87: RAISE fnd_api.g_exc_unexpected_error;
88: END IF;
89: -- Initialize message list.
90: IF fnd_api.to_boolean(p_init_msg_lst) THEN
91: fnd_msg_pub.initialize;
92: END IF;
93: -- reservation id is not decided yet
94: l_rsv_rec.reservation_id := NULL;
95: l_rsv_rec.requirement_date := p_requirement_date;
180: WHEN fnd_api.g_exc_error THEN
181: x_return_status := fnd_api.g_ret_sts_error;
182:
183: -- Get message count and data
184: fnd_msg_pub.count_and_get
185: ( p_count => x_msg_count
186: , p_data => x_msg_data
187: , p_encoded => 'F'
188: );
190: WHEN fnd_api.g_exc_unexpected_error THEN
191: x_return_status := fnd_api.g_ret_sts_unexp_error ;
192:
193: -- Get message count and data
194: fnd_msg_pub.count_and_get
195: ( p_count => x_msg_count
196: , p_data => x_msg_data
197: , p_encoded => 'F'
198: );
199:
200: WHEN OTHERS THEN
201: x_return_status := fnd_api.g_ret_sts_unexp_error ;
202:
203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
204: THEN
205: fnd_msg_pub.add_exc_msg
206: ( g_pkg_name
207: , l_api_name
201: x_return_status := fnd_api.g_ret_sts_unexp_error ;
202:
203: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
204: THEN
205: fnd_msg_pub.add_exc_msg
206: ( g_pkg_name
207: , l_api_name
208: );
209: END IF;
208: );
209: END IF;
210:
211: -- Get message count and data
212: fnd_msg_pub.count_and_get
213: ( p_count => x_msg_count
214: , p_data => x_msg_data
215: , p_encoded => 'F'
216: );
293: RAISE fnd_api.g_exc_unexpected_error;
294: END IF;
295: -- Initialize message list.
296: IF fnd_api.to_boolean(p_init_msg_lst) THEN
297: fnd_msg_pub.initialize;
298: END IF;
299:
300: -- Call the over loaded function
301: Create_reservation (
379: WHEN fnd_api.g_exc_error THEN
380: x_return_status := fnd_api.g_ret_sts_error;
381:
382: -- Get message count and data
383: fnd_msg_pub.count_and_get
384: ( p_count => x_msg_count
385: , p_data => x_msg_data
386: , p_encoded => 'F'
387: );
389: WHEN fnd_api.g_exc_unexpected_error THEN
390: x_return_status := fnd_api.g_ret_sts_unexp_error ;
391:
392: -- Get message count and data
393: fnd_msg_pub.count_and_get
394: ( p_count => x_msg_count
395: , p_data => x_msg_data
396: , p_encoded => 'F'
397: );
398:
399: WHEN OTHERS THEN
400: x_return_status := fnd_api.g_ret_sts_unexp_error ;
401:
402: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
403: THEN
404: fnd_msg_pub.add_exc_msg
405: ( g_pkg_name
406: , l_api_name
400: x_return_status := fnd_api.g_ret_sts_unexp_error ;
401:
402: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
403: THEN
404: fnd_msg_pub.add_exc_msg
405: ( g_pkg_name
406: , l_api_name
407: );
408: END IF;
407: );
408: END IF;
409:
410: -- Get message count and data
411: fnd_msg_pub.count_and_get
412: ( p_count => x_msg_count
413: , p_data => x_msg_data
414: , p_encoded => 'F'
415: );
555: END IF;
556:
557: -- Initialize message list.
558: IF fnd_api.to_boolean(p_init_msg_lst) THEN
559: fnd_msg_pub.initialize;
560: END IF;
561:
562: -- construct the record type for the original reservation
563: l_orig_rsv_rec.reservation_id := p_from_reservation_id;
706: WHEN fnd_api.g_exc_error THEN
707: x_return_status := fnd_api.g_ret_sts_error;
708:
709: -- Get message count and data
710: fnd_msg_pub.count_and_get
711: ( p_count => x_msg_count
712: , p_data => x_msg_data
713: , p_encoded => 'F'
714: );
716: WHEN fnd_api.g_exc_unexpected_error THEN
717: x_return_status := fnd_api.g_ret_sts_unexp_error ;
718:
719: -- Get message count and data
720: fnd_msg_pub.count_and_get
721: ( p_count => x_msg_count
722: , p_data => x_msg_data
723: , p_encoded => 'F'
724: );
725:
726: WHEN OTHERS THEN
727: x_return_status := fnd_api.g_ret_sts_unexp_error ;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
730: THEN
731: fnd_msg_pub.add_exc_msg
732: ( g_pkg_name
733: , l_api_name
727: x_return_status := fnd_api.g_ret_sts_unexp_error ;
728:
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
730: THEN
731: fnd_msg_pub.add_exc_msg
732: ( g_pkg_name
733: , l_api_name
734: );
735: END IF;
734: );
735: END IF;
736:
737: -- Get message count and data
738: fnd_msg_pub.count_and_get
739: ( p_count => x_msg_count
740: , p_data => x_msg_data
741: , p_encoded => 'F'
742: );
822: END IF;
823:
824: -- Initialize message list.
825: IF fnd_api.to_boolean(p_init_msg_lst) THEN
826: fnd_msg_pub.initialize;
827: END IF;
828:
829: l_rsv_rec.reservation_id := p_reservation_id;
830: l_rsv_rec.requirement_date := p_requirement_date;
906: WHEN fnd_api.g_exc_error THEN
907: x_return_status := fnd_api.g_ret_sts_error;
908:
909: -- Get message count and data
910: fnd_msg_pub.count_and_get
911: ( p_count => x_msg_count
912: , p_data => x_msg_data
913: , p_encoded => 'F'
914: );
916: WHEN fnd_api.g_exc_unexpected_error THEN
917: x_return_status := fnd_api.g_ret_sts_unexp_error ;
918:
919: -- Get message count and data
920: fnd_msg_pub.count_and_get
921: ( p_count => x_msg_count
922: , p_data => x_msg_data
923: , p_encoded => 'F'
924: );
925:
926: WHEN OTHERS THEN
927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
928:
929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
930: THEN
931: fnd_msg_pub.add_exc_msg
932: ( g_pkg_name
933: , l_api_name
927: x_return_status := fnd_api.g_ret_sts_unexp_error ;
928:
929: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
930: THEN
931: fnd_msg_pub.add_exc_msg
932: ( g_pkg_name
933: , l_api_name
934: );
935: END IF;
934: );
935: END IF;
936:
937: -- Get message count and data
938: fnd_msg_pub.count_and_get
939: ( p_count => x_msg_count
940: , p_data => x_msg_data
941: , p_encoded => 'F'
942: );
1040: END IF;
1041:
1042: -- Initialize message list.
1043: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1044: fnd_msg_pub.initialize;
1045: END IF;
1046:
1047: -- construct the record type for the original reservation
1048: IF p_from_reservation_id IS NOT NULL
1151: WHEN fnd_api.g_exc_error THEN
1152: x_return_status := fnd_api.g_ret_sts_error;
1153:
1154: -- Get message count and data
1155: fnd_msg_pub.count_and_get
1156: ( p_count => x_msg_count
1157: , p_data => x_msg_data
1158: , p_encoded => 'F'
1159: );
1161: WHEN fnd_api.g_exc_unexpected_error THEN
1162: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1163:
1164: -- Get message count and data
1165: fnd_msg_pub.count_and_get
1166: ( p_count => x_msg_count
1167: , p_data => x_msg_data
1168: , p_encoded => 'F'
1169: );
1170:
1171: WHEN OTHERS THEN
1172: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1173:
1174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1175: THEN
1176: fnd_msg_pub.add_exc_msg
1177: ( g_pkg_name
1178: , l_api_name
1172: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1173:
1174: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1175: THEN
1176: fnd_msg_pub.add_exc_msg
1177: ( g_pkg_name
1178: , l_api_name
1179: );
1180: END IF;
1179: );
1180: END IF;
1181:
1182: -- Get message count and data
1183: fnd_msg_pub.count_and_get
1184: ( p_count => x_msg_count
1185: , p_data => x_msg_data
1186: , p_encoded => 'F'
1187: );
1281: END IF;
1282:
1283: -- Initialize message list.
1284: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1285: fnd_msg_pub.initialize;
1286: END IF;
1287:
1288: -- construct the record type for the original reservation
1289: IF p_from_reservation_id IS NOT NULL
1386: WHEN fnd_api.g_exc_error THEN
1387: x_return_status := fnd_api.g_ret_sts_error;
1388:
1389: -- Get message count and data
1390: fnd_msg_pub.count_and_get
1391: ( p_count => x_msg_count
1392: , p_data => x_msg_data
1393: , p_encoded => 'F'
1394: );
1396: WHEN fnd_api.g_exc_unexpected_error THEN
1397: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1398:
1399: -- Get message count and data
1400: fnd_msg_pub.count_and_get
1401: ( p_count => x_msg_count
1402: , p_data => x_msg_data
1403: , p_encoded => 'F'
1404: );
1405:
1406: WHEN OTHERS THEN
1407: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1408:
1409: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1410: THEN
1411: fnd_msg_pub.add_exc_msg
1412: ( g_pkg_name
1413: , l_api_name
1407: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1408:
1409: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1410: THEN
1411: fnd_msg_pub.add_exc_msg
1412: ( g_pkg_name
1413: , l_api_name
1414: );
1415: END IF;
1414: );
1415: END IF;
1416:
1417: -- Get message count and data
1418: fnd_msg_pub.count_and_get
1419: ( p_count => x_msg_count
1420: , p_data => x_msg_data
1421: , p_encoded => 'F'
1422: );
1454: END IF;
1455: --
1456: -- Initialize message list.
1457: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1458: fnd_msg_pub.initialize;
1459: END IF;
1460: --
1461: l_rsv_rec.reservation_id := p_reservation_id;
1462: inv_reservation_pub.query_reservation
1488: WHEN fnd_api.g_exc_error THEN
1489: x_return_status := fnd_api.g_ret_sts_error;
1490:
1491: -- Get message count and data
1492: fnd_msg_pub.count_and_get
1493: ( p_count => x_msg_count
1494: , p_data => x_msg_data
1495: , p_encoded => 'F'
1496: );
1498: WHEN fnd_api.g_exc_unexpected_error THEN
1499: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1500:
1501: -- Get message count and data
1502: fnd_msg_pub.count_and_get
1503: ( p_count => x_msg_count
1504: , p_data => x_msg_data
1505: , p_encoded => 'F'
1506: );
1507:
1508: WHEN OTHERS THEN
1509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1510:
1511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1512: THEN
1513: fnd_msg_pub.add_exc_msg
1514: ( g_pkg_name
1515: , l_api_name
1509: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1510:
1511: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1512: THEN
1513: fnd_msg_pub.add_exc_msg
1514: ( g_pkg_name
1515: , l_api_name
1516: );
1517: END IF;
1516: );
1517: END IF;
1518:
1519: -- Get message count and data
1520: fnd_msg_pub.count_and_get
1521: ( p_count => x_msg_count
1522: , p_data => x_msg_data
1523: , p_encoded => 'F'
1524: );
1574: END IF;
1575: --
1576: -- Initialize message list.
1577: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1578: fnd_msg_pub.initialize;
1579: END IF;
1580:
1581: if p_demand_type_id in (inv_reservation_global.g_source_type_oe,
1582: inv_reservation_global.g_source_type_internal_ord,
1694: x_return_status := fnd_api.g_ret_sts_error;
1695: x_reservable_quantity := 0;
1696:
1697: -- Get message count and data
1698: fnd_msg_pub.count_and_get
1699: ( p_count => x_msg_count
1700: , p_data => x_msg_data
1701: , p_encoded => 'F'
1702: );
1705: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1706: x_reservable_quantity := 0;
1707:
1708: -- Get message count and data
1709: fnd_msg_pub.count_and_get
1710: ( p_count => x_msg_count
1711: , p_data => x_msg_data
1712: , p_encoded => 'F'
1713: );
1715: WHEN OTHERS THEN
1716: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1717: x_reservable_quantity := 0;
1718:
1719: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1720: THEN
1721: fnd_msg_pub.add_exc_msg
1722: ( g_pkg_name
1723: , l_api_name
1717: x_reservable_quantity := 0;
1718:
1719: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1720: THEN
1721: fnd_msg_pub.add_exc_msg
1722: ( g_pkg_name
1723: , l_api_name
1724: );
1725: END IF;
1724: );
1725: END IF;
1726:
1727: -- Get message count and data
1728: fnd_msg_pub.count_and_get
1729: ( p_count => x_msg_count
1730: , p_data => x_msg_data
1731: , p_encoded => 'F'
1732: );
1767: END IF;
1768: --
1769: -- Initialize message list.
1770: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1771: fnd_msg_pub.initialize;
1772: END IF;
1773:
1774: l_in_trohdr_rec.organization_id := p_organization_id;
1775: l_in_trohdr_rec.move_order_type := 8;
1809: WHEN fnd_api.g_exc_error THEN
1810: x_return_status := fnd_api.g_ret_sts_error;
1811:
1812: -- Get message count and data
1813: fnd_msg_pub.count_and_get
1814: ( p_count => x_msg_count
1815: , p_data => x_msg_data
1816: , p_encoded => 'F'
1817: );
1819: WHEN fnd_api.g_exc_unexpected_error THEN
1820: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1821:
1822: -- Get message count and data
1823: fnd_msg_pub.count_and_get
1824: ( p_count => x_msg_count
1825: , p_data => x_msg_data
1826: , p_encoded => 'F'
1827: );
1828:
1829: WHEN OTHERS THEN
1830: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1833: THEN
1834: fnd_msg_pub.add_exc_msg
1835: ( g_pkg_name
1836: , l_api_name
1830: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1831:
1832: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1833: THEN
1834: fnd_msg_pub.add_exc_msg
1835: ( g_pkg_name
1836: , l_api_name
1837: );
1838: END IF;
1837: );
1838: END IF;
1839:
1840: -- Get message count and data
1841: fnd_msg_pub.count_and_get
1842: ( p_count => x_msg_count
1843: , p_data => x_msg_data
1844: , p_encoded => 'F'
1845: );
1891: END IF;
1892: --
1893: -- Initialize message list.
1894: IF fnd_api.to_boolean(p_init_msg_lst) THEN
1895: fnd_msg_pub.initialize;
1896: END IF;
1897:
1898: l_in_trolin_tbl(1).operation := inv_globals.g_opr_create;
1899: l_in_trolin_tbl(1).header_id := p_move_order_header_id;
1957: WHEN fnd_api.g_exc_error THEN
1958: x_return_status := fnd_api.g_ret_sts_error;
1959:
1960: -- Get message count and data
1961: fnd_msg_pub.count_and_get
1962: ( p_count => x_msg_count
1963: , p_data => x_msg_data
1964: , p_encoded => 'F'
1965: );
1967: WHEN fnd_api.g_exc_unexpected_error THEN
1968: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1969:
1970: -- Get message count and data
1971: fnd_msg_pub.count_and_get
1972: ( p_count => x_msg_count
1973: , p_data => x_msg_data
1974: , p_encoded => 'F'
1975: );
1976:
1977: WHEN OTHERS THEN
1978: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1979:
1980: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1981: THEN
1982: fnd_msg_pub.add_exc_msg
1983: ( g_pkg_name
1984: , l_api_name
1978: x_return_status := fnd_api.g_ret_sts_unexp_error ;
1979:
1980: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
1981: THEN
1982: fnd_msg_pub.add_exc_msg
1983: ( g_pkg_name
1984: , l_api_name
1985: );
1986: END IF;
1985: );
1986: END IF;
1987:
1988: -- Get message count and data
1989: fnd_msg_pub.count_and_get
1990: ( p_count => x_msg_count
1991: , p_data => x_msg_data
1992: , p_encoded => 'F'
1993: );
2027: END IF;
2028: --
2029: -- Initialize message list.
2030: IF fnd_api.to_boolean(p_init_msg_lst) THEN
2031: fnd_msg_pub.initialize;
2032: END IF;
2033:
2034: l_in_trohdr_rec.operation := inv_globals.g_opr_delete;
2035: l_in_trohdr_rec.header_id := p_move_order_header_id;
2061: WHEN fnd_api.g_exc_error THEN
2062: x_return_status := fnd_api.g_ret_sts_error;
2063:
2064: -- Get message count and data
2065: fnd_msg_pub.count_and_get
2066: ( p_count => x_msg_count
2067: , p_data => x_msg_data
2068: , p_encoded => 'F'
2069: );
2071: WHEN fnd_api.g_exc_unexpected_error THEN
2072: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2073:
2074: -- Get message count and data
2075: fnd_msg_pub.count_and_get
2076: ( p_count => x_msg_count
2077: , p_data => x_msg_data
2078: , p_encoded => 'F'
2079: );
2080:
2081: WHEN OTHERS THEN
2082: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2083:
2084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2085: THEN
2086: fnd_msg_pub.add_exc_msg
2087: ( g_pkg_name
2088: , l_api_name
2082: x_return_status := fnd_api.g_ret_sts_unexp_error ;
2083:
2084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2085: THEN
2086: fnd_msg_pub.add_exc_msg
2087: ( g_pkg_name
2088: , l_api_name
2089: );
2090: END IF;
2089: );
2090: END IF;
2091:
2092: -- Get message count and data
2093: fnd_msg_pub.count_and_get
2094: ( p_count => x_msg_count
2095: , p_data => x_msg_data
2096: , p_encoded => 'F'
2097: );