DBA Data[Home] [Help]

APPS.CN_PAYMENT_WORKSHEET_PVT dependencies on CN_PAYMENT_WORKSHEET_PVT

Line 1: PACKAGE BODY cn_payment_worksheet_pvt AS

1: PACKAGE BODY cn_payment_worksheet_pvt AS
2: -- $Header: cnvwkshb.pls 120.30 2009/02/09 12:05:58 rajukum ship $
3: g_api_version CONSTANT NUMBER := 1.0;
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_Payment_Worksheet_PVT';
5: --G_last_update_date DATE := sysdate;

Line 4: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_Payment_Worksheet_PVT';

1: PACKAGE BODY cn_payment_worksheet_pvt AS
2: -- $Header: cnvwkshb.pls 120.30 2009/02/09 12:05:58 rajukum ship $
3: g_api_version CONSTANT NUMBER := 1.0;
4: g_pkg_name CONSTANT VARCHAR2(30) := 'CN_Payment_Worksheet_PVT';
5: --G_last_update_date DATE := sysdate;
6: -- g_last_updated_by NUMBER := fnd_global.user_id;
7: --G_creation_date DATE := sysdate;
8: --g_created_by NUMBER := fnd_global.user_id;

Line 1579: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call

1575: -- Get the Payrun
1576: BEGIN
1577: l_call_from := p_worksheet_rec.call_from;
1578:
1579: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call
1580: THEN
1581: OPEN get_payrun_for_conc_program;
1582: FETCH get_payrun_for_conc_program
1583: INTO l_get_payrun_rec;

Line 1594: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call

1590: END IF;
1591: EXCEPTION
1592: WHEN OTHERS THEN
1593: err_num := SQLCODE;
1594: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call
1595: THEN
1596: CLOSE get_payrun_for_conc_program;
1597: ELSE
1598: CLOSE get_payrun;

Line 2087: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;

2083: g_api_version CONSTANT NUMBER := 1.0;
2084: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
2085: x_msg_count NUMBER;
2086: x_msg_data VARCHAR2(4000);
2087: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
2088: x_status VARCHAR2(200);
2089: x_loading_status VARCHAR2(20) := 'CN_INSERTED';
2090: l_start_time DATE;
2091: l_error_count NUMBER := 0;

Line 2114: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;

2110: fnd_file.put_line(fnd_file.log, ' Current time = ' || to_char(l_start_time, 'Dy DD-Mon-YYYY HH24:MI:SS'));
2111:
2112: l_worksheet_rec.payrun_id := p_payrun_id;
2113: l_worksheet_rec.org_id := p_org_id;
2114: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
2115:
2116: FOR emp IN (SELECT salesrep_id
2117: FROM cn_process_batches
2118: WHERE logical_batch_id = p_logical_batch_id

Line 2124: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;

2120: LOOP
2121:
2122: -- Run create worksheet for this salesrep.
2123: l_worksheet_rec.salesrep_id := emp.salesrep_id;
2124: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
2125:
2126: fnd_file.put_line(fnd_file.log, ' Create worksheet for = ' || l_worksheet_rec.salesrep_id || ' salesrepID');
2127:
2128: cn_payment_worksheet_pvt.create_worksheet(p_api_version => 1.0,

Line 2128: cn_payment_worksheet_pvt.create_worksheet(p_api_version => 1.0,

2124: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
2125:
2126: fnd_file.put_line(fnd_file.log, ' Create worksheet for = ' || l_worksheet_rec.salesrep_id || ' salesrepID');
2127:
2128: cn_payment_worksheet_pvt.create_worksheet(p_api_version => 1.0,
2129: p_init_msg_list => 'T',
2130: p_commit => 'F',
2131: p_validation_level => fnd_api.g_valid_level_full,
2132: x_return_status => x_return_status,

Line 2349: fnd_file.put_line(fnd_file.log, 'Unexpected exception in cn_payment_worksheet_pvt.create_mult_worksheet_conc');

2345: retcode := 2;
2346: errbuf := errmsg;
2347: RAISE ;
2348: WHEN OTHERS THEN
2349: fnd_file.put_line(fnd_file.log, 'Unexpected exception in cn_payment_worksheet_pvt.create_mult_worksheet_conc');
2350: fnd_file.put_line(fnd_file.log, errmsg);
2351: fnd_file.put_line(fnd_file.log, SQLERRM);
2352: RAISE;
2353: END;

Line 4457: fnd_file.put_line(fnd_file.LOG,'Unexpected exception in cn_payment_worksheet_pvt.refresh_worksheet_parent');

4453: fnd_file.put_line(fnd_file.log,' Completed refresh worksheet process....');
4454:
4455: EXCEPTION
4456: WHEN OTHERS THEN
4457: fnd_file.put_line(fnd_file.LOG,'Unexpected exception in cn_payment_worksheet_pvt.refresh_worksheet_parent');
4458: fnd_file.put_line(fnd_file.log, errmsg);
4459: fnd_file.put_line(fnd_file.log, SQLERRM);
4460: RAISE;
4461: END refresh_worksheet_parent;

Line 4483: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;

4479: ) IS
4480: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4481: x_msg_count NUMBER;
4482: x_msg_data VARCHAR2(4000);
4483: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
4484: x_status VARCHAR2(200);
4485: x_loading_status VARCHAR2(20) := 'CN_UPDATED';
4486: l_start_time DATE;
4487: l_error_count NUMBER := 0;

Line 4505: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;

4501: AND physical_batch_id = p_batch_id)
4502: LOOP
4503: -- Run refresh worksheet for this salesrep.
4504: l_worksheet_rec.salesrep_id := emp.salesrep_id;
4505: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4506:
4507: SELECT wk.payment_worksheet_id,wk.object_version_number
4508: INTO l_worksheet_rec.worksheet_id,l_ovn
4509: FROM cn_payment_worksheets_all wk

Line 4516: cn_payment_worksheet_pvt.update_worksheet(p_api_version => 1.0,

4512: AND quota_id IS NULL;
4513:
4514: fnd_file.put_line(fnd_file.log,'Refresh worksheet for = ' || l_worksheet_rec.salesrep_id || ' salesrepID');
4515:
4516: cn_payment_worksheet_pvt.update_worksheet(p_api_version => 1.0,
4517: p_init_msg_list => 'T',
4518: p_commit => 'F',
4519: p_validation_level => fnd_api.g_valid_level_full,
4520: x_return_status => x_return_status,

Line 4572: END cn_payment_worksheet_pvt;

4568: END refresh_worksheet_child;
4569:
4570:
4571:
4572: END cn_payment_worksheet_pvt;