eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_APPROVAL_WF_HELPER dependencies on FND_MESSAGE

Line 1194: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

1190: itemkey => itemkey,
1191: aname => 'TC_FROM_ROLE',
1192: avalue => l_tc_from_role);
1193: --set TITLE
1194: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1195: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1197:
1198: l_title := fnd_message.get();

Line 1195: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1191: aname => 'TC_FROM_ROLE',
1192: avalue => l_tc_from_role);
1193: --set TITLE
1194: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1195: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1197:
1198: l_title := fnd_message.get();
1199:

Line 1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1192: avalue => l_tc_from_role);
1193: --set TITLE
1194: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1195: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1197:
1198: l_title := fnd_message.get();
1199:
1200: wf_engine.SetItemAttrText(

Line 1198: l_title := fnd_message.get();

1194: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1195: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1196: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1197:
1198: l_title := fnd_message.get();
1199:
1200: wf_engine.SetItemAttrText(
1201: itemtype => itemtype,
1202: itemkey => itemkey,

Line 1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');

1209: itemkey => itemkey,
1210: aname => 'DESCRIPTION',
1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1212: --set FYI_SUBJECT
1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:

Line 1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1210: aname => 'DESCRIPTION',
1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1212: --set FYI_SUBJECT
1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:
1218: l_fyi_subject :=fnd_message.get();

Line 1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1211: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1212: --set FYI_SUBJECT
1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:
1218: l_fyi_subject :=fnd_message.get();
1219:

Line 1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

1212: --set FYI_SUBJECT
1213: fnd_message.set_name('HXC','HXC_APPR_AUTO_WORKER');
1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:
1218: l_fyi_subject :=fnd_message.get();
1219:
1220: wf_engine.SetItemAttrText(

Line 1218: l_fyi_subject :=fnd_message.get();

1214: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1215: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1216: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1217:
1218: l_fyi_subject :=fnd_message.get();
1219:
1220: wf_engine.SetItemAttrText(
1221: itemtype => itemtype,
1222: itemkey => itemkey,

Line 1275: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

1271: itemkey => itemkey,
1272: aname => 'TC_FROM_ROLE',
1273: avalue => l_tc_from_role);
1274: --set TITLE
1275: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1276: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1278:
1279: l_title := fnd_message.get();

Line 1276: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1272: aname => 'TC_FROM_ROLE',
1273: avalue => l_tc_from_role);
1274: --set TITLE
1275: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1276: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1278:
1279: l_title := fnd_message.get();
1280:

Line 1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1273: avalue => l_tc_from_role);
1274: --set TITLE
1275: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1276: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1278:
1279: l_title := fnd_message.get();
1280:
1281: wf_engine.SetItemAttrText(

Line 1279: l_title := fnd_message.get();

1275: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1276: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1277: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1278:
1279: l_title := fnd_message.get();
1280:
1281: wf_engine.SetItemAttrText(
1282: itemtype => itemtype,
1283: itemkey => itemkey,

Line 1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');

1290: aname => 'DESCRIPTION',
1291: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1292:
1293: --set FYI_SUBJECT
1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

Line 1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);

1291: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
1292:
1293: --set FYI_SUBJECT
1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:

Line 1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1292:
1293: --set FYI_SUBJECT
1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:
1300: l_fyi_subject :=fnd_message.get();

Line 1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1293: --set FYI_SUBJECT
1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:
1300: l_fyi_subject :=fnd_message.get();
1301:

Line 1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

1294: fnd_message.set_name('HXC','HXC_APPR_REJ_PREPARER');
1295: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:
1300: l_fyi_subject :=fnd_message.get();
1301:
1302: wf_engine.SetItemAttrText(

Line 1300: l_fyi_subject :=fnd_message.get();

1296: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1297: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1299:
1300: l_fyi_subject :=fnd_message.get();
1301:
1302: wf_engine.SetItemAttrText(
1303: itemtype => itemtype,
1304: itemkey => itemkey,

Line 1349: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

1345: aname => 'TC_FROM_ROLE',
1346: avalue => l_preparer_role);
1347:
1348: --set TITLE
1349: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1350: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1352:
1353: l_title := fnd_message.get();

Line 1350: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1346: avalue => l_preparer_role);
1347:
1348: --set TITLE
1349: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1350: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1352:
1353: l_title := fnd_message.get();
1354:

Line 1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1347:
1348: --set TITLE
1349: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1350: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1352:
1353: l_title := fnd_message.get();
1354:
1355: wf_engine.SetItemAttrText(

Line 1353: l_title := fnd_message.get();

1349: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1350: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1351: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1352:
1353: l_title := fnd_message.get();
1354:
1355: wf_engine.SetItemAttrText(
1356: itemtype => itemtype,
1357: itemkey => itemkey,

Line 1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');

1362: itemkey => itemkey,
1363: aname => 'DESCRIPTION',
1364: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));
1365: --set FYI_SUBJECT
1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

Line 1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1364: avalue => hxc_find_notify_aprs_pkg.get_description_tc(l_timecard_id,l_timecard_ovn));
1365: --set FYI_SUBJECT
1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);

Line 1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1365: --set FYI_SUBJECT
1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:

Line 1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

1366: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:
1374: l_fyi_subject :=fnd_message.get();

Line 1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);

1367:
1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:
1374: l_fyi_subject :=fnd_message.get();
1375:

Line 1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);

1368: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1369: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:
1374: l_fyi_subject :=fnd_message.get();
1375:
1376: wf_engine.SetItemAttrText(

Line 1374: l_fyi_subject :=fnd_message.get();

1370: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1371: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1372: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1373:
1374: l_fyi_subject :=fnd_message.get();
1375:
1376: wf_engine.SetItemAttrText(
1377: itemtype => itemtype,
1378: itemkey => itemkey,

Line 1440: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

1436: aname => 'TC_FROM_ROLE',
1437: avalue => l_worker_role);
1438: --set TITLE
1439: hr_utility.trace('set TITLE');
1440: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1441: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1443:
1444: l_title := fnd_message.get();

Line 1441: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1437: avalue => l_worker_role);
1438: --set TITLE
1439: hr_utility.trace('set TITLE');
1440: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1441: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1443:
1444: l_title := fnd_message.get();
1445:

Line 1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1438: --set TITLE
1439: hr_utility.trace('set TITLE');
1440: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1441: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1443:
1444: l_title := fnd_message.get();
1445:
1446: wf_engine.SetItemAttrText(

Line 1444: l_title := fnd_message.get();

1440: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1441: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1442: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1443:
1444: l_title := fnd_message.get();
1445:
1446: wf_engine.SetItemAttrText(
1447: itemtype => itemtype,
1448: itemkey => itemkey,

Line 1464: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');

1460: itemtype => itemtype,
1461: itemkey => itemkey,
1462: aname => 'TC_APPROVER_FROM_ROLE');
1463:
1464: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:

Line 1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1461: itemkey => itemkey,
1462: aname => 'TC_APPROVER_FROM_ROLE');
1463:
1464: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:
1469: l_fyi_subject :=fnd_message.get();

Line 1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1462: aname => 'TC_APPROVER_FROM_ROLE');
1463:
1464: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:
1469: l_fyi_subject :=fnd_message.get();
1470:

Line 1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

1463:
1464: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:
1469: l_fyi_subject :=fnd_message.get();
1470:
1471: wf_engine.SetItemAttrText(

Line 1469: l_fyi_subject :=fnd_message.get();

1465: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1466: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1467: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1468:
1469: l_fyi_subject :=fnd_message.get();
1470:
1471: wf_engine.SetItemAttrText(
1472: itemtype => itemtype,
1473: itemkey => itemkey,

Line 1505: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');

1501: itemkey => itemkey,
1502: aname => 'TC_FROM_ROLE',
1503: avalue => l_preparer_role);
1504: --set TITLE
1505: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1506: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1508:
1509: l_title := fnd_message.get();

Line 1506: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1502: aname => 'TC_FROM_ROLE',
1503: avalue => l_preparer_role);
1504: --set TITLE
1505: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1506: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1508:
1509: l_title := fnd_message.get();
1510:

Line 1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1503: avalue => l_preparer_role);
1504: --set TITLE
1505: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1506: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1508:
1509: l_title := fnd_message.get();
1510:
1511: wf_engine.SetItemAttrText(

Line 1509: l_title := fnd_message.get();

1505: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1506: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1507: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1508:
1509: l_title := fnd_message.get();
1510:
1511: wf_engine.SetItemAttrText(
1512: itemtype => itemtype,
1513: itemkey => itemkey,

Line 1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');

1527: aname => 'APR_PERSON_ID');
1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);

Line 1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);

1528: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:

Line 1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1529: l_supervisor_name :=hxc_find_notify_aprs_pkg.get_name(
1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:
1537: l_fyi_subject :=fnd_message.get();

Line 1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1530: l_supervisor_id,SYSDATE);
1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:
1537: l_fyi_subject :=fnd_message.get();
1538:

Line 1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);

1531: fnd_message.set_name('HXC','HXC_APPR_TRAN_APPROVER');
1532: fnd_message.set_token('APPROVER_FULL_NAME',l_preparer_full_name);
1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:
1537: l_fyi_subject :=fnd_message.get();
1538:
1539: wf_engine.SetItemAttrText(

Line 1537: l_fyi_subject :=fnd_message.get();

1533: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1534: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1535: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1536:
1537: l_fyi_subject :=fnd_message.get();
1538:
1539: wf_engine.SetItemAttrText(
1540: itemtype => itemtype,
1541: itemkey => itemkey,

Line 1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');

1582: aname => 'TC_FROM_ROLE',
1583: avalue => l_tc_from_role);
1584:
1585: --set FYI_SUBJECT
1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

Line 1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);

1583: avalue => l_tc_from_role);
1584:
1585: --set FYI_SUBJECT
1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:

Line 1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1584:
1585: --set FYI_SUBJECT
1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:
1592: l_fyi_subject :=fnd_message.get();

Line 1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

1585: --set FYI_SUBJECT
1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:
1592: l_fyi_subject :=fnd_message.get();
1593:

Line 1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

1586: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1587: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:
1592: l_fyi_subject :=fnd_message.get();
1593:
1594: wf_engine.SetItemAttrText(

Line 1592: l_fyi_subject :=fnd_message.get();

1588: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1589: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1590: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1591:
1592: l_fyi_subject :=fnd_message.get();
1593:
1594: wf_engine.SetItemAttrText(
1595: itemtype => itemtype,
1596: itemkey => itemkey,

Line 1601: fnd_message.set_name('HXC','HXC_APPR_NO_DETAILS_BODY');

1597: aname => 'FYI_SUBJECT',
1598: avalue => l_fyi_subject);
1599:
1600: -- set FYI_NO_DETAIL_BODY
1601: fnd_message.set_name('HXC','HXC_APPR_NO_DETAILS_BODY');
1602: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1603:
1604:
1605:

Line 1602: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);

1598: avalue => l_fyi_subject);
1599:
1600: -- set FYI_NO_DETAIL_BODY
1601: fnd_message.set_name('HXC','HXC_APPR_NO_DETAILS_BODY');
1602: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1603:
1604:
1605:
1606: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1610: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);

1606: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,
1607: itemkey => itemkey,
1608: aname => 'APR_REJ_REASON');
1609:
1610: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1611:
1612: l_fyi_no_detail_body :=fnd_message.get();
1613:
1614: wf_engine.SetItemAttrText(

Line 1612: l_fyi_no_detail_body :=fnd_message.get();

1608: aname => 'APR_REJ_REASON');
1609:
1610: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1611:
1612: l_fyi_no_detail_body :=fnd_message.get();
1613:
1614: wf_engine.SetItemAttrText(
1615: itemtype => itemtype,
1616: itemkey => itemkey,