eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_COMPLETE_APPRAISAL_SS dependencies on HR_UTILITY

Line 1792: -- hr_utility.trace_on(null,'APPR');

1788: pa.appraisal_template_id = pat.appraisal_template_id
1789: and pa.appraisal_id = c_appraisal_id;
1790: BEGIN
1791: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';
1792: -- hr_utility.trace_on(null,'APPR');
1793: hr_utility.set_location(' Entering:' || l_proc,5);
1794: appraisal_id := wf_engine.GetItemAttrNumber (itemtype => item_type ,
1795: itemkey => item_key ,
1796: aname => 'APPRAISAL_ID',

Line 1793: hr_utility.set_location(' Entering:' || l_proc,5);

1789: and pa.appraisal_id = c_appraisal_id;
1790: BEGIN
1791: l_proc := 'HR_COMPLETE_APPRAISAL_SS.COMPLETE_APPR';
1792: -- hr_utility.trace_on(null,'APPR');
1793: hr_utility.set_location(' Entering:' || l_proc,5);
1794: appraisal_id := wf_engine.GetItemAttrNumber (itemtype => item_type ,
1795: itemkey => item_key ,
1796: aname => 'APPRAISAL_ID',
1797: ignore_notfound => true);

Line 1798: hr_utility.set_location(' Entering:' || l_proc,10);

1794: appraisal_id := wf_engine.GetItemAttrNumber (itemtype => item_type ,
1795: itemkey => item_key ,
1796: aname => 'APPRAISAL_ID',
1797: ignore_notfound => true);
1798: hr_utility.set_location(' Entering:' || l_proc,10);
1799: if appraisal_id is null then
1800: hr_utility.set_location(' Entering:' || l_proc,20);
1801: l_log := l_log || 'No Appraisal Id for this WorkFlow Transaction';
1802: raise lv_no_appraisal;

Line 1800: hr_utility.set_location(' Entering:' || l_proc,20);

1796: aname => 'APPRAISAL_ID',
1797: ignore_notfound => true);
1798: hr_utility.set_location(' Entering:' || l_proc,10);
1799: if appraisal_id is null then
1800: hr_utility.set_location(' Entering:' || l_proc,20);
1801: l_log := l_log || 'No Appraisal Id for this WorkFlow Transaction';
1802: raise lv_no_appraisal;
1803: end if;
1804: open c_appr_template_details(appraisal_id);

Line 1807: hr_utility.set_message(800,'HR_52256_APR_TEMP_MANDATORY');

1803: end if;
1804: open c_appr_template_details(appraisal_id);
1805: fetch c_appr_template_details into l_available_flag,update_personal_profile,l_talent_mang_src_typ;
1806: if (c_appr_template_details%NOTFOUND) then
1807: hr_utility.set_message(800,'HR_52256_APR_TEMP_MANDATORY');
1808: hr_utility.raise_error;
1809: end if;
1810:
1811: hr_utility.set_location(' Entering:' || l_proc,30);

Line 1808: hr_utility.raise_error;

1804: open c_appr_template_details(appraisal_id);
1805: fetch c_appr_template_details into l_available_flag,update_personal_profile,l_talent_mang_src_typ;
1806: if (c_appr_template_details%NOTFOUND) then
1807: hr_utility.set_message(800,'HR_52256_APR_TEMP_MANDATORY');
1808: hr_utility.raise_error;
1809: end if;
1810:
1811: hr_utility.set_location(' Entering:' || l_proc,30);
1812: check_item_attribute(item_type, item_key, gv_appr_compl_status);

Line 1811: hr_utility.set_location(' Entering:' || l_proc,30);

1807: hr_utility.set_message(800,'HR_52256_APR_TEMP_MANDATORY');
1808: hr_utility.raise_error;
1809: end if;
1810:
1811: hr_utility.set_location(' Entering:' || l_proc,30);
1812: check_item_attribute(item_type, item_key, gv_appr_compl_status);
1813: hr_utility.set_location(' Entering:' || l_proc,35);
1814: check_item_attribute(item_type, item_key, gv_upd_appr_status_log);
1815: hr_utility.set_location(' Entering:' || l_proc,40);

Line 1813: hr_utility.set_location(' Entering:' || l_proc,35);

1809: end if;
1810:
1811: hr_utility.set_location(' Entering:' || l_proc,30);
1812: check_item_attribute(item_type, item_key, gv_appr_compl_status);
1813: hr_utility.set_location(' Entering:' || l_proc,35);
1814: check_item_attribute(item_type, item_key, gv_upd_appr_status_log);
1815: hr_utility.set_location(' Entering:' || l_proc,40);
1816: check_item_attribute(item_type, item_key, gv_apply_asses_comps_log);
1817: hr_utility.set_location(' Entering:' || l_proc,45);

Line 1815: hr_utility.set_location(' Entering:' || l_proc,40);

1811: hr_utility.set_location(' Entering:' || l_proc,30);
1812: check_item_attribute(item_type, item_key, gv_appr_compl_status);
1813: hr_utility.set_location(' Entering:' || l_proc,35);
1814: check_item_attribute(item_type, item_key, gv_upd_appr_status_log);
1815: hr_utility.set_location(' Entering:' || l_proc,40);
1816: check_item_attribute(item_type, item_key, gv_apply_asses_comps_log);
1817: hr_utility.set_location(' Entering:' || l_proc,45);
1818: check_item_attribute(item_type, item_key, gv_create_event_log);
1819: hr_utility.set_location(' Entering:' || l_proc,50);

Line 1817: hr_utility.set_location(' Entering:' || l_proc,45);

1813: hr_utility.set_location(' Entering:' || l_proc,35);
1814: check_item_attribute(item_type, item_key, gv_upd_appr_status_log);
1815: hr_utility.set_location(' Entering:' || l_proc,40);
1816: check_item_attribute(item_type, item_key, gv_apply_asses_comps_log);
1817: hr_utility.set_location(' Entering:' || l_proc,45);
1818: check_item_attribute(item_type, item_key, gv_create_event_log);
1819: hr_utility.set_location(' Entering:' || l_proc,50);
1820: check_item_attribute(item_type, item_key, gv_upd_trn_act_status_log);
1821: hr_utility.set_location(' Entering:' || l_proc,55);

Line 1819: hr_utility.set_location(' Entering:' || l_proc,50);

1815: hr_utility.set_location(' Entering:' || l_proc,40);
1816: check_item_attribute(item_type, item_key, gv_apply_asses_comps_log);
1817: hr_utility.set_location(' Entering:' || l_proc,45);
1818: check_item_attribute(item_type, item_key, gv_create_event_log);
1819: hr_utility.set_location(' Entering:' || l_proc,50);
1820: check_item_attribute(item_type, item_key, gv_upd_trn_act_status_log);
1821: hr_utility.set_location(' Entering:' || l_proc,55);
1822:
1823: savepoint complete_appraisal_status;

Line 1821: hr_utility.set_location(' Entering:' || l_proc,55);

1817: hr_utility.set_location(' Entering:' || l_proc,45);
1818: check_item_attribute(item_type, item_key, gv_create_event_log);
1819: hr_utility.set_location(' Entering:' || l_proc,50);
1820: check_item_attribute(item_type, item_key, gv_upd_trn_act_status_log);
1821: hr_utility.set_location(' Entering:' || l_proc,55);
1822:
1823: savepoint complete_appraisal_status;
1824:
1825: -- change the appraisal system status to completed

Line 1828: hr_utility.set_location(' Entering:' || l_proc,60);

1824:
1825: -- change the appraisal system status to completed
1826: -- if this errors out then exit from the procudure
1827: -- with out processing furhter
1828: hr_utility.set_location(' Entering:' || l_proc,60);
1829: change_appr_status(appraisal_id, item_type, item_key, lv_chg_appr_status_log, chg_appr_status);
1830: hr_utility.set_location(' Entering:' || l_proc,70);
1831: set_appr_status_log(item_type, item_key, chg_appr_status, gv_upd_appr_status_log, lv_chg_appr_status_log);
1832: hr_utility.set_location(' Entering:' || l_proc,75);

Line 1830: hr_utility.set_location(' Entering:' || l_proc,70);

1826: -- if this errors out then exit from the procudure
1827: -- with out processing furhter
1828: hr_utility.set_location(' Entering:' || l_proc,60);
1829: change_appr_status(appraisal_id, item_type, item_key, lv_chg_appr_status_log, chg_appr_status);
1830: hr_utility.set_location(' Entering:' || l_proc,70);
1831: set_appr_status_log(item_type, item_key, chg_appr_status, gv_upd_appr_status_log, lv_chg_appr_status_log);
1832: hr_utility.set_location(' Entering:' || l_proc,75);
1833:
1834: -- create and event and add a performance record

Line 1832: hr_utility.set_location(' Entering:' || l_proc,75);

1828: hr_utility.set_location(' Entering:' || l_proc,60);
1829: change_appr_status(appraisal_id, item_type, item_key, lv_chg_appr_status_log, chg_appr_status);
1830: hr_utility.set_location(' Entering:' || l_proc,70);
1831: set_appr_status_log(item_type, item_key, chg_appr_status, gv_upd_appr_status_log, lv_chg_appr_status_log);
1832: hr_utility.set_location(' Entering:' || l_proc,75);
1833:
1834: -- create and event and add a performance record
1835: if l_available_flag is null then
1836: hr_utility.set_location(' Entering:' || l_proc,77);

Line 1836: hr_utility.set_location(' Entering:' || l_proc,77);

1832: hr_utility.set_location(' Entering:' || l_proc,75);
1833:
1834: -- create and event and add a performance record
1835: if l_available_flag is null then
1836: hr_utility.set_location(' Entering:' || l_proc,77);
1837: update_personal_profile := fnd_profile.value('HR_APPLY_COMPETENCIES_TO_PERSON');
1838: l_talent_mang_src_typ := fnd_profile.value('HR_TALENT_MGMT_SRC_TYPE');
1839: end if;
1840: hr_utility.set_location(' Entering:' || l_proc,80);

Line 1840: hr_utility.set_location(' Entering:' || l_proc,80);

1836: hr_utility.set_location(' Entering:' || l_proc,77);
1837: update_personal_profile := fnd_profile.value('HR_APPLY_COMPETENCIES_TO_PERSON');
1838: l_talent_mang_src_typ := fnd_profile.value('HR_TALENT_MGMT_SRC_TYPE');
1839: end if;
1840: hr_utility.set_location(' Entering:' || l_proc,80);
1841: p_new_appraisal := is_new_appraisal(item_type, item_key);
1842: if(update_personal_profile is not null and update_personal_profile = 'Y') then
1843: hr_utility.set_location(' Entering:' || l_proc,85);
1844: apply_to_personal_profile(appraisal_id, lv_apply_pers_comps_log, apply_pers_profile_status, p_new_appraisal,l_talent_mang_src_typ);

Line 1843: hr_utility.set_location(' Entering:' || l_proc,85);

1839: end if;
1840: hr_utility.set_location(' Entering:' || l_proc,80);
1841: p_new_appraisal := is_new_appraisal(item_type, item_key);
1842: if(update_personal_profile is not null and update_personal_profile = 'Y') then
1843: hr_utility.set_location(' Entering:' || l_proc,85);
1844: apply_to_personal_profile(appraisal_id, lv_apply_pers_comps_log, apply_pers_profile_status, p_new_appraisal,l_talent_mang_src_typ);
1845: hr_utility.set_location(' Entering:' || l_proc,90);
1846: set_appr_status_log(item_type, item_key, apply_pers_profile_status, gv_apply_asses_comps_log, lv_apply_pers_comps_log);
1847: hr_utility.set_location(' Entering:' || l_proc,95);

Line 1845: hr_utility.set_location(' Entering:' || l_proc,90);

1841: p_new_appraisal := is_new_appraisal(item_type, item_key);
1842: if(update_personal_profile is not null and update_personal_profile = 'Y') then
1843: hr_utility.set_location(' Entering:' || l_proc,85);
1844: apply_to_personal_profile(appraisal_id, lv_apply_pers_comps_log, apply_pers_profile_status, p_new_appraisal,l_talent_mang_src_typ);
1845: hr_utility.set_location(' Entering:' || l_proc,90);
1846: set_appr_status_log(item_type, item_key, apply_pers_profile_status, gv_apply_asses_comps_log, lv_apply_pers_comps_log);
1847: hr_utility.set_location(' Entering:' || l_proc,95);
1848: end if;
1849:

Line 1847: hr_utility.set_location(' Entering:' || l_proc,95);

1843: hr_utility.set_location(' Entering:' || l_proc,85);
1844: apply_to_personal_profile(appraisal_id, lv_apply_pers_comps_log, apply_pers_profile_status, p_new_appraisal,l_talent_mang_src_typ);
1845: hr_utility.set_location(' Entering:' || l_proc,90);
1846: set_appr_status_log(item_type, item_key, apply_pers_profile_status, gv_apply_asses_comps_log, lv_apply_pers_comps_log);
1847: hr_utility.set_location(' Entering:' || l_proc,95);
1848: end if;
1849:
1850: -- update the OTA status
1851: --update_train_component_status(appraisal_id, item_type, item_key, l_log, p_result_out);

Line 1852: hr_utility.set_location(' Entering:' || l_proc,100);

1848: end if;
1849:
1850: -- update the OTA status
1851: --update_train_component_status(appraisal_id, item_type, item_key, l_log, p_result_out);
1852: hr_utility.set_location(' Entering:' || l_proc,100);
1853: update_train_component_status(appraisal_id, lv_upd_train_comps_status_log, upd_train_comps_status, p_new_appraisal);
1854: hr_utility.set_location(' Entering:' || l_proc,105);
1855: set_appr_status_log(item_type, item_key, upd_train_comps_status, gv_upd_trn_act_status_log, lv_upd_train_comps_status_log);
1856: hr_utility.set_location(' Entering:' || l_proc,110);

Line 1854: hr_utility.set_location(' Entering:' || l_proc,105);

1850: -- update the OTA status
1851: --update_train_component_status(appraisal_id, item_type, item_key, l_log, p_result_out);
1852: hr_utility.set_location(' Entering:' || l_proc,100);
1853: update_train_component_status(appraisal_id, lv_upd_train_comps_status_log, upd_train_comps_status, p_new_appraisal);
1854: hr_utility.set_location(' Entering:' || l_proc,105);
1855: set_appr_status_log(item_type, item_key, upd_train_comps_status, gv_upd_trn_act_status_log, lv_upd_train_comps_status_log);
1856: hr_utility.set_location(' Entering:' || l_proc,110);
1857:
1858: create_event(appraisal_id, lv_upd_create_event_status_log, upd_create_event_status, p_new_appraisal);

Line 1856: hr_utility.set_location(' Entering:' || l_proc,110);

1852: hr_utility.set_location(' Entering:' || l_proc,100);
1853: update_train_component_status(appraisal_id, lv_upd_train_comps_status_log, upd_train_comps_status, p_new_appraisal);
1854: hr_utility.set_location(' Entering:' || l_proc,105);
1855: set_appr_status_log(item_type, item_key, upd_train_comps_status, gv_upd_trn_act_status_log, lv_upd_train_comps_status_log);
1856: hr_utility.set_location(' Entering:' || l_proc,110);
1857:
1858: create_event(appraisal_id, lv_upd_create_event_status_log, upd_create_event_status, p_new_appraisal);
1859: hr_utility.set_location(' Entering:' || l_proc,115);
1860: set_appr_status_log(item_type, item_key, upd_create_event_status, gv_create_event_log, lv_upd_create_event_status_log);

Line 1859: hr_utility.set_location(' Entering:' || l_proc,115);

1855: set_appr_status_log(item_type, item_key, upd_train_comps_status, gv_upd_trn_act_status_log, lv_upd_train_comps_status_log);
1856: hr_utility.set_location(' Entering:' || l_proc,110);
1857:
1858: create_event(appraisal_id, lv_upd_create_event_status_log, upd_create_event_status, p_new_appraisal);
1859: hr_utility.set_location(' Entering:' || l_proc,115);
1860: set_appr_status_log(item_type, item_key, upd_create_event_status, gv_create_event_log, lv_upd_create_event_status_log);
1861: hr_utility.set_location(' Entering:' || l_proc,120);
1862: -- add the following line to disable multi messaging for fixing bug#5947176
1863: hr_multi_message.disable_message_list;

Line 1861: hr_utility.set_location(' Entering:' || l_proc,120);

1857:
1858: create_event(appraisal_id, lv_upd_create_event_status_log, upd_create_event_status, p_new_appraisal);
1859: hr_utility.set_location(' Entering:' || l_proc,115);
1860: set_appr_status_log(item_type, item_key, upd_create_event_status, gv_create_event_log, lv_upd_create_event_status_log);
1861: hr_utility.set_location(' Entering:' || l_proc,120);
1862: -- add the following line to disable multi messaging for fixing bug#5947176
1863: hr_multi_message.disable_message_list;
1864: -- END changes for bug#5947176
1865:

Line 1869: hr_utility.set_location(' Entering:' || l_proc,125);

1865:
1866: post_appraisal_completion(appraisal_id);
1867:
1868: if( chg_appr_status = 'W' or apply_pers_profile_status = 'W' or upd_train_comps_status = 'W' or upd_create_event_status = 'W') then
1869: hr_utility.set_location(' Entering:' || l_proc,125);
1870: p_result_out := 'W';
1871: else
1872: hr_utility.set_location(' Entering:' || l_proc,130);
1873: p_result_out := 'S';

Line 1872: hr_utility.set_location(' Entering:' || l_proc,130);

1868: if( chg_appr_status = 'W' or apply_pers_profile_status = 'W' or upd_train_comps_status = 'W' or upd_create_event_status = 'W') then
1869: hr_utility.set_location(' Entering:' || l_proc,125);
1870: p_result_out := 'W';
1871: else
1872: hr_utility.set_location(' Entering:' || l_proc,130);
1873: p_result_out := 'S';
1874: end if;
1875:
1876:

Line 1886: hr_utility.set_location(' Entering:' || l_proc,200);

1882: -- instead the errors are written to WorkFlow so that appraisal
1883: -- can read and display corresponding message / warning.
1884: WHEN lv_no_appraisal THEN
1885: p_result_out := 'E';
1886: hr_utility.set_location(' Entering:' || l_proc,200);
1887: set_appr_status_log(item_type, item_key, 'E', gv_upd_appr_status_log, lv_chg_appr_status_log);
1888: WHEN others THEN
1889: hr_utility.set_location(' Entering:' || l_proc,300);
1890: rollback to complete_appraisal_status;

Line 1889: hr_utility.set_location(' Entering:' || l_proc,300);

1885: p_result_out := 'E';
1886: hr_utility.set_location(' Entering:' || l_proc,200);
1887: set_appr_status_log(item_type, item_key, 'E', gv_upd_appr_status_log, lv_chg_appr_status_log);
1888: WHEN others THEN
1889: hr_utility.set_location(' Entering:' || l_proc,300);
1890: rollback to complete_appraisal_status;
1891: p_result_out := 'E';
1892: set_appr_status_log(item_type, item_key, 'E', gv_upd_appr_status_log, lv_chg_appr_status_log);
1893: END; -- Procedure