APPS.PON_USER_PROFILE_PKG dependencies on PON_PROFILE_UTIL_PKG

Line 22: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(p_username , p_user_language);

18:
19: BEGIN
20:
21: --store user language in fnd_preferences.
22: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(p_username , p_user_language);
23: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(UPPER(p_username) , p_user_language);
24:
25: X_STATUS :='S';
26: x_exception_msg :=NULL;

Line 23: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(UPPER(p_username) , p_user_language);

19: BEGIN
20:
21: --store user language in fnd_preferences.
22: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(p_username , p_user_language);
23: PON_PROFILE_UTIL_PKG.SET_WF_LANGUAGE(UPPER(p_username) , p_user_language);
24:
25: X_STATUS :='S';
26: x_exception_msg :=NULL;
27:

Line 31: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN

27:
28: -- commit;
29:
30: EXCEPTION
31: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN
32: rollback;
33: X_STATUS :='E';
34: raise;
35: WHEN OTHERS THEN

Line 126: PON_PROFILE_UTIL_PKG.update_or_insert_party_pref(l_user_party_id, 'PON',

122: SET email_address = p_user_email
123: WHERE person_party_id = l_user_party_id;
124:
125: -- bug 2329157 . Need the user encoding option to be set for the user
126: PON_PROFILE_UTIL_PKG.update_or_insert_party_pref(l_user_party_id, 'PON',
127: 'USER_ENCODING', p_user_encodingoption, 'User Charset Encoding Option', NULL,NULL,NULL,NULL,NULL,
128: x_status, x_exception_msg);
129:
130: X_STATUS :='S';

Line 139: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN

135: WHEN UPDATE_SUPPLIER_CONTACT_E THEN
136: X_STATUS := x_return_status;
137: x_exception_msg := x_msg_data;
138: raise;
139: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN
140: --dbms_output.put_line('HZ failure ' || x_exception_msg);
141: --rollback; -- jazhang 01/08
142: X_STATUS :='E';
143: raise;

Line 323: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',

319: AND rownum = 1;
320: END; --}
321:
322: BEGIN
323: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',
324: 'USER_ENCODING',x_user_encodingoption,l_meaning,l_attribute,l_attribute,
325: l_attribute, l_attribute,l_attribute, x_status, x_exception_msg);
326: EXCEPTION
327: WHEN NO_DATA_FOUND THEN

Line 466: pon_profile_util_pkg.retrieve_party_preference(

462: x_exception_msg := 'begin: retrieve_pwd_challenge';
463:
464: -- retrieve the user's password challenge question and response
465: x_exception_msg := 'getting the password challenge question and response';
466: pon_profile_util_pkg.retrieve_party_preference(
467: p_party_id => p_user_party_id,
468: p_app_short_name => 'PON',
469: p_pref_name => 'PON_USER_PWD_QUESTION',
470: x_pref_value => x_user_pwd_question,

Line 480: pon_profile_util_pkg.retrieve_party_preference(

476: x_attribute5 => l_attribute,
477: x_status => x_status,
478: x_exception_msg => x_exception_msg);
479:
480: pon_profile_util_pkg.retrieve_party_preference(
481: p_party_id => p_user_party_id,
482: p_app_short_name => 'PON',
483: p_pref_name => 'PON_USER_PWD_RESPONSE',
484: x_pref_value => x_user_pwd_response,

Line 529: pon_profile_util_pkg.update_or_insert_party_pref(

525:
526: --encrypt the response
527: -- PON_UTIL_MGR.pass_util_info(P_USER_PWD_RESPONSE, l_pwd_response_encrypted);
528:
529: pon_profile_util_pkg.update_or_insert_party_pref(
530: p_party_id => p_user_party_id,
531: p_app_short_name => 'PON',
532: p_pref_name => 'PON_USER_PWD_QUESTION',
533: p_pref_value => p_user_pwd_question,

Line 543: pon_profile_util_pkg.update_or_insert_party_pref(

539: p_attribute5 => NULL,
540: x_status => x_status,
541: x_exception_msg => x_exception_msg);
542:
543: pon_profile_util_pkg.update_or_insert_party_pref(
544: p_party_id => p_user_party_id,
545: p_app_short_name => 'PON',
546: p_pref_name => 'PON_USER_PWD_RESPONSE',
547: p_pref_value => p_user_pwd_response,

Line 561: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN

557: x_status := 'S';
558: x_exception_msg := '';
559:
560: EXCEPTION
561: WHEN PON_PROFILE_UTIL_PKG.HZ_FAIL_EXCEPTION THEN
562: --dbms_output.put_line('HZ failure ' || x_exception_msg);
563: rollback;
564: X_STATUS :='E';
565: raise;

Line 902: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',

898: x_user_default_dateformat := '';
899: x_user_locale := '';
900:
901: BEGIN
902: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',
903: 'USER_ENCODING',x_user_encodingoption,l_meaning,l_attribute,l_attribute,
904: l_attribute, l_attribute,l_attribute, x_status, x_exception_msg);
905: EXCEPTION
906: WHEN NO_DATA_FOUND THEN

Line 1024: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',

1020: X_USER_FAX_AREA_CODE := '';
1021: X_USER_FAX_EXTENSION := '';
1022:
1023: BEGIN
1024: PON_PROFILE_UTIL_PKG.retrieve_party_preference(x_user_party_id,'PON',
1025: 'USER_ENCODING',x_user_encodingoption,l_meaning,l_attribute,l_attribute,
1026: l_attribute, l_attribute,l_attribute, x_status, x_exception_msg);
1027: EXCEPTION
1028: WHEN OTHERS THEN