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_CALC_ROLLUP_PVT dependencies on FND_API

Line 189: l_return_status := fnd_api.g_ret_sts_success;

185: , x_msg_data => l_msg_data
186: , p_srp_trx => l_srp_trx
187: , x_validation_status => l_validation_status );
188: ELSE
189: l_return_status := fnd_api.g_ret_sts_success;
190: l_validation_status := 'Y';
191: END IF;
192:
193: l_pending_status := 'Y';

Line 195: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN

191: END IF;
192:
193: l_pending_status := 'Y';
194:
195: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN
196: IF ( l_validation_status = 'Y' ) THEN
197: l_pending_status := 'N';
198: END IF;
199: ELSE

Line 1145: IF l_return_status <> fnd_api.g_ret_sts_success THEN

1141: , p_org_id => g_org_id
1142: , p_srp => l_srp_group
1143: , x_srp => l_srp_group_ancestor );
1144:
1145: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1146: UPDATE cn_commission_headers_all
1147: SET status = 'XROLL'
1148: , last_update_date = sysdate
1149: , last_updated_by = g_last_updated_by

Line 1157: RAISE fnd_api.g_exc_unexpected_error;

1153: DELETE FROM cn_commission_lines_all
1154: WHERE commission_header_id = eachtrx.commission_header_id;
1155:
1156: l_prev_status := 'XROLL';
1157: RAISE fnd_api.g_exc_unexpected_error;
1158: END IF; -- end of check api return status
1159: END IF; -- end of check of whether to call API again
1160:
1161: IF ( l_iteration_count < 2 ) THEN

Line 1292: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN

1288: , p_srp_trx => l_srp_trx
1289: , x_validation_status => l_validation_status );
1290: l_pending_status := 'Y';
1291:
1292: IF ( l_return_status = fnd_api.g_ret_sts_success ) THEN
1293: IF ( l_validation_status = 'Y' ) THEN
1294: l_pending_status := 'N';
1295:
1296: UPDATE cn_commission_lines_all

Line 1329: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)

1325: --
1326: --
1327: -- Parameters :
1328: -- IN : p_api_version NUMBER Require
1329: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1330: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1331: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1332: -- OUT : x_return_status VARCHAR2(1)
1333: -- x_msg_count NUMBER

Line 1330: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)

1326: --
1327: -- Parameters :
1328: -- IN : p_api_version NUMBER Require
1329: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1330: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1331: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1332: -- OUT : x_return_status VARCHAR2(1)
1333: -- x_msg_count NUMBER
1334: -- x_msg_data VARCHAR2(2000)

Line 1331: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)

1327: -- Parameters :
1328: -- IN : p_api_version NUMBER Require
1329: -- p_init_msg_list VARCHAR2 Optional (FND_API.G_FALSE)
1330: -- p_commit VARCHAR2 Optional (FND_API.G_FALSE)
1331: -- p_validation_level NUMBER Optional (FND_API.G_VALID_LEVEL_FULL)
1332: -- OUT : x_return_status VARCHAR2(1)
1333: -- x_msg_count NUMBER
1334: -- x_msg_data VARCHAR2(2000)
1335: -- IN : p_physical_batch_id NUMBER(15) Require

Line 1348: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false

1344: --
1345: -- End of comments
1346: PROCEDURE rollup_batch(
1347: p_api_version IN NUMBER
1348: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1349: , p_commit IN VARCHAR2 := fnd_api.g_false
1350: , p_validation_level IN VARCHAR2 := fnd_api.g_valid_level_full
1351: , x_return_status OUT NOCOPY VARCHAR2
1352: , x_msg_count OUT NOCOPY NUMBER

Line 1349: , p_commit IN VARCHAR2 := fnd_api.g_false

1345: -- End of comments
1346: PROCEDURE rollup_batch(
1347: p_api_version IN NUMBER
1348: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1349: , p_commit IN VARCHAR2 := fnd_api.g_false
1350: , p_validation_level IN VARCHAR2 := fnd_api.g_valid_level_full
1351: , x_return_status OUT NOCOPY VARCHAR2
1352: , x_msg_count OUT NOCOPY NUMBER
1353: , x_msg_data OUT NOCOPY VARCHAR2

Line 1350: , p_validation_level IN VARCHAR2 := fnd_api.g_valid_level_full

1346: PROCEDURE rollup_batch(
1347: p_api_version IN NUMBER
1348: , p_init_msg_list IN VARCHAR2 := fnd_api.g_false
1349: , p_commit IN VARCHAR2 := fnd_api.g_false
1350: , p_validation_level IN VARCHAR2 := fnd_api.g_valid_level_full
1351: , x_return_status OUT NOCOPY VARCHAR2
1352: , x_msg_count OUT NOCOPY NUMBER
1353: , x_msg_data OUT NOCOPY VARCHAR2
1354: , p_physical_batch_id IN NUMBER

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

1389: -- Standard Start of API savepoint
1390: SAVEPOINT rollup_batch;
1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396:
1397: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1394: RAISE fnd_api.g_exc_unexpected_error;

1390: SAVEPOINT rollup_batch;
1391:
1392: -- Standard call to check for call compatibility.
1393: IF NOT fnd_api.compatible_api_call( l_api_version, p_api_version, l_api_name, g_pkg_name ) THEN
1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396:
1397: -- Initialize message list if p_init_msg_list is set to TRUE.
1398: IF fnd_api.to_boolean( p_init_msg_list ) THEN

Line 1398: IF fnd_api.to_boolean( p_init_msg_list ) THEN

1394: RAISE fnd_api.g_exc_unexpected_error;
1395: END IF;
1396:
1397: -- Initialize message list if p_init_msg_list is set to TRUE.
1398: IF fnd_api.to_boolean( p_init_msg_list ) THEN
1399: fnd_msg_pub.initialize;
1400: END IF;
1401:
1402: -- Initialize API return status to success

Line 1403: x_return_status := fnd_api.g_ret_sts_success;

1399: fnd_msg_pub.initialize;
1400: END IF;
1401:
1402: -- Initialize API return status to success
1403: x_return_status := fnd_api.g_ret_sts_success;
1404:
1405: -- Codes start here
1406: SELECT org_id
1407: INTO g_org_id

Line 1520: IF fnd_api.to_boolean( p_commit ) THEN

1516: revalidation( p_physical_batch_id );
1517: END IF;
1518:
1519: -- Standard check of p_commit.
1520: IF fnd_api.to_boolean( p_commit ) THEN
1521: COMMIT WORK;
1522: END IF;
1523:
1524: -- Standard call to get message count and if count is 1, get message info.

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

1521: COMMIT WORK;
1522: END IF;
1523:
1524: -- Standard call to get message count and if count is 1, get message info.
1525: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: ROLLBACK TO rollup_batch;
1529: x_return_status := fnd_api.g_ret_sts_error;

Line 1527: WHEN fnd_api.g_exc_error THEN

1523:
1524: -- Standard call to get message count and if count is 1, get message info.
1525: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: ROLLBACK TO rollup_batch;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1529: x_return_status := fnd_api.g_ret_sts_error;

1525: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: ROLLBACK TO rollup_batch;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN
1532: ROLLBACK TO rollup_batch;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1526: EXCEPTION
1527: WHEN fnd_api.g_exc_error THEN
1528: ROLLBACK TO rollup_batch;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN
1532: ROLLBACK TO rollup_batch;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );

Line 1531: WHEN fnd_api.g_exc_unexpected_error THEN

1527: WHEN fnd_api.g_exc_error THEN
1528: ROLLBACK TO rollup_batch;
1529: x_return_status := fnd_api.g_ret_sts_error;
1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN
1532: ROLLBACK TO rollup_batch;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1535: WHEN OTHERS THEN

Line 1533: x_return_status := fnd_api.g_ret_sts_unexp_error;

1529: x_return_status := fnd_api.g_ret_sts_error;
1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN
1532: ROLLBACK TO rollup_batch;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1535: WHEN OTHERS THEN
1536: ROLLBACK TO rollup_batch;
1537: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

1530: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1531: WHEN fnd_api.g_exc_unexpected_error THEN
1532: ROLLBACK TO rollup_batch;
1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1535: WHEN OTHERS THEN
1536: ROLLBACK TO rollup_batch;
1537: x_return_status := fnd_api.g_ret_sts_unexp_error;
1538:

Line 1537: x_return_status := fnd_api.g_ret_sts_unexp_error;

1533: x_return_status := fnd_api.g_ret_sts_unexp_error;
1534: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1535: WHEN OTHERS THEN
1536: ROLLBACK TO rollup_batch;
1537: x_return_status := fnd_api.g_ret_sts_unexp_error;
1538:
1539: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
1540: fnd_msg_pub.add_exc_msg( g_pkg_name, l_api_name );
1541: END IF;

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

1539: IF fnd_msg_pub.check_msg_level( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
1540: fnd_msg_pub.add_exc_msg( g_pkg_name, l_api_name );
1541: END IF;
1542:
1543: fnd_msg_pub.count_and_get( p_count => x_msg_count, p_data => x_msg_data, p_encoded => fnd_api.g_false );
1544:
1545: IF ( fnd_log.level_unexpected >= fnd_log.g_current_runtime_level ) THEN
1546: fnd_log.STRING( fnd_log.level_unexpected, 'cn.plsql.cn_calc_rollup_pvt.rollup_batch.exception', SQLERRM );
1547: END IF;