89: OPEN c_get_cat_activity (l_category_id, l_activity_id);
90: FETCH c_get_cat_activity INTO l_dummy;
91: CLOSE c_get_cat_activity;
92: IF l_dummy IS NULL THEN
93: ozf_utility_pvt.error_message ( 'OZF_CAT_ACTIVITY_MISMATCH');
94: x_return_status := fnd_api.g_ret_sts_error;
95: END IF;
96: END IF;
97: END check_cat_activity_match;
219: FETCH c_transfer_allowed INTO l_parent_src_rec;
220: EXIT WHEN c_transfer_allowed%NOTFOUND;
221:
222: IF l_curr <> l_parent_src_rec.parent_curr THEN
223: ozf_utility_pvt.convert_currency (
224: x_return_status=> x_return_status
225: ,p_from_currency=> l_parent_src_rec.parent_curr
226: ,p_to_currency=> l_curr
227: ,p_from_amount=> l_parent_src_rec.total_amount
243: */
244:
245: -- IF p_object_type NOT IN ('FUND','PTNR','PRIC','WKST') THEN
246: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
247: ozf_utility_pvt.error_message ('p_transfer_amt: ' || p_transfer_amt);
248: ozf_utility_pvt.error_message ('l_existing_amt: ' || l_existing_amt);
249: ozf_utility_pvt.error_message ('p_object_id: ' || p_object_id);
250: ozf_utility_pvt.error_message ('p_budget_source_id: ' || p_budget_source_id);
251:
244:
245: -- IF p_object_type NOT IN ('FUND','PTNR','PRIC','WKST') THEN
246: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
247: ozf_utility_pvt.error_message ('p_transfer_amt: ' || p_transfer_amt);
248: ozf_utility_pvt.error_message ('l_existing_amt: ' || l_existing_amt);
249: ozf_utility_pvt.error_message ('p_object_id: ' || p_object_id);
250: ozf_utility_pvt.error_message ('p_budget_source_id: ' || p_budget_source_id);
251:
252: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
245: -- IF p_object_type NOT IN ('FUND','PTNR','PRIC','WKST') THEN
246: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
247: ozf_utility_pvt.error_message ('p_transfer_amt: ' || p_transfer_amt);
248: ozf_utility_pvt.error_message ('l_existing_amt: ' || l_existing_amt);
249: ozf_utility_pvt.error_message ('p_object_id: ' || p_object_id);
250: ozf_utility_pvt.error_message ('p_budget_source_id: ' || p_budget_source_id);
251:
252: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
253: x_return_status := fnd_api.g_ret_sts_error;
246: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
247: ozf_utility_pvt.error_message ('p_transfer_amt: ' || p_transfer_amt);
248: ozf_utility_pvt.error_message ('l_existing_amt: ' || l_existing_amt);
249: ozf_utility_pvt.error_message ('p_object_id: ' || p_object_id);
250: ozf_utility_pvt.error_message ('p_budget_source_id: ' || p_budget_source_id);
251:
252: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
253: x_return_status := fnd_api.g_ret_sts_error;
254: END IF;
248: ozf_utility_pvt.error_message ('l_existing_amt: ' || l_existing_amt);
249: ozf_utility_pvt.error_message ('p_object_id: ' || p_object_id);
250: ozf_utility_pvt.error_message ('p_budget_source_id: ' || p_budget_source_id);
251:
252: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
253: x_return_status := fnd_api.g_ret_sts_error;
254: END IF;
255: -- END IF;
256:
335: END IF;
336:
337: --dbms_output.put_line('yzhao: market/offer eligibility l_dummy=' || l_dummy);
338: IF l_dummy IS NULL THEN
339: ozf_utility_pvt.error_message ( 'OZF_MARKET_ELIG_MISMATCH');
340: x_return_status := fnd_api.g_ret_sts_error;
341: END IF;
342: END IF;
343: END check_market_elig_match;
419: CLOSE c_get_offer_product_elig;
420: END IF;
421:
422: IF l_dummy IS NULL THEN
423: ozf_utility_pvt.error_message ('OZF_PRODUCT_ELIG_MISMATCH');
424: x_return_status := fnd_api.g_ret_sts_error;
425: END IF;
426: END IF;
427: END check_prod_elig_match;