APPS.OKS_AUTO_REMINDER dependencies on FND_PROFILE

Line 377: (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),

373: SELECT CONCAT
374: (DBMS_RANDOM.STRING
375: ('l',
376: (NVL
377: (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
378: 7) -
379: 3
380: )),
381: ROUND (DBMS_RANDOM.VALUE (100, 999)))

Line 473: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),

469: -- ok to create a new user
470: x_password :=
471: DBMS_RANDOM.STRING
472: ('l',
473: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
474: 7) -
475: 3
476: )) ||
477: ROUND (DBMS_RANDOM.VALUE (100, 999));

Line 537: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',

533: start_date => SYSDATE,
534: end_date => NULL
535: );
536: l_return_value :=
537: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
538: x_value => 'PHP',
539: x_level_name => 'USER',
540: x_level_value => TO_CHAR
541: (l_user_id)

Line 548: -- error in fnd_profile.save

544: IF l_return_value
545: THEN
546: RETURN;
547: ELSE
548: -- error in fnd_profile.save
549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');
550: x_err_msg (l_count).description := fnd_message.get;
551: RAISE fnd_api.g_exc_error;
552: END IF;

Line 549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');

545: THEN
546: RETURN;
547: ELSE
548: -- error in fnd_profile.save
549: fnd_message.set_name ('OKS', 'OKS_SSO_FND_PROFILE_ERROR');
550: x_err_msg (l_count).description := fnd_message.get;
551: RAISE fnd_api.g_exc_error;
552: END IF;
553: ELSE

Line 2937: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',

2933: start_date => SYSDATE,
2934: end_date => NULL
2935: );
2936: l_return_value :=
2937: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
2938: x_value => 'PHP',
2939: x_level_name => 'USER',
2940: x_level_value => TO_CHAR
2941: (l_user_id)

Line 2948: -- error in fnd_profile.save

2944: IF l_return_value
2945: THEN
2946: RETURN;
2947: ELSE
2948: -- error in fnd_profile.save
2949: -- debug log
2950: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
2951: )
2952: THEN

Line 2956: '135: error in fnd_profile.save : '

2952: THEN
2953: fnd_log.STRING (fnd_log.level_procedure,
2954: g_module ||
2955: l_api_name,
2956: '135: error in fnd_profile.save : '
2957: );
2958: END IF;
2959:
2960: -- log file

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 3103: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||

3099: IF l_test_user = 0
3100: THEN
3101: -- ok to create a new user
3102: /*
3103: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||
3104: round(dbms_random.value(100,999));
3105: */
3106:
3107: -- log file

Line 3113: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),

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'),
3114: 4));
3115: l_user_id :=
3116: fnd_user_pkg.createuseridparty
3117: (x_user_name => l_suggested_user_name,

Line 3243: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',

3239: start_date => SYSDATE,
3240: end_date => NULL
3241: );
3242: l_return_value :=
3243: fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
3244: x_value => 'FWK',
3245: x_level_name => 'USER',
3246: x_level_value => TO_CHAR
3247: (l_user_id)

Line 3254: -- error in fnd_profile.save

3250: IF l_return_value
3251: THEN
3252: RETURN;
3253: ELSE
3254: -- error in fnd_profile.save
3255: -- debug log
3256: IF (fnd_log.level_procedure >=
3257: fnd_log.g_current_runtime_level
3258: )

Line 3263: '180: error in fnd_profile.save : '

3259: THEN
3260: fnd_log.STRING (fnd_log.level_procedure,
3261: g_module ||
3262: l_api_name,
3263: '180: error in fnd_profile.save : '
3264: );
3265: END IF;
3266:
3267: -- log file

Line 3269: 'error in fnd_profile.save ');

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;
3273: ELSE