DBA Data[Home] [Help]

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:
199: --Added for Bug 9326077
200: IF p_project_num is null THEN

Line 286: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

282:
283: EXCEPTION
284: WHEN no_data_found THEN
285:
286: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
287: l_txn_error_rec.error_text := l_error_message;
288: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
289: l_txn_error_rec.transaction_id := inservice_txn_rec.transaction_id;
290: l_txn_error_rec.source_type := 'CSENIISEI';

Line 332: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;

328: last_update_login = fnd_global.login_id
329: WHERE transaction_error_id = l_txn_error_id;
330: EXCEPTION
331: WHEN no_data_found THEN
332: l_txn_error_rec := cse_util_pkg.init_txn_error_rec;
333: l_txn_error_rec.error_text := x_error_message;
334: l_txn_error_rec.Transaction_id := inservice_txn_rec.transaction_id;
335: l_txn_error_rec.source_group_ref_id := nvl(p_conc_request_id,g_request_id);
336: l_txn_error_rec.source_type := 'NORMAL_ITEM_EXP_ITEM';

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

869: EXCEPTION
870: WHEN fnd_api.g_exc_error THEN
871: ----- Code start for bug 6030501
872: IF x_error_message IS NULL then
873: x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
874: END IF;
875: x_return_status := fnd_api.g_ret_sts_error;
876:
877: debug(' Error Message '||x_error_message);

Line 878: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;

874: END IF;
875: x_return_status := fnd_api.g_ret_sts_error;
876:
877: debug(' Error Message '||x_error_message);
878: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;
879: l_txn_error_rec.ERROR_TEXT := x_error_message;
880: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
881: l_txn_error_rec.SOURCE_TYPE := 'NORMAL_ITEM_ASSET_UNITS';
882: l_txn_error_rec.SOURCE_ID := NULL;

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

892: x_msg_count => l_Msg_Count,
893: x_msg_data => l_Msg_Data,
894: x_transaction_error_id => l_Transaction_Error_Id);
895:
896: -- x_error_message := nvl(cse_util_pkg.dump_error_stack, l_error_message);
897: x_return_status := fnd_api.g_ret_sts_error;
898:
899: ---- Code end for bug 6030501
900: END create_project_asset ;

Line 964: cse_util_pkg.set_debug;

960: l_transaction_id NUMBER;
961:
962: BEGIN
963:
964: cse_util_pkg.set_debug;
965:
966: debug('Inside API cse_fac_inservice_pkg.create_pa_asset_header');
967: debug('param.project_id : '||p_project_id);
968: debug('param.task_id : '||p_task_id);

Line 1075: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;

1071: WHEN fnd_api.g_exc_error THEN
1072: debug(l_error_message);
1073: rollback to insrv_txn;
1074: debug(' Error Message '||l_error_message);
1075: l_txn_error_rec := CSE_UTIL_PKG.Init_Txn_Error_Rec;
1076: l_txn_error_rec.ERROR_TEXT := l_error_message;
1077: l_txn_error_rec.source_group_ref_id := NVL(p_conc_request_id,g_request_id);
1078: l_txn_error_rec.SOURCE_TYPE := 'NORMAL_ITEM_ASSET_UNITS';
1079: l_txn_error_rec.SOURCE_ID := NULL;

Line 1167: cse_util_pkg.get_string_value(

1163: debug('unit adjustment record # '||txn_cur%rowcount);
1164:
1165: l_asset_id := null;
1166:
1167: cse_util_pkg.get_string_value(
1168: p_string => txn_rec.message_string,
1169: p_attribute => 'ASSET_ID',
1170: x_value => l_asset_id);
1171:

Line 1174: cse_util_pkg.get_string_value(

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

Line 1181: cse_util_pkg.get_string_value(

1177: x_value => l_book_type_code);
1178:
1179: l_units := null;
1180:
1181: cse_util_pkg.get_string_value(
1182: p_string => txn_rec.message_string,
1183: p_attribute => 'UNITS',
1184: x_value => l_units);
1185:

Line 1188: cse_util_pkg.get_string_value(

1184: x_value => l_units);
1185:
1186: l_location_id := null;
1187:
1188: cse_util_pkg.get_string_value(
1189: p_string => txn_rec.message_string,
1190: p_attribute => 'LOCATION_ID',
1191: x_value => l_location_id);
1192:

Line 1195: cse_util_pkg.get_string_value(

1191: x_value => l_location_id);
1192:
1193: l_expense_ccid := null;
1194:
1195: cse_util_pkg.get_string_value(
1196: p_string => txn_rec.message_string,
1197: p_attribute => 'DEPRN_EXPENSE_CCID',
1198: x_value => l_expense_ccid);
1199:

Line 1202: cse_util_pkg.get_string_value(

1198: x_value => l_expense_ccid);
1199:
1200: l_employee_id := null;
1201:
1202: cse_util_pkg.get_string_value(
1203: p_string => txn_rec.message_string,
1204: p_attribute => 'EMPLOYEE_ID',
1205: x_value => l_employee_id);
1206:

Line 1209: cse_util_pkg.get_string_value(

1205: x_value => l_employee_id);
1206:
1207: l_instance_id := null;
1208:
1209: cse_util_pkg.get_string_value(
1210: p_string => txn_rec.message_string,
1211: p_attribute => 'INSTANCE_ID',
1212: x_value => l_instance_id);
1213:

Line 1235: l_csi_txn_rec := cse_util_pkg.init_txn_rec;

1231: WHERE instance_id = l_instance_id
1232: AND fa_asset_id = l_asset_id
1233: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1);
1234:
1235: l_csi_txn_rec := cse_util_pkg.init_txn_rec;
1236: l_csi_txn_rec.transaction_date := sysdate;
1237: l_csi_txn_rec.source_transaction_date := sysdate;
1238: l_csi_txn_rec.transaction_quantity := l_units;
1239: l_csi_txn_rec.source_header_ref := 'ASSET_ID';

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

1238: l_csi_txn_rec.transaction_quantity := l_units;
1239: l_csi_txn_rec.source_header_ref := 'ASSET_ID';
1240: l_csi_txn_rec.source_header_ref_id := l_asset_id;
1241: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;
1242: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
1243:
1244: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1245: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;
1246: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;

Line 1244: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;

1240: l_csi_txn_rec.source_header_ref_id := l_asset_id;
1241: l_csi_txn_rec.transaction_status_code := cse_datastructures_pub.g_complete;
1242: l_csi_txn_rec.transaction_type_id := cse_util_pkg.get_txn_type_id('INSTANCE_ASSET_TIEBACK','CSE');
1243:
1244: l_inst_asset_rec := cse_util_pkg.init_instance_asset_rec;
1245: l_inst_asset_rec.asset_quantity := l_asset_quantity + l_units;
1246: l_inst_asset_rec.instance_asset_id := l_instance_asset_id;
1247: l_inst_asset_rec.object_version_number := l_object_version_number;
1248: l_inst_asset_rec.update_status := cse_datastructures_pub.g_in_service;