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

403: p_organization_id IN NUMBER,
404: p_delivery_name IN VARCHAR2,
405: p_lpn_id IN NUMBER)
406: IS
407: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
408: BEGIN
409:
410: IF p_lpn_id IS NOT NULL AND p_lpn_id <> 0 THEN
411:

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

459: p_delivery_id IN NUMBER,
460: p_lpn_id IN NUMBER)
461: IS
462:
463: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
464: BEGIN
465:
466: IF p_delivery_id IS NOT NULL AND p_delivery_id <> 0 THEN
467:

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

601: p_org_id IN NUMBER)
602:
603: IS
604:
605: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
606: BEGIN
607:
608: OPEN x_sub_lov FOR
609:

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

633: p_alias IN VARCHAR2)
634:
635: IS
636:
637: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
638: BEGIN
639:
640: IF p_alias IS NULL THEN
641: get_consolidation_inq_loc_lov(

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

732: p_comp_cons_dels_inq_mode IN VARCHAR2)
733:
734: IS
735:
736: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
737: BEGIN
738:
739: IF p_comp_cons_dels_inq_mode = 'ALL' THEN
740:

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

876: l_count NUMBER;
877: l_order_num VARCHAR2(30);
878: l_loc_id NUMBER;
879:
880: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
881: BEGIN
882:
883: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

879:
880: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
881: BEGIN
882:
883: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
884: x_return_status := FND_API.G_RET_STS_SUCCESS;
885: x_delivery_status := 'N';
886:
887: IF p_inquiry_mode = 1 THEN

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

1269: l_loc_id NUMBER;
1270: l_return_status VARCHAR2(30);
1271: l_lpn1_id NUMBER;
1272:
1273: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1274: BEGIN
1275:
1276: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1277: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

1272:
1273: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1274: BEGIN
1275:
1276: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1277: l_return_status := FND_API.G_RET_STS_SUCCESS;
1278: x_lpn_available := 'Y';
1279:
1280:

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

1460: l_loc_id NUMBER;
1461: l_return_status VARCHAR2(30);
1462: l_lpn1_id NUMBER;
1463:
1464: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1465: BEGIN
1466:
1467: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1468: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

1463:
1464: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1465: BEGIN
1466:
1467: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1468: l_return_status := FND_API.G_RET_STS_SUCCESS;
1469: x_lpn_available := 'Y';
1470:
1471:

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

1630: l_lpns wms_mdc_pvt.number_table_type;
1631: l_deliveries wms_mdc_pvt.number_table_type;
1632: l_allow_packing VARCHAR2(1);
1633: i NUMBER := 1;
1634: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1635: l_to_loc_type NUMBER;
1636: BEGIN
1637: p_user_id := fnd_global.user_id;
1638: SAVEPOINT sp_lpn_mass_move;

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

1635: l_to_loc_type NUMBER;
1636: BEGIN
1637: p_user_id := fnd_global.user_id;
1638: SAVEPOINT sp_lpn_mass_move;
1639: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
1640:
1641: IF (g_trace_on = 1) THEN mydebug('Entered lpn_mass_move: '); END IF;
1642:
1643: invttmtx.tdatechk(org_id => p_org_id,

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

1901: p_org_id IN NUMBER)
1902:
1903: IS
1904:
1905: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1906: BEGIN
1907:
1908: OPEN x_sub_lov FOR
1909:

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

1951: p_alias IN VARCHAR2)
1952:
1953: IS
1954:
1955: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1956: BEGIN
1957:
1958: IF p_alias IS NULL THEN
1959: get_lpn_mass_move_locs_lov(

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

2096: p_from_loc IN VARCHAR2)
2097:
2098: IS
2099:
2100: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2101: BEGIN
2102:
2103: IF p_from_sub IS NULL THEN
2104:

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

2277: p_org_id IN NUMBER)
2278:
2279: IS
2280:
2281: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2282: BEGIN
2283:
2284: OPEN x_loc_lov FOR
2285:

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

2317: p_alias IN VARCHAR2)
2318:
2319: IS
2320:
2321: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2322: BEGIN
2323:
2324: IF p_alias IS NULL THEN
2325: get_empty_cons_loc_lov(

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

2397:
2398: l_loc_rec empty_loc_csr%ROWTYPE;
2399: l_count NUMBER;
2400:
2401: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2402: BEGIN
2403:
2404: x_return_status := 'S';
2405:

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

2448:
2449: l_is_delivery_consolidated VARCHAR2(2) := 'N';
2450: l_count NUMBER := 0;
2451:
2452: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2453: BEGIN
2454:
2455: BEGIN
2456:

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

2532: l_period_id NUMBER;
2533: l_open_past_period BOOLEAN;
2534: l_item_id NUMBER;
2535:
2536: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2537: BEGIN
2538:
2539: SAVEPOINT sp_stg_move;
2540:

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

2541: -- Since the forms-server and MWA server recycles database connections
2542: -- we need to always check for debug profiles values and see if they
2543: -- are different from the values with which it was initialized earlier. If
2544: -- different then reinitialize the debug variables
2545: g_trace_on := fnd_profile.value('INV_DEBUG_TRACE') ;
2546:
2547: IF (g_trace_on = 1) THEN
2548:
2549: IF (l_debug = 1) THEN

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

2928:
2929: PROCEDURE mydebug(msg in varchar2)
2930: IS
2931:
2932: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2933: BEGIN
2934:
2935: inv_mobile_helper_functions.tracelog
2936: (p_err_msg => msg,