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 88: -- Write Debug statements to Log using Error Handler procedure --

84: G_ENTITY_ID NUMBER;
85: G_APPLICATION_CONTEXT VARCHAR2(30);
86:
87: -----------------------------------------------------------------
88: -- Write Debug statements to Log using Error Handler procedure --
89: -----------------------------------------------------------------
90: PROCEDURE Write_Debug (p_msg IN VARCHAR2) IS
91:
92: BEGIN

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

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

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

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

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

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

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

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

Line 169: Error_Handler.initialize();

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

Line 170: Error_Handler.set_bo_identifier(G_BO_IDENTIFIER);

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

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

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

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

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

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

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

Line 212: Error_Handler.Open_Debug_Session(

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

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

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

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

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

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

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

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

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

Line 290: Error_Handler.Close_Debug_Session;

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

Line 973: -- Close Error Handler Debug Session.

969:
970:
971:
972: -----------------------------------------------------
973: -- Close Error Handler Debug Session.
974: -----------------------------------------------------
975: Close_Debug_Session;
976:
977:

Line 1321: -- Close Error Handler Debug Session.

1317: );
1318:
1319:
1320: -----------------------------------------------------
1321: -- Close Error Handler Debug Session.
1322: -----------------------------------------------------
1323: Close_Debug_Session;
1324:
1325:

Line 2206: -- Close Error Handler Debug Session.

2202:
2203:
2204:
2205: -----------------------------------------------------
2206: -- Close Error Handler Debug Session.
2207: -----------------------------------------------------
2208: Close_Debug_Session;
2209:
2210:

Line 2663: -- Close Error Handler Debug Session.

2659: );
2660:
2661:
2662: -----------------------------------------------------
2663: -- Close Error Handler Debug Session.
2664: -----------------------------------------------------
2665: Close_Debug_Session;
2666:
2667:

Line 2681: -- Close Error Handler Debug Session.

2677: p_data => x_msg_data
2678: );
2679:
2680: -----------------------------------------------------
2681: -- Close Error Handler Debug Session.
2682: -----------------------------------------------------
2683: Close_Debug_Session;
2684:
2685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2694: -- Close Error Handler Debug Session.

2690: p_data => x_msg_data
2691: );
2692:
2693: -----------------------------------------------------
2694: -- Close Error Handler Debug Session.
2695: -----------------------------------------------------
2696: Close_Debug_Session;
2697:
2698: WHEN OTHERS THEN

Line 2717: -- Close Error Handler Debug Session.

2713: p_data => x_msg_data
2714: );
2715:
2716: -----------------------------------------------------
2717: -- Close Error Handler Debug Session.
2718: -----------------------------------------------------
2719: Close_Debug_Session;
2720:
2721:

Line 3145: -- Close Error Handler Debug Session.

3141: p_data => x_msg_data
3142: );
3143:
3144: -----------------------------------------------------
3145: -- Close Error Handler Debug Session.
3146: -----------------------------------------------------
3147: Close_Debug_Session;
3148:
3149:

Line 3160: -- Close Error Handler Debug Session.

3156: p_data => x_msg_data
3157: );
3158:
3159: -----------------------------------------------------
3160: -- Close Error Handler Debug Session.
3161: -----------------------------------------------------
3162: Close_Debug_Session;
3163:
3164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3173: -- Close Error Handler Debug Session.

3169: p_data => x_msg_data
3170: );
3171:
3172: -----------------------------------------------------
3173: -- Close Error Handler Debug Session.
3174: -----------------------------------------------------
3175: Close_Debug_Session;
3176:
3177: WHEN OTHERS THEN

Line 3196: -- Close Error Handler Debug Session.

3192: p_data => x_msg_data
3193: );
3194:
3195: -----------------------------------------------------
3196: -- Close Error Handler Debug Session.
3197: -----------------------------------------------------
3198: Close_Debug_Session;
3199:
3200:

Line 3569: -- Close Error Handler Debug Session.

3565: );
3566:
3567:
3568: -----------------------------------------------------
3569: -- Close Error Handler Debug Session.
3570: -----------------------------------------------------
3571: Close_Debug_Session;
3572:
3573:

Line 3584: -- Close Error Handler Debug Session.

3580: p_data => x_msg_data
3581: );
3582:
3583: -----------------------------------------------------
3584: -- Close Error Handler Debug Session.
3585: -----------------------------------------------------
3586: Close_Debug_Session;
3587:
3588: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3598: -- Close Error Handler Debug Session.

3594: p_data => x_msg_data
3595: );
3596:
3597: -----------------------------------------------------
3598: -- Close Error Handler Debug Session.
3599: -----------------------------------------------------
3600: Close_Debug_Session;
3601:
3602: WHEN OTHERS THEN

Line 3622: -- Close Error Handler Debug Session.

3618: p_data => x_msg_data
3619: );
3620:
3621: -----------------------------------------------------
3622: -- Close Error Handler Debug Session.
3623: -----------------------------------------------------
3624: Close_Debug_Session;
3625:
3626:

Line 3843: -- Close Error Handler Debug Session.

3839: );
3840:
3841:
3842: -----------------------------------------------------
3843: -- Close Error Handler Debug Session.
3844: -----------------------------------------------------
3845: Close_Debug_Session;
3846:
3847:

Line 3858: -- Close Error Handler Debug Session.

3854: p_data => x_msg_data
3855: );
3856:
3857: -----------------------------------------------------
3858: -- Close Error Handler Debug Session.
3859: -----------------------------------------------------
3860: Close_Debug_Session;
3861:
3862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3871: -- Close Error Handler Debug Session.

3867: p_data => x_msg_data
3868: );
3869:
3870: -----------------------------------------------------
3871: -- Close Error Handler Debug Session.
3872: -----------------------------------------------------
3873: Close_Debug_Session;
3874:
3875: WHEN OTHERS THEN

Line 3894: -- Close Error Handler Debug Session.

3890: p_data => x_msg_data
3891: );
3892:
3893: -----------------------------------------------------
3894: -- Close Error Handler Debug Session.
3895: -----------------------------------------------------
3896: Close_Debug_Session;
3897:
3898:

Line 4382: -- Close Error Handler Debug Session.

4378: );
4379:
4380:
4381: -----------------------------------------------------
4382: -- Close Error Handler Debug Session.
4383: -----------------------------------------------------
4384: Close_Debug_Session;
4385:
4386: EXCEPTION

Line 4396: -- Close Error Handler Debug Session.

4392: p_data => x_msg_data
4393: );
4394:
4395: -----------------------------------------------------
4396: -- Close Error Handler Debug Session.
4397: -----------------------------------------------------
4398: Close_Debug_Session;
4399:
4400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4409: -- Close Error Handler Debug Session.

4405: p_data => x_msg_data
4406: );
4407:
4408: -----------------------------------------------------
4409: -- Close Error Handler Debug Session.
4410: -----------------------------------------------------
4411: Close_Debug_Session;
4412:
4413: WHEN OTHERS THEN

Line 4436: -- Close Error Handler Debug Session.

4432:
4433: Write_Debug('Exception in CREATE_ORPHAN_COMPONENT_INTF: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4434:
4435: -----------------------------------------------------
4436: -- Close Error Handler Debug Session.
4437: -----------------------------------------------------
4438: Close_Debug_Session;
4439:
4440:

Line 4593: -- Close Error Handler Debug Session.

4589: );
4590:
4591:
4592: -----------------------------------------------------
4593: -- Close Error Handler Debug Session.
4594: -----------------------------------------------------
4595: Close_Debug_Session;
4596:
4597: EXCEPTION

Line 4607: -- Close Error Handler Debug Session.

4603: p_data => x_msg_data
4604: );
4605:
4606: -----------------------------------------------------
4607: -- Close Error Handler Debug Session.
4608: -----------------------------------------------------
4609: Close_Debug_Session;
4610:
4611: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4620: -- Close Error Handler Debug Session.

4616: p_data => x_msg_data
4617: );
4618:
4619: -----------------------------------------------------
4620: -- Close Error Handler Debug Session.
4621: -----------------------------------------------------
4622: Close_Debug_Session;
4623:
4624: WHEN OTHERS THEN

Line 4647: -- Close Error Handler Debug Session.

4643:
4644: Write_Debug('Exception in CREATE_ORPHAN_HEADER_INTF: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4645:
4646: -----------------------------------------------------
4647: -- Close Error Handler Debug Session.
4648: -----------------------------------------------------
4649: Close_Debug_Session;
4650:
4651:

Line 4801: -- Close Error Handler Debug Session.

4797: );
4798:
4799:
4800: -----------------------------------------------------
4801: -- Close Error Handler Debug Session.
4802: -----------------------------------------------------
4803: Close_Debug_Session;
4804:
4805: EXCEPTION

Line 4815: -- Close Error Handler Debug Session.

4811: p_data => x_msg_data
4812: );
4813:
4814: -----------------------------------------------------
4815: -- Close Error Handler Debug Session.
4816: -----------------------------------------------------
4817: Close_Debug_Session;
4818:
4819: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4828: -- Close Error Handler Debug Session.

4824: p_data => x_msg_data
4825: );
4826:
4827: -----------------------------------------------------
4828: -- Close Error Handler Debug Session.
4829: -----------------------------------------------------
4830: Close_Debug_Session;
4831:
4832: WHEN OTHERS THEN

Line 4855: -- Close Error Handler Debug Session.

4851:
4852: Write_Debug('Exception in PREPROCESS_COMP_CHILD_ROWS: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
4853:
4854: -----------------------------------------------------
4855: -- Close Error Handler Debug Session.
4856: -----------------------------------------------------
4857: Close_Debug_Session;
4858:
4859:

Line 5230: -- Close Error Handler Debug Session.

5226: );
5227:
5228:
5229: -----------------------------------------------------
5230: -- Close Error Handler Debug Session.
5231: -----------------------------------------------------
5232: Close_Debug_Session;
5233:
5234: EXCEPTION

Line 5244: -- Close Error Handler Debug Session.

5240: p_data => x_msg_data
5241: );
5242:
5243: -----------------------------------------------------
5244: -- Close Error Handler Debug Session.
5245: -----------------------------------------------------
5246: Close_Debug_Session;
5247:
5248: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 5257: -- Close Error Handler Debug Session.

5253: p_data => x_msg_data
5254: );
5255:
5256: -----------------------------------------------------
5257: -- Close Error Handler Debug Session.
5258: -----------------------------------------------------
5259: Close_Debug_Session;
5260:
5261: WHEN OTHERS THEN

Line 5284: -- Close Error Handler Debug Session.

5280:
5281: Write_Debug('Exception in PREPROCESS_BOM_INTERFACE_ROWS: '|| Substr(To_Char(SQLCODE)||'/'||SQLERRM,1,240));
5282:
5283: -----------------------------------------------------
5284: -- Close Error Handler Debug Session.
5285: -----------------------------------------------------
5286: Close_Debug_Session;
5287:
5288:

Line 6056: ERROR_HANDLER.Add_Error_Message(

6052: AND ROWNUM = 1';
6053: EXECUTE IMMEDIATE l_dynamic_sql
6054: INTO l_dummy
6055: USING p_data_set_id;
6056: ERROR_HANDLER.Add_Error_Message(
6057: p_message_text => x_msg_data
6058: ,p_row_identifier => l_dummy
6059: ,p_application_id => 'EGO'
6060: ,p_message_type => FND_API.G_RET_STS_ERROR