DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on FND_MESSAGE

Line 531: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');

527: WHERE INVENTORY_ITEM_ID = l_inventory_item_id
528: AND ORGANIZATION_ID = l_organization_id;
529:
530: if(l_lot_control_code = 1) then
531: fnd_message.set_name('INV','INV_NO_LOT_CONTROL');
532: fnd_msg_pub.add;
533: x_return_status := FND_API.G_RET_STS_ERROR;
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;

Line 538: fnd_message.set_name('INV','INV_INVALID_ITEM');

534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535: end if;
536: EXCEPTION
537: WHEN NO_DATA_FOUND THEN
538: fnd_message.set_name('INV','INV_INVALID_ITEM');
539: fnd_msg_pub.add;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
542: END;

Line 559: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');

555: WHERE inventory_item_id <> l_inventory_item_id
556: AND lot_number = l_lot_number;
557:
558: if(l_lotcount > 0) then
559: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
560: fnd_msg_pub.add;
561: x_return_status := FND_API.G_RET_STS_ERROR;
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: end if;

Line 577: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');

573: if(l_lotcount = 0) then
574: l_userid := fnd_global.user_id;
575: l_loginid := fnd_global.login_id;
576: else
577: fnd_message.set_name('INV','INV_INT_LOTUNIQEXP');
578: fnd_msg_pub.add;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: -- Stop PRocessing HERE

Line 601: fnd_message.set_name('INV','INV_LOT_EXPREQD');

597: SELECT SYSDATE + l_shelf_life_days
598: INTO l_expiration_date
599: FROM DUAL;
600: elsif(l_shelf_life_code = 4) then
601: fnd_message.set_name('INV','INV_LOT_EXPREQD');
602: fnd_msg_pub.add;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
605: end if;

Line 1472: fnd_message.set_name('INV','INV_NO_SERIAL_CONTROL');

1468: WHERE INVENTORY_ITEM_ID = p_inventory_item_id
1469: AND ORGANIZATION_ID = p_organization_id;
1470:
1471: if(l_serial_control_code = 1) then
1472: fnd_message.set_name('INV','INV_NO_SERIAL_CONTROL');
1473: fnd_msg_pub.add;
1474: x_return_status := FND_API.G_RET_STS_ERROR;
1475: return;
1476: end if;

Line 1479: fnd_message.set_name('INV','INV_INVALID_ITEM');

1475: return;
1476: end if;
1477: EXCEPTION
1478: WHEN NO_DATA_FOUND THEN
1479: fnd_message.set_name('INV','INV_INVALID_ITEM');
1480: fnd_msg_pub.add;
1481: x_return_status := FND_API.G_RET_STS_ERROR;
1482: return;
1483: END;

Line 2257: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL_USED');

2253: (p_org_id => p_organization_id,
2254: p_item_id => p_inventory_item_id,
2255: p_serial => l_cur_serial_number,
2256: x_proc_msg => l_msg_data) = 1 THEN
2257: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL_USED');
2258: FND_MSG_PUB.ADD;
2259: RAISE FND_API.G_EXC_ERROR;
2260: ELSE
2261: -- uniqueness check passed

Line 2301: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL');

2297: x_msg_count => l_msg_count,
2298: x_msg_data => l_msg_data);
2299:
2300: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2301: FND_MESSAGE.SET_NAME('INV', 'INV_SERIAL');
2302: FND_MSG_PUB.ADD;
2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: END IF;
2305: END IF;