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_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','Assignment_Id');
32: FND_MSG_PUB.Add;
33:
34: END IF;

Line 31: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_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','Assignment_Id');
32: FND_MSG_PUB.Add;
33:
34: END IF;
35:

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

53: --
54: IF p_Assignment_rec.Assignment_type = 2 AND
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;

Line 58: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Id');

54: IF p_Assignment_rec.Assignment_type = 2 AND
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:

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

62:
63: IF p_Assignment_rec.Assignment_type = 3 AND
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;

Line 67: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Inventory_Item_Id');

63: IF p_Assignment_rec.Assignment_type = 3 AND
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:

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

75: (p_Assignment_rec.Organization_Id IS NULL AND
76: p_Assignment_rec.Customer_Id IS NULL AND
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;

Line 80: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Organization_Id or Customer_Id');

76: p_Assignment_rec.Customer_Id IS NULL AND
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:

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

84:
85: IF p_Assignment_rec.Customer_Id IS NOT NULL AND
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;

Line 89: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_To_Site_Id');

85: IF p_Assignment_rec.Customer_Id IS NOT NULL AND
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:

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

601: IF p_Assignment_Set_Id IS NULL OR
602: p_Assignment_Set_Id = FND_API.G_MISS_NUM
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

Line 606: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Set_Id');

602: p_Assignment_Set_Id = FND_API.G_MISS_NUM
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(*)

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

612: FROM MRP_ASSIGNMENT_SETS
613: WHERE assignment_set_id = p_Assignment_Set_Id;
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;

Line 617: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Set_Id');

613: WHERE assignment_set_id = p_Assignment_Set_Id;
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;

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

635: IF p_Assignment_Type IS NULL OR
636: p_Assignment_Type = FND_API.G_MISS_NUM
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

Line 640: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Type');

636: p_Assignment_Type = FND_API.G_MISS_NUM
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

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

647: (p_Assignment_Type <> 5) AND
648: (p_Assignment_Type <> 6) THEN
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;

Line 652: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Assignment_Type');

648: (p_Assignment_Type <> 6) THEN
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:

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

970: AND mc.category_id = p_Category_Id;
971:
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;

Line 975: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Id');

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

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

1004: WHERE category_set_id = p_Category_Set_Id;
1005:
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;

Line 1009: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Category_Set_Id');

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

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

1075: AND status = 'A';
1076:
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;

Line 1080: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Customer_Id');

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

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

1114: AND inventory_item_id = p_Inventory_Item_Id;
1115:
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;

Line 1119: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Inventory_Item_Id');

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

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

1313: AND RSU.site_use_code in ('SHIP_TO','BILL_TO');
1314:
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;

Line 1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Ship_To_Site_Id');

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

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

1339: IF p_Sourcing_Rule_Id IS NULL OR
1340: p_Sourcing_Rule_Id = FND_API.G_MISS_NUM
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

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

1340: p_Sourcing_Rule_Id = FND_API.G_MISS_NUM
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(*)

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

1352: AND sourcing_rule_type = p_Sourcing_Rule_Type;
1353:
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;

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

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

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

1377: THEN
1378: RETURN TRUE;
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;

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

1378: RETURN TRUE;
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: