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