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

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

4:
5:
6: procedure mdebug(msg in varchar2)
7: is
8: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
9: begin
10: inv_log_util.trace(msg , g_pkg_name || ' ',9);
11: end;
12:

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

21: x_item_cost OUT NOCOPY NUMBER )
22:
23: IS
24: l_locator_id NUMBER := p_locator_id ;
25: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
26: --Begin Bug 16344740
27: l_process_enabled_flag VARCHAR2(1) := 'N';
28: l_result_code VARCHAR2(30);
29: l_return_status VARCHAR2(30);

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

174: l_msg_count NUMBER;
175: l_msg_data VARCHAR2(240);
176: l_return_status VARCHAR2(1);
177: l_result_date DATE;
178: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
179: begin
180: mtl_inv_validate_grp.get_offset_date(
181: p_api_version => 0.9,
182: x_msg_count => l_msg_count,

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

208: -- this procedure prevents reuse of global variables between calls to
209: -- the public api done within the same session
210: PROCEDURE Reset_Global_Vars
211: IS
212: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
213: BEGIN
214: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC := null;
215: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := null;
216: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := false;

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

259: --
260: -- Copy the current into the prior columns
261: PROCEDURE Current_To_Prior
262: IS
263: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
264: BEGIN
265: -- Start OF comments
266: -- API name : Current_to_Prior
267: -- TYPE : Private

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

329: --
330: -- Propagates info about first count into updated record
331: PROCEDURE Propagate_First
332: IS
333: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
334: BEGIN
335: -- propagate first count date
336: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_DATE_FIRST :=
337: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_DATE_FIRST;

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

377: PROCEDURE Current_To_First(
378: p_reference IN VARCHAR2 DEFAULT NULL,
379: p_primary_uom_quantity IN NUMBER )
380: IS
381: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
382: BEGIN
383: -- Start OF comments
384: -- API name : Current_to_first
385: -- TYPE : Private

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

454: PROCEDURE entry_to_current(
455: p_reference IN VARCHAR2 DEFAULT NULL,
456: p_primary_uom_quantity IN NUMBER )
457: IS
458: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
459: BEGIN
460: -- Start OF comments
461: -- API name : Entry_to_Current
462: -- TYPE : Private

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

531: p_transaction_reason_id IN NUMBER ,
532: p_transaction_process_mode IN NUMBER DEFAULT 3,
533: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
534: IS
535: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
536: BEGIN
537: -- Start OF comments
538: -- API name : Final_Update_Logic
539: -- TYPE : Private

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

816: p_serial_number VARCHAR2 ,
817: p_transaction_process_mode NUMBER ,
818: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
819: IS
820: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
821: BEGIN
822: -- Start OF comments
823: -- API name : In_TOLERANCE
824: -- TYPE : Private

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

911: p_serial_number VARCHAR2 ,
912: p_transaction_process_mode NUMBER ,
913: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
914: IS
915: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
916: BEGIN
917: -- Start OF comments
918: -- API name : out_OF_TOLERANCE
919: -- TYPE : Private

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

1020: p_approval_option_code IN NUMBER ,
1021: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
1022: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
1023: IS
1024: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1025: BEGIN
1026: -- Start OF comments
1027: -- API name : Tolerance_logic
1028: -- TYPE : Private

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

1608: PROCEDURE Zero_Count_Logic(
1609: p_reference IN VARCHAR2 DEFAULT NULL,
1610: p_primary_uom_quantity IN NUMBER )
1611: IS
1612: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1613: BEGIN
1614: -- Start OF comments
1615: -- API name : Zero_Count_logic
1616: -- TYPE : Private

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

1690: p_system_quantity IN NUMBER DEFAULT NULL,
1691: p_secondary_system_quantity IN NUMBER DEFAULT NULL -- INVCONV
1692: )
1693: IS
1694: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1695: BEGIN
1696: -- Start OF comments
1697: -- API name : Calculate_Adjustment
1698: -- TYPE : Private

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

2171: p_head_cost_tol_neg IN NUMBER ,
2172: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2173: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
2174: IS
2175: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2176: BEGIN
2177: -- Start OF comments
2178: -- API name : Calculate_Tolerance
2179: -- TYPE : Private

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

2347: -- Deletes entries in the interface tables
2348: PROCEDURE Delete_CCIEntry(
2349: p_cc_entry_interface_id IN NUMBER )
2350: IS
2351: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2352: BEGIN
2353: -- Start OF comments
2354: -- API name : Delete_CCEOIEntry
2355: -- TYPE : Private

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

2381: -- Delete records from the cycle count interface error table
2382: PROCEDURE Delete_CCEOIError(
2383: p_cc_entry_interface_id IN NUMBER )
2384: IS
2385: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2386: BEGIN
2387: -- Start OF comments
2388: -- API name : Delete_CCEOIError
2389: -- TYPE : Private

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

2425: */
2426: PROCEDURE Insert_CCEntry(
2427: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)
2428: IS
2429: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2430: l_user_tt_id NUMBER ; --10268469
2431: BEGIN
2432: -- Start OF comments
2433: -- API name : Insert_CCEntry

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

2690: PROCEDURE Insert_CCIEntry(
2691: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2692: x_return_status OUT NOCOPY VARCHAR2 )
2693: IS
2694: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2695: BEGIN
2696: -- Start OF comments
2697: -- API name : Insert_CCIEntry
2698: -- TYPE : Public

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

3052: p_error_column_name IN VARCHAR2 ,
3053: p_error_table_name IN VARCHAR2 ,
3054: p_message_name IN VARCHAR2 )
3055: IS
3056: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3057: BEGIN
3058: -- Start OF comments
3059: -- API name :insert_CCEOIError
3060: -- TYPE : Private

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

3148: p_transaction_reason_id IN NUMBER ,
3149: p_transaction_process_mode IN NUMBER DEFAULT 3,
3150: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
3151: IS
3152: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3153: BEGIN
3154: -- Start OF comments
3155: -- API name : Existing_Serial_number
3156: -- TYPE : Private

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

3302: x_msg_data OUT NOCOPY VARCHAR2 ,
3303: p_cycle_count_entry_id IN NUMBER ,
3304: p_export_flag IN NUMBER )
3305: IS
3306: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3307: BEGIN
3308: -- Start OF comments
3309: -- API name : Set_CCExport
3310: -- TYPE : Private

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

3466: x_msg_data OUT NOCOPY VARCHAR2 ,
3467: p_cc_entry_interface_id IN NUMBER ,
3468: p_flags IN VARCHAR2 )
3469: IS
3470: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3471: BEGIN
3472: -- Start OF comments
3473: -- API name : Set_CCEOIFlags
3474: -- TYPE : Private

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

3647: x_errorcode OUT NOCOPY NUMBER ,
3648: p_cycle_count_header_id IN NUMBER ,
3649: p_cycle_count_header_name IN VARCHAR2 DEFAULT NULL)
3650: IS
3651: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3652: BEGIN
3653: -- Start OF comments
3654: -- API name : Validate_CHeader
3655: -- TYPE : Private

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

3830: p_cycle_count_entry_id IN NUMBER ,
3831: p_count_list_sequence IN NUMBER ,
3832: p_organization_id IN NUMBER )
3833: IS
3834: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3835: BEGIN
3836: -- Start OF comments
3837: -- API name : Validate_CountListSeq
3838: -- TYPE : Private

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

4018: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
4019: p_organization_id IN number,
4020: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE )
4021: IS
4022: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4023: BEGIN
4024: -- Start OF comments
4025: -- API name : Validate_ItemSKU
4026: -- TYPE : Private

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

4863: p_system_quantity IN NUMBER,
4864: p_secondary_system_quantity IN NUMBER -- INVCONV
4865: )
4866: IS
4867: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4868: BEGIN
4869: -- Start OF comments
4870: -- API name : Validate_UOMQuantity
4871: -- TYPE : Private

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

5287: p_employee_id IN NUMBER ,
5288: p_employee_name IN VARCHAR2 DEFAULT NULL,
5289: p_count_date IN DATE )
5290: IS
5291: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5292: BEGIN
5293: -- Start OF comments
5294: -- API name : Validate_CDate_Counter
5295: -- TYPE : Private

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

5528: -- Updates the application tables
5529: PROCEDURE Update_CCEntry(
5530: p_cycle_count_entry_id IN NUMBER )
5531: IS
5532: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5533: BEGIN
5534: -- Start OF comments
5535: -- API name : Update_CCEntry
5536: -- TYPE : Public

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

5707: x_errorcode OUT NOCOPY NUMBER ,
5708: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5709: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
5710: IS
5711: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5712: BEGIN
5713: -- Start OF comments
5714: -- API name : Process_Data
5715: -- TYPE : Private

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

6042: PROCEDURE Update_CCIEntry(
6043: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
6044: x_return_status OUT NOCOPY VARCHAR2 )
6045: IS
6046: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6047: BEGIN
6048: -- Start OF comments
6049: -- API name : Update_CCIEntry
6050: -- TYPE : Private

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

6291: l_serial_number_type NUMBER;
6292: l_prefix VARCHAR2(30);
6293: l_quantity NUMBER;
6294:
6295: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6296: BEGIN
6297: SELECT SERIAL_NUMBER_TYPE
6298: INTO l_serial_number_type
6299: FROM MTL_PARAMETERS

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

6513: l_return_status VARCHAR2(1);
6514: l_msg_count NUMBER;
6515: l_msg_data VARCHAR2(240);
6516: lmsg varchar2(2000);
6517: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6518: BEGIN
6519: /* passing input variable */
6520: /* delete only cycle count reservation */
6521: l_mtl_reservation_rec.demand_source_type_id := 9;

Line 6573: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);

6569: , p_secondary_system_quantity IN NUMBER
6570: , p_tracking_quantity_ind IN VARCHAR2
6571: , p_secondary_default_ind IN VARCHAR2) IS
6572: --
6573: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
6574: l_api_version CONSTANT NUMBER := 0.9;
6575: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_SecondaryUOMQty';
6576: l_table_name VARCHAR2 (100);
6577: l_column_name VARCHAR2 (100);