519: --
520: -- This error is raised when the formula returned a character value for normalized_rating
521: -- out parameter
522: --
523: Fnd_Message.Set_Name('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
524: Fnd_Message.Set_Token('PARAMETER','NORMALIZED_RATING' );
525: Fnd_Message.Set_Token('FORMULA',l_ff_id);
526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');
527: RAISE ff_returned_invalid_value;
520: -- This error is raised when the formula returned a character value for normalized_rating
521: -- out parameter
522: --
523: Fnd_Message.Set_Name('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
524: Fnd_Message.Set_Token('PARAMETER','NORMALIZED_RATING' );
525: Fnd_Message.Set_Token('FORMULA',l_ff_id);
526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');
527: RAISE ff_returned_invalid_value;
528: --
521: -- out parameter
522: --
523: Fnd_Message.Set_Name('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
524: Fnd_Message.Set_Token('PARAMETER','NORMALIZED_RATING' );
525: Fnd_Message.Set_Token('FORMULA',l_ff_id);
526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');
527: RAISE ff_returned_invalid_value;
528: --
529: END;
522: --
523: Fnd_Message.Set_Name('BEN', 'BEN_92311_FORMULA_VAL_PARAM');
524: Fnd_Message.Set_Token('PARAMETER','NORMALIZED_RATING' );
525: Fnd_Message.Set_Token('FORMULA',l_ff_id);
526: Fnd_Message.Set_Token('PROC','HRI_BPL_PERF_RATING');
527: RAISE ff_returned_invalid_value;
528: --
529: END;
530: --
844: ' ORDER BY 2, 3';
845: --
846: -- Bug 4105868: Collection Diagnostic Call
847: --
848: fnd_message.set_name('HRI', 'HRI_407267_REVRTG_WRNGBG_IMPCT');
849: --
850: l_message := fnd_message.get;
851: --
852: hri_bpl_conc_log.log_process_info
846: -- Bug 4105868: Collection Diagnostic Call
847: --
848: fnd_message.set_name('HRI', 'HRI_407267_REVRTG_WRNGBG_IMPCT');
849: --
850: l_message := fnd_message.get;
851: --
852: hri_bpl_conc_log.log_process_info
853: (p_msg_type => 'WARNING'
854: ,p_note => l_message
1003: -- Bug 4105868: Collection Diagnostic Call
1004: -- 4237434 The name of the formula was wrongly being passed, Because of which
1005: -- a error was thrown. Changed the name of the message
1006: --
1007: fnd_message.set_name('HRI', 'HRI_407289_NRMLZD_RTNG_NOT_CLS');
1008: --
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1005: -- a error was thrown. Changed the name of the message
1006: --
1007: fnd_message.set_name('HRI', 'HRI_407289_NRMLZD_RTNG_NOT_CLS');
1008: --
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1006: --
1007: fnd_message.set_name('HRI', 'HRI_407289_NRMLZD_RTNG_NOT_CLS');
1008: --
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1007: fnd_message.set_name('HRI', 'HRI_407289_NRMLZD_RTNG_NOT_CLS');
1008: --
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1009: fnd_message.set_token('FF_NAME', l_ff_name);
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);
1017: --
1010: fnd_message.set_token('PERSON_NAME', l_person_name);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);
1017: --
1018: l_message := nvl(fnd_message.get, SQLERRM);
1011: fnd_message.set_token('BUSINESS_GROUP_ID',
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);
1017: --
1018: l_message := nvl(fnd_message.get, SQLERRM);
1019: --
1012: hr_general.decode_organization(p_business_group_id));
1013: fnd_message.set_token('APPRAISAL_TEMPLATE_NAME', p_appraisal_template_name);
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);
1017: --
1018: l_message := nvl(fnd_message.get, SQLERRM);
1019: --
1020: hri_bpl_conc_log.log_process_info
1014: fnd_message.set_token('REVIEW_TYPE', p_review_type);
1015: fnd_message.set_token('PERF_RATING_CD', p_perf_rating_cd);
1016: fnd_message.set_token('PERF_NRMLSD_RATING', p_perf_nrmlsd_rating);
1017: --
1018: l_message := nvl(fnd_message.get, SQLERRM);
1019: --
1020: hri_bpl_conc_log.log_process_info
1021: (p_msg_type => 'WARNING'
1022: ,p_note => l_message