eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_OFFER_PVT dependencies on FND_PROFILE

Line 727: l_promotional_offers_rec.autopay_days := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_DAYS');

723: /*
724: IF p_advanced_options_rec.autopay_days IS NOT NULL THEN
725: l_promotional_offers_rec.autopay_days := p_advanced_options_rec.autopay_days;
726: ELSE
727: l_promotional_offers_rec.autopay_days := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_DAYS');
728: END IF;
729:
730: IF p_advanced_options_rec.autopay_method IS NOT NULL THEN
731: l_promotional_offers_rec.autopay_method := p_advanced_options_rec.autopay_method;

Line 733: l_promotional_offers_rec.autopay_method := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_METHOD');

729:
730: IF p_advanced_options_rec.autopay_method IS NOT NULL THEN
731: l_promotional_offers_rec.autopay_method := p_advanced_options_rec.autopay_method;
732: ELSE
733: l_promotional_offers_rec.autopay_method := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_METHOD');
734: END IF;
735: */
736: l_promotional_offers_rec.autopay_party_attr := p_advanced_options_rec.autopay_party_attr;
737: l_promotional_offers_rec.autopay_party_id := p_advanced_options_rec.autopay_party_id;

Line 1968: l_act_budgets_rec.request_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));

1964: l_act_budgets_rec.budget_source_id := p_modifier_list_rec.budget_source_id;
1965: l_act_budgets_rec.budget_source_type := p_modifier_list_rec.budget_source_type;--'FUND';
1966: l_act_budgets_rec.transfer_type := 'REQUEST';
1967: l_act_budgets_rec.arc_act_budget_used_by := 'OFFR';
1968: l_act_budgets_rec.request_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1969: l_act_budgets_rec.approved_in_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1970: IF p_modifier_list_rec.offer_type = 'SCAN_DATA' THEN
1971: IF p_modifier_list_rec.offer_amount = fnd_api.g_miss_num THEN -- calling from offer detail
1972: l_act_budgets_rec.request_amount := p_modifier_list_rec.budget_amount_tc;

Line 1969: l_act_budgets_rec.approved_in_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));

1965: l_act_budgets_rec.budget_source_type := p_modifier_list_rec.budget_source_type;--'FUND';
1966: l_act_budgets_rec.transfer_type := 'REQUEST';
1967: l_act_budgets_rec.arc_act_budget_used_by := 'OFFR';
1968: l_act_budgets_rec.request_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1969: l_act_budgets_rec.approved_in_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1970: IF p_modifier_list_rec.offer_type = 'SCAN_DATA' THEN
1971: IF p_modifier_list_rec.offer_amount = fnd_api.g_miss_num THEN -- calling from offer detail
1972: l_act_budgets_rec.request_amount := p_modifier_list_rec.budget_amount_tc;
1973: END IF;

Line 3408: l_recal := NVL(FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'Y');

3404: OPEN c_approved_amount(l_offers_rec.qp_list_header_id);
3405: FETCH c_approved_amount INTO l_approved_amount;
3406: CLOSE c_approved_amount;
3407:
3408: l_recal := NVL(FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'Y');
3409: --julou checking approved amount vs committed amount for recal=N and lumpsum, scan_data
3410: IF l_recal = 'N' OR (l_recal = 'Y' AND p_offer_rec.offer_type IN ('LUMPSUM', 'SCAN_DATA')) THEN
3411: -- populate committed amount
3412: IF p_offer_rec.offer_type = 'SCAN_DATA' THEN

Line 3974: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');

3970: x_msg_count => x_msg_count,
3971: x_msg_data => x_msg_data,
3972: p_offer_rec => p_offer_rec
3973: );
3974: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');
3975: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3976: --julou amount validation failed, update status depending on recal
3977: IF p_called_from = 'R' THEN
3978: IF p_offer_rec.offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

Line 4500: l_modifier_list_rec.source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');

4496:
4497: l_modifier_list_rec.operation := p_modifier_list_rec.modifier_operation;
4498: l_modifier_list_rec.list_header_id := p_modifier_list_rec.qp_list_header_id ;
4499: l_modifier_list_rec.list_type_code := 'PRO';
4500: l_modifier_list_rec.source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
4501: l_modifier_list_rec.description := p_modifier_list_rec.description;
4502: l_modifier_list_rec.comments := p_modifier_list_rec.comments;
4503: l_modifier_list_rec.currency_code := p_modifier_list_rec.currency_code;
4504: l_modifier_list_rec.start_date_active := trunc(p_modifier_list_rec.start_date_active);

Line 4631: IF p_modifier_list_rec.offer_type NOT IN ('LUMPSUM','SCAN_DATA') AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') = 'OFF' THEN

4627: This code only makes sure that if the profile is OFF then the global flag is Y., to get rid of qp_list_header creation errors
4628: */
4629: --Bugfix : 12649016
4630: /*IF p_modifier_list_rec.modifier_operation = 'UPDATE' THEN
4631: IF p_modifier_list_rec.offer_type NOT IN ('LUMPSUM','SCAN_DATA') AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') = 'OFF' THEN
4632: l_modifier_list_rec.global_flag := 'Y';
4633: l_modifier_list_rec.org_id := NULL;
4634: ELSE
4635: l_modifier_list_rec.global_flag := p_modifier_list_rec.global_flag;

Line 4643: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') = 'OFF' THEN

4639: -- nepanda : Fix for Bug # 14500493
4640: -- When QP_SECURITY_CONTROL is OFF then GLOBAL FLAG will be always Y
4641: -- When QP_SECURITY_CONTROL is ON then taking GLOBAL FLAG from offer rec as it can be 1. Y with Org id = null OR 2. N with Org id = Not Null
4642: IF p_modifier_list_rec.offer_type NOT IN ('LUMPSUM','SCAN_DATA') THEN
4643: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') = 'OFF' THEN
4644: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header QP_SECURITY_CONTROL =OFF ---qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);
4645: l_modifier_list_rec.global_flag := 'Y';
4646: l_modifier_list_rec.org_id := NULL;
4647: ELSE

Line 5323: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

5319: l_pricingPhase NUMBER;
5320: BEGIN
5321: CASE getDiscountLevel(p_listHeaderId => p_listHeaderId)
5322: WHEN 'LINEGROUP' THEN
5323: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5324: WHEN 'LINE' THEN
5325: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
5326: WHEN 'ORDER' THEN
5327: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

Line 5325: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');

5321: CASE getDiscountLevel(p_listHeaderId => p_listHeaderId)
5322: WHEN 'LINEGROUP' THEN
5323: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5324: WHEN 'LINE' THEN
5325: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
5326: WHEN 'ORDER' THEN
5327: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
5328: ELSE
5329: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

Line 5327: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

5323: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5324: WHEN 'LINE' THEN
5325: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
5326: WHEN 'ORDER' THEN
5327: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
5328: ELSE
5329: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5330: END CASE;
5331: RETURN l_pricingPhase;

Line 5329: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

5325: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
5326: WHEN 'ORDER' THEN
5327: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
5328: ELSE
5329: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5330: END CASE;
5331: RETURN l_pricingPhase;
5332: END getPricingPhase;
5333:

Line 5353: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

5349: x_modifiersTbl(l_index).list_header_id := p_modifierLineRec.list_header_id;
5350: x_modifiersTbl(l_index).arithmetic_operator := NVL(p_modifierLineRec.arithmetic_operator, '%');
5351: x_modifiersTbl(l_index).operand := 0;
5352: x_modifiersTbl(l_index).proration_type_code := 'N';
5353: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5354:
5355: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5356: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5357: END IF;

Line 5356: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

5352: x_modifiersTbl(l_index).proration_type_code := 'N';
5353: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5354:
5355: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5356: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5357: END IF;
5358: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';
5359: x_modifiersTbl(l_index).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
5360: x_modifiersTbl(l_index).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);

Line 5389: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

5385: x_modifiersTbl(l_index).list_header_id := p_modifierLineRec.list_header_id;
5386: x_modifiersTbl(l_index).arithmetic_operator := NVL(p_modifierLineRec.arithmetic_operator, '%');
5387: x_modifiersTbl(l_index).operand := NVL(p_modifierLineRec.operand, 0);
5388: x_modifiersTbl(l_index).proration_type_code := 'N';
5389: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5390: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5391: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5392: END IF;
5393: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';

Line 5391: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

5387: x_modifiersTbl(l_index).operand := NVL(p_modifierLineRec.operand, 0);
5388: x_modifiersTbl(l_index).proration_type_code := 'N';
5389: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5390: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5391: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5392: END IF;
5393: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';
5394: x_modifiersTbl(l_index).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
5395: x_modifiersTbl(l_index).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);

Line 5662: x_modifiersTbl(1).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

5658: IF p_modifierLineRec.operation = 'CREATE' THEN
5659: -- l_child_index := l_child_index + 1;
5660: x_modifiersTbl(1).list_line_type_code := 'PBH' ;
5661: x_modifiersTbl(1).proration_type_code := 'N';
5662: x_modifiersTbl(1).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5663: x_modifiersTbl(1).print_on_invoice_flag := 'Y';
5664: x_modifiersTbl(1).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
5665: x_modifiersTbl(1).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);
5666: x_modifiersTbl(1).price_break_type_code := 'POINT';

Line 5669: x_modifiersTbl(1).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

5665: x_modifiersTbl(1).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);
5666: x_modifiersTbl(1).price_break_type_code := 'POINT';
5667: x_modifiersTbl(1).automatic_flag := 'Y';
5668: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5669: x_modifiersTbl(1).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5670: END IF;
5671: end if;
5672: IF getOfferType(p_listHeaderId => p_modifierLineRec.list_header_id) = 'ACCRUAL' THEN
5673: x_modifiersTbl(1).accrual_flag := 'Y';

Line 6152: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');

6148: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
6149: END IF;
6150: --nepanda fix for forwardport of bug # 8580281 end
6151:
6152: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');
6153: l_list_header_id := p_modifier_line_tbl(p_modifier_line_tbl.last).list_header_id;
6154:
6155: OPEN cur_get_discount_level(l_list_header_id);
6156: FETCH cur_get_discount_level into l_discount_level;

Line 6230: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

6226: CLOSE c_adv_options_exist;
6227:
6228: IF l_adv_options_exist IS NULL THEN
6229: IF l_discount_level = 'LINEGROUP' THEN
6230: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
6231: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6232: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6233: -- END IF;
6234: ELSIF l_discount_level = 'LINE' THEN

Line 6235: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');

6231: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6232: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6233: -- END IF;
6234: ELSIF l_discount_level = 'LINE' THEN
6235: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
6236: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
6237: -- l_modifiers_tbl(i).pricing_phase_id := 2;
6238: -- END IF;
6239: ELSIF l_discount_level = 'ORDER' THEN

Line 6240: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

6236: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
6237: -- l_modifiers_tbl(i).pricing_phase_id := 2;
6238: -- END IF;
6239: ELSIF l_discount_level = 'ORDER' THEN
6240: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
6241: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
6242: -- l_modifiers_tbl(i).pricing_phase_id := 4;
6243: -- END IF;
6244: ELSE

Line 6245: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

6241: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
6242: -- l_modifiers_tbl(i).pricing_phase_id := 4;
6243: -- END IF;
6244: ELSE
6245: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
6246: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6247: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6248: -- END IF;
6249: END IF;

Line 6251: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');

6247: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6248: -- END IF;
6249: END IF;
6250:
6251: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
6252:
6253: IF p_parent_offer_type = 'DEAL' THEN
6254: l_modifiers_tbl(i).incompatibility_grp_code := NULL;
6255: ELSE

Line 6256: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');

6252:
6253: IF p_parent_offer_type = 'DEAL' THEN
6254: l_modifiers_tbl(i).incompatibility_grp_code := NULL;
6255: ELSE
6256: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
6257: END IF;
6258:
6259: IF l_discount_level <> 'ORDER' THEN
6260: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

Line 6260: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

6256: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
6257: END IF;
6258:
6259: IF l_discount_level <> 'ORDER' THEN
6260: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
6261: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN
6262: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
6263: -- END IF;
6264: END IF;

Line 6266: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

6262: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
6263: -- END IF;
6264: END IF;
6265:
6266: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
6267:
6268: ELSE
6269: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
6270: FETCH c_adv_options INTO l_modifiers_tbl(i).pricing_phase_id,l_modifiers_tbl(i).print_on_invoice_flag,l_modifiers_tbl(i).incompatibility_grp_code,l_modifiers_tbl(i).pricing_group_sequence,l_modifiers_tbl(i).product_precedence;

Line 6892: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');

6888: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
6889: RAISE Fnd_Api.g_exc_unexpected_error;
6890: END IF;
6891:
6892: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');
6893: -- update status according to recal flag
6894: UPDATE ozf_offers
6895: SET status_code = DECODE(l_amount_error, 'Y', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'), 'N', 'ACTIVE'),
6896: status_date = SYSDATE,

Line 6910: ELSIF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'Y' THEN

6906: status_date = SYSDATE,
6907: object_version_number = object_version_number + 1,
6908: user_status_id = decode(l_amount_error,'Y',OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING_ACTIVE'),'N',p_new_status_id)
6909: WHERE qp_list_header_id = p_qp_list_header_id;
6910: ELSIF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'Y' THEN
6911: -- if recal='N' if approved>0 -> active(no status change) otherwise draft
6912: OPEN c_approved_amount(p_qp_list_header_id);
6913: FETCH c_approved_amount INTO l_approved_amount;
6914: CLOSE c_approved_amount;

Line 7034: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');

7030: l_end_date DATE;
7031: l_start_date DATE;
7032: BEGIN
7033: x_return_status := Fnd_Api.g_ret_sts_success;
7034: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');
7035: l_list_header_id := p_modifier_line_tbl(p_modifier_line_tbl.last).list_header_id;
7036:
7037: OPEN cur_get_discount_level(l_list_header_id);
7038: FETCH cur_get_discount_level into l_discount_level;

Line 7090: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

7086: CLOSE c_adv_options_exist;
7087:
7088: IF l_adv_options_exist IS NULL THEN
7089: IF l_discount_level = 'LINEGROUP' THEN
7090: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7091: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7092: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7093: -- END IF;
7094: ELSIF l_discount_level = 'LINE' THEN

Line 7095: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');

7091: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7092: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7093: -- END IF;
7094: ELSIF l_discount_level = 'LINE' THEN
7095: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
7096: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7097: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7098: -- END IF;
7099: ELSIF l_discount_level = 'ORDER' THEN

Line 7100: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

7096: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7097: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7098: -- END IF;
7099: ELSIF l_discount_level = 'ORDER' THEN
7100: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
7101: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7102: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7103: -- END IF;
7104: ELSE

Line 7105: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

7101: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7102: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7103: -- END IF;
7104: ELSE
7105: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7106: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7107: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7108: -- END IF;
7109: END IF;

Line 7111: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');

7107: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7108: -- END IF;
7109: END IF;
7110:
7111: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7112: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7113:
7114: IF l_discount_level <> 'ORDER' THEN
7115: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

Line 7112: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');

7108: -- END IF;
7109: END IF;
7110:
7111: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7112: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7113:
7114: IF l_discount_level <> 'ORDER' THEN
7115: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7116: -- IF l_modifiers_tbl(i).pricing_group_sequence <>1 THEN

Line 7115: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

7111: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7112: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7113:
7114: IF l_discount_level <> 'ORDER' THEN
7115: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7116: -- IF l_modifiers_tbl(i).pricing_group_sequence <>1 THEN
7117: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7118: -- END IF;
7119: END IF;

Line 7121: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

7117: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7118: -- END IF;
7119: END IF;
7120:
7121: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
7122:
7123: ELSE
7124: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
7125: FETCH c_adv_options INTO l_modifiers_tbl(i).pricing_phase_id,l_modifiers_tbl(i).print_on_invoice_flag,l_modifiers_tbl(i).incompatibility_grp_code,l_modifiers_tbl(i).pricing_group_sequence,l_modifiers_tbl(i).product_precedence;

Line 7716: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

7712: CLOSE c_adv_options_exist;
7713:
7714: IF l_adv_options_exist IS NULL THEN
7715: IF l_discount_level = 'LINEGROUP' THEN
7716: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7717: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7718: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7719: -- END IF;
7720: ELSIF l_discount_level = 'LINE' THEN

Line 7721: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');

7717: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7718: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7719: -- END IF;
7720: ELSIF l_discount_level = 'LINE' THEN
7721: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
7722: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7723: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7724: -- END IF;
7725: ELSIF l_discount_level = 'ORDER' THEN

Line 7726: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

7722: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7723: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7724: -- END IF;
7725: ELSIF l_discount_level = 'ORDER' THEN
7726: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
7727: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7728: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7729: -- END IF;
7730: ELSE

Line 7731: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

7727: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7728: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7729: -- END IF;
7730: ELSE
7731: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7732: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7733: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7734: -- END IF;
7735: END IF;

Line 7737: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');

7733: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7734: -- END IF;
7735: END IF;
7736:
7737: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7738: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7739:
7740: IF l_discount_level <> 'ORDER' THEN
7741: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

Line 7738: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');

7734: -- END IF;
7735: END IF;
7736:
7737: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7738: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7739:
7740: IF l_discount_level <> 'ORDER' THEN
7741: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7742: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN

Line 7741: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

7737: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7738: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7739:
7740: IF l_discount_level <> 'ORDER' THEN
7741: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7742: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN
7743: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7744: -- END IF;
7745: END IF;

Line 7747: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

7743: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7744: -- END IF;
7745: END IF;
7746:
7747: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
7748:
7749: ELSE
7750: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
7751: FETCH c_adv_options INTO l_modifiers_tbl(i).pricing_phase_id,l_modifiers_tbl(i).print_on_invoice_flag,l_modifiers_tbl(i).incompatibility_grp_code,l_modifiers_tbl(i).pricing_group_sequence,l_modifiers_tbl(i).product_precedence;

Line 9247: l_TPM_process_enabled VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');

9243: -- Bug 14138664
9244: l_old_fund_req_curr_code VARCHAR2(15);
9245: l_old_transaction_curr_code VARCHAR2(15);
9246: --//Bug 14158729
9247: l_TPM_process_enabled VARCHAR2 (1) := NVL(fnd_profile.VALUE ('OZF_TPM_PROCESS_ENABLED'),'N');
9248:
9249: CURSOR cur_get_user_status IS
9250: SELECT user_status_id,owner_id,status_code,offer_id,transaction_currency_code,fund_request_curr_code
9251: FROM ozf_offers

Line 9365: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP') IS NULL THEN

9361: x_return_status := Fnd_Api.g_ret_sts_success;
9362: x_error_location := 0;
9363:
9364: -- added by julou 14-DEC-2001 check default profile values before going any further
9365: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP') IS NULL THEN
9366: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINEGROUP');
9367: FND_MSG_PUB.add;
9368: RAISE FND_API.g_exc_unexpected_error;
9369: END IF;

Line 9371: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINE') IS NULL THEN

9367: FND_MSG_PUB.add;
9368: RAISE FND_API.g_exc_unexpected_error;
9369: END IF;
9370:
9371: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINE') IS NULL THEN
9372: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINE');
9373: FND_MSG_PUB.add;
9374: RAISE FND_API.g_exc_unexpected_error;
9375: END IF;

Line 9377: IF FND_PROFILE.value('OZF_PRICING_PHASE_ORDER') IS NULL THEN

9373: FND_MSG_PUB.add;
9374: RAISE FND_API.g_exc_unexpected_error;
9375: END IF;
9376:
9377: IF FND_PROFILE.value('OZF_PRICING_PHASE_ORDER') IS NULL THEN
9378: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_ORDER');
9379: FND_MSG_PUB.add;
9380: RAISE FND_API.g_exc_unexpected_error;
9381: END IF;

Line 9383: IF FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE') IS NULL THEN

9379: FND_MSG_PUB.add;
9380: RAISE FND_API.g_exc_unexpected_error;
9381: END IF;
9382:
9383: IF FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE') IS NULL THEN
9384: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_GROUP_SEQUENCE');
9385: FND_MSG_PUB.add;
9386: RAISE FND_API.g_exc_unexpected_error;
9387: END IF;

Line 9389: IF FND_PROFILE.value('OZF_PRINT_ON_INVOICE') IS NULL THEN

9385: FND_MSG_PUB.add;
9386: RAISE FND_API.g_exc_unexpected_error;
9387: END IF;
9388:
9389: IF FND_PROFILE.value('OZF_PRINT_ON_INVOICE') IS NULL THEN
9390: FND_MESSAGE.set_name('OZF','OZF_NO_PRINT_ON_INVOICE');
9391: FND_MSG_PUB.add;
9392: RAISE FND_API.g_exc_unexpected_error;
9393: END IF;

Line 9395: IF FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP') IS NULL THEN

9391: FND_MSG_PUB.add;
9392: RAISE FND_API.g_exc_unexpected_error;
9393: END IF;
9394: /* julou bug 3498759 - comment OUT NOCOPY as these profiles are not mandatory
9395: IF FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP') IS NULL THEN
9396: FND_MESSAGE.set_name('OZF','OZF_NO_INCOMPATIBILITY_GROUP');
9397: FND_MSG_PUB.add;
9398: RAISE FND_API.g_exc_unexpected_error;
9399: END IF;

Line 9401: IF FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE') IS NULL THEN

9397: FND_MSG_PUB.add;
9398: RAISE FND_API.g_exc_unexpected_error;
9399: END IF;
9400: */
9401: IF FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE') IS NULL THEN
9402: FND_MESSAGE.set_name('OZF','OZF_NO_PRODUCT_PRECEDENCE');
9403: FND_MSG_PUB.add;
9404: RAISE FND_API.g_exc_unexpected_error;
9405: END IF;

Line 9444: IF l_old_transaction_curr_code IS NOT NULL AND p_modifier_list_rec.transaction_currency_code IS NULL AND l_old_transaction_curr_code <> FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY') THEN

9440: FND_MSG_PUB.add;
9441: RAISE FND_API.g_exc_unexpected_error;
9442: END IF;
9443: --if currency is changed to no currency
9444: IF l_old_transaction_curr_code IS NOT NULL AND p_modifier_list_rec.transaction_currency_code IS NULL AND l_old_transaction_curr_code <> FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY') THEN
9445: FND_MESSAGE.set_name('OZF','OZF_REM_ASSO_BUDGET');
9446: FND_MSG_PUB.add;
9447: RAISE FND_API.g_exc_unexpected_error;
9448: END IF;

Line 9454: IF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'N' THEN

9450: --end Bug 14138664
9451:
9452: IF l_old_status_code = 'ACTIVE' THEN
9453: --julou in active status, if recal='N', validated committed vs approved othterwise do nothing
9454: IF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'N' THEN
9455: validate_offer
9456: (
9457: p_api_version => 1.0
9458: ,p_init_msg_list => p_init_msg_list

Line 10382: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

10378: x_modifiersRec.operation := QP_GLOBALS.G_OPR_CREATE;
10379: x_modifiersRec.list_header_id := p_qpListHeaderId;
10380: x_modifiersRec.list_line_type_code := 'PBH';
10381: x_modifiersRec.proration_type_code := 'N';
10382: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
10383: x_modifiersRec.incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
10384: x_modifiersRec.print_on_invoice_flag := 'Y';
10385: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId);
10386: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId);

Line 10383: x_modifiersRec.incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');

10379: x_modifiersRec.list_header_id := p_qpListHeaderId;
10380: x_modifiersRec.list_line_type_code := 'PBH';
10381: x_modifiersRec.proration_type_code := 'N';
10382: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
10383: x_modifiersRec.incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
10384: x_modifiersRec.print_on_invoice_flag := 'Y';
10385: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId);
10386: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId);
10387: x_modifiersRec.automatic_flag := 'Y';

Line 10392: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

10388: x_modifiersRec.price_break_type_code := 'RANGE';
10389: x_modifiersRec.accum_attribute := 'PRICING_ATTRIBUTE19';
10390: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
10391: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId) <> 'ORDER' THEN
10392: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
10393: END IF;
10394: x_modifiersRec.attribute1 := getDiscountLineId(p_offDiscountProductId => p_offDiscountProductId);
10395: END populatePBHRec;
10396:

Line 10422: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

10418: x_modifiersRec.list_header_id := p_qpListHeaderId;
10419: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
10420: x_modifiersRec.list_line_type_code := 'DIS';
10421: x_modifiersRec.proration_type_code := 'N';
10422: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
10423: x_modifiersRec.print_on_invoice_flag := 'Y';
10424: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId );
10425: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId );
10426: x_modifiersRec.automatic_flag := 'Y';

Line 10436: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

10432: x_modifiersRec.rltd_modifier_grp_type := 'PRICE BREAK';
10433: x_modifiersRec.rltd_modifier_grp_no := 1;
10434: x_modifiersRec.modifier_parent_index := 1;
10435: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId ) <> 'ORDER' THEN
10436: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
10437: END IF;
10438: x_modifiersRec.attribute1 := -1; -- for later identification
10439: END LOOP;
10440: END populateZeroDiscounts;

Line 10472: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');

10468: x_modifiersRec.list_header_id := p_qpListHeaderId;
10469: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
10470: x_modifiersRec.list_line_type_code := 'DIS';
10471: x_modifiersRec.proration_type_code := 'N';
10472: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
10473: x_modifiersRec.print_on_invoice_flag := 'Y';
10474: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId );
10475: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId );
10476: x_modifiersRec.automatic_flag := 'Y';

Line 10487: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

10483: x_modifiersRec.rltd_modifier_grp_no := 1;
10484: x_modifiersRec.modifier_parent_index := 1;
10485: x_modifiersRec.attribute1 := p_offerDiscountLineId; -- for later identification
10486: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId ) <> 'ORDER' THEN
10487: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
10488: END IF;
10489: END LOOP;
10490: END populateRegularDiscounts;
10491:

Line 11247: x_modifier_list_rec.BUDGET_SOURCE_ID := FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET');

11243: x_modifier_list_rec.STATUS_DATE := sysdate;
11244: x_modifier_list_rec.ACTIVE_FLAG := 'N';
11245:
11246: --//Bug 10648426
11247: x_modifier_list_rec.BUDGET_SOURCE_ID := FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET');
11248: x_modifier_list_rec.BUDGET_SOURCE_TYPE := 'FUND';
11249:
11250: END IF;
11251:

Line 11287: AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN

11283: x_modifier_list_rec.COMMENTS := FND_MESSAGE.GET_STRING('OZF','OZF_SD_OFFER_COMMENTS');
11284: x_modifier_list_rec.ASK_FOR_FLAG := NVL(l_request_basis,'N');
11285:
11286: IF l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM
11287: AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
11288: x_modifier_list_rec.global_flag := 'N';
11289: x_modifier_list_rec.orig_org_id := l_org_id;
11290: ELSE
11291: x_modifier_list_rec.global_flag := 'Y';

Line 11297: -- x_modifier_list_rec.BUDGET_SOURCE_ID := FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET');

11293:
11294: -- x_modifier_list_rec.global_flag := 'Y';
11295:
11296: --//Bug 10648426
11297: -- x_modifier_list_rec.BUDGET_SOURCE_ID := FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET');
11298: -- x_modifier_list_rec.BUDGET_SOURCE_TYPE := 'FUND';
11299:
11300: x_modifier_list_rec.OFFER_OPERATION := p_operation;
11301: x_modifier_list_rec.MODIFIER_OPERATION := p_operation;

Line 12265: IF FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET') IS NULL THEN

12261: g_sd_offer := 'Y';
12262:
12263: debug_message('N: qp_list_header_id' || x_qp_list_header_id);
12264:
12265: IF FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET') IS NULL THEN
12266: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
12267: FND_MESSAGE.set_name('OZF', 'OZF_SD_OFFR_NO_BUDGET_REQUEST');
12268: FND_MSG_PUB.add;
12269: END IF;