DBA Data[Home] [Help]

APPS.INV_COST_GROUP_UPDATE dependencies on FND_MESSAGE

Line 123: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');

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

Line 124: fnd_message.set_token('ENTITY1', 'mtl_material_transactions_temp');

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 : ' );

Line 177: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');

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

Line 178: fnd_message.set_token('ENTITY1', 'MTL_SERIAL_NUMBERS_TEMP');

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 : ');

Line 227: fnd_message.set_name('INV', 'INV_UPDATE_ERROR');

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

Line 228: fnd_message.set_token('ENTITY1', 'MTL_LOT_NUMBERS_TEMP');

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 : ');

Line 509: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');

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

Line 515: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');

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;

Line 753: fnd_message.set_name('INV','INV_PENDING_CG_NULL');

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;

Line 754: fnd_message.set_token('ORG',p_organization_id);

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

Line 755: fnd_message.set_token('ITEM',p_inventory_item_id);

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 */

Line 779: fnd_message.set_name('INV', 'INV_ZERO_ONHAND');

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;

Line 927: fnd_message.set_name('INV','INV_ONHAND_CG_NULL');

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;

Line 928: fnd_message.set_token('ORG',p_organization_id);

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

Line 929: fnd_message.set_token('ITEM',p_inventory_item_id);

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

Line 1999: --fnd_message.set_name('INV', 'INV_COMINGLE_ERROR');

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:

Line 2697: fnd_message.set_name('INV', 'Cannot find the serial number

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;

Line 2731: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');

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;

Line 2732: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);

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;

Line 2733: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);

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:

Line 2751: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');

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;

Line 2752: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);

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;

Line 2753: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);

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:

Line 3283: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');

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;

Line 3284: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);

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;

Line 3285: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);

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:

Line 3303: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');

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;

Line 3304: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);

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;

Line 3305: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);

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: