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_ACTBUDGETRULES_PVT dependencies on FND_API

Line 71: x_return_status := fnd_api.g_ret_sts_success;

67: l_dummy VARCHAR2 (3);
68: l_cat_act_count NUMBER;
69:
70: BEGIN
71: x_return_status := fnd_api.g_ret_sts_success;
72:
73: OPEN c_get_category_id (p_budget_source_id);
74: FETCH c_get_category_id INTO l_category_id;
75: CLOSE c_get_category_id;

Line 97: x_return_status := fnd_api.g_ret_sts_error;

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;
101:

Line 208: x_return_status := fnd_api.g_ret_sts_success;

204: l_existing_amt NUMBER := 0;
205: --l_curr VARCHAR2 (30) := p_transfer_currency;
206: --l_converted_amount NUMBER := 0;
207: BEGIN
208: x_return_status := fnd_api.g_ret_sts_success;
209:
210: IF p_transfer_type ='TRANSFER' THEN
211: OPEN c_transfer_allowed;
212: FETCH c_transfer_allowed INTO l_existing_amt;

Line 234: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

230: ,p_from_amount=> l_parent_src_rec.total_amount
231: ,x_to_amount=> l_converted_amount
232: );
233:
234: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
235: RAISE fnd_api.g_exc_unexpected_error;
236: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;

Line 235: RAISE fnd_api.g_exc_unexpected_error;

231: ,x_to_amount=> l_converted_amount
232: );
233:
234: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
235: RAISE fnd_api.g_exc_unexpected_error;
236: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;
239: ELSE

Line 236: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

232: );
233:
234: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
235: RAISE fnd_api.g_exc_unexpected_error;
236: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;
239: ELSE
240: l_converted_amount := l_parent_src_rec.total_amount;

Line 237: RAISE fnd_api.g_exc_error;

233:
234: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
235: RAISE fnd_api.g_exc_unexpected_error;
236: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN
237: RAISE fnd_api.g_exc_error;
238: END IF;
239: ELSE
240: l_converted_amount := l_parent_src_rec.total_amount;
241: END IF;

Line 259: x_return_status := fnd_api.g_ret_sts_error;

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:
263: END check_transfer_amount_exists;

Line 325: x_return_status := fnd_api.g_ret_sts_success;

321:
322: l_dummy1 VARCHAR2 (3);
323: l_dummy VARCHAR2 (3);
324: BEGIN
325: x_return_status := fnd_api.g_ret_sts_success;
326: OPEN c_market_elig_exists (p_budget_source_id);
327: FETCH c_market_elig_exists INTO l_dummy1;
328: CLOSE c_market_elig_exists;
329: --dbms_output.put_line('yzhao: market eligibility l_dummy1=' || l_dummy1 || ' used_by_type=' || p_used_by_type);

Line 346: x_return_status := fnd_api.g_ret_sts_error;

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;
350:

Line 411: x_return_status := fnd_api.g_ret_sts_success;

407:
408: l_dummy1 VARCHAR2 (3);
409: l_dummy VARCHAR2 (3);
410: BEGIN
411: x_return_status := fnd_api.g_ret_sts_success;
412: OPEN c_product_elig_exists (p_budget_source_id);
413: FETCH c_product_elig_exists INTO l_dummy1;
414: CLOSE c_product_elig_exists;
415:

Line 430: x_return_status := fnd_api.g_ret_sts_error;

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;
434: */

Line 493: RETURN fnd_api.g_true;

489: FETCH c_approved_amount INTO l_approved_amount;
490: CLOSE c_approved_amount;
491:
492: IF l_approved_amount >= p_approved_amount THEN
493: RETURN fnd_api.g_true;
494: ELSE
495: RETURN fnd_api.g_false;
496: END IF;
497: END source_has_enough_money;

Line 495: RETURN fnd_api.g_false;

491:
492: IF l_approved_amount >= p_approved_amount THEN
493: RETURN fnd_api.g_true;
494: ELSE
495: RETURN fnd_api.g_false;
496: END IF;
497: END source_has_enough_money;
498:
499:

Line 668: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10

664: --10/30/2001 commented owner code for later release, we ahve to change workflow approvals API also
665: -- for owner approval logic
666: -- IF l_source_owner_id <> l_object_owner_id THEN
667: IF l_flag IS NULL THEN
668: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10
669: ELSIF l_flag = 'Y' THEN
670: RETURN fnd_api.g_true;
671: ELSIF l_flag = 'N' THEN
672: RETURN fnd_api.g_false;

Line 670: RETURN fnd_api.g_true;

666: -- IF l_source_owner_id <> l_object_owner_id THEN
667: IF l_flag IS NULL THEN
668: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10
669: ELSIF l_flag = 'Y' THEN
670: RETURN fnd_api.g_true;
671: ELSIF l_flag = 'N' THEN
672: RETURN fnd_api.g_false;
673: ELSE
674: RETURN fnd_api.g_false;

Line 672: RETURN fnd_api.g_false;

668: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10
669: ELSIF l_flag = 'Y' THEN
670: RETURN fnd_api.g_true;
671: ELSIF l_flag = 'N' THEN
672: RETURN fnd_api.g_false;
673: ELSE
674: RETURN fnd_api.g_false;
675: END IF;
676: /*

Line 674: RETURN fnd_api.g_false;

670: RETURN fnd_api.g_true;
671: ELSIF l_flag = 'N' THEN
672: RETURN fnd_api.g_false;
673: ELSE
674: RETURN fnd_api.g_false;
675: END IF;
676: /*
677: -- if owner is the same then donot submit for approval
678: ELSE

Line 680: RETURN fnd_api.g_true;

676: /*
677: -- if owner is the same then donot submit for approval
678: ELSE
679: -- IMP mpande 08/10/2001 made it to true for a workaround in approvals workflow
680: RETURN fnd_api.g_true;
681: END IF;
682: */
683: ELSE -- else for transfer type 'TRANSFER'
684: RETURN fnd_api.g_false;

Line 684: RETURN fnd_api.g_false;

680: RETURN fnd_api.g_true;
681: END IF;
682: */
683: ELSE -- else for transfer type 'TRANSFER'
684: RETURN fnd_api.g_false;
685: END IF;
686: EXCEPTION
687: WHEN OTHERS THEN
688: IF c_campaign%ISOPEN THEN

Line 866: RETURN fnd_api.g_false;

862: IF p_object_type <> 'FUND'
863: AND l_status_code <> 'ACTIVE' THEN
864: IF NVL (l_existing_amount, 0)
865: + NVL (p_request_amount, 0) > NVL (l_amount, 0) THEN
866: RETURN fnd_api.g_false;
867: ELSE
868: RETURN fnd_api.g_true;
869: END IF;
870: ELSE

Line 868: RETURN fnd_api.g_true;

864: IF NVL (l_existing_amount, 0)
865: + NVL (p_request_amount, 0) > NVL (l_amount, 0) THEN
866: RETURN fnd_api.g_false;
867: ELSE
868: RETURN fnd_api.g_true;
869: END IF;
870: ELSE
871: RETURN fnd_api.g_true;
872: END IF;

Line 871: RETURN fnd_api.g_true;

867: ELSE
868: RETURN fnd_api.g_true;
869: END IF;
870: ELSE
871: RETURN fnd_api.g_true;
872: END IF;
873: EXCEPTION
874: WHEN OTHERS THEN
875: IF c_campaign%ISOPEN THEN

Line 940: RETURN fnd_api.g_true;

936: FETCH c_approved_amount INTO l_approved_amount;
937: CLOSE c_approved_amount;
938:
939: IF l_approved_amount >= p_approved_amount THEN
940: RETURN fnd_api.g_true;
941: ELSE
942: RETURN fnd_api.g_false;
943: END IF;
944: END budget_has_enough_money;

Line 942: RETURN fnd_api.g_false;

938:
939: IF l_approved_amount >= p_approved_amount THEN
940: RETURN fnd_api.g_true;
941: ELSE
942: RETURN fnd_api.g_false;
943: END IF;
944: END budget_has_enough_money;
945:
946:

Line 983: x_return_status := fnd_api.g_ret_sts_success;

979: || p_activity_type
980: AND source_object_id = p_activity_id
981: AND note_type = p_note_type;
982: BEGIN
983: x_return_status := fnd_api.g_ret_sts_success;
984: OPEN c_resource;
985: FETCH c_resource INTO l_user;
986:
987: IF c_resource%NOTFOUND THEN

Line 1057: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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');
1059: fnd_message.set_token ('ROW', SQLERRM);
1060: fnd_msg_pub.ADD;
1061: END IF;