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 48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

44: g_lpn_group_id NUMBER;
45: g_epc_group_id NUMBER;
46:
47: PROCEDURE print_debug(p_err_msg VARCHAR2, p_level NUMBER) IS
48: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
49: l_pkg_name VARCHAR2(100) := g_pkg_name||'($Revision: 120.92.12010000.5 $)';
50: BEGIN
51: IF (l_debug = 1) THEN
52: inv_mobile_helper_functions.tracelog(p_err_msg => p_err_msg, p_module => l_pkg_name, p_level => p_level);

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

67: ,p_ser_if_rowid IN ROWID DEFAULT NULL
68: ,x_epc_column OUT nocopy VARCHAR2
69: ,x_epc_value OUT nocopy VARCHAR2
70: ) IS
71: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
72: l_epc_column VARCHAR2(30);
73: l_epc_value VARCHAR2(100);
74: l_epc_sql VARCHAR2(1000);
75: l_epc_cursor NUMBER;

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

79: l_progress VARCHAR2(10);
80: BEGIN
81:
82: IF (p_mode = 1) THEN --LPN
83: l_epc_column := fnd_profile.value('WMS_EPC_LASN_COL');
84: ELSIF (p_mode = 2) THEN -- Serial
85: l_epc_column := fnd_profile.value('WMS_EPC_SASN_COL');
86: ELSE
87: IF l_debug = 1 THEN

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

81:
82: IF (p_mode = 1) THEN --LPN
83: l_epc_column := fnd_profile.value('WMS_EPC_LASN_COL');
84: ELSIF (p_mode = 2) THEN -- Serial
85: l_epc_column := fnd_profile.value('WMS_EPC_SASN_COL');
86: ELSE
87: IF l_debug = 1 THEN
88: print_debug('Unsupported mode',4);
89: END IF;

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

352: OR (transaction_source_type_id = 4 AND transaction_action_id = 27));
353:
354: l_transaction_temp_id NUMBER;
355:
356: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
357: BEGIN
358:
359: IF p_source_task_id IS NOT NULL THEN
360: IF (p_atf_api_name = g_atf_api_complete) THEN

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

440: x_return_status OUT nocopy VARCHAR2,
441: x_msg_count OUT nocopy NUMBER,
442: x_msg_data OUT nocopy VARCHAR2)
443: IS
444: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
445: BEGIN
446: x_return_status := g_ret_sts_success;
447:
448: SELECT msi.lot_control_code

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

487: l_cur_serial_number VARCHAR2(30);
488: l_serial_numbers varchar30_tb_tp;
489: l_sysdate DATE := Sysdate;
490:
491: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
492: l_progress VARCHAR2(15);
493:
494: CURSOR msnt_cur IS
495: SELECT

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

1091: l_serial_numbers varchar30_tb_tp;
1092: l_lot_numbers varchar30_tb_tp;
1093: l_quantitys number_tb_tp;
1094:
1095: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1096: l_progress VARCHAR (15) := '0';
1097: l_asn_lpn_id NUMBER;
1098: l_item_id NUMBER;
1099: l_quantity_to_unpack NUMBER;

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

1699: -- R12
1700: ,p_txn_quantity IN NUMBER DEFAULT NULL
1701: ,p_txn_uom_code IN VARCHAR2 DEFAULT NULL
1702: ) is
1703: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1704: l_progress VARCHAR2(15) := '10';
1705:
1706: l_total_lot_qty NUMBER := 0;
1707: l_total_ser_qty NUMBER := 0;

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

2244: l_exists NUMBER;
2245: l_prim_uom_code VARCHAR2(3);
2246:
2247: l_progress VARCHAR2(15) := '0';
2248: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2249:
2250: l_item_id number;
2251: l_to_organization_id number;
2252:

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

2785: l_errorneous_rows NUMBER := 0;
2786: l_msg_count number;
2787: l_msg_data VARCHAR2(2000);
2788: l_return_status VARCHAR2(1);
2789: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2790: l_progress VARCHAR2(15) := '10';
2791:
2792: l_lpn_grp_id NUMBER;
2793:

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

3199: ,x_return_status OUT NOCOPY VARCHAR2
3200: ,x_msg_count OUT NOCOPY NUMBER
3201: ,x_msg_data OUT NOCOPY VARCHAR2 ) IS
3202:
3203: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3204: l_progress VARCHAR2(15) := '10';
3205: l_count NUMBER; --bug 5008139
3206: l_comms_nl_trackable_flag mtl_system_items.comms_nl_trackable_flag%type;--Bug6374074
3207: l_destination_type rcv_transactions_interface.destination_type_code%type;--Bug6374074

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

3431: ,p_source_name IN VARCHAR2 DEFAULT NULL
3432: ,p_source_header_id IN NUMBER DEFAULT NULL
3433: ,p_source_type_id IN NUMBER DEFAULT NULL) IS
3434:
3435: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3436: l_progress VARCHAR2(15) := '10';
3437: l_lpn_rec WMS_LICENSE_PLATE_NUMBERS%rowtype;
3438:
3439: BEGIN

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

3602: ,x_msg_count OUT NOCOPY NUMBER
3603: ,x_msg_data OUT NOCOPY VARCHAR2
3604: ) is
3605:
3606: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3607: l_progress VARCHAR2(15) := '40400';
3608: l_proc_name VARCHAR2(30) := 'CHECK_REFERENCE';
3609: l_same_doc NUMBER;
3610: l_asn_line_flag VARCHAR2(1);

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

4043: l_operation_type NUMBER;
4044:
4045: l_dummy VARCHAR2(1);
4046:
4047: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4048: l_progress VARCHAR2(15) := '00';
4049: l_proc_name VARCHAR2(30) := 'MAINTAIN_MO_CON';
4050:
4051: -- OPMConvergence

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

7435: l_lot_primary_qty NUMBER := 0;
7436: l_lot_txn_qty NUMBER := 0;
7437:
7438: l_progress VARCHAR2(15) := '00';
7439: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7440: l_proc_name VARCHAR2(30) := 'MAINTAIN_MO_WRAPPER';
7441:
7442: -- OPMConvergence
7443: l_lot_sec_qty NUMBER;

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

7625: x_msg_count OUT NOCOPY NUMBER,
7626: x_msg_data OUT NOCOPY VARCHAR2
7627: ) IS
7628:
7629: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
7630: l_progress VARCHAR2(15) := '10';
7631:
7632:
7633: l_primary_uom VARCHAR2(3);

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

10030: x_msg_count OUT NOCOPY NUMBER,
10031: x_msg_data OUT NOCOPY VARCHAR2
10032: ) is
10033:
10034: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10035:
10036: l_progress VARCHAR2(15) := '10';
10037:
10038: l_msg_count number;

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

10141: ;
10142:
10143: l_mln_rec mln_csr%rowtype;
10144:
10145: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10146:
10147: l_progress VARCHAR2(15) := '10';
10148:
10149: l_msg_count number;

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

10404: x_msg_data OUT NOCOPY VARCHAR2)
10405: is
10406: l_interface_transaction_id NUMBER;
10407:
10408: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10409: l_progress VARCHAR2(15) := '10';
10410: l_msg_count number;
10411: l_msg_data VARCHAR2(2000);
10412:

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

11285:
11286: TYPE rs_tb_tp IS TABLE OF c_rs_cursor%ROWTYPE;
11287: l_rs_tb rs_tb_tp;
11288:
11289: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11290: l_progress VARCHAR2(15) := '10';
11291: l_return_status VARCHAR2(1);
11292: l_msg_count NUMBER;
11293: l_msg_data VARCHAR2(2000);

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

11836: x_return_status OUT NOCOPY VARCHAR2,
11837: x_msg_count OUT NOCOPY NUMBER,
11838: x_msg_data OUT NOCOPY VARCHAR2)
11839: is
11840: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11841: l_progress VARCHAR2(15) := '10';
11842: l_msg_count number;
11843: l_msg_data VARCHAR2(2000);
11844:

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

12021: l_source_line_id NUMBER;
12022: l_source_line_detail_id NUMBER;
12023: l_parent_lpn_id NUMBER;
12024:
12025: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12026: l_progress VARCHAR2(15) := '10';
12027: l_msg_count number;
12028: l_msg_data VARCHAR2(2000);
12029: l_lpn_id NUMBER;

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

12154: x_lpn_id OUT nocopy NUMBER
12155: ) return BOOLEAN
12156: is
12157:
12158: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12159: l_progress VARCHAR2(15) := '10';
12160: l_supply_Exists NUMBER;
12161:
12162: BEGIN

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

12191: p_auto_transact_code IN VARCHAR2,
12192: p_to_lpn_context IN NUMBER ) return BOOLEAN
12193: is
12194:
12195: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12196: l_progress VARCHAR2(15) := '10';
12197:
12198: Begin
12199:

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

12305: -- Bug 3714354
12306: and ( lpn_id is not null or license_plate_number is not null )
12307: order by interface_transaction_id;
12308:
12309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12310:
12311: l_lpn_rec c_explode_lpn%rowtype;
12312:
12313: l_other_txn_exists NUMBER;

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

12775: x_msg_count OUT NOCOPY NUMBER,
12776: x_msg_data OUT NOCOPY VARCHAR2)
12777: is
12778:
12779: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12780: l_progress VARCHAR2(15) := '10';
12781: l_msg_count number;
12782: l_msg_data VARCHAR2(2000);
12783:

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

12881: x_msg_count OUT NOCOPY NUMBER,
12882: x_msg_data OUT NOCOPY VARCHAR2
12883: ) is
12884:
12885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
12886: l_progress VARCHAR2(15) := '10';
12887: l_rti_qty NUMBER;
12888:
12889: l_serial_disc NUMBER;

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

13277: l_lpn_rec c_validate_lpn%rowtype;
13278:
13279: l_progress varchar2(15) := '00';
13280:
13281: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13282:
13283: l_source_header_id NUMBER;
13284: l_asn_type VARCHAR2(10);
13285: l_lpn_context NUMBER;

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

15901: x_return_status OUT NOCOPY VARCHAR2,
15902: x_msg_count OUT NOCOPY NUMBER,
15903: x_msg_data OUT NOCOPY VARCHAR2)
15904: IS
15905: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
15906: BEGIN
15907:
15908: x_return_status := g_ret_sts_success;
15909:

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

16146: x_return_status OUT NOCOPY VARCHAR2,
16147: x_msg_count OUT NOCOPY NUMBER,
16148: x_msg_data OUT NOCOPY VARCHAR2)
16149: IS
16150: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16151: BEGIN
16152: x_return_status := g_ret_sts_success;
16153:
16154: IF (l_debug = 1) THEN

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

16421:
16422: l_rti_count NUMBER;
16423:
16424: l_progress VARCHAR2(15) := '0';
16425: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
16426:
16427: -- Bug 3395211
16428: l_to_organization_id NUMBER;
16429: l_item_id NUMBER;

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

17280: x_return_status OUT nocopy VARCHAR2,
17281: x_msg_count OUT nocopy NUMBER,
17282: x_msg_data OUT nocopy VARCHAR2)
17283: IS
17284: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
17285: BEGIN
17286:
17287: x_return_status := g_ret_sts_success;
17288:

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

18067: l_object_id NUMBER;
18068:
18069: l_dummy_lpn NUMBER;
18070:
18071: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.value('INV_RESTRICT_RCPT_SER'),'2');
18072:
18073: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18074: l_progress VARCHAR2(15) := '00';
18075:

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

18069: l_dummy_lpn NUMBER;
18070:
18071: l_restrict_rcpt_ser VARCHAR2(1) := NVL(fnd_profile.value('INV_RESTRICT_RCPT_SER'),'2');
18072:
18073: L_DEBUG NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
18074: l_progress VARCHAR2(15) := '00';
18075:
18076: l_intransit_type NUMBER := 0;
18077: