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

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

8: -- trace : TO log all message
9: -----------------------------------------------------
10: PROCEDURE trace(p_msg IN VARCHAR2) IS
11:
12: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
13: BEGIN
14: IF (l_debug = 1) THEN
15: inv_trx_util_pub.trace(p_msg,'WMS_EPC_PVT', 9);
16: END IF;

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

143: l_outermost_lpn_id NUMBER;
144: l_lpn_item_id NUMBER;
145: l_uom_code VARCHAR2(3);
146: l_rev VARCHAR2(3);
147: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
148: BEGIN
149: --to be called from the Rules Engine
150: --Rules engine will look in to WMS_label_requestes table to get thte
151: --lpn_id AND pass it TO this api.

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

296: PRAGMA AUTONOMOUS_TRANSACTION;
297:
298: l_cur_serial_num NUMBER;
299: l_new_serial NUMBER := 0; --Just some random start value for a NEW GTIN
300: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
301: BEGIN
302:
303: -- See if there are records in the table for this GTIN
304: -- trace('P_gtin :'||p_gtin);

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

399: l_uom_code VARCHAR2(3);
400: l_found_gtin NUMBER;
401: l_gtin NUMBER;
402: l_rev_id NUMBER;
403: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
404: BEGIN
405:
406: x_return_status := fnd_api.g_ret_sts_success;
407:

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

616: l_total_qty NUMBER :=0;
617: l_found_gtin NUMBER := 0;
618: l_rev VARCHAR2(3);
619: l_uom_code VARCHAR2(3);
620: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
621: l_gtin NUMBER;
622: l_is_gtin_valid BOOLEAN := TRUE;
623:
624: l_total_wlc_qty NUMBER;

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

1069: l_pri_qty NUMBER;
1070: l_found_gtin NUMBER;
1071: l_uom_code VARCHAR2(3);
1072: l_primary_uom_code VARCHAR2(3);
1073: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1074: BEGIN
1075: x_return_status := fnd_api.g_ret_sts_success;
1076: -- if p_uom_code is NOT primary UOM, get primary qty in primary UOM
1077: -- For the primary qty, get the corresponding UOM conversion

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

1192:
1193:
1194: l_gtin NUMBER;
1195: l_rev_id NUMBER;
1196: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1197: BEGIN
1198:
1199: x_return_status := fnd_api.g_ret_sts_success;
1200:

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

1270: l_is_sscc_valid BOOLEAN;
1271: l_sscc VARCHAR2(30);
1272: l_sscc_len NUMBER;
1273: l_lpn_num_format NUMBER;
1274: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1275:
1276: BEGIN
1277: IF l_debug = 1 then
1278: trace('get_ssc() p_lpn_id,p_org_id :'||p_lpn_id ||','||p_org_id);

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

1345:
1346: PRAGMA AUTONOMOUS_TRANSACTION;
1347:
1348: l_epc_id NUMBER;
1349: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1350: BEGIN
1351:
1352: x_return_status := fnd_api.g_ret_sts_success;
1353:

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

1697: l_total_qty NUMBER :=0;
1698: l_found_gtin NUMBER := 0;
1699: l_rev VARCHAR2(3);
1700: l_uom_code VARCHAR2(3);
1701: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1702: l_gtin NUMBER;
1703:
1704: l_total_wlc_qty NUMBER;
1705: l_total_mmtt_qty NUMBER;

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

2124: from mgd_idencoding_type ;
2125:
2126: l_index NUMBER;
2127: l_epc_type_id NUMBER := NULL;
2128: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2129:
2130: BEGIN
2131: IF l_debug = 1 THEN
2132: trace('Inside Cache_and_get_rule');

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

2292: l_cust_comp_prefix_index NUMBER;
2293: l_comp_prefix_len NUMBER;
2294: l_cross_ref_type NUMBER;
2295: l_epc_category_id NUMBER;
2296: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2297: l_lpn_id NUMBER;
2298: l_serial_number VARCHAR2(30);
2299: l_item_id NUMBER;
2300: l_rev VARCHAR2(3);

Line 2307: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');

2303: pcode mgd_idcode;
2304:
2305: BEGIN
2306:
2307: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');
2308: x_return_status := fnd_api.g_ret_sts_success;
2309:
2310: IF l_debug = 1 THEN
2311: trace('************ inside generate_epc ***********');

Line 2683: l_epc_output_rep := NVL(fnd_profile.value('WMS_EPC_ENCODING'), 2);

2679:
2680:
2681:
2682: --{{ Get the EPC ENCODING defined with the profile 'WMS_EPC_ENCODING'}}
2683: l_epc_output_rep := NVL(fnd_profile.value('WMS_EPC_ENCODING'), 2);
2684: -- 1 : Binary
2685: -- 2 : Hex
2686: -- 3 : Decimal
2687:

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

2888: x_return_status OUT nocopy VARCHAR2,
2889: x_return_mesg OUT nocopy VARCHAR2
2890: ) IS
2891:
2892: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2893:
2894: BEGIN
2895: x_return_status := fnd_api.g_ret_sts_success;
2896: