DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on JG_ZZ_VAT_REP_UTILITY

Line 344: | (1) JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities to validate and |

340: | main() |
341: | |
342: | DESCRIPTION |
343: | This procedure calls |
344: | (1) JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities to validate and |
345: | determine whether to create ACCOUNTING reporting entities or not. |
346: | (2) JG_ZZ_VAT_REP_UTILITY.validate_process_initiation to validate and |
347: | determine whether to proceed with selection or not. |
348: | (2) Insert status information into jg_zz_vat_rep_status table. |

Line 346: | (2) JG_ZZ_VAT_REP_UTILITY.validate_process_initiation to validate and |

342: | DESCRIPTION |
343: | This procedure calls |
344: | (1) JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities to validate and |
345: | determine whether to create ACCOUNTING reporting entities or not. |
346: | (2) JG_ZZ_VAT_REP_UTILITY.validate_process_initiation to validate and |
347: | determine whether to proceed with selection or not. |
348: | (2) Insert status information into jg_zz_vat_rep_status table. |
349: | (3) Call TRL engine to fetch AR, AP, GL tax information. |
350: | (4) Controls intersecting domains (transactions selected in current |

Line 353: | (6) JG_ZZ_VAT_REP_UTILITY.post_process_updates to perform post |

349: | (3) Call TRL engine to fetch AR, AP, GL tax information. |
350: | (4) Controls intersecting domains (transactions selected in current |
351: | run intersects with a previous selection run(s). |
352: | (5) Insert TRL info into JG Tax Trx table |
353: | (6) JG_ZZ_VAT_REP_UTILITY.post_process_updates to perform post |
354: | selection process processing. |
355: | |
356: | SCOPE - Public |
357: | |

Line 469: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',

465: | reporting entity identifier. |
466: +--------------------------------------------------------------------*/
467: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
469: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
470: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
471: ||'()+');
472: END IF;
473:

Line 470: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'

466: +--------------------------------------------------------------------*/
467: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
468: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
469: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
470: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
471: ||'()+');
472: END IF;
473:
474:

Line 475: JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities(

471: ||'()+');
472: END IF;
473:
474:
475: JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities(
476: pv_entity_level_code => l_global_variables_rec.reporting_entity_level,
477: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
478: pn_ledger_id => l_global_variables_rec.ledger,
479: pv_balancing_segment_value => l_global_variables_rec.bsv,

Line 487: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',

483: );
484:
485: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
487: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
488: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
489: );
490: END IF;
491:

Line 488: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'

484:
485: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
486: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
487: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
488: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
489: );
490: END IF;
491:
492: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,

Line 543: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |

539: | previous run from jg_zz_vat_trx_details table by calling |
540: | jg_zz_vat_selection_pkg.purge_tax_data. |
541: | (5) Before re-selection, update the status information (nullify) |
542: | of the selection process for the given combination by calling |
543: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
544: | (6) If Selection is not yet initiated for the given combination |
545: | Validate if there is any gap in selection as per calendar |
546: | (7) Inserts status information of the Selection process into the |
547: | jg_zz_vat_rep_status table. |

Line 551: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',

547: | jg_zz_vat_rep_status table. |
548: +--------------------------------------------------------------------*/
549: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
551: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
552: G_PKG_NAME||': '||
553: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
554: END IF;
555:

Line 553: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');

549: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
550: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
551: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
552: G_PKG_NAME||': '||
553: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
554: END IF;
555:
556: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(
557: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,

Line 556: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(

552: G_PKG_NAME||': '||
553: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
554: END IF;
555:
556: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(
557: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
558: pv_tax_calendar_period => l_global_variables_rec.tax_period,
559: pv_source => l_global_variables_rec.source,
560: pv_process_name => 'SELECTION',

Line 570: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',

566: );
567:
568: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
570: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
571: G_PKG_NAME||': ' ||
572: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
573: END IF;
574:

Line 572: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');

568: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
569: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
570: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
571: G_PKG_NAME||': ' ||
572: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
573: END IF;
574:
575: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
576: FND_API.G_RET_STS_ERROR) then

Line 729: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',

725: -- Call the utility API to update selection_process columns of
726: -- jg_zz_vat_rep_status table by passing proper values.
727: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
729: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
730: G_PKG_NAME||': '||
731: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
732: END IF;
733:

Line 731: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');

727: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
728: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
729: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
730: G_PKG_NAME||': '||
731: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
732: END IF;
733:
734: l_selection_process_id := g_selection_process_id;
735: if l_selection_status_flag is null then

Line 740: JG_ZZ_VAT_REP_UTILITY.post_process_update(

736: l_selection_status_flag := fnd_api.g_ret_sts_success;
737: end if;
738:
739:
740: JG_ZZ_VAT_REP_UTILITY.post_process_update(
741: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
742: pv_tax_calendar_period => l_global_variables_rec.tax_period,
743: pv_source => l_global_variables_rec.source,
744: pv_process_name => 'SELECTION',

Line 754: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',

750: );
751:
752: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
754: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
755: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
756: END IF;
757:
758: IF l_return_status <> fnd_api.g_ret_sts_success THEN

Line 755: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');

751:
752: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
753: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
754: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
755: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
756: END IF;
757:
758: IF l_return_status <> fnd_api.g_ret_sts_success THEN
759: errbuf := l_return_message;

Line 1252: l_last_processed_date := JG_ZZ_VAT_REP_UTILITY.get_last_processed_date(

1248: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1249: END IF;
1250:
1251: --Find out the last final reported period
1252: l_last_processed_date := JG_ZZ_VAT_REP_UTILITY.get_last_processed_date(
1253: pn_vat_reporting_entity_id => p_global_variables_rec.vat_reporting_entity_id,
1254: pv_source => p_global_variables_rec.source,
1255: pv_process_name => 'FINAL REPORTING'
1256: );