DBA Data[Home] [Help]

APPS.HR_PERSON_DEPLOYMENT_API dependencies on FND_MESSAGE

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

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

Line 1179: fnd_message.raise_error;

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

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

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

Line 1189: fnd_message.raise_error;

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

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

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

Line 1197: fnd_message.raise_error;

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

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

1380: (p_effective_date => l_dpl_rec.start_date
1381: ,p_person_id => l_dpl_rec.to_person_id
1382: ,p_system_person_type => 'EMP') then
1383: --already emp so raise error
1384: fnd_message.set_name('PER','HR_449616_PDT_ALREADY_EMP');
1385: fnd_message.raise_error;
1386:
1387: elsif hr_person_type_usage_info.is_person_of_type
1388: (p_effective_date => l_dpl_rec.start_date

Line 1385: fnd_message.raise_error;

1381: ,p_person_id => l_dpl_rec.to_person_id
1382: ,p_system_person_type => 'EMP') then
1383: --already emp so raise error
1384: fnd_message.set_name('PER','HR_449616_PDT_ALREADY_EMP');
1385: fnd_message.raise_error;
1386:
1387: elsif hr_person_type_usage_info.is_person_of_type
1388: (p_effective_date => l_dpl_rec.start_date
1389: ,p_person_id => l_dpl_rec.to_person_id

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

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

Line 1393: fnd_message.raise_error;

1389: ,p_person_id => l_dpl_rec.to_person_id
1390: ,p_system_person_type => 'CWK') then
1391: --already cwk so raise error
1392: fnd_message.set_name('PER','HR_449617_PDT_ALREADY_CWK');
1393: fnd_message.raise_error;
1394:
1395: elsif hr_person_type_usage_info.is_person_of_type
1396: (p_effective_date => l_dpl_rec.start_date
1397: ,p_person_id => l_dpl_rec.to_person_id

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

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

Line 1401: fnd_message.raise_error;

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

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

2224: open csr_person_deployment(p_person_deployment_id);
2225: fetch csr_person_deployment into l_dpl_rec;
2226: if csr_person_deployment%notfound then
2227: close csr_person_deployment;
2228: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2229: fnd_message.raise_error;
2230: else
2231: close csr_person_deployment;
2232: --

Line 2229: fnd_message.raise_error;

2225: fetch csr_person_deployment into l_dpl_rec;
2226: if csr_person_deployment%notfound then
2227: close csr_person_deployment;
2228: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2229: fnd_message.raise_error;
2230: else
2231: close csr_person_deployment;
2232: --
2233: hr_utility.set_location(l_proc,30);

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

2234: --
2235: end if;
2236: --
2237: if l_dpl_rec.status = 'DRAFT' then
2238: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2239: fnd_message.raise_error;
2240: elsif l_dpl_rec.status = 'COMPLETE' then
2241: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2242: fnd_message.raise_error;

Line 2239: fnd_message.raise_error;

2235: end if;
2236: --
2237: if l_dpl_rec.status = 'DRAFT' then
2238: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2239: fnd_message.raise_error;
2240: elsif l_dpl_rec.status = 'COMPLETE' then
2241: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2242: fnd_message.raise_error;
2243: end if;

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

2237: if l_dpl_rec.status = 'DRAFT' then
2238: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2239: fnd_message.raise_error;
2240: elsif l_dpl_rec.status = 'COMPLETE' then
2241: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2242: fnd_message.raise_error;
2243: end if;
2244: --
2245: -- Added Bipul

Line 2242: fnd_message.raise_error;

2238: fnd_message.set_name('PER','HR_449619_PDT_DRAFT_NO_CHG');
2239: fnd_message.raise_error;
2240: elsif l_dpl_rec.status = 'COMPLETE' then
2241: fnd_message.set_name('PER','HR_449620_PDT_COMPLETE_NO_CHG');
2242: fnd_message.raise_error;
2243: end if;
2244: --
2245: -- Added Bipul
2246: if (l_dpl_rec.status = 'ACTIVE' and

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

2245: -- Added Bipul
2246: if (l_dpl_rec.status = 'ACTIVE' and
2247: l_end_date_in is not null
2248: and l_end_date_in < trunc(sysdate)) then
2249: fnd_message.set_name('PER','HR_449772_PDT_INV_END_DATE');
2250: fnd_message.raise_error;
2251: end if;
2252:
2253:

Line 2250: fnd_message.raise_error;

2246: if (l_dpl_rec.status = 'ACTIVE' and
2247: l_end_date_in is not null
2248: and l_end_date_in < trunc(sysdate)) then
2249: fnd_message.set_name('PER','HR_449772_PDT_INV_END_DATE');
2250: fnd_message.raise_error;
2251: end if;
2252:
2253:
2254: hr_utility.set_location(l_proc,40);

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

2254: hr_utility.set_location(l_proc,40);
2255: --
2256: if nvl(l_start_date_in,l_dpl_rec.start_date) >=
2257: nvl(l_end_date_in,l_dpl_rec.end_date) then
2258: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2259: fnd_message.raise_error;
2260: end if;
2261: --
2262: if nvl(l_dpl_rec.permanent,'N') = 'Y' then

Line 2259: fnd_message.raise_error;

2255: --
2256: if nvl(l_start_date_in,l_dpl_rec.start_date) >=
2257: nvl(l_end_date_in,l_dpl_rec.end_date) then
2258: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2259: fnd_message.raise_error;
2260: end if;
2261: --
2262: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2263: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');

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

2259: fnd_message.raise_error;
2260: end if;
2261: --
2262: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2263: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');
2264: fnd_message.raise_error;
2265: end if;
2266: --
2267: -- Process Logic

Line 2264: fnd_message.raise_error;

2260: end if;
2261: --
2262: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2263: fnd_message.set_name('PER','HR_449622_PDT_PERM_NO_CHG');
2264: fnd_message.raise_error;
2265: end if;
2266: --
2267: -- Process Logic
2268: --

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

2316: --
2317: close csr_overlap_asg_update;
2318: else
2319: close csr_overlap_asg_update;
2320: fnd_message.set_name('PER','HR_449623_PDT_CHG_ASG_OVERLAP');
2321: fnd_message.raise_error;
2322: end if;
2323: --
2324: end loop;

Line 2321: fnd_message.raise_error;

2317: close csr_overlap_asg_update;
2318: else
2319: close csr_overlap_asg_update;
2320: fnd_message.set_name('PER','HR_449623_PDT_CHG_ASG_OVERLAP');
2321: fnd_message.raise_error;
2322: end if;
2323: --
2324: end loop;
2325: end if;

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

2556: open csr_person_deployment(p_person_deployment_id);
2557: fetch csr_person_deployment into l_dpl_rec;
2558: if csr_person_deployment%notfound then
2559: close csr_person_deployment;
2560: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2561: fnd_message.raise_error;
2562: else
2563: close csr_person_deployment;
2564: --

Line 2561: fnd_message.raise_error;

2557: fetch csr_person_deployment into l_dpl_rec;
2558: if csr_person_deployment%notfound then
2559: close csr_person_deployment;
2560: fnd_message.set_name('PER','HR_449609_DPL_NOT_EXIST');
2561: fnd_message.raise_error;
2562: else
2563: close csr_person_deployment;
2564: --
2565: hr_utility.set_location(l_proc,20);

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

2566: --
2567: end if;
2568: --
2569: if l_dpl_rec.status = 'DRAFT' then
2570: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2571: fnd_message.raise_error;
2572: elsif l_dpl_rec.status = 'COMPLETE' then
2573: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2574: fnd_message.raise_error;

Line 2571: fnd_message.raise_error;

2567: end if;
2568: --
2569: if l_dpl_rec.status = 'DRAFT' then
2570: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2571: fnd_message.raise_error;
2572: elsif l_dpl_rec.status = 'COMPLETE' then
2573: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2574: fnd_message.raise_error;
2575: end if;

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

2569: if l_dpl_rec.status = 'DRAFT' then
2570: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2571: fnd_message.raise_error;
2572: elsif l_dpl_rec.status = 'COMPLETE' then
2573: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2574: fnd_message.raise_error;
2575: end if;
2576: --
2577: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then

Line 2574: fnd_message.raise_error;

2570: fnd_message.set_name('PER','HR_449624_PDT_DRAFT_NO_END');
2571: fnd_message.raise_error;
2572: elsif l_dpl_rec.status = 'COMPLETE' then
2573: fnd_message.set_name('PER','HR_449625_PDT_COMPLETE_NO_END');
2574: fnd_message.raise_error;
2575: end if;
2576: --
2577: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2578: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');

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

2574: fnd_message.raise_error;
2575: end if;
2576: --
2577: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2578: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2579: fnd_message.raise_error;
2580: end if;
2581: --
2582: if nvl(l_dpl_rec.permanent,'N') = 'Y' then

Line 2579: fnd_message.raise_error;

2575: end if;
2576: --
2577: if l_dpl_rec.start_date > nvl(l_end_date_in,l_dpl_rec.end_date) then
2578: fnd_message.set_name('PER','HR_449621_PDT_CHG_DATES');
2579: fnd_message.raise_error;
2580: end if;
2581: --
2582: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2583: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');

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

2579: fnd_message.raise_error;
2580: end if;
2581: --
2582: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2583: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');
2584: fnd_message.raise_error;
2585: end if;
2586: --
2587: -- Process Logic

Line 2584: fnd_message.raise_error;

2580: end if;
2581: --
2582: if nvl(l_dpl_rec.permanent,'N') = 'Y' then
2583: fnd_message.set_name('PER','HR_449626_PDT_PERM_NO_END');
2584: fnd_message.raise_error;
2585: end if;
2586: --
2587: -- Process Logic
2588: --