APPS.HXC_APPROVAL_WF_HELPER dependencies on FND_MESSAGE

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

1191: itemkey => itemkey,
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();

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 1199: l_title := fnd_message.get();

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(
1202: itemtype => itemtype,
1203: itemkey => itemkey,

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

1210: itemkey => itemkey,
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:

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

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:
1221: wf_engine.SetItemAttrText(

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

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:
1221: wf_engine.SetItemAttrText(
1222: itemtype => itemtype,
1223: itemkey => itemkey,

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

1272: itemkey => itemkey,
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();

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 1280: l_title := fnd_message.get();

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(
1283: itemtype => itemtype,
1284: itemkey => itemkey,

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

1291: aname => 'DESCRIPTION',
1292: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
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);

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

1292: avalue => hxc_find_notify_aprs_pkg.get_description(l_app_bb_id));
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:

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 1299: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

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:
1303: wf_engine.SetItemAttrText(

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

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:
1303: wf_engine.SetItemAttrText(
1304: itemtype => itemtype,
1305: itemkey => itemkey,

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

1346: aname => 'TC_FROM_ROLE',
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();

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 1354: l_title := fnd_message.get();

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(
1357: itemtype => itemtype,
1358: itemkey => itemkey,

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

1374: -- Added for bug 6369091
1375: --set TOTAL_HOURS
1376: l_total_hours := hxc_time_category_utils_pkg.category_timecard_hrs_ind(l_timecard_id,l_timecard_ovn,'');
1377: --set FYI_SUBJECT
1378: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1379: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1380: ELSE
1381: --set FYI_SUBJECT for Absences enabled resource
1382: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER_ABS');

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

1375: --set TOTAL_HOURS
1376: l_total_hours := hxc_time_category_utils_pkg.category_timecard_hrs_ind(l_timecard_id,l_timecard_ovn,'');
1377: --set FYI_SUBJECT
1378: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1379: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1380: ELSE
1381: --set FYI_SUBJECT for Absences enabled resource
1382: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER_ABS');
1383:

Line 1382: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER_ABS');

1378: fnd_message.set_name('HXC','HXC_APPR_SUB_WORKER');
1379: fnd_message.set_token('TOTAL_HOURS',l_total_hours);
1380: ELSE
1381: --set FYI_SUBJECT for Absences enabled resource
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')));

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 1388: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

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();
1392:

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

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();
1392:
1393: wf_engine.SetItemAttrText(

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

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();
1392:
1393: wf_engine.SetItemAttrText(
1394: itemtype => itemtype,
1395: itemkey => itemkey,

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

1453: aname => 'TC_FROM_ROLE',
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();

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 1461: l_title := fnd_message.get();

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(
1464: itemtype => itemtype,
1465: itemkey => itemkey,

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

1477: itemtype => itemtype,
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:

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 1484: fnd_message.set_token('RESOURCE_FULL_NAME',l_worker_full_name);

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:
1488: wf_engine.SetItemAttrText(

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

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:
1488: wf_engine.SetItemAttrText(
1489: itemtype => itemtype,
1490: itemkey => itemkey,

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

1518: itemkey => itemkey,
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();

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 1526: l_title := fnd_message.get();

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(
1529: itemtype => itemtype,
1530: itemkey => itemkey,

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

1544: aname => 'APR_PERSON_ID');
1545: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
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);

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

1545: l_supervisor_id :=hxc_find_notify_aprs_pkg.get_supervisor(l_apr_person_id,SYSDATE);
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:

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 1552: fnd_message.set_token('SUPERVISOR_FULL_NAME',l_supervisor_name);

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:
1556: wf_engine.SetItemAttrText(

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

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:
1556: wf_engine.SetItemAttrText(
1557: itemtype => itemtype,
1558: itemkey => itemkey,

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

1599: aname => 'TC_FROM_ROLE',
1600: avalue => l_tc_from_role);
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);

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

1600: avalue => l_tc_from_role);
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:

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:

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

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:
1611: wf_engine.SetItemAttrText(

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

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:
1611: wf_engine.SetItemAttrText(
1612: itemtype => itemtype,
1613: itemkey => itemkey,

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

1614: aname => 'FYI_SUBJECT',
1615: avalue => l_fyi_subject);
1616:
1617: -- set FYI_NO_DETAIL_BODY
1618: fnd_message.set_name('HXC','HXC_APPR_NO_DETAILS_BODY');
1619: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1620:
1621:
1622:

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

1615: avalue => l_fyi_subject);
1616:
1617: -- set FYI_NO_DETAIL_BODY
1618: fnd_message.set_name('HXC','HXC_APPR_NO_DETAILS_BODY');
1619: fnd_message.set_token('PREPARER_FULL_NAME',l_preparer_full_name);
1620:
1621:
1622:
1623: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,

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

1623: l_apr_rej_reason :=wf_engine.GetItemAttrText(itemtype => itemtype,
1624: itemkey => itemkey,
1625: aname => 'APR_REJ_REASON');
1626:
1627: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1628:
1629: l_fyi_no_detail_body :=fnd_message.get();
1630:
1631: wf_engine.SetItemAttrText(

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

1625: aname => 'APR_REJ_REASON');
1626:
1627: fnd_message.set_token('APR_REJ_REASON',l_apr_rej_reason);
1628:
1629: l_fyi_no_detail_body :=fnd_message.get();
1630:
1631: wf_engine.SetItemAttrText(
1632: itemtype => itemtype,
1633: itemkey => itemkey,