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 189: -- Standard Start of API savepoint

185:
186: l_serial_validate VARCHAR2(15);
187:
188: BEGIN
189: -- Standard Start of API savepoint
190: SAVEPOINT GENERATE_LPN_PUB;
191:
192: -- Standard call to check for call compatibility.
193: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

188: BEGIN
189: -- Standard Start of API savepoint
190: SAVEPOINT GENERATE_LPN_PUB;
191:
192: -- Standard call to check for call compatibility.
193: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
194: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
195: fnd_msg_pub.ADD;
196: RAISE fnd_api.g_exc_unexpected_error;

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

393: RAISE fnd_api.g_exc_error;
394: END IF;
395: ELSE
396: -- Subinventory was not given so will need to do
397: -- alternative non-standard serial number validation.
398: OPEN serial_validation_cursor;
399: FETCH serial_validation_cursor INTO l_serial_validate;
400:
401: IF serial_validation_cursor%NOTFOUND THEN

Line 532: -- Standard check of p_commit.

528: END IF;
529:
530: l_progress := 'End of API body';
531:
532: -- Standard check of p_commit.
533: IF fnd_api.to_boolean(p_commit) THEN
534: COMMIT WORK;
535: END IF;
536:

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

533: IF fnd_api.to_boolean(p_commit) THEN
534: COMMIT WORK;
535: END IF;
536:
537: -- Standard call to get message count and if count is 1,
538: -- get message info.
539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
540: EXCEPTION
541: WHEN FND_API.G_EXC_ERROR THEN

Line 605: -- Standard Start of API savepoint

601: l_new_weight_uom VARCHAR2(3);
602: l_net_weight NUMBER;
603: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT associate_lpn_pub;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

604: BEGIN
605: -- Standard Start of API savepoint
606: SAVEPOINT associate_lpn_pub;
607:
608: -- Standard call to check for call compatibility.
609: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
610: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
611: fnd_msg_pub.ADD;
612: RAISE fnd_api.g_exc_unexpected_error;

Line 1053: -- Standard check of p_commit.

1049: END IF;
1050:
1051: -- End of API body
1052:
1053: -- Standard check of p_commit.
1054: IF fnd_api.to_boolean(p_commit) THEN
1055: COMMIT WORK;
1056: END IF;
1057:

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

1054: IF fnd_api.to_boolean(p_commit) THEN
1055: COMMIT WORK;
1056: END IF;
1057:
1058: -- Standard call to get message count and if count is 1,
1059: -- get message info.
1060: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1061: EXCEPTION
1062: WHEN fnd_api.g_exc_error THEN

Line 1123: -- Standard Start of API savepoint

1119: l_serial inv_validate.serial;
1120: l_result NUMBER;
1121: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1122: BEGIN
1123: -- Standard Start of API savepoint
1124: SAVEPOINT create_lpn_pub;
1125:
1126: -- Standard call to check for call compatibility.
1127: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1122: BEGIN
1123: -- Standard Start of API savepoint
1124: SAVEPOINT create_lpn_pub;
1125:
1126: -- Standard call to check for call compatibility.
1127: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1128: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1129: fnd_msg_pub.ADD;
1130: RAISE fnd_api.g_exc_unexpected_error;

Line 1399: -- Standard check of p_commit.

1395: END IF;
1396: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1397: END IF;
1398:
1399: -- Standard check of p_commit.
1400: IF fnd_api.to_boolean(p_commit) THEN
1401: COMMIT WORK;
1402: END IF;
1403:

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

1400: IF fnd_api.to_boolean(p_commit) THEN
1401: COMMIT WORK;
1402: END IF;
1403:
1404: -- Standard call to get message count and if count is 1,
1405: -- get message info.
1406: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1407: EXCEPTION
1408: WHEN fnd_api.g_exc_error THEN

Line 1515: -- Standard Start of API savepoint

1511: l_lpn_serial_rec mtl_serial_numbers%ROWTYPE;
1512: l_net_weight NUMBER;
1513: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1514: BEGIN
1515: -- Standard Start of API savepoint
1516: SAVEPOINT modify_lpn_pub;
1517:
1518: -- Standard call to check for call compatibility.
1519: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1514: BEGIN
1515: -- Standard Start of API savepoint
1516: SAVEPOINT modify_lpn_pub;
1517:
1518: -- Standard call to check for call compatibility.
1519: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1520: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1521: fnd_msg_pub.ADD;
1522: RAISE fnd_api.g_exc_unexpected_error;

Line 1707: -- Standard check of p_commit.

1703: END IF;
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: END IF;
1706:
1707: -- Standard check of p_commit.
1708: IF fnd_api.to_boolean(p_commit) THEN
1709: COMMIT WORK;
1710: END IF;
1711:

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

1708: IF fnd_api.to_boolean(p_commit) THEN
1709: COMMIT WORK;
1710: END IF;
1711:
1712: -- Standard call to get message count and if count is 1,
1713: -- get message info.
1714: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1715: EXCEPTION
1716: WHEN fnd_api.g_exc_error THEN

Line 1768: -- Standard Start of API savepoint

1764: l_lpn lpn;
1765: l_result NUMBER;
1766: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1767: BEGIN
1768: -- Standard Start of API savepoint
1769: SAVEPOINT modify_lpn_wrapper_pub;
1770:
1771: -- Standard call to check for call compatibility.
1772: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

1767: BEGIN
1768: -- Standard Start of API savepoint
1769: SAVEPOINT modify_lpn_wrapper_pub;
1770:
1771: -- Standard call to check for call compatibility.
1772: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
1773: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
1774: fnd_msg_pub.ADD;
1775: RAISE fnd_api.g_exc_unexpected_error;

Line 1832: -- Standard check of p_commit.

1828: END IF;
1829:
1830: -- End of API body
1831:
1832: -- Standard check of p_commit.
1833: IF fnd_api.to_boolean(p_commit) THEN
1834: COMMIT WORK;
1835: END IF;
1836:

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

1833: IF fnd_api.to_boolean(p_commit) THEN
1834: COMMIT WORK;
1835: END IF;
1836:
1837: -- Standard call to get message count and if count is 1,
1838: -- get message info.
1839: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1840: EXCEPTION
1841: WHEN fnd_api.g_exc_error THEN

Line 2086: -- Standard Start of API savepoint

2082: l_temp_uom_code VARCHAR2(3);
2083: l_temp_count NUMBER;
2084: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2085: BEGIN
2086: -- Standard Start of API savepoint
2087: SAVEPOINT packunpack_container_pub;
2088:
2089: -- Standard call to check for call compatibility.
2090: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2085: BEGIN
2086: -- Standard Start of API savepoint
2087: SAVEPOINT packunpack_container_pub;
2088:
2089: -- Standard call to check for call compatibility.
2090: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2091: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2092: fnd_msg_pub.ADD;
2093: RAISE fnd_api.g_exc_unexpected_error;

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

2342: END IF;
2343: END IF;
2344: ELSE
2345: -- Subinventory was not given so will need to do
2346: -- alternative non-standard lot number validation.
2347: OPEN lot_validation_cursor;
2348: FETCH lot_validation_cursor INTO l_temp_lot_exist;
2349:
2350: IF lot_validation_cursor%NOTFOUND THEN

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

2476: END IF;
2477: ELSE
2478: -- Either the subinventory was not given or
2479: -- the serial number was dynamically generated. We will
2480: -- need to do alternative non-standard serial number validation.
2481: OPEN serial_validation_cursor;
2482: FETCH serial_validation_cursor INTO l_temp_serial_exist;
2483:
2484: IF serial_validation_cursor%NOTFOUND THEN

Line 2633: -- Standard check of p_commit.

2629: END IF;
2630:
2631: -- End of API body
2632:
2633: -- Standard check of p_commit.
2634: IF fnd_api.to_boolean(p_commit) THEN
2635: COMMIT WORK;
2636: END IF;
2637:

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

2634: IF fnd_api.to_boolean(p_commit) THEN
2635: COMMIT WORK;
2636: END IF;
2637:
2638: -- Standard call to get message count and if count is 1,
2639: -- get message info.
2640: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2641: EXCEPTION
2642: WHEN fnd_api.g_exc_error THEN

Line 2719: -- Standard Start of API savepoint

2715: l_table_index BINARY_INTEGER;
2716: l_dynamic_status NUMBER;
2717: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2718: BEGIN
2719: -- Standard Start of API savepoint
2720: SAVEPOINT pack_prepack_container_pub;
2721:
2722: -- Standard call to check for call compatibility.
2723: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

2718: BEGIN
2719: -- Standard Start of API savepoint
2720: SAVEPOINT pack_prepack_container_pub;
2721:
2722: -- Standard call to check for call compatibility.
2723: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
2724: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
2725: fnd_msg_pub.ADD;
2726: RAISE fnd_api.g_exc_unexpected_error;

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

2899: NULL;
2900: ELSE
2901: -- Either the subinventory was not given or
2902: -- the serial number was dynamically generated. We will
2903: -- need to do alternative non-standard serial number validation.
2904: OPEN serial_validation_cursor;
2905: FETCH serial_validation_cursor INTO l_temp_serial_exist;
2906:
2907: IF serial_validation_cursor%NOTFOUND THEN

Line 3003: -- Standard check of p_commit.

2999: END IF;
3000:
3001: -- End of API body
3002:
3003: -- Standard check of p_commit.
3004: IF fnd_api.to_boolean(p_commit) THEN
3005: COMMIT WORK;
3006: END IF;
3007:

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

3004: IF fnd_api.to_boolean(p_commit) THEN
3005: COMMIT WORK;
3006: END IF;
3007:
3008: -- Standard call to get message count and if count is 1,
3009: -- get message info.
3010: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3011: EXCEPTION
3012: WHEN fnd_api.g_exc_error THEN

Line 3136: -- Standard Start of API savepoint

3132: x_msg_data VARCHAR2(300);
3133: ret BOOLEAN;
3134: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3135: BEGIN
3136: -- Standard Start of API savepoint
3137: SAVEPOINT prepack_lpn_cp_pub;
3138:
3139: -- Standard call to check for call compatibility.
3140: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN

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

3135: BEGIN
3136: -- Standard Start of API savepoint
3137: SAVEPOINT prepack_lpn_cp_pub;
3138:
3139: -- Standard call to check for call compatibility.
3140: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3141: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3142: fnd_msg_pub.ADD;
3143: RAISE fnd_api.g_exc_unexpected_error;

Line 3195: -- Standard check of p_commit.

3191: END IF;
3192:
3193: -- End of API body
3194:
3195: -- Standard check of p_commit.
3196: IF fnd_api.to_boolean(p_commit) THEN
3197: COMMIT WORK;
3198: END IF;
3199:

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

3196: IF fnd_api.to_boolean(p_commit) THEN
3197: COMMIT WORK;
3198: END IF;
3199:
3200: -- Standard call to get message count and if count is 1,
3201: -- get message info.
3202: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
3203: EXCEPTION
3204: WHEN fnd_api.g_exc_error THEN

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

3294: l_org inv_validate.org;
3295: l_lpn LPN;
3296:
3297: BEGIN
3298: -- Standard call to check for call compatibility.
3299: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3300: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3301: fnd_msg_pub.ADD;
3302: RAISE fnd_api.g_exc_error;

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

3418: l_org inv_validate.org;
3419: l_lpn LPN;
3420:
3421: BEGIN
3422: -- Standard call to check for call compatibility.
3423: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3424: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3425: fnd_msg_pub.ADD;
3426: RAISE fnd_api.g_exc_error;

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

3542: l_org inv_validate.org;
3543: l_lpn LPN;
3544:
3545: BEGIN
3546: -- Standard call to check for call compatibility.
3547: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name) THEN
3548: fnd_message.set_name('WMS', 'WMS_CONT_INCOMPATIBLE_API_CALL');
3549: fnd_msg_pub.ADD;
3550: RAISE fnd_api.g_exc_error;