APPS.INV_LOT_SEL_ATTR dependencies on FND_PROFILE

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

11: p_module IN VARCHAR2,
12: p_level IN NUMBER
13: ) IS
14:
15: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
16:
17: BEGIN
18:
19: IF NOT g_version_printed THEN

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

49: p_lot_serial_number IN VARCHAR2 ) IS
50:
51: i NUMBER;
52: l_context_column_name VARCHAR2(12);
53: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
54: l_module_name VARCHAR2(30) := 'GET_CONTEXT_CODE';
55: BEGIN
56: context_value := NULL;
57: l_context_column_name := 'ITEM';

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

181: p_lot_serial IN VARCHAR2,
182: flex_name IN VARCHAR2
183: ) IS
184:
185: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
186:
187: l_module_name VARCHAR2(30) := 'GET_LOT_SERIAL_CONTEXT';
188: l_progress_indicator VARCHAR2(10) := '0';
189:

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

280:
281: l_retVarchar VARCHAR2(15) := 'VARCHAR2';
282: l_retDate VARCHAR2(15) := 'DATE';
283: l_retNumber VARcHAR2(15) := 'NUMBER';
284: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
285: BEGIN
286: if( upper(p_table_name) = 'MTL_LOT_NUMBERS' ) then
287: if( upper(p_column_name ) = 'VENDOR_ID') then
288: x_column_type := l_retNumber;

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

412: v_value VARCHAR2(200);
413: v_a_name VARCHAR2(50);
414: l_context_column_name VARCHAR2(240); --bug 2474713
415: l_context_prompt fnd_descriptive_flexs_vl.form_context_prompt%TYPE; --bug#2474713
416: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
417:
418: TYPE t_genref is REF CURSOR;
419: default_value_csr t_genref;
420: l_default_date_value DATE;

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

804: i BINARY_INTEGER;
805: j BINARY_INTEGER;
806:
807: v_is_enabled NUMBER := 0;
808: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
809: BEGIN
810:
811: v_is_enabled :=0;
812:

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

878: i BINARY_INTEGER;
879: j BINARY_INTEGER;
880:
881: v_is_enabled NUMBER := 0;
882: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
883: BEGIN
884:
885: v_is_enabled :=0;
886:

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

1005: l_column_idx BINARY_INTEGER;
1006: l_default_format VARCHAR2(30) := 'YYYY/MM/DD HH24:MI:SS';
1007: l_date DATE;
1008: l_get_default BOOLEAN DEFAULT FALSE; -- true if we are to get the default values for the attributes
1009: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1010: l_ret boolean;
1011:
1012: cursor column_csr(p_table_name VARCHAR2, p_owner VARCHAR2) is
1013: select column_name, data_type, data_length

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

1357: x_context OUT NOCOPY t_genref,
1358: p_application_id IN NUMBER,
1359: p_flex_name IN VARCHAR2) IS
1360:
1361: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1362: BEGIN
1363: OPEN x_context FOR
1364: SELECT descriptive_flex_context_code, descriptive_flex_context_name,
1365: global_flag, enabled_flag

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

1373: x_segment OUT NOCOPY t_genref,
1374: p_application_id IN NUMBER,
1375: p_flex_name IN VARCHAR2,
1376: p_flex_context_code IN VARCHAR2) IS
1377: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1378: BEGIN
1379: OPEN x_segment FOR
1380: SELECT end_user_column_name, application_column_name, enabled_flag,
1381: required_flag, default_type, default_value