DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on FND_MESSAGE

Line 109: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');

105: --Check for Item scheduled
106: OPEN c_visit_task_matrl_cur(l_schedule_material_id);
107: FETCH c_visit_task_matrl_cur INTO l_scheduled_date,l_scheduled_quantity;
108: IF l_scheduled_date IS NOT NULL THEN
109: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');
110: Fnd_Msg_Pub.ADD;
111: CLOSE c_visit_task_matrl_cur;
112: RAISE Fnd_Api.G_EXC_ERROR;
113: ELSE

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

449: (l_inventory_item_id, l_uom_code, l_requested_quantity);
450:
451: -- Required to check the UOM Conversion exists in mtl_units_of_measure
452: IF l_prim_quantity IS NULL THEN
453: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
454: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
455: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
456: FND_MSG_PUB.add;
457: RAISE FND_API.G_EXC_ERROR;

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

450:
451: -- Required to check the UOM Conversion exists in mtl_units_of_measure
452: IF l_prim_quantity IS NULL THEN
453: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
454: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
455: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
456: FND_MSG_PUB.add;
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;

Line 455: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);

451: -- Required to check the UOM Conversion exists in mtl_units_of_measure
452: IF l_prim_quantity IS NULL THEN
453: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
454: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
455: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
456: FND_MSG_PUB.add;
457: RAISE FND_API.G_EXC_ERROR;
458: END IF;
459:

Line 842: FND_MESSAGE.set_name( 'AHL','AHL_LTP_SCHE_ID_INVALID' );

838: --
839: OPEN Get_Planned_Items_cur(l_planned_materials_tbl(i).schedule_material_id);
840: FETCH Get_Planned_Items_cur INTO l_Planned_Items_rec;
841: IF Get_Planned_Items_cur%NOTFOUND THEN
842: FND_MESSAGE.set_name( 'AHL','AHL_LTP_SCHE_ID_INVALID' );
843: FND_MSG_PUB.add;
844: IF (l_log_error >= l_log_current_level)THEN
845: fnd_log.string
846: (

Line 864: FND_MESSAGE.set_name( 'AHL','AHL_LTP_RECORD_INVALID' );

860: l_planned_materials_tbl(i).object_version_number <> FND_API.G_MISS_NUM ) THEN
861: --
862: IF (l_planned_materials_tbl(i).object_version_number <> l_Planned_Items_rec.object_version_number )
863: THEN
864: FND_MESSAGE.set_name( 'AHL','AHL_LTP_RECORD_INVALID' );
865: FND_MSG_PUB.add;
866: IF (l_log_error >= l_log_current_level)THEN
867: fnd_log.string
868: (

Line 885: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_INVALID' );

881: OPEN Get_Inv_Item_cur(l_planned_materials_tbl(i).item_description,
882: l_planned_items_rec.organization_id);
883: FETCH Get_Inv_Item_cur INTO l_planned_materials_tbl(i).inventory_item_id;
884: IF Get_Inv_Item_cur%NOTFOUND THEN
885: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_INVALID' );
886: FND_MSG_PUB.add;
887: IF (l_log_error >= l_log_current_level)THEN
888: fnd_log.string
889: (

Line 919: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_RSV_EXISTS' );

915: AND MR.inventory_item_id = SM.inventory_item_id;
916:
917: -- This is based on PRIMARY_RESERVATION_QUANTITY is not null in mtl_reservations
918: IF l_rsvd_quantity IS NOT NULL THEN
919: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_RSV_EXISTS' );
920: -- Cannot change the item required because at least one reservation already exists for this item.
921: FND_MSG_PUB.add;
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;

Line 939: Fnd_message.SET_NAME('AHL','AHL_LTP_QUANTITY_INVALID');

935: IF l_planned_materials_tbl(i).quantity < 0 THEN
936:
937: -- yazhou 03-JUL-2006 ends
938: --
939: Fnd_message.SET_NAME('AHL','AHL_LTP_QUANTITY_INVALID');
940: Fnd_Msg_Pub.ADD;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;
943:

Line 961: Fnd_message.SET_NAME('AHL','AHL_LTP_QTY_EXCEEDS');

957: AND MR.inventory_item_id = SM.inventory_item_id;
958:
959: IF NVL((NVL(l_rsvd_quantity,0) + nvl(l_Planned_Items_rec.completed_quantity,0)),-9) > NVL(l_planned_materials_tbl(i).quantity,-9)
960: THEN
961: Fnd_message.SET_NAME('AHL','AHL_LTP_QTY_EXCEEDS');
962: --Completed quantity plus reserved quantity exceeded scheduled quantity
963: Fnd_Msg_Pub.ADD;
964: RAISE FND_API.G_EXC_ERROR;
965: END IF;

Line 974: Fnd_message.SET_NAME('AHL','AHL_LTP_DATE_INVALID');

970: IF (l_planned_materials_tbl(i).requested_date IS NOT NULL AND
971: l_planned_materials_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
972: IF l_planned_materials_tbl(i).requested_date < trunc(sysdate) THEN
973: --
974: Fnd_message.SET_NAME('AHL','AHL_LTP_DATE_INVALID');
975: Fnd_Msg_Pub.ADD;
976: RAISE FND_API.G_EXC_ERROR;
977:
978: END IF;

Line 994: Fnd_message.SET_NAME('AHL','AHL_LTP_REQ_DATE_RANGE');

990: IF (TRUNC(l_planned_materials_tbl(i).requested_date) < TRUNC(l_visit_start_date)) OR
991: (l_visit_end_date is not NULL AND
992: (TRUNC(l_planned_materials_tbl(i).requested_date) > TRUNC(l_visit_end_date))) THEN
993:
994: Fnd_message.SET_NAME('AHL','AHL_LTP_REQ_DATE_RANGE');
995: Fnd_Msg_Pub.ADD;
996: RAISE FND_API.G_EXC_ERROR;
997:
998: END IF;

Line 3112: FND_MESSAGE.set_name('AHL', 'AHL_LTP_MULTI_ORG');

3108:
3109: IF l_prev_org_id IS NULL THEN
3110: Return;
3111: ELSIF l_org_count > 1 THEN
3112: FND_MESSAGE.set_name('AHL', 'AHL_LTP_MULTI_ORG');
3113: FND_MSG_PUB.ADD;
3114: RAISE Fnd_Api.g_exc_error;
3115: END IF;
3116:

Line 3262: Fnd_Message.SET_NAME('AHL','AHL_VISIT_TASKID_NULL');

3258: IF (p_visit_task_id IS NULL) THEN
3259: IF (l_log_statement >= l_log_current_level) THEN
3260: fnd_log.string( l_log_statement,L_DEBUG_KEY,'Task id is null' );
3261: END IF;
3262: Fnd_Message.SET_NAME('AHL','AHL_VISIT_TASKID_NULL');
3263: Fnd_Msg_Pub.ADD;
3264: RAISE Fnd_Api.G_EXC_ERROR;
3265: END IF;
3266: