1: PACKAGE BODY OKL_ACC_GROUP_PUB AS
2: /* $Header: OKLPAGCB.pls 115.5 2002/12/18 12:09:28 kjinger noship $ */
3:
4:
5: PROCEDURE create_acc_group(p_api_version IN NUMBER
91: ,p_count => x_msg_count
92: ,p_data => x_msg_data);
93:
94: WHEN OTHERS THEN
95: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_group');
96: -- store SQL error message on message stack for caller
97: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
98: ,p_count => x_msg_count
99: ,p_data => x_msg_data);
189: ,p_count => x_msg_count
190: ,p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
193: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_ccid');
194: -- store SQL error message on message stack for caller
195: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
196: ,p_count => x_msg_count
197: ,p_data => x_msg_data);
245: i := l_agcv_tbl.FIRST;
246:
247: LOOP
248:
249: OKL_ACC_GROUP_PUB.create_acc_ccid(
250: p_api_version => p_api_version
251: ,p_init_msg_list => p_init_msg_list
252: ,x_return_status => l_return_status
253: ,x_msg_count => x_msg_count
309: ,p_count => x_msg_count
310: ,p_data => x_msg_data);
311:
312: WHEN OTHERS THEN
313: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_ccid');
314: -- store SQL error message on message stack for caller
315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
316: ,p_count => x_msg_count
317: ,p_data => x_msg_data);
415: ,p_count => x_msg_count
416: ,p_data => x_msg_data);
417:
418: WHEN OTHERS THEN
419: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
420: -- store SQL error message on message stack for caller
421: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
422: ,p_count => x_msg_count
423: ,p_data => x_msg_data);
515: ,p_count => x_msg_count
516: ,p_data => x_msg_data);
517:
518: WHEN OTHERS THEN
519: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_group');
520: -- store SQL error message on message stack for caller
521: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
522: ,p_count => x_msg_count
523: ,p_data => x_msg_data);
581: ,p_count => x_msg_count
582: ,p_data => x_msg_data);
583:
584: WHEN OTHERS THEN
585: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_ccid');
586: -- store SQL error message on message stack for caller
587: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
588: ,p_count => x_msg_count
589: ,p_data => x_msg_data);
621: i := p_agcv_tbl.FIRST;
622:
623: LOOP
624:
625: OKL_ACC_GROUP_PUB.lock_acc_ccid(p_api_version => p_api_version
626: ,p_init_msg_list => p_init_msg_list
627: ,x_return_status => l_return_status
628: ,x_msg_count => x_msg_count
629: ,x_msg_data => x_msg_data
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);
891:
892: WHEN OTHERS THEN
893: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_ccid');
894: -- store SQL error message on message stack for caller
895: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
896: ,p_count => x_msg_count
897: ,p_data => x_msg_data);
1010: ,p_count => x_msg_count
1011: ,p_data => x_msg_data);
1012:
1013: WHEN OTHERS THEN
1014: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1015: -- store SQL error message on message stack for caller
1016: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1017: ,p_count => x_msg_count
1018: ,p_data => x_msg_data);
1146: ,p_count => x_msg_count
1147: ,p_data => x_msg_data);
1148:
1149: WHEN OTHERS THEN
1150: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_ccid');
1151: -- store SQL error message on message stack for caller
1152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1153: ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1263: ,p_count => x_msg_count
1264: ,p_data => x_msg_data);
1265:
1266: WHEN OTHERS THEN
1267: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1268: -- store SQL error message on message stack for caller
1269: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1270: ,p_count => x_msg_count
1271: ,p_data => x_msg_data);
1397: ,p_count => x_msg_count
1398: ,p_data => x_msg_data);
1399:
1400: WHEN OTHERS THEN
1401: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_ccid');
1402: -- store SQL error message on message stack for caller
1403: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1404: ,p_count => x_msg_count
1405: ,p_data => x_msg_data);
1517: ,p_count => x_msg_count
1518: ,p_data => x_msg_data);
1519:
1520: WHEN OTHERS THEN
1521: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1522: -- store SQL error message on message stack for caller
1523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1524: ,p_count => x_msg_count
1525: ,p_data => x_msg_data);
1658: ,p_count => x_msg_count
1659: ,p_data => x_msg_data);
1660:
1661: WHEN OTHERS THEN
1662: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','create_acc_bal');
1663: -- store SQL error message on message stack for caller
1664: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1665: ,p_count => x_msg_count
1666: ,p_data => x_msg_data);
1734: ,p_count => x_msg_count
1735: ,p_data => x_msg_data);
1736:
1737: WHEN OTHERS THEN
1738: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1739: -- store SQL error message on message stack for caller
1740: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1741: ,p_count => x_msg_count
1742: ,p_data => x_msg_data);
1838: ,p_count => x_msg_count
1839: ,p_data => x_msg_data);
1840:
1841: WHEN OTHERS THEN
1842: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','lock_acc_bal');
1843: -- store SQL error message on message stack for caller
1844: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1845: ,p_count => x_msg_count
1846: ,p_data => x_msg_data);
1953: ,p_count => x_msg_count
1954: ,p_data => x_msg_data);
1955:
1956: WHEN OTHERS THEN
1957: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
1958: -- store SQL error message on message stack for caller
1959: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
1960: ,p_count => x_msg_count
1961: ,p_data => x_msg_data);
2093: ,p_count => x_msg_count
2094: ,p_data => x_msg_data);
2095:
2096: WHEN OTHERS THEN
2097: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','update_acc_bal');
2098: -- store SQL error message on message stack for caller
2099: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2100: ,p_count => x_msg_count
2101: ,p_data => x_msg_data);
2210: ,p_count => x_msg_count
2211: ,p_data => x_msg_data);
2212:
2213: WHEN OTHERS THEN
2214: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2215: -- store SQL error message on message stack for caller
2216: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2217: ,p_count => x_msg_count
2218: ,p_data => x_msg_data);
2346: ,p_count => x_msg_count
2347: ,p_data => x_msg_data);
2348:
2349: WHEN OTHERS THEN
2350: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','delete_acc_bal');
2351: -- store SQL error message on message stack for caller
2352: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2353: ,p_count => x_msg_count
2354: ,p_data => x_msg_data);
2459: ,p_count => x_msg_count
2460: ,p_data => x_msg_data);
2461:
2462: WHEN OTHERS THEN
2463: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2464: -- store SQL error message on message stack for caller
2465: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2466: ,p_count => x_msg_count
2467: ,p_data => x_msg_data);
2594: ,p_count => x_msg_count
2595: ,p_data => x_msg_data);
2596:
2597: WHEN OTHERS THEN
2598: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACC_GROUP_PUB','validate_acc_bal');
2599: -- store SQL error message on message stack for caller
2600: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
2601: ,p_count => x_msg_count
2602: ,p_data => x_msg_data);
2606: END validate_acc_bal;
2607:
2608:
2609:
2610: END OKL_ACC_GROUP_PUB;
2611: