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 CN_PAYMENT_SECURITY_PVT

Line 1527: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);

1523: -- Initialize API return status to success
1524: x_return_status := fnd_api.g_ret_sts_success;
1525: x_loading_status := 'CN_INSERTED';
1526: --Added for R12 payment security check begin.
1527: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);
1528:
1529: IF (l_has_access = FALSE)
1530: THEN
1531: RAISE fnd_api.g_exc_error;

Line 1631: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);

1627: END IF;
1628:
1629: -- Get the Pay By Summary Profile value
1630: -- N - Pay by Summary Y - Pay by Transaction
1631: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);
1632:
1633: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1634: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,
1635: p_salesrep_id => p_worksheet_rec.salesrep_id,

Line 2248: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);

2244: BEGIN
2245: fnd_file.put_line(fnd_file.log, 'Entering create_mult_worksheet_conc ');
2246: retcode := 0;
2247: --Added for R12 payment security check begin.
2248: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_wksht_create);
2249: --Get the salesrep batch size from profile option.
2250: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
2251: fnd_file.put_line(fnd_file.log,'Batch size : ' ||l_batch_sz);
2252:

Line 2488: l_pay_by_mode := cn_payment_security_pvt.get_pay_by_mode(wksht_rec.payrun_id);

2484:
2485: RAISE fnd_api.g_exc_error;
2486: END IF;
2487:
2488: l_pay_by_mode := cn_payment_security_pvt.get_pay_by_mode(wksht_rec.payrun_id);
2489:
2490: SELECT s.status,
2491: nvl(r.payroll_flag, 'N'),
2492: r.payables_flag

Line 2511: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

2507: IF p_operation = 'REFRESH'
2508: THEN
2509:
2510: --Added for R12 payment security check end.
2511: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
2512: p_init_msg_list => p_init_msg_list,
2513: p_commit => 'F',
2514: p_validation_level => p_validation_level,
2515: x_return_status => x_return_status,

Line 3379: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3375:
3376: ELSIF p_operation IN ('LOCK', 'RELEASE_HOLD')
3377: THEN
3378:
3379: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3380: p_init_msg_list => p_init_msg_list,
3381: p_commit => 'F',
3382: p_validation_level => p_validation_level,
3383: x_return_status => x_return_status,

Line 3429: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,

3425: END IF;
3426: END IF;
3427:
3428: -- set wksht audit
3429: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,
3430: p_payrun_id => wksht_rec.payrun_id,
3431: p_salesrep_id => wksht_rec.salesrep_id,
3432: p_action => p_operation,
3433: x_return_status => x_return_status,

Line 3444: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3440: END IF;
3441: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')
3442: THEN
3443: -- 'UNLOCK', 'SUBMIT'
3444: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3445: p_init_msg_list => p_init_msg_list,
3446: p_commit => 'F',
3447: p_validation_level => p_validation_level,
3448: x_return_status => x_return_status,

Line 3460: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3456: RAISE fnd_api.g_exc_error;
3457: END IF;
3458: ELSIF p_operation IN ('APPROVE', 'REJECT')
3459: THEN
3460: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3461: p_init_msg_list => p_init_msg_list,
3462: p_commit => 'F',
3463: p_validation_level => p_validation_level,
3464: x_return_status => x_return_status,

Line 3477: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3473: RAISE fnd_api.g_exc_error;
3474: END IF;
3475: ELSIF p_operation IN ('HOLD_ALL', 'RELEASE_ALL', 'RESET_TO_UNPAID')
3476: THEN
3477: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3478: p_init_msg_list => p_init_msg_list,
3479: p_commit => 'F',
3480: p_validation_level => p_validation_level,
3481: x_return_status => x_return_status,

Line 3612: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

3608: l_validation_only := nvl(p_validation_only, 'N');
3609:
3610: FOR wksht IN get_worksheet_dtls
3611: LOOP
3612: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,
3613: p_init_msg_list => p_init_msg_list,
3614: p_commit => 'F',
3615: p_validation_level => p_validation_level,
3616: x_return_status => x_return_status,

Line 3689: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,

3685: AND cnpd.credited_salesrep_id = wksht.salesrep_id
3686: AND nvl(cnpd.hold_flag, 'N') = 'N');
3687:
3688: -- add notes and audit
3689: cn_payment_security_pvt.worksheet_audit(p_worksheet_id => p_worksheet_id,
3690: p_payrun_id => wksht.payrun_id,
3691: p_salesrep_id => wksht.salesrep_id,
3692: p_action => 'REMOVE',
3693: x_return_status => x_return_status,

Line 4380: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_payrun_refresh);

4376: AND wk.org_id = mo_global.get_current_org_id);
4377:
4378: BEGIN
4379: fnd_file.put_line(fnd_file.log, 'Input Parameters Payrun_Name =' || p_name);
4380: l_has_access := cn_payment_security_pvt.get_security_access(cn_payment_security_pvt.g_type_wksht, cn_payment_security_pvt.g_access_payrun_refresh);
4381: --Get the salesrep batch size from profile option.
4382: l_batch_sz := nvl(fnd_profile.value('CN_PMT_SRP_BATCH_SIZE'),251);
4383: fnd_file.put_line(fnd_file.log, 'Batch Size =' || to_char(l_batch_sz));
4384: