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

Line 55: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_DML_TYPE');

51: x_return_status := FND_API.G_RET_STS_SUCCESS;
52:
53: -- Ensure the DML operation for the Job header is only Insert or Update
54: IF (p_ahl_wo_rec.dml_type <> 'I' AND p_ahl_wo_rec.dml_type <> 'U') THEN
55: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_DML_TYPE');
56: FND_MSG_PUB.ADD;
57: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
58: RETURN;
59: END IF;

Line 63: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_GROUP_HEADER_MISMATCH');

59: END IF;
60:
61: IF (p_group_id IS NULL AND p_header_id IS NOT NULL) OR
62: (p_group_id IS NOT NULL AND p_header_id IS NULL) THEN
63: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_GROUP_HEADER_MISMATCH');
64: FND_MSG_PUB.ADD;
65: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
66: RETURN;
67: END IF;

Line 244: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_HEADER_INSERT_ERR');

240: l_wip_job_rec.scheduling_method,
241: l_wip_job_rec.description);
242: EXCEPTION
243: WHEN OTHERS THEN
244: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_HEADER_INSERT_ERR');
245: FND_MSG_PUB.ADD;
246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
247: RAISE; -- Reraise the exception and its calling procedure's exception handler
248: -- will handle it in its OTHERS exception part

Line 273: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_OPER_DML_TYPE');

269: x_return_status := FND_API.G_RET_STS_SUCCESS;
270:
271: -- Ensure the DML operation for the Job operation is only Insert or Update
272: IF (p_ahl_wo_op_rec.dml_type <> 'I' AND p_ahl_wo_op_rec.dml_type <> 'U') THEN
273: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_OPER_DML_TYPE');
274: FND_MSG_PUB.ADD;
275: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
276: RETURN;
277: END IF;

Line 283: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');

279: -- Validate p_group_id and p_parent_header_id
280: OPEN job_header_exists(p_group_id, p_parent_header_id);
281: FETCH job_header_exists INTO l_dummy;
282: IF job_header_exists%NOTFOUND THEN
283: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');
284: FND_MSG_PUB.ADD;
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286: CLOSE job_header_exists;
287: RETURN;

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

291:
292: -- Validate p_ahl_wo_op_rec.operation_seq_num, because operation_seq_num is
293: -- a NOT NULL column in table wip_job_dtls_interface
294: IF p_ahl_wo_op_rec.operation_seq_num IS NULL THEN
295: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPERATION_SEQ_NULL');
296: FND_MSG_PUB.ADD;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: RETURN;
299: END IF;

Line 403: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_OPER_INSERT_ERR');

399: l_wip_job_op_rec.last_unit_completion_date,
400: l_wip_job_op_rec.backflush_flag);
401: EXCEPTION
402: WHEN OTHERS THEN
403: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_OPER_INSERT_ERR');
404: FND_MSG_PUB.ADD;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406: RAISE;
407: END;

Line 430: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_RES_DML_TYPE');

426:
427: -- Ensure the DML operation for the Job resource is Insert, Update or Delete
428: IF (p_ahl_wo_res_rec.dml_type <> 'I' AND p_ahl_wo_res_rec.dml_type <> 'U'
429: AND p_ahl_wo_res_rec.dml_type <> 'D') THEN
430: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_RES_DML_TYPE');
431: FND_MSG_PUB.ADD;
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: RETURN;
434: END IF;

Line 440: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');

436: -- validate p_group_id and p_parent_header_id
437: OPEN job_header_exists(p_group_id, p_parent_header_id);
438: FETCH job_header_exists INTO l_dummy;
439: IF job_header_exists%NOTFOUND THEN
440: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');
441: FND_MSG_PUB.ADD;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: CLOSE job_header_exists;
444: RETURN;

Line 572: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_RES_INSERT_ERR');

568: l_wip_job_res_rec.completion_date,
569: l_wip_job_res_rec.setup_id);
570: EXCEPTION
571: WHEN OTHERS THEN
572: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_RES_INSERT_ERR');
573: FND_MSG_PUB.ADD;
574: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
575: RAISE;
576: END;

Line 599: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_MTL_DML_TYPE');

595:
596: -- Ensure the DML operation for the Job material is Insert, Update or Delete
597: IF (p_ahl_wo_mtl_rec.dml_type <> 'I' AND p_ahl_wo_mtl_rec.dml_type <> 'U'
598: AND p_ahl_wo_mtl_rec.dml_type <> 'D') THEN
599: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_MTL_DML_TYPE');
600: FND_MSG_PUB.ADD;
601: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
602: RETURN;
603: END IF;

Line 609: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');

605: -- Validate p_group_id and p_parent_header_id
606: OPEN job_header_exists(p_group_id, p_parent_header_id);
607: FETCH job_header_exists INTO l_dummy;
608: IF job_header_exists%NOTFOUND THEN
609: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');
610: FND_MSG_PUB.ADD;
611: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
612: CLOSE job_header_exists;
613: RETURN;

Line 711: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_MTL_INSERT_ERR');

707: l_wip_job_mtl_rec.supply_subinventory,
708: l_wip_job_mtl_rec.date_required);
709: EXCEPTION
710: WHEN OTHERS THEN
711: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_JOB_MTL_INSERT_ERR');
712: FND_MSG_PUB.ADD;
713: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
714: RAISE;
715: END;

Line 751: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');

747: -- Validate p_group_id
748: OPEN job_header_exists(p_group_id);
749: FETCH job_header_exists INTO l_dummy;
750: IF job_header_exists%NOTFOUND THEN
751: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_INVALID_JOB_HEADER');
752: FND_MSG_PUB.ADD;
753: CLOSE job_header_exists;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: RETURN;

Line 775: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_CM_DOWN');

771: activep => l_activep,
772: pmon_method => l_pmon_method,
773: callstat => l_callstat);
774: IF (l_activep <= 0 OR l_activep1 <= 0) THEN
775: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_CM_DOWN');
776: FND_MSG_PUB.ADD;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: RETURN;
779: END IF;

Line 783: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WICMLP');

779: END IF;
780:
781: -- check whether Concurrent Program is available
782: IF NOT fnd_program.program_exists('WICMLP','WIP') THEN
783: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WICMLP');
784: FND_MSG_PUB.ADD;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: RETURN;
787: END IF;

Line 791: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WICMLX');

787: END IF;
788:
789: -- check whether Concurrent Executible is available
790: IF NOT fnd_program.executable_exists('WICMLX','WIP') THEN
791: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WICMLX');
792: FND_MSG_PUB.ADD;
793: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
794: RETURN;
795: END IF;

Line 810: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_SUBMIT_FAILURE');

806: AHL_DEBUG_PUB.debug('When calling submit_request, the group_id is '||to_char(p_group_id));
807: --dbms_output.put_line('When calling submit_request, the group_id is '||to_char(p_group_id));
808: END IF;
809: IF (l_req_id = 0 ) THEN
810: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_SUBMIT_FAILURE');
811: FND_MSG_PUB.ADD;
812: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
813: IF G_DEBUG='Y' THEN
814: AHL_DEBUG_PUB.debug('Submit request itself failed and the initialized parameters for the application are: ');

Line 838: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_WAIT_FAILURE');

834: dev_phase => l_dev_phase,
835: dev_status => l_dev_status,
836: message => l_message);
837: IF NOT l_boolvar THEN
838: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_WAIT_FAILURE');
839: FND_MSG_PUB.ADD;
840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
841: IF G_DEBUG='Y' THEN
842: AHL_DEBUG_PUB.debug('Wait for request itself failed');

Line 1013: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WIP_ENTITY_ID');

1009: OPEN get_wip_entity(p_ahl_wo_rec.wo_name, p_ahl_wo_rec.organization_id);
1010: FETCH get_wip_entity INTO x_wip_entity_id;
1011: IF get_wip_entity%NOTFOUND THEN
1012: CLOSE get_wip_entity;
1013: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WIP_ENTITY_ID');
1014: FND_MSG_PUB.ADD;
1015: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1016: ELSE
1017: CLOSE get_wip_entity;

Line 1027: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_REBUILD_FLAG_FAIL');

1023: p_organization_id => p_ahl_wo_rec.organization_id,
1024: p_manual_rebuild_flag => p_ahl_wo_rec.manual_rebuild_flag,
1025: x_return_status => l_return_status);
1026: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1027: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_REBUILD_FLAG_FAIL');
1028: FND_MSG_PUB.ADD;
1029: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1030: END IF;
1031: END IF;

Line 1040: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_OWN_DEPT_FAIL');

1036: p_organization_id => p_ahl_wo_rec.organization_id,
1037: p_owning_department => p_ahl_wo_rec.department_id,
1038: x_return_status => l_return_status);
1039: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1040: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_OWN_DEPT_FAIL');
1041: FND_MSG_PUB.ADD;
1042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1043: END IF;
1044: END IF;

Line 1089: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');

1085: WHERE group_id = l_group_id
1086: AND header_id = l_header_id;
1087: END IF;
1088:
1089: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');
1090: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);
1091: FND_MSG_PUB.ADD;
1092: x_msg_count := 1;
1093: x_msg_data := l_error_msg;

Line 1090: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);

1086: AND header_id = l_header_id;
1087: END IF;
1088:
1089: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');
1090: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);
1091: FND_MSG_PUB.ADD;
1092: x_msg_count := 1;
1093: x_msg_data := l_error_msg;
1094: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1270: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_RECORDS_IN_TBL');

1266: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1267: END IF;
1268:
1269: IF p_ahl_res_txn_tbl.count <= 0 THEN
1270: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_RECORDS_IN_TBL');
1271: FND_MSG_PUB.add;
1272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1273: END IF;
1274:

Line 1278: FND_MESSAGE.set_name('AHL','AHL_PRD_USER_ID_INVALID');

1274:
1275: OPEN get_user_name(fnd_global.user_id);
1276: FETCH get_user_name INTO l_user_name;
1277: IF get_user_name%NOTFOUND THEN
1278: FND_MESSAGE.set_name('AHL','AHL_PRD_USER_ID_INVALID');
1279: FND_MSG_PUB.add;
1280: CLOSE get_user_name;
1281: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1282: END IF;

Line 1293: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_WIP_ENTITY_ID');

1289:
1290: OPEN get_job_attr(p_ahl_res_txn_tbl(i).wip_entity_id);
1291: FETCH get_job_attr INTO l_job_attr;
1292: IF get_job_attr%NOTFOUND THEN
1293: FND_MESSAGE.set_name('AHL','AHL_PRD_NO_WIP_ENTITY_ID');
1294: FND_MSG_PUB.add;
1295: CLOSE get_job_attr;
1296: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1297: END IF;

Line 1303: FND_MESSAGE.set_name('AHL','AHL_PRD_ORG_ID_INVALID');

1299:
1300: OPEN get_org_code(l_job_attr.organization_id);
1301: FETCH get_org_code INTO l_org_code;
1302: IF get_org_code%NOTFOUND THEN
1303: FND_MESSAGE.set_name('AHL','AHL_PRD_ORG_ID_INVALID');
1304: FND_MSG_PUB.add;
1305: CLOSE get_org_code;
1306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1307: END IF;

Line 1364: FND_MESSAGE.set_name('AHL','AHL_PRD_EMPLOYEE_ID_INVALID');

1360: IF (p_ahl_res_txn_tbl(i).employee_id IS NOT NULL) THEN
1361: OPEN get_employee_num(p_ahl_res_txn_tbl(i).employee_id, l_job_attr.organization_id);
1362: FETCH get_employee_num INTO l_employee_num;
1363: IF get_employee_num%NOTFOUND THEN
1364: FND_MESSAGE.set_name('AHL','AHL_PRD_EMPLOYEE_ID_INVALID');
1365: FND_MSG_PUB.add;
1366: CLOSE get_employee_num;
1367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1368: END IF;

Line 1395: FND_MESSAGE.set_name('AHL','AHL_PRD_RESTXN_SERNUM_INVALID');

1391: FETCH get_instance_sernum INTO l_wip_cost_txn_rec.instance_id;
1392:
1393: IF get_instance_sernum%NOTFOUND
1394: THEN
1395: FND_MESSAGE.set_name('AHL','AHL_PRD_RESTXN_SERNUM_INVALID');
1396: FND_MESSAGE.SET_TOKEN('SERNUMB',p_ahl_res_txn_tbl(i).serial_number);
1397: FND_MSG_PUB.ADD;
1398: END IF;
1399: Close get_instance_sernum;

Line 1396: FND_MESSAGE.SET_TOKEN('SERNUMB',p_ahl_res_txn_tbl(i).serial_number);

1392:
1393: IF get_instance_sernum%NOTFOUND
1394: THEN
1395: FND_MESSAGE.set_name('AHL','AHL_PRD_RESTXN_SERNUM_INVALID');
1396: FND_MESSAGE.SET_TOKEN('SERNUMB',p_ahl_res_txn_tbl(i).serial_number);
1397: FND_MSG_PUB.ADD;
1398: END IF;
1399: Close get_instance_sernum;
1400: END IF;

Line 1497: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_INSERT_ERR');

1493: l_wip_cost_txn_rec.charge_department_id);
1494: -- End of changes for bug # 6326254.
1495: EXCEPTION
1496: WHEN OTHERS THEN
1497: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_INSERT_ERR');
1498: FND_MSG_PUB.ADD;
1499: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1500: RAISE;
1501: END;

Line 1585: FND_MESSAGE.set_name('AHL','AHL_COM_WIP_LOAD_PENDING');

1581: OPEN get_pending_job(l_job_name.wip_entity_name, l_job_name.organization_id);
1582: FETCH get_pending_job INTO l_dummy;
1583: IF get_pending_job%FOUND THEN
1584: CLOSE get_pending_job;
1585: FND_MESSAGE.set_name('AHL','AHL_COM_WIP_LOAD_PENDING');
1586: FND_MSG_PUB.add;
1587: RETURN TRUE;
1588: ELSE
1589: CLOSE get_pending_job;

Line 1743: FND_MESSAGE.set_name('AHL','AHL_WIP_ITF_REC_NOT_FOUND');

1739: OPEN get_job_attr(l_group_id, l_group_id + i);
1740: FETCH get_job_attr INTO l_get_job_attr;
1741: IF get_job_attr%NOTFOUND THEN
1742: CLOSE get_job_attr;
1743: FND_MESSAGE.set_name('AHL','AHL_WIP_ITF_REC_NOT_FOUND');
1744: FND_MSG_PUB.add;
1745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1746: END IF;
1747: x_ahl_wip_job_tbl(i+1).wip_entity_name := l_get_job_attr.job_name;

Line 1773: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WIP_ENTITY_ID');

1769: FETCH get_wip_entity INTO x_ahl_wip_job_tbl(i+1).wip_entity_id;
1770: IF get_wip_entity%NOTFOUND THEN
1771: CLOSE get_wip_entity;
1772: CLOSE get_job_attr;
1773: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_NO_WIP_ENTITY_ID');
1774: FND_MSG_PUB.ADD;
1775: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1776: ELSE
1777: CLOSE get_wip_entity;

Line 1791: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_REBUILD_FLAG_FAIL');

1787: p_organization_id => x_ahl_wip_job_tbl(i+1).organization_id,
1788: p_manual_rebuild_flag => x_ahl_wip_job_tbl(i+1).manual_rebuild_flag,
1789: x_return_status => l_return_status);
1790: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1791: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_REBUILD_FLAG_FAIL');
1792: FND_MSG_PUB.ADD;
1793: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1794: END IF;
1795: END IF;

Line 1804: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_OWN_DEPT_FAIL');

1800: p_organization_id => x_ahl_wip_job_tbl(i+1).organization_id,
1801: p_owning_department => x_ahl_wip_job_tbl(i+1).owning_department,
1802: x_return_status => l_return_status);
1803: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1804: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_EAM_OWN_DEPT_FAIL');
1805: FND_MSG_PUB.ADD;
1806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1807: END IF;
1808: END IF;

Line 1848: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');

1844: AND header_id = l_get_job_attr.header_id;
1845: END IF;
1846:
1847: /*
1848: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');
1849: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);
1850: FND_MSG_PUB.ADD;
1851: */
1852: x_msg_count := 1;

Line 1849: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);

1845: END IF;
1846:
1847: /*
1848: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WICMLP_ERROR');
1849: FND_MESSAGE.SET_TOKEN('ERROR',l_error_msg);
1850: FND_MSG_PUB.ADD;
1851: */
1852: x_msg_count := 1;
1853: x_msg_data := l_error_msg;