eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_CYC_LOVS dependencies on FND_MSG_PUB

Line 301: FND_MSG_PUB.initialize;

297:
298: END IF;
299:
300: -- Initialize the message stack
301: FND_MSG_PUB.initialize;
302: -- Set the global variables
303: g_count_quantity := p_count_quantity;
304: g_count_uom := p_count_uom;
305: g_user_id := p_user_id;

Line 380: FND_MSG_PUB.ADD;

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:
384: -- Check that in the case of a range of serial numbers, that the

Line 390: FND_MSG_PUB.ADD;

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:
394: -- Get the serial number length.

Line 538: --FND_MSG_PUB.ADD;

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;
542:

Line 752: --FND_MSG_PUB.ADD;

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;
756:

Line 811: FND_MSG_PUB.ADD;

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***' );
815: END IF;

Line 881: FND_MSG_PUB.initialize;

877: print_debug ( 'p_cost_group_id: ===========> ' || p_cost_group_id );
878: END IF;
879:
880: -- Initialize the message stack
881: FND_MSG_PUB.initialize;
882:
883: -- To fetch the cycle count entry ids which are in status 2,4,5.
884: -- for these entries if a record in wms_dispatched_tasks exists,
885: -- it has to be deleted

Line 2505: FND_MSG_PUB.ADD;

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:
2509: IF ( l_count_type_code = 4 ) THEN

Line 2622: FND_MSG_PUB.ADD;

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;
2624: END IF;
2625:
2626: IF ( l_entry_status_code = 5 ) THEN

Line 3503: FND_MSG_PUB.ADD;

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' );
3507: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );

Line 3509: FND_MSG_PUB.ADD;

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' );
3513: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

Line 3515: FND_MSG_PUB.ADD;

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:
3519: -- Get a new txn temp ID for receiving the serial back into inventory

Line 3648: FND_MSG_PUB.ADD;

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:
3652: -- Get a new txn temp ID for the next record into MMTT

Line 3756: FND_MSG_PUB.ADD;

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' );
3760: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );

Line 3762: FND_MSG_PUB.ADD;

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' );
3766: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

Line 3768: FND_MSG_PUB.ADD;

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;
3772: g_cc_entry.adjustment_date := SYSDATE;

Line 3865: FND_MSG_PUB.Count_AND_Get ( p_count => l_msg_count,

3861: x_msg_data => l_msg_data
3862: );
3863:
3864: IF ( l_return_status <> 'S' ) THEN
3865: FND_MSG_PUB.Count_AND_Get ( p_count => l_msg_count,
3866: p_data => l_msg_data
3867: );
3868: RAISE FND_API.G_EXC_ERROR;
3869: END IF;

Line 3917: FND_MSG_PUB.ADD;

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;
3921:

Line 4059: --FND_MSG_PUB.ADD;

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:
4063: FND_MESSAGE.SET_NAME ( 'INV', 'INV_ADJUSTMENTS_PROCESSED' );

Line 4065: FND_MSG_PUB.ADD;

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,
4069: -- we don't need to explicitly call the label printing API anymore

Line 4091: FND_MSG_PUB.ADD;

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);
4095: END IF;

Line 4099: FND_MSG_PUB.ADD;

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

Line 4128: --FND_MSG_PUB.ADD;

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:
4132: FND_MESSAGE.SET_NAME ( 'INV', 'INV_CONC_SUBMITTED' );

Line 4134: FND_MSG_PUB.ADD;

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,
4138: -- we don't need to explicitly call the label printing API anymore

Line 4160: FND_MSG_PUB.ADD;

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);
4164: END IF;

Line 4168: FND_MSG_PUB.ADD;

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' );
4172: FND_MSG_PUB.ADD;

Line 4172: FND_MSG_PUB.ADD;

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:
4176: IF ( l_debug = 1 ) THEN

Line 5233: -- FND_MSG_PUB.ADD;

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!' );
5237: END IF;

Line 5265: FND_MSG_PUB.ADD;

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;
5269: END IF;

Line 5337: FND_MSG_PUB.ADD;

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;
5341: ELSIF ( l_serial_count_option = 2 ) THEN

Line 5348: FND_MSG_PUB.ADD;

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
5352: ROLLBACK TO save_serial_detail;

Line 6275: FND_MSG_PUB.ADD;

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 );
6279: END IF;

Line 6289: FND_MSG_PUB.ADD;

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);
6293: -- go_block('CC_ENTRIES');

Line 6307: FND_MSG_PUB.ADD;

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
6311: print_debug ( 'Multiple serial error' );

Line 6767: FND_MSG_PUB.ADD;

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
6771: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

Line 6774: FND_MSG_PUB.ADD;

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' );
6778: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

Line 6780: FND_MSG_PUB.ADD;

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:
6784: -- Get a new txn temp ID for receiving the serial back into inventory

Line 6873: FND_MSG_PUB.ADD;

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
6877: FND_MESSAGE.SET_NAME ( 'INV', 'INV_TRX_LOT_NA_DUE_MS' );

Line 6880: FND_MSG_PUB.ADD;

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' );
6884: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_serial_number );

Line 6886: FND_MSG_PUB.ADD;

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:
6890: -- Set the commit status flag so that the TM will be called in the

Line 7050: FND_MSG_PUB.ADD;

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;
7054: END IF;

Line 7578: FND_MSG_PUB.ADD;

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:
7582: IF ( L_to_length = 0 ) THEN

Line 7632: FND_MSG_PUB.ADD;

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:
7636: -- Check the lengths of the two serial numbers to make sure they

Line 7641: FND_MSG_PUB.ADD;

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:
7645: -- Check whether the serial numbers are matched

Line 7656: FND_MSG_PUB.ADD;

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;
7660:

Line 7677: FND_MSG_PUB.ADD;

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:
7681: -- Check to make sure To serial number is greater than

Line 8543: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8539: );
8540: END IF;
8541:
8542: -- Get message count and data
8543: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8544: p_count => x_msg_count,
8545: p_data => x_msg_data
8546: );
8547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8560: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8556: );
8557: END IF;
8558:
8559: -- Get message count and data
8560: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8561: p_count => x_msg_count,
8562: p_data => x_msg_data
8563: );
8564: WHEN OTHERS THEN

Line 8583: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN

8579: SQLCODE
8580: );
8581: END IF;
8582:
8583: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
8584: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'update_serial_status' );
8585: END IF;
8586:
8587: -- Get message count and data

Line 8584: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'update_serial_status' );

8580: );
8581: END IF;
8582:
8583: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
8584: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'update_serial_status' );
8585: END IF;
8586:
8587: -- Get message count and data
8588: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

Line 8588: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8584: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'update_serial_status' );
8585: END IF;
8586:
8587: -- Get message count and data
8588: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8589: p_count => x_msg_count,
8590: p_data => x_msg_data
8591: );
8592: END update_serial_status;

Line 8669: FND_MSG_PUB.ADD;

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:
8673: l_progress := '30';

Line 8730: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8726: );
8727: END IF;
8728:
8729: -- Get message count and data
8730: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8731: p_count => x_msg_count,
8732: p_data => x_msg_data
8733: );
8734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 8747: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8743: END IF;
8744:
8745: x_return_status := fnd_api.g_ret_sts_unexp_error;
8746: -- Get message count and data
8747: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8748: p_count => x_msg_count,
8749: p_data => x_msg_data
8750: );
8751: WHEN OTHERS THEN

Line 8771: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN

8767: SQLCODE
8768: );
8769: END IF;
8770:
8771: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
8772: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'insert_range_serial' );
8773: END IF;
8774:
8775: -- Get message count and data

Line 8772: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'insert_range_serial' );

8768: );
8769: END IF;
8770:
8771: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
8772: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'insert_range_serial' );
8773: END IF;
8774:
8775: -- Get message count and data
8776: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

Line 8776: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,

8772: fnd_msg_pub.add_exc_msg ( g_pkg_name, 'insert_range_serial' );
8773: END IF;
8774:
8775: -- Get message count and data
8776: fnd_msg_pub.count_and_get ( p_encoded => fnd_api.g_false,
8777: p_count => x_msg_count,
8778: p_data => x_msg_data
8779: );
8780: END insert_range_serial;