DBA Data[Home] [Help]

APPS.AHL_RM_RT_OP_DEP_PVT dependencies on FND_MESSAGE

Line 380: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );

376:
377:
378: -- Check if a valid value is passed in p_route_id
379: IF ( p_route_id = FND_API.G_MISS_NUM OR p_route_id IS NULL ) THEN
380: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_ROUTE_ID_NULL' );
381: FND_MSG_PUB.add;
382: x_return_status := FND_API.G_RET_STS_ERROR;
383: RETURN;
384: END IF;

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

391: l_return_status
392: );
393:
394: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
395: FND_MESSAGE.SET_NAME('AHL',l_msg_data);
396: FND_MSG_PUB.ADD;
397: x_return_status := l_return_status;
398: RETURN;
399: END IF;

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

399: END IF;
400:
401: -- Check if at least one record is passed in p_x_rt_oper_dep_tbl
402: IF ( p_x_rt_oper_dep_tbl.count < 1 ) THEN
403: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
404: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || l_api_name );
405: FND_MSG_PUB.add;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RETURN;

Line 404: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || l_api_name );

400:
401: -- Check if at least one record is passed in p_x_rt_oper_dep_tbl
402: IF ( p_x_rt_oper_dep_tbl.count < 1 ) THEN
403: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_PROCEDURE_CALL' );
404: FND_MESSAGE.set_token( 'PROCEDURE', G_PKG_NAME || '.' || l_api_name );
405: FND_MSG_PUB.add;
406: x_return_status := FND_API.G_RET_STS_ERROR;
407: RETURN;
408: END IF;

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

411: FOR i IN 1..p_x_rt_oper_dep_tbl.count LOOP
412: IF ( p_x_rt_oper_dep_tbl(i).dml_operation <> 'C' AND
413: p_x_rt_oper_dep_tbl(i).dml_operation <> 'U' AND
414: p_x_rt_oper_dep_tbl(i).dml_operation <> 'D' ) THEN
415: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_dep_tbl(i) ) );
418: FND_MSG_PUB.add;
419: x_return_status := FND_API.G_RET_STS_ERROR;

Line 416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );

412: IF ( p_x_rt_oper_dep_tbl(i).dml_operation <> 'C' AND
413: p_x_rt_oper_dep_tbl(i).dml_operation <> 'U' AND
414: p_x_rt_oper_dep_tbl(i).dml_operation <> 'D' ) THEN
415: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_dep_tbl(i) ) );
418: FND_MSG_PUB.add;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: RETURN;

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

413: p_x_rt_oper_dep_tbl(i).dml_operation <> 'U' AND
414: p_x_rt_oper_dep_tbl(i).dml_operation <> 'D' ) THEN
415: FND_MESSAGE.set_name( 'AHL', 'AHL_COM_INVALID_DML' );
416: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dml_operation );
417: FND_MESSAGE.set_token( 'RECORD', get_record_identifier( p_x_rt_oper_dep_tbl(i) ) );
418: FND_MSG_PUB.add;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: RETURN;
421: END IF;

Line 431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );

427: p_x_rt_oper_dep_tbl(i).from_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).from_op_number IS NULL OR
428: p_x_rt_oper_dep_tbl(i).from_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).from_op_status IS NULL OR
429: p_x_rt_oper_dep_tbl(i).from_op_status = FND_API.G_MISS_CHAR ))
430: THEN
431: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
432: FND_MSG_PUB.add;
433: x_return_status := FND_API.G_RET_STS_ERROR;
434: RETURN;
435: END IF;

Line 446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );

442: p_x_rt_oper_dep_tbl(i).to_op_step = FND_API.G_MISS_NUM ) OR(p_x_rt_oper_dep_tbl(i).to_op_number IS NULL OR
443: p_x_rt_oper_dep_tbl(i).to_op_number = FND_API.G_MISS_CHAR ) OR(p_x_rt_oper_dep_tbl(i).to_op_status IS NULL OR
444: p_x_rt_oper_dep_tbl(i).to_op_status = FND_API.G_MISS_CHAR ))
445: THEN
446: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_DEP_STEP_NUM_STA_MAN' );
447: FND_MSG_PUB.add;
448: x_return_status := FND_API.G_RET_STS_ERROR;
449: END IF;
450: END IF;

Line 502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');

498:
499: IF (l_rt_operation_id IS NULL )
500: THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;

Line 503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);

499: IF (l_rt_operation_id IS NULL )
500: THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;
507:

Line 504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);

500: THEN
501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;
507:
508: IF (G_DEBUG = 'Y') THEN

Line 505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);

501: x_return_status := FND_API.G_RET_STS_ERROR;
502: FND_MESSAGE.SET_NAME('AHL','AHL_RM_INV_ROUTE_OPER_ASSO');
503: FND_MESSAGE.SET_TOKEN('NUMBER', p_operation_number);
504: FND_MESSAGE.SET_TOKEN('STEP', p_operation_step);
505: FND_MESSAGE.SET_TOKEN('STATUS', p_operation_status);
506: FND_MSG_PUB.ADD;
507:
508: IF (G_DEBUG = 'Y') THEN
509: AHL_DEBUG_PUB.debug(G_PKG_NAME||'.'||l_api_name||': INVALID Operation Name , Operation Step and Status' );

Line 571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');

567: END IF;
568:
569: EXCEPTION
570: WHEN l_cyclic_loop THEN
571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');
572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);

568:
569: EXCEPTION
570: WHEN l_cyclic_loop THEN
571: FND_MESSAGE.SET_NAME('AHL','AHL_RM_RT_OPSTEP_INVALID_CYC');
572: FND_MESSAGE.SET_TOKEN('RECORD',p_from_op_step ,false);
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_ERROR;
575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
576: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 772: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');

768: OPEN validate_oper_step(p_route_id,p_x_rt_oper_dep_tbl(i).from_rt_op_id);
769: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).from_op_step;
770: IF (validate_oper_step%NOTFOUND)
771: THEN
772: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
773: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
774: FND_MSG_PUB.add;
775: END IF;
776: CLOSE validate_oper_step;

Line 773: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );

769: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).from_op_step;
770: IF (validate_oper_step%NOTFOUND)
771: THEN
772: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
773: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
774: FND_MSG_PUB.add;
775: END IF;
776: CLOSE validate_oper_step;
777: END IF;

Line 809: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');

805: OPEN validate_oper_step(p_route_id,p_x_rt_oper_dep_tbl(i).to_rt_op_id);
806: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).to_op_step;
807: IF (validate_oper_step%NOTFOUND)
808: THEN
809: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
810: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
811: FND_MSG_PUB.add;
812: END IF;
813: CLOSE validate_oper_step;

Line 810: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );

806: FETCH validate_oper_step INTO p_x_rt_oper_dep_tbl(i).to_op_step;
807: IF (validate_oper_step%NOTFOUND)
808: THEN
809: FND_MESSAGE.set_name('AHL', 'AHL_RM_OPER_NOT_ASSO');
810: FND_MESSAGE.set_token( 'NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
811: FND_MSG_PUB.add;
812: END IF;
813: CLOSE validate_oper_step;
814: END IF;

Line 833: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );

829: );
830:
831: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
832: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
833: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
834: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
835: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_DEP_TYPES' );
836: ELSE
837: FND_MESSAGE.set_name( 'AHL', l_msg_data );

Line 835: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_DEP_TYPES' );

831: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
832: IF ( l_msg_data = 'AHL_COM_INVALID_LOOKUP' ) THEN
833: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
834: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
835: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_DEP_TYPES' );
836: ELSE
837: FND_MESSAGE.set_name( 'AHL', l_msg_data );
838: END IF;
839:

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

833: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_INVALID_DEP_TYPE' );
834: ELSIF ( l_msg_data = 'AHL_COM_TOO_MANY_LOOKUPS' ) THEN
835: FND_MESSAGE.set_name( 'AHL', 'AHL_RM_TOO_MANY_DEP_TYPES' );
836: ELSE
837: FND_MESSAGE.set_name( 'AHL', l_msg_data );
838: END IF;
839:
840: IF ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NULL OR
841: p_x_rt_oper_dep_tbl(i).dependency_mean = FND_API.G_MISS_CHAR ) THEN

Line 842: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_code );

838: END IF;
839:
840: IF ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NULL OR
841: p_x_rt_oper_dep_tbl(i).dependency_mean = FND_API.G_MISS_CHAR ) THEN
842: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_code );
843: ELSE
844: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_mean );
845: END IF;
846: FND_MSG_PUB.add;

Line 844: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_mean );

840: IF ( p_x_rt_oper_dep_tbl(i).dependency_mean IS NULL OR
841: p_x_rt_oper_dep_tbl(i).dependency_mean = FND_API.G_MISS_CHAR ) THEN
842: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_code );
843: ELSE
844: FND_MESSAGE.set_token( 'FIELD', p_x_rt_oper_dep_tbl(i).dependency_mean );
845: END IF;
846: FND_MSG_PUB.add;
847: END IF;
848:

Line 855: FND_MESSAGE.set_name('AHL', 'AHL_RM_DEP_SAME_OP');

851: -- Throw Error if From Operation Number and To Operation Number is same.
852:
853: IF (p_x_rt_oper_dep_tbl(i).from_op_step = p_x_rt_oper_dep_tbl(i).to_op_step)
854: THEN
855: FND_MESSAGE.set_name('AHL', 'AHL_RM_DEP_SAME_OP');
856: FND_MSG_PUB.add;
857: END IF;
858:
859: END IF;

Line 868: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');

864: OPEN validate_depen_ovn(p_x_rt_oper_dep_tbl(i).rt_op_dependency_id,p_x_rt_oper_dep_tbl(i).object_version_number);
865: FETCH validate_depen_ovn INTO l_dummy;
866: IF (validate_depen_ovn%NOTFOUND)
867: THEN
868: FND_MESSAGE.set_name('AHL', 'AHL_COM_RECORD_CHANGED');
869: FND_MSG_PUB.add;
870: END IF;
871: CLOSE validate_depen_ovn;
872: END IF;

Line 902: FND_MESSAGE.SET_NAME( 'AHL', L_MSG_DATA );

898: x_res_max_duration => l_res_max_duration
899: );
900:
901: IF ( NVL( l_return_status, 'X' ) <> FND_API.G_RET_STS_SUCCESS ) THEN
902: FND_MESSAGE.SET_NAME( 'AHL', L_MSG_DATA );
903: -- sansatpa added the below if condition to distinguish between error messages
904: IF(L_MSG_DATA = 'AHL_COM_INVALID_PROCEDURE_CALL')
905: THEN
906: FND_MESSAGE.set_token( 'PROCEDURE', 'AHL_RM_ROUTE_UTIL.VALIDATE_ROUTE_TIME_SPAN' );

Line 906: FND_MESSAGE.set_token( 'PROCEDURE', 'AHL_RM_ROUTE_UTIL.VALIDATE_ROUTE_TIME_SPAN' );

902: FND_MESSAGE.SET_NAME( 'AHL', L_MSG_DATA );
903: -- sansatpa added the below if condition to distinguish between error messages
904: IF(L_MSG_DATA = 'AHL_COM_INVALID_PROCEDURE_CALL')
905: THEN
906: FND_MESSAGE.set_token( 'PROCEDURE', 'AHL_RM_ROUTE_UTIL.VALIDATE_ROUTE_TIME_SPAN' );
907: ELSE
908: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
909: FND_MESSAGE.set_token( 'FIELD2', l_route_time_span );
910: END IF;

Line 908: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );

904: IF(L_MSG_DATA = 'AHL_COM_INVALID_PROCEDURE_CALL')
905: THEN
906: FND_MESSAGE.set_token( 'PROCEDURE', 'AHL_RM_ROUTE_UTIL.VALIDATE_ROUTE_TIME_SPAN' );
907: ELSE
908: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
909: FND_MESSAGE.set_token( 'FIELD2', l_route_time_span );
910: END IF;
911: FND_MSG_PUB.add;
912: END IF;

Line 909: FND_MESSAGE.set_token( 'FIELD2', l_route_time_span );

905: THEN
906: FND_MESSAGE.set_token( 'PROCEDURE', 'AHL_RM_ROUTE_UTIL.VALIDATE_ROUTE_TIME_SPAN' );
907: ELSE
908: FND_MESSAGE.set_token( 'FIELD1', l_res_max_duration );
909: FND_MESSAGE.set_token( 'FIELD2', l_route_time_span );
910: END IF;
911: FND_MSG_PUB.add;
912: END IF;
913:

Line 938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');

934: OPEN duplicate_depen(p_route_id,p_x_rt_oper_dep_tbl(i).from_rt_op_id,p_x_rt_oper_dep_tbl(i).to_rt_op_id, p_x_rt_oper_dep_tbl(i).dependency_code);
935: FETCH duplicate_depen INTO l_dummy;
936: IF (duplicate_depen%FOUND)
937: THEN
938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
941: FND_MSG_PUB.add;
942: RAISE FND_API.G_EXC_ERROR;

Line 939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );

935: FETCH duplicate_depen INTO l_dummy;
936: IF (duplicate_depen%FOUND)
937: THEN
938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
941: FND_MSG_PUB.add;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;

Line 940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );

936: IF (duplicate_depen%FOUND)
937: THEN
938: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
939: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
940: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
941: FND_MSG_PUB.add;
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944: CLOSE duplicate_depen;

Line 990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');

986: OPEN duplicate_depen(p_route_id,p_x_rt_oper_dep_tbl(i).from_rt_op_id,p_x_rt_oper_dep_tbl(i).to_rt_op_id, NULL);
987: FETCH duplicate_depen INTO l_dummy;
988: IF (duplicate_depen%FOUND)
989: THEN
990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
993: FND_MSG_PUB.add;
994: RAISE FND_API.G_EXC_ERROR;

Line 991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );

987: FETCH duplicate_depen INTO l_dummy;
988: IF (duplicate_depen%FOUND)
989: THEN
990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
993: FND_MSG_PUB.add;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;

Line 992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );

988: IF (duplicate_depen%FOUND)
989: THEN
990: FND_MESSAGE.set_name('AHL', 'AHL_RM_DUP_DEPEND');
991: FND_MESSAGE.set_token( 'FROM_NUMBER', p_x_rt_oper_dep_tbl(i).from_op_number );
992: FND_MESSAGE.set_token( 'TO_NUMBER', p_x_rt_oper_dep_tbl(i).to_op_number );
993: FND_MSG_PUB.add;
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: CLOSE duplicate_depen;