DBA Data[Home] [Help]

APPS.AR_GTA_TRX_UTIL dependencies on FND_FILE

Line 383: fnd_file.put(fnd_file.output

379: IF (l_pos_tag > l_tmp1)
380: AND (l_tmp < 0)
381: THEN
382: l_tmp := l_pos_tag - l_pos + 1;
383: fnd_file.put(fnd_file.output
384: ,substr(p_clob
385: ,l_pos
386: ,l_tmp));
387: l_pos := l_pos_tag + 1;

Line 391: fnd_file.put(fnd_file.output

387: l_pos := l_pos_tag + 1;
388: ELSE
389: l_substr := substr(p_clob
390: ,l_pos);
391: fnd_file.put(fnd_file.output
392: ,l_substr);
393: l_pos := l_len + 1;
394:
395: END IF;

Line 437: FND_FILE.Put_Line(FND_FILE.Output

433: l_pos:=l_pos3+2;
434: END IF;
435:
436: IF l_pos>2 THEN
437: FND_FILE.Put_Line(FND_FILE.Output
438: ,substr(p_clob
439: ,l_prepos
440: ,l_pos - l_prepos
441: )

Line 444: FND_FILE.Put_Line(FND_FILE.Log

440: ,l_pos - l_prepos
441: )
442: );
443: ELSE
444: FND_FILE.Put_Line(FND_FILE.Log
445: ,substr(p_clob
446: ,l_prepos
447: )
448: );

Line 556: fnd_file.put_line(FND_FILE.LOG,

552: l_gta_trx_tbl ar_gta_trx_util.trx_tbl_type;
553: l_index NUMBER;
554:
555: BEGIN
556: fnd_file.put_line(FND_FILE.LOG,
557: g_module_prefix || l_procedure_name ||
558: '----001 ');
559: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)
560: THEN

Line 589: fnd_file.put_line(FND_FILE.LOG,

585: fnd_log.STRING(fnd_log.level_procedure
586: ,g_module_prefix || l_procedure_name
587: ,'End Procedure. ');
588: END IF;
589: fnd_file.put_line(FND_FILE.LOG,
590: g_module_prefix || l_procedure_name ||
591: '----002 ');
592:
593: EXCEPTION

Line 2252: fnd_file.put_line(fnd_file.output, '

2248: --report AR_GTA_MISSING_ERROR
2249: fnd_message.set_name('AR', 'AR_GTA_MISSING_ERROR');
2250: l_error_string := fnd_message.get();
2251: -- output this error
2252: fnd_file.put_line(fnd_file.output, '
2253:
2254: Y
2255: '||l_error_string||'
2256: ');

Line 2607: fnd_file.put_line(fnd_file.output, '

2603: --report AR_GTA_MISSING_ERROR
2604: fnd_message.set_name('AR', 'AR_GTA_MISSING_ERROR');
2605: l_error_string := fnd_message.get();
2606: -- output this error
2607: fnd_file.put_line(fnd_file.output, '
2608:
2609: Y
2610: '||l_error_string||'
2611: ');

Line 3235: fnd_file.put_line(fnd_file.output,'

3231: --report AR_GTA_MISSING_ERROR
3232: fnd_message.set_name('AR', 'AR_GTA_SYS_CONFIG_MISSING');
3233: l_error_string := fnd_message.get();
3234: -- output this error
3235: fnd_file.put_line(fnd_file.output,'
3236:
3237: Y
3238: '||l_error_string||'
3239: ');

Line 4066: WHEN 'FND_FILE.OUTPUT' THEN

4062: fnd_log.STRING(FND_LOG.LEVEL_PROCEDURE
4063: ,p_api_name || '.debug_output'
4064: ,p_message);
4065: END IF;
4066: WHEN 'FND_FILE.OUTPUT' THEN
4067: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
4068: fnd_file.put_line(fnd_file.OUTPUT
4069: ,p_api_name || '.debug_output' || ': ' ||
4070: p_message);

Line 4068: fnd_file.put_line(fnd_file.OUTPUT

4064: ,p_message);
4065: END IF;
4066: WHEN 'FND_FILE.OUTPUT' THEN
4067: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
4068: fnd_file.put_line(fnd_file.OUTPUT
4069: ,p_api_name || '.debug_output' || ': ' ||
4070: p_message);
4071: END IF;
4072: WHEN 'FND_FILE.LOG' THEN

Line 4072: WHEN 'FND_FILE.LOG' THEN

4068: fnd_file.put_line(fnd_file.OUTPUT
4069: ,p_api_name || '.debug_output' || ': ' ||
4070: p_message);
4071: END IF;
4072: WHEN 'FND_FILE.LOG' THEN
4073: IF (FND_LOG.LEVEL_PROCEDURE >= fnd_log.G_CURRENT_RUNTIME_LEVEL) THEN
4074: log(p_api_name || '.debug_output' || ': ' ||
4075: p_message);
4076: END IF;

Line 4396: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4392: COMMIT;
4393:
4394: fnd_message.set_name('AR', 'AR_GTA_INV_TYPE_INIT');
4395: fnd_message.set_token('ORG_NAME',get_operatingunit(p_org_id));
4396: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4397:
4398: --logging for debug
4399: IF (l_proc_level >= l_dbg_level)
4400: THEN

Line 4536: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4532: END IF; --l_proc_level>=l_dbg_level)
4533:
4534: -- log for successfully updated invoice numbers
4535: fnd_message.set_name('AR', 'AR_GTA_UPG_TRANSACTION_S');
4536: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4537:
4538: OPEN c_all_inv_updated;
4539: LOOP
4540: FETCH c_all_inv_updated

Line 4620: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4616: END IF;/*(FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)*/
4617: END;
4618: IF (l_pre_trx_invoice_type IS NOT NULL AND l_pre_trx_invoice_type = l_invoice_type)
4619: THEN
4620: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4621: END IF;
4622: ELSE
4623: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4624: END IF;

Line 4623: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4619: THEN
4620: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4621: END IF;
4622: ELSE
4623: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4624: END IF;
4625: END IF; --l_invoice_type IS NOT NULL
4626: END LOOP; -- c_all_inv_updated%NOTFOUND;
4627: CLOSE c_all_inv_updated;

Line 4658: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4654:
4655: /* commented by Allen Yang 26-Aug-2009 for bug 8839141.
4656: -- log for invoice type populating exceptions
4657: fnd_message.set_name('AR', 'AR_GTA_INV_TYPE_EXC_REASON');
4658: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4659: */
4660:
4661: -- added by Allen Yang 26-Aug-2009 for bug 8839141.
4662: OPEN c_cm_inv_type_different;

Line 4667: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4663: FETCH c_cm_inv_type_different INTO l_gta_trx_number, l_source;
4664: IF c_cm_inv_type_different%FOUND
4665: THEN
4666: fnd_message.set_name('AR', 'AR_GTA_UPG_DIF_INVOICE_TYPE');
4667: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4668: END IF; --c_cm_inv_type_different%FOUND
4669: WHILE c_cm_inv_type_different%FOUND
4670: LOOP
4671: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

Line 4671: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4667: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4668: END IF; --c_cm_inv_type_different%FOUND
4669: WHILE c_cm_inv_type_different%FOUND
4670: LOOP
4671: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4672: FETCH c_cm_inv_type_different INTO l_gta_trx_number, l_source;
4673: END LOOP; --c_cm_inv_type_different%FOUND
4674: CLOSE c_cm_inv_type_different;
4675: -- end added by Allen Yang

Line 4685: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4681: -- modified by Allen Yang 26-Aug-2009 for bug 8839141
4682: --fnd_message.set_name('AR', 'AR_GTA_TRX_TYPE_NOT_ASS');
4683: fnd_message.set_name('AR', 'AR_GTA_UPG_NO_INVOICE_TYPE');
4684: -- end modified by Allen Yang
4685: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4686: END IF; --c_inv_trx_type_no_inv_type%FOUND
4687: WHILE c_inv_trx_type_no_inv_type%FOUND
4688: LOOP
4689: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

Line 4689: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4685: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4686: END IF; --c_inv_trx_type_no_inv_type%FOUND
4687: WHILE c_inv_trx_type_no_inv_type%FOUND
4688: LOOP
4689: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4690: FETCH c_inv_trx_type_no_inv_type INTO l_gta_trx_number, l_source;
4691: END LOOP; --c_inv_trx_type_no_inv_type%FOUND
4692: CLOSE c_inv_trx_type_no_inv_type;
4693:

Line 4702: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4698: -- modified by Allen Yang 26-Aug-2009 for bug 8839141
4699: --fnd_message.set_name('AR', 'AR_GTA_REC_TAX_NOT_ZERO');
4700: fnd_message.set_name('AR', 'AR_GTA_UPG_NOZERO_TAX_R');
4701: -- end modified by Allen Yang
4702: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4703: END IF; --c_recycle_tax_amount_not_zero%FOUND
4704: WHILE c_recycle_tax_amount_not_zero%FOUND
4705: LOOP
4706: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

Line 4706: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4702: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4703: END IF; --c_recycle_tax_amount_not_zero%FOUND
4704: WHILE c_recycle_tax_amount_not_zero%FOUND
4705: LOOP
4706: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4707: FETCH c_recycle_tax_amount_not_zero INTO l_gta_trx_number, l_source;
4708: END LOOP; --c_recycle_tax_amount_not_zero%FOUND
4709: CLOSE c_recycle_tax_amount_not_zero;
4710:

Line 4717: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());

4713: FETCH c_cm_inv_type_different INTO l_gta_trx_number, l_source;
4714: IF c_cm_inv_type_different%FOUND
4715: THEN
4716: fnd_message.set_name('AR', 'AR_GTA_CM_INV_TYPE_DIFF');
4717: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4718: END IF; --c_cm_inv_type_different%FOUND
4719: WHILE c_cm_inv_type_different%FOUND
4720: LOOP
4721: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

Line 4721: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');

4717: fnd_file.put_line(fnd_file.OUTPUT, fnd_message.get());
4718: END IF; --c_cm_inv_type_different%FOUND
4719: WHILE c_cm_inv_type_different%FOUND
4720: LOOP
4721: fnd_file.put_line(fnd_file.OUTPUT, l_gta_trx_number||'('||l_source||')');
4722: FETCH c_cm_inv_type_different INTO l_gta_trx_number, l_source;
4723: END LOOP; --c_cm_inv_type_different%FOUND
4724: CLOSE c_cm_inv_type_different;
4725: */