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_PROCESS_REQUISITION_PVT dependencies on OE_PROCESS_REQUISITION_PVT

Line 1: PACKAGE BODY OE_PROCESS_REQUISITION_PVT AS

1: PACKAGE BODY OE_PROCESS_REQUISITION_PVT AS
2: /* $Header: OEXVPIRB.pls 120.7.12020000.2 2012/09/14 08:09:56 rahujain ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_PROCESS_REQUISITION_PVT';

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

1: PACKAGE BODY OE_PROCESS_REQUISITION_PVT AS
2: /* $Header: OEXVPIRB.pls 120.7.12020000.2 2012/09/14 08:09:56 rahujain ship $ */
3:
4: -- Global constant holding the package name
5: G_PKG_Name CONSTANT VARCHAR2(30) := 'OE_PROCESS_REQUISITION_PVT';
6:
7: g_requisition_number VARCHAR2(20);
8: g_requisition_line_number NUMBER;
9: g_need_by_date DATE;

Line 108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;

104:
105: Begin
106:
107: IF l_debug_level > 0 THEN
108: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
109: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
110: oe_debug_pub.add( ' P_Line_id_tbl Count :'||P_Line_id_tbl.count , 5 ) ;
111: oe_debug_pub.add( ' P_performer :'||p_performer,5);
112: oe_debug_pub.add( ' p_notify_for :'||p_notify_for,5);

Line 550: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;

546: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
547: -- P_Data => x_msg_Data);
548:
549: IF l_debug_level > 0 THEN
550: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
551: END IF;
552:
553: Exception
554: WHEN FND_API.G_EXC_ERROR THEN

Line 565: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);

561: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
562: -- P_Data => x_msg_Data);
563:
564: WHEN OTHERS THEN
565: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
569: -- Pkg Body global variable = OE_Process_Requisition_Pvt

Line 569: -- Pkg Body global variable = OE_Process_Requisition_Pvt

565: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
567: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
568: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
569: -- Pkg Body global variable = OE_Process_Requisition_Pvt
570: END IF;
571: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
572: -- P_Data => x_msg_Data);
573:

Line 639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;

635:
636: Begin
637:
638: IF l_debug_level > 0 THEN
639: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
640: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
641: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
642: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
643: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

Line 1159: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;

1155: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1156: P_Data => x_msg_Data);
1157:
1158: IF l_debug_level > 0 THEN
1159: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
1160: END IF;
1161:
1162: Exception
1163: WHEN FND_API.G_EXC_ERROR THEN

Line 1174: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);

1170: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1171: P_Data => x_msg_Data);
1172:
1173: WHEN OTHERS THEN
1174: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1177: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1178: -- Pkg Body global variable = OE_Process_Requisition_Pvt

Line 1178: -- Pkg Body global variable = OE_Process_Requisition_Pvt

1174: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1176: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1177: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1178: -- Pkg Body global variable = OE_Process_Requisition_Pvt
1179: END IF;
1180: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1181: P_Data => x_msg_Data);
1182:

Line 1185: END OE_PROCESS_REQUISITION_PVT;

1181: P_Data => x_msg_Data);
1182:
1183: End Update_Internal_Requisition;
1184:
1185: END OE_PROCESS_REQUISITION_PVT;