DBA Data[Home] [Help]

APPS.MRP_VALIDATE_SHIPPING_ORG 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','Sr_Source_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','Sr_Source_Id');
32: FND_MSG_PUB.Add;
33:
34: END IF;
35:
36: END IF;

Line 60: FND_MSG_PUB.Add;

56: p_Shipping_Org_rec.source_organization_id IS NULL THEN
57: dbms_output.put_line ('Error -source_organization_id required');
58: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
59: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
60: FND_MSG_PUB.Add;
61: l_return_status := FND_API.G_RET_STS_ERROR;
62: END IF;
63:
64: IF p_Shipping_Org_rec.source_type = 3 AND

Line 69: FND_MSG_PUB.Add;

65: p_Shipping_Org_rec.vendor_id IS NULL THEN
66: dbms_output.put_line ('Error - vendor_id required');
67: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
68: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Vendor_Id');
69: FND_MSG_PUB.Add;
70: l_return_status := FND_API.G_RET_STS_ERROR;
71: END IF;
72:
73: --

Line 84: FND_MSG_PUB.Add;

80: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
81: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method');
82: FND_MESSAGE.SET_TOKEN('DETAILS',
83: 'Ship method should be NULL for this Source type');
84: FND_MSG_PUB.Add;
85: l_return_status := FND_API.G_RET_STS_ERROR;
86: END IF;
87:
88: IF p_Shipping_Org_rec.vendor_site_id IS NOT NULL AND

Line 93: FND_MSG_PUB.Add;

89: p_Shipping_Org_rec.vendor_id IS NULL THEN
90: dbms_output.put_line ('error - vendor_id not specified');
91: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
92: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Vendor_Id');
93: FND_MSG_PUB.Add;
94: l_return_status := FND_API.G_RET_STS_ERROR;
95: END IF;
96:
97: -- Done validating entity

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

111: WHEN OTHERS THEN
112:
113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114:
115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
116: THEN
117: FND_MSG_PUB.Add_Exc_Msg
118: ( G_PKG_NAME
119: , 'Entity'

Line 117: FND_MSG_PUB.Add_Exc_Msg

113: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
114:
115: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
116: THEN
117: FND_MSG_PUB.Add_Exc_Msg
118: ( G_PKG_NAME
119: , 'Entity'
120: );
121: END IF;

Line 154: FND_MSG_PUB.Add;

150: FND_MESSAGE.SET_TOKEN('OPERATION','DELETE');
151: FND_MESSAGE.SET_TOKEN('ENTITY','Shipping_Org');
152: FND_MESSAGE.SET_TOKEN('DETAILS', 'There is only one Source ' ||
153: 'Organization for this Receiving Organization');
154: FND_MSG_PUB.Add;
155: l_return_status := FND_API.G_RET_STS_ERROR;
156: END IF;
157:
158:

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

173: WHEN OTHERS THEN
174:
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg
180: ( G_PKG_NAME
181: , 'Entity_Delete'

Line 179: FND_MSG_PUB.Add_Exc_Msg

175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
178: THEN
179: FND_MSG_PUB.Add_Exc_Msg
180: ( G_PKG_NAME
181: , 'Entity_Delete'
182: );
183: END IF;

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

570: WHEN OTHERS THEN
571:
572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573:
574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
575: THEN
576: FND_MSG_PUB.Add_Exc_Msg
577: ( G_PKG_NAME
578: , 'Attributes'

Line 576: FND_MSG_PUB.Add_Exc_Msg

572: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
573:
574: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
575: THEN
576: FND_MSG_PUB.Add_Exc_Msg
577: ( G_PKG_NAME
578: , 'Attributes'
579: );
580: END IF;

Line 601: FND_MSG_PUB.Add;

597: THEN
598: dbms_output.put_line ('Val_Allocation_Percent Error ');
599: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
600: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Allocation_Percent');
601: FND_MSG_PUB.Add;
602: RETURN FALSE;
603: ELSIF p_Allocation_Percent > 100 THEN
604: dbms_output.put_line ('Val_Allocation_Percent Error ');
605: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

Line 609: FND_MSG_PUB.Add;

605: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Allocation_Percent');
607: FND_MESSAGE.SET_TOKEN('DETAILS',
608: 'Allocation_Percent cannot be greater than 100');
609: FND_MSG_PUB.Add;
610: RETURN FALSE;
611: END IF;
612:
613: RETURN TRUE;

Line 1136: FND_MSG_PUB.Add;

1132: IF l_count = 0 THEN
1133: dbms_output.put_line ('Val_Ship_Method Error');
1134: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1135: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_Method');
1136: FND_MSG_PUB.Add;
1137: RETURN FALSE;
1138: END IF;
1139:
1140: END IF;

Line 1171: FND_MSG_PUB.Add;

1167: IF l_count = 0 THEN
1168: dbms_output.put_line ('Val_Source_Organization_Id Error');
1169: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1170: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1171: FND_MSG_PUB.Add;
1172: RETURN FALSE;
1173: END IF;
1174: END IF;
1175:

Line 1194: FND_MSG_PUB.Add;

1190: THEN
1191: dbms_output.put_line ('Val_Source_Type Error ');
1192: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1193: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1194: FND_MSG_PUB.Add;
1195: RETURN FALSE;
1196: ELSIF (p_Source_Type <> 1) AND (p_Source_Type <> 2) AND
1197: (p_Source_Type <> 3) THEN
1198: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');

Line 1200: FND_MSG_PUB.Add;

1196: ELSIF (p_Source_Type <> 1) AND (p_Source_Type <> 2) AND
1197: (p_Source_Type <> 3) THEN
1198: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1199: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1200: FND_MSG_PUB.Add;
1201: dbms_output.put_line ('Val_Source_Type Error ');
1202: RETURN FALSE;
1203: END IF;
1204:

Line 1252: FND_MSG_PUB.Add;

1248: IF l_count = 0 THEN
1249: dbms_output.put_line ('Val_Vendor_Id Error');
1250: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1251: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Vendor_Id');
1252: FND_MSG_PUB.Add;
1253: RETURN FALSE;
1254: END IF;
1255: END IF;
1256:

Line 1288: FND_MSG_PUB.Add;

1284: IF l_count = 0 THEN
1285: dbms_output.put_line ('Val_Vendor_Site_Id Error');
1286: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1287: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Vendor_Site_Id');
1288: FND_MSG_PUB.Add;
1289: RETURN FALSE;
1290: END IF;
1291: END IF;
1292: