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.ENG_CHANGE_IMPORT_UTIL dependencies on ERROR_HANDLER

Line 15: -- Debug Profile option used to write Error_Handler.Write_Debug --

11: --------------------------------------------
12: G_LANGUAGE_CODE VARCHAR2(3);
13:
14: ----------------------------------------------------------------------------
15: -- Debug Profile option used to write Error_Handler.Write_Debug --
16: -- Profile option name = INV_DEBUG_TRACE ; --
17: -- User Profile Option Name = INV: Debug Trace --
18: -- Values: 1 (True) ; 0 (False) --
19: -- NOTE: This better than MRP_DEBUG which is used at many places. --

Line 68: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;

64:
65: ---------------------------------------------------------------
66: -- Message Type Text . --
67: ---------------------------------------------------------------
68: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
69: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
70: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
71: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
72: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';

Line 69: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;

65: ---------------------------------------------------------------
66: -- Message Type Text . --
67: ---------------------------------------------------------------
68: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
69: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
70: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
71: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
72: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
73: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;

Line 70: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;

66: -- Message Type Text . --
67: ---------------------------------------------------------------
68: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
69: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
70: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
71: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
72: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
73: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;
74:

Line 71: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;

67: ---------------------------------------------------------------
68: G_ENG_MSG_TYPE_ERROR CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_ERROR ;
69: G_ENG_MSG_TYPE_WARNING CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_WARNING ;
70: G_ENG_MSG_TYPE_UNEXPECTED CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_UNEXPECTED ;
71: G_ENG_MSG_TYPE_FATAL CONSTANT VARCHAR2(1) := Error_Handler.G_STATUS_FATAL ;
72: G_ENG_MSG_TYPE_CONFIRMATION CONSTANT VARCHAR2(1) := 'C';
73: G_ENG_MSG_TYPE_INFORMATION CONSTANT VARCHAR2(1) := 'I' ;
74:
75:

Line 85: -- Write Debug statements to Log using Error Handler procedure --

81: G_MISS_DATE DATE := EGO_ITEM_PUB.G_INTF_NULL_DATE;
82:
83:
84: -----------------------------------------------------------------
85: -- Write Debug statements to Log using Error Handler procedure --
86: -----------------------------------------------------------------
87: PROCEDURE Write_Debug (p_msg IN VARCHAR2) IS
88:
89: BEGIN

Line 91: -- NOTE: No need to check for profile now, as Error_Handler checks

87: PROCEDURE Write_Debug (p_msg IN VARCHAR2) IS
88:
89: BEGIN
90:
91: -- NOTE: No need to check for profile now, as Error_Handler checks
92: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
93: -- If Profile set to TRUE --
94: -- IF (G_DEBUG = 1) THEN
95: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);

Line 92: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.

88:
89: BEGIN
90:
91: -- NOTE: No need to check for profile now, as Error_Handler checks
92: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
93: -- If Profile set to TRUE --
94: -- IF (G_DEBUG = 1) THEN
95: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
96: -- END IF;

Line 95: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);

91: -- NOTE: No need to check for profile now, as Error_Handler checks
92: -- for Error_Handler.Get_Debug = 'Y' before writing to Debug Log.
93: -- If Profile set to TRUE --
94: -- IF (G_DEBUG = 1) THEN
95: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
96: -- END IF;
97:
98: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
99:

Line 98: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);

94: -- IF (G_DEBUG = 1) THEN
95: -- Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
96: -- END IF;
97:
98: Error_Handler.Write_Debug('['||TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||'] '|| p_msg);
99:
100:
101: /*------------------------------------------------------------------
102: -- Comment Out

Line 165: Error_Handler.initialize();

161: l_log_return_status VARCHAR2(99);
162: l_errbuff VARCHAR2(999);
163: BEGIN
164:
165: Error_Handler.initialize();
166: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
167:
168: ---------------------------------------------------------------------------------
169: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value

Line 166: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

162: l_errbuff VARCHAR2(999);
163: BEGIN
164:
165: Error_Handler.initialize();
166: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);
167:
168: ---------------------------------------------------------------------------------
169: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
170: -- appropriately, so that when the Debug Session is successfully opened :

Line 171: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'

167:
168: ---------------------------------------------------------------------------------
169: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
170: -- appropriately, so that when the Debug Session is successfully opened :
171: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'
172: ---------------------------------------------------------------------------------
173: -- Error_Handler.Set_Debug('Y');
174:
175: OPEN c_get_utl_file_dir;

Line 173: -- Error_Handler.Set_Debug('Y');

169: -- Commented on 12/17/2003 (PPEDDAMA). Open_Debug_Session should set the value
170: -- appropriately, so that when the Debug Session is successfully opened :
171: -- will return Error_Handler.Get_Debug = 'Y', else Error_Handler.Get_Debug = 'N'
172: ---------------------------------------------------------------------------------
173: -- Error_Handler.Set_Debug('Y');
174:
175: OPEN c_get_utl_file_dir;
176: FETCH c_get_utl_file_dir INTO l_log_output_dir;
177: --developer_debug('UTL_FILE_DIR : '||l_log_output_dir);

Line 206: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --

202: --developer_debug('Trying to open the Error File => '||G_ERROR_FILE_NAME);
203:
204: -----------------------------------------------------------------------
205: -- To open the Debug Session to write the Debug Log. --
206: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
207: -----------------------------------------------------------------------
208: Error_Handler.Open_Debug_Session(
209: p_debug_filename => G_ERROR_FILE_NAME
210: ,p_output_dir => l_log_output_dir

Line 208: Error_Handler.Open_Debug_Session(

204: -----------------------------------------------------------------------
205: -- To open the Debug Session to write the Debug Log. --
206: -- This sets Debug value so that Error_Handler.Get_Debug returns 'Y' --
207: -----------------------------------------------------------------------
208: Error_Handler.Open_Debug_Session(
209: p_debug_filename => G_ERROR_FILE_NAME
210: ,p_output_dir => l_log_output_dir
211: ,x_return_status => l_log_return_status
212: ,x_error_mesg => l_errbuff

Line 260: -- Opens Error_Handler debug session, only if Debug session is not already open.

256:
257: G_OUTPUT_DIR := p_output_dir ;
258: G_ERROR_FILE_NAME := p_file_name ;
259: ----------------------------------------------------------------------------------
260: -- Opens Error_Handler debug session, only if Debug session is not already open.
261: -- Suggested by RFAROOK, so that multiple debug sessions are not open PER
262: -- Concurrent Request.
263: ----------------------------------------------------------------------------------
264: IF (Error_Handler.Get_Debug <> 'Y') THEN

Line 264: IF (Error_Handler.Get_Debug <> 'Y') THEN

260: -- Opens Error_Handler debug session, only if Debug session is not already open.
261: -- Suggested by RFAROOK, so that multiple debug sessions are not open PER
262: -- Concurrent Request.
263: ----------------------------------------------------------------------------------
264: IF (Error_Handler.Get_Debug <> 'Y') THEN
265: Open_Debug_Session_Internal;
266: END IF;
267:
268: END IF;

Line 283: -- Close Error_Handler debug session, only if Debug session is already open.

279: PROCEDURE Close_Debug_Session IS
280:
281: BEGIN
282: -----------------------------------------------------------------------------
283: -- Close Error_Handler debug session, only if Debug session is already open.
284: -----------------------------------------------------------------------------
285: IF (Error_Handler.Get_Debug = 'Y') THEN
286: Error_Handler.Close_Debug_Session;
287: END IF;

Line 285: IF (Error_Handler.Get_Debug = 'Y') THEN

281: BEGIN
282: -----------------------------------------------------------------------------
283: -- Close Error_Handler debug session, only if Debug session is already open.
284: -----------------------------------------------------------------------------
285: IF (Error_Handler.Get_Debug = 'Y') THEN
286: Error_Handler.Close_Debug_Session;
287: END IF;
288:
289: EXCEPTION

Line 286: Error_Handler.Close_Debug_Session;

282: -----------------------------------------------------------------------------
283: -- Close Error_Handler debug session, only if Debug session is already open.
284: -----------------------------------------------------------------------------
285: IF (Error_Handler.Get_Debug = 'Y') THEN
286: Error_Handler.Close_Debug_Session;
287: END IF;
288:
289: EXCEPTION
290: WHEN OTHERS THEN

Line 969: -- Close Error Handler Debug Session.

965:
966:
967:
968: -----------------------------------------------------
969: -- Close Error Handler Debug Session.
970: -----------------------------------------------------
971: Close_Debug_Session;
972:
973:

Line 1317: -- Close Error Handler Debug Session.

1313: );
1314:
1315:
1316: -----------------------------------------------------
1317: -- Close Error Handler Debug Session.
1318: -----------------------------------------------------
1319: Close_Debug_Session;
1320:
1321:

Line 2202: -- Close Error Handler Debug Session.

2198:
2199:
2200:
2201: -----------------------------------------------------
2202: -- Close Error Handler Debug Session.
2203: -----------------------------------------------------
2204: Close_Debug_Session;
2205:
2206:

Line 2659: -- Close Error Handler Debug Session.

2655: );
2656:
2657:
2658: -----------------------------------------------------
2659: -- Close Error Handler Debug Session.
2660: -----------------------------------------------------
2661: Close_Debug_Session;
2662:
2663:

Line 2677: -- Close Error Handler Debug Session.

2673: p_data => x_msg_data
2674: );
2675:
2676: -----------------------------------------------------
2677: -- Close Error Handler Debug Session.
2678: -----------------------------------------------------
2679: Close_Debug_Session;
2680:
2681: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2690: -- Close Error Handler Debug Session.

2686: p_data => x_msg_data
2687: );
2688:
2689: -----------------------------------------------------
2690: -- Close Error Handler Debug Session.
2691: -----------------------------------------------------
2692: Close_Debug_Session;
2693:
2694: WHEN OTHERS THEN

Line 2713: -- Close Error Handler Debug Session.

2709: p_data => x_msg_data
2710: );
2711:
2712: -----------------------------------------------------
2713: -- Close Error Handler Debug Session.
2714: -----------------------------------------------------
2715: Close_Debug_Session;
2716:
2717:

Line 3039: -- Close Error Handler Debug Session.

3035: p_data => x_msg_data
3036: );
3037:
3038: -----------------------------------------------------
3039: -- Close Error Handler Debug Session.
3040: -----------------------------------------------------
3041: Close_Debug_Session;
3042:
3043:

Line 3054: -- Close Error Handler Debug Session.

3050: p_data => x_msg_data
3051: );
3052:
3053: -----------------------------------------------------
3054: -- Close Error Handler Debug Session.
3055: -----------------------------------------------------
3056: Close_Debug_Session;
3057:
3058: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3067: -- Close Error Handler Debug Session.

3063: p_data => x_msg_data
3064: );
3065:
3066: -----------------------------------------------------
3067: -- Close Error Handler Debug Session.
3068: -----------------------------------------------------
3069: Close_Debug_Session;
3070:
3071: WHEN OTHERS THEN

Line 3090: -- Close Error Handler Debug Session.

3086: p_data => x_msg_data
3087: );
3088:
3089: -----------------------------------------------------
3090: -- Close Error Handler Debug Session.
3091: -----------------------------------------------------
3092: Close_Debug_Session;
3093:
3094:

Line 3463: -- Close Error Handler Debug Session.

3459: );
3460:
3461:
3462: -----------------------------------------------------
3463: -- Close Error Handler Debug Session.
3464: -----------------------------------------------------
3465: Close_Debug_Session;
3466:
3467:

Line 3478: -- Close Error Handler Debug Session.

3474: p_data => x_msg_data
3475: );
3476:
3477: -----------------------------------------------------
3478: -- Close Error Handler Debug Session.
3479: -----------------------------------------------------
3480: Close_Debug_Session;
3481:
3482: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3492: -- Close Error Handler Debug Session.

3488: p_data => x_msg_data
3489: );
3490:
3491: -----------------------------------------------------
3492: -- Close Error Handler Debug Session.
3493: -----------------------------------------------------
3494: Close_Debug_Session;
3495:
3496: WHEN OTHERS THEN

Line 3516: -- Close Error Handler Debug Session.

3512: p_data => x_msg_data
3513: );
3514:
3515: -----------------------------------------------------
3516: -- Close Error Handler Debug Session.
3517: -----------------------------------------------------
3518: Close_Debug_Session;
3519:
3520:

Line 3737: -- Close Error Handler Debug Session.

3733: );
3734:
3735:
3736: -----------------------------------------------------
3737: -- Close Error Handler Debug Session.
3738: -----------------------------------------------------
3739: Close_Debug_Session;
3740:
3741:

Line 3752: -- Close Error Handler Debug Session.

3748: p_data => x_msg_data
3749: );
3750:
3751: -----------------------------------------------------
3752: -- Close Error Handler Debug Session.
3753: -----------------------------------------------------
3754: Close_Debug_Session;
3755:
3756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3765: -- Close Error Handler Debug Session.

3761: p_data => x_msg_data
3762: );
3763:
3764: -----------------------------------------------------
3765: -- Close Error Handler Debug Session.
3766: -----------------------------------------------------
3767: Close_Debug_Session;
3768:
3769: WHEN OTHERS THEN

Line 3788: -- Close Error Handler Debug Session.

3784: p_data => x_msg_data
3785: );
3786:
3787: -----------------------------------------------------
3788: -- Close Error Handler Debug Session.
3789: -----------------------------------------------------
3790: Close_Debug_Session;
3791:
3792:

Line 4276: -- Close Error Handler Debug Session.

4272: );
4273:
4274:
4275: -----------------------------------------------------
4276: -- Close Error Handler Debug Session.
4277: -----------------------------------------------------
4278: Close_Debug_Session;
4279:
4280: EXCEPTION

Line 4290: -- Close Error Handler Debug Session.

4286: p_data => x_msg_data
4287: );
4288:
4289: -----------------------------------------------------
4290: -- Close Error Handler Debug Session.
4291: -----------------------------------------------------
4292: Close_Debug_Session;
4293:
4294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4303: -- Close Error Handler Debug Session.

4299: p_data => x_msg_data
4300: );
4301:
4302: -----------------------------------------------------
4303: -- Close Error Handler Debug Session.
4304: -----------------------------------------------------
4305: Close_Debug_Session;
4306:
4307: WHEN OTHERS THEN

Line 4330: -- Close Error Handler Debug Session.

4326:
4327: Write_Debug('Exception in CREATE_ORPHAN_COMPONENT_INTF: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4328:
4329: -----------------------------------------------------
4330: -- Close Error Handler Debug Session.
4331: -----------------------------------------------------
4332: Close_Debug_Session;
4333:
4334:

Line 4487: -- Close Error Handler Debug Session.

4483: );
4484:
4485:
4486: -----------------------------------------------------
4487: -- Close Error Handler Debug Session.
4488: -----------------------------------------------------
4489: Close_Debug_Session;
4490:
4491: EXCEPTION

Line 4501: -- Close Error Handler Debug Session.

4497: p_data => x_msg_data
4498: );
4499:
4500: -----------------------------------------------------
4501: -- Close Error Handler Debug Session.
4502: -----------------------------------------------------
4503: Close_Debug_Session;
4504:
4505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4514: -- Close Error Handler Debug Session.

4510: p_data => x_msg_data
4511: );
4512:
4513: -----------------------------------------------------
4514: -- Close Error Handler Debug Session.
4515: -----------------------------------------------------
4516: Close_Debug_Session;
4517:
4518: WHEN OTHERS THEN

Line 4541: -- Close Error Handler Debug Session.

4537:
4538: Write_Debug('Exception in CREATE_ORPHAN_HEADER_INTF: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4539:
4540: -----------------------------------------------------
4541: -- Close Error Handler Debug Session.
4542: -----------------------------------------------------
4543: Close_Debug_Session;
4544:
4545:

Line 4695: -- Close Error Handler Debug Session.

4691: );
4692:
4693:
4694: -----------------------------------------------------
4695: -- Close Error Handler Debug Session.
4696: -----------------------------------------------------
4697: Close_Debug_Session;
4698:
4699: EXCEPTION

Line 4709: -- Close Error Handler Debug Session.

4705: p_data => x_msg_data
4706: );
4707:
4708: -----------------------------------------------------
4709: -- Close Error Handler Debug Session.
4710: -----------------------------------------------------
4711: Close_Debug_Session;
4712:
4713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4722: -- Close Error Handler Debug Session.

4718: p_data => x_msg_data
4719: );
4720:
4721: -----------------------------------------------------
4722: -- Close Error Handler Debug Session.
4723: -----------------------------------------------------
4724: Close_Debug_Session;
4725:
4726: WHEN OTHERS THEN

Line 4749: -- Close Error Handler Debug Session.

4745:
4746: Write_Debug('Exception in PREPROCESS_COMP_CHILD_ROWS: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4747:
4748: -----------------------------------------------------
4749: -- Close Error Handler Debug Session.
4750: -----------------------------------------------------
4751: Close_Debug_Session;
4752:
4753:

Line 5124: -- Close Error Handler Debug Session.

5120: );
5121:
5122:
5123: -----------------------------------------------------
5124: -- Close Error Handler Debug Session.
5125: -----------------------------------------------------
5126: Close_Debug_Session;
5127:
5128: EXCEPTION

Line 5138: -- Close Error Handler Debug Session.

5134: p_data => x_msg_data
5135: );
5136:
5137: -----------------------------------------------------
5138: -- Close Error Handler Debug Session.
5139: -----------------------------------------------------
5140: Close_Debug_Session;
5141:
5142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5151: -- Close Error Handler Debug Session.

5147: p_data => x_msg_data
5148: );
5149:
5150: -----------------------------------------------------
5151: -- Close Error Handler Debug Session.
5152: -----------------------------------------------------
5153: Close_Debug_Session;
5154:
5155: WHEN OTHERS THEN

Line 5178: -- Close Error Handler Debug Session.

5174:
5175: Write_Debug('Exception in PREPROCESS_BOM_INTERFACE_ROWS: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
5176:
5177: -----------------------------------------------------
5178: -- Close Error Handler Debug Session.
5179: -----------------------------------------------------
5180: Close_Debug_Session;
5181:
5182: