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.INV_LOT_TRX_VALIDATION_PUB dependencies on FND_PROFILE

Line 8: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

4: IS
5: l_debug NUMBER;
6: BEGIN
7:
8: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
9:
10: --dbms_output.put_line(g_pkg_name||'.'||p_module||': ' || p_message);
11: IF (l_debug = 1)
12: THEN

Line 31: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

27: )
28: IS
29: l_wms_installed VARCHAR2 (1);
30: l_debug NUMBER
31: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
32: BEGIN
33: BEGIN
34: inv_txn_validations.check_wms_install
35: (x_return_status => x_wms_installed

Line 192: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

188: l_st_serial_control_code NUMBER;
189: l_rs_lot_control_code NUMBER;
190: l_rs_serial_control_code NUMBER;
191: l_debug NUMBER
192: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
193: BEGIN
194: IF (l_debug = 1)
195: THEN
196: print_debug ('Inside Validate_Lots', 'Validate_Lots');

Line 670: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

666: )
667: IS
668: l_validation_status VARCHAR2 (1);
669: l_debug NUMBER
670: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
671: BEGIN
672: IF (l_debug = 1)
673: THEN
674: print_debug ('Inside Validate Start Lot ', 'Validate_Start_Lot');

Line 949: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

945: l_lot_uniqueness NUMBER;
946: l_lot_count NUMBER;
947: l_inventory_item_id NUMBER;
948: l_debug NUMBER
949: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
950: BEGIN
951: IF (l_debug = 1)
952: THEN
953: print_debug ('Inside Validate_Result_lot', 'Validate_Result_Lot');

Line 1408: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1404: , p_result_lot_number IN VARCHAR2
1405: , p_result_inv_item_id IN NUMBER
1406: )
1407: IS
1408: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1409: BEGIN
1410: IF (l_debug = 1)
1411: THEN
1412: print_debug ('Inside Validate_Lot_Translate', 'Validate_Lot_Translate');

Line 1527: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1523: l_locator_id NUMBER;
1524: l_validation_status VARCHAR2(1);
1525: l_debug NUMBER;
1526: BEGIN
1527: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1528: x_return_status := fnd_api.g_ret_sts_success;
1529: l_validation_status := 'Y';
1530:
1531: FOR i IN 1..p_st_lpn_id_tbl.COUNT LOOP

Line 1699: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1695: l_lot_status_enabled VARCHAR2 (10);
1696: l_serial_status_enabled VARCHAR2 (10);
1697: l_default_serial_status_id NUMBER;
1698: l_debug NUMBER
1699: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1700: BEGIN
1701: IF ( p_transaction_type_id IS NULL
1702: OR p_lot_number IS NULL
1703: OR p_organization_id IS NULL

Line 1864: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1860: l_lot_status_enabled VARCHAR2 (10);
1861: l_serial_status_enabled VARCHAR2 (10);
1862: l_default_serial_status_id NUMBER;
1863: l_debug NUMBER
1864: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1865: BEGIN
1866: IF ( p_transaction_type_id IS NULL
1867: OR p_serial_number IS NULL
1868: OR p_organization_id IS NULL

Line 2071: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2067: l_ret BOOLEAN;
2068: l_status VARCHAR2 (1);
2069: l_industry VARCHAR2 (1);
2070: l_oracle_schema VARCHAR2 (30);
2071: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2072: BEGIN
2073: l_ret :=
2074: fnd_installation.get_app_info ('INV'
2075: , l_status

Line 2257: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2253: l_count NUMBER := 0;
2254: l_rs_lot_attr_category VARCHAR2 (30);
2255: l_st_lot_attr_category VARCHAR2 (30);
2256: l_debug NUMBER
2257: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2258: BEGIN
2259: -- call to see if the lot attributes is enabled for this item/org/category combination
2260: IF (l_debug = 1)
2261: THEN

Line 2923: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2919: l_ret BOOLEAN;
2920: l_status VARCHAR2 (1);
2921: l_industry VARCHAR2 (1);
2922: l_oracle_schema VARCHAR2 (30);
2923: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2924: BEGIN
2925: IF (l_debug = 1)
2926: THEN
2927: print_debug ('IN populate_serial_attributes'

Line 2998: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2994: l_count NUMBER := 0;
2995: l_rs_ser_attr_category VARCHAR2 (30);
2996: l_st_ser_attr_category VARCHAR2 (30);
2997: l_debug NUMBER
2998: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2999: BEGIN
3000: -- call to see if the serial attributes is enabled for this item/org/category combination
3001: IF (l_debug = 1)
3002: THEN

Line 3641: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

3637: l_containerized_flag NUMBER;
3638: l_return_status VARCHAR2 (1);
3639: v_cost_group_id NUMBER;
3640: l_debug NUMBER
3641: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3642: BEGIN
3643: -- assign return value first
3644: IF (l_debug = 1)
3645: THEN

Line 4033: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

4029: l_is_serial_control VARCHAR2 (10);
4030: l_return_values VARCHAR2 (1);
4031: l_return_msg VARCHAR2 (200);
4032: l_revision_control VARCHAR2 (5);
4033: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4034: BEGIN
4035: IF (l_debug = 1)
4036: THEN
4037: print_debug ('Inside Validate_Quantity', 'Validate_Quantity');

Line 4693: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

4689: l_validation_status VARCHAR2 (1);
4690: l_primary_uom VARCHAR2(10);
4691:
4692: BEGIN
4693: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4694: l_validation_status := 'Y';
4695: x_return_status := fnd_api.g_ret_sts_success;
4696:
4697: IF (p_transaction_type_id IS NULL)

Line 5512: IF (NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0) = 0)

5508: BEGIN
5509: x_validation_status := 'Y';
5510: x_return_status := fnd_api.g_ret_sts_success;
5511:
5512: IF (NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0) = 0)
5513: THEN
5514: l_debug := FALSE;
5515: END IF;
5516:

Line 5555: NVL (fnd_profile.VALUE ('INV_RESTRICT_RCPT_SER'), 2);

5551: END IF;
5552:
5553: SAVEPOINT initial_state_svpt;
5554: l_restrict_serial_rcpt :=
5555: NVL (fnd_profile.VALUE ('INV_RESTRICT_RCPT_SER'), 2);
5556:
5557: IF (l_debug)
5558: THEN
5559: print_debug ('l_restrict_serial_rcpt ' || l_restrict_serial_rcpt