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 IGI_EXP_HOLDS

Line 1: PACKAGE BODY igi_exp_holds AS

1: PACKAGE BODY igi_exp_holds AS
2: -- $Header: igiexprb.pls 120.16.12000000.1 2007/09/13 04:24:26 mbremkum ship $
3:
4: /* ============== FND LOG VARIABLES ================== */
5: l_debug_level number := FND_LOG.G_CURRENT_RUNTIME_LEVEL ;

Line 26: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);

22: IF (P_error_type = 'DEFAULT') THEN
23: FND_MESSAGE.SET_NAME('IGI','IGI_LOGGING_UNEXP_ERROR');
24: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
25: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
26: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);
27: ELSIF (P_error_type = 'USER') THEN
28: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);
29: END IF;
30:

Line 28: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);

24: FND_MESSAGE.SET_TOKEN('CODE',sqlcode);
25: FND_MESSAGE.SET_TOKEN('MSG',sqlerrm);
26: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);
27: ELSIF (P_error_type = 'USER') THEN
28: FND_LOG.MESSAGE(l_unexp_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module ,TRUE);
29: END IF;
30:
31: END IF;
32:

Line 44: FND_LOG.STRING(P_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module, P_message) ;

40:
41: BEGIN
42:
43: IF (P_level >= l_debug_level) THEN
44: FND_LOG.STRING(P_level, 'igi.plsql.igiexprb.igi_exp_holds.' || P_module, P_message) ;
45: END IF;
46:
47: END Debug_log_string;
48:

Line 79: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'|| p_calling_sequence;

75: -- GSCC File.sql.35
76: l_debug_loc := 'Set_Hold';
77:
78: -- Update the calling sequence
79: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'|| p_calling_sequence;
80:
81: -- =============== START DEBUG LOG ================
82: Debug_log_string (l_proc_level, 'Set_hold.Msg2',
83: ' p_Calling_Sequence --> ' || p_calling_sequence);

Line 171: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

167: l_release_lookup_code := 'EXP HOLD RELEASE';
168: l_debug_loc :='Release_Hold';
169:
170: -- Update the calling sequence
171: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
172: p_calling_sequence;
173:
174: -- =============== START DEBUG LOG ================
175: Debug_log_string (l_proc_level, 'Release_hold.Msg2',

Line 242: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

238: l_debug_loc :='Get_Hold_Status';
239: -- Initialize to NOT ON HOLD in case the CURSOR retrieves no records.
240: p_status := 'NOT ON HOLD';
241: -- Update the calling sequence
242: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
243: p_calling_sequence;
244:
245: -- =============== START DEBUG LOG ================
246: Debug_log_string (l_proc_level, 'Get_hold_status.Msg2',

Line 316: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

312: -- =============== END DEBUG LOG ==================
313:
314: -- Initialize variables inside BEGIN bacause of GSCC Standard - File.sql.35
315: l_debug_loc := 'get_approval_status';
316: p_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
317: p_calling_sequence;
318:
319: -- =============== START DEBUG LOG ================
320: Debug_log_string (l_proc_level, 'Get_Approval_status.Msg2',

Line 503: l_curr_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

499:
500: -- GSCC Standard - File.sql.35
501: l_debug_loc := 'invoice_not_excluded';
502: -- Update the calling sequence
503: l_curr_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
504: p_calling_sequence;
505:
506: -- =============== START DEBUG LOG ================
507: Debug_log_string (l_proc_level, 'Invoice_not_included.Msg2',

Line 593: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

589: -- Bug 5905190 Start - Variable not initialised
590: l_hold_lookup_code := 'AWAIT EXP APP';
591: -- Bug 5905190 End
592: -- Update the calling sequence --
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',

Line 601: FOR i IN 1 .. igi_exp_holds.l_TableRow

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
602: LOOP
603:
604: l_invoice_id := igi_exp_holds.l_InvoiceidTable(i);
605:

Line 604: l_invoice_id := igi_exp_holds.l_InvoiceidTable(i);

600:
601: FOR i IN 1 .. igi_exp_holds.l_TableRow
602: LOOP
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);

Line 633: ' Calling igi_exp_holds.Place_Release_Hold ');

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,
637: -- Bug 2469158

Line 636: igi_exp_holds.Place_Release_Hold(l_invoice_id,

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,
637: -- Bug 2469158
638: '', -- invoice amount
639: l_source,
640: l_cancelled_date,

Line 648: ' out of igi_exp_holds.Place_Release_Hold');

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;
652: CLOSE c_exp_hold_released;

Line 698: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

694: l_debug_loc := 'IGI_EXP_AP_INV_DIST_T2';
695: l_calling_sequence := 'AWAIT EXP APP';
696:
697: -- Update the calling sequence --
698: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
699: p_calling_sequence;
700:
701: -- =============== START DEBUG LOG ================
702: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg2',

Line 706: FOR i IN 1 .. igi_exp_holds.l_DistTableRow LOOP

702: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg2',
703: ' l_calling_sequence --> ' || l_calling_sequence);
704: -- =============== END DEBUG LOG ==================
705:
706: FOR i IN 1 .. igi_exp_holds.l_DistTableRow LOOP
707:
708: l_invoice_id := igi_exp_holds.l_InvoiceidDistTable(i);
709:
710: -- =============== START DEBUG LOG ================

Line 708: l_invoice_id := igi_exp_holds.l_InvoiceidDistTable(i);

704: -- =============== END DEBUG LOG ==================
705:
706: FOR i IN 1 .. igi_exp_holds.l_DistTableRow LOOP
707:
708: l_invoice_id := igi_exp_holds.l_InvoiceidDistTable(i);
709:
710: -- =============== START DEBUG LOG ================
711: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg3',
712: ' l_invoice_id --> ' || l_invoice_id );

Line 732: ' Calling igi_exp_holds.Place_Release_Hold ' );

728: ' l_cancelled_date --> ' || l_cancelled_date );
729: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg6',
730: ' l_temp_cancelled_amount --> ' || l_temp_cancelled_amount );
731: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg7',
732: ' Calling igi_exp_holds.Place_Release_Hold ' );
733: -- =============== END DEBUG LOG ==================
734:
735: igi_exp_holds.Place_Release_Hold(l_invoice_id,
736: -- Bug 2469158

Line 735: igi_exp_holds.Place_Release_Hold(l_invoice_id,

731: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg7',
732: ' Calling igi_exp_holds.Place_Release_Hold ' );
733: -- =============== END DEBUG LOG ==================
734:
735: igi_exp_holds.Place_Release_Hold(l_invoice_id,
736: -- Bug 2469158
737: '', -- invoice amount
738: l_source,
739: l_cancelled_date,

Line 748: ' Out of igi_exp_holds.Place_Release_Hold ' );

744: );
745:
746: -- =============== START DEBUG LOG ================
747: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Dist_T2.Msg8',
748: ' Out of igi_exp_holds.Place_Release_Hold ' );
749: -- =============== END DEBUG LOG ==================
750: END LOOP;
751:
752: -- =============== START DEBUG LOG ================

Line 796: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||

792: l_debug_loc := 'IGI_EXP_AP_INV_LINE_T2';
793: l_calling_sequence := 'AWAIT EXP APP';
794:
795: -- Update the calling sequence --
796: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||
797: p_calling_sequence;
798:
799: -- =============== START DEBUG LOG ================
800: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg2',

Line 804: FOR i IN 1 .. igi_exp_holds.l_LineTableRow LOOP

800: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg2',
801: ' l_calling_sequence --> ' || l_calling_sequence);
802: -- =============== END DEBUG LOG ==================
803:
804: FOR i IN 1 .. igi_exp_holds.l_LineTableRow LOOP
805:
806: l_invoice_id := igi_exp_holds.l_InvoiceidLineTable(i);
807:
808: -- =============== START DEBUG LOG ================

Line 806: l_invoice_id := igi_exp_holds.l_InvoiceidLineTable(i);

802: -- =============== END DEBUG LOG ==================
803:
804: FOR i IN 1 .. igi_exp_holds.l_LineTableRow LOOP
805:
806: l_invoice_id := igi_exp_holds.l_InvoiceidLineTable(i);
807:
808: -- =============== START DEBUG LOG ================
809: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg3',
810: ' l_invoice_id --> ' || l_invoice_id );

Line 830: ' Calling igi_exp_holds.Place_Release_Hold ' );

826: ' l_cancelled_date --> ' || l_cancelled_date );
827: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg6',
828: ' l_temp_cancelled_amount --> ' || l_temp_cancelled_amount );
829: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg7',
830: ' Calling igi_exp_holds.Place_Release_Hold ' );
831: -- =============== END DEBUG LOG ==================
832:
833: igi_exp_holds.Place_Release_Hold(l_invoice_id,
834: -- Bug 2469158

Line 833: igi_exp_holds.Place_Release_Hold(l_invoice_id,

829: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg7',
830: ' Calling igi_exp_holds.Place_Release_Hold ' );
831: -- =============== END DEBUG LOG ==================
832:
833: igi_exp_holds.Place_Release_Hold(l_invoice_id,
834: -- Bug 2469158
835: '', -- invoice amount
836: l_source,
837: l_cancelled_date,

Line 846: ' Out of igi_exp_holds.Place_Release_Hold ' );

842: );
843:
844: -- =============== START DEBUG LOG ================
845: Debug_log_string (l_proc_level, 'Igi_Exp_Ap_Inv_Line_T2.Msg8',
846: ' Out of igi_exp_holds.Place_Release_Hold ' );
847: -- =============== END DEBUG LOG ==================
848: END LOOP;
849:
850: -- =============== START DEBUG LOG ================

Line 951: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||p_calling_sequence;

947: ' l_SapErrorNum --> ' || l_SapErrorNum);
948: -- =============== END DEBUG LOG ==================
949:
950: -- Update the calling sequence
951: l_calling_sequence := 'IGI_EXP_HOLDS.'||l_debug_loc||'<-'||p_calling_sequence;
952:
953: -- =============== START DEBUG LOG ================
954: Debug_log_string (l_proc_level, 'Place_Release_Hold.Msg11',
955: ' l_calling_sequence --> ' || l_calling_sequence);

Line 1277: END igi_exp_holds;

1273: END IF;
1274: RAISE_APPLICATION_ERROR(-20001, fnd_message.get);
1275: END Place_Release_Hold;
1276:
1277: END igi_exp_holds;