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.IGI_EXP_HOLDS dependencies on AP_HOLDS

Line 97: INSERT INTO ap_holds

93: ' l_get_hold_reason --> ' || l_get_hold_reason.displayed_field);
94: -- =============== END DEBUG LOG ==================
95:
96: -- Bug#5905190 : Add Hold Id, org_id column while inserting
97: INSERT INTO ap_holds
98: (invoice_id,
99: hold_lookup_code,
100: last_update_date,
101: last_updated_by,

Line 121: AP_HOLDS_S.NEXTVAL,

117: SYSDATE,
118: -- Bug No:2517124
119: l_get_hold_reason.displayed_field, --'Exchange Protocol Hold',
120: 'S',
121: AP_HOLDS_S.NEXTVAL,
122: mo_global.get_current_org_id()
123: FROM SYS.DUAL
124: WHERE NOT EXISTS(SELECT 'x'
125: FROM ap_holds_all ah2

Line 125: FROM ap_holds_all ah2

121: AP_HOLDS_S.NEXTVAL,
122: mo_global.get_current_org_id()
123: FROM SYS.DUAL
124: WHERE NOT EXISTS(SELECT 'x'
125: FROM ap_holds_all ah2
126: WHERE ah2.invoice_id = p_invoice_id
127: AND ah2.hold_lookup_code = 'AWAIT EXP APP'
128: AND (NVL(ah2.release_lookup_code, 'NULL') <> 'HOLDS QUICK RELEASED'
129: AND NVL(ah2.release_lookup_code, 'NULL') <> 'EXP HOLD RELEASE'));

Line 133: ' INSERT INTO ap_holds --> ' || SQL%ROWCOUNT);

129: AND NVL(ah2.release_lookup_code, 'NULL') <> 'EXP HOLD RELEASE'));
130:
131: -- =============== START DEBUG LOG ================
132: Debug_log_string (l_proc_level, 'Set_hold.Msg4',
133: ' INSERT INTO ap_holds --> ' || SQL%ROWCOUNT);
134: Debug_log_string (l_proc_level, 'Set_hold.Msg1',
135: ' ** END SET_HOLD ** ');
136: -- =============== END DEBUG LOG ==================
137:

Line 181: UPDATE ap_holds_all

177: -- =============== END DEBUG LOG ==================
178:
179: -- Bug No: 2517124 sowsubra changed the statement to select the
180: -- displayed_field column instead of the description column.
181: UPDATE ap_holds_all
182: SET release_lookup_code = l_release_lookup_code,
183: release_reason = (SELECT displayed_field
184: FROM ap_lookup_codes
185: WHERE lookup_code = l_release_lookup_code

Line 195: ' UPDATE ap_holds_all --> ' || SQL%ROWCOUNT);

191: AND hold_lookup_code = p_hold_lookup_code;
192:
193: -- =============== START DEBUG LOG ================
194: Debug_log_string (l_proc_level, 'Release_hold.Msg3',
195: ' UPDATE ap_holds_all --> ' || SQL%ROWCOUNT);
196: Debug_log_string (l_proc_level, 'Set_hold.Msg4',
197: ' ** END RELEASE_HOLD ** ');
198: -- =============== END DEBUG LOG ==================
199:

Line 227: FROM ap_holds_all

223: CURSOR c_hold_status IS
224: SELECT DECODE(release_lookup_code,
225: NULL, 'ALREADY ON HOLD',
226: 'RELEASED BY USER')
227: FROM ap_holds_all
228: WHERE invoice_id = p_invoice_id
229: AND hold_lookup_code = p_hold_lookup_code
230: AND release_lookup_code IS NULL;
231: BEGIN

Line 337: FROM ap_holds_all

333:
334: -- Get the number of unreleased holds for the invoice
335: SELECT COUNT(*)
336: INTO l_invoice_holds
337: FROM ap_holds_all
338: WHERE invoice_id = p_invoice_id
339: AND release_lookup_code IS NULL;
340:
341: -- =============== START DEBUG LOG ================

Line 550: -- PROCEDURE: Igi_Exp_Ap_Holds_T2

546: RAISE_APPLICATION_ERROR(-20001, fnd_message.get);
547: END Invoice_Not_Excluded ;
548:
549: --========================================================================
550: -- PROCEDURE: Igi_Exp_Ap_Holds_T2
551: -- Called from Trigger IGI_EXP_AP_HOLDS_T2
552: --========================================================================
553:
554: PROCEDURE Igi_Exp_Ap_Holds_T2(p_calling_sequence IN VARCHAR2)

Line 551: -- Called from Trigger IGI_EXP_AP_HOLDS_T2

547: END Invoice_Not_Excluded ;
548:
549: --========================================================================
550: -- PROCEDURE: Igi_Exp_Ap_Holds_T2
551: -- Called from Trigger IGI_EXP_AP_HOLDS_T2
552: --========================================================================
553:
554: PROCEDURE Igi_Exp_Ap_Holds_T2(p_calling_sequence IN VARCHAR2)
555: IS

Line 554: PROCEDURE Igi_Exp_Ap_Holds_T2(p_calling_sequence IN VARCHAR2)

550: -- PROCEDURE: Igi_Exp_Ap_Holds_T2
551: -- Called from Trigger IGI_EXP_AP_HOLDS_T2
552: --========================================================================
553:
554: PROCEDURE Igi_Exp_Ap_Holds_T2(p_calling_sequence IN VARCHAR2)
555: IS
556: l_debug_loc VARCHAR2(30);
557: l_debug_info VARCHAR2(250);
558: l_invoice_id NUMBER;

Line 569: FROM ap_holds_all ah

565:
566: CURSOR c_exp_hold_released(p_invoice_id NUMBER)
567: IS
568: SELECT 'x'
569: FROM ap_holds_all ah
570: WHERE ah.invoice_id = p_invoice_id
571: AND ah.hold_lookup_code = 'AWAIT EXP APP'
572: AND ah.release_lookup_code = 'EXP HOLD RELEASE'
573: AND NOT EXISTS(SELECT 'x'

Line 574: FROM ap_holds_all ah2

570: WHERE ah.invoice_id = p_invoice_id
571: AND ah.hold_lookup_code = 'AWAIT EXP APP'
572: AND ah.release_lookup_code = 'EXP HOLD RELEASE'
573: AND NOT EXISTS(SELECT 'x'
574: FROM ap_holds_all ah2
575: WHERE ah2.invoice_id = p_invoice_id
576: AND ah.hold_lookup_code = 'AWAIT EXP APP'
577: AND ah2.release_lookup_code IS NULL);
578:

Line 582: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg1',

578:
579:
580: BEGIN
581: -- =============== START DEBUG LOG ================
582: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg1',
583: ' ** START IGI_EXP_AP_HOLDS_T2 ** ');
584: -- =============== END DEBUG LOG ==================
585:
586: --Initialize variables inside BEGIN bacause of GSCC Standard - File.sql.35

Line 583: ' START IGI_EXP_AP_HOLDS_T2 ');

579:
580: BEGIN
581: -- =============== START DEBUG LOG ================
582: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg1',
583: ' ** START IGI_EXP_AP_HOLDS_T2 ** ');
584: -- =============== END DEBUG LOG ==================
585:
586: --Initialize variables inside BEGIN bacause of GSCC Standard - File.sql.35
587: l_debug_loc := 'IGI_EXP_AP_HOLDS_T2';

Line 587: l_debug_loc := 'IGI_EXP_AP_HOLDS_T2';

583: ' ** START IGI_EXP_AP_HOLDS_T2 ** ');
584: -- =============== END DEBUG LOG ==================
585:
586: --Initialize variables inside BEGIN bacause of GSCC Standard - File.sql.35
587: l_debug_loc := 'IGI_EXP_AP_HOLDS_T2';
588: l_calling_sequence := 'AWAIT EXP APP';
589: -- Bug 5905190 Start - Variable not initialised
590: l_hold_lookup_code := 'AWAIT EXP APP';
591: -- Bug 5905190 End

Line 597: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg2',

593: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
594: p_calling_sequence;
595:
596: -- =============== START DEBUG LOG ================
597: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg2',
598: ' l_calling_sequence --> ' || l_calling_sequence);
599: -- =============== END DEBUG LOG ==================
600:
601: FOR i IN 1 .. igi_exp_holds.l_TableRow

Line 607: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg3',

603:
604: l_invoice_id := igi_exp_holds.l_InvoiceidTable(i);
605:
606: -- =============== START DEBUG LOG ================
607: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg3',
608: ' l_invoice_id --> ' || l_invoice_id);
609: -- =============== END DEBUG LOG ==================
610:
611: OPEN c_exp_hold_released(l_invoice_id);

Line 626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',

622: FROM AP_INVOICES_ALL a
623: WHERE a.invoice_id = l_invoice_id;
624:
625: -- =============== START DEBUG LOG ================
626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',
627: ' l_source --> ' || l_source);
628: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg5',
629: ' l_cancelled_date --> ' || l_cancelled_date);
630: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg6',

Line 628: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg5',

624:
625: -- =============== START DEBUG LOG ================
626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',
627: ' l_source --> ' || l_source);
628: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg5',
629: ' l_cancelled_date --> ' || l_cancelled_date);
630: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg6',
631: ' l_temp_cancelled_amount --> ' || l_temp_cancelled_amount);
632: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg7',

Line 630: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg6',

626: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg4',
627: ' l_source --> ' || l_source);
628: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg5',
629: ' l_cancelled_date --> ' || l_cancelled_date);
630: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg6',
631: ' l_temp_cancelled_amount --> ' || l_temp_cancelled_amount);
632: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg7',
633: ' Calling igi_exp_holds.Place_Release_Hold ');
634: -- =============== END DEBUG LOG ==================

Line 632: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg7',

628: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg5',
629: ' l_cancelled_date --> ' || l_cancelled_date);
630: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg6',
631: ' l_temp_cancelled_amount --> ' || l_temp_cancelled_amount);
632: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg7',
633: ' Calling igi_exp_holds.Place_Release_Hold ');
634: -- =============== END DEBUG LOG ==================
635:
636: igi_exp_holds.Place_Release_Hold(l_invoice_id,

Line 647: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg8',

643: l_calling_sequence,
644: l_temp_cancelled_Amount);
645:
646: -- =============== START DEBUG LOG ================
647: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg8',
648: ' out of igi_exp_holds.Place_Release_Hold');
649: -- =============== END DEBUG LOG ==================
650:
651: END IF;

Line 656: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg9',

652: CLOSE c_exp_hold_released;
653: END LOOP;
654:
655: -- =============== START DEBUG LOG ================
656: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg9',
657: ' ** END IGI_EXP_AP_HOLDS_T2 ** ');
658: -- =============== END DEBUG LOG ==================
659:
660: EXCEPTION

Line 657: ' END IGI_EXP_AP_HOLDS_T2 ');

653: END LOOP;
654:
655: -- =============== START DEBUG LOG ================
656: Debug_log_string (l_proc_level, 'Igi_exp_ap_holds_t2.Msg9',
657: ' ** END IGI_EXP_AP_HOLDS_T2 ** ');
658: -- =============== END DEBUG LOG ==================
659:
660: EXCEPTION
661: WHEN OTHERS THEN

Line 668: END Igi_Exp_Ap_Holds_T2;

664: DEBUG_LOG_UNEXP_ERROR ('Invoice_not_included.unexp1','DEFAULT');
665: -- =============== END DEBUG LOG ==================
666: END IF;
667: RAISE_APPLICATION_ERROR(-20001, fnd_message.get);
668: END Igi_Exp_Ap_Holds_T2;
669:
670: -- Bug 2438858 Start
671: --========================================================================
672: -- PROCEDURE: Igi_Exp_Ap_Inv_Dist_T2

Line 899: From AP_HOLDS_ALL

895:
896: CURSOR cur_get_SIA_Hold(p_inv_id ap_invoices_all.invoice_id%type)
897: IS
898: Select hold_lookup_code
899: From AP_HOLDS_ALL
900: Where invoice_id = p_inv_id
901: And hold_lookup_code = 'AWAIT_SEC_APP'
902: And release_lookup_code is not null;
903:

Line 904: l_Hold_Lookup_Code AP_HOLDS.Hold_Lookup_Code%TYPE;

900: Where invoice_id = p_inv_id
901: And hold_lookup_code = 'AWAIT_SEC_APP'
902: And release_lookup_code is not null;
903:
904: l_Hold_Lookup_Code AP_HOLDS.Hold_Lookup_Code%TYPE;
905: l_SapStatusFlag VARCHAR2(1);
906: l_SapErrorNum NUMBER;
907:
908: BEGIN

Line 1204: 'Deleting from AP_holds --> ' || SQL%ROWCOUNT );

1200: l_calling_sequence);
1201:
1202: -- =============== START DEBUG LOG ================
1203: Debug_log_string (l_proc_level, 'Place_Release_Hold.Msg38',
1204: 'Deleting from AP_holds --> ' || SQL%ROWCOUNT );
1205: -- =============== END DEBUG LOG ==================
1206:
1207: END IF; -- already on hold
1208:

Line 1214: This was to delete the EXP hold from AP_HOLDS_ALL, so allow the invoice to

1210: END IF; -- 'P' to place hold
1211:
1212: /***********************************
1213: The following code snippet below was originally put in to fix bug 3595853.
1214: This was to delete the EXP hold from AP_HOLDS_ALL, so allow the invoice to
1215: be cancelled (by AP - in package AP_CANCEL_PKG Function: ap_cancel_single_invoice).
1216: However now that all EXP HOLDS are RELEASED, rather than deleted
1217: (requirement by AX - bug 3801520).
1218: This fix is no longer required as the above code snippet suffices; invoice amount

Line 1250: 'Deleting from AP_holds --> ' || SQL%ROWCOUNT );

1246: l_calling_sequence);
1247:
1248: -- =============== START DEBUG LOG ================
1249: Debug_log_string (l_proc_level, 'Place_Release_Hold.Msg41',
1250: 'Deleting from AP_holds --> ' || SQL%ROWCOUNT );
1251: -- =============== END DEBUG LOG ==================
1252:
1253: END IF; -- amounts are different
1254: END IF;