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 FND_GLOBAL

Line 43: v_chr9 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(9);

39:
40: v_sourcing NUMBER; /* sourcing rule flag */
41:
42:
43: v_chr9 VARCHAR2(1) := FND_GLOBAL.LOCAL_CHR(9);
44:
45: lv_ibuc_coll_start_time DATE; /*IBUC*/
46:
47: REGEN_AND_COLLECT CONSTANT NUMBER :=3; --BUG 13724715 (FP of 13907513/12955171)

Line 429: IF fnd_global.conc_request_id > 0 THEN

425: SELECT MSC_ERRORS_S.NEXTVAL
426: INTO SEQ
427: FROM DUAL;
428:
429: IF fnd_global.conc_request_id > 0 THEN
430:
431: FND_FILE.PUT_LINE( FND_FILE.LOG,
432: TO_CHAR(SEQ)||':'
433: ||TO_CHAR(pID)||':'

Line 469: IF fnd_global.conc_request_id > 0 THEN

465: SELECT MSC_ERRORS_S.NEXTVAL
466: INTO SEQ
467: FROM DUAL;
468:
469: IF fnd_global.conc_request_id > 0 THEN
470:
471: FND_FILE.PUT_LINE( FND_FILE.LOG,
472: TO_CHAR(SEQ)||':'
473: ||TO_CHAR(pID)||':'

Line 572: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

568: IF v_cp_enabled= MSC_UTIL.SYS_NO THEN
569: RETURN MSC_UTIL.SYS_YES;
570: END IF;
571:
572: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
573:
574: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
575: ( l_request_id,
576: NULL,

Line 857: FND_GLOBAL.USER_ID,

853: SO_LRTYPE,
854: APPS_VER,
855: SYSDATE,
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
858: SYSDATE,
859: FND_GLOBAL.USER_ID,
860: UPPER(INSTANCE_CODE), /* Bug 2129155 */
861: INSTANCE_TYPE, -- OPM

Line 859: FND_GLOBAL.USER_ID,

855: SYSDATE,
856: SYSDATE,
857: FND_GLOBAL.USER_ID,
858: SYSDATE,
859: FND_GLOBAL.USER_ID,
860: UPPER(INSTANCE_CODE), /* Bug 2129155 */
861: INSTANCE_TYPE, -- OPM
862: LR_SOURCING_FLAG -- Sourcing Flag
863: INTO lv_last_refresh_type,

Line 1027: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1023: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1024: LCID= MSC_COLLECTION_S.NEXTVAL,
1025: LAST_UPDATE_DATE= v_current_date,
1026: LAST_UPDATED_BY= v_current_user,
1027: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1028: WHERE INSTANCE_ID= pINSTANCE_ID;
1029:
1030: SELECT MSC_COLLECTION_S.CURRVAL
1031: INTO v_last_collection_id

Line 1088: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1084: SET ST_STATUS= MSC_UTIL.G_ST_PURGING,
1085: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1086: LAST_UPDATE_DATE= v_current_date,
1087: LAST_UPDATED_BY= v_current_user,
1088: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1089: WHERE INSTANCE_ID= pINSTANCE_ID;
1090:
1091: RETURN TRUE;
1092:

Line 1103: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1099: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
1100: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1101: LAST_UPDATE_DATE= v_current_date,
1102: LAST_UPDATED_BY= v_current_user,
1103: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1104: WHERE INSTANCE_ID= pINSTANCE_ID;
1105:
1106: RETCODE:= MSC_UTIL.G_SUCCESS ;
1107: RETURN TRUE;

Line 1116: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1112: UPDATE MSC_APPS_INSTANCES
1113: SET ST_STATUS= MSC_UTIL.G_ST_READY,
1114: LAST_UPDATE_DATE= v_current_date,
1115: LAST_UPDATED_BY= v_current_user,
1116: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1117: WHERE INSTANCE_ID= pINSTANCE_ID;
1118:
1119: RETCODE:= MSC_UTIL.G_SUCCESS ;
1120: RETURN TRUE;

Line 1142: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1138: UPDATE MSC_APPS_INSTANCES mai
1139: SET LAST_UPDATE_DATE= v_current_date,
1140: LAST_UPDATED_BY= v_current_user,
1141: SUPPLIES_LOAD_FLAG = null,
1142: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1143: WHERE mai.INSTANCE_ID= v_instance_id;
1144:
1145: --- PREPLACE CHANGE START ---
1146:

Line 3596: FND_GLOBAL.USER_ID,

3592: BEGIN
3593:
3594: SELECT APPS_VER,
3595: SYSDATE,
3596: FND_GLOBAL.USER_ID,
3597: SYSDATE,
3598: FND_GLOBAL.USER_ID
3599: INTO v_apps_ver,
3600: v_current_date,

Line 3598: FND_GLOBAL.USER_ID

3594: SELECT APPS_VER,
3595: SYSDATE,
3596: FND_GLOBAL.USER_ID,
3597: SYSDATE,
3598: FND_GLOBAL.USER_ID
3599: INTO v_apps_ver,
3600: v_current_date,
3601: v_current_user,
3602: v_current_date,

Line 3686: IF fnd_global.conc_request_id > 0 THEN

3682: FND_MESSAGE.SET_NAME('MSC','MSC_CL_PURGE_BATCH_SIZE');
3683: FND_MESSAGE.SET_TOKEN('PBS',PBS);
3684: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3685:
3686: IF fnd_global.conc_request_id > 0 THEN
3687: v_cp_enabled:= MSC_UTIL.SYS_YES;
3688: ELSE
3689: v_cp_enabled:= MSC_UTIL.SYS_NO;
3690: END IF;

Line 4001: IF fnd_global.conc_request_id > 0 THEN

3997: WHEN OTHERS THEN
3998: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, SQLERRM);
3999: END;
4000:
4001: IF fnd_global.conc_request_id > 0 THEN
4002: v_cp_enabled:= MSC_UTIL.SYS_YES;
4003: ELSE
4004: v_cp_enabled:= MSC_UTIL.SYS_NO;
4005: END IF;

Line 4159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Responsibility_id = '||NVL(FND_GLOBAL.RESP_ID,-99));

4155:
4156: /* Put configuration related information in LOG file */
4157:
4158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'The MSC : Configuration profile option : '||MSC_UTIL.G_MSC_CONFIGURATION);
4159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Responsibility_id = '||NVL(FND_GLOBAL.RESP_ID,-99));
4160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application_id = '||NVL(FND_GLOBAL.RESP_APPL_ID, -99));
4161:
4162: /* CP changes end */
4163:

Line 4160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application_id = '||NVL(FND_GLOBAL.RESP_APPL_ID, -99));

4156: /* Put configuration related information in LOG file */
4157:
4158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'The MSC : Configuration profile option : '||MSC_UTIL.G_MSC_CONFIGURATION);
4159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Responsibility_id = '||NVL(FND_GLOBAL.RESP_ID,-99));
4160: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application_id = '||NVL(FND_GLOBAL.RESP_APPL_ID, -99));
4161:
4162: /* CP changes end */
4163:
4164: --agmcont:

Line 4377: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4373: SET
4374: so_tbl_status= MSC_UTIL.SYS_NO,
4375: LAST_UPDATE_DATE= v_current_date,
4376: LAST_UPDATED_BY= v_current_user,
4377: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4378: WHERE mai.INSTANCE_ID= v_instance_id;
4379: commit;
4380: END IF;
4381:

Line 4534: FND_GLOBAL.CONC_REQUEST_ID,

4530: 'MSCPDCW',
4531: NULL, -- description
4532: NULL, -- start date
4533: FALSE, -- TRUE,
4534: FND_GLOBAL.CONC_REQUEST_ID,
4535: pINSTANCE_ID,
4536: v_last_collection_id,
4537: pTIMEOUT,
4538: lv_pRECALC_NRA_NEW,

Line 4590: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);

4586: COMMIT;
4587:
4588: END IF; -- DEVELOPING
4589:
4590: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
4591:
4592: -- ============ Send Tasks to Task Que 'v_pipe_task_que' =============
4593: -- load sales orders will be called from load_supply - link demand-supply
4594: /* ds change */

Line 4693: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4689: SET
4690: so_tbl_status= MSC_UTIL.SYS_YES,
4691: LAST_UPDATE_DATE= v_current_date,
4692: LAST_UPDATED_BY= v_current_user,
4693: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4694: WHERE mai.INSTANCE_ID= v_instance_id;
4695: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
4696: commit;
4697: G_TASK_ATP_RULES :=0;

Line 4786: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4782:
4783: UPDATE MSC_APPS_INSTANCES mai
4784: SET LAST_UPDATE_DATE= v_current_date,
4785: LAST_UPDATED_BY= v_current_user,
4786: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4787: WHERE mai.INSTANCE_ID= v_instance_id;
4788: commit;
4789:
4790: IF (v_is_complete_refresh) THEN

Line 6172: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6168: SET
6169: so_tbl_status= MSC_UTIL.SYS_NO,
6170: LAST_UPDATE_DATE= v_current_date,
6171: LAST_UPDATED_BY= v_current_user,
6172: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6173: WHERE mai.INSTANCE_ID= v_instance_id;
6174: commit;
6175: end if;
6176:

Line 6204: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6200: SET
6201: so_tbl_status= MSC_UTIL.SYS_YES,
6202: LAST_UPDATE_DATE= v_current_date,
6203: LAST_UPDATED_BY= v_current_user,
6204: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6205: WHERE mai.INSTANCE_ID= v_instance_id;
6206: commit;
6207: end if;
6208: END IF;

Line 6354: FND_GLOBAL.CONC_REQUEST_ID,

6350: 'MSCPDCW',
6351: NULL, -- description
6352: NULL, -- start date
6353: FALSE, -- TRUE,
6354: FND_GLOBAL.CONC_REQUEST_ID,
6355: pINSTANCE_ID,
6356: v_last_collection_id,
6357: pTIMEOUT,
6358: pRECALC_NRA,

Line 6420: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);

6416: /* for cont. collections the ODS load workers
6417: are launched from the MSCCLFAB.pls */
6418:
6419: END IF;
6420: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
6421:
6422: -- ============ Send Tasks to Task Que 'v_pipe_task_que' =============
6423: -- load sales orders will be called from load_supply - link demand-supply
6424:

Line 6436: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6432: SET
6433: so_tbl_status= MSC_UTIL.SYS_NO,
6434: LAST_UPDATE_DATE= v_current_date,
6435: LAST_UPDATED_BY= v_current_user,
6436: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6437: WHERE mai.INSTANCE_ID= v_instance_id;
6438: commit;
6439: end if;
6440:

Line 6510: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6506: SET
6507: so_tbl_status= MSC_UTIL.SYS_YES,
6508: LAST_UPDATE_DATE= v_current_date,
6509: LAST_UPDATED_BY= v_current_user,
6510: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6511: WHERE mai.INSTANCE_ID= v_instance_id;
6512: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
6513: commit;
6514: G_TASK_ATP_RULES:=0;

Line 6524: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6520: SET
6521: so_tbl_status= MSC_UTIL.SYS_YES,
6522: LAST_UPDATE_DATE= v_current_date,
6523: LAST_UPDATED_BY= v_current_user,
6524: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6525: WHERE mai.INSTANCE_ID= v_instance_id;
6526: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
6527: commit;
6528: G_TASK_SOURCING :=0;

Line 6537: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6533: SET
6534: so_tbl_status= MSC_UTIL.SYS_YES,
6535: LAST_UPDATE_DATE= v_current_date,
6536: LAST_UPDATED_BY= v_current_user,
6537: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6538: WHERE mai.INSTANCE_ID= v_instance_id;
6539: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
6540: commit;
6541: G_TASK_ATP_RULES :=0;

Line 6636: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

6632:
6633: UPDATE MSC_APPS_INSTANCES mai
6634: SET LAST_UPDATE_DATE= v_current_date,
6635: LAST_UPDATED_BY= v_current_user,
6636: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
6637: WHERE mai.INSTANCE_ID= v_instance_id;
6638: commit;
6639: /*
6640: * Commented out for bug 13084110 (Forward port for bug 13023757)