DBA Data[Home] [Help]

APPS.OKL_ACCT_EVENT_PUB dependencies on FND_MSG_PUB

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

124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO create_acct_event;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127:
128: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
129: ,p_count => x_msg_count
130: ,p_data => x_msg_data);
131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

131:
132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO create_acct_event;
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
136: ,p_count => x_msg_count
137: ,p_data => x_msg_data);
138:
139: WHEN OTHERS THEN

Line 140: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');

136: ,p_count => x_msg_count
137: ,p_data => x_msg_data);
138:
139: WHEN OTHERS THEN
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
141: -- store SQL error message on message stack for caller
142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);

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

138:
139: WHEN OTHERS THEN
140: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
141: -- store SQL error message on message stack for caller
142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
143: ,p_count => x_msg_count
144: ,p_data => x_msg_data);
145: -- notify caller of an UNEXPECTED error
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

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

Line 260: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');

256: ,p_count => x_msg_count
257: ,p_data => x_msg_data);
258:
259: WHEN OTHERS THEN
260: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
261: -- store SQL error message on message stack for caller
262: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
263: ,p_count => x_msg_count
264: ,p_data => x_msg_data);

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

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

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

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

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

395:
396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
397: ROLLBACK TO create_acct_event;
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
400: ,p_count => x_msg_count
401: ,p_data => x_msg_data);
402:
403: WHEN OTHERS THEN

Line 404: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');

400: ,p_count => x_msg_count
401: ,p_data => x_msg_data);
402:
403: WHEN OTHERS THEN
404: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
405: -- store SQL error message on message stack for caller
406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
407: ,p_count => x_msg_count
408: ,p_data => x_msg_data);

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

402:
403: WHEN OTHERS THEN
404: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_event');
405: -- store SQL error message on message stack for caller
406: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
407: ,p_count => x_msg_count
408: ,p_data => x_msg_data);
409: -- notify caller of an UNEXPECTED error
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

537:
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: ROLLBACK TO update_acct_event;
540: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
541: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544:
545: WHEN OTHERS THEN

Line 546: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');

542: ,p_count => x_msg_count
543: ,p_data => x_msg_data);
544:
545: WHEN OTHERS THEN
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);

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

544:
545: WHEN OTHERS THEN
546: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
547: -- store SQL error message on message stack for caller
548: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
549: ,p_count => x_msg_count
550: ,p_data => x_msg_data);
551: -- notify caller of an UNEXPECTED error
552: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

666:
667: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
668: ROLLBACK TO validate_acct_event;
669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
670: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
671: ,p_count => x_msg_count
672: ,p_data => x_msg_data);
673:
674: WHEN OTHERS THEN

Line 675: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');

671: ,p_count => x_msg_count
672: ,p_data => x_msg_data);
673:
674: WHEN OTHERS THEN
675: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
676: -- store SQL error message on message stack for caller
677: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
678: ,p_count => x_msg_count
679: ,p_data => x_msg_data);

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

673:
674: WHEN OTHERS THEN
675: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
676: -- store SQL error message on message stack for caller
677: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
678: ,p_count => x_msg_count
679: ,p_data => x_msg_data);
680: -- notify caller of an UNEXPECTED error
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO lock_acct_event;
736: x_return_status := FND_API.G_RET_STS_ERROR;
737:
738: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
739: ,p_count => x_msg_count
740: ,p_data => x_msg_data);
741:
742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 750: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');

746: ,p_count => x_msg_count
747: ,p_data => x_msg_data);
748:
749: WHEN OTHERS THEN
750: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');
751: -- store SQL error message on message stack for caller
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);

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

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

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

834: WHEN FND_API.G_EXC_ERROR THEN
835: ROLLBACK TO lock_acct_event;
836: x_return_status := FND_API.G_RET_STS_ERROR;
837:
838: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
839: ,p_count => x_msg_count
840: ,p_data => x_msg_data);
841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

