eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_JOB_BUS dependencies on HR_UTILITY

Line 74: hr_utility.set_location('Entering:'||l_proc, 1);

70: where job_definition_id = p_job_definition_id
71: and business_group_id + 0 = p_business_group_id;
72: --
73: begin
74: hr_utility.set_location('Entering:'||l_proc, 1);
75: --
76: -- Check mandatory parameters have been set
77: --
78: hr_api.mandatory_arg_error

Line 84: hr_utility.set_location(l_proc, 2);

80: ,p_argument => 'job_definition_id'
81: ,p_argument_value => p_job_definition_id
82: );
83: --
84: hr_utility.set_location(l_proc, 2);
85: --
86: l_api_updating := per_job_shd.api_updating
87: (p_job_id => p_job_id
88: ,p_object_version_number => p_object_version_number);

Line 90: hr_utility.set_location(l_proc, 3);

86: l_api_updating := per_job_shd.api_updating
87: (p_job_id => p_job_id
88: ,p_object_version_number => p_object_version_number);
89: --
90: hr_utility.set_location(l_proc, 3);
91: --
92: if ((l_api_updating and
93: (per_job_shd.g_old_rec.job_definition_id <>
94: p_job_definition_id)) or (NOT l_api_updating)) then

Line 96: hr_utility.set_location(l_proc, 4);

92: if ((l_api_updating and
93: (per_job_shd.g_old_rec.job_definition_id <>
94: p_job_definition_id)) or (NOT l_api_updating)) then
95: --
96: hr_utility.set_location(l_proc, 4);
97: --
98: open csr_job_def;
99: fetch csr_job_def into l_exists;
100: if csr_job_def%notfound then

Line 106: hr_utility.set_location(l_proc, 5);

102: per_job_shd.constraint_error(p_constraint_name => 'PER_JOBS_FK2');
103: end if;
104: close csr_job_def;
105: --
106: hr_utility.set_location(l_proc, 5);
107: --
108: open csr_unique_job_def;
109: fetch csr_unique_job_def into l_exists;
110: if csr_unique_job_def%found then

Line 112: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');

108: open csr_unique_job_def;
109: fetch csr_unique_job_def into l_exists;
110: if csr_unique_job_def%found then
111: close csr_unique_job_def;
112: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
113: hr_utility.raise_error;
114: end if;
115: close csr_unique_job_def;
116: --

Line 113: hr_utility.raise_error;

109: fetch csr_unique_job_def into l_exists;
110: if csr_unique_job_def%found then
111: close csr_unique_job_def;
112: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
113: hr_utility.raise_error;
114: end if;
115: close csr_unique_job_def;
116: --
117: end if;

Line 118: hr_utility.set_location('Leaving '||l_proc, 6);

114: end if;
115: close csr_unique_job_def;
116: --
117: end if;
118: hr_utility.set_location('Leaving '||l_proc, 6);
119: --
120: end chk_job_definition_id;
121: --
122: -- ---------------------------------------------------------------------------

Line 165: hr_utility.set_location('Entering:'||l_proc, 1);

161: l_proc varchar2(72) := g_package||'chk_dates';
162: l_api_updating boolean;
163: --
164: begin
165: hr_utility.set_location('Entering:'||l_proc, 1);
166: --
167: -- Check mandatory parameters have been set
168: --
169:

Line 175: hr_utility.set_location(l_proc, 2);

171: (p_api_name => l_proc
172: ,p_argument => 'date_from'
173: ,p_argument_value => p_date_from
174: );
175: hr_utility.set_location(l_proc, 2);
176: --
177: -- Only proceed with validation if :
178: -- a) The current g_old_rec is current and
179: -- b) The date_end value has changed

Line 193: hr_utility.set_location(l_proc, 3);

189: (NOT l_api_updating))) then
190: --
191: -- Check that date_from <= date_to
192: --
193: hr_utility.set_location(l_proc, 3);
194: --
195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);

Line 196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');

192: --
193: hr_utility.set_location(l_proc, 3);
194: --
195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);
198: hr_utility.set_message_token('STEP', '3');
199: hr_utility.raise_error;
200: end if;

Line 197: hr_utility.set_message_token('PROCEDURE', l_proc);

193: hr_utility.set_location(l_proc, 3);
194: --
195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);
198: hr_utility.set_message_token('STEP', '3');
199: hr_utility.raise_error;
200: end if;
201: --

Line 198: hr_utility.set_message_token('STEP', '3');

194: --
195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);
198: hr_utility.set_message_token('STEP', '3');
199: hr_utility.raise_error;
200: end if;
201: --
202: end if;

Line 199: hr_utility.raise_error;

195: if p_date_from > nvl(p_date_to,hr_api.g_eot) then
196: hr_utility.set_message(801,'HR_6153_ALL_PROCEDURE_FAIL');
197: hr_utility.set_message_token('PROCEDURE', l_proc);
198: hr_utility.set_message_token('STEP', '3');
199: hr_utility.raise_error;
200: end if;
201: --
202: end if;
203: --

Line 204: hr_utility.set_location(' Leaving:'||l_proc, 4);

200: end if;
201: --
202: end if;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 4);
205: end chk_dates;
206: --
207: -- -----------------------------------------------------------------------
208: -- |------------------------------< chk_df >-----------------------------|

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

236: --
237: l_proc varchar2(72) := g_package||'chk_df';
238: --
239: begin
240: hr_utility.set_location('Entering:'||l_proc, 10);
241: --
242: if ((p_rec.job_id is not null) and (
243: nvl(per_job_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
244: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

336: ,p_attribute20_value => p_rec.attribute20
337: );
338: end if;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 20);
341: end chk_df;
342: --
343: -- -----------------------------------------------------------------------
344: -- |------------------------------< chk_ddf >----------------------------|

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

372: --
373: l_proc varchar2(72) := g_package||'chk_ddf';
374: --
375: begin
376: hr_utility.set_location('Entering:'||l_proc, 10);
377: --
378: if ((p_rec.job_id is not null) and (
379: nvl(per_job_shd.g_old_rec.job_information_category, hr_api.g_varchar2) <>
380: nvl(p_rec.job_information_category, hr_api.g_varchar2) or

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

472: ,p_attribute20_value => p_rec.job_information20
473: );
474: end if;
475: --
476: hr_utility.set_location(' Leaving:'||l_proc, 20);
477: end chk_ddf;
478: --
479: -- ---------------------------------------------------------------------------
480: -- |---------------------------< insert_validate >----------------------------|

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

484: l_proc varchar2(72) := g_package||'insert_validate';
485: --
486: Begin
487:
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: -- Call all supporting business operations
491: --
492: -- Validate Business Group

Line 496: hr_utility.set_location(l_proc, 6);

492: -- Validate Business Group
493: --
494: hr_api.validate_bus_grp_id(p_rec.business_group_id);
495: --
496: hr_utility.set_location(l_proc, 6);
497: --
498: -- Validate date from and date_to
499: --
500: chk_dates

Line 505: hr_utility.set_location(l_proc, 7);

501: (p_date_from => p_rec.date_from,
502: p_date_to => p_rec.date_to
503: );
504: --
505: hr_utility.set_location(l_proc, 7);
506: --
507: -- Validate job definition id
508: --
509: chk_job_definition_id

Line 516: hr_utility.set_location(l_proc, 8);

512: );
513: --
514: -- chk_emp_rights_flag
515: --
516: hr_utility.set_location(l_proc, 8);
517: --
518: chk_emp_rights_flag
519: (p_emp_rights_flag => p_rec.emp_rights_flag
520: ,p_rec => p_rec);

Line 524: hr_utility.set_location(l_proc, 9);

520: ,p_rec => p_rec);
521: --
522: -- chk_job_group_id
523: --
524: hr_utility.set_location(l_proc, 9);
525: --
526: chk_job_group_id
527: (p_job_group_id => p_rec.job_group_id
528: ,p_business_group_id => p_rec.business_group_id);

Line 532: hr_utility.set_location(l_proc, 10);

528: ,p_business_group_id => p_rec.business_group_id);
529: --
530: -- chk_approval_authority
531: --
532: hr_utility.set_location(l_proc, 10);
533: --
534: chk_approval_authority
535: (p_approval_authority => p_rec.approval_authority
536: ,p_rec => p_rec);

Line 540: hr_utility.set_location(l_proc, 11);

536: ,p_rec => p_rec);
537: --
538: -- chk_benchmark_job_flag
539: --
540: hr_utility.set_location(l_proc, 11);
541: --
542: chk_benchmark_job_flag
543: (p_benchmark_job_flag => p_rec.benchmark_job_flag
544: ,p_benchmark_job_id => p_rec.benchmark_job_id

Line 549: hr_utility.set_location(l_proc, 12);

545: ,p_rec => p_rec);
546: --
547: -- chk_benchmark_job_id
548: --
549: hr_utility.set_location(l_proc, 12);
550: --
551: chk_benchmark_job_id
552: (p_benchmark_job_id => p_rec.benchmark_job_id
553: ,p_job_id => p_rec.job_id

Line 559: hr_utility.set_location(l_proc, 13);

555: ,p_rec => p_rec);
556: --
557: -- Flexfield Validation
558: --
559: hr_utility.set_location(l_proc, 13);
560: --
561: chk_ddf(p_rec => p_rec);
562: --
563: chk_df(p_rec => p_rec);

Line 565: hr_utility.set_location('Leaving:'||l_proc, 14);

561: chk_ddf(p_rec => p_rec);
562: --
563: chk_df(p_rec => p_rec);
564: --
565: hr_utility.set_location('Leaving:'||l_proc, 14);
566: End insert_validate;
567: --
568: -- ----------------------------------------------------------------------------
569: -- |---------------------------< update_validate >----------------------------|

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

573: l_proc varchar2(72) := g_package||'update_validate';
574: --
575: Begin
576:
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: -- Validate Business Group

Line 585: hr_utility.set_location(l_proc, 10);

581: -- Validate Business Group
582: --
583: hr_api.validate_bus_grp_id(p_rec.business_group_id);
584: --
585: hr_utility.set_location(l_proc, 10);
586: --
587: -- chk_non_updateable_args
588: --
589: chk_non_updateable_args

Line 593: hr_utility.set_location(l_proc, 15);

589: chk_non_updateable_args
590: (p_date_from => p_rec.date_from
591: ,p_rec => p_rec);
592: --
593: hr_utility.set_location(l_proc, 15);
594: --
595: -- Validate date effective
596: --
597: chk_dates

Line 604: hr_utility.set_location(l_proc, 20);

600: p_date_to => p_rec.date_to,
601: p_object_version_number => p_rec.object_version_number
602: );
603: --
604: hr_utility.set_location(l_proc, 20);
605: --
606: -- Validate job definition id
607: --
608: chk_job_definition_id

Line 617: hr_utility.set_location(l_proc, 30);

613: );
614: --
615: -- check that the emp_rights_flag is set to Y or N
616: --
617: hr_utility.set_location(l_proc, 30);
618: --
619: chk_emp_rights_flag
620: (p_emp_rights_flag => p_rec.emp_rights_flag
621: ,p_rec => p_rec);

Line 625: hr_utility.set_location(l_proc, 35);

621: ,p_rec => p_rec);
622: --
623: -- chk_approval_authority
624: --
625: hr_utility.set_location(l_proc, 35);
626: --
627: chk_approval_authority
628: (p_approval_authority => p_rec.approval_authority
629: ,p_rec => p_rec);

Line 634: hr_utility.set_location(l_proc, 40);

630: --
631: -- check that both the benchmark_job_flag and benchmark_job_id are not
632: -- populated
633: --
634: hr_utility.set_location(l_proc, 40);
635: --
636: chk_benchmark_job_flag
637: (p_benchmark_job_flag => p_rec.benchmark_job_flag
638: ,p_benchmark_job_id => p_rec.benchmark_job_id

Line 643: hr_utility.set_location(l_proc, 45);

639: ,p_rec => p_rec);
640: --
641: -- chk_benchmark_job_id
642: --
643: hr_utility.set_location(l_proc, 45);
644: --
645: chk_benchmark_job_id
646: (p_benchmark_job_id => p_rec.benchmark_job_id
647: ,p_job_id => p_rec.job_id

Line 651: hr_utility.set_location(l_proc, 50);

647: ,p_job_id => p_rec.job_id
648: ,p_business_group_id => p_rec.business_group_id
649: ,p_rec => p_rec);
650: --
651: hr_utility.set_location(l_proc, 50);
652: --
653: -- Flexfield Validation
654: --
655: chk_ddf(p_rec => p_rec);

Line 659: hr_utility.set_location(' Leaving:'||l_proc, 55);

655: chk_ddf(p_rec => p_rec);
656: --
657: chk_df(p_rec => p_rec);
658: --
659: hr_utility.set_location(' Leaving:'||l_proc, 55);
660: --
661: End update_validate;
662: --
663: -- ----------------------------------------------------------------------------

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

670: l_business_group_id number;
671: l_proc varchar2(72) := g_package||'delete_validate';
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: --
676: -- Call all supporting business operations
677: --
678: open csr_bg;

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

681: per_job_bus.check_delete_record
682: (p_job_id => p_rec.job_id
683: ,p_business_group_id => l_business_group_id);
684:
685: hr_utility.set_location(' Leaving:'||l_proc, 10);
686: End delete_validate;
687: --
688: --
689: -- ---------------------------------------------------------------------------

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

707: --
708: l_legislation_code varchar2(150);
709: l_proc varchar2(72) := g_package||'return_legislation_code';
710: begin
711: hr_utility.set_location('Entering:'|| l_proc, 10);
712: --
713: -- Ensure that all the mandatory parameter are not null
714: --
715: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 726: hr_utility.set_location(l_proc, 20);

722: -- call to this function. Just return the value in the global
723: -- variable.
724: --
725: l_legislation_code := g_legislation_code;
726: hr_utility.set_location(l_proc, 20);
727: else
728: --
729: -- The ID is different to the last call to this function
730: -- or this is the first call to this function.

Line 739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

735: close csr_leg_code;
736: --
737: -- The primary key is invalid therefore we must error
738: --
739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
740: hr_utility.raise_error;
741: end if;
742: --
743: close csr_leg_code;

Line 740: hr_utility.raise_error;

736: --
737: -- The primary key is invalid therefore we must error
738: --
739: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
740: hr_utility.raise_error;
741: end if;
742: --
743: close csr_leg_code;
744: g_job_id := p_job_id;

Line 747: hr_utility.set_location(' Leaving:'|| l_proc, 30);

743: close csr_leg_code;
744: g_job_id := p_job_id;
745: g_legislation_code := l_legislation_code;
746: end if;
747: hr_utility.set_location(' Leaving:'|| l_proc, 30);
748: --
749: return l_legislation_code;
750: end return_legislation_code;
751: --

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

816: l_proc varchar2(72) := g_package||'chk_emp_rights_flag';
817: l_api_updating boolean;
818:
819: begin
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821:
822: l_api_updating := per_job_shd.api_updating
823: (p_job_id => p_rec.job_id
824: ,p_object_version_number => p_rec.object_version_number);

Line 832: hr_utility.set_message(801,'HR_289476_EMP_RIGHTS_FLAG');

828: nvl(p_emp_rights_flag,hr_api.g_varchar2)) or NOT l_api_updating) then
829:
830: if (p_emp_rights_flag <> 'Y' and p_emp_rights_flag <> 'N' and
831: p_emp_rights_flag is not null) then
832: hr_utility.set_message(801,'HR_289476_EMP_RIGHTS_FLAG');
833: hr_utility.raise_error;
834: end if;
835:
836: end if;

Line 833: hr_utility.raise_error;

829:
830: if (p_emp_rights_flag <> 'Y' and p_emp_rights_flag <> 'N' and
831: p_emp_rights_flag is not null) then
832: hr_utility.set_message(801,'HR_289476_EMP_RIGHTS_FLAG');
833: hr_utility.raise_error;
834: end if;
835:
836: end if;
837:

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

834: end if;
835:
836: end if;
837:
838: hr_utility.set_location('Leaving:'|| l_proc, 20);
839:
840: end chk_emp_rights_flag;
841: --
842: -- -------------------------------------------------------------------------+

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

857: l_job_group_id per_jobs.job_group_id%TYPE;
858: l_proc varchar2(72) := g_package||'chk_job_group_id';
859:
860: begin
861: hr_utility.set_location('Entering:'|| l_proc, 10);
862:
863: open csr_job_group_id;
864: fetch csr_job_group_id into l_job_group_id;
865: close csr_job_group_id;

Line 868: hr_utility.set_message(801, 'HR_289477_JOB_GROUP_ID');

864: fetch csr_job_group_id into l_job_group_id;
865: close csr_job_group_id;
866:
867: if l_job_group_id is null then
868: hr_utility.set_message(801, 'HR_289477_JOB_GROUP_ID');
869: hr_utility.raise_error;
870: end if;
871:
872: hr_utility.set_location('Leaving:'|| l_proc, 20);

Line 869: hr_utility.raise_error;

865: close csr_job_group_id;
866:
867: if l_job_group_id is null then
868: hr_utility.set_message(801, 'HR_289477_JOB_GROUP_ID');
869: hr_utility.raise_error;
870: end if;
871:
872: hr_utility.set_location('Leaving:'|| l_proc, 20);
873:

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

868: hr_utility.set_message(801, 'HR_289477_JOB_GROUP_ID');
869: hr_utility.raise_error;
870: end if;
871:
872: hr_utility.set_location('Leaving:'|| l_proc, 20);
873:
874: end chk_job_group_id;
875: --
876: -- -------------------------------------------------------------------------+

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

885: l_api_updating boolean;
886:
887: begin
888:
889: hr_utility.set_location('Entering:'|| l_proc, 10);
890:
891: l_api_updating := per_job_shd.api_updating
892: (p_job_id => p_rec.job_id
893: ,p_object_version_number => p_rec.object_version_number);

Line 901: hr_utility.set_message(801, 'HR_289991_APPROVAL_AUTHORITY');

897: nvl(p_approval_authority,hr_api.g_number)) or
898: NOT l_api_updating) then
899:
900: if (l_approval_authority < 0) then
901: hr_utility.set_message(801, 'HR_289991_APPROVAL_AUTHORITY');
902: hr_utility.raise_error;
903: end if;
904:
905: end if;

Line 902: hr_utility.raise_error;

898: NOT l_api_updating) then
899:
900: if (l_approval_authority < 0) then
901: hr_utility.set_message(801, 'HR_289991_APPROVAL_AUTHORITY');
902: hr_utility.raise_error;
903: end if;
904:
905: end if;
906:

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

903: end if;
904:
905: end if;
906:
907: hr_utility.set_location('Leaving:'|| l_proc, 20);
908:
909: end chk_approval_authority;
910: --
911: -- -------------------------------------------------------------------------+

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

919: l_proc varchar2(72) := g_package||'chk_benchmark_job_flag';
920: l_api_updating boolean;
921: begin
922:
923: hr_utility.set_location('Entering:'|| l_proc, 10);
924:
925: l_api_updating := per_job_shd.api_updating
926: (p_job_id => p_rec.job_id
927: ,p_object_version_number => p_rec.object_version_number);

Line 937: hr_utility.set_message(801, 'HR_289474_BENCHMARK_JOB_FLAG');

933: nvl(p_benchmark_job_id, hr_api.g_number)) or
934: NOT l_api_updating) then
935:
936: if (p_benchmark_job_flag = 'Y' and p_benchmark_job_id is not null) then
937: hr_utility.set_message(801, 'HR_289474_BENCHMARK_JOB_FLAG');
938: hr_utility.raise_error;
939: end if;
940:
941: end if;

Line 938: hr_utility.raise_error;

934: NOT l_api_updating) then
935:
936: if (p_benchmark_job_flag = 'Y' and p_benchmark_job_id is not null) then
937: hr_utility.set_message(801, 'HR_289474_BENCHMARK_JOB_FLAG');
938: hr_utility.raise_error;
939: end if;
940:
941: end if;
942:

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

939: end if;
940:
941: end if;
942:
943: hr_utility.set_location('Leaving:'|| l_proc, 20);
944:
945: end chk_benchmark_job_flag;
946: --
947: -- --------------------------------------------------------------------------+

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

970: l_api_updating boolean;
971:
972: begin
973:
974: hr_utility.set_location('Entering:'|| l_proc, 10);
975:
976: l_api_updating := per_job_shd.api_updating
977: (p_job_id => p_rec.job_id
978: ,p_object_version_number => p_rec.object_version_number);

Line 991: hr_utility.set_message(801, 'HR_289475_BENCHMARK_JOB_ID');

987: fetch csr_benchmark_job_id into l_benchmark_job_id;
988: close csr_benchmark_job_id;
989:
990: if l_benchmark_job_id is null then
991: hr_utility.set_message(801, 'HR_289475_BENCHMARK_JOB_ID');
992: hr_utility.raise_error;
993: end if;
994:
995: end if;

Line 992: hr_utility.raise_error;

988: close csr_benchmark_job_id;
989:
990: if l_benchmark_job_id is null then
991: hr_utility.set_message(801, 'HR_289475_BENCHMARK_JOB_ID');
992: hr_utility.raise_error;
993: end if;
994:
995: end if;
996:

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

995: end if;
996:
997: end if;
998:
999: hr_utility.set_location('Leaving:'|| l_proc, 20);
1000:
1001: end chk_benchmark_job_id ;
1002: --
1003:

Line 1033: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');

1029: v_not_unique := csr_name%FOUND;
1030: close csr_name;
1031: --
1032: if v_not_unique then
1033: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
1034: hr_utility.raise_error;
1035: end if;
1036: --
1037: hr_utility.set_location(l_proc, 10);

Line 1034: hr_utility.raise_error;

1030: close csr_name;
1031: --
1032: if v_not_unique then
1033: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
1034: hr_utility.raise_error;
1035: end if;
1036: --
1037: hr_utility.set_location(l_proc, 10);
1038: --

Line 1037: hr_utility.set_location(l_proc, 10);

1033: hr_utility.set_message(801,'PER_7810_DEF_JOB_EXISTS');
1034: hr_utility.raise_error;
1035: end if;
1036: --
1037: hr_utility.set_location(l_proc, 10);
1038: --
1039: end check_unique_name;
1040: --
1041: -- --------------------------------------------------------------------------+

Line 1057: hr_utility.set_location('check date',99);

1053: v_job_date_greater boolean := FALSE;
1054: l_proc varchar2(72) := g_package||'check_date_from';
1055: --
1056: begin
1057: hr_utility.set_location('check date',99);
1058: --
1059: -- If the date from item in the jobs block is greater than
1060: -- the date from item in the grades block then raise an error
1061: --

Line 1068: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');

1064: v_job_date_greater := csr_date_from%FOUND;
1065: close csr_date_from;
1066: --
1067: if v_job_date_greater then
1068: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
1069: hr_utility.raise_error;
1070: end if;
1071: --
1072: hr_utility.set_location(l_proc, 10);

Line 1069: hr_utility.raise_error;

1065: close csr_date_from;
1066: --
1067: if v_job_date_greater then
1068: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
1069: hr_utility.raise_error;
1070: end if;
1071: --
1072: hr_utility.set_location(l_proc, 10);
1073: --

Line 1072: hr_utility.set_location(l_proc, 10);

1068: hr_utility.set_message(801,'PER_7825_DEF_GRD_JOB_START_JOB');
1069: hr_utility.raise_error;
1070: end if;
1071: --
1072: hr_utility.set_location(l_proc, 10);
1073: --
1074: end check_date_from;
1075: --
1076: -- --------------------------------------------------------------------------+

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

1104: fetch csr_date_to into g_dummy_number;
1105: p_early_date_to := csr_date_to%FOUND;
1106: close csr_date_to;
1107: --
1108: hr_utility.set_location(l_proc, 10);
1109: --
1110: open csr_date_from;
1111: fetch csr_date_from into g_dummy_number;
1112: p_early_date_from := csr_date_from%FOUND;

Line 1115: hr_utility.set_location(l_proc, 20);

1111: fetch csr_date_from into g_dummy_number;
1112: p_early_date_from := csr_date_from%FOUND;
1113: close csr_date_from;
1114: --
1115: hr_utility.set_location(l_proc, 20);
1116: --
1117: end check_altered_end_date;
1118: --
1119: -- ---------------------------------------------------------------------------

Line 1204: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');

1200: v_record_exists := csr_position%FOUND;
1201: close csr_position;
1202: --
1203: if v_record_exists then
1204: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
1205: hr_utility.raise_error;
1206: end if;
1207: --
1208: hr_utility.set_location(l_proc, 10);

Line 1205: hr_utility.raise_error;

1201: close csr_position;
1202: --
1203: if v_record_exists then
1204: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
1205: hr_utility.raise_error;
1206: end if;
1207: --
1208: hr_utility.set_location(l_proc, 10);
1209: --

Line 1208: hr_utility.set_location(l_proc, 10);

1204: hr_utility.set_message(801,'PER_7813_DEF_JOB_DEL_POS');
1205: hr_utility.raise_error;
1206: end if;
1207: --
1208: hr_utility.set_location(l_proc, 10);
1209: --
1210: --
1211: --
1212: open csr_assignment;

Line 1218: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');

1214: v_record_exists := csr_assignment%FOUND;
1215: close csr_assignment;
1216: --
1217: if v_record_exists then
1218: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
1219: hr_utility.raise_error;
1220: end if;
1221: --
1222: hr_utility.set_location(l_proc, 20);

Line 1219: hr_utility.raise_error;

1215: close csr_assignment;
1216: --
1217: if v_record_exists then
1218: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
1219: hr_utility.raise_error;
1220: end if;
1221: --
1222: hr_utility.set_location(l_proc, 20);
1223: --

Line 1222: hr_utility.set_location(l_proc, 20);

1218: hr_utility.set_message(801,'PER_7817_DEF_JOB_DEL_EMP');
1219: hr_utility.raise_error;
1220: end if;
1221: --
1222: hr_utility.set_location(l_proc, 20);
1223: --
1224: --
1225: --
1226: open csr_grade;

Line 1232: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');

1228: v_record_exists := csr_grade%FOUND;
1229: close csr_grade;
1230: --
1231: if v_record_exists then
1232: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
1233: hr_utility.raise_error;
1234: end if;
1235: --
1236: hr_utility.set_location(l_proc, 30);

Line 1233: hr_utility.raise_error;

1229: close csr_grade;
1230: --
1231: if v_record_exists then
1232: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
1233: hr_utility.raise_error;
1234: end if;
1235: --
1236: hr_utility.set_location(l_proc, 30);
1237: --

Line 1236: hr_utility.set_location(l_proc, 30);

1232: hr_utility.set_message(801,'PER_7812_DEF_JOB_DEL_GRADE');
1233: hr_utility.raise_error;
1234: end if;
1235: --
1236: hr_utility.set_location(l_proc, 30);
1237: --
1238: --
1239: --
1240: open csr_requirement;

Line 1246: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');

1242: v_record_exists := csr_requirement%FOUND;
1243: close csr_requirement;
1244: --
1245: if v_record_exists then
1246: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
1247: hr_utility.raise_error;
1248: end if;
1249: --
1250: hr_utility.set_location(l_proc, 40);

Line 1247: hr_utility.raise_error;

1243: close csr_requirement;
1244: --
1245: if v_record_exists then
1246: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
1247: hr_utility.raise_error;
1248: end if;
1249: --
1250: hr_utility.set_location(l_proc, 40);
1251: --

Line 1250: hr_utility.set_location(l_proc, 40);

1246: hr_utility.set_message(801,'PER_7814_DEF_JOB_DEL_REQ');
1247: hr_utility.raise_error;
1248: end if;
1249: --
1250: hr_utility.set_location(l_proc, 40);
1251: --
1252: --
1253: --
1254: open csr_evaluation;

Line 1260: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');

1256: v_record_exists := csr_evaluation%FOUND;
1257: close csr_evaluation;
1258: --
1259: if v_record_exists then
1260: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
1261: hr_utility.raise_error;
1262: end if;
1263: --
1264: hr_utility.set_location(l_proc, 50);

Line 1261: hr_utility.raise_error;

1257: close csr_evaluation;
1258: --
1259: if v_record_exists then
1260: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
1261: hr_utility.raise_error;
1262: end if;
1263: --
1264: hr_utility.set_location(l_proc, 50);
1265: --

Line 1264: hr_utility.set_location(l_proc, 50);

1260: hr_utility.set_message(801,'PER_7815_DEF_JOB_DEL_EVAL');
1261: hr_utility.raise_error;
1262: end if;
1263: --
1264: hr_utility.set_location(l_proc, 50);
1265: --
1266: --
1267: open csr_elementp;
1268: fetch csr_elementp into g_dummy_number;

Line 1273: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');

1269: v_record_exists := csr_elementp%FOUND;
1270: close csr_elementp;
1271: --
1272: if v_record_exists then
1273: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1274: hr_utility.raise_error;
1275: end if;
1276: --
1277: hr_utility.set_location(l_proc, 60);

Line 1274: hr_utility.raise_error;

1270: close csr_elementp;
1271: --
1272: if v_record_exists then
1273: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1274: hr_utility.raise_error;
1275: end if;
1276: --
1277: hr_utility.set_location(l_proc, 60);
1278: --

Line 1277: hr_utility.set_location(l_proc, 60);

1273: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1274: hr_utility.raise_error;
1275: end if;
1276: --
1277: hr_utility.set_location(l_proc, 60);
1278: --
1279: --
1280: --
1281: open csr_elements;

Line 1287: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');

1283: v_record_exists := csr_elements%FOUND;
1284: close csr_elements;
1285: --
1286: if v_record_exists then
1287: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1288: hr_utility.raise_error;
1289: end if;
1290: --
1291: hr_utility.set_location(l_proc, 70);

Line 1288: hr_utility.raise_error;

1284: close csr_elements;
1285: --
1286: if v_record_exists then
1287: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1288: hr_utility.raise_error;
1289: end if;
1290: --
1291: hr_utility.set_location(l_proc, 70);
1292: --

Line 1291: hr_utility.set_location(l_proc, 70);

1287: hr_utility.set_message(801,'PER_7811_DEF_JOB_DEL_PATH');
1288: hr_utility.raise_error;
1289: end if;
1290: --
1291: hr_utility.set_location(l_proc, 70);
1292: --
1293: --
1294: open csr_budget;
1295: fetch csr_budget into g_dummy_number;

Line 1300: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');

1296: v_record_exists := csr_budget%FOUND;
1297: close csr_budget;
1298: --
1299: if v_record_exists then
1300: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
1301: hr_utility.raise_error;
1302: end if;
1303: --
1304: hr_utility.set_location(l_proc, 80);

Line 1301: hr_utility.raise_error;

1297: close csr_budget;
1298: --
1299: if v_record_exists then
1300: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
1301: hr_utility.raise_error;
1302: end if;
1303: --
1304: hr_utility.set_location(l_proc, 80);
1305: --

Line 1304: hr_utility.set_location(l_proc, 80);

1300: hr_utility.set_message(801,'PER_7816_DEF_JOB_DEL_BUD');
1301: hr_utility.raise_error;
1302: end if;
1303: --
1304: hr_utility.set_location(l_proc, 80);
1305: --
1306: --
1307: open csr_vacancy;
1308: fetch csr_vacancy into g_dummy_number;

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

1309: v_record_exists := csr_vacancy%FOUND;
1310: close csr_vacancy;
1311: --
1312: if v_record_exists then
1313: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
1314: hr_utility.raise_error;
1315: end if;
1316: --
1317: hr_utility.set_location(l_proc, 90);

Line 1314: hr_utility.raise_error;

1310: close csr_vacancy;
1311: --
1312: if v_record_exists then
1313: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
1314: hr_utility.raise_error;
1315: end if;
1316: --
1317: hr_utility.set_location(l_proc, 90);
1318: --

Line 1317: hr_utility.set_location(l_proc, 90);

1313: hr_utility.set_message(801,'HR_6945_JOB_DEL_RAC');
1314: hr_utility.raise_error;
1315: end if;
1316: --
1317: hr_utility.set_location(l_proc, 90);
1318: --
1319: --
1320: open csr_link;
1321: fetch csr_link into g_dummy_number;

Line 1326: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');

1322: v_record_exists := csr_link%FOUND;
1323: close csr_link;
1324: --
1325: if v_record_exists then
1326: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
1327: hr_utility.raise_error;
1328: end if;
1329: --
1330: hr_utility.set_location(l_Proc, 100);

Line 1327: hr_utility.raise_error;

1323: close csr_link;
1324: --
1325: if v_record_exists then
1326: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
1327: hr_utility.raise_error;
1328: end if;
1329: --
1330: hr_utility.set_location(l_Proc, 100);
1331: --

Line 1330: hr_utility.set_location(l_Proc, 100);

1326: hr_utility.set_message(801,'HR_6946_JOB_DEL_LINK');
1327: hr_utility.raise_error;
1328: end if;
1329: --
1330: hr_utility.set_location(l_Proc, 100);
1331: --
1332: --
1333: open csr_role;
1334: fetch csr_role into g_dummy_number;

Line 1339: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');

1335: v_record_exists := csr_role%FOUND;
1336: close csr_role;
1337: --
1338: if v_record_exists then
1339: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
1340: hr_utility.raise_error;
1341: end if;
1342: --
1343: hr_utility.set_location(l_proc, 110);

Line 1340: hr_utility.raise_error;

1336: close csr_role;
1337: --
1338: if v_record_exists then
1339: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
1340: hr_utility.raise_error;
1341: end if;
1342: --
1343: hr_utility.set_location(l_proc, 110);
1344: --

Line 1343: hr_utility.set_location(l_proc, 110);

1339: hr_utility.set_message(800,'PER_52684_JOB_DEL_ROLE');
1340: hr_utility.raise_error;
1341: end if;
1342: --
1343: hr_utility.set_location(l_proc, 110);
1344: --
1345: -- is po installed?
1346: --
1347: if (fnd_installation.get(appl_id => 201

Line 1403: hr_utility.set_location(l_proc, 120);

1399: end;
1400: end if;
1401: end if;
1402: --
1403: hr_utility.set_location(l_proc, 120);
1404: --
1405: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
1406: --
1407: hr_utility.set_location(l_proc, 130);

Line 1407: hr_utility.set_location(l_proc, 130);

1403: hr_utility.set_location(l_proc, 120);
1404: --
1405: per_ota_predel_validation.ota_predel_job_validation(p_job_id);
1406: --
1407: hr_utility.set_location(l_proc, 130);
1408: --
1409: pa_job.pa_predel_validation(p_job_id);
1410: --
1411: end check_delete_record;

Line 1438: hr_utility.raise_error;

1434: if l_job_evaluation.date_evaluated not between
1435: nvl(p_job_date_from, hr_api.g_sot) and
1436: nvl(p_job_date_to, hr_api.g_eot) then
1437: fnd_message.set_name('PER', 'HR_52603_JOB_JBE_OUT_PERIOD');
1438: hr_utility.raise_error;
1439: end if;
1440: end loop;
1441: end if;
1442: