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

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

46: l_count NUMBER;
47: l_delivery_id NUMBER;
48: l_locator_id NUMBER;
49:
50: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
51: BEGIN
52:
53: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 53: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

49:
50: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
51: BEGIN
52:
53: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
54: x_return_status := FND_API.G_RET_STS_SUCCESS;
55:
56: x_total_no_of_dels := 0;
57: x_total_no_of_cons_dels := 0;

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

145: * translated environments
146: ********************************/
147: l_type_meaning mfg_lookups.meaning%TYPE;
148:
149: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
150:
151: CURSOR all_locs_csr
152: IS
153: -- need to query from both mil and milk

Line 232: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

228: mydebug('p_org_id : ' ||p_org_id);
229: mydebug('p_comp_cons_dels_inq_mode : ' ||p_comp_cons_dels_inq_mode);
230: END IF;
231:
232: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
233: l_return_status := FND_API.G_RET_STS_SUCCESS;
234: x_loc_available := 'Y';
235: l_loc := (x_loc || '%');
236: x_loc_count := 0;

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

364: p_lpn IN VARCHAR2)
365:
366: IS
367:
368: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
369: BEGIN
370:
371: OPEN x_lpn_lov FOR
372: SELECT DISTINCT

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

408: p_organization_id IN NUMBER,
409: p_delivery_name IN VARCHAR2,
410: p_lpn_id IN NUMBER)
411: IS
412: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
413: BEGIN
414:
415: IF p_lpn_id IS NOT NULL AND p_lpn_id <> 0 THEN
416:

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

464: p_delivery_id IN NUMBER,
465: p_lpn_id IN NUMBER)
466: IS
467:
468: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
469: BEGIN
470:
471: IF p_delivery_id IS NOT NULL AND p_delivery_id <> 0 THEN
472:

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

606: p_org_id IN NUMBER)
607:
608: IS
609:
610: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
611: BEGIN
612:
613: OPEN x_sub_lov FOR
614:

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

638: p_alias IN VARCHAR2)
639:
640: IS
641:
642: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
643: BEGIN
644:
645: IF p_alias IS NULL THEN
646: get_consolidation_inq_loc_lov(

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

737: p_comp_cons_dels_inq_mode IN VARCHAR2)
738:
739: IS
740:
741: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
742: BEGIN
743:
744: IF p_comp_cons_dels_inq_mode = 'ALL' THEN
745:

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

881: l_count NUMBER;
882: l_order_num VARCHAR2(30);
883: l_loc_id NUMBER;
884:
885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
886: BEGIN
887:
888: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 888: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

884:
885: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
886: BEGIN
887:
888: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
889: x_return_status := FND_API.G_RET_STS_SUCCESS;
890: x_delivery_status := 'N';
891:
892: IF p_inquiry_mode = 1 THEN

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

1274: l_loc_id NUMBER;
1275: l_return_status VARCHAR2(30);
1276: l_lpn1_id NUMBER;
1277:
1278: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1279: BEGIN
1280:
1281: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1282: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1281: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

1277:
1278: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1279: BEGIN
1280:
1281: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1282: l_return_status := FND_API.G_RET_STS_SUCCESS;
1283: x_lpn_available := 'Y';
1284:
1285:

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

1465: l_loc_id NUMBER;
1466: l_return_status VARCHAR2(30);
1467: l_lpn1_id NUMBER;
1468:
1469: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1470: BEGIN
1471:
1472: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1473: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1472: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

1468:
1469: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1470: BEGIN
1471:
1472: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1473: l_return_status := FND_API.G_RET_STS_SUCCESS;
1474: x_lpn_available := 'Y';
1475:
1476:

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

1635: l_lpns wms_mdc_pvt.number_table_type;
1636: l_deliveries wms_mdc_pvt.number_table_type;
1637: l_allow_packing VARCHAR2(1);
1638: i NUMBER := 1;
1639: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1640: l_to_loc_type NUMBER;
1641: BEGIN
1642: p_user_id := fnd_global.user_id;
1643: SAVEPOINT sp_lpn_mass_move;

Line 1644: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

1640: l_to_loc_type NUMBER;
1641: BEGIN
1642: p_user_id := fnd_global.user_id;
1643: SAVEPOINT sp_lpn_mass_move;
1644: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1645:
1646: IF (g_trace_on = 1) THEN mydebug('Entered lpn_mass_move: '); END IF;
1647:
1648: invttmtx.tdatechk(org_id => p_org_id,

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

1906: p_org_id IN NUMBER)
1907:
1908: IS
1909:
1910: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1911: BEGIN
1912:
1913: OPEN x_sub_lov FOR
1914:

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

1956: p_alias IN VARCHAR2)
1957:
1958: IS
1959:
1960: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1961: BEGIN
1962:
1963: IF p_alias IS NULL THEN
1964: get_lpn_mass_move_locs_lov(

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

2101: p_from_loc IN VARCHAR2)
2102:
2103: IS
2104:
2105: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2106: BEGIN
2107:
2108: IF p_from_sub IS NULL THEN
2109:

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

2282: p_org_id IN NUMBER)
2283:
2284: IS
2285:
2286: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2287: BEGIN
2288:
2289: OPEN x_loc_lov FOR
2290:

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

2322: p_alias IN VARCHAR2)
2323:
2324: IS
2325:
2326: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2327: BEGIN
2328:
2329: IF p_alias IS NULL THEN
2330: get_empty_cons_loc_lov(

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

2402:
2403: l_loc_rec empty_loc_csr%ROWTYPE;
2404: l_count NUMBER;
2405:
2406: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2407: BEGIN
2408:
2409: x_return_status := 'S';
2410:

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

2453:
2454: l_is_delivery_consolidated VARCHAR2(2) := 'N';
2455: l_count NUMBER := 0;
2456:
2457: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2458: BEGIN
2459:
2460: BEGIN
2461:

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

2540:
2541: -- added for bug# 12687532
2542: l_posting_flag VARCHAR2(1);
2543:
2544: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2545: BEGIN
2546:
2547: SAVEPOINT sp_stg_move;
2548:

Line 2553: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;

2549: -- Since the forms-server and MWA server recycles database connections
2550: -- we need to always check for debug profiles values and see if they
2551: -- are different from the values with which it was initialized earlier. If
2552: -- different then reinitialize the debug variables
2553: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
2554:
2555: IF (g_trace_on = 1) THEN
2556:
2557: IF (l_debug = 1) THEN

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

3022:
3023: PROCEDURE mydebug(msg in varchar2)
3024: IS
3025:
3026: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3027: BEGIN
3028:
3029: inv_mobile_helper_functions.tracelog
3030: (p_err_msg => msg,