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

Line 75: hr_Utility.set_location('Entering'||l_proc, 5);

71: l_ret_val varchar2(10) := 'N' ;
72: l_proc varchar2(72) := g_package||'determine_sub_low_lvl';
73: begin
74:
75: hr_Utility.set_location('Entering'||l_proc, 5);
76: if p_prev_lvl = 'P' and p_lvl in ('CO','G','E','Y','R','F','ED','B','D','A','PR','T','TS','WG','WR') then --- person
77: l_ret_val := 'Y' ;
78: elsif p_prev_lvl in ( 'E') and p_lvl in ('B','D','A','PR') then -- Enrollment
79: l_ret_val := 'Y' ;

Line 105: hr_utility.set_location('p_prev_lvl '|| p_prev_lvl , 15);

101: end if ;
102:
103: g_prev_grop_val := p_group ;
104:
105: hr_utility.set_location('p_prev_lvl '|| p_prev_lvl , 15);
106: hr_utility.set_location('p_lvl '|| p_lvl , 15);
107: hr_utility.set_location('Exiting '|| l_ret_val ||l_proc, 15);
108: return l_ret_val ;
109:

Line 106: hr_utility.set_location('p_lvl '|| p_lvl , 15);

102:
103: g_prev_grop_val := p_group ;
104:
105: hr_utility.set_location('p_prev_lvl '|| p_prev_lvl , 15);
106: hr_utility.set_location('p_lvl '|| p_lvl , 15);
107: hr_utility.set_location('Exiting '|| l_ret_val ||l_proc, 15);
108: return l_ret_val ;
109:
110: end determine_sub_low_lvl;

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

103: g_prev_grop_val := p_group ;
104:
105: hr_utility.set_location('p_prev_lvl '|| p_prev_lvl , 15);
106: hr_utility.set_location('p_lvl '|| p_lvl , 15);
107: hr_utility.set_location('Exiting '|| l_ret_val ||l_proc, 15);
108: return l_ret_val ;
109:
110: end determine_sub_low_lvl;
111:

Line 126: hr_Utility.set_location('Entering'||l_proc, 5);

122: and lookup_code = p_lvl ;
123:
124: begin
125:
126: hr_Utility.set_location('Entering'||l_proc, 5);
127: open c ;
128: fetch c into l_ret_val ;
129: close c ;
130: if l_ret_val is not null then

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

130: if l_ret_val is not null then
131: l_ret_val := translate(l_ret_val ,' !@#$%^&*()-+={}|[]\";:/.,<>?~`','_');
132: end if ;
133:
134: hr_utility.set_location('Exiting '|| l_ret_val ||l_proc, 15);
135: return (l_ret_val ) ;
136:
137: end get_low_lvl_name;
138:

Line 146: hr_Utility.set_location('Entering'||l_proc, 5);

142: l_proc varchar2(72) := g_package||' add_delete_sub_level';
143:
144: l_last number := g_low_lvl_tbl.last ;
145: begin
146: hr_Utility.set_location('Entering'||l_proc, 5);
147: hr_Utility.set_location(p_action ||' / '||p_low_lvl_cd , 5);
148:
149:
150: hr_Utility.set_location('p_action'||p_action, 5);

Line 147: hr_Utility.set_location(p_action ||' / '||p_low_lvl_cd , 5);

143:
144: l_last number := g_low_lvl_tbl.last ;
145: begin
146: hr_Utility.set_location('Entering'||l_proc, 5);
147: hr_Utility.set_location(p_action ||' / '||p_low_lvl_cd , 5);
148:
149:
150: hr_Utility.set_location('p_action'||p_action, 5);
151: hr_Utility.set_location('l_last '||l_last, 5);

Line 150: hr_Utility.set_location('p_action'||p_action, 5);

146: hr_Utility.set_location('Entering'||l_proc, 5);
147: hr_Utility.set_location(p_action ||' / '||p_low_lvl_cd , 5);
148:
149:
150: hr_Utility.set_location('p_action'||p_action, 5);
151: hr_Utility.set_location('l_last '||l_last, 5);
152:
153: if p_action = 'ADD' then
154: g_low_lvl_tbl(( nvl(l_last,0) + 1)) := p_low_lvl_cd ;

Line 151: hr_Utility.set_location('l_last '||l_last, 5);

147: hr_Utility.set_location(p_action ||' / '||p_low_lvl_cd , 5);
148:
149:
150: hr_Utility.set_location('p_action'||p_action, 5);
151: hr_Utility.set_location('l_last '||l_last, 5);
152:
153: if p_action = 'ADD' then
154: g_low_lvl_tbl(( nvl(l_last,0) + 1)) := p_low_lvl_cd ;
155: end if ;

Line 161: hr_Utility.set_location('delete '||j, 5);

157: if p_action = 'DELETE' then
158:
159: for j in REVERSE 1 .. l_last Loop
160: if g_low_lvl_tbl(j) = p_low_lvl_cd then
161: hr_Utility.set_location('delete '||j, 5);
162: g_low_lvl_tbl.delete(j) ;
163: exit ;
164: end if ;
165: end loop ;

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

164: end if ;
165: end loop ;
166:
167: end if ;
168: hr_utility.set_location('Exiting ' ||l_proc, 15);
169:
170: end add_delete_sub_level ;
171:
172:

Line 202: --hr_Utility.set_location('Entering'||l_proc, 5);

198: l_found varchar2(1) := 'N' ;
199: l_last number := nvl(p_tag_table.last,0) ;
200: begin
201:
202: --hr_Utility.set_location('Entering'||l_proc, 5);
203: if p_tag_table.first is not null then
204: for i in 1 .. l_last loop
205: if p_tag_table(i) = p_tag then
206: l_found := 'Y' ;

Line 216: --hr_utility.set_location('Exiting '||p_tag_table.last ||l_proc, 15);

212: p_tag_table(( nvl(l_last,0) + 1)) := p_tag ;
213: end if ;
214:
215:
216: --hr_utility.set_location('Exiting '||p_tag_table.last ||l_proc, 15);
217: End Load_tags;
218:
219:
220: Procedure write_style_sheet

Line 235: hr_Utility.set_location('Entering'||l_proc, 5);

231: l_output_name ben_ext_rslt.output_name%type ;
232:
233: Begin
234: --
235: hr_Utility.set_location('Entering'||l_proc, 5);
236: --l_output_name := 'benxxssh.xsl' ;
237: l_output_name := nvl(p_file_name, 'benxxssh') || '.xsl' ;
238: --
239:

Line 240: hr_Utility.set_location('out put '||l_output_name|| ' / '|| p_drctry_name, 5);

236: --l_output_name := 'benxxssh.xsl' ;
237: l_output_name := nvl(p_file_name, 'benxxssh') || '.xsl' ;
238: --
239:
240: hr_Utility.set_location('out put '||l_output_name|| ' / '|| p_drctry_name, 5);
241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');

Line 242: hr_Utility.set_location(' after header ', 5);

238: --
239:
240: hr_Utility.set_location('out put '||l_output_name|| ' / '|| p_drctry_name, 5);
241: file_handle := utl_file.fopen (p_drctry_name,l_output_name,'w' , l_max_ext_line_size );
242: hr_Utility.set_location(' after header ', 5);
243: --- Write the xml header
244: utl_file.put_line(file_handle, '');
245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');

Line 249: hr_Utility.set_location(' after header ', 5);

245: utl_file.put_line(file_handle, '');
246: utl_file.put_line(file_handle, '');
247: utl_file.put_line(file_handle, ' ');
248:
249: hr_Utility.set_location(' after header ', 5);
250: l_var := '
251:

252:
253:

Line 305: hr_Utility.set_location('out put '||l_var, 5);

301: l_var := '
302:
303: ' ;
304:
305: hr_Utility.set_location('out put '||l_var, 5);
306: utl_file.put_line(file_handle,l_var );
307: ---
308: utl_file.put_line(file_handle, ' ');
309: utl_file.put_line(file_handle, '');

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

313:
314: -- write to logfile the record count
315: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');
316: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;
317: hr_utility.set_location('Exiting'||l_proc, 15);
318:
319: END write_style_sheet;
320:
321:

Line 338: hr_Utility.set_location('Entering'||l_proc, 5);

334: l_output_name ben_ext_rslt.output_name%type ;
335:
336: Begin
337: --
338: hr_Utility.set_location('Entering'||l_proc, 5);
339:
340: l_output_name := nvl(p_file_name,'benxxsch' ) || '.xsd' ;
341: --l_output_name := 'benxxsch.xsd' ;
342:

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

463:
464: -- write to logfile the record count
465: fnd_message.set_name('BEN','BEN_91878_EXT_TTL_RCRDS');
466: fnd_file.put_line(fnd_file.log,fnd_message.get || ' ' || p_drctry_name||'/'||l_output_name ) ;
467: hr_utility.set_location('Exiting'||l_proc, 15);
468:
469:
470:
471:

Line 507: hr_Utility.set_location('Entering'||l_proc, 5);

503: where template_id = p_template_id ;
504:
505: Begin
506: --
507: hr_Utility.set_location('Entering'||l_proc, 5);
508:
509:
510:
511: open c_xdo(p_template_id) ;

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

544: );
545:
546: end if ;
547:
548: hr_utility.set_location('Exiting'||l_proc, 15);
549:
550: END write_xdo_pdf;
551:
552:

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

862: l_proc varchar2(72) := g_package||'load_arrays';
863: --
864: begin
865: --
866: hr_utility.set_location('Entering'||l_proc, 5);
867: --
868: ben_ext_write.g_val(01) := ext_xml_encode( p_val_01) ;
869: ben_ext_write.g_val(02) := ext_xml_encode( p_val_02) ;
870: ben_ext_write.g_val(03) := ext_xml_encode( p_val_03) ;

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

1167: ben_ext_write.g_val(300) := ext_xml_encode( p_val_300 );
1168:
1169:
1170: --
1171: hr_utility.set_location('Exiting'||l_proc, 15);
1172: --
1173: --
1174: end load_arrays;
1175: -----------------------------------------------------------------------------

Line 1628: hr_Utility.set_location('Entering'||l_proc, 5);

1624: from fnd_concurrent_requests
1625: where request_id = fnd_global.conc_request_id ;
1626: begin
1627: --
1628: hr_Utility.set_location('Entering'||l_proc, 5);
1629:
1630: fnd_profile.get( NAME => 'ICX_CLIENT_IANA_ENCODING'
1631: ,VAL => g_iana_char_set );
1632: if g_iana_char_set is null then

Line 1636: hr_Utility.set_location('iana character '|| l_output_name, 5);

1632: if g_iana_char_set is null then
1633: g_iana_char_set := 'UTF-8' ;
1634: end if ;
1635:
1636: hr_Utility.set_location('iana character '|| l_output_name, 5);
1637:
1638: --- Process for xml_file l_xml_result
1639: l_output_name := rtrim(p_output_name);
1640:

Line 2149: hr_utility.set_location(' close record ' || l_ext_rcd.xml_tag_name , 99 );

2145: if l_Low_lvl_grouping = 'N' then
2146: if l_new_rec <> l_xrd.ext_rcd_id then
2147: -- closing the element for previous record
2148: if l_new_rec <> -1 then
2149: hr_utility.set_location(' close record ' || l_ext_rcd.xml_tag_name , 99 );
2150:
2151: if l_cm_display_flag = 'Y' then
2152: fnd_file.put_line(fnd_file.OUTPUT, '');
2153: else

Line 2178: hr_utility.set_location(' new person ' || g_low_lvl_tbl(j) , 99 );

2174: or ( g_low_lvl_tbl(j) in ('PO','OR','PY','JB','LO') and
2175: nvl(l_xrd.group_val_01 ,'-1') = nvl(g_prev_grop_val,'-1') and
2176: l_xrd.group_val_01 <> ' ' )
2177: then
2178: hr_utility.set_location(' new person ' || g_low_lvl_tbl(j) , 99 );
2179: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;
2180: l_prev_levl_found := 'Y' ;
2181: exit ;
2182: end if ;

Line 2185: hr_utility.set_location(' close level ' || l_low_lvl_name , 99 );

2181: exit ;
2182: end if ;
2183: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;
2184: l_low_lvl_name := get_low_lvl_name(l_prv_low_lvl_cd) ;
2185: hr_utility.set_location(' close level ' || l_low_lvl_name , 99 );
2186: l_var:= ' ' ;
2187: --utl_file.put_line(file_handle, l_var );
2188: if l_cm_display_flag = 'Y' then
2189: fnd_file.put_line(fnd_file.OUTPUT, l_var);

Line 2246: hr_utility.set_location(' new record ' || l_xrd.ext_rcd_id , 99 );

2242: if l_new_rec <> -2 then
2243: l_rec_num := 0 ;
2244: end if ;
2245:
2246: hr_utility.set_location(' new record ' || l_xrd.ext_rcd_id , 99 );
2247: l_new_rec := l_xrd.ext_rcd_id ;
2248:
2249: --- Get the Extract Record Information
2250: open c_ext_rcd( l_ext_file.ext_file_id ,

Line 2290: hr_utility.set_location('closing previous level' || l_prv_low_lvl_cd , 99 );

2286: else
2287: -- when the level not the same and not subgroup
2288: -- close the element till it find the same or subgroup
2289: -- close the previous level
2290: hr_utility.set_location('closing previous level' || l_prv_low_lvl_cd , 99 );
2291: l_prev_levl_found := 'N' ;
2292: for j in REVERSE 1 .. g_low_lvl_tbl.count loop
2293:
2294: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;

Line 2295: hr_utility.set_location(' prv '||l_prv_low_lvl_cd|| ' curr '|| l_ext_rcd.low_lvl_cd , 99 ) ;

2291: l_prev_levl_found := 'N' ;
2292: for j in REVERSE 1 .. g_low_lvl_tbl.count loop
2293:
2294: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;
2295: hr_utility.set_location(' prv '||l_prv_low_lvl_cd|| ' curr '|| l_ext_rcd.low_lvl_cd , 99 ) ;
2296: if l_prv_low_lvl_cd = l_ext_rcd.low_lvl_cd and
2297: nvl(l_xrd.group_val_01,'-1') = nvl(g_prev_grop_val,'-1') then
2298: -- close the previous element and open a new element
2299: l_low_lvl_name := get_low_lvl_name(l_ext_rcd.low_lvl_cd) ;

Line 2335: hr_utility.set_location( ' closingi prv levl ' || l_low_lvl_name , 99 ) ;

2331: exit ;
2332: else
2333: add_delete_sub_level('DELETE' , l_prv_low_lvl_cd ) ;
2334: l_low_lvl_name := get_low_lvl_name(l_prv_low_lvl_cd) ;
2335: hr_utility.set_location( ' closingi prv levl ' || l_low_lvl_name , 99 ) ;
2336: l_var:= ' ' ;
2337: --utl_file.put_line(file_handle, l_var );
2338: if l_cm_display_flag = 'Y' then
2339: fnd_file.put_line(fnd_file.OUTPUT, l_var);

Line 2461: hr_utility.set_location ( ' out of loop ' , 99 ) ;

2457: end if ;
2458:
2459: end loop ;
2460: --- Close the elements
2461: hr_utility.set_location ( ' out of loop ' , 99 ) ;
2462:
2463: if l_Low_lvl_grouping = 'Y' then
2464: for j in REVERSE 1 .. g_low_lvl_tbl.count loop
2465: l_prv_low_lvl_cd := g_low_lvl_tbl(j) ;

Line 2510: hr_utility.set_location( ' calling xdo ', 99 );

2506:
2507:
2508:
2509:
2510: hr_utility.set_location( ' calling xdo ', 99 );
2511: write_xdo_pdf
2512: (p_drctry_name => l_directory_name ,
2513: p_pdf_output_name => l_pdf_output_name,
2514: p_input_name => l_output_name,

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

2546: end if ;
2547: */
2548:
2549:
2550: hr_utility.set_location('Exiting'||l_proc, 15);
2551: --
2552: --
2553: EXCEPTION
2554: --

Line 2582: hr_utility.set_location( 'other exception raised ' , 99 ) ;

2578: fnd_message.raise_error;
2579: --
2580:
2581: WHEN others THEN
2582: hr_utility.set_location( 'other exception raised ' , 99 ) ;
2583: fnd_message.set_name('PER','FFU10_GENERAL_ORACLE_ERROR');
2584: fnd_message.set_token('2',substr(sqlerrm,1,200));
2585: fnd_file.put_line(fnd_file.log, fnd_message.get);
2586: fnd_message.raise_error;