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_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 2631: fnd_profile.save api, this has been added as per the AOL team suggestion

2627: END validate_autoreminder_k;
2628:
2629: /*added for bug10018402*/
2630: /*following function is used to issue explicit commit once we make a call to
2631: fnd_profile.save api, this has been added as per the AOL team suggestion
2632: given in bug10022142*/
2633:
2634: FUNCTION set_user_home_page(l_value varchar2, l_level_value number)
2635: RETURN boolean AS

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

2643: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,G_MODULE||l_api_name,
2644: 'Entered '||G_PKG_NAME ||'.'||l_api_name );
2645: END IF;
2646:
2647: l_return_value := fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
2648: x_value => l_value,
2649: x_level_name => 'USER',
2650: x_level_value => to_char(l_level_value)
2651: );

Line 3084: /* fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',

3080: );
3081: /*modified for bug10018402*/
3082: l_return_value := set_user_home_page('PHP', l_user_id);
3083:
3084: /* fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
3085: x_value => 'PHP',
3086: x_level_name => 'USER',
3087: x_level_value => TO_CHAR
3088: (l_user_id)

Line 3095: -- error in fnd_profile.save

3091: IF l_return_value
3092: THEN
3093: RETURN;
3094: ELSE
3095: -- error in fnd_profile.save
3096: -- debug log
3097: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level
3098: )
3099: THEN

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

3099: THEN
3100: fnd_log.STRING (fnd_log.level_procedure,
3101: g_module ||
3102: l_api_name,
3103: '135: error in fnd_profile.save : '
3104: );
3105: END IF;
3106:
3107: -- log file

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

3104: );
3105: END IF;
3106:
3107: -- log file
3108: fnd_file.put_line (fnd_file.LOG, 'error in fnd_profile.save ');
3109: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3110: RAISE fnd_api.g_exc_error;
3111: END IF; -- l_return_value
3112: END IF; -- assignment_exists

Line 3250: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||

3246: IF l_test_user = 0
3247: THEN
3248: -- ok to create a new user
3249: /*
3250: x_password := dbms_random.string('l', (NVL(FND_PROFILE.value('SIGNON_PASSWORD_LENGTH'),7)-3))||
3251: round(dbms_random.value(100,999));
3252: */
3253:
3254: -- log file

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

3256: (fnd_file.LOG,
3257: 'ok to create a new user, calling FND_CRYPTO.randombytes');
3258: x_password :=
3259: fnd_crypto.randomstring
3260: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
3261: 4));
3262:
3263: /*modified for bug7207391*/
3264: /*IF Nvl(fnd_profile.value('SIGNON_PASSWORD_HARD_TO_GUESS'),'N') = 'Y' THEN*/

Line 3264: /IF Nvl(fnd_profile.value('SIGNON_PASSWORD_HARD_TO_GUESS'),'N') = 'Y' THEN/

3260: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
3261: 4));
3262:
3263: /*modified for bug7207391*/
3264: /*IF Nvl(fnd_profile.value('SIGNON_PASSWORD_HARD_TO_GUESS'),'N') = 'Y' THEN*/
3265: -- loop till password clears the validations
3266: l_result := FND_WEB_SEC.validate_password (l_suggested_user_name, x_password);
3267: WHILE ((l_result <> 'Y') AND (v_counter <= 100)) LOOP
3268:

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

3271:
3272: -- generate password
3273: x_password :=
3274: fnd_crypto.randomstring
3275: (NVL (fnd_profile.VALUE ('SIGNON_PASSWORD_LENGTH'),
3276: 4));
3277:
3278: fnd_file.put_line
3279: (fnd_file.LOG,

Line 3426: /* fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',

3422: end_date => NULL
3423: );
3424: /*modified for bug10018402*/
3425: l_return_value := set_user_home_page('FWK', l_user_id);
3426: /* fnd_profile.SAVE (x_name => 'APPLICATIONS_HOME_PAGE',
3427: x_value => 'FWK',
3428: x_level_name => 'USER',
3429: x_level_value => TO_CHAR
3430: (l_user_id)

Line 3437: -- error in fnd_profile.save

3433: IF l_return_value
3434: THEN
3435: RETURN;
3436: ELSE
3437: -- error in fnd_profile.save
3438: -- debug log
3439: IF (fnd_log.level_procedure >=
3440: fnd_log.g_current_runtime_level
3441: )

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

3442: THEN
3443: fnd_log.STRING (fnd_log.level_procedure,
3444: g_module ||
3445: l_api_name,
3446: '180: error in fnd_profile.save : '
3447: );
3448: END IF;
3449:
3450: -- log file

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

3448: END IF;
3449:
3450: -- log file
3451: fnd_file.put_line (fnd_file.LOG,
3452: 'error in fnd_profile.save ');
3453: fnd_file.put_line (fnd_file.LOG, SQLERRM);
3454: RAISE fnd_api.g_exc_error;
3455: END IF;
3456: ELSE

Line 3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'

3512: THEN
3513: --codefix for bug 5893305
3514: --check the value of the profile option oks_override_sso and update
3515: --oks_k_headers_b table accordingly.
3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'
3517: THEN
3518: fnd_file.put_line (fnd_file.LOG,'Overriding SSO behavior');
3519: --update oks_k_headers_b with fnd_profile value.
3520: UPDATE oks_k_headers_b

Line 3519: --update oks_k_headers_b with fnd_profile value.

3515: --oks_k_headers_b table accordingly.
3516: IF NVL(FND_PROFILE.VALUE('OKS_OVERRIDE_SSO'),'N') <>'N'
3517: THEN
3518: fnd_file.put_line (fnd_file.LOG,'Overriding SSO behavior');
3519: --update oks_k_headers_b with fnd_profile value.
3520: UPDATE oks_k_headers_b
3521: SET person_party_id =l_fnd_person_party_id
3522: WHERE chr_id=p_contract_id;
3523: fnd_file.put_line (fnd_file.LOG,'OKS Person Party ID updated to:'||l_fnd_person_party_id);