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.FV_IPAC_DISBURSEMENT_PKG dependencies on MTL_UNITS_OF_MEASURE_VL

Line 1988: --* : table mtl_units_of_measure_vl *--

1984: --****************************************************************************************--
1985: --* Name : resolve_uom *--
1986: --* Type : Procedure *--
1987: --* Purpose : This procedure will try to resolve the Unit of Measure against the *--
1988: --* : table mtl_units_of_measure_vl *--
1989: --* Parameters : p_ipac_import_id IN The ipac import id used to insert errors *--
1990: --* : p_uom_code IN The file UOM code *--
1991: --* : p_unit_of_measure IN OUT Resolved UOM code *--
1992: --* : p_record_status OUT Record Status *--

Line 2008: --* Tables Used : mtl_units_of_measure_vl VIEW, SELECT *--

2004: --* Called from : process_data *--
2005: --* Calls : insert_error *--
2006: --* : fv_utility.debug_mesg *--
2007: --* : fv_utility.log_mesg *--
2008: --* Tables Used : mtl_units_of_measure_vl VIEW, SELECT *--
2009: --* Logic : 1. Check to see if the input UOM code is uom_code from table *--
2010: --* : mtl_units_of_measure_vl *--
2011: --* : 2. If so return the unit of measure from the table in resolved UOM *--
2012: --* : code and return *--

Line 2010: --* : mtl_units_of_measure_vl *--

2006: --* : fv_utility.debug_mesg *--
2007: --* : fv_utility.log_mesg *--
2008: --* Tables Used : mtl_units_of_measure_vl VIEW, SELECT *--
2009: --* Logic : 1. Check to see if the input UOM code is uom_code from table *--
2010: --* : mtl_units_of_measure_vl *--
2011: --* : 2. If so return the unit of measure from the table in resolved UOM *--
2012: --* : code and return *--
2013: --* : 3. Check to see if the input UOM code is unit_of_measure from table *--
2014: --* : mtl_units_of_measure_vl *--

Line 2014: --* : mtl_units_of_measure_vl *--

2010: --* : mtl_units_of_measure_vl *--
2011: --* : 2. If so return the unit of measure from the table in resolved UOM *--
2012: --* : code and return *--
2013: --* : 3. Check to see if the input UOM code is unit_of_measure from table *--
2014: --* : mtl_units_of_measure_vl *--
2015: --* : 4. If so return the unit of measure from the table in resolved UOM *--
2016: --* : code and return *--
2017: --* : 5. If the UOM could not be resolved insert an error *--
2018: --****************************************************************************************--

Line 2022: p_uom_code IN mtl_units_of_measure_vl.uom_code%TYPE,

2018: --****************************************************************************************--
2019: PROCEDURE resolve_uom
2020: (
2021: p_ipac_import_id IN fv_ipac_import.ipac_import_id%TYPE,
2022: p_uom_code IN mtl_units_of_measure_vl.uom_code%TYPE,
2023: p_unit_of_measure IN OUT NOCOPY mtl_units_of_measure_vl.unit_of_measure%TYPE,
2024: p_record_status OUT NOCOPY fv_ipac_import.record_status%TYPE,
2025: p_error_code OUT NOCOPY NUMBER,
2026: p_error_desc OUT NOCOPY VARCHAR2

Line 2023: p_unit_of_measure IN OUT NOCOPY mtl_units_of_measure_vl.unit_of_measure%TYPE,

2019: PROCEDURE resolve_uom
2020: (
2021: p_ipac_import_id IN fv_ipac_import.ipac_import_id%TYPE,
2022: p_uom_code IN mtl_units_of_measure_vl.uom_code%TYPE,
2023: p_unit_of_measure IN OUT NOCOPY mtl_units_of_measure_vl.unit_of_measure%TYPE,
2024: p_record_status OUT NOCOPY fv_ipac_import.record_status%TYPE,
2025: p_error_code OUT NOCOPY NUMBER,
2026: p_error_desc OUT NOCOPY VARCHAR2
2027: )

Line 2031: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;

2027: )
2028: IS
2029: l_module_name VARCHAR2(200);
2030: l_location VARCHAR2(200);
2031: l_unit_of_measure mtl_units_of_measure_vl.unit_of_measure%TYPE;
2032: BEGIN
2033: l_module_name := g_module_name || 'resolve_uom';
2034: p_error_code := g_SUCCESS;
2035: l_unit_of_measure := NULL;

Line 2045: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from mtl_units_of_measure_vl1');

2041: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'p_unit_of_measure = '||p_unit_of_measure);
2042: END IF;
2043:
2044: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2045: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from mtl_units_of_measure_vl1');
2046: END IF;
2047:
2048: BEGIN
2049: SELECT unit_of_measure

Line 2051: FROM mtl_units_of_measure_vl

2047:
2048: BEGIN
2049: SELECT unit_of_measure
2050: INTO l_unit_of_measure
2051: FROM mtl_units_of_measure_vl
2052: WHERE uom_code = p_uom_code;
2053: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2054: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'l_unit_of_measure='||l_unit_of_measure);
2055: END IF;

Line 2065: l_location := l_module_name||'.select_mtl_units_of_measure_vl1';

2061: l_unit_of_measure := NULL;
2062: WHEN OTHERS THEN
2063: p_error_code := g_FAILURE;
2064: p_error_desc := SQLERRM;
2065: l_location := l_module_name||'.select_mtl_units_of_measure_vl1';
2066: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2067: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2068: END;
2069:

Line 2075: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from mtl_units_of_measure_vl1');

2071: IF (l_unit_of_measure IS NOT NULL) THEN
2072: p_unit_of_measure := l_unit_of_measure;
2073: ELSE
2074: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
2075: fv_utility.debug_mesg(fnd_log.level_statement, l_module_name,'Selecting from mtl_units_of_measure_vl1');
2076: END IF;
2077: BEGIN
2078: SELECT unit_of_measure
2079: INTO l_unit_of_measure

Line 2080: FROM mtl_units_of_measure_vl

2076: END IF;
2077: BEGIN
2078: SELECT unit_of_measure
2079: INTO l_unit_of_measure
2080: FROM mtl_units_of_measure_vl
2081: WHERE unit_of_measure = p_unit_of_measure;
2082: EXCEPTION
2083: WHEN NO_DATA_FOUND THEN
2084: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN

Line 2091: l_location := l_module_name||'.select_mtl_units_of_measure_vl2';

2087: l_unit_of_measure := NULL;
2088: WHEN OTHERS THEN
2089: p_error_code := g_FAILURE;
2090: p_error_desc := SQLERRM;
2091: l_location := l_module_name||'.select_mtl_units_of_measure_vl2';
2092: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,l_location) ;
2093: fv_utility.log_mesg(fnd_log.level_unexpected, l_location,p_error_desc) ;
2094: END;
2095: END IF;