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_SYS_ACCT_OPTS_PUB dependencies on FND_API

Line 24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

20: l_saov_rec saov_rec_type;
21: l_data VARCHAR2(100);
22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sys_acct_opts';
23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: SAVEPOINT insert_sys_acct_opts;
28: l_saov_rec := p_saov_rec;

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sys_acct_opts';
23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: SAVEPOINT insert_sys_acct_opts;
28: l_saov_rec := p_saov_rec;
29:
30: -- Bug 6014587: Start

Line 50: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

46: ,p_saov_rec => l_saov_rec
47: ,x_saov_rec => x_saov_rec
48: );
49:
50: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;

Line 51: RAISE FND_API.G_EXC_ERROR;

47: ,x_saov_rec => x_saov_rec
48: );
49:
50: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:

Line 52: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

48: );
49:
50: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: /* re-assign local record structure using output record from pvt api */

Line 53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

49:
50: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
51: RAISE FND_API.G_EXC_ERROR;
52: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
53: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
54: END IF;
55:
56: /* re-assign local record structure using output record from pvt api */
57: l_saov_rec := x_saov_rec;

Line 63: WHEN FND_API.G_EXC_ERROR THEN

59:
60:
61:
62: EXCEPTION
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO insert_sys_acct_opts;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66:
67: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 65: x_return_status := FND_API.G_RET_STS_ERROR;

61:
62: EXCEPTION
63: WHEN FND_API.G_EXC_ERROR THEN
64: ROLLBACK TO insert_sys_acct_opts;
65: x_return_status := FND_API.G_RET_STS_ERROR;
66:
67: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
68: ,p_count => x_msg_count
69: ,p_data => x_msg_data);

Line 71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

67: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
68: ,p_count => x_msg_count
69: ,p_data => x_msg_data);
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: ROLLBACK TO insert_sys_acct_opts;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
75: ,p_count => x_msg_count

Line 73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

69: ,p_data => x_msg_data);
70:
71: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
72: ROLLBACK TO insert_sys_acct_opts;
73: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
74: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
75: ,p_count => x_msg_count
76: ,p_data => x_msg_data);
77:

Line 85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

81: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
82: ,p_count => x_msg_count
83: ,p_data => x_msg_data);
84: -- notify caller of an UNEXPECTED error
85: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
86: END insert_sys_acct_opts;
87:
88:
89: PROCEDURE insert_sys_acct_opts(

Line 102: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

98: l_saov_tbl saov_tbl_type;
99: l_data VARCHAR2(100);
100: l_count NUMBER ;
101: l_api_name CONSTANT VARCHAR2(30) := 'insert_sys_acct_opts';
102: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
103: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
104: i NUMBER;
105:
106: BEGIN

Line 103: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

99: l_data VARCHAR2(100);
100: l_count NUMBER ;
101: l_api_name CONSTANT VARCHAR2(30) := 'insert_sys_acct_opts';
102: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
103: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
104: i NUMBER;
105:
106: BEGIN
107: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 107: x_return_status := FND_API.G_RET_STS_SUCCESS;

103: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
104: i NUMBER;
105:
106: BEGIN
107: x_return_status := FND_API.G_RET_STS_SUCCESS;
108: SAVEPOINT insert_sys_acct_opts;
109: l_saov_tbl := p_saov_tbl;
110:
111:

Line 128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

124: ,x_saov_rec => x_saov_tbl(i)
125: );
126:
127: -- store the highest degree of error
128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
129: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
130: l_overall_status := x_return_status;
131: END IF;
132: END IF;

Line 129: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

125: );
126:
127: -- store the highest degree of error
128: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
129: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
130: l_overall_status := x_return_status;
131: END IF;
132: END IF;
133: EXIT WHEN (i = p_saov_tbl.LAST);

Line 145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

141: END IF;
142:
143: l_return_status := x_return_status;
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;

Line 146: RAISE FND_API.G_EXC_ERROR;

142:
143: l_return_status := x_return_status;
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:

Line 147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

143: l_return_status := x_return_status;
144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:
151: /* re-assign local table structure using output table from pvt api */

Line 148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

144:
145: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
146: RAISE FND_API.G_EXC_ERROR;
147: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
149: END IF;
150:
151: /* re-assign local table structure using output table from pvt api */
152: l_saov_tbl := x_saov_tbl;

Line 157: WHEN FND_API.G_EXC_ERROR THEN

153:
154:
155:
156: EXCEPTION
157: WHEN FND_API.G_EXC_ERROR THEN
158: ROLLBACK TO insert_sys_acct_opts;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160:
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

155:
156: EXCEPTION
157: WHEN FND_API.G_EXC_ERROR THEN
158: ROLLBACK TO insert_sys_acct_opts;
159: x_return_status := FND_API.G_RET_STS_ERROR;
160:
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);

Line 165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO insert_sys_acct_opts;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
169: ,p_count => x_msg_count

Line 167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

163: ,p_data => x_msg_data);
164:
165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
166: ROLLBACK TO insert_sys_acct_opts;
167: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
169: ,p_count => x_msg_count
170: ,p_data => x_msg_data);
171:

Line 179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

175: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
176: ,p_count => x_msg_count
177: ,p_data => x_msg_data);
178: -- notify caller of an UNEXPECTED error
179: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
180: END insert_sys_acct_opts;
181:
182: PROCEDURE lock_sys_acct_opts(
183: p_api_version IN NUMBER

Line 192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

188: ,p_saov_rec IN saov_rec_type
189: ) IS
190:
191: l_saov_rec saov_rec_type;
192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
193:
194: BEGIN
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196: SAVEPOINT lock_sys_acct_opts;

Line 195: x_return_status := FND_API.G_RET_STS_SUCCESS;

191: l_saov_rec saov_rec_type;
192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
193:
194: BEGIN
195: x_return_status := FND_API.G_RET_STS_SUCCESS;
196: SAVEPOINT lock_sys_acct_opts;
197: l_saov_rec := p_saov_rec;
198:
199: okl_sao_pvt.lock_row(

Line 208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

204: ,x_msg_data => x_msg_data
205: ,p_saov_rec => l_saov_rec
206: );
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;

Line 209: RAISE FND_API.G_EXC_ERROR;

205: ,p_saov_rec => l_saov_rec
206: );
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:

Line 210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

206: );
207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: EXCEPTION

Line 211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

207:
208: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: EXCEPTION
215: WHEN FND_API.G_EXC_ERROR THEN

Line 215: WHEN FND_API.G_EXC_ERROR THEN

211: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
212: END IF;
213:
214: EXCEPTION
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO lock_sys_acct_opts;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218:
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 217: x_return_status := FND_API.G_RET_STS_ERROR;

213:
214: EXCEPTION
215: WHEN FND_API.G_EXC_ERROR THEN
216: ROLLBACK TO lock_sys_acct_opts;
217: x_return_status := FND_API.G_RET_STS_ERROR;
218:
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO lock_sys_acct_opts;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
227: ,p_count => x_msg_count

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

221: ,p_data => x_msg_data);
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: ROLLBACK TO lock_sys_acct_opts;
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
227: ,p_count => x_msg_count
228: ,p_data => x_msg_data);
229:

Line 237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

233: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
234: ,p_count => x_msg_count
235: ,p_data => x_msg_data);
236: -- notify caller of an UNEXPECTED error
237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
238: END lock_sys_acct_opts;
239:
240: PROCEDURE lock_sys_acct_opts(
241: p_api_version IN NUMBER

Line 249: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

245: ,x_msg_data OUT NOCOPY VARCHAR2
246: ,p_saov_tbl IN saov_tbl_type
247: ) IS
248:
249: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
250: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
251: i NUMBER;
252:
253: BEGIN

Line 250: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

246: ,p_saov_tbl IN saov_tbl_type
247: ) IS
248:
249: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
250: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
251: i NUMBER;
252:
253: BEGIN
254: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 254: x_return_status := FND_API.G_RET_STS_SUCCESS;

250: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
251: i NUMBER;
252:
253: BEGIN
254: x_return_status := FND_API.G_RET_STS_SUCCESS;
255: SAVEPOINT lock_sys_acct_opts;
256:
257: IF (p_saov_tbl.COUNT > 0) THEN
258: i := p_saov_tbl.FIRST;

Line 271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

267: ,p_saov_rec => p_saov_tbl(i)
268: );
269:
270: -- store the highest degree of error
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
273: l_overall_status := x_return_status;
274: END IF;
275: END IF;

Line 272: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

268: );
269:
270: -- store the highest degree of error
271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
272: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
273: l_overall_status := x_return_status;
274: END IF;
275: END IF;
276: EXIT WHEN (i = p_saov_tbl.LAST);

Line 288: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

284: END IF;
285:
286: l_return_status := x_return_status;
287:
288: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
289: RAISE FND_API.G_EXC_ERROR;
290: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;

Line 289: RAISE FND_API.G_EXC_ERROR;

285:
286: l_return_status := x_return_status;
287:
288: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
289: RAISE FND_API.G_EXC_ERROR;
290: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:

Line 290: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

286: l_return_status := x_return_status;
287:
288: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
289: RAISE FND_API.G_EXC_ERROR;
290: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: EXCEPTION

Line 291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

287:
288: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
289: RAISE FND_API.G_EXC_ERROR;
290: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN

Line 295: WHEN FND_API.G_EXC_ERROR THEN

291: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
292: END IF;
293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO lock_sys_acct_opts;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298:
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 297: x_return_status := FND_API.G_RET_STS_ERROR;

293:
294: EXCEPTION
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO lock_sys_acct_opts;
297: x_return_status := FND_API.G_RET_STS_ERROR;
298:
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);

Line 303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO lock_sys_acct_opts;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
307: ,p_count => x_msg_count

Line 305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

301: ,p_data => x_msg_data);
302:
303: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
304: ROLLBACK TO lock_sys_acct_opts;
305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
306: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
307: ,p_count => x_msg_count
308: ,p_data => x_msg_data);
309:

Line 317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

313: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
314: ,p_count => x_msg_count
315: ,p_data => x_msg_data);
316: -- notify caller of an UNEXPECTED error
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
318: END lock_sys_acct_opts;
319:
320: PROCEDURE update_sys_acct_opts(
321: p_api_version IN NUMBER

Line 333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

329: l_saov_rec saov_rec_type;
330: l_data VARCHAR2(100);
331: l_count NUMBER ;
332: l_api_name CONSTANT VARCHAR2(30) := 'update_sys_acct_opts';
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: BEGIN
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: SAVEPOINT update_sys_acct_opts;
337: l_saov_rec := p_saov_rec;

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: l_count NUMBER ;
332: l_api_name CONSTANT VARCHAR2(30) := 'update_sys_acct_opts';
333: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
334: BEGIN
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336: SAVEPOINT update_sys_acct_opts;
337: l_saov_rec := p_saov_rec;
338:
339:

Line 351: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

347: ,p_saov_rec => l_saov_rec
348: ,x_saov_rec => x_saov_rec
349: );
350:
351: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
352: RAISE FND_API.G_EXC_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;

Line 352: RAISE FND_API.G_EXC_ERROR;

348: ,x_saov_rec => x_saov_rec
349: );
350:
351: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
352: RAISE FND_API.G_EXC_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:

Line 353: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

349: );
350:
351: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
352: RAISE FND_API.G_EXC_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: /* re-assign local record structure using output record from pvt api */

Line 354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

350:
351: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
352: RAISE FND_API.G_EXC_ERROR;
353: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
354: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
355: END IF;
356:
357: /* re-assign local record structure using output record from pvt api */
358: l_saov_rec := x_saov_rec;

Line 363: WHEN FND_API.G_EXC_ERROR THEN

359:
360:
361:
362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO update_sys_acct_opts;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366:
367: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 365: x_return_status := FND_API.G_RET_STS_ERROR;

361:
362: EXCEPTION
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO update_sys_acct_opts;
365: x_return_status := FND_API.G_RET_STS_ERROR;
366:
367: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);

Line 371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

367: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
368: ,p_count => x_msg_count
369: ,p_data => x_msg_data);
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO update_sys_acct_opts;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
375: ,p_count => x_msg_count

Line 373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

369: ,p_data => x_msg_data);
370:
371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
372: ROLLBACK TO update_sys_acct_opts;
373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
374: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
375: ,p_count => x_msg_count
376: ,p_data => x_msg_data);
377:

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
382: ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: -- notify caller of an UNEXPECTED error
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: END update_sys_acct_opts;
387:
388:
389: PROCEDURE update_sys_acct_opts(

Line 402: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

398: l_saov_tbl saov_tbl_type;
399: l_data VARCHAR2(100);
400: l_count NUMBER;
401: l_api_name CONSTANT VARCHAR2(30) := 'update_sys_acct_opts';
402: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
403: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
404: i NUMBER;
405:
406: BEGIN

Line 403: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

399: l_data VARCHAR2(100);
400: l_count NUMBER;
401: l_api_name CONSTANT VARCHAR2(30) := 'update_sys_acct_opts';
402: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
403: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
404: i NUMBER;
405:
406: BEGIN
407: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 407: x_return_status := FND_API.G_RET_STS_SUCCESS;

403: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
404: i NUMBER;
405:
406: BEGIN
407: x_return_status := FND_API.G_RET_STS_SUCCESS;
408: SAVEPOINT update_sys_acct_opts;
409: l_saov_tbl := p_saov_tbl;
410:
411:

Line 428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

424: ,x_saov_rec => x_saov_tbl(i)
425: );
426:
427: -- store the highest degree of error
428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
429: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
430: l_overall_status := x_return_status;
431: END IF;
432: END IF;

Line 429: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

425: );
426:
427: -- store the highest degree of error
428: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
429: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
430: l_overall_status := x_return_status;
431: END IF;
432: END IF;
433: EXIT WHEN (i = p_saov_tbl.LAST);

Line 445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

441: END IF;
442:
443: l_return_status := x_return_status;
444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;

Line 446: RAISE FND_API.G_EXC_ERROR;

442:
443: l_return_status := x_return_status;
444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:

Line 447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

443: l_return_status := x_return_status;
444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: /* re-assign local table structure using output table from pvt api */

Line 448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

444:
445: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
446: RAISE FND_API.G_EXC_ERROR;
447: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
448: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
449: END IF;
450:
451: /* re-assign local table structure using output table from pvt api */
452: l_saov_tbl := x_saov_tbl;

Line 457: WHEN FND_API.G_EXC_ERROR THEN

453:
454:
455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO update_sys_acct_opts;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460:
461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 459: x_return_status := FND_API.G_RET_STS_ERROR;

455:
456: EXCEPTION
457: WHEN FND_API.G_EXC_ERROR THEN
458: ROLLBACK TO update_sys_acct_opts;
459: x_return_status := FND_API.G_RET_STS_ERROR;
460:
461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data);

Line 465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

461: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
462: ,p_count => x_msg_count
463: ,p_data => x_msg_data);
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_sys_acct_opts;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
469: ,p_count => x_msg_count

Line 467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

463: ,p_data => x_msg_data);
464:
465: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
466: ROLLBACK TO update_sys_acct_opts;
467: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
468: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
469: ,p_count => x_msg_count
470: ,p_data => x_msg_data);
471:

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
476: ,p_count => x_msg_count
477: ,p_data => x_msg_data);
478: -- notify caller of an UNEXPECTED error
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: END update_sys_acct_opts;
481:
482: PROCEDURE delete_sys_acct_opts(
483: p_api_version IN NUMBER

Line 494: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

490: l_saov_rec saov_rec_type;
491: l_data VARCHAR2(100);
492: l_count NUMBER ;
493: l_api_name CONSTANT VARCHAR2(30) := 'delete_sys_acct_opts';
494: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
495: BEGIN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: SAVEPOINT delete_sys_acct_opts;
498: l_saov_rec := p_saov_rec;

Line 496: x_return_status := FND_API.G_RET_STS_SUCCESS;

492: l_count NUMBER ;
493: l_api_name CONSTANT VARCHAR2(30) := 'delete_sys_acct_opts';
494: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
495: BEGIN
496: x_return_status := FND_API.G_RET_STS_SUCCESS;
497: SAVEPOINT delete_sys_acct_opts;
498: l_saov_rec := p_saov_rec;
499:
500:

Line 511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

507: ,x_msg_data => x_msg_data
508: ,p_saov_rec => l_saov_rec
509: );
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;

Line 512: RAISE FND_API.G_EXC_ERROR;

508: ,p_saov_rec => l_saov_rec
509: );
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:

Line 513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

509: );
510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517:

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

510:
511: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
512: RAISE FND_API.G_EXC_ERROR;
513: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
515: END IF;
516:
517:
518:

Line 520: WHEN FND_API.G_EXC_ERROR THEN

516:
517:
518:
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: ROLLBACK TO delete_sys_acct_opts;
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 522: x_return_status := FND_API.G_RET_STS_ERROR;

518:
519: EXCEPTION
520: WHEN FND_API.G_EXC_ERROR THEN
521: ROLLBACK TO delete_sys_acct_opts;
522: x_return_status := FND_API.G_RET_STS_ERROR;
523:
524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
525: ,p_count => x_msg_count
526: ,p_data => x_msg_data);

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

524: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
525: ,p_count => x_msg_count
526: ,p_data => x_msg_data);
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO delete_sys_acct_opts;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
532: ,p_count => x_msg_count

Line 530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

526: ,p_data => x_msg_data);
527:
528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
529: ROLLBACK TO delete_sys_acct_opts;
530: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
531: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
532: ,p_count => x_msg_count
533: ,p_data => x_msg_data);
534:

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
539: ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: -- notify caller of an UNEXPECTED error
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: END delete_sys_acct_opts;
544:
545:
546: PROCEDURE delete_sys_acct_opts(

Line 558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

554: l_saov_tbl saov_tbl_type;
555: l_data VARCHAR2(100);
556: l_count NUMBER ;
557: l_api_name CONSTANT VARCHAR2(30) := 'delete_sys_acct_opts';
558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN

Line 559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

555: l_data VARCHAR2(100);
556: l_count NUMBER ;
557: l_api_name CONSTANT VARCHAR2(30) := 'delete_sys_acct_opts';
558: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN
563: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 563: x_return_status := FND_API.G_RET_STS_SUCCESS;

559: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
560: i NUMBER;
561:
562: BEGIN
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: SAVEPOINT delete_sys_acct_opts;
565: l_saov_tbl := p_saov_tbl;
566:
567:

Line 583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

579: ,p_saov_rec => p_saov_tbl(i)
580: );
581:
582: -- store the highest degree of error
583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
585: l_overall_status := x_return_status;
586: END IF;
587: END IF;

Line 584: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

580: );
581:
582: -- store the highest degree of error
583: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
584: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
585: l_overall_status := x_return_status;
586: END IF;
587: END IF;
588: EXIT WHEN (i = p_saov_tbl.LAST);

Line 600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

596: END IF;
597:
598: l_return_status := x_return_status;
599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: RAISE FND_API.G_EXC_ERROR;
602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;

Line 601: RAISE FND_API.G_EXC_ERROR;

597:
598: l_return_status := x_return_status;
599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: RAISE FND_API.G_EXC_ERROR;
602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:

Line 602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

598: l_return_status := x_return_status;
599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: RAISE FND_API.G_EXC_ERROR;
602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606:

Line 603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

599:
600: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
601: RAISE FND_API.G_EXC_ERROR;
602: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
604: END IF;
605:
606:
607:

Line 609: WHEN FND_API.G_EXC_ERROR THEN

605:
606:
607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: ROLLBACK TO delete_sys_acct_opts;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612:
613: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 611: x_return_status := FND_API.G_RET_STS_ERROR;

607:
608: EXCEPTION
609: WHEN FND_API.G_EXC_ERROR THEN
610: ROLLBACK TO delete_sys_acct_opts;
611: x_return_status := FND_API.G_RET_STS_ERROR;
612:
613: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
614: ,p_count => x_msg_count
615: ,p_data => x_msg_data);

Line 617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

613: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
614: ,p_count => x_msg_count
615: ,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO delete_sys_acct_opts;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
621: ,p_count => x_msg_count

Line 619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

615: ,p_data => x_msg_data);
616:
617: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
618: ROLLBACK TO delete_sys_acct_opts;
619: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
620: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
621: ,p_count => x_msg_count
622: ,p_data => x_msg_data);
623:

Line 631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

627: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
628: ,p_count => x_msg_count
629: ,p_data => x_msg_data);
630: -- notify caller of an UNEXPECTED error
631: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
632: END delete_sys_acct_opts;
633:
634: PROCEDURE validate_sys_acct_opts(
635: p_api_version IN NUMBER

Line 646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

642: l_saov_rec saov_rec_type;
643: l_data VARCHAR2(100);
644: l_count NUMBER;
645: l_api_name CONSTANT VARCHAR2(30) := 'validate_sys_acct_opts';
646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
647: BEGIN
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649: SAVEPOINT validate_sys_acct_opts;
650: l_saov_rec := p_saov_rec;

Line 648: x_return_status := FND_API.G_RET_STS_SUCCESS;

644: l_count NUMBER;
645: l_api_name CONSTANT VARCHAR2(30) := 'validate_sys_acct_opts';
646: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
647: BEGIN
648: x_return_status := FND_API.G_RET_STS_SUCCESS;
649: SAVEPOINT validate_sys_acct_opts;
650: l_saov_rec := p_saov_rec;
651:
652:

Line 663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

659: ,x_msg_data => x_msg_data
660: ,p_saov_rec => l_saov_rec
661: );
662:
663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;

Line 664: RAISE FND_API.G_EXC_ERROR;

660: ,p_saov_rec => l_saov_rec
661: );
662:
663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668:

Line 665: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

661: );
662:
663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668:
669:

Line 666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

662:
663: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
664: RAISE FND_API.G_EXC_ERROR;
665: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
666: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
667: END IF;
668:
669:
670:

Line 672: WHEN FND_API.G_EXC_ERROR THEN

668:
669:
670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO validate_sys_acct_opts;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675:
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 674: x_return_status := FND_API.G_RET_STS_ERROR;

670:
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: ROLLBACK TO validate_sys_acct_opts;
674: x_return_status := FND_API.G_RET_STS_ERROR;
675:
676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);

Line 680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

676: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
677: ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO validate_sys_acct_opts;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
684: ,p_count => x_msg_count

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

678: ,p_data => x_msg_data);
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO validate_sys_acct_opts;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
684: ,p_count => x_msg_count
685: ,p_data => x_msg_data);
686:

Line 694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

690: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
691: ,p_count => x_msg_count
692: ,p_data => x_msg_data);
693: -- notify caller of an UNEXPECTED error
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: END validate_sys_acct_opts;
696:
697:
698: PROCEDURE validate_sys_acct_opts(

Line 710: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

706: l_saov_tbl saov_tbl_type;
707: l_data VARCHAR2(100);
708: l_count NUMBER;
709: l_api_name CONSTANT VARCHAR2(30) := 'validate_sys_acct_opts';
710: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
711: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
712: i NUMBER;
713:
714: BEGIN

Line 711: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

707: l_data VARCHAR2(100);
708: l_count NUMBER;
709: l_api_name CONSTANT VARCHAR2(30) := 'validate_sys_acct_opts';
710: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
711: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
712: i NUMBER;
713:
714: BEGIN
715: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 715: x_return_status := FND_API.G_RET_STS_SUCCESS;

711: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
712: i NUMBER;
713:
714: BEGIN
715: x_return_status := FND_API.G_RET_STS_SUCCESS;
716: SAVEPOINT validate_sys_acct_opts;
717: l_saov_tbl := p_saov_tbl;
718:
719:

Line 735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

731: ,p_saov_rec => p_saov_tbl(i)
732: );
733:
734: -- store the highest degree of error
735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
736: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
737: l_overall_status := x_return_status;
738: END IF;
739: END IF;

Line 736: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

732: );
733:
734: -- store the highest degree of error
735: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
736: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
737: l_overall_status := x_return_status;
738: END IF;
739: END IF;
740: EXIT WHEN (i = p_saov_tbl.LAST);

Line 752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

748: END IF;
749:
750: l_return_status := x_return_status;
751:
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;

Line 753: RAISE FND_API.G_EXC_ERROR;

749:
750: l_return_status := x_return_status;
751:
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:

Line 754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

750: l_return_status := x_return_status;
751:
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758:

Line 755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

751:
752: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
753: RAISE FND_API.G_EXC_ERROR;
754: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
756: END IF;
757:
758:
759:

Line 762: WHEN FND_API.G_EXC_ERROR THEN

758:
759:
760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO validate_sys_acct_opts;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 764: x_return_status := FND_API.G_RET_STS_ERROR;

760:
761: EXCEPTION
762: WHEN FND_API.G_EXC_ERROR THEN
763: ROLLBACK TO validate_sys_acct_opts;
764: x_return_status := FND_API.G_RET_STS_ERROR;
765:
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);

Line 770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: ROLLBACK TO validate_sys_acct_opts;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
774: ,p_count => x_msg_count

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: ,p_data => x_msg_data);
769:
770: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
771: ROLLBACK TO validate_sys_acct_opts;
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
774: ,p_count => x_msg_count
775: ,p_data => x_msg_data);
776:

Line 784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

780: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
781: ,p_count => x_msg_count
782: ,p_data => x_msg_data);
783: -- notify caller of an UNEXPECTED error
784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
785: END validate_sys_acct_opts;
786:
787:
788: END OKL_SYS_ACCT_OPTS_PUB;