692: l_cust_name := l_task_asgn_record.cust_name;
693: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
694: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
695:
696: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
697: fnd_message.set_token('CUST_NAME', l_cust_name);
698: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
699:
700: l_msg_subject := fnd_message.get;
693: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
694: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
695:
696: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
697: fnd_message.set_token('CUST_NAME', l_cust_name);
698: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
699:
700: l_msg_subject := fnd_message.get;
701:
694: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
695:
696: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
697: fnd_message.set_token('CUST_NAME', l_cust_name);
698: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
699:
700: l_msg_subject := fnd_message.get;
701:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
696: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');
697: fnd_message.set_token('CUST_NAME', l_cust_name);
698: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
699:
700: l_msg_subject := fnd_message.get;
701:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
703: fnd_message.set_token('CUST_NAME', l_cust_name);
704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
698: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
699:
700: l_msg_subject := fnd_message.get;
701:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
703: fnd_message.set_token('CUST_NAME', l_cust_name);
704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
705:
706: l_msg_subject2 := fnd_message.get;
699:
700: l_msg_subject := fnd_message.get;
701:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
703: fnd_message.set_token('CUST_NAME', l_cust_name);
704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
705:
706: l_msg_subject2 := fnd_message.get;
707:
700: l_msg_subject := fnd_message.get;
701:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
703: fnd_message.set_token('CUST_NAME', l_cust_name);
704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
705:
706: l_msg_subject2 := fnd_message.get;
707:
708: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_asgn_id);
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');
703: fnd_message.set_token('CUST_NAME', l_cust_name);
704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
705:
706: l_msg_subject2 := fnd_message.get;
707:
708: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_asgn_id);
709:
710: elsif l_csfw_event_type = 'DELETE' or l_csfw_event_type = 'DELETE_FOR_UPDATE' then
728: l_cust_name := l_task_asgn_record.cust_name;
729: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
730: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
731:
732: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
733: fnd_message.set_token('CUST_NAME', l_cust_name);
734: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
735:
736: l_msg_subject := fnd_message.get;
729: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
730: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
731:
732: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
733: fnd_message.set_token('CUST_NAME', l_cust_name);
734: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
735:
736: l_msg_subject := fnd_message.get;
737:
730: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
731:
732: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
733: fnd_message.set_token('CUST_NAME', l_cust_name);
734: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
735:
736: l_msg_subject := fnd_message.get;
737:
738: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
732: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
733: fnd_message.set_token('CUST_NAME', l_cust_name);
734: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
735:
736: l_msg_subject := fnd_message.get;
737:
738: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
739:
740: elsif l_csfw_event_type = 'SCH_UPDATE' then
755: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
756: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
757:
758:
759: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
760: fnd_message.set_token('CUST_NAME', l_cust_name);
761: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
762:
763: l_msg_subject := fnd_message.get;
756: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
757:
758:
759: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
760: fnd_message.set_token('CUST_NAME', l_cust_name);
761: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
762:
763: l_msg_subject := fnd_message.get;
764:
757:
758:
759: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
760: fnd_message.set_token('CUST_NAME', l_cust_name);
761: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
762:
763: l_msg_subject := fnd_message.get;
764:
765: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id) || '-' || to_char(l_task_audit_id);
759: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');
760: fnd_message.set_token('CUST_NAME', l_cust_name);
761: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
762:
763: l_msg_subject := fnd_message.get;
764:
765: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id) || '-' || to_char(l_task_audit_id);
766:
767: else
1234: l_cust_name := l_task_asgn_record.cust_name;
1235: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
1236: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1237:
1238: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1239: fnd_message.set_token('CUST_NAME', l_cust_name);
1240: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1241:
1242: l_msg_subject := fnd_message.get;
1235: l_schedule_start_date := to_char(getClientTime(l_task_asgn_record.sch_st_date,
1236: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1237:
1238: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1239: fnd_message.set_token('CUST_NAME', l_cust_name);
1240: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1241:
1242: l_msg_subject := fnd_message.get;
1243:
1236: getUserId(l_resource_id, l_resource_type)), 'DD-MON-YYYY HH24:MI');
1237:
1238: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1239: fnd_message.set_token('CUST_NAME', l_cust_name);
1240: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1241:
1242: l_msg_subject := fnd_message.get;
1243:
1244: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1238: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');
1239: fnd_message.set_token('CUST_NAME', l_cust_name);
1240: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);
1241:
1242: l_msg_subject := fnd_message.get;
1243:
1244: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);
1245:
1246: wf_engine.setItemAttrText(itemtype => itemtype,
1522:
1523: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1524:
1525:
1526: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1527: l_message_header := fnd_message.get;
1528:
1529: if display_type = 'text/html' then
1530:
1523: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1524:
1525:
1526: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1527: l_message_header := fnd_message.get;
1528:
1529: if display_type = 'text/html' then
1530:
1531: l_message := '
';
1758: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
1759:
1760: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1761:
1762: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1763: l_message_header1 := fnd_message.get;
1764: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1765: l_message_header2 := fnd_message.get;
1766:
1759:
1760: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1761:
1762: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1763: l_message_header1 := fnd_message.get;
1764: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1765: l_message_header2 := fnd_message.get;
1766:
1767: if display_type = 'text/html' then
1760: l_task_detail := getTaskDetails(null, l_task_asgn_id, null);
1761:
1762: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1763: l_message_header1 := fnd_message.get;
1764: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1765: l_message_header2 := fnd_message.get;
1766:
1767: if display_type = 'text/html' then
1768:
1761:
1762: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');
1763: l_message_header1 := fnd_message.get;
1764: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');
1765: l_message_header2 := fnd_message.get;
1766:
1767: if display_type = 'text/html' then
1768:
1769: l_message := '
';
1993: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
1994:
1995: l_task_detail := getTaskDetails(l_task_id, null, null);
1996:
1997: fnd_message.set_name('CSF', 'CSF_ALERTS_DELETE_HDR');
1998: l_message_header := fnd_message.get;
1999:
2000: if display_type = 'text/html' then
2001:
1994:
1995: l_task_detail := getTaskDetails(l_task_id, null, null);
1996:
1997: fnd_message.set_name('CSF', 'CSF_ALERTS_DELETE_HDR');
1998: l_message_header := fnd_message.get;
1999:
2000: if display_type = 'text/html' then
2001:
2002: l_message := '
';
2217: fnd_global.APPS_INITIALIZE(user_id => p_user_id, resp_id => 21685, resp_appl_id => 513);
2218:
2219: l_task_detail := getTaskDetails(p_task_id, null, p_task_audit_id);
2220:
2221: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_HDR');
2222: l_message_header := fnd_message.get;
2223:
2224: if display_type = 'text/html' then
2225:
2218:
2219: l_task_detail := getTaskDetails(p_task_id, null, p_task_audit_id);
2220:
2221: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_HDR');
2222: l_message_header := fnd_message.get;
2223:
2224: if display_type = 'text/html' then
2225:
2226: l_message := '
';
2405: function getPrompt (p_name varchar2) return varchar2 is
2406: l_return varchar2(100);
2407: begin
2408: l_return := '';
2409: fnd_message.set_name('CSF', p_name);
2410: l_return := fnd_message.get;
2411: return l_return;
2412: end;
2413:
2406: l_return varchar2(100);
2407: begin
2408: l_return := '';
2409: fnd_message.set_name('CSF', p_name);
2410: l_return := fnd_message.get;
2411: return l_return;
2412: end;
2413:
2414: function getContactDetail(p_incident_id number,