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_SOURCING_RULE_PVT dependencies on FND_MESSAGE

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

1028: NVL(l_Receiving_Org_rec.receipt_organization_id,-23453) <>
1029: NVL(l_sourcing_rule_rec.organization_id,-23453)) THEN
1030:
1031: -- dbms_output.put_line ('Invalid Receiving Organization');
1032: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receiving_Organization');
1034: FND_MESSAGE.SET_TOKEN('DETAILS', 'Mismatch between SR Organization and Receiving Organization');
1035: FND_MSG_PUB.Add;
1036: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receiving_Organization');

1029: NVL(l_sourcing_rule_rec.organization_id,-23453)) THEN
1030:
1031: -- dbms_output.put_line ('Invalid Receiving Organization');
1032: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receiving_Organization');
1034: FND_MESSAGE.SET_TOKEN('DETAILS', 'Mismatch between SR Organization and Receiving Organization');
1035: FND_MSG_PUB.Add;
1036: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1037:

Line 1034: FND_MESSAGE.SET_TOKEN('DETAILS', 'Mismatch between SR Organization and Receiving Organization');

1030:
1031: -- dbms_output.put_line ('Invalid Receiving Organization');
1032: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1033: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Receiving_Organization');
1034: FND_MESSAGE.SET_TOKEN('DETAILS', 'Mismatch between SR Organization and Receiving Organization');
1035: FND_MSG_PUB.Add;
1036: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1037:
1038: END IF;

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

1064: AND NVL(RO1.DISABLE_DATE,RO2.EFFECTIVE_DATE) >= RO2.EFFECTIVE_DATE));
1065:
1066: IF l_count > 0 THEN
1067: -- dbms_output.put_line ('Overlapping effective dates');
1068: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
1070: FND_MESSAGE.SET_TOKEN('DETAILS', 'Overlapping Effective ' ||
1071: 'Dates not allowed for Receiving Organizations');
1072: FND_MSG_PUB.Add;

Line 1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');

1065:
1066: IF l_count > 0 THEN
1067: -- dbms_output.put_line ('Overlapping effective dates');
1068: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
1070: FND_MESSAGE.SET_TOKEN('DETAILS', 'Overlapping Effective ' ||
1071: 'Dates not allowed for Receiving Organizations');
1072: FND_MSG_PUB.Add;
1073: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1070: FND_MESSAGE.SET_TOKEN('DETAILS', 'Overlapping Effective ' ||

1066: IF l_count > 0 THEN
1067: -- dbms_output.put_line ('Overlapping effective dates');
1068: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1069: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Effective_Date');
1070: FND_MESSAGE.SET_TOKEN('DETAILS', 'Overlapping Effective ' ||
1071: 'Dates not allowed for Receiving Organizations');
1072: FND_MSG_PUB.Add;
1073: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1074: END IF;

Line 1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');

1100:
1101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1102: THEN
1103:
1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');
1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);
1108: FND_MSG_PUB.Add;

Line 1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');

1101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1102: THEN
1103:
1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');
1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);
1108: FND_MSG_PUB.Add;
1109:

Line 1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);

1102: THEN
1103:
1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');
1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);
1108: FND_MSG_PUB.Add;
1109:
1110: END IF;

Line 1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);

1103:
1104: FND_MESSAGE.SET_NAME('MRP','MRP_API_INV_PARENT_INDEX');
1105: FND_MESSAGE.SET_TOKEN('ENTITY_NAME','Shipping_Org');
1106: FND_MESSAGE.SET_TOKEN('ENTITY_INDEX',I);
1107: FND_MESSAGE.SET_TOKEN('PARENT_INDEX',l_Shipping_Org_rec.Receiving_Org_index);
1108: FND_MSG_PUB.Add;
1109:
1110: END IF;
1111: END IF;

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

1187: IF /** Bug 2263575 l_sourcing_rule_rec.organization_id = **/
1188: l_Receiving_Org_rec.receipt_organization_id =
1189: l_Shipping_Org_rec.source_organization_id THEN
1190: -- dbms_output.put_line ('Source Org should be different');
1191: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1193: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1194: 'should be different from Receiving Organization');
1195: FND_MSG_PUB.Add;

Line 1192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');

1188: l_Receiving_Org_rec.receipt_organization_id =
1189: l_Shipping_Org_rec.source_organization_id THEN
1190: -- dbms_output.put_line ('Source Org should be different');
1191: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1193: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1194: 'should be different from Receiving Organization');
1195: FND_MSG_PUB.Add;
1196: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1193: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||

1189: l_Shipping_Org_rec.source_organization_id THEN
1190: -- dbms_output.put_line ('Source Org should be different');
1191: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1192: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1193: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1194: 'should be different from Receiving Organization');
1195: FND_MSG_PUB.Add;
1196: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1197:

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

1202: WHERE to_organization_id = l_Receiving_Org_rec.receipt_organization_id
1203: AND from_organization_id = l_Shipping_Org_rec.source_organization_id;
1204: EXCEPTION WHEN NO_DATA_FOUND THEN
1205: -- dbms_output.put_line ('Shipping Network not defined between source org and receiving org');
1206: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1208: FND_MESSAGE.SET_TOKEN('DETAILS', 'Shipping Network ' ||
1209: 'not defined between source org and receiving org');
1210: FND_MSG_PUB.Add;

Line 1207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');

1203: AND from_organization_id = l_Shipping_Org_rec.source_organization_id;
1204: EXCEPTION WHEN NO_DATA_FOUND THEN
1205: -- dbms_output.put_line ('Shipping Network not defined between source org and receiving org');
1206: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1208: FND_MESSAGE.SET_TOKEN('DETAILS', 'Shipping Network ' ||
1209: 'not defined between source org and receiving org');
1210: FND_MSG_PUB.Add;
1211: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1208: FND_MESSAGE.SET_TOKEN('DETAILS', 'Shipping Network ' ||

1204: EXCEPTION WHEN NO_DATA_FOUND THEN
1205: -- dbms_output.put_line ('Shipping Network not defined between source org and receiving org');
1206: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1207: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1208: FND_MESSAGE.SET_TOKEN('DETAILS', 'Shipping Network ' ||
1209: 'not defined between source org and receiving org');
1210: FND_MSG_PUB.Add;
1211: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1212: END;

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

1216: IF l_Shipping_Org_rec.source_type = 2 AND /* Bug 2263575 */
1217: l_sourcing_rule_rec.sourcing_rule_type = 1 AND /* Bug 5238229 */
1218: l_sourcing_rule_rec.organization_id IS NULL THEN
1219: -- dbms_output.put_line ('Cannot have source type of Make At for Global SR');
1220: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1222: FND_MESSAGE.SET_TOKEN('DETAILS', 'Cannot have source type of Make At for Global SR');
1223: FND_MSG_PUB.Add;
1224: l_Shipping_Org_tbl(I).return_status :=

Line 1221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');

1217: l_sourcing_rule_rec.sourcing_rule_type = 1 AND /* Bug 5238229 */
1218: l_sourcing_rule_rec.organization_id IS NULL THEN
1219: -- dbms_output.put_line ('Cannot have source type of Make At for Global SR');
1220: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1222: FND_MESSAGE.SET_TOKEN('DETAILS', 'Cannot have source type of Make At for Global SR');
1223: FND_MSG_PUB.Add;
1224: l_Shipping_Org_tbl(I).return_status :=
1225: FND_API.G_RET_STS_ERROR;

Line 1222: FND_MESSAGE.SET_TOKEN('DETAILS', 'Cannot have source type of Make At for Global SR');

1218: l_sourcing_rule_rec.organization_id IS NULL THEN
1219: -- dbms_output.put_line ('Cannot have source type of Make At for Global SR');
1220: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1221: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Type');
1222: FND_MESSAGE.SET_TOKEN('DETAILS', 'Cannot have source type of Make At for Global SR');
1223: FND_MSG_PUB.Add;
1224: l_Shipping_Org_tbl(I).return_status :=
1225: FND_API.G_RET_STS_ERROR;
1226: END IF;

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

1232: IF /** Bug 2263575 l_sourcing_rule_rec.organization_id <> **/
1233: l_Receiving_Org_rec.receipt_organization_id <>
1234: l_Shipping_Org_rec.source_organization_id THEN
1235: -- dbms_output.put_line ('Source Org should be same');
1236: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1238: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1239: 'should be same as Receiving Organization');
1240: FND_MSG_PUB.Add;

Line 1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');

1233: l_Receiving_Org_rec.receipt_organization_id <>
1234: l_Shipping_Org_rec.source_organization_id THEN
1235: -- dbms_output.put_line ('Source Org should be same');
1236: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1238: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1239: 'should be same as Receiving Organization');
1240: FND_MSG_PUB.Add;
1241: l_Shipping_Org_tbl(I).return_status :=

Line 1238: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||

1234: l_Shipping_Org_rec.source_organization_id THEN
1235: -- dbms_output.put_line ('Source Org should be same');
1236: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1237: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1238: FND_MESSAGE.SET_TOKEN('DETAILS', 'Source Organization ' ||
1239: 'should be same as Receiving Organization');
1240: FND_MSG_PUB.Add;
1241: l_Shipping_Org_tbl(I).return_status :=
1242: FND_API.G_RET_STS_ERROR;

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

1245:
1246: IF l_Shipping_Org_rec.source_type = 3 AND
1247: l_Shipping_Org_rec.source_organization_id IS NOT NULL THEN
1248: -- dbms_output.put_line ('Source Org should be NULL');
1249: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1251: FND_MESSAGE.SET_TOKEN('DETAILS',
1252: 'Source Organization should be NULL');
1253: FND_MSG_PUB.Add;

Line 1250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');

1246: IF l_Shipping_Org_rec.source_type = 3 AND
1247: l_Shipping_Org_rec.source_organization_id IS NOT NULL THEN
1248: -- dbms_output.put_line ('Source Org should be NULL');
1249: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1251: FND_MESSAGE.SET_TOKEN('DETAILS',
1252: 'Source Organization should be NULL');
1253: FND_MSG_PUB.Add;
1254: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1251: FND_MESSAGE.SET_TOKEN('DETAILS',

1247: l_Shipping_Org_rec.source_organization_id IS NOT NULL THEN
1248: -- dbms_output.put_line ('Source Org should be NULL');
1249: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1250: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Source_Organization_Id');
1251: FND_MESSAGE.SET_TOKEN('DETAILS',
1252: 'Source Organization should be NULL');
1253: FND_MSG_PUB.Add;
1254: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1255: END IF;

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

1269: AND NVL(SO2.rank, -999) = NVL(SO1.rank,-9999);
1270:
1271: IF l_count > 0 THEN
1272: -- dbms_output.put_line ('Cannot have Duplicate Ranks on SHO s');
1273: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1275: FND_MESSAGE.SET_TOKEN('DETAILS',
1276: 'Cannot have Duplicate Ranks on Shipping Organizations');
1277: FND_MSG_PUB.Add;

Line 1274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');

1270:
1271: IF l_count > 0 THEN
1272: -- dbms_output.put_line ('Cannot have Duplicate Ranks on SHO s');
1273: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1275: FND_MESSAGE.SET_TOKEN('DETAILS',
1276: 'Cannot have Duplicate Ranks on Shipping Organizations');
1277: FND_MSG_PUB.Add;
1278: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1275: FND_MESSAGE.SET_TOKEN('DETAILS',

1271: IF l_count > 0 THEN
1272: -- dbms_output.put_line ('Cannot have Duplicate Ranks on SHO s');
1273: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1274: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1275: FND_MESSAGE.SET_TOKEN('DETAILS',
1276: 'Cannot have Duplicate Ranks on Shipping Organizations');
1277: FND_MSG_PUB.Add;
1278: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1279: END IF;

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

1313: END;
1314:
1315: IF l_tot_alloc_percent > 100 THEN
1316: -- dbms_output.put_line ('total alloc percent cannot be > 100');
1317: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1319: FND_MESSAGE.SET_TOKEN('DETAILS',
1320: 'Total Allocation Percent cannot be greater than 100');
1321: FND_MSG_PUB.Add;

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

1314:
1315: IF l_tot_alloc_percent > 100 THEN
1316: -- dbms_output.put_line ('total alloc percent cannot be > 100');
1317: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1319: FND_MESSAGE.SET_TOKEN('DETAILS',
1320: 'Total Allocation Percent cannot be greater than 100');
1321: FND_MSG_PUB.Add;
1322: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1319: FND_MESSAGE.SET_TOKEN('DETAILS',

1315: IF l_tot_alloc_percent > 100 THEN
1316: -- dbms_output.put_line ('total alloc percent cannot be > 100');
1317: FND_MESSAGE.SET_NAME('MRP','MRP_ATTRIBUTE_VALUE_ERROR');
1318: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Rank');
1319: FND_MESSAGE.SET_TOKEN('DETAILS',
1320: 'Total Allocation Percent cannot be greater than 100');
1321: FND_MSG_PUB.Add;
1322: l_Shipping_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1323: END IF;

Line 1354: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_OBJECT');

1350: WHERE sourcing_rule_id = l_sourcing_rule_rec.sourcing_rule_id;
1351:
1352: IF l_count = 0 THEN
1353: -- dbms_output.put_line ('At least one receiving org req');
1354: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_OBJECT');
1355: FND_MESSAGE.SET_TOKEN('OBJECT','Sourcing_Rule');
1356: FND_MESSAGE.SET_TOKEN('DETAILS',
1357: 'At least one receiving organization is required');
1358: FND_MSG_PUB.Add;

Line 1355: FND_MESSAGE.SET_TOKEN('OBJECT','Sourcing_Rule');

1351:
1352: IF l_count = 0 THEN
1353: -- dbms_output.put_line ('At least one receiving org req');
1354: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_OBJECT');
1355: FND_MESSAGE.SET_TOKEN('OBJECT','Sourcing_Rule');
1356: FND_MESSAGE.SET_TOKEN('DETAILS',
1357: 'At least one receiving organization is required');
1358: FND_MSG_PUB.Add;
1359: l_sourcing_rule_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 1356: FND_MESSAGE.SET_TOKEN('DETAILS',

1352: IF l_count = 0 THEN
1353: -- dbms_output.put_line ('At least one receiving org req');
1354: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_OBJECT');
1355: FND_MESSAGE.SET_TOKEN('OBJECT','Sourcing_Rule');
1356: FND_MESSAGE.SET_TOKEN('DETAILS',
1357: 'At least one receiving organization is required');
1358: FND_MSG_PUB.Add;
1359: l_sourcing_rule_rec.return_status := FND_API.G_RET_STS_ERROR;
1360: END IF;

Line 1370: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_ENTITY');

1366: WHERE sr_receipt_id = l_Receiving_Org_tbl(I).Sr_Receipt_Id;
1367:
1368: IF l_count = 0 THEN
1369: -- dbms_output.put_line ('At least one source req');
1370: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_ENTITY');
1371: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');
1372: FND_MESSAGE.SET_TOKEN('DETAILS',
1373: 'At least one source organization is required');
1374: FND_MSG_PUB.Add;

Line 1371: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');

1367:
1368: IF l_count = 0 THEN
1369: -- dbms_output.put_line ('At least one source req');
1370: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_ENTITY');
1371: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');
1372: FND_MESSAGE.SET_TOKEN('DETAILS',
1373: 'At least one source organization is required');
1374: FND_MSG_PUB.Add;
1375: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;

Line 1372: FND_MESSAGE.SET_TOKEN('DETAILS',

1368: IF l_count = 0 THEN
1369: -- dbms_output.put_line ('At least one source req');
1370: FND_MESSAGE.SET_NAME('MRP','MRP_INCOMPLETE_ENTITY');
1371: FND_MESSAGE.SET_TOKEN('ENTITY','Receiving_Org');
1372: FND_MESSAGE.SET_TOKEN('DETAILS',
1373: 'At least one source organization is required');
1374: FND_MSG_PUB.Add;
1375: l_Receiving_Org_tbl(I).return_status := FND_API.G_RET_STS_ERROR;
1376: END IF;