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 FND_API

Line 128: raise fnd_api.G_EXC_ERROR;

124: IF x_request_id = 0
125: THEN
126: fnd_file.put_line(fnd_file.log, 'Failed to create concurrent request for (payrun_id,batch_id) = ' || p_payrun_id ||','|| p_batch_id);
127: fnd_file.put_line(fnd_file.log, 'Conc_submit: ' || fnd_message.get);
128: raise fnd_api.G_EXC_ERROR;
129: ELSE
130: fnd_file.put_line(fnd_file.log, 'Concurrent request, ID = ' || x_request_id || ', for (payrun_id,batch_id) = ' || p_payrun_id ||','|| p_batch_id );
131: END IF;
132:

Line 1512: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

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;
1516:

Line 1514: RAISE fnd_api.g_exc_unexpected_error;

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;
1516:
1517: -- Initialize message list if p_init_msg_list is set to TRUE.
1518: IF fnd_api.to_boolean(p_init_msg_list)

Line 1518: IF fnd_api.to_boolean(p_init_msg_list)

1514: RAISE fnd_api.g_exc_unexpected_error;
1515: END IF;
1516:
1517: -- Initialize message list if p_init_msg_list is set to TRUE.
1518: IF fnd_api.to_boolean(p_init_msg_list)
1519: THEN
1520: fnd_msg_pub.initialize;
1521: END IF;
1522:

Line 1524: x_return_status := fnd_api.g_ret_sts_success;

1520: fnd_msg_pub.initialize;
1521: END IF;
1522:
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:

Line 1531: RAISE fnd_api.g_exc_error;

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;
1532: END IF;
1533:
1534: -- API body
1535: -- The following validations are performed by this API

Line 1545: x_loading_status => x_loading_status)) = fnd_api.g_true)

1541: -- Mandatory parameters check for payrun_id, salesrep_id
1542: IF ((cn_api.chk_miss_null_num_para(p_num_para => p_worksheet_rec.payrun_id,
1543: p_obj_name => cn_api.get_lkup_meaning('PAY_RUN_NAME', 'PAY_RUN_VALIDATION_TYPE'),
1544: p_loading_status => x_loading_status,
1545: x_loading_status => x_loading_status)) = fnd_api.g_true)
1546: THEN
1547: RAISE fnd_api.g_exc_error;
1548: END IF;
1549:

Line 1547: RAISE fnd_api.g_exc_error;

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

Line 1553: x_loading_status => x_loading_status)) = fnd_api.g_true)

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

Line 1555: RAISE fnd_api.g_exc_error;

1551: p_obj_name => cn_api.get_lkup_meaning('SALES_PERSON', 'PAY_RUN_VALIDATION_TYPE'),
1552: p_loading_status => x_loading_status,
1553: x_loading_status => x_loading_status)) = fnd_api.g_true)
1554: THEN
1555: RAISE fnd_api.g_exc_error;
1556: END IF;
1557:
1558: -- Check Payrun Status
1559: 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) =

Line 1560: fnd_api.g_true

1556: END IF;
1557:
1558: -- Check Payrun Status
1559: 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) =
1560: fnd_api.g_true
1561: THEN
1562: RAISE fnd_api.g_exc_error;
1563: END IF;
1564:

Line 1562: RAISE fnd_api.g_exc_error;

1558: -- Check Payrun Status
1559: 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) =
1560: fnd_api.g_true
1561: THEN
1562: RAISE fnd_api.g_exc_error;
1563: END IF;
1564:
1565: -- Check if the salesrep is on hold
1566: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,

Line 1570: x_loading_status => x_loading_status) = fnd_api.g_true

1566: IF cn_api.chk_srp_hold_status(p_salesrep_id => p_worksheet_rec.salesrep_id,
1567: --R12
1568: p_org_id => p_worksheet_rec.org_id,
1569: p_loading_status => x_loading_status,
1570: x_loading_status => x_loading_status) = fnd_api.g_true
1571: THEN
1572: RAISE fnd_api.g_exc_error;
1573: END IF;
1574:

Line 1572: RAISE fnd_api.g_exc_error;

1568: p_org_id => p_worksheet_rec.org_id,
1569: p_loading_status => x_loading_status,
1570: x_loading_status => x_loading_status) = fnd_api.g_true
1571: THEN
1572: RAISE fnd_api.g_exc_error;
1573: END IF;
1574:
1575: -- Get the Payrun
1576: BEGIN

Line 1605: RAISE fnd_api.g_exc_error;

1601: IF err_num = -54
1602: THEN
1603: fnd_message.set_name('CN', 'CN_INVALID_OBJECT_VERSION');
1604: fnd_msg_pub.add;
1605: RAISE fnd_api.g_exc_error;
1606: ELSE
1607: RAISE;
1608: END IF;
1609: END;

Line 1626: RAISE fnd_api.g_exc_error;

1622: fnd_msg_pub.add;
1623: END IF;
1624:
1625: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
1626: RAISE fnd_api.g_exc_error;
1627: END IF;
1628:
1629: -- Get the Pay By Summary Profile value
1630: -- N - Pay by Summary Y - Pay by Transaction

Line 1643: x_loading_status => x_loading_status) = fnd_api.g_true

1639: IF cn_api.chk_duplicate_worksheet(p_payrun_id => p_worksheet_rec.payrun_id,
1640: p_salesrep_id => p_worksheet_rec.salesrep_id,
1641: p_org_id => p_worksheet_rec.org_id,
1642: p_loading_status => x_loading_status,
1643: x_loading_status => x_loading_status) = fnd_api.g_true
1644: THEN
1645: RAISE fnd_api.g_exc_error;
1646: END IF;
1647:

Line 1645: RAISE fnd_api.g_exc_error;

1641: p_org_id => p_worksheet_rec.org_id,
1642: p_loading_status => x_loading_status,
1643: x_loading_status => x_loading_status) = fnd_api.g_true
1644: THEN
1645: RAISE fnd_api.g_exc_error;
1646: END IF;
1647:
1648: -- get quarter Number and Year Number
1649: OPEN get_prd_statuses(l_get_payrun_rec.pay_period_id);

Line 1738: RAISE fnd_api.g_exc_error;

1734: fnd_msg_pub.add;
1735: END IF;
1736:
1737: x_loading_status := 'CN_CALC_NOT_COMPLETE';
1738: RAISE fnd_api.g_exc_error;
1739: END IF;
1740:
1741: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_error)
1742: THEN

Line 1748: RAISE fnd_api.g_exc_error;

1744: fnd_msg_pub.add;
1745: END IF;
1746:
1747: x_loading_status := 'CN_WKSHT_SRP_COMM_MISMATCH';
1748: RAISE fnd_api.g_exc_error;
1749: END IF; -- end if ABS() > .1
1750: END IF; --end if l_pbt_profile_value = 'Y'
1751:
1752: -- calculate values for payment plan records

Line 1879: RAISE fnd_api.g_exc_error;

1875: fnd_msg_pub.add;
1876: END IF;
1877:
1878: x_loading_status := 'CN_DUPLICATE_WORKSHEET';
1879: RAISE fnd_api.g_exc_error;
1880: END IF;
1881: EXCEPTION
1882: WHEN no_data_found THEN
1883: NULL;

Line 1904: RAISE fnd_api.g_exc_error;

1900: p_object_version_number => 1);
1901:
1902: IF x_loading_status <> 'CN_INSERTED'
1903: THEN
1904: RAISE fnd_api.g_exc_error;
1905: END IF;
1906:
1907: OPEN get_worksheet_id;
1908:

Line 2028: x_loading_status => x_loading_status)) = fnd_api.g_true

2024: -- Populate ccid's in payment worksheets
2025: IF (cn_payrun_pvt.populate_ccids(p_payrun_id => p_worksheet_rec.payrun_id,
2026: p_salesrep_id => p_worksheet_rec.salesrep_id,
2027: p_loading_status => x_loading_status,
2028: x_loading_status => x_loading_status)) = fnd_api.g_true
2029: THEN
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032: END IF;

Line 2030: RAISE fnd_api.g_exc_unexpected_error;

2026: p_salesrep_id => p_worksheet_rec.salesrep_id,
2027: p_loading_status => x_loading_status,
2028: x_loading_status => x_loading_status)) = fnd_api.g_true
2029: THEN
2030: RAISE fnd_api.g_exc_unexpected_error;
2031: END IF;
2032: END IF;
2033:
2034: -- End of API body.

Line 2036: IF fnd_api.to_boolean(p_commit)

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;
2040:

Line 2044: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
2047: ROLLBACK TO create_worksheet;
2048: x_return_status := fnd_api.g_ret_sts_error;

Line 2046: WHEN fnd_api.g_exc_error THEN

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
2047: ROLLBACK TO create_worksheet;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2050: WHEN fnd_api.g_exc_unexpected_error THEN

Line 2048: x_return_status := fnd_api.g_ret_sts_error;

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
2047: ROLLBACK TO create_worksheet;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2050: WHEN fnd_api.g_exc_unexpected_error THEN
2051: ROLLBACK TO create_worksheet;
2052: x_loading_status := 'UNEXPECTED_ERR';

Line 2049: 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
2047: ROLLBACK TO create_worksheet;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2050: WHEN fnd_api.g_exc_unexpected_error THEN
2051: ROLLBACK TO create_worksheet;
2052: x_loading_status := 'UNEXPECTED_ERR';
2053: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2050: WHEN fnd_api.g_exc_unexpected_error THEN

2046: WHEN fnd_api.g_exc_error THEN
2047: ROLLBACK TO create_worksheet;
2048: x_return_status := fnd_api.g_ret_sts_error;
2049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2050: WHEN fnd_api.g_exc_unexpected_error THEN
2051: ROLLBACK TO create_worksheet;
2052: x_loading_status := 'UNEXPECTED_ERR';
2053: x_return_status := fnd_api.g_ret_sts_unexp_error;
2054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 2053: x_return_status := fnd_api.g_ret_sts_unexp_error;

2049: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2050: WHEN fnd_api.g_exc_unexpected_error THEN
2051: ROLLBACK TO create_worksheet;
2052: x_loading_status := 'UNEXPECTED_ERR';
2053: x_return_status := fnd_api.g_ret_sts_unexp_error;
2054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2055: WHEN OTHERS THEN
2056: ROLLBACK TO create_worksheet;
2057: x_loading_status := 'UNEXPECTED_ERR';

Line 2054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2050: WHEN fnd_api.g_exc_unexpected_error THEN
2051: ROLLBACK TO create_worksheet;
2052: x_loading_status := 'UNEXPECTED_ERR';
2053: x_return_status := fnd_api.g_ret_sts_unexp_error;
2054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2055: WHEN OTHERS THEN
2056: ROLLBACK TO create_worksheet;
2057: x_loading_status := 'UNEXPECTED_ERR';
2058: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2058: x_return_status := fnd_api.g_ret_sts_unexp_error;

2054: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2055: WHEN OTHERS THEN
2056: ROLLBACK TO create_worksheet;
2057: x_loading_status := 'UNEXPECTED_ERR';
2058: x_return_status := fnd_api.g_ret_sts_unexp_error;
2059:
2060: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
2061: THEN
2062: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 2065: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

2061: THEN
2062: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2063: END IF;
2064:
2065: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
2066: END create_worksheet;
2067:
2068: -- ===========================================================================
2069: -- Procedure : Create_Multiple_Worksheets

Line 2084: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;

2080: )
2081: IS
2082: l_api_name CONSTANT VARCHAR2 (30) := 'Create_Multiple_Worksheets';
2083: g_api_version CONSTANT NUMBER := 1.0;
2084: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
2085: x_msg_count NUMBER;
2086: x_msg_data VARCHAR2(4000);
2087: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
2088: x_status VARCHAR2(200);

Line 2102: x_return_status := fnd_api.g_ret_sts_success;

2098: BEGIN
2099: --
2100: -- Initialize API return status to success
2101: --
2102: x_return_status := fnd_api.g_ret_sts_success;
2103: x_loading_status := 'CN_INSERTED';
2104: --
2105: -- API body
2106: --

Line 2131: p_validation_level => fnd_api.g_valid_level_full,

2127:
2128: cn_payment_worksheet_pvt.create_worksheet(p_api_version => 1.0,
2129: p_init_msg_list => 'T',
2130: p_commit => 'F',
2131: p_validation_level => fnd_api.g_valid_level_full,
2132: x_return_status => x_return_status,
2133: x_msg_count => x_msg_count,
2134: x_msg_data => x_msg_data,
2135: p_worksheet_rec => l_worksheet_rec,

Line 2139: IF x_return_status <> fnd_api.g_ret_sts_success

2135: p_worksheet_rec => l_worksheet_rec,
2136: x_loading_status => x_loading_status,
2137: x_status => x_status);
2138:
2139: IF x_return_status <> fnd_api.g_ret_sts_success
2140: THEN
2141: l_error_count := l_error_count + 1;
2142: cn_message_pkg.debug('Error when creating Worksheet for : ' || l_worksheet_rec.salesrep_id);
2143: fnd_file.put_line(fnd_file.log, 'Failed to create worksheet for ' || l_worksheet_rec.salesrep_id);

Line 2261: RAISE fnd_api.g_exc_error;

2257: raise_application_error(-20000, errmsg);
2258: END IF;
2259:
2260: IF (l_has_access = FALSE) THEN
2261: RAISE fnd_api.g_exc_error;
2262: END IF;
2263:
2264: --Added for R12 payment security check end.
2265: l_org_id := mo_global.get_current_org_id;

Line 2360: IF l_return_status <> fnd_api.g_ret_sts_success

2356: fnd_file.put_line(fnd_file.log, errbuf);
2357: fnd_file.put_line(fnd_file.log, 'Count of worksheets to be created = ' || salesrep_t.COUNT);
2358: fnd_file.put_line(fnd_file.log, 'Completed create worksheet process....');
2359:
2360: IF l_return_status <> fnd_api.g_ret_sts_success
2361: THEN
2362: retcode := 2;
2363: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2364: fnd_msg_pub.add;

Line 2365: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);

2361: THEN
2362: retcode := 2;
2363: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2364: fnd_msg_pub.add;
2365: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2366: END IF;
2367:
2368: cn_message_pkg.end_batch(l_proc_audit_id);
2369: COMMIT;

Line 2450: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

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;
2454:

Line 2452: RAISE fnd_api.g_exc_unexpected_error;

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;
2454:
2455: --
2456: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2458: IF fnd_api.to_boolean(p_init_msg_list)

2454:
2455: --
2456: -- Initialize message list if p_init_msg_list is set to TRUE.
2457: --
2458: IF fnd_api.to_boolean(p_init_msg_list)
2459: THEN
2460: fnd_msg_pub.initialize;
2461: END IF;
2462:

Line 2466: x_return_status := fnd_api.g_ret_sts_success;

2462:
2463: --
2464: -- Initialize API return status to success
2465: --
2466: x_return_status := fnd_api.g_ret_sts_success;
2467: x_loading_status := 'CN_UPDATED';
2468:
2469: OPEN get_worksheet_id;
2470:

Line 2485: RAISE fnd_api.g_exc_error;

2481: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2482: fnd_msg_pub.add;
2483: END IF;
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:

Line 2521: IF x_return_status <> fnd_api.g_ret_sts_success

2517: x_msg_data => x_msg_data,
2518: p_worksheet_id => p_worksheet_id,
2519: p_action => p_operation);
2520:
2521: IF x_return_status <> fnd_api.g_ret_sts_success
2522: THEN
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:

Line 2523: RAISE fnd_api.g_exc_error;

2519: p_action => p_operation);
2520:
2521: IF x_return_status <> fnd_api.g_ret_sts_success
2522: THEN
2523: RAISE fnd_api.g_exc_error;
2524: END IF;
2525:
2526: -- get sequence number
2527: SELECT cn_posting_batches_s.NEXTVAL

Line 3370: x_loading_status => x_loading_status)) = fnd_api.g_true

3366: -- Populate ccid's in payment worksheets
3367: IF (cn_payrun_pvt.populate_ccids(p_payrun_id => wksht_rec.payrun_id,
3368: p_salesrep_id => wksht_rec.salesrep_id,
3369: p_loading_status => x_loading_status,
3370: x_loading_status => x_loading_status)) = fnd_api.g_true
3371: THEN
3372: RAISE fnd_api.g_exc_unexpected_error;
3373: END IF;
3374: END IF;

Line 3372: RAISE fnd_api.g_exc_unexpected_error;

3368: p_salesrep_id => wksht_rec.salesrep_id,
3369: p_loading_status => x_loading_status,
3370: x_loading_status => x_loading_status)) = fnd_api.g_true
3371: THEN
3372: RAISE fnd_api.g_exc_unexpected_error;
3373: END IF;
3374: END IF;
3375:
3376: ELSIF p_operation IN ('LOCK', 'RELEASE_HOLD')

Line 3388: p_do_audit => fnd_api.g_false);

3384: x_msg_count => x_msg_count,
3385: x_msg_data => x_msg_data,
3386: p_worksheet_id => p_worksheet_id,
3387: p_action => p_operation,
3388: p_do_audit => fnd_api.g_false);
3389:
3390: IF x_return_status <> fnd_api.g_ret_sts_success
3391: THEN
3392: RAISE fnd_api.g_exc_error;

Line 3390: IF x_return_status <> fnd_api.g_ret_sts_success

3386: p_worksheet_id => p_worksheet_id,
3387: p_action => p_operation,
3388: p_do_audit => fnd_api.g_false);
3389:
3390: IF x_return_status <> fnd_api.g_ret_sts_success
3391: THEN
3392: RAISE fnd_api.g_exc_error;
3393: END IF;
3394:

Line 3392: RAISE fnd_api.g_exc_error;

3388: p_do_audit => fnd_api.g_false);
3389:
3390: IF x_return_status <> fnd_api.g_ret_sts_success
3391: THEN
3392: RAISE fnd_api.g_exc_error;
3393: END IF;
3394:
3395: IF p_operation = 'LOCK'
3396: THEN

Line 3405: IF x_return_status <> fnd_api.g_ret_sts_success

3401: x_msg_count => x_msg_count,
3402: x_msg_data => x_msg_data,
3403: p_worksheet_id => p_worksheet_id);
3404:
3405: IF x_return_status <> fnd_api.g_ret_sts_success
3406: THEN
3407: RAISE fnd_api.g_exc_error;
3408: END IF;
3409: ELSIF p_operation = 'RELEASE_HOLD'

Line 3407: RAISE fnd_api.g_exc_error;

3403: p_worksheet_id => p_worksheet_id);
3404:
3405: IF x_return_status <> fnd_api.g_ret_sts_success
3406: THEN
3407: RAISE fnd_api.g_exc_error;
3408: END IF;
3409: ELSIF p_operation = 'RELEASE_HOLD'
3410: THEN
3411:

Line 3422: IF x_return_status <> fnd_api.g_ret_sts_success

3418: x_msg_count => x_msg_count,
3419: x_msg_data => x_msg_data,
3420: p_payment_worksheet_id => p_worksheet_id);
3421:
3422: IF x_return_status <> fnd_api.g_ret_sts_success
3423: THEN
3424: RAISE fnd_api.g_exc_error;
3425: END IF;
3426: END IF;

Line 3424: RAISE fnd_api.g_exc_error;

3420: p_payment_worksheet_id => p_worksheet_id);
3421:
3422: IF x_return_status <> fnd_api.g_ret_sts_success
3423: THEN
3424: RAISE fnd_api.g_exc_error;
3425: END IF;
3426: END IF;
3427:
3428: -- set wksht audit

Line 3437: IF x_return_status <> fnd_api.g_ret_sts_success

3433: x_return_status => x_return_status,
3434: x_msg_count => x_msg_count,
3435: x_msg_data => x_msg_data);
3436:
3437: IF x_return_status <> fnd_api.g_ret_sts_success
3438: THEN
3439: RAISE fnd_api.g_exc_error;
3440: END IF;
3441: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')

Line 3439: RAISE fnd_api.g_exc_error;

3435: x_msg_data => x_msg_data);
3436:
3437: IF x_return_status <> fnd_api.g_ret_sts_success
3438: THEN
3439: RAISE fnd_api.g_exc_error;
3440: END IF;
3441: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')
3442: THEN
3443: -- 'UNLOCK', 'SUBMIT'

Line 3454: IF x_return_status <> fnd_api.g_ret_sts_success

3450: x_msg_data => x_msg_data,
3451: p_worksheet_id => p_worksheet_id,
3452: p_action => p_operation);
3453:
3454: IF x_return_status <> fnd_api.g_ret_sts_success
3455: THEN
3456: RAISE fnd_api.g_exc_error;
3457: END IF;
3458: ELSIF p_operation IN ('APPROVE', 'REJECT')

Line 3456: RAISE fnd_api.g_exc_error;

3452: p_action => p_operation);
3453:
3454: IF x_return_status <> fnd_api.g_ret_sts_success
3455: THEN
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,

Line 3469: p_do_audit => fnd_api.g_true);

3465: x_msg_count => x_msg_count,
3466: x_msg_data => x_msg_data,
3467: p_worksheet_id => p_worksheet_id,
3468: p_action => p_operation,
3469: p_do_audit => fnd_api.g_true);
3470:
3471: IF x_return_status <> fnd_api.g_ret_sts_success
3472: THEN
3473: RAISE fnd_api.g_exc_error;

Line 3471: IF x_return_status <> fnd_api.g_ret_sts_success

3467: p_worksheet_id => p_worksheet_id,
3468: p_action => p_operation,
3469: p_do_audit => fnd_api.g_true);
3470:
3471: IF x_return_status <> fnd_api.g_ret_sts_success
3472: THEN
3473: RAISE fnd_api.g_exc_error;
3474: END IF;
3475: ELSIF p_operation IN ('HOLD_ALL', 'RELEASE_ALL', 'RESET_TO_UNPAID')

Line 3473: RAISE fnd_api.g_exc_error;

3469: p_do_audit => fnd_api.g_true);
3470:
3471: IF x_return_status <> fnd_api.g_ret_sts_success
3472: THEN
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,

Line 3486: p_do_audit => fnd_api.g_true);

3482: x_msg_count => x_msg_count,
3483: x_msg_data => x_msg_data,
3484: p_worksheet_id => p_worksheet_id,
3485: p_action => p_operation,
3486: p_do_audit => fnd_api.g_true);
3487:
3488: IF x_return_status <> fnd_api.g_ret_sts_success
3489: THEN
3490: RAISE fnd_api.g_exc_error;

Line 3488: IF x_return_status <> fnd_api.g_ret_sts_success

3484: p_worksheet_id => p_worksheet_id,
3485: p_action => p_operation,
3486: p_do_audit => fnd_api.g_true);
3487:
3488: IF x_return_status <> fnd_api.g_ret_sts_success
3489: THEN
3490: RAISE fnd_api.g_exc_error;
3491: END IF;
3492: END IF;

Line 3490: RAISE fnd_api.g_exc_error;

3486: p_do_audit => fnd_api.g_true);
3487:
3488: IF x_return_status <> fnd_api.g_ret_sts_success
3489: THEN
3490: RAISE fnd_api.g_exc_error;
3491: END IF;
3492: END IF;
3493:
3494: --Update object_version_number

Line 3512: IF fnd_api.to_boolean(p_commit)

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;
3516:

Line 3518: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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;
3522: x_return_status := fnd_api.g_ret_sts_error;

Line 3520: WHEN fnd_api.g_exc_error THEN

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;
3522: x_return_status := fnd_api.g_ret_sts_error;
3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3522: x_return_status := fnd_api.g_ret_sts_error;

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;
3522: x_return_status := fnd_api.g_ret_sts_error;
3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';

Line 3523: 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;
3522: x_return_status := fnd_api.g_ret_sts_error;
3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3524: WHEN fnd_api.g_exc_unexpected_error THEN

3520: WHEN fnd_api.g_exc_error THEN
3521: ROLLBACK TO update_worksheet;
3522: x_return_status := fnd_api.g_ret_sts_error;
3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;
3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3527: x_return_status := fnd_api.g_ret_sts_unexp_error;

3523: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;
3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN OTHERS THEN
3530: ROLLBACK TO update_worksheet;
3531: x_loading_status := 'UNEXPECTED_ERR';

Line 3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3524: WHEN fnd_api.g_exc_unexpected_error THEN
3525: ROLLBACK TO update_worksheet;
3526: x_loading_status := 'UNEXPECTED_ERR';
3527: x_return_status := fnd_api.g_ret_sts_unexp_error;
3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN OTHERS THEN
3530: ROLLBACK TO update_worksheet;
3531: x_loading_status := 'UNEXPECTED_ERR';
3532: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3532: x_return_status := fnd_api.g_ret_sts_unexp_error;

3528: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3529: WHEN OTHERS THEN
3530: ROLLBACK TO update_worksheet;
3531: x_loading_status := 'UNEXPECTED_ERR';
3532: x_return_status := fnd_api.g_ret_sts_unexp_error;
3533:
3534: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3535: THEN
3536: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3535: THEN
3536: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3537: END IF;
3538:
3539: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3540: END update_worksheet;
3541:
3542: -- ===========================================================================
3543: -- Procedure : delete_worksheet

Line 3587: IF NOT fnd_api.compatible_api_call(g_api_version, p_api_version, l_api_name, g_pkg_name)

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;
3590: END IF;
3591:

Line 3589: RAISE fnd_api.g_exc_unexpected_error;

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;
3590: END IF;
3591:
3592: --
3593: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3595: IF fnd_api.to_boolean(p_init_msg_list)

3591:
3592: --
3593: -- Initialize message list if p_init_msg_list is set to TRUE.
3594: --
3595: IF fnd_api.to_boolean(p_init_msg_list)
3596: THEN
3597: fnd_msg_pub.initialize;
3598: END IF;
3599:

Line 3603: x_return_status := fnd_api.g_ret_sts_success;

3599:
3600: --
3601: -- Initialize API return status to success
3602: --
3603: x_return_status := fnd_api.g_ret_sts_success;
3604: x_loading_status := 'CN_DELETED';
3605:
3606: -- API body
3607: --R12 for OA. When p_validation_only = 'Y', only do validation for delete from OA.

Line 3621: p_do_audit => fnd_api.g_false);

3617: x_msg_count => x_msg_count,
3618: x_msg_data => x_msg_data,
3619: p_worksheet_id => p_worksheet_id,
3620: p_action => 'REMOVE',
3621: p_do_audit => fnd_api.g_false);
3622:
3623: IF x_return_status <> fnd_api.g_ret_sts_success
3624: THEN
3625: RAISE fnd_api.g_exc_error;

Line 3623: IF x_return_status <> fnd_api.g_ret_sts_success

3619: p_worksheet_id => p_worksheet_id,
3620: p_action => 'REMOVE',
3621: p_do_audit => fnd_api.g_false);
3622:
3623: IF x_return_status <> fnd_api.g_ret_sts_success
3624: THEN
3625: RAISE fnd_api.g_exc_error;
3626: END IF;
3627:

Line 3625: RAISE fnd_api.g_exc_error;

3621: p_do_audit => fnd_api.g_false);
3622:
3623: IF x_return_status <> fnd_api.g_ret_sts_success
3624: THEN
3625: RAISE fnd_api.g_exc_error;
3626: END IF;
3627:
3628: --R12
3629: EXIT WHEN l_validation_only = 'Y';

Line 3703: IF fnd_api.to_boolean(p_commit)

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;
3707:

Line 3711: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;

Line 3713: WHEN fnd_api.g_exc_error THEN

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
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;
3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3715: x_return_status := fnd_api.g_ret_sts_error;

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
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;
3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';

Line 3716: 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
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;
3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3717: WHEN fnd_api.g_exc_unexpected_error THEN

3713: WHEN fnd_api.g_exc_error THEN
3714: ROLLBACK TO delete_worksheet;
3715: x_return_status := fnd_api.g_ret_sts_error;
3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3720: x_return_status := fnd_api.g_ret_sts_unexp_error;

3716: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3722: WHEN OTHERS THEN
3723: ROLLBACK TO delete_worksheet;
3724: x_loading_status := 'UNEXPECTED_ERR';

Line 3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3717: WHEN fnd_api.g_exc_unexpected_error THEN
3718: ROLLBACK TO delete_worksheet;
3719: x_loading_status := 'UNEXPECTED_ERR';
3720: x_return_status := fnd_api.g_ret_sts_unexp_error;
3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3722: WHEN OTHERS THEN
3723: ROLLBACK TO delete_worksheet;
3724: x_loading_status := 'UNEXPECTED_ERR';
3725: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3725: x_return_status := fnd_api.g_ret_sts_unexp_error;

3721: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3722: WHEN OTHERS THEN
3723: ROLLBACK TO delete_worksheet;
3724: x_loading_status := 'UNEXPECTED_ERR';
3725: x_return_status := fnd_api.g_ret_sts_unexp_error;
3726:
3727: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3728: THEN
3729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3728: THEN
3729: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3730: END IF;
3731:
3732: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3733: END delete_worksheet;
3734:
3735:
3736: PROCEDURE get_ced_and_bb

Line 3777: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

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;
3781:

Line 3779: RAISE fnd_api.g_exc_unexpected_error;

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;
3781:
3782: -- Initialize message list if p_init_msg_list is set to TRUE.
3783: IF fnd_api.to_boolean(p_init_msg_list)

Line 3783: IF fnd_api.to_boolean(p_init_msg_list)

3779: RAISE fnd_api.g_exc_unexpected_error;
3780: END IF;
3781:
3782: -- Initialize message list if p_init_msg_list is set to TRUE.
3783: IF fnd_api.to_boolean(p_init_msg_list)
3784: THEN
3785: fnd_msg_pub.initialize;
3786: END IF;
3787:

Line 3789: x_return_status := fnd_api.g_ret_sts_success;

3785: fnd_msg_pub.initialize;
3786: END IF;
3787:
3788: -- Initialize API return status to success
3789: x_return_status := fnd_api.g_ret_sts_success;
3790: -- API Body
3791: x_curr_earnings := 0;
3792: x_curr_earnings_due := 0;
3793: x_bb_prior_period_adj := 0;

Line 3811: RAISE fnd_api.g_exc_error;

3807: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3808: fnd_msg_pub.add;
3809: END IF;
3810:
3811: RAISE fnd_api.g_exc_error;
3812: END IF;
3813:
3814: CLOSE c_wksht_csr;
3815:

Line 3894: IF fnd_api.to_boolean(p_commit)

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;
3898:

Line 3901: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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;
3905: x_return_status := fnd_api.g_ret_sts_error;

Line 3903: WHEN fnd_api.g_exc_error THEN

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;
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN

Line 3905: x_return_status := fnd_api.g_ret_sts_error;

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;
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3906: 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;
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3907: WHEN fnd_api.g_exc_unexpected_error THEN

3903: WHEN fnd_api.g_exc_error THEN
3904: ROLLBACK TO get_ced_and_bb;
3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3911: WHEN OTHERS THEN

Line 3909: x_return_status := fnd_api.g_ret_sts_unexp_error;

3905: x_return_status := fnd_api.g_ret_sts_error;
3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3911: WHEN OTHERS THEN
3912: ROLLBACK TO get_ced_and_bb;
3913: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3906: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3907: WHEN fnd_api.g_exc_unexpected_error THEN
3908: ROLLBACK TO get_ced_and_bb;
3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3911: WHEN OTHERS THEN
3912: ROLLBACK TO get_ced_and_bb;
3913: x_return_status := fnd_api.g_ret_sts_unexp_error;
3914:

Line 3913: x_return_status := fnd_api.g_ret_sts_unexp_error;

3909: x_return_status := fnd_api.g_ret_sts_unexp_error;
3910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3911: WHEN OTHERS THEN
3912: ROLLBACK TO get_ced_and_bb;
3913: x_return_status := fnd_api.g_ret_sts_unexp_error;
3914:
3915: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3916: THEN
3917: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 3920: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

3916: THEN
3917: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3918: END IF;
3919:
3920: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3921: END get_ced_and_bb;
3922:
3923: --============================================================================
3924: --Name :set_ced_and_bb

Line 3983: IF NOT fnd_api.compatible_api_call(l_api_version, p_api_version, l_api_name, g_pkg_name)

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;
3987:

Line 3985: RAISE fnd_api.g_exc_unexpected_error;

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;
3987:
3988: -- Initialize message list if p_init_msg_list is set to TRUE.
3989: IF fnd_api.to_boolean(p_init_msg_list)

Line 3989: IF fnd_api.to_boolean(p_init_msg_list)

3985: RAISE fnd_api.g_exc_unexpected_error;
3986: END IF;
3987:
3988: -- Initialize message list if p_init_msg_list is set to TRUE.
3989: IF fnd_api.to_boolean(p_init_msg_list)
3990: THEN
3991: fnd_msg_pub.initialize;
3992: END IF;
3993:

Line 3995: x_return_status := fnd_api.g_ret_sts_success;

3991: fnd_msg_pub.initialize;
3992: END IF;
3993:
3994: -- Initialize API return status to success
3995: x_return_status := fnd_api.g_ret_sts_success;
3996:
3997: -- API Body
3998: -- Get the Status Info
3999: OPEN c_status_csr;

Line 4012: RAISE fnd_api.g_exc_error;

4008: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
4009: fnd_msg_pub.add;
4010: END IF;
4011:
4012: RAISE fnd_api.g_exc_error;
4013: END IF;
4014:
4015: CLOSE c_status_csr;
4016:

Line 4082: IF fnd_api.to_boolean(p_commit)

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;
4086:

Line 4089: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

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;
4093: x_return_status := fnd_api.g_ret_sts_error;

Line 4091: WHEN fnd_api.g_exc_error THEN

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;
4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN

Line 4093: x_return_status := fnd_api.g_ret_sts_error;

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;
4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4094: 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;
4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4095: WHEN fnd_api.g_exc_unexpected_error THEN

4091: WHEN fnd_api.g_exc_error THEN
4092: ROLLBACK TO set_ced_and_bb;
4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4099: WHEN OTHERS THEN

Line 4097: x_return_status := fnd_api.g_ret_sts_unexp_error;

4093: x_return_status := fnd_api.g_ret_sts_error;
4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4099: WHEN OTHERS THEN
4100: ROLLBACK TO set_ced_and_bb;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4094: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4095: WHEN fnd_api.g_exc_unexpected_error THEN
4096: ROLLBACK TO set_ced_and_bb;
4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4099: WHEN OTHERS THEN
4100: ROLLBACK TO set_ced_and_bb;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:

Line 4101: x_return_status := fnd_api.g_ret_sts_unexp_error;

4097: x_return_status := fnd_api.g_ret_sts_unexp_error;
4098: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4099: WHEN OTHERS THEN
4100: ROLLBACK TO set_ced_and_bb;
4101: x_return_status := fnd_api.g_ret_sts_unexp_error;
4102:
4103: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4104: THEN
4105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

Line 4108: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

4104: THEN
4105: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4106: END IF;
4107:
4108: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4109: END set_ced_and_bb;
4110:
4111:
4112:

Line 4480: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;

4476: p_logical_batch_id IN NUMBER,
4477: --R12
4478: p_org_id IN cn_payruns.org_id%TYPE
4479: ) IS
4480: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4481: x_msg_count NUMBER;
4482: x_msg_data VARCHAR2(4000);
4483: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
4484: x_status VARCHAR2(200);

Line 4519: p_validation_level => fnd_api.g_valid_level_full,

4515:
4516: cn_payment_worksheet_pvt.update_worksheet(p_api_version => 1.0,
4517: p_init_msg_list => 'T',
4518: p_commit => 'F',
4519: p_validation_level => fnd_api.g_valid_level_full,
4520: x_return_status => x_return_status,
4521: x_msg_count => x_msg_count,
4522: x_msg_data => x_msg_data,
4523: p_worksheet_id => l_worksheet_rec.worksheet_id,

Line 4532: IF x_return_status <> fnd_api.g_ret_sts_success

4528: );
4529:
4530: END LOOP;
4531:
4532: IF x_return_status <> fnd_api.g_ret_sts_success
4533: THEN
4534: l_error_count := l_error_count + 1;
4535:
4536: --ROLLBACK TO create_single_worksheet;