DBA Data[Home] [Help]

APPS.GMS_FC_SYS dependencies on GMS_ERROR_PKG

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

97: l_brdn_impacted_enc l_brdn_impacted_enc_tab;
98: begin
99:
100: if l_debug = 'Y' then
101: gms_error_pkg.gms_debug('Start of create_burden_impacted_enc', 'C');
102: end if;
103:
104: p_rows_inserted := 0;
105:

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

103:
104: p_rows_inserted := 0;
105:
106: if l_debug = 'Y' then
107: gms_error_pkg.gms_debug('Inserting into GMS_BC_PACKETS for the records which failed funds check previously.', 'C');
108: end if;
109:
110: --Inserting into GMS_BC_PACKETS for the records which failed funds check previously.
111: insert into gms_bc_packets (packet_id,

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

236: l_profile_set_size := l_default_set_size;
237: end if;
238:
239: if l_debug = 'Y' then
240: gms_error_pkg.gms_debug('Batch size is: ' || l_profile_set_size, 'C');
241: end if;
242:
243: open brdn_impacted_enc;
244:

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

252: end if;
253: for i in 1..l_brdn_impacted_enc.count loop
254:
255: if l_debug = 'Y' then
256: gms_error_pkg.gms_debug('Processing ENC_ID: ' || l_brdn_impacted_enc(i).expenditure_item_id, 'C');
257: end if;
258:
259: --Create -ive ADL
260: select max(adl_line_num)

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

285: --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.
286: l_negative_ln_adl_tbl(i).billable_flag := l_brdn_impacted_enc(i).billable_flag;
287:
288: if l_debug = 'Y' then
289: gms_error_pkg.gms_debug('Creating -ive Line.', 'C');
290: end if;
291:
292: --Create -ive ADL
293: gms_awards_dist_pkg.create_adls(l_negative_ln_adl_tbl(i));

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

315: --l_positive_ln_adl_tbl(i).burdenable_raw_cost := l_brdn_impacted_enc(i).burdenable_raw_cost;
316: l_positive_ln_adl_tbl(i).billable_flag := l_brdn_impacted_enc(i).billable_flag;
317:
318: if l_debug = 'Y' then
319: gms_error_pkg.gms_debug('Creating +ive Line.', 'C');
320: end if;
321:
322: --Create +ive ADL
323: gms_awards_dist_pkg.create_adls(l_positive_ln_adl_tbl(i));

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

322: --Create +ive ADL
323: gms_awards_dist_pkg.create_adls(l_positive_ln_adl_tbl(i));
324:
325: if l_debug = 'Y' then
326: gms_error_pkg.gms_debug('Updating reversed flag.', 'C');
327: end if;
328:
329: --Update reversed_flag on original line.
330: update gms_award_distributions

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

334: and adl_line_num = l_brdn_impacted_enc(i).adl_line_num
335: and adl_status = 'A';
336:
337: if l_debug = 'Y' then
338: gms_error_pkg.gms_debug('Inserting into gms_bc_packets.', 'C');
339: end if;
340:
341: --Insert into GMS_BC_PACKETS
342: insert into gms_bc_packets (packet_id,

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

466:
467: close brdn_impacted_enc;
468:
469: if l_debug = 'Y' then
470: gms_error_pkg.gms_debug('Ending create_burden_impacted_enc.', 'C');
471: end if;
472:
473: end create_burden_impacted_enc;
474:

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

648: -- Bug 6761516 added 'BURDEN_RECALC'
649:
650: x_count := sql%rowcount;
651: IF L_DEBUG = 'Y' THEN
652: gms_error_pkg.gms_debug('Encumbrance record count '||x_count,'C');
653: END IF;
654:
655: --Bug 5726575
656: create_burden_impacted_enc(l_request_id,

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

662: l_rows_inserted);
663: x_count := x_count + l_rows_inserted;
664:
665: IF L_DEBUG = 'Y' THEN
666: gms_error_pkg.gms_debug('Encumbrance record count after create_burden_impacted_enc: ' || x_count, 'C');
667: END IF;
668:
669: for records in cur_for_bvid_update
670: loop

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

705: COMMIT;
706: EXCEPTION
707: When others then
708: IF L_DEBUG = 'Y' THEN
709: gms_error_pkg.gms_debug('load_enc_pkts - In When Others Exception','C');
710: END IF;
711: RAISE;
712: END load_enc_pkts;
713:

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

734:
735:
736: BEGIN
737: IF L_DEBUG = 'Y' THEN
738: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
739: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
740: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
741: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
742: END IF;

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

735:
736: BEGIN
737: IF L_DEBUG = 'Y' THEN
738: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
739: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
740: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
741: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
742: END IF;
743:

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

736: BEGIN
737: IF L_DEBUG = 'Y' THEN
738: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
739: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
740: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
741: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
742: END IF;
743:
744:

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

737: IF L_DEBUG = 'Y' THEN
738: gms_error_pkg.gms_debug('****project***'||p_project_id,'C');
739: gms_error_pkg.gms_debug('****exp group***'||p_enc_group,'C');
740: gms_error_pkg.gms_debug('****end date***'||p_end_date,'C');
741: gms_error_pkg.gms_debug('****org id***'||p_org_id,'C');
742: END IF;
743:
744:
745: -- Bug 1980810 : Added to set currency related global variables

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

766:
767:
768: If x_count > 0 THEN
769: IF L_DEBUG = 'Y' THEN
770: gms_error_pkg.gms_debug('Calling gms funds checker','C');
771: END IF;
772:
773: If not GMS_FUNDS_CONTROL_PKG.GMS_FCK( l_sob_id,
774: x_packet_id,

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

788: End if ;
789:
790: End if ;
791: IF L_DEBUG = 'Y' THEN
792: gms_error_pkg.gms_debug('exception x_count-'||x_count,'C');
793: END IF;
794:
795: EXCEPTION
796: When others then