DBA Data[Home] [Help]

APPS.INV_CYC_LOVS dependencies on FND_MESSAGE

Line 379: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_CONT_INVALID_SER' );

375: x_to_number => l_to_number,
376: x_errorcode => l_errorcode
377: )
378: ) THEN
379: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_CONT_INVALID_SER' );
380: FND_MSG_PUB.ADD;
381: RAISE FND_API.G_EXC_ERROR;
382: END IF;
383:

Line 389: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_CONT_INVALID_X_QTY' );

385: -- inputted p_count_quantity equals the amount of items in the serial range.
386: IF ( ( p_count_quantity <> l_quantity )
387: AND ( p_count_quantity <> 0 )
388: ) THEN
389: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_CONT_INVALID_X_QTY' );
390: FND_MSG_PUB.ADD;
391: RAISE FND_API.G_EXC_ERROR;
392: END IF;
393:

Line 537: --FND_MESSAGE.SET_NAME('INV', 'INV_NO_UNSCHED_COUNTS');

533: -- Unscheduled entries are not allowed
534: IF ( l_debug = 1 ) THEN
535: print_debug ( 'Unscheduled entries are not allowed' );
536: END IF;
537: --FND_MESSAGE.SET_NAME('INV', 'INV_NO_UNSCHED_COUNTS');
538: --FND_MSG_PUB.ADD;
539: --RAISE FND_API.G_EXC_ERROR;
540: END IF;
541: END IF;

Line 751: --FND_MESSAGE.SET_NAME('INV', 'INV_NO_UNSCHED_COUNTS');

747: -- Unscheduled entries are not allowed
748: IF ( l_debug = 1 ) THEN
749: print_debug ( 'Unscheduled entries are not allowed' );
750: END IF;
751: --FND_MESSAGE.SET_NAME('INV', 'INV_NO_UNSCHED_COUNTS');
752: --FND_MSG_PUB.ADD;
753: --RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: END IF;

Line 810: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_TD_CYC_TASK_ERROR' );

806: print_debug ( '***End of process_entry***' );
807: END IF;
808: EXCEPTION
809: WHEN e_Task_Dispatched THEN
810: FND_MESSAGE.SET_NAME ( 'WMS', 'WMS_TD_CYC_TASK_ERROR' );
811: FND_MSG_PUB.ADD;
812:
813: IF ( l_debug = 1 ) THEN
814: print_debug ( '***End of process_entry***' );

Line 2504: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUPLICATE_COUNT_UPDATE' );

2500: FROM mtl_cycle_count_entries
2501: WHERE cycle_count_entry_id = l_cc_entry_id;
2502:
2503: IF ( l_old_num_counts > l_number_of_counts ) THEN
2504: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUPLICATE_COUNT_UPDATE' );
2505: FND_MSG_PUB.ADD;
2506: RAISE FND_API.G_EXC_ERROR;
2507: END IF;
2508:

Line 2619: FND_MESSAGE.SET_NAME ( 'INV',

2615: FROM MTL_CC_SERIAL_NUMBERS
2616: WHERE CYCLE_COUNT_ENTRY_ID = l_cc_entry_id;
2617:
2618: IF ( l_total_serial_num_cnt <> l_count_quantity ) THEN
2619: FND_MESSAGE.SET_NAME ( 'INV',
2620: 'INV_CC_SERIAL_DETAIL_MISMATCH'
2621: );
2622: FND_MSG_PUB.ADD;
2623: RAISE FND_API.G_EXC_ERROR;

Line 3502: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );

3498:
3499: --If success flag is 2 or 3 then set the message for invalid
3500: --material status for the lot/serial and the item combination
3501: IF ( NVL ( l_success_flag, -1 ) < 0 ) THEN
3502: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3506: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

Line 3506: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

3502: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3506: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3507: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;

Line 3507: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );

3503: FND_MSG_PUB.ADD;
3504: RAISE FND_API.G_EXC_ERROR;
3505: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3506: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3507: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN

Line 3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

3504: RAISE FND_API.G_EXC_ERROR;
3505: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3506: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3507: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3512: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

Line 3512: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3512: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3513: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3514: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3515: FND_MSG_PUB.ADD;
3516: RAISE FND_API.G_EXC_ERROR;

Line 3513: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

3509: FND_MSG_PUB.ADD;
3510: RAISE FND_API.G_EXC_ERROR;
3511: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3512: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3513: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3514: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3515: FND_MSG_PUB.ADD;
3516: RAISE FND_API.G_EXC_ERROR;
3517: END IF;

Line 3514: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

3510: RAISE FND_API.G_EXC_ERROR;
3511: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3512: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3513: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3514: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3515: FND_MSG_PUB.ADD;
3516: RAISE FND_API.G_EXC_ERROR;
3517: END IF;
3518:

Line 3647: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );

3643: print_debug ( 'success_flag: ' || l_success_flag );
3644: END IF;
3645:
3646: IF ( NVL ( l_success_flag, -1 ) < 0 ) THEN
3647: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
3648: FND_MSG_PUB.ADD;
3649: RAISE FND_API.G_EXC_ERROR;
3650: END IF;
3651:

Line 3755: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );

3751: --material status for the lot/serial and the item combination
3752: IF ( ( NVL ( l_txn_header_id, -1 ) < 0 )
3753: OR ( NVL ( l_success_flag, -1 ) < 0 )
3754: ) THEN
3755: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
3756: FND_MSG_PUB.ADD;
3757: RAISE FND_API.G_EXC_ERROR;
3758: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3759: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

Line 3759: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

3755: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
3756: FND_MSG_PUB.ADD;
3757: RAISE FND_API.G_EXC_ERROR;
3758: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3759: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3760: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;

Line 3760: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );

3756: FND_MSG_PUB.ADD;
3757: RAISE FND_API.G_EXC_ERROR;
3758: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3759: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3760: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN

Line 3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

3757: RAISE FND_API.G_EXC_ERROR;
3758: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
3759: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
3760: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3765: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

Line 3765: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3765: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3766: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3767: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3768: FND_MSG_PUB.ADD;
3769: RAISE FND_API.G_EXC_ERROR;

Line 3766: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

3762: FND_MSG_PUB.ADD;
3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3765: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3766: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3767: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3768: FND_MSG_PUB.ADD;
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;

Line 3767: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

3763: RAISE FND_API.G_EXC_ERROR;
3764: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
3765: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
3766: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
3767: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
3768: FND_MSG_PUB.ADD;
3769: RAISE FND_API.G_EXC_ERROR;
3770: END IF;
3771: END IF;

Line 3916: FND_MESSAGE.SET_NAME ( 'INV', 'INV_OPEN_REQUEST_EXISTS' );

3912:
3913: AND NVL(parent_lpn_id,-1 ) = NVL(l_lpn_id, -1);
3914:
3915: IF ( l_count > 0 ) THEN
3916: FND_MESSAGE.SET_NAME ( 'INV', 'INV_OPEN_REQUEST_EXISTS' );
3917: FND_MSG_PUB.ADD;
3918: RAISE FND_API.G_EXC_ERROR;
3919: END IF;
3920: END duplicate_entries;

Line 4058: --FND_MESSAGE.SET_NAME('INV', 'INV_FAILED');

4054: END IF;
4055:
4056: IF ( l_txn_return_status <> 0 ) THEN
4057: -- This 'Transaction Failed' message is set on the java side
4058: --FND_MESSAGE.SET_NAME('INV', 'INV_FAILED');
4059: --FND_MSG_PUB.ADD;
4060: RAISE FND_API.G_EXC_ERROR;
4061: END IF;
4062:

Line 4063: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJUSTMENTS_PROCESSED' );

4059: --FND_MSG_PUB.ADD;
4060: RAISE FND_API.G_EXC_ERROR;
4061: END IF;
4062:
4063: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJUSTMENTS_PROCESSED' );
4064: FND_MESSAGE.SET_TOKEN ( 'ENTITY', 'INV_CYCLE_COUNT', TRUE );
4065: FND_MSG_PUB.ADD;
4066: /* Call the label printing API. */
4067: -- Bug# 2328371

Line 4064: FND_MESSAGE.SET_TOKEN ( 'ENTITY', 'INV_CYCLE_COUNT', TRUE );

4060: RAISE FND_API.G_EXC_ERROR;
4061: END IF;
4062:
4063: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJUSTMENTS_PROCESSED' );
4064: FND_MESSAGE.SET_TOKEN ( 'ENTITY', 'INV_CYCLE_COUNT', TRUE );
4065: FND_MSG_PUB.ADD;
4066: /* Call the label printing API. */
4067: -- Bug# 2328371
4068: -- Since we are passing in the business flow code to the TM,

Line 4090: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');

4086: WHEN OTHERS THEN
4087: IF (l_debug = 1) THEN
4088: print_debug('Error while calling label printing API');
4089: END IF;
4090: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
4091: FND_MSG_PUB.ADD;
4092: END;
4093: IF (l_debug = 1) THEN
4094: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);

Line 4098: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');

4094: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);
4095: END IF;
4096:
4097: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4098: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
4099: FND_MSG_PUB.ADD;
4100: END IF;*/
4101: ELSIF ( l_txn_proc_mode = 2 ) THEN
4102: /* txn process concurrent program */

Line 4127: --FND_MESSAGE.SET_NAME('INV', 'INV_FAILED');

4123: END IF;
4124:
4125: IF ( l_txn_return_status <> 0 ) THEN
4126: -- This 'Transaction Failed' message is set on the java side
4127: --FND_MESSAGE.SET_NAME('INV', 'INV_FAILED');
4128: --FND_MSG_PUB.ADD;
4129: RAISE FND_API.G_EXC_ERROR;
4130: END IF;
4131:

Line 4132: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CONC_SUBMITTED' );

4128: --FND_MSG_PUB.ADD;
4129: RAISE FND_API.G_EXC_ERROR;
4130: END IF;
4131:
4132: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CONC_SUBMITTED' );
4133: FND_MESSAGE.SET_TOKEN ( 'REQUEST_ID', TO_CHAR ( l_req_id ), FALSE );
4134: FND_MSG_PUB.ADD;
4135: /* Call the label printing API. */
4136: -- Bug# 2328371

Line 4133: FND_MESSAGE.SET_TOKEN ( 'REQUEST_ID', TO_CHAR ( l_req_id ), FALSE );

4129: RAISE FND_API.G_EXC_ERROR;
4130: END IF;
4131:
4132: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CONC_SUBMITTED' );
4133: FND_MESSAGE.SET_TOKEN ( 'REQUEST_ID', TO_CHAR ( l_req_id ), FALSE );
4134: FND_MSG_PUB.ADD;
4135: /* Call the label printing API. */
4136: -- Bug# 2328371
4137: -- Since we are passing in the business flow code to the TM,

Line 4159: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');

4155: WHEN OTHERS THEN
4156: IF (l_debug = 1) THEN
4157: print_debug('Error while calling label printing API');
4158: END IF;
4159: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
4160: FND_MSG_PUB.ADD;
4161: END;
4162: IF (l_debug = 1) THEN
4163: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);

Line 4167: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');

4163: print_debug('After calling label printing API: ' || l_return_status || ', ' || l_label_status || ', ' || l_msg_data);
4164: END IF;
4165:
4166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
4167: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
4168: FND_MSG_PUB.ADD;
4169: END IF;*/
4170: ELSE
4171: FND_MESSAGE.SET_NAME ( 'INV', 'INV_BACKGROUND_PENDING' );

Line 4171: FND_MESSAGE.SET_NAME ( 'INV', 'INV_BACKGROUND_PENDING' );

4167: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LABEL_FAILE');
4168: FND_MSG_PUB.ADD;
4169: END IF;*/
4170: ELSE
4171: FND_MESSAGE.SET_NAME ( 'INV', 'INV_BACKGROUND_PENDING' );
4172: FND_MSG_PUB.ADD;
4173: END IF;
4174: END IF;
4175:

Line 5232: -- FND_MESSAGE.SET_NAME('INV', 'INV_CC_NO_SN_INFO');

5228: AND ( event = 'WHEN-VALIDATE-RECORD' )
5229: AND ( l_system_quantity <> 0
5230: OR g_count_quantity <> 0 )
5231: ) THEN
5232: -- FND_MESSAGE.SET_NAME('INV', 'INV_CC_NO_SN_INFO');
5233: -- FND_MSG_PUB.ADD;
5234: -- RAISE FND_API.G_EXC_ERROR;
5235: IF ( l_debug = 1 ) THEN
5236: print_debug ( 'No SN info!' );

Line 5264: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_OUT_TOL_NO_SN' );

5260: END;
5261:
5262: IF ( l_number_of_counts = 0
5263: OR l_number_of_counts < l_counts ) THEN
5264: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_OUT_TOL_NO_SN' );
5265: FND_MSG_PUB.ADD;
5266: RAISE FND_API.G_EXC_ERROR;
5267: ELSE
5268: entered := 1;

Line 5335: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUP' );

5331: WHERE serial_number = l_serial_number
5332: AND cycle_count_entry_id = l_cycle_count_entry_id;
5333:
5334: IF ( l_count > 0 ) THEN
5335: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUP' );
5336: FND_MESSAGE.SET_TOKEN ( 'VALUE1', l_serial_number );
5337: FND_MSG_PUB.ADD;
5338: ROLLBACK TO save_serial_detail;
5339: RAISE FND_API.G_EXC_ERROR;

Line 5336: FND_MESSAGE.SET_TOKEN ( 'VALUE1', l_serial_number );

5332: AND cycle_count_entry_id = l_cycle_count_entry_id;
5333:
5334: IF ( l_count > 0 ) THEN
5335: FND_MESSAGE.SET_NAME ( 'INV', 'INV_DUP' );
5336: FND_MESSAGE.SET_TOKEN ( 'VALUE1', l_serial_number );
5337: FND_MSG_PUB.ADD;
5338: ROLLBACK TO save_serial_detail;
5339: RAISE FND_API.G_EXC_ERROR;
5340: END IF;

Line 5347: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_NULL_SN' );

5343: l_serial_number := g_cc_entry.serial_number;
5344: END IF;
5345:
5346: IF ( l_serial_number IS NULL ) THEN
5347: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_NULL_SN' );
5348: FND_MSG_PUB.ADD;
5349: l_success := FALSE;
5350:
5351: IF ( l_serial_count_option = 3 ) THEN

Line 6273: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_MULTI_TRANSACT2' );

6269: );
6270: END IF;
6271: END IF;
6272:
6273: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_MULTI_TRANSACT2' );
6274: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6275: FND_MSG_PUB.ADD;
6276:
6277: IF ( l_debug = 1 ) THEN

Line 6274: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );

6270: END IF;
6271: END IF;
6272:
6273: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_MULTI_TRANSACT2' );
6274: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6275: FND_MSG_PUB.ADD;
6276:
6277: IF ( l_debug = 1 ) THEN
6278: print_debug ( 'l_current_status: ' || l_current_status );

Line 6287: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );

6283: ELSE
6284: l_ret_value := FALSE;
6285: END IF;
6286: ELSE
6287: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );
6288: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6289: FND_MSG_PUB.ADD;
6290:
6291: IF ( l_serial_count_option = 3 ) THEN

Line 6288: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );

6284: l_ret_value := FALSE;
6285: END IF;
6286: ELSE
6287: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );
6288: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6289: FND_MSG_PUB.ADD;
6290:
6291: IF ( l_serial_count_option = 3 ) THEN
6292: -- clear_block(NO_VALIDATE);

Line 6305: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );

6301:
6302: RAISE FND_API.G_EXC_ERROR;
6303: END IF;
6304: ELSIF ( l_error_code <> 0 ) THEN
6305: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );
6306: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6307: FND_MSG_PUB.ADD;
6308:
6309: IF ( l_serial_count_option = 3 ) THEN

Line 6306: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );

6302: RAISE FND_API.G_EXC_ERROR;
6303: END IF;
6304: ELSIF ( l_error_code <> 0 ) THEN
6305: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CC_SERIAL_DISCREPANCY' );
6306: FND_MESSAGE.SET_TOKEN ( 'SERIAL', l_serial_number );
6307: FND_MSG_PUB.ADD;
6308:
6309: IF ( l_serial_count_option = 3 ) THEN
6310: IF ( l_debug = 1 ) THEN

Line 6766: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );

6762:
6763: --If success flag is 2 or 3 then set the message for invalid
6764: --material status for the lot/serial and the item combination
6765: IF ( NVL ( l_success_flag, -1 ) < 0 ) THEN
6766: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
6767: FND_MSG_PUB.ADD;
6768: ROLLBACK TO save_serial_detail;
6769: RAISE FND_API.G_EXC_ERROR;
6770: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN

Line 6771: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

6767: FND_MSG_PUB.ADD;
6768: ROLLBACK TO save_serial_detail;
6769: RAISE FND_API.G_EXC_ERROR;
6770: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6771: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6772: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;

Line 6772: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );

6768: ROLLBACK TO save_serial_detail;
6769: RAISE FND_API.G_EXC_ERROR;
6770: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6771: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6772: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN

Line 6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

6769: RAISE FND_API.G_EXC_ERROR;
6770: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6771: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6772: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6777: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

Line 6777: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6777: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6778: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6779: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_ERROR;

Line 6778: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

6774: FND_MSG_PUB.ADD;
6775: RAISE FND_API.G_EXC_ERROR;
6776: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6777: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6778: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6779: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_ERROR;
6782: END IF;

Line 6779: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

6775: RAISE FND_API.G_EXC_ERROR;
6776: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6777: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6778: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6779: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6780: FND_MSG_PUB.ADD;
6781: RAISE FND_API.G_EXC_ERROR;
6782: END IF;
6783:

Line 6872: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );

6868: --If success flag is 2 or 3 then set the message for invalid
6869: --material status for the lot/serial and the item combination
6870: --IF NVL(l_txn_header_id, -1) < 0 OR
6871: IF NVL ( l_success_flag, -1 ) < 0 THEN
6872: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJ_TXN_FAILED' );
6873: FND_MSG_PUB.ADD;
6874: ROLLBACK TO save_serial_detail;
6875: RAISE FND_API.G_EXC_ERROR;
6876: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN

Line 6877: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

6873: FND_MSG_PUB.ADD;
6874: ROLLBACK TO save_serial_detail;
6875: RAISE FND_API.G_EXC_ERROR;
6876: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6877: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6878: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_ERROR;

Line 6878: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );

6874: ROLLBACK TO save_serial_detail;
6875: RAISE FND_API.G_EXC_ERROR;
6876: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6877: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6878: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN

Line 6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

6875: RAISE FND_API.G_EXC_ERROR;
6876: ELSIF NVL ( l_success_flag, -1 ) = 2 THEN
6877: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );
6878: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6883: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

Line 6883: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );

6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6883: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6884: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6885: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6886: FND_MSG_PUB.ADD;
6887: RAISE FND_API.G_EXC_ERROR;

Line 6884: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

6880: FND_MSG_PUB.ADD;
6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6883: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6884: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6885: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6886: FND_MSG_PUB.ADD;
6887: RAISE FND_API.G_EXC_ERROR;
6888: END IF;

Line 6885: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

6881: RAISE FND_API.G_EXC_ERROR;
6882: ELSIF NVL ( l_success_flag, -1 ) = 3 THEN
6883: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_SER_NA_DUE_MS' );
6884: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );
6885: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );
6886: FND_MSG_PUB.ADD;
6887: RAISE FND_API.G_EXC_ERROR;
6888: END IF;
6889:

Line 7048: FND_MESSAGE.SET_NAME ( 'INV', 'INV_SERIAL_UNAVAILABLE' );

7044:
7045: -- A return success value of -1 means that the serial has already
7046: -- been marked. We don't need to error out in this case.
7047: IF ( success < -1 ) THEN
7048: FND_MESSAGE.SET_NAME ( 'INV', 'INV_SERIAL_UNAVAILABLE' );
7049: FND_MESSAGE.SET_TOKEN ( 'FIRST-SERIAL', g1 );
7050: FND_MSG_PUB.ADD;
7051:
7052: IF ( l_serial_count_option = 3 ) THEN

Line 7049: FND_MESSAGE.SET_TOKEN ( 'FIRST-SERIAL', g1 );

7045: -- A return success value of -1 means that the serial has already
7046: -- been marked. We don't need to error out in this case.
7047: IF ( success < -1 ) THEN
7048: FND_MESSAGE.SET_NAME ( 'INV', 'INV_SERIAL_UNAVAILABLE' );
7049: FND_MESSAGE.SET_TOKEN ( 'FIRST-SERIAL', g1 );
7050: FND_MSG_PUB.ADD;
7051:
7052: IF ( l_serial_count_option = 3 ) THEN
7053: ROLLBACK TO save_serial_detail;

Line 7577: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_NO_SERIAL' );

7573: print_debug ( 'L_to_length=' || L_to_length );
7574: END IF;
7575:
7576: IF ( L_from_length = 0 ) THEN
7577: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_NO_SERIAL' );
7578: FND_MSG_PUB.ADD;
7579: x_errorcode := 124;
7580: END IF;
7581:

Line 7631: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_PFX' );

7627:
7628: IF ( L_f_alp_part <> L_t_alp_part )
7629: OR ( l_f_alp_part IS NULL AND l_t_alp_part IS NOT NULL )
7630: OR ( l_f_alp_part IS NOT NULL AND l_t_alp_part IS NULL ) THEN
7631: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_PFX' );
7632: FND_MSG_PUB.ADD;
7633: x_errorcode := 119;
7634: END IF;
7635:

Line 7640: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_LGTH' );

7636: -- Check the lengths of the two serial numbers to make sure they
7637: -- match.
7638: IF ( L_from_length <> L_to_length ) THEN
7639: -- Message Name : INV_QTYBTWN_LGTH
7640: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_LGTH' );
7641: FND_MSG_PUB.ADD;
7642: x_errorcode := 120;
7643: END IF;
7644:

Line 7655: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_LAST' );

7651: IF ASCII ( SUBSTR ( L_f_ser_num, LENGTH ( L_f_ser_num ), 1 ) ) <
7652: 48
7653: AND ASCII ( SUBSTR ( L_f_ser_num, LENGTH ( L_f_ser_num ), 1 ) ) >
7654: 57 THEN
7655: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_LAST' );
7656: FND_MSG_PUB.ADD;
7657: x_errorcode := 121;
7658: END IF;
7659: END IF;

Line 7676: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_NUM' );

7672: + 1;
7673:
7674: IF ( X_Quantity <= 0 ) THEN
7675: -- Message Name : INV_QTYBTWN_NUM
7676: FND_MESSAGE.SET_NAME ( 'INV', 'INV_QTYBTWN_NUM' );
7677: FND_MSG_PUB.ADD;
7678: x_errorcode := 122;
7679: END IF;
7680:

Line 8668: FND_MESSAGE.SET_NAME ( 'INV', 'INV_LOT_COMMIT_FAILURE' );

8664: x_msg_data => x_msg_data
8665: );
8666:
8667: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8668: FND_MESSAGE.SET_NAME ( 'INV', 'INV_LOT_COMMIT_FAILURE' );
8669: FND_MSG_PUB.ADD;
8670: RAISE FND_API.G_EXC_ERROR;
8671: END IF;
8672: