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_RCV_INTEGRATION_PVT dependencies on FND_PROFILE

Line 55: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

51: g_org_id number; --Bug#8731994
52:
53:
54: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
55: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
56: l_pkg_name VARCHAR2(100) := g_pkg_name||'($Revision: 120.173.12020000.32 $)';
57: BEGIN
58: IF (l_debug = 1) THEN
59: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => l_pkg_name, p_level => p_level);

Line 78: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

74: ,p_ser_if_rowid IN ROWID DEFAULT NULL
75: ,x_epc_column OUT nocopy VARCHAR2
76: ,x_epc_value OUT nocopy VARCHAR2
77: ) IS
78: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
79: l_epc_column VARCHAR2(30);
80: l_epc_value VARCHAR2(100);
81: l_epc_sql VARCHAR2(1000);
82: l_epc_cursor NUMBER;

Line 90: l_epc_column := fnd_profile.value('WMS_EPC_LASN_COL');

86: l_progress VARCHAR2(10);
87: BEGIN
88:
89: IF (p_mode = 1) THEN --LPN
90: l_epc_column := fnd_profile.value('WMS_EPC_LASN_COL');
91: ELSIF (p_mode = 2) THEN -- Serial
92: l_epc_column := fnd_profile.value('WMS_EPC_SASN_COL');
93: ELSE
94: IF l_debug = 1 THEN

Line 92: l_epc_column := fnd_profile.value('WMS_EPC_SASN_COL');

88:
89: IF (p_mode = 1) THEN --LPN
90: l_epc_column := fnd_profile.value('WMS_EPC_LASN_COL');
91: ELSIF (p_mode = 2) THEN -- Serial
92: l_epc_column := fnd_profile.value('WMS_EPC_SASN_COL');
93: ELSE
94: IF l_debug = 1 THEN
95: print_debug('Unsupported mode',4);
96: END IF;

Line 380: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

376: OR (transaction_source_type_id = 4 AND transaction_action_id = 27));
377:
378: l_transaction_temp_id NUMBER;
379:
380: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
381: BEGIN
382:
383: IF p_source_task_id IS NOT NULL THEN
384: IF (p_atf_api_name = g_atf_api_complete) THEN

Line 468: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

464: x_return_status OUT nocopy VARCHAR2,
465: x_msg_count OUT nocopy NUMBER,
466: x_msg_data OUT nocopy VARCHAR2)
467: IS
468: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
469: BEGIN
470: x_return_status := g_ret_sts_success;
471:
472: SELECT msi.lot_control_code

Line 515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

511: l_cur_serial_number VARCHAR2(30);
512: l_serial_numbers varchar30_tb_tp;
513: l_sysdate DATE := Sysdate;
514:
515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
516: l_progress VARCHAR2(15);
517:
518: CURSOR msnt_cur IS
519: SELECT

Line 1119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1115: l_serial_numbers varchar30_tb_tp;
1116: l_lot_numbers varchar30_tb_tp;
1117: l_quantitys number_tb_tp;
1118:
1119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1120: l_progress VARCHAR (15) := '0';
1121: l_asn_lpn_id NUMBER;
1122: l_item_id NUMBER;
1123: l_quantity_to_unpack NUMBER;

Line 1729: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1725: ,p_txn_quantity IN NUMBER DEFAULT NULL
1726: ,p_txn_uom_code IN VARCHAR2 DEFAULT NULL
1727: ,p_ignore_item_controls IN NUMBER :=2 -- 12610461
1728: ) is
1729: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1730: l_progress VARCHAR2(15) := '10';
1731:
1732: l_total_lot_qty NUMBER := 0;
1733: l_total_ser_qty NUMBER := 0;

Line 2277: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2273: l_exists NUMBER;
2274: l_prim_uom_code VARCHAR2(3);
2275:
2276: l_progress VARCHAR2(15) := '0';
2277: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2278:
2279: l_item_id number;
2280: l_to_organization_id number;
2281:

Line 2820: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

2816: l_errorneous_rows NUMBER := 0;
2817: l_msg_count number;
2818: l_msg_data VARCHAR2(2000);
2819: l_return_status VARCHAR2(1);
2820: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2821: l_progress VARCHAR2(15) := '10';
2822:
2823: l_lpn_grp_id NUMBER;
2824:

Line 3090: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3086: , p_parent_parent_txn_type IN VARCHAR2 DEFAULT NULL
3087: , p_quantity IN NUMBER DEFAULT NULL) return NUMBER
3088: IS
3089: l_inspect_status NUMBER;
3090: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3091: BEGIN
3092: l_inspect_status := NULL;
3093:
3094: IF (p_transaction_type = 'RECEIVE' AND

Line 3256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3252: ,x_return_status OUT NOCOPY VARCHAR2
3253: ,x_msg_count OUT NOCOPY NUMBER
3254: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
3255:
3256: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3257: l_progress VARCHAR2(15) := '10';
3258: l_count NUMBER; --bug 5008139
3259: l_comms_nl_trackable_flag mtl_system_items.comms_nl_trackable_flag%type;--Bug6374074
3260: l_destination_type rcv_transactions_interface.destination_type_code%type;--Bug6374074

Line 3488: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3484: ,p_source_name IN VARCHAR2 DEFAULT NULL
3485: ,p_source_header_id IN NUMBER DEFAULT NULL
3486: ,p_source_type_id IN NUMBER DEFAULT NULL) IS
3487:
3488: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3489: l_progress VARCHAR2(15) := '10';
3490: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;
3491:
3492: BEGIN

Line 3659: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

3655: ,x_msg_count OUT NOCOPY NUMBER
3656: ,x_msg_data OUT NOCOPY VARCHAR2
3657: ) is
3658:
3659: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3660: l_progress VARCHAR2(15) := '40400';
3661: l_proc_name VARCHAR2(30) := 'CHECK_REFERENCE';
3662: l_same_doc NUMBER;
3663: l_asn_line_flag VARCHAR2(1);

Line 4111: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

4107: l_operation_type NUMBER;
4108:
4109: l_dummy VARCHAR2(1);
4110:
4111: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4112: l_progress VARCHAR2(15) := '00';
4113: l_proc_name VARCHAR2(30) := 'MAINTAIN_MO_CON';
4114:
4115: -- OPMConvergence

Line 7715: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7711: l_lot_primary_qty NUMBER := 0;
7712: l_lot_txn_qty NUMBER := 0;
7713:
7714: l_progress VARCHAR2(15) := '00';
7715: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7716: l_proc_name VARCHAR2(30) := 'MAINTAIN_MO_WRAPPER';
7717:
7718: -- OPMConvergence
7719: l_lot_sec_qty NUMBER;

Line 7925: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

7921: x_msg_count OUT NOCOPY NUMBER,
7922: x_msg_data OUT NOCOPY VARCHAR2
7923: ) IS
7924:
7925: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7926: l_progress VARCHAR2(15) := '10';
7927:
7928:
7929: l_primary_uom VARCHAR2(3);

Line 10511: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10507: x_msg_count OUT NOCOPY NUMBER,
10508: x_msg_data OUT NOCOPY VARCHAR2
10509: ) is
10510:
10511: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10512:
10513: l_progress VARCHAR2(15) := '10';
10514:
10515: l_msg_count number;

Line 10622: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10618: ;
10619:
10620: l_mln_rec mln_csr%rowtype;
10621:
10622: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10623:
10624: l_progress VARCHAR2(15) := '10';
10625:
10626: l_msg_count number;

Line 10885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10881: x_msg_data OUT NOCOPY VARCHAR2)
10882: is
10883: l_interface_transaction_id NUMBER;
10884:
10885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10886: l_progress VARCHAR2(15) := '10';
10887: l_msg_count number;
10888: l_msg_data VARCHAR2(2000);
10889:

Line 11766: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

11762:
11763: TYPE rs_tb_tp IS TABLE OF c_rs_cursor%ROWTYPE;
11764: l_rs_tb rs_tb_tp;
11765:
11766: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11767: l_progress VARCHAR2(15) := '10';
11768: l_return_status VARCHAR2(1);
11769: l_msg_count NUMBER;
11770: l_msg_data VARCHAR2(2000);

Line 12325: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

12321: x_return_status OUT NOCOPY VARCHAR2,
12322: x_msg_count OUT NOCOPY NUMBER,
12323: x_msg_data OUT NOCOPY VARCHAR2)
12324: is
12325: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12326: l_progress VARCHAR2(15) := '10';
12327: l_msg_count number;
12328: l_msg_data VARCHAR2(2000);
12329:

Line 12510: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

12506: l_source_line_id NUMBER;
12507: l_source_line_detail_id NUMBER;
12508: l_parent_lpn_id NUMBER;
12509:
12510: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12511: l_progress VARCHAR2(15) := '10';
12512: l_msg_count number;
12513: l_msg_data VARCHAR2(2000);
12514: l_lpn_id NUMBER;

Line 12732: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

12728: x_lpn_id OUT nocopy NUMBER
12729: ) return BOOLEAN
12730: is
12731:
12732: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12733: l_progress VARCHAR2(15) := '10';
12734: l_supply_Exists NUMBER;
12735:
12736: BEGIN

Line 12769: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

12765: p_auto_transact_code IN VARCHAR2,
12766: p_to_lpn_context IN NUMBER ) return BOOLEAN
12767: is
12768:
12769: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12770: l_progress VARCHAR2(15) := '10';
12771:
12772: Begin
12773:

Line 12883: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

12879: -- Bug 3714354
12880: and ( lpn_id is not null or license_plate_number is not null )
12881: order by interface_transaction_id;
12882:
12883: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12884:
12885: l_lpn_rec c_explode_lpn%rowtype;
12886:
12887: l_other_txn_exists NUMBER;

Line 13353: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

13349: x_msg_count OUT NOCOPY NUMBER,
13350: x_msg_data OUT NOCOPY VARCHAR2)
13351: is
13352:
13353: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13354: l_progress VARCHAR2(15) := '10';
13355: l_msg_count number;
13356: l_msg_data VARCHAR2(2000);
13357:

Line 13459: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

13455: x_msg_count OUT NOCOPY NUMBER,
13456: x_msg_data OUT NOCOPY VARCHAR2
13457: ) is
13458:
13459: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13460: l_progress VARCHAR2(15) := '10';
13461: l_rti_qty NUMBER;
13462:
13463: l_serial_disc NUMBER;

Line 13865: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

13861: l_lpn_rec c_validate_lpn%rowtype;
13862:
13863: l_progress varchar2(15) := '00';
13864:
13865: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13866:
13867: l_source_header_id NUMBER;
13868: l_asn_type VARCHAR2(10);
13869: l_lpn_context NUMBER;

Line 16659: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

16655: x_return_status OUT NOCOPY VARCHAR2,
16656: x_msg_count OUT NOCOPY NUMBER,
16657: x_msg_data OUT NOCOPY VARCHAR2)
16658: IS
16659: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16660: BEGIN
16661:
16662: x_return_status := g_ret_sts_success;
16663:

Line 16904: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

16900: x_return_status OUT NOCOPY VARCHAR2,
16901: x_msg_count OUT NOCOPY NUMBER,
16902: x_msg_data OUT NOCOPY VARCHAR2)
16903: IS
16904: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16905: BEGIN
16906: x_return_status := g_ret_sts_success;
16907:
16908: IF (l_debug = 1) THEN

Line 17208: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

17204:
17205: l_rti_count NUMBER;
17206:
17207: l_progress VARCHAR2(15) := '0';
17208: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17209:
17210: -- Bug 3395211
17211: l_to_organization_id NUMBER;
17212: l_item_id NUMBER;

Line 18198: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

18194: x_return_status OUT nocopy VARCHAR2,
18195: x_msg_count OUT nocopy NUMBER,
18196: x_msg_data OUT nocopy VARCHAR2)
18197: IS
18198: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18199: l_item_id number;
18200: l_org_id number;
18201: l_uom_code mtl_units_of_measure_vl.uom_code%TYPE;
18202: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;

Line 19080: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.value('INV_RESTRICT_RCPT_SER'),'2');

19076: l_object_id NUMBER;
19077:
19078: l_dummy_lpn NUMBER;
19079:
19080: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.value('INV_RESTRICT_RCPT_SER'),'2');
19081:
19082: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19083: l_progress VARCHAR2(15) := '00';
19084:

Line 19082: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

19078: l_dummy_lpn NUMBER;
19079:
19080: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.value('INV_RESTRICT_RCPT_SER'),'2');
19081:
19082: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
19083: l_progress VARCHAR2(15) := '00';
19084:
19085: l_intransit_type NUMBER := 0;
19086:

Line 19122: l_allow_status_entry VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_ALLOW_ONHAND_STATUS_ENTRY'), 'N'); -- Material Status Enhancement - Tracking bug: 13519864

19118:
19119: --Serial tagging
19120: l_parent_transaction_type VARCHAR2(25);
19121: l_serial_tagged NUMBER := 1; -- Bug 13886318 added initianlization
19122: l_allow_status_entry VARCHAR2(3) := NVL(fnd_profile.VALUE('INV_ALLOW_ONHAND_STATUS_ENTRY'), 'N'); -- Material Status Enhancement - Tracking bug: 13519864
19123: l_default_status_id number := NULL; -- Material Status Enhancement - Tracking bug: 13519864
19124: l_from_subinventory VARCHAR2(10); -- Bug 14269152
19125: l_from_locator_id NUMBER; -- Bug 14269152
19126:

Line 29199: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

29195: WMS_LICENSE_PLATE_NUMBERS WLPN
29196: WHERE
29197: WLPN.LPN_ID = p_lpn_id ;
29198: l_progress VARCHAR2(15) := '00';
29199: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29200: l_exit NUMBER ;
29201: l_lpn_context NUMBER;
29202: l_lpn VARCHAR2(200);
29203: l_lpn_rec c_validate_rec_lpn%rowTYPE;

Line 29397: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

29393:
29394: l_shipped_pr_quantity NUMBER :=0;
29395: l_recd_pr_quantity NUMBER :=0;
29396: l_rti_pr_qty NUMBER :=0;
29397: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
29398: l_progress VARCHAR2(25);
29399: l_rsl_UoM VARCHAR2(3);
29400: l_rsl_pr_UoM VARCHAR2(3);
29401: l_shipped_quantity_tr_uom NUMBER :=0;