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

Line 54: WHEN FND_API.G_EXC_ERROR THEN

50: ,x_msg_count
51: ,x_msg_data
52: );
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO BSCSetTimeDataSetPUB;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
58: ,p_data => x_msg_data);

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: );
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO BSCSetTimeDataSetPUB;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: ROLLBACK TO BSCSetTimeDataSetPUB;

Line 59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

55: ROLLBACK TO BSCSetTimeDataSetPUB;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: ROLLBACK TO BSCSetTimeDataSetPUB;
61: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );
62:
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: ROLLBACK TO BSCSetTimeDataSetPUB;
61: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );
62:
63: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
64: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66: WHEN OTHERS THEN
67: --dbms_output.put_line(' OTHERS ' );

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: ,p_data => x_msg_data);
66: WHEN OTHERS THEN
67: --dbms_output.put_line(' OTHERS ' );
68: ROLLBACK TO BSCSetTimeDataSetPUB;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
71: ,p_data => x_msg_data);
72:
73: end SET_TIME_STAMP_DATASET;

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144: end if;
145: close l_cursor;
146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO BSCSetTimeDataSetPUB;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
152: ,p_data => x_msg_data);

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO BSCSetTimeDataSetPUB;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
152: ,p_data => x_msg_data);
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO BSCSetTimeDataSetPUB;

Line 153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

149: ROLLBACK TO BSCSetTimeDataSetPUB;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
152: ,p_data => x_msg_data);
153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO BSCSetTimeDataSetPUB;
155: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
154: ROLLBACK TO BSCSetTimeDataSetPUB;
155: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
159: ,p_data => x_msg_data);
160: WHEN OTHERS THEN
161: --dbms_output.put_line(' OTHERS ' );

Line 163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

159: ,p_data => x_msg_data);
160: WHEN OTHERS THEN
161: --dbms_output.put_line(' OTHERS ' );
162: ROLLBACK TO BSCSetTimeDataSetPUB;
163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
164: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
165: ,p_data => x_msg_data);
166:
167: end SET_TIME_STAMP_DATASET;

Line 191: WHEN FND_API.G_EXC_ERROR THEN

187: ,x_msg_count
188: ,x_msg_data
189: );
190: EXCEPTION
191: WHEN FND_API.G_EXC_ERROR THEN
192: ROLLBACK TO BSCSetTimeDataSrcPUB;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

192: ROLLBACK TO BSCSetTimeDataSrcPUB;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: ROLLBACK TO BSCSetTimeDataSrcPUB;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
200: ,p_data => x_msg_data);

Line 198: 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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
197: ROLLBACK TO BSCSetTimeDataSrcPUB;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
199: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
200: ,p_data => x_msg_data);
201: WHEN OTHERS THEN
202: ROLLBACK TO BSCSetTimeDataSrcPUB;

Line 203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

199: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
200: ,p_data => x_msg_data);
201: WHEN OTHERS THEN
202: ROLLBACK TO BSCSetTimeDataSrcPUB;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
204: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
205: ,p_data => x_msg_data);
206:
207: end SET_TIME_STAMP_DATASOURCE;

Line 232: WHEN FND_API.G_EXC_ERROR THEN

228: ,x_msg_count
229: ,x_msg_data
230: );
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO BSCSetTimeDataSrcPUB;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
236: ,p_data => x_msg_data);

Line 234: x_return_status := FND_API.G_RET_STS_ERROR;

230: );
231: EXCEPTION
232: WHEN FND_API.G_EXC_ERROR THEN
233: ROLLBACK TO BSCSetTimeDataSrcPUB;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO BSCSetTimeDataSrcPUB;

Line 237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

233: ROLLBACK TO BSCSetTimeDataSrcPUB;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO BSCSetTimeDataSrcPUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
241: ,p_data => x_msg_data);

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
236: ,p_data => x_msg_data);
237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
238: ROLLBACK TO BSCSetTimeDataSrcPUB;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
241: ,p_data => x_msg_data);
242: WHEN OTHERS THEN
243: ROLLBACK TO BSCSetTimeDataSrcPUB;

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
241: ,p_data => x_msg_data);
242: WHEN OTHERS THEN
243: ROLLBACK TO BSCSetTimeDataSrcPUB;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
246: ,p_data => x_msg_data);
247:
248: end SET_TIME_STAMP_DATASOURCE;

Line 352: WHEN FND_API.G_EXC_ERROR THEN

348: end loop;
349: close l_cursor;
350:
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: ROLLBACK TO BSCLockDataSetPUB;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
356: ,p_data => x_msg_data);

Line 354: x_return_status := FND_API.G_RET_STS_ERROR;

350:
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: ROLLBACK TO BSCLockDataSetPUB;
354: x_return_status := FND_API.G_RET_STS_ERROR;
355: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
356: ,p_data => x_msg_data);
357: raise;
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

354: x_return_status := FND_API.G_RET_STS_ERROR;
355: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
356: ,p_data => x_msg_data);
357: raise;
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO BSCLockDataSetPUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
362: ,p_data => x_msg_data);

Line 360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

356: ,p_data => x_msg_data);
357: raise;
358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
359: ROLLBACK TO BSCLockDataSetPUB;
360: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
361: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
362: ,p_data => x_msg_data);
363: raise;
364: WHEN OTHERS THEN

Line 366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

362: ,p_data => x_msg_data);
363: raise;
364: WHEN OTHERS THEN
365: ROLLBACK TO BSCLockDataSetPUB;
366: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
367: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
368: ,p_data => x_msg_data);
369: raise;
370: end LOCK_DATASET;

Line 398: WHEN FND_API.G_EXC_ERROR THEN

394: ,x_msg_data
395: ) ;
396:
397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO BSCLockDataSrcPUB;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
402: ,p_data => x_msg_data);

Line 400: x_return_status := FND_API.G_RET_STS_ERROR;

396:
397: EXCEPTION
398: WHEN FND_API.G_EXC_ERROR THEN
399: ROLLBACK TO BSCLockDataSrcPUB;
400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
402: ,p_data => x_msg_data);
403: raise;
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

400: x_return_status := FND_API.G_RET_STS_ERROR;
401: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
402: ,p_data => x_msg_data);
403: raise;
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: ROLLBACK TO BSCLockDataSrcPUB;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
408: ,p_data => x_msg_data);

Line 406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

402: ,p_data => x_msg_data);
403: raise;
404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
405: ROLLBACK TO BSCLockDataSrcPUB;
406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
407: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
408: ,p_data => x_msg_data);
409: raise;
410: WHEN OTHERS THEN

Line 412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

408: ,p_data => x_msg_data);
409: raise;
410: WHEN OTHERS THEN
411: ROLLBACK TO BSCLockDataSrcPUB;
412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
413: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
414: ,p_data => x_msg_data);
415: raise;
416: end LOCK_DATASOURCE;

Line 440: WHEN FND_API.G_EXC_ERROR THEN

436: ,x_msg_data => x_msg_data
437: );
438:
439: EXCEPTION
440: WHEN FND_API.G_EXC_ERROR THEN
441: rollback;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
444: ,p_data => x_msg_data);

Line 442: x_return_status := FND_API.G_RET_STS_ERROR;

438:
439: EXCEPTION
440: WHEN FND_API.G_EXC_ERROR THEN
441: rollback;
442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445: raise;
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

442: x_return_status := FND_API.G_RET_STS_ERROR;
443: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
444: ,p_data => x_msg_data);
445: raise;
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: rollback;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
450: ,p_data => x_msg_data);

Line 448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

444: ,p_data => x_msg_data);
445: raise;
446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
447: rollback;
448: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
449: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451: raise;
452: WHEN OTHERS THEN

Line 454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

450: ,p_data => x_msg_data);
451: raise;
452: WHEN OTHERS THEN
453: rollback;
454: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
455: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
456: ,p_data => x_msg_data);
457: raise;
458: end LOCK_CREATE_MEASURE;

Line 483: WHEN FND_API.G_EXC_ERROR THEN

479: ,x_msg_data => x_msg_data
480: );
481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: --rollback;
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);

Line 485: x_return_status := FND_API.G_RET_STS_ERROR;

481:
482: EXCEPTION
483: WHEN FND_API.G_EXC_ERROR THEN
484: --rollback;
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: raise;
489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 489: WHEN FND_API.G_EXC_UNEXPECTED_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: raise;
489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: --rollback;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
493: ,p_data => x_msg_data);

Line 491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

487: ,p_data => x_msg_data);
488: raise;
489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
490: --rollback;
491: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
492: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
493: ,p_data => x_msg_data);
494: raise;
495: WHEN OTHERS THEN

Line 497: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

493: ,p_data => x_msg_data);
494: raise;
495: WHEN OTHERS THEN
496: --rollback;
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: raise;
501: end LOCK_UPDATE_MEASURE;

Line 524: WHEN FND_API.G_EXC_ERROR THEN

520: ,x_msg_data => x_msg_data
521: );
522:
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: --rollback;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
528: ,p_data => x_msg_data);

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522:
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: --rollback;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
528: ,p_data => x_msg_data);
529: raise;
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

528: ,p_data => x_msg_data);
529: raise;
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
531: --rollback;
532: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
533: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
534: ,p_data => x_msg_data);
535: raise;
536: WHEN OTHERS THEN

Line 538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 583: WHEN FND_API.G_EXC_ERROR THEN

579: ) ;
580:
581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO BSCLockAsgnMeasurePUB;
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);

Line 585: x_return_status := FND_API.G_RET_STS_ERROR;

581:
582: EXCEPTION
583: WHEN FND_API.G_EXC_ERROR THEN
584: ROLLBACK TO BSCLockAsgnMeasurePUB;
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: raise;
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 589: WHEN FND_API.G_EXC_UNEXPECTED_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: raise;
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO BSCLockAsgnMeasurePUB;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
593: ,p_data => x_msg_data);

Line 591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

587: ,p_data => x_msg_data);
588: raise;
589: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
590: ROLLBACK TO BSCLockAsgnMeasurePUB;
591: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
593: ,p_data => x_msg_data);
594: raise;
595: WHEN OTHERS THEN

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: ,p_data => x_msg_data);
594: raise;
595: WHEN OTHERS THEN
596: ROLLBACK TO BSCLockAsgnMeasurePUB;
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: raise;
601: end LOCK_ASSIGN_MEASURE;

Line 627: WHEN FND_API.G_EXC_ERROR THEN

623: ,x_msg_data
624: );
625:
626: EXCEPTION
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO BSCLockDimObjPUB;
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);

Line 629: x_return_status := FND_API.G_RET_STS_ERROR;

625:
626: EXCEPTION
627: WHEN FND_API.G_EXC_ERROR THEN
628: ROLLBACK TO BSCLockDimObjPUB;
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: raise;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 633: WHEN FND_API.G_EXC_UNEXPECTED_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: raise;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO BSCLockDimObjPUB;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
637: ,p_data => x_msg_data);

Line 635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: ,p_data => x_msg_data);
632: raise;
633: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
634: ROLLBACK TO BSCLockDimObjPUB;
635: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
637: ,p_data => x_msg_data);
638: raise;
639: WHEN OTHERS THEN

Line 641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

637: ,p_data => x_msg_data);
638: raise;
639: WHEN OTHERS THEN
640: ROLLBACK TO BSCLockDimObjPUB;
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: raise;
645: end LOCK_DIM_LEVEL;

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670:
671: );
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO BSCLockDimPUB;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
678: ,p_data => x_msg_data);

Line 676: x_return_status := FND_API.G_RET_STS_ERROR;

672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ROLLBACK TO BSCLockDimPUB;
676: x_return_status := FND_API.G_RET_STS_ERROR;
677: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: raise;
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

676: x_return_status := FND_API.G_RET_STS_ERROR;
677: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
678: ,p_data => x_msg_data);
679: raise;
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO BSCLockDimPUB;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
684: ,p_data => x_msg_data);

Line 682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

678: ,p_data => x_msg_data);
679: raise;
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: ROLLBACK TO BSCLockDimPUB;
682: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
683: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
684: ,p_data => x_msg_data);
685: raise;
686: WHEN OTHERS THEN

Line 688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

684: ,p_data => x_msg_data);
685: raise;
686: WHEN OTHERS THEN
687: ROLLBACK TO BSCLockDimPUB;
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
690: ,p_data => x_msg_data);
691: raise;
692: end LOCK_DIM_GROUP;

Line 722: WHEN FND_API.G_EXC_ERROR THEN

718: ,x_msg_data
719: );
720:
721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO BSCLockDimSetPUB;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
726: ,p_data => x_msg_data);

Line 724: x_return_status := FND_API.G_RET_STS_ERROR;

720:
721: EXCEPTION
722: WHEN FND_API.G_EXC_ERROR THEN
723: ROLLBACK TO BSCLockDimSetPUB;
724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
726: ,p_data => x_msg_data);
727: raise;
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

724: x_return_status := FND_API.G_RET_STS_ERROR;
725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
726: ,p_data => x_msg_data);
727: raise;
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO BSCLockDimSetPUB;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
732: ,p_data => x_msg_data);

Line 730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

726: ,p_data => x_msg_data);
727: raise;
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: ROLLBACK TO BSCLockDimSetPUB;
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
732: ,p_data => x_msg_data);
733: raise;
734: WHEN OTHERS THEN

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732: ,p_data => x_msg_data);
733: raise;
734: WHEN OTHERS THEN
735: ROLLBACK TO BSCLockDimSetPUB;
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
738: ,p_data => x_msg_data);
739: raise;
740: end LOCK_DIM_SET;

Line 748: ,p_full_lock_flag IN varchar2 /:= FND_API.G_FALSE /

744: -------------------------------------------------------------------------------------------------------------------*/
745: Procedure LOCK_KPI(
746: p_kpi_Id IN number
747: ,p_time_stamp IN varchar2 /* := null */
748: ,p_full_lock_flag IN varchar2 /*:= FND_API.G_FALSE */
749: ,x_return_status OUT NOCOPY varchar2
750: ,x_msg_count OUT NOCOPY number
751: ,x_msg_data OUT NOCOPY varchar2
752: ) is

Line 769: WHEN FND_API.G_EXC_ERROR THEN

765: ,x_msg_data
766: );
767:
768: EXCEPTION
769: WHEN FND_API.G_EXC_ERROR THEN
770: ROLLBACK TO BSCLockKpiPUB;
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
773: ,p_data => x_msg_data);

Line 771: x_return_status := FND_API.G_RET_STS_ERROR;

767:
768: EXCEPTION
769: WHEN FND_API.G_EXC_ERROR THEN
770: ROLLBACK TO BSCLockKpiPUB;
771: x_return_status := FND_API.G_RET_STS_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
773: ,p_data => x_msg_data);
774: raise;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

771: x_return_status := FND_API.G_RET_STS_ERROR;
772: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
773: ,p_data => x_msg_data);
774: raise;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO BSCLockKpiPUB;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
779: ,p_data => x_msg_data);

Line 777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

773: ,p_data => x_msg_data);
774: raise;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO BSCLockKpiPUB;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
779: ,p_data => x_msg_data);
780: raise;
781: WHEN OTHERS THEN

Line 783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

779: ,p_data => x_msg_data);
780: raise;
781: WHEN OTHERS THEN
782: ROLLBACK TO BSCLockKpiPUB;
783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
785: ,p_data => x_msg_data);
786: raise;
787: End LOCK_KPI;

Line 861: WHEN FND_API.G_EXC_ERROR THEN

857: ,x_msg_data
858: );
859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: ROLLBACK TO BSCSetTimeDimObjPUB;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
865: ,p_data => x_msg_data);

Line 863: x_return_status := FND_API.G_RET_STS_ERROR;

859:
860: EXCEPTION
861: WHEN FND_API.G_EXC_ERROR THEN
862: ROLLBACK TO BSCSetTimeDimObjPUB;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
865: ,p_data => x_msg_data);
866: raise;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

863: x_return_status := FND_API.G_RET_STS_ERROR;
864: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
865: ,p_data => x_msg_data);
866: raise;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO BSCSetTimeDimObjPUB;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
871: ,p_data => x_msg_data);

Line 869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

865: ,p_data => x_msg_data);
866: raise;
867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
868: ROLLBACK TO BSCSetTimeDimObjPUB;
869: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
870: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
871: ,p_data => x_msg_data);
872: raise;
873: WHEN OTHERS THEN

Line 875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

871: ,p_data => x_msg_data);
872: raise;
873: WHEN OTHERS THEN
874: ROLLBACK TO BSCSetTimeDimObjPUB;
875: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
876: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
877: ,p_data => x_msg_data);
878: raise;
879: end SET_TIME_STAMP_DIM_LEVEL;

Line 902: WHEN FND_API.G_EXC_ERROR THEN

898: ,x_msg_data
899: ) ;
900:
901: EXCEPTION
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO BSCSetTimeDimPUB;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
906: ,p_data => x_msg_data);

Line 904: x_return_status := FND_API.G_RET_STS_ERROR;

900:
901: EXCEPTION
902: WHEN FND_API.G_EXC_ERROR THEN
903: ROLLBACK TO BSCSetTimeDimPUB;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
906: ,p_data => x_msg_data);
907: raise;
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
906: ,p_data => x_msg_data);
907: raise;
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ROLLBACK TO BSCSetTimeDimPUB;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
912: ,p_data => x_msg_data);

Line 910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: ,p_data => x_msg_data);
907: raise;
908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
909: ROLLBACK TO BSCSetTimeDimPUB;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
912: ,p_data => x_msg_data);
913: raise;
914: WHEN OTHERS THEN

Line 916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

912: ,p_data => x_msg_data);
913: raise;
914: WHEN OTHERS THEN
915: ROLLBACK TO BSCSetTimeDimPUB;
916: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
917: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
918: ,p_data => x_msg_data);
919: raise;
920: end SET_TIME_STAMP_DIM_GROUP;

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941: ,x_msg_data
942: ) ;
943:
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO BSCSetTimeDimSetPUB;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
949: ,p_data => x_msg_data);

Line 947: x_return_status := FND_API.G_RET_STS_ERROR;

943:
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO BSCSetTimeDimSetPUB;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
949: ,p_data => x_msg_data);
950: raise;
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

947: x_return_status := FND_API.G_RET_STS_ERROR;
948: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
949: ,p_data => x_msg_data);
950: raise;
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: ROLLBACK TO BSCSetTimeDimSetPUB;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
955: ,p_data => x_msg_data);

Line 953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

949: ,p_data => x_msg_data);
950: raise;
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: ROLLBACK TO BSCSetTimeDimSetPUB;
953: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
954: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
955: ,p_data => x_msg_data);
956: raise;
957: WHEN OTHERS THEN

Line 959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

955: ,p_data => x_msg_data);
956: raise;
957: WHEN OTHERS THEN
958: ROLLBACK TO BSCSetTimeDimSetPUB;
959: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
960: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
961: ,p_data => x_msg_data);
962: raise;
963: end SET_TIME_STAMP_DIM_SET;

Line 986: WHEN FND_API.G_EXC_ERROR THEN

982: ,x_msg_data
983: );
984:
985: EXCEPTION
986: WHEN FND_API.G_EXC_ERROR THEN
987: ROLLBACK TO BSCSetTimeKpiPUB;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
990: ,p_data => x_msg_data);

Line 988: x_return_status := FND_API.G_RET_STS_ERROR;

984:
985: EXCEPTION
986: WHEN FND_API.G_EXC_ERROR THEN
987: ROLLBACK TO BSCSetTimeKpiPUB;
988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
990: ,p_data => x_msg_data);
991: raise;
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

988: x_return_status := FND_API.G_RET_STS_ERROR;
989: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
990: ,p_data => x_msg_data);
991: raise;
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO BSCSetTimeKpiPUB;
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
996: ,p_data => x_msg_data);

Line 994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

990: ,p_data => x_msg_data);
991: raise;
992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
993: ROLLBACK TO BSCSetTimeKpiPUB;
994: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
995: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
996: ,p_data => x_msg_data);
997: raise;
998: WHEN OTHERS THEN

Line 1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

996: ,p_data => x_msg_data);
997: raise;
998: WHEN OTHERS THEN
999: ROLLBACK TO BSCSetTimeKpiPUB;
1000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1001: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1002: ,p_data => x_msg_data);
1003: raise;
1004: end SET_TIME_STAMP_KPI;

Line 1035: WHEN FND_API.G_EXC_ERROR THEN

1031: ,x_msg_data
1032: );
1033:
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO BSCLockCreDimPUB;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1039: ,p_data => x_msg_data);

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR;

1033:
1034: EXCEPTION
1035: WHEN FND_API.G_EXC_ERROR THEN
1036: ROLLBACK TO BSCLockCreDimPUB;
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1039: ,p_data => x_msg_data);
1040: raise;
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1039: ,p_data => x_msg_data);
1040: raise;
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO BSCLockCreDimPUB;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1045: ,p_data => x_msg_data);

Line 1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1039: ,p_data => x_msg_data);
1040: raise;
1041: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1042: ROLLBACK TO BSCLockCreDimPUB;
1043: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1044: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1045: ,p_data => x_msg_data);
1046: raise;
1047: WHEN OTHERS THEN

Line 1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1045: ,p_data => x_msg_data);
1046: raise;
1047: WHEN OTHERS THEN
1048: ROLLBACK TO BSCLockCreDimPUB;
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1051: ,p_data => x_msg_data);
1052: raise;
1053:

Line 1094: WHEN FND_API.G_EXC_ERROR THEN

1090: ,x_msg_data
1091: ) ;
1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: ROLLBACK TO BSCLockUpdDimPUB;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1098: ,p_data => x_msg_data);

Line 1096: x_return_status := FND_API.G_RET_STS_ERROR;

1092:
1093: EXCEPTION
1094: WHEN FND_API.G_EXC_ERROR THEN
1095: ROLLBACK TO BSCLockUpdDimPUB;
1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1098: ,p_data => x_msg_data);
1099: raise;
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1096: x_return_status := FND_API.G_RET_STS_ERROR;
1097: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1098: ,p_data => x_msg_data);
1099: raise;
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: ROLLBACK TO BSCLockUpdDimPUB;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1104: ,p_data => x_msg_data);

Line 1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1098: ,p_data => x_msg_data);
1099: raise;
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: ROLLBACK TO BSCLockUpdDimPUB;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1104: ,p_data => x_msg_data);
1105: raise;
1106: WHEN OTHERS THEN

Line 1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1104: ,p_data => x_msg_data);
1105: raise;
1106: WHEN OTHERS THEN
1107: ROLLBACK TO BSCLockUpdDimPUB;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1110: ,p_data => x_msg_data);
1111: raise;
1112: end LOCK_UPDATE_DIMENSION;

Line 1144: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1146: x_return_status := FND_API.G_RET_STS_ERROR;

1142:
1143: EXCEPTION
1144: WHEN FND_API.G_EXC_ERROR THEN
1145: ROLLBACK TO BSCLockUpdDimInObjPUB;
1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1148: ,p_data => x_msg_data);
1149: raise;
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: x_return_status := FND_API.G_RET_STS_ERROR;
1147: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1148: ,p_data => x_msg_data);
1149: raise;
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151: ROLLBACK TO BSCLockUpdDimInObjPUB;
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1154: ,p_data => x_msg_data);

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1154: ,p_data => x_msg_data);
1155: raise;
1156: WHEN OTHERS THEN
1157: ROLLBACK TO BSCLockUpdDimInObjPUB;
1158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1159: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1160: ,p_data => x_msg_data);
1161: raise;
1162: End LOCK_UPDATE_DIM_OBJ_IN_DIM;

Line 1192: WHEN FND_API.G_EXC_ERROR THEN

1188: ,x_msg_count
1189: ,x_msg_data
1190: ) ;
1191: EXCEPTION
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: ROLLBACK TO BSCLockCreDimObjPUB;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1196: ,p_data => x_msg_data);

Line 1194: x_return_status := FND_API.G_RET_STS_ERROR;

1190: ) ;
1191: EXCEPTION
1192: WHEN FND_API.G_EXC_ERROR THEN
1193: ROLLBACK TO BSCLockCreDimObjPUB;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1196: ,p_data => x_msg_data);
1197: raise;
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1196: ,p_data => x_msg_data);
1197: raise;
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO BSCLockCreDimObjPUB;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1202: ,p_data => x_msg_data);

Line 1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1196: ,p_data => x_msg_data);
1197: raise;
1198: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1199: ROLLBACK TO BSCLockCreDimObjPUB;
1200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1201: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1202: ,p_data => x_msg_data);
1203: raise;
1204: WHEN OTHERS THEN

Line 1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1202: ,p_data => x_msg_data);
1203: raise;
1204: WHEN OTHERS THEN
1205: ROLLBACK TO BSCLockCreDimObjPUB;
1206: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1207: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1208: ,p_data => x_msg_data);
1209: raise;
1210:

Line 1248: WHEN FND_API.G_EXC_ERROR THEN

1244: ,x_msg_count
1245: ,x_msg_data
1246: ) ;
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO BSCLockUpdDimObjPUB;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1252: ,p_data => x_msg_data);

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

1246: ) ;
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO BSCLockUpdDimObjPUB;
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1252: ,p_data => x_msg_data);
1253: raise;
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1252: ,p_data => x_msg_data);
1253: raise;
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: ROLLBACK TO BSCLockUpdDimObjPUB;
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1258: ,p_data => x_msg_data);

Line 1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1252: ,p_data => x_msg_data);
1253: raise;
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: ROLLBACK TO BSCLockUpdDimObjPUB;
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1258: ,p_data => x_msg_data);
1259: raise;
1260: WHEN OTHERS THEN

Line 1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1258: ,p_data => x_msg_data);
1259: raise;
1260: WHEN OTHERS THEN
1261: ROLLBACK TO BSCLockUpdDimObjPUB;
1262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1263: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1264: ,p_data => x_msg_data);
1265: raise;
1266:

Line 1306: WHEN FND_API.G_EXC_ERROR THEN

1302: ,x_msg_count
1303: ,x_msg_data
1304: ) ;
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: ROLLBACK TO BSCLockUpdDimRelsPUB;
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1310: ,p_data => x_msg_data);

Line 1308: x_return_status := FND_API.G_RET_STS_ERROR;

1304: ) ;
1305: EXCEPTION
1306: WHEN FND_API.G_EXC_ERROR THEN
1307: ROLLBACK TO BSCLockUpdDimRelsPUB;
1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1310: ,p_data => x_msg_data);
1311: raise;
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1308: x_return_status := FND_API.G_RET_STS_ERROR;
1309: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1310: ,p_data => x_msg_data);
1311: raise;
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1313: ROLLBACK TO BSCLockUpdDimRelsPUB;
1314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1315: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1316: ,p_data => x_msg_data);

Line 1314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1310: ,p_data => x_msg_data);
1311: raise;
1312: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1313: ROLLBACK TO BSCLockUpdDimRelsPUB;
1314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1315: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1316: ,p_data => x_msg_data);
1317: raise;
1318: WHEN OTHERS THEN

Line 1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1316: ,p_data => x_msg_data);
1317: raise;
1318: WHEN OTHERS THEN
1319: ROLLBACK TO BSCLockUpdDimRelsPUB;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1321: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1322: ,p_data => x_msg_data);
1323: raise;
1324:

Line 1370: WHEN FND_API.G_EXC_ERROR THEN

1366: ,x_msg_count
1367: ,x_msg_data
1368: ) ;
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK TO BSCLockAsgnDimSetPUB;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1374: ,p_data => x_msg_data);

Line 1372: x_return_status := FND_API.G_RET_STS_ERROR;

1368: ) ;
1369: EXCEPTION
1370: WHEN FND_API.G_EXC_ERROR THEN
1371: ROLLBACK TO BSCLockAsgnDimSetPUB;
1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1374: ,p_data => x_msg_data);
1375: raise;
1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1372: x_return_status := FND_API.G_RET_STS_ERROR;
1373: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1374: ,p_data => x_msg_data);
1375: raise;
1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1377: ROLLBACK TO BSCLockAsgnDimSetPUB;
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1380: ,p_data => x_msg_data);

Line 1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1374: ,p_data => x_msg_data);
1375: raise;
1376: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1377: ROLLBACK TO BSCLockAsgnDimSetPUB;
1378: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1379: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1380: ,p_data => x_msg_data);
1381: raise;
1382: WHEN OTHERS THEN

Line 1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1380: ,p_data => x_msg_data);
1381: raise;
1382: WHEN OTHERS THEN
1383: ROLLBACK TO BSCLockAsgnDimSetPUB;
1384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1385: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1386: ,p_data => x_msg_data);
1387: raise;
1388: end LOCK_ASSIGN_DIM_SET;

Line 1422: WHEN FND_API.G_EXC_ERROR THEN

1418:
1419: );
1420:
1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1425: ,p_data => x_msg_data);
1426: RAISE;

Line 1423: x_return_status := FND_API.G_RET_STS_ERROR;

1419: );
1420:
1421: EXCEPTION
1422: WHEN FND_API.G_EXC_ERROR THEN
1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1425: ,p_data => x_msg_data);
1426: RAISE;
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1423: x_return_status := FND_API.G_RET_STS_ERROR;
1424: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1425: ,p_data => x_msg_data);
1426: RAISE;
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: RAISE;

Line 1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1424: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1425: ,p_data => x_msg_data);
1426: RAISE;
1427: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1429: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: RAISE;
1432: WHEN OTHERS THEN

Line 1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1429: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1430: ,p_data => x_msg_data);
1431: RAISE;
1432: WHEN OTHERS THEN
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1434: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1435: ,p_data => x_msg_data);
1436: RAISE;
1437:

Line 1458: x_return_status := FND_API.G_RET_STS_SUCCESS;

1454: ,x_msg_data OUT NOCOPY VARCHAR2
1455: )IS
1456: BEGIN
1457: FND_MSG_PUB.Initialize;
1458: x_return_status := FND_API.G_RET_STS_SUCCESS;
1459:
1460: BSC_BIS_LOCKS_PVT.LOCK_TAB
1461: (
1462: p_tab_id => p_tab_id

Line 1471: WHEN FND_API.G_EXC_ERROR THEN

1467:
1468: );
1469:
1470: EXCEPTION
1471: WHEN FND_API.G_EXC_ERROR THEN
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475: RAISE;

Line 1472: x_return_status := FND_API.G_RET_STS_ERROR;

1468: );
1469:
1470: EXCEPTION
1471: WHEN FND_API.G_EXC_ERROR THEN
1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475: RAISE;
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1472: x_return_status := FND_API.G_RET_STS_ERROR;
1473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475: RAISE;
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1479: ,p_data => x_msg_data);
1480: RAISE;

Line 1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1474: ,p_data => x_msg_data);
1475: RAISE;
1476: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1478: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1479: ,p_data => x_msg_data);
1480: RAISE;
1481: WHEN OTHERS THEN

Line 1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1478: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1479: ,p_data => x_msg_data);
1480: RAISE;
1481: WHEN OTHERS THEN
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1483: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count
1484: ,p_data => x_msg_data);
1485: RAISE;
1486: END LOCK_TAB;

Line 1513: RAISE FND_API.G_EXC_ERROR;

1509: FND_MESSAGE.SET_TOKEN('MACHINE' ,p_Machine , TRUE);
1510: FND_MESSAGE.SET_TOKEN('TERMINAL' ,p_Terminal, TRUE);
1511: FND_MSG_PUB.ADD;
1512: --DBMS_OUTPUT.PUT_LINE('if loop:- ' ||cd.program_id);
1513: RAISE FND_API.G_EXC_ERROR;
1514: END;
1515:
1516: /***********************************************************************
1517: Name :- Lock_Designer_Session_AT

Line 1555: x_return_status := FND_API.G_RET_STS_SUCCESS;

1551: l_sql VARCHAR2(8000);
1552:
1553: BEGIN
1554: FND_MSG_PUB.Initialize;
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556: -- First we need to delete the orphan sessions
1557: --Delete all orphan the sessions
1558: DELETE BSC_CURRENT_SESSIONS
1559: WHERE SESSION_ID NOT IN

Line 1672: WHEN FND_API.G_EXC_ERROR THEN

1668: );
1669: --DBMS_OUTPUT.PUT_LINE('the session id is :- '||USERENV('SESSIONID'));
1670: COMMIT;
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: IF (x_msg_data IS NULL) THEN
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_encoded => FND_API.G_FALSE
1676: , p_count => x_msg_count

Line 1675: ( p_encoded => FND_API.G_FALSE

1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: IF (x_msg_data IS NULL) THEN
1674: FND_MSG_PUB.Count_And_Get
1675: ( p_encoded => FND_API.G_FALSE
1676: , p_count => x_msg_count
1677: , p_data => x_msg_data
1678: );
1679: END IF;

Line 1680: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);

1676: , p_count => x_msg_count
1677: , p_data => x_msg_data
1678: );
1679: END IF;
1680: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: IF (x_msg_data IS NULL) THEN
1684: FND_MSG_PUB.Count_And_Get

Line 1681: x_return_status := FND_API.G_RET_STS_ERROR;

1677: , p_data => x_msg_data
1678: );
1679: END IF;
1680: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: IF (x_msg_data IS NULL) THEN
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_encoded => FND_API.G_FALSE

Line 1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1678: );
1679: END IF;
1680: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: IF (x_msg_data IS NULL) THEN
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_encoded => FND_API.G_FALSE
1686: , p_count => x_msg_count

Line 1685: ( p_encoded => FND_API.G_FALSE

1681: x_return_status := FND_API.G_RET_STS_ERROR;
1682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1683: IF (x_msg_data IS NULL) THEN
1684: FND_MSG_PUB.Count_And_Get
1685: ( p_encoded => FND_API.G_FALSE
1686: , p_count => x_msg_count
1687: , p_data => x_msg_data
1688: );
1689: END IF;

Line 1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1686: , p_count => x_msg_count
1687: , p_data => x_msg_data
1688: );
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF (x_msg_data IS NOT NULL) THEN

Line 1691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);

1687: , p_data => x_msg_data
1688: );
1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF (x_msg_data IS NOT NULL) THEN
1695: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';

Line 1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1689: END IF;
1690: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1691: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1692: WHEN OTHERS THEN
1693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1694: IF (x_msg_data IS NOT NULL) THEN
1695: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';
1696: ELSE
1697: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Designer_Session_AT ';

Line 1744: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1740: BEGIN
1741: SAVEPOINT LockUpdateCalendarPUB;
1742: FND_MSG_PUB.Initialize;
1743:
1744: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1745:
1746: BSC_BIS_LOCKS_PVT.Lock_Calendar (
1747: p_Calendar_Id => p_Calendar_Id
1748: , p_Time_Stamp => p_Time_Stamp

Line 1753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1749: , x_Return_Status => x_Return_Status
1750: , x_Msg_Count => x_Msg_Count
1751: , x_Msg_Data => x_Msg_Data
1752: );
1753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1755: END IF;
1756:
1757: FOR cPerIds IN c_Periodicity_Ids LOOP

Line 1754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1750: , x_Msg_Count => x_Msg_Count
1751: , x_Msg_Data => x_Msg_Data
1752: );
1753: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1755: END IF;
1756:
1757: FOR cPerIds IN c_Periodicity_Ids LOOP
1758: BSC_BIS_LOCKS_PVT.Lock_Periodicity (

Line 1765: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1761: , x_Return_Status => x_Return_Status
1762: , x_Msg_Count => x_Msg_Count
1763: , x_Msg_Data => x_Msg_Data
1764: );
1765: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1767: END IF;
1768: END LOOP;
1769:

Line 1766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1762: , x_Msg_Count => x_Msg_Count
1763: , x_Msg_Data => x_Msg_Data
1764: );
1765: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1767: END IF;
1768: END LOOP;
1769:
1770: EXCEPTION

Line 1771: WHEN FND_API.G_EXC_ERROR THEN

1767: END IF;
1768: END LOOP;
1769:
1770: EXCEPTION
1771: WHEN FND_API.G_EXC_ERROR THEN
1772: ROLLBACK TO LockUpdateCalendarPUB;
1773: IF (x_msg_data IS NULL) THEN
1774: FND_MSG_PUB.Count_And_Get
1775: ( p_encoded => FND_API.G_FALSE

Line 1775: ( p_encoded => FND_API.G_FALSE

1771: WHEN FND_API.G_EXC_ERROR THEN
1772: ROLLBACK TO LockUpdateCalendarPUB;
1773: IF (x_msg_data IS NULL) THEN
1774: FND_MSG_PUB.Count_And_Get
1775: ( p_encoded => FND_API.G_FALSE
1776: , p_count => x_msg_count
1777: , p_data => x_msg_data
1778: );
1779: END IF;

Line 1780: x_Return_Status := FND_API.G_RET_STS_ERROR;

1776: , p_count => x_msg_count
1777: , p_data => x_msg_data
1778: );
1779: END IF;
1780: x_Return_Status := FND_API.G_RET_STS_ERROR;
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO LockUpdateCalendarPUB;
1783: IF (x_msg_data IS NULL) THEN
1784: FND_MSG_PUB.Count_And_Get

Line 1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1777: , p_data => x_msg_data
1778: );
1779: END IF;
1780: x_Return_Status := FND_API.G_RET_STS_ERROR;
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO LockUpdateCalendarPUB;
1783: IF (x_msg_data IS NULL) THEN
1784: FND_MSG_PUB.Count_And_Get
1785: ( p_encoded => FND_API.G_FALSE

Line 1785: ( p_encoded => FND_API.G_FALSE

1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO LockUpdateCalendarPUB;
1783: IF (x_msg_data IS NULL) THEN
1784: FND_MSG_PUB.Count_And_Get
1785: ( p_encoded => FND_API.G_FALSE
1786: , p_count => x_msg_count
1787: , p_data => x_msg_data
1788: );
1789: END IF;

Line 1790: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1786: , p_count => x_msg_count
1787: , p_data => x_msg_data
1788: );
1789: END IF;
1790: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: WHEN NO_DATA_FOUND THEN
1792: ROLLBACK TO LockUpdateCalendarPUB;
1793: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF (x_msg_data IS NOT NULL) THEN

Line 1793: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1789: END IF;
1790: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: WHEN NO_DATA_FOUND THEN
1792: ROLLBACK TO LockUpdateCalendarPUB;
1793: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1794: IF (x_msg_data IS NOT NULL) THEN
1795: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1796: ELSE
1797: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

Line 1801: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1797: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1798: END IF;
1799: WHEN OTHERS THEN
1800: ROLLBACK TO LockUpdateCalendarPUB;
1801: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1802: IF (x_msg_data IS NOT NULL) THEN
1803: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';
1804: ELSE
1805: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar_And_Periods ';

Line 1821: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1817: BEGIN
1818: SAVEPOINT LockCalendarPUB;
1819: FND_MSG_PUB.Initialize;
1820:
1821: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1822:
1823: BSC_BIS_LOCKS_PVT.Lock_Calendar (
1824: p_Calendar_Id => p_Calendar_Id
1825: , p_Time_Stamp => p_Time_Stamp

Line 1830: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1826: , x_Return_Status => x_Return_Status
1827: , x_Msg_Count => x_Msg_Count
1828: , x_Msg_Data => x_Msg_Data
1829: );
1830: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: EXCEPTION

Line 1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1827: , x_Msg_Count => x_Msg_Count
1828: , x_Msg_Data => x_Msg_Data
1829: );
1830: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN

Line 1835: WHEN FND_API.G_EXC_ERROR THEN

1831: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1832: END IF;
1833:
1834: EXCEPTION
1835: WHEN FND_API.G_EXC_ERROR THEN
1836: ROLLBACK TO LockCalendarPUB;
1837: IF (x_msg_data IS NULL) THEN
1838: FND_MSG_PUB.Count_And_Get
1839: ( p_encoded => FND_API.G_FALSE

Line 1839: ( p_encoded => FND_API.G_FALSE

1835: WHEN FND_API.G_EXC_ERROR THEN
1836: ROLLBACK TO LockCalendarPUB;
1837: IF (x_msg_data IS NULL) THEN
1838: FND_MSG_PUB.Count_And_Get
1839: ( p_encoded => FND_API.G_FALSE
1840: , p_count => x_msg_count
1841: , p_data => x_msg_data
1842: );
1843: END IF;

Line 1844: x_Return_Status := FND_API.G_RET_STS_ERROR;

1840: , p_count => x_msg_count
1841: , p_data => x_msg_data
1842: );
1843: END IF;
1844: x_Return_Status := FND_API.G_RET_STS_ERROR;
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: ROLLBACK TO LockCalendarPUB;
1847: IF (x_msg_data IS NULL) THEN
1848: FND_MSG_PUB.Count_And_Get

Line 1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1841: , p_data => x_msg_data
1842: );
1843: END IF;
1844: x_Return_Status := FND_API.G_RET_STS_ERROR;
1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: ROLLBACK TO LockCalendarPUB;
1847: IF (x_msg_data IS NULL) THEN
1848: FND_MSG_PUB.Count_And_Get
1849: ( p_encoded => FND_API.G_FALSE

Line 1849: ( p_encoded => FND_API.G_FALSE

1845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1846: ROLLBACK TO LockCalendarPUB;
1847: IF (x_msg_data IS NULL) THEN
1848: FND_MSG_PUB.Count_And_Get
1849: ( p_encoded => FND_API.G_FALSE
1850: , p_count => x_msg_count
1851: , p_data => x_msg_data
1852: );
1853: END IF;

Line 1854: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1850: , p_count => x_msg_count
1851: , p_data => x_msg_data
1852: );
1853: END IF;
1854: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1855: WHEN NO_DATA_FOUND THEN
1856: ROLLBACK TO LockCalendarPUB;
1857: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF (x_msg_data IS NOT NULL) THEN

Line 1857: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1853: END IF;
1854: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1855: WHEN NO_DATA_FOUND THEN
1856: ROLLBACK TO LockCalendarPUB;
1857: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1858: IF (x_msg_data IS NOT NULL) THEN
1859: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1860: ELSE
1861: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';

Line 1865: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1861: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1862: END IF;
1863: WHEN OTHERS THEN
1864: ROLLBACK TO LockCalendarPUB;
1865: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1866: IF (x_msg_data IS NOT NULL) THEN
1867: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Calendar ';
1868: ELSE
1869: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Calendar ';

Line 1885: x_Return_Status := FND_API.G_RET_STS_SUCCESS;

1881: BEGIN
1882: SAVEPOINT LockPeriodicityPUB;
1883: FND_MSG_PUB.Initialize;
1884:
1885: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1886:
1887: BSC_BIS_LOCKS_PVT.Lock_Periodicity (
1888: p_Periodicity_Id => p_Periodicity_Id
1889: , p_Time_Stamp => p_Time_Stamp

Line 1894: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1890: , x_Return_Status => x_Return_Status
1891: , x_Msg_Count => x_Msg_Count
1892: , x_Msg_Data => x_Msg_Data
1893: );
1894: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896: END IF;
1897: EXCEPTION
1898: WHEN FND_API.G_EXC_ERROR THEN

Line 1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1891: , x_Msg_Count => x_Msg_Count
1892: , x_Msg_Data => x_Msg_Data
1893: );
1894: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896: END IF;
1897: EXCEPTION
1898: WHEN FND_API.G_EXC_ERROR THEN
1899: ROLLBACK TO LockPeriodicityPUB;

Line 1898: WHEN FND_API.G_EXC_ERROR THEN

1894: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1895: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1896: END IF;
1897: EXCEPTION
1898: WHEN FND_API.G_EXC_ERROR THEN
1899: ROLLBACK TO LockPeriodicityPUB;
1900: IF (x_msg_data IS NULL) THEN
1901: FND_MSG_PUB.Count_And_Get
1902: ( p_encoded => FND_API.G_FALSE

Line 1902: ( p_encoded => FND_API.G_FALSE

1898: WHEN FND_API.G_EXC_ERROR THEN
1899: ROLLBACK TO LockPeriodicityPUB;
1900: IF (x_msg_data IS NULL) THEN
1901: FND_MSG_PUB.Count_And_Get
1902: ( p_encoded => FND_API.G_FALSE
1903: , p_count => x_msg_count
1904: , p_data => x_msg_data
1905: );
1906: END IF;

Line 1907: x_Return_Status := FND_API.G_RET_STS_ERROR;

1903: , p_count => x_msg_count
1904: , p_data => x_msg_data
1905: );
1906: END IF;
1907: x_Return_Status := FND_API.G_RET_STS_ERROR;
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO LockPeriodicityPUB;
1910: IF (x_msg_data IS NULL) THEN
1911: FND_MSG_PUB.Count_And_Get

Line 1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1904: , p_data => x_msg_data
1905: );
1906: END IF;
1907: x_Return_Status := FND_API.G_RET_STS_ERROR;
1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO LockPeriodicityPUB;
1910: IF (x_msg_data IS NULL) THEN
1911: FND_MSG_PUB.Count_And_Get
1912: ( p_encoded => FND_API.G_FALSE

Line 1912: ( p_encoded => FND_API.G_FALSE

1908: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1909: ROLLBACK TO LockPeriodicityPUB;
1910: IF (x_msg_data IS NULL) THEN
1911: FND_MSG_PUB.Count_And_Get
1912: ( p_encoded => FND_API.G_FALSE
1913: , p_count => x_msg_count
1914: , p_data => x_msg_data
1915: );
1916: END IF;

Line 1917: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1913: , p_count => x_msg_count
1914: , p_data => x_msg_data
1915: );
1916: END IF;
1917: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: WHEN NO_DATA_FOUND THEN
1919: ROLLBACK TO LockPeriodicityPUB;
1920: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF (x_msg_data IS NOT NULL) THEN

Line 1920: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1916: END IF;
1917: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1918: WHEN NO_DATA_FOUND THEN
1919: ROLLBACK TO LockPeriodicityPUB;
1920: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1921: IF (x_msg_data IS NOT NULL) THEN
1922: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1923: ELSE
1924: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';

Line 1928: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

1924: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1925: END IF;
1926: WHEN OTHERS THEN
1927: ROLLBACK TO LockPeriodicityPUB;
1928: x_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
1929: IF (x_msg_data IS NOT NULL) THEN
1930: x_msg_data := x_msg_data||' -> BSC_BIS_LOCKS_PUB.Lock_Periodicity ';
1931: ELSE
1932: x_msg_data := SQLERRM||' at BSC_BIS_LOCKS_PUB.Lock_Periodicity ';