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_API

Line 1066: l_ispayee := cn_api.is_payee(p_period_id => p_period_id, p_salesrep_id => p_salesrep_id, p_org_id => p_org_id);

1062: ' WHERE (spayee.salesrep_id = v.salesrep_id OR ' || ' spayee.payee_id = v.salesrep_id)' || ' AND v.prd_end_date >= spayee.start_date' ||
1063: ' AND spayee.org_id = :p_org_id' || --R12
1064: ' AND v.prd_start_date <= Nvl(spayee.end_date, v.prd_end_date) )' || ' )';
1065: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1066: l_ispayee := cn_api.is_payee(p_period_id => p_period_id, p_salesrep_id => p_salesrep_id, p_org_id => p_org_id);
1067:
1068: -- if not a payee
1069: IF l_ispayee <> 1
1070: THEN

Line 1540: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,

1536: -- Salesrep should not be on hold -cn_salesreps.hold_payment
1537: -- Subledger entry should exist for salesrep, credit_type and period
1538: -- cn_srp_periods
1539: -- Mandatory parameters check for payrun_id, salesrep_id
1540: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,
1541: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1542: p_loading_status => x_loading_status,
1543: x_loading_status => x_loading_status)) = fnd_api.g_true)
1544: THEN

Line 1541: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),

1537: -- Subledger entry should exist for salesrep, credit_type and period
1538: -- cn_srp_periods
1539: -- Mandatory parameters check for payrun_id, salesrep_id
1540: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,
1541: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1542: p_loading_status => x_loading_status,
1543: x_loading_status => x_loading_status)) = fnd_api.g_true)
1544: THEN
1545: RAISE fnd_api.g_exc_error;

Line 1548: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,

1544: THEN
1545: RAISE fnd_api.g_exc_error;
1546: END IF;
1547:
1548: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,
1549: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1550: p_loading_status => x_loading_status,
1551: x_loading_status => x_loading_status)) = fnd_api.g_true)
1552: THEN

Line 1549: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),

1545: RAISE fnd_api.g_exc_error;
1546: END IF;
1547:
1548: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.salesrep_id,
1549: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1550: p_loading_status => x_loading_status,
1551: x_loading_status => x_loading_status)) = fnd_api.g_true)
1552: THEN
1553: RAISE fnd_api.g_exc_error;

Line 1557: IF cn_api.chk_payrun_status_paid(p_payrun_id => p_worksheet_rec.payrun_id, p_loading_status => x_loading_status, x_loading_status => x_loading_status) =

1553: RAISE fnd_api.g_exc_error;
1554: END IF;
1555:
1556: -- Check Payrun Status
1557: IF cn_api.chk_payrun_status_paid(p_payrun_id => p_worksheet_rec.payrun_id, p_loading_status => x_loading_status, x_loading_status => x_loading_status) =
1558: fnd_api.g_true
1559: THEN
1560: RAISE fnd_api.g_exc_error;
1561: END IF;

Line 1564: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,

1560: RAISE fnd_api.g_exc_error;
1561: END IF;
1562:
1563: -- Check if the salesrep is on hold
1564: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,
1565: --R12
1566: p_org_id => p_worksheet_rec.org_id,
1567: p_loading_status => x_loading_status,
1568: x_loading_status => x_loading_status) = fnd_api.g_true

Line 1632: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,

1628: -- N - Pay by Summary Y - Pay by Transaction
1629: l_pbt_profile_value := cn_payment_security_pvt.get_pay_by_mode(p_worksheet_rec.payrun_id);
1630:
1631: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
1632: l_ispayee := cn_api.is_payee(p_period_id => l_get_payrun_rec.pay_period_id,
1633: p_salesrep_id => p_worksheet_rec.salesrep_id,
1634: p_org_id => p_worksheet_rec.org_id);
1635:
1636: -- Check duplicate worksheet

Line 1637: IF cn_api.chk_duplicate_worksheet(p_payrun_id => p_worksheet_rec.payrun_id,

1633: p_salesrep_id => p_worksheet_rec.salesrep_id,
1634: p_org_id => p_worksheet_rec.org_id);
1635:
1636: -- Check duplicate worksheet
1637: IF cn_api.chk_duplicate_worksheet(p_payrun_id => p_worksheet_rec.payrun_id,
1638: p_salesrep_id => p_worksheet_rec.salesrep_id,
1639: p_org_id => p_worksheet_rec.org_id,
1640: p_loading_status => x_loading_status,
1641: x_loading_status => x_loading_status) = fnd_api.g_true

Line 1772: l_pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,

1768: THEN
1769: -- Bug 2880233: should find pay_element for PMTPLN base on quota_id
1770:
1771: -- IF l_calc_rec_tbl(i).pmt_amount_adj_rec <> 0 THEN
1772: l_pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,
1773: p_worksheet_rec.salesrep_id,
1774: --R12
1775: p_worksheet_rec.org_id,
1776: l_get_payrun_rec.pay_date);

Line 2459: l_ispayee := cn_api.is_payee(p_period_id => wksht_rec.pay_period_id, p_salesrep_id => wksht_rec.salesrep_id, p_org_id => wksht_rec.org_id);

2455: AND pr.org_id = r.org_id
2456: AND pr.payrun_id = wksht_rec.payrun_id;
2457:
2458: -- Bug 3140343 : Payee Design. Check if this salesrep is a Payee
2459: l_ispayee := cn_api.is_payee(p_period_id => wksht_rec.pay_period_id, p_salesrep_id => wksht_rec.salesrep_id, p_org_id => wksht_rec.org_id);
2460:
2461: IF p_operation = 'REFRESH'
2462: THEN
2463:

Line 2869: -- Bug 2875120 : remove cn_api function call in sql statement

2865: 'N',
2866: 'N',
2867: wksht_rec.payrun_id,
2868: nvl(cl.commission_amount, 0),
2869: -- Bug 2875120 : remove cn_api function call in sql statement
2870: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
2871: SYSDATE,
2872: fnd_global.user_id,
2873: --R12

Line 2968: -- Bug 2875120 : remove cn_api function call in sql statement

2964: 'N',
2965: 'N',
2966: wksht_rec.payrun_id,
2967: nvl(cl.commission_amount, 0),
2968: -- Bug 2875120 : remove cn_api function call in sql statement
2969: decode(l_payroll_flag, NULL, NULL, 'N', NULL, 'Y', qp.pay_element_type_id, NULL) pay_element_type_id,
2970: SYSDATE,
2971: fnd_global.user_id,
2972: --R12

Line 3127: l_pmt_trans_rec.pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,

3123: nvl(l_calc_rec_tbl(i).pmt_amount_adj_nrec, 0);
3124: --R12
3125: l_pmt_trans_rec.org_id := wksht_rec.org_id;
3126: l_pmt_trans_rec.object_version_number := 1;
3127: l_pmt_trans_rec.pay_element_type_id := cn_api.get_pay_element_id(l_calc_rec_tbl(i).quota_id,
3128: wksht_rec.salesrep_id,
3129: wksht_rec.org_id,
3130: wksht_rec.pay_date);
3131: -- Create the Payment Plan Record