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_FUNDS_CONTROL_PKG dependencies on GMS_ERROR_PKG

Line 179: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage,'C');

175:
176: l_request_id := fnd_global.conc_request_id;
177:
178: IF g_debug = 'Y' THEN
179: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage,'C');
180: END IF;
181:
182: For c_request_id in c_pending_request_id
183: Loop

Line 199: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage||' - request_id,phase_code:'||

195: l_phase_code := 'C';
196: End;
197:
198: IF g_debug = 'Y' THEN
199: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage||' - request_id,phase_code:'||
200: c_request_id.request_id||','||l_phase_code,'C');
201: END IF;
202:
203: -- Phase Code 'C' indicates that the process has been completed

Line 227: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage,'C');

223:
224: g_error_stage := ':End';
225:
226: IF g_debug = 'Y' THEN
227: gms_error_pkg.gms_debug (g_error_procedure_name||g_error_stage,'C');
228: END IF;
229:
230: Exception
231: -- Handling exception, as any failure to this procedure need not fail the calling process

Line 415: gms_error_pkg.gms_debug ('Check for related invoice failure', 'C');

411:
412: If p_level in ('AWD','ALL') then
413:
414: IF g_debug = 'Y' THEN
415: gms_error_pkg.gms_debug ('Check for related invoice failure', 'C');
416: END IF;
417:
418: l_dummy := 0;
419: Begin

Line 434: gms_error_pkg.gms_debug ('Check for related invoice failure, if exists then l_dummy = 1): l_dummy::'||l_dummy, 'C');

430: null;
431: End;
432:
433: IF g_debug = 'Y' THEN
434: gms_error_pkg.gms_debug ('Check for related invoice failure, if exists then l_dummy = 1): l_dummy::'||l_dummy, 'C');
435: END IF;
436:
437:
438: If l_dummy = 1 then

Line 461: gms_error_pkg.gms_debug (SQL%rowcount||' records updated','C');

457: and COALESCE(b.charge_applicable_to_dist_id,b.related_id,b.invoice_distribution_id) =
458: COALESCE(a.charge_applicable_to_dist_id,a.related_id,a.invoice_distribution_id));
459:
460: IF g_debug = 'Y' THEN
461: gms_error_pkg.gms_debug (SQL%rowcount||' records updated','C');
462: END IF;
463:
464: End If;
465:

Line 598: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : Start','C');

594: Begin
595: g_error_procedure_name := 'Handle_net_zero_txn' ;
596: g_error_stage := 'Net Zero - ENC';
597:
598: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : Start','C');
599: gms_error_pkg.gms_debug ( 'p_mode : '||p_mode,'C');
600:
601: If p_mode = 'Check_Adjusted' then
602: -- Fail adjusting txn. If adjusted has not been funds checked -F08

Line 599: gms_error_pkg.gms_debug ( 'p_mode : '||p_mode,'C');

595: g_error_procedure_name := 'Handle_net_zero_txn' ;
596: g_error_stage := 'Net Zero - ENC';
597:
598: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : Start','C');
599: gms_error_pkg.gms_debug ( 'p_mode : '||p_mode,'C');
600:
601: If p_mode = 'Check_Adjusted' then
602: -- Fail adjusting txn. If adjusted has not been funds checked -F08
603: update gms_bc_packets gbc

Line 642: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : End','C');

638: and nvl(ind_compiled_set_id,-1) = recs.ind_compiled_set_id;
639:
640: g_bc_packet_has_P82_records := 'Y' ;
641: end loop;
642: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : End','C');
643:
644: End If;
645:
646: COMMIT;

Line 673: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : Start','C');

669: t_exp_org t_exp_org_type;
670: t_ind_set t_ind_set_type;
671:
672: Begin
673: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : Start','C');
674:
675: -- This part of the code will take care of non-net zero encumbrance items or
676: -- the original (adjusted) net zero item
677:

Line 752: gms_error_pkg.gms_debug ( 'After Bulk processing','C');

748: adjusted_document_header_id = document_header_id);
749:
750: End If; --If t_project_id.COUNT > 0 then
751:
752: gms_error_pkg.gms_debug ( 'After Bulk processing','C');
753: -- =============================================================
754: -- This part of the code will take care of the reversing (adjusting) net zero item
755: -- =============================================================
756:

Line 780: gms_error_pkg.gms_debug ( 'After Update 1','C');

776: and gbc.adjusted_document_header_id is not NULL
777: and nvl(gbc.burden_adjustment_flag,'N') = 'N' -- 3389292
778: and gbc.adjusted_document_header_id <> gbc.document_header_id;
779:
780: gms_error_pkg.gms_debug ( 'After Update 1','C');
781: -- Bug#6075039 Modified the sub query for performance issue.
782: -- Update 2 : For Adjusting (Reversing) transactions whose original transaction
783: -- was funds checked earlier
784: Update gms_bc_packets gbc

Line 803: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : End','C');

799: and gbc.adjusted_document_header_id is not NULL
800: and nvl(gbc.burden_adjustment_flag,'N') = 'N' -- 3389292
801: and gbc.adjusted_document_header_id <> gbc.document_header_id;
802:
803: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : End','C');
804:
805: COMMIT;
806:
807: End Calc_enc_ind_compiled_set_id;

Line 951: gms_error_pkg.gms_debug ( 'STATUS_CODE_UPDATE - START ','C');

947: BEGIN
948: g_error_procedure_name := 'status_code_update';
949: g_error_stage := 'SCU : START';
950: IF g_debug = 'Y' THEN
951: gms_error_pkg.gms_debug ( 'STATUS_CODE_UPDATE - START ','C');
952: END IF;
953:
954: If g_partial_flag = 'N' then
955:

Line 987: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - SUBMIT UPDATE FOR PASS TRANSACTIONS', 'C');

983: UPDATE gms_bc_packets
984: SET status_code = decode(p_mode,'S','S','B','B','C','C','A')
985: WHERE packet_id = p_packet_id;
986: IF g_debug = 'Y' THEN
987: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - SUBMIT UPDATE FOR PASS TRANSACTIONS', 'C');
988: END IF;
989: END IF;
990: CLOSE c_failed_packet;
991: -- -------------------------------- PARTIAL MODE START ---------------------------------------------+

Line 1004: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED IN PARTIAL MODE', 'C');

1000: WHERE packet_id = p_packet_id;
1001:
1002: IF SQL%NOTFOUND THEN
1003: IF g_debug = 'Y' THEN
1004: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED IN PARTIAL MODE', 'C');
1005: END IF;
1006: END IF;
1007: g_error_stage := 'SCU : PARTIAL YES RES';
1008:

Line 1011: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED ', 'C');

1007: g_error_stage := 'SCU : PARTIAL YES RES';
1008:
1009: ELSE
1010: IF g_debug = 'Y' THEN
1011: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED ', 'C');
1012: END IF;
1013: END IF;
1014:
1015: -- --------------------------------------------------------------------------------------------------+

Line 1247: gms_error_pkg.gms_debug ('BEGIN result_status_code_update', 'C');

1243: x_err_code NUMBER;
1244: x_err_buff VARCHAR2 (2000);
1245: BEGIN
1246: IF g_debug = 'Y' THEN
1247: gms_error_pkg.gms_debug ('BEGIN result_status_code_update', 'C');
1248: END IF;
1249: g_error_procedure_name := 'result_status_code_update' ;
1250:
1251: IF p_bc_packet_id is NULL THEN

Line 1272: gms_error_pkg.gms_debug ('END result_status_code_update', 'C');

1268:
1269: END IF;
1270:
1271: IF g_debug = 'Y' THEN
1272: gms_error_pkg.gms_debug ('END result_status_code_update', 'C');
1273: END IF;
1274: x_err_code := 0;
1275: END result_status_code_update;
1276:

Line 1674: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Start','C');

1670:
1671: BEGIN
1672:
1673: IF g_debug = 'Y' THEN
1674: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Start','C');
1675: END IF;
1676:
1677: -- Burdenable raw cost calculation procedure returned FALSE due to exception
1678:

Line 1682: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms and gl packets to failed status F76/F67','C');

1678:
1679: IF p_result_code = 'F' THEN
1680:
1681: IF g_debug = 'Y' THEN
1682: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms and gl packets to failed status F76/F67','C');
1683: END IF;
1684:
1685: result_status_code_update ( p_packet_id=> p_packet_id,
1686: p_status_code=> 'T',

Line 1714: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms packets to Full mode failure','C');

1710:
1711: IF l_count <> 0 THEN
1712:
1713: IF g_debug = 'Y' THEN
1714: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms packets to Full mode failure','C');
1715: END IF;
1716:
1717: -- If failure, update result/status code
1718: Update gms_bc_packets

Line 1788: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Start','C');

1784:
1785: BEGIN
1786:
1787: IF g_debug = 'Y' THEN
1788: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Start','C');
1789: END IF;
1790:
1791:
1792: l_rec_count := p_set_of_books_id_tab.count();

Line 1795: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Intializing local variables','C');

1791:
1792: l_rec_count := p_set_of_books_id_tab.count();
1793:
1794: IF g_debug = 'Y' THEN
1795: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Intializing local variables','C');
1796: END IF;
1797:
1798: p_return_code := 'P';
1799: l_request_id := fnd_global.conc_request_id;

Line 1814: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Starting loop to insert '||l_rec_count||'into gms_bc_packets','C');

1810:
1811: IF l_rec_count > 0 Then
1812:
1813: IF g_debug = 'Y' THEN
1814: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Starting loop to insert '||l_rec_count||'into gms_bc_packets','C');
1815: END IF;
1816:
1817: FORALL i IN 1 .. l_rec_count
1818: INSERT INTO gms_bc_packets

Line 1915: gms_error_pkg.gms_debug ('Load_gms_pkts - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');

1911:
1912: EXCEPTION
1913: WHEN OTHERS THEN
1914: IF g_debug = 'Y' THEN
1915: gms_error_pkg.gms_debug ('Load_gms_pkts - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');
1916: END IF;
1917: p_return_code := 'F';
1918: END Load_gms_pkts;
1919:

Line 1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');

1931: p_entered_cr IN NUMBER) IS
1932: BEGIN
1933:
1934: IF g_debug = 'Y' THEN
1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');

Line 1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');

1932: BEGIN
1933:
1934: IF g_debug = 'Y' THEN
1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');

Line 1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');

1933:
1934: IF g_debug = 'Y' THEN
1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');

Line 1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');

1934: IF g_debug = 'Y' THEN
1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');

Line 1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');

1935: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1943: END IF;

Line 1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');

1936: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1943: END IF;
1944:

Line 1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');

1937: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1943: END IF;
1944:
1945: g_je_source_name_tab(p_new_rec_index) := g_je_source_name_tab(p_copy_from_index);

Line 1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');

1938: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1939: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1940: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_ind_com_set_id ='||p_po_ind_com_set_id,'C');
1941: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1943: END IF;
1944:
1945: g_je_source_name_tab(p_new_rec_index) := g_je_source_name_tab(p_copy_from_index);
1946: g_je_category_name_tab(p_new_rec_index) := g_je_category_name_tab(p_copy_from_index);

Line 1998: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - End','C');

1994:
1995: END IF;
1996:
1997: IF g_debug = 'Y' THEN
1998: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - End','C');
1999: END IF;
2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN

Line 2004: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - exception'||SQLERRM,'C');

2000:
2001: EXCEPTION
2002: WHEN OTHERS THEN
2003: IF g_debug = 'Y' THEN
2004: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - exception'||SQLERRM,'C');
2005: END IF;
2006: RAISE;
2007: END COPY_AP_RECORD;
2008:

Line 2027: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Start','C');

2023:
2024: BEGIN
2025:
2026: IF g_debug = 'Y' THEN
2027: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Start','C');
2028: END IF;
2029:
2030: -- Below is the logic of splitting AP line into multiple bc records
2031: -- 1.IF po_distribution id populated then create PO relieving record

Line 2048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Calculating accounted amounts for PO relieving record from its entered amounts and rate','C');

2044: Else
2045: Copy accounted amounts for PO relieving record from those on the invoice */
2046: If g_po_rate_tab(p_copy_from_index) is NOT NULL then
2047: IF g_debug = 'Y' THEN
2048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Calculating accounted amounts for PO relieving record from its entered amounts and rate','C');
2049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Rate : '||g_po_rate_tab(p_copy_from_index),'C');
2050: END IF;
2051: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2052: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);

Line 2049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Rate : '||g_po_rate_tab(p_copy_from_index),'C');

2045: Copy accounted amounts for PO relieving record from those on the invoice */
2046: If g_po_rate_tab(p_copy_from_index) is NOT NULL then
2047: IF g_debug = 'Y' THEN
2048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Calculating accounted amounts for PO relieving record from its entered amounts and rate','C');
2049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Rate : '||g_po_rate_tab(p_copy_from_index),'C');
2050: END IF;
2051: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2052: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2053: else

Line 2055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Copying accounted amounts for PO relieving record from those on the invoice','C');

2051: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2052: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2053: else
2054: IF g_debug = 'Y' THEN
2055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Copying accounted amounts for PO relieving record from those on the invoice','C');
2056: END IF;
2057: l_entered_dr := g_entered_cr_tab(p_copy_from_index);
2058: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2059: end if;

Line 2061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_dr : '||l_entered_dr,'C');

2057: l_entered_dr := g_entered_cr_tab(p_copy_from_index);
2058: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2059: end if;
2060: IF g_debug = 'Y' THEN
2061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_dr : '||l_entered_dr,'C');
2062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_cr : '||l_entered_cr,'C');
2063: END IF;
2064:
2065: COPY_AP_RECORD (p_copy_from_index => p_copy_from_index,

Line 2062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_cr : '||l_entered_cr,'C');

2058: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2059: end if;
2060: IF g_debug = 'Y' THEN
2061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_dr : '||l_entered_dr,'C');
2062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_cr : '||l_entered_cr,'C');
2063: END IF;
2064:
2065: COPY_AP_RECORD (p_copy_from_index => p_copy_from_index,
2066: p_new_rec_index => l_new_rec_index,

Line 2076: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling CREATE_APVAR_RECORD for amount varaince','C');

2072:
2073: IF NVL(g_amount_variance_tab(p_copy_from_index),0) <> 0 THEN
2074:
2075: IF g_debug = 'Y' THEN
2076: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling CREATE_APVAR_RECORD for amount varaince','C');
2077: END IF;
2078:
2079: l_new_rec_index := l_new_rec_index + 1;
2080:

Line 2112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for amount varaince','C');

2108: g_burdenable_raw_cost_tab(l_new_rec_index):= 0;
2109: END IF;
2110:
2111: IF g_debug = 'Y' THEN
2112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for amount varaince','C');
2113: END IF;
2114:
2115: END IF; --IF NVL(g_tab_ap_amount_variance(p_copy_from_index),0) <> 0 THEN
2116:

Line 2121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling CREATE_APVAR_RECORD for qty varaince','C');

2117:
2118: IF NVL(g_quantity_variance_tab(p_copy_from_index),0) <> 0 THEN
2119:
2120: IF g_debug = 'Y' THEN
2121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling CREATE_APVAR_RECORD for qty varaince','C');
2122: END IF;
2123:
2124: l_new_rec_index := l_new_rec_index + 1;
2125:

Line 2148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for qty varaince','C');

2144: g_burdenable_raw_cost_tab(l_new_rec_index):= 0;
2145: END IF;
2146:
2147: IF g_debug = 'Y' THEN
2148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for qty varaince','C');
2149: END IF;
2150:
2151: END IF; --IF NVL(g_quantity_variance_tab(p_copy_from_index),0) <> 0 THEN
2152:

Line 2156: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - End','C');

2152:
2153: p_new_rec_index := l_new_rec_index;
2154:
2155: IF g_debug = 'Y' THEN
2156: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - End','C');
2157: END IF;
2158:
2159: EXCEPTION
2160: WHEN OTHERS THEN

Line 2163: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - EXception','C');

2159: EXCEPTION
2160: WHEN OTHERS THEN
2161:
2162: IF g_debug = 'Y' THEN
2163: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - EXception','C');
2164: END IF;
2165:
2166: RAISE;
2167:

Line 2593: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start of DERIVE_DR_CR ','C');

2589: PROCEDURE DERIVE_DR_CR IS
2590: BEGIN
2591:
2592: IF g_debug = 'Y' THEN
2593: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start of DERIVE_DR_CR ','C');
2594: END IF;
2595:
2596: FOR l_index IN 1..g_set_of_books_id_tab.Last LOOP
2597:

Line 2643: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');

2639:
2640: END IF;
2641:
2642: IF g_debug = 'Y' THEN
2643: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2644: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2645: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2646: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2647: END IF;

Line 2644: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');

2640: END IF;
2641:
2642: IF g_debug = 'Y' THEN
2643: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2644: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2645: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2646: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2647: END IF;
2648:

Line 2645: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');

2641:
2642: IF g_debug = 'Y' THEN
2643: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2644: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2645: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2646: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2647: END IF;
2648:
2649:

Line 2646: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');

2642: IF g_debug = 'Y' THEN
2643: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2644: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2645: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2646: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2647: END IF;
2648:
2649:
2650: END LOOP;

Line 2653: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End of DERIVE_DR_CR ','C');

2649:
2650: END LOOP;
2651:
2652: IF g_debug = 'Y' THEN
2653: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End of DERIVE_DR_CR ','C');
2654: END IF;
2655:
2656: END DERIVE_DR_CR;
2657:

Line 2671: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start','C');

2667: l_mode := 'R';
2668: END IF;
2669:
2670: IF g_debug = 'Y' THEN
2671: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start','C');
2672: END IF;
2673:
2674: -- Initializing OUT variables
2675: x_return_code := 'P';

Line 2683: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Intialize_tabs','C');

2679: INTO l_packet_id
2680: FROM dual;
2681:
2682: IF g_debug = 'Y' THEN
2683: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Intialize_tabs','C');
2684: END IF;
2685:
2686: Intialize_tabs;
2687:

Line 2695: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 200 ','C');

2691: -- Fetch AP/PO/REQ data associted with sponsored Project.No other validations performed
2692: IF p_application_id = 200 THEN -- Payables is the Calling application
2693:
2694: IF g_debug = 'Y' THEN
2695: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 200 ','C');
2696: END IF;
2697:
2698: OPEN c_awrd_ap_dist;
2699: FETCH c_awrd_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;

Line 2703: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Number of AP distribuions fetched ='||g_ap_inv_dist_id.count,'C');

2699: FETCH c_awrd_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;
2700: CLOSE c_awrd_ap_dist;
2701:
2702: IF g_debug = 'Y' THEN
2703: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Number of AP distribuions fetched ='||g_ap_inv_dist_id.count,'C');
2704: END IF;
2705:
2706: IF g_ap_inv_dist_id.count <> 0 THEN
2707:

Line 2728: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');

2724:
2725: END LOOP;
2726:
2727: IF g_debug = 'Y' THEN
2728: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
2729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
2730: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
2731: End if;
2732:

Line 2729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');

2725: END LOOP;
2726:
2727: IF g_debug = 'Y' THEN
2728: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
2729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
2730: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
2731: End if;
2732:
2733: OPEN cur_ap_bc_dist(l_stdinvoice_exists,l_prepay_exists);

Line 2730: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');

2726:
2727: IF g_debug = 'Y' THEN
2728: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
2729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
2730: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
2731: End if;
2732:
2733: OPEN cur_ap_bc_dist(l_stdinvoice_exists,l_prepay_exists);
2734: FETCH cur_ap_bc_dist BULK COLLECT INTO

Line 2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');

2773: CLOSE cur_ap_bc_dist;
2774:
2775: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2776: FOR i in 1..g_doc_dist_id_tab.count LOOP
2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

Line 2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');

2774:
2775: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2776: FOR i in 1..g_doc_dist_id_tab.count LOOP
2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

Line 2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');

2775: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2776: FOR i in 1..g_doc_dist_id_tab.count LOOP
2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

Line 2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');

2776: FOR i in 1..g_doc_dist_id_tab.count LOOP
2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

Line 2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

2777: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

Line 2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

2778: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

Line 2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

2779: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

Line 2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

2780: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

Line 2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

2781: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

Line 2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

2782: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

Line 2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

2783: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

Line 2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

2784: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');

Line 2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

2785: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

Line 2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

2786: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

Line 2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

2787: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');

2788: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

Line 2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

2789: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

Line 2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

2790: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

Line 2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

2791: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

Line 2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

2792: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

Line 2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

2793: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');

Line 2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

2794: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
2802: END LOOP;

Line 2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

2795: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
2802: END LOOP;
2803: End if;

Line 2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

2796: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
2802: END LOOP;
2803: End if;
2804:

Line 2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');

2797: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2798: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
2799: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
2800: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
2801: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
2802: END LOOP;
2803: End if;
2804:
2805: END IF;--IF g_ap_inv_dist_id.count <> 0 THEN

Line 2810: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 201 ','C');

2806:
2807: ELSIF p_application_id = 201 THEN -- Purchasing is the Calling application
2808:
2809: IF g_debug = 'Y' THEN
2810: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 201 ','C');
2811: END IF;
2812:
2813: OPEN c_REQ_PO_pkt_rec;
2814: FETCH c_REQ_PO_pkt_rec BULK COLLECT INTO

Line 2844: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling DERIVE_DR_CR ','C');

2840: CLOSE c_REQ_PO_pkt_rec;
2841:
2842: IF g_doc_dist_id_tab.count <> 0 THEN
2843: IF g_debug = 'Y' THEN
2844: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling DERIVE_DR_CR ','C');
2845: END IF;
2846: DERIVE_DR_CR;
2847: END IF;
2848:

Line 2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');

2847: END IF;
2848:
2849: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2850: FOR i in 1..g_doc_dist_id_tab.count LOOP
2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');

Line 2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');

2848:
2849: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2850: FOR i in 1..g_doc_dist_id_tab.count LOOP
2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

Line 2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');

2849: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
2850: FOR i in 1..g_doc_dist_id_tab.count LOOP
2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

Line 2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');

2850: FOR i in 1..g_doc_dist_id_tab.count LOOP
2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

Line 2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');

2851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');

Line 2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

2852: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

Line 2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

2853: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

Line 2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

2854: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');

Line 2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');

2855: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');

Line 2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

2856: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

Line 2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

2857: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

Line 2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');

2858: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

Line 2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');

2859: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

Line 2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

2860: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

Line 2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

2861: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

Line 2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

2862: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');

Line 2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

2863: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');

Line 2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

Line 2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

2865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

Line 2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');

2866: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');

2867: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

Line 2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

2868: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

Line 2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

2869: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');

Line 2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

2870: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');

Line 2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

2871: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');

Line 2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

2872: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
2880: END LOOP;

Line 2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');

2873: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
2880: END LOOP;
2881: End if;

Line 2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');

2874: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
2880: END LOOP;
2881: End if;
2882:

Line 2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');

2875: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2876: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
2877: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
2878: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
2879: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
2880: END LOOP;
2881: End if;
2882:
2883: END IF;

Line 2886: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After fetching data from AP/PO ','C');

2882:
2883: END IF;
2884:
2885: IF g_debug = 'Y' THEN
2886: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After fetching data from AP/PO ','C');
2887: END IF;
2888:
2889: -- If no eligible GMS records to process then return with x_return_code as success ('P')
2890: IF g_doc_dist_id_tab.count = 0 THEN

Line 2892: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'NO records fetched from AP/PO extract,GOTO END_OF_PROCESS ','C');

2888:
2889: -- If no eligible GMS records to process then return with x_return_code as success ('P')
2890: IF g_doc_dist_id_tab.count = 0 THEN
2891: IF g_debug = 'Y' THEN
2892: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'NO records fetched from AP/PO extract,GOTO END_OF_PROCESS ','C');
2893: END IF;
2894: GOTO END_OF_PROCESS;
2895: END IF;
2896:

Line 2898: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling misc_synch_adls','C');

2894: GOTO END_OF_PROCESS;
2895: END IF;
2896:
2897: IF g_debug = 'Y' THEN
2898: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling misc_synch_adls','C');
2899: END IF;
2900:
2901: IF NOT misc_synch_adls (p_application_id) THEN -- Bug 5344693 : misc_synch_adls is called with correct application_id.
2902: x_return_code := 'F';

Line 2904: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'misc_synch_adls returned false','C');

2900:
2901: IF NOT misc_synch_adls (p_application_id) THEN -- Bug 5344693 : misc_synch_adls is called with correct application_id.
2902: x_return_code := 'F';
2903: IF g_debug = 'Y' THEN
2904: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'misc_synch_adls returned false','C');
2905: END IF;
2906: -- misc_synch_adls raises if any exceptions so no need to handle exception
2907: GOTO END_OF_PROCESS;
2908: END IF;

Line 2913: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id ','C');

2909:
2910: -- Start of Code to fire GMS specific validations
2911:
2912: IF g_debug = 'Y' THEN
2913: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id ','C');
2914: END IF;
2915:
2916: SELECT NVL (default_dist_award_id, 0),
2917: NVL (award_distribution_option, 'N')

Line 2923: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_award_dist_option = '||l_award_dist_option,'C');

2919: l_award_dist_option
2920: FROM gms_implementations;
2921:
2922: IF g_debug = 'Y' THEN
2923: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_award_dist_option = '||l_award_dist_option,'C');
2924: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_dist_award_id = '||l_dist_award_id,'C');
2925: END IF;
2926:
2927: IF l_award_dist_option = 'Y' THEN

Line 2924: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_dist_award_id = '||l_dist_award_id,'C');

2920: FROM gms_implementations;
2921:
2922: IF g_debug = 'Y' THEN
2923: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_award_dist_option = '||l_award_dist_option,'C');
2924: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_dist_award_id = '||l_dist_award_id,'C');
2925: END IF;
2926:
2927: IF l_award_dist_option = 'Y' THEN
2928:

Line 2947: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');

2943: x_adl_rec.last_update_login := 0;
2944: x_adl_rec.request_id := -9999;
2945:
2946: IF g_debug = 'Y' THEN
2947: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');
2948: END IF;
2949:
2950: gms_awards_dist_pkg.create_adls (x_adl_rec);
2951:

Line 2960: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching REQ data for distribution id '||g_doc_dist_id_tab(i),'C');

2956:
2957: IF g_document_type_tab(i) ='REQ' THEN
2958:
2959: IF g_debug = 'Y' THEN
2960: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching REQ data for distribution id '||g_doc_dist_id_tab(i),'C');
2961: END IF;
2962:
2963: OPEN c_req_adl_details(g_doc_dist_id_tab(i));
2964: FETCH c_req_adl_details INTO g_award_id_tab(i),

Line 2972: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Its an unsaved GMSIP transaction' ,'C');

2968: IF c_req_adl_details%NOTFOUND THEN
2969:
2970: IF g_reference6_tab(i) = 'GMSIP' THEN -- If its an unsaved Iprocurement
2971: IF g_debug = 'Y' THEN
2972: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Its an unsaved GMSIP transaction' ,'C');
2973: END IF;
2974: IF g_award_id_tab(i)=l_dist_award_id THEN
2975: g_result_code_tab(i) :='F21';
2976: ELSIF g_award_id_tab(i) IS NULL THEN

Line 2982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising REQ Data transfer failure F09' ,'C');

2978: END IF;
2979: g_vendor_id_tab(i) :=g_reference13_tab(i);
2980: ELSE
2981: IF g_debug = 'Y' THEN
2982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising REQ Data transfer failure F09' ,'C');
2983: END IF;
2984: g_result_code_tab(i) := 'F09'; -- Data transfer failure
2985: END IF; --F g_reference6_tab(i) = 'GMSIP' THEN
2986:

Line 2991: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

2987: END IF;
2988: CLOSE c_req_adl_details;
2989:
2990: IF g_debug = 'Y' THEN
2991: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2992: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2993: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2994: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2995: END IF;

Line 2992: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

2988: CLOSE c_req_adl_details;
2989:
2990: IF g_debug = 'Y' THEN
2991: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2992: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2993: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2994: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2995: END IF;
2996:

Line 2993: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

2989:
2990: IF g_debug = 'Y' THEN
2991: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2992: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2993: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2994: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2995: END IF;
2996:
2997: ELSIF g_document_type_tab(i) ='PO' THEN

Line 2994: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

2990: IF g_debug = 'Y' THEN
2991: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
2992: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
2993: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
2994: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
2995: END IF;
2996:
2997: ELSIF g_document_type_tab(i) ='PO' THEN
2998:

Line 3000: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching PO data for distribution id '||g_doc_dist_id_tab(i),'C');

2996:
2997: ELSIF g_document_type_tab(i) ='PO' THEN
2998:
2999: IF g_debug = 'Y' THEN
3000: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching PO data for distribution id '||g_doc_dist_id_tab(i),'C');
3001: END IF;
3002:
3003: OPEN c_po_adl_details(g_doc_dist_id_tab(i));
3004: FETCH c_po_adl_details INTO g_award_id_tab(i),

Line 3011: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');

3007: g_ind_cmp_set_id_tab(i),
3008: g_po_rate_tab(i); -- Bug 5614467
3009: IF c_po_adl_details%NOTFOUND THEN
3010: IF g_debug = 'Y' THEN
3011: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');
3012: END IF;
3013: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3014: END IF;
3015: CLOSE c_po_adl_details;

Line 3018: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

3014: END IF;
3015: CLOSE c_po_adl_details;
3016:
3017: IF g_debug = 'Y' THEN
3018: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3019: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3020: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3021: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3022: END IF;

Line 3019: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

3015: CLOSE c_po_adl_details;
3016:
3017: IF g_debug = 'Y' THEN
3018: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3019: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3020: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3021: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3022: END IF;
3023:

Line 3020: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

3016:
3017: IF g_debug = 'Y' THEN
3018: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3019: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3020: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3021: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3022: END IF;
3023:
3024:

Line 3021: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

3017: IF g_debug = 'Y' THEN
3018: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3019: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3020: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3021: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3022: END IF;
3023:
3024:
3025: ELSIF g_document_type_tab(i) ='AP' THEN

Line 3028: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching AP data for distribution id '||g_doc_dist_id_tab(i),'C');

3024:
3025: ELSIF g_document_type_tab(i) ='AP' THEN
3026:
3027: IF g_debug = 'Y' THEN
3028: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching AP data for distribution id '||g_doc_dist_id_tab(i),'C');
3029: END IF;
3030:
3031: OPEN c_ap_adl_details(g_doc_dist_id_tab(i));
3032: FETCH c_ap_adl_details INTO g_set_of_books_id_tab(i),

Line 3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising AP Data transfer failure F09' ,'C');

3045: g_burdenable_raw_cost_tab(i),
3046: g_parent_reversal_id_tab(i); -- Bug 5369296
3047: IF c_ap_adl_details%NOTFOUND THEN
3048: IF g_debug = 'Y' THEN
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising AP Data transfer failure F09' ,'C');
3050: END IF;
3051: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3052: END IF;
3053: CLOSE c_ap_adl_details;

Line 3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');

3052: END IF;
3053: CLOSE c_ap_adl_details;
3054:
3055: IF g_debug = 'Y' THEN
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');

Line 3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

3053: CLOSE c_ap_adl_details;
3054:
3055: IF g_debug = 'Y' THEN
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');

Line 3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');

3054:
3055: IF g_debug = 'Y' THEN
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');

Line 3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');

3055: IF g_debug = 'Y' THEN
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');

Line 3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');

3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_set_of_books_id_tab ='||g_set_of_books_id_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');

Line 3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');

3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

Line 3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');

3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

Line 3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');

3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');

3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_line_num_tab ='||g_doc_dist_line_num_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

Line 3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

Line 3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');

Line 3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

3063: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_1_tab ='||g_inv_dist_reference_1_tab(i),'C');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3071: END IF;

Line 3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_dist_reference_2_tab( ='||g_inv_dist_reference_2_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3071: END IF;
3072:

Line 3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3071: END IF;
3072:
3073: -- Code to check if there exists associated PO/Release and if exists create records

Line 3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');

3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3067: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3071: END IF;
3072:
3073: -- Code to check if there exists associated PO/Release and if exists create records
3074: -- to relieve amount variance/quantitiy variance AND PO

Line 3088: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');

3084: l_po_ind_com_set_id,
3085: g_po_rate_tab(i); -- Bug 5614467
3086: IF c_po_adl_details%NOTFOUND THEN
3087: IF g_debug = 'Y' THEN
3088: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');
3089: END IF;
3090: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3091: ELSE
3092: IF g_debug = 'Y' THEN

Line 3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');

3103: p_po_ind_com_set_id => l_po_ind_com_set_id);
3104:
3105: IF g_debug = 'Y' THEN
3106: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

Line 3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');

3104:
3105: IF g_debug = 'Y' THEN
3106: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

Line 3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');

3105: IF g_debug = 'Y' THEN
3106: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

Line 3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');

3106: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

Line 3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

3107: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

Line 3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

3108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

Line 3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

3109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

Line 3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

3110: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

Line 3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

3111: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

Line 3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

3112: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

Line 3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

3113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

Line 3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

3114: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');

Line 3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

Line 3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

3116: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

Line 3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

3117: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');

3118: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

Line 3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

3119: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

Line 3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

3120: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

Line 3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

3121: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

Line 3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');

3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_prepay_std_inv_dist_id ='||g_prepay_std_inv_dist_id(i),'C');
3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

Line 3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

3123: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');

Line 3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3132: END LOOP;

Line 3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3132: END LOOP;
3133: End if;

Line 3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_ind_cmp_set_id_tab ='||g_ind_cmp_set_id_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3132: END LOOP;
3133: End if;
3134:

Line 3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');

3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3132: END LOOP;
3133: End if;
3134:
3135: END IF;

Line 3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Deleting dummy ADL','C');

3143:
3144: IF NVL (l_award_dist_option, 'N') = 'Y' THEN
3145:
3146: IF g_debug = 'Y' THEN
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Deleting dummy ADL','C');
3148: END IF;
3149:
3150: DELETE gms_award_distributions
3151: WHERE award_set_id = NVL (l_dist_award_id, 0)

Line 3160: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Load_gms_pkts ','C');

3156: END IF;
3157: END IF; --IF p_application_id in (200,201) THEN
3158:
3159: IF g_debug = 'Y' THEN
3160: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Load_gms_pkts ','C');
3161: END IF;
3162:
3163: Load_gms_pkts (l_packet_id,
3164: p_partial_flag,

Line 3227: gms_error_pkg.gms_debug ('misc_gms_insert - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');

3223: AND request_id = -9999;
3224: END IF;
3225:
3226: IF g_debug = 'Y' THEN
3227: gms_error_pkg.gms_debug ('misc_gms_insert - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');
3228: END IF;
3229: x_return_code := 'F';
3230: END copy_gl_pkt_to_gms_pkt;
3231:

Line 3288: gms_error_pkg.gms_debug ('ENC1: Call calc_enc_ind_compiled_set_id ', 'C');

3284: Commented out for bug 3810247 : This code will move to stage 701 of gms_fck ..
3285:
3286: ELSIF doc_type = 'ENC' THEN
3287:
3288: gms_error_pkg.gms_debug ('ENC1: Call calc_enc_ind_compiled_set_id ', 'C');
3289: -- Fix for bug : 2927485 : calculate ind_compiled_set_id for ENC
3290: CALC_ENC_IND_COMPILED_SET_ID (x_packet_id);
3291:
3292: gms_error_pkg.gms_debug ('ENC2: Call Handle_net_zero_txn:Net_Zero ', 'C');

Line 3292: gms_error_pkg.gms_debug ('ENC2: Call Handle_net_zero_txn:Net_Zero ', 'C');

3288: gms_error_pkg.gms_debug ('ENC1: Call calc_enc_ind_compiled_set_id ', 'C');
3289: -- Fix for bug : 2927485 : calculate ind_compiled_set_id for ENC
3290: CALC_ENC_IND_COMPILED_SET_ID (x_packet_id);
3291:
3292: gms_error_pkg.gms_debug ('ENC2: Call Handle_net_zero_txn:Net_Zero ', 'C');
3293: -- Check if adjusted and adjusting transactions are present in the same packet
3294: -- If so, update them with result_code 'P82' and update effect_on_funds_code
3295: -- to 'I' so that 'funds avilable' calculation ignores them.
3296:

Line 3299: gms_error_pkg.gms_debug ('ENC3: Call Handle_net_zero_txn:Check_Adjusted ', 'C');

3295: -- to 'I' so that 'funds avilable' calculation ignores them.
3296:
3297: HANDLE_NET_ZERO_TXN(x_packet_id,'Net_Zero');
3298:
3299: gms_error_pkg.gms_debug ('ENC3: Call Handle_net_zero_txn:Check_Adjusted ', 'C');
3300: -- Fail adjusting transaction, if original transaction has not been FC'ed(F08)
3301:
3302: HANDLE_NET_ZERO_TXN(x_packet_id, 'Check_Adjusted');
3303: ======================================================================================== */

Line 3506: gms_error_pkg.gms_debug ('Initilaze Setup - Start ', 'C');

3502: ;
3503: BEGIN
3504: g_error_procedure_name := 'initialize_setup';
3505: IF g_debug = 'Y' THEN
3506: gms_error_pkg.gms_debug ('Initilaze Setup - Start ', 'C');
3507: END IF;
3508: g_error_stage := 'INIT_SETUP : START';
3509: SELECT NVL (default_dist_award_id, 0),
3510: NVL (award_distribution_option, 'N')

Line 3573: gms_error_pkg.gms_debug ('Initilize_Setup - End ', 'C');

3569: END LOOP;
3570: CLOSE cur_init_setup;
3571: g_error_stage := 'INIT_SETUP : END';
3572: IF g_debug = 'Y' THEN
3573: gms_error_pkg.gms_debug ('Initilize_Setup - End ', 'C');
3574: END IF;
3575: IF x_award_id = NVL (x_dist_award_id, -1111) THEN
3576: UPDATE gms_bc_packets
3577: SET status_code = decode(p_mode,'S','E','C','F','R'),

Line 3679: gms_error_pkg.gms_debug ('SETUP_RLMI - Start ', 'C');

3675: -- ########### =========================================-
3676:
3677: g_error_stage := 'SETUP_RLMI : START';
3678: IF g_debug = 'Y' THEN
3679: gms_error_pkg.gms_debug ('SETUP_RLMI - Start ', 'C');
3680: END IF;
3681: g_error_procedure_name := 'setup_rlmi';
3682:
3683: IF x_mode <> 'U' THEN

Line 3750: -- gms_error_pkg.gms_debug (

3746: OR (t_person_id (t_row_id.PRIOR (bcpkt_records))<> t_person_id (bcpkt_records))
3747: OR (t_job_id (t_row_id.PRIOR (bcpkt_records)) <> t_job_id (bcpkt_records))
3748: OR (t_vendor_id (t_row_id.PRIOR (bcpkt_records))<> t_vendor_id (bcpkt_records))) THEN
3749:
3750: -- gms_error_pkg.gms_debug (
3751: -- 'Setup_rlmi - Debug '|| t_exp_type (bcpkt_records),
3752: -- 'C');
3753:
3754: gms_res_map.map_resources_group (

Line 3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');

3770: t_rlmi_value (bcpkt_records),
3771: t_fc_error (bcpkt_records),
3772: x_err_buff);
3773:
3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');

Line 3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');

3771: t_fc_error (bcpkt_records),
3772: x_err_buff);
3773:
3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');

Line 3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');

3772: x_err_buff);
3773:
3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');

Line 3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');

3773:
3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');

Line 3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');

3774: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');

Line 3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');

3775: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');

Line 3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');

3776: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');

Line 3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');

3777: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
3785:

Line 3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');

3778: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
3785:
3786: ELSE

Line 3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');

3779: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
3785:
3786: ELSE
3787: t_rlmi_value (bcpkt_records) :=

Line 3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');

3780: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
3781: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
3782: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
3783: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
3784: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
3785:
3786: ELSE
3787: t_rlmi_value (bcpkt_records) :=
3788: t_rlmi_value (t_row_id.PRIOR (bcpkt_records));

Line 3843: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code P,L,T Complete ','C');

3839: AND bv1.budget_entry_method_code = bem1.budget_entry_method_code
3840: AND bem1.entry_level_code IN ('P', 'L', 'T'));
3841:
3842: IF g_debug = 'Y' THEN
3843: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code P,L,T Complete ','C');
3844: END IF;
3845:
3846: -- Added commit for the base bug 3848201
3847: commit;

Line 3902: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code M Complete ','C');

3898: -- Added commit for the base bug 3848201
3899: commit;
3900:
3901: IF g_debug = 'Y' THEN
3902: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code M Complete ','C');
3903: END IF;
3904:
3905: -- If Bud Task Id is not updated till this point , then update bud_task_id with
3906: -- task_id of expenditure

Line 3972: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Award Result code Complete ','C');

3968: WHERE packet_id = x_packet_id
3969: AND status_code = 'P'
3970: ;
3971: IF g_debug = 'Y' THEN
3972: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Award Result code Complete ','C');
3973: END IF;
3974: g_error_stage := 'FUND_CTRL_LEVEL_CODE : TT';
3975: -- Top Task Level
3976: UPDATE gms_bc_packets gms

Line 3993: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Top Task Result code Complete ','C');

3989: -- Added commit for the base bug 3848201
3990: commit;
3991:
3992: IF g_debug = 'Y' THEN
3993: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Top Task Result code Complete ','C');
3994: END IF;
3995: g_error_stage := 'FUND_CTRL_LEVEL_CODE : T';
3996:
3997: -- Task Level

Line 4015: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Task Result code Complete ','C');

4011: -- Added commit for the base bug 3848201
4012: commit;
4013:
4014: IF g_debug = 'Y' THEN
4015: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Task Result code Complete ','C');
4016: END IF;
4017: --Task level funds control level code should set up only if budget entry method is by task
4018: --For project with resource level budget entry method task_id =0
4019: -- Resource Group Level

Line 4039: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Group Result code Complete ','C');

4035: -- Added commit for the base bug 3848201
4036: commit;
4037:
4038: IF g_debug = 'Y' THEN
4039: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Group Result code Complete ','C');
4040: END IF;
4041:
4042: -- Resource Level
4043: g_error_stage := 'FUND_CTRL_LEVEL_CODE : R';

Line 4061: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Level Result code Complete ','C');

4057: -- Added commit for the base bug 3848201
4058: commit;
4059:
4060: IF g_debug = 'Y' THEN
4061: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Level Result code Complete ','C');
4062: END IF;
4063:
4064: -- If Funds control level code at any level is null
4065: -- The update it to 'None'

Line 4350: gms_error_pkg.gms_message (

4346: -- Find the x_start_date and x_end_date
4347: IF x_time_phased_type_code = 'N' THEN -- for no time phase
4348: IF ( x_amount_type <> 'PJTD'
4349: OR x_boundary_code <> 'J') THEN
4350: gms_error_pkg.gms_message (
4351: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4352: 'TIME_PHASED_CODE',
4353: x_time_phased_type_code,
4354: 'AMOUNT_TYPE',

Line 4371: gms_error_pkg.gms_debug ('For time phase = N it should be project to date project', 'C');

4367: p_packet_id=> x_packetid,
4368: p_bc_packet_id=> x_bc_packet_id);
4369:
4370: IF g_debug = 'Y' THEN
4371: gms_error_pkg.gms_debug ('For time phase = N it should be project to date project', 'C');
4372: END IF;
4373: ELSE
4374: x_start_date := project_start_date;
4375: x_end_date := project_end_date;

Line 4475: gms_error_pkg.gms_message (

4471: x_end_date := dr_period_end_date;
4472: END IF;
4473: -- end date calc for PJTD - period
4474: ELSE
4475: gms_error_pkg.gms_message (
4476: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4477: 'TIME_PHASED_CODE',
4478: x_time_phased_type_code,
4479: 'AMOUNT_TYPE',

Line 4487: gms_error_pkg.gms_debug ('invalid end date for PJTD ', 'C');

4483: x_exec_type=> 'C',
4484: x_err_code=> x_err_code,
4485: x_err_buff=> x_err_buff);
4486: IF g_debug = 'Y' THEN
4487: gms_error_pkg.gms_debug ('invalid end date for PJTD ', 'C');
4488: END IF;
4489: END IF;
4490: -- Year to Date - start and End date calculation
4491: -- start date calc - YTD

Line 4544: gms_error_pkg.gms_message (

4540: ELSIF x_time_phased_type_code = 'R' THEN
4541: x_end_date := dr_period_end_date;
4542: END IF;
4543: ELSE
4544: gms_error_pkg.gms_message (
4545: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4546: 'TIME_PHASED_CODE',
4547: x_time_phased_type_code,
4548: 'AMOUNT_TYPE',

Line 4556: gms_error_pkg.gms_debug ('invalid end date for year to date year', 'C');

4552: x_exec_type=> 'C',
4553: x_err_code=> x_err_code,
4554: x_err_buff=> x_err_buff);
4555: IF g_debug = 'Y' THEN
4556: gms_error_pkg.gms_debug ('invalid end date for year to date year', 'C');
4557: END IF;
4558: END IF;
4559: --For Period to Date Period
4560: ELSIF x_amount_type = 'PTD' THEN

Line 4574: gms_error_pkg.gms_message (

4570: x_start_date := dr_period_start_date;
4571: x_end_date := dr_period_end_date;
4572: END IF;
4573: ELSE
4574: gms_error_pkg.gms_message (
4575: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4576: 'TIME_PHASED_CODE',
4577: x_time_phased_type_code,
4578: 'AMOUNT_TYPE',

Line 4586: gms_error_pkg.gms_debug ('invalid end date for period to date', 'C');

4582: x_exec_type=> 'C',
4583: x_err_code=> x_err_code,
4584: x_err_buff=> x_err_buff);
4585: IF g_debug = 'Y' THEN
4586: gms_error_pkg.gms_debug ('invalid end date for period to date', 'C');
4587: END IF;
4588: END IF;
4589: ELSE
4590: gms_error_pkg.gms_message (

Line 4590: gms_error_pkg.gms_message (

4586: gms_error_pkg.gms_debug ('invalid end date for period to date', 'C');
4587: END IF;
4588: END IF;
4589: ELSE
4590: gms_error_pkg.gms_message (
4591: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4592: 'TIME_PHASED_CODE',
4593: x_time_phased_type_code,
4594: 'AMOUNT_TYPE',

Line 4602: gms_error_pkg.gms_debug ('invalid start date for any combination', 'C');

4598: x_exec_type=> 'C',
4599: x_err_code=> x_err_code,
4600: x_err_buff=> x_err_buff);
4601: IF g_debug = 'Y' THEN
4602: gms_error_pkg.gms_debug ('invalid start date for any combination', 'C');
4603: END IF;
4604: END IF;
4605: ELSE
4606: gms_error_pkg.gms_message (

Line 4606: gms_error_pkg.gms_message (

4602: gms_error_pkg.gms_debug ('invalid start date for any combination', 'C');
4603: END IF;
4604: END IF;
4605: ELSE
4606: gms_error_pkg.gms_message (
4607: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4608: 'TIME_PHASED_CODE',
4609: x_time_phased_type_code,
4610: 'AMOUNT_TYPE',

Line 4618: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');

4614: x_exec_type=> 'C',
4615: x_err_code=> x_err_code,
4616: x_err_buff=> x_err_buff);
4617: IF g_debug = 'Y' THEN
4618: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4619: END IF;
4620: END IF;
4621: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4622: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');

Line 4621: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');

4617: IF g_debug = 'Y' THEN
4618: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4619: END IF;
4620: END IF;
4621: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4622: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');
4623: --('After Date Check Process');
4624: END setup_start_end_date;
4625:

Line 4622: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');

4618: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4619: END IF;
4620: END IF;
4621: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4622: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');
4623: --('After Date Check Process');
4624: END setup_start_end_date;
4625:
4626: ----------------------------------------------------------------------------------------------------------

Line 5083: gms_error_pkg.gms_debug (g_error_procedure_name||':full_mode_failure call completed','C');

5079: If FULL_MODE_FAILURE(x_packetid, -- Packet_id
5080: g_mode, -- Mode , use g_mode
5081: 'ALL' -- Level
5082: ) THEN
5083: gms_error_pkg.gms_debug (g_error_procedure_name||':full_mode_failure call completed','C');
5084: -- Note:We're not handling Full mode failures for REQ/PO/AP here ...
5085: End If;
5086:
5087: -- Net zero txn.s failure

Line 5210: gms_error_pkg.gms_debug ( 'GMS_SETUP - Setup Failed ', 'C' );

5206: -- Added commit for the base bug 3848201
5207: commit;
5208:
5209: IF g_debug = 'Y' THEN
5210: gms_error_pkg.gms_debug ( 'GMS_SETUP - Setup Failed ', 'C' );
5211: END IF;
5212:
5213: RETURN FALSE;
5214: EXCEPTION

Line 5256: gms_error_pkg.gms_debug ( 'update_fc_sequence : Start ', 'C' );

5252: g_error_procedure_name := 'update_fc_sequence';
5253: g_error_stage := 'UPD FC SEQ: BLK COLL';
5254: t_count := 0; -- fix for bug : 2927485
5255:
5256: gms_error_pkg.gms_debug ( 'update_fc_sequence : Start ', 'C' );
5257:
5258: FOR recs in C_result_code
5259: loop
5260:

Line 5324: gms_error_pkg.gms_debug ( 'update_fc_sequence : End ', 'C' );

5320: WHERE ROWID = t_row_id (bcpkt_txns);
5321: End if;
5322:
5323: end loop;
5324: gms_error_pkg.gms_debug ( 'update_fc_sequence : End ', 'C' );
5325: END update_fc_sequence;
5326:
5327: ------------------------------------------------------------------------------------------------------
5328: -- Wrapper process which calls all the setup procedures and functions

Line 5357: gms_error_pkg.gms_debug ('GMS_SETUP - Before Burdened Cost Update ', 'C');

5353: BEGIN
5354: g_error_procedure_name := 'gms_setup';
5355: g_error_stage := 'GMS_SETUP : START';
5356: IF g_debug = 'Y' THEN
5357: gms_error_pkg.gms_debug ('GMS_SETUP - Before Burdened Cost Update ', 'C');
5358: END IF;
5359:
5360: update_burdened_cost (x_packetid);
5361: COMMIT;

Line 5367: gms_error_pkg.gms_debug ('GMS_SETUP - Before Setup RLMI ', 'C');

5363: --------------------------------------------------------------------------
5364: -- Set up of effect_on_funds_code and generating resource_list_member_id
5365: --------------------------------------------------------------------------
5366: IF g_debug = 'Y' THEN
5367: gms_error_pkg.gms_debug ('GMS_SETUP - Before Setup RLMI ', 'C');
5368: END IF;
5369: setup_rlmi (x_packetid, x_mode, x_err_code, x_err_buff);
5370: COMMIT;
5371:

Line 5377: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted Task Update -> packet_id'|| x_packetid, 'C');

5373: -- Update the budgeted task id
5374: -- in gms bc packets for a project, task, award, budget version
5375: -- ------------------------------------------------------------------------
5376: IF g_debug = 'Y' THEN
5377: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted Task Update -> packet_id'|| x_packetid, 'C');
5378: END IF;
5379: budget_task_id_update (x_packetid);
5380: COMMIT;
5381:

Line 5383: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted Task Update', 'C');

5379: budget_task_id_update (x_packetid);
5380: COMMIT;
5381:
5382: IF g_debug = 'Y' THEN
5383: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted Task Update', 'C');
5384: END IF;
5385:
5386: -- --------------------------------------------------------------------------
5387: -- Update the Budgeted resource list member id(rlmi)

Line 5391: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted rlmi Update -> packet_id'|| x_packetid, 'C');

5387: -- Update the Budgeted resource list member id(rlmi)
5388: -- in gms bc packets for a project, task, award, budget version
5389: -- --------------------------------------------------------------------------
5390: IF g_debug = 'Y' THEN
5391: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted rlmi Update -> packet_id'|| x_packetid, 'C');
5392: END IF;
5393: bud_res_list_id_update (x_packetid);
5394: COMMIT;
5395:

Line 5397: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted rlmi Update', 'C');

5393: bud_res_list_id_update (x_packetid);
5394: COMMIT;
5395:
5396: IF g_debug = 'Y' THEN
5397: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted rlmi Update', 'C');
5398: END IF;
5399:
5400: -- ---------------------------------------------------------------------------
5401: -- Updating the Funds control level code

Line 5405: gms_error_pkg.gms_debug ('GMS_SETUP - Before Funds ctrl code -> packet_id'|| x_packetid, 'C');

5401: -- Updating the Funds control level code
5402: -- in gms bc packets for a project, task, award, budget version
5403: -- ---------------------------------------------------------------------------
5404: IF g_debug = 'Y' THEN
5405: gms_error_pkg.gms_debug ('GMS_SETUP - Before Funds ctrl code -> packet_id'|| x_packetid, 'C');
5406: END IF;
5407: funds_ctrl_level_code (x_packetid);
5408: COMMIT;
5409:

Line 5411: gms_error_pkg.gms_debug ('GMS_SETUP - Before start date end date -> packet_id'|| x_packetid, 'C');

5407: funds_ctrl_level_code (x_packetid);
5408: COMMIT;
5409:
5410: IF g_debug = 'Y' THEN
5411: gms_error_pkg.gms_debug ('GMS_SETUP - Before start date end date -> packet_id'|| x_packetid, 'C');
5412: END IF;
5413:
5414: call_start_end_date_update (x_packetid,x_mode);
5415: COMMIT;

Line 5417: gms_error_pkg.gms_debug ('GMS_SETUP - After startdate end date -> packet_id'|| x_packetid, 'C');

5413:
5414: call_start_end_date_update (x_packetid,x_mode);
5415: COMMIT;
5416: IF g_debug = 'Y' THEN
5417: gms_error_pkg.gms_debug ('GMS_SETUP - After startdate end date -> packet_id'|| x_packetid, 'C');
5418: END IF;
5419:
5420: IF NOT check_setup_failure (x_packetid, x_partial ) THEN
5421: COMMIT;

Line 5464: gms_error_pkg.gms_debug ( 'GMS_SETUP -After Inserting Records in gms_bc_packet_arrival_order ', 'C' );

5460: */
5461:
5462: g_error_stage := 'GMS_SETUP : END';
5463: IF g_debug = 'Y' THEN
5464: gms_error_pkg.gms_debug ( 'GMS_SETUP -After Inserting Records in gms_bc_packet_arrival_order ', 'C' );
5465: END IF;
5466: RETURN TRUE;
5467: END gms_setup;
5468:

Line 5600: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - PROCESS'|| x_packetid, 'C');

5596: g_error_procedure_name := 'budget_fundscheck';
5597: g_error_stage := 'BUD_FC : START';
5598: -- Resource Level
5599: IF g_debug = 'Y' THEN
5600: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - PROCESS'|| x_packetid, 'C');
5601: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE LEVEL', 'C');
5602: END IF;
5603: g_error_stage := 'BUD_FC : RES';
5604: OPEN gms_bc_tot_r;

Line 5601: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE LEVEL', 'C');

5597: g_error_stage := 'BUD_FC : START';
5598: -- Resource Level
5599: IF g_debug = 'Y' THEN
5600: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - PROCESS'|| x_packetid, 'C');
5601: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE LEVEL', 'C');
5602: END IF;
5603: g_error_stage := 'BUD_FC : RES';
5604: OPEN gms_bc_tot_r;
5605: LOOP

Line 5656: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE GROUP LEVEL', 'C');

5652:
5653: l_previous_tot := 0;
5654:
5655: IF g_debug = 'Y' THEN
5656: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE GROUP LEVEL', 'C');
5657: END IF;
5658: OPEN gms_bc_tot_rg;
5659: LOOP
5660: FETCH gms_bc_tot_rg INTO x_rg_bc_tot,

Line 5713: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TASK LEVEL', 'C');

5709:
5710: l_previous_tot := 0;
5711:
5712: IF g_debug = 'Y' THEN
5713: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TASK LEVEL', 'C');
5714: END IF;
5715: OPEN gms_bc_tot_t;
5716: LOOP
5717: FETCH gms_bc_tot_t INTO x_t_bc_tot,

Line 5762: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TOP TASK LEVEL', 'C');

5758:
5759: l_previous_tot := 0;
5760:
5761: IF g_debug = 'Y' THEN
5762: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TOP TASK LEVEL', 'C');
5763: END IF;
5764: OPEN gms_bc_tot_tt;
5765: LOOP
5766: FETCH gms_bc_tot_tt INTO x_tt_bc_tot,

Line 5811: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE AWARD LEVEL', 'C');

5807:
5808: l_previous_tot := 0;
5809:
5810: IF g_debug = 'Y' THEN
5811: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE AWARD LEVEL', 'C');
5812: END IF;
5813: OPEN gms_bc_tot_a;
5814: LOOP
5815:

Line 5853: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK BEFORE P50 UPDATE '|| x_packetid, 'C');

5849:
5850: END LOOP;
5851: CLOSE gms_bc_tot_a;
5852: IF g_debug = 'Y' THEN
5853: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK BEFORE P50 UPDATE '|| x_packetid, 'C');
5854: END IF;
5855: UPDATE gms_bc_packets
5856: SET result_code = 'P50',
5857: award_result_code = 'P50',

Line 5865: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - AFTER P50 UPDATE '|| x_packetid, 'C');

5861: top_task_result_code = 'P50'
5862: WHERE packet_id = x_packetid
5863: AND status_code = 'P';
5864: IF g_debug = 'Y' THEN
5865: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - AFTER P50 UPDATE '|| x_packetid, 'C');
5866: END IF;
5867: EXCEPTION
5868: WHEN NO_DATA_FOUND THEN
5869: -- For Resource Level

Line 5872: gms_error_pkg.gms_message (

5868: WHEN NO_DATA_FOUND THEN
5869: -- For Resource Level
5870: IF gms_bc_tot_r%ISOPEN THEN
5871: g_error_stage := 'BUD_FC FAIL: RES';
5872: gms_error_pkg.gms_message (
5873: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_RES',
5874: x_token_name1=> 'PACKET_ID',
5875: x_token_val1=> x_packetid,
5876: x_token_name2=> 'TASK_ID',

Line 5901: gms_error_pkg.gms_message (

5897:
5898: -- For Resource Group Level
5899: IF gms_bc_tot_rg%ISOPEN THEN
5900: g_error_stage := 'BUD_FC FAIL: RES GRP';
5901: gms_error_pkg.gms_message (
5902: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_RES_GRP',
5903: x_token_name1=> 'PACKET_ID',
5904: x_token_val1=> x_packetid,
5905: x_token_name2=> 'TASK_ID',

Line 5930: gms_error_pkg.gms_message (

5926:
5927: -- For Task Level
5928: IF gms_bc_tot_t%ISOPEN THEN
5929: g_error_stage := 'BUD_FC FAIL: TASK';
5930: gms_error_pkg.gms_message (
5931: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_TASK',
5932: x_token_name1=> 'PACKET_ID',
5933: x_token_val1=> x_packetid,
5934: x_token_name2=> 'TASK_ID',

Line 5957: gms_error_pkg.gms_message (

5953:
5954: -- For Top Task Level
5955: IF gms_bc_tot_tt%ISOPEN THEN
5956: g_error_stage := 'BUD_FC FAIL: TOPTASK';
5957: gms_error_pkg.gms_message (
5958: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_TOP_TASK',
5959: x_token_name1=> 'PACKET_ID',
5960: x_token_val1=> x_packetid,
5961: x_token_name2=> 'TOP_TASK_ID',

Line 5984: gms_error_pkg.gms_message (

5980: -- For Award Level
5981:
5982: IF gms_bc_tot_a%ISOPEN THEN
5983: g_error_stage := 'BUD_FC FAIL: AWARD';
5984: gms_error_pkg.gms_message (
5985: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_AWARD',
5986: x_token_name1=> 'PACKET_ID',
5987: x_token_val1=> x_packetid,
5988: x_token_name4=> 'START_DATE',

Line 6054: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');

6050: -- Following Insert statement inserts records in gms_bc_packets_summary.
6051: -- Records in this table will later be used to summarize amount at
6052: -- resource,task and Award Level for previous and currne packet.
6053: IF g_debug = 'Y' THEN
6054: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');
6055: END IF;
6056: x_date := sysdate;
6057: g_error_stage := 'FC PR : INSRT SUMM';
6058: INSERT INTO gms_bc_packets_bvid

Line 6135: gms_error_pkg.gms_debug ('RESOURCE POSTED BALANCE UPDATE', 'C');

6131: --===============================================================================
6132: -- RESOURCE LEVEL : POSTED BALANCE UPDATE
6133: --===============================================================================
6134: IF g_debug = 'Y' THEN
6135: gms_error_pkg.gms_debug ('RESOURCE POSTED BALANCE UPDATE', 'C');
6136: END IF;
6137: g_error_stage := 'FC PR : RES P BAL';
6138: UPDATE gms_bc_packets bp
6139: SET (bp.res_budget_posted, bp.res_actual_posted, bp.res_enc_posted) =

Line 6178: gms_error_pkg.gms_debug (

6174: AND bp.categorization_code = 'R'
6175: AND bp.r_funds_control_level_code <> 'N';
6176: -- AND bp.budgeted_at_resource_level = 'Y'; -- Bug 2605070
6177: IF g_debug = 'Y' THEN
6178: gms_error_pkg.gms_debug (
6179: 'RESOURCE LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS',
6180: 'C');
6181: END IF;
6182: --===============================================================================

Line 6186: gms_error_pkg.gms_debug ( 'RESOURCE LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS','C' );

6182: --===============================================================================
6183: -- RESOURCE LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
6184: --===============================================================================
6185: IF g_debug = 'Y' THEN
6186: gms_error_pkg.gms_debug ( 'RESOURCE LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS','C' );
6187: END IF;
6188: -- Bug 2092791
6189: g_error_stage := 'FC PR : RES A BAL';
6190: UPDATE gms_bc_packets bp

Line 6319: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE', 'C');

6315: -- F92 : Transaction failed funds check at Resource level
6316: -- ================================================================================
6317: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
6318: IF g_debug = 'Y' THEN
6319: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE', 'C');
6320: END IF;
6321: g_error_stage := 'FC PR : RES RESULT CODE';
6322: UPDATE gms_bc_packets bp
6323: SET bp.res_result_code = DECODE (

Line 6428: gms_error_pkg.gms_debug ('RESOURCE GROUP POSTED BALANCE UPDATE', 'C');

6424: --===============================================================================
6425: -- RESOURCE GROUP LEVEL : POSTED BALANCE UPDATE
6426: --===============================================================================
6427: IF g_debug = 'Y' THEN
6428: gms_error_pkg.gms_debug ('RESOURCE GROUP POSTED BALANCE UPDATE', 'C');
6429: END IF;
6430: g_error_stage := 'FC PR : RESG P BAL';
6431: UPDATE gms_bc_packets bp
6432: SET (bp.res_grp_budget_posted, bp.res_grp_actual_posted, bp.res_grp_enc_posted) =

Line 6483: gms_error_pkg.gms_debug ('RESOURCE GROUP LEVEL - APPROVED/PENDING BALANCE FOR CURRENT PACKET', 'C');

6479: --===================================================================================
6480: -- RESOURCE GROUP LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
6481: --===================================================================================
6482: IF g_debug = 'Y' THEN
6483: gms_error_pkg.gms_debug ('RESOURCE GROUP LEVEL - APPROVED/PENDING BALANCE FOR CURRENT PACKET', 'C');
6484: END IF;
6485: -- Bug 2092791
6486: g_error_stage := 'FC PR : RESG A/P BAL';
6487: UPDATE gms_bc_packets bp

Line 6613: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE GROUP', 'C');

6609: -- F93 : Transaction failed funds check at Resource Group level
6610: -- ================================================================================
6611: -- Changed for bug : 2927485: Added decode(bp.result_code,null,'P78',bp.result_code)
6612: IF g_debug = 'Y' THEN
6613: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE GROUP', 'C');
6614: END IF;
6615: g_error_stage := 'FC PR : RESG RESULT UPD';
6616: UPDATE gms_bc_packets bp
6617: SET bp.res_grp_result_code = DECODE (

Line 6720: gms_error_pkg.gms_debug ('TASK :POSTED BALANCE ', 'C');

6716: --===============================================================================
6717: -- TASK LEVEL : POSTED BALANCE UPDATE
6718: --===============================================================================
6719: IF g_debug = 'Y' THEN
6720: gms_error_pkg.gms_debug ('TASK :POSTED BALANCE ', 'C');
6721: END IF;
6722: g_error_stage := 'FC PR : TASK P BAL';
6723: UPDATE gms_bc_packets bp
6724: SET (bp.task_budget_posted, bp.task_actual_posted, bp.task_enc_posted) =

Line 6760: gms_error_pkg.gms_debug ('TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');

6756: --===============================================================================
6757: -- TASK LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
6758: --===============================================================================
6759: IF g_debug = 'Y' THEN
6760: gms_error_pkg.gms_debug ('TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
6761: END IF;
6762:
6763: g_error_stage := 'FC PR : TASK A/P BAL';
6764: UPDATE gms_bc_packets bp

Line 6883: gms_error_pkg.gms_debug ('TASK : RESULT CODE ', 'C');

6879: -- ================================================================================
6880: -- 3. Task Result Code Update
6881: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
6882: IF g_debug = 'Y' THEN
6883: gms_error_pkg.gms_debug ('TASK : RESULT CODE ', 'C');
6884: END IF;
6885: g_error_stage := 'FC PR : TASK RESULT CD';
6886: UPDATE gms_bc_packets bp
6887: SET bp.task_result_code = DECODE (

Line 6987: gms_error_pkg.gms_debug ('TOP TASK :POSTED BALANCE ', 'C');

6983: --===============================================================================
6984: -- TOP TASK LEVEL : POSTED BALANCE UPDATE
6985: --===============================================================================
6986: IF g_debug = 'Y' THEN
6987: gms_error_pkg.gms_debug ('TOP TASK :POSTED BALANCE ', 'C');
6988: END IF;
6989: g_error_stage := 'FC PR : TTASK P BAL';
6990: UPDATE gms_bc_packets bp
6991: SET (bp.top_task_budget_posted, bp.top_task_actual_posted, bp.top_task_enc_posted) =

Line 7028: gms_error_pkg.gms_debug ('TOP TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');

7024: --===============================================================================
7025: -- TOP TASK LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
7026: --===============================================================================
7027: IF g_debug = 'Y' THEN
7028: gms_error_pkg.gms_debug ('TOP TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
7029: END IF;
7030: g_error_stage := 'FC PR : TTASK A/P BAL';
7031: -- Bug 2092791
7032:

Line 7156: gms_error_pkg.gms_debug ('TOP TASK : RESULT CODE ', 'C');

7152: -- ================================================================================
7153: -- Top Task Result Code Update
7154: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
7155: IF g_debug = 'Y' THEN
7156: gms_error_pkg.gms_debug ('TOP TASK : RESULT CODE ', 'C');
7157: END IF;
7158: g_error_stage := 'FC PR : TTASK RESULT CODE';
7159: UPDATE gms_bc_packets bp
7160: SET bp.top_task_result_code = DECODE (

Line 7254: gms_error_pkg.gms_debug ('AWARD:POSTED BALANCE ', 'C');

7250: --===============================================================================
7251: -- AWARD LEVEL : POSTED BALANCE UPDATE
7252: --===============================================================================
7253: IF g_debug = 'Y' THEN
7254: gms_error_pkg.gms_debug ('AWARD:POSTED BALANCE ', 'C');
7255: END IF;
7256: g_error_stage := 'FC PR : AWARD P B';
7257: UPDATE gms_bc_packets bp
7258: SET (bp.award_budget_posted, bp.award_actual_posted, bp.award_enc_posted) =

Line 7290: gms_error_pkg.gms_debug ('AWARD LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');

7286: --===============================================================================
7287: -- AWARD LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
7288: --===============================================================================
7289: IF g_debug = 'Y' THEN
7290: gms_error_pkg.gms_debug ('AWARD LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
7291: END IF;
7292: g_error_stage := 'FC PR : AWARD A/P B';
7293: -- Bug 2092791
7294: UPDATE gms_bc_packets bp

Line 7409: gms_error_pkg.gms_debug ('AWARD: Result Code ', 'C');

7405: -- F90 : Transaction failed funds check at Award level
7406: -- ================================================================================
7407: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
7408: IF g_debug = 'Y' THEN
7409: gms_error_pkg.gms_debug ('AWARD: Result Code ', 'C');
7410: END IF;
7411: g_error_stage := 'FC PR : AWARD RESULT';
7412: UPDATE gms_bc_packets bp
7413: SET bp.award_result_code = DECODE (

Line 7523: gms_error_pkg.gms_debug ('AFTER FUNDS CHECK', 'C');

7519: -- in gms_fck.when_other commit;
7520:
7521: RETURN (TRUE);
7522: IF g_debug = 'Y' THEN
7523: gms_error_pkg.gms_debug ('AFTER FUNDS CHECK', 'C');
7524: END IF;
7525: END gms_fc_process;
7526:
7527: --------------------------------------------------------------------------------------------------------------------------------------------------

Line 7550: gms_error_pkg.gms_debug (g_error_procedure_name||':x_sobid,x_arrival_seq-'||x_sobid||','||x_arrival_seq, 'C');

7546: x_error_code :=0;
7547: x_error_buff :=null;
7548:
7549: IF g_debug = 'Y' THEN
7550: gms_error_pkg.gms_debug (g_error_procedure_name||':x_sobid,x_arrival_seq-'||x_sobid||','||x_arrival_seq, 'C');
7551: END IF;
7552:
7553: -- If Mode is Unreservation, assign Packet ID to Unreservation Packet ID
7554: -- and initialize Packet ID to 0. This is done here to prevent the approved

Line 7566: gms_error_pkg.gms_debug (g_error_procedure_name||'Calling gms_setup', 'C' );

7562: -- ------------------------------------------------------------
7563: -- Setup and Summarization
7564: -- ('********* Calling GMS_SETUP *****************');
7565: -- ------------------------------------------------------------
7566: gms_error_pkg.gms_debug (g_error_procedure_name||'Calling gms_setup', 'C' );
7567: g_error_stage := 'gms_setup';
7568: IF NOT gms_setup (x_packetid, x_mode, x_partial,x_err_code,x_err_buff) THEN
7569: RETURN (FALSE);
7570: END IF;

Line 7584: gms_error_pkg.gms_debug ('BEFORE BASELINE', 'C');

7580:
7581: g_error_stage := 'gms_fc_process';
7582: IF x_mode IN ('S', 'B') THEN
7583: IF g_debug = 'Y' THEN
7584: gms_error_pkg.gms_debug ('BEFORE BASELINE', 'C');
7585: END IF;
7586: budget_fundscheck (x_packetid,x_err_code,x_err_buff);
7587: status_code_update (x_packetid, x_mode);
7588: IF g_debug = 'Y' THEN

Line 7589: gms_error_pkg.gms_debug ('AFTER BASELINE', 'C');

7585: END IF;
7586: budget_fundscheck (x_packetid,x_err_code,x_err_buff);
7587: status_code_update (x_packetid, x_mode);
7588: IF g_debug = 'Y' THEN
7589: gms_error_pkg.gms_debug ('AFTER BASELINE', 'C');
7590: END IF;
7591: ELSE
7592: IF NOT gms_fc_process (x_packetid,x_arrival_seq,x_mode) THEN -- Bug 2176230
7593: RETURN (FALSE);

Line 7597: gms_error_pkg.gms_debug ( 'GMS_FCP-After Calling gms_fc_process', 'C' );

7593: RETURN (FALSE);
7594: END IF;
7595: END IF;
7596: IF g_debug = 'Y' THEN
7597: gms_error_pkg.gms_debug ( 'GMS_FCP-After Calling gms_fc_process', 'C' );
7598: gms_error_pkg.gms_debug ( 'GMS_FCP-END', 'C' );
7599: END IF;
7600: RETURN (TRUE);
7601: END gms_fcp;

Line 7598: gms_error_pkg.gms_debug ( 'GMS_FCP-END', 'C' );

7594: END IF;
7595: END IF;
7596: IF g_debug = 'Y' THEN
7597: gms_error_pkg.gms_debug ( 'GMS_FCP-After Calling gms_fc_process', 'C' );
7598: gms_error_pkg.gms_debug ( 'GMS_FCP-END', 'C' );
7599: END IF;
7600: RETURN (TRUE);
7601: END gms_fcp;
7602:

Line 7695: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );

7691: END;
7692:
7693: IF x_result_code = 'F' THEN
7694: IF g_debug = 'Y' THEN
7695: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );
7696: END IF;
7697:
7698: status_code_update (x_packetid, 'E');
7699: x_e_code := 'H';

Line 7703: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );

7699: x_e_code := 'H';
7700:
7701: ELSE -- update gms_bc_packets with approved status
7702: IF g_debug = 'Y' THEN
7703: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );
7704: END IF;
7705: status_code_update (x_packetid, 'E');
7706: x_e_code := 'S';
7707: END IF;

Line 7826: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');

7822: g_error_procedure_name := 'Gms_fck_init';
7823: g_error_stage := 'Initalize Global Variables';
7824:
7825: IF g_debug = 'Y' THEN
7826: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');
7827: END IF;
7828:
7829: -- ==================================
7830: -- 1. Initalize global variables ...

Line 7841: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');

7837: -- ==================================
7838: g_error_stage := 'Derive doc_type';
7839:
7840: IF g_debug = 'Y' THEN
7841: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');
7842: END IF;
7843:
7844: If g_mode = 'X' then -- p_mode check - I
7845: g_doc_type := 'EXP';

Line 7884: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Derived value of document type '||g_doc_type,'C');

7880: END IF;
7881: END IF;
7882:
7883: IF g_debug = 'Y' THEN
7884: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Derived value of document type '||g_doc_type,'C');
7885: END IF;
7886:
7887: End if; -- p_mode check - I
7888:

Line 7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');

7886:
7887: End if; -- p_mode check - I
7888:
7889: IF g_debug = 'Y' THEN
7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');

Line 7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');

7887: End if; -- p_mode check - I
7888:
7889: IF g_debug = 'Y' THEN
7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');

Line 7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');

7888:
7889: IF g_debug = 'Y' THEN
7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
7896: END IF;

Line 7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');

7889: IF g_debug = 'Y' THEN
7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
7896: END IF;
7897:

Line 7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');

7890: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
7896: END IF;
7897:
7898: -- ======================================

Line 7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');

7891: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
7892: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
7893: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
7894: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
7895: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
7896: END IF;
7897:
7898: -- ======================================
7899: -- 3. Initalize global variables - part B

Line 7932: gms_error_pkg.gms_debug ('GMS_FCK-derived values :g_derived_mode,g_partial_flag:'

7928: End If;
7929:
7930:
7931: IF g_debug = 'Y' THEN
7932: gms_error_pkg.gms_debug ('GMS_FCK-derived values :g_derived_mode,g_partial_flag:'
7933: ||g_derived_mode||','||g_partial_flag,'C');
7934: END IF;
7935:
7936: -- Initialize currency precision variables ..

Line 8209: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : packet_id = '|| p_packet_id,'C');

8205:
8206: BEGIN
8207:
8208: IF g_debug = 'Y' THEN
8209: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : packet_id = '|| p_packet_id,'C');
8210: END IF;
8211:
8212: -- Get the packet_id that was establised earlier ..
8213: OPEN get_temp_packet_id;

Line 8219: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Previously establised packet is = '|| l_gms_packet_id,'C');

8215:
8216: IF get_temp_packet_id%FOUND THEN
8217:
8218: IF g_debug = 'Y' THEN
8219: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Previously establised packet is = '|| l_gms_packet_id,'C');
8220: END IF;
8221:
8222: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated
8223: correctly for an invoice matched to a PO scenario. Before this change , the same gl_bc_packets_rowid was updated on

Line 8235: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: glbcrec.source_distribution_type:'|| glbcrec.source_distribution_type,'C');

8231:
8232: FOR glbcrec in c_gl_bc_pkt LOOP
8233:
8234: IF g_debug = 'Y' THEN
8235: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: glbcrec.source_distribution_type:'|| glbcrec.source_distribution_type,'C');
8236: END IF;
8237:
8238: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8239: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..

Line 8242: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Derive prepay dist id ','C');

8238: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8239: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..
8240:
8241: IF g_debug = 'Y' THEN
8242: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Derive prepay dist id ','C');
8243: END IF;
8244:
8245: For x in g_ap_prepay_app_dist_id.FIRST..g_ap_prepay_app_dist_id.LAST loop
8246:

Line 8248: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: g_ap_prepay_app_dist_id(x)'||g_ap_prepay_app_dist_id(x),'C');

8244:
8245: For x in g_ap_prepay_app_dist_id.FIRST..g_ap_prepay_app_dist_id.LAST loop
8246:
8247: IF g_debug = 'Y' THEN
8248: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: g_ap_prepay_app_dist_id(x)'||g_ap_prepay_app_dist_id(x),'C');
8249: END IF;
8250:
8251: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8252: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl

Line 8258: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Found prepay dist,its:'||l_dist_id,'C');

8254:
8255: l_dist_id := g_doc_dist_id_tab(x);
8256:
8257: If g_debug = 'Y' THEN
8258: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Found prepay dist,its:'||l_dist_id,'C');
8259: End If;
8260:
8261: EXIT;
8262: END IF;

Line 8330: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets except PO matched to an invoice '|| SQL%ROWCOUNT,'C');

8326:
8327: END LOOP;
8328:
8329: IF g_debug = 'Y' THEN
8330: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets except PO matched to an invoice '|| SQL%ROWCOUNT,'C');
8331: END IF;
8332:
8333: -- If it's PO mathed to an AP then for the PO reversal record in gl_bc_packets source_distribution_id_num_1 is populated as invoice_distribution_id
8334: -- whereas for the corresponding record gms_bc_packets will have source_distribution_id_num_1 as po_distribution_id

Line 8364: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for PO matched to an invoice '|| SQL%ROWCOUNT,'C');

8360: and gbc.status_code = 'I'
8361: and gbc.document_type ='PO';
8362:
8363: IF g_debug = 'Y' THEN
8364: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for PO matched to an invoice '|| SQL%ROWCOUNT,'C');
8365: END IF;
8366:
8367: /* Bug 5645290 - Start */
8368: Update gms_bc_packets gbc

Line 8390: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for prepayment burden adjustment lines '|| SQL%ROWCOUNT,'C');

8386: and gbc.status_code = 'I'
8387: and gbc.gl_bc_packets_rowid IS NULL;
8388:
8389: IF g_debug = 'Y' THEN
8390: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for prepayment burden adjustment lines '|| SQL%ROWCOUNT,'C');
8391: END IF;
8392: /* Bug 5645290 - End */
8393:
8394: END IF;

Line 8398: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : End ','C');

8394: END IF;
8395: CLOSE get_temp_packet_id;
8396:
8397: IF g_debug = 'Y' THEN
8398: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : End ','C');
8399: END IF;
8400:
8401: End Synch_gms_gl_packets;
8402:

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

8455:
8456: x_err_code := 0;
8457: x_err_buff := null;
8458:
8459: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
8460:
8461: IF g_debug = 'Y' THEN
8462: gms_error_pkg.gms_debug (g_error_procedure_name||':packet,x_mode,x_partial:'||
8463: g_packet_id||','||g_mode||','||x_partial,'C');

Line 8462: gms_error_pkg.gms_debug (g_error_procedure_name||':packet,x_mode,x_partial:'||

8458:
8459: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
8460:
8461: IF g_debug = 'Y' THEN
8462: gms_error_pkg.gms_debug (g_error_procedure_name||':packet,x_mode,x_partial:'||
8463: g_packet_id||','||g_mode||','||x_partial,'C');
8464: END IF;
8465:
8466: -- ---------------------------------------------------------------------------------------------------------+

Line 8476: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8472: -- 2. Call gms_fck_init
8473: -------------------------------------------------------------------------------+
8474: x_e_stage := 'Before gms_fck_init call';
8475: IF g_debug = 'Y' THEN
8476: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8477: END IF;
8478:
8479: gms_fck_init(p_partial_flag => x_partial);
8480:

Line 8490: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8486: If g_non_gms_txn then
8487: x_e_stage := 'All txns. non-gms, exit GMS-FC';
8488:
8489: IF g_debug = 'Y' THEN
8490: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8491: END IF;
8492:
8493: x_return_code := 'S';
8494: RETURN g_non_gms_txn;

Line 8510: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8506: -- This procedure will delete pending records from gms_bc_packets
8507: -------------------------------------------------------------------------------+
8508: x_e_stage := 'delete_pending_txns';
8509: IF g_debug = 'Y' THEN
8510: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8511: END IF;
8512:
8513: delete_pending_txns(x_err_code,x_err_buff);
8514:

Line 8536: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8532: -- R12 Funds Management Uptake : R12 open issue
8533: IF g_doc_type = 'AP' and x_mode = 'R' then
8534: x_e_stage := 'si_adjustments';
8535: IF g_debug = 'Y' THEN
8536: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8537: END IF;
8538:
8539: si_adjustments(x_packetid, l_pkt_row) ;
8540: IF l_pkt_row = 0 THEN

Line 8559: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8555:
8556: IF g_debug = 'Y' THEN
8557: g_error_procedure_name := 'Gms_fck';
8558: x_e_stage := 'ENC:Derive ind';
8559: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8560: End If;
8561:
8562: CALC_ENC_IND_COMPILED_SET_ID (x_packetid);
8563:

Line 8567: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8563:
8564: IF g_debug = 'Y' THEN
8565: g_error_procedure_name := 'Gms_fck';
8566: x_e_stage := 'ENC:Handle_net_zero_txn:Net_Zero';
8567: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8568: End If;
8569: -- Check if adjusted and adjusting transactions are present in the same packet
8570: -- If so, update them with result_code 'P82' and update effect_on_funds_code
8571: -- to 'I' so that 'funds avilable' calculation ignores them.

Line 8578: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8574:
8575: IF g_debug = 'Y' THEN
8576: g_error_procedure_name := 'Gms_fck';
8577: x_e_stage := 'ENC:Handle_net_zero_txn:Check_Adjusted';
8578: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8579: End If;
8580: -- Fail adjusting transaction, if original transaction has not been FC'ed(F08)
8581:
8582: HANDLE_NET_ZERO_TXN(x_packetid, 'Check_Adjusted');

Line 8600: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8596: -- Calling burden calculation for all except for mode : Submit,Baseline,Interface
8597: IF g_debug = 'Y' THEN
8598: x_e_stage := 'Burdenable Raw Cost calculation';
8599: g_error_procedure_name := 'Gms_fck';
8600: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8601: END IF;
8602:
8603: -- 8A. CALCULATING BURDENABLE RAW COST
8604: -- pass g_derived_mode parameter ...

Line 8632: gms_error_pkg.gms_debug (

8628: -- R12 Funds Management Uptake : burden calculation logic for x_mode ='R'/'U'/'C'
8629: -- shifted to main session procedure copy_gl_pkt_to_gms_pkt.
8630:
8631: IF g_debug = 'Y' THEN
8632: gms_error_pkg.gms_debug (
8633: 'GMS_FCK-After Calling gms_cost_plus_extn.update_bc_pkt_burden_raw_cost','C');
8634: END IF;
8635:
8636: END IF;

Line 8647: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8643:
8644: x_e_stage := 'misc_gms_idc';
8645: IF g_debug = 'Y' THEN
8646: g_error_procedure_name := 'Gms_fck';
8647: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8648: END IF;
8649:
8650: IF NOT misc_gms_idc (x_packetid) THEN
8651: RETURN (FALSE);

Line 8664: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8660:
8661: x_e_stage := 'gms_fcp';
8662: IF g_debug = 'Y' THEN
8663: g_error_procedure_name := 'Gms_fck';
8664: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8665: END IF;
8666:
8667: -- pass g_derived_mode parameter ...
8668: IF NOT gms_fcp (x_sobid, x_packetid, g_derived_mode, g_partial_flag, x_arrival_seq,

Line 8676: gms_error_pkg.gms_debug ('GMS_FCK-After Calling gms_fcp', 'C');

8672:
8673: COMMIT;
8674:
8675: IF g_debug = 'Y' THEN
8676: gms_error_pkg.gms_debug ('GMS_FCK-After Calling gms_fcp', 'C');
8677: END IF;
8678:
8679: -------------------------------------------------------------------------------+
8680: -- 11. Posting for encumbrances ..

Line 8687: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8683: x_e_stage := 'Posting for encumbrances';
8684: g_error_procedure_name := 'Gms_fck';
8685: --g_error_procedure_name := 'update_source_burden_raw_cost';
8686: IF g_debug = 'Y' THEN
8687: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8688: END IF;
8689:
8690: IF NOT gms_cost_plus_extn.update_source_burden_raw_cost (x_packetid, x_mode, g_partial_flag) THEN
8691: IF g_debug = 'Y' THEN

Line 8692: gms_error_pkg.gms_debug ('GMS_FCK- Posting for encumbrances ..failed','C');

8688: END IF;
8689:
8690: IF NOT gms_cost_plus_extn.update_source_burden_raw_cost (x_packetid, x_mode, g_partial_flag) THEN
8691: IF g_debug = 'Y' THEN
8692: gms_error_pkg.gms_debug ('GMS_FCK- Posting for encumbrances ..failed','C');
8693: END IF;
8694: result_status_code_update (
8695: p_packet_id=> x_packetid,
8696: p_status_code=> 'T',

Line 8712: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8708:
8709: x_e_stage := 'Update status on failed bcpkt';
8710: IF g_debug = 'Y' THEN
8711: g_error_procedure_name := 'Gms_fck';
8712: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8713: END IF;
8714:
8715: update_status_on_failed_txns(x_packetid);
8716:

Line 8729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');

8725: If x_mode in ('R','U','C','E','S','B') then
8726: x_e_stage := 'Determine return code';
8727: IF g_debug = 'Y' THEN
8728: g_error_procedure_name := 'Gms_fck';
8729: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8730: END IF;
8731:
8732: IF NOT gms_return_code (x_packetid, g_derived_mode, g_partial_flag, x_return_code, x_e_code, x_err_buff) THEN
8733: RETURN FALSE;

Line 8738: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage||':return code'||x_return_code,'C');

8734: END IF;
8735:
8736: IF g_debug = 'Y' THEN
8737: g_error_procedure_name := 'Gms_fck';
8738: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage||':return code'||x_return_code,'C');
8739: END IF;
8740: End If;
8741:
8742: <>

Line 8744: gms_error_pkg.gms_debug (' End of GMS_FCK ', 'C');

8740: End If;
8741:
8742: <>
8743: IF g_debug = 'Y' THEN
8744: gms_error_pkg.gms_debug (' ********** End of GMS_FCK ********** ', 'C');
8745: END IF;
8746: COMMIT;
8747:
8748: RETURN (TRUE);

Line 8757: gms_error_pkg.gms_message (

8753: x_e_stage := SQLCODE||' '||SQLERRM; -- Bug 2337897 : Added SQLCODE
8754: g_return_code := 'T';
8755: x_return_code := 'T';
8756:
8757: gms_error_pkg.gms_message (
8758: x_err_name=> 'GMS_UNEXPECTED_ERROR',
8759: x_token_name1=> 'PROGRAM_NAME',
8760: x_token_val1=> g_error_program_name || '.' || g_error_procedure_name || '.' || g_error_stage,
8761: x_token_name2=> 'SQLCODE',