DBA Data[Home] [Help]

APPS.OKL_FUNDING_PUB dependencies on FND_MSG_PUB

Line 77: FND_MSG_PUB.initialize;

73: END IF;
74:
75: -- Initialize message list if requested
76: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
77: FND_MSG_PUB.initialize;
78: END IF;
79:
80: -- Initialize API status to success
81: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 111: FND_MSG_PUB.Count_And_Get

107: /*
108:
109: */
110: -- Get message count and if count is 1, get message info
111: FND_MSG_PUB.Count_And_Get
112: (p_count => x_msg_count,
113: p_data => x_msg_data);
114:
115: EXCEPTION

Line 119: FND_MSG_PUB.Count_And_Get

115: EXCEPTION
116: WHEN OKL_API.G_EXCEPTION_ERROR THEN
117: ROLLBACK TO CREATE_FUNDING_HEADER_PUB;
118: x_return_status := OKL_API.G_RET_STS_ERROR;
119: FND_MSG_PUB.Count_And_Get
120: (p_count => x_msg_count,
121: p_data => x_msg_data);
122:
123: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 126: FND_MSG_PUB.Count_And_Get

122:
123: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
124: ROLLBACK TO CREATE_FUNDING_HEADER_PUB;
125: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get
127: (p_count => x_msg_count,
128: p_data => x_msg_data);
129:
130: WHEN OTHERS THEN

Line 139: FND_MSG_PUB.Count_And_Get

135: p_token1 => G_SQLCODE_TOKEN,
136: p_token1_value => SQLCODE,
137: p_token2 => G_SQLERRM_TOKEN,
138: p_token2_value => SQLERRM);
139: FND_MSG_PUB.Count_And_Get
140: (p_count => x_msg_count,
141: p_data => x_msg_data);
142:
143: END create_funding_header;

Line 177: FND_MSG_PUB.initialize;

173: END IF;
174:
175: -- Initialize message list if requested
176: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
177: FND_MSG_PUB.initialize;
178: END IF;
179:
180: -- Initialize API status to success
181: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 211: FND_MSG_PUB.Count_And_Get

207: /*
208:
209: */
210: -- Get message count and if count is 1, get message info
211: FND_MSG_PUB.Count_And_Get
212: (p_count => x_msg_count,
213: p_data => x_msg_data);
214:
215: EXCEPTION

Line 219: FND_MSG_PUB.Count_And_Get

215: EXCEPTION
216: WHEN OKL_API.G_EXCEPTION_ERROR THEN
217: ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
218: x_return_status := OKL_API.G_RET_STS_ERROR;
219: FND_MSG_PUB.Count_And_Get
220: (p_count => x_msg_count,
221: p_data => x_msg_data);
222:
223: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 226: FND_MSG_PUB.Count_And_Get

222:
223: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
224: ROLLBACK TO UPDATE_FUNDING_HEADER_PUB;
225: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_And_Get
227: (p_count => x_msg_count,
228: p_data => x_msg_data);
229:
230: WHEN OTHERS THEN

Line 239: FND_MSG_PUB.Count_And_Get

235: p_token1 => G_SQLCODE_TOKEN,
236: p_token1_value => SQLCODE,
237: p_token2 => G_SQLERRM_TOKEN,
238: p_token2_value => SQLERRM);
239: FND_MSG_PUB.Count_And_Get
240: (p_count => x_msg_count,
241: p_data => x_msg_data);
242:
243: END update_funding_header;

Line 274: FND_MSG_PUB.initialize;

270: END IF;
271:
272: -- Initialize message list if requested
273: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
274: FND_MSG_PUB.initialize;
275: END IF;
276:
277: -- Initialize API status to success
278: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 307: FND_MSG_PUB.Count_And_Get

303: /*
304:
305: */
306: -- Get message count and if count is 1, get message info
307: FND_MSG_PUB.Count_And_Get
308: (p_count => x_msg_count,
309: p_data => x_msg_data);
310:
311: EXCEPTION

Line 315: FND_MSG_PUB.Count_And_Get

311: EXCEPTION
312: WHEN OKL_API.G_EXCEPTION_ERROR THEN
313: ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
314: x_return_status := OKL_API.G_RET_STS_ERROR;
315: FND_MSG_PUB.Count_And_Get
316: (p_count => x_msg_count,
317: p_data => x_msg_data);
318:
319: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 322: FND_MSG_PUB.Count_And_Get

