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.CN_PAYMENT_WORKSHEET_PVT dependencies on STANDARD

Line 1508: -- Standard Start of API savepoint

1504: l_ispayee NUMBER := 0;
1505: l_has_access BOOLEAN;
1506:
1507: BEGIN
1508: -- Standard Start of API savepoint
1509: SAVEPOINT create_worksheet;
1510:
1511: -- Standard call to check for call compatibility.
1512: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

Line 1511: -- Standard call to check for call compatibility.

1507: BEGIN
1508: -- Standard Start of API savepoint
1509: SAVEPOINT create_worksheet;
1510:
1511: -- Standard call to check for call compatibility.
1512: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)
1513: THEN
1514: RAISE fnd_api.g_exc_unexpected_error;
1515: END IF;

Line 2035: -- Standard check of p_commit.

2031: END IF;
2032: END IF;
2033:
2034: -- End of API body.
2035: -- Standard check of p_commit.
2036: IF fnd_api.to_boolean(p_commit)
2037: THEN
2038: COMMIT WORK;
2039: END IF;

Line 2042: -- Standard call to get message count and if count is 1, get message info.

2038: COMMIT WORK;
2039: END IF;
2040:
2041: --
2042: -- Standard call to get message count and if count is 1, get message info.
2043: --
2044: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2045: EXCEPTION
2046: WHEN fnd_api.g_exc_error THEN

Line 2446: -- Standard Start of API savepoint

2442: l_pay_by_mode VARCHAR2(1);
2443: l_srp_status cn_salesreps.status%TYPE;
2444:
2445: BEGIN
2446: -- Standard Start of API savepoint
2447: SAVEPOINT update_worksheet;
2448:
2449: -- Standard call to check for call compatibility.
2450: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

Line 2449: -- Standard call to check for call compatibility.

2445: BEGIN
2446: -- Standard Start of API savepoint
2447: SAVEPOINT update_worksheet;
2448:
2449: -- Standard call to check for call compatibility.
2450: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)
2451: THEN
2452: RAISE fnd_api.g_exc_unexpected_error;
2453: END IF;

Line 3511: -- Standard check of p_commit.

3507: FROM cn_payment_worksheets
3508: WHERE payment_worksheet_id = p_worksheet_id;
3509:
3510: -- End of API body.
3511: -- Standard check of p_commit.
3512: IF fnd_api.to_boolean(p_commit)
3513: THEN
3514: COMMIT WORK;
3515: END IF;

Line 3517: -- Standard call to get message count and if count is 1, get message info.

3513: THEN
3514: COMMIT WORK;
3515: END IF;
3516:
3517: -- Standard call to get message count and if count is 1, get message info.
3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3519: EXCEPTION
3520: WHEN fnd_api.g_exc_error THEN
3521: ROLLBACK TO update_worksheet;

Line 3580: -- Standard Start of API savepoint

3576: l_has_access BOOLEAN;
3577: l_ovn NUMBER;
3578: BEGIN
3579: --
3580: -- Standard Start of API savepoint
3581: --
3582: SAVEPOINT delete_worksheet;
3583:
3584: --

Line 3585: -- Standard call to check for call compatibility.

3581: --
3582: SAVEPOINT delete_worksheet;
3583:
3584: --
3585: -- Standard call to check for call compatibility.
3586: --
3587: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)
3588: THEN
3589: RAISE fnd_api.g_exc_unexpected_error;

Line 3702: -- Standard check of p_commit.

3698: cn_payment_worksheets_pkg.delete_record(p_salesrep_id => wksht.salesrep_id, p_payrun_id => wksht.payrun_id);
3699: END LOOP;
3700:
3701: -- End of API body.
3702: -- Standard check of p_commit.
3703: IF fnd_api.to_boolean(p_commit)
3704: THEN
3705: COMMIT WORK;
3706: END IF;

Line 3709: -- Standard call to get message count and if count is 1, get message info.

3705: COMMIT WORK;
3706: END IF;
3707:
3708: --
3709: -- Standard call to get message count and if count is 1, get message info.
3710: --
3711: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3712: EXCEPTION
3713: WHEN fnd_api.g_exc_error THEN

Line 3773: -- Standard Start of API savepoint

3769: AND w.org_id = p.org_id;
3770:
3771: l_wksht_rec c_wksht_csr%ROWTYPE;
3772: BEGIN
3773: -- Standard Start of API savepoint
3774: SAVEPOINT get_ced_and_bb;
3775:
3776: -- Standard call to check for call compatibility.
3777: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 3776: -- Standard call to check for call compatibility.

3772: BEGIN
3773: -- Standard Start of API savepoint
3774: SAVEPOINT get_ced_and_bb;
3775:
3776: -- Standard call to check for call compatibility.
3777: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)
3778: THEN
3779: RAISE fnd_api.g_exc_unexpected_error;
3780: END IF;

Line 3893: -- Standard check of p_commit.

3889: x_bb_total := nvl(x_bb_prior_period_adj, 0) + nvl(x_bb_pmt_recovery_plans, 0);
3890: x_curr_earnings_due := x_bb_total + nvl(x_curr_earnings, 0); -- + Nvl(l_held_amount_prior,0);
3891:
3892: -- End of API body.
3893: -- Standard check of p_commit.
3894: IF fnd_api.to_boolean(p_commit)
3895: THEN
3896: COMMIT WORK;
3897: END IF;

Line 3900: -- Standard call to get message count and if count is 1, get message info.

3896: COMMIT WORK;
3897: END IF;
3898:
3899: --
3900: -- Standard call to get message count and if count is 1, get message info.
3901: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3902: EXCEPTION
3903: WHEN fnd_api.g_exc_error THEN
3904: ROLLBACK TO get_ced_and_bb;

Line 3979: -- Standard Start of API savepoint

3975: l_loading_status VARCHAR2(30);
3976: -- varialve added for Bug 3140343
3977: l_ispayee NUMBER := 0;
3978: BEGIN
3979: -- Standard Start of API savepoint
3980: SAVEPOINT set_ced_and_bb;
3981:
3982: -- Standard call to check for call compatibility.
3983: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

Line 3982: -- Standard call to check for call compatibility.

3978: BEGIN
3979: -- Standard Start of API savepoint
3980: SAVEPOINT set_ced_and_bb;
3981:
3982: -- Standard call to check for call compatibility.
3983: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)
3984: THEN
3985: RAISE fnd_api.g_exc_unexpected_error;
3986: END IF;

Line 4081: -- Standard check of p_commit.

4077: -- Bug 3140343 : Payee Design.
4078: END IF;
4079:
4080: -- End of API body.
4081: -- Standard check of p_commit.
4082: IF fnd_api.to_boolean(p_commit)
4083: THEN
4084: COMMIT WORK;
4085: END IF;

Line 4088: -- Standard call to get message count and if count is 1, get message info.

4084: COMMIT WORK;
4085: END IF;
4086:
4087: --
4088: -- Standard call to get message count and if count is 1, get message info.
4089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4090: EXCEPTION
4091: WHEN fnd_api.g_exc_error THEN
4092: ROLLBACK TO set_ced_and_bb;

Line 4139: -- Standard Start of API savepoint

4135: errmsg VARCHAR2(4000) := '';
4136: err_num NUMBER := NULL;
4137: l_org_id cn_payruns.org_id%TYPE;
4138: BEGIN
4139: -- Standard Start of API savepoint
4140: SAVEPOINT generic_conc_processor;
4141: -- SUBMIT BATCHES
4142: fnd_file.put_line(fnd_file.LOG,'Start the batching process for payrun_id = ' || p_payrun_id);
4143: l_org_id := p_org_id;