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 1678: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);

1674: ELSIF pTASKNUM= TASK_ITEM_CUSTOMERS THEN
1675: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1676: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'TASK_ITEM_CUSTOMERS');
1677: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1678: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);
1679:
1680: ELSIF pTASKNUM= TASK_COMPANY_USERS THEN
1681:
1682: /* Perform this task only if MSC:Configuration is set to 'APS + SCE' or 'SCE. */

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

1683: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
1684: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
1685:
1686: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1687: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1689: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
1690:
1691: END IF;

Line 1689: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);

1685:
1686: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
1687: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
1688: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
1689: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
1690:
1691: END IF;
1692: /* SCE Change ends */
1693:

Line 3125: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);

3121:
3122: FND_MESSAGE.SET_NAME('MSC', 'MSC_DL_TASK_START_PARTIAL');
3123: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'TASK_ITEM_CUSTOMERS');
3124: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3125: MSC_CL_SCE_COLLECTION.LOAD_ITEM_CUSTOMERS(v_instance_id);
3126:
3127: ELSIF pTASKNUM= PTASK_COMPANY_USERS THEN
3128:
3129: /* Perform this task only if MSC:Configuration is set to

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

3131: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
3132: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
3133:
3134: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3135: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
3136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3137: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
3138:
3139: END IF;

Line 3137: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);

3133:
3134: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
3135: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY');
3136: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3137: MSC_CL_SCE_COLLECTION.LOAD_USER_COMPANY(v_instance_id);
3138:
3139: END IF;
3140: /* SCE Change ends */
3141:

Line 4246: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);

4242:
4243: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
4244: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4245: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before PROCESS_COMPANY_CHANGE');
4246: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);
4247:
4248: if (lv_process_comp_err = MSC_UTIL.G_ERROR) THEN
4249: ROLLBACK;
4250: RETCODE := MSC_UTIL.G_ERROR;

Line 4258: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;

4254: END IF;
4255:
4256: -- ========== Get My Company Name ============
4257: --IF (G_MSC_CONFIGURATION = G_CONF_APS_SCE OR G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
4258: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
4259:
4260: IF (v_my_company_name = null) then
4261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_FATAL_ERR, 'Error while fetching Company Name');
4262: ROLLBACK;

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

4287: - TRANSFORM KEYS
4288:
4289: If MSC:Configuration = 'APS+SCE' or 'SCE' then
4290: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
4291: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
4292: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
4293: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
4294: */
4295:

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

4288:
4289: If MSC:Configuration = 'APS+SCE' or 'SCE' then
4290: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
4291: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
4292: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
4293: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
4294: */
4295:
4296: /* DEBUG */

Line 4304: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

4300: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'before MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA 1');
4301: IF MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA
4302: /* SCE CHANGE starts */
4303: /* Data cleanup based on MSC:Configuration profile option */
4304: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
4305: v_my_company_name)
4306: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
4307: v_current_user,
4308: v_current_date,

Line 4306: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,

4302: /* SCE CHANGE starts */
4303: /* Data cleanup based on MSC:Configuration profile option */
4304: AND MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
4305: v_my_company_name)
4306: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
4307: v_current_user,
4308: v_current_date,
4309: v_last_collection_id,
4310: v_is_incremental_refresh,

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

4399: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4400: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
4401:
4402: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4403: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
4404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4405:
4406: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
4407:

Line 4406: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);

4402: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4403: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
4404: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4405:
4406: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
4407:
4408: END IF;
4409: /* SCE Change ends */
4410:

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

4432: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
4433: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
4434:
4435: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4436: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS');
4437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4438: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);
4439:
4440: END IF;

Line 4438: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);

4434:
4435: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
4436: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS');
4437: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
4438: MSC_CL_SCE_COLLECTION.CLEANSE_TP_ITEMS(v_instance_id);
4439:
4440: END IF;
4441:
4442: /* SCE Change ends */

Line 5998: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);

5994:
5995: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE
5996: OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
5997:
5998: MSC_CL_SCE_COLLECTION.PROCESS_COMPANY_CHANGE(lv_process_comp_err);
5999:
6000: if (lv_process_comp_err = MSC_UTIL.G_ERROR) THEN
6001: ROLLBACK;
6002: IF SET_ST_STATUS( ERRBUF, RETCODE, pINSTANCE_ID, MSC_UTIL.G_ST_READY) THEN

Line 6013: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;

6009: END IF;
6010:
6011: -- ========== Get My Company Name ============
6012: --IF (G_MSC_CONFIGURATION = G_CONF_APS_SCE OR G_MSC_CONFIGURATION = G_CONF_SCE) THEN
6013: v_my_company_name := MSC_CL_SCE_COLLECTION.GET_MY_COMPANY;
6014:
6015: IF (v_my_company_name = null) then
6016: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Error while fetching Company Name');
6017: ROLLBACK;

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

6043: - TRANSFORM KEYS
6044:
6045: If MSC:Configuration = 'APS+SCE' or 'SCE' then
6046: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
6047: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
6048: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
6049: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
6050: */
6051:

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

6044:
6045: If MSC:Configuration = 'APS+SCE' or 'SCE' then
6046: - Execute MSC_CL_SETUP_ODS_LOAD.CLEANSE_DATA (Hook for Customization)
6047: - MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE (Data cleanup for Multi Company)
6048: - MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS (New Companies and Sites in Collaboration area)
6049: - TRANSFORM KEYS (Global Ids for Trading Partners in Planning Area)
6050: */
6051:
6052: /* added code to call cleanse Data when Targeted Collections is running */

Line 6088: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,

6084:
6085: IF (MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE) THEN
6086: IF /* SCE CHANGE starts */
6087: /* Data cleanup based on MSC:Configuration profile option */
6088: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
6089: v_my_company_name)
6090: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
6091: v_current_user,
6092: v_current_date,

Line 6090: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,

6086: IF /* SCE CHANGE starts */
6087: /* Data cleanup based on MSC:Configuration profile option */
6088: MSC_CL_SCE_COLLECTION.CLEANSE_DATA_FOR_SCE(v_instance_id,
6089: v_my_company_name)
6090: AND MSC_CL_SCE_COLLECTION.SCE_TRANSFORM_KEYS(v_instance_id,
6091: v_current_user,
6092: v_current_date,
6093: v_last_collection_id,
6094: v_is_incremental_refresh,

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

6186: */
6187: IF MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_APS_SCE OR
6188: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
6189: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6190: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
6191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6192: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
6193: END IF;
6194: -- END IF;

Line 6192: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);

6188: MSC_UTIL.G_MSC_CONFIGURATION = MSC_UTIL.G_CONF_SCE THEN
6189: FND_MESSAGE.SET_NAME('MSC', 'MSC_DP_TASK_START');
6190: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE');
6191: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
6192: MSC_CL_SCE_COLLECTION.POPULATE_TP_MAP_TABLE(v_instance_id);
6193: END IF;
6194: -- END IF;
6195:
6196: /* SCE Change ends */