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_FAC_INSERVICE_PKG dependencies on CSE_UTIL_PKG

Line 141: cse_util_pkg.set_debug;

137: AND (cii.operational_status_code = 'IN_SERVICE' OR ciih.new_operational_status_code = 'IN_SERVICE');
138:
139: BEGIN
140:
141: cse_util_pkg.set_debug;
142:
143: debug('Inside API cse_fac_inservice_pkg.create_expitem');
144:
145: x_return_status := g_ret_sts_success;

Line 196: cse_util_pkg.check_depreciable(inservice_inst_rec.inventory_item_id, l_depreciable);

192: debug(' location_type_code : '||inservice_inst_rec.location_type_code);
193: debug(' location_id : '||inservice_inst_rec.location_id);
194: debug(' operation_status_code: '||inservice_inst_rec.operational_status_code);
195:
196: cse_util_pkg.check_depreciable(inservice_inst_rec.inventory_item_id, l_depreciable);
197:
198: debug(' depreciable_flag : '||l_depreciable);
199:
200: IF l_depreciable = 'N' THEN

Line 273: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

269:
270: EXCEPTION
271: WHEN no_data_found THEN
272:
273: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
274: l_txn_error_rec.error_text := l_error_message;
275: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
276: l_txn_error_rec.transaction_id := inservice_txn_rec.transaction_id;
277: l_txn_error_rec.source_type := 'CSENIISEI';

Line 319: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

315: last_update_login = fnd_global.login_id
316: WHERE transaction_error_id = l_txn_error_id;
317: EXCEPTION
318: WHEN no_data_found THEN
319: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
320: l_txn_error_rec.error_text := x_error_message;
321: l_txn_error_rec.Transaction_id := inservice_txn_rec.transaction_id;
322: l_txn_error_rec.source_group_ref_id := nvl(p_conc_request_id,g_request_id);
323: l_txn_error_rec.source_type := 'NORMAL_ITEM_EXP_ITEM';

Line 859: x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);

855: EXCEPTION
856: WHEN fnd_api.g_exc_error THEN
857: ----- Code start for bug 6030501
858: IF x_error_message IS NULL then
859: x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
860: END IF;
861: x_return_status := fnd_api.g_ret_sts_error;
862:
863: debug(' Error Message '||x_error_message);

Line 864: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;

860: END IF;
861: x_return_status := fnd_api.g_ret_sts_error;
862:
863: debug(' Error Message '||x_error_message);
864: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;
865: l_txn_error_rec.ERROR_TEXT := x_error_message;
866: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
867: l_txn_error_rec.SOURCE_TYPE := 'NORMAL_ITEM_ASSET_UNITS';
868: l_txn_error_rec.SOURCE_ID := NULL;

Line 882: -- x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);

878: x_msg_count => l_Msg_Count,
879: x_msg_data => l_Msg_Data,
880: x_transaction_error_id => l_Transaction_Error_Id);
881:
882: -- x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
883: x_return_status := fnd_api.g_ret_sts_error;
884:
885: ---- Code end for bug 6030501
886: END create_project_asset ;

Line 946: cse_util_pkg.set_debug;

942: l_transaction_id NUMBER;
943:
944: BEGIN
945:
946: cse_util_pkg.set_debug;
947:
948: debug('Inside API cse_fac_inservice_pkg.create_pa_asset_header');
949: debug('param.project_id : '||p_project_id);
950: debug('param.task_id : '||p_task_id);

Line 1040: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;

1036: WHEN fnd_api.g_exc_error THEN
1037: debug(l_error_message);
1038: rollback to insrv_txn;
1039: debug(' Error Message '||l_error_message);
1040: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;
1041: l_txn_error_rec.ERROR_TEXT := l_error_message;
1042: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
1043: l_txn_error_rec.SOURCE_TYPE := 'NORMAL_ITEM_ASSET_UNITS';
1044: l_txn_error_rec.SOURCE_ID := NULL;

Line 1132: cse_util_pkg.get_string_value(

1128: debug('unit adjustment record # '||txn_cur%rowcount);
1129:
1130: l_asset_id := null;
1131:
1132: cse_util_pkg.get_string_value(
1133: p_string => txn_rec.message_string,
1134: p_attribute => 'ASSET_ID',
1135: x_value => l_asset_id);
1136:

Line 1139: cse_util_pkg.get_string_value(

1135: x_value => l_asset_id);
1136:
1137: l_book_type_code := null;
1138:
1139: cse_util_pkg.get_string_value(
1140: p_string => txn_rec.message_string,
1141: p_attribute => 'BOOK_TYPE_CODE',
1142: x_value => l_book_type_code);
1143:

Line 1146: cse_util_pkg.get_string_value(

1142: x_value => l_book_type_code);
1143:
1144: l_units := null;
1145:
1146: cse_util_pkg.get_string_value(
1147: p_string => txn_rec.message_string,
1148: p_attribute => 'UNITS',
1149: x_value => l_units);
1150:

Line 1153: cse_util_pkg.get_string_value(

1149: x_value => l_units);
1150:
1151: l_location_id := null;
1152:
1153: cse_util_pkg.get_string_value(
1154: p_string => txn_rec.message_string,
1155: p_attribute => 'LOCATION_ID',
1156: x_value => l_location_id);
1157:

Line 1160: cse_util_pkg.get_string_value(

1156: x_value => l_location_id);
1157:
1158: l_expense_ccid := null;
1159:
1160: cse_util_pkg.get_string_value(
1161: p_string => txn_rec.message_string,
1162: p_attribute => 'DEPRN_EXPENSE_CCID',
1163: x_value => l_expense_ccid);
1164:

Line 1167: cse_util_pkg.get_string_value(

1163: x_value => l_expense_ccid);
1164:
1165: l_employee_id := null;
1166:
1167: cse_util_pkg.get_string_value(
1168: p_string => txn_rec.message_string,
1169: p_attribute => 'EMPLOYEE_ID',
1170: x_value => l_employee_id);
1171:

Line 1174: cse_util_pkg.get_string_value(

1170: x_value => l_employee_id);
1171:
1172: l_instance_id := null;
1173:
1174: cse_util_pkg.get_string_value(
1175: p_string => txn_rec.message_string,
1176: p_attribute => 'INSTANCE_ID',
1177: x_value => l_instance_id);
1178:

Line 1200: l_csi_txn_rec := cse_util_pkg.init_txn_rec;

1196: WHERE instance_id = l_instance_id
1197: AND fa_asset_id = l_asset_id
1198: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1);
1199:
1200: l_csi_txn_rec := cse_util_pkg.init_txn_rec;
1201: l_csi_txn_rec.transaction_date := sysdate;
1202: l_csi_txn_rec.source_transaction_date := sysdate;
1203: l_csi_txn_rec.transaction_quantity := l_units;
1204: l_csi_txn_rec.source_header_ref := 'ASSET_ID';

Line 1207: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');

1203: l_csi_txn_rec.transaction_quantity := l_units;
1204: l_csi_txn_rec.source_header_ref := 'ASSET_ID';
1205: l_csi_txn_rec.source_header_ref_id := l_asset_id;
1206: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;
1207: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
1208:
1209: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1210: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;
1211: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;

Line 1209: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;

1205: l_csi_txn_rec.source_header_ref_id := l_asset_id;
1206: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;
1207: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
1208:
1209: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1210: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;
1211: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;
1212: l_inst_asset_rec.object_version_number := l_object_version_number;
1213: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;