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.0.12010000.3 2008/11/24 05:54:39 vbkapoor noship $ */
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.0.12010000.3 2008/11/24 05:54:39 vbkapoor noship $ */
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 106: oe_debug_pub.add( ' ENTERING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;

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

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

516: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
517: -- P_Data => x_msg_Data);
518:
519: IF l_debug_level > 0 THEN
520: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Prepare_Notification', 1 ) ;
521: END IF;
522:
523: Exception
524: WHEN FND_API.G_EXC_ERROR THEN

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

531: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
532: -- P_Data => x_msg_Data);
533:
534: WHEN OTHERS THEN
535: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
538: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
539: -- Pkg Body global variable = OE_Process_Requisition_Pvt

Line 539: -- Pkg Body global variable = OE_Process_Requisition_Pvt

535: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Prepare_Notification '||sqlerrm,1);
536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
538: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');
539: -- Pkg Body global variable = OE_Process_Requisition_Pvt
540: END IF;
541: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
542: -- P_Data => x_msg_Data);
543:

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

589:
590: Begin
591:
592: IF l_debug_level > 0 THEN
593: oe_debug_pub.add( 'ENTERING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
594: oe_debug_pub.add( ' P_Header_id :'||P_Header_id , 5 ) ;
595: oe_debug_pub.add( ' P_Line_id :'||P_Line_id , 5 ) ;
596: oe_debug_pub.add( ' P_Num_Records :'||p_num_records,5);
597: oe_debug_pub.add( ' P_Req_Header_id :'||P_Req_Header_id , 5 ) ;

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

1049: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1050: P_Data => x_msg_Data);
1051:
1052: IF l_debug_level > 0 THEN
1053: oe_debug_pub.add( 'EXITING OE_Process_Requisition_Pvt.Update_Internal_Requisition', 1 ) ;
1054: END IF;
1055:
1056: Exception
1057: WHEN FND_API.G_EXC_ERROR THEN

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

1064: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1065: P_Data => x_msg_Data);
1066:
1067: WHEN OTHERS THEN
1068: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1071: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1072: -- Pkg Body global variable = OE_Process_Requisition_Pvt

Line 1072: -- Pkg Body global variable = OE_Process_Requisition_Pvt

1068: oe_debug_pub.add( ' When Others of OE_Process_Requisition_Pvt.Update_Internal_Requisition '||sqlerrm,1);
1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1071: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');
1072: -- Pkg Body global variable = OE_Process_Requisition_Pvt
1073: END IF;
1074: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1075: P_Data => x_msg_Data);
1076:

Line 1079: END OE_PROCESS_REQUISITION_PVT;

1075: P_Data => x_msg_Data);
1076:
1077: End Update_Internal_Requisition;
1078:
1079: END OE_PROCESS_REQUISITION_PVT;