[Home] [Help]
748:
749: IF (p_tabv_rec.currency_conversion_type IS NOT NULL) AND
750: (p_tabv_rec.currency_conversion_type <> OKC_API.G_MISS_CHAR)AND
751: (UPPER(p_tabv_rec.currency_conversion_type) <> 'USER') THEN
752: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_CURRENCY_CON_TYPE
753: (p_tabv_rec.currency_conversion_type);
754: IF (l_dummy = OKC_API.G_FALSE) THEN
755: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
756: p_msg_name => g_invalid_value,
803: RAISE G_EXCEPTION_HALT_VALIDATION;
804:
805: END IF;
806:
807: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
808: (p_lookup_type => 'CR_DR',
809: p_lookup_code => p_tabv_rec.cr_dr_flag,
810: p_app_id => l_app_id,
811: p_view_app_id => l_view_app_id);
896: Commented as part of SLA Uptake Bug#5707866 by zrehman on 7-Feb-2006 -- end */
897: /* Commented by Kanti. We want a not null validation but not the CCID validation from
898: GL Code combination table for the time being.
899:
900: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_GL_CCID(p_tabv_rec.code_combination_id);
901:
902: IF (l_dummy = okc_api.g_false) THEN
903: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
904: p_msg_name => g_invalid_value,
946: x_return_status := OKC_API.G_RET_STS_ERROR;
947: RAISE G_EXCEPTION_HALT_VALIDATION;
948: END IF;
949:
950: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_CURRENCY_CODE (p_tabv_rec.currency_code);
951:
952: IF (l_dummy = okl_api.g_false) THEN
953: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
954: p_msg_name => g_invalid_value,
995: x_return_status := OKC_API.G_RET_STS_ERROR;
996: RAISE G_EXCEPTION_HALT_VALIDATION;
997: END IF;
998:
999: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1000: (p_lookup_type => 'OKL_ACCOUNTING_LINE_TYPE',
1001: p_lookup_code => p_tabv_rec.ae_line_type);
1002:
1003: IF l_dummy = okl_api.g_false THEN
1112: x_return_status := OKC_API.G_RET_STS_ERROR;
1113: RAISE G_EXCEPTION_HALT_VALIDATION;
1114: END IF;
1115:
1116: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_SOURCE_ID_TABLE
1117: (p_source_id => p_tabv_rec.source_id,
1118: p_source_table => p_tabv_rec.source_table);
1119:
1120: IF (l_dummy = OKC_API.G_FALSE) THEN
1226:
1227: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1228:
1229: IF (p_tabv_rec.posted_yn IS NOT NULL) AND (p_tabv_rec.posted_yn <> OKC_API.G_MISS_CHAR) THEN
1230: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1231: (p_lookup_type => 'OKL_ACC_DIST_POSTED',
1232: p_lookup_code => p_tabv_rec.posted_yn);
1233:
1234: IF (l_dummy = OKC_API.G_FALSE) THEN
1288:
1289: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1290:
1291: IF (p_tabv_rec.GL_REVERSAL_FLAG IS NOT NULL) AND (p_tabv_rec.GL_REVERSAL_FLAG <> OKC_API.G_MISS_CHAR) THEN
1292: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1293: (p_lookup_type => 'YES_NO',
1294: p_lookup_code => p_tabv_rec.gl_reversal_flag,
1295: p_app_id => l_app_id,
1296: p_view_app_id => l_view_app_id);
1352:
1353: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1354:
1355: IF (p_tabv_rec.POST_TO_GL IS NOT NULL) AND (p_tabv_rec.POST_TO_GL <> OKC_API.G_MISS_CHAR) THEN
1356: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1357: (p_lookup_type => 'YES_NO',
1358: p_lookup_code => p_tabv_rec.POST_TO_GL,
1359: p_app_id => l_app_id,
1360: p_view_app_id => l_view_app_id);
1468: -- check for data before processing
1469: IF (p_tabv_rec.UPGRADE_STATUS_FLAG IS NOT NULL) AND
1470: (p_tabv_rec.UPGRADE_STATUS_FLAG <> Okc_Api.G_MISS_CHAR) THEN
1471: -- check in fnd_lookups for validity
1472: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE
1473: (p_lookup_type => 'OKL_YES_NO',
1474: p_lookup_code => p_tabv_rec.UPGRADE_STATUS_FLAG);
1475:
1476: IF (l_dummy = OKL_API.G_FALSE) THEN
2333: x_tabv_rec.ORG_ID := MO_GLOBAL.GET_CURRENT_ORG_ID();
2334:
2335: -- MG uptake, if sob is not sent in take primary ledger.
2336: if x_tabv_rec.set_of_books_id is null then
2337: x_tabv_rec.set_of_books_id := okl_accounting_util.get_set_of_books_id;
2338: end if;
2339:
2340: -- 05-10-01 - spalod - end - get and set org id and set of book id, concurrent program fields
2341: