DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on FND_MESSAGE

Line 549: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');

545: OPEN get_line_status(x_repair_line_id);
546: FETCH get_line_status INTO l_transaction_status,l_order_number;
547: CLOSE get_line_status;
548: -- get the notes message and replace the binds.
549: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
550: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
552: IF upper(l_transaction_status)='BOOKED' THEN
553: fnd_message.set_token('RMA_NUMBER',l_order_number);

Line 550: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);

546: FETCH get_line_status INTO l_transaction_status,l_order_number;
547: CLOSE get_line_status;
548: -- get the notes message and replace the binds.
549: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
550: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
552: IF upper(l_transaction_status)='BOOKED' THEN
553: fnd_message.set_token('RMA_NUMBER',l_order_number);
554: ELSE

Line 551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);

547: CLOSE get_line_status;
548: -- get the notes message and replace the binds.
549: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
550: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
552: IF upper(l_transaction_status)='BOOKED' THEN
553: fnd_message.set_token('RMA_NUMBER',l_order_number);
554: ELSE
555: fnd_message.set_token('RMA_NUMBER','not booked');

Line 553: fnd_message.set_token('RMA_NUMBER',l_order_number);

549: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
550: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
552: IF upper(l_transaction_status)='BOOKED' THEN
553: fnd_message.set_token('RMA_NUMBER',l_order_number);
554: ELSE
555: fnd_message.set_token('RMA_NUMBER','not booked');
556: END IF;
557:

Line 555: fnd_message.set_token('RMA_NUMBER','not booked');

551: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
552: IF upper(l_transaction_status)='BOOKED' THEN
553: fnd_message.set_token('RMA_NUMBER',l_order_number);
554: ELSE
555: fnd_message.set_token('RMA_NUMBER','not booked');
556: END IF;
557:
558: notes_message := fnd_message.get;
559:

Line 558: notes_message := fnd_message.get;

554: ELSE
555: fnd_message.set_token('RMA_NUMBER','not booked');
556: END IF;
557:
558: notes_message := fnd_message.get;
559:
560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
561: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'begin','calling create JTF Notes API');
562: END IF;

Line 596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');

592: l_item_name,l_contact_name;
593: CLOSE get_ro_attributes;
594:
595: -- derive the notification message.
596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
597: fnd_message.set_token('CONTACT_NAME',l_contact_name);
598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);

Line 597: fnd_message.set_token('CONTACT_NAME',l_contact_name);

593: CLOSE get_ro_attributes;
594:
595: -- derive the notification message.
596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
597: fnd_message.set_token('CONTACT_NAME',l_contact_name);
598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);
601:

Line 598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);

594:
595: -- derive the notification message.
596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
597: fnd_message.set_token('CONTACT_NAME',l_contact_name);
598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);
601:
602: l_message := fnd_message.get;

Line 599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);

595: -- derive the notification message.
596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
597: fnd_message.set_token('CONTACT_NAME',l_contact_name);
598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);
601:
602: l_message := fnd_message.get;
603:

Line 600: fnd_message.set_token('RMA_NUMBER',l_order_number);

596: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
597: fnd_message.set_token('CONTACT_NAME',l_contact_name);
598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);
601:
602: l_message := fnd_message.get;
603:
604: -- If role does not exist the create adhoc wf role

Line 602: l_message := fnd_message.get;

598: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
599: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
600: fnd_message.set_token('RMA_NUMBER',l_order_number);
601:
602: l_message := fnd_message.get;
603:
604: -- If role does not exist the create adhoc wf role
605:
606: IF ( l_wf_role IS NULL ) THEN