[Home] [Help]
1: PACKAGE BODY UMX_REG_REQUESTS_PVT AS
2: /* $Header: UMXVRRSB.pls 120.11 2011/02/17 08:11:07 spakanat 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);
1327: else
1328:
1329: -- There is an error while calling this API:
1330: -- All required input parameters are null
1331: 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.');
1332:
1333: end if;
1334:
1335: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1340:
1341: -- Get Current Approver name and email address
1342: if (x_status_code = 'PENDING') then
1343: -- Status code could be 'VERIFYING', in that case, don't get the next approver.
1344: UMX_REG_REQUESTS_PVT.get_current_approver_info (p_reg_request_id => x_reg_request_id,
1345: p_application_id => l_application_id,
1346: p_transaction_type_id => l_transaction_type_id,
1347: x_approver_name => x_approver_name,
1348: x_approver_email => x_approver_email_address);
1445: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1446: 'p_requester_user_id: ' || p_requester_user_id);
1447: end if;
1448:
1449: UMX_REG_REQUESTS_PVT.get_pend_acct_info (
1450: p_requester_user_id => p_requester_user_id,
1451: x_reg_request_id => x_reg_request_id,
1452: x_requested_for_username => x_requested_for_username,
1453: x_approver_name => x_approver_name,
1521: end if;
1522:
1523: l_reg_request_id := p_reg_request_id;
1524:
1525: UMX_REG_REQUESTS_PVT.get_pend_acct_info (
1526: x_reg_request_id => l_reg_request_id,
1527: x_requested_for_username => l_requested_for_username,
1528: x_approver_name => x_approver_name,
1529: x_approver_email_address => x_approver_email_address,
1839: end if;
1840:
1841: END is_pend_account_error;
1842:
1843: END UMX_REG_REQUESTS_PVT;