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

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

Line 101: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

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

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

148:
149: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
150: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
151: if WF_ITEM.ITEM_EXIST('UMXREGWF', L_ITEM_KEY) then
152: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');
154: end if;
155: else
156: WF_EVENT.RAISE(L_EVENT_NAME,L_ITEM_KEY,null,L_PARAMETER_LIST,sysdate);

Line 153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');

149: wf_event.addParametertoList('UMX_PARENT_ITEM_TYPE', UMX_REGISTRATION_UTIL.G_ITEM_TYPE, l_parameter_list);
150: wf_event.addParametertoList('UMX_PARENT_ITEM_KEY', l_item_key, l_parameter_list);
151: if WF_ITEM.ITEM_EXIST('UMXREGWF', L_ITEM_KEY) then
152: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
153: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,'fnd.plsql.UMXVREGB.doProcessRequest', 'Error: UMXREGWF with the Item Key -' ||L_ITEM_KEY ||' already exists');
154: end if;
155: else
156: WF_EVENT.RAISE(L_EVENT_NAME,L_ITEM_KEY,null,L_PARAMETER_LIST,sysdate);
157: end if;

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

172: x_return_status := 'S';
173: populateRegData(p_registration_data, l_item_key);
174: end if;
175:
176: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
178: 'fnd.plsql.UMXVREGB.doProcessRequest.end', 'end UMXREGWF');
179: end if;
180:

Line 177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

173: populateRegData(p_registration_data, l_item_key);
174: end if;
175:
176: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
177: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
178: 'fnd.plsql.UMXVREGB.doProcessRequest.end', 'end UMXREGWF');
179: end if;
180:
181: END do_process_request;

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

198: x_message_data out NOCOPY varchar2) IS
199:
200: BEGIN
201:
202: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
203: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.begin', '');
204: end if;
205:
206: DO_PROCESS_REQUEST(p_registration_data, x_return_status, x_message_data);

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

199:
200: BEGIN
201:
202: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
203: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.begin', '');
204: end if;
205:
206: DO_PROCESS_REQUEST(p_registration_data, x_return_status, x_message_data);
207:

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

205:
206: DO_PROCESS_REQUEST(p_registration_data, x_return_status, x_message_data);
207:
208:
209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
210: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.end', '');
211: end if;
212:
213: END UMX_PROCESS_REG_REQUEST;

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

206: DO_PROCESS_REQUEST(p_registration_data, x_return_status, x_message_data);
207:
208:
209: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
210: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE, 'fnd.plsql.UMXVREGB.umxProcessRegRequest.end', '');
211: end if;
212:
213: END UMX_PROCESS_REG_REQUEST;
214:

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

240: l_tbl hz_format_pub.string_tbl_type;
241:
242: begin
243:
244: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
245: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
246: 'fnd.plsql.UMXVREGB.formatAddressLov.begin',
247: 'partyId: ' || p_party_id);
248: end if;

Line 245: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

241:
242: begin
243:
244: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
245: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
246: 'fnd.plsql.UMXVREGB.formatAddressLov.begin',
247: 'partyId: ' || p_party_id);
248: end if;
249:

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

279: x_formatted_address => l_formatted_address,
280: x_formatted_lines_cnt => l_tbl_cnt,
281: x_formatted_address_tbl => l_tbl);
282:
283: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
284: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
285: 'fnd.plsql.UMXVREGB.formatAddressLov.end',
286: 'formattedAddress: ' || l_formatted_address);
287: end if;

Line 284: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

280: x_formatted_lines_cnt => l_tbl_cnt,
281: x_formatted_address_tbl => l_tbl);
282:
283: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
284: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
285: 'fnd.plsql.UMXVREGB.formatAddressLov.end',
286: 'formattedAddress: ' || l_formatted_address);
287: end if;
288:

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

351: l_wf_bus_logic_event_guid wf_events.guid%type;
352:
353: begin
354:
355: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
356: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
357: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.begin',
358: 'regRequestId: ' || p_reg_request_id ||
359: ' | regServiceCode: ' || p_reg_service_code);

Line 356: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

352:
353: begin
354:
355: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
356: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
357: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.begin',
358: 'regRequestId: ' || p_reg_request_id ||
359: ' | regServiceCode: ' || p_reg_service_code);
360: end if;

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

371:
372: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
373: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
374:
375: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
376: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
377: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.end',
378: 'regServiceType: ' || x_reg_service_type ||
379: ' | requestedByUserId: ' || x_requested_by_user_id ||

Line 376: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

372: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
373: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
374:
375: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
376: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
377: 'fnd.plsql.UMXVREGB.getReqDataFromReqId.end',
378: 'regServiceType: ' || x_reg_service_type ||
379: ' | requestedByUserId: ' || x_requested_by_user_id ||
380: ' | requestedForUserId: ' || x_requested_for_user_id ||

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

424: l_wf_bus_logic_event_guid wf_events.guid%type;
425:
426: begin
427:
428: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
429: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
430: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.begin',
431: 'regServiceCode: ' || p_reg_service_code);
432: end if;

Line 429: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

425:
426: begin
427:
428: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
429: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
430: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.begin',
431: 'regServiceCode: ' || p_reg_service_code);
432: end if;
433:

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

441:
442: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
443: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
444:
445: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
446: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
447: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.end',
448: 'regServiceType: ' || x_reg_service_type ||
449: ' | wfRoleName: ' || x_wf_role_name ||

Line 446: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

442: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
443: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
444:
445: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
446: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
447: 'fnd.plsql.UMXVREGB.getReqDataFromReqSvCode.end',
448: 'regServiceType: ' || x_reg_service_type ||
449: ' | wfRoleName: ' || x_wf_role_name ||
450: ' | ameApplicationId: ' || x_ame_application_id ||

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

483: l_wf_bus_logic_event_guid wf_events.guid%type;
484:
485: begin
486:
487: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
488: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
489: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.begin',
490: 'wfRoleName: ' || p_wf_role_name);
491: end if;

Line 488: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

484:
485: begin
486:
487: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
488: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
489: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.begin',
490: 'wfRoleName: ' || p_wf_role_name);
491: end if;
492:

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

507:
508: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
509: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
510:
511: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
513: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.end',
514: 'regServiceCode: ' || x_reg_service_code ||
515: ' | regServiceType: ' || x_reg_service_type ||

Line 512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

508: x_wf_notification_event_name := get_event_name (l_wf_notification_event_guid);
509: x_wf_bus_logic_event_name := get_event_name (l_wf_bus_logic_event_guid);
510:
511: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
512: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
513: 'fnd.plsql.UMXVREGB.getReqDataFromRoleName.end',
514: 'regServiceCode: ' || x_reg_service_code ||
515: ' | regServiceType: ' || x_reg_service_type ||
516: ' | ameApplicationId: ' || x_ame_application_id ||

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

548: l_count number := 0;
549:
550: BEGIN
551:
552: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
553: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
554: 'fnd.plsql.UMXVREGB.populateRegData.begin', '');
555: end if;
556:

Line 553: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

549:
550: BEGIN
551:
552: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
553: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
554: 'fnd.plsql.UMXVREGB.populateRegData.begin', '');
555: end if;
556:
557: j := p_registration_data.FIRST;

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

804: p_registration_data(l_index_to_add).ATTR_VALUE := l_requested_username;
805: l_index_to_add := l_index_to_add + 1;
806: end if;
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.UMXVREGB.populateRegData.end', '');
811: end if;
812:

Line 809: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

805: l_index_to_add := l_index_to_add + 1;
806: end if;
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.UMXVREGB.populateRegData.end', '');
811: end if;
812:
813: END POPULATE_REG_DATA;

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

880: where user_id = l_userid;
881:
882: BEGIN
883:
884: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
885: -- Print all the name and value in p_registration_data.
886: i := p_registration_data.first;
887: while (i <= p_registration_data.last) loop
888: if (p_registration_data(i).attr_name is not null) then

Line 889: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

885: -- Print all the name and value in p_registration_data.
886: i := p_registration_data.first;
887: while (i <= p_registration_data.last) loop
888: if (p_registration_data(i).attr_name is not null) then
889: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
890: 'fnd.plsql.UMXVREGB.assignRole.begin',
891: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
892: ' | attr_value = ' || p_registration_data(i).attr_value);
893: else

Line 894: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

890: 'fnd.plsql.UMXVREGB.assignRole.begin',
891: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
892: ' | attr_value = ' || p_registration_data(i).attr_value);
893: else
894: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
895: 'fnd.plsql.UMXVREGB.assignRole.begin', 'p_registration_data(' || i || ').attr_name is null');
896: end if;
897: i := i + 1;
898: end loop;

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

984: l_reg_service_code_i := p_registration_data.last + 1;
985: p_registration_data(l_reg_service_code_i).attr_name := G_REG_SERVICE_CODE;
986: end if;
987:
988: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
989: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
990: 'fnd.plsql.UMXVREGB.assignRole',
991: 'regServiceCode:' || p_registration_data(l_reg_service_code_i).attr_value);
992: end if;

Line 989: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

985: p_registration_data(l_reg_service_code_i).attr_name := G_REG_SERVICE_CODE;
986: end if;
987:
988: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
989: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
990: 'fnd.plsql.UMXVREGB.assignRole',
991: 'regServiceCode:' || p_registration_data(l_reg_service_code_i).attr_value);
992: end if;
993:

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

1145: open get_username_from_userid (l_requested_for_user_id);
1146: fetch get_username_from_userid into l_requested_for_user_name;
1147: close get_username_from_userid;
1148:
1149: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1150: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1151: 'fnd.plsql.UMXVREGB.assignRole',
1152: 'regServiceType: ' || l_reg_service_type ||
1153: ' | wfRoleName: ' || l_wf_role_name);

Line 1150: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1146: fetch get_username_from_userid into l_requested_for_user_name;
1147: close get_username_from_userid;
1148:
1149: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1150: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1151: 'fnd.plsql.UMXVREGB.assignRole',
1152: 'regServiceType: ' || l_reg_service_type ||
1153: ' | wfRoleName: ' || l_wf_role_name);
1154: end if;

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

1174: end loop;
1175:
1176: -- Raise WF Event
1177: select umx_events_s.nextval into l_event_key from dual;
1178: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1179: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1180: 'fnd.plsql.UMXVREGB.assignRole',
1181: 'Raising oracle.apps.fnd.umx.rolerequested event with l_event_key=' || l_event_key);
1182: end if;

Line 1179: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1175:
1176: -- Raise WF Event
1177: select umx_events_s.nextval into l_event_key from dual;
1178: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1179: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1180: 'fnd.plsql.UMXVREGB.assignRole',
1181: 'Raising oracle.apps.fnd.umx.rolerequested event with l_event_key=' || l_event_key);
1182: end if;
1183: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.rolerequested',

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

1190: if (l_wf_bus_logic_event_name is not null) then
1191: -- Set the custom event context
1192: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1193: -- Finally, raise the custom event.
1194: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1195: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1196: 'fnd.plsql.UMXVREGB.assignRole',
1197: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1198: end if;

Line 1195: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1191: -- Set the custom event context
1192: wf_event.addParametertoList ('UMX_CUSTOM_EVENT_CONTEXT', 'ROLE APPROVED', l_parameter_list);
1193: -- Finally, raise the custom event.
1194: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1195: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1196: 'fnd.plsql.UMXVREGB.assignRole',
1197: 'Raising ' || l_wf_bus_logic_event_name || ' event with l_event_key=' || l_event_key);
1198: end if;
1199: wf_event.raise (p_event_name => l_wf_bus_logic_event_name,

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

1204: end if;
1205:
1206: -- populate the wf_local_user_roles table and update the reg table
1207: -- with status approved
1208: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1209: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1210: 'fnd.plsql.UMXVREGB.assignRole',
1211: 'Calling wf_local_synch.propagateUserRole (p_user_name => ' || l_requested_for_user_name ||
1212: ', p_role_name => ' || l_wf_role_name ||

Line 1209: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1205:
1206: -- populate the wf_local_user_roles table and update the reg table
1207: -- with status approved
1208: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1209: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1210: 'fnd.plsql.UMXVREGB.assignRole',
1211: 'Calling wf_local_synch.propagateUserRole (p_user_name => ' || l_requested_for_user_name ||
1212: ', p_role_name => ' || l_wf_role_name ||
1213: ', p_start_date => ' || l_requested_start_date ||

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

1224: p_assignmentReason => l_justification);
1225:
1226: l_status_code := 'APPROVED';
1227:
1228: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1229: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1230: 'fnd.plsql.UMXVREGB.assignRole',
1231: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1232: end if;

Line 1229: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1225:
1226: l_status_code := 'APPROVED';
1227:
1228: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1229: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1230: 'fnd.plsql.UMXVREGB.assignRole',
1231: 'Raising oracle.apps.fnd.umx.requestapproved event with l_event_key=' || l_event_key);
1232: end if;
1233: wf_event.raise (p_event_name => 'oracle.apps.fnd.umx.requestapproved',

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

1246: l_status_code := 'PENDING';
1247: end if;
1248: end if;
1249:
1250: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1251: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1252: 'fnd.plsql.UMXVREGB.assignRole',
1253: 'statusCode: ' || l_status_code);
1254: end if;

Line 1251: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1247: end if;
1248: end if;
1249:
1250: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1251: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1252: 'fnd.plsql.UMXVREGB.assignRole',
1253: 'statusCode: ' || l_status_code);
1254: end if;
1255:

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

1293: l_status_code <> 'APPROVED') then
1294: DO_PROCESS_REQUEST (p_registration_data, x_return_status, x_message_data);
1295: end if;
1296:
1297: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1298: -- Print all the name and value in p_registration_data.
1299: i := p_registration_data.first;
1300: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1301: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);

Line 1300: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1296:
1297: if (FND_LOG.G_CURRENT_RUNTIME_LEVEL <= FND_LOG.LEVEL_PROCEDURE) then
1298: -- Print all the name and value in p_registration_data.
1299: i := p_registration_data.first;
1300: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1301: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);
1302: while (i <= p_registration_data.last) loop
1303: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1304: 'fnd.plsql.UMXVREGB.assignRole.end',

Line 1303: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,

1299: i := p_registration_data.first;
1300: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1301: 'fnd.plsql.UMXVREGB.assignRole.end', 'p_registration_data.last=' || p_registration_data.last);
1302: while (i <= p_registration_data.last) loop
1303: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
1304: 'fnd.plsql.UMXVREGB.assignRole.end',
1305: 'p_registration_data(' || i || ').attr_name = ' || p_registration_data(i).attr_name ||
1306: ' | attr_value = ' || p_registration_data(i).attr_value);
1307: i := i + 1;