841:
842: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
843: ROLLBACK TO lock_acct_event;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
846: ,p_count => x_msg_count
847: ,p_data => x_msg_data);
848:
849: WHEN OTHERS THEN

Line 850: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');

846: ,p_count => x_msg_count
847: ,p_data => x_msg_data);
848:
849: WHEN OTHERS THEN
850: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_event');
851: -- store SQL error message on message stack for caller
852: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
853: ,p_count => x_msg_count
854: ,p_data => x_msg_data);

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

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

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

951: WHEN FND_API.G_EXC_ERROR THEN
952: ROLLBACK TO update_acct_event;
953: x_return_status := FND_API.G_RET_STS_ERROR;
954:
955: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
956: ,p_count => x_msg_count
957: ,p_data => x_msg_data);
958:
959: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

Line 967: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');

963: ,p_count => x_msg_count
964: ,p_data => x_msg_data);
965:
966: WHEN OTHERS THEN
967: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
968: -- store SQL error message on message stack for caller
969: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
970: ,p_count => x_msg_count
971: ,p_data => x_msg_data);

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

965:
966: WHEN OTHERS THEN
967: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
968: -- store SQL error message on message stack for caller
969: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
970: ,p_count => x_msg_count
971: ,p_data => x_msg_data);
972: -- notify caller of an UNEXPECTED error
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1089: WHEN FND_API.G_EXC_ERROR THEN
1090: ROLLBACK TO update_acct_event;
1091: x_return_status := FND_API.G_RET_STS_ERROR;
1092:
1093: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1094: ,p_count => x_msg_count
1095: ,p_data => x_msg_data);
1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1096:
1097: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1098: ROLLBACK TO update_acct_event;
1099: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 OTHERS THEN

Line 1105: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');

1101: ,p_count => x_msg_count
1102: ,p_data => x_msg_data);
1103:
1104: WHEN OTHERS THEN
1105: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
1106: -- store SQL error message on message stack for caller
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);

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

1103:
1104: WHEN OTHERS THEN
1105: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_event');
1106: -- store SQL error message on message stack for caller
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: -- notify caller of an UNEXPECTED error
1111: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK TO delete_acct_event;
1210: x_return_status := FND_API.G_RET_STS_ERROR;
1211:
1212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1213: ,p_count => x_msg_count
1214: ,p_data => x_msg_data);
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO delete_acct_event;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1220: ,p_count => x_msg_count
1221: ,p_data => x_msg_data);
1222:
1223: WHEN OTHERS THEN

Line 1224: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');

1220: ,p_count => x_msg_count
1221: ,p_data => x_msg_data);
1222:
1223: WHEN OTHERS THEN
1224: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1225: -- store SQL error message on message stack for caller
1226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1227: ,p_count => x_msg_count
1228: ,p_data => x_msg_data);

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

1222:
1223: WHEN OTHERS THEN
1224: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1225: -- store SQL error message on message stack for caller
1226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1227: ,p_count => x_msg_count
1228: ,p_data => x_msg_data);
1229: -- notify caller of an UNEXPECTED error
1230: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1341: WHEN FND_API.G_EXC_ERROR THEN
1342: ROLLBACK TO delete_acct_event;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344:
1345: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1346: ,p_count => x_msg_count
1347: ,p_data => x_msg_data);
1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1348:
1349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1350: ROLLBACK TO delete_acct_event;
1351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1353: ,p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355:
1356: WHEN OTHERS THEN

Line 1357: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');

1353: ,p_count => x_msg_count
1354: ,p_data => x_msg_data);
1355:
1356: WHEN OTHERS THEN
1357: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1358: -- store SQL error message on message stack for caller
1359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1360: ,p_count => x_msg_count
1361: ,p_data => x_msg_data);

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

1355:
1356: WHEN OTHERS THEN
1357: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_event');
1358: -- store SQL error message on message stack for caller
1359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1360: ,p_count => x_msg_count
1361: ,p_data => x_msg_data);
1362: -- notify caller of an UNEXPECTED error
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1457: WHEN FND_API.G_EXC_ERROR THEN
1458: ROLLBACK TO validate_acct_event;
1459: x_return_status := FND_API.G_RET_STS_ERROR;
1460:
1461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1462: ,p_count => x_msg_count
1463: ,p_data => x_msg_data);
1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1464:
1465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1466: ROLLBACK TO validate_acct_event;
1467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1469: ,p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471:
1472: WHEN OTHERS THEN

Line 1473: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');

1469: ,p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471:
1472: WHEN OTHERS THEN
1473: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1474: -- store SQL error message on message stack for caller
1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);

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

1471:
1472: WHEN OTHERS THEN
1473: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1474: -- store SQL error message on message stack for caller
1475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1476: ,p_count => x_msg_count
1477: ,p_data => x_msg_data);
1478: -- notify caller of an UNEXPECTED error
1479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO validate_acct_event;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594:
1595: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1596: ,p_count => x_msg_count
1597: ,p_data => x_msg_data);
1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1598:
1599: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1600: ROLLBACK TO validate_acct_event;
1601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1602: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1603: ,p_count => x_msg_count
1604: ,p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN

Line 1607: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');

1603: ,p_count => x_msg_count
1604: ,p_data => x_msg_data);
1605:
1606: WHEN OTHERS THEN
1607: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1608: -- store SQL error message on message stack for caller
1609: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1610: ,p_count => x_msg_count
1611: ,p_data => x_msg_data);

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

1605:
1606: WHEN OTHERS THEN
1607: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_event');
1608: -- store SQL error message on message stack for caller
1609: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1610: ,p_count => x_msg_count
1611: ,p_data => x_msg_data);
1612: -- notify caller of an UNEXPECTED error
1613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1714: WHEN FND_API.G_EXC_ERROR THEN
1715: ROLLBACK TO create_acct_header;
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:
1718: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1719: ,p_count => x_msg_count
1720: ,p_data => x_msg_data);
1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1721:
1722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1723: ROLLBACK TO create_acct_header;
1724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1725: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1726: ,p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728:
1729: WHEN OTHERS THEN

Line 1730: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');

1726: ,p_count => x_msg_count
1727: ,p_data => x_msg_data);
1728:
1729: WHEN OTHERS THEN
1730: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1731: -- store SQL error message on message stack for caller
1732: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1733: ,p_count => x_msg_count
1734: ,p_data => x_msg_data);

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

1728:
1729: WHEN OTHERS THEN
1730: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1731: -- store SQL error message on message stack for caller
1732: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1733: ,p_count => x_msg_count
1734: ,p_data => x_msg_data);
1735: -- notify caller of an UNEXPECTED error
1736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1852: WHEN FND_API.G_EXC_ERROR THEN
1853: ROLLBACK TO create_acct_header;
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855:
1856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1857: ,p_count => x_msg_count
1858: ,p_data => x_msg_data);
1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1859:
1860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1861: ROLLBACK TO create_acct_header;
1862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1864: ,p_count => x_msg_count
1865: ,p_data => x_msg_data);
1866:
1867: WHEN OTHERS THEN

Line 1868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');

1864: ,p_count => x_msg_count
1865: ,p_data => x_msg_data);
1866:
1867: WHEN OTHERS THEN
1868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1869: -- store SQL error message on message stack for caller
1870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data);

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

1866:
1867: WHEN OTHERS THEN
1868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_header');
1869: -- store SQL error message on message stack for caller
1870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1871: ,p_count => x_msg_count
1872: ,p_data => x_msg_data);
1873: -- notify caller of an UNEXPECTED error
1874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1927: WHEN FND_API.G_EXC_ERROR THEN
1928: ROLLBACK TO lock_acct_header;
1929: x_return_status := FND_API.G_RET_STS_ERROR;
1930:
1931: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1932: ,p_count => x_msg_count
1933: ,p_data => x_msg_data);
1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1934:
1935: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1936: ROLLBACK TO lock_acct_header;
1937: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1938: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data);
1941:
1942: WHEN OTHERS THEN

Line 1943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');

1939: ,p_count => x_msg_count
1940: ,p_data => x_msg_data);
1941:
1942: WHEN OTHERS THEN
1943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
1944: -- store SQL error message on message stack for caller
1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data);

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

1941:
1942: WHEN OTHERS THEN
1943: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
1944: -- store SQL error message on message stack for caller
1945: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1946: ,p_count => x_msg_count
1947: ,p_data => x_msg_data);
1948: -- notify caller of an UNEXPECTED error
1949: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2027: WHEN FND_API.G_EXC_ERROR THEN
2028: ROLLBACK TO lock_acct_header;
2029: x_return_status := FND_API.G_RET_STS_ERROR;
2030:
2031: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2032: ,p_count => x_msg_count
2033: ,p_data => x_msg_data);
2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2034:
2035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2036: ROLLBACK TO lock_acct_header;
2037: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2038: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2039: ,p_count => x_msg_count
2040: ,p_data => x_msg_data);
2041:
2042: WHEN OTHERS THEN

Line 2043: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');

2039: ,p_count => x_msg_count
2040: ,p_data => x_msg_data);
2041:
2042: WHEN OTHERS THEN
2043: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
2044: -- store SQL error message on message stack for caller
2045: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2046: ,p_count => x_msg_count
2047: ,p_data => x_msg_data);

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

2041:
2042: WHEN OTHERS THEN
2043: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_header');
2044: -- store SQL error message on message stack for caller
2045: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2046: ,p_count => x_msg_count
2047: ,p_data => x_msg_data);
2048: -- notify caller of an UNEXPECTED error
2049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2143: WHEN FND_API.G_EXC_ERROR THEN
2144: ROLLBACK TO update_acct_header;
2145: x_return_status := FND_API.G_RET_STS_ERROR;
2146:
2147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2148: ,p_count => x_msg_count
2149: ,p_data => x_msg_data);
2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2150:
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: ROLLBACK TO update_acct_header;
2153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2155: ,p_count => x_msg_count
2156: ,p_data => x_msg_data);
2157:
2158: WHEN OTHERS THEN

Line 2159: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');

2155: ,p_count => x_msg_count
2156: ,p_data => x_msg_data);
2157:
2158: WHEN OTHERS THEN
2159: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2160: -- store SQL error message on message stack for caller
2161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2162: ,p_count => x_msg_count
2163: ,p_data => x_msg_data);

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

2157:
2158: WHEN OTHERS THEN
2159: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2160: -- store SQL error message on message stack for caller
2161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2162: ,p_count => x_msg_count
2163: ,p_data => x_msg_data);
2164: -- notify caller of an UNEXPECTED error
2165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2283: WHEN FND_API.G_EXC_ERROR THEN
2284: ROLLBACK TO update_acct_header;
2285: x_return_status := FND_API.G_RET_STS_ERROR;
2286:
2287: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2288: ,p_count => x_msg_count
2289: ,p_data => x_msg_data);
2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2290:
2291: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2292: ROLLBACK TO update_acct_header;
2293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2294: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2295: ,p_count => x_msg_count
2296: ,p_data => x_msg_data);
2297:
2298: WHEN OTHERS THEN

Line 2299: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');

2295: ,p_count => x_msg_count
2296: ,p_data => x_msg_data);
2297:
2298: WHEN OTHERS THEN
2299: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2300: -- store SQL error message on message stack for caller
2301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2302: ,p_count => x_msg_count
2303: ,p_data => x_msg_data);

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

2297:
2298: WHEN OTHERS THEN
2299: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_header');
2300: -- store SQL error message on message stack for caller
2301: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2302: ,p_count => x_msg_count
2303: ,p_data => x_msg_data);
2304: -- notify caller of an UNEXPECTED error
2305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2398: WHEN FND_API.G_EXC_ERROR THEN
2399: ROLLBACK TO delete_acct_header;
2400: x_return_status := FND_API.G_RET_STS_ERROR;
2401:
2402: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2403: ,p_count => x_msg_count
2404: ,p_data => x_msg_data);
2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2405:
2406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2407: ROLLBACK TO delete_acct_header;
2408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2409: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2410: ,p_count => x_msg_count
2411: ,p_data => x_msg_data);
2412:
2413: WHEN OTHERS THEN

Line 2414: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');

2410: ,p_count => x_msg_count
2411: ,p_data => x_msg_data);
2412:
2413: WHEN OTHERS THEN
2414: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2415: -- store SQL error message on message stack for caller
2416: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2417: ,p_count => x_msg_count
2418: ,p_data => x_msg_data);

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

2412:
2413: WHEN OTHERS THEN
2414: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2415: -- store SQL error message on message stack for caller
2416: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2417: ,p_count => x_msg_count
2418: ,p_data => x_msg_data);
2419: -- notify caller of an UNEXPECTED error
2420: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2535: WHEN FND_API.G_EXC_ERROR THEN
2536: ROLLBACK TO delete_acct_header;
2537: x_return_status := FND_API.G_RET_STS_ERROR;
2538:
2539: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2540: ,p_count => x_msg_count
2541: ,p_data => x_msg_data);
2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2542:
2543: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2544: ROLLBACK TO delete_acct_header;
2545: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2546: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2547: ,p_count => x_msg_count
2548: ,p_data => x_msg_data);
2549:
2550: WHEN OTHERS THEN

Line 2551: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');

2547: ,p_count => x_msg_count
2548: ,p_data => x_msg_data);
2549:
2550: WHEN OTHERS THEN
2551: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2552: -- store SQL error message on message stack for caller
2553: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2554: ,p_count => x_msg_count
2555: ,p_data => x_msg_data);

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

2549:
2550: WHEN OTHERS THEN
2551: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_header');
2552: -- store SQL error message on message stack for caller
2553: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2554: ,p_count => x_msg_count
2555: ,p_data => x_msg_data);
2556: -- notify caller of an UNEXPECTED error
2557: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2648: WHEN FND_API.G_EXC_ERROR THEN
2649: ROLLBACK TO validate_acct_header;
2650: x_return_status := FND_API.G_RET_STS_ERROR;
2651:
2652: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2653: ,p_count => x_msg_count
2654: ,p_data => x_msg_data);
2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2655:
2656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2657: ROLLBACK TO validate_acct_header;
2658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2659: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2660: ,p_count => x_msg_count
2661: ,p_data => x_msg_data);
2662:
2663: WHEN OTHERS THEN

Line 2664: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');

2660: ,p_count => x_msg_count
2661: ,p_data => x_msg_data);
2662:
2663: WHEN OTHERS THEN
2664: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2665: -- store SQL error message on message stack for caller
2666: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2667: ,p_count => x_msg_count
2668: ,p_data => x_msg_data);

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

2662:
2663: WHEN OTHERS THEN
2664: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2665: -- store SQL error message on message stack for caller
2666: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2667: ,p_count => x_msg_count
2668: ,p_data => x_msg_data);
2669: -- notify caller of an UNEXPECTED error
2670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2788: WHEN FND_API.G_EXC_ERROR THEN
2789: ROLLBACK TO validate_acct_header;
2790: x_return_status := FND_API.G_RET_STS_ERROR;
2791:
2792: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2793: ,p_count => x_msg_count
2794: ,p_data => x_msg_data);
2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2795:
2796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2797: ROLLBACK TO validate_acct_header;
2798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2799: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2800: ,p_count => x_msg_count
2801: ,p_data => x_msg_data);
2802:
2803: WHEN OTHERS THEN

Line 2804: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');

2800: ,p_count => x_msg_count
2801: ,p_data => x_msg_data);
2802:
2803: WHEN OTHERS THEN
2804: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2805: -- store SQL error message on message stack for caller
2806: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2807: ,p_count => x_msg_count
2808: ,p_data => x_msg_data);

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

2802:
2803: WHEN OTHERS THEN
2804: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_header');
2805: -- store SQL error message on message stack for caller
2806: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2807: ,p_count => x_msg_count
2808: ,p_data => x_msg_data);
2809: -- notify caller of an UNEXPECTED error
2810: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2911: WHEN FND_API.G_EXC_ERROR THEN
2912: ROLLBACK TO create_acct_lines;
2913: x_return_status := FND_API.G_RET_STS_ERROR;
2914:
2915: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2916: ,p_count => x_msg_count
2917: ,p_data => x_msg_data);
2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2918:
2919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2920: ROLLBACK TO create_acct_lines;
2921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2922: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2923: ,p_count => x_msg_count
2924: ,p_data => x_msg_data);
2925:
2926: WHEN OTHERS THEN

Line 2927: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');

2923: ,p_count => x_msg_count
2924: ,p_data => x_msg_data);
2925:
2926: WHEN OTHERS THEN
2927: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
2928: -- store SQL error message on message stack for caller
2929: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2930: ,p_count => x_msg_count
2931: ,p_data => x_msg_data);

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

2925:
2926: WHEN OTHERS THEN
2927: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
2928: -- store SQL error message on message stack for caller
2929: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2930: ,p_count => x_msg_count
2931: ,p_data => x_msg_data);
2932: -- notify caller of an UNEXPECTED error
2933: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3053: WHEN FND_API.G_EXC_ERROR THEN
3054: ROLLBACK TO create_acct_lines;
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056:
3057: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3058: ,p_count => x_msg_count
3059: ,p_data => x_msg_data);
3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3060:
3061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3062: ROLLBACK TO create_acct_lines;
3063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3064: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3065: ,p_count => x_msg_count
3066: ,p_data => x_msg_data);
3067:
3068: WHEN OTHERS THEN

Line 3069: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');

3065: ,p_count => x_msg_count
3066: ,p_data => x_msg_data);
3067:
3068: WHEN OTHERS THEN
3069: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
3070: -- store SQL error message on message stack for caller
3071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3072: ,p_count => x_msg_count
3073: ,p_data => x_msg_data);

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

3067:
3068: WHEN OTHERS THEN
3069: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','create_acct_lines');
3070: -- store SQL error message on message stack for caller
3071: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3072: ,p_count => x_msg_count
3073: ,p_data => x_msg_data);
3074: -- notify caller of an UNEXPECTED error
3075: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3127: WHEN FND_API.G_EXC_ERROR THEN
3128: ROLLBACK TO lock_acct_lines;
3129: x_return_status := FND_API.G_RET_STS_ERROR;
3130:
3131: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3132: ,p_count => x_msg_count
3133: ,p_data => x_msg_data);
3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3134:
3135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3136: ROLLBACK TO lock_acct_lines;
3137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3138: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3139: ,p_count => x_msg_count
3140: ,p_data => x_msg_data);
3141:
3142: WHEN OTHERS THEN

Line 3143: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');

3139: ,p_count => x_msg_count
3140: ,p_data => x_msg_data);
3141:
3142: WHEN OTHERS THEN
3143: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3144: -- store SQL error message on message stack for caller
3145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3146: ,p_count => x_msg_count
3147: ,p_data => x_msg_data);

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

3141:
3142: WHEN OTHERS THEN
3143: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3144: -- store SQL error message on message stack for caller
3145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3146: ,p_count => x_msg_count
3147: ,p_data => x_msg_data);
3148: -- notify caller of an UNEXPECTED error
3149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ROLLBACK TO lock_acct_lines;
3229: x_return_status := FND_API.G_RET_STS_ERROR;
3230:
3231: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3232: ,p_count => x_msg_count
3233: ,p_data => x_msg_data);
3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3234:
3235: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3236: ROLLBACK TO lock_acct_lines;
3237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3239: ,p_count => x_msg_count
3240: ,p_data => x_msg_data);
3241:
3242: WHEN OTHERS THEN

Line 3243: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');

3239: ,p_count => x_msg_count
3240: ,p_data => x_msg_data);
3241:
3242: WHEN OTHERS THEN
3243: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3244: -- store SQL error message on message stack for caller
3245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);

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

3241:
3242: WHEN OTHERS THEN
3243: FND_MSG_PUB.ADD_EXC_MSG('OKL_TMPT_SET_PUB','lock_acct_lines');
3244: -- store SQL error message on message stack for caller
3245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3246: ,p_count => x_msg_count
3247: ,p_data => x_msg_data);
3248: -- notify caller of an UNEXPECTED error
3249: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3343: WHEN FND_API.G_EXC_ERROR THEN
3344: ROLLBACK TO update_acct_lines;
3345: x_return_status := FND_API.G_RET_STS_ERROR;
3346:
3347: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3348: ,p_count => x_msg_count
3349: ,p_data => x_msg_data);
3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3350:
3351: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3352: ROLLBACK TO update_acct_lines;
3353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3354: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3355: ,p_count => x_msg_count
3356: ,p_data => x_msg_data);
3357:
3358: WHEN OTHERS THEN

Line 3359: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');

3355: ,p_count => x_msg_count
3356: ,p_data => x_msg_data);
3357:
3358: WHEN OTHERS THEN
3359: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3360: -- store SQL error message on message stack for caller
3361: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3362: ,p_count => x_msg_count
3363: ,p_data => x_msg_data);

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

3357:
3358: WHEN OTHERS THEN
3359: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3360: -- store SQL error message on message stack for caller
3361: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3362: ,p_count => x_msg_count
3363: ,p_data => x_msg_data);
3364: -- notify caller of an UNEXPECTED error
3365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3485: WHEN FND_API.G_EXC_ERROR THEN
3486: ROLLBACK TO update_acct_lines;
3487: x_return_status := FND_API.G_RET_STS_ERROR;
3488:
3489: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3490: ,p_count => x_msg_count
3491: ,p_data => x_msg_data);
3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3492:
3493: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3494: ROLLBACK TO update_acct_lines;
3495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3496: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3497: ,p_count => x_msg_count
3498: ,p_data => x_msg_data);
3499:
3500: WHEN OTHERS THEN

Line 3501: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');

3497: ,p_count => x_msg_count
3498: ,p_data => x_msg_data);
3499:
3500: WHEN OTHERS THEN
3501: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3502: -- store SQL error message on message stack for caller
3503: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3504: ,p_count => x_msg_count
3505: ,p_data => x_msg_data);

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

3499:
3500: WHEN OTHERS THEN
3501: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','update_acct_lines');
3502: -- store SQL error message on message stack for caller
3503: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3504: ,p_count => x_msg_count
3505: ,p_data => x_msg_data);
3506: -- notify caller of an UNEXPECTED error
3507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3600: WHEN FND_API.G_EXC_ERROR THEN
3601: ROLLBACK TO delete_acct_lines;
3602: x_return_status := FND_API.G_RET_STS_ERROR;
3603:
3604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3605: ,p_count => x_msg_count
3606: ,p_data => x_msg_data);
3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3607:
3608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3609: ROLLBACK TO delete_acct_lines;
3610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3612: ,p_count => x_msg_count
3613: ,p_data => x_msg_data);
3614:
3615: WHEN OTHERS THEN

Line 3616: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');

3612: ,p_count => x_msg_count
3613: ,p_data => x_msg_data);
3614:
3615: WHEN OTHERS THEN
3616: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3617: -- store SQL error message on message stack for caller
3618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3619: ,p_count => x_msg_count
3620: ,p_data => x_msg_data);

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

3614:
3615: WHEN OTHERS THEN
3616: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3617: -- store SQL error message on message stack for caller
3618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3619: ,p_count => x_msg_count
3620: ,p_data => x_msg_data);
3621: -- notify caller of an UNEXPECTED error
3622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3739: WHEN FND_API.G_EXC_ERROR THEN
3740: ROLLBACK TO delete_acct_lines;
3741: x_return_status := FND_API.G_RET_STS_ERROR;
3742:
3743: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3744: ,p_count => x_msg_count
3745: ,p_data => x_msg_data);
3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3746:
3747: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3748: ROLLBACK TO delete_acct_lines;
3749: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3750: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3751: ,p_count => x_msg_count
3752: ,p_data => x_msg_data);
3753:
3754: WHEN OTHERS THEN

Line 3755: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');

3751: ,p_count => x_msg_count
3752: ,p_data => x_msg_data);
3753:
3754: WHEN OTHERS THEN
3755: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3756: -- store SQL error message on message stack for caller
3757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3758: ,p_count => x_msg_count
3759: ,p_data => x_msg_data);

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

3753:
3754: WHEN OTHERS THEN
3755: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','delete_acct_lines');
3756: -- store SQL error message on message stack for caller
3757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3758: ,p_count => x_msg_count
3759: ,p_data => x_msg_data);
3760: -- notify caller of an UNEXPECTED error
3761: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3852: WHEN FND_API.G_EXC_ERROR THEN
3853: ROLLBACK TO validate_acct_lines;
3854: x_return_status := FND_API.G_RET_STS_ERROR;
3855:
3856: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3857: ,p_count => x_msg_count
3858: ,p_data => x_msg_data);
3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3859:
3860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3861: ROLLBACK TO validate_acct_lines;
3862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3863: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3864: ,p_count => x_msg_count
3865: ,p_data => x_msg_data);
3866:
3867: WHEN OTHERS THEN

Line 3868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');

3864: ,p_count => x_msg_count
3865: ,p_data => x_msg_data);
3866:
3867: WHEN OTHERS THEN
3868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
3869: -- store SQL error message on message stack for caller
3870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3871: ,p_count => x_msg_count
3872: ,p_data => x_msg_data);

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

3866:
3867: WHEN OTHERS THEN
3868: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
3869: -- store SQL error message on message stack for caller
3870: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3871: ,p_count => x_msg_count
3872: ,p_data => x_msg_data);
3873: -- notify caller of an UNEXPECTED error
3874: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3984: WHEN FND_API.G_EXC_ERROR THEN
3985: ROLLBACK TO validate_acct_lines;
3986: x_return_status := FND_API.G_RET_STS_ERROR;
3987:
3988: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3989: ,p_count => x_msg_count
3990: ,p_data => x_msg_data);
3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

3991:
3992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3993: ROLLBACK TO validate_acct_lines;
3994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3995: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
3996: ,p_count => x_msg_count
3997: ,p_data => x_msg_data);
3998:
3999: WHEN OTHERS THEN

Line 4000: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');

3996: ,p_count => x_msg_count
3997: ,p_data => x_msg_data);
3998:
3999: WHEN OTHERS THEN
4000: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
4001: -- store SQL error message on message stack for caller
4002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4003: ,p_count => x_msg_count
4004: ,p_data => x_msg_data);

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

3998:
3999: WHEN OTHERS THEN
4000: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_EVENT_PUB','validate_acct_lines');
4001: -- store SQL error message on message stack for caller
4002: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
4003: ,p_count => x_msg_count
4004: ,p_data => x_msg_data);
4005: -- notify caller of an UNEXPECTED error
4006: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;