410: if (i_event_name is not null)
411: then
412:
413: i_params := wf_parameter_list_t();
414: wf_event.addParameterToList(p_name => 'ECX_PARTY_TYPE',
415: p_value => i_party_type,
416: p_parameterlist => i_params);
417: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
418: p_value => i_party_id,
413: i_params := wf_parameter_list_t();
414: wf_event.addParameterToList(p_name => 'ECX_PARTY_TYPE',
415: p_value => i_party_type,
416: p_parameterlist => i_params);
417: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
418: p_value => i_party_id,
419: p_parameterlist => i_params);
420: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
421: p_value => i_party_site_id,
416: p_parameterlist => i_params);
417: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
418: p_value => i_party_id,
419: p_parameterlist => i_params);
420: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
421: p_value => i_party_site_id,
422: p_parameterlist => i_params);
423: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
424: p_value => i_transaction_type,
419: p_parameterlist => i_params);
420: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
421: p_value => i_party_site_id,
422: p_parameterlist => i_params);
423: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
424: p_value => i_transaction_type,
425: p_parameterlist => i_params);
426: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
427: p_value => i_transaction_subtype,
422: p_parameterlist => i_params);
423: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
424: p_value => i_transaction_type,
425: p_parameterlist => i_params);
426: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
427: p_value => i_transaction_subtype,
428: p_parameterlist => i_params);
429: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
430: p_value => i_message_type,
425: p_parameterlist => i_params);
426: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
427: p_value => i_transaction_subtype,
428: p_parameterlist => i_params);
429: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
430: p_value => i_message_type,
431: p_parameterlist => i_params);
432: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
433: p_value => i_message_standard,
428: p_parameterlist => i_params);
429: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
430: p_value => i_message_type,
431: p_parameterlist => i_params);
432: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
433: p_value => i_message_standard,
434: p_parameterlist => i_params);
435: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
436: p_value => i_document_number,
431: p_parameterlist => i_params);
432: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
433: p_value => i_message_standard,
434: p_parameterlist => i_params);
435: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
436: p_value => i_document_number,
437: p_parameterlist => i_params);
438: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
439: p_value => i_protocol_type,
434: p_parameterlist => i_params);
435: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
436: p_value => i_document_number,
437: p_parameterlist => i_params);
438: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
439: p_value => i_protocol_type,
440: p_parameterlist => i_params);
441: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
442: p_value => i_protocol_address,
437: p_parameterlist => i_params);
438: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
439: p_value => i_protocol_type,
440: p_parameterlist => i_params);
441: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
442: p_value => i_protocol_address,
443: p_parameterlist => i_params);
444: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
445: p_value => i_username,
440: p_parameterlist => i_params);
441: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
442: p_value => i_protocol_address,
443: p_parameterlist => i_params);
444: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
445: p_value => i_username,
446: p_parameterlist => i_params);
447: wf_event.addParameterToList(p_name => 'ECX_MSGID',
448: p_value => i_message_id,
443: p_parameterlist => i_params);
444: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
445: p_value => i_username,
446: p_parameterlist => i_params);
447: wf_event.addParameterToList(p_name => 'ECX_MSGID',
448: p_value => i_message_id,
449: p_parameterlist => i_params);
450: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
451: p_value => i_attribute1,
446: p_parameterlist => i_params);
447: wf_event.addParameterToList(p_name => 'ECX_MSGID',
448: p_value => i_message_id,
449: p_parameterlist => i_params);
450: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
451: p_value => i_attribute1,
452: p_parameterlist => i_params);
453: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
454: p_value => i_attribute2,
449: p_parameterlist => i_params);
450: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
451: p_value => i_attribute1,
452: p_parameterlist => i_params);
453: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
454: p_value => i_attribute2,
455: p_parameterlist => i_params);
456: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
457: p_value => i_attribute3,
452: p_parameterlist => i_params);
453: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
454: p_value => i_attribute2,
455: p_parameterlist => i_params);
456: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
457: p_value => i_attribute3,
458: p_parameterlist => i_params);
459: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
460: p_value => i_attribute4,
455: p_parameterlist => i_params);
456: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
457: p_value => i_attribute3,
458: p_parameterlist => i_params);
459: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
460: p_value => i_attribute4,
461: p_parameterlist => i_params);
462: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
463: p_value => i_attribute5,
458: p_parameterlist => i_params);
459: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
460: p_value => i_attribute4,
461: p_parameterlist => i_params);
462: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
463: p_value => i_attribute5,
464: p_parameterlist => i_params);
465: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
466: p_value => i_text_val,
461: p_parameterlist => i_params);
462: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
463: p_value => i_attribute5,
464: p_parameterlist => i_params);
465: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
466: p_value => i_text_val,
467: p_parameterlist => i_params);
468: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
469: p_value => i_status,
464: p_parameterlist => i_params);
465: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
466: p_value => i_text_val,
467: p_parameterlist => i_params);
468: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
469: p_value => i_status,
470: p_parameterlist => i_params);
471: wf_event.addParameterToList(p_name => 'ECX_ERR_PARAMS',
472: p_value => i_errparams,
467: p_parameterlist => i_params);
468: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
469: p_value => i_status,
470: p_parameterlist => i_params);
471: wf_event.addParameterToList(p_name => 'ECX_ERR_PARAMS',
472: p_value => i_errparams,
473: p_parameterlist => i_params);
474:
475:
478: i_method_name);
479: end if;
480: i_random_value := wf_core.random;
481: i_event_key := i_event_key||i_random_value;
482: wf_event.raise(i_event_name, i_event_key, null, i_params);
483:
484: end if;
485:
486: if (i_block_mode = 'Y')
529: end if;
530: if (i_status <> 0)
531: then
532: i_params := wf_parameter_list_t();
533: wf_event.addParameterToList(p_name => 'ECX_PARTY_TYPE',
534: p_value => i_party_type,
535: p_parameterlist => i_params);
536: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
537: p_value => i_party_id,
532: i_params := wf_parameter_list_t();
533: wf_event.addParameterToList(p_name => 'ECX_PARTY_TYPE',
534: p_value => i_party_type,
535: p_parameterlist => i_params);
536: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
537: p_value => i_party_id,
538: p_parameterlist => i_params);
539: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
540: p_value => i_party_site_id,
535: p_parameterlist => i_params);
536: wf_event.addParameterToList(p_name => 'ECX_PARTY_ID',
537: p_value => i_party_id,
538: p_parameterlist => i_params);
539: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
540: p_value => i_party_site_id,
541: p_parameterlist => i_params);
542: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
543: p_value => i_transaction_type,
538: p_parameterlist => i_params);
539: wf_event.addParameterToList(p_name => 'ECX_PARTY_SITE_ID',
540: p_value => i_party_site_id,
541: p_parameterlist => i_params);
542: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
543: p_value => i_transaction_type,
544: p_parameterlist => i_params);
545: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
546: p_value => i_transaction_subtype,
541: p_parameterlist => i_params);
542: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_TYPE',
543: p_value => i_transaction_type,
544: p_parameterlist => i_params);
545: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
546: p_value => i_transaction_subtype,
547: p_parameterlist => i_params);
548: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
549: p_value => i_message_type,
544: p_parameterlist => i_params);
545: wf_event.addParameterToList(p_name => 'ECX_TRANSACTION_SUBTYPE',
546: p_value => i_transaction_subtype,
547: p_parameterlist => i_params);
548: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
549: p_value => i_message_type,
550: p_parameterlist => i_params);
551: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
552: p_value => i_message_standard,
547: p_parameterlist => i_params);
548: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_TYPE',
549: p_value => i_message_type,
550: p_parameterlist => i_params);
551: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
552: p_value => i_message_standard,
553: p_parameterlist => i_params);
554: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
555: p_value => i_document_number,
550: p_parameterlist => i_params);
551: wf_event.addParameterToList(p_name => 'ECX_MESSAGE_STANDARD',
552: p_value => i_message_standard,
553: p_parameterlist => i_params);
554: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
555: p_value => i_document_number,
556: p_parameterlist => i_params);
557: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
558: p_value => i_protocol_type,
553: p_parameterlist => i_params);
554: wf_event.addParameterToList(p_name => 'ECX_DOCUMENT_ID',
555: p_value => i_document_number,
556: p_parameterlist => i_params);
557: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
558: p_value => i_protocol_type,
559: p_parameterlist => i_params);
560: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
561: p_value => i_protocol_address,
556: p_parameterlist => i_params);
557: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_TYPE',
558: p_value => i_protocol_type,
559: p_parameterlist => i_params);
560: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
561: p_value => i_protocol_address,
562: p_parameterlist => i_params);
563: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
564: p_value => i_username,
559: p_parameterlist => i_params);
560: wf_event.addParameterToList(p_name => 'ECX_PROTOCOL_ADDRESS',
561: p_value => i_protocol_address,
562: p_parameterlist => i_params);
563: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
564: p_value => i_username,
565: p_parameterlist => i_params);
566: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
567: p_value => i_attribute1,
562: p_parameterlist => i_params);
563: wf_event.addParameterToList(p_name => 'ECX_USERNAME',
564: p_value => i_username,
565: p_parameterlist => i_params);
566: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
567: p_value => i_attribute1,
568: p_parameterlist => i_params);
569: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
570: p_value => i_attribute2,
565: p_parameterlist => i_params);
566: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE1',
567: p_value => i_attribute1,
568: p_parameterlist => i_params);
569: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
570: p_value => i_attribute2,
571: p_parameterlist => i_params);
572: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
573: p_value => i_attribute3,
568: p_parameterlist => i_params);
569: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE2',
570: p_value => i_attribute2,
571: p_parameterlist => i_params);
572: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
573: p_value => i_attribute3,
574: p_parameterlist => i_params);
575: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
576: p_value => i_attribute4,
571: p_parameterlist => i_params);
572: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE3',
573: p_value => i_attribute3,
574: p_parameterlist => i_params);
575: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
576: p_value => i_attribute4,
577: p_parameterlist => i_params);
578: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
579: p_value => i_attribute5,
574: p_parameterlist => i_params);
575: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE4',
576: p_value => i_attribute4,
577: p_parameterlist => i_params);
578: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
579: p_value => i_attribute5,
580: p_parameterlist => i_params);
581: wf_event.addParameterToList(p_name => 'ECX_MSGID',
582: p_value => i_message_id,
577: p_parameterlist => i_params);
578: wf_event.addParameterToList(p_name => 'ECX_ATTRIBUTE5',
579: p_value => i_attribute5,
580: p_parameterlist => i_params);
581: wf_event.addParameterToList(p_name => 'ECX_MSGID',
582: p_value => i_message_id,
583: p_parameterlist => i_params);
584: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
585: p_value => i_text_val,
580: p_parameterlist => i_params);
581: wf_event.addParameterToList(p_name => 'ECX_MSGID',
582: p_value => i_message_id,
583: p_parameterlist => i_params);
584: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
585: p_value => i_text_val,
586: p_parameterlist => i_params);
587: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
588: p_value => i_status,
583: p_parameterlist => i_params);
584: wf_event.addParameterToList(p_name => 'ECX_ERROR_MSG',
585: p_value => i_text_val,
586: p_parameterlist => i_params);
587: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
588: p_value => i_status,
589: p_parameterlist => i_params);
590: wf_event.addParameterToList(p_name => 'ECX_ERR_PARAMS',
591: p_value => i_errparams,
586: p_parameterlist => i_params);
587: wf_event.addParameterToList(p_name => 'ECX_RETURN_CODE',
588: p_value => i_status,
589: p_parameterlist => i_params);
590: wf_event.addParameterToList(p_name => 'ECX_ERR_PARAMS',
591: p_value => i_errparams,
592: p_parameterlist => i_params);
593: -- set the error type
594: If (i_status <> 0)
596: i_error_type := 30; /*** Notify System Administrator ***/
597: --- ECX_Trading_Partner_PVT.get_sysadmin_email(i_admin_email,o_ret_code,o_ret_msg);
598: end if;
599:
600: wf_event.addParameterToList(p_name => 'ECX_ERROR_TYPE',
601: p_value => i_error_Type,
602: p_parameterlist => i_params);
603:
604: wf_event.addParameterToList(p_name => 'ECX_SA_ROLE',
600: wf_event.addParameterToList(p_name => 'ECX_ERROR_TYPE',
601: p_value => i_error_Type,
602: p_parameterlist => i_params);
603:
604: wf_event.addParameterToList(p_name => 'ECX_SA_ROLE',
605: p_value => 'ECX_SA',
606: p_parameterlist => i_params);
607:
608: if(l_statementEnabled) then
608: if(l_statementEnabled) then
609: ecx_debug.log(l_statement,'Raising the event - oracle.apps.ecx.processing.message.callback',
610: i_method_name);
611: end if;
612: wf_event.raise('oracle.apps.ecx.processing.message.callback',
613: i_transaction_type|| '-' || i_transaction_subtype || '-' ||
614: i_party_site_id || '-' || i_error_no,
615: null,
616: i_params
667: o_ret_code OUT NOCOPY pls_integer,
668: o_ret_msg OUT NOCOPY varchar2
669: )
670: is
671: p_event wf_event_t;
672: x_from_agt wf_agent_t := wf_agent_t(null, null);
673: m_transaction_subtype varchar2(250);
674: m_party_id number; /* Bug 2122579 */
675: m_party_site_id number; /* Bug 2122579 */
732: open c_ecx_errorno;
733: fetch c_ecx_errorno into i_error_no;
734: close c_ecx_errorno;
735:
736: wf_event_t.initialize(p_event);
737: x_from_agt := null;
738: p_event.setEventName('oracle.apps.ecx.processing.notification.send');
739: p_event.setEventKey(i_transaction_type|| '-' || m_transaction_subtype || '-' || m_party_site_id || '-' || i_error_no);
740: p_event.setFromAgent(x_from_agt);
748: p_event.addParameterToList('ECX_TRANSACTION_TYPE', ecx_utils.g_transaction_type);
749: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',ecx_utils.g_transaction_subtype);
750: p_event.addParameterToList('ECX_PARTY_ADMIN_EMAIL',m_admin_email);
751:
752: wf_event.raise(p_event.getEventName(),
753: p_event.getEventKey(),
754: null,
755: p_event.getParameterList()
756: );
788: from ecx_transactions
789: where transaction_type = i_transaction_type
790: and transaction_subtype = i_transaction_subtype;
791:
792: p_event wf_event_t;
793: x_from_agt wf_agent_t := wf_agent_t(null, null);
794:
795: i_admin_email ecx_tp_headers.company_admin_email%type;
796: i_party_type ecx_tp_headers.party_type%type;
843: open c_ecx_errorno;
844: fetch c_ecx_errorno into i_error_no;
845: close c_ecx_errorno;
846:
847: wf_event_t.initialize(p_event);
848: x_from_agt := null;
849: p_event.setEventName('oracle.apps.ecx.processing.notification.send');
850: p_event.setEventKey(p_transaction_type|| '-' || p_transaction_subtype || '-' || p_party_site_id || '-' || i_error_no);
851: p_event.setFromAgent(x_from_agt);
860: p_event.addParameterToList('ECX_TRANSACTION_SUBTYPE',p_transaction_subtype);
861: p_event.addParameterToList('ECX_PARTY_ADMIN_EMAIL',i_admin_email);
862:
863:
864: wf_event.raise(p_event.getEventName(),
865: p_event.getEventKey(),
866: null,
867: p_event.getParameterList()
868: );
1429: end log_resend;
1430:
1431:
1432: procedure get_event_params
1433: (p_event in wf_event_t,
1434: x_message_type out NOCOPY varchar2,
1435: x_message_standard out NOCOPY varchar2,
1436: x_ext_type out NOCOPY varchar2,
1437: x_ext_subtype out NOCOPY varchar2,
1596: end;
1597:
1598:
1599: procedure outbound_log (
1600: p_event in wf_event_t)
1601:
1602: is
1603:
1604: l_out_msgid raw(16);
1651: if (p_event is null) then
1652: return;
1653: end if;
1654:
1655: if (wf_event.g_msgid is null) then
1656: return;
1657: else
1658: l_out_msgid := wf_event.g_msgid;
1659: end if;
1654:
1655: if (wf_event.g_msgid is null) then
1656: return;
1657: else
1658: l_out_msgid := wf_event.g_msgid;
1659: end if;
1660:
1661: l_module := 'ecx.plsql.ecx_errorlog.outbound_log';
1662: if (wf_log_pkg.level_procedure >= fnd_log.g_current_runtime_level) then