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_USER_PKG

Line 302: Call FND_USER_PKG.TestUserName

298: If person_party_id in fnd_user = person_party_id from step 1 above
299: we are fine, do nothing
300:
301: Case B: Record NOT found in fnd_user
302: Call FND_USER_PKG.TestUserName
303: --@ TestUserName() returns:
304: --@ USER_OK_CREATE constant pls_integer := 0;
305: --@ USER_INVALID_NAME constant pls_integer := 1;
306: --@ USER_EXISTS_IN_FND constant pls_integer := 2;

Line 310: CALL FND_USER_PKG.CreateUserIdParty

306: --@ USER_EXISTS_IN_FND constant pls_integer := 2;
307: --@ USER_SYNCHED constant pls_integer := 3;
308: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
309: IF l_test_user IN (0,3) THEN
310: CALL FND_USER_PKG.CreateUserIdParty
311: Note : Call FND_CRYPTO for generating the password (track bug 4358822)
312: FND_USER_RESP_GROUPS_API.insert_assignment with responsibility as 'OKS_ERN_WEB'
313: ELSE -- l_test_user <> 0 ,3
314: -- error, raise exception

Line 463: fnd_user_pkg.testusername (x_user_name => l_user_name);

459: --@ USER_EXISTS_IN_FND constant pls_integer := 2;
460: --@ USER_SYNCHED constant pls_integer := 3;
461: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
462: l_test_user :=
463: fnd_user_pkg.testusername (x_user_name => l_user_name);
464:
465: IF l_test_user IN (0, 3)
466: THEN
467: IF l_test_user = 0

Line 479: fnd_user_pkg.createuseridparty

475: 3
476: )) ||
477: ROUND (DBMS_RANDOM.VALUE (100, 999));
478: l_user_id :=
479: fnd_user_pkg.createuseridparty
480: (x_user_name => UPPER
481: (TRIM
482: (p_user_name)),
483: x_owner => 'CUST',

Line 493: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID

489: x_person_party_id => l_qtc_person_party_id
490: );
491: ELSE -- l_test_user = 3
492: -- USER_SYNCHED constant pls_integer := 3;
493: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID
494: -- in Notification, put the password as *******'
495: l_user_id :=
496: fnd_user_pkg.createuseridparty
497: (x_user_name => UPPER

Line 496: fnd_user_pkg.createuseridparty

492: -- USER_SYNCHED constant pls_integer := 3;
493: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID
494: -- in Notification, put the password as *******'
495: l_user_id :=
496: fnd_user_pkg.createuseridparty
497: (x_user_name => UPPER
498: (TRIM
499: (p_user_name)),
500: x_owner => 'SEED',

Line 570: fnd_user_pkg.updateuserparty

566: ELSE -- l_row_notfound is false i.e record exists in fnd_user
567: x_password := '******';
568: IF l_fnd_person_party_id IS NULL
569: THEN
570: fnd_user_pkg.updateuserparty
571: (x_user_name => UPPER
572: (TRIM
573: (p_user_name)),
574: x_owner => 'CUST',

Line 2696: Call FND_USER_PKG.TestUserName

2692: Step 3: If no record found in step 2 above then check in fnd_user if record exists with the user name as quote to contact email
2693:
2694: CASE A: Record NOT Found in fnd_user
2695:
2696: Call FND_USER_PKG.TestUserName
2697: --@ TestUserName() returns:
2698: --@ USER_OK_CREATE constant pls_integer := 0;
2699: --@ USER_INVALID_NAME constant pls_integer := 1;
2700: --@ USER_EXISTS_IN_FND constant pls_integer := 2;

Line 2705: CALL FND_USER_PKG.CreateUserIdParty

2701: --@ USER_SYNCHED constant pls_integer := 3;
2702: --@ USER_EXISTS_NO_LINK_ALLOWED constant pls_integer := 4;
2703:
2704: IF l_test_user IN (0,3) THEN
2705: CALL FND_USER_PKG.CreateUserIdParty
2706: FND_USER_RESP_GROUPS_API.insert_assignment with responsibility as 'OKS_ERN_WEB'
2707:
2708: ELSE -- l_test_user <> 0 ,3
2709: -- error, raise exception

Line 3222: 'Creating New user, calling FND_USER_PKG.TestUserName for username :'||l_suggested_user_name);

3218:
3219: -- log file
3220: fnd_file.put_line
3221: (fnd_file.LOG,
3222: 'Creating New user, calling FND_USER_PKG.TestUserName for username :'||l_suggested_user_name);
3223: l_test_user :=
3224: fnd_user_pkg.testusername
3225: (x_user_name => l_suggested_user_name);
3226:

Line 3224: fnd_user_pkg.testusername

3220: fnd_file.put_line
3221: (fnd_file.LOG,
3222: 'Creating New user, calling FND_USER_PKG.TestUserName for username :'||l_suggested_user_name);
3223: l_test_user :=
3224: fnd_user_pkg.testusername
3225: (x_user_name => l_suggested_user_name);
3226:
3227: -- debug log
3228: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)

Line 3241: 'After calling FND_USER_PKG.TestUserName l_test_user : ' ||

3237:
3238: -- log file
3239: fnd_file.put_line
3240: (fnd_file.LOG,
3241: 'After calling FND_USER_PKG.TestUserName l_test_user : ' ||
3242: l_test_user);
3243:
3244: IF l_test_user IN (0, 3)
3245: THEN

Line 3298: fnd_user_pkg.createuseridparty

3294: /* END IF;*/
3295: /*end of modification for bug7207391*/
3296:
3297: l_user_id :=
3298: fnd_user_pkg.createuseridparty
3299: (x_user_name => l_suggested_user_name,
3300: x_owner => 'SEED',
3301: x_unencrypted_password => x_password,
3302: x_description => 'Electronic renewals User',

Line 3312: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||

3308: x_user_name := l_suggested_user_name;
3309: -- log file
3310: fnd_file.put_line
3311: (fnd_file.LOG,
3312: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3313: l_user_id);
3314: ELSE -- l_test_user = 3
3315: -- USER_SYNCHED constant pls_integer := 3;
3316: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID

Line 3316: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID

3312: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3313: l_user_id);
3314: ELSE -- l_test_user = 3
3315: -- USER_SYNCHED constant pls_integer := 3;
3316: -- Call the FND_USER_PKG.CreateUserIdParty WITHOUT password as password exists in OID
3317: -- in Notification, put the password as '******'
3318:
3319: -- log file
3320: fnd_file.put_line

Line 3322: 'USER_SYNCHED , calling FND_USER_PKG.CreateUserIdParty');

3318:
3319: -- log file
3320: fnd_file.put_line
3321: (fnd_file.LOG,
3322: 'USER_SYNCHED , calling FND_USER_PKG.CreateUserIdParty');
3323: l_user_id :=
3324: fnd_user_pkg.createuseridparty
3325: (x_user_name => l_suggested_user_name,
3326: x_owner => 'SEED',

Line 3324: fnd_user_pkg.createuseridparty

3320: fnd_file.put_line
3321: (fnd_file.LOG,
3322: 'USER_SYNCHED , calling FND_USER_PKG.CreateUserIdParty');
3323: l_user_id :=
3324: fnd_user_pkg.createuseridparty
3325: (x_user_name => l_suggested_user_name,
3326: x_owner => 'SEED',
3327: x_description => 'Electronic renewals User',
3328: x_email_address => UPPER

Line 3338: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||

3334: x_password := '******';
3335: -- log file
3336: fnd_file.put_line
3337: (fnd_file.LOG,
3338: 'FND_USER_PKG.CreateUserIdParty l_user_id : ' ||
3339: l_user_id);
3340: END IF; -- l_test_user = 0 or 3
3341:
3342: -- debug log