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

Line 107: g_debug := hr_utility.debug_enabled;

103:
104: BEGIN
105:
106: l_procedure := g_package || 'check_record_exists';
107: g_debug := hr_utility.debug_enabled;
108: g_debug := TRUE;
109:
110: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
111:

Line 115: hr_utility.trace('Checking contribution base setup');

111:
112: IF p_org_info_type_code = 'PER_CONT_AREA_CONT_BASE_CN' THEN
113:
114: IF g_debug THEN
115: hr_utility.trace('Checking contribution base setup');
116: END IF;
117:
118: OPEN csr_check_cont_base_setup;
119: FETCH csr_check_cont_base_setup INTO l_rec_count;

Line 127: hr_utility.trace('Ended Checking contribution base setup');

123: FETCH csr_future_rec_cont_base INTO l_fut_date;
124: CLOSE csr_future_rec_cont_base;
125:
126: IF g_debug THEN
127: hr_utility.trace('Ended Checking contribution base setup');
128: END IF;
129:
130: ELSIF p_org_info_type_code ='PER_CONT_AREA_PHF_SI_RATES_CN' THEN
131:

Line 133: hr_utility.trace('Checking PHF/SI rates setup');

129:
130: ELSIF p_org_info_type_code ='PER_CONT_AREA_PHF_SI_RATES_CN' THEN
131:
132: IF g_debug THEN
133: hr_utility.trace('Checking PHF/SI rates setup');
134: END IF;
135:
136: OPEN csr_check_phf_si_rates_setup;
137: FETCH csr_check_phf_si_rates_setup INTO l_rec_count;

Line 145: hr_utility.trace('Ended Checking PHF/SI Rates setup');

141: FETCH csr_future_rec_phfsi_base INTO l_fut_date;
142: CLOSE csr_future_rec_phfsi_base;
143:
144: IF g_debug THEN
145: hr_utility.trace('Ended Checking PHF/SI Rates setup');
146: END IF;
147:
148: END IF;
149:

Line 153: hr_utility.trace('Duplicate Record Exists');

149:
150: IF l_rec_count > 0 THEN
151:
152: IF g_debug THEN
153: hr_utility.trace('Duplicate Record Exists');
154: END IF;
155:
156: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
157: hr_utility.raise_error;

Line 156: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

152: IF g_debug THEN
153: hr_utility.trace('Duplicate Record Exists');
154: END IF;
155:
156: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
157: hr_utility.raise_error;
158:
159: ELSIF l_fut_date IS NOT NULL THEN
160:

Line 157: hr_utility.raise_error;

153: hr_utility.trace('Duplicate Record Exists');
154: END IF;
155:
156: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
157: hr_utility.raise_error;
158:
159: ELSIF l_fut_date IS NOT NULL THEN
160:
161: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN

Line 164: hr_utility.trace('Duplicate Record Exists');

160:
161: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN
162:
163: IF g_debug THEN
164: hr_utility.trace('Duplicate Record Exists');
165: END IF;
166:
167: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
168: hr_utility.raise_error; -- bug 9358335 - Moved this line from outer block to this error block

Line 167: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

163: IF g_debug THEN
164: hr_utility.trace('Duplicate Record Exists');
165: END IF;
166:
167: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
168: hr_utility.raise_error; -- bug 9358335 - Moved this line from outer block to this error block
169: END IF;
170:
171: END IF;

Line 168: hr_utility.raise_error; -- bug 9358335 - Moved this line from outer block to this error block

164: hr_utility.trace('Duplicate Record Exists');
165: END IF;
166:
167: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
168: hr_utility.raise_error; -- bug 9358335 - Moved this line from outer block to this error block
169: END IF;
170:
171: END IF;
172:

Line 226: g_debug := hr_utility.debug_enabled;

222:
223: BEGIN
224:
225: l_procedure := g_package || 'check_term_stat_info';
226: g_debug := hr_utility.debug_enabled;
227: g_debug := TRUE;
228:
229:
230: OPEN c_term_info_setup;

Line 241: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

237:
238: hr_cn_api.set_location(g_debug,' l_rec_count : '|| l_rec_count, 20);
239:
240: IF l_rec_count > 0 THEN
241: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
242: hr_utility.raise_error;
243: ELSIF l_fut_date IS NOT NULL THEN
244: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN
245: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

Line 242: hr_utility.raise_error;

238: hr_cn_api.set_location(g_debug,' l_rec_count : '|| l_rec_count, 20);
239:
240: IF l_rec_count > 0 THEN
241: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
242: hr_utility.raise_error;
243: ELSIF l_fut_date IS NOT NULL THEN
244: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN
245: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
246: hr_utility.raise_error;

Line 245: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

241: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
242: hr_utility.raise_error;
243: ELSIF l_fut_date IS NOT NULL THEN
244: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN
245: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
246: hr_utility.raise_error;
247: END IF;
248:
249: END IF;

Line 246: hr_utility.raise_error;

242: hr_utility.raise_error;
243: ELSIF l_fut_date IS NOT NULL THEN
244: IF p_effective_end_date >= l_fut_date OR p_effective_end_date IS NULL THEN
245: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
246: hr_utility.raise_error;
247: END IF;
248:
249: END IF;
250:

Line 290: g_debug := hr_utility.debug_enabled;

286: l_procedure VARCHAR2(100);
287:
288: BEGIN
289: l_procedure := g_package || 'check_single_record';
290: g_debug := hr_utility.debug_enabled;
291: g_debug := TRUE;
292:
293: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
294:

Line 297: hr_utility.trace(' =======================================================');

293: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
294:
295: IF p_org_info_type_code = 'PER_PHF_STAT_INFO_CN' THEN
296: IF g_debug THEN
297: hr_utility.trace(' =======================================================');
298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);

Line 298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);

294:
295: IF p_org_info_type_code = 'PER_PHF_STAT_INFO_CN' THEN
296: IF g_debug THEN
297: hr_utility.trace(' =======================================================');
298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
302: hr_utility.trace(' =======================================================');

Line 299: hr_utility.trace(' . p_organization_id : '||p_organization_id );

295: IF p_org_info_type_code = 'PER_PHF_STAT_INFO_CN' THEN
296: IF g_debug THEN
297: hr_utility.trace(' =======================================================');
298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
302: hr_utility.trace(' =======================================================');
303: END IF;

Line 300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);

296: IF g_debug THEN
297: hr_utility.trace(' =======================================================');
298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
302: hr_utility.trace(' =======================================================');
303: END IF;
304:

Line 301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);

297: hr_utility.trace(' =======================================================');
298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
302: hr_utility.trace(' =======================================================');
303: END IF;
304:
305: OPEN c_phf_high_limit_exempt_setup;

Line 302: hr_utility.trace(' =======================================================');

298: hr_utility.trace(' . p_org_information_id : '||p_org_information_id);
299: hr_utility.trace(' . p_organization_id : '||p_organization_id );
300: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
301: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
302: hr_utility.trace(' =======================================================');
303: END IF;
304:
305: OPEN c_phf_high_limit_exempt_setup;
306: FETCH c_phf_high_limit_exempt_setup INTO l_rec_count;

Line 313: hr_utility.trace('=========================================================');

309: END IF;
310:
311: IF l_rec_count > 0 THEN
312: IF g_debug THEN
313: hr_utility.trace('=========================================================');
314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
315: hr_utility.trace('=========================================================');
316: END IF;
317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

Line 314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');

310:
311: IF l_rec_count > 0 THEN
312: IF g_debug THEN
313: hr_utility.trace('=========================================================');
314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
315: hr_utility.trace('=========================================================');
316: END IF;
317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
318: hr_utility.raise_error;

Line 315: hr_utility.trace('=========================================================');

311: IF l_rec_count > 0 THEN
312: IF g_debug THEN
313: hr_utility.trace('=========================================================');
314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
315: hr_utility.trace('=========================================================');
316: END IF;
317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
318: hr_utility.raise_error;
319: END IF;

Line 317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

313: hr_utility.trace('=========================================================');
314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
315: hr_utility.trace('=========================================================');
316: END IF;
317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
318: hr_utility.raise_error;
319: END IF;
320:
321: hr_cn_api.set_location(g_debug,'Leaving ' || l_procedure,30);

Line 318: hr_utility.raise_error;

314: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
315: hr_utility.trace('=========================================================');
316: END IF;
317: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
318: hr_utility.raise_error;
319: END IF;
320:
321: hr_cn_api.set_location(g_debug,'Leaving ' || l_procedure,30);
322:

Line 360: g_debug := hr_utility.debug_enabled;

356: l_procedure VARCHAR2(100);
357:
358: BEGIN
359: l_procedure := g_package || 'check_single_record_ea';
360: g_debug := hr_utility.debug_enabled;
361: g_debug := TRUE;
362:
363: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
364:

Line 367: hr_utility.trace(' =======================================================');

363: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
364:
365: IF p_org_info_type_code = 'PER_ENN_ANN_TAX_CN' THEN
366: IF g_debug THEN
367: hr_utility.trace(' =======================================================');
368: hr_utility.trace(' . p_organization_id : '||p_organization_id );
369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
371: hr_utility.trace(' =======================================================');

Line 368: hr_utility.trace(' . p_organization_id : '||p_organization_id );

364:
365: IF p_org_info_type_code = 'PER_ENN_ANN_TAX_CN' THEN
366: IF g_debug THEN
367: hr_utility.trace(' =======================================================');
368: hr_utility.trace(' . p_organization_id : '||p_organization_id );
369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
371: hr_utility.trace(' =======================================================');
372: END IF;

Line 369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);

365: IF p_org_info_type_code = 'PER_ENN_ANN_TAX_CN' THEN
366: IF g_debug THEN
367: hr_utility.trace(' =======================================================');
368: hr_utility.trace(' . p_organization_id : '||p_organization_id );
369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
371: hr_utility.trace(' =======================================================');
372: END IF;
373:

Line 370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);

366: IF g_debug THEN
367: hr_utility.trace(' =======================================================');
368: hr_utility.trace(' . p_organization_id : '||p_organization_id );
369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
371: hr_utility.trace(' =======================================================');
372: END IF;
373:
374: OPEN c_phf_high_limit_exempt_setup;

Line 371: hr_utility.trace(' =======================================================');

367: hr_utility.trace(' =======================================================');
368: hr_utility.trace(' . p_organization_id : '||p_organization_id );
369: hr_utility.trace(' . p_org_info_type_code : '||p_org_info_type_code);
370: hr_utility.trace(' . p_org_information1 : '||p_org_information1);
371: hr_utility.trace(' =======================================================');
372: END IF;
373:
374: OPEN c_phf_high_limit_exempt_setup;
375: FETCH c_phf_high_limit_exempt_setup INTO l_rec_count;

Line 382: hr_utility.trace('=========================================================');

378: END IF;
379:
380: IF l_rec_count > 0 THEN
381: IF g_debug THEN
382: hr_utility.trace('=========================================================');
383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
384: hr_utility.trace('=========================================================');
385: END IF;
386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

Line 383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');

379:
380: IF l_rec_count > 0 THEN
381: IF g_debug THEN
382: hr_utility.trace('=========================================================');
383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
384: hr_utility.trace('=========================================================');
385: END IF;
386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
387: hr_utility.raise_error;

Line 384: hr_utility.trace('=========================================================');

380: IF l_rec_count > 0 THEN
381: IF g_debug THEN
382: hr_utility.trace('=========================================================');
383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
384: hr_utility.trace('=========================================================');
385: END IF;
386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
387: hr_utility.raise_error;
388: END IF;

Line 386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');

382: hr_utility.trace('=========================================================');
383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
384: hr_utility.trace('=========================================================');
385: END IF;
386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
387: hr_utility.raise_error;
388: END IF;
389:
390: hr_cn_api.set_location(g_debug,'Leaving ' || l_procedure,30);

Line 387: hr_utility.raise_error;

383: hr_utility.trace('message_name'||'PER_7901_SYS_DUPLICATE_RECORDS');
384: hr_utility.trace('=========================================================');
385: END IF;
386: hr_utility.set_message(800,'PER_7901_SYS_DUPLICATE_RECORDS');
387: hr_utility.raise_error;
388: END IF;
389:
390: hr_cn_api.set_location(g_debug,'Leaving ' || l_procedure,30);
391:

Line 413: g_debug := hr_utility.debug_enabled;

409: E_INVALID_FORMAT_ERR EXCEPTION;
410: BEGIN
411:
412: l_procedure := g_package || 'validate_date';
413: g_debug := hr_utility.debug_enabled;
414:
415: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
416:
417: IF p_effective_end_date IS NOT NULL THEN

Line 430: hr_utility.set_message(800,'PER_CN_INCORRECT_DATES');

426: END IF;
427:
428: EXCEPTION
429: WHEN E_INVALID_FORMAT_ERR THEN
430: hr_utility.set_message(800,'PER_CN_INCORRECT_DATES');
431: hr_cn_api.set_location(g_debug,l_procedure,40);
432: hr_utility.raise_error;
433:
434: END validate_date;

Line 432: hr_utility.raise_error;

428: EXCEPTION
429: WHEN E_INVALID_FORMAT_ERR THEN
430: hr_utility.set_message(800,'PER_CN_INCORRECT_DATES');
431: hr_cn_api.set_location(g_debug,l_procedure,40);
432: hr_utility.raise_error;
433:
434: END validate_date;
435:
436:

Line 485: g_debug := hr_utility.debug_enabled;

481:
482: BEGIN
483:
484: l_procedure := g_package || 'check_cn_org_internal';
485: g_debug := hr_utility.debug_enabled;
486:
487: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
488:
489:

Line 563: hr_utility.trace('Validating Effective Start Date and Effective End Date');

559: /* Changes for bug 8799060 end */
560: ELSIF p_org_info_type_code = 'PER_CONT_AREA_CONT_BASE_CN' THEN
561:
562: IF g_debug THEN
563: hr_utility.trace('Validating Effective Start Date and Effective End Date');
564: END IF;
565:
566: l_start_date := fnd_date.canonical_to_date(p_org_information15);
567: l_end_date := fnd_date.canonical_to_date(NVL(p_org_information16,'4712/12/31 00:00:00'));

Line 572: hr_utility.trace('Checking for Duplicate Record');

568: validate_date(l_start_date
569: ,l_end_date);
570:
571: IF g_debug THEN
572: hr_utility.trace('Checking for Duplicate Record');
573: END IF;
574:
575: check_record_exists(p_org_information_id => p_org_information_id
576: ,p_organization_id => p_organization_id

Line 587: hr_utility.trace('Calling pay_cn_deductions.check_cont_base_setup');

583: ,p_effective_end_date => l_end_date
584: );
585:
586: IF g_debug THEN
587: hr_utility.trace('Calling pay_cn_deductions.check_cont_base_setup');
588: END IF;
589:
590: pay_cn_deductions.check_cont_base_setup
591: (p_organization_id => p_organization_id

Line 618: hr_utility.trace('Validating Effective Start Date and Effective End Date');

614:
615: ELSIF p_org_info_type_code = 'PER_CONT_AREA_PHF_SI_RATES_CN' THEN
616:
617: IF g_debug THEN
618: hr_utility.trace('Validating Effective Start Date and Effective End Date');
619: END IF;
620:
621: l_start_date := fnd_date.canonical_to_date(p_org_information10);
622: l_end_date := fnd_date.canonical_to_date(p_org_information11);

Line 627: hr_utility.trace('Checking for Duplicate Record');

623: validate_date(l_start_date
624: ,l_end_date);
625:
626: IF g_debug THEN
627: hr_utility.trace('Checking for Duplicate Record');
628: END IF;
629:
630: check_record_exists(p_org_information_id => p_org_information_id
631: ,p_organization_id => p_organization_id

Line 642: hr_utility.trace('Calling pay_cn_deductions.check_phf_si_rates_setup');

638: ,p_effective_end_date => l_end_date
639: );
640:
641: IF g_debug THEN
642: hr_utility.trace('Calling pay_cn_deductions.check_phf_si_rates_setup');
643: END IF;
644:
645: pay_cn_deductions.check_phf_si_rates_setup
646: (p_organization_id => p_organization_id

Line 704: g_debug := hr_utility.debug_enabled;

700: l_procedure VARCHAR2(100);
701:
702: BEGIN
703: l_procedure := g_package || 'check_cn_org_info_type_create';
704: g_debug := hr_utility.debug_enabled;
705:
706: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
707:
708: -- Call check_cn_org_internal

Line 741: hr_utility.trace('Message => ' || g_message_name);

737:
738: hr_cn_api.set_location(g_debug,l_procedure,20);
739:
740: IF g_debug THEN
741: hr_utility.trace('Message => ' || g_message_name);
742: END IF;
743:
744: hr_cn_api.raise_message(800
745: ,g_message_name

Line 841: g_debug := hr_utility.debug_enabled;

837:
838: BEGIN
839:
840: l_procedure := g_package || 'check_cn_org_info_type_update';
841: g_debug := hr_utility.debug_enabled;
842:
843: hr_cn_api.set_location(g_debug,'Entering ' || l_procedure,10);
844:
845: OPEN csr_org_info;