519: IF l_fob_point IS NULL THEN
520: IF (l_debug = 1) THEN
521: print_debug ('l_fob_point is null:INV_FOB_NOT_DEFINED');
522: END IF;
523: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
524: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
525: FND_MSG_PUB.ADD;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
520: IF (l_debug = 1) THEN
521: print_debug ('l_fob_point is null:INV_FOB_NOT_DEFINED');
522: END IF;
523: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
524: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
525: FND_MSG_PUB.ADD;
526: RAISE FND_API.G_EXC_ERROR;
527: END IF;
528: EXCEPTION
529: WHEN NO_DATA_FOUND THEN
530: IF (l_debug = 1) THEN
531: print_debug ('no_data_found:INV_FOB_NOT_DEFINED');
532: END IF;
533: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
534: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: END;
530: IF (l_debug = 1) THEN
531: print_debug ('no_data_found:INV_FOB_NOT_DEFINED');
532: END IF;
533: FND_MESSAGE.SET_NAME('INV', 'INV_FOB_NOT_DEFINED');
534: fnd_message.set_token('ENTITY1',p_mmtt_rec.organization_id );
535: FND_MSG_PUB.ADD;
536: RAISE FND_API.G_EXC_ERROR;
537: END;
538: END IF;-- l_fob_point is null
1688: g_failure_txn_temp_id := g_current_txn_temp_id;
1689: print_debug('Failed Txn Temp Id : ' || g_failure_txn_temp_id );
1690: --Commenting these because this message is getting added
1691: --in INVCOMUB.pls
1692: --fnd_message.set_name('INV', 'INV_COMINGLE_ERROR');
1693: --fnd_msg_pub.add;
1694: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1695:
1696: WHEN FND_API.G_EXC_ERROR THEN
1816: x_return_status := FND_API.g_ret_sts_success;
1817:
1818: EXCEPTION
1819: WHEN too_many_rows THEN
1820: FND_MESSAGE.SET_NAME('WMS', 'WMS_COMMINGLE_EXISTS'); /*bug#2795266*/
1821: FND_MSG_PUB.ADD;
1822: x_return_status := FND_API.g_ret_sts_error;
1823: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1824: p_data => x_msg_data);