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