APPS.OE_RMA_GRP dependencies on OE_DEBUG_PUB

Line 24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

20:
21: l_header_rec OE_Order_PUB.Header_Rec_Type;
22:
23: --
24: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
25: --
26: BEGIN
27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 31: oe_debug_pub.add('OEXGRMAB: ENTERING SUBMIT_ORDER, HEADER ID: '||P_HEADER_ID) ;

27:
28: x_return_status := FND_API.G_RET_STS_SUCCESS;
29:
30: IF l_debug_level > 0 THEN
31: oe_debug_pub.add('OEXGRMAB: ENTERING SUBMIT_ORDER, HEADER ID: '||P_HEADER_ID) ;
32: END IF;
33:
34: /* Standard call to check for call compatibility */
35:

Line 50: oe_debug_pub.add('OEXGRMAB: AFTER CALLING QUERY ROW') ;

46: OE_Header_Util.Query_Row(p_header_id => p_header_id,
47: x_header_rec => l_header_rec);
48:
49: IF l_debug_level > 0 THEN
50: oe_debug_pub.add('OEXGRMAB: AFTER CALLING QUERY ROW') ;
51: END IF;
52:
53: /* Complete the Wait for Submission activity */
54:

Line 62: oe_debug_pub.add('OEXGRMAB: AFTER COMPLETING THE WAIT FOR SUBMISSION ACTIVITY') ;

58: , 'COMPLETE'
59: );
60:
61: IF l_debug_level > 0 THEN
62: oe_debug_pub.add('OEXGRMAB: AFTER COMPLETING THE WAIT FOR SUBMISSION ACTIVITY') ;
63: END IF;
64:
65: /* Update the ordered_date with the system date */
66:

Line 80: oe_debug_pub.add('OEXGRMAB: AFTER UPDATING ORDERED DATE ON HEADER');

76: , last_update_login = l_header_rec.last_update_login
77: WHERE header_id = p_header_id;
78:
79: IF l_debug_level > 0 THEN
80: oe_debug_pub.add('OEXGRMAB: AFTER UPDATING ORDERED DATE ON HEADER');
81: END IF;
82:
83: /* Update the Header Cache with the new information */
84:

Line 88: oe_debug_pub.add('OEXGRMAB: AFTER CALLING UPDATE FLOW STATUS CODE, RETURN STATUS: '||X_RETURN_STATUS);

84:
85: OE_Order_Cache.Set_Order_Header(l_header_rec);
86:
87: IF l_debug_level > 0 THEN
88: oe_debug_pub.add('OEXGRMAB: AFTER CALLING UPDATE FLOW STATUS CODE, RETURN STATUS: '||X_RETURN_STATUS);
89: END IF;
90:
91: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
92: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 98: oe_debug_pub.add('OEXGRMAB: EXITING SUBMIT_ORDER');

94: RAISE FND_API.G_EXC_ERROR;
95: END IF;
96:
97: IF l_debug_level > 0 THEN
98: oe_debug_pub.add('OEXGRMAB: EXITING SUBMIT_ORDER');
99: END IF;
100:
101: EXCEPTION
102:

Line 164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

160: l_already_returned NUMBER;
161: l_original_ordered NUMBER;
162:
163: --
164: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
165: --
166: BEGIN
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 171: oe_debug_pub.add('OEXGRMAB: ENTERING IS_OVER_RETURN') ;

167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:
170: IF l_debug_level > 0 THEN
171: oe_debug_pub.add('OEXGRMAB: ENTERING IS_OVER_RETURN') ;
172: END IF;
173:
174: /* Standard call to check for call compatibility */
175:

Line 192: oe_debug_pub.add('OEXGRMAB: VALIDATE LINE ID/ITEM ID: '||p_line_tbl(l_index).line_id||'/'

188:
189: WHILE l_index IS NOT NULL LOOP
190:
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add('OEXGRMAB: VALIDATE LINE ID/ITEM ID: '||p_line_tbl(l_index).line_id||'/'
193: ||p_line_tbl(l_index).inventory_item_id) ;
194: END IF;
195:
196: /* Get the total qty already returned for the referenced SO Line */

Line 218: oe_debug_pub.add('OEXGRMAB: LINE OVER RETURNED ERROR');

214:
215: IF (l_already_returned + p_line_tbl(l_index).ordered_quantity) > l_original_ordered THEN
216:
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add('OEXGRMAB: LINE OVER RETURNED ERROR');
219: END IF;
220:
221: FND_MESSAGE.Set_Name('ONT','OE_LINE_OVER_RETURNED');
222: FND_MESSAGE.Set_Token('LINE', p_line_tbl(l_index).line_number);

Line 257: oe_debug_pub.add('OEXGRMAB: EXITING IS_OVER_RETURN');

253:
254: END LOOP;
255:
256: IF l_debug_level > 0 THEN
257: oe_debug_pub.add('OEXGRMAB: EXITING IS_OVER_RETURN');
258: END IF;
259:
260: EXCEPTION
261:

Line 346: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

342: ) wv
343: ORDER BY wv.end_date DESC ;
344:
345: --
346: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
347: --
348: BEGIN
349:
350: IF l_debug_level > 0 THEN

Line 351: oe_debug_pub.add('OEXGRMAB: ENTERING POST_APPROVAL_PROCESS, ITEM TYPE/KEY: '||itemtype||'/'||itemkey) ;

347: --
348: BEGIN
349:
350: IF l_debug_level > 0 THEN
351: oe_debug_pub.add('OEXGRMAB: ENTERING POST_APPROVAL_PROCESS, ITEM TYPE/KEY: '||itemtype||'/'||itemkey) ;
352: END IF;
353:
354: IF (FUNCMODE = 'RUN') THEN
355:

Line 379: oe_debug_pub.add('OEXGRMAB: NOTIFICATION ID: '||l_notification_id) ;

375:
376: CLOSE ntf;
377:
378: IF l_debug_level > 0 THEN
379: oe_debug_pub.add('OEXGRMAB: NOTIFICATION ID: '||l_notification_id) ;
380: END IF;
381:
382: /* Get Approver Comments */
383:

Line 406: oe_debug_pub.add('OEXGRMAB: BEFORE CALLING IBE_OM_INTEGRATION_GRP.NOTIFY_RMA_REQUEST_ACTION');

402: );'||
403: 'END;';
404:
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add('OEXGRMAB: BEFORE CALLING IBE_OM_INTEGRATION_GRP.NOTIFY_RMA_REQUEST_ACTION');
407: END IF;
408:
409: BEGIN
410: EXECUTE IMMEDIATE l_block_str

Line 424: OE_DEBUG_PUB.ADD('OEXGRMAB: ISTORE PACKAGE DOES NOT EXIST '||SQLCODE);

420: ** 6550: PL/SQL Compilation Error - Raised when above package does not exist.
421: ** 4067: Not executed,