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.

APPS.HR_FLEXFIELD_INFO dependencies on HR_UTILITY

Line 15: g_debug boolean := hr_utility.debug_enabled;

11: --
12: g_package varchar2(33) := ' hr_flexfield_info';
13: g_psegment_count number := 0;
14: g_app_col_placeholder VARCHAR2(200) := '&'||hr_api.g_varchar2||'.';
15: g_debug boolean := hr_utility.debug_enabled;
16: --
17: -- ----------------------------------------------------------------------------
18: -- |------------------------------< initialize >------------------------------|
19: -- ----------------------------------------------------------------------------

Line 90: hr_utility.set_location('Entering:'|| l_proc, 10);

86: --
87:
88: IF g_debug THEN
89: l_proc := g_package||'get_ak_region_code';
90: hr_utility.set_location('Entering:'|| l_proc, 10);
91: END IF;
92:
93: --
94: -- Construct the right look up code for the AK region data based

Line 123: hr_utility.set_location('Leaving:'|| l_proc, 20);

119:
120: --
121:
122: IF g_debug THEN
123: hr_utility.set_location('Leaving:'|| l_proc, 20);
124: END IF;
125:
126: --
127: --return nvl(l_ak_web_region_code,'Not found!');

Line 168: hr_utility.set_location('Entering:'|| l_proc, 10);

164: --
165:
166: IF g_debug THEN
167: l_proc := g_package||'get_segment_parents';
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: END IF;
170:
171: --
172: l_count :=0;

Line 186: hr_utility.set_location(l_proc, 20);

182: -- place holder identifies the parent segment
183: --
184:
185: IF g_debug THEN
186: hr_utility.set_location(l_proc, 20);
187: END IF;
188:
189: --
190: LOOP

Line 197: hr_utility.set_location(l_proc, 30);

193: EXIT WHEN l_parent_loc < 1;
194: --
195:
196: IF g_debug THEN
197: hr_utility.set_location(l_proc, 30);
198: END IF;
199:
200: --
201: p_segment_info.psegment_pointer(p_segment_number):=g_psegment_count+1;

Line 245: hr_utility.set_location(l_proc, 40);

241: -- this can be a value set, or a segment name.
242: --
243:
244: IF g_debug THEN
245: hr_utility.set_location(l_proc, 40);
246: END IF;
247:
248: --
249: if (p_segment_info.value_set(i) > 0) then

Line 277: hr_utility.set_location(l_proc, 50);

273: -- value set name, but as a secondary check, perform this step
274: --
275:
276: IF g_debug THEN
277: hr_utility.set_location(l_proc, 50);
278: END IF;
279:
280: --
281: if(l_token_value is null) then

Line 287: hr_utility.set_location(l_proc, 60);

283: FOR i in 1..p_segment_info.nsegments LOOP
284: --
285:
286: IF g_debug THEN
287: hr_utility.set_location(l_proc, 60);
288: END IF;
289:
290: --
291: if (p_segment_info.segment_name(i) = l_segment_or_vs) then

Line 303: hr_utility.set_location(l_proc, 70);

299: END LOOP;
300: --
301:
302: IF g_debug THEN
303: hr_utility.set_location(l_proc, 70);
304: END IF;
305:
306: --
307: end if;

Line 319: hr_utility.set_location(l_proc, 80);

315: END LOOP;
316: --
317:
318: IF g_debug THEN
319: hr_utility.set_location(l_proc, 80);
320: END IF;
321:
322: --
323: -- Up date the number of parents and segment counts.

Line 330: hr_utility.set_location('Leaving: '||l_proc, 80);

326: g_psegment_count := g_psegment_count + l_count;
327: --
328:
329: IF g_debug THEN
330: hr_utility.set_location('Leaving: '||l_proc, 80);
331: END IF;
332:
333: --
334: end get_segment_parents;

Line 364: hr_utility.set_location('Entering:'|| l_proc, 10);

360: begin
361:
362: IF g_debug THEN
363: l_proc := g_package||'substitute_profiles';
364: hr_utility.set_location('Entering:'|| l_proc, 10);
365: END IF;
366:
367: --
368: -- Don't strictly need to do this if get_segment_parents is called

Line 384: hr_utility.set_location(l_proc, 20);

380: -- Found a placeholder.
381: --
382:
383: IF g_debug THEN
384: hr_utility.set_location(l_proc, 20);
385: END IF;
386:
387: /* AR 6/7/99
388: Adjust Adnan's code here, to check for any following special character

Line 419: hr_utility.set_location('Leaving ' || l_proc, 30);

415:
416: if l_profile_value is null then
417:
418: IF g_debug THEN
419: hr_utility.set_location('Leaving ' || l_proc, 30);
420: END IF;
421:
422: --
423: -- Using an AOL message here!

Line 425: hr_utility.set_message(0, 'FLEX-INVALID PROFILE');

421:
422: --
423: -- Using an AOL message here!
424: --
425: hr_utility.set_message(0, 'FLEX-INVALID PROFILE');
426: hr_utility.set_message_token('BTOKEN', upper(l_profile_name));
427: hr_utility.raise_error;
428: end if;
429: */

Line 426: hr_utility.set_message_token('BTOKEN', upper(l_profile_name));

422: --
423: -- Using an AOL message here!
424: --
425: hr_utility.set_message(0, 'FLEX-INVALID PROFILE');
426: hr_utility.set_message_token('BTOKEN', upper(l_profile_name));
427: hr_utility.raise_error;
428: end if;
429: */
430: --

Line 427: hr_utility.raise_error;

423: -- Using an AOL message here!
424: --
425: hr_utility.set_message(0, 'FLEX-INVALID PROFILE');
426: hr_utility.set_message_token('BTOKEN', upper(l_profile_name));
427: hr_utility.raise_error;
428: end if;
429: */
430: --
431: -- Replace the profile value completely in the string. Note:

Line 462: hr_utility.set_location('Leaving ' || l_proc, 40);

458: end loop;
459: p_sql_text := l_sql_text;
460:
461: IF g_debug THEN
462: hr_utility.set_location('Leaving ' || l_proc, 40);
463: END IF;
464:
465:
466: EXCEPTION

Line 468: hr_utility.trace(' Exception in hr_flexfield_info.substitute_profiles ' || SQLERRM );

464:
465:
466: EXCEPTION
467: WHEN OTHERS THEN
468: hr_utility.trace(' Exception in hr_flexfield_info.substitute_profiles ' || SQLERRM );
469: raise;
470:
471: end substitute_profiles;
472: --

Line 497: hr_utility.set_location('Entering:'|| l_proc, 5);

493: --
494:
495: IF g_debug THEN
496: l_proc := g_package||'get_contexts';
497: hr_utility.set_location('Entering:'|| l_proc, 5);
498: END IF;
499:
500: --
501:

Line 510: hr_utility.set_location(l_proc, 10);

506:
507: --
508:
509: IF g_debug THEN
510: hr_utility.set_location(l_proc, 10);
511: END IF;
512:
513: --
514: fnd_dflex.get_contexts(l_flexfield, p_contexts);

Line 518: hr_utility.set_location(' Leaving:'||l_proc, 15);

514: fnd_dflex.get_contexts(l_flexfield, p_contexts);
515: --
516:
517: IF g_debug THEN
518: hr_utility.set_location(' Leaving:'||l_proc, 15);
519: END IF;
520:
521: --
522: end get_contexts;

Line 548: g_debug := hr_utility.debug_enabled;

544: l_proc varchar2(72);
545: --
546: begin
547: --
548: g_debug := hr_utility.debug_enabled;
549: IF g_debug THEN
550: l_proc := g_package||'get_concatenated_contexts';
551: hr_utility.set_location('Entering:'|| l_proc, 5);
552: END IF;

Line 551: hr_utility.set_location('Entering:'|| l_proc, 5);

547: --
548: g_debug := hr_utility.debug_enabled;
549: IF g_debug THEN
550: l_proc := g_package||'get_concatenated_contexts';
551: hr_utility.set_location('Entering:'|| l_proc, 5);
552: END IF;
553:
554: --
555: hr_flexfield_info.get_contexts(p_appl_short_name,

Line 561: hr_utility.set_location( l_proc, 10);

557: l_contexts);
558: --
559:
560: IF g_debug THEN
561: hr_utility.set_location( l_proc, 10);
562: END IF;
563:
564: --
565: for i in 1 .. l_contexts.ncontexts

Line 586: hr_utility.set_location(' Leaving:'||l_proc, 15);

582: p_context_list := ltrim(l_context_list,p_concatenation_chr);
583: --
584:
585: IF g_debug THEN
586: hr_utility.set_location(' Leaving:'||l_proc, 15);
587: END IF;
588:
589: --
590: end get_concatenated_contexts;

Line 692: hr_utility.set_location('Entering:'|| l_proc, 5);

688: --
689:
690: IF g_debug THEN
691: l_proc:= g_package||'get_validation_info';
692: hr_utility.set_location('Entering:'|| l_proc, 5);
693: END IF;
694:
695: --
696: for i in 1..p_segment_info.nsegments loop

Line 729: hr_utility.set_location(l_proc, 10);

725: p_segment_info.sql_txt_descr(i) := '';
726: --
727:
728: IF g_debug THEN
729: hr_utility.set_location(l_proc, 10);
730: END IF;
731:
732: --
733: --

Line 752: hr_utility.set_location(l_proc, 20);

748: p_segment_info.validation_type(i) := 'TABLE';
749: --
750:
751: IF g_debug THEN
752: hr_utility.set_location(l_proc, 20);
753: END IF;
754:
755: --
756: select 'SELECT ' ||

Line 770: hr_utility.set_location(l_proc, 30);

766: from dual;
767: --
768:
769: IF g_debug THEN
770: hr_utility.set_location(l_proc, 30);
771: END IF;
772:
773: --
774: get_segment_parents(p_segment_info,i,p_segment_info.sql_text(i),

Line 779: hr_utility.set_location(l_proc, 35);

775: p_segment_info.number_parents(i));
776:
777:
778: IF g_debug THEN
779: hr_utility.set_location(l_proc, 35);
780: END IF;
781:
782: --
783: substitute_profiles

Line 789: hr_utility.set_location(l_proc, 40);

785: );
786: --
787:
788: IF g_debug THEN
789: hr_utility.set_location(l_proc, 40);
790: END IF;
791:
792: --
793: l_order_by_start := INSTR(upper(p_segment_info.sql_text(i)),'ORDER BY');

Line 810: hr_utility.set_location(l_proc, 50);

806: if l_valueset_r.table_info.id_column_name is null then
807: --
808:
809: IF g_debug THEN
810: hr_utility.set_location(l_proc, 50);
811: END IF;
812:
813: --
814: l_additional_and_clause := ' WHERE '||l_valueset_r.table_info.

Line 821: hr_utility.set_location(l_proc, 55);

817: else
818: --
819:
820: IF g_debug THEN
821: hr_utility.set_location(l_proc, 55);
822: END IF;
823:
824: --
825: l_additional_and_clause := ' WHERE '||l_valueset_r.table_info.

Line 833: hr_utility.set_location(l_proc, 60);

829: else
830: --
831:
832: IF g_debug THEN
833: hr_utility.set_location(l_proc, 60);
834: END IF;
835:
836: --
837: if l_valueset_r.table_info.id_column_name is null then

Line 841: hr_utility.set_location(l_proc, 70);

837: if l_valueset_r.table_info.id_column_name is null then
838: --
839:
840: IF g_debug THEN
841: hr_utility.set_location(l_proc, 70);
842: END IF;
843:
844: --
845: l_additional_and_clause := ' AND '||l_valueset_r.table_info.value_column_name

Line 851: hr_utility.set_location(l_proc, 75);

847: else
848: --
849:
850: IF g_debug THEN
851: hr_utility.set_location(l_proc, 75);
852: END IF;
853:
854: --
855: l_additional_and_clause := ' AND '||l_valueset_r.table_info.id_column_name

Line 862: hr_utility.set_location(l_proc, 80);

858: end if;
859: --
860:
861: IF g_debug THEN
862: hr_utility.set_location(l_proc, 80);
863: END IF;
864:
865: --
866: --

Line 878: hr_utility.set_location(l_proc, 90);

874: end if;
875: --
876:
877: IF g_debug THEN
878: hr_utility.set_location(l_proc, 90);
879: END IF;
880:
881: --
882: if(l_valueset_r.table_info.meaning_column_name is not null) then

Line 900: hr_utility.set_location(l_proc, 100);

896: else
897: --
898:
899: IF g_debug THEN
900: hr_utility.set_location(l_proc, 100);
901: END IF;
902:
903: --
904: --

Line 914: hr_utility.set_location(l_proc, 110);

910: else
911: --
912:
913: IF g_debug THEN
914: hr_utility.set_location(l_proc, 110);
915: END IF;
916:
917: --
918: p_segment_info.sql_txt_descr(i) := '';

Line 926: hr_utility.set_location(l_proc, 120);

922: p_segment_info.validation_type(i) := 'INDEPENDENT';
923: --
924:
925: IF g_debug THEN
926: hr_utility.set_location(l_proc, 120);
927: END IF;
928:
929: --
930: --

Line 979: hr_utility.set_location(l_proc, 120);

975: p_segment_info.validation_type(i) := 'DEPENDENT';
976: --
977:
978: IF g_debug THEN
979: hr_utility.set_location(l_proc, 120);
980: END IF;
981:
982: --
983: --

Line 1039: hr_utility.set_location(l_proc, 130);

1035: elsif l_valueset_r.validation_type = 'P' then
1036: --
1037:
1038: IF g_debug THEN
1039: hr_utility.set_location(l_proc, 130);
1040: END IF;
1041:
1042: p_segment_info.validation_type(i) := 'PAIR';
1043: --

Line 1053: hr_utility.set_location(l_proc, 130);

1049: elsif l_valueset_r.validation_type = 'U' then
1050: --
1051:
1052: IF g_debug THEN
1053: hr_utility.set_location(l_proc, 130);
1054: END IF;
1055:
1056: p_segment_info.validation_type(i) := 'SPECIAL';
1057: --

Line 1071: hr_utility.set_location(l_proc, 140);

1067: else -- have null value set id
1068: --
1069:
1070: IF g_debug THEN
1071: hr_utility.set_location(l_proc, 140);
1072: END IF;
1073:
1074: --
1075: p_segment_info.number_parents(i) := 0;

Line 1121: hr_utility.set_location(' Leaving:'||l_proc, 150);

1117: --
1118: end loop;
1119:
1120: IF g_debug THEN
1121: hr_utility.set_location(' Leaving:'||l_proc, 150);
1122: END IF;
1123:
1124: --
1125: end get_validation_info;

Line 1153: g_debug := hr_utility.debug_enabled;

1149: l_total_parents NUMBER :=0;
1150: --
1151: begin
1152: --
1153: g_debug := hr_utility.debug_enabled;
1154: IF g_debug THEN
1155: l_proc := g_package||'get_segments';
1156: hr_utility.set_location('Entering:'|| l_proc, 10);
1157: END IF;

Line 1156: hr_utility.set_location('Entering:'|| l_proc, 10);

1152: --
1153: g_debug := hr_utility.debug_enabled;
1154: IF g_debug THEN
1155: l_proc := g_package||'get_segments';
1156: hr_utility.set_location('Entering:'|| l_proc, 10);
1157: END IF;
1158:
1159: --
1160: --

Line 1170: hr_utility.set_location(l_proc, 20);

1166: l_flexinfo);
1167: --
1168:
1169: IF g_debug THEN
1170: hr_utility.set_location(l_proc, 20);
1171: END IF;
1172:
1173: --
1174: -- Now, given the flexfield information returned

Line 1192: hr_utility.set_location(l_proc, 30);

1188: loop
1189: --
1190:
1191: IF g_debug THEN
1192: hr_utility.set_location(l_proc, 30);
1193: END IF;
1194:
1195: --
1196: l_hr_segments.application_column_name(i)

Line 1220: hr_utility.set_location(l_proc, 40);

1216: end loop;
1217: --
1218:
1219: IF g_debug THEN
1220: hr_utility.set_location(l_proc, 40);
1221: END IF;
1222:
1223: --
1224: get_validation_info(p_segment_info => l_hr_segments,

Line 1234: hr_utility.set_location(l_proc, 50);

1230: p_segments := l_hr_segments;
1231: --
1232:
1233: IF g_debug THEN
1234: hr_utility.set_location(l_proc, 50);
1235: END IF;
1236:
1237: end get_segments;
1238: --

Line 1402: g_debug := hr_utility.debug_enabled;

1398: -- Start big loop for replacing the values
1399: -- We shouldn't expect any value to appear only once
1400: --
1401: --
1402: g_debug := hr_utility.debug_enabled;
1403: IF g_debug THEN
1404: l_proc := g_package||'build_sql_text';
1405: hr_utility.set_location('Entering:'|| l_proc, 10);
1406: END IF;

Line 1405: hr_utility.set_location('Entering:'|| l_proc, 10);

1401: --
1402: g_debug := hr_utility.debug_enabled;
1403: IF g_debug THEN
1404: l_proc := g_package||'build_sql_text';
1405: hr_utility.set_location('Entering:'|| l_proc, 10);
1406: END IF;
1407:
1408: --
1409: if(instr(p_sql_text,g_app_col_placeholder)>0) then

Line 1422: hr_utility.set_location(l_proc, 20);

1418: EXIT WHEN ((l_placeholder < 1) OR (l_no_replace_value='Y'));
1419: --
1420:
1421: IF g_debug THEN
1422: hr_utility.set_location(l_proc, 20);
1423: END IF;
1424:
1425: --
1426: -- Need to update this to take account of carriage returns etc.

Line 1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );

1454: and t.table_name = p_application_table_name
1455: and a.application_short_name = p_application_short_name;
1456: EXCEPTION
1457: WHEN NO_DATA_FOUND THEN
1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );
1459: hr_utility.trace(' Table Name ' || p_application_table_name );
1460: hr_utility.trace(' Column Name ' || l_application_column_name );
1461: --
1462:

Line 1459: hr_utility.trace(' Table Name ' || p_application_table_name );

1455: and a.application_short_name = p_application_short_name;
1456: EXCEPTION
1457: WHEN NO_DATA_FOUND THEN
1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );
1459: hr_utility.trace(' Table Name ' || p_application_table_name );
1460: hr_utility.trace(' Column Name ' || l_application_column_name );
1461: --
1462:
1463: IF g_debug THEN

Line 1460: hr_utility.trace(' Column Name ' || l_application_column_name );

1456: EXCEPTION
1457: WHEN NO_DATA_FOUND THEN
1458: hr_utility.trace(' Exception in hr_flexfield_info.build_sql_text ' || SQLERRM );
1459: hr_utility.trace(' Table Name ' || p_application_table_name );
1460: hr_utility.trace(' Column Name ' || l_application_column_name );
1461: --
1462:
1463: IF g_debug THEN
1464: hr_utility.set_location(l_proc, 30);

Line 1464: hr_utility.set_location(l_proc, 30);

1460: hr_utility.trace(' Column Name ' || l_application_column_name );
1461: --
1462:
1463: IF g_debug THEN
1464: hr_utility.set_location(l_proc, 30);
1465: END IF;
1466:
1467: --
1468: p_sql_text := 'FAILURE: Column '||l_application_column_name||

Line 1481: hr_utility.set_location(l_proc, 40);

1477: --
1478: --
1479:
1480: IF g_debug THEN
1481: hr_utility.set_location(l_proc, 40);
1482: END IF;
1483:
1484: --
1485: if (l_application_column_name = p_column_name1) then

Line 1743: hr_utility.set_location('Leaving:'|| l_proc, 50);

1739:
1740: --
1741:
1742: IF g_debug THEN
1743: hr_utility.set_location('Leaving:'|| l_proc, 50);
1744: END IF;
1745:
1746: --
1747: end build_sql_text;

Line 1767: g_debug := hr_utility.debug_enabled;

1763: --
1764: i binary_integer;
1765: l_proc varchar2(72);
1766: begin
1767: g_debug := hr_utility.debug_enabled;
1768: p_structure_list := null;
1769: --
1770: -- Get the flexfield.
1771: --

Line 1775: hr_utility.set_location('Entering:'|| l_proc, 5);

1771: --
1772:
1773: IF g_debug THEN
1774: l_proc := g_package||'get_kf_concatenated_structures';
1775: hr_utility.set_location('Entering:'|| l_proc, 5);
1776: END IF;
1777:
1778: fnd_flex_key_api.set_session_mode(session_mode => 'seed_data');
1779: l_flexfield :=

Line 1789: hr_utility.set_location(l_proc, 10);

1785: -- Get the flexfield structures.
1786: --
1787:
1788: IF g_debug THEN
1789: hr_utility.set_location(l_proc, 10);
1790: END IF;
1791:
1792: fnd_flex_key_api.get_structures
1793: (flexfield => l_flexfield

Line 1827: hr_utility.set_location(' Leaving:'||l_proc, 15);

1823: p_structure_list := ltrim(l_structure_list,p_concatenation_chr);
1824: --
1825:
1826: IF g_debug THEN
1827: hr_utility.set_location(' Leaving:'||l_proc, 15);
1828: END IF;
1829:
1830: end get_kf_concatenated_structures;
1831: --

Line 1861: g_debug := hr_utility.debug_enabled;

1857: i number;
1858: l_proc varchar2(72);
1859: begin
1860: --
1861: g_debug := hr_utility.debug_enabled;
1862: IF g_debug THEN
1863: l_proc := g_package||'get_kf_segments';
1864: hr_utility.set_location('Entering:'|| l_proc, 5);
1865: END IF;

Line 1864: hr_utility.set_location('Entering:'|| l_proc, 5);

1860: --
1861: g_debug := hr_utility.debug_enabled;
1862: IF g_debug THEN
1863: l_proc := g_package||'get_kf_segments';
1864: hr_utility.set_location('Entering:'|| l_proc, 5);
1865: END IF;
1866:
1867: --
1868: -- Get the flexfield.

Line 1882: hr_utility.set_location(l_proc, 10);

1878: --
1879:
1880:
1881: IF g_debug THEN
1882: hr_utility.set_location(l_proc, 10);
1883: END IF;
1884:
1885:
1886: /*

Line 1914: hr_utility.set_location(l_proc, 20);

1910: -- above, find the segment information
1911: --
1912:
1913: IF g_debug THEN
1914: hr_utility.set_location(l_proc, 20);
1915: END IF;
1916:
1917: fnd_flex_key_api.get_segments
1918: (flexfield => l_flexfield

Line 1933: hr_utility.set_location(l_proc, 20);

1929: i := l_segment_list.first;
1930: loop
1931:
1932: IF g_debug THEN
1933: hr_utility.set_location(l_proc, 20);
1934: END IF;
1935:
1936: exit when not l_segment_list.exists(i);
1937: --

Line 1942: hr_utility.set_location(l_proc, 30);

1938: -- For each segment get the segment information.
1939: --
1940:
1941: IF g_debug THEN
1942: hr_utility.set_location(l_proc, 30);
1943: END IF;
1944:
1945: l_segment_info :=
1946: fnd_flex_key_api.find_segment

Line 1956: hr_utility.set_location(l_proc, 40);

1952: -- Set up the returned segment information.
1953: --
1954:
1955: IF g_debug THEN
1956: hr_utility.set_location(l_proc, 40);
1957: END IF;
1958:
1959: l_segments.application_column_name(i) := l_segment_info.column_name;
1960: l_segments.segment_name(i) := l_segment_list(i);

Line 1994: hr_utility.set_location(l_proc, 50);

1990: -- to know if it is Personal Analysis flex (PEA)
1991: --
1992:
1993: IF g_debug THEN
1994: hr_utility.set_location(l_proc, 50);
1995: END IF;
1996:
1997: hr_flexfield_info.get_validation_info
1998: (p_segment_info => l_segments

Line 2010: hr_utility.set_location(l_proc, 60);

2006: --
2007: p_segments := l_segments;
2008:
2009: IF g_debug THEN
2010: hr_utility.set_location(l_proc, 60);
2011: END IF;
2012:
2013: end get_kf_segments;
2014: --