159: l_invalid := TRUE;
160: END IF;
161: IF (l_invalid) THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
164: FND_MESSAGE.set_token('ARG_NAME', 'p_art_ver_tbl');
165: FND_MESSAGE.set_token('ARG_VALUE', 'NULL');
166: FND_MSG_PUB.add;
167: RAISE fnd_api.g_exc_error;
160: END IF;
161: IF (l_invalid) THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
164: FND_MESSAGE.set_token('ARG_NAME', 'p_art_ver_tbl');
165: FND_MESSAGE.set_token('ARG_VALUE', 'NULL');
166: FND_MSG_PUB.add;
167: RAISE fnd_api.g_exc_error;
168: END IF;
161: IF (l_invalid) THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
164: FND_MESSAGE.set_token('ARG_NAME', 'p_art_ver_tbl');
165: FND_MESSAGE.set_token('ARG_VALUE', 'NULL');
166: FND_MSG_PUB.add;
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
167: RAISE fnd_api.g_exc_error;
168: END IF;
169:
170: IF (p_org_id IS NULL) THEN
171: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
172: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
173: FND_MESSAGE.set_token('ARG_VALUE', 'p_org_id');
174: FND_MSG_PUB.add;
175: RAISE fnd_api.g_exc_error;
168: END IF;
169:
170: IF (p_org_id IS NULL) THEN
171: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
172: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
173: FND_MESSAGE.set_token('ARG_VALUE', 'p_org_id');
174: FND_MSG_PUB.add;
175: RAISE fnd_api.g_exc_error;
176: END IF;
169:
170: IF (p_org_id IS NULL) THEN
171: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
172: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
173: FND_MESSAGE.set_token('ARG_VALUE', 'p_org_id');
174: FND_MSG_PUB.add;
175: RAISE fnd_api.g_exc_error;
176: END IF;
177:
277: okc_debug.log('198: l_total_count='||l_total_count||' p_art_ver_tbl.COUNT='||p_art_ver_tbl.COUNT);
278: okc_debug.log('199: This indicates that some article versions belonged to an org other than input org='||p_org_id);
279: END IF;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
283: FND_MESSAGE.set_token('ARG_VALUE', p_org_id);
284: FND_MSG_PUB.add;
285: RAISE fnd_api.g_exc_error;
278: okc_debug.log('199: This indicates that some article versions belonged to an org other than input org='||p_org_id);
279: END IF;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
283: FND_MESSAGE.set_token('ARG_VALUE', p_org_id);
284: FND_MSG_PUB.add;
285: RAISE fnd_api.g_exc_error;
286: END IF;
279: END IF;
280: x_return_status := FND_API.G_RET_STS_ERROR;
281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');
283: FND_MESSAGE.set_token('ARG_VALUE', p_org_id);
284: FND_MSG_PUB.add;
285: RAISE fnd_api.g_exc_error;
286: END IF;
287:
420:
421: ELSE
422: -- status change not recognized
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
425: FND_MESSAGE.set_token('ARG_NAME', 'p_to_status');
426: FND_MESSAGE.set_token('ARG_VALUE', p_to_status);
427: FND_MSG_PUB.add;
428: RAISE FND_API.G_EXC_ERROR;
421: ELSE
422: -- status change not recognized
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
425: FND_MESSAGE.set_token('ARG_NAME', 'p_to_status');
426: FND_MESSAGE.set_token('ARG_VALUE', p_to_status);
427: FND_MSG_PUB.add;
428: RAISE FND_API.G_EXC_ERROR;
429:
422: -- status change not recognized
423: x_return_status := FND_API.G_RET_STS_ERROR;
424: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
425: FND_MESSAGE.set_token('ARG_NAME', 'p_to_status');
426: FND_MESSAGE.set_token('ARG_VALUE', p_to_status);
427: FND_MSG_PUB.add;
428: RAISE FND_API.G_EXC_ERROR;
429:
430: END IF;
444: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
445: px_validation_results(errnum).article_title := l_art_title_tbl(i);
446: px_validation_results(errnum).error_code := G_CHK_INVALID_STS_CHANGE;
447:
448: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_INVALID_STS_CHANGE);
449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_tbl(i)));
451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);
452:
445: px_validation_results(errnum).article_title := l_art_title_tbl(i);
446: px_validation_results(errnum).error_code := G_CHK_INVALID_STS_CHANGE;
447:
448: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_INVALID_STS_CHANGE);
449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_tbl(i)));
451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);
452:
453: px_validation_results(errnum).error_message := FND_MESSAGE.get;
446: px_validation_results(errnum).error_code := G_CHK_INVALID_STS_CHANGE;
447:
448: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_INVALID_STS_CHANGE);
449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_tbl(i)));
451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);
452:
453: px_validation_results(errnum).error_message := FND_MESSAGE.get;
454:
447:
448: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_INVALID_STS_CHANGE);
449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_tbl(i)));
451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);
452:
453: px_validation_results(errnum).error_message := FND_MESSAGE.get;
454:
455: END LOOP;
449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_tbl(i)));
451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);
452:
453: px_validation_results(errnum).error_message := FND_MESSAGE.get;
454:
455: END LOOP;
456:
457: l_status_code_tbl.DELETE;
594: px_validation_results(errnum).article_id := l_art_id_tbl(i);
595: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
596: px_validation_results(errnum).article_title := l_art_title_tbl(i);
597: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
598: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
599: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
600: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
601: px_validation_results(errnum).error_message := fnd_message.get;
602: END LOOP;
595: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
596: px_validation_results(errnum).article_title := l_art_title_tbl(i);
597: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
598: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
599: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
600: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
601: px_validation_results(errnum).error_message := fnd_message.get;
602: END LOOP;
603: END IF;
596: px_validation_results(errnum).article_title := l_art_title_tbl(i);
597: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
598: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
599: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
600: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
601: px_validation_results(errnum).error_message := fnd_message.get;
602: END LOOP;
603: END IF;
604: l_found := FALSE;
597: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
598: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
599: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
600: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
601: px_validation_results(errnum).error_message := fnd_message.get;
602: END LOOP;
603: END IF;
604: l_found := FALSE;
605:
618: px_validation_results(errnum).article_id := l_art_id_tbl(i);
619: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
620: px_validation_results(errnum).article_title := l_art_title_tbl(i);
621: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
622: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
623: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
624: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
625: px_validation_results(errnum).error_message := fnd_message.get;
626: END IF;
619: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
620: px_validation_results(errnum).article_title := l_art_title_tbl(i);
621: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
622: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
623: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
624: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
625: px_validation_results(errnum).error_message := fnd_message.get;
626: END IF;
627:
620: px_validation_results(errnum).article_title := l_art_title_tbl(i);
621: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
622: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
623: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
624: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
625: px_validation_results(errnum).error_message := fnd_message.get;
626: END IF;
627:
628: END LOOP;
621: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
622: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
623: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
624: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
625: px_validation_results(errnum).error_message := fnd_message.get;
626: END IF;
627:
628: END LOOP;
629: END IF;
739: px_validation_results(errnum).article_id := l_art_id_tbl(i);
740: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
741: px_validation_results(errnum).article_title := l_art_title_tbl(i);
742: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
743: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
744: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
745: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
746: px_validation_results(errnum).error_message := fnd_message.get;
747: END LOOP;
740: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
741: px_validation_results(errnum).article_title := l_art_title_tbl(i);
742: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
743: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
744: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
745: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
746: px_validation_results(errnum).error_message := fnd_message.get;
747: END LOOP;
748: END IF;
741: px_validation_results(errnum).article_title := l_art_title_tbl(i);
742: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
743: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
744: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
745: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
746: px_validation_results(errnum).error_message := fnd_message.get;
747: END LOOP;
748: END IF;
749: l_found := FALSE;
742: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
743: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
744: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
745: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
746: px_validation_results(errnum).error_message := fnd_message.get;
747: END LOOP;
748: END IF;
749: l_found := FALSE;
750:
761: px_validation_results(errnum).article_id := l_art_id_tbl(i);
762: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
763: px_validation_results(errnum).article_title := l_art_title_tbl(i);
764: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
765: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
766: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
767: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
768: px_validation_results(errnum).error_message := fnd_message.get;
769: END LOOP;
762: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
763: px_validation_results(errnum).article_title := l_art_title_tbl(i);
764: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
765: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
766: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
767: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
768: px_validation_results(errnum).error_message := fnd_message.get;
769: END LOOP;
770: END IF;
763: px_validation_results(errnum).article_title := l_art_title_tbl(i);
764: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
765: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
766: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
767: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
768: px_validation_results(errnum).error_message := fnd_message.get;
769: END LOOP;
770: END IF;
771:
764: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
765: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
766: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
767: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
768: px_validation_results(errnum).error_message := fnd_message.get;
769: END LOOP;
770: END IF;
771:
772: l_art_id_tbl.DELETE;
928:
929: ELSE
930: -- p_type not recognized
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
933: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
934: FND_MESSAGE.set_token('ARG_VALUE', p_type);
935: FND_MSG_PUB.add;
936: RAISE FND_API.G_EXC_ERROR;
929: ELSE
930: -- p_type not recognized
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
933: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
934: FND_MESSAGE.set_token('ARG_VALUE', p_type);
935: FND_MSG_PUB.add;
936: RAISE FND_API.G_EXC_ERROR;
937:
930: -- p_type not recognized
931: x_return_status := FND_API.G_RET_STS_ERROR;
932: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
933: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
934: FND_MESSAGE.set_token('ARG_VALUE', p_type);
935: FND_MSG_PUB.add;
936: RAISE FND_API.G_EXC_ERROR;
937:
938: END IF;