eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2296: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN

2292:
2293: DBMS_MGD_ID_UTL.refresh_category(DBMS_MGD_ID_UTL.get_category_id('EPC', NULL));
2294:
2295: --{{get needed information from mtl_parameters setup for EPC generation }}
2296: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
2297: IF (l_debug = 1) THEN
2298: trace(p_org_id || 'is an invalid organization id');
2299: END IF;
2300: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');

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

2301: fnd_msg_pub.ADD;
2302: RAISE fnd_api.g_exc_error;
2303: END IF;
2304:
2305: l_company_prefix := inv_cache.org_rec.company_prefix;
2306: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2307:
2308:
2309: IF l_debug = 1 THEN

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

2302: RAISE fnd_api.g_exc_error;
2303: END IF;
2304:
2305: l_company_prefix := inv_cache.org_rec.company_prefix;
2306: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2307:
2308:
2309: IF l_debug = 1 THEN
2310: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));

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

2306: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
2307:
2308:
2309: IF l_debug = 1 THEN
2310: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
2311: trace('l_company_prefix :'||l_company_prefix);
2312: trace('l_company_prefix_index :'||l_company_prefix_index);
2313: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
2314: END IF;

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

2309: IF l_debug = 1 THEN
2310: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
2311: trace('l_company_prefix :'||l_company_prefix);
2312: trace('l_company_prefix_index :'||l_company_prefix_index);
2313: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
2314: END IF;
2315:
2316: --{{get needed information from label formats setup for the format_id}}
2317: SELECT epc_rule_type,filter_value,generate_epc,epc_category_id

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

2327: trace('l_epc_category_id :'||l_epc_category_id);
2328: END IF;
2329:
2330: --Check if EPC is enabled
2331: IF Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N') = 'Y' THEN
2332:
2333: --Get required information about the current transaction
2334: SELECT lpn_id,serial_number,inventory_item_id,revision
2335: INTO l_lpn_id,l_serial_number,l_item_id, l_rev

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

2495: p_business_flow_code => p_business_flow_code,
2496: p_label_type_id => P_label_type_id,
2497: p_epc_rule_type => l_epc_rule_type,
2498: p_filter_value => l_filter_value,
2499: p_cage_code => inv_cache.org_rec.commercial_govt_entity_number, --FOR p_label_type_id = 2
2500: x_gtin => l_gtin,
2501: x_sscc => l_sscc,
2502: x_gtin_serial => l_gtin_seriaL,
2503: x_components => l_components,

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

3797: END IF;
3798:
3799:
3800: --{{get needed information from mtl_parameters setup for EPC generation }}
3801: IF ( NOT Inv_Cache.set_org_rec( p_organization_id => p_org_id ))THEN
3802: IF (l_debug = 1) THEN
3803: trace(p_org_id || 'is an invalid organization id');
3804: END IF;
3805: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_ORG');

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

3806: fnd_msg_pub.ADD;
3807: RAISE fnd_api.g_exc_error;
3808: END IF;
3809:
3810: l_company_prefix := inv_cache.org_rec.company_prefix;
3811: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
3812:
3813:
3814: IF l_debug = 1 THEN

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

3807: RAISE fnd_api.g_exc_error;
3808: END IF;
3809:
3810: l_company_prefix := inv_cache.org_rec.company_prefix;
3811: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
3812:
3813:
3814: IF l_debug = 1 THEN
3815: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));

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

3811: l_company_prefix_index := inv_cache.org_rec.company_prefix_index;
3812:
3813:
3814: IF l_debug = 1 THEN
3815: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
3816: trace('l_company_prefix :'||l_company_prefix);
3817: trace('l_company_prefix_index :'||l_company_prefix_index);
3818: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
3819: END IF;

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

3814: IF l_debug = 1 THEN
3815: trace('epc_enabled :'||Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N'));
3816: trace('l_company_prefix :'||l_company_prefix);
3817: trace('l_company_prefix_index :'||l_company_prefix_index);
3818: trace('cage_code :'||inv_cache.org_rec.commercial_govt_entity_number);
3819: END IF;
3820:
3821: --{{get needed information from label formats setup for the format_id}}
3822: SELECT epc_rule_type,filter_value,generate_epc,epc_category_id

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

3832: trace('l_epc_category_id :'||l_epc_category_id);
3833: END IF;
3834:
3835: --Check if EPC is enabled
3836: IF Nvl(inv_cache.org_rec.epc_generation_enabled_flag,'N') = 'Y' THEN
3837:
3838: --Get required information about the current transaction
3839: SELECT lpn_id,serial_number,inventory_item_id,revision
3840: INTO l_lpn_id,l_serial_number,l_item_id, l_rev

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

4040: p_business_flow_code => p_business_flow_code,
4041: p_label_type_id => P_label_type_id,
4042: p_epc_rule_type => l_epc_rule_type,
4043: p_filter_value => l_filter_value,
4044: p_cage_code => inv_cache.org_rec.commercial_govt_entity_number, --FOR p_label_type_id = 2
4045: p_partition_value => l_partition_value,
4046: x_gtin => l_gtin,
4047: x_sscc => l_sscc,
4048: x_gtin_serial => l_gtin_seriaL,