DBA Data[Home] [Help]

APPS.IEX_STRY_UTL_PUB dependencies on FND_PROFILE

Line 18: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));

14: /**Name AddInvalidArgMsg
15: **Appends to a message the api name, parameter name and parameter Value
16: */
17:
18: --PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
19: PG_DEBUG NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
20:
21: PROCEDURE AddInvalidArgMsg
22: ( p_api_name IN VARCHAR2,

Line 1011: l_jtf_time_uom_class := fnd_profile.value_specific(NAME => 'JTF_TIME_UOM_CLASS',APPLICATION_ID =>695);

1007: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1008: iex_debug_pub.logmessage ('get_date before get conversion rate ');
1009: END IF;
1010: --Start of bug 7434190 22-Jan-2009 barathsr
1011: l_jtf_time_uom_class := fnd_profile.value_specific(NAME => 'JTF_TIME_UOM_CLASS',APPLICATION_ID =>695);
1012: select conversion_rate into l_conversion from mtl_uom_conversions
1013: --Use the profile 'unit of measure class' value if it is set at application level, else use it from site level
1014: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */
1015: where UOM_code = l_UOM and uom_class = l_jtf_time_uom_class

Line 1014: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */

1010: --Start of bug 7434190 22-Jan-2009 barathsr
1011: l_jtf_time_uom_class := fnd_profile.value_specific(NAME => 'JTF_TIME_UOM_CLASS',APPLICATION_ID =>695);
1012: select conversion_rate into l_conversion from mtl_uom_conversions
1013: --Use the profile 'unit of measure class' value if it is set at application level, else use it from site level
1014: /* where UOM_code = l_UOM and uom_class = (select fnd_profile.value('JTF_TIME_UOM_CLASS') from dual) */
1015: where UOM_code = l_UOM and uom_class = l_jtf_time_uom_class
1016: --End of Bug 7434190 22-Jan-2009 barathsr
1017: and inventory_item_id = 0;
1018: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN