APPS.AHL_FMP_MR_INTERVAL_PVT dependencies on FND_MESSAGE

Line 139: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );

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

Line 149: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

145: -- Check Profile value
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

Line 168: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );

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

Line 194: FND_MESSAGE.set_name( 'AHL', l_msg_data );

190: );
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;

Line 204: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );

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

Line 220: FND_MESSAGE.set_name( 'AHL', l_msg_data );

216: p_object_version_number => p_threshold_rec.object_version_number
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;

Line 234: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );

230: ( p_threshold_rec.threshold_date IS NULL OR
231: p_threshold_rec.threshold_date = FND_API.G_MISS_DATE ) AND
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;

Line 235: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );

231: p_threshold_rec.threshold_date = FND_API.G_MISS_DATE ) AND
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;

Line 246: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );

242: FOR i IN 1..p_interval_tbl.count LOOP
243: IF ( p_interval_tbl(i).dml_operation <> 'D' AND
244: p_interval_tbl(i).dml_operation <> 'U' AND
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;

Line 247: FND_MESSAGE.set_token( 'FIELD', p_interval_tbl(i).dml_operation );

243: IF ( p_interval_tbl(i).dml_operation <> 'D' AND
244: p_interval_tbl(i).dml_operation <> 'U' AND
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;

Line 248: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_tbl(i) ) );

244: p_interval_tbl(i).dml_operation <> 'U' AND
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;

Line 259: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_DML' );

255: IF ( l_pm_install_flag = 'Y' AND
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;

Line 279: FND_MESSAGE.set_name( 'AHL', l_msg_data );

275: p_effectivity_id => p_threshold_rec.MR_EFFECTIVITY_ID,
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;

Line 301: FND_MESSAGE.set_name( 'AHL', l_msg_data );

297: p_effectivity_id => p_threshold_rec.MR_EFFECTIVITY_ID,
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;

Line 316: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_OBJ_VERSION_NULL' );

312: p_threshold_rec.program_duration <> FND_API.G_MISS_NUM AND
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;

Line 400: FND_MESSAGE.set_name( 'AHL', l_msg_data );

396: p_x_counter_id => p_x_interval_rec.counter_id
397: );
398:
399: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
400: FND_MESSAGE.set_name( 'AHL', l_msg_data );
401:
402: IF ( l_msg_data = 'AHL_FMP_INVALID_COUNTER' OR
403: l_msg_data = 'AHL_FMP_TOO_MANY_COUNTERS' ) THEN
404: IF ( p_x_interval_rec.counter_name IS NULL OR

Line 406: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_interval_rec.counter_id ));

402: IF ( l_msg_data = 'AHL_FMP_INVALID_COUNTER' OR
403: l_msg_data = 'AHL_FMP_TOO_MANY_COUNTERS' ) THEN
404: IF ( p_x_interval_rec.counter_name IS NULL OR
405: p_x_interval_rec.counter_name = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_interval_rec.counter_id ));
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_interval_rec.counter_name );
409: END IF;
410: ELSE

Line 408: FND_MESSAGE.set_token( 'FIELD', p_x_interval_rec.counter_name );

404: IF ( p_x_interval_rec.counter_name IS NULL OR
405: p_x_interval_rec.counter_name = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_interval_rec.counter_id ));
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_interval_rec.counter_name );
409: END IF;
410: ELSE
411: IF ( p_x_interval_rec.counter_name IS NULL OR
412: p_x_interval_rec.counter_name = FND_API.G_MISS_CHAR ) THEN

Line 413: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_interval_rec.counter_id ) );

409: END IF;
410: ELSE
411: IF ( p_x_interval_rec.counter_name IS NULL OR
412: p_x_interval_rec.counter_name = FND_API.G_MISS_CHAR ) THEN
413: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_interval_rec.counter_id ) );
414: ELSE
415: FND_MESSAGE.set_token( 'FIELD1', p_x_interval_rec.counter_name );
416: END IF;
417:

Line 415: FND_MESSAGE.set_token( 'FIELD1', p_x_interval_rec.counter_name );

411: IF ( p_x_interval_rec.counter_name IS NULL OR
412: p_x_interval_rec.counter_name = FND_API.G_MISS_CHAR ) THEN
413: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_interval_rec.counter_id ) );
414: ELSE
415: FND_MESSAGE.set_token( 'FIELD1', p_x_interval_rec.counter_name );
416: END IF;
417:
418: IF ( l_position_ref_meaning IS NOT NULL ) THEN
419: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );

Line 419: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );

415: FND_MESSAGE.set_token( 'FIELD1', p_x_interval_rec.counter_name );
416: END IF;
417:
418: IF ( l_position_ref_meaning IS NOT NULL ) THEN
419: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );
420: ELSE
421: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
422: END IF;
423: END IF;

Line 421: FND_MESSAGE.set_token( 'FIELD2', l_item_number );

417:
418: IF ( l_position_ref_meaning IS NOT NULL ) THEN
419: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );
420: ELSE
421: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
422: END IF;
423: END IF;
424:
425: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );

Line 425: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );

421: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
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;

Line 696: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_INTERVAL_REC' );

692: l_old_interval_rec.attribute14,
693: l_old_interval_rec.attribute15;
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;

Line 697: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_rec ) );

693: l_old_interval_rec.attribute15;
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;

Line 881: FND_MESSAGE.set_name( 'AHL','AHL_FMP_COUNTER_NULL' );

877: p_interval_rec.counter_id IS NULL AND
878: p_interval_rec.counter_name IS NULL ) OR
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;

Line 882: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

878: p_interval_rec.counter_name IS NULL ) OR
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:

Line 890: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL' );

886:
887: -- Check if the Interval Value does not contain an invalid value
888: IF ( p_interval_rec.interval_value IS NOT NULL AND
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;

Line 891: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.interval_value ) );

887: -- Check if the Interval Value does not contain an invalid value
888: IF ( p_interval_rec.interval_value IS NOT NULL AND
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:

Line 892: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

888: IF ( p_interval_rec.interval_value IS NOT NULL AND
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.

Line 901: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EARL_DUE' );

897: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
898: IF ( p_interval_rec.earliest_due_value IS NOT NULL AND
899: p_interval_rec.earliest_due_value <> FND_API.G_MISS_NUM AND
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;

Line 902: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.earliest_due_value ) );

898: IF ( p_interval_rec.earliest_due_value IS NOT NULL AND
899: p_interval_rec.earliest_due_value <> FND_API.G_MISS_NUM AND
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;

Line 903: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

899: p_interval_rec.earliest_due_value <> FND_API.G_MISS_NUM AND
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:

Line 913: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_START' );

909: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
910: IF ( p_interval_rec.start_value IS NOT NULL AND
911: p_interval_rec.start_value <> FND_API.G_MISS_NUM AND
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;

Line 914: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.start_value ) );

910: IF ( p_interval_rec.start_value IS NOT NULL AND
911: p_interval_rec.start_value <> FND_API.G_MISS_NUM AND
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;

Line 915: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

911: p_interval_rec.start_value <> FND_API.G_MISS_NUM AND
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:

Line 925: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_STOP' );

921: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
922: IF ( p_interval_rec.stop_value IS NOT NULL AND
923: p_interval_rec.stop_value <> FND_API.G_MISS_NUM AND
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;

Line 926: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.stop_value ) );

922: IF ( p_interval_rec.stop_value IS NOT NULL AND
923: p_interval_rec.stop_value <> FND_API.G_MISS_NUM AND
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;

Line 927: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

923: p_interval_rec.stop_value <> FND_API.G_MISS_NUM AND
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:

Line 937: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_BF' );

933: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
934: IF ( p_interval_rec.tolerance_before IS NOT NULL AND
935: p_interval_rec.tolerance_before <> FND_API.G_MISS_NUM AND
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;

Line 938: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_before ) );

934: IF ( p_interval_rec.tolerance_before IS NOT NULL AND
935: p_interval_rec.tolerance_before <> FND_API.G_MISS_NUM AND
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;

Line 939: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

935: p_interval_rec.tolerance_before <> FND_API.G_MISS_NUM AND
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:

Line 949: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOLERANCE_AF' );

945: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
946: IF ( p_interval_rec.tolerance_after IS NOT NULL AND
947: p_interval_rec.tolerance_after <> FND_API.G_MISS_NUM AND
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;

Line 950: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.tolerance_after ) );

946: IF ( p_interval_rec.tolerance_after IS NOT NULL AND
947: p_interval_rec.tolerance_after <> FND_API.G_MISS_NUM AND
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;

Line 951: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

947: p_interval_rec.tolerance_after <> FND_API.G_MISS_NUM AND
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:

Line 961: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_RESET_VALUE' );

957: IF ( p_interval_rec.dml_operation <> 'D' ) THEN
958: IF ( p_interval_rec.reset_value IS NOT NULL AND
959: p_interval_rec.reset_value <> FND_API.G_MISS_NUM AND
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;

Line 962: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_interval_rec.reset_value ) );

958: IF ( p_interval_rec.reset_value IS NOT NULL AND
959: p_interval_rec.reset_value <> FND_API.G_MISS_NUM AND
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;

Line 963: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

959: p_interval_rec.reset_value <> FND_API.G_MISS_NUM AND
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:

Line 972: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_INTERVAL_ID_NULL' );

968: -- Check if the mandatory Interval ID column contains a null value.
969: IF ( p_interval_rec.dml_operation <> 'C' ) THEN
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;

Line 973: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

969: IF ( p_interval_rec.dml_operation <> 'C' ) THEN
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:

Line 982: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INT_OBJ_VERSION_NULL' );

978: -- Check if the mandatory Object Version Number column contains a null value.
979: IF ( p_interval_rec.dml_operation <> 'C' ) THEN
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;

Line 983: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

979: IF ( p_interval_rec.dml_operation <> 'C' ) THEN
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:

Line 1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_INPUTS' );

1012: p_interval_rec.reset_value IS NOT NULL OR
1013: p_interval_rec.interval_value IS NOT NULL OR
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:

Line 1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1013: p_interval_rec.interval_value IS NOT NULL OR
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

Line 1027: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INTERVAL_NULL' );

1023: p_mr_type_code <> 'PROGRAM' ) AND
1024: ( p_interval_rec.dml_operation = 'C' AND
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:

Line 1028: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1024: ( p_interval_rec.dml_operation = 'C' AND
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

Line 1035: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_START_NULL' );

1031:
1032: -- Check if Start is passed for PM Programs
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;

Line 1036: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1032: -- Check if Start is passed for PM Programs
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:

Line 1044: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_STOP_NULL' );

1040:
1041: -- Check if Stop is passed for PM Programs
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;

Line 1045: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1041: -- Check if Stop is passed for PM Programs
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:

Line 1058: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RANGE_NOTNULL' );

1054: ( p_interval_rec.start_value IS NOT NULL OR
1055: p_interval_rec.stop_value IS NOT NULL OR
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;

Line 1059: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1055: p_interval_rec.stop_value IS NOT NULL OR
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:

Line 1067: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_BF_INT' );

1063:
1064: -- Check if the Tolerance Before is less than the Interval Value
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:

Line 1068: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1064: -- Check if the Tolerance Before is less than the Interval Value
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

Line 1075: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_TOL_AF_INT' );

1071:
1072: -- Check if the Tolerance After is less than the Interval Value
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:

Line 1076: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1072: -- Check if the Tolerance After is less than the Interval Value
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

Line 1091: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_LESS_INIT_VALUE' );

1087: WHERE counter_id = p_interval_rec.counter_id;
1088:
1089: -- Check if the Reset Value is less than the initial reading for the counter
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;

Line 1092: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( l_initial_reading ) );

1088:
1089: -- Check if the Reset Value is less than the initial reading for the counter
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:

Line 1093: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1089: -- Check if the Reset Value is less than the initial reading for the counter
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;

Line 1102: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_VALUE_RANGE' );

1098:
1099: -- Check if the Start Value is passed if Stop Value is passed
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:

Line 1103: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1099: -- Check if the Start Value is passed if Stop Value is passed
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

Line 1111: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );

1107: -- Check if the Start Value is passed if Stop Value is passed
1108: IF ( p_interval_rec.start_value IS NULL AND
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:

Line 1112: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1108: IF ( p_interval_rec.start_value IS NULL AND
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

Line 1119: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MISSING_DATE_RANGE' );

1115:
1116: -- Check if the Start Date is passed if Stop Date is passed
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:

Line 1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1116: -- Check if the Start Date is passed if Stop Date is passed
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

Line 1128: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_VALUE_RANGE' );

1124: -- Check if the Stop Value is not greater than Start Value
1125: IF ( p_interval_rec.start_value IS NOT NULL AND
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:

Line 1129: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1125: IF ( p_interval_rec.start_value IS NOT NULL AND
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

Line 1137: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_DATE_RANGE' );

1133: -- Check if the Stop date is not greater than Start date
1134: IF ( p_interval_rec.start_date IS NOT NULL AND
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:

Line 1138: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1134: IF ( p_interval_rec.start_date IS NOT NULL AND
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

Line 1147: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_DATE_VALUE_RANGE' );

1143: IF ( ( p_interval_rec.start_date IS NOT NULL OR
1144: p_interval_rec.stop_date IS NOT NULL ) AND
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:

Line 1148: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1144: p_interval_rec.stop_date IS NOT NULL ) AND
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

Line 1159: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );

1155: p_interval_rec.interval_value >
1156: --( p_interval_rec.stop_value - p_interval_rec.start_value ) ) THEN
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:

Line 1160: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1156: --( p_interval_rec.stop_value - p_interval_rec.start_value ) ) THEN
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

Line 1167: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_INTERVAL_RANGE' );

1163:
1164: -- Check if the earliest due value is less than Start Value
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:

Line 1168: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_interval_rec ) );

1164: -- Check if the earliest due value is less than Start Value
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;

Line 1277: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_PGM_DUP_INT_REC' );

1273: l_interval_rec.counter_name;
1274:
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:

Line 1278: FND_MESSAGE.set_token( 'FIELD', l_interval_rec.counter_name );

1274:
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

Line 1305: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_INT_REC' );

1301: l_interval_rec.stop_date;
1302:
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:

Line 1306: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );

1302:
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

Line 1339: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_DATE_RANGE' );

1335: l_interval_rec.counter_id = l_prev_counter_id AND
1336: --l_interval_rec.start_date < l_prev_stop_date ) THEN
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;

Line 1340: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );

1336: --l_interval_rec.start_date < l_prev_stop_date ) THEN
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;

Line 1373: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );

1369: l_interval_rec.counter_id = l_prev_counter_id AND
1370: --l_interval_rec.start_value < l_prev_stop_value ) THEN
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;

Line 1374: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );

1370: --l_interval_rec.start_value < l_prev_stop_value ) THEN
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;

Line 1385: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_VALUE_RANGE' );

1381: IF ( l_prev_counter_id IS NOT NULL AND
1382: l_prev_stop_value IS NOT NULL AND
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;

Line 1386: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_interval_rec ) );

1382: l_prev_stop_value IS NOT NULL AND
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;

Line 1407: FND_MESSAGE.set_name( 'AHL','AHL_FMP_RESET_VALUE_NONUNIQUE' );

1403: INTO l_counter_name;
1404:
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:

Line 1408: FND_MESSAGE.set_token( 'FIELD', l_counter_name );

1404:
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

Line 1530: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_THRESHOLD' );

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

Line 1540: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_THRESHOLD' );

1536: -- Check if the Threshold date is not set for PM Programs
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;

Line 1550: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ACT_PGM_DURATION' );

1546: -- Check if the Program Duration is not specified for PM Activities.
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;

Line 1559: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_INVALID' );

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

Line 1568: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_PGM_DUR_UOM_NULL' );

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

Line 1587: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_INV_PGM_DUR_UOM' );

1583: p_x_lookup_code => p_x_threshold_rec.program_duration_uom_code
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;

Line 1598: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');

1594: -- Check Profile value
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' );

Line 1652: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );

1648: p_effectivity_id => p_x_threshold_rec.MR_EFFECTIVITY_ID,
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;

Line 1671: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PROGRAM_DURATION' );

1667: p_effectivity_id => p_x_threshold_rec.MR_EFFECTIVITY_ID,
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;

Line 1693: FND_MESSAGE.set_name('AHL','AHL_FMP_EFF_RECORD_CHANGED');

1689: AND object_version_number = p_x_threshold_rec.object_version_number;
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;

Line 2059: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');

2055: AND object_version_number = p_x_interval_tbl(i).object_version_number;
2056:
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;

Line 2060: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_interval_tbl(i) ) );

2056:
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:

Line 2077: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');

2073: AND object_version_number = p_x_interval_tbl(i).object_version_number;
2074:
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;

Line 2078: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );

2074:
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:

Line 2119: FND_MESSAGE.Set_Name('AHL','AHL_FMP_FRACTION_TRUNC');

2115:
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)