DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PUB dependencies on FND_MESSAGE

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

129: END IF;
130:
131: -- Check Error Message stack.
132: IF(p_Workorder_Id IS NULL AND p_Workorder_Number IS NULL)THEN
133: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
134: FND_MSG_PUB.ADD;
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF (p_Workorder_Id IS NULL AND p_Workorder_Number IS NOT NULL)THEN
137: l_workorder_id := get_workorder_id(p_Workorder_Number);

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

331: BEGIN
332: OPEN get_workorder_id_csr(p_Workorder_Number);
333: FETCH get_workorder_id_csr INTO l_workorder_id;
334: IF(get_workorder_id_csr%NOTFOUND)THEN
335: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
336: FND_MSG_PUB.ADD;
337: CLOSE get_workorder_id_csr;
338: RAISE FND_API.G_EXC_ERROR;
339: END IF;

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

354: BEGIN
355: OPEN get_workorder_operation_id_csr(p_Workorder_Id, p_operation_sequence);
356: FETCH get_workorder_operation_id_csr INTO l_workorder_operation_id;
357: IF(get_workorder_operation_id_csr%NOTFOUND)THEN
358: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_WO_NOT_FOUND');
359: FND_MSG_PUB.ADD;
360: CLOSE get_workorder_operation_id_csr;
361: RAISE FND_API.G_EXC_ERROR;
362: END IF;

Line 462: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');

458: IF p_x_workorder_rec.status_code IS NULL AND p_x_workorder_rec.status IS NOT NULL THEN
459: OPEN get_status_csr(p_x_workorder_rec.status);
460: FETCH get_status_csr INTO p_x_workorder_rec.status_code;
461: IF get_status_csr%NOTFOUND THEN
462: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');
463: FND_MSG_PUB.ADD;
464: CLOSE get_status_csr;
465: RAISE FND_API.G_EXC_ERROR;
466: ELSE

Line 476: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');

472: IF p_x_workorder_rec.status_code IS NOT NULL AND p_x_workorder_rec.Status_Code <> '4' THEN
473: OPEN validate_status_csr(p_x_workorder_rec.status_code,p_curr_workorder_rec.status_code);
474: FETCH validate_status_csr INTO l_dummy_ctr;
475: IF validate_status_csr%NOTFOUND THEN
476: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');
477: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_curr_workorder_rec.status_code);
478: FND_MESSAGE.SET_TOKEN('TO_STATUS', p_x_workorder_rec.status_code);
479: FND_MSG_PUB.ADD;
480: CLOSE validate_status_csr;

Line 477: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_curr_workorder_rec.status_code);

473: OPEN validate_status_csr(p_x_workorder_rec.status_code,p_curr_workorder_rec.status_code);
474: FETCH validate_status_csr INTO l_dummy_ctr;
475: IF validate_status_csr%NOTFOUND THEN
476: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');
477: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_curr_workorder_rec.status_code);
478: FND_MESSAGE.SET_TOKEN('TO_STATUS', p_x_workorder_rec.status_code);
479: FND_MSG_PUB.ADD;
480: CLOSE validate_status_csr;
481: RAISE FND_API.G_EXC_ERROR;

Line 478: FND_MESSAGE.SET_TOKEN('TO_STATUS', p_x_workorder_rec.status_code);

474: FETCH validate_status_csr INTO l_dummy_ctr;
475: IF validate_status_csr%NOTFOUND THEN
476: FND_MESSAGE.SET_NAME('AHL','AHL_UMP_INVALID_STTS_CHNG');
477: FND_MESSAGE.SET_TOKEN('FROM_STATUS',p_curr_workorder_rec.status_code);
478: FND_MESSAGE.SET_TOKEN('TO_STATUS', p_x_workorder_rec.status_code);
479: FND_MSG_PUB.ADD;
480: CLOSE validate_status_csr;
481: RAISE FND_API.G_EXC_ERROR;
482: ELSE

Line 1405: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_INV_CR');

1401: IF(p_x_Operations(i).OPERATION_FLAG = 'C')THEN
1402: OPEN get_route_id_validation_csr(p_workorder_rec.Workorder_Id);
1403: FETCH get_route_id_validation_csr INTO l_temp;
1404: IF(get_route_id_validation_csr%NOTFOUND)THEN
1405: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_INV_CR');
1406: FND_MESSAGE.SET_TOKEN('RECORD',l_prd_operation_tbl(j).operation_sequence_num,false);
1407: FND_MSG_PUB.ADD;
1408: CLOSE get_route_id_validation_csr;
1409: RAISE FND_API.G_EXC_ERROR;

Line 1406: FND_MESSAGE.SET_TOKEN('RECORD',l_prd_operation_tbl(j).operation_sequence_num,false);

1402: OPEN get_route_id_validation_csr(p_workorder_rec.Workorder_Id);
1403: FETCH get_route_id_validation_csr INTO l_temp;
1404: IF(get_route_id_validation_csr%NOTFOUND)THEN
1405: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_OPER_INV_CR');
1406: FND_MESSAGE.SET_TOKEN('RECORD',l_prd_operation_tbl(j).operation_sequence_num,false);
1407: FND_MSG_PUB.ADD;
1408: CLOSE get_route_id_validation_csr;
1409: RAISE FND_API.G_EXC_ERROR;
1410: END IF;

Line 1420: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_INV_OP_STATUS');

1416: AND p_x_Operations(i).status IS NOT NULL)THEN
1417: OPEN get_operation_status(p_x_Operations(i).status);
1418: FETCH get_operation_status INTO p_x_Operations(i).status_code;
1419: IF(get_operation_status%NOTFOUND)THEN
1420: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_INV_OP_STATUS');
1421: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_x_Operations(i).Operation_Sequence_Number);
1422: FND_MSG_PUB.ADD;
1423: CLOSE get_operation_status;
1424: RAISE FND_API.G_EXC_ERROR;

Line 1421: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_x_Operations(i).Operation_Sequence_Number);

1417: OPEN get_operation_status(p_x_Operations(i).status);
1418: FETCH get_operation_status INTO p_x_Operations(i).status_code;
1419: IF(get_operation_status%NOTFOUND)THEN
1420: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_UPDOP_INV_OP_STATUS');
1421: FND_MESSAGE.SET_TOKEN('OP_SEQ', p_x_Operations(i).Operation_Sequence_Number);
1422: FND_MSG_PUB.ADD;
1423: CLOSE get_operation_status;
1424: RAISE FND_API.G_EXC_ERROR;
1425: END IF;

Line 2547: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');

2543: IF p_x_workorder_rec.status_code IS NULL AND p_x_workorder_rec.status IS NOT NULL THEN
2544: OPEN get_status_csr(p_x_workorder_rec.status);
2545: FETCH get_status_csr INTO p_x_workorder_rec.status_code;
2546: IF get_status_csr%NOTFOUND THEN
2547: FND_MESSAGE.SET_NAME('AHL','AHL_PP_JOB_INV_STATUS_JSP');
2548: FND_MSG_PUB.ADD;
2549: CLOSE get_status_csr;
2550: RAISE FND_API.G_EXC_ERROR;
2551: ELSE

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

2716:
2717: IF(p_x_workorder_rec.Object_Version_Number IS NULL OR
2718: p_x_workorder_rec.Object_Version_Number <> l_workorder_rec.Object_Version_Number)THEN
2719: --AHL_DEBUG_PUB.debug( 'Object Version Numbers are not same');
2720: FND_MESSAGE.SET_NAME('AHL','AHL_COM_RECORD_CHANGED');
2721: FND_MSG_PUB.ADD;
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:

Line 2731: FND_MESSAGE.SET_NAME('AHL','AHL_PP_UNCLOSE_ONLY_CLOSED');

2727:
2728: IF(p_x_workorder_rec.UNCLOSE_WORKORDER_FLAG = 'Y') THEN
2729:
2730: IF (l_workorder_rec.Status_Code <> '12') THEN
2731: FND_MESSAGE.SET_NAME('AHL','AHL_PP_UNCLOSE_ONLY_CLOSED');
2732: FND_MSG_PUB.ADD;
2733: RAISE FND_API.G_EXC_ERROR;
2734: END IF;
2735: