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.OZF_QUOTA_PUB dependencies on OZF_UTILITY_PVT

Line 223: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

219:
220: BEGIN
221:
222: IF G_DEBUG THEN
223: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
224: END IF;
225:
226: IF p_mode = 'CREATE'
227: THEN

Line 664: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

660: p_fund_rec.threshold_id := p_quota_rec.threshold_id;
661: p_fund_rec.product_spread_time_id := p_quota_rec.product_spread_time_id;
662:
663: IF G_DEBUG THEN
664: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
665: END IF;
666:
667: END validate_quota_attributes;
668:

Line 686: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

682: l_act_product_rec AMS_ActProduct_PVT.act_Product_rec_type ;
683:
684: BEGIN
685: IF G_DEBUG THEN
686: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
687: END IF;
688:
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:

Line 743: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

739:
740: x_act_product_rec := l_act_product_rec;
741:
742: IF G_DEBUG THEN
743: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
744: END IF;
745:
746: EXCEPTION
747:

Line 814: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

810: BEGIN
811:
812: -- Initialize API return status to success
813: IF G_DEBUG THEN
814: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
815: END IF;
816:
817: x_return_status := FND_API.G_RET_STS_SUCCESS;
818:

Line 850: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);

846: ,x_fund_id => x_quota_id
847: );
848:
849: IF G_DEBUG THEN
850: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);
851: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);
852: END IF;
853:
854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 851: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);

847: );
848:
849: IF G_DEBUG THEN
850: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);
851: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);
852: END IF;
853:
854: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
855: RAISE FND_API.G_EXC_ERROR;

Line 927: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

923: --
924: END LOOP;
925:
926: IF G_DEBUG THEN
927: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
928: END IF;
929:
930: EXCEPTION
931: WHEN FND_API.G_EXC_ERROR THEN

Line 1050: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

1046: AND lookup_code = p_method_code;
1047:
1048: BEGIN
1049: IF G_DEBUG THEN
1050: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
1051: END IF;
1052:
1053: --if both quota id and quota number are null, then raise exception
1054: IF (p_alloc_rec.quota_id = fnd_api.g_miss_num OR p_alloc_rec.quota_id IS NULL) AND

Line 1303: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

1299: FETCH c_product_spread INTO p_alloc_rec.product_spread_time_id;
1300: CLOSE c_product_spread;
1301:
1302: IF G_DEBUG THEN
1303: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
1304: END IF;
1305:
1306: END validate_alloc_attributes;
1307:

Line 1328: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');

1324: l_product_alloc_id number := -1;
1325:
1326: BEGIN
1327:
1328: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');
1329:
1330: OPEN product_seq_csr;
1331: FETCH product_seq_csr INTO l_product_alloc_id;
1332: CLOSE product_seq_csr;

Line 1351: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

1347: return l_product_alloc_id;
1348:
1349: EXCEPTION
1350: WHEN OTHERS THEN
1351: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
1352: END get_product_allocation_id;
1353:
1354: FUNCTION get_time_allocation_id
1355: RETURN NUMBER IS

Line 1374: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');

1370: l_time_alloc_id number := -1;
1371:
1372: BEGIN
1373:
1374: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');
1375:
1376: OPEN time_seq_csr;
1377: FETCH time_seq_csr INTO l_time_alloc_id;
1378: CLOSE time_seq_csr;

Line 1397: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

1393: return l_time_alloc_id;
1394:
1395: EXCEPTION
1396: WHEN OTHERS THEN
1397: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
1398: END get_time_allocation_id;
1399:
1400: FUNCTION get_account_allocation_id
1401: RETURN NUMBER IS

Line 1420: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');

1416: l_account_alloc_id number := -1;
1417:
1418: BEGIN
1419:
1420: --OZF_UTILITY_PVT.debug_message('Private API: ' || l_full_api_name || ' -- start');
1421:
1422: OPEN account_seq_csr;
1423: FETCH account_seq_csr INTO l_account_alloc_id;
1424: CLOSE account_seq_csr;

Line 1443: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

1439: return l_account_alloc_id;
1440:
1441: EXCEPTION
1442: WHEN OTHERS THEN
1443: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
1444: END get_account_allocation_id;
1445:
1446: -- This procedure can be called to create product allocations
1447: -- to a Quota or an Account

Line 1469: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

1465:
1466: BEGIN
1467:
1468: IF G_DEBUG THEN
1469: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
1470: END IF;
1471:
1472: x_return_status := FND_API.G_RET_STS_SUCCESS;
1473:

Line 1519: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

1515: x_product_allocation_Id := l_product_allocation_id;
1516: x_return_status := FND_API.G_RET_STS_SUCCESS;
1517:
1518: IF G_DEBUG THEN
1519: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
1520: END IF;
1521:
1522: EXCEPTION
1523: WHEN OTHERS THEN

Line 1552: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

1548:
1549: BEGIN
1550:
1551: IF G_DEBUG THEN
1552: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
1553: END IF;
1554:
1555: x_return_status := FND_API.G_RET_STS_SUCCESS;
1556:

Line 1608: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

1604: x_account_allocation_Id := l_account_allocation_id;
1605: x_return_status := FND_API.G_RET_STS_SUCCESS;
1606:
1607: IF G_DEBUG THEN
1608: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
1609: END IF;
1610:
1611: EXCEPTION
1612: WHEN OTHERS THEN

Line 1642: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);

1638: l_object_version_number NUMBER := 1;
1639:
1640: BEGIN
1641: IF G_DEBUG THEN
1642: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name);
1643: END IF;
1644:
1645: x_return_status := FND_API.G_RET_STS_SUCCESS;
1646:

Line 1689: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);

1685: x_time_allocation_Id := l_time_allocation_id;
1686: x_return_status := FND_API.G_RET_STS_SUCCESS;
1687:
1688: IF G_DEBUG THEN
1689: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name);
1690: END IF;
1691:
1692: EXCEPTION
1693:

Line 1735: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );

1731: --
1732: SAVEPOINT CREATE_QUOTA_PRODUCT_SPREAD;
1733:
1734: IF G_DEBUG THEN
1735: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );
1736: END IF;
1737:
1738: -- Initialize API return status to success
1739: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1866: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );

1862: END LOOP; -- Product counter
1863: --
1864:
1865: IF G_DEBUG THEN
1866: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );
1867: END IF;
1868:
1869: FND_MSG_PUB.Count_And_Get (
1870: p_encoded => FND_API.G_FALSE,

Line 2277: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );

2273:
2274: SAVEPOINT create_quota;
2275:
2276: IF G_DEBUG THEN
2277: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );
2278: END IF;
2279:
2280: -- First Validate p_method ---------------------------------------------------
2281: -- Default is 'MANUAL'

Line 2327: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);

2323: ,p_quota_products_tbl => l_quota_products_tbl
2324: ,x_quota_id => x_quota_id );
2325:
2326: IF G_DEBUG THEN
2327: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);
2328: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);
2329: END IF;
2330:
2331: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

Line 2328: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);

2324: ,x_quota_id => x_quota_id );
2325:
2326: IF G_DEBUG THEN
2327: ozf_utility_pvt.debug_message('Quota ID: ' || x_quota_id);
2328: ozf_utility_pvt.debug_message('Return Status: ' || x_return_status);
2329: END IF;
2330:
2331: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
2332: RAISE FND_API.g_exc_unexpected_error;

Line 2445: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );

2441: END IF;
2442:
2443:
2444: IF G_DEBUG THEN
2445: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );
2446: END IF;
2447:
2448: FND_MSG_PUB.Count_And_Get (
2449: p_encoded => FND_API.G_FALSE,

Line 2562: ozf_utility_pvt.debug_message(l_api_name || ': l_quota_id :' || l_quota_id);

2558: CLOSE c_quota_id;
2559: END IF;
2560:
2561: IF G_DEBUG THEN
2562: ozf_utility_pvt.debug_message(l_api_name || ': l_quota_id :' || l_quota_id);
2563: END IF;
2564:
2565: IF l_quota_id IS NOT NULL THEN
2566: OPEN c_quota_details (l_quota_id);

Line 2575: ozf_utility_pvt.debug_message(l_api_name || ': l_quota_amount :' || l_quota_amount);

2571: CLOSE c_quota_details;
2572: END IF;
2573:
2574: IF G_DEBUG THEN
2575: ozf_utility_pvt.debug_message(l_api_name || ': l_quota_amount :' || l_quota_amount);
2576: ozf_utility_pvt.debug_message(l_api_name || ': l_product_spread_time_id :' || l_product_spread_time_id);
2577: END IF;
2578:
2579: l_quota_rec.quota_number := NVL(l_quota_rec.quota_number,l_quota_number);

Line 2576: ozf_utility_pvt.debug_message(l_api_name || ': l_product_spread_time_id :' || l_product_spread_time_id);

2572: END IF;
2573:
2574: IF G_DEBUG THEN
2575: ozf_utility_pvt.debug_message(l_api_name || ': l_quota_amount :' || l_quota_amount);
2576: ozf_utility_pvt.debug_message(l_api_name || ': l_product_spread_time_id :' || l_product_spread_time_id);
2577: END IF;
2578:
2579: l_quota_rec.quota_number := NVL(l_quota_rec.quota_number,l_quota_number);
2580: l_quota_rec.short_name := NVL(l_quota_rec.short_name,l_short_name);

Line 2719: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );

2715: --
2716: SAVEPOINT UPDATE_QUOTA_PRODUCT_SPREAD;
2717:
2718: IF G_DEBUG THEN
2719: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );
2720: END IF;
2721:
2722: -- Initialize API return status to success
2723: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2805: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );

2801: END IF;
2802: ---------------------------------------------
2803:
2804: IF G_DEBUG THEN
2805: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );
2806: END IF;
2807:
2808: FND_MSG_PUB.Count_And_Get (
2809: p_encoded => FND_API.G_FALSE,

Line 2880: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );

2876: --
2877: SAVEPOINT UPDATE_QUOTA_ACCOUNT_SPREAD;
2878:
2879: IF G_DEBUG THEN
2880: ozf_utility_pvt.debug_message('Start Procedure: '|| l_api_name );
2881: END IF;
2882:
2883: -- Initialize API return status to success
2884: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2966: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );

2962: END IF;
2963: ---------------------------------------------
2964:
2965: IF G_DEBUG THEN
2966: ozf_utility_pvt.debug_message('End Procedure: '|| l_api_name );
2967: END IF;
2968:
2969: FND_MSG_PUB.Count_And_Get (
2970: p_encoded => FND_API.G_FALSE,