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 667: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

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

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

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

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

1468: , p_result_lot_number IN VARCHAR2
1469: , p_result_inv_item_id IN NUMBER
1470: )
1471: IS
1472: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1473: BEGIN
1474: IF (l_debug = 1)
1475: THEN
1476: print_debug ('Inside Validate_Lot_Translate', 'Validate_Lot_Translate');

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

1587: l_locator_id NUMBER;
1588: l_validation_status VARCHAR2(1);
1589: l_debug NUMBER;
1590: BEGIN
1591: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1592: x_return_status := fnd_api.g_ret_sts_success;
1593: l_validation_status := 'Y';
1594:
1595: FOR i IN 1..p_st_lpn_id_tbl.COUNT LOOP

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

1758: l_lot_status_enabled VARCHAR2 (10);
1759: l_serial_status_enabled VARCHAR2 (10);
1760: l_default_serial_status_id NUMBER;
1761: l_debug NUMBER
1762: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1763: BEGIN
1764: IF ( p_transaction_type_id IS NULL
1765: OR p_lot_number IS NULL
1766: OR p_organization_id IS NULL

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

1922: l_lot_status_enabled VARCHAR2 (10);
1923: l_serial_status_enabled VARCHAR2 (10);
1924: l_default_serial_status_id NUMBER;
1925: l_debug NUMBER
1926: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1927: BEGIN
1928: IF ( p_transaction_type_id IS NULL
1929: OR p_serial_number IS NULL
1930: OR p_organization_id IS NULL

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

2118: l_ret BOOLEAN;
2119: l_status VARCHAR2 (1);
2120: l_industry VARCHAR2 (1);
2121: l_oracle_schema VARCHAR2 (30);
2122: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2123: BEGIN
2124: l_ret :=
2125: fnd_installation.get_app_info ('INV'
2126: , l_status

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

2304: l_count NUMBER := 0;
2305: l_rs_lot_attr_category VARCHAR2 (30);
2306: l_st_lot_attr_category VARCHAR2 (30);
2307: l_debug NUMBER
2308: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2309: BEGIN
2310: -- call to see if the lot attributes is enabled for this item/org/category combination
2311: IF (l_debug = 1)
2312: THEN

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

2960: l_ret BOOLEAN;
2961: l_status VARCHAR2 (1);
2962: l_industry VARCHAR2 (1);
2963: l_oracle_schema VARCHAR2 (30);
2964: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2965: BEGIN
2966: IF (l_debug = 1)
2967: THEN
2968: print_debug ('IN populate_serial_attributes'

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

3035: l_count NUMBER := 0;
3036: l_rs_ser_attr_category VARCHAR2 (30);
3037: l_st_ser_attr_category VARCHAR2 (30);
3038: l_debug NUMBER
3039: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3040: BEGIN
3041: -- call to see if the serial attributes is enabled for this item/org/category combination
3042: IF (l_debug = 1)
3043: THEN

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

3678: l_containerized_flag NUMBER;
3679: l_return_status VARCHAR2 (1);
3680: v_cost_group_id NUMBER;
3681: l_debug NUMBER
3682: := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
3683: BEGIN
3684: -- assign return value first
3685: IF (l_debug = 1)
3686: THEN

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

4070: l_is_serial_control VARCHAR2 (10);
4071: l_return_values VARCHAR2 (1);
4072: l_return_msg VARCHAR2 (200);
4073: l_revision_control VARCHAR2 (5);
4074: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4075: BEGIN
4076: IF (l_debug = 1)
4077: THEN
4078: print_debug ('Inside Validate_Quantity', 'Validate_Quantity');

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

4718: l_validation_status VARCHAR2 (1);
4719: l_primary_uom VARCHAR2(10);
4720:
4721: BEGIN
4722: l_debug := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
4723: l_validation_status := 'Y';
4724: x_return_status := fnd_api.g_ret_sts_success;
4725:
4726: IF (p_transaction_type_id IS NULL)

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

5537: BEGIN
5538: x_validation_status := 'Y';
5539: x_return_status := fnd_api.g_ret_sts_success;
5540:
5541: IF (NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0) = 0)
5542: THEN
5543: l_debug := FALSE;
5544: END IF;
5545:

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

5580: END IF;
5581:
5582: SAVEPOINT initial_state_svpt;
5583: l_restrict_serial_rcpt :=
5584: NVL (fnd_profile.VALUE ('INV_RESTRICT_RCPT_SER'), 2);
5585:
5586: IF (l_debug)
5587: THEN
5588: print_debug ('l_restrict_serial_rcpt ' || l_restrict_serial_rcpt