[Home] [Help]
611: if (x_iface_rec.cc_entry_interface_id is null) then
612:
613: SELECT MTL_CC_ENTRIES_INTERFACE_S1.nextval
614: INTO x_iface_rec.cc_entry_interface_id
615: FROM dual;
616:
617: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_INTERFACE_ID :=
618: x_iface_rec.cc_entry_interface_id;
619: MTL_CCEOI_VAR_PVT.G_REC_IN_SYSTEM := FALSE;
1277: FND_FILE.PUT_LINE(FND_FILE.LOG, x_msg_data);
1278: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1279: END IF;
1280:
1281: -- Check if Unschedualed Entries are allowed.
1282: SELECT unscheduled_count_entry
1283: INTO l_unsched_allowed
1284: FROM mtl_cycle_count_headers
1285: WHERE cycle_count_header_id = p_interface_rec.cycle_count_header_id;
1289: WHILE v_index IS NOT NULL LOOP
1290: --Check if record represents an item
1291: IF (l_expl_tbl(v_index).content_type = 1) THEN
1292: -- Check if item exist in cycle count entries table or in the cycle count items
1293: -- table if unschedualed entries are allowed.
1294: IF (l_debug = 1) THEN
1295: mdebug('org id: ' || TO_CHAR(l_expl_tbl(v_index).organization_id));
1296: mdebug('lpn id: ' || TO_CHAR(l_expl_tbl(v_index).parent_lpn_id));
1297: mdebug('item id: ' || TO_CHAR(l_expl_tbl(v_index).content_item_id));
1322: l_expl_tbl(v_index).content_item_id) )
1323: THEN
1324:
1325: IF l_in_cc_entries THEN
1326: -- Count List sequence number required for processing for schedualed entries
1327: SELECT count_list_sequence
1328: INTO l_item_rec.count_list_sequence
1329: FROM mtl_cycle_count_entries
1330: WHERE organization_id = l_expl_tbl(v_index).organization_id
1420:
1421: -- Create subinventory transfer information
1422: SELECT mtl_material_transactions_s.nextval
1423: INTO L_txn_header_id
1424: FROM dual;
1425:
1426: -- Do a subinventory transfer
1427: L_success_flag := mtl_cc_transact_pkg.cc_transact(
1428: org_id=> p_interface_rec.organization_id