DBA Data[Home] [Help]

APPS.PER_ASG_BUS2 dependencies on APP_EXCEPTION

Line 1118: when app_exception.application_exception then

1114: end if;
1115: --
1116: hr_utility.set_location(' Leaving:'|| l_proc, 5);
1117: exception
1118: when app_exception.application_exception then
1119: if hr_multi_message.exception_add
1120: (p_associated_column1 =>
1121: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1122: ) then

Line 1211: when app_exception.application_exception then

1207: --
1208: hr_utility.set_location(' Leaving:'|| l_proc, 4);
1209: --
1210: exception
1211: when app_exception.application_exception then
1212: if hr_multi_message.exception_add
1213: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD'
1214: ,p_associated_column2 =>
1215: 'PER_ALL_ASSIGNMENTS_F.PERF_REVIEW_PERIOD_FREQUENCY'

Line 1428: when app_exception.application_exception then

1424: close csr_get_bus_grp;
1425: --
1426: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1427: exception
1428: when app_exception.application_exception then
1429: if hr_multi_message.exception_add
1430: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
1431: ) then
1432: hr_utility.set_location(' Leaving:'|| l_proc, 4);

Line 1980: when app_exception.application_exception then

1976: end if;
1977: --
1978: hr_utility.set_location('Leaving'||l_proc, 4);
1979: exception
1980: when app_exception.application_exception then
1981: if hr_multi_message.exception_add
1982: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSITION_ID'
1983: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.ORGANIZATION_ID'
1984: ,p_associated_column3 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'

Line 2574: when app_exception.application_exception then

2570: --
2571: end if;
2572: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2573: exception
2574: when app_exception.application_exception then
2575: if hr_multi_message.exception_add
2576: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2577: ) then
2578: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2674: when app_exception.application_exception then

2670: end if;
2671: --
2672: hr_utility.set_location(' Leaving:'|| l_proc, 60);
2673: exception
2674: when app_exception.application_exception then
2675: if hr_multi_message.exception_add
2676: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2677: ) then
2678: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 2757: when app_exception.application_exception then

2753: end if;
2754: --
2755: hr_utility.set_location(' Leaving:'|| l_proc, 4);
2756: exception
2757: when app_exception.application_exception then
2758: if hr_multi_message.exception_add
2759: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_UNIT'
2760: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.PROBATION_PERIOD'
2761: ) then

Line 3564: when app_exception.application_exception then

3560: end if;
3561: --
3562: hr_utility.set_location(' Leaving:'|| l_proc, 5);
3563: exception
3564: when app_exception.application_exception then
3565: if hr_multi_message.exception_add
3566: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3567: ) then
3568: hr_utility.set_location(' Leaving:'|| l_proc, 6);

Line 3650: when app_exception.application_exception then

3646: end if;
3647: --
3648: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3649: exception
3650: when app_exception.application_exception then
3651: if hr_multi_message.exception_add
3652: (p_associated_column1 =>
3653: 'PER_ALL_ASSIGNMENTS_F.SAL_REVIEW_PERIOD'
3654: ,p_associated_column2 =>

Line 3772: when app_exception.application_exception then

3768: --
3769: end if;
3770: hr_utility.set_location(' Leaving:'|| l_proc, 100);
3771: exception
3772: when app_exception.application_exception then
3773: if hr_multi_message.exception_add
3774: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.SET_OF_BOOKS_ID'
3775: ) then
3776: hr_utility.set_location(' Leaving:'|| l_proc, 110);

Line 4917: when app_exception.application_exception then

4913: end if;
4914: hr_utility.set_location(' Leaving:'|| l_proc, 4);
4915: --
4916: exception
4917: when app_exception.application_exception then
4918: if hr_multi_message.exception_add
4919: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.PERSON_ID'
4920: ) then
4921: hr_utility.set_location(' Leaving:'|| l_proc, 5);

Line 5035: when app_exception.application_exception then

5031: end if;
5032: --
5033: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5034: exception
5035: when app_exception.application_exception then
5036: if hr_multi_message.exception_add
5037: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_FINISH'
5038: ) then
5039: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 5087: when app_exception.application_exception then

5083: end if;
5084: --
5085: hr_utility.set_location(' Leaving:'|| l_proc, 2);
5086: exception
5087: when app_exception.application_exception then
5088: if hr_multi_message.exception_add
5089: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.TIME_NORMAL_START'
5090: ) then
5091: hr_utility.set_location(' Leaving:'|| l_proc, 3);

Line 5167: when app_exception.application_exception then

5163: hr_utility.set_location(l_proc, 20);
5164: --
5165: end if;
5166: exception
5167: when app_exception.application_exception then
5168: if hr_multi_message.exception_add
5169: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.VACANCY_ID'
5170: ,p_associated_column2 => 'PER_ALL_ASSIGNMENTS_F.EFFECTIVE_START_DATE'
5171: ) then

Line 5666: when app_exception.application_exception then

5662: end if;
5663: --
5664: hr_utility.set_location(' Leaving:'|| l_proc, 60);
5665: exception
5666: when app_exception.application_exception then
5667: if hr_multi_message.exception_add
5668: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.INTERNAL_ADDRESS_LINE'
5669: ) then
5670: hr_utility.set_location(' Leaving:'|| l_proc, 70);

Line 5758: when app_exception.application_exception then

5754: --
5755: end if;
5756: hr_utility.set_location('Leaving:'|| l_proc, 70);
5757: exception
5758: when app_exception.application_exception then
5759: if hr_multi_message.exception_add
5760: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.APPLICANT_RANK'
5761: ) then
5762: raise;

Line 5858: when app_exception.application_exception then

5854: --
5855: end if;
5856: hr_utility.set_location('Leaving: '||l_proc, 50);
5857: exception
5858: when app_exception.application_exception then
5859: if hr_multi_message.exception_add
5860: (p_associated_column1 => 'PER_ALL_ASSIGNMENTS_F.POSTING_CONTENT_ID'
5861: ) then
5862: raise;