DBA Data[Home] [Help]

APPS.CSD_PROCESS_UTIL dependencies on FND_PROFILE

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

644: IF (x_return_status <> CSD_PROCESS_UTIL.G_RET_STS_SUCCESS) THEN
645: csd_gen_utility_pvt.ADD('Error in Deriving the Operating Unit ');
646: END IF;
647: ELSE
648: Fnd_Profile.Get('ORG_ID',l_operating_unit);
649: END IF;
650:
651: csd_gen_utility_pvt.add('l_operating_unit ='||l_operating_unit);
652:

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

1005: END IF;
1006:
1007:
1008: -- Get the price_list
1009: l_price_list_id := NVL(l_price_list_header_id,FND_PROFILE.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
1010:
1011: -- Get the return reason
1012: l_return_reason := FND_PROFILE.value('CSD_DEF_RMA_RETURN_REASON');
1013:

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

1008: -- Get the price_list
1009: l_price_list_id := NVL(l_price_list_header_id,FND_PROFILE.value('CS_CHARGE_DEFAULT_PRICE_LIST'));
1010:
1011: -- Get the return reason
1012: l_return_reason := FND_PROFILE.value('CSD_DEF_RMA_RETURN_REASON');
1013:
1014: IF (g_debug > 0 ) THEN
1015: csd_gen_utility_pvt.add('l_price list_id ='||l_price_list_id);
1016: END IF;

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

1207: END IF;
1208:
1209:
1210: -- bug fix for 4108369, Begin
1211: l_sr_add_to_order_flag := fnd_profile.value('CSD_ADD_TO_SO_WITHIN_SR');
1212: l_sr_add_to_order_flag := nvl(l_sr_Add_to_order_flag, 'N');
1213:
1214: if(l_sr_add_to_order_flag = 'Y') THEN
1215: l_add_rma_to_id := get_sr_add_to_order(p_repair_line_Id, 'RMA');

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

1216: l_add_ship_to_id := get_sr_add_to_order(p_repair_line_Id, 'SHIP');
1217: END IF;
1218: -- bug fix for 4108369, End
1219:
1220: l_return_days := nvl(FND_PROFILE.value('CSD_PRODUCT_RETURN_DAYS'),0); /*Fixed for FP bug#5408047*/
1221: --Bug fix 5494219 Begin
1222: l_sub_inv := FND_PROFILE.value('CSD_DEF_RMA_SUBINV');
1223: --Bug fix 5494219 End
1224:

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

1218: -- bug fix for 4108369, End
1219:
1220: l_return_days := nvl(FND_PROFILE.value('CSD_PRODUCT_RETURN_DAYS'),0); /*Fixed for FP bug#5408047*/
1221: --Bug fix 5494219 Begin
1222: l_sub_inv := FND_PROFILE.value('CSD_DEF_RMA_SUBINV');
1223: --Bug fix 5494219 End
1224:
1225:
1226: /* bug#3875036 --begin here--*/

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

1224:
1225:
1226: /* bug#3875036 --begin here--*/
1227:
1228: l_enable_advanced_pricing := FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING');
1229: l_enable_advanced_pricing := nvl(l_enable_advanced_pricing, 'N');
1230: IF(l_enable_advanced_pricing ='Y') THEN
1231: l_account_id := CSD_CHARGE_LINE_UTIL.Get_SR_AccountId(p_repair_line_id);
1232: l_currency_code := GET_PL_CURRENCY_CODE(l_price_list_id);

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

1403: x_prod_txn_tbl(l_index).task_id := l_task_id;
1404: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
1405:
1406: -- picking rule changes for R12
1407: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
1408: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
1409: --------------------------------
1410:
1411: l_attr_code := 'SHIP_FROM_ORG';

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

1770: x_prod_txn_tbl(l_index).task_id := l_task_id;
1771: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
1772:
1773: -- picking rule changes for R12
1774: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
1775: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
1776: --------------------------------
1777:
1778: l_attr_code := 'SHIP_FROM_ORG';

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

1940: x_prod_txn_tbl(l_index).task_id := l_task_id;
1941: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
1942:
1943: -- picking rule changes for R12
1944: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
1945: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
1946: --------------------------------
1947:
1948: l_attr_code := 'SHIP_FROM_ORG';

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

2274: x_prod_txn_tbl(l_index).task_id := l_task_id;
2275: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2276:
2277: -- picking rule changes for R12
2278: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2279: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2280: --------------------------------
2281:
2282: l_attr_code := 'SHIP_FROM_ORG';

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

2606: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2607:
2608:
2609: -- picking rule changes for R12
2610: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2611: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2612: --------------------------------
2613:
2614: l_attr_code := 'SHIP_FROM_ORG';

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

2926: x_prod_txn_tbl(l_index).task_id := l_task_id;
2927: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
2928:
2929: -- picking rule changes for R12
2930: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
2931: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
2932: --------------------------------
2933:
2934: l_attr_code := 'SHIP_FROM_ORG';

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

3255: x_prod_txn_tbl(l_index).task_id := l_task_id;
3256: x_prod_txn_tbl(l_index).unit_number := l_unit_number;
3257:
3258: -- picking rule changes for R12
3259: Fnd_Profile.Get('CSD_DEF_PICK_RELEASE_RULE',l_picking_rule_id);
3260: x_prod_txn_tbl(l_index).picking_rule_id := l_picking_rule_id;
3261: --------------------------------
3262:
3263: l_attr_code := 'SHIP_FROM_ORG';

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

3779: ------------------------------------------------------
3780: -- If not Multiorg derive org from MO operating Unit
3781: ------------------------------------------------------
3782:
3783: FND_PROFILE.Get('ORG_ID', l_org_id);
3784:
3785: END IF;
3786: RETURN l_org_id;
3787:

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

4793: --
4794:
4795: l_contract_line_id NUMBER := NULL;
4796: l_billing_pl_id NUMBER := NULL;
4797: l_profile_pl_id NUMBER := fnd_profile.value('CSD_DEFAULT_PRICE_LIST');
4798: l_use_pl BOOLEAN;
4799: l_date DATE := sysdate;
4800: l_pl_out_tbl OKS_CON_COVERAGE_PUB.pricing_tbl_type;
4801: i NUMBER := 1;

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

5084: --bug#7140580 if the profile CSD PL_Derivation Exclude Contract Header
5085: --set to 'Yes', then we will not get the default price list from
5086: --the contract header.
5087: --bug#7140580
5088: IF (l_billing_pl_id IS NOT NULL) and ((nvl(FND_PROFILE.VALUE('CSD_PL_DR_EXCLUDE_CONTRACT_H'), 'N')) = 'N') then
5089:
5090: x_contract_pl_id := l_billing_pl_id;
5091: x_currency_code := CSD_CHARGE_LINE_UTIL.Get_PLCurrCode(x_contract_pl_id);
5092: x_profile_pl_id := NULL;

Line 5199: IF(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING')='N') THEN

5195: -- Initialize API return status to success
5196: x_return_status := FND_API.G_RET_STS_SUCCESS;
5197:
5198: --bug#3875036
5199: IF(FND_PROFILE.VALUE('CSD_ENABLE_ADVANCED_PRICING')='N') THEN
5200:
5201: Cs_Pricing_Item_Pkg.Call_Pricing_Item
5202: (p_inventory_item_id => p_inventory_item_id,
5203: p_price_list_id => p_price_list_header_id,