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_DET_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_det_shd.api_updating
47: (p_analyzed_data_details_id => p_analyzed_data_details_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_details_id;
75: --
76: -- ----------------------------------------------------------------------------

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

112: where a.analyzed_data_id = p_analyzed_data_id;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc,5);
117: --
118: l_api_updating := pqp_det_shd.api_updating
119: (p_analyzed_data_details_id => p_analyzed_data_details_id,
120: p_object_version_number => p_object_version_number);

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

143: close c1;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: End chk_analyzed_data_id;
150: --
151: -- ----------------------------------------------------------------------------

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := pqp_det_shd.api_updating
190: (p_analyzed_data_details_id => p_analyzed_data_details_id,
191: p_object_version_number => p_object_version_number);

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

204: p_effective_date => p_effective_date) then
205: --
206: -- raise error as does not exist as lookup
207: --
208: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
209: hr_utility.set_message_token('COLUMN','retro_lose_ben_amt_flag' );
210: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
211: hr_utility.raise_error;
212: --

Line 209: hr_utility.set_message_token('COLUMN','retro_lose_ben_amt_flag' );

205: --
206: -- raise error as does not exist as lookup
207: --
208: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
209: hr_utility.set_message_token('COLUMN','retro_lose_ben_amt_flag' );
210: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
211: hr_utility.raise_error;
212: --
213: end if;

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

206: -- raise error as does not exist as lookup
207: --
208: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
209: hr_utility.set_message_token('COLUMN','retro_lose_ben_amt_flag' );
210: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
211: hr_utility.raise_error;
212: --
213: end if;
214: --

Line 211: hr_utility.raise_error;

207: --
208: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
209: hr_utility.set_message_token('COLUMN','retro_lose_ben_amt_flag' );
210: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
211: hr_utility.raise_error;
212: --
213: end if;
214: --
215: end if;

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_retro_lose_ben_amt_flag;
220: --
221: -- ----------------------------------------------------------------------------

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

253: l_api_updating boolean;
254: --
255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := pqp_det_shd.api_updating
260: (p_analyzed_data_details_id => p_analyzed_data_details_id,
261: p_object_version_number => p_object_version_number);

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

274: p_effective_date => p_effective_date) then
275: --
276: -- raise error as does not exist as lookup
277: --
278: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
279: hr_utility.set_message_token('COLUMN','treaty_ben_allowed_flag' );
280: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
281: hr_utility.raise_error;
282: --

Line 279: hr_utility.set_message_token('COLUMN','treaty_ben_allowed_flag' );

275: --
276: -- raise error as does not exist as lookup
277: --
278: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
279: hr_utility.set_message_token('COLUMN','treaty_ben_allowed_flag' );
280: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
281: hr_utility.raise_error;
282: --
283: end if;

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

276: -- raise error as does not exist as lookup
277: --
278: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
279: hr_utility.set_message_token('COLUMN','treaty_ben_allowed_flag' );
280: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
281: hr_utility.raise_error;
282: --
283: end if;
284: --

Line 281: hr_utility.raise_error;

277: --
278: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
279: hr_utility.set_message_token('COLUMN','treaty_ben_allowed_flag' );
280: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
281: hr_utility.raise_error;
282: --
283: end if;
284: --
285: end if;

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

283: end if;
284: --
285: end if;
286: --
287: hr_utility.set_location('Leaving:'||l_proc,10);
288: --
289: end chk_treaty_ben_allowed_flag;
290: --
291: -- ----------------------------------------------------------------------------

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

323: l_api_updating boolean;
324: --
325: Begin
326: --
327: hr_utility.set_location('Entering:'||l_proc, 5);
328: --
329: l_api_updating := pqp_det_shd.api_updating
330: (p_analyzed_data_details_id => p_analyzed_data_details_id,
331: p_object_version_number => p_object_version_number);

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

344: p_effective_date => p_effective_date) then
345: --
346: -- raise error as does not exist as lookup
347: --
348: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
349: hr_utility.set_message_token('COLUMN','addl_withholding_flag' );
350: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
351: hr_utility.raise_error;
352: --

Line 349: hr_utility.set_message_token('COLUMN','addl_withholding_flag' );

345: --
346: -- raise error as does not exist as lookup
347: --
348: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
349: hr_utility.set_message_token('COLUMN','addl_withholding_flag' );
350: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
351: hr_utility.raise_error;
352: --
353: end if;

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

346: -- raise error as does not exist as lookup
347: --
348: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
349: hr_utility.set_message_token('COLUMN','addl_withholding_flag' );
350: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
351: hr_utility.raise_error;
352: --
353: end if;
354: --

Line 351: hr_utility.raise_error;

347: --
348: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
349: hr_utility.set_message_token('COLUMN','addl_withholding_flag' );
350: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
351: hr_utility.raise_error;
352: --
353: end if;
354: --
355: end if;

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

353: end if;
354: --
355: end if;
356: --
357: hr_utility.set_location('Leaving:'||l_proc,10);
358: --
359: end chk_addl_withholding_flag;
360: --
361: -- ----------------------------------------------------------------------------

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

393: l_api_updating boolean;
394: --
395: Begin
396: --
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: l_api_updating := pqp_det_shd.api_updating
400: (p_analyzed_data_details_id => p_analyzed_data_details_id,
401: p_object_version_number => p_object_version_number);

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

414: p_effective_date => p_effective_date) then
415: --
416: -- raise error as does not exist as lookup
417: --
418: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
419: hr_utility.set_message_token('COLUMN','retro_lose_ben_date_flag' );
420: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
421: hr_utility.raise_error;
422: --

Line 419: hr_utility.set_message_token('COLUMN','retro_lose_ben_date_flag' );

415: --
416: -- raise error as does not exist as lookup
417: --
418: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
419: hr_utility.set_message_token('COLUMN','retro_lose_ben_date_flag' );
420: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
421: hr_utility.raise_error;
422: --
423: end if;

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

416: -- raise error as does not exist as lookup
417: --
418: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
419: hr_utility.set_message_token('COLUMN','retro_lose_ben_date_flag' );
420: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
421: hr_utility.raise_error;
422: --
423: end if;
424: --

Line 421: hr_utility.raise_error;

417: --
418: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
419: hr_utility.set_message_token('COLUMN','retro_lose_ben_date_flag' );
420: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
421: hr_utility.raise_error;
422: --
423: end if;
424: --
425: end if;

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

423: end if;
424: --
425: end if;
426: --
427: hr_utility.set_location('Leaving:'||l_proc,10);
428: --
429: end chk_retro_lose_ben_date_flag;
430: --
431: -- ----------------------------------------------------------------------------

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

463: l_api_updating BOOLEAN;
464: --
465: BEGIN
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := pqp_det_shd.api_updating
470: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
471: p_object_version_number => p_object_version_number);

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

484: p_effective_date => p_effective_date ) THEN
485: --
486: -- raise error as does not exist as lookup
487: --
488: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
489: hr_utility.set_message_token('COLUMN','student_exempt_from_ss' );
490: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
491: hr_utility.raise_error;
492: --

Line 489: hr_utility.set_message_token('COLUMN','student_exempt_from_ss' );

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

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

486: -- raise error as does not exist as lookup
487: --
488: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
489: hr_utility.set_message_token('COLUMN','student_exempt_from_ss' );
490: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
491: hr_utility.raise_error;
492: --
493: END IF;
494: --

Line 491: hr_utility.raise_error;

487: --
488: hr_utility.set_message(801,'HR_52966_INVALID_LOOKUP' );
489: hr_utility.set_message_token('COLUMN','student_exempt_from_ss' );
490: hr_utility.set_message_token('LOOKUP_TYPE', 'PQH_YES_NO' );
491: hr_utility.raise_error;
492: --
493: END IF;
494: --
495: END IF;

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

493: END IF;
494: --
495: END IF;
496: --
497: hr_utility.set_location('Leaving:'||l_proc,10);
498: --
499: END chk_student_exempt_from_ss;
500: --
501: -- ----------------------------------------------------------------------------

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

533: l_api_updating BOOLEAN;
534: --
535: BEGIN
536: --
537: hr_utility.set_location('Entering:'||l_proc, 5);
538: --
539: l_api_updating := pqp_det_shd.api_updating
540: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
541: p_object_version_number => p_object_version_number);

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

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

Line 559: hr_utility.set_message_token('COLUMN','nra_exempt_from_ss' );

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

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

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

Line 561: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 629: hr_utility.set_message_token('COLUMN','nra_exempt_from_medicare' );

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

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

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

Line 631: hr_utility.raise_error;

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

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

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

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

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

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

694: p_effective_date => p_effective_date ) THEN
695: --
696: -- raise error as does not exist as lookup
697: --
698: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
699: hr_utility.set_message_token('COLUMN', 'income_code' );
700: hr_utility.set_message_token('LOOKUP_TYPE',
701: 'PER_US_INCOME_TYPES' );
702: hr_utility.raise_error;

Line 699: hr_utility.set_message_token('COLUMN', 'income_code' );

695: --
696: -- raise error as does not exist as lookup
697: --
698: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
699: hr_utility.set_message_token('COLUMN', 'income_code' );
700: hr_utility.set_message_token('LOOKUP_TYPE',
701: 'PER_US_INCOME_TYPES' );
702: hr_utility.raise_error;
703: --

Line 700: hr_utility.set_message_token('LOOKUP_TYPE',

696: -- raise error as does not exist as lookup
697: --
698: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
699: hr_utility.set_message_token('COLUMN', 'income_code' );
700: hr_utility.set_message_token('LOOKUP_TYPE',
701: 'PER_US_INCOME_TYPES' );
702: hr_utility.raise_error;
703: --
704: END IF;

Line 702: hr_utility.raise_error;

698: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
699: hr_utility.set_message_token('COLUMN', 'income_code' );
700: hr_utility.set_message_token('LOOKUP_TYPE',
701: 'PER_US_INCOME_TYPES' );
702: hr_utility.raise_error;
703: --
704: END IF;
705: --
706: END IF;

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

704: END IF;
705: --
706: END IF;
707: --
708: hr_utility.set_location('Leaving:'||l_proc,10);
709: --
710: END chk_income_code;
711: --
712: -- |------< chk_income_code_sub_type >------|

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

743: l_api_updating BOOLEAN;
744: --
745: BEGIN
746: --
747: hr_utility.set_location('Entering:'||l_proc, 5);
748: --
749: l_api_updating := pqp_det_shd.api_updating
750: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
751: p_object_version_number => p_object_version_number);

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

764: p_effective_date => p_effective_date ) THEN
765: --
766: -- raise error as does not exist as lookup
767: --
768: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
769: hr_utility.set_message_token('COLUMN', 'income_code_sub_type' );
770: hr_utility.set_message_token('LOOKUP_TYPE',
771: 'PQP_US_INCOME_CODE_SUB_TYPE' );
772: hr_utility.raise_error;

Line 769: hr_utility.set_message_token('COLUMN', 'income_code_sub_type' );

765: --
766: -- raise error as does not exist as lookup
767: --
768: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
769: hr_utility.set_message_token('COLUMN', 'income_code_sub_type' );
770: hr_utility.set_message_token('LOOKUP_TYPE',
771: 'PQP_US_INCOME_CODE_SUB_TYPE' );
772: hr_utility.raise_error;
773: --

Line 770: hr_utility.set_message_token('LOOKUP_TYPE',

766: -- raise error as does not exist as lookup
767: --
768: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
769: hr_utility.set_message_token('COLUMN', 'income_code_sub_type' );
770: hr_utility.set_message_token('LOOKUP_TYPE',
771: 'PQP_US_INCOME_CODE_SUB_TYPE' );
772: hr_utility.raise_error;
773: --
774: END IF;

Line 772: hr_utility.raise_error;

768: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
769: hr_utility.set_message_token('COLUMN', 'income_code_sub_type' );
770: hr_utility.set_message_token('LOOKUP_TYPE',
771: 'PQP_US_INCOME_CODE_SUB_TYPE' );
772: hr_utility.raise_error;
773: --
774: END IF;
775: --
776: END IF;

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

774: END IF;
775: --
776: END IF;
777: --
778: hr_utility.set_location('Leaving:'||l_proc,10);
779: --
780: END chk_income_code_sub_type;
781: --
782: -- ----------------------------------------------------------------------------

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

814: l_api_updating BOOLEAN;
815: --
816: BEGIN
817: --
818: hr_utility.set_location('Entering:'||l_proc, 5);
819: --
820: l_api_updating := pqp_det_shd.api_updating
821: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
822: p_object_version_number => p_object_version_number);

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

835: p_effective_date => p_effective_date ) THEN
836: --
837: -- raise error as does not exist as lookup
838: --
839: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
840: hr_utility.set_message_token('COLUMN', 'exemption_code' );
841: hr_utility.set_message_token('LOOKUP_TYPE',
842: 'PQP_US_EXEMPTION_CODE' );
843: hr_utility.raise_error;

Line 840: hr_utility.set_message_token('COLUMN', 'exemption_code' );

836: --
837: -- raise error as does not exist as lookup
838: --
839: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
840: hr_utility.set_message_token('COLUMN', 'exemption_code' );
841: hr_utility.set_message_token('LOOKUP_TYPE',
842: 'PQP_US_EXEMPTION_CODE' );
843: hr_utility.raise_error;
844: --

Line 841: hr_utility.set_message_token('LOOKUP_TYPE',

837: -- raise error as does not exist as lookup
838: --
839: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
840: hr_utility.set_message_token('COLUMN', 'exemption_code' );
841: hr_utility.set_message_token('LOOKUP_TYPE',
842: 'PQP_US_EXEMPTION_CODE' );
843: hr_utility.raise_error;
844: --
845: END IF;

Line 843: hr_utility.raise_error;

839: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
840: hr_utility.set_message_token('COLUMN', 'exemption_code' );
841: hr_utility.set_message_token('LOOKUP_TYPE',
842: 'PQP_US_EXEMPTION_CODE' );
843: hr_utility.raise_error;
844: --
845: END IF;
846: --
847: END IF;

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

845: END IF;
846: --
847: END IF;
848: --
849: hr_utility.set_location('Leaving:'||l_proc,10);
850: --
851: END chk_exemption_code;
852: --
853: -- ----------------------------------------------------------------------------

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

885: l_api_updating BOOLEAN;
886: --
887: BEGIN
888: --
889: hr_utility.set_location('Entering:'||l_proc, 5);
890: --
891: l_api_updating := pqp_det_shd.api_updating
892: (p_analyzed_data_details_id=>p_analyzed_data_details_id,
893: p_object_version_number => p_object_version_number);

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

906: p_effective_date => p_effective_date ) THEN
907: --
908: -- raise error as does not exist as lookup
909: --
910: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
911: hr_utility.set_message_token('COLUMN',
912: 'addl_wthldng_amt_period_type' );
913: hr_utility.set_message_token('LOOKUP_TYPE',
914: 'PROC_PERIOD_TYPE' );

Line 911: hr_utility.set_message_token('COLUMN',

907: --
908: -- raise error as does not exist as lookup
909: --
910: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
911: hr_utility.set_message_token('COLUMN',
912: 'addl_wthldng_amt_period_type' );
913: hr_utility.set_message_token('LOOKUP_TYPE',
914: 'PROC_PERIOD_TYPE' );
915: hr_utility.raise_error;

Line 913: hr_utility.set_message_token('LOOKUP_TYPE',

909: --
910: hr_utility.set_message(801, 'HR_52966_INVALID_LOOKUP' );
911: hr_utility.set_message_token('COLUMN',
912: 'addl_wthldng_amt_period_type' );
913: hr_utility.set_message_token('LOOKUP_TYPE',
914: 'PROC_PERIOD_TYPE' );
915: hr_utility.raise_error;
916: --
917: END IF;

Line 915: hr_utility.raise_error;

911: hr_utility.set_message_token('COLUMN',
912: 'addl_wthldng_amt_period_type' );
913: hr_utility.set_message_token('LOOKUP_TYPE',
914: 'PROC_PERIOD_TYPE' );
915: hr_utility.raise_error;
916: --
917: END IF;
918: --
919: END IF;

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

917: END IF;
918: --
919: END IF;
920: --
921: hr_utility.set_location('Leaving:'||l_proc,10);
922: --
923: END chk_addl_wthldng_amt_period;
924:
925: -- ----------------------------------------------------------------------------

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

930: --
931: l_proc varchar2(72) := g_package||'insert_validate';
932: --
933: Begin
934: hr_utility.set_location('Entering:'||l_proc, 5);
935: --
936: -- Call all supporting business operations
937: --
938: chk_analyzed_data_details_id

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

1011: p_object_version_number => p_rec.object_version_number );
1012: --
1013: --
1014: --
1015: hr_utility.set_location(' Leaving:'||l_proc, 10);
1016: End insert_validate;
1017: --
1018: -- ----------------------------------------------------------------------------
1019: -- |---------------------------< update_validate >----------------------------|

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

1023: --
1024: l_proc varchar2(72) := g_package||'update_validate';
1025: --
1026: Begin
1027: hr_utility.set_location('Entering:'||l_proc, 5);
1028: --
1029: -- Call all supporting business operations
1030: --
1031: chk_analyzed_data_details_id

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

1104: p_object_version_number => p_rec.object_version_number );
1105: --
1106: --
1107: --
1108: hr_utility.set_location(' Leaving:'||l_proc, 10);
1109: End update_validate;
1110: --
1111: -- ----------------------------------------------------------------------------
1112: -- |---------------------------< delete_validate >----------------------------|

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

1116: --
1117: l_proc varchar2(72) := g_package||'delete_validate';
1118: --
1119: Begin
1120: hr_utility.set_location('Entering:'||l_proc, 5);
1121: --
1122: -- Call all supporting business operations
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1120: hr_utility.set_location('Entering:'||l_proc, 5);
1121: --
1122: -- Call all supporting business operations
1123: --
1124: hr_utility.set_location(' Leaving:'||l_proc, 10);
1125: End delete_validate;
1126: --
1127: end pqp_det_bus;