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

Line 128: WHEN FND_API.G_EXC_ERROR THEN

124:
125: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 129: x_return_status := FND_API.G_RET_STS_ERROR;

125: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
126:
127: EXCEPTION
128: WHEN FND_API.G_EXC_ERROR 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 132: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

128: WHEN FND_API.G_EXC_ERROR 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 FND_API.G_EXC_UNEXPECTED_ERROR 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: WHEN NO_DATA_FOUND THEN

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 FND_API.G_EXC_UNEXPECTED_ERROR 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: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;

Line 137: x_return_status := FND_API.G_RET_STS_ERROR;

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: WHEN NO_DATA_FOUND THEN
137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

137: x_return_status := FND_API.G_RET_STS_ERROR;
138: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
143: ,p_data => x_msg_data);
144: if (x_msg_data is null) then
145: x_msg_data := SQLERRM;

Line 188: WHEN FND_API.G_EXC_ERROR THEN

184:
185: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 189: x_return_status := FND_API.G_RET_STS_ERROR;

185: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
186:
187: EXCEPTION
188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

188: WHEN FND_API.G_EXC_ERROR THEN
189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN NO_DATA_FOUND THEN

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: x_return_status := FND_API.G_RET_STS_ERROR;
190: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
191: ,p_data => x_msg_data);
192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN NO_DATA_FOUND THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN NO_DATA_FOUND THEN
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

197: x_return_status := FND_API.G_RET_STS_ERROR;
198: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
202: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
203: ,p_data => x_msg_data);
204: if (x_msg_data is null) then
205: x_msg_data := SQLERRM;

Line 270: WHEN FND_API.G_EXC_ERROR THEN

266:
267: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
273: ,p_data => x_msg_data);
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
273: ,p_data => x_msg_data);
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 322: WHEN FND_API.G_EXC_ERROR THEN

318:
319: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
320:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 323: x_return_status := FND_API.G_RET_STS_ERROR;

319: l_result := BIS_MENU_ENTRIES_PUB.SUBMIT_COMPILE;
320:
321: EXCEPTION
322: WHEN FND_API.G_EXC_ERROR THEN
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

322: WHEN FND_API.G_EXC_ERROR THEN
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: WHEN NO_DATA_FOUND THEN

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

323: x_return_status := FND_API.G_RET_STS_ERROR;
324: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
325: ,p_data => x_msg_data);
326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
328: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
329: ,p_data => x_msg_data);
330: WHEN NO_DATA_FOUND THEN
331: x_return_status := FND_API.G_RET_STS_ERROR;

Line 331: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

331: x_return_status := FND_API.G_RET_STS_ERROR;
332: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
333: ,p_data => x_msg_data);
334: WHEN OTHERS THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
337: ,p_data => x_msg_data);
338: if (x_msg_data is null) then
339: x_msg_data := SQLERRM;

Line 385: WHEN FND_API.G_EXC_ERROR THEN

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

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 394: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: x_return_status := FND_API.G_RET_STS_ERROR;
395: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
396: ,p_data => x_msg_data);
397: WHEN OTHERS THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
400: ,p_data => x_msg_data);
401: if (x_msg_data is null) then
402: x_msg_data := SQLERRM;

Line 448: WHEN FND_API.G_EXC_ERROR THEN

444:
445: end loop;
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 449: x_return_status := FND_API.G_RET_STS_ERROR;

445: end loop;
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

448: WHEN FND_API.G_EXC_ERROR THEN
449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: WHEN NO_DATA_FOUND THEN

Line 453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

449: x_return_status := FND_API.G_RET_STS_ERROR;
450: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
451: ,p_data => x_msg_data);
452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: WHEN NO_DATA_FOUND THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;

Line 457: x_return_status := FND_API.G_RET_STS_ERROR;

453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
455: ,p_data => x_msg_data);
456: WHEN NO_DATA_FOUND THEN
457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: x_return_status := FND_API.G_RET_STS_ERROR;
458: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460: WHEN OTHERS THEN
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
463: ,p_data => x_msg_data);
464: if (x_msg_data is null) then
465: x_msg_data := SQLERRM;

Line 508: WHEN FND_API.G_EXC_ERROR THEN

504:
505: end loop;
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 509: x_return_status := FND_API.G_RET_STS_ERROR;

505: end loop;
506:
507: EXCEPTION
508: WHEN FND_API.G_EXC_ERROR THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

508: WHEN FND_API.G_EXC_ERROR THEN
509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN NO_DATA_FOUND THEN

Line 513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

509: x_return_status := FND_API.G_RET_STS_ERROR;
510: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
511: ,p_data => x_msg_data);
512: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN NO_DATA_FOUND THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;

Line 517: x_return_status := FND_API.G_RET_STS_ERROR;

513: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
514: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
515: ,p_data => x_msg_data);
516: WHEN NO_DATA_FOUND THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
519: ,p_data => x_msg_data);
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: x_return_status := FND_API.G_RET_STS_ERROR;
518: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
519: ,p_data => x_msg_data);
520: WHEN OTHERS THEN
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
523: ,p_data => x_msg_data);
524: if (x_msg_data is null) then
525: x_msg_data := SQLERRM;

Line 566: WHEN FND_API.G_EXC_ERROR THEN

562:
563: end loop;
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 567: x_return_status := FND_API.G_RET_STS_ERROR;

563: end loop;
564:
565: EXCEPTION
566: WHEN FND_API.G_EXC_ERROR THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

566: WHEN FND_API.G_EXC_ERROR THEN
567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574: WHEN NO_DATA_FOUND THEN

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

567: x_return_status := FND_API.G_RET_STS_ERROR;
568: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
569: ,p_data => x_msg_data);
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574: WHEN NO_DATA_FOUND THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;

Line 575: x_return_status := FND_API.G_RET_STS_ERROR;

571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
573: ,p_data => x_msg_data);
574: WHEN NO_DATA_FOUND THEN
575: x_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

575: x_return_status := FND_API.G_RET_STS_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
577: ,p_data => x_msg_data);
578: WHEN OTHERS THEN
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
580: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
581: ,p_data => x_msg_data);
582: if (x_msg_data is null) then
583: x_msg_data := SQLERRM;

Line 618: RAISE FND_API.G_EXC_ERROR;

614:
615: if (cMenuEntry%notfound) then
616: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_DELETED_ERROR');
617: FND_MSG_PUB.ADD;
618: RAISE FND_API.G_EXC_ERROR;
619: end if;
620:
621: if p_last_update_date is not null then
622: if p_last_update_date <> l_last_update_date then

Line 625: RAISE FND_API.G_EXC_ERROR;

621: if p_last_update_date is not null then
622: if p_last_update_date <> l_last_update_date then
623: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_CHANGED_ERROR');
624: FND_MSG_PUB.ADD;
625: RAISE FND_API.G_EXC_ERROR;
626: end if;
627: end if;
628:
629: rollback to SP_LOCK_ROW;

Line 633: WHEN FND_API.G_EXC_ERROR THEN NULL;

629: rollback to SP_LOCK_ROW;
630: CLOSE cMenuEntry;
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN NULL;
634: WHEN OTHERS THEN
635: close cMenuEntry;
636: rollback to SP_LOCK_ROW;
637: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_LOCKED_ERROR');

Line 639: RAISE FND_API.G_EXC_ERROR;

635: close cMenuEntry;
636: rollback to SP_LOCK_ROW;
637: FND_MESSAGE.SET_NAME('BIS','BIS_MENU_ENTRY_LOCKED_ERROR');
638: FND_MSG_PUB.ADD;
639: RAISE FND_API.G_EXC_ERROR;
640: END LOCK_ROW;
641:
642:
643: /*