DBA Data[Home] [Help]

APPS.MSC_CL_PRE_PROCESS dependencies on FND_PROFILE

Line 19: v_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), 1);

15: v_process_flag NUMBER:= SYS_NO;
16: --v_debug BOOLEAN := FALSE;
17: v_req_data varchar2(10);
18: v_cal_build boolean := False;
19: v_MSC_CONFIGURATION VARCHAR2(10) := nvl(fnd_profile.value('MSC_X_CONFIGURATION'), 1);
20: v_my_company VARCHAR2(1000) := MSC_ST_UTIL.GET_MY_COMPANY;
21:
22:
23: -- User Environment --

Line 218: fnd_profile.get('ECX_SYS_ADMIN_EMAIL',lv_protocol_address);

214: fnd_message.set_name ('ECX', 'ECX_TP_ADMIN_EMAIL_NOT_FOUND');
215: fnd_message.set_token ('TP_ID', c.party_site_id);
216: lv_errbuf := fnd_message.get;
217: LOG_MESSAGE( lv_errbuf);
218: fnd_profile.get('ECX_SYS_ADMIN_EMAIL',lv_protocol_address);
219: END IF;
220:
221: lv_pointer:= 3;
222: IF lv_protocol_address IS NULL THEN

Line 412: lv_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');

408: BEGIN
409:
410: IF (v_install_msd) THEN
411:
412: lv_direct_load_profile := (fnd_profile.value('MSD_ONE_STEP_COLLECTION')='Y');
413:
414: --IF ((v_level_assoc_enabled = SYS_YES) OR (v_item_rollup = SYS_YES) ) THEN
415: IF ((v_level_assoc_enabled = SYS_YES) OR (v_level_value_enabled = SYS_YES) OR (v_item_rollup = SYS_YES) ) THEN
416: lv_launch_lvalue := SYS_YES;

Line 2882: lv_msc_config := FND_PROFILE.VALUE('MSC_X_CONFIGURATION');

2878:
2879:
2880: -- check whether SCE is installed
2881: BEGIN
2882: lv_msc_config := FND_PROFILE.VALUE('MSC_X_CONFIGURATION');
2883:
2884: EXCEPTION
2885: when others then
2886: lv_msc_config := 1;

Line 24089: IF NVL(FND_PROFILE.VALUE('MSC_DEFAULT_SERIAL_CONTROL'),'Y') ='Y' THEN

24085: RAISE ex_logging_err;
24086: END IF;
24087:
24088: -- If the Serial Number Validation is enabled.
24089: IF NVL(FND_PROFILE.VALUE('MSC_DEFAULT_SERIAL_CONTROL'),'Y') ='Y' THEN
24090:
24091: -- Assumes the org_id,inventory_item_id and sr_instance_id is derrived by now.
24092: -- Set the error message
24093:

Line 57783: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

57779: BEGIN
57780: msc_util.print_trace_file_name(FND_GLOBAL.CONC_REQUEST_ID);
57781: -- ===== Switch on/ off debug based on MRP: Debug Profile
57782:
57783: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
57784:
57785: -- bug 3304390
57786: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN
57787: -- dbms_session.set_sql_trace(true);

Line 57786: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN

57782:
57783: v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
57784:
57785: -- bug 3304390
57786: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN
57787: -- dbms_session.set_sql_trace(true);
57788: -- END IF;
57789:
57790: ---========Initialize the global variables ========

Line 57839: PBS := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));

57835:
57836:
57837: v_monitor_request_id := p_monitor_request_id;
57838:
57839: PBS := TO_NUMBER( FND_PROFILE.VALUE('MRP_PURGE_BATCH_SIZE'));
57840:
57841: IF fnd_global.conc_request_id > 0 THEN
57842: v_cp_enabled:= SYS_YES;
57843: ELSE

Line 58141: lv_plan_per_profile NUMBER:=nvl(fnd_profile.value('MSD_PLANNING_PERCENTAGE'), G_NO_PLAN_PERCENTAGE);

58137: lv_collection_plan_exists PLS_INTEGER := 0;
58138: lv_is_build_over NUMBER;
58139: lv_monitor_id PLS_INTEGER;
58140:
58141: lv_plan_per_profile NUMBER:=nvl(fnd_profile.value('MSD_PLANNING_PERCENTAGE'), G_NO_PLAN_PERCENTAGE);
58142: lv_retval BOOLEAN;
58143: lv_dummy1 VARCHAR2(32) := '';
58144: lv_dummy2 VARCHAR2(32) := '';
58145: lv_count PLS_INTEGER; --8725891

Line 58234: -- v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';

58230:
58231:
58232: -- ===== Switch on/ off debug based on MRP: Debug Profile
58233:
58234: -- v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
58235:
58236: -- bug 3304390
58237: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN
58238: -- dbms_session.set_sql_trace(true);

Line 58237: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN

58233:
58234: -- v_debug := FND_PROFILE.VALUE('MRP_DEBUG') = 'Y';
58235:
58236: -- bug 3304390
58237: -- IF FND_PROFILE.VALUE('MRP_TRACE') = 'Y' THEN
58238: -- dbms_session.set_sql_trace(true);
58239: -- END IF;
58240:
58241: -- Print the parameters coming in