APPS.OKL_ACCT_SOURCES_PVT dependencies on FND_API

Line 18: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

14: l_asev_rec asev_rec_type;
15: l_data VARCHAR2(100);
16: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources';
17: l_count NUMBER ;
18: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
19: BEGIN
20: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
21: SAVEPOINT insert_acct_sources;
22: l_asev_rec := p_asev_rec;

Line 20: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

16: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources';
17: l_count NUMBER ;
18: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
19: BEGIN
20: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
21: SAVEPOINT insert_acct_sources;
22: l_asev_rec := p_asev_rec;
23:
24: Okl_Ase_Pvt.insert_row(

Line 34: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

30: ,p_asev_rec => l_asev_rec
31: ,x_asev_rec => x_asev_rec
32: );
33:
34: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;

Line 35: RAISE Fnd_Api.G_EXC_ERROR;

31: ,x_asev_rec => x_asev_rec
32: );
33:
34: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:

Line 36: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

32: );
33:
34: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: /* re-assign local record structure using output record from pvt api */

Line 37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

33:
34: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40: /* re-assign local record structure using output record from pvt api */
41: l_asev_rec := x_asev_rec;

Line 45: WHEN Fnd_Api.G_EXC_ERROR THEN

41: l_asev_rec := x_asev_rec;
42:
43:
44: EXCEPTION
45: WHEN Fnd_Api.G_EXC_ERROR THEN
46: ROLLBACK TO insert_acct_sources;
47: x_return_status := Fnd_Api.G_RET_STS_ERROR;
48:
49: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 47: x_return_status := Fnd_Api.G_RET_STS_ERROR;

43:
44: EXCEPTION
45: WHEN Fnd_Api.G_EXC_ERROR THEN
46: ROLLBACK TO insert_acct_sources;
47: x_return_status := Fnd_Api.G_RET_STS_ERROR;
48:
49: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
50: ,p_count => x_msg_count
51: ,p_data => x_msg_data);

Line 53: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

49: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
50: ,p_count => x_msg_count
51: ,p_data => x_msg_data);
52:
53: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
54: ROLLBACK TO insert_acct_sources;
55: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
56: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
57: ,p_count => x_msg_count

Line 55: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

51: ,p_data => x_msg_data);
52:
53: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
54: ROLLBACK TO insert_acct_sources;
55: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
56: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:

Line 67: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

63: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66: -- notify caller of an UNEXPECTED error
67: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
68: END insert_acct_sources;
69:
70:
71: PROCEDURE insert_acct_sources(

Line 84: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

80: l_asev_tbl asev_tbl_type;
81: l_data VARCHAR2(100);
82: l_count NUMBER ;
83: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources';
84: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
85: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
86: i NUMBER;
87:
88: BEGIN

Line 85: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

81: l_data VARCHAR2(100);
82: l_count NUMBER ;
83: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources';
84: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
85: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
86: i NUMBER;
87:
88: BEGIN
89: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 89: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

85: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
86: i NUMBER;
87:
88: BEGIN
89: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
90: SAVEPOINT insert_acct_sources;
91: l_asev_tbl := p_asev_tbl;
92:
93: IF (p_asev_tbl.COUNT > 0) THEN

Line 112: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

108: ,x_asev_rec => x_asev_tbl(i)
109: );
110:
111: -- store the highest degree of error
112: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
113: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
114: l_overall_status := x_return_status;
115: END IF;
116: END IF;

Line 113: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

109: );
110:
111: -- store the highest degree of error
112: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
113: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
114: l_overall_status := x_return_status;
115: END IF;
116: END IF;
117: END IF;

Line 133: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

129: END IF;
130:
131: l_return_status := x_return_status;
132:
133: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
134: RAISE Fnd_Api.G_EXC_ERROR;
135: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
136: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
137: END IF;

Line 134: RAISE Fnd_Api.G_EXC_ERROR;

130:
131: l_return_status := x_return_status;
132:
133: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
134: RAISE Fnd_Api.G_EXC_ERROR;
135: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
136: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:

Line 135: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

131: l_return_status := x_return_status;
132:
133: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
134: RAISE Fnd_Api.G_EXC_ERROR;
135: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
136: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:
139: /* re-assign local asele structure using output asele from pvt api */

Line 136: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

132:
133: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
134: RAISE Fnd_Api.G_EXC_ERROR;
135: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
136: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:
139: /* re-assign local asele structure using output asele from pvt api */
140: l_asev_tbl := x_asev_tbl;

Line 143: WHEN Fnd_Api.G_EXC_ERROR THEN

139: /* re-assign local asele structure using output asele from pvt api */
140: l_asev_tbl := x_asev_tbl;
141:
142: EXCEPTION
143: WHEN Fnd_Api.G_EXC_ERROR THEN
144: ROLLBACK TO insert_acct_sources;
145: x_return_status := Fnd_Api.G_RET_STS_ERROR;
146:
147: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 145: x_return_status := Fnd_Api.G_RET_STS_ERROR;

141:
142: EXCEPTION
143: WHEN Fnd_Api.G_EXC_ERROR THEN
144: ROLLBACK TO insert_acct_sources;
145: x_return_status := Fnd_Api.G_RET_STS_ERROR;
146:
147: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);

Line 151: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

147: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_acct_sources;
153: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
154: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
155: ,p_count => x_msg_count

Line 153: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

149: ,p_data => x_msg_data);
150:
151: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_acct_sources;
153: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
154: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:

Line 165: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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: -- notify caller of an UNEXPECTED error
165: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
166: END insert_acct_sources;
167:
168:
169: --Added by gboomina on 14-Oct-2005 for Accruals Performance Improvement

Line 185: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

181: l_asev_tbl asev_tbl_type;
182: l_data VARCHAR2(100);
183: l_count NUMBER ;
184: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources_bulk';
185: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
186: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
187: i NUMBER;
188:
189: BEGIN

Line 186: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

182: l_data VARCHAR2(100);
183: l_count NUMBER ;
184: l_api_name CONSTANT VARCHAR2(30) := 'insert_acct_sources_bulk';
185: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
186: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
187: i NUMBER;
188:
189: BEGIN
190: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 190: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

186: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
187: i NUMBER;
188:
189: BEGIN
190: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
191: SAVEPOINT insert_acct_sources;
192: l_asev_tbl := p_asev_tbl;
193:
194: IF (p_asev_tbl.COUNT > 0) THEN

Line 208: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

204: ,p_asev_tbl => p_asev_tbl
205: ,x_asev_tbl => x_asev_tbl
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: ,x_asev_tbl => x_asev_tbl
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: END IF;

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: END IF;
215:

Line 217: WHEN Fnd_Api.G_EXC_ERROR THEN

213:
214: END IF;
215:
216: EXCEPTION
217: WHEN Fnd_Api.G_EXC_ERROR THEN
218: ROLLBACK TO insert_acct_sources;
219: x_return_status := Fnd_Api.G_RET_STS_ERROR;
220:
221: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 219: x_return_status := Fnd_Api.G_RET_STS_ERROR;

215:
216: EXCEPTION
217: WHEN Fnd_Api.G_EXC_ERROR THEN
218: ROLLBACK TO insert_acct_sources;
219: x_return_status := Fnd_Api.G_RET_STS_ERROR;
220:
221: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
222: ,p_count => x_msg_count
223: ,p_data => x_msg_data);

Line 225: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

221: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
222: ,p_count => x_msg_count
223: ,p_data => x_msg_data);
224:
225: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO insert_acct_sources;
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
228: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
229: ,p_count => x_msg_count

Line 227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

223: ,p_data => x_msg_data);
224:
225: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
226: ROLLBACK TO insert_acct_sources;
227: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
228: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
229: ,p_count => x_msg_count
230: ,p_data => x_msg_data);
231:

Line 239: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

235: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
236: ,p_count => x_msg_count
237: ,p_data => x_msg_data);
238: -- notify caller of an UNEXPECTED error
239: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
240: END insert_acct_sources_bulk;
241: --Bug 4662173 - End of Changes
242:
243: PROCEDURE lock_acct_sources(

Line 253: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

249: ,p_asev_rec IN asev_rec_type
250: ) IS
251:
252: l_asev_rec asev_rec_type;
253: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
254:
255: BEGIN
256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
257: SAVEPOINT lock_acct_sources;

Line 256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

252: l_asev_rec asev_rec_type;
253: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
254:
255: BEGIN
256: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
257: SAVEPOINT lock_acct_sources;
258: l_asev_rec := p_asev_rec;
259:
260: Okl_Ase_Pvt.lock_row(

Line 269: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

265: ,x_msg_data => x_msg_data
266: ,p_asev_rec => l_asev_rec
267: );
268:
269: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
270: RAISE Fnd_Api.G_EXC_ERROR;
271: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
273: END IF;

Line 270: RAISE Fnd_Api.G_EXC_ERROR;

266: ,p_asev_rec => l_asev_rec
267: );
268:
269: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
270: RAISE Fnd_Api.G_EXC_ERROR;
271: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:

Line 271: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

267: );
268:
269: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
270: RAISE Fnd_Api.G_EXC_ERROR;
271: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: EXCEPTION

Line 272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

268:
269: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
270: RAISE Fnd_Api.G_EXC_ERROR;
271: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: EXCEPTION
276: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 276: WHEN Fnd_Api.G_EXC_ERROR THEN

272: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: EXCEPTION
276: WHEN Fnd_Api.G_EXC_ERROR THEN
277: ROLLBACK TO lock_acct_sources;
278: x_return_status := Fnd_Api.G_RET_STS_ERROR;
279:
280: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 278: x_return_status := Fnd_Api.G_RET_STS_ERROR;

274:
275: EXCEPTION
276: WHEN Fnd_Api.G_EXC_ERROR THEN
277: ROLLBACK TO lock_acct_sources;
278: x_return_status := Fnd_Api.G_RET_STS_ERROR;
279:
280: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
281: ,p_count => x_msg_count
282: ,p_data => x_msg_data);

Line 284: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

280: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
281: ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283:
284: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO lock_acct_sources;
286: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
287: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
288: ,p_count => x_msg_count

Line 286: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

282: ,p_data => x_msg_data);
283:
284: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
285: ROLLBACK TO lock_acct_sources;
286: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
287: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
288: ,p_count => x_msg_count
289: ,p_data => x_msg_data);
290:

Line 298: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

294: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
295: ,p_count => x_msg_count
296: ,p_data => x_msg_data);
297: -- notify caller of an UNEXPECTED error
298: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
299: END lock_acct_sources;
300:
301: PROCEDURE lock_acct_sources(
302: p_api_version IN NUMBER

Line 310: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

306: ,x_msg_data OUT NOCOPY VARCHAR2
307: ,p_asev_tbl IN asev_tbl_type
308: ) IS
309:
310: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
311: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
312: i NUMBER;
313:
314: BEGIN

Line 311: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

307: ,p_asev_tbl IN asev_tbl_type
308: ) IS
309:
310: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
311: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
312: i NUMBER;
313:
314: BEGIN
315: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 315: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

311: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
312: i NUMBER;
313:
314: BEGIN
315: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
316: SAVEPOINT lock_acct_sources;
317:
318: IF (p_asev_tbl.COUNT > 0) THEN
319: i := p_asev_tbl.FIRST;

Line 332: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

328: ,p_asev_rec => p_asev_tbl(i)
329: );
330:
331: -- store the highest degree of error
332: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
333: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
334: l_overall_status := x_return_status;
335: END IF;
336: END IF;

Line 333: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

329: );
330:
331: -- store the highest degree of error
332: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
333: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
334: l_overall_status := x_return_status;
335: END IF;
336: END IF;
337: EXIT WHEN (i = p_asev_tbl.LAST);

Line 349: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

345: END IF;
346:
347: l_return_status := x_return_status;
348:
349: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
353: END IF;

Line 350: RAISE Fnd_Api.G_EXC_ERROR;

346:
347: l_return_status := x_return_status;
348:
349: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:

Line 351: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

347: l_return_status := x_return_status;
348:
349: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: EXCEPTION

Line 352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

348:
349: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
350: RAISE Fnd_Api.G_EXC_ERROR;
351: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: EXCEPTION
356: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 356: WHEN Fnd_Api.G_EXC_ERROR THEN

352: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: EXCEPTION
356: WHEN Fnd_Api.G_EXC_ERROR THEN
357: ROLLBACK TO lock_acct_sources;
358: x_return_status := Fnd_Api.G_RET_STS_ERROR;
359:
360: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 358: x_return_status := Fnd_Api.G_RET_STS_ERROR;

354:
355: EXCEPTION
356: WHEN Fnd_Api.G_EXC_ERROR THEN
357: ROLLBACK TO lock_acct_sources;
358: x_return_status := Fnd_Api.G_RET_STS_ERROR;
359:
360: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
361: ,p_count => x_msg_count
362: ,p_data => x_msg_data);

Line 364: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

360: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
361: ,p_count => x_msg_count
362: ,p_data => x_msg_data);
363:
364: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO lock_acct_sources;
366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
367: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
368: ,p_count => x_msg_count

Line 366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

362: ,p_data => x_msg_data);
363:
364: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
365: ROLLBACK TO lock_acct_sources;
366: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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:

Line 378: 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: -- notify caller of an UNEXPECTED error
378: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
379: END lock_acct_sources;
380:
381: PROCEDURE update_acct_sources(
382: p_api_version IN NUMBER

Line 394: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

390: l_asev_rec asev_rec_type;
391: l_data VARCHAR2(100);
392: l_count NUMBER ;
393: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_sources';
394: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
395: BEGIN
396: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
397: SAVEPOINT update_acct_sources;
398: l_asev_rec := p_asev_rec;

Line 396: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

392: l_count NUMBER ;
393: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_sources';
394: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
395: BEGIN
396: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
397: SAVEPOINT update_acct_sources;
398: l_asev_rec := p_asev_rec;
399:
400: /* consulting pre-processing user hook call */

Line 414: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

410: ,p_asev_rec => l_asev_rec
411: ,x_asev_rec => x_asev_rec
412: );
413:
414: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
415: RAISE Fnd_Api.G_EXC_ERROR;
416: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: END IF;

Line 415: RAISE Fnd_Api.G_EXC_ERROR;

411: ,x_asev_rec => x_asev_rec
412: );
413:
414: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
415: RAISE Fnd_Api.G_EXC_ERROR;
416: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:

Line 416: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

412: );
413:
414: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
415: RAISE Fnd_Api.G_EXC_ERROR;
416: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: /* re-assign local record structure using output record from pvt api */

Line 417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

413:
414: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
415: RAISE Fnd_Api.G_EXC_ERROR;
416: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
417: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
418: END IF;
419:
420: /* re-assign local record structure using output record from pvt api */
421: l_asev_rec := x_asev_rec;

Line 428: WHEN Fnd_Api.G_EXC_ERROR THEN

424:
425: /* consulting post-processing user hook call */
426:
427: EXCEPTION
428: WHEN Fnd_Api.G_EXC_ERROR THEN
429: ROLLBACK TO update_acct_sources;
430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
431:
432: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 430: x_return_status := Fnd_Api.G_RET_STS_ERROR;

426:
427: EXCEPTION
428: WHEN Fnd_Api.G_EXC_ERROR THEN
429: ROLLBACK TO update_acct_sources;
430: x_return_status := Fnd_Api.G_RET_STS_ERROR;
431:
432: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
433: ,p_count => x_msg_count
434: ,p_data => x_msg_data);

Line 436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

432: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
433: ,p_count => x_msg_count
434: ,p_data => x_msg_data);
435:
436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO update_acct_sources;
438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
439: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
440: ,p_count => x_msg_count

Line 438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

434: ,p_data => x_msg_data);
435:
436: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
437: ROLLBACK TO update_acct_sources;
438: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
439: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
440: ,p_count => x_msg_count
441: ,p_data => x_msg_data);
442:

Line 450: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

446: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
447: ,p_count => x_msg_count
448: ,p_data => x_msg_data);
449: -- notify caller of an UNEXPECTED error
450: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
451: END update_acct_sources;
452:
453:
454: PROCEDURE update_acct_sources(

Line 467: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

463: l_asev_tbl asev_tbl_type;
464: l_data VARCHAR2(100);
465: l_count NUMBER;
466: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_sources';
467: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
468: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
469: i NUMBER;
470:
471: BEGIN

Line 468: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

464: l_data VARCHAR2(100);
465: l_count NUMBER;
466: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_sources';
467: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
468: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
469: i NUMBER;
470:
471: BEGIN
472: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 472: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

468: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
469: i NUMBER;
470:
471: BEGIN
472: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
473: SAVEPOINT update_acct_sources;
474: l_asev_tbl := p_asev_tbl;
475:
476: /* consulting pre-processing user hook call */

Line 495: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

491: ,x_asev_rec => x_asev_tbl(i)
492: );
493:
494: -- store the highest degree of error
495: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
496: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
497: l_overall_status := x_return_status;
498: END IF;
499: END IF;

Line 496: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

492: );
493:
494: -- store the highest degree of error
495: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
496: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
497: l_overall_status := x_return_status;
498: END IF;
499: END IF;
500: EXIT WHEN (i = p_asev_tbl.LAST);

Line 512: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

508: END IF;
509:
510: l_return_status := x_return_status;
511:
512: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
513: RAISE Fnd_Api.G_EXC_ERROR;
514: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
515: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
516: END IF;

Line 513: RAISE Fnd_Api.G_EXC_ERROR;

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

Line 514: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

510: l_return_status := x_return_status;
511:
512: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
513: RAISE Fnd_Api.G_EXC_ERROR;
514: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
515: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: /* re-assign local asele structure using output asele from pvt api */

Line 515: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

511:
512: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
513: RAISE Fnd_Api.G_EXC_ERROR;
514: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
515: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
516: END IF;
517:
518: /* re-assign local asele structure using output asele from pvt api */
519: l_asev_tbl := x_asev_tbl;

Line 526: WHEN Fnd_Api.G_EXC_ERROR THEN

522:
523: /* consulting post-processing user hook call */
524:
525: EXCEPTION
526: WHEN Fnd_Api.G_EXC_ERROR THEN
527: ROLLBACK TO update_acct_sources;
528: x_return_status := Fnd_Api.G_RET_STS_ERROR;
529:
530: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 528: x_return_status := Fnd_Api.G_RET_STS_ERROR;

524:
525: EXCEPTION
526: WHEN Fnd_Api.G_EXC_ERROR THEN
527: ROLLBACK TO update_acct_sources;
528: x_return_status := Fnd_Api.G_RET_STS_ERROR;
529:
530: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);

Line 534: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

530: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
531: ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533:
534: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
535: ROLLBACK TO update_acct_sources;
536: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
537: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
538: ,p_count => x_msg_count

Line 536: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

532: ,p_data => x_msg_data);
533:
534: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
535: ROLLBACK TO update_acct_sources;
536: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
537: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
538: ,p_count => x_msg_count
539: ,p_data => x_msg_data);
540:

Line 548: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

544: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
545: ,p_count => x_msg_count
546: ,p_data => x_msg_data);
547: -- notify caller of an UNEXPECTED error
548: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
549: END update_acct_sources;
550:
551: PROCEDURE delete_acct_sources(
552: p_api_version IN NUMBER

Line 563: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

559: l_asev_rec asev_rec_type;
560: l_data VARCHAR2(100);
561: l_count NUMBER ;
562: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_sources';
563: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
564:
565:
566: -- Added by Santonyr to fix the bug 3089327 on 07th Aug, 2003
567:

Line 582: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

578: FROM OKL_TRX_CONTRACTS
579: WHERE ID = v_tcn_id;
580:
581: BEGIN
582: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
583: SAVEPOINT delete_acct_sources;
584: l_asev_rec := p_asev_rec;
585:
586: /* consulting pre-processing user hook call */

Line 619: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

615: ,x_msg_data => x_msg_data
616: ,p_asev_rec => l_asev_rec
617: );
618:
619: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
620: RAISE Fnd_Api.G_EXC_ERROR;
621: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;

Line 620: RAISE Fnd_Api.G_EXC_ERROR;

616: ,p_asev_rec => l_asev_rec
617: );
618:
619: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
620: RAISE Fnd_Api.G_EXC_ERROR;
621: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:

Line 621: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

617: );
618:
619: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
620: RAISE Fnd_Api.G_EXC_ERROR;
621: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: /* vertical user post-processing hook call */

Line 622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

618:
619: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
620: RAISE Fnd_Api.G_EXC_ERROR;
621: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
622: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624:
625: /* vertical user post-processing hook call */
626:

Line 630: WHEN Fnd_Api.G_EXC_ERROR THEN

626:
627: /* consulting post-processing user hook call */
628:
629: EXCEPTION
630: WHEN Fnd_Api.G_EXC_ERROR THEN
631: ROLLBACK TO delete_acct_sources;
632: x_return_status := Fnd_Api.G_RET_STS_ERROR;
633:
634: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 632: x_return_status := Fnd_Api.G_RET_STS_ERROR;

628:
629: EXCEPTION
630: WHEN Fnd_Api.G_EXC_ERROR THEN
631: ROLLBACK TO delete_acct_sources;
632: x_return_status := Fnd_Api.G_RET_STS_ERROR;
633:
634: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
635: ,p_count => x_msg_count
636: ,p_data => x_msg_data);

Line 638: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

634: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
635: ,p_count => x_msg_count
636: ,p_data => x_msg_data);
637:
638: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
639: ROLLBACK TO delete_acct_sources;
640: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
641: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
642: ,p_count => x_msg_count

Line 640: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

636: ,p_data => x_msg_data);
637:
638: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
639: ROLLBACK TO delete_acct_sources;
640: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
641: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
642: ,p_count => x_msg_count
643: ,p_data => x_msg_data);
644:

Line 652: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

648: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
649: ,p_count => x_msg_count
650: ,p_data => x_msg_data);
651: -- notify caller of an UNEXPECTED error
652: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
653: END delete_acct_sources;
654:
655:
656: PROCEDURE delete_acct_sources(

Line 668: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

664: l_asev_tbl asev_tbl_type;
665: l_data VARCHAR2(100);
666: l_count NUMBER ;
667: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_sources';
668: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
669: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
670: i NUMBER;
671:
672: BEGIN

Line 669: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

665: l_data VARCHAR2(100);
666: l_count NUMBER ;
667: l_api_name CONSTANT VARCHAR2(30) := 'delete_acct_sources';
668: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
669: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
670: i NUMBER;
671:
672: BEGIN
673: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 673: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

669: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
670: i NUMBER;
671:
672: BEGIN
673: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
674: SAVEPOINT delete_acct_sources;
675: l_asev_tbl := p_asev_tbl;
676:
677: /* consulting pre-processing user hook call */

Line 695: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

691: ,p_asev_rec => p_asev_tbl(i)
692: );
693:
694: -- store the highest degree of error
695: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
696: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
697: l_overall_status := x_return_status;
698: END IF;
699: END IF;

Line 696: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

692: );
693:
694: -- store the highest degree of error
695: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
696: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
697: l_overall_status := x_return_status;
698: END IF;
699: END IF;
700: EXIT WHEN (i = p_asev_tbl.LAST);

Line 712: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

708: END IF;
709:
710: l_return_status := x_return_status;
711:
712: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
715: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
716: END IF;

Line 713: RAISE Fnd_Api.G_EXC_ERROR;

709:
710: l_return_status := x_return_status;
711:
712: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
715: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:

Line 714: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

710: l_return_status := x_return_status;
711:
712: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
715: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: /* vertical user post-processing hook call */

Line 715: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

711:
712: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
713: RAISE Fnd_Api.G_EXC_ERROR;
714: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
715: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
716: END IF;
717:
718: /* vertical user post-processing hook call */
719:

Line 723: WHEN Fnd_Api.G_EXC_ERROR THEN

719:
720: /* consulting post-processing user hook call */
721:
722: EXCEPTION
723: WHEN Fnd_Api.G_EXC_ERROR THEN
724: ROLLBACK TO delete_acct_sources;
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726:
727: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 725: x_return_status := Fnd_Api.G_RET_STS_ERROR;

721:
722: EXCEPTION
723: WHEN Fnd_Api.G_EXC_ERROR THEN
724: ROLLBACK TO delete_acct_sources;
725: x_return_status := Fnd_Api.G_RET_STS_ERROR;
726:
727: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
728: ,p_count => x_msg_count
729: ,p_data => x_msg_data);

Line 731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

727: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
728: ,p_count => x_msg_count
729: ,p_data => x_msg_data);
730:
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO delete_acct_sources;
733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
734: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
735: ,p_count => x_msg_count

Line 733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

729: ,p_data => x_msg_data);
730:
731: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
732: ROLLBACK TO delete_acct_sources;
733: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
734: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
735: ,p_count => x_msg_count
736: ,p_data => x_msg_data);
737:

Line 745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

741: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
742: ,p_count => x_msg_count
743: ,p_data => x_msg_data);
744: -- notify caller of an UNEXPECTED error
745: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
746: END delete_acct_sources;
747:
748: PROCEDURE validate_acct_sources(
749: p_api_version IN NUMBER

Line 760: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

756: l_asev_rec asev_rec_type;
757: l_data VARCHAR2(100);
758: l_count NUMBER;
759: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_sources';
760: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
761: BEGIN
762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
763: SAVEPOINT validate_acct_sources;
764: l_asev_rec := p_asev_rec;

Line 762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

758: l_count NUMBER;
759: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_sources';
760: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
761: BEGIN
762: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
763: SAVEPOINT validate_acct_sources;
764: l_asev_rec := p_asev_rec;
765:
766: /* consulting pre-processing user hook call */

Line 779: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

775: ,x_msg_data => x_msg_data
776: ,p_asev_rec => l_asev_rec
777: );
778:
779: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
780: RAISE Fnd_Api.G_EXC_ERROR;
781: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
782: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
783: END IF;

Line 780: RAISE Fnd_Api.G_EXC_ERROR;

776: ,p_asev_rec => l_asev_rec
777: );
778:
779: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
780: RAISE Fnd_Api.G_EXC_ERROR;
781: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
782: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:

Line 781: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

777: );
778:
779: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
780: RAISE Fnd_Api.G_EXC_ERROR;
781: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
782: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: /* vertical user post-processing hook call */

Line 782: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

778:
779: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
780: RAISE Fnd_Api.G_EXC_ERROR;
781: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
782: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
783: END IF;
784:
785: /* vertical user post-processing hook call */
786:

Line 790: WHEN Fnd_Api.G_EXC_ERROR THEN

786:
787: /* consulting post-processing user hook call */
788:
789: EXCEPTION
790: WHEN Fnd_Api.G_EXC_ERROR THEN
791: ROLLBACK TO validate_acct_sources;
792: x_return_status := Fnd_Api.G_RET_STS_ERROR;
793:
794: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 792: x_return_status := Fnd_Api.G_RET_STS_ERROR;

788:
789: EXCEPTION
790: WHEN Fnd_Api.G_EXC_ERROR THEN
791: ROLLBACK TO validate_acct_sources;
792: x_return_status := Fnd_Api.G_RET_STS_ERROR;
793:
794: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
795: ,p_count => x_msg_count
796: ,p_data => x_msg_data);

Line 798: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

794: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
795: ,p_count => x_msg_count
796: ,p_data => x_msg_data);
797:
798: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO validate_acct_sources;
800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
801: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
802: ,p_count => x_msg_count

Line 800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

796: ,p_data => x_msg_data);
797:
798: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
799: ROLLBACK TO validate_acct_sources;
800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
801: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
802: ,p_count => x_msg_count
803: ,p_data => x_msg_data);
804:

Line 812: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

808: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
809: ,p_count => x_msg_count
810: ,p_data => x_msg_data);
811: -- notify caller of an UNEXPECTED error
812: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
813: END validate_acct_sources;
814:
815:
816: PROCEDURE validate_acct_sources(

Line 828: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

824: l_asev_tbl asev_tbl_type;
825: l_data VARCHAR2(100);
826: l_count NUMBER;
827: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_sources';
828: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
829: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
830: i NUMBER;
831:
832: BEGIN

Line 829: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

825: l_data VARCHAR2(100);
826: l_count NUMBER;
827: l_api_name CONSTANT VARCHAR2(30) := 'validate_acct_sources';
828: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
829: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
830: i NUMBER;
831:
832: BEGIN
833: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 833: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

829: l_overall_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
830: i NUMBER;
831:
832: BEGIN
833: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
834: SAVEPOINT validate_acct_sources;
835: l_asev_tbl := p_asev_tbl;
836:
837: /* consulting pre-processing user hook call */

Line 855: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN

851: ,p_asev_rec => p_asev_tbl(i)
852: );
853:
854: -- store the highest degree of error
855: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
856: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
857: l_overall_status := x_return_status;
858: END IF;
859: END IF;

Line 856: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

852: );
853:
854: -- store the highest degree of error
855: IF x_return_status <> Fnd_Api.G_RET_STS_SUCCESS THEN
856: IF l_overall_status <> Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
857: l_overall_status := x_return_status;
858: END IF;
859: END IF;
860: EXIT WHEN (i = p_asev_tbl.LAST);

Line 872: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

868: END IF;
869:
870: l_return_status := x_return_status;
871:
872: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
873: RAISE Fnd_Api.G_EXC_ERROR;
874: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
876: END IF;

Line 873: RAISE Fnd_Api.G_EXC_ERROR;

869:
870: l_return_status := x_return_status;
871:
872: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
873: RAISE Fnd_Api.G_EXC_ERROR;
874: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:

Line 874: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

870: l_return_status := x_return_status;
871:
872: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
873: RAISE Fnd_Api.G_EXC_ERROR;
874: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:
878: /* vertical user post-processing hook call */

Line 875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

871:
872: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
873: RAISE Fnd_Api.G_EXC_ERROR;
874: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
875: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
876: END IF;
877:
878: /* vertical user post-processing hook call */
879:

Line 884: WHEN Fnd_Api.G_EXC_ERROR THEN

880: /* consulting post-processing user hook call */
881:
882:
883: EXCEPTION
884: WHEN Fnd_Api.G_EXC_ERROR THEN
885: ROLLBACK TO validate_acct_sources;
886: x_return_status := Fnd_Api.G_RET_STS_ERROR;
887:
888: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 886: x_return_status := Fnd_Api.G_RET_STS_ERROR;

882:
883: EXCEPTION
884: WHEN Fnd_Api.G_EXC_ERROR THEN
885: ROLLBACK TO validate_acct_sources;
886: x_return_status := Fnd_Api.G_RET_STS_ERROR;
887:
888: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);

Line 892: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

888: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
889: ,p_count => x_msg_count
890: ,p_data => x_msg_data);
891:
892: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
893: ROLLBACK TO validate_acct_sources;
894: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
895: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
896: ,p_count => x_msg_count

Line 894: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

890: ,p_data => x_msg_data);
891:
892: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
893: ROLLBACK TO validate_acct_sources;
894: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
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);
898:

Line 906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

902: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
903: ,p_count => x_msg_count
904: ,p_data => x_msg_data);
905: -- notify caller of an UNEXPECTED error
906: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
907: END validate_acct_sources;
908:
909: PROCEDURE update_acct_src_custom_status(
910: p_api_version IN NUMBER,

Line 922: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;

918: l_asev_rec asev_rec_type;
919: l_data VARCHAR2(100);
920: l_count NUMBER ;
921: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_src_custom_status';
922: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
923: BEGIN
924: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
925: SAVEPOINT update_acct_src_custom_status;
926: l_asev_rec:= p_asev_rec;

Line 924: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

920: l_count NUMBER ;
921: l_api_name CONSTANT VARCHAR2(30) := 'update_acct_src_custom_status';
922: l_return_status VARCHAR2(1) := Fnd_Api.G_RET_STS_SUCCESS;
923: BEGIN
924: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
925: SAVEPOINT update_acct_src_custom_status;
926: l_asev_rec:= p_asev_rec;
927:
928: /* consulting pre-processing user hook call */

Line 942: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN

938: ,p_asev_rec => l_asev_rec
939: ,x_asev_rec => x_asev_rec
940: );
941:
942: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
943: RAISE Fnd_Api.G_EXC_ERROR;
944: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
945: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
946: END IF;

Line 943: RAISE Fnd_Api.G_EXC_ERROR;

939: ,x_asev_rec => x_asev_rec
940: );
941:
942: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
943: RAISE Fnd_Api.G_EXC_ERROR;
944: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
945: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947:

Line 944: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

940: );
941:
942: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
943: RAISE Fnd_Api.G_EXC_ERROR;
944: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
945: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947:
948: /* re-assign local record structure using output record from pvt api */

Line 945: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

941:
942: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
943: RAISE Fnd_Api.G_EXC_ERROR;
944: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
945: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
946: END IF;
947:
948: /* re-assign local record structure using output record from pvt api */
949: l_asev_rec := x_asev_rec;

Line 956: WHEN Fnd_Api.G_EXC_ERROR THEN

952:
953: /* consulting post-processing user hook call */
954:
955: EXCEPTION
956: WHEN Fnd_Api.G_EXC_ERROR THEN
957: ROLLBACK TO update_acct_src_custom_status;
958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
959:
960: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE

Line 958: x_return_status := Fnd_Api.G_RET_STS_ERROR;

954:
955: EXCEPTION
956: WHEN Fnd_Api.G_EXC_ERROR THEN
957: ROLLBACK TO update_acct_src_custom_status;
958: x_return_status := Fnd_Api.G_RET_STS_ERROR;
959:
960: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
961: ,p_count => x_msg_count
962: ,p_data => x_msg_data);

Line 964: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

960: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
961: ,p_count => x_msg_count
962: ,p_data => x_msg_data);
963:
964: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
965: ROLLBACK TO update_acct_src_custom_status;
966: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
967: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
968: ,p_count => x_msg_count

Line 966: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

962: ,p_data => x_msg_data);
963:
964: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
965: ROLLBACK TO update_acct_src_custom_status;
966: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
967: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
968: ,p_count => x_msg_count
969: ,p_data => x_msg_data);
970:

Line 978: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

974: Fnd_Msg_Pub.Count_and_get(p_encoded => Okc_Api.G_FALSE
975: ,p_count => x_msg_count
976: ,p_data => x_msg_data);
977: -- notify caller of an UNEXPECTED error
978: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
979:
980: END update_acct_src_custom_status;
981:
982: