DBA Data[Home] [Help]

APPS.OKL_TRNS_ACC_DSTRS_PUB dependencies on FND_MSG_PUB

Line 268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

264: WHEN FND_API.G_EXC_ERROR THEN
265: ROLLBACK TO insert_trns_acc_dstrs;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267:
268: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
269: ,p_count => x_msg_count
270: ,p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO insert_trns_acc_dstrs;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
276: ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278:
279: WHEN OTHERS THEN

Line 280: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');

276: ,p_count => x_msg_count
277: ,p_data => x_msg_data);
278:
279: WHEN OTHERS THEN
280: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
281: -- store SQL error message on message stack for caller
282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
283: ,p_count => x_msg_count
284: ,p_data => x_msg_data);

Line 282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

278:
279: WHEN OTHERS THEN
280: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
281: -- store SQL error message on message stack for caller
282: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
283: ,p_count => x_msg_count
284: ,p_data => x_msg_data);
285: -- notify caller of an UNEXPECTED error
286: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

358: WHEN FND_API.G_EXC_ERROR THEN
359: ROLLBACK TO insert_trns_acc_dstrs;
360: x_return_status := FND_API.G_RET_STS_ERROR;
361:
362: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
363: ,p_count => x_msg_count
364: ,p_data => x_msg_data);
365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

365:
366: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: ROLLBACK TO insert_trns_acc_dstrs;
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
370: ,p_count => x_msg_count
371: ,p_data => x_msg_data);
372:
373: WHEN OTHERS THEN

Line 374: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');

370: ,p_count => x_msg_count
371: ,p_data => x_msg_data);
372:
373: WHEN OTHERS THEN
374: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
375: -- store SQL error message on message stack for caller
376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
377: ,p_count => x_msg_count
378: ,p_data => x_msg_data);

Line 376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

372:
373: WHEN OTHERS THEN
374: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','insert_trns_acc_dstrs');
375: -- store SQL error message on message stack for caller
376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
377: ,p_count => x_msg_count
378: ,p_data => x_msg_data);
379: -- notify caller of an UNEXPECTED error
380: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

416: WHEN FND_API.G_EXC_ERROR THEN
417: ROLLBACK TO lock_trns_acc_dstrs;
418: x_return_status := FND_API.G_RET_STS_ERROR;
419:
420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
421: ,p_count => x_msg_count
422: ,p_data => x_msg_data);
423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

423:
424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
425: ROLLBACK TO lock_trns_acc_dstrs;
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:
431: WHEN OTHERS THEN

Line 432: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');

428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:
431: WHEN OTHERS THEN
432: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
433: -- store SQL error message on message stack for caller
434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);

Line 434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

430:
431: WHEN OTHERS THEN
432: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
433: -- store SQL error message on message stack for caller
434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: -- notify caller of an UNEXPECTED error
438: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

496: WHEN FND_API.G_EXC_ERROR THEN
497: ROLLBACK TO lock_trns_acc_dstrs;
498: x_return_status := FND_API.G_RET_STS_ERROR;
499:
500: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
501: ,p_count => x_msg_count
502: ,p_data => x_msg_data);
503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

503:
504: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
505: ROLLBACK TO lock_trns_acc_dstrs;
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
507: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN

Line 512: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');

508: ,p_count => x_msg_count
509: ,p_data => x_msg_data);
510:
511: WHEN OTHERS THEN
512: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
513: -- store SQL error message on message stack for caller
514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);

Line 514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

510:
511: WHEN OTHERS THEN
512: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','lock_trns_acc_dstrs');
513: -- store SQL error message on message stack for caller
514: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517: -- notify caller of an UNEXPECTED error
518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

564: WHEN FND_API.G_EXC_ERROR THEN
565: ROLLBACK TO update_trns_acc_dstrs;
566: x_return_status := FND_API.G_RET_STS_ERROR;
567:
568: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
569: ,p_count => x_msg_count
570: ,p_data => x_msg_data);
571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

571:
572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
573: ROLLBACK TO update_trns_acc_dstrs;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
576: ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578:
579: WHEN OTHERS THEN

Line 580: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');

576: ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578:
579: WHEN OTHERS THEN
580: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
581: -- store SQL error message on message stack for caller
582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data);

Line 582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

578:
579: WHEN OTHERS THEN
580: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
581: -- store SQL error message on message stack for caller
582: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data);
585: -- notify caller of an UNEXPECTED error
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

658: WHEN FND_API.G_EXC_ERROR THEN
659: ROLLBACK TO update_trns_acc_dstrs;
660: x_return_status := FND_API.G_RET_STS_ERROR;
661:
662: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
663: ,p_count => x_msg_count
664: ,p_data => x_msg_data);
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO update_trns_acc_dstrs;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
670: ,p_count => x_msg_count
671: ,p_data => x_msg_data);
672:
673: WHEN OTHERS THEN

Line 674: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');

670: ,p_count => x_msg_count
671: ,p_data => x_msg_data);
672:
673: WHEN OTHERS THEN
674: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
675: -- store SQL error message on message stack for caller
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);

Line 676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

672:
673: WHEN OTHERS THEN
674: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','update_trns_acc_dstrs');
675: -- store SQL error message on message stack for caller
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: -- notify caller of an UNEXPECTED error
680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

758: WHEN FND_API.G_EXC_ERROR THEN
759: ROLLBACK TO delete_trns_acc_dstrs;
760: x_return_status := FND_API.G_RET_STS_ERROR;
761:
762: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
763: ,p_count => x_msg_count
764: ,p_data => x_msg_data);
765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

765:
766: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
767: ROLLBACK TO delete_trns_acc_dstrs;
768: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
770: ,p_count => x_msg_count
771: ,p_data => x_msg_data);
772:
773: WHEN OTHERS THEN

Line 774: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');

770: ,p_count => x_msg_count
771: ,p_data => x_msg_data);
772:
773: WHEN OTHERS THEN
774: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
775: -- store SQL error message on message stack for caller
776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
777: ,p_count => x_msg_count
778: ,p_data => x_msg_data);

Line 776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

772:
773: WHEN OTHERS THEN
774: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
775: -- store SQL error message on message stack for caller
776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
777: ,p_count => x_msg_count
778: ,p_data => x_msg_data);
779: -- notify caller of an UNEXPECTED error
780: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

847: WHEN FND_API.G_EXC_ERROR THEN
848: ROLLBACK TO delete_trns_acc_dstrs;
849: x_return_status := FND_API.G_RET_STS_ERROR;
850:
851: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
852: ,p_count => x_msg_count
853: ,p_data => x_msg_data);
854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

854:
855: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
856: ROLLBACK TO delete_trns_acc_dstrs;
857: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
858: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
859: ,p_count => x_msg_count
860: ,p_data => x_msg_data);
861:
862: WHEN OTHERS THEN

Line 863: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');

859: ,p_count => x_msg_count
860: ,p_data => x_msg_data);
861:
862: WHEN OTHERS THEN
863: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
864: -- store SQL error message on message stack for caller
865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
866: ,p_count => x_msg_count
867: ,p_data => x_msg_data);

Line 865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

861:
862: WHEN OTHERS THEN
863: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','delete_trns_acc_dstrs');
864: -- store SQL error message on message stack for caller
865: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
866: ,p_count => x_msg_count
867: ,p_data => x_msg_data);
868: -- notify caller of an UNEXPECTED error
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

910: WHEN FND_API.G_EXC_ERROR THEN
911: ROLLBACK TO validate_trns_acc_dstrs;
912: x_return_status := FND_API.G_RET_STS_ERROR;
913:
914: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
915: ,p_count => x_msg_count
916: ,p_data => x_msg_data);
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO validate_trns_acc_dstrs;
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
922: ,p_count => x_msg_count
923: ,p_data => x_msg_data);
924:
925: WHEN OTHERS THEN

Line 926: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');

922: ,p_count => x_msg_count
923: ,p_data => x_msg_data);
924:
925: WHEN OTHERS THEN
926: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
927: -- store SQL error message on message stack for caller
928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
929: ,p_count => x_msg_count
930: ,p_data => x_msg_data);

Line 928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

924:
925: WHEN OTHERS THEN
926: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
927: -- store SQL error message on message stack for caller
928: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
929: ,p_count => x_msg_count
930: ,p_data => x_msg_data);
931: -- notify caller of an UNEXPECTED error
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1000: WHEN FND_API.G_EXC_ERROR THEN
1001: ROLLBACK TO validate_trns_acc_dstrs;
1002: x_return_status := FND_API.G_RET_STS_ERROR;
1003:
1004: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1005: ,p_count => x_msg_count
1006: ,p_data => x_msg_data);
1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1007:
1008: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1009: ROLLBACK TO validate_trns_acc_dstrs;
1010: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1011: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014:
1015: WHEN OTHERS THEN

Line 1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');

1012: ,p_count => x_msg_count
1013: ,p_data => x_msg_data);
1014:
1015: WHEN OTHERS THEN
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
1017: -- store SQL error message on message stack for caller
1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1019: ,p_count => x_msg_count
1020: ,p_data => x_msg_data);

Line 1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

1014:
1015: WHEN OTHERS THEN
1016: FND_MSG_PUB.ADD_EXC_MSG('OKL_TRNS_ACC_DSTRS_PUB','validate_trns_acc_dstrs');
1017: -- store SQL error message on message stack for caller
1018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1019: ,p_count => x_msg_count
1020: ,p_data => x_msg_data);
1021: -- notify caller of an UNEXPECTED error
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;