[Home] [Help]
1139: --There is a possibility that worker may not be having SS login, in that case worker role will be null.
1140: --But we need to have worker full name for various notification purposes, hence we need to check worker role
1141: --for null, if it is null we need to fetch from the per tables.
1142: if l_worker_role is null then
1143: l_worker_full_name :=hxc_find_notify_aprs_pkg.get_name(l_resource_id,l_tc_stop_date);
1144: else
1145: l_worker_full_name := find_full_name_from_role(l_worker_role,l_tc_start_date);
1146: end if;
1147:
1208: wf_engine.SetItemAttrText
1209: (itemtype => itemtype,
1210: itemkey => itemkey,
1211: aname => 'DESCRIPTION',
1212: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1213: --set FYI_SUBJECT
1214: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1215: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1288: wf_engine.SetItemAttrText
1289: (itemtype => itemtype,
1290: itemkey => itemkey,
1291: aname => 'DESCRIPTION',
1292: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1293:
1294: --set FYI_SUBJECT
1295: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1296: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1361: --set DESCRIPTION
1362: wf_engine.SetItemAttrText(itemtype => itemtype,
1363: itemkey => itemkey,
1364: aname => 'DESCRIPTION',
1365: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));
1366:
1367: -- for bug 8888588
1368: l_exclude_hours := hxc_notification_process_pkg.evaluate_abs_pref
1369: (l_resource_id,
1469: wf_engine.SetItemAttrText
1470: (itemtype => itemtype,
1471: itemkey => itemkey,
1472: aname => 'DESCRIPTION',
1473: avalue => hxc_find_notify_aprs_pkg.get_description_date(l_effective_start_date,l_effective_end_date,l_resource_id));
1474:
1475: --set FYI_SUBJECT
1476: l_tc_to_role :=wf_engine.GetItemAttrText(
1477: itemtype => itemtype,
1534: wf_engine.SetItemAttrText
1535: (itemtype => itemtype,
1536: itemkey => itemkey,
1537: aname => 'DESCRIPTION',
1538: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1539:
1540: --set FYI_SUBJECT
1541: l_apr_person_id :=wf_engine.GetItemAttrText(
1542: itemtype => itemtype,
1541: l_apr_person_id :=wf_engine.GetItemAttrText(
1542: itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'APR_PERSON_ID');
1545: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1546: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1547: l_supervisor_id,SYSDATE);
1548: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1549: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1542: itemtype => itemtype,
1543: itemkey => itemkey,
1544: aname => 'APR_PERSON_ID');
1545: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1546: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1547: l_supervisor_id,SYSDATE);
1548: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1549: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1550: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1558: itemkey => itemkey,
1559: aname => 'FYI_SUBJECT',
1560: avalue => l_fyi_subject);
1561: --set FYI_RECIPIENT_LOGIN
1562: l_tc_from_role :=hxc_find_notify_aprs_pkg.get_login(p_person_id => l_apr_person_id);
1563:
1564: wf_engine.SetItemAttrText(
1565: itemtype => itemtype,
1566: itemkey => itemkey,