DBA Data[Home] [Help]

APPS.CSF_ALERTS_PUB dependencies on FND_MESSAGE

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

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;

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

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

Line 710: l_msg_subject := fnd_message.get;

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

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

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;

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

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:

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

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

Line 716: l_msg_subject2 := fnd_message.get;

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

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

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;

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

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

Line 746: l_msg_subject := fnd_message.get;

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

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

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;

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

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:

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

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

Line 773: l_msg_subject := fnd_message.get;

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

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

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;

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

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

Line 1252: l_msg_subject := fnd_message.get;

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,

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

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:

Line 1537: l_message_header := fnd_message.get;

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

';

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

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:

Line 1773: l_message_header1 := fnd_message.get;

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

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

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:

Line 1775: l_message_header2 := fnd_message.get;

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

';

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

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:

Line 2008: l_message_header := fnd_message.get;

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

';

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

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:

Line 2232: l_message_header := fnd_message.get;

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

';

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

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:

Line 2420: l_return := fnd_message.get;

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,