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_COLLECTION dependencies on MSC_CL_SCE_COLLECTION

Line 1637: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);

1633: ELSIF pTASKNUM= TASK_ITEM_CUSTOMERS THEN
1634: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1635: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'TASK_ITEM_CUSTOMERS');
1636: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1637: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);
1638:
1639: ELSIF pTASKNUM= TASK_COMPANY_USERS THEN
1640:
1641: /* Perform this task only if MSC:Configuration is set to 'APS + SCE' or 'SCE. */

Line 1646: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');

1642: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
1643: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
1644:
1645: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1646: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
1647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1648: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
1649:
1650: END IF;

Line 1648: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);

1644:
1645: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1646: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
1647: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1648: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
1649:
1650: END IF;
1651: /* SCE Change ends */
1652:

Line 2771: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);

2767:
2768: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
2769: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'TASK_ITEM_CUSTOMERS');
2770: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2771: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);
2772:
2773: ELSIF pTASKNUM= PTASK_COMPANY_USERS THEN
2774:
2775: /* Perform this task only if MSC:Configuration is set to

Line 2781: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');

2777: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
2778: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
2779:
2780: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2781: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
2782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2783: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
2784:
2785: END IF;

Line 2783: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);

2779:
2780: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
2781: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
2782: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
2783: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
2784:
2785: END IF;
2786: /* SCE Change ends */
2787:

Line 3643: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);

3639:
3640: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
3641: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
3642: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before PROCESS_COMPANY_CHANGE');
3643: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);
3644:
3645: if (lv_process_comp_err = MSC_UTIL.G_ERROR) THEN
3646: ROLLBACK;
3647: RETCODE := MSC_UTIL.G_ERROR;

Line 3655: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;

3651: END IF;
3652:
3653: -- ========== Get My Company Name ============
3654: --IF (G_MSC_CONFIGURATION = G_CONF_APS_SCE OR G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
3655: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
3656:
3657: IF (v_my_company_name = null) then
3658: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error while fetching Company Name');
3659: ROLLBACK;

Line 3688: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)

3684: - TRANSFORM KEYS
3685:
3686: If MSC:Configuration = 'APS+SCE' or 'SCE' then
3687: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
3688: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
3689: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
3690: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
3691: */
3692:

Line 3689: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)

3685:
3686: If MSC:Configuration = 'APS+SCE' or 'SCE' then
3687: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
3688: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
3689: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
3690: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
3691: */
3692:
3693: /* DEBUG */

Line 3701: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

3697: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
3698: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
3699: /* SCE CHANGE starts */
3700: /* Data cleanup based on MSC:Configuration profile option */
3701: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
3702: v_my_company_name)
3703: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
3704: v_current_user,
3705: v_current_date,

Line 3703: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,

3699: /* SCE CHANGE starts */
3700: /* Data cleanup based on MSC:Configuration profile option */
3701: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
3702: v_my_company_name)
3703: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
3704: v_current_user,
3705: v_current_date,
3706: v_last_collection_id,
3707: v_is_incremental_refresh,

Line 3800: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');

3796: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
3797: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
3798:
3799: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3800: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
3801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3802:
3803: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
3804:

Line 3803: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);

3799: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3800: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
3801: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3802:
3803: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
3804:
3805: END IF;
3806: /* SCE Change ends */
3807:

Line 3833: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS');

3829: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
3830: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
3831:
3832: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3833: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS');
3834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3835: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);
3836:
3837: END IF;

Line 3835: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);

3831:
3832: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3833: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS');
3834: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3835: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);
3836:
3837: END IF;
3838:
3839: /* SCE Change ends */

Line 5232: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);

5228:
5229: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
5230: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
5231:
5232: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);
5233:
5234: if (lv_process_comp_err = MSC_UTIL.G_ERROR) THEN
5235: ROLLBACK;
5236: IF SET_ST_STATUS( ERRBUF, RETCODE, pINSTANCE_ID, MSC_UTIL.G_ST_READY) THEN

Line 5247: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;

5243: END IF;
5244:
5245: -- ========== Get My Company Name ============
5246: --IF (G_MSC_CONFIGURATION = G_CONF_APS_SCE OR G_MSC_CONFIGURATION = G_CONF_SCE) THEN
5247: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
5248:
5249: IF (v_my_company_name = null) then
5250: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error while fetching Company Name');
5251: ROLLBACK;

Line 5281: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)

5277: - TRANSFORM KEYS
5278:
5279: If MSC:Configuration = 'APS+SCE' or 'SCE' then
5280: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
5281: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
5282: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
5283: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
5284: */
5285:

Line 5282: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)

5278:
5279: If MSC:Configuration = 'APS+SCE' or 'SCE' then
5280: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
5281: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
5282: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
5283: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
5284: */
5285:
5286: /* added code to call cleanse Data when Targeted Collections is running */

Line 5322: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

5318:
5319: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
5320: IF /* SCE CHANGE starts */
5321: /* Data cleanup based on MSC:Configuration profile option */
5322: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
5323: v_my_company_name)
5324: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
5325: v_current_user,
5326: v_current_date,

Line 5324: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,

5320: IF /* SCE CHANGE starts */
5321: /* Data cleanup based on MSC:Configuration profile option */
5322: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
5323: v_my_company_name)
5324: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
5325: v_current_user,
5326: v_current_date,
5327: v_last_collection_id,
5328: v_is_incremental_refresh,

Line 5424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');

5420: */
5421: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
5422: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
5423: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
5425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5426: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
5427: END IF;
5428: -- END IF;

Line 5426: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);

5422: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
5423: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
5424: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
5425: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
5426: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
5427: END IF;
5428: -- END IF;
5429:
5430: /* SCE Change ends */