eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKS_AUTO_REMINDER dependencies on FND_FILE

Line 2730: fnd_file.put_line (fnd_file.LOG, ' ');

2726: );
2727: END IF;
2728:
2729: -- log file
2730: fnd_file.put_line (fnd_file.LOG, ' ');
2731: fnd_file.put_line
2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');

Line 2731: fnd_file.put_line

2727: END IF;
2728:
2729: -- log file
2730: fnd_file.put_line (fnd_file.LOG, ' ');
2731: fnd_file.put_line
2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');

Line 2732: (fnd_file.LOG,

2728:
2729: -- log file
2730: fnd_file.put_line (fnd_file.LOG, ' ');
2731: fnd_file.put_line
2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');
2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||

Line 2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');

2730: fnd_file.put_line (fnd_file.LOG, ' ');
2731: fnd_file.put_line
2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');
2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||
2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||

Line 2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');

2731: fnd_file.put_line
2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');
2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||
2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||
2739: p_contract_id);

Line 2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||

2732: (fnd_file.LOG,
2733: '---------------------------------------------------------- ');
2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');
2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||
2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||
2739: p_contract_id);
2740: fnd_file.put_line

Line 2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||

2734: fnd_file.put_line (fnd_file.LOG, 'Entered create_sso_user');
2735: fnd_file.put_line (fnd_file.LOG, 'Parameters ');
2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||
2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||
2739: p_contract_id);
2740: fnd_file.put_line
2741: (fnd_file.LOG,
2742: '---------------------------------------------------------- ');

Line 2740: fnd_file.put_line

2736: fnd_file.put_line (fnd_file.LOG, 'p_user_name : ' ||
2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||
2739: p_contract_id);
2740: fnd_file.put_line
2741: (fnd_file.LOG,
2742: '---------------------------------------------------------- ');
2743: fnd_file.put_line (fnd_file.LOG, ' ');
2744: -- Initialize API return status to success

Line 2741: (fnd_file.LOG,

2737: p_user_name);
2738: fnd_file.put_line (fnd_file.LOG, 'p_contract_id : ' ||
2739: p_contract_id);
2740: fnd_file.put_line
2741: (fnd_file.LOG,
2742: '---------------------------------------------------------- ');
2743: fnd_file.put_line (fnd_file.LOG, ' ');
2744: -- Initialize API return status to success
2745: x_return_status := fnd_api.g_ret_sts_success;

Line 2743: fnd_file.put_line (fnd_file.LOG, ' ');

2739: p_contract_id);
2740: fnd_file.put_line
2741: (fnd_file.LOG,
2742: '---------------------------------------------------------- ');
2743: fnd_file.put_line (fnd_file.LOG, ' ');
2744: -- Initialize API return status to success
2745: x_return_status := fnd_api.g_ret_sts_success;
2746:
2747: -- Get the Person Party Id and quote_to_contact_id from oks_k_headers_b

Line 2774: fnd_file.put_line (fnd_file.LOG,

2770: );
2771: END IF;
2772:
2773: -- log file
2774: fnd_file.put_line (fnd_file.LOG,
2775: 'OKS l_person_party_id : ' ||
2776: l_person_party_id);
2777: fnd_file.put_line (fnd_file.LOG,
2778: 'OKS l_quote_to_contact_id : ' ||

Line 2777: fnd_file.put_line (fnd_file.LOG,

2773: -- log file
2774: fnd_file.put_line (fnd_file.LOG,
2775: 'OKS l_person_party_id : ' ||
2776: l_person_party_id);
2777: fnd_file.put_line (fnd_file.LOG,
2778: 'OKS l_quote_to_contact_id : ' ||
2779: l_quote_to_contact_id);
2780:
2781: -- if the person_party_id is NULL then get person_party_id for quote_to_contact_id

Line 2805: fnd_file.put_line (fnd_file.LOG,

2801: );
2802: END IF;
2803:
2804: -- log file
2805: fnd_file.put_line (fnd_file.LOG,
2806: 'HZ l_person_party_id : ' ||
2807: l_person_party_id);
2808:
2809: -- update the oks_k_headers_b with the person_party_id

Line 2865: fnd_file.put_line (fnd_file.LOG,

2861: );
2862: END IF;
2863:
2864: -- log file
2865: fnd_file.put_line (fnd_file.LOG,
2866: 'Check FND User record for person_party_id : ' ||
2867: l_person_party_id);
2868: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||
2869: l_user_id);

Line 2868: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||

2864: -- log file
2865: fnd_file.put_line (fnd_file.LOG,
2866: 'Check FND User record for person_party_id : ' ||
2867: l_person_party_id);
2868: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||
2869: l_user_id);
2870: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||
2871: x_user_name);
2872:

Line 2870: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||

2866: 'Check FND User record for person_party_id : ' ||
2867: l_person_party_id);
2868: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||
2869: l_user_id);
2870: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||
2871: x_user_name);
2872:
2873: -- Check if valid fnd_user found
2874: IF x_user_name IS NOT NULL

Line 2878: fnd_file.put_line (fnd_file.LOG,

2874: IF x_user_name IS NOT NULL
2875: THEN
2876: x_password := '******';
2877: -- log file
2878: fnd_file.put_line (fnd_file.LOG,
2879: 'Found FND User record for person_party_id : ' ||
2880: l_person_party_id);
2881: -- Bug 4650639
2882: -- FND USER found, check if this user has the responsibility G_ERN_WEB_RESPONSIBILITY

Line 2883: fnd_file.put_line (fnd_file.LOG,

2879: 'Found FND User record for person_party_id : ' ||
2880: l_person_party_id);
2881: -- Bug 4650639
2882: -- FND USER found, check if this user has the responsibility G_ERN_WEB_RESPONSIBILITY
2883: fnd_file.put_line (fnd_file.LOG,
2884: 'Check if the user has ERN responsibility');
2885:
2886: OPEN l_resp_csr (p_resp_key => g_ern_web_responsibility);
2887:

Line 2907: fnd_file.put_line (fnd_file.LOG,

2903: l_security_grp_id
2904: )
2905: THEN
2906: -- user has the ERN responsibility
2907: fnd_file.put_line (fnd_file.LOG,
2908: 'user : ' ||
2909: x_user_name ||
2910: ' has ERN responsibility');
2911: RETURN;

Line 2915: fnd_file.put_line (fnd_file.LOG,

2911: RETURN;
2912: ELSE
2913: -- add responsibility and return
2914: -- log file
2915: fnd_file.put_line (fnd_file.LOG,
2916: 'user : ' ||
2917: x_user_name ||
2918: ' DOES NOT HAVE ERN responsibility');
2919: fnd_file.put_line (fnd_file.LOG,

Line 2919: fnd_file.put_line (fnd_file.LOG,

2915: fnd_file.put_line (fnd_file.LOG,
2916: 'user : ' ||
2917: x_user_name ||
2918: ' DOES NOT HAVE ERN responsibility');
2919: fnd_file.put_line (fnd_file.LOG,
2920: 'assign responsibility to user created');
2921: fnd_file.put_line (fnd_file.LOG,
2922: 'l_responsibility_id : ' ||
2923: l_responsibility_id);

Line 2921: fnd_file.put_line (fnd_file.LOG,

2917: x_user_name ||
2918: ' DOES NOT HAVE ERN responsibility');
2919: fnd_file.put_line (fnd_file.LOG,
2920: 'assign responsibility to user created');
2921: fnd_file.put_line (fnd_file.LOG,
2922: 'l_responsibility_id : ' ||
2923: l_responsibility_id);
2924: fnd_file.put_line (fnd_file.LOG,
2925: 'l_security_grp_id : ' ||

Line 2924: fnd_file.put_line (fnd_file.LOG,

2920: 'assign responsibility to user created');
2921: fnd_file.put_line (fnd_file.LOG,
2922: 'l_responsibility_id : ' ||
2923: l_responsibility_id);
2924: fnd_file.put_line (fnd_file.LOG,
2925: 'l_security_grp_id : ' ||
2926: l_security_grp_id);
2927: fnd_user_resp_groups_api.insert_assignment
2928: (user_id => l_user_id,

Line 2961: fnd_file.put_line (fnd_file.LOG, 'error in fnd_profile.save ');

2957: );
2958: END IF;
2959:
2960: -- log file
2961: fnd_file.put_line (fnd_file.LOG, 'error in fnd_profile.save ');
2962: fnd_file.put_line (fnd_file.LOG, SQLERRM);
2963: RAISE fnd_api.g_exc_error;
2964: END IF; -- l_return_value
2965: END IF; -- assignment_exists

Line 2962: fnd_file.put_line (fnd_file.LOG, SQLERRM);

2958: END IF;
2959:
2960: -- log file
2961: fnd_file.put_line (fnd_file.LOG, 'error in fnd_profile.save ');
2962: fnd_file.put_line (fnd_file.LOG, SQLERRM);
2963: RAISE fnd_api.g_exc_error;
2964: END IF; -- l_return_value
2965: END IF; -- assignment_exists
2966: END IF; -- x_user_name IS NOT NULL THEN

Line 3009: fnd_file.put_line (fnd_file.LOG,

3005: );
3006: END IF;
3007:
3008: -- log file
3009: fnd_file.put_line (fnd_file.LOG,
3010: 'Check FND User record for user name : ' ||
3011: p_user_name);
3012: fnd_file.put_line (fnd_file.LOG,
3013: 'l_fnd_person_party_id : ' ||

Line 3012: fnd_file.put_line (fnd_file.LOG,

3008: -- log file
3009: fnd_file.put_line (fnd_file.LOG,
3010: 'Check FND User record for user name : ' ||
3011: p_user_name);
3012: fnd_file.put_line (fnd_file.LOG,
3013: 'l_fnd_person_party_id : ' ||
3014: l_fnd_person_party_id);
3015: fnd_file.put_line (fnd_file.LOG, 'l_start_date : ' ||
3016: l_start_date);

Line 3015: fnd_file.put_line (fnd_file.LOG, 'l_start_date : ' ||

3011: p_user_name);
3012: fnd_file.put_line (fnd_file.LOG,
3013: 'l_fnd_person_party_id : ' ||
3014: l_fnd_person_party_id);
3015: fnd_file.put_line (fnd_file.LOG, 'l_start_date : ' ||
3016: l_start_date);
3017: fnd_file.put_line (fnd_file.LOG, 'l_end_date : ' ||
3018: l_end_date);
3019:

Line 3017: fnd_file.put_line (fnd_file.LOG, 'l_end_date : ' ||

3013: 'l_fnd_person_party_id : ' ||
3014: l_fnd_person_party_id);
3015: fnd_file.put_line (fnd_file.LOG, 'l_start_date : ' ||
3016: l_start_date);
3017: fnd_file.put_line (fnd_file.LOG, 'l_end_date : ' ||
3018: l_end_date);
3019:
3020: IF csr_chk_qtc_fnd_user%NOTFOUND
3021: THEN

Line 3032: fnd_file.put_line

3028: --@ USER_SYNCHED constant pls_integer := 3;
3029: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
3030:
3031: -- log file
3032: fnd_file.put_line
3033: (fnd_file.LOG,
3034: 'Getting Suggested username, calling UMX_PUB.get_suggested_username');
3035:
3036: -- Call API UMX_PUB.get_suggested_username to get the suggested user name

Line 3033: (fnd_file.LOG,

3029: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
3030:
3031: -- log file
3032: fnd_file.put_line
3033: (fnd_file.LOG,
3034: 'Getting Suggested username, calling UMX_PUB.get_suggested_username');
3035:
3036: -- Call API UMX_PUB.get_suggested_username to get the suggested user name
3037: UMX_PUB.get_suggested_username(p_person_party_id => l_person_party_id,

Line 3041: fnd_file.put_line

3037: UMX_PUB.get_suggested_username(p_person_party_id => l_person_party_id,
3038: x_suggested_username => l_suggested_user_name);
3039:
3040: -- log file
3041: fnd_file.put_line
3042: (fnd_file.LOG,
3043: 'Suggested username : '||l_suggested_user_name);
3044:
3045: -- debug log

Line 3042: (fnd_file.LOG,

3038: x_suggested_username => l_suggested_user_name);
3039:
3040: -- log file
3041: fnd_file.put_line
3042: (fnd_file.LOG,
3043: 'Suggested username : '||l_suggested_user_name);
3044:
3045: -- debug log
3046: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 3073: fnd_file.put_line

3069: );
3070: END IF;
3071:
3072: -- log file
3073: fnd_file.put_line
3074: (fnd_file.LOG,
3075: 'Creating New user, calling FND_USER_PKG.TestUserName for username :'||l_suggested_user_name);
3076: l_test_user :=
3077: fnd_user_pkg.testusername

Line 3074: (fnd_file.LOG,

3070: END IF;
3071:
3072: -- log file
3073: fnd_file.put_line
3074: (fnd_file.LOG,
3075: 'Creating New user, calling FND_USER_PKG.TestUserName for username :'||l_suggested_user_name);
3076: l_test_user :=
3077: fnd_user_pkg.testusername
3078: (x_user_name => l_suggested_user_name);

Line 3092: fnd_file.put_line

3088: );
3089: END IF;
3090:
3091: -- log file
3092: fnd_file.put_line
3093: (fnd_file.LOG,
3094: 'After calling FND_USER_PKG.TestUserName l_test_user : ' ||
3095: l_test_user);
3096:

Line 3093: (fnd_file.LOG,

3089: END IF;
3090:
3091: -- log file
3092: fnd_file.put_line
3093: (fnd_file.LOG,
3094: 'After calling FND_USER_PKG.TestUserName l_test_user : ' ||
3095: l_test_user);
3096:
3097: IF l_test_user IN (0, 3)

Line 3108: fnd_file.put_line

3104: round(dbms_random.value(100,999));
3105: */
3106:
3107: -- log file
3108: fnd_file.put_line
3109: (fnd_file.LOG,
3110: 'ok to create a new user, calling FND_CRYPTO.randombytes');
3111: x_password :=
3112: fnd_crypto.randomstring

Line 3109: (fnd_file.LOG,

3105: */
3106:
3107: -- log file
3108: fnd_file.put_line
3109: (fnd_file.LOG,
3110: 'ok to create a new user, calling FND_CRYPTO.randombytes');
3111: x_password :=
3112: fnd_crypto.randomstring
3113: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),

Line 3128: fnd_file.put_line

3124: x_person_party_id => l_person_party_id
3125: );
3126: x_user_name := l_suggested_user_name;
3127: -- log file
3128: fnd_file.put_line
3129: (fnd_file.LOG,
3130: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3131: l_user_id);
3132: ELSE -- l_test_user = 3

Line 3129: (fnd_file.LOG,

3125: );
3126: x_user_name := l_suggested_user_name;
3127: -- log file
3128: fnd_file.put_line
3129: (fnd_file.LOG,
3130: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3131: l_user_id);
3132: ELSE -- l_test_user = 3
3133: -- USER_SYNCHED constant pls_integer := 3;

Line 3138: fnd_file.put_line

3134: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID
3135: -- in Notification, put the password as '******'
3136:
3137: -- log file
3138: fnd_file.put_line
3139: (fnd_file.LOG,
3140: 'USER_SYNCHED , calling FND_USER_PKG.CreateUserIdParty');
3141: l_user_id :=
3142: fnd_user_pkg.createuseridparty

Line 3139: (fnd_file.LOG,

3135: -- in Notification, put the password as '******'
3136:
3137: -- log file
3138: fnd_file.put_line
3139: (fnd_file.LOG,
3140: 'USER_SYNCHED , calling FND_USER_PKG.CreateUserIdParty');
3141: l_user_id :=
3142: fnd_user_pkg.createuseridparty
3143: (x_user_name => l_suggested_user_name,

Line 3154: fnd_file.put_line

3150: );
3151: x_user_name := l_suggested_user_name;
3152: x_password := '******';
3153: -- log file
3154: fnd_file.put_line
3155: (fnd_file.LOG,
3156: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3157: l_user_id);
3158: END IF; -- l_test_user = 0 or 3

Line 3155: (fnd_file.LOG,

3151: x_user_name := l_suggested_user_name;
3152: x_password := '******';
3153: -- log file
3154: fnd_file.put_line
3155: (fnd_file.LOG,
3156: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3157: l_user_id);
3158: END IF; -- l_test_user = 0 or 3
3159:

Line 3184: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||

3180: );
3181: END IF;
3182:
3183: -- log file
3184: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||
3185: l_user_id);
3186: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||
3187: x_user_name);
3188:

Line 3186: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||

3182:
3183: -- log file
3184: fnd_file.put_line (fnd_file.LOG, 'l_user_id : ' ||
3185: l_user_id);
3186: fnd_file.put_line (fnd_file.LOG, 'x_user_name : ' ||
3187: x_user_name);
3188:
3189: IF l_user_id IS NOT NULL
3190: THEN

Line 3225: fnd_file.put_line (fnd_file.LOG,

3221: );
3222: END IF;
3223:
3224: -- log file
3225: fnd_file.put_line (fnd_file.LOG,
3226: 'assign responsibility to user created');
3227: fnd_file.put_line (fnd_file.LOG,
3228: 'l_responsibility_id : ' ||
3229: l_responsibility_id);

Line 3227: fnd_file.put_line (fnd_file.LOG,

3223:
3224: -- log file
3225: fnd_file.put_line (fnd_file.LOG,
3226: 'assign responsibility to user created');
3227: fnd_file.put_line (fnd_file.LOG,
3228: 'l_responsibility_id : ' ||
3229: l_responsibility_id);
3230: fnd_file.put_line (fnd_file.LOG,
3231: 'l_security_grp_id : ' ||

Line 3230: fnd_file.put_line (fnd_file.LOG,

3226: 'assign responsibility to user created');
3227: fnd_file.put_line (fnd_file.LOG,
3228: 'l_responsibility_id : ' ||
3229: l_responsibility_id);
3230: fnd_file.put_line (fnd_file.LOG,
3231: 'l_security_grp_id : ' ||
3232: l_security_grp_id);
3233: fnd_user_resp_groups_api.insert_assignment
3234: (user_id => l_user_id,

Line 3268: fnd_file.put_line (fnd_file.LOG,

3264: );
3265: END IF;
3266:
3267: -- log file
3268: fnd_file.put_line (fnd_file.LOG,
3269: 'error in fnd_profile.save ');
3270: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3271: RAISE fnd_api.g_exc_error;
3272: END IF;

Line 3270: fnd_file.put_line (fnd_file.LOG, SQLERRM);

3266:
3267: -- log file
3268: fnd_file.put_line (fnd_file.LOG,
3269: 'error in fnd_profile.save ');
3270: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3271: RAISE fnd_api.g_exc_error;
3272: END IF;
3273: ELSE
3274: -- l_user_id is null, raise exception

Line 3287: fnd_file.put_line (fnd_file.LOG,

3283: );
3284: END IF;
3285:
3286: -- log file
3287: fnd_file.put_line (fnd_file.LOG,
3288: 'l_user_id is null, raise exception ');
3289: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3290: RAISE fnd_api.g_exc_error;
3291: END IF; -- l_user_id is not null

Line 3289: fnd_file.put_line (fnd_file.LOG, SQLERRM);

3285:
3286: -- log file
3287: fnd_file.put_line (fnd_file.LOG,
3288: 'l_user_id is null, raise exception ');
3289: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3290: RAISE fnd_api.g_exc_error;
3291: END IF; -- l_user_id is not null
3292: ELSE -- l_test_user <> 0 ,3
3293: -- error, raise exception

Line 3298: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');

3294: fnd_message.set_name ('OKS', 'OKS_SSO_TEST_USER_ERROR');
3295: fnd_message.set_token ('RETURN_VAL', l_test_user);
3296: fnd_msg_pub.ADD;
3297: -- log file
3298: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');
3299: fnd_file.put_line (fnd_file.LOG, 'l_test_user: ' ||
3300: l_test_user);
3301: RAISE fnd_api.g_exc_error;
3302: END IF; -- l_test_user check

Line 3299: fnd_file.put_line (fnd_file.LOG, 'l_test_user: ' ||

3295: fnd_message.set_token ('RETURN_VAL', l_test_user);
3296: fnd_msg_pub.ADD;
3297: -- log file
3298: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_TEST_USER_ERROR');
3299: fnd_file.put_line (fnd_file.LOG, 'l_test_user: ' ||
3300: l_test_user);
3301: RAISE fnd_api.g_exc_error;
3302: END IF; -- l_test_user check
3303: ELSE -- csr_chk_qtc_fnd_user%FOUND

Line 3311: fnd_file.put_line

3307: THEN
3308: -- fnd user is valid
3309:
3310: -- log file
3311: fnd_file.put_line
3312: (fnd_file.LOG,
3313: 'chk_qtc_fnd_user%FOUND, check if the above fnd_user is valid');
3314: fnd_file.put_line (fnd_file.LOG,
3315: 'l_fnd_person_party_id : ' ||

Line 3312: (fnd_file.LOG,

3308: -- fnd user is valid
3309:
3310: -- log file
3311: fnd_file.put_line
3312: (fnd_file.LOG,
3313: 'chk_qtc_fnd_user%FOUND, check if the above fnd_user is valid');
3314: fnd_file.put_line (fnd_file.LOG,
3315: 'l_fnd_person_party_id : ' ||
3316: l_fnd_person_party_id);

Line 3314: fnd_file.put_line (fnd_file.LOG,

3310: -- log file
3311: fnd_file.put_line
3312: (fnd_file.LOG,
3313: 'chk_qtc_fnd_user%FOUND, check if the above fnd_user is valid');
3314: fnd_file.put_line (fnd_file.LOG,
3315: 'l_fnd_person_party_id : ' ||
3316: l_fnd_person_party_id);
3317: fnd_file.put_line (fnd_file.LOG,
3318: 'l_person_party_id : ' ||

Line 3317: fnd_file.put_line (fnd_file.LOG,

3313: 'chk_qtc_fnd_user%FOUND, check if the above fnd_user is valid');
3314: fnd_file.put_line (fnd_file.LOG,
3315: 'l_fnd_person_party_id : ' ||
3316: l_fnd_person_party_id);
3317: fnd_file.put_line (fnd_file.LOG,
3318: 'l_person_party_id : ' ||
3319: l_person_party_id);
3320:
3321: -- Check the person_party_id of the fnd_user

Line 3337: fnd_file.put_line (fnd_file.LOG,'OKS Person Party Name: '||l_oks_per_party_name);

3333: OPEN csr_get_per_party_name (p_party_id => l_person_party_id);
3334: FETCH csr_get_per_party_name INTO l_oks_per_party_name;
3335: CLOSE csr_get_per_party_name;
3336: -- log file
3337: fnd_file.put_line (fnd_file.LOG,'OKS Person Party Name: '||l_oks_per_party_name);
3338:
3339: -- fnd person party name
3340: OPEN csr_get_per_party_name (p_party_id => l_fnd_person_party_id);
3341: FETCH csr_get_per_party_name INTO l_fnd_per_party_name;

Line 3344: fnd_file.put_line (fnd_file.LOG,'FND Person Party Name: '||l_fnd_per_party_name);

3340: OPEN csr_get_per_party_name (p_party_id => l_fnd_person_party_id);
3341: FETCH csr_get_per_party_name INTO l_fnd_per_party_name;
3342: CLOSE csr_get_per_party_name;
3343: -- log file
3344: fnd_file.put_line (fnd_file.LOG,'FND Person Party Name: '||l_fnd_per_party_name);
3345:
3346: -- get the party name (organization name) for oks person
3347: OPEN csr_get_party_name (p_party_id => l_person_party_id);
3348: FETCH csr_get_party_name INTO l_oks_party_name, l_oks_party_id;

Line 3351: fnd_file.put_line (fnd_file.LOG,'OKS Party Name: '||l_oks_party_name);

3347: OPEN csr_get_party_name (p_party_id => l_person_party_id);
3348: FETCH csr_get_party_name INTO l_oks_party_name, l_oks_party_id;
3349: CLOSE csr_get_party_name;
3350: -- log file
3351: fnd_file.put_line (fnd_file.LOG,'OKS Party Name: '||l_oks_party_name);
3352: fnd_file.put_line (fnd_file.LOG,'OKS Party ID: '||l_oks_party_id);
3353:
3354: -- get the party name (organization name) for FND person
3355: OPEN csr_get_party_name (p_party_id => l_fnd_person_party_id);

Line 3352: fnd_file.put_line (fnd_file.LOG,'OKS Party ID: '||l_oks_party_id);

3348: FETCH csr_get_party_name INTO l_oks_party_name, l_oks_party_id;
3349: CLOSE csr_get_party_name;
3350: -- log file
3351: fnd_file.put_line (fnd_file.LOG,'OKS Party Name: '||l_oks_party_name);
3352: fnd_file.put_line (fnd_file.LOG,'OKS Party ID: '||l_oks_party_id);
3353:
3354: -- get the party name (organization name) for FND person
3355: OPEN csr_get_party_name (p_party_id => l_fnd_person_party_id);
3356: FETCH csr_get_party_name INTO l_fnd_party_name, l_fnd_party_id;

Line 3359: fnd_file.put_line (fnd_file.LOG,'FND Party Name: '||l_fnd_party_name);

3355: OPEN csr_get_party_name (p_party_id => l_fnd_person_party_id);
3356: FETCH csr_get_party_name INTO l_fnd_party_name, l_fnd_party_id;
3357: CLOSE csr_get_party_name;
3358: -- log file
3359: fnd_file.put_line (fnd_file.LOG,'FND Party Name: '||l_fnd_party_name);
3360: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3361:
3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');

Line 3360: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);

3356: FETCH csr_get_party_name INTO l_fnd_party_name, l_fnd_party_id;
3357: CLOSE csr_get_party_name;
3358: -- log file
3359: fnd_file.put_line (fnd_file.LOG,'FND Party Name: '||l_fnd_party_name);
3360: fnd_file.put_line (fnd_file.LOG,'FND Party ID: '||l_fnd_party_id);
3361:
3362: -- set error message
3363: fnd_message.set_name ('OKS', 'OKS_SSO_PERSON_PARTY_ERROR');
3364: fnd_message.set_token ('OKS_USER_NAME', p_user_name);

Line 3376: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_PERSON_PARTY_ERROR');

3372: fnd_message.set_token ('FND_PERSON_PARTY_NAME', l_fnd_per_party_name); -- bug 6338286
3373: fnd_msg_pub.ADD;
3374:
3375: -- log file
3376: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_PERSON_PARTY_ERROR');
3377: RAISE fnd_api.g_exc_error;
3378: END IF; -- person_party_id check
3379:
3380: x_user_name := UPPER (TRIM (p_user_name));

Line 3392: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');

3388: fnd_message.set_name ('OKS', 'OKS_SSO_USER_EXPIRED');
3389: fnd_message.set_token ('USER_NAME', UPPER (TRIM (p_user_name)));
3390: fnd_msg_pub.ADD;
3391: -- log file
3392: fnd_file.put_line (fnd_file.LOG, 'OKS_SSO_USER_EXPIRED ');
3393: RAISE fnd_api.g_exc_error;
3394: END IF;
3395: END IF;
3396:

Line 3400: fnd_file.put_line (fnd_file.LOG, ' ');

3396:
3397: CLOSE csr_chk_qtc_fnd_user;
3398:
3399: -- log file
3400: fnd_file.put_line (fnd_file.LOG, ' ');
3401: fnd_file.put_line
3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');

Line 3401: fnd_file.put_line

3397: CLOSE csr_chk_qtc_fnd_user;
3398:
3399: -- log file
3400: fnd_file.put_line (fnd_file.LOG, ' ');
3401: fnd_file.put_line
3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line

Line 3402: (fnd_file.LOG,

3398:
3399: -- log file
3400: fnd_file.put_line (fnd_file.LOG, ' ');
3401: fnd_file.put_line
3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line
3406: (fnd_file.LOG,

Line 3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');

3400: fnd_file.put_line (fnd_file.LOG, ' ');
3401: fnd_file.put_line
3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line
3406: (fnd_file.LOG,
3407: '---------------------------------------------------------- ');
3408: fnd_file.put_line (fnd_file.LOG, ' ');

Line 3405: fnd_file.put_line

3401: fnd_file.put_line
3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line
3406: (fnd_file.LOG,
3407: '---------------------------------------------------------- ');
3408: fnd_file.put_line (fnd_file.LOG, ' ');
3409: -- Standard call to get message count and if count is 1, get message info.

Line 3406: (fnd_file.LOG,

3402: (fnd_file.LOG,
3403: '---------------------------------------------------------- ');
3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line
3406: (fnd_file.LOG,
3407: '---------------------------------------------------------- ');
3408: fnd_file.put_line (fnd_file.LOG, ' ');
3409: -- Standard call to get message count and if count is 1, get message info.
3410: fnd_msg_pub.count_and_get (p_encoded => 'F',

Line 3408: fnd_file.put_line (fnd_file.LOG, ' ');

3404: fnd_file.put_line (fnd_file.LOG, 'Leaving create_sso_user');
3405: fnd_file.put_line
3406: (fnd_file.LOG,
3407: '---------------------------------------------------------- ');
3408: fnd_file.put_line (fnd_file.LOG, ' ');
3409: -- Standard call to get message count and if count is 1, get message info.
3410: fnd_msg_pub.count_and_get (p_encoded => 'F',
3411: p_count => x_msg_count,
3412: p_data => x_msg_data

Line 3443: fnd_file.put_line (fnd_file.LOG, '2000: Leaving create_sso_user');

3439: l_api_name
3440: );
3441: END IF;
3442:
3443: fnd_file.put_line (fnd_file.LOG, '2000: Leaving create_sso_user');
3444:
3445: x_return_status := g_ret_sts_error;
3446: fnd_msg_pub.count_and_get (p_encoded => 'F',
3447: p_count => x_msg_count,

Line 3464: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');

3460: l_api_name
3461: );
3462: END IF;
3463:
3464: fnd_file.put_line (fnd_file.LOG, '3000: Leaving create_sso_user');
3465:
3466: x_return_status := g_ret_sts_unexp_error;
3467: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3468: fnd_msg_pub.count_and_get (p_encoded => 'F',

Line 3486: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');

3482: l_api_name
3483: );
3484: END IF;
3485:
3486: fnd_file.put_line (fnd_file.LOG, '4000: Leaving create_sso_user');
3487:
3488: x_return_status := g_ret_sts_error;
3489: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
3490: fnd_msg_pub.count_and_get (p_encoded => 'F',