92: OPEN c_get_cat_activity (l_category_id, l_activity_id);
93: FETCH c_get_cat_activity INTO l_dummy;
94: CLOSE c_get_cat_activity;
95: IF l_dummy IS NULL THEN
96: ozf_utility_pvt.error_message ( 'OZF_CAT_ACTIVITY_MISMATCH');
97: x_return_status := fnd_api.g_ret_sts_error;
98: END IF;
99: END IF;
100: END check_cat_activity_match;
222: FETCH c_transfer_allowed INTO l_parent_src_rec;
223: EXIT WHEN c_transfer_allowed%NOTFOUND;
224:
225: IF l_curr <> l_parent_src_rec.parent_curr THEN
226: ozf_utility_pvt.convert_currency (
227: x_return_status=> x_return_status
228: ,p_from_currency=> l_parent_src_rec.parent_curr
229: ,p_to_currency=> l_curr
230: ,p_from_amount=> l_parent_src_rec.total_amount
247:
248: -- IF p_object_type NOT IN ('FUND','PTNR','PRIC','WKST') THEN
249: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
250: IF G_DEBUG THEN
251: ozf_utility_pvt.debug_message ('p_transfer_amt: ' || p_transfer_amt);
252: ozf_utility_pvt.debug_message ('p_transfer_type ' || p_transfer_type);
253: ozf_utility_pvt.debug_message ('l_existing_amt: ' || l_existing_amt);
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
248: -- IF p_object_type NOT IN ('FUND','PTNR','PRIC','WKST') THEN
249: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
250: IF G_DEBUG THEN
251: ozf_utility_pvt.debug_message ('p_transfer_amt: ' || p_transfer_amt);
252: ozf_utility_pvt.debug_message ('p_transfer_type ' || p_transfer_type);
253: ozf_utility_pvt.debug_message ('l_existing_amt: ' || l_existing_amt);
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
256: END IF;
249: IF NVL (p_transfer_amt, 0) > NVL (l_existing_amt, 0) THEN
250: IF G_DEBUG THEN
251: ozf_utility_pvt.debug_message ('p_transfer_amt: ' || p_transfer_amt);
252: ozf_utility_pvt.debug_message ('p_transfer_type ' || p_transfer_type);
253: ozf_utility_pvt.debug_message ('l_existing_amt: ' || l_existing_amt);
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
256: END IF;
257:
250: IF G_DEBUG THEN
251: ozf_utility_pvt.debug_message ('p_transfer_amt: ' || p_transfer_amt);
252: ozf_utility_pvt.debug_message ('p_transfer_type ' || p_transfer_type);
253: ozf_utility_pvt.debug_message ('l_existing_amt: ' || l_existing_amt);
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
256: END IF;
257:
258: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
251: ozf_utility_pvt.debug_message ('p_transfer_amt: ' || p_transfer_amt);
252: ozf_utility_pvt.debug_message ('p_transfer_type ' || p_transfer_type);
253: ozf_utility_pvt.debug_message ('l_existing_amt: ' || l_existing_amt);
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
256: END IF;
257:
258: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
259: x_return_status := fnd_api.g_ret_sts_error;
254: ozf_utility_pvt.debug_message ('p_object_id: ' || p_object_id);
255: ozf_utility_pvt.debug_message ('p_budget_source_id: ' || p_budget_source_id);
256: END IF;
257:
258: ozf_utility_pvt.error_message ('OZF_TRANSFER_NOT_ALLOWED');
259: x_return_status := fnd_api.g_ret_sts_error;
260: END IF;
261: -- END IF;
262:
341: END IF;
342:
343: --dbms_output.put_line('yzhao: market/offer eligibility l_dummy=' || l_dummy);
344: IF l_dummy IS NULL THEN
345: ozf_utility_pvt.error_message ( 'OZF_MARKET_ELIG_MISMATCH');
346: x_return_status := fnd_api.g_ret_sts_error;
347: END IF;
348: END IF;
349: END check_market_elig_match;
425: CLOSE c_get_offer_product_elig;
426: END IF;
427:
428: IF l_dummy IS NULL THEN
429: ozf_utility_pvt.error_message ('OZF_PRODUCT_ELIG_MISMATCH');
430: x_return_status := fnd_api.g_ret_sts_error;
431: END IF;
432: END IF;
433: END check_prod_elig_match;
1003:
1004: IF l_note_id IS NOT NULL THEN
1005:
1006: IF G_DEBUG THEN
1007: ozf_utility_pvt.debug_message('jtf_notes_pub.update_note');
1008: END IF;
1009:
1010: -- For Bug#8867381 to avoid locking of the record in JTF_NOTES Table
1011: IF p_note <> 'CHARGEBACK' THEN
1026:
1027: ELSE
1028:
1029: IF G_DEBUG THEN
1030: ozf_utility_pvt.debug_message('jtf_notes_pub.create_note');
1031: END IF;
1032:
1033: jtf_notes_pub.create_note (
1034: p_api_version=> 1.0
1050: );
1051: END IF;
1052:
1053: IF G_DEBUG THEN
1054: ozf_utility_pvt.debug_message('jtf_notes_pub returns: ' || x_return_status);
1055: END IF;
1056:
1057: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1058: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');