DBA Data[Home] [Help]

APPS.OKL_ACCT_SOURCES_PVT dependencies on FND_MSG_PUB

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 61: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');

57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
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);

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 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 159: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources');

155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
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);

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 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 233: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','insert_acct_sources_bulk');

229: ,p_count => x_msg_count
230: ,p_data => x_msg_data);
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);

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 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 292: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','lock_acct_sources');

288: ,p_count => x_msg_count
289: ,p_data => x_msg_data);
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);

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 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 372: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','lock_acct_sources');

368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
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);

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 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 444: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');

440: ,p_count => x_msg_count
441: ,p_data => x_msg_data);
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);

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 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 542: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');

538: ,p_count => x_msg_count
539: ,p_data => x_msg_data);
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);

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 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 646: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');

642: ,p_count => x_msg_count
643: ,p_data => x_msg_data);
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);

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 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 739: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','delete_acct_sources');

735: ,p_count => x_msg_count
736: ,p_data => x_msg_data);
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);

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 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 806: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','validate_acct_sources');

802: ,p_count => x_msg_count
803: ,p_data => x_msg_data);
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);

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 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 900: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','validate_acct_sources');

896: ,p_count => x_msg_count
897: ,p_data => x_msg_data);
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);

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 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 972: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_acct_sources_Pvt','update_acct_sources');

968: ,p_count => x_msg_count
969: ,p_data => x_msg_data);
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);

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;