DBA Data[Home] [Help]

APPS.WMS_ASN_LOT_ATT dependencies on FND_MSG_PUB

Line 532: fnd_msg_pub.add;

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;
536: EXCEPTION

Line 539: fnd_msg_pub.add;

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

Line 560: fnd_msg_pub.add;

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;
564: end if;

Line 578: fnd_msg_pub.add;

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
582: end if;

Line 602: fnd_msg_pub.add;

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;
606: end if;

Line 1079: FND_MSG_PUB.Count_And_Get

1075: IF (l_debug = 1) THEN
1076: print_debug('Process - expected error happened - l_progress : '||l_progress, 1);
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data
1082: );
1083:

Line 1090: FND_MSG_PUB.Count_And_Get

1086: IF (l_debug = 1) THEN
1087: print_debug('Process - unexpected error happened - l_progress : '||l_progress, 1);
1088: END IF;
1089: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1090: FND_MSG_PUB.Count_And_Get
1091: (p_count => x_msg_count,
1092: p_data => x_msg_data
1093: );
1094:

Line 1473: fnd_msg_pub.add;

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;
1477: EXCEPTION

Line 1480: fnd_msg_pub.add;

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

Line 2084: FND_MSG_PUB.Count_And_Get

2080:
2081: x_return_status := FND_API.G_RET_STS_SUCCESS;
2082:
2083: -- Standard call to get message count and if count is 1, get message info.
2084: FND_MSG_PUB.Count_And_Get
2085: ( p_encoded => FND_API.G_FALSE,
2086: p_count => x_msg_count ,
2087: p_data => x_msg_data
2088: );

Line 2102: FND_MSG_PUB.Count_And_Get

2098: print_debug('SQL Error : '||SQLERRM(SQLCODE)||' SQL Error code : '||SQLCODE, 1);
2099: END IF;
2100: END IF;
2101:
2102: FND_MSG_PUB.Count_And_Get
2103: ( p_encoded => FND_API.G_FALSE,
2104: p_count => x_msg_count ,
2105: p_data => x_msg_data
2106: );

Line 2258: FND_MSG_PUB.ADD;

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
2262: -- and it is not a pre-defined serial

Line 2302: FND_MSG_PUB.ADD;

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

Line 2319: FND_MSG_PUB.Count_And_Get

2315: END IF;
2316:
2317: -- Standard call to get message count and if count is 1,
2318: -- get message info.
2319: FND_MSG_PUB.Count_And_Get
2320: ( p_count => x_msg_count,
2321: p_data => x_msg_data
2322: );
2323:

Line 2328: FND_MSG_PUB.Count_And_Get

2324: EXCEPTION
2325: WHEN FND_API.G_EXC_ERROR THEN
2326: ROLLBACK TO SP_insert_range_serial;
2327: x_return_status := FND_API.G_RET_STS_ERROR;
2328: FND_MSG_PUB.Count_And_Get
2329: (p_count => x_msg_count,
2330: p_data => x_msg_data
2331: );
2332:

Line 2336: FND_MSG_PUB.Count_And_Get

2332:
2333: WHEN FND_API.g_exc_unexpected_error THEN
2334: ROLLBACK TO SP_insert_range_serial;
2335: x_return_status := FND_API.g_ret_sts_unexp_error;
2336: FND_MSG_PUB.Count_And_Get
2337: (p_count => x_msg_count,
2338: p_data => x_msg_data
2339: );
2340:

Line 2344: FND_MSG_PUB.Count_And_Get

2340:
2341: WHEN OTHERS THEN
2342: ROLLBACK TO SP_insert_range_serial;
2343: x_return_status := FND_API.g_ret_sts_unexp_error;
2344: FND_MSG_PUB.Count_And_Get
2345: (p_count => x_msg_count,
2346: p_data => x_msg_data
2347: );
2348: