APPS.HR_COMPLETE_APPRAISAL_SS dependencies on FND_MSG_PUB

Line 391: for i in 1 .. fnd_msg_pub.count_msg Loop

387:
388: chg_appr_status := 'E';
389: raise ;
390: when hr_multi_message.error_message_exist then
391: for i in 1 .. fnd_msg_pub.count_msg Loop
392: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
393: end loop;
394: --bug#3767915
395: fnd_msg_pub.Delete_Msg;

Line 392: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

388: chg_appr_status := 'E';
389: raise ;
390: when hr_multi_message.error_message_exist then
391: for i in 1 .. fnd_msg_pub.count_msg Loop
392: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
393: end loop;
394: --bug#3767915
395: fnd_msg_pub.Delete_Msg;
396: if is_new_appraisal (item_type, item_key) then

Line 395: fnd_msg_pub.Delete_Msg;

391: for i in 1 .. fnd_msg_pub.count_msg Loop
392: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
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')

Line 740: for i in 1 .. fnd_msg_pub.count_msg Loop

736:
737: exception
738: when hr_multi_message.error_message_exist then
739: --p_log := p_log || '
' || assess_comps.name || ' => ';
740: for i in 1 .. fnd_msg_pub.count_msg Loop
741: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
742: end loop;
743: --bug#3767915
744: fnd_msg_pub.Delete_Msg;

737: exception
738: when hr_multi_message.error_message_exist then
739: --p_log := p_log || '
' || assess_comps.name || ' => ';
740: for i in 1 .. fnd_msg_pub.count_msg Loop
741: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
742: end loop;
743: --bug#3767915
744: fnd_msg_pub.Delete_Msg;
745:

857:
858: exception
859: when hr_multi_message.error_message_exist then
860: --p_log := p_log || '
' || assess_comps.name || ' => ';
861: for i in 1 .. fnd_msg_pub.count_msg Loop
862: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
863: end loop;
864: --bug#3767915
865: fnd_msg_pub.Delete_Msg;

858: exception
859: when hr_multi_message.error_message_exist then
860: --p_log := p_log || '
' || assess_comps.name || ' => ';
861: for i in 1 .. fnd_msg_pub.count_msg Loop
862: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
863: end loop;
864: --bug#3767915
865: fnd_msg_pub.Delete_Msg;
866: --p_log := p_log || ' ';

Line 865: fnd_msg_pub.Delete_Msg;

861: for i in 1 .. fnd_msg_pub.count_msg Loop
862: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');
863: end loop;
864: --bug#3767915
865: fnd_msg_pub.Delete_Msg;
866: --p_log := p_log || ' ';
867:
868: if p_new_appraisal then
869: l_comp_log := l_comp_log || assess_comps.competence_element_id || '^'

Line 1177: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP

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');
1179: END LOOP;
1180: --bug#3767915
1181: fnd_msg_pub.Delete_Msg;

Line 1178: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

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');
1179: END LOOP;
1180: --bug#3767915
1181: fnd_msg_pub.Delete_Msg;
1182: --set_appr_status_log(item_type, item_key, 'W',p_log);

Line 1181: fnd_msg_pub.Delete_Msg;

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');
1179: END LOOP;
1180: --bug#3767915
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(

Line 1211: FOR i in 1 .. fnd_msg_pub.count_msg LOOP

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');
1213: END LOOP;
1214: --bug#3767915
1215: fnd_msg_pub.Delete_Msg;

Line 1212: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

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');
1213: END LOOP;
1214: --bug#3767915
1215: fnd_msg_pub.Delete_Msg;
1216: --set_appr_status_log(item_type, item_key, 'W',p_log);

Line 1215: fnd_msg_pub.Delete_Msg;

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');
1213: END LOOP;
1214: --bug#3767915
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(

Line 1236: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP

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');
1238: END LOOP;
1239:
1240: WHEN Others THEN

Line 1237: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

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');
1238: END LOOP;
1239:
1240: WHEN Others THEN
1241:

Line 1262: FOR i IN 1 .. fnd_msg_pub.count_msg LOOP

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');
1264: END LOOP;
1265: --bug#3767915
1266: fnd_msg_pub.Delete_Msg;

Line 1263: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

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');
1264: END LOOP;
1265: --bug#3767915
1266: fnd_msg_pub.Delete_Msg;
1267: --set_appr_status_log(item_type, item_key, 'W',p_log);

Line 1266: fnd_msg_pub.Delete_Msg;

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');
1264: END LOOP;
1265: --bug#3767915
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(

Line 1526: for i in 1 .. fnd_msg_pub.count_msg Loop

1522: EXCEPTION
1523: WHEN hr_multi_message.error_message_exist then
1524: close check_contingent_worker;
1525: close get_appr_overall_perf;
1526: for i in 1 .. fnd_msg_pub.count_msg Loop
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),

Line 1527: error_message := error_message || fnd_msg_pub.get(p_msg_index => I, p_encoded => 'F');

1523: WHEN hr_multi_message.error_message_exist then
1524: close check_contingent_worker;
1525: close get_appr_overall_perf;
1526: for i in 1 .. fnd_msg_pub.count_msg Loop
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(

Line 1538: fnd_msg_pub.Delete_Msg;

1534: error_message,
1535: p_log,
1536: p_new_appraisal);
1537: --bug#3767915
1538: fnd_msg_pub.Delete_Msg;
1539: --set_appr_status_log(item_type, item_key, 'W',p_log);
1540: upd_create_event_status := 'E';
1541:
1542: WHEN others THEN