DBA Data[Home] [Help]

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on FND_MESSAGE

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

139: --Check for Item scheduled
140: OPEN c_visit_task_matrl_cur(l_sch_mtls_Rec.scheduled_material_id);
141: FETCH c_visit_task_matrl_cur INTO l_scheduled_date,l_scheduled_quantity;
142: IF l_scheduled_date IS NOT NULL THEN
143: Fnd_Message.SET_NAME('AHL','AHL_LTP_MRP_SCHEDUl_ITEM');
144: Fnd_Msg_Pub.ADD;
145: CLOSE c_visit_task_matrl_cur;
146: RAISE Fnd_Api.G_EXC_ERROR;
147: ELSE

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

481: l_prim_quantity := AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty(l_inventory_item_id, l_uom_code, l_requested_quantity);
482:
483: -- Required to check the UOM Conversion exists in mtl_units_of_measure
484: IF l_prim_quantity IS NULL THEN
485: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
486: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
487: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
488: FND_MSG_PUB.add;
489: RAISE FND_API.G_EXC_ERROR;

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

482:
483: -- Required to check the UOM Conversion exists in mtl_units_of_measure
484: IF l_prim_quantity IS NULL THEN
485: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
486: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
487: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
488: FND_MSG_PUB.add;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;

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

483: -- Required to check the UOM Conversion exists in mtl_units_of_measure
484: IF l_prim_quantity IS NULL THEN
485: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_UOM_CONV_NOT_EXIST' );
486: FND_MESSAGE.Set_Token('FUOM', l_uom_code);
487: FND_MESSAGE.Set_Token('TUOM', l_prim_uom_code);
488: FND_MSG_PUB.add;
489: RAISE FND_API.G_EXC_ERROR;
490: END IF;
491:

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

849: --
850: OPEN Get_Planned_Items_cur(l_planned_materials_tbl(i).schedule_material_id);
851: FETCH Get_Planned_Items_cur INTO l_Planned_Items_rec;
852: IF Get_Planned_Items_cur%NOTFOUND THEN
853: FND_MESSAGE.set_name( 'AHL','AHL_LTP_SCHE_ID_INVALID' );
854: FND_MSG_PUB.add;
855: IF (l_log_error >= l_log_current_level)THEN
856: fnd_log.string
857: (

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

871: l_planned_materials_tbl(i).object_version_number <> FND_API.G_MISS_NUM ) THEN
872: --
873: IF (l_planned_materials_tbl(i).object_version_number <> l_Planned_Items_rec.object_version_number )
874: THEN
875: FND_MESSAGE.set_name( 'AHL','AHL_LTP_RECORD_INVALID' );
876: FND_MSG_PUB.add;
877: IF (l_log_error >= l_log_current_level)THEN
878: fnd_log.string
879: (

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

892: OPEN Get_Inv_Item_cur(l_planned_materials_tbl(i).item_description,
893: l_planned_items_rec.organization_id);
894: FETCH Get_Inv_Item_cur INTO l_planned_materials_tbl(i).inventory_item_id;
895: IF Get_Inv_Item_cur%NOTFOUND THEN
896: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_INVALID' );
897: FND_MSG_PUB.add;
898: IF (l_log_error >= l_log_current_level)THEN
899: fnd_log.string
900: (

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

926: AND MR.inventory_item_id = SM.inventory_item_id;
927:
928: -- This is based on PRIMARY_RESERVATION_QUANTITY is not null in mtl_reservations
929: IF l_rsvd_quantity IS NOT NULL THEN
930: FND_MESSAGE.set_name( 'AHL','AHL_LTP_ITEM_RSV_EXISTS' );
931: -- Cannot change the item required because at least one reservation already exists for this item.
932: FND_MSG_PUB.add;
933: RAISE FND_API.G_EXC_ERROR;
934: END IF;

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

946: IF l_planned_materials_tbl(i).quantity < 0 THEN
947:
948: -- yazhou 03-JUL-2006 ends
949: --
950: Fnd_message.SET_NAME('AHL','AHL_LTP_QUANTITY_INVALID');
951: Fnd_Msg_Pub.ADD;
952: RAISE FND_API.G_EXC_ERROR;
953: END IF;
954:

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

968: AND MR.inventory_item_id = SM.inventory_item_id;
969:
970: IF NVL((NVL(l_rsvd_quantity,0) + nvl(l_Planned_Items_rec.completed_quantity,0)),-9) > NVL(l_planned_materials_tbl(i).quantity,-9)
971: THEN
972: Fnd_message.SET_NAME('AHL','AHL_LTP_QTY_EXCEEDS');
973: --Completed quantity plus reserved quantity exceeded scheduled quantity
974: Fnd_Msg_Pub.ADD;
975: RAISE FND_API.G_EXC_ERROR;
976: END IF;

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

981: IF (l_planned_materials_tbl(i).requested_date IS NOT NULL AND
982: l_planned_materials_tbl(i).requested_date <> FND_API.G_MISS_DATE) THEN
983: IF l_planned_materials_tbl(i).requested_date < trunc(sysdate) THEN
984: --
985: Fnd_message.SET_NAME('AHL','AHL_LTP_DATE_INVALID');
986: Fnd_Msg_Pub.ADD;
987: RAISE FND_API.G_EXC_ERROR;
988:
989: END IF;

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

1001: IF (TRUNC(l_planned_materials_tbl(i).requested_date) < TRUNC(l_visit_start_date)) OR
1002: (l_visit_end_date is not NULL AND
1003: (TRUNC(l_planned_materials_tbl(i).requested_date) > TRUNC(l_visit_end_date))) THEN
1004:
1005: Fnd_message.SET_NAME('AHL','AHL_LTP_REQ_DATE_RANGE');
1006: Fnd_Msg_Pub.ADD;
1007: RAISE FND_API.G_EXC_ERROR;
1008:
1009: END IF;

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

3177:
3178: IF l_prev_org_id IS NULL THEN
3179: Return;
3180: ELSIF l_org_count > 1 THEN
3181: FND_MESSAGE.set_name('AHL', 'AHL_LTP_MULTI_ORG');
3182: FND_MSG_PUB.ADD;
3183: RAISE Fnd_Api.g_exc_error;
3184: END IF;
3185:

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

3327: IF (p_visit_task_id IS NULL) THEN
3328: IF (l_log_statement >= l_log_current_level) THEN
3329: fnd_log.string( l_log_statement,L_DEBUG_KEY,'Task id is null' );
3330: END IF;
3331: Fnd_Message.SET_NAME('AHL','AHL_VISIT_TASKID_NULL');
3332: Fnd_Msg_Pub.ADD;
3333: RAISE Fnd_Api.G_EXC_ERROR;
3334: END IF;
3335: