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_XCR_PUB dependencies on OKL_API

Line 12: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

8:
9: --Object type procedure for insert
10: PROCEDURE create_ext_ar_txns(
11: p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,x_msg_count OUT NOCOPY NUMBER
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_xcrv_rec IN xcrv_rec_type

Line 22: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

18: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
19: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
20: ) IS
21:
22: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
23:
24: l_api_version NUMBER;
25: l_init_msg_list VARCHAR2(1);
26:

Line 65: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

61: ,x_xcav_tbl
62: );
63:
64:
65: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
66: RAISE G_EXCEPTION_HALT_VALIDATION;
67: END IF;
68:
69: -- customer post-processing

Line 116: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

112:
113: --Object type procedure for update
114: PROCEDURE update_ext_ar_txns(
115: p_api_version IN NUMBER
116: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
117: ,x_return_status OUT NOCOPY VARCHAR2
118: ,x_msg_count OUT NOCOPY NUMBER
119: ,x_msg_data OUT NOCOPY VARCHAR2
120: ,p_xcrv_rec IN xcrv_rec_type

Line 126: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

122: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
123: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
124: ) IS
125:
126: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
127:
128: l_api_version NUMBER;
129: l_init_msg_list VARCHAR2(1);
130:

Line 167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

163: ,p_xcav_tbl
164: ,x_xcrv_rec
165: ,x_xcav_tbl
166: );
167: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
168: RAISE G_EXCEPTION_HALT_VALIDATION;
169: END IF;
170:
171: -- customer post-processing

Line 216: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

212: END update_ext_ar_txns;
213:
214: PROCEDURE update_ext_csh_txns(
215: p_api_version IN NUMBER
216: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
217: ,x_return_status OUT NOCOPY VARCHAR2
218: ,x_msg_count OUT NOCOPY NUMBER
219: ,x_msg_data OUT NOCOPY VARCHAR2
220: ,p_xcrv_rec IN xcrv_rec_type

Line 224: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

220: ,p_xcrv_rec IN xcrv_rec_type
221: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
222: ) IS
223:
224: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
225:
226: l_api_version NUMBER;
227: l_init_msg_list VARCHAR2(1);
228:

Line 260: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

256: ,p_xcrv_rec
257: ,x_xcrv_rec
258: );
259:
260: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
261: RAISE G_EXCEPTION_HALT_VALIDATION;
262: END IF;
263:
264: -- customer post-processing

Line 309: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

305:
306: --Object type procedure for update
307: PROCEDURE delete_ext_ar_txns(
308: p_api_version IN NUMBER
309: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
310: ,x_return_status OUT NOCOPY VARCHAR2
311: ,x_msg_count OUT NOCOPY NUMBER
312: ,x_msg_data OUT NOCOPY VARCHAR2
313: ,p_xcrv_rec IN xcrv_rec_type

Line 319: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

315: ,x_xcrv_rec OUT NOCOPY xcrv_rec_type
316: ,x_xcav_tbl OUT NOCOPY xcav_tbl_type
317: ) IS
318:
319: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
320:
321: l_api_version NUMBER;
322: l_init_msg_list VARCHAR2(1);
323:

Line 360: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

356: ,p_xcav_tbl
357: ,x_xcrv_rec
358: ,x_xcav_tbl
359: );
360: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
361: RAISE G_EXCEPTION_HALT_VALIDATION;
362: END IF;
363:
364: -- customer post-processing

Line 410: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

406:
407: --Object type procedure for validate
408: PROCEDURE validate_ext_ar_txns(
409: p_api_version IN NUMBER
410: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
411: ,x_return_status OUT NOCOPY VARCHAR2
412: ,x_msg_count OUT NOCOPY NUMBER
413: ,x_msg_data OUT NOCOPY VARCHAR2
414: ,p_xcrv_rec IN xcrv_rec_type

Line 418: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;

414: ,p_xcrv_rec IN xcrv_rec_type
415: ,p_xcav_tbl IN xcav_tbl_type
416: ) IS
417:
418: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
419:
420: l_api_version NUMBER;
421: l_init_msg_list VARCHAR2(1);
422:

Line 458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

454: ,p_xcrv_rec
455: ,p_xcav_tbl
456: );
457:
458: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
459: RAISE G_EXCEPTION_HALT_VALIDATION;
460: END IF;
461:
462: -- customer post-processing

Line 506: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

502:
503: --Object type procedure for lock
504: PROCEDURE lock_ext_ar_txns(
505: p_api_version IN NUMBER
506: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
507: ,x_return_status OUT NOCOPY VARCHAR2
508: ,x_msg_count OUT NOCOPY NUMBER
509: ,x_msg_data OUT NOCOPY VARCHAR2
510: ,p_xcrv_rec IN xcrv_rec_type

Line 522: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

518: ,x_msg_data
519: ,p_xcrv_rec
520: );
521:
522: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
523: RAISE G_EXCEPTION_HALT_VALIDATION;
524: END IF;
525:
526: EXCEPTION

Line 528: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

524: END IF;
525:
526: EXCEPTION
527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531: Okl_Api.set_message(p_app_name => g_app_name,
532: p_msg_name => g_unexpected_error,

Line 531: Okl_Api.set_message(p_app_name => g_app_name,

527: WHEN G_EXCEPTION_HALT_VALIDATION THEN
528: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
529:
530: WHEN OTHERS THEN
531: Okl_Api.set_message(p_app_name => g_app_name,
532: p_msg_name => g_unexpected_error,
533: p_token1 => g_sqlcode_token,
534: p_token1_value => SQLCODE,
535: p_token2 => g_sqlerrm_token,

Line 537: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

533: p_token1 => g_sqlcode_token,
534: p_token1_value => SQLCODE,
535: p_token2 => g_sqlerrm_token,
536: p_token2_value => SQLERRM);
537: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
538: END lock_ext_ar_txns;
539:
540: --Object type procedure for lock
541: PROCEDURE lock_ext_ar_txns(

Line 543: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

539:
540: --Object type procedure for lock
541: PROCEDURE lock_ext_ar_txns(
542: p_api_version IN NUMBER
543: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
544: ,x_return_status OUT NOCOPY VARCHAR2
545: ,x_msg_count OUT NOCOPY NUMBER
546: ,x_msg_data OUT NOCOPY VARCHAR2
547: ,p_xcrv_tbl IN xcrv_tbl_type

Line 559: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

555: ,x_msg_data
556: ,p_xcrv_tbl
557: );
558:
559: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
560: RAISE G_EXCEPTION_HALT_VALIDATION;
561: END IF;
562:
563: EXCEPTION

Line 565: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

561: END IF;
562:
563: EXCEPTION
564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
565: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
566:
567: WHEN OTHERS THEN
568: Okl_Api.set_message(p_app_name => g_app_name,
569: p_msg_name => g_unexpected_error,

Line 568: Okl_Api.set_message(p_app_name => g_app_name,

564: WHEN G_EXCEPTION_HALT_VALIDATION THEN
565: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
566:
567: WHEN OTHERS THEN
568: Okl_Api.set_message(p_app_name => g_app_name,
569: p_msg_name => g_unexpected_error,
570: p_token1 => g_sqlcode_token,
571: p_token1_value => SQLCODE,
572: p_token2 => g_sqlerrm_token,

Line 574: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

570: p_token1 => g_sqlcode_token,
571: p_token1_value => SQLCODE,
572: p_token2 => g_sqlerrm_token,
573: p_token2_value => SQLERRM);
574: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
575: END lock_ext_ar_txns;
576:
577: --Object type procedure for lock
578: PROCEDURE lock_ext_ar_txns(

Line 580: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

576:
577: --Object type procedure for lock
578: PROCEDURE lock_ext_ar_txns(
579: p_api_version IN NUMBER
580: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
581: ,x_return_status OUT NOCOPY VARCHAR2
582: ,x_msg_count OUT NOCOPY NUMBER
583: ,x_msg_data OUT NOCOPY VARCHAR2
584: ,p_xcav_rec IN xcav_rec_type

Line 596: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

592: ,x_msg_data
593: ,p_xcav_rec
594: );
595:
596: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
597: RAISE G_EXCEPTION_HALT_VALIDATION;
598: END IF;
599:
600: EXCEPTION

Line 602: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

598: END IF;
599:
600: EXCEPTION
601: WHEN G_EXCEPTION_HALT_VALIDATION THEN
602: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
603:
604: WHEN OTHERS THEN
605: Okl_Api.set_message(p_app_name => g_app_name,
606: p_msg_name => g_unexpected_error,

Line 605: Okl_Api.set_message(p_app_name => g_app_name,

601: WHEN G_EXCEPTION_HALT_VALIDATION THEN
602: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
603:
604: WHEN OTHERS THEN
605: Okl_Api.set_message(p_app_name => g_app_name,
606: p_msg_name => g_unexpected_error,
607: p_token1 => g_sqlcode_token,
608: p_token1_value => SQLCODE,
609: p_token2 => g_sqlerrm_token,

Line 611: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

607: p_token1 => g_sqlcode_token,
608: p_token1_value => SQLCODE,
609: p_token2 => g_sqlerrm_token,
610: p_token2_value => SQLERRM);
611: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
612: END lock_ext_ar_txns;
613:
614: --Object type procedure for lock
615: PROCEDURE lock_ext_ar_txns(

Line 617: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE

613:
614: --Object type procedure for lock
615: PROCEDURE lock_ext_ar_txns(
616: p_api_version IN NUMBER
617: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
618: ,x_return_status OUT NOCOPY VARCHAR2
619: ,x_msg_count OUT NOCOPY NUMBER
620: ,x_msg_data OUT NOCOPY VARCHAR2
621: ,p_xcav_tbl IN xcav_tbl_type

Line 633: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN

629: ,x_msg_data
630: ,p_xcav_tbl
631: );
632:
633: IF x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR THEN
634: RAISE G_EXCEPTION_HALT_VALIDATION;
635: END IF;
636:
637: EXCEPTION

Line 639: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

635: END IF;
636:
637: EXCEPTION
638: WHEN G_EXCEPTION_HALT_VALIDATION THEN
639: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
640:
641: WHEN OTHERS THEN
642: Okl_Api.set_message(p_app_name => g_app_name,
643: p_msg_name => g_unexpected_error,

Line 642: Okl_Api.set_message(p_app_name => g_app_name,

638: WHEN G_EXCEPTION_HALT_VALIDATION THEN
639: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
640:
641: WHEN OTHERS THEN
642: Okl_Api.set_message(p_app_name => g_app_name,
643: p_msg_name => g_unexpected_error,
644: p_token1 => g_sqlcode_token,
645: p_token1_value => SQLCODE,
646: p_token2 => g_sqlerrm_token,

Line 648: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;

644: p_token1 => g_sqlcode_token,
645: p_token1_value => SQLCODE,
646: p_token2 => g_sqlerrm_token,
647: p_token2_value => SQLERRM);
648: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
649: END lock_ext_ar_txns;
650:
651: END Okl_Xcr_Pub;