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_ADV_CONDITIONS dependencies on HR_UTILITY

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

84: l_err_no number := p_err_no ;
85: --
86: begin
87: --
88: hr_utility.set_location('Entering'||l_proc, 5);
89: --
90: -- form is changed to take the error message and name from error table
91: -- only customised message is sent as parameter to error text bug: 1579767
92: -- instead of error name the null sent as param

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

111: p_business_group_id => ben_ext_person.g_business_group_id,
112: p_ext_rslt_id => ben_extract.g_ext_rslt_id);
113: end if;
114: --
115: hr_utility.set_location('Exiting'||l_proc, 15);
116: --
117: --
118: end write_warning;
119: --

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

125: l_proc varchar2(72) := g_package||'Strip_quotes';
126: l_ret_val varchar2(500) ;
127: begin
128:
129: hr_utility.set_location('Entering'||l_proc, 5);
130: hr_utility.set_location('date '||p_data , 5);
131: l_ret_val := ltrim(rtrim(p_data)) ;
132: if substr(l_ret_val,1,1) = '''' then
133: l_ret_val := substr(l_ret_val,2) ;

Line 130: hr_utility.set_location('date '||p_data , 5);

126: l_ret_val varchar2(500) ;
127: begin
128:
129: hr_utility.set_location('Entering'||l_proc, 5);
130: hr_utility.set_location('date '||p_data , 5);
131: l_ret_val := ltrim(rtrim(p_data)) ;
132: if substr(l_ret_val,1,1) = '''' then
133: l_ret_val := substr(l_ret_val,2) ;
134: end if ;

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

137: if substr(l_ret_val,length(l_ret_val)) = '''' then
138: l_ret_val := substr(l_ret_val,1,length(l_ret_val)-1) ;
139: end if ;
140:
141: hr_utility.set_location('Exiting'||l_proc, 15);
142: return l_ret_val ;
143: end ;
144: -- ----------------------------------------------------------------------------
145: -- |--------------------< rcd_in_file >-----------------------------------|

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

207:
208: --
209: Begin
210: --
211: hr_utility.set_location('Entering'||l_proc, 5);
212: --
213: ben_ext_adv_conditions.g_ext_adv_ct_validation := 'N' ;
214: p_exclude_this_rcd_flag := false;
215: if p_sprs_cd = null then

Line 241: hr_utility.set_location('count '||l_cnt , 5);

237: l_dynamic_condition := 'begin if ';
238: for xwc in c_xwc(p_ext_rcd_in_file_id) loop
239: l_cnt := l_cnt +1;
240:
241: hr_utility.set_location('count '||l_cnt , 5);
242: l_ext_adv_data(l_cnt).name := ':A'||to_char(l_cnt) ;
243:
244: -- strip all quotes out of any values.
245: l_value_without_quotes := replace(ben_ext_fmt.g_val_tab(xwc.seq_num),'''');

Line 280: hr_utility.set_location ( ' l_dummy_var ' || l_dummy_var , 99 ) ;

276: if xwc.oper_cd in ( 'BETWEEN','NOT BETWEEN') then
277:
278: l_cond_cnt := l_cond_cnt +1;
279: l_dummy_var := xwc.val ;
280: hr_utility.set_location ( ' l_dummy_var ' || l_dummy_var , 99 ) ;
281: l_dummy_num := instr(upper(l_dummy_var), 'AND') ;
282: l_ext_adv_conditions(l_cond_cnt).name := ':B'||to_char(l_cond_cnt) ;
283:
284: -- if the data lement is number change the value to number

Line 291: hr_utility.set_location(' number between 1 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

287: xwc.data_elmt_typ_cd = 'R') then
288:
289: begin
290: l_ext_adv_conditions( l_cond_cnt).value := to_number(strip_quote(substr(l_dummy_var,1,l_dummy_num-1)) ) ;
291: hr_utility.set_location(' number between 1 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
292: exception when others then
293: l_ext_adv_conditions( l_cond_cnt).value := strip_quote(substr(l_dummy_var,1,l_dummy_num-1)) ;
294: end ;
295:

Line 302: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

298: l_ext_adv_conditions( l_cond_cnt).name := ':B'||to_char(l_cond_cnt) ;
299:
300: begin
301: l_ext_adv_conditions( l_cond_cnt).value := to_number(strip_quote( substr(l_dummy_var, l_dummy_num+4))) ;
302: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
303: exception when others then
304: l_ext_adv_conditions( l_cond_cnt).value := strip_quote( substr(l_dummy_var, l_dummy_num+4)) ;
305: end ;
306: l_dynamic_condition := l_dynamic_condition || l_ext_adv_conditions( l_cond_cnt).name || ' ' ;

Line 372: hr_utility.set_location(' number =' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

368: xwc.data_elmt_typ_cd = 'R') then
369:
370: begin
371: l_ext_adv_conditions( l_cond_cnt).value := to_number(l_ext_adv_conditions( l_cond_cnt).value) ;
372: hr_utility.set_location(' number =' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
373: exception when others then
374: null ;
375: end ;
376:

Line 381: hr_utility.set_location(' condition '|| l_value_without_quotes , 3);

377: end if ;
378: end if ;
379:
380: l_dynamic_condition := l_dynamic_condition || ' ' || xwc.and_or_cd || ' ' ;
381: hr_utility.set_location(' condition '|| l_value_without_quotes , 3);
382: l_rcd_name := xwc.name ;
383:
384: end loop;
385: -- if there is no data for advanced conditions, exit this program.

Line 389: hr_utility.set_location('out of loop ' , 5);

385: -- if there is no data for advanced conditions, exit this program.
386: if l_cnt = 0 then
387: return;
388: end if;
389: hr_utility.set_location('out of loop ' , 5);
390: l_dynamic_condition := l_dynamic_condition ||
391: ' then :l_condition := ''T''; else :l_condition := ''F''; end if; end;';
392: begin
393: --execute immediate l_dynamic_condition using OUT l_condition;

Line 395: hr_utility.set_location(' parsing '|| l_cnt , 3);

391: ' then :l_condition := ''T''; else :l_condition := ''F''; end if; end;';
392: begin
393: --execute immediate l_dynamic_condition using OUT l_condition;
394:
395: hr_utility.set_location(' parsing '|| l_cnt , 3);
396: l_cursor_name := dbms_sql.open_cursor;
397: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
399: for i in 1 .. l_cnt

Line 398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);

394:
395: hr_utility.set_location(' parsing '|| l_cnt , 3);
396: l_cursor_name := dbms_sql.open_cursor;
397: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
399: for i in 1 .. l_cnt
400: Loop
401:
402: hr_utility.set_location(' bind data '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);

Line 402: hr_utility.set_location(' bind data '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);

398: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
399: for i in 1 .. l_cnt
400: Loop
401:
402: hr_utility.set_location(' bind data '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);
403: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,
404: l_ext_adv_data(i).value);
405: end loop ;
406:

Line 411: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);

407:
408: for i in 1 .. l_cond_cnt
409: Loop
410:
411: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);
412: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
413: l_ext_adv_conditions(i).value);
414: end loop ;
415: dbms_sql.bind_variable(l_cursor_name, ':l_condition' , l_condition, 1 ) ;

Line 422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;

418:
419: dbms_sql.variable_Value(l_cursor_name, ':l_condition' , l_condition ) ;
420:
421: dbms_sql.close_cursor(l_cursor_name);
422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
423:
424: exception
425: when others then
426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;

Line 426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;

422: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
423:
424: exception
425: when others then
426: hr_utility.set_location( 'except ' || substr(sqlerrm,1,100), 99 ) ;
427: fnd_file.put_line(fnd_file.log,
428: 'Error in Advanced Conditions while processing this dynamic sql statement: ');
429: fnd_file.put_line(fnd_file.log, l_dynamic_condition);
430: IF dbms_sql.is_open(l_cursor_name) THEN

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

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

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

549: --
550: --
551: Begin
552: --
553: hr_utility.set_location('Entering'||l_proc, 5);
554: ben_ext_adv_conditions.g_ext_adv_ct_validation := 'N' ;
555: --
556: p_exclude_this_rcd_flag := false;
557:

Line 610: hr_utility.set_location(' oper code ' || xwc.oper_cd , 99 ) ;

606: l_ext_adv_data(l_cnt).value := l_value_without_quotes;
607: end if;
608:
609: l_dynamic_condition := l_dynamic_condition || ' ' || l_ext_adv_data(l_cnt).name || ' ' || xwc.oper_cd || ' ' ;
610: hr_utility.set_location(' oper code ' || xwc.oper_cd , 99 ) ;
611: ----- get the value into array
612: if xwc.oper_cd in ( 'BETWEEN','NOT BETWEEN') then
613:
614: l_cond_cnt := l_cond_cnt +1;

Line 616: hr_utility.set_location ( ' l_dummy_var ' || l_dummy_var , 99 ) ;

612: if xwc.oper_cd in ( 'BETWEEN','NOT BETWEEN') then
613:
614: l_cond_cnt := l_cond_cnt +1;
615: l_dummy_var := xwc.val ;
616: hr_utility.set_location ( ' l_dummy_var ' || l_dummy_var , 99 ) ;
617: l_dummy_num := instr(upper(l_dummy_var), 'AND') ;
618: l_ext_adv_conditions(l_cond_cnt).name := ':B'||to_char(l_cond_cnt) ;
619: -- if the data lement is number change the value to number
620: if (xwc.frmt_mask_typ_cd = 'N' or

Line 626: hr_utility.set_location(' number between 1 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

622: xwc.data_elmt_typ_cd = 'R') then
623:
624: begin
625: l_ext_adv_conditions( l_cond_cnt).value := to_number(strip_quote(substr(l_dummy_var,1,l_dummy_num-1)) ) ;
626: hr_utility.set_location(' number between 1 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
627: exception when others then
628: l_ext_adv_conditions( l_cond_cnt).value := strip_quote(substr(l_dummy_var,1,l_dummy_num-1)) ;
629: end ;
630:

Line 637: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

633: l_ext_adv_conditions( l_cond_cnt).name := ':B'||to_char(l_cond_cnt) ;
634:
635: begin
636: l_ext_adv_conditions( l_cond_cnt).value := to_number(strip_quote( substr(l_dummy_var, l_dummy_num+4))) ;
637: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
638: exception when others then
639: l_ext_adv_conditions( l_cond_cnt).value := strip_quote( substr(l_dummy_var, l_dummy_num+4)) ;
640: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
641: end ;

Line 640: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

636: l_ext_adv_conditions( l_cond_cnt).value := to_number(strip_quote( substr(l_dummy_var, l_dummy_num+4))) ;
637: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
638: exception when others then
639: l_ext_adv_conditions( l_cond_cnt).value := strip_quote( substr(l_dummy_var, l_dummy_num+4)) ;
640: hr_utility.set_location(' number between 2 ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
641: end ;
642: l_dynamic_condition := l_dynamic_condition || l_ext_adv_conditions( l_cond_cnt).name || ' ' ;
643:
644: else

Line 705: hr_utility.set_location(' number = ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;

701: xwc.data_elmt_typ_cd = 'R') then
702:
703: begin
704: l_ext_adv_conditions( l_cond_cnt).value := to_number(l_ext_adv_conditions( l_cond_cnt).value) ;
705: hr_utility.set_location(' number = ' || l_ext_adv_conditions( l_cond_cnt).value , 99 ) ;
706: exception when others then
707: null ;
708: end ;
709:

Line 726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);

722: begin
723: --execute immediate l_dynamic_condition using OUT l_condition;
724: l_cursor_name := dbms_sql.open_cursor;
725: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
727: for i in 1 .. l_cnt
728: Loop
729: hr_utility.set_location(' bind '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);
730: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,

Line 729: hr_utility.set_location(' bind '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);

725: dbms_sql.parse(l_cursor_name, l_dynamic_condition,dbms_sql.v7) ;
726: hr_utility.set_location(' parse the cursor '|| l_cnt , 3);
727: for i in 1 .. l_cnt
728: Loop
729: hr_utility.set_location(' bind '|| l_ext_adv_data(i).name || l_ext_adv_data(i).value , 3);
730: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_data(i).name,
731: l_ext_adv_data(i).value);
732: end loop ;
733:

Line 738: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);

734: -- bind the values from conditions
735: for i in 1 .. l_cond_cnt
736: Loop
737:
738: hr_utility.set_location(' bind cond '|| l_ext_adv_conditions(i).name || l_ext_adv_conditions(i).value , 5);
739: dbms_sql.bind_variable(l_cursor_name, l_ext_adv_conditions(i).name,
740: l_ext_adv_conditions(i).value);
741: end loop ;
742:

Line 760: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;

756: end if ;
757: raise; -- such that the error processing in ben_ext_thread occurs.
758: end;
759: --
760: hr_utility.set_location( 'return from dbms_sql ' || l_condition , 99 ) ;
761: --
762: if l_condition = 'T' then
763:
764: if xer.sprs_cd = 'A' then -- rollback record

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

810: end if;
811: --
812: end loop;
813: --
814: hr_utility.set_location('Exiting'||l_proc, 15);
815: --
816: end data_elmt_in_rcd;
817: --
818: -- ----------------------------------------------------------------------------

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

1459:
1460: --
1461: begin
1462: --
1463: hr_utility.set_location('Entering'||l_proc, 5);
1464: --
1465: p_exclude_this_rcd_flag := false;
1466: --
1467: if p_any_or_all_cd = 'Y' then

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

1791: */
1792:
1793: end if;
1794: --
1795: hr_utility.set_location('Exiting'||l_proc, 15);
1796: --
1797: end prevent_duplicates;
1798: --
1799: -- ----------------------------------------------------------------------------

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

1836: l_dummy varchar2(1);
1837: --
1838: begin
1839: --
1840: hr_utility.set_location('Entering'||l_proc, 5);
1841: --
1842: l_exclude_flag := false;
1843: --
1844:

Line 1845: hr_utility.set_location('p_ext_rcd_in_file_id'||p_ext_rcd_in_file_id, 5);

1841: --
1842: l_exclude_flag := false;
1843: --
1844:
1845: hr_utility.set_location('p_ext_rcd_in_file_id'||p_ext_rcd_in_file_id, 5);
1846: hr_utility.set_location('p_rcd_seq_nu'||p_rcd_seq_num, 5);
1847: if p_ext_rcd_in_file_id is not null then
1848: --
1849: -- for each record load a 'Y' or 'N' into table indicating that

Line 1846: hr_utility.set_location('p_rcd_seq_nu'||p_rcd_seq_num, 5);

1842: l_exclude_flag := false;
1843: --
1844:
1845: hr_utility.set_location('p_ext_rcd_in_file_id'||p_ext_rcd_in_file_id, 5);
1846: hr_utility.set_location('p_rcd_seq_nu'||p_rcd_seq_num, 5);
1847: if p_ext_rcd_in_file_id is not null then
1848: --
1849: -- for each record load a 'Y' or 'N' into table indicating that
1850: -- that there is or is not change events for this record.

Line 1855: hr_utility.set_location('p_ext_rcd_in_file_id found ', 5);

1851: -- This is done only once per record.
1852: --
1853: if g_rcd_list.exists(p_rcd_seq_num) then
1854: --
1855: hr_utility.set_location('p_ext_rcd_in_file_id found ', 5);
1856: null;
1857: else
1858: --
1859: open c_rcd_chg_evt_exist;

Line 1886: hr_utility.set_location('p_ext_data_elmt_in_rcd_id'||p_ext_data_elmt_in_rcd_id, 15);

1882: end if;
1883: --
1884: end if;
1885: --
1886: hr_utility.set_location('p_ext_data_elmt_in_rcd_id'||p_ext_data_elmt_in_rcd_id, 15);
1887: hr_utility.set_location('p_data_elmt_seq_num'||p_data_elmt_seq_num, 15);
1888:
1889: if p_ext_data_elmt_in_rcd_id is not null then
1890: --

Line 1887: hr_utility.set_location('p_data_elmt_seq_num'||p_data_elmt_seq_num, 15);

1883: --
1884: end if;
1885: --
1886: hr_utility.set_location('p_ext_data_elmt_in_rcd_id'||p_ext_data_elmt_in_rcd_id, 15);
1887: hr_utility.set_location('p_data_elmt_seq_num'||p_data_elmt_seq_num, 15);
1888:
1889: if p_ext_data_elmt_in_rcd_id is not null then
1890: --
1891: if g_data_elmt_list.exists(p_data_elmt_seq_num) and

Line 1894: hr_utility.set_location('p_ext_data_elmt_in_rcd_id found', 15);

1890: --
1891: if g_data_elmt_list.exists(p_data_elmt_seq_num) and
1892: g_data_elmt_list_id(p_data_elmt_seq_num) = p_ext_data_elmt_in_rcd_id then
1893: --
1894: hr_utility.set_location('p_ext_data_elmt_in_rcd_id found', 15);
1895: null;
1896: else
1897: open c_data_elmt_chg_evt_exist;
1898: fetch c_data_elmt_chg_evt_exist into l_dummy;

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

1920: --
1921: p_exclude_flag := l_exclude_flag;
1922:
1923: -- to be removed
1924: hr_utility.set_location('Exiting'||l_proc, 15);
1925: --
1926: end chg_evt_incl;
1927: --
1928:

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

2253: l_ext_rslt c_ext_rslt_dtls%rowtype ;
2254: begin
2255:
2256: l_proc := g_package|| '.chg_rcd_merge' ;
2257: hr_utility.set_location('Entering'||l_proc, 5);
2258:
2259: p_ext_chg_rcd_mode := 'C' ;
2260: open c_ext_rslt_dtls ;
2261: fetch c_ext_rslt_dtls into l_ext_rslt ;

Line 2264: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);

2260: open c_ext_rslt_dtls ;
2261: fetch c_ext_rslt_dtls into l_ext_rslt ;
2262: if c_ext_rslt_dtls%notfound then
2263: close c_ext_rslt_dtls ;
2264: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);
2265: hr_utility.set_location('Exiting'||l_proc, 15);
2266: Return ;
2267: end if ;
2268: close c_ext_rslt_dtls ;

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

2261: fetch c_ext_rslt_dtls into l_ext_rslt ;
2262: if c_ext_rslt_dtls%notfound then
2263: close c_ext_rslt_dtls ;
2264: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);
2265: hr_utility.set_location('Exiting'||l_proc, 15);
2266: Return ;
2267: end if ;
2268: close c_ext_rslt_dtls ;
2269:

Line 2577: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);

2573: p_val_299 := nvl(p_val_299,l_ext_rslt.val_299 ) ;
2574: p_val_300 := nvl(p_val_300,l_ext_rslt.val_300 ) ;
2575:
2576:
2577: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);
2578: hr_utility.set_location('Exiting'||l_proc, 15);
2579:
2580: End chg_rcd_merge ;
2581:

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

2574: p_val_300 := nvl(p_val_300,l_ext_rslt.val_300 ) ;
2575:
2576:
2577: hr_utility.set_location('Mode '||p_ext_chg_rcd_mode, 15);
2578: hr_utility.set_location('Exiting'||l_proc, 15);
2579:
2580: End chg_rcd_merge ;
2581:
2582: