DBA Data[Home] [Help]

APPS.ASO_TAX_INT dependencies on AR_SYSTEM_PARAMETERS

Line 887: -- Get the AR system parameters

883: IF p_qte_header_id is not null and p_qte_header_id <> FND_API.G_MISS_NUM then
884:
885: Begin
886:
887: -- Get the AR system parameters
888:
889: select tax_rounding_allow_override,
890: tax_header_level_flag,
891: tax_rounding_rule,

Line 897: from ar_system_parameters;

893: into l_tax_rounding_allow_override,
894: l_tax_header_level_flag,
895: l_tax_rounding_rule,
896: l_set_of_books_id
897: from ar_system_parameters;
898:
899: EXCEPTION
900:
901: WHEN NO_DATA_FOUND THEN

Line 904: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND from AR_SYSTEM_PARAMETERS table', 1, 'Y');

900:
901: WHEN NO_DATA_FOUND THEN
902:
903: IF aso_debug_pub.g_debug_flag = 'Y' THEN
904: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND from AR_SYSTEM_PARAMETERS table', 1, 'Y');
905: END IF;
906:
907: l_reason := 'No Data Found while selecting tax_rounding_rule, set_of_books_id';
908: l_reason := l_reason || 'from ar_system_parameters table.';

Line 908: l_reason := l_reason || 'from ar_system_parameters table.';

904: aso_debug_pub.add('ASO_TAX_LINE: NO_DATA_FOUND from AR_SYSTEM_PARAMETERS table', 1, 'Y');
905: END IF;
906:
907: l_reason := 'No Data Found while selecting tax_rounding_rule, set_of_books_id';
908: l_reason := l_reason || 'from ar_system_parameters table.';
909:
910: aso_quote_misc_pvt.debug_tax_info_notification( l_qte_header_rec,
911: l_Shipment_rec, l_reason);
912:

Line 917: aso_debug_pub.add('ASO_TAX_LINE: After selecting from AR_SYSTEM_PARAMETERS table.', 1, 'Y');

913: End;
914:
915: IF aso_debug_pub.g_debug_flag = 'Y' THEN
916:
917: aso_debug_pub.add('ASO_TAX_LINE: After selecting from AR_SYSTEM_PARAMETERS table.', 1, 'Y');
918: aso_debug_pub.add('l_tax_rounding_allow_override: '|| l_tax_rounding_allow_override, 1, 'Y');
919: aso_debug_pub.add('l_tax_header_level_flag: '|| l_tax_header_level_flag, 1, 'Y');
920: aso_debug_pub.add('l_tax_rounding_rule: '|| l_tax_rounding_rule, 1, 'Y');
921: aso_debug_pub.add('l_set_of_books_id: '|| l_set_of_books_id, 1, 'Y');

Line 2310: from ar_system_parameters;

2306: and (tax_calculation_flag = 'Y');
2307:
2308: Cursor c_set_of_books_id is
2309: select set_of_books_id
2310: from ar_system_parameters;
2311:
2312: Cursor c_INVOICE_SOURCE_ID is
2313: select INVOICE_SOURCE_ID
2314: FROM OE_TRANSACTION_TYPES

Line 2467: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');

2463: FETCH c_set_of_books_id into l_set_of_books_id;
2464: close c_set_of_books_id;
2465:
2466: IF aso_debug_pub.g_debug_flag = 'Y' THEN
2467: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After selecting from AR_SYSTEM_PARAMETERS table', 1, 'Y');
2468: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_set_of_books_id : '||l_set_of_books_id, 1, 'Y');
2469: END IF;
2470:
2471: