DBA Data[Home] [Help]

APPS.AP_ACCTG_DATA_FIX_PKG dependencies on AP_ACCTG_DATA_FIX_PKG

Line 1: PACKAGE BODY AP_Acctg_Data_Fix_PKG AS

1: PACKAGE BODY AP_Acctg_Data_Fix_PKG AS
2: /* $Header: apgdfalb.pls 120.45.12020000.5 2012/10/16 11:45:48 vinerao ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_UNEXPECTED CONSTANT NUMBER := FND_LOG.LEVEL_UNEXPECTED;

Line 11: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_ACCTG_DATA_FIX_PKG.';

7: G_LEVEL_EXCEPTION CONSTANT NUMBER := FND_LOG.LEVEL_EXCEPTION;
8: G_LEVEL_EVENT CONSTANT NUMBER := FND_LOG.LEVEL_EVENT;
9: G_LEVEL_PROCEDURE CONSTANT NUMBER := FND_LOG.LEVEL_PROCEDURE;
10: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
11: G_MODULE_NAME CONSTANT VARCHAR2(50) :='AP.PLSQL.AP_ACCTG_DATA_FIX_PKG.';
12:
13:
14:
15: /* Procedure to open the log files on the instance where the datafix

Line 59: l_message := 'in side AP_ACCTG_DATA_FIX_PKG.Open_Log_Out_Files '||'

';

55: WHEN OTHERS THEN
56: l_message := 'Exception :: '||SQLERRM||'

';
57: FND_File.Put_Line(fnd_file.log,l_message);
58:
59: l_message := 'in side AP_ACCTG_DATA_FIX_PKG.Open_Log_Out_Files '||'

';
60: FND_File.Put_Line(fnd_file.log,l_message);
61: APP_EXCEPTION.RAISE_EXCEPTION;
62: END Open_Log_Out_Files;
63:

Line 84: 'AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables';

80: l_calling_sequence VARCHAR2(2000);
81: l_message VARCHAR2(500);
82: Begin
83: l_calling_sequence :=
84: 'AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables';
85:
86: Execute Immediate
87: 'create table '||'Events_'||P_Bug_Number||
88: ' as select * from XLA_EVENTS where rownum<1 ';

Line 154: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;

150:
151: begin
152:
153: l_calling_sequence :=
154: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
155: stmt_str := 'select column_name from '|| l_all_tab_columns ||
156: ' where table_name=:1 and column_name<>''DATAFIX_UPDATE_DATE''';
157: OPEN cur FOR stmt_str USING TAB_NAME;
158: LOOP

Line 194: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;

190:
191: begin
192:
193: l_calling_sequence :=
194: 'AP_Acctg_Data_Fix_PKG.Get_Cols<-' ;
195: stmt_str := 'select column_name from '|| l_all_tab_columns ||
196: ' where table_name=:1 and owner =:2 and column_name<>''DATAFIX_UPDATE_DATE''';
197: OPEN cur FOR stmt_str USING TAB_NAME, SCHEMA_NAME;
198: LOOP

Line 241: 'AP_Acctg_Data_Fix_PKG.Back_Up_Acctg<-'||P_calling_Sequence ;

237: l_calling_sequence VARCHAR2(2000);
238: BEGIN
239:
240: l_calling_sequence :=
241: 'AP_Acctg_Data_Fix_PKG.Back_Up_Acctg<-'||P_calling_Sequence ;
242:
243: l_debug_info := 'Setting the driver table name';
244: IF P_Driver_Table IS NULL THEN
245: l_driver_table := 'AP_TEMP_DATA_DRIVER_'||P_Bug_number;

Line 257: AP_Acctg_Data_Fix_PKG.Print('_______________________________________'||

253: OPEN cur FOR sql_liab_stat;
254: fetch cur into bkp_tables_exists;
255: CLOSE cur;
256:
257: AP_Acctg_Data_Fix_PKG.Print('_______________________________________'||
258: '_______________________________________');
259:
260: if (bkp_tables_exists=0) then
261: l_message := 'Backup tables do not Exist: Before creating accounting backup tables

';

Line 264: AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables(p_bug_number);

260: if (bkp_tables_exists=0) then
261: l_message := 'Backup tables do not Exist: Before creating accounting backup tables

';
262: Print(l_message);
263:
264: AP_Acctg_Data_Fix_PKG.Create_Temp_Acctg_Tables(p_bug_number);
265:
266: l_message := 'After creating accounting backup tables

';
267: Print(l_message);
268:

Line 273: AP_Acctg_Data_Fix_PKG.get_cols('EVENTS_'||P_Bug_Number,col_str5);

269: end if;
270:
271: l_debug_info := 'Before getting the cols for the Backup Tables';
272:
273: AP_Acctg_Data_Fix_PKG.get_cols('EVENTS_'||P_Bug_Number,col_str5);
274:
275: AP_Acctg_Data_Fix_PKG.get_cols('HEADERS_'||P_Bug_Number,col_str1);
276:
277: AP_Acctg_Data_Fix_PKG.get_cols('LINES_'||P_Bug_Number,col_str2);

Line 275: AP_Acctg_Data_Fix_PKG.get_cols('HEADERS_'||P_Bug_Number,col_str1);

271: l_debug_info := 'Before getting the cols for the Backup Tables';
272:
273: AP_Acctg_Data_Fix_PKG.get_cols('EVENTS_'||P_Bug_Number,col_str5);
274:
275: AP_Acctg_Data_Fix_PKG.get_cols('HEADERS_'||P_Bug_Number,col_str1);
276:
277: AP_Acctg_Data_Fix_PKG.get_cols('LINES_'||P_Bug_Number,col_str2);
278:
279: AP_Acctg_Data_Fix_PKG.get_cols('DISTRIB_LINKS_'||P_Bug_Number,col_str3);

Line 277: AP_Acctg_Data_Fix_PKG.get_cols('LINES_'||P_Bug_Number,col_str2);

273: AP_Acctg_Data_Fix_PKG.get_cols('EVENTS_'||P_Bug_Number,col_str5);
274:
275: AP_Acctg_Data_Fix_PKG.get_cols('HEADERS_'||P_Bug_Number,col_str1);
276:
277: AP_Acctg_Data_Fix_PKG.get_cols('LINES_'||P_Bug_Number,col_str2);
278:
279: AP_Acctg_Data_Fix_PKG.get_cols('DISTRIB_LINKS_'||P_Bug_Number,col_str3);
280:
281: l_message := 'Before creating backup for Accounting tables

';

Line 279: AP_Acctg_Data_Fix_PKG.get_cols('DISTRIB_LINKS_'||P_Bug_Number,col_str3);

275: AP_Acctg_Data_Fix_PKG.get_cols('HEADERS_'||P_Bug_Number,col_str1);
276:
277: AP_Acctg_Data_Fix_PKG.get_cols('LINES_'||P_Bug_Number,col_str2);
278:
279: AP_Acctg_Data_Fix_PKG.get_cols('DISTRIB_LINKS_'||P_Bug_Number,col_str3);
280:
281: l_message := 'Before creating backup for Accounting tables

';
282: FND_File.Put_Line(fnd_file.log,l_message);
283:

Line 349: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.print <- '||p_calling_sequence;

345: P_calling_sequence IN VARCHAR2) IS
346: l_message varchar2(500);
347: l_calling_sequence varchar2(500);
348: Begin
349: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.print <- '||p_calling_sequence;
350:
351: FND_File.Put_Line(fnd_file.log,p_message||'

');
352:
353: Exception

Line 409: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.Print_Html_Table <- '||

405: col_list VARCHAR2(2000);
406: l_message VARCHAR2(2000):='';
407:
408: BEGIN
409: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.Print_Html_Table <- '||
410: p_calling_sequence;
411: dot_loc := INSTR (table_nm, '.');
412: IF dot_loc > 0
413: THEN

Line 577: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.Backup_data <- '||

573: l_col_name VARCHAR2(35);
574: l_col_type VARCHAR2(35);
575:
576: Begin
577: l_calling_sequence:='AP_Acctg_Data_Fix_PKG.Backup_data <- '||
578: p_calling_sequence;
579:
580: sql_stmt := 'select count(*) from '|| l_tables ||
581: ' where table_name='||''''||p_destination_table||'''';

Line 660: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.apps_initialize <-'||p_calling_sequence;

656: l_error_log LONG;
657: l_calling_sequence VARCHAR2(4000);
658: BEGIN
659:
660: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.apps_initialize <-'||p_calling_sequence;
661:
662: l_debug_info := 'Before fetching the User Details ';
663: BEGIN
664: SELECT fu.user_id

Line 748: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Del_Nonfinal_xla_entries <- '||p_calling_sequence;

744: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
745:
746:
747: BEGIN
748: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Del_Nonfinal_xla_entries <- '||p_calling_sequence;
749:
750: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
751:
752: l_log_msg := 'Begin of procedure '|| l_procedure_name;

Line 854: Code changes are done in ap_acctg_data_fix_pkg.del_nonfinal_xla_entries procedure

850: RETURN;
851: END IF;
852:
853: /* Bug 11674553
854: Code changes are done in ap_acctg_data_fix_pkg.del_nonfinal_xla_entries procedure
855: for deleting the journals, event and entity by calling api instead of directly
856: deleting from xla tables.
857:
858: While calling delete entity, if l_result is 0 then entity deleted

Line 1131: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Check_Period <- '||p_calling_sequence;

1127: period_close_list PERIOD_CLOSE_REC_TYP;
1128:
1129: BEGIN
1130:
1131: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.Check_Period <- '||p_calling_sequence;
1132: l_bug_no := p_bug_no;
1133:
1134: l_debug_info := 'Constructing the name of the driver table';
1135: IF p_driver_table IS NOT NULL THEN

Line 1752: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.check_ccid <- '||p_calling_sequence;

1748: invalid_ccid REFCURTYP;
1749:
1750: BEGIN
1751:
1752: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.check_ccid <- '||p_calling_sequence;
1753: l_bug_no := p_bug_no;
1754:
1755: l_debug_info := 'Constructing the driver table name';
1756: IF p_driver_table IS NOT NULL THEN

Line 2093: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG <- '||p_calling_sequence;

2089: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2090:
2091: BEGIN
2092:
2093: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG <- '||p_calling_sequence;
2094:
2095: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2096:
2097: l_log_msg := 'Begin of procedure '|| l_procedure_name;

Line 2558: l_procedure_name := 'AP_ACCTG_DATA_FIX_PKG.undo_accounting';

2554: l_source_id := p_source_id;
2555: l_event_id := p_event_id;
2556: l_bug_id := p_bug_id;
2557: l_gl_date := p_GL_Date;
2558: l_procedure_name := 'AP_ACCTG_DATA_FIX_PKG.undo_accounting';
2559:
2560: debug_info := 'Calling the Undo_Accounting with higher number of Arguments';
2561: Undo_Accounting
2562: (p_Source_Table => l_source_table,

Line 5552: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.undo_Inv_accounting <- '||p_calling_sequence;

5548: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5549:
5550: BEGIN
5551:
5552: l_calling_sequence := 'AP_ACCTG_DATA_FIX_PKG.undo_Inv_accounting <- '||p_calling_sequence;
5553:
5554: G_CURRENT_RUNTIME_LEVEL := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5555:
5556: l_log_msg := 'Begin of procedure '|| l_procedure_name;

Line 6008: l_procedure_name := 'AP_ACCTG_DATA_FIX_PKG.undo_inv_accounting';

6004: l_source_id := p_source_id;
6005: l_event_id := p_event_id;
6006: l_bug_id := p_bug_id;
6007: l_gl_date := p_gl_date;
6008: l_procedure_name := 'AP_ACCTG_DATA_FIX_PKG.undo_inv_accounting';
6009:
6010: l_debug_info := 'Calling the undo_inv_accounting with higher number of arguments';
6011: IF( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL ) THEN
6012: FND_LOG.STRING( G_LEVEL_PROCEDURE, G_MODULE_NAME||l_procedure_name, l_log_msg );

Line 6496: END AP_Acctg_Data_Fix_PKG;

6492: END send_mail_clob_impl;
6493:
6494: -- Bug 14731725 end
6495:
6496: END AP_Acctg_Data_Fix_PKG;