DBA Data[Home] [Help]

APPS.XTR_CLEAR_JOURNAL_PROCESS_P dependencies on XTR_DEBUG_PKG

Line 79: -- xtr_debug_pkg.enable_debug (null,null);

75: v_batch_type Xtr_Batches.Batch_Type%Type;
76:
77: --
78: BEGIN
79: -- xtr_debug_pkg.enable_debug (null,null);
80: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');
82: END IF;
83:

Line 80: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

76:
77: --
78: BEGIN
79: -- xtr_debug_pkg.enable_debug (null,null);
80: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');
82: END IF;
83:
84: Open BATCH_SEQ;

Line 81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');

77: --
78: BEGIN
79: -- xtr_debug_pkg.enable_debug (null,null);
80: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
81: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journal_Process');
82: END IF;
83:
84: Open BATCH_SEQ;
85: Fetch BATCH_SEQ into p_curr_batch_id;

Line 122: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

118: -- G_end_date := p_period_end;
119:
120: Clear_Journals(G_company_code,G_batch_id);
121:
122: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
123: xtr_debug_pkg.debug('< 124: END IF;
125:
126: Fetch BATCH_SEQ into p_curr_batch_id;

Line 123: xtr_debug_pkg.debug('<

119:
120: Clear_Journals(G_company_code,G_batch_id);
121:
122: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
123: xtr_debug_pkg.debug('< 124: END IF;
125:
126: Fetch BATCH_SEQ into p_curr_batch_id;
127: END LOOP;

Line 182: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

178: l_batch_type XTR_BATCHES.batch_type%TYPE := null;
179: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';
180: --
181: Begin
182: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');
184: xtr_debug_pkg.debug('CLEAR_JOURNALS: ' || 'Current Batch = ' || to_char(in_batch_id));
185: END IF;
186:

Line 183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');

179: p_event_code XTR_BATCH_EVENTS.EVENT_CODE%TYPE :='JRNLGN';
180: --
181: Begin
182: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');
184: xtr_debug_pkg.debug('CLEAR_JOURNALS: ' || 'Current Batch = ' || to_char(in_batch_id));
185: END IF;
186:
187: -- Turn BATCH_ID to null value once we delete journals.

Line 184: xtr_debug_pkg.debug('CLEAR_JOURNALS: ' || 'Current Batch = ' || to_char(in_batch_id));

180: --
181: Begin
182: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
183: xtr_debug_pkg.debug('>>XTR_CLEAR_JOURNAL_PROCESS_P.Clear_Journals');
184: xtr_debug_pkg.debug('CLEAR_JOURNALS: ' || 'Current Batch = ' || to_char(in_batch_id));
185: END IF;
186:
187: -- Turn BATCH_ID to null value once we delete journals.
188: Update XTR_DEAL_DATE_AMOUNTS

Line 219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN

215: End If;
216:
217: Commit;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('< 221: END IF;
222:
223: End CLEAR_JOURNALS;

Line 220: xtr_debug_pkg.debug('<

216:
217: Commit;
218:
219: IF xtr_debug_pkg.pg_sqlplus_enable_flag = 1 THEN
220: xtr_debug_pkg.debug('< 221: END IF;
222:
223: End CLEAR_JOURNALS;
224: