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: null;
11: INV_TRX_UTIL_PUB.TRACE( P_MESG =>msg
12: ,P_MOD => 'mtl_cceoi_action_pvt'

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

25: x_item_cost OUT NOCOPY NUMBER )
26:
27: IS
28: l_locator_id NUMBER := p_locator_id ;
29: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
30:
31: BEGIN
32:
33: IF ( l_debug = 1 ) THEN

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

115: l_msg_count NUMBER;
116: l_msg_data VARCHAR2(240);
117: l_return_status VARCHAR2(1);
118: l_result_date DATE;
119: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
120: begin
121: mtl_inv_validate_grp.get_offset_date(
122: p_api_version => 0.9,
123: x_msg_count => l_msg_count,

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

149: -- this procedure prevents reuse of global variables between calls to
150: -- the public api done within the same session
151: PROCEDURE Reset_Global_Vars
152: IS
153: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
154: BEGIN
155: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_HEADER_REC := null;
156: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC := null;
157: MTL_CCEOI_VAR_PVT.G_OPEN_REQUEST := false;

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

200: --
201: -- Copy the current into the prior columns
202: PROCEDURE Current_To_Prior
203: IS
204: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
205: BEGIN
206: -- Start OF comments
207: -- API name : Current_to_Prior
208: -- TYPE : Private

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

270: --
271: -- Propagates info about first count into updated record
272: PROCEDURE Propagate_First
273: IS
274: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
275: BEGIN
276: -- propagate first count date
277: MTL_CCEOI_VAR_PVT.G_CC_ENTRY_REC_TMP.COUNT_DATE_FIRST :=
278: MTL_CCEOI_VAR_PVT.G_CYCLE_COUNT_ENTRY_REC.COUNT_DATE_FIRST;

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

318: PROCEDURE Current_To_First(
319: p_reference IN VARCHAR2 DEFAULT NULL,
320: p_primary_uom_quantity IN NUMBER )
321: IS
322: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
323: BEGIN
324: -- Start OF comments
325: -- API name : Current_to_first
326: -- TYPE : Private

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

395: PROCEDURE entry_to_current(
396: p_reference IN VARCHAR2 DEFAULT NULL,
397: p_primary_uom_quantity IN NUMBER )
398: IS
399: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
400: BEGIN
401: -- Start OF comments
402: -- API name : Entry_to_Current
403: -- TYPE : Private

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

472: p_transaction_reason_id IN NUMBER ,
473: p_transaction_process_mode IN NUMBER DEFAULT 3,
474: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
475: IS
476: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
477: BEGIN
478: -- Start OF comments
479: -- API name : Final_Update_Logic
480: -- TYPE : Private

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

719: p_serial_number VARCHAR2 ,
720: p_transaction_process_mode NUMBER ,
721: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
722: IS
723: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
724: BEGIN
725: -- Start OF comments
726: -- API name : In_TOLERANCE
727: -- TYPE : Private

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

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

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

923: p_approval_option_code IN NUMBER ,
924: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
925: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
926: IS
927: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
928: BEGIN
929: -- Start OF comments
930: -- API name : Tolerance_logic
931: -- TYPE : Private

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

1511: PROCEDURE Zero_Count_Logic(
1512: p_reference IN VARCHAR2 DEFAULT NULL,
1513: p_primary_uom_quantity IN NUMBER )
1514: IS
1515: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1516: BEGIN
1517: -- Start OF comments
1518: -- API name : Zero_Count_logic
1519: -- TYPE : Private

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

1593: p_system_quantity IN NUMBER DEFAULT NULL,
1594: p_secondary_system_quantity IN NUMBER DEFAULT NULL -- INVCONV
1595: )
1596: IS
1597: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1598: BEGIN
1599: -- Start OF comments
1600: -- API name : Calculate_Adjustment
1601: -- TYPE : Private

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

2053: p_head_cost_tol_neg IN NUMBER ,
2054: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2055: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
2056: IS
2057: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2058: BEGIN
2059: -- Start OF comments
2060: -- API name : Calculate_Tolerance
2061: -- TYPE : Private

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

2229: -- Deletes entries in the interface tables
2230: PROCEDURE Delete_CCIEntry(
2231: p_cc_entry_interface_id IN NUMBER )
2232: IS
2233: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2234: BEGIN
2235: -- Start OF comments
2236: -- API name : Delete_CCEOIEntry
2237: -- TYPE : Private

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

2263: -- Delete records from the cycle count interface error table
2264: PROCEDURE Delete_CCEOIError(
2265: p_cc_entry_interface_id IN NUMBER )
2266: IS
2267: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2268: BEGIN
2269: -- Start OF comments
2270: -- API name : Delete_CCEOIError
2271: -- TYPE : Private

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

2307: */
2308: PROCEDURE Insert_CCEntry(
2309: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE)
2310: IS
2311: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2312: BEGIN
2313: -- Start OF comments
2314: -- API name : Insert_CCEntry
2315: -- TYPE : Public

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

2552: PROCEDURE Insert_CCIEntry(
2553: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
2554: x_return_status OUT NOCOPY VARCHAR2 )
2555: IS
2556: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2557: BEGIN
2558: -- Start OF comments
2559: -- API name : Insert_CCIEntry
2560: -- TYPE : Public

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

2914: p_error_column_name IN VARCHAR2 ,
2915: p_error_table_name IN VARCHAR2 ,
2916: p_message_name IN VARCHAR2 )
2917: IS
2918: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
2919: BEGIN
2920: -- Start OF comments
2921: -- API name :insert_CCEOIError
2922: -- TYPE : Private

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

3010: p_transaction_reason_id IN NUMBER ,
3011: p_transaction_process_mode IN NUMBER DEFAULT 3,
3012: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE)
3013: IS
3014: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3015: BEGIN
3016: -- Start OF comments
3017: -- API name : Existing_Serial_number
3018: -- TYPE : Private

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

3164: x_msg_data OUT NOCOPY VARCHAR2 ,
3165: p_cycle_count_entry_id IN NUMBER ,
3166: p_export_flag IN NUMBER )
3167: IS
3168: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3169: BEGIN
3170: -- Start OF comments
3171: -- API name : Set_CCExport
3172: -- TYPE : Private

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

3325: x_msg_data OUT NOCOPY VARCHAR2 ,
3326: p_cc_entry_interface_id IN NUMBER ,
3327: p_flags IN VARCHAR2 )
3328: IS
3329: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3330: BEGIN
3331: -- Start OF comments
3332: -- API name : Set_CCEOIFlags
3333: -- TYPE : Private

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

3506: x_errorcode OUT NOCOPY NUMBER ,
3507: p_cycle_count_header_id IN NUMBER ,
3508: p_cycle_count_header_name IN VARCHAR2 DEFAULT NULL)
3509: IS
3510: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3511: BEGIN
3512: -- Start OF comments
3513: -- API name : Validate_CHeader
3514: -- TYPE : Private

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

3689: p_cycle_count_entry_id IN NUMBER ,
3690: p_count_list_sequence IN NUMBER ,
3691: p_organization_id IN NUMBER )
3692: IS
3693: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3694: BEGIN
3695: -- Start OF comments
3696: -- API name : Validate_CountListSeq
3697: -- TYPE : Private

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

3877: p_locator_rec IN MTL_CCEOI_VAR_PVT.INV_LOCATOR_REC_TYPE ,
3878: p_organization_id IN number,
3879: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE )
3880: IS
3881: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
3882: BEGIN
3883: -- Start OF comments
3884: -- API name : Validate_ItemSKU
3885: -- TYPE : Private

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

4692: p_system_quantity IN NUMBER,
4693: p_secondary_system_quantity IN NUMBER -- INVCONV
4694: )
4695: IS
4696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
4697: BEGIN
4698: -- Start OF comments
4699: -- API name : Validate_UOMQuantity
4700: -- TYPE : Private

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

5116: p_employee_id IN NUMBER ,
5117: p_employee_name IN VARCHAR2 DEFAULT NULL,
5118: p_count_date IN DATE )
5119: IS
5120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5121: BEGIN
5122: -- Start OF comments
5123: -- API name : Validate_CDate_Counter
5124: -- TYPE : Private

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

5353: -- Updates the application tables
5354: PROCEDURE Update_CCEntry(
5355: p_cycle_count_entry_id IN NUMBER )
5356: IS
5357: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5358: BEGIN
5359: -- Start OF comments
5360: -- API name : Update_CCEntry
5361: -- TYPE : Public

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

5532: x_errorcode OUT NOCOPY NUMBER ,
5533: p_simulate IN VARCHAR2 DEFAULT FND_API.G_FALSE,
5534: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE )
5535: IS
5536: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5537: BEGIN
5538: -- Start OF comments
5539: -- API name : Process_Data
5540: -- TYPE : Private

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

5867: PROCEDURE Update_CCIEntry(
5868: p_interface_rec IN MTL_CCEOI_VAR_PVT.INV_CCEOI_TYPE ,
5869: x_return_status OUT NOCOPY VARCHAR2 )
5870: IS
5871: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5872: BEGIN
5873: -- Start OF comments
5874: -- API name : Update_CCIEntry
5875: -- TYPE : Private

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

6116: l_serial_number_type NUMBER;
6117: l_prefix VARCHAR2(30);
6118: l_quantity NUMBER;
6119:
6120: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6121: BEGIN
6122: SELECT SERIAL_NUMBER_TYPE
6123: INTO l_serial_number_type
6124: FROM MTL_PARAMETERS

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

6338: l_return_status VARCHAR2(1);
6339: l_msg_count NUMBER;
6340: l_msg_data VARCHAR2(240);
6341: lmsg varchar2(2000);
6342: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
6343: BEGIN
6344: /* passing input variable */
6345: /* delete only cycle count reservation */
6346: l_mtl_reservation_rec.demand_source_type_id := 9;

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

6394: , p_secondary_system_quantity IN NUMBER
6395: , p_tracking_quantity_ind IN VARCHAR2
6396: , p_secondary_default_ind IN VARCHAR2) IS
6397: --
6398: l_debug NUMBER := NVL (fnd_profile.VALUE ('INV_DEBUG_TRACE'), 0);
6399: l_api_version CONSTANT NUMBER := 0.9;
6400: l_api_name CONSTANT VARCHAR2 (30) := 'Validate_SecondaryUOMQty';
6401: l_table_name VARCHAR2 (100);
6402: l_column_name VARCHAR2 (100);