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.CSE_ASSET_MOVE_PKG dependencies on FND_API

Line 263: x_return_status := fnd_api.g_ret_sts_success;

259: WHERE transaction_id = c_transaction_id ;
260:
261: BEGIN
262:
263: x_return_status := fnd_api.g_ret_sts_success;
264:
265: debug('Inside API update_txn_status');
266:
267: IF p_src_move_trans_tbl.COUNT > 0 THEN

Line 292: p_init_msg_list => fnd_api.g_true,

288: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
289:
290: csi_transactions_pvt.update_transactions(
291: p_api_version => 1.0,
292: p_init_msg_list => fnd_api.g_true,
293: p_commit => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_transaction_rec => l_txn_rec,
296: x_return_status => l_return_status,

Line 293: p_commit => fnd_api.g_false,

289:
290: csi_transactions_pvt.update_transactions(
291: p_api_version => 1.0,
292: p_init_msg_list => fnd_api.g_true,
293: p_commit => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_transaction_rec => l_txn_rec,
296: x_return_status => l_return_status,
297: x_msg_count => l_msg_count,

Line 294: p_validation_level => fnd_api.g_valid_level_full,

290: csi_transactions_pvt.update_transactions(
291: p_api_version => 1.0,
292: p_init_msg_list => fnd_api.g_true,
293: p_commit => fnd_api.g_false,
294: p_validation_level => fnd_api.g_valid_level_full,
295: p_transaction_rec => l_txn_rec,
296: x_return_status => l_return_status,
297: x_msg_count => l_msg_count,
298: x_msg_data => l_msg_data);

Line 300: IF l_return_status <> fnd_api.G_RET_STS_success THEN

296: x_return_status => l_return_status,
297: x_msg_count => l_msg_count,
298: x_msg_data => l_msg_data);
299:
300: IF l_return_status <> fnd_api.G_RET_STS_success THEN
301: l_error_msg := cse_util_pkg.dump_error_stack ;
302: RAISE fnd_api.g_exc_error ;
303: END IF;
304:

Line 302: RAISE fnd_api.g_exc_error ;

298: x_msg_data => l_msg_data);
299:
300: IF l_return_status <> fnd_api.G_RET_STS_success THEN
301: l_error_msg := cse_util_pkg.dump_error_stack ;
302: RAISE fnd_api.g_exc_error ;
303: END IF;
304:
305: END IF ; ---src_move_tbl.transaction
306: END IF ; --p_src_trans_tbl.COUNT > 0

Line 351: p_init_msg_list => fnd_api.g_true,

347: debug(' transaction_status : '||l_txn_rec.transaction_status_code);
348:
349: csi_transactions_pvt.update_transactions(
350: p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_true,
352: p_commit => fnd_api.g_false,
353: p_validation_level => fnd_api.g_valid_level_full,
354: p_transaction_rec => l_txn_rec,
355: x_return_status => l_return_status,

Line 352: p_commit => fnd_api.g_false,

348:
349: csi_transactions_pvt.update_transactions(
350: p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_true,
352: p_commit => fnd_api.g_false,
353: p_validation_level => fnd_api.g_valid_level_full,
354: p_transaction_rec => l_txn_rec,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,

Line 353: p_validation_level => fnd_api.g_valid_level_full,

349: csi_transactions_pvt.update_transactions(
350: p_api_version => 1.0,
351: p_init_msg_list => fnd_api.g_true,
352: p_commit => fnd_api.g_false,
353: p_validation_level => fnd_api.g_valid_level_full,
354: p_transaction_rec => l_txn_rec,
355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data);

Line 359: IF l_return_status <> fnd_api.G_RET_STS_success THEN

355: x_return_status => l_return_status,
356: x_msg_count => l_msg_count,
357: x_msg_data => l_msg_data);
358:
359: IF l_return_status <> fnd_api.G_RET_STS_success THEN
360: l_error_msg := cse_util_pkg.dump_error_stack ;
361: RAISE fnd_api.g_exc_error ;
362: END IF;
363: END IF; ---l_dest_move_trans_tbl.

Line 361: RAISE fnd_api.g_exc_error ;

357: x_msg_data => l_msg_data);
358:
359: IF l_return_status <> fnd_api.G_RET_STS_success THEN
360: l_error_msg := cse_util_pkg.dump_error_stack ;
361: RAISE fnd_api.g_exc_error ;
362: END IF;
363: END IF; ---l_dest_move_trans_tbl.
364: END LOOP ; --L-dest_trans_id_tbl
365: END IF ; ---L-dest_trans_id_tbl.COUNT > 0

Line 368: WHEN fnd_api.g_exc_error THEN

364: END LOOP ; --L-dest_trans_id_tbl
365: END IF ; ---L-dest_trans_id_tbl.COUNT > 0
366:
367: EXCEPTION
368: WHEN fnd_api.g_exc_error THEN
369: x_return_status := fnd_api.G_RET_STS_ERROR ;
370: x_error_msg := l_error_msg ;
371: END update_txn_status ;
372:

Line 369: x_return_status := fnd_api.G_RET_STS_ERROR ;

365: END IF ; ---L-dest_trans_id_tbl.COUNT > 0
366:
367: EXCEPTION
368: WHEN fnd_api.g_exc_error THEN
369: x_return_status := fnd_api.G_RET_STS_ERROR ;
370: x_error_msg := l_error_msg ;
371: END update_txn_status ;
372:
373: ------------------------------------------------------------------------------------------

Line 389: x_return_status := fnd_api.g_ret_sts_success ;

385: l_error_msg VARCHAR2(2000);
386:
387: BEGIN
388:
389: x_return_status := fnd_api.g_ret_sts_success ;
390:
391: px_txn_rec.object_version_number := 1;
392: px_txn_rec.transaction_date := sysdate;
393:

Line 396: p_commit => fnd_api.g_false,

392: px_txn_rec.transaction_date := sysdate;
393:
394: csi_transactions_pvt.create_transaction(
395: p_api_version => 1.0,
396: p_commit => fnd_api.g_false,
397: p_init_msg_list => fnd_api.g_true,
398: p_validation_level => fnd_api.g_valid_level_full,
399: p_success_if_exists_flag => 'Y',
400: p_transaction_rec => px_txn_rec,

Line 397: p_init_msg_list => fnd_api.g_true,

393:
394: csi_transactions_pvt.create_transaction(
395: p_api_version => 1.0,
396: p_commit => fnd_api.g_false,
397: p_init_msg_list => fnd_api.g_true,
398: p_validation_level => fnd_api.g_valid_level_full,
399: p_success_if_exists_flag => 'Y',
400: p_transaction_rec => px_txn_rec,
401: x_return_status => l_return_status,

Line 398: p_validation_level => fnd_api.g_valid_level_full,

394: csi_transactions_pvt.create_transaction(
395: p_api_version => 1.0,
396: p_commit => fnd_api.g_false,
397: p_init_msg_list => fnd_api.g_true,
398: p_validation_level => fnd_api.g_valid_level_full,
399: p_success_if_exists_flag => 'Y',
400: p_transaction_rec => px_txn_rec,
401: x_return_status => l_return_status,
402: x_msg_count => l_msg_count,

Line 405: IF l_return_status <> fnd_api.g_ret_sts_success THEN

401: x_return_status => l_return_status,
402: x_msg_count => l_msg_count,
403: x_msg_data => l_msg_data);
404:
405: IF l_return_status <> fnd_api.g_ret_sts_success THEN
406: RAISE fnd_api.g_exc_error;
407: END IF;
408:
409:

Line 406: RAISE fnd_api.g_exc_error;

402: x_msg_count => l_msg_count,
403: x_msg_data => l_msg_data);
404:
405: IF l_return_status <> fnd_api.g_ret_sts_success THEN
406: RAISE fnd_api.g_exc_error;
407: END IF;
408:
409:
410: EXCEPTION

Line 411: WHEN fnd_api.g_exc_error THEN

407: END IF;
408:
409:
410: EXCEPTION
411: WHEN fnd_api.g_exc_error THEN
412: x_return_status := fnd_api.g_ret_sts_error;
413: x_error_message := cse_util_pkg.dump_error_stack;
414: END create_csi_txn;
415: -----------------------------------------------------------------------------------------

Line 412: x_return_status := fnd_api.g_ret_sts_error;

408:
409:
410: EXCEPTION
411: WHEN fnd_api.g_exc_error THEN
412: x_return_status := fnd_api.g_ret_sts_error;
413: x_error_message := cse_util_pkg.dump_error_stack;
414: END create_csi_txn;
415: -----------------------------------------------------------------------------------------
416: -- Derives the unit cost of the FA based on FA_UNITS and FA_COST

Line 453: x_return_status := fnd_api.g_ret_sts_success;

449: BETWEEN fcgd.start_dpis AND NVL(fcgd.end_dpis, fb.date_placed_in_service);
450:
451: BEGIN
452:
453: x_return_status := fnd_api.g_ret_sts_success;
454: debug('Inside API retire_asset');
455:
456: SELECT sysdate INTO l_sysdate FROM sys.dual ;
457:

Line 500: IF l_return_status <> fnd_api.g_ret_sts_success THEN

496: p_ext_ret_rec => l_ext_ret_rec,
497: x_return_status => l_return_status,
498: x_error_msg => l_error_msg) ;
499:
500: IF l_return_status <> fnd_api.g_ret_sts_success THEN
501: debug('Insert into Retirements table failed ');
502: RAISE fnd_api.g_exc_error ;
503: END IF ;
504:

Line 502: RAISE fnd_api.g_exc_error ;

498: x_error_msg => l_error_msg) ;
499:
500: IF l_return_status <> fnd_api.g_ret_sts_success THEN
501: debug('Insert into Retirements table failed ');
502: RAISE fnd_api.g_exc_error ;
503: END IF ;
504:
505: cse_fa_txn_pkg.asset_retirement(
506: p_instance_id => p_fa_inst_dtls_rec.instance_id,

Line 516: IF l_return_status <> fnd_api.g_ret_sts_success THEN

512: px_txn_rec => l_txn_rec,
513: x_return_status => l_return_status,
514: x_error_message => l_error_msg);
515:
516: IF l_return_status <> fnd_api.g_ret_sts_success THEN
517: RAISE fnd_api.g_exc_error;
518: END IF;
519:
520: EXCEPTION

Line 517: RAISE fnd_api.g_exc_error;

513: x_return_status => l_return_status,
514: x_error_message => l_error_msg);
515:
516: IF l_return_status <> fnd_api.g_ret_sts_success THEN
517: RAISE fnd_api.g_exc_error;
518: END IF;
519:
520: EXCEPTION
521: WHEN fnd_api.g_exc_error THEN

Line 521: WHEN fnd_api.g_exc_error THEN

517: RAISE fnd_api.g_exc_error;
518: END IF;
519:
520: EXCEPTION
521: WHEN fnd_api.g_exc_error THEN
522: x_return_status := fnd_api.g_ret_sts_error;
523: x_error_msg := l_error_msg ;
524: END retire_asset ;
525:

Line 522: x_return_status := fnd_api.g_ret_sts_error;

518: END IF;
519:
520: EXCEPTION
521: WHEN fnd_api.g_exc_error THEN
522: x_return_status := fnd_api.g_ret_sts_error;
523: x_error_msg := l_error_msg ;
524: END retire_asset ;
525:
526: PROCEDURE get_fa_details (

Line 602: x_return_status := fnd_api.g_ret_sts_success ;

598: AND fma.add_to_asset_id = c_asset_id;
599:
600: BEGIN
601:
602: x_return_status := fnd_api.g_ret_sts_success ;
603:
604: debug('Inside API get_fa_details');
605:
606: FOR src_fa_inst_dtl_rec IN src_fa_inst_dtl_cur(p_src_move_trans_rec.instance_id)

Line 704: x_return_status := fnd_api.g_ret_sts_success ;

700: FROM csi_i_assets cia
701: WHERE cia.instance_asset_id = c_instance_asset_id ;
702:
703: BEGIN
704: x_return_status := fnd_api.g_ret_sts_success ;
705:
706: debug('Inside API update_inst_asset');
707:
708: debug(' p_transaction_units : '||p_transaction_units);

Line 726: IF nvl(p_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN

722:
723: l_csi_txn_rec := p_csi_txn_rec ;
724: l_inst_asset_rec := p_inst_asset_rec ;
725:
726: IF nvl(p_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
727:
728: l_inst_asset_rec.asset_quantity := l_inst_asset_rec.asset_quantity + p_transaction_units ;
729: l_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
730:

Line 729: l_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;

725:
726: IF nvl(p_inst_asset_rec.instance_asset_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
727:
728: l_inst_asset_rec.asset_quantity := l_inst_asset_rec.asset_quantity + p_transaction_units ;
729: l_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
730:
731: OPEN inst_asset_cur (p_inst_asset_rec.instance_asset_id);
732: FETCH inst_asset_cur INTO l_inst_asset_rec.object_version_number ;
733: CLOSE inst_asset_cur ;

Line 743: p_commit => fnd_api.g_false,

739: debug('Calling csi_asset_pvt.update_instance_asset');
740:
741: csi_asset_pvt.update_instance_asset (
742: p_api_version => 1.0,
743: p_commit => fnd_api.g_false,
744: p_init_msg_list => fnd_api.g_false,
745: p_validation_level => fnd_api.g_valid_level_full,
746: p_instance_asset_rec => l_inst_asset_rec,
747: p_txn_rec => l_csi_txn_rec,

Line 744: p_init_msg_list => fnd_api.g_false,

740:
741: csi_asset_pvt.update_instance_asset (
742: p_api_version => 1.0,
743: p_commit => fnd_api.g_false,
744: p_init_msg_list => fnd_api.g_false,
745: p_validation_level => fnd_api.g_valid_level_full,
746: p_instance_asset_rec => l_inst_asset_rec,
747: p_txn_rec => l_csi_txn_rec,
748: x_return_status => l_return_status,

Line 745: p_validation_level => fnd_api.g_valid_level_full,

741: csi_asset_pvt.update_instance_asset (
742: p_api_version => 1.0,
743: p_commit => fnd_api.g_false,
744: p_init_msg_list => fnd_api.g_false,
745: p_validation_level => fnd_api.g_valid_level_full,
746: p_instance_asset_rec => l_inst_asset_rec,
747: p_txn_rec => l_csi_txn_rec,
748: x_return_status => l_return_status,
749: x_msg_count => l_msg_count,

Line 756: IF l_return_status <> fnd_api.g_ret_sts_success THEN

752: p_asset_count_rec => l_asset_count_rec,
753: p_asset_id_tbl => l_asset_id_tbl,
754: p_asset_loc_tbl => l_asset_loc_tbl );
755:
756: IF l_return_status <> fnd_api.g_ret_sts_success THEN
757: l_error_msg := cse_util_pkg.dump_error_stack ;
758: RAISE fnd_api.g_exc_error;
759: END IF ;
760: ELSE

Line 758: RAISE fnd_api.g_exc_error;

754: p_asset_loc_tbl => l_asset_loc_tbl );
755:
756: IF l_return_status <> fnd_api.g_ret_sts_success THEN
757: l_error_msg := cse_util_pkg.dump_error_stack ;
758: RAISE fnd_api.g_exc_error;
759: END IF ;
760: ELSE
761:
762: --Call get_inst_asset API

Line 775: p_commit => fnd_api.g_false,

771: debug('Inside API csi_asset_pvt.get_instance_assets');
772:
773: csi_asset_pvt.get_instance_assets(
774: p_api_version => 1.0,
775: p_commit => fnd_api.g_false,
776: p_init_msg_list => fnd_api.g_false,
777: p_validation_level => fnd_api.g_valid_level_full,
778: p_instance_asset_query_rec => l_dest_inst_asset_query_rec,
779: p_resolve_id_columns => NULL ,

Line 776: p_init_msg_list => fnd_api.g_false,

772:
773: csi_asset_pvt.get_instance_assets(
774: p_api_version => 1.0,
775: p_commit => fnd_api.g_false,
776: p_init_msg_list => fnd_api.g_false,
777: p_validation_level => fnd_api.g_valid_level_full,
778: p_instance_asset_query_rec => l_dest_inst_asset_query_rec,
779: p_resolve_id_columns => NULL ,
780: p_time_stamp => l_time_stamp ,

Line 777: p_validation_level => fnd_api.g_valid_level_full,

773: csi_asset_pvt.get_instance_assets(
774: p_api_version => 1.0,
775: p_commit => fnd_api.g_false,
776: p_init_msg_list => fnd_api.g_false,
777: p_validation_level => fnd_api.g_valid_level_full,
778: p_instance_asset_query_rec => l_dest_inst_asset_query_rec,
779: p_resolve_id_columns => NULL ,
780: p_time_stamp => l_time_stamp ,
781: x_instance_asset_tbl => l_dest_inst_asset_header_tbl,

Line 786: IF l_return_status <> fnd_api.g_ret_sts_success THEN

782: x_return_status => l_return_status,
783: x_msg_count => l_msg_count,
784: x_msg_data => l_msg_data );
785:
786: IF l_return_status <> fnd_api.g_ret_sts_success THEN
787: l_error_msg := cse_util_pkg.dump_error_stack ;
788: RAISE fnd_api.g_exc_error ;
789: END IF ;
790:

Line 788: RAISE fnd_api.g_exc_error ;

784: x_msg_data => l_msg_data );
785:
786: IF l_return_status <> fnd_api.g_ret_sts_success THEN
787: l_error_msg := cse_util_pkg.dump_error_stack ;
788: RAISE fnd_api.g_exc_error ;
789: END IF ;
790:
791: debug(' x_inst_asset_tbl.count : '||l_dest_inst_asset_header_tbl.count);
792:

Line 801: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.g_false;

797: l_dest_inst_asset_tbl(1).asset_quantity :=
798: l_dest_inst_asset_header_tbl(1).asset_quantity + p_transaction_units;
799: l_dest_inst_asset_tbl(1).object_version_number := l_dest_inst_asset_header_tbl(1).object_version_number;
800: l_dest_inst_asset_tbl(1).active_end_date := p_inst_asset_rec.active_end_date;
801: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.g_false;
802:
803: debug('Inside API csi_asset_pvt.update_instance_asset');
804: debug(' instance_asset_id : '||l_dest_inst_asset_tbl(1).instance_asset_id);
805: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);

Line 809: p_commit => fnd_api.g_false,

805: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);
806:
807: csi_asset_pvt.update_instance_asset (
808: p_api_version => 1.0,
809: p_commit => fnd_api.g_false,
810: p_init_msg_list => fnd_api.g_false,
811: p_validation_level => fnd_api.g_valid_level_full,
812: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
813: p_txn_rec => l_csi_txn_rec,

Line 810: p_init_msg_list => fnd_api.g_false,

806:
807: csi_asset_pvt.update_instance_asset (
808: p_api_version => 1.0,
809: p_commit => fnd_api.g_false,
810: p_init_msg_list => fnd_api.g_false,
811: p_validation_level => fnd_api.g_valid_level_full,
812: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
813: p_txn_rec => l_csi_txn_rec,
814: x_return_status => l_return_status,

Line 811: p_validation_level => fnd_api.g_valid_level_full,

807: csi_asset_pvt.update_instance_asset (
808: p_api_version => 1.0,
809: p_commit => fnd_api.g_false,
810: p_init_msg_list => fnd_api.g_false,
811: p_validation_level => fnd_api.g_valid_level_full,
812: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
813: p_txn_rec => l_csi_txn_rec,
814: x_return_status => l_return_status,
815: x_msg_count => l_msg_count,

Line 822: IF l_return_status <> fnd_api.g_ret_sts_success THEN

818: p_asset_count_rec => l_asset_count_rec,
819: p_asset_id_tbl => l_asset_id_tbl,
820: p_asset_loc_tbl => l_asset_loc_tbl );
821:
822: IF l_return_status <> fnd_api.g_ret_sts_success THEN
823: l_error_msg := cse_util_pkg.dump_error_stack ;
824: RAISE fnd_api.g_exc_error;
825: END IF;
826: ELSE

Line 824: RAISE fnd_api.g_exc_error;

820: p_asset_loc_tbl => l_asset_loc_tbl );
821:
822: IF l_return_status <> fnd_api.g_ret_sts_success THEN
823: l_error_msg := cse_util_pkg.dump_error_stack ;
824: RAISE fnd_api.g_exc_error;
825: END IF;
826: ELSE
827: ---Create a new destination Instance
828: l_dest_inst_asset_tbl(1).update_status := cse_datastructures_pub.G_IN_SERVICE ;

Line 836: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.G_FALSE ;

832: l_dest_inst_asset_tbl(1).fa_location_id := l_inst_asset_rec.fa_location_id ;
833: l_dest_inst_asset_tbl(1).fa_book_type_code := l_inst_asset_rec.fa_book_type_code ;
834: l_dest_inst_asset_tbl(1).active_start_date := l_sysdate;
835: l_dest_inst_asset_tbl(1).asset_quantity := p_transaction_units ;
836: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.G_FALSE ;
837: l_dest_inst_asset_tbl(1).fa_sync_flag := 'Y';
838: l_dest_inst_asset_tbl(1).fa_sync_validation_reqd := fnd_api.g_false;
839:
840: debug('Inside API csi_asset_pvt.create_instance_asset');

Line 838: l_dest_inst_asset_tbl(1).fa_sync_validation_reqd := fnd_api.g_false;

834: l_dest_inst_asset_tbl(1).active_start_date := l_sysdate;
835: l_dest_inst_asset_tbl(1).asset_quantity := p_transaction_units ;
836: l_dest_inst_asset_tbl(1).check_for_instance_expiry := fnd_api.G_FALSE ;
837: l_dest_inst_asset_tbl(1).fa_sync_flag := 'Y';
838: l_dest_inst_asset_tbl(1).fa_sync_validation_reqd := fnd_api.g_false;
839:
840: debug('Inside API csi_asset_pvt.create_instance_asset');
841: debug(' fa_asset_id : '||l_dest_inst_asset_tbl(1).fa_asset_id);
842: debug(' fa_book_type_code : '||l_dest_inst_asset_tbl(1).fa_book_type_code);

Line 848: p_commit => fnd_api.g_false,

844: debug(' instance_asset_qty : '||l_dest_inst_asset_tbl(1).asset_quantity);
845:
846: csi_asset_pvt.create_instance_asset (
847: p_api_version => 1.0,
848: p_commit => fnd_api.g_false,
849: p_init_msg_list => fnd_api.g_false,
850: p_validation_level => fnd_api.g_valid_level_full,
851: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
852: p_txn_rec => l_csi_txn_rec,

Line 849: p_init_msg_list => fnd_api.g_false,

845:
846: csi_asset_pvt.create_instance_asset (
847: p_api_version => 1.0,
848: p_commit => fnd_api.g_false,
849: p_init_msg_list => fnd_api.g_false,
850: p_validation_level => fnd_api.g_valid_level_full,
851: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
852: p_txn_rec => l_csi_txn_rec,
853: x_return_status => l_return_status,

Line 850: p_validation_level => fnd_api.g_valid_level_full,

846: csi_asset_pvt.create_instance_asset (
847: p_api_version => 1.0,
848: p_commit => fnd_api.g_false,
849: p_init_msg_list => fnd_api.g_false,
850: p_validation_level => fnd_api.g_valid_level_full,
851: p_instance_asset_rec => l_dest_inst_asset_tbl(1),
852: p_txn_rec => l_csi_txn_rec,
853: x_return_status => l_return_status,
854: x_msg_count => l_msg_count,

Line 861: IF l_return_status <> fnd_api.g_ret_sts_success THEN

857: p_asset_count_rec => l_asset_count_rec,
858: p_asset_id_tbl => l_asset_id_tbl,
859: p_asset_loc_tbl => l_asset_loc_tbl );
860:
861: IF l_return_status <> fnd_api.g_ret_sts_success THEN
862: l_error_msg := cse_util_pkg.dump_error_stack ;
863: RAISE fnd_api.g_exc_error;
864: END IF;
865:

Line 863: RAISE fnd_api.g_exc_error;

859: p_asset_loc_tbl => l_asset_loc_tbl );
860:
861: IF l_return_status <> fnd_api.g_ret_sts_success THEN
862: l_error_msg := cse_util_pkg.dump_error_stack ;
863: RAISE fnd_api.g_exc_error;
864: END IF;
865:
866: debug(' instance_asset_id : '||l_dest_inst_asset_tbl(1).instance_asset_id);
867:

Line 872: WHEN fnd_api.g_exc_error THEN

868: END IF ;---dest instance asset found
869: END IF ; -- p_src_inst_asset_rec.instance_asset_id IS NOT NULL
870:
871: EXCEPTION
872: WHEN fnd_api.g_exc_error THEN
873: x_return_status := fnd_api.g_ret_sts_error ;
874: x_error_msg := l_error_msg ;
875: END update_inst_asset ;
876:

Line 873: x_return_status := fnd_api.g_ret_sts_error ;

869: END IF ; -- p_src_inst_asset_rec.instance_asset_id IS NOT NULL
870:
871: EXCEPTION
872: WHEN fnd_api.g_exc_error THEN
873: x_return_status := fnd_api.g_ret_sts_error ;
874: x_error_msg := l_error_msg ;
875: END update_inst_asset ;
876:
877: PROCEDURE do_dist_transfer (

Line 912: l_fnd_success := FND_API.G_RET_STS_SUCCESS;

908:
909:
910: BEGIN
911:
912: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
913: l_fnd_error := FND_API.G_RET_STS_ERROR;
914: x_return_status := l_fnd_success ;
915: l_calling_fn := 'OAT';
916: l_upd_csi_i_assets := 'N';

Line 913: l_fnd_error := FND_API.G_RET_STS_ERROR;

909:
910: BEGIN
911:
912: l_fnd_success := FND_API.G_RET_STS_SUCCESS;
913: l_fnd_error := FND_API.G_RET_STS_ERROR;
914: x_return_status := l_fnd_success ;
915: l_calling_fn := 'OAT';
916: l_upd_csi_i_assets := 'N';
917:

Line 982: p_init_msg_list => fnd_api.g_false,

978: debug('Destination Transaction Units :'|| l_asset_dist_tbl(i).transaction_units );
979:
980: fa_transfer_pub.do_transfer (
981: p_api_version => 1.0 ,
982: p_init_msg_list => fnd_api.g_false,
983: p_commit => fnd_api.g_false,
984: p_validation_level => fnd_api.g_valid_level_full,
985: p_calling_fn => l_calling_fn ,
986: x_return_status => l_return_status,

Line 983: p_commit => fnd_api.g_false,

979:
980: fa_transfer_pub.do_transfer (
981: p_api_version => 1.0 ,
982: p_init_msg_list => fnd_api.g_false,
983: p_commit => fnd_api.g_false,
984: p_validation_level => fnd_api.g_valid_level_full,
985: p_calling_fn => l_calling_fn ,
986: x_return_status => l_return_status,
987: x_msg_count => l_msg_count,

Line 984: p_validation_level => fnd_api.g_valid_level_full,

980: fa_transfer_pub.do_transfer (
981: p_api_version => 1.0 ,
982: p_init_msg_list => fnd_api.g_false,
983: p_commit => fnd_api.g_false,
984: p_validation_level => fnd_api.g_valid_level_full,
985: p_calling_fn => l_calling_fn ,
986: x_return_status => l_return_status,
987: x_msg_count => l_msg_count,
988: x_msg_data => l_msg_data ,

Line 1093: x_return_status := fnd_api.g_ret_sts_success;

1089: l_err_inst_rec cse_asset_creation_pkg.instance_rec;
1090:
1091: BEGIN
1092:
1093: x_return_status := fnd_api.g_ret_sts_success;
1094:
1095: retire_asset (
1096: p_fa_inst_dtls_rec => p_src_fa_inst_dtls_rec,
1097: p_units_to_retire => p_transaction_units,

Line 1101: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

1097: p_units_to_retire => p_transaction_units,
1098: x_return_status => l_return_status,
1099: x_error_msg => l_error_message);
1100:
1101: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1102: RAISE fnd_api.g_exc_error;
1103: END IF ;
1104:
1105:

Line 1102: RAISE fnd_api.g_exc_error;

1098: x_return_status => l_return_status,
1099: x_error_msg => l_error_message);
1100:
1101: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1102: RAISE fnd_api.g_exc_error;
1103: END IF ;
1104:
1105:
1106: l_inst_tbl(1).instance_id := p_dest_move_trans_rec.instance_id;

Line 1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1140: p_inst_tbl => l_inst_tbl,
1141: x_return_status => l_return_status,
1142: x_err_inst_rec => l_err_inst_rec);
1143:
1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: EXCEPTION

Line 1145: RAISE fnd_api.g_exc_error;

1141: x_return_status => l_return_status,
1142: x_err_inst_rec => l_err_inst_rec);
1143:
1144: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN fnd_api.g_exc_error THEN

Line 1149: WHEN fnd_api.g_exc_error THEN

1145: RAISE fnd_api.g_exc_error;
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN fnd_api.g_exc_error THEN
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: x_error_msg := l_error_message ;
1152: END do_inter_asset_transfer ;
1153:

Line 1150: x_return_status := fnd_api.g_ret_sts_error;

1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN fnd_api.g_exc_error THEN
1150: x_return_status := fnd_api.g_ret_sts_error;
1151: x_error_msg := l_error_message ;
1152: END do_inter_asset_transfer ;
1153:
1154: PROCEDURE process_adjustment_trans(

Line 1205: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;

1201: l_qty_to_process NUMBER ;
1202: l_qty_canbe_process NUMBER ;
1203: l_qty_being_process NUMBER ;
1204:
1205: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
1206: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
1207: l_sysdate DATE := sysdate;
1208: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec ;
1209: l_error_msg VARCHAR2(4000);

Line 1206: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;

1202: l_qty_canbe_process NUMBER ;
1203: l_qty_being_process NUMBER ;
1204:
1205: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
1206: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
1207: l_sysdate DATE := sysdate;
1208: l_txn_rec CSI_DATASTRUCTURES_PUB.transaction_rec ;
1209: l_error_msg VARCHAR2(4000);
1210: l_return_status VARCHAR2(1);

Line 1221: l_commit VARCHAR2(1) := fnd_api.g_false;

1217:
1218: ---For Public API's
1219: l_api_name VARCHAR2(100) := 'cse_asset_move_pkg.process_adjustment_trans';
1220: l_api_version NUMBER := 1.0;
1221: l_commit VARCHAR2(1) := fnd_api.g_false;
1222: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
1223: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1224: l_msg_index NUMBER;
1225: l_msg_data VARCHAR2(2000);

Line 1222: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;

1218: ---For Public API's
1219: l_api_name VARCHAR2(100) := 'cse_asset_move_pkg.process_adjustment_trans';
1220: l_api_version NUMBER := 1.0;
1221: l_commit VARCHAR2(1) := fnd_api.g_false;
1222: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
1223: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1224: l_msg_index NUMBER;
1225: l_msg_data VARCHAR2(2000);
1226: l_msg_count NUMBER;

Line 1223: l_validation_level NUMBER := fnd_api.g_valid_level_full;

1219: l_api_name VARCHAR2(100) := 'cse_asset_move_pkg.process_adjustment_trans';
1220: l_api_version NUMBER := 1.0;
1221: l_commit VARCHAR2(1) := fnd_api.g_false;
1222: l_init_msg_list VARCHAR2(1) := fnd_api.g_true;
1223: l_validation_level NUMBER := fnd_api.g_valid_level_full;
1224: l_msg_index NUMBER;
1225: l_msg_data VARCHAR2(2000);
1226: l_msg_count NUMBER;
1227: l_trx_error_rec csi_datastructures_pub.transaction_error_rec ;

Line 1261: RAISE fnd_api.g_exc_error;

1257: x_return_status => l_return_status,
1258: x_error_msg => l_error_msg);
1259:
1260: IF l_return_status = l_fnd_error THEN
1261: RAISE fnd_api.g_exc_error;
1262: END IF ;
1263:
1264: IF l_valid_to_process <> 'Y' THEN
1265: debug('this transaction cannot be processed as there are prior pending transaction ');

Line 1266: RAISE fnd_api.g_exc_error ;

1262: END IF ;
1263:
1264: IF l_valid_to_process <> 'Y' THEN
1265: debug('this transaction cannot be processed as there are prior pending transaction ');
1266: RAISE fnd_api.g_exc_error ;
1267: END IF ;
1268:
1269: l_src_move_trans_rec.transaction_id := p_transaction_id ;
1270: l_src_move_trans_rec.transaction_date := cse_neg_adj_rec.transaction_date ;

Line 1292: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1288: x_error_msg => l_error_msg) ;
1289:
1290: debug('after get_fa_details. count : ' ||l_src_fa_inst_dtls_tbl.COUNT);
1291:
1292: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1293: RAISE fnd_api.g_exc_error ;
1294: END IF ;
1295:
1296: IF l_src_fa_inst_dtls_tbl.COUNT > 0 THEN

Line 1293: RAISE fnd_api.g_exc_error ;

1289:
1290: debug('after get_fa_details. count : ' ||l_src_fa_inst_dtls_tbl.COUNT);
1291:
1292: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1293: RAISE fnd_api.g_exc_error ;
1294: END IF ;
1295:
1296: IF l_src_fa_inst_dtls_tbl.COUNT > 0 THEN
1297:

Line 1323: RAISE fnd_api.g_exc_error ;

1319: x_return_status => l_return_status,
1320: x_error_msg => l_error_msg);
1321:
1322: IF l_return_status = l_fnd_error THEN
1323: RAISE fnd_api.g_exc_error ;
1324: END IF ;
1325:
1326: l_qty_to_process := l_qty_to_process - l_qty_being_process ;
1327:

Line 1338: RAISE fnd_api.g_exc_error ;

1334: ELSE
1335: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
1336: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
1337: fnd_msg_pub.add;
1338: RAISE fnd_api.g_exc_error ;
1339: END IF;
1340:
1341: l_src_move_trans_tbl(1) := l_src_move_trans_rec ;
1342: update_txn_status (

Line 1349: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

1345: p_conc_request_id => p_conc_request_id,
1346: x_return_status => l_return_status,
1347: x_error_msg => l_error_msg);
1348:
1349: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1350: debug ('Update Status Failed ..');
1351: RAISE fnd_api.g_exc_error ;
1352: END IF ;
1353:

Line 1351: RAISE fnd_api.g_exc_error ;

1347: x_error_msg => l_error_msg);
1348:
1349: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
1350: debug ('Update Status Failed ..');
1351: RAISE fnd_api.g_exc_error ;
1352: END IF ;
1353:
1354: END; ---cse_neg_adj_cur
1355: END LOOP; ---cse_neg_adj_cur

Line 1358: WHEN fnd_api.g_exc_error THEN

1354: END; ---cse_neg_adj_cur
1355: END LOOP; ---cse_neg_adj_cur
1356:
1357: EXCEPTION
1358: WHEN fnd_api.g_exc_error THEN
1359: l_error_msg := l_error_msg ;
1360: x_return_status := fnd_api.G_RET_STS_ERROR ;
1361: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1362: l_trx_error_rec.error_text := l_error_msg;

Line 1360: x_return_status := fnd_api.G_RET_STS_ERROR ;

1356:
1357: EXCEPTION
1358: WHEN fnd_api.g_exc_error THEN
1359: l_error_msg := l_error_msg ;
1360: x_return_status := fnd_api.G_RET_STS_ERROR ;
1361: l_trx_error_rec.transaction_id := l_src_transaction_id ;
1362: l_trx_error_rec.error_text := l_error_msg;
1363: l_trx_error_rec.source_type := 'ASSET_MOVE';
1364: l_trx_error_rec.source_id := l_src_transaction_id ;

Line 1395: x_return_status := fnd_api.G_RET_STS_ERROR ;

1391: debug ('Error in process_adjustment_trans p_conc_req id ' || l_error_msg );
1392: x_error_msg := l_error_msg ;
1393: WHEN OTHERS THEN
1394: l_error_msg := l_error_msg || SQLERRM ;
1395: x_return_status := fnd_api.G_RET_STS_ERROR ;
1396: fnd_message.set_name('CSE','CSE_UNEXP_SQL_ERROR');
1397: fnd_message.set_token('API_NAME','process_adjustment_trans');
1398: fnd_message.set_token('SQL_ERROR',SQLERRM);
1399: x_error_msg := fnd_message.get;

Line 1507: RAISE fnd_api.g_exc_error ;

1503:
1504: EXCEPTION
1505: WHEN OTHERS THEN
1506: debug('exception - Please check transaction detail history');
1507: RAISE fnd_api.g_exc_error ;
1508: END;
1509:
1510: END IF;
1511:

Line 1519: p_commit => fnd_api.g_false,

1515: debug(' l_time_stamp : '||to_char(l_time_stamp, 'dd-mon-yyyy hh24:mi:ss'));
1516:
1517: csi_item_instance_pub.get_item_instance_details (
1518: p_api_version => 1.0,
1519: p_commit => fnd_api.g_false,
1520: p_init_msg_list => fnd_api.g_true,
1521: p_validation_level => fnd_api.g_valid_level_full,
1522: p_instance_rec => g_inst_rec,
1523: p_get_parties => fnd_api.g_false,

Line 1520: p_init_msg_list => fnd_api.g_true,

1516:
1517: csi_item_instance_pub.get_item_instance_details (
1518: p_api_version => 1.0,
1519: p_commit => fnd_api.g_false,
1520: p_init_msg_list => fnd_api.g_true,
1521: p_validation_level => fnd_api.g_valid_level_full,
1522: p_instance_rec => g_inst_rec,
1523: p_get_parties => fnd_api.g_false,
1524: p_party_header_tbl => g_pty_tbl,

Line 1521: p_validation_level => fnd_api.g_valid_level_full,

1517: csi_item_instance_pub.get_item_instance_details (
1518: p_api_version => 1.0,
1519: p_commit => fnd_api.g_false,
1520: p_init_msg_list => fnd_api.g_true,
1521: p_validation_level => fnd_api.g_valid_level_full,
1522: p_instance_rec => g_inst_rec,
1523: p_get_parties => fnd_api.g_false,
1524: p_party_header_tbl => g_pty_tbl,
1525: p_get_accounts => fnd_api.g_false,

Line 1523: p_get_parties => fnd_api.g_false,

1519: p_commit => fnd_api.g_false,
1520: p_init_msg_list => fnd_api.g_true,
1521: p_validation_level => fnd_api.g_valid_level_full,
1522: p_instance_rec => g_inst_rec,
1523: p_get_parties => fnd_api.g_false,
1524: p_party_header_tbl => g_pty_tbl,
1525: p_get_accounts => fnd_api.g_false,
1526: p_account_header_tbl => g_pa_tbl,
1527: p_get_org_assignments => fnd_api.g_false,

Line 1525: p_get_accounts => fnd_api.g_false,

1521: p_validation_level => fnd_api.g_valid_level_full,
1522: p_instance_rec => g_inst_rec,
1523: p_get_parties => fnd_api.g_false,
1524: p_party_header_tbl => g_pty_tbl,
1525: p_get_accounts => fnd_api.g_false,
1526: p_account_header_tbl => g_pa_tbl,
1527: p_get_org_assignments => fnd_api.g_false,
1528: p_org_header_tbl => g_ou_tbl,
1529: p_get_pricing_attribs => fnd_api.g_false,

Line 1527: p_get_org_assignments => fnd_api.g_false,

1523: p_get_parties => fnd_api.g_false,
1524: p_party_header_tbl => g_pty_tbl,
1525: p_get_accounts => fnd_api.g_false,
1526: p_account_header_tbl => g_pa_tbl,
1527: p_get_org_assignments => fnd_api.g_false,
1528: p_org_header_tbl => g_ou_tbl,
1529: p_get_pricing_attribs => fnd_api.g_false,
1530: p_pricing_attrib_tbl => g_prc_tbl,
1531: p_get_ext_attribs => fnd_api.g_false,

Line 1529: p_get_pricing_attribs => fnd_api.g_false,

1525: p_get_accounts => fnd_api.g_false,
1526: p_account_header_tbl => g_pa_tbl,
1527: p_get_org_assignments => fnd_api.g_false,
1528: p_org_header_tbl => g_ou_tbl,
1529: p_get_pricing_attribs => fnd_api.g_false,
1530: p_pricing_attrib_tbl => g_prc_tbl,
1531: p_get_ext_attribs => fnd_api.g_false,
1532: p_ext_attrib_tbl => g_eav_tbl,
1533: p_ext_attrib_def_tbl => g_ea_tbl,

Line 1531: p_get_ext_attribs => fnd_api.g_false,

1527: p_get_org_assignments => fnd_api.g_false,
1528: p_org_header_tbl => g_ou_tbl,
1529: p_get_pricing_attribs => fnd_api.g_false,
1530: p_pricing_attrib_tbl => g_prc_tbl,
1531: p_get_ext_attribs => fnd_api.g_false,
1532: p_ext_attrib_tbl => g_eav_tbl,
1533: p_ext_attrib_def_tbl => g_ea_tbl,
1534: p_get_asset_assignments => fnd_api.g_false,
1535: p_asset_header_tbl => g_asset_tbl,

Line 1534: p_get_asset_assignments => fnd_api.g_false,

1530: p_pricing_attrib_tbl => g_prc_tbl,
1531: p_get_ext_attribs => fnd_api.g_false,
1532: p_ext_attrib_tbl => g_eav_tbl,
1533: p_ext_attrib_def_tbl => g_ea_tbl,
1534: p_get_asset_assignments => fnd_api.g_false,
1535: p_asset_header_tbl => g_asset_tbl,
1536: p_resolve_id_columns => fnd_api.g_false,
1537: p_time_stamp => l_time_stamp,
1538: x_return_status => l_return_status,

Line 1536: p_resolve_id_columns => fnd_api.g_false,

1532: p_ext_attrib_tbl => g_eav_tbl,
1533: p_ext_attrib_def_tbl => g_ea_tbl,
1534: p_get_asset_assignments => fnd_api.g_false,
1535: p_asset_header_tbl => g_asset_tbl,
1536: p_resolve_id_columns => fnd_api.g_false,
1537: p_time_stamp => l_time_stamp,
1538: x_return_status => l_return_status,
1539: x_msg_count => l_msg_count,
1540: x_msg_data => l_msg_data);

Line 1542: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1538: x_return_status => l_return_status,
1539: x_msg_count => l_msg_count,
1540: x_msg_data => l_msg_data);
1541:
1542: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1543: RAISE fnd_api.g_exc_error;
1544: END IF;
1545:
1546: x_instance_rec := g_inst_rec;

Line 1543: RAISE fnd_api.g_exc_error;

1539: x_msg_count => l_msg_count,
1540: x_msg_data => l_msg_data);
1541:
1542: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1543: RAISE fnd_api.g_exc_error;
1544: END IF;
1545:
1546: x_instance_rec := g_inst_rec;
1547:

Line 1558: WHEN fnd_api.g_exc_error THEN

1554: debug(' instance_usage_code : '||x_instance_rec.instance_usage_code);
1555:
1556:
1557: EXCEPTION
1558: WHEN fnd_api.g_exc_error THEN
1559: x_return_status := fnd_api.g_ret_sts_error;
1560: END get_inst_txn_dtls_srl;
1561:
1562:

Line 1559: x_return_status := fnd_api.g_ret_sts_error;

1555:
1556:
1557: EXCEPTION
1558: WHEN fnd_api.g_exc_error THEN
1559: x_return_status := fnd_api.g_ret_sts_error;
1560: END get_inst_txn_dtls_srl;
1561:
1562:
1563: PROCEDURE get_move_txn_details(

Line 1665: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

1661:
1662: s_ind binary_integer := 0;
1663: d_ind binary_integer := 0;
1664:
1665: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
1666: l_instance_id number;
1667: l_transaction_id number;
1668: l_nsrl_asset_rec nsrl_asset_cur%ROWTYPE;
1669: l_nsrl_inst_rec nsrl_inst_cur%ROWTYPE;

Line 1734: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1730: p_source_dest_flag => 'S',
1731: x_instance_rec => l_src_inst_rec,
1732: x_return_status => l_return_status);
1733:
1734: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1735: RAISE fnd_api.g_exc_error;
1736: END IF;
1737:
1738: -- s_ind := inst_cur%rowcount;

Line 1735: RAISE fnd_api.g_exc_error;

1731: x_instance_rec => l_src_inst_rec,
1732: x_return_status => l_return_status);
1733:
1734: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1735: RAISE fnd_api.g_exc_error;
1736: END IF;
1737:
1738: -- s_ind := inst_cur%rowcount;
1739: s_ind := s_ind + 1;

Line 1769: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1765: p_source_dest_flag => 'D',
1766: x_instance_rec => l_dest_inst_rec,
1767: x_return_status => l_return_status);
1768:
1769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1770: RAISE fnd_api.g_exc_error;
1771: END IF;
1772:
1773: --d_ind := inst_cur%rowcount;

Line 1770: RAISE fnd_api.g_exc_error;

1766: x_instance_rec => l_dest_inst_rec,
1767: x_return_status => l_return_status);
1768:
1769: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1770: RAISE fnd_api.g_exc_error;
1771: END IF;
1772:
1773: --d_ind := inst_cur%rowcount;
1774: d_ind := d_ind + 1;

Line 1849: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1845: p_source_dest_flag => 'D',
1846: x_instance_rec => l_src_inst_rec,
1847: x_return_status => l_return_status);
1848:
1849: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1850: RAISE fnd_api.g_exc_error;
1851: END IF;
1852:
1853: IF l_txn_quantity = 0 THEN

Line 1850: RAISE fnd_api.g_exc_error;

1846: x_instance_rec => l_src_inst_rec,
1847: x_return_status => l_return_status);
1848:
1849: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1850: RAISE fnd_api.g_exc_error;
1851: END IF;
1852:
1853: IF l_txn_quantity = 0 THEN
1854: l_txn_quantity := l_src_inst_rec.quantity;

Line 1930: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1926: x_return_status => l_return_status);
1927:
1928: DEBUG(' return Status '||l_return_status );
1929:
1930: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1931: RAISE fnd_api.g_exc_error;
1932: END IF;
1933:
1934: IF l_txn_quantity = 0 THEN

Line 1931: RAISE fnd_api.g_exc_error;

1927:
1928: DEBUG(' return Status '||l_return_status );
1929:
1930: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1931: RAISE fnd_api.g_exc_error;
1932: END IF;
1933:
1934: IF l_txn_quantity = 0 THEN
1935: l_txn_quantity := l_dest_inst_rec.quantity;

Line 1982: WHEN fnd_api.g_exc_error THEN

1978: x_src_move_trans_tbl := l_src_move_tbl;
1979: x_dest_move_trans_tbl := l_dest_move_tbl;
1980:
1981: EXCEPTION
1982: WHEN fnd_api.g_exc_error THEN
1983: x_return_status := fnd_api.g_ret_sts_error;
1984: END get_move_txn_details;
1985:
1986: -- CASE ACTION

Line 1983: x_return_status := fnd_api.g_ret_sts_error;

1979: x_dest_move_trans_tbl := l_dest_move_tbl;
1980:
1981: EXCEPTION
1982: WHEN fnd_api.g_exc_error THEN
1983: x_return_status := fnd_api.g_ret_sts_error;
1984: END get_move_txn_details;
1985:
1986: -- CASE ACTION
1987: -------------------------------------------------------------------------------

Line 2115: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;

2111: temp_str VARCHAR2(512);
2112:
2113: l_return_status VARCHAR2(1);
2114: l_error_msg VARCHAR2(4000);
2115: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
2116: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
2117: e_error Exception; --added by sreeram
2118: BEGIN
2119:

Line 2116: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;

2112:
2113: l_return_status VARCHAR2(1);
2114: l_error_msg VARCHAR2(4000);
2115: l_fnd_success VARCHAR2(1) := fnd_api.g_ret_sts_success;
2116: l_fnd_error VARCHAR2(1) := fnd_api.g_ret_sts_error;
2117: e_error Exception; --added by sreeram
2118: BEGIN
2119:
2120: x_return_status := l_fnd_success ;

Line 2142: RAISE fnd_api.g_exc_error;

2138: create_csi_txn(l_txn_rec, l_return_status, l_error_msg);
2139:
2140: IF l_return_status <> l_fnd_success THEN
2141: x_error_msg := l_error_msg ;
2142: RAISE fnd_api.g_exc_error;
2143: END IF ;
2144:
2145: FOR s_ind IN p_src_move_trans_tbl.FIRST .. p_src_move_trans_tbl.LAST
2146: LOOP

Line 2162: RAISE fnd_api.g_exc_error ;

2158: x_return_status => l_return_status,
2159: x_error_msg => l_error_msg) ;
2160:
2161: IF l_return_status = l_fnd_error THEN
2162: RAISE fnd_api.g_exc_error ;
2163: END IF ;
2164:
2165: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2166: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');

Line 2169: RAISE fnd_api.g_exc_error ;

2165: IF l_src_fa_inst_dtls_tbl.COUNT = 0 THEN
2166: fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2167: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2168: fnd_msg_pub.add;
2169: RAISE fnd_api.g_exc_error ;
2170: END IF ;
2171:
2172: <>
2173: FOR d_ind IN p_dest_move_trans_tbl.FIRST .. p_dest_move_trans_tbl.LAST

Line 2244: RAISE fnd_api.g_exc_error ;

2240: x_return_status => l_return_status,
2241: x_error_msg => l_error_msg);
2242:
2243: IF l_return_status = l_fnd_error THEN
2244: RAISE fnd_api.g_exc_error ;
2245: END IF ;
2246:
2247: l_dest_fa_dist_rec.location_id := l_dest_fa_location_id ;
2248: IF l_src_fa_inst_dtls_tbl.COUNT > 0 THEN

Line 2261: RAISE fnd_api.g_exc_error ;

2257: debug('abs(l_txn_qty)' || abs(l_txn_qty));
2258: /* fnd_message.set_name('CSE','CSE_SRC_INST_ASSET_NOTFOUND');
2259: fnd_message.set_token('CSI_TRANSACTION', l_src_transaction_id);
2260: fnd_msg_pub.add;*/
2261: RAISE fnd_api.g_exc_error ;
2262: END IF;
2263: END IF;
2264:
2265: IF l_src_fa_inst_dtls_tbl.COUNT > 0 THEN

Line 2333: p_init_msg_list => fnd_api.g_false,

2329: debug('inside api fa_reclass_pub.do_reclass');
2330:
2331: fa_reclass_pub.do_reclass (
2332: p_api_version => 1.0 ,
2333: p_init_msg_list => fnd_api.g_false,
2334: p_commit => fnd_api.g_false,
2335: p_validation_level => fnd_api.g_valid_level_full,
2336: p_calling_fn => l_calling_fn ,
2337: x_return_status => l_return_status,

Line 2334: p_commit => fnd_api.g_false,

2330:
2331: fa_reclass_pub.do_reclass (
2332: p_api_version => 1.0 ,
2333: p_init_msg_list => fnd_api.g_false,
2334: p_commit => fnd_api.g_false,
2335: p_validation_level => fnd_api.g_valid_level_full,
2336: p_calling_fn => l_calling_fn ,
2337: x_return_status => l_return_status,
2338: x_msg_count => l_msg_count,

Line 2335: p_validation_level => fnd_api.g_valid_level_full,

2331: fa_reclass_pub.do_reclass (
2332: p_api_version => 1.0 ,
2333: p_init_msg_list => fnd_api.g_false,
2334: p_commit => fnd_api.g_false,
2335: p_validation_level => fnd_api.g_valid_level_full,
2336: p_calling_fn => l_calling_fn ,
2337: x_return_status => l_return_status,
2338: x_msg_count => l_msg_count,
2339: x_msg_data => l_msg_data,

Line 2347: RAISE fnd_api.g_exc_error ;

2343: p_recl_opt_rec => l_recl_opt_rec );
2344:
2345: IF (l_return_status = l_fnd_error) THEN
2346: l_error_msg := cse_util_pkg.dump_error_stack;
2347: RAISE fnd_api.g_exc_error ;
2348: END IF;
2349: */
2350:
2351: -- For updating the FA Location.

Line 2365: RAISE fnd_api.g_exc_error ;

2361: x_return_status => l_return_status,
2362: x_error_msg => l_error_msg);
2363:
2364: IF l_return_status = l_fnd_error THEN
2365: RAISE fnd_api.g_exc_error ;
2366: END IF ;
2367:
2368: l_asset_hdr_rec.asset_id := l_src_fa_inst_dtls_tbl(j).fa_asset_id ;
2369: l_asset_cat_rec_new.category_id := l_dest_fa_category_id ;

Line 2375: p_init_msg_list => fnd_api.g_false,

2371: debug('inside api fa_reclass_pub.do_reclass');
2372:
2373: fa_reclass_pub.do_reclass (
2374: p_api_version => 1.0 ,
2375: p_init_msg_list => fnd_api.g_false,
2376: p_commit => fnd_api.g_false,
2377: p_validation_level => fnd_api.g_valid_level_full,
2378: p_calling_fn => l_calling_fn ,
2379: x_return_status => l_return_status,

Line 2376: p_commit => fnd_api.g_false,

2372:
2373: fa_reclass_pub.do_reclass (
2374: p_api_version => 1.0 ,
2375: p_init_msg_list => fnd_api.g_false,
2376: p_commit => fnd_api.g_false,
2377: p_validation_level => fnd_api.g_valid_level_full,
2378: p_calling_fn => l_calling_fn ,
2379: x_return_status => l_return_status,
2380: x_msg_count => l_msg_count,

Line 2377: p_validation_level => fnd_api.g_valid_level_full,

2373: fa_reclass_pub.do_reclass (
2374: p_api_version => 1.0 ,
2375: p_init_msg_list => fnd_api.g_false,
2376: p_commit => fnd_api.g_false,
2377: p_validation_level => fnd_api.g_valid_level_full,
2378: p_calling_fn => l_calling_fn ,
2379: x_return_status => l_return_status,
2380: x_msg_count => l_msg_count,
2381: x_msg_data => l_msg_data,

Line 2389: RAISE fnd_api.g_exc_error ;

2385: p_recl_opt_rec => l_recl_opt_rec );
2386:
2387: IF (l_return_status = l_fnd_error) THEN
2388: l_error_msg := cse_util_pkg.dump_error_stack;
2389: RAISE fnd_api.g_exc_error ;
2390: END IF;
2391:
2392: ELSIF l_fa_action_code = '2' THEN --INTER-ASSET transfer
2393: --Create a new FA with a new DPI.

Line 2420: RAISE fnd_api.g_exc_error ;

2416: x_return_status => l_return_status,
2417: x_error_msg => l_error_msg);
2418:
2419: IF (l_return_status = l_fnd_error) THEN
2420: RAISE fnd_api.g_exc_error ;
2421: END IF ;
2422: ELSIF l_fa_action_code = '3' THEN -- INTRA-ASSET
2423:
2424: l_dest_fa_dist_rec.employee_id := l_src_fa_inst_dtls_tbl(j).fa_employee_id ;

Line 2439: RAISE fnd_api.g_exc_error ;

2435: x_return_status => l_return_status,
2436: x_error_msg => l_error_msg);
2437:
2438: IF (l_return_status = l_fnd_error) THEN
2439: RAISE fnd_api.g_exc_error ;
2440: END IF ;
2441: END IF ; --l_fa_action_code (1,2,3).
2442:
2443: -- Done with processing txn_qty?

Line 2476: WHEN fnd_api.g_exc_error THEN

2472:
2473: END IF ; --p_src_move_trans_tbl.COUNT
2474:
2475: EXCEPTION
2476: WHEN fnd_api.g_exc_error THEN
2477: x_return_status := fnd_api.G_RET_STS_ERROR ;
2478: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
2479: debug ('Error : '||x_error_msg);
2480: END update_fa ;

Line 2477: x_return_status := fnd_api.G_RET_STS_ERROR ;

2473: END IF ; --p_src_move_trans_tbl.COUNT
2474:
2475: EXCEPTION
2476: WHEN fnd_api.g_exc_error THEN
2477: x_return_status := fnd_api.G_RET_STS_ERROR ;
2478: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
2479: debug ('Error : '||x_error_msg);
2480: END update_fa ;
2481:

Line 2489: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

2485: x_return_status OUT nocopy varchar2,
2486: x_error_message OUT nocopy varchar2)
2487: IS
2488: l_txn_rec csi_datastructures_pub.transaction_rec;
2489: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
2490: l_msg_count number;
2491: l_msg_data varchar2(2000);
2492: BEGIN
2493:

Line 2494: x_return_status := fnd_api.g_ret_sts_success;

2490: l_msg_count number;
2491: l_msg_data varchar2(2000);
2492: BEGIN
2493:
2494: x_return_status := fnd_api.g_ret_sts_success;
2495:
2496: l_txn_rec.transaction_id := p_csi_txn_id;
2497: l_txn_rec.source_group_ref := fnd_api.g_miss_char;
2498: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;

Line 2497: l_txn_rec.source_group_ref := fnd_api.g_miss_char;

2493:
2494: x_return_status := fnd_api.g_ret_sts_success;
2495:
2496: l_txn_rec.transaction_id := p_csi_txn_id;
2497: l_txn_rec.source_group_ref := fnd_api.g_miss_char;
2498: l_txn_rec.source_group_ref_id := fnd_global.conc_request_id;
2499: l_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete ;
2500:
2501: SELECT object_version_number

Line 2508: p_init_msg_list => fnd_api.g_true,

2504: WHERE transaction_id = l_txn_rec.transaction_id;
2505:
2506: csi_transactions_pvt.update_transactions(
2507: p_api_version => 1.0,
2508: p_init_msg_list => fnd_api.g_true,
2509: p_commit => fnd_api.g_false,
2510: p_validation_level => fnd_api.g_valid_level_full,
2511: p_transaction_rec => l_txn_rec,
2512: x_return_status => l_return_status,

Line 2509: p_commit => fnd_api.g_false,

2505:
2506: csi_transactions_pvt.update_transactions(
2507: p_api_version => 1.0,
2508: p_init_msg_list => fnd_api.g_true,
2509: p_commit => fnd_api.g_false,
2510: p_validation_level => fnd_api.g_valid_level_full,
2511: p_transaction_rec => l_txn_rec,
2512: x_return_status => l_return_status,
2513: x_msg_count => l_msg_count,

Line 2510: p_validation_level => fnd_api.g_valid_level_full,

2506: csi_transactions_pvt.update_transactions(
2507: p_api_version => 1.0,
2508: p_init_msg_list => fnd_api.g_true,
2509: p_commit => fnd_api.g_false,
2510: p_validation_level => fnd_api.g_valid_level_full,
2511: p_transaction_rec => l_txn_rec,
2512: x_return_status => l_return_status,
2513: x_msg_count => l_msg_count,
2514: x_msg_data => l_msg_data);

Line 2516: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2512: x_return_status => l_return_status,
2513: x_msg_count => l_msg_count,
2514: x_msg_data => l_msg_data);
2515:
2516: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: EXCEPTION

Line 2517: RAISE fnd_api.g_exc_error;

2513: x_msg_count => l_msg_count,
2514: x_msg_data => l_msg_data);
2515:
2516: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: EXCEPTION
2521: WHEN fnd_api.g_exc_error THEN

Line 2521: WHEN fnd_api.g_exc_error THEN

2517: RAISE fnd_api.g_exc_error;
2518: END IF;
2519:
2520: EXCEPTION
2521: WHEN fnd_api.g_exc_error THEN
2522: x_return_status := fnd_api.g_ret_sts_error;
2523: END complete_csi_txn;
2524:
2525:

Line 2522: x_return_status := fnd_api.g_ret_sts_error;

2518: END IF;
2519:
2520: EXCEPTION
2521: WHEN fnd_api.g_exc_error THEN
2522: x_return_status := fnd_api.g_ret_sts_error;
2523: END complete_csi_txn;
2524:
2525:
2526:

Line 2552: x_return_status := fnd_api.g_ret_sts_success;

2548: WHERE transaction_id = c_transaction_id ;
2549:
2550: BEGIN
2551:
2552: x_return_status := fnd_api.g_ret_sts_success;
2553: debug('Inside API cse_asset_move_pkg.process_a_move_txn');
2554: debug(' transaction_id : '||p_transaction_id);
2555:
2556: get_move_txn_details(

Line 2562: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2558: x_src_move_trans_tbl => l_src_move_trans_tbl,
2559: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
2560: x_return_status => l_return_status);
2561:
2562: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2563: RAISE fnd_api.g_exc_error ;
2564: END IF ;
2565:
2566: IF l_src_move_trans_tbl.COUNT = 0 OR l_dest_move_trans_tbl.COUNT=0 THEN

Line 2563: RAISE fnd_api.g_exc_error ;

2559: x_dest_move_trans_tbl => l_dest_move_trans_tbl,
2560: x_return_status => l_return_status);
2561:
2562: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2563: RAISE fnd_api.g_exc_error ;
2564: END IF ;
2565:
2566: IF l_src_move_trans_tbl.COUNT = 0 OR l_dest_move_trans_tbl.COUNT=0 THEN
2567: l_error_msg := 'No changes pending for this transaction..';

Line 2578: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

2574: p_dest_move_trans_tbl => l_dest_move_trans_tbl,
2575: x_return_status => l_return_status,
2576: x_error_msg => l_error_msg) ;
2577:
2578: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
2579: RAISE fnd_api.g_exc_error ;
2580: END IF ;
2581:
2582: --Assign Out parameters

Line 2579: RAISE fnd_api.g_exc_error ;

2575: x_return_status => l_return_status,
2576: x_error_msg => l_error_msg) ;
2577:
2578: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
2579: RAISE fnd_api.g_exc_error ;
2580: END IF ;
2581:
2582: --Assign Out parameters
2583: x_src_move_trans_tbl := l_src_move_trans_tbl ;

Line 2591: IF l_return_status <> fnd_api.g_ret_sts_success THEN

2587: complete_csi_txn(
2588: p_csi_txn_id => p_transaction_id,
2589: x_return_status => l_return_status,
2590: x_error_message => l_error_msg);
2591: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2592: RAISE fnd_api.g_exc_error;
2593: END IF;
2594:
2595: END IF ; ---l_src_move_trans_tbl.COUNT is 0.

Line 2592: RAISE fnd_api.g_exc_error;

2588: p_csi_txn_id => p_transaction_id,
2589: x_return_status => l_return_status,
2590: x_error_message => l_error_msg);
2591: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2592: RAISE fnd_api.g_exc_error;
2593: END IF;
2594:
2595: END IF ; ---l_src_move_trans_tbl.COUNT is 0.
2596: EXCEPTION

Line 2597: WHEN fnd_api.g_exc_error THEN

2593: END IF;
2594:
2595: END IF ; ---l_src_move_trans_tbl.COUNT is 0.
2596: EXCEPTION
2597: WHEN fnd_api.g_exc_error THEN
2598: x_move_processed_flag := 'N' ;
2599: x_return_status := fnd_api.G_RET_STS_ERROR ;
2600: x_error_msg := l_error_msg ;
2601: END process_a_move_txn ;

Line 2599: x_return_status := fnd_api.G_RET_STS_ERROR ;

2595: END IF ; ---l_src_move_trans_tbl.COUNT is 0.
2596: EXCEPTION
2597: WHEN fnd_api.g_exc_error THEN
2598: x_move_processed_flag := 'N' ;
2599: x_return_status := fnd_api.G_RET_STS_ERROR ;
2600: x_error_msg := l_error_msg ;
2601: END process_a_move_txn ;
2602:
2603: ---------------------------------------------------------------------------------

Line 2749: l_commit := fnd_api.g_false;

2745:
2746: BEGIN
2747: l_cost_api_ver := 1;
2748: l_api_version := 1.0;
2749: l_commit := fnd_api.g_false;
2750: l_init_msg_list := fnd_api.g_true;
2751: l_validation_level := fnd_api.g_valid_level_full;
2752: l_api_name := 'CSE_ASSET_MOVE_PKG.process_misc_moves';
2753: l_sysdate := SYSDATE ;

Line 2750: l_init_msg_list := fnd_api.g_true;

2746: BEGIN
2747: l_cost_api_ver := 1;
2748: l_api_version := 1.0;
2749: l_commit := fnd_api.g_false;
2750: l_init_msg_list := fnd_api.g_true;
2751: l_validation_level := fnd_api.g_valid_level_full;
2752: l_api_name := 'CSE_ASSET_MOVE_PKG.process_misc_moves';
2753: l_sysdate := SYSDATE ;
2754: l_time_stamp := NULL ;

Line 2751: l_validation_level := fnd_api.g_valid_level_full;

2747: l_cost_api_ver := 1;
2748: l_api_version := 1.0;
2749: l_commit := fnd_api.g_false;
2750: l_init_msg_list := fnd_api.g_true;
2751: l_validation_level := fnd_api.g_valid_level_full;
2752: l_api_name := 'CSE_ASSET_MOVE_PKG.process_misc_moves';
2753: l_sysdate := SYSDATE ;
2754: l_time_stamp := NULL ;
2755: l_move_processed_flag := 'N';

Line 2838: l_src_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;

2834: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;
2835: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;
2836: l_src_inst_asset_rec.asset_quantity := instance_assets_rec.asset_quantity - l_adj_units ;
2837: l_src_inst_asset_rec.object_version_number := instance_assets_rec.object_version_number ;
2838: l_src_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2839: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;
2840: l_txn_rec.transaction_date := l_sysdate;
2841: l_txn_rec.source_transaction_date := l_sysdate;
2842: l_txn_rec.object_version_number := 1 ;

Line 2849: ,p_commit => fnd_api.g_false

2845: debug ('Update Source Inst Asset');
2846: ---Update Source Instant Asset.
2847: csi_asset_pvt.update_instance_asset (
2848: p_api_version => 1.0
2849: ,p_commit => fnd_api.g_false
2850: ,p_init_msg_list => fnd_api.g_false
2851: ,p_validation_level => fnd_api.g_valid_level_full
2852: ,p_instance_asset_rec => l_src_inst_asset_rec
2853: ,p_txn_rec => l_txn_rec

Line 2850: ,p_init_msg_list => fnd_api.g_false

2846: ---Update Source Instant Asset.
2847: csi_asset_pvt.update_instance_asset (
2848: p_api_version => 1.0
2849: ,p_commit => fnd_api.g_false
2850: ,p_init_msg_list => fnd_api.g_false
2851: ,p_validation_level => fnd_api.g_valid_level_full
2852: ,p_instance_asset_rec => l_src_inst_asset_rec
2853: ,p_txn_rec => l_txn_rec
2854: ,x_return_status => l_return_status

Line 2851: ,p_validation_level => fnd_api.g_valid_level_full

2847: csi_asset_pvt.update_instance_asset (
2848: p_api_version => 1.0
2849: ,p_commit => fnd_api.g_false
2850: ,p_init_msg_list => fnd_api.g_false
2851: ,p_validation_level => fnd_api.g_valid_level_full
2852: ,p_instance_asset_rec => l_src_inst_asset_rec
2853: ,p_txn_rec => l_txn_rec
2854: ,x_return_status => l_return_status
2855: ,x_msg_count => l_msg_count

Line 2864: IF l_return_status = fnd_api.G_RET_STS_ERROR

2860: ,p_asset_loc_tbl => l_asset_loc_tbl );
2861:
2862:
2863: debug ('After Update Source Inst Asset');
2864: IF l_return_status = fnd_api.G_RET_STS_ERROR
2865: THEN
2866: l_error_msg := cse_util_pkg.dump_error_stack ;
2867: RAISE e_goto_next_trans ;
2868: END IF;

Line 2914: IF NOT l_return_status = fnd_api.G_RET_STS_SUCCESS

2910: l_return_status,
2911: l_msg_count,
2912: l_msg_data);
2913:
2914: IF NOT l_return_status = fnd_api.G_RET_STS_SUCCESS
2915: THEN
2916: l_error_msg := cse_util_pkg.dump_error_stack ;
2917: RAISE e_goto_next_trans ;
2918: END IF;

Line 2937: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;

2933: l_txn_rec.source_transaction_date := l_sysdate;
2934: l_txn_rec.object_version_number := 1 ;
2935: ---l_txn_rec.transaction_id := NULL ;
2936: l_dest_inst_asset_rec.object_version_number := l_dest_inst_asset_header_tbl(1).object_version_number ;
2937: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2938:
2939: csi_asset_pvt.update_instance_asset (
2940: p_api_version => 1.0
2941: ,p_commit => fnd_api.g_false

Line 2941: ,p_commit => fnd_api.g_false

2937: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2938:
2939: csi_asset_pvt.update_instance_asset (
2940: p_api_version => 1.0
2941: ,p_commit => fnd_api.g_false
2942: ,p_init_msg_list => fnd_api.g_false
2943: ,p_validation_level => fnd_api.g_valid_level_full
2944: ,p_instance_asset_rec => l_dest_inst_asset_rec
2945: ,p_txn_rec => l_txn_rec

Line 2942: ,p_init_msg_list => fnd_api.g_false

2938:
2939: csi_asset_pvt.update_instance_asset (
2940: p_api_version => 1.0
2941: ,p_commit => fnd_api.g_false
2942: ,p_init_msg_list => fnd_api.g_false
2943: ,p_validation_level => fnd_api.g_valid_level_full
2944: ,p_instance_asset_rec => l_dest_inst_asset_rec
2945: ,p_txn_rec => l_txn_rec
2946: ,x_return_status => l_return_status

Line 2943: ,p_validation_level => fnd_api.g_valid_level_full

2939: csi_asset_pvt.update_instance_asset (
2940: p_api_version => 1.0
2941: ,p_commit => fnd_api.g_false
2942: ,p_init_msg_list => fnd_api.g_false
2943: ,p_validation_level => fnd_api.g_valid_level_full
2944: ,p_instance_asset_rec => l_dest_inst_asset_rec
2945: ,p_txn_rec => l_txn_rec
2946: ,x_return_status => l_return_status
2947: ,x_msg_count => l_msg_count

Line 2954: IF l_return_status = fnd_api.G_RET_STS_ERROR

2950: ,p_asset_count_rec => l_asset_count_rec
2951: ,p_asset_id_tbl => l_asset_id_tbl
2952: ,p_asset_loc_tbl => l_asset_loc_tbl );
2953:
2954: IF l_return_status = fnd_api.G_RET_STS_ERROR
2955: THEN
2956: l_error_msg := cse_util_pkg.dump_error_stack ;
2957: RAISE e_goto_next_trans ;
2958: END IF;

Line 2978: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;

2974: l_dest_inst_asset_rec.object_version_number := 1 ;
2975: l_dest_inst_asset_rec.active_start_date := l_sysdate;
2976: l_dest_inst_asset_rec.asset_quantity := l_adj_units ;
2977: l_dest_inst_asset_rec.instance_asset_id := NULL ;
2978: l_dest_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;
2979: l_dest_inst_asset_rec.fa_sync_flag := 'Y' ;
2980:
2981: debug (l_dest_inst_asset_rec.fa_asset_id);
2982: debug('Dest Instance ID : '||l_dest_inst_asset_rec.instance_id);

Line 2991: ,p_commit => fnd_api.g_false

2987:
2988: --l_txn_rec.transaction_id := NULL ;
2989: csi_asset_pvt.create_instance_asset (
2990: p_api_version => 1.0
2991: ,p_commit => fnd_api.g_false
2992: ,p_init_msg_list => fnd_api.g_false
2993: ,p_validation_level => fnd_api.g_valid_level_full
2994: ,p_instance_asset_rec => l_dest_inst_asset_rec
2995: ,p_txn_rec => l_txn_rec

Line 2992: ,p_init_msg_list => fnd_api.g_false

2988: --l_txn_rec.transaction_id := NULL ;
2989: csi_asset_pvt.create_instance_asset (
2990: p_api_version => 1.0
2991: ,p_commit => fnd_api.g_false
2992: ,p_init_msg_list => fnd_api.g_false
2993: ,p_validation_level => fnd_api.g_valid_level_full
2994: ,p_instance_asset_rec => l_dest_inst_asset_rec
2995: ,p_txn_rec => l_txn_rec
2996: ,x_return_status => l_return_status

Line 2993: ,p_validation_level => fnd_api.g_valid_level_full

2989: csi_asset_pvt.create_instance_asset (
2990: p_api_version => 1.0
2991: ,p_commit => fnd_api.g_false
2992: ,p_init_msg_list => fnd_api.g_false
2993: ,p_validation_level => fnd_api.g_valid_level_full
2994: ,p_instance_asset_rec => l_dest_inst_asset_rec
2995: ,p_txn_rec => l_txn_rec
2996: ,x_return_status => l_return_status
2997: ,x_msg_count => l_msg_count

Line 3004: IF l_return_status = fnd_api.G_RET_STS_ERROR

3000: ,p_asset_count_rec => l_asset_count_rec
3001: ,p_asset_id_tbl => l_asset_id_tbl
3002: ,p_asset_loc_tbl => l_asset_loc_tbl );
3003:
3004: IF l_return_status = fnd_api.G_RET_STS_ERROR
3005: THEN
3006: l_error_msg := cse_util_pkg.dump_error_stack ;
3007: RAISE e_goto_next_trans ;
3008: END IF;

Line 3046: IF l_return_status = fnd_api.G_RET_STS_ERROR

3042: ,x_msg_data => l_msg_data
3043: );
3044:
3045:
3046: IF l_return_status = fnd_api.G_RET_STS_ERROR
3047: THEN
3048: l_error_msg := cse_util_pkg.dump_error_stack ;
3049: RAISE e_goto_next_trans ;
3050: END IF;

Line 3078: IF l_return_status = fnd_api.G_RET_STS_ERROR

3074: ,x_msg_data => l_msg_data
3075: );
3076:
3077:
3078: IF l_return_status = fnd_api.G_RET_STS_ERROR
3079: THEN
3080: l_error_msg := cse_util_pkg.dump_error_stack ;
3081: RAISE e_goto_next_trans ;
3082: END IF;

Line 3194: IF l_return_status = fnd_api.G_RET_STS_ERROR

3190: ,x_msg_data => l_msg_data
3191: );
3192:
3193:
3194: IF l_return_status = fnd_api.G_RET_STS_ERROR
3195: THEN
3196: l_error_msg := cse_util_pkg.dump_error_stack ;
3197: RAISE e_error ;
3198: END IF;

Line 3265: x_return_status := fnd_api.G_RET_STS_SUCCESS ;

3261: AND mmt.inventory_item_id = msib.inventory_item_id
3262: AND mmt.transfer_organization_id = msib.organization_id ;
3263:
3264: BEGIN
3265: x_return_status := fnd_api.G_RET_STS_SUCCESS ;
3266:
3267: OPEN get_srl_code_from_org ;
3268: FETCH get_srl_code_from_org INTO x_src_inst_srl_code;
3269: CLOSE get_srl_code_from_org ;

Line 3278: x_return_status := fnd_api.G_RET_STS_ERROR ;

3274:
3275: EXCEPTION
3276: WHEN OTHERS
3277: THEN
3278: x_return_status := fnd_api.G_RET_STS_ERROR ;
3279: x_error_msg := SQLERRM ;
3280: END get_src_dest_inst_srl_code ;
3281:
3282: -------------------------------------------------------------------------------

Line 3480: x_return_status := fnd_api.g_ret_sts_success;

3476:
3477: SELECT sysdate INTO l_sysdate FROM DUAL ;
3478: i := 0;
3479: j := 0;
3480: x_return_status := fnd_api.g_ret_sts_success;
3481:
3482: SELECT inventory_item_id,
3483: shipment_number,
3484: transfer_organization_id

Line 3547: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

3543: p_dest_move_trans_tbl => l_dest_move_trans_tbl,
3544: x_return_status => l_return_status,
3545: x_error_msg => l_error_msg) ;
3546:
3547: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
3548: debug ('Update Status Failed ..');
3549: RAISE e_error ;
3550: END IF ;
3551:

Line 3560: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

3556: p_conc_request_id => p_conc_request_id,
3557: x_return_status => l_return_status,
3558: x_error_msg => l_error_msg);
3559:
3560: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
3561: debug ('Update Status Failed ..');
3562: RAISE e_error ;
3563: END IF ;
3564:

Line 3629: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

3625: p_dest_move_trans_tbl => l_dest_move_trans_tbl,
3626: x_return_status => l_return_status,
3627: x_error_msg => l_error_msg) ;
3628:
3629: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
3630: debug ('Update Status Failed ..');
3631: RAISE e_error ;
3632: END IF ;
3633:

Line 3642: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN

3638: p_conc_request_id => p_conc_request_id,
3639: x_return_status => l_return_status,
3640: x_error_msg => l_error_msg);
3641:
3642: IF l_return_status = fnd_api.G_RET_STS_ERROR THEN
3643: debug ('Update Status Failed ..');
3644: RAISE e_error ;
3645: END IF ;
3646:

Line 3675: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,

3671:
3672: IF l_txn_error_id IS NULL
3673: THEN
3674: csi_transactions_pvt.create_txn_error
3675: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3676: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3677: l_txn_error_id);
3678: ELSE
3679: UPDATE csi_txn_errors

Line 3686: x_return_status := fnd_api.g_ret_sts_error;

3682: last_update_date = l_sysdate
3683: WHERE transaction_error_id = l_txn_error_id ;
3684: END IF ;
3685: --For better error reporting
3686: x_return_status := fnd_api.g_ret_sts_error;
3687: x_error_msg := l_error_msg ;
3688:
3689: WHEN OTHERS
3690: THEN

Line 3713: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,

3709:
3710: IF l_txn_error_id IS NULL
3711: THEN
3712: csi_transactions_pvt.create_txn_error
3713: (1.0, fnd_api.g_true, fnd_api.g_false, fnd_api.g_valid_level_full,
3714: l_trx_error_rec, l_return_status, l_msg_count,l_msg_data,
3715: l_txn_error_id);
3716: ELSE
3717: UPDATE csi_txn_errors

Line 3724: x_return_status := fnd_api.g_ret_sts_error;

3720: last_update_date = l_sysdate
3721: WHERE transaction_error_id = l_txn_error_id ;
3722: END IF ;
3723: --For better error reporting
3724: x_return_status := fnd_api.g_ret_sts_error;
3725:
3726: x_error_msg := l_error_msg || SQLERRM;
3727: END process_srl_nosrl_xorg_txn ;
3728: --------------------------------------------------------------------------------------

Line 4377: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;

4373: l_error_id number;
4374: l_source_type varchar2(20);
4375: l_error_message varchar2(2000);
4376:
4377: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
4378: l_msg_count number;
4379: l_msg_data varchar2(2000);
4380:
4381: BEGIN

Line 4426: p_init_msg_list => fnd_api.g_true,

4422: WHEN no_data_found THEN
4423:
4424: csi_transactions_pvt.create_txn_error (
4425: p_api_version => 1.0,
4426: p_init_msg_list => fnd_api.g_true,
4427: p_commit => fnd_api.g_false,
4428: p_validation_level => fnd_api.g_valid_level_full,
4429: p_txn_error_rec => l_error_rec,
4430: x_transaction_error_id => l_error_id,

Line 4427: p_commit => fnd_api.g_false,

4423:
4424: csi_transactions_pvt.create_txn_error (
4425: p_api_version => 1.0,
4426: p_init_msg_list => fnd_api.g_true,
4427: p_commit => fnd_api.g_false,
4428: p_validation_level => fnd_api.g_valid_level_full,
4429: p_txn_error_rec => l_error_rec,
4430: x_transaction_error_id => l_error_id,
4431: x_return_status => l_return_status,

Line 4428: p_validation_level => fnd_api.g_valid_level_full,

4424: csi_transactions_pvt.create_txn_error (
4425: p_api_version => 1.0,
4426: p_init_msg_list => fnd_api.g_true,
4427: p_commit => fnd_api.g_false,
4428: p_validation_level => fnd_api.g_valid_level_full,
4429: p_txn_error_rec => l_error_rec,
4430: x_transaction_error_id => l_error_id,
4431: x_return_status => l_return_status,
4432: x_msg_count => l_msg_count,

Line 4435: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4431: x_return_status => l_return_status,
4432: x_msg_count => l_msg_count,
4433: x_msg_data => l_msg_data);
4434:
4435: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4436: RAISE fnd_api.g_exc_error;
4437: END IF;
4438:
4439: debug(' new error logged. transaction_error_id : '||l_error_id);

Line 4436: RAISE fnd_api.g_exc_error;

4432: x_msg_count => l_msg_count,
4433: x_msg_data => l_msg_data);
4434:
4435: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4436: RAISE fnd_api.g_exc_error;
4437: END IF;
4438:
4439: debug(' new error logged. transaction_error_id : '||l_error_id);
4440: END;

Line 4443: WHEN fnd_api.g_exc_error THEN

4439: debug(' new error logged. transaction_error_id : '||l_error_id);
4440: END;
4441:
4442: EXCEPTION
4443: WHEN fnd_api.g_exc_error THEN
4444: NULL;
4445: -- i mean if you can't log the error then what else will you do.
4446: -- just leave the transaction as pending so that atleast the next run
4447: -- will pick it yp

Line 4579: l_commit := fnd_api.g_false;

4575: debug(' param.inv_item_id : '||p_inventory_item_id);
4576:
4577: l_api_name :='cse_asset_move_pkg.process_move_transactions';
4578: l_api_version := 1.0;
4579: l_commit := fnd_api.g_false;
4580: l_init_msg_list := fnd_api.g_true;
4581: l_validation_level := fnd_api.g_valid_level_full;
4582: l_sysdate := sysdate ;
4583:

Line 4580: l_init_msg_list := fnd_api.g_true;

4576:
4577: l_api_name :='cse_asset_move_pkg.process_move_transactions';
4578: l_api_version := 1.0;
4579: l_commit := fnd_api.g_false;
4580: l_init_msg_list := fnd_api.g_true;
4581: l_validation_level := fnd_api.g_valid_level_full;
4582: l_sysdate := sysdate ;
4583:
4584: FOR pending_rec IN csi_pending_txn_cur (p_inventory_item_id)

Line 4581: l_validation_level := fnd_api.g_valid_level_full;

4577: l_api_name :='cse_asset_move_pkg.process_move_transactions';
4578: l_api_version := 1.0;
4579: l_commit := fnd_api.g_false;
4580: l_init_msg_list := fnd_api.g_true;
4581: l_validation_level := fnd_api.g_valid_level_full;
4582: l_sysdate := sysdate ;
4583:
4584: FOR pending_rec IN csi_pending_txn_cur (p_inventory_item_id)
4585: LOOP

Line 4618: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4614: p_txn_context => l_txn_context,
4615: px_action => l_txn_action,
4616: x_instance_tbl => l_instance_tbl,
4617: x_return_status => l_return_status);
4618: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4619: RAISE fnd_api.g_exc_error;
4620: END IF;
4621: END IF;
4622: END IF;

Line 4619: RAISE fnd_api.g_exc_error;

4615: px_action => l_txn_action,
4616: x_instance_tbl => l_instance_tbl,
4617: x_return_status => l_return_status);
4618: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4619: RAISE fnd_api.g_exc_error;
4620: END IF;
4621: END IF;
4622: END IF;
4623:

Line 4634: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4630: complete_csi_txn(
4631: p_csi_txn_id => pending_rec.transaction_id,
4632: x_return_status => l_return_status,
4633: x_error_message => l_error_message);
4634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4635: RAISE fnd_api.g_exc_error;
4636: END IF;
4637: END IF;
4638:

Line 4635: RAISE fnd_api.g_exc_error;

4631: p_csi_txn_id => pending_rec.transaction_id,
4632: x_return_status => l_return_status,
4633: x_error_message => l_error_message);
4634: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4635: RAISE fnd_api.g_exc_error;
4636: END IF;
4637: END IF;
4638:
4639: IF l_txn_action = 'MOVE' THEN

Line 4703: IF l_return_status <> fnd_api.g_ret_sts_success THEN

4699: END IF;
4700:
4701: END IF;
4702:
4703: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4704: RAISE fnd_api.g_exc_error;
4705: END IF;
4706:
4707: IF l_txn_action = 'COMPLETE' THEN

Line 4704: RAISE fnd_api.g_exc_error;

4700:
4701: END IF;
4702:
4703: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4704: RAISE fnd_api.g_exc_error;
4705: END IF;
4706:
4707: IF l_txn_action = 'COMPLETE' THEN
4708: l_total_skipped_txns := l_total_skipped_txns + 1;

Line 4720: WHEN fnd_api.g_exc_error THEN

4716: WHEN skip_txn THEN
4717:
4718: l_total_skipped_txns := l_total_skipped_txns + 1;
4719:
4720: WHEN fnd_api.g_exc_error THEN
4721:
4722: l_total_failure_txns := l_total_failure_txns + 1;
4723: l_failure_txn_tbl(l_total_failure_txns).txn_id := pending_rec.transaction_id;
4724: l_failure_txn_tbl(l_total_failure_txns).txn_action := l_txn_action;