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_INTERNAL_REQUISITION_PVT dependencies on OE_DEBUG_PUB

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

12: ) IS
13: --
14: l_line_ids_rec Line_Id_Rec_Type;
15: --
16: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
17: --
18:
19: Begin
20:

Line 22: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;

18:
19: Begin
20:
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;
23: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
24: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
25: END IF;
26:

Line 23: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;

19: Begin
20:
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;
23: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
24: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
25: END IF;
26:
27: X_return_status := FND_API.G_RET_STS_SUCCESS;

Line 24: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;

20:
21: IF l_debug_level > 0 THEN
22: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;
23: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
24: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
25: END IF;
26:
27: X_return_status := FND_API.G_RET_STS_SUCCESS;
28:

Line 70: oe_debug_pub.add( ' EXITING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;

66:
67: X_line_ids_rec := l_line_ids_rec;
68:
69: IF l_debug_level > 0 THEN
70: oe_debug_pub.add( ' EXITING OE_Internal_Requisition_Pvt.Get_Eligible_ISO_Shipment', 1 ) ;
71: END IF;
72:
73: Exception
74:

Line 77: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment With No Data Found Error', 1 ) ;

73: Exception
74:
75: WHEN NO_DATA_FOUND THEN
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment With No Data Found Error', 1 ) ;
78: END IF;
79: FND_Message.Set_Name('ONT', 'OE_IRCMS_NOT_ELIGIBLE');
80: -- There is no sales order line shipment eligible for update/cancellation.
81: OE_MSG_PUB.Add;

Line 86: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with Too Many Rows error', 1 ) ;

82: X_return_status := FND_API.G_RET_STS_ERROR;
83:
84: WHEN TOO_MANY_ROWS THEN
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with Too Many Rows error', 1 ) ;
87: END IF;
88: FND_Message.Set_Name('ONT', 'OE_IRCMS_TOO_MANY_ROWS');
89: -- There are multiple sales order line shipments eligible for update.
90: -- This is not allowed.

Line 96: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with others error'||sqlerrm,1);

92: X_return_status := FND_API.G_RET_STS_ERROR;
93:
94: WHEN OTHERS THEN
95: IF l_debug_level > 0 THEN
96: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with others error'||sqlerrm,1);
97: END IF;
98: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
99: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Get_Eligible_ISO_Shipment');
100: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'

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

116: l_entity_update_allowed BOOLEAN := FALSE;
117: l_action NUMBER;
118: l_result NUMBER := OE_PC_GLOBALS.NO;
119: --
120: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
121: --
122: Begin
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Update_Allowed', 1) ;

Line 124: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Update_Allowed', 1) ;

120: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
121: --
122: Begin
123: IF l_debug_level > 0 THEN
124: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Update_Allowed', 1) ;
125: END IF;
126:
127: OE_LINE_UTIL.QUERY_ROW( p_line_id => P_line_id
128: , x_line_rec => l_line_rec );

Line 131: oe_debug_pub.add( ' Converting to Rowtype record', 5);

127: OE_LINE_UTIL.QUERY_ROW( p_line_id => P_line_id
128: , x_line_rec => l_line_rec );
129:
130: IF l_debug_level > 0 THEN
131: oe_debug_pub.add( ' Converting to Rowtype record', 5);
132: END IF;
133:
134: OE_LINE_Util_Ext.API_Rec_To_Rowtype_Rec( p_LINE_rec => l_line_rec
135: , x_rowtype_rec => l_line_rowtype_rec);

Line 142: oe_debug_pub.add( ' Checking if update of Request Date is allowed', 5);

138: OE_LINE_SECURITY.g_record := l_line_rowtype_rec;
139:
140: IF P_Attribute IS NULL OR P_Attribute in ('REQUEST_DATE','ALL') THEN
141: IF l_debug_level > 0 THEN
142: oe_debug_pub.add( ' Checking if update of Request Date is allowed', 5);
143: END IF;
144: l_result := OE_Line_Security.Request_Date -- Is_OP_Constrained
145: ( p_operation => OE_PC_GLOBALS.UPDATE_OP
146: -- , p_column_name => 'REQUEST_DATE'

Line 152: oe_debug_pub.add( ' Update of Request Date is allowed. Action'||l_action,1);

148: , x_on_operation_action => l_action );
149:
150: IF l_result = OE_PC_GLOBALS.NO THEN
151: IF l_debug_level > 0 THEN
152: oe_debug_pub.add( ' Update of Request Date is allowed. Action'||l_action,1);
153: END IF;
154: l_attr_update_allowed := TRUE;
155: ELSE
156: IF l_debug_level > 0 THEN

Line 157: oe_debug_pub.add( ' Update of Request Date is not allowed.',1);

153: END IF;
154: l_attr_update_allowed := TRUE;
155: ELSE
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( ' Update of Request Date is not allowed.',1);
158: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
159: END IF;
160: l_attr_Update_Allowed := FALSE;
161: END IF; -- l_result

Line 158: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);

154: l_attr_update_allowed := TRUE;
155: ELSE
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( ' Update of Request Date is not allowed.',1);
158: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
159: END IF;
160: l_attr_Update_Allowed := FALSE;
161: END IF; -- l_result
162: END IF; -- P_Attribute

Line 168: oe_debug_pub.add( ' Checking if update of Ordered Quantity is allowed',5);

164:
165: IF (NOT l_attr_update_allowed AND P_Attribute IS NULL)
166: OR P_Attribute in ('ORDERED_QUANTITY', 'ALL') THEN
167: IF l_debug_level > 0 THEN
168: oe_debug_pub.add( ' Checking if update of Ordered Quantity is allowed',5);
169: END IF;
170:
171: l_result := OE_Line_Security.Ordered_Quantity --Is_OP_Constrained
172: ( p_operation => OE_PC_GLOBALS.UPDATE_OP

Line 179: oe_debug_pub.add( 'Update of Ordered Quantity is allowed. Action'||l_action,1);

175: , x_on_operation_action => l_action );
176:
177: IF l_result = OE_PC_GLOBALS.NO THEN
178: IF l_debug_level > 0 THEN
179: oe_debug_pub.add( 'Update of Ordered Quantity is allowed. Action'||l_action,1);
180: END IF;
181: l_attr_Update_Allowed := TRUE;
182: ELSE
183: IF l_debug_level > 0 THEN

Line 184: oe_debug_pub.add( ' Update of Ordered Quantity is not allowed.',1);

180: END IF;
181: l_attr_Update_Allowed := TRUE;
182: ELSE
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( ' Update of Ordered Quantity is not allowed.',1);
185: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
186: END IF;
187: l_attr_Update_Allowed := FALSE;
188: END IF; -- l_result

Line 185: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);

181: l_attr_Update_Allowed := TRUE;
182: ELSE
183: IF l_debug_level > 0 THEN
184: oe_debug_pub.add( ' Update of Ordered Quantity is not allowed.',1);
185: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
186: END IF;
187: l_attr_Update_Allowed := FALSE;
188: END IF; -- l_result
189: END IF; -- P_Attribute

Line 192: oe_debug_pub.add( ' Checking if Update operation is allowed for a record',5);

188: END IF; -- l_result
189: END IF; -- P_Attribute
190:
191: IF l_debug_level > 0 THEN
192: oe_debug_pub.add( ' Checking if Update operation is allowed for a record',5);
193: END IF;
194: IF ( NOT l_entity_update_allowed ) AND ( l_attr_update_allowed ) THEN
195:
196: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line 205: oe_debug_pub.add( 'Update is allowed for Entity. Action'||l_action,1);

201: , x_return_status => l_return_status );
202:
203: IF l_result = OE_PC_GLOBALS.NO THEN
204: IF l_debug_level > 0 THEN
205: oe_debug_pub.add( 'Update is allowed for Entity. Action'||l_action,1);
206: END IF;
207: l_entity_Update_Allowed := TRUE;
208: ELSE
209: IF l_debug_level > 0 THEN

Line 210: oe_debug_pub.add( ' Entity Update is not allowed.',1);

206: END IF;
207: l_entity_Update_Allowed := TRUE;
208: ELSE
209: IF l_debug_level > 0 THEN
210: oe_debug_pub.add( ' Entity Update is not allowed.',1);
211: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
212: END IF;
213: l_entity_Update_Allowed := FALSE;
214: END IF; -- l_result

Line 211: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);

207: l_entity_Update_Allowed := TRUE;
208: ELSE
209: IF l_debug_level > 0 THEN
210: oe_debug_pub.add( ' Entity Update is not allowed.',1);
211: oe_debug_pub.add( ' Action / Result : '||l_action||' / '||l_result,1);
212: END IF;
213: l_entity_Update_Allowed := FALSE;
214: END IF; -- l_result
215: END IF; -- l_entity_update_allowed

Line 219: oe_debug_pub.add( ' Order Line is allowed to UPDATE.',1);

215: END IF; -- l_entity_update_allowed
216:
217: IF l_entity_update_allowed AND l_attr_update_allowed THEN
218: IF l_debug_level > 0 THEN
219: oe_debug_pub.add( ' Order Line is allowed to UPDATE.',1);
220: END IF;
221: RETURN TRUE;
222: ELSE
223: IF l_debug_level > 0 THEN

Line 224: oe_debug_pub.add( ' Order Line is NOT allowed to UPDATE.',1);

220: END IF;
221: RETURN TRUE;
222: ELSE
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( ' Order Line is NOT allowed to UPDATE.',1);
225: END IF;
226: -- Resetting the Boolean for the next iteration of the loop
227: l_entity_update_allowed := FALSE;
228: l_attr_update_allowed := FALSE;

Line 233: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Update_Allowed', 1 ) ;

229: RETURN FALSE;
230: END IF;
231:
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Update_Allowed', 1 ) ;
234: END IF;
235: Exception
236: WHEN OTHERS THEN
237: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Update_Allowed '||sqlerrm,1);

Line 237: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Update_Allowed '||sqlerrm,1);

233: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Update_Allowed', 1 ) ;
234: END IF;
235: Exception
236: WHEN OTHERS THEN
237: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Update_Allowed '||sqlerrm,1);
238: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
239: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Allowed');
240: -- Pkg Body global variable = 'OE_internal_Requisition_Pv'
241: END IF;

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

257: l_grp NUMBER;
258: l_on_operation_action NUMBER;
259: l_column_name VARCHAR2(120);
260: --
261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
262: --
263: Begin
264: IF l_debug_level > 0 THEN
265: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Allowed', 1) ;

Line 265: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Allowed', 1) ;

261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
262: --
263: Begin
264: IF l_debug_level > 0 THEN
265: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Allowed', 1) ;
266: END IF;
267:
268: OE_LINE_UTIL.QUERY_ROW( p_line_id => P_line_id
269: , x_line_rec => l_line_rec );

Line 272: oe_debug_pub.add( ' Calling OE_Line_SEcurity.Entity',5);

268: OE_LINE_UTIL.QUERY_ROW( p_line_id => P_line_id
269: , x_line_rec => l_line_rec );
270:
271: IF l_debug_level > 0 THEN
272: oe_debug_pub.add( ' Calling OE_Line_SEcurity.Entity',5);
273: END IF;
274:
275: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
276: l_line_rec.ordered_quantity := 0;

Line 323: oe_debug_pub.add( 'Cancel is allowed for this shipment.',1);

319: */
320:
321: IF l_result = OE_PC_GLOBALS.NO THEN
322: IF l_debug_level > 0 THEN
323: oe_debug_pub.add( 'Cancel is allowed for this shipment.',1);
324: END IF;
325: RETURN TRUE;
326: ELSE
327: IF l_debug_level > 0 THEN

Line 328: oe_debug_pub.add( 'Cancel is Not allowed for this shipment',1);

324: END IF;
325: RETURN TRUE;
326: ELSE
327: IF l_debug_level > 0 THEN
328: oe_debug_pub.add( 'Cancel is Not allowed for this shipment',1);
329: END IF;
330: RETURN FALSE;
331: END IF;
332: ELSE

Line 334: oe_debug_pub.add( 'Cancel is not allowed for this shipment.',1);

330: RETURN FALSE;
331: END IF;
332: ELSE
333: IF l_debug_level > 0 THEN
334: oe_debug_pub.add( 'Cancel is not allowed for this shipment.',1);
335: END IF;
336: RETURN FALSE;
337: END IF;
338: IF l_debug_level > 0 THEN

Line 339: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Cancel_Allowed', 1 ) ;

335: END IF;
336: RETURN FALSE;
337: END IF;
338: IF l_debug_level > 0 THEN
339: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Cancel_Allowed', 1 ) ;
340: END IF;
341:
342: Exception
343: WHEN OTHERS THEN

Line 344: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Allowed '||sqlerrm,1);

340: END IF;
341:
342: Exception
343: WHEN OTHERS THEN
344: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Allowed '||sqlerrm,1);
345: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
346: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Allowed');
347: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
348: END IF;

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

359: l_header_rowtype_rec OE_AK_ORDER_HEADERS_V%ROWTYPE;
360: l_action NUMBER;
361: l_result NUMBER := OE_PC_GLOBALS.NO;
362: --
363: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
364: --
365: Begin
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Header_Allowed', 1 ) ;

Line 367: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Header_Allowed', 1 ) ;

363: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
364: --
365: Begin
366: IF l_debug_level > 0 THEN
367: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Cancel_Header_Allowed', 1 ) ;
368: END IF;
369:
370: OE_HEADER_UTIL.QUERY_ROW( p_header_id => P_header_id
371: , x_header_rec => l_header_rec );

Line 374: oe_debug_pub.add( ' Converting to Rowtype record',5);

370: OE_HEADER_UTIL.QUERY_ROW( p_header_id => P_header_id
371: , x_header_rec => l_header_rec );
372:
373: IF l_debug_level > 0 THEN
374: oe_debug_pub.add( ' Converting to Rowtype record',5);
375: END IF;
376:
377: OE_HEADER_Util.API_Rec_To_Rowtype_Rec( p_header_rec => l_header_rec
378: , x_rowtype_rec => l_header_rowtype_rec);

Line 390: oe_debug_pub.add( 'Cancel is allowed for this Order. Action'||l_action,1);

386: , x_on_operation_action => l_action );
387:
388: IF l_result = OE_PC_GLOBALS.NO THEN
389: IF l_debug_level > 0 THEN
390: oe_debug_pub.add( 'Cancel is allowed for this Order. Action'||l_action,1);
391: END IF;
392: RETURN TRUE;
393: ELSE
394: IF l_debug_level > 0 THEN

Line 395: oe_debug_pub.add( 'Cancel is not allowed for this Order. Action'||l_action,1);

391: END IF;
392: RETURN TRUE;
393: ELSE
394: IF l_debug_level > 0 THEN
395: oe_debug_pub.add( 'Cancel is not allowed for this Order. Action'||l_action,1);
396: END IF;
397: RETURN FALSE;
398: END IF;
399: IF l_debug_level > 0 THEN

Line 400: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Cancel_Header_Allowed', 1 ) ;

396: END IF;
397: RETURN FALSE;
398: END IF;
399: IF l_debug_level > 0 THEN
400: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Cancel_Header_Allowed', 1 ) ;
401: END IF;
402:
403: Exception
404: WHEN OTHERS THEN

Line 405: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Header_Allowed '||sqlerrm,1);

401: END IF;
402:
403: Exception
404: WHEN OTHERS THEN
405: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Header_Allowed '||sqlerrm,1);
406: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
407: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Header_Allowed');
408: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
409: END IF;

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

426: l_header_id NUMBER;
427: l_msg_count NUMBER;
428: l_msg_data VARCHAR2(2000);
429: --
430: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
431: --
432: BEGIN
433:
434: IF l_debug_level > 0 THEN

Line 435: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;

431: --
432: BEGIN
433:
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;
436: oe_debug_pub.add( ' Count of Lines :'||P_Line_Tbl.COUNT, 5 ) ;
437: oe_debug_pub.add( ' Mode :'||P_Mode, 5 ) ;
438: END IF;
439:

Line 436: oe_debug_pub.add( ' Count of Lines :'||P_Line_Tbl.COUNT, 5 ) ;

432: BEGIN
433:
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;
436: oe_debug_pub.add( ' Count of Lines :'||P_Line_Tbl.COUNT, 5 ) ;
437: oe_debug_pub.add( ' Mode :'||P_Mode, 5 ) ;
438: END IF;
439:
440: l_x_line_tbl := p_line_tbl;

Line 437: oe_debug_pub.add( ' Mode :'||P_Mode, 5 ) ;

433:
434: IF l_debug_level > 0 THEN
435: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;
436: oe_debug_pub.add( ' Count of Lines :'||P_Line_Tbl.COUNT, 5 ) ;
437: oe_debug_pub.add( ' Mode :'||P_Mode, 5 ) ;
438: END IF;
439:
440: l_x_line_tbl := p_line_tbl;
441: l_header_id := l_x_line_tbl(1).header_id;

Line 462: oe_debug_pub.add( ' After OE_Order_Pvt.Lines: '||l_return_status);

458: , p_x_old_line_tbl => l_x_old_line_tbl
459: , x_return_status => l_return_status);
460:
461: IF l_debug_level > 0 THEN
462: oe_debug_pub.add( ' After OE_Order_Pvt.Lines: '||l_return_status);
463: END IF;
464:
465: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
466: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 482: oe_debug_pub.add( ' Process_requests_and_notify UNEXP_ERROR',1 ) ;

478: , x_return_status => l_return_status );
479:
480: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
481: IF l_debug_level > 0 THEN
482: oe_debug_pub.add( ' Process_requests_and_notify UNEXP_ERROR',1 ) ;
483: END IF;
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: IF l_debug_level > 0 THEN

Line 487: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR',1 ) ;

483: END IF;
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
486: IF l_debug_level > 0 THEN
487: oe_debug_pub.add( 'Process_requests_and_notify RET_STS_ERROR',1 ) ;
488: END IF;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491: IF P_Cancel THEN

Line 499: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;

495:
496: x_return_status := l_return_status;
497:
498: IF l_debug_level > 0 THEN
499: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Process_Line_Entity', 1 ) ;
500: END IF;
501:
502: EXCEPTION
503: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 522: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;

518: ( G_PKG_NAME
519: , 'Process_Line_Entity' );
520: END IF;
521: IF l_debug_level > 0 THEN
522: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
523: END IF;
524: END Process_Line_Entity;
525:
526:

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

543: l_msg_count NUMBER;
544: l_msg_data VARCHAR2(2000);
545: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
546: --
547: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
548: --
549:
550: Begin
551:

Line 563: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;

559:
560: SavePoint Apply_Hold_For_IReq;
561:
562: IF l_debug_level > 0 THEN
563: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
564: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
565: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
566: END IF;
567:

Line 564: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;

560: SavePoint Apply_Hold_For_IReq;
561:
562: IF l_debug_level > 0 THEN
563: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
564: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
565: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
566: END IF;
567:
568: -- OE_MSG_PUB.set_msg_context();

Line 565: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;

561:
562: IF l_debug_level > 0 THEN
563: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
564: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
565: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
566: END IF;
567:
568: -- OE_MSG_PUB.set_msg_context();
569: -- No need to set the message context as the caller of this API is PO

Line 576: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);

572: l_return_status := FND_API.G_RET_STS_SUCCESS;
573:
574: IF P_internal_req_line_id is NULL THEN
575: IF l_debug_level > 0 THEN
576: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
577: END IF;
578: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
579: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');
580: OE_MSG_PUB.Add;

Line 585: oe_debug_pub.add( ' No value passed for Requisition Header',1);

581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583: IF P_internal_req_header_id is NULL THEN
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( ' No value passed for Requisition Header',1);
586: END IF;
587: Begin
588: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
589: select requisition_header_id

Line 588: oe_debug_pub.add( ' Retrieving Requisition Header id',5);

584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( ' No value passed for Requisition Header',1);
586: END IF;
587: Begin
588: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
589: select requisition_header_id
590: into l_req_hdr_id
591: from po_requisition_lines_all
592: where requisition_line_id = P_internal_req_line_id;

Line 595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

591: from po_requisition_lines_all
592: where requisition_line_id = P_internal_req_line_id;
593:
594: IF l_req_hdr_id IS NULL THEN
595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
596: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
597: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
598: OE_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;

Line 603: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);

599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601: Exception
602: When No_Data_Found Then
603: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
604: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
605: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
606: OE_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;

Line 626: oe_debug_pub.add( ' Applying hold for line_id '||l_line_ids_rec.line_id,5);

622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: IF l_debug_level > 0 THEN
626: oe_debug_pub.add( ' Applying hold for line_id '||l_line_ids_rec.line_id,5);
627: END IF;
628:
629: l_hold_source_rec.hold_id := 17;
630: -- Ensure that the new seeded hold_id should be 17 in seed database

Line 654: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;

650: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
651: P_Data => x_msg_Data);
652:
653: IF l_debug_level > 0 THEN
654: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
655: END IF;
656:
657: Exception
658: WHEN FND_API.G_EXC_ERROR THEN

Line 673: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);

669: P_Data => x_msg_Data);
670: ROLLBACK TO Apply_Hold_For_IReq;
671:
672: WHEN OTHERS THEN
673: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
674: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
676: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
677: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');

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

704: l_msg_data VARCHAR2(2000);
705: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
706: l_hold_release_rec OE_Holds_Pvt.Hold_Release_REC_Type;
707: --
708: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
709: --
710:
711: Begin
712:

Line 724: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;

720:
721: SavePoint Release_Hold_For_IReq;
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
725: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
726: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
727: END IF;
728:

Line 725: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;

721: SavePoint Release_Hold_For_IReq;
722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
725: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
726: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
727: END IF;
728:
729: -- OE_MSG_PUB.set_msg_context();

Line 726: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;

722:
723: IF l_debug_level > 0 THEN
724: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
725: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
726: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
727: END IF;
728:
729: -- OE_MSG_PUB.set_msg_context();
730: -- No need to set the message context as the caller of this API is PO

Line 737: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);

733: l_return_status := FND_API.G_RET_STS_SUCCESS;
734:
735: IF P_internal_req_line_id is NULL THEN
736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
738: END IF;
739: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
740: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
741: OE_MSG_PUB.Add;

Line 746: oe_debug_pub.add( ' No value passed for Requisition Header',1);

742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: IF P_internal_req_header_id is NULL THEN
745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( ' No value passed for Requisition Header',1);
747: END IF;
748: Begin
749: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
750: select requisition_header_id

Line 749: oe_debug_pub.add( ' Retrieving Requisition Header id',5);

745: IF l_debug_level > 0 THEN
746: oe_debug_pub.add( ' No value passed for Requisition Header',1);
747: END IF;
748: Begin
749: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
750: select requisition_header_id
751: into l_req_hdr_id
752: from po_requisition_lines_all
753: where requisition_line_id = P_internal_req_line_id;

Line 756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

752: from po_requisition_lines_all
753: where requisition_line_id = P_internal_req_line_id;
754:
755: IF l_req_hdr_id IS NULL THEN
756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
757: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
758: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
759: OE_MSG_PUB.Add;
760: RAISE FND_API.G_EXC_ERROR;

Line 764: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);

760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: Exception
763: When No_Data_Found Then
764: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
765: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
766: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
767: OE_MSG_PUB.Add;
768: RAISE FND_API.G_EXC_ERROR;

Line 795: oe_debug_pub.add( ' Releasing hold for line_id '||l_line_id,5);

791: and h.source_document_id = l_req_hdr_id
792: and l.source_document_line_id = P_internal_req_line_id;
793:
794: IF l_debug_level > 0 THEN
795: oe_debug_pub.add( ' Releasing hold for line_id '||l_line_id,5);
796: END IF;
797:
798: l_hold_source_rec.hold_id := 17;
799: -- Ensure that the new seeded hold_id should be 17 in seed database

Line 824: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');

820:
821: Exception
822: When No_Data_Found Then
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');
825: END IF;
826: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');
827: -- There is no sales order line shipment on hold.
828: OE_MSG_PUB.Add;

Line 833: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;

829: X_return_status := FND_API.G_RET_STS_ERROR;
830:
831: When Too_Many_Rows Then
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;
834: END IF;
835: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');
836: -- There are many sales order line shipments eligible for hold release. This is not allowed.
837: OE_MSG_PUB.Add;

Line 851: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;

847: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
848: P_Data => x_msg_Data);
849:
850: IF l_debug_level > 0 THEN
851: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
852: END IF;
853:
854: Exception
855: WHEN FND_API.G_EXC_ERROR THEN

Line 871: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);

867: P_Data => x_msg_Data);
868: ROLLBACK TO Release_Hold_For_IReq;
869:
870: WHEN OTHERS THEN
871: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
872: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
875: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');

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

919: l_msg_data VARCHAR2(2000);
920: l_hold_applied_count NUMBER := 0;
921: l_hold_source_rec OE_HOLDS_PVT.Hold_Source_Rec_Type;
922: --
923: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
924: --
925:
926: Begin
927:

Line 937: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;

933: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
934: END IF;
935:
936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
938: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
939: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
940: END IF;
941:

Line 938: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;

934: END IF;
935:
936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
938: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
939: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
940: END IF;
941:
942: -- OE_MSG_PUB.set_msg_context();

Line 939: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;

935:
936: IF l_debug_level > 0 THEN
937: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
938: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
939: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
940: END IF;
941:
942: -- OE_MSG_PUB.set_msg_context();
943: -- No need to set the message context as the caller of this API is PO

Line 952: oe_debug_pub.add( ' Invalid value for Requisition Header/Line',1);

948: X_Cancel_Allowed := FALSE;
949:
950: IF P_internal_req_header_id is NULL AND P_internal_req_line_id is NULL THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( ' Invalid value for Requisition Header/Line',1);
953: END IF;
954: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_INFO');
955: OE_MSG_PUB.Add;
956: RAISE FND_API.G_EXC_ERROR;

Line 961: oe_debug_pub.add('Requisition Line is NULL. We cannot check if Requisition Line is allowed to Update',1);

957: END IF;
958:
959: IF P_internal_req_header_id is NOT NULL AND P_internal_req_line_id is NULL THEN
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.add('Requisition Line is NULL. We cannot check if Requisition Line is allowed to Update',1);
962: END IF;
963: X_UPDATE_Allowed := FALSE;
964:
965: IF l_debug_level > 0 THEN

Line 966: oe_debug_pub.add( ' Checking if Requisition header is allowed to Cancel',5);

962: END IF;
963: X_UPDATE_Allowed := FALSE;
964:
965: IF l_debug_level > 0 THEN
966: oe_debug_pub.add( ' Checking if Requisition header is allowed to Cancel',5);
967: END IF;
968: Begin
969: select h.header_id
970: into l_header_id

Line 977: oe_debug_pub.add( ' Header id is '||l_header_id,5);

973: and h.order_source_id = OE_Globals.G_ORDER_SOURCE_INTERNAL
974: and h.open_flag = 'Y';
975:
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( ' Header id is '||l_header_id,5);
978: END IF;
979:
980: OPEN All_Order_Lines (l_header_id);
981: LOOP

Line 986: oe_debug_pub.add( ' Checking cancellation allowed for line_id '||l_line_id,5);

982: FETCH All_Order_Lines INTO l_line_id;
983: EXIT WHEN All_Order_Lines%NOTFOUND;
984: l_lines_ctr := l_lines_ctr + 1;
985: IF l_debug_level > 0 THEN
986: oe_debug_pub.add( ' Checking cancellation allowed for line_id '||l_line_id,5);
987: END IF;
988:
989: IF Cancel_Allowed( p_Line_id => l_line_id) THEN
990: l_cancel_eligble_lin := l_cancel_eligble_lin + 1;

Line 993: oe_debug_pub.add( ' Line is not allowed for cancellation',5);

989: IF Cancel_Allowed( p_Line_id => l_line_id) THEN
990: l_cancel_eligble_lin := l_cancel_eligble_lin + 1;
991: ELSE
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( ' Line is not allowed for cancellation',5);
994: oe_debug_pub.add( ' Since line cancel is not allowed, setting header FULL Cancel as FALSE',5);
995: oe_debug_pub.add( ' Exiting out of the loop ',5);
996: END IF;
997: X_Cancel_Allowed := FALSE;

Line 994: oe_debug_pub.add( ' Since line cancel is not allowed, setting header FULL Cancel as FALSE',5);

990: l_cancel_eligble_lin := l_cancel_eligble_lin + 1;
991: ELSE
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( ' Line is not allowed for cancellation',5);
994: oe_debug_pub.add( ' Since line cancel is not allowed, setting header FULL Cancel as FALSE',5);
995: oe_debug_pub.add( ' Exiting out of the loop ',5);
996: END IF;
997: X_Cancel_Allowed := FALSE;
998: l_skip_ctr_chk := TRUE;

Line 995: oe_debug_pub.add( ' Exiting out of the loop ',5);

991: ELSE
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( ' Line is not allowed for cancellation',5);
994: oe_debug_pub.add( ' Since line cancel is not allowed, setting header FULL Cancel as FALSE',5);
995: oe_debug_pub.add( ' Exiting out of the loop ',5);
996: END IF;
997: X_Cancel_Allowed := FALSE;
998: l_skip_ctr_chk := TRUE;
999: EXIT;

Line 1006: oe_debug_pub.add( ' Total number of order lines are '||l_lines_ctr);

1002: CLOSE All_Order_Lines;
1003:
1004: IF NOT l_skip_ctr_chk THEN
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( ' Total number of order lines are '||l_lines_ctr);
1007: oe_debug_pub.add( ' Total number of lines eligible for cancellation are '||l_cancel_eligble_lin);
1008: END IF;
1009:
1010: IF l_lines_ctr = l_cancel_eligble_lin THEN

Line 1007: oe_debug_pub.add( ' Total number of lines eligible for cancellation are '||l_cancel_eligble_lin);

1003:
1004: IF NOT l_skip_ctr_chk THEN
1005: IF l_debug_level > 0 THEN
1006: oe_debug_pub.add( ' Total number of order lines are '||l_lines_ctr);
1007: oe_debug_pub.add( ' Total number of lines eligible for cancellation are '||l_cancel_eligble_lin);
1008: END IF;
1009:
1010: IF l_lines_ctr = l_cancel_eligble_lin THEN
1011: IF l_debug_level > 0 THEN

Line 1012: oe_debug_pub.add( ' All Lines are eligible for cancellation',5);

1008: END IF;
1009:
1010: IF l_lines_ctr = l_cancel_eligble_lin THEN
1011: IF l_debug_level > 0 THEN
1012: oe_debug_pub.add( ' All Lines are eligible for cancellation',5);
1013: END IF;
1014: X_Cancel_Allowed := Cancel_Header_Allowed( P_header_id => l_header_id);
1015: IF X_Cancel_Allowed THEN
1016: IF l_debug_level > 0 THEN

Line 1017: oe_debug_pub.add( ' Header cancellation is TRUE',5);

1013: END IF;
1014: X_Cancel_Allowed := Cancel_Header_Allowed( P_header_id => l_header_id);
1015: IF X_Cancel_Allowed THEN
1016: IF l_debug_level > 0 THEN
1017: oe_debug_pub.add( ' Header cancellation is TRUE',5);
1018: END IF;
1019: ELSE
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( ' Header cancellation is FALSE',5);

Line 1021: oe_debug_pub.add( ' Header cancellation is FALSE',5);

1017: oe_debug_pub.add( ' Header cancellation is TRUE',5);
1018: END IF;
1019: ELSE
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( ' Header cancellation is FALSE',5);
1022: END IF;
1023: END IF;
1024: ELSE
1025: IF l_debug_level > 0 THEN

Line 1026: oe_debug_pub.add( ' Header cancellation is not allowed' , 5);

1022: END IF;
1023: END IF;
1024: ELSE
1025: IF l_debug_level > 0 THEN
1026: oe_debug_pub.add( ' Header cancellation is not allowed' , 5);
1027: END IF;
1028: X_Cancel_Allowed := FALSE;
1029: END IF;
1030: END IF; -- NOT l_skip_ctr_chk

Line 1037: oe_debug_pub.add( ' Requisition is not allowed to cancel',1);

1033:
1034: Exception
1035: When No_Data_Found Then
1036: IF l_debug_level > 0 THEN
1037: oe_debug_pub.add( ' Requisition is not allowed to cancel',1);
1038: END IF;
1039: X_Cancel_Allowed := FALSE;
1040: GOTO SKIP_REQ_LINE_CHK;
1041: When Others Then

Line 1043: oe_debug_pub.add( ' Invalid value for Requisition Header',1);

1039: X_Cancel_Allowed := FALSE;
1040: GOTO SKIP_REQ_LINE_CHK;
1041: When Others Then
1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add( ' Invalid value for Requisition Header',1);
1044: END IF;
1045: X_Cancel_Allowed := FALSE;
1046: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1047: OE_MSG_PUB.Add;

Line 1054: oe_debug_pub.add( ' No value passed for Requisition Header',1);

1050: END IF;
1051:
1052: IF P_internal_req_header_id is NULL AND P_internal_req_line_id is NOT NULL THEN
1053: IF l_debug_level > 0 THEN
1054: oe_debug_pub.add( ' No value passed for Requisition Header',1);
1055: END IF;
1056: Begin
1057: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1058: select requisition_header_id

Line 1057: oe_debug_pub.add( ' Retrieving Requisition Header id',5);

1053: IF l_debug_level > 0 THEN
1054: oe_debug_pub.add( ' No value passed for Requisition Header',1);
1055: END IF;
1056: Begin
1057: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1058: select requisition_header_id
1059: into l_req_hdr_id
1060: from po_requisition_lines_all
1061: where requisition_line_id = P_internal_req_line_id;

Line 1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

1060: from po_requisition_lines_all
1061: where requisition_line_id = P_internal_req_line_id;
1062:
1063: IF l_req_hdr_id IS NULL THEN
1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1066: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1067: OE_MSG_PUB.Add;
1068: RAISE FND_API.G_EXC_ERROR;

Line 1072: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);

1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: Exception
1071: When No_Data_Found Then
1072: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1073: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1074: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1075: OE_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_ERROR;

Line 1095: oe_debug_pub.add( ' Line id: '||l_line_ids_rec.line_id,5);

1091: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1092: END IF;
1093:
1094: IF l_debug_level > 0 THEN
1095: oe_debug_pub.add( ' Line id: '||l_line_ids_rec.line_id,5);
1096: END IF;
1097:
1098: IF NOT X_Update_Allowed THEN
1099: IF l_debug_level > 0 THEN

Line 1100: oe_debug_pub.add( ' Checking if Update is allowed',5);

1096: END IF;
1097:
1098: IF NOT X_Update_Allowed THEN
1099: IF l_debug_level > 0 THEN
1100: oe_debug_pub.add( ' Checking if Update is allowed',5);
1101: END IF;
1102: l_Update_Allowed := Update_Allowed(P_Line_id => l_line_ids_rec.line_id);
1103: IF l_Update_Allowed THEN
1104: IF l_debug_level > 0 THEN

Line 1105: oe_debug_pub.add( ' Update is Allowed',5);

1101: END IF;
1102: l_Update_Allowed := Update_Allowed(P_Line_id => l_line_ids_rec.line_id);
1103: IF l_Update_Allowed THEN
1104: IF l_debug_level > 0 THEN
1105: oe_debug_pub.add( ' Update is Allowed',5);
1106: END IF;
1107: X_Update_Allowed := TRUE;
1108: ELSE
1109: IF l_debug_level > 0 THEN

Line 1110: oe_debug_pub.add(' Update is Not Allowed for this requisition line',1);

1106: END IF;
1107: X_Update_Allowed := TRUE;
1108: ELSE
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add(' Update is Not Allowed for this requisition line',1);
1111: END IF;
1112: END IF;
1113: END IF;
1114:

Line 1117: oe_debug_pub.add( ' Checking if Cancel is allowed',5);

1113: END IF;
1114:
1115: IF NOT X_Cancel_Allowed THEN
1116: IF l_debug_level > 0 THEN
1117: oe_debug_pub.add( ' Checking if Cancel is allowed',5);
1118: END IF;
1119: l_Cancel_Allowed := Cancel_Allowed(p_line_id => l_line_ids_rec.line_id);
1120:
1121: IF l_Cancel_Allowed THEN

Line 1123: oe_debug_pub.add( ' Cancel is Allowed',5);

1119: l_Cancel_Allowed := Cancel_Allowed(p_line_id => l_line_ids_rec.line_id);
1120:
1121: IF l_Cancel_Allowed THEN
1122: IF l_debug_level > 0 THEN
1123: oe_debug_pub.add( ' Cancel is Allowed',5);
1124: END IF;
1125: X_Cancel_Allowed := TRUE;
1126: ELSE
1127: IF l_debug_level > 0 THEN

Line 1128: oe_debug_pub.add(' Cancel is Not Allowed for this requisition line',1);

1124: END IF;
1125: X_Cancel_Allowed := TRUE;
1126: ELSE
1127: IF l_debug_level > 0 THEN
1128: oe_debug_pub.add(' Cancel is Not Allowed for this requisition line',1);
1129: END IF;
1130: END IF;
1131: END IF;
1132:

Line 1142: oe_debug_pub.add( ' Record is allowed to Update',5);

1138: null;
1139:
1140: IF l_debug_level > 0 THEN
1141: IF X_Update_Allowed THEN
1142: oe_debug_pub.add( ' Record is allowed to Update',5);
1143: END IF;
1144: IF X_Cancel_Allowed THEN
1145: oe_debug_pub.add( ' Record is allowed to Cancel',5);
1146: END IF;

Line 1145: oe_debug_pub.add( ' Record is allowed to Cancel',5);

1141: IF X_Update_Allowed THEN
1142: oe_debug_pub.add( ' Record is allowed to Update',5);
1143: END IF;
1144: IF X_Cancel_Allowed THEN
1145: oe_debug_pub.add( ' Record is allowed to Cancel',5);
1146: END IF;
1147: END IF;
1148:
1149: x_return_status := l_return_status;

Line 1155: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;

1151: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1152: P_Data => x_msg_Data);
1153:
1154: IF l_debug_level > 0 THEN
1155: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
1156: END IF;
1157:
1158: Exception
1159: WHEN FND_API.G_EXC_ERROR THEN

Line 1176: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);

1172: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1173: P_Data => x_msg_Data);
1174:
1175: WHEN OTHERS THEN
1176: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);
1177: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1179: X_Update_Allowed := FALSE;
1180: X_Cancel_Allowed := FALSE;

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

1247: l_cancel_request BOOLEAN := FALSE;
1248: l_Process_Line_Entity BOOLEAN := FALSE;
1249: l_Cancel_Allowed BOOLEAN := FALSE;
1250: --
1251: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1252: --
1253:
1254: Begin
1255:

Line 1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;

1263:
1264: SavePoint Call_Process_Order_for_IReq;
1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;

Line 1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;

1264: SavePoint Call_Process_Order_for_IReq;
1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;

Line 1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;

1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN

Line 1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;

1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN
1274: oe_debug_pub.add( ' Header level cancellation',5);

Line 1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;

1267: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN
1274: oe_debug_pub.add( ' Header level cancellation',5);
1275: ELSE

Line 1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;

1268: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1269: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN
1274: oe_debug_pub.add( ' Header level cancellation',5);
1275: ELSE
1276: oe_debug_pub.add( ' Not a header level cancellation',5);

Line 1274: oe_debug_pub.add( ' Header level cancellation',5);

1270: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1271: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;
1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN
1274: oe_debug_pub.add( ' Header level cancellation',5);
1275: ELSE
1276: oe_debug_pub.add( ' Not a header level cancellation',5);
1277: END IF;
1278: IF P_Cancel_ISO_Lines THEN

Line 1276: oe_debug_pub.add( ' Not a header level cancellation',5);

1272: oe_debug_pub.add( ' P_Delta_Ordered_Qty :'||P_Delta_Ordered_Qty , 5 ) ;
1273: IF P_Cancel_ISO THEN
1274: oe_debug_pub.add( ' Header level cancellation',5);
1275: ELSE
1276: oe_debug_pub.add( ' Not a header level cancellation',5);
1277: END IF;
1278: IF P_Cancel_ISO_Lines THEN
1279: oe_debug_pub.add( ' Line level cancellation',5);
1280: ELSE

Line 1279: oe_debug_pub.add( ' Line level cancellation',5);

1275: ELSE
1276: oe_debug_pub.add( ' Not a header level cancellation',5);
1277: END IF;
1278: IF P_Cancel_ISO_Lines THEN
1279: oe_debug_pub.add( ' Line level cancellation',5);
1280: ELSE
1281: oe_debug_pub.add( ' Not a line level cancellation',5);
1282: END IF;
1283: END IF;

Line 1281: oe_debug_pub.add( ' Not a line level cancellation',5);

1277: END IF;
1278: IF P_Cancel_ISO_Lines THEN
1279: oe_debug_pub.add( ' Line level cancellation',5);
1280: ELSE
1281: oe_debug_pub.add( ' Not a line level cancellation',5);
1282: END IF;
1283: END IF;
1284:
1285: -- OE_MSG_PUB.set_msg_context();

Line 1307: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;

1303: (P_Cancel_ISO_Lines AND P_Delta_Ordered_Qty IS NOT NULL AND P_Delta_Ordered_Qty <> 0) OR
1304: (P_New_Request_Date IS NOT NULL AND P_internal_req_line_id IS NULL) OR
1305: (P_Delta_Ordered_Qty IS NOT NULL AND P_Delta_Ordered_Qty <> 0 AND P_internal_req_line_id IS NULL) THEN
1306: IF l_debug_level > 0 THEN
1307: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;
1308: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;
1309: END IF;
1310: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');
1311: OE_MSG_PUB.Add;

Line 1308: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;

1304: (P_New_Request_Date IS NOT NULL AND P_internal_req_line_id IS NULL) OR
1305: (P_Delta_Ordered_Qty IS NOT NULL AND P_Delta_Ordered_Qty <> 0 AND P_internal_req_line_id IS NULL) THEN
1306: IF l_debug_level > 0 THEN
1307: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;
1308: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;
1309: END IF;
1310: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');
1311: OE_MSG_PUB.Add;
1312: RAISE FND_API.G_EXC_ERROR;

Line 1317: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;

1313: END IF;
1314:
1315: IF P_Mode NOT IN ('V','P') THEN
1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;
1318: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);
1319: END IF;
1320: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');
1321: OE_MSG_PUB.Add;

Line 1318: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);

1314:
1315: IF P_Mode NOT IN ('V','P') THEN
1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;
1318: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);
1319: END IF;
1320: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');
1321: OE_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;

Line 1327: oe_debug_pub.add( ' No value passed for Requisition Header',1);

1323: END IF;
1324:
1325: IF P_internal_req_header_id is NULL THEN
1326: IF l_debug_level > 0 THEN
1327: oe_debug_pub.add( ' No value passed for Requisition Header',1);
1328: END IF;
1329: Begin
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add( ' Retrieving Requisition Header id',5);

Line 1331: oe_debug_pub.add( ' Retrieving Requisition Header id',5);

1327: oe_debug_pub.add( ' No value passed for Requisition Header',1);
1328: END IF;
1329: Begin
1330: IF l_debug_level > 0 THEN
1331: oe_debug_pub.add( ' Retrieving Requisition Header id',5);
1332: END IF;
1333: select requisition_header_id
1334: into l_req_hdr_id
1335: from po_requisition_lines_all

Line 1340: oe_debug_pub.add( ' Invalid value for Requisition Header',5);

1336: where requisition_line_id = P_internal_req_line_id;
1337:
1338: IF l_req_hdr_id IS NULL THEN
1339: IF l_debug_level > 0 THEN
1340: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1341: END IF;
1342: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1343: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1344: OE_MSG_PUB.Add;

Line 1350: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);

1346: END IF;
1347: Exception
1348: When No_Data_Found Then
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1351: END IF;
1352: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1353: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1354: OE_MSG_PUB.Add;

Line 1367: oe_debug_pub.add(' Order level cancellation request',5);

1363: l_lin_update := 0;
1364:
1365: IF P_Cancel_ISO THEN
1366: IF l_debug_level > 0 THEN
1367: oe_debug_pub.add(' Order level cancellation request',5);
1368: END IF;
1369:
1370: Begin
1371: select header_id

Line 1380: oe_debug_pub.add( ' Invalid value passed for Requisition Header: no data found',1);

1376: and h.open_flag = 'Y';
1377: Exception
1378: WHEN No_Data_found THEN
1379: IF l_debug_level > 0 THEN
1380: oe_debug_pub.add( ' Invalid value passed for Requisition Header: no data found',1);
1381: END IF;
1382: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');
1383: RAISE FND_API.G_EXC_ERROR;
1384: WHEN Too_Many_Rows THEN

Line 1386: oe_debug_pub.add( ' Invalid value passed for Requisition Header: too many rows',1);

1382: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');
1383: RAISE FND_API.G_EXC_ERROR;
1384: WHEN Too_Many_Rows THEN
1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add( ' Invalid value passed for Requisition Header: too many rows',1);
1387: END IF;
1388: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');
1389: RAISE FND_API.G_EXC_ERROR;
1390: End;

Line 1396: oe_debug_pub.add( ' No Header level cancellation constraint',5);

1392: l_Cancel_Allowed := Cancel_Header_Allowed( P_header_id => l_order_header_id);
1393:
1394: IF l_Cancel_Allowed THEN
1395: IF l_debug_level > 0 THEN
1396: oe_debug_pub.add( ' No Header level cancellation constraint',5);
1397: END IF;
1398:
1399: OPEN All_Order_Lines (l_order_header_id);
1400: LOOP

Line 1433: oe_debug_pub.add('Order cancellation request is valid',5);

1429: and nvl(cancelled_flag,'N') = 'N';
1430:
1431: IF l_cancel_eligble_lin > 0 OR l_count_of_lines = 0 THEN
1432: IF l_debug_level > 0 THEN
1433: oe_debug_pub.add('Order cancellation request is valid',5);
1434: END IF;
1435:
1436: IF l_count_of_lines = l_cancel_eligble_lin THEN
1437:

Line 1439: oe_debug_pub.add(' Cancel FULL Order request',5);

1435:
1436: IF l_count_of_lines = l_cancel_eligble_lin THEN
1437:
1438: IF l_debug_level > 0 THEN
1439: oe_debug_pub.add(' Cancel FULL Order request',5);
1440: END IF;
1441:
1442: OE_MSG_PUB.set_msg_context
1443: ( p_entity_code => 'HEADER'

Line 1505: oe_debug_pub.add( ' Return Status is '||l_return_status,1) ;

1501:
1502:
1503: x_return_status := l_return_status;
1504: IF l_debug_level > 0 THEN
1505: oe_debug_pub.add( ' Return Status is '||l_return_status,1) ;
1506: END IF;
1507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( ' CANCELLATION UNEXPECTED FAILURE',1 ) ;

Line 1509: oe_debug_pub.add( ' CANCELLATION UNEXPECTED FAILURE',1 ) ;

1505: oe_debug_pub.add( ' Return Status is '||l_return_status,1) ;
1506: END IF;
1507: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1508: IF l_debug_level > 0 THEN
1509: oe_debug_pub.add( ' CANCELLATION UNEXPECTED FAILURE',1 ) ;
1510: END IF;
1511: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1515: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;

1511: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1512: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1513: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1514: IF l_debug_level > 0 THEN
1515: oe_debug_pub.add( ' CANCELLATION EXPECTED FAILURE',1 ) ;
1516: END IF;
1517: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1518: RAISE FND_API.G_EXC_ERROR;
1519: END IF;

Line 1529: oe_debug_pub.add(' Cancel REMAINING Order request',5);

1525: OE_MSG_PUB.Reset_Msg_Context('HEADER');
1526:
1527: ELSIF l_count_of_lines > l_cancel_eligble_lin THEN
1528: IF l_debug_level > 0 THEN
1529: oe_debug_pub.add(' Cancel REMAINING Order request',5);
1530: END IF;
1531: l_Process_Line_Entity := TRUE;
1532: l_cancel_request := TRUE;
1533: END IF; -- l_count_of_lines = l_cancel_eligble_lin

Line 1537: oe_debug_pub.add( ' There are Header level cancellation constraint',5);

1533: END IF; -- l_count_of_lines = l_cancel_eligble_lin
1534: END IF;
1535: ELSE
1536: IF l_debug_level > 0 THEN
1537: oe_debug_pub.add( ' There are Header level cancellation constraint',5);
1538: END IF;
1539: l_return_status := FND_API.G_RET_STS_ERROR;
1540: END IF;
1541: END IF; -- P_Cancel_Order

Line 1560: oe_debug_pub.add(' Line level Cancel request',5);

1556: END IF;
1557:
1558: IF P_Cancel_ISO_Lines THEN
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add(' Line level Cancel request',5);
1561: oe_debug_pub.add(' Check for Cancel of Line_id '||l_line_ids_rec.line_id,5);
1562: END IF;
1563: IF Cancel_Allowed( p_Line_id => l_line_ids_rec.line_id) THEN
1564: l_lin_cancel := l_lin_cancel + 1;

Line 1561: oe_debug_pub.add(' Check for Cancel of Line_id '||l_line_ids_rec.line_id,5);

1557:
1558: IF P_Cancel_ISO_Lines THEN
1559: IF l_debug_level > 0 THEN
1560: oe_debug_pub.add(' Line level Cancel request',5);
1561: oe_debug_pub.add(' Check for Cancel of Line_id '||l_line_ids_rec.line_id,5);
1562: END IF;
1563: IF Cancel_Allowed( p_Line_id => l_line_ids_rec.line_id) THEN
1564: l_lin_cancel := l_lin_cancel + 1;
1565: OE_LINE_UTIL.QUERY_ROW( p_line_id => l_line_ids_rec.line_id

Line 1581: oe_debug_pub.add(' Cancel is not allowed for this line. Setting the status to Error',5);

1577: l_Process_Line_Entity := TRUE;
1578: l_cancel_request := TRUE;
1579: ELSE
1580: IF l_debug_level > 0 THEN
1581: oe_debug_pub.add(' Cancel is not allowed for this line. Setting the status to Error',5);
1582: END IF;
1583: l_return_status := FND_API.G_RET_STS_ERROR;
1584: END IF;
1585:

Line 1590: oe_debug_pub.add(' This is an Update request',5);

1586: ELSIF P_New_Request_Date IS NOT NULL OR ( P_Delta_Ordered_Qty IS NOT NULL
1587: AND p_Delta_Ordered_Qty <> 0) THEN -- This is an update request
1588:
1589: IF l_debug_level > 0 THEN
1590: oe_debug_pub.add(' This is an Update request',5);
1591: END IF;
1592:
1593: IF P_New_Request_Date IS NOT NULL AND ( P_Delta_Ordered_Qty IS NULL
1594: OR p_Delta_Ordered_Qty = 0) THEN

Line 1597: oe_debug_pub.add(' Only Request Date is changed',5);

1593: IF P_New_Request_Date IS NOT NULL AND ( P_Delta_Ordered_Qty IS NULL
1594: OR p_Delta_Ordered_Qty = 0) THEN
1595:
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add(' Only Request Date is changed',5);
1598: oe_debug_pub.add(' Check if update is allowed for line_id '||l_line_ids_rec.line_id,5);
1599: END IF;
1600: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1601: Update_Allowed( p_Line_id => l_line_ids_rec.line_id

Line 1598: oe_debug_pub.add(' Check if update is allowed for line_id '||l_line_ids_rec.line_id,5);

1594: OR p_Delta_Ordered_Qty = 0) THEN
1595:
1596: IF l_debug_level > 0 THEN
1597: oe_debug_pub.add(' Only Request Date is changed',5);
1598: oe_debug_pub.add(' Check if update is allowed for line_id '||l_line_ids_rec.line_id,5);
1599: END IF;
1600: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1601: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1602: , P_Attribute => 'REQUEST_DATE') THEN

Line 1605: oe_debug_pub.add(' Request Date is different w.r.t. sales order line ',5);

1601: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1602: , P_Attribute => 'REQUEST_DATE') THEN
1603:
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add(' Request Date is different w.r.t. sales order line ',5);
1606: oe_debug_pub.add(' Request Date is allowed to change',5);
1607: END IF;
1608:
1609: l_lin_update := l_lin_update + 1;

Line 1606: oe_debug_pub.add(' Request Date is allowed to change',5);

1602: , P_Attribute => 'REQUEST_DATE') THEN
1603:
1604: IF l_debug_level > 0 THEN
1605: oe_debug_pub.add(' Request Date is different w.r.t. sales order line ',5);
1606: oe_debug_pub.add(' Request Date is allowed to change',5);
1607: END IF;
1608:
1609: l_lin_update := l_lin_update + 1;
1610:

Line 1625: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);

1621: l_Process_Line_Entity := TRUE;
1622:
1623: ELSE
1624: IF l_debug_level > 0 THEN
1625: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);
1626: END IF;
1627: l_return_status := FND_API.G_RET_STS_ERROR;
1628: END IF;
1629:

Line 1634: oe_debug_pub.add(' Only Ordered Quantity is changed',5);

1630: ELSIF P_New_Request_Date IS NULL AND (P_Delta_Ordered_Qty IS NOT NULL
1631: OR p_Delta_Ordered_Qty <> 0) THEN
1632:
1633: IF l_debug_level > 0 THEN
1634: oe_debug_pub.add(' Only Ordered Quantity is changed',5);
1635: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1636: END IF;
1637: IF Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1638: , P_Attribute => 'ORDERED_QUANTITY') THEN

Line 1635: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);

1631: OR p_Delta_Ordered_Qty <> 0) THEN
1632:
1633: IF l_debug_level > 0 THEN
1634: oe_debug_pub.add(' Only Ordered Quantity is changed',5);
1635: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1636: END IF;
1637: IF Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1638: , P_Attribute => 'ORDERED_QUANTITY') THEN
1639:

Line 1656: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);

1652: l_Process_Line_Entity := TRUE;
1653:
1654: ELSE
1655: IF l_debug_level > 0 THEN
1656: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);
1657: END IF;
1658: l_return_status := FND_API.G_RET_STS_ERROR;
1659: END IF;
1660:

Line 1665: oe_debug_pub.add(' Both Request Date and Ordered Quantity are changed',5);

1661: ELSIF P_New_Request_Date IS NOT NULL AND (P_Delta_Ordered_Qty IS NOT NULL
1662: OR p_Delta_Ordered_Qty <> 0) THEN
1663:
1664: IF l_debug_level > 0 THEN
1665: oe_debug_pub.add(' Both Request Date and Ordered Quantity are changed',5);
1666: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1667: END IF;
1668: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1669: Update_Allowed( p_Line_id => l_line_ids_rec.line_id

Line 1666: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);

1662: OR p_Delta_Ordered_Qty <> 0) THEN
1663:
1664: IF l_debug_level > 0 THEN
1665: oe_debug_pub.add(' Both Request Date and Ordered Quantity are changed',5);
1666: oe_debug_pub.add(' Check for update of Line_id '||l_line_ids_rec.line_id,5);
1667: END IF;
1668: IF NOT OE_Globals.Equal(P_New_Request_Date, l_line_ids_rec.request_date) AND
1669: Update_Allowed( p_Line_id => l_line_ids_rec.line_id
1670: , P_Attribute => 'ALL') THEN

Line 1688: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);

1684:
1685: l_Process_Line_Entity := TRUE;
1686: ELSE
1687: IF l_debug_level > 0 THEN
1688: oe_debug_pub.add(' Update is not allowed for this line. Setting the status to Error',5);
1689: END IF;
1690: l_return_status := FND_API.G_RET_STS_ERROR;
1691: END IF;
1692: END IF; -- P_New_Request_Date/P_Delta_Ordered_Qty

Line 1698: oe_debug_pub.add( ' Before calling Process_Line_Entity', 5 ) ;

1694: END IF; -- Update/Cancel Request
1695:
1696: IF l_Process_Line_Entity THEN
1697: IF l_debug_level > 0 THEN
1698: oe_debug_pub.add( ' Before calling Process_Line_Entity', 5 ) ;
1699: END IF;
1700:
1701: OE_MSG_PUB.set_msg_context
1702: ( p_entity_code => 'LINE'

Line 1724: oe_debug_pub.add( ' After calling Process_Line_Entity'||l_return_status, 5 ) ;

1720:
1721: OE_MSG_PUB.Reset_Msg_Context('LINE');
1722:
1723: IF l_debug_level > 0 THEN
1724: oe_debug_pub.add( ' After calling Process_Line_Entity'||l_return_status, 5 ) ;
1725: END IF;
1726: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1727: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1728: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 1740: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;

1736: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1737: P_Data => x_msg_Data);
1738:
1739: IF l_debug_level > 0 THEN
1740: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1741: END IF;
1742:
1743: Exception
1744: WHEN FND_API.G_EXC_ERROR THEN

Line 1761: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);

1757: G_Update_ISO_From_Req := FALSE; -- Confirming IR initiated change
1758: ROLLBACK TO Call_Process_Order_for_IReq;
1759:
1760: WHEN OTHERS THEN
1761: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1762: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1764: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1765: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');