21: BEGIN
22:
23: SAVEPOINT GET_RULE_LINES_COUNT;
24:
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26:
27: -- customer pre-processing
28:
29:
57:
58:
59: EXCEPTION
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62: ROLLBACK TO GET_RULE_LINES_COUNT;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
59: EXCEPTION
60:
61: WHEN FND_API.G_EXC_ERROR THEN
62: ROLLBACK TO GET_RULE_LINES_COUNT;
63: x_return_status := FND_API.G_RET_STS_ERROR;
64:
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
65: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
70: ROLLBACK TO GET_RULE_LINES_COUNT;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
73: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:
69: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
70: ROLLBACK TO GET_RULE_LINES_COUNT;
71: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
72: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
73: ,p_count => x_msg_count
74: ,p_data => x_msg_data);
75:
78: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_GEN_RULE_PUB','GET_RULE_LINES_COUNT');
79: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
80: ,p_count => x_msg_count
81: ,p_data => x_msg_data);
82: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
83:
84:
85:
86: END GET_RULE_LINES_COUNT;
107: BEGIN
108:
109: SAVEPOINT GET_RULE_LINES;
110:
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: -- customer pre-processing
114:
115:
143:
144:
145: EXCEPTION
146:
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO GET_RULE_LINES;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150:
151: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
145: EXCEPTION
146:
147: WHEN FND_API.G_EXC_ERROR THEN
148: ROLLBACK TO GET_RULE_LINES;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150:
151: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
151: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
152: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO GET_RULE_LINES;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
153: ,p_data => x_msg_data);
154:
155: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
156: ROLLBACK TO GET_RULE_LINES;
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
159: ,p_count => x_msg_count
160: ,p_data => x_msg_data);
161:
164: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCT_GEN_RULE_PUB','GET_RULE_LINES');
165: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
166: ,p_count => x_msg_count
167: ,p_data => x_msg_data);
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169:
170:
171:
172: END GET_RULE_LINES;
194: BEGIN
195:
196: SAVEPOINT UPDT_RULE_LINES;
197:
198: x_return_status := FND_API.G_RET_STS_SUCCESS;
199:
200: -- customer pre-processing
201:
202:
216:
217:
218: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
219:
220: RAISE FND_API.G_EXC_ERROR;
221:
222: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
223:
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
220: RAISE FND_API.G_EXC_ERROR;
221:
222: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
223:
224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
225:
226: END IF;
227:
228: l_acc_lines := x_acc_lines;
232:
233:
234: EXCEPTION
235:
236: WHEN FND_API.G_EXC_ERROR THEN
237: ROLLBACK TO UPDT_RULE_LINES;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
234: EXCEPTION
235:
236: WHEN FND_API.G_EXC_ERROR THEN
237: ROLLBACK TO UPDT_RULE_LINES;
238: x_return_status := FND_API.G_RET_STS_ERROR;
239:
240: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
240: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
241: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO UPDT_RULE_LINES;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
248: ,p_count => x_msg_count
242: ,p_data => x_msg_data);
243:
244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
245: ROLLBACK TO UPDT_RULE_LINES;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
248: ,p_count => x_msg_count
249: ,p_data => x_msg_data);
250:
254: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
255: ,p_count => x_msg_count
256: ,p_data => x_msg_data);
257:
258: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
259:
260:
261:
262: END UPDT_RULE_LINES;