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_MSG_PUB

Line 827: FND_MSG_PUB.ADD;

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;
831: -- Bug # 6717357 -- end

Line 850: FND_MSG_PUB.ADD;

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;
854: -- Added following code for Bug # 6717357 -- End

Line 864: FND_MSG_PUB.ADD;

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;
868: CLOSE get_department;

Line 880: FND_MSG_PUB.ADD;

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;
884:

Line 1040: FND_MSG_PUB.ADD;

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
1044: /*IF p_prd_workoper_rec.status_code = '1' THEN

Line 1049: FND_MSG_PUB.ADD;

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');
1053: FND_MESSAGE.SET_TOKEN('WO_STS', l_wo_status);

Line 1054: 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;
1058: IF(l_curr_op_status = '1')THEN

Line 1064: FND_MSG_PUB.ADD;

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;
1068: END IF;

Line 1081: FND_MSG_PUB.ADD;

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;
1084: */
1085: -- rroy

Line 1091: FND_MSG_PUB.ADD;

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
1095: p_prd_workoper_rec.SCHEDULED_START_DATE=FND_API.G_MISS_DATE THEN

Line 1097: FND_MSG_PUB.ADD;

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');
1101: FND_MSG_PUB.ADD;

Line 1101: FND_MSG_PUB.ADD;

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;
1105: END IF;

Line 1104: FND_MSG_PUB.ADD;

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
1108: p_prd_workoper_rec.ACTUAL_START_DATE <> FND_API.G_MISS_DATE AND

Line 1111: FND_MSG_PUB.ADD;

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
1115: p_prd_workoper_rec.ACTUAL_START_DATE=FND_API.G_MISS_DATE) AND

Line 1120: FND_MSG_PUB.ADD;

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
1124: p_prd_workoper_rec.ACTUAL_START_DATE<>FND_API.G_MISS_DATE AND

Line 1129: FND_MSG_PUB.ADD;

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
1133: p_prd_workoper_rec.ACTUAL_END_DATE <> FND_API.G_MISS_DATE AND

Line 1136: FND_MSG_PUB.ADD;

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.
1140: OPEN get_wo_actual_dates(p_prd_workoper_rec.workorder_id);

Line 1149: FND_MSG_PUB.add;

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
1153: p_prd_workoper_rec.actual_end_date <> FND_API.G_MISS_DATE AND

Line 1157: FND_MSG_PUB.add;

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
1161: p_prd_workoper_rec.OPERATION_SEQUENCE_NUM=FND_API.G_MISS_NUM THEN

Line 1163: FND_MSG_PUB.ADD;

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;
1167: ELSE

Line 1166: FND_MSG_PUB.ADD;

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);
1170: FETCH validate_unique_operation INTO l_unique_rec;

Line 1174: FND_MSG_PUB.ADD;

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;
1178: END IF;

Line 1184: FND_MSG_PUB.ADD;

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:
1188: IF p_prd_workoper_rec.ORGANIZATION_ID IS NOT NULL AND

Line 1197: FND_MSG_PUB.ADD;

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;
1201: END IF;

Line 1200: FND_MSG_PUB.ADD;

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;
1204:

Line 1256: FND_MSG_PUB.initialize;

1252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1253: END IF;
1254:
1255: IF FND_API.to_boolean(p_init_msg_list) THEN
1256: FND_MSG_PUB.initialize;
1257: END IF;
1258:
1259: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1260:

Line 1316: l_msg_count:=FND_MSG_PUB.count_msg;

1312: END LOOP;
1313: END IF;
1314: END IF;
1315:
1316: l_msg_count:=FND_MSG_PUB.count_msg;
1317:
1318: IF l_msg_count > 0 THEN
1319: x_msg_count := l_msg_count;
1320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1342: l_msg_count:=FND_MSG_PUB.count_msg;

1338: (
1339: p_prd_workoper_rec =>p_x_prd_operation_tbl(i)
1340: );
1341:
1342: l_msg_count:=FND_MSG_PUB.count_msg;
1343: IF l_msg_count > 0 THEN
1344: x_msg_count := l_msg_count;
1345: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1346: END IF;

Line 1506: l_msg_count:=FND_MSG_PUB.count_msg;

1502: END IF;
1503: END LOOP;
1504: END IF;
1505:
1506: l_msg_count:=FND_MSG_PUB.count_msg;
1507:
1508: IF l_msg_count > 0 THEN
1509: x_msg_count := l_msg_count;
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1584: EXCEPTION
1585: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1586: ROLLBACK TO process_operations_PVT;
1587: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1588: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1589: p_count => x_msg_count,
1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;

Line 1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1590: p_data => x_msg_data);
1591: WHEN FND_API.G_EXC_ERROR THEN
1592: ROLLBACK TO process_operations_PVT;
1593: x_return_status := FND_API.G_RET_STS_ERROR;
1594: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1595: p_count => x_msg_count,
1596: p_data => x_msg_data);
1597:
1598: WHEN OTHERS THEN

Line 1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1597:
1598: WHEN OTHERS THEN
1599: ROLLBACK TO process_operations_PVT;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1602: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1603: p_procedure_name =>l_api_name,
1604: p_error_text => SUBSTR(SQLERRM,1,240));
1605:

Line 1602: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,

1598: WHEN OTHERS THEN
1599: ROLLBACK TO process_operations_PVT;
1600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1601: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1602: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1603: p_procedure_name =>l_api_name,
1604: p_error_text => SUBSTR(SQLERRM,1,240));
1605:
1606: END IF;

Line 1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1603: p_procedure_name =>l_api_name,
1604: p_error_text => SUBSTR(SQLERRM,1,240));
1605:
1606: END IF;
1607: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1608: p_count => x_msg_count,
1609: p_data => x_msg_data);
1610:
1611: END;