DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on APP_EXCEPTION

Line 1158: when app_exception.application_exception then

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

Line 1251: when app_exception.application_exception then

1247: --
1248: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1249: --
1250: exception
1251: when app_exception.application_exception then
1252: if hr_multi_message.exception_add
1253: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1254: ,p_associated_column2 =>
1255: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

Line 1468: when app_exception.application_exception then

1464: close csr_get_bus_grp;
1465: --
1466: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1467: exception
1468: when app_exception.application_exception then
1469: if hr_multi_message.exception_add
1470: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1471: ) then
1472: hr_utility.set_location(' Leaving:'|| l_proc, 4);

Line 2020: when app_exception.application_exception then

2016: end if;
2017: --
2018: hr_utility.set_location('Leaving'||l_proc, 4);
2019: exception
2020: when app_exception.application_exception then
2021: if hr_multi_message.exception_add
2022: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
2023: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
2024: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

Line 2614: when app_exception.application_exception then

2610: --
2611: end if;
2612: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2613: exception
2614: when app_exception.application_exception then
2615: if hr_multi_message.exception_add
2616: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2617: ) then
2618: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2714: when app_exception.application_exception then

2710: end if;
2711: --
2712: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2713: exception
2714: when app_exception.application_exception then
2715: if hr_multi_message.exception_add
2716: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2717: ) then
2718: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2797: when app_exception.application_exception then

2793: end if;
2794: --
2795: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2796: exception
2797: when app_exception.application_exception then
2798: if hr_multi_message.exception_add
2799: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2800: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2801: ) then

Line 3604: when app_exception.application_exception then

3600: end if;
3601: --
3602: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3603: exception
3604: when app_exception.application_exception then
3605: if hr_multi_message.exception_add
3606: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3607: ) then
3608: hr_utility.set_location(' Leaving:'|| l_proc, 6);

Line 3690: when app_exception.application_exception then

3686: end if;
3687: --
3688: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3689: exception
3690: when app_exception.application_exception then
3691: if hr_multi_message.exception_add
3692: (p_associated_column1 =>
3693: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3694: ,p_associated_column2 =>

Line 3812: when app_exception.application_exception then

3808: --
3809: end if;
3810: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3811: exception
3812: when app_exception.application_exception then
3813: if hr_multi_message.exception_add
3814: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3815: ) then
3816: hr_utility.set_location(' Leaving:'|| l_proc, 110);

Line 4995: when app_exception.application_exception then

4991: end if;
4992: hr_utility.set_location(' Leaving:'|| l_proc, 4);
4993: --
4994: exception
4995: when app_exception.application_exception then
4996: if hr_multi_message.exception_add
4997: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4998: ) then
4999: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 5113: when app_exception.application_exception then

5109: end if;
5110: --
5111: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5112: exception
5113: when app_exception.application_exception then
5114: if hr_multi_message.exception_add
5115: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5116: ) then
5117: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 5165: when app_exception.application_exception then

5161: end if;
5162: --
5163: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5164: exception
5165: when app_exception.application_exception then
5166: if hr_multi_message.exception_add
5167: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5168: ) then
5169: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 5373: when app_exception.application_exception then

5369:
5370: end if;
5371:
5372: exception
5373: when app_exception.application_exception then
5374: if hr_multi_message.exception_add
5375: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5376: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5377: ) then

Line 5871: when app_exception.application_exception then

5867: end if;
5868: --
5869: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5870: exception
5871: when app_exception.application_exception then
5872: if hr_multi_message.exception_add
5873: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5874: ) then
5875: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 5963: when app_exception.application_exception then

5959: --
5960: end if;
5961: hr_utility.set_location('Leaving:'|| l_proc, 70);
5962: exception
5963: when app_exception.application_exception then
5964: if hr_multi_message.exception_add
5965: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5966: ) then
5967: raise;

Line 6063: when app_exception.application_exception then

6059: --
6060: end if;
6061: hr_utility.set_location('Leaving: '||l_proc, 50);
6062: exception
6063: when app_exception.application_exception then
6064: if hr_multi_message.exception_add
6065: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
6066: ) then
6067: raise;