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 633: l_promotional_offers_rec.autopay_days := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_DAYS');

629: /*
630: IF p_advanced_options_rec.autopay_days IS NOT NULL THEN
631: l_promotional_offers_rec.autopay_days := p_advanced_options_rec.autopay_days;
632: ELSE
633: l_promotional_offers_rec.autopay_days := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_DAYS');
634: END IF;
635:
636: IF p_advanced_options_rec.autopay_method IS NOT NULL THEN
637: l_promotional_offers_rec.autopay_method := p_advanced_options_rec.autopay_method;

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

635:
636: IF p_advanced_options_rec.autopay_method IS NOT NULL THEN
637: l_promotional_offers_rec.autopay_method := p_advanced_options_rec.autopay_method;
638: ELSE
639: l_promotional_offers_rec.autopay_method := FND_PROFILE.VALUE('OZF_DEFAULT_AUTOPAY_METHOD');
640: END IF;
641: */
642: l_promotional_offers_rec.autopay_party_attr := p_advanced_options_rec.autopay_party_attr;
643: l_promotional_offers_rec.autopay_party_id := p_advanced_options_rec.autopay_party_id;

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

1854: l_act_budgets_rec.budget_source_id := p_modifier_list_rec.budget_source_id;
1855: l_act_budgets_rec.budget_source_type := p_modifier_list_rec.budget_source_type;--'FUND';
1856: l_act_budgets_rec.transfer_type := 'REQUEST';
1857: l_act_budgets_rec.arc_act_budget_used_by := 'OFFR';
1858: l_act_budgets_rec.request_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1859: l_act_budgets_rec.approved_in_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1860: IF p_modifier_list_rec.offer_type = 'SCAN_DATA' THEN
1861: IF p_modifier_list_rec.offer_amount = fnd_api.g_miss_num THEN -- calling from offer detail
1862: l_act_budgets_rec.request_amount := p_modifier_list_rec.budget_amount_tc;

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

1855: l_act_budgets_rec.budget_source_type := p_modifier_list_rec.budget_source_type;--'FUND';
1856: l_act_budgets_rec.transfer_type := 'REQUEST';
1857: l_act_budgets_rec.arc_act_budget_used_by := 'OFFR';
1858: l_act_budgets_rec.request_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1859: l_act_budgets_rec.approved_in_currency := nvl(p_modifier_list_rec.transaction_currency_code,FND_PROFILE.VALUE('JTF_PROFILE_DEFAULT_CURRENCY'));
1860: IF p_modifier_list_rec.offer_type = 'SCAN_DATA' THEN
1861: IF p_modifier_list_rec.offer_amount = fnd_api.g_miss_num THEN -- calling from offer detail
1862: l_act_budgets_rec.request_amount := p_modifier_list_rec.budget_amount_tc;
1863: END IF;

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

3239: OPEN c_approved_amount(l_offers_rec.qp_list_header_id);
3240: FETCH c_approved_amount INTO l_approved_amount;
3241: CLOSE c_approved_amount;
3242:
3243: l_recal := NVL(FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL'), 'Y');
3244: --julou checking approved amount vs committed amount for recal=N and lumpsum, scan_data
3245: IF l_recal = 'N' OR (l_recal = 'Y' AND p_offer_rec.offer_type IN ('LUMPSUM', 'SCAN_DATA')) THEN
3246: -- populate committed amount
3247: IF p_offer_rec.offer_type = 'SCAN_DATA' THEN

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

3789: x_msg_count => x_msg_count,
3790: x_msg_data => x_msg_data,
3791: p_offer_rec => p_offer_rec
3792: );
3793: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');
3794: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
3795: --julou amount validation failed, update status depending on recal
3796: IF p_called_from = 'R' THEN
3797: IF p_offer_rec.offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

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

4257:
4258: l_modifier_list_rec.operation := p_modifier_list_rec.modifier_operation;
4259: l_modifier_list_rec.list_header_id := p_modifier_list_rec.qp_list_header_id ;
4260: l_modifier_list_rec.list_type_code := 'PRO';
4261: l_modifier_list_rec.source_system_code := FND_PROFILE.VALUE('QP_SOURCE_SYSTEM_CODE');
4262: l_modifier_list_rec.description := p_modifier_list_rec.description;
4263: l_modifier_list_rec.comments := p_modifier_list_rec.comments;
4264: l_modifier_list_rec.currency_code := p_modifier_list_rec.currency_code;
4265: l_modifier_list_rec.start_date_active := trunc(p_modifier_list_rec.start_date_active);

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

4379: In case of lumpsum and scandata Offers the OrgID field appears in the UI, irrespective of the security profile since
4380: they are always local. The org_id is actually stored in ozf_offers, in this case.
4381: 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
4382: */
4383: IF NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') = 'OFF' THEN
4384: l_modifier_list_rec.global_flag := 'Y';
4385: l_modifier_list_rec.org_id := NULL;
4386: END IF;
4387:

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

4941: l_pricingPhase NUMBER;
4942: BEGIN
4943: CASE getDiscountLevel(p_listHeaderId => p_listHeaderId)
4944: WHEN 'LINEGROUP' THEN
4945: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
4946: WHEN 'LINE' THEN
4947: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
4948: WHEN 'ORDER' THEN
4949: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');

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

4943: CASE getDiscountLevel(p_listHeaderId => p_listHeaderId)
4944: WHEN 'LINEGROUP' THEN
4945: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
4946: WHEN 'LINE' THEN
4947: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
4948: WHEN 'ORDER' THEN
4949: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
4950: ELSE
4951: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

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

4945: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
4946: WHEN 'LINE' THEN
4947: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
4948: WHEN 'ORDER' THEN
4949: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
4950: ELSE
4951: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
4952: END CASE;
4953: RETURN l_pricingPhase;

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

4947: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
4948: WHEN 'ORDER' THEN
4949: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
4950: ELSE
4951: l_pricingPhase := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
4952: END CASE;
4953: RETURN l_pricingPhase;
4954: END getPricingPhase;
4955:

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

4971: x_modifiersTbl(l_index).list_header_id := p_modifierLineRec.list_header_id;
4972: x_modifiersTbl(l_index).arithmetic_operator := NVL(p_modifierLineRec.arithmetic_operator, '%');
4973: x_modifiersTbl(l_index).operand := 0;
4974: x_modifiersTbl(l_index).proration_type_code := 'N';
4975: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
4976:
4977: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
4978: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
4979: END IF;

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

4974: x_modifiersTbl(l_index).proration_type_code := 'N';
4975: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
4976:
4977: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
4978: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
4979: END IF;
4980: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';
4981: x_modifiersTbl(l_index).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
4982: x_modifiersTbl(l_index).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);

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

5007: x_modifiersTbl(l_index).list_header_id := p_modifierLineRec.list_header_id;
5008: x_modifiersTbl(l_index).arithmetic_operator := NVL(p_modifierLineRec.arithmetic_operator, '%');
5009: x_modifiersTbl(l_index).operand := NVL(p_modifierLineRec.operand, 0);
5010: x_modifiersTbl(l_index).proration_type_code := 'N';
5011: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5012: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5013: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5014: END IF;
5015: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';

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

5009: x_modifiersTbl(l_index).operand := NVL(p_modifierLineRec.operand, 0);
5010: x_modifiersTbl(l_index).proration_type_code := 'N';
5011: x_modifiersTbl(l_index).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5012: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5013: x_modifiersTbl(l_index).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5014: END IF;
5015: x_modifiersTbl(l_index).print_on_invoice_flag := 'Y';
5016: x_modifiersTbl(l_index).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
5017: x_modifiersTbl(l_index).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);

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

5280: IF p_modifierLineRec.operation = 'CREATE' THEN
5281: -- l_child_index := l_child_index + 1;
5282: x_modifiersTbl(1).list_line_type_code := 'PBH' ;
5283: x_modifiersTbl(1).proration_type_code := 'N';
5284: x_modifiersTbl(1).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5285: x_modifiersTbl(1).print_on_invoice_flag := 'Y';
5286: x_modifiersTbl(1).pricing_phase_id := getPricingPhase(p_listHeaderId => p_modifierLineRec.list_header_id);
5287: x_modifiersTbl(1).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);
5288: x_modifiersTbl(1).price_break_type_code := 'POINT';

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

5287: x_modifiersTbl(1).modifier_level_code := getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id);
5288: x_modifiersTbl(1).price_break_type_code := 'POINT';
5289: x_modifiersTbl(1).automatic_flag := 'Y';
5290: IF getDiscountLevel(p_listHeaderId => p_modifierLineRec.list_header_id) <> 'ORDER' THEN
5291: x_modifiersTbl(1).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5292: END IF;
5293: end if;
5294: IF getOfferType(p_listHeaderId => p_modifierLineRec.list_header_id) = 'ACCRUAL' THEN
5295: x_modifiersTbl(1).accrual_flag := 'Y';

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

5631: l_adv_options_exist NUMBER;
5632:
5633: BEGIN
5634: x_return_status := Fnd_Api.g_ret_sts_success;
5635: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');
5636: l_list_header_id := p_modifier_line_tbl(p_modifier_line_tbl.last).list_header_id;
5637:
5638: OPEN cur_get_discount_level(l_list_header_id);
5639: FETCH cur_get_discount_level into l_discount_level;

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

5702: CLOSE c_adv_options_exist;
5703:
5704: IF l_adv_options_exist IS NULL THEN
5705: IF l_discount_level = 'LINEGROUP' THEN
5706: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5707: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
5708: -- l_modifiers_tbl(i).pricing_phase_id := 3;
5709: -- END IF;
5710: ELSIF l_discount_level = 'LINE' THEN

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

5707: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
5708: -- l_modifiers_tbl(i).pricing_phase_id := 3;
5709: -- END IF;
5710: ELSIF l_discount_level = 'LINE' THEN
5711: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
5712: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
5713: -- l_modifiers_tbl(i).pricing_phase_id := 2;
5714: -- END IF;
5715: ELSIF l_discount_level = 'ORDER' THEN

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

5712: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
5713: -- l_modifiers_tbl(i).pricing_phase_id := 2;
5714: -- END IF;
5715: ELSIF l_discount_level = 'ORDER' THEN
5716: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
5717: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
5718: -- l_modifiers_tbl(i).pricing_phase_id := 4;
5719: -- END IF;
5720: ELSE

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

5717: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
5718: -- l_modifiers_tbl(i).pricing_phase_id := 4;
5719: -- END IF;
5720: ELSE
5721: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
5722: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
5723: -- l_modifiers_tbl(i).pricing_phase_id := 3;
5724: -- END IF;
5725: END IF;

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

5723: -- l_modifiers_tbl(i).pricing_phase_id := 3;
5724: -- END IF;
5725: END IF;
5726:
5727: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
5728:
5729: IF p_parent_offer_type = 'DEAL' THEN
5730: l_modifiers_tbl(i).incompatibility_grp_code := NULL;
5731: ELSE

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

5728:
5729: IF p_parent_offer_type = 'DEAL' THEN
5730: l_modifiers_tbl(i).incompatibility_grp_code := NULL;
5731: ELSE
5732: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
5733: END IF;
5734:
5735: IF l_discount_level <> 'ORDER' THEN
5736: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

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

5732: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
5733: END IF;
5734:
5735: IF l_discount_level <> 'ORDER' THEN
5736: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
5737: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN
5738: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
5739: -- END IF;
5740: END IF;

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

5738: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
5739: -- END IF;
5740: END IF;
5741:
5742: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
5743:
5744: ELSE
5745: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
5746: 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 6362: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');

6358: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
6359: RAISE Fnd_Api.g_exc_unexpected_error;
6360: END IF;
6361:
6362: l_recal := FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL');
6363: -- update status according to recal flag
6364: UPDATE ozf_offers
6365: SET status_code = DECODE(l_amount_error, 'Y', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'), 'N', 'ACTIVE'),
6366: status_date = SYSDATE,

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

6376: status_date = SYSDATE,
6377: object_version_number = object_version_number + 1,
6378: 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)
6379: WHERE qp_list_header_id = p_qp_list_header_id;
6380: ELSIF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'Y' THEN
6381: -- if recal='N' if approved>0 -> active(no status change) otherwise draft
6382: OPEN c_approved_amount(p_qp_list_header_id);
6383: FETCH c_approved_amount INTO l_approved_amount;
6384: CLOSE c_approved_amount;

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

6500: l_end_date DATE;
6501: l_start_date DATE;
6502: BEGIN
6503: x_return_status := Fnd_Api.g_ret_sts_success;
6504: l_override_flag := FND_PROFILE.value('OZF_OFFR_OVERRIDE_FLAG');
6505: l_list_header_id := p_modifier_line_tbl(p_modifier_line_tbl.last).list_header_id;
6506:
6507: OPEN cur_get_discount_level(l_list_header_id);
6508: FETCH cur_get_discount_level into l_discount_level;

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

6554: CLOSE c_adv_options_exist;
6555:
6556: IF l_adv_options_exist IS NULL THEN
6557: IF l_discount_level = 'LINEGROUP' THEN
6558: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
6559: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6560: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6561: -- END IF;
6562: ELSIF l_discount_level = 'LINE' THEN

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

6559: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6560: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6561: -- END IF;
6562: ELSIF l_discount_level = 'LINE' THEN
6563: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
6564: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
6565: -- l_modifiers_tbl(i).pricing_phase_id := 2;
6566: -- END IF;
6567: ELSIF l_discount_level = 'ORDER' THEN

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

6564: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
6565: -- l_modifiers_tbl(i).pricing_phase_id := 2;
6566: -- END IF;
6567: ELSIF l_discount_level = 'ORDER' THEN
6568: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
6569: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
6570: -- l_modifiers_tbl(i).pricing_phase_id := 4;
6571: -- END IF;
6572: ELSE

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

6569: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
6570: -- l_modifiers_tbl(i).pricing_phase_id := 4;
6571: -- END IF;
6572: ELSE
6573: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
6574: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
6575: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6576: -- END IF;
6577: END IF;

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

6575: -- l_modifiers_tbl(i).pricing_phase_id := 3;
6576: -- END IF;
6577: END IF;
6578:
6579: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
6580: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
6581:
6582: IF l_discount_level <> 'ORDER' THEN
6583: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

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

6576: -- END IF;
6577: END IF;
6578:
6579: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
6580: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
6581:
6582: IF l_discount_level <> 'ORDER' THEN
6583: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
6584: -- IF l_modifiers_tbl(i).pricing_group_sequence <>1 THEN

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

6579: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
6580: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
6581:
6582: IF l_discount_level <> 'ORDER' THEN
6583: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
6584: -- IF l_modifiers_tbl(i).pricing_group_sequence <>1 THEN
6585: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
6586: -- END IF;
6587: END IF;

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

6585: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
6586: -- END IF;
6587: END IF;
6588:
6589: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
6590:
6591: ELSE
6592: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
6593: 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 7182: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');

7178: CLOSE c_adv_options_exist;
7179:
7180: IF l_adv_options_exist IS NULL THEN
7181: IF l_discount_level = 'LINEGROUP' THEN
7182: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7183: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7184: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7185: -- END IF;
7186: ELSIF l_discount_level = 'LINE' THEN

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

7183: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7184: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7185: -- END IF;
7186: ELSIF l_discount_level = 'LINE' THEN
7187: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINE');
7188: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7189: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7190: -- END IF;
7191: ELSIF l_discount_level = 'ORDER' THEN

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

7188: -- IF l_modifiers_tbl(i).pricing_phase_id <> 2 THEN
7189: -- l_modifiers_tbl(i).pricing_phase_id := 2;
7190: -- END IF;
7191: ELSIF l_discount_level = 'ORDER' THEN
7192: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_ORDER');
7193: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7194: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7195: -- END IF;
7196: ELSE

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

7193: -- IF l_modifiers_tbl(i).pricing_phase_id <> 4 THEN
7194: -- l_modifiers_tbl(i).pricing_phase_id := 4;
7195: -- END IF;
7196: ELSE
7197: l_modifiers_tbl(i).pricing_phase_id := FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP');
7198: -- IF l_modifiers_tbl(i).pricing_phase_id <> 3 THEN
7199: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7200: -- END IF;
7201: END IF;

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

7199: -- l_modifiers_tbl(i).pricing_phase_id := 3;
7200: -- END IF;
7201: END IF;
7202:
7203: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7204: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7205:
7206: IF l_discount_level <> 'ORDER' THEN
7207: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');

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

7200: -- END IF;
7201: END IF;
7202:
7203: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7204: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7205:
7206: IF l_discount_level <> 'ORDER' THEN
7207: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7208: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN

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

7203: l_modifiers_tbl(i).print_on_invoice_flag := FND_PROFILE.value('OZF_PRINT_ON_INVOICE');
7204: l_modifiers_tbl(i).incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
7205:
7206: IF l_discount_level <> 'ORDER' THEN
7207: l_modifiers_tbl(i).pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
7208: -- IF l_modifiers_tbl(i).pricing_group_sequence <> 1 THEN
7209: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7210: -- END IF;
7211: END IF;

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

7209: -- l_modifiers_tbl(i).pricing_group_sequence := 1;
7210: -- END IF;
7211: END IF;
7212:
7213: l_modifiers_tbl(i).product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
7214:
7215: ELSE
7216: OPEN c_adv_options(p_modifier_line_tbl(1).list_header_id);
7217: 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 8817: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP') IS NULL THEN

8813: x_return_status := Fnd_Api.g_ret_sts_success;
8814: x_error_location := 0;
8815:
8816: -- added by julou 14-DEC-2001 check default profile values before going any further
8817: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINEGROUP') IS NULL THEN
8818: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINEGROUP');
8819: FND_MSG_PUB.add;
8820: RAISE FND_API.g_exc_unexpected_error;
8821: END IF;

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

8819: FND_MSG_PUB.add;
8820: RAISE FND_API.g_exc_unexpected_error;
8821: END IF;
8822:
8823: IF FND_PROFILE.value('OZF_PRICING_PHASE_LINE') IS NULL THEN
8824: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_LINE');
8825: FND_MSG_PUB.add;
8826: RAISE FND_API.g_exc_unexpected_error;
8827: END IF;

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

8825: FND_MSG_PUB.add;
8826: RAISE FND_API.g_exc_unexpected_error;
8827: END IF;
8828:
8829: IF FND_PROFILE.value('OZF_PRICING_PHASE_ORDER') IS NULL THEN
8830: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_PHASE_ORDER');
8831: FND_MSG_PUB.add;
8832: RAISE FND_API.g_exc_unexpected_error;
8833: END IF;

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

8831: FND_MSG_PUB.add;
8832: RAISE FND_API.g_exc_unexpected_error;
8833: END IF;
8834:
8835: IF FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE') IS NULL THEN
8836: FND_MESSAGE.set_name('OZF','OZF_NO_PRICING_GROUP_SEQUENCE');
8837: FND_MSG_PUB.add;
8838: RAISE FND_API.g_exc_unexpected_error;
8839: END IF;

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

8837: FND_MSG_PUB.add;
8838: RAISE FND_API.g_exc_unexpected_error;
8839: END IF;
8840:
8841: IF FND_PROFILE.value('OZF_PRINT_ON_INVOICE') IS NULL THEN
8842: FND_MESSAGE.set_name('OZF','OZF_NO_PRINT_ON_INVOICE');
8843: FND_MSG_PUB.add;
8844: RAISE FND_API.g_exc_unexpected_error;
8845: END IF;

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

8843: FND_MSG_PUB.add;
8844: RAISE FND_API.g_exc_unexpected_error;
8845: END IF;
8846: /* julou bug 3498759 - comment OUT NOCOPY as these profiles are not mandatory
8847: IF FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP') IS NULL THEN
8848: FND_MESSAGE.set_name('OZF','OZF_NO_INCOMPATIBILITY_GROUP');
8849: FND_MSG_PUB.add;
8850: RAISE FND_API.g_exc_unexpected_error;
8851: END IF;

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

8849: FND_MSG_PUB.add;
8850: RAISE FND_API.g_exc_unexpected_error;
8851: END IF;
8852: */
8853: IF FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE') IS NULL THEN
8854: FND_MESSAGE.set_name('OZF','OZF_NO_PRODUCT_PRECEDENCE');
8855: FND_MSG_PUB.add;
8856: RAISE FND_API.g_exc_unexpected_error;
8857: END IF;

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

8881: CLOSE cur_get_user_status;
8882:
8883: IF l_old_status_code = 'ACTIVE' THEN
8884: --julou in active status, if recal='N', validated committed vs approved othterwise do nothing
8885: IF FND_PROFILE.VALUE('OZF_BUDGET_ADJ_ALLOW_RECAL') = 'N' THEN
8886: validate_offer
8887: (
8888: p_api_version => 1.0
8889: ,p_init_msg_list => p_init_msg_list

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

9797: x_modifiersRec.operation := QP_GLOBALS.G_OPR_CREATE;
9798: x_modifiersRec.list_header_id := p_qpListHeaderId;
9799: x_modifiersRec.list_line_type_code := 'PBH';
9800: x_modifiersRec.proration_type_code := 'N';
9801: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
9802: x_modifiersRec.incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
9803: x_modifiersRec.print_on_invoice_flag := 'Y';
9804: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId);
9805: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId);

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

9798: x_modifiersRec.list_header_id := p_qpListHeaderId;
9799: x_modifiersRec.list_line_type_code := 'PBH';
9800: x_modifiersRec.proration_type_code := 'N';
9801: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
9802: x_modifiersRec.incompatibility_grp_code := FND_PROFILE.value('OZF_INCOMPATIBILITY_GROUP');
9803: x_modifiersRec.print_on_invoice_flag := 'Y';
9804: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId);
9805: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId);
9806: x_modifiersRec.automatic_flag := 'Y';

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

9807: x_modifiersRec.price_break_type_code := 'RANGE';
9808: x_modifiersRec.accum_attribute := 'PRICING_ATTRIBUTE19';
9809: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
9810: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId) <> 'ORDER' THEN
9811: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
9812: END IF;
9813: x_modifiersRec.attribute1 := getDiscountLineId(p_offDiscountProductId => p_offDiscountProductId);
9814: END populatePBHRec;
9815:

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

9837: x_modifiersRec.list_header_id := p_qpListHeaderId;
9838: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
9839: x_modifiersRec.list_line_type_code := 'DIS';
9840: x_modifiersRec.proration_type_code := 'N';
9841: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
9842: x_modifiersRec.print_on_invoice_flag := 'Y';
9843: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId );
9844: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId );
9845: x_modifiersRec.automatic_flag := 'Y';

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

9851: x_modifiersRec.rltd_modifier_grp_type := 'PRICE BREAK';
9852: x_modifiersRec.rltd_modifier_grp_no := 1;
9853: x_modifiersRec.modifier_parent_index := 1;
9854: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId ) <> 'ORDER' THEN
9855: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
9856: END IF;
9857: x_modifiersRec.attribute1 := -1; -- for later identification
9858: END LOOP;
9859: END populateZeroDiscounts;

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

9887: x_modifiersRec.list_header_id := p_qpListHeaderId;
9888: x_modifiersRec.accrual_flag := getVOAccrualFlag(p_qpListHeaderId => p_qpListHeaderId );
9889: x_modifiersRec.list_line_type_code := 'DIS';
9890: x_modifiersRec.proration_type_code := 'N';
9891: x_modifiersRec.product_precedence := FND_PROFILE.value('OZF_PRODUCT_PRECEDENCE');
9892: x_modifiersRec.print_on_invoice_flag := 'Y';
9893: x_modifiersRec.pricing_phase_id := getPricingPhase(p_listHeaderId => p_qpListHeaderId );
9894: x_modifiersRec.modifier_level_code := getDiscountLevel(p_listHeaderId => p_qpListHeaderId );
9895: x_modifiersRec.automatic_flag := 'Y';

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

9902: x_modifiersRec.rltd_modifier_grp_no := 1;
9903: x_modifiersRec.modifier_parent_index := 1;
9904: x_modifiersRec.attribute1 := p_offerDiscountLineId; -- for later identification
9905: IF getDiscountLevel(p_listHeaderId => p_qpListHeaderId ) <> 'ORDER' THEN
9906: x_modifiersRec.pricing_group_sequence := FND_PROFILE.value('OZF_PRICING_GROUP_SEQUENCE');
9907: END IF;
9908: END LOOP;
9909: END populateRegularDiscounts;
9910:

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

10689: x_modifier_list_rec.COMMENTS := FND_MESSAGE.GET_STRING('OZF','OZF_SD_OFFER_COMMENTS');
10690: x_modifier_list_rec.ASK_FOR_FLAG := NVL(l_request_basis,'N');
10691:
10692: IF l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM
10693: AND NVL(fnd_profile.value('QP_SECURITY_CONTROL'), 'OFF') <> 'OFF' THEN
10694: x_modifier_list_rec.global_flag := 'N';
10695: x_modifier_list_rec.orig_org_id := l_org_id;
10696: ELSE
10697: x_modifier_list_rec.global_flag := 'Y';

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

10698: END IF;
10699:
10700: -- x_modifier_list_rec.global_flag := 'Y';
10701:
10702: x_modifier_list_rec.BUDGET_SOURCE_ID := FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET');
10703: x_modifier_list_rec.BUDGET_SOURCE_TYPE := 'FUND';
10704:
10705: x_modifier_list_rec.OFFER_OPERATION := p_operation;
10706: x_modifier_list_rec.MODIFIER_OPERATION := p_operation;

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

11451: x_return_status := Fnd_Api.g_ret_sts_success;
11452: x_error_location := 0;
11453: g_sd_offer := 'Y';
11454:
11455: IF FND_PROFILE.VALUE('OZF_SD_DEFAULT_BUDGET') IS NULL THEN
11456: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
11457: FND_MESSAGE.set_name('OZF', 'OZF_SD_OFFR_NO_BUDGET_REQUEST');
11458: FND_MSG_PUB.add;
11459: END IF;