DBA Data[Home] [Help]

APPS.OKL_SGN_TRANSLATIONS_PUB dependencies on FND_MSG_PUB

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

50: WHEN FND_API.G_EXC_ERROR THEN
51: ROLLBACK TO insert_sgn_translations;
52: x_return_status := FND_API.G_RET_STS_ERROR;
53:
54: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
55: ,p_count => x_msg_count
56: ,p_data => x_msg_data);
57:
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

57:
58: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
59: ROLLBACK TO insert_sgn_translations;
60: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
61: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
62: ,p_count => x_msg_count
63: ,p_data => x_msg_data);
64:
65: WHEN OTHERS THEN

Line 66: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');

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

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

64:
65: WHEN OTHERS THEN
66: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
67: -- store SQL error message on message stack for caller
68: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
69: ,p_count => x_msg_count
70: ,p_data => x_msg_data);
71: -- notify caller of an UNEXPECTED error
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

140: WHEN FND_API.G_EXC_ERROR THEN
141: ROLLBACK TO insert_sgn_translations;
142: x_return_status := FND_API.G_RET_STS_ERROR;
143:
144: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
145: ,p_count => x_msg_count
146: ,p_data => x_msg_data);
147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

147:
148: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
149: ROLLBACK TO insert_sgn_translations;
150: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN OTHERS THEN

Line 156: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');

152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN OTHERS THEN
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);

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

154:
155: WHEN OTHERS THEN
156: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','insert_sgn_translations');
157: -- store SQL error message on message stack for caller
158: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161: -- notify caller of an UNEXPECTED error
162: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

195: WHEN FND_API.G_EXC_ERROR THEN
196: ROLLBACK TO lock_sgn_translations;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198:
199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
200: ,p_count => x_msg_count
201: ,p_data => x_msg_data);
202:
203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 211: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');

207: ,p_count => x_msg_count
208: ,p_data => x_msg_data);
209:
210: WHEN OTHERS THEN
211: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
212: -- store SQL error message on message stack for caller
213: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
214: ,p_count => x_msg_count
215: ,p_data => x_msg_data);

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

209:
210: WHEN OTHERS THEN
211: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
212: -- store SQL error message on message stack for caller
213: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
214: ,p_count => x_msg_count
215: ,p_data => x_msg_data);
216: -- notify caller of an UNEXPECTED error
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO lock_sgn_translations;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275:
276: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
277: ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

279:
280: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
281: ROLLBACK TO lock_sgn_translations;
282: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
284: ,p_count => x_msg_count
285: ,p_data => x_msg_data);
286:
287: WHEN OTHERS THEN

Line 288: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');

284: ,p_count => x_msg_count
285: ,p_data => x_msg_data);
286:
287: WHEN OTHERS THEN
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
289: -- store SQL error message on message stack for caller
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);

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

286:
287: WHEN OTHERS THEN
288: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','lock_sgn_translations');
289: -- store SQL error message on message stack for caller
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);
293: -- notify caller of an UNEXPECTED error
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO update_sgn_translations;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338:
339: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
340: ,p_count => x_msg_count
341: ,p_data => x_msg_data);
342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

342:
343: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
344: ROLLBACK TO update_sgn_translations;
345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
346: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
347: ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349:
350: WHEN OTHERS THEN

Line 351: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');

347: ,p_count => x_msg_count
348: ,p_data => x_msg_data);
349:
350: WHEN OTHERS THEN
351: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
352: -- store SQL error message on message stack for caller
353: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
354: ,p_count => x_msg_count
355: ,p_data => x_msg_data);

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

349:
350: WHEN OTHERS THEN
351: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
352: -- store SQL error message on message stack for caller
353: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
354: ,p_count => x_msg_count
355: ,p_data => x_msg_data);
356: -- notify caller of an UNEXPECTED error
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO update_sgn_translations;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426:
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
428: ,p_count => x_msg_count
429: ,p_data => x_msg_data);
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO update_sgn_translations;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437:
438: WHEN OTHERS THEN

Line 439: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');

435: ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437:
438: WHEN OTHERS THEN
439: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
440: -- store SQL error message on message stack for caller
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);

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

437:
438: WHEN OTHERS THEN
439: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','update_sgn_translations');
440: -- store SQL error message on message stack for caller
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444: -- notify caller of an UNEXPECTED error
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

484: WHEN FND_API.G_EXC_ERROR THEN
485: ROLLBACK TO delete_sgn_translations;
486: x_return_status := FND_API.G_RET_STS_ERROR;
487:
488: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
489: ,p_count => x_msg_count
490: ,p_data => x_msg_data);
491:
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

491:
492: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
493: ROLLBACK TO delete_sgn_translations;
494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
495: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
498:
499: WHEN OTHERS THEN

Line 500: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');

496: ,p_count => x_msg_count
497: ,p_data => x_msg_data);
498:
499: WHEN OTHERS THEN
500: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
501: -- store SQL error message on message stack for caller
502: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
503: ,p_count => x_msg_count
504: ,p_data => x_msg_data);

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

498:
499: WHEN OTHERS THEN
500: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
501: -- store SQL error message on message stack for caller
502: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
503: ,p_count => x_msg_count
504: ,p_data => x_msg_data);
505: -- notify caller of an UNEXPECTED error
506: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

570: WHEN FND_API.G_EXC_ERROR THEN
571: ROLLBACK TO delete_sgn_translations;
572: x_return_status := FND_API.G_RET_STS_ERROR;
573:
574: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
575: ,p_count => x_msg_count
576: ,p_data => x_msg_data);
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO delete_sgn_translations;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
585: WHEN OTHERS THEN

Line 586: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');

582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
585: WHEN OTHERS THEN
586: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
587: -- store SQL error message on message stack for caller
588: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data);

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

584:
585: WHEN OTHERS THEN
586: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','delete_sgn_translations');
587: -- store SQL error message on message stack for caller
588: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data);
591: -- notify caller of an UNEXPECTED error
592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

631: WHEN FND_API.G_EXC_ERROR THEN
632: ROLLBACK TO validate_sgn_translations;
633: x_return_status := FND_API.G_RET_STS_ERROR;
634:
635: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
636: ,p_count => x_msg_count
637: ,p_data => x_msg_data);
638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

638:
639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
640: ROLLBACK TO validate_sgn_translations;
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
643: ,p_count => x_msg_count
644: ,p_data => x_msg_data);
645:
646: WHEN OTHERS THEN

Line 647: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');

643: ,p_count => x_msg_count
644: ,p_data => x_msg_data);
645:
646: WHEN OTHERS THEN
647: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
648: -- store SQL error message on message stack for caller
649: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
650: ,p_count => x_msg_count
651: ,p_data => x_msg_data);

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

645:
646: WHEN OTHERS THEN
647: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
648: -- store SQL error message on message stack for caller
649: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
650: ,p_count => x_msg_count
651: ,p_data => x_msg_data);
652: -- notify caller of an UNEXPECTED error
653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

719: WHEN FND_API.G_EXC_ERROR THEN
720: ROLLBACK TO validate_sgn_translations;
721: x_return_status := FND_API.G_RET_STS_ERROR;
722:
723: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
724: ,p_count => x_msg_count
725: ,p_data => x_msg_data);
726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

726:
727: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
728: ROLLBACK TO validate_sgn_translations;
729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
730: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
731: ,p_count => x_msg_count
732: ,p_data => x_msg_data);
733:
734: WHEN OTHERS THEN

Line 735: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');

731: ,p_count => x_msg_count
732: ,p_data => x_msg_data);
733:
734: WHEN OTHERS THEN
735: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
736: -- store SQL error message on message stack for caller
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);

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

733:
734: WHEN OTHERS THEN
735: FND_MSG_PUB.ADD_EXC_MSG('OKL_SGN_TRANSLATIONS_PUB','validate_sgn_translations');
736: -- store SQL error message on message stack for caller
737: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
738: ,p_count => x_msg_count
739: ,p_data => x_msg_data);
740: -- notify caller of an UNEXPECTED error
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;