DBA Data[Home] [Help]

APPS.GMS_FC_SYS dependencies on GMS_ERROR_PKG

Line 147: gms_error_pkg.gms_debug('Start of create_burden_impacted_enc', 'C');

143: l_brdn_impacted_enc l_brdn_impacted_enc_tab;
144: begin
145:
146: if l_debug = 'Y' then
147: gms_error_pkg.gms_debug('Start of create_burden_impacted_enc', 'C');
148: end if;
149:
150: p_rows_inserted := 0;
151:

Line 153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');

149:
150: p_rows_inserted := 0;
151:
152: if l_debug = 'Y' then
153: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
154: end if;
155:
156: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
157: insert into gms_bc_packets (packet_id,

Line 286: gms_error_pkg.gms_debug('Batch size is: ' || l_profile_set_size, 'C');

282: l_profile_set_size := l_default_set_size;
283: end if;
284:
285: if l_debug = 'Y' then
286: gms_error_pkg.gms_debug('Batch size is: ' || l_profile_set_size, 'C');
287: end if;
288:
289: if p_enc_group is not null then -- added for bug:8232859
290: open brdn_impacted_enc1;

Line 312: gms_error_pkg.gms_debug('Processing ENC_ID: ' || l_brdn_impacted_enc(i).expenditure_item_id, 'C');

308: end if;
309: for i in 1..l_brdn_impacted_enc.count loop
310:
311: if l_debug = 'Y' then
312: gms_error_pkg.gms_debug('Processing ENC_ID: ' || l_brdn_impacted_enc(i).expenditure_item_id, 'C');
313: end if;
314:
315: --Create -ive ADL
316: select max(adl_line_num)

Line 345: gms_error_pkg.gms_debug('Creating -ive Line.', 'C');

341: --l_negative_ln_adl_tbl(i).burdenable_raw_cost := l_brdn_impacted_enc(i).burdenable_raw_cost * -1; --If we are putting this then take care of gms_award_exp_type_act_cost table.
342: l_negative_ln_adl_tbl(i).billable_flag := l_brdn_impacted_enc(i).billable_flag;
343:
344: if l_debug = 'Y' then
345: gms_error_pkg.gms_debug('Creating -ive Line.', 'C');
346: end if;
347:
348: --Create -ive ADL
349: gms_awards_dist_pkg.create_adls(l_negative_ln_adl_tbl(i));

Line 375: gms_error_pkg.gms_debug('Creating +ive Line.', 'C');

371: --l_positive_ln_adl_tbl(i).burdenable_raw_cost := l_brdn_impacted_enc(i).burdenable_raw_cost;
372: l_positive_ln_adl_tbl(i).billable_flag := l_brdn_impacted_enc(i).billable_flag;
373:
374: if l_debug = 'Y' then
375: gms_error_pkg.gms_debug('Creating +ive Line.', 'C');
376: end if;
377:
378: --Create +ive ADL
379: gms_awards_dist_pkg.create_adls(l_positive_ln_adl_tbl(i));

Line 382: gms_error_pkg.gms_debug('Updating reversed flag.', 'C');

378: --Create +ive ADL
379: gms_awards_dist_pkg.create_adls(l_positive_ln_adl_tbl(i));
380:
381: if l_debug = 'Y' then
382: gms_error_pkg.gms_debug('Updating reversed flag.', 'C');
383: end if;
384:
385: --Update reversed_flag on original line.
386: update gms_award_distributions

Line 394: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');

390: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num
391: and adl_status = 'A';
392:
393: if l_debug = 'Y' then
394: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
395: end if;
396:
397: --Insert into GMS_BC_PACKETS
398: insert into gms_bc_packets (packet_id,

Line 530: gms_error_pkg.gms_debug('Ending create_burden_impacted_enc.', 'C');

526: close brdn_impacted_enc2;
527: end if;
528:
529: if l_debug = 'Y' then
530: gms_error_pkg.gms_debug('Ending create_burden_impacted_enc.', 'C');
531: end if;
532:
533: end create_burden_impacted_enc;
534:

Line 745: gms_error_pkg.gms_debug('Encumbrance record count '||x_count,'C');

741: -- Bug 6761516 added 'BURDEN_RECALC'
742:
743: x_count := sql%rowcount;
744: IF L_DEBUG = 'Y' THEN
745: gms_error_pkg.gms_debug('Encumbrance record count '||x_count,'C');
746: END IF;
747:
748: --Bug 5726575
749: create_burden_impacted_enc(l_request_id,

Line 759: gms_error_pkg.gms_debug('Encumbrance record count after create_burden_impacted_enc: ' || x_count, 'C');

755: l_rows_inserted);
756: x_count := x_count + l_rows_inserted;
757:
758: IF L_DEBUG = 'Y' THEN
759: gms_error_pkg.gms_debug('Encumbrance record count after create_burden_impacted_enc: ' || x_count, 'C');
760: END IF;
761:
762: for records in cur_for_bvid_update
763: loop

Line 802: gms_error_pkg.gms_debug('load_enc_pkts - In When Others Exception','C');

798: COMMIT;
799: EXCEPTION
800: When others then
801: IF L_DEBUG = 'Y' THEN
802: gms_error_pkg.gms_debug('load_enc_pkts - In When Others Exception','C');
803: END IF;
804: RAISE;
805: END load_enc_pkts;
806:

Line 831: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');

827:
828:
829: BEGIN
830: IF L_DEBUG = 'Y' THEN
831: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
832: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
833: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
834: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
835: END IF;

Line 832: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');

828:
829: BEGIN
830: IF L_DEBUG = 'Y' THEN
831: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
832: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
833: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
834: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
835: END IF;
836:

Line 833: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');

829: BEGIN
830: IF L_DEBUG = 'Y' THEN
831: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
832: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
833: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
834: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
835: END IF;
836:
837:

Line 834: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');

830: IF L_DEBUG = 'Y' THEN
831: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
832: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
833: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
834: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
835: END IF;
836:
837:
838: -- Bug 1980810 : Added to set currency related global variables

Line 863: gms_error_pkg.gms_debug('Calling gms funds checker','C');

859:
860:
861: If x_count > 0 THEN
862: IF L_DEBUG = 'Y' THEN
863: gms_error_pkg.gms_debug('Calling gms funds checker','C');
864: END IF;
865:
866: If not GMS_FUNDS_CONTROL_PKG.GMS_FCK( l_sob_id,
867: x_packet_id,

Line 885: gms_error_pkg.gms_debug('exception x_count-'||x_count,'C');

881: End if ;
882:
883: End if ;
884: IF L_DEBUG = 'Y' THEN
885: gms_error_pkg.gms_debug('exception x_count-'||x_count,'C');
886: END IF;
887:
888: EXCEPTION
889: When others then