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

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

Line 521: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 522: raise fnd_api.g_exc_unexpected_error;

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

Line 528: x_return_status := fnd_api.g_ret_sts_success;

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

Line 543: IF x_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 544: raise fnd_api.g_exc_unexpected_error;

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

Line 561: WHEN fnd_api.g_exc_error THEN

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

Line 562: x_return_status := fnd_api.g_ret_sts_error;

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

Line 564: p_encoded => fnd_api.g_false

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

Line 567: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 568: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 570: p_encoded => fnd_api.g_false

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

Line 574: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 579: p_encoded => fnd_api.g_false

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

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

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

Line 640: x_return_status := fnd_api.g_ret_sts_success;

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

Line 671: p_init_msg_list=> fnd_api.g_false,

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

Line 673: p_commit=> fnd_api.g_false,

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

Line 692: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

Line 700: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

Line 701: RAISE fnd_api.g_exc_error;

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

Line 702: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

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

Line 703: RAISE fnd_api.g_exc_unexpected_error;

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

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

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

Line 790: x_return_status := fnd_api.g_ret_sts_success;

786: WHERE act_access_to_object_id = p_object_id
787: AND arc_act_access_to_object = 'FUND';
788:
789: BEGIN
790: x_return_status := fnd_api.g_ret_sts_success;
791:
792: FOR child_rec IN c_get_child_funds LOOP
793: delete_fund_schema(p_api_version_number => p_api_version_number
794: , p_object_id => child_rec.fund_id

Line 801: IF l_return_status <> fnd_api.g_ret_sts_success THEN

797: , x_return_status => l_return_status
798: , x_msg_count => x_msg_count
799: , x_msg_data => x_msg_data
800: );
801: IF l_return_status <> fnd_api.g_ret_sts_success THEN
802: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
803: END IF;
804: END LOOP;
805:

Line 802: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;

798: , x_msg_count => x_msg_count
799: , x_msg_data => x_msg_data
800: );
801: IF l_return_status <> fnd_api.g_ret_sts_success THEN
802: RAISE fnd_api.G_EXC_UNEXPECTED_ERROR;
803: END IF;
804: END LOOP;
805:
806: -- ??? how to delete note? no JTF_NOTEs_PUB.delete

Line 838: ,p_init_msg_list => fnd_api.g_false

834: AND p_top_del_budget_id = p_object_id THEN
835: -- update its ancestors' rollup amount
836: ozf_funds_pvt.update_rollup_amount(
837: p_api_version => p_api_version_number
838: ,p_init_msg_list => fnd_api.g_false
839: ,p_commit => fnd_api.g_false
840: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
841: ,x_return_status => l_return_status
842: ,x_msg_count => x_msg_count

Line 839: ,p_commit => fnd_api.g_false

835: -- update its ancestors' rollup amount
836: ozf_funds_pvt.update_rollup_amount(
837: p_api_version => p_api_version_number
838: ,p_init_msg_list => fnd_api.g_false
839: ,p_commit => fnd_api.g_false
840: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
841: ,x_return_status => l_return_status
842: ,x_msg_count => x_msg_count
843: ,x_msg_data => x_msg_data

Line 840: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

836: ozf_funds_pvt.update_rollup_amount(
837: p_api_version => p_api_version_number
838: ,p_init_msg_list => fnd_api.g_false
839: ,p_commit => fnd_api.g_false
840: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
841: ,x_return_status => l_return_status
842: ,x_msg_count => x_msg_count
843: ,x_msg_data => x_msg_data
844: ,p_fund_rec => l_fund_rec

Line 847: IF l_return_status <> fnd_api.g_ret_sts_success THEN

843: ,x_msg_data => x_msg_data
844: ,p_fund_rec => l_fund_rec
845: );
846: -- dbms_output.put_line('update_rollup_amount for budget ' || l_fund_rec.short_name || ' returns ' || x_return_status);
847: IF l_return_status <> fnd_api.g_ret_sts_success THEN
848: -- l_msg_text := 'Update ancestor''s rollup amount for budget ' || l_fund_rec.short_name;
849: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ROLLUP');
850: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
851: ozf_utility_pvt.create_log(

Line 859: IF l_return_status = fnd_api.g_ret_sts_error THEN

855: , p_msg_data => fnd_message.get
856: , p_msg_type => 'ERROR'
857: );
858:
859: IF l_return_status = fnd_api.g_ret_sts_error THEN
860: RAISE fnd_api.g_exc_error;
861: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
862: RAISE fnd_api.g_exc_unexpected_error;
863: END IF;

Line 860: RAISE fnd_api.g_exc_error;

856: , p_msg_type => 'ERROR'
857: );
858:
859: IF l_return_status = fnd_api.g_ret_sts_error THEN
860: RAISE fnd_api.g_exc_error;
861: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
862: RAISE fnd_api.g_exc_unexpected_error;
863: END IF;
864: END IF;

Line 861: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

857: );
858:
859: IF l_return_status = fnd_api.g_ret_sts_error THEN
860: RAISE fnd_api.g_exc_error;
861: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
862: RAISE fnd_api.g_exc_unexpected_error;
863: END IF;
864: END IF;
865:

Line 862: RAISE fnd_api.g_exc_unexpected_error;

858:
859: IF l_return_status = fnd_api.g_ret_sts_error THEN
860: RAISE fnd_api.g_exc_error;
861: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
862: RAISE fnd_api.g_exc_unexpected_error;
863: END IF;
864: END IF;
865:
866: -- remove its ancestors' access to the budget

Line 869: ,p_init_msg_list => fnd_api.g_false

865:
866: -- remove its ancestors' access to the budget
867: ozf_funds_pvt.update_funds_access(
868: p_api_version => p_api_version_number
869: ,p_init_msg_list => fnd_api.g_false
870: ,p_commit => fnd_api.g_false
871: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
872: ,x_return_status => l_return_status
873: ,x_msg_count => x_msg_count

Line 870: ,p_commit => fnd_api.g_false

866: -- remove its ancestors' access to the budget
867: ozf_funds_pvt.update_funds_access(
868: p_api_version => p_api_version_number
869: ,p_init_msg_list => fnd_api.g_false
870: ,p_commit => fnd_api.g_false
871: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
872: ,x_return_status => l_return_status
873: ,x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data

Line 871: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

867: ozf_funds_pvt.update_funds_access(
868: p_api_version => p_api_version_number
869: ,p_init_msg_list => fnd_api.g_false
870: ,p_commit => fnd_api.g_false
871: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
872: ,x_return_status => l_return_status
873: ,x_msg_count => x_msg_count
874: ,x_msg_data => x_msg_data
875: ,p_fund_rec => l_fund_rec

Line 879: IF l_return_status <> fnd_api.g_ret_sts_success THEN

875: ,p_fund_rec => l_fund_rec
876: ,p_mode => 'DELETE'
877: );
878: -- dbms_output.put_line('update_funds_access for budget ' || l_fund_rec.short_name || ' returns ' || x_return_status);
879: IF l_return_status <> fnd_api.g_ret_sts_success THEN
880: -- l_msg_text := 'Remove ancestor''s access to budget ' || l_fund_rec.short_name;
881: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');
882: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
883: ozf_utility_pvt.create_log(

Line 891: IF l_return_status = fnd_api.g_ret_sts_error THEN

887: , p_msg_data => fnd_message.get
888: , p_msg_type => 'ERROR'
889: );
890:
891: IF l_return_status = fnd_api.g_ret_sts_error THEN
892: RAISE fnd_api.g_exc_error;
893: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
894: RAISE fnd_api.g_exc_unexpected_error;
895: END IF;

Line 892: RAISE fnd_api.g_exc_error;

888: , p_msg_type => 'ERROR'
889: );
890:
891: IF l_return_status = fnd_api.g_ret_sts_error THEN
892: RAISE fnd_api.g_exc_error;
893: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
894: RAISE fnd_api.g_exc_unexpected_error;
895: END IF;
896: END IF;

Line 893: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

889: );
890:
891: IF l_return_status = fnd_api.g_ret_sts_error THEN
892: RAISE fnd_api.g_exc_error;
893: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
894: RAISE fnd_api.g_exc_unexpected_error;
895: END IF;
896: END IF;
897:

Line 894: RAISE fnd_api.g_exc_unexpected_error;

890:
891: IF l_return_status = fnd_api.g_ret_sts_error THEN
892: RAISE fnd_api.g_exc_error;
893: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
894: RAISE fnd_api.g_exc_unexpected_error;
895: END IF;
896: END IF;
897:
898: END IF; -- update ancestor

Line 910: IF l_return_status = fnd_api.g_ret_sts_error THEN

906: ,x_msg_count => x_msg_count
907: ,x_msg_data => x_msg_data
908: );
909:
910: IF l_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;

Line 911: RAISE fnd_api.g_exc_error;

907: ,x_msg_data => x_msg_data
908: );
909:
910: IF l_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;
915: END IF;

Line 912: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

908: );
909:
910: IF l_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;
915: END IF;
916:

Line 913: RAISE fnd_api.g_exc_unexpected_error;

909:
910: IF l_return_status = fnd_api.g_ret_sts_error THEN
911: RAISE fnd_api.g_exc_error;
912: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
913: RAISE fnd_api.g_exc_unexpected_error;
914: END IF;
915: END IF;
916:
917: -- End Terminate offer

Line 1019: ,p_init_msg_list => fnd_api.g_false

1015: -- remove every one's access to this budget
1016: FOR fund_access_rec IN c_fund_access LOOP
1017: ams_access_pvt.delete_access(
1018: p_api_version => p_api_version_number
1019: ,p_init_msg_list => fnd_api.g_false
1020: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1021: ,x_return_status => l_return_status
1022: ,x_msg_count => x_msg_count
1023: ,x_msg_data => x_msg_data

Line 1020: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE

1016: FOR fund_access_rec IN c_fund_access LOOP
1017: ams_access_pvt.delete_access(
1018: p_api_version => p_api_version_number
1019: ,p_init_msg_list => fnd_api.g_false
1020: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1021: ,x_return_status => l_return_status
1022: ,x_msg_count => x_msg_count
1023: ,x_msg_data => x_msg_data
1024: ,p_commit => fnd_api.g_false

Line 1024: ,p_commit => fnd_api.g_false

1020: ,p_validation_level => fnd_api.G_VALID_LEVEL_NONE
1021: ,x_return_status => l_return_status
1022: ,x_msg_count => x_msg_count
1023: ,x_msg_data => x_msg_data
1024: ,p_commit => fnd_api.g_false
1025: ,p_access_id => fund_access_rec.activity_access_id
1026: ,p_object_version => fund_access_rec.object_version_number);
1027: -- dbms_output.put_line('delete access to fund returns ' || l_return_status);
1028: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 1028: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1024: ,p_commit => fnd_api.g_false
1025: ,p_access_id => fund_access_rec.activity_access_id
1026: ,p_object_version => fund_access_rec.object_version_number);
1027: -- dbms_output.put_line('delete access to fund returns ' || l_return_status);
1028: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1029: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');
1030: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
1031: ozf_utility_pvt.create_log(
1032: x_return_status => l_return_status

Line 1038: IF l_return_status = fnd_api.g_ret_sts_error THEN

1034: , p_log_used_by_id => p_top_del_budget_id
1035: , p_msg_data => fnd_message.get
1036: , p_msg_type => 'MILESTONE'
1037: );
1038: IF l_return_status = fnd_api.g_ret_sts_error THEN
1039: RAISE fnd_api.g_exc_error;
1040: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;

Line 1039: RAISE fnd_api.g_exc_error;

1035: , p_msg_data => fnd_message.get
1036: , p_msg_type => 'MILESTONE'
1037: );
1038: IF l_return_status = fnd_api.g_ret_sts_error THEN
1039: RAISE fnd_api.g_exc_error;
1040: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043: END IF;

Line 1040: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

1036: , p_msg_type => 'MILESTONE'
1037: );
1038: IF l_return_status = fnd_api.g_ret_sts_error THEN
1039: RAISE fnd_api.g_exc_error;
1040: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043: END IF;
1044: END LOOP;

Line 1041: RAISE fnd_api.g_exc_unexpected_error;

1037: );
1038: IF l_return_status = fnd_api.g_ret_sts_error THEN
1039: RAISE fnd_api.g_exc_error;
1040: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
1041: RAISE fnd_api.g_exc_unexpected_error;
1042: END IF;
1043: END IF;
1044: END LOOP;
1045:

Line 1067: WHEN fnd_api.g_exc_error THEN

1063: DELETE FROM ozf_funds_all_tl
1064: WHERE fund_id = p_object_id;
1065: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_tl records with budget ' || l_fund_rec.short_name);
1066: EXCEPTION
1067: WHEN fnd_api.g_exc_error THEN
1068: -- dbms_output.put_line('delete_fund_schema exception expected error');
1069: x_return_status := fnd_api.g_ret_sts_error;
1070: fnd_msg_pub.count_and_get(
1071: p_encoded => fnd_api.g_false

Line 1069: x_return_status := fnd_api.g_ret_sts_error;

1065: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_tl records with budget ' || l_fund_rec.short_name);
1066: EXCEPTION
1067: WHEN fnd_api.g_exc_error THEN
1068: -- dbms_output.put_line('delete_fund_schema exception expected error');
1069: x_return_status := fnd_api.g_ret_sts_error;
1070: fnd_msg_pub.count_and_get(
1071: p_encoded => fnd_api.g_false
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);

Line 1071: p_encoded => fnd_api.g_false

1067: WHEN fnd_api.g_exc_error THEN
1068: -- dbms_output.put_line('delete_fund_schema exception expected error');
1069: x_return_status := fnd_api.g_ret_sts_error;
1070: fnd_msg_pub.count_and_get(
1071: p_encoded => fnd_api.g_false
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074: WHEN fnd_api.g_exc_unexpected_error THEN
1075: -- dbms_output.put_line('delete_fund_schema exception unexpected error');

Line 1074: WHEN fnd_api.g_exc_unexpected_error THEN

1070: fnd_msg_pub.count_and_get(
1071: p_encoded => fnd_api.g_false
1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074: WHEN fnd_api.g_exc_unexpected_error THEN
1075: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077: fnd_msg_pub.count_and_get(
1078: p_encoded => fnd_api.g_false

Line 1076: x_return_status := fnd_api.g_ret_sts_unexp_error;

1072: ,p_count => x_msg_count
1073: ,p_data => x_msg_data);
1074: WHEN fnd_api.g_exc_unexpected_error THEN
1075: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077: fnd_msg_pub.count_and_get(
1078: p_encoded => fnd_api.g_false
1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);

Line 1078: p_encoded => fnd_api.g_false

1074: WHEN fnd_api.g_exc_unexpected_error THEN
1075: -- dbms_output.put_line('delete_fund_schema exception unexpected error');
1076: x_return_status := fnd_api.g_ret_sts_unexp_error;
1077: fnd_msg_pub.count_and_get(
1078: p_encoded => fnd_api.g_false
1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081: WHEN OTHERS THEN
1082: -- dbms_output.put_line('delete_fund_schema exception other error');

Line 1083: x_return_status := fnd_api.g_ret_sts_unexp_error;

1079: ,p_count => x_msg_count
1080: ,p_data => x_msg_data);
1081: WHEN OTHERS THEN
1082: -- dbms_output.put_line('delete_fund_schema exception other error');
1083: x_return_status := fnd_api.g_ret_sts_unexp_error;
1084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1085: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1086: END IF;
1087: fnd_msg_pub.count_and_get(

Line 1088: p_encoded => fnd_api.g_false

1084: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1085: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1086: END IF;
1087: fnd_msg_pub.count_and_get(
1088: p_encoded => fnd_api.g_false
1089: ,p_count => x_msg_count
1090: ,p_data => x_msg_data);
1091: END delete_fund_schema;
1092:

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

1105: ---------------------------------------------------------------------
1106:
1107: PROCEDURE delete_fund(
1108: p_api_version_number IN NUMBER
1109: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1110: , p_commit IN VARCHAR2 := fnd_api.g_false
1111: , p_object_id IN NUMBER
1112: , p_object_version_number IN NUMBER
1113: , x_return_status OUT NOCOPY VARCHAR2

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

1106:
1107: PROCEDURE delete_fund(
1108: p_api_version_number IN NUMBER
1109: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1110: , p_commit IN VARCHAR2 := fnd_api.g_false
1111: , p_object_id IN NUMBER
1112: , p_object_version_number IN NUMBER
1113: , x_return_status OUT NOCOPY VARCHAR2
1114: , x_msg_count OUT NOCOPY NUMBER

Line 1120: IF fnd_api.to_boolean (p_init_msg_list) THEN

1116: ) IS
1117: l_api_name CONSTANT VARCHAR2(30) := 'delete_fund';
1118: BEGIN
1119: -- Initialize message list IF p_init_msg_list is set to TRUE.
1120: IF fnd_api.to_boolean (p_init_msg_list) THEN
1121: fnd_msg_pub.initialize;
1122: END IF;
1123:
1124: delete_fund_schema(

Line 1135: IF p_commit = fnd_api.g_true THEN

1131: , x_msg_data => x_msg_data
1132: );
1133: -- dbms_output.put_line('delete_fund_schema returns ' || x_return_status);
1134:
1135: IF p_commit = fnd_api.g_true THEN
1136: commit;
1137: END IF;
1138:
1139: EXCEPTION

Line 1146: p_encoded => fnd_api.g_false

1142: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1144: END IF;
1145: fnd_msg_pub.count_and_get(
1146: p_encoded => fnd_api.g_false
1147: ,p_count => x_msg_count
1148: ,p_data => x_msg_data);
1149: END delete_fund;
1150: