[Home] [Help]
182: l_sr_rec.INSTALL_SITE_ID := NVL(p_record.INSTALL_SITE_ID, p_record.INSTALL_SITE_USE_ID);
183: l_sr_rec.INSTALL_SITE_USE_ID := l_sr_rec.INSTALL_SITE_ID;
184: l_sr_rec.CUSTOMER_PRODUCT_ID := p_record.CUSTOMER_PRODUCT_ID;
185: l_sr_rec.INVENTORY_ITEM_ID := p_record.INVENTORY_ITEM_ID;
186: l_sr_rec.inventory_org_id := TO_NUMBER(fnd_profile.value(
187: 'CS_INV_VALIDATION_ORG') ) ;
188: l_sr_rec.PROBLEM_CODE := p_record.PROBLEM_CODE;
189: l_sr_rec.RESOLUTION_CODE := p_record.RESOLUTION_CODE;
190: l_sr_rec.CONTRACT_SERVICE_ID := p_record.CONTRACT_SERVICE_ID;
301:
302: -- See if Credit Card profile is set?
303: --Bug 4496299
304: /*
305: l_profile_value := fnd_profile.value('JTM_CREDIT_CARD_ENABLED');
306: IF l_profile_value = 'Y' THEN
307: IF p_record.CREDIT_CARD_NUMBER IS NOT NULL THEN
308: l_decript_value := CS_SERVICEREQUEST_PUB.CC_DECODE(p_record.CREDIT_CARD_NUMBER);
309: l_sr_rec.cc_number := l_decript_value;
370: , p_request_number => p_record.incident_number
371: , p_service_request_rec => l_sr_rec
372: , p_notes => l_notes_tab
373: , p_contacts => l_contacts_tab
374: , p_resp_id => to_number(fnd_profile.value('CSL_SR_CREATE_RESP'))
375: , x_request_id => l_request_id
376: , x_request_number => l_request_number
377: , x_interaction_id => l_interaction_id
378: , x_workflow_process_id => l_workflow_process_id
489: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
490: END IF;
491:
492: -- Check for Stale data
493: l_profile_value := fnd_profile.value('JTM_APPL_CONFLICT_RULE');
494: if l_profile_value = 'SERVER_WINS' AND
495: ASG_DEFER.IS_DEFERRED(p_record.clid$$cs, p_record.tranid$$,g_object_name, p_record.seqno$$) <> FND_API.G_TRUE then
496: open c_last_update_date(b_incident_id => p_record.incident_id);
497: fetch c_last_update_date into r_last_update_date;
622:
623: -- See if Credit Card profile is set?
624: --Bug 4496299
625: /*
626: l_profile_value := fnd_profile.value('JTM_CREDIT_CARD_ENABLED');
627: IF l_profile_value = 'Y' THEN
628: IF p_record.CREDIT_CARD_NUMBER IS NOT NULL THEN
629: open c_credit_card(b_incident_id => p_record.incident_id);
630: fetch c_credit_card into r_credit_card;
669: , p_last_update_date => sysdate
670: , p_service_request_rec => l_sr_rec
671: , p_notes => l_notes_tab
672: , p_contacts => l_contacts_tab
673: , p_resp_id => to_number(fnd_profile.value('CSL_SR_CREATE_RESP'))
674: , x_workflow_process_id => l_workflow_id
675: , x_interaction_id => l_interaction_id
676: );
677: