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 POS_PARTY_TAX_REG_INT

Line 6360: p_tax_reg_rec IN pos_party_tax_reg_int%ROWTYPE,

6356:
6357: PROCEDURE validate_tax_registration
6358: (
6359: p_batch_id IN NUMBER,
6360: p_tax_reg_rec IN pos_party_tax_reg_int%ROWTYPE,
6361: x_return_status OUT NOCOPY VARCHAR2,
6362: x_msg_count OUT NOCOPY NUMBER,
6363: x_msg_data OUT NOCOPY VARCHAR2,
6364: x_tax_reg_valid OUT NOCOPY VARCHAR2,

Line 6406: 'POS_PARTY_TAX_REG_INT',

6402: x_return_status := fnd_api.g_ret_sts_error;
6403: x_msg_data := 'POS_INVALID_REGI_TYPE_CODE';
6404: IF (insert_rejections(p_batch_id,
6405: l_request_id,
6406: 'POS_PARTY_TAX_REG_INT',
6407: p_tax_reg_rec.registration_type_code,
6408: 'POS_INVALID_REGI_TYPE_CODE',
6409: g_user_id,
6410: g_login_id,

Line 6451: 'POS_PARTY_TAX_REG_INT',

6447: x_return_status := fnd_api.g_ret_sts_error;
6448: x_msg_data := 'POS_INVALID_REG_STATUS_CODE';
6449: IF (insert_rejections(p_batch_id,
6450: l_request_id,
6451: 'POS_PARTY_TAX_REG_INT',
6452: p_tax_reg_rec.registration_status_code,
6453: 'POS_INVALID_REG_STATUS_CODE',
6454: g_user_id,
6455: g_login_id,

Line 6497: 'POS_PARTY_TAX_REG_INT',

6493: x_return_status := fnd_api.g_ret_sts_error;
6494: x_msg_data := 'POS_INVALID_REG_ADDRESS';
6495: IF (insert_rejections(p_batch_id,
6496: l_request_id,
6497: 'POS_PARTY_TAX_REG_INT',
6498: p_tax_reg_rec.registration_address,
6499: 'POS_INVALID_REG_ADDRESS',
6500: g_user_id,
6501: g_login_id,

Line 6542: 'POS_PARTY_TAX_REG_INT',

6538: x_return_status := fnd_api.g_ret_sts_error;
6539: x_msg_data := 'POS_INVALID_REG_REASON_CODE';
6540: IF (insert_rejections(p_batch_id,
6541: l_request_id,
6542: 'POS_PARTY_TAX_REG_INT',
6543: p_tax_reg_rec.registration_reason_code,
6544: 'POS_INVALID_REG_REASON_CODE',
6545: g_user_id,
6546: g_login_id,

Line 6587: 'POS_PARTY_TAX_REG_INT',

6583: x_return_status := fnd_api.g_ret_sts_error;
6584: x_msg_data := 'POS_INVALID_REG_SOURCE_CODE';
6585: IF (insert_rejections(p_batch_id,
6586: l_request_id,
6587: 'POS_PARTY_TAX_REG_INT',
6588: p_tax_reg_rec.registration_source_code,
6589: 'POS_INVALID_REG_SOURCE_CODE',
6590: g_user_id,
6591: g_login_id,

Line 6632: 'POS_PARTY_TAX_REG_INT',

6628: x_return_status := fnd_api.g_ret_sts_error;
6629: x_msg_data := 'POS_INVALID_ROUND_RULE_CODE';
6630: IF (insert_rejections(p_batch_id,
6631: l_request_id,
6632: 'POS_PARTY_TAX_REG_INT',
6633: p_tax_reg_rec.rounding_rule_code,
6634: 'POS_INVALID_ROUND_RULE_CODE',
6635: g_user_id,
6636: g_login_id,

Line 6677: 'POS_PARTY_TAX_REG_INT',

6673: x_return_status := fnd_api.g_ret_sts_error;
6674: x_msg_data := 'POS_INVALID_TAX_AUTHORITY';
6675: IF (insert_rejections(p_batch_id,
6676: l_request_id,
6677: 'POS_PARTY_TAX_REG_INT',
6678: p_tax_reg_rec.rounding_rule_code,
6679: 'POS_INVALID_TAX_AUTHORITY',
6680: g_user_id,
6681: g_login_id,

Line 6714: p_tax_registration_rec IN pos_party_tax_reg_int%ROWTYPE,

6710:
6711: PROCEDURE create_tax_registration
6712: (
6713: p_batch_id IN NUMBER,
6714: p_tax_registration_rec IN pos_party_tax_reg_int%ROWTYPE,
6715: x_return_status OUT NOCOPY VARCHAR2,
6716: x_msg_count OUT NOCOPY NUMBER,
6717: x_msg_data OUT NOCOPY VARCHAR2
6718: ) IS

Line 6809: 'POS_PARTY_TAX_REG_INT',

6805: -- Add the error buffer message to supplier rejections
6806: -- table
6807: IF (insert_rejections(p_batch_id,
6808: l_request_id,
6809: 'POS_PARTY_TAX_REG_INT',
6810: p_tax_registration_rec.registration_type_code,
6811: 'POS_INVALID_TAX_REG_INS',
6812: g_user_id,
6813: g_login_id,

Line 6843: p_tax_registration_rec IN pos_party_tax_reg_int%ROWTYPE,

6839: PROCEDURE update_tax_registration
6840: (
6841: p_batch_id IN NUMBER,
6842: p_registration_id IN NUMBER,
6843: p_tax_registration_rec IN pos_party_tax_reg_int%ROWTYPE,
6844: x_return_status OUT NOCOPY VARCHAR2,
6845: x_msg_count OUT NOCOPY NUMBER,
6846: x_msg_data OUT NOCOPY VARCHAR2
6847: ) IS

Line 6937: 'POS_PARTY_TAX_REG_INT',

6933:
6934: IF x_return_status = fnd_api.g_ret_sts_error THEN
6935: IF (insert_rejections(p_batch_id,
6936: l_request_id,
6937: 'POS_PARTY_TAX_REG_INT',
6938: p_tax_registration_rec.registration_type_code,
6939: 'POS_INVALID_TAX_REG_UPD',
6940: g_user_id,
6941: g_login_id,

Line 7353: FROM pos_party_tax_reg_int supp

7349: AND party.interface_status = 'R');
7350:
7351: CURSOR tax_reg_cur IS
7352: SELECT *
7353: FROM pos_party_tax_reg_int supp
7354: WHERE batch_id = p_batch_id
7355: AND nvl(status, 'ACTIVE') NOT IN ('PROCESSED', 'REMOVED')
7356: AND NOT EXISTS
7357: (SELECT 1

Line 7390: TYPE l_tax_reg_rec_tab_typ IS TABLE OF pos_party_tax_reg_int%ROWTYPE;

7386:
7387: TYPE l_tax_profile_rec_tab_typ IS TABLE OF pos_party_tax_profile_int%ROWTYPE;
7388: l_tax_profile_rec_tab l_tax_profile_rec_tab_typ;
7389:
7390: TYPE l_tax_reg_rec_tab_typ IS TABLE OF pos_party_tax_reg_int%ROWTYPE;
7391: l_tax_reg_rec_tab l_tax_reg_rec_tab_typ;
7392:
7393: TYPE l_fiscal_class_rec_tab_typ IS TABLE OF pos_fiscal_class_int%ROWTYPE;
7394: l_fiscal_class_rec_tab l_fiscal_class_rec_tab_typ;

Line 7416: UPDATE pos_party_tax_reg_int api

7412: FROM fnd_concurrent_requests fcr
7413: WHERE fcr.request_id = api.request_id
7414: AND fcr.phase_code = 'C');
7415:
7416: UPDATE pos_party_tax_reg_int api
7417: SET request_id = NULL
7418: WHERE request_id IS NOT NULL
7419: AND batch_id = p_batch_id
7420: AND nvl(status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 7444: UPDATE pos_party_tax_reg_int

7440: WHERE request_id IS NULL
7441: AND batch_id = p_batch_id
7442: AND nvl(status, 'ACTIVE') <> 'PROCESSED';
7443:
7444: UPDATE pos_party_tax_reg_int
7445: SET request_id = l_request_id
7446: WHERE request_id IS NULL
7447: AND batch_id = p_batch_id
7448: AND nvl(status, 'ACTIVE') <> 'PROCESSED';

Line 7491: UPDATE pos_party_tax_reg_int supp

7487: WHERE status = 'REMOVED'
7488: AND request_id = l_request_id
7489: AND batch_id = p_batch_id);
7490:
7491: UPDATE pos_party_tax_reg_int supp
7492: SET status = 'REMOVED',
7493: request_id = l_request_id
7494: WHERE batch_id = p_batch_id
7495: AND nvl(status, 'ACTIVE') <> 'PROCESSED'

Line 7508: ' records from table pos_party_tax_reg_int. Reason interface_status in hz_imp_parties_int = R');

7504:
7505: fnd_file.put_line(fnd_file.log,
7506: ' Message: Inside PROCEDURE IMPORT_VENDOR_TAX_DTLS' ||
7507: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
7508: ' records from table pos_party_tax_reg_int. Reason interface_status in hz_imp_parties_int = R');
7509:
7510: INSERT INTO pos_supplier_int_rejections
7511: (SELECT p_batch_id,
7512: l_request_id,

Line 7521: FROM pos_party_tax_reg_int

7517: SYSDATE,
7518: g_login_id,
7519: g_user_id,
7520: SYSDATE
7521: FROM pos_party_tax_reg_int
7522: WHERE status = 'REMOVED'
7523: AND request_id = l_request_id
7524: AND batch_id = p_batch_id);
7525:

Line 7609: UPDATE pos_party_tax_reg_int

7605: .tax_profile_interface_id || ' x_return_status: ' ||
7606: x_return_status);
7607:
7608: -- Tax Profile Id in the Tax Registrations Interface table
7609: UPDATE pos_party_tax_reg_int
7610: SET tax_profile_id = l_tax_profile_id
7611: WHERE tax_profile_interface_id = l_tax_profile_rec_tab(cntr)
7612: .tax_profile_interface_id
7613: AND batch_id = p_batch_id;

Line 7778: UPDATE pos_party_tax_reg_int

7774: x_msg_count => x_msg_count,
7775: x_msg_data => x_msg_data);
7776: IF (x_return_status = 'S') THEN
7777:
7778: UPDATE pos_party_tax_reg_int
7779: SET status = 'PROCESSED'
7780: WHERE tax_reg_interface_id = l_tax_reg_rec_tab(cntr)
7781: .tax_reg_interface_id
7782: AND batch_id = p_batch_id;

Line 7803: UPDATE pos_party_tax_reg_int

7799: x_return_status);
7800:
7801: IF (x_return_status = 'S') THEN
7802:
7803: UPDATE pos_party_tax_reg_int
7804: SET status = 'PROCESSED'
7805: WHERE tax_reg_interface_id = l_tax_reg_rec_tab(cntr)
7806: .tax_reg_interface_id
7807: AND batch_id = p_batch_id;

Line 7820: UPDATE pos_party_tax_reg_int

7816: END IF;
7817:
7818: IF (x_return_status <> 'S') THEN
7819:
7820: UPDATE pos_party_tax_reg_int
7821: SET status = 'REJECTED'
7822: WHERE tax_reg_interface_id = l_tax_reg_rec_tab(cntr)
7823: .tax_reg_interface_id
7824: AND batch_id = p_batch_id;

Line 7830: 'POS_PARTY_TAX_REG_INT',

7826: x_return_status := fnd_api.g_ret_sts_error;
7827:
7828: IF (insert_rejections(p_batch_id,
7829: l_request_id,
7830: 'POS_PARTY_TAX_REG_INT',
7831: l_tax_reg_rec_tab(cntr).tax_reg_interface_id,
7832: 'POS_TAX_REGISTRATION_CREATION',
7833: g_user_id,
7834: g_login_id,

Line 10463: FROM pos_party_tax_reg_int

10459: l_tot_err_count := l_tot_err_count + l_error_count;
10460:
10461: SELECT COUNT(1)
10462: INTO l_error_count
10463: FROM pos_party_tax_reg_int
10464: WHERE batch_id = p_batch_id
10465: AND nvl(status, 'ACTIVE') = 'REJECTED'
10466: AND rownum = 1;
10467: