DBA Data[Home] [Help]

APPS.ENG_DOCUMENT_UTIL dependencies on ENG_DOCUMENT_UTIL

Line 1: PACKAGE BODY ENG_DOCUMENT_UTIL AS

1: PACKAGE BODY ENG_DOCUMENT_UTIL AS
2: /* $Header: ENGUDOCB.pls 120.14 2006/11/14 08:47:20 asjohal noship $ */
3:
4:
5: PLSQL_COMPILE_ERROR EXCEPTION;

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_DOCUMENT_UTIL' ;

4:
5: PLSQL_COMPILE_ERROR EXCEPTION;
6: PRAGMA EXCEPTION_INIT(PLSQL_COMPILE_ERROR, -6550);
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30):= 'ENG_DOCUMENT_UTIL' ;
9:
10: -- For Debug
11: g_debug_flag BOOLEAN := FALSE ;
12: g_output_dir VARCHAR2(240) := NULL ;

Line 15: G_BO_IDENTIFIER VARCHAR2(30) := 'ENG_DOCUMENT_UTIL';

11: g_debug_flag BOOLEAN := FALSE ;
12: g_output_dir VARCHAR2(240) := NULL ;
13: g_debug_filename VARCHAR2(200) := NULL ;
14: g_debug_errmesg VARCHAR2(240);
15: G_BO_IDENTIFIER VARCHAR2(30) := 'ENG_DOCUMENT_UTIL';
16: G_ERRFILE_PATH_AND_NAME VARCHAR2(10000);
17: g_profile_debug_option VARCHAR2(10) ;
18: g_profile_debug_level VARCHAR2(10) ;
19:

Line 384: Write_Debug('ENG_DOCUMENT_UTIL.Update_Approval_Status Log');

380: -- For Test/Debug
381: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
382:
383: IF g_debug_flag THEN
384: Write_Debug('ENG_DOCUMENT_UTIL.Update_Approval_Status Log');
385: Write_Debug('-----------------------------------------------------');
386: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
387: Write_Debug('Approval Status : ' || TO_CHAR(p_approval_status) );
388: Write_Debug('Workflow Status : ' || p_wf_route_status);

Line 517: Write_Debug('ENG_DOCUMENT_UTIL.Change_Doc_LC_Phase Log');

513: -- For Test/Debug
514: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
515:
516: IF g_debug_flag THEN
517: Write_Debug('ENG_DOCUMENT_UTIL.Change_Doc_LC_Phase Log');
518: Write_Debug('-----------------------------------------------------');
519: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
520: Write_Debug('LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );
521: Write_Debug('Action Type : ' || p_action_type);

Line 652: Write_Debug('ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF Log');

648: -- For Test/Debug
649: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
650:
651: IF g_debug_flag THEN
652: Write_Debug('ENG_DOCUMENT_UTIL.Start_Doc_LC_Phase_WF Log');
653: Write_Debug('-----------------------------------------------------');
654: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
655: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
656: Write_Debug('LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

Line 786: Write_Debug('ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF Log');

782: -- For Test/Debug
783: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
784:
785: IF g_debug_flag THEN
786: Write_Debug('ENG_DOCUMENT_UTIL.Abort_Doc_LC_Phase_WF Log');
787: Write_Debug('-----------------------------------------------------');
788: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );
789: Write_Debug('Route Id : ' || TO_CHAR(p_route_id) );
790: Write_Debug('LC Phase Code : ' || TO_CHAR(p_lc_phase_code) );

Line 922: Write_Debug('ENG_DOCUMENT_UTIL.Grant_Document_Role Log');

918: -- For Test/Debug
919: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
920:
921: IF g_debug_flag THEN
922: Write_Debug('ENG_DOCUMENT_UTIL.Grant_Document_Role Log');
923: Write_Debug('-----------------------------------------------------');
924: Write_Debug('Document Id : ' || TO_CHAR(p_document_id) );
925: Write_Debug('Document Revision Id : ' || TO_CHAR(p_document_revision_id) );
926: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );

Line 1117: Write_Debug('ENG_DOCUMENT_UTIL.Revoke_Document_Role Log');

1113: -- For Test/Debug
1114: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
1115:
1116: IF g_debug_flag THEN
1117: Write_Debug('ENG_DOCUMENT_UTIL.Revoke_Document_Role Log');
1118: Write_Debug('-----------------------------------------------------');
1119: Write_Debug('Document Id : ' || TO_CHAR(p_document_id) );
1120: Write_Debug('Document Revision Id : ' || TO_CHAR(p_document_revision_id) );
1121: Write_Debug('Change Id : ' || TO_CHAR(p_change_id) );

Line 1321: Write_Debug('ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole Log');

1317: -- For Test/Debug
1318: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
1319:
1320: IF g_debug_flag THEN
1321: Write_Debug('ENG_DOCUMENT_UTIL.Grant_Attachments_OCSRole Log');
1322: Write_Debug('-----------------------------------------------------');
1323: Write_Debug('Entity Name : ' || p_entity_name);
1324: Write_Debug('PK1 Value : ' || p_pk1value);
1325: Write_Debug('PK2 Value : ' || p_pk2value);

Line 1536: Write_Debug('ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole Log');

1532: -- For Test/Debug
1533: Check_And_Open_Debug_Session(p_debug, p_output_dir, p_debug_filename) ;
1534:
1535: IF g_debug_flag THEN
1536: Write_Debug('ENG_DOCUMENT_UTIL.Revoke_Attachments_OCSRole Log');
1537: Write_Debug('-----------------------------------------------------');
1538: Write_Debug('Entity Name : ' || p_entity_name);
1539: Write_Debug('PK1 Value : ' || p_pk1value);
1540: Write_Debug('PK2 Value : ' || p_pk2value);

Line 1691: END ENG_DOCUMENT_UTIL;

1687:
1688:
1689:
1690:
1691: END ENG_DOCUMENT_UTIL;