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.BIS_PAGE_PUB dependencies on FND_API

Line 82: RAISE FND_API.G_EXC_ERROR;

78:
79: if (l_count > 0) then
80: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
81: FND_MSG_PUB.ADD;
82: RAISE FND_API.G_EXC_ERROR;
83: end if;
84:
85: -- Insert new Region
86: BIS_AK_REGION_PUB.INSERT_REGION_ROW (

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: x_msg_data =>x_msg_data);
117: end if;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 121: x_return_status := FND_API.G_RET_STS_ERROR;

117: end if;
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
127: ,p_data => x_msg_data);
128: WHEN NO_DATA_FOUND THEN

Line 125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

121: x_return_status := FND_API.G_RET_STS_ERROR;
122: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
123: ,p_data => x_msg_data);
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
127: ,p_data => x_msg_data);
128: WHEN NO_DATA_FOUND THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
126: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
127: ,p_data => x_msg_data);
128: WHEN NO_DATA_FOUND THEN
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

129: x_return_status := FND_API.G_RET_STS_ERROR;
130: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
135: ,p_data => x_msg_data);
136: if (x_msg_data is null) then
137: x_msg_data := SQLERRM;

Line 215: RAISE FND_API.G_EXC_ERROR;

211:
212: if (l_count > 0) then
213: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
214: FND_MSG_PUB.ADD;
215: RAISE FND_API.G_EXC_ERROR;
216: end if;
217:
218: -- Delete existing region
219: BIS_AK_REGION_PUB.DELETE_REGION_ROW(

Line 275: WHEN FND_API.G_EXC_ERROR THEN

271: x_msg_data =>x_msg_data);
272:
273:
274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 276: x_return_status := FND_API.G_RET_STS_ERROR;

272:
273:
274: EXCEPTION
275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: WHEN FND_API.G_EXC_ERROR THEN
276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN NO_DATA_FOUND THEN

Line 280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: x_return_status := FND_API.G_RET_STS_ERROR;
277: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN NO_DATA_FOUND THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;

Line 284: x_return_status := FND_API.G_RET_STS_ERROR;

280: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
282: ,p_data => x_msg_data);
283: WHEN NO_DATA_FOUND THEN
284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

284: x_return_status := FND_API.G_RET_STS_ERROR;
285: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
290: ,p_data => x_msg_data);
291: if (x_msg_data is null) then
292: x_msg_data := SQLERRM;

Line 331: WHEN FND_API.G_EXC_ERROR THEN

327: x_msg_count => x_msg_count,
328: x_msg_data =>x_msg_data);
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
334: ,p_data => x_msg_data);
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 332: x_return_status := FND_API.G_RET_STS_ERROR;

328: x_msg_data =>x_msg_data);
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
334: ,p_data => x_msg_data);
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

331: WHEN FND_API.G_EXC_ERROR THEN
332: x_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
334: ,p_data => x_msg_data);
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN NO_DATA_FOUND THEN

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: x_return_status := FND_API.G_RET_STS_ERROR;
333: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
334: ,p_data => x_msg_data);
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;

Line 340: x_return_status := FND_API.G_RET_STS_ERROR;

336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
338: ,p_data => x_msg_data);
339: WHEN NO_DATA_FOUND THEN
340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
342: ,p_data => x_msg_data);
343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

340: x_return_status := FND_API.G_RET_STS_ERROR;
341: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
342: ,p_data => x_msg_data);
343: WHEN OTHERS THEN
344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
345: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
346: ,p_data => x_msg_data);
347: if (x_msg_data is null) then
348: x_msg_data := SQLERRM;

Line 380: WHEN FND_API.G_EXC_ERROR THEN

376: x_msg_data =>x_msg_data);
377:
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 381: x_return_status := FND_API.G_RET_STS_ERROR;

377:
378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

380: WHEN FND_API.G_EXC_ERROR THEN
381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
387: ,p_data => x_msg_data);
388: WHEN NO_DATA_FOUND THEN

Line 385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

381: x_return_status := FND_API.G_RET_STS_ERROR;
382: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
383: ,p_data => x_msg_data);
384: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
387: ,p_data => x_msg_data);
388: WHEN NO_DATA_FOUND THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;

Line 389: x_return_status := FND_API.G_RET_STS_ERROR;

385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
387: ,p_data => x_msg_data);
388: WHEN NO_DATA_FOUND THEN
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

389: x_return_status := FND_API.G_RET_STS_ERROR;
390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
391: ,p_data => x_msg_data);
392: WHEN OTHERS THEN
393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
395: ,p_data => x_msg_data);
396: if (x_msg_data is null) then
397: x_msg_data := SQLERRM;

Line 429: WHEN FND_API.G_EXC_ERROR THEN

425: x_msg_count => x_msg_count,
426: x_msg_data =>x_msg_data);
427:
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 430: x_return_status := FND_API.G_RET_STS_ERROR;

426: x_msg_data =>x_msg_data);
427:
428: EXCEPTION
429: WHEN FND_API.G_EXC_ERROR THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

429: WHEN FND_API.G_EXC_ERROR THEN
430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN NO_DATA_FOUND THEN

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430: x_return_status := FND_API.G_RET_STS_ERROR;
431: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
432: ,p_data => x_msg_data);
433: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN NO_DATA_FOUND THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;

Line 438: x_return_status := FND_API.G_RET_STS_ERROR;

434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
436: ,p_data => x_msg_data);
437: WHEN NO_DATA_FOUND THEN
438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
440: ,p_data => x_msg_data);
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

438: x_return_status := FND_API.G_RET_STS_ERROR;
439: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
440: ,p_data => x_msg_data);
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445: if (x_msg_data is null) then
446: x_msg_data := SQLERRM;

Line 484: WHEN FND_API.G_EXC_ERROR THEN

480: x_msg_count => x_msg_count,
481: x_msg_data =>x_msg_data);
482:
483: EXCEPTION
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481: x_msg_data =>x_msg_data);
482:
483: EXCEPTION
484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: WHEN FND_API.G_EXC_ERROR THEN
485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN NO_DATA_FOUND THEN

Line 489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

485: x_return_status := FND_API.G_RET_STS_ERROR;
486: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
487: ,p_data => x_msg_data);
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN NO_DATA_FOUND THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;

Line 493: x_return_status := FND_API.G_RET_STS_ERROR;

489: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
490: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
491: ,p_data => x_msg_data);
492: WHEN NO_DATA_FOUND THEN
493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

493: x_return_status := FND_API.G_RET_STS_ERROR;
494: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
495: ,p_data => x_msg_data);
496: WHEN OTHERS THEN
497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
498: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
499: ,p_data => x_msg_data);
500: if (x_msg_data is null) then
501: x_msg_data := SQLERRM;

Line 529: WHEN FND_API.G_EXC_ERROR THEN

525: x_msg_data =>x_msg_data);
526:
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526:
527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

529: WHEN FND_API.G_EXC_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN NO_DATA_FOUND THEN

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
532: ,p_data => x_msg_data);
533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
536: ,p_data => x_msg_data);
537: WHEN NO_DATA_FOUND THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
540: ,p_data => x_msg_data);
541: WHEN OTHERS THEN
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
544: ,p_data => x_msg_data);
545: if (x_msg_data is null) then
546: x_msg_data := SQLERRM;

Line 584: WHEN FND_API.G_EXC_ERROR THEN

580: x_msg_count => x_msg_count,
581: x_msg_data =>x_msg_data);
582:
583: EXCEPTION
584: WHEN FND_API.G_EXC_ERROR THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581: x_msg_data =>x_msg_data);
582:
583: EXCEPTION
584: WHEN FND_API.G_EXC_ERROR THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

584: WHEN FND_API.G_EXC_ERROR THEN
585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN NO_DATA_FOUND THEN

Line 589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

585: x_return_status := FND_API.G_RET_STS_ERROR;
586: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
587: ,p_data => x_msg_data);
588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN NO_DATA_FOUND THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;

Line 593: x_return_status := FND_API.G_RET_STS_ERROR;

589: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
590: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
591: ,p_data => x_msg_data);
592: WHEN NO_DATA_FOUND THEN
593: x_return_status := FND_API.G_RET_STS_ERROR;
594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
595: ,p_data => x_msg_data);
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: x_return_status := FND_API.G_RET_STS_ERROR;
594: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
595: ,p_data => x_msg_data);
596: WHEN OTHERS THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
599: ,p_data => x_msg_data);
600: if (x_msg_data is null) then
601: x_msg_data := SQLERRM;

Line 628: WHEN FND_API.G_EXC_ERROR THEN

624: x_msg_count => x_msg_count,
625: x_msg_data =>x_msg_data);
626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625: x_msg_data =>x_msg_data);
626:
627: EXCEPTION
628: WHEN FND_API.G_EXC_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

628: WHEN FND_API.G_EXC_ERROR THEN
629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN NO_DATA_FOUND THEN

Line 633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

629: x_return_status := FND_API.G_RET_STS_ERROR;
630: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
631: ,p_data => x_msg_data);
632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN NO_DATA_FOUND THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;

Line 637: x_return_status := FND_API.G_RET_STS_ERROR;

633: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
634: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN NO_DATA_FOUND THEN
637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
639: ,p_data => x_msg_data);
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: x_return_status := FND_API.G_RET_STS_ERROR;
638: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
639: ,p_data => x_msg_data);
640: WHEN OTHERS THEN
641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
642: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
643: ,p_data => x_msg_data);
644: if (x_msg_data is null) then
645: x_msg_data := SQLERRM;

Line 691: WHEN FND_API.G_EXC_ERROR THEN

687: CLOSE pageRacks_cursor;
688: end if;
689:
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 692: x_return_status := FND_API.G_RET_STS_ERROR;

688: end if;
689:
690: EXCEPTION
691: WHEN FND_API.G_EXC_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

691: WHEN FND_API.G_EXC_ERROR THEN
692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN NO_DATA_FOUND THEN

Line 696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

692: x_return_status := FND_API.G_RET_STS_ERROR;
693: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
694: ,p_data => x_msg_data);
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN NO_DATA_FOUND THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;

Line 700: x_return_status := FND_API.G_RET_STS_ERROR;

696: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN NO_DATA_FOUND THEN
700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700: x_return_status := FND_API.G_RET_STS_ERROR;
701: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
702: ,p_data => x_msg_data);
703: WHEN OTHERS THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
706: ,p_data => x_msg_data);
707: if (x_msg_data is null) then
708: x_msg_data := SQLERRM;

Line 749: WHEN FND_API.G_EXC_ERROR THEN

745: close items_cursor;
746: end if;
747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746: end if;
747:
748: EXCEPTION
749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

749: WHEN FND_API.G_EXC_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
756: ,p_data => x_msg_data);
757: WHEN NO_DATA_FOUND THEN

Line 754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

750: x_return_status := FND_API.G_RET_STS_ERROR;
751: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
752: ,p_data => x_msg_data);
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
756: ,p_data => x_msg_data);
757: WHEN NO_DATA_FOUND THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;

Line 758: x_return_status := FND_API.G_RET_STS_ERROR;

754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
756: ,p_data => x_msg_data);
757: WHEN NO_DATA_FOUND THEN
758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

758: x_return_status := FND_API.G_RET_STS_ERROR;
759: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
760: ,p_data => x_msg_data);
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
764: ,p_data => x_msg_data);
765: if (x_msg_data is null) then
766: x_msg_data := SQLERRM;

Line 887: RAISE FND_API.G_EXC_ERROR;

883: x_msg_data =>x_msg_data);
884: else
885: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
886: FND_MSG_PUB.ADD;
887: RAISE FND_API.G_EXC_ERROR;
888: end if;
889: end if;
890:
891: -- Insert new Region

Line 939: WHEN FND_API.G_EXC_ERROR THEN

935:
936:
937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 940: x_return_status := FND_API.G_RET_STS_ERROR;

936:
937:
938: EXCEPTION
939: WHEN FND_API.G_EXC_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

939: WHEN FND_API.G_EXC_ERROR THEN
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
946: ,p_data => x_msg_data);
947: WHEN NO_DATA_FOUND THEN

Line 944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

940: x_return_status := FND_API.G_RET_STS_ERROR;
941: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
942: ,p_data => x_msg_data);
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
946: ,p_data => x_msg_data);
947: WHEN NO_DATA_FOUND THEN
948: x_return_status := FND_API.G_RET_STS_ERROR;

Line 948: x_return_status := FND_API.G_RET_STS_ERROR;

944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
946: ,p_data => x_msg_data);
947: WHEN NO_DATA_FOUND THEN
948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
950: ,p_data => x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

948: x_return_status := FND_API.G_RET_STS_ERROR;
949: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
950: ,p_data => x_msg_data);
951: WHEN OTHERS THEN
952: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
953: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
954: ,p_data => x_msg_data);
955: if (x_msg_data is null) then
956: x_msg_data := SQLERRM;

Line 989: RAISE FND_API.G_EXC_ERROR;

985: if (l_count > 0) then
986: -- Trying to update a non-page function.
987: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
988: FND_MSG_PUB.ADD;
989: RAISE FND_API.G_EXC_ERROR;
990: else
991:
992: select lower(application_short_name) into l_app_short_name
993: from fnd_application

Line 1022: WHEN FND_API.G_EXC_ERROR THEN

1018: x_msg_data =>x_msg_data);
1019: end if;
1020:
1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1023: x_return_status := FND_API.G_RET_STS_ERROR;

1019: end if;
1020:
1021: EXCEPTION
1022: WHEN FND_API.G_EXC_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1022: WHEN FND_API.G_EXC_ERROR THEN
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1029: ,p_data => x_msg_data);
1030: WHEN NO_DATA_FOUND THEN

Line 1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1023: x_return_status := FND_API.G_RET_STS_ERROR;
1024: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1025: ,p_data => x_msg_data);
1026: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1029: ,p_data => x_msg_data);
1030: WHEN NO_DATA_FOUND THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1031: x_return_status := FND_API.G_RET_STS_ERROR;

1027: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1028: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1029: ,p_data => x_msg_data);
1030: WHEN NO_DATA_FOUND THEN
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1033: ,p_data => x_msg_data);
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1033: ,p_data => x_msg_data);
1034: WHEN OTHERS THEN
1035: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1036: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1037: ,p_data => x_msg_data);
1038: if (x_msg_data is null) then
1039: x_msg_data := SQLERRM;

Line 1125: RAISE FND_API.G_EXC_ERROR;

1121: if (l_count > 0) then
1122: -- Duplicate function name
1123: FND_MESSAGE.SET_NAME('BIS','BIS_PD_UNIQUE_PGE_ERR');
1124: FND_MSG_PUB.ADD;
1125: RAISE FND_API.G_EXC_ERROR;
1126: end if;
1127:
1128: UPDATE fnd_form_functions
1129: SET function_name = l_page_function_name

Line 1143: WHEN FND_API.G_EXC_ERROR THEN

1139: x_msg_count => x_msg_count,
1140: x_msg_data =>x_msg_data);
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1144: x_return_status := FND_API.G_RET_STS_ERROR;

1140: x_msg_data =>x_msg_data);
1141:
1142: EXCEPTION
1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1143: WHEN FND_API.G_EXC_ERROR THEN
1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: WHEN NO_DATA_FOUND THEN

Line 1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1144: x_return_status := FND_API.G_RET_STS_ERROR;
1145: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1146: ,p_data => x_msg_data);
1147: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: WHEN NO_DATA_FOUND THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1152: x_return_status := FND_API.G_RET_STS_ERROR;

1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1150: ,p_data => x_msg_data);
1151: WHEN NO_DATA_FOUND THEN
1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1152: x_return_status := FND_API.G_RET_STS_ERROR;
1153: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1154: ,p_data => x_msg_data);
1155: WHEN OTHERS THEN
1156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1157: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
1158: ,p_data => x_msg_data);
1159: if (x_msg_data is null) then
1160: x_msg_data := SQLERRM;