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 539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then

535: uid fnd_user.user_id%type;
536:
537: begin
538:
539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
541: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin',
542: 'regRequestId: ' || p_reg_request_id ||
543: ' | username: ' || p_username ||

Line 540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

536:
537: begin
538:
539: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
540: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
541: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin',
542: 'regRequestId: ' || p_reg_request_id ||
543: ' | username: ' || p_username ||
544: ' | personPartyId: ' || p_person_party_id ||

Line 696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN

692:
693: END IF;
694: EXCEPTION
695: WHEN OTHERS THEN
696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
697: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin', 'When inserting security attributes');
698: END IF;
699: END;
700: END IF;

Line 697: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin', 'When inserting security attributes');

693: END IF;
694: EXCEPTION
695: WHEN OTHERS THEN
696: IF (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) THEN
697: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVRRSB.approve_username_reg_request.begin', 'When inserting security attributes');
698: END IF;
699: END;
700: END IF;
701: --end changes for hrms and security attributes

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

707: X_REG_REQUEST_ID => p_reg_request_id,
708: X_STATUS_CODE => 'APPROVED',
709: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
710:
711: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
712: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
713: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.end', 'End');
714: end if;
715:

Line 712: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

708: X_STATUS_CODE => 'APPROVED',
709: X_REQUESTED_FOR_PARTY_ID => p_person_party_id);
710:
711: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
712: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
713: 'fnd.plsql.UMXVRRSB.approve_username_reg_request.end', 'End');
714: end if;
715:
716: end approve_username_reg_request;

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

760: where reg_request_id = p_reg_request_id;
761:
762: begin
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.reject_cancel_username_reg_req.begin',
767: 'regRequestId: ' || p_reg_request_id ||
768: ' | username: ' || p_username ||

Line 765: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

761:
762: begin
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.reject_cancel_username_reg_req.begin',
767: 'regRequestId: ' || p_reg_request_id ||
768: ' | username: ' || p_username ||
769: ' | userId: ' || p_user_id ||

Line 771: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

767: 'regRequestId: ' || p_reg_request_id ||
768: ' | username: ' || p_username ||
769: ' | userId: ' || p_user_id ||
770: ' | statusCode: ' || p_status_code);
771: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
772: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
773: 'Before calling fnd_user_pkg.RemovePendingUser');
774: end if;
775:

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

775:
776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);
778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
782: 'After calling fnd_user_pkg.RemovePendingUser');
783: end if;

Line 780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

776: -- Call FND's release_username API to release/delete the username
777: fnd_user_pkg.RemovePendingUser (username => p_username);
778:
779: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
780: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
781: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.begin',
782: 'After calling fnd_user_pkg.RemovePendingUser');
783: end if;
784:

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

804: X_STATUS_CODE => p_status_code,
805: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
806: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
807:
808: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
809: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
810: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.end', 'End');
811: end if;
812:

Line 809: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

805: X_REQUESTED_FOR_USER_ID => fnd_api.g_miss_num,
806: X_REQUESTED_BY_USER_ID => l_requested_by_user_id);
807:
808: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
809: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
810: 'fnd.plsql.UMXVRRSB.reject_cancel_username_reg_req.end', 'End');
811: end if;
812:
813: end reject_cancel_username_reg_req;

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

841: p_username in FND_USER.USER_NAME%TYPE) is
842:
843: begin
844:
845: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
846: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
847: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.begin',
848: 'regRequestId: ' || p_reg_request_id ||
849: ' | userId: ' || p_user_id ||

Line 846: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

842:
843: begin
844:
845: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
846: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
847: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.begin',
848: 'regRequestId: ' || p_reg_request_id ||
849: ' | userId: ' || p_user_id ||
850: ' | username: ' || p_username);

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

856: p_username => p_username,
857: p_user_id => p_user_id,
858: p_status_code => 'REJECTED');
859:
860: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
861: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
862: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.end', 'End');
863: end if;
864:

Line 861: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

857: p_user_id => p_user_id,
858: p_status_code => 'REJECTED');
859:
860: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
861: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
862: 'fnd.plsql.UMXVRRSB.reject_username_reg_request.end', 'End');
863: end if;
864:
865: end reject_username_reg_request;

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

893: p_username in FND_USER.USER_NAME%TYPE) is
894:
895: begin
896:
897: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
898: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
899: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.begin',
900: 'regRequestId: ' || p_reg_request_id ||
901: ' | userId: ' || p_user_id ||

Line 898: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

894:
895: begin
896:
897: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
898: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
899: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.begin',
900: 'regRequestId: ' || p_reg_request_id ||
901: ' | userId: ' || p_user_id ||
902: ' | username: ' || p_username);

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

908: p_username => p_username,
909: p_user_id => p_user_id,
910: p_status_code => 'CANCELLED');
911:
912: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
913: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
914: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.end', 'End');
915: end if;
916:

Line 913: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

909: p_user_id => p_user_id,
910: p_status_code => 'CANCELLED');
911:
912: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
913: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
914: 'fnd.plsql.UMXVRRSB.cancel_username_reg_request.end', 'End');
915: end if;
916:
917: end cancel_username_reg_request;

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

939: p_status_code in UMX_REG_REQUESTS.STATUS_CODE%type) is
940:
941: begin
942:
943: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
944: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
945: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.begin',
946: 'regRequestId: ' || p_reg_request_id ||
947: ' | statusCode: ' || p_status_code);

Line 944: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

940:
941: begin
942:
943: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
944: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
945: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.begin',
946: 'regRequestId: ' || p_reg_request_id ||
947: ' | statusCode: ' || p_status_code);
948: end if;

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

950: -- update the record in the Reg Requests table with status to status_code
951: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
952: X_STATUS_CODE => p_status_code);
953:
954: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
956: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.end', 'End');
957: end if;
958:

Line 955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

951: UMX_REG_REQUESTS_PKG.update_row (X_REG_REQUEST_ID => p_reg_request_id,
952: X_STATUS_CODE => p_status_code);
953:
954: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
955: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
956: 'fnd.plsql.UMXVRRSB.approve_reject_reg_request.end', 'End');
957: end if;
958:
959: end approve_reject_reg_request;

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

976: --
977: Procedure approve_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
978: begin
979:
980: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
981: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
982: 'fnd.plsql.UMXVRRSB.approve_reg_request.begin',
983: 'regRequestId: ' || p_reg_request_id);
984: end if;

Line 981: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

977: Procedure approve_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
978: begin
979:
980: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
981: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
982: 'fnd.plsql.UMXVRRSB.approve_reg_request.begin',
983: 'regRequestId: ' || p_reg_request_id);
984: end if;
985:

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

987: -- UMX_REG_REQUESTS table.
988: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
989: p_status_code => 'APPROVED');
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.approve_reg_request.end', 'End');
994: end if;
995:

Line 992: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

988: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
989: p_status_code => 'APPROVED');
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.approve_reg_request.end', 'End');
994: end if;
995:
996: end approve_reg_request;

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

1013: --
1014: Procedure reject_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
1015: begin
1016:
1017: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1018: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1019: 'fnd.plsql.UMXVRRSB.reject_reg_request.begin',
1020: 'regRequestId: ' || p_reg_request_id);
1021: end if;

Line 1018: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1014: Procedure reject_reg_request (p_reg_request_id in UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE) is
1015: begin
1016:
1017: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1018: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1019: 'fnd.plsql.UMXVRRSB.reject_reg_request.begin',
1020: 'regRequestId: ' || p_reg_request_id);
1021: end if;
1022:

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

1024: -- UMX_REG_REQUESTS table.
1025: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
1026: p_status_code => 'REJECTED');
1027:
1028: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1029: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1030: 'fnd.plsql.UMXVRRSB.reject_reg_request.end', 'End');
1031: end if;
1032:

Line 1029: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1025: approve_reject_reg_request (p_reg_request_id => p_reg_request_id,
1026: p_status_code => 'REJECTED');
1027:
1028: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1029: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1030: 'fnd.plsql.UMXVRRSB.reject_reg_request.end', 'End');
1031: end if;
1032:
1033: end reject_reg_request;

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

1052: i number := 1;
1053:
1054: begin
1055:
1056: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1057: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1058: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.begin',
1059: 'p_ame_application_id=' || p_ame_application_id ||
1060: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||

Line 1057: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1053:
1054: begin
1055:
1056: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1057: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1058: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.begin',
1059: 'p_ame_application_id=' || p_ame_application_id ||
1060: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||
1061: ' | p_reg_request_id=' || p_reg_request_id);

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

1060: ' | p_ame_transaction_type_id=' || p_ame_transaction_type_id ||
1061: ' | p_reg_request_id=' || p_reg_request_id);
1062: end if;
1063:
1064: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1065: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1066: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1067: 'Before calling ame_api2.getNextApprovers4 (' ||
1068: p_ame_application_id || ',' ||

Line 1065: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1061: ' | p_reg_request_id=' || p_reg_request_id);
1062: end if;
1063:
1064: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1065: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1066: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1067: 'Before calling ame_api2.getNextApprovers4 (' ||
1068: p_ame_application_id || ',' ||
1069: p_ame_transaction_type_id || ',' ||

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

1078: flagApproversAsNotifiedIn => ame_util.booleanFalse,
1079: approvalProcessCompleteYNOut => l_approval_complete,
1080: nextApproversOut => l_next_approvers);
1081:
1082: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1083: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1084: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1085: 'After calling ame_api2.getNextApprovers4 (' ||
1086: l_approval_complete || ')');

Line 1083: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1079: approvalProcessCompleteYNOut => l_approval_complete,
1080: nextApproversOut => l_next_approvers);
1081:
1082: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1083: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1084: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1085: 'After calling ame_api2.getNextApprovers4 (' ||
1086: l_approval_complete || ')');
1087: end if;

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

1092: -- We are exiting because our Workflow Process will only support
1093: -- serial approval.
1094: l_next_approver := l_next_approvers(i);
1095:
1096: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1097: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1098: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1099: 'approver username:'|| l_next_approver.name);
1100: end if;

Line 1097: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,

1093: -- serial approval.
1094: l_next_approver := l_next_approvers(i);
1095:
1096: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1097: FND_LOG.STRING (FND_LOG.LEVEL_STATEMENT,
1098: 'fnd.plsql.UMXVRRSB.getNextApproverPvt',
1099: 'approver username:'|| l_next_approver.name);
1100: end if;
1101:

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

1107: end if;
1108: end loop;
1109: end if;
1110:
1111: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1112: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1113: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.End',
1114: 'l_next_approver=' || l_next_approver.name);
1115: end if;

Line 1112: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1108: end loop;
1109: end if;
1110:
1111: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
1112: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1113: 'fnd.plsql.UMXVRRSB.getNextApproverPvt.End',
1114: 'l_next_approver=' || l_next_approver.name);
1115: end if;
1116:

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

1135: l_role_info_tbl wf_directory.wf_local_roles_tbl_type;
1136:
1137: Begin
1138:
1139: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1140: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1141: 'fnd.plsql.UMXVRRSB.get_current_approver_info.begin',
1142: 'regRequestId: ' || p_reg_request_id ||
1143: ' | applicationId: ' || p_application_id ||

Line 1140: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1136:
1137: Begin
1138:
1139: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1140: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1141: 'fnd.plsql.UMXVRRSB.get_current_approver_info.begin',
1142: 'regRequestId: ' || p_reg_request_id ||
1143: ' | applicationId: ' || p_application_id ||
1144: ' | transactionTypeId: ' || p_transaction_type_id);

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

1160: 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.');
1161: end if;
1162: end if;
1163:
1164: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1165: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1166: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1167: 'regRequestId: ' || p_reg_request_id ||
1168: ' | applicationId: ' || l_application_id ||

Line 1165: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1161: end if;
1162: end if;
1163:
1164: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1165: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1166: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1167: 'regRequestId: ' || p_reg_request_id ||
1168: ' | applicationId: ' || l_application_id ||
1169: ' | transactionTypeId: ' || l_transaction_type_id);

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

1181: exception
1182: when others
1183: -- Suppress it for now, we will log the error statement.
1184: then
1185: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1186: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1187: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1188: 'Exception occurs when calling ame_api.getNextApprover.');
1189: end if;

Line 1186: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,

1182: when others
1183: -- Suppress it for now, we will log the error statement.
1184: then
1185: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_EXCEPTION) then
1186: FND_LOG.STRING (FND_LOG.LEVEL_EXCEPTION,
1187: 'fnd.plsql.UMXVRRSB.get_current_approver_info',
1188: 'Exception occurs when calling ame_api.getNextApprover.');
1189: end if;
1190: end;

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

1197: x_approver_email := l_role_info_tbl(1).email_address;
1198:
1199: end if;
1200:
1201: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1202: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1203: 'fnd.plsql.UMXVRRSB.get_current_approver_info.end', 'End');
1204: end if;
1205:

Line 1202: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1198:
1199: end if;
1200:
1201: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1202: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1203: 'fnd.plsql.UMXVRRSB.get_current_approver_info.end', 'End');
1204: end if;
1205:
1206: End get_current_approver_info;

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

1273: where user_id = l_user_id;
1274:
1275: begin
1276:
1277: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1278: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1279: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.begin',
1280: 'requesterUserId: ' || p_requester_user_id ||
1281: ' | regRequestId: ' || x_reg_request_id);

Line 1278: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1274:
1275: begin
1276:
1277: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1278: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1279: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.begin',
1280: 'requesterUserId: ' || p_requester_user_id ||
1281: ' | regRequestId: ' || x_reg_request_id);
1282: end if;

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

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
1336: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1337: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1338: 'statusCode: ' || x_status_code);
1339: end if;

Line 1336: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1332:
1333: end if;
1334:
1335: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1336: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1337: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1338: 'statusCode: ' || x_status_code);
1339: end if;
1340:

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

1353: itemtype => UMX_REGISTRATION_UTIL.G_ITEM_TYPE,
1354: itemkey => x_reg_request_id,
1355: aname => 'REQUESTED_START_DATE');
1356:
1357: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1359: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1360: 'activeFrom: ' || x_active_from);
1361: end if;

Line 1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1354: itemkey => x_reg_request_id,
1355: aname => 'REQUESTED_START_DATE');
1356:
1357: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1358: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1359: 'fnd.plsql.UMXVRRSB.get_pend_acct_info',
1360: 'activeFrom: ' || x_active_from);
1361: end if;
1362:

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

1376: if (x_active_to is not null) then
1377: x_active_to := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_to), calendar_aware => fnd_date.calendar_aware );
1378: end if;
1379:
1380: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1381: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1382: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.end',
1383: 'x_reg_request_id: ' || x_reg_request_id ||
1384: ' | x_requested_for_username: ' || x_requested_for_username ||

Line 1381: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1377: x_active_to := fnd_date.date_to_displaydate ( dateval => fnd_date.canonical_to_date (x_active_to), calendar_aware => fnd_date.calendar_aware );
1378: end if;
1379:
1380: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1381: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1382: 'fnd.plsql.UMXVRRSB.get_pend_acct_info.end',
1383: 'x_reg_request_id: ' || x_reg_request_id ||
1384: ' | x_requested_for_username: ' || x_requested_for_username ||
1385: ' | x_approver_name: ' || x_approver_name ||

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

1439: l_reg_request_id UMX_REG_REQUESTS.REG_REQUEST_ID%TYPE;
1440:
1441: begin
1442:
1443: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1444: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1445: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1446: 'p_requester_user_id: ' || p_requester_user_id);
1447: end if;

Line 1444: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1440:
1441: begin
1442:
1443: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1444: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1445: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.begin',
1446: 'p_requester_user_id: ' || p_requester_user_id);
1447: end if;
1448:

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

1456: x_active_from => x_active_from,
1457: x_active_to => x_active_to,
1458: x_justification => x_justification);
1459:
1460: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1461: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1462: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.end',
1463: 'x_reg_request_id: ' || x_reg_request_id ||
1464: ' | x_requested_for_username: ' || x_requested_for_username ||

Line 1461: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1457: x_active_to => x_active_to,
1458: x_justification => x_justification);
1459:
1460: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1461: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1462: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_userid.end',
1463: 'x_reg_request_id: ' || x_reg_request_id ||
1464: ' | x_requested_for_username: ' || x_requested_for_username ||
1465: ' | x_approver_name: ' || x_approver_name ||

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

1513: l_requested_for_username FND_USER.USER_NAME%TYPE;
1514:
1515: begin
1516:
1517: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1518: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1519: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.begin',
1520: 'p_reg_request_id: ' || p_reg_request_id);
1521: end if;

Line 1518: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1514:
1515: begin
1516:
1517: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1518: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1519: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.begin',
1520: 'p_reg_request_id: ' || p_reg_request_id);
1521: end if;
1522:

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

1531: x_active_from => x_active_from,
1532: x_active_to => x_active_to,
1533: x_justification => x_justification);
1534:
1535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1537: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.end',
1538: 'x_approver_name:' || x_approver_name ||
1539: ' | x_approver_email_address: ' || x_approver_email_address ||

Line 1536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1532: x_active_to => x_active_to,
1533: x_justification => x_justification);
1534:
1535: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1536: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1537: 'fnd.plsql.UMXVRRSB.get_pend_acct_info_with_reqid.end',
1538: 'x_approver_name:' || x_approver_name ||
1539: ' | x_approver_email_address: ' || x_approver_email_address ||
1540: ' | x_status_code: ' || x_status_code ||

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

1583: child get_child_workflow%rowtype;
1584:
1585: BEGIN
1586:
1587: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1588: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1589: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1590: 'p_reg_request_id: ' || p_reg_request_id);
1591: end if;

Line 1588: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1584:
1585: BEGIN
1586:
1587: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1588: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1589: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1590: 'p_reg_request_id: ' || p_reg_request_id);
1591: end if;
1592:

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

1601: errname => x_errname,
1602: errmsg => x_errmsg,
1603: errstack => x_errstack);
1604:
1605: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1606: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1607: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1608: 'x_status: ' || x_status);
1609: end if;

Line 1606: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1602: errmsg => x_errmsg,
1603: errstack => x_errstack);
1604:
1605: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1606: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1607: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1608: 'x_status: ' || x_status);
1609: end if;
1610:

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

1624: exit when x_status = 'ERROR';
1625: end loop;
1626: end if;
1627:
1628: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1629: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1630: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1631: 'x_itemtype: ' || x_itemtype ||
1632: ' | x_itemkey: ' || x_itemkey ||

Line 1629: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1625: end loop;
1626: end if;
1627:
1628: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1629: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1630: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1631: 'x_itemtype: ' || x_itemtype ||
1632: ' | x_itemkey: ' || x_itemkey ||
1633: ' | x_status: ' || x_status ||

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

1678: l_reg_req_id umx_reg_requests.reg_request_id%type;
1679:
1680: BEGIN
1681:
1682: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1684: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1685: 'p_user_id: ' || p_user_id);
1686: end if;

Line 1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1679:
1680: BEGIN
1681:
1682: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1683: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1684: 'fnd.plsql.UMXVRRSB.get_error_wf_info.begin',
1685: 'p_user_id: ' || p_user_id);
1686: end if;
1687:

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

1695: x_status := 'PENDING';
1696: else
1697: close get_reg_req_id_with_user_id;
1698:
1699: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1700: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1701: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1702: 'l_reg_req_id: ' || l_reg_req_id);
1703: end if;

Line 1700: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1696: else
1697: close get_reg_req_id_with_user_id;
1698:
1699: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1700: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1701: 'fnd.plsql.UMXVRRSB.get_error_wf_info',
1702: 'l_reg_req_id: ' || l_reg_req_id);
1703: end if;
1704:

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

1712: x_errmsg => x_errmsg,
1713: x_errstack => x_errstack);
1714: end if;
1715:
1716: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1717: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1718: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1719: 'x_itemtype: ' || x_itemtype ||
1720: ' | x_itemkey: ' || x_itemkey ||

Line 1717: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1713: x_errstack => x_errstack);
1714: end if;
1715:
1716: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1717: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1718: 'fnd.plsql.UMXVRRSB.get_error_wf_info.end',
1719: 'x_itemtype: ' || x_itemtype ||
1720: ' | x_itemkey: ' || x_itemkey ||
1721: ' | x_status: ' || x_status ||

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

1753: l_errstack varchar2(4000);
1754:
1755: BEGIN
1756:
1757: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1758: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1759: 'fnd.plsql.UMXVRRSB.is_pend_request_error.begin',
1760: 'p_reg_request_id: ' || p_reg_request_id);
1761: end if;

Line 1758: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1754:
1755: BEGIN
1756:
1757: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1758: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1759: 'fnd.plsql.UMXVRRSB.is_pend_request_error.begin',
1760: 'p_reg_request_id: ' || p_reg_request_id);
1761: end if;
1762:

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

1769: x_errname => l_errname,
1770: x_errmsg => l_errmsg,
1771: x_errstack => l_errstack);
1772:
1773: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1774: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1775: 'fnd.plsql.UMXVRRSB.is_pend_request_error.end',
1776: 'l_status: ' || l_status);
1777: end if;

Line 1774: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1770: x_errmsg => l_errmsg,
1771: x_errstack => l_errstack);
1772:
1773: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1774: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1775: 'fnd.plsql.UMXVRRSB.is_pend_request_error.end',
1776: 'l_status: ' || l_status);
1777: end if;
1778:

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

1809: l_errstack varchar2(4000);
1810:
1811: BEGIN
1812:
1813: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1814: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1815: 'fnd.plsql.UMXVRRSB.is_pend_account_error.begin',
1816: 'p_user_id: ' || p_user_id);
1817: end if;

Line 1814: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1810:
1811: BEGIN
1812:
1813: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1814: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1815: 'fnd.plsql.UMXVRRSB.is_pend_account_error.begin',
1816: 'p_user_id: ' || p_user_id);
1817: end if;
1818:

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

1825: x_errname => l_errname,
1826: x_errmsg => l_errmsg,
1827: x_errstack => l_errstack);
1828:
1829: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1830: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1831: 'fnd.plsql.UMXVRRSB.is_pend_account_error.end',
1832: 'l_status: ' || l_status);
1833: end if;

Line 1830: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1826: x_errmsg => l_errmsg,
1827: x_errstack => l_errstack);
1828:
1829: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1830: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1831: 'fnd.plsql.UMXVRRSB.is_pend_account_error.end',
1832: 'l_status: ' || l_status);
1833: end if;
1834: