DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on FND_GLOBAL

Line 2852: FND_GLOBAL.USER_ID,

2848: APPS_VER,
2849: SYSDATE,
2850: SYSDATE,
2851: LRID, -- gets current refresh id
2852: FND_GLOBAL.USER_ID,
2853: SYSDATE,
2854: FND_GLOBAL.USER_ID,
2855: INSTANCE_CODE,
2856: INSTANCE_TYPE -- OPM

Line 2854: FND_GLOBAL.USER_ID,

2850: SYSDATE,
2851: LRID, -- gets current refresh id
2852: FND_GLOBAL.USER_ID,
2853: SYSDATE,
2854: FND_GLOBAL.USER_ID,
2855: INSTANCE_CODE,
2856: INSTANCE_TYPE -- OPM
2857: INTO lv_last_refresh_type,
2858: lv_so_last_refresh_type,

Line 2979: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID

2975: LRID= v_refresh_id,
2976: LRTYPE= 'L',
2977: SO_LRTYPE= 'I',
2978: CLEANSED_FLAG= SYS_NO,
2979: REQUEST_ID = FND_GLOBAL.CONC_REQUEST_ID
2980: WHERE mai.INSTANCE_ID = v_instance_id;
2981:
2982: -- Legacy Net Change Perf L flow changes
2983:

Line 3078: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;

3074: IF v_cp_enabled= SYS_NO THEN
3075: RETURN SYS_YES;
3076: END IF;
3077:
3078: l_request_id := FND_GLOBAL.CONC_REQUEST_ID;
3079:
3080: l_call_status:= FND_CONCURRENT.GET_REQUEST_STATUS
3081: ( l_request_id,
3082: NULL,

Line 10160: select fnd_global.user_id into lv_user_id from dual;

10156: IF lv_return <> 0 THEN
10157: RAISE ex_logging_err;
10158: END IF;
10159:
10160: select fnd_global.user_id into lv_user_id from dual;
10161:
10162: IF NOT MSC_ST_util.IS_OPERATOR(lv_user_id) THEN
10163: lv_return := MSC_ST_util.GET_ERROR_MESSAGE
10164: (p_app_short_name => 'MSC',

Line 10740: select fnd_global.user_id into lv_user_id from dual;

10736:
10737:
10738: -- Only group owner or operator can update
10739:
10740: select fnd_global.user_id into lv_user_id from dual;
10741:
10742: lv_return := MSC_ST_util.GET_ERROR_MESSAGE
10743: (p_app_short_name => 'MSC',
10744: p_error_code => 'MSC_PP_INVALID_VALUE',

Line 52650: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

52646: SET ST_STATUS= G_ST_PRE_PROCESSING,
52647: LCID= MSC_COLLECTION_S.NEXTVAL,
52648: LAST_UPDATE_DATE= v_current_date,
52649: LAST_UPDATED_BY= v_current_user,
52650: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
52651: WHERE INSTANCE_ID= p_instance_id;
52652:
52653: SELECT MSC_COLLECTION_S.CURRVAL
52654: INTO v_last_collection_id

Line 52668: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

52664: UPDATE MSC_APPS_INSTANCES
52665: SET ST_STATUS= G_ST_READY,
52666: LAST_UPDATE_DATE= v_current_date,
52667: LAST_UPDATED_BY= v_current_user,
52668: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
52669: WHERE INSTANCE_ID= p_instance_id;
52670:
52671: RETCODE:= G_SUCCESS;
52672: RETURN TRUE;

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

52742:
52743: EX_PIPE_RCV EXCEPTION;
52744: EX_PIPE_SND EXCEPTION;
52745: BEGIN
52746: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
52747: -- ===== Switch on/ off debug based on MRP: Debug Profile
52748:
52749: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
52750:

Line 52804: IF fnd_global.conc_request_id > 0 THEN

52800: v_monitor_request_id := p_monitor_request_id;
52801:
52802: PBS := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
52803:
52804: IF fnd_global.conc_request_id > 0 THEN
52805: v_cp_enabled:= SYS_YES;
52806: ELSE
52807: v_cp_enabled:= SYS_NO;
52808: END IF;

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

53111: WHERE instance_id = p_instance_id;
53112:
53113:
53114: BEGIN
53115: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
53116: lv_retval := FND_INSTALLATION.GET_APP_INFO(
53117: 'MSD', lv_dummy1,lv_dummy2, v_applsys_schema);
53118:
53119: IF (lv_dummy1 = 'I' OR lv_dummy1 = 'S')THEN

Line 53323: -- monitor using fnd_global.conc_request_id.

53319: INITIALIZE( p_instance_id);
53320:
53321: -- Initializing v_request_id with the p_parent_request_id if
53322: -- OA upload else with current request id of the pre process
53323: -- monitor using fnd_global.conc_request_id.
53324: IF nvl(p_parent_request_id, -1) < 1 THEN
53325: v_request_id := -(fnd_global.conc_request_id);
53326: ELSE
53327: v_request_id := v_parent_request_id;

Line 53325: v_request_id := -(fnd_global.conc_request_id);

53321: -- Initializing v_request_id with the p_parent_request_id if
53322: -- OA upload else with current request id of the pre process
53323: -- monitor using fnd_global.conc_request_id.
53324: IF nvl(p_parent_request_id, -1) < 1 THEN
53325: v_request_id := -(fnd_global.conc_request_id);
53326: ELSE
53327: v_request_id := v_parent_request_id;
53328: END IF;
53329:

Line 53367: IF fnd_global.conc_request_id > 0 THEN

53363:
53364:
53365: -- end of changes for L flow
53366:
53367: IF fnd_global.conc_request_id > 0 THEN
53368: v_cp_enabled:= SYS_YES;
53369: ELSE
53370: v_cp_enabled:= SYS_NO;
53371: END IF;

Line 53505: FND_GLOBAL.CONC_REQUEST_ID,

53501: 'MSCPPW', /* launch worker procedure called */
53502: NULL, -- description
53503: NULL, -- start date
53504: FALSE, -- TRUE,
53505: FND_GLOBAL.CONC_REQUEST_ID,
53506: p_instance_id,
53507: v_last_collection_id,
53508: p_timeout,
53509: p_batch_size,

Line 54443: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID

54439:
54440: UPDATE MSC_APPS_INSTANCES mai
54441: SET LAST_UPDATE_DATE= v_current_date,
54442: LAST_UPDATED_BY= v_current_user,
54443: REQUEST_ID= FND_GLOBAL.CONC_REQUEST_ID
54444: WHERE mai.INSTANCE_ID= v_instance_id;
54445:
54446: FND_MESSAGE.SET_NAME('MSC', 'MSC_PP_SUCCEED');
54447: ERRBUF:= FND_MESSAGE.GET;