DBA Data[Home] [Help]

APPS.HR_PERSON_DEPLOYMENT_API dependencies on FND_MESSAGE

Line 1180: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');

1176: open csr_person_deployment(p_person_deployment_id);
1177: fetch csr_person_deployment into l_dpl_rec;
1178: if csr_person_deployment%notfound then
1179: close csr_person_deployment;
1180: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
1181: fnd_message.raise_error;
1182: else
1183: close csr_person_deployment;
1184: --

Line 1181: fnd_message.raise_error;

1177: fetch csr_person_deployment into l_dpl_rec;
1178: if csr_person_deployment%notfound then
1179: close csr_person_deployment;
1180: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
1181: fnd_message.raise_error;
1182: else
1183: close csr_person_deployment;
1184: --
1185: hr_utility.set_location(l_proc,30);

Line 1190: fnd_message.set_name('PER','HR_449614_PDT_ALREADY_INIT');

1186: --
1187: end if;
1188: --
1189: if l_dpl_rec.status <> 'DRAFT' then
1190: fnd_message.set_name('PER','HR_449614_PDT_ALREADY_INIT');
1191: fnd_message.raise_error;
1192: end if;
1193: --
1194: open csr_other_active_dpl(p_person_deployment_id);

Line 1191: fnd_message.raise_error;

1187: end if;
1188: --
1189: if l_dpl_rec.status <> 'DRAFT' then
1190: fnd_message.set_name('PER','HR_449614_PDT_ALREADY_INIT');
1191: fnd_message.raise_error;
1192: end if;
1193: --
1194: open csr_other_active_dpl(p_person_deployment_id);
1195: fetch csr_other_active_dpl into l_dummy_n;

Line 1198: fnd_message.set_name('PER','HR_449615_PDT_OTHER_ACTIVE');

1194: open csr_other_active_dpl(p_person_deployment_id);
1195: fetch csr_other_active_dpl into l_dummy_n;
1196: if csr_other_active_dpl%found then
1197: close csr_other_active_dpl;
1198: fnd_message.set_name('PER','HR_449615_PDT_OTHER_ACTIVE');
1199: fnd_message.raise_error;
1200: else
1201: close csr_other_active_dpl;
1202: end if;

Line 1199: fnd_message.raise_error;

1195: fetch csr_other_active_dpl into l_dummy_n;
1196: if csr_other_active_dpl%found then
1197: close csr_other_active_dpl;
1198: fnd_message.set_name('PER','HR_449615_PDT_OTHER_ACTIVE');
1199: fnd_message.raise_error;
1200: else
1201: close csr_other_active_dpl;
1202: end if;
1203: --

Line 1390: fnd_message.set_name('PER','HR_449616_PDT_ALREADY_EMP');

1386: (p_effective_date => l_dpl_rec.start_date
1387: ,p_person_id => l_dpl_rec.to_person_id
1388: ,p_system_person_type => 'EMP') then
1389: --already emp so raise error
1390: fnd_message.set_name('PER','HR_449616_PDT_ALREADY_EMP');
1391: fnd_message.raise_error;
1392:
1393: elsif hr_person_type_usage_info.is_person_of_type
1394: (p_effective_date => l_dpl_rec.start_date

Line 1391: fnd_message.raise_error;

1387: ,p_person_id => l_dpl_rec.to_person_id
1388: ,p_system_person_type => 'EMP') then
1389: --already emp so raise error
1390: fnd_message.set_name('PER','HR_449616_PDT_ALREADY_EMP');
1391: fnd_message.raise_error;
1392:
1393: elsif hr_person_type_usage_info.is_person_of_type
1394: (p_effective_date => l_dpl_rec.start_date
1395: ,p_person_id => l_dpl_rec.to_person_id

Line 1398: fnd_message.set_name('PER','HR_449617_PDT_ALREADY_CWK');

1394: (p_effective_date => l_dpl_rec.start_date
1395: ,p_person_id => l_dpl_rec.to_person_id
1396: ,p_system_person_type => 'CWK') then
1397: --already cwk so raise error
1398: fnd_message.set_name('PER','HR_449617_PDT_ALREADY_CWK');
1399: fnd_message.raise_error;
1400:
1401: elsif hr_person_type_usage_info.is_person_of_type
1402: (p_effective_date => l_dpl_rec.start_date

Line 1399: fnd_message.raise_error;

1395: ,p_person_id => l_dpl_rec.to_person_id
1396: ,p_system_person_type => 'CWK') then
1397: --already cwk so raise error
1398: fnd_message.set_name('PER','HR_449617_PDT_ALREADY_CWK');
1399: fnd_message.raise_error;
1400:
1401: elsif hr_person_type_usage_info.is_person_of_type
1402: (p_effective_date => l_dpl_rec.start_date
1403: ,p_person_id => l_dpl_rec.to_person_id

Line 1406: fnd_message.set_name('PER','HR_449618_PDT_ALREADY_APL');

1402: (p_effective_date => l_dpl_rec.start_date
1403: ,p_person_id => l_dpl_rec.to_person_id
1404: ,p_system_person_type => 'APL') then
1405: --error out in this case, there is no way to create an employee record from here
1406: fnd_message.set_name('PER','HR_449618_PDT_ALREADY_APL');
1407: fnd_message.raise_error;
1408: --
1409: else --we should have the all clear to hire existing person
1410: --

Line 1407: fnd_message.raise_error;

1403: ,p_person_id => l_dpl_rec.to_person_id
1404: ,p_system_person_type => 'APL') then
1405: --error out in this case, there is no way to create an employee record from here
1406: fnd_message.set_name('PER','HR_449618_PDT_ALREADY_APL');
1407: fnd_message.raise_error;
1408: --
1409: else --we should have the all clear to hire existing person
1410: --
1411: hr_utility.set_location(l_proc,70);

Line 2253: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');

2249: open csr_person_deployment(p_person_deployment_id);
2250: fetch csr_person_deployment into l_dpl_rec;
2251: if csr_person_deployment%notfound then
2252: close csr_person_deployment;
2253: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2254: fnd_message.raise_error;
2255: else
2256: close csr_person_deployment;
2257: --

Line 2254: fnd_message.raise_error;

2250: fetch csr_person_deployment into l_dpl_rec;
2251: if csr_person_deployment%notfound then
2252: close csr_person_deployment;
2253: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2254: fnd_message.raise_error;
2255: else
2256: close csr_person_deployment;
2257: --
2258: hr_utility.set_location(l_proc,30);

Line 2263: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');

2259: --
2260: end if;
2261: --
2262: if l_dpl_rec.status = 'DRAFT' then
2263: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2264: fnd_message.raise_error;
2265: elsif l_dpl_rec.status = 'COMPLETE' then
2266: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2267: fnd_message.raise_error;

Line 2264: fnd_message.raise_error;

2260: end if;
2261: --
2262: if l_dpl_rec.status = 'DRAFT' then
2263: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2264: fnd_message.raise_error;
2265: elsif l_dpl_rec.status = 'COMPLETE' then
2266: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2267: fnd_message.raise_error;
2268: end if;

Line 2266: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');

2262: if l_dpl_rec.status = 'DRAFT' then
2263: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2264: fnd_message.raise_error;
2265: elsif l_dpl_rec.status = 'COMPLETE' then
2266: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2267: fnd_message.raise_error;
2268: end if;
2269: --
2270: -- Added Bipul

Line 2267: fnd_message.raise_error;

2263: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2264: fnd_message.raise_error;
2265: elsif l_dpl_rec.status = 'COMPLETE' then
2266: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2267: fnd_message.raise_error;
2268: end if;
2269: --
2270: -- Added Bipul
2271: if (l_dpl_rec.status = 'ACTIVE' and

Line 2274: fnd_message.set_name('PER','HR_449772_PDT_INV_END_DATE');

2270: -- Added Bipul
2271: if (l_dpl_rec.status = 'ACTIVE' and
2272: l_end_date_in is not null
2273: and l_end_date_in < trunc(sysdate)) then
2274: fnd_message.set_name('PER','HR_449772_PDT_INV_END_DATE');
2275: fnd_message.raise_error;
2276: end if;
2277:
2278:

Line 2275: fnd_message.raise_error;

2271: if (l_dpl_rec.status = 'ACTIVE' and
2272: l_end_date_in is not null
2273: and l_end_date_in < trunc(sysdate)) then
2274: fnd_message.set_name('PER','HR_449772_PDT_INV_END_DATE');
2275: fnd_message.raise_error;
2276: end if;
2277:
2278:
2279: hr_utility.set_location(l_proc,40);

Line 2283: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');

2279: hr_utility.set_location(l_proc,40);
2280: --
2281: if nvl(l_start_date_in,l_dpl_rec.start_date) >=
2282: nvl(l_end_date_in,l_dpl_rec.end_date) then
2283: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2284: fnd_message.raise_error;
2285: end if;
2286: --
2287: if nvl(l_dpl_rec.permanent,'N') = 'Y' then

Line 2284: fnd_message.raise_error;

2280: --
2281: if nvl(l_start_date_in,l_dpl_rec.start_date) >=
2282: nvl(l_end_date_in,l_dpl_rec.end_date) then
2283: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2284: fnd_message.raise_error;
2285: end if;
2286: --
2287: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2288: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');

Line 2288: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');

2284: fnd_message.raise_error;
2285: end if;
2286: --
2287: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2288: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');
2289: fnd_message.raise_error;
2290: end if;
2291: --
2292: -- Process Logic

Line 2289: fnd_message.raise_error;

2285: end if;
2286: --
2287: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2288: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');
2289: fnd_message.raise_error;
2290: end if;
2291: --
2292: -- Process Logic
2293: --

Line 2345: fnd_message.set_name('PER','HR_449623_PDT_CHG_ASG_OVERLAP');

2341: --
2342: close csr_overlap_asg_update;
2343: else
2344: close csr_overlap_asg_update;
2345: fnd_message.set_name('PER','HR_449623_PDT_CHG_ASG_OVERLAP');
2346: fnd_message.raise_error;
2347: end if;
2348: --
2349: end loop;

Line 2346: fnd_message.raise_error;

2342: close csr_overlap_asg_update;
2343: else
2344: close csr_overlap_asg_update;
2345: fnd_message.set_name('PER','HR_449623_PDT_CHG_ASG_OVERLAP');
2346: fnd_message.raise_error;
2347: end if;
2348: --
2349: end loop;
2350: end if;

Line 2585: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');

2581: open csr_person_deployment(p_person_deployment_id);
2582: fetch csr_person_deployment into l_dpl_rec;
2583: if csr_person_deployment%notfound then
2584: close csr_person_deployment;
2585: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2586: fnd_message.raise_error;
2587: else
2588: close csr_person_deployment;
2589: --

Line 2586: fnd_message.raise_error;

2582: fetch csr_person_deployment into l_dpl_rec;
2583: if csr_person_deployment%notfound then
2584: close csr_person_deployment;
2585: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2586: fnd_message.raise_error;
2587: else
2588: close csr_person_deployment;
2589: --
2590: hr_utility.set_location(l_proc,20);

Line 2595: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');

2591: --
2592: end if;
2593: --
2594: if l_dpl_rec.status = 'DRAFT' then
2595: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2596: fnd_message.raise_error;
2597: elsif l_dpl_rec.status = 'COMPLETE' then
2598: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2599: fnd_message.raise_error;

Line 2596: fnd_message.raise_error;

2592: end if;
2593: --
2594: if l_dpl_rec.status = 'DRAFT' then
2595: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2596: fnd_message.raise_error;
2597: elsif l_dpl_rec.status = 'COMPLETE' then
2598: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2599: fnd_message.raise_error;
2600: end if;

Line 2598: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');

2594: if l_dpl_rec.status = 'DRAFT' then
2595: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2596: fnd_message.raise_error;
2597: elsif l_dpl_rec.status = 'COMPLETE' then
2598: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2599: fnd_message.raise_error;
2600: end if;
2601: --
2602: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then

Line 2599: fnd_message.raise_error;

2595: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2596: fnd_message.raise_error;
2597: elsif l_dpl_rec.status = 'COMPLETE' then
2598: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2599: fnd_message.raise_error;
2600: end if;
2601: --
2602: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2603: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');

Line 2603: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');

2599: fnd_message.raise_error;
2600: end if;
2601: --
2602: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2603: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2604: fnd_message.raise_error;
2605: end if;
2606: --
2607: if nvl(l_dpl_rec.permanent,'N') = 'Y' then

Line 2604: fnd_message.raise_error;

2600: end if;
2601: --
2602: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2603: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2604: fnd_message.raise_error;
2605: end if;
2606: --
2607: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2608: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');

Line 2608: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');

2604: fnd_message.raise_error;
2605: end if;
2606: --
2607: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2608: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');
2609: fnd_message.raise_error;
2610: end if;
2611: --
2612: -- Process Logic

Line 2609: fnd_message.raise_error;

2605: end if;
2606: --
2607: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2608: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');
2609: fnd_message.raise_error;
2610: end if;
2611: --
2612: -- Process Logic
2613: --