DBA Data[Home] [Help]

APPS.MRP_VALIDATE_SOURCING_RULE dependencies on FND_MESSAGE

Line 30: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');

26:
27: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:
30: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Id');
32: FND_MSG_PUB.Add;
33:
34: END IF;

Line 31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Id');

27: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
28: THEN
29:
30: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Id');
32: FND_MSG_PUB.Add;
33:
34: END IF;
35:

Line 109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');

105: WHERE sourcing_rule_id = p_Sourcing_Rule_rec.sourcing_rule_id;
106:
107: IF l_count > 0 THEN
108: dbms_output.put_line ('Cannot delete Sourcing Rule');
109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');
112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');
113: FND_MSG_PUB.Add;

Line 110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');

106:
107: IF l_count > 0 THEN
108: dbms_output.put_line ('Cannot delete Sourcing Rule');
109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');
112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');
113: FND_MSG_PUB.Add;
114: l_return_status := FND_API.G_RET_STS_ERROR;

Line 111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');

107: IF l_count > 0 THEN
108: dbms_output.put_line ('Cannot delete Sourcing Rule');
109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');
112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');
113: FND_MSG_PUB.Add;
114: l_return_status := FND_API.G_RET_STS_ERROR;
115: END IF;

Line 112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');

108: dbms_output.put_line ('Cannot delete Sourcing Rule');
109: FND_MESSAGE.SET_NAME('MRP','MRP_OPERATION_ERROR');
110: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
111: FND_MESSAGE.SET_TOKEN('ENTITY','Sourcing_Rule');
112: FND_MESSAGE.SET_TOKEN('DETAILS','This Sourcing Rule has been assigned');
113: FND_MSG_PUB.Add;
114: l_return_status := FND_API.G_RET_STS_ERROR;
115: END IF;
116:

Line 402: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

398: THEN
399: IF (p_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE) AND
400: (p_old_Sourcing_Rule_rec.Organization_Id IS NOT NULL) THEN
401: -- organization_id changed while updating - NOT ALLOWED
402: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');
404: FND_MESSAGE.SET_TOKEN('DETAILS',
405: 'Cannot change Organization while Updating');
406: FND_MSG_PUB.Add;

Line 403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');

399: IF (p_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE) AND
400: (p_old_Sourcing_Rule_rec.Organization_Id IS NOT NULL) THEN
401: -- organization_id changed while updating - NOT ALLOWED
402: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');
404: FND_MESSAGE.SET_TOKEN('DETAILS',
405: 'Cannot change Organization while Updating');
406: FND_MSG_PUB.Add;
407: x_return_status := FND_API.G_RET_STS_ERROR;

Line 404: FND_MESSAGE.SET_TOKEN('DETAILS',

400: (p_old_Sourcing_Rule_rec.Organization_Id IS NOT NULL) THEN
401: -- organization_id changed while updating - NOT ALLOWED
402: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
403: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');
404: FND_MESSAGE.SET_TOKEN('DETAILS',
405: 'Cannot change Organization while Updating');
406: FND_MSG_PUB.Add;
407: x_return_status := FND_API.G_RET_STS_ERROR;
408: ELSIF NOT Val_Organization_Id(p_Sourcing_Rule_rec.Organization_Id) THEN

Line 485: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

481: THEN
482: IF (p_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE) AND
483: (p_old_Sourcing_Rule_rec.Sourcing_Rule_Type IS NOT NULL) THEN
484: -- sourcing_rule_type changed while updating - NOT ALLOWED
485: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
487: FND_MESSAGE.SET_TOKEN('DETAILS',
488: 'Cannot Change Sourcing Rule Type while updating');
489: FND_MSG_PUB.Add;

Line 486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');

482: IF (p_Sourcing_Rule_rec.operation = MRP_Globals.G_OPR_UPDATE) AND
483: (p_old_Sourcing_Rule_rec.Sourcing_Rule_Type IS NOT NULL) THEN
484: -- sourcing_rule_type changed while updating - NOT ALLOWED
485: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
487: FND_MESSAGE.SET_TOKEN('DETAILS',
488: 'Cannot Change Sourcing Rule Type while updating');
489: FND_MSG_PUB.Add;
490: x_return_status := FND_API.G_RET_STS_ERROR;

Line 487: FND_MESSAGE.SET_TOKEN('DETAILS',

483: (p_old_Sourcing_Rule_rec.Sourcing_Rule_Type IS NOT NULL) THEN
484: -- sourcing_rule_type changed while updating - NOT ALLOWED
485: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
486: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
487: FND_MESSAGE.SET_TOKEN('DETAILS',
488: 'Cannot Change Sourcing Rule Type while updating');
489: FND_MSG_PUB.Add;
490: x_return_status := FND_API.G_RET_STS_ERROR;
491: ELSIF NOT Val_Sourcing_Rule_Type(p_Sourcing_Rule_rec.Sourcing_Rule_Type) THEN

Line 955: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

951: FROM MTL_PARAMETERS
952: WHERE organization_id = p_Organization_Id;
953:
954: IF l_count = 0 THEN
955: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');
957: FND_MSG_PUB.Add;
958: RETURN FALSE;
959: END IF;

Line 956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');

952: WHERE organization_id = p_Organization_Id;
953:
954: IF l_count = 0 THEN
955: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
956: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id');
957: FND_MSG_PUB.Add;
958: RETURN FALSE;
959: END IF;
960: END IF;

Line 1071: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');

1067:
1068: IF p_Sourcing_Rule_Name IS NULL OR
1069: p_Sourcing_Rule_Name = FND_API.G_MISS_CHAR
1070: THEN
1071: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');
1073: FND_MSG_PUB.Add;
1074: RETURN FALSE;
1075: ELSE

Line 1072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');

1068: IF p_Sourcing_Rule_Name IS NULL OR
1069: p_Sourcing_Rule_Name = FND_API.G_MISS_CHAR
1070: THEN
1071: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1072: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');
1073: FND_MSG_PUB.Add;
1074: RETURN FALSE;
1075: ELSE
1076: -- make sure that this sourcing rule name does

Line 1086: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

1082: WHERE sourcing_rule_name = p_Sourcing_Rule_Name
1083: AND organization_id = p_organization_id;
1084:
1085: IF l_count > 0 THEN
1086: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');
1088: FND_MESSAGE.SET_TOKEN('DETAILS',
1089: 'This Sourcing Rule already exists');
1090: FND_MSG_PUB.Add;

Line 1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');

1083: AND organization_id = p_organization_id;
1084:
1085: IF l_count > 0 THEN
1086: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');
1088: FND_MESSAGE.SET_TOKEN('DETAILS',
1089: 'This Sourcing Rule already exists');
1090: FND_MSG_PUB.Add;
1091: RETURN FALSE;

Line 1088: FND_MESSAGE.SET_TOKEN('DETAILS',

1084:
1085: IF l_count > 0 THEN
1086: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1087: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Name');
1088: FND_MESSAGE.SET_TOKEN('DETAILS',
1089: 'This Sourcing Rule already exists');
1090: FND_MSG_PUB.Add;
1091: RETURN FALSE;
1092: END IF;

Line 1111: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');

1107:
1108: IF p_Sourcing_Rule_Type IS NULL OR
1109: p_Sourcing_Rule_Type = FND_API.G_MISS_NUM
1110: THEN
1111: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
1113: FND_MSG_PUB.Add;
1114: RETURN FALSE;
1115: ELSE

Line 1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');

1108: IF p_Sourcing_Rule_Type IS NULL OR
1109: p_Sourcing_Rule_Type = FND_API.G_MISS_NUM
1110: THEN
1111: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1112: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
1113: FND_MSG_PUB.Add;
1114: RETURN FALSE;
1115: ELSE
1116: IF (p_Sourcing_Rule_Type <> 1) AND (p_Sourcing_Rule_Type <> 2) THEN

Line 1117: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

1113: FND_MSG_PUB.Add;
1114: RETURN FALSE;
1115: ELSE
1116: IF (p_Sourcing_Rule_Type <> 1) AND (p_Sourcing_Rule_Type <> 2) THEN
1117: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
1119: FND_MSG_PUB.Add;
1120: RETURN FALSE;
1121: END IF;

Line 1118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');

1114: RETURN FALSE;
1115: ELSE
1116: IF (p_Sourcing_Rule_Type <> 1) AND (p_Sourcing_Rule_Type <> 2) THEN
1117: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1118: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
1119: FND_MSG_PUB.Add;
1120: RETURN FALSE;
1121: END IF;
1122: END IF;

Line 1139: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');

1135:
1136: IF p_Status IS NULL OR
1137: p_Status = FND_API.G_MISS_NUM
1138: THEN
1139: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');
1141: FND_MSG_PUB.Add;
1142: RETURN FALSE;
1143: ELSE

Line 1140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');

1136: IF p_Status IS NULL OR
1137: p_Status = FND_API.G_MISS_NUM
1138: THEN
1139: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1140: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');
1141: FND_MSG_PUB.Add;
1142: RETURN FALSE;
1143: ELSE
1144: IF p_Status <> 1 THEN

Line 1145: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

1141: FND_MSG_PUB.Add;
1142: RETURN FALSE;
1143: ELSE
1144: IF p_Status <> 1 THEN
1145: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');
1147: FND_MSG_PUB.Add;
1148: RETURN FALSE;
1149: END IF;

Line 1146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');

1142: RETURN FALSE;
1143: ELSE
1144: IF p_Status <> 1 THEN
1145: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1146: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Status');
1147: FND_MSG_PUB.Add;
1148: RETURN FALSE;
1149: END IF;
1150: END IF;