2130: --
2131: -- If Performance Start Date not defined, return with error.
2132: --
2133: if p_perf_revw_strt_dt is null then
2134: fnd_message.set_name ('BEN', 'BEN_93190_PERF_STRT_NOT_DFND');
2135: fnd_message.raise_error;
2136: end if;
2137: --
2138:
2131: -- If Performance Start Date not defined, return with error.
2132: --
2133: if p_perf_revw_strt_dt is null then
2134: fnd_message.set_name ('BEN', 'BEN_93190_PERF_STRT_NOT_DFND');
2135: fnd_message.raise_error;
2136: end if;
2137: --
2138:
2139: ---- audit changes begin ------------------------------
2213: p_app_short_name => l_app_short_name,
2214: p_message_name => l_message_name);
2215:
2216: if l_message_name is null then
2217: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2218: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2219: elsif l_save_status = 'PERF_STARTED' and
2220: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2221: l_encoded_message := fnd_message.get_encoded;
2214: p_message_name => l_message_name);
2215:
2216: if l_message_name is null then
2217: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2218: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2219: elsif l_save_status = 'PERF_STARTED' and
2220: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2221: l_encoded_message := fnd_message.get_encoded;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2217: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2218: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2219: elsif l_save_status = 'PERF_STARTED' and
2220: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2221: l_encoded_message := fnd_message.get_encoded;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2218: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2219: elsif l_save_status = 'PERF_STARTED' and
2220: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2221: l_encoded_message := fnd_message.get_encoded;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2226: fnd_message.set_token('NAME', p_person_name);
2220: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2221: l_encoded_message := fnd_message.get_encoded;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2226: fnd_message.set_token('NAME', p_person_name);
2227: fnd_message.set_token('MESSAGE', l_encoded_message);
2228: end if;
2221: l_encoded_message := fnd_message.get_encoded;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2226: fnd_message.set_token('NAME', p_person_name);
2227: fnd_message.set_token('MESSAGE', l_encoded_message);
2228: end if;
2229: fnd_msg_pub.add;
2222: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2226: fnd_message.set_token('NAME', p_person_name);
2227: fnd_message.set_token('MESSAGE', l_encoded_message);
2228: end if;
2229: fnd_msg_pub.add;
2230:
2223: else
2224: l_encoded_message := fnd_message.get;
2225: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2226: fnd_message.set_token('NAME', p_person_name);
2227: fnd_message.set_token('MESSAGE', l_encoded_message);
2228: end if;
2229: fnd_msg_pub.add;
2230:
2231: end process_rating;
2306: --
2307: -- If Assignment Update Date not defined, return with error.
2308: --
2309: if p_asg_updt_eff_date is null then
2310: fnd_message.set_name ('BEN', 'BEN_93191_PROMO_EFFDT_NOT_DFND');
2311: fnd_message.raise_error;
2312: end if;
2313:
2314: ---- audit changes begin ------------------------------
2307: -- If Assignment Update Date not defined, return with error.
2308: --
2309: if p_asg_updt_eff_date is null then
2310: fnd_message.set_name ('BEN', 'BEN_93191_PROMO_EFFDT_NOT_DFND');
2311: fnd_message.raise_error;
2312: end if;
2313:
2314: ---- audit changes begin ------------------------------
2315: -------------------------------------------------------
2452: p_app_short_name => l_app_short_name,
2453: p_message_name => l_message_name);
2454:
2455: if l_message_name is null then
2456: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2457: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2453: p_message_name => l_message_name);
2454:
2455: if l_message_name is null then
2456: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2457: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2461: fnd_message.set_token('NAME', p_person_name);
2455: if l_message_name is null then
2456: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2457: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2461: fnd_message.set_token('NAME', p_person_name);
2462: fnd_message.set_token('MESSAGE', l_encoded_message);
2463: end if;
2456: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2457: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2461: fnd_message.set_token('NAME', p_person_name);
2462: fnd_message.set_token('MESSAGE', l_encoded_message);
2463: end if;
2464: fnd_msg_pub.add;
2457: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2461: fnd_message.set_token('NAME', p_person_name);
2462: fnd_message.set_token('MESSAGE', l_encoded_message);
2463: end if;
2464: fnd_msg_pub.add;
2465:
2458: else
2459: l_encoded_message := fnd_message.get;
2460: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2461: fnd_message.set_token('NAME', p_person_name);
2462: fnd_message.set_token('MESSAGE', l_encoded_message);
2463: end if;
2464: fnd_msg_pub.add;
2465:
2466: end process_promotions;
2532:
2533: if(l_event_type is not null) then
2534: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2535: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2536: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2537: fnd_message.raise_error;
2538: end if;
2539: end if;
2540:
2533: if(l_event_type is not null) then
2534: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2535: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2536: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2537: fnd_message.raise_error;
2538: end if;
2539: end if;
2540:
2541: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2540:
2541: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2542: if(l_performance_review_id is not null) then
2543: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2544: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2545: fnd_message.raise_error;
2546: else
2547: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2548: per_events_api.create_event(
2541: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2542: if(l_performance_review_id is not null) then
2543: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2544: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2545: fnd_message.raise_error;
2546: else
2547: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2548: per_events_api.create_event(
2549: p_validate => false