eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on FND_MESSAGE

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

87: -- Check if a valid value is passed in p_mr_header_id
88:
89: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
90: p_mr_header_id IS NULL ) THEN
91: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
92: FND_MSG_PUB.add;
93: x_return_status := FND_API.G_RET_STS_ERROR;
94: RETURN;
95: IF G_DEBUG = 'Y' THEN

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

99: -- Check Profile value
100:
101: IF G_APPLN_USAGE IS NULL
102: THEN
103: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
104: FND_MSG_PUB.ADD;
105: IF G_DEBUG = 'Y' THEN
106: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
107: END IF;

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

115:
116: --check if mr is terminated and get the mr status.
117: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
118: IF l_mr_status_code IS NULL THEN
119: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
120: FND_MSG_PUB.add;
121: x_return_status := FND_API.G_RET_STS_ERROR;
122: RETURN;
123: END IF;

Line 149: FND_MESSAGE.set_name( 'AHL', l_error_code );

145: END IF;
146:
147: IF l_error_code is not null THEN
148: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);
149: FND_MESSAGE.set_name( 'AHL', l_error_code );
150: FND_MSG_PUB.add;
151: RETURN;
152: END IF;
153:

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

155:
156:
157: -- Check if atleast one record is passed in p_effectivity_tbl
158: IF ( p_effectivity_tbl.count < 1 ) THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
160: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
161: FND_MSG_PUB.add;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: RETURN;

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

156:
157: -- Check if atleast one record is passed in p_effectivity_tbl
158: IF ( p_effectivity_tbl.count < 1 ) THEN
159: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
160: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
161: FND_MSG_PUB.add;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: RETURN;
164: END IF;

Line 172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );

168: -- Validate DML Operation
169: IF ( p_effectivity_tbl(i).dml_operation <> 'D' AND
170: p_effectivity_tbl(i).dml_operation <> 'U' AND
171: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
175: FND_MSG_PUB.add;
176: x_return_status := FND_API.G_RET_STS_ERROR;

Line 173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );

169: IF ( p_effectivity_tbl(i).dml_operation <> 'D' AND
170: p_effectivity_tbl(i).dml_operation <> 'U' AND
171: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
175: FND_MSG_PUB.add;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;

Line 174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

170: p_effectivity_tbl(i).dml_operation <> 'U' AND
171: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
172: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
173: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
174: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
175: FND_MSG_PUB.add;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: END IF;
178:

Line 192: FND_MESSAGE.set_name( 'AHL', l_error_code );

188: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,
189: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
190: );
191: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
192: FND_MESSAGE.set_name( 'AHL', l_error_code );
193: FND_MSG_PUB.add;
194: x_return_status := FND_API.G_RET_STS_ERROR;
195: RETURN;
196: END IF;

Line 214: FND_MESSAGE.set_name( 'AHL', l_error_code );

210: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
211: );
212:
213: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
214: FND_MESSAGE.set_name( 'AHL', l_error_code );
215: FND_MSG_PUB.add;
216: x_return_status := FND_API.G_RET_STS_ERROR;
217: RETURN;
218: END IF;

Line 226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );

222: IF ( l_pm_install_flag = 'Y' AND
223: p_effectivity_tbl(i).dml_operation = 'U' AND
224: p_super_user ='Y' AND
225: l_mr_status_code = 'COMPLETE') THEN
226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
228: FND_MSG_PUB.add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RETURN;

Line 227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

223: p_effectivity_tbl(i).dml_operation = 'U' AND
224: p_super_user ='Y' AND
225: l_mr_status_code = 'COMPLETE') THEN
226: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
227: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
228: FND_MSG_PUB.add;
229: x_return_status := FND_API.G_RET_STS_ERROR;
230: RETURN;
231: END IF;

Line 242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );

238: IF ( ( p_effectivity_tbl(i).relationship_id IS NOT NULL AND
239: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
240: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
244: FND_MSG_PUB.add;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;

Line 243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

239: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
240: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
241: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
242: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
243: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
244: FND_MSG_PUB.add;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: END IF;
247:

Line 252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );

248: IF ( ( p_effectivity_tbl(i).position_inventory_item_id IS NOT NULL AND
249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR
250: ( p_effectivity_tbl(i).position_item_number IS NOT NULL AND
251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
254: FND_MSG_PUB.add;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;

Line 253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

249: p_effectivity_tbl(i).position_inventory_item_id <> FND_API.G_MISS_NUM ) OR
250: ( p_effectivity_tbl(i).position_item_number IS NOT NULL AND
251: p_effectivity_tbl(i).position_item_number <> FND_API.G_MISS_CHAR ) ) THEN
252: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS_ITEM' );
253: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
254: FND_MSG_PUB.add;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: END IF;
257:

Line 262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );

258: IF ( ( p_effectivity_tbl(i).pc_node_id IS NOT NULL AND
259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR
260: ( p_effectivity_tbl(i).pc_node_name IS NOT NULL AND
261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
264: FND_MSG_PUB.add;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;

Line 263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );

259: p_effectivity_tbl(i).pc_node_id <> FND_API.G_MISS_NUM ) OR
260: ( p_effectivity_tbl(i).pc_node_name IS NOT NULL AND
261: p_effectivity_tbl(i).pc_node_name <> FND_API.G_MISS_CHAR ) ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_PC_NODE' );
263: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
264: FND_MSG_PUB.add;
265: x_return_status := FND_API.G_RET_STS_ERROR;
266: END IF;
267:

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

341: p_x_inventory_item_id => p_x_effectivity_rec.inventory_item_id
342: );
343:
344: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
345: FND_MESSAGE.set_name( 'AHL', l_msg_data );
346:
347: IF ( p_x_effectivity_rec.item_number IS NULL OR
348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );

Line 349: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );

345: FND_MESSAGE.set_name( 'AHL', l_msg_data );
346:
347: IF ( p_x_effectivity_rec.item_number IS NULL OR
348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );
350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
352: END IF;
353:

Line 351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );

347: IF ( p_x_effectivity_rec.item_number IS NULL OR
348: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
349: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );
350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
352: END IF;
353:
354: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
355: FND_MSG_PUB.add;

Line 354: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

350: ELSE
351: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
352: END IF;
353:
354: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
355: FND_MSG_PUB.add;
356: END IF;
357:
358: END IF;

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

372: p_x_relationship_id => p_x_effectivity_rec.relationship_id
373: );
374:
375: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
376: FND_MESSAGE.set_name( 'AHL', l_msg_data );
377:
378: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
380: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );

Line 380: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );

376: FND_MESSAGE.set_name( 'AHL', l_msg_data );
377:
378: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
380: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );
381: ELSE
382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
383: END IF;
384:

Line 382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );

378: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
379: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
380: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );
381: ELSE
382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
383: END IF;
384:
385: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
386: FND_MSG_PUB.add;

Line 385: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

381: ELSE
382: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
383: END IF;
384:
385: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
386: FND_MSG_PUB.add;
387: END IF;
388:
389: END IF;

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

404: p_x_inventory_item_id => p_x_effectivity_rec.position_inventory_item_id
405: );
406:
407: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
408: FND_MESSAGE.set_name( 'AHL', l_msg_data );
409:
410: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
412: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );

Line 412: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );

408: FND_MESSAGE.set_name( 'AHL', l_msg_data );
409:
410: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
412: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );
413: ELSE
414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
415: END IF;
416:

Line 414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );

410: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
411: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
412: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );
413: ELSE
414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
415: END IF;
416:
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
418: FND_MSG_PUB.add;

Line 417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

413: ELSE
414: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
415: END IF;
416:
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
418: FND_MSG_PUB.add;
419: END IF;
420:
421: END IF;

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

434: p_x_pc_node_id => p_x_effectivity_rec.pc_node_id
435: );
436:
437: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
438: FND_MESSAGE.set_name( 'AHL', l_msg_data );
439:
440: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
442: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );

Line 442: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );

438: FND_MESSAGE.set_name( 'AHL', l_msg_data );
439:
440: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
442: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );
443: ELSE
444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
445: END IF;
446:

Line 444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );

440: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
441: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
442: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );
443: ELSE
444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
445: END IF;
446:
447: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
448: FND_MSG_PUB.add;

Line 447: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

443: ELSE
444: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
445: END IF;
446:
447: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
448: FND_MSG_PUB.add;
449: END IF;
450:
451: END IF;

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

465: p_x_fleet_header_id => p_x_effectivity_rec.FLEET_HEADER_ID
466: );
467:
468: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
469: FND_MESSAGE.set_name( 'AHL', l_msg_data );
470:
471: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL OR
472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
473: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.FLEET_HEADER_ID ) );

Line 473: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.FLEET_HEADER_ID ) );

469: FND_MESSAGE.set_name( 'AHL', l_msg_data );
470:
471: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL OR
472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
473: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.FLEET_HEADER_ID ) );
474: ELSE
475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );
476: END IF;
477:

Line 475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );

471: IF ( p_x_effectivity_rec.FLEET_NAME IS NULL OR
472: p_x_effectivity_rec.FLEET_NAME = FND_API.G_MISS_CHAR ) THEN
473: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.FLEET_HEADER_ID ) );
474: ELSE
475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );
476: END IF;
477:
478: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
479: FND_MSG_PUB.add;

Line 478: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

474: ELSE
475: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.FLEET_NAME );
476: END IF;
477:
478: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
479: FND_MSG_PUB.add;
480: END IF;
481:
482: END IF;

Line 700: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );

696: l_old_effectivity_rec.attribute14,
697: l_old_effectivity_rec.attribute15;
698:
699: IF get_old_rec%NOTFOUND THEN
700: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
701: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
702: FND_MSG_PUB.add;
703: CLOSE get_old_rec;
704: RAISE FND_API.G_EXC_ERROR;

Line 701: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );

697: l_old_effectivity_rec.attribute15;
698:
699: IF get_old_rec%NOTFOUND THEN
700: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
701: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
702: FND_MSG_PUB.add;
703: CLOSE get_old_rec;
704: RAISE FND_API.G_EXC_ERROR;
705: END IF;

Line 888: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );

884: IF ( p_effectivity_rec.dml_operation = 'C' ) THEN
885: -- Check if the Effectivity Name does not column contains a null value.
886: IF ( p_effectivity_rec.name IS NULL OR
887: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
888: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
889: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
890: FND_MSG_PUB.add;
891: END IF;
892: RETURN;

Line 889: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

885: -- Check if the Effectivity Name does not column contains a null value.
886: IF ( p_effectivity_rec.name IS NULL OR
887: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
888: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
889: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
890: FND_MSG_PUB.add;
891: END IF;
892: RETURN;
893: END IF;

Line 898: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );

894:
895: IF ( p_effectivity_rec.dml_operation = 'U' ) THEN
896: -- Check if the Effectivity Name column does not contains a null value.
897: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
898: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
899: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
900: FND_MSG_PUB.add;
901: END IF;
902: END IF;

Line 899: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

895: IF ( p_effectivity_rec.dml_operation = 'U' ) THEN
896: -- Check if the Effectivity Name column does not contains a null value.
897: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
898: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
899: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
900: FND_MSG_PUB.add;
901: END IF;
902: END IF;
903:

Line 907: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );

903:
904: -- Check if the mandatory Effectivity ID column contains a null value.
905: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
906: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
907: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
908: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
909: FND_MSG_PUB.add;
910: RETURN;
911: END IF;

Line 908: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

904: -- Check if the mandatory Effectivity ID column contains a null value.
905: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
906: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
907: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
908: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
909: FND_MSG_PUB.add;
910: RETURN;
911: END IF;
912:

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

912:
913: -- Check if the mandatory Object Version Number column contains a null value.
914: IF ( p_effectivity_rec.object_version_number IS NULL OR
915: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
916: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
917: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
918: FND_MSG_PUB.add;
919: RETURN;
920: END IF;

Line 917: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

913: -- Check if the mandatory Object Version Number column contains a null value.
914: IF ( p_effectivity_rec.object_version_number IS NULL OR
915: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
916: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
917: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
918: FND_MSG_PUB.add;
919: RETURN;
920: END IF;
921:

Line 995: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );

991:
992: -- Check if Item is NULL
993: IF ( p_effectivity_rec.inventory_item_id IS NULL AND
994: p_effectivity_rec.item_number IS NULL ) THEN
995: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );
996: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
997: FND_MSG_PUB.add;
998: END IF;
999:

Line 996: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

992: -- Check if Item is NULL
993: IF ( p_effectivity_rec.inventory_item_id IS NULL AND
994: p_effectivity_rec.item_number IS NULL ) THEN
995: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );
996: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
997: FND_MSG_PUB.add;
998: END IF;
999:
1000: ELSE

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

1012: -- Tamal [MEL/CDL RM-FMP Enhancements] Begins here...
1013: p_effectivity_rec.item_number IS NULL AND
1014: nvl(l_prog_type, 'X') <> 'MO_PROC') THEN
1015: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ITEM_POS_NULL' );
1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1018: FND_MSG_PUB.add;
1019: END IF;
1020:

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

1013: p_effectivity_rec.item_number IS NULL AND
1014: nvl(l_prog_type, 'X') <> 'MO_PROC') THEN
1015: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
1016: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ITEM_POS_NULL' );
1017: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1018: FND_MSG_PUB.add;
1019: END IF;
1020:
1021: -- Check if Master Configuration Item contains a value but, the Position is NULL

Line 1026: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );

1022: IF ( p_effectivity_rec.relationship_id IS NULL AND
1023: p_effectivity_rec.position_ref_meaning IS NULL AND
1024: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1025: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1026: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );
1027: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1028: FND_MSG_PUB.add;
1029: END IF;
1030:

Line 1027: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1023: p_effectivity_rec.position_ref_meaning IS NULL AND
1024: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1025: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1026: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );
1027: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1028: FND_MSG_PUB.add;
1029: END IF;
1030:
1031: -- Check if both Item and Master Configuration Position contain values

Line 1036: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );

1032: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR
1033: p_effectivity_rec.item_number IS NOT NULL ) AND
1034: ( p_effectivity_rec.relationship_id IS NOT NULL OR
1035: p_effectivity_rec.position_ref_meaning IS NOT NULL ) ) THEN
1036: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );
1037: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1038: FND_MSG_PUB.add;
1039: END IF;
1040:

Line 1037: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1033: p_effectivity_rec.item_number IS NOT NULL ) AND
1034: ( p_effectivity_rec.relationship_id IS NOT NULL OR
1035: p_effectivity_rec.position_ref_meaning IS NOT NULL ) ) THEN
1036: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );
1037: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1038: FND_MSG_PUB.add;
1039: END IF;
1040:
1041: -- Check if both Item and Master Configuration Item contain values

Line 1046: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );

1042: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR
1043: p_effectivity_rec.item_number IS NOT NULL ) AND
1044: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1045: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1046: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );
1047: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1048: FND_MSG_PUB.add;
1049: END IF;
1050:

Line 1047: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1043: p_effectivity_rec.item_number IS NOT NULL ) AND
1044: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
1045: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
1046: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );
1047: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1048: FND_MSG_PUB.add;
1049: END IF;
1050:
1051: -- sansatpa - Check if both Item and MC position are null and fleet contains value

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

1054: (p_effectivity_rec.relationship_id IS NULL OR
1055: p_effectivity_rec.position_ref_meaning IS NULL) ) AND
1056: ( p_effectivity_rec.FLEET_HEADER_ID IS NOT NULL OR
1057: p_effectivity_rec.FLEET_NAME IS NOT NULL )) THEN
1058: FND_MESSAGE.set_name( 'AHL','AHL_FMP_FLEET_REQ_ITEM_OR_PC' );
1059: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1060: FND_MSG_PUB.add;
1061: END IF;*/
1062:

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

1055: p_effectivity_rec.position_ref_meaning IS NULL) ) AND
1056: ( p_effectivity_rec.FLEET_HEADER_ID IS NOT NULL OR
1057: p_effectivity_rec.FLEET_NAME IS NOT NULL )) THEN
1058: FND_MESSAGE.set_name( 'AHL','AHL_FMP_FLEET_REQ_ITEM_OR_PC' );
1059: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1060: FND_MSG_PUB.add;
1061: END IF;*/
1062:
1063: -- Check if the given Item can be installed in the given Master Configuration Position

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

1073: p_relationship_id => p_effectivity_rec.relationship_id
1074: );
1075:
1076: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1077: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1078: IF ( p_effectivity_rec.position_item_number IS NULL OR
1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1081: ELSE

Line 1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );

1076: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1077: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1078: IF ( p_effectivity_rec.position_item_number IS NULL OR
1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1081: ELSE
1082: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1083: END IF;
1084:

Line 1082: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );

1078: IF ( p_effectivity_rec.position_item_number IS NULL OR
1079: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1080: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1081: ELSE
1082: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1083: END IF;
1084:
1085: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1086: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

Line 1087: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );

1083: END IF;
1084:
1085: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1086: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1087: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1088: ELSE
1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1090: END IF;
1091:

Line 1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );

1085: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1086: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1087: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1088: ELSE
1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1090: END IF;
1091:
1092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1093: FND_MSG_PUB.add;

Line 1092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1088: ELSE
1089: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1090: END IF;
1091:
1092: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1093: FND_MSG_PUB.add;
1094: END IF; */
1095:
1096: --pdoki added for Bug 6719371

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

1101:
1102: IF check_alternate%NOTFOUND THEN
1103: l_msg_data := 'AHL_FMP_INVALID_POSITION_ITEM';
1104:
1105: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1106: IF ( p_effectivity_rec.position_item_number IS NULL OR
1107: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1108: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1109: ELSE

Line 1108: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );

1104:
1105: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1106: IF ( p_effectivity_rec.position_item_number IS NULL OR
1107: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1108: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1109: ELSE
1110: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1111: END IF;
1112:

Line 1110: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );

1106: IF ( p_effectivity_rec.position_item_number IS NULL OR
1107: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1108: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1109: ELSE
1110: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1111: END IF;
1112:
1113: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1114: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

Line 1115: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );

1111: END IF;
1112:
1113: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1114: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1115: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1116: ELSE
1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1118: END IF;
1119:

Line 1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );

1113: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1114: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1115: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1116: ELSE
1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1118: END IF;
1119:
1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1121: FND_MSG_PUB.add;

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

1116: ELSE
1117: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1118: END IF;
1119:
1120: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1121: FND_MSG_PUB.add;
1122: END IF;
1123: CLOSE check_alternate;
1124: END IF;

Line 1163: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );

1159: );
1160: END IF;
1161:
1162: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1163: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1165: FND_MSG_PUB.add;
1166: END IF;
1167:

Line 1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1160: END IF;
1161:
1162: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1163: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1164: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1165: FND_MSG_PUB.add;
1166: END IF;
1167:
1168: END IF;

Line 1213: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );

1209: );
1210: END IF;
1211:
1212: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1213: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1214: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1215: FND_MSG_PUB.add;
1216: END IF;
1217:

Line 1214: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );

1210: END IF;
1211:
1212: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1213: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1214: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1215: FND_MSG_PUB.add;
1216: END IF;
1217:
1218: END IF;

Line 1279: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );

1275: l_effectivity_name;
1276:
1277: EXIT WHEN get_dup_name%NOTFOUND;
1278:
1279: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1280: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );
1281: FND_MSG_PUB.add;
1282:
1283: END LOOP;

Line 1280: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );

1276:
1277: EXIT WHEN get_dup_name%NOTFOUND;
1278:
1279: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1280: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );
1281: FND_MSG_PUB.add;
1282:
1283: END LOOP;
1284:

Line 1304: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_ITEM_DUP' );

1300:
1301: EXIT WHEN get_dup_item%NOTFOUND;
1302:
1303: if (get_dup_item%FOUND and l_inventory_item_id is not null) then
1304: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_ITEM_DUP' );
1305: open get_item_number(l_inventory_item_id);
1306: fetch get_item_number into l_item_number;
1307: if get_item_number%notfound then
1308: l_item_number := to_char(l_inventory_item_id);

Line 1311: FND_MESSAGE.set_token( 'RECORD', l_item_number );

1307: if get_item_number%notfound then
1308: l_item_number := to_char(l_inventory_item_id);
1309: end if;
1310: close get_item_number;
1311: FND_MESSAGE.set_token( 'RECORD', l_item_number );
1312: FND_MSG_PUB.add;
1313: end if;
1314:
1315: END LOOP;

Line 1624: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );

1620:
1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF ( SQLCODE = -1 ) THEN
1624: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1625: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1626: FND_MSG_PUB.add;
1627: END IF;
1628: END;

Line 1625: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );

1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: IF ( SQLCODE = -1 ) THEN
1624: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1625: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1626: FND_MSG_PUB.add;
1627: END IF;
1628: END;
1629:

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

1665: AND object_version_number = p_x_effectivity_tbl(i).object_version_number;
1666:
1667: -- If the record does not exist, then, abort API.
1668: IF ( SQL%ROWCOUNT = 0 ) THEN
1669: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );
1671: FND_MSG_PUB.add;
1672: END IF;
1673:

Line 1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );

1666:
1667: -- If the record does not exist, then, abort API.
1668: IF ( SQL%ROWCOUNT = 0 ) THEN
1669: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );
1671: FND_MSG_PUB.add;
1672: END IF;
1673:
1674: -- Set OUT values

Line 1680: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );

1676:
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: IF ( SQLCODE = -1 ) THEN
1680: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1681: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1682: FND_MSG_PUB.add;
1683: END IF;
1684: END;

Line 1681: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );

1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: IF ( SQLCODE = -1 ) THEN
1680: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1681: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1682: FND_MSG_PUB.add;
1683: END IF;
1684: END;
1685:

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

1691: AND object_version_number = p_x_effectivity_tbl(i).object_version_number;
1692:
1693: -- If the record does not exist, then, abort API.
1694: IF ( SQL%ROWCOUNT = 0 ) THEN
1695: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1696: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1697: FND_MSG_PUB.add;
1698: END IF;
1699:

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

1692:
1693: -- If the record does not exist, then, abort API.
1694: IF ( SQL%ROWCOUNT = 0 ) THEN
1695: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1696: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1697: FND_MSG_PUB.add;
1698: END IF;
1699:
1700: -- Delete the record in related Tables