45: functional_currency in out nocopy varchar2
46: ) is
47:
48: begin
49: customer_type := arp_standard.ar_lookup('CUSTOMER_TYPE','R');
50:
51: tax_printing_option := arp_standard.sysparm.tax_invoice_print;
52:
53: begin
47:
48: begin
49: customer_type := arp_standard.ar_lookup('CUSTOMER_TYPE','R');
50:
51: tax_printing_option := arp_standard.sysparm.tax_invoice_print;
52:
53: begin
54: select gr.name
55: into grouping_rule
53: begin
54: select gr.name
55: into grouping_rule
56: from ra_grouping_rules gr
57: where gr.grouping_rule_id = arp_standard.sysparm.default_grouping_rule_id
58: and trunc(sysdate) BETWEEN gr.start_date AND nvl(gr.end_date, trunc(sysdate));
59: exception
60: when NO_DATA_FOUND then
61: null;
60: when NO_DATA_FOUND then
61: null;
62: end;
63:
64: --l_sob_id := arp_standard.sysparm.set_of_books_id;
65: --
66: --
67: ---Bug:2420993,Handled the following exception.
68: --
69: begin
70: SELECT currency_code
71: INTO functional_currency
72: FROM gl_sets_of_books
73: WHERE set_of_books_id = arp_standard.sysparm.set_of_books_id;
74: exception
75: when NO_DATA_FOUND then
76: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
77: end;
72: FROM gl_sets_of_books
73: WHERE set_of_books_id = arp_standard.sysparm.set_of_books_id;
74: exception
75: when NO_DATA_FOUND then
76: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
77: end;
78:
79: --
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
76: arp_standard.fnd_message( 'ARTA_SET_OF_BOOKS_ID_NOT_FOUND' );
77: end;
78:
79: --
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
77: end;
78:
79: --
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
78:
79: --
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
79: --
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
87: home_country_code := arp_standard.sysparm.default_country;
80: create_reciprocal := arp_standard.sysparm.create_reciprocal_flag;
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
87: home_country_code := arp_standard.sysparm.default_country;
88: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
81: auto_cust_numbering := arp_standard.sysparm.generate_customer_number;
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
87: home_country_code := arp_standard.sysparm.default_country;
88: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
89: --
82: auto_site_numbering := arp_standard.sysparm.auto_site_numbering;
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
87: home_country_code := arp_standard.sysparm.default_country;
88: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
89: --
90: if ( default_country_code is null ) then
83: address_validation := arp_standard.sysparm.address_validation;
84: location_structure_id := arp_standard.sysparm.location_structure_id;
85: from_postal_code := arp_standard.sysparm.from_postal_code;
86: to_postal_code := arp_standard.sysparm.to_postal_code;
87: home_country_code := arp_standard.sysparm.default_country;
88: fnd_profile.get('DEFAULT_COUNTRY',default_country_code);
89: --
90: if ( default_country_code is null ) then
91: default_country_code := home_country_code;