DBA Data[Home] [Help]

APPS.AHL_PRD_WO_PUB dependencies on FND_MESSAGE

Line 25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');

21: END IF;
22: OPEN get_user_id_csr(p_user_id);
23: FETCH get_user_id_csr INTO l_user_id;
24: IF get_user_id_csr%NOTFOUND THEN
25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
27: FND_MSG_PUB.ADD;
28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
29: END IF;

Line 26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);

22: OPEN get_user_id_csr(p_user_id);
23: FETCH get_user_id_csr INTO l_user_id;
24: IF get_user_id_csr%NOTFOUND THEN
25: FND_MESSAGE.set_name('AHL','AHL_PRD_INV_BPEL_USR');
26: FND_MESSAGE.SET_TOKEN('USER_NAME',p_user_id);
27: FND_MSG_PUB.ADD;
28: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
29: END IF;
30: CLOSE get_user_id_csr;

Line 156: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

152: --x_return_status := FND_API.G_RET_STS_SUCCESS;
153: x_return_status := init_user_and_role(p_userid);
154:
155: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
156: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
157: FND_MSG_PUB.ADD;
158: RAISE FND_API.G_EXC_ERROR;
159: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
160: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 169: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

165:
166: OPEN get_wo_details_csr(l_workorder_id);
167: FETCH get_wo_details_csr INTO l_wo_details;
168: IF(get_wo_details_csr%NOTFOUND)THEN
169: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
170: FND_MSG_PUB.ADD;
171: CLOSE get_wo_details_csr;
172: RAISE FND_API.G_EXC_ERROR;
173: ELSE

Line 335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

331: FND_MSG_PUB.Initialize;
332: END IF;
333: -- Check Error Message stack.
334: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
336: FND_MSG_PUB.ADD;
337: RAISE FND_API.G_EXC_ERROR;
338: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
339: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 485: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

481: END IF;
482:
483: -- Check Error Message stack.
484: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
485: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
486: FND_MSG_PUB.ADD;
487: RAISE FND_API.G_EXC_ERROR;
488: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
489: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 667: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

663: END IF;
664:
665: -- Check Error Message stack.
666: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
667: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
668: FND_MSG_PUB.ADD;
669: RAISE FND_API.G_EXC_ERROR;
670: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
671: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 778: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

774: END IF;
775:
776: -- Check Error Message stack.
777: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
778: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
779: FND_MSG_PUB.ADD;
780: RAISE FND_API.G_EXC_ERROR;
781: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
782: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 902: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

898: END IF;
899:
900: -- Check Error Message stack.
901: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
902: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
903: FND_MSG_PUB.ADD;
904: RAISE FND_API.G_EXC_ERROR;
905: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
906: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 920: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

916: IF(p_WoOperationId IS NOT NULL)THEN
917: OPEN get_operation_sequence_csr(p_WoOperationId);
918: FETCH get_operation_sequence_csr INTO l_operation_sequence;
919: IF(get_operation_sequence_csr%NOTFOUND)THEN
920: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
921: FND_MSG_PUB.ADD;
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: CLOSE get_operation_sequence_csr;

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

1158: END IF;
1159:
1160: -- Check Error Message stack.
1161: IF(p_WorkorderId IS NULL AND p_WorkorderNumber IS NULL)THEN
1162: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1163: FND_MSG_PUB.ADD;
1164: RAISE FND_API.G_EXC_ERROR;
1165: ELSIF (p_WorkorderId IS NULL AND p_WorkorderNumber IS NOT NULL)THEN
1166: l_workorder_id := get_workorder_id(p_WorkorderNumber);

Line 1363: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

1359: BEGIN
1360: OPEN get_workorder_id_csr(p_WorkorderNumber);
1361: FETCH get_workorder_id_csr INTO l_workorder_id;
1362: IF(get_workorder_id_csr%NOTFOUND)THEN
1363: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1364: FND_MSG_PUB.ADD;
1365: CLOSE get_workorder_id_csr;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;

Line 1386: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');

1382: BEGIN
1383: OPEN get_workorder_operation_id_csr(p_WorkorderId, p_operation_sequence);
1384: FETCH get_workorder_operation_id_csr INTO l_workorder_operation_id;
1385: IF(get_workorder_operation_id_csr%NOTFOUND)THEN
1386: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
1387: FND_MSG_PUB.ADD;
1388: CLOSE get_workorder_operation_id_csr;
1389: RAISE FND_API.G_EXC_ERROR;
1390: END IF;

Line 1487: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TRNNTREC_NALWD');

1483: END LOOP;
1484:
1485: IF(l_trunover_notes_tbl IS NOT NULL AND l_trunover_notes_tbl.COUNT > 0)THEN
1486: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1487: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_TRNNTREC_NALWD');
1488: FND_MSG_PUB.ADD;
1489: RAISE FND_API.G_EXC_ERROR;
1490: END IF;
1491:

Line 1528: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_UPD_NALWD');

1524: IF(p_WO_DETAILS_REC.StatusCode IS NULL OR p_WO_DETAILS_REC.StatusCode = p_CURR_WO_DETAILS_REC.StatusCode)THEN
1525: RETURN;--Nothing to do
1526: END IF;
1527: IF(p_CURR_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
1528: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_UPD_NALWD');
1529: FND_MSG_PUB.ADD;
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: IF(p_WO_DETAILS_REC.StatusCode = '3' AND p_CURR_WO_DETAILS_REC.StatusCode = '1')THEN

Line 1568: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_COMP_NALWD');

1564: p_workorder_id => p_CURR_WO_DETAILS_REC.WorkorderId
1565: );
1566: ELSIF(p_WO_DETAILS_REC.StatusCode = '4')THEN
1567: IF(p_CURR_WO_DETAILS_REC.IsCompleteEnabled <> 'T')THEN
1568: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_COMP_NALWD');
1569: FND_MSG_PUB.ADD;
1570: RAISE FND_API.G_EXC_ERROR;
1571: END IF;
1572: -- complete job

Line 1643: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPQASUB_NALWD');

1639: RETURN;
1640: END IF;
1641:
1642: IF(p_OP_DETAILS_REC.IsQualityEnabled <> 'T')THEN
1643: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPQASUB_NALWD');
1644: FND_MSG_PUB.ADD;
1645: RAISE FND_API.G_EXC_ERROR;
1646: END IF;
1647:

Line 1766: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

1762: );
1763: --DBMS_OUTPUT.put_line('x_return_status :i: ' || x_return_status);
1764: IF(p_Operations(i).ObjectVersionNumber IS NULL OR
1765: p_Operations(i).ObjectVersionNumber <> l_Operations(0).ObjectVersionNumber)THEN
1766: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN

Line 1771: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');

1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770: IF(l_Operations(0).IsUpdateEnabled <> 'T')THEN
1771: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1772: FND_MSG_PUB.ADD;
1773: RAISE FND_API.G_EXC_ERROR;
1774: END IF;
1775: process_op_quality

Line 1796: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');

1792: IF(p_Operations(i).StatusCode IS NOT NULL OR p_Operations(i).Status IS NOT NULL
1793: OR p_Operations(i).ActualStartDate IS NOT NULL
1794: OR p_Operations(i).ActualEndDate IS NOT NULL)THEN
1795: IF(p_Operations(i).StatusCode NOT IN ('1','2'))THEN
1796: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPUPD_NALWD');
1797: FND_MSG_PUB.ADD;
1798: RAISE FND_API.G_EXC_ERROR;
1799: END IF;
1800: ----DBMS_OUTPUT.put_line('op :i:statusCode: ' || p_Operations(i).StatusCode);

Line 1901: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WOQASUB_NALWD');

1897: IF(p_WO_QaResults.QA_RESULT_TBL IS NULL OR p_WO_QaResults.QA_RESULT_TBL.COUNT < 1)THEN
1898: RETURN;
1899: END IF;
1900: IF(p_WO_DETAILS_REC.IsQualityEnabled <> 'T')THEN
1901: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WOQASUB_NALWD');
1902: FND_MSG_PUB.ADD;
1903: RAISE FND_API.G_EXC_ERROR;
1904: END IF;
1905:

Line 2022: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_NALWD');

2018: END LOOP;
2019:
2020: IF(l_res_txns_tbl IS NOT NULL AND l_res_txns_tbl.COUNT > 0)THEN
2021: IF(p_WO_DETAILS_REC.IsUpdateEnabled <> 'T')THEN
2022: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_RES_TXN_NALWD');
2023: FND_MSG_PUB.ADD;
2024: RAISE FND_API.G_EXC_ERROR;
2025: END IF;
2026: AHL_PRD_RESOURCE_TRANX_PVT.process_resource_txns

Line 2102: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');

2098: END IF;
2099: IF(p_WO_DETAILS_REC.ObjectVersionNumber IS NULL OR
2100: p_WO_DETAILS_REC.ObjectVersionNumber <> l_WO_DETAILS_REC.ObjectVersionNumber)THEN
2101: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');
2102: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2103: FND_MSG_PUB.ADD;
2104: RAISE FND_API.G_EXC_ERROR;
2105: END IF;
2106: process_turnover_notes(