Home » Developer & Programmer » Forms » FRM-40733 Error
FRM-40733 Error [message #314727] Thu, 17 April 2008 11:35 Go to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
I get this error. I dont understand why this problem occurs because I use SET_GROUP_CHAR_CELL, SET_GROUP_DATE_CELL and SET_GROUP_NUMBER_CELL Builtins and argument used in this BuiltIns correctly

Please Explain and Guide me what will be the cause of this error and what will be the solution
Re: FRM-40733 Error [message #314795 is a reply to message #314727] Thu, 17 April 2008 15:42 Go to previous messageGo to next message
Littlefoot
Messages: 20895
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Unfortunately, I can't help much. This is what Oracle says:
Quote:
FRM-40733: PL/SQL built-in %s failed.

Cause:  A fatal error occurred in Oracle Forms or in PL/SQL during trigger execution.

Action:  Notify the DBA.

Level:  >25

Type:  Error

Although you are quite sure that you've used these built-ins correctly, perhaps you could post them here (if possible) so that someone who is familiar with their use might take a look and, hopefully, suggest a solution.
Re: FRM-40733 Error [message #314824 is a reply to message #314727] Thu, 17 April 2008 23:18 Go to previous messageGo to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
declare
rg_id RecordGroup;
gc_id GroupColumn;

rg_col1 VARCHAR2(80) := 'rg_cont'||'.BATCH_NO';
rg_col2 VARCHAR2(80) := 'rg_cont'||'.TRAN_DATE';
rg_col3 VARCHAR2(80) := 'rg_cont'||'.LV4_CODE';

BEGIN
rg_id := Find_Group('rg_cont');

IF Id_Null(rg_id) THEN
rg_id := Create_Group('rg_cont');

gc_id := Add_Group_Column(rg_id, 'BATCH_NO',NUMBER_COLUMN,12); -- batchno
gc_id := Add_Group_Column(rg_id, 'TRAN_DATE', DATE_COLUMN,11); -- tran_dt
gc_id := Add_Group_Column(rg_id, 'LV4_CODE', NUMBER_COLUMN,6); -- lv4_code

Delete_Group_Row(rg_id, ALL_ROWS );
go_block('DET_LEDGER');
first_record;
loop
If :system.last_record <> 'TRUE' then
If :credit_amt > 0 then

Add_Group_Row(rg_id, END_OF_GROUP);

Set_Group_NUMBER_Cell(rg_col1,:system.cursor_record, :DET_LEDGER.BATCH_NO);
Set_Group_DATE_Cell(rg_col2,:system.cursor_record, :DET_LEDGER.TRAN_DATE);
Set_Group_NUMBER_Cell(rg_col3,:system.cursor_record, :DET_LEDGER.LV4_CODE);

next_record;
else
next_record;
end if;
else
if :lc3_code is null and :tran_date is not null then
exit;
elsif :lc3_code is not null and :tran_date is not null then
exit;
end if;
end if;
end loop;

So whats wrong with this code. It works fine when I pass credit amount > 0 in first record but it fails when I pass credit amount > 0 in second record.

Please reply its Urgent.

Re: FRM-40733 Error [message #314828 is a reply to message #314727] Thu, 17 April 2008 23:48 Go to previous messageGo to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
In previous reply in which I mentioned coding If I will use two record groups i-e- If credit > 0 then set_group_number_cell in first record group and if debit > 0 then set_group_number_cell
in second record group then please reply what will be the coding structure.

After adding of Set_Group_number_cell in my previous post I add parameter list and pass record group in report
Add_Parameter(pl_id,'q_1',DATA_PARAMETER,'rg_cont');
and execute report.

I think you guys understand the situation. Please help me in this matter
Re: FRM-40733 Error [message #315552 is a reply to message #314828] Mon, 21 April 2008 21:11 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
In which trigger are you trying to run this code?

David
Re: FRM-40733 Error [message #315690 is a reply to message #314727] Tue, 22 April 2008 07:36 Go to previous messageGo to next message
hasnainlakhani
Messages: 24
Registered: January 2007
Junior Member
I use the code in WHEN-BUTTON-PRESSED Trigger
Re: FRM-40733 Error [message #316698 is a reply to message #315690] Sun, 27 April 2008 20:20 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
declare
  rg_id     RecordGroup;
  gc_id     GroupColumn;
  rg_col1   VARCHAR2 (80) := 'rg_cont' || '.BATCH_NO';
  rg_col2   VARCHAR2 (80) := 'rg_cont' || '.TRAN_DATE';
  rg_col3   VARCHAR2 (80) := 'rg_cont' || '.LV4_CODE';
BEGIN
  rg_id  := Find_Group ('rg_cont');
  IF Id_Null (rg_id) THEN
    rg_id  := Create_Group ('rg_cont');
    gc_id  := Add_Group_Column (rg_id, 'BATCH_NO', NUMBER_COLUMN, 12);   -- batchno
    gc_id  := Add_Group_Column (rg_id, 'TRAN_DATE', DATE_COLUMN, 11);   -- tran_dt
    gc_id  := Add_Group_Column (rg_id, 'LV4_CODE', NUMBER_COLUMN, 6);   -- lv4_code
    Delete_Group_Row (rg_id, ALL_ROWS);
    go_block ('DET_LEDGER');
    first_record;
    loop
      If :system.last_record <> 'TRUE' then
        If :credit_amt > 0 then
          Add_Group_Row (rg_id, END_OF_GROUP);
          Set_Group_NUMBER_Cell (rg_col1,
                                 :system.cursor_record,
                                 :DET_LEDGER.BATCH_NO);
          Set_Group_DATE_Cell (rg_col2,
                               :system.cursor_record,
                               :DET_LEDGER.TRAN_DATE);
          Set_Group_NUMBER_Cell (rg_col3,
                                 :system.cursor_record,
                                 :DET_LEDGER.LV4_CODE);
          next_record;
        else
          next_record;
        end if;
      else
        if     :lc3_code is null
           and :tran_date is not null then
          exit;
        elsif     :lc3_code is not null
              and :tran_date is not null then
          exit;
        end if;
      end if;
    end loop;
  end if;
end;

Next time please post ALL the code. The last 'end if' and 'end' were missing.

Now that I have formatted the code it is easy to see that you have no logic when the group 'rg_cont' already exists.

David
Previous Topic: How to install Form builer 6i & report builder 6i
Next Topic: ORA:03115 error
Goto Forum:
  


Current Time: Mon Dec 05 23:55:56 CST 2016

Total time taken to generate the page: 0.12140 seconds