[Home] [Help]
1: PACKAGE BODY UMX_REG_REQUESTS_PVT AS
2: /* $Header: UMXVRRSB.pls 120.6.12010000.2 2008/12/03 13:01:55 jstyles ship $ */
3:
4: -- procedure
5: --
51:
52: if ( p_reg_request.requested_for_user_id is null) then
53: fnd_message.set_name('FND','UMX_COMMON_MISS_PARAM_MSG');
54: fnd_message.set_token('PARAM', 'p_reg_request.requested_for_user_id');
55: fnd_message.set_token('API', 'UMX_REG_REQUESTS_PVT.populateRegRecord');
56: raise_application_error ('-20000', fnd_message.get);
57:
58: else
59:
63: if (getPersonPartyId%notfound) then
64: close getPersonPartyId;
65: fnd_message.set_name('FND','UMX_COMMON_MISS_PARAM_MSG');
66: fnd_message.set_token('PARAM', 'getPersonPartyId');
67: fnd_message.set_token('API', 'UMX_REG_REQUESTS_PVT.populateRegRecord');
68: raise_application_error ('-20000', fnd_message.get);
69: end if;
70:
71: close getPersonPartyId;
94: elsif (p_reg_request.wf_role_name is null) then
95: -- this is a smart request and role name should be passed
96: fnd_message.set_name('FND','UMX_COMMON_MISS_PARAM_MSG');
97: fnd_message.set_token('PARAM', 'p_reg_request.wf_role_name');
98: fnd_message.set_token('API', 'UMX_REG_REQUESTS_PVT.populateRegRecord');
99: raise_application_error ('-20000', fnd_message.get);
100: end if;
101:
102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
322: if (p_username is null) or (l_username is null) then
323: -- Username is a required input parameter.
324: fnd_message.set_name('FND','UMX_COMMON_MISS_PARAM_MSG');
325: fnd_message.set_token('PARAM', 'p_username');
326: fnd_message.set_token('API', 'UMX_REG_REQUESTS_PVT.is_username_available');
327: raise_application_error ('-20000', fnd_message.get);
328: end if;
329:
330: open getUserFromFNDUSER (l_username);
1179: else
1180:
1181: -- There is an error while calling this API:
1182: -- All required input parameters are null
1183: raise_application_error ('-20000', 'Both p_requester_user_id and x_reg_request_id is null while calling UMX_REG_REQUESTS_PVT.get_pend_acct_info API.');
1184:
1185: end if;
1186:
1187: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1192:
1193: -- Get Current Approver name and email address
1194: if (x_status_code = 'PENDING') then
1195: -- Status code could be 'VERIFYING', in that case, don't get the next approver.
1196: UMX_REG_REQUESTS_PVT.get_current_approver_info (p_reg_request_id => x_reg_request_id,
1197: p_application_id => l_application_id,
1198: p_transaction_type_id => l_transaction_type_id,
1199: x_approver_name => x_approver_name,
1200: x_approver_email => x_approver_email_address);
1297: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1298: 'p_requester_user_id: ' || p_requester_user_id);
1299: end if;
1300:
1301: UMX_REG_REQUESTS_PVT.get_pend_acct_info (
1302: p_requester_user_id => p_requester_user_id,
1303: x_reg_request_id => x_reg_request_id,
1304: x_requested_for_username => x_requested_for_username,
1305: x_approver_name => x_approver_name,
1373: end if;
1374:
1375: l_reg_request_id := p_reg_request_id;
1376:
1377: UMX_REG_REQUESTS_PVT.get_pend_acct_info (
1378: x_reg_request_id => l_reg_request_id,
1379: x_requested_for_username => l_requested_for_username,
1380: x_approver_name => x_approver_name,
1381: x_approver_email_address => x_approver_email_address,
1691: end if;
1692:
1693: END is_pend_account_error;
1694:
1695: END UMX_REG_REQUESTS_PVT;