'
749: || ''
750: || ''
751: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_COMPETENCY',
752: p_application_id => 'PER'
753: )
754: || ' | '
755: || ''
Line 756: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEVEL',
752: p_application_id => 'PER'
753: )
754: || ' | '
755: || ''
756: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEVEL',
757: p_application_id => 'PER'
758: )
759: || ' | '
760: || ''
Line 761: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_RESULT',
757: p_application_id => 'PER'
758: )
759: || ' | '
760: || ''
761: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_RESULT',
762: p_application_id => 'PER'
763: )
764: || ' | '
765: || ''
Line 766: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_REASON',
762: p_application_id => 'PER'
763: )
764: || ' | '
765: || ''
766: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_REASON',
767: p_application_id => 'PER'
768: )
769: || ' | '
770: || '
';
921:
922: -- End for competence qualification link enhancement
923: each_comp_status := 'S';
924:
925: --p_log := p_log || '
' || assess_comps.name || ' => ' || hr_util_misc_web.return_msg_text(
926: -- p_message_name=>'HR_ASSESS_COMP_SUCC',
927: -- p_Application_id=>'PER') ||' ';
928: IF p_new_appraisal
929: THEN
Line 934: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
930: l_comp_log :=
931: l_comp_log
932: || assess_comps.competence_element_id
933: || '^'
934: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
935: p_application_id => 'PER'
936: )
937: || '~';
938: ELSE
Line 949: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
945:
'
946: || assess_comps.prof_level
947: || ' |
948: '
949: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
950: p_application_id => 'PER'
951: )
952: || ' |
953: '
Line 982: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
978: l_comp_log :=
979: l_comp_log
980: || assess_comps.competence_element_id
981: || '^'
982: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
983: p_application_id => 'PER'
984: )
985: || '^'
986: || error_message
Line 999: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
995: | '
996: || assess_comps.prof_level
997: || ' |
998: '
999: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1000: p_application_id => 'PER'
1001: )
1002: || ' |
1003: '
Line 1029: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1025: l_comp_log :=
1026: l_comp_log
1027: || assess_comps.competence_element_id
1028: || '^'
1029: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1030: p_application_id => 'PER'
1031: )
1032: || '^'
1033: || error_message
Line 1046: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1042: | '
1043: || assess_comps.prof_level
1044: || ' |
1045: '
1046: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1047: p_application_id => 'PER'
1048: )
1049: || ' |
1050: '
1112: -- added for competence qual enhancement
1113: );
1114: each_comp_status := 'S';
1115:
1116: --p_log := p_log || ' ' || assess_comps.name || ' => ' || hr_util_misc_web.return_msg_text(
1117: -- p_message_name=>'HR_ASSESS_COMP_SUCC',
1118: -- p_Application_id=>'PER') || '';
1119: IF p_new_appraisal
1120: THEN
Line 1125: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1121: l_comp_log :=
1122: l_comp_log
1123: || assess_comps.competence_element_id
1124: || '^'
1125: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1126: p_application_id => 'PER'
1127: )
1128: || '~';
1129: ELSE
Line 1140: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1136: | '
1137: || assess_comps.prof_level
1138: || ' |
1139: '
1140: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1141: p_application_id => 'PER'
1142: )
1143: || ' |
1144: '
Line 1174: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1170: l_comp_log :=
1171: l_comp_log
1172: || assess_comps.competence_element_id
1173: || '^'
1174: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1175: p_application_id => 'PER'
1176: )
1177: || '^'
1178: || error_message
Line 1191: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1187: | '
1188: || assess_comps.prof_level
1189: || ' |
1190: '
1191: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1192: p_application_id => 'PER'
1193: )
1194: || ' |
1195: '
Line 1221: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1217: l_comp_log :=
1218: l_comp_log
1219: || assess_comps.competence_element_id
1220: || '^'
1221: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1222: p_application_id => 'PER'
1223: )
1224: || '^'
1225: || error_message
Line 1238: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1234: | '
1235: || assess_comps.prof_level
1236: || ' |
1237: '
1238: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1239: p_application_id => 'PER'
1240: )
1241: || ' |
1242: '
Line 1292: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1288: l_comp_log :=
1289: l_comp_log
1290: || '-1'
1291: || '^'
1292: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1293: p_application_id => 'PER'
1294: )
1295: || '^'
1296: || error_message
Line 1307: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1303: || ' |
1304: '
1305: || ' |
1306: '
1307: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1308: p_application_id => 'PER'
1309: )
1310: || ' |
1311: '
Line 1390: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_LP_COURSE',
1386: || ' | '
1387: || ''
1388: || ''
1389: || ''
1390: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_LP_COURSE',
1391: p_application_id => 'PER'
1392: )
1393: || ' | '
1394: || ''
Line 1395: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_STATUS',
1391: p_application_id => 'PER'
1392: )
1393: || ' | '
1394: || ''
1395: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_STATUS',
1396: p_application_id => 'PER'
1397: )
1398: || ' | '
1399: || ''
Line 1400: || hr_util_misc_web.return_msg_text
1396: p_application_id => 'PER'
1397: )
1398: || ' | '
1399: || ''
1400: || hr_util_misc_web.return_msg_text
1401: (p_message_name => 'HR_LP_COURSE_TARGET_DATE',
1402: p_application_id => 'PER'
1403: )
1404: || ' | '
Line 1406: || hr_util_misc_web.return_msg_text
1402: p_application_id => 'PER'
1403: )
1404: || ''
1405: || ' '
1406: || hr_util_misc_web.return_msg_text
1407: (p_message_name => 'HR_LP_COURSE_COMP_DATE',
1408: p_application_id => 'PER'
1409: )
1410: || ' | '
Line 1542: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEARNING_PATH',
1538: || ' '
1539: || ' '
1540: || ''
1541: || ' '
1542: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEARNING_PATH',
1543: p_application_id => 'PER'
1544: )
1545: || ' | '
1546: || ' '
Line 1559: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEARNING_PATH',
1555: || ' '
1556: || ''
1557: || ''
1558: || ''
1559: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LEARNING_PATH',
1560: p_application_id => 'PER'
1561: )
1562: || ' | '
1563: || ''
Line 1564: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_STATUS',
1560: p_application_id => 'PER'
1561: )
1562: || ' | '
1563: || ''
1564: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_STATUS',
1565: p_application_id => 'PER'
1566: )
1567: || ' | '
1568: || ''
Line 1569: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_RESULT',
1565: p_application_id => 'PER'
1566: )
1567: || ' | '
1568: || ''
1569: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_RESULT',
1570: p_application_id => 'PER'
1571: )
1572: || ' | '
1573: || ''
Line 1574: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_REASON',
1570: p_application_id => 'PER'
1571: )
1572: || ' | '
1573: || ''
1574: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_REASON',
1575: p_application_id => 'PER'
1576: )
1577: || ' | '
1578: || ' ';
Line 1601: || hr_util_misc_web.return_msg_text
1597: WHEN hr_multi_message.error_message_exist
1598: THEN
1599: error_message :=
1600: error_message
1601: || hr_util_misc_web.return_msg_text
1602: (p_message_name => 'HR_APPR_DISP_TO_LEARNER',
1603: p_application_id => 'PER'
1604: )
1605: || ' => ';
Line 1622: || hr_util_misc_web.return_msg_text
1618: WHEN OTHERS
1619: THEN
1620: error_message :=
1621: error_message
1622: || hr_util_misc_web.return_msg_text
1623: (p_message_name => 'HR_APPR_DISP_TO_LEARNER',
1624: p_application_id => 'PER'
1625: )
1626: || ' => '
Line 1651: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_STATUS',
1647: WHEN hr_multi_message.error_message_exist
1648: THEN
1649: error_message :=
1650: error_message
1651: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_STATUS',
1652: p_application_id => 'PER'
1653: )
1654: || ' => ';
1655:
Line 1671: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_STATUS',
1667: WHEN OTHERS
1668: THEN
1669: error_message :=
1670: error_message
1671: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_STATUS',
1672: p_application_id => 'PER'
1673: )
1674: || ' => '
1675: || SQLERRM;
Line 1691: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_COMPLETE',
1687: WHEN hr_multi_message.error_message_exist
1688: THEN
1689: error_message :=
1690: error_message
1691: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_COMPLETE',
1692: p_application_id => 'PER'
1693: )
1694: || ' => ';
1695:
Line 1706: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_COMPLETE',
1702: WHEN OTHERS
1703: THEN
1704: error_message :=
1705: error_message
1706: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_APPR_LP_COMPLETE',
1707: p_application_id => 'PER'
1708: )
1709: || ' => '
1710: || SQLERRM;
Line 1733: || hr_util_misc_web.return_msg_text
1729: WHEN hr_multi_message.error_message_exist
1730: THEN
1731: error_message :=
1732: error_message
1733: || hr_util_misc_web.return_msg_text
1734: (p_message_name => 'HR_APPR_LP_COMPLETE',
1735: p_application_id => 'PER'
1736: )
1737: || ' => ';
Line 1754: || hr_util_misc_web.return_msg_text
1750: WHEN OTHERS
1751: THEN
1752: error_message :=
1753: error_message
1754: || hr_util_misc_web.return_msg_text
1755: (p_message_name => 'HR_APPR_LP_COMPLETE',
1756: p_application_id => 'PER'
1757: )
1758: || ' => '
Line 1785: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1781: THEN
1782: p_log :=
1783: l_lp_id
1784: || '^'
1785: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1786: p_application_id => 'PER'
1787: )
1788: || '^';
1789: ELSE
Line 1793: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1789: ELSE
1790: p_log :=
1791: l_lp_id
1792: || '^'
1793: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1794: p_application_id => 'PER'
1795: )
1796: || '^'
1797: || error_message;
Line 1812: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1808: || ' '
1809: || l_completion_status
1810: || ' | '
1811: || ''
1812: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
1813: p_application_id => 'PER'
1814: )
1815: || ' | '
1816: || ''
Line 1840: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1836: || ' | '
1837: || l_completion_status
1838: || ' | '
1839: || ''
1840: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1841: p_application_id => 'PER'
1842: )
1843: || ' | '
1844: || ''
Line 1896: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1892: THEN
1893: p_log :=
1894: l_lp_id
1895: || '^'
1896: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1897: p_application_id => 'PER'
1898: )
1899: || '^'
1900: || error_message;
Line 1912: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1908: || ' | '
1909: || l_path_status
1910: || ' | '
1911: || ''
1912: || hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
1913: p_application_id => 'PER'
1914: )
1915: || ' | '
1916: || ''
Line 2046: hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
2042: );
2043: found_overall_performance := TRUE;
2044: generate_event (appraisal_rec.overall_perf_rating,
2045: TRUNC (SYSDATE),
2046: hr_util_misc_web.return_msg_text (p_message_name => 'HR_SUCCESS',
2047: p_application_id => 'PER'
2048: ),
2049: NULL,
2050: p_log,
Line 2085: hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
2081: END LOOP;
2082:
2083: generate_event (appraisal_rec.overall_perf_rating,
2084: TRUNC (SYSDATE),
2085: hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
2086: p_application_id => 'PER'
2087: ),
2088: error_message,
2089: p_log,
Line 2102: hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
2098: error_message := error_message || SQLERRM;
2099: upd_create_event_status := 'W';
2100: generate_event (appraisal_rec.overall_perf_rating,
2101: TRUNC (SYSDATE),
2102: hr_util_misc_web.return_msg_text (p_message_name => 'HR_FAILURE',
2103: p_application_id => 'PER'
2104: ),
2105: error_message,
2106: p_log,
| | |