1266: end if;
1267: ln_activityId := null;
1268: when others then
1269: ln_activityId := null;
1270: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1271: hr_utility.raise_error;
1272: end;
1273:
1274: if(ln_activityId is not null) then
1324: end if;
1325:
1326: EXCEPTION
1327: WHEN OTHERS THEN
1328: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1329: hr_utility.raise_error;
1330: END getPageDetails;
1331:
1332: function GetItemAttrText(itemtype in varchar2,
1836: WHERE wrpv.item_type = itemtype
1837: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1838: AND rownum <=1;
1839: else
1840: fnd_message.set_name('PER',lv_ntf_sub_msg);
1841: getProcessDisplayName.lv_display_name := fnd_message.get;
1842: end if;
1843:
1844: exception
1837: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1838: AND rownum <=1;
1839: else
1840: fnd_message.set_name('PER',lv_ntf_sub_msg);
1841: getProcessDisplayName.lv_display_name := fnd_message.get;
1842: end if;
1843:
1844: exception
1845: when others then
1974:
1975: if(lv_ntf_sub_msg is null) then
1976: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1977: else
1978: fnd_message.set_name('PER',lv_ntf_sub_msg);
1979: lv_process_display_name:= fnd_message.get;
1980: end if;
1981:
1982:
1975: if(lv_ntf_sub_msg is null) then
1976: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
1977: else
1978: fnd_message.set_name('PER',lv_ntf_sub_msg);
1979: lv_process_display_name:= fnd_message.get;
1980: end if;
1981:
1982:
1983: l_creator_person_id:= wf_engine.GetItemAttrNumber
2014: -- "Change Job for Doe, John "
2015: if g_debug then
2016: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2017: end if;
2018: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2019: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2020: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2021: document := fnd_message.get;
2022:
2015: if g_debug then
2016: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2017: end if;
2018: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2019: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2020: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2021: document := fnd_message.get;
2022:
2023: else
2016: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2017: end if;
2018: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2019: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2020: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2021: document := fnd_message.get;
2022:
2023: else
2024: -- get creator display name from role
2017: end if;
2018: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2019: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2020: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2021: document := fnd_message.get;
2022:
2023: else
2024: -- get creator display name from role
2025: if g_debug then
2071: if g_debug then
2072: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2073: end if;
2074:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2077: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2078: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2079: document := fnd_message.get;
2072: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2073: end if;
2074:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2077: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2078: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2079: document := fnd_message.get;
2080: end if;
2073: end if;
2074:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2077: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2078: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2079: document := fnd_message.get;
2080: end if;
2081:
2074:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2077: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2078: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2079: document := fnd_message.get;
2080: end if;
2081:
2082:
2075: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2076: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2077: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2078: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2079: document := fnd_message.get;
2080: end if;
2081:
2082:
2083: -- set the document type
2326: end if;
2327:
2328: EXCEPTION
2329: WHEN OTHERS THEN
2330: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
2331: hr_utility.raise_error;
2332: return null;
2333: end getNextApproverForHist;
2334: