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.ASO_TAX_INT dependencies on FND_GLOBAL

Line 44: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

40: l_arp_tax_tbl ARP_TAX.tax_rec_tbl_type;
41:
42: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
43:
44: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
45: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
46: CURSOR C_Tax_Code (c_tax_id NUMBER) IS
47: SELECT tax_code from AR_VAT_TAX
48: WHERE vat_tax_id = c_tax_id;

Line 45: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

41:
42: l_tax_detail_rec ASO_QUOTE_PUB.Tax_Detail_Rec_Type;
43:
44: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
45: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
46: CURSOR C_Tax_Code (c_tax_id NUMBER) IS
47: SELECT tax_code from AR_VAT_TAX
48: WHERE vat_tax_id = c_tax_id;
49: BEGIN

Line 236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

232: l_hd_exempt_reason_code VARCHAR2(30);
233: l_exempt_flag VARCHAR2(1);
234: l_exempt_number VARCHAR2(80);
235: l_exempt_reason_code VARCHAR2(30);
236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
237: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
238: CURSOR c_hd_tax(qt_hdr_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code
239: FROM
240: aso_tax_details WHERE quote_header_id= qt_hdr_id

Line 237: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

233: l_exempt_flag VARCHAR2(1);
234: l_exempt_number VARCHAR2(80);
235: l_exempt_reason_code VARCHAR2(30);
236: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
237: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
238: CURSOR c_hd_tax(qt_hdr_id NUMBER,q_ship_id NUMBER) IS SELECT tax_exempt_flag,tax_exempt_number,tax_exempt_reason_code
239: FROM
240: aso_tax_details WHERE quote_header_id= qt_hdr_id
241: and quote_shipment_id= q_ship_id and quote_line_id IS NULL;

Line 373: last_updated_by = fnd_global.user_id,

369: SET tax_exempt_flag = l_hd_exempt_flag ,
370: tax_exempt_number = l_hd_exempt_number,
371: tax_exempt_reason_code = l_hd_exempt_reason_code,
372: last_update_date = sysdate,
373: last_updated_by = fnd_global.user_id,
374: last_update_login = fnd_global.conc_login_id,
375: tax_date = l_sys_date
376: WHERE quote_header_id = c_header_id
377: and quote_line_id = c_line_id

Line 374: last_update_login = fnd_global.conc_login_id,

370: tax_exempt_number = l_hd_exempt_number,
371: tax_exempt_reason_code = l_hd_exempt_reason_code,
372: last_update_date = sysdate,
373: last_updated_by = fnd_global.user_id,
374: last_update_login = fnd_global.conc_login_id,
375: tax_date = l_sys_date
376: WHERE quote_header_id = c_header_id
377: and quote_line_id = c_line_id
378: and quote_shipment_id = c_shipment_id;

Line 715: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

711: l_reason VARCHAR2(4000);
712: l_ship_from_org_id NUMBER;
713: l_party_id NUMBER;
714:
715: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
716: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
717: l_ship_loc_asgn_id NUMBER;
718: l_bill_loc_asgn_id NUMBER;
719:

Line 716: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

712: l_ship_from_org_id NUMBER;
713: l_party_id NUMBER;
714:
715: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
716: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
717: l_ship_loc_asgn_id NUMBER;
718: l_bill_loc_asgn_id NUMBER;
719:
720: l_tax_start_time number;

Line 1110: l_reason := l_reason || fnd_global.newline();

1106: END IF;
1107:
1108: l_reason := 'No Data Found Exception raised while selecting cust_trx_type_id';
1109: l_reason := l_reason || 'from ra_cust_trx_types_all. ';
1110: l_reason := l_reason || fnd_global.newline();
1111: l_reason := l_reason || 'Please check Default order type id profile is correctly';
1112: l_reason := l_reason || 'set. Also pl verify the';
1113: l_reason := l_reason || fnd_global.newline();
1114: l_reason := l_reason || 'the value the profile is returning. No tax call being';

Line 1113: l_reason := l_reason || fnd_global.newline();

1109: l_reason := l_reason || 'from ra_cust_trx_types_all. ';
1110: l_reason := l_reason || fnd_global.newline();
1111: l_reason := l_reason || 'Please check Default order type id profile is correctly';
1112: l_reason := l_reason || 'set. Also pl verify the';
1113: l_reason := l_reason || fnd_global.newline();
1114: l_reason := l_reason || 'the value the profile is returning. No tax call being';
1115: l_reason := l_reason || 'being made to tax engine.';
1116:
1117: aso_quote_misc_pvt.debug_tax_info_notification(l_qte_header_rec,

Line 1753: l_reason := l_reason || fnd_global.newline();

1749: END IF;
1750:
1751: l_reason := 'No Data Found Exception when selecting transaction_type_id from ';
1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';
1753: l_reason := l_reason || fnd_global.newline();
1754: l_reason := l_reason || 'Please check Default order type id profile is ';
1755: l_reason := l_reason || 'correctly set. Also pl verify the';
1756: l_reason := l_reason || fnd_global.newline();
1757: l_reason := l_reason || 'the value the profile is returning. No tax call ';

Line 1756: l_reason := l_reason || fnd_global.newline();

1752: l_reason := l_reason || 'ra_cust_trx_types_all and oe_transaction_types_vl';
1753: l_reason := l_reason || fnd_global.newline();
1754: l_reason := l_reason || 'Please check Default order type id profile is ';
1755: l_reason := l_reason || 'correctly set. Also pl verify the';
1756: l_reason := l_reason || fnd_global.newline();
1757: l_reason := l_reason || 'the value the profile is returning. No tax call ';
1758: l_reason := l_reason || 'being made to tax engine.';
1759:
1760: aso_quote_misc_pvt.debug_tax_info_notification(l_qte_header_rec,

Line 1960: l_reason := l_reason || fnd_global.newline();

1956:
1957: END IF;
1958:
1959: l_reason := 'Exception in call to tax engine arp_tax_crm_integration_pkg.summary';
1960: l_reason := l_reason || fnd_global.newline();
1961: l_reason := l_reason || 'Table count returned from tax engine x_tax_out_tbl.count :';
1962: l_reason := l_reason || fnd_global.newline();
1963: l_reason := l_reason || x_tax_out_tbl.count;
1964:

Line 1962: l_reason := l_reason || fnd_global.newline();

1958:
1959: l_reason := 'Exception in call to tax engine arp_tax_crm_integration_pkg.summary';
1960: l_reason := l_reason || fnd_global.newline();
1961: l_reason := l_reason || 'Table count returned from tax engine x_tax_out_tbl.count :';
1962: l_reason := l_reason || fnd_global.newline();
1963: l_reason := l_reason || x_tax_out_tbl.count;
1964:
1965: FOR i IN 1.. x_tax_out_tbl.count LOOP
1966:

Line 1969: l_reason := l_reason || fnd_global.newline();

1965: FOR i IN 1.. x_tax_out_tbl.count LOOP
1966:
1967: l_reason := l_reason || 'x_tax_out_tbl('||i||').vat_tax_id : ';
1968: l_reason := l_reason || x_tax_out_tbl(i).vat_tax_id;
1969: l_reason := l_reason || fnd_global.newline();
1970: l_reason := l_reason || 'x_tax_out_tbl('||i||').extended_amount: ';
1971: l_reason := l_reason || x_tax_out_tbl(i).extended_amount;
1972: l_reason := l_reason || fnd_global.newline();
1973: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_rate: ';

Line 1972: l_reason := l_reason || fnd_global.newline();

1968: l_reason := l_reason || x_tax_out_tbl(i).vat_tax_id;
1969: l_reason := l_reason || fnd_global.newline();
1970: l_reason := l_reason || 'x_tax_out_tbl('||i||').extended_amount: ';
1971: l_reason := l_reason || x_tax_out_tbl(i).extended_amount;
1972: l_reason := l_reason || fnd_global.newline();
1973: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_rate: ';
1974: l_reason := l_reason || x_tax_out_tbl(i).tax_rate;
1975: l_reason := l_reason || fnd_global.newline();
1976: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_amount: ';

Line 1975: l_reason := l_reason || fnd_global.newline();

1971: l_reason := l_reason || x_tax_out_tbl(i).extended_amount;
1972: l_reason := l_reason || fnd_global.newline();
1973: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_rate: ';
1974: l_reason := l_reason || x_tax_out_tbl(i).tax_rate;
1975: l_reason := l_reason || fnd_global.newline();
1976: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_amount: ';
1977: l_reason := l_reason || x_tax_out_tbl(1).tax_amount;
1978: l_reason := l_reason || fnd_global.newline();
1979: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_control: ';

Line 1978: l_reason := l_reason || fnd_global.newline();

1974: l_reason := l_reason || x_tax_out_tbl(i).tax_rate;
1975: l_reason := l_reason || fnd_global.newline();
1976: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_amount: ';
1977: l_reason := l_reason || x_tax_out_tbl(1).tax_amount;
1978: l_reason := l_reason || fnd_global.newline();
1979: l_reason := l_reason || 'x_tax_out_tbl('||i||').tax_control: ';
1980: l_reason := l_reason || x_tax_out_tbl(1).tax_control;
1981:
1982: End Loop;

Line 2238: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;

2234: l_SHIP_FROM_LOCATION_ID NUMBER;
2235: l_ship_to_location NUMBER;
2236: l_bill_to_location NUMBER;
2237: l_party_site_id NUMBER;
2238: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2239: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
2240: x_legal_entity XLE_BUSINESSINFO_GRP.otoc_le_rec;
2241: l_batch_source NUMBER;
2242: l_init_msg_list VARCHAR2(1);

Line 2239: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;

2235: l_ship_to_location NUMBER;
2236: l_bill_to_location NUMBER;
2237: l_party_site_id NUMBER;
2238: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
2239: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
2240: x_legal_entity XLE_BUSINESSINFO_GRP.otoc_le_rec;
2241: l_batch_source NUMBER;
2242: l_init_msg_list VARCHAR2(1);
2243: l_commit VARCHAR2(1) :=NULL;