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 126: raise fnd_api.G_EXC_ERROR;

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

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

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

Line 1512: RAISE fnd_api.g_exc_unexpected_error;

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

Line 1516: IF fnd_api.to_boolean(p_init_msg_list)

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

Line 1522: x_return_status := fnd_api.g_ret_sts_success;

1518: fnd_msg_pub.initialize;
1519: END IF;
1520:
1521: -- Initialize API return status to success
1522: x_return_status := fnd_api.g_ret_sts_success;
1523: x_loading_status := 'CN_INSERTED';
1524: --Added for R12 payment security check begin.
1525: 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);
1526:

Line 1529: RAISE fnd_api.g_exc_error;

1525: 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);
1526:
1527: IF (l_has_access = FALSE)
1528: THEN
1529: RAISE fnd_api.g_exc_error;
1530: END IF;
1531:
1532: -- API body
1533: -- The following validations are performed by this API

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

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;
1546: END IF;
1547:

Line 1545: RAISE fnd_api.g_exc_error;

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;
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'),

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

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;
1554: END IF;
1555:

Line 1553: RAISE fnd_api.g_exc_error;

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;
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) =

Line 1558: fnd_api.g_true

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

Line 1560: RAISE fnd_api.g_exc_error;

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;
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,

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

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
1569: THEN
1570: RAISE fnd_api.g_exc_error;
1571: END IF;
1572:

Line 1570: RAISE fnd_api.g_exc_error;

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
1569: THEN
1570: RAISE fnd_api.g_exc_error;
1571: END IF;
1572:
1573: -- Get the Payrun
1574: BEGIN

Line 1603: RAISE fnd_api.g_exc_error;

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

Line 1624: RAISE fnd_api.g_exc_error;

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

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

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
1642: THEN
1643: RAISE fnd_api.g_exc_error;
1644: END IF;
1645:

Line 1643: RAISE fnd_api.g_exc_error;

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
1642: THEN
1643: RAISE fnd_api.g_exc_error;
1644: END IF;
1645:
1646: -- get quarter Number and Year Number
1647: OPEN get_prd_statuses(l_get_payrun_rec.pay_period_id);

Line 1736: RAISE fnd_api.g_exc_error;

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

Line 1746: RAISE fnd_api.g_exc_error;

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

Line 1877: RAISE fnd_api.g_exc_error;

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

Line 1902: RAISE fnd_api.g_exc_error;

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

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

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

Line 2028: RAISE fnd_api.g_exc_unexpected_error;

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

Line 2034: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 2044: WHEN fnd_api.g_exc_error THEN

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

Line 2046: x_return_status := fnd_api.g_ret_sts_error;

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

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

Line 2048: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 2051: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

Line 2056: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

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

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

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

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

Line 2100: x_return_status := fnd_api.g_ret_sts_success;

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

Line 2129: p_validation_level => fnd_api.g_valid_level_full,

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

Line 2137: IF x_return_status <> fnd_api.g_ret_sts_success

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

Line 2225: RAISE fnd_api.g_exc_error;

2221: raise_application_error(-20000, errmsg);
2222: END IF;
2223:
2224: IF (l_has_access = FALSE) THEN
2225: RAISE fnd_api.g_exc_error;
2226: END IF;
2227:
2228: --Added for R12 payment security check end.
2229: l_org_id := mo_global.get_current_org_id;

Line 2314: IF l_return_status <> fnd_api.g_ret_sts_success

2310: fnd_file.put_line(fnd_file.log, errbuf);
2311: fnd_file.put_line(fnd_file.log, 'Count of worksheets to be created = ' || salesrep_t.COUNT);
2312: fnd_file.put_line(fnd_file.log, 'Completed create worksheet process....');
2313:
2314: IF l_return_status <> fnd_api.g_ret_sts_success
2315: THEN
2316: retcode := 2;
2317: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2318: fnd_msg_pub.add;

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

2315: THEN
2316: retcode := 2;
2317: fnd_message.set_name('CN', 'CN_CONC_REQ_FAIL');
2318: fnd_msg_pub.add;
2319: errbuf := fnd_msg_pub.get(p_msg_index => fnd_msg_pub.g_last, p_encoded => fnd_api.g_false);
2320: END IF;
2321:
2322: cn_message_pkg.end_batch(l_proc_audit_id);
2323: COMMIT;

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

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

Line 2406: RAISE fnd_api.g_exc_unexpected_error;

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;
2408:
2409: --
2410: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2412: IF fnd_api.to_boolean(p_init_msg_list)

2408:
2409: --
2410: -- Initialize message list if p_init_msg_list is set to TRUE.
2411: --
2412: IF fnd_api.to_boolean(p_init_msg_list)
2413: THEN
2414: fnd_msg_pub.initialize;
2415: END IF;
2416:

Line 2420: x_return_status := fnd_api.g_ret_sts_success;

2416:
2417: --
2418: -- Initialize API return status to success
2419: --
2420: x_return_status := fnd_api.g_ret_sts_success;
2421: x_loading_status := 'CN_UPDATED';
2422:
2423: OPEN get_worksheet_id;
2424:

Line 2439: RAISE fnd_api.g_exc_error;

2435: fnd_message.set_name('CN', 'CN_RECORD_CHANGED');
2436: fnd_msg_pub.add;
2437: END IF;
2438:
2439: RAISE fnd_api.g_exc_error;
2440: END IF;
2441:
2442: l_pay_by_mode := cn_payment_security_pvt.get_pay_by_mode(wksht_rec.payrun_id);
2443:

Line 2475: IF x_return_status <> fnd_api.g_ret_sts_success

2471: x_msg_data => x_msg_data,
2472: p_worksheet_id => p_worksheet_id,
2473: p_action => p_operation);
2474:
2475: IF x_return_status <> fnd_api.g_ret_sts_success
2476: THEN
2477: RAISE fnd_api.g_exc_error;
2478: END IF;
2479:

Line 2477: RAISE fnd_api.g_exc_error;

2473: p_action => p_operation);
2474:
2475: IF x_return_status <> fnd_api.g_ret_sts_success
2476: THEN
2477: RAISE fnd_api.g_exc_error;
2478: END IF;
2479:
2480: -- get sequence number
2481: SELECT cn_posting_batches_s.NEXTVAL

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

3320: -- Populate ccid's in payment worksheets
3321: IF (cn_payrun_pvt.populate_ccids(p_payrun_id => wksht_rec.payrun_id,
3322: p_salesrep_id => wksht_rec.salesrep_id,
3323: p_loading_status => x_loading_status,
3324: x_loading_status => x_loading_status)) = fnd_api.g_true
3325: THEN
3326: RAISE fnd_api.g_exc_unexpected_error;
3327: END IF;
3328: END IF;

Line 3326: RAISE fnd_api.g_exc_unexpected_error;

3322: p_salesrep_id => wksht_rec.salesrep_id,
3323: p_loading_status => x_loading_status,
3324: x_loading_status => x_loading_status)) = fnd_api.g_true
3325: THEN
3326: RAISE fnd_api.g_exc_unexpected_error;
3327: END IF;
3328: END IF;
3329:
3330: ELSIF p_operation IN ('LOCK', 'RELEASE_HOLD')

Line 3342: p_do_audit => fnd_api.g_false);

3338: x_msg_count => x_msg_count,
3339: x_msg_data => x_msg_data,
3340: p_worksheet_id => p_worksheet_id,
3341: p_action => p_operation,
3342: p_do_audit => fnd_api.g_false);
3343:
3344: IF x_return_status <> fnd_api.g_ret_sts_success
3345: THEN
3346: RAISE fnd_api.g_exc_error;

Line 3344: IF x_return_status <> fnd_api.g_ret_sts_success

3340: p_worksheet_id => p_worksheet_id,
3341: p_action => p_operation,
3342: p_do_audit => fnd_api.g_false);
3343:
3344: IF x_return_status <> fnd_api.g_ret_sts_success
3345: THEN
3346: RAISE fnd_api.g_exc_error;
3347: END IF;
3348:

Line 3346: RAISE fnd_api.g_exc_error;

3342: p_do_audit => fnd_api.g_false);
3343:
3344: IF x_return_status <> fnd_api.g_ret_sts_success
3345: THEN
3346: RAISE fnd_api.g_exc_error;
3347: END IF;
3348:
3349: IF p_operation = 'LOCK'
3350: THEN

Line 3359: IF x_return_status <> fnd_api.g_ret_sts_success

3355: x_msg_count => x_msg_count,
3356: x_msg_data => x_msg_data,
3357: p_worksheet_id => p_worksheet_id);
3358:
3359: IF x_return_status <> fnd_api.g_ret_sts_success
3360: THEN
3361: RAISE fnd_api.g_exc_error;
3362: END IF;
3363: ELSIF p_operation = 'RELEASE_HOLD'

Line 3361: RAISE fnd_api.g_exc_error;

3357: p_worksheet_id => p_worksheet_id);
3358:
3359: IF x_return_status <> fnd_api.g_ret_sts_success
3360: THEN
3361: RAISE fnd_api.g_exc_error;
3362: END IF;
3363: ELSIF p_operation = 'RELEASE_HOLD'
3364: THEN
3365:

Line 3376: IF x_return_status <> fnd_api.g_ret_sts_success

3372: x_msg_count => x_msg_count,
3373: x_msg_data => x_msg_data,
3374: p_payment_worksheet_id => p_worksheet_id);
3375:
3376: IF x_return_status <> fnd_api.g_ret_sts_success
3377: THEN
3378: RAISE fnd_api.g_exc_error;
3379: END IF;
3380: END IF;

Line 3378: RAISE fnd_api.g_exc_error;

3374: p_payment_worksheet_id => p_worksheet_id);
3375:
3376: IF x_return_status <> fnd_api.g_ret_sts_success
3377: THEN
3378: RAISE fnd_api.g_exc_error;
3379: END IF;
3380: END IF;
3381:
3382: -- set wksht audit

Line 3391: IF x_return_status <> fnd_api.g_ret_sts_success

3387: x_return_status => x_return_status,
3388: x_msg_count => x_msg_count,
3389: x_msg_data => x_msg_data);
3390:
3391: IF x_return_status <> fnd_api.g_ret_sts_success
3392: THEN
3393: RAISE fnd_api.g_exc_error;
3394: END IF;
3395: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')

Line 3393: RAISE fnd_api.g_exc_error;

3389: x_msg_data => x_msg_data);
3390:
3391: IF x_return_status <> fnd_api.g_ret_sts_success
3392: THEN
3393: RAISE fnd_api.g_exc_error;
3394: END IF;
3395: ELSIF p_operation IN ('UNLOCK', 'SUBMIT')
3396: THEN
3397: -- 'UNLOCK', 'SUBMIT'

Line 3408: IF x_return_status <> fnd_api.g_ret_sts_success

3404: x_msg_data => x_msg_data,
3405: p_worksheet_id => p_worksheet_id,
3406: p_action => p_operation);
3407:
3408: IF x_return_status <> fnd_api.g_ret_sts_success
3409: THEN
3410: RAISE fnd_api.g_exc_error;
3411: END IF;
3412: ELSIF p_operation IN ('APPROVE', 'REJECT')

Line 3410: RAISE fnd_api.g_exc_error;

3406: p_action => p_operation);
3407:
3408: IF x_return_status <> fnd_api.g_ret_sts_success
3409: THEN
3410: RAISE fnd_api.g_exc_error;
3411: END IF;
3412: ELSIF p_operation IN ('APPROVE', 'REJECT')
3413: THEN
3414: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

Line 3423: p_do_audit => fnd_api.g_true);

3419: x_msg_count => x_msg_count,
3420: x_msg_data => x_msg_data,
3421: p_worksheet_id => p_worksheet_id,
3422: p_action => p_operation,
3423: p_do_audit => fnd_api.g_true);
3424:
3425: IF x_return_status <> fnd_api.g_ret_sts_success
3426: THEN
3427: RAISE fnd_api.g_exc_error;

Line 3425: IF x_return_status <> fnd_api.g_ret_sts_success

3421: p_worksheet_id => p_worksheet_id,
3422: p_action => p_operation,
3423: p_do_audit => fnd_api.g_true);
3424:
3425: IF x_return_status <> fnd_api.g_ret_sts_success
3426: THEN
3427: RAISE fnd_api.g_exc_error;
3428: END IF;
3429: ELSIF p_operation IN ('HOLD_ALL', 'RELEASE_ALL', 'RESET_TO_UNPAID')

Line 3427: RAISE fnd_api.g_exc_error;

3423: p_do_audit => fnd_api.g_true);
3424:
3425: IF x_return_status <> fnd_api.g_ret_sts_success
3426: THEN
3427: RAISE fnd_api.g_exc_error;
3428: END IF;
3429: ELSIF p_operation IN ('HOLD_ALL', 'RELEASE_ALL', 'RESET_TO_UNPAID')
3430: THEN
3431: cn_payment_security_pvt.worksheet_action(p_api_version => p_api_version,

Line 3440: p_do_audit => fnd_api.g_true);

3436: x_msg_count => x_msg_count,
3437: x_msg_data => x_msg_data,
3438: p_worksheet_id => p_worksheet_id,
3439: p_action => p_operation,
3440: p_do_audit => fnd_api.g_true);
3441:
3442: IF x_return_status <> fnd_api.g_ret_sts_success
3443: THEN
3444: RAISE fnd_api.g_exc_error;

Line 3442: IF x_return_status <> fnd_api.g_ret_sts_success

3438: p_worksheet_id => p_worksheet_id,
3439: p_action => p_operation,
3440: p_do_audit => fnd_api.g_true);
3441:
3442: IF x_return_status <> fnd_api.g_ret_sts_success
3443: THEN
3444: RAISE fnd_api.g_exc_error;
3445: END IF;
3446: END IF;

Line 3444: RAISE fnd_api.g_exc_error;

3440: p_do_audit => fnd_api.g_true);
3441:
3442: IF x_return_status <> fnd_api.g_ret_sts_success
3443: THEN
3444: RAISE fnd_api.g_exc_error;
3445: END IF;
3446: END IF;
3447:
3448: --Update object_version_number

Line 3466: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 3474: WHEN fnd_api.g_exc_error THEN

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

Line 3476: x_return_status := fnd_api.g_ret_sts_error;

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;
3476: x_return_status := fnd_api.g_ret_sts_error;
3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';

Line 3477: 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;
3476: x_return_status := fnd_api.g_ret_sts_error;
3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3478: WHEN fnd_api.g_exc_unexpected_error THEN

3474: WHEN fnd_api.g_exc_error THEN
3475: ROLLBACK TO update_worksheet;
3476: x_return_status := fnd_api.g_ret_sts_error;
3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;
3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3481: x_return_status := fnd_api.g_ret_sts_unexp_error;

3477: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;
3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3483: WHEN OTHERS THEN
3484: ROLLBACK TO update_worksheet;
3485: x_loading_status := 'UNEXPECTED_ERR';

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

3478: WHEN fnd_api.g_exc_unexpected_error THEN
3479: ROLLBACK TO update_worksheet;
3480: x_loading_status := 'UNEXPECTED_ERR';
3481: x_return_status := fnd_api.g_ret_sts_unexp_error;
3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3483: WHEN OTHERS THEN
3484: ROLLBACK TO update_worksheet;
3485: x_loading_status := 'UNEXPECTED_ERR';
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3486: x_return_status := fnd_api.g_ret_sts_unexp_error;

3482: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3483: WHEN OTHERS THEN
3484: ROLLBACK TO update_worksheet;
3485: x_loading_status := 'UNEXPECTED_ERR';
3486: x_return_status := fnd_api.g_ret_sts_unexp_error;
3487:
3488: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3489: THEN
3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3489: THEN
3490: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3491: END IF;
3492:
3493: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3494: END update_worksheet;
3495:
3496: -- ===========================================================================
3497: -- Procedure : delete_worksheet

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

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;
3544: END IF;
3545:

Line 3543: RAISE fnd_api.g_exc_unexpected_error;

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;
3544: END IF;
3545:
3546: --
3547: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 3549: IF fnd_api.to_boolean(p_init_msg_list)

3545:
3546: --
3547: -- Initialize message list if p_init_msg_list is set to TRUE.
3548: --
3549: IF fnd_api.to_boolean(p_init_msg_list)
3550: THEN
3551: fnd_msg_pub.initialize;
3552: END IF;
3553:

Line 3557: x_return_status := fnd_api.g_ret_sts_success;

3553:
3554: --
3555: -- Initialize API return status to success
3556: --
3557: x_return_status := fnd_api.g_ret_sts_success;
3558: x_loading_status := 'CN_DELETED';
3559:
3560: -- API body
3561: --R12 for OA. When p_validation_only = 'Y', only do validation for delete from OA.

Line 3575: p_do_audit => fnd_api.g_false);

3571: x_msg_count => x_msg_count,
3572: x_msg_data => x_msg_data,
3573: p_worksheet_id => p_worksheet_id,
3574: p_action => 'REMOVE',
3575: p_do_audit => fnd_api.g_false);
3576:
3577: IF x_return_status <> fnd_api.g_ret_sts_success
3578: THEN
3579: RAISE fnd_api.g_exc_error;

Line 3577: IF x_return_status <> fnd_api.g_ret_sts_success

3573: p_worksheet_id => p_worksheet_id,
3574: p_action => 'REMOVE',
3575: p_do_audit => fnd_api.g_false);
3576:
3577: IF x_return_status <> fnd_api.g_ret_sts_success
3578: THEN
3579: RAISE fnd_api.g_exc_error;
3580: END IF;
3581:

Line 3579: RAISE fnd_api.g_exc_error;

3575: p_do_audit => fnd_api.g_false);
3576:
3577: IF x_return_status <> fnd_api.g_ret_sts_success
3578: THEN
3579: RAISE fnd_api.g_exc_error;
3580: END IF;
3581:
3582: --R12
3583: EXIT WHEN l_validation_only = 'Y';

Line 3657: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 3667: WHEN fnd_api.g_exc_error THEN

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

Line 3669: x_return_status := fnd_api.g_ret_sts_error;

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
3668: ROLLBACK TO delete_worksheet;
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';

Line 3670: 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
3668: ROLLBACK TO delete_worksheet;
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3671: WHEN fnd_api.g_exc_unexpected_error THEN

3667: WHEN fnd_api.g_exc_error THEN
3668: ROLLBACK TO delete_worksheet;
3669: x_return_status := fnd_api.g_ret_sts_error;
3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3674: x_return_status := fnd_api.g_ret_sts_unexp_error;

3670: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3676: WHEN OTHERS THEN
3677: ROLLBACK TO delete_worksheet;
3678: x_loading_status := 'UNEXPECTED_ERR';

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

3671: WHEN fnd_api.g_exc_unexpected_error THEN
3672: ROLLBACK TO delete_worksheet;
3673: x_loading_status := 'UNEXPECTED_ERR';
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;
3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3676: WHEN OTHERS THEN
3677: ROLLBACK TO delete_worksheet;
3678: x_loading_status := 'UNEXPECTED_ERR';
3679: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3679: x_return_status := fnd_api.g_ret_sts_unexp_error;

3675: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3676: WHEN OTHERS THEN
3677: ROLLBACK TO delete_worksheet;
3678: x_loading_status := 'UNEXPECTED_ERR';
3679: x_return_status := fnd_api.g_ret_sts_unexp_error;
3680:
3681: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3682: THEN
3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3682: THEN
3683: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3684: END IF;
3685:
3686: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3687: END delete_worksheet;
3688:
3689:
3690: PROCEDURE get_ced_and_bb

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

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

Line 3733: RAISE fnd_api.g_exc_unexpected_error;

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

Line 3737: IF fnd_api.to_boolean(p_init_msg_list)

3733: RAISE fnd_api.g_exc_unexpected_error;
3734: END IF;
3735:
3736: -- Initialize message list if p_init_msg_list is set to TRUE.
3737: IF fnd_api.to_boolean(p_init_msg_list)
3738: THEN
3739: fnd_msg_pub.initialize;
3740: END IF;
3741:

Line 3743: x_return_status := fnd_api.g_ret_sts_success;

3739: fnd_msg_pub.initialize;
3740: END IF;
3741:
3742: -- Initialize API return status to success
3743: x_return_status := fnd_api.g_ret_sts_success;
3744: -- API Body
3745: x_curr_earnings := 0;
3746: x_curr_earnings_due := 0;
3747: x_bb_prior_period_adj := 0;

Line 3765: RAISE fnd_api.g_exc_error;

3761: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3762: fnd_msg_pub.add;
3763: END IF;
3764:
3765: RAISE fnd_api.g_exc_error;
3766: END IF;
3767:
3768: CLOSE c_wksht_csr;
3769:

Line 3848: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 3857: WHEN fnd_api.g_exc_error THEN

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

Line 3859: x_return_status := fnd_api.g_ret_sts_error;

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;
3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3860: 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;
3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 3861: WHEN fnd_api.g_exc_unexpected_error THEN

3857: WHEN fnd_api.g_exc_error THEN
3858: ROLLBACK TO get_ced_and_bb;
3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3865: WHEN OTHERS THEN

Line 3863: x_return_status := fnd_api.g_ret_sts_unexp_error;

3859: x_return_status := fnd_api.g_ret_sts_error;
3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3865: WHEN OTHERS THEN
3866: ROLLBACK TO get_ced_and_bb;
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

3860: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3861: WHEN fnd_api.g_exc_unexpected_error THEN
3862: ROLLBACK TO get_ced_and_bb;
3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3865: WHEN OTHERS THEN
3866: ROLLBACK TO get_ced_and_bb;
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:

Line 3867: x_return_status := fnd_api.g_ret_sts_unexp_error;

3863: x_return_status := fnd_api.g_ret_sts_unexp_error;
3864: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3865: WHEN OTHERS THEN
3866: ROLLBACK TO get_ced_and_bb;
3867: x_return_status := fnd_api.g_ret_sts_unexp_error;
3868:
3869: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
3870: THEN
3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

3870: THEN
3871: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
3872: END IF;
3873:
3874: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
3875: END get_ced_and_bb;
3876:
3877: --============================================================================
3878: --Name :set_ced_and_bb

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

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

Line 3939: RAISE fnd_api.g_exc_unexpected_error;

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

Line 3943: IF fnd_api.to_boolean(p_init_msg_list)

3939: RAISE fnd_api.g_exc_unexpected_error;
3940: END IF;
3941:
3942: -- Initialize message list if p_init_msg_list is set to TRUE.
3943: IF fnd_api.to_boolean(p_init_msg_list)
3944: THEN
3945: fnd_msg_pub.initialize;
3946: END IF;
3947:

Line 3949: x_return_status := fnd_api.g_ret_sts_success;

3945: fnd_msg_pub.initialize;
3946: END IF;
3947:
3948: -- Initialize API return status to success
3949: x_return_status := fnd_api.g_ret_sts_success;
3950:
3951: -- API Body
3952: -- Get the Status Info
3953: OPEN c_status_csr;

Line 3966: RAISE fnd_api.g_exc_error;

3962: fnd_message.set_name('CN', 'CN_WKSHT_DOES_NOT_EXIST');
3963: fnd_msg_pub.add;
3964: END IF;
3965:
3966: RAISE fnd_api.g_exc_error;
3967: END IF;
3968:
3969: CLOSE c_status_csr;
3970:

Line 4036: IF fnd_api.to_boolean(p_commit)

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

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

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

Line 4045: WHEN fnd_api.g_exc_error THEN

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

Line 4047: x_return_status := fnd_api.g_ret_sts_error;

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;
4047: x_return_status := fnd_api.g_ret_sts_error;
4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4048: 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;
4047: x_return_status := fnd_api.g_ret_sts_error;
4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);

Line 4049: WHEN fnd_api.g_exc_unexpected_error THEN

4045: WHEN fnd_api.g_exc_error THEN
4046: ROLLBACK TO set_ced_and_bb;
4047: x_return_status := fnd_api.g_ret_sts_error;
4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4053: WHEN OTHERS THEN

Line 4051: x_return_status := fnd_api.g_ret_sts_unexp_error;

4047: x_return_status := fnd_api.g_ret_sts_error;
4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4053: WHEN OTHERS THEN
4054: ROLLBACK TO set_ced_and_bb;
4055: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

4048: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4049: WHEN fnd_api.g_exc_unexpected_error THEN
4050: ROLLBACK TO set_ced_and_bb;
4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4053: WHEN OTHERS THEN
4054: ROLLBACK TO set_ced_and_bb;
4055: x_return_status := fnd_api.g_ret_sts_unexp_error;
4056:

Line 4055: x_return_status := fnd_api.g_ret_sts_unexp_error;

4051: x_return_status := fnd_api.g_ret_sts_unexp_error;
4052: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4053: WHEN OTHERS THEN
4054: ROLLBACK TO set_ced_and_bb;
4055: x_return_status := fnd_api.g_ret_sts_unexp_error;
4056:
4057: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
4058: THEN
4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

4058: THEN
4059: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
4060: END IF;
4061:
4062: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false);
4063: END set_ced_and_bb;
4064:
4065:
4066:

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

4409: p_logical_batch_id IN NUMBER,
4410: --R12
4411: p_org_id IN cn_payruns.org_id%TYPE
4412: ) IS
4413: x_return_status VARCHAR2(10) := fnd_api.g_ret_sts_success;
4414: x_msg_count NUMBER;
4415: x_msg_data VARCHAR2(4000);
4416: l_worksheet_rec cn_payment_worksheet_pvt.worksheet_rec_type;
4417: x_status VARCHAR2(200);

Line 4452: p_validation_level => fnd_api.g_valid_level_full,

4448:
4449: cn_payment_worksheet_pvt.update_worksheet(p_api_version => 1.0,
4450: p_init_msg_list => 'T',
4451: p_commit => 'F',
4452: p_validation_level => fnd_api.g_valid_level_full,
4453: x_return_status => x_return_status,
4454: x_msg_count => x_msg_count,
4455: x_msg_data => x_msg_data,
4456: p_worksheet_id => l_worksheet_rec.worksheet_id,

Line 4465: IF x_return_status <> fnd_api.g_ret_sts_success

4461: );
4462:
4463: END LOOP;
4464:
4465: IF x_return_status <> fnd_api.g_ret_sts_success
4466: THEN
4467: l_error_count := l_error_count + 1;
4468:
4469: --ROLLBACK TO create_single_worksheet;