1308: end if;
1309: ln_activityId := null;
1310: when others then
1311: ln_activityId := null;
1312: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1313: hr_utility.raise_error;
1314: end;
1315:
1316: if(ln_activityId is not null) then
1366: end if;
1367:
1368: EXCEPTION
1369: WHEN OTHERS THEN
1370: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
1371: hr_utility.raise_error;
1372: END getPageDetails;
1373:
1374: function GetItemAttrText(itemtype in varchar2,
1878: WHERE wrpv.item_type = itemtype
1879: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1880: AND rownum <=1;
1881: else
1882: fnd_message.set_name('PER',lv_ntf_sub_msg);
1883: getProcessDisplayName.lv_display_name := fnd_message.get;
1884: end if;
1885:
1886: exception
1879: AND wrpv.process_name = wf_engine.GetItemAttrText (itemtype,itemkey,'PROCESS_NAME')
1880: AND rownum <=1;
1881: else
1882: fnd_message.set_name('PER',lv_ntf_sub_msg);
1883: getProcessDisplayName.lv_display_name := fnd_message.get;
1884: end if;
1885:
1886: exception
1887: when others then
2016:
2017: if(lv_ntf_sub_msg is null) then
2018: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2019: else
2020: fnd_message.set_name('PER',lv_ntf_sub_msg);
2021: lv_process_display_name:= fnd_message.get;
2022: end if;
2023:
2024:
2017: if(lv_ntf_sub_msg is null) then
2018: lv_process_display_name := hr_workflow_ss.getProcessDisplayName(lv_item_type,lv_item_key);
2019: else
2020: fnd_message.set_name('PER',lv_ntf_sub_msg);
2021: lv_process_display_name:= fnd_message.get;
2022: end if;
2023:
2024:
2025: l_creator_person_id:= wf_engine.GetItemAttrNumber
2058: -- "Change Job for Doe, John "
2059: if g_debug then
2060: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2061: end if;
2062: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2063: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2064: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2065: document := fnd_message.get;
2066:
2059: if g_debug then
2060: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2061: end if;
2062: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2063: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2064: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2065: document := fnd_message.get;
2066:
2067: else
2060: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_SELF',19);
2061: end if;
2062: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2063: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2064: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2065: document := fnd_message.get;
2066:
2067: else
2068: -- get creator display name from role
2061: end if;
2062: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_SELF');
2063: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2064: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2065: document := fnd_message.get;
2066:
2067: else
2068: -- get creator display name from role
2069: if g_debug then
2115: if g_debug then
2116: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2117: end if;
2118:
2119: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2120: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2121: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2122: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2123: document := fnd_message.get;
2116: hr_utility.set_location('Getting message HR_SS_APPROVER_MSG_SUB_REPORTS',22);
2117: end if;
2118:
2119: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2120: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2121: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2122: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2123: document := fnd_message.get;
2124: end if;
2117: end if;
2118:
2119: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2120: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2121: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2122: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2123: document := fnd_message.get;
2124: end if;
2125:
2118:
2119: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2120: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2121: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2122: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2123: document := fnd_message.get;
2124: end if;
2125:
2126:
2119: fnd_message.set_name('PER','HR_SS_APPROVER_MSG_SUB_REPORTS');
2120: fnd_message.set_token('PROCESS_DISPLAY_NAME',lv_process_display_name,false);
2121: fnd_message.set_token('CURRENT_PERSON_DISPLAY_NAME',l_current_disp_name,false);
2122: fnd_message.set_token('CREATOR_PERSON_DISPLAY_NAME',l_creator_disp_name,false);
2123: document := fnd_message.get;
2124: end if;
2125:
2126:
2127: -- set the document type
2394: end if;
2395:
2396: EXCEPTION
2397: WHEN OTHERS THEN
2398: fnd_message.set_name('PER', SQLERRM ||' '||to_char(SQLCODE));
2399: hr_utility.raise_error;
2400: return null;
2401: end getNextApproverForHist;
2402: