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_VAC_BUS dependencies on HR_UTILITY

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

37: l_proc varchar2(72) := g_package||'set_security_group_id';
38: --
39: begin
40: --
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Ensure that all the mandatory parameter are not null
44: --
45: hr_api.mandatory_arg_error

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

70: (p_security_group_id => l_security_group_id
71: );
72: --
73: end if;
74: hr_utility.set_location(' Leaving:'|| l_proc, 20);
75: --
76: end set_security_group_id;
77: --
78: -- ---------------------------------------------------------------------------

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

99: l_proc varchar2(72) := g_package||'return_legislation_code';
100: --
101: Begin
102: --
103: hr_utility.set_location('Entering:'|| l_proc, 10);
104: --
105: -- Ensure that all the mandatory parameter are not null
106: --
107: hr_api.mandatory_arg_error

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

117: -- call to this function. Just return the value in the global
118: -- variable.
119: --
120: l_legislation_code := per_vac_bus.g_legislation_code;
121: hr_utility.set_location(l_proc, 20);
122: else
123: --
124: -- The ID is different to the last call to this function
125: -- or this is the first call to this function.

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

134: close csr_leg_code;
135: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
136: fnd_message.raise_error;
137: end if;
138: hr_utility.set_location(l_proc,30);
139: --
140: -- Set the global variables so the values are
141: -- available for the next call to this function.
142: --

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

143: close csr_leg_code;
144: per_vac_bus.g_vacancy_id := p_vacancy_id;
145: per_vac_bus.g_legislation_code := l_legislation_code;
146: end if;
147: hr_utility.set_location(' Leaving:'|| l_proc, 40);
148: return l_legislation_code;
149: end return_legislation_code;
150: --
151: -- ----------------------------------------------------------------------------

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

182: --
183: l_proc varchar2(72) := g_package || 'chk_df';
184: --
185: begin
186: hr_utility.set_location('Entering:'||l_proc,10);
187: --
188: if ((p_rec.vacancy_id is not null) and (
189: nvl(per_vac_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
190: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

281: ,p_attribute20_value => p_rec.attribute20
282: );
283: end if;
284: --
285: hr_utility.set_location(' Leaving:'||l_proc,20);
286: end chk_df;
287: --
288: -- ----------------------------------------------------------------------------
289: -- |-----------------------< chk_non_updateable_args >------------------------|

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

397: where name = p_name
398: and business_group_id = p_business_group_id;
399: --
400: Begin
401: hr_utility.set_location('Entering:'||l_proc,10);
402: --
403: if (p_name is null)
404: then
405: hr_api.mandatory_arg_error

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

411: --
412: open csr_name;
413: fetch csr_name into l_name;
414: --
415: hr_utility.set_location(l_proc,20);
416: if (csr_name%found)
417: then
418: close csr_name;
419: fnd_message.set_name('PER','IRC_412115_DUPLICATE_VAC_NAME');

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

421: fnd_message.raise_error;
422: end if;
423: close csr_name;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc,30);
426: exception
427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PER_ALL_VACANCIES.NAME'

Line 431: hr_utility.set_location(' Leaving:'|| l_proc, 40);

427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PER_ALL_VACANCIES.NAME'
430: ) then
431: hr_utility.set_location(' Leaving:'|| l_proc, 40);
432: raise;
433: end if;
434: hr_utility.set_location(' Leaving:'|| l_proc, 50);
435: End chk_name;

Line 434: hr_utility.set_location(' Leaving:'|| l_proc, 50);

430: ) then
431: hr_utility.set_location(' Leaving:'|| l_proc, 40);
432: raise;
433: end if;
434: hr_utility.set_location(' Leaving:'|| l_proc, 50);
435: End chk_name;
436: --
437: -- ----------------------------------------------------------------------------
438: -- |-------------------------------------------------------|

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

469: l_proc varchar2(72) := g_package || 'chk_vacancy_dates';
470: l_api_updating boolean;
471: --
472: Begin
473: hr_utility.set_location('Entering:'||l_proc,10);
474: l_api_updating := per_vac_shd.api_updating
475: (p_vacancy_id => p_vacancy_id
476: ,p_object_version_number => p_object_version_number);
477: --

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

474: l_api_updating := per_vac_shd.api_updating
475: (p_vacancy_id => p_vacancy_id
476: ,p_object_version_number => p_object_version_number);
477: --
478: hr_utility.set_location(l_proc,20);
479: if ((l_api_updating
480: and
481: (nvl(per_vac_shd.g_old_rec.date_from, hr_api.g_date) <>
482: nvl(p_date_from, hr_api.g_date) or

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

484: nvl(p_date_to, hr_api.g_date)))
485: or
486: (NOT l_api_updating)) then
487: --
488: hr_utility.set_location(l_proc,30);
489: if (p_date_from is null)
490: then
491: fnd_message.set_name('PER','PER_289443_VAC_DATE_FROM_MND');
492: hr_multi_message.add

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

493: (p_associated_column1 => 'PER_ALL_VACANCIES.DATE_FROM'
494: );
495: hr_multi_message.end_validation_set();
496: end if;
497: hr_utility.set_location(l_proc,40);
498: --
499: if (p_date_from > nvl(p_date_to,hr_api.g_eot))
500: then
501: fnd_message.set_name('PER','IRC_ALL_DATE_START_END');

Line 509: hr_utility.set_location(' Leaving:'||l_proc,50);

505: );
506: end if;
507: end if;
508: --
509: hr_utility.set_location(' Leaving:'||l_proc,50);
510: End chk_vacancy_dates;
511: --
512: -- ----------------------------------------------------------------------------
513: -- |-----------------------------< chk_status >-------------------------------|

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

546: l_exists boolean;
547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc,10);
551: l_api_updating := per_vac_shd.api_updating
552: (p_vacancy_id => p_vacancy_id
553: ,p_object_version_number => p_object_version_number);
554: --

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

551: l_api_updating := per_vac_shd.api_updating
552: (p_vacancy_id => p_vacancy_id
553: ,p_object_version_number => p_object_version_number);
554: --
555: hr_utility.set_location(l_proc,20);
556: if ((l_api_updating
557: and
558: nvl(per_vac_shd.g_old_rec.status, hr_api.g_varchar2) <>
559: nvl(p_status, hr_api.g_varchar2))

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

563: then
564: l_exists := hr_api.not_exists_in_hr_lookups(p_effective_date
565: ,'VACANCY_STATUS'
566: ,p_status);
567: hr_utility.set_location(l_proc,30);
568: if (l_exists = true)
569: then
570: fnd_message.set_name('PER','PER_289444_VAC_INV_STATUS_CODE');
571: fnd_message.raise_error;

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

569: then
570: fnd_message.set_name('PER','PER_289444_VAC_INV_STATUS_CODE');
571: fnd_message.raise_error;
572: end if;
573: hr_utility.set_location(l_proc,30);
574: end if;
575: end if;
576: --
577: hr_utility.set_location(' Leaving:'||l_proc,40);

Line 577: hr_utility.set_location(' Leaving:'||l_proc,40);

573: hr_utility.set_location(l_proc,30);
574: end if;
575: end if;
576: --
577: hr_utility.set_location(' Leaving:'||l_proc,40);
578: exception
579: when app_exception.application_exception then
580: if hr_multi_message.exception_add
581: (p_associated_column1 => 'PER_ALL_VACANCIES.STATUS'

Line 583: hr_utility.set_location(' Leaving:'|| l_proc, 50);

579: when app_exception.application_exception then
580: if hr_multi_message.exception_add
581: (p_associated_column1 => 'PER_ALL_VACANCIES.STATUS'
582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;
585: end if;
586: hr_utility.set_location(' Leaving:'|| l_proc, 60);
587: --

Line 586: hr_utility.set_location(' Leaving:'|| l_proc, 60);

582: ) then
583: hr_utility.set_location(' Leaving:'|| l_proc, 50);
584: raise;
585: end if;
586: hr_utility.set_location(' Leaving:'|| l_proc, 60);
587: --
588: End chk_status;
589: --
590: -- ----------------------------------------------------------------------------

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

623: l_proc varchar2(72) := g_package || 'chk_budget_measurement_type';
624: l_api_updating boolean;
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc,10);
628: --
629: l_api_updating := per_vac_shd.api_updating
630: (p_vacancy_id => p_vacancy_id
631: ,p_object_version_number => p_object_version_number);

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

629: l_api_updating := per_vac_shd.api_updating
630: (p_vacancy_id => p_vacancy_id
631: ,p_object_version_number => p_object_version_number);
632: --
633: hr_utility.set_location(l_proc,20);
634: if ((l_api_updating
635: and
636: nvl(per_vac_shd.g_old_rec.budget_measurement_type,hr_api.g_varchar2) <>
637: nvl(p_budget_measurement_type, hr_api.g_varchar2))

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

642: then
643: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date
644: ,'BUDGET_MEASUREMENT_TYPE'
645: ,p_budget_measurement_type);
646: hr_utility.set_location(l_proc,30);
647: if (l_api_updating = true)
648: then
649: fnd_message.set_name('PER','PER_289445_VAC_INV_BUD_MST_TYP');
650: fnd_message.raise_error;

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

648: then
649: fnd_message.set_name('PER','PER_289445_VAC_INV_BUD_MST_TYP');
650: fnd_message.raise_error;
651: end if;
652: hr_utility.set_location(l_proc,40);
653: end if;
654: end if;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc,50);

Line 656: hr_utility.set_location(' Leaving:'||l_proc,50);

652: hr_utility.set_location(l_proc,40);
653: end if;
654: end if;
655: --
656: hr_utility.set_location(' Leaving:'||l_proc,50);
657: exception
658: when app_exception.application_exception then
659: if hr_multi_message.exception_add
660: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_TYPE'

Line 662: hr_utility.set_location(' Leaving:'|| l_proc, 60);

658: when app_exception.application_exception then
659: if hr_multi_message.exception_add
660: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_TYPE'
661: ) then
662: hr_utility.set_location(' Leaving:'|| l_proc, 60);
663: raise;
664: end if;
665: hr_utility.set_location(' Leaving:'|| l_proc, 70);
666: End chk_budget_measurement_type;

Line 665: hr_utility.set_location(' Leaving:'|| l_proc, 70);

661: ) then
662: hr_utility.set_location(' Leaving:'|| l_proc, 60);
663: raise;
664: end if;
665: hr_utility.set_location(' Leaving:'|| l_proc, 70);
666: End chk_budget_measurement_type;
667: --
668: -- ----------------------------------------------------------------------------
669: -- |-----------------------------------------------------|

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

699: l_proc varchar2(72) := g_package || 'chk_security_method';
700: l_api_updating boolean;
701: --
702: Begin
703: hr_utility.set_location('Entering:'||l_proc,10);
704: --
705: l_api_updating := per_vac_shd.api_updating
706: (p_vacancy_id => p_vacancy_id
707: ,p_object_version_number => p_object_version_number);

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

705: l_api_updating := per_vac_shd.api_updating
706: (p_vacancy_id => p_vacancy_id
707: ,p_object_version_number => p_object_version_number);
708: --
709: hr_utility.set_location(l_proc,20);
710: if ((l_api_updating
711: and
712: nvl(per_vac_shd.g_old_rec.security_method,hr_api.g_varchar2) <>
713: nvl(p_security_method, hr_api.g_varchar2))

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

713: nvl(p_security_method, hr_api.g_varchar2))
714: or
715: (NOT l_api_updating)) then
716: --
717: hr_utility.set_location(l_proc,30);
718: if(p_security_method is not null)
719: then
720: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date
721: ,'IRC_SECURITY_METHOD'

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

719: then
720: l_api_updating := hr_api.not_exists_in_hr_lookups(p_effective_date
721: ,'IRC_SECURITY_METHOD'
722: ,p_security_method);
723: hr_utility.set_location(l_proc,40);
724: if (l_api_updating = true)
725: then
726: fnd_message.set_name('PER','PER_289446_VAC_INV_SEC_METHOD');
727: fnd_message.raise_error;

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

725: then
726: fnd_message.set_name('PER','PER_289446_VAC_INV_SEC_METHOD');
727: fnd_message.raise_error;
728: end if;
729: hr_utility.set_location(l_proc,50);
730: end if;
731: end if;
732: hr_utility.set_location(' Leaving:'||l_proc,60);
733: exception

Line 732: hr_utility.set_location(' Leaving:'||l_proc,60);

728: end if;
729: hr_utility.set_location(l_proc,50);
730: end if;
731: end if;
732: hr_utility.set_location(' Leaving:'||l_proc,60);
733: exception
734: when app_exception.application_exception then
735: if hr_multi_message.exception_add
736: (p_associated_column1 => 'PER_ALL_VACANCIES.SECURITY_METHOD'

Line 738: hr_utility.set_location(' Leaving:'|| l_proc, 70);

734: when app_exception.application_exception then
735: if hr_multi_message.exception_add
736: (p_associated_column1 => 'PER_ALL_VACANCIES.SECURITY_METHOD'
737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 70);
739: raise;
740: end if;
741: hr_utility.set_location(' Leaving:'|| l_proc, 80);
742: End chk_security_method;

Line 741: hr_utility.set_location(' Leaving:'|| l_proc, 80);

737: ) then
738: hr_utility.set_location(' Leaving:'|| l_proc, 70);
739: raise;
740: end if;
741: hr_utility.set_location(' Leaving:'|| l_proc, 80);
742: End chk_security_method;
743: --
744: -- ----------------------------------------------------------------------------
745: -- |------------------------------------------------------|

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

780: and business_group_id = p_business_group_id;
781: --
782: Begin
783: --
784: hr_utility.set_location('Entering:'||l_proc,10);
785: open csr_requisition;
786: fetch csr_requisition into l_date_from,l_date_to;
787: if (csr_requisition%NOTFOUND) then
788: close csr_requisition;

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

791: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'
792: );
793: else
794: close csr_requisition;
795: hr_utility.set_location(l_proc,20);
796: if(p_date_from not between l_date_from and nvl(l_date_to,hr_api.g_eot)) then
797: fnd_message.set_name('PER','PER_289448_VAC_REQ_ID_INV_DATE');
798: hr_multi_message.add
799: (p_associated_column1 => 'PER_ALL_VACANCIES.REQUISITION_ID'

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

802: );
803: end if;
804: end if;
805: --
806: hr_utility.set_location(' Leaving:'||l_proc,30);
807: End chk_requisition_id;
808: --
809: -- ---------------------------------------------------------------------------
810: -- |------------------------< chk_position_id >------------------------------|

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

839: and ps.shared_type_id = hp.availability_status_id
840: and ps.system_type_cd = 'ACTIVE' ;
841: --
842: begin
843: hr_utility.set_location('Entering:'|| l_proc, 10);
844: --
845: -- Only proceed with validation if :
846: -- a) The current g_old_rec is current and
847: -- b) The value for position_id has changed

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

849: l_api_updating := per_vac_shd.api_updating
850: (p_vacancy_id => p_vacancy_id
851: ,p_object_version_number => p_object_version_number);
852: --
853: hr_utility.set_location(l_proc,20);
854: if ((l_api_updating
855: and
856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
857: nvl(p_position_id, hr_api.g_number))

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

856: nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
857: nvl(p_position_id, hr_api.g_number))
858: or
859: (NOT l_api_updating)) then
860: hr_utility.set_location(l_proc, 30);
861: --
862: -- Check that if the value for position_id is not null
863: -- then it exists date effective in HR_POSITIONS
864: --

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

873: fnd_message.set_name('PER','PER_289449_VAC_INV_POS_ID');
874: fnd_message.raise_error;
875: end if;
876: close csr_valid_pos;
877: hr_utility.set_location(l_proc, 40);
878: --
879: -- Check if the business_group_id for the assignment matches
880: -- the business_group_id in HR_POSITIONS date effectively.
881: --

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

884: fnd_message.set_name('PAY', 'HR_51009_ASG_INVALID_BG_POS');
885: fnd_message.raise_error;
886: --
887: end if;
888: hr_utility.set_location(l_proc, 50);
889: --
890: end if;
891: --
892: end if;

Line 894: hr_utility.set_location('Leaving'||l_proc, 80);

890: end if;
891: --
892: end if;
893: --
894: hr_utility.set_location('Leaving'||l_proc, 80);
895: exception
896: when app_exception.application_exception then
897: if hr_multi_message.exception_add
898: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

Line 900: hr_utility.set_location(' Leaving:'|| l_proc, 40);

896: when app_exception.application_exception then
897: if hr_multi_message.exception_add
898: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
899: ) then
900: hr_utility.set_location(' Leaving:'|| l_proc, 40);
901: raise;
902: end if;
903: hr_utility.set_location(' Leaving:'|| l_proc, 50);
904: end chk_position_id;

Line 903: hr_utility.set_location(' Leaving:'|| l_proc, 50);

899: ) then
900: hr_utility.set_location(' Leaving:'|| l_proc, 40);
901: raise;
902: end if;
903: hr_utility.set_location(' Leaving:'|| l_proc, 50);
904: end chk_position_id;
905: ------------------------------------------------------------------------------
906: -------------------< chk_position_id_grade_id >-------------------------------
907: ------------------------------------------------------------------------------

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

930: and nvl(date_to, hr_api.g_eot);
931: --
932: begin
933: --
934: hr_utility.set_location('Entering:'|| l_proc, 1);
935: if hr_multi_message.no_exclusive_error
936: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
937: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
938: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

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

955: ))
956: or
957: (NOT l_api_updating) then
958: --
959: hr_utility.set_location(l_proc, 2);
960: --
961: -- Check that position_id and grade_id both contain not null values
962: --
963: if p_position_id is not null and p_grade_id is not null then

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

969: if csr_valid_pos_val_grd%notfound then
970: l_inv_pos_grade_warning := true;
971: end if;
972: close csr_valid_pos_val_grd;
973: hr_utility.set_location(l_proc, 3);
974: --
975: end if;
976: --
977: end if;

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

977: end if;
978: --
979: p_inv_pos_grade_warning := l_inv_pos_grade_warning;
980: end if;
981: hr_utility.set_location('Leaving'||l_proc, 4);
982:
983: end chk_position_id_grade_id;
984: --
985: -- ----------------------------------------------------------------------------

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

1010: and hp.organization_id = p_organization_id;
1011: --
1012: begin
1013: --
1014: hr_utility.set_location('Entering:'|| l_proc, 1);
1015: if hr_multi_message.no_exclusive_error
1016: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1017: ,p_check_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1018: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

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

1035: ))
1036: or
1037: (NOT l_api_updating) then
1038: --
1039: hr_utility.set_location(l_proc, 2);
1040: --
1041: -- Check if the position is null
1042: --
1043: If p_position_id is not null then

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

1044: --
1045: -- Check if assignment position_id and organization_id combination
1046: -- matches the combination in HR_POSITIONS.
1047: --
1048: hr_utility.set_location(l_proc, 3);
1049: open csr_valid_pos_org_comb;
1050: fetch csr_valid_pos_org_comb into l_exists;
1051: if csr_valid_pos_org_comb%notfound then
1052: close csr_valid_pos_org_comb;

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

1058: end if;
1059: end if;
1060: --
1061: end if;
1062: hr_utility.set_location('Leaving'||l_proc, 4);
1063: exception
1064: when app_exception.application_exception then
1065: if hr_multi_message.exception_add
1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

Line 1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1065: if hr_multi_message.exception_add
1066: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1067: ,p_associated_column2 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1068: ) then
1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1070: raise;
1071: end if;
1072: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1073: end chk_position_id_org_id;

Line 1072: hr_utility.set_location(' Leaving:'|| l_proc, 70);

1068: ) then
1069: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1070: raise;
1071: end if;
1072: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1073: end chk_position_id_org_id;
1074: --
1075: ------------------------------------------------------------------------------
1076: -------------------------< chk_position_id_job_id >---------------------------

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

1098: and hp.effective_end_date
1099: and hp.job_id = p_job_id;
1100: --
1101: begin
1102: hr_utility.set_location('Entering:'|| l_proc, 10);
1103: if hr_multi_message.no_exclusive_error
1104: (p_check_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1105: ,p_check_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1106: ,p_check_column3 => 'PER_ALL_VACANCIES.DATE_FROM'

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

1112: --
1113: l_api_updating := per_vac_shd.api_updating
1114: (p_vacancy_id => p_vacancy_id
1115: ,p_object_version_number => p_object_version_number);
1116: hr_utility.set_location(l_proc, 30);
1117: --
1118: if (l_api_updating and
1119: ((nvl(per_vac_shd.g_old_rec.position_id, hr_api.g_number) <>
1120: nvl(p_position_id, hr_api.g_number))

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

1124: ))
1125: or
1126: (NOT l_api_updating)
1127: then
1128: hr_utility.set_location(l_proc, 40);
1129: --
1130: -- Check if the assignment job and position are not null
1131: --
1132: if p_position_id is not null and p_job_id is not null then

Line 1158: hr_utility.set_location('Leaving'||l_proc, 3);

1154: --
1155: end if;
1156: end if;
1157: --
1158: hr_utility.set_location('Leaving'||l_proc, 3);
1159: exception
1160: when app_exception.application_exception then
1161: if hr_multi_message.exception_add
1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'

Line 1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1161: if hr_multi_message.exception_add
1162: (p_associated_column1 => 'PER_ALL_VACANCIES.POSITION_ID'
1163: ,p_associated_column2 => 'PER_ALL_VACANCIES.JOB_ID'
1164: ) then
1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1166: raise;
1167: end if;
1168: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1169: end chk_position_id_job_id;

Line 1168: hr_utility.set_location(' Leaving:'|| l_proc, 70);

1164: ) then
1165: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1166: raise;
1167: end if;
1168: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1169: end chk_position_id_job_id;
1170: --
1171: -- ----------------------------------------------------------------------------
1172: -- |--------------------------------------------------------------|

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

1214: and business_group_id = p_business_group_id;
1215: --
1216: Begin
1217: --
1218: hr_utility.set_location('Entering:'||l_proc,10);
1219: --
1220: l_api_updating := per_vac_shd.api_updating
1221: (p_vacancy_id => p_vacancy_id
1222: ,p_object_version_number => p_object_version_number);

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

1220: l_api_updating := per_vac_shd.api_updating
1221: (p_vacancy_id => p_vacancy_id
1222: ,p_object_version_number => p_object_version_number);
1223: --
1224: hr_utility.set_location(l_proc,20);
1225: if ((l_api_updating
1226: and
1227: nvl(per_vac_shd.g_old_rec.job_id,hr_api.g_number) <>
1228: nvl(p_job_id, hr_api.g_number))

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

1231: --
1232: if (p_job_id is not null) then
1233: open csr_job;
1234: fetch csr_job into l_date_from,l_date_to;
1235: hr_utility.set_location(l_proc,30);
1236: if (csr_job%notfound) then
1237: close csr_job;
1238: fnd_message.set_name('PER','PER_289451_VAC_INV_JOB_ID');
1239: hr_multi_message.add

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

1240: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1241: );
1242: else
1243: close csr_job;
1244: hr_utility.set_location(l_proc,40);
1245: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1246: then
1247: fnd_message.set_name('PER','PER_289452_VAC_JOB_ID_INV_DATE');
1248: hr_multi_message.add

Line 1257: hr_utility.set_location(' Leaving:'||l_proc,50);

1253: end if;
1254: end if;
1255: end if;
1256: --
1257: hr_utility.set_location(' Leaving:'||l_proc,50);
1258: End chk_job_id;
1259: --
1260: -- ---------------------------------------------------------------------------
1261: -- |----------------------< chk_job_id_grade_id >----------------------------|

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

1285: between date_from
1286: and nvl(date_to, hr_api.g_eot);
1287: --
1288: begin
1289: hr_utility.set_location('Entering:'|| l_proc, 10);
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1292: ,p_check_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1293: ) then

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

1297: l_api_updating := per_vac_shd.api_updating
1298: (p_vacancy_id => p_vacancy_id
1299: ,p_object_version_number => p_object_version_number
1300: );
1301: hr_utility.set_location(l_proc, 30);
1302: --
1303: -- Only proceed with validation if :
1304: -- a) The current g_old_rec is current and
1305: -- b) The value for job or grade has changed.

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

1312: (nvl(per_vac_shd.g_old_rec.grade_id, hr_api.g_number)
1313: <> nvl(p_grade_id, hr_api.g_number))))
1314: or
1315: NOT l_api_updating then
1316: hr_utility.set_location(l_proc, 40);
1317: --
1318: -- Check that both job and grade are set.
1319: --
1320: if p_job_id is not null and p_grade_id is not null then

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

1327: if csr_val_job_grade%notfound then
1328: p_inv_job_grade_warning := true;
1329: end if;
1330: close csr_val_job_grade;
1331: hr_utility.set_location(l_proc, 50);
1332: --
1333: end if;
1334: hr_utility.set_location(l_proc, 60);
1335: --

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

1330: close csr_val_job_grade;
1331: hr_utility.set_location(l_proc, 50);
1332: --
1333: end if;
1334: hr_utility.set_location(l_proc, 60);
1335: --
1336: end if;
1337: end if;
1338: --

Line 1339: hr_utility.set_location(' Leaving:'|| l_proc, 70);

1335: --
1336: end if;
1337: end if;
1338: --
1339: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1340: exception
1341: when app_exception.application_exception then
1342: if hr_multi_message.exception_add
1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'

Line 1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1342: if hr_multi_message.exception_add
1343: (p_associated_column1 => 'PER_ALL_VACANCIES.JOB_ID'
1344: ,p_associated_column2 => 'PER_ALL_VACANCIES.GRADE_ID'
1345: ) then
1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1347: raise;
1348: end if;
1349: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1350: end chk_job_id_grade_id;

Line 1349: hr_utility.set_location(' Leaving:'|| l_proc, 70);

1345: ) then
1346: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1347: raise;
1348: end if;
1349: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1350: end chk_job_id_grade_id;
1351: --
1352: -- ----------------------------------------------------------------------------
1353: -- |------------------------------------------------------------|

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

1393: where grade_id = p_grade_id
1394: and business_group_id = p_business_group_id;
1395: --
1396: Begin
1397: hr_utility.set_location('Entering:'||l_proc,10);
1398: --
1399: l_api_updating := per_vac_shd.api_updating
1400: (p_vacancy_id => p_vacancy_id
1401: ,p_object_version_number => p_object_version_number);

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

1399: l_api_updating := per_vac_shd.api_updating
1400: (p_vacancy_id => p_vacancy_id
1401: ,p_object_version_number => p_object_version_number);
1402: --
1403: hr_utility.set_location(l_proc,20);
1404: if ((l_api_updating
1405: and
1406: nvl(per_vac_shd.g_old_rec.grade_id,hr_api.g_number) <>
1407: nvl(p_grade_id, hr_api.g_number))

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

1407: nvl(p_grade_id, hr_api.g_number))
1408: or
1409: (NOT l_api_updating)) then
1410: -- --
1411: hr_utility.set_location(l_proc,30);
1412: if (p_grade_id is not null)
1413: then
1414: open csr_grade;
1415: fetch csr_grade into l_date_from,l_date_to;

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

1412: if (p_grade_id is not null)
1413: then
1414: open csr_grade;
1415: fetch csr_grade into l_date_from,l_date_to;
1416: hr_utility.set_location(l_proc,40);
1417: if (csr_grade%notfound)
1418: then
1419: close csr_grade;
1420: fnd_message.set_name('PER','PER_289453_VAC_INV_GRD_ID');

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

1422: (p_associated_column1 => 'PER_ALL_VACANCIES.GRADE_ID'
1423: );
1424: else
1425: close csr_grade;
1426: hr_utility.set_location(l_proc,50);
1427: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1428: then
1429: fnd_message.set_name('PER','PER_289454_VAC_GRD_ID_INV_DATE');
1430: hr_multi_message.add

Line 1439: hr_utility.set_location(' Leaving:'||l_proc,60);

1435: end if;
1436: end if;
1437: end if;
1438: --
1439: hr_utility.set_location(' Leaving:'||l_proc,60);
1440: End chk_grade_id;
1441: --
1442: -- ----------------------------------------------------------------------------
1443: -- |-----------------------------------------------------|

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

1483: where organization_id = p_organization_id
1484: and business_group_id = p_business_group_id;
1485: --
1486: Begin
1487: hr_utility.set_location('Entering:'||l_proc,10);
1488: --
1489: l_api_updating := per_vac_shd.api_updating
1490: (p_vacancy_id => p_vacancy_id
1491: ,p_object_version_number => p_object_version_number);

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

1489: l_api_updating := per_vac_shd.api_updating
1490: (p_vacancy_id => p_vacancy_id
1491: ,p_object_version_number => p_object_version_number);
1492: --
1493: hr_utility.set_location(l_proc,20);
1494: if ((l_api_updating
1495: and
1496: nvl(per_vac_shd.g_old_rec.organization_id,hr_api.g_number) <>
1497: nvl(p_organization_id, hr_api.g_number))

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

1501: if (p_organization_id is not null)
1502: then
1503: open csr_organization;
1504: fetch csr_organization into l_date_from,l_date_to;
1505: hr_utility.set_location(l_proc,30);
1506: if (csr_organization%notfound)
1507: then
1508: close csr_organization;
1509: fnd_message.set_name('PER','PER_289455_VAC_INV_ORG_ID');

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

1511: (p_associated_column1 => 'PER_ALL_VACANCIES.ORGANIZATION_ID'
1512: );
1513: else
1514: close csr_organization;
1515: hr_utility.set_location(l_proc,40);
1516: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1517: then
1518: fnd_message.set_name('PER','PER_289456_VAC_ORG_ID_INV_DATE');
1519: hr_multi_message.add

Line 1527: hr_utility.set_location(' Leaving:'||l_proc,50);

1523: end if;
1524: end if;
1525: end if;
1526: end if;
1527: hr_utility.set_location(' Leaving:'||l_proc,50);
1528: End chk_organization_id;
1529: --
1530: -- ----------------------------------------------------------------------------
1531: -- |-----------------------------------------------------|

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

1568: from pay_people_groups
1569: where people_group_id = p_people_group_id;
1570: --
1571: Begin
1572: hr_utility.set_location('Entering:'||l_proc,10);
1573: --
1574: l_api_updating := per_vac_shd.api_updating
1575: (p_vacancy_id => p_vacancy_id
1576: ,p_object_version_number => p_object_version_number);

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

1574: l_api_updating := per_vac_shd.api_updating
1575: (p_vacancy_id => p_vacancy_id
1576: ,p_object_version_number => p_object_version_number);
1577: --
1578: hr_utility.set_location(l_proc,20);
1579: if ((l_api_updating
1580: and
1581: nvl(per_vac_shd.g_old_rec.people_group_id,hr_api.g_number) <>
1582: nvl(p_people_group_id, hr_api.g_number))

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

1587: then
1588: open csr_peoplegrp;
1589: fetch csr_peoplegrp into l_date_from,l_date_to;
1590: --
1591: hr_utility.set_location(l_proc,20);
1592: if (csr_peoplegrp%notfound)
1593: then
1594: close csr_peoplegrp;
1595: fnd_message.set_name('PER','PER_289457_VAC_INV_GRP_ID');

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

1597: (p_associated_column1 => 'PER_ALL_VACANCIES.PEOPLE_GROUP_ID'
1598: );
1599: else
1600: close csr_peoplegrp;
1601: hr_utility.set_location(l_proc,30);
1602: if (p_effective_date not between l_date_from and nvl(l_date_to,hr_api.g_eot))
1603: then
1604: fnd_message.set_name('PER','PER_289458_VAC_GRP_ID_INV_DATE');
1605: hr_multi_message.add

Line 1613: hr_utility.set_location(' Leaving:'||l_proc,40);

1609: end if;
1610: end if;
1611: end if;
1612: end if;
1613: hr_utility.set_location(' Leaving:'||l_proc,40);
1614: End chk_people_group_id;
1615: --
1616: -- ----------------------------------------------------------------------------
1617: -- |---------------------------------------------------------|

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

1651: from hr_locations_all
1652: where location_id = p_location_id;
1653: --
1654: Begin
1655: hr_utility.set_location('Entering:'||l_proc,10);
1656: --
1657: l_api_updating := per_vac_shd.api_updating
1658: (p_vacancy_id => p_vacancy_id
1659: ,p_object_version_number => p_object_version_number);

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

1657: l_api_updating := per_vac_shd.api_updating
1658: (p_vacancy_id => p_vacancy_id
1659: ,p_object_version_number => p_object_version_number);
1660: --
1661: hr_utility.set_location(l_proc,20);
1662: if ((l_api_updating
1663: and
1664: nvl(per_vac_shd.g_old_rec.location_id,hr_api.g_number) <>
1665: nvl(p_location_id, hr_api.g_number))

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

1669: if (p_location_id is not null)
1670: then
1671: open csr_location;
1672: fetch csr_location into l_location_id;
1673: hr_utility.set_location(l_proc,30);
1674: if (csr_location%notfound)
1675: then
1676: close csr_location;
1677: fnd_message.set_name('PER','PER_289459_VAC_INV_LOCATION_ID');

Line 1683: hr_utility.set_location(' Leaving:'||l_proc,40);

1679: end if;
1680: close csr_location;
1681: end if;
1682: end if;
1683: hr_utility.set_location(' Leaving:'||l_proc,40);
1684: exception
1685: when app_exception.application_exception then
1686: if hr_multi_message.exception_add
1687: (p_associated_column1 => 'PER_ALL_VACANCIES.LOCATION_ID'

Line 1689: hr_utility.set_location(' Leaving:'|| l_proc, 50);

1685: when app_exception.application_exception then
1686: if hr_multi_message.exception_add
1687: (p_associated_column1 => 'PER_ALL_VACANCIES.LOCATION_ID'
1688: ) then
1689: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1690: raise;
1691: end if;
1692: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1693: End chk_location_id;

Line 1692: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1688: ) then
1689: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1690: raise;
1691: end if;
1692: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1693: End chk_location_id;
1694: --
1695: -- ----------------------------------------------------------------------------
1696: -- |--------------------------------------------------------|

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

1745: where person_id = p_recruiter_id
1746: and p_effective_date between effective_start_date and effective_end_date;
1747: --
1748: Begin
1749: hr_utility.set_location('Entering:'||l_proc,10);
1750: --
1751: l_api_updating := per_vac_shd.api_updating
1752: (p_vacancy_id => p_vacancy_id
1753: ,p_object_version_number => p_object_version_number);

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

1751: l_api_updating := per_vac_shd.api_updating
1752: (p_vacancy_id => p_vacancy_id
1753: ,p_object_version_number => p_object_version_number);
1754: --
1755: hr_utility.set_location(l_proc,20);
1756: if ((l_api_updating
1757: and
1758: nvl(per_vac_shd.g_old_rec.recruiter_id,hr_api.g_number) <>
1759: nvl(p_recruiter_id, hr_api.g_number))

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

1763: if (p_recruiter_id is not null)
1764: then
1765: open csr_recruiter1;
1766: fetch csr_recruiter1 into l_recruiter_id;
1767: hr_utility.set_location(l_proc,30);
1768: if (csr_recruiter1%notfound)
1769: then
1770: close csr_recruiter1;
1771: fnd_message.set_name('PER','PER_289460_VAC_INV_REC_ID');

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

1777: --
1778: open csr_recruiter2;
1779: fetch csr_recruiter2 into l_recruiter_id;
1780: --
1781: hr_utility.set_location(l_proc,40);
1782: if (csr_recruiter2%notfound)
1783: then
1784: close csr_recruiter2;
1785: fnd_message.set_name('PER','PER_289461_VAC_REC_ID_INV_DATE');

Line 1796: hr_utility.set_location(' Leaving:'||l_proc,50);

1792: end if;
1793: end if;
1794: end if;
1795: --
1796: hr_utility.set_location(' Leaving:'||l_proc,50);
1797: End chk_recruiter_id;
1798: --
1799: -- ----------------------------------------------------------------------------
1800: -- |-----------------------------------------------|

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

1828: --
1829: l_proc varchar2(72) := g_package || 'chk_number_of_openings';
1830: --
1831: Begin
1832: hr_utility.set_location('Entering:'||l_proc,10);
1833: --
1834: --
1835: hr_utility.set_location(l_proc,30);
1836: if (p_num_open <= 0)

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

1831: Begin
1832: hr_utility.set_location('Entering:'||l_proc,10);
1833: --
1834: --
1835: hr_utility.set_location(l_proc,30);
1836: if (p_num_open <= 0)
1837: then
1838: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1839: fnd_message.raise_error;

Line 1842: hr_utility.set_location(' Leaving:'||l_proc,40);

1838: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1839: fnd_message.raise_error;
1840: end if;
1841: --
1842: hr_utility.set_location(' Leaving:'||l_proc,40);
1843: exception
1844: when app_exception.application_exception then
1845: if hr_multi_message.exception_add
1846: (p_associated_column1 => 'PER_ALL_VACANCIES.NUMBER_OF_OPENINGS'

Line 1848: hr_utility.set_location(' Leaving:'|| l_proc, 50);

1844: when app_exception.application_exception then
1845: if hr_multi_message.exception_add
1846: (p_associated_column1 => 'PER_ALL_VACANCIES.NUMBER_OF_OPENINGS'
1847: ) then
1848: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1849: raise;
1850: end if;
1851: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1852: End chk_number_of_openings;

Line 1851: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1847: ) then
1848: hr_utility.set_location(' Leaving:'|| l_proc, 50);
1849: raise;
1850: end if;
1851: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1852: End chk_number_of_openings;
1853: --
1854: -- ----------------------------------------------------------------------------
1855: -- |--------------------------------------------|

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

1884: --
1885: l_proc varchar2(72) := g_package || 'chk_budget_measurement_value';
1886: --
1887: Begin
1888: hr_utility.set_location('Entering:'||l_proc,10);
1889: --
1890: --
1891: hr_utility.set_location(l_proc,20);
1892: --

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

1887: Begin
1888: hr_utility.set_location('Entering:'||l_proc,10);
1889: --
1890: --
1891: hr_utility.set_location(l_proc,20);
1892: --
1893: hr_utility.set_location(l_proc,20);
1894: if (p_bud_mea_val <= 0)
1895: then

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

1889: --
1890: --
1891: hr_utility.set_location(l_proc,20);
1892: --
1893: hr_utility.set_location(l_proc,20);
1894: if (p_bud_mea_val <= 0)
1895: then
1896: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1897: fnd_message.raise_error;

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

1895: then
1896: fnd_message.set_name('PER','PER_289462_VAC_INV_NO_OF_OPEN');
1897: fnd_message.raise_error;
1898: end if;
1899: hr_utility.set_location(' Leaving:'||l_proc,30);
1900: exception
1901: when app_exception.application_exception then
1902: if hr_multi_message.exception_add
1903: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_VALUE'

Line 1905: hr_utility.set_location(' Leaving:'|| l_proc, 60);

1901: when app_exception.application_exception then
1902: if hr_multi_message.exception_add
1903: (p_associated_column1 => 'PER_ALL_VACANCIES.BUDGET_MEASUREMENT_VALUE'
1904: ) then
1905: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1906: raise;
1907: end if;
1908: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1909: End chk_budget_measurement_value;

Line 1908: hr_utility.set_location(' Leaving:'|| l_proc, 70);

1904: ) then
1905: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1906: raise;
1907: end if;
1908: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1909: End chk_budget_measurement_value;
1910: --
1911: -- ----------------------------------------------------------------------------
1912: -- |---------------------------< chk_manager_id >-----------------------------|

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

1960: where person_id = p_manager_id
1961: and p_effective_date between effective_start_date and effective_end_date;
1962: --
1963: Begin
1964: hr_utility.set_location('Entering:'||l_proc,10);
1965: --
1966: l_api_updating := per_vac_shd.api_updating
1967: (p_vacancy_id => p_vacancy_id
1968: ,p_object_version_number => p_object_version_number);

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

1966: l_api_updating := per_vac_shd.api_updating
1967: (p_vacancy_id => p_vacancy_id
1968: ,p_object_version_number => p_object_version_number);
1969: --
1970: hr_utility.set_location(l_proc,20);
1971: if ((l_api_updating
1972: and
1973: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
1974: nvl(p_manager_id, hr_api.g_number))

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

1978: if (p_manager_id is not null)
1979: then
1980: open csr_manager1;
1981: fetch csr_manager1 into l_manager_id;
1982: hr_utility.set_location(l_proc,20);
1983: if (csr_manager1%notfound)
1984: then
1985: close csr_manager1;
1986: fnd_message.set_name('PER','PER_289464_VAC_INV_MGR_ID');

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

1991: close csr_manager1;
1992: --
1993: open csr_manager2;
1994: fetch csr_manager2 into l_manager_id;
1995: hr_utility.set_location(l_proc,30);
1996: if (csr_manager2%notfound)
1997: then
1998: close csr_manager2;
1999: fnd_message.set_name('PER','PER_289465_VAC_MGR_ID_INV_DATE');

Line 2010: hr_utility.set_location(' Leaving:'||l_proc,40);

2006: end if;
2007: end if;
2008: end if;
2009: --
2010: hr_utility.set_location(' Leaving:'||l_proc,40);
2011: End chk_manager_id;
2012: --
2013: -- ----------------------------------------------------------------------------
2014: -- |---------------------------< chk_manager_assignment_id >-----------------------------|

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

2057: where ppf.person_id = p_manager_id
2058: and p_effective_date between ppf.effective_start_date and ppf.effective_end_date);
2059: --
2060: Begin
2061: hr_utility.set_location('Entering:'||l_proc,10);
2062: --
2063: l_api_updating := per_vac_shd.api_updating
2064: (p_vacancy_id => p_vacancy_id
2065: ,p_object_version_number => p_object_version_number);

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

2063: l_api_updating := per_vac_shd.api_updating
2064: (p_vacancy_id => p_vacancy_id
2065: ,p_object_version_number => p_object_version_number);
2066: --
2067: hr_utility.set_location(l_proc,20);
2068: if ((l_api_updating
2069: and
2070: nvl(per_vac_shd.g_old_rec.manager_id,hr_api.g_number) <>
2071: nvl(p_manager_id, hr_api.g_number))

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

2078: -- Check that the manager is not existing applicant for the same vacancy.
2079: --
2080: open csr_manager;
2081: fetch csr_manager into l_exists;
2082: hr_utility.set_location(l_proc,30);
2083: if (csr_manager%found)
2084: then
2085: close csr_manager;
2086: fnd_message.set_name('PER','IRC_VAC_MGR_EQUAL_APPL');

Line 2096: hr_utility.set_location(' Leaving:'||l_proc,40);

2092: end if;
2093: end if;
2094: end if;
2095: --
2096: hr_utility.set_location(' Leaving:'||l_proc,40);
2097: End chk_manager_assignment_id;
2098:
2099: --
2100: -- ----------------------------------------------------------------------------

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

2137: from irc_posting_contents
2138: where posting_content_id = p_primary_posting_id;
2139: --
2140: Begin
2141: hr_utility.set_location('Entering:'||l_proc,10);
2142: --
2143: l_api_updating := per_vac_shd.api_updating
2144: (p_vacancy_id => p_vacancy_id
2145: ,p_object_version_number => p_object_version_number);

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

2143: l_api_updating := per_vac_shd.api_updating
2144: (p_vacancy_id => p_vacancy_id
2145: ,p_object_version_number => p_object_version_number);
2146: --
2147: hr_utility.set_location(l_proc,20);
2148: if ((l_api_updating
2149: and
2150: nvl(per_vac_shd.g_old_rec.primary_posting_id,hr_api.g_number) <>
2151: nvl(p_primary_posting_id, hr_api.g_number))

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

2155: if (p_primary_posting_id is not null)
2156: then
2157: open csr_posting_contents;
2158: fetch csr_posting_contents into l_primary_posting;
2159: hr_utility.set_location(l_proc,30);
2160: if (csr_posting_contents%notfound)
2161: then
2162: close csr_posting_contents;
2163: fnd_message.set_name('PER','PER_449565_VAC_INV_POSTING_ID');

Line 2173: hr_utility.set_location(' Leaving:'||l_proc,40);

2169: end if;
2170: end if;
2171: end if;
2172: --
2173: hr_utility.set_location(' Leaving:'||l_proc,40);
2174: End chk_primary_posting_id;
2175: --
2176: -- ----------------------------------------------------------------------------
2177: -- |-------------------------------------------------------|

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

2214: where data_source='OIR'
2215: and test_id = p_assessment_id;
2216: --
2217: Begin
2218: hr_utility.set_location('Entering:'||l_proc,10);
2219: --
2220: l_api_updating := per_vac_shd.api_updating
2221: (p_vacancy_id => p_vacancy_id
2222: ,p_object_version_number => p_object_version_number);

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

2220: l_api_updating := per_vac_shd.api_updating
2221: (p_vacancy_id => p_vacancy_id
2222: ,p_object_version_number => p_object_version_number);
2223: --
2224: hr_utility.set_location(l_proc,20);
2225: if ((l_api_updating
2226: and
2227: nvl(per_vac_shd.g_old_rec.assessment_id,hr_api.g_number) <>
2228: nvl(p_assessment_id, hr_api.g_number))

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

2232: if (p_assessment_id is not null)
2233: then
2234: open csr_assessments;
2235: fetch csr_assessments into l_assessment;
2236: hr_utility.set_location(l_proc,30);
2237: if (csr_assessments%notfound)
2238: then
2239: close csr_assessments;
2240: fnd_message.set_name('PER','PER_449566_VAC_INV_ASSESS_ID');

Line 2250: hr_utility.set_location(' Leaving:'||l_proc,40);

2246: end if;
2247: end if;
2248: end if;
2249: --
2250: hr_utility.set_location(' Leaving:'||l_proc,40);
2251: End chk_assessment_id;
2252: --
2253: -- ----------------------------------------------------------------------------
2254: -- |---------------------------< insert_validate >----------------------------|

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

2264: l_inv_job_grade_warning boolean;
2265: l_inv_pos_grade_warning boolean;
2266: --
2267: Begin
2268: hr_utility.set_location('Entering:'||l_proc, 5);
2269: --
2270: -- Call all supporting business operations
2271: --
2272: hr_api.validate_bus_grp_id(p_rec.business_group_id

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

2271: --
2272: hr_api.validate_bus_grp_id(p_rec.business_group_id
2273: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2274: --
2275: hr_utility.set_location(l_proc, 10);
2276: --
2277: chk_vacancy_dates
2278: (p_vacancy_id => p_rec.vacancy_id
2279: ,p_object_version_number => p_rec.object_version_number

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

2282: );
2283: --
2284: hr_multi_message.end_validation_set();
2285: --
2286: hr_utility.set_location(l_proc, 20);
2287: --
2288: chk_name
2289: (p_name => p_rec.name
2290: ,p_business_group_id => p_rec.business_group_id

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

2289: (p_name => p_rec.name
2290: ,p_business_group_id => p_rec.business_group_id
2291: );
2292: --
2293: hr_utility.set_location(l_proc, 30);
2294: --
2295: chk_status
2296: (p_vacancy_id => p_rec.vacancy_id
2297: ,p_object_version_number => p_rec.object_version_number

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

2298: ,p_status => p_rec.status
2299: ,p_effective_date => p_effective_date
2300: );
2301: --
2302: hr_utility.set_location(l_proc, 40);
2303: --
2304: chk_budget_measurement_type
2305: (p_vacancy_id => p_rec.vacancy_id
2306: ,p_object_version_number => p_rec.object_version_number

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

2307: ,p_budget_measurement_type => p_rec.budget_measurement_type
2308: ,p_effective_date => p_effective_date
2309: );
2310: --
2311: hr_utility.set_location(l_proc, 50);
2312: --
2313: chk_security_method
2314: (p_vacancy_id => p_rec.vacancy_id
2315: ,p_object_version_number => p_rec.object_version_number

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

2316: ,p_security_method => p_rec.security_method
2317: ,p_effective_date => p_effective_date
2318: );
2319: --
2320: hr_utility.set_location(l_proc, 60);
2321: --
2322: chk_requisition_id
2323: (p_requisition_id => p_rec.requisition_id
2324: ,p_date_from => p_rec.date_from

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

2324: ,p_date_from => p_rec.date_from
2325: ,p_business_group_id => p_rec.business_group_id
2326: );
2327: --
2328: hr_utility.set_location(l_proc, 70);
2329: --
2330: chk_organization_id
2331: (p_vacancy_id => p_rec.vacancy_id
2332: ,p_object_version_number => p_rec.object_version_number

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

2334: ,p_effective_date => p_effective_date
2335: ,p_business_group_id => p_rec.business_group_id
2336: );
2337: --
2338: hr_utility.set_location(l_proc, 80);
2339: --
2340: chk_job_id
2341: (p_vacancy_id => p_rec.vacancy_id
2342: ,p_object_version_number => p_rec.object_version_number

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

2344: ,p_effective_date => p_effective_date
2345: ,p_business_group_id => p_rec.business_group_id
2346: );
2347: --
2348: hr_utility.set_location(l_proc, 90);
2349: --
2350: chk_position_id
2351: (p_vacancy_id => p_rec.vacancy_id
2352: ,p_object_version_number => p_rec.object_version_number

Line 2358: hr_utility.set_location(l_proc, 100);

2354: ,p_business_group_id => p_rec.business_group_id
2355: ,p_effective_date => p_effective_date
2356: );
2357: --
2358: hr_utility.set_location(l_proc, 100);
2359: --
2360: chk_position_id_org_id
2361: (p_vacancy_id => p_rec.vacancy_id
2362: ,p_object_version_number => p_rec.object_version_number

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

2364: ,p_organization_id => p_rec.organization_id
2365: ,p_effective_date => p_effective_date
2366: );
2367: --
2368: hr_utility.set_location(l_proc, 110);
2369: --
2370: chk_position_id_job_id
2371: (p_vacancy_id => p_rec.vacancy_id
2372: ,p_object_version_number => p_rec.object_version_number

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

2374: ,p_job_id => p_rec.job_id
2375: ,p_effective_date => p_effective_date
2376: );
2377: --
2378: hr_utility.set_location(l_proc, 120);
2379: --
2380: chk_grade_id
2381: (p_vacancy_id => p_rec.vacancy_id
2382: ,p_object_version_number => p_rec.object_version_number

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

2384: ,p_effective_date => p_effective_date
2385: ,p_business_group_id => p_rec.business_group_id
2386: );
2387: --
2388: hr_utility.set_location(l_proc, 130);
2389: --
2390: chk_position_id_grade_id
2391: (p_vacancy_id => p_rec.vacancy_id
2392: ,p_object_version_number => p_rec.object_version_number

Line 2399: hr_utility.set_location(l_proc, 140);

2395: ,p_effective_date => p_effective_date
2396: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
2397: );
2398: --
2399: hr_utility.set_location(l_proc, 140);
2400: --
2401: per_vac_bus.chk_job_id_grade_id
2402: (p_vacancy_id => p_rec.vacancy_id
2403: ,p_job_id => p_rec.job_id

Line 2410: hr_utility.set_location(l_proc, 150);

2406: ,p_object_version_number => p_rec.object_version_number
2407: ,p_inv_job_grade_warning => l_inv_job_grade_warning
2408: );
2409: --
2410: hr_utility.set_location(l_proc, 150);
2411: --
2412: chk_people_group_id
2413: (p_vacancy_id => p_rec.vacancy_id
2414: ,p_object_version_number => p_rec.object_version_number

Line 2419: hr_utility.set_location(l_proc, 160);

2415: ,p_people_group_id => p_rec.people_group_id
2416: ,p_effective_date => p_effective_date
2417: );
2418: --
2419: hr_utility.set_location(l_proc, 160);
2420: --
2421: chk_location_id
2422: (p_vacancy_id => p_rec.vacancy_id
2423: ,p_object_version_number => p_rec.object_version_number

Line 2427: hr_utility.set_location(l_proc, 170);

2423: ,p_object_version_number => p_rec.object_version_number
2424: ,p_location_id => p_rec.location_id
2425: );
2426: --
2427: hr_utility.set_location(l_proc, 170);
2428: --
2429: chk_recruiter_id
2430: (p_vacancy_id => p_rec.vacancy_id
2431: ,p_object_version_number => p_rec.object_version_number

Line 2437: hr_utility.set_location(l_proc, 180);

2433: ,p_business_group_id => p_rec.business_group_id
2434: ,p_effective_date => p_effective_date
2435: );
2436: --
2437: hr_utility.set_location(l_proc, 180);
2438: --
2439: chk_number_of_openings
2440: (p_vacancy_id => p_rec.vacancy_id
2441: ,p_object_version_number => p_rec.object_version_number

Line 2445: hr_utility.set_location(l_proc, 190);

2441: ,p_object_version_number => p_rec.object_version_number
2442: ,p_num_open => p_rec.number_of_openings
2443: );
2444: --
2445: hr_utility.set_location(l_proc, 190);
2446: --
2447: chk_budget_measurement_value
2448: (p_vacancy_id => p_rec.vacancy_id
2449: ,p_object_version_number => p_rec.object_version_number

Line 2453: hr_utility.set_location(l_proc, 200);

2449: ,p_object_version_number => p_rec.object_version_number
2450: ,p_bud_mea_val => p_rec.budget_measurement_value
2451: );
2452: --
2453: hr_utility.set_location(l_proc, 200);
2454: --
2455: chk_manager_id
2456: (p_vacancy_id => p_rec.vacancy_id
2457: ,p_object_version_number => p_rec.object_version_number

Line 2463: hr_utility.set_location(l_proc, 210);

2459: ,p_effective_date => p_effective_date
2460: ,p_business_group_id => p_rec.business_group_id
2461: );
2462: --
2463: hr_utility.set_location(l_proc, 210);
2464: --
2465: chk_primary_posting_id
2466: (p_vacancy_id => p_rec.vacancy_id
2467: ,p_object_version_number => p_rec.object_version_number

Line 2471: hr_utility.set_location(l_proc, 220);

2467: ,p_object_version_number => p_rec.object_version_number
2468: ,p_primary_posting_id => p_rec.primary_posting_id
2469: );
2470: --
2471: hr_utility.set_location(l_proc, 220);
2472: --
2473: chk_assessment_id
2474: (p_vacancy_id => p_rec.vacancy_id
2475: ,p_object_version_number => p_rec.object_version_number

Line 2479: hr_utility.set_location(l_proc, 230);

2475: ,p_object_version_number => p_rec.object_version_number
2476: ,p_assessment_id => p_rec.assessment_id
2477: );
2478: --
2479: hr_utility.set_location(l_proc, 230);
2480: --
2481: per_vac_bus.chk_df(p_rec);
2482: --
2483: hr_utility.set_location(l_proc, 240);

Line 2483: hr_utility.set_location(l_proc, 240);

2479: hr_utility.set_location(l_proc, 230);
2480: --
2481: per_vac_bus.chk_df(p_rec);
2482: --
2483: hr_utility.set_location(l_proc, 240);
2484: --
2485: p_inv_job_grade_warning:=l_inv_job_grade_warning;
2486: p_inv_pos_grade_warning:=l_inv_pos_grade_warning;
2487: --

Line 2488: hr_utility.set_location(' Leaving:'||l_proc, 250);

2484: --
2485: p_inv_job_grade_warning:=l_inv_job_grade_warning;
2486: p_inv_pos_grade_warning:=l_inv_pos_grade_warning;
2487: --
2488: hr_utility.set_location(' Leaving:'||l_proc, 250);
2489: End insert_validate;
2490: --
2491: -- ----------------------------------------------------------------------------
2492: -- |---------------------------< update_validate >----------------------------|

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

2502: l_inv_job_grade_warning boolean;
2503: l_inv_pos_grade_warning boolean;
2504: --
2505: Begin
2506: hr_utility.set_location('Entering:'||l_proc, 10);
2507: --
2508: -- Call all supporting business operations
2509: --
2510: --

Line 2511: hr_utility.set_location(l_proc, 190);

2507: --
2508: -- Call all supporting business operations
2509: --
2510: --
2511: hr_utility.set_location(l_proc, 190);
2512: --
2513: chk_non_updateable_args
2514: (p_rec => p_rec
2515: );

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

2517: --
2518: hr_api.validate_bus_grp_id(p_rec.business_group_id
2519: ,p_associated_column1 => per_vac_shd.g_tab_name||'.BUSINESS_GROUP_ID');
2520: --
2521: hr_utility.set_location(l_proc, 20);
2522: --
2523: chk_vacancy_dates
2524: (p_vacancy_id => p_rec.vacancy_id
2525: ,p_object_version_number => p_rec.object_version_number

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

2526: ,p_date_from => p_rec.date_from
2527: ,p_date_to => p_rec.date_to
2528: );
2529: --
2530: hr_utility.set_location(l_proc, 30);
2531: --
2532: chk_status
2533: (p_vacancy_id => p_rec.vacancy_id
2534: ,p_object_version_number => p_rec.object_version_number

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

2535: ,p_status => p_rec.status
2536: ,p_effective_date => p_effective_date
2537: );
2538: --
2539: hr_utility.set_location(l_proc, 40);
2540: --
2541: chk_budget_measurement_type
2542: (p_vacancy_id => p_rec.vacancy_id
2543: ,p_object_version_number => p_rec.object_version_number

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

2544: ,p_budget_measurement_type => p_rec.budget_measurement_type
2545: ,p_effective_date => p_effective_date
2546: );
2547: --
2548: hr_utility.set_location(l_proc, 50);
2549: --
2550: chk_organization_id
2551: (p_vacancy_id => p_rec.vacancy_id
2552: ,p_object_version_number => p_rec.object_version_number

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

2554: ,p_effective_date => p_effective_date
2555: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2556: );
2557: --
2558: hr_utility.set_location(l_proc, 60);
2559: --
2560: chk_job_id
2561: (p_vacancy_id => p_rec.vacancy_id
2562: ,p_object_version_number => p_rec.object_version_number

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

2564: ,p_effective_date => p_effective_date
2565: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2566: );
2567: --
2568: hr_utility.set_location(l_proc, 70);
2569: --
2570: chk_position_id
2571: (p_vacancy_id => p_rec.vacancy_id
2572: ,p_object_version_number => p_rec.object_version_number

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

2574: ,p_business_group_id => p_rec.business_group_id
2575: ,p_effective_date => p_effective_date
2576: );
2577: --
2578: hr_utility.set_location(l_proc, 80);
2579: --
2580: chk_position_id_org_id
2581: (p_vacancy_id => p_rec.vacancy_id
2582: ,p_object_version_number => p_rec.object_version_number

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

2584: ,p_organization_id => p_rec.organization_id
2585: ,p_effective_date => p_effective_date
2586: );
2587: --
2588: hr_utility.set_location(l_proc, 90);
2589: --
2590: chk_position_id_job_id
2591: (p_vacancy_id => p_rec.vacancy_id
2592: ,p_object_version_number => p_rec.object_version_number

Line 2598: hr_utility.set_location(l_proc, 100);

2594: ,p_job_id => p_rec.job_id
2595: ,p_effective_date => p_effective_date
2596: );
2597: --
2598: hr_utility.set_location(l_proc, 100);
2599: --
2600: chk_grade_id
2601: (p_vacancy_id => p_rec.vacancy_id
2602: ,p_object_version_number => p_rec.object_version_number

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

2604: ,p_effective_date => p_effective_date
2605: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2606: );
2607: --
2608: hr_utility.set_location(l_proc, 110);
2609: --
2610: chk_position_id_grade_id
2611: (p_vacancy_id => p_rec.vacancy_id
2612: ,p_object_version_number => p_rec.object_version_number

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

2615: ,p_effective_date => p_effective_date
2616: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
2617: );
2618: --
2619: hr_utility.set_location(l_proc, 120);
2620: --
2621: per_vac_bus.chk_job_id_grade_id
2622: (p_vacancy_id => p_rec.vacancy_id
2623: ,p_job_id => p_rec.job_id

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

2626: ,p_object_version_number => p_rec.object_version_number
2627: ,p_inv_job_grade_warning => l_inv_job_grade_warning
2628: );
2629: --
2630: hr_utility.set_location(l_proc, 130);
2631: --
2632: chk_people_group_id
2633: (p_vacancy_id => p_rec.vacancy_id
2634: ,p_object_version_number => p_rec.object_version_number

Line 2639: hr_utility.set_location(l_proc, 140);

2635: ,p_people_group_id => p_rec.people_group_id
2636: ,p_effective_date => p_effective_date
2637: );
2638: --
2639: hr_utility.set_location(l_proc, 140);
2640: --
2641: chk_location_id
2642: (p_vacancy_id => p_rec.vacancy_id
2643: ,p_object_version_number => p_rec.object_version_number

Line 2647: hr_utility.set_location(l_proc, 150);

2643: ,p_object_version_number => p_rec.object_version_number
2644: ,p_location_id => p_rec.location_id
2645: );
2646: --
2647: hr_utility.set_location(l_proc, 150);
2648: --
2649: chk_recruiter_id
2650: (p_vacancy_id => p_rec.vacancy_id
2651: ,p_object_version_number => p_rec.object_version_number

Line 2657: hr_utility.set_location(l_proc, 160);

2653: ,p_effective_date => p_effective_date
2654: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2655: );
2656: --
2657: hr_utility.set_location(l_proc, 160);
2658: --
2659: chk_number_of_openings
2660: (p_vacancy_id => p_rec.vacancy_id
2661: ,p_object_version_number => p_rec.object_version_number

Line 2665: hr_utility.set_location(l_proc, 170);

2661: ,p_object_version_number => p_rec.object_version_number
2662: ,p_num_open => p_rec.number_of_openings
2663: );
2664: --
2665: hr_utility.set_location(l_proc, 170);
2666: --
2667: chk_budget_measurement_value
2668: (p_vacancy_id => p_rec.vacancy_id
2669: ,p_object_version_number => p_rec.object_version_number

Line 2673: hr_utility.set_location(l_proc, 180);

2669: ,p_object_version_number => p_rec.object_version_number
2670: ,p_bud_mea_val => p_rec.budget_measurement_value
2671: );
2672: --
2673: hr_utility.set_location(l_proc, 180);
2674: --
2675: chk_manager_id
2676: (p_vacancy_id => p_rec.vacancy_id
2677: ,p_object_version_number => p_rec.object_version_number

Line 2683: hr_utility.set_location(l_proc, 190);

2679: ,p_effective_date => p_effective_date
2680: ,p_business_group_id => per_vac_shd.g_old_rec.business_group_id
2681: );
2682: --
2683: hr_utility.set_location(l_proc, 190);
2684: --
2685: chk_manager_assignment_id
2686: (p_vacancy_id => p_rec.vacancy_id
2687: ,p_object_version_number => p_rec.object_version_number

Line 2692: hr_utility.set_location(l_proc, 200);

2688: ,p_manager_id => p_rec.manager_id
2689: ,p_effective_date => p_effective_date
2690: );
2691: --
2692: hr_utility.set_location(l_proc, 200);
2693: --
2694: chk_primary_posting_id
2695: (p_vacancy_id => p_rec.vacancy_id
2696: ,p_object_version_number => p_rec.object_version_number

Line 2700: hr_utility.set_location(l_proc, 210);

2696: ,p_object_version_number => p_rec.object_version_number
2697: ,p_primary_posting_id => p_rec.primary_posting_id
2698: );
2699: --
2700: hr_utility.set_location(l_proc, 210);
2701: --
2702: chk_assessment_id
2703: (p_vacancy_id => p_rec.vacancy_id
2704: ,p_object_version_number => p_rec.object_version_number

Line 2708: hr_utility.set_location(l_proc, 220);

2704: ,p_object_version_number => p_rec.object_version_number
2705: ,p_assessment_id => p_rec.assessment_id
2706: );
2707: --
2708: hr_utility.set_location(l_proc, 220);
2709: --
2710: per_vac_bus.chk_df(p_rec);
2711: --
2712: p_inv_job_grade_warning:=l_inv_job_grade_warning;

Line 2715: hr_utility.set_location(' Leaving:'||l_proc, 230);

2711: --
2712: p_inv_job_grade_warning:=l_inv_job_grade_warning;
2713: p_inv_pos_grade_warning:=l_inv_pos_grade_warning;
2714: --
2715: hr_utility.set_location(' Leaving:'||l_proc, 230);
2716: End update_validate;
2717: --
2718: -- ----------------------------------------------------------------------------
2719: -- |---------------------------< delete_validate >----------------------------|

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

2724: --
2725: l_proc varchar2(72) := g_package||'delete_validate';
2726: --
2727: Begin
2728: hr_utility.set_location('Entering:'||l_proc, 5);
2729: --
2730: -- Call all supporting business operations
2731: --
2732: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2728: hr_utility.set_location('Entering:'||l_proc, 5);
2729: --
2730: -- Call all supporting business operations
2731: --
2732: hr_utility.set_location(' Leaving:'||l_proc, 10);
2733: End delete_validate;
2734: --
2735: end per_vac_bus;