eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_ART_BLK_PVT dependencies on FND_MESSAGE

Line 163: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

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;

Line 164: FND_MESSAGE.set_token('ARG_NAME', 'p_art_ver_tbl');

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;

Line 165: FND_MESSAGE.set_token('ARG_VALUE', 'NULL');

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:

Line 171: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

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;

Line 172: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');

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;

Line 173: FND_MESSAGE.set_token('ARG_VALUE', 'p_org_id');

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:

Line 281: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

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;

Line 282: FND_MESSAGE.set_token('ARG_NAME', 'p_org_id');

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;

Line 283: FND_MESSAGE.set_token('ARG_VALUE', 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;
287:

Line 424: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

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;

Line 425: FND_MESSAGE.set_token('ARG_NAME', 'p_to_status');

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:

Line 426: FND_MESSAGE.set_token('ARG_VALUE', p_to_status);

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;

Line 448: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_INVALID_STS_CHANGE);

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:

Line 449: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_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:
453: px_validation_results(errnum).error_message := FND_MESSAGE.get;

Line 450: FND_MESSAGE.set_token('FROM_STATUS', get_status_meaning(l_ver_from_status_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;
454:

Line 451: FND_MESSAGE.set_token('TO_STATUS', l_to_status_meaning);

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;

Line 453: px_validation_results(errnum).error_message := FND_MESSAGE.get;

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;

Line 597: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);

593: px_validation_results(errnum).article_id := l_art_id_tbl(i);
594: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
595: px_validation_results(errnum).article_title := l_art_title_tbl(i);
596: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
597: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
598: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
599: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
600: px_validation_results(errnum).error_message := fnd_message.get;
601: END LOOP;

Line 598: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));

594: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
595: px_validation_results(errnum).article_title := l_art_title_tbl(i);
596: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
597: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
598: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
599: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
600: px_validation_results(errnum).error_message := fnd_message.get;
601: END LOOP;
602: END IF;

Line 599: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));

595: px_validation_results(errnum).article_title := l_art_title_tbl(i);
596: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
597: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
598: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
599: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
600: px_validation_results(errnum).error_message := fnd_message.get;
601: END LOOP;
602: END IF;
603: l_found := FALSE;

Line 600: px_validation_results(errnum).error_message := fnd_message.get;

596: px_validation_results(errnum).error_code := G_CHK_ART_INACTIVE_VARIABLE;
597: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INACTIVE_VARIABLE);
598: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
599: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
600: px_validation_results(errnum).error_message := fnd_message.get;
601: END LOOP;
602: END IF;
603: l_found := FALSE;
604:

Line 621: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);

617: px_validation_results(errnum).article_id := l_art_id_tbl(i);
618: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
619: px_validation_results(errnum).article_title := l_art_title_tbl(i);
620: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
621: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
622: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
623: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
624: px_validation_results(errnum).error_message := fnd_message.get;
625: END IF;

Line 622: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));

618: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
619: px_validation_results(errnum).article_title := l_art_title_tbl(i);
620: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
621: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
622: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
623: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
624: px_validation_results(errnum).error_message := fnd_message.get;
625: END IF;
626:

Line 623: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));

619: px_validation_results(errnum).article_title := l_art_title_tbl(i);
620: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
621: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
622: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
623: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
624: px_validation_results(errnum).error_message := fnd_message.get;
625: END IF;
626:
627: END LOOP;

Line 624: px_validation_results(errnum).error_message := fnd_message.get;

620: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_VALUESET;
621: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_VALUESET);
622: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
623: FND_MESSAGE.set_token('VARIABLE_NAME', l_var_name_tbl(i));
624: px_validation_results(errnum).error_message := fnd_message.get;
625: END IF;
626:
627: END LOOP;
628: END IF;

Line 742: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);

738: px_validation_results(errnum).article_id := l_art_id_tbl(i);
739: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
740: px_validation_results(errnum).article_title := l_art_title_tbl(i);
741: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
742: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
743: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
744: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
745: px_validation_results(errnum).error_message := fnd_message.get;
746: END LOOP;

Line 743: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));

739: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
740: px_validation_results(errnum).article_title := l_art_title_tbl(i);
741: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
742: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
743: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
744: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
745: px_validation_results(errnum).error_message := fnd_message.get;
746: END LOOP;
747: END IF;

Line 744: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));

740: px_validation_results(errnum).article_title := l_art_title_tbl(i);
741: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
742: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
743: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
744: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
745: px_validation_results(errnum).error_message := fnd_message.get;
746: END LOOP;
747: END IF;
748: l_found := FALSE;

Line 745: px_validation_results(errnum).error_message := fnd_message.get;

741: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_TYPE;
742: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_TYPE);
743: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
744: FND_MESSAGE.set_token('ARTICLE_TYPE', l_art_typ_tbl(i));
745: px_validation_results(errnum).error_message := fnd_message.get;
746: END LOOP;
747: END IF;
748: l_found := FALSE;
749:

Line 764: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);

760: px_validation_results(errnum).article_id := l_art_id_tbl(i);
761: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
762: px_validation_results(errnum).article_title := l_art_title_tbl(i);
763: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
764: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
765: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
766: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
767: px_validation_results(errnum).error_message := fnd_message.get;
768: END LOOP;

Line 765: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));

761: px_validation_results(errnum).article_version_id := l_art_ver_id_tbl(i);
762: px_validation_results(errnum).article_title := l_art_title_tbl(i);
763: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
764: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
765: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
766: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
767: px_validation_results(errnum).error_message := fnd_message.get;
768: END LOOP;
769: END IF;

Line 766: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));

762: px_validation_results(errnum).article_title := l_art_title_tbl(i);
763: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
764: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
765: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
766: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
767: px_validation_results(errnum).error_message := fnd_message.get;
768: END LOOP;
769: END IF;
770:

Line 767: px_validation_results(errnum).error_message := fnd_message.get;

763: px_validation_results(errnum).error_code := G_CHK_ART_INVALID_SECTION;
764: FND_MESSAGE.set_name(G_APP_NAME, G_MSG_ART_INVALID_SECTION);
765: FND_MESSAGE.set_token('ARTICLE_TITLE', l_art_title_tbl(i));
766: FND_MESSAGE.set_token('DEFAULT_SECTION', l_def_sec_tbl(i));
767: px_validation_results(errnum).error_message := fnd_message.get;
768: END LOOP;
769: END IF;
770:
771: l_art_id_tbl.DELETE;

Line 931: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);

927:
928: ELSE
929: -- p_type not recognized
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
932: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
933: FND_MESSAGE.set_token('ARG_VALUE', p_type);
934: FND_MSG_PUB.add;
935: RAISE FND_API.G_EXC_ERROR;

Line 932: FND_MESSAGE.set_token('ARG_NAME', 'p_type');

928: ELSE
929: -- p_type not recognized
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
932: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
933: FND_MESSAGE.set_token('ARG_VALUE', p_type);
934: FND_MSG_PUB.add;
935: RAISE FND_API.G_EXC_ERROR;
936:

Line 933: FND_MESSAGE.set_token('ARG_VALUE', p_type);

929: -- p_type not recognized
930: x_return_status := FND_API.G_RET_STS_ERROR;
931: FND_MESSAGE.set_name(G_APP_NAME, G_OKC_MSG_INVALID_ARGUMENT);
932: FND_MESSAGE.set_token('ARG_NAME', 'p_type');
933: FND_MESSAGE.set_token('ARG_VALUE', p_type);
934: FND_MSG_PUB.add;
935: RAISE FND_API.G_EXC_ERROR;
936:
937: END IF;