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.BEN_EXT_THREAD dependencies on HR_UTILITY

Line 130: hr_utility.set_location calls

126: string element will be considered as space
127: 17-dec-02 tjesumic 115.81 115.78,115.79 reversed
128: 27-Dec-02 lakrish 115.84 NOCOPY changes
129: 13-Feb-03 rpillay 115.85 HRMS Debug Performance changes to
130: hr_utility.set_location calls
131: 23-Aug-03 tjesumic 115.86 calcualted records added for detail record
132: 02-Oct-03 tjesumic 115.87 Upper/lower/initcap applied for string format mask
133: 29-Oct-03 tjesumic 115.88 total for detail records are considers only non hiden records
134: hiden recors are filterd

Line 236: g_debug boolean := hr_utility.debug_enabled;

232: -- ----------------------------------------------------------------------------
233: -- | Private Global Definitions |
234: -- ----------------------------------------------------------------------------
235: --
236: g_debug boolean := hr_utility.debug_enabled;
237: --
238: g_val_def ben_ext_fmt.valtabtyp :=
239: ben_ext_fmt.valtabtyp(null,null,null,null,null,null,null,null,null,null,
240: null,null,null,null,null,null,null,null,null,null,

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

286: begin
287: --
288: if g_debug then
289: l_proc := g_package || '.write_error';
290: hr_utility.set_location('Entering'||l_proc, 5);
291: end if;
292: --
293: if p_business_group_id is not null then
294: --

Line 310: hr_utility.set_location('Exiting'||l_proc, 15);

306: --
307: end if;
308: --
309: if g_debug then
310: hr_utility.set_location('Exiting'||l_proc, 15);
311: end if;
312: --
313: end write_error;
314: --

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

395: begin
396: --
397: if g_debug then
398: l_proc := g_package||'.get_ext_prmtrs';
399: hr_utility.set_location('Entering'||l_proc, 5);
400: end if;
401: --
402: open ext_dfn_c;
403: fetch ext_dfn_c into p_data_typ_cd,

Line 476: hr_utility.set_location('Exiting'||l_proc, 15);

472: end if ;
473: -- eof subheader
474:
475: if g_debug then
476: hr_utility.set_location('Exiting'||l_proc, 15);
477: end if;
478: --
479: Exception
480: --

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

525: BEGIN
526: --
527: if g_debug then
528: l_proc := g_package||'.update_ht_strt_end_dt';
529: hr_utility.set_location('Entering'||l_proc, 5);
530: end if;
531: --
532: --
533: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

Line 606: hr_utility.set_location('Exiting'||l_proc, 15);

602: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
603: --
604: --
605: if g_debug then
606: hr_utility.set_location('Exiting'||l_proc, 15);
607: end if;
608: --
609: EXCEPTION
610: --

Line 773: g_debug := hr_utility.debug_enabled;

769: l_rslt_elmt_fmt varchar2(600) := null;
770:
771: Begin
772:
773: g_debug := hr_utility.debug_enabled;
774: if g_debug then
775: l_proc := g_package||'.get_ht_elmt_data';
776: hr_utility.set_location('Entering'||l_proc, 5);
777: end if;

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

772:
773: g_debug := hr_utility.debug_enabled;
774: if g_debug then
775: l_proc := g_package||'.get_ht_elmt_data';
776: hr_utility.set_location('Entering'||l_proc, 5);
777: end if;
778:
779: IF p_data_elmt_typ_cd = 'F' THEN
780:

Line 817: hr_utility.set_location( ' ttl count ' || l_rslt_elmt , 99 ) ;

813: p_group_val_02) ;
814: fetch get_ttl_cnt into l_rslt_elmt ;
815: close get_ttl_cnt ;
816:
817: hr_utility.set_location( ' ttl count ' || l_rslt_elmt , 99 ) ;
818: hr_utility.set_location( ' su ttl ' || l_subtrl_cnt , 99 ) ;
819: if l_rslt_elmt is not null or l_subtrl_cnt is not null then
820: l_rslt_elmt :=
821: ben_ext_fmt.apply_format_mask(nvl(to_number(l_rslt_elmt),0)+

Line 818: hr_utility.set_location( ' su ttl ' || l_subtrl_cnt , 99 ) ;

814: fetch get_ttl_cnt into l_rslt_elmt ;
815: close get_ttl_cnt ;
816:
817: hr_utility.set_location( ' ttl count ' || l_rslt_elmt , 99 ) ;
818: hr_utility.set_location( ' su ttl ' || l_subtrl_cnt , 99 ) ;
819: if l_rslt_elmt is not null or l_subtrl_cnt is not null then
820: l_rslt_elmt :=
821: ben_ext_fmt.apply_format_mask(nvl(to_number(l_rslt_elmt),0)+
822: nvl(l_subtrl_cnt,0),P_frmt_mask_cd);

Line 836: hr_utility.set_location( ' dtl count ' || l_rslt_elmt , 99 ) ;

832: open get_dtl_cnt (p_group_val_01 ,
833: p_group_val_02) ;
834: fetch get_dtl_cnt into l_rslt_elmt ;
835: close get_dtl_cnt ;
836: hr_utility.set_location( ' dtl count ' || l_rslt_elmt , 99 ) ;
837: if l_rslt_elmt is not null then
838: l_rslt_elmt := ben_ext_fmt.apply_format_mask(l_rslt_elmt, P_frmt_mask_cd);
839: end if ;
840:

Line 966: hr_utility.set_location(' Rule546:'||P_data_elmt_rl, 39);

962: -- data element is a rule:
963:
964: --
965: if g_debug then
966: hr_utility.set_location(' Rule546:'||P_data_elmt_rl, 39);
967: end if;
968:
969:
970: open c_rule_type(P_data_elmt_rl);

Line 975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);

971: fetch c_rule_type into l_rule_type;
972: close c_rule_type;
973:
974: if g_debug then
975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);
976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);
977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);
978: end if;
979: if l_rule_type.formula_type_id = -546 then

Line 976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);

972: close c_rule_type;
973:
974: if g_debug then
975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);
976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);
977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);
978: end if;
979: if l_rule_type.formula_type_id = -546 then
980: l_outputs := benutils.formula

Line 977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);

973:
974: if g_debug then
975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);
976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);
977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);
978: end if;
979: if l_rule_type.formula_type_id = -546 then
980: l_outputs := benutils.formula
981: (p_formula_id => p_data_elmt_rl,

Line 996: hr_utility.set_location(' rule result :'|| l_rslt_elmt, 39);

992: );
993:
994: l_rslt_elmt := l_outputs(l_outputs.first).value;
995: --
996: hr_utility.set_location(' rule result :'|| l_rslt_elmt, 39);
997:
998: -- format mask handling
999: if p_frmt_mask_lookup_cd is not null then
1000: begin

Line 1014: hr_utility.set_location(' rule result frmt :'|| l_rslt_elmt, 39);

1010: when others then
1011: null;
1012: end;
1013: end if ;
1014: hr_utility.set_location(' rule result frmt :'|| l_rslt_elmt, 39);
1015: else
1016: --- this avoid copying the previous result
1017: l_rslt_elmt := null ;
1018: end if ;

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

1096: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
1097: and xel.ext_fld_id = efl.ext_fld_id (+) ;
1098: begin
1099:
1100: hr_utility.set_location('Entering'||l_proc, 5);
1101: for elmt in c_calc_elmt Loop
1102: l_rslt_calc :=get_ht_elmt_data(p_ext_rslt_id => p_ext_rslt_id,
1103: p_data_elmt_typ_cd => elmt.data_elmt_typ_cd ,
1104: p_short_name => elmt.short_name ,

Line 1120: hr_utility.set_location (' HT ' || elmt.short_name || l_rslt_calc , 999 );

1116: p_ttl_sum_ext_data_elmt_id => elmt.ttl_sum_ext_data_elmt_id,
1117: p_ttl_cond_ext_data_elmt_id => elmt.ttl_cond_ext_data_elmt_id,
1118: p_rcd_typ_cd => p_rcd_typ_cd
1119: ) ;
1120: hr_utility.set_location (' HT ' || elmt.short_name || l_rslt_calc , 999 );
1121: hr_utility.set_location (' type ' || elmt.short_name || elmt.data_elmt_typ_cd , 999 );
1122:
1123: Begin
1124: l_rslt_calc := to_number(l_rslt_calc) ;

Line 1121: hr_utility.set_location (' type ' || elmt.short_name || elmt.data_elmt_typ_cd , 999 );

1117: p_ttl_cond_ext_data_elmt_id => elmt.ttl_cond_ext_data_elmt_id,
1118: p_rcd_typ_cd => p_rcd_typ_cd
1119: ) ;
1120: hr_utility.set_location (' HT ' || elmt.short_name || l_rslt_calc , 999 );
1121: hr_utility.set_location (' type ' || elmt.short_name || elmt.data_elmt_typ_cd , 999 );
1122:
1123: Begin
1124: l_rslt_calc := to_number(l_rslt_calc) ;
1125: exception

Line 1140: hr_utility.set_location (' HT result ' || l_rslt_elmt , 999 );

1136: ,p_second_value => l_rslt_calc
1137: ,p_calc => p_calc ) ;
1138: end if ;
1139: end if ;
1140: hr_utility.set_location (' HT result ' || l_rslt_elmt , 999 );
1141: end loop ;
1142: l_rslt_elmt := ben_ext_fmt.apply_format_mask(to_number(l_rslt_elmt), p_frmt_mask_cd);
1143:
1144:

Line 1145: hr_utility.set_location (' HT return result ' || l_rslt_elmt , 999 );

1141: end loop ;
1142: l_rslt_elmt := ben_ext_fmt.apply_format_mask(to_number(l_rslt_elmt), p_frmt_mask_cd);
1143:
1144:
1145: hr_utility.set_location (' HT return result ' || l_rslt_elmt , 999 );
1146: hr_utility.set_location(' Exiting:'||l_proc, 15);
1147: return l_rslt_elmt ;
1148: end get_calc_value ;
1149:

Line 1146: hr_utility.set_location(' Exiting:'||l_proc, 15);

1142: l_rslt_elmt := ben_ext_fmt.apply_format_mask(to_number(l_rslt_elmt), p_frmt_mask_cd);
1143:
1144:
1145: hr_utility.set_location (' HT return result ' || l_rslt_elmt , 999 );
1146: hr_utility.set_location(' Exiting:'||l_proc, 15);
1147: return l_rslt_elmt ;
1148: end get_calc_value ;
1149:
1150:

Line 1266: g_debug := hr_utility.debug_enabled;

1262: l_dummy_var varchar2(1000) ;
1263: --
1264: begin
1265: --
1266: g_debug := hr_utility.debug_enabled;
1267: if g_debug then
1268: l_proc := g_package||'.process_ext_ht_recs';
1269: hr_utility.set_location('Entering'||l_proc, 5);
1270: end if;

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

1265: --
1266: g_debug := hr_utility.debug_enabled;
1267: if g_debug then
1268: l_proc := g_package||'.process_ext_ht_recs';
1269: hr_utility.set_location('Entering'||l_proc, 5);
1270: end if;
1271: --
1272: savepoint head_trail;
1273: --

Line 1338: hr_utility.set_location('element '||elmt.short_name, 5);

1334: FOR elmt IN rcd_elmt_c LOOP
1335: --
1336: l_rslt_elmt := null ;
1337: if g_debug then
1338: hr_utility.set_location('element '||elmt.short_name, 5);
1339: hr_utility.set_location('element type '||elmt.data_elmt_typ_cd, 5);
1340: end if;
1341: IF elmt.data_elmt_typ_cd in ( 'F','D','R') THEN
1342:

Line 1339: hr_utility.set_location('element type '||elmt.data_elmt_typ_cd, 5);

1335: --
1336: l_rslt_elmt := null ;
1337: if g_debug then
1338: hr_utility.set_location('element '||elmt.short_name, 5);
1339: hr_utility.set_location('element type '||elmt.data_elmt_typ_cd, 5);
1340: end if;
1341: IF elmt.data_elmt_typ_cd in ( 'F','D','R') THEN
1342:
1343: l_rslt_elmt := get_ht_elmt_data(p_ext_rslt_id => p_ext_rslt_id,

Line 1393: hr_utility.set_location(' mass lengh :'||elmt.max_length_num , 39);

1389: --
1390: -- data element is a string:
1391: l_rslt_elmt := elmt.string_val;
1392: if g_debug then
1393: hr_utility.set_location(' mass lengh :'||elmt.max_length_num , 39);
1394: end if;
1395: IF elmt.max_length_num is not null THEN
1396: l_rslt_elmt := rPad(nvl(l_rslt_elmt,' '),elmt.max_length_num );
1397: if g_debug then

Line 1398: hr_utility.set_location('ele :'||l_rslt_elmt , 39);

1394: end if;
1395: IF elmt.max_length_num is not null THEN
1396: l_rslt_elmt := rPad(nvl(l_rslt_elmt,' '),elmt.max_length_num );
1397: if g_debug then
1398: hr_utility.set_location('ele :'||l_rslt_elmt , 39);
1399: end if;
1400: end if ;
1401: ELSIF elmt.data_elmt_typ_cd = 'T' THEN
1402:

Line 1462: hr_utility.set_location(' max ele :'||l_rslt_elmt , 39);

1458: --
1459: END IF;
1460: --
1461: if g_debug then
1462: hr_utility.set_location(' max ele :'||l_rslt_elmt , 39);
1463: end if;
1464: -- if data element is mandatory, but l_rslt_elmt is null then
1465: -- raise ht error
1466: -- when the element is required and not elemnt skip the record

Line 1869: hr_utility.set_location ('Exiting '||l_proc,15);

1865: --
1866: commit;
1867: --
1868: if g_debug then
1869: hr_utility.set_location ('Exiting '||l_proc,15);
1870: end if;
1871: --
1872: exception
1873: --

Line 1932: g_debug := hr_utility.debug_enabled;

1928: --
1929: l_ext_per_bg_id number ;
1930: begin
1931: --
1932: g_debug := hr_utility.debug_enabled;
1933: if g_debug then
1934: l_proc := g_package||'.process_subtrailer';
1935: hr_utility.set_location('Entering'||l_proc, 5);
1936: end if;

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

1931: --
1932: g_debug := hr_utility.debug_enabled;
1933: if g_debug then
1934: l_proc := g_package||'.process_subtrailer';
1935: hr_utility.set_location('Entering'||l_proc, 5);
1936: end if;
1937:
1938: if p_ext_group_elmt1 is null then
1939: process_ext_ht_recs

Line 1980: hr_utility.set_location ('Exiting '||l_proc,15);

1976:
1977:
1978: --
1979: if g_debug then
1980: hr_utility.set_location ('Exiting '||l_proc,15);
1981: end if;
1982: --
1983: --
1984: end process_subtrailer;

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

2076: begin
2077: --
2078: if g_debug then
2079: l_proc := g_package||'.check_all_threads_finished';
2080: hr_utility.set_location ('Entering '||l_proc,5);
2081: end if;
2082: --
2083: if g_num_processes <> 0 then
2084: --

Line 2150: hr_utility.set_location ('Exiting '||l_proc,15);

2146: --
2147: End if;
2148: --
2149: if g_debug then
2150: hr_utility.set_location ('Exiting '||l_proc,15);
2151: end if;
2152: --
2153: end check_all_threads_finished;
2154: --

Line 2248: g_debug := hr_utility.debug_enabled;

2244:
2245:
2246: Begin
2247: --
2248: g_debug := hr_utility.debug_enabled;
2249: if g_debug then
2250: l_proc := g_package||'.do_multithread';
2251: hr_utility.set_location ('Entering '||l_proc,5);
2252: end if;

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

2247: --
2248: g_debug := hr_utility.debug_enabled;
2249: if g_debug then
2250: l_proc := g_package||'.do_multithread';
2251: hr_utility.set_location ('Entering '||l_proc,5);
2252: end if;
2253: g_ext_dfn_id := p_ext_dfn_id;
2254: g_ext_rslt_id := p_ext_rslt_id;
2255: --

Line 2345: hr_utility.set_location (' thread CELT ben/pay ' || g_chg_ext_from_ben || ' / ' || g_chg_ext_from_pay, 99 ) ;

2341: g_chg_ext_from_ben := 'Y' ;
2342: end if ;
2343: close c_celt ;
2344:
2345: hr_utility.set_location (' thread CELT ben/pay ' || g_chg_ext_from_ben || ' / ' || g_chg_ext_from_pay, 99 ) ;
2346: end if ;
2347: --
2348:
2349: --

Line 2427: hr_utility.set_location ('Exiting '||l_proc,15);

2423: end if;
2424: end if;
2425: --
2426: if g_debug then
2427: hr_utility.set_location ('Exiting '||l_proc,15);
2428: end if;
2429: --
2430: Exception
2431: --

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

2537: begin
2538: --
2539: if g_debug then
2540: l_proc := g_package||'.initialize_globals';
2541: hr_utility.set_location ('Entering '||l_proc,5);
2542: end if;
2543: --
2544: for i in 1..g_processes_rec.count loop
2545: if g_processes_rec.exists(i) then

Line 2566: hr_utility.set_location ('Exiting '||l_proc,15);

2562: g_subhdr_cnt := 0;
2563: g_subtrl_cnt := 0;
2564: --
2565: if g_debug then
2566: hr_utility.set_location ('Exiting '||l_proc,15);
2567: end if;
2568: --
2569: end initialize_globals;
2570: -- =======================================================================

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

2582: begin
2583: --
2584: if g_debug then
2585: l_proc := g_package||'.thread_summary';
2586: hr_utility.set_location ('Entering '||l_proc,5);
2587: end if;
2588: --
2589: fnd_file.put_line(fnd_file.log, ' ');
2590: fnd_message.set_name('BEN', 'BEN_92191_ALL_THREAD_LABEL');

Line 2607: hr_utility.set_location ('Exiting '||l_proc,15);

2603: --
2604: fnd_file.put_line(fnd_file.log, ' ');
2605: --
2606: if g_debug then
2607: hr_utility.set_location ('Exiting '||l_proc,15);
2608: end if;
2609: --
2610: end thread_summary;
2611:

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

2653: begin
2654: --
2655: if g_debug then
2656: l_proc := g_package||'.build_adv_criteria';
2657: hr_utility.set_location ('Entering '||l_proc,5);
2658: end if;
2659:
2660: l_sql_string := '' ;
2661: l_first_time := 'Y' ;

Line 2801: hr_utility.set_location ('Exiting '||l_proc,15);

2797:
2798: p_select_statement := l_sql_string ;
2799:
2800: if g_debug then
2801: hr_utility.set_location ('Exiting '||l_proc,15);
2802: end if;
2803:
2804: end ;
2805:

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

2887:
2888: --
2889: if g_debug then
2890: l_proc := g_package||'.chck_non_asg_pay_evt';
2891: hr_utility.set_location ('Entering '||l_proc,5);
2892: end if;
2893:
2894:
2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);

Line 2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);

2891: hr_utility.set_location ('Entering '||l_proc,5);
2892: end if;
2893:
2894:
2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);
2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);
2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);
2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);
2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);

Line 2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);

2892: end if;
2893:
2894:
2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);
2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);
2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);
2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);
2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);
2900:

Line 2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);

2893:
2894:
2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);
2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);
2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);
2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);
2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);
2900:
2901:

Line 2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);

2894:
2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);
2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);
2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);
2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);
2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);
2900:
2901:
2902: l_result := 'N' ;

Line 2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);

2895: hr_utility.set_location ('actual date '||p_actual_from_date ,5);
2896: hr_utility.set_location ('actual date '||p_actual_to_date ,5);
2897: hr_utility.set_location ('effect date '||p_effective_from_date ,5);
2898: hr_utility.set_location ('effect date '||p_effective_to_date ,5);
2899: hr_utility.set_location ('adv cond '||p_adv_crit_exist ,5);
2900:
2901:
2902: l_result := 'N' ;
2903: p_result := 'N' ;

Line 2910: hr_utility.set_location ('Exiting no criteria found '||l_proc,10);

2906: IF c_non_asg_crit%notfound then
2907: -- when there is criteria with non asg table
2908: -- do not process further
2909: close c_non_asg_crit ;
2910: hr_utility.set_location ('Exiting no criteria found '||l_proc,10);
2911: Return ;
2912: End if ;
2913: close c_non_asg_crit ;
2914:

Line 3003: hr_utility.set_location ('Non Asg Pay event found '||l_result,15);

2999: --
3000:
3001: End Loop ;
3002:
3003: hr_utility.set_location ('Non Asg Pay event found '||l_result,15);
3004: p_result := l_result ;
3005: if g_debug then
3006: hr_utility.set_location ('Exiting '||l_proc,15);
3007: end if;

Line 3006: hr_utility.set_location ('Exiting '||l_proc,15);

3002:
3003: hr_utility.set_location ('Non Asg Pay event found '||l_result,15);
3004: p_result := l_result ;
3005: if g_debug then
3006: hr_utility.set_location ('Exiting '||l_proc,15);
3007: end if;
3008:
3009:
3010: End chck_non_asg_pay_evt ;

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

3033:
3034: Begin
3035: if g_debug then
3036: l_proc := g_package||'.get_ext_crit_string';
3037: hr_utility.set_location ('Entering '||l_proc,5);
3038: end if;
3039:
3040: l_crit_all := '' ;
3041: l_first_time := 'Y' ;

Line 3067: hr_utility.set_location ('Exiting '||l_proc,15);

3063: if l_first_time = 'N' then
3064: p_string := '(' || l_crit_all || ')' ;
3065: end if ;
3066:
3067: hr_utility.set_location ('Exiting '||l_proc,15);
3068: End get_ext_crit_string ;
3069:
3070:
3071:

Line 3486: hr_utility.set_location( 'CELT exist ' || g_chg_ext_from_ben || ' / ' || g_chg_ext_from_pay , 99 ) ;

3482: fetch c_rrl into l_rrl_exists, l_rrl_exclude;
3483: close c_rrl;
3484:
3485:
3486: hr_utility.set_location( 'CELT exist ' || g_chg_ext_from_ben || ' / ' || g_chg_ext_from_pay , 99 ) ;
3487:
3488: -- cwb
3489:
3490: open c_wplr;

Line 3664: hr_utility.set_location('DATE FORMAT 1 ', 470);

3660:
3661:
3662:
3663: if g_debug then
3664: hr_utility.set_location('DATE FORMAT 1 ', 470);
3665: end if;
3666: end if;
3667:
3668: -- intitialising

Line 3704: hr_utility.set_location('g_chg_ext_from_pay ' || g_chg_ext_from_pay , 470);

3700: end if ;
3701: -- for Payroll change event
3702: -- when the celt criteria defined and
3703: -- pay is part of the defintion
3704: hr_utility.set_location('g_chg_ext_from_pay ' || g_chg_ext_from_pay , 470);
3705:
3706:
3707: if g_chg_ext_from_pay = 'Y' then
3708: --- calcaulte the date for finding the non asg exisit in pay process events

Line 3744: hr_utility.set_location('calling chck_non_asg_pay_evt ' , 470);

3740: End if ;
3741:
3742: ---- check the payroll non asg exist
3743:
3744: hr_utility.set_location('calling chck_non_asg_pay_evt ' , 470);
3745:
3746: chck_non_asg_pay_evt(
3747: p_ext_crit_prfl_id => p_ext_crit_prfl_id ,
3748: p_ext_dfn_id => p_ext_dfn_id,

Line 3807: hr_utility.set_location('DATE FORMAT 2 ', 470);

3803: end if ;
3804:
3805: -- End Update
3806: if g_debug then
3807: hr_utility.set_location('DATE FORMAT 2 ', 470);
3808: end if;
3809: end if; -- 'C'
3810:
3811: if p_data_typ_cd in ('CM') then

Line 3838: hr_utility.set_location('DATE FORMAT 3 ', 470);

3834: l_dynamic_sql := l_dynamic_sql||' and pcm.business_group_id = '||p_business_group_id||' ' ;
3835: end if ;
3836:
3837: if g_debug then
3838: hr_utility.set_location('DATE FORMAT 3 ', 470);
3839: end if;
3840: end if; -- 'CM'
3841:
3842: --- CWB

Line 4104: hr_utility.set_location('PPT excluded ' || l_ppt_exclude, 99 ) ;

4100:
4101: -- person type usage
4102: if l_ppt_exists = 'Y' then
4103:
4104: hr_utility.set_location('PPT excluded ' || l_ppt_exclude, 99 ) ;
4105: if l_pay_spl_process = 'N' then
4106: if l_ppt_exclude = 'N' then
4107: l_dynamic_sql := l_dynamic_sql || ' and per.person_id in ';
4108: else

Line 4324: hr_utility.set_location(' called from benxthrd 1 '|| l_cad_val1 ,514);

4320: end if; -- CPE
4321: -- change event actual date
4322: if l_cad_exists = 'Y' and p_data_typ_cd in ('C') then
4323: if g_debug then
4324: hr_utility.set_location(' called from benxthrd 1 '|| l_cad_val1 ,514);
4325: end if;
4326: if l_cad_val1 in ('CHAD','CHED') then
4327: l_cad_date_from := hr_api.g_sot ;
4328: l_cad_date_to := hr_api.g_eot ;

Line 4374: hr_utility.set_location(' called from benxthrd 2 '|| l_ced_val1 ,514);

4370: end if; -- CAD
4371: -- chage event Effective date
4372: if l_ced_exists = 'Y' and p_data_typ_cd in ('C') then
4373: if g_debug then
4374: hr_utility.set_location(' called from benxthrd 2 '|| l_ced_val1 ,514);
4375: end if;
4376: if l_ced_val1 in ('CHAD','CHED') then
4377: l_cad_date_from := hr_api.g_sot ;
4378: l_cad_date_to := hr_api.g_eot ;

Line 4576: hr_utility.set_location('pdl excluded ' || l_pdl_exclude, 99 ) ;

4572:
4573:
4574: -- person data link
4575: if l_pdl_exists = 'Y' then
4576: hr_utility.set_location('pdl excluded ' || l_pdl_exclude, 99 ) ;
4577: if l_pdl_exclude = 'N' then
4578: l_dynamic_sql := l_dynamic_sql || ' and EXISTS ';
4579: else
4580: l_dynamic_sql := l_dynamic_sql || ' and not EXISTS ';

Line 4630: hr_utility.set_location( p_data_typ_cd || ' '|| l_wplr_exists , 99 ) ;

4626: end if;
4627:
4628: end if;
4629:
4630: hr_utility.set_location( p_data_typ_cd || ' '|| l_wplr_exists , 99 ) ;
4631:
4632: if l_wplr_exists = 'Y' and p_data_typ_cd in ('CW') then
4633: if l_wplr_exclude = 'N' then
4634: l_dynamic_sql := l_dynamic_sql || ' and exists ' ;

Line 4656: hr_utility.set_location(' first l_dynamic_sql not null ' , 99 );

4652: end if ;
4653:
4654: l_dynamic_sql := l_dynamic_BEN_sql ;
4655: if l_dynamic_sql is not null then
4656: hr_utility.set_location(' first l_dynamic_sql not null ' , 99 );
4657:
4658: if l_dynamic_PAY_sql is not null then
4659: hr_utility.set_location(' first l_dynamic_pay sql not null ' , 99 );
4660: l_dynamic_sql := l_dynamic_sql || ' UNION ' ||

Line 4659: hr_utility.set_location(' first l_dynamic_pay sql not null ' , 99 );

4655: if l_dynamic_sql is not null then
4656: hr_utility.set_location(' first l_dynamic_sql not null ' , 99 );
4657:
4658: if l_dynamic_PAY_sql is not null then
4659: hr_utility.set_location(' first l_dynamic_pay sql not null ' , 99 );
4660: l_dynamic_sql := l_dynamic_sql || ' UNION ' ||
4661: l_dynamic_PAY_sql ;
4662: end if ;
4663: else

Line 4664: hr_utility.set_location(' first l_dynamic_pay sql null ' , 99 );

4660: l_dynamic_sql := l_dynamic_sql || ' UNION ' ||
4661: l_dynamic_PAY_sql ;
4662: end if ;
4663: else
4664: hr_utility.set_location(' first l_dynamic_pay sql null ' , 99 );
4665: if l_dynamic_PAY_sql is not null then
4666: l_dynamic_sql := l_dynamic_PAY_sql ;
4667: end if ;
4668: end if ;

Line 4672: hr_utility.set_location(' build completed ' , 99 );

4668: end if ;
4669:
4670: end if ;
4671:
4672: hr_utility.set_location(' build completed ' , 99 );
4673: p_select_statement := l_dynamic_sql;
4674:
4675: --ptilak(p_select_statement) ;
4676:

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

4717: begin
4718:
4719: l_return := true ;
4720: -- if g_debug then
4721: -- hr_utility.set_location ('Entering '||l_proc,5);
4722: -- hr_utility.set_location ('person '||p_person_id ,5);
4723: -- end if;
4724:
4725: if HR_SECURITY.VIEW_ALL = 'Y' and hr_general.get_xbg_profile = 'Y' then

Line 4722: -- hr_utility.set_location ('person '||p_person_id ,5);

4718:
4719: l_return := true ;
4720: -- if g_debug then
4721: -- hr_utility.set_location ('Entering '||l_proc,5);
4722: -- hr_utility.set_location ('person '||p_person_id ,5);
4723: -- end if;
4724:
4725: if HR_SECURITY.VIEW_ALL = 'Y' and hr_general.get_xbg_profile = 'Y' then
4726: -- hr_utility.set_location ('Exiting '||l_proc,5);

Line 4726: -- hr_utility.set_location ('Exiting '||l_proc,5);

4722: -- hr_utility.set_location ('person '||p_person_id ,5);
4723: -- end if;
4724:
4725: if HR_SECURITY.VIEW_ALL = 'Y' and hr_general.get_xbg_profile = 'Y' then
4726: -- hr_utility.set_location ('Exiting '||l_proc,5);
4727: return l_return ;
4728: end if ;
4729:
4730: /* moved down

Line 4735: -- hr_utility.set_location ('Exiting false'||l_proc,8);

4731: -- this is common validation for asg and person
4732: if hr_general.get_xbg_profile <> 'Y'
4733: and hr_general.get_business_group_id is not null
4734: and hr_general.get_business_group_id <> p_business_group_id then
4735: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4736: Return false ;
4737: end if ;
4738:
4739: */

Line 4746: -- hr_utility.set_location ('assignment not exist dependent ',5);

4742: open c_asg ;
4743: fetch c_asg into l_ASSIGNMENT_TYPE,l_assignment_id, l_business_group_id ;
4744: if c_asg%notfound then
4745: -- if there is no assignmnet, allow the security , it could be dpnt
4746: -- hr_utility.set_location ('assignment not exist dependent ',5);
4747: close c_asg ;
4748: return l_return ;
4749: end if ;
4750: close c_asg ;

Line 4758: -- hr_utility.set_location ('Exiting false'||l_proc,8);

4754: -- this is common validation for asg and person
4755: if hr_general.get_xbg_profile <> 'Y'
4756: and hr_general.get_business_group_id is not null
4757: and hr_general.get_business_group_id <> l_business_group_id then
4758: -- hr_utility.set_location ('Exiting false'||l_proc,8);
4759: Return false ;
4760: end if ;
4761:
4762:

Line 4768: -- hr_utility.set_location ('Exiting false'||l_proc,9);

4764: if l_ASSIGNMENT_TYPE in ('E','C') then
4765:
4766: if HR_SECURITY.VIEW_ALL <> 'Y' and
4767: HR_SECURITY.SHOW_RECORD('PER_ALL_ASSIGNMENTS_F', L_ASSIGNMENT_ID, P_PERSON_ID, L_ASSIGNMENT_TYPE) <> 'TRUE' then
4768: -- hr_utility.set_location ('Exiting false'||l_proc,9);
4769: return false ;
4770: end if ;
4771: end if ;
4772:

Line 4775: -- hr_utility.set_location ('Exiting '||l_proc,15);

4771: end if ;
4772:
4773:
4774: -- if g_debug then
4775: -- hr_utility.set_location ('Exiting '||l_proc,15);
4776: -- end if;
4777: return l_return ;
4778:
4779: end check_asg_security ;

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

4782: l_proc varchar2(80) := g_package||'.init_sub_lvl';
4783: begin
4784:
4785: if g_debug then
4786: hr_utility.set_location ('Entering '||l_proc,5);
4787: end if;
4788: ben_ext_person.g_location_id := null;
4789: ben_ext_person.g_location_code := null;
4790: ben_ext_person.g_location_addr1 := null;

Line 4870: hr_utility.set_location ('Exiting '||l_proc,15);

4866: ben_ext_person.g_grd_flex_10 := null;
4867:
4868:
4869: if g_debug then
4870: hr_utility.set_location ('Exiting '||l_proc,15);
4871: end if;
4872: end init_sub_lvl ;
4873:
4874:

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

5030:
5031: l_person_id := 0 ;
5032: l_include := 'Y' ;
5033: if g_debug then
5034: hr_utility.set_location ('Entering '||l_proc,5);
5035: end if;
5036: --
5037: ben_extract.set_ext_lvls
5038: (p_ext_file_id => p_ext_file_id

Line 5044: hr_utility.set_location ('Exiting no definition found '||l_proc,10);

5040: );
5041:
5042: if nvl(ben_extract.g_subhead_dfn,'N') <> 'Y' then
5043: if g_debug then
5044: hr_utility.set_location ('Exiting no definition found '||l_proc,10);
5045: end if;
5046: return ;
5047: end if ;
5048: --

Line 5066: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||

5062: --
5063: g_ext_dfn_id := p_ext_dfn_id;
5064: g_ext_rslt_id := p_ext_rslt_id;
5065:
5066: hr_utility.set_location ( ' org ' || ben_extract.g_org_lvl || ' pos '|| ben_extract.g_pos_lvl ||
5067: ' pay ' || ben_extract.g_pay_lvl || ' bg ' || ben_extract.g_bg_csr , 99 ) ;
5068: --- get the processing bg
5069: --if ben_extract.g_bg_csr = 'Y' then
5070: open c_pbg ;

Line 5075: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;

5071: fetch c_pbg into
5072: ben_extract.g_proc_business_group_id ,
5073: ben_extract.g_proc_business_group_name;
5074: close c_pbg ;
5075: hr_utility.set_location ( ' proc bg ' || ben_extract.g_proc_business_group_name , 99 ) ;
5076: --end if ;
5077:
5078:
5079: for l_bg in c_bg Loop

Line 5110: hr_utility.set_location ('_organization '||i.name,10);

5106: --- extract organization and postion level
5107: if ben_extract.g_org_lvl = 'Y' or ben_extract.g_pos_lvl = 'Y' then
5108: for i in c_org(l_bg.business_group_id) loop
5109:
5110: hr_utility.set_location ('_organization '||i.name,10);
5111: if ben_extract.g_org_lvl = 'Y' then
5112:
5113: if p_ext_crit_prfl_id is not null then
5114: ben_ext_evaluate_inclusion.Evaluate_subhead_incl

Line 5143: hr_utility.set_location( 'spl flag ' || g_subhdr_chg_log , 99 );

5139: --- position
5140:
5141: if ben_extract.g_pos_lvl = 'Y' then
5142:
5143: hr_utility.set_location( 'spl flag ' || g_subhdr_chg_log , 99 );
5144:
5145: if g_subhdr_chg_log = 'Y' then
5146:
5147: ---

Line 5166: hr_utility.set_location( ' include ' || l_include , 99 );

5162: p_include => l_include,
5163: p_effective_date => p_effective_date
5164: );
5165:
5166: hr_utility.set_location( ' include ' || l_include , 99 );
5167:
5168: end if ;
5169:
5170: -- call the function from per_person_extract

Line 5179: hr_utility.set_location ('position '||j.position_id,10);

5175:
5176: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5177: p_effective_date => p_effective_date) ;
5178:
5179: hr_utility.set_location ('position '||j.position_id,10);
5180: ben_ext_fmt.process_ext_recs(
5181: p_ext_rslt_id => p_ext_rslt_id,
5182: p_ext_file_id => p_ext_file_id,
5183: p_data_typ_cd => p_data_typ_cd,

Line 5220: hr_utility.set_location ('position '||j.position_id,10);

5216: ben_ext_person.g_position_id := j.position_id ;
5217: ben_ext_person.get_pos_info(p_position_id => j.position_id,
5218: p_effective_date => p_effective_date ) ;
5219:
5220: hr_utility.set_location ('position '||j.position_id,10);
5221: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5222: p_ext_file_id => p_ext_file_id,
5223: p_data_typ_cd => p_data_typ_cd,
5224: p_ext_typ_cd => p_ext_typ_cd,

Line 5263: hr_utility.set_location ('payroll id '||j.payroll_id,10);

5259: if l_include = 'Y' then
5260: ben_ext_person.get_payroll_info(p_payroll_id => j.payroll_id,
5261: p_effective_date => p_effective_date ) ;
5262:
5263: hr_utility.set_location ('payroll id '||j.payroll_id,10);
5264: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5265: p_ext_file_id => p_ext_file_id,
5266: p_data_typ_cd => p_data_typ_cd,
5267: p_ext_typ_cd => p_ext_typ_cd,

Line 5304: hr_utility.set_location ('job id '||i.job_id,10);

5300: ben_ext_person.g_job_id := i.job_id ;
5301: ben_ext_person.get_job_info(p_job_id => i.job_id,
5302: p_effective_date => p_effective_date ) ;
5303:
5304: hr_utility.set_location ('job id '||i.job_id,10);
5305: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5306: p_ext_file_id => p_ext_file_id,
5307: p_data_typ_cd => p_data_typ_cd,
5308: p_ext_typ_cd => p_ext_typ_cd,

Line 5342: hr_utility.set_location ('payroll id '||i.location_id,10);

5338: ben_ext_person.g_location_id := i.location_id ;
5339: ben_ext_person.get_loc_info(p_location_id => i.location_id,
5340: p_effective_date => p_effective_date ) ;
5341:
5342: hr_utility.set_location ('payroll id '||i.location_id,10);
5343: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5344: p_ext_file_id => p_ext_file_id,
5345: p_data_typ_cd => p_data_typ_cd,
5346: p_ext_typ_cd => p_ext_typ_cd,

Line 5379: hr_utility.set_location ('grade id '||i.grade_id,10);

5375: ben_ext_person.g_employee_grade_id := i.grade_id ;
5376: ben_ext_person.get_grade_info(p_grade_id => i.grade_id,
5377: p_effective_date => p_effective_date ) ;
5378:
5379: hr_utility.set_location ('grade id '||i.grade_id,10);
5380: ben_ext_fmt.process_ext_recs(p_ext_rslt_id => p_ext_rslt_id,
5381: p_ext_file_id => p_ext_file_id,
5382: p_data_typ_cd => p_data_typ_cd,
5383: p_ext_typ_cd => p_ext_typ_cd,

Line 5402: hr_utility.set_location ('Exiting '||l_proc,15);

5398: end Loop ; -- bg level
5399: --reintialize all the variable before person is extracted
5400: init_sub_lvl ;
5401: if g_debug then
5402: hr_utility.set_location ('Exiting '||l_proc,15);
5403: end if;
5404:
5405: End ;
5406:

Line 5577: g_debug := hr_utility.debug_enabled;

5573: l_fnd_out boolean ;
5574:
5575: Begin
5576: --
5577: g_debug := hr_utility.debug_enabled;
5578: if g_debug then
5579: hr_utility.set_location ('Entering '||l_proc,5);
5580: end if;
5581: --

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

5575: Begin
5576: --
5577: g_debug := hr_utility.debug_enabled;
5578: if g_debug then
5579: hr_utility.set_location ('Entering '||l_proc,5);
5580: end if;
5581: --
5582:
5583: l_conc_request_id := fnd_global.conc_request_id;

Line 5847: hr_utility.set_location(' resilt_id ' || l_ext_rslt_id,177 ) ;

5843: --
5844: end if ;
5845:
5846: if g_debug then
5847: hr_utility.set_location(' resilt_id ' || l_ext_rslt_id,177 ) ;
5848: end if;
5849: benutils.get_parameter
5850: (p_business_group_id => p_business_group_id
5851: ,p_batch_exe_cd => 'BENXTRCT'

Line 6460: hr_utility.set_location ('Exiting '||l_proc,15);

6456: --
6457: end if;
6458: --
6459: if g_debug then
6460: hr_utility.set_location ('Exiting '||l_proc,15);
6461: end if;
6462: --
6463: exception
6464: --

Line 6633: hr_utility.set_location ('Entering '||l_package,10);

6629:
6630: begin
6631: if g_debug then
6632: l_package := g_package||'.ext_restart_clear';
6633: hr_utility.set_location ('Entering '||l_package,10);
6634: hr_utility.set_location ('result_id '||p_ext_rslt_id,10);
6635: end if;
6636:
6637: for pact in per_cursor

Line 6634: hr_utility.set_location ('result_id '||p_ext_rslt_id,10);

6630: begin
6631: if g_debug then
6632: l_package := g_package||'.ext_restart_clear';
6633: hr_utility.set_location ('Entering '||l_package,10);
6634: hr_utility.set_location ('result_id '||p_ext_rslt_id,10);
6635: end if;
6636:
6637: for pact in per_cursor
6638: loop

Line 6641: hr_utility.set_location ('person '||pact.person_id,10);

6637: for pact in per_cursor
6638: loop
6639:
6640: if g_debug then
6641: hr_utility.set_location ('person '||pact.person_id,10);
6642: end if;
6643: ---delete extract results for the person proccessed
6644: --- and in the error range
6645: for xrdt in c_xrdt(pact.person_id)

Line 6649: hr_utility.set_location ('deleting '|| pact.person_id, 177);

6645: for xrdt in c_xrdt(pact.person_id)
6646: loop
6647:
6648: if g_debug then
6649: hr_utility.set_location ('deleting '|| pact.person_id, 177);
6650: end if;
6651:
6652: l_object_version_number := xrdt.object_version_number ;
6653: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL

Line 6664: hr_utility.set_location ('deleting error'||pact.person_id, 177);

6660: for xrer in c_xrer(pact.person_id)
6661: loop
6662:
6663: if g_debug then
6664: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6665: end if;
6666:
6667: l_object_version_number := xrer.object_version_number ;
6668: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

Line 6677: hr_utility.set_location ('Leaving '||l_package,10);

6673: end loop ;
6674:
6675: end loop ;
6676: if g_debug then
6677: hr_utility.set_location ('Leaving '||l_package,10);
6678: end if;
6679: end ext_restart_clear ;
6680: --
6681: --old proc. Not used

Line 6713: g_debug := hr_utility.debug_enabled;

6709: l_retcode number;
6710: l_ext_rslt_id number ;
6711: --
6712: begin
6713: g_debug := hr_utility.debug_enabled;
6714: if g_debug then
6715: l_package := g_package||'.restart';
6716: hr_utility.set_location ('Entering '||l_package,10);
6717: end if;

Line 6716: hr_utility.set_location ('Entering '||l_package,10);

6712: begin
6713: g_debug := hr_utility.debug_enabled;
6714: if g_debug then
6715: l_package := g_package||'.restart';
6716: hr_utility.set_location ('Entering '||l_package,10);
6717: end if;
6718: --
6719: -- get the parameters for a previous run and do a restart
6720: --

Line 6753: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);

6749: if l_ext_rslt_id is not null then
6750: for rng in c_range_err
6751: Loop
6752: if g_debug then
6753: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);
6754: end if;
6755: ext_restart_clear(
6756: p_benefit_action_id => p_benefit_action_id
6757: ,p_ext_rslt_id => l_ext_rslt_id

Line 6780: hr_utility.set_location ('Leaving '||l_package,10);

6776: ,l_parameters.business_group_id
6777: ,l_ext_rslt_id);
6778:
6779: if g_debug then
6780: hr_utility.set_location ('Leaving '||l_package,10);
6781: end if;
6782: end; */
6783: --
6784: --new proc

Line 6846: Hr_Utility.set_location('Entering: '||l_proc_name, 5);

6842:
6843: BEGIN
6844: IF g_debug THEN
6845: l_proc_name := g_package||'.Chk_PQP_Extract';
6846: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6847: END IF;
6848:
6849: OPEN check_pqp_extract (p_ext_dfn_id,
6850: p_business_group_id);

Line 6979: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);

6975: );
6976:
6977: END IF;
6978: IF g_debug THEN
6979: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
6980: END IF;
6981: END Chk_PQP_Extract;
6982:
6983: -- =============================================================================

Line 7022: g_debug := hr_utility.debug_enabled;

7018:
7019:
7020: BEGIN
7021:
7022: g_debug := hr_utility.debug_enabled;
7023: if g_debug then
7024: l_package := g_package||'.restart';
7025: hr_utility.set_location ('Entering '||l_package,10);
7026: end if;

Line 7025: hr_utility.set_location ('Entering '||l_package,10);

7021:
7022: g_debug := hr_utility.debug_enabled;
7023: if g_debug then
7024: l_package := g_package||'.restart';
7025: hr_utility.set_location ('Entering '||l_package,10);
7026: end if;
7027: --
7028: -- get the parameters for a previous run and do a restart
7029: --

Line 7070: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);

7066: if l_ext_rslt_id is not null then
7067: for rng in c_range_err
7068: Loop
7069: if g_debug then
7070: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);
7071: end if;
7072: ext_restart_clear
7073: (p_benefit_action_id => l_benefit_action_id
7074: ,p_ext_rslt_id => l_ext_rslt_id

Line 7107: hr_utility.set_location ('Leaving '||l_package,10);

7103:
7104: */
7105:
7106: if g_debug then
7107: hr_utility.set_location ('Leaving '||l_package,10);
7108: end if;
7109:
7110: end Restart;
7111:

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

7161: begin
7162: --
7163: fnd_msg_pub.initialize;
7164: --
7165: hr_utility.set_location('Entering:'|| l_proc, 10);
7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;

Line 7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;

7162: --
7163: fnd_msg_pub.initialize;
7164: --
7165: hr_utility.set_location('Entering:'|| l_proc, 10);
7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;

Line 7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;

7163: fnd_msg_pub.initialize;
7164: --
7165: hr_utility.set_location('Entering:'|| l_proc, 10);
7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;

Line 7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;

7164: --
7165: hr_utility.set_location('Entering:'|| l_proc, 10);
7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;

Line 7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;

7165: hr_utility.set_location('Entering:'|| l_proc, 10);
7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;

Line 7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;

7166: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7174: --

Line 7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;

7167: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7174: --
7175: --

Line 7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;

7168: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7174: --
7175: --
7176: -- Issue a savepoint if operating in validation only mode

Line 7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;

7169: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7170: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7171: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7172: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7173: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7174: --
7175: --
7176: -- Issue a savepoint if operating in validation only mode
7177: --

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

7176: -- Issue a savepoint if operating in validation only mode
7177: --
7178: savepoint SUBMIT_COPY_REQUEST;
7179: --
7180: hr_utility.set_location(l_proc, 20);
7181:
7182: open c_bg_name ;
7183: fetch c_bg_name into l_business_goup_name ;
7184: if c_bg_name%notfound then

Line 7229: hr_utility.set_location('Bg Name ' || l_business_group_name , 20);

7225: end if ;
7226: end if ;
7227:
7228:
7229: hr_utility.set_location('Bg Name ' || l_business_group_name , 20);
7230:
7231:
7232: if p_file_name is null then
7233: fnd_message.set_name('BEN','BEN_91000_INVALID_FILE_NAME');

Line 7276: hr_utility.set_location(' Leaving:'||l_proc, 70);

7272: end if ;
7273:
7274: -- When in validation only mode raise the Validate_Enabled exception
7275: --
7276: hr_utility.set_location(' Leaving:'||l_proc, 70);
7277: --
7278: exception
7279: --
7280: when app_exception.application_exception then