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.MTL_INV_VALIDATE_GRP dependencies on FND_PROFILE

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

6:
7:
8: procedure mdebug(msg in varchar2)
9: is
10: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
11: begin
12: --dbms_output.put_line(msg);
13: null;
14: --inv_debug.message(msg);

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

91: and exception_set_id = p_exception_set_id
92: and next_date = trunc(p_start_date));
93:
94:
95: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
96: begin
97: -- Standard start of API savepoint
98: SAVEPOINT Get_Offset_Date;
99: --

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

175: -- Derive Count Uom
176: PROCEDURE Get_CountUom(
177: p_uom_code IN VARCHAR2 )
178: IS
179: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
180: BEGIN
181: -- Start OF comments
182: -- API name :Get_CountUom
183: -- TYPE : Private

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

206: -- Dervies Item and SKU information from the given Count List Sequence
207: PROCEDURE Get_Item_SKU(
208: p_cycle_count_entry_rec IN MTL_CYCLE_COUNT_ENTRIES%ROWTYPE )
209: IS
210: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
211: BEGIN
212: -- Start OF comments
213: -- API name :Get_Item_SKU
214: -- TYPE : Private

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

270: -- Get the STOCK_LOCATOR_CONTROL_CODE from the given ORG_ID
271: PROCEDURE Get_StockLocatorControlCode(
272: p_organization_id IN NUMBER )
273: IS
274: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
275: BEGIN
276: -- Start OF comments
277: -- API name : Get_StockLocatorControlCode
278: -- TYPE : Private

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

319: x_msg_count OUT NOCOPY NUMBER ,
320: x_msg_data OUT NOCOPY VARCHAR2 ,
321: p_adjustaccount_rec IN MTL_CCEOI_VAR_PVT.ADJUSTACCOUNT_REC_TYPE )
322: IS
323: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
324: BEGIN
325: -- Start OF comments
326: -- API name : Validate_AdjustAccount
327: -- TYPE : Private

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

587: x_msg_data OUT NOCOPY VARCHAR2 ,
588: x_errorcode OUT NOCOPY NUMBER ,
589: p_count_date IN DATE )
590: IS
591: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
592: BEGIN
593: -- Start OF comments
594: -- API name : Validate_CountDate
595: -- TYPE : Private

Line 682: IF(fnd_profile.defined('TRANSACTION_DATE')) THEN

678: RAISE FND_API.G_EXC_ERROR;
679: END IF;
680: --
681: -- within a accounting period
682: IF(fnd_profile.defined('TRANSACTION_DATE')) THEN
683: L_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
684: /* Profile value of:
685: 1 = Any open period
686: 2 = No past date

Line 683: L_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));

679: END IF;
680: --
681: -- within a accounting period
682: IF(fnd_profile.defined('TRANSACTION_DATE')) THEN
683: L_profile_value := TO_NUMBER(fnd_profile.value('TRANSACTION_DATE'));
684: /* Profile value of:
685: 1 = Any open period
686: 2 = No past date
687: 3 = No past periods

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

795: x_errorcode OUT NOCOPY VARCHAR2 ,
796: p_cycle_count_header_id IN NUMBER DEFAULT NULL,
797: p_cycle_count_header_name IN VARCHAR2 DEFAULT NULL)
798: IS
799: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
800: BEGIN
801: -- Start OF comments
802: -- API name : Validate_CountHeader
803: -- TYPE : Private

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

1001: p_cycle_count_entry_id IN number ,
1002: p_count_list_sequence IN number ,
1003: p_organization_id IN NUMBER )
1004: IS
1005: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1006: BEGIN
1007: -- Start OF comments
1008: -- API name : Validate_CountListSequence
1009: -- TYPE : Private

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

1213: x_msg_data OUT NOCOPY VARCHAR2 ,
1214: x_errorcode OUT NOCOPY NUMBER ,
1215: p_count_quantity IN NUMBER )
1216: IS
1217: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1218: BEGIN
1219: -- Start OF comments
1220: -- API name : Validate_CountQuantity
1221: -- TYPE : Private

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

1390: p_revision IN VARCHAR2 ,
1391: p_serial_number IN VARCHAR2 ,
1392: p_locator_control IN NUMBER ) -- XXX not used inside!
1393: IS
1394: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1395: BEGIN
1396: -- Start OF comments
1397: -- API name : Validate_Ctrol
1398: -- TYPE : Private

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

1715: p_count_unit_of_measure IN VARCHAR2 DEFAULT NULL,
1716: p_organization_id IN NUMBER ,
1717: p_inventory_item_id IN NUMBER )
1718: IS
1719: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1720: BEGIN
1721: -- Start OF comments
1722: -- API name : Validate_CountUOM
1723: -- TYPE : Private

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

1912: p_inventory_item_rec IN MTL_CCEOI_VAR_PVT.INV_ITEM_REC_TYPE ,
1913: p_organization_id IN NUMBER ,
1914: p_cycle_count_header_id IN NUMBER DEFAULT NULL)
1915: IS
1916: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1917: BEGIN
1918: -- Start OF comments
1919: -- API name : Validate_Item
1920: -- TYPE : Private

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

2166: p_control_level IN NUMBER ,
2167: p_restrict_control IN NUMBER,
2168: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
2169: IS
2170: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2171: BEGIN
2172: -- Start OF comments
2173: -- API name : Validate_Locator
2174: -- TYPE : Private

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

2434: x_errorcode OUT NOCOPY NUMBER ,
2435: p_primary_uom_quantity IN NUMBER ,
2436: p_primary_uom_code IN VARCHAR2 )
2437: IS
2438: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2439: BEGIN
2440: -- Start OF comments
2441: -- API name : Validate_PrimaryUomQuantity
2442: -- TYPE : Private

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

2591: p_organization_id IN NUMBER,
2592: p_orientation_code IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_ORIENTATION_CODE,
2593: p_cycle_count_header_id IN NUMBER DEFAULT MTL_CCEOI_VAR_PVT.G_CC_HEADER_ID)
2594: IS
2595: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2596: BEGIN
2597: -- Start OF comments
2598: -- API name : Validate_SubInv
2599: -- TYPE : Private

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

2815: p_action IN NUMBER DEFAULT NULL,
2816: x_locator_control OUT NOCOPY NUMBER ,
2817: x_level OUT NOCOPY NUMBER )
2818: IS
2819: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2820: BEGIN
2821: -- Start OF comments
2822: -- API name : Locator_Control
2823: -- TYPE : Private

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

3051: restrict_flag IN NUMBER ,
3052: neg_flag IN NUMBER DEFAULT 38,
3053: action IN NUMBER DEFAULT 38)
3054: RETURN VARCHAR2 IS
3055: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3056: BEGIN
3057: DECLARE
3058: VALUE VARCHAR2(2000);
3059: DO_NOT VARCHAR2(10);

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

3126: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE
3127: ) IS
3128: -- end of parameter
3129: --
3130: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3131: BEGIN
3132: -- Start OF comments
3133: -- API name : Get_Item_Cost
3134: -- TYPE : Private