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_SGN_TRANSLATIONS_PUB dependencies on OKC_API

Line 13: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

9:
10:
11: PROCEDURE insert_sgn_translations(
12: p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
14: x_return_status OUT NOCOPY VARCHAR2,
15: x_msg_count OUT NOCOPY NUMBER,
16: x_msg_data OUT NOCOPY VARCHAR2,
17: p_sgnv_rec IN sgnv_rec_type,

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

73: END insert_sgn_translations;
74:
75: PROCEDURE insert_sgn_translations(
76: p_api_version IN NUMBER,
77: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
78: x_return_status OUT NOCOPY VARCHAR2,
79: x_msg_count OUT NOCOPY NUMBER,
80: x_msg_data OUT NOCOPY VARCHAR2,
81: p_sgnv_tbl IN sgnv_tbl_type,

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

163: END insert_sgn_translations;
164:
165: PROCEDURE lock_sgn_translations(
166: p_api_version IN NUMBER,
167: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
168: x_return_status OUT NOCOPY VARCHAR2,
169: x_msg_count OUT NOCOPY NUMBER,
170: x_msg_data OUT NOCOPY VARCHAR2,
171: p_sgnv_rec IN sgnv_rec_type) IS

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

218: END lock_sgn_translations;
219:
220: PROCEDURE lock_sgn_translations(
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
223: x_return_status OUT NOCOPY VARCHAR2,
224: x_msg_count OUT NOCOPY NUMBER,
225: x_msg_data OUT NOCOPY VARCHAR2,
226: p_sgnv_tbl IN sgnv_tbl_type) IS

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

295: END lock_sgn_translations;
296:
297: PROCEDURE update_sgn_translations(
298: p_api_version IN NUMBER,
299: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
300: x_return_status OUT NOCOPY VARCHAR2,
301: x_msg_count OUT NOCOPY NUMBER,
302: x_msg_data OUT NOCOPY VARCHAR2,
303: p_sgnv_rec IN sgnv_rec_type,

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

358: END update_sgn_translations;
359:
360: PROCEDURE update_sgn_translations(
361: p_api_version IN NUMBER,
362: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
363: x_return_status OUT NOCOPY VARCHAR2,
364: x_msg_count OUT NOCOPY NUMBER,
365: x_msg_data OUT NOCOPY VARCHAR2,
366: p_sgnv_tbl IN sgnv_tbl_type,

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

446: END update_sgn_translations;
447:
448: PROCEDURE delete_sgn_translations(
449: p_api_version IN NUMBER,
450: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
451: x_return_status OUT NOCOPY VARCHAR2,
452: x_msg_count OUT NOCOPY NUMBER,
453: x_msg_data OUT NOCOPY VARCHAR2,
454: p_sgnv_rec IN sgnv_rec_type) IS

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

507: END delete_sgn_translations;
508:
509: PROCEDURE delete_sgn_translations(
510: p_api_version IN NUMBER,
511: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
512: x_return_status OUT NOCOPY VARCHAR2,
513: x_msg_count OUT NOCOPY NUMBER,
514: x_msg_data OUT NOCOPY VARCHAR2,
515: p_sgnv_tbl IN sgnv_tbl_type) IS

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

593: END delete_sgn_translations;
594:
595: PROCEDURE validate_sgn_translations(
596: p_api_version IN NUMBER,
597: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
598: x_return_status OUT NOCOPY VARCHAR2,
599: x_msg_count OUT NOCOPY NUMBER,
600: x_msg_data OUT NOCOPY VARCHAR2,
601: p_sgnv_rec IN sgnv_rec_type,

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

654: END validate_sgn_translations;
655:
656: PROCEDURE validate_sgn_translations(
657: p_api_version IN NUMBER,
658: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
659: x_return_status OUT NOCOPY VARCHAR2,
660: x_msg_count OUT NOCOPY NUMBER,
661: x_msg_data OUT NOCOPY VARCHAR2,
662: p_sgnv_tbl IN sgnv_tbl_type,

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