[Home] [Help]
257: --
258:
259: if (x_iface_rec.cycle_count_entry_id is null) then
260:
261: mtl_cceoi_process_pvt.Validate_CHeader
262: (
263: p_api_version => 0.9,
264: x_msg_count => x_msg_count,
265: x_msg_data => x_msg_data,
272: if (x_return_status <> fnd_api.g_ret_sts_success) then
273: raise fnd_api.g_exc_error;
274: end if;
275:
276: mtl_cceoi_process_pvt.Validate_CountListSeq
277: (
278: p_api_version => 0.9,
279: x_msg_count => x_msg_count,
280: x_msg_data => x_msg_data,
331: if (x_iface_rec.action_code <> mtl_cceoi_var_pvt.g_valsim) then
332: IF (l_debug = 1) THEN
333: mdebug('Exporting: ' || to_char(x_iface_rec.cycle_count_entry_id));
334: END IF;
335: mtl_cceoi_process_pvt.Set_CCExport(
336: p_api_version => 0.9,
337: x_msg_data => x_msg_data,
338: x_msg_count => x_msg_count,
339: x_return_status => x_return_status,
541: -- we may want to warn about updating only count info
542: x_iface_rec.cycle_count_entry_id := c_rec.cycle_count_entry_id;
543: x_iface_rec.lock_flag := 1;
544:
545: mtl_cceoi_process_pvt.Update_CCIEntry(x_iface_rec,x_return_status);
546:
547: if (x_return_status <> fnd_api.g_ret_sts_success) then
548: raise fnd_api.g_exc_unexpected_error;
549: end if;
594: x_iface_rec.error_flag := c_rec.error_flag;
595: x_iface_rec.lock_flag := 1;
596: x_iface_rec.cycle_count_header_id := mtl_cceoi_var_pvt.g_cc_header_id;
597:
598: mtl_cceoi_process_pvt.Update_CCIEntry(x_iface_rec,x_return_status);
599:
600: if (x_return_status <> fnd_api.g_ret_sts_success) then
601: raise fnd_api.g_exc_unexpected_error;
602: end if;
654: x_iface_rec.status_flag := null;
655: x_iface_rec.error_flag := null;
656: x_iface_rec.lock_flag := 1;
657:
658: mtl_cceoi_process_pvt.Insert_CCIEntry(x_iface_rec, x_return_status);
659:
660: if (x_return_status <> fnd_api.g_ret_sts_success) then
661: -- some exotic error or one of the non-null columns is missing
662: raise fnd_api.g_exc_unexpected_error;
802: mdebug('Process: Import_CountRequest');
803: END IF;
804:
805: --reset global variables
806: MTL_CCEOI_PROCESS_PVT.Reset_Global_Vars;
807:
808: --
809: L_interface_rec := p_interface_rec;
810:
914:
915: -- this is a really dangerous call since
916: -- some of the mandatory fields may be null in which case
917: -- insert will raise an exception
918: MTL_CCEOI_PROCESS_PVT.Insert_CCIEntry(
919: p_interface_rec => p_interface_rec,
920: x_return_status => x_return_status);
921: end if;
922:
919: p_interface_rec => p_interface_rec,
920: x_return_status => x_return_status);
921: end if;
922:
923: MTL_CCEOI_PROCESS_PVT.Insert_CCEOIError(
924: p_cc_entry_interface_id =>
925: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID,
926: p_error_column_name => 'ACTION_CODE'
927: , p_error_table_name => 'MTL_CC_ENTRIES_INTERFACE_ID'
944: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
945: -- if (mtl_cceoi_var_pvt.g_rec_in_system) then
946: -- it is unnecessary to mark it for deletion since
947: -- it will be deleted by purge if status_flag in (0,1)
948: /* MTL_CCEOI_PROCESS_PVT.Set_CCEOIFlags(
949: p_api_version => 0.9
950: , p_init_msg_list => FND_API.G_TRUE
951: , x_return_status => x_return_status
952: , x_msg_count => x_msg_count
970: -- record must have been exported in order
971: -- to be processed, unless it is just validation
972: -- an of unscheduled entry in which case
973: -- no cycle count entry id will exist
974: mtl_cceoi_process_pvt.Set_CCExport(
975: p_api_version => 0.9,
976: x_return_status => x_return_status,
977: x_msg_data => x_msg_data,
978: x_msg_count => x_msg_count,
1154: END IF;
1155:
1156: --No validation for performance reasons
1157: -- Except for header id and lpn id
1158: mtl_cceoi_process_pvt.Validate_CHeader
1159: (
1160: p_api_version => 0.9,
1161: x_msg_count => x_msg_count,
1162: x_msg_data => x_msg_data,