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 FND_MSG_PUB

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 136: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

132: ,p_count => x_msg_count
133: ,p_data => x_msg_data);
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);

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 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 257: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

253: ,p_count => x_msg_count
254: ,p_data => x_msg_data);
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);

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 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 398: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_set');

394: ,p_count => x_msg_count
395: ,p_data => x_msg_data);
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);

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 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 540: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

536: ,p_count => x_msg_count
537: ,p_data => x_msg_data);
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);

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 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 669: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

665: ,p_count => x_msg_count
666: ,p_data => x_msg_data);
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);

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 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 749: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');

745: ,p_count => x_msg_count
746: ,p_data => x_msg_data);
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);

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 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 854: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_set');

850: ,p_count => x_msg_count
851: ,p_data => x_msg_data);
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);

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 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 973: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

969: ,p_count => x_msg_count
970: ,p_data => x_msg_data);
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);

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 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 1112: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_set');

1108: ,p_count => x_msg_count
1109: ,p_data => x_msg_data);
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);

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 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 1234: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');

1230: ,p_count => x_msg_count
1231: ,p_data => x_msg_data);
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);

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 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 1369: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_set');

1365: ,p_count => x_msg_count
1366: ,p_data => x_msg_data);
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);

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 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 1484: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

1480: ,p_count => x_msg_count
1481: ,p_data => x_msg_data);
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);

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 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 1617: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_set');

1613: ,p_count => x_msg_count
1614: ,p_data => x_msg_data);
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);

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 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 1740: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');

1736: ,p_count => x_msg_count
1737: ,p_data => x_msg_data);
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);

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 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 1885: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_template');

1881: ,p_count => x_msg_count
1882: ,p_data => x_msg_data);
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);

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 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 1960: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');

1956: ,p_count => x_msg_count
1957: ,p_data => x_msg_data);
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);

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 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 2065: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_template');

2061: ,p_count => x_msg_count
2062: ,p_data => x_msg_data);
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);

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 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 2182: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');

2178: ,p_count => x_msg_count
2179: ,p_data => x_msg_data);
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);

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 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 2322: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_template');

2318: ,p_count => x_msg_count
2319: ,p_data => x_msg_data);
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);

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 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 2438: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');

2434: ,p_count => x_msg_count
2435: ,p_data => x_msg_data);
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);

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 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 2576: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_template');

2572: ,p_count => x_msg_count
2573: ,p_data => x_msg_data);
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);

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 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 2690: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');

2686: ,p_count => x_msg_count
2687: ,p_data => x_msg_data);
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);

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 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 2825: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_template');

2821: ,p_count => x_msg_count
2822: ,p_data => x_msg_data);
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);

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 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 2947: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');

2943: ,p_count => x_msg_count
2944: ,p_data => x_msg_data);
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);

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 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 3091: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','create_tmpt_lines');

3087: ,p_count => x_msg_count
3088: ,p_data => x_msg_data);
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);

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 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 3166: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');

3162: ,p_count => x_msg_count
3163: ,p_data => x_msg_data);
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);

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 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 3272: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_tmpt_lines');

3268: ,p_count => x_msg_count
3269: ,p_data => x_msg_data);
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);

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 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 3388: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');

3384: ,p_count => x_msg_count
3385: ,p_data => x_msg_data);
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);

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 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 3528: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','update_tmpt_lines');

3524: ,p_count => x_msg_count
3525: ,p_data => x_msg_data);
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);

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 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 3643: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');

3639: ,p_count => x_msg_count
3640: ,p_data => x_msg_data);
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);

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 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 3781: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','delete_tmpt_lines');

3777: ,p_count => x_msg_count
3778: ,p_data => x_msg_data);
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);

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 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 3894: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');

3890: ,p_count => x_msg_count
3891: ,p_data => x_msg_data);
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);

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 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 4030: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','validate_tmpt_lines');

4026: ,p_count => x_msg_count
4027: ,p_data => x_msg_data);
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);

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;