DBA Data[Home] [Help]

APPS.GME_SUPPLY_RES_PVT dependencies on INV_RESERVATION_PUB

Line 186: inv_reservation_pub.query_reservation

182: l_fpo_rsv_rec.inventory_item_id := l_inventory_item_id;
183: l_fpo_rsv_rec.supply_source_type_id := 5 ;--inv_reservation_global.g_source_type_wip;
184: l_fpo_rsv_rec.supply_source_header_id := p_fpo_batch_id;
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

Line 274: inv_reservation_pub.transfer_reservation

270: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty '||l_reserved_qty);
271: gme_debug.put_line(g_pkg_name||'.'||l_api_name || ' new reserved qty2 '||l_reserved_qty2);
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,

Line 1096: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');

1092: l_to_rsv_rec.primary_reservation_quantity := l_transfer_primary;
1093: l_to_rsv_rec.secondary_reservation_quantity := l_transfer_secondary;
1094:
1095: IF (g_debug <= gme_debug.g_log_statement) THEN
1096: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');
1097: END IF;
1098:
1099: inv_reservation_pub.Transfer_Reservation
1100: ( p_api_version_number => 1.0

Line 1099: inv_reservation_pub.Transfer_Reservation

1095: IF (g_debug <= gme_debug.g_log_statement) THEN
1096: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');
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

Line 1113: gme_debug.put_line ('After Calling inv_reservation_pub.transfer_reservation status is '||x_return_status);

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);
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

Line 1167: inv_reservation_pub.relieve_reservation

1163: || l_api_name
1164: || ' Invoke relieve reservation for quantity of '
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

Line 1233: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');

1229: END IF;
1230: WHEN transfer_reservation_err THEN
1231: IF (g_debug <= gme_debug.g_log_error) THEN
1232: gme_debug.put_line
1233: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1234: gme_debug.put_line ('error message is ' || x_message_list);
1235: END IF;
1236: WHEN update_reservation_err THEN
1237: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1239: ( 'terminating due to error in inv_reservation_pub.update_reservation ');

1235: END IF;
1236: WHEN update_reservation_err THEN
1237: IF (g_debug <= gme_debug.g_log_error) THEN
1238: gme_debug.put_line
1239: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1240: gme_debug.put_line ('error message is ' || x_message_list);
1241: END IF;
1242: WHEN query_reservation_error THEN
1243: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1316: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for line'

1312: gme_debug.put_line
1313: ( g_pkg_name
1314: || '.'
1315: || l_api_name
1316: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for line'
1317: || p_matl_dtl_rec.material_detail_id);
1318: END IF;
1319: -- If batch_id only supplied,retrieve the reservations against this supply source
1320: -- ==============================================================================

Line 1331: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for batce'

1327: gme_debug.put_line
1328: ( g_pkg_name
1329: || '.'
1330: || l_api_name
1331: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for batce'
1332: || p_matl_dtl_rec.batch_id);
1333: END IF;
1334: END IF;
1335:

Line 1336: inv_reservation_pub.query_reservation

1332: || p_matl_dtl_rec.batch_id);
1333: END IF;
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

Line 1354: || 'Return status from inv_reservation_pub.query_reservation is '

1350: gme_debug.put_line
1351: ( g_pkg_name
1352: || '.'
1353: || l_api_name
1354: || 'Return status from inv_reservation_pub.query_reservation is '
1355: || l_return_status
1356: || ' Error code is '
1357: || l_error_code);
1358: END IF;

Line 1381: ( 'inv_reservation_pub.query_reservation returns '

1377: EXCEPTION
1378: WHEN query_reservation_error THEN
1379: IF (g_debug <= gme_debug.g_log_error) THEN
1380: gme_debug.put_line
1381: ( 'inv_reservation_pub.query_reservation returns '
1382: || x_return_status);
1383: gme_debug.put_line ('error message is ' || x_msg_data);
1384: END IF;
1385:

Line 1573: inv_reservation_pub.delete_reservation

1569: || l_api_name
1570: || ' about to invoke delete_reservation ');
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

Line 1625: inv_reservation_pub.relieve_reservation

1621: || l_secondary_to_unreserve
1622: || ' call relieve_reservation ');
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

Line 1673: ( 'inv_reservation_pub.delete_reservation failure ');

1669: EXCEPTION
1670: WHEN delete_reservation_err THEN
1671: IF (g_debug <= gme_debug.g_log_error) THEN
1672: gme_debug.put_line
1673: ( 'inv_reservation_pub.delete_reservation failure ');
1674: gme_debug.put_line ('error message is ' || x_msg_data);
1675: END IF;
1676: WHEN update_reservation_err THEN
1677: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1679: ( 'inv_reservation_pub.relieve_reservation failure ');

1675: END IF;
1676: WHEN update_reservation_err THEN
1677: IF (g_debug <= gme_debug.g_log_error) THEN
1678: gme_debug.put_line
1679: ( 'inv_reservation_pub.relieve_reservation failure ');
1680: gme_debug.put_line ('error message is ' || x_msg_data);
1681: END IF;
1682: WHEN notify_CSR_err THEN
1683: IF (g_debug <= gme_debug.g_log_error) THEN

Line 1685: ( 'inv_reservation_pub.update_reservation failure ');

1681: END IF;
1682: WHEN notify_CSR_err THEN
1683: IF (g_debug <= gme_debug.g_log_error) THEN
1684: gme_debug.put_line
1685: ( 'inv_reservation_pub.update_reservation failure ');
1686: gme_debug.put_line ('error message is ' || x_msg_data);
1687: END IF;
1688:
1689:

Line 1835: inv_reservation_pub.delete_reservation

1831: || ' about to invoke delete_reservation for reservation id '
1832: || l_rsv_rec.reservation_id);
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

Line 1867: ( 'inv_reservation_pub.delete_reservation failure ');

1863: EXCEPTION
1864: WHEN delete_reservation_err THEN
1865: IF (g_debug <= gme_debug.g_log_error) THEN
1866: gme_debug.put_line
1867: ( 'inv_reservation_pub.delete_reservation failure ');
1868: gme_debug.put_line ('error message is ' || x_msg_data);
1869: END IF;
1870: WHEN notify_CSR_err THEN
1871: IF (g_debug <= gme_debug.g_log_error) THEN

Line 2014: inv_reservation_pub.delete_reservation

2010: || ' about to invoke delete_reservation for reservation id '
2011: || l_rsv_rec.reservation_id);
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

Line 2046: ( 'inv_reservation_pub.delete_reservation failure ');

2042: EXCEPTION
2043: WHEN delete_reservation_err THEN
2044: IF (g_debug <= gme_debug.g_log_error) THEN
2045: gme_debug.put_line
2046: ( 'inv_reservation_pub.delete_reservation failure ');
2047: gme_debug.put_line ('error message is ' || x_msg_data);
2048: END IF;
2049: WHEN notify_CSR_err THEN
2050: IF (g_debug <= gme_debug.g_log_error) THEN