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.28 2007/07/04 10:59:55 sdarbha 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 649: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Header_Appr_Status log');

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

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

1334: -- END IF;
1335:
1336: -- Write debug message if debug mode is on
1337: IF g_debug_flag THEN
1338: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_Line_Workflow log');
1339: Write_Debug('-----------------------------------------------------');
1340: Write_Debug('p_change_id : ' || p_change_id );
1341: Write_Debug('p_new_status_code : ' || p_new_status_code );
1342: Write_Debug('p_cur_status_code : ' || p_cur_status_code);

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

1573: -- END IF;
1574:
1575: -- Write debug message if debug mode is on
1576: IF g_debug_flag THEN
1577: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Start_WF_OnlyIf_Necessary log');
1578: Write_Debug('-----------------------------------------------------');
1579: Write_Debug('p_change_id : ' || p_change_id );
1580: Write_Debug('p_status_code : ' || p_status_code );
1581: Write_Debug('-----------------------------------------------------');

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

2101:
2102:
2103: -- Write debug message if debug mode is on
2104: IF g_debug_flag THEN
2105: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Header log');
2106: Write_Debug('-----------------------------------------------------');
2107: Write_Debug('p_change_id : ' || p_change_id );
2108: Write_Debug('p_status_code : ' || p_status_code );
2109: Write_Debug('p_api_caller : ' || p_api_caller );

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

3142: -- END IF;
3143:
3144: -- Write debug message if debug mode is on
3145: IF g_debug_flag THEN
3146: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Header log');
3147: Write_Debug('-----------------------------------------------------');
3148: Write_Debug('p_change_id : ' || p_change_id );
3149: Write_Debug('p_status_code : ' || p_status_code );
3150: Write_Debug('p_api_caller : ' || p_api_caller );

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

3822: -- END IF;
3823:
3824: -- Write debug message if debug mode is on
3825: IF g_debug_flag THEN
3826: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Promote_Revised_Item log');
3827: Write_Debug('-----------------------------------------------------');
3828: Write_Debug('p_change_id : ' || p_change_id );
3829: Write_Debug('p_object_id2 : ' || p_object_id2 );
3830: Write_Debug('p_status_code : ' || p_status_code );

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

4196: -- END IF;
4197:
4198: -- Write debug message if debug mode is on
4199: IF g_debug_flag THEN
4200: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Demote_Revised_Item log');
4201: Write_Debug('-----------------------------------------------------');
4202: Write_Debug('p_change_id : ' || p_change_id );
4203: Write_Debug('p_object_id2 : ' || p_object_id2 );
4204: Write_Debug('p_status_code : ' || p_status_code );

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

4499: -- END IF;
4500:
4501: -- Write debug message if debug mode is on
4502: IF g_debug_flag THEN
4503: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Change_Phase log');
4504: Write_Debug('-----------------------------------------------------');
4505: Write_Debug('p_object_name : ' || p_object_name );
4506: Write_Debug('p_change_id : ' || p_change_id );
4507: Write_Debug('p_object_id2 : ' || p_object_id2 );

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

4915: -- END IF;
4916:
4917: -- Write debug message if debug mode is on
4918: IF g_debug_flag THEN
4919: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_Lifecycle_States log');
4920: Write_Debug('-----------------------------------------------------');
4921: Write_Debug('p_change_id : ' || p_change_id );
4922: Write_Debug('p_status_code : ' || p_status_code );
4923: Write_Debug('p_api_caller : ' || p_api_caller );

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

6313: -- END IF;
6314:
6315: -- Write debug message if debug mode is on
6316: IF g_debug_flag THEN
6317: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Refresh_WF_Route log');
6318: Write_Debug('-----------------------------------------------------');
6319: Write_Debug('p_change_id : ' || p_change_id );
6320: Write_Debug('p_status_code : ' || p_status_code );
6321: IF (p_wf_route_id IS NULL)

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

6585: -- END IF;
6586:
6587: -- Write debug message if debug mode is on
6588: IF g_debug_flag THEN
6589: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Init_Lifecycle log');
6590: Write_Debug('-----------------------------------------------------');
6591: Write_Debug('p_change_id : ' || p_change_id );
6592: Write_Debug('p_init_status_code : ' || p_init_status_code );
6593: Write_Debug('p_init_option : ' || p_init_option );

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

7129: -- END IF;
7130:
7131: -- Write debug message if debug mode is on
7132: IF g_debug_flag THEN
7133: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Update_RevItem_Lifecycle log');
7134: Write_Debug('-----------------------------------------------------');
7135: Write_Debug('p_rev_item_seq_id : ' || p_rev_item_seq_id );
7136: Write_Debug('p_status_type : ' || p_status_type );
7137: Write_Debug('-----------------------------------------------------');

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

7313:
7314:
7315: -- Write debug message if debug mode is on
7316: IF g_debug_flag THEN
7317: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Reset_Phase log');
7318: Write_Debug('-----------------------------------------------------');
7319: Write_Debug('p_change_id : ' || to_char(p_change_id) );
7320: Write_Debug('p_status_code : ' || to_char(p_status_code) );
7321: Write_Debug('p_api_caller : ' || p_api_caller );

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

7747: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
7748:
7749: -- Write debug message if debug mode is on
7750: IF g_debug_flag THEN
7751: Write_Debug('ENG_CHANGE_LIFECYCLE_UTIL.Sync_LC_Phase_Setup log');
7752: Write_Debug('-----------------------------------------------------');
7753: Write_Debug('p_change_type_id : ' || to_char(p_change_type_id));
7754: Write_Debug('p_api_caller : ' || p_api_caller );
7755: Write_Debug('-----------------------------------------------------');

Line 8195: END ENG_CHANGE_LIFECYCLE_UTIL;

8191:
8192: END Sync_LC_Phase_Setup ;
8193:
8194:
8195: END ENG_CHANGE_LIFECYCLE_UTIL;
8196: