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.PQP_AAD_BUS dependencies on HR_UTILITY

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := pqp_aad_shd.api_updating
47: (p_analyzed_data_id => p_analyzed_data_id,
48: p_object_version_number => p_object_version_number);

Line 72: hr_utility.set_location('Leaving:'||l_proc, 10);

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_analyzed_data_id;
75: --
76: -- ----------------------------------------------------------------------------

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

108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := pqp_aad_shd.api_updating
115: (p_analyzed_data_id => p_analyzed_data_id,
116: p_object_version_number => p_object_version_number);

Line 133: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

129: p_effective_date => p_effective_date) then
130: --
131: -- raise error as does not exist as lookup
132: --
133: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
134: hr_utility.set_message_token('COLUMN','withldg_allow_eligible_flag' );
135: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
136: hr_utility.raise_error;
137: --

Line 134: hr_utility.set_message_token('COLUMN','withldg_allow_eligible_flag' );

130: --
131: -- raise error as does not exist as lookup
132: --
133: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
134: hr_utility.set_message_token('COLUMN','withldg_allow_eligible_flag' );
135: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
136: hr_utility.raise_error;
137: --
138: end if;

Line 135: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );

131: -- raise error as does not exist as lookup
132: --
133: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
134: hr_utility.set_message_token('COLUMN','withldg_allow_eligible_flag' );
135: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
136: hr_utility.raise_error;
137: --
138: end if;
139: --

Line 136: hr_utility.raise_error;

132: --
133: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
134: hr_utility.set_message_token('COLUMN','withldg_allow_eligible_flag' );
135: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
136: hr_utility.raise_error;
137: --
138: end if;
139: --
140: end if;

Line 142: hr_utility.set_location('Leaving:'||l_proc,10);

138: end if;
139: --
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc,10);
143: --
144: end chk_withldg_allow_elig_flag;
145: --
146: -- ----------------------------------------------------------------------------

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

179: l_api_updating BOOLEAN;
180: --
181: BEGIN
182: --
183: hr_utility.set_location('Entering:'||l_proc, 5);
184: --
185: l_api_updating := pqp_aad_shd.api_updating
186: (p_analyzed_data_id => p_analyzed_data_id ,
187: p_object_version_number => p_object_version_number);

Line 204: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

200: p_effective_date => p_effective_date ) THEN
201: --
202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
205: hr_utility.set_message_token('COLUMN','current_residency_status' );
206: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_RES_STATUS' );
207: hr_utility.raise_error;
208: --

Line 205: hr_utility.set_message_token('COLUMN','current_residency_status' );

201: --
202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
205: hr_utility.set_message_token('COLUMN','current_residency_status' );
206: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_RES_STATUS' );
207: hr_utility.raise_error;
208: --
209: END IF;

Line 206: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_RES_STATUS' );

202: -- raise error as does not exist as lookup
203: --
204: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
205: hr_utility.set_message_token('COLUMN','current_residency_status' );
206: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_RES_STATUS' );
207: hr_utility.raise_error;
208: --
209: END IF;
210: --

Line 207: hr_utility.raise_error;

203: --
204: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
205: hr_utility.set_message_token('COLUMN','current_residency_status' );
206: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_RES_STATUS' );
207: hr_utility.raise_error;
208: --
209: END IF;
210: --
211: END IF;

Line 213: hr_utility.set_location('Leaving:'||l_proc,10);

209: END IF;
210: --
211: END IF;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: END chk_current_residency_status;
216: --
217: -- ----------------------------------------------------------------------------

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

250: l_api_updating BOOLEAN;
251: --
252: BEGIN
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: l_api_updating := pqp_aad_shd.api_updating
257: (p_analyzed_data_id => p_analyzed_data_id ,
258: p_object_version_number => p_object_version_number);

Line 275: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

271: p_effective_date => p_effective_date ) THEN
272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
276: hr_utility.set_message_token('COLUMN','tax_residence_country_code');
277: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_COUNTRY_CODE' );
278: hr_utility.raise_error;
279: --

Line 276: hr_utility.set_message_token('COLUMN','tax_residence_country_code');

272: --
273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
276: hr_utility.set_message_token('COLUMN','tax_residence_country_code');
277: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_COUNTRY_CODE' );
278: hr_utility.raise_error;
279: --
280: END IF;

Line 277: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_COUNTRY_CODE' );

273: -- raise error as does not exist as lookup
274: --
275: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
276: hr_utility.set_message_token('COLUMN','tax_residence_country_code');
277: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_COUNTRY_CODE' );
278: hr_utility.raise_error;
279: --
280: END IF;
281: --

Line 278: hr_utility.raise_error;

274: --
275: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
276: hr_utility.set_message_token('COLUMN','tax_residence_country_code');
277: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_COUNTRY_CODE' );
278: hr_utility.raise_error;
279: --
280: END IF;
281: --
282: END IF;

Line 284: hr_utility.set_location('Leaving:'||l_proc,10);

280: END IF;
281: --
282: END IF;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: END chk_tax_residence_country_code;
287: --
288: -- ----------------------------------------------------------------------------

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

320: l_api_updating BOOLEAN;
321: --
322: BEGIN
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := pqp_aad_shd.api_updating
327: (p_analyzed_data_id => p_analyzed_data_id ,
328: p_object_version_number => p_object_version_number);

Line 345: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

341: p_effective_date => p_effective_date ) THEN
342: --
343: -- raise error as does not exist as lookup
344: --
345: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
346: hr_utility.set_message_token('COLUMN','record_source');
347: hr_utility.set_message_token('LOOKUP_TYPE', 'PQP_US_RECORD_SOURCE');
348: hr_utility.raise_error;
349: --

Line 346: hr_utility.set_message_token('COLUMN','record_source');

342: --
343: -- raise error as does not exist as lookup
344: --
345: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
346: hr_utility.set_message_token('COLUMN','record_source');
347: hr_utility.set_message_token('LOOKUP_TYPE', 'PQP_US_RECORD_SOURCE');
348: hr_utility.raise_error;
349: --
350: END IF;

Line 347: hr_utility.set_message_token('LOOKUP_TYPE', 'PQP_US_RECORD_SOURCE');

343: -- raise error as does not exist as lookup
344: --
345: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
346: hr_utility.set_message_token('COLUMN','record_source');
347: hr_utility.set_message_token('LOOKUP_TYPE', 'PQP_US_RECORD_SOURCE');
348: hr_utility.raise_error;
349: --
350: END IF;
351: --

Line 348: hr_utility.raise_error;

344: --
345: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
346: hr_utility.set_message_token('COLUMN','record_source');
347: hr_utility.set_message_token('LOOKUP_TYPE', 'PQP_US_RECORD_SOURCE');
348: hr_utility.raise_error;
349: --
350: END IF;
351: --
352: END IF;

Line 354: hr_utility.set_location('Leaving:'||l_proc,10);

350: END IF;
351: --
352: END IF;
353: --
354: hr_utility.set_location('Leaving:'||l_proc,10);
355: --
356: END chk_record_source;
357: --
358: -- ----------------------------------------------------------------------------

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

390: l_api_updating BOOLEAN;
391: --
392: BEGIN
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := pqp_aad_shd.api_updating
397: (p_analyzed_data_id => p_analyzed_data_id ,
398: p_object_version_number => p_object_version_number);

Line 415: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

411: p_effective_date => p_effective_date ) THEN
412: --
413: -- raise error as does not exist as lookup
414: --
415: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
416: hr_utility.set_message_token('COLUMN','visa_type');
417: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_VISA_TYPES');
418: hr_utility.raise_error;
419: --

Line 416: hr_utility.set_message_token('COLUMN','visa_type');

412: --
413: -- raise error as does not exist as lookup
414: --
415: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
416: hr_utility.set_message_token('COLUMN','visa_type');
417: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_VISA_TYPES');
418: hr_utility.raise_error;
419: --
420: END IF;

Line 417: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_VISA_TYPES');

413: -- raise error as does not exist as lookup
414: --
415: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
416: hr_utility.set_message_token('COLUMN','visa_type');
417: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_VISA_TYPES');
418: hr_utility.raise_error;
419: --
420: END IF;
421: --

Line 418: hr_utility.raise_error;

414: --
415: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
416: hr_utility.set_message_token('COLUMN','visa_type');
417: hr_utility.set_message_token('LOOKUP_TYPE', 'PER_US_VISA_TYPES');
418: hr_utility.raise_error;
419: --
420: END IF;
421: --
422: END IF;

Line 424: hr_utility.set_location('Leaving:'||l_proc,10);

420: END IF;
421: --
422: END IF;
423: --
424: hr_utility.set_location('Leaving:'||l_proc,10);
425: --
426: END chk_visa_type;
427: --
428: -- ----------------------------------------------------------------------------

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

460: l_api_updating BOOLEAN;
461: --
462: BEGIN
463: --
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: l_api_updating := pqp_aad_shd.api_updating
467: (p_analyzed_data_id => p_analyzed_data_id ,
468: p_object_version_number => p_object_version_number);

Line 485: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

481: p_effective_date => p_effective_date ) THEN
482: --
483: -- raise error as does not exist as lookup
484: --
485: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
486: hr_utility.set_message_token('COLUMN','j_sub_type' );
487: hr_utility.set_message_token('LOOKUP_TYPE',
488: 'PER_US_VISA_CATEGORIES');
489: hr_utility.raise_error;

Line 486: hr_utility.set_message_token('COLUMN','j_sub_type' );

482: --
483: -- raise error as does not exist as lookup
484: --
485: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
486: hr_utility.set_message_token('COLUMN','j_sub_type' );
487: hr_utility.set_message_token('LOOKUP_TYPE',
488: 'PER_US_VISA_CATEGORIES');
489: hr_utility.raise_error;
490: --

Line 487: hr_utility.set_message_token('LOOKUP_TYPE',

483: -- raise error as does not exist as lookup
484: --
485: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
486: hr_utility.set_message_token('COLUMN','j_sub_type' );
487: hr_utility.set_message_token('LOOKUP_TYPE',
488: 'PER_US_VISA_CATEGORIES');
489: hr_utility.raise_error;
490: --
491: END IF;

Line 489: hr_utility.raise_error;

485: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
486: hr_utility.set_message_token('COLUMN','j_sub_type' );
487: hr_utility.set_message_token('LOOKUP_TYPE',
488: 'PER_US_VISA_CATEGORIES');
489: hr_utility.raise_error;
490: --
491: END IF;
492: --
493: END IF;

Line 495: hr_utility.set_location('Leaving:'||l_proc,10);

491: END IF;
492: --
493: END IF;
494: --
495: hr_utility.set_location('Leaving:'||l_proc,10);
496: --
497: END chk_j_sub_type;
498: --
499: -- ----------------------------------------------------------------------------

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

531: l_api_updating BOOLEAN;
532: --
533: BEGIN
534: --
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: l_api_updating := pqp_aad_shd.api_updating
538: (p_analyzed_data_id => p_analyzed_data_id ,
539: p_object_version_number => p_object_version_number);

Line 556: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

552: p_effective_date => p_effective_date ) THEN
553: --
554: -- raise error as does not exist as lookup
555: --
556: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
557: hr_utility.set_message_token('COLUMN','primary_activity' );
558: hr_utility.set_message_token('LOOKUP_TYPE',
559: 'PQP_US_PRIMARY_ACTIVITY');
560: hr_utility.raise_error;

Line 557: hr_utility.set_message_token('COLUMN','primary_activity' );

553: --
554: -- raise error as does not exist as lookup
555: --
556: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
557: hr_utility.set_message_token('COLUMN','primary_activity' );
558: hr_utility.set_message_token('LOOKUP_TYPE',
559: 'PQP_US_PRIMARY_ACTIVITY');
560: hr_utility.raise_error;
561: --

Line 558: hr_utility.set_message_token('LOOKUP_TYPE',

554: -- raise error as does not exist as lookup
555: --
556: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
557: hr_utility.set_message_token('COLUMN','primary_activity' );
558: hr_utility.set_message_token('LOOKUP_TYPE',
559: 'PQP_US_PRIMARY_ACTIVITY');
560: hr_utility.raise_error;
561: --
562: END IF;

Line 560: hr_utility.raise_error;

556: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
557: hr_utility.set_message_token('COLUMN','primary_activity' );
558: hr_utility.set_message_token('LOOKUP_TYPE',
559: 'PQP_US_PRIMARY_ACTIVITY');
560: hr_utility.raise_error;
561: --
562: END IF;
563: --
564: END IF;

Line 566: hr_utility.set_location('Leaving:'||l_proc,10);

562: END IF;
563: --
564: END IF;
565: --
566: hr_utility.set_location('Leaving:'||l_proc,10);
567: --
568: END chk_primary_activity;
569: --
570: -- ----------------------------------------------------------------------------

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

602: l_api_updating BOOLEAN;
603: --
604: BEGIN
605: --
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: l_api_updating := pqp_aad_shd.api_updating
609: (p_analyzed_data_id => p_analyzed_data_id ,
610: p_object_version_number => p_object_version_number);

Line 627: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );

623: p_effective_date => p_effective_date ) THEN
624: --
625: -- raise error as does not exist as lookup
626: --
627: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
628: hr_utility.set_message_token('COLUMN','non_us_country_code' );
629: hr_utility.set_message_token('LOOKUP_TYPE', '');
630: hr_utility.raise_error;
631: --

Line 628: hr_utility.set_message_token('COLUMN','non_us_country_code' );

624: --
625: -- raise error as does not exist as lookup
626: --
627: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
628: hr_utility.set_message_token('COLUMN','non_us_country_code' );
629: hr_utility.set_message_token('LOOKUP_TYPE', '');
630: hr_utility.raise_error;
631: --
632: END IF;

Line 629: hr_utility.set_message_token('LOOKUP_TYPE', '');

625: -- raise error as does not exist as lookup
626: --
627: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
628: hr_utility.set_message_token('COLUMN','non_us_country_code' );
629: hr_utility.set_message_token('LOOKUP_TYPE', '');
630: hr_utility.raise_error;
631: --
632: END IF;
633: --

Line 630: hr_utility.raise_error;

626: --
627: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
628: hr_utility.set_message_token('COLUMN','non_us_country_code' );
629: hr_utility.set_message_token('LOOKUP_TYPE', '');
630: hr_utility.raise_error;
631: --
632: END IF;
633: --
634: END IF;

Line 636: hr_utility.set_location('Leaving:'||l_proc,10);

632: END IF;
633: --
634: END IF;
635: --
636: hr_utility.set_location('Leaving:'||l_proc,10);
637: --
638: END chk_non_us_country_code;
639: --
640: -- ----------------------------------------------------------------------------

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

672: l_api_updating BOOLEAN;
673: --
674: BEGIN
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := pqp_aad_shd.api_updating
679: (p_analyzed_data_id => p_analyzed_data_id ,
680: p_object_version_number => p_object_version_number);

Line 697: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

693: p_effective_date => p_effective_date ) THEN
694: --
695: -- raise error as does not exist as lookup
696: --
697: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
698: hr_utility.raise_error;
699: --
700: END IF;
701: --

Line 698: hr_utility.raise_error;

694: --
695: -- raise error as does not exist as lookup
696: --
697: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
698: hr_utility.raise_error;
699: --
700: END IF;
701: --
702: END IF;

Line 704: hr_utility.set_location('Leaving:'||l_proc,10);

700: END IF;
701: --
702: END IF;
703: --
704: hr_utility.set_location('Leaving:'||l_proc,10);
705: --
706: END chk_citizenship_country_code;
707: --
708: -- ----------------------------------------------------------------------------

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

713: --
714: l_proc varchar2(72) := g_package||'insert_validate';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: chk_analyzed_data_id

Line 784: hr_utility.set_location(' Leaving:'||l_proc, 10);

780: -- p_object_version_number => p_rec.object_version_number ) ;
781: --
782: --
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
785: End insert_validate;
786: --
787: -- ----------------------------------------------------------------------------
788: -- |---------------------------< update_validate >----------------------------|

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

792: --
793: l_proc varchar2(72) := g_package||'update_validate';
794: --
795: Begin
796: hr_utility.set_location('Entering:'||l_proc, 5);
797: --
798: -- Call all supporting business operations
799: --
800: chk_analyzed_data_id

Line 860: hr_utility.set_location(' Leaving:'||l_proc, 10);

856: -- p_object_version_number => p_rec.object_version_number ) ;
857: --
858: --
859: --
860: hr_utility.set_location(' Leaving:'||l_proc, 10);
861: End update_validate;
862: --
863: -- ----------------------------------------------------------------------------
864: -- |---------------------------< delete_validate >----------------------------|

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

868: --
869: l_proc varchar2(72) := g_package||'delete_validate';
870: --
871: Begin
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: -- Call all supporting business operations
875: --
876: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 876: hr_utility.set_location(' Leaving:'||l_proc, 10);

872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: -- Call all supporting business operations
875: --
876: hr_utility.set_location(' Leaving:'||l_proc, 10);
877: End delete_validate;
878: --
879: end pqp_aad_bus;