492: aname => 'TC_FROM_ROLE',
493: avalue => l_tc_from_role);
494:
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
493: avalue => l_tc_from_role);
494:
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
494:
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();
495:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();
503:
496: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
497: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();
503:
504: wf_engine.SetItemAttrText(
498: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
499: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
500: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
501:
502: l_fyi_subject :=fnd_message.get();
503:
504: wf_engine.SetItemAttrText(
505: itemtype => p_itemtype,
506: itemkey => p_itemkey,
553: l_apr_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
554: itemkey => p_itemkey,
555: aname => 'TC_APPROVER_FROM_ROLE');
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
554: itemkey => p_itemkey,
555: aname => 'TC_APPROVER_FROM_ROLE');
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
555: aname => 'TC_APPROVER_FROM_ROLE');
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();
556:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();
564:
557: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
558: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();
564:
565:
559: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
560: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
561: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
562:
563: l_fyi_subject :=fnd_message.get();
564:
565:
566:
567: wf_engine.SetItemAttrText(