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.

[Home] [Help]

APPS.PER_SUC_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 := per_suc_shd.api_updating
47: (p_succession_plan_id => p_succession_plan_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_succession_plan_id;
75: -- ----------------------------------------------------------------------------
76: -- |----------------------------< chk_person_id >-----------------------------|

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

120: AND ppt.system_person_type = 'EMP';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: l_api_updating := per_suc_shd.api_updating
127: (p_succession_plan_id => p_succession_plan_id,
128: p_object_version_number => p_object_version_number);

Line 141: hr_utility.set_message(801,'HR_52784_SUC_CHK_PERSON_ID');

137: if p_person_id is null then
138: --
139: -- raise error as this a mandatory requirement
140: --
141: hr_utility.set_message(801,'HR_52784_SUC_CHK_PERSON_ID');
142: hr_utility.raise_error;
143: --
144: end if;
145: --

Line 142: hr_utility.raise_error;

138: --
139: -- raise error as this a mandatory requirement
140: --
141: hr_utility.set_message(801,'HR_52784_SUC_CHK_PERSON_ID');
142: hr_utility.raise_error;
143: --
144: end if;
145: --
146: /*if l_api_updating then

Line 150: hr_utility.set_message(801,'HR_52785_SUC_CHK_PERSON_UPDATE');

146: /*if l_api_updating then
147: --
148: -- raise error as the person can not be updated.
149: --
150: hr_utility.set_message(801,'HR_52785_SUC_CHK_PERSON_UPDATE');
151: hr_utility.raise_error;
152: --
153: end if;*/
154: --

Line 151: hr_utility.raise_error;

147: --
148: -- raise error as the person can not be updated.
149: --
150: hr_utility.set_message(801,'HR_52785_SUC_CHK_PERSON_UPDATE');
151: hr_utility.raise_error;
152: --
153: end if;*/
154: --
155: -- check if the person_id exists as of effective date.

Line 167: hr_utility.set_message(801,'HR_52786_SUC_CHK_PERSON_EXISTS');

163: close c1;
164: --
165: -- raise error as person does not exist.
166: --
167: hr_utility.set_message(801,'HR_52786_SUC_CHK_PERSON_EXISTS');
168: hr_utility.raise_error;
169: --
170: end if;
171: --

Line 168: hr_utility.raise_error;

164: --
165: -- raise error as person does not exist.
166: --
167: hr_utility.set_message(801,'HR_52786_SUC_CHK_PERSON_EXISTS');
168: hr_utility.raise_error;
169: --
170: end if;
171: --
172: close c1;

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

172: close c1;
173: --
174: end if;
175: --
176: hr_utility.set_location(' Leaving:'||l_proc, 10);
177: --
178: End chk_person_id;
179: --
180: -- ----------------------------------------------------------------------------

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

225: and nvl(hr_general.get_position_date_end(per.position_id),hr_api.g_eot);
226: --
227: Begin
228: --
229: hr_utility.set_location('Entering:'||l_proc, 5);
230: --
231: l_api_updating := per_suc_shd.api_updating
232: (p_succession_plan_id => p_succession_plan_id,
233: p_object_version_number => p_object_version_number);

Line 246: hr_utility.set_message(801,'HR_51998_SUC_CHK_POSITION_ID');

242: /* if p_position_id is null then
243: --
244: -- raise error as this a mandatory requirement
245: --
246: hr_utility.set_message(801,'HR_51998_SUC_CHK_POSITION_ID');
247: hr_utility.raise_error;
248: --
249: end if;*/
250: --

Line 247: hr_utility.raise_error;

243: --
244: -- raise error as this a mandatory requirement
245: --
246: hr_utility.set_message(801,'HR_51998_SUC_CHK_POSITION_ID');
247: hr_utility.raise_error;
248: --
249: end if;*/
250: --
251: if l_api_updating then

Line 255: hr_utility.set_message(801,'HR_51999_SUC_CHK_POS_UPDATE');

251: if l_api_updating then
252: --
253: -- raise error as the position_id can not be updated.
254: --
255: hr_utility.set_message(801,'HR_51999_SUC_CHK_POS_UPDATE');
256: hr_utility.raise_error;
257: --
258: end if;
259: --

Line 256: hr_utility.raise_error;

252: --
253: -- raise error as the position_id can not be updated.
254: --
255: hr_utility.set_message(801,'HR_51999_SUC_CHK_POS_UPDATE');
256: hr_utility.raise_error;
257: --
258: end if;
259: --
260: -- check if the position_id exists as of effective_date.

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

276: close c1;
277: --
278: end if;
279: --
280: hr_utility.set_location(' Leaving:'||l_proc, 10);
281: --
282: End chk_position_id;
283: --
284: -- ----------------------------------------------------------------------------

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

326:
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := per_suc_shd.api_updating
333: (p_succession_plan_id => p_succession_plan_id,
334: p_object_version_number => p_object_version_number);

Line 347: hr_utility.set_message(801,'HR_XXXXX_SUC_CHK_JOB_ID');

343: /* if p_job_id is null then
344: --
345: -- raise error as this a mandatory requirement
346: --
347: hr_utility.set_message(801,'HR_XXXXX_SUC_CHK_JOB_ID');
348: hr_utility.raise_error;
349: --
350: end if;*/
351: --

Line 348: hr_utility.raise_error;

344: --
345: -- raise error as this a mandatory requirement
346: --
347: hr_utility.set_message(801,'HR_XXXXX_SUC_CHK_JOB_ID');
348: hr_utility.raise_error;
349: --
350: end if;*/
351: --
352: if l_api_updating then

Line 356: hr_utility.set_message(801,'HR_50493_SUC_CHK_JOB_UPDATE');

352: if l_api_updating then
353: --
354: -- raise error as the job_id can not be updated.
355: --
356: hr_utility.set_message(801,'HR_50493_SUC_CHK_JOB_UPDATE');
357: hr_utility.raise_error;
358: --
359: end if;
360: --

Line 357: hr_utility.raise_error;

353: --
354: -- raise error as the job_id can not be updated.
355: --
356: hr_utility.set_message(801,'HR_50493_SUC_CHK_JOB_UPDATE');
357: hr_utility.raise_error;
358: --
359: end if;
360: --
361: -- check if the job_id exists as of effective_date.

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

377: close c1;
378: --
379: end if;
380: --
381: hr_utility.set_location(' Leaving:'||l_proc, 10);
382: --
383: End chk_job_id;
384: --
385: -- ----------------------------------------------------------------------------

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

426:
427: --
428: Begin
429: --
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: l_api_updating := per_suc_shd.api_updating
433: (p_succession_plan_id => p_succession_plan_id,
434: p_object_version_number => p_object_version_number);

Line 443: hr_utility.set_message(801,'HR_50494_SUC_CHK_SUCC_UPDATE');

439: then
440: --
441: -- raise error as the person can not be updated.
442: --
443: hr_utility.set_message(801,'HR_50494_SUC_CHK_SUCC_UPDATE');
444: hr_utility.raise_error;
445: --
446: end if;
447: --

Line 444: hr_utility.raise_error;

440: --
441: -- raise error as the person can not be updated.
442: --
443: hr_utility.set_message(801,'HR_50494_SUC_CHK_SUCC_UPDATE');
444: hr_utility.raise_error;
445: --
446: end if;
447: --
448: if(p_job_id is not null)

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

493: end if;
494:
495:
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 10);
498: --
499: End chk_successee;
500: --
501: -- ----------------------------------------------------------------------------

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

537:
538: --
539: Begin
540: --
541: hr_utility.set_location('Entering:'||l_proc, 5);
542: --
543: l_api_updating := per_suc_shd.api_updating
544: (p_succession_plan_id => p_succession_plan_id,
545: p_object_version_number => p_object_version_number);

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

554: if l_api_updating then
555: --
556: -- raise error as the person_id can not be updated.
557: --
558: hr_utility.set_message(801,'HR_50497_SUC_CHK_SUC_UPDATE');
559: hr_utility.raise_error;
560: --
561: end if;
562: -- CHK_SUCCESSOR_ID

Line 559: hr_utility.raise_error;

555: --
556: -- raise error as the person_id can not be updated.
557: --
558: hr_utility.set_message(801,'HR_50497_SUC_CHK_SUC_UPDATE');
559: hr_utility.raise_error;
560: --
561: end if;
562: -- CHK_SUCCESSOR_ID
563: --

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

583: end if;
584: --
585: end if;
586: --
587: hr_utility.set_location(' Leaving:'||l_proc, 10);
588: --
589: End chk_successor;
590: -- ----------------------------------------------------------------------------
591: -- |-----------------------------< chk_time_scale >---------------------------|

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

623: l_api_updating boolean;
624: --
625: Begin
626: --
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: l_api_updating := per_suc_shd.api_updating
630: (p_succession_plan_id => p_succession_plan_id,
631: p_object_version_number => p_object_version_number);

Line 646: hr_utility.set_message(801,'HR_52001_SUC_CHK_TIME_SCALE');

642: p_effective_date => p_effective_date) then
643: --
644: -- raise error as does not exist as lookup
645: --
646: hr_utility.set_message(801,'HR_52001_SUC_CHK_TIME_SCALE');
647: hr_utility.raise_error;
648: --
649: end if;
650: --

Line 647: hr_utility.raise_error;

643: --
644: -- raise error as does not exist as lookup
645: --
646: hr_utility.set_message(801,'HR_52001_SUC_CHK_TIME_SCALE');
647: hr_utility.raise_error;
648: --
649: end if;
650: --
651: end if;

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

649: end if;
650: --
651: end if;
652: --
653: hr_utility.set_location('Leaving:'||l_proc,10);
654: --
655: end chk_time_scale;
656: -- ----------------------------------------------------------------------------
657: -- |----------------------------< chk_start_date >----------------------------|

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

684: l_api_updating boolean;
685: --
686: Begin
687: --
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: l_api_updating := per_suc_shd.api_updating
691: (p_succession_plan_id => p_succession_plan_id,
692: p_object_version_number => p_object_version_number);

Line 705: hr_utility.set_message(801,'HR_52002_SUC_CHK_START_DATE');

701: if p_start_date is null then
702: --
703: -- raise error as this a mandatory requirement
704: --
705: hr_utility.set_message(801,'HR_52002_SUC_CHK_START_DATE');
706: hr_utility.raise_error;
707: --
708: end if;
709: --

Line 706: hr_utility.raise_error;

702: --
703: -- raise error as this a mandatory requirement
704: --
705: hr_utility.set_message(801,'HR_52002_SUC_CHK_START_DATE');
706: hr_utility.raise_error;
707: --
708: end if;
709: --
710: end if;

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

708: end if;
709: --
710: end if;
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: --
714: End chk_start_date;
715: -- ----------------------------------------------------------------------------
716: -- |----------------------------< chk_end_date >------------------------------|

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

746: l_api_updating boolean;
747: --
748: Begin
749: --
750: hr_utility.set_location('Entering:'||l_proc, 5);
751: --
752: l_api_updating := per_suc_shd.api_updating
753: (p_succession_plan_id => p_succession_plan_id,
754: p_object_version_number => p_object_version_number);

Line 769: hr_utility.set_message(801,'HR_52003_SUC_CHK_END_DATE');

765: if p_start_date > nvl(p_end_date,hr_api.g_eot) then
766: --
767: -- raise error as start date should be less than or equal to end date.
768: --
769: hr_utility.set_message(801,'HR_52003_SUC_CHK_END_DATE');
770: hr_utility.raise_error;
771: --
772: end if;
773: --

Line 770: hr_utility.raise_error;

766: --
767: -- raise error as start date should be less than or equal to end date.
768: --
769: hr_utility.set_message(801,'HR_52003_SUC_CHK_END_DATE');
770: hr_utility.raise_error;
771: --
772: end if;
773: --
774: end if;

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

772: end if;
773: --
774: end if;
775: --
776: hr_utility.set_location(' Leaving:'||l_proc, 10);
777: --
778: End chk_end_date;
779: -- ----------------------------------------------------------------------------
780: -- |----------------------< chk_available_for_promotion >---------------------|

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

812: l_api_updating boolean;
813: --
814: Begin
815: --
816: hr_utility.set_location('Entering:'||l_proc, 5);
817: --
818: l_api_updating := per_suc_shd.api_updating
819: (p_succession_plan_id => p_succession_plan_id,
820: p_object_version_number => p_object_version_number);

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

843: end if;
844: --
845: end if;
846: --
847: hr_utility.set_location('Leaving:'||l_proc,10);
848: --
849: end chk_available_for_promotion;
850:
851:

Line 902: hr_utility.set_message(801,'HR_52005_SUC_CHK_DATE');

898: FETCH person_start_details INTO l_curr_position_id;
899:
900: IF (person_start_details%NOTFOUND) THEN
901: CLOSE person_start_details;
902: hr_utility.set_message(801,'HR_52005_SUC_CHK_DATE');
903: hr_utility.raise_error;
904: ELSE
905: CLOSE person_start_details;
906: END IF;

Line 903: hr_utility.raise_error;

899:
900: IF (person_start_details%NOTFOUND) THEN
901: CLOSE person_start_details;
902: hr_utility.set_message(801,'HR_52005_SUC_CHK_DATE');
903: hr_utility.raise_error;
904: ELSE
905: CLOSE person_start_details;
906: END IF;
907: END;

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

967: and nvl(p_end_date,hr_api.g_eot));
968: --
969: Begin
970: --
971: hr_utility.set_location('Entering:'||l_proc, 5);
972: --
973: l_api_updating := per_suc_shd.api_updating
974: (p_succession_plan_id => p_succession_plan_id,
975: p_object_version_number => p_object_version_number);

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

1000: close c1;
1001: --
1002: end if;
1003: --
1004: hr_utility.set_location(' Leaving:'||l_proc, 10);
1005: --
1006: End chk_date;
1007: --
1008: -- -----------------------------------------------------------------------

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

1040: --
1041: l_proc varchar2(72) := g_package||'chk_df';
1042: --
1043: begin
1044: hr_utility.set_location('Entering:'||l_proc, 10);
1045: --
1046: if ((p_rec.succession_plan_id is not null) and (
1047: nvl(per_suc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
1048: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 1143: hr_utility.set_location(' Leaving:'||l_proc, 20);

1139: ,p_attribute20_name => 'ATTRIBUTE20'
1140: ,p_attribute20_value => p_rec.attribute20);
1141: end if;
1142: --
1143: hr_utility.set_location(' Leaving:'||l_proc, 20);
1144: end chk_df;
1145: --
1146: -- ----------------------------------------------------------------------------
1147: -- |---------------------------< insert_validate >----------------------------|

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

1151: --
1152: l_proc varchar2(72) := g_package||'insert_validate';
1153: --
1154: Begin
1155: hr_utility.set_location('Entering:'||l_proc, 5);
1156: --
1157: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1158: --
1159: -- Call all supporting business operations

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

1256: -- call descriptive flexfield validation routines
1257: --
1258: per_suc_bus.chk_df(p_rec => p_rec);
1259: --
1260: hr_utility.set_location(' Leaving:'||l_proc, 10);
1261: End insert_validate;
1262: --
1263: -- ----------------------------------------------------------------------------
1264: -- |---------------------------< update_validate >----------------------------|

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

1268: --
1269: l_proc varchar2(72) := g_package||'update_validate';
1270: --
1271: Begin
1272: hr_utility.set_location('Entering:'||l_proc, 5);
1273: --
1274: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1275: --
1276: -- Call all supporting business operations

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

1375: -- call descriptive flexfield validation routines
1376: --
1377: per_suc_bus.chk_df(p_rec => p_rec);
1378: --
1379: hr_utility.set_location(' Leaving:'||l_proc, 10);
1380: End update_validate;
1381: --
1382: -- ----------------------------------------------------------------------------
1383: -- |---------------------------< delete_validate >----------------------------|

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

1386: --
1387: l_proc varchar2(72) := g_package||'delete_validate';
1388: --
1389: Begin
1390: hr_utility.set_location('Entering:'||l_proc, 5);
1391: --
1392: -- Call all supporting business operations
1393: --
1394: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1390: hr_utility.set_location('Entering:'||l_proc, 5);
1391: --
1392: -- Call all supporting business operations
1393: --
1394: hr_utility.set_location(' Leaving:'||l_proc, 10);
1395: End delete_validate;
1396: --
1397: end per_suc_bus;