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