eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.UMX_REG_REQUESTS_PVT dependencies on FND_LOG

Line 40: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

36: and URS.WF_NOTIFICATION_EVENT_GUID = WE.GUID;
37:
38: BEGIN
39:
40: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
41: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
42: 'fnd.plsql.UMXVRRSB.populateRegRecord.begin',
43: 'regServiceCode: ' || p_reg_request.reg_service_code ||
44: ' | requestedForUserId: ' || p_reg_request.requested_for_user_id);

Line 41: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

37:
38: BEGIN
39:
40: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
41: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
42: 'fnd.plsql.UMXVRRSB.populateRegRecord.begin',
43: 'regServiceCode: ' || p_reg_request.reg_service_code ||
44: ' | requestedForUserId: ' || p_reg_request.requested_for_user_id);
45: end if;

Line 102: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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
103: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
104: 'fnd.plsql.UMXVRRSB.populateRegRecord',
105: 'regServiceCode: ' || p_reg_request.reg_service_code ||
106: ' | requestedForUserId: ' || p_reg_request.requested_for_user_id);

Line 103: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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
103: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
104: 'fnd.plsql.UMXVRRSB.populateRegRecord',
105: 'regServiceCode: ' || p_reg_request.reg_service_code ||
106: ' | requestedForUserId: ' || p_reg_request.requested_for_user_id);
107: end if;

Line 131: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

127:
128: close getRegSvcFromRoleName;
129: end if;
130:
131: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
132: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
133: 'fnd.plsql.UMXVRRSB.populateRegRecord.end',
134: 'regFunctionId:' || x_reg_function_id);
135: end if;

Line 132: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

128: close getRegSvcFromRoleName;
129: end if;
130:
131: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
132: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
133: 'fnd.plsql.UMXVRRSB.populateRegRecord.end',
134: 'regFunctionId:' || x_reg_function_id);
135: end if;
136:

Line 157: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

153: l_exist VARCHAR2(1);
154:
155: BEGIN
156:
157: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
159: 'fnd.plsql.UMXVRRSB.validate_fnd_lookup.begin',
160: 'lookupType: ' || p_lookup_type ||
161: ' | column: ' || p_column ||

Line 158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

154:
155: BEGIN
156:
157: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
158: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
159: 'fnd.plsql.UMXVRRSB.validate_fnd_lookup.begin',
160: 'lookupType: ' || p_lookup_type ||
161: ' | column: ' || p_column ||
162: ' | columnValue: ' || p_column_value);

Line 179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

175: END IF;
176: CLOSE c1;
177: END IF;
178:
179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXVRRSB.validate_fnd_lookup.end',
182: 'returnStatus: ' || x_return_status);
183: end if;

Line 180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

176: CLOSE c1;
177: END IF;
178:
179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
181: 'fnd.plsql.UMXVRRSB.validate_fnd_lookup.end',
182: 'returnStatus: ' || x_return_status);
183: end if;
184:

Line 215: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

211: -- x_reg_request_id: Registration Request ID
212: --
213: procedure update_reg_request (p_reg_request in out NOCOPY REG_REQUEST_TYPE) IS
214: BEGIN
215: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
216: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
217: 'fnd.plsql.UMXVRRSB.update_reg_request.begin', 'Begin');
218: end if;
219:

Line 216: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

212: --
213: procedure update_reg_request (p_reg_request in out NOCOPY REG_REQUEST_TYPE) IS
214: BEGIN
215: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
216: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
217: 'fnd.plsql.UMXVRRSB.update_reg_request.begin', 'Begin');
218: end if;
219:
220: UMX_REG_REQUESTS_PKG.update_row (

Line 235: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

231: X_AME_APPLICATION_ID => p_reg_request.ame_application_id,
232: X_AME_TRANSACTION_TYPE_ID => p_reg_request.ame_transaction_type_id,
233: X_JUSTIFICATION => p_reg_request.justification
234: );
235: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
237: 'fnd.plsql.UMXVRRSB.update_reg_request.end', 'End');
238: end if;
239:

Line 236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

232: X_AME_TRANSACTION_TYPE_ID => p_reg_request.ame_transaction_type_id,
233: X_JUSTIFICATION => p_reg_request.justification
234: );
235: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
237: 'fnd.plsql.UMXVRRSB.update_reg_request.end', 'End');
238: end if;
239:
240: END update_reg_request;

Line 272: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

268: procedure delete_reg_request (
269: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
270: ) is
271: BEGIN
272: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
273: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
274: 'fnd.plsql.UMXVRRSB.delete_reg_request.begin',
275: 'regRequestId: ' || p_reg_request_id);
276: end if;

Line 273: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

269: p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE
270: ) is
271: BEGIN
272: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
273: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
274: 'fnd.plsql.UMXVRRSB.delete_reg_request.begin',
275: 'regRequestId: ' || p_reg_request_id);
276: end if;
277:

Line 280: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

276: end if;
277:
278: UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_id);
279:
280: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
281: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
282: 'fnd.plsql.UMXVRRSB.delete_reg_request.end', 'End');
283: end if;
284:

Line 281: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

277:
278: UMX_REG_REQUESTS_PKG.DELETE_ROW (X_REG_REQUEST_ID => p_reg_request_id);
279:
280: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
281: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
282: 'fnd.plsql.UMXVRRSB.delete_reg_request.end', 'End');
283: end if;
284:
285: END delete_reg_request;

Line 314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

310: l_username fnd_user.user_name%type;
311:
312: begin
313:
314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
315: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
316: 'fnd.plsql.UMXVRRSB.is_username_available.begin',
317: 'username: ' || p_username);
318: end if;

Line 315: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

311:
312: begin
313:
314: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
315: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
316: 'fnd.plsql.UMXVRRSB.is_username_available.begin',
317: 'username: ' || p_username);
318: end if;
319:

Line 337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

333: -- Query didn't find out username in FND_USER table,
334: -- username is available
335: l_username_available := true;
336:
337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
339: 'fnd.plsql.UMXVRRSB.is_username_available.end',
340: 'usernameAvailable: true');
341: end if;

Line 338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

334: -- username is available
335: l_username_available := true;
336:
337: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
338: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
339: 'fnd.plsql.UMXVRRSB.is_username_available.end',
340: 'usernameAvailable: true');
341: end if;
342:

Line 348: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

344: -- Query returns something.
345: -- username is not available
346: l_username_available := false;
347:
348: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
349: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
350: 'fnd.plsql.UMXVRRSB.is_username_available.end',
351: 'usernameAvailable: false');
352: end if;

Line 349: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

345: -- username is not available
346: l_username_available := false;
347:
348: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
349: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
350: 'fnd.plsql.UMXVRRSB.is_username_available.end',
351: 'usernameAvailable: false');
352: end if;
353:

Line 412: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

408: where reg_request_id = p_reg_request_id;
409:
410: begin
411:
412: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
413: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
414: 'fnd.plsql.UMXVRRSB.reserve_username.begin',
415: 'regRequestId: ' || p_reg_request_id ||
416: ' | username: ' || p_username ||

Line 413: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

409:
410: begin
411:
412: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
413: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
414: 'fnd.plsql.UMXVRRSB.reserve_username.begin',
415: 'regRequestId: ' || p_reg_request_id ||
416: ' | username: ' || p_username ||
417: ' | owner: ' || p_owner ||

Line 432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

428: end if;
429:
430: -- First call fnd's resrve_username to reserve a username in FND user table.
431: -- Still waiting for their true implementation from the proposal
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;

Line 433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

429:
430: -- First call fnd's resrve_username to reserve a username in FND user table.
431: -- Still waiting for their true implementation from the proposal
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVRRSB.reserve_username',
435: 'Before calling fnd_user_pkg.CreatePendingUser');
436: end if;
437:

Line 452: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

448: x_email_address => p_email_address,
449: x_fax => p_fax,
450: x_person_party_id => p_person_party_id);
451:
452: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
453: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
454: 'fnd.plsql.UMXVRRSB.reserve_username',
455: 'After calling fnd_user_pkg.CreatePendingUser');
456: end if;

Line 453: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

449: x_fax => p_fax,
450: x_person_party_id => p_person_party_id);
451:
452: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
453: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
454: 'fnd.plsql.UMXVRRSB.reserve_username',
455: 'After calling fnd_user_pkg.CreatePendingUser');
456: end if;
457:

Line 481: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

477: X_REQUESTED_FOR_USER_ID => l_USER_ID,
478: X_REQUESTED_USERNAME => p_username,
479: X_STATUS_CODE => 'PENDING');
480:
481: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
483: 'fnd.plsql.UMXVRRSB.reserve_username.end',
484: 'userId: ' || l_user_id);
485: end if;

Line 482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

478: X_REQUESTED_USERNAME => p_username,
479: X_STATUS_CODE => 'PENDING');
480:
481: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
482: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
483: 'fnd.plsql.UMXVRRSB.reserve_username.end',
484: 'userId: ' || l_user_id);
485: end if;
486:

Line 535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

531: l_start_date fnd_user.start_date%type;
532:
533: begin
534:
535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
537: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin',
538: 'regRequestId: ' || p_reg_request_id ||
539: ' | username: ' || p_username ||

Line 536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

532:
533: begin
534:
535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
537: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin',
538: 'regRequestId: ' || p_reg_request_id ||
539: ' | username: ' || p_username ||
540: ' | personPartyId: ' || p_person_party_id ||

Line 563: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

559: X_REG_REQUEST_ID => p_reg_request_id,
560: X_STATUS_CODE => 'APPROVED',
561: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
562:
563: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
564: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
565: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.end', 'End');
566: end if;
567:

Line 564: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

560: X_STATUS_CODE => 'APPROVED',
561: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
562:
563: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
564: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
565: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.end', 'End');
566: end if;
567:
568: end approve_username_reg_request;

Line 616: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

612: where reg_request_id = p_reg_request_id;
613:
614: begin
615:
616: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
617: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
618: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
619: 'regRequestId: ' || p_reg_request_id ||
620: ' | username: ' || p_username ||

Line 617: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

613:
614: begin
615:
616: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
617: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
618: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
619: 'regRequestId: ' || p_reg_request_id ||
620: ' | username: ' || p_username ||
621: ' | userId: ' || p_user_id ||

Line 623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

619: 'regRequestId: ' || p_reg_request_id ||
620: ' | username: ' || p_username ||
621: ' | userId: ' || p_user_id ||
622: ' | statusCode: ' || p_status_code);
623: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
624: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
625: 'Before calling fnd_user_pkg.RemovePendingUser');
626: end if;
627:

Line 631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

627:
628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);
630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
634: 'After calling fnd_user_pkg.RemovePendingUser');
635: end if;

Line 632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

628: -- Call FND's release_username API to release/delete the username
629: fnd_user_pkg.RemovePendingUser (username => p_username);
630:
631: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
632: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
633: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
634: 'After calling fnd_user_pkg.RemovePendingUser');
635: end if;
636:

Line 660: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

656: X_STATUS_CODE => p_status_code,
657: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
658: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
659:
660: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
661: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
662: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.end', 'End');
663: end if;
664:

Line 661: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

657: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
658: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
659:
660: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
661: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
662: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.end', 'End');
663: end if;
664:
665: end reject_cancel_username_reg_req;

Line 697: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

693: p_username in FND_USER.USER_NAME%TYPE) is
694:
695: begin
696:
697: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
698: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
699: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.begin',
700: 'regRequestId: ' || p_reg_request_id ||
701: ' | userId: ' || p_user_id ||

Line 698: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

694:
695: begin
696:
697: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
698: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
699: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.begin',
700: 'regRequestId: ' || p_reg_request_id ||
701: ' | userId: ' || p_user_id ||
702: ' | username: ' || p_username);

Line 712: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

708: p_username => p_username,
709: p_user_id => p_user_id,
710: p_status_code => 'REJECTED');
711:
712: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
713: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
714: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.end', 'End');
715: end if;
716:

Line 713: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

709: p_user_id => p_user_id,
710: p_status_code => 'REJECTED');
711:
712: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
713: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
714: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.end', 'End');
715: end if;
716:
717: end reject_username_reg_request;

Line 749: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

745: p_username in FND_USER.USER_NAME%TYPE) is
746:
747: begin
748:
749: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
751: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.begin',
752: 'regRequestId: ' || p_reg_request_id ||
753: ' | userId: ' || p_user_id ||

Line 750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

746:
747: begin
748:
749: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
750: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
751: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.begin',
752: 'regRequestId: ' || p_reg_request_id ||
753: ' | userId: ' || p_user_id ||
754: ' | username: ' || p_username);

Line 764: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

760: p_username => p_username,
761: p_user_id => p_user_id,
762: p_status_code => 'CANCELLED');
763:
764: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
765: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
766: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.end', 'End');
767: end if;
768:

Line 765: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

761: p_user_id => p_user_id,
762: p_status_code => 'CANCELLED');
763:
764: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
765: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
766: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.end', 'End');
767: end if;
768:
769: end cancel_username_reg_request;

Line 795: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

791: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%type) is
792:
793: begin
794:
795: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
796: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
797: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.begin',
798: 'regRequestId: ' || p_reg_request_id ||
799: ' | statusCode: ' || p_status_code);

Line 796: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

792:
793: begin
794:
795: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
796: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
797: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.begin',
798: 'regRequestId: ' || p_reg_request_id ||
799: ' | statusCode: ' || p_status_code);
800: end if;

Line 806: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

802: -- update the record in the Reg Requests table with status to status_code
803: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
804: X_STATUS_CODE => p_status_code);
805:
806: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
807: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
808: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.end', 'End');
809: end if;
810:

Line 807: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

803: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
804: X_STATUS_CODE => p_status_code);
805:
806: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
807: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
808: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.end', 'End');
809: end if;
810:
811: end approve_reject_reg_request;

Line 832: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

828: --
829: Procedure approve_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
830: begin
831:
832: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
833: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
834: 'fnd.plsql.UMXVRRSB.approve_reg_request.begin',
835: 'regRequestId: ' || p_reg_request_id);
836: end if;

Line 833: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

829: Procedure approve_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
830: begin
831:
832: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
833: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
834: 'fnd.plsql.UMXVRRSB.approve_reg_request.begin',
835: 'regRequestId: ' || p_reg_request_id);
836: end if;
837:

Line 843: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

839: -- UMX_REG_REQUESTS table.
840: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
841: p_status_code => 'APPROVED');
842:
843: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
844: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
845: 'fnd.plsql.UMXVRRSB.approve_reg_request.end', 'End');
846: end if;
847:

Line 844: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

840: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
841: p_status_code => 'APPROVED');
842:
843: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
844: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
845: 'fnd.plsql.UMXVRRSB.approve_reg_request.end', 'End');
846: end if;
847:
848: end approve_reg_request;

Line 869: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

865: --
866: Procedure reject_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
867: begin
868:
869: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
870: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
871: 'fnd.plsql.UMXVRRSB.reject_reg_request.begin',
872: 'regRequestId: ' || p_reg_request_id);
873: end if;

Line 870: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

866: Procedure reject_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
867: begin
868:
869: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
870: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
871: 'fnd.plsql.UMXVRRSB.reject_reg_request.begin',
872: 'regRequestId: ' || p_reg_request_id);
873: end if;
874:

Line 880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

876: -- UMX_REG_REQUESTS table.
877: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
878: p_status_code => 'REJECTED');
879:
880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
882: 'fnd.plsql.UMXVRRSB.reject_reg_request.end', 'End');
883: end if;
884:

Line 881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

877: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
878: p_status_code => 'REJECTED');
879:
880: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
881: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
882: 'fnd.plsql.UMXVRRSB.reject_reg_request.end', 'End');
883: end if;
884:
885: end reject_reg_request;

Line 908: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

904: i number := 1;
905:
906: begin
907:
908: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
910: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.begin',
911: 'p_ame_application_id=' || p_ame_application_id ||
912: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||

Line 909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

905:
906: begin
907:
908: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
909: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
910: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.begin',
911: 'p_ame_application_id=' || p_ame_application_id ||
912: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||
913: ' | p_reg_request_id=' || p_reg_request_id);

Line 916: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

912: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||
913: ' | p_reg_request_id=' || p_reg_request_id);
914: end if;
915:
916: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
917: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
918: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
919: 'Before calling ame_api2.getNextApprovers4 (' ||
920: p_ame_application_id || ',' ||

Line 917: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

913: ' | p_reg_request_id=' || p_reg_request_id);
914: end if;
915:
916: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
917: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
918: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
919: 'Before calling ame_api2.getNextApprovers4 (' ||
920: p_ame_application_id || ',' ||
921: p_ame_transaction_type_id || ',' ||

Line 934: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

930: flagApproversAsNotifiedIn => ame_util.booleanFalse,
931: approvalProcessCompleteYNOut => l_approval_complete,
932: nextApproversOut => l_next_approvers);
933:
934: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
935: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
936: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
937: 'After calling ame_api2.getNextApprovers4 (' ||
938: l_approval_complete || ')');

Line 935: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

931: approvalProcessCompleteYNOut => l_approval_complete,
932: nextApproversOut => l_next_approvers);
933:
934: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
935: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
936: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
937: 'After calling ame_api2.getNextApprovers4 (' ||
938: l_approval_complete || ')');
939: end if;

Line 948: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

944: -- We are exiting because our Workflow Process will only support
945: -- serial approval.
946: l_next_approver := l_next_approvers(i);
947:
948: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
949: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
950: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
951: 'approver username:'|| l_next_approver.name);
952: end if;

Line 949: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

945: -- serial approval.
946: l_next_approver := l_next_approvers(i);
947:
948: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
949: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
950: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
951: 'approver username:'|| l_next_approver.name);
952: end if;
953:

Line 963: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then

959: end if;
960: end loop;
961: end if;
962:
963: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
964: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
965: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.End',
966: 'l_next_approver=' || l_next_approver.name);
967: end if;

Line 964: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

960: end loop;
961: end if;
962:
963: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
964: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
965: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.End',
966: 'l_next_approver=' || l_next_approver.name);
967: end if;
968:

Line 991: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

987: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
988:
989: Begin
990:
991: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
992: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
993: 'fnd.plsql.UMXVRRSB.get_current_approver_info.begin',
994: 'regRequestId: ' || p_reg_request_id ||
995: ' | applicationId: ' || p_application_id ||

Line 992: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

988:
989: Begin
990:
991: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
992: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
993: 'fnd.plsql.UMXVRRSB.get_current_approver_info.begin',
994: 'regRequestId: ' || p_reg_request_id ||
995: ' | applicationId: ' || p_application_id ||
996: ' | transactionTypeId: ' || p_transaction_type_id);

Line 1016: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1012: raise_application_error ('-200000', 'Required input parameters are missing. The API get_current_approver_info needs to be called with p_reg_request_id or combination of p_application_id and l_transaction_type_id.');
1013: end if;
1014: end if;
1015:
1016: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1017: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1018: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1019: 'regRequestId: ' || p_reg_request_id ||
1020: ' | applicationId: ' || l_application_id ||

Line 1017: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1013: end if;
1014: end if;
1015:
1016: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1017: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1018: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1019: 'regRequestId: ' || p_reg_request_id ||
1020: ' | applicationId: ' || l_application_id ||
1021: ' | transactionTypeId: ' || l_transaction_type_id);

Line 1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then

1033: exception
1034: when others
1035: -- Suppress it for now, we will log the error statement.
1036: then
1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1038: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1039: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1040: 'Exception occurs when calling ame_api.getNextApprover.');
1041: end if;

Line 1038: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1034: when others
1035: -- Suppress it for now, we will log the error statement.
1036: then
1037: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1038: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1039: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1040: 'Exception occurs when calling ame_api.getNextApprover.');
1041: end if;
1042: end;

Line 1053: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1049: x_approver_email := l_role_info_tbl(1).email_address;
1050:
1051: end if;
1052:
1053: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1054: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1055: 'fnd.plsql.UMXVRRSB.get_current_approver_info.end', 'End');
1056: end if;
1057:

Line 1054: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1050:
1051: end if;
1052:
1053: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1054: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1055: 'fnd.plsql.UMXVRRSB.get_current_approver_info.end', 'End');
1056: end if;
1057:
1058: End get_current_approver_info;

Line 1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1125: where user_id = l_user_id;
1126:
1127: begin
1128:
1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1131: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.begin',
1132: 'requesterUserId: ' || p_requester_user_id ||
1133: ' | regRequestId: ' || x_reg_request_id);

Line 1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1126:
1127: begin
1128:
1129: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1130: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1131: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.begin',
1132: 'requesterUserId: ' || p_requester_user_id ||
1133: ' | regRequestId: ' || x_reg_request_id);
1134: end if;

Line 1187: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

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
1188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1189: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1190: 'statusCode: ' || x_status_code);
1191: end if;

Line 1188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1184:
1185: end if;
1186:
1187: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1188: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1189: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1190: 'statusCode: ' || x_status_code);
1191: end if;
1192:

Line 1209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1205: itemtype => UMX_REGISTRATION_UTIL.G_ITEM_TYPE,
1206: itemkey => x_reg_request_id,
1207: aname => 'REQUESTED_START_DATE');
1208:
1209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1210: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1211: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1212: 'activeFrom: ' || x_active_from);
1213: end if;

Line 1210: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1206: itemkey => x_reg_request_id,
1207: aname => 'REQUESTED_START_DATE');
1208:
1209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1210: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1211: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1212: 'activeFrom: ' || x_active_from);
1213: end if;
1214:

Line 1232: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1228: if (x_active_to is not null) then
1229: x_active_to := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_to));
1230: end if;
1231:
1232: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1233: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1234: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.end',
1235: 'x_reg_request_id: ' || x_reg_request_id ||
1236: ' | x_requested_for_username: ' || x_requested_for_username ||

Line 1233: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1229: x_active_to := fnd_date.date_to_displaydate (fnd_date.canonical_to_date (x_active_to));
1230: end if;
1231:
1232: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1233: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1234: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.end',
1235: 'x_reg_request_id: ' || x_reg_request_id ||
1236: ' | x_requested_for_username: ' || x_requested_for_username ||
1237: ' | x_approver_name: ' || x_approver_name ||

Line 1295: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1291: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1292:
1293: begin
1294:
1295: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1296: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1297: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1298: 'p_requester_user_id: ' || p_requester_user_id);
1299: end if;

Line 1296: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1292:
1293: begin
1294:
1295: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1296: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1297: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1298: 'p_requester_user_id: ' || p_requester_user_id);
1299: end if;
1300:

Line 1312: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1308: x_active_from => x_active_from,
1309: x_active_to => x_active_to,
1310: x_justification => x_justification);
1311:
1312: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1313: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1314: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.end',
1315: 'x_reg_request_id: ' || x_reg_request_id ||
1316: ' | x_requested_for_username: ' || x_requested_for_username ||

Line 1313: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1309: x_active_to => x_active_to,
1310: x_justification => x_justification);
1311:
1312: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1313: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1314: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.end',
1315: 'x_reg_request_id: ' || x_reg_request_id ||
1316: ' | x_requested_for_username: ' || x_requested_for_username ||
1317: ' | x_approver_name: ' || x_approver_name ||

Line 1369: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1365: l_requested_for_username FND_USER.USER_NAME%TYPE;
1366:
1367: begin
1368:
1369: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1370: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1371: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.begin',
1372: 'p_reg_request_id: ' || p_reg_request_id);
1373: end if;

Line 1370: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1366:
1367: begin
1368:
1369: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1370: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1371: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.begin',
1372: 'p_reg_request_id: ' || p_reg_request_id);
1373: end if;
1374:

Line 1387: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1383: x_active_from => x_active_from,
1384: x_active_to => x_active_to,
1385: x_justification => x_justification);
1386:
1387: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1389: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.end',
1390: 'x_approver_name:' || x_approver_name ||
1391: ' | x_approver_email_address: ' || x_approver_email_address ||

Line 1388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1384: x_active_to => x_active_to,
1385: x_justification => x_justification);
1386:
1387: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1388: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1389: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.end',
1390: 'x_approver_name:' || x_approver_name ||
1391: ' | x_approver_email_address: ' || x_approver_email_address ||
1392: ' | x_status_code: ' || x_status_code ||

Line 1439: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1435: child get_child_workflow%rowtype;
1436:
1437: BEGIN
1438:
1439: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1441: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1442: 'p_reg_request_id: ' || p_reg_request_id);
1443: end if;

Line 1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1436:
1437: BEGIN
1438:
1439: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1440: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1441: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1442: 'p_reg_request_id: ' || p_reg_request_id);
1443: end if;
1444:

Line 1457: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1453: errname => x_errname,
1454: errmsg => x_errmsg,
1455: errstack => x_errstack);
1456:
1457: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1458: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1459: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1460: 'x_status: ' || x_status);
1461: end if;

Line 1458: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1454: errmsg => x_errmsg,
1455: errstack => x_errstack);
1456:
1457: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1458: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1459: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1460: 'x_status: ' || x_status);
1461: end if;
1462:

Line 1480: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1476: exit when x_status = 'ERROR';
1477: end loop;
1478: end if;
1479:
1480: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1482: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1483: 'x_itemtype: ' || x_itemtype ||
1484: ' | x_itemkey: ' || x_itemkey ||

Line 1481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1477: end loop;
1478: end if;
1479:
1480: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1481: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1482: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1483: 'x_itemtype: ' || x_itemtype ||
1484: ' | x_itemkey: ' || x_itemkey ||
1485: ' | x_status: ' || x_status ||

Line 1534: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1530: l_reg_req_id umx_reg_requests.reg_request_id%type;
1531:
1532: BEGIN
1533:
1534: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1535: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1536: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1537: 'p_user_id: ' || p_user_id);
1538: end if;

Line 1535: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1531:
1532: BEGIN
1533:
1534: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1535: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1536: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1537: 'p_user_id: ' || p_user_id);
1538: end if;
1539:

Line 1551: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1547: x_status := 'PENDING';
1548: else
1549: close get_reg_req_id_with_user_id;
1550:
1551: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1552: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1553: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1554: 'l_reg_req_id: ' || l_reg_req_id);
1555: end if;

Line 1552: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1548: else
1549: close get_reg_req_id_with_user_id;
1550:
1551: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1552: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1553: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1554: 'l_reg_req_id: ' || l_reg_req_id);
1555: end if;
1556:

Line 1568: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1564: x_errmsg => x_errmsg,
1565: x_errstack => x_errstack);
1566: end if;
1567:
1568: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1569: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1570: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1571: 'x_itemtype: ' || x_itemtype ||
1572: ' | x_itemkey: ' || x_itemkey ||

Line 1569: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1565: x_errstack => x_errstack);
1566: end if;
1567:
1568: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1569: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1570: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1571: 'x_itemtype: ' || x_itemtype ||
1572: ' | x_itemkey: ' || x_itemkey ||
1573: ' | x_status: ' || x_status ||

Line 1609: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1605: l_errstack varchar2(4000);
1606:
1607: BEGIN
1608:
1609: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1610: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1611: 'fnd.plsql.UMXVRRSB.is_pend_request_error.begin',
1612: 'p_reg_request_id: ' || p_reg_request_id);
1613: end if;

Line 1610: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1606:
1607: BEGIN
1608:
1609: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1610: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1611: 'fnd.plsql.UMXVRRSB.is_pend_request_error.begin',
1612: 'p_reg_request_id: ' || p_reg_request_id);
1613: end if;
1614:

Line 1625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1621: x_errname => l_errname,
1622: x_errmsg => l_errmsg,
1623: x_errstack => l_errstack);
1624:
1625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1627: 'fnd.plsql.UMXVRRSB.is_pend_request_error.end',
1628: 'l_status: ' || l_status);
1629: end if;

Line 1626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1622: x_errmsg => l_errmsg,
1623: x_errstack => l_errstack);
1624:
1625: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1626: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1627: 'fnd.plsql.UMXVRRSB.is_pend_request_error.end',
1628: 'l_status: ' || l_status);
1629: end if;
1630:

Line 1665: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1661: l_errstack varchar2(4000);
1662:
1663: BEGIN
1664:
1665: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1666: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1667: 'fnd.plsql.UMXVRRSB.is_pend_account_error.begin',
1668: 'p_user_id: ' || p_user_id);
1669: end if;

Line 1666: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1662:
1663: BEGIN
1664:
1665: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1666: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1667: 'fnd.plsql.UMXVRRSB.is_pend_account_error.begin',
1668: 'p_user_id: ' || p_user_id);
1669: end if;
1670:

Line 1681: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

1677: x_errname => l_errname,
1678: x_errmsg => l_errmsg,
1679: x_errstack => l_errstack);
1680:
1681: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1682: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1683: 'fnd.plsql.UMXVRRSB.is_pend_account_error.end',
1684: 'l_status: ' || l_status);
1685: end if;

Line 1682: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1678: x_errmsg => l_errmsg,
1679: x_errstack => l_errstack);
1680:
1681: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1682: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1683: 'fnd.plsql.UMXVRRSB.is_pend_account_error.end',
1684: 'l_status: ' || l_status);
1685: end if;
1686: