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 FND_API

Line 124: l_return_status := FND_API.G_RET_STS_SUCCESS;

120: END IF;
121: END IF;
122: END IF;
123:
124: l_return_status := FND_API.G_RET_STS_SUCCESS;
125:
126: IF p_notify_for is NULL AND NOT P_cancel_order THEN
127: IF l_debug_level > 0 THEN
128: oe_debug_pub.add( ' RETURN. No notification will be send as nothing has updated on the requisition', 5);

Line 524: WHEN FND_API.G_EXC_ERROR 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
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:

Line 525: x_return_status := FND_API.G_RET_STS_ERROR;

521: END IF;
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

Line 529: WHEN FND_API.G_EXC_UNEXPECTED_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;
531: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
532: -- P_Data => x_msg_Data);
533:

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_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;
531: -- OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
532: -- P_Data => x_msg_Data);
533:
534: WHEN OTHERS THEN

Line 536: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
540: END IF;

Line 613: l_return_status := FND_API.G_RET_STS_SUCCESS;

609: oe_debug_pub.add( ' Not a line level cancellation',5);
610: END IF;
611: END IF;
612:
613: l_return_status := FND_API.G_RET_STS_SUCCESS;
614:
615: IF NOT P_Cancel_Line and NOT P_Cancel_Order
616: AND (P_Quantity_Change is null OR P_Quantity_Change = 0)
617: AND P_New_Schedule_Ship_Date is null THEN

Line 621: -- RAISE FND_API.G_EXC_ERROR;

617: AND P_New_Schedule_Ship_Date is null THEN
618: IF l_debug_level > 0 THEN
619: oe_debug_pub.add( ' Nothing to update on Requisition', 5 ) ;
620: END IF;
621: -- RAISE FND_API.G_EXC_ERROR;
622: x_return_status := l_return_status;
623: RETURN;
624: END IF;
625:

Line 665: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

661: IF l_debug_level > 0 THEN
662: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 1 ) ;
663: END IF;
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

Line 669: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 673: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
677: END IF;

Line 674: RAISE FND_API.G_EXC_ERROR;

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;
677: END IF;
678: END IF;

Line 675: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
677: END IF;
678: END IF;
679:

Line 676: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
677: END IF;
678: END IF;
679:
680: l_create_notification := TRUE;

Line 734: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

730: IF l_debug_level > 0 THEN
731: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqCancel_from_SO '||l_return_status, 5 ) ;
732: END IF;
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

Line 738: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
742: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 742: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
746: END IF;

Line 743: RAISE FND_API.G_EXC_ERROR;

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;
746: END IF;
747: END IF;

Line 744: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
746: END IF;
747: END IF;
748:

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
746: END IF;
747: END IF;
748:
749: L_change := 'C'; -- Line cancellation

Line 882: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

878: IF l_debug_level > 0 THEN
879: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Update_ReqChange_from_SO '||l_return_status, 1);
880: END IF;
881:
882: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
883: IF L_change = 'Q' THEN -- Q => Quantity
884: -- Ordered quantity, Supply picture, and corresponding internal
885: -- requisition line have been updated
886: g_reason := OE_GLOBALS.G_REASON_CODE;

Line 905: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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');
908: OE_MSG_PUB.Add;
909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 909: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
913: END IF;

Line 910: RAISE FND_API.G_EXC_ERROR;

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;
913: END IF;
914: END IF;

Line 911: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
913: END IF;
914: END IF;
915:

Line 912: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
913: END IF;
914: END IF;
915:
916: l_create_notification := TRUE;

Line 987: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add( ' After PO_RCO_Validation_GRP.Get_Preparer_Name '||l_return_status, 1 ) ;
985: END IF;
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

Line 991: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;
995: END IF;

Line 992: RAISE FND_API.G_EXC_ERROR;

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;
995: END IF;
996: END IF;

Line 993: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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;
995: END IF;
996: END IF;
997:

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
995: END IF;
996: END IF;
997:
998: IF l_preparer_name IS NULL THEN

Line 1022: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1018: , p_req_line_id => p_req_line_id
1019: , x_return_status => l_return_status
1020: );
1021:
1022: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;

Line 1023: RAISE FND_API.G_EXC_ERROR;

1019: , x_return_status => l_return_status
1020: );
1021:
1022: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:

Line 1024: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1020: );
1021:
1022: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:
1028: END IF;

Line 1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1021:
1022: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1023: RAISE FND_API.G_EXC_ERROR;
1024: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1025: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1026: END IF;
1027:
1028: END IF;
1029:

Line 1057: WHEN FND_API.G_EXC_ERROR 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
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:

Line 1058: x_return_status := FND_API.G_RET_STS_ERROR;

1054: END IF;
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

Line 1062: WHEN FND_API.G_EXC_UNEXPECTED_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;
1064: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1065: P_Data => x_msg_Data);
1066:

Line 1063: x_return_status := FND_API.G_RET_STS_UNEXP_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;
1064: OE_MSG_PUB.Count_And_Get (P_Count => x_msg_Count,
1065: P_Data => x_msg_Data);
1066:
1067: WHEN OTHERS THEN

Line 1069: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1073: END IF;