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

Line 7: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

3:
4:
5: PROCEDURE insert_acct_sources(
6: p_api_version IN NUMBER
7: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
8: ,x_return_status OUT NOCOPY VARCHAR2
9: ,x_msg_count OUT NOCOPY NUMBER
10: ,x_msg_data OUT NOCOPY VARCHAR2
11: ,p_asev_rec IN asev_rec_type

Line 49: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

45: WHEN Fnd_Api.G_EXC_ERROR THEN
46: ROLLBACK TO insert_acct_sources;
47: x_return_status := Fnd_Api.G_RET_STS_ERROR;
48:
49: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
50: ,p_count => x_msg_count
51: ,p_data => x_msg_data);
52:
53: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 56: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

52:
53: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
54: ROLLBACK TO insert_acct_sources;
55: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
56: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:
60: WHEN OTHERS THEN

Line 63: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

59:
60: WHEN OTHERS THEN
61: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');
62: -- store SQL error message on message stack for caller
63: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66: -- notify caller of an UNEXPECTED error
67: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 73: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

69:
70:
71: PROCEDURE insert_acct_sources(
72: p_api_version IN NUMBER
73: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
74: ,x_return_status OUT NOCOPY VARCHAR2
75: ,x_msg_count OUT NOCOPY NUMBER
76: ,x_msg_data OUT NOCOPY VARCHAR2
77: ,p_asev_tbl IN asev_tbl_type

Line 147: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

143: WHEN Fnd_Api.G_EXC_ERROR THEN
144: ROLLBACK TO insert_acct_sources;
145: x_return_status := Fnd_Api.G_RET_STS_ERROR;
146:
147: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 154: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

150:
151: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_acct_sources;
153: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
154: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN

Line 161: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

157:
158: WHEN OTHERS THEN
159: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');
160: -- store SQL error message on message stack for caller
161: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: -- notify caller of an UNEXPECTED error
165: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 174: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

170: --Bug 4662173 - Start of Changes
171:
172: PROCEDURE insert_acct_sources_bulk(
173: p_api_version IN NUMBER
174: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
175: ,x_return_status OUT NOCOPY VARCHAR2
176: ,x_msg_count OUT NOCOPY NUMBER
177: ,x_msg_data OUT NOCOPY VARCHAR2
178: ,p_asev_tbl IN asev_tbl_type

Line 221: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

217: WHEN Fnd_Api.G_EXC_ERROR THEN
218: ROLLBACK TO insert_acct_sources;
219: x_return_status := Fnd_Api.G_RET_STS_ERROR;
220:
221: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
222: ,p_count => x_msg_count
223: ,p_data => x_msg_data);
224:
225: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 228: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

224:
225: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO insert_acct_sources;
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
228: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
229: ,p_count => x_msg_count
230: ,p_data => x_msg_data);
231:
232: WHEN OTHERS THEN

Line 235: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

231:
232: WHEN OTHERS THEN
233: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources_bulk');
234: -- store SQL error message on message stack for caller
235: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
236: ,p_count => x_msg_count
237: ,p_data => x_msg_data);
238: -- notify caller of an UNEXPECTED error
239: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 245: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

241: --Bug 4662173 - End of Changes
242:
243: PROCEDURE lock_acct_sources(
244: p_api_version IN NUMBER
245: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
246: ,x_return_status OUT NOCOPY VARCHAR2
247: ,x_msg_count OUT NOCOPY NUMBER
248: ,x_msg_data OUT NOCOPY VARCHAR2
249: ,p_asev_rec IN asev_rec_type

Line 280: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

276: WHEN Fnd_Api.G_EXC_ERROR THEN
277: ROLLBACK TO lock_acct_sources;
278: x_return_status := Fnd_Api.G_RET_STS_ERROR;
279:
280: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
281: ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283:
284: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 287: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

283:
284: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO lock_acct_sources;
286: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
287: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
288: ,p_count => x_msg_count
289: ,p_data => x_msg_data);
290:
291: WHEN OTHERS THEN

Line 294: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

290:
291: WHEN OTHERS THEN
292: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','lock_acct_sources');
293: -- store SQL error message on message stack for caller
294: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
295: ,p_count => x_msg_count
296: ,p_data => x_msg_data);
297: -- notify caller of an UNEXPECTED error
298: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 303: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

299: END lock_acct_sources;
300:
301: PROCEDURE lock_acct_sources(
302: p_api_version IN NUMBER
303: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
304: ,x_return_status OUT NOCOPY VARCHAR2
305: ,x_msg_count OUT NOCOPY NUMBER
306: ,x_msg_data OUT NOCOPY VARCHAR2
307: ,p_asev_tbl IN asev_tbl_type

Line 360: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

356: WHEN Fnd_Api.G_EXC_ERROR THEN
357: ROLLBACK TO lock_acct_sources;
358: x_return_status := Fnd_Api.G_RET_STS_ERROR;
359:
360: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
361: ,p_count => x_msg_count
362: ,p_data => x_msg_data);
363:
364: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 367: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

363:
364: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO lock_acct_sources;
366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
367: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
370:
371: WHEN OTHERS THEN

Line 374: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

370:
371: WHEN OTHERS THEN
372: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','lock_acct_sources');
373: -- store SQL error message on message stack for caller
374: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);
377: -- notify caller of an UNEXPECTED error
378: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 383: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

379: END lock_acct_sources;
380:
381: PROCEDURE update_acct_sources(
382: p_api_version IN NUMBER
383: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
384: ,x_return_status OUT NOCOPY VARCHAR2
385: ,x_msg_count OUT NOCOPY NUMBER
386: ,x_msg_data OUT NOCOPY VARCHAR2
387: ,p_asev_rec IN asev_rec_type

Line 432: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

428: WHEN Fnd_Api.G_EXC_ERROR THEN
429: ROLLBACK TO update_acct_sources;
430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
431:
432: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
433: ,p_count => x_msg_count
434: ,p_data => x_msg_data);
435:
436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 439: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

435:
436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO update_acct_sources;
438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
439: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
440: ,p_count => x_msg_count
441: ,p_data => x_msg_data);
442:
443: WHEN OTHERS THEN

Line 446: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

442:
443: WHEN OTHERS THEN
444: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
445: -- store SQL error message on message stack for caller
446: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
447: ,p_count => x_msg_count
448: ,p_data => x_msg_data);
449: -- notify caller of an UNEXPECTED error
450: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 456: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

452:
453:
454: PROCEDURE update_acct_sources(
455: p_api_version IN NUMBER
456: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
457: ,x_return_status OUT NOCOPY VARCHAR2
458: ,x_msg_count OUT NOCOPY NUMBER
459: ,x_msg_data OUT NOCOPY VARCHAR2
460: ,p_asev_tbl IN asev_tbl_type

Line 530: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

526: WHEN Fnd_Api.G_EXC_ERROR THEN
527: ROLLBACK TO update_acct_sources;
528: x_return_status := Fnd_Api.G_RET_STS_ERROR;
529:
530: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533:
534: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 537: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

533:
534: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
535: ROLLBACK TO update_acct_sources;
536: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
537: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
538: ,p_count => x_msg_count
539: ,p_data => x_msg_data);
540:
541: WHEN OTHERS THEN

Line 544: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

540:
541: WHEN OTHERS THEN
542: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
543: -- store SQL error message on message stack for caller
544: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
545: ,p_count => x_msg_count
546: ,p_data => x_msg_data);
547: -- notify caller of an UNEXPECTED error
548: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 553: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

549: END update_acct_sources;
550:
551: PROCEDURE delete_acct_sources(
552: p_api_version IN NUMBER
553: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
554: ,x_return_status OUT NOCOPY VARCHAR2
555: ,x_msg_count OUT NOCOPY NUMBER
556: ,x_msg_data OUT NOCOPY VARCHAR2
557: ,p_asev_rec IN asev_rec_type

Line 634: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

630: WHEN Fnd_Api.G_EXC_ERROR THEN
631: ROLLBACK TO delete_acct_sources;
632: x_return_status := Fnd_Api.G_RET_STS_ERROR;
633:
634: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
635: ,p_count => x_msg_count
636: ,p_data => x_msg_data);
637:
638: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 641: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

637:
638: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
639: ROLLBACK TO delete_acct_sources;
640: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
641: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
642: ,p_count => x_msg_count
643: ,p_data => x_msg_data);
644:
645: WHEN OTHERS THEN

Line 648: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

644:
645: WHEN OTHERS THEN
646: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');
647: -- store SQL error message on message stack for caller
648: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
649: ,p_count => x_msg_count
650: ,p_data => x_msg_data);
651: -- notify caller of an UNEXPECTED error
652: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 658: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

654:
655:
656: PROCEDURE delete_acct_sources(
657: p_api_version IN NUMBER
658: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
659: ,x_return_status OUT NOCOPY VARCHAR2
660: ,x_msg_count OUT NOCOPY NUMBER
661: ,x_msg_data OUT NOCOPY VARCHAR2
662: ,p_asev_tbl IN asev_tbl_type

Line 727: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

723: WHEN Fnd_Api.G_EXC_ERROR THEN
724: ROLLBACK TO delete_acct_sources;
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726:
727: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
728: ,p_count => x_msg_count
729: ,p_data => x_msg_data);
730:
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 734: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

730:
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO delete_acct_sources;
733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
734: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
735: ,p_count => x_msg_count
736: ,p_data => x_msg_data);
737:
738: WHEN OTHERS THEN

Line 741: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

737:
738: WHEN OTHERS THEN
739: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');
740: -- store SQL error message on message stack for caller
741: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
742: ,p_count => x_msg_count
743: ,p_data => x_msg_data);
744: -- notify caller of an UNEXPECTED error
745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 750: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

746: END delete_acct_sources;
747:
748: PROCEDURE validate_acct_sources(
749: p_api_version IN NUMBER
750: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
751: ,x_return_status OUT NOCOPY VARCHAR2
752: ,x_msg_count OUT NOCOPY NUMBER
753: ,x_msg_data OUT NOCOPY VARCHAR2
754: ,p_asev_rec IN asev_rec_type

Line 794: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

790: WHEN Fnd_Api.G_EXC_ERROR THEN
791: ROLLBACK TO validate_acct_sources;
792: x_return_status := Fnd_Api.G_RET_STS_ERROR;
793:
794: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
795: ,p_count => x_msg_count
796: ,p_data => x_msg_data);
797:
798: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 801: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

797:
798: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO validate_acct_sources;
800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
801: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
802: ,p_count => x_msg_count
803: ,p_data => x_msg_data);
804:
805: WHEN OTHERS THEN

Line 808: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

804:
805: WHEN OTHERS THEN
806: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','validate_acct_sources');
807: -- store SQL error message on message stack for caller
808: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
809: ,p_count => x_msg_count
810: ,p_data => x_msg_data);
811: -- notify caller of an UNEXPECTED error
812: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 818: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE

814:
815:
816: PROCEDURE validate_acct_sources(
817: p_api_version IN NUMBER
818: ,p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE
819: ,x_return_status OUT NOCOPY VARCHAR2
820: ,x_msg_count OUT NOCOPY NUMBER
821: ,x_msg_data OUT NOCOPY VARCHAR2
822: ,p_asev_tbl IN asev_tbl_type

Line 888: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

884: WHEN Fnd_Api.G_EXC_ERROR THEN
885: ROLLBACK TO validate_acct_sources;
886: x_return_status := Fnd_Api.G_RET_STS_ERROR;
887:
888: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);
891:
892: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 895: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

891:
892: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
893: ROLLBACK TO validate_acct_sources;
894: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
895: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
896: ,p_count => x_msg_count
897: ,p_data => x_msg_data);
898:
899: WHEN OTHERS THEN

Line 902: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

898:
899: WHEN OTHERS THEN
900: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','validate_acct_sources');
901: -- store SQL error message on message stack for caller
902: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);
905: -- notify caller of an UNEXPECTED error
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

Line 911: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

907: END validate_acct_sources;
908:
909: PROCEDURE update_acct_src_custom_status(
910: p_api_version IN NUMBER,
911: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
912: x_return_status OUT NOCOPY VARCHAR2,
913: x_msg_count OUT NOCOPY NUMBER,
914: x_msg_data OUT NOCOPY VARCHAR2,
915: p_asev_rec IN asev_rec_type,

Line 960: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

956: WHEN Fnd_Api.G_EXC_ERROR THEN
957: ROLLBACK TO update_acct_src_custom_status;
958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
959:
960: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
961: ,p_count => x_msg_count
962: ,p_data => x_msg_data);
963:
964: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

Line 967: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

963:
964: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
965: ROLLBACK TO update_acct_src_custom_status;
966: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
967: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
968: ,p_count => x_msg_count
969: ,p_data => x_msg_data);
970:
971: WHEN OTHERS THEN

Line 974: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

970:
971: WHEN OTHERS THEN
972: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');
973: -- store SQL error message on message stack for caller
974: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
975: ,p_count => x_msg_count
976: ,p_data => x_msg_data);
977: -- notify caller of an UNEXPECTED error
978: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;