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 982: l_error_msg := cse_util_pkg.dump_error_stack;

978: --Get the message the way FA does.
979:
980: debug('After calling fa_transfer_pub.do_transfer : '|| l_return_status );
981: IF (l_return_status = l_fnd_error) THEN
982: l_error_msg := cse_util_pkg.dump_error_stack;
983: debug('Error :'||l_error_msg);
984: RAISE e_error ;
985: END IF;
986: l_upd_csi_i_assets := 'Y';

Line 2065: l_txn_rec := cse_util_pkg.init_txn_rec;

2061: debug(' dst_move_trans_tbl.count : '||p_dest_move_trans_tbl.count);
2062:
2063: IF p_src_move_trans_tbl.COUNT > 0 THEN
2064:
2065: l_txn_rec := cse_util_pkg.init_txn_rec;
2066: l_txn_rec.source_transaction_date := l_sysdate;
2067: l_txn_rec.transaction_date := l_sysdate;
2068: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2069: l_txn_rec.transaction_quantity := 1;

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

2064:
2065: l_txn_rec := cse_util_pkg.init_txn_rec;
2066: l_txn_rec.source_transaction_date := l_sysdate;
2067: l_txn_rec.transaction_date := l_sysdate;
2068: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2069: l_txn_rec.transaction_quantity := 1;
2070: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2071: l_txn_rec.source_header_ref := 'CSI_TXN_ID';
2072: l_txn_rec.source_header_ref_id := p_transaction_id;

Line 2268: l_error_msg := cse_util_pkg.dump_error_stack;

2264: px_asset_cat_rec_new => l_asset_cat_rec_new,
2265: p_recl_opt_rec => l_recl_opt_rec );
2266:
2267: IF (l_return_status = l_fnd_error) THEN
2268: l_error_msg := cse_util_pkg.dump_error_stack;
2269: RAISE fnd_api.g_exc_error ;
2270: END IF;
2271: */
2272:

Line 2310: l_error_msg := cse_util_pkg.dump_error_stack;

2306: px_asset_cat_rec_new => l_asset_cat_rec_new,
2307: p_recl_opt_rec => l_recl_opt_rec );
2308:
2309: IF (l_return_status = l_fnd_error) THEN
2310: l_error_msg := cse_util_pkg.dump_error_stack;
2311: RAISE fnd_api.g_exc_error ;
2312: END IF;
2313:
2314: ELSIF l_fa_action_code = '2' THEN --INTER-ASSET transfer

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

2396:
2397: EXCEPTION
2398: WHEN fnd_api.g_exc_error THEN
2399: x_return_status := fnd_api.G_RET_STS_ERROR ;
2400: x_error_msg := nvl(l_error_msg, cse_util_pkg.dump_error_stack);
2401: debug ('Error : '||x_error_msg);
2402: END update_fa ;
2403:
2404:

Line 2733: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;

2729: l_dest_inst_asset_header_tbl.DELETE ;
2730: l_dest_inst_asset_rec := NULL ;
2731: l_dest_asset_query_rec := NULL ;
2732: l_dest_inst_asset_tbl.DELETE ;
2733: l_dest_inst_asset_query_rec := cse_util_pkg.init_instance_asset_query_rec;
2734:
2735: i := i+1 ;
2736: debug ('Units to be adjusted :'||l_units_to_be_adjusted );
2737: IF l_units_to_be_adjusted > 0

Line 2752: l_txn_rec := cse_util_pkg.init_txn_rec;

2748:
2749: debug ('New Units to be adjusted :'||l_units_to_be_adjusted );
2750: ---Update Source Instance Asset
2751: ---Initialize CSI Transaction Record.
2752: l_txn_rec := cse_util_pkg.init_txn_rec;
2753: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2754: l_txn_rec.transaction_quantity := l_adj_units ;
2755: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;
2756: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;

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

2749: debug ('New Units to be adjusted :'||l_units_to_be_adjusted );
2750: ---Update Source Instance Asset
2751: ---Initialize CSI Transaction Record.
2752: l_txn_rec := cse_util_pkg.init_txn_rec;
2753: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2754: l_txn_rec.transaction_quantity := l_adj_units ;
2755: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;
2756: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;
2757: l_src_inst_asset_rec.asset_quantity := instance_assets_rec.asset_quantity - l_adj_units ;

Line 2755: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;

2751: ---Initialize CSI Transaction Record.
2752: l_txn_rec := cse_util_pkg.init_txn_rec;
2753: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2754: l_txn_rec.transaction_quantity := l_adj_units ;
2755: l_src_inst_asset_Rec := CSE_Util_Pkg.Init_Instance_Asset_Rec;
2756: l_src_inst_asset_rec.instance_asset_id := instance_assets_rec.instance_asset_id ;
2757: l_src_inst_asset_rec.asset_quantity := instance_assets_rec.asset_quantity - l_adj_units ;
2758: l_src_inst_asset_rec.object_version_number := instance_assets_rec.object_version_number ;
2759: l_src_inst_asset_rec.check_for_instance_expiry := fnd_api.G_FALSE ;

Line 2787: l_error_msg := cse_util_pkg.dump_error_stack ;

2783:
2784: debug ('After Update Source Inst Asset');
2785: IF l_return_status = fnd_api.G_RET_STS_ERROR
2786: THEN
2787: l_error_msg := cse_util_pkg.dump_error_stack ;
2788: RAISE e_goto_next_trans ;
2789: END IF;
2790:
2791: --Find Dest Instance Asset and if found

Line 2837: l_error_msg := cse_util_pkg.dump_error_stack ;

2833: l_msg_data);
2834:
2835: IF NOT l_return_status = fnd_api.G_RET_STS_SUCCESS
2836: THEN
2837: l_error_msg := cse_util_pkg.dump_error_stack ;
2838: RAISE e_goto_next_trans ;
2839: END IF;
2840:
2841: IF l_dest_inst_asset_header_tbl.COUNT=1

Line 2846: l_txn_rec := cse_util_pkg.init_txn_rec;

2842: THEN
2843: ---Update Destination Instance Asset
2844: ---Initialize CSI Transaction Record.
2845: debug ('Destination Instance Asset found');
2846: l_txn_rec := cse_util_pkg.init_txn_rec;
2847: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2848: l_txn_rec.transaction_quantity := l_adj_units ;
2849: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2850: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;

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

2843: ---Update Destination Instance Asset
2844: ---Initialize CSI Transaction Record.
2845: debug ('Destination Instance Asset found');
2846: l_txn_rec := cse_util_pkg.init_txn_rec;
2847: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2848: l_txn_rec.transaction_quantity := l_adj_units ;
2849: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2850: l_dest_inst_asset_rec.asset_quantity := l_dest_inst_asset_header_tbl(1).asset_quantity + l_adj_units ;
2851: l_dest_inst_asset_rec.instance_asset_id := l_dest_inst_asset_header_tbl(1).instance_asset_id ;

Line 2877: l_error_msg := cse_util_pkg.dump_error_stack ;

2873: ,p_asset_loc_tbl => l_asset_loc_tbl );
2874:
2875: IF l_return_status = fnd_api.G_RET_STS_ERROR
2876: THEN
2877: l_error_msg := cse_util_pkg.dump_error_stack ;
2878: RAISE e_goto_next_trans ;
2879: END IF;
2880: ELSE
2881: --Create a new destination Instance

Line 2884: l_txn_rec := cse_util_pkg.init_txn_rec;

2880: ELSE
2881: --Create a new destination Instance
2882: --Initialize CSI Transaction Record.
2883: debug ('Destination Instance Asset NOT found');
2884: l_txn_rec := cse_util_pkg.init_txn_rec;
2885: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2886: l_txn_rec.transaction_quantity := l_adj_units ;
2887: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2888: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;

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

2881: --Create a new destination Instance
2882: --Initialize CSI Transaction Record.
2883: debug ('Destination Instance Asset NOT found');
2884: l_txn_rec := cse_util_pkg.init_txn_rec;
2885: l_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
2886: l_txn_rec.transaction_quantity := l_adj_units ;
2887: debug ('Units being transfered : '|| l_txn_rec.transaction_quantity);
2888: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE;
2889: l_txn_rec.transaction_date := l_sysdate;

Line 2927: l_error_msg := cse_util_pkg.dump_error_stack ;

2923: ,p_asset_loc_tbl => l_asset_loc_tbl );
2924:
2925: IF l_return_status = fnd_api.G_RET_STS_ERROR
2926: THEN
2927: l_error_msg := cse_util_pkg.dump_error_stack ;
2928: RAISE e_goto_next_trans ;
2929: END IF;
2930: END IF ;---dest instance asset found
2931: END IF ; ---l_units_to_be_adjusted

Line 2947: l_txn_rec := cse_util_pkg.init_txn_rec;

2943: debug ('Txn Object Version : '||l_src_txn_object_ver_num);
2944:
2945: ---Update Source txn.
2946:
2947: l_txn_rec := cse_util_pkg.init_txn_rec;
2948: l_txn_rec.transaction_id := l_src_transaction_id ;
2949: l_txn_rec.source_group_ref_id := p_conc_request_id;
2950:
2951: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 2969: l_error_msg := cse_util_pkg.dump_error_stack ;

2965:
2966:
2967: IF l_return_status = fnd_api.G_RET_STS_ERROR
2968: THEN
2969: l_error_msg := cse_util_pkg.dump_error_stack ;
2970: RAISE e_goto_next_trans ;
2971: END IF;
2972:
2973: ---Update Destination txn.

Line 2979: l_txn_rec := cse_util_pkg.init_txn_rec;

2975: THEN
2976: debug ('Updating Dest Transactions as Complete '
2977: || dest_misc_move_trans_rec.transaction_id);
2978:
2979: l_txn_rec := cse_util_pkg.init_txn_rec;
2980: l_txn_rec.transaction_id := dest_misc_move_trans_rec.transaction_id ;
2981: l_txn_rec.source_group_ref_id := p_conc_request_id;
2982:
2983: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 3001: l_error_msg := cse_util_pkg.dump_error_stack ;

2997:
2998:
2999: IF l_return_status = fnd_api.G_RET_STS_ERROR
3000: THEN
3001: l_error_msg := cse_util_pkg.dump_error_stack ;
3002: RAISE e_goto_next_trans ;
3003: END IF;
3004: END IF ; --Src txn <> dest txn
3005: COMMIT ;

Line 3095: l_txn_rec := cse_util_pkg.init_txn_rec;

3091: LOOP
3092: debug ('This is Misc Move Transaction for Serial Item');
3093: ---Update Source txn.
3094:
3095: l_txn_rec := cse_util_pkg.init_txn_rec;
3096: l_txn_rec.transaction_id := serial_move_trans_rec.transaction_id ;
3097: l_txn_rec.source_group_ref_id := p_conc_request_id;
3098:
3099: l_txn_rec.transaction_status_code := cse_datastructures_pub.G_COMPLETE ;

Line 3117: l_error_msg := cse_util_pkg.dump_error_stack ;

3113:
3114:
3115: IF l_return_status = fnd_api.G_RET_STS_ERROR
3116: THEN
3117: l_error_msg := cse_util_pkg.dump_error_stack ;
3118: RAISE e_error ;
3119: END IF;
3120:
3121: COMMIT ;

Line 4162: l_error_message := cse_util_pkg.dump_error_stack;

4158:
4159: l_error_message := rtrim(p_error_message);
4160:
4161: IF l_error_message IS NULL THEN
4162: l_error_message := cse_util_pkg.dump_error_stack;
4163: IF l_error_message IS NULL THEN
4164: l_error_message := substr(sqlerrm, 1, 240);
4165: END IF;
4166: END IF;

Line 4347: cse_util_pkg.set_debug;

4343:
4344:
4345: BEGIN
4346:
4347: cse_util_pkg.set_debug;
4348:
4349: debug('Inside process_move_transaction - '||to_char(sysdate, 'dd-mon-yyy hh24:mi:ss'));
4350:
4351: debug(' param.inv_item_id : '||p_inventory_item_id);