APPS.MSC_EXCHANGE_BUCKETING dependencies on MSC_EXCHANGE_BUCKETING

Line 1: PACKAGE BODY MSC_EXCHANGE_BUCKETING AS

1: PACKAGE BODY MSC_EXCHANGE_BUCKETING AS
2: /* $Header: MSCXBKB.pls 120.4 2006/02/13 04:12:43 pragarwa noship $ */
3: EQUAL CONSTANT INTEGER := 1;
4: NOT_EQUAL CONSTANT INTEGER := 2;
5: SYS_NO CONSTANT INTEGER := 2;

Line 299: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_MONTHLY_BUCKETS',SQLERRM);

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:

Line 537: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.ASSIGN_WEEKLY_BUCKETS',SQLERRM);

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:

Line 673: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.ASSIGN_DAILY_BUCKETS',SQLERRM);

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:

Line 780: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, 'MSC_EXCHANGE_BUCKETING.calculate_plan_buckets',SQLERRM);

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,

Line 2211: FND_FILE.PUT_LINE( FND_FILE.LOG, 'Error in MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET ' || sqlerrm);

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:
2215: END CALCULATE_NETTING_BUCKET;

Line 2212: FND_LOG.STRING(FND_LOG.LEVEL_ERROR,'MSC_EXCHANGE_BUCKETING.CALCULATE_NETTING_BUCKET',SQLERRM);

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:

Line 2497: END MSC_EXCHANGE_BUCKETING;

2493: RAISE;
2494:
2495: END start_bucketing;
2496:
2497: END MSC_EXCHANGE_BUCKETING;