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_PROFILE

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 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 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 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 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 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 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 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 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 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 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: