DBA Data[Home] [Help]

APPS.JG_ZZ_VAT_SELECTION_PKG dependencies on JG_ZZ_VAT_REP_UTILITY

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

346: | main() |
347: | |
348: | DESCRIPTION |
349: | This procedure calls |
350: | (1) JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities to validate and |
351: | determine whether to create ACCOUNTING reporting entities or not. |
352: | (2) JG_ZZ_VAT_REP_UTILITY.validate_process_initiation to validate and |
353: | determine whether to proceed with selection or not. |
354: | (2) Insert status information into jg_zz_vat_rep_status table. |

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

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

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

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

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

490: | reporting entity identifier. |
491: +--------------------------------------------------------------------*/
492: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
494: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
495: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
496: ||'()+');
497: END IF;
498:

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

491: +--------------------------------------------------------------------*/
492: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
493: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
494: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.BEGIN',
495: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'
496: ||'()+');
497: END IF;
498:
499:

Line 500: JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities(

496: ||'()+');
497: END IF;
498:
499:
500: JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities(
501: pv_entity_level_code => l_global_variables_rec.reporting_entity_level,
502: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
503: pn_ledger_id => l_global_variables_rec.ledger,
504: pv_balancing_segment_value => l_global_variables_rec.bsv,

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

508: );
509:
510: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
511: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
512: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
513: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
514: );
515: END IF;
516:

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

509:
510: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
511: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
512: 'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'.END',
513: G_PKG_NAME||': '||'JG_ZZ_VAT_REP_UTILITY.maintain_selection_entities'||'()-'
514: );
515: END IF;
516:
517:

Line 598: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |

594: | previous run from jg_zz_vat_trx_details table by calling |
595: | jg_zz_vat_selection_pkg.purge_tax_data. |
596: | (5) Before re-selection, update the status information (nullify) |
597: | of the selection process for the given combination by calling |
598: | JG_ZZ_VAT_REP_UTILITY.pre_process_update procedure. |
599: | (6) If Selection is not yet initiated for the given combination |
600: | Validate if there is any gap in selection as per calendar |
601: | (7) Inserts status information of the Selection process into the |
602: | jg_zz_vat_rep_status table. |

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

602: | jg_zz_vat_rep_status table. |
603: +--------------------------------------------------------------------*/
604: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
606: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
607: G_PKG_NAME||': '||
608: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
609: END IF;
610:

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

604: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
605: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
606: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.BEGIN',
607: G_PKG_NAME||': '||
608: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
609: END IF;
610:
611: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(
612: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,

Line 611: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(

607: G_PKG_NAME||': '||
608: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()+');
609: END IF;
610:
611: JG_ZZ_VAT_REP_UTILITY.validate_process_initiation(
612: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
613: pv_tax_calendar_period => l_global_variables_rec.tax_period,
614: pv_source => l_global_variables_rec.source,
615: pv_process_name => 'SELECTION',

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

621: );
622:
623: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
625: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
626: G_PKG_NAME||': ' ||
627: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
628: END IF;
629:

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

623: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
624: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
625: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'.END',
626: G_PKG_NAME||': ' ||
627: 'JG_ZZ_VAT_REP_UTILITY.validate_process_initiation'||'()-');
628: END IF;
629:
630: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
631: FND_API.G_RET_STS_ERROR) then

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

780: -- Call the utility API to update selection_process columns of
781: -- jg_zz_vat_rep_status table by passing proper values.
782: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
784: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
785: G_PKG_NAME||': '||
786: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
787: END IF;
788:

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

782: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
783: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
784: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.BEGIN',
785: G_PKG_NAME||': '||
786: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()+');
787: END IF;
788:
789: l_selection_process_id := g_selection_process_id;
790: if l_selection_status_flag is null then

Line 795: JG_ZZ_VAT_REP_UTILITY.post_process_update(

791: l_selection_status_flag := fnd_api.g_ret_sts_success;
792: end if;
793:
794:
795: JG_ZZ_VAT_REP_UTILITY.post_process_update(
796: pn_vat_reporting_entity_id => l_global_variables_rec.vat_reporting_entity_id,
797: pv_tax_calendar_period => l_global_variables_rec.tax_period,
798: pv_source => l_global_variables_rec.source,
799: pv_process_name => 'SELECTION',

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

805: );
806:
807: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
809: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
810: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
811: END IF;
812:
813: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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

806:
807: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
808: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||
809: 'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'.END',
810: G_PKG_NAME||': ' ||'JG_ZZ_VAT_REP_UTILITY.post_process_update'||'()-');
811: END IF;
812:
813: IF l_return_status <> fnd_api.g_ret_sts_success THEN
814: errbuf := l_return_message;

Line 1336: l_last_processed_date := JG_ZZ_VAT_REP_UTILITY.get_last_processed_date(

1332:
1333: -- END Code to check if this is a very first reporting period.
1334:
1335: --Find out the last final reported period
1336: l_last_processed_date := JG_ZZ_VAT_REP_UTILITY.get_last_processed_date(
1337: pn_vat_reporting_entity_id => p_global_variables_rec.vat_reporting_entity_id,
1338: pv_source => p_global_variables_rec.source,
1339: pv_process_name => 'FINAL REPORTING'
1340: );