DBA Data[Home] [Help]

APPS.OKL_ITM_CAT_RV_PRCS_PUB dependencies on FND_MSG_PUB

Line 25: FND_MSG_PUB.initialize;

21: SAVEPOINT l_program_name;
22: END IF;
23:
24: IF p_init_msg_list = OKL_API.G_TRUE THEN
25: FND_MSG_PUB.initialize;
26: END IF;
27:
28: okl_icp_pvt.insert_row(p_api_version => G_API_VERSION,
29: p_init_msg_list => G_FALSE,

Line 50: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

46: WHEN OKL_API.G_EXCEPTION_ERROR THEN
47:
48: IF p_transaction_control = G_TRUE THEN
49: ROLLBACK TO l_program_name;
50: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
51: END IF;
52:
53: x_return_status := G_RET_STS_ERROR;
54:

Line 59: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

55: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
56:
57: IF p_transaction_control = G_TRUE THEN
58: ROLLBACK TO l_program_name;
59: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
60: END IF;
61:
62: x_return_status := G_RET_STS_UNEXP_ERROR;
63:

Line 77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

73: p_token3_value => sqlerrm);
74:
75: IF p_transaction_control = G_TRUE THEN
76: ROLLBACK TO l_program_name;
77: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
78: END IF;
79:
80: x_return_status := G_RET_STS_UNEXP_ERROR;
81:

Line 106: FND_MSG_PUB.initialize;

102: SAVEPOINT l_program_name;
103: END IF;
104:
105: IF p_init_msg_list = OKL_API.G_TRUE THEN
106: FND_MSG_PUB.initialize;
107: END IF;
108:
109: okl_icp_pvt.insert_row(p_api_version => G_API_VERSION,
110: p_init_msg_list => G_FALSE,

Line 131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

127: WHEN OKL_API.G_EXCEPTION_ERROR THEN
128:
129: IF p_transaction_control = G_TRUE THEN
130: ROLLBACK TO l_program_name;
131: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
132: END IF;
133:
134: x_return_status := G_RET_STS_ERROR;
135:

Line 140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

136: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
137:
138: IF p_transaction_control = G_TRUE THEN
139: ROLLBACK TO l_program_name;
140: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
141: END IF;
142:
143: x_return_status := G_RET_STS_UNEXP_ERROR;
144:

Line 158: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

154: p_token3_value => sqlerrm);
155:
156: IF p_transaction_control = G_TRUE THEN
157: ROLLBACK TO l_program_name;
158: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
159: END IF;
160:
161: x_return_status := G_RET_STS_UNEXP_ERROR;
162:

Line 186: FND_MSG_PUB.initialize;

182: SAVEPOINT l_program_name;
183: END IF;
184:
185: IF p_init_msg_list = OKL_API.G_TRUE THEN
186: FND_MSG_PUB.initialize;
187: END IF;
188:
189: okl_icp_pvt.lock_row(p_api_version => G_API_VERSION,
190: p_init_msg_list => G_FALSE,

Line 210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

206: WHEN OKL_API.G_EXCEPTION_ERROR THEN
207:
208: IF p_transaction_control = G_TRUE THEN
209: ROLLBACK TO l_program_name;
210: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
211: END IF;
212:
213: x_return_status := G_RET_STS_ERROR;
214:

Line 219: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

215: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
216:
217: IF p_transaction_control = G_TRUE THEN
218: ROLLBACK TO l_program_name;
219: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
220: END IF;
221:
222: x_return_status := G_RET_STS_UNEXP_ERROR;
223:

Line 237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

233: p_token3_value => sqlerrm);
234:
235: IF p_transaction_control = G_TRUE THEN
236: ROLLBACK TO l_program_name;
237: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
238: END IF;
239:
240: x_return_status := G_RET_STS_UNEXP_ERROR;
241:

Line 265: FND_MSG_PUB.initialize;

261: SAVEPOINT l_program_name;
262: END IF;
263:
264: IF p_init_msg_list = OKL_API.G_TRUE THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267:
268: okl_icp_pvt.lock_row(p_api_version => G_API_VERSION,
269: p_init_msg_list => G_FALSE,

Line 289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

285: WHEN OKL_API.G_EXCEPTION_ERROR THEN
286:
287: IF p_transaction_control = G_TRUE THEN
288: ROLLBACK TO l_program_name;
289: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
290: END IF;
291:
292: x_return_status := G_RET_STS_ERROR;
293:

Line 298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

294: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
295:
296: IF p_transaction_control = G_TRUE THEN
297: ROLLBACK TO l_program_name;
298: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
299: END IF;
300:
301: x_return_status := G_RET_STS_UNEXP_ERROR;
302:

Line 316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

312: p_token3_value => sqlerrm);
313:
314: IF p_transaction_control = G_TRUE THEN
315: ROLLBACK TO l_program_name;
316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
317: END IF;
318:
319: x_return_status := G_RET_STS_UNEXP_ERROR;
320:

Line 345: FND_MSG_PUB.initialize;

341: SAVEPOINT l_program_name;
342: END IF;
343:
344: IF p_init_msg_list = OKL_API.G_TRUE THEN
345: FND_MSG_PUB.initialize;
346: END IF;
347:
348: okl_icp_pvt.update_row(p_api_version => G_API_VERSION,
349: p_init_msg_list => G_FALSE,

Line 370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

366: WHEN OKL_API.G_EXCEPTION_ERROR THEN
367:
368: IF p_transaction_control = G_TRUE THEN
369: ROLLBACK TO l_program_name;
370: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
371: END IF;
372:
373: x_return_status := G_RET_STS_ERROR;
374:

Line 379: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

375: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
376:
377: IF p_transaction_control = G_TRUE THEN
378: ROLLBACK TO l_program_name;
379: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
380: END IF;
381:
382: x_return_status := G_RET_STS_UNEXP_ERROR;
383:

Line 397: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

393: p_token3_value => sqlerrm);
394:
395: IF p_transaction_control = G_TRUE THEN
396: ROLLBACK TO l_program_name;
397: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
398: END IF;
399:
400: x_return_status := G_RET_STS_UNEXP_ERROR;
401:

Line 426: FND_MSG_PUB.initialize;

422: SAVEPOINT l_program_name;
423: END IF;
424:
425: IF p_init_msg_list = OKL_API.G_TRUE THEN
426: FND_MSG_PUB.initialize;
427: END IF;
428:
429: okl_icp_pvt.update_row(p_api_version => G_API_VERSION,
430: p_init_msg_list => G_FALSE,

Line 451: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

447: WHEN OKL_API.G_EXCEPTION_ERROR THEN
448:
449: IF p_transaction_control = G_TRUE THEN
450: ROLLBACK TO l_program_name;
451: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
452: END IF;
453:
454: x_return_status := G_RET_STS_ERROR;
455:

Line 460: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

456: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
457:
458: IF p_transaction_control = G_TRUE THEN
459: ROLLBACK TO l_program_name;
460: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
461: END IF;
462:
463: x_return_status := G_RET_STS_UNEXP_ERROR;
464:

Line 478: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

474: p_token3_value => sqlerrm);
475:
476: IF p_transaction_control = G_TRUE THEN
477: ROLLBACK TO l_program_name;
478: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
479: END IF;
480:
481: x_return_status := G_RET_STS_UNEXP_ERROR;
482:

Line 506: FND_MSG_PUB.initialize;

502: SAVEPOINT l_program_name;
503: END IF;
504:
505: IF p_init_msg_list = OKL_API.G_TRUE THEN
506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: okl_icp_pvt.delete_row(p_api_version => G_API_VERSION,
510: p_init_msg_list => G_FALSE,

Line 530: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

526: WHEN OKL_API.G_EXCEPTION_ERROR THEN
527:
528: IF p_transaction_control = G_TRUE THEN
529: ROLLBACK TO l_program_name;
530: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
531: END IF;
532:
533: x_return_status := G_RET_STS_ERROR;
534:

Line 539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

535: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
536:
537: IF p_transaction_control = G_TRUE THEN
538: ROLLBACK TO l_program_name;
539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
540: END IF;
541:
542: x_return_status := G_RET_STS_UNEXP_ERROR;
543:

Line 557: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

553: p_token3_value => sqlerrm);
554:
555: IF p_transaction_control = G_TRUE THEN
556: ROLLBACK TO l_program_name;
557: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
558: END IF;
559:
560: x_return_status := G_RET_STS_UNEXP_ERROR;
561:

Line 585: FND_MSG_PUB.initialize;

581: SAVEPOINT l_program_name;
582: END IF;
583:
584: IF p_init_msg_list = OKL_API.G_TRUE THEN
585: FND_MSG_PUB.initialize;
586: END IF;
587:
588: okl_icp_pvt.delete_row(p_api_version => G_API_VERSION,
589: p_init_msg_list => G_FALSE,

Line 609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

605: WHEN OKL_API.G_EXCEPTION_ERROR THEN
606:
607: IF p_transaction_control = G_TRUE THEN
608: ROLLBACK TO l_program_name;
609: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
610: END IF;
611:
612: x_return_status := G_RET_STS_ERROR;
613:

Line 618: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

614: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
615:
616: IF p_transaction_control = G_TRUE THEN
617: ROLLBACK TO l_program_name;
618: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
619: END IF;
620:
621: x_return_status := G_RET_STS_UNEXP_ERROR;
622:

Line 636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

632: p_token3_value => sqlerrm);
633:
634: IF p_transaction_control = G_TRUE THEN
635: ROLLBACK TO l_program_name;
636: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
637: END IF;
638:
639: x_return_status := G_RET_STS_UNEXP_ERROR;
640:

Line 664: FND_MSG_PUB.initialize;

660: SAVEPOINT l_program_name;
661: END IF;
662:
663: IF p_init_msg_list = OKL_API.G_TRUE THEN
664: FND_MSG_PUB.initialize;
665: END IF;
666:
667: okl_icp_pvt.validate_row(p_api_version => G_API_VERSION,
668: p_init_msg_list => G_FALSE,

Line 688: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

684: WHEN OKL_API.G_EXCEPTION_ERROR THEN
685:
686: IF p_transaction_control = G_TRUE THEN
687: ROLLBACK TO l_program_name;
688: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
689: END IF;
690:
691: x_return_status := G_RET_STS_ERROR;
692:

Line 697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

693: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
694:
695: IF p_transaction_control = G_TRUE THEN
696: ROLLBACK TO l_program_name;
697: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
698: END IF;
699:
700: x_return_status := G_RET_STS_UNEXP_ERROR;
701:

Line 715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

711: p_token3_value => sqlerrm);
712:
713: IF p_transaction_control = G_TRUE THEN
714: ROLLBACK TO l_program_name;
715: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
716: END IF;
717:
718: x_return_status := G_RET_STS_UNEXP_ERROR;
719:

Line 743: FND_MSG_PUB.initialize;

739: SAVEPOINT l_program_name;
740: END IF;
741:
742: IF p_init_msg_list = OKL_API.G_TRUE THEN
743: FND_MSG_PUB.initialize;
744: END IF;
745:
746: okl_icp_pvt.validate_row(p_api_version => G_API_VERSION,
747: p_init_msg_list => G_FALSE,

Line 767: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

763: WHEN OKL_API.G_EXCEPTION_ERROR THEN
764:
765: IF p_transaction_control = G_TRUE THEN
766: ROLLBACK TO l_program_name;
767: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
768: END IF;
769:
770: x_return_status := G_RET_STS_ERROR;
771:

Line 776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

772: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
773:
774: IF p_transaction_control = G_TRUE THEN
775: ROLLBACK TO l_program_name;
776: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
777: END IF;
778:
779: x_return_status := G_RET_STS_UNEXP_ERROR;
780:

Line 794: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

790: p_token3_value => sqlerrm);
791:
792: IF p_transaction_control = G_TRUE THEN
793: ROLLBACK TO l_program_name;
794: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
795: END IF;
796:
797: x_return_status := G_RET_STS_UNEXP_ERROR;
798: