APPS.WMS_UTILITY_PVT dependencies on FND_PROFILE

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

27: Cursor Get_FileDebugDir IS
28: select rtrim(ltrim(value)) from v$parameter
29: where upper(name) = 'UTL_FILE_DIR';
30:
31: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
32: BEGIN
33: open Get_FileDebugDir;
34: fetch Get_FileDebugDir into l_write_dir;
35: IF(l_write_dir IS NULL) THEN

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

60: -- ======================================================
61:
62: PROCEDURE file_debug(line in varchar2) IS
63:
64: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
65: BEGIN
66: if (pg_file_name is not null) then
67:
68: -- dbms_output.put_line('pg_file_name ' || pg_file_name);

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

83: x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER,
84: x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
85: ) IS
86:
87: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
88: BEGIN
89:
90: if (pg_file_name is null) then
91: pg_fp := utl_file.fopen(p_path_name, p_file_name, 'a',32767);

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

114: -- Function : Close the logfile
115:
116: -- ===========================================
117: PROCEDURE disable_file_debug is
118: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
119: BEGIN
120: if (pg_file_name is not null) THEN
121: utl_file.fclose(pg_fp);
122: end if;

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

136: , p_parent_lpn_id IN NUMBER )
137: RETURN NUMBER
138: IS
139: l_transaction_id NUMBER;
140: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
141: BEGIN
142:
143: SELECT MIN(mmt.transaction_id)
144: INTO l_transaction_id

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

177: , p_parent_lpn_id IN NUMBER )
178: RETURN NUMBER
179: IS
180: l_transaction_id NUMBER;
181: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
182: BEGIN
183:
184: SELECT MAX(mmt.transaction_id)
185: INTO l_transaction_id