119: transaction_quantity = Nvl(p_transaction_quantity, transaction_quantity)
120: WHERE transaction_temp_id = p_transaction_temp_id;
121: IF (SQL%NOTFOUND )THEN
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
124: fnd_message.set_token('ENTITY1', 'mtl_material_transactions_temp');
125: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
126: fnd_msg_pub.add;
127: IF (l_debug = 1) THEN
120: WHERE transaction_temp_id = p_transaction_temp_id;
121: IF (SQL%NOTFOUND )THEN
122: x_return_status := FND_API.G_RET_STS_ERROR ;
123: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
124: fnd_message.set_token('ENTITY1', 'mtl_material_transactions_temp');
125: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
126: fnd_msg_pub.add;
127: IF (l_debug = 1) THEN
128: print_debug('proc_update_mmtt .. nodatafound OTHERS : ' );
173: WHERE ROWID = p_rowid;
174:
175: IF (SQL%NOTFOUND) THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');
179: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
180: fnd_msg_pub.add;
181: IF (l_debug = 1) THEN
174:
175: IF (SQL%NOTFOUND) THEN
176: x_return_status := FND_API.G_RET_STS_ERROR ;
177: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');
179: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
180: fnd_msg_pub.add;
181: IF (l_debug = 1) THEN
182: print_debug('proc_update_msnt .. nodatafound OTHERS : ');
223: WHERE ROWID = p_rowid;
224:
225: IF (SQL%NOTFOUND) THEN
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
228: fnd_message.set_token('ENTITY1', 'MTL_LOT_NUMBERS_TEMP');
229: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
230: fnd_msg_pub.add;
231: IF (l_debug = 1) THEN
224:
225: IF (SQL%NOTFOUND) THEN
226: x_return_status := FND_API.G_RET_STS_ERROR ;
227: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');
228: fnd_message.set_token('ENTITY1', 'MTL_LOT_NUMBERS_TEMP');
229: -- MESSAGE_TEXT = "Error Updating ENTITY1 "
230: fnd_msg_pub.add;
231: IF (l_debug = 1) THEN
232: print_debug('proc_update_mtlt .. nodatafound OTHERS : ');
505: END IF;
506: END IF;
507: ELSIF l_negative_balances_allowed = 2 THEN -- Negative balances are not allowed
508: x_return_status := FND_API.G_RET_STS_ERROR ;
509: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
510: fnd_msg_pub.add;
511: END IF;
512: EXCEPTION
513: WHEN no_data_found THEN
511: END IF;
512: EXCEPTION
513: WHEN no_data_found THEN
514: x_return_status := FND_API.G_RET_STS_ERROR ;
515: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
516: fnd_msg_pub.add;
517: IF (l_debug = 1) THEN
518: print_debug('proc_get_default_costgroup .. no_data_found' );
519: END IF;
749: 'ser '||p_serial_number);
750:
751: print_debug('proc_get_pendingcostgroup...returning failure with CG:'||x_cost_group_id);
752: END IF;
753: fnd_message.set_name('INV','INV_PENDING_CG_NULL');
754: fnd_message.set_token('ORG',p_organization_id);
755: fnd_message.set_token('ITEM',p_inventory_item_id);
756: fnd_msg_pub.add;
757: x_return_status := g_corrupt_cg_error;
750:
751: print_debug('proc_get_pendingcostgroup...returning failure with CG:'||x_cost_group_id);
752: END IF;
753: fnd_message.set_name('INV','INV_PENDING_CG_NULL');
754: fnd_message.set_token('ORG',p_organization_id);
755: fnd_message.set_token('ITEM',p_inventory_item_id);
756: fnd_msg_pub.add;
757: x_return_status := g_corrupt_cg_error;
758: --Bug 2844271 fix
751: print_debug('proc_get_pendingcostgroup...returning failure with CG:'||x_cost_group_id);
752: END IF;
753: fnd_message.set_name('INV','INV_PENDING_CG_NULL');
754: fnd_message.set_token('ORG',p_organization_id);
755: fnd_message.set_token('ITEM',p_inventory_item_id);
756: fnd_msg_pub.add;
757: x_return_status := g_corrupt_cg_error;
758: --Bug 2844271 fix
759: ELSE */
775:
776: EXCEPTION
777: WHEN no_data_found THEN
778: x_return_status := FND_API.G_RET_STS_ERROR ;
779: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');
780: fnd_msg_pub.add;
781: IF (l_debug = 1) THEN
782: print_debug('proc_get_pending_costgroup .. no_data_found' );
783: END IF;
923: 'ser '||p_serial_number);
924:
925: print_debug('proc_get_costgroup...returning failure with CG:'||x_cost_group_id);
926: END IF;
927: fnd_message.set_name('INV','INV_ONHAND_CG_NULL');
928: fnd_message.set_token('ORG',p_organization_id);
929: fnd_message.set_token('ITEM',p_inventory_item_id);
930: fnd_msg_pub.add;
931: x_return_status := g_corrupt_cg_error;
924:
925: print_debug('proc_get_costgroup...returning failure with CG:'||x_cost_group_id);
926: END IF;
927: fnd_message.set_name('INV','INV_ONHAND_CG_NULL');
928: fnd_message.set_token('ORG',p_organization_id);
929: fnd_message.set_token('ITEM',p_inventory_item_id);
930: fnd_msg_pub.add;
931: x_return_status := g_corrupt_cg_error;
932: --Bug 2844271 fix
925: print_debug('proc_get_costgroup...returning failure with CG:'||x_cost_group_id);
926: END IF;
927: fnd_message.set_name('INV','INV_ONHAND_CG_NULL');
928: fnd_message.set_token('ORG',p_organization_id);
929: fnd_message.set_token('ITEM',p_inventory_item_id);
930: fnd_msg_pub.add;
931: x_return_status := g_corrupt_cg_error;
932: --Bug 2844271 fix
933: ELSE
1995: print_debug('proc_insert_mmtt .. comigling occurs : ' );
1996: END IF;
1997: --Commenting these because this message is getting added
1998: --in INVCOMUB.pls
1999: --fnd_message.set_name('INV', 'INV_COMINGLE_ERROR');
2000: --fnd_msg_pub.add;
2001: x_return_status := inv_cost_group_pvt.g_comingle_error;
2002: END IF;
2003:
2693: IF (l_debug = 1) THEN
2694: print_debug('Serial Code is not 6 but does not have any corresponding
2695: records IN MSNT');
2696: END IF;
2697: fnd_message.set_name('INV', 'Cannot find the serial number
2698: for the transaction being processed');
2699: fnd_msg_pub.add;
2700: RAISE FND_API.G_EXC_ERROR;
2701: END IF;
2727: IF Length(rec_msnt.to_serial_number)<>l_fm_ser_length THEN
2728: IF (l_debug = 1) THEN
2729: print_debug('ERROR: Length of FSN diff from TSN');
2730: END IF;
2731: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2732: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2733: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2734: fnd_msg_pub.add;
2735: RAISE fnd_api.g_exc_error;
2728: IF (l_debug = 1) THEN
2729: print_debug('ERROR: Length of FSN diff from TSN');
2730: END IF;
2731: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2732: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2733: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2734: fnd_msg_pub.add;
2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2729: print_debug('ERROR: Length of FSN diff from TSN');
2730: END IF;
2731: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2732: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2733: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2734: fnd_msg_pub.add;
2735: RAISE fnd_api.g_exc_error;
2736: END IF;
2737:
2747: (l_to_temp_prefix <> l_temp_prefix) THEN
2748: IF (l_debug = 1) THEN
2749: print_debug('ERROR: From serial prefix different from to serial prefix');
2750: END IF;
2751: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2752: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2753: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2754: fnd_msg_pub.add;
2755: RAISE fnd_api.g_exc_error;
2748: IF (l_debug = 1) THEN
2749: print_debug('ERROR: From serial prefix different from to serial prefix');
2750: END IF;
2751: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2752: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2753: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2754: fnd_msg_pub.add;
2755: RAISE fnd_api.g_exc_error;
2756: END IF;
2749: print_debug('ERROR: From serial prefix different from to serial prefix');
2750: END IF;
2751: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2752: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2753: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2754: fnd_msg_pub.add;
2755: RAISE fnd_api.g_exc_error;
2756: END IF;
2757:
3279: IF Length(rec_msnt.to_serial_number)<>l_fm_ser_length THEN
3280: IF (l_debug = 1) THEN
3281: print_debug('ERROR: Length of FSN diff from TSN');
3282: END IF;
3283: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3284: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3285: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3286: fnd_msg_pub.add;
3287: RAISE fnd_api.g_exc_error;
3280: IF (l_debug = 1) THEN
3281: print_debug('ERROR: Length of FSN diff from TSN');
3282: END IF;
3283: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3284: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3285: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3286: fnd_msg_pub.add;
3287: RAISE fnd_api.g_exc_error;
3288: END IF;
3281: print_debug('ERROR: Length of FSN diff from TSN');
3282: END IF;
3283: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3284: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3285: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3286: fnd_msg_pub.add;
3287: RAISE fnd_api.g_exc_error;
3288: END IF;
3289:
3299: (l_to_temp_prefix <> l_temp_prefix) THEN
3300: IF (l_debug = 1) THEN
3301: print_debug('ERROR: From serial prefix different from to serial prefix');
3302: END IF;
3303: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3304: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3305: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3306: fnd_msg_pub.add;
3307: RAISE fnd_api.g_exc_error;
3300: IF (l_debug = 1) THEN
3301: print_debug('ERROR: From serial prefix different from to serial prefix');
3302: END IF;
3303: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3304: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3305: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3306: fnd_msg_pub.add;
3307: RAISE fnd_api.g_exc_error;
3308: END IF;
3301: print_debug('ERROR: From serial prefix different from to serial prefix');
3302: END IF;
3303: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3304: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3305: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3306: fnd_msg_pub.add;
3307: RAISE fnd_api.g_exc_error;
3308: END IF;
3309: