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 OZF_UTILITY_PVT

Line 225: ozf_utility_pvt.debug_message(p_message);

221: IS
222: BEGIN
223:
224: IF (OZF_DEBUG_HIGH_ON) THEN
225: ozf_utility_pvt.debug_message(p_message);
226:
227: END IF;
228: END debug_message;
229:

Line 690: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_adv_options---');

686: l_modifiers_tbl(i).operation := Qp_Globals.G_OPR_UPDATE;
687: i:= i+1;
688: END LOOP;
689:
690: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_adv_options---');
691: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_adv_options before calling QP for list_header_id : '|| p_advanced_options_rec.list_header_id);
692:
693: Qp_Modifiers_Pub.process_modifiers(
694: p_api_version_number => 1.0,

Line 976: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in create_offer_tiers---');

972: END IF;
973:
974:
975: debug_message('Calling Pub Process in tiers');
976: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in create_offer_tiers---');
977: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.create_offer_tiers before calling QP for list_header_id : '|| p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
978: END IF;
979: Qp_Modifiers_Pub.process_modifiers(
980: p_api_version_number => 1.0,

Line 1163: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_exlusions---p_pricing_attr_tbl.COUNT = '|| p_pricing_attr_tbl.COUNT);

1159:
1160: x_return_status := Fnd_Api.g_ret_sts_success;
1161: x_error_location := 0;
1162:
1163: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_exlusions---p_pricing_attr_tbl.COUNT = '|| p_pricing_attr_tbl.COUNT);
1164:
1165: IF p_pricing_attr_tbl.COUNT > 0 THEN
1166: FOR i IN p_pricing_attr_tbl.first..p_pricing_attr_tbl.last LOOP
1167: IF p_pricing_attr_tbl.EXISTS(i) THEN

Line 1481: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_rltd_modifier_qual---');

1477: END IF;
1478: END LOOP;
1479: debug_message('jl qualifier tbl count: ' || l_qualifiers_tbl.count);
1480: --raise Fnd_Api.g_exc_error;
1481: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_rltd_modifier_qual---');
1482:
1483: IF l_qualifiers_tbl.COUNT > 0 THEN
1484:
1485: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT.process_rltd_modifier_qual before calling QP for list_header_id : '|| l_qualifiers_tbl(l_qualifiers_tbl.first).list_header_id);

Line 1596: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_market_qualifiers1--- p_qualifiers_tbl.COUNT = '|| p_qualifiers_tbl.COUNT);

1592: END IF;
1593:
1594: x_return_status := Fnd_Api.g_ret_sts_success;
1595: x_error_location := 0;
1596: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_market_qualifiers1--- p_qualifiers_tbl.COUNT = '|| p_qualifiers_tbl.COUNT);
1597: IF p_qualifiers_tbl.COUNT > 0 THEN
1598: FOR i IN p_qualifiers_tbl.first..p_qualifiers_tbl.last LOOP
1599: IF p_qualifiers_tbl.EXISTS(i) THEN
1600: IF p_qualifiers_tbl(i).operation <> 'CREATE' THEN

Line 1798: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_market_qualifiers2--- p_qualifiers_tbl.COUNT = '|| p_qualifiers_tbl.COUNT);

1794: END IF;
1795:
1796: x_return_status := Fnd_Api.g_ret_sts_success;
1797: x_error_location := 0;
1798: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_market_qualifiers2--- p_qualifiers_tbl.COUNT = '|| p_qualifiers_tbl.COUNT);
1799: IF p_qualifiers_tbl.COUNT > 0 THEN
1800: FOR i IN p_qualifiers_tbl.first..p_qualifiers_tbl.last LOOP
1801: IF p_qualifiers_tbl.EXISTS(i) THEN
1802: IF p_qualifiers_tbl(i).operation <> 'CREATE' THEN

Line 2002: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_type: ' || l_act_budgets_rec.budget_source_type);

1998: IF p_operation = 'UPDATE' AND p_modifier_list_rec.offer_type = 'SCAN_DATA' AND get_active_budget_source_count(p_modifier_list_rec.qp_list_header_id) =1 THEN
1999: OPEN cur_get_offer_budget;
2000: FETCH cur_get_offer_budget INTO l_act_budgets_rec.activity_budget_id, l_act_budgets_rec.object_version_number;
2001: CLOSE cur_get_offer_budget;
2002: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_type: ' || l_act_budgets_rec.budget_source_type);
2003: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_id: ' || l_act_budgets_rec.budget_source_id);
2004:
2005: OZF_Actbudgets_Pvt.update_act_budgets(
2006: p_api_version => l_api_version

Line 2003: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_id: ' || l_act_budgets_rec.budget_source_id);

1999: OPEN cur_get_offer_budget;
2000: FETCH cur_get_offer_budget INTO l_act_budgets_rec.activity_budget_id, l_act_budgets_rec.object_version_number;
2001: CLOSE cur_get_offer_budget;
2002: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_type: ' || l_act_budgets_rec.budget_source_type);
2003: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_id: ' || l_act_budgets_rec.budget_source_id);
2004:
2005: OZF_Actbudgets_Pvt.update_act_budgets(
2006: p_api_version => l_api_version
2007: ,p_init_msg_list => Fnd_Api.g_false

Line 2339: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 1 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);

2335: l_qualifier_tbl(i).qualifier_id := l_qualifier_id;
2336: END IF;
2337:
2338: IF l_qualifier_tbl.COUNT > 0 THEN
2339: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 1 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);
2340: process_market_qualifiers
2341: (p_api_version => 1.0,
2342: p_init_msg_list => Fnd_Api.g_false,
2343: p_commit => Fnd_Api.g_false,

Line 2442: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 2 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);

2438:
2439:
2440: --raise Fnd_Api.g_exc_error;
2441: IF l_qualifier_tbl.COUNT > 0 THEN
2442: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 2 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);
2443: process_market_qualifiers
2444: (p_api_version => 1.0,
2445: p_init_msg_list => Fnd_Api.g_false,
2446: p_commit => Fnd_Api.g_false,

Line 2945: OZF_Utility_PVT.check_new_status_change

2941: OPEN c_old_user_status_id;
2942: FETCH c_old_user_status_id INTO l_old_status_id;
2943: CLOSE c_old_user_status_id;
2944:
2945: OZF_Utility_PVT.check_new_status_change
2946: (
2947: p_object_type => 'OFFR',
2948: p_object_id => l_offer_rec.qp_list_header_id,
2949: p_old_status_id => l_old_status_id,

Line 3089: OZF_Utility_PVT.check_new_status_change

3085: OPEN c_old_user_status_id;
3086: FETCH c_old_user_status_id INTO l_old_status_id;
3087: CLOSE c_old_user_status_id;
3088:
3089: OZF_Utility_PVT.check_new_status_change
3090: (
3091: p_object_type => 'OFFR',
3092: p_object_id => l_offer_rec.qp_list_header_id,
3093: p_old_status_id => l_old_status_id,

Line 3275: ozf_utility_pvt.error_message('OZF_OFFR_NO_START_DATE');

3271: IF p_offer_rec.offer_type IN ('SCAN_DATA', 'NET_ACCRUAL')
3272: OR (p_offer_rec.offer_type = 'LUMPSUM' AND p_offer_rec.custom_setup_id <> 110) -- not applicable to soft fund
3273: THEN
3274: IF p_offer_rec.start_date_active IS NULL THEN
3275: ozf_utility_pvt.error_message('OZF_OFFR_NO_START_DATE');
3276: RAISE FND_API.G_EXC_ERROR;
3277: END IF;
3278: END IF;
3279:

Line 3433: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_AMNT_GT_APPR_AMNT');

3429: END IF;
3430: END IF;
3431:
3432: IF l_committed_amount > l_approved_amount THEN
3433: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_AMNT_GT_APPR_AMNT');
3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436: ELSIF l_recal = 'Y' AND p_offer_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA') THEN
3437: IF l_approved_amount < 0 THEN

Line 3438: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_NO_APPROVED_AMOUNT');

3434: RAISE FND_API.G_EXC_ERROR;
3435: END IF;
3436: ELSIF l_recal = 'Y' AND p_offer_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA') THEN
3437: IF l_approved_amount < 0 THEN
3438: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_NO_APPROVED_AMOUNT');
3439: RAISE FND_API.G_EXC_ERROR;
3440: END IF;
3441: END IF;
3442: END IF;

Line 3529: OZF_Utility_PVT.Error_Message('OZF_OFFR_NO_BUDGET_REQUEST');

3525: OPEN c_request_amount;
3526: FETCH c_request_amount INTO l_request_amount;
3527: IF c_request_amount%NOTFOUND THEN
3528: CLOSE c_request_amount;
3529: OZF_Utility_PVT.Error_Message('OZF_OFFR_NO_BUDGET_REQUEST');
3530: RAISE FND_API.G_EXC_ERROR;
3531: END IF;
3532: CLOSE c_request_amount;
3533:

Line 3539: OZF_Utility_PVT.Error_Message('OZF_OFFR_REQAMT_LT_OFFAMT');

3535: FETCH c_committed_amount INTO l_committed_amount;
3536: CLOSE c_committed_amount;
3537:
3538: IF l_committed_amount > l_request_amount THEN
3539: OZF_Utility_PVT.Error_Message('OZF_OFFR_REQAMT_LT_OFFAMT');
3540: RAISE FND_API.G_EXC_ERROR;
3541: END IF;
3542:
3543: FND_MSG_PUB.Count_And_Get

Line 3697: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.Push_Target_group','before process_market_qualifiers 3 l_qualifiers_tbl.count = '|| l_qualifiers_tbl.count);

3693:
3694: END LOOP;
3695:
3696: IF l_qualifiers_tbl.count > 0 THEN
3697: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.Push_Target_group','before process_market_qualifiers 3 l_qualifiers_tbl.count = '|| l_qualifiers_tbl.count);
3698: process_market_qualifiers
3699: (
3700: p_init_msg_list => p_init_msg_list
3701: ,p_api_version => p_api_version

Line 3889: AND sdr.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'PENDING_OFFER_APPROVAL');

3885: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off
3886: --WHERE nvl(sdr.authorization_number,sdr.request_number) = off.offer_code
3887: WHERE sdr.request_number = off.offer_code
3888: AND off.qp_list_header_id = p_offer_id
3889: AND sdr.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'PENDING_OFFER_APPROVAL');
3890:
3891:
3892: CURSOR c_offer_status_code(p_qp_list_header_id NUMBER) IS
3893: SELECT status_code

Line 3959: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')

3955: IF p_offer_rec.status_code = 'DRAFT' THEN
3956: -- CP validation fails. update offer to DRAFT
3957: UPDATE ozf_offers
3958: SET status_code = 'DRAFT'
3959: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
3960: ,status_date = SYSDATE
3961: ,object_version_number = object_version_number + 1
3962: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3963: ELSE

Line 3983: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'PENDING_ACTIVE')

3979: UPDATE ozf_offers
3980: SET status_code = 'PENDING_ACTIVE',
3981: status_date = SYSDATE,
3982: object_version_number = object_version_number + 1,
3983: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'PENDING_ACTIVE')
3984: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3985: ELSE
3986: UPDATE ozf_offers
3987: SET status_code = DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'),

Line 3990: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'))

3986: UPDATE ozf_offers
3987: SET status_code = DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'),
3988: status_date = SYSDATE,
3989: object_version_number = object_version_number + 1,
3990: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'))
3991: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3992: END IF;
3993: ELSE -- called from B/ set amount error and the caller takes care of status
3994: x_amount_error := 'Y';

Line 4076: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'ACTIVE')

4072: SET status_code = 'ACTIVE',
4073: status_date = SYSDATE,
4074: object_version_number = object_version_number + 1,
4075: start_date = l_start_date,
4076: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'ACTIVE')
4077: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
4078:
4079: IF p_offer_rec.custom_setup_id = 110 THEN -- soft fund offers
4080: -- update ozf_request_headers_all_b update activating

Line 4087: ozf_utility_pvt.write_conc_log('p_offer_rec.custom_setup_id '||p_offer_rec.custom_setup_id);

4083: x_msg_data => x_msg_data,
4084: p_qp_list_header_id => p_offer_rec.qp_list_header_id);
4085: END IF;
4086:
4087: ozf_utility_pvt.write_conc_log('p_offer_rec.custom_setup_id '||p_offer_rec.custom_setup_id);
4088: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
4089:
4090:
4091: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers

Line 4088: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);

4084: p_qp_list_header_id => p_offer_rec.qp_list_header_id);
4085: END IF;
4086:
4087: ozf_utility_pvt.write_conc_log('p_offer_rec.custom_setup_id '||p_offer_rec.custom_setup_id);
4088: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
4089:
4090:
4091: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers
4092: -- update ozf_sd_request_headers_all_b update activating

Line 4097: ozf_utility_pvt.write_conc_log('l_obj_ver_num '||l_obj_ver_num);

4093: OPEN c_sd_req_header_rec(p_offer_rec.qp_list_header_id);
4094: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
4095: CLOSE c_sd_req_header_rec;
4096:
4097: ozf_utility_pvt.write_conc_log('l_obj_ver_num '||l_obj_ver_num);
4098: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
4099:
4100: --fix for bug 7004273
4101:

Line 4098: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);

4094: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
4095: CLOSE c_sd_req_header_rec;
4096:
4097: ozf_utility_pvt.write_conc_log('l_obj_ver_num '||l_obj_ver_num);
4098: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
4099:
4100: --fix for bug 7004273
4101:
4102: UPDATE ozf_sd_request_headers_all_b

Line 4103: SET user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'ACTIVE') ,

4099:
4100: --fix for bug 7004273
4101:
4102: UPDATE ozf_sd_request_headers_all_b
4103: SET user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'ACTIVE') ,
4104: object_version_number = l_obj_ver_num + 1
4105: WHERE request_header_id = l_sdr_req_header_id;
4106: END IF;
4107:

Line 4369: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 4 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);

4365:
4366:
4367: END IF;
4368: -- End Ship date
4369: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'before process_market_qualifiers 4 l_qualifier_tbl.COUNT = '|| l_qualifier_tbl.COUNT);
4370: process_market_qualifiers
4371: (
4372: p_api_version => 1.0,
4373: p_init_msg_list => Fnd_Api.g_false,

Line 4492: ozf_utility_pvt.debug_message('p_modifier_list_rec.orig_org_id : ' || p_modifier_list_rec.orig_org_id);

4488: --dbms_output.put_line('calling qp procedure');
4489:
4490: x_return_status := Fnd_Api.g_ret_sts_success;
4491:
4492: ozf_utility_pvt.debug_message('p_modifier_list_rec.orig_org_id : ' || p_modifier_list_rec.orig_org_id);
4493:
4494:
4495:
4496:

Line 4543: IF ozf_utility_pvt.get_system_status_code(p_old_status_id) = 'DRAFT' THEN

4539: --nepanda : fix for bug 8507709 : call process_offer_activation only when status is changing from DRAFT to ACTIVE (in order to prevent populating qp_list_lines table in case of ON-HOLD to ACTIVE
4540: IF p_new_status_code = 'ACTIVE' THEN
4541: IF p_approval_type is NULL AND p_modifier_list_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA') THEN
4542: l_modifier_list_rec.active_flag := 'Y';
4543: IF ozf_utility_pvt.get_system_status_code(p_old_status_id) = 'DRAFT' THEN
4544: debug_message('Calling activate');
4545: process_offer_activation
4546: (
4547: p_api_version_number => p_api_version

Line 4608: --l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');

4604: );
4605: ELSE
4606: l_modifier_list_rec.name := p_modifier_list_rec.offer_code;
4607: --nepanda : fix for bug 9149865
4608: --l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');
4609:
4610: OPEN c_check_uniqeness_create;
4611: FETCH c_check_uniqeness_create INTO l_uk_flag;
4612: CLOSE c_check_uniqeness_create;

Line 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);

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
4648: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header QP_SECURITY_CONTROL ON--qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);

Line 4648: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header QP_SECURITY_CONTROL ON--qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);

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
4648: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header QP_SECURITY_CONTROL ON--qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);
4649: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- p_modifier_list_rec.modifier_operation = '|| p_modifier_list_rec.modifier_operation);
4650:
4651: IF p_modifier_list_rec.modifier_operation = 'UPDATE' AND p_modifier_list_rec.offer_type NOT IN ('ACCRUAL','OFF_INVOICE','DEAL') THEN
4652: OPEN get_offer_info_frm_hdr(p_modifier_list_rec.qp_list_header_id);

Line 4649: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- p_modifier_list_rec.modifier_operation = '|| p_modifier_list_rec.modifier_operation);

4645: l_modifier_list_rec.global_flag := 'Y';
4646: l_modifier_list_rec.org_id := NULL;
4647: ELSE
4648: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header QP_SECURITY_CONTROL ON--qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);
4649: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- p_modifier_list_rec.modifier_operation = '|| p_modifier_list_rec.modifier_operation);
4650:
4651: IF p_modifier_list_rec.modifier_operation = 'UPDATE' AND p_modifier_list_rec.offer_type NOT IN ('ACCRUAL','OFF_INVOICE','DEAL') THEN
4652: OPEN get_offer_info_frm_hdr(p_modifier_list_rec.qp_list_header_id);
4653: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;

Line 4656: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);

4652: OPEN get_offer_info_frm_hdr(p_modifier_list_rec.qp_list_header_id);
4653: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;
4654: CLOSE get_offer_info_frm_hdr;
4655:
4656: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);
4657: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);
4658:
4659: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4660: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN

Line 4657: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);

4653: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;
4654: CLOSE get_offer_info_frm_hdr;
4655:
4656: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);
4657: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);
4658:
4659: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4660: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN
4661: /*1. Set context to access_mode =S AND org_id = old org id

Line 4676: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header TM Offer---qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);

4672: l_modifier_list_rec.org_id := p_modifier_list_rec.orig_org_id;
4673: END IF;
4674: END IF;
4675: ELSE
4676: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header TM Offer---qp_list_header_id = '|| p_modifier_list_rec.qp_list_header_id);
4677: OPEN get_offer_info_frm_hdr(p_modifier_list_rec.qp_list_header_id);
4678: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;
4679: CLOSE get_offer_info_frm_hdr;
4680:

Line 4681: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);

4677: OPEN get_offer_info_frm_hdr(p_modifier_list_rec.qp_list_header_id);
4678: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;
4679: CLOSE get_offer_info_frm_hdr;
4680:
4681: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);
4682: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);
4683:
4684: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4685: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN

Line 4682: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);

4678: FETCH get_offer_info_frm_hdr INTO l_org_id, l_global_flag;
4679: CLOSE get_offer_info_frm_hdr;
4680:
4681: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- New Org Id = '|| p_modifier_list_rec.orig_org_id);
4682: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_qp_list_header--- Old Org Id = '||l_org_id);
4683:
4684: IF (l_org_id IS NOT NULL AND l_org_id <> FND_API.G_MISS_NUM) THEN
4685: IF NVL(l_org_id,0) <> NVL(p_modifier_list_rec.orig_org_id,0) THEN
4686: /*1. Set context to access_mode =S AND org_id = old org id

Line 4698: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header org_id = '|| l_modifier_list_rec.org_id);

4694: l_modifier_list_rec.org_id := p_modifier_list_rec.orig_org_id;
4695: END IF;
4696:
4697: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before calling QP for list_header_id : '||l_modifier_list_rec.list_header_id);
4698: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header org_id = '|| l_modifier_list_rec.org_id);
4699: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header global_flag = '|| l_modifier_list_rec.global_flag);
4700:
4701: Qp_Modifiers_Pub.process_modifiers(
4702: p_api_version_number => 1.0,

Line 4699: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header global_flag = '|| l_modifier_list_rec.global_flag);

4695: END IF;
4696:
4697: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_qp_list_header before calling QP for list_header_id : '||l_modifier_list_rec.list_header_id);
4698: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header org_id = '|| l_modifier_list_rec.org_id);
4699: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'QP Call in process_qp_list_header global_flag = '|| l_modifier_list_rec.global_flag);
4700:
4701: Qp_Modifiers_Pub.process_modifiers(
4702: p_api_version_number => 1.0,
4703: p_init_msg_list => FND_API.G_FALSE,

Line 4719: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'After QP Call in process_qp_list_header x_return_status = '|| x_return_status);

4715: x_pricing_attr_tbl => v_pricing_attr_tbl,
4716: x_pricing_attr_val_tbl => v_pricing_attr_val_tbl
4717: );
4718:
4719: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT, l_full_name ,'After QP Call in process_qp_list_header x_return_status = '|| x_return_status);
4720: --reset context based on flag
4721: IF l_context_changed = 'T' THEN
4722: --reset back to original value
4723: IF (p_modifier_list_rec.orig_org_id IS NOT NULL AND p_modifier_list_rec.orig_org_id <> FND_API.G_MISS_NUM) THEN

Line 5000: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');

4996: x_return_status := FND_API.G_RET_STS_SUCCESS;
4997: IF (p_modifier_list_rec.offer_type = 'LUMPSUM' OR p_modifier_list_rec.offer_type = 'SCAN_DATA' ) THEN
4998: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
4999: IF (p_modifier_list_rec.currency_code IS NULL OR p_modifier_list_rec.currency_code = FND_API.G_MISS_CHAR) THEN
5000: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');
5001: x_return_status := Fnd_Api.g_ret_sts_error;
5002: RETURN;
5003: END IF;
5004: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN

Line 5006: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');

5002: RETURN;
5003: END IF;
5004: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN
5005: IF (p_modifier_list_rec.currency_code IS NULL) THEN
5006: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');
5007: x_return_status := Fnd_Api.g_ret_sts_error;
5008: RETURN;
5009: END IF;
5010: END IF;

Line 5160: l_promotional_offers_rec.status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);

5156: l_promotional_offers_rec.status_code := FND_API.g_miss_char;
5157: ELSIF l_promotional_offers_rec.user_status_id IS NULL THEN
5158: l_promotional_offers_rec.status_code := NULL;
5159: ELSE
5160: l_promotional_offers_rec.status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
5161: END IF;
5162:
5163: l_promotional_offers_rec.reusable := nvl(p_modifier_list_rec.reusable,'N');
5164: l_promotional_offers_rec.owner_id := p_modifier_list_rec.owner_id;

Line 5418: ozf_utility_pvt.debug_message('After setting index:'||p_modifierLineRec.pricing_attr_value_from);

5414: l_modifierLineRec MODIFIER_LINE_REC_TYPE;
5415: BEGIN
5416: x_return_status := FND_API.G_RET_STS_SUCCESS;
5417: l_index := nvl(x_modifiersTbl.count,0) + 1;
5418: ozf_utility_pvt.debug_message('After setting index:'||p_modifierLineRec.pricing_attr_value_from);
5419: l_modifierLineRec := p_modifierLineRec;
5420: IF p_modifierLineRec.pricing_attr_value_from IS NOT NULL AND p_modifierLineRec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
5421: l_modifierLineRec.pricing_attr_value_from := 0;
5422: END IF;

Line 5424: ozf_utility_pvt.debug_message('Calling Populate zero discount');

5420: IF p_modifierLineRec.pricing_attr_value_from IS NOT NULL AND p_modifierLineRec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
5421: l_modifierLineRec.pricing_attr_value_from := 0;
5422: END IF;
5423: IF NVL(to_number(l_modifierLineRec.pricing_attr_value_from), 0) > 0 THEN
5424: ozf_utility_pvt.debug_message('Calling Populate zero discount');
5425: populateZeroDiscount
5426: (
5427: x_return_status => x_return_status
5428: ,x_msg_count => x_msg_count

Line 5436: ozf_utility_pvt.debug_message('Calling Populate Regular discount');

5432: );
5433: l_index := l_index + 1;
5434: END IF;
5435:
5436: ozf_utility_pvt.debug_message('Calling Populate Regular discount');
5437: populateRegularDiscount
5438: (
5439: x_return_status => x_return_status
5440: ,x_msg_count => x_msg_count

Line 5604: ozf_utility_pvt.debug_message('Calling populate DIS Modifier Data');

5600: )
5601: IS
5602: BEGIN
5603: x_return_status := FND_API.G_RET_STS_SUCCESS;
5604: ozf_utility_pvt.debug_message('Calling populate DIS Modifier Data');
5605: IF p_modifierLineRec.operation = 'CREATE' THEN
5606: populateDISModifierData
5607: (
5608: x_return_status => x_return_status

Line 5620: ozf_utility_pvt.debug_message('Calling populate DIS Pricing Attr Data');

5616: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5617: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5618: END IF;
5619: END IF;
5620: ozf_utility_pvt.debug_message('Calling populate DIS Pricing Attr Data');
5621: populateDISPricingAttrData
5622: (
5623: x_return_status => x_return_status
5624: ,x_msg_count => x_msg_count

Line 5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');

5809: RAISE FND_API.G_EXC_ERROR;
5810: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5812: END IF;
5813: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.processPbhLine','QP Call in processPbhLine---');
5814: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT processPbhLine before calling QP for list_header_id : '||p_modifierLineRec.list_header_id);
5815: QP_Modifiers_PUB.process_modifiers(
5816: p_api_version_number => 1.0,
5817: p_init_msg_list => FND_API.G_FALSE,

Line 5961: OZF_Utility_PVT.error_message('OZF_OFFR_ITEM_REQD');

5957: IF (p_modifier_line_rec.PRODUCT_ATTR_VAL IS NULL OR p_modifier_line_rec.PRODUCT_ATTR_VAL = FND_API.g_miss_char)
5958: OR
5959: ( p_modifier_line_rec.PRODUCT_ATTR IS NULL OR p_modifier_line_rec.PRODUCT_ATTR = FND_API.g_miss_char )
5960: THEN
5961: OZF_Utility_PVT.error_message('OZF_OFFR_ITEM_REQD');
5962: x_return_status := Fnd_Api.g_ret_sts_error;
5963: END IF;
5964:
5965: Open QP_Vset_cur;

Line 5971: OZF_Utility_PVT.error_message('OZF_OFR_INVALID_LOV_VALUE');

5967: Close QP_Vset_cur;
5968:
5969: IF (l_value_set_id IS NOT NULL) THEN
5970: IF (validate_vset_values(l_value_set_id,p_modifier_line_rec.PRODUCT_ATTR_VAL) = 'FALSE') THEN
5971: OZF_Utility_PVT.error_message('OZF_OFR_INVALID_LOV_VALUE');
5972: x_return_status := Fnd_Api.g_ret_sts_error;
5973: END IF;
5974: END IF; --HEKKIRAL added for bug 13738807
5975:

Line 5979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_NAME'));

5975:
5976: /*IF (p_modifier_line_rec.product_attr_val IS NULL OR p_modifier_line_rec.product_attr_val = FND_API.G_MISS_CHAR)
5977: THEN
5978: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
5979: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_NAME'));
5980: FND_MSG_PUB.Add;
5981: x_return_status := FND_API.g_ret_sts_error;
5982: END IF;
5983: IF (p_modifier_line_rec.product_attr IS NULL OR p_modifier_line_rec.product_attr = FND_API.G_MISS_CHAR)

Line 5986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_LEVEL'));

5982: END IF;
5983: IF (p_modifier_line_rec.product_attr IS NULL OR p_modifier_line_rec.product_attr = FND_API.G_MISS_CHAR)
5984: THEN
5985: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
5986: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_LEVEL'));
5987: FND_MSG_PUB.Add;
5988: x_return_status := FND_API.g_ret_sts_error;
5989: END IF;*/
5990: --end of fix for bug 11694790

Line 5994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_TIER_TYPE'));

5990: --end of fix for bug 11694790
5991: IF (p_modifier_line_rec.list_line_type_code IS NULL OR p_modifier_line_rec.list_line_type_code = FND_API.G_MISS_CHAR)
5992: THEN
5993: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
5994: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_TIER_TYPE'));
5995: FND_MSG_PUB.Add;
5996: x_return_status := FND_API.g_ret_sts_error;
5997: END IF;
5998: ELSIF p_modifier_line_rec.operation = 'UPDATE' THEN

Line 6002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_LEVEL'));

5998: ELSIF p_modifier_line_rec.operation = 'UPDATE' THEN
5999: IF (p_modifier_line_rec.product_attr IS NULL )
6000: THEN
6001: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
6002: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_LEVEL'));
6003: FND_MSG_PUB.Add;
6004: x_return_status := FND_API.g_ret_sts_error;
6005: END IF;
6006: IF (p_modifier_line_rec.product_attr_val IS NULL )

Line 6009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_NAME'));

6005: END IF;
6006: IF (p_modifier_line_rec.product_attr_val IS NULL )
6007: THEN
6008: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
6009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_NAME'));
6010: FND_MSG_PUB.Add;
6011: x_return_status := FND_API.g_ret_sts_error;
6012: END IF;
6013: END IF;

Line 6017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_TIER_TYPE'));

6013: END IF;
6014: IF (p_modifier_line_rec.list_line_type_code IS NULL )
6015: THEN
6016: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
6017: FND_MESSAGE.SET_TOKEN('ATTRIBUTE',OZF_UTILITY_PVT.getAttributeName(p_attributeCode => 'OZF_TIER_TYPE'));
6018: FND_MSG_PUB.Add;
6019: x_return_status := FND_API.g_ret_sts_error;
6020: END IF;
6021: END checkRequiredItems;

Line 6420: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_regular_discounts--- l_modifiers_tbl.count = '|| l_modifiers_tbl.count);

6416: debug_message('ListLineTypeCode is :'||p_modifier_line_tbl(j).list_line_type_code);
6417: END LOOP;
6418: -- RAISE Fnd_Api.g_exc_error;
6419:
6420: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_regular_discounts--- l_modifiers_tbl.count = '|| l_modifiers_tbl.count);
6421:
6422: IF l_modifiers_tbl.count > 0 THEN -- bug 3711957. when processing PBH, l_modifiers_tbl is empty
6423: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_regular_discounts before calling for QP list_header_id : '|| l_modifiers_tbl(l_modifiers_tbl.FIRST).list_header_id);
6424: QP_Modifiers_PUB.process_modifiers(

Line 6802: l_status_code := OZF_Utility_PVT.get_system_status_code(p_new_status_id);

6798: SAVEPOINT activate_offer_api;
6799:
6800: x_return_status := FND_API.g_ret_sts_success;
6801:
6802: l_status_code := OZF_Utility_PVT.get_system_status_code(p_new_status_id);
6803:
6804: OPEN cur_get_ozf_offers;
6805: FETCH cur_get_ozf_offers
6806: INTO l_offer_rec.OFFER_ID

Line 6833: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')

6829: ,l_offer_rec.ACTIVITY_MEDIA_ID
6830: ,l_offer_rec.BREAK_TYPE;
6831: CLOSE cur_get_ozf_offers;
6832:
6833: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6834: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6835:
6836: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6837: where offer_id= l_offer_rec.qp_list_header_id;

Line 6836: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')

6832:
6833: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6834: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6835:
6836: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6837: where offer_id= l_offer_rec.qp_list_header_id;
6838:
6839: END IF;
6840:

Line 6853: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')

6849:
6850:
6851:
6852: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6853: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6854: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6855:
6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6857: where offer_id= l_offer_rec.qp_list_header_id;

Line 6854: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN

6850:
6851:
6852: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6853: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6854: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6855:
6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6857: where offer_id= l_offer_rec.qp_list_header_id;
6858:

Line 6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')

6852: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6853: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6854: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6855:
6856: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6857: where offer_id= l_offer_rec.qp_list_header_id;
6858:
6859: END IF;
6860:

Line 6898: user_status_id = decode(l_amount_error, 'Y', OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT')),'N', p_new_status_id)

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,
6897: object_version_number = object_version_number + 1,
6898: user_status_id = decode(l_amount_error, 'Y', OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT')),'N', p_new_status_id)
6899: WHERE qp_list_header_id = p_qp_list_header_id;
6900:
6901: /*
6902: -- julou if recal = 'N' if approved>committed -> active otherwise pending_active

Line 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)

6904: UPDATE ozf_offers
6905: SET status_code = decode(l_amount_error,'Y','PENDING_ACTIVE','N','ACTIVE'),
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);

Line 6921: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DRAFT')

6917: UPDATE ozf_offers
6918: SET status_code = 'DRAFT',
6919: status_date = SYSDATE,
6920: object_version_number = object_version_number + 1,
6921: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DRAFT')
6922: WHERE qp_list_header_id = p_qp_list_header_id;
6923: END IF;
6924: END IF;
6925: */

Line 7054: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value---');

7050: NULL;
7051: ELSE
7052: l_discount_level := 'LINEGROUP';
7053: END IF;
7054: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value---');
7055:
7056: FOR i in p_modifier_line_tbl.first..p_modifier_line_tbl.last LOOP
7057: IF p_modifier_line_tbl.exists(i) THEN
7058:

Line 7255: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value 2---p_modifier_line_tbl.count = '|| p_modifier_line_tbl.count);

7251: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT process_order_value before calling QP for list_header_id : '||p_modifier_line_tbl(p_modifier_line_tbl.first).list_header_id);
7252:
7253: END LOOP;
7254:
7255: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'QP Call in process_order_value 2---p_modifier_line_tbl.count = '|| p_modifier_line_tbl.count);
7256: QP_Modifiers_PUB.process_modifiers(
7257: p_api_version_number => 1.0,
7258: p_init_msg_list => FND_API.G_FALSE,
7259: p_return_values => FND_API.G_FALSE,

Line 7536: OZF_Utility_PVT.error_message('OZF_OFFR_ITEM_REQD');

7532: IF (p_modifier_line_tbl(i).PRODUCT_ATTR_VAL IS NULL OR p_modifier_line_tbl(i).PRODUCT_ATTR_VAL = FND_API.g_miss_char)
7533: OR
7534: ( p_modifier_line_tbl(i).PRODUCT_ATTR IS NULL OR p_modifier_line_tbl(i).PRODUCT_ATTR = FND_API.g_miss_char )
7535: THEN
7536: OZF_Utility_PVT.error_message('OZF_OFFR_ITEM_REQD');
7537: x_return_status := Fnd_Api.g_ret_sts_error;
7538: END IF;
7539: END LOOP;
7540: END check_pg_reqd_items;

Line 8688: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');

8684: THEN
8685: IF
8686: (p_modifier_line_tbl(i).list_line_type_code = 'DIS' AND p_modifier_line_tbl(i).arithmetic_operator <> '%' )
8687: THEN
8688: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');
8689: x_return_status := FND_API.G_RET_STS_ERROR;
8690: RAISE FND_API.g_exc_error;
8691: END IF;
8692: END IF;

Line 8700: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');

8696: THEN
8697: IF
8698: (p_modifier_line_tbl(i).list_line_type_code = 'DIS' AND p_modifier_line_tbl(i).qd_arithmetic_operator <> '%' )
8699: THEN
8700: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');
8701: x_return_status := FND_API.G_RET_STS_ERROR;
8702: RAISE FND_API.g_exc_error;
8703: END IF;
8704: END IF;

Line 8896: OZF_Utility_PVT.error_message('OZF_EVE_NO_BGT_SRC');

8892: CLOSE c_budget_exist;
8893:
8894:
8895: IF l_budget_exist IS NULL THEN
8896: OZF_Utility_PVT.error_message('OZF_EVE_NO_BGT_SRC');
8897: RAISE FND_API.g_exc_error;
8898: END IF;
8899:
8900:

Line 9476: l_new_status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);

9472:
9473: IF (p_modifier_list_rec.user_status_id <> FND_API.g_miss_num)
9474: AND (p_modifier_list_rec.user_status_id <> l_old_status_id) THEN
9475:
9476: l_new_status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
9477:
9478: --IF l_new_status_code = 'ACTIVE' THEN
9479:
9480: OZF_Utility_PVT.check_new_status_change

Line 9480: OZF_Utility_PVT.check_new_status_change

9476: l_new_status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
9477:
9478: --IF l_new_status_code = 'ACTIVE' THEN
9479:
9480: OZF_Utility_PVT.check_new_status_change
9481: (
9482: p_object_type => 'OFFR',
9483: p_object_id => p_modifier_list_rec.qp_list_header_id,
9484: p_old_status_id => l_old_status_id,

Line 9511: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'ozf_offers_pvt.process_modifiers before calling offer_dates getDateQualifier = '|| getDateQualifier(p_qpListHeaderId => p_modifier_list_rec.qp_list_header_id));

9507: IF p_modifier_list_rec.offer_type = 'VOLUME_OFFER' THEN
9508: l_modifier_list_rec.offer_type := p_modifier_list_rec.volume_offer_type;
9509: END IF;
9510:
9511: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,l_full_name,'ozf_offers_pvt.process_modifiers before calling offer_dates getDateQualifier = '|| getDateQualifier(p_qpListHeaderId => p_modifier_list_rec.qp_list_header_id));
9512: IF p_modifier_list_rec.modifier_operation = 'UPDATE' THEN
9513: IF getDateQualifier(p_qpListHeaderId => p_modifier_list_rec.qp_list_header_id) = 'A'
9514: THEN
9515: offer_dates(

Line 9648: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','SUBMITTED_TA');

9644: END IF;
9645: END IF;
9646:
9647: IF l_approval_type = 'THEME' THEN
9648: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','SUBMITTED_TA');
9649: temp_modifier_list_rec.status_code := 'SUBMITTED_TA';
9650: ELSIF l_approval_type = 'BUDGET' THEN
9651: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING');
9652: temp_modifier_list_rec.status_code := 'PENDING';

Line 9651: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING');

9647: IF l_approval_type = 'THEME' THEN
9648: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','SUBMITTED_TA');
9649: temp_modifier_list_rec.status_code := 'SUBMITTED_TA';
9650: ELSIF l_approval_type = 'BUDGET' THEN
9651: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING');
9652: temp_modifier_list_rec.status_code := 'PENDING';
9653: -- julou budget w/o approval scenario
9654: ELSIF l_budget_required = 'Y' THEN
9655: IF l_new_status_code = 'ACTIVE' THEN

Line 9656: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING_VALIDATION');

9652: temp_modifier_list_rec.status_code := 'PENDING';
9653: -- julou budget w/o approval scenario
9654: ELSIF l_budget_required = 'Y' THEN
9655: IF l_new_status_code = 'ACTIVE' THEN
9656: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING_VALIDATION');
9657: temp_modifier_list_rec.status_code := 'PENDING_VALIDATION';
9658: END IF;
9659: ELSE -- no validation or approval required
9660: IF l_new_status_code = 'ACTIVE' THEN

Line 9666: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');

9662: FETCH c_budget_req_count INTO l_budget_req_count;
9663: CLOSE c_budget_req_count;
9664:
9665: IF l_budget_req_count = 0 THEN
9666: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');
9667: temp_modifier_list_rec.status_code := 'ACTIVE';
9668: ELSE
9669: OZF_budgetapproval_pvt.budget_request_approval(
9670: p_init_msg_list => FND_API.G_FALSE

Line 9686: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);

9682: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
9683: RAISE Fnd_Api.g_exc_unexpected_error;
9684: END IF;
9685:
9686: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);
9687: temp_modifier_list_rec.status_code := l_status_code;
9688: END IF;
9689: END IF;
9690: -- julou end

Line 9906: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);

9902: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
9903: RAISE Fnd_Api.g_exc_unexpected_error;
9904: END IF;
9905:
9906: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);
9907: temp_modifier_list_rec.status_code := l_status_code;
9908: END IF;
9909: --julou end BREQ
9910: -- julou handle status depending on recal(handled by activate_offer_over).

Line 9938: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')

9934: ELSIF l_status_code = 'DRAFT' THEN
9935: -- CP validation fails. update offer to DRAFT
9936: UPDATE ozf_offers
9937: SET status_code = 'DRAFT'
9938: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
9939: ,status_date = SYSDATE
9940: ,object_version_number = object_version_number + 1
9941: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
9942: END IF;

Line 9966: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED'),

9962: p_approval_type => 'BUDGET',
9963: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9964: p_orig_stat_id => l_old_status_id,
9965: p_new_stat_id => p_modifier_list_rec.user_status_id,
9966: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED'),
9967: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9968: p_workflowprocess => 'AMS_APPROVAL',
9969: p_item_type => 'AMSAPRV');
9970: ELSE

Line 9967: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),

9963: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9964: p_orig_stat_id => l_old_status_id,
9965: p_new_stat_id => p_modifier_list_rec.user_status_id,
9966: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED'),
9967: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9968: p_workflowprocess => 'AMS_APPROVAL',
9969: p_item_type => 'AMSAPRV');
9970: ELSE
9971: Activate_Offer_over(

Line 9997: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA'),

9993: p_approval_type => 'CONCEPT',
9994: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9995: p_orig_stat_id => l_old_status_id,
9996: p_new_stat_id => p_modifier_list_rec.user_status_id,
9997: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA'),
9998: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9999: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
10000: p_item_type => 'AMSAPRV');
10001: END IF;

Line 9998: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),

9994: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9995: p_orig_stat_id => l_old_status_id,
9996: p_new_stat_id => p_modifier_list_rec.user_status_id,
9997: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA'),
9998: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9999: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
10000: p_item_type => 'AMSAPRV');
10001: END IF;
10002: END IF;

Line 10210: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')

10206:
10207: END IF;
10208:
10209: IF p_modifier_list_rec.custom_setup_id = 118 THEN
10210: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
10211: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
10212:
10213:
10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')

Line 10211: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --

10207: END IF;
10208:
10209: IF p_modifier_list_rec.custom_setup_id = 118 THEN
10210: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
10211: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
10212:
10213:
10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
10215: where offer_id=p_modifier_list_rec.qp_list_header_id;

Line 10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')

10210: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
10211: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
10212:
10213:
10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
10215: where offer_id=p_modifier_list_rec.qp_list_header_id;
10216:
10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
10218:

Line 10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN

10213:
10214: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
10215: where offer_id=p_modifier_list_rec.qp_list_header_id;
10216:
10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
10218:
10219: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
10220: where offer_id= p_modifier_list_rec.qp_list_header_id;
10221:

Line 10219: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')

10215: where offer_id=p_modifier_list_rec.qp_list_header_id;
10216:
10217: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
10218:
10219: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
10220: where offer_id= p_modifier_list_rec.qp_list_header_id;
10221:
10222: END IF;
10223: END IF;

Line 10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');

10932: RAISE FND_API.G_EXC_ERROR;
10933: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
10934: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
10935: END IF;
10936: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.pushDiscountRuleToQp','QP Call in pushDiscountRuleToQp---');
10937: OZF_DEBUG_PVT.DEBUG_MO('OZF_OFFER_PVT pushDiscountRuleToQp before calling QP for list_header_id : '||p_qp_list_header_id);
10938: QP_Modifiers_PUB.process_modifiers(
10939: p_api_version_number => 1.0,
10940: p_init_msg_list => FND_API.G_FALSE,

Line 11483: ozf_utility_pvt.convert_currency (

11479:
11480: IF line_rec.product_cost_currency
11481: <> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency) THEN
11482:
11483: ozf_utility_pvt.convert_currency (
11484: x_return_status=> x_return_status,
11485: p_from_currency=> line_rec.product_cost_currency,
11486: p_to_currency=> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency),
11487: p_conv_date=> sysdate,

Line 11517: ozf_utility_pvt.convert_currency (

11513:
11514: IF x_modifier_line_tbl(l_prod_index).ARITHMETIC_OPERATOR IN ('AMT', 'NEWPRICE')
11515: AND NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency)
11516: <> NVL(l_sales_order_currency,l_request_currency_code) THEN
11517: ozf_utility_pvt.convert_currency (
11518: x_return_status=> x_return_status,
11519: p_from_currency=> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency),
11520: p_to_currency=> NVL(l_sales_order_currency,l_request_currency_code),
11521: p_conv_date=> sysdate,

Line 12289: IF l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CANCELLED')

12285: OPEN c_get_sdr_status(p_sdr_header_id);
12286: FETCH c_get_sdr_status INTO l_sdr_status_id;
12287: CLOSE c_get_sdr_status;
12288:
12289: IF l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CANCELLED')
12290: OR l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CLOSED') THEN
12291:
12292: OPEN c_offer_info(x_qp_list_header_id);
12293: FETCH c_offer_info INTO l_modifier_list_rec.offer_id, l_modifier_list_rec.offer_type,

Line 12290: OR l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CLOSED') THEN

12286: FETCH c_get_sdr_status INTO l_sdr_status_id;
12287: CLOSE c_get_sdr_status;
12288:
12289: IF l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CANCELLED')
12290: OR l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CLOSED') THEN
12291:
12292: OPEN c_offer_info(x_qp_list_header_id);
12293: FETCH c_offer_info INTO l_modifier_list_rec.offer_id, l_modifier_list_rec.offer_type,
12294: l_modifier_list_rec.custom_setup_id, l_modifier_list_rec.offer_code,

Line 12307: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','COMPLETED');

12303: l_modifier_list_rec.offer_operation := 'UPDATE';
12304: l_modifier_list_rec.status_code := 'COMPLETED';
12305: l_modifier_list_rec.modifier_operation := 'UPDATE';
12306: --l_modifier_list_rec.operation := 'UPDATE';
12307: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','COMPLETED');
12308: l_qp_list_header_id := x_qp_list_header_id;
12309:
12310: /*Complete Offer*/
12311: process_modifiers(

Line 12351: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;

12347: IF l_operation = 'CREATE' THEN
12348:
12349: l_modifier_list_rec.modifier_operation := 'CREATE';
12350: l_modifier_list_rec.status_code := 'DRAFT';
12351: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
12352:
12353: IF l_modifier_list_rec.OWNER_ID IS NULL OR l_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
12354: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(NVL(FND_GLOBAL.user_id,-1));
12355: ELSE

Line 12354: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(NVL(FND_GLOBAL.user_id,-1));

12350: l_modifier_list_rec.status_code := 'DRAFT';
12351: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
12352:
12353: IF l_modifier_list_rec.OWNER_ID IS NULL OR l_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
12354: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(NVL(FND_GLOBAL.user_id,-1));
12355: ELSE
12356: l_modifier_list_rec.OWNER_ID := l_modifier_list_rec.OWNER_ID;
12357: END IF;
12358:

Line 12468: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(l_modifier_list_rec.user_status_id);

12464: --dbms_output.put_line('l_modifier_list_rec.user_status_id set operation as update' );
12465: l_modifier_list_rec.offer_operation := 'UPDATE';
12466: l_modifier_list_rec.modifier_operation := 'UPDATE';
12467: l_modifier_list_rec.user_status_id := l_modifier_list_rec.user_status_id;
12468: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(l_modifier_list_rec.user_status_id);
12469: END IF;
12470:
12471: /*Create Qualifier Line Records*/
12472: --dbms_output.put_line('N: x_qp_list_header_id '||x_qp_list_header_id);

Line 12492: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.process_sd_modifiers','before process_market_qualifiers 5');

12488: RAISE Fnd_Api.g_exc_unexpected_error;
12489: END IF;
12490:
12491: /*Create Market Qualifiers*/
12492: OZF_Utility_PVT.debug_message(FND_LOG.LEVEL_STATEMENT,'OZF_OFFER_PVT.process_sd_modifiers','before process_market_qualifiers 5');
12493: process_market_qualifiers(
12494: p_init_msg_list => p_init_msg_list
12495: ,p_api_version => p_api_version
12496: ,p_commit => p_commit

Line 12616: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');

12612: l_modifier_list_rec.offer_operation := 'UPDATE';
12613: l_modifier_list_rec.status_code := 'ACTIVE';
12614: l_modifier_list_rec.modifier_operation := 'UPDATE';
12615: --l_modifier_list_rec.operation := 'UPDATE';
12616: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');
12617: l_qp_list_header_id := x_qp_list_header_id;
12618:
12619: /*Activate Offer*/
12620: process_modifiers(

Line 12635: /*IF l_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN

12631: ,x_error_location => x_error_location);
12632:
12633: /*added this code to make SDR active */
12634:
12635: /*IF l_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
12636:
12637: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
12638:
12639: update ozf_sd_request_headers_all_b

Line 12640: set user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')

12636:
12637: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
12638:
12639: update ozf_sd_request_headers_all_b
12640: set user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
12641: where request_header_id = p_sdr_header_id;
12642:
12643: END IF;*/
12644:

Line 12671: OPEN c_access_exists (ozf_utility_pvt.get_resource_id(nvl(l_offer_access_rec.user_id,-1)),l_qp_list_header_id);

12667: FOR l_offer_access_rec IN c_offer_access(l_qp_list_header_id,p_sdr_header_id) LOOP
12668: debug_message('N: l_offer_access_rec.user_id '||l_offer_access_rec.user_id);
12669: debug_message('N: l_qp_list_header_id '||l_qp_list_header_id);
12670: l_access_exists := 0;
12671: OPEN c_access_exists (ozf_utility_pvt.get_resource_id(nvl(l_offer_access_rec.user_id,-1)),l_qp_list_header_id);
12672: FETCH c_access_exists INTO l_access_exists;
12673: CLOSE c_access_exists;
12674: debug_message('N: l_access_exists '||l_access_exists);
12675: debug_message('N: l_offer_access_rec.status '|| l_offer_access_rec.status);

Line 12681: l_access_rec.user_or_role_id := ozf_utility_pvt.get_resource_id(l_offer_access_rec.user_id);

12677: IF l_access_exists <> 1 AND l_offer_access_rec.status='REQUEST' THEN
12678: --CREATE
12679: l_access_rec.act_access_to_object_id := l_qp_list_header_id;
12680: l_access_rec.arc_act_access_to_object := 'OFFR';
12681: l_access_rec.user_or_role_id := ozf_utility_pvt.get_resource_id(l_offer_access_rec.user_id);
12682: l_access_rec.arc_user_or_role_type := 'USER';
12683: l_access_rec.admin_flag := 'Y';
12684: l_access_rec.owner_flag := 'N';
12685: debug_message('N: l_access_rec.user_or_role_id '||l_access_rec.user_or_role_id);