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_MSG_PUB

Line 57: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
61: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );

Line 64: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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 ' );
68: ROLLBACK TO BSCSetTimeDataSetPUB;

Line 70: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
74:

Line 151: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
155: --dbms_output.put_line(' G_EXC_UNEXPECTED_ERROR ' );

Line 158: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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 ' );
162: ROLLBACK TO BSCSetTimeDataSetPUB;

Line 164: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
168:

Line 194: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
198: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 199: 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;
203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 204: 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;
208:

Line 235: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 240: 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;
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 245: 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;
249: /*------------------------------------------------------------------------------------------

Line 355: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
359: ROLLBACK TO BSCLockDataSetPUB;

Line 361: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
365: ROLLBACK TO BSCLockDataSetPUB;

Line 367: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
371:

Line 401: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
405: ROLLBACK TO BSCLockDataSrcPUB;

Line 407: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
411: ROLLBACK TO BSCLockDataSrcPUB;

Line 413: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
417:

Line 443: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
447: rollback;

Line 449: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
453: rollback;

Line 455: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
459: */

Line 486: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
490: --rollback;

Line 492: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
496: --rollback;

Line 498: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
502: /*------------------------------------------------------------------------------------------

Line 527: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
531: --rollback;

Line 533: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
537: --rollback;

Line 539: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
543: /*------------------------------------------------------------------------------------------

Line 586: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
590: ROLLBACK TO BSCLockAsgnMeasurePUB;

Line 592: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
596: ROLLBACK TO BSCLockAsgnMeasurePUB;

Line 598: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
602: /*-------------------------------------------------------------------------------------------------------------------

Line 630: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
634: ROLLBACK TO BSCLockDimObjPUB;

Line 636: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
640: ROLLBACK TO BSCLockDimObjPUB;

Line 642: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
646:

Line 677: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
681: ROLLBACK TO BSCLockDimPUB;

Line 683: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
687: ROLLBACK TO BSCLockDimPUB;

Line 689: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
693:

Line 725: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
729: ROLLBACK TO BSCLockDimSetPUB;

Line 731: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
735: ROLLBACK TO BSCLockDimSetPUB;

Line 737: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
741:

Line 772: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
776: ROLLBACK TO BSCLockKpiPUB;

Line 778: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
782: ROLLBACK TO BSCLockKpiPUB;

Line 784: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
788: /*------------------------------------------------------------------------------------------

Line 864: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
868: ROLLBACK TO BSCSetTimeDimObjPUB;

Line 870: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
874: ROLLBACK TO BSCSetTimeDimObjPUB;

Line 876: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
880: /*------------------------------------------------------------------------------------------

Line 905: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
909: ROLLBACK TO BSCSetTimeDimPUB;

Line 911: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
915: ROLLBACK TO BSCSetTimeDimPUB;

Line 917: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
921: /*------------------------------------------------------------------------------------------

Line 948: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
952: ROLLBACK TO BSCSetTimeDimSetPUB;

Line 954: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
958: ROLLBACK TO BSCSetTimeDimSetPUB;

Line 960: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
964: /*------------------------------------------------------------------------------------------

Line 989: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
993: ROLLBACK TO BSCSetTimeKpiPUB;

Line 995: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
999: ROLLBACK TO BSCSetTimeKpiPUB;

Line 1001: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1005:

Line 1038: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1042: ROLLBACK TO BSCLockCreDimPUB;

Line 1044: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1048: ROLLBACK TO BSCLockCreDimPUB;

Line 1050: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1054: end LOCK_CREATE_DIMENSION;

Line 1097: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1101: ROLLBACK TO BSCLockUpdDimPUB;

Line 1103: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1107: ROLLBACK TO BSCLockUpdDimPUB;

Line 1109: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1113:

Line 1147: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1151: ROLLBACK TO BSCLockUpdDimInObjPUB;

Line 1153: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1157: ROLLBACK TO BSCLockUpdDimInObjPUB;

Line 1159: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1163:

Line 1195: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1199: ROLLBACK TO BSCLockCreDimObjPUB;

Line 1201: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1205: ROLLBACK TO BSCLockCreDimObjPUB;

Line 1207: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1211: End LOCK_CREATE_DIMENSION_OBJECT;

Line 1251: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1255: ROLLBACK TO BSCLockUpdDimObjPUB;

Line 1257: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1261: ROLLBACK TO BSCLockUpdDimObjPUB;

Line 1263: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1267: end LOCK_UPDATE_DIMENSION_OBJECT;

Line 1309: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1313: ROLLBACK TO BSCLockUpdDimRelsPUB;

Line 1315: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1319: ROLLBACK TO BSCLockUpdDimRelsPUB;

Line 1321: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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:
1325: end LOCK_UPDATE_RELATIONSHIPS;

Line 1373: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1377: ROLLBACK TO BSCLockAsgnDimSetPUB;

Line 1379: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1383: ROLLBACK TO BSCLockAsgnDimSetPUB;

Line 1385: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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;
1389:

Line 1424: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1428: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1429: 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
1433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1434: 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:
1438: END LOCK_TAB_VIEW_ID;

Line 1457: FND_MSG_PUB.Initialize;

1453: ,x_msg_count OUT NOCOPY NUMBER
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: (

Line 1473: FND_MSG_PUB.Count_And_Get(p_encoded => 'F' ,p_count => x_msg_count

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
1477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1478: 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
1482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1483: 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;
1487:

Line 1497: FND_MSG_PUB.Initialize;

1493: ) IS
1494: TYPE t_array_varchar2 IS TABLE OF VARCHAR2(500) INDEX BY BINARY_INTEGER;
1495: h_modules t_array_varchar2;
1496: BEGIN
1497: FND_MSG_PUB.Initialize;
1498: h_modules(-100) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader UI
1499: h_modules(-101) := bsc_apps.get_lookup_value('BSC_UI_SETUP', 'BSC_LOADER'); -- Loader concurrent program
1500: h_modules(-200) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER');
1501: h_modules(-201) := bsc_apps.get_lookup_value('BSC_UI_COMMON', 'METADATA_OPTIMIZER'); --Generate documentation

Line 1511: FND_MSG_PUB.ADD;

1507: FND_MESSAGE.SET_TOKEN('COMPONENT',h_modules(p_Program_id) , TRUE);
1508: FND_MESSAGE.SET_TOKEN('USERNAME' ,p_User_Name , TRUE);
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:

Line 1554: FND_MSG_PUB.Initialize;

1550: l_session_ids VARCHAR2(8000);
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

Line 1674: FND_MSG_PUB.Count_And_Get

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
1677: , p_data => x_msg_data
1678: );

Line 1684: FND_MSG_PUB.Count_And_Get

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
1687: , p_data => x_msg_data
1688: );

Line 1742: FND_MSG_PUB.Initialize;

1738: FROM BSC_SYS_PERIODICITIES
1739: WHERE CALENDAR_ID = p_Calendar_Id;
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 (

Line 1774: FND_MSG_PUB.Count_And_Get

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
1776: , p_count => x_msg_count
1777: , p_data => x_msg_data
1778: );

Line 1784: FND_MSG_PUB.Count_And_Get

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
1786: , p_count => x_msg_count
1787: , p_data => x_msg_data
1788: );

Line 1819: FND_MSG_PUB.Initialize;

1815: , x_Msg_Data OUT NOCOPY VARCHAR2
1816: ) IS
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 (

Line 1838: FND_MSG_PUB.Count_And_Get

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
1840: , p_count => x_msg_count
1841: , p_data => x_msg_data
1842: );

Line 1848: FND_MSG_PUB.Count_And_Get

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
1850: , p_count => x_msg_count
1851: , p_data => x_msg_data
1852: );

Line 1883: FND_MSG_PUB.Initialize;

1879: , x_Msg_Data OUT NOCOPY VARCHAR2
1880: ) IS
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 (

Line 1901: FND_MSG_PUB.Count_And_Get

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
1903: , p_count => x_msg_count
1904: , p_data => x_msg_data
1905: );

Line 1911: FND_MSG_PUB.Count_And_Get

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
1913: , p_count => x_msg_count
1914: , p_data => x_msg_data
1915: );