'|| hr_util_misc_web.return_msg_text(
138: '
' ||
139: '' ||
140: '' ||
141: ' ' ||
142: ' '|| hr_util_misc_web.return_msg_text(
143: p_message_name =>'HR_APPRAISAL_EVENT',
144: p_Application_id =>'PER') || ' | ' ||
145: ' | ' ||
146: ' '||
Line 153: '' || hr_util_misc_web.return_msg_text(
149: ' | ' ||
150: '' ||
151: '' ||
152: '' ||
153: '' || hr_util_misc_web.return_msg_text(
154: p_message_name =>'HR_APPR_PERF_LEVEL',
155: p_Application_id =>'PER') ||' | ' ||
156: '' || hr_util_misc_web.return_msg_text(
157: p_message_name =>'HR_PERF_REVIEW_DATE',
Line 156: '' || hr_util_misc_web.return_msg_text(
152: ' | ' ||
153: '' || hr_util_misc_web.return_msg_text(
154: p_message_name =>'HR_APPR_PERF_LEVEL',
155: p_Application_id =>'PER') ||' | ' ||
156: '' || hr_util_misc_web.return_msg_text(
157: p_message_name =>'HR_PERF_REVIEW_DATE',
158: p_Application_id =>'PER') ||' | ' ||
159: '' || hr_util_misc_web.return_msg_text(
160: p_message_name =>'HR_RESULT',
Line 159: '' || hr_util_misc_web.return_msg_text(
155: p_Application_id =>'PER') ||' | ' ||
156: '' || hr_util_misc_web.return_msg_text(
157: p_message_name =>'HR_PERF_REVIEW_DATE',
158: p_Application_id =>'PER') ||' | ' ||
159: '' || hr_util_misc_web.return_msg_text(
160: p_message_name =>'HR_RESULT',
161: p_Application_id =>'PER') ||' | ' ||
162: '' || hr_util_misc_web.return_msg_text(
163: p_message_name =>'HR_REASON',
Line 162: '' || hr_util_misc_web.return_msg_text(
158: p_Application_id =>'PER') ||' | ' ||
159: '' || hr_util_misc_web.return_msg_text(
160: p_message_name =>'HR_RESULT',
161: p_Application_id =>'PER') ||' | ' ||
162: '' || hr_util_misc_web.return_msg_text(
163: p_message_name =>'HR_REASON',
164: p_Application_id =>'PER') ||' | ' ||
165: ' | | ' ||
166: ' ' ||
Line 202: ' '|| hr_util_misc_web.return_msg_text(
198: '
' ||
199: '' ||
200: '' ||
201: ' ' ||
202: ' '|| hr_util_misc_web.return_msg_text(
203: p_message_name =>'HR_APPRAISAL_STATUS',
204: p_Application_id =>'PER') || ' | ' ||
205: ' | ' ||
206: ' '||
Line 213: '' || hr_util_misc_web.return_msg_text(
209: ' | ' ||
210: '' ||
211: '' ||
212: '' ||
213: '' || hr_util_misc_web.return_msg_text(
214: p_message_name =>'HR_APPRAISAL_DATE',
215: p_Application_id =>'PER') ||' | ' ||
216: '' || hr_util_misc_web.return_msg_text(
217: p_message_name =>'HR_APPRAISEE',
Line 216: '' || hr_util_misc_web.return_msg_text(
212: ' | ' ||
213: '' || hr_util_misc_web.return_msg_text(
214: p_message_name =>'HR_APPRAISAL_DATE',
215: p_Application_id =>'PER') ||' | ' ||
216: '' || hr_util_misc_web.return_msg_text(
217: p_message_name =>'HR_APPRAISEE',
218: p_Application_id =>'PER') ||' | ' ||
219: '' || hr_util_misc_web.return_msg_text(
220: p_message_name =>'HR_APPRAISAL_TYPE',
Line 219: '' || hr_util_misc_web.return_msg_text(
215: p_Application_id =>'PER') ||' | ' ||
216: '' || hr_util_misc_web.return_msg_text(
217: p_message_name =>'HR_APPRAISEE',
218: p_Application_id =>'PER') ||' | ' ||
219: '' || hr_util_misc_web.return_msg_text(
220: p_message_name =>'HR_APPRAISAL_TYPE',
221: p_Application_id =>'PER') ||' | ' ||
222: '' || hr_util_misc_web.return_msg_text(
223: p_message_name =>'HR_STATUS',
Line 222: '' || hr_util_misc_web.return_msg_text(
218: p_Application_id =>'PER') ||' | ' ||
219: '' || hr_util_misc_web.return_msg_text(
220: p_message_name =>'HR_APPRAISAL_TYPE',
221: p_Application_id =>'PER') ||' | ' ||
222: '' || hr_util_misc_web.return_msg_text(
223: p_message_name =>'HR_STATUS',
224: p_Application_id =>'PER') ||' | ' ||
225: '' || hr_util_misc_web.return_msg_text(
226: p_message_name =>'HR_RESULT',
Line 225: '' || hr_util_misc_web.return_msg_text(
221: p_Application_id =>'PER') ||' | ' ||
222: '' || hr_util_misc_web.return_msg_text(
223: p_message_name =>'HR_STATUS',
224: p_Application_id =>'PER') ||' | ' ||
225: '' || hr_util_misc_web.return_msg_text(
226: p_message_name =>'HR_RESULT',
227: p_Application_id =>'PER') ||' | ' ||
228: '' || hr_util_misc_web.return_msg_text(
229: p_message_name =>'HR_REASON',
Line 228: '' || hr_util_misc_web.return_msg_text(
224: p_Application_id =>'PER') ||' | ' ||
225: '' || hr_util_misc_web.return_msg_text(
226: p_message_name =>'HR_RESULT',
227: p_Application_id =>'PER') ||' | ' ||
228: '' || hr_util_misc_web.return_msg_text(
229: p_message_name =>'HR_REASON',
230: p_Application_id =>'PER') ||' | ' ||
231: ' | | | | ' ||
232: ' ' ||
Line 348: p_log := hr_util_misc_web.return_msg_text(
344:
345: open get_appraisal_status(appr_id);
346: fetch get_appraisal_status into lv_appr_result_status;
347: if is_new_appraisal (item_type, item_key) then
348: p_log := hr_util_misc_web.return_msg_text(
349: p_message_name =>'HR_SUCCESS',
350: p_Application_id =>'PER')
351: || '^' || null;
352: else
Line 357: hr_util_misc_web.return_msg_text(
353: generate_appraisal_status(appraisal_record.appraisal_date,
354: appraisal_record.full_name,
355: lv_appr_result_status,
356: appraisal_record.apprtype,
357: hr_util_misc_web.return_msg_text(
358: p_message_name =>'HR_SUCCESS',
359: p_Application_id =>'PER'),
360: null,
361: p_log);
Line 367: p_log := hr_util_misc_web.return_msg_text(
363:
364: EXCEPTION
365: WHEN lv_no_appraisal then
366: if is_new_appraisal (item_type, item_key) then
367: p_log := hr_util_misc_web.return_msg_text(
368: p_message_name =>'HR_FAILURE',
369: p_Application_id =>'PER')
370: || '^' ||
371: hr_util_misc_web.return_msg_text(
Line 371: hr_util_misc_web.return_msg_text(
367: p_log := hr_util_misc_web.return_msg_text(
368: p_message_name =>'HR_FAILURE',
369: p_Application_id =>'PER')
370: || '^' ||
371: hr_util_misc_web.return_msg_text(
372: p_message_name=>'HR_NO_APPRAISAL_RECORD',
373: p_Application_id=>'PER');
374: else
375: generate_appraisal_status(appraisal_record.appraisal_date,
Line 379: hr_util_misc_web.return_msg_text(
375: generate_appraisal_status(appraisal_record.appraisal_date,
376: appraisal_record.full_name,
377: appraisal_record.apprstatus,
378: appraisal_record.apprtype,
379: hr_util_misc_web.return_msg_text(
380: p_message_name =>'HR_FAILURE',
381: p_Application_id =>'PER'),
382: hr_util_misc_web.return_msg_text(
383: p_message_name=>'HR_NO_APPRAISAL_RECORD',
Line 382: hr_util_misc_web.return_msg_text(
378: appraisal_record.apprtype,
379: hr_util_misc_web.return_msg_text(
380: p_message_name =>'HR_FAILURE',
381: p_Application_id =>'PER'),
382: hr_util_misc_web.return_msg_text(
383: p_message_name=>'HR_NO_APPRAISAL_RECORD',
384: p_Application_id=>'PER'),
385: p_log);
386: end if;
Line 397: p_log := hr_util_misc_web.return_msg_text(
393: end loop;
394: --bug#3767915
395: fnd_msg_pub.Delete_Msg;
396: if is_new_appraisal (item_type, item_key) then
397: p_log := hr_util_misc_web.return_msg_text(
398: p_message_name =>'HR_FAILURE',
399: p_Application_id =>'PER')
400: || '^' || error_message;
401: else
Line 406: hr_util_misc_web.return_msg_text(
402: generate_appraisal_status(appraisal_record.appraisal_date,
403: appraisal_record.full_name,
404: appraisal_record.apprstatus,
405: appraisal_record.apprtype,
406: hr_util_misc_web.return_msg_text(
407: p_message_name =>'HR_FAILURE',
408: p_Application_id =>'PER'),
409: error_message,
410: p_log);
Line 417: p_log := hr_util_misc_web.return_msg_text(
413: raise ;
414: when others then
415: error_message := error_message || sqlerrm;
416: if is_new_appraisal (item_type, item_key) then
417: p_log := hr_util_misc_web.return_msg_text(
418: p_message_name =>'HR_FAILURE',
419: p_Application_id =>'PER')
420: || '^' || error_message;
421: else
Line 426: hr_util_misc_web.return_msg_text(
422: generate_appraisal_status(appraisal_record.appraisal_date,
423: appraisal_record.full_name,
424: appraisal_record.apprstatus,
425: appraisal_record.apprtype,
426: hr_util_misc_web.return_msg_text(
427: p_message_name =>'HR_FAILURE',
428: p_Application_id =>'PER'),
429: error_message,
430: p_log);
Line 549: ' '|| hr_util_misc_web.return_msg_text(
545: ' | ' ||
546: '' ||
547: ' ' ||
548: '' ||
549: ' '|| hr_util_misc_web.return_msg_text(
550: p_message_name =>'HR_APPR_APPLY_ASSESS_COMPS',
551: p_Application_id =>'PER') || ' | ' ||
552: ' ' ||
553: '' ||
Line 564: ''|| hr_util_misc_web.return_msg_text(
560: ' | ' ||
561: '' ||
562: '' ||
563: '' ||
564: ''|| hr_util_misc_web.return_msg_text(
565: p_message_name =>'HR_APPR_COMPETENCY',
566: p_Application_id =>'PER') || ' | ' ||
567: ''|| hr_util_misc_web.return_msg_text(
568: p_message_name =>'HR_APPR_LEVEL',
Line 567: ''|| hr_util_misc_web.return_msg_text(
563: ' | ' ||
564: ''|| hr_util_misc_web.return_msg_text(
565: p_message_name =>'HR_APPR_COMPETENCY',
566: p_Application_id =>'PER') || ' | ' ||
567: ''|| hr_util_misc_web.return_msg_text(
568: p_message_name =>'HR_APPR_LEVEL',
569: p_Application_id =>'PER') || ' | ' ||
570: ''|| hr_util_misc_web.return_msg_text(
571: p_message_name =>'HR_RESULT',
Line 570: ''|| hr_util_misc_web.return_msg_text(
566: p_Application_id =>'PER') || ' | ' ||
567: ''|| hr_util_misc_web.return_msg_text(
568: p_message_name =>'HR_APPR_LEVEL',
569: p_Application_id =>'PER') || ' | ' ||
570: ''|| hr_util_misc_web.return_msg_text(
571: p_message_name =>'HR_RESULT',
572: p_Application_id =>'PER') || ' | ' ||
573: ''|| hr_util_misc_web.return_msg_text(
574: p_message_name =>'HR_REASON',
Line 573: ''|| hr_util_misc_web.return_msg_text(
569: p_Application_id =>'PER') || ' | ' ||
570: ''|| hr_util_misc_web.return_msg_text(
571: p_message_name =>'HR_RESULT',
572: p_Application_id =>'PER') || ' | ' ||
573: ''|| hr_util_misc_web.return_msg_text(
574: p_message_name =>'HR_REASON',
575: p_Application_id =>'PER') || ' | ' ||
576: ' | | ';
577: if (length(l_comp_log) <=4000) then
711: END loop;
712: -- End for competence qualification link enhancement
713:
714: each_comp_status := 'S';
715: --p_log := p_log || ' ' || assess_comps.name || ' => ' || hr_util_misc_web.return_msg_text(
716: -- p_message_name=>'HR_ASSESS_COMP_SUCC',
717: -- p_Application_id=>'PER') ||' ';
718:
719: if p_new_appraisal then
Line 721: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_SUCCESS', p_Application_id =>'PER') || '~';
717: -- p_Application_id=>'PER') ||' ';
718:
719: if p_new_appraisal then
720: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
721: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_SUCCESS', p_Application_id =>'PER') || '~';
722: else
723: l_comp_log := l_comp_log ||
724: ' |
725: ' || assess_comps.name || ' |
Line 727: ' || hr_util_misc_web.return_msg_text(
723: l_comp_log := l_comp_log ||
724: ' |
725: ' || assess_comps.name || ' |
726: ' || assess_comps.prof_level || ' |
727: ' || hr_util_misc_web.return_msg_text(
728: p_message_name =>'HR_SUCCESS',
729: p_Application_id =>'PER') || ' |
730: ' || ' |
731: ';
Line 748: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
744: fnd_msg_pub.Delete_Msg;
745:
746: if p_new_appraisal then
747: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
748: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
749: else
750: l_comp_log := l_comp_log ||
751: '
752: ' || assess_comps.name || ' |
Line 754: ' || hr_util_misc_web.return_msg_text(
750: l_comp_log := l_comp_log ||
751: ' |
752: ' || assess_comps.name || ' |
753: ' || assess_comps.prof_level || ' |
754: ' || hr_util_misc_web.return_msg_text(
755: p_message_name =>'HR_FAILURE',
756: p_Application_id =>'PER') || ' |
757: ' || error_message || ' |
758: ';
Line 773: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
769: error_message := error_message || sqlerrm;
770:
771: if p_new_appraisal then
772: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
773: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
774: else
775: l_comp_log := l_comp_log ||
776: '
777: ' || assess_comps.name || ' |
Line 779: ' || hr_util_misc_web.return_msg_text(
775: l_comp_log := l_comp_log ||
776: ' |
777: ' || assess_comps.name || ' |
778: ' || assess_comps.prof_level || ' |
779: ' || hr_util_misc_web.return_msg_text(
780: p_message_name =>'HR_FAILURE',
781: p_Application_id =>'PER') || ' |
782: ' || error_message || ' |
783: ';
832: ,p_achieved_date => l_achieved_date -- added for competence qual enhancement
833: );
834:
835: each_comp_status := 'S';
836: --p_log := p_log || ' ' || assess_comps.name || ' => ' || hr_util_misc_web.return_msg_text(
837: -- p_message_name=>'HR_ASSESS_COMP_SUCC',
838: -- p_Application_id=>'PER') || '';
839:
840: if p_new_appraisal then
Line 842: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_SUCCESS', p_Application_id =>'PER') || '~';
838: -- p_Application_id=>'PER') || '';
839:
840: if p_new_appraisal then
841: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
842: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_SUCCESS', p_Application_id =>'PER') || '~';
843: else
844: l_comp_log := l_comp_log ||
845: '
846: ' || assess_comps.name || ' |
Line 848: ' || hr_util_misc_web.return_msg_text(
844: l_comp_log := l_comp_log ||
845: ' |
846: ' || assess_comps.name || ' |
847: ' || assess_comps.prof_level || ' |
848: ' || hr_util_misc_web.return_msg_text(
849: p_message_name =>'HR_SUCCESS',
850: p_Application_id =>'PER') || ' |
851: ' || ' |
852: ';
Line 870: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
866: --p_log := p_log || ' ';
867:
868: if p_new_appraisal then
869: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
870: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
871: else
872: l_comp_log := l_comp_log ||
873: '
874: ' || assess_comps.name || ' |
Line 876: ' || hr_util_misc_web.return_msg_text(
872: l_comp_log := l_comp_log ||
873: ' |
874: ' || assess_comps.name || ' |
875: ' || assess_comps.prof_level || ' |
876: ' || hr_util_misc_web.return_msg_text(
877: p_message_name =>'HR_FAILURE',
878: p_Application_id =>'PER') || ' |
879: ' || error_message || ' |
880: ';
Line 895: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
891: --p_log := p_log || ' ' || assess_comps.name || ' => ' || sqlcode || sqlerrm || '';
892:
893: if p_new_appraisal then
894: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'
895: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
896: else
897: l_comp_log := l_comp_log ||
898: '
899: ' || assess_comps.name || ' |
Line 901: ' || hr_util_misc_web.return_msg_text(
897: l_comp_log := l_comp_log ||
898: ' |
899: ' || assess_comps.name || ' |
900: ' || assess_comps.prof_level || ' |
901: ' || hr_util_misc_web.return_msg_text(
902: p_message_name =>'HR_FAILURE',
903: p_Application_id =>'PER') || ' |
904: ' || error_message || ' |
905: ';
Line 941: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
937: error_message := error_message || sqlerrm;
938:
939: if p_new_appraisal then
940: l_comp_log := l_comp_log || '-1' || '^'
941: || hr_util_misc_web.return_msg_text(p_message_name =>'HR_FAILURE', p_Application_id =>'PER') || '^' || error_message || '~';
942: else
943: l_comp_log := l_comp_log ||
944: '
945: ' || ' |
Line 947: ' || hr_util_misc_web.return_msg_text(
943: l_comp_log := l_comp_log ||
944: ' |
945: ' || ' |
946: ' || ' |
947: ' || hr_util_misc_web.return_msg_text(
948: p_message_name =>'HR_FAILURE',
949: p_Application_id =>'PER') || ' |
950: ' || error_message || ' |
951: ';
Line 1008: ''|| hr_util_misc_web.return_msg_text(
1004: ' | '||
1005: '' ||
1006: '' ||
1007: '' ||
1008: ''|| hr_util_misc_web.return_msg_text(
1009: p_message_name =>'HR_LP_COURSE',
1010: p_Application_id =>'PER') || ' | ' ||
1011: ''|| hr_util_misc_web.return_msg_text(
1012: p_message_name =>'HR_STATUS',
Line 1011: ''|| hr_util_misc_web.return_msg_text(
1007: ' | ' ||
1008: ''|| hr_util_misc_web.return_msg_text(
1009: p_message_name =>'HR_LP_COURSE',
1010: p_Application_id =>'PER') || ' | ' ||
1011: ''|| hr_util_misc_web.return_msg_text(
1012: p_message_name =>'HR_STATUS',
1013: p_Application_id =>'PER') || ' | ' ||
1014: ''|| hr_util_misc_web.return_msg_text(
1015: p_message_name =>'HR_LP_COURSE_TARGET_DATE',
Line 1014: ''|| hr_util_misc_web.return_msg_text(
1010: p_Application_id =>'PER') || ' | ' ||
1011: ''|| hr_util_misc_web.return_msg_text(
1012: p_message_name =>'HR_STATUS',
1013: p_Application_id =>'PER') || ' | ' ||
1014: ''|| hr_util_misc_web.return_msg_text(
1015: p_message_name =>'HR_LP_COURSE_TARGET_DATE',
1016: p_Application_id =>'PER') || ' | ' ||
1017: ''|| hr_util_misc_web.return_msg_text(
1018: p_message_name =>'HR_LP_COURSE_COMP_DATE',
Line 1017: ''|| hr_util_misc_web.return_msg_text(
1013: p_Application_id =>'PER') || ' | ' ||
1014: ''|| hr_util_misc_web.return_msg_text(
1015: p_message_name =>'HR_LP_COURSE_TARGET_DATE',
1016: p_Application_id =>'PER') || ' | ' ||
1017: ''|| hr_util_misc_web.return_msg_text(
1018: p_message_name =>'HR_LP_COURSE_COMP_DATE',
1019: p_Application_id =>'PER') || ' | ' ||
1020: ' | | ';
1021:
Line 1128: ' '|| hr_util_misc_web.return_msg_text(
1124: ' | ' ||
1125: '' ||
1126: ' ' ||
1127: '' ||
1128: ' '|| hr_util_misc_web.return_msg_text(
1129: p_message_name =>'HR_APPR_LEARNING_PATH',
1130: p_Application_id =>'PER') || ' | ' ||
1131: ' ' ||
1132: '' ||
Line 1143: ''|| hr_util_misc_web.return_msg_text(
1139: ' | ' ||
1140: '' ||
1141: '' ||
1142: '' ||
1143: ''|| hr_util_misc_web.return_msg_text(
1144: p_message_name =>'HR_APPR_LEARNING_PATH',
1145: p_Application_id =>'PER') || ' | ' ||
1146: ''|| hr_util_misc_web.return_msg_text(
1147: p_message_name =>'HR_STATUS',
Line 1146: ''|| hr_util_misc_web.return_msg_text(
1142: ' | ' ||
1143: ''|| hr_util_misc_web.return_msg_text(
1144: p_message_name =>'HR_APPR_LEARNING_PATH',
1145: p_Application_id =>'PER') || ' | ' ||
1146: ''|| hr_util_misc_web.return_msg_text(
1147: p_message_name =>'HR_STATUS',
1148: p_Application_id =>'PER') || ' | ' ||
1149: ''|| hr_util_misc_web.return_msg_text(
1150: p_message_name =>'HR_RESULT',
Line 1149: ''|| hr_util_misc_web.return_msg_text(
1145: p_Application_id =>'PER') || ' | ' ||
1146: ''|| hr_util_misc_web.return_msg_text(
1147: p_message_name =>'HR_STATUS',
1148: p_Application_id =>'PER') || ' | ' ||
1149: ''|| hr_util_misc_web.return_msg_text(
1150: p_message_name =>'HR_RESULT',
1151: p_Application_id =>'PER') || ' | ' ||
1152: ''|| hr_util_misc_web.return_msg_text(
1153: p_message_name =>'HR_REASON',
Line 1152: ''|| hr_util_misc_web.return_msg_text(
1148: p_Application_id =>'PER') || ' | ' ||
1149: ''|| hr_util_misc_web.return_msg_text(
1150: p_message_name =>'HR_RESULT',
1151: p_Application_id =>'PER') || ' | ' ||
1152: ''|| hr_util_misc_web.return_msg_text(
1153: p_message_name =>'HR_REASON',
1154: p_Application_id =>'PER') || ' | ' ||
1155: ' | | ';
1156: end if;
Line 1174: error_message := error_message || hr_util_misc_web.return_msg_text(
1170: EXECUTE IMMEDIATE l_stmt using IN l_lp_id,IN OUT l_lp_ovn,IN 'Y';
1171:
1172: EXCEPTION
1173: WHEN hr_multi_message.error_message_exist THEN
1174: error_message := error_message || hr_util_misc_web.return_msg_text(
1175: p_message_name =>'HR_APPR_DISP_TO_LEARNER',
1176: p_Application_id =>'PER') || ' => ';
1177: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
1178: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
Line 1185: error_message := error_message || hr_util_misc_web.return_msg_text(
1181: fnd_msg_pub.Delete_Msg;
1182: --set_appr_status_log(item_type, item_key, 'W',p_log);
1183: upd_train_comps_status := 'W';
1184: WHEN others THEN
1185: error_message := error_message || hr_util_misc_web.return_msg_text(
1186: p_message_name =>'HR_APPR_DISP_TO_LEARNER',
1187: p_Application_id =>'PER') || ' => ' || sqlerrm ;
1188: upd_train_comps_status := 'W';
1189: END;
Line 1208: error_message := error_message || hr_util_misc_web.return_msg_text(
1204:
1205: EXCEPTION
1206: WHEN hr_multi_message.error_message_exist THEN
1207:
1208: error_message := error_message || hr_util_misc_web.return_msg_text(
1209: p_message_name =>'HR_APPR_LP_STATUS',
1210: p_Application_id =>'PER') || ' => ';
1211: FOR i in 1 .. fnd_msg_pub.count_msg LOOP
1212: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
Line 1219: error_message := error_message || hr_util_misc_web.return_msg_text(
1215: fnd_msg_pub.Delete_Msg;
1216: --set_appr_status_log(item_type, item_key, 'W',p_log);
1217: upd_train_comps_status := 'W';
1218: WHEN others THEN
1219: error_message := error_message || hr_util_misc_web.return_msg_text(
1220: p_message_name =>'HR_APPR_LP_STATUS',
1221: p_Application_id =>'PER') || ' => ' || sqlerrm;
1222: upd_train_comps_status := 'W';
1223: END;
Line 1233: error_message := error_message || hr_util_misc_web.return_msg_text(
1229: query_str := 'SELECT ota_lrng_path_util.chk_complete_path_ok(:1) from dual';
1230: OPEN l_status_cursor FOR query_str USING l_lpe_id;
1231: EXCEPTION
1232: WHEN hr_multi_message.error_message_exist THEN
1233: error_message := error_message || hr_util_misc_web.return_msg_text(
1234: p_message_name =>'HR_APPR_LP_COMPLETE',
1235: p_Application_id =>'PER') || ' => ';
1236: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
1237: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
Line 1242: error_message := error_message || hr_util_misc_web.return_msg_text(
1238: END LOOP;
1239:
1240: WHEN Others THEN
1241:
1242: error_message := error_message || hr_util_misc_web.return_msg_text(
1243: p_message_name =>'HR_APPR_LP_COMPLETE',
1244: p_Application_id =>'PER') || ' => ' || sqlerrm;
1245: upd_train_comps_status := 'S';
1246: END;
Line 1259: error_message := error_message || hr_util_misc_web.return_msg_text(
1255: EXECUTE IMMEDIATE l_stmt using IN l_lpe_id;
1256:
1257: EXCEPTION
1258: WHEN hr_multi_message.error_message_exist THEN
1259: error_message := error_message || hr_util_misc_web.return_msg_text(
1260: p_message_name =>'HR_APPR_LP_COMPLETE',
1261: p_Application_id =>'PER') || ' => ';
1262: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP
1263: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
Line 1270: error_message := error_message || hr_util_misc_web.return_msg_text(
1266: fnd_msg_pub.Delete_Msg;
1267: --set_appr_status_log(item_type, item_key, 'W',p_log);
1268: upd_train_comps_status := 'W';
1269: WHEN others THEN
1270: error_message := error_message || hr_util_misc_web.return_msg_text(
1271: p_message_name =>'HR_APPR_LP_COMPLETE',
1272: p_Application_id =>'PER') || ' => ' || sqlerrm;
1273: upd_train_comps_status := 'W';
1274: END;
Line 1293: || hr_util_misc_web.return_msg_text(
1289:
1290: if p_new_appraisal then
1291: if (error_message is null) then
1292: p_log := l_lp_id || '^'
1293: || hr_util_misc_web.return_msg_text(
1294: p_message_name =>'HR_SUCCESS',
1295: p_Application_id =>'PER')
1296: || '^';
1297: else
Line 1299: || hr_util_misc_web.return_msg_text(
1295: p_Application_id =>'PER')
1296: || '^';
1297: else
1298: p_log := l_lp_id || '^'
1299: || hr_util_misc_web.return_msg_text(
1300: p_message_name =>'HR_FAILURE',
1301: p_Application_id =>'PER')
1302: || '^' || error_message;
1303: end if;
Line 1310: '' || hr_util_misc_web.return_msg_text(
1306: p_log := p_log ||
1307: ' | ' ||
1308: '' || l_lp_name || ' | ' ||
1309: '' || l_completion_status || ' | ' ||
1310: '' || hr_util_misc_web.return_msg_text(
1311: p_message_name =>'HR_SUCCESS',
1312: p_Application_id =>'PER') || ' | ' ||
1313: '' || ' | ' ||
1314: ' ' ||
Line 1330: '' || hr_util_misc_web.return_msg_text(
1326: p_log := p_log ||
1327: ' | ' ||
1328: '' || l_lp_name || ' | ' ||
1329: '' || l_completion_status || ' | ' ||
1330: '' || hr_util_misc_web.return_msg_text(
1331: p_message_name =>'HR_FAILURE',
1332: p_Application_id =>'PER') || ' | ' ||
1333: '' || error_message || ' | ' ||
1334: ' ' ||
Line 1375: || hr_util_misc_web.return_msg_text(
1371: CLOSE l_cursor;
1372: error_message := error_message || sqlerrm ;
1373: if p_new_appraisal then
1374: p_log := l_lp_id || '^'
1375: || hr_util_misc_web.return_msg_text(
1376: p_message_name =>'HR_FAILURE',
1377: p_Application_id =>'PER')
1378: || '^' || error_message;
1379: else
Line 1384: '' || hr_util_misc_web.return_msg_text(
1380: p_log := p_log ||
1381: ' | ' ||
1382: '' || l_lp_name || ' | ' ||
1383: '' || l_path_status || ' | ' ||
1384: '' || hr_util_misc_web.return_msg_text(
1385: p_message_name =>'HR_FAILURE',
1386: p_Application_id =>'PER') || ' | ' ||
1387: '' || error_message || ' | ' ||
1388: ' ' ||
Line 1505: hr_util_misc_web.return_msg_text(
1501:
1502: found_overall_performance := true;
1503:
1504: generate_event(appraisal_rec.overall_perf_rating, trunc(sysdate),
1505: hr_util_misc_web.return_msg_text(
1506: p_message_name =>'HR_SUCCESS',
1507: p_Application_id =>'PER') , null, p_log, p_new_appraisal);
1508:
1509: end if;
Line 1531: hr_util_misc_web.return_msg_text(
1527: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
1528: end loop;
1529: generate_event(appraisal_rec.overall_perf_rating,
1530: trunc(sysdate),
1531: hr_util_misc_web.return_msg_text(
1532: p_message_name =>'HR_FAILURE',
1533: p_Application_id =>'PER') ,
1534: error_message,
1535: p_log,
Line 1547: hr_util_misc_web.return_msg_text(
1543: error_message := error_message || sqlerrm;
1544: upd_create_event_status := 'W';
1545: generate_event(appraisal_rec.overall_perf_rating,
1546: trunc(sysdate),
1547: hr_util_misc_web.return_msg_text(
1548: p_message_name =>'HR_FAILURE',
1549: p_Application_id =>'PER'),
1550: error_message,
1551: p_log,
| | | | | | | | | | | | | | |