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 1196: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));

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

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

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

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

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')));
1217: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1218:
1219: l_fyi_subject :=fnd_message.get();

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

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')));
1217: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1218:
1219: l_fyi_subject :=fnd_message.get();
1220:

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

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

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

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

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

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);
1297: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1299: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1300:
1301: l_fyi_subject :=fnd_message.get();

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

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);
1297: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1298: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1299: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1300:
1301: l_fyi_subject :=fnd_message.get();
1302:

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

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

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

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

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

1382: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER_ABS');
1383:
1384: END IF;
1385:
1386: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1387: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1388: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1389: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1390:

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

1383:
1384: END IF;
1385:
1386: fnd_message.set_token('START_DATE',to_char(l_tc_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1387: fnd_message.set_token('END_DATE',to_char(l_tc_stop_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1388: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1389: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1390:
1391: l_fyi_subject :=fnd_message.get();

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

1454: avalue => l_worker_role);
1455: --set TITLE
1456: hr_utility.trace('set TITLE');
1457: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1458: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1459: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1460:
1461: l_title := fnd_message.get();
1462:

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

1455: --set TITLE
1456: hr_utility.trace('set TITLE');
1457: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1458: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1459: fnd_message.set_token('END_DATE',to_char(l_effective_END_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1460:
1461: l_title := fnd_message.get();
1462:
1463: wf_engine.SetItemAttrText(

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

1478: itemkey => itemkey,
1479: aname => 'TC_APPROVER_FROM_ROLE');
1480:
1481: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1482: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1483: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1484: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1485:
1486: l_fyi_subject :=fnd_message.get();

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

1479: aname => 'TC_APPROVER_FROM_ROLE');
1480:
1481: fnd_message.set_name('HXC','HXC_APPR_SUB_SUPERVISOR');
1482: fnd_message.set_token('APPLICATION_PERIOD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1483: fnd_message.set_token('APPLICATION_PERIOD_END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1484: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1485:
1486: l_fyi_subject :=fnd_message.get();
1487:

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

1519: aname => 'TC_FROM_ROLE',
1520: avalue => l_preparer_role);
1521: --set TITLE
1522: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1523: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1524: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1525:
1526: l_title := fnd_message.get();
1527:

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

1520: avalue => l_preparer_role);
1521: --set TITLE
1522: fnd_message.set_name('HXC','HXC_APPR_WF_TITLE');
1523: fnd_message.set_token('START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1524: fnd_message.set_token('END_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1525:
1526: l_title := fnd_message.get();
1527:
1528: wf_engine.SetItemAttrText(

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

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')));
1551: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1552: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1553:
1554: l_fyi_subject :=fnd_message.get();

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

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')));
1551: fnd_message.set_token('APPLICATION_PERIOD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1552: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);
1553:
1554: l_fyi_subject :=fnd_message.get();
1555:

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

1601:
1602: --set FYI_SUBJECT
1603: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1604: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1605: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1606: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1607: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1608:
1609: l_fyi_subject :=fnd_message.get();

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

1602: --set FYI_SUBJECT
1603: fnd_message.set_name('HXC','HXC_APPR_APPR_PREPARER');
1604: fnd_message.set_token('APPROVER_FULL_NAME',l_tc_from_role);
1605: fnd_message.set_token('TIMECARD_START_DATE',to_char(l_effective_start_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1606: fnd_message.set_token('TIMECARD_STOP_DATE',to_char(l_effective_end_date,fnd_profile.value('ICX_DATE_FORMAT_MASK')));
1607: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);
1608:
1609: l_fyi_subject :=fnd_message.get();
1610: