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.GMI_RESERVATION_PVT dependencies on FND_MSG_PUB

Line 300: FND_MSG_PUB.Add;

296: THEN
297: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
298: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_AppsUOM_from_OPMUOM');
299: FND_MESSAGE.Set_Token('WHERE', 'Query_Reservation');
300: FND_MSG_PUB.Add;
301: raise FND_API.G_EXC_ERROR;
302: END IF;
303: /* ============================================================================================= */
304: /* Validation for the query (private level) */

Line 323: FND_MSG_PUB.Add;

319: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_for_Query');
320: FND_MESSAGE.Set_Token('WHERE', 'Query_Reservation');
321: /* x_error_code := x_return_status ; */ /* Bug 2168710 */
322: x_return_status := FND_API.G_RET_STS_ERROR;
323: FND_MSG_PUB.Add;
324: raise FND_API.G_EXC_ERROR;
325: END IF;
326: END IF;
327:

Line 402: FND_MSG_PUB.count_and_get

398: WHEN FND_API.G_EXC_ERROR THEN
399: x_return_status := FND_API.G_RET_STS_ERROR;
400:
401: /* Get message count and data */
402: FND_MSG_PUB.count_and_get
403: ( p_count => x_msg_count
404: , p_data => x_msg_data
405: );
406:

Line 418: FND_MSG_PUB.Add;

414: FND_MESSAGE.Set_Name('GMI','GMI_SQL_ERROR');
415: FND_MESSAGE.Set_Token('WHERE', 'Query_Reservation');
416: FND_MESSAGE.Set_Token('SQL_CODE', SQLCODE);
417: FND_MESSAGE.Set_Token('SQL_ERRM', SQLERRM);
418: FND_MSG_PUB.Add;
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 422: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

418: FND_MSG_PUB.Add;
419: raise FND_API.G_EXC_ERROR;
420: END IF;
421:
422: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
423: , l_api_name
424: );
425:
426: /* Get message count and data */

Line 427: FND_MSG_PUB.count_and_get

423: , l_api_name
424: );
425:
426: /* Get message count and data */
427: FND_MSG_PUB.count_and_get
428: ( p_count => x_msg_count
429: , p_data => x_msg_data
430: );
431:

Line 568: FND_MSG_PUB.Add;

564: IF (p_rsv_rec.reservation_quantity = 0)
565: THEN
566: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Nothing to reserve.');
567: FND_MESSAGE.Set_Name('GMI','GMI_NOTHING_TO_RESERVE');
568: FND_MSG_PUB.Add;
569: RAISE FND_API.G_EXC_ERROR;
570: END IF;
571:
572: /* =============================================================================================*/

Line 600: FND_MSG_PUB.ADD;

596: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c: Error Returned by Query_Reservation.');
597: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
598: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_reservation_pub.Query_Reservation');
599: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
600: FND_MSG_PUB.ADD;
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603:
604: /* At this point the table ic_tran_rec_tbl should have rows*/

Line 624: FND_MSG_PUB.Add;

620: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Validation_Before_Allocate.');
621: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
622: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Validation_before_Allocate');
623: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
624: FND_MSG_PUB.Add;
625: RAISE FND_API.G_EXC_ERROR;
626: END IF;
627:
628:

Line 678: FND_MSG_PUB.Add;

674: THEN
675: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Cannot get default lot.');
676: FND_MESSAGE.Set_Name('GMI','SY_API_UNABLE_TO_GET_CONSTANT');
677: FND_MESSAGE.Set_Token('CONSTANT_NAME','IC$DEFAULT_LOCT');
678: FND_MSG_PUB.Add;
679: RAISE FND_API.G_EXC_ERROR;
680: END IF;
681:
682:

Line 696: FND_MSG_PUB.Add;

692: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Get_Default_Lot.');
693: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
694: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
695: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
696: FND_MSG_PUB.Add;
697: RAISE FND_API.G_EXC_ERROR;
698: END IF;
699:
700: /* =============================================================================================*/

Line 715: FND_MSG_PUB.Add;

711: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Lock_Inventory.');
712: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
713: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
714: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
715: FND_MSG_PUB.Add;
716: GMI_reservation_Util.PrintLn('return 1 in lock inventory');
717: RETURN;
718: -- RAISE FND_API.G_EXC_ERROR; Bug2516545
719: END IF;

Line 746: FND_MSG_PUB.Add;

742: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Create_Default_Lot.');
743: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
744: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Create_Default_Lot');
745: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
746: FND_MSG_PUB.Add;
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749:
750: ELSE

Line 785: FND_MSG_PUB.Add;

781: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
782: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
783: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
784: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
785: FND_MSG_PUB.Add;
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: /* =============================================================================================*/
789: /* Set the trans_id of the default transaction (passed as a parameter)*/

Line 824: FND_MSG_PUB.Add;

820: THEN
821: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : Customer is not synchronized. SO_line_id='||l_allocation_rec.line_id);
822: FND_MESSAGE.Set_Name('GML','GML_CUST_NOT_OPM_SYNCHRONIZED');
823: FND_MESSAGE.Set_Token('SO_LINE_ID', l_allocation_rec.line_id);
824: FND_MSG_PUB.Add;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;*/
827: /* End of Bug 1479751*/
828:

Line 850: FND_MSG_PUB.Add;

846: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Lock_Inventory.');
847: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
848: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Locks.Lock_Inventory');
849: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
850: FND_MSG_PUB.Add;
851: -- RAISE FND_API.G_EXC_ERROR; Bug2516545
852: GMI_reservation_Util.PrintLn('return 2 in lock inventory');
853: RETURN;
854: END IF;

Line 876: FND_MSG_PUB.Add;

872: GMI_reservation_Util.PrintLn('(opm_dbg) in end of PVT c ERROR:Returned by Allocate_Inventory.');
873: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
874: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Auto_Allocate_PUB.Allocate_Inventory');
875: FND_MESSAGE.Set_Token('WHERE', 'Create_Reservation');
876: FND_MSG_PUB.Add;
877: RAISE FND_API.G_EXC_ERROR;
878: END IF;
879: ELSE
880: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT c : Manual Allocation or HighLevelReservation: Only Default Lot.');

Line 905: FND_MSG_PUB.count_and_get

901: GMI_Reservation_Util.PrintLn('in end of PVT c ERROR.');
902: x_return_status := FND_API.G_RET_STS_ERROR;
903:
904: /* Get message count and data*/
905: FND_MSG_PUB.count_and_get
906: ( p_count => x_msg_count
907: , p_data => x_msg_data
908: );
909:

Line 914: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

910: WHEN OTHERS THEN
911: GMI_Reservation_Util.PrintLn('in end of PVT c ERROR:Other.');
912: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
913:
914: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
915: , l_api_name
916: );
917:
918: /* Get message count and data*/

Line 919: FND_MSG_PUB.count_and_get

915: , l_api_name
916: );
917:
918: /* Get message count and data*/
919: FND_MSG_PUB.count_and_get
920: ( p_count => x_msg_count
921: , p_data => x_msg_data
922: );
923:

Line 1022: FND_MSG_PUB.ADD;

1018: ,x_msg_data => x_msg_data);
1019: IF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u : Error Returned by Validation_before_Update');
1021: FND_MESSAGE.SET_NAME('GMI','ERROR_IN_VALIDATION_BEFORE_UPDATE');
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025: */
1026: GMI_reservation_Util.PrintLn('ATTRIBUTE2 => ' || p_to_rsv_rec.attribute2);

Line 1053: FND_MSG_PUB.ADD;

1049: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error No Rows Found in mtl_reservation');
1050: FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
1051: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1052: FND_MESSAGE.Set_Token('SO_LINE_ID', p_original_rsv_rec.demand_source_line_id);
1053: FND_MSG_PUB.ADD;
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056:
1057: /* There may have been a problem getting the rows*/

Line 1064: FND_MSG_PUB.ADD;

1060: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error Returned by Query_Reservation.');
1061: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1062: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_reservation_pub.Query_Reservation');
1063: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1064: FND_MSG_PUB.ADD;
1065: RAISE FND_API.G_EXC_ERROR;
1066: END IF;
1067:
1068: /* At this point the table should have rows*/

Line 1083: FND_MSG_PUB.ADD;

1079: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error Returned by Get_Default_Lot.');
1080: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1081: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
1082: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1083: FND_MSG_PUB.ADD;
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086:
1087: /* Populate local default row to hold values for comparision*/

Line 1114: FND_MSG_PUB.ADD;

1110: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error Returned by Get_Allocation.');
1111: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1112: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
1113: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1114: FND_MSG_PUB.ADD;
1115: RAISE FND_API.G_EXC_ERROR;
1116: END IF;
1117:
1118: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Not updating the default, save orig trans to local rec.');

Line 1165: FND_MSG_PUB.add;

1161: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error Returned by Get_OPMUOMfromAppsUOM ');
1162: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1163: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_OPMUOM_from_AppsUOM');
1164: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1165: FND_MSG_PUB.add;
1166: RAISE FND_API.G_EXC_ERROR;
1167: END IF;
1168:
1169: /* convert the new rsv qty to the item um qty*/

Line 1251: FND_MSG_PUB.Add;

1247: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1248: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1249: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1250: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1251: FND_MSG_PUB.Add;
1252: RAISE FND_API.G_EXC_ERROR;
1253: END IF;
1254:
1255: ELSE

Line 1284: FND_MSG_PUB.Add;

1280: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error returned by GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION.');
1281: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1282: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1283: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1284: FND_MSG_PUB.Add;
1285: RAISE FND_API.G_EXC_ERROR;
1286: END IF;
1287: ELSE
1288: /* --------------------------------------------------------------------*/

Line 1318: FND_MSG_PUB.Add;

1314: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: ERROR Returned by Delete_Transaction().');
1315: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1316: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
1317: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1318: FND_MSG_PUB.Add;
1319: RAISE FND_API.G_EXC_ERROR;
1320: END IF;
1321:
1322: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: After DELETE_PENDING_TRANSACTION.');

Line 1347: FND_MSG_PUB.Add;

1343: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: ERROR Returned by Update_Pending_Transaction updating the default record.');
1344: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1345: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1346: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1347: FND_MSG_PUB.Add;
1348: RAISE FND_API.G_EXC_ERROR;
1349: END IF;
1350: END IF;
1351: END IF;

Line 1381: /* FND_MSG_PUB.ADD;*/

1377: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Called Query_Reservation Received NoError No Rows Found in mtl_reservation');
1378: /* FND_MESSAGE.Set_Name('GMI','GMI_QRY_RSV_NOT_FOUND');*/
1379: /* FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');*/
1380: /* FND_MESSAGE.Set_Token('SO_LINE_ID', p_to_rsv_rec.demand_source_line_id);*/
1381: /* FND_MSG_PUB.ADD;*/
1382: /* RAISE FND_API.G_EXC_ERROR;*/
1383: END IF;
1384:
1385: /* There may have been a problem getting the rows*/

Line 1392: FND_MSG_PUB.ADD;

1388: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u: Error Returned by Query_Reservation.');
1389: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1390: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Query_Reservation');
1391: FND_MESSAGE.Set_Token('WHERE', 'Update_Reservation');
1392: FND_MSG_PUB.ADD;
1393: RAISE FND_API.G_EXC_ERROR;
1394: END IF;
1395:
1396:

Line 1404: FND_MSG_PUB.count_and_get

1400: WHEN FND_API.G_EXC_ERROR THEN
1401: x_return_status := FND_API.G_RET_STS_ERROR;
1402:
1403: /* Get message count and data*/
1404: FND_MSG_PUB.count_and_get
1405: ( p_count => x_msg_count
1406: , p_data => x_msg_data
1407: );
1408:

Line 1414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1410:
1411: WHEN OTHERS THEN
1412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1413:
1414: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1415: , l_api_name
1416: );
1417:
1418: /* Get message count and data*/

Line 1419: FND_MSG_PUB.count_and_get

1415: , l_api_name
1416: );
1417:
1418: /* Get message count and data*/
1419: FND_MSG_PUB.count_and_get
1420: ( p_count => x_msg_count
1421: , p_data => x_msg_data
1422: );
1423:

Line 1541: FND_MSG_PUB.Add;

1537: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: No records found to delete.');
1538: FND_MESSAGE.Set_name('GMI','GMI_ERROR');
1539: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Query_Reservation');
1540: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1541: FND_MSG_PUB.Add;
1542: RAISE FND_API.G_EXC_ERROR;
1543: END IF;
1544:
1545: GMI_Reservation_Util.Get_Default_Lot(

Line 1557: FND_MSG_PUB.Add;

1553: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: No records found to delete.');
1554: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1555: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Default_Lot');
1556: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1557: FND_MSG_PUB.Add;
1558: RAISE FND_API.G_EXC_ERROR;
1559: END IF;
1560:
1561: /* Find the matching ic_tran_rec_tbl record for the rsv_rec passed in*/

Line 1581: FND_MSG_PUB.Add;

1577: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Get_Allocation().');
1578: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1579: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Get_Allocation');
1580: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1581: FND_MSG_PUB.Add;
1582: RAISE FND_API.G_EXC_ERROR;
1583: END IF;
1584:
1585: /* added the following condition for OM changes when org id is changed

Line 1615: FND_MSG_PUB.Add;

1611: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Delete_Transaction().');
1612: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1613: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.DELETE_PENDING_TRANSACTION');
1614: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: END IF;

Line 1636: FND_MSG_PUB.Add;

1632: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
1633: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1634: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1635: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1636: FND_MSG_PUB.Add;
1637: RAISE FND_API.G_EXC_ERROR;
1638: END IF;
1639: ELSE
1640:

Line 1673: FND_MSG_PUB.Add;

1669: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Balancing the default record.');
1670: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1671: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_RESERVATION_UTIL.balance_default_lot');
1672: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1673: FND_MSG_PUB.Add;
1674: RAISE FND_API.G_EXC_ERROR;
1675: END IF;
1676:
1677: ELSE

Line 1698: FND_MSG_PUB.Add;

1694: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d ERROR: Returned by Update_Transaction() updating the default record.');
1695: FND_MESSAGE.Set_Name('GMI','GMI_ERROR');
1696: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_TRANS_ENGINE_PUB.UPDATE_PENDING_TRANSACTION');
1697: FND_MESSAGE.Set_Token('WHERE', 'Delete_Reservation');
1698: FND_MSG_PUB.Add;
1699: RAISE FND_API.G_EXC_ERROR;
1700: END IF;
1701: END IF;
1702: -- End Bug3248046

Line 1723: FND_MSG_PUB.count_and_get

1719: WHEN FND_API.G_EXC_ERROR THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721:
1722: /* Get message count and data*/
1723: FND_MSG_PUB.count_and_get
1724: ( p_count => x_msg_count
1725: , p_data => x_msg_data
1726: );
1727: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT d EXCEPTION: Expected');

Line 1732: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

1728:
1729: WHEN OTHERS THEN
1730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1731:
1732: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1733: , l_api_name
1734: );
1735:
1736: /* Get message count and data*/

Line 1737: FND_MSG_PUB.count_and_get

1733: , l_api_name
1734: );
1735:
1736: /* Get message count and data*/
1737: FND_MSG_PUB.count_and_get
1738: ( p_count => x_msg_count
1739: , p_data => x_msg_data
1740: );
1741:

Line 1811: FND_MSG_PUB.count_and_get

1807: WHEN fnd_api.g_exc_error THEN
1808: x_return_status := fnd_api.g_ret_sts_error;
1809:
1810: /* Get message count and data*/
1811: FND_MSG_PUB.count_and_get
1812: ( p_count => x_msg_count
1813: , p_data => x_msg_data
1814: );
1815:

Line 2420: FND_MSG_PUB.count_and_get

2416: CLOSE c_get_wsh_released_status;
2417: END IF;
2418:
2419: /* Get message count and data*/
2420: FND_MSG_PUB.count_and_get
2421: ( p_count => x_msg_count
2422: , p_data => x_msg_data
2423: );
2424:

Line 2433: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2429: IF c_get_wsh_released_status%ISOPEN THEN
2430: CLOSE c_get_wsh_released_status;
2431: END IF;
2432:
2433: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2434: , l_api_name
2435: );
2436:
2437: /* Get message count and data*/

Line 2438: FND_MSG_PUB.count_and_get

2434: , l_api_name
2435: );
2436:
2437: /* Get message count and data*/
2438: FND_MSG_PUB.count_and_get
2439: ( p_count => x_msg_count
2440: , p_data => x_msg_data
2441: );
2442:

Line 2759: FND_MSG_PUB.Add;

2755: CLOSE get_item_ctl;
2756: GMI_RESERVATION_UTIL.PrintLn('Error retrieving item details');
2757: FND_MESSAGE.Set_Name('GMI','GMI_API_ITEM_NOT_FOUND');
2758: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_organization_id);
2759: FND_MSG_PUB.Add;
2760: RAISE FND_API.G_EXC_ERROR;
2761: ELSE
2762: CLOSE get_item_ctl;
2763: END IF;

Line 2775: FND_MSG_PUB.Add;

2771: GMI_RESERVATION_UTIL.PrintLn('Error retrieving whse code');
2772: FND_MESSAGE.SET_NAME('GMI','GMI_API_WHSE_NOT_FOUND');
2773: FND_MESSAGE.SET_TOKEN('ORG', p_organization_id);
2774: FND_MESSAGE.SET_TOKEN('LINE_ID', p_demand_source_line_id);
2775: FND_MSG_PUB.Add;
2776: RAISE FND_API.G_EXC_ERROR;
2777: ELSE
2778: CLOSE get_whse_code;
2779: END IF;

Line 2843: FND_MSG_PUB.Add_Exc_Msg (

2839: WHEN FND_API.G_EXC_ERROR THEN
2840: x_return_status := FND_API.G_RET_STS_ERROR;
2841:
2842: GMI_RESERVATION_UTIL.PrintLn('Exeption GMI_Reservation_PVT.calculate_prior_reservations');
2843: FND_MSG_PUB.Add_Exc_Msg (
2844: G_PKG_NAME
2845: , l_api_name);
2846:
2847: /* Get message count and data */

Line 2848: FND_MSG_PUB.count_and_get (

2844: G_PKG_NAME
2845: , l_api_name);
2846:
2847: /* Get message count and data */
2848: FND_MSG_PUB.count_and_get (
2849: p_count => x_msg_count
2850: , p_data => x_msg_data);
2851:
2852: WHEN NO_DATA_FOUND THEN

Line 2856: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2852: WHEN NO_DATA_FOUND THEN
2853: x_return_status := FND_API.G_RET_STS_ERROR;
2854: GMI_RESERVATION_UTIL.PrintLn('No Data found Exception GMI_Reservation_PVT.calculate_prior_reservations');
2855:
2856: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2857: , l_api_name);
2858:
2859: /* Get message count and data */
2860: FND_MSG_PUB.count_and_get

Line 2860: FND_MSG_PUB.count_and_get

2856: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2857: , l_api_name);
2858:
2859: /* Get message count and data */
2860: FND_MSG_PUB.count_and_get
2861: ( p_count => x_msg_count
2862: , p_data => x_msg_data);
2863:
2864: WHEN OTHERS THEN

Line 2869: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

2865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2866:
2867: GMI_RESERVATION_UTIL.PrintLn('OTHERS Exception GMI_Reservation_PVT.calculate_prior_reservations');
2868:
2869: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2870: , l_api_name);
2871:
2872: /* Get message count and data */
2873: FND_MSG_PUB.count_and_get (

Line 2873: FND_MSG_PUB.count_and_get (

2869: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
2870: , l_api_name);
2871:
2872: /* Get message count and data */
2873: FND_MSG_PUB.count_and_get (
2874: p_count => x_msg_count
2875: , p_data => x_msg_data);
2876:
2877: END calculate_prior_reservations;