DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on FND_MESSAGE

Line 696: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_SUB');

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;

Line 697: fnd_message.set_token('CUST_NAME', l_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;
701:

Line 698: fnd_message.set_token('SCH_START_DT', l_schedule_start_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:
702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');

Line 700: l_msg_subject := fnd_message.get;

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);

Line 702: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_SUB');

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;

Line 703: fnd_message.set_token('CUST_NAME', l_cust_name);

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:

Line 704: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);

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);

Line 706: l_msg_subject2 := fnd_message.get;

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

Line 732: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');

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;

Line 733: fnd_message.set_token('CUST_NAME', l_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;
737:

Line 734: fnd_message.set_token('SCH_START_DT', l_schedule_start_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:
738: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);

Line 736: l_msg_subject := fnd_message.get;

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

Line 759: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_SUB');

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;

Line 760: fnd_message.set_token('CUST_NAME', l_cust_name);

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:

Line 761: fnd_message.set_token('SCH_START_DT', l_schedule_start_date);

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);

Line 763: l_msg_subject := fnd_message.get;

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

Line 1238: fnd_message.set_name('CSF', 'CSF_ALERTS_CANCEL_SUB');

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;

Line 1239: fnd_message.set_token('CUST_NAME', l_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;
1243:

Line 1240: fnd_message.set_token('SCH_START_DT', l_schedule_start_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:
1244: l_document_id := to_char(l_resource_id) || '-' || l_resource_type || '-' || to_char(l_task_id);

Line 1242: l_msg_subject := fnd_message.get;

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,

Line 1526: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');

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:

Line 1527: l_message_header := fnd_message.get;

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

';

Line 1762: fnd_message.set_name('CSF', 'CSF_ALERTS_REMINDER_HDR');

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:

Line 1763: l_message_header1 := fnd_message.get;

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

Line 1764: fnd_message.set_name('CSF', 'CSF_ALERTS_ASSIGNED_HDR');

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:

Line 1765: l_message_header2 := fnd_message.get;

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

';

Line 1997: fnd_message.set_name('CSF', 'CSF_ALERTS_DELETE_HDR');

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:

Line 1998: l_message_header := fnd_message.get;

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

';

Line 2221: fnd_message.set_name('CSF', 'CSF_ALERTS_RESCHEDULE_HDR');

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:

Line 2222: l_message_header := fnd_message.get;

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

';

Line 2409: fnd_message.set_name('CSF', p_name);

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:

Line 2410: l_return := fnd_message.get;

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,