DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on OZF_UTILITY_PVT

Line 246: l_actbudget_tbl(I).TYPE := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', actbudget_rec.arc_act_budget_used_by);

242: END IF;
243: END IF;
244:
245: IF l_include_rec THEN
246: l_actbudget_tbl(I).TYPE := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', actbudget_rec.arc_act_budget_used_by);
247: l_actbudget_tbl(I).status := actbudget_rec.status_code;
248: get_object_info( actbudget_rec.act_budget_used_by_id
249: , actbudget_rec.arc_act_budget_used_by
250: , actbudget_rec.status_code

Line 291: l_actbudget_tbl(I).TYPE := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', actbudget_rec.budget_source_type);

287: END IF;
288: END IF;
289:
290: IF l_include_rec THEN
291: l_actbudget_tbl(I).TYPE := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', actbudget_rec.budget_source_type);
292: l_actbudget_tbl(I).status := actbudget_rec.status_code;
293: get_object_info( actbudget_rec.budget_source_id
294: , actbudget_rec.budget_source_type
295: , actbudget_rec.status_code

Line 376: l_object_type := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER', 'FUND');

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');
377: FOR child_fund_rec IN c_get_child_funds LOOP
378: l_child_fund_tbl(I).name := child_fund_rec.short_name;
379: l_child_fund_tbl(I).type := l_object_type;
380: l_child_fund_tbl(I).status := child_fund_rec.status_code;

Line 637: ozf_utility_pvt.debug_message(l_full_name ||

633: BEGIN
634:
635: SAVEPOINT terminate_accrual_offer;
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:

Line 644: ozf_utility_pvt.debug_message('l_qp_list_header_id =>' ||

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 =>' ||
645: l_qp_list_header_id);
646: END IF;
647:
648: OPEN c_qp_list_header_id;

Line 665: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type,'CANCELLED');

661: l_offer_hdr_rec.offer_operation := 'UPDATE';
662: l_offer_hdr_rec.modifier_operation := 'UPDATE';
663:
664: --kdass bug 3612350 - changed offer status from TERMINATED to CANCELLED
665: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type,'CANCELLED');
666: l_offer_hdr_rec.status_code := 'CANCELLED';
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:

Line 667: --l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type,'TERMINATED');

663:
664: --kdass bug 3612350 - changed offer status from TERMINATED to CANCELLED
665: l_offer_hdr_rec.user_status_id := ozf_utility_pvt.get_default_user_status(l_status_type,'CANCELLED');
666: l_offer_hdr_rec.status_code := 'CANCELLED';
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,

Line 684: ozf_utility_pvt.debug_message(

680: x_qp_list_header_id=> l_qp_list_header_id,
681: x_error_location=> l_error_location);
682:
683: IF G_DEBUG THEN
684: ozf_utility_pvt.debug_message(
685: 'l_return_status' ||
686: l_return_status ||
687: '-' ||
688: l_error_location ||

Line 694: ozf_utility_pvt.debug_message('OZF_OFFR_QP_FAILURE ' ||

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);
697: END IF;
698:

Line 851: ozf_utility_pvt.create_log(

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(
852: x_return_status => l_return_status
853: , p_arc_log_used_by => 'FUND'
854: , p_log_used_by_id => p_top_del_budget_id
855: , p_msg_data => fnd_message.get

Line 883: ozf_utility_pvt.create_log(

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(
884: x_return_status => l_return_status
885: , p_arc_log_used_by => 'FUND'
886: , p_log_used_by_id => p_top_del_budget_id
887: , p_msg_data => fnd_message.get

Line 955: ozf_utility_pvt.create_log(

951: IF SQL%ROWCOUNT > 0 THEN
952: -- l_msg_text := 'Remove transactions associated with budget ' || l_fund_rec.short_name;
953: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_TRANSACTION');
954: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
955: ozf_utility_pvt.create_log(
956: x_return_status => l_return_status
957: , p_arc_log_used_by => 'FUND'
958: , p_log_used_by_id => p_top_del_budget_id
959: , p_msg_data => fnd_message.get

Line 973: ozf_utility_pvt.create_log(

969: IF SQL%ROWCOUNT > 0 THEN
970: --l_msg_text := 'Remove products associated with budget ' || l_fund_rec.short_name;
971: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_PRODUCT');
972: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
973: ozf_utility_pvt.create_log(
974: x_return_status => l_return_status
975: , p_arc_log_used_by => 'FUND'
976: , p_log_used_by_id => p_top_del_budget_id
977: , p_msg_data => fnd_message.get

Line 991: ozf_utility_pvt.create_log(

987: IF SQL%ROWCOUNT > 0 THEN
988: --l_msg_text := 'Remove market eligibilities associated with budget ' || l_fund_rec.short_name;
989: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_MARKET');
990: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
991: ozf_utility_pvt.create_log(
992: x_return_status => l_return_status
993: , p_arc_log_used_by => 'FUND'
994: , p_log_used_by_id => p_top_del_budget_id
995: , p_msg_data => fnd_message.get

Line 1031: ozf_utility_pvt.create_log(

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
1033: , p_arc_log_used_by => 'FUND'
1034: , p_log_used_by_id => p_top_del_budget_id
1035: , p_msg_data => fnd_message.get

Line 1054: ozf_utility_pvt.create_log(

1050: IF SQL%ROWCOUNT > 0 THEN
1051: -- l_msg_text := 'Remove table record of budget ' || l_fund_rec.short_name;
1052: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_RECORD');
1053: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
1054: ozf_utility_pvt.create_log(
1055: x_return_status => l_return_status
1056: , p_arc_log_used_by => 'FUND'
1057: , p_log_used_by_id => p_top_del_budget_id
1058: , p_msg_data => fnd_message.get