DBA Data[Home] [Help]

APPS.AHL_LTP_MATRL_AVAL_PVT dependencies on FND_MESSAGE

Line 134: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );

130: --Check for Instance Exists
131: OPEN Instance_Id_Cur;
132: FETCH Instance_Id_Cur INTO l_instance_id;
133: IF Instance_Id_Cur%NOTFOUND THEN
134: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
135: FND_MSG_PUB.add;
136: CLOSE Instance_Id_Cur;
137: RAISE FND_API.G_EXC_ERROR;
138: END IF;

Line 497: Fnd_Message.SET_NAME('AHL','AHL_VISIT_UNSCHEDULED');

493: --Validation for schedule visit
494: OPEN Check_Sch_Visit_cur(p_x_material_avl_tbl(1).visit_id);
495: FETCH Check_Sch_Visit_cur INTO l_dummy;
496: IF Check_Sch_Visit_cur%FOUND THEN
497: Fnd_Message.SET_NAME('AHL','AHL_VISIT_UNSCHEDULED');
498: Fnd_Msg_Pub.ADD;
499: CLOSE Check_Sch_Visit_cur;
500: RAISE Fnd_Api.G_EXC_ERROR;
501: END IF;

Line 526: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_ID_NOT_EXISTS');

522: --Check for schedule mat rec
523: OPEN Schedule_Matrl_cur(p_x_material_avl_tbl(i).schedule_material_id);
524: FETCH Schedule_Matrl_cur INTO l_Schedule_Matrl_Rec;
525: IF Schedule_Matrl_cur%NOTFOUND THEN
526: Fnd_Message.SET_NAME('AHL','AHL_LTP_ORG_ID_NOT_EXISTS');
527: Fnd_Msg_Pub.ADD;
528: CLOSE Schedule_Matrl_cur;
529: RAISE Fnd_Api.G_EXC_ERROR;
530: END IF;

Line 535: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');

531: CLOSE Schedule_Matrl_cur;
532:
533: --Added by sowsubra - starts
534: IF l_Schedule_Matrl_Rec.status = 'IN-SERVICE' THEN
535: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
536: Fnd_Msg_Pub.ADD;
537: RAISE Fnd_Api.G_EXC_ERROR;
538: END IF;
539: --Added by sowsubra - ends

Line 1038: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );

1034: --Check for Instance Id
1035: OPEN Instance_Id_Cur;
1036: FETCH Instance_Id_Cur INTO l_instance_id;
1037: IF Instance_Id_Cur%NOTFOUND THEN
1038: FND_MESSAGE.Set_Name( 'AHL','AHL_LTP_ATP_INS_ENABLE' );
1039: FND_MSG_PUB.add;
1040: CLOSE Instance_Id_Cur;
1041: RAISE FND_API.G_EXC_ERROR;
1042: END IF;

Line 1082: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');

1078: CLOSE Planned_Order_Cur;
1079:
1080: --Added by sowsubra - start
1081: IF l_Planned_Order_Rec.status = 'IN-SERVICE' THEN
1082: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1083: Fnd_Msg_Pub.ADD;
1084: RAISE Fnd_Api.G_EXC_ERROR;
1085: END IF;
1086: --Added by sowsubra - end

Line 1424: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');

1420: END IF;
1421:
1422: --Added by sowsubra - starts
1423: IF l_planned_matrl_tbl(i).mat_status = 'IN-SERVICE' THEN
1424: Fnd_Message.SET_NAME('AHL','AHL_MAT_STS_INSERVICE');
1425: Fnd_Msg_Pub.ADD;
1426: RAISE Fnd_Api.G_EXC_ERROR;
1427: END IF;
1428: --Added by sowsubra - ends