APPS.JG_ZZ_VAT_ALLOC_PRC_PKG dependencies on FND_API

Line 41: xv_return_status := fnd_api.g_ret_sts_unexp_error;

37: end if;
38:
39: exception
40: when others then
41: xv_return_status := fnd_api.g_ret_sts_unexp_error;
42: xv_return_message := 'jg_zz_vat_alloc_prc_pkg.purge_allocation_data ~ Unexpected Error -' || sqlerrm;
43: end purge_allocation_data;
44:
45: PROCEDURE insert_allocation_error (

Line 92: xv_return_status := fnd_api.g_ret_sts_unexp_error;

88: );
89:
90: exception
91: when others then
92: xv_return_status := fnd_api.g_ret_sts_unexp_error;
93: xv_return_message := 'jg_zz_vat_alloc_prc_pkg.insert_allocation_error ~ Unexpected Error -' || sqlerrm;
94: END insert_allocation_error;
95:
96: PROCEDURE update_allocation_error (

Line 117: xv_return_status := fnd_api.g_ret_sts_unexp_error;

113: AND period_type = pv_period_type;
114:
115: exception
116: when others then
117: xv_return_status := fnd_api.g_ret_sts_unexp_error;
118: xv_return_message := 'jg_zz_vat_alloc_prc_pkg.update_allocation_error ~ Unexpected Error -' || sqlerrm;
119: end update_allocation_error;
120:
121: PROCEDURE delete_allocation_error (

Line 137: xv_return_status := fnd_api.g_ret_sts_unexp_error;

133: AND period_type = pv_period_type;
134:
135: exception
136: when others then
137: xv_return_status := fnd_api.g_ret_sts_unexp_error;
138: xv_return_message := 'jg_zz_vat_alloc_prc_pkg.delete_allocation_error ~ Unexpected Error -' || sqlerrm;
139: end delete_allocation_error;
140:
141: /* Main procedure that performs the allocation */

Line 426: if lv_return_flag in (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) then

422: );
423:
424:
425: /* raise error if validation failed */
426: if lv_return_flag in (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) then
427: if gv_debug_flag then
428: fnd_file.put_line(fnd_file.log, 'run allocation - Error JG_ZZ_VAT_REP_UTILITY.validate_process_initiation. value-'||lv_return_flag);
429: end if;
430:

Line 724: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then

720: end if;
721: end if;
722:
723: /* raise error if validation failed */
724: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then
725: xv_errbuf := lv_return_message;
726: xv_retcode := 2;
727: return;
728: end if;

Line 744: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then

740: xv_return_message => lv_return_message
741: );
742:
743: /* raise error if validation failed */
744: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then
745: xv_errbuf := lv_return_message;
746: xv_retcode := 2;
747: return;
748: end if;

Line 783: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then

779: xv_return_message => lv_return_message
780: );
781:
782: /* raise error if above call failed */
783: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then
784: xv_errbuf := lv_return_message;
785: xv_retcode := 2;
786: return;
787: end if;

Line 810: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then

806: xv_return_status => lv_return_flag,
807: xv_return_message => lv_return_message
808: );
809: /* raise error if validation failed */
810: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then
811: xv_errbuf := lv_return_message;
812: xv_retcode := 2;
813: return;
814: end if;

Line 831: lv_allocation_status_flag := fnd_api.g_ret_sts_error;

827: (lv_tax_box IS NULL and lv_taxable_box IS NULL)
828: then
829:
830: lv_allocation_errored_flag := g_yes;
831: lv_allocation_status_flag := fnd_api.g_ret_sts_error;
832: end if;
833:
834: if gv_debug_flag then
835: fnd_file.put_line(fnd_file.log, 'run allocation - periodTypeloop 3. BefDML.'

Line 882: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then

878:
879: lv_check_alloc_trans := lv_check_alloc_trans + 1;
880:
881: /* raise error if error is returned from the call */
882: if lv_return_flag in (fnd_api.g_ret_sts_unexp_error) then
883: xv_errbuf := lv_return_message;
884: xv_retcode := 2;
885: return;
886: end if;

Line 903: lv_allocation_status_flag := fnd_api.g_ret_sts_success;

899:
900: /* derive the sequence value for the allocation process that will be punched in the status table
901: Preparation for call to post process update */
902: if lv_allocation_status_flag is null then
903: lv_allocation_status_flag := fnd_api.g_ret_sts_success;
904: end if;
905:
906: if ln_allocation_process_id is null then
907: select jg_zz_vat_rep_status_s2.nextval into ln_allocation_process_id from dual;

Line 935: if lv_return_flag in (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) then

931: ||' lv_return_flag:'||lv_return_flag
932: );
933: end if;
934: /* raise error if validation failed */
935: if lv_return_flag in (fnd_api.g_ret_sts_error, fnd_api.g_ret_sts_unexp_error) then
936: xv_errbuf := lv_return_message;
937: xv_retcode := 2;
938: return;
939: end if;

Line 1301: xv_return_status := fnd_api.g_ret_sts_unexp_error;

1297: when others then
1298: if gv_debug_flag then
1299: fnd_file.put_line(fnd_file.log, 'allocate_box - ERROR lv_statement:'||lv_statement );
1300: end if;
1301: xv_return_status := fnd_api.g_ret_sts_unexp_error;
1302: xv_return_message := 'jg_zz_vat_alloc_prc_pkg.allocate_box ~ Unexpected Error -' || sqlerrm;
1303:
1304: end allocate_box;
1305: