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 131: x_return_status := FND_API.G_RET_STS_SUCCESS;

127: From gme_batch_header
128: where batch_id = p_batch_id;
129:
130: BEGIN
131: x_return_status := FND_API.G_RET_STS_SUCCESS;
132: IF g_debug <= gme_debug.g_log_procedure THEN
133: gme_debug.put_line ('Entering api '
134: || g_pkg_name || '.'
135: || l_api_name);

Line 189: , p_init_msg_lst => fnd_api.g_false

185: l_fpo_rsv_rec.supply_source_line_id := l_fpo_batch_line_id;
186: inv_reservation_pub.query_reservation
187: (
188: p_api_version_number => 1.0
189: , p_init_msg_lst => fnd_api.g_false
190: , x_return_status => x_return_status
191: , x_msg_count => x_msg_count
192: , x_msg_data => x_msg_data
193: , p_query_input => l_fpo_rsv_rec

Line 199: IF x_return_status = fnd_api.g_ret_sts_error THEN

195: , x_mtl_reservation_tbl => l_fpo_rsv_tbl
196: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
197: , x_error_code => l_api_error_code
198: );
199: IF x_return_status = fnd_api.g_ret_sts_error THEN
200: RAISE fnd_api.g_exc_error;
201: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
202: RAISE fnd_api.g_exc_unexpected_error;
203: END IF;

Line 200: RAISE fnd_api.g_exc_error;

196: , x_mtl_reservation_tbl_count => l_fpo_rsv_count
197: , x_error_code => l_api_error_code
198: );
199: IF x_return_status = fnd_api.g_ret_sts_error THEN
200: RAISE fnd_api.g_exc_error;
201: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
202: RAISE fnd_api.g_exc_unexpected_error;
203: END IF;
204:

Line 201: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

197: , x_error_code => l_api_error_code
198: );
199: IF x_return_status = fnd_api.g_ret_sts_error THEN
200: RAISE fnd_api.g_exc_error;
201: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
202: RAISE fnd_api.g_exc_unexpected_error;
203: END IF;
204:
205: IF g_debug <= gme_debug.g_log_procedure THEN

Line 202: RAISE fnd_api.g_exc_unexpected_error;

198: );
199: IF x_return_status = fnd_api.g_ret_sts_error THEN
200: RAISE fnd_api.g_exc_error;
201: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
202: RAISE fnd_api.g_exc_unexpected_error;
203: END IF;
204:
205: IF g_debug <= gme_debug.g_log_procedure THEN
206: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' fpo reservation count '||l_fpo_rsv_count);

Line 276: p_init_msg_lst => fnd_api.g_false,

272: END IF;
273:
274: inv_reservation_pub.transfer_reservation
275: (p_api_version_number => 1.0,
276: p_init_msg_lst => fnd_api.g_false,
277: x_return_status => x_return_status,
278: x_msg_count => x_msg_count,
279: x_msg_data => x_msg_data,
280: p_original_rsv_rec => l_fpo_rsv_tbl(i),

Line 284: p_validation_flag => fnd_api.g_false,

280: p_original_rsv_rec => l_fpo_rsv_tbl(i),
281: p_to_rsv_rec => l_batch_rsv_rec,
282: p_original_serial_number => l_dummy_sn ,
283: p_to_serial_number => l_dummy_sn ,
284: p_validation_flag => fnd_api.g_false,
285: x_to_reservation_id => l_new_reservation_id
286: );
287: IF x_return_status = fnd_api.g_ret_sts_error THEN
288: RAISE fnd_api.g_exc_error;

Line 287: IF x_return_status = fnd_api.g_ret_sts_error THEN

283: p_to_serial_number => l_dummy_sn ,
284: p_validation_flag => fnd_api.g_false,
285: x_to_reservation_id => l_new_reservation_id
286: );
287: IF x_return_status = fnd_api.g_ret_sts_error THEN
288: RAISE fnd_api.g_exc_error;
289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
290: RAISE fnd_api.g_exc_unexpected_error;
291: END IF;

Line 288: RAISE fnd_api.g_exc_error;

284: p_validation_flag => fnd_api.g_false,
285: x_to_reservation_id => l_new_reservation_id
286: );
287: IF x_return_status = fnd_api.g_ret_sts_error THEN
288: RAISE fnd_api.g_exc_error;
289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
290: RAISE fnd_api.g_exc_unexpected_error;
291: END IF;
292: l_remaining_qty := l_remaining_qty - l_reserved_qty;

Line 289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

285: x_to_reservation_id => l_new_reservation_id
286: );
287: IF x_return_status = fnd_api.g_ret_sts_error THEN
288: RAISE fnd_api.g_exc_error;
289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
290: RAISE fnd_api.g_exc_unexpected_error;
291: END IF;
292: l_remaining_qty := l_remaining_qty - l_reserved_qty;
293: <>

Line 290: RAISE fnd_api.g_exc_unexpected_error;

286: );
287: IF x_return_status = fnd_api.g_ret_sts_error THEN
288: RAISE fnd_api.g_exc_error;
289: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
290: RAISE fnd_api.g_exc_unexpected_error;
291: END IF;
292: l_remaining_qty := l_remaining_qty - l_reserved_qty;
293: <>
294: null;

Line 311: WHEN FND_API.G_EXC_ERROR THEN

307: , X_msg_cont => x_msg_count
308: , X_msg_data => x_msg_data );
309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: /* Get message count and data*/
314: FND_MSG_PUB.count_and_get
315: ( p_count => x_msg_count

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: , X_msg_data => x_msg_data );
309:
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: x_return_status := FND_API.G_RET_STS_ERROR;
313: /* Get message count and data*/
314: FND_MSG_PUB.count_and_get
315: ( p_count => x_msg_count
316: , p_data => x_msg_data

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318: IF g_debug <= gme_debug.g_log_procedure THEN
319: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'u EXCEPTION: Expected');
320: END IF;
321: WHEN OTHERS THEN
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323:
324: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
325: , 'convert_FPO'
326: );

Line 465: x_return_status := FND_API.G_RET_STS_SUCCESS;

461: -- MakeToOrder BEGIN
462:
463: BEGIN
464:
465: x_return_status := FND_API.G_RET_STS_SUCCESS;
466:
467: IF g_debug <= gme_debug.g_log_procedure THEN
468: gme_debug.put_line ('Entering api '
469: || g_pkg_name || '.'

Line 830: x_return_status := fnd_api.g_ret_sts_success;

826: || g_pkg_name || '.'
827: || l_api_name);
828: END IF;
829:
830: x_return_status := fnd_api.g_ret_sts_success;
831:
832: IF g_debug <= gme_debug.g_log_statement THEN
833: gme_debug.put_line
834: ( g_pkg_name

Line 846: IF x_return_status <> fnd_api.g_ret_sts_success THEN

842: ,x_mmt_rec => l_mmt_rec
843: ,x_mmln_tbl => l_mmln_tbl
844: ,x_return_status => x_return_status);
845:
846: IF x_return_status <> fnd_api.g_ret_sts_success THEN
847: IF (g_debug <= gme_debug.g_log_statement) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||':'||'Error from get transactions');
849: END IF;
850: RAISE get_trans_err;

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

948: || ' number of reservations is '
949: || l_rsv_count);
950: END IF;
951:
952: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
953: IF g_debug <= gme_debug.g_log_statement THEN
954: gme_debug.put_line
955: ( g_pkg_name
956: || '.'

Line 1101: , p_init_msg_lst => FND_API.G_TRUE

1097: END IF;
1098:
1099: inv_reservation_pub.Transfer_Reservation
1100: ( p_api_version_number => 1.0
1101: , p_init_msg_lst => FND_API.G_TRUE
1102: , x_return_status => x_return_status
1103: , x_msg_count => x_message_count
1104: , x_msg_data => x_message_list
1105: , p_original_rsv_rec => l_rsv_rec

Line 1109: , p_validation_flag => FND_API.G_FALSE

1105: , p_original_rsv_rec => l_rsv_rec
1106: , p_to_rsv_rec => l_to_rsv_rec
1107: , p_original_serial_number => l_dummy_sn
1108: , p_to_serial_number => l_dummy_sn
1109: , p_validation_flag => FND_API.G_FALSE
1110: , x_to_reservation_id => l_rsv_id);
1111:
1112: IF (g_debug <= gme_debug.g_log_statement) THEN
1113: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);

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

1113: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);
1114: END IF;
1115:
1116: IF (l_return_status IN
1117: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1118: RAISE transfer_reservation_err;
1119: END IF;
1120: ELSE
1121: -- Target Inventory IS NOT RESERVABLE so we cannot transfer the reservation

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

1149: || ' after calling notify_CSR status is '
1150: || x_return_status );
1151: END IF;
1152:
1153: IF (x_return_status IN (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1154: RAISE notify_CSR_err;
1155: END IF;
1156:
1157: END IF;

Line 1169: , p_init_msg_lst => fnd_api.g_true

1165: || l_transfer_primary );
1166: END IF;
1167: inv_reservation_pub.relieve_reservation
1168: ( p_api_version_number => 1.0
1169: , p_init_msg_lst => fnd_api.g_true
1170: , x_return_status => x_return_status
1171: , x_msg_count => x_message_count
1172: , x_msg_data => x_message_list
1173: , p_rsv_rec => l_rsv_rec

Line 1176: , p_relieve_all => fnd_api.g_false

1172: , x_msg_data => x_message_list
1173: , p_rsv_rec => l_rsv_rec
1174: , p_primary_relieved_quantity => l_transfer_primary
1175: , p_secondary_relieved_quantity => l_transfer_secondary
1176: , p_relieve_all => fnd_api.g_false
1177: , p_original_serial_number => l_dummy_sn -- no serial control
1178: , p_validation_flag => fnd_api.g_true
1179: , x_primary_relieved_quantity => l_primary_relieved
1180: , x_secondary_relieved_quantity => l_secondary_relieved

Line 1178: , p_validation_flag => fnd_api.g_true

1174: , p_primary_relieved_quantity => l_transfer_primary
1175: , p_secondary_relieved_quantity => l_transfer_secondary
1176: , p_relieve_all => fnd_api.g_false
1177: , p_original_serial_number => l_dummy_sn -- no serial control
1178: , p_validation_flag => fnd_api.g_true
1179: , x_primary_relieved_quantity => l_primary_relieved
1180: , x_secondary_relieved_quantity => l_secondary_relieved
1181: , x_primary_remain_quantity => l_primary_remain
1182: , x_secondary_remain_quantity => l_secondary_remain

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

1189: || x_return_status );
1190: END IF;
1191:
1192: IF (x_return_status IN
1193: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1194: RAISE update_reservation_err;
1195: END IF;
1196: END IF; -- End of handling for non reservable inventory
1197:

Line 1216: x_return_status := fnd_api.g_ret_sts_error;

1212: END IF;
1213:
1214: EXCEPTION
1215: WHEN uom_conversion_error THEN
1216: x_return_status := fnd_api.g_ret_sts_error;
1217: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1218: fnd_message.set_token ('ITEM_NO', l_rsv_rec.inventory_item_id);
1219: fnd_message.set_token ('FROM_UOM', l_rsv_rec.primary_uom_code);
1220: fnd_message.set_token ('TO_UOM', l_rsv_rec.secondary_uom_code);

Line 1269: x_return_status := fnd_api.g_ret_sts_unexp_error;

1265: || SQLERRM);
1266: END IF;
1267:
1268: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1269: x_return_status := fnd_api.g_ret_sts_unexp_error;
1270:
1271: END transfer_reservation_to_inv;
1272:
1273: PROCEDURE query_prod_supply_reservations(

Line 1299: x_return_status := fnd_api.g_ret_sts_success;

1295: || g_pkg_name || '.'
1296: || l_api_name);
1297: END IF;
1298:
1299: x_return_status := fnd_api.g_ret_sts_success;
1300:
1301: -- If material_detail_id supplied,retrieve the reservations against this supply line
1302: -- =================================================================================
1303: IF p_matl_dtl_rec.material_detail_id is NOT NULL THEN

Line 1338: ,p_init_msg_lst => fnd_api.g_false

1334: END IF;
1335:
1336: inv_reservation_pub.query_reservation
1337: (p_api_version_number => 1.0
1338: ,p_init_msg_lst => fnd_api.g_false
1339: ,x_return_status => x_return_status
1340: ,x_msg_count => x_msg_count
1341: ,x_msg_data => x_msg_data
1342: ,p_query_input => l_rsv_rec_inq

Line 1343: ,p_lock_records => fnd_api.g_false

1339: ,x_return_status => x_return_status
1340: ,x_msg_count => x_msg_count
1341: ,x_msg_data => x_msg_data
1342: ,p_query_input => l_rsv_rec_inq
1343: ,p_lock_records => fnd_api.g_false
1344: ,p_sort_by_req_date => inv_reservation_global.g_query_req_date_asc
1345: ,x_mtl_reservation_tbl => x_mtl_reservation_tbl
1346: ,x_mtl_reservation_tbl_count => x_mtl_reservation_tbl_count
1347: ,x_error_code => l_error_code);

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

1356: || ' Error code is '
1357: || l_error_code);
1358: END IF;
1359:
1360: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1361: RAISE query_reservation_error;
1362: END IF;
1363:
1364: IF g_debug <= gme_debug.g_log_statement THEN

Line 1397: x_return_status := fnd_api.g_ret_sts_unexp_error;

1393: || SQLERRM);
1394: END IF;
1395:
1396: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1397: x_return_status := fnd_api.g_ret_sts_unexp_error;
1398:
1399: END query_prod_supply_reservations;
1400:
1401: PROCEDURE relieve_prod_supply_resv (

Line 1435: x_return_status := fnd_api.g_ret_sts_success;

1431: || ' material_detail_id '
1432: || p_matl_dtl_rec.material_detail_id);
1433: END IF;
1434:
1435: x_return_status := fnd_api.g_ret_sts_success;
1436:
1437: IF p_matl_dtl_rec.line_type not in (1,2) THEN
1438: RETURN;
1439: END IF;

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

1460: || ' number of reservations is '
1461: || l_rsv_count);
1462: END IF;
1463:
1464: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1465: IF g_debug <= gme_debug.g_log_statement THEN
1466: gme_debug.put_line
1467: ( g_pkg_name
1468: || '.'

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

1558: || x_return_status );
1559: END IF;
1560:
1561: IF (x_return_status IN
1562: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1563: RAISE notify_CSR_err;
1564: END IF;
1565:
1566: IF (l_rsv_rec.primary_reservation_quantity <= l_primary_to_unreserve) THEN

Line 1575: , p_init_msg_lst => fnd_api.g_true

1571: END IF;
1572:
1573: inv_reservation_pub.delete_reservation
1574: ( p_api_version_number => 1.0
1575: , p_init_msg_lst => fnd_api.g_true
1576: , x_return_status => x_return_status
1577: , x_msg_count => x_msg_count
1578: , x_msg_data => x_msg_data
1579: , p_rsv_rec => l_rsv_rec

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

1588: END IF;
1589:
1590:
1591: IF (x_return_status IN
1592: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1593: RAISE delete_reservation_err;
1594: END IF;
1595:
1596: l_primary_to_unreserve := l_primary_to_unreserve -

Line 1627: , p_init_msg_lst => fnd_api.g_true

1623: END IF;
1624:
1625: inv_reservation_pub.relieve_reservation
1626: ( p_api_version_number => 1.0
1627: , p_init_msg_lst => fnd_api.g_true
1628: , x_return_status => x_return_status
1629: , x_msg_count => x_msg_count
1630: , x_msg_data => x_msg_data
1631: , p_rsv_rec => l_rsv_rec

Line 1634: , p_relieve_all => fnd_api.g_false

1630: , x_msg_data => x_msg_data
1631: , p_rsv_rec => l_rsv_rec
1632: , p_primary_relieved_quantity => l_primary_to_unreserve
1633: , p_secondary_relieved_quantity => l_secondary_to_unreserve
1634: , p_relieve_all => fnd_api.g_false
1635: , p_original_serial_number => l_dummy_sn -- no serial control
1636: , p_validation_flag => fnd_api.g_true
1637: , x_primary_relieved_quantity => l_primary_relieved
1638: , x_secondary_relieved_quantity => l_secondary_relieved

Line 1636: , p_validation_flag => fnd_api.g_true

1632: , p_primary_relieved_quantity => l_primary_to_unreserve
1633: , p_secondary_relieved_quantity => l_secondary_to_unreserve
1634: , p_relieve_all => fnd_api.g_false
1635: , p_original_serial_number => l_dummy_sn -- no serial control
1636: , p_validation_flag => fnd_api.g_true
1637: , x_primary_relieved_quantity => l_primary_relieved
1638: , x_secondary_relieved_quantity => l_secondary_relieved
1639: , x_primary_remain_quantity => l_primary_remain
1640: , x_secondary_remain_quantity => l_secondary_remain

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

1647: || x_return_status );
1648: END IF;
1649:
1650: IF (x_return_status IN
1651: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1652: RAISE update_reservation_err;
1653: END IF;
1654:
1655: l_primary_to_unreserve := 0;

Line 1701: x_return_status := fnd_api.g_ret_sts_unexp_error;

1697: || SQLERRM);
1698: END IF;
1699:
1700: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1701: x_return_status := fnd_api.g_ret_sts_unexp_error;
1702:
1703: END relieve_prod_supply_resv;
1704:
1705: PROCEDURE delete_prod_supply_resv (

Line 1733: x_return_status := fnd_api.g_ret_sts_success;

1729: || ' material_detail_id '
1730: || p_matl_dtl_rec.material_detail_id);
1731: END IF;
1732:
1733: x_return_status := fnd_api.g_ret_sts_success;
1734:
1735: -- The line may not have been fully populated so retrieve it if necessary
1736: -- ======================================================================
1737: IF p_matl_dtl_rec.line_type is NULL THEN

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

1769: || ' number of reservations is '
1770: || l_rsv_count);
1771: END IF;
1772:
1773: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1774: IF g_debug <= gme_debug.g_log_statement THEN
1775: gme_debug.put_line
1776: ( g_pkg_name
1777: || '.'

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

1820: || x_return_status );
1821: END IF;
1822:
1823: IF (x_return_status IN
1824: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1825: RAISE notify_CSR_err;
1826: END IF;
1827:
1828: IF g_debug <= gme_debug.g_log_procedure THEN

Line 1837: , p_init_msg_lst => fnd_api.g_true

1833: END IF;
1834:
1835: inv_reservation_pub.delete_reservation
1836: ( p_api_version_number => 1.0
1837: , p_init_msg_lst => fnd_api.g_true
1838: , x_return_status => x_return_status
1839: , x_msg_count => x_msg_count
1840: , x_msg_data => x_msg_data
1841: , p_rsv_rec => l_rsv_rec

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

1850: END IF;
1851:
1852:
1853: IF (x_return_status IN
1854: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
1855: RAISE delete_reservation_err;
1856: END IF;
1857:
1858: END LOOP;

Line 1877: x_return_status := fnd_api.g_ret_sts_error;

1873: ( 'gme_supply_res_pvt.notify_CSR failure ');
1874: gme_debug.put_line ('error message is ' || x_msg_data);
1875: END IF;
1876: WHEN matl_fetch_error THEN
1877: x_return_status := fnd_api.g_ret_sts_error;
1878: WHEN OTHERS THEN
1879: IF g_debug <= gme_debug.g_log_unexpected THEN
1880: gme_debug.put_line ( 'When others exception in '
1881: || g_pkg_name

Line 1889: x_return_status := fnd_api.g_ret_sts_unexp_error;

1885: || SQLERRM);
1886: END IF;
1887:
1888: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890:
1891: END delete_prod_supply_resv;
1892:
1893: PROCEDURE delete_batch_prod_supply_resv (

Line 1921: x_return_status := fnd_api.g_ret_sts_success;

1917: || ' batch_id => '
1918: || p_batch_header_rec.batch_id);
1919: END IF;
1920:
1921: x_return_status := fnd_api.g_ret_sts_success;
1922:
1923: -- Query all the reservations agains this batch as a source of supply
1924: l_matl_dtl_rec.batch_id := p_batch_header_rec.batch_id;
1925: GME_SUPPLY_RES_PVT.query_prod_supply_reservations

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

1944: || ' number of reservations is '
1945: || l_rsv_count);
1946: END IF;
1947:
1948: IF (x_return_status <> fnd_api.g_ret_sts_success) THEN
1949: IF g_debug <= gme_debug.g_log_statement THEN
1950: gme_debug.put_line
1951: ( g_pkg_name
1952: || '.'

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

1999: -- This will advise the sales representative of the deletion
2000: -- =========================================================
2001:
2002: IF (x_return_status IN
2003: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
2004: RAISE notify_CSR_err;
2005: END IF;
2006:
2007: IF g_debug <= gme_debug.g_log_procedure THEN

Line 2016: , p_init_msg_lst => fnd_api.g_true

2012: END IF;
2013:
2014: inv_reservation_pub.delete_reservation
2015: ( p_api_version_number => 1.0
2016: , p_init_msg_lst => fnd_api.g_true
2017: , x_return_status => x_return_status
2018: , x_msg_count => x_msg_count
2019: , x_msg_data => x_msg_data
2020: , p_rsv_rec => l_rsv_rec

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

2029: END IF;
2030:
2031:
2032: IF (x_return_status IN
2033: (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) ) THEN
2034: RAISE delete_reservation_err;
2035: END IF;
2036:
2037: END LOOP;

Line 2056: x_return_status := fnd_api.g_ret_sts_error;

2052: ( 'gme_supply_res_pvt.notify_CSR failure ');
2053: gme_debug.put_line ('error message is ' || x_msg_data);
2054: END IF;
2055: WHEN matl_fetch_error THEN
2056: x_return_status := fnd_api.g_ret_sts_error;
2057: WHEN OTHERS THEN
2058: IF g_debug <= gme_debug.g_log_unexpected THEN
2059: gme_debug.put_line ( 'When others exception in '
2060: || g_pkg_name

Line 2068: x_return_status := fnd_api.g_ret_sts_unexp_error;

2064: || SQLERRM);
2065: END IF;
2066:
2067: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
2068: x_return_status := fnd_api.g_ret_sts_unexp_error;
2069:
2070: END delete_batch_prod_supply_resv;
2071:
2072: END GME_SUPPLY_RES_PVT;