1154: l_label_err_msg := NULL;
1155: l_debug := inv_label.l_debug;
1156:
1157: IF (
1158: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
1159: AND(inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)
1160: ) THEN
1161: l_patch_level := 1; --Patchset J and above
1162: ELSE
1155: l_debug := inv_label.l_debug;
1156:
1157: IF (
1158: (inv_rcv_common_apis.g_inv_patch_level >= inv_rcv_common_apis.g_patchset_j)
1159: AND(inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)
1160: ) THEN
1161: l_patch_level := 1; --Patchset J and above
1162: ELSE
1163: l_patch_level := 0; --Below Patchset J
1223: */
1224: IF (p_label_type_info.business_flow_code IN(1, 2, 3, 4)
1225: AND(l_patch_level = 1)) THEN
1226: TRACE('Patchset J code');
1227: l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
1228:
1229: OPEN rt_serial_cur;
1230:
1231: FETCH rt_serial_cur
1258: AND(p_label_type_info.business_flow_code IN(1, 2))
1259: AND(l_is_wms_org = TRUE)) THEN
1260: -- Receipt(1), Inspection(2) or Putaway Drop(4) and org is WMS enabled
1261: -- In an INV org there are no serial numbers at these points in the transaction.
1262: l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
1263:
1264: OPEN rti_serial_lpn_cur;
1265:
1266: FETCH rti_serial_lpn_cur
1296: AND(l_is_wms_org = FALSE))
1297: )
1298: ) THEN
1299: -- Delivery(3) and org is an INV org.
1300: l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
1301:
1302: OPEN rti_serial_msnt_cur;
1303:
1304: FETCH rti_serial_msnt_cur
3174: AND(p_label_type_info.business_flow_code IN(1, 2)
3175: AND(l_is_wms_org = TRUE))) THEN
3176: -- Receipt(1), Inspection(2) or Putaway Drop(4) and org is WMS enabled
3177: -- In an INV org there are no serial numbers at these points in the transaction.
3178: l_receipt_number := inv_rcv_common_apis.g_rcv_global_var.receipt_num;
3179:
3180: FETCH rti_serial_lpn_cur
3181: INTO l_inventory_item_id
3182: , l_organization_id