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_RULE_PVT dependencies on OKC_API

Line 50: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

46: x_msg_data => x_msg_data,
47: p_cvmv_rec => l_cvmv_rec,
48: x_cvmv_rec => x_out_rec);
49:
50: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
51: RAISE G_EXCEPTION_HALT_VALIDATION;
52: END IF;
53:
54: EXCEPTION

Line 63: OKC_API.SET_MESSAGE(

59: WHEN OTHERS THEN
60:
61:
62: -- store SQL error message on message stack
63: OKC_API.SET_MESSAGE(
64: p_app_name => g_app_name,
65: p_msg_name => g_unexpected_error,
66: p_token1 => g_sqlcode_token,
67: p_token1_value => sqlcode,

Line 71: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

67: p_token1_value => sqlcode,
68: p_token2 => g_sqlerrm_token,
69: p_token2_value => sqlerrm);
70: -- notify caller of an error as UNEXPETED error
71: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
72: END update_minor_version;
73:
74: -- Start of comments
75: --

Line 142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

138: p_euro_conv_yn IN VARCHAR2)
139: IS
140:
141: l_rulv_rec okc_rule_pub.rulv_rec_type;
142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
143: l_euro_rate NUMBER;
144: l_rate NUMBER;
145: l_meaning VARCHAR2(80) ;
146: lx_return_status VARCHAR2(1) ;

Line 188: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

184: ,x_CONVERSION_RATE => l_rate
185: ,x_EURO_RATE => l_euro_rate
186: ,x_return_status => l_return_status);
187:
188: IF l_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
189: x_return_status := l_return_status;
190: RETURN;
191: END IF;
192:

Line 212: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

208: p_rulv_rec => l_rulv_rec,
209: x_rulv_rec => x_rulv_rec);
210:
211: -- Update minor version
212: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
213: update_minor_version(p_rulv_rec.dnz_chr_id);
214: END IF;
215:
216: EXCEPTION

Line 219: x_return_status := OKC_API.g_ret_sts_error;

215:
216: EXCEPTION
217: WHEN okc_currency_api.no_rate then
218:
219: x_return_status := OKC_API.g_ret_sts_error;
220: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
221: WHEN okc_currency_api.invalid_currency then
222:
223: x_return_status := OKC_API.g_ret_sts_error;

Line 220: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');

216: EXCEPTION
217: WHEN okc_currency_api.no_rate then
218:
219: x_return_status := OKC_API.g_ret_sts_error;
220: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
221: WHEN okc_currency_api.invalid_currency then
222:
223: x_return_status := OKC_API.g_ret_sts_error;
224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');

Line 223: x_return_status := OKC_API.g_ret_sts_error;

219: x_return_status := OKC_API.g_ret_sts_error;
220: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
221: WHEN okc_currency_api.invalid_currency then
222:
223: x_return_status := OKC_API.g_ret_sts_error;
224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
225:
226: WHEN G_NO_RULE_ALLOWED then
227: x_return_status := OKC_API.g_ret_sts_error;

Line 224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');

220: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_CONVERSION_RATE');
221: WHEN okc_currency_api.invalid_currency then
222:
223: x_return_status := OKC_API.g_ret_sts_error;
224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
225:
226: WHEN G_NO_RULE_ALLOWED then
227: x_return_status := OKC_API.g_ret_sts_error;
228: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);

Line 227: x_return_status := OKC_API.g_ret_sts_error;

223: x_return_status := OKC_API.g_ret_sts_error;
224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
225:
226: WHEN G_NO_RULE_ALLOWED then
227: x_return_status := OKC_API.g_ret_sts_error;
228: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
229:
230: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
231: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 228: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);

224: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_INVALID_CURRENCY');
225:
226: WHEN G_NO_RULE_ALLOWED then
227: x_return_status := OKC_API.g_ret_sts_error;
228: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
229:
230: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
231: WHEN G_EXCEPTION_HALT_VALIDATION THEN
232: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 232: x_return_status := OKC_API.G_RET_STS_ERROR;

228: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
229:
230: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
231: WHEN G_EXCEPTION_HALT_VALIDATION THEN
232: x_return_status := OKC_API.G_RET_STS_ERROR;
233:
234: WHEN OTHERS THEN
235:
236:

Line 241: OKC_API.SET_MESSAGE(

237: IF l_chr_csr%ISOPEN THEN
238: CLOSE l_chr_csr;
239: END IF;
240: -- store SQL error message on message stack
241: OKC_API.SET_MESSAGE(
242: p_app_name => G_APP_NAME,
243: p_msg_name => G_UNEXPECTED_ERROR,
244: p_token1 => G_SQLCODE_TOKEN,
245: p_token1_value => SQLCODE,

Line 249: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

245: p_token1_value => SQLCODE,
246: p_token2 => G_SQLERRM_TOKEN,
247: p_token2_value => SQLERRM);
248: -- notify caller of an error as UNEXPETED error
249: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
250: END create_rule;
251:
252: PROCEDURE update_rule(
253: p_api_version IN NUMBER,

Line 289: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

285: p_rulv_rec => p_rulv_rec,
286: x_rulv_rec => x_rulv_rec);
287:
288: -- Update minor version
289: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
290: update_minor_version(p_rulv_rec.dnz_chr_id);
291: END IF;
292:
293:

Line 298: x_return_status := OKC_API.g_ret_sts_error;

294:
295:
296: EXCEPTION
297: WHEN G_NO_RULE_ALLOWED then
298: x_return_status := OKC_API.g_ret_sts_error;
299: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
300:
301: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
302: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 299: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);

295:
296: EXCEPTION
297: WHEN G_NO_RULE_ALLOWED then
298: x_return_status := OKC_API.g_ret_sts_error;
299: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
300:
301: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
302: WHEN G_EXCEPTION_HALT_VALIDATION THEN
303: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 303: x_return_status := OKC_API.G_RET_STS_ERROR;

299: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RUL_ALLOWED','VALUE1',l_meaning);
300:
301: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
302: WHEN G_EXCEPTION_HALT_VALIDATION THEN
303: x_return_status := OKC_API.G_RET_STS_ERROR;
304:
305: WHEN OTHERS THEN
306:
307:

Line 309: OKC_API.SET_MESSAGE(

305: WHEN OTHERS THEN
306:
307:
308: -- store SQL error message on message stack
309: OKC_API.SET_MESSAGE(
310: p_app_name => G_APP_NAME,
311: p_msg_name => G_UNEXPECTED_ERROR,
312: p_token1 => G_SQLCODE_TOKEN,
313: p_token1_value => SQLCODE,

Line 317: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

313: p_token1_value => SQLCODE,
314: p_token2 => G_SQLERRM_TOKEN,
315: p_token2_value => SQLERRM);
316: -- notify caller of an error as UNEXPETED error
317: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
318: END update_rule;
319:
320: PROCEDURE delete_rule(
321: p_api_version IN NUMBER,

Line 386: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

382: x_msg_count => x_msg_count,
383: x_msg_data => x_msg_data,
384: p_ctiv_tbl => l_ctiv_tbl);
385:
386: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
387: -- stop delete process
388: RETURN;
389: END IF;
390: END IF;

Line 411: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

407: x_msg_count => x_msg_count,
408: x_msg_data => x_msg_data,
409: p_rilv_tbl => l_rilv_tbl);
410:
411: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
412: -- stop delete process
413: RETURN;
414: END IF;
415: END IF;

Line 447: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

443: x_return_status => x_return_status,
444: x_msg_count => x_msg_count,
445: x_msg_data => x_msg_data,
446: p_tve_id => l_col_vals(i).col_value);
447: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
448: -- stop delete process
449: RETURN;
450: END IF;
451: end if;

Line 468: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

464: x_msg_data => x_msg_data,
465: p_rulv_rec => p_rulv_rec);
466:
467: -- Update minor version
468: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
469: update_minor_version(p_rulv_rec.dnz_chr_id);
470: END IF;
471:
472: EXCEPTION

Line 476: OKC_API.SET_MESSAGE(

472: EXCEPTION
473: WHEN G_EXCEPTION_CANNOT_DELETE THEN
474:
475: -- store SQL error message on message stack
476: OKC_API.SET_MESSAGE(
477: p_app_name => G_APP_NAME,
478: p_msg_name => G_CANNOT_DELETE_MASTER);
479: -- notify caller of an error
480: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 480: x_return_status := OKC_API.G_RET_STS_ERROR;

476: OKC_API.SET_MESSAGE(
477: p_app_name => G_APP_NAME,
478: p_msg_name => G_CANNOT_DELETE_MASTER);
479: -- notify caller of an error
480: x_return_status := OKC_API.G_RET_STS_ERROR;
481:
482: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
483: WHEN G_EXCEPTION_HALT_VALIDATION THEN
484: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 484: x_return_status := OKC_API.G_RET_STS_ERROR;

480: x_return_status := OKC_API.G_RET_STS_ERROR;
481:
482: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
483: WHEN G_EXCEPTION_HALT_VALIDATION THEN
484: x_return_status := OKC_API.G_RET_STS_ERROR;
485:
486: WHEN OTHERS THEN
487:
488: -- store SQL error message on message stack

Line 489: OKC_API.SET_MESSAGE(

485:
486: WHEN OTHERS THEN
487:
488: -- store SQL error message on message stack
489: OKC_API.SET_MESSAGE(
490: p_app_name => G_APP_NAME,
491: p_msg_name => G_UNEXPECTED_ERROR,
492: p_token1 => G_SQLCODE_TOKEN,
493: p_token1_value => SQLCODE,

Line 497: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

493: p_token1_value => SQLCODE,
494: p_token2 => G_SQLERRM_TOKEN,
495: p_token2_value => SQLERRM);
496: -- notify caller of an error as UNEXPETED error
497: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
498: -- verify that cursor was closed
499: IF l_ctiv_csr%ISOPEN THEN
500: CLOSE l_ctiv_csr;
501: END IF;

Line 591: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

587: p_rgpv_rec => p_rgpv_rec,
588: x_rgpv_rec => x_rgpv_rec);
589:
590: -- Update minor version
591: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
592: update_minor_version(p_rgpv_rec.dnz_chr_id);
593: END IF;
594:
595:

Line 598: x_return_status := OKC_API.g_ret_sts_error;

594:
595:
596: EXCEPTION
597: WHEN G_NO_RULE_ALLOWED then
598: x_return_status := OKC_API.g_ret_sts_error;
599: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
600:
601: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
602: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 599: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');

595:
596: EXCEPTION
597: WHEN G_NO_RULE_ALLOWED then
598: x_return_status := OKC_API.g_ret_sts_error;
599: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
600:
601: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
602: WHEN G_EXCEPTION_HALT_VALIDATION THEN
603: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 603: x_return_status := OKC_API.G_RET_STS_ERROR;

599: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
600:
601: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
602: WHEN G_EXCEPTION_HALT_VALIDATION THEN
603: x_return_status := OKC_API.G_RET_STS_ERROR;
604:
605: WHEN OTHERS THEN
606: -- store SQL error message on message stack
607: OKC_API.SET_MESSAGE(

Line 607: OKC_API.SET_MESSAGE(

603: x_return_status := OKC_API.G_RET_STS_ERROR;
604:
605: WHEN OTHERS THEN
606: -- store SQL error message on message stack
607: OKC_API.SET_MESSAGE(
608: p_app_name => G_APP_NAME,
609: p_msg_name => G_UNEXPECTED_ERROR,
610: p_token1 => G_SQLCODE_TOKEN,
611: p_token1_value => SQLCODE,

Line 615: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

611: p_token1_value => SQLCODE,
612: p_token2 => G_SQLERRM_TOKEN,
613: p_token2_value => SQLERRM);
614: -- notify caller of an error as UNEXPETED error
615: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
616: END create_rule_group;
617:
618: PROCEDURE update_rule_group(
619: p_api_version IN NUMBER,

Line 657: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

653: p_rgpv_rec => p_rgpv_rec,
654: x_rgpv_rec => x_rgpv_rec);
655:
656: -- Update minor version
657: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
658: update_minor_version(p_rgpv_rec.dnz_chr_id);
659: END IF;
660:
661:

Line 666: x_return_status := OKC_API.g_ret_sts_error;

662:
663:
664: EXCEPTION
665: WHEN G_NO_RULE_ALLOWED then
666: x_return_status := OKC_API.g_ret_sts_error;
667: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
668:
669: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
670: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 667: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');

663:
664: EXCEPTION
665: WHEN G_NO_RULE_ALLOWED then
666: x_return_status := OKC_API.g_ret_sts_error;
667: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
668:
669: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
670: WHEN G_EXCEPTION_HALT_VALIDATION THEN
671: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 671: x_return_status := OKC_API.G_RET_STS_ERROR;

667: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_NO_RGP_ALLOWED');
668:
669: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
670: WHEN G_EXCEPTION_HALT_VALIDATION THEN
671: x_return_status := OKC_API.G_RET_STS_ERROR;
672:
673: WHEN OTHERS THEN
674:
675:

Line 677: OKC_API.SET_MESSAGE(

673: WHEN OTHERS THEN
674:
675:
676: -- store SQL error message on message stack
677: OKC_API.SET_MESSAGE(
678: p_app_name => G_APP_NAME,
679: p_msg_name => G_UNEXPECTED_ERROR,
680: p_token1 => G_SQLCODE_TOKEN,
681: p_token1_value => SQLCODE,

Line 685: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

681: p_token1_value => SQLCODE,
682: p_token2 => G_SQLERRM_TOKEN,
683: p_token2_value => SQLERRM);
684: -- notify caller of an error as UNEXPETED error
685: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
686: END update_rule_group;
687:
688: PROCEDURE delete_rule_group(
689: p_api_version IN NUMBER,

Line 755: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

751: x_msg_count => x_msg_count,
752: x_msg_data => x_msg_data,
753: p_rmpv_tbl => l_rmpv_tbl);
754:
755: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
756: -- stop delete process
757: RETURN;
758: END IF;
759: END IF;

Line 780: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

776: x_msg_count => x_msg_count,
777: x_msg_data => x_msg_data,
778: p_rulv_tbl => l_rulv_tbl);
779:
780: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
781: -- stop delete process
782: RETURN;
783: END IF;
784: END IF;

Line 795: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

791: x_msg_data => x_msg_data,
792: p_rgpv_rec => p_rgpv_rec);
793:
794: -- Update minor version
795: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
796: update_minor_version(p_rgpv_rec.dnz_chr_id);
797: END IF;
798:
799:

Line 807: OKC_API.SET_MESSAGE(

803: WHEN G_EXCEPTION_CANNOT_DELETE THEN
804:
805:
806: -- store SQL error message on message stack
807: OKC_API.SET_MESSAGE(
808: p_app_name => G_APP_NAME,
809: p_msg_name => G_CANNOT_DELETE_MASTER);
810: -- notify caller of an error
811: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 811: x_return_status := OKC_API.G_RET_STS_ERROR;

807: OKC_API.SET_MESSAGE(
808: p_app_name => G_APP_NAME,
809: p_msg_name => G_CANNOT_DELETE_MASTER);
810: -- notify caller of an error
811: x_return_status := OKC_API.G_RET_STS_ERROR;
812:
813: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
814: WHEN G_EXCEPTION_HALT_VALIDATION THEN
815: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 815: x_return_status := OKC_API.G_RET_STS_ERROR;

811: x_return_status := OKC_API.G_RET_STS_ERROR;
812:
813: --Bug 4149131/4190812 Added logic to handle G_EXCEPTION_HALT_VALIDATION
814: WHEN G_EXCEPTION_HALT_VALIDATION THEN
815: x_return_status := OKC_API.G_RET_STS_ERROR;
816:
817: WHEN OTHERS THEN
818:
819:

Line 821: OKC_API.SET_MESSAGE(

817: WHEN OTHERS THEN
818:
819:
820: -- store SQL error message on message stack
821: OKC_API.SET_MESSAGE(
822: p_app_name => G_APP_NAME,
823: p_msg_name => G_UNEXPECTED_ERROR,
824: p_token1 => G_SQLCODE_TOKEN,
825: p_token1_value => SQLCODE,

Line 829: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

825: p_token1_value => SQLCODE,
826: p_token2 => G_SQLERRM_TOKEN,
827: p_token2_value => SQLERRM);
828: -- notify caller of an error as UNEXPETED error
829: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
830: -- verify that cursor was closed
831: IF l_rgpv_csr%ISOPEN THEN
832: CLOSE l_rgpv_csr;
833: END IF;

Line 924: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

920: p_rmpv_rec => p_rmpv_rec,
921: x_rmpv_rec => x_rmpv_rec);
922:
923: -- Update minor version
924: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
925: update_minor_version(p_rmpv_rec.dnz_chr_id);
926: END IF;
927:
928:

Line 936: OKC_API.SET_MESSAGE(

932: WHEN OTHERS THEN
933:
934:
935: -- store SQL error message on message stack
936: OKC_API.SET_MESSAGE(
937: p_app_name => G_APP_NAME,
938: p_msg_name => G_UNEXPECTED_ERROR,
939: p_token1 => G_SQLCODE_TOKEN,
940: p_token1_value => SQLCODE,

Line 944: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

940: p_token1_value => SQLCODE,
941: p_token2 => G_SQLERRM_TOKEN,
942: p_token2_value => SQLERRM);
943: -- notify caller of an error as UNEXPETED error
944: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
945: END create_rg_mode_pty_role;
946:
947: PROCEDURE update_rg_mode_pty_role(
948: p_api_version IN NUMBER,

Line 973: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

969: p_rmpv_rec => p_rmpv_rec,
970: x_rmpv_rec => x_rmpv_rec);
971:
972: -- Update minor version
973: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
974: update_minor_version(p_rmpv_rec.dnz_chr_id);
975: END IF;
976:
977:

Line 985: OKC_API.SET_MESSAGE(

981: WHEN OTHERS THEN
982:
983:
984: -- store SQL error message on message stack
985: OKC_API.SET_MESSAGE(
986: p_app_name => G_APP_NAME,
987: p_msg_name => G_UNEXPECTED_ERROR,
988: p_token1 => G_SQLCODE_TOKEN,
989: p_token1_value => SQLCODE,

Line 993: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

989: p_token1_value => SQLCODE,
990: p_token2 => G_SQLERRM_TOKEN,
991: p_token2_value => SQLERRM);
992: -- notify caller of an error as UNEXPETED error
993: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
994: END update_rg_mode_pty_role;
995:
996: PROCEDURE delete_rg_mode_pty_role(
997: p_api_version IN NUMBER,

Line 1020: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1016: x_msg_data => x_msg_data,
1017: p_rmpv_rec => p_rmpv_rec);
1018:
1019: -- Update minor version
1020: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1021: update_minor_version(p_rmpv_rec.dnz_chr_id);
1022: END IF;
1023:
1024:

Line 1032: OKC_API.SET_MESSAGE(

1028: WHEN OTHERS THEN
1029:
1030:
1031: -- store SQL error message on message stack
1032: OKC_API.SET_MESSAGE(
1033: p_app_name => G_APP_NAME,
1034: p_msg_name => G_UNEXPECTED_ERROR,
1035: p_token1 => G_SQLCODE_TOKEN,
1036: p_token1_value => SQLCODE,

Line 1040: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1036: p_token1_value => SQLCODE,
1037: p_token2 => G_SQLERRM_TOKEN,
1038: p_token2_value => SQLERRM);
1039: -- notify caller of an error as UNEXPETED error
1040: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1041: END delete_rg_mode_pty_role;
1042:
1043: PROCEDURE lock_rg_mode_pty_role(
1044: p_api_version IN NUMBER,

Line 1126: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1122: p_ctiv_rec => p_ctiv_rec,
1123: x_ctiv_rec => x_ctiv_rec);
1124:
1125: -- Update minor version
1126: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1127: update_minor_version(p_ctiv_rec.dnz_chr_id);
1128: END IF;
1129:
1130:

Line 1138: OKC_API.SET_MESSAGE(

1134: WHEN OTHERS THEN
1135:
1136:
1137: -- store SQL error message on message stack
1138: OKC_API.SET_MESSAGE(
1139: p_app_name => G_APP_NAME,
1140: p_msg_name => G_UNEXPECTED_ERROR,
1141: p_token1 => G_SQLCODE_TOKEN,
1142: p_token1_value => SQLCODE,

Line 1146: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1142: p_token1_value => SQLCODE,
1143: p_token2 => G_SQLERRM_TOKEN,
1144: p_token2_value => SQLERRM);
1145: -- notify caller of an error as UNEXPETED error
1146: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1147: END create_cover_time;
1148:
1149: PROCEDURE update_cover_time(
1150: p_api_version IN NUMBER,

Line 1175: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1171: p_ctiv_rec => p_ctiv_rec,
1172: x_ctiv_rec => x_ctiv_rec);
1173:
1174: -- Update minor version
1175: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1176: update_minor_version(p_ctiv_rec.dnz_chr_id);
1177: END IF;
1178:
1179:

Line 1187: OKC_API.SET_MESSAGE(

1183: WHEN OTHERS THEN
1184:
1185:
1186: -- store SQL error message on message stack
1187: OKC_API.SET_MESSAGE(
1188: p_app_name => G_APP_NAME,
1189: p_msg_name => G_UNEXPECTED_ERROR,
1190: p_token1 => G_SQLCODE_TOKEN,
1191: p_token1_value => SQLCODE,

Line 1195: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1191: p_token1_value => SQLCODE,
1192: p_token2 => G_SQLERRM_TOKEN,
1193: p_token2_value => SQLERRM);
1194: -- notify caller of an error as UNEXPETED error
1195: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1196: END update_cover_time;
1197:
1198: PROCEDURE delete_cover_time(
1199: p_api_version IN NUMBER,

Line 1222: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1218: x_msg_data => x_msg_data,
1219: p_ctiv_rec => p_ctiv_rec);
1220:
1221: -- Update minor version
1222: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1223: update_minor_version(p_ctiv_rec.dnz_chr_id);
1224: END IF;
1225:
1226:

Line 1234: OKC_API.SET_MESSAGE(

1230: WHEN OTHERS THEN
1231:
1232:
1233: -- store SQL error message on message stack
1234: OKC_API.SET_MESSAGE(
1235: p_app_name => G_APP_NAME,
1236: p_msg_name => G_UNEXPECTED_ERROR,
1237: p_token1 => G_SQLCODE_TOKEN,
1238: p_token1_value => SQLCODE,

Line 1242: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1238: p_token1_value => SQLCODE,
1239: p_token2 => G_SQLERRM_TOKEN,
1240: p_token2_value => SQLERRM);
1241: -- notify caller of an error as UNEXPETED error
1242: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1243: END delete_cover_time;
1244:
1245: PROCEDURE lock_cover_time(
1246: p_api_version IN NUMBER,

Line 1324: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1320: p_rilv_rec => p_rilv_rec,
1321: x_rilv_rec => x_rilv_rec);
1322:
1323: -- Update minor version
1324: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1325: update_minor_version(p_rilv_rec.dnz_chr_id);
1326: END IF;
1327:
1328:

Line 1336: OKC_API.SET_MESSAGE(

1332: WHEN OTHERS THEN
1333:
1334:
1335: -- store SQL error message on message stack
1336: OKC_API.SET_MESSAGE(
1337: p_app_name => G_APP_NAME,
1338: p_msg_name => G_UNEXPECTED_ERROR,
1339: p_token1 => G_SQLCODE_TOKEN,
1340: p_token1_value => SQLCODE,

Line 1344: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1340: p_token1_value => SQLCODE,
1341: p_token2 => G_SQLERRM_TOKEN,
1342: p_token2_value => SQLERRM);
1343: -- notify caller of an error as UNEXPETED error
1344: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1345: END create_react_interval;
1346:
1347: PROCEDURE update_react_interval(
1348: p_api_version IN NUMBER,

Line 1373: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1369: p_rilv_rec => p_rilv_rec,
1370: x_rilv_rec => x_rilv_rec);
1371:
1372: -- Update minor version
1373: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1374: update_minor_version(p_rilv_rec.dnz_chr_id);
1375: END IF;
1376:
1377:

Line 1385: OKC_API.SET_MESSAGE(

1381: WHEN OTHERS THEN
1382:
1383:
1384: -- store SQL error message on message stack
1385: OKC_API.SET_MESSAGE(
1386: p_app_name => G_APP_NAME,
1387: p_msg_name => G_UNEXPECTED_ERROR,
1388: p_token1 => G_SQLCODE_TOKEN,
1389: p_token1_value => SQLCODE,

Line 1393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1389: p_token1_value => SQLCODE,
1390: p_token2 => G_SQLERRM_TOKEN,
1391: p_token2_value => SQLERRM);
1392: -- notify caller of an error as UNEXPETED error
1393: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1394: END update_react_interval;
1395:
1396: PROCEDURE delete_react_interval(
1397: p_api_version IN NUMBER,

Line 1420: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN

1416: x_msg_data => x_msg_data,
1417: p_rilv_rec => p_rilv_rec);
1418:
1419: -- Update minor version
1420: IF (x_return_status = OKC_API.G_RET_STS_SUCCESS) THEN
1421: update_minor_version(p_rilv_rec.dnz_chr_id);
1422: END IF;
1423:
1424:

Line 1432: OKC_API.SET_MESSAGE(

1428: WHEN OTHERS THEN
1429:
1430:
1431: -- store SQL error message on message stack
1432: OKC_API.SET_MESSAGE(
1433: p_app_name => G_APP_NAME,
1434: p_msg_name => G_UNEXPECTED_ERROR,
1435: p_token1 => G_SQLCODE_TOKEN,
1436: p_token1_value => SQLCODE,

Line 1440: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1436: p_token1_value => SQLCODE,
1437: p_token2 => G_SQLERRM_TOKEN,
1438: p_token2_value => SQLERRM);
1439: -- notify caller of an error as UNEXPETED error
1440: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1441: END delete_react_interval;
1442:
1443: PROCEDURE lock_react_interval(
1444: p_api_version IN NUMBER,