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.OE_ORDER_PVT dependencies on OE_ORDER_UTIL

Line 49: oe_debug_pub.add( 'RECURSION MODE WITHOUT EXP AT ENTRY -' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;

45: oe_debug_pub.add( 'ENTER SET RECURSION MODE' , 1 ) ;
46: oe_debug_pub.add( 'ENTITY CODE-'||P_ENTITY_CODE , 1 ) ;
47: oe_debug_pub.add( 'ENTRY-EXIT MODE -'||P_IN_OUT , 1 ) ;
48: oe_debug_pub.add( 'RECURSION MODE AT ENTRY -' || OE_GLOBALS.G_RECURSION_MODE , 1 ) ;
49: oe_debug_pub.add( 'RECURSION MODE WITHOUT EXP AT ENTRY -' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;
50: END IF;
51:
52: IF p_entity_code = 1 THEN
53: IF p_In_Out = 1 THEN

Line 68: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

64: prn_ctr > 0 OR
65: pr_ctr > 0 ) THEN
66: --prrt_ctr > 0 ) THEN
67: oe_globals.g_recursion_mode := 'Y';
68: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
69: ELSE
70: oe_globals.g_recursion_mode := 'N';
71: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
72: END IF;

Line 71: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

67: oe_globals.g_recursion_mode := 'Y';
68: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
69: ELSE
70: oe_globals.g_recursion_mode := 'N';
71: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
72: END IF;
73:
74: /* This is added to control notification call to just one call out. */
75: IF po_ctr > 1 THEN

Line 76: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

72: END IF;
73:
74: /* This is added to control notification call to just one call out. */
75: IF po_ctr > 1 THEN
76: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
77: ELSE
78: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
79: END IF;
80:

Line 78: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

74: /* This is added to control notification call to just one call out. */
75: IF po_ctr > 1 THEN
76: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
77: ELSE
78: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
79: END IF;
80:
81: NULL;
82: ELSIF p_entity_code = 2 THEN

Line 91: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

87: hdr_ctr := hdr_ctr - 1;
88: END IF;
89: IF hdr_ctr > 1 THEN
90: oe_globals.g_recursion_mode := 'Y';
91: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
92: ELSE
93: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
94: null; /* SAM */
95: END IF;

Line 93: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

89: IF hdr_ctr > 1 THEN
90: oe_globals.g_recursion_mode := 'Y';
91: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
92: ELSE
93: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
94: null; /* SAM */
95: END IF;
96:
97:

Line 107: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

103: hdr_adj_ctr := hdr_adj_ctr - 1;
104: END IF;
105: IF hdr_adj_ctr > 1 THEN
106: oe_globals.g_recursion_mode := 'Y';
107: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
108: ELSE
109: oe_globals.g_recursion_mode := 'N';
110: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
111: END IF;

Line 110: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

106: oe_globals.g_recursion_mode := 'Y';
107: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
108: ELSE
109: oe_globals.g_recursion_mode := 'N';
110: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
111: END IF;
112:
113: NULL;
114:

Line 124: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

120: hdr_scredit_ctr := hdr_scredit_ctr - 1;
121: END IF;
122: IF hdr_scredit_ctr > 1 THEN
123: oe_globals.g_recursion_mode := 'Y';
124: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
125: ELSE
126: oe_globals.g_recursion_mode := 'N';
127: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
128: END IF;

Line 127: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

123: oe_globals.g_recursion_mode := 'Y';
124: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
125: ELSE
126: oe_globals.g_recursion_mode := 'N';
127: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
128: END IF;
129:
130: NULL;
131: ELSIF p_entity_code = 5 THEN

Line 139: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

135: line_ctr := line_ctr - 1;
136: END IF;
137: IF line_ctr > 1 THEN
138: oe_globals.g_recursion_mode := 'Y';
139: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
140: ELSE
141: oe_globals.g_recursion_mode := 'N';
142: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
143: END IF;

Line 142: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

138: oe_globals.g_recursion_mode := 'Y';
139: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
140: ELSE
141: oe_globals.g_recursion_mode := 'N';
142: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
143: END IF;
144:
145: NULL;
146: ELSIF p_entity_code = 6 THEN

Line 154: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

150: line_adj_ctr := line_adj_ctr - 1;
151: END IF;
152: IF line_adj_ctr > 1 THEN
153: oe_globals.g_recursion_mode := 'Y';
154: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
155: ELSE
156: oe_globals.g_recursion_mode := 'N';
157: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
158: END IF;

Line 157: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

153: oe_globals.g_recursion_mode := 'Y';
154: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
155: ELSE
156: oe_globals.g_recursion_mode := 'N';
157: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
158: END IF;
159:
160: NULL;
161: ELSIF p_entity_code = 7 THEN

Line 169: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

165: line_scredit_ctr := line_scredit_ctr - 1;
166: END IF;
167: IF line_scredit_ctr > 1 THEN
168: oe_globals.g_recursion_mode := 'Y';
169: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
170: ELSE
171: oe_globals.g_recursion_mode := 'N';
172: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
173: END IF;

Line 172: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

168: oe_globals.g_recursion_mode := 'Y';
169: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
170: ELSE
171: oe_globals.g_recursion_mode := 'N';
172: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
173: END IF;
174:
175: NULL;
176: ELSIF p_entity_code = 8 THEN

Line 227: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

223: pr_ctr > 0 OR
224: --prrt_ctr > 0 OR
225: poa_ctr > 0 ) THEN
226:
227: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
228: ELSIF prn_ctr > 1 THEN
229: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
230: ELSE
231: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

Line 229: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

225: poa_ctr > 0 ) THEN
226:
227: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
228: ELSIF prn_ctr > 1 THEN
229: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
230: ELSE
231: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
232:
233: END IF;

Line 231: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

227: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
228: ELSIF prn_ctr > 1 THEN
229: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
230: ELSE
231: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
232:
233: END IF;
234:
235:

Line 245: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

241: pr_ctr := pr_ctr - 1;
242: END IF;
243: IF pr_ctr > 1 THEN
244: oe_globals.g_recursion_mode := 'Y';
245: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
246: ELSE
247: oe_globals.g_recursion_mode := 'N';
248: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
249: END IF;

Line 248: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

244: oe_globals.g_recursion_mode := 'Y';
245: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
246: ELSE
247: oe_globals.g_recursion_mode := 'N';
248: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
249: END IF;
250: NULL;
251:
252: ELSIF p_entity_code = 10 THEN

Line 259: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

255: ELSIF p_In_Out = 0 THEN
256: poa_ctr := poa_ctr - 1;
257: END IF;
258: IF poa_ctr > 1 THEN
259: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
260: ELSE
261: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
262:
263: END IF;

Line 261: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

257: END IF;
258: IF poa_ctr > 1 THEN
259: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
260: ELSE
261: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
262:
263: END IF;
264: NULL;
265: ELSIF p_entity_code = 11 THEN

Line 278: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';

274: -- executing request for req type in validate and write.
275:
276: /*IF prrt_ctr > 1 THEN
277: oe_globals.g_recursion_mode := 'Y';
278: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
279: ELSE
280: oe_globals.g_recursion_mode := 'N';
281: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
282: END IF; */

Line 281: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

277: oe_globals.g_recursion_mode := 'Y';
278: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'Y';
279: ELSE
280: oe_globals.g_recursion_mode := 'N';
281: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
282: END IF; */
283: NULL;
284:
285:

Line 288: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';

284:
285:
286: ELSE
287: oe_globals.g_recursion_mode := 'N';
288: OE_ORDER_UTIL.G_Recursion_Without_Exception := 'N';
289: NULL;
290: END IF;
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'RECURSION MODE AT EXIT -' || OE_GLOBALS.G_RECURSION_MODE , 1 ) ;

Line 293: oe_debug_pub.add( 'RECURSION MODE WITHOUT EXP AT EXIT -' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;

289: NULL;
290: END IF;
291: IF l_debug_level > 0 THEN
292: oe_debug_pub.add( 'RECURSION MODE AT EXIT -' || OE_GLOBALS.G_RECURSION_MODE , 1 ) ;
293: oe_debug_pub.add( 'RECURSION MODE WITHOUT EXP AT EXIT -' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;
294: END IF;
295: End Set_Recursion_Mode ;
296:
297:

Line 5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;

5852: END IF; -- p_notify and p_process_ack
5853:
5854: ELSE /*post pack H*/
5855: IF l_debug_level > 0 THEN
5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

Line 5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;

5854: ELSE /*post pack H*/
5855: IF l_debug_level > 0 THEN
5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

Line 5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;

5855: IF l_debug_level > 0 THEN
5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

Line 5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;

5856: oe_debug_pub.add( 'JPN: GLOBAL RECURSION WITHOUT EXCEPTION: ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

Line 5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;

5857: oe_debug_pub.add( 'JPN: GLOBAL CACHE BOOKED FLAG' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

Line 5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;

5858: oe_debug_pub.add( 'JPN: GLOBAL PICTURE HEADER BOOKED FLAG' || OE_ORDER_UTIL.G_HEADER_REC.BOOKED_FLAG ) ;
5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

Line 5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;

5859: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE TABLE= '|| OE_ORDER_UTIL.G_LINE_TBL.COUNT ) ;
5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

Line 5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;

5860: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_TBL.COUNT ) ;
5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

Line 5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;

5861: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_LINE_ADJ_TBL.COUNT ) ;
5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

Line 5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;

5862: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_ADJ_TBL.COUNT ) ;
5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

Line 5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;

5863: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_HEADER_ADJ_TBL.COUNT ) ;
5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
5871: END IF;

Line 5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;

5864: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR ADJ TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_ADJ_TBL.COUNT ) ;
5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
5871: END IF;
5872:

Line 5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;

5865: oe_debug_pub.add( 'JPN: COUNT OF NEW HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_HEADER_SCREDIT_TBL.COUNT ) ;
5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
5871: END IF;
5872:
5873: /*check global pictures, to see if there's any record in the seven key entities*/

Line 5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;

5866: oe_debug_pub.add( 'JPN: COUNT OF OLD HDR SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_HEADER_SCREDIT_TBL.COUNT ) ;
5867: oe_debug_pub.add( 'JPN: COUNT OF NEW LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_LINE_SCREDIT_TBL.COUNT ) ;
5868: oe_debug_pub.add( 'JPN: COUNT OF OLD LINE SCREDIT TABLE= '|| OE_ORDER_UTIL.G_OLD_LINE_SCREDIT_TBL.COUNT ) ;
5869: oe_debug_pub.add( 'JPN: COUNT OF NEW LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_LOT_SERIAL_TBL.COUNT ) ;
5870: oe_debug_pub.add( 'JPN: COUNT OF OLD LOT SERIAL TABLE= '|| OE_ORDER_UTIL.G_OLD_LOT_SERIAL_TBL.COUNT ) ;
5871: END IF;
5872:
5873: /*check global pictures, to see if there's any record in the seven key entities*/
5874:

Line 5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null

5871: END IF;
5872:
5873: /*check global pictures, to see if there's any record in the seven key entities*/
5874:
5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0

Line 5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM

5872:
5873: /*check global pictures, to see if there's any record in the seven key entities*/
5874:
5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0

Line 5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0

5873: /*check global pictures, to see if there's any record in the seven key entities*/
5874:
5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0

Line 5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0

5874:
5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0

Line 5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0

5875: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0

Line 5880: OR OE_ORDER_UTIL.g_line_tbl.count >0

5876: OR OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM
5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0
5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN

Line 5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0

5877: OR OE_ORDER_UTIL.g_header_adj_tbl.count >0
5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0
5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5885:

Line 5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0

5878: OR OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0
5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0
5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5885:
5886: /* start of bug 2781468 hashraf */

Line 5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0

5879: -- OR OE_ORDER_UTIL.g_Header_Payment_tbl.count >0
5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0
5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5885:
5886: /* start of bug 2781468 hashraf */
5887:

Line 5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN

5880: OR OE_ORDER_UTIL.g_line_tbl.count >0
5881: OR OE_ORDER_UTIL.g_Line_Adj_tbl.count >0
5882: OR OE_ORDER_UTIL.g_Line_Scredit_tbl.count >0
5883: -- OR OE_ORDER_UTIL.g_Line_Payment_tbl.count >0
5884: OR OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5885:
5886: /* start of bug 2781468 hashraf */
5887:
5888: /* need to get the header_id which will then be passed to load_order_header

Line 5894: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null

5890: */
5891:
5892: l_index := 1;
5893:
5894: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5895: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM) THEN
5896: l_header_id := OE_ORDER_UTIL.g_header_rec.header_id;
5897:
5898: IF l_debug_level > 0 THEN

Line 5895: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM) THEN

5891:
5892: l_index := 1;
5893:
5894: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5895: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM) THEN
5896: l_header_id := OE_ORDER_UTIL.g_header_rec.header_id;
5897:
5898: IF l_debug_level > 0 THEN
5899: oe_debug_pub.add('header id in g_header_rec is: ' || l_header_id ) ;

Line 5896: l_header_id := OE_ORDER_UTIL.g_header_rec.header_id;

5892: l_index := 1;
5893:
5894: IF ( OE_ORDER_UTIL.g_header_rec.header_id is not null
5895: AND OE_ORDER_UTIL.g_header_rec.header_id <> FND_API.G_MISS_NUM) THEN
5896: l_header_id := OE_ORDER_UTIL.g_header_rec.header_id;
5897:
5898: IF l_debug_level > 0 THEN
5899: oe_debug_pub.add('header id in g_header_rec is: ' || l_header_id ) ;
5900: END IF;

Line 5902: ELSIF ( OE_ORDER_UTIL.g_header_adj_tbl.count >0 ) THEN

5898: IF l_debug_level > 0 THEN
5899: oe_debug_pub.add('header id in g_header_rec is: ' || l_header_id ) ;
5900: END IF;
5901:
5902: ELSIF ( OE_ORDER_UTIL.g_header_adj_tbl.count >0 ) THEN
5903: IF l_debug_level > 0 THEN
5904: oe_debug_pub.add('Inside the header_adj_tbl loop');
5905: END IF;
5906: l_index := OE_ORDER_UTIL.g_header_adj_tbl.first;

Line 5906: l_index := OE_ORDER_UTIL.g_header_adj_tbl.first;

5902: ELSIF ( OE_ORDER_UTIL.g_header_adj_tbl.count >0 ) THEN
5903: IF l_debug_level > 0 THEN
5904: oe_debug_pub.add('Inside the header_adj_tbl loop');
5905: END IF;
5906: l_index := OE_ORDER_UTIL.g_header_adj_tbl.first;
5907: IF (l_index is not null) THEN
5908: l_header_id := OE_ORDER_UTIL.g_header_adj_tbl(l_index).header_id;
5909: IF l_debug_level > 0 THEN
5910: oe_debug_pub.add('header id in g_header_adj_tbl is: ' || l_header_id ) ;

Line 5908: l_header_id := OE_ORDER_UTIL.g_header_adj_tbl(l_index).header_id;

5904: oe_debug_pub.add('Inside the header_adj_tbl loop');
5905: END IF;
5906: l_index := OE_ORDER_UTIL.g_header_adj_tbl.first;
5907: IF (l_index is not null) THEN
5908: l_header_id := OE_ORDER_UTIL.g_header_adj_tbl(l_index).header_id;
5909: IF l_debug_level > 0 THEN
5910: oe_debug_pub.add('header id in g_header_adj_tbl is: ' || l_header_id ) ;
5911: oe_debug_pub.add('l_index in g_header_adj_tbl is: ' || l_index ) ;
5912: END IF;

Line 5915: ELSIF ( OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0 ) THEN

5911: oe_debug_pub.add('l_index in g_header_adj_tbl is: ' || l_index ) ;
5912: END IF;
5913: END IF;
5914:
5915: ELSIF ( OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0 ) THEN
5916: IF l_debug_level > 0 THEN
5917: oe_debug_pub.add('Inside the header_Scredit_tbl loop');
5918: END IF;
5919: l_index := OE_ORDER_UTIL.g_header_Scredit_tbl.first;

Line 5919: l_index := OE_ORDER_UTIL.g_header_Scredit_tbl.first;

5915: ELSIF ( OE_ORDER_UTIL.g_Header_Scredit_tbl.count >0 ) THEN
5916: IF l_debug_level > 0 THEN
5917: oe_debug_pub.add('Inside the header_Scredit_tbl loop');
5918: END IF;
5919: l_index := OE_ORDER_UTIL.g_header_Scredit_tbl.first;
5920: IF (l_index is not null) THEN
5921: l_header_id := OE_ORDER_UTIL.g_header_Scredit_tbl(l_index).header_id;
5922: IF l_debug_level > 0 THEN
5923: oe_debug_pub.add('header id in g_header_Scredit_tbl is: ' || l_header_id ) ;

Line 5921: l_header_id := OE_ORDER_UTIL.g_header_Scredit_tbl(l_index).header_id;

5917: oe_debug_pub.add('Inside the header_Scredit_tbl loop');
5918: END IF;
5919: l_index := OE_ORDER_UTIL.g_header_Scredit_tbl.first;
5920: IF (l_index is not null) THEN
5921: l_header_id := OE_ORDER_UTIL.g_header_Scredit_tbl(l_index).header_id;
5922: IF l_debug_level > 0 THEN
5923: oe_debug_pub.add('header id in g_header_Scredit_tbl is: ' || l_header_id ) ;
5924: oe_debug_pub.add('l_index in g_header_Scredit_tbl is: ' || l_index ) ;
5925: END IF;

Line 5928: ELSIF ( OE_ORDER_UTIL.g_line_tbl.count >0 ) THEN

5924: oe_debug_pub.add('l_index in g_header_Scredit_tbl is: ' || l_index ) ;
5925: END IF;
5926: END IF;
5927:
5928: ELSIF ( OE_ORDER_UTIL.g_line_tbl.count >0 ) THEN
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add('Inside the line loop');
5931: END IF;
5932: l_index := OE_ORDER_UTIL.g_line_tbl.first;

Line 5932: l_index := OE_ORDER_UTIL.g_line_tbl.first;

5928: ELSIF ( OE_ORDER_UTIL.g_line_tbl.count >0 ) THEN
5929: IF l_debug_level > 0 THEN
5930: oe_debug_pub.add('Inside the line loop');
5931: END IF;
5932: l_index := OE_ORDER_UTIL.g_line_tbl.first;
5933: IF (l_index is not null) THEN
5934: l_header_id := OE_ORDER_UTIL.g_line_tbl(l_index).header_id;
5935: IF l_debug_level > 0 THEN
5936: oe_debug_pub.add('header id in g_line_tbl is: ' || l_header_id ) ;

Line 5934: l_header_id := OE_ORDER_UTIL.g_line_tbl(l_index).header_id;

5930: oe_debug_pub.add('Inside the line loop');
5931: END IF;
5932: l_index := OE_ORDER_UTIL.g_line_tbl.first;
5933: IF (l_index is not null) THEN
5934: l_header_id := OE_ORDER_UTIL.g_line_tbl(l_index).header_id;
5935: IF l_debug_level > 0 THEN
5936: oe_debug_pub.add('header id in g_line_tbl is: ' || l_header_id ) ;
5937: oe_debug_pub.add('l_index in g_line_tbl is: ' || l_index ) ;
5938: END IF;

Line 5941: ELSIF ( OE_ORDER_UTIL.g_line_adj_tbl.count >0 ) THEN

5937: oe_debug_pub.add('l_index in g_line_tbl is: ' || l_index ) ;
5938: END IF;
5939: END IF;
5940:
5941: ELSIF ( OE_ORDER_UTIL.g_line_adj_tbl.count >0 ) THEN
5942:
5943: IF l_debug_level > 0 THEN
5944: oe_debug_pub.add('Inside the line_adj loop');
5945: END IF;

Line 5946: l_index := OE_ORDER_UTIL.g_line_adj_tbl.first;

5942:
5943: IF l_debug_level > 0 THEN
5944: oe_debug_pub.add('Inside the line_adj loop');
5945: END IF;
5946: l_index := OE_ORDER_UTIL.g_line_adj_tbl.first;
5947: IF (l_index is not null) THEN
5948:
5949: l_header_id := OE_ORDER_UTIL.g_line_adj_tbl(l_index).header_id;
5950: IF l_debug_level > 0 THEN

Line 5949: l_header_id := OE_ORDER_UTIL.g_line_adj_tbl(l_index).header_id;

5945: END IF;
5946: l_index := OE_ORDER_UTIL.g_line_adj_tbl.first;
5947: IF (l_index is not null) THEN
5948:
5949: l_header_id := OE_ORDER_UTIL.g_line_adj_tbl(l_index).header_id;
5950: IF l_debug_level > 0 THEN
5951: oe_debug_pub.add('header id in g_line_adj_tbl is: ' || l_header_id ) ;
5952: oe_debug_pub.add('l_index in g_line_adj_tbl is: ' || l_index ) ;
5953: END IF;

Line 5956: ELSIF ( OE_ORDER_UTIL.g_line_Scredit_tbl.count >0 ) THEN

5952: oe_debug_pub.add('l_index in g_line_adj_tbl is: ' || l_index ) ;
5953: END IF;
5954: END IF;
5955:
5956: ELSIF ( OE_ORDER_UTIL.g_line_Scredit_tbl.count >0 ) THEN
5957:
5958: IF l_debug_level > 0 THEN
5959: oe_debug_pub.add('Inside the line_Scredit loop');
5960: END IF;

Line 5961: l_index := OE_ORDER_UTIL.g_line_Scredit_tbl.first;

5957:
5958: IF l_debug_level > 0 THEN
5959: oe_debug_pub.add('Inside the line_Scredit loop');
5960: END IF;
5961: l_index := OE_ORDER_UTIL.g_line_Scredit_tbl.first;
5962: IF (l_index is not null) THEN
5963:
5964: l_header_id := OE_ORDER_UTIL.g_line_Scredit_tbl(l_index).header_id;
5965: IF l_debug_level > 0 THEN

Line 5964: l_header_id := OE_ORDER_UTIL.g_line_Scredit_tbl(l_index).header_id;

5960: END IF;
5961: l_index := OE_ORDER_UTIL.g_line_Scredit_tbl.first;
5962: IF (l_index is not null) THEN
5963:
5964: l_header_id := OE_ORDER_UTIL.g_line_Scredit_tbl(l_index).header_id;
5965: IF l_debug_level > 0 THEN
5966: oe_debug_pub.add('header id in g_line_Scredit_tbl is: ' || l_header_id );
5967: oe_debug_pub.add('l_index in g_line_Scredit_tbl is: ' || l_index ) ;
5968: END IF;

Line 5971: ELSIF ( OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN

5967: oe_debug_pub.add('l_index in g_line_Scredit_tbl is: ' || l_index ) ;
5968: END IF;
5969: END IF;
5970:
5971: ELSIF ( OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5972: IF l_debug_level > 0 THEN
5973: oe_debug_pub.add('Inside the group by_lot_serial loop');
5974: END IF;
5975: l_index := OE_ORDER_UTIL.g_Lot_Serial_tbl.first;

Line 5975: l_index := OE_ORDER_UTIL.g_Lot_Serial_tbl.first;

5971: ELSIF ( OE_ORDER_UTIL.g_Lot_Serial_tbl.count >0 ) THEN
5972: IF l_debug_level > 0 THEN
5973: oe_debug_pub.add('Inside the group by_lot_serial loop');
5974: END IF;
5975: l_index := OE_ORDER_UTIL.g_Lot_Serial_tbl.first;
5976: IF (l_index is not null) THEN
5977: l_line_id := OE_ORDER_UTIL.g_Lot_Serial_tbl(l_index).line_id;
5978:
5979: BEGIN

Line 5977: l_line_id := OE_ORDER_UTIL.g_Lot_Serial_tbl(l_index).line_id;

5973: oe_debug_pub.add('Inside the group by_lot_serial loop');
5974: END IF;
5975: l_index := OE_ORDER_UTIL.g_Lot_Serial_tbl.first;
5976: IF (l_index is not null) THEN
5977: l_line_id := OE_ORDER_UTIL.g_Lot_Serial_tbl(l_index).line_id;
5978:
5979: BEGIN
5980: SELECT header_id
5981: INTO l_header_id

Line 6016: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND

6012: oe_debug_pub.add('Out of Load_Order_Header in PRN');
6013: END IF;
6014: /* end of bug 2781468*/
6015:
6016: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6017: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y') THEN
6018:
6019: IF l_debug_level > 0 THEN
6020: oe_debug_pub.add( 'POST PACK H. CALLING NOTIFY_OC API' , 1 ) ;

Line 6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec

6025: , p_init_msg_list => FND_API.G_FALSE
6026: , x_return_status => l_return_status
6027: , x_msg_count => l_msg_count
6028: , x_msg_data => l_msg_data
6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec
6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl

Line 6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec

6026: , x_return_status => l_return_status
6027: , x_msg_count => l_msg_count
6028: , x_msg_data => l_msg_data
6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec
6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl

Line 6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl

6027: , x_msg_count => l_msg_count
6028: , x_msg_data => l_msg_data
6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec
6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl

Line 6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl

6028: , x_msg_data => l_msg_data
6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec
6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl

Line 6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl

6029: , p_header_rec => OE_ORDER_UTIL.g_header_rec
6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl

Line 6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl

6030: , p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl

Line 6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl

6031: , p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

Line 6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl

6032: , p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl

Line 6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl

6033: , p_Header_Scredit_tbl => OE_ORDER_UTIL.g_Header_Scredit_tbl
6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl

Line 6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl

6034: , p_old_Header_Scredit_tbl => OE_ORDER_UTIL.g_old_Header_Scredit_tbl
6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl

Line 6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl

6035: -- , p_Header_Payment_tbl => OE_ORDER_UTIL.g_Header_Payment_tbl
6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl

Line 6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl

6036: -- , p_old_Header_Payment_tbl => OE_ORDER_UTIL.g_old_Header_Payment_tbl
6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl

Line 6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl

6037: , p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl

Line 6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl

6038: , p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl
6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl

Line 6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl

6039: , p_Line_Adj_tbl => OE_ORDER_UTIL.g_Line_Adj_tbl
6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl
6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl
6047: );

Line 6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl

6040: , p_old_Line_Adj_tbl => OE_ORDER_UTIL.g_old_Line_Adj_tbl
6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl
6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl
6047: );
6048:

Line 6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl

6041: , p_Line_Scredit_tbl => OE_ORDER_UTIL.g_Line_Scredit_tbl
6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl
6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl
6047: );
6048:
6049: IF l_debug_level > 0 THEN

Line 6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl

6042: , p_old_Line_Scredit_tbl => OE_ORDER_UTIL.g_old_Line_Scredit_tbl
6043: -- , p_Line_Payment_tbl => OE_ORDER_UTIL.g_Line_Payment_tbl
6044: -- , p_old_Line_Payment_tbl => OE_ORDER_UTIL.g_old_Line_Payment_tbl
6045: , p_Lot_Serial_tbl => OE_ORDER_UTIL.g_Lot_Serial_tbl
6046: , p_old_Lot_Serial_tbl => OE_ORDER_UTIL.g_old_Lot_Serial_tbl
6047: );
6048:
6049: IF l_debug_level > 0 THEN
6050: oe_debug_pub.add( 'AFTER NOTIFY_OC API' , 1 ) ;

Line 6063: oe_debug_pub.add( 'PACKS ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;

6059: END IF;
6060:
6061: IF l_debug_level > 0 THEN
6062: oe_debug_pub.add( 'PROCESSING ACKS' , 1 ) ;
6063: oe_debug_pub.add( 'PACKS ' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION , 1 ) ;
6064: oe_debug_pub.add( 'PACKS' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG , 1 ) ;
6065: END IF;
6066:
6067: --SUN OIP ER

Line 6069: i := OE_ORDER_UTIL.g_line_tbl.first;

6065: END IF;
6066:
6067: --SUN OIP ER
6068: If NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' THEN
6069: i := OE_ORDER_UTIL.g_line_tbl.first;
6070: while i is not null LOOP
6071: if OE_ORDER_UTIL.g_line_tbl(i).line_id = OE_ORDER_UTIL.g_old_line_tbl(i).line_id then
6072: j := i;
6073: else

Line 6071: if OE_ORDER_UTIL.g_line_tbl(i).line_id = OE_ORDER_UTIL.g_old_line_tbl(i).line_id then

6067: --SUN OIP ER
6068: If NVL (Fnd_Profile.Value('ONT_RAISE_STATUS_CHANGE_BUSINESS_EVENT'), 'N')='Y' THEN
6069: i := OE_ORDER_UTIL.g_line_tbl.first;
6070: while i is not null LOOP
6071: if OE_ORDER_UTIL.g_line_tbl(i).line_id = OE_ORDER_UTIL.g_old_line_tbl(i).line_id then
6072: j := i;
6073: else
6074: j := OE_Acknowledgment_Pub.get_line_index(OE_ORDER_UTIL.g_old_line_tbl, OE_ORDER_UTIL.g_line_tbl(i).line_id);
6075: end if;

Line 6074: j := OE_Acknowledgment_Pub.get_line_index(OE_ORDER_UTIL.g_old_line_tbl, OE_ORDER_UTIL.g_line_tbl(i).line_id);

6070: while i is not null LOOP
6071: if OE_ORDER_UTIL.g_line_tbl(i).line_id = OE_ORDER_UTIL.g_old_line_tbl(i).line_id then
6072: j := i;
6073: else
6074: j := OE_Acknowledgment_Pub.get_line_index(OE_ORDER_UTIL.g_old_line_tbl, OE_ORDER_UTIL.g_line_tbl(i).line_id);
6075: end if;
6076:
6077: if j<>0 THEN
6078:

Line 6079: IF NOT l_event_Tbl.exists(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN

6075: end if;
6076:
6077: if j<>0 THEN
6078:
6079: IF NOT l_event_Tbl.exists(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6080: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := FALSE;
6081: END IF;
6082:
6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL

Line 6080: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := FALSE;

6076:
6077: if j<>0 THEN
6078:
6079: IF NOT l_event_Tbl.exists(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6080: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := FALSE;
6081: END IF;
6082:
6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL
6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND

Line 6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL

6079: IF NOT l_event_Tbl.exists(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6080: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := FALSE;
6081: END IF;
6082:
6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL
6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND
6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,

Line 6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND

6080: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := FALSE;
6081: END IF;
6082:
6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL
6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND
6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,

Line 6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN

6081: END IF;
6082:
6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL
6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND
6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6089: 'SCHEDULED');

Line 6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,

6083: if OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date IS NULL
6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND
6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6089: 'SCHEDULED');
6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE

Line 6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,

6084: AND OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date IS NOT NULL AND
6085: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6089: 'SCHEDULED');
6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE
6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>

Line 6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;

6086:
6087: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6089: 'SCHEDULED');
6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE
6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN

Line 6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>

6088: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6089: 'SCHEDULED');
6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE
6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,

Line 6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND

6089: 'SCHEDULED');
6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE
6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,

Line 6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN

6090: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6091: ELSE
6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6098: 'SSD Change');

Line 6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,

6092: IF nvl(OE_ORDER_UTIL.g_line_tbl(i).schedule_ship_date, trunc(sysdate)) <>
6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6098: 'SSD Change');
6099: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6100: END IF;

Line 6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,

6093: nvl(OE_ORDER_UTIL.g_old_line_tbl(i).schedule_ship_date, trunc(sysdate)) AND
6094: NOT l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) THEN
6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6098: 'SSD Change');
6099: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6100: END IF;
6101: END IF;

Line 6099: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;

6095:
6096: OE_ORDER_UTIL.RAISE_BUSINESS_EVENT(OE_ORDER_UTIL.g_line_tbl(i).header_id,
6097: OE_ORDER_UTIL.g_line_tbl(i).line_id,
6098: 'SSD Change');
6099: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6100: END IF;
6101: END IF;
6102: END IF;
6103: i := OE_ORDER_UTIL.g_line_tbl.Next(i);

Line 6103: i := OE_ORDER_UTIL.g_line_tbl.Next(i);

6099: l_event_Tbl(Mod(OE_ORDER_UTIL.g_line_tbl(i).line_id,G_BINARY_LIMIT)) := TRUE;
6100: END IF;
6101: END IF;
6102: END IF;
6103: i := OE_ORDER_UTIL.g_line_tbl.Next(i);
6104: end loop;
6105: end if;
6106: --End of SUN OIP ER
6107: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND

Line 6107: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND

6103: i := OE_ORDER_UTIL.g_line_tbl.Next(i);
6104: end loop;
6105: end if;
6106: --End of SUN OIP ER
6107: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6108: OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' AND p_process_ack) THEN
6109:
6110: IF l_debug_level > 0 THEN
6111: oe_debug_pub.add( 'POST PACK H.CALLING ACKS API' , 1 ) ;

Line 6137: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl

6133: OE_Acknowledgment_Pub.Process_SSO
6134: (p_api_version_number => 1
6135: ,p_init_msg_list => FND_API.G_FALSE
6136: ,p_header_rec => OE_ORDER_CACHE.g_header_rec
6137: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6138: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6139: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6140:
6141: ,x_return_status => l_return_status

Line 6138: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec

6134: (p_api_version_number => 1
6135: ,p_init_msg_list => FND_API.G_FALSE
6136: ,p_header_rec => OE_ORDER_CACHE.g_header_rec
6137: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6138: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6139: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6140:
6141: ,x_return_status => l_return_status
6142: );

Line 6139: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl

6135: ,p_init_msg_list => FND_API.G_FALSE
6136: ,p_header_rec => OE_ORDER_CACHE.g_header_rec
6137: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6138: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6139: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6140:
6141: ,x_return_status => l_return_status
6142: );
6143:

Line 6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,

6145: Elsif Oe_Code_Control.Code_Release_Level >= '110510' And
6146: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) And
6147: l_edi_ack_pfile = 'YES' Then
6148: OE_Acknowledgment_Pvt.Process_Acknowledgment
6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,
6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,
6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,
6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,
6153: x_return_status => l_return_status);

Line 6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,

6146: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) And
6147: l_edi_ack_pfile = 'YES' Then
6148: OE_Acknowledgment_Pvt.Process_Acknowledgment
6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,
6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,
6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,
6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,
6153: x_return_status => l_return_status);
6154: Elsif l_edi_ack_pfile = 'NO' And

Line 6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,

6147: l_edi_ack_pfile = 'YES' Then
6148: OE_Acknowledgment_Pvt.Process_Acknowledgment
6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,
6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,
6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,
6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,
6153: x_return_status => l_return_status);
6154: Elsif l_edi_ack_pfile = 'NO' And
6155: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) Then

Line 6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,

6148: OE_Acknowledgment_Pvt.Process_Acknowledgment
6149: (p_header_rec => OE_ORDER_UTIL.g_header_rec,
6150: p_line_tbl => OE_ORDER_UTIL.g_line_tbl,
6151: p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec,
6152: p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl,
6153: x_return_status => l_return_status);
6154: Elsif l_edi_ack_pfile = 'NO' And
6155: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) Then
6156: OE_Acknowledgment_Pvt.Process_Acknowledgment

Line 6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec

6155: OE_ORDER_CACHE.g_header_rec.order_source_id in (0,2,6) Then
6156: OE_Acknowledgment_Pvt.Process_Acknowledgment
6157: (p_api_version_number => 1
6158: ,p_init_msg_list => FND_API.G_FALSE
6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec
6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl

Line 6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl

6156: OE_Acknowledgment_Pvt.Process_Acknowledgment
6157: (p_api_version_number => 1
6158: ,p_init_msg_list => FND_API.G_FALSE
6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec
6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl

Line 6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl

6157: (p_api_version_number => 1
6158: ,p_init_msg_list => FND_API.G_FALSE
6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec
6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl

Line 6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl

6158: ,p_init_msg_list => FND_API.G_FALSE
6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec
6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec

Line 6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl

6159: ,p_header_rec => OE_ORDER_UTIL.g_header_rec
6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl

Line 6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl

6160: ,p_header_adj_tbl => OE_ORDER_UTIL.g_header_adj_tbl
6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl

Line 6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl

6161: ,p_header_Scredit_tbl => OE_ORDER_UTIL.g_header_scredit_tbl
6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl

Line 6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec

6162: ,p_line_tbl => OE_ORDER_UTIL.g_line_tbl
6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl

Line 6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl

6163: ,p_line_adj_tbl => OE_ORDER_UTIL.g_line_adj_tbl
6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl

Line 6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl

6164: ,p_line_scredit_tbl => OE_ORDER_UTIL.g_line_scredit_tbl
6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl
6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl

Line 6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl

6165: ,p_lot_serial_tbl => OE_ORDER_UTIL.g_lot_serial_tbl
6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl
6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl
6173:

Line 6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl

6166: ,p_old_header_rec => OE_ORDER_UTIL.g_old_header_rec
6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl
6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl
6173:
6174: ,p_buyer_seller_flag => 'B'

Line 6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl

6167: ,p_old_header_adj_tbl => OE_ORDER_UTIL.g_old_header_adj_tbl
6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl
6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl
6173:
6174: ,p_buyer_seller_flag => 'B'
6175: ,p_reject_order => 'N'

Line 6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl

6168: ,p_old_header_Scredit_tbl => OE_ORDER_UTIL.g_old_header_scredit_tbl
6169: ,p_old_line_tbl => OE_ORDER_UTIL.g_old_line_tbl
6170: ,p_old_line_adj_tbl => OE_ORDER_UTIL.g_old_line_adj_tbl
6171: ,p_old_line_scredit_tbl => OE_ORDER_UTIL.g_old_line_scredit_tbl
6172: ,p_old_lot_serial_tbl => OE_ORDER_UTIL.g_old_lot_serial_tbl
6173:
6174: ,p_buyer_seller_flag => 'B'
6175: ,p_reject_order => 'N'
6176:

Line 6197: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;

6193: -- DBI project changes start
6194: IF l_debug_level > 0 THEN
6195: oe_debug_pub.add( 'CALLING OE_DBI_UTIL' , 1 ) ;
6196: oe_debug_pub.add( 'CACHED VALUE' || OE_ORDER_CACHE.G_HEADER_REC.BOOKED_FLAG ) ;
6197: oe_debug_pub.add( 'RECURSION VALUE' || OE_ORDER_UTIL.G_RECURSION_WITHOUT_EXCEPTION ) ;
6198: oe_debug_pub.add( 'PROFILE VALUE' || FND_PROFILE.VALUE ( 'ONT_DBI_INSTALLED' ) ) ;
6199: END IF;
6200:
6201: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND

Line 6203: OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N'

6199: END IF;
6200:
6201: IF NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'), 'N') = 'Y' AND
6202: oe_order_cache.g_header_rec.booked_flag = 'Y' AND
6203: OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N'
6204: -- AND p_header_rec.header_id IS NOT NULL AND
6205: --p_header_rec.header_id <> FND_API.G_MISS_NUM
6206: THEN
6207: OE_DBI_UTIL.Update_DBI_Log( x_return_status => l_return_status);

Line 6222: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND

6218:
6219:
6220: /* Now clear the global pl/sql tables */
6221: /* Also clear for >= 11i10 for versioning */
6222: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6223: (OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' OR
6224: OE_CODE_CONTROL.Code_Release_Level >= '110510' )) THEN
6225: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6226: END IF;

Line 6225: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

6221: /* Also clear for >= 11i10 for versioning */
6222: IF (OE_ORDER_UTIL.G_Recursion_Without_Exception = 'N' AND
6223: (OE_ORDER_CACHE.g_header_rec.booked_flag = 'Y' OR
6224: OE_CODE_CONTROL.Code_Release_Level >= '110510' )) THEN
6225: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6226: END IF;
6227:
6228: END IF; /*check for record in key entities*/
6229: END IF; /*code_release_level*/

Line 6267: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

6263: x_return_status := FND_API.G_RET_STS_ERROR;
6264: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
6265: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
6266: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
6267: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6268: END IF;
6269: END IF;
6270:
6271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 6279: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

6275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6276: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
6277: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
6278: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
6279: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6280: END IF;
6281: END IF;
6282:
6283: WHEN OTHERS THEN

Line 6294: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

6290: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6291: IF NOT (OE_GLOBALS.G_UI_FLAG) THEN
6292: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
6293: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
6294: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
6295: END IF;
6296: END IF;
6297: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
6298: THEN

Line 10524: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

10520: END IF;
10521:
10522: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
10523: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
10524: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
10525: END IF;
10526: OE_ORDER_WF_UTIL.CLEAR_FLOWSTART_GLOBALS;
10527: ROLLBACK TO SAVEPOINT Process_Order;
10528:

Line 10556: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

10552: END IF;
10553:
10554: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
10555: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
10556: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
10557: END IF;
10558: OE_ORDER_WF_UTIL.CLEAR_FLOWSTART_GLOBALS;
10559: ROLLBACK TO SAVEPOINT Process_Order;
10560:

Line 10589: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);

10585: END IF;
10586:
10587: OE_DELAYED_REQUESTS_PVT.Clear_Request(l_return_status);
10588: IF OE_CODE_CONTROL.CODE_RELEASE_LEVEL >= '110508' THEN
10589: OE_ORDER_UTIL.Clear_Global_Picture(l_return_status);
10590: END IF;
10591: OE_ORDER_WF_UTIL.CLEAR_FLOWSTART_GLOBALS;
10592: ROLLBACK TO SAVEPOINT Process_Order;
10593: