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 238: g_debug boolean := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 775: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1268: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1934: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

Line 2250: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 5583: g_debug := hr_utility.debug_enabled;

5579: l_rule_value varchar2(30);
5580:
5581: Begin
5582: --
5583: g_debug := hr_utility.debug_enabled;
5584: if g_debug then
5585: hr_utility.set_location ('Entering '||l_proc,5);
5586: end if;
5587: --

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

5581: Begin
5582: --
5583: g_debug := hr_utility.debug_enabled;
5584: if g_debug then
5585: hr_utility.set_location ('Entering '||l_proc,5);
5586: end if;
5587: --
5588:
5589: l_conc_request_id := fnd_global.conc_request_id;

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

5849: --
5850: end if ;
5851:
5852: if g_debug then
5853: hr_utility.set_location(' resilt_id ' || l_ext_rslt_id,177 ) ;
5854: end if;
5855: benutils.get_parameter
5856: (p_business_group_id => p_business_group_id
5857: ,p_batch_exe_cd => 'BENXTRCT'

Line 5996: hr_utility.set_location ('Calling Ben_batch_utils.person_selection_rule...',100);

5992: --
5993: /* Bug 13509481 */
5994: if p_person_selection_rl is not null then
5995: --
5996: hr_utility.set_location ('Calling Ben_batch_utils.person_selection_rule...',100);
5997: hr_utility.set_location ('l_rec.person_id '||l_rec.person_id,100);
5998: l_rule_value :=
5999: ben_batch_utils.person_selection_rule
6000: (p_person_id => l_rec.person_id

Line 5997: hr_utility.set_location ('l_rec.person_id '||l_rec.person_id,100);

5993: /* Bug 13509481 */
5994: if p_person_selection_rl is not null then
5995: --
5996: hr_utility.set_location ('Calling Ben_batch_utils.person_selection_rule...',100);
5997: hr_utility.set_location ('l_rec.person_id '||l_rec.person_id,100);
5998: l_rule_value :=
5999: ben_batch_utils.person_selection_rule
6000: (p_person_id => l_rec.person_id
6001: ,p_business_group_id => p_business_group_id

Line 6004: hr_utility.set_location ('l_rule_value '||l_rule_value,100);

6000: (p_person_id => l_rec.person_id
6001: ,p_business_group_id => p_business_group_id
6002: ,p_person_selection_rule_id => p_person_selection_rl
6003: ,p_effective_date => l_effective_date);
6004: hr_utility.set_location ('l_rule_value '||l_rule_value,100);
6005: --
6006: if l_rule_value = 'N' then
6007: l_skip := TRUE;
6008: elsif l_rule_value = 'Y' then

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

6497: --
6498: end if;
6499: --
6500: if g_debug then
6501: hr_utility.set_location ('Exiting '||l_proc,15);
6502: end if;
6503: --
6504: exception
6505: --

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

6670:
6671: begin
6672: if g_debug then
6673: l_package := g_package||'.ext_restart_clear';
6674: hr_utility.set_location ('Entering '||l_package,10);
6675: hr_utility.set_location ('result_id '||p_ext_rslt_id,10);
6676: end if;
6677:
6678: for pact in per_cursor

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

6671: begin
6672: if g_debug then
6673: l_package := g_package||'.ext_restart_clear';
6674: hr_utility.set_location ('Entering '||l_package,10);
6675: hr_utility.set_location ('result_id '||p_ext_rslt_id,10);
6676: end if;
6677:
6678: for pact in per_cursor
6679: loop

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

6678: for pact in per_cursor
6679: loop
6680:
6681: if g_debug then
6682: hr_utility.set_location ('person '||pact.person_id,10);
6683: end if;
6684: ---delete extract results for the person proccessed
6685: --- and in the error range
6686: for xrdt in c_xrdt(pact.person_id)

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

6686: for xrdt in c_xrdt(pact.person_id)
6687: loop
6688:
6689: if g_debug then
6690: hr_utility.set_location ('deleting '|| pact.person_id, 177);
6691: end if;
6692:
6693: l_object_version_number := xrdt.object_version_number ;
6694: ben_EXT_RSLT_DTL_api.delete_EXT_RSLT_DTL

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

6701: for xrer in c_xrer(pact.person_id)
6702: loop
6703:
6704: if g_debug then
6705: hr_utility.set_location ('deleting error'||pact.person_id, 177);
6706: end if;
6707:
6708: l_object_version_number := xrer.object_version_number ;
6709: ben_EXT_RSLT_ERR_api.delete_EXT_RSLT_ERR

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

6714: end loop ;
6715:
6716: end loop ;
6717: if g_debug then
6718: hr_utility.set_location ('Leaving '||l_package,10);
6719: end if;
6720: end ext_restart_clear ;
6721: --
6722: --old proc. Not used

Line 6754: g_debug := hr_utility.debug_enabled;

6750: l_retcode number;
6751: l_ext_rslt_id number ;
6752: --
6753: begin
6754: g_debug := hr_utility.debug_enabled;
6755: if g_debug then
6756: l_package := g_package||'.restart';
6757: hr_utility.set_location ('Entering '||l_package,10);
6758: end if;

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

6753: begin
6754: g_debug := hr_utility.debug_enabled;
6755: if g_debug then
6756: l_package := g_package||'.restart';
6757: hr_utility.set_location ('Entering '||l_package,10);
6758: end if;
6759: --
6760: -- get the parameters for a previous run and do a restart
6761: --

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

6790: if l_ext_rslt_id is not null then
6791: for rng in c_range_err
6792: Loop
6793: if g_debug then
6794: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);
6795: end if;
6796: ext_restart_clear(
6797: p_benefit_action_id => p_benefit_action_id
6798: ,p_ext_rslt_id => l_ext_rslt_id

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

6817: ,l_parameters.business_group_id
6818: ,l_ext_rslt_id);
6819:
6820: if g_debug then
6821: hr_utility.set_location ('Leaving '||l_package,10);
6822: end if;
6823: end; */
6824: --
6825: --new proc

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

6883:
6884: BEGIN
6885: IF g_debug THEN
6886: l_proc_name := g_package||'.Chk_PQP_Extract';
6887: Hr_Utility.set_location('Entering: '||l_proc_name, 5);
6888: END IF;
6889:
6890: OPEN check_pqp_extract (p_ext_dfn_id,
6891: p_business_group_id);

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

7016: );
7017:
7018: END IF;
7019: IF g_debug THEN
7020: Hr_Utility.set_location('Leaving: '||l_proc_name, 80);
7021: END IF;
7022: END Chk_PQP_Extract;
7023:
7024: -- =============================================================================

Line 7063: g_debug := hr_utility.debug_enabled;

7059:
7060:
7061: BEGIN
7062:
7063: g_debug := hr_utility.debug_enabled;
7064: if g_debug then
7065: l_package := g_package||'.restart';
7066: hr_utility.set_location ('Entering '||l_package,10);
7067: end if;

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

7062:
7063: g_debug := hr_utility.debug_enabled;
7064: if g_debug then
7065: l_package := g_package||'.restart';
7066: hr_utility.set_location ('Entering '||l_package,10);
7067: end if;
7068: --
7069: -- get the parameters for a previous run and do a restart
7070: --

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

7107: if l_ext_rslt_id is not null then
7108: for rng in c_range_err
7109: Loop
7110: if g_debug then
7111: hr_utility.set_location ('range id '||rng.starting_person_action_id,10);
7112: end if;
7113: ext_restart_clear
7114: (p_benefit_action_id => l_benefit_action_id
7115: ,p_ext_rslt_id => l_ext_rslt_id

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

7144:
7145: */
7146:
7147: if g_debug then
7148: hr_utility.set_location ('Leaving '||l_package,10);
7149: end if;
7150:
7151: end Restart;
7152:

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

7202: begin
7203: --
7204: fnd_msg_pub.initialize;
7205: --
7206: hr_utility.set_location('Entering:'|| l_proc, 10);
7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;

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

7203: --
7204: fnd_msg_pub.initialize;
7205: --
7206: hr_utility.set_location('Entering:'|| l_proc, 10);
7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;

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

7204: fnd_msg_pub.initialize;
7205: --
7206: hr_utility.set_location('Entering:'|| l_proc, 10);
7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;

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

7205: --
7206: hr_utility.set_location('Entering:'|| l_proc, 10);
7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;

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

7206: hr_utility.set_location('Entering:'|| l_proc, 10);
7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7214: hr_utility.set_location('p_validate '|| p_validate ,10) ;

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

7207: hr_utility.set_location('p_mode '|| p_mode ,10) ;
7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7214: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7215: --

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

7208: hr_utility.set_location('p_seeded '|| p_seeded ,10) ;
7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7214: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7215: --
7216: --

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

7209: hr_utility.set_location('p_loader_file '|| p_loader_file,10) ;
7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7214: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7215: --
7216: --
7217: -- Issue a savepoint if operating in validation only mode

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

7210: hr_utility.set_location('p_file_name '|| p_file_name ,10) ;
7211: hr_utility.set_location('p_view_name '|| p_view_name,10) ;
7212: hr_utility.set_location('p_extract_file_id'||p_extract_file_id ,10) ;
7213: hr_utility.set_location('p_business_group_id'||p_business_group_id ,10) ;
7214: hr_utility.set_location('p_validate '|| p_validate ,10) ;
7215: --
7216: --
7217: -- Issue a savepoint if operating in validation only mode
7218: --

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

7217: -- Issue a savepoint if operating in validation only mode
7218: --
7219: savepoint SUBMIT_COPY_REQUEST;
7220: --
7221: hr_utility.set_location(l_proc, 20);
7222:
7223: open c_bg_name ;
7224: fetch c_bg_name into l_business_goup_name ;
7225: if c_bg_name%notfound then

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

7266: end if ;
7267: end if ;
7268:
7269:
7270: hr_utility.set_location('Bg Name ' || l_business_group_name , 20);
7271:
7272:
7273: if p_file_name is null then
7274: fnd_message.set_name('BEN','BEN_91000_INVALID_FILE_NAME');

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

7313: end if ;
7314:
7315: -- When in validation only mode raise the Validate_Enabled exception
7316: --
7317: hr_utility.set_location(' Leaving:'||l_proc, 70);
7318: --
7319: exception
7320: --
7321: when app_exception.application_exception then