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_API

Line 264: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;

260: /* Bug 4891916-Added the following local variables for the call to label printing */
261: l_print_label NUMBER := NVL(FND_PROFILE.VALUE('WMS_LABEL_FOR_CYCLE_COUNT'),2);
262: l_business_flow_code NUMBER := 8;
263: l_label_status VARCHAR2 ( 300 ) := NULL;
264: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
265: l_msg_count NUMBER;
266: l_msg_data VARCHAR2(240);
267: /* End of fix for Bug 4891916 */
268:

Line 381: RAISE FND_API.G_EXC_ERROR;

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
385: -- inputted p_count_quantity equals the amount of items in the serial range.

Line 391: RAISE FND_API.G_EXC_ERROR;

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.
395: -- Note that the from and to serial numbers must be of the same length.

Line 539: --RAISE FND_API.G_EXC_ERROR;

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:
543: CLOSE cc_discrepant_serial_cursor;

Line 753: --RAISE FND_API.G_EXC_ERROR;

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:
757: CLOSE cc_discrepant_cursor;

Line 794: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

790: print_debug ( 'Values of l_msg_count:'|| l_msg_count );
791: print_debug ( 'Values of l_label_status'|| l_label_status );
792: END IF;
793:
794: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
795: IF (l_debug = 1) THEN
796: print_debug('**Label Printing returned error:' || l_return_status);
797: END IF;
798: END IF;

Line 964: RAISE FND_API.G_EXC_ERROR;

960: WHEN OTHERS THEN
961: IF(l_debug = 1) THEN
962: print_debug('Unable to get the Outermost LPN ID for: ' || g_cc_entry.parent_lpn_id);
963: END IF;
964: RAISE FND_API.G_EXC_ERROR;
965: END;
966: --Bug2935754 ends
967: ELSE
968: g_cc_entry.outermost_lpn_id := NULL;

Line 1200: RAISE FND_API.G_EXC_ERROR;

1196: WHEN OTHERS THEN
1197: IF(l_debug = 1) THEN
1198: print_debug('Unable to get the Outermost LPN ID for: ' || g_cc_entry.parent_lpn_id);
1199: END IF;
1200: RAISE FND_API.G_EXC_ERROR;
1201: END;
1202: --Bug2935754 ends
1203: ELSE
1204: g_cc_entry.outermost_lpn_id := NULL;

Line 2506: RAISE FND_API.G_EXC_ERROR;

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
2510: -- Zero Count

Line 2623: RAISE FND_API.G_EXC_ERROR;

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
2627: -- Completed count entries

Line 2806: RAISE FND_API.G_EXC_ERROR;

2802: END IF;
2803: END IF;
2804: EXCEPTION
2805: WHEN NO_DATA_FOUND THEN
2806: RAISE FND_API.G_EXC_ERROR;
2807: END pre_update;
2808:
2809: PROCEDURE final_preupdate_logic
2810: IS

Line 3504: RAISE FND_API.G_EXC_ERROR;

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 );
3508: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 3510: RAISE FND_API.G_EXC_ERROR;

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 );
3514: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 3516: RAISE FND_API.G_EXC_ERROR;

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
3520: SELECT mtl_material_transactions_s.NEXTVAL

Line 3649: RAISE FND_API.G_EXC_ERROR;

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
3653: SELECT mtl_material_transactions_s.NEXTVAL

Line 3757: RAISE FND_API.G_EXC_ERROR;

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 );
3761: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 3763: RAISE FND_API.G_EXC_ERROR;

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 );
3767: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 3769: RAISE FND_API.G_EXC_ERROR;

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

Line 3868: RAISE FND_API.G_EXC_ERROR;

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;
3870: END delete_reservation;
3871:
3872: PROCEDURE duplicate_entries

Line 3918: RAISE FND_API.G_EXC_ERROR;

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:
3922: PROCEDURE post_commit

Line 4060: RAISE FND_API.G_EXC_ERROR;

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' );
4064: FND_MESSAGE.SET_TOKEN ( 'ENTITY', 'INV_CYCLE_COUNT', TRUE );

Line 4097: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

Line 4129: RAISE FND_API.G_EXC_ERROR;

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' );
4133: FND_MESSAGE.SET_TOKEN ( 'REQUEST_ID', TO_CHAR ( l_req_id ), FALSE );

Line 4166: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

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

Line 5234: -- RAISE FND_API.G_EXC_ERROR;

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;
5238: ELSE

Line 5266: RAISE FND_API.G_EXC_ERROR;

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

Line 5339: RAISE FND_API.G_EXC_ERROR;

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
5342: -- Single serial per count
5343: l_serial_number := g_cc_entry.serial_number;

Line 5355: RAISE FND_API.G_EXC_ERROR;

5351: IF ( l_serial_count_option = 3 ) THEN
5352: ROLLBACK TO save_serial_detail;
5353: END IF;
5354:
5355: RAISE FND_API.G_EXC_ERROR;
5356: END IF;
5357:
5358: IF ( l_debug = 1 ) THEN
5359: print_debug ( 'l_automatic_recount_flag = '||l_automatic_recount_flag||', g_cc_entry.number_of_counts = '||g_cc_entry.number_of_counts);

Line 6302: RAISE FND_API.G_EXC_ERROR;

6298:
6299: ROLLBACK TO save_serial_detail;
6300: END IF;
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 );

Line 6317: RAISE FND_API.G_EXC_ERROR;

6313:
6314: ROLLBACK TO save_serial_detail;
6315: END IF;
6316:
6317: RAISE FND_API.G_EXC_ERROR;
6318: END IF;
6319: END IF;
6320:
6321: RETURN ( l_ret_value );

Line 6769: RAISE FND_API.G_EXC_ERROR;

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' );
6772: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_msn_lot_number );
6773: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 6775: RAISE FND_API.G_EXC_ERROR;

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 );
6779: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 6781: RAISE FND_API.G_EXC_ERROR;

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
6785: SELECT mtl_material_transactions_s.NEXTVAL

Line 6875: RAISE FND_API.G_EXC_ERROR;

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' );
6878: FND_MESSAGE.SET_TOKEN ( 'TOKEN1', l_lot_num );
6879: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 6881: RAISE FND_API.G_EXC_ERROR;

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 );
6885: FND_MESSAGE.SET_TOKEN ( 'TOKEN2', l_item_name );

Line 6887: RAISE FND_API.G_EXC_ERROR;

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
6891: -- post commit procedure

Line 7056: RAISE FND_API.G_EXC_ERROR;

7052: IF ( l_serial_count_option = 3 ) THEN
7053: ROLLBACK TO save_serial_detail;
7054: END IF;
7055:
7056: RAISE FND_API.G_EXC_ERROR;
7057: END IF;
7058: END IF;
7059: END mark;
7060:

Line 8333: x_return_status := FND_API.G_RET_STS_SUCCESS;

8329: IS
8330: l_debug NUMBER := NVL ( FND_PROFILE.VALUE ( 'INV_DEBUG_TRACE' ), 0 );
8331: BEGIN
8332: -- Initialize the return status
8333: x_return_status := FND_API.G_RET_STS_SUCCESS;
8334:
8335: IF ( l_debug = 1 ) THEN
8336: print_debug ( '***Calling insert_dynamic_lot***' );
8337: END IF;

Line 8360: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN

8356: x_msg_count => x_msg_count,
8357: x_msg_data => x_msg_data
8358: );
8359:
8360: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
8361: IF ( l_debug = 1 ) THEN
8362: print_debug ( 'insertLot was not called successfully' );
8363: END IF;
8364:

Line 8365: RAISE FND_API.G_EXC_ERROR;

8361: IF ( l_debug = 1 ) THEN
8362: print_debug ( 'insertLot was not called successfully' );
8363: END IF;
8364:
8365: RAISE FND_API.G_EXC_ERROR;
8366: END IF;
8367:
8368: IF ( l_debug = 1 ) THEN
8369: print_debug ( 'insertLot was called successfully' );

Line 8372: IF ( ( x_return_status = FND_API.g_ret_sts_success )

8368: IF ( l_debug = 1 ) THEN
8369: print_debug ( 'insertLot was called successfully' );
8370: END IF;
8371:
8372: IF ( ( x_return_status = FND_API.g_ret_sts_success )
8373: AND ( p_update_status = 'TRUE' )
8374: ) THEN
8375: IF ( l_debug = 1 ) THEN
8376: print_debug ( 'Update the status of the new lot' );

Line 8396: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN

8392: p_to_serial_number => NULL,
8393: p_object_type => 'O'
8394: );
8395:
8396: IF ( x_return_status <> fnd_api.g_ret_sts_success ) THEN
8397: IF ( l_debug = 1 ) THEN
8398: print_debug ( 'update_status was not called successfully' );
8399: END IF;
8400:

Line 8401: RAISE FND_API.G_EXC_ERROR;

8397: IF ( l_debug = 1 ) THEN
8398: print_debug ( 'update_status was not called successfully' );
8399: END IF;
8400:
8401: RAISE FND_API.G_EXC_ERROR;
8402: END IF;
8403: END IF;
8404: END insert_dynamic_lot;
8405:

Line 8443: x_return_status := FND_API.G_RET_STS_SUCCESS;

8439: );
8440: END IF;
8441:
8442: l_progress := '10';
8443: x_return_status := FND_API.G_RET_STS_SUCCESS;
8444: SAVEPOINT count_update_serial_sp;
8445: l_progress := '20';
8446: -- get the number part of the 'to' serial
8447: inv_validate.number_from_sequence ( p_to_serial_number,

Line 8507: IF x_return_status <> fnd_api.g_ret_sts_success THEN

8503: END IF;
8504:
8505: l_progress := '80';
8506:
8507: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8508: RAISE FND_API.G_EXC_ERROR;
8509: END IF;
8510: END LOOP;
8511:

Line 8508: RAISE FND_API.G_EXC_ERROR;

8504:
8505: l_progress := '80';
8506:
8507: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8508: RAISE FND_API.G_EXC_ERROR;
8509: END IF;
8510: END LOOP;
8511:
8512: l_progress := '90';

Line 8530: WHEN FND_API.G_EXC_ERROR THEN

8526: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
8527: );
8528: END IF;
8529: EXCEPTION
8530: WHEN FND_API.G_EXC_ERROR THEN
8531: ROLLBACK TO count_update_serial_sp;
8532: x_return_status := FND_API.G_RET_STS_ERROR;
8533:
8534: IF ( l_debug = 1 ) THEN

Line 8532: x_return_status := FND_API.G_RET_STS_ERROR;

8528: END IF;
8529: EXCEPTION
8530: WHEN FND_API.G_EXC_ERROR THEN
8531: ROLLBACK TO count_update_serial_sp;
8532: x_return_status := FND_API.G_RET_STS_ERROR;
8533:
8534: IF ( l_debug = 1 ) THEN
8535: print_debug ( 'Exitting update_serial_status - execution error:'
8536: || l_progress

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 8547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
8548: ROLLBACK TO count_update_serial_sp;
8549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8550:
8551: IF ( l_debug = 1 ) THEN

Line 8549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8545: p_data => x_msg_data
8546: );
8547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8548: ROLLBACK TO count_update_serial_sp;
8549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8550:
8551: IF ( l_debug = 1 ) THEN
8552: print_debug ( 'Exitting update_serial_status - unexpected error:'
8553: || l_progress

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 8566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

8562: p_data => x_msg_data
8563: );
8564: WHEN OTHERS THEN
8565: ROLLBACK TO count_update_serial_sp;
8566: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8567:
8568: IF ( l_debug = 1 ) THEN
8569: print_debug ( 'Exitting update_serial_status - other exceptions:'
8570: || l_progress

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 8625: x_return_status := FND_API.G_RET_STS_SUCCESS;

8621: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
8622: );
8623: END IF;
8624:
8625: x_return_status := FND_API.G_RET_STS_SUCCESS;
8626: l_progress := '10';
8627: SAVEPOINT count_insert_range_serial_sp;
8628: l_progress := '20';
8629: inv_serial_number_pub.insert_range_serial ( p_api_version => p_api_version,

Line 8667: IF x_return_status <> fnd_api.g_ret_sts_success THEN

8663: x_msg_count => x_msg_count,
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;

Line 8670: RAISE FND_API.G_EXC_ERROR;

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

Line 8695: IF x_return_status <> fnd_api.g_ret_sts_success THEN

8691: p_object_type => 'S'
8692: );
8693: END IF;
8694:
8695: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8696: RAISE FND_API.G_EXC_ERROR;
8697: END IF;
8698:
8699: l_progress := '50';

Line 8696: RAISE FND_API.G_EXC_ERROR;

8692: );
8693: END IF;
8694:
8695: IF x_return_status <> fnd_api.g_ret_sts_success THEN
8696: RAISE FND_API.G_EXC_ERROR;
8697: END IF;
8698:
8699: l_progress := '50';
8700: serial_check.inv_mark_serial ( from_serial_number => p_from_serial_number,

Line 8717: WHEN FND_API.G_EXC_ERROR THEN

8713: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
8714: );
8715: END IF;
8716: EXCEPTION
8717: WHEN FND_API.G_EXC_ERROR THEN
8718: ROLLBACK TO count_insert_range_serial_sp;
8719: x_return_status := fnd_api.g_ret_sts_error;
8720:
8721: IF ( l_debug = 1 ) THEN

Line 8719: x_return_status := fnd_api.g_ret_sts_error;

8715: END IF;
8716: EXCEPTION
8717: WHEN FND_API.G_EXC_ERROR THEN
8718: ROLLBACK TO count_insert_range_serial_sp;
8719: x_return_status := fnd_api.g_ret_sts_error;
8720:
8721: IF ( l_debug = 1 ) THEN
8722: print_debug ( 'Exitting insert_range_serial - execution error:'
8723: || l_progress

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 8734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
8735: ROLLBACK TO count_insert_range_serial_sp;
8736:
8737: IF ( l_debug = 1 ) THEN
8738: print_debug ( 'Exitting insert_range_serial - unexpected error:'

Line 8745: x_return_status := fnd_api.g_ret_sts_unexp_error;

8741: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
8742: );
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

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 8762: x_return_status := fnd_api.g_ret_sts_unexp_error;

8758: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
8759: );
8760: END IF;
8761:
8762: x_return_status := fnd_api.g_ret_sts_unexp_error;
8763:
8764: IF SQLCODE IS NOT NULL THEN
8765: inv_mobile_helper_functions.sql_error ( 'INV_RCV_COMMON_APIS.insert_range_serial',
8766: l_progress,

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;

Line 9093: RAISE FND_API.G_EXC_ERROR;

9089: IF ( l_debug = 1 ) THEN
9090: print_debug ( 'The person ID for the completed task is null' );
9091: END IF;
9092:
9093: RAISE FND_API.G_EXC_ERROR;
9094: END IF;
9095:
9096: l_progress := '20';
9097:

Line 9214: WHEN FND_API.G_EXC_ERROR THEN

9210: IF ( l_debug = 1 ) THEN
9211: print_debug ( '***End of clean_up_tasks***' );
9212: END IF;
9213: EXCEPTION
9214: WHEN FND_API.G_EXC_ERROR THEN
9215: ROLLBACK TO clean_up_tasks_sp;
9216:
9217: IF ( l_debug = 1 ) THEN
9218: print_debug ( 'Exiting clean_up_tasks - execution error:'

Line 9224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

9220: || ' '
9221: || TO_CHAR ( SYSDATE, 'YYYY-MM-DD HH:DD:SS' )
9222: );
9223: END IF;
9224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9225: ROLLBACK TO clean_up_tasks_sp;
9226:
9227: IF ( l_debug = 1 ) THEN
9228: print_debug ( 'Exiting clean_up_tasks - unexpected error:'