441: aname => 'TC_FROM_ROLE',
442: avalue => l_tc_from_role);
443:
444:
445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
442: avalue => l_tc_from_role);
443:
444:
445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
443:
444:
445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
451: l_fyi_subject :=fnd_message.get();
444:
445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
451: l_fyi_subject :=fnd_message.get();
452:
445: fnd_message.set_name('HXC','HXC_APPR_TO_PREPARER');
446: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
451: l_fyi_subject :=fnd_message.get();
452:
453: wf_engine.SetItemAttrText(
447: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
448: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
449: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_tc_from_role,l_tc_start_date));
450:
451: l_fyi_subject :=fnd_message.get();
452:
453: wf_engine.SetItemAttrText(
454: itemtype => p_itemtype,
455: itemkey => p_itemkey,
502: l_apr_name := wf_engine.GetItemAttrText(itemtype => p_itemtype,
503: itemkey => p_itemkey,
504: aname => 'TC_APPROVER_FROM_ROLE');
505:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
503: itemkey => p_itemkey,
504: aname => 'TC_APPROVER_FROM_ROLE');
505:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
504: aname => 'TC_APPROVER_FROM_ROLE');
505:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
512: l_fyi_subject :=fnd_message.get();
505:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
512: l_fyi_subject :=fnd_message.get();
513:
506: fnd_message.set_name('HXC','HXC_APPR_TO_ADMIN');
507: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
512: l_fyi_subject :=fnd_message.get();
513:
514:
508: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
509: fnd_message.set_token('WORKER_FULL_NAME',l_worker_full_name);
510: fnd_message.set_token('APPROVER_FULL_NAME',hxc_approval_wf_helper.find_full_name_from_role(l_apr_name,l_tc_start_date));
511:
512: l_fyi_subject :=fnd_message.get();
513:
514:
515:
516: wf_engine.SetItemAttrText(