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 825: FND_MSG_PUB.ADD;

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

Line 848: FND_MSG_PUB.ADD;

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

Line 862: FND_MSG_PUB.ADD;

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

Line 878: FND_MSG_PUB.ADD;

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

Line 1038: FND_MSG_PUB.ADD;

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

Line 1047: FND_MSG_PUB.ADD;

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

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

Line 1062: FND_MSG_PUB.ADD;

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

Line 1079: FND_MSG_PUB.ADD;

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;
1082: */
1083: -- rroy

Line 1089: FND_MSG_PUB.ADD;

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

Line 1095: FND_MSG_PUB.ADD;

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

Line 1099: FND_MSG_PUB.ADD;

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

Line 1102: FND_MSG_PUB.ADD;

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

Line 1109: FND_MSG_PUB.ADD;

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

Line 1118: FND_MSG_PUB.ADD;

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

Line 1127: FND_MSG_PUB.ADD;

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

Line 1134: FND_MSG_PUB.ADD;

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

Line 1147: FND_MSG_PUB.add;

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

Line 1155: FND_MSG_PUB.add;

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

Line 1161: FND_MSG_PUB.ADD;

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

Line 1164: FND_MSG_PUB.ADD;

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

Line 1172: FND_MSG_PUB.ADD;

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

Line 1182: FND_MSG_PUB.ADD;

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

Line 1195: FND_MSG_PUB.ADD;

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

Line 1198: FND_MSG_PUB.ADD;

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

Line 1252: FND_MSG_PUB.initialize;

1248: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1249: END IF;
1250:
1251: IF FND_API.to_boolean(p_init_msg_list) THEN
1252: FND_MSG_PUB.initialize;
1253: END IF;
1254:
1255: x_return_status:=FND_API.G_RET_STS_SUCCESS;
1256:

Line 1312: l_msg_count:=FND_MSG_PUB.count_msg;

1308: END LOOP;
1309: END IF;
1310: END IF;
1311:
1312: l_msg_count:=FND_MSG_PUB.count_msg;
1313:
1314: IF l_msg_count > 0 THEN
1315: x_msg_count := l_msg_count;
1316: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1338: l_msg_count:=FND_MSG_PUB.count_msg;

1334: (
1335: p_prd_workoper_rec =>p_x_prd_operation_tbl(i)
1336: );
1337:
1338: l_msg_count:=FND_MSG_PUB.count_msg;
1339: IF l_msg_count > 0 THEN
1340: x_msg_count := l_msg_count;
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: END IF;

Line 1480: l_msg_count:=FND_MSG_PUB.count_msg;

1476: END IF;
1477: END LOOP;
1478: END IF;
1479:
1480: l_msg_count:=FND_MSG_PUB.count_msg;
1481:
1482: IF l_msg_count > 0 THEN
1483: x_msg_count := l_msg_count;
1484: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1558: EXCEPTION
1559: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1560: ROLLBACK TO process_operations_PVT;
1561: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1562: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1563: p_count => x_msg_count,
1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;

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

1564: p_data => x_msg_data);
1565: WHEN FND_API.G_EXC_ERROR THEN
1566: ROLLBACK TO process_operations_PVT;
1567: x_return_status := FND_API.G_RET_STS_ERROR;
1568: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1569: p_count => x_msg_count,
1570: p_data => x_msg_data);
1571:
1572: WHEN OTHERS THEN

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

1571:
1572: WHEN OTHERS THEN
1573: ROLLBACK TO process_operations_PVT;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1576: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1577: p_procedure_name =>l_api_name,
1578: p_error_text => SUBSTR(SQLERRM,1,240));
1579:

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

1572: WHEN OTHERS THEN
1573: ROLLBACK TO process_operations_PVT;
1574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1575: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1576: FND_MSG_PUB.add_exc_msg(p_pkg_name =>g_pkg_name,
1577: p_procedure_name =>l_api_name,
1578: p_error_text => SUBSTR(SQLERRM,1,240));
1579:
1580: END IF;

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

1577: p_procedure_name =>l_api_name,
1578: p_error_text => SUBSTR(SQLERRM,1,240));
1579:
1580: END IF;
1581: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1582: p_count => x_msg_count,
1583: p_data => x_msg_data);
1584:
1585: END;