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_TASK_DISPATCH_LOV dependencies on FND_PROFILE

Line 8: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

4:
5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_Task_Dispatch_LOV';
8: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
9: g_gtin_code_length NUMBER := 14;
10:
11:
12: PROCEDURE mydebug(msg in varchar2)

Line 985: mydebug('In GET_LPN_ITEMS_LOV fnd_global.resp_id:' || fnd_global.resp_id || '...fnd_profile.value_wnps_INV_TRANS_REASON_SECURITY:'||fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'));

981: p_txn_type_id IN NUMBER ) IS
982:
983:
984: BEGIN
985: mydebug('In GET_LPN_ITEMS_LOV fnd_global.resp_id:' || fnd_global.resp_id || '...fnd_profile.value_wnps_INV_TRANS_REASON_SECURITY:'||fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'));
986: mydebug('In p_txn_type_id :' || p_txn_type_id);
987: OPEN x_reasons FOR
988: SELECT reason_name,description, reason_id
989: FROM mtl_transaction_reasons

Line 994: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

990: WHERE reason_type=p_reason_type
991: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
992: AND reason_name LIKE p_concat_segments || '%' -- Bug 14369838
993: -- nsrivast, invconv , transaction reason security
994: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
995: OR
996: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
997: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
998: AND

Line 1010: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'

1006: WHERE reason_type=p_reason_type
1007: AND nvl(DISABLE_DATE, SYSDATE+1) > SYSDATE
1008: AND reason_name LIKE p_concat_segments || '%'
1009: -- nsrivast, invconv , transaction reason security
1010: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1011: AND
1012: reason_id NOT IN (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs )
1013: ORDER BY reason_name;
1014:

Line 1125: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1121: p_Organization_Id IN NUMBER,
1122: p_concat_segments IN VARCHAR2)
1123: IS
1124:
1125: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1126: BEGIN
1127: IF (l_debug = 1) THEN
1128: mydebug('In get_device_lov');
1129: END IF;

Line 1155: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

1151: (x_devices OUT NOCOPY t_genref,
1152: p_Employee_Id IN NUMBER,
1153: p_concat_segments IN VARCHAR2)
1154: IS
1155: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1156: BEGIN
1157: IF (l_debug = 1) THEN
1158: mydebug('In get_device_lov');
1159: END IF;

Line 1571: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0); -- 14319939

1567: l_um_allowed NUMBER := 0;
1568: l_pl_allowed NUMBER := 0;
1569: l_context VARCHAR2(2);
1570: l_reason_count NUMBER := 0;
1571: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0); -- 14319939
1572: BEGIN
1573: -- bug 14319939 start
1574: IF (l_debug = 1) THEN
1575: mydebug('In get_reasons_lov( 5 para)');

Line 1626: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

1622: 'UM', l_um_allowed,
1623: 'PL', l_pl_allowed) = 1
1624: AND reason_name LIKE p_concat_segments || '%'
1625: -- nsrivast, invconv , transaction reason security
1626: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1627: OR
1628: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1629: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1630: AND

Line 1651: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'

1647: 'UM', l_um_allowed,
1648: 'PL', l_pl_allowed) = 1
1649: AND reason_name LIKE p_concat_segments || '%'
1650: -- nsrivast, invconv , transaction reason security
1651: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1652: AND reason_id NOT IN
1653: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs
1654: )
1655: ) -- Added for bug 14319939 end

Line 1683: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'

1679: 'UM', l_um_allowed,
1680: 'PL', l_pl_allowed) = 1
1681: AND reason_name LIKE p_concat_segments || '%'
1682: -- nsrivast, invconv , transaction reason security
1683: AND ( NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'N'
1684: OR
1685: reason_id IN (SELECT reason_id FROM mtl_trans_reason_security mtrs
1686: WHERE(( responsibility_id = fnd_global.resp_id OR NVL(responsibility_id, -1) = -1 )
1687: AND

Line 1710: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'

1706: 'UM', l_um_allowed,
1707: 'PL', l_pl_allowed) = 1
1708: AND reason_name LIKE p_concat_segments || '%'
1709: -- nsrivast, invconv , transaction reason security
1710: AND NVL ( fnd_profile.value_wnps('INV_TRANS_REASON_SECURITY'), 'N') = 'Y'
1711: AND reason_id NOT IN
1712: (SELECT mtrs.reason_id FROM mtl_trans_reason_security mtrs
1713: ) -- Bug 14319939 end
1714: ORDER BY reason_name;