DBA Data[Home] [Help]

APPS.MRP_VALIDATE_SOURCING_RULE dependencies on FND_MSG_PUB

Line 27: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

23: THEN
24:
25: l_return_status := FND_API.G_RET_STS_ERROR;
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');

Line 32: FND_MSG_PUB.Add;

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:
36: END IF;

Line 79: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

75: WHEN OTHERS THEN
76:
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: FND_MSG_PUB.Add_Exc_Msg
82: ( G_PKG_NAME
83: , 'Entity'

Line 81: FND_MSG_PUB.Add_Exc_Msg

77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78:
79: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
80: THEN
81: FND_MSG_PUB.Add_Exc_Msg
82: ( G_PKG_NAME
83: , 'Entity'
84: );
85: END IF;

Line 113: FND_MSG_PUB.Add;

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:
117: -- Done.

Line 135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

131: WHEN OTHERS THEN
132:
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134:
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME
139: , 'Entity_Delete'

Line 137: FND_MSG_PUB.Add_Exc_Msg

133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
134:
135: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME
139: , 'Entity_Delete'
140: );
141: END IF;

Line 406: FND_MSG_PUB.Add;

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
409: dbms_output.put_line ('Error Organization_Id');
410: x_return_status := FND_API.G_RET_STS_ERROR;

Line 489: FND_MSG_PUB.Add;

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
492: dbms_output.put_line ('Error Sourcing_Rule_Type');
493: x_return_status := FND_API.G_RET_STS_ERROR;

Line 524: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

520: WHEN OTHERS THEN
521:
522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523:
524: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
526: FND_MSG_PUB.Add_Exc_Msg
527: ( G_PKG_NAME
528: , 'Attributes'

Line 526: FND_MSG_PUB.Add_Exc_Msg

522: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
523:
524: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
525: THEN
526: FND_MSG_PUB.Add_Exc_Msg
527: ( G_PKG_NAME
528: , 'Attributes'
529: );
530: END IF;

Line 957: FND_MSG_PUB.Add;

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;
961:

Line 1073: FND_MSG_PUB.Add;

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
1077: -- not already exist in the given org

Line 1090: FND_MSG_PUB.Add;

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;
1093:
1094: END IF;

Line 1113: FND_MSG_PUB.Add;

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
1117: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

Line 1119: FND_MSG_PUB.Add;

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;
1123:

Line 1141: FND_MSG_PUB.Add;

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
1145: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

Line 1147: FND_MSG_PUB.Add;

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;
1151: