DBA Data[Home] [Help]

APPS.OKL_VP_SYNC_CR_PVT dependencies on OKC_API

Line 1212: lv_catv_rec.sfwt_flag := OKC_API.G_TRUE;

1208: IF(creq_articles_rec.cat_type = 'NSD')THEN
1209: lv_catv_rec.cle_id := null;
1210: lv_catv_rec.dnz_chr_id := p_orig_chr_id;
1211: lv_catv_rec.object_version_number := 1.0;
1212: lv_catv_rec.sfwt_flag := OKC_API.G_TRUE;
1213: lv_catv_rec.comments := NULL;
1214: lv_catv_rec.fulltext_yn := NULL;
1215: lv_catv_rec.variation_description := NULL;
1216: lv_catv_rec.sav_sae_id := NULL;

Line 1232: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1228: l_module,
1229: 'okl_okc_migration_a_pvt.insert_row returned with status '||x_return_status
1230: );
1231: END IF;
1232: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;

Line 1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1229: 'okl_okc_migration_a_pvt.insert_row returned with status '||x_return_status
1230: );
1231: END IF;
1232: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237: -- now copy the text of the Non Standard Article into the new record

Line 1234: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1230: );
1231: END IF;
1232: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237: -- now copy the text of the Non Standard Article into the new record
1238: x_return_status := okc_util.copy_articles_text(p_id => x_catv_rec.id

Line 1235: RAISE OKC_API.G_EXCEPTION_ERROR;

1231: END IF;
1232: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237: -- now copy the text of the Non Standard Article into the new record
1238: x_return_status := okc_util.copy_articles_text(p_id => x_catv_rec.id
1239: ,lang => USERENV('LANG')

Line 1241: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1237: -- now copy the text of the Non Standard Article into the new record
1238: x_return_status := okc_util.copy_articles_text(p_id => x_catv_rec.id
1239: ,lang => USERENV('LANG')
1240: ,p_text => creq_articles_rec.text);
1241: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1242: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1244: RAISE OKC_API.G_EXCEPTION_ERROR;
1245: END IF;

Line 1242: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1238: x_return_status := okc_util.copy_articles_text(p_id => x_catv_rec.id
1239: ,lang => USERENV('LANG')
1240: ,p_text => creq_articles_rec.text);
1241: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1242: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1244: RAISE OKC_API.G_EXCEPTION_ERROR;
1245: END IF;
1246:

Line 1243: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1239: ,lang => USERENV('LANG')
1240: ,p_text => creq_articles_rec.text);
1241: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1242: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1244: RAISE OKC_API.G_EXCEPTION_ERROR;
1245: END IF;
1246:
1247: ELSIF(creq_articles_rec.cat_type = 'STA')THEN

Line 1244: RAISE OKC_API.G_EXCEPTION_ERROR;

1240: ,p_text => creq_articles_rec.text);
1241: IF(x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1242: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1243: ELSIF(x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1244: RAISE OKC_API.G_EXCEPTION_ERROR;
1245: END IF;
1246:
1247: ELSIF(creq_articles_rec.cat_type = 'STA')THEN
1248: lv_catv_rec.sav_sae_id := creq_articles_rec.sav_sae_id;