DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on FND_MESSAGE

Line 849: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ROLLUP');

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(
852: x_return_status => l_return_status
853: , p_arc_log_used_by => 'FUND'

Line 850: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

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(
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

Line 855: , p_msg_data => fnd_message.get

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
856: , p_msg_type => 'ERROR'
857: );
858:
859: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 881: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');

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(
884: x_return_status => l_return_status
885: , p_arc_log_used_by => 'FUND'

Line 882: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

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(
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

Line 887: , p_msg_data => fnd_message.get

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
888: , p_msg_type => 'ERROR'
889: );
890:
891: IF l_return_status = fnd_api.g_ret_sts_error THEN

Line 953: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_TRANSACTION');

949: AND transfer_type IN ('TRANSFER', 'REQUEST', 'UTILIZATION', 'RESERVE');
950: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' transaction records with budget ' || l_fund_rec.short_name);
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'

Line 954: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

950: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' transaction records with budget ' || l_fund_rec.short_name);
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

Line 959: , p_msg_data => fnd_message.get

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
960: , p_msg_type => 'MILESTONE'
961: );
962: END IF;
963:

Line 971: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_PRODUCT');

967: AND act_product_used_by_id = p_object_id;
968: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' product records with budget ' || l_fund_rec.short_name);
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'

Line 972: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

968: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' product records with budget ' || l_fund_rec.short_name);
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

Line 977: , p_msg_data => fnd_message.get

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
978: , p_msg_type => 'MILESTONE'
979: );
980: END IF;
981:

Line 989: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_MARKET');

985: AND act_market_segment_used_by_id = p_object_id;
986: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' market segment records with budget ' || l_fund_rec.short_name);
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'

Line 990: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

986: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' market segment records with budget ' || l_fund_rec.short_name);
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

Line 995: , p_msg_data => fnd_message.get

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
996: , p_msg_type => 'MILESTONE'
997: );
998: END IF;
999:

Line 1029: fnd_message.set_name ('OZF', 'OZF_ERR_UPD_FUND_ACCESS');

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
1033: , p_arc_log_used_by => 'FUND'

Line 1030: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

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
1033: , p_arc_log_used_by => 'FUND'
1034: , p_log_used_by_id => p_top_del_budget_id

Line 1035: , p_msg_data => fnd_message.get

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

Line 1052: fnd_message.set_name ('OZF', 'OZF_DEL_FUND_RECORD');

1048: AND object_version_number = p_object_version_number;
1049: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
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'

Line 1053: fnd_message.set_token ('BUDGET_NAME', l_fund_rec.short_name);

1049: -- dbms_output.put_line('Remove ' || SQL%ROWCOUNT || ' ozf_funds_all_b records with budget ' || l_fund_rec.short_name);
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

Line 1058: , p_msg_data => fnd_message.get

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
1059: , p_msg_type => 'MILESTONE'
1060: );
1061: END IF;
1062: