520:
521: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
522: select VALUE into l_system from V$PARAMETER where NAME='db_name';
523:
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
521: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
522: select VALUE into l_system from V$PARAMETER where NAME='db_name';
523:
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
522: select VALUE into l_system from V$PARAMETER where NAME='db_name';
523:
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
523:
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
524: FND_MESSAGE.CLEAR;
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
532:
525: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_SUB');
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
532:
533: fdebug('Subject:'|| document);
526: FND_MESSAGE.SET_TOKEN(token=>'SYSTEM', value=>l_system);
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
532:
533: fdebug('Subject:'|| document);
534: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
527: FND_MESSAGE.SET_TOKEN(token=>'SEVERITY', value=>l_severity);
528: FND_MESSAGE.SET_TOKEN(token=>'APP', value=>l_app_sn);
529: FND_MESSAGE.SET_TOKEN(token=>'COMP', value=>l_comp_sn);
530: document := FND_MESSAGE.GET;
531: FND_MESSAGE.CLEAR;
532:
533: fdebug('Subject:'|| document);
534: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocSubject');
535: /*
608: document_type := 'text/plain';
609: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
610:
611: --Documnet other Part
612: FND_MESSAGE.clear;
613: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
614: document := FND_MESSAGE.GET;
615: ---fdebug('document' || document);
616:
609: retriveComponentInfo(l_app_id, l_comp_type, l_comp_id, l_comp_sn, l_comp_fn);
610:
611: --Documnet other Part
612: FND_MESSAGE.clear;
613: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
614: document := FND_MESSAGE.GET;
615: ---fdebug('document' || document);
616:
617: FND_MESSAGE.clear;
610:
611: --Documnet other Part
612: FND_MESSAGE.clear;
613: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
614: document := FND_MESSAGE.GET;
615: ---fdebug('document' || document);
616:
617: FND_MESSAGE.clear;
618: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
613: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_CTX');
614: document := FND_MESSAGE.GET;
615: ---fdebug('document' || document);
616:
617: FND_MESSAGE.clear;
618: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
619: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
614: document := FND_MESSAGE.GET;
615: ---fdebug('document' || document);
616:
617: FND_MESSAGE.clear;
618: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
619: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
622:
615: ---fdebug('document' || document);
616:
617: FND_MESSAGE.clear;
618: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
619: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
622:
623: FND_MESSAGE.clear;
616:
617: FND_MESSAGE.clear;
618: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_ALERT_ID');
619: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
622:
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
619: FND_MESSAGE.SET_TOKEN(token=>'ID', value=>document_id);
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
622:
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
625: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
620: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
621: ---fdebug('document' || document);
622:
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
625: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
621: ---fdebug('document' || document);
622:
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
625: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
629:
622:
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
625: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
629:
630: FND_MESSAGE.clear;
623: FND_MESSAGE.clear;
624: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_APP');
625: FND_MESSAGE.SET_TOKEN(token=>'APP_FULL_NAME', value=>l_app_fn);
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
629:
630: FND_MESSAGE.clear;
631: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
626: FND_MESSAGE.SET_TOKEN(token=>'APP_SN', value=>l_app_sn);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
629:
630: FND_MESSAGE.clear;
631: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
632: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
627: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
628: ---fdebug('document' || document);
629:
630: FND_MESSAGE.clear;
631: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
632: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
635:
628: ---fdebug('document' || document);
629:
630: FND_MESSAGE.clear;
631: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
632: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
635:
636: FND_MESSAGE.clear;
629:
630: FND_MESSAGE.clear;
631: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP_TYPE');
632: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
635:
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
632: FND_MESSAGE.SET_TOKEN(token=>'COMP_TYPE', value=>l_comp_type);
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
635:
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
638: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
633: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
634: --fdebug('document' || document);
635:
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
638: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
641: --fdebug('document' || document);
634: --fdebug('document' || document);
635:
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
638: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
641: --fdebug('document' || document);
642:
635:
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
638: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
641: --fdebug('document' || document);
642:
643: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
636: FND_MESSAGE.clear;
637: FND_MESSAGE.SET_NAME(application=>'FND', name=>'AF_OAM_BE_COMP');
638: FND_MESSAGE.SET_TOKEN(token=>'COMP_FULL_NAME', value=>l_comp_fn);
639: FND_MESSAGE.SET_TOKEN(token=>'COMP_SN', value=>l_comp_sn);
640: document := document || WF_CORE.NEWLINE || FND_MESSAGE.GET;
641: --fdebug('document' || document);
642:
643: fdebug('Out:FND_OAM_KBF_SUBS.createBusExcepDocPart1');
644: END createBusExcepDocPart1;