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

Line 220: x_return_status := fnd_api.g_ret_sts_success;

216: WHERE parent_fund_id = p_object_id
217: AND fund_id = p_child_fund_id;
218:
219: BEGIN
220: x_return_status := fnd_api.g_ret_sts_success;
221: x_non_del_flag := false;
222: I := 1;
223:
224: FOR actbudget_rec IN c_get_actbudget_usedby LOOP

Line 319: x_return_status := fnd_api.g_ret_sts_unexp_error;

315: x_actbudget_tbl := l_actbudget_tbl;
316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: x_return_status := fnd_api.g_ret_sts_unexp_error;
320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
322: END IF;
323: fnd_msg_pub.count_and_get(

Line 324: p_encoded => fnd_api.g_false

320: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
321: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
322: END IF;
323: fnd_msg_pub.count_and_get(
324: p_encoded => fnd_api.g_false
325: ,p_count => x_msg_count
326: ,p_data => x_msg_data);
327: END get_actbudgets;
328:

Line 372: x_return_status := fnd_api.g_ret_sts_success;

368: FROM ams_jtf_rs_emp_v
369: WHERE resource_id = p_owner_id;
370:
371: BEGIN
372: x_return_status := fnd_api.g_ret_sts_success;
373: x_non_del_flag := false;
374: I := 1;
375:
376: l_object_type := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', 'FUND');

Line 409: IF x_return_status <> fnd_api.g_ret_sts_success THEN

405: , x_return_status => x_return_status
406: , x_msg_count => x_msg_count
407: , x_msg_data => x_msg_data
408: );
409: IF x_return_status <> fnd_api.g_ret_sts_success THEN
410: RAISE fnd_api.g_exc_unexpected_error;
411: END IF;
412:
413: FOR J IN NVL(l_actbudget_tbl.FIRST, 1) .. NVL(l_actbudget_tbl.LAST, 0) LOOP

Line 410: RAISE fnd_api.g_exc_unexpected_error;

406: , x_msg_count => x_msg_count
407: , x_msg_data => x_msg_data
408: );
409: IF x_return_status <> fnd_api.g_ret_sts_success THEN
410: RAISE fnd_api.g_exc_unexpected_error;
411: END IF;
412:
413: FOR J IN NVL(l_actbudget_tbl.FIRST, 1) .. NVL(l_actbudget_tbl.LAST, 0) LOOP
414: l_child_fund_tbl(I).name := l_actbudget_tbl(J).name;

Line 452: x_return_status := fnd_api.g_ret_sts_unexp_error;

448: x_child_fund_tbl := l_child_fund_tbl;
449:
450: EXCEPTION
451: WHEN OTHERS THEN
452: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: fnd_msg_pub.count_and_get(

Line 457: p_encoded => fnd_api.g_false

453: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
454: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
455: END IF;
456: fnd_msg_pub.count_and_get(
457: p_encoded => fnd_api.g_false
458: ,p_count => x_msg_count
459: ,p_data => x_msg_data);
460:
461: END get_child_funds;

Line 484: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

480: ---------------------------------------------------------------------
481:
482: PROCEDURE validate_delete_fund(
483: p_api_version_number IN NUMBER
484: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
485: , p_commit IN VARCHAR2 := fnd_api.g_false
486: , p_object_id IN NUMBER
487: , p_object_version_number IN NUMBER
488: , x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type

Line 485: , p_commit IN VARCHAR2 := fnd_api.g_false

481:
482: PROCEDURE validate_delete_fund(
483: p_api_version_number IN NUMBER
484: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
485: , p_commit IN VARCHAR2 := fnd_api.g_false
486: , p_object_id IN NUMBER
487: , p_object_version_number IN NUMBER
488: , x_dependent_object_tbl OUT NOCOPY ams_utility_pvt.dependent_objects_tbl_type
489: , x_return_status OUT NOCOPY VARCHAR2

Line 508: x_return_status := fnd_api.g_ret_sts_success;

504: FROM ozf_funds_all_b
505: WHERE fund_id = p_object_id;
506:
507: BEGIN
508: x_return_status := fnd_api.g_ret_sts_success;
509:
510: OPEN c_get_fund_info;
511: FETCH c_get_fund_info INTO l_fund_status;
512: CLOSE c_get_fund_info;

Line 523: IF x_return_status <> fnd_api.g_ret_sts_success THEN

519: , x_return_status => x_return_status
520: , x_msg_count => x_msg_count
521: , x_msg_data => x_msg_data
522: );
523: IF x_return_status <> fnd_api.g_ret_sts_success THEN
524: raise fnd_api.g_exc_unexpected_error;
525: END IF;
526:
527: IF l_non_del_flag THEN

Line 524: raise fnd_api.g_exc_unexpected_error;

520: , x_msg_count => x_msg_count
521: , x_msg_data => x_msg_data
522: );
523: IF x_return_status <> fnd_api.g_ret_sts_success THEN
524: raise fnd_api.g_exc_unexpected_error;
525: END IF;
526:
527: IF l_non_del_flag THEN
528: -- return. There are non-deletable objects.

Line 530: x_return_status := fnd_api.g_ret_sts_success;

526:
527: IF l_non_del_flag THEN
528: -- return. There are non-deletable objects.
529: x_dependent_object_tbl := l_depend_obj_tbl;
530: x_return_status := fnd_api.g_ret_sts_success;
531: RETURN;
532: END IF;
533:
534: I := NVL(l_depend_obj_tbl.LAST, 0) + 1;

Line 545: IF x_return_status <> fnd_api.g_ret_sts_success THEN

541: , x_return_status => x_return_status
542: , x_msg_count => x_msg_count
543: , x_msg_data => x_msg_data
544: );
545: IF x_return_status <> fnd_api.g_ret_sts_success THEN
546: raise fnd_api.g_exc_unexpected_error;
547: END IF;
548:
549: FOR J IN NVL(l_actbudget_tbl.FIRST, 1) .. NVL(l_actbudget_tbl.LAST, 0) LOOP

