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_REGISTRATION_PVT dependencies on FND_LOG

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

19: l_index_to_add NUMBER;
20:
21: BEGIN
22:
23: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
24: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
25: 'fnd.plsql.UMXVREGB.populateRegData.begin',
26: 'regRequestId: ' || p_reg_request_id);
27: end if;

Line 24: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

20:
21: BEGIN
22:
23: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
24: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
25: 'fnd.plsql.UMXVREGB.populateRegData.begin',
26: 'regRequestId: ' || p_reg_request_id);
27: end if;
28:

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

69: l_index_to_add := l_index_to_add + 1;
70: p_registration_data(l_index_to_add).ATTR_NAME := 'status_code';
71: p_registration_data(l_index_to_add).ATTR_VALUE := l_status_code;
72:
73: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
74: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.populateRegData.end', '');
75: end if;
76:
77: END populateRegData;

Line 74: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.populateRegData.end', '');

70: p_registration_data(l_index_to_add).ATTR_NAME := 'status_code';
71: p_registration_data(l_index_to_add).ATTR_VALUE := l_status_code;
72:
73: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
74: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.populateRegData.end', '');
75: end if;
76:
77: END populateRegData;
78:

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

94: l_actid number;
95:
96: BEGIN
97:
98: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
99: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
100: 'fnd.plsql.UMXVREGB.doProcessRequest.begin', '');
101: end if;
102:

Line 99: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

95:
96: BEGIN
97:
98: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
99: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
100: 'fnd.plsql.UMXVREGB.doProcessRequest.begin', '');
101: end if;
102:
103: POPULATE_REG_DATA (p_registration_data => p_registration_data);

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

162: else
163: populateRegData(p_registration_data, l_item_key);
164: end if;
165:
166: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
167: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
168: 'fnd.plsql.UMXVREGB.doProcessRequest.end', '');
169: end if;
170:

Line 167: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

163: populateRegData(p_registration_data, l_item_key);
164: end if;
165:
166: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
167: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
168: 'fnd.plsql.UMXVREGB.doProcessRequest.end', '');
169: end if;
170:
171: END do_process_request;

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

186: PROCEDURE UMX_PROCESS_REG_REQUEST (p_registration_data IN OUT NOCOPY UMX_REGISTRATION_DATA_TBL) IS
187:
188: BEGIN
189:
190: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.begin', '');
192: end if;
193:
194: DO_PROCESS_REQUEST(p_registration_data);

Line 191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.begin', '');

187:
188: BEGIN
189:
190: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
191: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.begin', '');
192: end if;
193:
194: DO_PROCESS_REQUEST(p_registration_data);
195:

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

192: end if;
193:
194: DO_PROCESS_REQUEST(p_registration_data);
195:
196: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
197: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.end', '');
198: end if;
199:
200: END UMX_PROCESS_REG_REQUEST;

Line 197: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.end', '');

193:
194: DO_PROCESS_REQUEST(p_registration_data);
195:
196: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
197: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.end', '');
198: end if;
199:
200: END UMX_PROCESS_REG_REQUEST;
201:

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

227: l_tbl hz_format_pub.string_tbl_type;
228:
229: begin
230:
231: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
232: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
233: 'fnd.plsql.UMXVREGB.formatAddressLov.begin',
234: 'partyId: ' || p_party_id);
235: end if;

Line 232: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

228:
229: begin
230:
231: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
232: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
233: 'fnd.plsql.UMXVREGB.formatAddressLov.begin',
234: 'partyId: ' || p_party_id);
235: end if;
236:

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

266: x_formatted_address => l_formatted_address,
267: x_formatted_lines_cnt => l_tbl_cnt,
268: x_formatted_address_tbl => l_tbl);
269:
270: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
271: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
272: 'fnd.plsql.UMXVREGB.formatAddressLov.end',
273: 'formattedAddress: ' || l_formatted_address);
274: end if;

Line 271: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

267: x_formatted_lines_cnt => l_tbl_cnt,
268: x_formatted_address_tbl => l_tbl);
269:
270: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
271: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
272: 'fnd.plsql.UMXVREGB.formatAddressLov.end',
273: 'formattedAddress: ' || l_formatted_address);
274: end if;
275:

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

338: l_wf_bus_logic_event_guid wf_events.guid%type;
339:
340: begin
341:
342: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
343: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
344: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.begin',
345: 'regRequestId: ' || p_reg_request_id ||
346: ' | regServiceCode: ' || p_reg_service_code);

Line 343: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

339:
340: begin
341:
342: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
343: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
344: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.begin',
345: 'regRequestId: ' || p_reg_request_id ||
346: ' | regServiceCode: ' || p_reg_service_code);
347: end if;

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

358:
359: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
360: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
361:
362: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
363: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
364: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.end',
365: 'regServiceType: ' || x_reg_service_type ||
366: ' | requestedByUserId: ' || x_requested_by_user_id ||

Line 363: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

359: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
360: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
361:
362: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
363: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
364: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.end',
365: 'regServiceType: ' || x_reg_service_type ||
366: ' | requestedByUserId: ' || x_requested_by_user_id ||
367: ' | requestedForUserId: ' || x_requested_for_user_id ||

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

411: l_wf_bus_logic_event_guid wf_events.guid%type;
412:
413: begin
414:
415: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
416: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
417: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.begin',
418: 'regServiceCode: ' || p_reg_service_code);
419: end if;

Line 416: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

412:
413: begin
414:
415: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
416: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
417: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.begin',
418: 'regServiceCode: ' || p_reg_service_code);
419: end if;
420:

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

428:
429: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
430: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
431:
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.end',
435: 'regServiceType: ' || x_reg_service_type ||
436: ' | wfRoleName: ' || x_wf_role_name ||

Line 433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

429: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
430: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
431:
432: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
433: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
434: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.end',
435: 'regServiceType: ' || x_reg_service_type ||
436: ' | wfRoleName: ' || x_wf_role_name ||
437: ' | ameApplicationId: ' || x_ame_application_id ||

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

470: l_wf_bus_logic_event_guid wf_events.guid%type;
471:
472: begin
473:
474: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
475: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
476: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.begin',
477: 'wfRoleName: ' || p_wf_role_name);
478: end if;

Line 475: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

471:
472: begin
473:
474: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
475: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
476: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.begin',
477: 'wfRoleName: ' || p_wf_role_name);
478: end if;
479:

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

494:
495: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
496: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
497:
498: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
499: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
500: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.end',
501: 'regServiceCode: ' || x_reg_service_code ||
502: ' | regServiceType: ' || x_reg_service_type ||

Line 499: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

495: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
496: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
497:
498: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
499: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
500: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.end',
501: 'regServiceCode: ' || x_reg_service_code ||
502: ' | regServiceType: ' || x_reg_service_type ||
503: ' | ameApplicationId: ' || x_ame_application_id ||

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

535: l_count number := 0;
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.UMXVREGB.populateRegData.begin', '');
542: end if;
543:

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.UMXVREGB.populateRegData.begin', '');
542: end if;
543:
544: j := p_registration_data.FIRST;

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

791: p_registration_data(l_index_to_add).ATTR_VALUE := l_requested_username;
792: l_index_to_add := l_index_to_add + 1;
793: end if;
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.UMXVREGB.populateRegData.end', '');
798: end if;
799:

Line 796: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

792: l_index_to_add := l_index_to_add + 1;
793: end if;
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.UMXVREGB.populateRegData.end', '');
798: end if;
799:
800: END POPULATE_REG_DATA;

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

865: where user_id = l_userid;
866:
867: BEGIN
868:
869: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
870: -- Print all the name and value in p_registration_data.
871: i := p_registration_data.first;
872: while (i <= p_registration_data.last) loop
873: if (p_registration_data(i).attr_name is not null) then

Line 874: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

870: -- Print all the name and value in p_registration_data.
871: i := p_registration_data.first;
872: while (i <= p_registration_data.last) loop
873: if (p_registration_data(i).attr_name is not null) then
874: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
875: 'fnd.plsql.UMXVREGB.assignRole.begin',
876: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
877: ' | attr_value = ' || p_registration_data(i).attr_value);
878: else

Line 879: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

875: 'fnd.plsql.UMXVREGB.assignRole.begin',
876: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
877: ' | attr_value = ' || p_registration_data(i).attr_value);
878: else
879: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
880: 'fnd.plsql.UMXVREGB.assignRole.begin', 'p_registration_data(' || i || ').attr_name is null');
881: end if;
882: i := i + 1;
883: end loop;

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

969: l_reg_service_code_i := p_registration_data.last + 1;
970: p_registration_data(l_reg_service_code_i).attr_name := G_REG_SERVICE_CODE;
971: end if;
972:
973: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
975: 'fnd.plsql.UMXVREGB.assignRole',
976: 'regServiceCode:' || p_registration_data(l_reg_service_code_i).attr_value);
977: end if;

Line 974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

970: p_registration_data(l_reg_service_code_i).attr_name := G_REG_SERVICE_CODE;
971: end if;
972:
973: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
974: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
975: 'fnd.plsql.UMXVREGB.assignRole',
976: 'regServiceCode:' || p_registration_data(l_reg_service_code_i).attr_value);
977: end if;
978:

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

1130: open get_username_from_userid (l_requested_for_user_id);
1131: fetch get_username_from_userid into l_requested_for_user_name;
1132: close get_username_from_userid;
1133:
1134: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1135: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1136: 'fnd.plsql.UMXVREGB.assignRole',
1137: 'regServiceType: ' || l_reg_service_type ||
1138: ' | wfRoleName: ' || l_wf_role_name);

Line 1135: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1131: fetch get_username_from_userid into l_requested_for_user_name;
1132: close get_username_from_userid;
1133:
1134: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1135: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1136: 'fnd.plsql.UMXVREGB.assignRole',
1137: 'regServiceType: ' || l_reg_service_type ||
1138: ' | wfRoleName: ' || l_wf_role_name);
1139: end if;

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

1159: end loop;
1160:
1161: -- Raise WF Event
1162: select umx_events_s.nextval into l_event_key from dual;
1163: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1164: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1165: 'fnd.plsql.UMXVREGB.assignRole',
1166: 'Raising oracle.apps.fnd.umx.rolerequested event with l_event_key=' || l_event_key);
1167: end if;

Line 1164: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1160:
1161: -- Raise WF Event
1162: select umx_events_s.nextval into l_event_key from dual;
1163: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1164: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1165: 'fnd.plsql.UMXVREGB.assignRole',
1166: 'Raising oracle.apps.fnd.umx.rolerequested event with l_event_key=' || l_event_key);
1167: end if;
1168: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.rolerequested',

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

1175: if (l_wf_bus_logic_event_name is not null) then
1176: -- Set the custom event context
1177: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1178: -- Finally, raise the custom event.
1179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1181: 'fnd.plsql.UMXVREGB.assignRole',
1182: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1183: end if;

Line 1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1176: -- Set the custom event context
1177: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1178: -- Finally, raise the custom event.
1179: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1180: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1181: 'fnd.plsql.UMXVREGB.assignRole',
1182: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1183: end if;
1184: wf_event.raise (p_event_name => l_wf_bus_logic_event_name,

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

1189: end if;
1190:
1191: -- populate the wf_local_user_roles table and update the reg table
1192: -- with status approved
1193: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1195: 'fnd.plsql.UMXVREGB.assignRole',
1196: 'Calling wf_local_synch.propagateUserRole (p_user_name => ' || l_requested_for_user_name ||
1197: ', p_role_name => ' || l_wf_role_name ||

Line 1194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1190:
1191: -- populate the wf_local_user_roles table and update the reg table
1192: -- with status approved
1193: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1194: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1195: 'fnd.plsql.UMXVREGB.assignRole',
1196: 'Calling wf_local_synch.propagateUserRole (p_user_name => ' || l_requested_for_user_name ||
1197: ', p_role_name => ' || l_wf_role_name ||
1198: ', p_start_date => ' || l_requested_start_date ||

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

1209: p_assignmentReason => l_justification);
1210:
1211: l_status_code := 'APPROVED';
1212:
1213: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMXVREGB.assignRole',
1216: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1217: end if;

Line 1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1210:
1211: l_status_code := 'APPROVED';
1212:
1213: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1214: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1215: 'fnd.plsql.UMXVREGB.assignRole',
1216: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1217: end if;
1218: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.requestapproved',

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

1231: l_status_code := 'PENDING';
1232: end if;
1233: end if;
1234:
1235: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1237: 'fnd.plsql.UMXVREGB.assignRole',
1238: 'statusCode: ' || l_status_code);
1239: end if;

Line 1236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1232: end if;
1233: end if;
1234:
1235: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1236: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1237: 'fnd.plsql.UMXVREGB.assignRole',
1238: 'statusCode: ' || l_status_code);
1239: end if;
1240:

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

1278: l_status_code <> 'APPROVED') then
1279: DO_PROCESS_REQUEST (p_registration_data);
1280: end if;
1281:
1282: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1283: -- Print all the name and value in p_registration_data.
1284: i := p_registration_data.first;
1285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1286: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);

Line 1285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1281:
1282: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1283: -- Print all the name and value in p_registration_data.
1284: i := p_registration_data.first;
1285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1286: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);
1287: while (i <= p_registration_data.last) loop
1288: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1289: 'fnd.plsql.UMXVREGB.assignRole.end',

Line 1288: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1284: i := p_registration_data.first;
1285: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1286: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);
1287: while (i <= p_registration_data.last) loop
1288: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1289: 'fnd.plsql.UMXVREGB.assignRole.end',
1290: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
1291: ' | attr_value = ' || p_registration_data(i).attr_value);
1292: i := i + 1;