23:
24:
25: SAVEPOINT GET_SYSTEM_ACCT_OPT1;
26:
27: x_return_status := FND_API.G_RET_STS_SUCCESS;
28:
29: -- customer pre-processing
30:
31:
42: p_set_of_books_id => l_set_of_books_id,
43: x_saov_rec => x_saov_rec);
44:
45:
46: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47:
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
44:
45:
46: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47:
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
51:
52: RAISE FND_API.G_EXC_ERROR;
46: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47:
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
51:
52: RAISE FND_API.G_EXC_ERROR;
53:
54: END IF;
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49:
50: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
51:
52: RAISE FND_API.G_EXC_ERROR;
53:
54: END IF;
55:
56:
58:
59:
60: EXCEPTION
61:
62: WHEN FND_API.G_EXC_ERROR THEN
63: ROLLBACK TO GET_SYSTEM_ACCT_OPT1;
64: x_return_status := FND_API.G_RET_STS_ERROR;
65:
66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
60: EXCEPTION
61:
62: WHEN FND_API.G_EXC_ERROR THEN
63: ROLLBACK TO GET_SYSTEM_ACCT_OPT1;
64: x_return_status := FND_API.G_RET_STS_ERROR;
65:
66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
66: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
67: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
71: ROLLBACK TO GET_SYSTEM_ACCT_OPT1;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
74: ,p_count => x_msg_count
68: ,p_data => x_msg_data);
69:
70: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
71: ROLLBACK TO GET_SYSTEM_ACCT_OPT1;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76:
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_ACCT_OPT_PUB','GET_SYSTEM_ACCT_OPT');
81: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
82: ,p_count => x_msg_count
83: ,p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85:
86:
87:
88: END GET_SYSTEM_ACCT_OPT;
111: BEGIN
112:
113:
114: SAVEPOINT UPDT_SYSTEM_ACCT_OPT1;
115: x_return_status := FND_API.G_RET_STS_SUCCESS;
116:
117: -- customer pre-processing
118:
119:
129: p_saov_rec => l_saov_rec,
130: x_saov_rec => x_saov_rec);
131:
132:
133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
131:
132:
133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
138:
139: RAISE FND_API.G_EXC_ERROR;
133: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
134:
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
138:
139: RAISE FND_API.G_EXC_ERROR;
140:
141: END IF;
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136:
137: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
138:
139: RAISE FND_API.G_EXC_ERROR;
140:
141: END IF;
142:
143:
145:
146:
147: EXCEPTION
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO UPDT_SYSTEM_ACCT_OPT1;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
147: EXCEPTION
148:
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO UPDT_SYSTEM_ACCT_OPT1;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
153: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO UPDT_SYSTEM_ACCT_OPT1;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
161: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO UPDT_SYSTEM_ACCT_OPT1;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
161: ,p_count => x_msg_count
162: ,p_data => x_msg_data);
163:
167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_ACCT_OPT_PUB','UPDT_SYSTEM_ACCT_OPT');
168: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
169: ,p_count => x_msg_count
170: ,p_data => x_msg_data);
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173:
174:
175: END UPDT_SYSTEM_ACCT_OPT;