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_NOTIFICATION_UTIL dependencies on WF_ENGINE

Line 50: l_event := wf_engine.getitemattrevent (itemtype => item_type,

46: **/
47:
48: if (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
49:
50: l_event := wf_engine.getitemattrevent (itemtype => item_type,
51: itemkey => item_key,
52: name => 'REGISTRATION_DATA');
53:
54: l_parameter_list := l_event.getparameterlist ();

Line 64: l_context := wf_engine.getitemattrtext (itemtype => item_type,

60: ' value:'||l_parameter_list (i).getValue ());
61: end loop;
62: end if;
63:
64: l_context := wf_engine.getitemattrtext (itemtype => item_type,
65: itemkey => item_key,
66: aname =>'NOTIFICATION_CONTEXT',
67: ignore_notfound => false);
68: if (l_context is not null) then

Line 80: l_requested_username := wf_engine.getitemattrtext (itemtype => item_type,

76: elsif l_context = 'APPROVAL_CONFIRMATION' then
77: -- We have to call the fnd_user_pkg.testusername api to find out
78: -- whether oid is enable. If that is the case, then we have to
79: -- send a differnet notification.
80: l_requested_username := wf_engine.getitemattrtext (itemtype => item_type,
81: itemkey => item_key,
82: aname =>'REQUESTED_USERNAME');
83: l_registration_data :=
84: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');

Line 84: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');

80: l_requested_username := wf_engine.getitemattrtext (itemtype => item_type,
81: itemkey => item_key,
82: aname =>'REQUESTED_USERNAME');
83: l_registration_data :=
84: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');
85:
86: if (l_parameter_list is null) then
87: l_parameter_list := l_registration_data.getParameterList;
88: end if;

Line 152: wf_engine.getitemattrevent (item_type,item_key,'REGISTRATION_DATA');

148: 'fnd.plsql.UMXNTFSB.notificationprocessdone.begin', 'Begin');
149: end if;
150:
151: l_registration_data :=
152: wf_engine.getitemattrevent (item_type,item_key,'REGISTRATION_DATA');
153:
154: l_approval_result :=
155: wf_engine.getItemattrtext (item_type,item_key,'APPROVAL_RESULT',false);
156:

Line 155: wf_engine.getItemattrtext (item_type,item_key,'APPROVAL_RESULT',false);

151: l_registration_data :=
152: wf_engine.getitemattrevent (item_type,item_key,'REGISTRATION_DATA');
153:
154: l_approval_result :=
155: wf_engine.getItemattrtext (item_type,item_key,'APPROVAL_RESULT',false);
156:
157: /*l_parameter_list := l_registration_data.getparameterlist ();*/ --bug# 7110551
158: /*Fix for bug# 7110551
159: Remove the unwanted parameter '#CONTEXT' which contains the value 'UMXREGWF:item_key' (where item_key is the item_key value for UMXREGWF workflow)

Line 162: are being set to same value by the WF engine.

158: /*Fix for bug# 7110551
159: Remove the unwanted parameter '#CONTEXT' which contains the value 'UMXREGWF:item_key' (where item_key is the item_key value for UMXREGWF workflow)
160: from the parameter list being passed to the event.
161: Because of this parameter the parent_item_key and item_key for UMXREGWF workflow
162: are being set to same value by the WF engine.
163: */
164: pList := l_registration_data.getparameterlist ();
165: j := 1;
166: for i in pList.first .. pList.last loop

Line 181: wf_engine.getItemattrtext (item_type,item_key,'UMX_PARENT_ITEM_KEY',false);

177:
178: wf_event.addParametertoList ('APPROVAL_RESULT',l_approval_result,l_parameter_list);
179:
180: l_parent_itemkey :=
181: wf_engine.getItemattrtext (item_type,item_key,'UMX_PARENT_ITEM_KEY',false);
182:
183: wf_event.raise ('oracle.apps.fnd.umx.notificationdone', l_parent_itemkey,
184: null,l_parameter_list,sysdate);
185: resultout := 'COMPLETE';

Line 258: l_ame_application_id := wf_engine.getitemattrtext (

254: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
255: 'fnd.plsql.UMXNTFSB.getnextapprover.begin', 'Begin');
256: end if;
257:
258: l_ame_application_id := wf_engine.getitemattrtext (
259: itemtype => item_type,
260: itemkey => item_key,
261: aname => 'AME_APPLICATION_ID',
262: ignore_notfound => false);

Line 264: l_ame_transaction_type_id := wf_engine.getitemattrtext (

260: itemkey => item_key,
261: aname => 'AME_APPLICATION_ID',
262: ignore_notfound => false);
263:
264: l_ame_transaction_type_id := wf_engine.getitemattrtext (
265: itemtype => item_type,
266: itemkey => item_key,
267: aname => 'AME_TRANSACTION_TYPE_ID',
268: ignore_notfound => false);

Line 270: l_reg_request_id := wf_engine.getitemattrtext (

266: itemkey => item_key,
267: aname => 'AME_TRANSACTION_TYPE_ID',
268: ignore_notfound => false);
269:
270: l_reg_request_id := wf_engine.getitemattrtext (
271: itemtype => item_type,
272: itemkey => item_key,
273: aname => 'UMX_PARENT_ITEM_KEY',
274: ignore_notfound => false);

Line 289: wf_engine.setItemattrtext (itemtype => item_type,

285: end if;
286:
287: if (l_approver_name is not null) then
288:
289: wf_engine.setItemattrtext (itemtype => item_type,
290: itemkey => item_key,
291: aname => 'APPROVER_NAME',
292: avalue => l_approver_name);
293:

Line 294: l_user_role_name := wf_engine.getItemattrtext (

290: itemkey => item_key,
291: aname => 'APPROVER_NAME',
292: avalue => l_approver_name);
293:
294: l_user_role_name := wf_engine.getItemattrtext (
295: itemtype => item_type,
296: itemkey => item_key,
297: aname => 'USER_ROLE_NAME');
298:

Line 306: wf_engine.getItemattrtext (itemtype => item_type,

302: -- who is requesting account
303: -- We have to first check to see if the requester has a user account.
304:
305: l_reg_service_type :=
306: wf_engine.getItemattrtext (itemtype => item_type,
307: itemkey => item_key,
308: aname => 'REG_SERVICE_TYPE');
309:
310: if ((l_reg_service_type = 'ADMIN_CREATION') or

Line 318: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');

314: -- user account. Check if the person id exists. If the person ID
315: -- exists, then we will use the WF role of that person.
316:
317: l_registration_data :=
318: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');
319: l_requested_for_party_id := wf_event.GetValueForParameter (
320: p_name => 'PERSON_PARTY_ID',
321: p_parameterlist => l_registration_data.getParameterList);
322:

Line 334: l_person_first_name := wf_engine.getItemattrtext (

330: p_display_name => l_display_name);
331:
332: else
333: -- l_requested_for_party_id is null. Create an ad hoc role.
334: l_person_first_name := wf_engine.getItemattrtext (
335: itemtype => item_type,
336: itemkey => item_key,
337: aname => 'FIRST_NAME');
338:

Line 339: l_person_last_name := wf_engine.getItemattrtext (

335: itemtype => item_type,
336: itemkey => item_key,
337: aname => 'FIRST_NAME');
338:
339: l_person_last_name := wf_engine.getItemattrtext (
340: itemtype => item_type,
341: itemkey => item_key,
342: aname => 'LAST_NAME');
343:

Line 344: l_person_middle_name := wf_engine.getItemattrtext (

340: itemtype => item_type,
341: itemkey => item_key,
342: aname => 'LAST_NAME');
343:
344: l_person_middle_name := wf_engine.getItemattrtext (
345: itemtype => item_type,
346: itemkey => item_key,
347: aname => 'MIDDLE_NAME');
348:

Line 349: l_suffix := wf_engine.getitemattrtext (

345: itemtype => item_type,
346: itemkey => item_key,
347: aname => 'MIDDLE_NAME');
348:
349: l_suffix := wf_engine.getitemattrtext (
350: itemtype => item_type,
351: itemkey => item_key,
352: aname => 'PERSON_SUFFIX');
353:

Line 354: l_prefix := wf_engine.getitemattrtext (

350: itemtype => item_type,
351: itemkey => item_key,
352: aname => 'PERSON_SUFFIX');
353:
354: l_prefix := wf_engine.getitemattrtext (
355: itemtype => item_type,
356: itemkey => item_key,
357: aname => 'PRE_NAME_ADJUNCT');
358:

Line 391: l_requester_email_address := wf_engine.getitemattrtext (

387: end if;
388:
389: l_user_role_name := '~UMX_' || l_reg_request_id;
390:
391: l_requester_email_address := wf_engine.getitemattrtext (
392: itemtype => item_type,
393: itemkey => item_key,
394: aname => 'EMAIL_ADDRESS');
395:

Line 407: wf_engine.getItemattrtext (itemtype => item_type,

403: else
404:
405: -- REG_SERVICE_TYPE is ADDITIONAL_ACCESS
406: l_requested_for_user_id :=
407: wf_engine.getItemattrtext (itemtype => item_type,
408: itemkey => item_key,
409: aname => 'REQUESTED_FOR_USER_ID');
410:
411: open getUserName (l_requested_for_user_id);

Line 417: wf_engine.setItemattrtext (itemtype => item_type,

413: close getUserName;
414:
415: end if;
416:
417: wf_engine.setItemattrtext (itemtype => item_type,
418: itemkey => item_key,
419: aname => 'USER_ROLE_NAME',
420: avalue => l_user_role_name);
421:

Line 422: l_event := wf_engine.getitemattrevent (itemtype => item_type,

418: itemkey => item_key,
419: aname => 'USER_ROLE_NAME',
420: avalue => l_user_role_name);
421:
422: l_event := wf_engine.getitemattrevent (itemtype => item_type,
423: itemkey => item_key,
424: name => 'REGISTRATION_DATA');
425:
426: l_status := UMX_REGISTRATION_UTIL.set_event_object (

Line 431: wf_engine.setitemattrevent (itemtype => item_type,

427: p_event => l_event,
428: p_attr_name => 'USER_ROLE_NAME',
429: p_attr_value => l_user_role_name);
430:
431: wf_engine.setitemattrevent (itemtype => item_type,
432: itemkey => item_key,
433: name => 'REGISTRATION_DATA',
434: event => l_event);
435: end if;

Line 518: l_first_name := wf_engine.getitemattrtext (

514: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
515: 'fnd.plsql.UMXNTFSB.getreceipientusername.begin', 'Begin');
516: end if;
517:
518: l_first_name := wf_engine.getitemattrtext (
519: itemtype => item_type,
520: itemkey => item_key,
521: aname =>'FIRST_NAME',
522: ignore_notfound => true);

Line 524: l_last_name := wf_engine.getitemattrtext (

520: itemkey => item_key,
521: aname =>'FIRST_NAME',
522: ignore_notfound => true);
523:
524: l_last_name := wf_engine.getitemattrtext (
525: itemtype => item_type,
526: itemkey => item_key,
527: aname =>'LAST_NAME',
528: ignore_notfound => true);

Line 530: l_middle_name := wf_engine.getitemattrtext (

526: itemkey => item_key,
527: aname =>'LAST_NAME',
528: ignore_notfound => true);
529:
530: l_middle_name := wf_engine.getitemattrtext (
531: itemtype => item_type,
532: itemkey => item_key,
533: aname =>'MIDDLE_NAME',
534: ignore_notfound => true);

Line 536: l_suffix := wf_engine.getitemattrtext (

532: itemkey => item_key,
533: aname =>'MIDDLE_NAME',
534: ignore_notfound => true);
535:
536: l_suffix := wf_engine.getitemattrtext (
537: itemtype => item_type,
538: itemkey => item_key,
539: aname =>'PERSON_SUFFIX',
540: ignore_notfound => true);

Line 542: l_prefix := wf_engine.getitemattrtext (

538: itemkey => item_key,
539: aname =>'PERSON_SUFFIX',
540: ignore_notfound => true);
541:
542: l_prefix := wf_engine.getitemattrtext (
543: itemtype => item_type,
544: itemkey => item_key,
545: aname =>'PRE_NAME_ADJUNCT',
546: ignore_notfound => true);

Line 548: l_requested_for_user_id := wf_engine.getitemattrtext (

544: itemkey => item_key,
545: aname =>'PRE_NAME_ADJUNCT',
546: ignore_notfound => true);
547:
548: l_requested_for_user_id := wf_engine.getitemattrtext (
549: itemtype => item_type,
550: itemkey => item_key,
551: aname =>'REQUESTED_FOR_USER_ID',
552: ignore_notfound => false);

Line 554: l_username := wf_engine.getitemattrtext (

550: itemkey => item_key,
551: aname =>'REQUESTED_FOR_USER_ID',
552: ignore_notfound => false);
553:
554: l_username := wf_engine.getitemattrtext (
555: itemtype => item_type,
556: itemkey => item_key,
557: aname =>'REQUESTED_USERNAME',
558: ignore_notfound => false);

Line 560: l_reg_service_type := wf_engine.getitemattrtext (

556: itemkey => item_key,
557: aname =>'REQUESTED_USERNAME',
558: ignore_notfound => false);
559:
560: l_reg_service_type := wf_engine.getitemattrtext (
561: itemtype => item_type,
562: itemkey => item_key,
563: aname =>'REG_SERVICE_TYPE',
564: ignore_notfound => false);

Line 579: wf_engine.setItemattrtext (

575: fetch get_username_from_userid
576: into l_username,l_email_address,l_first_name,
577: l_last_name,l_middle_name,l_suffix,l_prefix;
578:
579: wf_engine.setItemattrtext (
580: itemtype => item_type,
581: itemkey => item_key,
582: aname => 'REQUESTED_USERNAME',
583: avalue => l_username);

Line 585: wf_engine.setItemattrtext (

581: itemkey => item_key,
582: aname => 'REQUESTED_USERNAME',
583: avalue => l_username);
584:
585: wf_engine.setItemattrtext (
586: itemtype => item_type,
587: itemkey => item_key,
588: aname => 'EMAIL_ADDRESS',
589: avalue => l_email_address);

Line 613: wf_engine.setItemattrtext (

609: x_formatted_name => x_formatted_name,
610: x_formatted_lines_cnt => x_formatted_lines_cnt,
611: x_formatted_name_tbl => x_formatted_name_tbl);
612:
613: wf_engine.setItemattrtext (
614: itemtype => item_type,
615: itemkey => item_key,
616: aname => 'USER_DISPLAY_NAME',
617: avalue => LOWER (l_username));

Line 624: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');

620: -- The formatted name is missing due to first name, last name, etc are missing.
621: -- Get the formatted name from person party id
622: -- Get the person party id from the event message
623: l_registration_data :=
624: wf_engine.getitemattrevent (item_type, item_key, 'REGISTRATION_DATA');
625: l_person_party_id := wf_event.GetValueForParameter (
626: p_name => 'PERSON_PARTY_ID',
627: p_parameterlist => l_registration_data.getParameterList);
628: x_formatted_name := hz_format_pub.format_name (p_party_id => l_person_party_id);

Line 631: wf_engine.setItemattrtext (

627: p_parameterlist => l_registration_data.getParameterList);
628: x_formatted_name := hz_format_pub.format_name (p_party_id => l_person_party_id);
629: end if;
630:
631: wf_engine.setItemattrtext (
632: itemtype => item_type,
633: itemkey => item_key,
634: aname => 'FORMATED_NAME',
635: avalue => x_formatted_name);

Line 639: l_primary_phone := wf_engine.getitemattrtext (

635: avalue => x_formatted_name);
636:
637: -- getting a formated phone number
638:
639: l_primary_phone := wf_engine.getitemattrtext (
640: itemtype => item_type,
641: itemkey => item_key,
642: aname =>'PRIMARY_PHONE',
643: ignore_notfound => false);

Line 645: l_phone_country_code := wf_engine.getitemattrtext (

641: itemkey => item_key,
642: aname =>'PRIMARY_PHONE',
643: ignore_notfound => false);
644:
645: l_phone_country_code := wf_engine.getitemattrtext (
646: itemtype => item_type,
647: itemkey => item_key,
648: aname =>'COUNTRY_CODE',
649: ignore_notfound => false);

Line 651: l_phone_area_code := wf_engine.getitemattrtext (

647: itemkey => item_key,
648: aname =>'COUNTRY_CODE',
649: ignore_notfound => false);
650:
651: l_phone_area_code := wf_engine.getitemattrtext (
652: itemtype => item_type,
653: itemkey => item_key,
654: aname =>'AREA_CODE',
655: ignore_notfound => false);

Line 668: wf_engine.setItemattrtext (

664: x_return_status => x_return_status,
665: x_msg_count => x_msg_count,
666: x_msg_data => x_msg_data );
667:
668: wf_engine.setItemattrtext (
669: itemtype => item_type,
670: itemkey => item_key,
671: aname => 'FORMATED_PHONE',
672: avalue => x_formatted_phone);

Line 674: l_justification := wf_engine.getitemattrtext (

670: itemkey => item_key,
671: aname => 'FORMATED_PHONE',
672: avalue => x_formatted_phone);
673: --justification
674: l_justification := wf_engine.getitemattrtext (
675: itemtype => item_type,
676: itemkey => item_key,
677: aname =>'JUSTIFICATION',
678: ignore_notfound => false);

Line 682: wf_engine.setItemattrtext (

678: ignore_notfound => false);
679:
680: if (l_justification is null ) then
681:
682: wf_engine.setItemattrtext (
683: itemtype => item_type,
684: itemkey => item_key,
685: aname => 'JUSTIFICATION',
686: avalue => fnd_message.get_string ('FND','UMX_NOT_AVAIL'));

Line 690: l_mins := wf_engine.GetItemAttrNumber (

686: avalue => fnd_message.get_string ('FND','UMX_NOT_AVAIL'));
687: end if;
688:
689: --convert the mins timeout to days.
690: l_mins := wf_engine.GetItemAttrNumber (
691: itemtype => item_type,
692: itemkey => item_key,
693: aname =>'MINS_TO_TIMEOUT',
694: ignore_notfound => true);

Line 697: wf_engine.setItemattrtext (

693: aname =>'MINS_TO_TIMEOUT',
694: ignore_notfound => true);
695: if (l_mins > 0) then
696: l_days := l_mins / 1440;
697: wf_engine.setItemattrtext (
698: itemtype => item_type,
699: itemkey => item_key,
700: aname => 'DAYS_TO_TIMEOUT',
701: avalue => l_days);

Line 752: l_ame_application_id := wf_engine.getitemattrtext (

748: end if;
749:
750: -- get the next approver record again, this will not increment
751: -- approver chain it returns the same approver
752: l_ame_application_id := wf_engine.getitemattrtext (
753: itemtype => item_type,
754: itemkey => item_key,
755: aname =>'AME_APPLICATION_ID',
756: ignore_notfound => false);

Line 758: l_ame_transaction_type_id := wf_engine.getitemattrtext (

754: itemkey => item_key,
755: aname =>'AME_APPLICATION_ID',
756: ignore_notfound => false);
757:
758: l_ame_transaction_type_id := wf_engine.getitemattrtext (
759: itemtype => item_type,
760: itemkey => item_key,
761: aname =>'AME_TRANSACTION_TYPE_ID',
762: ignore_notfound => false);

Line 764: l_reg_request_id := wf_engine.getitemattrtext (

760: itemkey => item_key,
761: aname =>'AME_TRANSACTION_TYPE_ID',
762: ignore_notfound => false);
763:
764: l_reg_request_id := wf_engine.getitemattrtext (
765: itemtype => item_type,
766: itemkey => item_key,
767: aname =>'UMX_PARENT_ITEM_KEY',
768: ignore_notfound => false);

Line 837: l_ame_application_id := wf_engine.getitemattrtext (itemtype => item_type,

833: end if;
834:
835: -- get the next approver record again, this will not increment
836: -- approver chain it returns the same approver
837: l_ame_application_id := wf_engine.getitemattrtext (itemtype => item_type,
838: itemkey => item_key,
839: aname =>'AME_APPLICATION_ID',
840: ignore_notfound => false);
841: l_ame_transaction_type_id := wf_engine.getitemattrtext (itemtype => item_type,

Line 841: l_ame_transaction_type_id := wf_engine.getitemattrtext (itemtype => item_type,

837: l_ame_application_id := wf_engine.getitemattrtext (itemtype => item_type,
838: itemkey => item_key,
839: aname =>'AME_APPLICATION_ID',
840: ignore_notfound => false);
841: l_ame_transaction_type_id := wf_engine.getitemattrtext (itemtype => item_type,
842: itemkey => item_key,
843: aname =>'AME_TRANSACTION_TYPE_ID',
844: ignore_notfound => false);
845: l_reg_request_id := wf_engine.getitemattrtext (itemtype => item_type,

Line 845: l_reg_request_id := wf_engine.getitemattrtext (itemtype => item_type,

841: l_ame_transaction_type_id := wf_engine.getitemattrtext (itemtype => item_type,
842: itemkey => item_key,
843: aname =>'AME_TRANSACTION_TYPE_ID',
844: ignore_notfound => false);
845: l_reg_request_id := wf_engine.getitemattrtext (itemtype => item_type,
846: itemkey => item_key,
847: aname =>'UMX_PARENT_ITEM_KEY',
848: ignore_notfound => false);
849: l_rejection_reason := wf_engine.getitemattrtext (itemtype => item_type,

Line 849: l_rejection_reason := wf_engine.getitemattrtext (itemtype => item_type,

845: l_reg_request_id := wf_engine.getitemattrtext (itemtype => item_type,
846: itemkey => item_key,
847: aname =>'UMX_PARENT_ITEM_KEY',
848: ignore_notfound => false);
849: l_rejection_reason := wf_engine.getitemattrtext (itemtype => item_type,
850: itemkey => item_key,
851: aname =>'WF_NOTE',
852: ignore_notfound => false);
853:

Line 884: l_event := wf_engine.getitemattrevent (itemtype => item_type,

880: end if;
881:
882: -- populate the rejected reason into event object, and main wf
883: -- so that, this will go into rejection notification
884: l_event := wf_engine.getitemattrevent (itemtype => item_type,
885: itemkey => item_key,
886: name => 'REGISTRATION_DATA');
887:
888: l_status := UMX_REGISTRATION_UTIL.set_event_object (

Line 893: wf_engine.setitemattrevent (itemtype => item_type,

889: p_event => l_event,
890: p_attr_name => 'WF_NOTE',
891: p_attr_value => l_rejection_reason);
892:
893: wf_engine.setitemattrevent (itemtype => item_type,
894: itemkey => item_key,
895: name => 'REGISTRATION_DATA',
896: event => l_event);
897:

Line 942: l_role_name := wf_engine.getitemattrtext (itemtype => item_type,

938: FND_LOG.STRING (FND_LOG.LEVEL_PROCEDURE,
939: 'fnd.plsql.UMXNTFSB.queryroledisplayname.begin', 'Begin');
940: end if;
941:
942: l_role_name := wf_engine.getitemattrtext (itemtype => item_type,
943: itemkey => item_key,
944: aname =>'WF_ROLE_NAME',
945: ignore_notfound => false);
946:

Line 961: wf_engine.setitemattrtext (itemtype => item_type,

957:
958: end if;
959:
960: if (l_role_display_name is not null) then
961: wf_engine.setitemattrtext (itemtype => item_type,
962: itemkey => item_key,
963: aname => 'ROLE_DISPLAY_NAME',
964: avalue => l_role_display_name);
965: end if;