DBA Data[Home] [Help]

APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on FND_MESSAGE

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

79: -- Check if a valid value is passed in p_mr_header_id
80:
81: IF ( p_mr_header_id = FND_API.G_MISS_NUM OR
82: p_mr_header_id IS NULL ) THEN
83: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_MR_HEADER_ID_NULL' );
84: FND_MSG_PUB.add;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86: RETURN;
87: IF G_DEBUG = 'Y' THEN

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

91: -- Check Profile value
92:
93: IF G_APPLN_USAGE IS NULL
94: THEN
95: FND_MESSAGE.SET_NAME('AHL','AHL_COM_APP_PRFL_UNDEF');
96: FND_MSG_PUB.ADD;
97: IF G_DEBUG = 'Y' THEN
98: AHL_DEBUG_PUB.debug('APPLN USAGE CODE IS NULL IN VALIDATE_API_INPUTS' );
99: END IF;

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

107:
108: --check if mr is terminated and get the mr status.
109: l_mr_status_code :=AHL_FMP_COMMON_PVT.check_mr_status(p_mr_header_id);
110: IF l_mr_status_code IS NULL THEN
111: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR' );
112: FND_MSG_PUB.add;
113: x_return_status := FND_API.G_RET_STS_ERROR;
114: RETURN;
115: END IF;

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

137: END IF;
138:
139: IF l_error_code is not null THEN
140: AHL_DEBUG_PUB.debug('Error here.....'||L_ERROR_CODE);
141: FND_MESSAGE.set_name( 'AHL', l_error_code );
142: FND_MSG_PUB.add;
143: RETURN;
144: END IF;
145:

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

147:
148:
149: -- Check if atleast one record is passed in p_effectivity_tbl
150: IF ( p_effectivity_tbl.count < 1 ) THEN
151: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
152: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
153: FND_MSG_PUB.add;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: RETURN;

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

148:
149: -- Check if atleast one record is passed in p_effectivity_tbl
150: IF ( p_effectivity_tbl.count < 1 ) THEN
151: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
152: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
153: FND_MSG_PUB.add;
154: x_return_status := FND_API.G_RET_STS_ERROR;
155: RETURN;
156: END IF;

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

160: -- Validate DML Operation
161: IF ( p_effectivity_tbl(i).dml_operation <> 'D' AND
162: p_effectivity_tbl(i).dml_operation <> 'U' AND
163: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
164: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
165: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
166: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
167: FND_MSG_PUB.add;
168: x_return_status := FND_API.G_RET_STS_ERROR;

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

161: IF ( p_effectivity_tbl(i).dml_operation <> 'D' AND
162: p_effectivity_tbl(i).dml_operation <> 'U' AND
163: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
164: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
165: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
166: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
167: FND_MSG_PUB.add;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: END IF;

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

162: p_effectivity_tbl(i).dml_operation <> 'U' AND
163: p_effectivity_tbl(i).dml_operation <> 'C' ) THEN
164: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
165: FND_MESSAGE.set_token( 'FIELD', p_effectivity_tbl(i).dml_operation );
166: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
167: FND_MSG_PUB.add;
168: x_return_status := FND_API.G_RET_STS_ERROR;
169: END IF;
170:

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

180: p_effectivity_id => p_effectivity_tbl(i).MR_EFFECTIVITY_ID,
181: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
182: );
183: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
184: FND_MESSAGE.set_name( 'AHL', l_error_code );
185: FND_MSG_PUB.add;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: RETURN;
188: END IF;

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

202: p_eff_obj_version => p_effectivity_tbl(i).OBJECT_VERSION_NUMBER
203: );
204:
205: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
206: FND_MESSAGE.set_name( 'AHL', l_error_code );
207: FND_MSG_PUB.add;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209: RETURN;
210: END IF;

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

214: IF ( l_pm_install_flag = 'Y' AND
215: p_effectivity_tbl(i).dml_operation = 'U' AND
216: p_super_user ='Y' AND
217: l_mr_status_code = 'COMPLETE') THEN
218: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
219: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
220: FND_MSG_PUB.add;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: RETURN;

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

215: p_effectivity_tbl(i).dml_operation = 'U' AND
216: p_super_user ='Y' AND
217: l_mr_status_code = 'COMPLETE') THEN
218: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_UPDATE' );
219: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
220: FND_MSG_PUB.add;
221: x_return_status := FND_API.G_RET_STS_ERROR;
222: RETURN;
223: END IF;

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

230: IF ( ( p_effectivity_tbl(i).relationship_id IS NOT NULL AND
231: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
232: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
233: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
234: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
235: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
236: FND_MSG_PUB.add;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: END IF;

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

231: p_effectivity_tbl(i).relationship_id <> FND_API.G_MISS_NUM ) OR
232: ( p_effectivity_tbl(i).position_ref_meaning IS NOT NULL AND
233: p_effectivity_tbl(i).position_ref_meaning <> FND_API.G_MISS_CHAR ) ) THEN
234: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_INPUT_MC_POS' );
235: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_tbl(i) ) );
236: FND_MSG_PUB.add;
237: x_return_status := FND_API.G_RET_STS_ERROR;
238: END IF;
239:

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

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

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

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

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

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

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

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

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

325: p_x_inventory_item_id => p_x_effectivity_rec.inventory_item_id
326: );
327:
328: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
329: FND_MESSAGE.set_name( 'AHL', l_msg_data );
330:
331: IF ( p_x_effectivity_rec.item_number IS NULL OR
332: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
333: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );

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

329: FND_MESSAGE.set_name( 'AHL', l_msg_data );
330:
331: IF ( p_x_effectivity_rec.item_number IS NULL OR
332: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
333: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );
334: ELSE
335: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
336: END IF;
337:

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

331: IF ( p_x_effectivity_rec.item_number IS NULL OR
332: p_x_effectivity_rec.item_number = FND_API.G_MISS_CHAR ) THEN
333: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.inventory_item_id ) );
334: ELSE
335: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
336: END IF;
337:
338: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
339: FND_MSG_PUB.add;

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

334: ELSE
335: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.item_number );
336: END IF;
337:
338: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
339: FND_MSG_PUB.add;
340: END IF;
341:
342: END IF;

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

356: p_x_relationship_id => p_x_effectivity_rec.relationship_id
357: );
358:
359: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
360: FND_MESSAGE.set_name( 'AHL', l_msg_data );
361:
362: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
363: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );

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

360: FND_MESSAGE.set_name( 'AHL', l_msg_data );
361:
362: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
363: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );
365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
367: END IF;
368:

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

362: IF ( p_x_effectivity_rec.position_ref_meaning IS NULL OR
363: p_x_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
364: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.relationship_id ) );
365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
367: END IF;
368:
369: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
370: FND_MSG_PUB.add;

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

365: ELSE
366: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_ref_meaning );
367: END IF;
368:
369: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
370: FND_MSG_PUB.add;
371: END IF;
372:
373: END IF;

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

388: p_x_inventory_item_id => p_x_effectivity_rec.position_inventory_item_id
389: );
390:
391: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
392: FND_MESSAGE.set_name( 'AHL', l_msg_data );
393:
394: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
395: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
396: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );

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

392: FND_MESSAGE.set_name( 'AHL', l_msg_data );
393:
394: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
395: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
396: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );
397: ELSE
398: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
399: END IF;
400:

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

394: IF ( p_x_effectivity_rec.position_item_number IS NULL OR
395: p_x_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
396: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.position_inventory_item_id ) );
397: ELSE
398: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
399: END IF;
400:
401: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
402: FND_MSG_PUB.add;

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

397: ELSE
398: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.position_item_number );
399: END IF;
400:
401: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
402: FND_MSG_PUB.add;
403: END IF;
404:
405: END IF;

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

418: p_x_pc_node_id => p_x_effectivity_rec.pc_node_id
419: );
420:
421: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
422: FND_MESSAGE.set_name( 'AHL', l_msg_data );
423:
424: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
425: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
426: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );

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

422: FND_MESSAGE.set_name( 'AHL', l_msg_data );
423:
424: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
425: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
426: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );
427: ELSE
428: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
429: END IF;
430:

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

424: IF ( p_x_effectivity_rec.pc_node_name IS NULL OR
425: p_x_effectivity_rec.pc_node_name = FND_API.G_MISS_CHAR ) THEN
426: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_effectivity_rec.pc_node_id ) );
427: ELSE
428: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
429: END IF;
430:
431: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
432: FND_MSG_PUB.add;

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

427: ELSE
428: FND_MESSAGE.set_token( 'FIELD', p_x_effectivity_rec.pc_node_name );
429: END IF;
430:
431: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
432: FND_MSG_PUB.add;
433: END IF;
434:
435: END IF;

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

636: l_old_effectivity_rec.attribute14,
637: l_old_effectivity_rec.attribute15;
638:
639: IF get_old_rec%NOTFOUND THEN
640: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
642: FND_MSG_PUB.add;
643: CLOSE get_old_rec;
644: RAISE FND_API.G_EXC_ERROR;

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

637: l_old_effectivity_rec.attribute15;
638:
639: IF get_old_rec%NOTFOUND THEN
640: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INVALID_MR_EFF_REC' );
641: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_rec ) );
642: FND_MSG_PUB.add;
643: CLOSE get_old_rec;
644: RAISE FND_API.G_EXC_ERROR;
645: END IF;

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

811: IF ( p_effectivity_rec.dml_operation = 'C' ) THEN
812: -- Check if the Effectivity Name does not column contains a null value.
813: IF ( p_effectivity_rec.name IS NULL OR
814: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
815: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
816: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
817: FND_MSG_PUB.add;
818: END IF;
819: RETURN;

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

812: -- Check if the Effectivity Name does not column contains a null value.
813: IF ( p_effectivity_rec.name IS NULL OR
814: p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
815: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
816: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
817: FND_MSG_PUB.add;
818: END IF;
819: RETURN;
820: END IF;

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

821:
822: IF ( p_effectivity_rec.dml_operation = 'U' ) THEN
823: -- Check if the Effectivity Name column does not contains a null value.
824: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
825: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
826: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
827: FND_MSG_PUB.add;
828: END IF;
829: END IF;

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

822: IF ( p_effectivity_rec.dml_operation = 'U' ) THEN
823: -- Check if the Effectivity Name column does not contains a null value.
824: IF ( p_effectivity_rec.name = FND_API.G_MISS_CHAR ) THEN
825: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_NAME_NULL' );
826: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
827: FND_MSG_PUB.add;
828: END IF;
829: END IF;
830:

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

830:
831: -- Check if the mandatory Effectivity ID column contains a null value.
832: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
833: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
834: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
835: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
836: FND_MSG_PUB.add;
837: RETURN;
838: END IF;

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

831: -- Check if the mandatory Effectivity ID column contains a null value.
832: IF ( p_effectivity_rec.mr_effectivity_id IS NULL OR
833: p_effectivity_rec.mr_effectivity_id = FND_API.G_MISS_NUM ) THEN
834: FND_MESSAGE.set_name( 'AHL','AHL_FMP_EFFECTIVITY_ID_NULL' );
835: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
836: FND_MSG_PUB.add;
837: RETURN;
838: END IF;
839:

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

839:
840: -- Check if the mandatory Object Version Number column contains a null value.
841: IF ( p_effectivity_rec.object_version_number IS NULL OR
842: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
843: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
844: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
845: FND_MSG_PUB.add;
846: RETURN;
847: END IF;

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

840: -- Check if the mandatory Object Version Number column contains a null value.
841: IF ( p_effectivity_rec.object_version_number IS NULL OR
842: p_effectivity_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
843: FND_MESSAGE.set_name( 'AHL','AHL_FMP_MRE_OBJ_VERSION_NULL' );
844: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
845: FND_MSG_PUB.add;
846: RETURN;
847: END IF;
848:

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

918:
919: -- Check if Item is NULL
920: IF ( p_effectivity_rec.inventory_item_id IS NULL AND
921: p_effectivity_rec.item_number IS NULL ) THEN
922: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );
923: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
924: FND_MSG_PUB.add;
925: END IF;
926:

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

919: -- Check if Item is NULL
920: IF ( p_effectivity_rec.inventory_item_id IS NULL AND
921: p_effectivity_rec.item_number IS NULL ) THEN
922: FND_MESSAGE.set_name( 'AHL','AHL_FMP_PM_ITEM_NULL' );
923: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
924: FND_MSG_PUB.add;
925: END IF;
926:
927: ELSE

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

939: -- Tamal [MEL/CDL RM-FMP Enhancements] Begins here...
940: p_effectivity_rec.item_number IS NULL AND
941: nvl(l_prog_type, 'X') <> 'MO_PROC') THEN
942: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
943: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ITEM_POS_NULL' );
944: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
945: FND_MSG_PUB.add;
946: END IF;
947:

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

940: p_effectivity_rec.item_number IS NULL AND
941: nvl(l_prog_type, 'X') <> 'MO_PROC') THEN
942: -- Tamal [MEL/CDL RM-FMP Enhancements] Ends here...
943: FND_MESSAGE.set_name( 'AHL','AHL_FMP_ITEM_POS_NULL' );
944: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
945: FND_MSG_PUB.add;
946: END IF;
947:
948: -- Check if Master Configuration Item contains a value but, the Position is NULL

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

949: IF ( p_effectivity_rec.relationship_id IS NULL AND
950: p_effectivity_rec.position_ref_meaning IS NULL AND
951: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
952: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
953: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );
954: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
955: FND_MSG_PUB.add;
956: END IF;
957:

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

950: p_effectivity_rec.position_ref_meaning IS NULL AND
951: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
952: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
953: FND_MESSAGE.set_name( 'AHL','AHL_FMP_POS_NULL_ITEM_NOTNULL' );
954: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
955: FND_MSG_PUB.add;
956: END IF;
957:
958: -- Check if both Item and Master Configuration Position contain values

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

959: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR
960: p_effectivity_rec.item_number IS NOT NULL ) AND
961: ( p_effectivity_rec.relationship_id IS NOT NULL OR
962: p_effectivity_rec.position_ref_meaning IS NOT NULL ) ) THEN
963: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );
964: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
965: FND_MSG_PUB.add;
966: END IF;
967:

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

960: p_effectivity_rec.item_number IS NOT NULL ) AND
961: ( p_effectivity_rec.relationship_id IS NOT NULL OR
962: p_effectivity_rec.position_ref_meaning IS NOT NULL ) ) THEN
963: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_NOTNULL' );
964: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
965: FND_MSG_PUB.add;
966: END IF;
967:
968: -- Check if both Item and Master Configuration Item contain values

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

969: IF ( ( p_effectivity_rec.inventory_item_id IS NOT NULL OR
970: p_effectivity_rec.item_number IS NOT NULL ) AND
971: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
972: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
973: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );
974: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
975: FND_MSG_PUB.add;
976: END IF;
977:

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

970: p_effectivity_rec.item_number IS NOT NULL ) AND
971: ( p_effectivity_rec.position_inventory_item_id IS NOT NULL OR
972: p_effectivity_rec.position_item_number IS NOT NULL ) ) THEN
973: FND_MESSAGE.set_name( 'AHL','AHL_FMP_BOTH_ITEM_POS_ITEM' );
974: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
975: FND_MSG_PUB.add;
976: END IF;
977:
978: -- Check if the given Item can be installed in the given Master Configuration Position

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

988: p_relationship_id => p_effectivity_rec.relationship_id
989: );
990:
991: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
992: FND_MESSAGE.set_name( 'AHL', l_msg_data );
993: IF ( p_effectivity_rec.position_item_number IS NULL OR
994: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
995: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
996: ELSE

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

991: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
992: FND_MESSAGE.set_name( 'AHL', l_msg_data );
993: IF ( p_effectivity_rec.position_item_number IS NULL OR
994: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
995: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
996: ELSE
997: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
998: END IF;
999:

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

993: IF ( p_effectivity_rec.position_item_number IS NULL OR
994: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
995: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
996: ELSE
997: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
998: END IF;
999:
1000: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1001: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

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

998: END IF;
999:
1000: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1001: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1002: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1003: ELSE
1004: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1005: END IF;
1006:

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

1000: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1001: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1002: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1003: ELSE
1004: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1005: END IF;
1006:
1007: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1008: FND_MSG_PUB.add;

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

1003: ELSE
1004: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1005: END IF;
1006:
1007: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1008: FND_MSG_PUB.add;
1009: END IF; */
1010:
1011: --pdoki added for Bug 6719371

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

1016:
1017: IF check_alternate%NOTFOUND THEN
1018: l_msg_data := 'AHL_FMP_INVALID_POSITION_ITEM';
1019:
1020: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1021: IF ( p_effectivity_rec.position_item_number IS NULL OR
1022: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1023: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1024: ELSE

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

1019:
1020: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1021: IF ( p_effectivity_rec.position_item_number IS NULL OR
1022: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1023: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1024: ELSE
1025: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1026: END IF;
1027:

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

1021: IF ( p_effectivity_rec.position_item_number IS NULL OR
1022: p_effectivity_rec.position_item_number = FND_API.G_MISS_CHAR ) THEN
1023: FND_MESSAGE.set_token( 'FIELD1', TO_CHAR( p_effectivity_rec.position_inventory_item_id ) );
1024: ELSE
1025: FND_MESSAGE.set_token( 'FIELD1', p_effectivity_rec.position_item_number );
1026: END IF;
1027:
1028: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1029: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN

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

1026: END IF;
1027:
1028: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1029: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1030: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1031: ELSE
1032: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1033: END IF;
1034:

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

1028: IF ( p_effectivity_rec.position_ref_meaning IS NULL OR
1029: p_effectivity_rec.position_ref_meaning = FND_API.G_MISS_CHAR ) THEN
1030: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_effectivity_rec.relationship_id ) );
1031: ELSE
1032: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1033: END IF;
1034:
1035: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1036: FND_MSG_PUB.add;

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

1031: ELSE
1032: FND_MESSAGE.set_token( 'FIELD2', p_effectivity_rec.position_ref_meaning );
1033: END IF;
1034:
1035: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1036: FND_MSG_PUB.add;
1037: END IF;
1038: CLOSE check_alternate;
1039: END IF;

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

1074: );
1075: END IF;
1076:
1077: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1078: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1079: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1080: FND_MSG_PUB.add;
1081: END IF;
1082:

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

1075: END IF;
1076:
1077: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1078: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_DTLS_EXIST' );
1079: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1080: FND_MSG_PUB.add;
1081: END IF;
1082:
1083: END IF;

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

1124: );
1125: END IF;
1126:
1127: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1128: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1129: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1130: FND_MSG_PUB.add;
1131: END IF;
1132:

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

1125: END IF;
1126:
1127: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1128: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_INTERVALS_EXIST' );
1129: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_effectivity_rec ) );
1130: FND_MSG_PUB.add;
1131: END IF;
1132:
1133: END IF;

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

1190: l_effectivity_name;
1191:
1192: EXIT WHEN get_dup_name%NOTFOUND;
1193:
1194: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1195: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );
1196: FND_MSG_PUB.add;
1197:
1198: END LOOP;

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

1191:
1192: EXIT WHEN get_dup_name%NOTFOUND;
1193:
1194: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1195: FND_MESSAGE.set_token( 'RECORD', l_effectivity_name );
1196: FND_MSG_PUB.add;
1197:
1198: END LOOP;
1199:

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

1215:
1216: EXIT WHEN get_dup_item%NOTFOUND;
1217:
1218: if (get_dup_item%FOUND and l_inventory_item_id is not null) then
1219: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_PM_ITEM_DUP' );
1220: open get_item_number(l_inventory_item_id);
1221: fetch get_item_number into l_item_number;
1222: if get_item_number%notfound then
1223: l_item_number := to_char(l_inventory_item_id);

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

1222: if get_item_number%notfound then
1223: l_item_number := to_char(l_inventory_item_id);
1224: end if;
1225: close get_item_number;
1226: FND_MESSAGE.set_token( 'RECORD', l_item_number );
1227: FND_MSG_PUB.add;
1228: end if;
1229:
1230: END LOOP;

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

1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF ( SQLCODE = -1 ) THEN
1531: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1532: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1533: FND_MSG_PUB.add;
1534: END IF;
1535: END;

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

1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF ( SQLCODE = -1 ) THEN
1531: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1532: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1533: FND_MSG_PUB.add;
1534: END IF;
1535: END;
1536:

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

1571: AND object_version_number = p_x_effectivity_tbl(i).object_version_number;
1572:
1573: -- If the record does not exist, then, abort API.
1574: IF ( SQL%ROWCOUNT = 0 ) THEN
1575: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );
1577: FND_MSG_PUB.add;
1578: END IF;
1579:

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

1572:
1573: -- If the record does not exist, then, abort API.
1574: IF ( SQL%ROWCOUNT = 0 ) THEN
1575: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_effectivity_tbl(i) ) );
1577: FND_MSG_PUB.add;
1578: END IF;
1579:
1580: -- Set OUT values

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

1582:
1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: IF ( SQLCODE = -1 ) THEN
1586: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1587: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1588: FND_MSG_PUB.add;
1589: END IF;
1590: END;

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

1583: EXCEPTION
1584: WHEN OTHERS THEN
1585: IF ( SQLCODE = -1 ) THEN
1586: FND_MESSAGE.set_name( 'AHL', 'AHL_FMP_EFFECTIVITY_NAME_DUP' );
1587: FND_MESSAGE.set_token( 'RECORD', p_x_effectivity_tbl(i).name );
1588: FND_MSG_PUB.add;
1589: END IF;
1590: END;
1591:

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

1597: AND object_version_number = p_x_effectivity_tbl(i).object_version_number;
1598:
1599: -- If the record does not exist, then, abort API.
1600: IF ( SQL%ROWCOUNT = 0 ) THEN
1601: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1602: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1603: FND_MSG_PUB.add;
1604: END IF;
1605:

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

1598:
1599: -- If the record does not exist, then, abort API.
1600: IF ( SQL%ROWCOUNT = 0 ) THEN
1601: FND_MESSAGE.set_name('AHL','AHL_FMP_RECORD_CHANGED');
1602: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
1603: FND_MSG_PUB.add;
1604: END IF;
1605:
1606: -- Delete the record in related Tables