APPS.WMS_ZONES_PVT dependencies on FND_PROFILE

Line 102: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

98: END;
99:
100: PROCEDURE DEBUG (p_message IN VARCHAR2, p_module IN VARCHAR2, p_level NUMBER) IS
101:
102: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
103:
104: BEGIN
105: dbms_output.put_line(fnd_profile.VALUE ('INV_DEBUG_FILE'));
106: -- dbms_output.put_line(p_message);

Line 105: dbms_output.put_line(fnd_profile.VALUE ('INV_DEBUG_FILE'));

101:
102: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
103:
104: BEGIN
105: dbms_output.put_line(fnd_profile.VALUE ('INV_DEBUG_FILE'));
106: -- dbms_output.put_line(p_message);
107:
108: IF NOT g_version_printed THEN
109: inv_log_util.TRACE ('$Header: WMSZONEB.pls 120.0 2005/05/25 02:35:41 appldev noship $',

Line 132: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

128: x_return_status OUT NOCOPY VARCHAR2,
129: x_msg_data OUT NOCOPY VARCHAR2
130: ) IS
131:
132: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
133:
134: l_progress_indicator VARCHAR2(10) := '0';
135: l_module_name VARCHAR2(15) := 'POPULATE_GRID';
136:

Line 356: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

352: l_progress VARCHAR2 (10) := '0';
353: l_is_all_locators BOOLEAN := FALSE;
354:
355: l_module_name VARCHAR2 (30) := 'ADD_LOCATORS_TO_GRID';
356: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
357: l_progress_indicator VARCHAR2(10) := '0';
358:
359: -- Zone enhancement
360: l_jtf_message wms_zone_locators_temp.MESSAGE%TYPE;

Line 1392: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1388: p_last_updated_by IN NUMBER,
1389: p_last_update_login IN NUMBER
1390: ) IS
1391:
1392: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1393: l_module_name VARCHAR2(20) := 'INSERT_WMS_ZONES';
1394: l_progress_indicator VARCHAR2(10) := '0';
1395:
1396: l_return_status VARCHAR2(1);

Line 1584: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1580: p_last_update_date IN DATE,
1581: p_last_updated_by IN NUMBER,
1582: p_last_update_login IN NUMBER
1583: ) IS
1584: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1585: l_module_name VARCHAR2(20) := 'UPDATE_WMS_ZONES';
1586: l_progress_indicator VARCHAR2(10) := '0';
1587:
1588: l_return_status VARCHAR2(1);

Line 1740: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

1736: ) IS
1737:
1738: l_progress_indicator VARCHAR2(10) := '0';
1739: l_module_name VARCHAR2(20) := 'SAVE_SEL_LOCATORS';
1740: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1741:
1742: BEGIN
1743:
1744: DEBUG('In procedure :', l_module_name,0);

Line 2453: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2449: ) IS
2450:
2451: l_module_name VARCHAR2(20) := 'ADD_LOCATORS';
2452: l_progress_indicator VARCHAR2(20) := '0';
2453: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2454:
2455: BEGIN
2456:
2457: DEBUG('In procedure :', l_module_name,0);

Line 2574: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2570: ) IS
2571:
2572: l_module_name VARCHAR2(20) := 'VALIDATE_LOCATORS';
2573: l_progress_indicator VARCHAR2(20) := '0';
2574: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2575: l_return_status VARCHAR2(1);
2576:
2577: l_id VARCHAR2(30);
2578:

Line 2746: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

2742: ) IS
2743:
2744: l_module_name VARCHAR2(20) := 'DELETE_LOCATORS';
2745: l_progress_indicator VARCHAR2(20) := '0';
2746: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2747:
2748: BEGIN
2749:
2750: DEBUG('In procedure :', l_module_name,0);