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 639: ozf_utility_pvt.debug_message(l_full_name ||

635: BEGIN
636:
637: SAVEPOINT terminate_accrual_offer;
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:

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

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

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

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

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

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

Line 686: ozf_utility_pvt.debug_message(

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

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

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);
699: END IF;
700:

Line 874: ozf_utility_pvt.create_log(

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(
875: x_return_status => l_return_status
876: , p_arc_log_used_by => 'FUND'
877: , p_log_used_by_id => p_top_del_budget_id
878: , p_msg_data => fnd_message.get

Line 906: ozf_utility_pvt.create_log(

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(
907: x_return_status => l_return_status
908: , p_arc_log_used_by => 'FUND'
909: , p_log_used_by_id => p_top_del_budget_id
910: , p_msg_data => fnd_message.get

Line 978: ozf_utility_pvt.create_log(

974: IF SQL%ROWCOUNT > 0 THEN
975: -- l_msg_text := 'Remove transactions associated with budget ' || l_fund_rec.short_name;
976: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_TRANSACTION');
977: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
978: ozf_utility_pvt.create_log(
979: x_return_status => l_return_status
980: , p_arc_log_used_by => 'FUND'
981: , p_log_used_by_id => p_top_del_budget_id
982: , p_msg_data => fnd_message.get

Line 996: ozf_utility_pvt.create_log(

992: IF SQL%ROWCOUNT > 0 THEN
993: --l_msg_text := 'Remove products associated with budget ' || l_fund_rec.short_name;
994: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_PRODUCT');
995: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
996: ozf_utility_pvt.create_log(
997: x_return_status => l_return_status
998: , p_arc_log_used_by => 'FUND'
999: , p_log_used_by_id => p_top_del_budget_id
1000: , p_msg_data => fnd_message.get

Line 1014: ozf_utility_pvt.create_log(

1010: IF SQL%ROWCOUNT > 0 THEN
1011: --l_msg_text := 'Remove market eligibilities associated with budget ' || l_fund_rec.short_name;
1012: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_MARKET');
1013: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
1014: ozf_utility_pvt.create_log(
1015: x_return_status => l_return_status
1016: , p_arc_log_used_by => 'FUND'
1017: , p_log_used_by_id => p_top_del_budget_id
1018: , p_msg_data => fnd_message.get

Line 1055: ozf_utility_pvt.create_log(

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
1057: , p_arc_log_used_by => 'FUND'
1058: , p_log_used_by_id => p_top_del_budget_id
1059: , p_msg_data => fnd_message.get

Line 1078: ozf_utility_pvt.create_log(

1074: IF SQL%ROWCOUNT > 0 THEN
1075: -- l_msg_text := 'Remove table record of budget ' || l_fund_rec.short_name;
1076: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_RECORD');
1077: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);
1078: ozf_utility_pvt.create_log(
1079: x_return_status => l_return_status
1080: , p_arc_log_used_by => 'FUND'
1081: , p_log_used_by_id => p_top_del_budget_id
1082: , p_msg_data => fnd_message.get