DBA Data[Home] [Help]

APPS.ENG_CHANGE_LIFECYCLE_UTIL dependencies on ENG_CHANGE_LIFECYCLE_UTIL

Line 1: PACKAGE BODY ENG_CHANGE_LIFECYCLE_UTIL AS

1: PACKAGE BODY ENG_CHANGE_LIFECYCLE_UTIL AS
2: /* $Header: ENGULCMB.pls 120.39.12020000.4 2013/03/05 06:46:29 jewen ship $ */
3:
4: -- ---------------------------------------------------------------------------
5: -- Global variables and constants

Line 7: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_LIFECYCLE_UTIL';

3:
4: -- ---------------------------------------------------------------------------
5: -- Global variables and constants
6: -- ---------------------------------------------------------------------------
7: G_PKG_NAME VARCHAR2(30) := 'ENG_CHANGE_LIFECYCLE_UTIL';
8:
9: -- For Debug
10: g_debug_flag BOOLEAN := FALSE ;
11: g_output_dir VARCHAR2(240) := NULL ;

Line 374: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Is_CO_On_Last_Imp_Phase log');

370: --x_curr_status_code := NULL;
371:
372: -- Write debug message if debug mode is on
373: IF g_debug_flag THEN
374: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Is_CO_On_Last_Imp_Phase log');
375: Write_Debug('-----------------------------------------------------');
376: Write_Debug('p_change_id : ' || p_change_id );
377: Write_Debug('-----------------------------------------------------');
378: Write_Debug('Initializing return status... ' );

Line 478: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Is_CO_Last_Imp_Phase_Used log');

474: x_last_status_code := NULL;
475:
476: -- Write debug message if debug mode is on
477: IF g_debug_flag THEN
478: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Is_CO_Last_Imp_Phase_Used log');
479: Write_Debug('-----------------------------------------------------');
480: Write_Debug('p_change_id : ' || p_change_id );
481: Write_Debug('-----------------------------------------------------');
482: Write_Debug('Initializing return status... ' );

Line 651: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Header_Appr_Status log');

647: -- END IF;
648:
649: -- Write debug message if debug mode is on
650: IF g_debug_flag THEN
651: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Header_Appr_Status log');
652: Write_Debug('-----------------------------------------------------');
653: Write_Debug('p_change_id : ' || p_change_id );
654: Write_Debug('p_status_code : ' || p_status_code );
655: Write_Debug('p_appr_status : ' || p_appr_status );

Line 1354: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_Line_Workflow log');

1350: -- END IF;
1351:
1352: -- Write debug message if debug mode is on
1353: IF g_debug_flag THEN
1354: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_Line_Workflow log');
1355: Write_Debug('-----------------------------------------------------');
1356: Write_Debug('p_change_id : ' || p_change_id );
1357: Write_Debug('p_new_status_code : ' || p_new_status_code );
1358: Write_Debug('p_cur_status_code : ' || p_cur_status_code);

Line 1593: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_WF_OnlyIf_Necessary log');

1589: -- END IF;
1590:
1591: -- Write debug message if debug mode is on
1592: IF g_debug_flag THEN
1593: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_WF_OnlyIf_Necessary log');
1594: Write_Debug('-----------------------------------------------------');
1595: Write_Debug('p_change_id : ' || p_change_id );
1596: Write_Debug('p_status_code : ' || p_status_code );
1597: -- bug 9577905

Line 2145: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Header log');

2141:
2142:
2143: -- Write debug message if debug mode is on
2144: IF g_debug_flag THEN
2145: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Header log');
2146: Write_Debug('-----------------------------------------------------');
2147: Write_Debug('p_change_id : ' || p_change_id );
2148: Write_Debug('p_status_code : ' || p_status_code );
2149: Write_Debug('p_api_caller : ' || p_api_caller );

Line 3250: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Header log');

3246: -- END IF;
3247:
3248: -- Write debug message if debug mode is on
3249: IF g_debug_flag THEN
3250: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Header log');
3251: Write_Debug('-----------------------------------------------------');
3252: Write_Debug('p_change_id : ' || p_change_id );
3253: Write_Debug('p_status_code : ' || p_status_code );
3254: Write_Debug('p_api_caller : ' || p_api_caller );

Line 3944: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Revised_Item log');

3940: -- END IF;
3941:
3942: -- Write debug message if debug mode is on
3943: IF g_debug_flag THEN
3944: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Revised_Item log');
3945: Write_Debug('-----------------------------------------------------');
3946: Write_Debug('p_change_id : ' || p_change_id );
3947: Write_Debug('p_object_id2 : ' || p_object_id2 );
3948: Write_Debug('p_status_code : ' || p_status_code );

Line 4318: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Revised_Item log');

4314: -- END IF;
4315:
4316: -- Write debug message if debug mode is on
4317: IF g_debug_flag THEN
4318: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Revised_Item log');
4319: Write_Debug('-----------------------------------------------------');
4320: Write_Debug('p_change_id : ' || p_change_id );
4321: Write_Debug('p_object_id2 : ' || p_object_id2 );
4322: Write_Debug('p_status_code : ' || p_status_code );

Line 4621: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase log');

4617: -- END IF;
4618:
4619: -- Write debug message if debug mode is on
4620: IF g_debug_flag THEN
4621: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase log');
4622: Write_Debug('-----------------------------------------------------');
4623: Write_Debug('p_object_name : ' || p_object_name );
4624: Write_Debug('p_change_id : ' || p_change_id );
4625: Write_Debug('p_object_id2 : ' || p_object_id2 );

Line 5037: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States log');

5033: -- END IF;
5034:
5035: -- Write debug message if debug mode is on
5036: IF g_debug_flag THEN
5037: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States log');
5038: Write_Debug('-----------------------------------------------------');
5039: Write_Debug('p_change_id : ' || p_change_id );
5040: Write_Debug('p_status_code : ' || p_status_code );
5041: Write_Debug('p_api_caller : ' || p_api_caller );

Line 6481: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Refresh_WF_Route log');

6477: -- END IF;
6478:
6479: -- Write debug message if debug mode is on
6480: IF g_debug_flag THEN
6481: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Refresh_WF_Route log');
6482: Write_Debug('-----------------------------------------------------');
6483: Write_Debug('p_change_id : ' || p_change_id );
6484: Write_Debug('p_status_code : ' || p_status_code );
6485: IF (p_wf_route_id IS NULL)

Line 6760: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle log');

6756: -- END IF;
6757:
6758: -- Write debug message if debug mode is on
6759: IF g_debug_flag THEN
6760: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle log');
6761: Write_Debug('-----------------------------------------------------');
6762: Write_Debug('p_change_id : ' || p_change_id );
6763: Write_Debug('p_init_status_code : ' || p_init_status_code );
6764: Write_Debug('p_init_option : ' || p_init_option );

Line 7424: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_RevItem_Lifecycle log');

7420: -- END IF;
7421:
7422: -- Write debug message if debug mode is on
7423: IF g_debug_flag THEN
7424: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_RevItem_Lifecycle log');
7425: Write_Debug('-----------------------------------------------------');
7426: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
7427: Write_Debug('p_status_type : ' || p_status_type );
7428: Write_Debug('-----------------------------------------------------');

Line 7608: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Reset_Phase log');

7604:
7605:
7606: -- Write debug message if debug mode is on
7607: IF g_debug_flag THEN
7608: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Reset_Phase log');
7609: Write_Debug('-----------------------------------------------------');
7610: Write_Debug('p_change_id : ' || to_char(p_change_id) );
7611: Write_Debug('p_status_code : ' || to_char(p_status_code) );
7612: Write_Debug('p_api_caller : ' || p_api_caller );

Line 8042: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Sync_LC_Phase_Setup log');

8038: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
8039:
8040: -- Write debug message if debug mode is on
8041: IF g_debug_flag THEN
8042: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Sync_LC_Phase_Setup log');
8043: Write_Debug('-----------------------------------------------------');
8044: Write_Debug('p_change_type_id : ' || to_char(p_change_type_id));
8045: Write_Debug('p_api_caller : ' || p_api_caller );
8046: Write_Debug('-----------------------------------------------------');

Line 8486: END ENG_CHANGE_LIFECYCLE_UTIL;

8482:
8483: END Sync_LC_Phase_Setup ;
8484:
8485:
8486: END ENG_CHANGE_LIFECYCLE_UTIL;
8487: