eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_PDT_STYS_PUB dependencies on OKC_API

Line 12: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

8:
9:
10: PROCEDURE insert_pdt_stys(
11: p_api_version IN NUMBER
12: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
13: ,x_return_status OUT NOCOPY VARCHAR2
14: ,x_msg_count OUT NOCOPY NUMBER
15: ,x_msg_data OUT NOCOPY VARCHAR2
16: ,p_psyv_rec IN psyv_rec_type

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 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 82: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

78:
79:
80: PROCEDURE insert_pdt_stys(
81: p_api_version IN NUMBER
82: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
83: ,x_return_status OUT NOCOPY VARCHAR2
84: ,x_msg_count OUT NOCOPY NUMBER
85: ,x_msg_data OUT NOCOPY VARCHAR2
86: ,p_psyv_tbl IN psyv_tbl_type

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 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 175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

171: END insert_pdt_stys;
172:
173: PROCEDURE lock_pdt_stys(
174: p_api_version IN NUMBER
175: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
176: ,x_return_status OUT NOCOPY VARCHAR2
177: ,x_msg_count OUT NOCOPY NUMBER
178: ,x_msg_data OUT NOCOPY VARCHAR2
179: ,p_psyv_rec IN psyv_rec_type

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 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 233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

229: END lock_pdt_stys;
230:
231: PROCEDURE lock_pdt_stys(
232: p_api_version IN NUMBER
233: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
234: ,x_return_status OUT NOCOPY VARCHAR2
235: ,x_msg_count OUT NOCOPY NUMBER
236: ,x_msg_data OUT NOCOPY VARCHAR2
237: ,p_psyv_tbl IN psyv_tbl_type

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 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 313: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

309: END lock_pdt_stys;
310:
311: PROCEDURE update_pdt_stys(
312: p_api_version IN NUMBER
313: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
314: ,x_return_status OUT NOCOPY VARCHAR2
315: ,x_msg_count OUT NOCOPY NUMBER
316: ,x_msg_data OUT NOCOPY VARCHAR2
317: ,p_psyv_rec IN psyv_rec_type

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 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 382: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

378:
379:
380: PROCEDURE update_pdt_stys(
381: p_api_version IN NUMBER
382: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
383: ,x_return_status OUT NOCOPY VARCHAR2
384: ,x_msg_count OUT NOCOPY NUMBER
385: ,x_msg_data OUT NOCOPY VARCHAR2
386: ,p_psyv_tbl IN psyv_tbl_type

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 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 475: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

471: END update_pdt_stys;
472:
473: PROCEDURE delete_pdt_stys(
474: p_api_version IN NUMBER
475: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
476: ,x_return_status OUT NOCOPY VARCHAR2
477: ,x_msg_count OUT NOCOPY NUMBER
478: ,x_msg_data OUT NOCOPY VARCHAR2
479: ,p_psyv_rec IN psyv_rec_type

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 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 539: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

535:
536:
537: PROCEDURE delete_pdt_stys(
538: p_api_version IN NUMBER
539: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
540: ,x_return_status OUT NOCOPY VARCHAR2
541: ,x_msg_count OUT NOCOPY NUMBER
542: ,x_msg_data OUT NOCOPY VARCHAR2
543: ,p_psyv_tbl IN psyv_tbl_type

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 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 627: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

623: END delete_pdt_stys;
624:
625: PROCEDURE validate_pdt_stys(
626: p_api_version IN NUMBER
627: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
628: ,x_return_status OUT NOCOPY VARCHAR2
629: ,x_msg_count OUT NOCOPY NUMBER
630: ,x_msg_data OUT NOCOPY VARCHAR2
631: ,p_psyv_rec IN psyv_rec_type

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 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 691: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

687:
688:
689: PROCEDURE validate_pdt_stys(
690: p_api_version IN NUMBER
691: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
692: ,x_return_status OUT NOCOPY VARCHAR2
693: ,x_msg_count OUT NOCOPY NUMBER
694: ,x_msg_data OUT NOCOPY VARCHAR2
695: ,p_psyv_tbl IN psyv_tbl_type

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 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;