DBA Data[Home] [Help]

APPS.CSD_REPAIR_ESTIMATE_PVT dependencies on FND_PROFILE

Line 18: G_DEBUG_LEVEL CONSTANT NUMBER := TO_NUMBER(NVL(Fnd_Profile.value('CSD_DEBUG_LEVEL'),

14: C_EST_STATUS_REJECTED CONSTANT VARCHAR2(30) := 'REJECTED';
15: C_EST_STATUS_NEW CONSTANT VARCHAR2(30) := 'NEW';
16: C_REP_STATUS_APPROVED CONSTANT VARCHAR2(30) := 'A';
17: C_REP_STATUS_REJECTED CONSTANT VARCHAR2(30) := 'R';
18: G_DEBUG_LEVEL CONSTANT NUMBER := TO_NUMBER(NVL(Fnd_Profile.value('CSD_DEBUG_LEVEL'),
19: '0'));
20: ----End change for 3931317, wrpper aPI forward port
21:
22: -- swai: Bug 14804275 FP of bug 14752421 - begin change for create estimate from WIP

Line 659: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then

655: p_api_name => l_api_name);
656: END IF;
657: -- Dump the in parameters in the log file
658: -- if the debug level > 5
659: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
660: -- IF (g_debug > 5)
661: -- THEN
662: -- Csd_Gen_Utility_Pvt.dump_estimate_rec(p_estimate_rec => x_estimate_rec);
663: -- END IF;

Line 937: --If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then

933: p_api_name => l_api_name);
934: END IF;
935: -- Dump the in parameters in the log file
936: -- if the debug level > 5
937: --If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
938: -- IF (g_debug > 5)
939: -- THEN
940: -- Csd_Gen_Utility_Pvt.dump_estimate_rec(p_estimate_rec => x_estimate_rec);
941: -- END IF;

Line 1469: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then

1465: p_api_name => l_api_name);
1466: END IF;
1467: -- Dump the in parameters in the log file
1468: -- if the debug level > 5
1469: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
1470: -- IF (g_debug > 5)
1471: -- THEN
1472: -- Csd_Gen_Utility_Pvt.dump_estimate_line_rec(p_estimate_line_rec => x_estimate_line_rec);
1473: -- END IF;

Line 2020: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then

2016: p_api_name => l_api_name);
2017: END IF;
2018: -- Dump the in parameters in the log file
2019: -- if the debug level > 5
2020: -- If fnd_profile.value('CSD_DEBUG_LEVEL') > 5 then
2021: -- IF (g_debug > 5)
2022: -- THEN
2023: -- Csd_Gen_Utility_Pvt.dump_estimate_line_rec(p_estimate_line_rec => x_estimate_line_rec);
2024: -- END IF;

Line 2657: l_printer_name := Fnd_Profile.value('CSD_PRINTER_NAME');

2653: END IF;
2654: -- Initialize API return status to success
2655: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2656: -- start of the concurrent submission
2657: l_printer_name := Fnd_Profile.value('CSD_PRINTER_NAME');
2658: IF (g_debug > 0)
2659: THEN
2660: Csd_Gen_Utility_Pvt.ADD('l_printer_name =' || l_printer_name);
2661: END IF;

Line 2663: -- l_print_required := fnd_profile.value('CSD_EST_PRINTER_REQ');

2659: THEN
2660: Csd_Gen_Utility_Pvt.ADD('l_printer_name =' || l_printer_name);
2661: END IF;
2662: -- Check if the printer setup is required
2663: -- l_print_required := fnd_profile.value('CSD_EST_PRINTER_REQ');
2664: -- For bugfix 3398079. vkjain.
2665: -- The profile name was misspelt.
2666: l_print_required := Fnd_Profile.value('CSD_PRINTER_REQ');
2667: IF (g_debug > 0)

Line 2666: l_print_required := Fnd_Profile.value('CSD_PRINTER_REQ');

2662: -- Check if the printer setup is required
2663: -- l_print_required := fnd_profile.value('CSD_EST_PRINTER_REQ');
2664: -- For bugfix 3398079. vkjain.
2665: -- The profile name was misspelt.
2666: l_print_required := Fnd_Profile.value('CSD_PRINTER_REQ');
2667: IF (g_debug > 0)
2668: THEN
2669: Csd_Gen_Utility_Pvt.ADD('l_print_required =' ||
2670: l_print_required);

Line 2703: l_print_mode := FND_PROFILE.value('CSD_ESTRT_PRINT_MODE');

2699: Fnd_Msg_Pub.ADD;
2700: END IF;
2701: -- valase:6499519, rfieldma: 6532016 below
2702: -- get print mode
2703: l_print_mode := FND_PROFILE.value('CSD_ESTRT_PRINT_MODE');
2704:
2705: IF (l_print_mode is not null and l_print_mode <> 'ORAPT' ) THEN -- one of the XDO output types
2706: --get concurrent name
2707: l_xdo_conc_name :=FND_PROFILE.value('CSD_CUST_ESTRT_CON_NAME');

Line 2707: l_xdo_conc_name :=FND_PROFILE.value('CSD_CUST_ESTRT_CON_NAME');

2703: l_print_mode := FND_PROFILE.value('CSD_ESTRT_PRINT_MODE');
2704:
2705: IF (l_print_mode is not null and l_print_mode <> 'ORAPT' ) THEN -- one of the XDO output types
2706: --get concurrent name
2707: l_xdo_conc_name :=FND_PROFILE.value('CSD_CUST_ESTRT_CON_NAME');
2708: IF l_xdo_conc_name is null THEN
2709: l_xdo_conc_name := 'CSDERT';
2710: END IF;
2711: -- get default template code

Line 3393: (NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'), 'N') = 'N')

3389: -- bug fix 3388891
3390: -- only give an error if it is wip or if
3391: -- in task mode profile option is not set to get tasks from soln
3392: IF (p_repair_mode = 'WIP') OR
3393: (NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'), 'N') = 'N')
3394: THEN
3395: RAISE CSD_EST_SC_NO_APPL;
3396: END IF;
3397: END IF;

Line 4730: l_labor_inventory_item_id := Fnd_Profile.value('CSD_DEFAULT_EST_LABOR');

4726: 'p_contract_line_id: ' || p_contract_line_id);
4727: END IF;
4728:
4729: -- get labor inventory item from profile option
4730: l_labor_inventory_item_id := Fnd_Profile.value('CSD_DEFAULT_EST_LABOR');
4731:
4732: -- get use tasks from solution profile option
4733: l_use_tasks_from_sol := NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'),
4734: 'N');

Line 4733: l_use_tasks_from_sol := NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'),

4729: -- get labor inventory item from profile option
4730: l_labor_inventory_item_id := Fnd_Profile.value('CSD_DEFAULT_EST_LABOR');
4731:
4732: -- get use tasks from solution profile option
4733: l_use_tasks_from_sol := NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'),
4734: 'N');
4735:
4736: -- get threshold for tasks - to be used when determining manual vs rollup qty
4737: l_task_threshold := TO_NUMBER(NVL(Fnd_Profile.value('CSP_PROD_TASK_HIST_RULE'),

Line 4737: l_task_threshold := TO_NUMBER(NVL(Fnd_Profile.value('CSP_PROD_TASK_HIST_RULE'),

4733: l_use_tasks_from_sol := NVL(Fnd_Profile.value('CSD_USE_TASK_FROM_SOLN'),
4734: 'N');
4735:
4736: -- get threshold for tasks - to be used when determining manual vs rollup qty
4737: l_task_threshold := TO_NUMBER(NVL(Fnd_Profile.value('CSP_PROD_TASK_HIST_RULE'),
4738: '0'));
4739:
4740: IF (Fnd_Log.Level_Statement >= Fnd_Log.G_Current_Runtime_Level)
4741: THEN

Line 8181: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN

8177: DECLARE
8178: l_count NUMBER := 0;
8179: BEGIN
8180:
8181: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN
8182: if (nvl(fnd_profile.value('CSD_IMPORT_WIP_TO_ESTIMATES_NET_QTY'),'Y') = 'N') THEN
8183: if (lc_stat_level >= lc_debug_level) then
8184: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8185: 'Begin: loop through the cursor c_est_lines_from_materials1.');

Line 8182: if (nvl(fnd_profile.value('CSD_IMPORT_WIP_TO_ESTIMATES_NET_QTY'),'Y') = 'N') THEN

8178: l_count NUMBER := 0;
8179: BEGIN
8180:
8181: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN
8182: if (nvl(fnd_profile.value('CSD_IMPORT_WIP_TO_ESTIMATES_NET_QTY'),'Y') = 'N') THEN
8183: if (lc_stat_level >= lc_debug_level) then
8184: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8185: 'Begin: loop through the cursor c_est_lines_from_materials1.');
8186: end if;

Line 8259: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN

8255: end if;
8256: end if;
8257: END IF;
8258:
8259: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_MTL_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN
8260: if (lc_stat_level >= lc_debug_level) then
8261: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8262: 'Begin: loop through the cursor c_est_lines_from_material_reqs.');
8263: end if;

Line 8321: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN

8317: -- the WIP jobs. Getting the table for all the lines.
8318: DECLARE
8319: l_count NUMBER := l_estimate_lines_tbl.count; -- append to the materials in the table
8320: BEGIN
8321: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('TRANS', 'ALL'))) THEN
8322: if (lc_stat_level >= lc_debug_level) then
8323: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8324: 'Begin: loop through the cursor c_est_lines_from_resources.');
8325: end if;

Line 8360: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN

8356: 'End: loop through the cursor c_est_lines_from_resources.');
8357: end if;
8358: END IF;
8359:
8360: IF ((nvl(fnd_profile.value('CSD_IMPORT_WIP_RES_TO_ESTIMATES'),'NONE') in ('UNTRANS', 'ALL'))) THEN
8361: if (lc_stat_level >= lc_debug_level) then
8362: FND_LOG.STRING(lc_stat_level, lc_mod_name,
8363: 'Begin: loop through the cursor c_est_lines_from_resource_reqs.');
8364: end if;