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_MSG_PUB

Line 516: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

512: END IF;
513:
514: x_return_status := l_return_status;
515:
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 ) ;

Line 526: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

522:
523: Exception
524: WHEN FND_API.G_EXC_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
527: -- P_Data => x_msg_Data);
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 531: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

527: -- P_Data => x_msg_Data);
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 537: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
540: END IF;
541: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 538: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Prepare_Notification');

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
540: END IF;
541: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
542: -- P_Data => x_msg_Data);

Line 541: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

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:
544: End Prepare_Notification;
545:

Line 668: OE_MSG_PUB.Add;

664:
665: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
666: -- Sales order and corresponding internal requisition has been cancelled
667: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_CANCEL');
668: OE_MSG_PUB.Add;
669: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
671: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
672: OE_MSG_PUB.Add;

Line 672: OE_MSG_PUB.Add;

668: OE_MSG_PUB.Add;
669: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
670: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
671: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
672: OE_MSG_PUB.Add;
673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
674: RAISE FND_API.G_EXC_ERROR;
675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 737: OE_MSG_PUB.Add;

733:
734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
735: -- Sales order and corresponding internal requisition line has been cancelled
736: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_LIN_CANCEL');
737: OE_MSG_PUB.Add;
738: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
740: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
741: OE_MSG_PUB.Add;

Line 741: OE_MSG_PUB.Add;

737: OE_MSG_PUB.Add;
738: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
739: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
740: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
741: OE_MSG_PUB.Add;
742: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
743: RAISE FND_API.G_EXC_ERROR;
744: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 889: OE_MSG_PUB.Add;

885: -- requisition line have been updated
886: g_reason := OE_GLOBALS.G_REASON_CODE;
887: -- 'OE_GLOBALS.G_REASON_COMMENTS'
888: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_UDPATE');
889: OE_MSG_PUB.Add;
890: ELSIF L_change = 'D' THEN -- D => Date
891: -- Schedule Ship/Arrival date and corresponding internal
892: -- requisition line have been updated
893: g_reason := OE_GLOBALS.G_REASON_CODE;

Line 896: OE_MSG_PUB.Add;

892: -- requisition line have been updated
893: g_reason := OE_GLOBALS.G_REASON_CODE;
894: -- 'OE_GLOBALS.G_REASON_COMMENTS'
895: FND_Message.Set_Name('ONT', 'OE_IRCMS_DATE_UDPATE');
896: OE_MSG_PUB.Add;
897: ELSIF L_change = 'B' THEN -- B => Both Date and Quantity
898: -- Schedule Ship/Arrival date, Ordered quantity, Supply picture,
899: -- and corresponding internal requisition line have been updated
900: g_reason := OE_GLOBALS.G_REASON_CODE;

Line 903: OE_MSG_PUB.Add;

899: -- and corresponding internal requisition line have been updated
900: g_reason := OE_GLOBALS.G_REASON_CODE;
901: -- 'OE_GLOBALS.G_REASON_COMMENTS'
902: FND_Message.Set_Name('ONT', 'OE_IRCMS_QTY_DATE_UDPATE');
903: OE_MSG_PUB.Add;
904: END IF;
905: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
907: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');

Line 908: OE_MSG_PUB.Add;

904: END IF;
905: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
906: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
907: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
908: OE_MSG_PUB.Add;
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
910: RAISE FND_API.G_EXC_ERROR;
911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 990: OE_MSG_PUB.Add;

986:
987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
988: -- Unable to save the changes as the corresponding Internal Requisition can not be updated
989: FND_Message.Set_Name('ONT', 'OE_IRCMS_REQ_FAIL');
990: OE_MSG_PUB.Add;
991: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
992: RAISE FND_API.G_EXC_ERROR;
993: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1049: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1045: g_reason := NULL;
1046:
1047: x_return_status := l_return_status;
1048:
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 ) ;

Line 1059: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1055:
1056: Exception
1057: WHEN FND_API.G_EXC_ERROR THEN
1058: x_return_status := FND_API.G_RET_STS_ERROR;
1059: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1060: P_Data => x_msg_Data);
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1064: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

1060: P_Data => x_msg_Data);
1061:
1062: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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);

Line 1070: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
1073: END IF;
1074: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

Line 1071: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'Update_Internal_Requisition');

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
1073: END IF;
1074: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1075: P_Data => x_msg_Data);

Line 1074: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,

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:
1077: End Update_Internal_Requisition;
1078: