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 825: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_CODE_INVALID');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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