APPS.JG_ZZ_AR_AUTO_INVOICE dependencies on JG_ZZ_AR_AUTO_INVOICE

Line 1: PACKAGE BODY JG_ZZ_AR_AUTO_INVOICE AS

1: PACKAGE BODY JG_ZZ_AR_AUTO_INVOICE AS
2: /* $Header: jgzztnub.pls 120.16 2012/02/14 14:01:24 abuissa ship $ */
3:
4: Function Is_context_enabled (l_country_code In Varchar2) Return Boolean IS
5: l_exist Varchar2(30);

Line 143: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code TW';

139: --fnd_profile.get('ORG_ID',l_org_id);
140: l_org_id := MO_GLOBAL.get_current_org_id; -- bug 8304339
141:
142: If l_country_code = 'TW' Then
143: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code TW';
144: Open C_Trx_lines(p_request_id);
145: Fetch C_Trx_lines Bulk Collect Into trx_number, customer_trx_id;
146: Close C_Trx_lines;
147:

Line 205: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code AR';

201: Elsif l_country_code = 'AR' Then
202: --fnd_profile.get('ORG_ID',f_org_id);
203: f_org_id := MO_GLOBAL.get_current_org_id;
204:
205: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code AR';
206: Open C_AR_Trx_lines(p_request_id);
207: Fetch C_AR_Trx_lines Bulk Collect Into trx_number, customer_trx_id, global_attribute16,cust_trx_type_id; --bug 10038807
208: Close C_AR_Trx_lines;
209:

Line 289: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code BR';

285: Elsif l_country_code = 'BR' Then
286:
287: -- fnd_profile.get('ORG_ID',f_org_id);
288: f_org_id := MO_GLOBAL.get_current_org_id;
289: l_debug_loc := 'jg_zz_ar_auto_invoice.trx_num_upd, country code BR';
290: Open C_Trx_lines(p_request_id);
291: Fetch C_Trx_lines Bulk Collect Into trx_number, customer_trx_id;
292: Close C_Trx_lines;
293:

Line 795: fnd_file.put_line(fnd_file.log, 'Entering JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

791: l_error_msg varchar2(255);
792:
793: BEGIN
794:
795: fnd_file.put_line(fnd_file.log, 'Entering JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
796:
797: OPEN C_Batch;
798: FETCH C_Batch BULK COLLECT INTO batch_source_name, org_id;
799: CLOSE C_Batch;

Line 873: fnd_file.put_line(fnd_file.log, 'Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

869: END LOOP;
870: END LOOP;
871: END IF;
872:
873: fnd_file.put_line(fnd_file.log, 'Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
874:
875: EXCEPTION
876: WHEN OTHERS THEN
877: arp_standard.debug('-- Found an exception at UPD_TRX_DATE.');

Line 879: fnd_file.put_line(fnd_file.log, l_error_msg||'EXCEPTION: Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');

875: EXCEPTION
876: WHEN OTHERS THEN
877: arp_standard.debug('-- Found an exception at UPD_TRX_DATE.');
878: arp_standard.debug('-- ' || SQLERRM);
879: fnd_file.put_line(fnd_file.log, l_error_msg||'EXCEPTION: Exiting JG_ZZ_AR_AUTO_INVOICE.upd_trx_date...');
880: RAISE_APPLICATION_ERROR(- 20999,'Error during update of TRX_DATE on AI pre-processing - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
881: END upd_trx_date;
882: --ER 13528443 - end
883:

Line 884: End JG_ZZ_AR_AUTO_INVOICE;

880: RAISE_APPLICATION_ERROR(- 20999,'Error during update of TRX_DATE on AI pre-processing - '|| SQLCODE ||' -ERROR- '|| SQLERRM);
881: END upd_trx_date;
882: --ER 13528443 - end
883:
884: End JG_ZZ_AR_AUTO_INVOICE;
885: