702: l_cust_name := l_task_asgn_record.cust_name;
703: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
704: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
705:
706: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
707: fnd_message.set_token('CUST_NAME', l_cust_name);
708: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
709:
710: l_msg_subject := fnd_message.get;
703: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
704: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
705:
706: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
707: fnd_message.set_token('CUST_NAME', l_cust_name);
708: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
709:
710: l_msg_subject := fnd_message.get;
711:
704: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
705:
706: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
707: fnd_message.set_token('CUST_NAME', l_cust_name);
708: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
709:
710: l_msg_subject := fnd_message.get;
711:
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
706: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
707: fnd_message.set_token('CUST_NAME', l_cust_name);
708: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
709:
710: l_msg_subject := fnd_message.get;
711:
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
713: fnd_message.set_token('CUST_NAME', l_cust_name);
714: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
708: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
709:
710: l_msg_subject := fnd_message.get;
711:
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
713: fnd_message.set_token('CUST_NAME', l_cust_name);
714: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
715:
716: l_msg_subject2 := fnd_message.get;
709:
710: l_msg_subject := fnd_message.get;
711:
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
713: fnd_message.set_token('CUST_NAME', l_cust_name);
714: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
715:
716: l_msg_subject2 := fnd_message.get;
717:
710: l_msg_subject := fnd_message.get;
711:
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
713: fnd_message.set_token('CUST_NAME', l_cust_name);
714: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
715:
716: l_msg_subject2 := fnd_message.get;
717:
718: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_asgn_id);
712: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
713: fnd_message.set_token('CUST_NAME', l_cust_name);
714: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
715:
716: l_msg_subject2 := fnd_message.get;
717:
718: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_asgn_id);
719:
720: elsif l_csfw_event_type = 'DELETE' or l_csfw_event_type = 'DELETE_FOR_UPDATE' then
738: l_cust_name := l_task_asgn_record.cust_name;
739: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
740: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
741:
742: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
743: fnd_message.set_token('CUST_NAME', l_cust_name);
744: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
745:
746: l_msg_subject := fnd_message.get;
739: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
740: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
741:
742: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
743: fnd_message.set_token('CUST_NAME', l_cust_name);
744: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
745:
746: l_msg_subject := fnd_message.get;
747:
740: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
741:
742: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
743: fnd_message.set_token('CUST_NAME', l_cust_name);
744: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
745:
746: l_msg_subject := fnd_message.get;
747:
748: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
742: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
743: fnd_message.set_token('CUST_NAME', l_cust_name);
744: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
745:
746: l_msg_subject := fnd_message.get;
747:
748: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
749:
750: elsif l_csfw_event_type = 'SCH_UPDATE' then
765: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
766: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
767:
768:
769: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
770: fnd_message.set_token('CUST_NAME', l_cust_name);
771: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
772:
773: l_msg_subject := fnd_message.get;
766: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
767:
768:
769: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
770: fnd_message.set_token('CUST_NAME', l_cust_name);
771: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
772:
773: l_msg_subject := fnd_message.get;
774:
767:
768:
769: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
770: fnd_message.set_token('CUST_NAME', l_cust_name);
771: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
772:
773: l_msg_subject := fnd_message.get;
774:
775: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id) || '-' || to_char(l_task_audit_id);
769: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
770: fnd_message.set_token('CUST_NAME', l_cust_name);
771: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
772:
773: l_msg_subject := fnd_message.get;
774:
775: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id) || '-' || to_char(l_task_audit_id);
776:
777: else
1244: l_cust_name := l_task_asgn_record.cust_name;
1245: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
1246: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1247:
1248: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1249: fnd_message.set_token('CUST_NAME', l_cust_name);
1250: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1251:
1252: l_msg_subject := fnd_message.get;
1245: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
1246: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1247:
1248: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1249: fnd_message.set_token('CUST_NAME', l_cust_name);
1250: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1251:
1252: l_msg_subject := fnd_message.get;
1253:
1246: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1247:
1248: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1249: fnd_message.set_token('CUST_NAME', l_cust_name);
1250: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1251:
1252: l_msg_subject := fnd_message.get;
1253:
1254: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1248: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1249: fnd_message.set_token('CUST_NAME', l_cust_name);
1250: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1251:
1252: l_msg_subject := fnd_message.get;
1253:
1254: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1255:
1256: wf_engine.setItemAttrText(itemtype => itemtype,
1532:
1533: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1534:
1535:
1536: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1537: l_message_header := fnd_message.get;
1538:
1539: if display_type = 'text/html' then
1540:
1533: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1534:
1535:
1536: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1537: l_message_header := fnd_message.get;
1538:
1539: if display_type = 'text/html' then
1540:
1541: l_message := '
';
1768: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
1769:
1770: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1771:
1772: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1773: l_message_header1 := fnd_message.get;
1774: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1775: l_message_header2 := fnd_message.get;
1776:
1769:
1770: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1771:
1772: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1773: l_message_header1 := fnd_message.get;
1774: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1775: l_message_header2 := fnd_message.get;
1776:
1777: if display_type = 'text/html' then
1770: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1771:
1772: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1773: l_message_header1 := fnd_message.get;
1774: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1775: l_message_header2 := fnd_message.get;
1776:
1777: if display_type = 'text/html' then
1778:
1771:
1772: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1773: l_message_header1 := fnd_message.get;
1774: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1775: l_message_header2 := fnd_message.get;
1776:
1777: if display_type = 'text/html' then
1778:
1779: l_message := '
';
2003: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
2004:
2005: l_task_detail := getTaskDetails(l_task_id, null, null);
2006:
2007: fnd_message.set_name('CSF', 'CSF_ALERTS_DELETE_HDR');
2008: l_message_header := fnd_message.get;
2009:
2010: if display_type = 'text/html' then
2011:
2004:
2005: l_task_detail := getTaskDetails(l_task_id, null, null);
2006:
2007: fnd_message.set_name('CSF', 'CSF_ALERTS_DELETE_HDR');
2008: l_message_header := fnd_message.get;
2009:
2010: if display_type = 'text/html' then
2011:
2012: l_message := '
';
2227: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
2228:
2229: l_task_detail := getTaskDetails(p_task_id, null, p_task_audit_id);
2230:
2231: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_HDR');
2232: l_message_header := fnd_message.get;
2233:
2234: if display_type = 'text/html' then
2235:
2228:
2229: l_task_detail := getTaskDetails(p_task_id, null, p_task_audit_id);
2230:
2231: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_HDR');
2232: l_message_header := fnd_message.get;
2233:
2234: if display_type = 'text/html' then
2235:
2236: l_message := '
';
2415: function getPrompt (p_name varchar2) return varchar2 is
2416: l_return varchar2(100);
2417: begin
2418: l_return := '';
2419: fnd_message.set_name('CSF', p_name);
2420: l_return := fnd_message.get;
2421: return l_return;
2422: end;
2423:
2416: l_return varchar2(100);
2417: begin
2418: l_return := '';
2419: fnd_message.set_name('CSF', p_name);
2420: l_return := fnd_message.get;
2421: return l_return;
2422: end;
2423:
2424: function getContactDetail(p_incident_id number,