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

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

20: l_fodv_rec fodv_rec_type;
21: l_data VARCHAR2(100);
22: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmla_oprnds';
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_fmla_oprnds;
28: l_fodv_rec := p_fodv_rec;

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmla_oprnds';
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_fmla_oprnds;
28: l_fodv_rec := p_fodv_rec;
29:
30:

Line 42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

38: ,p_fodv_rec => l_fodv_rec
39: ,x_fodv_rec => x_fodv_rec
40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;

Line 43: RAISE FND_API.G_EXC_ERROR;

39: ,x_fodv_rec => x_fodv_rec
40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:

Line 44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: /* re-assign local record structure using output record from pvt api */

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48: /* re-assign local record structure using output record from pvt api */
49: l_fodv_rec := x_fodv_rec;

Line 55: WHEN FND_API.G_EXC_ERROR THEN

51:
52:
53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_ERROR THEN
56: ROLLBACK TO insert_fmla_oprnds;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 57: x_return_status := FND_API.G_RET_STS_ERROR;

53:
54: EXCEPTION
55: WHEN FND_API.G_EXC_ERROR THEN
56: ROLLBACK TO insert_fmla_oprnds;
57: x_return_status := FND_API.G_RET_STS_ERROR;
58:
59: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);

Line 63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

59: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
60: ,p_count => x_msg_count
61: ,p_data => x_msg_data);
62:
63: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
64: ROLLBACK TO insert_fmla_oprnds;
65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
67: ,p_count => x_msg_count

Line 65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
74: ,p_count => x_msg_count
75: ,p_data => x_msg_data);
76: -- notify caller of an UNEXPECTED error
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: END insert_fmla_oprnds;
79:
80:
81: PROCEDURE insert_fmla_oprnds(

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

90: l_fodv_tbl fodv_tbl_type;
91: l_data VARCHAR2(100);
92: l_count NUMBER ;
93: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmla_oprnds';
94: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: i NUMBER;
97:
98: BEGIN

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

91: l_data VARCHAR2(100);
92: l_count NUMBER ;
93: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmla_oprnds';
94: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: i NUMBER;
97:
98: BEGIN
99: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 99: x_return_status := FND_API.G_RET_STS_SUCCESS;

95: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: i NUMBER;
97:
98: BEGIN
99: x_return_status := FND_API.G_RET_STS_SUCCESS;
100: SAVEPOINT insert_fmla_oprnds;
101: l_fodv_tbl := p_fodv_tbl;
102:
103:

Line 120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

116: ,x_fodv_rec => x_fodv_tbl(i)
117: );
118:
119: -- store the highest degree of error
120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
121: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
122: l_overall_status := x_return_status;
123: END IF;
124: END IF;

Line 121: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

117: );
118:
119: -- store the highest degree of error
120: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
121: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
122: l_overall_status := x_return_status;
123: END IF;
124: END IF;
125: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

133: END IF;
134:
135: l_return_status := x_return_status;
136:
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;

Line 138: RAISE FND_API.G_EXC_ERROR;

134:
135: l_return_status := x_return_status;
136:
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:

Line 139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

135: l_return_status := x_return_status;
136:
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: /* re-assign local table structure using output table from pvt api */

Line 140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

136:
137: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
138: RAISE FND_API.G_EXC_ERROR;
139: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
140: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
141: END IF;
142:
143: /* re-assign local table structure using output table from pvt api */
144: l_fodv_tbl := x_fodv_tbl;

Line 149: WHEN FND_API.G_EXC_ERROR THEN

145:
146:
147:
148: EXCEPTION
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO insert_fmla_oprnds;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147:
148: EXCEPTION
149: WHEN FND_API.G_EXC_ERROR THEN
150: ROLLBACK TO insert_fmla_oprnds;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152:
153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);

Line 157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

153: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
154: ,p_count => x_msg_count
155: ,p_data => x_msg_data);
156:
157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
158: ROLLBACK TO insert_fmla_oprnds;
159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
160: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
161: ,p_count => x_msg_count

Line 159: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
168: ,p_count => x_msg_count
169: ,p_data => x_msg_data);
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: END insert_fmla_oprnds;
173:
174: PROCEDURE lock_fmla_oprnds(
175: p_api_version IN NUMBER

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

180: ,p_fodv_rec IN fodv_rec_type
181: ) IS
182:
183: l_fodv_rec fodv_rec_type;
184: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185:
186: BEGIN
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: SAVEPOINT lock_fmla_oprnds;

Line 187: x_return_status := FND_API.G_RET_STS_SUCCESS;

183: l_fodv_rec fodv_rec_type;
184: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
185:
186: BEGIN
187: x_return_status := FND_API.G_RET_STS_SUCCESS;
188: SAVEPOINT lock_fmla_oprnds;
189: l_fodv_rec := p_fodv_rec;
190:
191: okl_fod_pvt.lock_row(

Line 200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

196: ,x_msg_data => x_msg_data
197: ,p_fodv_rec => l_fodv_rec
198: );
199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;

Line 201: RAISE FND_API.G_EXC_ERROR;

197: ,p_fodv_rec => l_fodv_rec
198: );
199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:

Line 202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

198: );
199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: EXCEPTION

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN

Line 207: WHEN FND_API.G_EXC_ERROR THEN

203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO lock_fmla_oprnds;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 209: x_return_status := FND_API.G_RET_STS_ERROR;

205:
206: EXCEPTION
207: WHEN FND_API.G_EXC_ERROR THEN
208: ROLLBACK TO lock_fmla_oprnds;
209: x_return_status := FND_API.G_RET_STS_ERROR;
210:
211: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
212: ,p_count => x_msg_count
213: ,p_data => x_msg_data);

Line 215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

211: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
212: ,p_count => x_msg_count
213: ,p_data => x_msg_data);
214:
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: ROLLBACK TO lock_fmla_oprnds;
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
219: ,p_count => x_msg_count

Line 217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
226: ,p_count => x_msg_count
227: ,p_data => x_msg_data);
228: -- notify caller of an UNEXPECTED error
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230: END lock_fmla_oprnds;
231:
232: PROCEDURE lock_fmla_oprnds(
233: p_api_version IN NUMBER

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

237: ,x_msg_data OUT NOCOPY VARCHAR2
238: ,p_fodv_tbl IN fodv_tbl_type
239: ) IS
240:
241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
243: i NUMBER;
244:
245: BEGIN

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

238: ,p_fodv_tbl IN fodv_tbl_type
239: ) IS
240:
241: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
243: i NUMBER;
244:
245: BEGIN
246: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
243: i NUMBER;
244:
245: BEGIN
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247: SAVEPOINT lock_fmla_oprnds;
248:
249: IF (p_fodv_tbl.COUNT > 0) THEN
250: i := p_fodv_tbl.FIRST;

Line 263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

259: ,p_fodv_rec => p_fodv_tbl(i)
260: );
261:
262: -- store the highest degree of error
263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
265: l_overall_status := x_return_status;
266: END IF;
267: END IF;

Line 264: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

260: );
261:
262: -- store the highest degree of error
263: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
264: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
265: l_overall_status := x_return_status;
266: END IF;
267: END IF;
268: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

276: END IF;
277:
278: l_return_status := x_return_status;
279:
280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;

Line 281: RAISE FND_API.G_EXC_ERROR;

277:
278: l_return_status := x_return_status;
279:
280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:

Line 282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

278: l_return_status := x_return_status;
279:
280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: EXCEPTION

Line 283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

279:
280: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
281: RAISE FND_API.G_EXC_ERROR;
282: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
284: END IF;
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO lock_fmla_oprnds;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 289: x_return_status := FND_API.G_RET_STS_ERROR;

285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: ROLLBACK TO lock_fmla_oprnds;
289: x_return_status := FND_API.G_RET_STS_ERROR;
290:
291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);

Line 295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

291: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
292: ,p_count => x_msg_count
293: ,p_data => x_msg_data);
294:
295: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
296: ROLLBACK TO lock_fmla_oprnds;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
299: ,p_count => x_msg_count

Line 297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

305: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
306: ,p_count => x_msg_count
307: ,p_data => x_msg_data);
308: -- notify caller of an UNEXPECTED error
309: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
310: END lock_fmla_oprnds;
311:
312: PROCEDURE update_fmla_oprnds(
313: p_api_version IN NUMBER

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

321: l_fodv_rec fodv_rec_type;
322: l_data VARCHAR2(100);
323: l_count NUMBER ;
324: l_api_name CONSTANT VARCHAR2(30) := 'update_fmla_oprnds';
325: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
326: BEGIN
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328: SAVEPOINT update_fmla_oprnds;
329: l_fodv_rec := p_fodv_rec;

Line 327: x_return_status := FND_API.G_RET_STS_SUCCESS;

323: l_count NUMBER ;
324: l_api_name CONSTANT VARCHAR2(30) := 'update_fmla_oprnds';
325: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
326: BEGIN
327: x_return_status := FND_API.G_RET_STS_SUCCESS;
328: SAVEPOINT update_fmla_oprnds;
329: l_fodv_rec := p_fodv_rec;
330:
331:

Line 343: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

339: ,p_fodv_rec => l_fodv_rec
340: ,x_fodv_rec => x_fodv_rec
341: );
342:
343: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;

Line 344: RAISE FND_API.G_EXC_ERROR;

340: ,x_fodv_rec => x_fodv_rec
341: );
342:
343: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:

Line 345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

341: );
342:
343: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: /* re-assign local record structure using output record from pvt api */

Line 346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

342:
343: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
344: RAISE FND_API.G_EXC_ERROR;
345: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
346: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
347: END IF;
348:
349: /* re-assign local record structure using output record from pvt api */
350: l_fodv_rec := x_fodv_rec;

Line 355: WHEN FND_API.G_EXC_ERROR THEN

351:
352:
353:
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_fmla_oprnds;
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:
359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 357: x_return_status := FND_API.G_RET_STS_ERROR;

353:
354: EXCEPTION
355: WHEN FND_API.G_EXC_ERROR THEN
356: ROLLBACK TO update_fmla_oprnds;
357: x_return_status := FND_API.G_RET_STS_ERROR;
358:
359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
360: ,p_count => x_msg_count
361: ,p_data => x_msg_data);

Line 363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

359: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
360: ,p_count => x_msg_count
361: ,p_data => x_msg_data);
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: ROLLBACK TO update_fmla_oprnds;
365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
366: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
367: ,p_count => x_msg_count

Line 365: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

373: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
374: ,p_count => x_msg_count
375: ,p_data => x_msg_data);
376: -- notify caller of an UNEXPECTED error
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378: END update_fmla_oprnds;
379:
380:
381: PROCEDURE update_fmla_oprnds(

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

390: l_fodv_tbl fodv_tbl_type;
391: l_data VARCHAR2(100);
392: l_count NUMBER;
393: l_api_name CONSTANT VARCHAR2(30) := 'update_fmla_oprnds';
394: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
395: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
396: i NUMBER;
397:
398: BEGIN

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

391: l_data VARCHAR2(100);
392: l_count NUMBER;
393: l_api_name CONSTANT VARCHAR2(30) := 'update_fmla_oprnds';
394: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
395: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
396: i NUMBER;
397:
398: BEGIN
399: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 399: x_return_status := FND_API.G_RET_STS_SUCCESS;

395: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
396: i NUMBER;
397:
398: BEGIN
399: x_return_status := FND_API.G_RET_STS_SUCCESS;
400: SAVEPOINT update_fmla_oprnds;
401: l_fodv_tbl := p_fodv_tbl;
402:
403:

Line 420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

416: ,x_fodv_rec => x_fodv_tbl(i)
417: );
418:
419: -- store the highest degree of error
420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
421: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
422: l_overall_status := x_return_status;
423: END IF;
424: END IF;

Line 421: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

417: );
418:
419: -- store the highest degree of error
420: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
421: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
422: l_overall_status := x_return_status;
423: END IF;
424: END IF;
425: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

433: END IF;
434:
435: l_return_status := x_return_status;
436:
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE FND_API.G_EXC_ERROR;
439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;

Line 438: RAISE FND_API.G_EXC_ERROR;

434:
435: l_return_status := x_return_status;
436:
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE FND_API.G_EXC_ERROR;
439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:

Line 439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

435: l_return_status := x_return_status;
436:
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE FND_API.G_EXC_ERROR;
439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443: /* re-assign local table structure using output table from pvt api */

Line 440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

436:
437: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
438: RAISE FND_API.G_EXC_ERROR;
439: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
440: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
441: END IF;
442:
443: /* re-assign local table structure using output table from pvt api */
444: l_fodv_tbl := x_fodv_tbl;

Line 449: WHEN FND_API.G_EXC_ERROR THEN

445:
446:
447:
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO update_fmla_oprnds;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452:
453: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447:
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO update_fmla_oprnds;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452:
453: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
454: ,p_count => x_msg_count
455: ,p_data => x_msg_data);

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
454: ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: ROLLBACK TO update_fmla_oprnds;
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
461: ,p_count => x_msg_count

Line 459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

467: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
468: ,p_count => x_msg_count
469: ,p_data => x_msg_data);
470: -- notify caller of an UNEXPECTED error
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: END update_fmla_oprnds;
473:
474: PROCEDURE delete_fmla_oprnds(
475: p_api_version IN NUMBER

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

482: l_fodv_rec fodv_rec_type;
483: l_data VARCHAR2(100);
484: l_count NUMBER ;
485: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmla_oprnds';
486: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
487: BEGIN
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489: SAVEPOINT delete_fmla_oprnds;
490: l_fodv_rec := p_fodv_rec;

Line 488: x_return_status := FND_API.G_RET_STS_SUCCESS;

484: l_count NUMBER ;
485: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmla_oprnds';
486: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
487: BEGIN
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489: SAVEPOINT delete_fmla_oprnds;
490: l_fodv_rec := p_fodv_rec;
491:
492:

Line 503: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

499: ,x_msg_data => x_msg_data
500: ,p_fodv_rec => l_fodv_rec
501: );
502:
503: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;

Line 504: RAISE FND_API.G_EXC_ERROR;

500: ,p_fodv_rec => l_fodv_rec
501: );
502:
503: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:

Line 505: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

501: );
502:
503: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509:

Line 506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

502:
503: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
504: RAISE FND_API.G_EXC_ERROR;
505: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
506: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
507: END IF;
508:
509:
510:

Line 512: WHEN FND_API.G_EXC_ERROR THEN

508:
509:
510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO delete_fmla_oprnds;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 514: x_return_status := FND_API.G_RET_STS_ERROR;

510:
511: EXCEPTION
512: WHEN FND_API.G_EXC_ERROR THEN
513: ROLLBACK TO delete_fmla_oprnds;
514: x_return_status := FND_API.G_RET_STS_ERROR;
515:
516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data);

Line 520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

516: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
517: ,p_count => x_msg_count
518: ,p_data => x_msg_data);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: ROLLBACK TO delete_fmla_oprnds;
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
524: ,p_count => x_msg_count

Line 522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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: -- notify caller of an UNEXPECTED error
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: END delete_fmla_oprnds;
536:
537:
538: PROCEDURE delete_fmla_oprnds(

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

546: l_fodv_tbl fodv_tbl_type;
547: l_data VARCHAR2(100);
548: l_count NUMBER ;
549: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmla_oprnds';
550: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
552: i NUMBER;
553:
554: BEGIN

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

547: l_data VARCHAR2(100);
548: l_count NUMBER ;
549: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmla_oprnds';
550: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
552: i NUMBER;
553:
554: BEGIN
555: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 555: x_return_status := FND_API.G_RET_STS_SUCCESS;

551: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
552: i NUMBER;
553:
554: BEGIN
555: x_return_status := FND_API.G_RET_STS_SUCCESS;
556: SAVEPOINT delete_fmla_oprnds;
557: l_fodv_tbl := p_fodv_tbl;
558:
559:

Line 575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

571: ,p_fodv_rec => p_fodv_tbl(i)
572: );
573:
574: -- store the highest degree of error
575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
577: l_overall_status := x_return_status;
578: END IF;
579: END IF;

Line 576: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

572: );
573:
574: -- store the highest degree of error
575: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
576: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
577: l_overall_status := x_return_status;
578: END IF;
579: END IF;
580: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

588: END IF;
589:
590: l_return_status := x_return_status;
591:
592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;

Line 593: RAISE FND_API.G_EXC_ERROR;

589:
590: l_return_status := x_return_status;
591:
592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597:

Line 594: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

590: l_return_status := x_return_status;
591:
592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597:
598:

Line 595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

591:
592: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
593: RAISE FND_API.G_EXC_ERROR;
594: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
595: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
596: END IF;
597:
598:
599:

Line 601: WHEN FND_API.G_EXC_ERROR THEN

597:
598:
599:
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO delete_fmla_oprnds;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 603: x_return_status := FND_API.G_RET_STS_ERROR;

599:
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: ROLLBACK TO delete_fmla_oprnds;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604:
605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
606: ,p_count => x_msg_count
607: ,p_data => x_msg_data);

Line 609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

605: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
606: ,p_count => x_msg_count
607: ,p_data => x_msg_data);
608:
609: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
610: ROLLBACK TO delete_fmla_oprnds;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
613: ,p_count => x_msg_count

Line 611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

619: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
620: ,p_count => x_msg_count
621: ,p_data => x_msg_data);
622: -- notify caller of an UNEXPECTED error
623: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
624: END delete_fmla_oprnds;
625:
626: PROCEDURE validate_fmla_oprnds(
627: p_api_version IN NUMBER

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

634: l_fodv_rec fodv_rec_type;
635: l_data VARCHAR2(100);
636: l_count NUMBER;
637: l_api_name CONSTANT VARCHAR2(30) := 'validate_fmla_oprnds';
638: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
639: BEGIN
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641: SAVEPOINT validate_fmla_oprnds;
642: l_fodv_rec := p_fodv_rec;

Line 640: x_return_status := FND_API.G_RET_STS_SUCCESS;

636: l_count NUMBER;
637: l_api_name CONSTANT VARCHAR2(30) := 'validate_fmla_oprnds';
638: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
639: BEGIN
640: x_return_status := FND_API.G_RET_STS_SUCCESS;
641: SAVEPOINT validate_fmla_oprnds;
642: l_fodv_rec := p_fodv_rec;
643:
644:

Line 655: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

651: ,x_msg_data => x_msg_data
652: ,p_fodv_rec => l_fodv_rec
653: );
654:
655: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
656: RAISE FND_API.G_EXC_ERROR;
657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;

Line 656: RAISE FND_API.G_EXC_ERROR;

652: ,p_fodv_rec => l_fodv_rec
653: );
654:
655: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
656: RAISE FND_API.G_EXC_ERROR;
657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:

Line 657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

653: );
654:
655: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
656: RAISE FND_API.G_EXC_ERROR;
657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661:

Line 658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

654:
655: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
656: RAISE FND_API.G_EXC_ERROR;
657: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
658: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
659: END IF;
660:
661:
662:

Line 664: WHEN FND_API.G_EXC_ERROR THEN

660:
661:
662:
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO validate_fmla_oprnds;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 666: x_return_status := FND_API.G_RET_STS_ERROR;

662:
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: ROLLBACK TO validate_fmla_oprnds;
666: x_return_status := FND_API.G_RET_STS_ERROR;
667:
668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);

Line 672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

668: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data);
671:
672: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
673: ROLLBACK TO validate_fmla_oprnds;
674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
675: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
676: ,p_count => x_msg_count

Line 674: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

682: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
683: ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: -- notify caller of an UNEXPECTED error
686: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
687: END validate_fmla_oprnds;
688:
689:
690: PROCEDURE validate_fmla_oprnds(

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

698: l_fodv_tbl fodv_tbl_type;
699: l_data VARCHAR2(100);
700: l_count NUMBER;
701: l_api_name CONSTANT VARCHAR2(30) := 'validate_fmla_oprnds';
702: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
703: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
704: i NUMBER;
705:
706: BEGIN

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

699: l_data VARCHAR2(100);
700: l_count NUMBER;
701: l_api_name CONSTANT VARCHAR2(30) := 'validate_fmla_oprnds';
702: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
703: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
704: i NUMBER;
705:
706: BEGIN
707: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 707: x_return_status := FND_API.G_RET_STS_SUCCESS;

703: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
704: i NUMBER;
705:
706: BEGIN
707: x_return_status := FND_API.G_RET_STS_SUCCESS;
708: SAVEPOINT validate_fmla_oprnds;
709: l_fodv_tbl := p_fodv_tbl;
710:
711:

Line 727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

723: ,p_fodv_rec => p_fodv_tbl(i)
724: );
725:
726: -- store the highest degree of error
727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
729: l_overall_status := x_return_status;
730: END IF;
731: END IF;

Line 728: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

724: );
725:
726: -- store the highest degree of error
727: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
728: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
729: l_overall_status := x_return_status;
730: END IF;
731: END IF;
732: EXIT WHEN (i = p_fodv_tbl.LAST);

Line 744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

740: END IF;
741:
742: l_return_status := x_return_status;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
745: RAISE FND_API.G_EXC_ERROR;
746: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;

Line 745: RAISE FND_API.G_EXC_ERROR;

741:
742: l_return_status := x_return_status;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
745: RAISE FND_API.G_EXC_ERROR;
746: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:

Line 746: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

742: l_return_status := x_return_status;
743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
745: RAISE FND_API.G_EXC_ERROR;
746: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750:

Line 747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

743:
744: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
745: RAISE FND_API.G_EXC_ERROR;
746: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
747: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
748: END IF;
749:
750:
751:

Line 754: WHEN FND_API.G_EXC_ERROR THEN

750:
751:
752:
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO validate_fmla_oprnds;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 756: x_return_status := FND_API.G_RET_STS_ERROR;

752:
753: EXCEPTION
754: WHEN FND_API.G_EXC_ERROR THEN
755: ROLLBACK TO validate_fmla_oprnds;
756: x_return_status := FND_API.G_RET_STS_ERROR;
757:
758: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
759: ,p_count => x_msg_count
760: ,p_data => x_msg_data);

Line 762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

758: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
759: ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO validate_fmla_oprnds;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
766: ,p_count => x_msg_count

Line 764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

760: ,p_data => x_msg_data);
761:
762: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
763: ROLLBACK TO validate_fmla_oprnds;
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
766: ,p_count => x_msg_count
767: ,p_data => x_msg_data);
768:

Line 776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

772: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
773: ,p_count => x_msg_count
774: ,p_data => x_msg_data);
775: -- notify caller of an UNEXPECTED error
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777: END validate_fmla_oprnds;
778:
779:
780: END OKL_FMLA_OPRNDS_PUB;