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.AHL_FMP_MR_INTERVAL_PVT dependencies on FND_MSG_PUB

Line 140: FND_MSG_PUB.add;

136: -- Check if a valid value is passed in p_mr_header_id
137: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
138: p_mr_header_id IS NULL ) THEN
139: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
140: FND_MSG_PUB.add;
141: x_return_status := FND_API.G_RET_STS_ERROR;
142: RETURN;
143: END IF;
144:

Line 150: FND_MSG_PUB.ADD;

146:
147: IF G_APPLN_USAGE IS NULL
148: THEN
149: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
150: FND_MSG_PUB.ADD;
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: RETURN;
153: IF G_DEBUG = 'Y' THEN
154: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );

Line 169: FND_MSG_PUB.add;

165: --check if mr is terminated and get the mr status.
166: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
167: IF l_mr_status_code IS NULL THEN
168: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
169: FND_MSG_PUB.add;
170: x_return_status := FND_API.G_RET_STS_ERROR;
171: RETURN;
172: END IF;
173:

Line 195: FND_MSG_PUB.add;

191: END IF;
192:
193: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
194: FND_MESSAGE.set_name( 'AHL', l_msg_data );
195: FND_MSG_PUB.add;
196: x_return_status := l_return_status;
197: RETURN;
198: END IF;
199:

Line 205: FND_MSG_PUB.add;

201: -- Check if a valid value is passed in p_mr_effectivity_id
202: IF ( p_threshold_rec.mr_effectivity_id = FND_API.G_MISS_NUM OR
203: p_threshold_rec.mr_effectivity_id IS NULL ) THEN
204: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
205: FND_MSG_PUB.add;
206: x_return_status := FND_API.G_RET_STS_ERROR;
207: RETURN;
208: END IF;
209:

Line 221: FND_MSG_PUB.add;

217: );
218:
219: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
220: FND_MESSAGE.set_name( 'AHL', l_msg_data );
221: FND_MSG_PUB.add;
222: x_return_status := l_return_status;
223: RETURN;
224: END IF;
225:

Line 236: FND_MSG_PUB.add;

232: ( p_threshold_rec.program_duration IS NULL OR
233: p_threshold_rec.program_duration = FND_API.G_MISS_NUM ) ) THEN
234: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
235: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
236: FND_MSG_PUB.add;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: RETURN;
239: END IF;
240:

Line 249: FND_MSG_PUB.add;

245: p_interval_tbl(i).dml_operation <> 'C' ) THEN
246: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
247: FND_MESSAGE.set_token( 'FIELD', p_interval_tbl(i).dml_operation );
248: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_tbl(i) ) );
249: FND_MSG_PUB.add;
250: x_return_status := FND_API.G_RET_STS_ERROR;
251: RETURN;
252: END IF;
253:

Line 260: FND_MSG_PUB.add;

256: p_interval_tbl(i).dml_operation = 'U' AND
257: p_super_user ='Y' AND
258: l_mr_status_code = 'COMPLETE') THEN
259: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_DML' );
260: FND_MSG_PUB.add;
261: x_return_status := FND_API.G_RET_STS_ERROR;
262: RETURN;
263: END IF;
264:

Line 280: FND_MSG_PUB.add;

276: p_eff_obj_version => p_threshold_rec.OBJECT_VERSION_NUMBER
277: );
278: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
279: FND_MESSAGE.set_name( 'AHL', l_msg_data );
280: FND_MSG_PUB.add;
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: RETURN;
283: END IF;
284: END IF;

Line 302: FND_MSG_PUB.add;

298: p_eff_obj_version => p_threshold_rec.OBJECT_VERSION_NUMBER
299: );
300: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
301: FND_MESSAGE.set_name( 'AHL', l_msg_data );
302: FND_MSG_PUB.add;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: RETURN;
305: END IF;
306: END IF;

Line 317: FND_MSG_PUB.add;

313: p_threshold_rec.mr_effectivity_id IS NOT NULL ) AND
314: ( p_threshold_rec.object_version_number IS NULL OR
315: p_threshold_rec.object_version_number = FND_API.G_MISS_NUM ) ) THEN
316: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_OBJ_VERSION_NULL' );
317: FND_MSG_PUB.add;
318: x_return_status := FND_API.G_RET_STS_ERROR;
319: RETURN;
320: END IF;
321:

Line 426: FND_MSG_PUB.add;

422: END IF;
423: END IF;
424:
425: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );
426: FND_MSG_PUB.add;
427: END IF;
428:
429: END IF;
430:

Line 735: FND_MSG_PUB.add;

731:
732: IF get_old_rec%NOTFOUND THEN
733: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_INTERVAL_REC' );
734: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );
735: FND_MSG_PUB.add;
736: CLOSE get_old_rec;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739:

Line 927: FND_MSG_PUB.add;

923: ( p_interval_rec.counter_id = FND_API.G_MISS_NUM AND
924: p_interval_rec.counter_name = FND_API.G_MISS_CHAR ) ) THEN
925: FND_MESSAGE.set_name( 'AHL','AHL_FMP_COUNTER_NULL' );
926: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
927: FND_MSG_PUB.add;
928: END IF;
929: END IF;
930:
931: -- Check if the Interval Value does not contain an invalid value

Line 937: FND_MSG_PUB.add;

933: p_interval_rec.interval_value <= 0 ) THEN
934: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL' );
935: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.interval_value ) );
936: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
937: FND_MSG_PUB.add;
938: END IF;
939:
940: -- Check if the earliest due Value does not contain an invalid value.
941: IF ( p_interval_rec.dml_operation <> 'D' ) THEN

Line 948: FND_MSG_PUB.add;

944: p_interval_rec.earliest_due_value < 0 ) THEN
945: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EARL_DUE' );
946: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.earliest_due_value ) );
947: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
948: FND_MSG_PUB.add;
949: END IF;
950: END IF;
951:
952: -- Check if the Start Value does not contain an invalid value.

Line 960: FND_MSG_PUB.add;

956: p_interval_rec.start_value < 0 ) THEN
957: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_START' );
958: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.start_value ) );
959: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
960: FND_MSG_PUB.add;
961: END IF;
962: END IF;
963:
964: -- Check if the Stop Value does not contain an invalid value.

Line 972: FND_MSG_PUB.add;

968: p_interval_rec.stop_value <= 0 ) THEN
969: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_STOP' );
970: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.stop_value ) );
971: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
972: FND_MSG_PUB.add;
973: END IF;
974: END IF;
975:
976: -- Check if the Tolerance Before does not contain an invalid value.

Line 984: FND_MSG_PUB.add;

980: p_interval_rec.tolerance_before < 0 ) THEN
981: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_BF' );
982: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_before ) );
983: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
984: FND_MSG_PUB.add;
985: END IF;
986: END IF;
987:
988: -- Check if the Tolerance After does not contain an invalid value.

Line 996: FND_MSG_PUB.add;

992: p_interval_rec.tolerance_after < 0 ) THEN
993: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_AF' );
994: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_after ) );
995: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
996: FND_MSG_PUB.add;
997: END IF;
998: END IF;
999:
1000: -- Check if the Reset After does not contain an invalid value.

Line 1008: FND_MSG_PUB.add;

1004: p_interval_rec.reset_value < 0 ) THEN
1005: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_RESET_VALUE' );
1006: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.reset_value ) );
1007: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1008: FND_MSG_PUB.add;
1009: END IF;
1010: END IF;
1011:
1012: -- Check if the mandatory Interval ID column contains a null value.

Line 1018: FND_MSG_PUB.add;

1014: IF ( p_interval_rec.mr_interval_id IS NULL OR
1015: p_interval_rec.mr_interval_id = FND_API.G_MISS_NUM ) THEN
1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_INTERVAL_ID_NULL' );
1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1018: FND_MSG_PUB.add;
1019: END IF;
1020: END IF;
1021:
1022: -- Check if the mandatory Object Version Number column contains a null value.

Line 1028: FND_MSG_PUB.add;

1024: IF ( p_interval_rec.object_version_number IS NULL OR
1025: p_interval_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1026: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INT_OBJ_VERSION_NULL' );
1027: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1028: FND_MSG_PUB.add;
1029: END IF;
1030: END IF;
1031:
1032: END validate_attributes;

Line 1062: FND_MSG_PUB.add;

1058: p_interval_rec.start_date IS NOT NULL OR
1059: p_interval_rec.stop_date IS NOT NULL ) ) THEN
1060: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_INPUTS' );
1061: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1062: FND_MSG_PUB.add;
1063: END IF;
1064:
1065: -- Check if the Interval Value is always passed for non-PM Programs
1066: IF ( ( p_mr_type_code IS NULL OR

Line 1073: FND_MSG_PUB.add;

1069: p_interval_rec.interval_value IS NULL ) OR
1070: ( p_interval_rec.interval_value = FND_API.G_MISS_NUM ) ) THEN
1071: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INTERVAL_NULL' );
1072: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1073: FND_MSG_PUB.add;
1074: END IF;
1075:
1076: -- Check if Start is passed for PM Programs
1077: IF ( p_mr_type_code = 'PROGRAM' AND

Line 1081: FND_MSG_PUB.add;

1077: IF ( p_mr_type_code = 'PROGRAM' AND
1078: p_interval_rec.start_value IS NULL ) THEN
1079: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_START_NULL' );
1080: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1081: FND_MSG_PUB.add;
1082: RETURN;
1083: END IF;
1084:
1085: -- Check if Stop is passed for PM Programs

Line 1090: FND_MSG_PUB.add;

1086: IF ( p_mr_type_code = 'PROGRAM' AND
1087: p_interval_rec.stop_value IS NULL ) THEN
1088: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_STOP_NULL' );
1089: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1090: FND_MSG_PUB.add;
1091: RETURN;
1092: END IF;
1093:
1094: -- Check if Range is not passed for One Time MRs.

Line 1104: FND_MSG_PUB.add;

1100: p_interval_rec.start_date IS NOT NULL OR
1101: p_interval_rec.stop_date IS NOT NULL ) ) THEN
1102: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RANGE_NOTNULL' );
1103: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1104: FND_MSG_PUB.add;
1105: RETURN;
1106: END IF;
1107:
1108: -- Check if the Tolerance Before is less than the Interval Value

Line 1113: FND_MSG_PUB.add;

1109: IF ( p_interval_rec.tolerance_before IS NOT NULL AND
1110: p_interval_rec.tolerance_before >= p_interval_rec.interval_value ) THEN
1111: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_BF_INT' );
1112: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1113: FND_MSG_PUB.add;
1114: END IF;
1115:
1116: -- Check if the Tolerance After is less than the Interval Value
1117: IF ( p_interval_rec.tolerance_after IS NOT NULL AND

Line 1121: FND_MSG_PUB.add;

1117: IF ( p_interval_rec.tolerance_after IS NOT NULL AND
1118: p_interval_rec.tolerance_after >= p_interval_rec.interval_value ) THEN
1119: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_AF_INT' );
1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1121: FND_MSG_PUB.add;
1122: END IF;
1123:
1124: IF ( p_interval_rec.counter_id IS NOT NULL AND
1125: p_interval_rec.reset_value IS NOT NULL AND

Line 1138: FND_MSG_PUB.add;

1134: IF ( p_interval_rec.reset_value < l_initial_reading ) THEN
1135: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_LESS_INIT_VALUE' );
1136: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( l_initial_reading ) );
1137: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1138: FND_MSG_PUB.add;
1139: END IF;
1140:
1141: END IF;
1142:

Line 1148: FND_MSG_PUB.add;

1144: IF ( p_interval_rec.start_value IS NULL AND
1145: p_interval_rec.stop_value IS NOT NULL ) THEN
1146: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_VALUE_RANGE' );
1147: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1148: FND_MSG_PUB.add;
1149: END IF;
1150:
1151: -- Check if the Start Value is passed if Stop Value is passed
1152: IF ( p_interval_rec.start_value IS NULL AND

Line 1157: FND_MSG_PUB.add;

1153: p_interval_rec.start_date IS NULL AND
1154: p_interval_rec.earliest_due_value IS NOT NULL ) THEN
1155: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
1156: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1157: FND_MSG_PUB.add;
1158: END IF;
1159:
1160: -- Check if the Start Date is passed if Stop Date is passed
1161: IF ( p_interval_rec.start_date IS NULL AND

Line 1165: FND_MSG_PUB.add;

1161: IF ( p_interval_rec.start_date IS NULL AND
1162: p_interval_rec.stop_date IS NOT NULL ) THEN
1163: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_DATE_RANGE' );
1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: -- Check if the Stop Value is not greater than Start Value
1169: IF ( p_interval_rec.start_value IS NOT NULL AND

Line 1174: FND_MSG_PUB.add;

1170: p_interval_rec.stop_value IS NOT NULL AND
1171: p_interval_rec.stop_value < p_interval_rec.start_value ) THEN
1172: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_VALUE_RANGE' );
1173: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1174: FND_MSG_PUB.add;
1175: END IF;
1176:
1177: -- Check if the Stop date is not greater than Start date
1178: IF ( p_interval_rec.start_date IS NOT NULL AND

Line 1183: FND_MSG_PUB.add;

1179: p_interval_rec.stop_date IS NOT NULL AND
1180: p_interval_rec.stop_date < p_interval_rec.start_date ) THEN
1181: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_DATE_RANGE' );
1182: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1183: FND_MSG_PUB.add;
1184: END IF;
1185:
1186: -- Check if both Date based and Value based interval ranges are not passed
1187: IF ( ( p_interval_rec.start_date IS NOT NULL OR

Line 1193: FND_MSG_PUB.add;

1189: ( p_interval_rec.start_value IS NOT NULL OR
1190: p_interval_rec.stop_value IS NOT NULL ) ) THEN
1191: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_DATE_VALUE_RANGE' );
1192: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1193: FND_MSG_PUB.add;
1194: END IF;
1195:
1196: -- Check if the Interval Value is between Start Value and Stop Value
1197: IF ( p_interval_rec.start_value IS NOT NULL AND

Line 1205: FND_MSG_PUB.add;

1201: -- Fix for bug# 3482307.
1202: ( p_interval_rec.stop_value - p_interval_rec.start_value + 1) ) THEN
1203: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
1204: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1205: FND_MSG_PUB.add;
1206: END IF;
1207:
1208: -- Check if the earliest due value is less than Start Value
1209: IF ( p_interval_rec.start_value IS NOT NULL AND

Line 1213: FND_MSG_PUB.add;

1209: IF ( p_interval_rec.start_value IS NOT NULL AND
1210: p_interval_rec.earliest_due_value > p_interval_rec.start_value ) THEN
1211: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
1212: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1213: FND_MSG_PUB.add;
1214: END IF;
1215:
1216: END validate_record;
1217:

Line 1323: FND_MSG_PUB.add;

1319: EXIT WHEN get_pm_pgm_dup_rec%NOTFOUND;
1320:
1321: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_PGM_DUP_INT_REC' );
1322: FND_MESSAGE.set_token( 'FIELD', l_interval_rec.counter_name );
1323: FND_MSG_PUB.add;
1324: END LOOP;
1325:
1326: IF ( get_pm_pgm_dup_rec%ROWCOUNT > 0 ) THEN
1327: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1351: FND_MSG_PUB.add;

1347: EXIT WHEN get_dup_rec%NOTFOUND;
1348:
1349: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_INT_REC' );
1350: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1351: FND_MSG_PUB.add;
1352: END LOOP;
1353:
1354: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
1355: CLOSE get_dup_rec;

Line 1385: FND_MSG_PUB.add;

1381: -- Fix for bug# 3482307.
1382: l_interval_rec.start_date <= l_prev_stop_date ) THEN
1383: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_DATE_RANGE' );
1384: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1385: FND_MSG_PUB.add;
1386: CLOSE get_recs_for_date_range;
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: RETURN;
1389: END IF;

Line 1419: FND_MSG_PUB.add;

1415: -- Fix for bug# 3482307.
1416: l_interval_rec.start_value <= l_prev_stop_value ) THEN
1417: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );
1418: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1419: FND_MSG_PUB.add;
1420: CLOSE get_recs_for_value_range;
1421: x_return_status := FND_API.G_RET_STS_ERROR;
1422: RETURN;
1423: END IF;

Line 1431: FND_MSG_PUB.add;

1427: l_interval_rec.counter_id = l_prev_counter_id AND
1428: l_interval_rec.earliest_due_value <= l_prev_stop_value ) THEN
1429: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );
1430: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1431: FND_MSG_PUB.add;
1432: CLOSE get_recs_for_value_range;
1433: x_return_status := FND_API.G_RET_STS_ERROR;
1434: RETURN;
1435: END IF;

Line 1453: FND_MSG_PUB.add;

1449: EXIT WHEN check_unique_reset_value%NOTFOUND;
1450:
1451: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_VALUE_NONUNIQUE' );
1452: FND_MESSAGE.set_token( 'FIELD', l_counter_name );
1453: FND_MSG_PUB.add;
1454: END LOOP;
1455:
1456: IF ( check_unique_reset_value%ROWCOUNT > 0 ) THEN
1457: CLOSE check_unique_reset_value;

Line 1575: FND_MSG_PUB.add;

1571: -- Check if the Threshold date is not set for repeating MRs.
1572: IF ( p_x_threshold_rec.threshold_date IS NOT NULL AND
1573: p_repetitive_flag = 'Y' ) THEN
1574: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_THRESHOLD' );
1575: FND_MSG_PUB.add;
1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: RETURN;
1578: END IF;
1579:

Line 1585: FND_MSG_PUB.add;

1581: IF ( p_x_threshold_rec.threshold_date IS NOT NULL AND
1582: p_appln_code= 'PM' AND
1583: p_mr_type_code = 'PROGRAM' ) THEN
1584: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_THRESHOLD' );
1585: FND_MSG_PUB.add;
1586: x_return_status := FND_API.G_RET_STS_ERROR;
1587: RETURN;
1588: END IF;
1589:

Line 1595: FND_MSG_PUB.add;

1591: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1592: p_appln_code = 'PM' AND
1593: p_mr_type_code = 'ACTIVITY' ) THEN
1594: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ACT_PGM_DURATION' );
1595: FND_MSG_PUB.add;
1596: x_return_status := FND_API.G_RET_STS_ERROR;
1597: RETURN;
1598: END IF;
1599:

Line 1604: FND_MSG_PUB.add;

1600: -- Check if the Program Duration is a positive number.
1601: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1602: p_x_threshold_rec.program_duration <= 0 ) THEN
1603: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_INVALID' );
1604: FND_MSG_PUB.add;
1605: x_return_status := FND_API.G_RET_STS_ERROR;
1606: RETURN;
1607: END IF;
1608:

Line 1613: FND_MSG_PUB.add;

1609: -- Check if the Program Duration is specified then the UOM should be specified.
1610: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1611: p_x_threshold_rec.program_duration_uom_code IS NULL ) THEN
1612: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_UOM_NULL' );
1613: FND_MSG_PUB.add;
1614: x_return_status := FND_API.G_RET_STS_ERROR;
1615: RETURN;
1616: END IF;
1617:

Line 1632: FND_MSG_PUB.add;

1628: );
1629:
1630: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1631: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_INV_PGM_DUR_UOM' );
1632: FND_MSG_PUB.add;
1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: RETURN;
1635: END IF;
1636: END IF;

Line 1643: FND_MSG_PUB.ADD;

1639:
1640: IF G_APPLN_USAGE IS NULL
1641: THEN
1642: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
1643: FND_MSG_PUB.ADD;
1644: x_return_status := FND_API.G_RET_STS_ERROR;
1645: IF G_DEBUG = 'Y' THEN
1646: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
1647: END IF;

Line 1697: FND_MSG_PUB.add;

1693: p_eff_obj_version => p_x_threshold_rec.OBJECT_VERSION_NUMBER
1694: );
1695: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1696: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );
1697: FND_MSG_PUB.add;
1698: x_return_status := FND_API.G_RET_STS_ERROR;
1699: RETURN;
1700: END IF;
1701: END IF;

Line 1716: FND_MSG_PUB.add;

1712: p_eff_obj_version => p_x_threshold_rec.OBJECT_VERSION_NUMBER
1713: );
1714: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1715: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );
1716: FND_MSG_PUB.add;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718: RETURN;
1719: END IF;
1720: END IF;

Line 1738: FND_MSG_PUB.add;

1734:
1735: -- If the record does not exist, then, abort API.
1736: IF ( SQL%ROWCOUNT = 0 ) THEN
1737: FND_MESSAGE.set_name('AHL','AHL_FMP_EFF_RECORD_CHANGED');
1738: FND_MSG_PUB.add;
1739: x_return_status := FND_API.G_RET_STS_ERROR;
1740: RETURN;
1741: END IF;
1742:

Line 1792: FND_MSG_PUB.initialize;

1788: END IF;
1789:
1790: -- Initialize message list if p_init_msg_list is set to TRUE.
1791: IF FND_API.to_boolean( p_init_msg_list ) THEN
1792: FND_MSG_PUB.initialize;
1793: END IF;
1794:
1795: -- Enable Debug (optional)
1796: IF ( G_DEBUG = 'Y' ) THEN

Line 1999: l_msg_count := FND_MSG_PUB.count_msg;

1995: END LOOP;
1996: --pdoki added for ADAT ER end.
1997:
1998: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1999: l_msg_count := FND_MSG_PUB.count_msg;
2000: IF l_msg_count > 0 THEN
2001: x_msg_count := l_msg_count;
2002: RAISE FND_API.G_EXC_ERROR;
2003: END IF;

Line 2131: FND_MSG_PUB.add;

2127: -- If the record does not exist, then, abort API.
2128: IF ( SQL%ROWCOUNT = 0 ) THEN
2129: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2130: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_tbl(i) ) );
2131: FND_MSG_PUB.add;
2132: RAISE FND_API.G_EXC_ERROR;
2133: END IF;
2134:
2135: -- Set OUT values

Line 2149: FND_MSG_PUB.add;

2145: -- If the record does not exist, then, abort API.
2146: IF ( SQL%ROWCOUNT = 0 ) THEN
2147: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2148: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2149: FND_MSG_PUB.add;
2150: RAISE FND_API.G_EXC_ERROR;
2151: END IF;
2152:
2153: END IF;

Line 2190: FND_MSG_PUB.ADD;

2186: -- Add informational message if any truncation of interval values occured.
2187: -- Fix for bug#3482307
2188: IF (l_fractional_trunc_flag) THEN
2189: FND_MESSAGE.Set_Name('AHL','AHL_FMP_FRACTION_TRUNC');
2190: FND_MSG_PUB.ADD;
2191: END IF;
2192:
2193: -- Count and Get messages (optional)
2194: FND_MSG_PUB.count_and_get

Line 2194: FND_MSG_PUB.count_and_get

2190: FND_MSG_PUB.ADD;
2191: END IF;
2192:
2193: -- Count and Get messages (optional)
2194: FND_MSG_PUB.count_and_get
2195: (
2196: p_encoded => FND_API.G_FALSE,
2197: p_count => x_msg_count,
2198: p_data => x_msg_data

Line 2211: FND_MSG_PUB.count_and_get

2207:
2208: WHEN FND_API.G_EXC_ERROR THEN
2209: ROLLBACK TO process_interval_PVT;
2210: x_return_status := FND_API.G_RET_STS_ERROR ;
2211: FND_MSG_PUB.count_and_get
2212: (
2213: p_encoded => FND_API.G_FALSE,
2214: p_count => x_msg_count,
2215: p_data => x_msg_data

Line 2226: FND_MSG_PUB.count_and_get

2222:
2223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2224: ROLLBACK TO process_interval_PVT;
2225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2226: FND_MSG_PUB.count_and_get
2227: (
2228: p_encoded => FND_API.G_FALSE,
2229: p_count => x_msg_count,
2230: p_data => x_msg_data

Line 2241: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

2237:
2238: WHEN OTHERS THEN
2239: ROLLBACK TO process_interval_PVT;
2240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2241: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2242: THEN
2243: FND_MSG_PUB.add_exc_msg
2244: (
2245: p_pkg_name => G_PKG_NAME,

Line 2243: FND_MSG_PUB.add_exc_msg

2239: ROLLBACK TO process_interval_PVT;
2240: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2241: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2242: THEN
2243: FND_MSG_PUB.add_exc_msg
2244: (
2245: p_pkg_name => G_PKG_NAME,
2246: p_procedure_name => G_API_NAME,
2247: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 2250: FND_MSG_PUB.count_and_get

2246: p_procedure_name => G_API_NAME,
2247: p_error_text => SUBSTRB(SQLERRM,1,240)
2248: );
2249: END IF;
2250: FND_MSG_PUB.count_and_get
2251: (
2252: p_encoded => FND_API.G_FALSE,
2253: p_count => x_msg_count,
2254: p_data => x_msg_data