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

Line 9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

5: PROCEDURE create_tmpt_set(
6:
7: p_api_version IN NUMBER
8:
9: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
10:
11: ,x_return_status OUT NOCOPY VARCHAR2
12:
13: ,x_msg_count OUT NOCOPY NUMBER

Line 39: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

35: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
36:
37: l_aesv_rec aesv_rec_type := p_aesv_rec;
38:
39: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
40:
41: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;
42:
43: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;

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

120: WHEN FND_API.G_EXC_ERROR THEN
121: ROLLBACK TO create_tmpt_set;
122: x_return_status := FND_API.G_RET_STS_ERROR;
123:
124: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
125: ,p_count => x_msg_count
126: ,p_data => x_msg_data);
127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

127:
128: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
129: ROLLBACK TO create_tmpt_set;
130: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
132: ,p_count => x_msg_count
133: ,p_data => x_msg_data);
134:
135: WHEN OTHERS THEN

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

134:
135: WHEN OTHERS THEN
136: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
137: -- store SQL error message on message stack for caller
138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
139: ,p_count => x_msg_count
140: ,p_data => x_msg_data);
141: -- notify caller of an UNEXPECTED error
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 153: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

149: PROCEDURE create_tmpt_set(
150:
151: p_api_version IN NUMBER
152:
153: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
154:
155: ,x_return_status OUT NOCOPY VARCHAR2
156:
157: ,x_msg_count OUT NOCOPY NUMBER

Line 165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

161: ,p_aesv_rec IN aesv_rec_type
162:
163: ,x_aesv_rec OUT NOCOPY aesv_rec_type) IS
164:
165: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
166:
167: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
168:
169: l_aesv_rec aesv_rec_type := p_aesv_rec;

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

241: WHEN FND_API.G_EXC_ERROR THEN
242: ROLLBACK TO create_tmpt_set;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244:
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
246: ,p_count => x_msg_count
247: ,p_data => x_msg_data);
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250: ROLLBACK TO create_tmpt_set;
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
253: ,p_count => x_msg_count
254: ,p_data => x_msg_data);
255:
256: WHEN OTHERS THEN

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

255:
256: WHEN OTHERS THEN
257: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
258: -- store SQL error message on message stack for caller
259: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
260: ,p_count => x_msg_count
261: ,p_data => x_msg_data);
262: -- notify caller of an UNEXPECTED error
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 273: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

269: PROCEDURE create_tmpt_set(
270:
271: p_api_version IN NUMBER
272:
273: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
274:
275: ,x_return_status OUT NOCOPY VARCHAR2
276:
277: ,x_msg_count OUT NOCOPY NUMBER

Line 285: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

281: ,p_aesv_tbl IN aesv_tbl_type
282:
283: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
284:
285: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
286:
287: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_set';
288:
289: i NUMBER;

Line 293: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

289: i NUMBER;
290:
291: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;
292:
293: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
294:
295:
296: BEGIN
297:

Line 342: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

338: ,x_aesv_rec => x_aesv_tbl(i)
339:
340: );
341:
342: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
343: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: l_overall_status := x_return_status;
345: END IF;
346: END IF;

Line 343: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

339:
340: );
341:
342: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
343: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
344: l_overall_status := x_return_status;
345: END IF;
346: END IF;
347:

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

382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO create_tmpt_set;
384: x_return_status := FND_API.G_RET_STS_ERROR;
385:
386: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
387: ,p_count => x_msg_count
388: ,p_data => x_msg_data);
389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

389:
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: ROLLBACK TO create_tmpt_set;
392: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
393: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
394: ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396:
397: WHEN OTHERS THEN

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

396:
397: WHEN OTHERS THEN
398: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');
399: -- store SQL error message on message stack for caller
400: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
401: ,p_count => x_msg_count
402: ,p_data => x_msg_data);
403: -- notify caller of an UNEXPECTED error
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 416: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

412: PROCEDURE update_tmpt_set(
413:
414: p_api_version IN NUMBER,
415:
416: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
417:
418: x_return_status OUT NOCOPY VARCHAR2,
419:
420: x_msg_count OUT NOCOPY NUMBER,

Line 436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

432: x_avlv_tbl OUT NOCOPY avlv_tbl_type,
433:
434: x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
435:
436: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
437:
438: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
439:
440: l_aesv_rec aesv_rec_type := p_aesv_rec;

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

524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO update_tmpt_set;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527:
528: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
529: ,p_count => x_msg_count
530: ,p_data => x_msg_data);
531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

531:
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO update_tmpt_set;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
538:
539: WHEN OTHERS THEN

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

538:
539: WHEN OTHERS THEN
540: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
541: -- store SQL error message on message stack for caller
542: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
543: ,p_count => x_msg_count
544: ,p_data => x_msg_data);
545: -- notify caller of an UNEXPECTED error
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 556: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

552: PROCEDURE validate_tmpt_set(
553:
554: p_api_version IN NUMBER
555:
556: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
557:
558: ,x_return_status OUT NOCOPY VARCHAR2
559:
560: ,x_msg_count OUT NOCOPY NUMBER

Line 572: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

568: ,p_atlv_tbl IN atlv_tbl_type) IS
569:
570:
571:
572: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
573:
574: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_set';
575:
576: l_aesv_rec aesv_rec_type := p_aesv_rec;

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

653: WHEN FND_API.G_EXC_ERROR THEN
654: ROLLBACK TO validate_tmpt_set;
655: x_return_status := FND_API.G_RET_STS_ERROR;
656:
657: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
658: ,p_count => x_msg_count
659: ,p_data => x_msg_data);
660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

660:
661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: ROLLBACK TO validate_tmpt_set;
663: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
665: ,p_count => x_msg_count
666: ,p_data => x_msg_data);
667:
668: WHEN OTHERS THEN

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

667:
668: WHEN OTHERS THEN
669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
670: -- store SQL error message on message stack for caller
671: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
672: ,p_count => x_msg_count
673: ,p_data => x_msg_data);
674: -- notify caller of an UNEXPECTED error
675: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 685: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

681: PROCEDURE lock_tmpt_set(
682:
683: p_api_version IN NUMBER
684:
685: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
686:
687: ,x_return_status OUT NOCOPY VARCHAR2
688:
689: ,x_msg_count OUT NOCOPY NUMBER

Line 695: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

691: ,x_msg_data OUT NOCOPY VARCHAR2
692:
693: ,p_aesv_rec IN aesv_rec_type) IS
694:
695: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
696:
697: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_set';
698:
699:

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

733: WHEN FND_API.G_EXC_ERROR THEN
734: ROLLBACK TO lock_tmpt_set;
735: x_return_status := FND_API.G_RET_STS_ERROR;
736:
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:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

740:
741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
742: ROLLBACK TO lock_tmpt_set;
743: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
744: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
745: ,p_count => x_msg_count
746: ,p_data => x_msg_data);
747:
748: WHEN OTHERS THEN

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

747:
748: WHEN OTHERS THEN
749: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');
750: -- store SQL error message on message stack for caller
751: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
752: ,p_count => x_msg_count
753: ,p_data => x_msg_data);
754: -- notify caller of an UNEXPECTED error
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 765: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

761: PROCEDURE lock_tmpt_set(
762:
763: p_api_version IN NUMBER
764:
765: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
766:
767: ,x_return_status OUT NOCOPY VARCHAR2
768:
769: ,x_msg_count OUT NOCOPY NUMBER

Line 775: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

771: ,x_msg_data OUT NOCOPY VARCHAR2
772:
773: ,p_aesv_tbl IN aesv_tbl_type) IS
774:
775: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
776:
777: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_set';
778:
779: i NUMBER;

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

838: WHEN FND_API.G_EXC_ERROR THEN
839: ROLLBACK TO lock_tmpt_set;
840: x_return_status := FND_API.G_RET_STS_ERROR;
841:
842: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
843: ,p_count => x_msg_count
844: ,p_data => x_msg_data);
845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

845:
846: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
847: ROLLBACK TO lock_tmpt_set;
848: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
849: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
850: ,p_count => x_msg_count
851: ,p_data => x_msg_data);
852:
853: WHEN OTHERS THEN

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

852:
853: WHEN OTHERS THEN
854: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');
855: -- store SQL error message on message stack for caller
856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
857: ,p_count => x_msg_count
858: ,p_data => x_msg_data);
859: -- notify caller of an UNEXPECTED error
860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 870: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

866: PROCEDURE update_tmpt_set(
867:
868: p_api_version IN NUMBER
869:
870: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
871:
872: ,x_return_status OUT NOCOPY VARCHAR2
873:
874: ,x_msg_count OUT NOCOPY NUMBER

Line 882: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

878: ,p_aesv_rec IN aesv_rec_type
879:
880: ,x_aesv_rec OUT NOCOPY aesv_rec_type) IS
881:
882: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
883:
884: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
885:
886: l_aesv_rec aesv_rec_type := p_aesv_rec;

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

957: WHEN FND_API.G_EXC_ERROR THEN
958: ROLLBACK TO update_tmpt_set;
959: x_return_status := FND_API.G_RET_STS_ERROR;
960:
961: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
962: ,p_count => x_msg_count
963: ,p_data => x_msg_data);
964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

964:
965: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
966: ROLLBACK TO update_tmpt_set;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
969: ,p_count => x_msg_count
970: ,p_data => x_msg_data);
971:
972: WHEN OTHERS THEN

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

971:
972: WHEN OTHERS THEN
973: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
974: -- store SQL error message on message stack for caller
975: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
976: ,p_count => x_msg_count
977: ,p_data => x_msg_data);
978: -- notify caller of an UNEXPECTED error
979: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 989: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

985: PROCEDURE update_tmpt_set(
986:
987: p_api_version IN NUMBER
988:
989: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
990:
991: ,x_return_status OUT NOCOPY VARCHAR2
992:
993: ,x_msg_count OUT NOCOPY NUMBER

Line 1001: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

997: ,p_aesv_tbl IN aesv_tbl_type
998:
999: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
1000:
1001: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1003:
1004: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
1005:

Line 1002: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

998:
999: ,x_aesv_tbl OUT NOCOPY aesv_tbl_type) IS
1000:
1001: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1002: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1003:
1004: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_set';
1005:
1006: i NUMBER;

Line 1056: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1052: ,x_aesv_rec => x_aesv_tbl(i)
1053:
1054: );
1055:
1056: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1057: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1058: l_overall_status := x_return_status;
1059: END IF;
1060: END IF;

Line 1057: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1053:
1054: );
1055:
1056: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1057: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1058: l_overall_status := x_return_status;
1059: END IF;
1060: END IF;
1061:

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

1096: WHEN FND_API.G_EXC_ERROR THEN
1097: ROLLBACK TO update_tmpt_set;
1098: x_return_status := FND_API.G_RET_STS_ERROR;
1099:
1100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1103:
1104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1105: ROLLBACK TO update_tmpt_set;
1106: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1107: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
1110:
1111: WHEN OTHERS THEN

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

1110:
1111: WHEN OTHERS THEN
1112: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');
1113: -- store SQL error message on message stack for caller
1114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1115: ,p_count => x_msg_count
1116: ,p_data => x_msg_data);
1117: -- notify caller of an UNEXPECTED error
1118: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1130: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1126: PROCEDURE delete_tmpt_set(
1127:
1128: p_api_version IN NUMBER
1129:
1130: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1131:
1132: ,x_return_status OUT NOCOPY VARCHAR2
1133:
1134: ,x_msg_count OUT NOCOPY NUMBER

Line 1142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1138: ,p_aesv_rec IN aesv_rec_type) IS
1139:
1140: i NUMBER :=0;
1141:
1142: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1143:
1144: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
1145:
1146:

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

1218: WHEN FND_API.G_EXC_ERROR THEN
1219: ROLLBACK TO delete_tmpt_set;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221:
1222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1223: ,p_count => x_msg_count
1224: ,p_data => x_msg_data);
1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1225:
1226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1227: ROLLBACK TO delete_tmpt_set;
1228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1229: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1230: ,p_count => x_msg_count
1231: ,p_data => x_msg_data);
1232:
1233: WHEN OTHERS THEN

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

1232:
1233: WHEN OTHERS THEN
1234: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
1235: -- store SQL error message on message stack for caller
1236: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1237: ,p_count => x_msg_count
1238: ,p_data => x_msg_data);
1239: -- notify caller of an UNEXPECTED error
1240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1250: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1246: PROCEDURE delete_tmpt_set(
1247:
1248: p_api_version IN NUMBER
1249:
1250: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1251:
1252: ,x_return_status OUT NOCOPY VARCHAR2
1253:
1254: ,x_msg_count OUT NOCOPY NUMBER

Line 1262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1258: ,p_aesv_tbl IN aesv_tbl_type) IS
1259:
1260: i NUMBER :=0;
1261:
1262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1263: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1264:
1265: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
1266:

Line 1263: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1259:
1260: i NUMBER :=0;
1261:
1262: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1263: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1264:
1265: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_set';
1266:
1267: l_aesv_tbl aesv_tbl_type := p_aesv_tbl;

Line 1314: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1310: ,p_aesv_rec => l_aesv_tbl(i)
1311:
1312: );
1313:
1314: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1315: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1316: l_overall_status := x_return_status;
1317: END IF;
1318: END IF;

Line 1315: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1311:
1312: );
1313:
1314: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1315: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1316: l_overall_status := x_return_status;
1317: END IF;
1318: END IF;
1319:

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

1353: WHEN FND_API.G_EXC_ERROR THEN
1354: ROLLBACK TO delete_tmpt_set;
1355: x_return_status := FND_API.G_RET_STS_ERROR;
1356:
1357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data);
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO delete_tmpt_set;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1365: ,p_count => x_msg_count
1366: ,p_data => x_msg_data);
1367:
1368: WHEN OTHERS THEN

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

1367:
1368: WHEN OTHERS THEN
1369: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');
1370: -- store SQL error message on message stack for caller
1371: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1372: ,p_count => x_msg_count
1373: ,p_data => x_msg_data);
1374: -- notify caller of an UNEXPECTED error
1375: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1385: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1381: PROCEDURE validate_tmpt_set(
1382:
1383: p_api_version IN NUMBER
1384:
1385: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1386:
1387: ,x_return_status OUT NOCOPY VARCHAR2
1388:
1389: ,x_msg_count OUT NOCOPY NUMBER

Line 1395: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1391: ,x_msg_data OUT NOCOPY VARCHAR2
1392:
1393: ,p_aesv_rec IN aesv_rec_type) IS
1394:
1395: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1396:
1397: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_set';
1398:
1399: l_aesv_rec aesv_rec_type := p_aesv_rec;

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

1468: WHEN FND_API.G_EXC_ERROR THEN
1469: ROLLBACK TO validate_tmpt_set;
1470: x_return_status := FND_API.G_RET_STS_ERROR;
1471:
1472: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1473: ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475:
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1475:
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1477: ROLLBACK TO validate_tmpt_set;
1478: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1479: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1480: ,p_count => x_msg_count
1481: ,p_data => x_msg_data);
1482:
1483: WHEN OTHERS THEN

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

1482:
1483: WHEN OTHERS THEN
1484: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
1485: -- store SQL error message on message stack for caller
1486: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1487: ,p_count => x_msg_count
1488: ,p_data => x_msg_data);
1489: -- notify caller of an UNEXPECTED error
1490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1500: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1496: PROCEDURE validate_tmpt_set(
1497:
1498: p_api_version IN NUMBER,
1499:
1500: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1501:
1502: x_return_status OUT NOCOPY VARCHAR2,
1503:
1504: x_msg_count OUT NOCOPY NUMBER,

Line 1510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1506: x_msg_data OUT NOCOPY VARCHAR2,
1507:
1508: p_aesv_tbl IN aesv_tbl_type) IS
1509:
1510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1511: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1512:
1513: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_set';
1514:

Line 1511: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1507:
1508: p_aesv_tbl IN aesv_tbl_type) IS
1509:
1510: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1511: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1512:
1513: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_set';
1514:
1515: i NUMBER;

Line 1562: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1558:
1559: ,p_aesv_rec => l_aesv_tbl(i)
1560:
1561: );
1562: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1563: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1564: l_overall_status := x_return_status;
1565: END IF;
1566: END IF;

Line 1563: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1559: ,p_aesv_rec => l_aesv_tbl(i)
1560:
1561: );
1562: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1563: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1564: l_overall_status := x_return_status;
1565: END IF;
1566: END IF;
1567:

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

1601: WHEN FND_API.G_EXC_ERROR THEN
1602: ROLLBACK TO validate_tmpt_set;
1603: x_return_status := FND_API.G_RET_STS_ERROR;
1604:
1605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1606: ,p_count => x_msg_count
1607: ,p_data => x_msg_data);
1608:
1609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1608:
1609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1610: ROLLBACK TO validate_tmpt_set;
1611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1613: ,p_count => x_msg_count
1614: ,p_data => x_msg_data);
1615:
1616: WHEN OTHERS THEN

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

1615:
1616: WHEN OTHERS THEN
1617: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');
1618: -- store SQL error message on message stack for caller
1619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1620: ,p_count => x_msg_count
1621: ,p_data => x_msg_data);
1622: -- notify caller of an UNEXPECTED error
1623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1633: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1629: PROCEDURE create_template(
1630:
1631: p_api_version IN NUMBER
1632:
1633: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1634:
1635: ,x_return_status OUT NOCOPY VARCHAR2
1636:
1637: ,x_msg_count OUT NOCOPY NUMBER

Line 1645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1641: ,p_avlv_rec IN avlv_rec_type
1642:
1643: ,x_avlv_rec OUT NOCOPY avlv_rec_type) IS
1644:
1645: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1646:
1647: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
1648:
1649: l_avlv_rec avlv_rec_type := p_avlv_rec;

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

1724: WHEN FND_API.G_EXC_ERROR THEN
1725: ROLLBACK TO create_template;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727:
1728: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1729: ,p_count => x_msg_count
1730: ,p_data => x_msg_data);
1731:
1732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1731:
1732: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1733: ROLLBACK TO create_template;
1734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1735: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1736: ,p_count => x_msg_count
1737: ,p_data => x_msg_data);
1738:
1739: WHEN OTHERS THEN

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

1738:
1739: WHEN OTHERS THEN
1740: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');
1741: -- store SQL error message on message stack for caller
1742: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1743: ,p_count => x_msg_count
1744: ,p_data => x_msg_data);
1745: -- notify caller of an UNEXPECTED error
1746: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1756: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1752: PROCEDURE create_template(
1753:
1754: p_api_version IN NUMBER
1755:
1756: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1757:
1758: ,x_return_status OUT NOCOPY VARCHAR2
1759:
1760: ,x_msg_count OUT NOCOPY NUMBER

Line 1768: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1764: ,p_avlv_tbl IN avlv_tbl_type
1765:
1766: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
1767:
1768: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1769: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1770:
1771: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
1772:

Line 1769: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1765:
1766: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
1767:
1768: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1769: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1770:
1771: l_api_name CONSTANT VARCHAR2(30) := 'create_template';
1772:
1773: i NUMBER;

Line 1829: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1825: ,x_avlv_rec => x_avlv_tbl(i)
1826:
1827: );
1828:
1829: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1830: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: l_overall_status := x_return_status;
1832: END IF;
1833: END IF;

Line 1830: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1826:
1827: );
1828:
1829: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1830: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1831: l_overall_status := x_return_status;
1832: END IF;
1833: END IF;
1834:

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

1869: WHEN FND_API.G_EXC_ERROR THEN
1870: ROLLBACK TO create_template;
1871: x_return_status := FND_API.G_RET_STS_ERROR;
1872:
1873: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1874: ,p_count => x_msg_count
1875: ,p_data => x_msg_data);
1876:
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1876:
1877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1878: ROLLBACK TO create_template;
1879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1880: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1881: ,p_count => x_msg_count
1882: ,p_data => x_msg_data);
1883:
1884: WHEN OTHERS THEN

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

1883:
1884: WHEN OTHERS THEN
1885: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');
1886: -- store SQL error message on message stack for caller
1887: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1888: ,p_count => x_msg_count
1889: ,p_data => x_msg_data);
1890: -- notify caller of an UNEXPECTED error
1891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1901: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1897: PROCEDURE lock_template(
1898:
1899: p_api_version IN NUMBER
1900:
1901: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1902:
1903: ,x_return_status OUT NOCOPY VARCHAR2
1904:
1905: ,x_msg_count OUT NOCOPY NUMBER

Line 1911: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1907: ,x_msg_data OUT NOCOPY VARCHAR2
1908:
1909: ,p_avlv_rec IN avlv_rec_type) IS
1910:
1911: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1912:
1913: l_api_name CONSTANT VARCHAR2(30) := 'lock_template';
1914:
1915: BEGIN

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

1944: WHEN FND_API.G_EXC_ERROR THEN
1945: ROLLBACK TO lock_template;
1946: x_return_status := FND_API.G_RET_STS_ERROR;
1947:
1948: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1949: ,p_count => x_msg_count
1950: ,p_data => x_msg_data);
1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1951:
1952: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1953: ROLLBACK TO lock_template;
1954: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1956: ,p_count => x_msg_count
1957: ,p_data => x_msg_data);
1958:
1959: WHEN OTHERS THEN

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

1958:
1959: WHEN OTHERS THEN
1960: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');
1961: -- store SQL error message on message stack for caller
1962: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1963: ,p_count => x_msg_count
1964: ,p_data => x_msg_data);
1965: -- notify caller of an UNEXPECTED error
1966: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1976: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

1972: PROCEDURE lock_template(
1973:
1974: p_api_version IN NUMBER
1975:
1976: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1977:
1978: ,x_return_status OUT NOCOPY VARCHAR2
1979:
1980: ,x_msg_count OUT NOCOPY NUMBER

Line 1986: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1982: ,x_msg_data OUT NOCOPY VARCHAR2
1983:
1984: ,p_avlv_tbl IN avlv_tbl_type) IS
1985:
1986: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1987:
1988: l_api_name CONSTANT VARCHAR2(30) := 'lock_template';
1989:
1990: i NUMBER;

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

2049: WHEN FND_API.G_EXC_ERROR THEN
2050: ROLLBACK TO lock_template;
2051: x_return_status := FND_API.G_RET_STS_ERROR;
2052:
2053: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2054: ,p_count => x_msg_count
2055: ,p_data => x_msg_data);
2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2056:
2057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2058: ROLLBACK TO lock_template;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);
2063:
2064: WHEN OTHERS THEN

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

2063:
2064: WHEN OTHERS THEN
2065: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');
2066: -- store SQL error message on message stack for caller
2067: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2068: ,p_count => x_msg_count
2069: ,p_data => x_msg_data);
2070: -- notify caller of an UNEXPECTED error
2071: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2081: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2077: PROCEDURE update_template(
2078:
2079: p_api_version IN NUMBER
2080:
2081: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2082:
2083: ,x_return_status OUT NOCOPY VARCHAR2
2084:
2085: ,x_msg_count OUT NOCOPY NUMBER

Line 2093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2089: ,p_avlv_rec IN avlv_rec_type
2090:
2091: ,x_avlv_rec OUT NOCOPY avlv_rec_type) IS
2092:
2093: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2094:
2095: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
2096:
2097: l_avlv_rec avlv_rec_type := p_avlv_rec;

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

2166: WHEN FND_API.G_EXC_ERROR THEN
2167: ROLLBACK TO update_template;
2168: x_return_status := FND_API.G_RET_STS_ERROR;
2169:
2170: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2171: ,p_count => x_msg_count
2172: ,p_data => x_msg_data);
2173:
2174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2173:
2174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2175: ROLLBACK TO update_template;
2176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2177: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2178: ,p_count => x_msg_count
2179: ,p_data => x_msg_data);
2180:
2181: WHEN OTHERS THEN

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

2180:
2181: WHEN OTHERS THEN
2182: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
2183: -- store SQL error message on message stack for caller
2184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2185: ,p_count => x_msg_count
2186: ,p_data => x_msg_data);
2187: -- notify caller of an UNEXPECTED error
2188: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2198: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2194: PROCEDURE update_template(
2195:
2196: p_api_version IN NUMBER
2197:
2198: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2199:
2200: ,x_return_status OUT NOCOPY VARCHAR2
2201:
2202: ,x_msg_count OUT NOCOPY NUMBER

Line 2210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2206: ,p_avlv_tbl IN avlv_tbl_type
2207:
2208: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
2209:
2210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2211: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2212:
2213: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
2214:

Line 2211: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2207:
2208: ,x_avlv_tbl OUT NOCOPY avlv_tbl_type) IS
2209:
2210: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2211: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2212:
2213: l_api_name CONSTANT VARCHAR2(30) := 'update_template';
2214:
2215: i NUMBER;

Line 2264: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2260:
2261: ,x_avlv_rec => x_avlv_tbl(i)
2262:
2263: );
2264: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2265: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: l_overall_status := x_return_status;
2267: END IF;
2268: END IF;

Line 2265: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2261: ,x_avlv_rec => x_avlv_tbl(i)
2262:
2263: );
2264: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2265: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2266: l_overall_status := x_return_status;
2267: END IF;
2268: END IF;
2269:

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

2306: WHEN FND_API.G_EXC_ERROR THEN
2307: ROLLBACK TO update_template;
2308: x_return_status := FND_API.G_RET_STS_ERROR;
2309:
2310: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2311: ,p_count => x_msg_count
2312: ,p_data => x_msg_data);
2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2313:
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: ROLLBACK TO update_template;
2316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2317: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2318: ,p_count => x_msg_count
2319: ,p_data => x_msg_data);
2320:
2321: WHEN OTHERS THEN

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

2320:
2321: WHEN OTHERS THEN
2322: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');
2323: -- store SQL error message on message stack for caller
2324: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2325: ,p_count => x_msg_count
2326: ,p_data => x_msg_data);
2327: -- notify caller of an UNEXPECTED error
2328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2340: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2336: PROCEDURE delete_template(
2337:
2338: p_api_version IN NUMBER
2339:
2340: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2341:
2342: ,x_return_status OUT NOCOPY VARCHAR2
2343:
2344: ,x_msg_count OUT NOCOPY NUMBER

Line 2352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2348: ,p_avlv_rec IN avlv_rec_type) IS
2349:
2350: i NUMBER :=0;
2351:
2352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2353:
2354: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
2355:
2356: l_avlv_rec avlv_rec_type := p_avlv_rec;

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

2422: WHEN FND_API.G_EXC_ERROR THEN
2423: ROLLBACK TO delete_template;
2424: x_return_status := FND_API.G_RET_STS_ERROR;
2425:
2426: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2427: ,p_count => x_msg_count
2428: ,p_data => x_msg_data);
2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2429:
2430: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2431: ROLLBACK TO delete_template;
2432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2433: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2434: ,p_count => x_msg_count
2435: ,p_data => x_msg_data);
2436:
2437: WHEN OTHERS THEN

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

2436:
2437: WHEN OTHERS THEN
2438: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
2439: -- store SQL error message on message stack for caller
2440: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2441: ,p_count => x_msg_count
2442: ,p_data => x_msg_data);
2443: -- notify caller of an UNEXPECTED error
2444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2454: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2450: PROCEDURE delete_template(
2451:
2452: p_api_version IN NUMBER
2453:
2454: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2455:
2456: ,x_return_status OUT NOCOPY VARCHAR2
2457:
2458: ,x_msg_count OUT NOCOPY NUMBER

Line 2468: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2464:
2465:
2466: i NUMBER :=0;
2467:
2468: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2469: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2470:
2471: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
2472:

Line 2469: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2465:
2466: i NUMBER :=0;
2467:
2468: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2469: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2470:
2471: l_api_name CONSTANT VARCHAR2(30) := 'delete_template';
2472:
2473: l_avlv_tbl avlv_tbl_type := p_avlv_tbl;

Line 2518: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2514: ,x_msg_data => x_msg_data
2515:
2516: ,p_avlv_rec => l_avlv_tbl(i));
2517:
2518: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2519: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2520: l_overall_status := x_return_status;
2521: END IF;
2522: END IF;

Line 2519: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2515:
2516: ,p_avlv_rec => l_avlv_tbl(i));
2517:
2518: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2519: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2520: l_overall_status := x_return_status;
2521: END IF;
2522: END IF;
2523:

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

2560: WHEN FND_API.G_EXC_ERROR THEN
2561: ROLLBACK TO delete_template;
2562: x_return_status := FND_API.G_RET_STS_ERROR;
2563:
2564: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2565: ,p_count => x_msg_count
2566: ,p_data => x_msg_data);
2567:
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2567:
2568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2569: ROLLBACK TO delete_template;
2570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2571: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2572: ,p_count => x_msg_count
2573: ,p_data => x_msg_data);
2574:
2575: WHEN OTHERS THEN

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

2574:
2575: WHEN OTHERS THEN
2576: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');
2577: -- store SQL error message on message stack for caller
2578: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2579: ,p_count => x_msg_count
2580: ,p_data => x_msg_data);
2581: -- notify caller of an UNEXPECTED error
2582: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2593: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2589: PROCEDURE validate_template(
2590:
2591: p_api_version IN NUMBER
2592:
2593: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2594:
2595: ,x_return_status OUT NOCOPY VARCHAR2
2596:
2597: ,x_msg_count OUT NOCOPY NUMBER

Line 2603: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2599: ,x_msg_data OUT NOCOPY VARCHAR2
2600:
2601: ,p_avlv_rec IN avlv_rec_type) IS
2602:
2603: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2604:
2605: l_api_name CONSTANT VARCHAR2(30) := 'validate_template';
2606:
2607: l_avlv_rec avlv_rec_type := p_avlv_rec;

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

2674: WHEN FND_API.G_EXC_ERROR THEN
2675: ROLLBACK TO validate_template;
2676: x_return_status := FND_API.G_RET_STS_ERROR;
2677:
2678: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2679: ,p_count => x_msg_count
2680: ,p_data => x_msg_data);
2681:
2682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2681:
2682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2683: ROLLBACK TO validate_template;
2684: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2685: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2686: ,p_count => x_msg_count
2687: ,p_data => x_msg_data);
2688:
2689: WHEN OTHERS THEN

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

2688:
2689: WHEN OTHERS THEN
2690: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');
2691: -- store SQL error message on message stack for caller
2692: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2693: ,p_count => x_msg_count
2694: ,p_data => x_msg_data);
2695: -- notify caller of an UNEXPECTED error
2696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2706: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2702: PROCEDURE validate_template(
2703:
2704: p_api_version IN NUMBER
2705:
2706: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2707:
2708: ,x_return_status OUT NOCOPY VARCHAR2
2709:
2710: ,x_msg_count OUT NOCOPY NUMBER

Line 2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2712: ,x_msg_data OUT NOCOPY VARCHAR2
2713:
2714: ,p_avlv_tbl IN avlv_tbl_type) IS
2715:
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2718:
2719: l_api_name CONSTANT VARCHAR2(30) := 'validate_template';
2720:

Line 2717: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2713:
2714: ,p_avlv_tbl IN avlv_tbl_type) IS
2715:
2716: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2717: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2718:
2719: l_api_name CONSTANT VARCHAR2(30) := 'validate_template';
2720:
2721: i NUMBER;

Line 2769: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

2765:
2766: ,p_avlv_rec => l_avlv_tbl(i)
2767:
2768: );
2769: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2770: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2771: l_overall_status := x_return_status;
2772: END IF;
2773: END IF;

Line 2770: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2766: ,p_avlv_rec => l_avlv_tbl(i)
2767:
2768: );
2769: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
2770: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2771: l_overall_status := x_return_status;
2772: END IF;
2773: END IF;
2774:

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

2809: WHEN FND_API.G_EXC_ERROR THEN
2810: ROLLBACK TO validate_template;
2811: x_return_status := FND_API.G_RET_STS_ERROR;
2812:
2813: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2814: ,p_count => x_msg_count
2815: ,p_data => x_msg_data);
2816:
2817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2816:
2817: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2818: ROLLBACK TO validate_template;
2819: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2820: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2821: ,p_count => x_msg_count
2822: ,p_data => x_msg_data);
2823:
2824: WHEN OTHERS THEN

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

2823:
2824: WHEN OTHERS THEN
2825: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');
2826: -- store SQL error message on message stack for caller
2827: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2828: ,p_count => x_msg_count
2829: ,p_data => x_msg_data);
2830: -- notify caller of an UNEXPECTED error
2831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2840: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2836: PROCEDURE create_tmpt_lines(
2837:
2838: p_api_version IN NUMBER
2839:
2840: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2841:
2842: ,x_return_status OUT NOCOPY VARCHAR2
2843:
2844: ,x_msg_count OUT NOCOPY NUMBER

Line 2852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2848: ,p_atlv_rec IN atlv_rec_type
2849:
2850: ,x_atlv_rec OUT NOCOPY atlv_rec_type) IS
2851:
2852: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2853:
2854: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
2855:
2856: l_atlv_rec atlv_rec_type := p_atlv_rec;

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

2931: WHEN FND_API.G_EXC_ERROR THEN
2932: ROLLBACK TO create_tmpt_lines;
2933: x_return_status := FND_API.G_RET_STS_ERROR;
2934:
2935: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2936: ,p_count => x_msg_count
2937: ,p_data => x_msg_data);
2938:
2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2938:
2939: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2940: ROLLBACK TO create_tmpt_lines;
2941: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2942: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2943: ,p_count => x_msg_count
2944: ,p_data => x_msg_data);
2945:
2946: WHEN OTHERS THEN

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

2945:
2946: WHEN OTHERS THEN
2947: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');
2948: -- store SQL error message on message stack for caller
2949: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2950: ,p_count => x_msg_count
2951: ,p_data => x_msg_data);
2952: -- notify caller of an UNEXPECTED error
2953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2963: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

2959: PROCEDURE create_tmpt_lines(
2960:
2961: p_api_version IN NUMBER
2962:
2963: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
2964:
2965: ,x_return_status OUT NOCOPY VARCHAR2
2966:
2967: ,x_msg_count OUT NOCOPY NUMBER

Line 2975: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2971: ,p_atlv_tbl IN atlv_tbl_type
2972:
2973: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
2974:
2975: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2976: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2977:
2978: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
2979:

Line 2976: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

2972:
2973: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
2974:
2975: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2976: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2977:
2978: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpt_lines';
2979:
2980: i NUMBER;

Line 3034: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3030:
3031: ,x_atlv_rec => x_atlv_tbl(i)
3032:
3033: );
3034: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3035: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3036: l_overall_status := x_return_status;
3037: END IF;
3038: END IF;

Line 3035: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3031: ,x_atlv_rec => x_atlv_tbl(i)
3032:
3033: );
3034: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3035: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3036: l_overall_status := x_return_status;
3037: END IF;
3038: END IF;
3039:

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

3075: WHEN FND_API.G_EXC_ERROR THEN
3076: ROLLBACK TO create_tmpt_lines;
3077: x_return_status := FND_API.G_RET_STS_ERROR;
3078:
3079: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3080: ,p_count => x_msg_count
3081: ,p_data => x_msg_data);
3082:
3083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3082:
3083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3084: ROLLBACK TO create_tmpt_lines;
3085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3086: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3087: ,p_count => x_msg_count
3088: ,p_data => x_msg_data);
3089:
3090: WHEN OTHERS THEN

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

3089:
3090: WHEN OTHERS THEN
3091: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');
3092: -- store SQL error message on message stack for caller
3093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3094: ,p_count => x_msg_count
3095: ,p_data => x_msg_data);
3096: -- notify caller of an UNEXPECTED error
3097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3107: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3103: PROCEDURE lock_tmpt_lines(
3104:
3105: p_api_version IN NUMBER
3106:
3107: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3108:
3109: ,x_return_status OUT NOCOPY VARCHAR2
3110:
3111: ,x_msg_count OUT NOCOPY NUMBER

Line 3117: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3113: ,x_msg_data OUT NOCOPY VARCHAR2
3114:
3115: ,p_atlv_rec IN atlv_rec_type) IS
3116:
3117: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3118:
3119: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_lines';
3120:
3121: BEGIN

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

3150: WHEN FND_API.G_EXC_ERROR THEN
3151: ROLLBACK TO lock_tmpt_lines;
3152: x_return_status := FND_API.G_RET_STS_ERROR;
3153:
3154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3155: ,p_count => x_msg_count
3156: ,p_data => x_msg_data);
3157:
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3157:
3158: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3159: ROLLBACK TO lock_tmpt_lines;
3160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3162: ,p_count => x_msg_count
3163: ,p_data => x_msg_data);
3164:
3165: WHEN OTHERS THEN

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

3164:
3165: WHEN OTHERS THEN
3166: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');
3167: -- store SQL error message on message stack for caller
3168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3169: ,p_count => x_msg_count
3170: ,p_data => x_msg_data);
3171: -- notify caller of an UNEXPECTED error
3172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3178: PROCEDURE lock_tmpt_lines(
3179:
3180: p_api_version IN NUMBER
3181:
3182: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3183:
3184: ,x_return_status OUT NOCOPY VARCHAR2
3185:
3186: ,x_msg_count OUT NOCOPY NUMBER

Line 3192: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3188: ,x_msg_data OUT NOCOPY VARCHAR2
3189:
3190: ,p_atlv_tbl IN atlv_tbl_type) IS
3191:
3192: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3193:
3194: l_api_name CONSTANT VARCHAR2(30) := 'lock_tmpt_lines';
3195:
3196: i NUMBER;

Line 3232: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3228: ,p_atlv_rec => p_atlv_tbl(i)
3229:
3230: );
3231:
3232: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3233: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3234: l_overall_status := x_return_status;
3235: END IF;
3236: END IF;

Line 3233: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3229:
3230: );
3231:
3232: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3233: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3234: l_overall_status := x_return_status;
3235: END IF;
3236: END IF;
3237:

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

3256: WHEN FND_API.G_EXC_ERROR THEN
3257: ROLLBACK TO lock_tmpt_lines;
3258: x_return_status := FND_API.G_RET_STS_ERROR;
3259:
3260: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3261: ,p_count => x_msg_count
3262: ,p_data => x_msg_data);
3263:
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3263:
3264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3265: ROLLBACK TO lock_tmpt_lines;
3266: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3267: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3268: ,p_count => x_msg_count
3269: ,p_data => x_msg_data);
3270:
3271: WHEN OTHERS THEN

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

3270:
3271: WHEN OTHERS THEN
3272: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');
3273: -- store SQL error message on message stack for caller
3274: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3275: ,p_count => x_msg_count
3276: ,p_data => x_msg_data);
3277: -- notify caller of an UNEXPECTED error
3278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3288: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3284: PROCEDURE update_tmpt_lines(
3285:
3286: p_api_version IN NUMBER
3287:
3288: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3289:
3290: ,x_return_status OUT NOCOPY VARCHAR2
3291:
3292: ,x_msg_count OUT NOCOPY NUMBER

Line 3300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3296: ,p_atlv_rec IN atlv_rec_type
3297:
3298: ,x_atlv_rec OUT NOCOPY atlv_rec_type) IS
3299:
3300: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3301:
3302: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
3303:
3304: l_atlv_rec atlv_rec_type := p_atlv_rec;

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

3372: WHEN FND_API.G_EXC_ERROR THEN
3373: ROLLBACK TO update_tmpt_lines;
3374: x_return_status := FND_API.G_RET_STS_ERROR;
3375:
3376: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3377: ,p_count => x_msg_count
3378: ,p_data => x_msg_data);
3379:
3380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3379:
3380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3381: ROLLBACK TO update_tmpt_lines;
3382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3383: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);
3386:
3387: WHEN OTHERS THEN

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

3386:
3387: WHEN OTHERS THEN
3388: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
3389: -- store SQL error message on message stack for caller
3390: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3391: ,p_count => x_msg_count
3392: ,p_data => x_msg_data);
3393: -- notify caller of an UNEXPECTED error
3394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3403: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3399: PROCEDURE update_tmpt_lines(
3400:
3401: p_api_version IN NUMBER
3402:
3403: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3404:
3405: ,x_return_status OUT NOCOPY VARCHAR2
3406:
3407: ,x_msg_count OUT NOCOPY NUMBER

Line 3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3411: ,p_atlv_tbl IN atlv_tbl_type
3412:
3413: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
3414:
3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3416: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3417:
3418: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
3419:

Line 3416: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3412:
3413: ,x_atlv_tbl OUT NOCOPY atlv_tbl_type) IS
3414:
3415: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3416: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3417:
3418: l_api_name CONSTANT VARCHAR2(30) := 'update_tmpt_lines';
3419:
3420: i NUMBER;

Line 3469: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3465: ,x_atlv_rec => x_atlv_tbl(i)
3466:
3467: );
3468:
3469: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3470: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3471: l_overall_status := x_return_status;
3472: END IF;
3473: END IF;

Line 3470: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3466:
3467: );
3468:
3469: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3470: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3471: l_overall_status := x_return_status;
3472: END IF;
3473: END IF;
3474:

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

3512: WHEN FND_API.G_EXC_ERROR THEN
3513: ROLLBACK TO update_tmpt_lines;
3514: x_return_status := FND_API.G_RET_STS_ERROR;
3515:
3516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3517: ,p_count => x_msg_count
3518: ,p_data => x_msg_data);
3519:
3520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3519:
3520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3521: ROLLBACK TO update_tmpt_lines;
3522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data);
3526:
3527: WHEN OTHERS THEN

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

3526:
3527: WHEN OTHERS THEN
3528: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');
3529: -- store SQL error message on message stack for caller
3530: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3531: ,p_count => x_msg_count
3532: ,p_data => x_msg_data);
3533: -- notify caller of an UNEXPECTED error
3534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3546: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3542: PROCEDURE delete_tmpt_lines(
3543:
3544: p_api_version IN NUMBER
3545:
3546: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3547:
3548: ,x_return_status OUT NOCOPY VARCHAR2
3549:
3550: ,x_msg_count OUT NOCOPY NUMBER

Line 3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3554: ,p_atlv_rec IN atlv_rec_type) IS
3555:
3556: i NUMBER :=0;
3557:
3558: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3559:
3560: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
3561:
3562: l_atlv_rec atlv_rec_type := p_atlv_rec;

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

3627: WHEN FND_API.G_EXC_ERROR THEN
3628: ROLLBACK TO delete_tmpt_lines;
3629: x_return_status := FND_API.G_RET_STS_ERROR;
3630:
3631: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3632: ,p_count => x_msg_count
3633: ,p_data => x_msg_data);
3634:
3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3634:
3635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3636: ROLLBACK TO delete_tmpt_lines;
3637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3638: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);
3641:
3642: WHEN OTHERS THEN

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

3641:
3642: WHEN OTHERS THEN
3643: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
3644: -- store SQL error message on message stack for caller
3645: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3646: ,p_count => x_msg_count
3647: ,p_data => x_msg_data);
3648: -- notify caller of an UNEXPECTED error
3649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3659: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3655: PROCEDURE delete_tmpt_lines(
3656:
3657: p_api_version IN NUMBER
3658:
3659: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3660:
3661: ,x_return_status OUT NOCOPY VARCHAR2
3662:
3663: ,x_msg_count OUT NOCOPY NUMBER

Line 3673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3669:
3670:
3671: i NUMBER :=0;
3672:
3673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3674: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3675:
3676: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
3677:

Line 3674: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3670:
3671: i NUMBER :=0;
3672:
3673: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3674: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3675:
3676: l_api_name CONSTANT VARCHAR2(30) := 'delete_tmpt_lines';
3677:
3678: l_atlv_tbl atlv_tbl_type := p_atlv_tbl;

Line 3724: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3720: ,x_msg_data => x_msg_data
3721:
3722: ,p_atlv_rec => l_atlv_tbl(i));
3723:
3724: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3725: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3726: l_overall_status := x_return_status;
3727: END IF;
3728: END IF;

Line 3725: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3721:
3722: ,p_atlv_rec => l_atlv_tbl(i));
3723:
3724: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3725: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3726: l_overall_status := x_return_status;
3727: END IF;
3728: END IF;
3729:

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

3765: WHEN FND_API.G_EXC_ERROR THEN
3766: ROLLBACK TO delete_tmpt_lines;
3767: x_return_status := FND_API.G_RET_STS_ERROR;
3768:
3769: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3770: ,p_count => x_msg_count
3771: ,p_data => x_msg_data);
3772:
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3772:
3773: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3774: ROLLBACK TO delete_tmpt_lines;
3775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3776: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3777: ,p_count => x_msg_count
3778: ,p_data => x_msg_data);
3779:
3780: WHEN OTHERS THEN

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

3779:
3780: WHEN OTHERS THEN
3781: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');
3782: -- store SQL error message on message stack for caller
3783: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3784: ,p_count => x_msg_count
3785: ,p_data => x_msg_data);
3786: -- notify caller of an UNEXPECTED error
3787: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3797: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3793: PROCEDURE validate_tmpt_lines(
3794:
3795: p_api_version IN NUMBER
3796:
3797: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3798:
3799: ,x_return_status OUT NOCOPY VARCHAR2
3800:
3801: ,x_msg_count OUT NOCOPY NUMBER

Line 3807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3803: ,x_msg_data OUT NOCOPY VARCHAR2
3804:
3805: ,p_atlv_rec IN atlv_rec_type) IS
3806:
3807: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3808:
3809: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_lines';
3810:
3811: l_atlv_rec atlv_rec_type := p_atlv_rec;

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

3878: WHEN FND_API.G_EXC_ERROR THEN
3879: ROLLBACK TO validate_tmpt_lines;
3880: x_return_status := FND_API.G_RET_STS_ERROR;
3881:
3882: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3883: ,p_count => x_msg_count
3884: ,p_data => x_msg_data);
3885:
3886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3885:
3886: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3887: ROLLBACK TO validate_tmpt_lines;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3890: ,p_count => x_msg_count
3891: ,p_data => x_msg_data);
3892:
3893: WHEN OTHERS THEN

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

3892:
3893: WHEN OTHERS THEN
3894: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');
3895: -- store SQL error message on message stack for caller
3896: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3897: ,p_count => x_msg_count
3898: ,p_data => x_msg_data);
3899: -- notify caller of an UNEXPECTED error
3900: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3910: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE

3906: PROCEDURE validate_tmpt_lines(
3907:
3908: p_api_version IN NUMBER
3909:
3910: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
3911:
3912: ,x_return_status OUT NOCOPY VARCHAR2
3913:
3914: ,x_msg_count OUT NOCOPY NUMBER

Line 3920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3916: ,x_msg_data OUT NOCOPY VARCHAR2
3917:
3918: ,p_atlv_tbl IN atlv_tbl_type) IS
3919:
3920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3922:
3923: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_lines';
3924:

Line 3921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

3917:
3918: ,p_atlv_tbl IN atlv_tbl_type) IS
3919:
3920: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3921: l_overall_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3922:
3923: l_api_name CONSTANT VARCHAR2(30) := 'validate_tmpt_lines';
3924:
3925: i NUMBER;

Line 3973: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

3969:
3970: ,p_atlv_rec => l_atlv_tbl(i)
3971:
3972: );
3973: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3974: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3975: l_overall_status := x_return_status;
3976: END IF;
3977: END IF;

Line 3974: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN

3970: ,p_atlv_rec => l_atlv_tbl(i)
3971:
3972: );
3973: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3974: IF (l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR) THEN
3975: l_overall_status := x_return_status;
3976: END IF;
3977: END IF;
3978:

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

4014: WHEN FND_API.G_EXC_ERROR THEN
4015: ROLLBACK TO validate_tmpt_lines;
4016: x_return_status := FND_API.G_RET_STS_ERROR;
4017:
4018: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4019: ,p_count => x_msg_count
4020: ,p_data => x_msg_data);
4021:
4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

4021:
4022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4023: ROLLBACK TO validate_tmpt_lines;
4024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4025: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4026: ,p_count => x_msg_count
4027: ,p_data => x_msg_data);
4028:
4029: WHEN OTHERS THEN

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

4028:
4029: WHEN OTHERS THEN
4030: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');
4031: -- store SQL error message on message stack for caller
4032: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4033: ,p_count => x_msg_count
4034: ,p_data => x_msg_data);
4035: -- notify caller of an UNEXPECTED error
4036: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;