APPS.WMS_EPC_PVT dependencies on INV_CACHE

Line 1100: IF ( inv_cache.set_item_rec(

1096:
1097: --If p_uom is not primary UOM code then convert it to the primary UOM
1098: --AND primary_qty and
1099:
1100: IF ( inv_cache.set_item_rec(
1101: p_organization_id => p_org_id
1102: , p_item_id => p_item_id ) )
1103: THEN
1104: IF (l_debug = 1) THEN

Line 1105: trace('Got Item info puom='||inv_cache.item_rec.primary_uom_code);

1101: p_organization_id => p_org_id
1102: , p_item_id => p_item_id ) )
1103: THEN
1104: IF (l_debug = 1) THEN
1105: trace('Got Item info puom='||inv_cache.item_rec.primary_uom_code);
1106:
1107: END IF;
1108: ELSE
1109: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');

Line 1115: IF (p_uom_code <> inv_cache.item_rec.primary_uom_code) THEN

1111: RAISE fnd_api.g_exc_error;
1112: END IF;
1113:
1114:
1115: IF (p_uom_code <> inv_cache.item_rec.primary_uom_code) THEN
1116: l_pri_qty :=
1117: inv_convert.inv_um_convert(item_id => p_item_id
1118: ,precision => 5
1119: ,from_quantity => 1 --p_qty, get the prim qty FOR UOM

Line 1121: ,to_unit => inv_cache.item_rec.primary_uom_code

1117: inv_convert.inv_um_convert(item_id => p_item_id
1118: ,precision => 5
1119: ,from_quantity => 1 --p_qty, get the prim qty FOR UOM
1120: ,from_unit => p_uom_code
1121: ,to_unit => inv_cache.item_rec.primary_uom_code
1122: ,from_name => NULL
1123: ,to_name => NULL);
1124: ELSE
1125:

Line 1132: trace('l_primary_uom_code :'||inv_cache.item_rec.primary_uom_code);

1128: END IF;
1129:
1130: IF l_debug = 1 then
1131: trace('for each GTIN l_pri_qty :'||l_pri_qty);
1132: trace('l_primary_uom_code :'||inv_cache.item_rec.primary_uom_code);
1133: trace('p_rev :'||p_rev);
1134: END IF;
1135:
1136:

Line 1203: IF ( inv_cache.set_item_rec(

1199: x_return_status := fnd_api.g_ret_sts_success;
1200:
1201:
1202: --GET THE PRIMARY UOM code FOR SERIAL ITEM
1203: IF ( inv_cache.set_item_rec(
1204: p_organization_id => p_org_id
1205: , p_item_id => p_item_id ) )
1206: THEN
1207: IF (l_debug = 1) THEN

Line 1208: trace('Got Item info puom='||inv_cache.item_rec.primary_uom_code);

1204: p_organization_id => p_org_id
1205: , p_item_id => p_item_id ) )
1206: THEN
1207: IF (l_debug = 1) THEN
1208: trace('Got Item info puom='||inv_cache.item_rec.primary_uom_code);
1209: END IF;
1210: ELSE
1211: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ITEM');
1212: fnd_msg_pub.ADD;

Line 1226: p_primary_uom => inv_cache.item_rec.primary_uom_code,

1222: get_gtin_and_gserial(p_org_id => p_org_id,
1223: p_item_id => p_item_id,
1224: p_total_qty => 1, --Always = 1 since primary UOM
1225: p_rev => p_rev,
1226: p_primary_uom => inv_cache.item_rec.primary_uom_code,
1227: x_gtin => x_gtin,
1228: x_gtin_serial => x_gtin_serial,
1229: x_return_status => x_return_status);
1230:

Line 2326: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN

2322: END IF;
2323:
2324:
2325: --{{get needed information from mtl_parameters setup for EPC generation }}
2326: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
2327: IF (l_debug = 1) THEN
2328: trace(p_org_id || 'is an invalid organization id');
2329: END IF;
2330: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');

Line 2335: l_company_prefix := inv_cache.org_rec.company_prefix;

2331: fnd_msg_pub.ADD;
2332: RAISE fnd_api.g_exc_error;
2333: END IF;
2334:
2335: l_company_prefix := inv_cache.org_rec.company_prefix;
2336: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2337:
2338:
2339: IF l_debug = 1 THEN

Line 2336: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;

2332: RAISE fnd_api.g_exc_error;
2333: END IF;
2334:
2335: l_company_prefix := inv_cache.org_rec.company_prefix;
2336: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2337:
2338:
2339: IF l_debug = 1 THEN
2340: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));

Line 2340: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));

2336: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2337:
2338:
2339: IF l_debug = 1 THEN
2340: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
2341: trace('l_company_prefix :'||l_company_prefix);
2342: trace('l_company_prefix_index :'||l_company_prefix_index);
2343: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
2344: END IF;

Line 2343: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);

2339: IF l_debug = 1 THEN
2340: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
2341: trace('l_company_prefix :'||l_company_prefix);
2342: trace('l_company_prefix_index :'||l_company_prefix_index);
2343: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
2344: END IF;
2345:
2346: --{{get needed information from label formats setup for the format_id}}
2347: SELECT epc_rule_type,filter_value,generate_epc,epc_category_id

Line 2361: IF Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N') = 'Y' THEN

2357: trace('l_epc_category_id :'||l_epc_category_id);
2358: END IF;
2359:
2360: --Check if EPC is enabled
2361: IF Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N') = 'Y' THEN
2362:
2363: --Get required information about the current transaction
2364: SELECT lpn_id,serial_number,inventory_item_id,revision
2365: INTO l_lpn_id,l_serial_number,l_item_id, l_rev

Line 2569: p_cage_code => inv_cache.org_rec.commercial_govt_entity_number, --FOR p_label_type_id = 2

2565: p_business_flow_code => p_business_flow_code,
2566: p_label_type_id => P_label_type_id,
2567: p_epc_rule_type => l_epc_rule_type,
2568: p_filter_value => l_filter_value,
2569: p_cage_code => inv_cache.org_rec.commercial_govt_entity_number, --FOR p_label_type_id = 2
2570: p_partition_value => l_partition_value,
2571: x_gtin => l_gtin,
2572: x_sscc => l_sscc,
2573: x_gtin_serial => l_gtin_seriaL,