DBA Data[Home] [Help]

APPS.OKL_PDT_STYS_PUB dependencies on FND_MSG_PUB

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

54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO insert_pdt_stys;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57:
58: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
59: ,p_count => x_msg_count
60: ,p_data => x_msg_data);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO insert_pdt_stys;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:
69: WHEN OTHERS THEN

Line 70: FND_MSG_PUB.ADD_EXC_MSG('OKL_pdt_stys_PUB','insert_pdt_stys');

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

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

68:
69: WHEN OTHERS THEN
70: FND_MSG_PUB.ADD_EXC_MSG('OKL_pdt_stys_PUB','insert_pdt_stys');
71: -- store SQL error message on message stack for caller
72: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
73: ,p_count => x_msg_count
74: ,p_data => x_msg_data);
75: -- notify caller of an UNEXPECTED error
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO insert_pdt_stys;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:
163: WHEN OTHERS THEN

Line 164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','insert_pdt_stys');

160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:
163: WHEN OTHERS THEN
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','insert_pdt_stys');
165: -- store SQL error message on message stack for caller
166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);

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

162:
163: WHEN OTHERS THEN
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','insert_pdt_stys');
165: -- store SQL error message on message stack for caller
166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
169: -- notify caller of an UNEXPECTED error
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

206: WHEN FND_API.G_EXC_ERROR THEN
207: ROLLBACK TO lock_pdt_stys;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209:
210: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
211: ,p_count => x_msg_count
212: ,p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO lock_pdt_stys;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
218: ,p_count => x_msg_count
219: ,p_data => x_msg_data);
220:
221: WHEN OTHERS THEN

Line 222: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');

218: ,p_count => x_msg_count
219: ,p_data => x_msg_data);
220:
221: WHEN OTHERS THEN
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');
223: -- store SQL error message on message stack for caller
224: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
225: ,p_count => x_msg_count
226: ,p_data => x_msg_data);

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

220:
221: WHEN OTHERS THEN
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');
223: -- store SQL error message on message stack for caller
224: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
225: ,p_count => x_msg_count
226: ,p_data => x_msg_data);
227: -- notify caller of an UNEXPECTED error
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

286: WHEN FND_API.G_EXC_ERROR THEN
287: ROLLBACK TO lock_pdt_stys;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289:
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:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO lock_pdt_stys;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
298: ,p_count => x_msg_count
299: ,p_data => x_msg_data);
300:
301: WHEN OTHERS THEN

Line 302: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');

298: ,p_count => x_msg_count
299: ,p_data => x_msg_data);
300:
301: WHEN OTHERS THEN
302: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');
303: -- store SQL error message on message stack for caller
304: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
305: ,p_count => x_msg_count
306: ,p_data => x_msg_data);

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

300:
301: WHEN OTHERS THEN
302: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','lock_pdt_stys');
303: -- store SQL error message on message stack for caller
304: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
305: ,p_count => x_msg_count
306: ,p_data => x_msg_data);
307: -- notify caller of an UNEXPECTED error
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO update_pdt_stys;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357:
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO update_pdt_stys;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
369: WHEN OTHERS THEN

Line 370: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');

366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);
368:
369: WHEN OTHERS THEN
370: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
371: -- store SQL error message on message stack for caller
372: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
373: ,p_count => x_msg_count
374: ,p_data => x_msg_data);

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

368:
369: WHEN OTHERS THEN
370: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
371: -- store SQL error message on message stack for caller
372: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
373: ,p_count => x_msg_count
374: ,p_data => x_msg_data);
375: -- notify caller of an UNEXPECTED error
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

448: WHEN FND_API.G_EXC_ERROR THEN
449: ROLLBACK TO update_pdt_stys;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451:
452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
453: ,p_count => x_msg_count
454: ,p_data => x_msg_data);
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: ROLLBACK TO update_pdt_stys;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
460: ,p_count => x_msg_count
461: ,p_data => x_msg_data);
462:
463: WHEN OTHERS THEN

Line 464: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');

460: ,p_count => x_msg_count
461: ,p_data => x_msg_data);
462:
463: WHEN OTHERS THEN
464: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
465: -- store SQL error message on message stack for caller
466: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
467: ,p_count => x_msg_count
468: ,p_data => x_msg_data);

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

462:
463: WHEN OTHERS THEN
464: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','update_pdt_stys');
465: -- store SQL error message on message stack for caller
466: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
467: ,p_count => x_msg_count
468: ,p_data => x_msg_data);
469: -- notify caller of an UNEXPECTED error
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO delete_pdt_stys;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514:
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO delete_pdt_stys;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);
525:
526: WHEN OTHERS THEN

Line 527: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');

523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);
525:
526: WHEN OTHERS THEN
527: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
528: -- store SQL error message on message stack for caller
529: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
530: ,p_count => x_msg_count
531: ,p_data => x_msg_data);

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

525:
526: WHEN OTHERS THEN
527: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
528: -- store SQL error message on message stack for caller
529: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
530: ,p_count => x_msg_count
531: ,p_data => x_msg_data);
532: -- notify caller of an UNEXPECTED error
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

600: WHEN FND_API.G_EXC_ERROR THEN
601: ROLLBACK TO delete_pdt_stys;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603:
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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_pdt_stys;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
615: WHEN OTHERS THEN

Line 616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');

612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614:
615: WHEN OTHERS THEN
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
617: -- store SQL error message on message stack for caller
618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);

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

614:
615: WHEN OTHERS THEN
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','delete_pdt_stys');
617: -- store SQL error message on message stack for caller
618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);
621: -- notify caller of an UNEXPECTED error
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ROLLBACK TO validate_pdt_stys;
673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
677:
678: WHEN OTHERS THEN

Line 679: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');

675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
677:
678: WHEN OTHERS THEN
679: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');
680: -- store SQL error message on message stack for caller
681: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
682: ,p_count => x_msg_count
683: ,p_data => x_msg_data);

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

677:
678: WHEN OTHERS THEN
679: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');
680: -- store SQL error message on message stack for caller
681: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
682: ,p_count => x_msg_count
683: ,p_data => x_msg_data);
684: -- notify caller of an UNEXPECTED error
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO validate_pdt_stys;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756:
757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data);
760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO validate_pdt_stys;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
765: ,p_count => x_msg_count
766: ,p_data => x_msg_data);
767:
768: WHEN OTHERS THEN

Line 769: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');

765: ,p_count => x_msg_count
766: ,p_data => x_msg_data);
767:
768: WHEN OTHERS THEN
769: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');
770: -- store SQL error message on message stack for caller
771: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
772: ,p_count => x_msg_count
773: ,p_data => x_msg_data);

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

767:
768: WHEN OTHERS THEN
769: FND_MSG_PUB.ADD_EXC_MSG('OKL_PDT_STYS_PUB','validate_pdt_stys');
770: -- store SQL error message on message stack for caller
771: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
772: ,p_count => x_msg_count
773: ,p_data => x_msg_data);
774: -- notify caller of an UNEXPECTED error
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;