[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
720: if g_debug then
721: hr_utility.set_location(' Leaving:'|| l_proc, 13);
722: end if;
723: exception
724: when app_exception.application_exception then
725: if hr_multi_message.exception_add
726: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PERSON_TYPE_ID'
727: ) then
728: if g_debug then
986: if g_debug then
987: hr_utility.set_location(' Leaving:'|| l_proc, 8);
988: end if;
989: exception
990: when app_exception.application_exception then
991: If not l_dob_st then
992: if hr_multi_message.exception_add
993: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_OF_BIRTH'
994: ) then
1144: if g_debug then
1145: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1146: end if;
1147: exception
1148: when app_exception.application_exception then
1149: if hr_multi_message.exception_add
1150: (p_associated_column1 => 'PER_ALL_PEOPLE_F.MARITAL_STATUS'
1151: ) then
1152: if g_debug then
1268: if g_debug then
1269: hr_utility.set_location(' Leaving:'|| l_proc, 70);
1270: end if;
1271: exception
1272: when app_exception.application_exception then
1273: if hr_multi_message.exception_add
1274: (p_associated_column1 => 'PER_ALL_PEOPLE_F.PARTY_ID'
1275: ) then
1276: if g_debug then
1411: if g_debug then
1412: hr_utility.set_location(' Leaving:'|| l_proc, 60);
1413: end if;
1414: exception
1415: when app_exception.application_exception then
1416: if hr_multi_message.exception_add
1417: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONALITY'
1418: ) then
1419: if g_debug then
1613: if g_debug then
1614: hr_utility.set_location(' Leaving:'|| l_proc, 3);
1615: end if;
1616: exception
1617: when app_exception.application_exception then
1618: if hr_multi_message.exception_add
1619: (p_associated_column1 => 'PER_ALL_PEOPLE_F.NATIONAL_IDENTIFIER'
1620: ) then
1621: if g_debug then
2093: if g_debug then
2094: hr_utility.set_location(' Leaving:'|| l_proc, 140);
2095: end if;
2096: exception
2097: when app_exception.application_exception then
2098: -- if error is not because of national identifier
2099: if not l_emp_ni
2100: then
2101: if hr_multi_message.exception_add
2474: if g_debug then
2475: hr_utility.set_location(' Leaving:'|| l_proc, 140);
2476: end if;
2477: exception
2478: when app_exception.application_exception then
2479: -- if error is not because of national identifier
2480: if not l_npw_ni
2481: then
2482: if hr_multi_message.exception_add
2642: if g_debug then
2643: hr_utility.set_location(' Leaving:'|| l_proc, 70);
2644: end if;
2645: exception
2646: when app_exception.application_exception then
2647: if hr_multi_message.exception_add
2648: (p_associated_column1 => 'PER_ALL_PEOPLE_F.EXPENSE_CHECK_SEND_TO_ADDRESS'
2649: ) then
2650: if g_debug then
3007: if g_debug then
3008: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3009: end if;
3010: exception
3011: when app_exception.application_exception then
3012: if hr_multi_message.exception_add
3013: (p_associated_column1 => 'PER_ALL_PEOPLE_F.TOWN_OF_BIRTH'
3014: ) then
3015: if g_debug then
3121: if g_debug then
3122: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3123: end if;
3124: exception
3125: when app_exception.application_exception then
3126: if hr_multi_message.exception_add
3127: (p_associated_column1 => 'PER_ALL_PEOPLE_F.REGION_OF_BIRTH'
3128: ) then
3129: if g_debug then
3211: if g_debug then
3212: hr_utility.set_location(' Leaving:'|| l_proc, 3);
3213: end if;
3214: exception
3215: when app_exception.application_exception then
3216: if hr_multi_message.exception_add
3217: (p_associated_column1 => 'PER_ALL_PEOPLE_F.COUNTRY_OF_BIRTH'
3218: ) then
3219: if g_debug then
3344: if g_debug then
3345: hr_utility.set_location(' Leaving:'|| l_proc, 4);
3346: end if;
3347: exception
3348: when app_exception.application_exception then
3349: if hr_multi_message.exception_add
3350: (p_associated_column1 => 'PER_ALL_PEOPLE_F.START_DATE'
3351: ) then
3352: if g_debug then
5606: if g_debug then
5607: hr_utility.set_location(' Leaving:'|| l_proc, 5);
5608: end if;
5609: exception
5610: when app_exception.application_exception then
5611: if hr_multi_message.exception_add
5612: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
5613: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.FIRST_NAME'
5614: ) then
6166: if g_debug then
6167: hr_utility.set_location(' Leaving:'|| l_proc, 40);
6168: end if;
6169: exception
6170: when app_exception.application_exception then
6171: if hr_multi_message.exception_add
6172: (p_associated_column1 => 'PER_ALL_PEOPLE_F.LAST_NAME'
6173: ) then
6174: if g_debug then
6592: if g_debug then
6593: hr_utility.set_location(' Leaving:'|| l_proc,16);
6594: end if;
6595: exception
6596: when app_exception.application_exception then
6597: if not l_apl_sys
6598: then
6599: if hr_multi_message.exception_add
6600: (p_associated_column1 => 'PER_ALL_PEOPLE_F.APPLICANT_NUMBER'
6709: if g_debug then
6710: hr_utility.set_location(' Leaving:'|| l_proc, 5);
6711: end if;
6712: exception
6713: when app_exception.application_exception then
6714: if hr_multi_message.exception_add
6715: (p_associated_column1 => 'PER_ALL_PEOPLE_F.DATE_EMPLOYEE_DATA_VERIFIED'
6716: ,p_associated_column2 => 'PER_ALL_PEOPLE_F.EFFECTIVE_START_DATE'
6717: ) then
6854: if g_debug then
6855: hr_utility.set_location(' Leaving:'|| l_proc, 80);
6856: end if;
6857: exception
6858: when app_exception.application_exception then
6859: if hr_multi_message.exception_add
6860: (p_associated_column1 => 'PER_ALL_PEOPLE_F.VENDOR_ID'
6861: ) then
6862: if g_debug then
7022: if g_debug then
7023: hr_utility.set_location(' Leaving:'|| l_proc, 70);
7024: end if;
7025: exception
7026: when app_exception.application_exception then
7027: if hr_multi_message.exception_add
7028: (p_associated_column1 => 'PER_ALL_PEOPLE_F.WORK_TELEPHONE'
7029: ) then
7030: if g_debug then