DBA Data[Home] [Help]

APPS.GME_SUPPLY_RES_PVT dependencies on INV_RESERVATION_PUB

Line 202: inv_reservation_pub.query_reservation

198: l_fpo_rsv_rec.inventory_item_id := l_inventory_item_id;
199: l_fpo_rsv_rec.supply_source_type_id := 5 ;--inv_reservation_global.g_source_type_wip;
200: l_fpo_rsv_rec.supply_source_header_id := p_fpo_batch_id;
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

Line 290: inv_reservation_pub.transfer_reservation

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

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

1151: l_to_rsv_rec.primary_reservation_quantity := l_transfer_primary;
1152: l_to_rsv_rec.secondary_reservation_quantity := l_transfer_secondary;
1153:
1154: IF (g_debug <= gme_debug.g_log_statement) THEN
1155: gme_debug.put_line ('Calling inv_reservation_pub.transfer_reservation');
1156: END IF;
1157:
1158: inv_reservation_pub.Transfer_Reservation
1159: ( p_api_version_number => 1.0

Line 1158: inv_reservation_pub.Transfer_Reservation

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

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

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

Line 1226: inv_reservation_pub.relieve_reservation

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

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

1288: END IF;
1289: WHEN transfer_reservation_err THEN
1290: IF (g_debug <= gme_debug.g_log_error) THEN
1291: gme_debug.put_line
1292: ( 'terminating due to error in inv_reservation_pub.transfer_reservation ');
1293: gme_debug.put_line ('error message is ' || x_message_list);
1294: END IF;
1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN

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

1294: END IF;
1295: WHEN update_reservation_err THEN
1296: IF (g_debug <= gme_debug.g_log_error) THEN
1297: gme_debug.put_line
1298: ( 'terminating due to error in inv_reservation_pub.update_reservation ');
1299: gme_debug.put_line ('error message is ' || x_message_list);
1300: END IF;
1301: WHEN query_reservation_error THEN
1302: IF (g_debug <= gme_debug.g_log_error) THEN

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

1375: gme_debug.put_line
1376: ( g_pkg_name
1377: || '.'
1378: || l_api_name
1379: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for line'
1380: || p_matl_dtl_rec.material_detail_id);
1381: END IF;
1382: -- If batch_id only supplied,retrieve the reservations against this supply source
1383: -- ==============================================================================

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

1390: gme_debug.put_line
1391: ( g_pkg_name
1392: || '.'
1393: || l_api_name
1394: || ' Calling inv_reservation_pub.query_reservation for reservations against PROD supply for batce'
1395: || p_matl_dtl_rec.batch_id);
1396: END IF;
1397: END IF;
1398:

Line 1399: inv_reservation_pub.query_reservation

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

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

1413: gme_debug.put_line
1414: ( g_pkg_name
1415: || '.'
1416: || l_api_name
1417: || 'Return status from inv_reservation_pub.query_reservation is '
1418: || l_return_status
1419: || ' Error code is '
1420: || l_error_code);
1421: END IF;

Line 1444: ( 'inv_reservation_pub.query_reservation returns '

1440: EXCEPTION
1441: WHEN query_reservation_error THEN
1442: IF (g_debug <= gme_debug.g_log_error) THEN
1443: gme_debug.put_line
1444: ( 'inv_reservation_pub.query_reservation returns '
1445: || x_return_status);
1446: gme_debug.put_line ('error message is ' || x_msg_data);
1447: END IF;
1448:

Line 1636: inv_reservation_pub.delete_reservation

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

Line 1688: inv_reservation_pub.relieve_reservation

1684: || l_secondary_to_unreserve
1685: || ' call relieve_reservation ');
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

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

1732: EXCEPTION
1733: WHEN delete_reservation_err THEN
1734: IF (g_debug <= gme_debug.g_log_error) THEN
1735: gme_debug.put_line
1736: ( 'inv_reservation_pub.delete_reservation failure ');
1737: gme_debug.put_line ('error message is ' || x_msg_data);
1738: END IF;
1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN

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

1738: END IF;
1739: WHEN update_reservation_err THEN
1740: IF (g_debug <= gme_debug.g_log_error) THEN
1741: gme_debug.put_line
1742: ( 'inv_reservation_pub.relieve_reservation failure ');
1743: gme_debug.put_line ('error message is ' || x_msg_data);
1744: END IF;
1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN

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

1744: END IF;
1745: WHEN notify_CSR_err THEN
1746: IF (g_debug <= gme_debug.g_log_error) THEN
1747: gme_debug.put_line
1748: ( 'inv_reservation_pub.update_reservation failure ');
1749: gme_debug.put_line ('error message is ' || x_msg_data);
1750: END IF;
1751:
1752:

Line 1898: inv_reservation_pub.delete_reservation

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

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

1926: EXCEPTION
1927: WHEN delete_reservation_err THEN
1928: IF (g_debug <= gme_debug.g_log_error) THEN
1929: gme_debug.put_line
1930: ( 'inv_reservation_pub.delete_reservation failure ');
1931: gme_debug.put_line ('error message is ' || x_msg_data);
1932: END IF;
1933: WHEN notify_CSR_err THEN
1934: IF (g_debug <= gme_debug.g_log_error) THEN

Line 2077: inv_reservation_pub.delete_reservation

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

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

2105: EXCEPTION
2106: WHEN delete_reservation_err THEN
2107: IF (g_debug <= gme_debug.g_log_error) THEN
2108: gme_debug.put_line
2109: ( 'inv_reservation_pub.delete_reservation failure ');
2110: gme_debug.put_line ('error message is ' || x_msg_data);
2111: END IF;
2112: WHEN notify_CSR_err THEN
2113: IF (g_debug <= gme_debug.g_log_error) THEN