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_INTERNAL_REQUISITION_PVT

Line 1: PACKAGE BODY OE_INTERNAL_REQUISITION_PVT AS

1: PACKAGE BODY OE_INTERNAL_REQUISITION_PVT AS
2: /* $Header: OEXVIRQB.pls 120.5.12020000.2 2012/07/03 10:24:38 amallik ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_INTERNAL_REQUISITION_PVT';

Line 5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_INTERNAL_REQUISITION_PVT';

1: PACKAGE BODY OE_INTERNAL_REQUISITION_PVT AS
2: /* $Header: OEXVIRQB.pls 120.5.12020000.2 2012/07/03 10:24:38 amallik ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_INTERNAL_REQUISITION_PVT';
6:
7: -- Added for 8583903
8: g_fnd_debug CONSTANT VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
9:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 350: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

346: WHEN OTHERS THEN
347: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Allowed '||sqlerrm,1);
348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Allowed');
350: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
351: END IF;
352: RETURN FALSE;
353: End Cancel_Allowed;
354:

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

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

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

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

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

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

Line 411: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

407: WHEN OTHERS THEN
408: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Cancel_Header_Allowed '||sqlerrm,1);
409: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
410: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Cancel_Header_Allowed');
411: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
412: END IF;
413: RETURN FALSE;
414: End Cancel_Header_Allowed;
415:

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

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

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

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

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

581:
582: SavePoint Apply_Hold_For_IReq;
583:
584: IF l_debug_level > 0 THEN
585: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
586: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
587: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
588: END IF;
589:

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

675: P_Count => x_msg_Count,
676: P_Data => x_msg_Data);
677:
678: IF l_debug_level > 0 THEN
679: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq', 1 ) ;
680: END IF;
681:
682: -- Added for 8583903
683: oe_debug_pub.debug_off;

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

710: oe_Debug_pub.setdebuglevel(0);
711: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
712:
713: WHEN OTHERS THEN
714: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Apply_Hold_for_IReq '||sqlerrm,1);
715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');

Line 719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

715: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
716: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
717: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
718: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Apply_Hold_for_IReq');
719: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
720: END IF;
721: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
722: P_Count => x_msg_Count,
723: P_Data => x_msg_Data);

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

786:
787: SavePoint Release_Hold_For_IReq;
788:
789: IF l_debug_level > 0 THEN
790: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
791: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
792: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
793: END IF;
794:

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

888:
889: Exception
890: When No_Data_Found Then
891: IF l_debug_level > 0 THEN
892: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');
893: END IF;
894: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');
895: -- There is no sales order line shipment on hold.
896: OE_MSG_PUB.Add;

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

897: X_return_status := FND_API.G_RET_STS_ERROR;
898:
899: When Too_Many_Rows Then
900: IF l_debug_level > 0 THEN
901: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;
902: END IF;
903: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');
904: -- There are many sales order line shipments eligible for hold release. This is not allowed.
905: OE_MSG_PUB.Add;

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

916: P_Count => x_msg_Count,
917: P_Data => x_msg_Data);
918:
919: IF l_debug_level > 0 THEN
920: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_IReq', 1 ) ;
921: END IF;
922:
923: -- Added for 8583903
924: oe_debug_pub.debug_off;

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

953: oe_Debug_pub.setdebuglevel(0);
954: OE_GLOBALS.G_SYS_HOLD := FALSE; -- bug 9494397
955:
956: WHEN OTHERS THEN
957: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Release_Hold_for_IReq '||sqlerrm,1);
958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');

Line 962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

958: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
961: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Release_Hold_for_IReq');
962: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
963: END IF;
964: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
965: P_Count => x_msg_Count,
966: P_Data => x_msg_Data);

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

1044: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
1045: END IF;
1046:
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
1049: oe_debug_pub.add( ' Requisition Line id :'||P_internal_req_line_id , 5 ) ;
1050: oe_debug_pub.add( ' Requisition Header id :'||P_internal_req_header_id , 5) ;
1051: END IF;
1052:

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

1263: P_Count => x_msg_Count,
1264: P_Data => x_msg_Data);
1265:
1266: IF l_debug_level > 0 THEN
1267: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Is_IReq_Changable', 1 ) ;
1268: END IF;
1269:
1270: -- Added for 8583903
1271: oe_debug_pub.debug_off;

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

1298: oe_debug_pub.debug_off;
1299: oe_Debug_pub.setdebuglevel(0);
1300:
1301: WHEN OTHERS THEN
1302: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Is_IReq_Changable '||sqlerrm,1);
1303: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1305: X_Update_Allowed := FALSE;
1306: X_Cancel_Allowed := FALSE;

Line 1309: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

1305: X_Update_Allowed := FALSE;
1306: X_Cancel_Allowed := FALSE;
1307: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1308: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Is_IReq_Changable');
1309: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1310: END IF;
1311: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1312: P_Count => x_msg_Count,
1313: P_Data => x_msg_Data);

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

1414:
1415: SavePoint Call_Process_Order_for_IReq;
1416:
1417: IF l_debug_level > 0 THEN
1418: oe_debug_pub.add( 'ENTERING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1419: oe_debug_pub.add( ' P_internal_req_line_id :'||P_internal_req_line_id , 5 ) ;
1420: oe_debug_pub.add( ' P_internal_req_header_id :'||P_internal_req_header_id , 5 ) ;
1421: oe_debug_pub.add( ' P_Mode :'||P_Mode , 5 ) ;
1422: oe_debug_pub.add( ' P_New_Request_Date :'||P_New_Request_Date , 5 ) ;

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

1888: P_Count => x_msg_Count,
1889: P_Data => x_msg_Data);
1890:
1891: IF l_debug_level > 0 THEN
1892: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq', 1 ) ;
1893: END IF;
1894:
1895: -- Added for 8583903
1896: oe_debug_pub.debug_off;

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

1923: oe_debug_pub.debug_off;
1924: oe_Debug_pub.setdebuglevel(0);
1925:
1926: WHEN OTHERS THEN
1927: oe_debug_pub.add( ' When Others of OE_Internal_Requisition_Pvt.Call_Process_Order_for_IReq '||sqlerrm,1);
1928: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');

Line 1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'

1928: -- OE_MSG_PUB.Reset_Msg_Context('LINE');
1929: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1930: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1931: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Call_Process_Order_for_IReq');
1932: -- Pkg Body global variable = 'OE_internal_Requisition_Pvt'
1933: END IF;
1934: OE_MSG_PUB.Count_And_Get (P_encoded =>'F', --added for bug 13992154
1935: P_Count => x_msg_Count,
1936: P_Data => x_msg_Data);

Line 1946: END OE_INTERNAL_REQUISITION_PVT;

1942: oe_Debug_pub.setdebuglevel(0);
1943:
1944: End Call_Process_Order_for_IReq;
1945:
1946: END OE_INTERNAL_REQUISITION_PVT;