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 198: ozf_utility_pvt.debug_message(p_message);

194: IS
195: BEGIN
196:
197: IF (OZF_DEBUG_HIGH_ON) THEN
198: ozf_utility_pvt.debug_message(p_message);
199:
200: END IF;
201: END debug_message;
202:

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

1887: IF p_operation = 'UPDATE' AND p_modifier_list_rec.offer_type = 'SCAN_DATA' AND get_budget_source_count(p_modifier_list_rec.qp_list_header_id) =1 THEN
1888: OPEN cur_get_offer_budget;
1889: FETCH cur_get_offer_budget INTO l_act_budgets_rec.activity_budget_id, l_act_budgets_rec.object_version_number;
1890: CLOSE cur_get_offer_budget;
1891: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_type: ' || l_act_budgets_rec.budget_source_type);
1892: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_id: ' || l_act_budgets_rec.budget_source_id);
1893:
1894: OZF_Actbudgets_Pvt.update_act_budgets(
1895: p_api_version => l_api_version

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

1888: OPEN cur_get_offer_budget;
1889: FETCH cur_get_offer_budget INTO l_act_budgets_rec.activity_budget_id, l_act_budgets_rec.object_version_number;
1890: CLOSE cur_get_offer_budget;
1891: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_type: ' || l_act_budgets_rec.budget_source_type);
1892: ozf_utility_pvt.debug_message('GR: l_act_budgets_rec.budget_source_id: ' || l_act_budgets_rec.budget_source_id);
1893:
1894: OZF_Actbudgets_Pvt.update_act_budgets(
1895: p_api_version => l_api_version
1896: ,p_init_msg_list => Fnd_Api.g_false

Line 2780: OZF_Utility_PVT.check_new_status_change

2776: OPEN c_old_user_status_id;
2777: FETCH c_old_user_status_id INTO l_old_status_id;
2778: CLOSE c_old_user_status_id;
2779:
2780: OZF_Utility_PVT.check_new_status_change
2781: (
2782: p_object_type => 'OFFR',
2783: p_object_id => l_offer_rec.qp_list_header_id,
2784: p_old_status_id => l_old_status_id,

Line 2924: OZF_Utility_PVT.check_new_status_change

2920: OPEN c_old_user_status_id;
2921: FETCH c_old_user_status_id INTO l_old_status_id;
2922: CLOSE c_old_user_status_id;
2923:
2924: OZF_Utility_PVT.check_new_status_change
2925: (
2926: p_object_type => 'OFFR',
2927: p_object_id => l_offer_rec.qp_list_header_id,
2928: p_old_status_id => l_old_status_id,

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

3106: IF p_offer_rec.offer_type IN ('SCAN_DATA', 'NET_ACCRUAL')
3107: OR (p_offer_rec.offer_type = 'LUMPSUM' AND p_offer_rec.custom_setup_id <> 110) -- not applicable to soft fund
3108: THEN
3109: IF p_offer_rec.start_date_active IS NULL THEN
3110: ozf_utility_pvt.error_message('OZF_OFFR_NO_START_DATE');
3111: RAISE FND_API.G_EXC_ERROR;
3112: END IF;
3113: END IF;
3114:

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

3264: END IF;
3265: END IF;
3266:
3267: IF l_committed_amount > l_approved_amount THEN
3268: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_OFFER_AMNT_GT_APPR_AMNT');
3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;
3271: ELSIF l_recal = 'Y' AND p_offer_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA') THEN
3272: IF l_approved_amount < 0 THEN

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

3269: RAISE FND_API.G_EXC_ERROR;
3270: END IF;
3271: ELSIF l_recal = 'Y' AND p_offer_rec.offer_type NOT IN ('LUMPSUM', 'SCAN_DATA') THEN
3272: IF l_approved_amount < 0 THEN
3273: OZF_Utility_PVT.Error_Message(p_message_name => 'OZF_NO_APPROVED_AMOUNT');
3274: RAISE FND_API.G_EXC_ERROR;
3275: END IF;
3276: END IF;
3277: END IF;

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

3360: OPEN c_request_amount;
3361: FETCH c_request_amount INTO l_request_amount;
3362: IF c_request_amount%NOTFOUND THEN
3363: CLOSE c_request_amount;
3364: OZF_Utility_PVT.Error_Message('OZF_OFFR_NO_BUDGET_REQUEST');
3365: RAISE FND_API.G_EXC_ERROR;
3366: END IF;
3367: CLOSE c_request_amount;
3368:

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

3370: FETCH c_committed_amount INTO l_committed_amount;
3371: CLOSE c_committed_amount;
3372:
3373: IF l_committed_amount > l_request_amount THEN
3374: OZF_Utility_PVT.Error_Message('OZF_OFFR_REQAMT_LT_OFFAMT');
3375: RAISE FND_API.G_EXC_ERROR;
3376: END IF;
3377:
3378: FND_MSG_PUB.Count_And_Get

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

3710: FROM ozf_sd_request_headers_all_b sdr, ozf_offers off
3711: --WHERE nvl(sdr.authorization_number,sdr.request_number) = off.offer_code
3712: WHERE sdr.request_number = off.offer_code
3713: AND off.qp_list_header_id = p_offer_id
3714: AND sdr.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'PENDING_OFFER_APPROVAL');
3715:
3716:
3717: l_api_name CONSTANT VARCHAR2(30) := 'Activate_Offer_Over';
3718: l_api_version CONSTANT NUMBER := 1.0;

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

3774: IF p_offer_rec.status_code = 'DRAFT' THEN
3775: -- CP validation fails. update offer to DRAFT
3776: UPDATE ozf_offers
3777: SET status_code = 'DRAFT'
3778: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
3779: ,status_date = SYSDATE
3780: ,object_version_number = object_version_number + 1
3781: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3782: ELSE

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

3798: UPDATE ozf_offers
3799: SET status_code = 'PENDING_ACTIVE',
3800: status_date = SYSDATE,
3801: object_version_number = object_version_number + 1,
3802: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'PENDING_ACTIVE')
3803: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3804: ELSE
3805: UPDATE ozf_offers
3806: SET status_code = DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'),

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

3805: UPDATE ozf_offers
3806: SET status_code = DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'),
3807: status_date = SYSDATE,
3808: object_version_number = object_version_number + 1,
3809: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', DECODE(l_recal, 'N', 'PENDING_ACTIVE', 'Y', 'DRAFT'))
3810: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3811: END IF;
3812: ELSE -- called from B/ set amount error and the caller takes care of status
3813: x_amount_error := 'Y';

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

3891: SET status_code = 'ACTIVE',
3892: status_date = SYSDATE,
3893: object_version_number = object_version_number + 1,
3894: start_date = l_start_date,
3895: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS', 'ACTIVE')
3896: WHERE qp_list_header_id = p_offer_rec.qp_list_header_id;
3897:
3898: IF p_offer_rec.custom_setup_id = 110 THEN -- soft fund offers
3899: -- update ozf_request_headers_all_b update activating

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

3902: x_msg_data => x_msg_data,
3903: p_qp_list_header_id => p_offer_rec.qp_list_header_id);
3904: END IF;
3905:
3906: ozf_utility_pvt.write_conc_log('p_offer_rec.custom_setup_id '||p_offer_rec.custom_setup_id);
3907: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
3908:
3909:
3910: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers

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

3903: p_qp_list_header_id => p_offer_rec.qp_list_header_id);
3904: END IF;
3905:
3906: ozf_utility_pvt.write_conc_log('p_offer_rec.custom_setup_id '||p_offer_rec.custom_setup_id);
3907: ozf_utility_pvt.write_conc_log('p_offer_rec.qp_list_header_id '||p_offer_rec.qp_list_header_id);
3908:
3909:
3910: IF p_offer_rec.custom_setup_id = 118 THEN -- SD offers
3911: -- update ozf_sd_request_headers_all_b update activating

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

3912: OPEN c_sd_req_header_rec(p_offer_rec.qp_list_header_id);
3913: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
3914: CLOSE c_sd_req_header_rec;
3915:
3916: ozf_utility_pvt.write_conc_log('l_obj_ver_num '||l_obj_ver_num);
3917: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
3918:
3919: --fix for bug 7004273
3920:

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

3913: FETCH c_sd_req_header_rec INTO l_obj_ver_num , l_sdr_req_header_id;
3914: CLOSE c_sd_req_header_rec;
3915:
3916: ozf_utility_pvt.write_conc_log('l_obj_ver_num '||l_obj_ver_num);
3917: ozf_utility_pvt.write_conc_log('l_sdr_req_header_id '|| l_sdr_req_header_id);
3918:
3919: --fix for bug 7004273
3920:
3921: UPDATE ozf_sd_request_headers_all_b

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

3918:
3919: --fix for bug 7004273
3920:
3921: UPDATE ozf_sd_request_headers_all_b
3922: SET user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS', 'ACTIVE') ,
3923: object_version_number = l_obj_ver_num + 1
3924: WHERE request_header_id = l_sdr_req_header_id;
3925: END IF;
3926:

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

4363: );
4364: ELSE
4365: l_modifier_list_rec.name := p_modifier_list_rec.offer_code;
4366:
4367: l_uk_flag := OZF_Utility_PVT.check_uniqueness('AMS_SOURCE_CODES','source_code = ''' || p_modifier_list_rec.offer_code || '''');
4368:
4369: IF l_uk_flag = Fnd_Api.g_false THEN
4370: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
4371: Fnd_Message.set_name('OZF', 'OZF_ACT_OFFER_DUP_OFFER_CODE');

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

4618: x_return_status := FND_API.G_RET_STS_SUCCESS;
4619: IF (p_modifier_list_rec.offer_type = 'LUMPSUM' OR p_modifier_list_rec.offer_type = 'SCAN_DATA' ) THEN
4620: IF p_modifier_list_rec.offer_operation = 'CREATE' THEN
4621: IF (p_modifier_list_rec.currency_code IS NULL OR p_modifier_list_rec.currency_code = FND_API.G_MISS_CHAR) THEN
4622: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');
4623: x_return_status := Fnd_Api.g_ret_sts_error;
4624: RETURN;
4625: END IF;
4626: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN

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

4624: RETURN;
4625: END IF;
4626: ELSIF p_modifier_list_rec.offer_operation = 'UPDATE' THEN
4627: IF (p_modifier_list_rec.currency_code IS NULL) THEN
4628: OZF_Utility_PVT.error_message('OZF_OFFR_LS_SD_CURR_REQD');
4629: x_return_status := Fnd_Api.g_ret_sts_error;
4630: RETURN;
4631: END IF;
4632: END IF;

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

4778: l_promotional_offers_rec.status_code := FND_API.g_miss_char;
4779: ELSIF l_promotional_offers_rec.user_status_id IS NULL THEN
4780: l_promotional_offers_rec.status_code := NULL;
4781: ELSE
4782: l_promotional_offers_rec.status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
4783: END IF;
4784:
4785: l_promotional_offers_rec.reusable := nvl(p_modifier_list_rec.reusable,'N');
4786: l_promotional_offers_rec.owner_id := p_modifier_list_rec.owner_id;

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

5036: l_modifierLineRec MODIFIER_LINE_REC_TYPE;
5037: BEGIN
5038: x_return_status := FND_API.G_RET_STS_SUCCESS;
5039: l_index := nvl(x_modifiersTbl.count,0) + 1;
5040: ozf_utility_pvt.debug_message('After setting index:'||p_modifierLineRec.pricing_attr_value_from);
5041: l_modifierLineRec := p_modifierLineRec;
5042: IF p_modifierLineRec.pricing_attr_value_from IS NOT NULL AND p_modifierLineRec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
5043: l_modifierLineRec.pricing_attr_value_from := 0;
5044: END IF;

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

5042: IF p_modifierLineRec.pricing_attr_value_from IS NOT NULL AND p_modifierLineRec.pricing_attr_value_from <> FND_API.G_MISS_CHAR THEN
5043: l_modifierLineRec.pricing_attr_value_from := 0;
5044: END IF;
5045: IF NVL(to_number(l_modifierLineRec.pricing_attr_value_from), 0) > 0 THEN
5046: ozf_utility_pvt.debug_message('Calling Populate zero discount');
5047: populateZeroDiscount
5048: (
5049: x_return_status => x_return_status
5050: ,x_msg_count => x_msg_count

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

5054: );
5055: l_index := l_index + 1;
5056: END IF;
5057:
5058: ozf_utility_pvt.debug_message('Calling Populate Regular discount');
5059: populateRegularDiscount
5060: (
5061: x_return_status => x_return_status
5062: ,x_msg_count => x_msg_count

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

5222: )
5223: IS
5224: BEGIN
5225: x_return_status := FND_API.G_RET_STS_SUCCESS;
5226: ozf_utility_pvt.debug_message('Calling populate DIS Modifier Data');
5227: IF p_modifierLineRec.operation = 'CREATE' THEN
5228: populateDISModifierData
5229: (
5230: x_return_status => x_return_status

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

5238: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
5239: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5240: END IF;
5241: END IF;
5242: ozf_utility_pvt.debug_message('Calling populate DIS Pricing Attr Data');
5243: populateDISPricingAttrData
5244: (
5245: x_return_status => x_return_status
5246: ,x_msg_count => x_msg_count

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

6268: SAVEPOINT activate_offer_api;
6269:
6270: x_return_status := FND_API.g_ret_sts_success;
6271:
6272: l_status_code := OZF_Utility_PVT.get_system_status_code(p_new_status_id);
6273:
6274: OPEN cur_get_ozf_offers;
6275: FETCH cur_get_ozf_offers
6276: INTO l_offer_rec.OFFER_ID

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

6299: ,l_offer_rec.ACTIVITY_MEDIA_ID
6300: ,l_offer_rec.BREAK_TYPE;
6301: CLOSE cur_get_ozf_offers;
6302:
6303: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6304: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6305:
6306: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6307: where offer_id= l_offer_rec.qp_list_header_id;

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

6302:
6303: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE')
6304: AND l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6305:
6306: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
6307: where offer_id= l_offer_rec.qp_list_header_id;
6308:
6309: END IF;
6310:

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

6319:
6320:
6321:
6322: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6323: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6324: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6325:
6326: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6327: where offer_id= l_offer_rec.qp_list_header_id;

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

6320:
6321:
6322: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6323: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6324: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6325:
6326: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6327: where offer_id= l_offer_rec.qp_list_header_id;
6328:

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

6322: IF l_offer_rec.CUSTOM_SETUP_ID = 118 THEN
6323: IF p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
6324: OR p_new_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN
6325:
6326: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
6327: where offer_id= l_offer_rec.qp_list_header_id;
6328:
6329: END IF;
6330:

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

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,
6367: object_version_number = object_version_number + 1,
6368: 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)
6369: WHERE qp_list_header_id = p_qp_list_header_id;
6370:
6371: /*
6372: -- julou if recal = 'N' if approved>committed -> active otherwise pending_active

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

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

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

6387: UPDATE ozf_offers
6388: SET status_code = 'DRAFT',
6389: status_date = SYSDATE,
6390: object_version_number = object_version_number + 1,
6391: user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DRAFT')
6392: WHERE qp_list_header_id = p_qp_list_header_id;
6393: END IF;
6394: END IF;
6395: */

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

6998: 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)
6999: OR
7000: ( p_modifier_line_tbl(i).PRODUCT_ATTR IS NULL OR p_modifier_line_tbl(i).PRODUCT_ATTR = FND_API.g_miss_char )
7001: THEN
7002: OZF_Utility_PVT.error_message('OZF_OFFR_ITEM_REQD');
7003: x_return_status := Fnd_Api.g_ret_sts_error;
7004: END IF;
7005: END LOOP;
7006: END check_pg_reqd_items;

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

8150: THEN
8151: IF
8152: (p_modifier_line_tbl(i).list_line_type_code = 'DIS' AND p_modifier_line_tbl(i).arithmetic_operator <> '%' )
8153: THEN
8154: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');
8155: x_return_status := FND_API.G_RET_STS_ERROR;
8156: RAISE FND_API.g_exc_error;
8157: END IF;
8158: END IF;

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

8162: THEN
8163: IF
8164: (p_modifier_line_tbl(i).list_line_type_code = 'DIS' AND p_modifier_line_tbl(i).qd_arithmetic_operator <> '%' )
8165: THEN
8166: OZF_Utility_PVT.error_message('OZF_OFFR_OPT_CURR_PCNT');
8167: x_return_status := FND_API.G_RET_STS_ERROR;
8168: RAISE FND_API.g_exc_error;
8169: END IF;
8170: END IF;

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

8358: CLOSE c_budget_exist;
8359:
8360:
8361: IF l_budget_exist IS NULL THEN
8362: OZF_Utility_PVT.error_message('OZF_EVE_NO_BGT_SRC');
8363: RAISE FND_API.g_exc_error;
8364: END IF;
8365:
8366:

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

8903:
8904: IF (p_modifier_list_rec.user_status_id <> FND_API.g_miss_num)
8905: AND (p_modifier_list_rec.user_status_id <> l_old_status_id) THEN
8906:
8907: l_new_status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
8908:
8909: --IF l_new_status_code = 'ACTIVE' THEN
8910:
8911: OZF_Utility_PVT.check_new_status_change

Line 8911: OZF_Utility_PVT.check_new_status_change

8907: l_new_status_code := OZF_Utility_PVT.get_system_status_code(p_modifier_list_rec.user_status_id);
8908:
8909: --IF l_new_status_code = 'ACTIVE' THEN
8910:
8911: OZF_Utility_PVT.check_new_status_change
8912: (
8913: p_object_type => 'OFFR',
8914: p_object_id => p_modifier_list_rec.qp_list_header_id,
8915: p_old_status_id => l_old_status_id,

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

9064: END IF;
9065: END IF;
9066:
9067: IF l_approval_type = 'THEME' THEN
9068: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','SUBMITTED_TA');
9069: temp_modifier_list_rec.status_code := 'SUBMITTED_TA';
9070: ELSIF l_approval_type = 'BUDGET' THEN
9071: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING');
9072: temp_modifier_list_rec.status_code := 'PENDING';

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

9067: IF l_approval_type = 'THEME' THEN
9068: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','SUBMITTED_TA');
9069: temp_modifier_list_rec.status_code := 'SUBMITTED_TA';
9070: ELSIF l_approval_type = 'BUDGET' THEN
9071: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING');
9072: temp_modifier_list_rec.status_code := 'PENDING';
9073: -- julou budget w/o approval scenario
9074: ELSIF l_budget_required = 'Y' THEN
9075: IF l_new_status_code = 'ACTIVE' THEN

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

9072: temp_modifier_list_rec.status_code := 'PENDING';
9073: -- julou budget w/o approval scenario
9074: ELSIF l_budget_required = 'Y' THEN
9075: IF l_new_status_code = 'ACTIVE' THEN
9076: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','PENDING_VALIDATION');
9077: temp_modifier_list_rec.status_code := 'PENDING_VALIDATION';
9078: END IF;
9079: ELSE -- no validation or approval required
9080: IF l_new_status_code = 'ACTIVE' THEN

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

9082: FETCH c_budget_req_count INTO l_budget_req_count;
9083: CLOSE c_budget_req_count;
9084:
9085: IF l_budget_req_count = 0 THEN
9086: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');
9087: temp_modifier_list_rec.status_code := 'ACTIVE';
9088: ELSE
9089: OZF_budgetapproval_pvt.budget_request_approval(
9090: p_init_msg_list => FND_API.G_FALSE

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

9102: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
9103: RAISE Fnd_Api.g_exc_unexpected_error;
9104: END IF;
9105:
9106: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);
9107: temp_modifier_list_rec.status_code := l_status_code;
9108: END IF;
9109: END IF;
9110: -- julou end

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

9321: ELSIF x_return_status = Fnd_Api.g_ret_sts_unexp_error THEN
9322: RAISE Fnd_Api.g_exc_unexpected_error;
9323: END IF;
9324:
9325: temp_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS',l_status_code);
9326: temp_modifier_list_rec.status_code := l_status_code;
9327: END IF;
9328: --julou end BREQ
9329: -- julou handle status depending on recal(handled by activate_offer_over).

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

9353: ELSIF l_status_code = 'DRAFT' THEN
9354: -- CP validation fails. update offer to DRAFT
9355: UPDATE ozf_offers
9356: SET status_code = 'DRAFT'
9357: ,user_status_id = OZF_Utility_PVT.get_default_user_status ('OZF_OFFER_STATUS', 'DRAFT')
9358: ,status_date = SYSDATE
9359: ,object_version_number = object_version_number + 1
9360: WHERE qp_list_header_id = p_modifier_list_rec.qp_list_header_id;
9361: END IF;

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

9381: p_approval_type => 'BUDGET',
9382: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9383: p_orig_stat_id => l_old_status_id,
9384: p_new_stat_id => p_modifier_list_rec.user_status_id,
9385: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED'),
9386: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9387: p_workflowprocess => 'AMS_APPROVAL',
9388: p_item_type => 'AMSAPRV');
9389: ELSE

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

9382: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9383: p_orig_stat_id => l_old_status_id,
9384: p_new_stat_id => p_modifier_list_rec.user_status_id,
9385: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED'),
9386: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9387: p_workflowprocess => 'AMS_APPROVAL',
9388: p_item_type => 'AMSAPRV');
9389: ELSE
9390: Activate_Offer_over(

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

9412: p_approval_type => 'CONCEPT',
9413: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9414: p_orig_stat_id => l_old_status_id,
9415: p_new_stat_id => p_modifier_list_rec.user_status_id,
9416: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA'),
9417: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9418: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
9419: p_item_type => 'AMSAPRV');
9420: END IF;

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

9413: p_object_version_number => p_modifier_list_rec.object_version_number+1,
9414: p_orig_stat_id => l_old_status_id,
9415: p_new_stat_id => p_modifier_list_rec.user_status_id,
9416: p_reject_stat_id => OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA'),
9417: p_requester_userid => OZF_Utility_PVT.get_resource_id(NVL(FND_GLOBAL.user_id,-1)),
9418: p_workflowprocess => 'AMS_CONCEPT_APPROVAL',
9419: p_item_type => 'AMSAPRV');
9420: END IF;
9421: END IF;

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

9625:
9626: END IF;
9627:
9628: IF p_modifier_list_rec.custom_setup_id = 118 THEN
9629: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
9630: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
9631:
9632:
9633: 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 9630: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --

9626: END IF;
9627:
9628: IF p_modifier_list_rec.custom_setup_id = 118 THEN
9629: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
9630: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
9631:
9632:
9633: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
9634: where offer_id=p_modifier_list_rec.qp_list_header_id;

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

9629: IF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','DENIED_TA')
9630: OR p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','REJECTED') THEN --
9631:
9632:
9633: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
9634: where offer_id=p_modifier_list_rec.qp_list_header_id;
9635:
9636: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
9637:

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

9632:
9633: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','OFFER_REJECTED')
9634: where offer_id=p_modifier_list_rec.qp_list_header_id;
9635:
9636: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
9637:
9638: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
9639: where offer_id= p_modifier_list_rec.qp_list_header_id;
9640:

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

9634: where offer_id=p_modifier_list_rec.qp_list_header_id;
9635:
9636: ELSIF p_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
9637:
9638: update ozf_sd_request_headers_all_b set user_status_id= OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
9639: where offer_id= p_modifier_list_rec.qp_list_header_id;
9640:
9641: END IF;
9642: END IF;

Line 10882: ozf_utility_pvt.convert_currency (

10878:
10879: IF line_rec.product_cost_currency
10880: <> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency) THEN
10881:
10882: ozf_utility_pvt.convert_currency (
10883: x_return_status=> x_return_status,
10884: p_from_currency=> line_rec.product_cost_currency,
10885: p_to_currency=> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency),
10886: p_conv_date=> sysdate,

Line 10919: ozf_utility_pvt.convert_currency (

10915:
10916: IF x_modifier_line_tbl(l_prod_index).ARITHMETIC_OPERATOR = 'AMT'
10917: AND NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency)
10918: <> NVL(l_sales_order_currency,l_request_currency_code) THEN
10919: ozf_utility_pvt.convert_currency (
10920: x_return_status=> x_return_status,
10921: p_from_currency=> NVL(line_rec.approved_discount_currency,line_rec.requested_discount_currency),
10922: p_to_currency=> NVL(l_sales_order_currency,l_request_currency_code),
10923: p_conv_date=> sysdate,

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

11475: OPEN c_get_sdr_status(p_sdr_header_id);
11476: FETCH c_get_sdr_status INTO l_sdr_status_id;
11477: CLOSE c_get_sdr_status;
11478:
11479: IF l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CANCELLED')
11480: OR l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CLOSED') THEN
11481:
11482: OPEN c_offer_info(x_qp_list_header_id);
11483: FETCH c_offer_info INTO l_modifier_list_rec.offer_id, l_modifier_list_rec.offer_type,

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

11476: FETCH c_get_sdr_status INTO l_sdr_status_id;
11477: CLOSE c_get_sdr_status;
11478:
11479: IF l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CANCELLED')
11480: OR l_sdr_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','CLOSED') THEN
11481:
11482: OPEN c_offer_info(x_qp_list_header_id);
11483: FETCH c_offer_info INTO l_modifier_list_rec.offer_id, l_modifier_list_rec.offer_type,
11484: l_modifier_list_rec.custom_setup_id, l_modifier_list_rec.offer_code,

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

11493: l_modifier_list_rec.offer_operation := 'UPDATE';
11494: l_modifier_list_rec.status_code := 'COMPLETED';
11495: l_modifier_list_rec.modifier_operation := 'UPDATE';
11496: --l_modifier_list_rec.operation := 'UPDATE';
11497: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','COMPLETED');
11498: l_qp_list_header_id := x_qp_list_header_id;
11499:
11500: /*Complete Offer*/
11501: process_modifiers(

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

11537: IF l_operation = 'CREATE' THEN
11538:
11539: l_modifier_list_rec.modifier_operation := 'CREATE';
11540: l_modifier_list_rec.status_code := 'DRAFT';
11541: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
11542:
11543: IF l_modifier_list_rec.OWNER_ID IS NULL OR l_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
11544: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(NVL(FND_GLOBAL.user_id,-1));
11545: ELSE

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

11540: l_modifier_list_rec.status_code := 'DRAFT';
11541: l_modifier_list_rec.user_status_id := ozf_utility_pvt.get_default_user_status('OZF_OFFER_STATUS','DRAFT');--1600;
11542:
11543: IF l_modifier_list_rec.OWNER_ID IS NULL OR l_modifier_list_rec.OWNER_ID = fnd_api.g_miss_num THEN
11544: l_modifier_list_rec.OWNER_ID := ozf_utility_pvt.get_resource_id(NVL(FND_GLOBAL.user_id,-1));
11545: ELSE
11546: l_modifier_list_rec.OWNER_ID := l_modifier_list_rec.OWNER_ID;
11547: END IF;
11548:

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

11654: --dbms_output.put_line('l_modifier_list_rec.user_status_id set operation as update' );
11655: l_modifier_list_rec.offer_operation := 'UPDATE';
11656: l_modifier_list_rec.modifier_operation := 'UPDATE';
11657: l_modifier_list_rec.user_status_id := l_modifier_list_rec.user_status_id;
11658: l_modifier_list_rec.status_code := ozf_utility_pvt.get_system_status_code(l_modifier_list_rec.user_status_id);
11659: END IF;
11660:
11661: /*Create Qualifier Line Records*/
11662: --dbms_output.put_line('N: x_qp_list_header_id '||x_qp_list_header_id);

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

11801: l_modifier_list_rec.offer_operation := 'UPDATE';
11802: l_modifier_list_rec.status_code := 'ACTIVE';
11803: l_modifier_list_rec.modifier_operation := 'UPDATE';
11804: --l_modifier_list_rec.operation := 'UPDATE';
11805: l_modifier_list_rec.user_status_id := OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE');
11806: l_qp_list_header_id := x_qp_list_header_id;
11807:
11808: /*Activate Offer*/
11809: process_modifiers(

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

11820: ,x_error_location => x_error_location);
11821:
11822: /*added this code to make SDR active */
11823:
11824: /*IF l_modifier_list_rec.user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_OFFER_STATUS','ACTIVE') THEN
11825:
11826: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
11827:
11828: update ozf_sd_request_headers_all_b

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

11825:
11826: debug_message('p_sdr_header_id1111 = '|| p_sdr_header_id);
11827:
11828: update ozf_sd_request_headers_all_b
11829: set user_status_id = OZF_Utility_PVT.get_default_user_status('OZF_SD_REQUEST_STATUS','ACTIVE')
11830: where request_header_id = p_sdr_header_id;
11831:
11832: END IF;*/
11833:

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

11856: FOR l_offer_access_rec IN c_offer_access(l_qp_list_header_id,p_sdr_header_id) LOOP
11857: dbms_output.put_line('N: l_offer_access_rec.user_id '||l_offer_access_rec.user_id);
11858: dbms_output.put_line('N: l_qp_list_header_id '||l_qp_list_header_id);
11859: l_access_exists := 0;
11860: OPEN c_access_exists (ozf_utility_pvt.get_resource_id(nvl(l_offer_access_rec.user_id,-1)),l_qp_list_header_id);
11861: FETCH c_access_exists INTO l_access_exists;
11862: CLOSE c_access_exists;
11863: debug_message('N: l_access_exists '||l_access_exists);
11864: debug_message('N: l_offer_access_rec.status '|| l_offer_access_rec.status);

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

11866: IF l_access_exists <> 1 AND l_offer_access_rec.status='REQUEST' THEN
11867: --CREATE
11868: l_access_rec.act_access_to_object_id := l_qp_list_header_id;
11869: l_access_rec.arc_act_access_to_object := 'OFFR';
11870: l_access_rec.user_or_role_id := ozf_utility_pvt.get_resource_id(l_offer_access_rec.user_id);
11871: l_access_rec.arc_user_or_role_type := 'USER';
11872: l_access_rec.admin_flag := 'Y';
11873: l_access_rec.owner_flag := 'N';
11874: debug_message('N: l_access_rec.user_or_role_id '||l_access_rec.user_or_role_id);