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.12010000.3 2009/08/03 06:45:01 ajunnikr ship $',

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 357: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

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

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

1406: p_last_updated_by IN NUMBER,
1407: p_last_update_login IN NUMBER
1408: ) IS
1409:
1410: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1411: l_module_name VARCHAR2(20) := 'INSERT_WMS_ZONES';
1412: l_progress_indicator VARCHAR2(10) := '0';
1413:
1414: l_return_status VARCHAR2(1);

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

1603: p_last_update_date IN DATE,
1604: p_last_updated_by IN NUMBER,
1605: p_last_update_login IN NUMBER
1606: ) IS
1607: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1608: l_module_name VARCHAR2(20) := 'UPDATE_WMS_ZONES';
1609: l_progress_indicator VARCHAR2(10) := '0';
1610:
1611: l_return_status VARCHAR2(1);

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

1760: ) IS
1761:
1762: l_progress_indicator VARCHAR2(10) := '0';
1763: l_module_name VARCHAR2(20) := 'SAVE_SEL_LOCATORS';
1764: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
1765:
1766: BEGIN
1767:
1768: DEBUG('In procedure :', l_module_name,0);

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

2476: ) IS
2477:
2478: l_module_name VARCHAR2(20) := 'ADD_LOCATORS';
2479: l_progress_indicator VARCHAR2(20) := '0';
2480: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2481:
2482: BEGIN
2483:
2484: DEBUG('In procedure :', l_module_name,0);

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

2597: ) IS
2598:
2599: l_module_name VARCHAR2(20) := 'VALIDATE_LOCATORS';
2600: l_progress_indicator VARCHAR2(20) := '0';
2601: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2602: l_return_status VARCHAR2(1);
2603:
2604: l_id VARCHAR2(30);
2605:

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

2769: ) IS
2770:
2771: l_module_name VARCHAR2(20) := 'DELETE_LOCATORS';
2772: l_progress_indicator VARCHAR2(20) := '0';
2773: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
2774:
2775: BEGIN
2776:
2777: DEBUG('In procedure :', l_module_name,0);