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 698: FND_MSG_PUB.add;

694:
695: IF get_old_rec%NOTFOUND THEN
696: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_INTERVAL_REC' );
697: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );
698: FND_MSG_PUB.add;
699: CLOSE get_old_rec;
700: RAISE FND_API.G_EXC_ERROR;
701: END IF;
702:

Line 883: FND_MSG_PUB.add;

879: ( p_interval_rec.counter_id = FND_API.G_MISS_NUM AND
880: p_interval_rec.counter_name = FND_API.G_MISS_CHAR ) ) THEN
881: FND_MESSAGE.set_name( 'AHL','AHL_FMP_COUNTER_NULL' );
882: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
883: FND_MSG_PUB.add;
884: END IF;
885: END IF;
886:
887: -- Check if the Interval Value does not contain an invalid value

Line 893: FND_MSG_PUB.add;

889: p_interval_rec.interval_value <= 0 ) THEN
890: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL' );
891: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.interval_value ) );
892: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
893: FND_MSG_PUB.add;
894: END IF;
895:
896: -- Check if the earliest due Value does not contain an invalid value.
897: IF ( p_interval_rec.dml_operation <> 'D' ) THEN

Line 904: FND_MSG_PUB.add;

900: p_interval_rec.earliest_due_value < 0 ) THEN
901: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EARL_DUE' );
902: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.earliest_due_value ) );
903: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
904: FND_MSG_PUB.add;
905: END IF;
906: END IF;
907:
908: -- Check if the Start Value does not contain an invalid value.

Line 916: FND_MSG_PUB.add;

912: p_interval_rec.start_value < 0 ) THEN
913: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_START' );
914: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.start_value ) );
915: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
916: FND_MSG_PUB.add;
917: END IF;
918: END IF;
919:
920: -- Check if the Stop Value does not contain an invalid value.

Line 928: FND_MSG_PUB.add;

924: p_interval_rec.stop_value <= 0 ) THEN
925: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_STOP' );
926: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.stop_value ) );
927: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
928: FND_MSG_PUB.add;
929: END IF;
930: END IF;
931:
932: -- Check if the Tolerance Before does not contain an invalid value.

Line 940: FND_MSG_PUB.add;

936: p_interval_rec.tolerance_before < 0 ) THEN
937: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_BF' );
938: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_before ) );
939: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
940: FND_MSG_PUB.add;
941: END IF;
942: END IF;
943:
944: -- Check if the Tolerance After does not contain an invalid value.

Line 952: FND_MSG_PUB.add;

948: p_interval_rec.tolerance_after < 0 ) THEN
949: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_AF' );
950: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_after ) );
951: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
952: FND_MSG_PUB.add;
953: END IF;
954: END IF;
955:
956: -- Check if the Reset After does not contain an invalid value.

Line 964: FND_MSG_PUB.add;

960: p_interval_rec.reset_value < 0 ) THEN
961: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_RESET_VALUE' );
962: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.reset_value ) );
963: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
964: FND_MSG_PUB.add;
965: END IF;
966: END IF;
967:
968: -- Check if the mandatory Interval ID column contains a null value.

Line 974: FND_MSG_PUB.add;

970: IF ( p_interval_rec.mr_interval_id IS NULL OR
971: p_interval_rec.mr_interval_id = FND_API.G_MISS_NUM ) THEN
972: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_INTERVAL_ID_NULL' );
973: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
974: FND_MSG_PUB.add;
975: END IF;
976: END IF;
977:
978: -- Check if the mandatory Object Version Number column contains a null value.

Line 984: FND_MSG_PUB.add;

980: IF ( p_interval_rec.object_version_number IS NULL OR
981: p_interval_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
982: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INT_OBJ_VERSION_NULL' );
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: END validate_attributes;

Line 1018: FND_MSG_PUB.add;

1014: p_interval_rec.start_date IS NOT NULL OR
1015: p_interval_rec.stop_date IS NOT NULL ) ) THEN
1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_INPUTS' );
1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1018: FND_MSG_PUB.add;
1019: END IF;
1020:
1021: -- Check if the Interval Value is always passed for non-PM Programs
1022: IF ( ( p_mr_type_code IS NULL OR

Line 1029: FND_MSG_PUB.add;

1025: p_interval_rec.interval_value IS NULL ) OR
1026: ( p_interval_rec.interval_value = FND_API.G_MISS_NUM ) ) THEN
1027: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INTERVAL_NULL' );
1028: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1029: FND_MSG_PUB.add;
1030: END IF;
1031:
1032: -- Check if Start is passed for PM Programs
1033: IF ( p_mr_type_code = 'PROGRAM' AND

Line 1037: FND_MSG_PUB.add;

1033: IF ( p_mr_type_code = 'PROGRAM' AND
1034: p_interval_rec.start_value IS NULL ) THEN
1035: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_START_NULL' );
1036: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1037: FND_MSG_PUB.add;
1038: RETURN;
1039: END IF;
1040:
1041: -- Check if Stop is passed for PM Programs

Line 1046: FND_MSG_PUB.add;

1042: IF ( p_mr_type_code = 'PROGRAM' AND
1043: p_interval_rec.stop_value IS NULL ) THEN
1044: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_STOP_NULL' );
1045: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1046: FND_MSG_PUB.add;
1047: RETURN;
1048: END IF;
1049:
1050: -- Check if Range is not passed for One Time MRs.

Line 1060: FND_MSG_PUB.add;

1056: p_interval_rec.start_date IS NOT NULL OR
1057: p_interval_rec.stop_date IS NOT NULL ) ) THEN
1058: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RANGE_NOTNULL' );
1059: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1060: FND_MSG_PUB.add;
1061: RETURN;
1062: END IF;
1063:
1064: -- Check if the Tolerance Before is less than the Interval Value

Line 1069: FND_MSG_PUB.add;

1065: IF ( p_interval_rec.tolerance_before IS NOT NULL AND
1066: p_interval_rec.tolerance_before >= p_interval_rec.interval_value ) THEN
1067: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_BF_INT' );
1068: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1069: FND_MSG_PUB.add;
1070: END IF;
1071:
1072: -- Check if the Tolerance After is less than the Interval Value
1073: IF ( p_interval_rec.tolerance_after IS NOT NULL AND

Line 1077: FND_MSG_PUB.add;

1073: IF ( p_interval_rec.tolerance_after IS NOT NULL AND
1074: p_interval_rec.tolerance_after >= p_interval_rec.interval_value ) THEN
1075: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_AF_INT' );
1076: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1077: FND_MSG_PUB.add;
1078: END IF;
1079:
1080: IF ( p_interval_rec.counter_id IS NOT NULL AND
1081: p_interval_rec.reset_value IS NOT NULL AND

Line 1094: FND_MSG_PUB.add;

1090: IF ( p_interval_rec.reset_value < l_initial_reading ) THEN
1091: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_LESS_INIT_VALUE' );
1092: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( l_initial_reading ) );
1093: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1094: FND_MSG_PUB.add;
1095: END IF;
1096:
1097: END IF;
1098:

Line 1104: FND_MSG_PUB.add;

1100: IF ( p_interval_rec.start_value IS NULL AND
1101: p_interval_rec.stop_value IS NOT NULL ) THEN
1102: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_VALUE_RANGE' );
1103: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1104: FND_MSG_PUB.add;
1105: END IF;
1106:
1107: -- Check if the Start Value is passed if Stop Value is passed
1108: IF ( p_interval_rec.start_value IS NULL AND

Line 1113: FND_MSG_PUB.add;

1109: p_interval_rec.start_date IS NULL AND
1110: p_interval_rec.earliest_due_value IS NOT NULL ) THEN
1111: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
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 Start Date is passed if Stop Date is passed
1117: IF ( p_interval_rec.start_date IS NULL AND

Line 1121: FND_MSG_PUB.add;

1117: IF ( p_interval_rec.start_date IS NULL AND
1118: p_interval_rec.stop_date IS NOT NULL ) THEN
1119: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_DATE_RANGE' );
1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1121: FND_MSG_PUB.add;
1122: END IF;
1123:
1124: -- Check if the Stop Value is not greater than Start Value
1125: IF ( p_interval_rec.start_value IS NOT NULL AND

Line 1130: FND_MSG_PUB.add;

1126: p_interval_rec.stop_value IS NOT NULL AND
1127: p_interval_rec.stop_value < p_interval_rec.start_value ) THEN
1128: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_VALUE_RANGE' );
1129: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1130: FND_MSG_PUB.add;
1131: END IF;
1132:
1133: -- Check if the Stop date is not greater than Start date
1134: IF ( p_interval_rec.start_date IS NOT NULL AND

Line 1139: FND_MSG_PUB.add;

1135: p_interval_rec.stop_date IS NOT NULL AND
1136: p_interval_rec.stop_date < p_interval_rec.start_date ) THEN
1137: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_DATE_RANGE' );
1138: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1139: FND_MSG_PUB.add;
1140: END IF;
1141:
1142: -- Check if both Date based and Value based interval ranges are not passed
1143: IF ( ( p_interval_rec.start_date IS NOT NULL OR

Line 1149: FND_MSG_PUB.add;

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

Line 1161: FND_MSG_PUB.add;

1157: -- Fix for bug# 3482307.
1158: ( p_interval_rec.stop_value - p_interval_rec.start_value + 1) ) THEN
1159: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
1160: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1161: FND_MSG_PUB.add;
1162: END IF;
1163:
1164: -- Check if the earliest due value is less than Start Value
1165: IF ( p_interval_rec.start_value IS NOT NULL AND

Line 1169: FND_MSG_PUB.add;

1165: IF ( p_interval_rec.start_value IS NOT NULL AND
1166: p_interval_rec.earliest_due_value > p_interval_rec.start_value ) THEN
1167: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );
1168: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );
1169: FND_MSG_PUB.add;
1170: END IF;
1171:
1172: END validate_record;
1173:

Line 1279: FND_MSG_PUB.add;

1275: EXIT WHEN get_pm_pgm_dup_rec%NOTFOUND;
1276:
1277: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_PGM_DUP_INT_REC' );
1278: FND_MESSAGE.set_token( 'FIELD', l_interval_rec.counter_name );
1279: FND_MSG_PUB.add;
1280: END LOOP;
1281:
1282: IF ( get_pm_pgm_dup_rec%ROWCOUNT > 0 ) THEN
1283: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1307: FND_MSG_PUB.add;

1303: EXIT WHEN get_dup_rec%NOTFOUND;
1304:
1305: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_INT_REC' );
1306: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1307: FND_MSG_PUB.add;
1308: END LOOP;
1309:
1310: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN
1311: CLOSE get_dup_rec;

Line 1341: FND_MSG_PUB.add;

1337: -- Fix for bug# 3482307.
1338: l_interval_rec.start_date <= l_prev_stop_date ) THEN
1339: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_DATE_RANGE' );
1340: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1341: FND_MSG_PUB.add;
1342: CLOSE get_recs_for_date_range;
1343: x_return_status := FND_API.G_RET_STS_ERROR;
1344: RETURN;
1345: END IF;

Line 1375: FND_MSG_PUB.add;

1371: -- Fix for bug# 3482307.
1372: l_interval_rec.start_value <= l_prev_stop_value ) THEN
1373: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );
1374: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1375: FND_MSG_PUB.add;
1376: CLOSE get_recs_for_value_range;
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: RETURN;
1379: END IF;

Line 1387: FND_MSG_PUB.add;

1383: l_interval_rec.counter_id = l_prev_counter_id AND
1384: l_interval_rec.earliest_due_value <= l_prev_stop_value ) THEN
1385: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );
1386: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );
1387: FND_MSG_PUB.add;
1388: CLOSE get_recs_for_value_range;
1389: x_return_status := FND_API.G_RET_STS_ERROR;
1390: RETURN;
1391: END IF;

Line 1409: FND_MSG_PUB.add;

1405: EXIT WHEN check_unique_reset_value%NOTFOUND;
1406:
1407: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_VALUE_NONUNIQUE' );
1408: FND_MESSAGE.set_token( 'FIELD', l_counter_name );
1409: FND_MSG_PUB.add;
1410: END LOOP;
1411:
1412: IF ( check_unique_reset_value%ROWCOUNT > 0 ) THEN
1413: CLOSE check_unique_reset_value;

Line 1531: FND_MSG_PUB.add;

1527: -- Check if the Threshold date is not set for repeating MRs.
1528: IF ( p_x_threshold_rec.threshold_date IS NOT NULL AND
1529: p_repetitive_flag = 'Y' ) THEN
1530: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_THRESHOLD' );
1531: FND_MSG_PUB.add;
1532: x_return_status := FND_API.G_RET_STS_ERROR;
1533: RETURN;
1534: END IF;
1535:

Line 1541: FND_MSG_PUB.add;

1537: IF ( p_x_threshold_rec.threshold_date IS NOT NULL AND
1538: p_appln_code= 'PM' AND
1539: p_mr_type_code = 'PROGRAM' ) THEN
1540: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_THRESHOLD' );
1541: FND_MSG_PUB.add;
1542: x_return_status := FND_API.G_RET_STS_ERROR;
1543: RETURN;
1544: END IF;
1545:

Line 1551: FND_MSG_PUB.add;

1547: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1548: p_appln_code = 'PM' AND
1549: p_mr_type_code = 'ACTIVITY' ) THEN
1550: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ACT_PGM_DURATION' );
1551: FND_MSG_PUB.add;
1552: x_return_status := FND_API.G_RET_STS_ERROR;
1553: RETURN;
1554: END IF;
1555:

Line 1560: FND_MSG_PUB.add;

1556: -- Check if the Program Duration is a positive number.
1557: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1558: p_x_threshold_rec.program_duration <= 0 ) THEN
1559: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_INVALID' );
1560: FND_MSG_PUB.add;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: RETURN;
1563: END IF;
1564:

Line 1569: FND_MSG_PUB.add;

1565: -- Check if the Program Duration is specified then the UOM should be specified.
1566: IF ( p_x_threshold_rec.program_duration IS NOT NULL AND
1567: p_x_threshold_rec.program_duration_uom_code IS NULL ) THEN
1568: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_UOM_NULL' );
1569: FND_MSG_PUB.add;
1570: x_return_status := FND_API.G_RET_STS_ERROR;
1571: RETURN;
1572: END IF;
1573:

Line 1588: FND_MSG_PUB.add;

1584: );
1585:
1586: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1587: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_INV_PGM_DUR_UOM' );
1588: FND_MSG_PUB.add;
1589: x_return_status := FND_API.G_RET_STS_ERROR;
1590: RETURN;
1591: END IF;
1592: END IF;

Line 1599: FND_MSG_PUB.ADD;

1595:
1596: IF G_APPLN_USAGE IS NULL
1597: THEN
1598: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
1599: FND_MSG_PUB.ADD;
1600: x_return_status := FND_API.G_RET_STS_ERROR;
1601: IF G_DEBUG = 'Y' THEN
1602: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
1603: END IF;

Line 1653: FND_MSG_PUB.add;

1649: p_eff_obj_version => p_x_threshold_rec.OBJECT_VERSION_NUMBER
1650: );
1651: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1652: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );
1653: FND_MSG_PUB.add;
1654: x_return_status := FND_API.G_RET_STS_ERROR;
1655: RETURN;
1656: END IF;
1657: END IF;

Line 1672: FND_MSG_PUB.add;

1668: p_eff_obj_version => p_x_threshold_rec.OBJECT_VERSION_NUMBER
1669: );
1670: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1671: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );
1672: FND_MSG_PUB.add;
1673: x_return_status := FND_API.G_RET_STS_ERROR;
1674: RETURN;
1675: END IF;
1676: END IF;

Line 1694: FND_MSG_PUB.add;

1690:
1691: -- If the record does not exist, then, abort API.
1692: IF ( SQL%ROWCOUNT = 0 ) THEN
1693: FND_MESSAGE.set_name('AHL','AHL_FMP_EFF_RECORD_CHANGED');
1694: FND_MSG_PUB.add;
1695: x_return_status := FND_API.G_RET_STS_ERROR;
1696: RETURN;
1697: END IF;
1698:

Line 1748: FND_MSG_PUB.initialize;

1744: END IF;
1745:
1746: -- Initialize message list if p_init_msg_list is set to TRUE.
1747: IF FND_API.to_boolean( p_init_msg_list ) THEN
1748: FND_MSG_PUB.initialize;
1749: END IF;
1750:
1751: -- Enable Debug (optional)
1752: IF ( G_DEBUG = 'Y' ) THEN

Line 1932: l_msg_count := FND_MSG_PUB.count_msg;

1928: AHL_DEBUG_PUB.debug( G_PKG_NAME || '.' || G_API_NAME || ' : after validate_record' );
1929: END IF;
1930:
1931: -- Get all the error messages from the previous steps (if any) and raise the appropriate Exception
1932: l_msg_count := FND_MSG_PUB.count_msg;
1933: IF l_msg_count > 0 THEN
1934: x_msg_count := l_msg_count;
1935: RAISE FND_API.G_EXC_ERROR;
1936: END IF;

Line 2061: FND_MSG_PUB.add;

2057: -- If the record does not exist, then, abort API.
2058: IF ( SQL%ROWCOUNT = 0 ) THEN
2059: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2060: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_tbl(i) ) );
2061: FND_MSG_PUB.add;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064:
2065: -- Set OUT values

Line 2079: FND_MSG_PUB.add;

2075: -- If the record does not exist, then, abort API.
2076: IF ( SQL%ROWCOUNT = 0 ) THEN
2077: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2078: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2079: FND_MSG_PUB.add;
2080: RAISE FND_API.G_EXC_ERROR;
2081: END IF;
2082:
2083: END IF;

Line 2120: FND_MSG_PUB.ADD;

2116: -- Add informational message if any truncation of interval values occured.
2117: -- Fix for bug#3482307
2118: IF (l_fractional_trunc_flag) THEN
2119: FND_MESSAGE.Set_Name('AHL','AHL_FMP_FRACTION_TRUNC');
2120: FND_MSG_PUB.ADD;
2121: END IF;
2122:
2123: -- Count and Get messages (optional)
2124: FND_MSG_PUB.count_and_get

Line 2124: FND_MSG_PUB.count_and_get

2120: FND_MSG_PUB.ADD;
2121: END IF;
2122:
2123: -- Count and Get messages (optional)
2124: FND_MSG_PUB.count_and_get
2125: (
2126: p_encoded => FND_API.G_FALSE,
2127: p_count => x_msg_count,
2128: p_data => x_msg_data

Line 2141: FND_MSG_PUB.count_and_get

2137:
2138: WHEN FND_API.G_EXC_ERROR THEN
2139: ROLLBACK TO process_interval_PVT;
2140: x_return_status := FND_API.G_RET_STS_ERROR ;
2141: FND_MSG_PUB.count_and_get
2142: (
2143: p_encoded => FND_API.G_FALSE,
2144: p_count => x_msg_count,
2145: p_data => x_msg_data

Line 2156: FND_MSG_PUB.count_and_get

2152:
2153: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2154: ROLLBACK TO process_interval_PVT;
2155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2156: FND_MSG_PUB.count_and_get
2157: (
2158: p_encoded => FND_API.G_FALSE,
2159: p_count => x_msg_count,
2160: p_data => x_msg_data

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

2167:
2168: WHEN OTHERS THEN
2169: ROLLBACK TO process_interval_PVT;
2170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2171: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2172: THEN
2173: FND_MSG_PUB.add_exc_msg
2174: (
2175: p_pkg_name => G_PKG_NAME,

Line 2173: FND_MSG_PUB.add_exc_msg

2169: ROLLBACK TO process_interval_PVT;
2170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2171: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
2172: THEN
2173: FND_MSG_PUB.add_exc_msg
2174: (
2175: p_pkg_name => G_PKG_NAME,
2176: p_procedure_name => G_API_NAME,
2177: p_error_text => SUBSTRB(SQLERRM,1,240)

Line 2180: FND_MSG_PUB.count_and_get

2176: p_procedure_name => G_API_NAME,
2177: p_error_text => SUBSTRB(SQLERRM,1,240)
2178: );
2179: END IF;
2180: FND_MSG_PUB.count_and_get
2181: (
2182: p_encoded => FND_API.G_FALSE,
2183: p_count => x_msg_count,
2184: p_data => x_msg_data