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.WMS_CONTAINER_PUB dependencies on STANDARD

Line 264: -- Standard Start of API savepoint

260:
261: l_serial_validate VARCHAR2(15);
262:
263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT GENERATE_LPN_PUB;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 267: -- Standard call to check for call compatibility.

263: BEGIN
264: -- Standard Start of API savepoint
265: SAVEPOINT GENERATE_LPN_PUB;
266:
267: -- Standard call to check for call compatibility.
268: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
269: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
270: fnd_msg_pub.ADD;
271: RAISE fnd_api.g_exc_unexpected_error;

Line 472: -- alternative non-standard serial number validation.

468: RAISE fnd_api.g_exc_error;
469: END IF;
470: ELSE
471: -- Subinventory was not given so will need to do
472: -- alternative non-standard serial number validation.
473: OPEN serial_validation_cursor;
474: FETCH serial_validation_cursor INTO l_serial_validate;
475:
476: IF serial_validation_cursor%NOTFOUND THEN

Line 609: -- Standard check of p_commit.

605: END IF;
606:
607: l_progress := 'End of API body';
608:
609: -- Standard check of p_commit.
610: IF fnd_api.to_boolean(p_commit) THEN
611: COMMIT WORK;
612: END IF;
613:

Line 614: -- Standard call to get message count and if count is 1,

610: IF fnd_api.to_boolean(p_commit) THEN
611: COMMIT WORK;
612: END IF;
613:
614: -- Standard call to get message count and if count is 1,
615: -- get message info.
616: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
617: EXCEPTION
618: WHEN FND_API.G_EXC_ERROR THEN

Line 682: -- Standard Start of API savepoint

678: l_new_weight_uom VARCHAR2(3);
679: l_net_weight NUMBER;
680: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
681: BEGIN
682: -- Standard Start of API savepoint
683: SAVEPOINT associate_lpn_pub;
684:
685: -- Standard call to check for call compatibility.
686: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 685: -- Standard call to check for call compatibility.

681: BEGIN
682: -- Standard Start of API savepoint
683: SAVEPOINT associate_lpn_pub;
684:
685: -- Standard call to check for call compatibility.
686: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
687: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
688: fnd_msg_pub.ADD;
689: RAISE fnd_api.g_exc_unexpected_error;

Line 1130: -- Standard check of p_commit.

1126: END IF;
1127:
1128: -- End of API body
1129:
1130: -- Standard check of p_commit.
1131: IF fnd_api.to_boolean(p_commit) THEN
1132: COMMIT WORK;
1133: END IF;
1134:

Line 1135: -- Standard call to get message count and if count is 1,

1131: IF fnd_api.to_boolean(p_commit) THEN
1132: COMMIT WORK;
1133: END IF;
1134:
1135: -- Standard call to get message count and if count is 1,
1136: -- get message info.
1137: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1138: EXCEPTION
1139: WHEN fnd_api.g_exc_error THEN

Line 1200: -- Standard Start of API savepoint

1196: l_serial inv_validate.serial;
1197: l_result NUMBER;
1198: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1199: BEGIN
1200: -- Standard Start of API savepoint
1201: SAVEPOINT create_lpn_pub;
1202:
1203: -- Standard call to check for call compatibility.
1204: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1203: -- Standard call to check for call compatibility.

1199: BEGIN
1200: -- Standard Start of API savepoint
1201: SAVEPOINT create_lpn_pub;
1202:
1203: -- Standard call to check for call compatibility.
1204: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1205: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1206: fnd_msg_pub.ADD;
1207: RAISE fnd_api.g_exc_unexpected_error;

Line 1476: -- Standard check of p_commit.

1472: END IF;
1473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1474: END IF;
1475:
1476: -- Standard check of p_commit.
1477: IF fnd_api.to_boolean(p_commit) THEN
1478: COMMIT WORK;
1479: END IF;
1480:

Line 1481: -- Standard call to get message count and if count is 1,

1477: IF fnd_api.to_boolean(p_commit) THEN
1478: COMMIT WORK;
1479: END IF;
1480:
1481: -- Standard call to get message count and if count is 1,
1482: -- get message info.
1483: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1484: EXCEPTION
1485: WHEN fnd_api.g_exc_error THEN

Line 1592: -- Standard Start of API savepoint

1588: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1589: l_net_weight NUMBER;
1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1591: BEGIN
1592: -- Standard Start of API savepoint
1593: SAVEPOINT modify_lpn_pub;
1594:
1595: -- Standard call to check for call compatibility.
1596: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1595: -- Standard call to check for call compatibility.

1591: BEGIN
1592: -- Standard Start of API savepoint
1593: SAVEPOINT modify_lpn_pub;
1594:
1595: -- Standard call to check for call compatibility.
1596: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1597: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1598: fnd_msg_pub.ADD;
1599: RAISE fnd_api.g_exc_unexpected_error;

Line 1784: -- Standard check of p_commit.

1780: END IF;
1781: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1782: END IF;
1783:
1784: -- Standard check of p_commit.
1785: IF fnd_api.to_boolean(p_commit) THEN
1786: COMMIT WORK;
1787: END IF;
1788:

Line 1789: -- Standard call to get message count and if count is 1,

1785: IF fnd_api.to_boolean(p_commit) THEN
1786: COMMIT WORK;
1787: END IF;
1788:
1789: -- Standard call to get message count and if count is 1,
1790: -- get message info.
1791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1792: EXCEPTION
1793: WHEN fnd_api.g_exc_error THEN

Line 1845: -- Standard Start of API savepoint

1841: l_lpn lpn;
1842: l_result NUMBER;
1843: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1844: BEGIN
1845: -- Standard Start of API savepoint
1846: SAVEPOINT modify_lpn_wrapper_pub;
1847:
1848: -- Standard call to check for call compatibility.
1849: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 1848: -- Standard call to check for call compatibility.

1844: BEGIN
1845: -- Standard Start of API savepoint
1846: SAVEPOINT modify_lpn_wrapper_pub;
1847:
1848: -- Standard call to check for call compatibility.
1849: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1850: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1851: fnd_msg_pub.ADD;
1852: RAISE fnd_api.g_exc_unexpected_error;

Line 1909: -- Standard check of p_commit.

1905: END IF;
1906:
1907: -- End of API body
1908:
1909: -- Standard check of p_commit.
1910: IF fnd_api.to_boolean(p_commit) THEN
1911: COMMIT WORK;
1912: END IF;
1913:

Line 1914: -- Standard call to get message count and if count is 1,

1910: IF fnd_api.to_boolean(p_commit) THEN
1911: COMMIT WORK;
1912: END IF;
1913:
1914: -- Standard call to get message count and if count is 1,
1915: -- get message info.
1916: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1917: EXCEPTION
1918: WHEN fnd_api.g_exc_error THEN

Line 2163: -- Standard Start of API savepoint

2159: l_temp_uom_code VARCHAR2(3);
2160: l_temp_count NUMBER;
2161: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2162: BEGIN
2163: -- Standard Start of API savepoint
2164: SAVEPOINT packunpack_container_pub;
2165:
2166: -- Standard call to check for call compatibility.
2167: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2166: -- Standard call to check for call compatibility.

2162: BEGIN
2163: -- Standard Start of API savepoint
2164: SAVEPOINT packunpack_container_pub;
2165:
2166: -- Standard call to check for call compatibility.
2167: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2168: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2169: fnd_msg_pub.ADD;
2170: RAISE fnd_api.g_exc_unexpected_error;

Line 2423: -- alternative non-standard lot number validation.

2419: END IF;
2420: END IF;
2421: ELSE
2422: -- Subinventory was not given so will need to do
2423: -- alternative non-standard lot number validation.
2424: OPEN lot_validation_cursor;
2425: FETCH lot_validation_cursor INTO l_temp_lot_exist;
2426:
2427: IF lot_validation_cursor%NOTFOUND THEN

Line 2558: -- need to do alternative non-standard serial number validation.

2554: END IF;
2555: ELSE
2556: -- Either the subinventory was not given or
2557: -- the serial number was dynamically generated. We will
2558: -- need to do alternative non-standard serial number validation.
2559: OPEN serial_validation_cursor;
2560: FETCH serial_validation_cursor INTO l_temp_serial_exist;
2561:
2562: IF serial_validation_cursor%NOTFOUND THEN

Line 2711: -- Standard check of p_commit.

2707: END IF;
2708:
2709: -- End of API body
2710:
2711: -- Standard check of p_commit.
2712: IF fnd_api.to_boolean(p_commit) THEN
2713: COMMIT WORK;
2714: END IF;
2715:

Line 2716: -- Standard call to get message count and if count is 1,

2712: IF fnd_api.to_boolean(p_commit) THEN
2713: COMMIT WORK;
2714: END IF;
2715:
2716: -- Standard call to get message count and if count is 1,
2717: -- get message info.
2718: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2719: EXCEPTION
2720: WHEN fnd_api.g_exc_error THEN

Line 2797: -- Standard Start of API savepoint

2793: l_table_index BINARY_INTEGER;
2794: l_dynamic_status NUMBER;
2795: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2796: BEGIN
2797: -- Standard Start of API savepoint
2798: SAVEPOINT pack_prepack_container_pub;
2799:
2800: -- Standard call to check for call compatibility.
2801: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 2800: -- Standard call to check for call compatibility.

2796: BEGIN
2797: -- Standard Start of API savepoint
2798: SAVEPOINT pack_prepack_container_pub;
2799:
2800: -- Standard call to check for call compatibility.
2801: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2802: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2803: fnd_msg_pub.ADD;
2804: RAISE fnd_api.g_exc_unexpected_error;

Line 2981: -- need to do alternative non-standard serial number validation.

2977: NULL;
2978: ELSE
2979: -- Either the subinventory was not given or
2980: -- the serial number was dynamically generated. We will
2981: -- need to do alternative non-standard serial number validation.
2982: OPEN serial_validation_cursor;
2983: FETCH serial_validation_cursor INTO l_temp_serial_exist;
2984:
2985: IF serial_validation_cursor%NOTFOUND THEN

Line 3081: -- Standard check of p_commit.

3077: END IF;
3078:
3079: -- End of API body
3080:
3081: -- Standard check of p_commit.
3082: IF fnd_api.to_boolean(p_commit) THEN
3083: COMMIT WORK;
3084: END IF;
3085:

Line 3086: -- Standard call to get message count and if count is 1,

3082: IF fnd_api.to_boolean(p_commit) THEN
3083: COMMIT WORK;
3084: END IF;
3085:
3086: -- Standard call to get message count and if count is 1,
3087: -- get message info.
3088: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3089: EXCEPTION
3090: WHEN fnd_api.g_exc_error THEN

Line 3214: -- Standard Start of API savepoint

3210: x_msg_data VARCHAR2(300);
3211: ret BOOLEAN;
3212: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3213: BEGIN
3214: -- Standard Start of API savepoint
3215: SAVEPOINT prepack_lpn_cp_pub;
3216:
3217: -- Standard call to check for call compatibility.
3218: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

Line 3217: -- Standard call to check for call compatibility.

3213: BEGIN
3214: -- Standard Start of API savepoint
3215: SAVEPOINT prepack_lpn_cp_pub;
3216:
3217: -- Standard call to check for call compatibility.
3218: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3219: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3220: fnd_msg_pub.ADD;
3221: RAISE fnd_api.g_exc_unexpected_error;

Line 3273: -- Standard check of p_commit.

3269: END IF;
3270:
3271: -- End of API body
3272:
3273: -- Standard check of p_commit.
3274: IF fnd_api.to_boolean(p_commit) THEN
3275: COMMIT WORK;
3276: END IF;
3277:

Line 3278: -- Standard call to get message count and if count is 1,

3274: IF fnd_api.to_boolean(p_commit) THEN
3275: COMMIT WORK;
3276: END IF;
3277:
3278: -- Standard call to get message count and if count is 1,
3279: -- get message info.
3280: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3281: EXCEPTION
3282: WHEN fnd_api.g_exc_error THEN

Line 3376: -- Standard call to check for call compatibility.

3372: l_org inv_validate.org;
3373: l_lpn LPN;
3374:
3375: BEGIN
3376: -- Standard call to check for call compatibility.
3377: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3378: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3379: fnd_msg_pub.ADD;
3380: RAISE fnd_api.g_exc_error;

Line 3500: -- Standard call to check for call compatibility.

3496: l_org inv_validate.org;
3497: l_lpn LPN;
3498:
3499: BEGIN
3500: -- Standard call to check for call compatibility.
3501: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3502: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3503: fnd_msg_pub.ADD;
3504: RAISE fnd_api.g_exc_error;

Line 3624: -- Standard call to check for call compatibility.

3620: l_org inv_validate.org;
3621: l_lpn LPN;
3622:
3623: BEGIN
3624: -- Standard call to check for call compatibility.
3625: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3626: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3627: fnd_msg_pub.ADD;
3628: RAISE fnd_api.g_exc_error;