APPS.WMS_EPC_PVT dependencies on MGD_IDCODE

Line 2303: pcode mgd_idcode;

2299: l_item_id NUMBER;
2300: l_rev VARCHAR2(3);
2301: l_bit_length NUMBER;
2302: l_components mgd_idcomponent_varray := mgd_idcomponent_varray(mgd_idcomponent('HEADER',NULL,null));
2303: pcode mgd_idcode;
2304:
2305: BEGIN
2306:
2307: G_PROFILE_GTIN := FND_PROFILE.value('INV:GTIN_CROSS_REFERENCE_TYPE');

Line 2526: IF l_epc_category_id <> mgd_idcode_utl.epc_encoding_category_id

2522: trace('Generating EPC now.............');
2523: END IF;
2524:
2525: --{{ See if the rule is custom or Un-Implemented Standard Rule }}
2526: IF l_epc_category_id <> mgd_idcode_utl.epc_encoding_category_id
2527: OR ( l_epc_category_id = mgd_idcode_utl.epc_encoding_category_id AND
2528: l_epc_rule_type NOT IN ('EPC_SGTIN_96','EPC_SSCC_96','EPC_SGTIN_64','EPC_SSCC_64','EPC_DOD_96','EPC_DOD_64') )
2529: --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')
2530: THEN

Line 2527: OR ( l_epc_category_id = mgd_idcode_utl.epc_encoding_category_id AND

2523: END IF;
2524:
2525: --{{ See if the rule is custom or Un-Implemented Standard Rule }}
2526: IF l_epc_category_id <> mgd_idcode_utl.epc_encoding_category_id
2527: OR ( l_epc_category_id = mgd_idcode_utl.epc_encoding_category_id AND
2528: l_epc_rule_type NOT IN ('EPC_SGTIN_96','EPC_SSCC_96','EPC_SGTIN_64','EPC_SSCC_64','EPC_DOD_96','EPC_DOD_64') )
2529: --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')
2530: THEN
2531:

Line 2601: trace('Before calling DB EPC category_name :'||mgd_idcode_utl.EPC_ENCODING_CATEGORY_NAME);

2597: END IF;
2598:
2599:
2600: IF l_debug = 1 THEN
2601: trace('Before calling DB EPC category_name :'||mgd_idcode_utl.EPC_ENCODING_CATEGORY_NAME);
2602: trace('partition_val :'||l_partition_value);
2603: END IF;
2604:
2605: BEGIN

Line 2606: pcode := mgd_idcode( category_name => mgd_idcode_utl.EPC_ENCODING_CATEGORY_NAME,

2602: trace('partition_val :'||l_partition_value);
2603: END IF;
2604:
2605: BEGIN
2606: pcode := mgd_idcode( category_name => mgd_idcode_utl.EPC_ENCODING_CATEGORY_NAME,
2607: category_agency => NULL,
2608: category_version => NULL,
2609: category_uri => NULL,
2610: encoding_type_name => l_epc_rule_type, --mgd_idcode_utl.EPC_SGTIN_96,

Line 2610: encoding_type_name => l_epc_rule_type, --mgd_idcode_utl.EPC_SGTIN_96,

2606: pcode := mgd_idcode( category_name => mgd_idcode_utl.EPC_ENCODING_CATEGORY_NAME,
2607: category_agency => NULL,
2608: category_version => NULL,
2609: category_uri => NULL,
2610: encoding_type_name => l_epc_rule_type, --mgd_idcode_utl.EPC_SGTIN_96,
2611: partition_val => l_partition_value,
2612: components => l_components);
2613:
2614: l_gen_epc := pcode.bit_encoding; --EPC in HEXA system

Line 2624: TRACE('After calling mgd_idcode: Inside exception');

2620: EXCEPTION
2621: WHEN OTHERS THEN
2622:
2623: IF l_debug = 1 THEN
2624: TRACE('After calling mgd_idcode: Inside exception');
2625: TRACE('ERROR CODE = ' || SQLCODE);
2626: TRACE('ERROR MESSAGE = ' || SQLERRM);
2627: END IF;
2628: