APPS.AHL_FMP_EFFECTIVITY_DTL_PVT dependencies on FND_MESSAGE

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

126:
127: -- Check Profile value
128:
129: IF G_APPLN_USAGE IS NULL THEN
130: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
131: FND_MSG_PUB.ADD;
132: RETURN;
133: END IF;
134:

Line 137: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MED_PM_INSTALL' );

133: END IF;
134:
135:
136: IF ( G_APPLN_USAGE = 'PM' ) THEN
137: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_MED_PM_INSTALL' );
138: FND_MSG_PUB.add;
139: x_return_status := FND_API.G_RET_STS_ERROR;
140: RETURN;
141: END IF;

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

143: -- Check if a valid value is passed in p_mr_header_id
144:
145: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
146: p_mr_header_id IS NULL ) THEN
147: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
148: FND_MSG_PUB.add;
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: RETURN;
151: END IF;

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

158: p_mr_header_id => p_mr_header_id
159: );
160:
161: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
162: FND_MESSAGE.set_name( 'AHL', l_msg_data );
163: FND_MSG_PUB.add;
164: x_return_status := l_return_status;
165: RETURN;
166: END IF;

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

167:
168: -- Check if a valid value is passed in p_mr_effectivity_id
169: IF ( p_mr_effectivity_id = FND_API.G_MISS_NUM OR
170: p_mr_effectivity_id IS NULL ) THEN
171: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MRE_ID_NULL' );
172: FND_MSG_PUB.add;
173: x_return_status := FND_API.G_RET_STS_ERROR;
174: RETURN;
175: END IF;

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

182: p_mr_effectivity_id => p_mr_effectivity_id
183: );
184:
185: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
186: FND_MESSAGE.set_name( 'AHL', l_msg_data );
187: FND_MSG_PUB.add;
188: x_return_status := l_return_status;
189: RETURN;
190: END IF;

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

190: END IF;
191:
192: -- Check if atleast one record is passed in p_effectivity_detail_tbl
193: IF ( p_effectivity_detail_tbl.count < 1 AND p_effty_ext_detail_tbl.count < 1 ) THEN
194: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
195: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
196: FND_MSG_PUB.add;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: RETURN;

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

191:
192: -- Check if atleast one record is passed in p_effectivity_detail_tbl
193: IF ( p_effectivity_detail_tbl.count < 1 AND p_effty_ext_detail_tbl.count < 1 ) THEN
194: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
195: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
196: FND_MSG_PUB.add;
197: x_return_status := FND_API.G_RET_STS_ERROR;
198: RETURN;
199: END IF;

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

202: FOR i IN 1..p_effectivity_detail_tbl.count LOOP
203: IF ( p_effectivity_detail_tbl(i).dml_operation <> 'D' AND
204: p_effectivity_detail_tbl(i).dml_operation <> 'U' AND
205: p_effectivity_detail_tbl(i).dml_operation <> 'C' ) THEN
206: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
207: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );
208: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );
209: FND_MSG_PUB.add;
210: x_return_status := FND_API.G_RET_STS_ERROR;

Line 207: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );

203: IF ( p_effectivity_detail_tbl(i).dml_operation <> 'D' AND
204: p_effectivity_detail_tbl(i).dml_operation <> 'U' AND
205: p_effectivity_detail_tbl(i).dml_operation <> 'C' ) THEN
206: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
207: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );
208: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );
209: FND_MSG_PUB.add;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: RETURN;

Line 208: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );

204: p_effectivity_detail_tbl(i).dml_operation <> 'U' AND
205: p_effectivity_detail_tbl(i).dml_operation <> 'C' ) THEN
206: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
207: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_tbl(i).dml_operation );
208: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_tbl(i) ) );
209: FND_MSG_PUB.add;
210: x_return_status := FND_API.G_RET_STS_ERROR;
211: RETURN;
212: END IF;

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

216: FOR i IN 1..p_effty_ext_detail_tbl.count LOOP
217: IF ( p_effty_ext_detail_tbl(i).dml_operation <> 'D' AND
218: p_effty_ext_detail_tbl(i).dml_operation <> 'U' AND
219: p_effty_ext_detail_tbl(i).dml_operation <> 'C' ) THEN
220: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
221: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).dml_operation );
222: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;

Line 221: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).dml_operation );

217: IF ( p_effty_ext_detail_tbl(i).dml_operation <> 'D' AND
218: p_effty_ext_detail_tbl(i).dml_operation <> 'U' AND
219: p_effty_ext_detail_tbl(i).dml_operation <> 'C' ) THEN
220: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
221: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).dml_operation );
222: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: RETURN;

Line 222: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );

218: p_effty_ext_detail_tbl(i).dml_operation <> 'U' AND
219: p_effty_ext_detail_tbl(i).dml_operation <> 'C' ) THEN
220: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
221: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).dml_operation );
222: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
223: FND_MSG_PUB.add;
224: x_return_status := FND_API.G_RET_STS_ERROR;
225: RETURN;
226: END IF;

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

226: END IF;
227: IF ( p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'OWNER' AND
228: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'LOCATION' AND
229: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'CSIEXTATTR' ) THEN
230: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
231: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE );
232: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;

Line 231: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE );

227: IF ( p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'OWNER' AND
228: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'LOCATION' AND
229: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'CSIEXTATTR' ) THEN
230: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
231: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE );
232: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: RETURN;

Line 232: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );

228: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'LOCATION' AND
229: p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE <> 'CSIEXTATTR' ) THEN
230: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_DML_INVALID' );
231: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_tbl(i).EFFECT_EXT_DTL_REC_TYPE );
232: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_tbl(i) ) );
233: FND_MSG_PUB.add;
234: x_return_status := FND_API.G_RET_STS_ERROR;
235: RETURN;
236: END IF;

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

351: p_x_manufacturer_id => p_x_effectivity_detail_rec.manufacturer_id
352: );
353:
354: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
355: FND_MESSAGE.set_name( 'AHL', l_msg_data );
356:
357: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
358: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN
359: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR

Line 361: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));

357: IF ( l_msg_data = 'AHL_FMP_INVALID_MF' OR
358: l_msg_data = 'AHL_FMP_TOO_MANY_MFS' ) THEN
359: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
360: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
361: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
362: ELSE
363: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
364: END IF;
365: ELSE

Line 363: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );

359: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
360: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
361: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
362: ELSE
363: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.manufacturer );
364: END IF;
365: ELSE
366: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
367: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN

Line 368: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));

364: END IF;
365: ELSE
366: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
367: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
368: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
369: ELSE
370: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );
371: END IF;
372:

Line 370: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );

366: IF ( p_x_effectivity_detail_rec.manufacturer IS NULL OR
367: p_x_effectivity_detail_rec.manufacturer = FND_API.G_MISS_CHAR ) THEN
368: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_x_effectivity_detail_rec.manufacturer_id ));
369: ELSE
370: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );
371: END IF;
372:
373: IF ( l_position_ref_meaning IS NOT NULL ) THEN
374: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );

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

370: FND_MESSAGE.set_token( 'FIELD1', p_x_effectivity_detail_rec.manufacturer );
371: END IF;
372:
373: IF ( l_position_ref_meaning IS NOT NULL ) THEN
374: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );
375: ELSE
376: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
377: END IF;
378: END IF;

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

372:
373: IF ( l_position_ref_meaning IS NOT NULL ) THEN
374: FND_MESSAGE.set_token( 'FIELD2', l_position_ref_meaning );
375: ELSE
376: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
377: END IF;
378: END IF;
379:
380: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );

Line 380: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );

376: FND_MESSAGE.set_token( 'FIELD2', l_item_number );
377: END IF;
378: END IF;
379:
380: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
381: FND_MSG_PUB.add;
382: END IF;
383:
384: END IF;

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

399: p_x_country_code => p_x_effectivity_detail_rec.country_code
400: );
401:
402: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
403: FND_MESSAGE.set_name( 'AHL', l_msg_data );
404: IF ( p_x_effectivity_detail_rec.country IS NULL OR
405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
407: ELSE

Line 406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );

402: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
403: FND_MESSAGE.set_name( 'AHL', l_msg_data );
404: IF ( p_x_effectivity_detail_rec.country IS NULL OR
405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );
409: END IF;
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );

Line 408: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );

404: IF ( p_x_effectivity_detail_rec.country IS NULL OR
405: p_x_effectivity_detail_rec.country = FND_API.G_MISS_CHAR ) THEN
406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );
409: END IF;
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
411: FND_MSG_PUB.add;
412: END IF;

Line 410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );

406: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country_code );
407: ELSE
408: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_detail_rec.country );
409: END IF;
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
411: FND_MSG_PUB.add;
412: END IF;
413:
414: END IF;

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

471: p_x_owner_id => p_x_effty_ext_detail_rec.owner_id
472: );
473:
474: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
475: FND_MESSAGE.set_name( 'AHL', l_msg_data );
476:
477: IF ( l_msg_data = 'AHL_FMP_INVALID_OWNER' OR
478: l_msg_data = 'AHL_FMP_INV_TOO_MANY_OWNERS' ) THEN
479: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR

Line 481: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));

477: IF ( l_msg_data = 'AHL_FMP_INVALID_OWNER' OR
478: l_msg_data = 'AHL_FMP_INV_TOO_MANY_OWNERS' ) THEN
479: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
480: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
481: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
482: ELSE
483: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
484: END IF;
485: ELSE

Line 483: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );

479: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
480: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
481: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
482: ELSE
483: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
484: END IF;
485: ELSE
486: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
487: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN

Line 488: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));

484: END IF;
485: ELSE
486: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
487: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
488: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
489: ELSE
490: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
491: END IF;
492: END IF;

Line 490: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );

486: IF ( p_x_effty_ext_detail_rec.owner IS NULL OR
487: p_x_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR ) THEN
488: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effty_ext_detail_rec.owner_id ));
489: ELSE
490: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
491: END IF;
492: END IF;
493:
494: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

Line 494: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

490: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.owner );
491: END IF;
492: END IF;
493:
494: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
495: FND_MSG_PUB.add;
496: END IF;
497: END IF;
498: END IF;

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

514: p_x_location_type_code => p_x_effty_ext_detail_rec.location_type_code
515: );
516:
517: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
518: FND_MESSAGE.set_name( 'AHL', l_msg_data );
519: IF ( p_x_effty_ext_detail_rec.location IS NULL OR
520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );
522: ELSE

Line 521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );

517: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
518: FND_MESSAGE.set_name( 'AHL', l_msg_data );
519: IF ( p_x_effty_ext_detail_rec.location IS NULL OR
520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );
522: ELSE
523: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location );
524: END IF;
525: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

Line 523: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location );

519: IF ( p_x_effty_ext_detail_rec.location IS NULL OR
520: p_x_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR ) THEN
521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );
522: ELSE
523: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location );
524: END IF;
525: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
526: FND_MSG_PUB.add;
527: END IF;

Line 525: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

521: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location_type_code );
522: ELSE
523: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.location );
524: END IF;
525: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
526: FND_MSG_PUB.add;
527: END IF;
528: END IF;
529: END IF;

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

545: p_x_csi_attribute_code => p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE
546: );
547:
548: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
549: FND_MESSAGE.set_name( 'AHL', l_msg_data );
550: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR
551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );
553: ELSE

Line 552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );

548: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
549: FND_MESSAGE.set_name( 'AHL', l_msg_data );
550: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR
551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );
553: ELSE
554: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME );
555: END IF;
556: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

Line 554: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME );

550: IF ( p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR
551: p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR ) THEN
552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );
553: ELSE
554: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME );
555: END IF;
556: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
557: FND_MSG_PUB.add;
558: END IF;

Line 556: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

552: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE );
553: ELSE
554: FND_MESSAGE.set_token( 'FIELD', p_x_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME );
555: END IF;
556: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
557: FND_MSG_PUB.add;
558: END IF;
559: END IF;
560: END IF;

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

886: l_old_effectivity_detail_rec.attribute14,
887: l_old_effectivity_detail_rec.attribute15;
888:
889: IF get_old_rec%NOTFOUND THEN
890: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_EFF_DTL_REC' );
891: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
892: FND_MSG_PUB.add;
893: CLOSE get_old_rec;
894: RAISE FND_API.G_EXC_ERROR;

Line 891: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );

887: l_old_effectivity_detail_rec.attribute15;
888:
889: IF get_old_rec%NOTFOUND THEN
890: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_EFF_DTL_REC' );
891: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_rec ) );
892: FND_MSG_PUB.add;
893: CLOSE get_old_rec;
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;

Line 1118: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_OWN_REC' );

1114: l_old_effty_ext_detail_rec.attribute15;
1115:
1116: IF get_old_rec%NOTFOUND THEN
1117: IF(l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER')THEN
1118: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_OWN_REC' );
1119: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION')THEN
1120: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_LOC_REC' );
1121: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR')THEN
1122: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_ATTR_REC' );

Line 1120: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_LOC_REC' );

1116: IF get_old_rec%NOTFOUND THEN
1117: IF(l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER')THEN
1118: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_OWN_REC' );
1119: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION')THEN
1120: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_LOC_REC' );
1121: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR')THEN
1122: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_ATTR_REC' );
1123: END IF;
1124: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

Line 1122: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_ATTR_REC' );

1118: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_OWN_REC' );
1119: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION')THEN
1120: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_LOC_REC' );
1121: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR')THEN
1122: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_ATTR_REC' );
1123: END IF;
1124: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
1125: FND_MSG_PUB.add;
1126: CLOSE get_old_rec;

Line 1124: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );

1120: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_LOC_REC' );
1121: ELSIF (l_old_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR')THEN
1122: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVEFF_EXT_ATTR_REC' );
1123: END IF;
1124: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_rec ) );
1125: FND_MSG_PUB.add;
1126: CLOSE get_old_rec;
1127: RAISE FND_API.G_EXC_ERROR;
1128: END IF;

Line 1286: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );

1282: IF ( p_effectivity_detail_rec.dml_operation = 'C' ) THEN
1283: -- Check if the Exclude Flag does not contain a null value.
1284: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR
1285: p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1286: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1287: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1288: FND_MSG_PUB.add;
1289: ELSE
1290: -- Check if the Exclude Flag does not contain an invalid value.

Line 1287: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1283: -- Check if the Exclude Flag does not contain a null value.
1284: IF ( p_effectivity_detail_rec.exclude_flag IS NULL OR
1285: p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1286: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1287: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1288: FND_MSG_PUB.add;
1289: ELSE
1290: -- Check if the Exclude Flag does not contain an invalid value.
1291: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND

Line 1293: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );

1289: ELSE
1290: -- Check if the Exclude Flag does not contain an invalid value.
1291: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1292: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1293: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1294: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1295: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1296: FND_MSG_PUB.add;
1297: END IF;

Line 1294: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );

1290: -- Check if the Exclude Flag does not contain an invalid value.
1291: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1292: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1293: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1294: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1295: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1296: FND_MSG_PUB.add;
1297: END IF;
1298: END IF;

Line 1295: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1291: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1292: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1293: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1294: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1295: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1296: FND_MSG_PUB.add;
1297: END IF;
1298: END IF;
1299: RETURN;

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

1301:
1302: IF ( p_effectivity_detail_rec.dml_operation = 'U' ) THEN
1303: -- Check if the Exclude Flag does not contain a null value.
1304: IF ( p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1305: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1306: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1307: FND_MSG_PUB.add;
1308: ELSIF ( p_effectivity_detail_rec.exclude_flag IS NOT NULL ) THEN
1309: -- Check if the Exclude Flag does not contain an invalid value.

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

1302: IF ( p_effectivity_detail_rec.dml_operation = 'U' ) THEN
1303: -- Check if the Exclude Flag does not contain a null value.
1304: IF ( p_effectivity_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1305: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1306: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1307: FND_MSG_PUB.add;
1308: ELSIF ( p_effectivity_detail_rec.exclude_flag IS NOT NULL ) THEN
1309: -- Check if the Exclude Flag does not contain an invalid value.
1310: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND

Line 1312: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );

1308: ELSIF ( p_effectivity_detail_rec.exclude_flag IS NOT NULL ) THEN
1309: -- Check if the Exclude Flag does not contain an invalid value.
1310: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1311: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1312: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1313: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1314: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1315: FND_MSG_PUB.add;
1316: END IF;

Line 1313: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );

1309: -- Check if the Exclude Flag does not contain an invalid value.
1310: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1311: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1312: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1313: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1314: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1315: FND_MSG_PUB.add;
1316: END IF;
1317: END IF;

Line 1314: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1310: IF ( p_effectivity_detail_rec.exclude_flag <> 'Y' AND
1311: p_effectivity_detail_rec.exclude_flag <> 'N' ) THEN
1312: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1313: FND_MESSAGE.set_token( 'FIELD', p_effectivity_detail_rec.exclude_flag );
1314: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1315: FND_MSG_PUB.add;
1316: END IF;
1317: END IF;
1318: END IF;

Line 1323: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_DTL_ID_NULL' );

1319:
1320: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1321: IF ( p_effectivity_detail_rec.mr_effectivity_detail_id IS NULL OR
1322: p_effectivity_detail_rec.mr_effectivity_detail_id = FND_API.G_MISS_NUM ) THEN
1323: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_DTL_ID_NULL' );
1324: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1325: FND_MSG_PUB.add;
1326: END IF;
1327:

Line 1324: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1320: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1321: IF ( p_effectivity_detail_rec.mr_effectivity_detail_id IS NULL OR
1322: p_effectivity_detail_rec.mr_effectivity_detail_id = FND_API.G_MISS_NUM ) THEN
1323: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_DTL_ID_NULL' );
1324: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1325: FND_MSG_PUB.add;
1326: END IF;
1327:
1328: -- Check if the mandatory Object Version Number column contains a null value.

Line 1331: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_OBJ_VERSION_NULL' );

1327:
1328: -- Check if the mandatory Object Version Number column contains a null value.
1329: IF ( p_effectivity_detail_rec.object_version_number IS NULL OR
1330: p_effectivity_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1331: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_OBJ_VERSION_NULL' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1333: FND_MSG_PUB.add;
1334: END IF;
1335:

Line 1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1328: -- Check if the mandatory Object Version Number column contains a null value.
1329: IF ( p_effectivity_detail_rec.object_version_number IS NULL OR
1330: p_effectivity_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1331: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_OBJ_VERSION_NULL' );
1332: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1333: FND_MSG_PUB.add;
1334: END IF;
1335:
1336: END validate_attributes;

Line 1353: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );

1349: IF ( p_effty_ext_detail_rec.dml_operation = 'C' ) THEN
1350: -- Check if the Exclude Flag does not contain a null value.
1351: IF ( p_effty_ext_detail_rec.exclude_flag IS NULL OR
1352: p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1353: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1354: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1355: FND_MSG_PUB.add;
1356: ELSE
1357: -- Check if the Exclude Flag does not contain an invalid value.

Line 1354: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1350: -- Check if the Exclude Flag does not contain a null value.
1351: IF ( p_effty_ext_detail_rec.exclude_flag IS NULL OR
1352: p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1353: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1354: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1355: FND_MSG_PUB.add;
1356: ELSE
1357: -- Check if the Exclude Flag does not contain an invalid value.
1358: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND

Line 1360: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );

1356: ELSE
1357: -- Check if the Exclude Flag does not contain an invalid value.
1358: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1359: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1360: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1361: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1362: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1363: FND_MSG_PUB.add;
1364: END IF;

Line 1361: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );

1357: -- Check if the Exclude Flag does not contain an invalid value.
1358: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1359: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1360: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1361: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1362: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1363: FND_MSG_PUB.add;
1364: END IF;
1365: END IF;

Line 1362: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1358: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1359: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1360: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1361: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1362: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1363: FND_MSG_PUB.add;
1364: END IF;
1365: END IF;
1366: RETURN;

Line 1372: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );

1368:
1369: IF ( p_effty_ext_detail_rec.dml_operation = 'U' ) THEN
1370: -- Check if the Exclude Flag does not contain a null value.
1371: IF ( p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1372: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1373: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1374: FND_MSG_PUB.add;
1375: ELSIF ( p_effty_ext_detail_rec.exclude_flag IS NOT NULL ) THEN
1376: -- Check if the Exclude Flag does not contain an invalid value.

Line 1373: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1369: IF ( p_effty_ext_detail_rec.dml_operation = 'U' ) THEN
1370: -- Check if the Exclude Flag does not contain a null value.
1371: IF ( p_effty_ext_detail_rec.exclude_flag = FND_API.G_MISS_CHAR ) THEN
1372: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EX_FLAG_NULL' );
1373: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1374: FND_MSG_PUB.add;
1375: ELSIF ( p_effty_ext_detail_rec.exclude_flag IS NOT NULL ) THEN
1376: -- Check if the Exclude Flag does not contain an invalid value.
1377: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND

Line 1379: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );

1375: ELSIF ( p_effty_ext_detail_rec.exclude_flag IS NOT NULL ) THEN
1376: -- Check if the Exclude Flag does not contain an invalid value.
1377: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1378: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1379: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1380: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1381: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1382: FND_MSG_PUB.add;
1383: END IF;

Line 1380: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );

1376: -- Check if the Exclude Flag does not contain an invalid value.
1377: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1378: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1379: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1380: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1381: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1382: FND_MSG_PUB.add;
1383: END IF;
1384: END IF;

Line 1381: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1377: IF ( p_effty_ext_detail_rec.exclude_flag <> 'Y' AND
1378: p_effty_ext_detail_rec.exclude_flag <> 'N' ) THEN
1379: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_EX_FLAG' );
1380: FND_MESSAGE.set_token( 'FIELD', p_effty_ext_detail_rec.exclude_flag );
1381: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1382: FND_MSG_PUB.add;
1383: END IF;
1384: END IF;
1385: END IF;

Line 1390: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_EXT_DTL_ID_NULL' );

1386:
1387: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1388: IF ( p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID IS NULL OR
1389: p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID = FND_API.G_MISS_NUM ) THEN
1390: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_EXT_DTL_ID_NULL' );
1391: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1392: FND_MSG_PUB.add;
1393: END IF;
1394:

Line 1391: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1387: -- Check if the mandatory Effectivity Detail ID column contains a null value.
1388: IF ( p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID IS NULL OR
1389: p_effty_ext_detail_rec.MR_EFFECTIVITY_EXT_DTL_ID = FND_API.G_MISS_NUM ) THEN
1390: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MR_EFF_EXT_DTL_ID_NULL' );
1391: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1392: FND_MSG_PUB.add;
1393: END IF;
1394:
1395: -- Check if the mandatory Object Version Number column contains a null value.

Line 1398: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_EXT_OBJ_VER_NULL' );

1394:
1395: -- Check if the mandatory Object Version Number column contains a null value.
1396: IF ( p_effty_ext_detail_rec.object_version_number IS NULL OR
1397: p_effty_ext_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1398: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_EXT_OBJ_VER_NULL' );
1399: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1400: FND_MSG_PUB.add;
1401: END IF;
1402:

Line 1399: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );

1395: -- Check if the mandatory Object Version Number column contains a null value.
1396: IF ( p_effty_ext_detail_rec.object_version_number IS NULL OR
1397: p_effty_ext_detail_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1398: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MED_EXT_OBJ_VER_NULL' );
1399: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_effty_ext_detail_rec ) );
1400: FND_MSG_PUB.add;
1401: END IF;
1402:
1403: END validate_ext_attributes;

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

1428: p_serial_number_to => p_effectivity_detail_rec.serial_number_to
1429: );
1430:
1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1432: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1436: FND_MSG_PUB.add;

Line 1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );

1429: );
1430:
1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1432: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1436: FND_MSG_PUB.add;
1437: END IF;

Line 1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );

1430:
1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1432: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1436: FND_MSG_PUB.add;
1437: END IF;
1438: END IF;

Line 1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1431: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1432: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1433: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.serial_number_from );
1434: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.serial_number_to );
1435: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1436: FND_MSG_PUB.add;
1437: END IF;
1438: END IF;
1439:

Line 1445: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_MFG_DT_RANGE' );

1441: IF ( p_effectivity_detail_rec.manufacture_date_from IS NOT NULL AND
1442: p_effectivity_detail_rec.manufacture_date_to IS NOT NULL ) THEN
1443: IF ( p_effectivity_detail_rec.manufacture_date_from >
1444: p_effectivity_detail_rec.manufacture_date_to ) THEN
1445: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_MFG_DT_RANGE' );
1446: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.manufacture_date_from );
1447: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.manufacture_date_to );
1448: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1449: FND_MSG_PUB.add;

Line 1446: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.manufacture_date_from );

1442: p_effectivity_detail_rec.manufacture_date_to IS NOT NULL ) THEN
1443: IF ( p_effectivity_detail_rec.manufacture_date_from >
1444: p_effectivity_detail_rec.manufacture_date_to ) THEN
1445: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_MFG_DT_RANGE' );
1446: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.manufacture_date_from );
1447: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.manufacture_date_to );
1448: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1449: FND_MSG_PUB.add;
1450: END IF;

Line 1447: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.manufacture_date_to );

1443: IF ( p_effectivity_detail_rec.manufacture_date_from >
1444: p_effectivity_detail_rec.manufacture_date_to ) THEN
1445: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_MFG_DT_RANGE' );
1446: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.manufacture_date_from );
1447: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.manufacture_date_to );
1448: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1449: FND_MSG_PUB.add;
1450: END IF;
1451: END IF;

Line 1448: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );

1444: p_effectivity_detail_rec.manufacture_date_to ) THEN
1445: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_MFG_DT_RANGE' );
1446: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_detail_rec.manufacture_date_from );
1447: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_detail_rec.manufacture_date_to );
1448: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_detail_rec ) );
1449: FND_MSG_PUB.add;
1450: END IF;
1451: END IF;
1452:

Line 1462: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ONE_VALUE_REQD' );

1458: p_effectivity_detail_rec.manufacture_date_from IS NULL AND
1459: p_effectivity_detail_rec.manufacture_date_to IS NULL AND
1460: p_effectivity_detail_rec.country IS NULL AND
1461: p_effectivity_detail_rec.country_code IS NULL ) THEN
1462: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ONE_VALUE_REQD' );
1463: FND_MSG_PUB.add;
1464: END IF;
1465:
1466: END validate_record;

Line 1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );

1481:
1482: IF ( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'OWNER' )THEN
1483: IF ( (p_effty_ext_detail_rec.owner IS NULL OR p_effty_ext_detail_rec.owner = FND_API.G_MISS_CHAR) AND
1484: (p_effty_ext_detail_rec.owner_id IS NULL OR p_effty_ext_detail_rec.owner_id = FND_API.G_MISS_NUM )) THEN
1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );

Line 1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );

1485: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_NLL' );
1486: FND_MSG_PUB.add;
1487: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1488: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );

Line 1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );

1489: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1490: FND_MSG_PUB.add;
1491: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1492: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1493: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_OWNER_REC' );
1494: FND_MSG_PUB.add;
1495: END IF;
1496: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND

Line 1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );

1495: END IF;
1496: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'LOCATION' ) THEN
1497: IF((p_effty_ext_detail_rec.location IS NULL OR p_effty_ext_detail_rec.location = FND_API.G_MISS_CHAR) AND
1498: (p_effty_ext_detail_rec.location_type_code IS NULL OR p_effty_ext_detail_rec.location_type_code = FND_API.G_MISS_CHAR )) THEN
1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );

Line 1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );

1499: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_NLL' );
1500: FND_MSG_PUB.add;
1501: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1502: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );

Line 1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );

1503: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1504: FND_MSG_PUB.add;
1505: ELSIF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME <> FND_API.G_MISS_CHAR) AND
1506: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NOT NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE <> FND_API.G_MISS_CHAR ))THEN
1507: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_LOC_REC' );
1508: FND_MSG_PUB.add;
1509: END IF;
1510: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND

Line 1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );

1509: END IF;
1510: ELSIF( p_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE = 'CSIEXTATTR' ) THEN
1511: IF((p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME = FND_API.G_MISS_CHAR) AND
1512: (p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE IS NULL OR p_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_CODE = FND_API.G_MISS_CHAR ))THEN
1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );

Line 1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );

1513: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_NLL' );
1514: FND_MSG_PUB.add;
1515: ELSIF ( (p_effty_ext_detail_rec.owner IS NOT NULL OR p_effty_ext_detail_rec.owner <> FND_API.G_MISS_CHAR) AND
1516: (p_effty_ext_detail_rec.owner_id IS NOT NULL OR p_effty_ext_detail_rec.owner_id <> FND_API.G_MISS_NUM )) THEN
1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1521: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );

Line 1521: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );

1517: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1518: FND_MSG_PUB.add;
1519: ELSIF((p_effty_ext_detail_rec.location IS NOT NULL OR p_effty_ext_detail_rec.location <> FND_API.G_MISS_CHAR) AND
1520: (p_effty_ext_detail_rec.location_type_code IS NOT NULL OR p_effty_ext_detail_rec.location_type_code <> FND_API.G_MISS_CHAR )) THEN
1521: FND_MESSAGE.set_name( 'AHL','AHL_FMP_INVALID_CSIATTR_REC' );
1522: FND_MSG_PUB.add;
1523: END IF;
1524: END IF;
1525:

Line 1620: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_MED_REC' );

1616: l_effectivity_detail_rec.country;
1617:
1618: EXIT WHEN get_dup_rec%NOTFOUND;
1619:
1620: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_MED_REC' );
1621: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_effectivity_detail_rec ) );
1622: FND_MSG_PUB.add;
1623: END LOOP;
1624:

Line 1621: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_effectivity_detail_rec ) );

1617:
1618: EXIT WHEN get_dup_rec%NOTFOUND;
1619:
1620: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUPLICATE_MED_REC' );
1621: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_effectivity_detail_rec ) );
1622: FND_MSG_PUB.add;
1623: END LOOP;
1624:
1625: IF ( get_dup_rec%ROWCOUNT > 0 ) THEN

Line 1644: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_OWNER_REC' );

1640: l_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE;
1641:
1642: EXIT WHEN get_dup_owner_rec%NOTFOUND;
1643:
1644: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_OWNER_REC' );
1645: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1646: FND_MSG_PUB.add;
1647: END LOOP;
1648:

Line 1645: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );

1641:
1642: EXIT WHEN get_dup_owner_rec%NOTFOUND;
1643:
1644: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_OWNER_REC' );
1645: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1646: FND_MSG_PUB.add;
1647: END LOOP;
1648:
1649: IF ( get_dup_owner_rec%ROWCOUNT > 0 ) THEN

Line 1668: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_LOC_REC' );

1664: l_effty_ext_detail_rec.EFFECT_EXT_DTL_REC_TYPE;
1665:
1666: EXIT WHEN get_dup_location_rec%NOTFOUND;
1667:
1668: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_LOC_REC' );
1669: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1670: FND_MSG_PUB.add;
1671: END LOOP;
1672:

Line 1669: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );

1665:
1666: EXIT WHEN get_dup_location_rec%NOTFOUND;
1667:
1668: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_LOC_REC' );
1669: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1670: FND_MSG_PUB.add;
1671: END LOOP;
1672:
1673: IF ( get_dup_location_rec%ROWCOUNT > 0 ) THEN

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

1689: ,l_effty_ext_detail_rec.CSI_EXT_ATTRIBUTE_NAME;
1690:
1691: EXIT WHEN get_dup_csi_attrib_rec%NOTFOUND;
1692:
1693: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_ATTRIB_REC' );
1694: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1695: FND_MSG_PUB.add;
1696: END LOOP;
1697:

Line 1694: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );

1690:
1691: EXIT WHEN get_dup_csi_attrib_rec%NOTFOUND;
1692:
1693: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_DUP_MED_ATTRIB_REC' );
1694: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( l_effty_ext_detail_rec ) );
1695: FND_MSG_PUB.add;
1696: END LOOP;
1697:
1698: IF ( get_dup_csi_attrib_rec%ROWCOUNT > 0 ) THEN

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

2142: AND object_version_number = p_x_effectivity_detail_tbl(i).object_version_number;
2143:
2144: -- If the record does not exist, then, abort API.
2145: IF ( SQL%ROWCOUNT = 0 ) THEN
2146: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2147: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
2148: FND_MSG_PUB.add;
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;

Line 2147: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );

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

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

2160: AND object_version_number = p_x_effectivity_detail_tbl(i).object_version_number;
2161:
2162: -- If the record does not exist, then, abort API.
2163: IF ( SQL%ROWCOUNT = 0 ) THEN
2164: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2165: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2166: FND_MSG_PUB.add;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;

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

2161:
2162: -- If the record does not exist, then, abort API.
2163: IF ( SQL%ROWCOUNT = 0 ) THEN
2164: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2165: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2166: FND_MSG_PUB.add;
2167: RAISE FND_API.G_EXC_ERROR;
2168: END IF;
2169: END IF;

Line 2226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_MED_REC' );

2222: ( yi > y )
2223: )
2224: )
2225: THEN
2226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_MED_REC' );
2227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
2228: FND_MSG_PUB.add;
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;

Line 2227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );

2223: )
2224: )
2225: THEN
2226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_OVERLAP_MED_REC' );
2227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_detail_tbl(i) ) );
2228: FND_MSG_PUB.add;
2229: RAISE FND_API.G_EXC_ERROR;
2230: END IF;
2231:

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

2347: AND object_version_number = p_x_effty_ext_detail_tbl(i).object_version_number;
2348:
2349: -- If the record does not exist, then, abort API.
2350: IF ( SQL%ROWCOUNT = 0 ) THEN
2351: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2352: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_tbl(i) ) );
2353: FND_MSG_PUB.add;
2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;

Line 2352: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_tbl(i) ) );

2348:
2349: -- If the record does not exist, then, abort API.
2350: IF ( SQL%ROWCOUNT = 0 ) THEN
2351: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2352: FND_MESSAGE.set_token( 'RECORD', get_ext_record_identifier( p_x_effty_ext_detail_tbl(i) ) );
2353: FND_MSG_PUB.add;
2354: RAISE FND_API.G_EXC_ERROR;
2355: END IF;
2356:

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

2365: AND object_version_number = p_x_effty_ext_detail_tbl(i).object_version_number;
2366:
2367: -- If the record does not exist, then, abort API.
2368: IF ( SQL%ROWCOUNT = 0 ) THEN
2369: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2370: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2371: FND_MSG_PUB.add;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;

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

2366:
2367: -- If the record does not exist, then, abort API.
2368: IF ( SQL%ROWCOUNT = 0 ) THEN
2369: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
2370: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2371: FND_MSG_PUB.add;
2372: RAISE FND_API.G_EXC_ERROR;
2373: END IF;
2374: END IF;