26: -- the user approval page URL
27: POS_APPROVAL_PAGE CONSTANT VARCHAR2(4000) := 'OA_HTML/OA.jsp?akRegionCode=POS_APPROVE_MAIN_RGN&akRegionApplicationId=177®istrationKey=';
28:
29: -- a global error message holder
30: ERROR_MESSAGE FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := NULL;
31:
32: -- error message names
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
29: -- a global error message holder
30: ERROR_MESSAGE FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := NULL;
31:
32: -- error message names
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
31:
32: -- error message names
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
32: -- error message names
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
33: MSG_USER_RESP_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_USER_RESP_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
34:
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
35: MSG_UNEXPECTED_ERROR CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_UNEXPECTED_ERR';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
36: MSG_FND_USER_DUPLICATE CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'SECURITY-DUPLICATE USER';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
37: MSG_USER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_USER_CREATION_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
38: MSG_VENDORUSER_CREATION_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_CREATE_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
46: MSG_VENDORUSER_DETAILS_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_DETAIL_FAIL';
39: MSG_POS_SITE_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SITE_SECATTR_FAIL';
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
46: MSG_VENDORUSER_DETAILS_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_DETAIL_FAIL';
47:
40: MSG_POS_CONTACT_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_CONT_SECATTR_FAIL';
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
46: MSG_VENDORUSER_DETAILS_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_DETAIL_FAIL';
47:
48: -- global variable for logging
41: MSG_POS_SEC_ATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_SECATTR_FAIL';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
46: MSG_VENDORUSER_DETAILS_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_DETAIL_FAIL';
47:
48: -- global variable for logging
49: g_log_module_name VARCHAR2(30) := 'pos.plsql.POSREGWB';
42: MSG_REG_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_REGLOCK_FAIL';
43: MSG_APPRV_LOCK_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_APPRVLOCK_FAIL';
44: MSG_REG_DATA_MISSING CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_DATA_MISSING';
45: MSG_POS_SUPP_SECATTR_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_SUPP_SECATTR_FAIL';
46: MSG_VENDORUSER_DETAILS_FAIL CONSTANT FND_NEW_MESSAGES.MESSAGE_NAME%TYPE := 'POS_REG_VNDR_USR_DETAIL_FAIL';
47:
48: -- global variable for logging
49: g_log_module_name VARCHAR2(30) := 'pos.plsql.POSREGWB';
50: g_log_proc_start VARCHAR2(30) := 'start';
311: , p_translate IN BOOLEAN DEFAULT TRUE
312: )
313:
314: IS
315: lv_prev_msg FND_NEW_MESSAGES.MESSAGE_TEXT%TYPE;
316: lv_proc_name VARCHAR2(30) := 'SetErrMsg';
317: BEGIN
318:
319: -- just to lot previous messages if any