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

Line 823: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');

819: OPEN get_operation(p_x_prd_workoper_rec.OPERATION_CODE);
820: FETCH get_operation INTO p_x_prd_workoper_rec.OPERATION_ID;
821:
822: IF get_operation%NOTFOUND THEN
823: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');
824: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);
825: FND_MSG_PUB.ADD;
826: END IF;
827: CLOSE get_operation;

Line 824: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);

820: FETCH get_operation INTO p_x_prd_workoper_rec.OPERATION_ID;
821:
822: IF get_operation%NOTFOUND THEN
823: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');
824: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);
825: FND_MSG_PUB.ADD;
826: END IF;
827: CLOSE get_operation;
828: END IF;

Line 846: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');

842:
843: IF p_x_prd_workoper_rec.operation_code IS NOT NULL AND
844: l_operation_id IS NULL
845: THEN
846: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');
847: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);
848: FND_MSG_PUB.ADD;
849: ELSE
850: p_x_prd_workoper_rec.OPERATION_ID := l_operation_id;

Line 847: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);

843: IF p_x_prd_workoper_rec.operation_code IS NOT NULL AND
844: l_operation_id IS NULL
845: THEN
846: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');
847: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.operation_sequence_num,false);
848: FND_MSG_PUB.ADD;
849: ELSE
850: p_x_prd_workoper_rec.OPERATION_ID := l_operation_id;
851: END IF;

Line 859: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');

855: OPEN get_department(p_x_prd_workoper_rec.department_name,p_x_prd_workoper_rec.organization_id);
856: FETCH get_department INTO l_dept_rec;
857:
858: IF get_department%NOTFOUND THEN
859: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');
860: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.department_name,false);
861: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
862: FND_MSG_PUB.ADD;
863: ELSIF get_department%FOUND THEN

Line 860: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.department_name,false);

856: FETCH get_department INTO l_dept_rec;
857:
858: IF get_department%NOTFOUND THEN
859: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');
860: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.department_name,false);
861: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
862: FND_MSG_PUB.ADD;
863: ELSIF get_department%FOUND THEN
864: p_x_prd_workoper_rec.department_id:=l_dept_rec.department_id;

Line 861: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);

857:
858: IF get_department%NOTFOUND THEN
859: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');
860: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.department_name,false);
861: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
862: FND_MSG_PUB.ADD;
863: ELSIF get_department%FOUND THEN
864: p_x_prd_workoper_rec.department_id:=l_dept_rec.department_id;
865: END IF;

Line 875: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_TYPE_INVALID');

871: OPEN get_operation_type(p_x_prd_workoper_rec.OPERATION_TYPE);
872: FETCH get_operation_type INTO p_x_prd_workoper_rec.OPERATION_TYPE_CODE;
873:
874: IF get_operation_type%NOTFOUND THEN
875: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_TYPE_INVALID');
876: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.OPERATION_TYPE,false);
877: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
878: FND_MSG_PUB.ADD;
879: END IF;

Line 876: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.OPERATION_TYPE,false);

872: FETCH get_operation_type INTO p_x_prd_workoper_rec.OPERATION_TYPE_CODE;
873:
874: IF get_operation_type%NOTFOUND THEN
875: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_TYPE_INVALID');
876: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.OPERATION_TYPE,false);
877: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
878: FND_MSG_PUB.ADD;
879: END IF;
880: CLOSE get_operation_type;

Line 877: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);

873:
874: IF get_operation_type%NOTFOUND THEN
875: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_TYPE_INVALID');
876: FND_MESSAGE.SET_TOKEN('FIELD1',p_x_prd_workoper_rec.OPERATION_TYPE,false);
877: FND_MESSAGE.SET_TOKEN('RECORD',p_x_prd_workoper_rec.operation_sequence_num,false);
878: FND_MSG_PUB.ADD;
879: END IF;
880: CLOSE get_operation_type;
881: END IF;

Line 1036: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');

1032: FETCH get_wo_status INTO l_wo_status_code, l_wo_status;
1033: CLOSE get_wo_status;
1034:
1035: IF l_wo_status_code IN ('4', '5', '7', '12') THEN
1036: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');
1037: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);
1038: FND_MSG_PUB.ADD;
1039: END IF;
1040:

Line 1037: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);

1033: CLOSE get_wo_status;
1034:
1035: IF l_wo_status_code IN ('4', '5', '7', '12') THEN
1036: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');
1037: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);
1038: FND_MSG_PUB.ADD;
1039: END IF;
1040:
1041: -- fix for bug# 7555681

Line 1045: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');

1041: -- fix for bug# 7555681
1042: /*IF p_prd_workoper_rec.status_code = '1' THEN
1043: -- Bug 4393092
1044: -- Cannot update an operation which is in status 'Complete'
1045: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');
1046: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);
1047: FND_MSG_PUB.ADD;
1048: END IF;*/
1049: IF (l_wo_status_code = '1' AND p_prd_workoper_rec.status_code = '1') THEN

Line 1046: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);

1042: /*IF p_prd_workoper_rec.status_code = '1' THEN
1043: -- Bug 4393092
1044: -- Cannot update an operation which is in status 'Complete'
1045: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');
1046: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);
1047: FND_MSG_PUB.ADD;
1048: END IF;*/
1049: IF (l_wo_status_code = '1' AND p_prd_workoper_rec.status_code = '1') THEN
1050: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');

Line 1050: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');

1046: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);
1047: FND_MSG_PUB.ADD;
1048: END IF;*/
1049: IF (l_wo_status_code = '1' AND p_prd_workoper_rec.status_code = '1') THEN
1050: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');
1051: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);
1052: FND_MSG_PUB.ADD;
1053: ELSE
1054: OPEN get_curr_operation_status(p_prd_workoper_rec.workorder_id,p_prd_workoper_rec.operation_sequence_num);

Line 1051: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);

1047: FND_MSG_PUB.ADD;
1048: END IF;*/
1049: IF (l_wo_status_code = '1' AND p_prd_workoper_rec.status_code = '1') THEN
1050: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_WOSTS');
1051: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);
1052: FND_MSG_PUB.ADD;
1053: ELSE
1054: OPEN get_curr_operation_status(p_prd_workoper_rec.workorder_id,p_prd_workoper_rec.operation_sequence_num);
1055: FETCH get_curr_operation_status INTO l_curr_op_status;

Line 1060: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');

1056: IF(l_curr_op_status = '1')THEN
1057:
1058: -- Bug 4393092
1059: -- Cannot update an operation which is in status 'Complete'
1060: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');
1061: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);
1062: FND_MSG_PUB.ADD;
1063: END IF;
1064: CLOSE get_curr_operation_status;

Line 1061: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);

1057:
1058: -- Bug 4393092
1059: -- Cannot update an operation which is in status 'Complete'
1060: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_STS_COMP');
1061: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_prd_workoper_rec.OPERATION_SEQUENCE_NUM);
1062: FND_MSG_PUB.ADD;
1063: END IF;
1064: CLOSE get_curr_operation_status;
1065: END IF;

Line 1075: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_CRT_UNTLCKD');

1071: p_visit_id => NULL,
1072: p_item_instance_id => NULL);
1073: IF l_return_status = FND_API.G_TRUE THEN
1074: IF p_prd_workoper_rec.dml_operation='C' THEN
1075: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_CRT_UNTLCKD');
1076: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');
1078: END IF;
1079: FND_MSG_PUB.ADD;

Line 1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');

1073: IF l_return_status = FND_API.G_TRUE THEN
1074: IF p_prd_workoper_rec.dml_operation='C' THEN
1075: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_CRT_UNTLCKD');
1076: ELSIF p_prd_workoper_rec.dml_operation='U' THEN
1077: FND_MESSAGE.Set_Name('AHL', 'AHL_PP_OP_UPD_UNTLCKD');
1078: END IF;
1079: FND_MSG_PUB.ADD;
1080: RAISE FND_API.G_EXC_ERROR;
1081: END IF;

Line 1088: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_ID_NULL');

1084: -- ACL Changes
1085:
1086: IF p_prd_workoper_rec.DEPARTMENT_ID IS NULL OR
1087: p_prd_workoper_rec.DEPARTMENT_ID=FND_API.G_MISS_NUM THEN
1088: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_ID_NULL');
1089: FND_MSG_PUB.ADD;
1090: END IF;
1091:
1092: IF p_prd_workoper_rec.SCHEDULED_START_DATE IS NULL OR

Line 1094: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');

1090: END IF;
1091:
1092: IF p_prd_workoper_rec.SCHEDULED_START_DATE IS NULL OR
1093: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN
1094: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1095: FND_MSG_PUB.ADD;
1096: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');

Line 1098: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');

1094: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDSTART_DT_NULL');
1095: FND_MSG_PUB.ADD;
1096: ELSIF p_prd_workoper_rec.SCHEDULED_END_DATE IS NULL OR
1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');
1099: FND_MSG_PUB.ADD;
1100: ELSIF NVL(p_prd_workoper_rec.SCHEDULED_START_DATE,SYSDATE) > NVL(p_prd_workoper_rec.SCHEDULED_END_DATE,SYSDATE) THEN
1101: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDDTS_INVALID_DT');
1102: FND_MSG_PUB.ADD;

Line 1101: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDDTS_INVALID_DT');

1097: p_prd_workoper_rec.SCHEDULED_END_DATE=FND_API.G_MISS_DATE THEN
1098: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDEND_DT_NULL');
1099: FND_MSG_PUB.ADD;
1100: ELSIF NVL(p_prd_workoper_rec.SCHEDULED_START_DATE,SYSDATE) > NVL(p_prd_workoper_rec.SCHEDULED_END_DATE,SYSDATE) THEN
1101: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_SCHEDDTS_INVALID_DT');
1102: FND_MSG_PUB.ADD;
1103: END IF;
1104:
1105: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND

Line 1108: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_STRT_DT_INVALID');

1104:
1105: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND
1106: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND
1107: p_prd_workoper_rec.ACTUAL_START_DATE > SYSDATE THEN
1108: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_STRT_DT_INVALID');
1109: FND_MSG_PUB.ADD;
1110: END IF;
1111:
1112: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR

Line 1116: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');

1112: IF (p_prd_workoper_rec.ACTUAL_START_DATE IS NULL OR
1113: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1114: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1115: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1116: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1117: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1118: FND_MSG_PUB.ADD;
1119: END IF;
1120:

Line 1117: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);

1113: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND
1114: (p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1115: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL) THEN
1116: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_START_DT_NULL');
1117: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1118: FND_MSG_PUB.ADD;
1119: END IF;
1120:
1121: IF p_prd_workoper_rec.ACTUAL_START_DATE IS NOT NULL AND

Line 1126: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');

1122: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND
1123: p_prd_workoper_rec.ACTUAL_END_DATE<>FND_API.G_MISS_DATE AND
1124: p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1125: p_prd_workoper_rec.ACTUAL_START_DATE > p_prd_workoper_rec.ACTUAL_END_DATE THEN
1126: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_SE_DT_INVALID');
1127: FND_MSG_PUB.ADD;
1128: END IF;
1129:
1130: IF p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND

Line 1133: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_END_DT_INVALID');

1129:
1130: IF p_prd_workoper_rec.ACTUAL_END_DATE IS NOT NULL AND
1131: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND
1132: TRUNC( p_prd_workoper_rec.ACTUAL_END_DATE ) > TRUNC( SYSDATE ) THEN
1133: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OP_ACT_END_DT_INVALID');
1134: FND_MSG_PUB.ADD;
1135: END IF;
1136:
1137: -- Balaji added actual date validation against workorder actual dates.

Line 1146: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_ST_DT' );

1142: IF ( p_prd_workoper_rec.actual_start_date IS NOT NULL AND
1143: p_prd_workoper_rec.actual_start_date <> FND_API.G_MISS_DATE AND
1144: l_wo_actual_start_date IS NOT NULL AND
1145: p_prd_workoper_rec.actual_start_date < l_wo_actual_start_date ) THEN
1146: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_ST_DT' );
1147: FND_MSG_PUB.add;
1148: END IF;
1149:
1150: IF ( p_prd_workoper_rec.actual_end_date IS NOT NULL AND

Line 1154: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_END_DT' );

1150: IF ( p_prd_workoper_rec.actual_end_date IS NOT NULL AND
1151: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND
1152: l_wo_actual_end_date IS NOT NULL AND
1153: p_prd_workoper_rec.actual_end_date > l_wo_actual_end_date ) THEN
1154: FND_MESSAGE.set_name( 'AHL', 'AHL_PRD_OP_WO_END_DT' );
1155: FND_MSG_PUB.add;
1156: END IF;
1157:
1158: IF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL OR

Line 1160: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');

1156: END IF;
1157:
1158: IF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM IS NULL OR
1159: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN
1160: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
1161: FND_MSG_PUB.ADD;
1162: ELSIF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM <=0 THEN
1163: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NEGZERO');
1164: FND_MSG_PUB.ADD;

Line 1163: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NEGZERO');

1159: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN
1160: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
1161: FND_MSG_PUB.ADD;
1162: ELSIF p_prd_workoper_rec.OPERATION_SEQUENCE_NUM <=0 THEN
1163: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NEGZERO');
1164: FND_MSG_PUB.ADD;
1165: ELSE
1166: IF p_prd_workoper_rec.dml_operation='C' THEN
1167: OPEN validate_unique_operation(p_prd_workoper_rec.workorder_id,p_prd_workoper_rec.operation_sequence_num);

Line 1170: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_SEQ_NOTUNIQ');

1166: IF p_prd_workoper_rec.dml_operation='C' THEN
1167: OPEN validate_unique_operation(p_prd_workoper_rec.workorder_id,p_prd_workoper_rec.operation_sequence_num);
1168: FETCH validate_unique_operation INTO l_unique_rec;
1169: IF validate_unique_operation%FOUND THEN
1170: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_SEQ_NOTUNIQ');
1171: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1172: FND_MSG_PUB.ADD;
1173: END IF;
1174: CLOSE validate_unique_operation;

Line 1171: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);

1167: OPEN validate_unique_operation(p_prd_workoper_rec.workorder_id,p_prd_workoper_rec.operation_sequence_num);
1168: FETCH validate_unique_operation INTO l_unique_rec;
1169: IF validate_unique_operation%FOUND THEN
1170: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_SEQ_NOTUNIQ');
1171: FND_MESSAGE.SET_TOKEN('RECORD',p_prd_workoper_rec.operation_sequence_num,false);
1172: FND_MSG_PUB.ADD;
1173: END IF;
1174: CLOSE validate_unique_operation;
1175: END IF;

Line 1181: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_OPERID_NULL');

1177:
1178: IF p_prd_workoper_rec.dml_operation='U' THEN
1179: IF p_prd_workoper_rec.WORKORDER_OPERATION_ID IS NULL OR
1180: p_prd_workoper_rec.WORKORDER_OPERATION_ID=FND_API.G_MISS_NUM THEN
1181: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_OPERID_NULL');
1182: FND_MSG_PUB.ADD;
1183: END IF;
1184: END IF;
1185:

Line 1194: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');

1190: OPEN validate_department(p_prd_workoper_rec.DEPARTMENT_ID,p_prd_workoper_rec.ORGANIZATION_ID);
1191: FETCH validate_department INTO l_eam_enabled_flag;
1192:
1193: IF validate_department%NOTFOUND THEN
1194: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');
1195: FND_MSG_PUB.ADD;
1196: ELSIF validate_department%FOUND AND l_eam_enabled_flag='N' THEN
1197: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NOT_EAM_ENABLED');
1198: FND_MSG_PUB.ADD;

Line 1197: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NOT_EAM_ENABLED');

1193: IF validate_department%NOTFOUND THEN
1194: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NAME_INVALID');
1195: FND_MSG_PUB.ADD;
1196: ELSIF validate_department%FOUND AND l_eam_enabled_flag='N' THEN
1197: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_DEPT_NOT_EAM_ENABLED');
1198: FND_MSG_PUB.ADD;
1199: END IF;
1200: CLOSE validate_department;
1201: END IF;