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

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

15: x_msg_data OUT NOCOPY VARCHAR2,
16: x_no_data_found OUT NOCOPY BOOLEAN,
17: x_fodv_rec OUT NOCOPY fodv_rec_type) IS
18: l_fodv_rec fodv_rec_type;
19: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: l_no_data_found BOOLEAN;
21: BEGIN
22:
23: l_fodv_rec := p_fodv_rec;

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: l_no_data_found BOOLEAN;
21: BEGIN
22:
23: l_fodv_rec := p_fodv_rec;
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25: x_no_data_found := TRUE;
26:
27: -- Start of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.get_rec
28: IF(L_DEBUG_ENABLED='Y') THEN

Line 48: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

44: END;
45: END IF;
46: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.get_rec
47:
48: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: EXCEPTION

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

45: END IF;
46: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.get_rec
47:
48: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN

Line 54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
55: x_no_data_found := FALSE;
56: FND_MESSAGE.set_name(application => G_APP_NAME,
57: name => G_UNEXPECTED_ERROR);
58: x_msg_data := FND_MESSAGE.get;

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

74: l_fodv_rec fodv_rec_type;
75: l_data VARCHAR2(100);
76: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
77: l_count NUMBER ;
78: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
79: BEGIN
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: SAVEPOINT sp_insert_fmaconstraints;
82:

Line 80: x_return_status := FND_API.G_RET_STS_SUCCESS;

76: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
77: l_count NUMBER ;
78: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
79: BEGIN
80: x_return_status := FND_API.G_RET_STS_SUCCESS;
81: SAVEPOINT sp_insert_fmaconstraints;
82:
83: l_fmav_rec := p_fmav_rec;
84: l_fodv_rec := p_fodv_rec;

Line 114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

110: END;
111: END IF;
112: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;

Line 115: RAISE FND_API.G_EXC_ERROR;

111: END IF;
112: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:

Line 116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

112: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: /* re-assign local record structure using output record from pvt api */

Line 117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

113:
114: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
115: RAISE FND_API.G_EXC_ERROR;
116: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
117: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
118: END IF;
119:
120: /* re-assign local record structure using output record from pvt api */
121: l_fodv_rec := x_fodv_rec;

Line 126: WHEN FND_API.G_EXC_ERROR THEN

122:
123:
124:
125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO sp_insert_fmaconstraints;
128: -- notify caller of an UNEXPECTED error
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: EXCEPTION
126: WHEN FND_API.G_EXC_ERROR THEN
127: ROLLBACK TO sp_insert_fmaconstraints;
128: -- notify caller of an UNEXPECTED error
129: x_return_status := FND_API.G_RET_STS_ERROR;
130:
131: -- store SQL error message on message stack for caller
132: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
133: p_count => x_msg_count,

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

132: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
133: p_count => x_msg_count,
134: p_data => x_msg_data);
135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO sp_insert_fmaconstraints;
138: -- notify caller of an UNEXPECTED error
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140:

Line 139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

135:
136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
137: ROLLBACK TO sp_insert_fmaconstraints;
138: -- notify caller of an UNEXPECTED error
139: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
140:
141: -- store SQL error message on message stack for caller
142: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
143: p_count => x_msg_count,

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: p_data => x_msg_data);
145:
146: WHEN OTHERS THEN
147: -- notify caller of an UNEXPECTED error
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','insert_fmaconstraints');
150:
151: -- store SQL error message on message stack for caller
152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

170: l_fodv_rec fodv_rec_type;
171: l_data VARCHAR2(100);
172: l_count NUMBER ;
173: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
174: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
175: BEGIN
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: SAVEPOINT sp_update_fmaconstraints;
178:

Line 176: x_return_status := FND_API.G_RET_STS_SUCCESS;

172: l_count NUMBER ;
173: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
174: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
175: BEGIN
176: x_return_status := FND_API.G_RET_STS_SUCCESS;
177: SAVEPOINT sp_update_fmaconstraints;
178:
179: l_fmav_rec := p_fmav_rec;
180: l_fodv_rec := p_fodv_rec;

Line 210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

206: END;
207: END IF;
208: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.update_fmaconstraints
209:
210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;

Line 211: RAISE FND_API.G_EXC_ERROR;

207: END IF;
208: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.update_fmaconstraints
209:
210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:

Line 212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

208: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.update_fmaconstraints
209:
210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: /* re-assign local record structure using output record from pvt api */

Line 213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

209:
210: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
211: RAISE FND_API.G_EXC_ERROR;
212: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
213: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
214: END IF;
215:
216: /* re-assign local record structure using output record from pvt api */
217: l_fodv_rec := x_fodv_rec;

Line 222: WHEN FND_API.G_EXC_ERROR THEN

218:
219:
220:
221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO sp_update_fmaconstraints;
224: -- notify caller of an UNEXPECTED error
225: x_return_status := FND_API.G_RET_STS_ERROR;
226:

Line 225: x_return_status := FND_API.G_RET_STS_ERROR;

221: EXCEPTION
222: WHEN FND_API.G_EXC_ERROR THEN
223: ROLLBACK TO sp_update_fmaconstraints;
224: -- notify caller of an UNEXPECTED error
225: x_return_status := FND_API.G_RET_STS_ERROR;
226:
227: -- store SQL error message on message stack for caller
228: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
229: p_count => x_msg_count,

Line 232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO sp_update_fmaconstraints;
234: -- notify caller of an UNEXPECTED error
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231:
232: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
233: ROLLBACK TO sp_update_fmaconstraints;
234: -- notify caller of an UNEXPECTED error
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: -- store SQL error message on message stack for caller
238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
239: p_count => x_msg_count,

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: p_data => x_msg_data);
241:
242: WHEN OTHERS THEN
243: -- notify caller of an UNEXPECTED error
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','update_fmaconstraints');
246:
247: -- store SQL error message on message stack for caller
248: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

263: l_fodv_tbl fodv_tbl_type;
264: l_data VARCHAR2(100);
265: l_count NUMBER ;
266: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmaconstraints';
267: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
268: BEGIN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: SAVEPOINT sp_delete_fmaconstraints;
271:

Line 269: x_return_status := FND_API.G_RET_STS_SUCCESS;

265: l_count NUMBER ;
266: l_api_name CONSTANT VARCHAR2(30) := 'delete_fmaconstraints';
267: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
268: BEGIN
269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270: SAVEPOINT sp_delete_fmaconstraints;
271:
272: l_fodv_tbl := p_fodv_tbl;
273:

Line 300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

296: END;
297: END IF;
298: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.delete_fmaconstraints
299:
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: END IF;
298: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.delete_fmaconstraints
299:
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:

Line 302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

298: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.delete_fmaconstraints
299:
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306:

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299:
300: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306:
307:

Line 309: WHEN FND_API.G_EXC_ERROR THEN

305:
306:
307:
308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: ROLLBACK TO sp_delete_fmaconstraints;
311: -- notify caller of an UNEXPECTED error
312: x_return_status := FND_API.G_RET_STS_ERROR;
313:

Line 312: x_return_status := FND_API.G_RET_STS_ERROR;

308: EXCEPTION
309: WHEN FND_API.G_EXC_ERROR THEN
310: ROLLBACK TO sp_delete_fmaconstraints;
311: -- notify caller of an UNEXPECTED error
312: x_return_status := FND_API.G_RET_STS_ERROR;
313:
314: -- store SQL error message on message stack for caller
315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
316: p_count => x_msg_count,

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
316: p_count => x_msg_count,
317: p_data => x_msg_data);
318:
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO sp_delete_fmaconstraints;
321: -- notify caller of an UNEXPECTED error
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323:

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

318:
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO sp_delete_fmaconstraints;
321: -- notify caller of an UNEXPECTED error
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
323:
324: -- store SQL error message on message stack for caller
325: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
326: p_count => x_msg_count,

Line 331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

327: p_data => x_msg_data);
328:
329: WHEN OTHERS THEN
330: -- notify caller of an UNEXPECTED error
331: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
332: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','delete_fmaconstraints');
333:
334: -- store SQL error message on message stack for caller
335: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

354: l_fodv_tbl fodv_tbl_type;
355: l_data VARCHAR2(100);
356: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
357: l_count NUMBER ;
358: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
359: BEGIN
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361: SAVEPOINT sp_insert_fmaconstraints;
362:

Line 360: x_return_status := FND_API.G_RET_STS_SUCCESS;

356: l_api_name CONSTANT VARCHAR2(30) := 'insert_fmaconstraints';
357: l_count NUMBER ;
358: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
359: BEGIN
360: x_return_status := FND_API.G_RET_STS_SUCCESS;
361: SAVEPOINT sp_insert_fmaconstraints;
362:
363: l_fmav_rec := p_fmav_rec;
364: l_fodv_tbl := p_fodv_tbl;

Line 392: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

388: END;
389: END IF;
390: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
391:
392: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;

Line 393: RAISE FND_API.G_EXC_ERROR;

389: END IF;
390: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
391:
392: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:

Line 394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

390: -- End of wraper code generated automatically by Debug code generator for okl_setupfmaconstraints_pvt.insert_fmaconstraints
391:
392: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: /* re-assign local record structure using output record from pvt api */

Line 395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

391:
392: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
393: RAISE FND_API.G_EXC_ERROR;
394: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
395: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
396: END IF;
397:
398: /* re-assign local record structure using output record from pvt api */
399: l_fodv_tbl := x_fodv_tbl;

Line 404: WHEN FND_API.G_EXC_ERROR THEN

400:
401:
402:
403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: ROLLBACK TO sp_insert_fmaconstraints;
406: -- notify caller of an UNEXPECTED error
407: x_return_status := FND_API.G_RET_STS_ERROR;
408:

Line 407: x_return_status := FND_API.G_RET_STS_ERROR;

403: EXCEPTION
404: WHEN FND_API.G_EXC_ERROR THEN
405: ROLLBACK TO sp_insert_fmaconstraints;
406: -- notify caller of an UNEXPECTED error
407: x_return_status := FND_API.G_RET_STS_ERROR;
408:
409: -- store SQL error message on message stack for caller
410: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
411: p_count => x_msg_count,

Line 414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

410: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
411: p_count => x_msg_count,
412: p_data => x_msg_data);
413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: ROLLBACK TO sp_insert_fmaconstraints;
416: -- notify caller of an UNEXPECTED error
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418:

Line 417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

413:
414: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
415: ROLLBACK TO sp_insert_fmaconstraints;
416: -- notify caller of an UNEXPECTED error
417: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
418:
419: -- store SQL error message on message stack for caller
420: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
421: p_count => x_msg_count,

Line 426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

422: p_data => x_msg_data);
423:
424: WHEN OTHERS THEN
425: -- notify caller of an UNEXPECTED error
426: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
427: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','insert_fmaconstraints');
428:
429: -- store SQL error message on message stack for caller
430: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

450: l_fodv_tbl fodv_tbl_type;
451: l_data VARCHAR2(100);
452: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
453: l_count NUMBER ;
454: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
455: BEGIN
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: SAVEPOINT sp_update_fmaconstraints;
458:

Line 456: x_return_status := FND_API.G_RET_STS_SUCCESS;

452: l_api_name CONSTANT VARCHAR2(30) := 'update_fmaconstraints';
453: l_count NUMBER ;
454: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
455: BEGIN
456: x_return_status := FND_API.G_RET_STS_SUCCESS;
457: SAVEPOINT sp_update_fmaconstraints;
458:
459: l_fmav_rec := p_fmav_rec;
460: l_fodv_tbl := p_fodv_tbl;

Line 488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

484: END;
485: END IF;
486:
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;

Line 489: RAISE FND_API.G_EXC_ERROR;

485: END IF;
486:
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:

Line 490: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

486:
487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: /* re-assign local record structure using output record from pvt api */

Line 491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

487:
488: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
489: RAISE FND_API.G_EXC_ERROR;
490: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
491: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
492: END IF;
493:
494: /* re-assign local record structure using output record from pvt api */
495: l_fodv_tbl := x_fodv_tbl;

Line 499: WHEN FND_API.G_EXC_ERROR THEN

495: l_fodv_tbl := x_fodv_tbl;
496:
497:
498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO sp_update_fmaconstraints;
501: -- notify caller of an UNEXPECTED error
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:

Line 502: x_return_status := FND_API.G_RET_STS_ERROR;

498: EXCEPTION
499: WHEN FND_API.G_EXC_ERROR THEN
500: ROLLBACK TO sp_update_fmaconstraints;
501: -- notify caller of an UNEXPECTED error
502: x_return_status := FND_API.G_RET_STS_ERROR;
503:
504: -- store SQL error message on message stack for caller
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
506: p_count => x_msg_count,

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
506: p_count => x_msg_count,
507: p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO sp_update_fmaconstraints;
511: -- notify caller of an UNEXPECTED error
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513:

Line 512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO sp_update_fmaconstraints;
511: -- notify caller of an UNEXPECTED error
512: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
513:
514: -- store SQL error message on message stack for caller
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
516: p_count => x_msg_count,

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: p_data => x_msg_data);
518:
519: WHEN OTHERS THEN
520: -- notify caller of an UNEXPECTED error
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFMACONSTRAINTS_PUB','update_fmaconstraints');
523:
524: -- store SQL error message on message stack for caller
525: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,