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 CSE_UTIL_PKG

Line 273: l_txn_rec := cse_util_pkg.init_txn_rec;

269:
270: debug('updating source transaction');
271:
272: l_src_transaction_id := p_src_move_trans_tbl(1).transaction_id ;
273: l_txn_rec := cse_util_pkg.init_txn_rec;
274: l_txn_rec.transaction_id := p_src_move_trans_tbl(1).transaction_id ;
275: l_txn_rec.source_group_ref_id := p_conc_request_id;
276:
277: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 301: l_error_msg := cse_util_pkg.dump_error_stack ;

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:
305: END IF ; ---src_move_tbl.transaction

Line 337: l_txn_rec := cse_util_pkg.init_txn_rec;

333: debug('updating destination transaction');
334:
335: l_dest_txn_processed := 0;
336:
337: l_txn_rec := cse_util_pkg.init_txn_rec;
338: l_txn_rec.transaction_id := p_dest_move_trans_tbl(j).transaction_id ;
339: l_txn_rec.source_group_ref_id := p_conc_request_id;
340:
341: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 360: l_error_msg := cse_util_pkg.dump_error_stack ;

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.
364: END LOOP ; --L-dest_trans_id_tbl

Line 413: x_error_message := cse_util_pkg.dump_error_stack;

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
417: -- Prorates the same for p_units_to_retire

Line 757: l_error_msg := cse_util_pkg.dump_error_stack ;

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
761:

Line 763: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;

759: END IF ;
760: ELSE
761:
762: --Call get_inst_asset API
763: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;
764:
765: l_dest_inst_asset_query_rec.update_status := cse_datastructures_pub.g_in_service;
766: l_dest_inst_asset_query_rec.instance_id := l_inst_asset_rec.instance_id;
767: l_dest_inst_asset_query_rec.fa_asset_id := l_inst_asset_rec.fa_asset_id;

Line 787: l_error_msg := cse_util_pkg.dump_error_stack ;

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:
791: debug(' x_inst_asset_tbl.count : '||l_dest_inst_asset_header_tbl.count);

Line 823: l_error_msg := cse_util_pkg.dump_error_stack ;

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
827: ---Create a new destination Instance

Line 862: l_error_msg := cse_util_pkg.dump_error_stack ;

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:
866: debug(' instance_asset_id : '||l_dest_inst_asset_tbl(1).instance_asset_id);

Line 997: l_error_msg := cse_util_pkg.dump_error_stack;

993: --Get the message the way FA does.
994:
995: debug('After calling fa_transfer_pub.do_transfer : '|| l_return_status );
996: IF (l_return_status = l_fnd_error) THEN
997: l_error_msg := cse_util_pkg.dump_error_stack;
998: debug('Error :'||l_error_msg);
999: RAISE e_error ;
1000: END IF;
1001: l_upd_csi_i_assets := 'Y';

Line 2128: l_txn_rec := cse_util_pkg.init_txn_rec;

2124: debug(' dst_move_trans_tbl.count : '||p_dest_move_trans_tbl.count);
2125:
2126: IF p_src_move_trans_tbl.COUNT > 0 THEN
2127:
2128: l_txn_rec := cse_util_pkg.init_txn_rec;
2129: l_txn_rec.source_transaction_date := l_sysdate;
2130: l_txn_rec.transaction_date := l_sysdate;
2131: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2132: l_txn_rec.transaction_quantity := 1;

Line 2131: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');

2127:
2128: l_txn_rec := cse_util_pkg.init_txn_rec;
2129: l_txn_rec.source_transaction_date := l_sysdate;
2130: l_txn_rec.transaction_date := l_sysdate;
2131: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2132: l_txn_rec.transaction_quantity := 1;
2133: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2134: l_txn_rec.source_header_ref := 'CSI_TXN_ID';
2135: l_txn_rec.source_header_ref_id := p_transaction_id;

Line 2346: l_error_msg := cse_util_pkg.dump_error_stack;

2342: px_asset_cat_rec_new => l_asset_cat_rec_new,
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:

Line 2388: l_error_msg := cse_util_pkg.dump_error_stack;

2384: px_asset_cat_rec_new => l_asset_cat_rec_new,
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

Line 2478: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);

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:
2482:

Line 2812: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;

2808: l_dest_inst_asset_header_tbl.DELETE ;
2809: l_dest_inst_asset_rec := NULL ;
2810: l_dest_asset_query_rec := NULL ;
2811: l_dest_inst_asset_tbl.DELETE ;
2812: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;
2813:
2814: i := i+1 ;
2815: debug ('Units to be adjusted :'||l_units_to_be_adjusted );
2816: IF l_units_to_be_adjusted > 0

Line 2831: l_txn_rec := cse_util_pkg.init_txn_rec;

2827:
2828: debug ('New Units to be adjusted :'||l_units_to_be_adjusted );
2829: ---Update Source Instance Asset
2830: ---Initialize CSI Transaction Record.
2831: l_txn_rec := cse_util_pkg.init_txn_rec;
2832: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2833: l_txn_rec.transaction_quantity := l_adj_units ;
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 ;

Line 2832: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');

2828: debug ('New Units to be adjusted :'||l_units_to_be_adjusted );
2829: ---Update Source Instance Asset
2830: ---Initialize CSI Transaction Record.
2831: l_txn_rec := cse_util_pkg.init_txn_rec;
2832: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2833: l_txn_rec.transaction_quantity := l_adj_units ;
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 ;

Line 2834: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;

2830: ---Initialize CSI Transaction Record.
2831: l_txn_rec := cse_util_pkg.init_txn_rec;
2832: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2833: l_txn_rec.transaction_quantity := l_adj_units ;
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 ;

Line 2866: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
2869:
2870: --Find Dest Instance Asset and if found

Line 2916: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
2919:
2920: IF l_dest_inst_asset_header_tbl.COUNT=1

Line 2925: l_txn_rec := cse_util_pkg.init_txn_rec;

2921: THEN
2922: ---Update Destination Instance Asset
2923: ---Initialize CSI Transaction Record.
2924: debug ('Destination Instance Asset found');
2925: l_txn_rec := cse_util_pkg.init_txn_rec;
2926: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2927: l_txn_rec.transaction_quantity := l_adj_units ;
2928: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2929: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;

Line 2926: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');

2922: ---Update Destination Instance Asset
2923: ---Initialize CSI Transaction Record.
2924: debug ('Destination Instance Asset found');
2925: l_txn_rec := cse_util_pkg.init_txn_rec;
2926: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2927: l_txn_rec.transaction_quantity := l_adj_units ;
2928: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2929: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;
2930: l_dest_inst_asset_rec.instance_asset_id := l_dest_inst_asset_header_tbl(1).instance_asset_id ;

Line 2956: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
2959: ELSE
2960: --Create a new destination Instance

Line 2963: l_txn_rec := cse_util_pkg.init_txn_rec;

2959: ELSE
2960: --Create a new destination Instance
2961: --Initialize CSI Transaction Record.
2962: debug ('Destination Instance Asset NOT found');
2963: l_txn_rec := cse_util_pkg.init_txn_rec;
2964: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2965: l_txn_rec.transaction_quantity := l_adj_units ;
2966: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2967: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;

Line 2964: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');

2960: --Create a new destination Instance
2961: --Initialize CSI Transaction Record.
2962: debug ('Destination Instance Asset NOT found');
2963: l_txn_rec := cse_util_pkg.init_txn_rec;
2964: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2965: l_txn_rec.transaction_quantity := l_adj_units ;
2966: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2967: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2968: l_txn_rec.transaction_date := l_sysdate;

Line 3006: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
3009: END IF ;---dest instance asset found
3010: END IF ; ---l_units_to_be_adjusted

Line 3026: l_txn_rec := cse_util_pkg.init_txn_rec;

3022: debug ('Txn Object Version : '||l_src_txn_object_ver_num);
3023:
3024: ---Update Source txn.
3025:
3026: l_txn_rec := cse_util_pkg.init_txn_rec;
3027: l_txn_rec.transaction_id := l_src_transaction_id ;
3028: l_txn_rec.source_group_ref_id := p_conc_request_id;
3029:
3030: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 3048: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
3051:
3052: ---Update Destination txn.

Line 3058: l_txn_rec := cse_util_pkg.init_txn_rec;

3054: THEN
3055: debug ('Updating Dest Transactions as Complete '
3056: || dest_misc_move_trans_rec.transaction_id);
3057:
3058: l_txn_rec := cse_util_pkg.init_txn_rec;
3059: l_txn_rec.transaction_id := dest_misc_move_trans_rec.transaction_id ;
3060: l_txn_rec.source_group_ref_id := p_conc_request_id;
3061:
3062: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 3080: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
3083: END IF ; --Src txn <> dest txn
3084: COMMIT ;

Line 3174: l_txn_rec := cse_util_pkg.init_txn_rec;

3170: LOOP
3171: debug ('This is Misc Move Transaction for Serial Item');
3172: ---Update Source txn.
3173:
3174: l_txn_rec := cse_util_pkg.init_txn_rec;
3175: l_txn_rec.transaction_id := serial_move_trans_rec.transaction_id ;
3176: l_txn_rec.source_group_ref_id := p_conc_request_id;
3177:
3178: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 3196: l_error_msg := cse_util_pkg.dump_error_stack ;

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;
3199:
3200: COMMIT ;

Line 4386: l_error_message := cse_util_pkg.dump_error_stack;

4382:
4383: l_error_message := rtrim(p_error_message);
4384:
4385: IF l_error_message IS NULL THEN
4386: l_error_message := cse_util_pkg.dump_error_stack;
4387: IF l_error_message IS NULL THEN
4388: l_error_message := substr(sqlerrm, 1, 240);
4389: END IF;
4390: END IF;

Line 4571: cse_util_pkg.set_debug;

4567:
4568:
4569: BEGIN
4570:
4571: cse_util_pkg.set_debug;
4572:
4573: debug('Inside process_move_transaction - '||to_char(sysdate, 'dd-mon-yyy hh24:mi:ss'));
4574:
4575: debug(' param.inv_item_id : '||p_inventory_item_id);