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.PER_EMPDIR_LEG_OVERRIDE dependencies on PER_EMPDIR_SS

Line 76: per_empdir_ss.write_log(1,

72:
73: EXCEPTION WHEN OTHERS THEN
74: errbuf := errbuf||SQLERRM;
75: retcode := '1';
76: per_empdir_ss.write_log(1,
77: 'Error in pkg: '||g_package||' proc: positions: '||SQLCODE);
78: per_empdir_ss.write_log(1,
79: 'Error Msg: '||substr(SQLERRM,1,700));
80: END positions;

Line 78: per_empdir_ss.write_log(1,

74: errbuf := errbuf||SQLERRM;
75: retcode := '1';
76: per_empdir_ss.write_log(1,
77: 'Error in pkg: '||g_package||' proc: positions: '||SQLCODE);
78: per_empdir_ss.write_log(1,
79: 'Error Msg: '||substr(SQLERRM,1,700));
80: END positions;
81:
82: -- ---------------------------------------------------------------------------

Line 121: per_empdir_ss.write_log(1,

117:
118: EXCEPTION WHEN OTHERS THEN
119: errbuf := errbuf||SQLERRM;
120: retcode := '1';
121: per_empdir_ss.write_log(1,
122: 'Error in pkg: '||g_package||' proc: orgs: '||SQLCODE);
123: per_empdir_ss.write_log(1,
124: 'Error Msg: '||substr(SQLERRM,1,700));
125: END orgs;

Line 123: per_empdir_ss.write_log(1,

119: errbuf := errbuf||SQLERRM;
120: retcode := '1';
121: per_empdir_ss.write_log(1,
122: 'Error in pkg: '||g_package||' proc: orgs: '||SQLCODE);
123: per_empdir_ss.write_log(1,
124: 'Error Msg: '||substr(SQLERRM,1,700));
125: END orgs;
126:
127: -- ---------------------------------------------------------------------------

Line 166: per_empdir_ss.write_log(1,

162:
163: EXCEPTION WHEN OTHERS THEN
164: errbuf := errbuf||SQLERRM;
165: retcode := '1';
166: per_empdir_ss.write_log(1,
167: 'Error in pkg: '||g_package||' proc: jobs: '||SQLCODE);
168: per_empdir_ss.write_log(1,
169: 'Error Msg: '||substr(SQLERRM,1,700));
170: END jobs;

Line 168: per_empdir_ss.write_log(1,

164: errbuf := errbuf||SQLERRM;
165: retcode := '1';
166: per_empdir_ss.write_log(1,
167: 'Error in pkg: '||g_package||' proc: jobs: '||SQLCODE);
168: per_empdir_ss.write_log(1,
169: 'Error Msg: '||substr(SQLERRM,1,700));
170: END jobs;
171:
172: -- ---------------------------------------------------------------------------

Line 211: per_empdir_ss.write_log(1,

207:
208: EXCEPTION WHEN OTHERS THEN
209: errbuf := errbuf||SQLERRM;
210: retcode := '1';
211: per_empdir_ss.write_log(1,
212: 'Error in pkg: '||g_package||' proc: people: '||SQLCODE);
213: per_empdir_ss.write_log(1,
214: 'Error Msg: '||substr(SQLERRM,1,700));
215: END people;

Line 213: per_empdir_ss.write_log(1,

209: errbuf := errbuf||SQLERRM;
210: retcode := '1';
211: per_empdir_ss.write_log(1,
212: 'Error in pkg: '||g_package||' proc: people: '||SQLCODE);
213: per_empdir_ss.write_log(1,
214: 'Error Msg: '||substr(SQLERRM,1,700));
215: END people;
216:
217: -- ---------------------------------------------------------------------------

Line 255: per_empdir_ss.write_log(1,

251:
252: EXCEPTION WHEN OTHERS THEN
253: errbuf := errbuf||SQLERRM;
254: retcode := '1';
255: per_empdir_ss.write_log(1,
256: 'Error in pkg: '||g_package||' proc: asg: '||SQLCODE);
257: per_empdir_ss.write_log(1,
258: 'Error Msg: '||substr(SQLERRM,1,700));
259: END asg;

Line 257: per_empdir_ss.write_log(1,

253: errbuf := errbuf||SQLERRM;
254: retcode := '1';
255: per_empdir_ss.write_log(1,
256: 'Error in pkg: '||g_package||' proc: asg: '||SQLCODE);
257: per_empdir_ss.write_log(1,
258: 'Error Msg: '||substr(SQLERRM,1,700));
259: END asg;
260:
261: -- ---------------------------------------------------------------------------

Line 286: l_style := nvl(per_empdir_ss.locationTbl.country(I)

282: -- Begin Legislation specific overried code
283:
284: IF p_srcSystem = 'PER' THEN
285:
286: l_style := nvl(per_empdir_ss.locationTbl.country(I)
287: ,per_empdir_ss.locationTbl.style(I));
288:
289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||

Line 287: ,per_empdir_ss.locationTbl.style(I));

283:
284: IF p_srcSystem = 'PER' THEN
285:
286: l_style := nvl(per_empdir_ss.locationTbl.country(I)
287: ,per_empdir_ss.locationTbl.style(I));
288:
289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||
291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';

Line 290: l_address := per_empdir_ss.locationTbl.postal_code(I)||

286: l_style := nvl(per_empdir_ss.locationTbl.country(I)
287: ,per_empdir_ss.locationTbl.style(I));
288:
289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||
291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';
292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;

Line 291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';

287: ,per_empdir_ss.locationTbl.style(I));
288:
289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||
291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';
292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN

Line 292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN

288:
289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||
291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';
292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN
296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';

Line 293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';

289: IF (l_style = 'JP') THEN
290: l_address := per_empdir_ss.locationTbl.postal_code(I)||
291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';
292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN
296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';
297: END IF;

Line 295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN

291: '
'||per_empdir_ss.locationTbl.address_line_1(I)||'
';
292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN
296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';
297: END IF;
298: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I);
299:

Line 296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';

292: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
293: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN
296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';
297: END IF;
298: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I);
299:
300: ELSE -- Applying gloabl address format.

Line 298: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I);

294: END IF;
295: IF per_empdir_ss.locationTbl.address_line_3(I) IS NOT NULL THEN
296: l_address := l_address||per_empdir_ss.locationTbl.address_line_3(I)||'
';
297: END IF;
298: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I);
299:
300: ELSE -- Applying gloabl address format.
301:
302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';

Line 302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';

298: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I);
299:
300: ELSE -- Applying gloabl address format.
301:
302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';
303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||

Line 303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN

299:
300: ELSE -- Applying gloabl address format.
301:
302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';
303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||
307: ', '||per_empdir_ss.locationTbl.region_2(I)||

Line 304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';

300: ELSE -- Applying gloabl address format.
301:
302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';
303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||
307: ', '||per_empdir_ss.locationTbl.region_2(I)||
308: ' '||per_empdir_ss.locationTbl.postal_code(I);

Line 306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||

302: l_address := per_empdir_ss.locationTbl.address_line_1(I)||'
';
303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||
307: ', '||per_empdir_ss.locationTbl.region_2(I)||
308: ' '||per_empdir_ss.locationTbl.postal_code(I);
309: END IF;
310:

Line 307: ', '||per_empdir_ss.locationTbl.region_2(I)||

303: IF per_empdir_ss.locationTbl.address_line_2(I) IS NOT NULL THEN
304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||
307: ', '||per_empdir_ss.locationTbl.region_2(I)||
308: ' '||per_empdir_ss.locationTbl.postal_code(I);
309: END IF;
310:
311: -- End Legislation specific overried code

Line 308: ' '||per_empdir_ss.locationTbl.postal_code(I);

304: l_address := l_address||per_empdir_ss.locationTbl.address_line_2(I)||'
';
305: END IF;
306: l_address := l_address||per_empdir_ss.locationTbl.town_or_city(I)||
307: ', '||per_empdir_ss.locationTbl.region_2(I)||
308: ' '||per_empdir_ss.locationTbl.postal_code(I);
309: END IF;
310:
311: -- End Legislation specific overried code
312:

Line 313: per_empdir_ss.locationTbl.address(I) := ' '||l_address||' ';

309: END IF;
310:
311: -- End Legislation specific overried code
312:
313: per_empdir_ss.locationTbl.address(I) := ' '||l_address||' ';
314:
315: IF l_flg THEN
316:
317: -- Invoking customer override call

Line 334: per_empdir_ss.write_log(1,

330:
331: EXCEPTION WHEN OTHERS THEN
332: errbuf := errbuf||SQLERRM;
333: retcode := '1';
334: per_empdir_ss.write_log(1,
335: 'Error in pkg: '||g_package||' proc: locations: '||SQLCODE);
336: per_empdir_ss.write_log(1,
337: 'Error Msg: '||substr(SQLERRM,1,700));
338: END locations;

Line 336: per_empdir_ss.write_log(1,

332: errbuf := errbuf||SQLERRM;
333: retcode := '1';
334: per_empdir_ss.write_log(1,
335: 'Error in pkg: '||g_package||' proc: locations: '||SQLCODE);
336: per_empdir_ss.write_log(1,
337: 'Error Msg: '||substr(SQLERRM,1,700));
338: END locations;
339:
340: END PER_EMPDIR_LEG_OVERRIDE;