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

Line 127: WHEN FND_API.G_EXC_ERROR THEN

123: end if;
124:
125:
126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: rollback;
129: FND_MSG_PUB.Initialize;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

126: EXCEPTION
127: WHEN FND_API.G_EXC_ERROR THEN
128: rollback;
129: FND_MSG_PUB.Initialize;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: rollback;

Line 133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

129: FND_MSG_PUB.Initialize;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: rollback;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
137: ,p_data => x_msg_data);

Line 135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

131: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
132: ,p_data => x_msg_data);
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: rollback;
135: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
137: ,p_data => x_msg_data);
138: WHEN NO_DATA_FOUND THEN
139: rollback;

Line 140: x_return_status := FND_API.G_RET_STS_ERROR;

136: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
137: ,p_data => x_msg_data);
138: WHEN NO_DATA_FOUND THEN
139: rollback;
140: x_return_status := FND_API.G_RET_STS_ERROR;
141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
142: ,p_data => x_msg_data);
143: WHEN OTHERS THEN
144: rollback;

Line 145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

141: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
142: ,p_data => x_msg_data);
143: WHEN OTHERS THEN
144: rollback;
145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
146: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
147: ,p_data => x_msg_data);
148:
149: end Apply_Multi_User_Env;

Line 179: RAISE FND_API.G_EXC_ERROR;

175: ,x_return_status
176: ,x_msg_count
177: ,x_msg_data);
178: else
179: RAISE FND_API.G_EXC_ERROR;
180: end if;
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: RAISE FND_API.G_EXC_ERROR;
180: end if;
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: rollback;
185: FND_MSG_PUB.Initialize;
186: --x_return_status := FND_API.G_RET_STS_ERROR;
187: x_return_status := 'C';

Line 186: --x_return_status := FND_API.G_RET_STS_ERROR;

182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: rollback;
185: FND_MSG_PUB.Initialize;
186: --x_return_status := FND_API.G_RET_STS_ERROR;
187: x_return_status := 'C';
188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

186: --x_return_status := FND_API.G_RET_STS_ERROR;
187: x_return_status := 'C';
188: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
189: ,p_data => x_msg_data);
190: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
191: rollback;
192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
194: ,p_data => x_msg_data);

Line 192: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 197: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

198: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
199: ,p_data => x_msg_data);
200: WHEN OTHERS THEN
201: rollback;
202: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
204: ,p_data => x_msg_data);
205:
206: end Have_Time_Stamps_Changed;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: from BSC_TABS_B
226: where tab_id = p_obj_id;
227:
228: if l_time_stamp > p_time_stamp then
229: RAISE FND_API.G_EXC_ERROR;
230: end if;
231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN

Line 233: WHEN FND_API.G_EXC_ERROR THEN

229: RAISE FND_API.G_EXC_ERROR;
230: end if;
231:
232: EXCEPTION
233: WHEN FND_API.G_EXC_ERROR THEN
234: rollback;
235: x_return_status := 'C';
236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
237: ,p_data => x_msg_data);

Line 238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

234: rollback;
235: x_return_status := 'C';
236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
237: ,p_data => x_msg_data);
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: rollback;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
242: ,p_data => x_msg_data);

Line 240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

236: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
237: ,p_data => x_msg_data);
238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
239: rollback;
240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
241: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
242: ,p_data => x_msg_data);
243: WHEN NO_DATA_FOUND THEN
244: rollback;

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
247: ,p_data => x_msg_data);
248: WHEN OTHERS THEN
249: rollback;
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
252: ,p_data => x_msg_data);
253:
254: end Check_Tab_Time_Stamp;

Line 278: RAISE FND_API.G_EXC_ERROR;

274: where indicator = p_obj_id;
275:
276: /*
277: if l_time_stamp > p_time_stamp then
278: RAISE FND_API.G_EXC_ERROR;
279: end if;
280: */
281: if to_date(l_time_stamp, 'DD-MM-YYYY-HH24-MI-SS') > to_date(p_time_stamp, 'DD-MM-YYYY-HH24-MI-SS') then
282: RAISE FND_API.G_EXC_ERROR;

Line 282: RAISE FND_API.G_EXC_ERROR;

278: RAISE FND_API.G_EXC_ERROR;
279: end if;
280: */
281: if to_date(l_time_stamp, 'DD-MM-YYYY-HH24-MI-SS') > to_date(p_time_stamp, 'DD-MM-YYYY-HH24-MI-SS') then
282: RAISE FND_API.G_EXC_ERROR;
283: end if;
284:
285:
286: EXCEPTION

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: end if;
284:
285:
286: EXCEPTION
287: WHEN FND_API.G_EXC_ERROR THEN
288: rollback;
289: x_return_status := 'C';
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: ,p_data => x_msg_data);

Line 292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

288: rollback;
289: x_return_status := 'C';
290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: ,p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: rollback;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
296: ,p_data => x_msg_data);

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
291: ,p_data => x_msg_data);
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: rollback;
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
296: ,p_data => x_msg_data);
297: WHEN NO_DATA_FOUND THEN
298: rollback;

Line 304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

300: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
301: ,p_data => x_msg_data);
302: WHEN OTHERS THEN
303: rollback;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
305: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
306: ,p_data => x_msg_data);
307:
308: end Check_Kpi_Time_Stamp;

Line 331: RAISE FND_API.G_EXC_ERROR;

327: from BSC_SYS_INIT
328: where property_code = p_property_code;
329:
330: if l_time_stamp > p_time_stamp then
331: RAISE FND_API.G_EXC_ERROR;
332: end if;
333:
334:
335: EXCEPTION

Line 336: WHEN FND_API.G_EXC_ERROR THEN

332: end if;
333:
334:
335: EXCEPTION
336: WHEN FND_API.G_EXC_ERROR THEN
337: rollback;
338: x_return_status := 'C';
339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
340: ,p_data => x_msg_data);

Line 341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

337: rollback;
338: x_return_status := 'C';
339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: rollback;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
345: ,p_data => x_msg_data);

Line 343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

339: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
340: ,p_data => x_msg_data);
341: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
342: rollback;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN NO_DATA_FOUND THEN
347: rollback;

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
345: ,p_data => x_msg_data);
346: WHEN NO_DATA_FOUND THEN
347: rollback;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN OTHERS THEN
352: rollback;

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

349: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
350: ,p_data => x_msg_data);
351: WHEN OTHERS THEN
352: rollback;
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
354: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
355: ,p_data => x_msg_data);
356:
357: end Check_System_Change;

Line 384: WHEN FND_API.G_EXC_ERROR THEN

380: and rownum < 2
381: for update nowait;
382:
383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN
385: -- rollback;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
388: ,p_data => x_msg_data);

Line 386: x_return_status := FND_API.G_RET_STS_ERROR;

382:
383: EXCEPTION
384: WHEN FND_API.G_EXC_ERROR THEN
385: -- rollback;
386: x_return_status := FND_API.G_RET_STS_ERROR;
387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: -- rollback;

Line 389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

387: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
388: ,p_data => x_msg_data);
389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
390: -- rollback;
391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
392: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
393: ,p_data => x_msg_data);
394: WHEN NO_DATA_FOUND THEN
395: -- rollback;

Line 397: -- x_return_status := FND_API.G_RET_STS_ERROR;

393: ,p_data => x_msg_data);
394: WHEN NO_DATA_FOUND THEN
395: -- rollback;
396: x_return_status := 'D';
397: -- x_return_status := FND_API.G_RET_STS_ERROR;
398: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
399: ,p_data => x_msg_data);
400: WHEN OTHERS THEN
401: -- rollback;

Line 409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

405: x_return_status := 'L';
406: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
407: ,p_data => x_msg_data);
408: else
409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
410: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
411: ,p_data => x_msg_data);
412: IF (x_msg_data IS NULL) THEN
413: x_msg_data := SQLERRM||' at BSC_MULTI_USER_PVT.Tab_Details_Lock ';

Line 454: WHEN FND_API.G_EXC_ERROR THEN

450: for update nowait;
451:
452:
453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: rollback;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
458: ,p_data => x_msg_data);

Line 456: x_return_status := FND_API.G_RET_STS_ERROR;

452:
453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: rollback;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
458: ,p_data => x_msg_data);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: rollback;

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: rollback;
456: x_return_status := FND_API.G_RET_STS_ERROR;
457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
458: ,p_data => x_msg_data);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: rollback;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
463: ,p_data => x_msg_data);

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
458: ,p_data => x_msg_data);
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: rollback;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
463: ,p_data => x_msg_data);
464: WHEN NO_DATA_FOUND THEN
465: rollback;

Line 467: -- x_return_status := FND_API.G_RET_STS_ERROR;

463: ,p_data => x_msg_data);
464: WHEN NO_DATA_FOUND THEN
465: rollback;
466: x_return_status := 'D';
467: -- x_return_status := FND_API.G_RET_STS_ERROR;
468: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
469: ,p_data => x_msg_data);
470: WHEN OTHERS THEN
471: rollback;

Line 477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

473: x_return_status := 'L';
474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
475: ,p_data => x_msg_data);
476: else
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
479: ,p_data => x_msg_data);
480: end if;
481:

Line 509: WHEN FND_API.G_EXC_ERROR THEN

505: where tab_id = p_obj_id
506: for update nowait;
507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: rollback;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
513: ,p_data => x_msg_data);

Line 511: x_return_status := FND_API.G_RET_STS_ERROR;

507:
508: EXCEPTION
509: WHEN FND_API.G_EXC_ERROR THEN
510: rollback;
511: x_return_status := FND_API.G_RET_STS_ERROR;
512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
513: ,p_data => x_msg_data);
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: rollback;

Line 514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

512: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
513: ,p_data => x_msg_data);
514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
515: rollback;
516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
517: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
518: ,p_data => x_msg_data);
519: WHEN NO_DATA_FOUND THEN
520: rollback;

Line 522: -- x_return_status := FND_API.G_RET_STS_ERROR;

518: ,p_data => x_msg_data);
519: WHEN NO_DATA_FOUND THEN
520: rollback;
521: x_return_status := 'D';
522: -- x_return_status := FND_API.G_RET_STS_ERROR;
523: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
524: ,p_data => x_msg_data);
525: WHEN OTHERS THEN
526: rollback;

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: x_return_status := 'L';
529: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
530: ,p_data => x_msg_data);
531: else
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
534: ,p_data => x_msg_data);
535: end if;
536:

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: where indicator = p_obj_id
565: for update nowait;
566:
567: EXCEPTION
568: WHEN FND_API.G_EXC_ERROR THEN
569: rollback;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
572: ,p_data => x_msg_data);

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

569: rollback;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
572: ,p_data => x_msg_data);
573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: rollback;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
577: ,p_data => x_msg_data);

Line 575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 581: -- x_return_status := FND_API.G_RET_STS_ERROR;

577: ,p_data => x_msg_data);
578: WHEN NO_DATA_FOUND THEN
579: rollback;
580: x_return_status := 'D';
581: -- x_return_status := FND_API.G_RET_STS_ERROR;
582: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
583: ,p_data => x_msg_data);
584: WHEN OTHERS THEN
585: rollback;

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

587: x_return_status := 'L';
588: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
589: ,p_data => x_msg_data);
590: else
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
593: ,p_data => x_msg_data);
594: end if;
595:

Line 633: WHEN FND_API.G_EXC_ERROR THEN

629: for update nowait;
630: */
631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);

Line 635: x_return_status := FND_API.G_RET_STS_ERROR;

631:
632: EXCEPTION
633: WHEN FND_API.G_EXC_ERROR THEN
634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;

Line 638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

634: rollback;
635: x_return_status := FND_API.G_RET_STS_ERROR;
636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
637: ,p_data => x_msg_data);
638: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
639: rollback;
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
642: ,p_data => x_msg_data);
643: WHEN NO_DATA_FOUND THEN
644: rollback;

Line 646: -- x_return_status := FND_API.G_RET_STS_ERROR;

642: ,p_data => x_msg_data);
643: WHEN NO_DATA_FOUND THEN
644: rollback;
645: x_return_status := 'D';
646: -- x_return_status := FND_API.G_RET_STS_ERROR;
647: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
648: ,p_data => x_msg_data);
649: WHEN OTHERS THEN
650: rollback;

Line 656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

652: x_return_status := 'L';
653: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
654: ,p_data => x_msg_data);
655: else
656: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
657: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
658: ,p_data => x_msg_data);
659: end if;
660:

Line 694: WHEN FND_API.G_EXC_ERROR THEN

690: end if;
691:
692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: rollback;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
698: ,p_data => x_msg_data);

Line 696: x_return_status := FND_API.G_RET_STS_ERROR;

692:
693: EXCEPTION
694: WHEN FND_API.G_EXC_ERROR THEN
695: rollback;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: rollback;

Line 699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

695: rollback;
696: x_return_status := FND_API.G_RET_STS_ERROR;
697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: rollback;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
703: ,p_data => x_msg_data);

Line 701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

697: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
698: ,p_data => x_msg_data);
699: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
700: rollback;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
703: ,p_data => x_msg_data);
704: WHEN NO_DATA_FOUND THEN
705: rollback;

Line 707: -- x_return_status := FND_API.G_RET_STS_ERROR;

703: ,p_data => x_msg_data);
704: WHEN NO_DATA_FOUND THEN
705: rollback;
706: x_return_status := 'D';
707: -- x_return_status := FND_API.G_RET_STS_ERROR;
708: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
709: ,p_data => x_msg_data);
710: WHEN OTHERS THEN
711: rollback;

Line 717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

713: x_return_status := 'L';
714: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
715: ,p_data => x_msg_data);
716: else
717: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
718: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
719: ,p_data => x_msg_data);
720: end if;
721: