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_RM_MATERIAL_AS_PVT dependencies on FND_MESSAGE

Line 128: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OBJECT_ID_NULL' );

124:
125: -- Check if a value is passed in p_object_id
126: IF ( p_object_id = FND_API.G_MISS_NUM OR
127: p_object_id IS NULL ) THEN
128: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_OBJECT_ID_NULL' );
129: FND_MSG_PUB.add;
130: x_return_status := FND_API.G_RET_STS_ERROR;
131: RETURN;
132: END IF;

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

133:
134: -- Check if a value is passed in p_association_type
135: IF ( p_association_type = FND_API.G_MISS_CHAR OR
136: p_association_type IS NULL ) THEN
137: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_NULL' );
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_RM_ASSOC_TYPE_INVALID' );

143: -- Check if a valid value is passed in p_association_type
144: IF ( p_association_type <> 'ROUTE' AND
145: p_association_type <> 'OPERATION' AND
146: p_association_type <> 'DISPOSITION' ) THEN
147: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
148: FND_MESSAGE.set_token( 'FIELD', p_association_type );
149: FND_MSG_PUB.add;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: RETURN;

Line 148: FND_MESSAGE.set_token( 'FIELD', p_association_type );

144: IF ( p_association_type <> 'ROUTE' AND
145: p_association_type <> 'OPERATION' AND
146: p_association_type <> 'DISPOSITION' ) THEN
147: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ASSOC_TYPE_INVALID' );
148: FND_MESSAGE.set_token( 'FIELD', p_association_type );
149: FND_MSG_PUB.add;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151: RETURN;
152: END IF;

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

175: );
176: END IF;
177:
178: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
179: FND_MESSAGE.set_name( 'AHL', l_msg_data );
180: FND_MSG_PUB.add;
181: x_return_status := l_return_status;
182: RETURN;
183: END IF;

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

183: END IF;
184:
185: -- Check if atleast one record is passed in p_material_req_tbl
186: IF ( p_material_req_tbl.count < 1 ) THEN
187: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
188: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
189: FND_MSG_PUB.add;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: RETURN;

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

184:
185: -- Check if atleast one record is passed in p_material_req_tbl
186: IF ( p_material_req_tbl.count < 1 ) THEN
187: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
188: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME );
189: FND_MSG_PUB.add;
190: x_return_status := FND_API.G_RET_STS_ERROR;
191: RETURN;
192: END IF;

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

195: FOR i IN 1..p_material_req_tbl.count LOOP
196: IF ( p_material_req_tbl(i).dml_operation <> 'D' AND
197: p_material_req_tbl(i).dml_operation <> 'U' AND
198: p_material_req_tbl(i).dml_operation <> 'C' ) THEN
199: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
200: FND_MESSAGE.set_token( 'FIELD', p_material_req_tbl(i).dml_operation );
201: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_tbl(i) ) );
202: FND_MSG_PUB.add;
203: x_return_status := FND_API.G_RET_STS_ERROR;

Line 200: FND_MESSAGE.set_token( 'FIELD', p_material_req_tbl(i).dml_operation );

196: IF ( p_material_req_tbl(i).dml_operation <> 'D' AND
197: p_material_req_tbl(i).dml_operation <> 'U' AND
198: p_material_req_tbl(i).dml_operation <> 'C' ) THEN
199: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
200: FND_MESSAGE.set_token( 'FIELD', p_material_req_tbl(i).dml_operation );
201: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_tbl(i) ) );
202: FND_MSG_PUB.add;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: RETURN;

Line 201: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_tbl(i) ) );

197: p_material_req_tbl(i).dml_operation <> 'U' AND
198: p_material_req_tbl(i).dml_operation <> 'C' ) THEN
199: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
200: FND_MESSAGE.set_token( 'FIELD', p_material_req_tbl(i).dml_operation );
201: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_tbl(i) ) );
202: FND_MSG_PUB.add;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: RETURN;
205: END IF;

Line 228: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_efct_OBJECT_NULL' );

224:
225: -- Check if a valid value is passed in p_rt_oper_resource_id
226: IF ( p_object_id = FND_API.G_MISS_NUM OR
227: p_object_id IS NULL ) THEN
228: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_efct_OBJECT_NULL' );
229: FND_MSG_PUB.add;
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: RAISE FND_API.G_EXC_ERROR;
232: END IF;

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

237: x_return_status => l_return_status,
238: x_msg_data => l_msg_data
239: );
240: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
241: FND_MESSAGE.set_name( 'AHL', l_msg_data );
242: FND_MSG_PUB.add;
243: x_return_status := FND_API.G_RET_STS_ERROR;
244: RETURN;
245: END IF;

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

246:
247:
248: -- Check if at least one record is passed in p_rt_oper_resource_tbl
249: IF ( p_route_efct_tbl.count < 1 ) THEN
250: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
251: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );
252: FND_MSG_PUB.add;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: RETURN;

Line 251: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );

247:
248: -- Check if at least one record is passed in p_rt_oper_resource_tbl
249: IF ( p_route_efct_tbl.count < 1 ) THEN
250: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
251: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || G_API_NAME1 );
252: FND_MSG_PUB.add;
253: x_return_status := FND_API.G_RET_STS_ERROR;
254: RETURN;
255: END IF;

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

258: FOR i IN 1..p_route_efct_tbl.count LOOP
259: IF ( p_route_efct_tbl(i).dml_operation <> 'C' AND
260: p_route_efct_tbl(i).dml_operation <> 'U' AND
261: p_route_efct_tbl(i).dml_operation <> 'D' ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
263: FND_MESSAGE.set_token( 'FIELD', p_route_efct_tbl(i).dml_operation );
264: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_efct_tbl(i) ) );
265: FND_MSG_PUB.add;
266: x_return_status := FND_API.G_RET_STS_ERROR;

Line 263: FND_MESSAGE.set_token( 'FIELD', p_route_efct_tbl(i).dml_operation );

259: IF ( p_route_efct_tbl(i).dml_operation <> 'C' AND
260: p_route_efct_tbl(i).dml_operation <> 'U' AND
261: p_route_efct_tbl(i).dml_operation <> 'D' ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
263: FND_MESSAGE.set_token( 'FIELD', p_route_efct_tbl(i).dml_operation );
264: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_efct_tbl(i) ) );
265: FND_MSG_PUB.add;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: RETURN;

Line 264: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_efct_tbl(i) ) );

260: p_route_efct_tbl(i).dml_operation <> 'U' AND
261: p_route_efct_tbl(i).dml_operation <> 'D' ) THEN
262: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
263: FND_MESSAGE.set_token( 'FIELD', p_route_efct_tbl(i).dml_operation );
264: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_route_efct_tbl(i) ) );
265: FND_MSG_PUB.add;
266: x_return_status := FND_API.G_RET_STS_ERROR;
267: RETURN;
268: END IF;

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

404: );
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: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_comp_detail_id ) );
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
411: FND_MSG_PUB.add;
412: x_return_status := l_return_status;

Line 409: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_comp_detail_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: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_comp_detail_id ) );
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
411: FND_MSG_PUB.add;
412: x_return_status := l_return_status;
413: END IF;

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

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: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_comp_detail_id ) );
410: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
411: FND_MSG_PUB.add;
412: x_return_status := l_return_status;
413: END IF;
414:

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

429: p_x_position_path_id => p_x_material_req_rec.position_path_id
430: );
431:
432: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
433: FND_MESSAGE.set_name( 'AHL', l_msg_data );
434:
435: IF ( p_x_material_req_rec.position_path IS NULL OR
436: p_x_material_req_rec.position_path = FND_API.G_MISS_CHAR ) THEN
437: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.position_path_id ) );

Line 437: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.position_path_id ) );

433: FND_MESSAGE.set_name( 'AHL', l_msg_data );
434:
435: IF ( p_x_material_req_rec.position_path IS NULL OR
436: p_x_material_req_rec.position_path = FND_API.G_MISS_CHAR ) THEN
437: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.position_path_id ) );
438: ELSE
439: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.position_path );
440: END IF;
441:

Line 439: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.position_path );

435: IF ( p_x_material_req_rec.position_path IS NULL OR
436: p_x_material_req_rec.position_path = FND_API.G_MISS_CHAR ) THEN
437: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.position_path_id ) );
438: ELSE
439: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.position_path );
440: END IF;
441:
442: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
443: FND_MSG_PUB.add;

Line 442: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

438: ELSE
439: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.position_path );
440: END IF;
441:
442: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
443: FND_MSG_PUB.add;
444: x_return_status := l_return_status;
445: END IF;
446:

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

462: p_x_item_group_id => p_x_material_req_rec.item_group_id
463: );
464:
465: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
466: FND_MESSAGE.set_name( 'AHL', l_msg_data );
467:
468: IF ( p_x_material_req_rec.item_group_name IS NULL OR
469: p_x_material_req_rec.item_group_name = FND_API.G_MISS_CHAR ) THEN
470: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_group_id ) );

Line 470: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_group_id ) );

466: FND_MESSAGE.set_name( 'AHL', l_msg_data );
467:
468: IF ( p_x_material_req_rec.item_group_name IS NULL OR
469: p_x_material_req_rec.item_group_name = FND_API.G_MISS_CHAR ) THEN
470: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_group_id ) );
471: ELSE
472: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_group_name );
473: END IF;
474:

Line 472: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_group_name );

468: IF ( p_x_material_req_rec.item_group_name IS NULL OR
469: p_x_material_req_rec.item_group_name = FND_API.G_MISS_CHAR ) THEN
470: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.item_group_id ) );
471: ELSE
472: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_group_name );
473: END IF;
474:
475: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
476: FND_MSG_PUB.add;

Line 475: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

471: ELSE
472: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_group_name );
473: END IF;
474:
475: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
476: FND_MSG_PUB.add;
477: x_return_status := l_return_status;
478: END IF;
479:

Line 499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INV_ITEM_COMP_MAT' );

495: IF l_item_comp_detail_id IS NOT NULL
496: THEN
497: p_x_material_req_rec.item_comp_detail_id := l_item_comp_detail_id;
498: ELSE
499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INV_ITEM_COMP_MAT' );
500: FND_MESSAGE.set_token( 'FIELD',p_x_material_req_rec.item_group_name);
501: FND_MSG_PUB.add;
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: END IF; -- l_item_comp_detail_id is null

Line 500: FND_MESSAGE.set_token( 'FIELD',p_x_material_req_rec.item_group_name);

496: THEN
497: p_x_material_req_rec.item_comp_detail_id := l_item_comp_detail_id;
498: ELSE
499: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INV_ITEM_COMP_MAT' );
500: FND_MESSAGE.set_token( 'FIELD',p_x_material_req_rec.item_group_name);
501: FND_MSG_PUB.add;
502: x_return_status := FND_API.G_RET_STS_ERROR;
503: END IF; -- l_item_comp_detail_id is null
504: END IF; -- which association if

Line 540: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );

536: END IF;
537:
538: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
539: IF ( l_msg_data = 'AHL_COM_INVALID_ITEM' ) THEN
540: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
541: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
542: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
543: ELSIF ( l_msg_data = 'AHL_COM_SERVICE_ITEM' ) THEN
544: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SERVICE_ITEM' );

Line 542: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );

538: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
539: IF ( l_msg_data = 'AHL_COM_INVALID_ITEM' ) THEN
540: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
541: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
542: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
543: ELSIF ( l_msg_data = 'AHL_COM_SERVICE_ITEM' ) THEN
544: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SERVICE_ITEM' );
545: ELSE
546: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 544: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SERVICE_ITEM' );

540: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
541: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
542: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
543: ELSIF ( l_msg_data = 'AHL_COM_SERVICE_ITEM' ) THEN
544: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SERVICE_ITEM' );
545: ELSE
546: FND_MESSAGE.set_name( 'AHL', l_msg_data );
547: END IF;
548:

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

542: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
543: ELSIF ( l_msg_data = 'AHL_COM_SERVICE_ITEM' ) THEN
544: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_SERVICE_ITEM' );
545: ELSE
546: FND_MESSAGE.set_name( 'AHL', l_msg_data );
547: END IF;
548:
549: IF ( p_x_material_req_rec.item_number IS NULL OR
550: p_x_material_req_rec.item_number = FND_API.G_MISS_CHAR ) THEN

Line 551: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_material_req_rec.inventory_org_id ) );

547: END IF;
548:
549: IF ( p_x_material_req_rec.item_number IS NULL OR
550: p_x_material_req_rec.item_number = FND_API.G_MISS_CHAR ) THEN
551: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_material_req_rec.inventory_org_id ) );
552: ELSE
553: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_number );
554: END IF;
555:

Line 553: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_number );

549: IF ( p_x_material_req_rec.item_number IS NULL OR
550: p_x_material_req_rec.item_number = FND_API.G_MISS_CHAR ) THEN
551: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_material_req_rec.inventory_org_id ) );
552: ELSE
553: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_number );
554: END IF;
555:
556: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
557: FND_MSG_PUB.add;

Line 556: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

552: ELSE
553: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.item_number );
554: END IF;
555:
556: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
557: FND_MSG_PUB.add;
558: x_return_status := l_return_status;
559: END IF;
560:

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

574: p_x_uom_code => p_x_material_req_rec.uom_code
575: );
576:
577: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
578: FND_MESSAGE.set_name( 'AHL', l_msg_data );
579:
580: IF ( p_x_material_req_rec.uom IS NULL OR
581: p_x_material_req_rec.uom = FND_API.G_MISS_CHAR ) THEN
582: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom_code );

Line 582: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom_code );

578: FND_MESSAGE.set_name( 'AHL', l_msg_data );
579:
580: IF ( p_x_material_req_rec.uom IS NULL OR
581: p_x_material_req_rec.uom = FND_API.G_MISS_CHAR ) THEN
582: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom_code );
583: ELSE
584: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom );
585: END IF;
586:

Line 584: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom );

580: IF ( p_x_material_req_rec.uom IS NULL OR
581: p_x_material_req_rec.uom = FND_API.G_MISS_CHAR ) THEN
582: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom_code );
583: ELSE
584: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom );
585: END IF;
586:
587: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
588: FND_MSG_PUB.add;

Line 587: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

583: ELSE
584: FND_MESSAGE.set_token( 'FIELD', p_x_material_req_rec.uom );
585: END IF;
586:
587: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
588: FND_MSG_PUB.add;
589: x_return_status := l_return_status;
590: END IF;
591:

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

624: p_x_mc_header_id => p_x_route_efct_rec.MC_HEADER_ID
625: );
626:
627: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
628: FND_MESSAGE.set_name( 'AHL', l_msg_data );
629:
630: IF ( p_x_route_efct_rec.MC_NAME IS NULL OR
631: p_x_route_efct_rec.MC_NAME = FND_API.G_MISS_CHAR ) THEN
632: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.MC_HEADER_ID ) );

Line 632: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.MC_HEADER_ID ) );

628: FND_MESSAGE.set_name( 'AHL', l_msg_data );
629:
630: IF ( p_x_route_efct_rec.MC_NAME IS NULL OR
631: p_x_route_efct_rec.MC_NAME = FND_API.G_MISS_CHAR ) THEN
632: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.MC_HEADER_ID ) );
633: ELSE
634: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.MC_NAME );
635: END IF;
636:

Line 634: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.MC_NAME );

630: IF ( p_x_route_efct_rec.MC_NAME IS NULL OR
631: p_x_route_efct_rec.MC_NAME = FND_API.G_MISS_CHAR ) THEN
632: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.MC_HEADER_ID ) );
633: ELSE
634: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.MC_NAME );
635: END IF;
636:
637: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec(i) ) );
638: FND_MSG_PUB.add;

Line 637: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec(i) ) );

633: ELSE
634: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.MC_NAME );
635: END IF;
636:
637: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec(i) ) );
638: FND_MSG_PUB.add;
639: x_return_status := l_return_status;
640: END IF;
641:

Line 666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );

662: );
663:
664: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
665: IF ( l_msg_data = 'AHL_COM_INVALID_ITEM' ) THEN
666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
667: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
669: ELSIF ( l_msg_data = 'AHL_COM_effectivity_ITEM' ) THEN
670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_effectivity_ITEM' );

Line 668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );

664: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
665: IF ( l_msg_data = 'AHL_COM_INVALID_ITEM' ) THEN
666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
667: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
669: ELSIF ( l_msg_data = 'AHL_COM_effectivity_ITEM' ) THEN
670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_effectivity_ITEM' );
671: ELSE
672: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_effectivity_ITEM' );

666: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_ITEM' );
667: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_ITEMS' ) THEN
668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
669: ELSIF ( l_msg_data = 'AHL_COM_effectivity_ITEM' ) THEN
670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_effectivity_ITEM' );
671: ELSE
672: FND_MESSAGE.set_name( 'AHL', l_msg_data );
673: END IF;
674:

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

668: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_ITEMS' );
669: ELSIF ( l_msg_data = 'AHL_COM_effectivity_ITEM' ) THEN
670: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_effectivity_ITEM' );
671: ELSE
672: FND_MESSAGE.set_name( 'AHL', l_msg_data );
673: END IF;
674:
675: IF ( p_x_route_efct_rec.item_number IS NULL OR
676: p_x_route_efct_rec.item_number = FND_API.G_MISS_CHAR ) THEN

Line 677: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_route_efct_rec.inventory_master_org_id ) );

673: END IF;
674:
675: IF ( p_x_route_efct_rec.item_number IS NULL OR
676: p_x_route_efct_rec.item_number = FND_API.G_MISS_CHAR ) THEN
677: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_route_efct_rec.inventory_master_org_id ) );
678: ELSE
679: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.item_number );
680: END IF;
681:

Line 679: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.item_number );

675: IF ( p_x_route_efct_rec.item_number IS NULL OR
676: p_x_route_efct_rec.item_number = FND_API.G_MISS_CHAR ) THEN
677: FND_MESSAGE.set_token( 'FIELD', TO_CHAR( p_x_route_efct_rec.inventory_item_id ) || '-' || TO_CHAR( p_x_route_efct_rec.inventory_master_org_id ) );
678: ELSE
679: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.item_number );
680: END IF;
681:
682: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
683: FND_MSG_PUB.add;

Line 682: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

678: ELSE
679: FND_MESSAGE.set_token( 'FIELD', p_x_route_efct_rec.item_number );
680: END IF;
681:
682: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
683: FND_MSG_PUB.add;
684: x_return_status := l_return_status;
685: END IF;
686:

Line 1021: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MTL_REC' );

1017: l_old_material_req_rec.in_service --pdoki added for OGMA 105 issue
1018: ;
1019:
1020: IF get_old_rec%NOTFOUND THEN
1021: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MTL_REC' );
1022: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
1023: FND_MSG_PUB.add;
1024: CLOSE get_old_rec;
1025: RAISE FND_API.G_EXC_ERROR;

Line 1022: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );

1018: ;
1019:
1020: IF get_old_rec%NOTFOUND THEN
1021: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_MTL_REC' );
1022: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_rec ) );
1023: FND_MSG_PUB.add;
1024: CLOSE get_old_rec;
1025: RAISE FND_API.G_EXC_ERROR;
1026: END IF;

Line 1295: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_efct_REC' );

1291: ,l_old_route_efct_rec.attribute14
1292: ,l_old_route_efct_rec.attribute15 ;
1293:
1294: IF get_old_rec%NOTFOUND THEN
1295: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_efct_REC' );
1296: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_efct_rec ) );
1297: FND_MSG_PUB.add;
1298: CLOSE get_old_rec;
1299: RAISE FND_API.G_EXC_ERROR;

Line 1296: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_efct_rec ) );

1292: ,l_old_route_efct_rec.attribute15 ;
1293:
1294: IF get_old_rec%NOTFOUND THEN
1295: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_efct_REC' );
1296: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_route_efct_rec ) );
1297: FND_MSG_PUB.add;
1298: CLOSE get_old_rec;
1299: RAISE FND_API.G_EXC_ERROR;
1300: END IF;

Line 1487: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );

1483: (p_material_req_rec.quantity IS NULL OR p_material_req_rec.quantity = FND_API.G_MISS_NUM)
1484: ) THEN
1485: IF (p_association_type = 'DISPOSITION')
1486: THEN
1487: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );
1488: ELSE
1489: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_NULL' );
1490: END IF;
1491: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

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

1485: IF (p_association_type = 'DISPOSITION')
1486: THEN
1487: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );
1488: ELSE
1489: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_NULL' );
1490: END IF;
1491: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1492: FND_MSG_PUB.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1491: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1487: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );
1488: ELSE
1489: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_NULL' );
1490: END IF;
1491: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1492: FND_MSG_PUB.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: ELSIF ( p_material_req_rec.dml_operation <> 'D' AND
1495: p_material_req_rec.quantity <= 0 ) THEN

Line 1496: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_LESS_ZERO' );

1492: FND_MSG_PUB.add;
1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: ELSIF ( p_material_req_rec.dml_operation <> 'D' AND
1495: p_material_req_rec.quantity <= 0 ) THEN
1496: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_LESS_ZERO' );
1497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1498: FND_MSG_PUB.add;
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: ELSIF ( p_material_req_rec.dml_operation <> 'D' AND

Line 1497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1493: x_return_status := FND_API.G_RET_STS_ERROR;
1494: ELSIF ( p_material_req_rec.dml_operation <> 'D' AND
1495: p_material_req_rec.quantity <= 0 ) THEN
1496: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_QTY_LESS_ZERO' );
1497: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1498: FND_MSG_PUB.add;
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: ELSIF ( p_material_req_rec.dml_operation <> 'D' AND
1501: p_association_type = 'DISPOSITION'

Line 1506: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );

1502: AND
1503: (p_material_req_rec.INVENTORY_ITEM_ID IS NOT NULL OR p_material_req_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM )
1504: AND
1505: (p_material_req_rec.quantity IS NULL OR p_material_req_rec.quantity = FND_API.G_MISS_NUM) ) THEN
1506: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );
1507: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1508: FND_MSG_PUB.add;
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: END IF;

Line 1507: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1503: (p_material_req_rec.INVENTORY_ITEM_ID IS NOT NULL OR p_material_req_rec.INVENTORY_ITEM_ID <> FND_API.G_MISS_NUM )
1504: AND
1505: (p_material_req_rec.quantity IS NULL OR p_material_req_rec.quantity = FND_API.G_MISS_NUM) ) THEN
1506: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_ITEM_QTY_NULL' );
1507: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1508: FND_MSG_PUB.add;
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: END IF;
1511:

Line 1520: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );

1516: p_material_req_rec.uom_code IS NULL ) OR
1517: ( p_material_req_rec.uom = FND_API.G_MISS_CHAR AND
1518: p_material_req_rec.uom_code = FND_API.G_MISS_CHAR ) )
1519: THEN
1520: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );
1521: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1522: FND_MSG_PUB.add;
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: /*

Line 1521: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1517: ( p_material_req_rec.uom = FND_API.G_MISS_CHAR AND
1518: p_material_req_rec.uom_code = FND_API.G_MISS_CHAR ) )
1519: THEN
1520: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );
1521: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1522: FND_MSG_PUB.add;
1523: x_return_status := FND_API.G_RET_STS_ERROR;
1524: /*
1525: ELSIF

Line 1538: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );

1534: OR
1535: (p_material_req_rec.uom = FND_API.G_MISS_CHAR AND p_material_req_rec.uom_code = FND_API.G_MISS_CHAR)
1536: )
1537: THEN
1538: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );
1539: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1540: FND_MSG_PUB.add;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: */

Line 1539: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1535: (p_material_req_rec.uom = FND_API.G_MISS_CHAR AND p_material_req_rec.uom_code = FND_API.G_MISS_CHAR)
1536: )
1537: THEN
1538: FND_MESSAGE.set_name( 'AHL','AHL_RM_UOM_NULL' );
1539: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1540: FND_MSG_PUB.add;
1541: x_return_status := FND_API.G_RET_STS_ERROR;
1542: */
1543: END IF;

Line 1561: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );

1557: AND (p_material_req_rec.INVENTORY_ITEM_ID IS NULL OR p_material_req_rec.INVENTORY_ITEM_ID = FND_API.G_MISS_NUM )
1558: )
1559: )
1560: THEN
1561: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );
1562: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );
1563: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1564: FND_MSG_PUB.add;
1565: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1562: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );

1558: )
1559: )
1560: THEN
1561: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );
1562: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );
1563: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1564: FND_MSG_PUB.add;
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: END IF ;

Line 1563: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1559: )
1560: THEN
1561: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );
1562: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );
1563: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1564: FND_MSG_PUB.add;
1565: x_return_status := FND_API.G_RET_STS_ERROR;
1566: END IF ;
1567:

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

1571: ( p_material_req_rec.REPLACE_PERCENT IS NULL OR
1572: p_material_req_rec.REPLACE_PERCENT = FND_API.G_MISS_NUM )
1573: )
1574: THEN
1575: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_NULL' );
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1577: FND_MSG_PUB.add;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579:

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

1572: p_material_req_rec.REPLACE_PERCENT = FND_API.G_MISS_NUM )
1573: )
1574: THEN
1575: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_NULL' );
1576: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1577: FND_MSG_PUB.add;
1578: x_return_status := FND_API.G_RET_STS_ERROR;
1579:
1580: ELSIF ( p_association_type = 'DISPOSITION' AND

Line 1585: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );

1581: p_material_req_rec.dml_operation <> 'D' AND
1582: NOT ( p_material_req_rec.REPLACE_PERCENT BETWEEN 0 AND 100 )
1583: )
1584: THEN
1585: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );
1586: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1587: FND_MSG_PUB.add;
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589:

Line 1586: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1582: NOT ( p_material_req_rec.REPLACE_PERCENT BETWEEN 0 AND 100 )
1583: )
1584: THEN
1585: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REPLACE_INVALID' );
1586: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1587: FND_MSG_PUB.add;
1588: x_return_status := FND_API.G_RET_STS_ERROR;
1589:
1590: END IF;

Line 1619: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_NULL' );

1615: AND
1616: ( p_material_req_rec.REWORK_PERCENT IS NULL OR p_material_req_rec.REWORK_PERCENT = FND_API.G_MISS_NUM )
1617: )
1618: THEN
1619: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_NULL' );
1620: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1621: FND_MSG_PUB.add;
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623: ELSIF ( p_association_type = 'DISPOSITION' AND

Line 1620: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1616: ( p_material_req_rec.REWORK_PERCENT IS NULL OR p_material_req_rec.REWORK_PERCENT = FND_API.G_MISS_NUM )
1617: )
1618: THEN
1619: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_NULL' );
1620: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1621: FND_MSG_PUB.add;
1622: x_return_status := FND_API.G_RET_STS_ERROR;
1623: ELSIF ( p_association_type = 'DISPOSITION' AND
1624: p_material_req_rec.dml_operation <> 'D'

Line 1637: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );

1633: )
1634: AND NOT ( p_material_req_rec.REWORK_PERCENT BETWEEN 0 AND 100 )
1635: )
1636: THEN
1637: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );
1638: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1639: FND_MSG_PUB.add;
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641:

Line 1638: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1634: AND NOT ( p_material_req_rec.REWORK_PERCENT BETWEEN 0 AND 100 )
1635: )
1636: THEN
1637: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_INVALID' );
1638: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1639: FND_MSG_PUB.add;
1640: x_return_status := FND_API.G_RET_STS_ERROR;
1641:
1642: END IF;

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

1665:
1666: )
1667: )
1668: THEN
1669: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_NOT_REQ' );
1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1671: FND_MSG_PUB.add;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: END IF;

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

1666: )
1667: )
1668: THEN
1669: FND_MESSAGE.set_name( 'AHL','AHL_RM_DISP_REWORK_NOT_REQ' );
1670: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1671: FND_MSG_PUB.add;
1672: x_return_status := FND_API.G_RET_STS_ERROR;
1673: END IF;
1674:

Line 1683: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_ID_NULL' );

1679:
1680: -- Check if the mandatory Effectivity ID column contains a null value.
1681: IF ( p_material_req_rec.rt_oper_material_id IS NULL OR
1682: p_material_req_rec.rt_oper_material_id = FND_API.G_MISS_NUM ) THEN
1683: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_ID_NULL' );
1684: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1685: FND_MSG_PUB.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: RETURN;

Line 1684: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1680: -- Check if the mandatory Effectivity ID column contains a null value.
1681: IF ( p_material_req_rec.rt_oper_material_id IS NULL OR
1682: p_material_req_rec.rt_oper_material_id = FND_API.G_MISS_NUM ) THEN
1683: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_ID_NULL' );
1684: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1685: FND_MSG_PUB.add;
1686: x_return_status := FND_API.G_RET_STS_ERROR;
1687: RETURN;
1688: END IF;

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

1689:
1690: -- Check if the mandatory Object Version Number column contains a null value.
1691: IF ( p_material_req_rec.object_version_number IS NULL OR
1692: p_material_req_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1693: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_OBJ_VERSION_NULL' );
1694: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1695: FND_MSG_PUB.add;
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: RETURN;

Line 1694: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1690: -- Check if the mandatory Object Version Number column contains a null value.
1691: IF ( p_material_req_rec.object_version_number IS NULL OR
1692: p_material_req_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1693: FND_MESSAGE.set_name( 'AHL','AHL_RM_MTL_OBJ_VERSION_NULL' );
1694: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1695: FND_MSG_PUB.add;
1696: x_return_status := FND_API.G_RET_STS_ERROR;
1697: RETURN;
1698: END IF;

Line 1723: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ID_NULL' );

1719:
1720: -- Check if the mandatory column contains a null value.
1721: IF ( p_route_efct_rec.ROUTE_EFFECTIVITY_ID IS NULL OR
1722: p_route_efct_rec.ROUTE_EFFECTIVITY_ID = FND_API.G_MISS_NUM ) THEN
1723: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ID_NULL' );
1724: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1725: FND_MSG_PUB.add;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: RETURN;

Line 1724: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1720: -- Check if the mandatory column contains a null value.
1721: IF ( p_route_efct_rec.ROUTE_EFFECTIVITY_ID IS NULL OR
1722: p_route_efct_rec.ROUTE_EFFECTIVITY_ID = FND_API.G_MISS_NUM ) THEN
1723: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ID_NULL' );
1724: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1725: FND_MSG_PUB.add;
1726: x_return_status := FND_API.G_RET_STS_ERROR;
1727: RETURN;
1728: END IF;

Line 1733: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_OBJ_VERSION_NULL' );

1729:
1730: -- Check if the mandatory Object Version Number column contains a null value.
1731: IF ( p_route_efct_rec.object_version_number IS NULL OR
1732: p_route_efct_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1733: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_OBJ_VERSION_NULL' );
1734: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1735: FND_MSG_PUB.add;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: RETURN;

Line 1734: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1730: -- Check if the mandatory Object Version Number column contains a null value.
1731: IF ( p_route_efct_rec.object_version_number IS NULL OR
1732: p_route_efct_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
1733: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_OBJ_VERSION_NULL' );
1734: -- FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1735: FND_MSG_PUB.add;
1736: x_return_status := FND_API.G_RET_STS_ERROR;
1737: RETURN;
1738: END IF;

Line 1764: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NULL' );

1760: p_material_req_rec.item_group_name IS NULL AND
1761: p_material_req_rec.inventory_item_id IS NULL AND
1762: p_material_req_rec.inventory_org_id IS NULL AND
1763: p_material_req_rec.item_number IS NULL ) THEN
1764: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NULL' );
1765: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1766: FND_MSG_PUB.add;
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;

Line 1765: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1761: p_material_req_rec.inventory_item_id IS NULL AND
1762: p_material_req_rec.inventory_org_id IS NULL AND
1763: p_material_req_rec.item_number IS NULL ) THEN
1764: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NULL' );
1765: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1766: FND_MSG_PUB.add;
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768: END IF;
1769:

Line 1778: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NOTNULL' );

1774: p_material_req_rec.inventory_org_id IS NOT NULL OR
1775: p_material_req_rec.item_number IS NOT NULL ) AND
1776: ( p_material_req_rec.item_group_id IS NOT NULL OR
1777: p_material_req_rec.item_group_name IS NOT NULL ) ) THEN
1778: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NOTNULL' );
1779: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1780: FND_MSG_PUB.add;
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: END IF;

Line 1779: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1775: p_material_req_rec.item_number IS NOT NULL ) AND
1776: ( p_material_req_rec.item_group_id IS NOT NULL OR
1777: p_material_req_rec.item_group_name IS NOT NULL ) ) THEN
1778: FND_MESSAGE.set_name( 'AHL','AHL_RM_ITEMGRP_ITEM_NOTNULL' );
1779: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1780: FND_MSG_PUB.add;
1781: x_return_status := FND_API.G_RET_STS_ERROR;
1782: END IF;
1783:

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

1796: p_uom_code => p_material_req_rec.uom_code
1797: );
1798:
1799: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1800: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1801: IF ( p_material_req_rec.uom IS NULL ) THEN
1802: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom_code );
1803: ELSE
1804: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom );

Line 1802: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom_code );

1798:
1799: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
1800: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1801: IF ( p_material_req_rec.uom IS NULL ) THEN
1802: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom_code );
1803: ELSE
1804: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom );
1805: END IF;
1806:

Line 1804: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom );

1800: FND_MESSAGE.set_name( 'AHL', l_msg_data );
1801: IF ( p_material_req_rec.uom IS NULL ) THEN
1802: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom_code );
1803: ELSE
1804: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom );
1805: END IF;
1806:
1807: IF ( p_material_req_rec.item_number IS NOT NULL ) THEN
1808: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_number );

Line 1808: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_number );

1804: FND_MESSAGE.set_token( 'FIELD1', p_material_req_rec.uom );
1805: END IF;
1806:
1807: IF ( p_material_req_rec.item_number IS NOT NULL ) THEN
1808: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_number );
1809: ELSIF ( p_material_req_rec.inventory_item_id IS NOT NULL AND
1810: p_material_req_rec.inventory_org_id IS NOT NULL ) THEN
1811: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_material_req_rec.inventory_org_id ) );
1812: ELSIF ( p_material_req_rec.item_group_name IS NOT NULL ) THEN

Line 1811: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_material_req_rec.inventory_org_id ) );

1807: IF ( p_material_req_rec.item_number IS NOT NULL ) THEN
1808: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_number );
1809: ELSIF ( p_material_req_rec.inventory_item_id IS NOT NULL AND
1810: p_material_req_rec.inventory_org_id IS NOT NULL ) THEN
1811: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_material_req_rec.inventory_org_id ) );
1812: ELSIF ( p_material_req_rec.item_group_name IS NOT NULL ) THEN
1813: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_group_name );
1814: ELSIF ( p_material_req_rec.item_group_id IS NOT NULL ) THEN
1815: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.item_group_id ) );

Line 1813: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_group_name );

1809: ELSIF ( p_material_req_rec.inventory_item_id IS NOT NULL AND
1810: p_material_req_rec.inventory_org_id IS NOT NULL ) THEN
1811: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_material_req_rec.inventory_org_id ) );
1812: ELSIF ( p_material_req_rec.item_group_name IS NOT NULL ) THEN
1813: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_group_name );
1814: ELSIF ( p_material_req_rec.item_group_id IS NOT NULL ) THEN
1815: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.item_group_id ) );
1816: END IF;
1817:

Line 1815: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.item_group_id ) );

1811: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.inventory_item_id ) || '-' || TO_CHAR( p_material_req_rec.inventory_org_id ) );
1812: ELSIF ( p_material_req_rec.item_group_name IS NOT NULL ) THEN
1813: FND_MESSAGE.set_token( 'FIELD2', p_material_req_rec.item_group_name );
1814: ELSIF ( p_material_req_rec.item_group_id IS NOT NULL ) THEN
1815: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.item_group_id ) );
1816: END IF;
1817:
1818: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1819: FND_MSG_PUB.add;

Line 1818: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );

1814: ELSIF ( p_material_req_rec.item_group_id IS NOT NULL ) THEN
1815: FND_MESSAGE.set_token( 'FIELD2', TO_CHAR( p_material_req_rec.item_group_id ) );
1816: END IF;
1817:
1818: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_material_req_rec ) );
1819: FND_MSG_PUB.add;
1820: x_return_status := l_return_status;
1821: END IF;
1822:

Line 1847: FND_MESSAGE.set_name( 'AHL','AHL_RM_EFCT_ITEM_NULL' );

1843: p_route_efct_rec.mc_name IS NULL AND
1844: p_route_efct_rec.inventory_item_id IS NULL AND
1845: p_route_efct_rec.inventory_master_org_id IS NULL AND
1846: p_route_efct_rec.item_number IS NULL ) THEN
1847: FND_MESSAGE.set_name( 'AHL','AHL_RM_EFCT_ITEM_NULL' );
1848: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1849: FND_MSG_PUB.add;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: END IF;

Line 1848: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );

1844: p_route_efct_rec.inventory_item_id IS NULL AND
1845: p_route_efct_rec.inventory_master_org_id IS NULL AND
1846: p_route_efct_rec.item_number IS NULL ) THEN
1847: FND_MESSAGE.set_name( 'AHL','AHL_RM_EFCT_ITEM_NULL' );
1848: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1849: FND_MSG_PUB.add;
1850: x_return_status := FND_API.G_RET_STS_ERROR;
1851: END IF;
1852:

Line 1866: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_NOTNULL' );

1862: p_route_efct_rec.MC_REVISION IS NOT NULL OR
1863: p_route_efct_rec.MC_HEADER_ID IS NOT NULL
1864: ) )
1865: THEN
1866: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_NOTNULL' );
1867: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1868: FND_MSG_PUB.add;
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: END IF;

Line 1867: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );

1863: p_route_efct_rec.MC_HEADER_ID IS NOT NULL
1864: ) )
1865: THEN
1866: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_NOTNULL' );
1867: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1868: FND_MSG_PUB.add;
1869: x_return_status := FND_API.G_RET_STS_ERROR;
1870: END IF;
1871:

Line 1877: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_ORG_NOTNULL' );

1873: IF ( ( p_route_efct_rec.inventory_item_id IS NOT NULL OR p_route_efct_rec.item_number IS NOT NULL )
1874: AND ( p_route_efct_rec.inventory_master_org_id IS NULL OR p_route_efct_rec.organization_code IS NULL)
1875: )
1876: THEN
1877: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_ORG_NOTNULL' );
1878: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1879: FND_MSG_PUB.add;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: END IF;

Line 1878: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );

1874: AND ( p_route_efct_rec.inventory_master_org_id IS NULL OR p_route_efct_rec.organization_code IS NULL)
1875: )
1876: THEN
1877: FND_MESSAGE.set_name( 'AHL','AHL_RM_efct_ITEM_ORG_NOTNULL' );
1878: -- FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( p_route_efct_rec ) );
1879: FND_MSG_PUB.add;
1880: x_return_status := FND_API.G_RET_STS_ERROR;
1881: END IF;
1882:

Line 1956: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );

1952: AHL_DEBUG_PUB.debug( 'inventory_org_id : ' || l_material_req_rec.inventory_org_id);
1953: END IF;
1954: EXIT WHEN get_dup_rec%NOTFOUND;
1955:
1956: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
1957: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_material_req_rec ) );
1958: FND_MSG_PUB.add;
1959:
1960: END LOOP;

Line 1957: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_material_req_rec ) );

1953: END IF;
1954: EXIT WHEN get_dup_rec%NOTFOUND;
1955:
1956: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
1957: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( l_material_req_rec ) );
1958: FND_MSG_PUB.add;
1959:
1960: END LOOP;
1961:

Line 2092: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_route_efct_REC_DUP' );

2088: l_route_efct_req_rec.MC_REVISION;
2089: CLOSE get_mc_name_and_revision;
2090: --END
2091: IF ( get_dup_rec%FOUND ) THEN
2092: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_route_efct_REC_DUP' );
2093: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( l_route_efct_req_rec ) );
2094: FND_MSG_PUB.add;
2095: END IF ;
2096: END LOOP;

Line 2093: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( l_route_efct_req_rec ) );

2089: CLOSE get_mc_name_and_revision;
2090: --END
2091: IF ( get_dup_rec%FOUND ) THEN
2092: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_route_efct_REC_DUP' );
2093: FND_MESSAGE.set_token( 'RECORD', get_effct_identifier( l_route_efct_req_rec ) );
2094: FND_MSG_PUB.add;
2095: END IF ;
2096: END LOOP;
2097:

Line 2349: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2345: l_return_status
2346: );
2347:
2348: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2349: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2350: FND_MSG_PUB.ADD;
2351: x_return_status := l_return_status;
2352: RETURN;
2353: END IF;

Line 2372: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_efct_REC' );

2368: OPEN get_efct_rec ( p_object_id ) ;
2369: FETCH get_efct_rec INTO l_dummy_number;
2370: IF get_efct_rec%NOTFOUND
2371: THEN
2372: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_efct_REC' );
2373: FND_MSG_PUB.add;
2374: CLOSE get_efct_rec;
2375: RAISE FND_API.G_EXC_ERROR;
2376: END IF;

Line 2388: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2384: l_return_status
2385: );
2386:
2387: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2388: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2389: FND_MSG_PUB.ADD;
2390: x_return_status := l_return_status;
2391: RETURN;
2392: END IF;

Line 2416: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2412: l_return_status
2413: );
2414:
2415: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2416: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2417: FND_MSG_PUB.ADD;
2418: x_return_status := l_return_status;
2419: RETURN;
2420: END IF;

Line 2560: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );

2556:
2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: IF ( SQLCODE = -1 ) THEN
2560: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
2561: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2562: FND_MSG_PUB.add;
2563: ELSE
2564: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2561: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );

2557: EXCEPTION
2558: WHEN OTHERS THEN
2559: IF ( SQLCODE = -1 ) THEN
2560: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
2561: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2562: FND_MSG_PUB.add;
2563: ELSE
2564: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
2565: THEN

Line 2617: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

2613: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2614:
2615: -- If the record does not exist, then, abort API.
2616: IF ( SQL%ROWCOUNT = 0 ) THEN
2617: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
2618: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2619: FND_MSG_PUB.add;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;

Line 2618: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );

2614:
2615: -- If the record does not exist, then, abort API.
2616: IF ( SQL%ROWCOUNT = 0 ) THEN
2617: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
2618: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2619: FND_MSG_PUB.add;
2620: RAISE FND_API.G_EXC_ERROR;
2621: END IF;
2622:

Line 2629: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );

2625:
2626: EXCEPTION
2627: WHEN OTHERS THEN
2628: IF ( SQLCODE = -1 ) THEN
2629: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
2630: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2631: FND_MSG_PUB.add;
2632: RAISE FND_API.G_EXC_ERROR;
2633: ELSE

Line 2630: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );

2626: EXCEPTION
2627: WHEN OTHERS THEN
2628: IF ( SQLCODE = -1 ) THEN
2629: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_MATERIAL_REQ_REC_DUP' );
2630: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_material_req_tbl(i) ) );
2631: FND_MSG_PUB.add;
2632: RAISE FND_API.G_EXC_ERROR;
2633: ELSE
2634: IF (fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 2655: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

2651: AND object_version_number = p_x_material_req_tbl(i).object_version_number;
2652:
2653: -- If the record does not exist, then, abort API.
2654: IF ( SQL%ROWCOUNT = 0 ) THEN
2655: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
2656: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2657: FND_MSG_PUB.add;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;

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

2652:
2653: -- If the record does not exist, then, abort API.
2654: IF ( SQL%ROWCOUNT = 0 ) THEN
2655: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
2656: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
2657: FND_MSG_PUB.add;
2658: RAISE FND_API.G_EXC_ERROR;
2659: END IF;
2660:

Line 2973: FND_MESSAGE.SET_NAME('AHL',l_msg_data);

2969: l_return_status
2970: );
2971:
2972: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
2973: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
2974: FND_MSG_PUB.ADD;
2975: x_return_status := l_return_status;
2976: RETURN;
2977: END IF;

Line 3111: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

3107: AND object_version_number = p_x_route_efct_tbl(i).object_version_number;
3108:
3109: -- If the record does not exist, then, abort API.
3110: IF ( SQL%ROWCOUNT = 0 ) THEN
3111: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3112: -- FND_MESSAGE.set_token( 'RECORD', p_x_route_efct_tbl(i).aso_resource_name );
3113: FND_MSG_PUB.add;
3114: END IF;
3115:

Line 3112: -- FND_MESSAGE.set_token( 'RECORD', p_x_route_efct_tbl(i).aso_resource_name );

3108:
3109: -- If the record does not exist, then, abort API.
3110: IF ( SQL%ROWCOUNT = 0 ) THEN
3111: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3112: -- FND_MESSAGE.set_token( 'RECORD', p_x_route_efct_tbl(i).aso_resource_name );
3113: FND_MSG_PUB.add;
3114: END IF;
3115:
3116: -- Set OUT values

Line 3141: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');

3137:
3138:
3139: -- If the record does not exist, then, abort API.
3140: IF ( SQL%ROWCOUNT = 0 ) THEN
3141: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3142: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
3143: FND_MSG_PUB.add;
3144: END IF;
3145: END IF;

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

3138:
3139: -- If the record does not exist, then, abort API.
3140: IF ( SQL%ROWCOUNT = 0 ) THEN
3141: FND_MESSAGE.set_name('AHL','AHL_RM_RECORD_CHANGED');
3142: FND_MESSAGE.set_token( 'RECORD', TO_CHAR( i ) );
3143: FND_MSG_PUB.add;
3144: END IF;
3145: END IF;
3146: