DBA Data[Home] [Help]

APPS.OKL_SYS_ACCT_OPTS_PUB dependencies on FND_MSG_PUB

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

63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO insert_sys_acct_opts;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66:
67: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
68: ,p_count => x_msg_count
69: ,p_data => x_msg_data);
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: ROLLBACK TO insert_sys_acct_opts;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
75: ,p_count => x_msg_count
76: ,p_data => x_msg_data);
77:
78: WHEN OTHERS THEN

Line 79: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');

75: ,p_count => x_msg_count
76: ,p_data => x_msg_data);
77:
78: WHEN OTHERS THEN
79: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
80: -- store SQL error message on message stack for caller
81: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
82: ,p_count => x_msg_count
83: ,p_data => x_msg_data);

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

77:
78: WHEN OTHERS THEN
79: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
80: -- store SQL error message on message stack for caller
81: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
82: ,p_count => x_msg_count
83: ,p_data => x_msg_data);
84: -- notify caller of an UNEXPECTED error
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

157: WHEN FND_API.G_EXC_ERROR THEN
158: ROLLBACK TO insert_sys_acct_opts;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160:
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:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO insert_sys_acct_opts;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
169: ,p_count => x_msg_count
170: ,p_data => x_msg_data);
171:
172: WHEN OTHERS THEN

Line 173: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');

169: ,p_count => x_msg_count
170: ,p_data => x_msg_data);
171:
172: WHEN OTHERS THEN
173: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
174: -- store SQL error message on message stack for caller
175: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
176: ,p_count => x_msg_count
177: ,p_data => x_msg_data);

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

171:
172: WHEN OTHERS THEN
173: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','insert_sys_acct_opts');
174: -- store SQL error message on message stack for caller
175: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
176: ,p_count => x_msg_count
177: ,p_data => x_msg_data);
178: -- notify caller of an UNEXPECTED error
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO lock_sys_acct_opts;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218:
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO lock_sys_acct_opts;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
227: ,p_count => x_msg_count
228: ,p_data => x_msg_data);
229:
230: WHEN OTHERS THEN

Line 231: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');

227: ,p_count => x_msg_count
228: ,p_data => x_msg_data);
229:
230: WHEN OTHERS THEN
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');
232: -- store SQL error message on message stack for caller
233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);

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

229:
230: WHEN OTHERS THEN
231: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');
232: -- store SQL error message on message stack for caller
233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236: -- notify caller of an UNEXPECTED error
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO lock_sys_acct_opts;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298:
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO lock_sys_acct_opts;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
307: ,p_count => x_msg_count
308: ,p_data => x_msg_data);
309:
310: WHEN OTHERS THEN

Line 311: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');

307: ,p_count => x_msg_count
308: ,p_data => x_msg_data);
309:
310: WHEN OTHERS THEN
311: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');
312: -- store SQL error message on message stack for caller
313: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
314: ,p_count => x_msg_count
315: ,p_data => x_msg_data);

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

309:
310: WHEN OTHERS THEN
311: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','lock_sys_acct_opts');
312: -- store SQL error message on message stack for caller
313: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
314: ,p_count => x_msg_count
315: ,p_data => x_msg_data);
316: -- notify caller of an UNEXPECTED error
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO update_sys_acct_opts;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366:
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO update_sys_acct_opts;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
378: WHEN OTHERS THEN

Line 379: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');

375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);
377:
378: WHEN OTHERS THEN
379: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
380: -- store SQL error message on message stack for caller
381: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
382: ,p_count => x_msg_count
383: ,p_data => x_msg_data);

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

377:
378: WHEN OTHERS THEN
379: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
380: -- store SQL error message on message stack for caller
381: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
382: ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: -- notify caller of an UNEXPECTED error
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO update_sys_acct_opts;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460:
461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data);
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_sys_acct_opts;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471:
472: WHEN OTHERS THEN

Line 473: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');

469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471:
472: WHEN OTHERS THEN
473: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
474: -- store SQL error message on message stack for caller
475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);

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

471:
472: WHEN OTHERS THEN
473: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','update_sys_acct_opts');
474: -- store SQL error message on message stack for caller
475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: -- notify caller of an UNEXPECTED error
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

520: WHEN FND_API.G_EXC_ERROR THEN
521: ROLLBACK TO delete_sys_acct_opts;
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
525: ,p_count => x_msg_count
526: ,p_data => x_msg_data);
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO delete_sys_acct_opts;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
532: ,p_count => x_msg_count
533: ,p_data => x_msg_data);
534:
535: WHEN OTHERS THEN

Line 536: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');

532: ,p_count => x_msg_count
533: ,p_data => x_msg_data);
534:
535: WHEN OTHERS THEN
536: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
537: -- store SQL error message on message stack for caller
538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
539: ,p_count => x_msg_count
540: ,p_data => x_msg_data);

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

534:
535: WHEN OTHERS THEN
536: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
537: -- store SQL error message on message stack for caller
538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
539: ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: -- notify caller of an UNEXPECTED error
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

609: WHEN FND_API.G_EXC_ERROR THEN
610: ROLLBACK TO delete_sys_acct_opts;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612:
613: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
614: ,p_count => x_msg_count
615: ,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO delete_sys_acct_opts;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
621: ,p_count => x_msg_count
622: ,p_data => x_msg_data);
623:
624: WHEN OTHERS THEN

Line 625: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');

621: ,p_count => x_msg_count
622: ,p_data => x_msg_data);
623:
624: WHEN OTHERS THEN
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
626: -- store SQL error message on message stack for caller
627: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
628: ,p_count => x_msg_count
629: ,p_data => x_msg_data);

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

623:
624: WHEN OTHERS THEN
625: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','delete_sys_acct_opts');
626: -- store SQL error message on message stack for caller
627: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
628: ,p_count => x_msg_count
629: ,p_data => x_msg_data);
630: -- notify caller of an UNEXPECTED error
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO validate_sys_acct_opts;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675:
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:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO validate_sys_acct_opts;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
684: ,p_count => x_msg_count
685: ,p_data => x_msg_data);
686:
687: WHEN OTHERS THEN

Line 688: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');

684: ,p_count => x_msg_count
685: ,p_data => x_msg_data);
686:
687: WHEN OTHERS THEN
688: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');
689: -- store SQL error message on message stack for caller
690: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
691: ,p_count => x_msg_count
692: ,p_data => x_msg_data);

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

686:
687: WHEN OTHERS THEN
688: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');
689: -- store SQL error message on message stack for caller
690: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
691: ,p_count => x_msg_count
692: ,p_data => x_msg_data);
693: -- notify caller of an UNEXPECTED error
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO validate_sys_acct_opts;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: ROLLBACK TO validate_sys_acct_opts;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
774: ,p_count => x_msg_count
775: ,p_data => x_msg_data);
776:
777: WHEN OTHERS THEN

Line 778: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');

774: ,p_count => x_msg_count
775: ,p_data => x_msg_data);
776:
777: WHEN OTHERS THEN
778: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');
779: -- store SQL error message on message stack for caller
780: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
781: ,p_count => x_msg_count
782: ,p_data => x_msg_data);

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

776:
777: WHEN OTHERS THEN
778: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYS_ACCT_OPTS_PUB','validate_sys_acct_opts');
779: -- store SQL error message on message stack for caller
780: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
781: ,p_count => x_msg_count
782: ,p_data => x_msg_data);
783: -- notify caller of an UNEXPECTED error
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;