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 1506: -- Standard Start of API savepoint

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

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

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

Line 2033: -- Standard check of p_commit.

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

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

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

Line 2400: -- Standard Start of API savepoint

2396: l_pay_by_mode VARCHAR2(1);
2397: l_srp_status cn_salesreps.status%TYPE;
2398:
2399: BEGIN
2400: -- Standard Start of API savepoint
2401: SAVEPOINT update_worksheet;
2402:
2403: -- Standard call to check for call compatibility.
2404: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

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

2399: BEGIN
2400: -- Standard Start of API savepoint
2401: SAVEPOINT update_worksheet;
2402:
2403: -- Standard call to check for call compatibility.
2404: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)
2405: THEN
2406: RAISE fnd_api.g_exc_unexpected_error;
2407: END IF;

Line 3465: -- Standard check of p_commit.

3461: FROM cn_payment_worksheets
3462: WHERE payment_worksheet_id = p_worksheet_id;
3463:
3464: -- End of API body.
3465: -- Standard check of p_commit.
3466: IF fnd_api.to_boolean(p_commit)
3467: THEN
3468: COMMIT WORK;
3469: END IF;

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

3467: THEN
3468: COMMIT WORK;
3469: END IF;
3470:
3471: -- Standard call to get message count and if count is 1, get message info.
3472: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3473: EXCEPTION
3474: WHEN fnd_api.g_exc_error THEN
3475: ROLLBACK TO update_worksheet;

Line 3534: -- Standard Start of API savepoint

3530: l_has_access BOOLEAN;
3531: l_ovn NUMBER;
3532: BEGIN
3533: --
3534: -- Standard Start of API savepoint
3535: --
3536: SAVEPOINT delete_worksheet;
3537:
3538: --

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

3535: --
3536: SAVEPOINT delete_worksheet;
3537:
3538: --
3539: -- Standard call to check for call compatibility.
3540: --
3541: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)
3542: THEN
3543: RAISE fnd_api.g_exc_unexpected_error;

Line 3656: -- Standard check of p_commit.

3652: cn_payment_worksheets_pkg.delete_record(p_salesrep_id => wksht.salesrep_id, p_payrun_id => wksht.payrun_id);
3653: END LOOP;
3654:
3655: -- End of API body.
3656: -- Standard check of p_commit.
3657: IF fnd_api.to_boolean(p_commit)
3658: THEN
3659: COMMIT WORK;
3660: END IF;

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

3659: COMMIT WORK;
3660: END IF;
3661:
3662: --
3663: -- Standard call to get message count and if count is 1, get message info.
3664: --
3665: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3666: EXCEPTION
3667: WHEN fnd_api.g_exc_error THEN

Line 3727: -- Standard Start of API savepoint

3723: AND w.org_id = p.org_id;
3724:
3725: l_wksht_rec c_wksht_csr%ROWTYPE;
3726: BEGIN
3727: -- Standard Start of API savepoint
3728: SAVEPOINT get_ced_and_bb;
3729:
3730: -- Standard call to check for call compatibility.
3731: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

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

3726: BEGIN
3727: -- Standard Start of API savepoint
3728: SAVEPOINT get_ced_and_bb;
3729:
3730: -- Standard call to check for call compatibility.
3731: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)
3732: THEN
3733: RAISE fnd_api.g_exc_unexpected_error;
3734: END IF;

Line 3847: -- Standard check of p_commit.

3843: x_bb_total := nvl(x_bb_prior_period_adj, 0) + nvl(x_bb_pmt_recovery_plans, 0);
3844: x_curr_earnings_due := x_bb_total + nvl(x_curr_earnings, 0); -- + Nvl(l_held_amount_prior,0);
3845:
3846: -- End of API body.
3847: -- Standard check of p_commit.
3848: IF fnd_api.to_boolean(p_commit)
3849: THEN
3850: COMMIT WORK;
3851: END IF;

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

3850: COMMIT WORK;
3851: END IF;
3852:
3853: --
3854: -- Standard call to get message count and if count is 1, get message info.
3855: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3856: EXCEPTION
3857: WHEN fnd_api.g_exc_error THEN
3858: ROLLBACK TO get_ced_and_bb;

Line 3933: -- Standard Start of API savepoint

3929: l_loading_status VARCHAR2(30);
3930: -- varialve added for Bug 3140343
3931: l_ispayee NUMBER := 0;
3932: BEGIN
3933: -- Standard Start of API savepoint
3934: SAVEPOINT set_ced_and_bb;
3935:
3936: -- Standard call to check for call compatibility.
3937: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

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

3932: BEGIN
3933: -- Standard Start of API savepoint
3934: SAVEPOINT set_ced_and_bb;
3935:
3936: -- Standard call to check for call compatibility.
3937: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)
3938: THEN
3939: RAISE fnd_api.g_exc_unexpected_error;
3940: END IF;

Line 4035: -- Standard check of p_commit.

4031: -- Bug 3140343 : Payee Design.
4032: END IF;
4033:
4034: -- End of API body.
4035: -- Standard check of p_commit.
4036: IF fnd_api.to_boolean(p_commit)
4037: THEN
4038: COMMIT WORK;
4039: END IF;

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

4038: COMMIT WORK;
4039: END IF;
4040:
4041: --
4042: -- Standard call to get message count and if count is 1, get message info.
4043: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4044: EXCEPTION
4045: WHEN fnd_api.g_exc_error THEN
4046: ROLLBACK TO set_ced_and_bb;

Line 4093: -- Standard Start of API savepoint

4089: errmsg VARCHAR2(4000) := '';
4090: err_num NUMBER := NULL;
4091: l_org_id cn_payruns.org_id%TYPE;
4092: BEGIN
4093: -- Standard Start of API savepoint
4094: SAVEPOINT generic_conc_processor;
4095: -- SUBMIT BATCHES
4096: fnd_file.put_line(fnd_file.LOG,'Start the batching process for payrun_id = ' || p_payrun_id);
4097: l_org_id := p_org_id;