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.26 2008/01/14 19:56:55 rnagired 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.26 2008/01/14 19:56:55 rnagired 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 1577: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call

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

Line 1592: IF l_call_from = cn_payment_worksheet_pvt.concurrent_program_call

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

Line 2085: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;

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

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

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

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

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

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

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

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

2299: retcode := 2;
2300: errbuf := errmsg;
2301: RAISE ;
2302: WHEN OTHERS THEN
2303: fnd_file.put_line(fnd_file.log, 'Unexpected exception in cn_payment_worksheet_pvt.create_mult_worksheet_conc');
2304: fnd_file.put_line(fnd_file.log, errmsg);
2305: fnd_file.put_line(fnd_file.log, SQLERRM);
2306: RAISE;
2307: END;

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

4386: fnd_file.put_line(fnd_file.log,' Completed refresh worksheet process....');
4387:
4388: EXCEPTION
4389: WHEN OTHERS THEN
4390: fnd_file.put_line(fnd_file.LOG,'Unexpected exception in cn_payment_worksheet_pvt.refresh_worksheet_parent');
4391: fnd_file.put_line(fnd_file.log, errmsg);
4392: fnd_file.put_line(fnd_file.log, SQLERRM);
4393: RAISE;
4394: END refresh_worksheet_parent;

Line 4416: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;

4412: ) IS
4413: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4414: x_msg_count NUMBER;
4415: x_msg_data VARCHAR2(4000);
4416: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
4417: x_status VARCHAR2(200);
4418: x_loading_status VARCHAR2(20) := 'CN_UPDATED';
4419: l_start_time DATE;
4420: l_error_count NUMBER := 0;

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

4434: AND physical_batch_id = p_batch_id)
4435: LOOP
4436: -- Run refresh worksheet for this salesrep.
4437: l_worksheet_rec.salesrep_id := emp.salesrep_id;
4438: l_worksheet_rec.call_from := cn_payment_worksheet_pvt.concurrent_program_call;
4439:
4440: SELECT wk.payment_worksheet_id,wk.object_version_number
4441: INTO l_worksheet_rec.worksheet_id,l_ovn
4442: FROM cn_payment_worksheets_all wk

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

4445: AND quota_id IS NULL;
4446:
4447: fnd_file.put_line(fnd_file.log,'Refresh worksheet for = ' || l_worksheet_rec.salesrep_id || ' salesrepID');
4448:
4449: cn_payment_worksheet_pvt.update_worksheet(p_api_version => 1.0,
4450: p_init_msg_list => 'T',
4451: p_commit => 'F',
4452: p_validation_level => fnd_api.g_valid_level_full,
4453: x_return_status => x_return_status,

Line 4505: END cn_payment_worksheet_pvt;

4501: END refresh_worksheet_child;
4502:
4503:
4504:
4505: END cn_payment_worksheet_pvt;