APPS.CN_PMT_TRANS_PVT dependencies on CN_PMT_TRANS_PVT

Line 1: PACKAGE BODY cn_pmt_trans_pvt AS

1: PACKAGE BODY cn_pmt_trans_pvt AS
2: -- $Header: cnvpmtrb.pls 120.15 2006/01/20 18:51:53 fmburu ship $
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_Pmt_Trans_PVT';
4: g_credit_type_id NUMBER := -1000;
5:

Line 3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_Pmt_Trans_PVT';

1: PACKAGE BODY cn_pmt_trans_pvt AS
2: -- $Header: cnvpmtrb.pls 120.15 2006/01/20 18:51:53 fmburu ship $
3: g_pkg_name CONSTANT VARCHAR2 (30) := 'CN_Pmt_Trans_PVT';
4: g_credit_type_id NUMBER := -1000;
5:
6: CURSOR get_transactions_details(
7: c_payrun_id NUMBER,

Line 157: IF p_rec.p_action IN (CN_PMT_TRANS_PVT.G_HOLD_ALL,CN_PMT_TRANS_PVT.G_RELEASE_ALL)

153: END IF;
154: RAISE fnd_api.g_exc_error;
155: END IF ;
156:
157: IF p_rec.p_action IN (CN_PMT_TRANS_PVT.G_HOLD_ALL,CN_PMT_TRANS_PVT.G_RELEASE_ALL)
158: THEN
159: BEGIN
160: OPEN get_transactions_details(
161: p_rec.payrun_id,

Line 186: ELSIF p_rec.p_action = CN_PMT_TRANS_PVT.G_RESET_TO_UNPAID

182: WHEN OTHERS THEN
183: CLOSE get_transactions_details ;
184: RAISE ;
185: END ;
186: ELSIF p_rec.p_action = CN_PMT_TRANS_PVT.G_RESET_TO_UNPAID
187: THEN
188: NULL ;
189: ELSE
190: -- throw the error, should not be calling this procedure in this start

Line 1681: l_pmt_process_rec cn_pmt_trans_pvt.pmt_process_rec;

1677: l_processed VARCHAR2(20);
1678: l_flag varchar2(1);
1679:
1680:
1681: l_pmt_process_rec cn_pmt_trans_pvt.pmt_process_rec;
1682:
1683: CURSOR get_paysheet_details IS
1684: SELECT
1685: payment_worksheet_id,object_version_number, name

Line 1925: IF p_rec.p_action IN (CN_PMT_TRANS_PVT.G_HOLD_ALL, CN_PMT_TRANS_PVT.G_RELEASE_ALL) THEN

1921: THEN
1922: RAISE fnd_api.g_exc_error;
1923: END IF;
1924:
1925: IF p_rec.p_action IN (CN_PMT_TRANS_PVT.G_HOLD_ALL, CN_PMT_TRANS_PVT.G_RELEASE_ALL) THEN
1926:
1927: -- init the org_id
1928: fnd_request.set_org_id(p_rec.org_id);
1929:

Line 1953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'cn.plsql.cn_pmt_trans_pvt.pmt_process.exception','Failed to submit request for BATCH_PROCESSOR.');

1949: cn_message_pkg.debug('Main : unable to submit batch conc program ');
1950: cn_message_pkg.debug('Main : ' || fnd_message.get);
1951:
1952: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1953: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED,'cn.plsql.cn_pmt_trans_pvt.pmt_process.exception','Failed to submit request for BATCH_PROCESSOR.');
1954: END IF;
1955: RAISE fnd_api.g_exc_error;
1956: END IF ;
1957: p_rec.request_id := l_request_id ;

Line 1968: ELSIF p_rec.p_action = CN_PMT_TRANS_PVT.G_RESET_TO_UNPAID THEN

1964: WHERE payrun_id = p_rec.payrun_id
1965: AND salesrep_id = p_rec.salesrep_id
1966: AND quota_id IS NULL ;
1967:
1968: ELSIF p_rec.p_action = CN_PMT_TRANS_PVT.G_RESET_TO_UNPAID THEN
1969: NULL ;
1970: ELSE
1971: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error)
1972: THEN

Line 2023: END cn_pmt_trans_pvt;

2019: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2020: END process_pmt_transactions;
2021:
2022:
2023: END cn_pmt_trans_pvt;