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: if (l_person_party_id is null) then

Line 635: wf_engine.setItemattrtext (

631: x_formatted_name := hz_format_pub.format_name (p_party_id => l_person_party_id);
632: end if;
633: end if;
634:
635: wf_engine.setItemattrtext (
636: itemtype => item_type,
637: itemkey => item_key,
638: aname => 'FORMATED_NAME',
639: avalue => x_formatted_name);

Line 643: l_primary_phone := wf_engine.getitemattrtext (

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

Line 649: l_phone_country_code := wf_engine.getitemattrtext (

645: itemkey => item_key,
646: aname =>'PRIMARY_PHONE',
647: ignore_notfound => false);
648:
649: l_phone_country_code := wf_engine.getitemattrtext (
650: itemtype => item_type,
651: itemkey => item_key,
652: aname =>'COUNTRY_CODE',
653: ignore_notfound => false);

Line 655: l_phone_area_code := wf_engine.getitemattrtext (

651: itemkey => item_key,
652: aname =>'COUNTRY_CODE',
653: ignore_notfound => false);
654:
655: l_phone_area_code := wf_engine.getitemattrtext (
656: itemtype => item_type,
657: itemkey => item_key,
658: aname =>'AREA_CODE',
659: ignore_notfound => false);

Line 672: wf_engine.setItemattrtext (

668: x_return_status => x_return_status,
669: x_msg_count => x_msg_count,
670: x_msg_data => x_msg_data );
671:
672: wf_engine.setItemattrtext (
673: itemtype => item_type,
674: itemkey => item_key,
675: aname => 'FORMATED_PHONE',
676: avalue => x_formatted_phone);

Line 678: l_justification := wf_engine.getitemattrtext (

674: itemkey => item_key,
675: aname => 'FORMATED_PHONE',
676: avalue => x_formatted_phone);
677: --justification
678: l_justification := wf_engine.getitemattrtext (
679: itemtype => item_type,
680: itemkey => item_key,
681: aname =>'JUSTIFICATION',
682: ignore_notfound => false);

Line 686: wf_engine.setItemattrtext (

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

Line 694: l_mins := wf_engine.GetItemAttrNumber (

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

Line 701: wf_engine.setItemattrtext (

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

Line 756: l_ame_application_id := wf_engine.getitemattrtext (

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

Line 762: l_ame_transaction_type_id := wf_engine.getitemattrtext (

758: itemkey => item_key,
759: aname =>'AME_APPLICATION_ID',
760: ignore_notfound => false);
761:
762: l_ame_transaction_type_id := wf_engine.getitemattrtext (
763: itemtype => item_type,
764: itemkey => item_key,
765: aname =>'AME_TRANSACTION_TYPE_ID',
766: ignore_notfound => false);

Line 768: l_reg_request_id := wf_engine.getitemattrtext (

764: itemkey => item_key,
765: aname =>'AME_TRANSACTION_TYPE_ID',
766: ignore_notfound => false);
767:
768: l_reg_request_id := wf_engine.getitemattrtext (
769: itemtype => item_type,
770: itemkey => item_key,
771: aname =>'UMX_PARENT_ITEM_KEY',
772: ignore_notfound => false);

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

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

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

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

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

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

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

849: l_reg_request_id := wf_engine.getitemattrtext (itemtype => item_type,
850: itemkey => item_key,
851: aname =>'UMX_PARENT_ITEM_KEY',
852: ignore_notfound => false);
853: l_rejection_reason := wf_engine.getitemattrtext (itemtype => item_type,
854: itemkey => item_key,
855: aname =>'WF_NOTE',
856: ignore_notfound => false);
857:

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

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

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

893: p_event => l_event,
894: p_attr_name => 'WF_NOTE',
895: p_attr_value => l_rejection_reason);
896:
897: wf_engine.setitemattrevent (itemtype => item_type,
898: itemkey => item_key,
899: name => 'REGISTRATION_DATA',
900: event => l_event);
901:

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

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

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

961:
962: end if;
963:
964: if (l_role_display_name is not null) then
965: wf_engine.setitemattrtext (itemtype => item_type,
966: itemkey => item_key,
967: aname => 'ROLE_DISPLAY_NAME',
968: avalue => l_role_display_name);
969: end if;