Line 546: raise fnd_api.g_exc_unexpected_error;

542: , x_msg_count => x_msg_count
543: , x_msg_data => x_msg_data
544: );
545: IF x_return_status <> fnd_api.g_ret_sts_success THEN
546: raise fnd_api.g_exc_unexpected_error;
547: END IF;
548:
549: FOR J IN NVL(l_actbudget_tbl.FIRST, 1) .. NVL(l_actbudget_tbl.LAST, 0) LOOP
550: l_depend_obj_tbl(I).name := l_actbudget_tbl(J).name;

Line 563: WHEN fnd_api.g_exc_error THEN

559: x_dependent_object_tbl := l_depend_obj_tbl;
560: -- dbms_output.put_line('Validate_delete_fund successfully ends');
561:
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: fnd_msg_pub.count_and_get(
566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count

Line 564: x_return_status := fnd_api.g_ret_sts_error;

560: -- dbms_output.put_line('Validate_delete_fund successfully ends');
561:
562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: fnd_msg_pub.count_and_get(
566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);

Line 566: p_encoded => fnd_api.g_false

562: EXCEPTION
563: WHEN fnd_api.g_exc_error THEN
564: x_return_status := fnd_api.g_ret_sts_error;
565: fnd_msg_pub.count_and_get(
566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
570: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 569: WHEN fnd_api.g_exc_unexpected_error THEN

565: fnd_msg_pub.count_and_get(
566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: fnd_msg_pub.count_and_get(
572: p_encoded => fnd_api.g_false
573: ,p_count => x_msg_count

Line 570: x_return_status := fnd_api.g_ret_sts_unexp_error;

566: p_encoded => fnd_api.g_false
567: ,p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: fnd_msg_pub.count_and_get(
572: p_encoded => fnd_api.g_false
573: ,p_count => x_msg_count
574: ,p_data => x_msg_data);

Line 572: p_encoded => fnd_api.g_false

568: ,p_data => x_msg_data);
569: WHEN fnd_api.g_exc_unexpected_error THEN
570: x_return_status := fnd_api.g_ret_sts_unexp_error;
571: fnd_msg_pub.count_and_get(
572: p_encoded => fnd_api.g_false
573: ,p_count => x_msg_count
574: ,p_data => x_msg_data);
575: WHEN OTHERS THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 576: x_return_status := fnd_api.g_ret_sts_unexp_error;

572: p_encoded => fnd_api.g_false
573: ,p_count => x_msg_count
574: ,p_data => x_msg_data);
575: WHEN OTHERS THEN
576: x_return_status := fnd_api.g_ret_sts_unexp_error;
577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
579: END IF;
580: fnd_msg_pub.count_and_get(

Line 581: p_encoded => fnd_api.g_false

577: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
578: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
579: END IF;
580: fnd_msg_pub.count_and_get(
581: p_encoded => fnd_api.g_false
582: ,p_count => x_msg_count
583: ,p_data => x_msg_data);
584:
585: END validate_delete_fund;

Line 621: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

617: l_error_location NUMBER;
618:
619: l_offer_hdr_rec ozf_offer_pvt.modifier_list_rec_type;
620: l_offer_line_tbl ozf_offer_pvt.modifier_line_tbl_type;
621: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
622:
623: CURSOR c_get_offers(p_qp_list_header_id IN NUMBER)
624: IS
625: SELECT offer_id, object_version_number, offer_type

Line 642: x_return_status := fnd_api.g_ret_sts_success;

638: IF G_DEBUG THEN
639: ozf_utility_pvt.debug_message(l_full_name ||
640: ': terminate_accrual_offer');
641: END IF;
642: x_return_status := fnd_api.g_ret_sts_success;
643:
644:
645: IF G_DEBUG THEN
646: ozf_utility_pvt.debug_message('l_qp_list_header_id =>' ||

Line 673: p_init_msg_list=> fnd_api.g_false,

669: --l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type,'TERMINATED');
670: --l_offer_hdr_rec.status_code := 'TERMINATED';
671:
672: ozf_offer_pvt.process_modifiers(
673: p_init_msg_list=> fnd_api.g_false,
674: p_api_version=> 1.0,
675: p_commit=> fnd_api.g_false,
676: x_return_status=> l_return_status,
677: x_msg_count=> x_msg_count,

Line 675: p_commit=> fnd_api.g_false,

671:
672: ozf_offer_pvt.process_modifiers(
673: p_init_msg_list=> fnd_api.g_false,
674: p_api_version=> 1.0,
675: p_commit=> fnd_api.g_false,
676: x_return_status=> l_return_status,
677: x_msg_count=> x_msg_count,
678: x_msg_data=> x_msg_data,
679: p_modifier_list_rec=> l_offer_hdr_rec,

Line 694: IF l_return_status <> fnd_api.g_ret_sts_success THEN

690: l_error_location ||
691: x_msg_data);
692: END IF;
693:
694: IF l_return_status <> fnd_api.g_ret_sts_success THEN
695: IF G_DEBUG THEN
696: ozf_utility_pvt.debug_message('OZF_OFFR_QP_FAILURE ' ||
697: l_error_location ||
698: x_msg_data);

Line 702: IF l_return_status = fnd_api.g_ret_sts_error THEN

698: x_msg_data);
699: END IF;
700:
701:
702: IF l_return_status = fnd_api.g_ret_sts_error THEN
703: RAISE fnd_api.g_exc_error;
704: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
705: RAISE fnd_api.g_exc_unexpected_error;
706: END IF;

Line 703: RAISE fnd_api.g_exc_error;

699: END IF;
700:
701:
702: IF l_return_status = fnd_api.g_ret_sts_error THEN
703: RAISE fnd_api.g_exc_error;
704: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
705: RAISE fnd_api.g_exc_unexpected_error;
706: END IF;
707: END IF;

Line 704: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

700:
701:
702: IF l_return_status = fnd_api.g_ret_sts_error THEN
703: RAISE fnd_api.g_exc_error;
704: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
705: RAISE fnd_api.g_exc_unexpected_error;
706: END IF;
707: END IF;
708:

Line 705: RAISE fnd_api.g_exc_unexpected_error;

701:
702: IF l_return_status = fnd_api.g_ret_sts_error THEN
703: RAISE fnd_api.g_exc_error;
704: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
705: RAISE fnd_api.g_exc_unexpected_error;
706: END IF;
707: END IF;
708:
709:

Line 739: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

735: ) IS
736: l_api_name CONSTANT VARCHAR2(30) := 'delete_fund_schema';
737: l_fund_rec ozf_funds_pvt.fund_rec_type;
738: l_msg_text VARCHAR2(4000);
739: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
740: l_msg_count NUMBER;
741: l_msg_data VARCHAR2(4000);
742: l_utiz_count NUMBER;
743:

Line 800: x_return_status := fnd_api.g_ret_sts_success;

796: FROM ozf_funds_utilized_all_b
797: WHERE fund_id = p_object_id and rownum = 1;
798:
799: BEGIN
800: x_return_status := fnd_api.g_ret_sts_success;
801:
802: l_utiz_count := 0;
803:
804: OPEN c_get_fund_utiz_info;

Line 812: RAISE fnd_api.g_exc_unexpected_error;

808: --ninarasi fix for motorola bug 13054588
809: IF l_utiz_count = 1 THEN
810: FND_MESSAGE.set_name('OZF', 'OZF_DEL_FUND_ACCRUALS');
811: FND_MSG_PUB.add;
812: RAISE fnd_api.g_exc_unexpected_error;
813: END IF;
814:
815: FOR child_rec IN c_get_child_funds LOOP
816: delete_fund_schema(p_api_version_number => p_api_version_number

Line 824: IF l_return_status <> fnd_api.g_ret_sts_success THEN

820: , x_return_status => l_return_status
821: , x_msg_count => x_msg_count
822: , x_msg_data => x_msg_data
823: );
824: IF l_return_status <> fnd_api.g_ret_sts_success THEN
825: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827: END LOOP;
828:

Line 825: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

821: , x_msg_count => x_msg_count
822: , x_msg_data => x_msg_data
823: );
824: IF l_return_status <> fnd_api.g_ret_sts_success THEN
825: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
826: END IF;
827: END LOOP;
828:
829: -- ??? how to delete note? no JTF_NOTEs_PUB.delete

Line 861: ,p_init_msg_list => fnd_api.g_false

857: AND p_top_del_budget_id = p_object_id THEN
858: -- update its ancestors' rollup amount
859: ozf_funds_pvt.update_rollup_amount(
860: p_api_version => p_api_version_number
861: ,p_init_msg_list => fnd_api.g_false
862: ,p_commit => fnd_api.g_false
863: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
864: ,x_return_status => l_return_status
865: ,x_msg_count => x_msg_count

Line 862: ,p_commit => fnd_api.g_false

858: -- update its ancestors' rollup amount
859: ozf_funds_pvt.update_rollup_amount(
860: p_api_version => p_api_version_number
861: ,p_init_msg_list => fnd_api.g_false
862: ,p_commit => fnd_api.g_false
863: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
864: ,x_return_status => l_return_status
865: ,x_msg_count => x_msg_count
866: ,x_msg_data => x_msg_data

Line 863: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

859: ozf_funds_pvt.update_rollup_amount(
860: p_api_version => p_api_version_number
861: ,p_init_msg_list => fnd_api.g_false
862: ,p_commit => fnd_api.g_false
863: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
864: ,x_return_status => l_return_status
865: ,x_msg_count => x_msg_count
866: ,x_msg_data => x_msg_data
867: ,p_fund_rec => l_fund_rec

Line 870: IF l_return_status <> fnd_api.g_ret_sts_success THEN

866: ,x_msg_data => x_msg_data
867: ,p_fund_rec => l_fund_rec
868: );
869: -- dbms_output.put_line('update_rollup_amount for budget ' || l_fund_rec.short_name || ' returns ' || x_return_status);
870: IF l_return_status <> fnd_api.g_ret_sts_success THEN
871: -- l_msg_text := 'Update ancestor''s rollup amount for budget ' || l_fund_rec.short_name;
872: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ROLLUP');
873: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
874: ozf_utility_pvt.create_log(

Line 882: IF l_return_status = fnd_api.g_ret_sts_error THEN

878: , p_msg_data => fnd_message.get
879: , p_msg_type => 'ERROR'
880: );
881:
882: IF l_return_status = fnd_api.g_ret_sts_error THEN
883: RAISE fnd_api.g_exc_error;
884: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;

Line 883: RAISE fnd_api.g_exc_error;

879: , p_msg_type => 'ERROR'
880: );
881:
882: IF l_return_status = fnd_api.g_ret_sts_error THEN
883: RAISE fnd_api.g_exc_error;
884: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887: END IF;

Line 884: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

880: );
881:
882: IF l_return_status = fnd_api.g_ret_sts_error THEN
883: RAISE fnd_api.g_exc_error;
884: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887: END IF;
888:

Line 885: RAISE fnd_api.g_exc_unexpected_error;

881:
882: IF l_return_status = fnd_api.g_ret_sts_error THEN
883: RAISE fnd_api.g_exc_error;
884: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
885: RAISE fnd_api.g_exc_unexpected_error;
886: END IF;
887: END IF;
888:
889: -- remove its ancestors' access to the budget

Line 892: ,p_init_msg_list => fnd_api.g_false

888:
889: -- remove its ancestors' access to the budget
890: ozf_funds_pvt.update_funds_access(
891: p_api_version => p_api_version_number
892: ,p_init_msg_list => fnd_api.g_false
893: ,p_commit => fnd_api.g_false
894: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
895: ,x_return_status => l_return_status
896: ,x_msg_count => x_msg_count

Line 893: ,p_commit => fnd_api.g_false

889: -- remove its ancestors' access to the budget
890: ozf_funds_pvt.update_funds_access(
891: p_api_version => p_api_version_number
892: ,p_init_msg_list => fnd_api.g_false
893: ,p_commit => fnd_api.g_false
894: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
895: ,x_return_status => l_return_status
896: ,x_msg_count => x_msg_count
897: ,x_msg_data => x_msg_data

Line 894: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

890: ozf_funds_pvt.update_funds_access(
891: p_api_version => p_api_version_number
892: ,p_init_msg_list => fnd_api.g_false
893: ,p_commit => fnd_api.g_false
894: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
895: ,x_return_status => l_return_status
896: ,x_msg_count => x_msg_count
897: ,x_msg_data => x_msg_data
898: ,p_fund_rec => l_fund_rec

Line 902: IF l_return_status <> fnd_api.g_ret_sts_success THEN

898: ,p_fund_rec => l_fund_rec
899: ,p_mode => 'DELETE'
900: );
901: -- dbms_output.put_line('update_funds_access for budget ' || l_fund_rec.short_name || ' returns ' || x_return_status);
902: IF l_return_status <> fnd_api.g_ret_sts_success THEN
903: -- l_msg_text := 'Remove ancestor''s access to budget ' || l_fund_rec.short_name;
904: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');
905: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
906: ozf_utility_pvt.create_log(

Line 914: IF l_return_status = fnd_api.g_ret_sts_error THEN

910: , p_msg_data => fnd_message.get
911: , p_msg_type => 'ERROR'
912: );
913:
914: IF l_return_status = fnd_api.g_ret_sts_error THEN
915: RAISE fnd_api.g_exc_error;
916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;

Line 915: RAISE fnd_api.g_exc_error;

911: , p_msg_type => 'ERROR'
912: );
913:
914: IF l_return_status = fnd_api.g_ret_sts_error THEN
915: RAISE fnd_api.g_exc_error;
916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;
919: END IF;

Line 916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

912: );
913:
914: IF l_return_status = fnd_api.g_ret_sts_error THEN
915: RAISE fnd_api.g_exc_error;
916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;
919: END IF;
920:

Line 917: RAISE fnd_api.g_exc_unexpected_error;

913:
914: IF l_return_status = fnd_api.g_ret_sts_error THEN
915: RAISE fnd_api.g_exc_error;
916: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
917: RAISE fnd_api.g_exc_unexpected_error;
918: END IF;
919: END IF;
920:
921: END IF; -- update ancestor

Line 933: IF l_return_status = fnd_api.g_ret_sts_error THEN

929: ,x_msg_count => x_msg_count
930: ,x_msg_data => x_msg_data
931: );
932:
933: IF l_return_status = fnd_api.g_ret_sts_error THEN
934: RAISE fnd_api.g_exc_error;
935: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;

Line 934: RAISE fnd_api.g_exc_error;

930: ,x_msg_data => x_msg_data
931: );
932:
933: IF l_return_status = fnd_api.g_ret_sts_error THEN
934: RAISE fnd_api.g_exc_error;
935: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938: END IF;

Line 935: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

931: );
932:
933: IF l_return_status = fnd_api.g_ret_sts_error THEN
934: RAISE fnd_api.g_exc_error;
935: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938: END IF;
939:

Line 936: RAISE fnd_api.g_exc_unexpected_error;

932:
933: IF l_return_status = fnd_api.g_ret_sts_error THEN
934: RAISE fnd_api.g_exc_error;
935: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
936: RAISE fnd_api.g_exc_unexpected_error;
937: END IF;
938: END IF;
939:
940: -- End Terminate offer

Line 1043: ,p_init_msg_list => fnd_api.g_false

1039: -- remove every one's access to this budget
1040: FOR fund_access_rec IN c_fund_access LOOP
1041: ams_access_pvt.delete_access(
1042: p_api_version => p_api_version_number
1043: ,p_init_msg_list => fnd_api.g_false
1044: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1045: ,x_return_status => l_return_status
1046: ,x_msg_count => x_msg_count
1047: ,x_msg_data => x_msg_data

Line 1044: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

1040: FOR fund_access_rec IN c_fund_access LOOP
1041: ams_access_pvt.delete_access(
1042: p_api_version => p_api_version_number
1043: ,p_init_msg_list => fnd_api.g_false
1044: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1045: ,x_return_status => l_return_status
1046: ,x_msg_count => x_msg_count
1047: ,x_msg_data => x_msg_data
1048: ,p_commit => fnd_api.g_false

Line 1048: ,p_commit => fnd_api.g_false

1044: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1045: ,x_return_status => l_return_status
1046: ,x_msg_count => x_msg_count
1047: ,x_msg_data => x_msg_data
1048: ,p_commit => fnd_api.g_false
1049: ,p_access_id => fund_access_rec.activity_access_id
1050: ,p_object_version => fund_access_rec.object_version_number);
1051: -- dbms_output.put_line('delete access to fund returns ' || l_return_status);
1052: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1052: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1048: ,p_commit => fnd_api.g_false
1049: ,p_access_id => fund_access_rec.activity_access_id
1050: ,p_object_version => fund_access_rec.object_version_number);
1051: -- dbms_output.put_line('delete access to fund returns ' || l_return_status);
1052: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1053: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');
1054: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
1055: ozf_utility_pvt.create_log(
1056: x_return_status => l_return_status

Line 1062: IF l_return_status = fnd_api.g_ret_sts_error THEN

1058: , p_log_used_by_id => p_top_del_budget_id
1059: , p_msg_data => fnd_message.get
1060: , p_msg_type => 'MILESTONE'
1061: );
1062: IF l_return_status = fnd_api.g_ret_sts_error THEN
1063: RAISE fnd_api.g_exc_error;
1064: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1065: RAISE fnd_api.g_exc_unexpected_error;
1066: END IF;

Line 1063: RAISE fnd_api.g_exc_error;

1059: , p_msg_data => fnd_message.get
1060: , p_msg_type => 'MILESTONE'
1061: );
1062: IF l_return_status = fnd_api.g_ret_sts_error THEN
1063: RAISE fnd_api.g_exc_error;
1064: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1065: RAISE fnd_api.g_exc_unexpected_error;
1066: END IF;
1067: END IF;

Line 1064: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1060: , p_msg_type => 'MILESTONE'
1061: );
1062: IF l_return_status = fnd_api.g_ret_sts_error THEN
1063: RAISE fnd_api.g_exc_error;
1064: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1065: RAISE fnd_api.g_exc_unexpected_error;
1066: END IF;
1067: END IF;
1068: END LOOP;

Line 1065: RAISE fnd_api.g_exc_unexpected_error;

1061: );
1062: IF l_return_status = fnd_api.g_ret_sts_error THEN
1063: RAISE fnd_api.g_exc_error;
1064: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1065: RAISE fnd_api.g_exc_unexpected_error;
1066: END IF;
1067: END IF;
1068: END LOOP;
1069:

Line 1091: WHEN fnd_api.g_exc_error THEN

1087: DELETE FROM ozf_funds_all_tl
1088: WHERE fund_id = p_object_id;
1089: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_tl records with budget ' || l_fund_rec.short_name);
1090: EXCEPTION
1091: WHEN fnd_api.g_exc_error THEN
1092: -- dbms_output.put_line('delete_fund_schema exception expected error');
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: fnd_msg_pub.count_and_get(
1095: p_encoded => fnd_api.g_false

Line 1093: x_return_status := fnd_api.g_ret_sts_error;

1089: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_tl records with budget ' || l_fund_rec.short_name);
1090: EXCEPTION
1091: WHEN fnd_api.g_exc_error THEN
1092: -- dbms_output.put_line('delete_fund_schema exception expected error');
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: fnd_msg_pub.count_and_get(
1095: p_encoded => fnd_api.g_false
1096: ,p_count => x_msg_count
1097: ,p_data => x_msg_data);

Line 1095: p_encoded => fnd_api.g_false

1091: WHEN fnd_api.g_exc_error THEN
1092: -- dbms_output.put_line('delete_fund_schema exception expected error');
1093: x_return_status := fnd_api.g_ret_sts_error;
1094: fnd_msg_pub.count_and_get(
1095: p_encoded => fnd_api.g_false
1096: ,p_count => x_msg_count
1097: ,p_data => x_msg_data);
1098: WHEN fnd_api.g_exc_unexpected_error THEN
1099: -- dbms_output.put_line('delete_fund_schema exception unexpected error');

Line 1098: WHEN fnd_api.g_exc_unexpected_error THEN

1094: fnd_msg_pub.count_and_get(
1095: p_encoded => fnd_api.g_false
1096: ,p_count => x_msg_count
1097: ,p_data => x_msg_data);
1098: WHEN fnd_api.g_exc_unexpected_error THEN
1099: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1100: x_return_status := fnd_api.g_ret_sts_unexp_error;
1101: fnd_msg_pub.count_and_get(
1102: p_encoded => fnd_api.g_false

Line 1100: x_return_status := fnd_api.g_ret_sts_unexp_error;

1096: ,p_count => x_msg_count
1097: ,p_data => x_msg_data);
1098: WHEN fnd_api.g_exc_unexpected_error THEN
1099: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1100: x_return_status := fnd_api.g_ret_sts_unexp_error;
1101: fnd_msg_pub.count_and_get(
1102: p_encoded => fnd_api.g_false
1103: ,p_count => x_msg_count
1104: ,p_data => x_msg_data);

Line 1102: p_encoded => fnd_api.g_false

1098: WHEN fnd_api.g_exc_unexpected_error THEN
1099: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1100: x_return_status := fnd_api.g_ret_sts_unexp_error;
1101: fnd_msg_pub.count_and_get(
1102: p_encoded => fnd_api.g_false
1103: ,p_count => x_msg_count
1104: ,p_data => x_msg_data);
1105: WHEN OTHERS THEN
1106: -- dbms_output.put_line('delete_fund_schema exception other error');

Line 1107: x_return_status := fnd_api.g_ret_sts_unexp_error;

1103: ,p_count => x_msg_count
1104: ,p_data => x_msg_data);
1105: WHEN OTHERS THEN
1106: -- dbms_output.put_line('delete_fund_schema exception other error');
1107: x_return_status := fnd_api.g_ret_sts_unexp_error;
1108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111: fnd_msg_pub.count_and_get(

Line 1112: p_encoded => fnd_api.g_false

1108: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1109: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1110: END IF;
1111: fnd_msg_pub.count_and_get(
1112: p_encoded => fnd_api.g_false
1113: ,p_count => x_msg_count
1114: ,p_data => x_msg_data);
1115: END delete_fund_schema;
1116:

Line 1133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1129: ---------------------------------------------------------------------
1130:
1131: PROCEDURE delete_fund(
1132: p_api_version_number IN NUMBER
1133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1134: , p_commit IN VARCHAR2 := fnd_api.g_false
1135: , p_object_id IN NUMBER
1136: , p_object_version_number IN NUMBER
1137: , x_return_status OUT NOCOPY VARCHAR2

Line 1134: , p_commit IN VARCHAR2 := fnd_api.g_false

1130:
1131: PROCEDURE delete_fund(
1132: p_api_version_number IN NUMBER
1133: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1134: , p_commit IN VARCHAR2 := fnd_api.g_false
1135: , p_object_id IN NUMBER
1136: , p_object_version_number IN NUMBER
1137: , x_return_status OUT NOCOPY VARCHAR2
1138: , x_msg_count OUT NOCOPY NUMBER

Line 1144: IF fnd_api.to_boolean (p_init_msg_list) THEN

1140: ) IS
1141: l_api_name CONSTANT VARCHAR2(30) := 'delete_fund';
1142: BEGIN
1143: -- Initialize message list IF p_init_msg_list is set to TRUE.
1144: IF fnd_api.to_boolean (p_init_msg_list) THEN
1145: fnd_msg_pub.initialize;
1146: END IF;
1147:
1148: delete_fund_schema(

Line 1159: IF p_commit = fnd_api.g_true THEN

1155: , x_msg_data => x_msg_data
1156: );
1157: -- dbms_output.put_line('delete_fund_schema returns ' || x_return_status);
1158:
1159: IF p_commit = fnd_api.g_true THEN
1160: commit;
1161: END IF;
1162:
1163: EXCEPTION

Line 1170: p_encoded => fnd_api.g_false

1166: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1167: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1168: END IF;
1169: fnd_msg_pub.count_and_get(
1170: p_encoded => fnd_api.g_false
1171: ,p_count => x_msg_count
1172: ,p_data => x_msg_data);
1173: END delete_fund;
1174: