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_ATD_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_atd_shd.api_updating
47: (p_alien_transaction_id => p_alien_transaction_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_alien_transaction_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_atd_shd.api_updating
115: (p_alien_transaction_id => p_alien_transaction_id,
116: p_object_version_number => p_object_version_number);

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

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_LOOKUP_DOES_NOT_EXIST');
134: hr_utility.raise_error; */
135:
136: -- Append the error message to the g_error_message
137:

Line 134: hr_utility.raise_error; */

130: /* --
131: -- raise error as does not exist as lookup
132: --
133: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
134: hr_utility.raise_error; */
135:
136: -- Append the error message to the g_error_message
137:
138: g_error_message := g_error_message || '(' ||

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

143: END IF;
144: --
145: END IF;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: END chk_treaty_ben_allowed_flag;
150: --
151: -- ----------------------------------------------------------------------------

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

184: l_api_updating BOOLEAN;
185: --
186: BEGIN
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := pqp_atd_shd.api_updating
191: (p_alien_transaction_id => p_alien_transaction_id ,
192: p_object_version_number => p_object_version_number);

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

205: p_effective_date => p_effective_date) then
206: /* --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error; */
211:
212: -- Append the error message to the g_error_message
213:

Line 210: hr_utility.raise_error; */

206: /* --
207: -- raise error as does not exist as lookup
208: --
209: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
210: hr_utility.raise_error; */
211:
212: -- Append the error message to the g_error_message
213:
214: g_error_message := g_error_message || '(' ||

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

218: END IF;
219: --
220: END IF;
221: --
222: hr_utility.set_location('Leaving:'||l_proc,10);
223: --
224: END chk_wthldg_allow_eligible_flag;
225: --
226: -- ----------------------------------------------------------------------------

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

258: l_api_updating boolean;
259: --
260: Begin
261: --
262: hr_utility.set_location('Entering:'||l_proc, 5);
263: --
264: l_api_updating := pqp_atd_shd.api_updating
265: (p_alien_transaction_id => p_alien_transaction_id,
266: p_object_version_number => p_object_version_number);

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

279: p_effective_date => p_effective_date) then
280: /* --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: -- */
286:
287: -- Append the error message to the g_error_message

Line 284: hr_utility.raise_error;

280: /* --
281: -- raise error as does not exist as lookup
282: --
283: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
284: hr_utility.raise_error;
285: -- */
286:
287: -- Append the error message to the g_error_message
288:

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

292: end if;
293: --
294: end if;
295: --
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: --
298: end chk_addl_withholding_flag;
299: --
300: -- ----------------------------------------------------------------------------

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

332: l_api_updating boolean;
333: --
334: Begin
335: --
336: hr_utility.set_location('Entering:'||l_proc, 5);
337: --
338: l_api_updating := pqp_atd_shd.api_updating
339: (p_alien_transaction_id => p_alien_transaction_id,
340: p_object_version_number => p_object_version_number);

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

353: p_effective_date => p_effective_date) then
354: /* --
355: -- raise error as does not exist as lookup
356: --
357: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
358: hr_utility.raise_error;
359: -- */
360:
361: -- Append the error message to the g_error_message

Line 358: hr_utility.raise_error;

354: /* --
355: -- raise error as does not exist as lookup
356: --
357: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
358: hr_utility.raise_error;
359: -- */
360:
361: -- Append the error message to the g_error_message
362:

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

366: end if;
367: --
368: end if;
369: --
370: hr_utility.set_location('Leaving:'||l_proc,10);
371: --
372: end chk_retro_lose_ben_date_flag;
373: --
374: -- ----------------------------------------------------------------------------

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

406: l_api_updating boolean;
407: --
408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := pqp_atd_shd.api_updating
413: (p_alien_transaction_id => p_alien_transaction_id,
414: p_object_version_number => p_object_version_number);

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

427: p_effective_date => p_effective_date) then
428: /* --
429: -- raise error as does not exist as lookup
430: --
431: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
432: hr_utility.raise_error;
433: -- */
434:
435: -- Append the error message to the g_error_message

Line 432: hr_utility.raise_error;

428: /* --
429: -- raise error as does not exist as lookup
430: --
431: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
432: hr_utility.raise_error;
433: -- */
434:
435: -- Append the error message to the g_error_message
436:

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

440: end if;
441: --
442: end if;
443: --
444: hr_utility.set_location('Leaving:'||l_proc,10);
445: --
446: end chk_retro_lose_ben_amt_flag;
447: --
448: -- ----------------------------------------------------------------------------

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

480: l_api_updating boolean;
481: --
482: Begin
483: --
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: l_api_updating := pqp_atd_shd.api_updating
487: (p_alien_transaction_id => p_alien_transaction_id,
488: p_object_version_number => p_object_version_number);

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

501: p_effective_date => p_effective_date) then
502: /* --
503: -- raise error as does not exist as lookup
504: --
505: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
506: hr_utility.raise_error;
507: -- */
508: -- Append the error message to the g_error_message
509:

Line 506: hr_utility.raise_error;

502: /* --
503: -- raise error as does not exist as lookup
504: --
505: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
506: hr_utility.raise_error;
507: -- */
508: -- Append the error message to the g_error_message
509:
510: g_error_message := g_error_message || '(' ||

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

513: end if;
514: --
515: end if;
516: --
517: hr_utility.set_location('Leaving:'||l_proc,10);
518: --
519: end chk_state_honors_treaty_flag;
520: --
521: -- ----------------------------------------------------------------------------

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

553: l_api_updating BOOLEAN;
554: --
555: BEGIN
556: --
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: l_api_updating := pqp_atd_shd.api_updating
560: (p_alien_transaction_id => p_alien_transaction_id,
561: p_object_version_number => p_object_version_number);

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

574: p_effective_date => p_effective_date ) THEN
575: /* --
576: -- raise error as does not exist as lookup
577: --
578: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
579: hr_utility.raise_error;
580: -- */
581: -- Append the error message to the g_error_message
582:

Line 579: hr_utility.raise_error;

575: /* --
576: -- raise error as does not exist as lookup
577: --
578: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
579: hr_utility.raise_error;
580: -- */
581: -- Append the error message to the g_error_message
582:
583: g_error_message := g_error_message || '(' ||

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

586: END IF;
587: --
588: END IF;
589: --
590: hr_utility.set_location('Leaving:'||l_proc,10);
591: --
592: END chk_student_exempt_from_fica;
593: --
594: -- |------< chk_nra_exempt_from_fica >------|

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

625: l_api_updating BOOLEAN;
626: --
627: BEGIN
628: --
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: l_api_updating := pqp_atd_shd.api_updating
632: (p_alien_transaction_id => p_alien_transaction_id,
633: p_object_version_number => p_object_version_number);

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

646: p_effective_date => p_effective_date ) THEN
647: /* --
648: -- raise error as does not exist as lookup
649: --
650: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
651: hr_utility.raise_error;
652: -- */
653:
654: -- Append the error message to the g_error_message

Line 651: hr_utility.raise_error;

647: /* --
648: -- raise error as does not exist as lookup
649: --
650: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
651: hr_utility.raise_error;
652: -- */
653:
654: -- Append the error message to the g_error_message
655:

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

659: END IF;
660: --
661: END IF;
662: --
663: hr_utility.set_location('Leaving:'||l_proc,10);
664: --
665: END chk_nra_exempt_from_fica;
666: -- ----------------------------------------------------------------------------
667: -- |------< chk_income_code >------|

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

698: l_api_updating BOOLEAN;
699: --
700: BEGIN
701: --
702: hr_utility.set_location('Entering:'||l_proc, 5);
703: --
704: l_api_updating := pqp_atd_shd.api_updating
705: (p_alien_transaction_id => p_alien_transaction_id ,
706: p_object_version_number => p_object_version_number);

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

719: p_effective_date => p_effective_date ) THEN
720: /* --
721: -- raise error as does not exist as lookup
722: --
723: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
724: hr_utility.raise_error;
725: -- */
726: -- Append the error message to the g_error_message
727:

Line 724: hr_utility.raise_error;

720: /* --
721: -- raise error as does not exist as lookup
722: --
723: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
724: hr_utility.raise_error;
725: -- */
726: -- Append the error message to the g_error_message
727:
728: g_error_message := g_error_message || '(' ||

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

731: END IF;
732: --
733: END IF;
734: --
735: hr_utility.set_location('Leaving:'||l_proc,10);
736: --
737: END chk_income_code;
738: --
739: -- ----------------------------------------------------------------------------

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

771: l_api_updating BOOLEAN;
772: --
773: BEGIN
774: --
775: hr_utility.set_location('Entering:'||l_proc, 5);
776: --
777: l_api_updating := pqp_atd_shd.api_updating
778: (p_alien_transaction_id => p_alien_transaction_id ,
779: p_object_version_number => p_object_version_number);

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

792: p_effective_date => p_effective_date ) THEN
793: /* --
794: -- raise error as does not exist as lookup
795: --
796: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
797: hr_utility.raise_error;
798: -- */
799:
800: -- Append the error message to the g_error_message

Line 797: hr_utility.raise_error;

793: /* --
794: -- raise error as does not exist as lookup
795: --
796: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
797: hr_utility.raise_error;
798: -- */
799:
800: -- Append the error message to the g_error_message
801:

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

805: END IF;
806: --
807: END IF;
808: --
809: hr_utility.set_location('Leaving:'||l_proc,10);
810: --
811: END chk_income_code_sub_type;
812: --
813: -- ----------------------------------------------------------------------------

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

845: l_api_updating BOOLEAN;
846: --
847: BEGIN
848: --
849: hr_utility.set_location('Entering:'||l_proc, 5);
850: --
851: l_api_updating := pqp_atd_shd.api_updating
852: (p_alien_transaction_id => p_alien_transaction_id ,
853: p_object_version_number => p_object_version_number);

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

866: p_effective_date => p_effective_date ) THEN
867: /* --
868: -- raise error as does not exist as lookup
869: --
870: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
871: --app_exception.raise_exception;
872: hr_utility.raise_error;
873: -- */
874:

Line 872: hr_utility.raise_error;

868: -- raise error as does not exist as lookup
869: --
870: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
871: --app_exception.raise_exception;
872: hr_utility.raise_error;
873: -- */
874:
875: -- Append the error message to the g_error_message
876:

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

880: END IF;
881: --
882: END IF;
883: --
884: hr_utility.set_location('Leaving:'||l_proc,10);
885: --
886: END chk_exemption_code;
887: --
888: -- ----------------------------------------------------------------------------

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

920: l_api_updating BOOLEAN;
921: --
922: BEGIN
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := pqp_atd_shd.api_updating
927: (p_alien_transaction_id => p_alien_transaction_id ,
928: p_object_version_number => p_object_version_number);

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

941: p_effective_date => p_effective_date ) THEN
942: /* --
943: -- raise error as does not exist as lookup
944: --
945: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
946: hr_utility.raise_error;
947: -- */
948:
949: -- Append the error message to the g_error_message

Line 946: hr_utility.raise_error;

942: /* --
943: -- raise error as does not exist as lookup
944: --
945: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
946: hr_utility.raise_error;
947: -- */
948:
949: -- Append the error message to the g_error_message
950:

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

954: END IF;
955: --
956: END IF;
957: --
958: hr_utility.set_location('Leaving:'||l_proc,10);
959: --
960: END chk_current_residency_status;
961: --
962: -- ----------------------------------------------------------------------------

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

994: l_api_updating BOOLEAN;
995: --
996: BEGIN
997: --
998: hr_utility.set_location('Entering:'||l_proc, 5);
999: --
1000: l_api_updating := pqp_atd_shd.api_updating
1001: (p_alien_transaction_id => p_alien_transaction_id ,
1002: p_object_version_number => p_object_version_number);

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

1015: p_effective_date => p_effective_date ) THEN
1016: /* --
1017: -- raise error as does not exist as lookup
1018: --
1019: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1020: hr_utility.raise_error;
1021: -- */
1022:
1023: -- Append the error message to the g_error_message

Line 1020: hr_utility.raise_error;

1016: /* --
1017: -- raise error as does not exist as lookup
1018: --
1019: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1020: hr_utility.raise_error;
1021: -- */
1022:
1023: -- Append the error message to the g_error_message
1024:

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

1028: END IF;
1029: --
1030: END IF;
1031: --
1032: hr_utility.set_location('Leaving:'||l_proc,10);
1033: --
1034: END chk_tax_residence_country_code;
1035: --
1036: -- ----------------------------------------------------------------------------

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

1068: l_api_updating BOOLEAN;
1069: --
1070: BEGIN
1071: --
1072: hr_utility.set_location('Entering:'||l_proc, 5);
1073: --
1074: l_api_updating := pqp_atd_shd.api_updating
1075: (p_alien_transaction_id => p_alien_transaction_id ,
1076: p_object_version_number => p_object_version_number);

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

1089: p_effective_date => p_effective_date ) THEN
1090: /* --
1091: -- raise error as does not exist as lookup
1092: --
1093: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1094: hr_utility.raise_error;
1095: -- */
1096:
1097: -- Append the error message to the g_error_message

Line 1094: hr_utility.raise_error;

1090: /* --
1091: -- raise error as does not exist as lookup
1092: --
1093: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1094: hr_utility.raise_error;
1095: -- */
1096:
1097: -- Append the error message to the g_error_message
1098:

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

1102: END IF;
1103: --
1104: END IF;
1105: --
1106: hr_utility.set_location('Leaving:'||l_proc,10);
1107: --
1108: END chk_addtnl_wthldng_amt_period;
1109: -- ----------------------------------------------------------------------------
1110: -- |------< chk_state_code >------|

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

1141: l_api_updating BOOLEAN;
1142: --
1143: BEGIN
1144: --
1145: hr_utility.set_location('Entering:'||l_proc, 5);
1146: --
1147: l_api_updating := pqp_atd_shd.api_updating
1148: (p_alien_transaction_id => p_alien_transaction_id ,
1149: p_object_version_number => p_object_version_number);

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

1162: p_effective_date => p_effective_date ) THEN
1163: /* --
1164: -- raise error as does not exist as lookup
1165: --
1166: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1167: hr_utility.raise_error;
1168: -- */
1169: -- Append the error message to the g_error_message
1170:

Line 1167: hr_utility.raise_error;

1163: /* --
1164: -- raise error as does not exist as lookup
1165: --
1166: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1167: hr_utility.raise_error;
1168: -- */
1169: -- Append the error message to the g_error_message
1170:
1171: g_error_message := g_error_message || '(' ||

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

1174: END IF;
1175: --
1176: END IF;
1177: --
1178: hr_utility.set_location('Leaving:'||l_proc,10);
1179: --
1180: END chk_state_code;
1181: --
1182: -- ----------------------------------------------------------------------------

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

1214: l_api_updating BOOLEAN;
1215: --
1216: BEGIN
1217: --
1218: hr_utility.set_location('Entering:'||l_proc, 5);
1219: --
1220: l_api_updating := pqp_atd_shd.api_updating
1221: (p_alien_transaction_id => p_alien_transaction_id ,
1222: p_object_version_number => p_object_version_number);

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

1235: p_effective_date => p_effective_date ) THEN
1236: /* --
1237: -- raise error as does not exist as lookup
1238: --
1239: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1240: hr_utility.raise_error;
1241: -- */
1242:
1243: -- Append the error message to the g_error_message

Line 1240: hr_utility.raise_error;

1236: /* --
1237: -- raise error as does not exist as lookup
1238: --
1239: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1240: hr_utility.raise_error;
1241: -- */
1242:
1243: -- Append the error message to the g_error_message
1244:

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

1248: END IF;
1249: --
1250: END IF;
1251: --
1252: hr_utility.set_location('Leaving:'||l_proc,10);
1253: --
1254: END chk_record_source;
1255: --
1256: -- ----------------------------------------------------------------------------

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

1288: l_api_updating BOOLEAN;
1289: --
1290: BEGIN
1291: --
1292: hr_utility.set_location('Entering:'||l_proc, 5);
1293: --
1294: l_api_updating := pqp_atd_shd.api_updating
1295: (p_alien_transaction_id => p_alien_transaction_id ,
1296: p_object_version_number => p_object_version_number);

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

1309: p_effective_date => p_effective_date ) THEN
1310: /* --
1311: -- raise error as does not exist as lookup
1312: --
1313: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1314: hr_utility.raise_error;
1315: -- */
1316:
1317: -- Append the error message to the g_error_message

Line 1314: hr_utility.raise_error;

1310: /* --
1311: -- raise error as does not exist as lookup
1312: --
1313: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1314: hr_utility.raise_error;
1315: -- */
1316:
1317: -- Append the error message to the g_error_message
1318:

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

1322: END IF;
1323: --
1324: END IF;
1325: --
1326: hr_utility.set_location('Leaving:'||l_proc,10);
1327: --
1328: END chk_visa_type;
1329: --
1330: -- ----------------------------------------------------------------------------

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

1362: l_api_updating BOOLEAN;
1363: --
1364: BEGIN
1365: --
1366: hr_utility.set_location('Entering:'||l_proc, 5);
1367: --
1368: l_api_updating := pqp_atd_shd.api_updating
1369: (p_alien_transaction_id => p_alien_transaction_id ,
1370: p_object_version_number => p_object_version_number);

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

1383: p_effective_date => p_effective_date ) THEN
1384: /* --
1385: -- raise error as does not exist as lookup
1386: --
1387: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1388: hr_utility.raise_error;
1389: -- */
1390: -- Append the error message to the g_error_message
1391:

Line 1388: hr_utility.raise_error;

1384: /* --
1385: -- raise error as does not exist as lookup
1386: --
1387: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1388: hr_utility.raise_error;
1389: -- */
1390: -- Append the error message to the g_error_message
1391:
1392: g_error_message := g_error_message || '(' ||

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

1395: END IF;
1396: --
1397: END IF;
1398: --
1399: hr_utility.set_location('Leaving:'||l_proc,10);
1400: --
1401: END chk_j_sub_type;
1402: --
1403: -- ----------------------------------------------------------------------------

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

1435: l_api_updating BOOLEAN;
1436: --
1437: BEGIN
1438: --
1439: hr_utility.set_location('Entering:'||l_proc, 5);
1440: --
1441: l_api_updating := pqp_atd_shd.api_updating
1442: (p_alien_transaction_id => p_alien_transaction_id ,
1443: p_object_version_number => p_object_version_number);

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

1456: p_effective_date => p_effective_date ) THEN
1457: /* --
1458: -- raise error as does not exist as lookup
1459: --
1460: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1461: hr_utility.raise_error;
1462: -- */
1463: -- Append the error message to the g_error_message
1464:

Line 1461: hr_utility.raise_error;

1457: /* --
1458: -- raise error as does not exist as lookup
1459: --
1460: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1461: hr_utility.raise_error;
1462: -- */
1463: -- Append the error message to the g_error_message
1464:
1465: g_error_message := g_error_message || '(' ||

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

1468: END IF;
1469:
1470: END IF;
1471: --
1472: hr_utility.set_location('Leaving:'||l_proc,10);
1473: --
1474: END chk_primary_activity;
1475: --
1476: -- ----------------------------------------------------------------------------

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

1508: l_api_updating BOOLEAN;
1509: --
1510: BEGIN
1511: --
1512: hr_utility.set_location('Entering:'||l_proc, 5);
1513: --
1514: l_api_updating := pqp_atd_shd.api_updating
1515: (p_alien_transaction_id => p_alien_transaction_id ,
1516: p_object_version_number => p_object_version_number);

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

1529: p_effective_date => p_effective_date ) THEN
1530: /* --
1531: -- raise error as does not exist as lookup
1532: --
1533: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1534: hr_utility.raise_error;
1535: -- */
1536: -- Append the error message to the g_error_message
1537:

Line 1534: hr_utility.raise_error;

1530: /* --
1531: -- raise error as does not exist as lookup
1532: --
1533: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1534: hr_utility.raise_error;
1535: -- */
1536: -- Append the error message to the g_error_message
1537:
1538: g_error_message := g_error_message || '(' ||

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

1541: END IF;
1542: --
1543: END IF;
1544: --
1545: hr_utility.set_location('Leaving:'||l_proc,10);
1546: --
1547: END chk_non_us_country_code;
1548: --
1549: -- ----------------------------------------------------------------------------

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

1581: l_api_updating BOOLEAN;
1582: --
1583: BEGIN
1584: --
1585: hr_utility.set_location('Entering:'||l_proc, 5);
1586: --
1587: l_api_updating := pqp_atd_shd.api_updating
1588: (p_alien_transaction_id => p_alien_transaction_id ,
1589: p_object_version_number => p_object_version_number);

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

1602: p_effective_date => p_effective_date ) THEN
1603: /* --
1604: -- raise error as does not exist as lookup
1605: --
1606: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1607: hr_utility.raise_error;
1608: -- */
1609:
1610: -- Append the error message to the g_error_message

Line 1607: hr_utility.raise_error;

1603: /* --
1604: -- raise error as does not exist as lookup
1605: --
1606: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
1607: hr_utility.raise_error;
1608: -- */
1609:
1610: -- Append the error message to the g_error_message
1611:

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

1615: END IF;
1616: --
1617: END IF;
1618: --
1619: hr_utility.set_location('Leaving:'||l_proc,10);
1620: --
1621: END chk_citizenship_country_code;
1622: --
1623: -- ----------------------------------------------------------------------------

Line 1655: hr_utility.set_location('Entering:'||l_proc,10);

1651: --
1652: l_proc VARCHAR2(72) := g_package||'chk_benefit_amount_percent';
1653: --
1654: BEGIN
1655: hr_utility.set_location('Entering:'||l_proc,10);
1656:
1657: IF (NVL(p_withholding_rate , 0) > 0 AND
1658: NVL(p_maximum_benefit_amount, 0) > 0 AND
1659: NVL(p_maximum_benefit_amount, 0) <> 999999 ) THEN

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

1663: g_error_message := g_error_message || 'Both Max Benefit Amount and ' ||
1664: 'Withholding Rate cannot be more than 0';
1665: END IF;
1666:
1667: hr_utility.set_location('Leaving:'||l_proc,10);
1668: END chk_benefit_amount_percent;
1669: -- ----------------------------------------------------------------------------
1670: -- |---------------------------< insert_validate >----------------------------|
1671: -- ----------------------------------------------------------------------------

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

1674: --
1675: l_proc varchar2(72) := g_package||'insert_validate';
1676: --
1677: Begin
1678: hr_utility.set_location('Entering:'||l_proc, 5);
1679: --
1680: -- Call all supporting business operations
1681: --
1682: chk_alien_transaction_id

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

1818: -- p_object_version_number => p_rec.object_version_number );
1819: --
1820: --
1821: --
1822: hr_utility.set_location(' Leaving:'||l_proc, 10);
1823: End insert_validate;
1824: --
1825: -- ----------------------------------------------------------------------------
1826: -- |---------------------------< update_validate >----------------------------|

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

1830: --
1831: l_proc varchar2(72) := g_package||'update_validate';
1832: --
1833: Begin
1834: hr_utility.set_location('Entering:'||l_proc, 5);
1835: --
1836: -- Call all supporting business operations
1837: --
1838: chk_alien_transaction_id

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

1974: -- p_object_version_number => p_rec.object_version_number );
1975: --
1976: --
1977: --
1978: hr_utility.set_location(' Leaving:'||l_proc, 10);
1979: End update_validate;
1980: --
1981: -- ----------------------------------------------------------------------------
1982: -- |---------------------------< delete_validate >----------------------------|

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

1986: --
1987: l_proc varchar2(72) := g_package||'delete_validate';
1988: --
1989: Begin
1990: hr_utility.set_location('Entering:'||l_proc, 5);
1991: --
1992: -- Call all supporting business operations
1993: --
1994: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1990: hr_utility.set_location('Entering:'||l_proc, 5);
1991: --
1992: -- Call all supporting business operations
1993: --
1994: hr_utility.set_location(' Leaving:'||l_proc, 10);
1995: End delete_validate;
1996: --
1997: end pqp_atd_bus;