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_THRESHOLD_RULE_PVT dependencies on FND_MESSAGE

Line 861: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');

857:
858: IF (c_Threshold_Rule%NOTFOUND) THEN
859: CLOSE c_Threshold_Rule;
860: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
861: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
862: FND_MSG_PUB.add;
863: END IF;
864: RAISE FND_API.g_exc_error;
865: END IF;

Line 967: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

963: x_return_status := FND_API.g_ret_sts_success;
964:
965: IF p_threshold_rule_rec.start_date IS NULL THEN
966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
967: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
968: FND_MESSAGE.set_token('COLUMN', 'Start Date');
969: FND_MSG_PUB.add;
970: END IF;
971: x_return_status := FND_API.g_ret_sts_error;

Line 968: FND_MESSAGE.set_token('COLUMN', 'Start Date');

964:
965: IF p_threshold_rule_rec.start_date IS NULL THEN
966: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
967: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
968: FND_MESSAGE.set_token('COLUMN', 'Start Date');
969: FND_MSG_PUB.add;
970: END IF;
971: x_return_status := FND_API.g_ret_sts_error;
972: RETURN;

Line 977: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

973: END IF;
974:
975: IF p_threshold_rule_rec.end_date IS NULL THEN
976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
977: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
978: FND_MESSAGE.set_token('COLUMN', 'End Date');
979: FND_MSG_PUB.add;
980: END IF;
981: x_return_status := FND_API.g_ret_sts_error;

Line 978: FND_MESSAGE.set_token('COLUMN', 'End Date');

974:
975: IF p_threshold_rule_rec.end_date IS NULL THEN
976: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
977: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
978: FND_MESSAGE.set_token('COLUMN', 'End Date');
979: FND_MSG_PUB.add;
980: END IF;
981: x_return_status := FND_API.g_ret_sts_error;
982: RETURN;

Line 987: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

983: END IF;
984:
985: IF p_threshold_rule_rec.value_limit IS NULL THEN
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
988: FND_MESSAGE.set_token('COLUMN', 'Value Limit');
989: FND_MSG_PUB.add;
990: END IF;
991: x_return_status := FND_API.g_ret_sts_error;

Line 988: FND_MESSAGE.set_token('COLUMN', 'Value Limit');

984:
985: IF p_threshold_rule_rec.value_limit IS NULL THEN
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
988: FND_MESSAGE.set_token('COLUMN', 'Value Limit');
989: FND_MSG_PUB.add;
990: END IF;
991: x_return_status := FND_API.g_ret_sts_error;
992: RETURN;

Line 997: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

993: END IF;
994:
995: IF p_threshold_rule_rec.operator_code IS NULL THEN
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
997: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
998: FND_MESSAGE.set_token('COLUMN', 'Operator');
999: FND_MSG_PUB.add;
1000: END IF;
1001: x_return_status := FND_API.g_ret_sts_error;

Line 998: FND_MESSAGE.set_token('COLUMN', 'Operator');

994:
995: IF p_threshold_rule_rec.operator_code IS NULL THEN
996: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
997: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
998: FND_MESSAGE.set_token('COLUMN', 'Operator');
999: FND_MSG_PUB.add;
1000: END IF;
1001: x_return_status := FND_API.g_ret_sts_error;
1002: RETURN;

Line 1014: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1010: IF l_threshold_type IS NOT NULL THEN
1011: IF l_threshold_type = 'QUOTA' THEN
1012: IF p_threshold_rule_rec.comparison_type IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1015: FND_MESSAGE.set_token('COLUMN', 'Comparision Type');
1016: FND_MSG_PUB.add;
1017: END IF;
1018: x_return_status := FND_API.g_ret_sts_error;

Line 1015: FND_MESSAGE.set_token('COLUMN', 'Comparision Type');

1011: IF l_threshold_type = 'QUOTA' THEN
1012: IF p_threshold_rule_rec.comparison_type IS NULL THEN
1013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1014: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1015: FND_MESSAGE.set_token('COLUMN', 'Comparision Type');
1016: FND_MSG_PUB.add;
1017: END IF;
1018: x_return_status := FND_API.g_ret_sts_error;
1019: RETURN;

Line 1023: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1019: RETURN;
1020: END IF;
1021: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1023: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1024: FND_MESSAGE.set_token('COLUMN', 'Comparision Value');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;

Line 1024: FND_MESSAGE.set_token('COLUMN', 'Comparision Value');

1020: END IF;
1021: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1023: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1024: FND_MESSAGE.set_token('COLUMN', 'Comparision Value');
1025: FND_MSG_PUB.add;
1026: END IF;
1027: x_return_status := FND_API.g_ret_sts_error;
1028: RETURN;

Line 1033: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1029: END IF;
1030: IF p_threshold_rule_rec.comparison_type = 'PERCENT' THEN
1031: IF p_threshold_rule_rec.base_line IS NULL THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1033: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1034: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1035: FND_MSG_PUB.add;
1036: END IF;
1037: x_return_status := FND_API.g_ret_sts_error;

Line 1034: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');

1030: IF p_threshold_rule_rec.comparison_type = 'PERCENT' THEN
1031: IF p_threshold_rule_rec.base_line IS NULL THEN
1032: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1033: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1034: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1035: FND_MSG_PUB.add;
1036: END IF;
1037: x_return_status := FND_API.g_ret_sts_error;
1038: RETURN;

Line 1043: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1039: END IF;
1040: END IF;
1041: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1043: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1044: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1045: FND_MSG_PUB.add;
1046: END IF;
1047: x_return_status := FND_API.g_ret_sts_error;

Line 1044: FND_MESSAGE.set_token('COLUMN', 'Frequency');

1040: END IF;
1041: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1042: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1043: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1044: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1045: FND_MSG_PUB.add;
1046: END IF;
1047: x_return_status := FND_API.g_ret_sts_error;
1048: RETURN;

Line 1052: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1048: RETURN;
1049: END IF;
1050: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1052: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1053: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;

Line 1053: FND_MESSAGE.set_token('COLUMN', 'Period Type');

1049: END IF;
1050: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1051: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1052: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1053: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1054: FND_MSG_PUB.add;
1055: END IF;
1056: x_return_status := FND_API.g_ret_sts_error;
1057: RETURN;

Line 1061: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1057: RETURN;
1058: END IF;
1059: IF p_threshold_rule_rec.alert_type IS NULL THEN
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1061: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1062: FND_MESSAGE.set_token('COLUMN', 'Alert Type');
1063: FND_MSG_PUB.add;
1064: END IF;
1065: x_return_status := FND_API.g_ret_sts_error;

Line 1062: FND_MESSAGE.set_token('COLUMN', 'Alert Type');

1058: END IF;
1059: IF p_threshold_rule_rec.alert_type IS NULL THEN
1060: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1061: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1062: FND_MESSAGE.set_token('COLUMN', 'Alert Type');
1063: FND_MSG_PUB.add;
1064: END IF;
1065: x_return_status := FND_API.g_ret_sts_error;
1066: RETURN;

Line 1071: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1067: END IF;
1068: ELSIF l_threshold_type = 'BUDGET' THEN
1069: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1071: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN', 'Percent');
1073: FND_MSG_PUB.add;
1074: END IF;
1075: x_return_status := FND_API.g_ret_sts_error;

Line 1072: FND_MESSAGE.set_token('COLUMN', 'Percent');

1068: ELSIF l_threshold_type = 'BUDGET' THEN
1069: IF p_threshold_rule_rec.percent_amount IS NULL THEN
1070: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1071: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN', 'Percent');
1073: FND_MSG_PUB.add;
1074: END IF;
1075: x_return_status := FND_API.g_ret_sts_error;
1076: RETURN;

Line 1080: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1076: RETURN;
1077: END IF;
1078: IF p_threshold_rule_rec.base_line IS NULL THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1081: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1082: FND_MSG_PUB.add;
1083: END IF;
1084: x_return_status := FND_API.g_ret_sts_error;

Line 1081: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');

1077: END IF;
1078: IF p_threshold_rule_rec.base_line IS NULL THEN
1079: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1080: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1081: FND_MESSAGE.set_token('COLUMN', 'OfBaseline');
1082: FND_MSG_PUB.add;
1083: END IF;
1084: x_return_status := FND_API.g_ret_sts_error;
1085: RETURN;

Line 1089: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1085: RETURN;
1086: END IF;
1087: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1089: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1090: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1091: FND_MSG_PUB.add;
1092: END IF;
1093: x_return_status := FND_API.g_ret_sts_error;

Line 1090: FND_MESSAGE.set_token('COLUMN', 'Frequency');

1086: END IF;
1087: IF p_threshold_rule_rec.repeat_frequency IS NULL THEN
1088: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1089: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1090: FND_MESSAGE.set_token('COLUMN', 'Frequency');
1091: FND_MSG_PUB.add;
1092: END IF;
1093: x_return_status := FND_API.g_ret_sts_error;
1094: RETURN;

Line 1098: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');

1094: RETURN;
1095: END IF;
1096: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1099: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1100: FND_MSG_PUB.add;
1101: END IF;
1102: x_return_status := FND_API.g_ret_sts_error;

Line 1099: FND_MESSAGE.set_token('COLUMN', 'Period Type');

1095: END IF;
1096: IF p_threshold_rule_rec.frequency_period IS NULL THEN
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1098: FND_MESSAGE.set_name('OZF', 'OZF_FUND_MISSING_COLUMN');
1099: FND_MESSAGE.set_token('COLUMN', 'Period Type');
1100: FND_MSG_PUB.add;
1101: END IF;
1102: x_return_status := FND_API.g_ret_sts_error;
1103: RETURN;