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.OKL_CREDIT_MEMO_PVT dependencies on OKL_API

Line 81: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

77: EXCEPTION
78:
79: WHEN OTHERS THEN
80:
81: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
82: p_msg_name => G_UNEXPECTED_ERROR,
83: p_token1 => G_SQLCODE_TOKEN,
84: p_token1_value => SQLCODE,
85: p_token2 => G_SQLERRM_TOKEN,

Line 124: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

120: EXCEPTION
121:
122: WHEN OTHERS THEN
123:
124: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
125: p_msg_name => G_UNEXPECTED_ERROR,
126: p_token1 => G_SQLCODE_TOKEN,
127: p_token1_value => SQLCODE,
128: p_token2 => G_SQLERRM_TOKEN,

Line 217: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

213: EXCEPTION
214:
215: WHEN OTHERS THEN
216:
217: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
218: p_msg_name => G_UNEXPECTED_ERROR,
219: p_token1 => G_SQLCODE_TOKEN,
220: p_token1_value => SQLCODE,
221: p_token2 => G_SQLERRM_TOKEN,

Line 382: OKL_API.set_message(p_app_name => G_APP_NAME,

378: l_try_id := get_try_id( 'Credit Memo');
379:
380: IF l_try_id IS NULL THEN
381:
382: OKL_API.set_message(p_app_name => G_APP_NAME,
383: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
384: p_token1 => 'TRY_NAME',
385: p_token1_value => 'Credit Memo');
386:

Line 387: RAISE OKL_API.G_EXCEPTION_ERROR;

383: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
384: p_token1 => 'TRY_NAME',
385: p_token1_value => 'Credit Memo');
386:
387: RAISE OKL_API.G_EXCEPTION_ERROR;
388:
389: END IF;
390:
391: END IF;

Line 431: OKL_API.set_message(p_app_name => G_APP_NAME,

427: FETCH cust_acct_csr INTO i_taiv_rec.ibt_id;
428: CLOSE cust_acct_csr;
429: --gkhuntet 26-07-2007 start.
430: /* ELSE
431: OKL_API.set_message(p_app_name => G_APP_NAME,
432: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
433: p_token1 => 'TRY_NAME',
434: p_token1_value => 'Credit Memo');
435:

Line 436: RAISE OKL_API.G_EXCEPTION_ERROR;*/

432: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
433: p_token1 => 'TRY_NAME',
434: p_token1_value => 'Credit Memo');
435:
436: RAISE OKL_API.G_EXCEPTION_ERROR;*/
437: --gkhuntet 26-07-2007 end.
438: END IF;
439:
440: ---------------------------------------------

Line 641: okl_api.set_message(p_app_name => G_APP_NAME,

637: lp_tilv_tbl(0) := i_tilv_rec;
638:
639: ELSE
640:
641: okl_api.set_message(p_app_name => G_APP_NAME,
642: p_msg_name => 'OKL_INVOICE_TRX_NOT_FOUND');
643:
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645:

Line 644: RAISE OKL_API.G_EXCEPTION_ERROR;

640:
641: okl_api.set_message(p_app_name => G_APP_NAME,
642: p_msg_name => 'OKL_INVOICE_TRX_NOT_FOUND');
643:
644: RAISE OKL_API.G_EXCEPTION_ERROR;
645:
646: END IF;
647:
648: END IF;

Line 670: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

666: x_taiv_rec := r_taiv_rec;
667: x_return_status := l_return_status;
668:
669:
670: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
671: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
672: x_return_status := l_return_status;
673: END IF;
674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 671: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

667: x_return_status := l_return_status;
668:
669:
670: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
671: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
672: x_return_status := l_return_status;
673: END IF;
674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: END IF;

Line 674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

670: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
671: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
672: x_return_status := l_return_status;
673: END IF;
674: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
675: END IF;
676:
677: EXCEPTION
678:

Line 679: WHEN OKL_API.G_EXCEPTION_ERROR THEN

675: END IF;
676:
677: EXCEPTION
678:
679: WHEN OKL_API.G_EXCEPTION_ERROR THEN
680:
681: x_return_status := OKL_API.G_RET_STS_ERROR;
682:
683: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 681: x_return_status := OKL_API.G_RET_STS_ERROR;

677: EXCEPTION
678:
679: WHEN OKL_API.G_EXCEPTION_ERROR THEN
680:
681: x_return_status := OKL_API.G_RET_STS_ERROR;
682:
683: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
684:
685: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 683: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

679: WHEN OKL_API.G_EXCEPTION_ERROR THEN
680:
681: x_return_status := OKL_API.G_RET_STS_ERROR;
682:
683: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
684:
685: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN

Line 685: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

681: x_return_status := OKL_API.G_RET_STS_ERROR;
682:
683: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
684:
685: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN
688:
689: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 689: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

685: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
686:
687: WHEN OTHERS THEN
688:
689: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
690: p_msg_name => G_UNEXPECTED_ERROR,
691: p_token1 => G_SQLCODE_TOKEN,
692: p_token1_value => sqlcode,
693: p_token2 => G_SQLERRM_TOKEN,

Line 696: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

692: p_token1_value => sqlcode,
693: p_token2 => G_SQLERRM_TOKEN,
694: p_token2_value => sqlerrm);
695:
696: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
697:
698:
699: END insert_request;
700:

Line 737: OKL_API.set_message(p_app_name => G_APP_NAME,

733: l_try_id := get_try_id(p_credit_list(i).credit_try_name);
734:
735: IF l_try_id IS NULL THEN
736:
737: OKL_API.set_message(p_app_name => G_APP_NAME,
738: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
739: p_token1 => 'TRY_NAME',
740: p_token1_value => p_credit_list(i).credit_try_name);
741:

Line 742: RAISE OKL_API.G_EXCEPTION_ERROR;

738: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
739: p_token1 => 'TRY_NAME',
740: p_token1_value => p_credit_list(i).credit_try_name);
741:
742: RAISE OKL_API.G_EXCEPTION_ERROR;
743:
744: END IF;
745:
746: ELSE

Line 754: OKL_API.set_message(p_app_name => G_APP_NAME,

750: l_cm_try_id := get_try_id('Credit Memo');
751:
752: IF l_cm_try_id IS NULL THEN
753:
754: OKL_API.set_message(p_app_name => G_APP_NAME,
755: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
756: p_token1 => 'TRY_NAME',
757: p_token1_value => 'Credit Memo');
758:

Line 759: RAISE OKL_API.G_EXCEPTION_ERROR;

755: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
756: p_token1 => 'TRY_NAME',
757: p_token1_value => 'Credit Memo');
758:
759: RAISE OKL_API.G_EXCEPTION_ERROR;
760:
761: END IF;
762:
763: ELSE

Line 789: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN

785: x_return_status => l_return_status,
786: x_msg_count => x_msg_count,
787: x_msg_data => x_msg_data);
788:
789: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
790: RAISE OKL_API.G_EXCEPTION_ERROR;
791: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: END IF;

Line 790: RAISE OKL_API.G_EXCEPTION_ERROR;

786: x_msg_count => x_msg_count,
787: x_msg_data => x_msg_data);
788:
789: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
790: RAISE OKL_API.G_EXCEPTION_ERROR;
791: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: END IF;
794:

Line 791: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

787: x_msg_data => x_msg_data);
788:
789: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
790: RAISE OKL_API.G_EXCEPTION_ERROR;
791: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: END IF;
794:
795: x_taiv_tbl(i) := lx_taiv_rec;

Line 792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

788:
789: IF l_return_status = OKL_API.G_RET_STS_ERROR THEN
790: RAISE OKL_API.G_EXCEPTION_ERROR;
791: ELSIF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
792: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: END IF;
794:
795: x_taiv_tbl(i) := lx_taiv_rec;
796:

Line 803: WHEN OKL_API.G_EXCEPTION_ERROR THEN

799: x_return_status := l_return_status;
800:
801: EXCEPTION
802:
803: WHEN OKL_API.G_EXCEPTION_ERROR THEN
804:
805: x_return_status := OKL_API.G_RET_STS_ERROR;
806:
807: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 805: x_return_status := OKL_API.G_RET_STS_ERROR;

801: EXCEPTION
802:
803: WHEN OKL_API.G_EXCEPTION_ERROR THEN
804:
805: x_return_status := OKL_API.G_RET_STS_ERROR;
806:
807: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
808:
809: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 807: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

803: WHEN OKL_API.G_EXCEPTION_ERROR THEN
804:
805: x_return_status := OKL_API.G_RET_STS_ERROR;
806:
807: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
808:
809: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
810:
811: WHEN OTHERS THEN

Line 809: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

805: x_return_status := OKL_API.G_RET_STS_ERROR;
806:
807: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
808:
809: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
810:
811: WHEN OTHERS THEN
812:
813: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 813: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

809: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
810:
811: WHEN OTHERS THEN
812:
813: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
814: p_msg_name => G_UNEXPECTED_ERROR,
815: p_token1 => G_SQLCODE_TOKEN,
816: p_token1_value => sqlcode,
817: p_token2 => G_SQLERRM_TOKEN,

Line 820: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

816: p_token1_value => sqlcode,
817: p_token2 => G_SQLERRM_TOKEN,
818: p_token2_value => sqlerrm);
819:
820: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
821:
822: END insert_request;
823:
824: --rkuttiya added for bug#4341480

Line 942: OKL_API.set_message(p_app_name => G_APP_NAME,

938: l_try_id := get_try_id( 'Credit Memo');
939:
940: IF l_try_id IS NULL THEN
941:
942: OKL_API.set_message(p_app_name => G_APP_NAME,
943: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
944: p_token1 => 'TRY_NAME',
945: p_token1_value => 'Credit Memo');
946:

Line 947: RAISE OKL_API.G_EXCEPTION_ERROR;

943: p_msg_name => 'OKL_TRY_ID_NOT_FOUND',
944: p_token1 => 'TRY_NAME',
945: p_token1_value => 'Credit Memo');
946:
947: RAISE OKL_API.G_EXCEPTION_ERROR;
948:
949: END IF;
950:
951: END IF;

Line 995: OKL_API.set_message(p_app_name => G_APP_NAME,

991: CLOSE cust_acct_csr;
992: END IF;
993:
994: IF(i_taiv_rec.ibt_id IS NULL) THEN
995: OKL_API.set_message(p_app_name => G_APP_NAME,
996: p_msg_name => 'OKL_IBT_ID_NOT_FOUND',
997: p_token1 => 'TRY_NAME',
998: p_token1_value => 'Credit Memo');
999: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 999: RAISE OKL_API.G_EXCEPTION_ERROR;

995: OKL_API.set_message(p_app_name => G_APP_NAME,
996: p_msg_name => 'OKL_IBT_ID_NOT_FOUND',
997: p_token1 => 'TRY_NAME',
998: p_token1_value => 'Credit Memo');
999: RAISE OKL_API.G_EXCEPTION_ERROR;
1000: END IF;
1001:
1002:
1003: ---------------------------------------------

Line 1200: okl_api.set_message(p_app_name => G_APP_NAME,

1196: lp_tilv_tbl(0) := i_tilv_rec;
1197:
1198: ELSE
1199:
1200: okl_api.set_message(p_app_name => G_APP_NAME,
1201: p_msg_name => 'OKL_INVOICE_TRX_NOT_FOUND');
1202:
1203: RAISE OKL_API.G_EXCEPTION_ERROR;
1204:

Line 1203: RAISE OKL_API.G_EXCEPTION_ERROR;

1199:
1200: okl_api.set_message(p_app_name => G_APP_NAME,
1201: p_msg_name => 'OKL_INVOICE_TRX_NOT_FOUND');
1202:
1203: RAISE OKL_API.G_EXCEPTION_ERROR;
1204:
1205: END IF;
1206:
1207: END IF;

Line 1231: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

1227: x_return_status := l_return_status;
1228: x_tai_id := r_taiv_rec.id;
1229: --g_debug_proc('After call of create_billing_trx ' || x_tai_id || ' ' || lx_tilv_tbl(lx_tilv_tbl.FIRST).id);
1230:
1231: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1232: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: x_return_status := l_return_status;
1234: END IF;
1235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1232: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

1228: x_tai_id := r_taiv_rec.id;
1229: --g_debug_proc('After call of create_billing_trx ' || x_tai_id || ' ' || lx_tilv_tbl(lx_tilv_tbl.FIRST).id);
1230:
1231: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1232: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: x_return_status := l_return_status;
1234: END IF;
1235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1236: END IF;

Line 1235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1231: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
1232: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1233: x_return_status := l_return_status;
1234: END IF;
1235: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1236: END IF;
1237:
1238: EXCEPTION
1239:

Line 1240: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1236: END IF;
1237:
1238: EXCEPTION
1239:
1240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1241:
1242: x_return_status := OKL_API.G_RET_STS_ERROR;
1243:
1244: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1242: x_return_status := OKL_API.G_RET_STS_ERROR;

1238: EXCEPTION
1239:
1240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1241:
1242: x_return_status := OKL_API.G_RET_STS_ERROR;
1243:
1244: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1245:
1246: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

Line 1244: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1240: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1241:
1242: x_return_status := OKL_API.G_RET_STS_ERROR;
1243:
1244: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1245:
1246: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: WHEN OTHERS THEN

Line 1246: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1242: x_return_status := OKL_API.G_RET_STS_ERROR;
1243:
1244: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1245:
1246: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: WHEN OTHERS THEN
1249:
1250: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

Line 1250: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1246: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: WHEN OTHERS THEN
1249:
1250: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1251: p_msg_name => G_UNEXPECTED_ERROR,
1252: p_token1 => G_SQLCODE_TOKEN,
1253: p_token1_value => sqlcode,
1254: p_token2 => G_SQLERRM_TOKEN,

Line 1257: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

1253: p_token1_value => sqlcode,
1254: p_token2 => G_SQLERRM_TOKEN,
1255: p_token2_value => sqlerrm);
1256:
1257: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
1258:
1259:
1260: END insert_on_acc_cm_request;
1261: