eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JMF_GTA_SPLIT_TRX_PROC dependencies on FND_LOG

Line 76: IF(p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

72: ,p_message IN VARCHAR2)
73: IS
74: BEGIN
75:
76: IF(p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
77: THEN
78: fnd_log.STRING(LOG_LEVEL => p_level
79: ,MODULE => p_module
80: ,MESSAGE => p_message

Line 78: fnd_log.STRING(LOG_LEVEL => p_level

74: BEGIN
75:
76: IF(p_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
77: THEN
78: fnd_log.STRING(LOG_LEVEL => p_level
79: ,MODULE => p_module
80: ,MESSAGE => p_message
81: );
82: END IF;

Line 163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

159: l_functional_price jmf_gta_trx_lines_all.unit_price%TYPE; --25-Apr-2006: Jogen Hu bug 5168852
160:
161: BEGIN
162:
163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
166: , G_MODULE_PREFIX || l_procedure_name
167: ,'Begin Procedure. ');

Line 165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

161: BEGIN
162:
163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
164: THEN
165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
166: , G_MODULE_PREFIX || l_procedure_name
167: ,'Begin Procedure. ');
168: END IF;
169:

Line 170: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

166: , G_MODULE_PREFIX || l_procedure_name
167: ,'Begin Procedure. ');
168: END IF;
169:
170: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
171: THEN
172: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin Split_trx');
173:
174:

Line 172: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin Split_trx');

168: END IF;
169:
170: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
171: THEN
172: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin Split_trx');
173:
174:
175: END IF;
176:

Line 196: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

192: JMF_GTA_SYSTEM_PARAMETERS_all
193: WHERE org_id = p_org_id;
194:
195: -- begin log
196: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
197: THEN
198: --fnd_file.put_line(fnd_file.LOG, 'l_split_flag:'||l_split_flag);
199: log(FND_LOG.LEVEL_PROCEDURE
200: , G_MODULE_PREFIX || l_procedure_name

Line 199: log(FND_LOG.LEVEL_PROCEDURE

195: -- begin log
196: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
197: THEN
198: --fnd_file.put_line(fnd_file.LOG, 'l_split_flag:'||l_split_flag);
199: log(FND_LOG.LEVEL_PROCEDURE
200: , G_MODULE_PREFIX || l_procedure_name
201: , 'l_split_flag:'||l_split_flag);
202: END IF;
203: -- end log

Line 208: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

204:
205: EXCEPTION
206: -- no data found , raise a data error
207: WHEN no_data_found THEN
208: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
211: , G_MODULE_PREFIX || l_procedure_name
212: , 'no data found');

Line 210: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

206: -- no data found , raise a data error
207: WHEN no_data_found THEN
208: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
209: THEN
210: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
211: , G_MODULE_PREFIX || l_procedure_name
212: , 'no data found');
213:
214: --JMF_GTA_SYS_CONFIG_MISSING

Line 216: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

212: , 'no data found');
213:
214: --JMF_GTA_SYS_CONFIG_MISSING
215: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
216: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
217: , G_MODULE_PREFIX || l_procedure_name
218: , fnd_message.get());
219:
220: END IF;

Line 237: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

233: AND rule_header_id = p_transfer_id;
234: EXCEPTION
235: -- no data found , raise a data error
236: WHEN no_data_found THEN
237: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
238: THEN
239: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
240: , G_MODULE_PREFIX || l_procedure_name
241: , 'no data found');

Line 239: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

235: -- no data found , raise a data error
236: WHEN no_data_found THEN
237: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
238: THEN
239: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
240: , G_MODULE_PREFIX || l_procedure_name
241: , 'no data found');
242:
243: --JMF_GTA_SYS_CONFIG_MISSING

Line 245: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

241: , 'no data found');
242:
243: --JMF_GTA_SYS_CONFIG_MISSING
244: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
245: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
246: , G_MODULE_PREFIX || l_procedure_name
247: , fnd_message.get());
248:
249: END IF;

Line 256: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

252: END;
253:
254:
255: -- begin log
256: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
257: THEN
258: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sales_list_flag:'||l_sales_list_flag);
259: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'begin split_trx_loop......');
260: END IF;

Line 258: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sales_list_flag:'||l_sales_list_flag);

254:
255: -- begin log
256: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
257: THEN
258: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sales_list_flag:'||l_sales_list_flag);
259: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'begin split_trx_loop......');
260: END IF;
261: -- end log
262:

Line 259: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'begin split_trx_loop......');

255: -- begin log
256: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
257: THEN
258: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sales_list_flag:'||l_sales_list_flag);
259: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'begin split_trx_loop......');
260: END IF;
261: -- end log
262:
263:

Line 269: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

265: -- begin split trx
266: l_trx_index := P_GTA_TRX_Tbl.FIRST;
267:
268: -- begin log
269: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
270: THEN
271: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_index......'||l_trx_index);
272: END IF;
273: -- end log

Line 271: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_index......'||l_trx_index);

267:
268: -- begin log
269: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
270: THEN
271: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_index......'||l_trx_index);
272: END IF;
273: -- end log
274:
275:

Line 293: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

289: , x_TRX_Tbl => l_gta_taxreg_trx_tbl);
290: -- end split by tax registration number
291:
292: -- begin log
293: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
294: THEN
295: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End Split_trx_by_taxreg_number:'||l_gta_taxreg_trx_tbl.COUNT);
296: END IF;
297: -- end log

Line 295: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End Split_trx_by_taxreg_number:'||l_gta_taxreg_trx_tbl.COUNT);

291:
292: -- begin log
293: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
294: THEN
295: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End Split_trx_by_taxreg_number:'||l_gta_taxreg_trx_tbl.COUNT);
296: END IF;
297: -- end log
298:
299: -- begin split by tax rate

Line 307: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

303: -- end split by tax rate
304:
305:
306: -- begin log
307: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
308: THEN
309: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End split_trx_by_rate:'||l_gta_rate_trx_tbl.COUNT);
310: END IF;
311: -- end log

Line 309: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End split_trx_by_rate:'||l_gta_rate_trx_tbl.COUNT);

305:
306: -- begin log
307: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
308: THEN
309: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End split_trx_by_rate:'||l_gta_rate_trx_tbl.COUNT);
310: END IF;
311: -- end log
312:
313: -- loop by a new trx nested table which split by rate

Line 328: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

324: , x_trx_type => l_trx_type);
325:
326:
327: -- begin log
328: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
329: THEN
330: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_rate_index:'||l_trx_rate_index);
331: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_trx_type:'||l_trx_type);
332: END IF;

Line 330: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_rate_index:'||l_trx_rate_index);

326:
327: -- begin log
328: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
329: THEN
330: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_rate_index:'||l_trx_rate_index);
331: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_trx_type:'||l_trx_type);
332: END IF;
333: -- end log
334:

Line 331: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_trx_type:'||l_trx_type);

327: -- begin log
328: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
329: THEN
330: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_trx_rate_index:'||l_trx_rate_index);
331: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_trx_type:'||l_trx_type);
332: END IF;
333: -- end log
334:
335: -- IS CM ?\

Line 365: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

361: , x_max_line => l_max_line
362: );
363:
364: -- begin log
365: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
366: THEN
367: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'get_max_amount_line');
368: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_amount:'||l_max_amount);
369: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_line:'||l_max_line);

Line 367: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'get_max_amount_line');

363:
364: -- begin log
365: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
366: THEN
367: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'get_max_amount_line');
368: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_amount:'||l_max_amount);
369: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_line:'||l_max_line);
370: END IF;
371: -- end log

Line 368: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_amount:'||l_max_amount);

364: -- begin log
365: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
366: THEN
367: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'get_max_amount_line');
368: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_amount:'||l_max_amount);
369: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_line:'||l_max_line);
370: END IF;
371: -- end log
372:

Line 369: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_line:'||l_max_line);

365: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
366: THEN
367: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'get_max_amount_line');
368: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_amount:'||l_max_amount);
369: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_max_line:'||l_max_line);
370: END IF;
371: -- end log
372:
373: -- get lines number and amount

Line 390: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

386: THEN
387:
388:
389: -- begin log
390: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
391: THEN
392: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sum_of_amount 393: END IF;
394: -- end log

Line 392: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sum_of_amount

388:
389: -- begin log
390: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
391: THEN
392: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_sum_of_amount 393: END IF;
394: -- end log
395:
396: -- insert trx into result table

Line 423: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

419:
420: -- 25-Apr-2006: Jogen Hu bug 5168852
421: l_functional_price:=l_GTA_TRX_line_old.amount/l_GTA_TRX_line_old.quantity;
422: -- begin log
423: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
424: THEN
425: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name
426: , 'l_functional_price:'||l_functional_price);
427: END IF;

Line 425: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name

421: l_functional_price:=l_GTA_TRX_line_old.amount/l_GTA_TRX_line_old.quantity;
422: -- begin log
423: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
424: THEN
425: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name
426: , 'l_functional_price:'||l_functional_price);
427: END IF;
428: -- end log
429: -- 25-Apr-2006: Jogen Hu bug 5168852

Line 437: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

433: IF l_accumulated_amount <= l_max_amount AND l_processing_row 434: THEN
435:
436: -- begin log
437: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
438: THEN
439: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount <= l_max_amount AND l_processing_row 440: END IF;
441: -- end log

Line 439: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount <= l_max_amount AND l_processing_row

435:
436: -- begin log
437: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
438: THEN
439: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount <= l_max_amount AND l_processing_row 440: END IF;
441: -- end log
442:
443: IF l_processing_row = l_GTA_TRX.trx_lines.COUNT

Line 461: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

457: ELSIF l_processing_row >= l_max_line AND l_sales_list_flag = 'Y' AND l_accumulated_amount <= l_max_amount
458: THEN
459:
460: -- begin log
461: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
462: THEN
463: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_processing_row >= l_max_line AND l_sales_list_flag = ''Y'' AND l_accumulated_amount <= l_max_amount');
464: END IF;
465: -- end log

Line 463: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_processing_row >= l_max_line AND l_sales_list_flag = ''Y'' AND l_accumulated_amount <= l_max_amount');

459:
460: -- begin log
461: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
462: THEN
463: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_processing_row >= l_max_line AND l_sales_list_flag = ''Y'' AND l_accumulated_amount <= l_max_amount');
464: END IF;
465: -- end log
466:
467: IF l_processing_row = l_GTA_TRX.trx_lines.COUNT

Line 540: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

536: ELSIF l_accumulated_amount > l_max_amount
537: THEN
538:
539: -- begin log
540: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
541: THEN
542: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount > l_max_amount');
543: END IF;
544: -- end log

Line 542: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount > l_max_amount');

538:
539: -- begin log
540: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
541: THEN
542: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_accumulated_amount > l_max_amount');
543: END IF;
544: -- end log
545:
546: l_trx_lines := l_GTA_TRX.trx_lines;

Line 862: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

858: l_trx_index := P_GTA_TRX_Tbl.NEXT(l_trx_index);
859:
860: END LOOP; -- end loop by P_gta_trx_tbl /*l_trx_index IS NOT NULL*/
861:
862: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
863: THEN
864: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
865: , G_MODULE_PREFIX || l_procedure_name
866: ,'End Procedure. ');

Line 864: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

860: END LOOP; -- end loop by P_gta_trx_tbl /*l_trx_index IS NOT NULL*/
861:
862: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
863: THEN
864: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
865: , G_MODULE_PREFIX || l_procedure_name
866: ,'End Procedure. ');
867: END IF;
868:

Line 871: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

867: END IF;
868:
869: EXCEPTION
870: WHEN OTHERS THEN
871: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
872: THEN
873: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
874: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
875: , Sqlcode||Sqlerrm);

Line 873: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

869: EXCEPTION
870: WHEN OTHERS THEN
871: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
872: THEN
873: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
874: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
875: , Sqlcode||Sqlerrm);
876: END IF;
877: RAISE;

Line 905: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

901: l_gta_header_id jmf_gta_trx_headers.gta_trx_header_id%TYPE;
902: l_gta_trx_header_rec JMF_GTA_TRX_UTIL.TRX_HEADER_REC_TYPE;
903:
904: BEGIN
905: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
906: THEN
907: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
908: , G_MODULE_PREFIX || l_procedure_name
909: ,'Begin Procedure. ');

Line 907: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

903:
904: BEGIN
905: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
906: THEN
907: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
908: , G_MODULE_PREFIX || l_procedure_name
909: ,'Begin Procedure. ');
910: END IF;
911:

Line 932: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

928: || l_GTA_TRX_Header_rec.version;
929:
930: x_GTA_TRX_Header_Rec := l_gta_trx_header_rec;
931:
932: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
933: THEN
934: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
935: , G_MODULE_PREFIX || l_procedure_name
936: ,'End Procedure. ');

Line 934: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

930: x_GTA_TRX_Header_Rec := l_gta_trx_header_rec;
931:
932: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
933: THEN
934: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
935: , G_MODULE_PREFIX || l_procedure_name
936: ,'End Procedure. ');
937: END IF;
938:

Line 941: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

937: END IF;
938:
939: EXCEPTION
940: WHEN OTHERS THEN
941: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
942: THEN
943: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
944: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
945: , Sqlcode||Sqlerrm);

Line 943: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

939: EXCEPTION
940: WHEN OTHERS THEN
941: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
942: THEN
943: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
944: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
945: , Sqlcode||Sqlerrm);
946: END IF;
947: RAISE;

Line 983: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

979: l_index NUMBER;
980: l_procedure_name VARCHAR2(50):='Split_Nested_Table';
981:
982: BEGIN
983: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
984: THEN
985: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
986: , G_MODULE_PREFIX || l_procedure_name
987: ,'Begin Procedure. ');

Line 985: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

981:
982: BEGIN
983: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
984: THEN
985: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
986: , G_MODULE_PREFIX || l_procedure_name
987: ,'Begin Procedure. ');
988: END IF;
989:

Line 1020: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1016:
1017: x_first_lines := l_first_lines;
1018: x_last_lines := l_last_lines;
1019:
1020: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1021: THEN
1022: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1023: , G_MODULE_PREFIX || l_procedure_name
1024: ,'End Procedure. ');

Line 1022: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1018: x_last_lines := l_last_lines;
1019:
1020: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1021: THEN
1022: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1023: , G_MODULE_PREFIX || l_procedure_name
1024: ,'End Procedure. ');
1025: END IF;
1026:

Line 1029: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1025: END IF;
1026:
1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1030: THEN
1031: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1032: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1033: , Sqlcode||Sqlerrm);

Line 1031: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1027: EXCEPTION
1028: WHEN OTHERS THEN
1029: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1030: THEN
1031: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1032: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1033: , Sqlcode||Sqlerrm);
1034: END IF;
1035: RAISE;

Line 1064: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1060: l_index NUMBER; -- loop index
1061:
1062: BEGIN
1063:
1064: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1065: THEN
1066: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1067: , G_MODULE_PREFIX || l_procedure_name
1068: ,'Begin Procedure. ');

Line 1066: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1062: BEGIN
1063:
1064: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1065: THEN
1066: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1067: , G_MODULE_PREFIX || l_procedure_name
1068: ,'Begin Procedure. ');
1069: END IF;
1070:

Line 1111: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1107:
1108: END IF;
1109: --12/06/2006 Shujuan Yan bug 5168900
1110:
1111: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1112: THEN
1113: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1114: , G_MODULE_PREFIX || l_procedure_name
1115: ,'Begin Procedure. ');

Line 1113: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1109: --12/06/2006 Shujuan Yan bug 5168900
1110:
1111: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1112: THEN
1113: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1114: , G_MODULE_PREFIX || l_procedure_name
1115: ,'Begin Procedure. ');
1116: END IF;
1117:

Line 1120: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1116: END IF;
1117:
1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1121: THEN
1122: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1123: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1124: , Sqlcode||Sqlerrm);

Line 1122: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1118: EXCEPTION
1119: WHEN OTHERS THEN
1120: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1121: THEN
1122: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1123: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1124: , Sqlcode||Sqlerrm);
1125: END IF;
1126: RAISE;

Line 1163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1159: l_warning_record_count NUMBER;
1160: l_customer_trx_id NUMBER(15);
1161:
1162: BEGIN
1163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1164: THEN
1165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1166: , G_MODULE_PREFIX || l_procedure_name
1167: ,'Begin Procedure. ');

Line 1165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1161:
1162: BEGIN
1163: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1164: THEN
1165: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1166: , G_MODULE_PREFIX || l_procedure_name
1167: ,'Begin Procedure. ');
1168: END IF;
1169:

Line 1194: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1190: AND ctt.Org_Id = h.Org_Id
1191: AND h.customer_trx_id = p_gta_trx_rec.trx_header.ra_trx_id;
1192: EXCEPTION
1193: WHEN no_data_found THEN
1194: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1195: THEN
1196: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1197: , G_MODULE_PREFIX || l_procedure_name
1198: ,'No data found. ');

Line 1196: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1192: EXCEPTION
1193: WHEN no_data_found THEN
1194: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1195: THEN
1196: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1197: , G_MODULE_PREFIX || l_procedure_name
1198: ,'No data found. ');
1199: END IF;
1200: END;

Line 1252: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1248:
1249: END IF;/*l_warning_record_count = 0*/
1250:
1251:
1252: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1253: THEN
1254: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1255: , G_MODULE_PREFIX || l_procedure_name
1256: ,'Begin Procedure. ');

Line 1254: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1250:
1251:
1252: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1253: THEN
1254: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1255: , G_MODULE_PREFIX || l_procedure_name
1256: ,'Begin Procedure. ');
1257: END IF;
1258:

Line 1261: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1257: END IF;
1258:
1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1262: THEN
1263: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1264: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1265: , Sqlcode||Sqlerrm);

Line 1263: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1259: EXCEPTION
1260: WHEN OTHERS THEN
1261: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1262: THEN
1263: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1264: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1265: , Sqlcode||Sqlerrm);
1266: END IF;
1267: RAISE;

Line 1303: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1299: l_trx_header_new JMF_GTA_TRX_UTIL.TRX_header_rec_TYPE;
1300: l_trx_rate_index NUMBER; -- index for nested table loop
1301: l_index NUMBER; -- index for nested table loop
1302: BEGIN
1303: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1304: THEN
1305: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1306: , G_MODULE_PREFIX || l_procedure_name
1307: ,'Begin Procedure. ');

Line 1305: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1301: l_index NUMBER; -- index for nested table loop
1302: BEGIN
1303: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1304: THEN
1305: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1306: , G_MODULE_PREFIX || l_procedure_name
1307: ,'Begin Procedure. ');
1308: END IF;
1309: -- init l_gta_rate_trx_tbl

Line 1384: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1380:
1381: -- output
1382: x_trx_tbl := l_gta_rate_trx_tbl;
1383:
1384: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1385: THEN
1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1387: , G_MODULE_PREFIX || l_procedure_name
1388: ,'Begin Procedure. ');

Line 1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1382: x_trx_tbl := l_gta_rate_trx_tbl;
1383:
1384: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1385: THEN
1386: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1387: , G_MODULE_PREFIX || l_procedure_name
1388: ,'Begin Procedure. ');
1389: END IF;
1390:

Line 1393: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1389: END IF;
1390:
1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1394: THEN
1395: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1396: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1397: , Sqlcode||Sqlerrm);

Line 1395: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1391: EXCEPTION
1392: WHEN OTHERS THEN
1393: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1394: THEN
1395: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1396: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1397: , Sqlcode||Sqlerrm);
1398: END IF;
1399: RAISE;

Line 1434: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1430: l_trx_rate_index NUMBER; -- index for nested table loop
1431: l_index NUMBER; -- index for nested table loop
1432: l_gta_index NUMBER; -- index for nested table loop
1433: BEGIN
1434: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1435: THEN
1436: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1437: , G_MODULE_PREFIX || l_procedure_name
1438: ,'Begin Procedure. ');

Line 1436: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1432: l_gta_index NUMBER; -- index for nested table loop
1433: BEGIN
1434: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1435: THEN
1436: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1437: , G_MODULE_PREFIX || l_procedure_name
1438: ,'Begin Procedure. ');
1439: END IF;
1440: -- init l_gta_rate_trx_tbl

Line 1521: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1517:
1518: -- output
1519: x_trx_tbl := l_gta_rate_trx_tbl;
1520:
1521: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1522: THEN
1523: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1524: , G_MODULE_PREFIX || l_procedure_name
1525: ,'Begin Procedure. ');

Line 1523: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1519: x_trx_tbl := l_gta_rate_trx_tbl;
1520:
1521: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1522: THEN
1523: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1524: , G_MODULE_PREFIX || l_procedure_name
1525: ,'Begin Procedure. ');
1526: END IF;
1527:

Line 1530: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1526: END IF;
1527:
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1531: THEN
1532: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1533: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1534: , Sqlcode||Sqlerrm);

Line 1532: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1531: THEN
1532: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1533: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1534: , Sqlcode||Sqlerrm);
1535: END IF;
1536: RAISE;

Line 1565: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1561: l_procedure_name VARCHAR2(30) := 'get_trx_type';
1562: l_trx_id ra_customer_trx_all.customer_trx_id%TYPE;
1563: l_trx_type ra_cust_trx_types_all.type%TYPE;
1564: BEGIN
1565: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1566: THEN
1567: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1568: , G_MODULE_PREFIX || l_procedure_name
1569: ,'Begin Procedure. ');

Line 1567: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1563: l_trx_type ra_cust_trx_types_all.type%TYPE;
1564: BEGIN
1565: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1566: THEN
1567: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1568: , G_MODULE_PREFIX || l_procedure_name
1569: ,'Begin Procedure. ');
1570: END IF;
1571:

Line 1591: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1587: END IF;/*p_gta_trx.trx_header.ra_trx_id IS NOT NULL*/
1588:
1589: x_trx_type := l_trx_type;
1590:
1591: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1592: THEN
1593: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1594: , G_MODULE_PREFIX || l_procedure_name
1595: ,'Begin Procedure. ');

Line 1593: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1589: x_trx_type := l_trx_type;
1590:
1591: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1592: THEN
1593: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1594: , G_MODULE_PREFIX || l_procedure_name
1595: ,'Begin Procedure. ');
1596: END IF;
1597:

Line 1600: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1596: END IF;
1597:
1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1601: THEN
1602: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1603: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1604: , Sqlcode||Sqlerrm);

Line 1602: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1598: EXCEPTION
1599: WHEN OTHERS THEN
1600: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1601: THEN
1602: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1603: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1604: , Sqlcode||Sqlerrm);
1605: END IF;
1606: RAISE;

Line 1643: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1639: l_trx_line_index NUMBER;
1640: l_invoice_type jmf_gta_trx_headers_all.invoice_type%TYPE; --added by subba for R12.1
1641: l_sales_list_flag jmf_gta_rule_headers_all.Sales_List_Flag%TYPE;--added by Yao Zhang for bug 7758496
1642: BEGIN
1643: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1644: THEN
1645: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1646: , G_MODULE_PREFIX || l_procedure_name
1647: ,'Begin Procedure. ');

Line 1645: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1641: l_sales_list_flag jmf_gta_rule_headers_all.Sales_List_Flag%TYPE;--added by Yao Zhang for bug 7758496
1642: BEGIN
1643: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1644: THEN
1645: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1646: , G_MODULE_PREFIX || l_procedure_name
1647: ,'Begin Procedure. ');
1648: END IF;
1649:

Line 1676: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1672: AND limits.org_id = p_org_id;
1673:
1674: EXCEPTION
1675: WHEN no_data_found THEN
1676: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1677: THEN
1678: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1679: , G_MODULE_PREFIX || l_procedure_name
1680: , 'no data found');

Line 1678: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1674: EXCEPTION
1675: WHEN no_data_found THEN
1676: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1677: THEN
1678: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1679: , G_MODULE_PREFIX || l_procedure_name
1680: , 'no data found');
1681:
1682: --JMF_GTA_SYS_CONFIG_MISSING

Line 1684: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1680: , 'no data found');
1681:
1682: --JMF_GTA_SYS_CONFIG_MISSING
1683: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1684: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1685: , G_MODULE_PREFIX || l_procedure_name
1686: , fnd_message.get());
1687:
1688: END IF;

Line 1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1702: AND rule_header_id = p_transfer_id;
1703: EXCEPTION
1704: -- no data found , raise a data error
1705: WHEN no_data_found THEN
1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1707: THEN
1708: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1709: , G_MODULE_PREFIX || l_procedure_name
1710: , 'no data found');

Line 1708: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1704: -- no data found , raise a data error
1705: WHEN no_data_found THEN
1706: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1707: THEN
1708: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1709: , G_MODULE_PREFIX || l_procedure_name
1710: , 'no data found');
1711:
1712: --JMF_GTA_SYS_CONFIG_MISSING

Line 1714: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1710: , 'no data found');
1711:
1712: --JMF_GTA_SYS_CONFIG_MISSING
1713: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1714: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1715: , G_MODULE_PREFIX || l_procedure_name
1716: , fnd_message.get());
1717:
1718: END IF;

Line 1754: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1750: THEN
1751: x_result := FALSE;
1752: END IF;/*l_sum_of_amount > l_max_amount OR l_lines_number > l_max_line*/
1753:
1754: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1755: THEN
1756: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1757: , G_MODULE_PREFIX || l_procedure_name
1758: ,'End Procedure. ');

Line 1756: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1752: END IF;/*l_sum_of_amount > l_max_amount OR l_lines_number > l_max_line*/
1753:
1754: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1755: THEN
1756: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1757: , G_MODULE_PREFIX || l_procedure_name
1758: ,'End Procedure. ');
1759: END IF;
1760:

Line 1763: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1759: END IF;
1760:
1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1764: THEN
1765: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1766: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1767: , Sqlcode||Sqlerrm);

Line 1765: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1761: EXCEPTION
1762: WHEN OTHERS THEN
1763: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1764: THEN
1765: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1766: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1767: , Sqlcode||Sqlerrm);
1768: END IF;
1769: RAISE;

Line 1802: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1798: l_max_amount NUMBER;
1799: l_max_line NUMBER;
1800: l_error_string VARCHAR2(2000); --added by subba.
1801: BEGIN
1802: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1803: THEN
1804: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1805: , G_MODULE_PREFIX || l_procedure_name
1806: ,'Begin Procedure. ');

Line 1804: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1800: l_error_string VARCHAR2(2000); --added by subba.
1801: BEGIN
1802: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1803: THEN
1804: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1805: , G_MODULE_PREFIX || l_procedure_name
1806: ,'Begin Procedure. ');
1807: END IF;
1808:

Line 1810: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1806: ,'Begin Procedure. ');
1807: END IF;
1808:
1809: -- begin log
1810: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1811: THEN
1812: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin get_max_amount_line '||'p_org_id:'||P_org_id);
1813: END IF;
1814: -- end log

Line 1812: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin get_max_amount_line '||'p_org_id:'||P_org_id);

1808:
1809: -- begin log
1810: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1811: THEN
1812: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin get_max_amount_line '||'p_org_id:'||P_org_id);
1813: END IF;
1814: -- end log
1815:
1816: l_gta_trx := p_gta_trx;

Line 1820: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1816: l_gta_trx := p_gta_trx;
1817: l_fp_reg_num := l_gta_trx.trx_lines(1).fp_tax_registration_number;
1818:
1819: -- begin log
1820: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1821: THEN
1822: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_fp_reg_num: '||l_fp_reg_num);
1823: END IF;
1824: -- end log

Line 1822: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_fp_reg_num: '||l_fp_reg_num);

1818:
1819: -- begin log
1820: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1821: THEN
1822: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'l_fp_reg_num: '||l_fp_reg_num);
1823: END IF;
1824: -- end log
1825: /* 28/12/07 commented by Subba to change the logic for R12.1
1826: BEGIN

Line 1840: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1836: AND limits.org_id = p_org_id;
1837:
1838: EXCEPTION
1839: WHEN no_data_found THEN
1840: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1841: THEN
1842: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1843: , G_MODULE_PREFIX || l_procedure_name
1844: , 'no data found');

Line 1842: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1838: EXCEPTION
1839: WHEN no_data_found THEN
1840: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1841: THEN
1842: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1843: , G_MODULE_PREFIX || l_procedure_name
1844: , 'no data found');
1845:
1846: --JMF_GTA_SYS_CONFIG_MISSING

Line 1848: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED

1844: , 'no data found');
1845:
1846: --JMF_GTA_SYS_CONFIG_MISSING
1847: fnd_message.set_name('JMF', 'JMF_GTA_SYS_CONFIG_MISSING');
1848: fnd_log.STRING(fnd_log.LEVEL_UNEXPECTED
1849: , G_MODULE_PREFIX || l_procedure_name
1850: , fnd_message.get());
1851:
1852: END IF;

Line 1892: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

1888: Y
1889: '||l_error_string ||'
1890: ');
1891:
1892: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1893: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1894: ,G_MODULE_PREFIX || l_procedure_name
1895: ,'no data found for max_amt and mx_num_line'
1896: );

Line 1893: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1889: '||l_error_string ||'
1890: ');
1891:
1892: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1893: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1894: ,G_MODULE_PREFIX || l_procedure_name
1895: ,'no data found for max_amt and mx_num_line'
1896: );
1897: END IF;

Line 1910: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1906: x_max_amount := l_max_amount;
1907: END IF ; /*l_max_line IS NOT NULL AND l_max_amount IS NOT NULL*/
1908:
1909: -- begin log
1910: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1911: THEN
1912: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_max_amount_line:'||l_fp_reg_num);
1913: END IF;
1914: -- end log

Line 1912: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_max_amount_line:'||l_fp_reg_num);

1908:
1909: -- begin log
1910: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1911: THEN
1912: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_max_amount_line:'||l_fp_reg_num);
1913: END IF;
1914: -- end log
1915:
1916: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1916: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1912: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End get_max_amount_line:'||l_fp_reg_num);
1913: END IF;
1914: -- end log
1915:
1916: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1917: THEN
1918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1919: , G_MODULE_PREFIX || l_procedure_name
1920: ,'Begin Procedure. ');

Line 1918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1914: -- end log
1915:
1916: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1917: THEN
1918: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1919: , G_MODULE_PREFIX || l_procedure_name
1920: ,'Begin Procedure. ');
1921: END IF;
1922:

Line 1925: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1921: END IF;
1922:
1923: EXCEPTION
1924: WHEN OTHERS THEN
1925: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1926: THEN
1927: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1928: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1929: , Sqlcode||Sqlerrm);

Line 1927: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

1923: EXCEPTION
1924: WHEN OTHERS THEN
1925: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1926: THEN
1927: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
1928: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
1929: , Sqlcode||Sqlerrm);
1930: END IF;
1931: RAISE;

Line 1972: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1968: l_error_string VARCHAR2(500);
1969:
1970: BEGIN
1971:
1972: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1973: THEN
1974: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1975: , G_MODULE_PREFIX || l_procedure_name
1976: ,'Begin Procedure. ');

Line 1974: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

1970: BEGIN
1971:
1972: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1973: THEN
1974: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
1975: , G_MODULE_PREFIX || l_procedure_name
1976: ,'Begin Procedure. ');
1977: END IF;
1978:

Line 1980: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1976: ,'Begin Procedure. ');
1977: END IF;
1978:
1979: -- begin log
1980: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1981: THEN
1982: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin filter_credit_memo');
1983: END IF;
1984: -- end log

Line 1982: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin filter_credit_memo');

1978:
1979: -- begin log
1980: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1981: THEN
1982: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Begin filter_credit_memo');
1983: END IF;
1984: -- end log
1985:
1986: -- init x_gta_Trx_tbl

Line 2019: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2015: IF l_result = FALSE
2016: THEN
2017: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_EXCEED_LIMIT');
2018: l_error_string := fnd_message.GET();
2019: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2020: THEN
2021: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2022: , G_MODULE_PREFIX || l_procedure_name
2023: , l_error_string

Line 2021: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION

2017: fnd_message.SET_NAME('JMF', 'JMF_GTA_CRMEMO_EXCEED_LIMIT');
2018: l_error_string := fnd_message.GET();
2019: IF(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2020: THEN
2021: fnd_log.STRING(fnd_log.LEVEL_EXCEPTION
2022: , G_MODULE_PREFIX || l_procedure_name
2023: , l_error_string
2024: );
2025: END IF;

Line 2035: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2031: x_gta_trx_tbl(x_gta_trx_tbl.COUNT) := l_gta_trx;
2032:
2033: ELSE /*l_trx_type = 'CM'*/
2034: -- begin log
2035: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2036: THEN
2037: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Is not a CM');
2038: END IF;
2039: -- end log

Line 2037: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Is not a CM');

2033: ELSE /*l_trx_type = 'CM'*/
2034: -- begin log
2035: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2036: THEN
2037: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'Is not a CM');
2038: END IF;
2039: -- end log
2040:
2041: x_gta_trx_tbl.EXTEND;

Line 2084: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2080: END;
2081: l_index := p_gta_trx_tbl.NEXT(l_index);
2082: END LOOP;/*l_index IS NOT NULL*/
2083:
2084: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2085: THEN
2086: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2087: , G_MODULE_PREFIX || l_procedure_name
2088: ,'Begin Procedure. ');

Line 2086: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE

2082: END LOOP;/*l_index IS NOT NULL*/
2083:
2084: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2085: THEN
2086: fnd_log.STRING(fnd_log.LEVEL_PROCEDURE
2087: , G_MODULE_PREFIX || l_procedure_name
2088: ,'Begin Procedure. ');
2089: END IF;
2090:

Line 2092: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2088: ,'Begin Procedure. ');
2089: END IF;
2090:
2091: -- begin log
2092: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2093: THEN
2094: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End filter_credit_memo');
2095: END IF;
2096: -- end log

Line 2094: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End filter_credit_memo');

2090:
2091: -- begin log
2092: IF(FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2093: THEN
2094: log(FND_LOG.LEVEL_PROCEDURE,G_MODULE_PREFIX || l_procedure_name, 'End filter_credit_memo');
2095: END IF;
2096: -- end log
2097:
2098: EXCEPTION

Line 2100: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2096: -- end log
2097:
2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2103: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2104: , Sqlcode||Sqlerrm);

Line 2102: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED

2098: EXCEPTION
2099: WHEN OTHERS THEN
2100: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2101: THEN
2102: FND_LOG.string( FND_LOG.LEVEL_UNEXPECTED
2103: , G_MODULE_PREFIX || l_procedure_name || '. OTHER_EXCEPTION '
2104: , Sqlcode||Sqlerrm);
2105: END IF;
2106: RAISE;