DBA Data[Home] [Help]

APPS.AHL_LTP_MTL_REQ_PVT dependencies on FND_MESSAGE

Line 590: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_NULL');

586: END IF;
587:
588: -- Get the Route Id
589: IF (p_route_id IS NULL AND p_mr_route_id IS NULL) THEN
590: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_NULL');
591: FND_MSG_PUB.ADD;
592: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
593: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
594: END IF;

Line 607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');

603: -- Validate the Route Id
604: OPEN validate_route_id_csr(c_route_id => x_route_id);
605: FETCH validate_route_id_csr INTO l_dummy;
606: IF (validate_route_id_csr%NOTFOUND) THEN
607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');
608: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);
609: FND_MSG_PUB.ADD;
610: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 608: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);

604: OPEN validate_route_id_csr(c_route_id => x_route_id);
605: FETCH validate_route_id_csr INTO l_dummy;
606: IF (validate_route_id_csr%NOTFOUND) THEN
607: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_ROUTE_ID_INVALID');
608: FND_MESSAGE.Set_Token('ROUTE_ID', x_route_id);
609: FND_MSG_PUB.ADD;
610: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
611: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
612: END IF;

Line 618: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_NULL');

614: CLOSE validate_route_id_csr;
615:
616: -- Validate the Instance Id
617: IF (p_item_instance_id IS NULL) THEN
618: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_NULL');
619: FND_MSG_PUB.ADD;
620: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
621: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
622: END IF;

Line 630: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');

626: IF (check_visit_tasks_status_csr%FOUND) THEN
627: OPEN validate_instance_id_csr;
628: FETCH validate_instance_id_csr INTO l_dummy;
629: IF (validate_instance_id_csr%NOTFOUND) THEN
630: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');
631: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
632: FND_MSG_PUB.ADD;
633: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 631: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);

627: OPEN validate_instance_id_csr;
628: FETCH validate_instance_id_csr INTO l_dummy;
629: IF (validate_instance_id_csr%NOTFOUND) THEN
630: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_INST_ID_INVALID');
631: FND_MESSAGE.Set_Token('INST_ID', p_item_instance_id);
632: FND_MSG_PUB.ADD;
633: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
634: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
635: END IF;

Line 644: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_NULL');

640: END IF;
641:
642: -- Validate the Request Type
643: IF (p_request_type IS NULL) THEN
644: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_NULL');
645: FND_MSG_PUB.ADD;
646: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
648: END IF;

Line 650: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');

646: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
648: END IF;
649: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN
650: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
651: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);
652: FND_MSG_PUB.ADD;
653: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 651: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);

647: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
648: END IF;
649: ELSIF (p_request_type NOT IN (G_REQ_TYPE_FORECAST, G_REQ_TYPE_PLANNED)) THEN
650: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_TYPE_INVALID');
651: FND_MESSAGE.Set_Token('REQ_TYPE', p_request_type);
652: FND_MSG_PUB.ADD;
653: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
654: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
655: END IF;

Line 660: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_NULL');

656: END IF;
657:
658: -- Validate the Requirement Date
659: IF (p_requirement_date IS NULL) THEN
660: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_NULL');
661: FND_MSG_PUB.ADD;
662: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
663: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
664: END IF;

Line 669: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');

665: -- SKPATHAK :: Bug 8343599 :: 13-APR-2009
666: -- Removing the check to allow creation of Material Requirements in the past.
667: /**
668: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN
669: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
670: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);
671: FND_MSG_PUB.ADD;
672: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);

Line 670: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);

666: -- Removing the check to allow creation of Material Requirements in the past.
667: /**
668: ELSIF (TRUNC(p_requirement_date) < TRUNC(SYSDATE)) THEN
669: FND_MESSAGE.Set_Name('AHL', 'AHL_LTP_APS_REQ_DATE_PAST');
670: FND_MESSAGE.Set_Token('REQ_DATE', p_requirement_date);
671: FND_MSG_PUB.ADD;
672: IF (G_LEVEL_ERROR >= G_CURRENT_RUNTIME_LEVEL) THEN
673: FND_LOG.MESSAGE(G_LEVEL_ERROR, L_DEBUG_KEY, FALSE);
674: END IF;

Line 2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );

2292: END IF;
2293:
2294: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2295: IF l_quantity IS NULL THEN
2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2299: FND_MSG_PUB.add;
2300: RAISE FND_API.G_EXC_ERROR;

Line 2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);

2293:
2294: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2295: IF l_quantity IS NULL THEN
2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2299: FND_MSG_PUB.add;
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;

Line 2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);

2294: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2295: IF l_quantity IS NULL THEN
2296: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2297: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
2298: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2299: FND_MSG_PUB.add;
2300: RAISE FND_API.G_EXC_ERROR;
2301: END IF;
2302:

Line 2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );

2312: l_cp_uom,
2313: l_remaining_qty);
2314: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2315: IF l_remaining_qty IS NULL THEN
2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);
2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2319: FND_MSG_PUB.add;
2320: RAISE FND_API.G_EXC_ERROR;

Line 2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);

2313: l_remaining_qty);
2314: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2315: IF l_remaining_qty IS NULL THEN
2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);
2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2319: FND_MSG_PUB.add;
2320: RAISE FND_API.G_EXC_ERROR;
2321: END IF;

Line 2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);

2314: -- Required to check the UOM Conversion exists in mtl_units_of_measure
2315: IF l_remaining_qty IS NULL THEN
2316: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
2317: FND_MESSAGE.Set_Token('FUOM', l_cp_uom);
2318: FND_MESSAGE.Set_Token('TUOM', p_x_route_mtl_reqs(p_x_index).uom_code);
2319: FND_MSG_PUB.add;
2320: RAISE FND_API.G_EXC_ERROR;
2321: END IF;
2322:

Line 2736: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');

2732: FND_LOG.STRING(G_LEVEL_STATEMENT, L_DEBUG_KEY, 'Schedule Material ID: '|| p_schedule_material_id);
2733: END IF;
2734:
2735: IF p_schedule_material_id IS NULL THEN
2736: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2737: Fnd_Msg_Pub.ADD;
2738: RAISE Fnd_Api.G_EXC_ERROR;
2739: END IF;
2740:

Line 2744: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');

2740:
2741: OPEN get_asm_req_details_csr(p_schedule_material_id);
2742: FETCH get_asm_req_details_csr INTO l_asm_req_rec;
2743: IF get_asm_req_details_csr%NOTFOUND THEN
2744: Fnd_Message.SET_NAME('AHL','AHL_LTP_MAT_ID_INVALID');
2745: Fnd_Msg_Pub.ADD;
2746: CLOSE get_asm_req_details_csr;
2747: RAISE Fnd_Api.G_EXC_ERROR;
2748: END IF;