DBA Data[Home] [Help]

APPS.OE_INTERNAL_REQUISITION_PVT dependencies on FND_MESSAGE

Line 79: FND_Message.Set_Name('ONT', 'OE_IRCMS_NOT_ELIGIBLE');

75: WHEN NO_DATA_FOUND THEN
76: IF l_debug_level > 0 THEN
77: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment With No Data Found Error', 1 ) ;
78: END IF;
79: FND_Message.Set_Name('ONT', 'OE_IRCMS_NOT_ELIGIBLE');
80: -- There is no sales order line shipment eligible for update/cancellation.
81: OE_MSG_PUB.Add;
82: X_return_status := FND_API.G_RET_STS_ERROR;
83:

Line 88: FND_Message.Set_Name('ONT', 'OE_IRCMS_TOO_MANY_ROWS');

84: WHEN TOO_MANY_ROWS THEN
85: IF l_debug_level > 0 THEN
86: oe_debug_pub.add( ' EXITING Get_Eligible_ISO_Shipment with Too Many Rows error', 1 ) ;
87: END IF;
88: FND_Message.Set_Name('ONT', 'OE_IRCMS_TOO_MANY_ROWS');
89: -- There are multiple sales order line shipments eligible for update.
90: -- This is not allowed.
91: OE_MSG_PUB.Add;
92: X_return_status := FND_API.G_RET_STS_ERROR;

Line 578: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

574: IF P_internal_req_line_id is NULL THEN
575: IF l_debug_level > 0 THEN
576: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
577: END IF;
578: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
579: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');
580: OE_MSG_PUB.Add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;

Line 579: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');

575: IF l_debug_level > 0 THEN
576: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
577: END IF;
578: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
579: -- FND_Message.Set_Token('REQ_LIN_ID',' P_internal_req_line_id');
580: OE_MSG_PUB.Add;
581: RAISE FND_API.G_EXC_ERROR;
582: END IF;
583: IF P_internal_req_header_id is NULL THEN

Line 596: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');

592: where requisition_line_id = P_internal_req_line_id;
593:
594: IF l_req_hdr_id IS NULL THEN
595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
596: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
597: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
598: OE_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;

Line 597: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);

593:
594: IF l_req_hdr_id IS NULL THEN
595: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
596: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
597: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
598: OE_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_ERROR;
600: END IF;
601: Exception

Line 604: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

600: END IF;
601: Exception
602: When No_Data_Found Then
603: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
604: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
605: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
606: OE_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;
608: End;

Line 605: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);

601: Exception
602: When No_Data_Found Then
603: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
604: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
605: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
606: OE_MSG_PUB.Add;
607: RAISE FND_API.G_EXC_ERROR;
608: End;
609: ELSE

Line 739: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

735: IF P_internal_req_line_id is NULL THEN
736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
738: END IF;
739: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
740: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
741: OE_MSG_PUB.Add;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;

Line 740: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);

736: IF l_debug_level > 0 THEN
737: oe_debug_pub.add( ' Invalid value passed for Requisition Line',1);
738: END IF;
739: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
740: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
741: OE_MSG_PUB.Add;
742: RAISE FND_API.G_EXC_ERROR;
743: END IF;
744: IF P_internal_req_header_id is NULL THEN

Line 757: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');

753: where requisition_line_id = P_internal_req_line_id;
754:
755: IF l_req_hdr_id IS NULL THEN
756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
757: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
758: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
759: OE_MSG_PUB.Add;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;

Line 758: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);

754:
755: IF l_req_hdr_id IS NULL THEN
756: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
757: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
758: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
759: OE_MSG_PUB.Add;
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: Exception

Line 765: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

761: END IF;
762: Exception
763: When No_Data_Found Then
764: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
765: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
766: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
767: OE_MSG_PUB.Add;
768: RAISE FND_API.G_EXC_ERROR;
769: End;

Line 766: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);

762: Exception
763: When No_Data_Found Then
764: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
765: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
766: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
767: OE_MSG_PUB.Add;
768: RAISE FND_API.G_EXC_ERROR;
769: End;
770: ELSE

Line 826: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');

822: When No_Data_Found Then
823: IF l_debug_level > 0 THEN
824: oe_debug_pub.add( 'EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with No Data Found Error');
825: END IF;
826: FND_Message.Set_Name('ONT', 'OE_IRCMS_NO_HOLD_RELEASED');
827: -- There is no sales order line shipment on hold.
828: OE_MSG_PUB.Add;
829: X_return_status := FND_API.G_RET_STS_ERROR;
830:

Line 835: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');

831: When Too_Many_Rows Then
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add('EXITING OE_Internal_Requisition_Pvt.Release_Hold_for_Ireq with Too Many rows error') ;
834: END IF;
835: FND_Message.Set_Name('ONT', 'OE_IRCMS_MANY_HOLD');
836: -- There are many sales order line shipments eligible for hold release. This is not allowed.
837: OE_MSG_PUB.Add;
838: X_return_status := FND_API.G_RET_STS_ERROR;
839: End;

Line 954: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_INFO');

950: IF P_internal_req_header_id is NULL AND P_internal_req_line_id is NULL THEN
951: IF l_debug_level > 0 THEN
952: oe_debug_pub.add( ' Invalid value for Requisition Header/Line',1);
953: END IF;
954: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_INFO');
955: OE_MSG_PUB.Add;
956: RAISE FND_API.G_EXC_ERROR;
957: END IF;
958:

Line 1046: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');

1042: IF l_debug_level > 0 THEN
1043: oe_debug_pub.add( ' Invalid value for Requisition Header',1);
1044: END IF;
1045: X_Cancel_Allowed := FALSE;
1046: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1047: OE_MSG_PUB.Add;
1048: RAISE FND_API.G_EXC_ERROR;
1049: End;
1050: END IF;

Line 1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');

1061: where requisition_line_id = P_internal_req_line_id;
1062:
1063: IF l_req_hdr_id IS NULL THEN
1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1066: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1067: OE_MSG_PUB.Add;
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;

Line 1066: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);

1062:
1063: IF l_req_hdr_id IS NULL THEN
1064: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1065: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1066: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1067: OE_MSG_PUB.Add;
1068: RAISE FND_API.G_EXC_ERROR;
1069: END IF;
1070: Exception

Line 1073: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

1069: END IF;
1070: Exception
1071: When No_Data_Found Then
1072: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1073: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1074: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1075: OE_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_ERROR;
1077: End;

Line 1074: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);

1070: Exception
1071: When No_Data_Found Then
1072: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1073: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1074: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1075: OE_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_ERROR;
1077: End;
1078: ELSE

Line 1310: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');

1306: IF l_debug_level > 0 THEN
1307: oe_debug_pub.add( ' Invalid call to Order Management', 5 ) ;
1308: oe_debug_pub.add( ' Please provide a valid argument values', 5 ) ;
1309: END IF;
1310: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_OM_CALL');
1311: OE_MSG_PUB.Add;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314:

Line 1320: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');

1316: IF l_debug_level > 0 THEN
1317: oe_debug_pub.add( ' Mode is Invalid. The Valid values are V or P', 1 ) ;
1318: oe_debug_pub.add( ' Invalid Mode passed to Fulfillment Organization',5);
1319: END IF;
1320: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_MODE');
1321: OE_MSG_PUB.Add;
1322: RAISE FND_API.G_EXC_ERROR;
1323: END IF;
1324:

Line 1342: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');

1338: IF l_req_hdr_id IS NULL THEN
1339: IF l_debug_level > 0 THEN
1340: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1341: END IF;
1342: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1343: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1344: OE_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;

Line 1343: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);

1339: IF l_debug_level > 0 THEN
1340: oe_debug_pub.add( ' Invalid value for Requisition Header',5);
1341: END IF;
1342: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_HDR');
1343: -- FND_Message.Set_Token('REQ_HDR_ID',P_internal_req_header_id);
1344: OE_MSG_PUB.Add;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: Exception

Line 1352: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');

1348: When No_Data_Found Then
1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1351: END IF;
1352: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1353: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1354: OE_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;
1356: End;

Line 1353: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);

1349: IF l_debug_level > 0 THEN
1350: oe_debug_pub.add( ' Invalid value passed for Requisition Line',5);
1351: END IF;
1352: FND_Message.Set_Name('ONT', 'OE_IRCMS_INVALID_REQ_LIN');
1353: -- FND_Message.Set_Token('REQ_LIN_ID',P_internal_req_line_id);
1354: OE_MSG_PUB.Add;
1355: RAISE FND_API.G_EXC_ERROR;
1356: End;
1357: ELSE

Line 1382: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');

1378: WHEN No_Data_found THEN
1379: IF l_debug_level > 0 THEN
1380: oe_debug_pub.add( ' Invalid value passed for Requisition Header: no data found',1);
1381: END IF;
1382: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');
1383: RAISE FND_API.G_EXC_ERROR;
1384: WHEN Too_Many_Rows THEN
1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add( ' Invalid value passed for Requisition Header: too many rows',1);

Line 1388: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');

1384: WHEN Too_Many_Rows THEN
1385: IF l_debug_level > 0 THEN
1386: oe_debug_pub.add( ' Invalid value passed for Requisition Header: too many rows',1);
1387: END IF;
1388: FND_Message.Set_name('ONT','OE_IRCMS_INVALID_REQ_HDR');
1389: RAISE FND_API.G_EXC_ERROR;
1390: End;
1391:
1392: l_Cancel_Allowed := Cancel_Header_Allowed( P_header_id => l_order_header_id);