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.JG_ZZ_VAT_SELECTION_PKG dependencies on FND_API

Line 492: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,

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,
493: FND_API.G_RET_STS_ERROR) then
494: l_selection_status_flag := fnd_api.g_ret_sts_error;
495: errbuf := l_return_message;
496: retcode := 2;

Line 493: FND_API.G_RET_STS_ERROR) then

489: );
490: END IF;
491:
492: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
493: FND_API.G_RET_STS_ERROR) then
494: l_selection_status_flag := fnd_api.g_ret_sts_error;
495: errbuf := l_return_message;
496: retcode := 2;
497: RETURN;

Line 494: l_selection_status_flag := fnd_api.g_ret_sts_error;

490: END IF;
491:
492: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
493: FND_API.G_RET_STS_ERROR) then
494: l_selection_status_flag := fnd_api.g_ret_sts_error;
495: errbuf := l_return_message;
496: retcode := 2;
497: RETURN;
498: end if;

Line 575: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,

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
577: l_selection_status_flag := fnd_api.g_ret_sts_error;
578: errbuf := l_return_message;
579: retcode := 2;

Line 576: FND_API.G_RET_STS_ERROR) then

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
577: l_selection_status_flag := fnd_api.g_ret_sts_error;
578: errbuf := l_return_message;
579: retcode := 2;
580: RETURN;

Line 577: l_selection_status_flag := fnd_api.g_ret_sts_error;

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
577: l_selection_status_flag := fnd_api.g_ret_sts_error;
578: errbuf := l_return_message;
579: retcode := 2;
580: RETURN;
581: end if;

Line 589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

585: p_vat_reporting_entity_id => l_mapping_rep_entity_id,
586: p_global_variables_rec => l_global_variables_rec,
587: x_return_status => l_return_status);
588:
589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: l_selection_status_flag := fnd_api.g_ret_sts_error;
591: errbuf := 'Unexpected error in get_VAT_reporting_details';
592: retcode := 2;
593: RETURN;

Line 590: l_selection_status_flag := fnd_api.g_ret_sts_error;

586: p_global_variables_rec => l_global_variables_rec,
587: x_return_status => l_return_status);
588:
589: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
590: l_selection_status_flag := fnd_api.g_ret_sts_error;
591: errbuf := 'Unexpected error in get_VAT_reporting_details';
592: retcode := 2;
593: RETURN;
594: ELSE

Line 603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

599: p_global_variables_rec => l_global_variables_rec,
600: x_return_status => l_return_status);
601: END IF;
602:
603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: l_selection_status_flag := fnd_api.g_ret_sts_error;
605: errbuf := 'Unexpected error in get_period_date_range';
606: retcode := 2;
607: RETURN;

Line 604: l_selection_status_flag := fnd_api.g_ret_sts_error;

600: x_return_status => l_return_status);
601: END IF;
602:
603: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
604: l_selection_status_flag := fnd_api.g_ret_sts_error;
605: errbuf := 'Unexpected error in get_period_date_range';
606: retcode := 2;
607: RETURN;
608: ELSE

Line 679: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,

675: x_return_status => l_return_status,
676: x_errbuf => l_return_message
677: );
678:
679: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
680: FND_API.G_RET_STS_ERROR) then
681: l_selection_status_flag := fnd_api.g_ret_sts_error;
682: errbuf := l_return_message;
683: retcode := 2;

Line 680: FND_API.G_RET_STS_ERROR) then

676: x_errbuf => l_return_message
677: );
678:
679: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
680: FND_API.G_RET_STS_ERROR) then
681: l_selection_status_flag := fnd_api.g_ret_sts_error;
682: errbuf := l_return_message;
683: retcode := 2;
684: RETURN;

Line 681: l_selection_status_flag := fnd_api.g_ret_sts_error;

677: );
678:
679: if l_return_status in ( FND_API.G_RET_STS_UNEXP_ERROR,
680: FND_API.G_RET_STS_ERROR) then
681: l_selection_status_flag := fnd_api.g_ret_sts_error;
682: errbuf := l_return_message;
683: retcode := 2;
684: RETURN;
685: end if;

Line 708: l_selection_status_flag := fnd_api.g_ret_sts_error;

704: -- And bulk insert into JG_ZZ_VAT_TRX_DETAILS.
705: fetch_tax_data(l_global_variables_rec,
706: g_conc_request_id);
707: ELSE
708: l_selection_status_flag := fnd_api.g_ret_sts_error;
709: errbuf := l_intersect_domain_err;
710: retcode := 2;
711: RETURN;
712: END IF;

Line 736: l_selection_status_flag := fnd_api.g_ret_sts_success;

732: END IF;
733:
734: l_selection_process_id := g_selection_process_id;
735: if l_selection_status_flag is null then
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(

Line 758: IF l_return_status <> fnd_api.g_ret_sts_success THEN

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;
760: retcode := 2;
761: RETURN;
762: END IF;

Line 838: x_return_status := FND_API.G_RET_STS_SUCCESS;

834: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
835: END IF;
836:
837: /*Set the return status to Success */
838: x_return_status := FND_API.G_RET_STS_SUCCESS;
839:
840: delete from JG_ZZ_VAT_TRX_DETAILS
841: where reporting_Status_id = p_reporting_status_id;
842:

Line 859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

855: END IF;
856:
857: EXCEPTION
858: WHEN OTHERS THEN
859: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
860: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
861:
862: IF g_debug_flag = 'Y' THEN
863: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 1066: x_return_status := FND_API.G_RET_STS_SUCCESS;

1062: G_PKG_NAME||': '||l_api_name||'()+');
1063: END IF;
1064:
1065: /*Set the return status to Success */
1066: x_return_status := FND_API.G_RET_STS_SUCCESS;
1067:
1068: IF g_debug_flag = 'Y' THEN
1069: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1070: END IF;

Line 1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1099: END IF;
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1104:
1105: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1106:
1107: IF g_debug_flag = 'Y' THEN

Line 1156: x_return_status := FND_API.G_RET_STS_SUCCESS;

1152: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
1153: END IF;
1154:
1155: /*Set the return status to Success */
1156: x_return_status := FND_API.G_RET_STS_SUCCESS;
1157:
1158: IF g_debug_flag = 'Y' THEN
1159: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
1160: END IF;

Line 1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1199: END IF;
1200:
1201: EXCEPTION
1202: WHEN OTHERS THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204:
1205: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
1206:
1207: IF g_debug_flag = 'Y' THEN

Line 2659: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2655: END IF;
2656:
2657: EXCEPTION
2658: WHEN OTHERS THEN
2659: --x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2660: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
2661:
2662: IF g_debug_flag = 'Y' THEN
2663: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 3025: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3021: END IF;
3022:
3023: EXCEPTION
3024: WHEN OTHERS THEN
3025: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3026: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3027:
3028: IF g_debug_flag = 'Y' THEN
3029: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 3152: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3148: xv_return_message => l_return_message
3149: );
3150: END IF;
3151:
3152: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3153: x_intersect_domain_err := l_return_message;
3154: p_global_variables_rec.retcode := 2;
3155: RETURN;
3156: END IF;

Line 3174: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

3170: END IF;
3171:
3172: EXCEPTION
3173: WHEN OTHERS THEN
3174: -- x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3175: g_error_buffer := sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80);
3176:
3177: IF g_debug_flag = 'Y' THEN
3178: FND_FILE.PUT_LINE(FND_FILE.LOG, g_error_buffer);

Line 3367: -- xv_return_status := fnd_api.g_ret_sts_error;

3363: FND_MESSAGE.SET_NAME('JG','JG_ZZ_VAT_TRX_OVERLAPPING');
3364: FND_MESSAGE.SET_TOKEN('LOG_FILE', lv_filename );
3365: FND_MESSAGE.SET_TOKEN('LOG_LOCATION', lv_utl_location );
3366: xv_return_message := FND_MESSAGE.GET;
3367: -- xv_return_status := fnd_api.g_ret_sts_error;
3368:
3369: IF g_debug_flag = 'Y' THEN
3370: FND_FILE.PUT_LINE(FND_FILE.LOG,xv_return_message);
3371: END IF;

Line 3390: p_init_msg_list => fnd_api.g_false ,

3386: /* Call the eBtax API to update transactions in eBtax as finally reported */
3387: zx_extract_pkg.zx_upd_legal_reporting_status
3388: (
3389: p_api_version => jg_zz_vat_rep_final_reporting.gn_api_version ,
3390: p_init_msg_list => fnd_api.g_false ,
3391: p_commit => fnd_api.g_false ,
3392: p_validation_level => null ,
3393: p_application_id_tbl => ltn_application_id ,
3394: p_entity_code_tbl => ltv_entity_code ,

Line 3391: p_commit => fnd_api.g_false ,

3387: zx_extract_pkg.zx_upd_legal_reporting_status
3388: (
3389: p_api_version => jg_zz_vat_rep_final_reporting.gn_api_version ,
3390: p_init_msg_list => fnd_api.g_false ,
3391: p_commit => fnd_api.g_false ,
3392: p_validation_level => null ,
3393: p_application_id_tbl => ltn_application_id ,
3394: p_entity_code_tbl => ltv_entity_code ,
3395: p_event_class_code_tbl => ltv_event_class_code ,

Line 3406: IF l_return_status <> fnd_api.g_ret_sts_success THEN

3402: x_msg_count => l_msg_count ,
3403: x_msg_data => l_return_message
3404: );
3405:
3406: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3407: xv_return_status := l_return_status;
3408: xv_return_message := l_return_message;
3409: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unexpected error occurred in the
3410: procedure zx_extract_pkg.zx_upd_legal_reporting_status :'||l_return_message);

Line 3445: xv_return_status := fnd_api.g_ret_sts_success;

3441: where vat_transaction_id = IdList(i) ;
3442:
3443: END IF ; --IF l_trx_count > 0 THEN
3444:
3445: xv_return_status := fnd_api.g_ret_sts_success;
3446: xv_return_message := 'None of the transactions are finally reported';
3447: IF ( G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
3448: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name, xv_return_message);
3449: END IF;

Line 3463: xv_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3459:
3460:
3461: EXCEPTION
3462: WHEN OTHERS THEN
3463: xv_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3464: xv_return_message := 'Unexpected error occurred in the
3465: procedure PURGE_REPORT_FINALREP:' || SQLCODE || ' ' ||
3466: SUBSTR(SQLERRM,1,80) ;
3467: IF ( G_LEVEL_EXCEPTION >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 3688: x_return_status := FND_API.G_RET_STS_SUCCESS;

3684: IF g_debug_flag = 'Y' THEN
3685: FND_FILE.PUT_LINE(FND_FILE.LOG, G_PKG_NAME||': '||l_api_name||'()+');
3686: END IF;
3687:
3688: x_return_status := FND_API.G_RET_STS_SUCCESS;
3689: x_errbuf := NULL;
3690:
3691: IF p_legal_entity_id IS NOT NULL THEN
3692: SELECT ledger_id

Line 3776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3772: 'Unable to update the Tax_Invoice_Date in
3773: PAYABLES_MAINTENANCE PROGRAM' || ' error_msg = '
3774: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3775: END IF;
3776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3777: x_errbuf := sqlcode || ':' || SUBSTR(SQLERRM, 1, 80);
3778: return;
3779:
3780: END; -- Payables_Maintenance_Prog

Line 3822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3818: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3819: 'Error in updating Tax_Invoice_Date ' || ' error_msg = '
3820: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3821: END IF;
3822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3823: x_errbuf := sqlcode || ':' || SUBSTR(SQLERRM, 1, 80);
3824: END;
3825:
3826: END LOOP;

Line 3841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3837: 'Unable to update the Tax_Invoice_Date in
3838: RECEIVABLES_MAINTENANCE PROGRAM' || ' error_msg = '
3839: || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80));
3840: END IF;
3841: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3842: x_errbuf := sqlcode || ':' || SUBSTR(SQLERRM, 1, 80);
3843: END; -- Receivables_maintenance_prog
3844:
3845: END IF;

Line 3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3859: FND_LOG.STRING(G_LEVEL_EXCEPTION,G_MODULE_NAME||l_api_name,
3860: 'Unable to update the Tax_Invoice_Date in TAX DATE MAINTENANCE PROGRAM'
3861: || ' error_msg = ' || sqlcode || ':' || SUBSTR(SQLERRM, 1, 80) );
3862: END IF;
3863: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3864: x_errbuf := sqlcode || ':' || SUBSTR(SQLERRM, 1, 80);
3865: END tax_date_maintenance_program;
3866:
3867: