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 DBMS_OUTPUT

Line 56: dbms_output.put_line ('Category ID required');

52: -- Check conditionally required attributes here.
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;

Line 65: dbms_output.put_line ('Inventory_Item_Id required');

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

Line 78: dbms_output.put_line ('org/cust required');

74: p_Assignment_rec.Assignment_type = 6) AND
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;

Line 87: dbms_output.put_line ('cust site required');

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

Line 604: dbms_output.put_line ('Val_Assignment_Set_Id Error');

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

Line 638: dbms_output.put_line ('Val_Assignment_Type error');

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

Line 650: dbms_output.put_line ('Val_Assignment_Type error');

646: (p_Assignment_Type <> 4) AND
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;

Line 973: dbms_output.put_line ('Val_Category_Id Error');

969: AND mc.structure_id = mcs.structure_id
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;

Line 1007: dbms_output.put_line ('Val_Category_Set_Id Error');

1003: FROM MTL_CATEGORY_SETS
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;

Line 1078: dbms_output.put_line ('Val_Customer_Id Error');

1074: WHERE cust_account_id = p_Customer_Id
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;

Line 1117: dbms_output.put_line ('Val_Inventory_Item_Id Error');

1113: p_organization_id)
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;

Line 1316: dbms_output.put_line('Val_Ship_To_Site_Id Error');

1312: AND RSU.site_use_id = p_Ship_To_Site_Id
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;

Line 1342: dbms_output.put_line ('Error Val_Sourcing_Rule_Id');

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

Line 1355: dbms_output.put_line ('Error Val_Sourcing_Rule_Id');

1351: WHERE sourcing_rule_id = p_Sourcing_Rule_Id
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;

Line 1380: dbms_output.put_line ('Val_Sourcing_Rule_Type Error');

1376: p_Sourcing_Rule_Type = FND_API.G_MISS_NUM
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;