2135: --
2136: -- If Performance Start Date not defined, return with error.
2137: --
2138: if p_perf_revw_strt_dt is null then
2139: fnd_message.set_name ('BEN', 'BEN_93190_PERF_STRT_NOT_DFND');
2140: fnd_message.raise_error;
2141: end if;
2142: --
2143:
2136: -- If Performance Start Date not defined, return with error.
2137: --
2138: if p_perf_revw_strt_dt is null then
2139: fnd_message.set_name ('BEN', 'BEN_93190_PERF_STRT_NOT_DFND');
2140: fnd_message.raise_error;
2141: end if;
2142: --
2143:
2144: ---- audit changes begin ------------------------------
2218: p_app_short_name => l_app_short_name,
2219: p_message_name => l_message_name);
2220:
2221: if l_message_name is null then
2222: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2223: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2224: elsif l_save_status = 'PERF_STARTED' and
2225: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2226: l_encoded_message := fnd_message.get_encoded;
2219: p_message_name => l_message_name);
2220:
2221: if l_message_name is null then
2222: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2223: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2224: elsif l_save_status = 'PERF_STARTED' and
2225: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2226: l_encoded_message := fnd_message.get_encoded;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2222: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2223: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2224: elsif l_save_status = 'PERF_STARTED' and
2225: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2226: l_encoded_message := fnd_message.get_encoded;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2223: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2224: elsif l_save_status = 'PERF_STARTED' and
2225: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2226: l_encoded_message := fnd_message.get_encoded;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2231: fnd_message.set_token('NAME', p_person_name);
2225: l_message_name = 'HR_13000_SAL_DATE_NOT_UNIQUE' then
2226: l_encoded_message := fnd_message.get_encoded;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2231: fnd_message.set_token('NAME', p_person_name);
2232: fnd_message.set_token('MESSAGE', l_encoded_message);
2233: end if;
2226: l_encoded_message := fnd_message.get_encoded;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2231: fnd_message.set_token('NAME', p_person_name);
2232: fnd_message.set_token('MESSAGE', l_encoded_message);
2233: end if;
2234: fnd_msg_pub.add;
2227: fnd_message.set_name('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2231: fnd_message.set_token('NAME', p_person_name);
2232: fnd_message.set_token('MESSAGE', l_encoded_message);
2233: end if;
2234: fnd_msg_pub.add;
2235:
2228: else
2229: l_encoded_message := fnd_message.get;
2230: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2231: fnd_message.set_token('NAME', p_person_name);
2232: fnd_message.set_token('MESSAGE', l_encoded_message);
2233: end if;
2234: fnd_msg_pub.add;
2235:
2236: end process_rating;
2311: --
2312: -- If Assignment Update Date not defined, return with error.
2313: --
2314: if p_asg_updt_eff_date is null then
2315: fnd_message.set_name ('BEN', 'BEN_93191_PROMO_EFFDT_NOT_DFND');
2316: fnd_message.raise_error;
2317: end if;
2318:
2319: ---- audit changes begin ------------------------------
2312: -- If Assignment Update Date not defined, return with error.
2313: --
2314: if p_asg_updt_eff_date is null then
2315: fnd_message.set_name ('BEN', 'BEN_93191_PROMO_EFFDT_NOT_DFND');
2316: fnd_message.raise_error;
2317: end if;
2318:
2319: ---- audit changes begin ------------------------------
2320: -------------------------------------------------------
2457: p_app_short_name => l_app_short_name,
2458: p_message_name => l_message_name);
2459:
2460: if l_message_name is null then
2461: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2462: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2458: p_message_name => l_message_name);
2459:
2460: if l_message_name is null then
2461: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2462: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2466: fnd_message.set_token('NAME', p_person_name);
2460: if l_message_name is null then
2461: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2462: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2466: fnd_message.set_token('NAME', p_person_name);
2467: fnd_message.set_token('MESSAGE', l_encoded_message);
2468: end if;
2461: fnd_message.set_name('PER','HR_ASG_PROCESS_API_ERROR');
2462: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2466: fnd_message.set_token('NAME', p_person_name);
2467: fnd_message.set_token('MESSAGE', l_encoded_message);
2468: end if;
2469: fnd_msg_pub.add;
2462: fnd_message.set_token('ERROR_MSG',substr(sqlerrm,1,1000));
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2466: fnd_message.set_token('NAME', p_person_name);
2467: fnd_message.set_token('MESSAGE', l_encoded_message);
2468: end if;
2469: fnd_msg_pub.add;
2470:
2463: else
2464: l_encoded_message := fnd_message.get;
2465: fnd_message.set_name('BEN', 'BEN_93934_CWB_EMP_SAVE_API_ERR');
2466: fnd_message.set_token('NAME', p_person_name);
2467: fnd_message.set_token('MESSAGE', l_encoded_message);
2468: end if;
2469: fnd_msg_pub.add;
2470:
2471: end process_promotions;
2537:
2538: if(l_event_type is not null) then
2539: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2540: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2541: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2542: fnd_message.raise_error;
2543: end if;
2544: end if;
2545:
2538: if(l_event_type is not null) then
2539: if (l_event_type <> nvl(p_txn_rec.attribute2,'-1')) then
2540: hr_utility.set_location('Rating type mismatch '||l_event_type||'&'||p_txn_rec.attribute2, 20);
2541: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2542: fnd_message.raise_error;
2543: end if;
2544: end if;
2545:
2546: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2545:
2546: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2547: if(l_performance_review_id is not null) then
2548: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2549: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2550: fnd_message.raise_error;
2551: else
2552: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2553: per_events_api.create_event(
2546: if (p_txn_rec.attribute2 is not null and l_event_id is null) then
2547: if(l_performance_review_id is not null) then
2548: hr_utility.set_location('Not Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2549: fnd_message.set_name ('BEN', 'BEN_93371_RATING_EXST_FOR_DATE');
2550: fnd_message.raise_error;
2551: else
2552: hr_utility.set_location('Creating Evt. Assign Id: ' ||p_txn_rec.assignment_id, 30);
2553: per_events_api.create_event(
2554: p_validate => false