eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_SWEEPER dependencies on GMS_ERROR_PKG

Line 102: gms_error_pkg.gms_debug(l_procedure_name||'Start','C');

98: p_error_code := null;
99:
100: l_procedure_name := 'RECORD_BURDEN_AMOUNTS:';
101: IF L_DEBUG = 'Y' THEN
102: gms_error_pkg.gms_debug(l_procedure_name||'Start','C');
103: END IF;
104:
105: If l_plsql_counter > 0 then -- I
106: For x in 1..l_plsql_counter

Line 192: gms_error_pkg.gms_debug(l_procedure_name||'End','C');

188: null;
189: End If; -- I
190: -- l_posted_flag := 'Y';
191: IF L_DEBUG = 'Y' THEN
192: gms_error_pkg.gms_debug(l_procedure_name||'End','C');
193: END IF;
194:
195: Exception
196: When others then

Line 198: gms_error_pkg.gms_debug(l_procedure_name||SQLERRM,'C');

194:
195: Exception
196: When others then
197: IF L_DEBUG = 'Y' THEN
198: gms_error_pkg.gms_debug(l_procedure_name||SQLERRM,'C');
199: END IF;
200: p_error_code := 'E';
201: End Record_burden_amounts;
202:

Line 218: gms_error_pkg.gms_debug(l_procedure_name||'Start','C');

214: Begin
215: p_error_code := null;
216: l_procedure_name := 'POST_BURDEN_AMOUNTS:';
217: IF L_DEBUG = 'Y' THEN
218: gms_error_pkg.gms_debug(l_procedure_name||'Start','C');
219: END IF;
220:
221: -- 1. Get gms_bc_packet records for burdne posting
222: For x in 1..p_plsql_count

Line 285: gms_error_pkg.gms_debug(l_procedure_name||'End','C');

281:
282: End Loop;
283:
284: IF L_DEBUG = 'Y' THEN
285: gms_error_pkg.gms_debug(l_procedure_name||'End','C');
286: END IF;
287: Exception
288: When others then
289: IF L_DEBUG = 'Y' THEN

Line 290: gms_error_pkg.gms_debug(l_procedure_name||SQLERRM,'C');

286: END IF;
287: Exception
288: When others then
289: IF L_DEBUG = 'Y' THEN
290: gms_error_pkg.gms_debug(l_procedure_name||SQLERRM,'C');
291: END IF;
292: p_error_code := 'E';
293: End Post_burden_amounts;
294: ----------------------------------------------------------------------------------------

Line 375: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',

371: Exception
372:
373: When Others then
374:
375: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',
376: x_token_name1 => 'PROGRAM_NAME',
377: x_token_val1 => l_stage,
378: x_token_name2 => 'SQLCODE',
379: x_token_val2 => SQLCODE,

Line 511: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',

507: End if; --IF x_time_phased_type_code = 'R' THEN
508:
509: EXCEPTION
510: WHEN OTHERS THEN
511: gms_error_pkg.gms_message ( x_err_name=> 'GMS_UNEXPECTED_ERROR',
512: x_token_name1 => 'PROGRAM_NAME',
513: x_token_val1 => x_error_procedure_name||'.'||x_error_stage,
514: x_token_name2 => 'SQLCODE',
515: x_token_val2 => SQLCODE,

Line 652: gms_error_pkg.gms_output('---------- Records that Errored Out NOCOPY -----------');

648:
649: l_rec := err_table.COUNT;
650:
651: --fnd_file.put_line(FND_FILE.OUTPUT,'---------- Records that Errored Out NOCOPY -----------');
652: gms_error_pkg.gms_output('---------- Records that Errored Out NOCOPY -----------');
653:
654: for l_records in 1..l_rec
655: loop
656:

Line 657: gms_error_pkg.gms_output('----- Record Number: '||l_records||' ----');

653:
654: for l_records in 1..l_rec
655: loop
656:
657: gms_error_pkg.gms_output('----- Record Number: '||l_records||' ----');
658: gms_error_pkg.gms_output('---- Record -----');
659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);

Line 658: gms_error_pkg.gms_output('---- Record -----');

654: for l_records in 1..l_rec
655: loop
656:
657: gms_error_pkg.gms_output('----- Record Number: '||l_records||' ----');
658: gms_error_pkg.gms_output('---- Record -----');
659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);

Line 660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);

656:
657: gms_error_pkg.gms_output('----- Record Number: '||l_records||' ----');
658: gms_error_pkg.gms_output('---- Record -----');
659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);

Line 661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);

657: gms_error_pkg.gms_output('----- Record Number: '||l_records||' ----');
658: gms_error_pkg.gms_output('---- Record -----');
659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);

Line 662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);

658: gms_error_pkg.gms_output('---- Record -----');
659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);

Line 663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);

659:
660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:

Line 664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);

660: gms_error_pkg.gms_output('Expenditure_item_id :'||Err_table(l_records).exp_item_id);
661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');

Line 665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);

661: gms_error_pkg.gms_output('Adl Line num :'||Err_table(l_records).adl);
662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);

Line 666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);

662: gms_error_pkg.gms_output('Award_id :'||Err_table(l_records).award_id);
663: gms_error_pkg.gms_output('Project_Id :'||Err_table(l_records).project_id);
664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);

Line 668: gms_error_pkg.gms_output('---- Record Details ----');

664: gms_error_pkg.gms_output('Task_id :'||Err_table(l_records).task_id);
665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);

Line 669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);

665: gms_error_pkg.gms_output('Amount :'||Err_table(l_records).amount);
666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);

Line 670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);

666: gms_error_pkg.gms_output('Reason :'||Err_table(l_records).reason);
667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);

Line 671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);

667:
668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);

Line 672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);

668: gms_error_pkg.gms_output('---- Record Details ----');
669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);

Line 673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);

669: gms_error_pkg.gms_output('Person Id :'||Res_table(l_records).Person_Id);
670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);

Line 674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);

670: gms_error_pkg.gms_output('Job Id :'||Res_table(l_records).Job_id);
671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);

Line 675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);

671: gms_error_pkg.gms_output('Org_Id :'||Res_table(l_records).org_id);
672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);

Line 676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);

672: gms_error_pkg.gms_output('Expenditure_type :'||Res_table(l_records).expenditure_type);
673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);

Line 677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);

673: gms_error_pkg.gms_output('Non Labor resource :'||Res_table(l_records).nlr);
674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);

Line 678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);

674: gms_error_pkg.gms_output('Expenditure Category :'||Res_table(l_records).exp_category);
675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);

Line 679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);

675: gms_error_pkg.gms_output('Revenue Category :'||Res_table(l_records).rev_category);
676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');

Line 680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);

676: gms_error_pkg.gms_output('Non Labor resource Org Id :'||Res_table(l_records).nlr_org_id);
677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');
684: end loop;

Line 681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);

677: gms_error_pkg.gms_output('System Linkage :'||Res_table(l_records).sys_link);
678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');
684: end loop;
685:

Line 682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);

678: gms_error_pkg.gms_output('Expenditure Date :'||Res_table(l_records).exp_date);
679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');
684: end loop;
685:
686: gms_error_pkg.gms_output('---- End Report ----');

Line 683: gms_error_pkg.gms_output('--------------------------------------------------');

679: gms_error_pkg.gms_output('Budget Version :'||Res_table(l_records).bvid);
680: gms_error_pkg.gms_output('Budgeted Task :'||Res_table(l_records).bud_task);
681: gms_error_pkg.gms_output('Categorization Code :'||Res_table(l_records).cat_code);
682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');
684: end loop;
685:
686: gms_error_pkg.gms_output('---- End Report ----');
687:

Line 686: gms_error_pkg.gms_output('---- End Report ----');

682: gms_error_pkg.gms_output('Time Phase code :'||Res_table(l_records).tp_code);
683: gms_error_pkg.gms_output('--------------------------------------------------');
684: end loop;
685:
686: gms_error_pkg.gms_output('---- End Report ----');
687:
688: End;
689:
690: --------------------------------------------------------------------

Line 1062: gms_error_pkg.gms_debug('No processing','C');

1058: If x_budget_version_id is null then
1059:
1060: GOTO NO_PROCESS1;
1061: IF L_DEBUG = 'Y' THEN
1062: gms_error_pkg.gms_debug('No processing','C');
1063: END IF;
1064:
1065: End if;
1066:

Line 1068: gms_error_pkg.gms_debug('Project_id, Award_id, Budget_version_id:'||l_project_id_tbl(i)||','||l_award_id_tbl(i)||','||x_budget_version_id,'C');

1064:
1065: End if;
1066:
1067: IF L_DEBUG = 'Y' THEN
1068: gms_error_pkg.gms_debug('Project_id, Award_id, Budget_version_id:'||l_project_id_tbl(i)||','||l_award_id_tbl(i)||','||x_budget_version_id,'C');
1069: END IF;
1070:
1071: -- 3. Initialize revenue records
1072:

Line 1102: gms_error_pkg.gms_debug('Amount_type,Boundary_code:'|| x_amount_type||','||x_boundary_code,'C');

1098: -- Will call main exception
1099: End;
1100:
1101: IF L_DEBUG = 'Y' THEN
1102: gms_error_pkg.gms_debug('Amount_type,Boundary_code:'|| x_amount_type||','||x_boundary_code,'C');
1103: END IF;
1104:
1105: -- 5. Get Resource List Id and Categorization Code
1106:

Line 1159: gms_error_pkg.gms_debug('Expenditure_item_id,Adl_line_Num:'||l_ei_id_tbl(i)||','||l_adl_ln_num_id_tbl(i),'C');

1155: /*for rev_gen in gms_rev
1156: loop */ /* commented for the bug 5481465 */
1157:
1158: IF L_DEBUG = 'Y' THEN
1159: gms_error_pkg.gms_debug('Expenditure_item_id,Adl_line_Num:'||l_ei_id_tbl(i)||','||l_adl_ln_num_id_tbl(i),'C');
1160: gms_error_pkg.gms_debug('Amount,Table:'||l_amount_tbl(i)||','||l_fr_tab_tbl(i),'C');
1161: END IF;
1162:
1163: x_stage :='Get Set of Books Id';

Line 1160: gms_error_pkg.gms_debug('Amount,Table:'||l_amount_tbl(i)||','||l_fr_tab_tbl(i),'C');

1156: loop */ /* commented for the bug 5481465 */
1157:
1158: IF L_DEBUG = 'Y' THEN
1159: gms_error_pkg.gms_debug('Expenditure_item_id,Adl_line_Num:'||l_ei_id_tbl(i)||','||l_adl_ln_num_id_tbl(i),'C');
1160: gms_error_pkg.gms_debug('Amount,Table:'||l_amount_tbl(i)||','||l_fr_tab_tbl(i),'C');
1161: END IF;
1162:
1163: x_stage :='Get Set of Books Id';
1164: x_set_of_books_id := p_sob_id;

Line 1205: gms_error_pkg.gms_debug('RLMI :'||x_resource_list_member_id,'C');

1201:
1202: End if; --if x_categorization_code = .....
1203:
1204: IF L_DEBUG = 'Y' THEN
1205: gms_error_pkg.gms_debug('RLMI :'||x_resource_list_member_id,'C');
1206: END IF;
1207:
1208: if x_resource_list_member_id is null then
1209:

Line 1257: gms_error_pkg.gms_debug('No Balance Line Updated','C');

1253:
1254: IF (SQL%NOTFOUND) THEN
1255:
1256: IF L_DEBUG = 'Y' THEN
1257: gms_error_pkg.gms_debug('No Balance Line Updated','C');
1258: END IF;
1259:
1260: -- 4d. Calculate Start and End date.
1261:

Line 1393: gms_error_pkg.gms_debug('After Balance Line Insert','C');

1389: ,l_amount_tbl(i) --rev_gen.amount
1390: );
1391:
1392: IF L_DEBUG = 'Y' THEN
1393: gms_error_pkg.gms_debug('After Balance Line Insert','C');
1394: END IF;
1395: end if;
1396:
1397: x_stage:='Updating revenue records';

Line 1464: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',

1460: <>
1461: NULL;
1462: exception
1463: when others then
1464: gms_error_pkg.gms_message('GMS_UNEXPECTED_ERROR',
1465: 'SQLCODE',
1466: SQLCODE,
1467: 'SQLERRM',
1468: SQLERRM,

Line 1483: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024

1479: -- MAIN BEGIN STARTS HERE ---
1480:
1481: BEGIN
1482:
1483: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
1484:
1485: -- Initialize error tables
1486: upd_error_table.delete;
1487: upd_reason_table.delete;

Line 1496: gms_error_pkg.gms_debug('---------- Budget Balance Process Starts ----','C');

1492: x_status_code := 'A';
1493: end if;
1494:
1495: IF L_DEBUG = 'Y' THEN
1496: gms_error_pkg.gms_debug('---------- Budget Balance Process Starts ----','C');
1497:
1498: gms_error_pkg.gms_debug('Baselining for Project_ID :'||x_project_id,'C');
1499: gms_error_pkg.gms_debug('Baselining for Award_ID :'||x_award_id,'C');
1500:

Line 1498: gms_error_pkg.gms_debug('Baselining for Project_ID :'||x_project_id,'C');

1494:
1495: IF L_DEBUG = 'Y' THEN
1496: gms_error_pkg.gms_debug('---------- Budget Balance Process Starts ----','C');
1497:
1498: gms_error_pkg.gms_debug('Baselining for Project_ID :'||x_project_id,'C');
1499: gms_error_pkg.gms_debug('Baselining for Award_ID :'||x_award_id,'C');
1500:
1501: END IF;
1502:

Line 1499: gms_error_pkg.gms_debug('Baselining for Award_ID :'||x_award_id,'C');

1495: IF L_DEBUG = 'Y' THEN
1496: gms_error_pkg.gms_debug('---------- Budget Balance Process Starts ----','C');
1497:
1498: gms_error_pkg.gms_debug('Baselining for Project_ID :'||x_project_id,'C');
1499: gms_error_pkg.gms_debug('Baselining for Award_ID :'||x_award_id,'C');
1500:
1501: END IF;
1502:
1503: --Bug 4732065 : Shifted the code to fetch set of books id as part of Main cursors

Line 1514: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have NULL value','C');

1510: FND_PROFILE.GET('GMS_PURGE_FUNDS_CHECK_RESULTS', l_offset_days);
1511:
1512: IF l_offset_days IS NULL THEN
1513: IF L_DEBUG = 'Y' THEN
1514: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have NULL value','C');
1515: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1516: END IF;
1517: l_offset_days :=3 ;
1518: ELSIF (l_offset_days < 1 ) THEN

Line 1515: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');

1511:
1512: IF l_offset_days IS NULL THEN
1513: IF L_DEBUG = 'Y' THEN
1514: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have NULL value','C');
1515: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1516: END IF;
1517: l_offset_days :=3 ;
1518: ELSIF (l_offset_days < 1 ) THEN
1519: IF L_DEBUG = 'Y' THEN

Line 1520: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have value '||l_offset_days||' which is less than 1','C');

1516: END IF;
1517: l_offset_days :=3 ;
1518: ELSIF (l_offset_days < 1 ) THEN
1519: IF L_DEBUG = 'Y' THEN
1520: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have value '||l_offset_days||' which is less than 1','C');
1521: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1522: END IF;
1523: l_offset_days :=3 ;
1524:

Line 1521: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');

1517: l_offset_days :=3 ;
1518: ELSIF (l_offset_days < 1 ) THEN
1519: IF L_DEBUG = 'Y' THEN
1520: gms_error_pkg.gms_debug('Profile GMS_PURGE_FUNDS_CHECK_RESULTS cannot have value '||l_offset_days||' which is less than 1','C');
1521: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1522: END IF;
1523: l_offset_days :=3 ;
1524:
1525: END IF;

Line 1530: gms_error_pkg.gms_debug('Invalid character type value is assigned to Profile GMS_PURGE_FUNDS_CHECK_RESULTS',

1526:
1527: Exception
1528: When value_error then
1529: IF L_DEBUG = 'Y' THEN
1530: gms_error_pkg.gms_debug('Invalid character type value is assigned to Profile GMS_PURGE_FUNDS_CHECK_RESULTS',
1531: 'C');
1532: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1533: END IF;
1534: l_offset_days :=3;

Line 1532: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');

1528: When value_error then
1529: IF L_DEBUG = 'Y' THEN
1530: gms_error_pkg.gms_debug('Invalid character type value is assigned to Profile GMS_PURGE_FUNDS_CHECK_RESULTS',
1531: 'C');
1532: gms_error_pkg.gms_debug('Defaulting the value of GMS_PURGE_FUNDS_CHECK_RESULTS profile to 3','C');
1533: END IF;
1534: l_offset_days :=3;
1535: END;
1536:

Line 1549: gms_error_pkg.gms_debug('Deleting old records from GMS','C');

1545:
1546: ---------------------------------------------------------------------------------- +
1547: x_stage := '100'; -- Delete old records from gms_bc_packets
1548: IF L_DEBUG = 'Y' THEN
1549: gms_error_pkg.gms_debug('Deleting old records from GMS','C');
1550: END IF;
1551:
1552: -- Bug 2155790 : Removed the trunc function and replaced 3 with l_offset_days
1553: delete from gms_bc_packets

Line 1568: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');

1564:
1565: ---------------------------------------------------------------------------------- +
1566: x_stage := '200'; -- Delete from gms_bc_packet_arrival_order
1567: IF L_DEBUG = 'Y' THEN
1568: gms_error_pkg.gms_debug('Deleting records from arrival order table','C');
1569: END IF;
1570:
1571: DELETE gms_bc_packet_arrival_order ao
1572: WHERE NOT EXISTS (

Line 1583: gms_error_pkg.gms_debug('Deleting transactions left in pending state','C');

1579:
1580: ---------------------------------------------------------------------------------- +
1581: x_stage := '250'; -- delete transactions left in pending state
1582: IF L_DEBUG = 'Y' THEN
1583: gms_error_pkg.gms_debug('Deleting transactions left in pending state','C');
1584: END IF;
1585:
1586: gms_funds_control_pkg.delete_pending_txns(retcode,errbuf);
1587: -- Note: Above mentioned procedure will not handle exception , so if there is any error

Line 1605: gms_error_pkg.gms_debug('Start Loop for Updation','C');

1601: -- Bug 4053891 Ends
1602:
1603: x_stage := '300'; -- Before loop of gms_bc_packet
1604: IF L_DEBUG = 'Y' THEN
1605: gms_error_pkg.gms_debug('Start Loop for Updation','C');
1606: gms_error_pkg.gms_debug('----------------------------------------------','C');
1607: END IF;
1608:
1609: FOR rec_gms_packets IN c_gms_packets(x_status_code) --Added parameter to fix bug 2138376

Line 1606: gms_error_pkg.gms_debug('----------------------------------------------','C');

1602:
1603: x_stage := '300'; -- Before loop of gms_bc_packet
1604: IF L_DEBUG = 'Y' THEN
1605: gms_error_pkg.gms_debug('Start Loop for Updation','C');
1606: gms_error_pkg.gms_debug('----------------------------------------------','C');
1607: END IF;
1608:
1609: FOR rec_gms_packets IN c_gms_packets(x_status_code) --Added parameter to fix bug 2138376
1610: LOOP

Line 1626: gms_error_pkg.gms_debug('Check if burden to be posted','C');

1622: -- * Update gms_bc_packets
1623: ---------------------------------------------------------------------------------- +
1624: x_stage := '325';
1625: IF L_DEBUG = 'Y' THEN
1626: gms_error_pkg.gms_debug('Check if burden to be posted','C');
1627: END IF;
1628:
1629: If x_mode <> 'B' then
1630: If (x_loop_counter = 100 or

Line 1647: gms_error_pkg.gms_debug('Posting burden for bvid:'||x_old_budget_version_id,'C');

1643: If x_plsql_count > 0 then
1644:
1645: x_stage := '350';
1646: IF L_DEBUG = 'Y' THEN
1647: gms_error_pkg.gms_debug('Posting burden for bvid:'||x_old_budget_version_id,'C');
1648: END IF;
1649:
1650: POST_BURDEN_AMOUNTS(x_plsql_count,Tab_Award_exp_burden,x_err_code);
1651:

Line 1655: gms_error_pkg.gms_debug('Error Code after posting burden(E->Failure):'||x_err_code,'C');

1651:
1652: If x_err_code = 'E' then
1653:
1654: IF L_DEBUG = 'Y' THEN
1655: gms_error_pkg.gms_debug('Error Code after posting burden(E->Failure):'||x_err_code,'C');
1656: END IF;
1657:
1658: ROLLBACK to SAVEPOINT A;
1659: If Tab_Award_exp_burden.exists(1) then

Line 1667: gms_error_pkg.gms_debug('Burden posted for bvid:'||x_old_budget_version_id,'C');

1663:
1664: End If;
1665:
1666: IF L_DEBUG = 'Y' THEN
1667: gms_error_pkg.gms_debug('Burden posted for bvid:'||x_old_budget_version_id,'C');
1668: END IF;
1669:
1670: End If; --If x_plsql_count > 0 then
1671:

Line 1693: gms_error_pkg.gms_debug('Recording burden','C');

1689: x_loop_counter := x_loop_counter + 1;
1690:
1691: x_stage := '360';
1692: IF L_DEBUG = 'Y' THEN
1693: gms_error_pkg.gms_debug('Recording burden','C');
1694: END IF;
1695:
1696: -- Record Burden amounts
1697: If ((rec_gms_packets.burden_adjustment_flag = 'N' and

Line 1722: gms_error_pkg.gms_debug('Burden recording failed for bvid,award_id,expenditure type,doc_type:'||

1718: Tab_Award_exp_burden,
1719: x_err_code);
1720: If x_err_code = 'E' then
1721: IF L_DEBUG = 'Y' THEN
1722: gms_error_pkg.gms_debug('Burden recording failed for bvid,award_id,expenditure type,doc_type:'||
1723: rec_gms_packets.budget_version_id||','||rec_gms_packets.award_id||
1724: ','||rec_gms_packets.expenditure_type||','||
1725: rec_gms_packets.document_type,'C');
1726: END IF;

Line 1739: gms_error_pkg.gms_debug('----------------------------------------------','C');

1735:
1736:
1737: x_stage := '400'; -- Update GMS_BALANCES record
1738: IF L_DEBUG = 'Y' THEN
1739: gms_error_pkg.gms_debug('----------------------------------------------','C');
1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');

Line 1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');

1736:
1737: x_stage := '400'; -- Update GMS_BALANCES record
1738: IF L_DEBUG = 'Y' THEN
1739: gms_error_pkg.gms_debug('----------------------------------------------','C');
1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');

Line 1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');

1737: x_stage := '400'; -- Update GMS_BALANCES record
1738: IF L_DEBUG = 'Y' THEN
1739: gms_error_pkg.gms_debug('----------------------------------------------','C');
1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');

Line 1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');

1738: IF L_DEBUG = 'Y' THEN
1739: gms_error_pkg.gms_debug('----------------------------------------------','C');
1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');
1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');

Line 1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');

1739: gms_error_pkg.gms_debug('----------------------------------------------','C');
1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');
1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');
1747: END IF;

Line 1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');

1740: gms_error_pkg.gms_debug('Expenditure --> '||to_char(rec_gms_packets.document_header_id),'C');
1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');
1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');
1747: END IF;
1748:

Line 1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');

1741: gms_error_pkg.gms_debug('Adl --> '||to_char(rec_gms_packets.document_distribution_id),'C');
1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');
1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');
1747: END IF;
1748:
1749:

Line 1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');

1742: gms_error_pkg.gms_debug('Award --> '||to_char(rec_gms_packets.award_id),'C');
1743: gms_error_pkg.gms_debug('Project --> '||to_char(rec_gms_packets.project_id),'C');
1744: gms_error_pkg.gms_debug('Task --> '||to_char(rec_gms_packets.task_id),'C');
1745: gms_error_pkg.gms_debug('Budget Version --> '||to_char(rec_gms_packets.budget_version_id),'C');
1746: gms_error_pkg.gms_debug('Document --> '||rec_gms_packets.document_type,'C');
1747: END IF;
1748:
1749:
1750: /* Bug 5956576: Base Bug 5956576 - Changes start */

Line 2026: gms_error_pkg.gms_debug('Stage:'||x_stage||';'||substr(sqlerrm,1,255),'C');

2022:
2023: EXCEPTION
2024: When others then
2025: IF L_DEBUG = 'Y' THEN
2026: gms_error_pkg.gms_debug('Stage:'||x_stage||';'||substr(sqlerrm,1,255),'C');
2027: END IF;
2028: If x_mode <> 'B' then
2029: ROLLBACK TO SAVEPOINT A;
2030: -- If Sweeper then rollback and continue

Line 2078: gms_error_pkg.gms_debug('Calling Revenue Updation','C');

2074: -- Moved Revenue posting to after actuals ...bug 3487431
2075:
2076: -- Call update_revenue_balance.
2077: IF L_DEBUG = 'Y' THEN
2078: gms_error_pkg.gms_debug('Calling Revenue Updation','C');
2079: gms_error_pkg.gms_debug('Mode passed for revenue updation '||x_mode,'C');
2080: END IF;
2081:
2082: -- Bug 2138376 : Modify the following code

Line 2079: gms_error_pkg.gms_debug('Mode passed for revenue updation '||x_mode,'C');

2075:
2076: -- Call update_revenue_balance.
2077: IF L_DEBUG = 'Y' THEN
2078: gms_error_pkg.gms_debug('Calling Revenue Updation','C');
2079: gms_error_pkg.gms_debug('Mode passed for revenue updation '||x_mode,'C');
2080: END IF;
2081:
2082: -- Bug 2138376 : Modify the following code
2083: -- If called from Baselining process consider records with status 'B' else

Line 2123: gms_error_pkg.gms_debug('Revenue Updation Completed','C');

2119:
2120: end if;
2121:
2122: IF L_DEBUG = 'Y' THEN
2123: gms_error_pkg.gms_debug('Revenue Updation Completed','C');
2124: END IF;
2125:
2126: -- ...bug 3487431 end.
2127: