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.

[Home] [Help]

APPS.POS_BATCH_IMPORT_PKG dependencies on POS_BANK_ACCOUNT_DET_INT

Line 8046: FROM pos_bank_account_det_int supp

8042: x_msg_data OUT NOCOPY VARCHAR2
8043: ) IS
8044: CURSOR bank_account_dtls_cur IS
8045: SELECT *
8046: FROM pos_bank_account_det_int supp
8047: WHERE batch_id = p_batch_id
8048: AND nvl(interface_status, 'ACTIVE') NOT IN
8049: ('PROCESSED', 'REMOVED')
8050: AND NOT EXISTS

Line 8151: UPDATE pos_bank_account_det_int api

8147: ' request_id: ' || l_request_id);
8148:
8149: -- This update statement resets the unprocessed rows so
8150: -- that they get picked in the current run.
8151: UPDATE pos_bank_account_det_int api
8152: SET request_id = NULL
8153: WHERE request_id IS NOT NULL
8154: AND batch_id = p_batch_id
8155: AND nvl(interface_status, 'ACTIVE') IN ('ACTIVE', 'REJECTED')

Line 8173: UPDATE pos_bank_account_det_int

8169: AND fcr.phase_code = 'C');
8170:
8171: -- Updating Interface Record with request id
8172:
8173: UPDATE pos_bank_account_det_int
8174: SET request_id = l_request_id
8175: WHERE request_id IS NULL
8176: AND batch_id = p_batch_id
8177: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED';

Line 8185: UPDATE pos_bank_account_det_int supp

8181: WHERE request_id IS NULL
8182: AND batch_id = p_batch_id
8183: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED';
8184:
8185: UPDATE pos_bank_account_det_int supp
8186: SET interface_status = 'REMOVED',
8187: request_id = l_request_id
8188: WHERE batch_id = p_batch_id
8189: AND nvl(interface_status, 'ACTIVE') <> 'PROCESSED'

Line 8202: ' records from table pos_bank_account_det_int. Reason interface_status in hz_imp_parties_int = R');

8198:
8199: fnd_file.put_line(fnd_file.log,
8200: ' Message: Inside PROCEDURE IMPORT_VENDOR_BANK_DTLS' ||
8201: ' Not imported(marked REMOVED) : ' || SQL%ROWCOUNT ||
8202: ' records from table pos_bank_account_det_int. Reason interface_status in hz_imp_parties_int = R');
8203:
8204: INSERT INTO pos_supplier_int_rejections
8205: (SELECT p_batch_id,
8206: l_request_id,

Line 8207: 'POS_BANK_ACCOUNT_DET_INT',

8203:
8204: INSERT INTO pos_supplier_int_rejections
8205: (SELECT p_batch_id,
8206: l_request_id,
8207: 'POS_BANK_ACCOUNT_DET_INT',
8208: bank_account_interface_id,
8209: 'POS_INVALID_PARTY_ORIG_SYSTEM',
8210: g_user_id,
8211: SYSDATE,

Line 8215: FROM pos_bank_account_det_int

8211: SYSDATE,
8212: g_login_id,
8213: g_user_id,
8214: SYSDATE
8215: FROM pos_bank_account_det_int
8216: WHERE interface_status = 'REMOVED'
8217: AND request_id = l_request_id
8218: AND batch_id = p_batch_id);
8219:

Line 8313: UPDATE pos_bank_account_det_int

8309: x_msg_count := l_msg_count;
8310: x_msg_data := l_msg_data;
8311:
8312: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8313: UPDATE pos_bank_account_det_int
8314: SET interface_status = 'REJECTED'
8315: WHERE bank_account_interface_id =
8316: bank_account_dtls_rec.bank_account_interface_id
8317: AND batch_id = p_batch_id;

Line 8321: 'POS_BANK_ACCOUNT_DET_INT',

8317: AND batch_id = p_batch_id;
8318:
8319: IF (insert_rejections(p_batch_id,
8320: l_request_id,
8321: 'POS_BANK_ACCOUNT_DET_INT',
8322: bank_account_dtls_rec.bank_account_interface_id,
8323: 'POS_INVALID_BANK_INFO',
8324: g_user_id,
8325: g_login_id,

Line 8410: UPDATE pos_bank_account_det_int

8406: END IF;
8407:
8408: -- this would also return the generated bank_id.
8409: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8410: UPDATE pos_bank_account_det_int
8411: SET interface_status = 'REJECTED'
8412: WHERE bank_account_interface_id =
8413: bank_account_dtls_rec.bank_account_interface_id
8414: AND batch_id = p_batch_id;

Line 8418: 'POS_BANK_ACCOUNT_DET_INT',

8414: AND batch_id = p_batch_id;
8415:
8416: IF (insert_rejections(p_batch_id,
8417: l_request_id,
8418: 'POS_BANK_ACCOUNT_DET_INT',
8419: bank_account_dtls_rec.bank_account_interface_id,
8420: 'POS_INVALID_BANK_INFO',
8421: g_user_id,
8422: g_login_id,

Line 8449: UPDATE pos_bank_account_det_int

8445: IF l_bank_id IS NOT NULL THEN
8446: fnd_file.put_line(fnd_file.log, ' Message: Bank Id :' || l_bank_id);
8447: -- Update the interface table with the
8448: -- bank_id that is obtained
8449: UPDATE pos_bank_account_det_int
8450: SET bank_id = l_bank_id
8451: WHERE bank_account_interface_id =
8452: bank_account_dtls_rec.bank_account_interface_id
8453: AND batch_id = p_batch_id;

Line 8563: UPDATE pos_bank_account_det_int

8559: x_msg_count := l_msg_count;
8560: x_msg_data := l_msg_data;
8561:
8562: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8563: UPDATE pos_bank_account_det_int
8564: SET interface_status = 'REJECTED'
8565: WHERE bank_account_interface_id =
8566: bank_account_dtls_rec.bank_account_interface_id
8567: AND batch_id = p_batch_id;

Line 8571: 'POS_BANK_ACCOUNT_DET_INT',

8567: AND batch_id = p_batch_id;
8568:
8569: IF (insert_rejections(p_batch_id,
8570: l_request_id,
8571: 'POS_BANK_ACCOUNT_DET_INT',
8572: bank_account_dtls_rec.bank_account_interface_id,
8573: 'POS_FAILED_BANK_END_DATE',
8574: g_user_id,
8575: g_login_id,

Line 8620: UPDATE pos_bank_account_det_int

8616: x_msg_count := l_msg_count;
8617: x_msg_data := l_msg_data;
8618:
8619: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8620: UPDATE pos_bank_account_det_int
8621: SET interface_status = 'REJECTED'
8622: WHERE bank_account_interface_id =
8623: bank_account_dtls_rec.bank_account_interface_id
8624: AND batch_id = p_batch_id;

Line 8628: 'POS_BANK_ACCOUNT_DET_INT',

8624: AND batch_id = p_batch_id;
8625:
8626: IF (insert_rejections(p_batch_id,
8627: l_request_id,
8628: 'POS_BANK_ACCOUNT_DET_INT',
8629: bank_account_dtls_rec.bank_account_interface_id,
8630: 'POS_INVALID_BRANCH_INFO',
8631: g_user_id,
8632: g_login_id,

Line 8752: UPDATE pos_bank_account_det_int

8748: END IF;
8749: -- this would also return the generated branch_id.
8750:
8751: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8752: UPDATE pos_bank_account_det_int
8753: SET interface_status = 'REJECTED'
8754: WHERE bank_account_interface_id =
8755: bank_account_dtls_rec.bank_account_interface_id
8756: AND batch_id = p_batch_id;

Line 8760: 'POS_BANK_ACCOUNT_DET_INT',

8756: AND batch_id = p_batch_id;
8757:
8758: IF (insert_rejections(p_batch_id,
8759: l_request_id,
8760: 'POS_BANK_ACCOUNT_DET_INT',
8761: bank_account_dtls_rec.bank_account_interface_id,
8762: 'POS_INVALID_BRANCH_INFO',
8763: g_user_id,
8764: g_login_id,

Line 8793: UPDATE pos_bank_account_det_int

8789: fnd_file.put_line(fnd_file.log,
8790: ' Message: Updating branch id ' || ' Branch Id :' ||
8791: l_branch_id);
8792: -- Update the interface table with the branch_id that is obtained
8793: UPDATE pos_bank_account_det_int
8794: SET branch_id = l_branch_id
8795: WHERE bank_account_interface_id =
8796: bank_account_dtls_rec.bank_account_interface_id
8797: AND batch_id = p_batch_id;

Line 8907: UPDATE pos_bank_account_det_int

8903: x_msg_count := l_msg_count;
8904: x_msg_data := l_msg_data;
8905:
8906: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
8907: UPDATE pos_bank_account_det_int
8908: SET interface_status = 'REJECTED'
8909: WHERE bank_account_interface_id =
8910: bank_account_dtls_rec.bank_account_interface_id
8911: AND batch_id = p_batch_id;

Line 8915: 'POS_BANK_ACCOUNT_DET_INT',

8911: AND batch_id = p_batch_id;
8912:
8913: IF (insert_rejections(p_batch_id,
8914: l_request_id,
8915: 'POS_BANK_ACCOUNT_DET_INT',
8916: bank_account_dtls_rec.bank_account_interface_id,
8917: 'POS_FAILED_BRANCH_END_DATE',
8918: g_user_id,
8919: g_login_id,

Line 9074: UPDATE pos_bank_account_det_int

9070: l_association_level);
9071:
9072: EXCEPTION
9073: WHEN OTHERS THEN
9074: UPDATE pos_bank_account_det_int
9075: SET interface_status = 'REJECTED'
9076: WHERE bank_account_interface_id =
9077: bank_account_dtls_rec.bank_account_interface_id
9078: AND batch_id = p_batch_id;

Line 9082: 'POS_BANK_ACCOUNT_DET_INT',

9078: AND batch_id = p_batch_id;
9079:
9080: IF (insert_rejections(p_batch_id,
9081: l_request_id,
9082: 'POS_BANK_ACCOUNT_DET_INT',
9083: bank_account_dtls_rec.bank_account_interface_id,
9084: 'AP_INVALID_BANK_ACCT_INFO',
9085: g_user_id,
9086: g_login_id,

Line 9307: UPDATE pos_bank_account_det_int

9303: END IF;
9304: -- this would also return the generated account_id.
9305:
9306: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9307: UPDATE pos_bank_account_det_int
9308: SET interface_status = 'REJECTED'
9309: WHERE bank_account_interface_id =
9310: bank_account_dtls_rec.bank_account_interface_id
9311: AND batch_id = p_batch_id;

Line 9315: 'POS_BANK_ACCOUNT_DET_INT',

9311: AND batch_id = p_batch_id;
9312:
9313: IF (insert_rejections(p_batch_id,
9314: l_request_id,
9315: 'POS_BANK_ACCOUNT_DET_INT',
9316: bank_account_dtls_rec.bank_account_interface_id,
9317: 'AP_INVALID_BANK_ACCT_INFO',
9318: g_user_id,
9319: g_login_id,

Line 9348: UPDATE pos_bank_account_det_int

9344: fnd_file.put_line(fnd_file.log,
9345: ' Message: Updating account id :' || l_account_id);
9346: -- Update the interface table with the
9347: -- account_id that is obtained
9348: UPDATE pos_bank_account_det_int
9349: SET bank_account_id = l_account_id
9350: WHERE bank_account_interface_id =
9351: bank_account_dtls_rec.bank_account_interface_id
9352: AND batch_id = p_batch_id;

Line 9475: UPDATE pos_bank_account_det_int

9471: x_msg_data := l_msg_data;
9472: END IF;
9473:
9474: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9475: UPDATE pos_bank_account_det_int
9476: SET interface_status = 'REJECTED'
9477: WHERE bank_account_interface_id =
9478: bank_account_dtls_rec.bank_account_interface_id
9479: AND batch_id = p_batch_id;

Line 9483: 'POS_BANK_ACCOUNT_DET_INT',

9479: AND batch_id = p_batch_id;
9480:
9481: IF (insert_rejections(p_batch_id,
9482: l_request_id,
9483: 'POS_BANK_ACCOUNT_DET_INT',
9484: bank_account_dtls_rec.bank_account_interface_id,
9485: 'POS_FAILED_INTERMEDIARY_ACCT',
9486: g_user_id,
9487: g_login_id,

Line 9619: UPDATE pos_bank_account_det_int

9615: x_msg_data := l_msg_data;
9616: END IF;
9617:
9618: IF l_ret_status <> fnd_api.g_ret_sts_success THEN
9619: UPDATE pos_bank_account_det_int
9620: SET interface_status = 'REJECTED'
9621: WHERE bank_account_interface_id =
9622: bank_account_dtls_rec.bank_account_interface_id
9623: AND batch_id = p_batch_id;

Line 9627: 'POS_BANK_ACCOUNT_DET_INT',

9623: AND batch_id = p_batch_id;
9624:
9625: IF (insert_rejections(p_batch_id,
9626: l_request_id,
9627: 'POS_BANK_ACCOUNT_DET_INT',
9628: bank_account_dtls_rec.bank_account_interface_id,
9629: 'POS_FAILED_INTERMEDIARY_ACCT2',
9630: g_user_id,
9631: g_login_id,

Line 9655: UPDATE pos_bank_account_det_int

9651: GOTO continue_next_record;
9652: END IF;
9653: END IF;
9654:
9655: UPDATE pos_bank_account_det_int
9656: SET interface_status = 'PROCESSED'
9657: WHERE bank_account_interface_id =
9658: bank_account_dtls_rec.bank_account_interface_id
9659: AND batch_id = p_batch_id;

Line 10496: FROM pos_bank_account_det_int

10492: retcode := 1;
10493: ELSE
10494: SELECT COUNT(1)
10495: INTO l_error_count
10496: FROM pos_bank_account_det_int
10497: WHERE batch_id = p_batch_id
10498: AND nvl(interface_status, 'ACTIVE') = 'REJECTED'
10499: AND rownum = 1;
10500: