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 2685: fnd_message.set_name('INV', 'Cannot find the serial number

2681: IF (l_debug = 1) THEN
2682: print_debug('Serial Code is not 6 but does not have any corresponding
2683: records IN MSNT');
2684: END IF;
2685: fnd_message.set_name('INV', 'Cannot find the serial number
2686: for the transaction being processed');
2687: fnd_msg_pub.add;
2688: RAISE FND_API.G_EXC_ERROR;
2689: END IF;

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

2715: IF Length(rec_msnt.to_serial_number)<>l_fm_ser_length THEN
2716: IF (l_debug = 1) THEN
2717: print_debug('ERROR: Length of FSN diff from TSN');
2718: END IF;
2719: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2720: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2721: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2722: fnd_msg_pub.add;
2723: RAISE fnd_api.g_exc_error;

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

2716: IF (l_debug = 1) THEN
2717: print_debug('ERROR: Length of FSN diff from TSN');
2718: END IF;
2719: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2720: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2721: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2722: fnd_msg_pub.add;
2723: RAISE fnd_api.g_exc_error;
2724: END IF;

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

2717: print_debug('ERROR: Length of FSN diff from TSN');
2718: END IF;
2719: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
2720: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2721: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2722: fnd_msg_pub.add;
2723: RAISE fnd_api.g_exc_error;
2724: END IF;
2725:

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

2735: (l_to_temp_prefix <> l_temp_prefix) THEN
2736: IF (l_debug = 1) THEN
2737: print_debug('ERROR: From serial prefix different from to serial prefix');
2738: END IF;
2739: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2740: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2741: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2742: fnd_msg_pub.add;
2743: RAISE fnd_api.g_exc_error;

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

2736: IF (l_debug = 1) THEN
2737: print_debug('ERROR: From serial prefix different from to serial prefix');
2738: END IF;
2739: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2740: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2741: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2742: fnd_msg_pub.add;
2743: RAISE fnd_api.g_exc_error;
2744: END IF;

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

2737: print_debug('ERROR: From serial prefix different from to serial prefix');
2738: END IF;
2739: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
2740: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
2741: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
2742: fnd_msg_pub.add;
2743: RAISE fnd_api.g_exc_error;
2744: END IF;
2745:

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

3267: IF Length(rec_msnt.to_serial_number)<>l_fm_ser_length THEN
3268: IF (l_debug = 1) THEN
3269: print_debug('ERROR: Length of FSN diff from TSN');
3270: END IF;
3271: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3272: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3273: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3274: fnd_msg_pub.add;
3275: RAISE fnd_api.g_exc_error;

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

3268: IF (l_debug = 1) THEN
3269: print_debug('ERROR: Length of FSN diff from TSN');
3270: END IF;
3271: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3272: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3273: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3274: fnd_msg_pub.add;
3275: RAISE fnd_api.g_exc_error;
3276: END IF;

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

3269: print_debug('ERROR: Length of FSN diff from TSN');
3270: END IF;
3271: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_LENGTH');
3272: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3273: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3274: fnd_msg_pub.add;
3275: RAISE fnd_api.g_exc_error;
3276: END IF;
3277:

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

3287: (l_to_temp_prefix <> l_temp_prefix) THEN
3288: IF (l_debug = 1) THEN
3289: print_debug('ERROR: From serial prefix different from to serial prefix');
3290: END IF;
3291: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3292: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3293: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3294: fnd_msg_pub.add;
3295: RAISE fnd_api.g_exc_error;

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

3288: IF (l_debug = 1) THEN
3289: print_debug('ERROR: From serial prefix different from to serial prefix');
3290: END IF;
3291: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3292: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3293: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3294: fnd_msg_pub.add;
3295: RAISE fnd_api.g_exc_error;
3296: END IF;

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

3289: print_debug('ERROR: From serial prefix different from to serial prefix');
3290: END IF;
3291: fnd_message.set_name('INV', 'INV_FROM_TO_SER_DIFF_PFX');
3292: fnd_message.set_token('FM_SER_NUM',rec_msnt.fm_serial_number);
3293: fnd_message.set_token('TO_SER_NUM', rec_msnt.to_serial_number);
3294: fnd_msg_pub.add;
3295: RAISE fnd_api.g_exc_error;
3296: END IF;
3297: