527:
528: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
529: select VALUE into l_system from V$PARAMETER where NAME='db_name';
530:
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
528: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
529: select VALUE into l_system from V$PARAMETER where NAME='db_name';
530:
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
529: select VALUE into l_system from V$PARAMETER where NAME='db_name';
530:
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
530:
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
531: FND_MESSAGE.CLEAR;
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
539:
532: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
539:
540: fdebug('Subject:'|| document);
533: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
539:
540: fdebug('Subject:'|| document);
541: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
534: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
535: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
536: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
537: document := FND_MESSAGE.GET;
538: FND_MESSAGE.CLEAR;
539:
540: fdebug('Subject:'|| document);
541: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
542: /*
618: document_type := 'text/plain';
619: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
620:
621: --Documnet other Part
622: FND_MESSAGE.clear;
623: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
624: document := FND_MESSAGE.GET;
625: ---fdebug('document' || document);
626:
619: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
620:
621: --Documnet other Part
622: FND_MESSAGE.clear;
623: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
624: document := FND_MESSAGE.GET;
625: ---fdebug('document' || document);
626:
627: FND_MESSAGE.clear;
620:
621: --Documnet other Part
622: FND_MESSAGE.clear;
623: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
624: document := FND_MESSAGE.GET;
625: ---fdebug('document' || document);
626:
627: FND_MESSAGE.clear;
628: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
623: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
624: document := FND_MESSAGE.GET;
625: ---fdebug('document' || document);
626:
627: FND_MESSAGE.clear;
628: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
629: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
624: document := FND_MESSAGE.GET;
625: ---fdebug('document' || document);
626:
627: FND_MESSAGE.clear;
628: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
629: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
632:
625: ---fdebug('document' || document);
626:
627: FND_MESSAGE.clear;
628: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
629: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
632:
633: FND_MESSAGE.clear;
626:
627: FND_MESSAGE.clear;
628: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
629: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
632:
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
629: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
632:
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
635: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
630: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
631: ---fdebug('document' || document);
632:
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
635: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
631: ---fdebug('document' || document);
632:
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
635: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
639:
632:
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
635: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
639:
640: FND_MESSAGE.clear;
633: FND_MESSAGE.clear;
634: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
635: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
639:
640: FND_MESSAGE.clear;
641: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
636: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
639:
640: FND_MESSAGE.clear;
641: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
642: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
643: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
644: --fdebug('document' || document);
637: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
638: ---fdebug('document' || document);
639:
640: FND_MESSAGE.clear;
641: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
642: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
643: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
644: --fdebug('document' || document);
645:
638: ---fdebug('document' || document);
639:
640: FND_MESSAGE.clear;
641: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
642: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
643: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
644: --fdebug('document' || document);
645:
646: --10254432
639:
640: FND_MESSAGE.clear;
641: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
642: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
643: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
644: --fdebug('document' || document);
645:
646: --10254432
647: if (l_comp_fn<>'UNKNOWN') then
644: --fdebug('document' || document);
645:
646: --10254432
647: if (l_comp_fn<>'UNKNOWN') then
648: FND_MESSAGE.clear;
649: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
650: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
651: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
645:
646: --10254432
647: if (l_comp_fn<>'UNKNOWN') then
648: FND_MESSAGE.clear;
649: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
650: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
651: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
653: --fdebug('document' || document);
646: --10254432
647: if (l_comp_fn<>'UNKNOWN') then
648: FND_MESSAGE.clear;
649: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
650: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
651: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
653: --fdebug('document' || document);
654: end if;
647: if (l_comp_fn<>'UNKNOWN') then
648: FND_MESSAGE.clear;
649: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
650: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
651: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
653: --fdebug('document' || document);
654: end if;
655:
648: FND_MESSAGE.clear;
649: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
650: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
651: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
652: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
653: --fdebug('document' || document);
654: end if;
655:
656: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');