802: --
803: -- Setup the successful message
804: --
805: x_return_status := OKC_API.G_RET_STS_SUCCESS;
806: FND_MESSAGE.SET_NAME(application => g_app_name,
807: name => g_validate_dbname_success);
808:
809: x_msg_count := 0;
810: x_msg_data := null;
815: OPEN wf (p_pdfv_rec.wf_name, p_pdfv_rec.wf_process_name);
816: FETCH wf INTO l_run_flag;
817: IF wf%NOTFOUND THEN
818: CLOSE wf;
819: FND_MESSAGE.SET_NAME(application => g_app_name,
820: name => g_validate_dbname_notfound);
821: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
822: value => g_validate_dbname_wf_pair,
823: translate => TRUE);
817: IF wf%NOTFOUND THEN
818: CLOSE wf;
819: FND_MESSAGE.SET_NAME(application => g_app_name,
820: name => g_validate_dbname_notfound);
821: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
822: value => g_validate_dbname_wf_pair,
823: translate => TRUE);
824: x_return_status := OKC_API.G_RET_STS_ERROR;
825: ELSE
825: ELSE
826: CLOSE wf;
827: IF l_run_flag <> 'Y' THEN
828: x_return_status := OKC_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME(application => g_app_name,
830: name => g_validate_dbname_notrun);
831: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
832: value => g_validate_dbname_wf_pair,
833: translate => TRUE);
827: IF l_run_flag <> 'Y' THEN
828: x_return_status := OKC_API.G_RET_STS_ERROR;
829: FND_MESSAGE.SET_NAME(application => g_app_name,
830: name => g_validate_dbname_notrun);
831: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
832: value => g_validate_dbname_wf_pair,
833: translate => TRUE);
834: END IF;
835: END IF;
838: OPEN pp(p_pdfv_rec.package_name, p_pdfv_rec.procedure_name);
839: FETCH pp INTO l_pack_count;
840: IF pp%NOTFOUND THEN
841: x_return_status := OKC_API.G_RET_STS_ERROR;
842: FND_MESSAGE.SET_NAME(application => g_app_name,
843: name => g_validate_dbname_notfound);
844: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
845: value => g_validate_dbname_pp_pair,
846: translate => TRUE);
840: IF pp%NOTFOUND THEN
841: x_return_status := OKC_API.G_RET_STS_ERROR;
842: FND_MESSAGE.SET_NAME(application => g_app_name,
843: name => g_validate_dbname_notfound);
844: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',
845: value => g_validate_dbname_pp_pair,
846: translate => TRUE);
847: END IF;
848:
857: ELSIF pp%ISOPEN THEN
858: CLOSE pp;
859: END IF;
860:
861: FND_MESSAGE.SET_NAME(application => g_app_name,
862: name => g_unexpected_error);
863: FND_MESSAGE.SET_TOKEN(token => g_sqlcode_token,
864: value => sqlcode);
865: FND_MESSAGE.SET_TOKEN(token => g_sqlerrm_token,
859: END IF;
860:
861: FND_MESSAGE.SET_NAME(application => g_app_name,
862: name => g_unexpected_error);
863: FND_MESSAGE.SET_TOKEN(token => g_sqlcode_token,
864: value => sqlcode);
865: FND_MESSAGE.SET_TOKEN(token => g_sqlerrm_token,
866: value => sqlerrm);
867: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
861: FND_MESSAGE.SET_NAME(application => g_app_name,
862: name => g_unexpected_error);
863: FND_MESSAGE.SET_TOKEN(token => g_sqlcode_token,
864: value => sqlcode);
865: FND_MESSAGE.SET_TOKEN(token => g_sqlerrm_token,
866: value => sqlerrm);
867: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
868:
869: END validate_dbnames;