318:
319: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
320: ROLLBACK TO DELETE_FUNDING_HEADER_PUB;
321: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
322: FND_MSG_PUB.Count_And_Get
323: (p_count => x_msg_count,
324: p_data => x_msg_data);
325:
326: WHEN OTHERS THEN

Line 335: FND_MSG_PUB.Count_And_Get

331: p_token1 => G_SQLCODE_TOKEN,
332: p_token1_value => SQLCODE,
333: p_token2 => G_SQLERRM_TOKEN,
334: p_token2_value => SQLERRM);
335: FND_MSG_PUB.Count_And_Get
336: (p_count => x_msg_count,
337: p_data => x_msg_data);
338:
339: END delete_funding_header;

Line 373: FND_MSG_PUB.initialize;

369: END IF;
370:
371: -- Initialize message list if requested
372: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
373: FND_MSG_PUB.initialize;
374: END IF;
375:
376: -- Initialize API status to success
377: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 407: FND_MSG_PUB.Count_And_Get

403: /*
404:
405: */
406: -- Get message count and if count is 1, get message info
407: FND_MSG_PUB.Count_And_Get
408: (p_count => x_msg_count,
409: p_data => x_msg_data);
410:
411: EXCEPTION

Line 415: FND_MSG_PUB.Count_And_Get

411: EXCEPTION
412: WHEN OKL_API.G_EXCEPTION_ERROR THEN
413: ROLLBACK TO CREATE_FUNDING_LINES_PUB;
414: x_return_status := OKL_API.G_RET_STS_ERROR;
415: FND_MSG_PUB.Count_And_Get
416: (p_count => x_msg_count,
417: p_data => x_msg_data);
418:
419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 422: FND_MSG_PUB.Count_And_Get

418:
419: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
420: ROLLBACK TO CREATE_FUNDING_LINES_PUB;
421: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
422: FND_MSG_PUB.Count_And_Get
423: (p_count => x_msg_count,
424: p_data => x_msg_data);
425:
426: WHEN OTHERS THEN

Line 435: FND_MSG_PUB.Count_And_Get

431: p_token1 => G_SQLCODE_TOKEN,
432: p_token1_value => SQLCODE,
433: p_token2 => G_SQLERRM_TOKEN,
434: p_token2_value => SQLERRM);
435: FND_MSG_PUB.Count_And_Get
436: (p_count => x_msg_count,
437: p_data => x_msg_data);
438:
439: END create_funding_lines;

Line 478: FND_MSG_PUB.initialize;

474: END IF;
475:
476: -- Initialize message list if requested
477: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481: -- Initialize API status to success
482: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 514: FND_MSG_PUB.Count_And_Get

510: /*
511:
512: */
513: -- Get message count and if count is 1, get message info
514: FND_MSG_PUB.Count_And_Get
515: (p_count => x_msg_count,
516: p_data => x_msg_data);
517:
518: EXCEPTION

Line 522: FND_MSG_PUB.Count_And_Get

518: EXCEPTION
519: WHEN OKL_API.G_EXCEPTION_ERROR THEN
520: ROLLBACK TO CREATE_FUNDING_LINES_PUB;
521: x_return_status := OKL_API.G_RET_STS_ERROR;
522: FND_MSG_PUB.Count_And_Get
523: (p_count => x_msg_count,
524: p_data => x_msg_data);
525:
526: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 529: FND_MSG_PUB.Count_And_Get

525:
526: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
527: ROLLBACK TO CREATE_FUNDING_LINES_PUB;
528: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
529: FND_MSG_PUB.Count_And_Get
530: (p_count => x_msg_count,
531: p_data => x_msg_data);
532:
533: WHEN OTHERS THEN

Line 542: FND_MSG_PUB.Count_And_Get

538: p_token1 => G_SQLCODE_TOKEN,
539: p_token1_value => SQLCODE,
540: p_token2 => G_SQLERRM_TOKEN,
541: p_token2_value => SQLERRM);
542: FND_MSG_PUB.Count_And_Get
543: (p_count => x_msg_count,
544: p_data => x_msg_data);
545:
546: END create_funding_lines;

Line 584: FND_MSG_PUB.initialize;

580: END IF;
581:
582: -- Initialize message list if requested
583: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586:
587: -- Initialize API status to success
588: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 618: FND_MSG_PUB.Count_And_Get

614: /*
615:
616: */
617: -- Get message count and if count is 1, get message info
618: FND_MSG_PUB.Count_And_Get
619: (p_count => x_msg_count,
620: p_data => x_msg_data);
621:
622: EXCEPTION

Line 626: FND_MSG_PUB.Count_And_Get

622: EXCEPTION
623: WHEN OKL_API.G_EXCEPTION_ERROR THEN
624: ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
625: x_return_status := OKL_API.G_RET_STS_ERROR;
626: FND_MSG_PUB.Count_And_Get
627: (p_count => x_msg_count,
628: p_data => x_msg_data);
629:
630: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 633: FND_MSG_PUB.Count_And_Get

629:
630: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
631: ROLLBACK TO UPDATE_FUNDING_LINES_PUB;
632: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.Count_And_Get
634: (p_count => x_msg_count,
635: p_data => x_msg_data);
636:
637: WHEN OTHERS THEN

Line 646: FND_MSG_PUB.Count_And_Get

642: p_token1 => G_SQLCODE_TOKEN,
643: p_token1_value => SQLCODE,
644: p_token2 => G_SQLERRM_TOKEN,
645: p_token2_value => SQLERRM);
646: FND_MSG_PUB.Count_And_Get
647: (p_count => x_msg_count,
648: p_data => x_msg_data);
649:
650: END update_funding_lines;

Line 689: FND_MSG_PUB.initialize;

685: END IF;
686:
687: -- Initialize message list if requested
688: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
689: FND_MSG_PUB.initialize;
690: END IF;
691:
692: -- Initialize API status to success
693: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 744: FND_MSG_PUB.Count_And_Get

740: /*
741:
742: */
743: -- Get message count and if count is 1, get message info
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count,
746: p_data => x_msg_data);
747:
748: EXCEPTION

Line 752: FND_MSG_PUB.Count_And_Get

748: EXCEPTION
749: WHEN OKL_API.G_EXCEPTION_ERROR THEN
750: ROLLBACK TO DELETE_FUNDING_LINES_PUB;
751: x_return_status := OKL_API.G_RET_STS_ERROR;
752: FND_MSG_PUB.Count_And_Get
753: (p_count => x_msg_count,
754: p_data => x_msg_data);
755:
756: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 759: FND_MSG_PUB.Count_And_Get

755:
756: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
757: ROLLBACK TO DELETE_FUNDING_LINES_PUB;
758: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_And_Get
760: (p_count => x_msg_count,
761: p_data => x_msg_data);
762:
763: WHEN OTHERS THEN

Line 772: FND_MSG_PUB.Count_And_Get

768: p_token1 => G_SQLCODE_TOKEN,
769: p_token1_value => SQLCODE,
770: p_token2 => G_SQLERRM_TOKEN,
771: p_token2_value => SQLERRM);
772: FND_MSG_PUB.Count_And_Get
773: (p_count => x_msg_count,
774: p_data => x_msg_data);
775:
776: END delete_funding_lines;

Line 807: FND_MSG_PUB.initialize;

803: END IF;
804:
805: -- Initialize message list if requested
806: IF (FND_API.to_Boolean(p_init_msg_list)) THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:
810: -- Initialize API status to success
811: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 833: FND_MSG_PUB.Count_And_Get

829:
830: /*** End API body ******************************************************/
831:
832: -- Get message count and if count is 1, get message info
833: FND_MSG_PUB.Count_And_Get
834: (p_count => x_msg_count,
835: p_data => x_msg_data);
836:
837: EXCEPTION

Line 841: FND_MSG_PUB.Count_And_Get

837: EXCEPTION
838: WHEN OKL_API.G_EXCEPTION_ERROR THEN
839: ROLLBACK TO CREATE_FUNDING_ASSETS_PUB;
840: x_return_status := OKL_API.G_RET_STS_ERROR;
841: FND_MSG_PUB.Count_And_Get
842: (p_count => x_msg_count,
843: p_data => x_msg_data);
844:
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 848: FND_MSG_PUB.Count_And_Get

844:
845: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
846: ROLLBACK TO CREATE_FUNDING_ASSETS_PUB;
847: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
848: FND_MSG_PUB.Count_And_Get
849: (p_count => x_msg_count,
850: p_data => x_msg_data);
851:
852: WHEN OTHERS THEN

Line 861: FND_MSG_PUB.Count_And_Get

857: p_token1 => G_SQLCODE_TOKEN,
858: p_token1_value => SQLCODE,
859: p_token2 => G_SQLERRM_TOKEN,
860: p_token2_value => SQLERRM);
861: FND_MSG_PUB.Count_And_Get
862: (p_count => x_msg_count,
863: p_data => x_msg_data);
864:
865: END create_funding_assets;