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.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_BIS_PERIODS

Line 3191: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id, NULL);

3187: END;
3188:
3189: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) or
3190: (MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER AND lv_rec_count > 0) THEN
3191: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id, NULL);
3192:
3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);
3195: ELSE

Line 3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);

3190: (MSC_CL_COLLECTION.v_instance_type = MSC_UTIL.G_INS_OTHER AND lv_rec_count > 0) THEN
3191: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id, NULL);
3192:
3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);
3195: ELSE
3196: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3197: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
3198: END IF;

Line 3197: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);

3193: IF (MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS) OR (MSC_CL_COLLECTION.v_coll_prec.org_group_flag IS NULL) THEN
3194: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL);
3195: ELSE
3196: MSC_CL_COLLECTION.v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3197: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BIS_PERIODS', MSC_CL_COLLECTION.v_instance_id,NULL,MSC_CL_COLLECTION.v_sub_str);
3198: END IF;
3199:
3200: END IF;
3201:

Line 3209: INSERT INTO MSC_BIS_PERIODS

3205: FOR c_rec IN c5 LOOP
3206:
3207: BEGIN
3208:
3209: INSERT INTO MSC_BIS_PERIODS
3210: ( ORGANIZATION_ID,
3211: PERIOD_SET_NAME,
3212: PERIOD_NAME,
3213: START_DATE,

Line 3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');

3264:
3265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3266: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3267: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3268: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3269: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3270:
3271: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3272: RAISE;

Line 3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');

3276:
3277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3278: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3279: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BIS');
3280: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BIS_PERIODS');
3281: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3282:
3283: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3284: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');