294: -- added exception handler
295: EXCEPTION
296: WHEN OTHERS THEN
297: /* Bug # 4235511 */
298: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_MONTHLY_BUCKETS',SQLERRM);
300: end if ;
301:
302: END ASSIGN_MONTHLY_BUCKETS;
295: EXCEPTION
296: WHEN OTHERS THEN
297: /* Bug # 4235511 */
298: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
299: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_MONTHLY_BUCKETS',SQLERRM);
300: end if ;
301:
302: END ASSIGN_MONTHLY_BUCKETS;
303:
532:
533: -- added exception handler
534: EXCEPTION WHEN OTHERS THEN
535: /* Bug # 4235511 */
536: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
537: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.ASSIGN_WEEKLY_BUCKETS',SQLERRM);
538: end if ;
539:
540: END ASSIGN_WEEKLY_BUCKETS;
533: -- added exception handler
534: EXCEPTION WHEN OTHERS THEN
535: /* Bug # 4235511 */
536: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
537: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.ASSIGN_WEEKLY_BUCKETS',SQLERRM);
538: end if ;
539:
540: END ASSIGN_WEEKLY_BUCKETS;
541:
668:
669: -- added exception handler
670: EXCEPTION WHEN OTHERS THEN
671: /* Bug # 4235511 */
672: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
673: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_DAILY_BUCKETS',SQLERRM);
674: end if ;
675:
676: end ASSIGN_DAILY_BUCKETS;
669: -- added exception handler
670: EXCEPTION WHEN OTHERS THEN
671: /* Bug # 4235511 */
672: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
673: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_DAILY_BUCKETS',SQLERRM);
674: end if ;
675:
676: end ASSIGN_DAILY_BUCKETS;
677:
775:
776: -- added exception handler
777: exception when others then
778: /* Bug # 4235511 */
779: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
780: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.calculate_plan_buckets',SQLERRM);
781: end if ;
782: end calculate_plan_buckets;
783:
776: -- added exception handler
777: exception when others then
778: /* Bug # 4235511 */
779: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
780: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.calculate_plan_buckets',SQLERRM);
781: end if ;
782: end calculate_plan_buckets;
783:
784: PROCEDURE CALC_MONTHLY_NETTING_BKTS(p_cutoff_date IN NUMBER,
2206:
2207: -- added exception handler
2208: EXCEPTION WHEN OTHERS THEN
2209: /* Bug 4235511 */
2210: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2211: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET ' || sqlerrm);
2212: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET',SQLERRM);
2213: end if ;
2214:
2208: EXCEPTION WHEN OTHERS THEN
2209: /* Bug 4235511 */
2210: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
2211: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET ' || sqlerrm);
2212: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET',SQLERRM);
2213: end if ;
2214:
2215: END CALCULATE_NETTING_BUCKET;
2216: