DBA Data[Home] [Help]

APPS.OKC_PROCESS_PVT dependencies on FND_MESSAGE

Line 806: FND_MESSAGE.SET_NAME(application => g_app_name,

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;

Line 819: FND_MESSAGE.SET_NAME(application => g_app_name,

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);

Line 821: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',

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

Line 829: FND_MESSAGE.SET_NAME(application => g_app_name,

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);

Line 831: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',

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;

Line 842: FND_MESSAGE.SET_NAME(application => g_app_name,

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);

Line 844: FND_MESSAGE.SET_TOKEN(token => 'DATANAME',

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:

Line 861: FND_MESSAGE.SET_NAME(application => g_app_name,

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,

Line 863: FND_MESSAGE.SET_TOKEN(token => g_sqlcode_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;

Line 865: FND_MESSAGE.SET_TOKEN(token => g_sqlerrm_token,

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;