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:
46:
47:

Line 421: IF fnd_global.conc_request_id > 0 THEN

417: SELECT MSC_ERRORS_S.NEXTVAL
418: INTO SEQ
419: FROM DUAL;
420:
421: IF fnd_global.conc_request_id > 0 THEN
422:
423: FND_FILE.PUT_LINE( FND_FILE.LOG,
424: TO_CHAR(SEQ)||':'
425: ||TO_CHAR(pID)||':'

Line 461: IF fnd_global.conc_request_id > 0 THEN

457: SELECT MSC_ERRORS_S.NEXTVAL
458: INTO SEQ
459: FROM DUAL;
460:
461: IF fnd_global.conc_request_id > 0 THEN
462:
463: FND_FILE.PUT_LINE( FND_FILE.LOG,
464: TO_CHAR(SEQ)||':'
465: ||TO_CHAR(pID)||':'

Line 564: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

560: IF v_cp_enabled= MSC_UTIL.SYS_NO THEN
561: RETURN MSC_UTIL.SYS_YES;
562: END IF;
563:
564: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
565:
566: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
567: ( l_request_id,
568: NULL,

Line 849: FND_GLOBAL.USER_ID,

845: SO_LRTYPE,
846: APPS_VER,
847: SYSDATE,
848: SYSDATE,
849: FND_GLOBAL.USER_ID,
850: SYSDATE,
851: FND_GLOBAL.USER_ID,
852: UPPER(INSTANCE_CODE), /* Bug 2129155 */
853: INSTANCE_TYPE, -- OPM

Line 851: FND_GLOBAL.USER_ID,

847: SYSDATE,
848: SYSDATE,
849: FND_GLOBAL.USER_ID,
850: SYSDATE,
851: FND_GLOBAL.USER_ID,
852: UPPER(INSTANCE_CODE), /* Bug 2129155 */
853: INSTANCE_TYPE, -- OPM
854: LR_SOURCING_FLAG -- Sourcing Flag
855: INTO lv_last_refresh_type,

Line 1019: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1015: SET ST_STATUS= MSC_UTIL.G_ST_COLLECTING,
1016: LCID= MSC_COLLECTION_S.NEXTVAL,
1017: LAST_UPDATE_DATE= v_current_date,
1018: LAST_UPDATED_BY= v_current_user,
1019: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1020: WHERE INSTANCE_ID= pINSTANCE_ID;
1021:
1022: SELECT MSC_COLLECTION_S.CURRVAL
1023: INTO v_last_collection_id

Line 1080: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1076: SET ST_STATUS= MSC_UTIL.G_ST_PURGING,
1077: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1078: LAST_UPDATE_DATE= v_current_date,
1079: LAST_UPDATED_BY= v_current_user,
1080: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1081: WHERE INSTANCE_ID= pINSTANCE_ID;
1082:
1083: RETURN TRUE;
1084:

Line 1095: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1091: SET ST_STATUS= MSC_UTIL.G_ST_EMPTY,
1092: SO_TBL_STATUS= MSC_UTIL.SYS_YES,
1093: LAST_UPDATE_DATE= v_current_date,
1094: LAST_UPDATED_BY= v_current_user,
1095: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1096: WHERE INSTANCE_ID= pINSTANCE_ID;
1097:
1098: RETCODE:= MSC_UTIL.G_SUCCESS ;
1099: RETURN TRUE;

Line 1108: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1104: UPDATE MSC_APPS_INSTANCES
1105: SET ST_STATUS= MSC_UTIL.G_ST_READY,
1106: LAST_UPDATE_DATE= v_current_date,
1107: LAST_UPDATED_BY= v_current_user,
1108: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1109: WHERE INSTANCE_ID= pINSTANCE_ID;
1110:
1111: RETCODE:= MSC_UTIL.G_SUCCESS ;
1112: RETURN TRUE;

Line 1134: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

1130: UPDATE MSC_APPS_INSTANCES mai
1131: SET LAST_UPDATE_DATE= v_current_date,
1132: LAST_UPDATED_BY= v_current_user,
1133: SUPPLIES_LOAD_FLAG = null,
1134: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
1135: WHERE mai.INSTANCE_ID= v_instance_id;
1136:
1137: --- PREPLACE CHANGE START ---
1138:

Line 2999: FND_GLOBAL.USER_ID,

2995: BEGIN
2996:
2997: SELECT APPS_VER,
2998: SYSDATE,
2999: FND_GLOBAL.USER_ID,
3000: SYSDATE,
3001: FND_GLOBAL.USER_ID
3002: INTO v_apps_ver,
3003: v_current_date,

Line 3001: FND_GLOBAL.USER_ID

2997: SELECT APPS_VER,
2998: SYSDATE,
2999: FND_GLOBAL.USER_ID,
3000: SYSDATE,
3001: FND_GLOBAL.USER_ID
3002: INTO v_apps_ver,
3003: v_current_date,
3004: v_current_user,
3005: v_current_date,

Line 3089: IF fnd_global.conc_request_id > 0 THEN

3085: FND_MESSAGE.SET_NAME('MSC','MSC_CL_PURGE_BATCH_SIZE');
3086: FND_MESSAGE.SET_TOKEN('PBS',PBS);
3087: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, FND_MESSAGE.GET);
3088:
3089: IF fnd_global.conc_request_id > 0 THEN
3090: v_cp_enabled:= MSC_UTIL.SYS_YES;
3091: ELSE
3092: v_cp_enabled:= MSC_UTIL.SYS_NO;
3093: END IF;

Line 3400: IF fnd_global.conc_request_id > 0 THEN

3396: WHEN OTHERS THEN
3397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, SQLERRM);
3398: END;
3399:
3400: IF fnd_global.conc_request_id > 0 THEN
3401: v_cp_enabled:= MSC_UTIL.SYS_YES;
3402: ELSE
3403: v_cp_enabled:= MSC_UTIL.SYS_NO;
3404: END IF;

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

3554:
3555: /* Put configuration related information in LOG file */
3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'The MSC : Configuration profile option : '||MSC_UTIL.G_MSC_CONFIGURATION);
3558: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Responsibility_id = '||NVL(FND_GLOBAL.RESP_ID,-99));
3559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application_id = '||NVL(FND_GLOBAL.RESP_APPL_ID, -99));
3560:
3561: /* CP changes end */
3562:

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

3555: /* Put configuration related information in LOG file */
3556:
3557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'The MSC : Configuration profile option : '||MSC_UTIL.G_MSC_CONFIGURATION);
3558: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Responsibility_id = '||NVL(FND_GLOBAL.RESP_ID,-99));
3559: MSC_UTIL.LOG_MSG(MSC_UTIL.G_LVL_STATUS, 'Application_id = '||NVL(FND_GLOBAL.RESP_APPL_ID, -99));
3560:
3561: /* CP changes end */
3562:
3563: --agmcont:

Line 3774: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

3770: SET
3771: so_tbl_status= MSC_UTIL.SYS_NO,
3772: LAST_UPDATE_DATE= v_current_date,
3773: LAST_UPDATED_BY= v_current_user,
3774: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
3775: WHERE mai.INSTANCE_ID= v_instance_id;
3776: commit;
3777: END IF;
3778:

Line 3915: FND_GLOBAL.CONC_REQUEST_ID,

3911: 'MSCPDCW',
3912: NULL, -- description
3913: NULL, -- start date
3914: FALSE, -- TRUE,
3915: FND_GLOBAL.CONC_REQUEST_ID,
3916: pINSTANCE_ID,
3917: v_last_collection_id,
3918: pTIMEOUT,
3919: lv_pRECALC_NRA_NEW,

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

3967: COMMIT;
3968:
3969: END IF; -- DEVELOPING
3970:
3971: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
3972:
3973: -- ============ Send Tasks to Task Que 'v_pipe_task_que' =============
3974: -- load sales orders will be called from load_supply - link demand-supply
3975: /* ds change */

Line 4067: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4063: SET
4064: so_tbl_status= MSC_UTIL.SYS_YES,
4065: LAST_UPDATE_DATE= v_current_date,
4066: LAST_UPDATED_BY= v_current_user,
4067: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4068: WHERE mai.INSTANCE_ID= v_instance_id;
4069: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
4070: commit;
4071: G_TASK_ATP_RULES :=0;

Line 4160: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

4156:
4157: UPDATE MSC_APPS_INSTANCES mai
4158: SET LAST_UPDATE_DATE= v_current_date,
4159: LAST_UPDATED_BY= v_current_user,
4160: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
4161: WHERE mai.INSTANCE_ID= v_instance_id;
4162: commit;
4163:
4164: IF (v_is_complete_refresh) THEN

Line 5406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5402: SET
5403: so_tbl_status= MSC_UTIL.SYS_NO,
5404: LAST_UPDATE_DATE= v_current_date,
5405: LAST_UPDATED_BY= v_current_user,
5406: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5407: WHERE mai.INSTANCE_ID= v_instance_id;
5408: commit;
5409: end if;
5410:

Line 5438: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5434: SET
5435: so_tbl_status= MSC_UTIL.SYS_YES,
5436: LAST_UPDATE_DATE= v_current_date,
5437: LAST_UPDATED_BY= v_current_user,
5438: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5439: WHERE mai.INSTANCE_ID= v_instance_id;
5440: commit;
5441: end if;
5442: END IF;

Line 5572: FND_GLOBAL.CONC_REQUEST_ID,

5568: 'MSCPDCW',
5569: NULL, -- description
5570: NULL, -- start date
5571: FALSE, -- TRUE,
5572: FND_GLOBAL.CONC_REQUEST_ID,
5573: pINSTANCE_ID,
5574: v_last_collection_id,
5575: pTIMEOUT,
5576: pRECALC_NRA,

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

5634: /* for cont. collections the ODS load workers
5635: are launched from the MSCCLFAB.pls */
5636:
5637: END IF;
5638: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
5639:
5640: -- ============ Send Tasks to Task Que 'v_pipe_task_que' =============
5641: -- load sales orders will be called from load_supply - link demand-supply
5642:

Line 5654: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5650: SET
5651: so_tbl_status= MSC_UTIL.SYS_NO,
5652: LAST_UPDATE_DATE= v_current_date,
5653: LAST_UPDATED_BY= v_current_user,
5654: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5655: WHERE mai.INSTANCE_ID= v_instance_id;
5656: commit;
5657: end if;
5658:

Line 5721: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5717: SET
5718: so_tbl_status= MSC_UTIL.SYS_YES,
5719: LAST_UPDATE_DATE= v_current_date,
5720: LAST_UPDATED_BY= v_current_user,
5721: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5722: WHERE mai.INSTANCE_ID= v_instance_id;
5723: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
5724: commit;
5725: G_TASK_ATP_RULES:=0;

Line 5735: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5731: SET
5732: so_tbl_status= MSC_UTIL.SYS_YES,
5733: LAST_UPDATE_DATE= v_current_date,
5734: LAST_UPDATED_BY= v_current_user,
5735: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5736: WHERE mai.INSTANCE_ID= v_instance_id;
5737: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
5738: commit;
5739: G_TASK_SOURCING :=0;

Line 5748: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5744: SET
5745: so_tbl_status= MSC_UTIL.SYS_YES,
5746: LAST_UPDATE_DATE= v_current_date,
5747: LAST_UPDATED_BY= v_current_user,
5748: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5749: WHERE mai.INSTANCE_ID= v_instance_id;
5750: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_DEBUG_1, 'update so tbl status');
5751: commit;
5752: G_TASK_ATP_RULES :=0;

Line 5847: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

5843:
5844: UPDATE MSC_APPS_INSTANCES mai
5845: SET LAST_UPDATE_DATE= v_current_date,
5846: LAST_UPDATED_BY= v_current_user,
5847: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
5848: WHERE mai.INSTANCE_ID= v_instance_id;
5849: commit;
5850:
5851: IF (v_is_partial_refresh) AND