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 478: gms_error_pkg.gms_debug (SQL%rowcount||' records updated','C');

474: );
475:
476:
477: IF g_debug = 'Y' THEN
478: gms_error_pkg.gms_debug (SQL%rowcount||' records updated','C');
479: END IF;
480:
481: End If;
482:

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

611: Begin
612: g_error_procedure_name := 'Handle_net_zero_txn' ;
613: g_error_stage := 'Net Zero - ENC';
614:
615: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : Start','C');
616: gms_error_pkg.gms_debug ( 'p_mode : '||p_mode,'C');
617:
618: If p_mode = 'Check_Adjusted' then
619: -- Fail adjusting txn. If adjusted has not been funds checked -F08

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

612: g_error_procedure_name := 'Handle_net_zero_txn' ;
613: g_error_stage := 'Net Zero - ENC';
614:
615: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : Start','C');
616: gms_error_pkg.gms_debug ( 'p_mode : '||p_mode,'C');
617:
618: If p_mode = 'Check_Adjusted' then
619: -- Fail adjusting txn. If adjusted has not been funds checked -F08
620: update gms_bc_packets gbc

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

655: and nvl(ind_compiled_set_id,-1) = recs.ind_compiled_set_id;
656:
657: g_bc_packet_has_P82_records := 'Y' ;
658: end loop;
659: gms_error_pkg.gms_debug ( 'Handle_net_zero_txn : End','C');
660:
661: End If;
662:
663: COMMIT;

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

686: t_exp_org t_exp_org_type;
687: t_ind_set t_ind_set_type;
688:
689: Begin
690: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : Start','C');
691:
692: -- This part of the code will take care of non-net zero encumbrance items or
693: -- the original (adjusted) net zero item
694:

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

766: adjusted_document_header_id = document_header_id);
767:
768: End If; --If t_project_id.COUNT > 0 then
769:
770: gms_error_pkg.gms_debug ( 'After Bulk processing','C');
771: -- =============================================================
772: -- This part of the code will take care of the reversing (adjusting) net zero item
773: -- =============================================================
774:

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

794: and gbc.adjusted_document_header_id is not NULL
795: and nvl(gbc.burden_adjustment_flag,'N') = 'N' -- 3389292
796: and gbc.adjusted_document_header_id <> gbc.document_header_id;
797:
798: gms_error_pkg.gms_debug ( 'After Update 1','C');
799: -- Bug#6075039 Modified the sub query for performance issue.
800: -- Update 2 : For Adjusting (Reversing) transactions whose original transaction
801: -- was funds checked earlier
802: Update gms_bc_packets gbc

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

817: and gbc.adjusted_document_header_id is not NULL
818: and nvl(gbc.burden_adjustment_flag,'N') = 'N' -- 3389292
819: and gbc.adjusted_document_header_id <> gbc.document_header_id;
820:
821: gms_error_pkg.gms_debug ( 'Calc_enc_ind_compiled_set_id : End','C');
822:
823: COMMIT;
824:
825: End Calc_enc_ind_compiled_set_id;

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

965: BEGIN
966: g_error_procedure_name := 'status_code_update';
967: g_error_stage := 'SCU : START';
968: IF g_debug = 'Y' THEN
969: gms_error_pkg.gms_debug ( 'STATUS_CODE_UPDATE - START ','C');
970: END IF;
971:
972: If g_partial_flag = 'N' then
973:

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

1001: UPDATE gms_bc_packets
1002: SET status_code = decode(p_mode,'S','S','B','B','C','C','A')
1003: WHERE packet_id = p_packet_id;
1004: IF g_debug = 'Y' THEN
1005: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - SUBMIT UPDATE FOR PASS TRANSACTIONS', 'C');
1006: END IF;
1007: END IF;
1008: CLOSE c_failed_packet;
1009: -- -------------------------------- PARTIAL MODE START ---------------------------------------------+

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

1018: WHERE packet_id = p_packet_id;
1019:
1020: IF SQL%NOTFOUND THEN
1021: IF g_debug = 'Y' THEN
1022: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED IN PARTIAL MODE', 'C');
1023: END IF;
1024: END IF;
1025: g_error_stage := 'SCU : PARTIAL YES RES';
1026:

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

1025: g_error_stage := 'SCU : PARTIAL YES RES';
1026:
1027: ELSE
1028: IF g_debug = 'Y' THEN
1029: gms_error_pkg.gms_debug ('STATUS_CODE_UPDATE - NO RECORDS UPDATED ', 'C');
1030: END IF;
1031: END IF;
1032:
1033: -- --------------------------------------------------------------------------------------------------+

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

1261: x_err_code NUMBER;
1262: x_err_buff VARCHAR2 (2000);
1263: BEGIN
1264: IF g_debug = 'Y' THEN
1265: gms_error_pkg.gms_debug ('BEGIN result_status_code_update', 'C');
1266: END IF;
1267: g_error_procedure_name := 'result_status_code_update' ;
1268:
1269: IF p_bc_packet_id is NULL THEN

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

1286:
1287: END IF;
1288:
1289: IF g_debug = 'Y' THEN
1290: gms_error_pkg.gms_debug ('END result_status_code_update', 'C');
1291: END IF;
1292: x_err_code := 0;
1293: END result_status_code_update;
1294:

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

1717:
1718: BEGIN
1719:
1720: IF g_debug = 'Y' THEN
1721: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Start','C');
1722: END IF;
1723:
1724: -- Burdenable raw cost calculation procedure returned FALSE due to exception
1725:

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

1725:
1726: IF p_result_code = 'F' THEN
1727:
1728: IF g_debug = 'Y' THEN
1729: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms and gl packets to failed status F76/F67','C');
1730: END IF;
1731:
1732: result_status_code_update ( p_packet_id=> p_packet_id,
1733: p_status_code=> 'T',

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

1757:
1758: IF l_count <> 0 THEN
1759:
1760: IF g_debug = 'Y' THEN
1761: gms_error_pkg.gms_debug ('UPDATE_BC_PKT_BRC_STATUS'||':'|| 'Updating gms packets to Full mode failure','C');
1762: END IF;
1763:
1764: -- If failure, update result/status code
1765: Update gms_bc_packets

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

1831:
1832: BEGIN
1833:
1834: IF g_debug = 'Y' THEN
1835: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Start','C');
1836: END IF;
1837:
1838:
1839: l_rec_count := p_set_of_books_id_tab.count();

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

1838:
1839: l_rec_count := p_set_of_books_id_tab.count();
1840:
1841: IF g_debug = 'Y' THEN
1842: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Intializing local variables','C');
1843: END IF;
1844:
1845: p_return_code := 'P';
1846: l_request_id := fnd_global.conc_request_id;

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

1857:
1858: IF l_rec_count > 0 Then
1859:
1860: IF g_debug = 'Y' THEN
1861: gms_error_pkg.gms_debug ('Load_gms_pkts'||':'|| 'Starting loop to insert '||l_rec_count||'into gms_bc_packets','C');
1862: END IF;
1863:
1864: FORALL i IN 1 .. l_rec_count
1865: INSERT INTO gms_bc_packets

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

1958:
1959: EXCEPTION
1960: WHEN OTHERS THEN
1961: IF g_debug = 'Y' THEN
1962: gms_error_pkg.gms_debug ('Load_gms_pkts - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');
1963: END IF;
1964: p_return_code := 'F';
1965: END Load_gms_pkts;
1966:

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

1978: p_entered_cr IN NUMBER) IS
1979: BEGIN
1980:
1981: IF g_debug = 'Y' THEN
1982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');

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

1979: BEGIN
1980:
1981: IF g_debug = 'Y' THEN
1982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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 1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');

1980:
1981: IF g_debug = 'Y' THEN
1982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');

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

1981: IF g_debug = 'Y' THEN
1982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1989: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');

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

1982: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - Start','C');
1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1989: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1990: END IF;

Line 1987: 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');

1983: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_copy_from_index ='||p_copy_from_index,'C');
1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1989: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1990: END IF;
1991:

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

1984: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_new_rec_index ='||p_new_rec_index,'C');
1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1989: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1990: END IF;
1991:
1992: g_je_source_name_tab(p_new_rec_index) := g_je_source_name_tab(p_copy_from_index);

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

1985: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_document_type ='||p_document_type,'C');
1986: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_po_vendor_id ='||p_po_vendor_id,'C');
1987: 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');
1988: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_dr ='||p_entered_dr,'C');
1989: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of parameter p_entered_cr ='||p_entered_cr,'C');
1990: END IF;
1991:
1992: g_je_source_name_tab(p_new_rec_index) := g_je_source_name_tab(p_copy_from_index);
1993: g_je_category_name_tab(p_new_rec_index) := g_je_category_name_tab(p_copy_from_index);

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

2041:
2042: END IF;
2043:
2044: IF g_debug = 'Y' THEN
2045: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - End','C');
2046: END IF;
2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN

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

2047:
2048: EXCEPTION
2049: WHEN OTHERS THEN
2050: IF g_debug = 'Y' THEN
2051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'COPY_AP_RECORD - exception'||SQLERRM,'C');
2052: END IF;
2053: RAISE;
2054: END COPY_AP_RECORD;
2055:

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

2070:
2071: BEGIN
2072:
2073: IF g_debug = 'Y' THEN
2074: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Start','C');
2075: END IF;
2076:
2077: -- Below is the logic of splitting AP line into multiple bc records
2078: -- 1.IF po_distribution id populated then create PO relieving record

Line 2095: 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');

2091: Else
2092: Copy accounted amounts for PO relieving record from those on the invoice */
2093: If g_po_rate_tab(p_copy_from_index) is NOT NULL then
2094: IF g_debug = 'Y' THEN
2095: 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');
2096: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Rate : '||g_po_rate_tab(p_copy_from_index),'C');
2097: END IF;
2098: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2099: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);

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

2092: Copy accounted amounts for PO relieving record from those on the invoice */
2093: If g_po_rate_tab(p_copy_from_index) is NOT NULL then
2094: IF g_debug = 'Y' THEN
2095: 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');
2096: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - Rate : '||g_po_rate_tab(p_copy_from_index),'C');
2097: END IF;
2098: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2099: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2100: else

Line 2102: 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');

2098: l_entered_dr := g_txn_cr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2099: l_entered_cr := g_txn_dr_tab(p_copy_from_index) * g_po_rate_tab(p_copy_from_index);
2100: else
2101: IF g_debug = 'Y' THEN
2102: 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');
2103: END IF;
2104: l_entered_dr := g_entered_cr_tab(p_copy_from_index);
2105: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2106: end if;

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

2104: l_entered_dr := g_entered_cr_tab(p_copy_from_index);
2105: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2106: end if;
2107: IF g_debug = 'Y' THEN
2108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_dr : '||l_entered_dr,'C');
2109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_cr : '||l_entered_cr,'C');
2110: END IF;
2111:
2112: COPY_AP_RECORD (p_copy_from_index => p_copy_from_index,

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

2105: l_entered_cr := g_entered_dr_tab(p_copy_from_index);
2106: end if;
2107: IF g_debug = 'Y' THEN
2108: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_dr : '||l_entered_dr,'C');
2109: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - PO relieving record - l_entered_cr : '||l_entered_cr,'C');
2110: END IF;
2111:
2112: COPY_AP_RECORD (p_copy_from_index => p_copy_from_index,
2113: p_new_rec_index => l_new_rec_index,

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

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

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

2155: g_burdenable_raw_cost_tab(l_new_rec_index):= 0;
2156: END IF;
2157:
2158: IF g_debug = 'Y' THEN
2159: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for amount varaince','C');
2160: END IF;
2161:
2162: END IF; --IF NVL(g_tab_ap_amount_variance(p_copy_from_index),0) <> 0 THEN
2163:

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

2164:
2165: IF NVL(g_quantity_variance_tab(p_copy_from_index),0) <> 0 THEN
2166:
2167: IF g_debug = 'Y' THEN
2168: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling CREATE_APVAR_RECORD for qty varaince','C');
2169: END IF;
2170:
2171: l_new_rec_index := l_new_rec_index + 1;
2172:

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

2191: g_burdenable_raw_cost_tab(l_new_rec_index):= 0;
2192: END IF;
2193:
2194: IF g_debug = 'Y' THEN
2195: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After call to CREATE_APVAR_RECORD for qty varaince','C');
2196: END IF;
2197:
2198: END IF; --IF NVL(g_quantity_variance_tab(p_copy_from_index),0) <> 0 THEN
2199:

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

2199:
2200: p_new_rec_index := l_new_rec_index;
2201:
2202: IF g_debug = 'Y' THEN
2203: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - End','C');
2204: END IF;
2205:
2206: EXCEPTION
2207: WHEN OTHERS THEN

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

2206: EXCEPTION
2207: WHEN OTHERS THEN
2208:
2209: IF g_debug = 'Y' THEN
2210: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'CREATE_BACKING_PO_APVAR_REC - EXception','C');
2211: END IF;
2212:
2213: RAISE;
2214:

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

2860: PROCEDURE DERIVE_DR_CR IS
2861: BEGIN
2862:
2863: IF g_debug = 'Y' THEN
2864: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start of DERIVE_DR_CR ','C');
2865: END IF;
2866:
2867: FOR l_index IN 1..g_set_of_books_id_tab.Last LOOP
2868:

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

2910:
2911: END IF;
2912:
2913: IF g_debug = 'Y' THEN
2914: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2915: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2916: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2917: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2918: END IF;

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

2911: END IF;
2912:
2913: IF g_debug = 'Y' THEN
2914: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2915: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2916: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2917: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2918: END IF;
2919:

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

2912:
2913: IF g_debug = 'Y' THEN
2914: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2915: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2916: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2917: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2918: END IF;
2919:
2920:

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

2913: IF g_debug = 'Y' THEN
2914: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_main_or_backing_tab '||g_main_or_backing_tab(l_index),'C');
2915: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_event_type_code_tab '||g_event_type_code_tab(l_index),'C');
2916: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_cr_tab '||g_entered_cr_tab(l_index),'C');
2917: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'value of g_entered_dr_tab '||g_entered_dr_tab(l_index),'C');
2918: END IF;
2919:
2920:
2921: END LOOP;

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

2920:
2921: END LOOP;
2922:
2923: IF g_debug = 'Y' THEN
2924: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End of DERIVE_DR_CR ','C');
2925: END IF;
2926:
2927: END DERIVE_DR_CR;
2928:

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

2938: l_mode := 'R';
2939: END IF;
2940:
2941: IF g_debug = 'Y' THEN
2942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start','C');
2943: END IF;
2944:
2945: -- Initializing OUT variables
2946: x_return_code := 'P';

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

2950: INTO l_packet_id
2951: FROM dual;
2952:
2953: IF g_debug = 'Y' THEN
2954: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Intialize_tabs','C');
2955: END IF;
2956:
2957: Intialize_tabs;
2958:

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

2962: -- Fetch AP/PO/REQ data associted with sponsored Project.No other validations performed
2963: IF p_application_id = 200 THEN -- Payables is the Calling application
2964:
2965: IF g_debug = 'Y' THEN
2966: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 200 ','C');
2967: END IF;
2968:
2969: OPEN c_awrd_ap_dist;
2970: FETCH c_awrd_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;

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

2970: FETCH c_awrd_ap_dist BULK COLLECT INTO g_ap_inv_dist_id,g_ap_line_type_lkup;
2971: CLOSE c_awrd_ap_dist;
2972:
2973: IF g_debug = 'Y' THEN
2974: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Number of AP distribuions fetched ='||g_ap_inv_dist_id.count,'C');
2975: END IF;
2976:
2977: IF g_ap_inv_dist_id.count <> 0 THEN
2978:

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

2995:
2996: END LOOP;
2997:
2998: IF g_debug = 'Y' THEN
2999: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
3000: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
3001: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
3002: End if;
3003:

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

2996: END LOOP;
2997:
2998: IF g_debug = 'Y' THEN
2999: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
3000: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
3001: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
3002: End if;
3003:
3004: OPEN cur_ap_bc_dist(l_stdinvoice_exists,l_prepay_exists);

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

2997:
2998: IF g_debug = 'Y' THEN
2999: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists PREPAY distribution ? '||l_prepay_exists,'C');
3000: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'For current run there exists Std Invoice distribution ? '||l_stdinvoice_exists,'C');
3001: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching required data from AP extract into plsql tables','C');
3002: End if;
3003:
3004: OPEN cur_ap_bc_dist(l_stdinvoice_exists,l_prepay_exists);
3005: FETCH cur_ap_bc_dist BULK COLLECT INTO

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

3044: CLOSE cur_ap_bc_dist;
3045:
3046: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3047: FOR i in 1..g_doc_dist_id_tab.count LOOP
3048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

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

3045:
3046: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3047: FOR i in 1..g_doc_dist_id_tab.count LOOP
3048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

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

3046: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3047: FOR i in 1..g_doc_dist_id_tab.count LOOP
3048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

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

3047: FOR i in 1..g_doc_dist_id_tab.count LOOP
3048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

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

3048: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from AP extract'||-i,'C');
3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

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

3049: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

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

3050: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

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

3051: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

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

3052: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

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

3053: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

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

3054: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

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

3055: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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 3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

3056: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

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

3057: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

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

3058: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 3063: 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');

3059: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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 3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

3060: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

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

3061: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

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

3062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

Line 3067: 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');

3063: 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');
3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

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

3064: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3072: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');

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

3065: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3072: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
3073: END LOOP;

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

3066: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3072: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
3073: END LOOP;
3074: End if;

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

3067: 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');
3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3072: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
3073: END LOOP;
3074: End if;
3075:

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

3068: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3069: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3070: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3071: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3072: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from AP extract'||-i,'C');
3073: END LOOP;
3074: End if;
3075:
3076: END IF;--IF g_ap_inv_dist_id.count <> 0 THEN

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

3077:
3078: ELSIF p_application_id = 201 THEN -- Purchasing is the Calling application
3079:
3080: IF g_debug = 'Y' THEN
3081: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Inside p_application_id = 201 ','C');
3082: END IF;
3083:
3084: OPEN c_REQ_PO_pkt_rec;
3085: FETCH c_REQ_PO_pkt_rec BULK COLLECT INTO

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

3111: CLOSE c_REQ_PO_pkt_rec;
3112:
3113: IF g_doc_dist_id_tab.count <> 0 THEN
3114: IF g_debug = 'Y' THEN
3115: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling DERIVE_DR_CR ','C');
3116: END IF;
3117: DERIVE_DR_CR;
3118: END IF;
3119:

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

3118: END IF;
3119:
3120: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3121: FOR i in 1..g_doc_dist_id_tab.count LOOP
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');

Line 3123: 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');

3119:
3120: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3121: FOR i in 1..g_doc_dist_id_tab.count LOOP
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

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

3120: IF g_debug = 'Y' AND g_doc_dist_id_tab.count <> 0 THEN
3121: FOR i in 1..g_doc_dist_id_tab.count LOOP
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

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

3121: FOR i in 1..g_doc_dist_id_tab.count LOOP
3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

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

3122: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records fetched from PO GT table'||-i,'C');
3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');

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

3123: 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');
3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

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

3124: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

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

3125: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');

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

3126: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');

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

3127: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

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

3128: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

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

3129: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

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

3130: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_amount_tab ='||g_entered_amount_tab(i),'C');
3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

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

3131: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

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

3132: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

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

3133: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_event_type_code_tab ='||g_event_type_code_tab(i),'C');
3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');

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

3134: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_main_or_backing_tab ='||g_main_or_backing_tab(i),'C');
3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');

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

3135: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

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

3136: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

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

3137: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

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

3138: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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 3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

3139: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

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

3140: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');

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

3141: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');

Line 3146: 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');

3142: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
3150: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');

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

3143: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
3150: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
3151: END LOOP;

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

3144: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
3150: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
3151: END LOOP;
3152: End if;

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

3145: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
3150: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
3151: END LOOP;
3152: End if;
3153:

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

3146: 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');
3147: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3148: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference6_tab ='||g_reference6_tab(i),'C');
3149: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_reference13_tab ='||g_reference13_tab(i),'C');
3150: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records fetched from PO GT table '||-i,'C');
3151: END LOOP;
3152: End if;
3153:
3154: END IF;

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

3153:
3154: END IF;
3155:
3156: IF g_debug = 'Y' THEN
3157: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'After fetching data from AP/PO ','C');
3158: END IF;
3159:
3160: -- If no eligible GMS records to process then return with x_return_code as success ('P')
3161: IF g_doc_dist_id_tab.count = 0 THEN

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

3159:
3160: -- If no eligible GMS records to process then return with x_return_code as success ('P')
3161: IF g_doc_dist_id_tab.count = 0 THEN
3162: IF g_debug = 'Y' THEN
3163: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'NO records fetched from AP/PO extract,GOTO END_OF_PROCESS ','C');
3164: END IF;
3165: GOTO END_OF_PROCESS;
3166: END IF;
3167:

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

3165: GOTO END_OF_PROCESS;
3166: END IF;
3167:
3168: IF g_debug = 'Y' THEN
3169: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling misc_synch_adls','C');
3170: END IF;
3171:
3172: IF NOT misc_synch_adls (p_application_id) THEN -- Bug 5344693 : misc_synch_adls is called with correct application_id.
3173: x_return_code := 'F';

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

3171:
3172: IF NOT misc_synch_adls (p_application_id) THEN -- Bug 5344693 : misc_synch_adls is called with correct application_id.
3173: x_return_code := 'F';
3174: IF g_debug = 'Y' THEN
3175: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'misc_synch_adls returned false','C');
3176: END IF;
3177: -- misc_synch_adls raises if any exceptions so no need to handle exception
3178: GOTO END_OF_PROCESS;
3179: END IF;

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

3180:
3181: -- Start of Code to fire GMS specific validations
3182:
3183: IF g_debug = 'Y' THEN
3184: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id ','C');
3185: END IF;
3186:
3187: SELECT NVL (default_dist_award_id, 0),
3188: NVL (award_distribution_option, 'N')

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

3190: l_award_dist_option
3191: FROM gms_implementations;
3192:
3193: IF g_debug = 'Y' THEN
3194: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_award_dist_option = '||l_award_dist_option,'C');
3195: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_dist_award_id = '||l_dist_award_id,'C');
3196: END IF;
3197:
3198: IF l_award_dist_option = 'Y' THEN

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

3191: FROM gms_implementations;
3192:
3193: IF g_debug = 'Y' THEN
3194: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_award_dist_option = '||l_award_dist_option,'C');
3195: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching default award id l_dist_award_id = '||l_dist_award_id,'C');
3196: END IF;
3197:
3198: IF l_award_dist_option = 'Y' THEN
3199:

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

3214: x_adl_rec.last_update_login := 0;
3215: x_adl_rec.request_id := -9999;
3216:
3217: IF g_debug = 'Y' THEN
3218: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling gms_awards_dist_pkg.create_adls to create dummy ADL','C');
3219: END IF;
3220:
3221: gms_awards_dist_pkg.create_adls (x_adl_rec);
3222:

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

3227:
3228: IF g_document_type_tab(i) ='REQ' THEN
3229:
3230: IF g_debug = 'Y' THEN
3231: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching REQ data for distribution id '||g_doc_dist_id_tab(i),'C');
3232: END IF;
3233:
3234: OPEN c_req_adl_details(g_doc_dist_id_tab(i));
3235: FETCH c_req_adl_details INTO g_award_id_tab(i),

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

3239: IF c_req_adl_details%NOTFOUND THEN
3240:
3241: IF g_reference6_tab(i) = 'GMSIP' THEN -- If its an unsaved Iprocurement
3242: IF g_debug = 'Y' THEN
3243: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Its an unsaved GMSIP transaction' ,'C');
3244: END IF;
3245: IF g_award_id_tab(i)=l_dist_award_id THEN
3246: g_result_code_tab(i) :='F21';
3247: ELSIF g_award_id_tab(i) IS NULL THEN

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

3249: END IF;
3250: g_vendor_id_tab(i) :=g_reference13_tab(i);
3251: ELSE
3252: IF g_debug = 'Y' THEN
3253: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising REQ Data transfer failure F09' ,'C');
3254: END IF;
3255: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3256: END IF; --F g_reference6_tab(i) = 'GMSIP' THEN
3257:

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

3258: END IF;
3259: CLOSE c_req_adl_details;
3260:
3261: IF g_debug = 'Y' THEN
3262: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3263: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3264: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3265: 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');
3266: END IF;

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

3259: CLOSE c_req_adl_details;
3260:
3261: IF g_debug = 'Y' THEN
3262: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3263: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3264: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3265: 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');
3266: END IF;
3267:

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

3260:
3261: IF g_debug = 'Y' THEN
3262: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3263: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3264: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3265: 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');
3266: END IF;
3267:
3268: ELSIF g_document_type_tab(i) ='PO' THEN

Line 3265: 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');

3261: IF g_debug = 'Y' THEN
3262: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3263: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3264: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3265: 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');
3266: END IF;
3267:
3268: ELSIF g_document_type_tab(i) ='PO' THEN
3269:

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

3267:
3268: ELSIF g_document_type_tab(i) ='PO' THEN
3269:
3270: IF g_debug = 'Y' THEN
3271: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching PO data for distribution id '||g_doc_dist_id_tab(i),'C');
3272: END IF;
3273:
3274: OPEN c_po_adl_details(g_doc_dist_id_tab(i));
3275: FETCH c_po_adl_details INTO g_award_id_tab(i),

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

3278: g_ind_cmp_set_id_tab(i),
3279: g_po_rate_tab(i); -- Bug 5614467
3280: IF c_po_adl_details%NOTFOUND THEN
3281: IF g_debug = 'Y' THEN
3282: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');
3283: END IF;
3284: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3285: END IF;
3286: CLOSE c_po_adl_details;

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

3285: END IF;
3286: CLOSE c_po_adl_details;
3287:
3288: IF g_debug = 'Y' THEN
3289: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3290: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3291: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3292: 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');
3293: END IF;

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

3286: CLOSE c_po_adl_details;
3287:
3288: IF g_debug = 'Y' THEN
3289: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3290: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3291: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3292: 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');
3293: END IF;
3294:

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

3287:
3288: IF g_debug = 'Y' THEN
3289: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3290: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3291: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3292: 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');
3293: END IF;
3294:
3295:

Line 3292: 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');

3288: IF g_debug = 'Y' THEN
3289: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3290: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3291: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3292: 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');
3293: END IF;
3294:
3295:
3296: ELSIF g_document_type_tab(i) ='AP' THEN

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

3295:
3296: ELSIF g_document_type_tab(i) ='AP' THEN
3297:
3298: IF g_debug = 'Y' THEN
3299: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Fetching AP data for distribution id '||g_doc_dist_id_tab(i),'C');
3300: END IF;
3301:
3302: OPEN c_ap_adl_details(g_doc_dist_id_tab(i));
3303: FETCH c_ap_adl_details INTO g_set_of_books_id_tab(i),

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

3316: g_burdenable_raw_cost_tab(i),
3317: g_parent_reversal_id_tab(i); -- Bug 5369296
3318: IF c_ap_adl_details%NOTFOUND THEN
3319: IF g_debug = 'Y' THEN
3320: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising AP Data transfer failure F09' ,'C');
3321: END IF;
3322: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3323: END IF;
3324: CLOSE c_ap_adl_details;

Line 3327: 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');

3323: END IF;
3324: CLOSE c_ap_adl_details;
3325:
3326: IF g_debug = 'Y' THEN
3327: 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');
3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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 3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

3324: CLOSE c_ap_adl_details;
3325:
3326: IF g_debug = 'Y' THEN
3327: 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');
3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');

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

3325:
3326: IF g_debug = 'Y' THEN
3327: 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');
3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');

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

3326: IF g_debug = 'Y' THEN
3327: 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');
3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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 3331: 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');

3327: 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');
3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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 3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');

3328: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

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

3329: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_category_tab ='||g_exp_category_tab(i),'C');
3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

Line 3334: 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');

3330: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_revenue_category_tab ='||g_revenue_category_tab(i),'C');
3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 3335: 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');

3331: 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');
3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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 3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

3332: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_invoice_type_code_tab ='||g_invoice_type_code_tab(i),'C');
3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

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

3333: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_inv_source_tab ='||g_inv_source_tab(i),'C');
3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3341: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');

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

3334: 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');
3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3341: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3342: END IF;

Line 3339: 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');

3335: 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');
3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3341: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3342: END IF;
3343:

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

3336: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3341: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3342: END IF;
3343:
3344: -- Code to check if there exists associated PO/Release and if exists create records

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

3337: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3338: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3339: 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');
3340: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3341: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_parent_reversal_id_tab ='||g_parent_reversal_id_tab(i),'C');
3342: END IF;
3343:
3344: -- Code to check if there exists associated PO/Release and if exists create records
3345: -- to relieve amount variance/quantitiy variance AND PO

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

3355: l_po_ind_com_set_id,
3356: g_po_rate_tab(i); -- Bug 5614467
3357: IF c_po_adl_details%NOTFOUND THEN
3358: IF g_debug = 'Y' THEN
3359: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Raising PO Data transfer failure F09' ,'C');
3360: END IF;
3361: g_result_code_tab(i) := 'F09'; -- Data transfer failure
3362: ELSE
3363: IF g_debug = 'Y' THEN

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

3374: p_po_ind_com_set_id => l_po_ind_com_set_id);
3375:
3376: IF g_debug = 'Y' THEN
3377: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3378: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');

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

3375:
3376: IF g_debug = 'Y' THEN
3377: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3378: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');

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

3376: IF g_debug = 'Y' THEN
3377: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3378: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');

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

3377: FOR i in l_debug_start_counter..g_doc_dist_id_tab.count LOOP
3378: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');

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

3378: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Start-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');

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

3379: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_source_name_tab ='||g_je_source_name_tab(i),'C');
3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');

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

3380: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_je_category_name_tab ='||g_je_category_name_tab(i),'C');
3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');

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

3381: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_actual_flag_tab ='||g_actual_flag_tab(i),'C');
3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');

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

3382: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_project_id_tab ='||g_project_id_tab(i),'C');
3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

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

3383: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_task_id_tab ='||g_task_id_tab(i),'C');
3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');

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

3384: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_award_id_tab ='||g_award_id_tab(i),'C');
3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');

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

3385: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_dr_tab ='||g_entered_dr_tab(i),'C');
3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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 3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');

3386: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_entered_cr_tab ='||g_entered_cr_tab(i),'C');
3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

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

3387: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_etype_tab ='||g_etype_tab(i),'C');
3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');

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

3388: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_org_id_tab ='||g_exp_org_id_tab(i),'C');
3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');

Line 3393: 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');

3389: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_exp_item_date_tab ='||g_exp_item_date_tab(i),'C');
3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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 3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');

3390: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_document_type_tab ='||g_document_type_tab(i),'C');
3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');

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

3391: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_header_id_tab ='||g_doc_header_id_tab(i),'C');
3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');

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

3392: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_doc_dist_id_tab ='||g_doc_dist_id_tab(i),'C');
3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');

Line 3397: 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');

3393: 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');
3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');

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

3394: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_source_event_id_tab ='||g_source_event_id_tab(i),'C');
3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3402: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');

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

3395: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_result_code_tab ='||g_result_code_tab(i),'C');
3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3402: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3403: END LOOP;

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

3396: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_vendor_id_tab ='||g_vendor_id_tab(i),'C');
3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3402: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3403: END LOOP;
3404: End if;

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

3397: 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');
3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3402: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3403: END LOOP;
3404: End if;
3405:

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

3398: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_burdenable_raw_cost_tab ='||g_burdenable_raw_cost_tab(i),'C');
3399: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_quantity_variance_tab ='||g_quantity_variance_tab(i),'C');
3400: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_amount_variance_tab ='||g_amount_variance_tab(i),'C');
3401: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Value of g_po_distribution_id_tab ='||g_po_distribution_id_tab(i),'C');
3402: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'End-Records created by CREATE_BACKING_PO_APVAR_REC'||-i,'C');
3403: END LOOP;
3404: End if;
3405:
3406: END IF;

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

3414:
3415: IF NVL (l_award_dist_option, 'N') = 'Y' THEN
3416:
3417: IF g_debug = 'Y' THEN
3418: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Deleting dummy ADL','C');
3419: END IF;
3420:
3421: DELETE gms_award_distributions
3422: WHERE award_set_id = NVL (l_dist_award_id, 0)

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

3427: END IF;
3428: END IF; --IF p_application_id in (200,201) THEN
3429:
3430: IF g_debug = 'Y' THEN
3431: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Calling Load_gms_pkts ','C');
3432: END IF;
3433:
3434: Load_gms_pkts (l_packet_id,
3435: p_partial_flag,

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

3494: AND request_id = -9999;
3495: END IF;
3496:
3497: IF g_debug = 'Y' THEN
3498: gms_error_pkg.gms_debug ('misc_gms_insert - Exception '||' SQLCODE:'||SQLCODE||' SQLERRM:'||SQLERRM, 'C');
3499: END IF;
3500: x_return_code := 'F';
3501: END copy_gl_pkt_to_gms_pkt;
3502:

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

3586: Commented out for bug 3810247 : This code will move to stage 701 of gms_fck ..
3587:
3588: ELSIF doc_type = 'ENC' THEN
3589:
3590: gms_error_pkg.gms_debug ('ENC1: Call calc_enc_ind_compiled_set_id ', 'C');
3591: -- Fix for bug : 2927485 : calculate ind_compiled_set_id for ENC
3592: CALC_ENC_IND_COMPILED_SET_ID (x_packet_id);
3593:
3594: gms_error_pkg.gms_debug ('ENC2: Call Handle_net_zero_txn:Net_Zero ', 'C');

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

3590: gms_error_pkg.gms_debug ('ENC1: Call calc_enc_ind_compiled_set_id ', 'C');
3591: -- Fix for bug : 2927485 : calculate ind_compiled_set_id for ENC
3592: CALC_ENC_IND_COMPILED_SET_ID (x_packet_id);
3593:
3594: gms_error_pkg.gms_debug ('ENC2: Call Handle_net_zero_txn:Net_Zero ', 'C');
3595: -- Check if adjusted and adjusting transactions are present in the same packet
3596: -- If so, update them with result_code 'P82' and update effect_on_funds_code
3597: -- to 'I' so that 'funds avilable' calculation ignores them.
3598:

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

3597: -- to 'I' so that 'funds avilable' calculation ignores them.
3598:
3599: HANDLE_NET_ZERO_TXN(x_packet_id,'Net_Zero');
3600:
3601: gms_error_pkg.gms_debug ('ENC3: Call Handle_net_zero_txn:Check_Adjusted ', 'C');
3602: -- Fail adjusting transaction, if original transaction has not been FC'ed(F08)
3603:
3604: HANDLE_NET_ZERO_TXN(x_packet_id, 'Check_Adjusted');
3605: ======================================================================================== */

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

3808: ;
3809: BEGIN
3810: g_error_procedure_name := 'initialize_setup';
3811: IF g_debug = 'Y' THEN
3812: gms_error_pkg.gms_debug ('Initilaze Setup - Start ', 'C');
3813: END IF;
3814: g_error_stage := 'INIT_SETUP : START';
3815: SELECT NVL (default_dist_award_id, 0),
3816: NVL (award_distribution_option, 'N')

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

3875: END LOOP;
3876: CLOSE cur_init_setup;
3877: g_error_stage := 'INIT_SETUP : END';
3878: IF g_debug = 'Y' THEN
3879: gms_error_pkg.gms_debug ('Initilize_Setup - End ', 'C');
3880: END IF;
3881: IF x_award_id = NVL (x_dist_award_id, -1111) THEN
3882: UPDATE gms_bc_packets
3883: SET status_code = decode(p_mode,'S','E','C','F','R'),

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

3981: -- ########### =========================================-
3982:
3983: g_error_stage := 'SETUP_RLMI : START';
3984: IF g_debug = 'Y' THEN
3985: gms_error_pkg.gms_debug ('SETUP_RLMI - Start ', 'C');
3986: END IF;
3987: g_error_procedure_name := 'setup_rlmi';
3988:
3989: IF x_mode <> 'U' THEN

Line 4056: -- gms_error_pkg.gms_debug (

4052: OR (t_person_id (t_row_id.PRIOR (bcpkt_records))<> t_person_id (bcpkt_records))
4053: OR (t_job_id (t_row_id.PRIOR (bcpkt_records)) <> t_job_id (bcpkt_records))
4054: OR (t_vendor_id (t_row_id.PRIOR (bcpkt_records))<> t_vendor_id (bcpkt_records))) THEN
4055:
4056: -- gms_error_pkg.gms_debug (
4057: -- 'Setup_rlmi - Debug '|| t_exp_type (bcpkt_records),
4058: -- 'C');
4059:
4060: gms_res_map.map_resources_group (

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

4076: t_rlmi_value (bcpkt_records),
4077: t_fc_error (bcpkt_records),
4078: x_err_buff);
4079:
4080: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');

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

4077: t_fc_error (bcpkt_records),
4078: x_err_buff);
4079:
4080: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');

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

4078: x_err_buff);
4079:
4080: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');

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

4079:
4080: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');

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

4080: -- gms_error_pkg.gms_debug ('Setup_rlmi - Resource List '||to_char(t_res_list(bcpkt_records)), 'C');
4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');

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

4081: -- gms_error_pkg.gms_debug ('Setup_rlmi - Cat Code '||t_cat_code(bcpkt_records), 'C');
4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');

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

4082: -- gms_error_pkg.gms_debug ('Setup_rlmi - Doc Type '||t_doc_type(bcpkt_records), 'C');
4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
4090: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');

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

4083: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Type '||t_exp_type(bcpkt_records), 'C');
4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
4090: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
4091:

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

4084: -- gms_error_pkg.gms_debug ('Setup_rlmi - Org Id '||t_org_id(bcpkt_records), 'C');
4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
4090: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
4091:
4092: ELSE

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

4085: -- gms_error_pkg.gms_debug ('Setup_rlmi - Exp Cat '||t_exp_cat(bcpkt_records), 'C');
4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
4090: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
4091:
4092: ELSE
4093: t_rlmi_value (bcpkt_records) :=

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

4086: -- gms_error_pkg.gms_debug ('Setup_rlmi - Rev Cat '||t_rev_cat(bcpkt_records), 'C');
4087: -- gms_error_pkg.gms_debug ('Setup_rlmi - Person Id '||t_person_id(bcpkt_records), 'C');
4088: -- gms_error_pkg.gms_debug ('Setup_rlmi - Job Id '||t_job_id(bcpkt_records), 'C');
4089: -- gms_error_pkg.gms_debug ('Setup_rlmi - Vendor Id '||t_vendor_id(bcpkt_records), 'C');
4090: -- gms_error_pkg.gms_debug ('Setup_rlmi - RLMId '||t_rlmi_value(bcpkt_records), 'C');
4091:
4092: ELSE
4093: t_rlmi_value (bcpkt_records) :=
4094: t_rlmi_value (t_row_id.PRIOR (bcpkt_records));

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

4145: AND bv1.budget_entry_method_code = bem1.budget_entry_method_code
4146: AND bem1.entry_level_code IN ('P', 'L', 'T'));
4147:
4148: IF g_debug = 'Y' THEN
4149: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code P,L,T Complete ','C');
4150: END IF;
4151:
4152: -- Added commit for the base bug 3848201
4153: commit;

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

4204: -- Added commit for the base bug 3848201
4205: commit;
4206:
4207: IF g_debug = 'Y' THEN
4208: gms_error_pkg.gms_debug('BUDGET_TASK_ID_UPDATE - Update for Entry Level code M Complete ','C');
4209: END IF;
4210:
4211: -- If Bud Task Id is not updated till this point , then update bud_task_id with
4212: -- task_id of expenditure

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

4287: WHERE packet_id = x_packet_id
4288: AND status_code = 'P'
4289: ;
4290: IF g_debug = 'Y' THEN
4291: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Award Result code Complete ','C');
4292: END IF;
4293: g_error_stage := 'FUND_CTRL_LEVEL_CODE : TT';
4294: -- Top Task Level
4295: UPDATE gms_bc_packets gms

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

4308: -- Added commit for the base bug 3848201
4309: commit;
4310:
4311: IF g_debug = 'Y' THEN
4312: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Top Task Result code Complete ','C');
4313: END IF;
4314: g_error_stage := 'FUND_CTRL_LEVEL_CODE : T';
4315:
4316: -- Task Level

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

4330: -- Added commit for the base bug 3848201
4331: commit;
4332:
4333: IF g_debug = 'Y' THEN
4334: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for Task Result code Complete ','C');
4335: END IF;
4336: --Task level funds control level code should set up only if budget entry method is by task
4337: --For project with resource level budget entry method task_id =0
4338: -- Resource Group Level

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

4354: -- Added commit for the base bug 3848201
4355: commit;
4356:
4357: IF g_debug = 'Y' THEN
4358: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Group Result code Complete ','C');
4359: END IF;
4360:
4361: -- Resource Level
4362: g_error_stage := 'FUND_CTRL_LEVEL_CODE : R';

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

4376: -- Added commit for the base bug 3848201
4377: commit;
4378:
4379: IF g_debug = 'Y' THEN
4380: gms_error_pkg.gms_debug('FUNDS_CTRL_LEVEL_CODE - Update for resource Level Result code Complete ','C');
4381: END IF;
4382:
4383: -- If Funds control level code at any level is null
4384: -- The update it to 'None'

Line 4704: gms_error_pkg.gms_message (

4700: -- Find the x_start_date and x_end_date
4701: IF x_time_phased_type_code = 'N' THEN -- for no time phase
4702: IF ( x_amount_type <> 'PJTD'
4703: OR x_boundary_code <> 'J') THEN
4704: gms_error_pkg.gms_message (
4705: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4706: 'TIME_PHASED_CODE',
4707: x_time_phased_type_code,
4708: 'AMOUNT_TYPE',

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

4721: p_packet_id=> x_packetid,
4722: p_bc_packet_id=> x_bc_packet_id);
4723:
4724: IF g_debug = 'Y' THEN
4725: gms_error_pkg.gms_debug ('For time phase = N it should be project to date project', 'C');
4726: END IF;
4727: ELSE
4728: x_start_date := project_start_date;
4729: x_end_date := project_end_date;

Line 4829: gms_error_pkg.gms_message (

4825: x_end_date := dr_period_end_date;
4826: END IF;
4827: -- end date calc for PJTD - period
4828: ELSE
4829: gms_error_pkg.gms_message (
4830: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4831: 'TIME_PHASED_CODE',
4832: x_time_phased_type_code,
4833: 'AMOUNT_TYPE',

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

4837: x_exec_type=> 'C',
4838: x_err_code=> x_err_code,
4839: x_err_buff=> x_err_buff);
4840: IF g_debug = 'Y' THEN
4841: gms_error_pkg.gms_debug ('invalid end date for PJTD ', 'C');
4842: END IF;
4843: END IF;
4844: -- Year to Date - start and End date calculation
4845: -- start date calc - YTD

Line 4898: gms_error_pkg.gms_message (

4894: ELSIF x_time_phased_type_code = 'R' THEN
4895: x_end_date := dr_period_end_date;
4896: END IF;
4897: ELSE
4898: gms_error_pkg.gms_message (
4899: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4900: 'TIME_PHASED_CODE',
4901: x_time_phased_type_code,
4902: 'AMOUNT_TYPE',

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

4906: x_exec_type=> 'C',
4907: x_err_code=> x_err_code,
4908: x_err_buff=> x_err_buff);
4909: IF g_debug = 'Y' THEN
4910: gms_error_pkg.gms_debug ('invalid end date for year to date year', 'C');
4911: END IF;
4912: END IF;
4913: --For Period to Date Period
4914: ELSIF x_amount_type = 'PTD' THEN

Line 4928: gms_error_pkg.gms_message (

4924: x_start_date := dr_period_start_date;
4925: x_end_date := dr_period_end_date;
4926: END IF;
4927: ELSE
4928: gms_error_pkg.gms_message (
4929: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4930: 'TIME_PHASED_CODE',
4931: x_time_phased_type_code,
4932: 'AMOUNT_TYPE',

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

4936: x_exec_type=> 'C',
4937: x_err_code=> x_err_code,
4938: x_err_buff=> x_err_buff);
4939: IF g_debug = 'Y' THEN
4940: gms_error_pkg.gms_debug ('invalid end date for period to date', 'C');
4941: END IF;
4942: END IF;
4943: ELSE
4944: gms_error_pkg.gms_message (

Line 4944: gms_error_pkg.gms_message (

4940: gms_error_pkg.gms_debug ('invalid end date for period to date', 'C');
4941: END IF;
4942: END IF;
4943: ELSE
4944: gms_error_pkg.gms_message (
4945: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4946: 'TIME_PHASED_CODE',
4947: x_time_phased_type_code,
4948: 'AMOUNT_TYPE',

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

4952: x_exec_type=> 'C',
4953: x_err_code=> x_err_code,
4954: x_err_buff=> x_err_buff);
4955: IF g_debug = 'Y' THEN
4956: gms_error_pkg.gms_debug ('invalid start date for any combination', 'C');
4957: END IF;
4958: END IF;
4959: ELSE
4960: gms_error_pkg.gms_message (

Line 4960: gms_error_pkg.gms_message (

4956: gms_error_pkg.gms_debug ('invalid start date for any combination', 'C');
4957: END IF;
4958: END IF;
4959: ELSE
4960: gms_error_pkg.gms_message (
4961: 'GMS_INVALID_AMT_TYPE_BND_CODE',
4962: 'TIME_PHASED_CODE',
4963: x_time_phased_type_code,
4964: 'AMOUNT_TYPE',

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

4968: x_exec_type=> 'C',
4969: x_err_code=> x_err_code,
4970: x_err_buff=> x_err_buff);
4971: IF g_debug = 'Y' THEN
4972: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4973: END IF;
4974: END IF;
4975: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4976: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');

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

4971: IF g_debug = 'Y' THEN
4972: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4973: END IF;
4974: END IF;
4975: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4976: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');
4977: --('After Date Check Process');
4978: END setup_start_end_date;
4979:

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

4972: gms_error_pkg.gms_debug ('invalid time phased type for any combination', 'C');
4973: END IF;
4974: END IF;
4975: -- gms_error_pkg.gms_debug ('start start end date cal-start date'|| x_start_date, 'C');
4976: -- gms_error_pkg.gms_debug ('start start end date cal-end date'|| x_end_date, 'C');
4977: --('After Date Check Process');
4978: END setup_start_end_date;
4979:
4980: ----------------------------------------------------------------------------------------------------------

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

5433: If FULL_MODE_FAILURE(x_packetid, -- Packet_id
5434: g_mode, -- Mode , use g_mode
5435: 'ALL' -- Level
5436: ) THEN
5437: gms_error_pkg.gms_debug (g_error_procedure_name||':full_mode_failure call completed','C');
5438: -- Note:We're not handling Full mode failures for REQ/PO/AP here ...
5439: End If;
5440:
5441: -- Net zero txn.s failure

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

5560: -- Added commit for the base bug 3848201
5561: commit;
5562:
5563: IF g_debug = 'Y' THEN
5564: gms_error_pkg.gms_debug ( 'GMS_SETUP - Setup Failed ', 'C' );
5565: END IF;
5566:
5567: RETURN FALSE;
5568: EXCEPTION

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

5606: g_error_procedure_name := 'update_fc_sequence';
5607: g_error_stage := 'UPD FC SEQ: BLK COLL';
5608: t_count := 0; -- fix for bug : 2927485
5609:
5610: gms_error_pkg.gms_debug ( 'update_fc_sequence : Start ', 'C' );
5611:
5612: FOR recs in C_result_code
5613: loop
5614:

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

5676: WHERE ROWID = t_row_id (bcpkt_txns);
5677: End if;
5678:
5679: end loop;
5680: gms_error_pkg.gms_debug ( 'update_fc_sequence : End ', 'C' );
5681: END update_fc_sequence;
5682:
5683: ------------------------------------------------------------------------------------------------------
5684: -- Wrapper process which calls all the setup procedures and functions

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

5709: BEGIN
5710: g_error_procedure_name := 'gms_setup';
5711: g_error_stage := 'GMS_SETUP : START';
5712: IF g_debug = 'Y' THEN
5713: gms_error_pkg.gms_debug ('GMS_SETUP - Before Burdened Cost Update ', 'C');
5714: END IF;
5715:
5716: update_burdened_cost (x_packetid);
5717: COMMIT;

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

5719: --------------------------------------------------------------------------
5720: -- Set up of effect_on_funds_code and generating resource_list_member_id
5721: --------------------------------------------------------------------------
5722: IF g_debug = 'Y' THEN
5723: gms_error_pkg.gms_debug ('GMS_SETUP - Before Setup RLMI ', 'C');
5724: END IF;
5725: setup_rlmi (x_packetid, x_mode, x_err_code, x_err_buff);
5726: COMMIT;
5727:

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

5729: -- Update the budgeted task id
5730: -- in gms bc packets for a project, task, award, budget version
5731: -- ------------------------------------------------------------------------
5732: IF g_debug = 'Y' THEN
5733: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted Task Update -> packet_id'|| x_packetid, 'C');
5734: END IF;
5735: budget_task_id_update (x_packetid);
5736: COMMIT;
5737:

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

5735: budget_task_id_update (x_packetid);
5736: COMMIT;
5737:
5738: IF g_debug = 'Y' THEN
5739: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted Task Update', 'C');
5740: END IF;
5741:
5742: -- --------------------------------------------------------------------------
5743: -- Update the Budgeted resource list member id(rlmi)

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

5743: -- Update the Budgeted resource list member id(rlmi)
5744: -- in gms bc packets for a project, task, award, budget version
5745: -- --------------------------------------------------------------------------
5746: IF g_debug = 'Y' THEN
5747: gms_error_pkg.gms_debug ('GMS_SETUP - Before Budgeted rlmi Update -> packet_id'|| x_packetid, 'C');
5748: END IF;
5749: bud_res_list_id_update (x_packetid);
5750: COMMIT;
5751:

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

5749: bud_res_list_id_update (x_packetid);
5750: COMMIT;
5751:
5752: IF g_debug = 'Y' THEN
5753: gms_error_pkg.gms_debug ('GMS_SETUP - After Budgeted rlmi Update', 'C');
5754: END IF;
5755:
5756: -- ---------------------------------------------------------------------------
5757: -- Updating the Funds control level code

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

5757: -- Updating the Funds control level code
5758: -- in gms bc packets for a project, task, award, budget version
5759: -- ---------------------------------------------------------------------------
5760: IF g_debug = 'Y' THEN
5761: gms_error_pkg.gms_debug ('GMS_SETUP - Before Funds ctrl code -> packet_id'|| x_packetid, 'C');
5762: END IF;
5763: funds_ctrl_level_code (x_packetid);
5764: COMMIT;
5765:

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

5763: funds_ctrl_level_code (x_packetid);
5764: COMMIT;
5765:
5766: IF g_debug = 'Y' THEN
5767: gms_error_pkg.gms_debug ('GMS_SETUP - Before start date end date -> packet_id'|| x_packetid, 'C');
5768: END IF;
5769:
5770: call_start_end_date_update (x_packetid,x_mode);
5771: COMMIT;

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

5769:
5770: call_start_end_date_update (x_packetid,x_mode);
5771: COMMIT;
5772: IF g_debug = 'Y' THEN
5773: gms_error_pkg.gms_debug ('GMS_SETUP - After startdate end date -> packet_id'|| x_packetid, 'C');
5774: END IF;
5775:
5776: IF NOT check_setup_failure (x_packetid, x_partial ) THEN
5777: COMMIT;

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

5816: */
5817:
5818: g_error_stage := 'GMS_SETUP : END';
5819: IF g_debug = 'Y' THEN
5820: gms_error_pkg.gms_debug ( 'GMS_SETUP -After Inserting Records in gms_bc_packet_arrival_order ', 'C' );
5821: END IF;
5822: RETURN TRUE;
5823: END gms_setup;
5824:

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

5952: g_error_procedure_name := 'budget_fundscheck';
5953: g_error_stage := 'BUD_FC : START';
5954: -- Resource Level
5955: IF g_debug = 'Y' THEN
5956: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - PROCESS'|| x_packetid, 'C');
5957: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE LEVEL', 'C');
5958: END IF;
5959: g_error_stage := 'BUD_FC : RES';
5960: OPEN gms_bc_tot_r;

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

5953: g_error_stage := 'BUD_FC : START';
5954: -- Resource Level
5955: IF g_debug = 'Y' THEN
5956: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - PROCESS'|| x_packetid, 'C');
5957: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE LEVEL', 'C');
5958: END IF;
5959: g_error_stage := 'BUD_FC : RES';
5960: OPEN gms_bc_tot_r;
5961: LOOP

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

6008:
6009: l_previous_tot := 0;
6010:
6011: IF g_debug = 'Y' THEN
6012: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE RESOURCE GROUP LEVEL', 'C');
6013: END IF;
6014: OPEN gms_bc_tot_rg;
6015: LOOP
6016: FETCH gms_bc_tot_rg INTO x_rg_bc_tot,

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

6065:
6066: l_previous_tot := 0;
6067:
6068: IF g_debug = 'Y' THEN
6069: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TASK LEVEL', 'C');
6070: END IF;
6071: OPEN gms_bc_tot_t;
6072: LOOP
6073: FETCH gms_bc_tot_t INTO x_t_bc_tot,

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

6114:
6115: l_previous_tot := 0;
6116:
6117: IF g_debug = 'Y' THEN
6118: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE TOP TASK LEVEL', 'C');
6119: END IF;
6120: OPEN gms_bc_tot_tt;
6121: LOOP
6122: FETCH gms_bc_tot_tt INTO x_tt_bc_tot,

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

6163:
6164: l_previous_tot := 0;
6165:
6166: IF g_debug = 'Y' THEN
6167: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - BEFORE AWARD LEVEL', 'C');
6168: END IF;
6169: OPEN gms_bc_tot_a;
6170: LOOP
6171:

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

6205:
6206: END LOOP;
6207: CLOSE gms_bc_tot_a;
6208: IF g_debug = 'Y' THEN
6209: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK BEFORE P50 UPDATE '|| x_packetid, 'C');
6210: END IF;
6211: UPDATE gms_bc_packets
6212: SET result_code = 'P50',
6213: award_result_code = 'P50',

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

6217: top_task_result_code = 'P50'
6218: WHERE packet_id = x_packetid
6219: AND status_code = 'P';
6220: IF g_debug = 'Y' THEN
6221: gms_error_pkg.gms_debug ('BUDGET_FUNDSCHECK - AFTER P50 UPDATE '|| x_packetid, 'C');
6222: END IF;
6223: EXCEPTION
6224: WHEN NO_DATA_FOUND THEN
6225: -- For Resource Level

Line 6228: gms_error_pkg.gms_message (

6224: WHEN NO_DATA_FOUND THEN
6225: -- For Resource Level
6226: IF gms_bc_tot_r%ISOPEN THEN
6227: g_error_stage := 'BUD_FC FAIL: RES';
6228: gms_error_pkg.gms_message (
6229: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_RES',
6230: x_token_name1=> 'PACKET_ID',
6231: x_token_val1=> x_packetid,
6232: x_token_name2=> 'TASK_ID',

Line 6257: gms_error_pkg.gms_message (

6253:
6254: -- For Resource Group Level
6255: IF gms_bc_tot_rg%ISOPEN THEN
6256: g_error_stage := 'BUD_FC FAIL: RES GRP';
6257: gms_error_pkg.gms_message (
6258: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_RES_GRP',
6259: x_token_name1=> 'PACKET_ID',
6260: x_token_val1=> x_packetid,
6261: x_token_name2=> 'TASK_ID',

Line 6286: gms_error_pkg.gms_message (

6282:
6283: -- For Task Level
6284: IF gms_bc_tot_t%ISOPEN THEN
6285: g_error_stage := 'BUD_FC FAIL: TASK';
6286: gms_error_pkg.gms_message (
6287: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_TASK',
6288: x_token_name1=> 'PACKET_ID',
6289: x_token_val1=> x_packetid,
6290: x_token_name2=> 'TASK_ID',

Line 6313: gms_error_pkg.gms_message (

6309:
6310: -- For Top Task Level
6311: IF gms_bc_tot_tt%ISOPEN THEN
6312: g_error_stage := 'BUD_FC FAIL: TOPTASK';
6313: gms_error_pkg.gms_message (
6314: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_TOP_TASK',
6315: x_token_name1=> 'PACKET_ID',
6316: x_token_val1=> x_packetid,
6317: x_token_name2=> 'TOP_TASK_ID',

Line 6340: gms_error_pkg.gms_message (

6336: -- For Award Level
6337:
6338: IF gms_bc_tot_a%ISOPEN THEN
6339: g_error_stage := 'BUD_FC FAIL: AWARD';
6340: gms_error_pkg.gms_message (
6341: x_err_name=> 'GMS_FC_FAIL_AT_BUDG_AWARD',
6342: x_token_name1=> 'PACKET_ID',
6343: x_token_val1=> x_packetid,
6344: x_token_name4=> 'START_DATE',

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

6406: -- Following Insert statement inserts records in gms_bc_packets_summary.
6407: -- Records in this table will later be used to summarize amount at
6408: -- resource,task and Award Level for previous and currne packet.
6409: IF g_debug = 'Y' THEN
6410: gms_error_pkg.gms_debug ('RESOURCE LEVEL - SUMMARY INSERT ', 'C');
6411: END IF;
6412: x_date := sysdate;
6413: g_error_stage := 'FC PR : INSRT SUMM';
6414: INSERT INTO gms_bc_packets_bvid

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

6487: --===============================================================================
6488: -- RESOURCE LEVEL : POSTED BALANCE UPDATE
6489: --===============================================================================
6490: IF g_debug = 'Y' THEN
6491: gms_error_pkg.gms_debug ('RESOURCE POSTED BALANCE UPDATE', 'C');
6492: END IF;
6493: g_error_stage := 'FC PR : RES P BAL';
6494: UPDATE gms_bc_packets bp
6495: SET (bp.res_budget_posted, bp.res_actual_posted, bp.res_enc_posted) =

Line 6534: gms_error_pkg.gms_debug (

6530: AND bp.categorization_code = 'R'
6531: AND bp.r_funds_control_level_code <> 'N';
6532: -- AND bp.budgeted_at_resource_level = 'Y'; -- Bug 2605070
6533: IF g_debug = 'Y' THEN
6534: gms_error_pkg.gms_debug (
6535: 'RESOURCE LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS',
6536: 'C');
6537: END IF;
6538: --===============================================================================

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

6538: --===============================================================================
6539: -- RESOURCE LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
6540: --===============================================================================
6541: IF g_debug = 'Y' THEN
6542: gms_error_pkg.gms_debug ( 'RESOURCE LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS','C' );
6543: END IF;
6544: -- Bug 2092791
6545: g_error_stage := 'FC PR : RES A BAL';
6546: UPDATE gms_bc_packets bp

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

6671: -- F92 : Transaction failed funds check at Resource level
6672: -- ================================================================================
6673: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
6674: IF g_debug = 'Y' THEN
6675: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE', 'C');
6676: END IF;
6677: g_error_stage := 'FC PR : RES RESULT CODE';
6678: UPDATE gms_bc_packets bp
6679: SET bp.res_result_code = DECODE (

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

6780: --===============================================================================
6781: -- RESOURCE GROUP LEVEL : POSTED BALANCE UPDATE
6782: --===============================================================================
6783: IF g_debug = 'Y' THEN
6784: gms_error_pkg.gms_debug ('RESOURCE GROUP POSTED BALANCE UPDATE', 'C');
6785: END IF;
6786: g_error_stage := 'FC PR : RESG P BAL';
6787: UPDATE gms_bc_packets bp
6788: SET (bp.res_grp_budget_posted, bp.res_grp_actual_posted, bp.res_grp_enc_posted) =

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

6835: --===================================================================================
6836: -- RESOURCE GROUP LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
6837: --===================================================================================
6838: IF g_debug = 'Y' THEN
6839: gms_error_pkg.gms_debug ('RESOURCE GROUP LEVEL - APPROVED/PENDING BALANCE FOR CURRENT PACKET', 'C');
6840: END IF;
6841: -- Bug 2092791
6842: g_error_stage := 'FC PR : RESG A/P BAL';
6843: UPDATE gms_bc_packets bp

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

6965: -- F93 : Transaction failed funds check at Resource Group level
6966: -- ================================================================================
6967: -- Changed for bug : 2927485: Added decode(bp.result_code,null,'P78',bp.result_code)
6968: IF g_debug = 'Y' THEN
6969: gms_error_pkg.gms_debug ('RESULT CODE UPDATE - RESOURCE GROUP', 'C');
6970: END IF;
6971: g_error_stage := 'FC PR : RESG RESULT UPD';
6972: UPDATE gms_bc_packets bp
6973: SET bp.res_grp_result_code = DECODE (

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

7072: --===============================================================================
7073: -- TASK LEVEL : POSTED BALANCE UPDATE
7074: --===============================================================================
7075: IF g_debug = 'Y' THEN
7076: gms_error_pkg.gms_debug ('TASK :POSTED BALANCE ', 'C');
7077: END IF;
7078: g_error_stage := 'FC PR : TASK P BAL';
7079: UPDATE gms_bc_packets bp
7080: SET (bp.task_budget_posted, bp.task_actual_posted, bp.task_enc_posted) =

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

7112: --===============================================================================
7113: -- TASK LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
7114: --===============================================================================
7115: IF g_debug = 'Y' THEN
7116: gms_error_pkg.gms_debug ('TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
7117: END IF;
7118:
7119: g_error_stage := 'FC PR : TASK A/P BAL';
7120: UPDATE gms_bc_packets bp

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

7235: -- ================================================================================
7236: -- 3. Task Result Code Update
7237: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
7238: IF g_debug = 'Y' THEN
7239: gms_error_pkg.gms_debug ('TASK : RESULT CODE ', 'C');
7240: END IF;
7241: g_error_stage := 'FC PR : TASK RESULT CD';
7242: UPDATE gms_bc_packets bp
7243: SET bp.task_result_code = DECODE (

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

7339: --===============================================================================
7340: -- TOP TASK LEVEL : POSTED BALANCE UPDATE
7341: --===============================================================================
7342: IF g_debug = 'Y' THEN
7343: gms_error_pkg.gms_debug ('TOP TASK :POSTED BALANCE ', 'C');
7344: END IF;
7345: g_error_stage := 'FC PR : TTASK P BAL';
7346: UPDATE gms_bc_packets bp
7347: SET (bp.top_task_budget_posted, bp.top_task_actual_posted, bp.top_task_enc_posted) =

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

7380: --===============================================================================
7381: -- TOP TASK LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
7382: --===============================================================================
7383: IF g_debug = 'Y' THEN
7384: gms_error_pkg.gms_debug ('TOP TASK LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
7385: END IF;
7386: g_error_stage := 'FC PR : TTASK A/P BAL';
7387: -- Bug 2092791
7388:

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

7508: -- ================================================================================
7509: -- Top Task Result Code Update
7510: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
7511: IF g_debug = 'Y' THEN
7512: gms_error_pkg.gms_debug ('TOP TASK : RESULT CODE ', 'C');
7513: END IF;
7514: g_error_stage := 'FC PR : TTASK RESULT CODE';
7515: UPDATE gms_bc_packets bp
7516: SET bp.top_task_result_code = DECODE (

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

7606: --===============================================================================
7607: -- AWARD LEVEL : POSTED BALANCE UPDATE
7608: --===============================================================================
7609: IF g_debug = 'Y' THEN
7610: gms_error_pkg.gms_debug ('AWARD:POSTED BALANCE ', 'C');
7611: END IF;
7612: g_error_stage := 'FC PR : AWARD P B';
7613: UPDATE gms_bc_packets bp
7614: SET (bp.award_budget_posted, bp.award_actual_posted, bp.award_enc_posted) =

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

7642: --===============================================================================
7643: -- AWARD LEVEL : APPROVED/PENDING BALANCE FOR PREVIOUS AND CURRENT PACKETS
7644: --===============================================================================
7645: IF g_debug = 'Y' THEN
7646: gms_error_pkg.gms_debug ('AWARD LEVEL - APPROVED/PENDING BALANCE FOR PREVIOUS PACKETS', 'C');
7647: END IF;
7648: g_error_stage := 'FC PR : AWARD A/P B';
7649: -- Bug 2092791
7650: UPDATE gms_bc_packets bp

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

7761: -- F90 : Transaction failed funds check at Award level
7762: -- ================================================================================
7763: -- Added decode(bp.result_code,null,'P78',bp.result_code for bug : 2927485
7764: IF g_debug = 'Y' THEN
7765: gms_error_pkg.gms_debug ('AWARD: Result Code ', 'C');
7766: END IF;
7767: g_error_stage := 'FC PR : AWARD RESULT';
7768: UPDATE gms_bc_packets bp
7769: SET bp.award_result_code = DECODE (

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

7875: -- in gms_fck.when_other commit;
7876:
7877: RETURN (TRUE);
7878: IF g_debug = 'Y' THEN
7879: gms_error_pkg.gms_debug ('AFTER FUNDS CHECK', 'C');
7880: END IF;
7881: END gms_fc_process;
7882:
7883: --------------------------------------------------------------------------------------------------------------------------------------------------

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

7902: x_error_code :=0;
7903: x_error_buff :=null;
7904:
7905: IF g_debug = 'Y' THEN
7906: gms_error_pkg.gms_debug (g_error_procedure_name||':x_sobid,x_arrival_seq-'||x_sobid||','||x_arrival_seq, 'C');
7907: END IF;
7908:
7909: -- If Mode is Unreservation, assign Packet ID to Unreservation Packet ID
7910: -- and initialize Packet ID to 0. This is done here to prevent the approved

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

7918: -- ------------------------------------------------------------
7919: -- Setup and Summarization
7920: -- ('********* Calling GMS_SETUP *****************');
7921: -- ------------------------------------------------------------
7922: gms_error_pkg.gms_debug (g_error_procedure_name||'Calling gms_setup', 'C' );
7923: g_error_stage := 'gms_setup';
7924: IF NOT gms_setup (x_packetid, x_mode, x_partial,x_err_code,x_err_buff) THEN
7925: RETURN (FALSE);
7926: END IF;

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

7936:
7937: g_error_stage := 'gms_fc_process';
7938: IF x_mode IN ('S', 'B') THEN
7939: IF g_debug = 'Y' THEN
7940: gms_error_pkg.gms_debug ('BEFORE BASELINE', 'C');
7941: END IF;
7942: budget_fundscheck (x_packetid,x_err_code,x_err_buff);
7943: status_code_update (x_packetid, x_mode);
7944: IF g_debug = 'Y' THEN

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

7941: END IF;
7942: budget_fundscheck (x_packetid,x_err_code,x_err_buff);
7943: status_code_update (x_packetid, x_mode);
7944: IF g_debug = 'Y' THEN
7945: gms_error_pkg.gms_debug ('AFTER BASELINE', 'C');
7946: END IF;
7947: ELSE
7948: IF NOT gms_fc_process (x_packetid,x_arrival_seq,x_mode) THEN -- Bug 2176230
7949: RETURN (FALSE);

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

7949: RETURN (FALSE);
7950: END IF;
7951: END IF;
7952: IF g_debug = 'Y' THEN
7953: gms_error_pkg.gms_debug ( 'GMS_FCP-After Calling gms_fc_process', 'C' );
7954: gms_error_pkg.gms_debug ( 'GMS_FCP-END', 'C' );
7955: END IF;
7956: RETURN (TRUE);
7957: END gms_fcp;

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

7950: END IF;
7951: END IF;
7952: IF g_debug = 'Y' THEN
7953: gms_error_pkg.gms_debug ( 'GMS_FCP-After Calling gms_fc_process', 'C' );
7954: gms_error_pkg.gms_debug ( 'GMS_FCP-END', 'C' );
7955: END IF;
7956: RETURN (TRUE);
7957: END gms_fcp;
7958:

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

8047: END;
8048:
8049: IF x_result_code = 'F' THEN
8050: IF g_debug = 'Y' THEN
8051: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );
8052: END IF;
8053:
8054: status_code_update (x_packetid, 'E');
8055: x_e_code := 'H';

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

8055: x_e_code := 'H';
8056:
8057: ELSE -- update gms_bc_packets with approved status
8058: IF g_debug = 'Y' THEN
8059: gms_error_pkg.gms_debug ( 'Calling status_code_update for encumbrances', 'C' );
8060: END IF;
8061: status_code_update (x_packetid, 'E');
8062: x_e_code := 'S';
8063: END IF;

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

8178: g_error_procedure_name := 'Gms_fck_init';
8179: g_error_stage := 'Initalize Global Variables';
8180:
8181: IF g_debug = 'Y' THEN
8182: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');
8183: END IF;
8184:
8185: -- ==================================
8186: -- 1. Initalize global variables ...

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

8193: -- ==================================
8194: g_error_stage := 'Derive doc_type';
8195:
8196: IF g_debug = 'Y' THEN
8197: gms_error_pkg.gms_debug (g_error_procedure_name||':'||g_error_stage,'C');
8198: END IF;
8199:
8200: If g_mode = 'X' then -- p_mode check - I
8201: g_doc_type := 'EXP';

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

8236: END IF;
8237: END IF;
8238:
8239: IF g_debug = 'Y' THEN
8240: gms_error_pkg.gms_debug (g_error_procedure_name||':'||'Derived value of document type '||g_doc_type,'C');
8241: END IF;
8242:
8243: End if; -- p_mode check - I
8244:

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

8242:
8243: End if; -- p_mode check - I
8244:
8245: IF g_debug = 'Y' THEN
8246: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');

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

8243: End if; -- p_mode check - I
8244:
8245: IF g_debug = 'Y' THEN
8246: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
8251: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');

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

8244:
8245: IF g_debug = 'Y' THEN
8246: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
8251: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
8252: END IF;

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

8245: IF g_debug = 'Y' THEN
8246: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
8251: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
8252: END IF;
8253:

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

8246: gms_error_pkg.gms_debug (g_error_procedure_name||':Total txns. in gms_bc_packets -'||l_gms_txn_count, 'C');
8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
8251: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
8252: END IF;
8253:
8254: -- ======================================

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

8247: gms_error_pkg.gms_debug (g_error_procedure_name||':Total REQ txns in gms_bc_packets -'||l_req_count,'C');
8248: gms_error_pkg.gms_debug (g_error_procedure_name||':Total PO txns in gms_bc_packets -'||l_po_count,'C');
8249: gms_error_pkg.gms_debug (g_error_procedure_name||':Total AP txns in gms_bc_packets -'||l_ap_count,'C');
8250: gms_error_pkg.gms_debug (g_error_procedure_name||':Total FAB txns in gms_bc_packets -'||l_fab_count,'C');
8251: gms_error_pkg.gms_debug (g_error_procedure_name||':Document type (ALL indicates Submit/Baseline)-'||g_doc_type,'C');
8252: END IF;
8253:
8254: -- ======================================
8255: -- 3. Initalize global variables - part B

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

8284: End If;
8285:
8286:
8287: IF g_debug = 'Y' THEN
8288: gms_error_pkg.gms_debug ('GMS_FCK-derived values :g_derived_mode,g_partial_flag:'
8289: ||g_derived_mode||','||g_partial_flag,'C');
8290: END IF;
8291:
8292: -- Initialize currency precision variables ..

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

8570:
8571: BEGIN
8572:
8573: IF g_debug = 'Y' THEN
8574: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : packet_id = '|| p_packet_id,'C');
8575: END IF;
8576:
8577: -- Get the packet_id that was establised earlier ..
8578: OPEN get_temp_packet_id;

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

8580:
8581: IF get_temp_packet_id%FOUND THEN
8582:
8583: IF g_debug = 'Y' THEN
8584: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Previously establised packet is = '|| l_gms_packet_id,'C');
8585: END IF;
8586:
8587: /* Bug 5250793 : Added a join with gl_encumbrance_types so that the gl_bc_packets_rowid on gms_bc_packets is updated
8588: correctly for an invoice matched to a PO scenario. Before this change , the same gl_bc_packets_rowid was updated on

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

8596:
8597: FOR glbcrec in c_gl_bc_pkt LOOP
8598:
8599: IF g_debug = 'Y' THEN
8600: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: glbcrec.source_distribution_type:'|| glbcrec.source_distribution_type,'C');
8601: END IF;
8602:
8603: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8604: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..

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

8603: If glbcrec.source_distribution_type = 'AP_PREPAY' then
8604: -- This is reqd. as we cannot access ap_prepay_app_dists here .. autonomous ..
8605:
8606: IF g_debug = 'Y' THEN
8607: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Derive prepay dist id ','C');
8608: END IF;
8609:
8610: For x in g_ap_prepay_app_dist_id.FIRST..g_ap_prepay_app_dist_id.LAST loop
8611:

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

8609:
8610: For x in g_ap_prepay_app_dist_id.FIRST..g_ap_prepay_app_dist_id.LAST loop
8611:
8612: IF g_debug = 'Y' THEN
8613: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: g_ap_prepay_app_dist_id(x)'||g_ap_prepay_app_dist_id(x),'C');
8614: END IF;
8615:
8616: IF g_ap_prepay_app_dist_id(x) = glbcrec.source_distribution_id_num_1 then
8617: -- basically, if ap_prepay_app_dists.ap_prepay_dist_id is same as in gl

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

8619:
8620: l_dist_id := g_doc_dist_id_tab(x);
8621:
8622: If g_debug = 'Y' THEN
8623: gms_error_pkg.gms_debug ('Synch_gms_gl_packets: Found prepay dist,its:'||l_dist_id,'C');
8624: End If;
8625:
8626: EXIT;
8627: END IF;

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

8691:
8692: END LOOP;
8693:
8694: IF g_debug = 'Y' THEN
8695: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets except PO matched to an invoice '|| SQL%ROWCOUNT,'C');
8696: END IF;
8697:
8698: -- 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
8699: -- whereas for the corresponding record gms_bc_packets will have source_distribution_id_num_1 as po_distribution_id

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

8732: and gbc.status_code = 'I'
8733: and gbc.document_type ='PO';
8734:
8735: IF g_debug = 'Y' THEN
8736: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for PO matched to an invoice '|| SQL%ROWCOUNT,'C');
8737: END IF;
8738:
8739: /* Bug 5645290 - Start */
8740: Update gms_bc_packets gbc

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

8761: and gbc.parent_bc_packet_id is not null;
8762:
8763:
8764: IF g_debug = 'Y' THEN
8765: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : Updated bc packets for prepayment burden adjustment lines '|| SQL%ROWCOUNT,'C');
8766: END IF;
8767: /* Bug 5645290 - End */
8768:
8769: END IF;

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

8769: END IF;
8770: CLOSE get_temp_packet_id;
8771:
8772: IF g_debug = 'Y' THEN
8773: gms_error_pkg.gms_debug ('Synch_gms_gl_packets Strat : End ','C');
8774: END IF;
8775:
8776: End Synch_gms_gl_packets;
8777:

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

8830:
8831: x_err_code := 0;
8832: x_err_buff := null;
8833:
8834: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
8835:
8836: IF g_debug = 'Y' THEN
8837: gms_error_pkg.gms_debug (g_error_procedure_name||':packet,x_mode,x_partial:'||
8838: g_packet_id||','||g_mode||','||x_partial,'C');

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

8833:
8834: gms_error_pkg.set_debug_context; -- Added for Bug: 2510024
8835:
8836: IF g_debug = 'Y' THEN
8837: gms_error_pkg.gms_debug (g_error_procedure_name||':packet,x_mode,x_partial:'||
8838: g_packet_id||','||g_mode||','||x_partial,'C');
8839: END IF;
8840:
8841: -- ---------------------------------------------------------------------------------------------------------+

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

8847: -- 2. Call gms_fck_init
8848: -------------------------------------------------------------------------------+
8849: x_e_stage := 'Before gms_fck_init call';
8850: IF g_debug = 'Y' THEN
8851: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8852: END IF;
8853:
8854: gms_fck_init(p_partial_flag => x_partial);
8855:

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

8861: If g_non_gms_txn then
8862: x_e_stage := 'All txns. non-gms, exit GMS-FC';
8863:
8864: IF g_debug = 'Y' THEN
8865: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8866: END IF;
8867:
8868: x_return_code := 'S';
8869: RETURN g_non_gms_txn;

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

8881: -- This procedure will delete pending records from gms_bc_packets
8882: -------------------------------------------------------------------------------+
8883: x_e_stage := 'delete_pending_txns';
8884: IF g_debug = 'Y' THEN
8885: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8886: END IF;
8887:
8888: delete_pending_txns(x_err_code,x_err_buff);
8889:

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

8907: -- R12 Funds Management Uptake : R12 open issue
8908: IF g_doc_type = 'AP' and x_mode = 'R' then
8909: x_e_stage := 'si_adjustments';
8910: IF g_debug = 'Y' THEN
8911: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8912: END IF;
8913:
8914: si_adjustments(x_packetid, l_pkt_row) ;
8915: IF l_pkt_row = 0 THEN

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

8930:
8931: IF g_debug = 'Y' THEN
8932: g_error_procedure_name := 'Gms_fck';
8933: x_e_stage := 'ENC:Derive ind';
8934: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8935: End If;
8936:
8937: CALC_ENC_IND_COMPILED_SET_ID (x_packetid);
8938:

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

8938:
8939: IF g_debug = 'Y' THEN
8940: g_error_procedure_name := 'Gms_fck';
8941: x_e_stage := 'ENC:Handle_net_zero_txn:Net_Zero';
8942: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8943: End If;
8944: -- Check if adjusted and adjusting transactions are present in the same packet
8945: -- If so, update them with result_code 'P82' and update effect_on_funds_code
8946: -- to 'I' so that 'funds avilable' calculation ignores them.

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

8949:
8950: IF g_debug = 'Y' THEN
8951: g_error_procedure_name := 'Gms_fck';
8952: x_e_stage := 'ENC:Handle_net_zero_txn:Check_Adjusted';
8953: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8954: End If;
8955: -- Fail adjusting transaction, if original transaction has not been FC'ed(F08)
8956:
8957: HANDLE_NET_ZERO_TXN(x_packetid, 'Check_Adjusted');

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

8971: -- Calling burden calculation for all except for mode : Submit,Baseline,Interface
8972: IF g_debug = 'Y' THEN
8973: x_e_stage := 'Burdenable Raw Cost calculation';
8974: g_error_procedure_name := 'Gms_fck';
8975: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
8976: END IF;
8977:
8978: -- 8A. CALCULATING BURDENABLE RAW COST
8979: -- pass g_derived_mode parameter ...

Line 9007: gms_error_pkg.gms_debug (

9003: -- R12 Funds Management Uptake : burden calculation logic for x_mode ='R'/'U'/'C'
9004: -- shifted to main session procedure copy_gl_pkt_to_gms_pkt.
9005:
9006: IF g_debug = 'Y' THEN
9007: gms_error_pkg.gms_debug (
9008: 'GMS_FCK-After Calling gms_cost_plus_extn.update_bc_pkt_burden_raw_cost','C');
9009: END IF;
9010:
9011: END IF;

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

9018:
9019: x_e_stage := 'misc_gms_idc';
9020: IF g_debug = 'Y' THEN
9021: g_error_procedure_name := 'Gms_fck';
9022: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
9023: END IF;
9024:
9025: IF NOT misc_gms_idc (x_packetid) THEN
9026: RETURN (FALSE);

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

9035:
9036: x_e_stage := 'gms_fcp';
9037: IF g_debug = 'Y' THEN
9038: g_error_procedure_name := 'Gms_fck';
9039: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
9040: END IF;
9041:
9042: -- pass g_derived_mode parameter ...
9043: IF NOT gms_fcp (x_sobid, x_packetid, g_derived_mode, g_partial_flag, x_arrival_seq,

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

9047:
9048: COMMIT;
9049:
9050: IF g_debug = 'Y' THEN
9051: gms_error_pkg.gms_debug ('GMS_FCK-After Calling gms_fcp', 'C');
9052: END IF;
9053:
9054: -------------------------------------------------------------------------------+
9055: -- 11. Posting for encumbrances ..

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

9058: x_e_stage := 'Posting for encumbrances';
9059: g_error_procedure_name := 'Gms_fck';
9060: --g_error_procedure_name := 'update_source_burden_raw_cost';
9061: IF g_debug = 'Y' THEN
9062: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
9063: END IF;
9064:
9065: IF NOT gms_cost_plus_extn.update_source_burden_raw_cost (x_packetid, x_mode, g_partial_flag) THEN
9066: IF g_debug = 'Y' THEN

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

9063: END IF;
9064:
9065: IF NOT gms_cost_plus_extn.update_source_burden_raw_cost (x_packetid, x_mode, g_partial_flag) THEN
9066: IF g_debug = 'Y' THEN
9067: gms_error_pkg.gms_debug ('GMS_FCK- Posting for encumbrances ..failed','C');
9068: END IF;
9069: result_status_code_update (
9070: p_packet_id=> x_packetid,
9071: p_status_code=> 'T',

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

9083:
9084: x_e_stage := 'Update status on failed bcpkt';
9085: IF g_debug = 'Y' THEN
9086: g_error_procedure_name := 'Gms_fck';
9087: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
9088: END IF;
9089:
9090: update_status_on_failed_txns(x_packetid);
9091:

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

9100: If x_mode in ('R','U','C','E','S','B') then
9101: x_e_stage := 'Determine return code';
9102: IF g_debug = 'Y' THEN
9103: g_error_procedure_name := 'Gms_fck';
9104: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage,'C');
9105: END IF;
9106:
9107: IF NOT gms_return_code (x_packetid, g_derived_mode, g_partial_flag, x_return_code, x_e_code, x_err_buff) THEN
9108: RETURN FALSE;

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

9109: END IF;
9110:
9111: IF g_debug = 'Y' THEN
9112: g_error_procedure_name := 'Gms_fck';
9113: gms_error_pkg.gms_debug (g_error_procedure_name||':'||x_e_stage||':return code'||x_return_code,'C');
9114: END IF;
9115: End If;
9116:
9117: <>

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

9115: End If;
9116:
9117: <>
9118: IF g_debug = 'Y' THEN
9119: gms_error_pkg.gms_debug (' ********** End of GMS_FCK ********** ', 'C');
9120: END IF;
9121: COMMIT;
9122:
9123: RETURN (TRUE);

Line 9132: gms_error_pkg.gms_message (

9128: x_e_stage := SQLCODE||' '||SQLERRM; -- Bug 2337897 : Added SQLCODE
9129: g_return_code := 'T';
9130: x_return_code := 'T';
9131:
9132: gms_error_pkg.gms_message (
9133: x_err_name=> 'GMS_UNEXPECTED_ERROR',
9134: x_token_name1=> 'PROGRAM_NAME',
9135: x_token_val1=> g_error_program_name || '.' || g_error_procedure_name || '.' || g_error_stage,
9136: x_token_name2=> 'SQLCODE',