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.GME_SUPPLY_RES_PVT dependencies on FND_API

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: From gme_batch_header
144: where batch_id = p_batch_id;
145:
146: BEGIN
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line ('Entering api '
150: || g_pkg_name || '.'
151: || l_api_name);

Line 205: , p_init_msg_lst => fnd_api.g_false

201: l_fpo_rsv_rec.supply_source_line_id := l_fpo_batch_line_id;
202: inv_reservation_pub.query_reservation
203: (
204: p_api_version_number => 1.0
205: , p_init_msg_lst => fnd_api.g_false
206: , x_return_status => x_return_status
207: , x_msg_count => x_msg_count
208: , x_msg_data => x_msg_data
209: , p_query_input => l_fpo_rsv_rec

Line 215: IF x_return_status = fnd_api.g_ret_sts_error THEN

211: , x_mtl_reservation_tbl => l_fpo_rsv_tbl
212: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
213: , x_error_code => l_api_error_code
214: );
215: IF x_return_status = fnd_api.g_ret_sts_error THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;

Line 216: RAISE fnd_api.g_exc_error;

212: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
213: , x_error_code => l_api_error_code
214: );
215: IF x_return_status = fnd_api.g_ret_sts_error THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:

Line 217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

213: , x_error_code => l_api_error_code
214: );
215: IF x_return_status = fnd_api.g_ret_sts_error THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: IF g_debug <= gme_debug.g_log_procedure THEN

Line 218: RAISE fnd_api.g_exc_unexpected_error;

214: );
215: IF x_return_status = fnd_api.g_ret_sts_error THEN
216: RAISE fnd_api.g_exc_error;
217: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
218: RAISE fnd_api.g_exc_unexpected_error;
219: END IF;
220:
221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' fpo reservation count '||l_fpo_rsv_count);

Line 292: p_init_msg_lst => fnd_api.g_false,

288: END IF;
289:
290: inv_reservation_pub.transfer_reservation
291: (p_api_version_number => 1.0,
292: p_init_msg_lst => fnd_api.g_false,
293: x_return_status => x_return_status,
294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data,
296: p_original_rsv_rec => l_fpo_rsv_tbl(i),

Line 300: p_validation_flag => fnd_api.g_false,

296: p_original_rsv_rec => l_fpo_rsv_tbl(i),
297: p_to_rsv_rec => l_batch_rsv_rec,
298: p_original_serial_number => l_dummy_sn ,
299: p_to_serial_number => l_dummy_sn ,
300: p_validation_flag => fnd_api.g_false,
301: x_to_reservation_id => l_new_reservation_id
302: );
303: IF x_return_status = fnd_api.g_ret_sts_error THEN
304: RAISE fnd_api.g_exc_error;

Line 303: IF x_return_status = fnd_api.g_ret_sts_error THEN

299: p_to_serial_number => l_dummy_sn ,
300: p_validation_flag => fnd_api.g_false,
301: x_to_reservation_id => l_new_reservation_id
302: );
303: IF x_return_status = fnd_api.g_ret_sts_error THEN
304: RAISE fnd_api.g_exc_error;
305: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
306: RAISE fnd_api.g_exc_unexpected_error;
307: END IF;

Line 304: RAISE fnd_api.g_exc_error;

300: p_validation_flag => fnd_api.g_false,
301: x_to_reservation_id => l_new_reservation_id
302: );
303: IF x_return_status = fnd_api.g_ret_sts_error THEN
304: RAISE fnd_api.g_exc_error;
305: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
306: RAISE fnd_api.g_exc_unexpected_error;
307: END IF;
308: l_remaining_qty := l_remaining_qty - l_reserved_qty;

Line 305: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

301: x_to_reservation_id => l_new_reservation_id
302: );
303: IF x_return_status = fnd_api.g_ret_sts_error THEN
304: RAISE fnd_api.g_exc_error;
305: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
306: RAISE fnd_api.g_exc_unexpected_error;
307: END IF;
308: l_remaining_qty := l_remaining_qty - l_reserved_qty;
309: <>

Line 306: RAISE fnd_api.g_exc_unexpected_error;

302: );
303: IF x_return_status = fnd_api.g_ret_sts_error THEN
304: RAISE fnd_api.g_exc_error;
305: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
306: RAISE fnd_api.g_exc_unexpected_error;
307: END IF;
308: l_remaining_qty := l_remaining_qty - l_reserved_qty;
309: <>
310: null;

Line 327: WHEN FND_API.G_EXC_ERROR THEN

323: , X_msg_cont => x_msg_count
324: , X_msg_data => x_msg_data );
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: /* Get message count and data*/
330: FND_MSG_PUB.count_and_get
331: ( p_count => x_msg_count

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: , X_msg_data => x_msg_data );
325:
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: /* Get message count and data*/
330: FND_MSG_PUB.count_and_get
331: ( p_count => x_msg_count
332: , p_data => x_msg_data

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334: IF g_debug <= gme_debug.g_log_procedure THEN
335: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Expected');
336: END IF;
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
341: , 'convert_FPO'
342: );

Line 481: x_return_status := FND_API.G_RET_STS_SUCCESS;

477: -- MakeToOrder BEGIN
478:
479: BEGIN
480:
481: x_return_status := FND_API.G_RET_STS_SUCCESS;
482:
483: IF g_debug <= gme_debug.g_log_procedure THEN
484: gme_debug.put_line ('Entering api '
485: || g_pkg_name || '.'

Line 852: x_return_status := fnd_api.g_ret_sts_success;

848: || g_pkg_name || '.'
849: || l_api_name);
850: END IF;
851:
852: x_return_status := fnd_api.g_ret_sts_success;
853:
854: IF g_debug <= gme_debug.g_log_statement THEN
855: gme_debug.put_line
856: ( g_pkg_name

Line 868: IF x_return_status <> fnd_api.g_ret_sts_success THEN

864: ,x_mmt_rec => l_mmt_rec
865: ,x_mmln_tbl => l_mmln_tbl
866: ,x_return_status => x_return_status);
867:
868: IF x_return_status <> fnd_api.g_ret_sts_success THEN
869: IF (g_debug <= gme_debug.g_log_statement) THEN
870: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
871: END IF;
872: RAISE get_trans_err;

Line 974: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

970: || ' number of reservations is '
971: || l_rsv_count);
972: END IF;
973:
974: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
975: IF g_debug <= gme_debug.g_log_statement THEN
976: gme_debug.put_line
977: ( g_pkg_name
978: || '.'

Line 1022: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1018: ,p_item_id => l_rsv_rec.inventory_item_id
1019: ,x_item_rec => l_item_rec
1020: ,x_return_status => l_return_status);
1021:
1022: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1023: x_return_status := l_return_status;
1024: RAISE error_get_item;
1025: END IF;
1026:

Line 1160: , p_init_msg_lst => FND_API.G_TRUE

1156: END IF;
1157:
1158: inv_reservation_pub.Transfer_Reservation
1159: ( p_api_version_number => 1.0
1160: , p_init_msg_lst => FND_API.G_TRUE
1161: , x_return_status => x_return_status
1162: , x_msg_count => x_message_count
1163: , x_msg_data => x_message_list
1164: , p_original_rsv_rec => l_rsv_rec

Line 1168: , p_validation_flag => FND_API.G_FALSE

1164: , p_original_rsv_rec => l_rsv_rec
1165: , p_to_rsv_rec => l_to_rsv_rec
1166: , p_original_serial_number => l_dummy_sn
1167: , p_to_serial_number => l_dummy_sn
1168: , p_validation_flag => FND_API.G_FALSE
1169: , x_to_reservation_id => l_rsv_id);
1170:
1171: IF (g_debug <= gme_debug.g_log_statement) THEN
1172: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);

Line 1176: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1172: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);
1173: END IF;
1174:
1175: IF (l_return_status IN
1176: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1177: RAISE transfer_reservation_err;
1178: END IF;
1179: ELSE
1180: -- Target Inventory IS NOT RESERVABLE so we cannot transfer the reservation

Line 1212: IF (x_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1208: || ' after calling notify_CSR status is '
1209: || x_return_status );
1210: END IF;
1211:
1212: IF (x_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1213: RAISE notify_CSR_err;
1214: END IF;
1215:
1216: END IF;

Line 1228: , p_init_msg_lst => fnd_api.g_true

1224: || l_transfer_primary );
1225: END IF;
1226: inv_reservation_pub.relieve_reservation
1227: ( p_api_version_number => 1.0
1228: , p_init_msg_lst => fnd_api.g_true
1229: , x_return_status => x_return_status
1230: , x_msg_count => x_message_count
1231: , x_msg_data => x_message_list
1232: , p_rsv_rec => l_rsv_rec

Line 1235: , p_relieve_all => fnd_api.g_false

1231: , x_msg_data => x_message_list
1232: , p_rsv_rec => l_rsv_rec
1233: , p_primary_relieved_quantity => l_transfer_primary
1234: , p_secondary_relieved_quantity => l_transfer_secondary
1235: , p_relieve_all => fnd_api.g_false
1236: , p_original_serial_number => l_dummy_sn -- no serial control
1237: , p_validation_flag => fnd_api.g_true
1238: , x_primary_relieved_quantity => l_primary_relieved
1239: , x_secondary_relieved_quantity => l_secondary_relieved

Line 1237: , p_validation_flag => fnd_api.g_true

1233: , p_primary_relieved_quantity => l_transfer_primary
1234: , p_secondary_relieved_quantity => l_transfer_secondary
1235: , p_relieve_all => fnd_api.g_false
1236: , p_original_serial_number => l_dummy_sn -- no serial control
1237: , p_validation_flag => fnd_api.g_true
1238: , x_primary_relieved_quantity => l_primary_relieved
1239: , x_secondary_relieved_quantity => l_secondary_relieved
1240: , x_primary_remain_quantity => l_primary_remain
1241: , x_secondary_remain_quantity => l_secondary_remain

Line 1252: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1248: || x_return_status );
1249: END IF;
1250:
1251: IF (x_return_status IN
1252: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1253: RAISE update_reservation_err;
1254: END IF;
1255: END IF; -- End of handling for non reservable inventory
1256:

Line 1275: x_return_status := fnd_api.g_ret_sts_error;

1271: END IF;
1272:
1273: EXCEPTION
1274: WHEN uom_conversion_error THEN
1275: x_return_status := fnd_api.g_ret_sts_error;
1276: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1277: fnd_message.set_token ('ITEM_NO', l_rsv_rec.inventory_item_id);
1278: fnd_message.set_token ('FROM_UOM', l_rsv_rec.primary_uom_code);
1279: fnd_message.set_token ('TO_UOM', l_rsv_rec.secondary_uom_code);

Line 1332: x_return_status := fnd_api.g_ret_sts_unexp_error;

1328: || SQLERRM);
1329: END IF;
1330:
1331: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1332: x_return_status := fnd_api.g_ret_sts_unexp_error;
1333:
1334: END transfer_reservation_to_inv;
1335:
1336: PROCEDURE query_prod_supply_reservations(

Line 1362: x_return_status := fnd_api.g_ret_sts_success;

1358: || g_pkg_name || '.'
1359: || l_api_name);
1360: END IF;
1361:
1362: x_return_status := fnd_api.g_ret_sts_success;
1363:
1364: -- If material_detail_id supplied,retrieve the reservations against this supply line
1365: -- =================================================================================
1366: IF p_matl_dtl_rec.material_detail_id is NOT NULL THEN

Line 1401: ,p_init_msg_lst => fnd_api.g_false

1397: END IF;
1398:
1399: inv_reservation_pub.query_reservation
1400: (p_api_version_number => 1.0
1401: ,p_init_msg_lst => fnd_api.g_false
1402: ,x_return_status => x_return_status
1403: ,x_msg_count => x_msg_count
1404: ,x_msg_data => x_msg_data
1405: ,p_query_input => l_rsv_rec_inq

Line 1406: ,p_lock_records => fnd_api.g_false

1402: ,x_return_status => x_return_status
1403: ,x_msg_count => x_msg_count
1404: ,x_msg_data => x_msg_data
1405: ,p_query_input => l_rsv_rec_inq
1406: ,p_lock_records => fnd_api.g_false
1407: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
1408: ,x_mtl_reservation_tbl => x_mtl_reservation_tbl
1409: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1410: ,x_error_code => l_error_code);

Line 1423: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1419: || ' Error code is '
1420: || l_error_code);
1421: END IF;
1422:
1423: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1424: RAISE query_reservation_error;
1425: END IF;
1426:
1427: IF g_debug <= gme_debug.g_log_statement THEN

Line 1460: x_return_status := fnd_api.g_ret_sts_unexp_error;

1456: || SQLERRM);
1457: END IF;
1458:
1459: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1460: x_return_status := fnd_api.g_ret_sts_unexp_error;
1461:
1462: END query_prod_supply_reservations;
1463:
1464: PROCEDURE relieve_prod_supply_resv (

Line 1498: x_return_status := fnd_api.g_ret_sts_success;

1494: || ' material_detail_id '
1495: || p_matl_dtl_rec.material_detail_id);
1496: END IF;
1497:
1498: x_return_status := fnd_api.g_ret_sts_success;
1499:
1500: IF p_matl_dtl_rec.line_type not in (1,2) THEN
1501: RETURN;
1502: END IF;

Line 1527: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1523: || ' number of reservations is '
1524: || l_rsv_count);
1525: END IF;
1526:
1527: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1528: IF g_debug <= gme_debug.g_log_statement THEN
1529: gme_debug.put_line
1530: ( g_pkg_name
1531: || '.'

Line 1625: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1621: || x_return_status );
1622: END IF;
1623:
1624: IF (x_return_status IN
1625: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1626: RAISE notify_CSR_err;
1627: END IF;
1628:
1629: IF (l_rsv_rec.primary_reservation_quantity <= l_primary_to_unreserve) THEN

Line 1638: , p_init_msg_lst => fnd_api.g_true

1634: END IF;
1635:
1636: inv_reservation_pub.delete_reservation
1637: ( p_api_version_number => 1.0
1638: , p_init_msg_lst => fnd_api.g_true
1639: , x_return_status => x_return_status
1640: , x_msg_count => x_msg_count
1641: , x_msg_data => x_msg_data
1642: , p_rsv_rec => l_rsv_rec

Line 1655: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1651: END IF;
1652:
1653:
1654: IF (x_return_status IN
1655: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1656: RAISE delete_reservation_err;
1657: END IF;
1658:
1659: l_primary_to_unreserve := l_primary_to_unreserve -

Line 1690: , p_init_msg_lst => fnd_api.g_true

1686: END IF;
1687:
1688: inv_reservation_pub.relieve_reservation
1689: ( p_api_version_number => 1.0
1690: , p_init_msg_lst => fnd_api.g_true
1691: , x_return_status => x_return_status
1692: , x_msg_count => x_msg_count
1693: , x_msg_data => x_msg_data
1694: , p_rsv_rec => l_rsv_rec

Line 1697: , p_relieve_all => fnd_api.g_false

1693: , x_msg_data => x_msg_data
1694: , p_rsv_rec => l_rsv_rec
1695: , p_primary_relieved_quantity => l_primary_to_unreserve
1696: , p_secondary_relieved_quantity => l_secondary_to_unreserve
1697: , p_relieve_all => fnd_api.g_false
1698: , p_original_serial_number => l_dummy_sn -- no serial control
1699: , p_validation_flag => fnd_api.g_true
1700: , x_primary_relieved_quantity => l_primary_relieved
1701: , x_secondary_relieved_quantity => l_secondary_relieved

Line 1699: , p_validation_flag => fnd_api.g_true

1695: , p_primary_relieved_quantity => l_primary_to_unreserve
1696: , p_secondary_relieved_quantity => l_secondary_to_unreserve
1697: , p_relieve_all => fnd_api.g_false
1698: , p_original_serial_number => l_dummy_sn -- no serial control
1699: , p_validation_flag => fnd_api.g_true
1700: , x_primary_relieved_quantity => l_primary_relieved
1701: , x_secondary_relieved_quantity => l_secondary_relieved
1702: , x_primary_remain_quantity => l_primary_remain
1703: , x_secondary_remain_quantity => l_secondary_remain

Line 1714: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1710: || x_return_status );
1711: END IF;
1712:
1713: IF (x_return_status IN
1714: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1715: RAISE update_reservation_err;
1716: END IF;
1717:
1718: l_primary_to_unreserve := 0;

Line 1764: x_return_status := fnd_api.g_ret_sts_unexp_error;

1760: || SQLERRM);
1761: END IF;
1762:
1763: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1764: x_return_status := fnd_api.g_ret_sts_unexp_error;
1765:
1766: END relieve_prod_supply_resv;
1767:
1768: PROCEDURE delete_prod_supply_resv (

Line 1796: x_return_status := fnd_api.g_ret_sts_success;

1792: || ' material_detail_id '
1793: || p_matl_dtl_rec.material_detail_id);
1794: END IF;
1795:
1796: x_return_status := fnd_api.g_ret_sts_success;
1797:
1798: -- The line may not have been fully populated so retrieve it if necessary
1799: -- ======================================================================
1800: IF p_matl_dtl_rec.line_type is NULL THEN

Line 1836: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

1832: || ' number of reservations is '
1833: || l_rsv_count);
1834: END IF;
1835:
1836: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1837: IF g_debug <= gme_debug.g_log_statement THEN
1838: gme_debug.put_line
1839: ( g_pkg_name
1840: || '.'

Line 1887: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1883: || x_return_status );
1884: END IF;
1885:
1886: IF (x_return_status IN
1887: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1888: RAISE notify_CSR_err;
1889: END IF;
1890:
1891: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1900: , p_init_msg_lst => fnd_api.g_true

1896: END IF;
1897:
1898: inv_reservation_pub.delete_reservation
1899: ( p_api_version_number => 1.0
1900: , p_init_msg_lst => fnd_api.g_true
1901: , x_return_status => x_return_status
1902: , x_msg_count => x_msg_count
1903: , x_msg_data => x_msg_data
1904: , p_rsv_rec => l_rsv_rec

Line 1917: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

1913: END IF;
1914:
1915:
1916: IF (x_return_status IN
1917: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1918: RAISE delete_reservation_err;
1919: END IF;
1920:
1921: END LOOP;

Line 1940: x_return_status := fnd_api.g_ret_sts_error;

1936: ( 'gme_supply_res_pvt.notify_CSR failure ');
1937: gme_debug.put_line ('error message is ' || x_msg_data);
1938: END IF;
1939: WHEN matl_fetch_error THEN
1940: x_return_status := fnd_api.g_ret_sts_error;
1941: WHEN OTHERS THEN
1942: IF g_debug <= gme_debug.g_log_unexpected THEN
1943: gme_debug.put_line ( 'When others exception in '
1944: || g_pkg_name

Line 1952: x_return_status := fnd_api.g_ret_sts_unexp_error;

1948: || SQLERRM);
1949: END IF;
1950:
1951: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1952: x_return_status := fnd_api.g_ret_sts_unexp_error;
1953:
1954: END delete_prod_supply_resv;
1955:
1956: PROCEDURE delete_batch_prod_supply_resv (

Line 1984: x_return_status := fnd_api.g_ret_sts_success;

1980: || ' batch_id => '
1981: || p_batch_header_rec.batch_id);
1982: END IF;
1983:
1984: x_return_status := fnd_api.g_ret_sts_success;
1985:
1986: -- Query all the reservations agains this batch as a source of supply
1987: l_matl_dtl_rec.batch_id := p_batch_header_rec.batch_id;
1988: GME_SUPPLY_RES_PVT.query_prod_supply_reservations

Line 2011: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN

2007: || ' number of reservations is '
2008: || l_rsv_count);
2009: END IF;
2010:
2011: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
2012: IF g_debug <= gme_debug.g_log_statement THEN
2013: gme_debug.put_line
2014: ( g_pkg_name
2015: || '.'

Line 2066: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

2062: -- This will advise the sales representative of the deletion
2063: -- =========================================================
2064:
2065: IF (x_return_status IN
2066: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
2067: RAISE notify_CSR_err;
2068: END IF;
2069:
2070: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2079: , p_init_msg_lst => fnd_api.g_true

2075: END IF;
2076:
2077: inv_reservation_pub.delete_reservation
2078: ( p_api_version_number => 1.0
2079: , p_init_msg_lst => fnd_api.g_true
2080: , x_return_status => x_return_status
2081: , x_msg_count => x_msg_count
2082: , x_msg_data => x_msg_data
2083: , p_rsv_rec => l_rsv_rec

Line 2096: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN

2092: END IF;
2093:
2094:
2095: IF (x_return_status IN
2096: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
2097: RAISE delete_reservation_err;
2098: END IF;
2099:
2100: END LOOP;

Line 2119: x_return_status := fnd_api.g_ret_sts_error;

2115: ( 'gme_supply_res_pvt.notify_CSR failure ');
2116: gme_debug.put_line ('error message is ' || x_msg_data);
2117: END IF;
2118: WHEN matl_fetch_error THEN
2119: x_return_status := fnd_api.g_ret_sts_error;
2120: WHEN OTHERS THEN
2121: IF g_debug <= gme_debug.g_log_unexpected THEN
2122: gme_debug.put_line ( 'When others exception in '
2123: || g_pkg_name

Line 2131: x_return_status := fnd_api.g_ret_sts_unexp_error;

2127: || SQLERRM);
2128: END IF;
2129:
2130: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2131: x_return_status := fnd_api.g_ret_sts_unexp_error;
2132:
2133: END delete_batch_prod_supply_resv;
2134:
2135: END GME_SUPPLY_RES_PVT;