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.

[Home] [Help]

APPS.WMS_WIP_INTEGRATION dependencies on FND_PROFILE

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

15:
16: IS
17: l_return_status VARCHAR2(1);
18:
19: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
20: BEGIN
21: l_return_status:= FND_API.G_RET_STS_SUCCESS;
22:
23: UPDATE mtl_txn_request_lines

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

92: CURSOR wip_lpn_comp_lots_csr IS
93: SELECT lot_number
94: FROM wip_lpn_completions_lots
95: WHERE header_id = l_temp_header_id;
96: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
97: BEGIN
98: l_return_status:= FND_API.G_RET_STS_SUCCESS;
99: l_query_result := 0;
100: l_txn_ret:=0;

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

893:
894: IS
895: l_serial_temp_id NUMBER;
896:
897: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
898: BEGIN
899: --Insert into MSNT attributes from WIP tables
900:
901: IF p_serial_flag = 2 THEN

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

1140: v17 VARCHAR2(32);
1141: d19 DATE;
1142: d20 DATE;
1143: -- bug 12708745 end
1144: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1145: BEGIN
1146:
1147: --Update MTLT attributes from WIP tables
1148:

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

1416: l_item_id NUMBER;
1417: l_return_status VARCHAR2(1);
1418: l_object_id NUMBER;
1419:
1420: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1421:
1422: BEGIN
1423:
1424: l_return_status := FND_API.G_RET_STS_SUCCESS;

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

1618: l_object_id NUMBER;
1619: l_status_rec inv_material_status_pub.mtl_status_update_rec_type; --bug4073725
1620: l_status_id NUMBER;--bug4073725
1621:
1622: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1623: BEGIN
1624:
1625: l_return_status := FND_API.G_RET_STS_SUCCESS;
1626:

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

1874: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1875: l_shelf_life_code NUMBER;
1876: l_expiration_date DATE;
1877:
1878: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1879: BEGIN
1880:
1881: l_return_status := FND_API.G_RET_STS_SUCCESS;
1882:

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

2010: l_errorcode NUMBER;
2011: l_padded_length NUMBER;
2012: l_length NUMBER;
2013:
2014: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2015: BEGIN
2016: IF (l_debug = 1) THEN
2017: mydebug('post_completion: procedure post_completion begins');
2018: END IF;

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

2118: )
2119: IS
2120:
2121:
2122: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2123: BEGIN
2124:
2125: IF (l_debug = 1) THEN
2126: mydebug('get_wip_job_info: get_wip_job_info begins');

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

2313: l_wip_entity_type NUMBER;
2314: l_org_id NUMBER;
2315: l_wip_entity_id NUMBER;
2316:
2317: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2318: BEGIN
2319:
2320: IF (l_debug = 1) THEN
2321: mydebug('get_wip_info_for_putaway: get_wip_info_for_putaway begins');

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

2532: l_return_status VARCHAR2(1);
2533: l_msg_data VARCHAR2(2500);
2534: l_msg_count NUMBER;
2535:
2536: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2537: BEGIN
2538:
2539: l_return_status := FND_API.G_RET_STS_SUCCESS;
2540:

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

2602: l_content_lpn_id NUMBER;
2603: l_lot_primary_qty NUMBER;
2604: l_primary_qty NUMBER;
2605: l_lpn_controlled_flag NUMBER;
2606: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2607: BEGIN
2608:
2609: IF (l_debug = 1) THEN
2610: mydebug('transfer_Reservation: transfer_Reservation API begins');

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

2727: PROCEDURE mydebug(msg in varchar2)
2728: IS
2729: l_msg VARCHAR2(5100);
2730: l_ts VARCHAR2(30);
2731: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2732: BEGIN
2733: -- select to_char(sysdate,'MM/DD/YYYY HH:MM:SS') INTO l_ts from dual;
2734: -- l_msg:=l_ts||' '||msg;
2735:

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

2757: l_repetitive_line_id NUMBER;
2758: l_department_id NUMBER;
2759: l_department_code bom_departments.department_code%TYPE;
2760:
2761: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2762: l_project_id NUMBER := NULL ; --Bug6604904
2763: l_task_id NUMBER := NULL ; --Bug6604904
2764:
2765: BEGIN

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

2978: p_business_flow_code IN NUMBER,
2979: x_return_status OUT NOCOPY VARCHAR2)
2980: IS
2981:
2982: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2983: l_errorMsg VARCHAR2(100);
2984: BEGIN
2985:
2986: IF (l_debug = 1) THEN