646: IF (l_err_code > 0)
647: THEN
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
651: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
652: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
653: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
654: FND_MSG_PUB.add;
647: THEN
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
651: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
652: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
653: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
654: FND_MSG_PUB.add;
655: END IF;
648: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR)
649: THEN
650: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
651: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
652: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
653: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
654: FND_MSG_PUB.add;
655: END IF;
656: l_return_status := FND_API.G_RET_STS_ERROR;
649: THEN
650: FND_MESSAGE.SET_NAME('PA','PA_WF_CLIENT_EXTN');
651: FND_MESSAGE.SET_TOKEN('EXTNAME', 'PA_BUDGET_WF.START_BUDGET_WF');
652: FND_MESSAGE.SET_TOKEN('ERRCODE',l_err_code);
653: FND_MESSAGE.SET_TOKEN('ERRMSG', l_err_stage);
654: FND_MSG_PUB.add;
655: END IF;
656: l_return_status := FND_API.G_RET_STS_ERROR;
657:
786: IF (l_return_status = FND_API.G_RET_STS_SUCCESS)
787: THEN
788: -- Success!
789:
790: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_SUCCESS');
791: l_msg_subj_text := FND_MESSAGE.GET;
792:
793: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_SUCCESS');
794: l_msg_desc_text := FND_MESSAGE.GET;
787: THEN
788: -- Success!
789:
790: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_SUCCESS');
791: l_msg_subj_text := FND_MESSAGE.GET;
792:
793: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_SUCCESS');
794: l_msg_desc_text := FND_MESSAGE.GET;
795:
789:
790: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_SUCCESS');
791: l_msg_subj_text := FND_MESSAGE.GET;
792:
793: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_SUCCESS');
794: l_msg_desc_text := FND_MESSAGE.GET;
795:
796: wf_engine.SetItemAttrText
797: ( itemtype => itemtype
790: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_SUCCESS');
791: l_msg_subj_text := FND_MESSAGE.GET;
792:
793: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_SUCCESS');
794: l_msg_desc_text := FND_MESSAGE.GET;
795:
796: wf_engine.SetItemAttrText
797: ( itemtype => itemtype
798: , itemkey => itemkey
809:
810: ELSE
811: -- Errors! Note that the WF ONLY marked as FAILURE if ORA error
812:
813: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_FAILURE');
814: l_msg_subj_text := FND_MESSAGE.GET;
815:
816: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_FAILURE');
817: l_msg_desc_text := FND_MESSAGE.GET;
810: ELSE
811: -- Errors! Note that the WF ONLY marked as FAILURE if ORA error
812:
813: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_FAILURE');
814: l_msg_subj_text := FND_MESSAGE.GET;
815:
816: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_FAILURE');
817: l_msg_desc_text := FND_MESSAGE.GET;
818:
812:
813: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_FAILURE');
814: l_msg_subj_text := FND_MESSAGE.GET;
815:
816: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_FAILURE');
817: l_msg_desc_text := FND_MESSAGE.GET;
818:
819: wf_engine.SetItemAttrText
820: ( itemtype => itemtype
813: FND_MESSAGE.SET_NAME ('PA','PA_NFSUBJ_BU_INTG_FAILURE');
814: l_msg_subj_text := FND_MESSAGE.GET;
815:
816: FND_MESSAGE.SET_NAME ('PA','PA_NFDESC_BU_INTG_FAILURE');
817: l_msg_desc_text := FND_MESSAGE.GET;
818:
819: wf_engine.SetItemAttrText
820: ( itemtype => itemtype
821: , itemkey => itemkey
895: -- error processing code to treat
896: -- NULL or zero (0) msg_count as
897: -- msg_count = 1.
898: --
899: -- Also, replaced fnd_message.set_encoded
900: -- with set_message.
901: --
902: -- 08-APR-02 jwhite Bug 2310429
903: -- Made changes to gracefully handle ORA
932:
933: IF length(p_msg_data) < 31
934: THEN
935:
936: FND_MESSAGE.SET_NAME ('PA',p_msg_data);
937: l_data := FND_MESSAGE.GET;
938:
939: END IF;
940:
933: IF length(p_msg_data) < 31
934: THEN
935:
936: FND_MESSAGE.SET_NAME ('PA',p_msg_data);
937: l_data := FND_MESSAGE.GET;
938:
939: END IF;
940:
941: