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 STANDARD

Line 135: -- Evaluate whether the LPN is standard

131:
132:
133: --This API needs to move in the rules Engine code
134: --Purpose
135: -- Evaluate whether the LPN is standard
136: ---Standard : Contains single Item
137: ---Non-Standard : Contains multiple Items
138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS
139:

Line 136: ---Standard : Contains single Item

132:
133: --This API needs to move in the rules Engine code
134: --Purpose
135: -- Evaluate whether the LPN is standard
136: ---Standard : Contains single Item
137: ---Non-Standard : Contains multiple Items
138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS
139:
140: l_is_standard NUMBER;

Line 137: ---Non-Standard : Contains multiple Items

133: --This API needs to move in the rules Engine code
134: --Purpose
135: -- Evaluate whether the LPN is standard
136: ---Standard : Contains single Item
137: ---Non-Standard : Contains multiple Items
138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS
139:
140: l_is_standard NUMBER;
141: l_item_cnt NUMBER;

Line 138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS

134: --Purpose
135: -- Evaluate whether the LPN is standard
136: ---Standard : Contains single Item
137: ---Non-Standard : Contains multiple Items
138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS
139:
140: l_is_standard NUMBER;
141: l_item_cnt NUMBER;
142: l_parent_lpn_id NUMBER;

Line 140: l_is_standard NUMBER;

136: ---Standard : Contains single Item
137: ---Non-Standard : Contains multiple Items
138: FUNCTION is_lpn_standard(p_lpn_id NUMBER) RETURN NUMBER IS
139:
140: l_is_standard NUMBER;
141: l_item_cnt NUMBER;
142: l_parent_lpn_id NUMBER;
143: l_outermost_lpn_id NUMBER;
144: l_lpn_item_id NUMBER;

Line 176: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard

172:
173: BEGIN
174:
175: SELECT DISTINCT wlc.inventory_item_id,wlc.uom_code,wlc.revision,1
176: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard
177: FROM wms_lpn_contents wlc, wms_license_plate_numbers wlpn
178: WHERE wlpn.outermost_lpn_id = p_lpn_id
179: AND wlpn.lpn_id = wlc.parent_lpn_id
180: AND wlc.organization_id = wlpn.organization_id;

Line 182: -- it must be Non-Standard here if there are multiple records for item,

178: WHERE wlpn.outermost_lpn_id = p_lpn_id
179: AND wlpn.lpn_id = wlc.parent_lpn_id
180: AND wlc.organization_id = wlpn.organization_id;
181:
182: -- it must be Non-Standard here if there are multiple records for item,
183: --uom_code,revision combination
184:
185:
186: EXCEPTION

Line 189: --NON-STANDARD

185:
186: EXCEPTION
187: WHEN too_many_rows THEN
188: --MUITPLE ITEMS OR IN DIFFERETN UOMS OR Different Revision
189: --NON-STANDARD
190: l_is_standard := 0;
191:
192: WHEN no_data_found THEN
193: --Error condition

Line 190: l_is_standard := 0;

186: EXCEPTION
187: WHEN too_many_rows THEN
188: --MUITPLE ITEMS OR IN DIFFERETN UOMS OR Different Revision
189: --NON-STANDARD
190: l_is_standard := 0;
191:
192: WHEN no_data_found THEN
193: --Error condition
194: l_is_standard := -1;

Line 194: l_is_standard := -1;

190: l_is_standard := 0;
191:
192: WHEN no_data_found THEN
193: --Error condition
194: l_is_standard := -1;
195:
196: WHEN OTHERS THEN
197: l_is_standard := -1;
198: IF l_debug = 1 then

Line 197: l_is_standard := -1;

193: --Error condition
194: l_is_standard := -1;
195:
196: WHEN OTHERS THEN
197: l_is_standard := -1;
198: IF l_debug = 1 then
199: trace('ERROR CODE = ' || SQLCODE);
200: trace('ERROR MESSAGE = ' || SQLERRM);
201: END IF;

Line 242: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard

238: --epc generation AND rfid tagging will be done only AT pallet and
239: --CASE label. so CASE might have nested lpns within it.
240:
241: select wlc.inventory_item_id,wlc.uom_code,wlc.revision,1
242: INTO l_lpn_item_id,l_uom_code,l_rev,l_is_standard
243: from WMS_LPN_CONTENTS WLC
244: where WLC.parent_lpn_id in (
245: select wlpn.lpn_id
246: from wms_license_plate_numbers wlpn

Line 259: --NON-STANDARD

255:
256: EXCEPTION
257: WHEN too_many_rows THEN
258: --MUITPLE ITEMS
259: --NON-STANDARD
260: l_is_standard := 0;
261:
262: WHEN no_data_found THEN
263: --Error condition

Line 260: l_is_standard := 0;

256: EXCEPTION
257: WHEN too_many_rows THEN
258: --MUITPLE ITEMS
259: --NON-STANDARD
260: l_is_standard := 0;
261:
262: WHEN no_data_found THEN
263: --Error condition
264: l_is_standard := -1;

Line 264: l_is_standard := -1;

260: l_is_standard := 0;
261:
262: WHEN no_data_found THEN
263: --Error condition
264: l_is_standard := -1;
265:
266: WHEN OTHERS THEN
267: l_is_standard := -1;
268: IF l_debug = 1 then

Line 267: l_is_standard := -1;

263: --Error condition
264: l_is_standard := -1;
265:
266: WHEN OTHERS THEN
267: l_is_standard := -1;
268: IF l_debug = 1 then
269: trace('ERROR CODE = ' || SQLCODE);
270: trace('ERROR MESSAGE = ' || SQLERRM);
271: END IF;

Line 280: RETURN l_is_standard;

276: RETURN -1;
277:
278: END IF;
279:
280: RETURN l_is_standard;
281:
282:
283: END is_lpn_standard;
284:

Line 283: END is_lpn_standard;

279:
280: RETURN l_is_standard;
281:
282:
283: END is_lpn_standard;
284:
285:
286: -- p_org_id, p_item_id ,p_uom , p_rev_id
287: -- are needed in this function because

Line 1772: generation using diferent standard (X means acceptable)

1768:
1769: ----------------------------------------
1770: /*
1771: Following table shows Valid set up in Label Format Form for EPC
1772: generation using diferent standard (X means acceptable)
1773:
1774: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial
1775: SGTIN_96/64 X X X
1776: SSCC_96/64 X - -

Line 1774: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial

1770: /*
1771: Following table shows Valid set up in Label Format Form for EPC
1772: generation using diferent standard (X means acceptable)
1773:
1774: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial
1775: SGTIN_96/64 X X X
1776: SSCC_96/64 X - -
1777: DoD_96/64 - - X
1778: */

Line 2455: --{{ See if the rule is custom or Un-Implemented Standard Rule }}

2451: IF l_debug = 1 THEN
2452: trace('Generating EPC now.............');
2453: END IF;
2454:
2455: --{{ See if the rule is custom or Un-Implemented Standard Rule }}
2456: IF l_epc_category_id <> DBMS_MGD_ID_UTL.GET_CATEGORY_ID('EPC',NULL)
2457: OR ( l_epc_category_id = DBMS_MGD_ID_UTL.GET_CATEGORY_ID('EPC',NULL) AND
2458: l_epc_rule_type NOT IN ('SGTIN-96','SSCC-96','SGTIN-64','SSCC-64','USDOD-96','USDOD-64') )
2459: --means in ('GIAI-96','GRAI-96','SGLN-96','GID-96','GIAI-64','GRAI-64','SGLN-64','GID-64')

Line 2475: --{{ get standard EPC generated for standard rule}}

2471: x_epc => l_epc);
2472:
2473: ELSIF l_epc_rule_type IN
2474: ('SGTIN-96','SSCC-96','SGTIN-64','SSCC-64','USDOD-96','USDOD-64') THEN
2475: --{{ get standard EPC generated for standard rule}}
2476:
2477: --{{ Check to see if regenerate flag is ON..only then generate epc }}
2478: IF l_regenerate_flag = 'Y' OR (l_epc is NULL AND
2479: Nvl(l_regenerate_flag,'N') = 'N' ) THEN

Line 3087: --PARTITION value (specified by EPC global standard)

3083:
3084: END uptodate_wms_epc;
3085:
3086: --Given EPC_rule_type and company_prefix, calculates the pre-defined
3087: --PARTITION value (specified by EPC global standard)
3088: --FUNCTION applicable to DB versions below RDBMS12c
3089: FUNCTION get_PARTITION_value(p_epc_rule_type IN VARCHAR2,
3090: P_company_prefix IN VARCHAR2) RETURN NUMBER
3091: IS

Line 3128: l_partition := 0; --partition is not needed for this STANDARD EPC TYPE generation

3124: END IF;
3125:
3126: ELSE
3127:
3128: l_partition := 0; --partition is not needed for this STANDARD EPC TYPE generation
3129:
3130: END IF;
3131:
3132: RETURN l_partition;

Line 3195: generation using diferent standard (X means acceptable)

3191:
3192: ----------------------------------------
3193: /*
3194: Following table shows Valid set up in Label Format Form for EPC
3195: generation using diferent standard (X means acceptable)
3196:
3197: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial
3198: SGTIN_96/64 X X X
3199: SSCC_96/64 X - -

Line 3197: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial

3193: /*
3194: Following table shows Valid set up in Label Format Form for EPC
3195: generation using diferent standard (X means acceptable)
3196:
3197: Standard\LabelType LPN/LPNContent/LPNSummary Material Serial
3198: SGTIN_96/64 X X X
3199: SSCC_96/64 X - -
3200: DoD_96/64 - - X
3201: */

Line 4000: --{{ See if the rule is custom or Un-Implemented Standard Rule }}

3996: IF l_debug = 1 THEN
3997: trace('Generating EPC now.............');
3998: END IF;
3999:
4000: --{{ See if the rule is custom or Un-Implemented Standard Rule }}
4001: IF l_epc_category_id <> mgd_idcode_utl.epc_encoding_category_id
4002: OR ( l_epc_category_id = mgd_idcode_utl.epc_encoding_category_id AND
4003: l_epc_rule_type NOT IN ('EPC_SGTIN_96','EPC_SSCC_96','EPC_SGTIN_64','EPC_SSCC_64','EPC_DOD_96','EPC_DOD_64') )
4004: --means in ('EPC_GIAI_96','EPC_GRAI_96','EPC_SGLN_96','EPC_GID_96','EPC_GIAI_64','EPC_GRAI_64','EPC_SGLN_64','EPC_GID_64')

Line 4020: --{{ get standard EPC generated for standard rule}}

4016: x_epc => l_epc);
4017:
4018: ELSIF l_epc_rule_type IN
4019: ('EPC_SGTIN_96','EPC_SSCC_96','EPC_SGTIN_64','EPC_SSCC_64','EPC_DOD_96','EPC_DOD_64') THEN
4020: --{{ get standard EPC generated for standard rule}}
4021:
4022: --{{ Check to see if regenerate flag is ON..only then generate epc }}
4023: IF l_regenerate_flag = 'Y' OR (l_epc is NULL AND
4024: Nvl(l_regenerate_flag,'N') = 'N' ) THEN