DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on FND_PROFILE

Line 656: Fnd_Profile.Get('ORG_ID',l_operating_unit);

652: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN
653: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');
654: END IF;
655: ELSE
656: Fnd_Profile.Get('ORG_ID',l_operating_unit);
657: END IF;
658:
659: csd_gen_utility_pvt.add('l_operating_unit ='||l_operating_unit);
660:

Line 1034: l_price_list_id := NVL(l_price_list_header_id,FND_PROFILE.value('CS_CHARGE_DEFAULT_PRICE_LIST'));

1030: END IF;
1031:
1032:
1033: -- Get the price_list
1034: l_price_list_id := NVL(l_price_list_header_id,FND_PROFILE.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
1035:
1036: -- Get the return reason
1037: -- modified by subhat to get the value from procedure param if passed.
1038: IF p_return_reason_code IS NULL

Line 1040: l_return_reason := FND_PROFILE.value('CSD_DEF_RMA_RETURN_REASON');

1036: -- Get the return reason
1037: -- modified by subhat to get the value from procedure param if passed.
1038: IF p_return_reason_code IS NULL
1039: THEN
1040: l_return_reason := FND_PROFILE.value('CSD_DEF_RMA_RETURN_REASON');
1041: ELSE
1042: l_return_reason := p_return_reason_code;
1043: END IF;
1044:

Line 1253: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');

1249: END IF;
1250:
1251:
1252: -- bug fix for 4108369, Begin
1253: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
1254: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');
1255:
1256: if(l_sr_add_to_order_flag = 'Y') THEN
1257: l_add_rma_to_id := get_sr_add_to_order(p_repair_line_Id, 'RMA');

Line 1262: l_return_days := nvl(FND_PROFILE.value('CSD_PRODUCT_RETURN_DAYS'),0); /*Fixed for FP bug#5408047*/

1258: l_add_ship_to_id := get_sr_add_to_order(p_repair_line_Id, 'SHIP');
1259: END IF;
1260: -- bug fix for 4108369, End
1261:
1262: l_return_days := nvl(FND_PROFILE.value('CSD_PRODUCT_RETURN_DAYS'),0); /*Fixed for FP bug#5408047*/
1263: --Bug fix 5494219 Begin
1264: l_sub_inv := FND_PROFILE.value('CSD_DEF_RMA_SUBINV');
1265: --Bug fix 5494219 End
1266:

Line 1264: l_sub_inv := FND_PROFILE.value('CSD_DEF_RMA_SUBINV');

1260: -- bug fix for 4108369, End
1261:
1262: l_return_days := nvl(FND_PROFILE.value('CSD_PRODUCT_RETURN_DAYS'),0); /*Fixed for FP bug#5408047*/
1263: --Bug fix 5494219 Begin
1264: l_sub_inv := FND_PROFILE.value('CSD_DEF_RMA_SUBINV');
1265: --Bug fix 5494219 End
1266:
1267:
1268: /* bug#3875036 --begin here--*/

Line 1270: l_enable_advanced_pricing := FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING');

1266:
1267:
1268: /* bug#3875036 --begin here--*/
1269:
1270: l_enable_advanced_pricing := FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING');
1271: l_enable_advanced_pricing := nvl(l_enable_advanced_pricing, 'N');
1272: IF(l_enable_advanced_pricing ='Y') THEN
1273: l_account_id := CSD_CHARGE_LINE_UTIL.Get_SR_AccountId(p_repair_line_id);
1274: l_currency_code := GET_PL_CURRENCY_CODE(l_price_list_id);

Line 1294: l_default_logistics_warehouse := nvl(FND_PROFILE.value('CSD_DEFAULT_LOGISTICS_WAREHOUSE'), 'Y');

1290:
1291: /* bug#3875036 --end here--*/
1292:
1293: --bug#11769559
1294: l_default_logistics_warehouse := nvl(FND_PROFILE.value('CSD_DEFAULT_LOGISTICS_WAREHOUSE'), 'Y');
1295: --bug#11769559
1296:
1297: --defaulting rule value
1298: l_attr_type := 'CSD_DEF_ENTITY_ATTR_RO';

Line 1453: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

1449: x_prod_txn_tbl(l_index).task_id := l_task_id;
1450: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
1451:
1452: -- picking rule changes for R12
1453: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
1454: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
1455: --------------------------------
1456:
1457: --bug#11769559

Line 1841: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

1837: x_prod_txn_tbl(l_index).task_id := l_task_id;
1838: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
1839:
1840: -- picking rule changes for R12
1841: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
1842: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
1843: --------------------------------
1844: --bug#11769559
1845: If (l_default_logistics_warehouse = 'Y') Then

Line 2024: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

2020: x_prod_txn_tbl(l_index).task_id := l_task_id;
2021: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2022:
2023: -- picking rule changes for R12
2024: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2025: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2026: --------------------------------
2027:
2028: --bug#11769559

Line 2387: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

2383: x_prod_txn_tbl(l_index).task_id := l_task_id;
2384: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2385:
2386: -- picking rule changes for R12
2387: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2388: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2389: --------------------------------
2390:
2391: --bug#11769559

Line 2745: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

2741: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2742:
2743:
2744: -- picking rule changes for R12
2745: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2746: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2747: --------------------------------
2748:
2749: --bug#11769559

Line 3095: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

3091: x_prod_txn_tbl(l_index).task_id := l_task_id;
3092: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
3093:
3094: -- picking rule changes for R12
3095: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
3096: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
3097: --------------------------------
3098:
3099: --bug#11769559

Line 3461: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);

3457: x_prod_txn_tbl(l_index).task_id := l_task_id;
3458: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
3459:
3460: -- picking rule changes for R12
3461: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
3462: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
3463: --------------------------------
3464:
3465: --bug#11769559

Line 4014: FND_PROFILE.Get('ORG_ID', l_org_id);

4010: ------------------------------------------------------
4011: -- If not Multiorg derive org from MO operating Unit
4012: ------------------------------------------------------
4013:
4014: FND_PROFILE.Get('ORG_ID', l_org_id);
4015:
4016: END IF;
4017: RETURN l_org_id;
4018:

Line 5063: l_profile_pl_id NUMBER := fnd_profile.value('CSD_DEFAULT_PRICE_LIST');

5059: --
5060:
5061: l_contract_line_id NUMBER := NULL;
5062: l_billing_pl_id NUMBER := NULL;
5063: l_profile_pl_id NUMBER := fnd_profile.value('CSD_DEFAULT_PRICE_LIST');
5064: l_use_pl BOOLEAN;
5065: l_date DATE := sysdate;
5066: l_pl_out_tbl OKS_CON_COVERAGE_PUB.pricing_tbl_type;
5067: i NUMBER := 1;

Line 5354: IF (l_billing_pl_id IS NOT NULL) and ((nvl(FND_PROFILE.VALUE('CSD_PL_DR_EXCLUDE_CONTRACT_H'), 'N')) = 'N') then

5350: --bug#7140580 if the profile CSD PL_Derivation Exclude Contract Header
5351: --set to 'Yes', then we will not get the default price list from
5352: --the contract header.
5353: --bug#7140580
5354: IF (l_billing_pl_id IS NOT NULL) and ((nvl(FND_PROFILE.VALUE('CSD_PL_DR_EXCLUDE_CONTRACT_H'), 'N')) = 'N') then
5355:
5356: x_contract_pl_id := l_billing_pl_id;
5357: x_currency_code := CSD_CHARGE_LINE_UTIL.Get_PLCurrCode(x_contract_pl_id);
5358: x_profile_pl_id := NULL;

Line 5491: IF ((NVL(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING'), 'N')='Y')

5487: --this check if the only the both of the profile set to YES.
5488: --the pricelist has comments end of '999',
5489: --and the pricelist has any dynmaic formula attached to it.
5490: --then, we will call Charge/Order Capture pricing API
5491: IF ((NVL(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING'), 'N')='Y')
5492: and (NVL(FND_PROFILE.VALUE('CSD_ENABLE_DYNAMIC_FORMULA'), 'N')='Y')) THEN
5493:
5494: open get_pricelist_comment(p_price_list_header_id);
5495: fetch get_pricelist_comment into l_pricelist_comment;

Line 5492: and (NVL(FND_PROFILE.VALUE('CSD_ENABLE_DYNAMIC_FORMULA'), 'N')='Y')) THEN

5488: --the pricelist has comments end of '999',
5489: --and the pricelist has any dynmaic formula attached to it.
5490: --then, we will call Charge/Order Capture pricing API
5491: IF ((NVL(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING'), 'N')='Y')
5492: and (NVL(FND_PROFILE.VALUE('CSD_ENABLE_DYNAMIC_FORMULA'), 'N')='Y')) THEN
5493:
5494: open get_pricelist_comment(p_price_list_header_id);
5495: fetch get_pricelist_comment into l_pricelist_comment;
5496: close get_pricelist_comment;

Line 5507: IF((NVL(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING'), 'N')='N') or (NVL(l_dynamic_formula, 'N') = 'Y')) THEN -- swai: bug 11730709 (FP of bug#11720454)

5503: END IF;
5504: -- end swai: bug 11730709 (FP of bug#11720454)
5505:
5506: --bug#3875036
5507: IF((NVL(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING'), 'N')='N') or (NVL(l_dynamic_formula, 'N') = 'Y')) THEN -- swai: bug 11730709 (FP of bug#11720454)
5508:
5509: Cs_Pricing_Item_Pkg.Call_Pricing_Item
5510: (p_inventory_item_id => p_inventory_item_id,
5511: p_price_list_id => p_price_list_header_id,

Line 6239: l_override_negative_qty := fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');

6235: END;
6236: g_negative_inventory(p_org_id) := l_negative_inv_allowed;
6237: END IF;
6238: IF l_override_negative_qty IS NULL THEN
6239: l_override_negative_qty := fnd_profile.value('INV_OVERRIDE_NEG_FOR_BACKFLUSH');
6240: g_override_negative_qty(p_org_id) := l_override_negative_qty ;
6241: END IF;
6242:
6243: --bug#13498183