[Home] [Help]
370: p_inactive_date IN DATE DEFAULT NULL
371: )
372: IS
373: l_person_party_id NUMBER;
374: l_fnd_user_id NUMBER;
375: l_step VARCHAR2(100);
376: l_method VARCHAR2(30);
377: l_lock_id NUMBER;
378: cursor l_cont_addr_cur is
434:
435: -- handling user account
436: IF p_request_rec.create_user_account IS NOT NULL
437: AND p_request_rec.create_user_account = 'Y' THEN
438: -- create fnd user account
439: l_step := 'call create_fnd_user';
440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string
442: ( fnd_log.level_statement
435: -- handling user account
436: IF p_request_rec.create_user_account IS NOT NULL
437: AND p_request_rec.create_user_account = 'Y' THEN
438: -- create fnd user account
439: l_step := 'call create_fnd_user';
440: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
441: fnd_log.string
442: ( fnd_log.level_statement
443: , g_module || '.' || l_method
455: p_password => null,
456: x_return_status => x_return_status,
457: x_msg_count => x_msg_count,
458: x_msg_data => x_msg_data,
459: x_user_id => l_fnd_user_id,
460: x_password => x_password
461: );
462:
463: IF x_return_status IS NULL OR x_return_status <> fnd_api.g_ret_sts_success THEN
465: RETURN;
466: END IF;
467:
468: pos_user_admin_pkg.createsecattr
469: ( p_user_id => l_fnd_user_id,
470: p_attribute_code => 'ICX_SUPPLIER_ORG_ID',
471: p_app_id => 177,
472: p_number_value => p_vendor_id
473: );
963: l_rec2 l_cur2%ROWTYPE;
964:
965: l_method VARCHAR2(30);
966:
967: l_user_name fnd_user.user_name%TYPE;
968:
969: BEGIN
970: savepoint approve_contact_req;
971:
2584: if p_create_user_acc = 'Y' then
2585:
2586: SELECT fu.user_id,fu.PERSON_PARTY_ID
2587: into x_user_id, x_cont_party_id
2588: FROM fnd_user fu, pos_contact_requests pcr
2589: WHERE pcr.CONTACT_PARTY_ID = fu.PERSON_PARTY_ID
2590: and pcr.contact_request_id = p_request_id;
2591:
2592: ELSE