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.AHL_RSV_RESERVATIONS_PVT dependencies on INV_RESERVATION_PUB

Line 304: 'Calling WMS api:inv_reservation_pub.create_reservation'

300: fnd_log.string
301: (
302: fnd_log.level_statement,
303: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
304: 'Calling WMS api:inv_reservation_pub.create_reservation'
305: );
306: END IF;
307:
308: inv_reservation_pub.create_reservation

Line 308: inv_reservation_pub.create_reservation

304: 'Calling WMS api:inv_reservation_pub.create_reservation'
305: );
306: END IF;
307:
308: inv_reservation_pub.create_reservation
309: (
310: p_api_version_number => l_api_version,
311: p_init_msg_lst => l_init_msg_list,
312: x_return_status => l_return_status,

Line 338: 'Calling WMS api:inv_reservation_pub.update_reservation'

334: fnd_log.string
335: (
336: fnd_log.level_statement,
337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
338: 'Calling WMS api:inv_reservation_pub.update_reservation'
339: );
340: END IF;
341: inv_reservation_pub.update_reservation
342: (

Line 341: inv_reservation_pub.update_reservation

337: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
338: 'Calling WMS api:inv_reservation_pub.update_reservation'
339: );
340: END IF;
341: inv_reservation_pub.update_reservation
342: (
343: p_api_version_number => l_api_version,
344: p_init_msg_lst => l_init_msg_list,
345: x_return_status => l_return_status,

Line 664: 'Calling WMS api:inv_reservation_pub.update_reservation'

660: fnd_log.string
661: (
662: fnd_log.level_statement,
663: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
664: 'Calling WMS api:inv_reservation_pub.update_reservation'
665: );
666: END IF;
667: -- Call WMS Update reservation API
668: inv_reservation_pub.update_reservation

Line 668: inv_reservation_pub.update_reservation

664: 'Calling WMS api:inv_reservation_pub.update_reservation'
665: );
666: END IF;
667: -- Call WMS Update reservation API
668: inv_reservation_pub.update_reservation
669: (
670: p_api_version_number => l_api_version,
671: p_init_msg_lst => l_init_msg_list,
672: x_return_status => l_return_status,

Line 973: 'About to Call inv_reservation_pub.delete_reservation with l_reservation_id: ' || l_reservation_id);

969:
970: IF (l_reservation_id IS NOT NULL) THEN
971: IF (l_log_statement >= l_log_current_level) THEN
972: fnd_log.string(fnd_log.level_statement, l_debug_module,
973: 'About to Call inv_reservation_pub.delete_reservation with l_reservation_id: ' || l_reservation_id);
974: END IF;
975:
976: -- Assign the reservation id to be deleted
977: l_rsv_rec.reservation_id := l_reservation_id;

Line 979: inv_reservation_pub.delete_reservation

975:
976: -- Assign the reservation id to be deleted
977: l_rsv_rec.reservation_id := l_reservation_id;
978: -- Call the WMS api
979: inv_reservation_pub.delete_reservation
980: (
981: p_api_version_number => l_api_version,
982: p_init_msg_lst => l_init_msg_list,
983: x_return_status => l_return_status,

Line 991: 'Returned from inv_reservation_pub.delete_reservation, l_return_status: ' || l_return_status);

987: p_serial_number => l_serial_number_tbl
988: );
989: IF (l_log_statement >= l_log_current_level) THEN
990: fnd_log.string(fnd_log.level_statement, l_debug_module,
991: 'Returned from inv_reservation_pub.delete_reservation, l_return_status: ' || l_return_status);
992: END IF;
993: -- Check whether the return status is success, if not raise exception
994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
995: -- log the error

Line 998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');

994: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
995: -- log the error
996: IF (l_log_error >= l_log_current_level) THEN
997: fnd_log.string(fnd_log.level_error, l_debug_module,
998: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR');
999: END IF;
1000: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error

Line 1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');

1001: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1002: -- log the error
1003: IF (l_log_error >= l_log_current_level) THEN
1004: fnd_log.string(fnd_log.level_error, l_debug_module,
1005: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR');
1006: END IF;
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: END IF; -- l_reservation_id IS NOT NULL

Line 1023: 'Going to Call inv_reservation_pub.delete_reservation l_reservation_id :' || l_reservation_id

1019: fnd_log.string
1020: (
1021: fnd_log.level_statement,
1022: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1023: 'Going to Call inv_reservation_pub.delete_reservation l_reservation_id :' || l_reservation_id
1024: );
1025: END IF;
1026:
1027: -- Assign the reservation id to be deleted

Line 1030: inv_reservation_pub.delete_reservation

1026:
1027: -- Assign the reservation id to be deleted
1028: l_rsv_rec.reservation_id := l_reservation_id;
1029: -- Call the WMS api
1030: inv_reservation_pub.delete_reservation
1031: (
1032: p_api_version_number => l_api_version,
1033: p_init_msg_lst => l_init_msg_list,
1034: x_return_status => l_return_status,

Line 1045: 'After call inv_reservation_pub.delete_reservation,l_return_status :' || l_return_status

1041: fnd_log.string
1042: (
1043: fnd_log.level_statement,
1044: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1045: 'After call inv_reservation_pub.delete_reservation,l_return_status :' || l_return_status
1046: );
1047: END IF;
1048: -- Check whether the return status is success, if not raise exception
1049: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'

1052: fnd_log.string
1053: (
1054: fnd_log.level_error,
1055: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1056: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_UNEXP_ERROR'
1057: );
1058: END IF;
1059: CLOSE get_reservation_csr;
1060: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'

1064: fnd_log.string
1065: (
1066: fnd_log.level_error,
1067: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1068: 'inv_reservation_pub.delete_reservation returned FND_API.G_RET_STS_ERROR'
1069: );
1070: END IF;
1071: CLOSE get_reservation_csr;
1072: RAISE FND_API.G_EXC_ERROR;

Line 1424: inv_reservation_pub.relieve_reservation(

1420: l_rsv_rec.reservation_id := l_reservation_id;
1421: l_serial_number_tbl(1).serial_number := p_serial_number;
1422: l_serial_number_tbl(1).inventory_item_id := l_get_mtl_req_dtls_rec.inventory_item_id;
1423:
1424: inv_reservation_pub.relieve_reservation(
1425: p_api_version_number => l_api_version,
1426: p_init_msg_lst => l_init_msg_list,
1427: x_return_status => l_return_status,
1428: x_msg_count => l_msg_count,

Line 1683: 'Before Calling inv_reservation_pub.transfer_reservation'

1679: IF (l_log_statement >= l_log_current_level) THEN
1680: fnd_log.string
1681: (
1682: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1683: 'Before Calling inv_reservation_pub.transfer_reservation'
1684: );
1685: fnd_log.string
1686: (
1687: fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,

Line 1714: inv_reservation_pub.transfer_reservation

1710:
1711: END IF;
1712:
1713: -- Call the WMS Transfer Reservaion API
1714: inv_reservation_pub.transfer_reservation
1715: (
1716: p_api_version_number => l_api_version,
1717: p_init_msg_lst => l_init_msg_list,
1718: x_return_status => l_return_status,

Line 1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

1734: fnd_log.string
1735: (
1736: fnd_log.level_error,
1737: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1738: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
1739: );
1740: END IF;
1741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1742: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

1746: fnd_log.string
1747: (
1748: fnd_log.level_error,
1749: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
1750: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
1751: );
1752: END IF;
1753: RAISE FND_API.G_EXC_ERROR;
1754: END IF;

Line 2061: inv_reservation_pub.update_reservation

2057: l_to_rsv_rec.requirement_date := l_get_mtl_req_id_rec.requested_date;
2058: l_to_rsv_rec.demand_source_line_detail := l_get_mtl_req_id_rec.scheduled_material_id;
2059:
2060: -- Call WMS Update reservation API
2061: inv_reservation_pub.update_reservation
2062: (
2063: p_api_version_number => l_api_version,
2064: p_init_msg_lst => l_init_msg_list,
2065: x_return_status => l_return_status,

Line 2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'

2080: fnd_log.string
2081: (
2082: fnd_log.level_statement,
2083: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2084: 'inv_reservation_pub.update_reservation returned UNEXPECTED ERROR'
2085: );
2086: END IF;
2087: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2088: --RAISE FND_API.G_EXC_ERROR;

Line 2096: 'inv_reservation_pub.update_reservation returned EXPECTED ERROR'

2092: fnd_log.string
2093: (
2094: fnd_log.level_statement,
2095: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2096: 'inv_reservation_pub.update_reservation returned EXPECTED ERROR'
2097: );
2098: END IF;
2099: END IF;
2100: END LOOP;

Line 2209: inv_reservation_pub.delete_reservation

2205: FETCH get_del_rsv_csr INTO l_reservation_id;
2206: EXIT WHEN get_del_rsv_csr%NOTFOUND;
2207: l_rsv_rec.reservation_id := l_reservation_id;
2208: -- Call WMS delete reservation API
2209: inv_reservation_pub.delete_reservation
2210: (
2211: p_api_version_number => l_api_version,
2212: p_init_msg_lst => l_init_msg_list,
2213: x_return_status => l_return_status,

Line 2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');

2556: l_to_rsv_rec.demand_source_line_detail := p_to_mat_req_id;
2557:
2558: IF (l_log_statement >= l_log_current_level)THEN
2559: fnd_log.string
2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');
2561: END IF;
2562:
2563: inv_reservation_pub.transfer_reservation
2564: (

Line 2563: inv_reservation_pub.transfer_reservation

2559: fnd_log.string
2560: (fnd_log.level_statement,'ahl.plsql.'||g_pkg_name||'.'||l_api_name,'Calling inv_reservation_pub.transfer_reservation');
2561: END IF;
2562:
2563: inv_reservation_pub.transfer_reservation
2564: (
2565: p_api_version_number => l_api_version,
2566: p_init_msg_lst => l_init_msg_list,
2567: x_return_status => l_return_status,

Line 2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'

2581: fnd_log.string
2582: (
2583: fnd_log.level_error,
2584: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2585: 'inv_reservation_pub.transfer_reservation returned FND_API.G_EXC_ERROR'
2586: );
2587: END IF;
2588: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2589: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'

2591: fnd_log.string
2592: (
2593: fnd_log.level_error,
2594: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name,
2595: 'inv_reservation_pub.transfer_reservation returned FND_API.G_RET_STS_ERROR'
2596: );
2597: END IF;
2598: RAISE FND_API.G_EXC_ERROR;
2599: END IF;