[Home] [Help]
178: hr_utility.set_location(' Leaving '||l_proc, 5);
179: end if;
180: return g_previous_sys_per_type;
181: exception
182: when app_exception.application_exception then
183: if hr_multi_message.exception_add
184: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
185: ) then
186: if g_debug then
724: if g_debug then
725: hr_utility.set_location(' Leaving:'|| l_proc, 13);
726: end if;
727: exception
728: when app_exception.application_exception then
729: if hr_multi_message.exception_add
730: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
731: ) then
732: if g_debug then
990: if g_debug then
991: hr_utility.set_location(' Leaving:'|| l_proc, 8);
992: end if;
993: exception
994: when app_exception.application_exception then
995: If not l_dob_st then
996: if hr_multi_message.exception_add
997: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
998: ) then
1148: if g_debug then
1149: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1150: end if;
1151: exception
1152: when app_exception.application_exception then
1153: if hr_multi_message.exception_add
1154: (p_associated_column1 => 'PER_ALL_PEOPLE_F.MARITAL_STATUS'
1155: ) then
1156: if g_debug then
1272: if g_debug then
1273: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1274: end if;
1275: exception
1276: when app_exception.application_exception then
1277: if hr_multi_message.exception_add
1278: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PARTY_ID'
1279: ) then
1280: if g_debug then
1415: if g_debug then
1416: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1417: end if;
1418: exception
1419: when app_exception.application_exception then
1420: if hr_multi_message.exception_add
1421: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONALITY'
1422: ) then
1423: if g_debug then
1617: if g_debug then
1618: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1619: end if;
1620: exception
1621: when app_exception.application_exception then
1622: if hr_multi_message.exception_add
1623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1624: ) then
1625: if g_debug then
2097: if g_debug then
2098: hr_utility.set_location(' Leaving:'|| l_proc, 140);
2099: end if;
2100: exception
2101: when app_exception.application_exception then
2102: -- if error is not because of national identifier
2103: if not l_emp_ni
2104: then
2105: if hr_multi_message.exception_add
2484: if g_debug then
2485: hr_utility.set_location(' Leaving:'|| l_proc, 140);
2486: end if;
2487: exception
2488: when app_exception.application_exception then
2489: -- if error is not because of national identifier
2490: if not l_npw_ni
2491: then
2492: if hr_multi_message.exception_add
2652: if g_debug then
2653: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2654: end if;
2655: exception
2656: when app_exception.application_exception then
2657: if hr_multi_message.exception_add
2658: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2659: ) then
2660: if g_debug then
3017: if g_debug then
3018: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3019: end if;
3020: exception
3021: when app_exception.application_exception then
3022: if hr_multi_message.exception_add
3023: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3024: ) then
3025: if g_debug then
3131: if g_debug then
3132: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3133: end if;
3134: exception
3135: when app_exception.application_exception then
3136: if hr_multi_message.exception_add
3137: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3138: ) then
3139: if g_debug then
3221: if g_debug then
3222: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3223: end if;
3224: exception
3225: when app_exception.application_exception then
3226: if hr_multi_message.exception_add
3227: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3228: ) then
3229: if g_debug then
3354: if g_debug then
3355: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3356: end if;
3357: exception
3358: when app_exception.application_exception then
3359: if hr_multi_message.exception_add
3360: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3361: ) then
3362: if g_debug then
5617: if g_debug then
5618: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5619: end if;
5620: exception
5621: when app_exception.application_exception then
5622: if hr_multi_message.exception_add
5623: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5624: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5625: ) then
6177: if g_debug then
6178: hr_utility.set_location(' Leaving:'|| l_proc, 40);
6179: end if;
6180: exception
6181: when app_exception.application_exception then
6182: if hr_multi_message.exception_add
6183: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6184: ) then
6185: if g_debug then
6603: if g_debug then
6604: hr_utility.set_location(' Leaving:'|| l_proc,16);
6605: end if;
6606: exception
6607: when app_exception.application_exception then
6608: if not l_apl_sys
6609: then
6610: if hr_multi_message.exception_add
6611: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6720: if g_debug then
6721: hr_utility.set_location(' Leaving:'|| l_proc, 5);
6722: end if;
6723: exception
6724: when app_exception.application_exception then
6725: if hr_multi_message.exception_add
6726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6727: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6728: ) then
6865: if g_debug then
6866: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6867: end if;
6868: exception
6869: when app_exception.application_exception then
6870: if hr_multi_message.exception_add
6871: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6872: ) then
6873: if g_debug then
7033: if g_debug then
7034: hr_utility.set_location(' Leaving:'|| l_proc, 70);
7035: end if;
7036: exception
7037: when app_exception.application_exception then
7038: if hr_multi_message.exception_add
7039: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7040: ) then
7041: if g_debug then