DBA Data[Home] [Help]

APPS.CSD_ISUP_DEPOT_WF_PVT dependencies on FND_MESSAGE

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

406: open get_line_status(x_repair_line_id);
407: fetch get_line_status into l_transaction_status,l_order_number;
408: close get_line_status;
409: -- get the notes message and replace the binds.
410: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
411: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
412: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
413: if upper(l_transaction_status)='BOOKED' then
414: --notes_message := notes_message||' RMA number is '||l_order_number;

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

407: fetch get_line_status into l_transaction_status,l_order_number;
408: close get_line_status;
409: -- get the notes message and replace the binds.
410: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
411: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
412: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
413: if upper(l_transaction_status)='BOOKED' then
414: --notes_message := notes_message||' RMA number is '||l_order_number;
415: fnd_message.set_token('RMA_NUMBER',l_order_number);

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

408: close get_line_status;
409: -- get the notes message and replace the binds.
410: fnd_message.set_name('CSD','CSD_RO_CREATED_WF_NOTE');
411: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
412: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
413: if upper(l_transaction_status)='BOOKED' then
414: --notes_message := notes_message||' RMA number is '||l_order_number;
415: fnd_message.set_token('RMA_NUMBER',l_order_number);
416: else

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

411: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
412: fnd_message.set_token('REPAIR_NUMBER',x_repair_number);
413: if upper(l_transaction_status)='BOOKED' then
414: --notes_message := notes_message||' RMA number is '||l_order_number;
415: fnd_message.set_token('RMA_NUMBER',l_order_number);
416: else
417: fnd_message.set_token('RMA_NUMBER','not booked');
418: end if;
419:

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

413: if upper(l_transaction_status)='BOOKED' then
414: --notes_message := notes_message||' RMA number is '||l_order_number;
415: fnd_message.set_token('RMA_NUMBER',l_order_number);
416: else
417: fnd_message.set_token('RMA_NUMBER','not booked');
418: end if;
419:
420: notes_message := fnd_message.get;
421:

Line 420: notes_message := fnd_message.get;

416: else
417: fnd_message.set_token('RMA_NUMBER','not booked');
418: end if;
419:
420: notes_message := fnd_message.get;
421:
422: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
423: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,lc_mod_name||'begin','calling create JTF Notes API');
424: END IF;

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

454: l_item_name,l_contact_name;
455: Close get_ro_attributes;
456:
457: -- derive the notification message.
458: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
459: fnd_message.set_token('CONTACT_NAME',l_contact_name);
460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);

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

455: Close get_ro_attributes;
456:
457: -- derive the notification message.
458: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
459: fnd_message.set_token('CONTACT_NAME',l_contact_name);
460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);
463:

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

456:
457: -- derive the notification message.
458: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
459: fnd_message.set_token('CONTACT_NAME',l_contact_name);
460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);
463:
464: l_message := fnd_message.get;

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

457: -- derive the notification message.
458: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
459: fnd_message.set_token('CONTACT_NAME',l_contact_name);
460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);
463:
464: l_message := fnd_message.get;
465:

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

458: fnd_message.set_name('CSD','CSD_RO_WF_NTF_MSG');
459: fnd_message.set_token('CONTACT_NAME',l_contact_name);
460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);
463:
464: l_message := fnd_message.get;
465:
466: -- If role does not exist the create adhoc wf role

Line 464: l_message := fnd_message.get;

460: fnd_message.set_token('REPAIR_ORDER',x_repair_number);
461: fnd_message.set_token('SERVICE_REQUEST',g_incident_number);
462: fnd_message.set_token('RMA_NUMBER',l_order_number);
463:
464: l_message := fnd_message.get;
465:
466: -- If role does not exist the create adhoc wf role
467:
468: if ( l_wf_role is null ) then