DBA Data[Home] [Help]

APPS.OKL_SIF_TRX_PARMS_PUB dependencies on FND_MSG_PUB

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

52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_trx_parms;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_trx_parms;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
67: WHEN OTHERS THEN

Line 68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');

64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);

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

66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73: -- notify caller of an UNEXPECTED error
74: 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_sif_trx_parms;
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_sif_trx_parms;
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_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');

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_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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_SIF_TRX_PARMS_PUB','insert_sif_trx_parms');
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 205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_trx_parms;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
206: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_trx_parms;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN

Line 217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');

213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
218: -- store SQL error message on message stack for caller
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);

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

215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
218: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_trx_parms;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_trx_parms;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN

Line 297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');

293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
298: -- store SQL error message on message stack for caller
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);

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

295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','lock_sif_trx_parms');
298: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_sif_trx_parms;
349: x_return_status := FND_API.G_RET_STS_ERROR;
350:
351: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
352: ,p_count => x_msg_count
353: ,p_data => x_msg_data);
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO update_sif_trx_parms;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN

Line 363: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');

359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362: WHEN OTHERS THEN
363: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
364: -- store SQL error message on message stack for caller
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);

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

361:
362: WHEN OTHERS THEN
363: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
364: -- store SQL error message on message stack for caller
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);
368: -- notify caller of an UNEXPECTED error
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

438: WHEN FND_API.G_EXC_ERROR THEN
439: ROLLBACK TO update_sif_trx_parms;
440: x_return_status := FND_API.G_RET_STS_ERROR;
441:
442: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
443: ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

445:
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: ROLLBACK TO update_sif_trx_parms;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
450: ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452:
453: WHEN OTHERS THEN

Line 454: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');

450: ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452:
453: WHEN OTHERS THEN
454: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
455: -- store SQL error message on message stack for caller
456: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
457: ,p_count => x_msg_count
458: ,p_data => x_msg_data);

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

452:
453: WHEN OTHERS THEN
454: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','update_sif_trx_parms');
455: -- store SQL error message on message stack for caller
456: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
457: ,p_count => x_msg_count
458: ,p_data => x_msg_data);
459: -- notify caller of an UNEXPECTED error
460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

502: WHEN FND_API.G_EXC_ERROR THEN
503: ROLLBACK TO delete_sif_trx_parms;
504: x_return_status := FND_API.G_RET_STS_ERROR;
505:
506: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
507: ,p_count => x_msg_count
508: ,p_data => x_msg_data);
509:
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

509:
510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
511: ROLLBACK TO delete_sif_trx_parms;
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
514: ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516:
517: WHEN OTHERS THEN

Line 518: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');

514: ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516:
517: WHEN OTHERS THEN
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
519: -- store SQL error message on message stack for caller
520: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
521: ,p_count => x_msg_count
522: ,p_data => x_msg_data);

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

516:
517: WHEN OTHERS THEN
518: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
519: -- store SQL error message on message stack for caller
520: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
521: ,p_count => x_msg_count
522: ,p_data => x_msg_data);
523: -- notify caller of an UNEXPECTED error
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

593: WHEN FND_API.G_EXC_ERROR THEN
594: ROLLBACK TO delete_sif_trx_parms;
595: x_return_status := FND_API.G_RET_STS_ERROR;
596:
597: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
598: ,p_count => x_msg_count
599: ,p_data => x_msg_data);
600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

600:
601: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
602: ROLLBACK TO delete_sif_trx_parms;
603: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);
607:
608: WHEN OTHERS THEN

Line 609: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');

605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);
607:
608: WHEN OTHERS THEN
609: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
610: -- store SQL error message on message stack for caller
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);

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

607:
608: WHEN OTHERS THEN
609: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','delete_sif_trx_parms');
610: -- store SQL error message on message stack for caller
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614: -- notify caller of an UNEXPECTED error
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

657: WHEN FND_API.G_EXC_ERROR THEN
658: ROLLBACK TO validate_sif_trx_parms;
659: x_return_status := FND_API.G_RET_STS_ERROR;
660:
661: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
662: ,p_count => x_msg_count
663: ,p_data => x_msg_data);
664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

664:
665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
666: ROLLBACK TO validate_sif_trx_parms;
667: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN OTHERS THEN

Line 673: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');

669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
674: -- store SQL error message on message stack for caller
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);

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

671:
672: WHEN OTHERS THEN
673: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
674: -- store SQL error message on message stack for caller
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data);
678: -- notify caller of an UNEXPECTED error
679: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

749: WHEN FND_API.G_EXC_ERROR THEN
750: ROLLBACK TO validate_sif_trx_parms;
751: x_return_status := FND_API.G_RET_STS_ERROR;
752:
753: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
754: ,p_count => x_msg_count
755: ,p_data => x_msg_data);
756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

756:
757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
758: ROLLBACK TO validate_sif_trx_parms;
759: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
760: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763:
764: WHEN OTHERS THEN

Line 765: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');

761: ,p_count => x_msg_count
762: ,p_data => x_msg_data);
763:
764: WHEN OTHERS THEN
765: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
766: -- store SQL error message on message stack for caller
767: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
768: ,p_count => x_msg_count
769: ,p_data => x_msg_data);

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

763:
764: WHEN OTHERS THEN
765: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_TRX_PARMS_PUB','validate_sif_trx_parms');
766: -- store SQL error message on message stack for caller
767: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
768: ,p_count => x_msg_count
769: ,p_data => x_msg_data);
770: -- notify caller of an UNEXPECTED error
771: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;