APPS.JA_CN_CFS_CONC_PROG dependencies on FND_LOG

Line 145: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

141: p_destination_filename IN VARCHAR2) IS
142: l_error_flag VARCHAR2(1) := 'N';
143: l_error_status BOOLEAN;
144:
145: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
146: l_proc_level NUMBER := FND_LOG.Level_Procedure;
147: l_proc_name VARCHAR2(100) := 'Cfs_Generate';
148:
149: BEGIN

Line 146: l_proc_level NUMBER := FND_LOG.Level_Procedure;

142: l_error_flag VARCHAR2(1) := 'N';
143: l_error_status BOOLEAN;
144:
145: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
146: l_proc_level NUMBER := FND_LOG.Level_Procedure;
147: l_proc_name VARCHAR2(100) := 'Cfs_Generate';
148:
149: BEGIN
150:

Line 153: FND_LOG.String(l_proc_level,

149: BEGIN
150:
151: --log for debug
152: IF (l_proc_level >= l_dbg_level) THEN
153: FND_LOG.String(l_proc_level,
154: l_module_prefix || '.' || l_proc_name || '.begin',
155: 'Enter procedure');
156:
157: FND_LOG.String(l_proc_level,

Line 157: FND_LOG.String(l_proc_level,

153: FND_LOG.String(l_proc_level,
154: l_module_prefix || '.' || l_proc_name || '.begin',
155: 'Enter procedure');
156:
157: FND_LOG.String(l_proc_level,
158: l_module_prefix || '.' || l_proc_name || '.parameters',
159: 'p_legal_entity_id ' || p_legal_entity_id);
160:
161: FND_LOG.String(l_proc_level,

Line 161: FND_LOG.String(l_proc_level,

157: FND_LOG.String(l_proc_level,
158: l_module_prefix || '.' || l_proc_name || '.parameters',
159: 'p_legal_entity_id ' || p_legal_entity_id);
160:
161: FND_LOG.String(l_proc_level,
162: l_module_prefix || '.' || l_proc_name || '.parameters',
163: 'p_ledger_id ' || p_ledger_id);
164:
165: FND_LOG.String(l_proc_level,

Line 165: FND_LOG.String(l_proc_level,

161: FND_LOG.String(l_proc_level,
162: l_module_prefix || '.' || l_proc_name || '.parameters',
163: 'p_ledger_id ' || p_ledger_id);
164:
165: FND_LOG.String(l_proc_level,
166: l_module_prefix || '.' || l_proc_name || '.parameters',
167: 'p_coa_id ' || p_coa_id);
168:
169: FND_LOG.String(l_proc_level,

Line 169: FND_LOG.String(l_proc_level,

165: FND_LOG.String(l_proc_level,
166: l_module_prefix || '.' || l_proc_name || '.parameters',
167: 'p_coa_id ' || p_coa_id);
168:
169: FND_LOG.String(l_proc_level,
170: l_module_prefix || '.' || l_proc_name || '.parameters',
171: 'p_adhoc_prefix ' || p_adhoc_prefix);
172:
173: FND_LOG.String(l_proc_level,

Line 173: FND_LOG.String(l_proc_level,

169: FND_LOG.String(l_proc_level,
170: l_module_prefix || '.' || l_proc_name || '.parameters',
171: 'p_adhoc_prefix ' || p_adhoc_prefix);
172:
173: FND_LOG.String(l_proc_level,
174: l_module_prefix || '.' || l_proc_name || '.parameters',
175: 'p_industry ' || p_industry);
176:
177: FND_LOG.String(l_proc_level,

Line 177: FND_LOG.String(l_proc_level,

173: FND_LOG.String(l_proc_level,
174: l_module_prefix || '.' || l_proc_name || '.parameters',
175: 'p_industry ' || p_industry);
176:
177: FND_LOG.String(l_proc_level,
178: l_module_prefix || '.' || l_proc_name || '.parameters',
179: 'p_id_flex_code ' || p_id_flex_code);
180:
181: FND_LOG.String(l_proc_level,

Line 181: FND_LOG.String(l_proc_level,

177: FND_LOG.String(l_proc_level,
178: l_module_prefix || '.' || l_proc_name || '.parameters',
179: 'p_id_flex_code ' || p_id_flex_code);
180:
181: FND_LOG.String(l_proc_level,
182: l_module_prefix || '.' || l_proc_name || '.parameters',
183: 'p_report_id ' || p_report_id);
184:
185: FND_LOG.String(l_proc_level,

Line 185: FND_LOG.String(l_proc_level,

181: FND_LOG.String(l_proc_level,
182: l_module_prefix || '.' || l_proc_name || '.parameters',
183: 'p_report_id ' || p_report_id);
184:
185: FND_LOG.String(l_proc_level,
186: l_module_prefix || '.' || l_proc_name || '.parameters',
187: 'p_period_name ' || p_period_name);
188:
189: FND_LOG.String(l_proc_level,

Line 189: FND_LOG.String(l_proc_level,

185: FND_LOG.String(l_proc_level,
186: l_module_prefix || '.' || l_proc_name || '.parameters',
187: 'p_period_name ' || p_period_name);
188:
189: FND_LOG.String(l_proc_level,
190: l_module_prefix || '.' || l_proc_name || '.parameters',
191: 'p_axis_set_id ' || p_axis_set_id);
192:
193: FND_LOG.String(l_proc_level,

Line 193: FND_LOG.String(l_proc_level,

189: FND_LOG.String(l_proc_level,
190: l_module_prefix || '.' || l_proc_name || '.parameters',
191: 'p_axis_set_id ' || p_axis_set_id);
192:
193: FND_LOG.String(l_proc_level,
194: l_module_prefix || '.' || l_proc_name || '.parameters',
195: 'p_colset_id ' || p_colset_id);
196:
197: FND_LOG.String(l_proc_level,

Line 197: FND_LOG.String(l_proc_level,

193: FND_LOG.String(l_proc_level,
194: l_module_prefix || '.' || l_proc_name || '.parameters',
195: 'p_colset_id ' || p_colset_id);
196:
197: FND_LOG.String(l_proc_level,
198: l_module_prefix || '.' || l_proc_name || '.parameters',
199: 'p_rounding_option ' || p_rounding_option);
200:
201: FND_LOG.String(l_proc_level,

Line 201: FND_LOG.String(l_proc_level,

197: FND_LOG.String(l_proc_level,
198: l_module_prefix || '.' || l_proc_name || '.parameters',
199: 'p_rounding_option ' || p_rounding_option);
200:
201: FND_LOG.String(l_proc_level,
202: l_module_prefix || '.' || l_proc_name || '.parameters',
203: 'p_segment_override ' || p_segment_override);
204:
205: FND_LOG.String(l_proc_level,

Line 205: FND_LOG.String(l_proc_level,

201: FND_LOG.String(l_proc_level,
202: l_module_prefix || '.' || l_proc_name || '.parameters',
203: 'p_segment_override ' || p_segment_override);
204:
205: FND_LOG.String(l_proc_level,
206: l_module_prefix || '.' || l_proc_name || '.parameters',
207: 'p_accounting_date ' || p_accounting_date);
208:
209: FND_LOG.String(l_proc_level,

Line 209: FND_LOG.String(l_proc_level,

205: FND_LOG.String(l_proc_level,
206: l_module_prefix || '.' || l_proc_name || '.parameters',
207: 'p_accounting_date ' || p_accounting_date);
208:
209: FND_LOG.String(l_proc_level,
210: l_module_prefix || '.' || l_proc_name || '.parameters',
211: 'p_parameter_set_id ' || p_parameter_set_id);
212:
213: FND_LOG.String(l_proc_level,

Line 213: FND_LOG.String(l_proc_level,

209: FND_LOG.String(l_proc_level,
210: l_module_prefix || '.' || l_proc_name || '.parameters',
211: 'p_parameter_set_id ' || p_parameter_set_id);
212:
213: FND_LOG.String(l_proc_level,
214: l_module_prefix || '.' || l_proc_name || '.parameters',
215: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
216:
217: FND_LOG.String(l_proc_level,

Line 217: FND_LOG.String(l_proc_level,

213: FND_LOG.String(l_proc_level,
214: l_module_prefix || '.' || l_proc_name || '.parameters',
215: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
216:
217: FND_LOG.String(l_proc_level,
218: l_module_prefix || '.' || l_proc_name || '.parameters',
219: 'p_balance_type ' || p_balance_type);
220:
221: /* FND_LOG.String(l_proc_level

Line 221: /* FND_LOG.String(l_proc_level

217: FND_LOG.String(l_proc_level,
218: l_module_prefix || '.' || l_proc_name || '.parameters',
219: 'p_balance_type ' || p_balance_type);
220:
221: /* FND_LOG.String(l_proc_level
222: ,l_module_prefix||'.'||l_proc_name||'.parameters'
223: ,'p_internal_trx_flag '||p_internal_trx_flag
224: );*/
225:

Line 226: FND_LOG.String(l_proc_level,

222: ,l_module_prefix||'.'||l_proc_name||'.parameters'
223: ,'p_internal_trx_flag '||p_internal_trx_flag
224: );*/
225:
226: FND_LOG.String(l_proc_level,
227: l_module_prefix || '.' || l_proc_name || '.parameters',
228: 'p_xml_template_language ' || p_xml_template_language);
229:
230: FND_LOG.String(l_proc_level,

Line 230: FND_LOG.String(l_proc_level,

226: FND_LOG.String(l_proc_level,
227: l_module_prefix || '.' || l_proc_name || '.parameters',
228: 'p_xml_template_language ' || p_xml_template_language);
229:
230: FND_LOG.String(l_proc_level,
231: l_module_prefix || '.' || l_proc_name || '.parameters',
232: 'p_xml_template_territory ' ||
233: p_xml_template_territory);
234:

Line 235: FND_LOG.String(l_proc_level,

231: l_module_prefix || '.' || l_proc_name || '.parameters',
232: 'p_xml_template_territory ' ||
233: p_xml_template_territory);
234:
235: FND_LOG.String(l_proc_level,
236: l_module_prefix || '.' || l_proc_name || '.parameters',
237: 'p_xml_output_format ' || p_xml_output_format);
238:
239: FND_LOG.String(l_proc_level,

Line 239: FND_LOG.String(l_proc_level,

235: FND_LOG.String(l_proc_level,
236: l_module_prefix || '.' || l_proc_name || '.parameters',
237: 'p_xml_output_format ' || p_xml_output_format);
238:
239: FND_LOG.String(l_proc_level,
240: l_module_prefix || '.' || l_proc_name || '.parameters',
241: 'p_source_charset ' || p_source_charset);
242:
243: FND_LOG.String(l_proc_level,

Line 243: FND_LOG.String(l_proc_level,

239: FND_LOG.String(l_proc_level,
240: l_module_prefix || '.' || l_proc_name || '.parameters',
241: 'p_source_charset ' || p_source_charset);
242:
243: FND_LOG.String(l_proc_level,
244: l_module_prefix || '.' || l_proc_name || '.parameters',
245: 'p_destination_charset ' || p_destination_charset);
246:
247: FND_LOG.String(l_proc_level,

Line 247: FND_LOG.String(l_proc_level,

243: FND_LOG.String(l_proc_level,
244: l_module_prefix || '.' || l_proc_name || '.parameters',
245: 'p_destination_charset ' || p_destination_charset);
246:
247: FND_LOG.String(l_proc_level,
248: l_module_prefix || '.' || l_proc_name || '.parameters',
249: 'p_source_separator ' || p_source_separator);
250:
251: FND_LOG.String(l_proc_level,

Line 251: FND_LOG.String(l_proc_level,

247: FND_LOG.String(l_proc_level,
248: l_module_prefix || '.' || l_proc_name || '.parameters',
249: 'p_source_separator ' || p_source_separator);
250:
251: FND_LOG.String(l_proc_level,
252: l_module_prefix || '.' || l_proc_name || '.parameters',
253: 'p_destination_filename ' || p_destination_filename);
254: END IF; --(l_proc_level >= l_dbg_level)
255:

Line 316: FND_LOG.STRING(l_proc_level,

312:
313: END IF; --JA_CN_UTILITY.Check_Profile
314: --log for debug
315: IF (l_proc_level >= l_dbg_level) THEN
316: FND_LOG.STRING(l_proc_level,
317: l_module_prefix || '.' || l_proc_name || '.end',
318: 'Exit procedure');
319: END IF; --( l_proc_level >= l_dbg_level )
320:

Line 324: FND_LOG.String(l_proc_level,

320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: IF (l_proc_level >= l_dbg_level) THEN
324: FND_LOG.String(l_proc_level,
325: l_module_prefix || '.' || l_proc_name ||
326: '. Other_Exception ',
327: SQLCODE || ':' || SQLERRM);
328: END IF; --(l_proc_level >= l_dbg_level)

Line 383: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

379: ,p_coa IN NUMBER
380: ,p_segment_override IN VARCHAR2 -- Added for CNAO Enhancement
381: ) IS
382: l_error_status BOOLEAN;
383: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
384: l_proc_level NUMBER := FND_LOG.Level_Procedure;
385: l_proc_name VARCHAR2(100) := 'Cfs_Calculate';
386:
387: BEGIN

Line 384: l_proc_level NUMBER := FND_LOG.Level_Procedure;

380: ,p_segment_override IN VARCHAR2 -- Added for CNAO Enhancement
381: ) IS
382: l_error_status BOOLEAN;
383: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
384: l_proc_level NUMBER := FND_LOG.Level_Procedure;
385: l_proc_name VARCHAR2(100) := 'Cfs_Calculate';
386:
387: BEGIN
388:

Line 391: FND_LOG.String(l_proc_level,

387: BEGIN
388:
389: --log for debug
390: IF (l_proc_level >= l_dbg_level) THEN
391: FND_LOG.String(l_proc_level,
392: l_module_prefix || '.' || l_proc_name || '.begin',
393: 'Enter procedure');
394:
395: FND_LOG.String(l_proc_level,

Line 395: FND_LOG.String(l_proc_level,

391: FND_LOG.String(l_proc_level,
392: l_module_prefix || '.' || l_proc_name || '.begin',
393: 'Enter procedure');
394:
395: FND_LOG.String(l_proc_level,
396: l_module_prefix || '.' || l_proc_name || '.parameters',
397: 'p_legal_entity_id ' || p_legal_entity_id);
398:
399: FND_LOG.String(l_proc_level,

Line 399: FND_LOG.String(l_proc_level,

395: FND_LOG.String(l_proc_level,
396: l_module_prefix || '.' || l_proc_name || '.parameters',
397: 'p_legal_entity_id ' || p_legal_entity_id);
398:
399: FND_LOG.String(l_proc_level,
400: l_module_prefix || '.' || l_proc_name || '.parameters',
401: 'p_ledger_id ' || p_ledger_id);
402:
403: FND_LOG.String(l_proc_level,

Line 403: FND_LOG.String(l_proc_level,

399: FND_LOG.String(l_proc_level,
400: l_module_prefix || '.' || l_proc_name || '.parameters',
401: 'p_ledger_id ' || p_ledger_id);
402:
403: FND_LOG.String(l_proc_level,
404: l_module_prefix || '.' || l_proc_name || '.parameters',
405: 'p_period_name ' || p_period_name);
406:
407: FND_LOG.String(l_proc_level,

Line 407: FND_LOG.String(l_proc_level,

403: FND_LOG.String(l_proc_level,
404: l_module_prefix || '.' || l_proc_name || '.parameters',
405: 'p_period_name ' || p_period_name);
406:
407: FND_LOG.String(l_proc_level,
408: l_module_prefix || '.' || l_proc_name || '.parameters',
409: 'p_axis_set_id ' || p_axis_set_id);
410:
411: FND_LOG.String(l_proc_level,

Line 411: FND_LOG.String(l_proc_level,

407: FND_LOG.String(l_proc_level,
408: l_module_prefix || '.' || l_proc_name || '.parameters',
409: 'p_axis_set_id ' || p_axis_set_id);
410:
411: FND_LOG.String(l_proc_level,
412: l_module_prefix || '.' || l_proc_name || '.parameters',
413: 'p_rounding_option ' || p_rounding_option);
414:
415: FND_LOG.String(l_proc_level,

Line 415: FND_LOG.String(l_proc_level,

411: FND_LOG.String(l_proc_level,
412: l_module_prefix || '.' || l_proc_name || '.parameters',
413: 'p_rounding_option ' || p_rounding_option);
414:
415: FND_LOG.String(l_proc_level,
416: l_module_prefix || '.' || l_proc_name || '.parameters',
417: 'p_balance_type ' || p_balance_type);
418:
419: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

Line 419: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

415: FND_LOG.String(l_proc_level,
416: l_module_prefix || '.' || l_proc_name || '.parameters',
417: 'p_balance_type ' || p_balance_type);
418:
419: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
420: l_module_prefix || '.' || l_proc_name || '.parameters',
421: 'p_segmment_override ' || p_segment_override);
422:
423: /* FND_LOG.String(l_proc_level

Line 423: /* FND_LOG.String(l_proc_level

419: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
420: l_module_prefix || '.' || l_proc_name || '.parameters',
421: 'p_segmment_override ' || p_segment_override);
422:
423: /* FND_LOG.String(l_proc_level
424: ,l_module_prefix||'.'||l_proc_name||'.parameters'
425: ,'p_internal_trx_flag '||p_internal_trx_flag
426: );*/
427:

Line 455: FND_LOG.STRING(l_proc_level,

451: END IF; --JA_CN_UTILITY.Check_Profile
452:
453: --log for debug
454: IF (l_proc_level >= l_dbg_level) THEN
455: FND_LOG.STRING(l_proc_level,
456: l_module_prefix || '.' || l_proc_name || '.end',
457: 'Exit procedure');
458: END IF; --( l_proc_level >= l_dbg_level )
459:

Line 463: FND_LOG.String(l_proc_level,

459:
460: EXCEPTION
461: WHEN OTHERS THEN
462: IF (l_proc_level >= l_dbg_level) THEN
463: FND_LOG.String(l_proc_level,
464: l_module_prefix || '.' || l_proc_name ||
465: '. Other_Exception ',
466: SQLCODE || ':' || SQLERRM);
467: END IF; --(l_proc_level >= l_dbg_level)

Line 561: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

557: l_flag NUMBER;
558: l_error_flag VARCHAR2(1) := 'N';
559: l_error_status BOOLEAN;
560:
561: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
562: l_proc_level NUMBER := FND_LOG.Level_Procedure;
563: l_proc_name VARCHAR2(100) := 'Cfsse_Generate';
564:
565: BEGIN

Line 562: l_proc_level NUMBER := FND_LOG.Level_Procedure;

558: l_error_flag VARCHAR2(1) := 'N';
559: l_error_status BOOLEAN;
560:
561: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
562: l_proc_level NUMBER := FND_LOG.Level_Procedure;
563: l_proc_name VARCHAR2(100) := 'Cfsse_Generate';
564:
565: BEGIN
566: --log for debug

Line 569: FND_LOG.String(l_proc_level,

565: BEGIN
566: --log for debug
567: IF (l_proc_level >= l_dbg_level)
568: THEN
569: FND_LOG.String(l_proc_level,
570: l_module_prefix || '.' || l_proc_name || '.begin',
571: 'Enter procedure');
572:
573: FND_LOG.String(l_proc_level,

Line 573: FND_LOG.String(l_proc_level,

569: FND_LOG.String(l_proc_level,
570: l_module_prefix || '.' || l_proc_name || '.begin',
571: 'Enter procedure');
572:
573: FND_LOG.String(l_proc_level,
574: l_module_prefix || '.' || l_proc_name || '.parameters',
575: 'p_legal_entity_id ' || p_legal_entity_id);
576:
577: FND_LOG.String(l_proc_level,

Line 577: FND_LOG.String(l_proc_level,

573: FND_LOG.String(l_proc_level,
574: l_module_prefix || '.' || l_proc_name || '.parameters',
575: 'p_legal_entity_id ' || p_legal_entity_id);
576:
577: FND_LOG.String(l_proc_level,
578: l_module_prefix || '.' || l_proc_name || '.parameters',
579: 'p_ledger_id ' || p_ledger_id);
580:
581: FND_LOG.String(l_proc_level,

Line 581: FND_LOG.String(l_proc_level,

577: FND_LOG.String(l_proc_level,
578: l_module_prefix || '.' || l_proc_name || '.parameters',
579: 'p_ledger_id ' || p_ledger_id);
580:
581: FND_LOG.String(l_proc_level,
582: l_module_prefix || '.' || l_proc_name || '.parameters',
583: 'p_coa_id ' || p_coa_id);
584:
585: FND_LOG.String(l_proc_level,

Line 585: FND_LOG.String(l_proc_level,

581: FND_LOG.String(l_proc_level,
582: l_module_prefix || '.' || l_proc_name || '.parameters',
583: 'p_coa_id ' || p_coa_id);
584:
585: FND_LOG.String(l_proc_level,
586: l_module_prefix || '.' || l_proc_name || '.parameters',
587: 'p_adhoc_prefix ' || p_adhoc_prefix);
588:
589: FND_LOG.String(l_proc_level,

Line 589: FND_LOG.String(l_proc_level,

585: FND_LOG.String(l_proc_level,
586: l_module_prefix || '.' || l_proc_name || '.parameters',
587: 'p_adhoc_prefix ' || p_adhoc_prefix);
588:
589: FND_LOG.String(l_proc_level,
590: l_module_prefix || '.' || l_proc_name || '.parameters',
591: 'p_industry ' || p_industry);
592:
593: FND_LOG.String(l_proc_level,

Line 593: FND_LOG.String(l_proc_level,

589: FND_LOG.String(l_proc_level,
590: l_module_prefix || '.' || l_proc_name || '.parameters',
591: 'p_industry ' || p_industry);
592:
593: FND_LOG.String(l_proc_level,
594: l_module_prefix || '.' || l_proc_name || '.parameters',
595: 'p_id_flex_code ' || p_id_flex_code);
596:
597: FND_LOG.String(l_proc_level,

Line 597: FND_LOG.String(l_proc_level,

593: FND_LOG.String(l_proc_level,
594: l_module_prefix || '.' || l_proc_name || '.parameters',
595: 'p_id_flex_code ' || p_id_flex_code);
596:
597: FND_LOG.String(l_proc_level,
598: l_module_prefix || '.' || l_proc_name || '.parameters',
599: 'p_report_id ' || p_report_id);
600:
601: FND_LOG.String(l_proc_level,

Line 601: FND_LOG.String(l_proc_level,

597: FND_LOG.String(l_proc_level,
598: l_module_prefix || '.' || l_proc_name || '.parameters',
599: 'p_report_id ' || p_report_id);
600:
601: FND_LOG.String(l_proc_level,
602: l_module_prefix || '.' || l_proc_name || '.parameters',
603: 'p_period_name ' || p_period_name);
604:
605: FND_LOG.String(l_proc_level,

Line 605: FND_LOG.String(l_proc_level,

601: FND_LOG.String(l_proc_level,
602: l_module_prefix || '.' || l_proc_name || '.parameters',
603: 'p_period_name ' || p_period_name);
604:
605: FND_LOG.String(l_proc_level,
606: l_module_prefix || '.' || l_proc_name || '.parameters',
607: 'p_axis_set_id ' || p_axis_set_id);
608:
609: FND_LOG.String(l_proc_level,

Line 609: FND_LOG.String(l_proc_level,

605: FND_LOG.String(l_proc_level,
606: l_module_prefix || '.' || l_proc_name || '.parameters',
607: 'p_axis_set_id ' || p_axis_set_id);
608:
609: FND_LOG.String(l_proc_level,
610: l_module_prefix || '.' || l_proc_name || '.parameters',
611: 'p_colset_id ' || p_colset_id);
612:
613: FND_LOG.String(l_proc_level,

Line 613: FND_LOG.String(l_proc_level,

609: FND_LOG.String(l_proc_level,
610: l_module_prefix || '.' || l_proc_name || '.parameters',
611: 'p_colset_id ' || p_colset_id);
612:
613: FND_LOG.String(l_proc_level,
614: l_module_prefix || '.' || l_proc_name || '.parameters',
615: 'p_rounding_option ' || p_rounding_option);
616:
617: FND_LOG.String(l_proc_level,

Line 617: FND_LOG.String(l_proc_level,

613: FND_LOG.String(l_proc_level,
614: l_module_prefix || '.' || l_proc_name || '.parameters',
615: 'p_rounding_option ' || p_rounding_option);
616:
617: FND_LOG.String(l_proc_level,
618: l_module_prefix || '.' || l_proc_name || '.parameters',
619: 'p_segment_override ' || p_segment_override);
620:
621: FND_LOG.String(l_proc_level,

Line 621: FND_LOG.String(l_proc_level,

617: FND_LOG.String(l_proc_level,
618: l_module_prefix || '.' || l_proc_name || '.parameters',
619: 'p_segment_override ' || p_segment_override);
620:
621: FND_LOG.String(l_proc_level,
622: l_module_prefix || '.' || l_proc_name || '.parameters',
623: 'p_accounting_date ' || p_accounting_date);
624:
625: FND_LOG.String(l_proc_level,

Line 625: FND_LOG.String(l_proc_level,

621: FND_LOG.String(l_proc_level,
622: l_module_prefix || '.' || l_proc_name || '.parameters',
623: 'p_accounting_date ' || p_accounting_date);
624:
625: FND_LOG.String(l_proc_level,
626: l_module_prefix || '.' || l_proc_name || '.parameters',
627: 'p_parameter_set_id ' || p_parameter_set_id);
628:
629: FND_LOG.String(l_proc_level,

Line 629: FND_LOG.String(l_proc_level,

625: FND_LOG.String(l_proc_level,
626: l_module_prefix || '.' || l_proc_name || '.parameters',
627: 'p_parameter_set_id ' || p_parameter_set_id);
628:
629: FND_LOG.String(l_proc_level,
630: l_module_prefix || '.' || l_proc_name || '.parameters',
631: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
632:
633: FND_LOG.String(l_proc_level,

Line 633: FND_LOG.String(l_proc_level,

629: FND_LOG.String(l_proc_level,
630: l_module_prefix || '.' || l_proc_name || '.parameters',
631: 'P_PAGE_LENGTH ' || P_PAGE_LENGTH);
632:
633: FND_LOG.String(l_proc_level,
634: l_module_prefix || '.' || l_proc_name || '.parameters',
635: 'p_balance_type ' || p_balance_type);
636:
637: /* FND_LOG.String(l_proc_level

Line 637: /* FND_LOG.String(l_proc_level

633: FND_LOG.String(l_proc_level,
634: l_module_prefix || '.' || l_proc_name || '.parameters',
635: 'p_balance_type ' || p_balance_type);
636:
637: /* FND_LOG.String(l_proc_level
638: ,l_module_prefix||'.'||l_proc_name||'.parameters'
639: ,'p_internal_trx_flag '||p_internal_trx_flag
640: );*/
641:

Line 642: FND_LOG.String(l_proc_level,

638: ,l_module_prefix||'.'||l_proc_name||'.parameters'
639: ,'p_internal_trx_flag '||p_internal_trx_flag
640: );*/
641:
642: FND_LOG.String(l_proc_level,
643: l_module_prefix || '.' || l_proc_name || '.parameters',
644: 'p_xml_template_language ' || p_xml_template_language);
645:
646: FND_LOG.String(l_proc_level,

Line 646: FND_LOG.String(l_proc_level,

642: FND_LOG.String(l_proc_level,
643: l_module_prefix || '.' || l_proc_name || '.parameters',
644: 'p_xml_template_language ' || p_xml_template_language);
645:
646: FND_LOG.String(l_proc_level,
647: l_module_prefix || '.' || l_proc_name || '.parameters',
648: 'p_xml_template_territory ' ||
649: p_xml_template_territory);
650:

Line 651: FND_LOG.String(l_proc_level,

647: l_module_prefix || '.' || l_proc_name || '.parameters',
648: 'p_xml_template_territory ' ||
649: p_xml_template_territory);
650:
651: FND_LOG.String(l_proc_level,
652: l_module_prefix || '.' || l_proc_name || '.parameters',
653: 'p_xml_output_format ' || p_xml_output_format);
654:
655: FND_LOG.String(l_proc_level,

Line 655: FND_LOG.String(l_proc_level,

651: FND_LOG.String(l_proc_level,
652: l_module_prefix || '.' || l_proc_name || '.parameters',
653: 'p_xml_output_format ' || p_xml_output_format);
654:
655: FND_LOG.String(l_proc_level,
656: l_module_prefix || '.' || l_proc_name || '.parameters',
657: 'p_source_charset ' || p_source_charset);
658:
659: FND_LOG.String(l_proc_level,

Line 659: FND_LOG.String(l_proc_level,

655: FND_LOG.String(l_proc_level,
656: l_module_prefix || '.' || l_proc_name || '.parameters',
657: 'p_source_charset ' || p_source_charset);
658:
659: FND_LOG.String(l_proc_level,
660: l_module_prefix || '.' || l_proc_name || '.parameters',
661: 'p_destination_charset ' || p_destination_charset);
662:
663: FND_LOG.String(l_proc_level,

Line 663: FND_LOG.String(l_proc_level,

659: FND_LOG.String(l_proc_level,
660: l_module_prefix || '.' || l_proc_name || '.parameters',
661: 'p_destination_charset ' || p_destination_charset);
662:
663: FND_LOG.String(l_proc_level,
664: l_module_prefix || '.' || l_proc_name || '.parameters',
665: 'p_source_separator ' || p_source_separator);
666:
667: FND_LOG.String(l_proc_level,

Line 667: FND_LOG.String(l_proc_level,

663: FND_LOG.String(l_proc_level,
664: l_module_prefix || '.' || l_proc_name || '.parameters',
665: 'p_source_separator ' || p_source_separator);
666:
667: FND_LOG.String(l_proc_level,
668: l_module_prefix || '.' || l_proc_name || '.parameters',
669: 'p_destination_filename ' || p_destination_filename);
670: END IF; --(l_proc_level >= l_dbg_level)
671:

Line 752: FND_LOG.STRING(l_proc_level,

748:
749: --log for debug
750: IF (l_proc_level >= l_dbg_level)
751: THEN
752: FND_LOG.STRING(l_proc_level,
753: l_module_prefix || '.' || l_proc_name || '.end',
754: 'Exit procedure');
755: END IF; --( l_proc_level >= l_dbg_level )
756:

Line 761: FND_LOG.STRING(l_proc_level,

757: EXCEPTION
758: WHEN OTHERS THEN
759: IF (l_proc_level >= l_dbg_level)
760: THEN
761: FND_LOG.STRING(l_proc_level,
762: l_module_prefix || '.' || l_proc_name ||
763: '. Other_Exception ',
764: SQLCODE || ':' || SQLERRM);
765: END IF; --(l_proc_level >= l_dbg_level)

Line 814: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

810: l_flag NUMBER;
811: l_error_flag VARCHAR2(1) := 'N';
812: l_error_status BOOLEAN;
813:
814: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
815: l_proc_level NUMBER := FND_LOG.Level_Procedure;
816: l_proc_name VARCHAR2(100) := 'Cfsse_Calculate';
817:
818: BEGIN

Line 815: l_proc_level NUMBER := FND_LOG.Level_Procedure;

811: l_error_flag VARCHAR2(1) := 'N';
812: l_error_status BOOLEAN;
813:
814: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
815: l_proc_level NUMBER := FND_LOG.Level_Procedure;
816: l_proc_name VARCHAR2(100) := 'Cfsse_Calculate';
817:
818: BEGIN
819: --log for debug

Line 822: FND_LOG.STRING(l_proc_level,

818: BEGIN
819: --log for debug
820: IF (l_proc_level >= l_dbg_level)
821: THEN
822: FND_LOG.STRING(l_proc_level,
823: l_module_prefix || '.' || l_proc_name || '.begin',
824: 'Enter procedure');
825:
826: FND_LOG.STRING(l_proc_level,

Line 826: FND_LOG.STRING(l_proc_level,

822: FND_LOG.STRING(l_proc_level,
823: l_module_prefix || '.' || l_proc_name || '.begin',
824: 'Enter procedure');
825:
826: FND_LOG.STRING(l_proc_level,
827: l_module_prefix || '.' || l_proc_name || '.parameters',
828: 'p_legal_entity_id ' || p_legal_entity_id);
829: FND_LOG.STRING(l_proc_level,
830: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 829: FND_LOG.STRING(l_proc_level,

825:
826: FND_LOG.STRING(l_proc_level,
827: l_module_prefix || '.' || l_proc_name || '.parameters',
828: 'p_legal_entity_id ' || p_legal_entity_id);
829: FND_LOG.STRING(l_proc_level,
830: l_module_prefix || '.' || l_proc_name || '.parameters',
831: 'p_period_name ' || p_period_name);
832:
833: FND_LOG.STRING(l_proc_level,

Line 833: FND_LOG.STRING(l_proc_level,

829: FND_LOG.STRING(l_proc_level,
830: l_module_prefix || '.' || l_proc_name || '.parameters',
831: 'p_period_name ' || p_period_name);
832:
833: FND_LOG.STRING(l_proc_level,
834: l_module_prefix || '.' || l_proc_name || '.parameters',
835: 'p_axis_set_id ' || p_axis_set_id);
836:
837: FND_LOG.STRING(l_proc_level,

Line 837: FND_LOG.STRING(l_proc_level,

833: FND_LOG.STRING(l_proc_level,
834: l_module_prefix || '.' || l_proc_name || '.parameters',
835: 'p_axis_set_id ' || p_axis_set_id);
836:
837: FND_LOG.STRING(l_proc_level,
838: l_module_prefix || '.' || l_proc_name || '.parameters',
839: 'p_rounding_option ' || p_rounding_option);
840:
841: FND_LOG.STRING(l_proc_level,

Line 841: FND_LOG.STRING(l_proc_level,

837: FND_LOG.STRING(l_proc_level,
838: l_module_prefix || '.' || l_proc_name || '.parameters',
839: 'p_rounding_option ' || p_rounding_option);
840:
841: FND_LOG.STRING(l_proc_level,
842: l_module_prefix || '.' || l_proc_name || '.parameters',
843: 'p_balance_type ' || p_balance_type);
844:
845: /* FND_LOG.STRING(l_proc_level,

Line 845: /* FND_LOG.STRING(l_proc_level,

841: FND_LOG.STRING(l_proc_level,
842: l_module_prefix || '.' || l_proc_name || '.parameters',
843: 'p_balance_type ' || p_balance_type);
844:
845: /* FND_LOG.STRING(l_proc_level,
846: l_module_prefix || '.' || l_proc_name || '.parameters',
847: 'p_internal_trx_flag ' || p_internal_trx_flag) ;*/
848: END IF; --(l_proc_level >= l_dbg_level)
849:

Line 903: FND_LOG.STRING(l_proc_level,

899:
900: --log for debug
901: IF (l_proc_level >= l_dbg_level)
902: THEN
903: FND_LOG.STRING(l_proc_level,
904: l_module_prefix || '.' || l_proc_name || '.end',
905: 'Exit procedure');
906: END IF; --( l_proc_level >= l_dbg_level )
907:

Line 912: FND_LOG.STRING(l_proc_level,

908: EXCEPTION
909: WHEN OTHERS THEN
910: IF (l_proc_level >= l_dbg_level)
911: THEN
912: FND_LOG.STRING(l_proc_level,
913: l_module_prefix || '.' || l_proc_name ||
914: '. Other_Exception ',
915: SQLCODE || ':' || SQLERRM);
916: END IF; --(l_proc_level >= l_dbg_level)

Line 953: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

949: p_LEDGER_ID IN NUMBER,
950: P_GL_PERIOD_FROM IN VARCHAR2,
951: P_GL_PERIOD_TO IN VARCHAR2,
952: P_SOURCE IN VARCHAR2) IS
953: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
954: l_proc_level NUMBER := FND_LOG.Level_Procedure;
955: l_proc_name VARCHAR2(100) := 'Collect_Cfs_Data';
956: l_flag VARCHAR2(15); --populate the ledger and the legal entity flag
957:

Line 954: l_proc_level NUMBER := FND_LOG.Level_Procedure;

950: P_GL_PERIOD_FROM IN VARCHAR2,
951: P_GL_PERIOD_TO IN VARCHAR2,
952: P_SOURCE IN VARCHAR2) IS
953: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
954: l_proc_level NUMBER := FND_LOG.Level_Procedure;
955: l_proc_name VARCHAR2(100) := 'Collect_Cfs_Data';
956: l_flag VARCHAR2(15); --populate the ledger and the legal entity flag
957:
958: JA_CN_INVALID_GLPERIOD exception;

Line 970: FND_LOG.String(l_proc_level,

966: l_year_to NUMBER;
967: BEGIN
968: --log for debug
969: IF (l_proc_level >= l_dbg_level) THEN
970: FND_LOG.String(l_proc_level,
971: l_module_prefix || '.' || l_proc_name || '.begin',
972: 'Enter procedure');
973: FND_LOG.String(l_proc_level,
974: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 973: FND_LOG.String(l_proc_level,

969: IF (l_proc_level >= l_dbg_level) THEN
970: FND_LOG.String(l_proc_level,
971: l_module_prefix || '.' || l_proc_name || '.begin',
972: 'Enter procedure');
973: FND_LOG.String(l_proc_level,
974: l_module_prefix || '.' || l_proc_name || '.parameters',
975: 'P_LE_ID ' || P_LE_ID);
976: FND_LOG.String(l_proc_level,
977: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 976: FND_LOG.String(l_proc_level,

972: 'Enter procedure');
973: FND_LOG.String(l_proc_level,
974: l_module_prefix || '.' || l_proc_name || '.parameters',
975: 'P_LE_ID ' || P_LE_ID);
976: FND_LOG.String(l_proc_level,
977: l_module_prefix || '.' || l_proc_name || '.parameters',
978: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
979: FND_LOG.String(l_proc_level,
980: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 979: FND_LOG.String(l_proc_level,

975: 'P_LE_ID ' || P_LE_ID);
976: FND_LOG.String(l_proc_level,
977: l_module_prefix || '.' || l_proc_name || '.parameters',
978: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
979: FND_LOG.String(l_proc_level,
980: l_module_prefix || '.' || l_proc_name || '.parameters',
981: 'P_GL_PERIOD_TO ' || P_GL_PERIOD_TO);
982: FND_LOG.String(l_proc_level,
983: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 982: FND_LOG.String(l_proc_level,

978: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
979: FND_LOG.String(l_proc_level,
980: l_module_prefix || '.' || l_proc_name || '.parameters',
981: 'P_GL_PERIOD_TO ' || P_GL_PERIOD_TO);
982: FND_LOG.String(l_proc_level,
983: l_module_prefix || '.' || l_proc_name || '.parameters',
984: 'P_SOURCE ' || P_SOURCE);
985: END IF; --(l_proc_level >= l_dbg_level)
986:

Line 1028: FND_LOG.String(l_proc_level,

1024: END IF;
1025:
1026: --log for debug
1027: IF (l_proc_level >= l_dbg_level) THEN
1028: FND_LOG.String(l_proc_level,
1029: l_module_prefix || '.' || l_proc_name || '.end',
1030: 'Exit procedure');
1031: END IF; --(l_proc_level >= l_dbg_level)
1032: ELSE

Line 1041: FND_LOG.String(l_proc_level,

1037: FND_MESSAGE.Set_Name(APPLICATION => 'JA',
1038: NAME => 'JA_CN_INVALID_GLPERIOD');
1039: l_msg_invalid_glperiod := FND_MESSAGE.Get;
1040: IF (l_proc_level >= l_dbg_level) THEN
1041: FND_LOG.String(l_proc_level,
1042: l_module_prefix || '.' || l_proc_name ||
1043: '.JA_CN_INVALID_GLPERIOD ',
1044: l_msg_invalid_glperiod);
1045: END IF; --(l_proc_level >= l_dbg_level)

Line 1050: FND_LOG.String(l_proc_level,

1046: retcode := 1;
1047: errbuf := l_msg_invalid_glperiod;
1048: WHEN OTHERS THEN
1049: IF (l_proc_level >= l_dbg_level) THEN
1050: FND_LOG.String(l_proc_level,
1051: l_module_prefix || '.' || l_proc_name ||
1052: '.Other_Exception ',
1053: SQLCODE || ':' || SQLERRM);
1054: END IF; --(l_proc_level >= l_dbg_level)

Line 1101: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1097: P_SOURCE IN VARCHAR2,
1098: P_JOURNAL_CTG IN VARCHAR2,
1099: P_STATUS IN VARCHAR2,
1100: P_COM_SEG IN VARCHAR2) IS --Added for CNAO Enhancement
1101: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1102: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1103: l_proc_name VARCHAR2(100) := 'GL_Validation';
1104:
1105: BEGIN

Line 1102: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1098: P_JOURNAL_CTG IN VARCHAR2,
1099: P_STATUS IN VARCHAR2,
1100: P_COM_SEG IN VARCHAR2) IS --Added for CNAO Enhancement
1101: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1102: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1103: l_proc_name VARCHAR2(100) := 'GL_Validation';
1104:
1105: BEGIN
1106: --log for debug

Line 1108: FND_LOG.String(l_proc_level,

1104:
1105: BEGIN
1106: --log for debug
1107: IF (l_proc_level >= l_dbg_level) THEN
1108: FND_LOG.String(l_proc_level,
1109: l_module_prefix || '.' || l_proc_name || '.begin',
1110: 'Enter procedure');
1111: FND_LOG.String(l_proc_level,
1112: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1111: FND_LOG.String(l_proc_level,

1107: IF (l_proc_level >= l_dbg_level) THEN
1108: FND_LOG.String(l_proc_level,
1109: l_module_prefix || '.' || l_proc_name || '.begin',
1110: 'Enter procedure');
1111: FND_LOG.String(l_proc_level,
1112: l_module_prefix || '.' || l_proc_name || '.parameters',
1113: 'P_COA_ID ' || P_COA_ID);
1114: FND_LOG.String(l_proc_level,
1115: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1114: FND_LOG.String(l_proc_level,

1110: 'Enter procedure');
1111: FND_LOG.String(l_proc_level,
1112: l_module_prefix || '.' || l_proc_name || '.parameters',
1113: 'P_COA_ID ' || P_COA_ID);
1114: FND_LOG.String(l_proc_level,
1115: l_module_prefix || '.' || l_proc_name || '.parameters',
1116: 'P_LE_ID ' || P_LE_ID);
1117: FND_LOG.String(l_proc_level,
1118: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1117: FND_LOG.String(l_proc_level,

1113: 'P_COA_ID ' || P_COA_ID);
1114: FND_LOG.String(l_proc_level,
1115: l_module_prefix || '.' || l_proc_name || '.parameters',
1116: 'P_LE_ID ' || P_LE_ID);
1117: FND_LOG.String(l_proc_level,
1118: l_module_prefix || '.' || l_proc_name || '.parameters',
1119: 'P_LEDGER_ID ' || P_LEDGER_ID);
1120: FND_LOG.String(l_proc_level,
1121: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1120: FND_LOG.String(l_proc_level,

1116: 'P_LE_ID ' || P_LE_ID);
1117: FND_LOG.String(l_proc_level,
1118: l_module_prefix || '.' || l_proc_name || '.parameters',
1119: 'P_LEDGER_ID ' || P_LEDGER_ID);
1120: FND_LOG.String(l_proc_level,
1121: l_module_prefix || '.' || l_proc_name || '.parameters',
1122: 'P_START_PERIOD ' || P_START_PERIOD);
1123: FND_LOG.String(l_proc_level,
1124: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1123: FND_LOG.String(l_proc_level,

1119: 'P_LEDGER_ID ' || P_LEDGER_ID);
1120: FND_LOG.String(l_proc_level,
1121: l_module_prefix || '.' || l_proc_name || '.parameters',
1122: 'P_START_PERIOD ' || P_START_PERIOD);
1123: FND_LOG.String(l_proc_level,
1124: l_module_prefix || '.' || l_proc_name || '.parameters',
1125: 'P_END_PERIOD ' || P_END_PERIOD);
1126: FND_LOG.String(l_proc_level,
1127: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1126: FND_LOG.String(l_proc_level,

1122: 'P_START_PERIOD ' || P_START_PERIOD);
1123: FND_LOG.String(l_proc_level,
1124: l_module_prefix || '.' || l_proc_name || '.parameters',
1125: 'P_END_PERIOD ' || P_END_PERIOD);
1126: FND_LOG.String(l_proc_level,
1127: l_module_prefix || '.' || l_proc_name || '.parameters',
1128: 'P_SOURCE ' || P_SOURCE);
1129: FND_LOG.String(l_proc_level,
1130: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1129: FND_LOG.String(l_proc_level,

1125: 'P_END_PERIOD ' || P_END_PERIOD);
1126: FND_LOG.String(l_proc_level,
1127: l_module_prefix || '.' || l_proc_name || '.parameters',
1128: 'P_SOURCE ' || P_SOURCE);
1129: FND_LOG.String(l_proc_level,
1130: l_module_prefix || '.' || l_proc_name || '.parameters',
1131: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1132: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1133: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1132: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

1128: 'P_SOURCE ' || P_SOURCE);
1129: FND_LOG.String(l_proc_level,
1130: l_module_prefix || '.' || l_proc_name || '.parameters',
1131: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1132: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1133: l_module_prefix || '.' || l_proc_name || '.parameters',
1134: 'P_COM_SEG ' || P_COM_SEG);
1135: FND_LOG.String(l_proc_level,
1136: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1135: FND_LOG.String(l_proc_level,

1131: 'P_JOURNAL_CTG ' || P_JOURNAL_CTG);
1132: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1133: l_module_prefix || '.' || l_proc_name || '.parameters',
1134: 'P_COM_SEG ' || P_COM_SEG);
1135: FND_LOG.String(l_proc_level,
1136: l_module_prefix || '.' || l_proc_name || '.parameters',
1137: 'P_STATUS ' || P_STATUS);
1138: END IF; --(l_proc_level >= l_dbg_level)
1139:

Line 1162: FND_LOG.String(l_proc_level,

1158: P_COM_SEG => P_COM_SEG); --Added for CNAO Enhancement
1159: EXCEPTION
1160: WHEN OTHERS THEN
1161: IF (l_proc_level >= l_dbg_level) THEN
1162: FND_LOG.String(l_proc_level,
1163: l_module_prefix || '.' || l_proc_name ||
1164: '.Other_Exception ',
1165: SQLCODE || ':' || SQLERRM);
1166: END IF; --(l_proc_level >= l_dbg_level)

Line 1210: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1206: P_END_PERIOD IN VARCHAR2,
1207: P_STATUS IN VARCHAR2,
1208: P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1209: ) IS
1210: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1211: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1212: l_proc_name VARCHAR2(100) := 'GL_Validation';
1213:
1214: BEGIN

Line 1211: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1207: P_STATUS IN VARCHAR2,
1208: P_COM_SEG IN VARCHAR2 --Added for CNAO Enhancement
1209: ) IS
1210: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1211: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1212: l_proc_name VARCHAR2(100) := 'GL_Validation';
1213:
1214: BEGIN
1215: --log for debug

Line 1217: FND_LOG.String(l_proc_level,

1213:
1214: BEGIN
1215: --log for debug
1216: IF (l_proc_level >= l_dbg_level) THEN
1217: FND_LOG.String(l_proc_level,
1218: l_module_prefix || '.' || l_proc_name || '.begin',
1219: 'Enter procedure');
1220: FND_LOG.String(l_proc_level,
1221: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1220: FND_LOG.String(l_proc_level,

1216: IF (l_proc_level >= l_dbg_level) THEN
1217: FND_LOG.String(l_proc_level,
1218: l_module_prefix || '.' || l_proc_name || '.begin',
1219: 'Enter procedure');
1220: FND_LOG.String(l_proc_level,
1221: l_module_prefix || '.' || l_proc_name || '.parameters',
1222: 'P_COA_ID ' || P_COA_ID);
1223: FND_LOG.String(l_proc_level,
1224: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1223: FND_LOG.String(l_proc_level,

1219: 'Enter procedure');
1220: FND_LOG.String(l_proc_level,
1221: l_module_prefix || '.' || l_proc_name || '.parameters',
1222: 'P_COA_ID ' || P_COA_ID);
1223: FND_LOG.String(l_proc_level,
1224: l_module_prefix || '.' || l_proc_name || '.parameters',
1225: 'P_LE_ID ' || P_LE_ID);
1226: FND_LOG.String(l_proc_level,
1227: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1226: FND_LOG.String(l_proc_level,

1222: 'P_COA_ID ' || P_COA_ID);
1223: FND_LOG.String(l_proc_level,
1224: l_module_prefix || '.' || l_proc_name || '.parameters',
1225: 'P_LE_ID ' || P_LE_ID);
1226: FND_LOG.String(l_proc_level,
1227: l_module_prefix || '.' || l_proc_name || '.parameters',
1228: 'P_LEDGER_ID ' || P_LEDGER_ID);
1229: FND_LOG.String(l_proc_level,
1230: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1229: FND_LOG.String(l_proc_level,

1225: 'P_LE_ID ' || P_LE_ID);
1226: FND_LOG.String(l_proc_level,
1227: l_module_prefix || '.' || l_proc_name || '.parameters',
1228: 'P_LEDGER_ID ' || P_LEDGER_ID);
1229: FND_LOG.String(l_proc_level,
1230: l_module_prefix || '.' || l_proc_name || '.parameters',
1231: 'P_START_PERIOD ' || P_START_PERIOD);
1232: FND_LOG.String(l_proc_level,
1233: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1232: FND_LOG.String(l_proc_level,

1228: 'P_LEDGER_ID ' || P_LEDGER_ID);
1229: FND_LOG.String(l_proc_level,
1230: l_module_prefix || '.' || l_proc_name || '.parameters',
1231: 'P_START_PERIOD ' || P_START_PERIOD);
1232: FND_LOG.String(l_proc_level,
1233: l_module_prefix || '.' || l_proc_name || '.parameters',
1234: 'P_END_PERIOD ' || P_END_PERIOD);
1235: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1236: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1235: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement

1231: 'P_START_PERIOD ' || P_START_PERIOD);
1232: FND_LOG.String(l_proc_level,
1233: l_module_prefix || '.' || l_proc_name || '.parameters',
1234: 'P_END_PERIOD ' || P_END_PERIOD);
1235: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1236: l_module_prefix || '.' || l_proc_name || '.parameters',
1237: 'P_COM_SEG ' || P_COM_SEG);
1238: FND_LOG.String(l_proc_level,
1239: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1238: FND_LOG.String(l_proc_level,

1234: 'P_END_PERIOD ' || P_END_PERIOD);
1235: FND_LOG.String(l_proc_level, --Added for CNAO Enhancement
1236: l_module_prefix || '.' || l_proc_name || '.parameters',
1237: 'P_COM_SEG ' || P_COM_SEG);
1238: FND_LOG.String(l_proc_level,
1239: l_module_prefix || '.' || l_proc_name || '.parameters',
1240: 'P_STATUS ' || P_STATUS);
1241: END IF; --(l_proc_level >= l_dbg_level)
1242:

Line 1264: FND_LOG.String(l_proc_level,

1260: );
1261: EXCEPTION
1262: WHEN OTHERS THEN
1263: IF (l_proc_level >= l_dbg_level) THEN
1264: FND_LOG.String(l_proc_level,
1265: l_module_prefix || '.' || l_proc_name ||
1266: '.Other_Exception ',
1267: SQLCODE || ':' || SQLERRM);
1268: END IF; --(l_proc_level >= l_dbg_level)

Line 1369: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;

1365: P_SOURCE IN VARCHAR2,
1366: P_BSV IN VARCHAR2) is--Fix Bug#7334017 add
1367:
1368: l_error_status BOOLEAN;
1369: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1370: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1371: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1372: begin
1373: --log for debug

Line 1370: l_proc_level NUMBER := FND_LOG.Level_Procedure;

1366: P_BSV IN VARCHAR2) is--Fix Bug#7334017 add
1367:
1368: l_error_status BOOLEAN;
1369: l_dbg_level NUMBER := FND_LOG.G_Current_Runtime_Level;
1370: l_proc_level NUMBER := FND_LOG.Level_Procedure;
1371: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1372: begin
1373: --log for debug
1374: IF (l_proc_level >= l_dbg_level) THEN

Line 1375: FND_LOG.String(l_proc_level,

1371: l_proc_name VARCHAR2(100) := 'Cfs_Detail_Report';
1372: begin
1373: --log for debug
1374: IF (l_proc_level >= l_dbg_level) THEN
1375: FND_LOG.String(l_proc_level,
1376: l_module_prefix || '.' || l_proc_name || '.begin',
1377: 'Enter procedure');
1378: FND_LOG.String(l_proc_level,
1379: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1378: FND_LOG.String(l_proc_level,

1374: IF (l_proc_level >= l_dbg_level) THEN
1375: FND_LOG.String(l_proc_level,
1376: l_module_prefix || '.' || l_proc_name || '.begin',
1377: 'Enter procedure');
1378: FND_LOG.String(l_proc_level,
1379: l_module_prefix || '.' || l_proc_name || '.parameters',
1380: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1381: FND_LOG.String(l_proc_level,
1382: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1381: FND_LOG.String(l_proc_level,

1377: 'Enter procedure');
1378: FND_LOG.String(l_proc_level,
1379: l_module_prefix || '.' || l_proc_name || '.parameters',
1380: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1381: FND_LOG.String(l_proc_level,
1382: l_module_prefix || '.' || l_proc_name || '.parameters',
1383: 'P_LEDGER_ID ' || P_LEDGER_ID);
1384: FND_LOG.String(l_proc_level,
1385: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1384: FND_LOG.String(l_proc_level,

1380: 'P_LEGAL_ENTITY_ID ' || P_LEGAL_ENTITY_ID);
1381: FND_LOG.String(l_proc_level,
1382: l_module_prefix || '.' || l_proc_name || '.parameters',
1383: 'P_LEDGER_ID ' || P_LEDGER_ID);
1384: FND_LOG.String(l_proc_level,
1385: l_module_prefix || '.' || l_proc_name || '.parameters',
1386: 'P_chart_of_accounts_ID ' || P_chart_of_accounts_ID);
1387:
1388: FND_LOG.String(l_proc_level,

Line 1388: FND_LOG.String(l_proc_level,

1384: FND_LOG.String(l_proc_level,
1385: l_module_prefix || '.' || l_proc_name || '.parameters',
1386: 'P_chart_of_accounts_ID ' || P_chart_of_accounts_ID);
1387:
1388: FND_LOG.String(l_proc_level,
1389: l_module_prefix || '.' || l_proc_name || '.parameters',
1390: 'P_ADHOC_PREFIX ' || p_adhoc_prefix);
1391:
1392: FND_LOG.String(l_proc_level,

Line 1392: FND_LOG.String(l_proc_level,

1388: FND_LOG.String(l_proc_level,
1389: l_module_prefix || '.' || l_proc_name || '.parameters',
1390: 'P_ADHOC_PREFIX ' || p_adhoc_prefix);
1391:
1392: FND_LOG.String(l_proc_level,
1393: l_module_prefix || '.' || l_proc_name || '.parameters',
1394: 'P_INDUSTRY ' || p_industry);
1395:
1396: FND_LOG.String(l_proc_level,

Line 1396: FND_LOG.String(l_proc_level,

1392: FND_LOG.String(l_proc_level,
1393: l_module_prefix || '.' || l_proc_name || '.parameters',
1394: 'P_INDUSTRY ' || p_industry);
1395:
1396: FND_LOG.String(l_proc_level,
1397: l_module_prefix || '.' || l_proc_name || '.parameters',
1398: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1399: FND_LOG.String(l_proc_level,
1400: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1399: FND_LOG.String(l_proc_level,

1395:
1396: FND_LOG.String(l_proc_level,
1397: l_module_prefix || '.' || l_proc_name || '.parameters',
1398: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1399: FND_LOG.String(l_proc_level,
1400: l_module_prefix || '.' || l_proc_name || '.parameters',
1401: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1402: FND_LOG.String(l_proc_level,
1403: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1402: FND_LOG.String(l_proc_level,

1398: 'P_ID_FLEX_CODE ' || p_id_flex_code);
1399: FND_LOG.String(l_proc_level,
1400: l_module_prefix || '.' || l_proc_name || '.parameters',
1401: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1402: FND_LOG.String(l_proc_level,
1403: l_module_prefix || '.' || l_proc_name || '.parameters',
1404: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1405: FND_LOG.String(l_proc_level,
1406: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1405: FND_LOG.String(l_proc_level,

1401: 'P_GL_PERIOD_FROM ' || P_GL_PERIOD_FROM);
1402: FND_LOG.String(l_proc_level,
1403: l_module_prefix || '.' || l_proc_name || '.parameters',
1404: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1405: FND_LOG.String(l_proc_level,
1406: l_module_prefix || '.' || l_proc_name || '.parameters',
1407: 'P_SOURCE ' || P_SOURCE);
1408: FND_LOG.String(l_proc_level,
1409: l_module_prefix || '.' || l_proc_name || '.parameters',

Line 1408: FND_LOG.String(l_proc_level,

1404: 'P_GL_PERIOD_TO' || P_GL_PERIOD_TO);
1405: FND_LOG.String(l_proc_level,
1406: l_module_prefix || '.' || l_proc_name || '.parameters',
1407: 'P_SOURCE ' || P_SOURCE);
1408: FND_LOG.String(l_proc_level,
1409: l_module_prefix || '.' || l_proc_name || '.parameters',
1410: 'P_REPORT_ID ' || P_REPORT_ID);
1411:
1412: END IF; --(l_proc_level >= l_dbg_level)

Line 1444: FND_LOG.STRING(l_proc_level,

1440: END IF; --JA_CN_UTILITY.Check_Profile
1441:
1442: --log for debug
1443: IF (l_proc_level >= l_dbg_level) THEN
1444: FND_LOG.STRING(l_proc_level,
1445: l_module_prefix || '.' || l_proc_name || '.end',
1446: 'Exit procedure');
1447: END IF; --( l_proc_level >= l_dbg_level )
1448:

Line 1452: FND_LOG.String(l_proc_level,

1448:
1449: EXCEPTION
1450: WHEN OTHERS THEN
1451: IF (l_proc_level >= l_dbg_level) THEN
1452: FND_LOG.String(l_proc_level,
1453: l_module_prefix || '.' || l_proc_name ||
1454: '. Other_Exception ',
1455: SQLCODE || ':' || SQLERRM);
1456: END IF; --(l_proc_level >= l_dbg_level)