64: IF x_msg_data IS NOT NULL THEN
65: x_msg_count := 1;
66: END IF;
67:
68: pos_log.log_call_result
69: (p_module => 'POSADMB',
70: p_prefix => 'call fnd_user_pkg.update_user',
71: p_return_status => x_return_status,
72: p_msg_count => x_msg_count,
103: x_return_status := fnd_api.g_ret_sts_success;
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: pos_log.log_sqlerrm('POSADMB', 'in reset_password');
108: RAISE;
109: END reset_password;
110:
111: PROCEDURE set_user_inactive_date
158: x_return_status := fnd_api.g_ret_sts_success;
159:
160: EXCEPTION
161: WHEN OTHERS THEN
162: pos_log.log_sqlerrm('POSADMB', 'in reset_password');
163: RAISE;
164: END set_user_inactive_date;
165:
166: procedure grant_user_resp
187: x_return_status := fnd_api.g_ret_sts_success;
188:
189: EXCEPTION
190: WHEN OTHERS THEN
191: pos_log.log_sqlerrm
192: ('POSADMB',
193: 'in grant_user_resp: p_user_id = ' || p_user_id
194: || ' p_resp_id = ' || p_resp_id
195: || ' p_resp_app_id = ' || p_resp_app_id
289: x_return_status := fnd_api.g_ret_sts_success;
290:
291: EXCEPTION
292: WHEN OTHERS THEN
293: pos_log.log_sqlerrm('POSADMB', 'in revoke_user_resp');
294: RAISE;
295: END revoke_user_resp;
296:
297: procedure revoke_user_resps
398: x_msg_count => x_msg_count,
399: x_msg_data => x_msg_data
400: );
401:
402: pos_log.log_call_result
403: (p_module => 'POSADMB',
404: p_prefix => 'call hz_party_v2pub.update_person.update_person',
405: p_return_status => x_return_status,
406: p_msg_count => x_msg_count,
469: x_return_status := fnd_api.g_ret_sts_success;
470:
471: EXCEPTION
472: WHEN OTHERS THEN
473: pos_log.log_sqlerrm('POSADMB', 'in update_user_info');
474: raise_application_error(-20002,'POSADMB:UPDATE_USER_INFO: Caught an exception', true);
475: END update_user_info;
476:
477: PROCEDURE createsecattr
504: p_last_update_date => Sysdate,
505: p_last_update_login => fnd_global.login_id
506: );
507:
508: pos_log.log_call_result
509: (p_module => 'POSADMB',
510: p_prefix => 'call icx_user_sec_attr_pvt.create_user_sec_attr ',
511: p_return_status => l_return_status,
512: p_msg_count => l_msg_count,
514: );
515:
516: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN
517: IF l_msg_count > 0 THEN
518: pos_log.combine_fnd_msg(l_msg_count, l_msg_data);
519: END IF;
520:
521: raise_application_error(-20001
522: ,'POSADMB.createsecattr '
526: );
527: END IF;
528: EXCEPTION
529: WHEN OTHERS THEN
530: pos_log.log_sqlerrm('POSADMB','in createsecattr');
531: RAISE;
532: END createsecattr;
533:
534: PROCEDURE deletesecattr
556: p_date_value => p_date_value,
557: p_number_value => p_number_value
558: );
559:
560: pos_log.log_call_result
561: (p_module => 'POSADMB',
562: p_prefix => 'call icx_user_sec_attr_pvt.delete_user_sec_attr ',
563: p_return_status => l_return_status,
564: p_msg_count => l_msg_count,
566: );
567:
568: IF l_return_status IS NULL OR l_return_status <> fnd_api.g_ret_sts_success THEN
569: IF l_msg_count > 0 THEN
570: pos_log.combine_fnd_msg(l_msg_count, l_msg_data);
571: END IF;
572:
573: raise_application_error(-20001
574: ,'POSADMB.deletesecattr '
578: );
579: END IF;
580: EXCEPTION
581: WHEN OTHERS THEN
582: pos_log.log_sqlerrm('POSADMB','in deletesecattr');
583: RAISE;
584: END deletesecattr;
585:
586:
618: ELSE
619: IF l_msg_count = 1 THEN
620: x_exception_msg := l_msg_data;
621: ELSE
622: pos_log.combine_fnd_msg(l_msg_count, x_exception_msg);
623: END IF;
624: END IF;
625: END grant_user_resp;
626:
651: ELSE
652: IF l_msg_count = 1 THEN
653: x_exception_msg := l_msg_data;
654: ELSE
655: pos_log.combine_fnd_msg(l_msg_count, x_exception_msg);
656: END IF;
657: END IF;
658: END revoke_user_resp;
659:
698: ELSE
699: IF l_msg_count = 1 THEN
700: x_exception_msg := l_msg_data;
701: ELSE
702: pos_log.combine_fnd_msg(l_msg_count, x_exception_msg);
703: END IF;
704: END IF;
705: END update_user_info;
706:
882: ROLLBACK TO create_supp_user_account_sp;
883: x_return_status := fnd_api.g_ret_sts_error;
884: x_msg_count := 1;
885: x_msg_data := Sqlerrm;
886: pos_log.log_sqlerrm('POSADMB', 'in create_supplier_user_account');
887:
888: END create_supplier_user_account;
889:
890:
1109: WHEN OTHERS THEN
1110: x_return_status := fnd_api.g_ret_sts_error;
1111: x_msg_count := 1;
1112: x_msg_data := Sqlerrm;
1113: pos_log.log_sqlerrm('POSADMB', 'in assign_vendor_reg_def_resp, step ' || l_step );
1114:
1115: END assign_vendor_reg_def_resp;
1116:
1117:
1166: EXCEPTION
1167: WHEN OTHERS THEN
1168: x_status := fnd_api.g_ret_sts_error;
1169: x_exception_msg := 'Error creating notification subscription'||Sqlerrm;
1170: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1171:
1172: END add_certntf_subscription;
1173:
1174: procedure remove_certntf_subscription
1204: EXCEPTION
1205: WHEN OTHERS THEN
1206: x_status := fnd_api.g_ret_sts_error;
1207: x_exception_msg := 'Error removing notification subscription'||Sqlerrm;
1208: pos_log.log_sqlerrm('POSADMB', x_exception_msg);
1209:
1210: END remove_certntf_subscription;
1211:
1212: procedure get_certntf_subscription