467: chg_appr_status := 'E';
468: RAISE;
469: WHEN hr_multi_message.error_message_exist
470: THEN
471: FOR i IN 1 .. fnd_msg_pub.count_msg
472: LOOP
473: error_message :=
474: error_message || fnd_msg_pub.get (p_msg_index => i,
475: p_encoded => 'F');
470: THEN
471: FOR i IN 1 .. fnd_msg_pub.count_msg
472: LOOP
473: error_message :=
474: error_message || fnd_msg_pub.get (p_msg_index => i,
475: p_encoded => 'F');
476: END LOOP;
477:
478: --bug#3767915
475: p_encoded => 'F');
476: END LOOP;
477:
478: --bug#3767915
479: fnd_msg_pub.delete_msg;
480:
481: IF is_new_appraisal (item_type, item_key)
482: THEN
483: p_log :=
962: EXCEPTION
963: WHEN hr_multi_message.error_message_exist
964: THEN
965: --p_log := p_log || '
' || assess_comps.name || ' => ';
966: FOR i IN 1 .. fnd_msg_pub.count_msg
967: LOOP
968: error_message :=
969: error_message || fnd_msg_pub.get (p_msg_index => i,
970: p_encoded => 'F');
965: --p_log := p_log || '
' || assess_comps.name || ' => ';
966: FOR i IN 1 .. fnd_msg_pub.count_msg
967: LOOP
968: error_message :=
969: error_message || fnd_msg_pub.get (p_msg_index => i,
970: p_encoded => 'F');
971: END LOOP;
972:
973: --bug#3767915
970: p_encoded => 'F');
971: END LOOP;
972:
973: --bug#3767915
974: fnd_msg_pub.delete_msg;
975:
976: IF p_new_appraisal
977: THEN
978: l_comp_log :=
1153: EXCEPTION
1154: WHEN hr_multi_message.error_message_exist
1155: THEN
1156: --p_log := p_log || '
' || assess_comps.name || ' => ';
1157: FOR i IN 1 .. fnd_msg_pub.count_msg
1158: LOOP
1159: error_message :=
1160: error_message || fnd_msg_pub.get (p_msg_index => i,
1161: p_encoded => 'F');
1156: --p_log := p_log || '
' || assess_comps.name || ' => ';
1157: FOR i IN 1 .. fnd_msg_pub.count_msg
1158: LOOP
1159: error_message :=
1160: error_message || fnd_msg_pub.get (p_msg_index => i,
1161: p_encoded => 'F');
1162: END LOOP;
1163:
1164: --bug#3767915
1161: p_encoded => 'F');
1162: END LOOP;
1163:
1164: --bug#3767915
1165: fnd_msg_pub.delete_msg;
1166:
1167: --p_log := p_log || ' ';
1168: IF p_new_appraisal
1169: THEN
1603: p_application_id => 'PER'
1604: )
1605: || ' => ';
1606:
1607: FOR i IN 1 .. fnd_msg_pub.count_msg
1608: LOOP
1609: error_message :=
1610: error_message || fnd_msg_pub.get (p_msg_index => i,
1611: p_encoded => 'F');
1606:
1607: FOR i IN 1 .. fnd_msg_pub.count_msg
1608: LOOP
1609: error_message :=
1610: error_message || fnd_msg_pub.get (p_msg_index => i,
1611: p_encoded => 'F');
1612: END LOOP;
1613:
1614: --bug#3767915
1611: p_encoded => 'F');
1612: END LOOP;
1613:
1614: --bug#3767915
1615: fnd_msg_pub.delete_msg;
1616: --set_appr_status_log(item_type, item_key, 'W',p_log);
1617: upd_train_comps_status := 'W';
1618: WHEN OTHERS
1619: THEN
1652: p_application_id => 'PER'
1653: )
1654: || ' => ';
1655:
1656: FOR i IN 1 .. fnd_msg_pub.count_msg
1657: LOOP
1658: error_message :=
1659: error_message || fnd_msg_pub.get (p_msg_index => i,
1660: p_encoded => 'F');
1655:
1656: FOR i IN 1 .. fnd_msg_pub.count_msg
1657: LOOP
1658: error_message :=
1659: error_message || fnd_msg_pub.get (p_msg_index => i,
1660: p_encoded => 'F');
1661: END LOOP;
1662:
1663: --bug#3767915
1660: p_encoded => 'F');
1661: END LOOP;
1662:
1663: --bug#3767915
1664: fnd_msg_pub.delete_msg;
1665: --set_appr_status_log(item_type, item_key, 'W',p_log);
1666: upd_train_comps_status := 'W';
1667: WHEN OTHERS
1668: THEN
1692: p_application_id => 'PER'
1693: )
1694: || ' => ';
1695:
1696: FOR i IN 1 .. fnd_msg_pub.count_msg
1697: LOOP
1698: error_message :=
1699: error_message || fnd_msg_pub.get (p_msg_index => i,
1700: p_encoded => 'F');
1695:
1696: FOR i IN 1 .. fnd_msg_pub.count_msg
1697: LOOP
1698: error_message :=
1699: error_message || fnd_msg_pub.get (p_msg_index => i,
1700: p_encoded => 'F');
1701: END LOOP;
1702: WHEN OTHERS
1703: THEN
1735: p_application_id => 'PER'
1736: )
1737: || ' => ';
1738:
1739: FOR i IN 1 .. fnd_msg_pub.count_msg
1740: LOOP
1741: error_message :=
1742: error_message || fnd_msg_pub.get (p_msg_index => i,
1743: p_encoded => 'F');
1738:
1739: FOR i IN 1 .. fnd_msg_pub.count_msg
1740: LOOP
1741: error_message :=
1742: error_message || fnd_msg_pub.get (p_msg_index => i,
1743: p_encoded => 'F');
1744: END LOOP;
1745:
1746: --bug#3767915
1743: p_encoded => 'F');
1744: END LOOP;
1745:
1746: --bug#3767915
1747: fnd_msg_pub.delete_msg;
1748: --set_appr_status_log(item_type, item_key, 'W',p_log);
1749: upd_train_comps_status := 'W';
1750: WHEN OTHERS
1751: THEN
2072: CLOSE check_contingent_worker;
2073:
2074: CLOSE get_appr_overall_perf;
2075:
2076: FOR i IN 1 .. fnd_msg_pub.count_msg
2077: LOOP
2078: error_message :=
2079: error_message || fnd_msg_pub.get (p_msg_index => i,
2080: p_encoded => 'F');
2075:
2076: FOR i IN 1 .. fnd_msg_pub.count_msg
2077: LOOP
2078: error_message :=
2079: error_message || fnd_msg_pub.get (p_msg_index => i,
2080: p_encoded => 'F');
2081: END LOOP;
2082:
2083: generate_event (appraisal_rec.overall_perf_rating,
2089: p_log,
2090: p_new_appraisal
2091: );
2092: --bug#3767915
2093: fnd_msg_pub.delete_msg;
2094: --set_appr_status_log(item_type, item_key, 'W',p_log);
2095: upd_create_event_status := 'E';
2096: WHEN OTHERS
2097: THEN