eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

Line 59: FND_MSG_PUB.Add;

55: p_Assignment_rec.Category_Id IS NULL THEN
56: dbms_output.put_line ('Category ID required');
57: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Id');
59: FND_MSG_PUB.Add;
60: l_return_status := FND_API.G_RET_STS_ERROR;
61: END IF;
62:
63: IF p_Assignment_rec.Assignment_type = 3 AND

Line 68: FND_MSG_PUB.Add;

64: p_Assignment_rec.Inventory_Item_Id IS NULL THEN
65: dbms_output.put_line ('Inventory_Item_Id required');
66: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
67: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Inventory_Item_Id');
68: FND_MSG_PUB.Add;
69: l_return_status := FND_API.G_RET_STS_ERROR;
70: END IF;
71:
72: IF (p_Assignment_rec.Assignment_type = 4 OR

Line 81: FND_MSG_PUB.Add;

77: p_Assignment_rec.Ship_To_Site_Id IS NULL ) THEN
78: dbms_output.put_line ('org/cust required');
79: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
80: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id or Customer_Id');
81: FND_MSG_PUB.Add;
82: l_return_status := FND_API.G_RET_STS_ERROR;
83: END IF;
84:
85: IF p_Assignment_rec.Customer_Id IS NOT NULL AND

Line 90: FND_MSG_PUB.Add;

86: p_Assignment_rec.Ship_To_Site_Id IS NULL THEN
87: dbms_output.put_line ('cust site required');
88: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
89: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_To_Site_Id');
90: FND_MSG_PUB.Add;
91: l_return_status := FND_API.G_RET_STS_ERROR;
92: END IF;
93:
94: --

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

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

Line 119: FND_MSG_PUB.Add_Exc_Msg

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

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

155: WHEN OTHERS THEN
156:
157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: ( G_PKG_NAME
163: , 'Entity_Delete'

Line 161: FND_MSG_PUB.Add_Exc_Msg

157: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
158:
159: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
160: THEN
161: FND_MSG_PUB.Add_Exc_Msg
162: ( G_PKG_NAME
163: , 'Entity_Delete'
164: );
165: END IF;

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

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

Line 579: FND_MSG_PUB.Add_Exc_Msg

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

Line 607: FND_MSG_PUB.Add;

603: THEN
604: dbms_output.put_line ('Val_Assignment_Set_Id Error');
605: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Set_Id');
607: FND_MSG_PUB.Add;
608: RETURN FALSE;
609: ELSE
610: SELECT count(*)
611: INTO l_count

Line 618: FND_MSG_PUB.Add;

614:
615: IF l_count = 0 THEN
616: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Set_Id');
618: FND_MSG_PUB.Add;
619: RETURN FALSE;
620: END IF;
621: END IF;
622:

Line 641: FND_MSG_PUB.Add;

637: THEN
638: dbms_output.put_line ('Val_Assignment_Type error');
639: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Type');
641: FND_MSG_PUB.Add;
642: RETURN FALSE;
643: ELSIF (p_Assignment_Type <> 1) AND
644: (p_Assignment_Type <> 2) AND
645: (p_Assignment_Type <> 3) AND

Line 653: FND_MSG_PUB.Add;

649:
650: dbms_output.put_line ('Val_Assignment_Type error');
651: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Type');
653: FND_MSG_PUB.Add;
654: RETURN FALSE;
655: END IF;
656:
657: RETURN TRUE;

Line 976: FND_MSG_PUB.Add;

972: IF l_count = 0 THEN
973: dbms_output.put_line ('Val_Category_Id Error');
974: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Id');
976: FND_MSG_PUB.Add;
977: RETURN FALSE;
978: END IF;
979: END IF;
980:

Line 1010: FND_MSG_PUB.Add;

1006: IF l_count = 0 THEN
1007: dbms_output.put_line ('Val_Category_Set_Id Error');
1008: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Set_Id');
1010: FND_MSG_PUB.Add;
1011: RETURN FALSE;
1012: END IF;
1013: END IF;
1014:

Line 1081: FND_MSG_PUB.Add;

1077: IF l_count = 0 THEN
1078: dbms_output.put_line ('Val_Customer_Id Error');
1079: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');
1081: FND_MSG_PUB.Add;
1082: RETURN FALSE;
1083: END IF;
1084: END IF;
1085:

Line 1120: FND_MSG_PUB.Add;

1116: IF l_count = 0 THEN
1117: dbms_output.put_line ('Val_Inventory_Item_Id Error');
1118: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1119: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Inventory_Item_Id');
1120: FND_MSG_PUB.Add;
1121: RETURN FALSE;
1122: END IF;
1123: END IF;
1124:

Line 1319: FND_MSG_PUB.Add;

1315: IF l_count = 0 THEN
1316: dbms_output.put_line('Val_Ship_To_Site_Id Error');
1317: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_To_Site_Id');
1319: FND_MSG_PUB.Add;
1320: RETURN FALSE;
1321: END IF;
1322: END IF;
1323:

Line 1345: FND_MSG_PUB.Add;

1341: THEN
1342: dbms_output.put_line ('Error Val_Sourcing_Rule_Id');
1343: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_REQUIRED');
1344: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Id');
1345: FND_MSG_PUB.Add;
1346: RETURN FALSE;
1347: ELSE
1348: SELECT count(*)
1349: INTO l_count

Line 1358: FND_MSG_PUB.Add;

1354: IF l_count = 0 THEN
1355: dbms_output.put_line ('Error Val_Sourcing_Rule_Id');
1356: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1357: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Id');
1358: FND_MSG_PUB.Add;
1359: RETURN FALSE;
1360: END IF;
1361: END IF;
1362:

Line 1383: FND_MSG_PUB.Add;

1379: ELSIF (p_Sourcing_Rule_Type <> 1 AND p_Sourcing_Rule_Type <> 2) THEN
1380: dbms_output.put_line ('Val_Sourcing_Rule_Type Error');
1381: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1382: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Sourcing_Rule_Type');
1383: FND_MSG_PUB.Add;
1384: RETURN FALSE;
1385: END IF;
1386:
1387: RETURN TRUE;