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

Line 9: g_user_id NUMBER(15) := fnd_global.user_id;

5: g_level_procedure CONSTANT NUMBER := fnd_log.level_procedure;
6: g_module_name CONSTANT VARCHAR2(100) := 'AP.PLSQL.POS_BATCH_IMPORT_PKG';
7:
8: g_source VARCHAR2(30) := 'IMPORT';
9: g_user_id NUMBER(15) := fnd_global.user_id;
10: g_login_id NUMBER(15) := fnd_global.login_id;
11:
12: l_error_msg_tbl error_handler.error_tbl_type;
13:

Line 10: g_login_id NUMBER(15) := fnd_global.login_id;

6: g_module_name CONSTANT VARCHAR2(100) := 'AP.PLSQL.POS_BATCH_IMPORT_PKG';
7:
8: g_source VARCHAR2(30) := 'IMPORT';
9: g_user_id NUMBER(15) := fnd_global.user_id;
10: g_login_id NUMBER(15) := fnd_global.login_id;
11:
12: l_error_msg_tbl error_handler.error_tbl_type;
13:
14: --Function: Insert_Rejections

Line 607: l_request_id NUMBER := fnd_global.conc_request_id;

603: x_msg_count OUT NOCOPY NUMBER,
604: x_msg_data OUT NOCOPY VARCHAR2
605: ) IS
606: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_VENDOR';
607: l_request_id NUMBER := fnd_global.conc_request_id;
608:
609: l_return_status VARCHAR2(2000);
610: l_msg_count NUMBER;
611: l_msg_data VARCHAR2(2000);

Line 1229: l_request_id NUMBER := fnd_global.conc_request_id;

1225: x_msg_count OUT NOCOPY NUMBER,
1226: x_msg_data OUT NOCOPY VARCHAR2
1227: ) IS
1228: l_api_name CONSTANT VARCHAR2(30) := 'ENABLE_PARTY_AS_SUPPLIER';
1229: l_request_id NUMBER := fnd_global.conc_request_id;
1230:
1231: l_return_status VARCHAR2(2000);
1232: l_msg_count NUMBER;
1233: l_msg_data VARCHAR2(2000);

Line 1649: l_request_id NUMBER := fnd_global.conc_request_id;

1645: x_msg_count OUT NOCOPY NUMBER,
1646: x_msg_data OUT NOCOPY VARCHAR2
1647: ) IS
1648: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VENDOR';
1649: l_request_id NUMBER := fnd_global.conc_request_id;
1650:
1651: l_return_status VARCHAR2(2000);
1652: l_msg_count NUMBER;
1653: l_msg_data VARCHAR2(2000);

Line 2046: l_request_id NUMBER := fnd_global.conc_request_id;

2042: x_msg_data OUT NOCOPY VARCHAR2
2043: ) IS
2044:
2045: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDORS';
2046: l_request_id NUMBER := fnd_global.conc_request_id;
2047:
2048: l_return_status VARCHAR2(2000);
2049: l_msg_count NUMBER;
2050: l_msg_data VARCHAR2(2000);

Line 2608: l_request_id NUMBER := fnd_global.conc_request_id;

2604: x_msg_count OUT NOCOPY NUMBER,
2605: x_msg_data OUT NOCOPY VARCHAR2
2606: ) IS
2607: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VENDOR_SITE';
2608: l_request_id NUMBER := fnd_global.conc_request_id;
2609:
2610: l_return_status VARCHAR2(2000);
2611: l_msg_count NUMBER;
2612: l_msg_data VARCHAR2(2000);

Line 3025: l_request_id NUMBER := fnd_global.conc_request_id;

3021: x_msg_count OUT NOCOPY NUMBER,
3022: x_msg_data OUT NOCOPY VARCHAR2
3023: ) IS
3024: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_SITES';
3025: l_request_id NUMBER := fnd_global.conc_request_id;
3026:
3027: l_return_status VARCHAR2(2000);
3028: l_msg_count NUMBER;
3029: l_msg_data VARCHAR2(2000);

Line 3639: l_request_id NUMBER := fnd_global.conc_request_id;

3635: x_msg_data OUT NOCOPY VARCHAR2,
3636: p_vendor_contact_rec IN ap_vendor_pub_pkg.r_vendor_contact_rec_type
3637: ) IS
3638: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VENDOR_CONTACT';
3639: l_request_id NUMBER := fnd_global.conc_request_id;
3640:
3641: l_return_status VARCHAR2(2000);
3642: l_msg_count NUMBER;
3643: l_msg_data VARCHAR2(2000);

Line 3740: l_request_id NUMBER := fnd_global.conc_request_id;

3736: x_msg_data OUT NOCOPY VARCHAR2
3737: ) IS
3738: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_CONTACTS';
3739:
3740: l_request_id NUMBER := fnd_global.conc_request_id;
3741: l_insert_update_flag VARCHAR2(1);
3742: l_return_status VARCHAR2(2000);
3743: l_msg_count NUMBER;
3744: l_msg_data VARCHAR2(2000);

Line 4337: l_request_id NUMBER := fnd_global.conc_request_id;

4333:
4334: l_msg_count NUMBER;
4335: l_msg_data VARCHAR2(2000);
4336: l_api_name CONSTANT VARCHAR2(50) := 'VALIDATE_VENDOR_PRODS_SERVICES';
4337: l_request_id NUMBER := fnd_global.conc_request_id;
4338:
4339: l_pscur cursor_ref_type;
4340: l_sql VARCHAR2(4000) := NULL;
4341: l_seg_def fnd_profile_option_values.profile_option_value%TYPE;

Line 4773: l_request_id NUMBER := fnd_global.conc_request_id;

4769: x_msg_count OUT NOCOPY NUMBER,
4770: x_msg_data OUT NOCOPY VARCHAR2
4771: ) IS
4772: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_PRODS_SERVICES';
4773: l_request_id NUMBER := fnd_global.conc_request_id;
4774:
4775: l_return_status VARCHAR2(2000);
4776: l_msg_count NUMBER;
4777: l_msg_data VARCHAR2(2000);

Line 5339: l_request_id NUMBER := fnd_global.conc_request_id;

5335:
5336: l_msg_count NUMBER;
5337: l_msg_data VARCHAR2(2000);
5338: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_VENDOR_BUSS_CLASS';
5339: l_request_id NUMBER := fnd_global.conc_request_id;
5340: BEGIN
5341: -- Initialize API return status to success
5342: x_return_status := fnd_api.g_ret_sts_success;
5343:

Line 5551: l_request_id NUMBER := fnd_global.conc_request_id;

5547: x_msg_count OUT NOCOPY NUMBER,
5548: x_msg_data OUT NOCOPY VARCHAR2
5549: ) IS
5550: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_BUSS_CLASS';
5551: l_request_id NUMBER := fnd_global.conc_request_id;
5552:
5553: l_return_status VARCHAR2(2000);
5554: l_msg_count NUMBER;
5555: l_msg_data VARCHAR2(2000);

Line 5971: l_request_id NUMBER := fnd_global.conc_request_id;

5967: x_party_tax_profile_id OUT NOCOPY NUMBER,
5968: x_country_code OUT NOCOPY VARCHAR2
5969: ) IS
5970: l_dummy_lookup VARCHAR2(30);
5971: l_request_id NUMBER := fnd_global.conc_request_id;
5972:
5973: l_msg_count NUMBER;
5974: l_msg_data VARCHAR2(2000);
5975: l_api_name CONSTANT VARCHAR2(50) := 'VALIDATE_VENDOR_PRODS_SERVICES';

Line 6372: l_request_id NUMBER := fnd_global.conc_request_id;

6368: l_dummy_lookup VARCHAR2(30);
6369: l_dummy_location NUMBER;
6370: l_tax_authority_party_id NUMBER;
6371:
6372: l_request_id NUMBER := fnd_global.conc_request_id;
6373:
6374: l_msg_count NUMBER;
6375: l_msg_data VARCHAR2(2000);
6376: l_api_name CONSTANT VARCHAR2(50) := 'VALIDATE_VENDOR_PRODS_SERVICES';

Line 6726: l_request_id NUMBER := fnd_global.conc_request_id;

6722: l_msg_count NUMBER;
6723: l_msg_data VARCHAR2(4000);
6724: l_valid VARCHAR2(100);
6725: l_tax_authority_party_id NUMBER;
6726: l_request_id NUMBER := fnd_global.conc_request_id;
6727: BEGIN
6728: fnd_file.put_line(fnd_file.log, ' Inside create_tax_registration');
6729: x_return_status := fnd_api.g_ret_sts_success;
6730:

Line 6855: l_request_id NUMBER := fnd_global.conc_request_id;

6851: l_msg_count NUMBER;
6852: l_msg_data VARCHAR2(4000);
6853: l_valid VARCHAR2(100);
6854: l_tax_authority_party_id NUMBER;
6855: l_request_id NUMBER := fnd_global.conc_request_id;
6856: BEGIN
6857: fnd_file.put_line(fnd_file.log, ' Inside update_tax_registration');
6858: -- Initialize API return status to success
6859: x_return_status := fnd_api.g_ret_sts_success;

Line 6985: l_request_id NUMBER := fnd_global.conc_request_id;

6981:
6982: l_classification_code VARCHAR2(50);
6983: l_classification_type VARCHAR2(50);
6984:
6985: l_request_id NUMBER := fnd_global.conc_request_id;
6986:
6987: l_msg_count NUMBER;
6988: l_msg_data VARCHAR2(2000);
6989: l_api_name CONSTANT VARCHAR2(50) := 'VALIDATE_VENDOR_PRODS_SERVICES';

Line 7329: l_request_id NUMBER := fnd_global.conc_request_id;

7325: x_return_status OUT NOCOPY VARCHAR2,
7326: x_msg_count OUT NOCOPY NUMBER,
7327: x_msg_data OUT NOCOPY VARCHAR2
7328: ) AS
7329: l_request_id NUMBER := fnd_global.conc_request_id;
7330: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_TAX_DTLS';
7331: l_effective_from_date DATE;
7332:
7333: l_msg_count NUMBER;

Line 8139: l_request_id NUMBER := fnd_global.conc_request_id;

8135: l_new_intermed_acct2_rec iby_ext_bankacct_pub.intermediaryacct_rec_type;
8136:
8137: l_association_level VARCHAR2(10);
8138:
8139: l_request_id NUMBER := fnd_global.conc_request_id;
8140: l_api_name CONSTANT VARCHAR2(30) := 'IMPORT_VENDOR_BANK_DTLS';
8141: BEGIN
8142: x_return_status := fnd_api.g_ret_sts_success;
8143:

Line 10005: l_request_id NUMBER := fnd_global.conc_request_id;

10001: p_run_automerge IN VARCHAR2 := 'N',
10002: p_generate_fuzzy_key IN VARCHAR2 := 'Y',
10003: p_import_uda_only IN VARCHAR2 := 'N' --Bug 12747017
10004: ) AS
10005: l_request_id NUMBER := fnd_global.conc_request_id;
10006:
10007: l_errbuf VARCHAR2(4000);
10008: l_retcode VARCHAR2(10);
10009: l_batch_status hz_imp_batch_summary.batch_status%TYPE;