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 68: x_return_status := fnd_api.g_ret_sts_success;

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

Line 94: x_return_status := fnd_api.g_ret_sts_error;

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

Line 205: x_return_status := fnd_api.g_ret_sts_success;

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

Line 231: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

Line 232: RAISE fnd_api.g_exc_unexpected_error;

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

Line 233: ELSIF x_return_status = fnd_api.g_ret_sts_error THEN

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

Line 234: RAISE fnd_api.g_exc_error;

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

Line 253: x_return_status := fnd_api.g_ret_sts_error;

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

Line 319: x_return_status := fnd_api.g_ret_sts_success;

315:
316: l_dummy1 VARCHAR2 (3);
317: l_dummy VARCHAR2 (3);
318: BEGIN
319: x_return_status := fnd_api.g_ret_sts_success;
320: OPEN c_market_elig_exists (p_budget_source_id);
321: FETCH c_market_elig_exists INTO l_dummy1;
322: CLOSE c_market_elig_exists;
323: --dbms_output.put_line('yzhao: market eligibility l_dummy1=' || l_dummy1 || ' used_by_type=' || p_used_by_type);

Line 340: x_return_status := fnd_api.g_ret_sts_error;

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

Line 405: x_return_status := fnd_api.g_ret_sts_success;

401:
402: l_dummy1 VARCHAR2 (3);
403: l_dummy VARCHAR2 (3);
404: BEGIN
405: x_return_status := fnd_api.g_ret_sts_success;
406: OPEN c_product_elig_exists (p_budget_source_id);
407: FETCH c_product_elig_exists INTO l_dummy1;
408: CLOSE c_product_elig_exists;
409:

Line 424: x_return_status := fnd_api.g_ret_sts_error;

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

Line 487: RETURN fnd_api.g_true;

483: FETCH c_approved_amount INTO l_approved_amount;
484: CLOSE c_approved_amount;
485:
486: IF l_approved_amount >= p_approved_amount THEN
487: RETURN fnd_api.g_true;
488: ELSE
489: RETURN fnd_api.g_false;
490: END IF;
491: END source_has_enough_money;

Line 489: RETURN fnd_api.g_false;

485:
486: IF l_approved_amount >= p_approved_amount THEN
487: RETURN fnd_api.g_true;
488: ELSE
489: RETURN fnd_api.g_false;
490: END IF;
491: END source_has_enough_money;
492:
493:

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

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

Line 664: RETURN fnd_api.g_true;

660: -- IF l_source_owner_id <> l_object_owner_id THEN
661: IF l_flag IS NULL THEN
662: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10
663: ELSIF l_flag = 'Y' THEN
664: RETURN fnd_api.g_true;
665: ELSIF l_flag = 'N' THEN
666: RETURN fnd_api.g_false;
667: ELSE
668: RETURN fnd_api.g_false;

Line 666: RETURN fnd_api.g_false;

662: RETURN fnd_api.g_false; --change to false by feliu from 11.5.10
663: ELSIF l_flag = 'Y' THEN
664: RETURN fnd_api.g_true;
665: ELSIF l_flag = 'N' THEN
666: RETURN fnd_api.g_false;
667: ELSE
668: RETURN fnd_api.g_false;
669: END IF;
670: /*

Line 668: RETURN fnd_api.g_false;

664: RETURN fnd_api.g_true;
665: ELSIF l_flag = 'N' THEN
666: RETURN fnd_api.g_false;
667: ELSE
668: RETURN fnd_api.g_false;
669: END IF;
670: /*
671: -- if owner is the same then donot submit for approval
672: ELSE

Line 674: RETURN fnd_api.g_true;

670: /*
671: -- if owner is the same then donot submit for approval
672: ELSE
673: -- IMP mpande 08/10/2001 made it to true for a workaround in approvals workflow
674: RETURN fnd_api.g_true;
675: END IF;
676: */
677: ELSE -- else for transfer type 'TRANSFER'
678: RETURN fnd_api.g_false;

Line 678: RETURN fnd_api.g_false;

674: RETURN fnd_api.g_true;
675: END IF;
676: */
677: ELSE -- else for transfer type 'TRANSFER'
678: RETURN fnd_api.g_false;
679: END IF;
680: EXCEPTION
681: WHEN OTHERS THEN
682: IF c_campaign%ISOPEN THEN

Line 860: RETURN fnd_api.g_false;

856: IF p_object_type <> 'FUND'
857: AND l_status_code <> 'ACTIVE' THEN
858: IF NVL (l_existing_amount, 0)
859: + NVL (p_request_amount, 0) > NVL (l_amount, 0) THEN
860: RETURN fnd_api.g_false;
861: ELSE
862: RETURN fnd_api.g_true;
863: END IF;
864: ELSE

Line 862: RETURN fnd_api.g_true;

858: IF NVL (l_existing_amount, 0)
859: + NVL (p_request_amount, 0) > NVL (l_amount, 0) THEN
860: RETURN fnd_api.g_false;
861: ELSE
862: RETURN fnd_api.g_true;
863: END IF;
864: ELSE
865: RETURN fnd_api.g_true;
866: END IF;

Line 865: RETURN fnd_api.g_true;

861: ELSE
862: RETURN fnd_api.g_true;
863: END IF;
864: ELSE
865: RETURN fnd_api.g_true;
866: END IF;
867: EXCEPTION
868: WHEN OTHERS THEN
869: IF c_campaign%ISOPEN THEN

Line 934: RETURN fnd_api.g_true;

930: FETCH c_approved_amount INTO l_approved_amount;
931: CLOSE c_approved_amount;
932:
933: IF l_approved_amount >= p_approved_amount THEN
934: RETURN fnd_api.g_true;
935: ELSE
936: RETURN fnd_api.g_false;
937: END IF;
938: END budget_has_enough_money;

Line 936: RETURN fnd_api.g_false;

932:
933: IF l_approved_amount >= p_approved_amount THEN
934: RETURN fnd_api.g_true;
935: ELSE
936: RETURN fnd_api.g_false;
937: END IF;
938: END budget_has_enough_money;
939:
940:

Line 977: x_return_status := fnd_api.g_ret_sts_success;

973: || p_activity_type
974: AND source_object_id = p_activity_id
975: AND note_type = p_note_type;
976: BEGIN
977: x_return_status := fnd_api.g_ret_sts_success;
978: OPEN c_resource;
979: FETCH c_resource INTO l_user;
980:
981: IF c_resource%NOTFOUND THEN

Line 1031: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1027: ,p_creation_date=> SYSDATE
1028: );
1029: END IF;
1030:
1031: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1032: fnd_message.set_name ('OZF', 'OZF_API_DEBUG_MESSAGE');
1033: fnd_message.set_token ('ROW', SQLERRM);
1034: fnd_msg_pub.ADD;
1035: END IF;