DBA Data[Home] [Help]

APPS.OZF_FUND_EXTENSION_PVT dependencies on FND_MESSAGE

Line 810: FND_MESSAGE.set_name('OZF', 'OZF_DEL_FUND_ACCRUALS');

806: CLOSE c_get_fund_utiz_info;
807:
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:

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

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

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

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

Line 878: , p_msg_data => fnd_message.get

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
879: , p_msg_type => 'ERROR'
880: );
881:
882: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

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

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

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

Line 910: , p_msg_data => fnd_message.get

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
911: , p_msg_type => 'ERROR'
912: );
913:
914: IF l_return_status = fnd_api.g_ret_sts_error THEN

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

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

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

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

Line 982: , p_msg_data => fnd_message.get

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
983: , p_msg_type => 'MILESTONE'
984: );
985: END IF;
986:

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

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

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

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

Line 1000: , p_msg_data => fnd_message.get

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
1001: , p_msg_type => 'MILESTONE'
1002: );
1003: END IF;
1004:

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

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

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

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

Line 1018: , p_msg_data => fnd_message.get

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
1019: , p_msg_type => 'MILESTONE'
1020: );
1021: END IF;
1022:

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

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

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

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

Line 1059: , p_msg_data => fnd_message.get

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

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

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

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

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

Line 1082: , p_msg_data => fnd_message.get

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
1083: , p_msg_type => 'MILESTONE'
1084: );
1085: END IF;
1086: