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_ALLOCATION_ENGINE_PVT dependencies on FND_MSG_PUB

Line 6: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

2: /* $Header: ozfvaegb.pls 120.9 2008/12/22 09:23:30 psomyaju ship $ */
3: -- g_version CONSTANT CHAR(80) := '$Header: ozfvaegb.pls 120.9 2008/12/22 09:23:30 psomyaju ship $';
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_ALLOCATION_ENGINE_PVT';
5:
6: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
10:

Line 7: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

3: -- g_version CONSTANT CHAR(80) := '$Header: ozfvaegb.pls 120.9 2008/12/22 09:23:30 psomyaju ship $';
4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_ALLOCATION_ENGINE_PVT';
5:
6: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
10:
11: g_phase VARCHAR2(500);

Line 8: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);

4: g_pkg_name CONSTANT VARCHAR2(30):='OZF_ALLOCATION_ENGINE_PVT';
5:
6: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
10:
11: g_phase VARCHAR2(500);
12: g_user_id NUMBER;

Line 9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

5:
6: OZF_DEBUG_HIGH_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
7: OZF_DEBUG_MEDIUM_ON CONSTANT BOOLEAN := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
8: OZF_DEBUG_LOW_ON CONSTANT BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_low);
9: G_DEBUG_LEVEL BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
10:
11: g_phase VARCHAR2(500);
12: g_user_id NUMBER;
13: g_login_id NUMBER;

Line 730: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

726: RETURNING t.allocation_for_id INTO l_temp_product_allocation_id;
727:
728:
729: IF (SQL%NOTFOUND) THEN
730: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
731: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
732: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
733: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
734: fnd_msg_pub.ADD;

Line 734: fnd_msg_pub.ADD;

730: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
731: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
732: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
733: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
734: fnd_msg_pub.ADD;
735: END IF;
736: RAISE fnd_api.g_exc_unexpected_error;
737: END IF;
738:

Line 748: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

744: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
745: WHERE p.product_allocation_id = l_temp_product_allocation_id;
746:
747: IF (SQL%NOTFOUND) THEN
748: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
749: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
750: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
751: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
752: fnd_msg_pub.ADD;

Line 752: fnd_msg_pub.ADD;

748: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
749: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
750: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
751: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
752: fnd_msg_pub.ADD;
753: END IF;
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;
756:

Line 775: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

771: );
772:
773:
774: IF (SQL%NOTFOUND) THEN
775: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
776: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
777: fnd_msg_pub.ADD;
778: END IF;
779: RAISE fnd_api.g_exc_unexpected_error;

Line 777: fnd_msg_pub.ADD;

773:
774: IF (SQL%NOTFOUND) THEN
775: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
776: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
777: fnd_msg_pub.ADD;
778: END IF;
779: RAISE fnd_api.g_exc_unexpected_error;
780: END IF;
781:

Line 793: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

789: AND p.allocation_for_id = l_account_allocation_id
790: AND p.item_id = -9999;
791:
792: IF (SQL%NOTFOUND) THEN
793: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
794: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
795: fnd_msg_pub.ADD;
796: END IF;
797: RAISE fnd_api.g_exc_unexpected_error;

Line 795: fnd_msg_pub.ADD;

791:
792: IF (SQL%NOTFOUND) THEN
793: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
794: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
795: fnd_msg_pub.ADD;
796: END IF;
797: RAISE fnd_api.g_exc_unexpected_error;
798: END IF;
799: ---------------------------------------------------------------------------------------------------

Line 1099: FND_MSG_PUB.initialize;

1095: END IF;
1096:
1097: -- Initialize message list if p_init_msg_list is set to TRUE.
1098: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1099: FND_MSG_PUB.initialize;
1100: END IF;
1101:
1102: -- Initialize API return status to SUCCESS
1103: x_return_status := FND_API.g_ret_sts_success;

Line 1431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1427: AND p.item_id = -9999 )
1428: );
1429:
1430: IF (SQL%NOTFOUND) THEN
1431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1432: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
1433: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1434: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1435: fnd_msg_pub.ADD;

Line 1435: fnd_msg_pub.ADD;

1431: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1432: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
1433: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1434: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1435: fnd_msg_pub.ADD;
1436: END IF;
1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;
1439:

Line 1452: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

1448: AND p.allocation_for_id = l_fact_id
1449: AND p.item_id = -9999;
1450:
1451: IF (SQL%NOTFOUND) THEN
1452: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1453: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
1454: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1455: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1456: fnd_msg_pub.ADD;

Line 1456: fnd_msg_pub.ADD;

1452: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1453: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
1454: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1455: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1456: fnd_msg_pub.ADD;
1457: END IF;
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;
1460:

Line 1476: FND_MSG_PUB.add;

1472: EXCEPTION
1473: WHEN OZF_TP_DIFF_TIME_SPREAD THEN
1474: ROLLBACK TO create_old_fact_product_spread;
1475: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
1476: FND_MSG_PUB.add;
1477: x_return_status := FND_API.g_ret_sts_error ;
1478: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1479: p_data => x_error_message);
1480: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));

Line 1478: FND_MSG_PUB.count_and_get (p_count => x_error_number,

1474: ROLLBACK TO create_old_fact_product_spread;
1475: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
1476: FND_MSG_PUB.add;
1477: x_return_status := FND_API.g_ret_sts_error ;
1478: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1479: p_data => x_error_message);
1480: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));
1481: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
1482:

Line 1486: FND_MSG_PUB.add;

1482:
1483: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
1484: ROLLBACK TO create_old_fact_product_spread;
1485: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
1486: FND_MSG_PUB.add;
1487: x_return_status := FND_API.g_ret_sts_error ;
1488: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1489: p_data => x_error_message);
1490: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));

Line 1488: FND_MSG_PUB.count_and_get (p_count => x_error_number,

1484: ROLLBACK TO create_old_fact_product_spread;
1485: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
1486: FND_MSG_PUB.add;
1487: x_return_status := FND_API.g_ret_sts_error ;
1488: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1489: p_data => x_error_message);
1490: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
1491: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
1492:

Line 1496: FND_MSG_PUB.count_and_get (p_count => x_error_number,

1492:
1493: WHEN FND_API.G_EXC_ERROR THEN
1494: ROLLBACK TO create_old_fact_product_spread;
1495: x_return_status := FND_API.g_ret_sts_error ;
1496: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1497: p_data => x_error_message);
1498:
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: ROLLBACK TO create_old_fact_product_spread;

Line 1502: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

1498:
1499: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1500: ROLLBACK TO create_old_fact_product_spread;
1501: x_return_status := FND_API.g_ret_sts_unexp_error ;
1502: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
1503: p_data => x_error_message);
1504:
1505: WHEN OTHERS THEN
1506: ROLLBACK TO create_old_fact_product_spread;

Line 1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1504:
1505: WHEN OTHERS THEN
1506: ROLLBACK TO create_old_fact_product_spread;
1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1509: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
1510: END IF;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
1512: p_data => x_error_message);

Line 1509: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

1505: WHEN OTHERS THEN
1506: ROLLBACK TO create_old_fact_product_spread;
1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1509: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
1510: END IF;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
1512: p_data => x_error_message);
1513: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 1511: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

1507: x_return_status := FND_API.g_ret_sts_unexp_error ;
1508: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1509: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
1510: END IF;
1511: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
1512: p_data => x_error_message);
1513: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
1514:
1515: END create_old_fact_product_spread;

Line 1810: FND_MSG_PUB.initialize;

1806: END IF;
1807:
1808: -- Initialize message list if p_init_msg_list is set to TRUE.
1809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1810: FND_MSG_PUB.initialize;
1811: END IF;
1812:
1813: -- Initialize API return status to SUCCESS
1814: x_return_status := FND_API.g_ret_sts_success;

Line 2141: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2137: WHERE p.allocation_for = 'FACT'
2138: AND p.allocation_for_id = l_fact_id );
2139:
2140: IF (SQL%NOTFOUND) THEN
2141: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2142: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2143: fnd_msg_pub.ADD;
2144: END IF;
2145:

Line 2143: fnd_msg_pub.ADD;

2139:
2140: IF (SQL%NOTFOUND) THEN
2141: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2142: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2143: fnd_msg_pub.ADD;
2144: END IF;
2145:
2146: RAISE fnd_api.g_exc_unexpected_error;
2147: END IF;

Line 2162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2158: WHERE p.allocation_for = 'FACT'
2159: AND p.allocation_for_id = l_fact_id;
2160:
2161: IF (SQL%NOTFOUND) THEN
2162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2163: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2164: fnd_msg_pub.ADD;
2165: END IF;
2166:

Line 2164: fnd_msg_pub.ADD;

2160:
2161: IF (SQL%NOTFOUND) THEN
2162: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2163: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2164: fnd_msg_pub.ADD;
2165: END IF;
2166:
2167: RAISE fnd_api.g_exc_unexpected_error;
2168: END IF;

Line 2192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2188: AND p.allocation_for_id = l_fact_id
2189: AND p.item_id = -9999;
2190:
2191: IF (SQL%NOTFOUND) THEN
2192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2193: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2194: fnd_msg_pub.ADD;
2195: END IF;
2196:

Line 2194: fnd_msg_pub.ADD;

2190:
2191: IF (SQL%NOTFOUND) THEN
2192: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2193: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2194: fnd_msg_pub.ADD;
2195: END IF;
2196:
2197: RAISE fnd_api.g_exc_unexpected_error;
2198: END IF;

Line 2214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2210: AND p.allocation_for_id = l_fact_id
2211: AND p.item_id = -9999 );
2212:
2213: IF (SQL%NOTFOUND) THEN
2214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2215: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2216: fnd_msg_pub.ADD;
2217: END IF;
2218: RAISE fnd_api.g_exc_unexpected_error;

Line 2216: fnd_msg_pub.ADD;

2212:
2213: IF (SQL%NOTFOUND) THEN
2214: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2215: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2216: fnd_msg_pub.ADD;
2217: END IF;
2218: RAISE fnd_api.g_exc_unexpected_error;
2219: END IF;
2220:

Line 2235: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2231: AND p.allocation_for_id = l_fact_id
2232: AND p.item_id = -9999;
2233:
2234: IF (SQL%NOTFOUND) THEN
2235: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2236: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2237: fnd_msg_pub.ADD;
2238: END IF;
2239:

Line 2237: fnd_msg_pub.ADD;

2233:
2234: IF (SQL%NOTFOUND) THEN
2235: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2236: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2237: fnd_msg_pub.ADD;
2238: END IF;
2239:
2240: RAISE fnd_api.g_exc_unexpected_error;
2241: END IF;

Line 2295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2291: );
2292:
2293:
2294: IF (SQL%NOTFOUND) THEN
2295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2296: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2297: fnd_msg_pub.ADD;
2298: END IF;
2299: RAISE fnd_api.g_exc_unexpected_error;

Line 2297: fnd_msg_pub.ADD;

2293:
2294: IF (SQL%NOTFOUND) THEN
2295: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2296: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2297: fnd_msg_pub.ADD;
2298: END IF;
2299: RAISE fnd_api.g_exc_unexpected_error;
2300: END IF;
2301:

Line 2313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

2309: AND p.allocation_for_id = l_fact_id
2310: AND p.item_id = -9999;
2311:
2312: IF (SQL%NOTFOUND) THEN
2313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2314: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2315: fnd_msg_pub.ADD;
2316: END IF;
2317: RAISE fnd_api.g_exc_unexpected_error;

Line 2315: fnd_msg_pub.ADD;

2311:
2312: IF (SQL%NOTFOUND) THEN
2313: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2314: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2315: fnd_msg_pub.ADD;
2316: END IF;
2317: RAISE fnd_api.g_exc_unexpected_error;
2318: END IF;
2319: */

Line 2337: FND_MSG_PUB.add;

2333: EXCEPTION
2334: WHEN OZF_TP_DIFF_TIME_SPREAD THEN
2335: ROLLBACK TO create_fact_product_spread;
2336: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
2337: FND_MSG_PUB.add;
2338: x_return_status := FND_API.g_ret_sts_error ;
2339: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2340: p_data => x_error_message);
2341: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));

Line 2339: FND_MSG_PUB.count_and_get (p_count => x_error_number,

2335: ROLLBACK TO create_fact_product_spread;
2336: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
2337: FND_MSG_PUB.add;
2338: x_return_status := FND_API.g_ret_sts_error ;
2339: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2340: p_data => x_error_message);
2341: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));
2342: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
2343:

Line 2347: FND_MSG_PUB.add;

2343:
2344: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
2345: ROLLBACK TO create_fact_product_spread;
2346: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
2347: FND_MSG_PUB.add;
2348: x_return_status := FND_API.g_ret_sts_error ;
2349: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2350: p_data => x_error_message);
2351: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));

Line 2349: FND_MSG_PUB.count_and_get (p_count => x_error_number,

2345: ROLLBACK TO create_fact_product_spread;
2346: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
2347: FND_MSG_PUB.add;
2348: x_return_status := FND_API.g_ret_sts_error ;
2349: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2350: p_data => x_error_message);
2351: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
2352: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
2353:

Line 2357: FND_MSG_PUB.count_and_get (p_count => x_error_number,

2353:
2354: WHEN FND_API.G_EXC_ERROR THEN
2355: ROLLBACK TO create_fact_product_spread;
2356: x_return_status := FND_API.g_ret_sts_error ;
2357: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2358: p_data => x_error_message);
2359:
2360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2361: ROLLBACK TO create_fact_product_spread;

Line 2363: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

2359:
2360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2361: ROLLBACK TO create_fact_product_spread;
2362: x_return_status := FND_API.g_ret_sts_unexp_error ;
2363: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
2364: p_data => x_error_message);
2365:
2366: WHEN OTHERS THEN
2367: ROLLBACK TO create_fact_product_spread;

Line 2369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2365:
2366: WHEN OTHERS THEN
2367: ROLLBACK TO create_fact_product_spread;
2368: x_return_status := FND_API.g_ret_sts_unexp_error ;
2369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2370: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
2371: END IF;
2372: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
2373: p_data => x_error_message);

Line 2370: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

2366: WHEN OTHERS THEN
2367: ROLLBACK TO create_fact_product_spread;
2368: x_return_status := FND_API.g_ret_sts_unexp_error ;
2369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2370: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
2371: END IF;
2372: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
2373: p_data => x_error_message);
2374: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 2372: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

2368: x_return_status := FND_API.g_ret_sts_unexp_error ;
2369: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2370: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
2371: END IF;
2372: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
2373: p_data => x_error_message);
2374: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
2375:
2376: END create_fact_product_spread;

Line 2631: FND_MSG_PUB.initialize;

2627: END IF;
2628:
2629: -- Initialize message list if p_init_msg_list is set to TRUE.
2630: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2631: FND_MSG_PUB.initialize;
2632: END IF;
2633:
2634: -- Initialize API return status to SUCCESS
2635: x_return_status := FND_API.g_ret_sts_success;

Line 3155: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3151: WHERE p.allocation_for = 'FUND'
3152: AND p.allocation_for_id = l_fund_id;
3153:
3154: IF (SQL%NOTFOUND) THEN
3155: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3156: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3157: fnd_msg_pub.ADD;
3158: END IF;
3159:

Line 3157: fnd_msg_pub.ADD;

3153:
3154: IF (SQL%NOTFOUND) THEN
3155: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3156: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3157: fnd_msg_pub.ADD;
3158: END IF;
3159:
3160: RAISE fnd_api.g_exc_unexpected_error;
3161: END IF;

Line 3177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3173: WHERE p.allocation_for = 'FUND'
3174: AND p.allocation_for_id = l_fund_id );
3175:
3176: IF (SQL%NOTFOUND) THEN
3177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3179: fnd_msg_pub.ADD;
3180: END IF;
3181:

Line 3179: fnd_msg_pub.ADD;

3175:
3176: IF (SQL%NOTFOUND) THEN
3177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3179: fnd_msg_pub.ADD;
3180: END IF;
3181:
3182: RAISE fnd_api.g_exc_unexpected_error;
3183: END IF;

Line 3199: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3195: WHERE p.allocation_for = 'FUND'
3196: AND p.allocation_for_id = l_fund_id;
3197:
3198: IF (SQL%NOTFOUND) THEN
3199: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3200: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3201: fnd_msg_pub.ADD;
3202: END IF;
3203:

Line 3201: fnd_msg_pub.ADD;

3197:
3198: IF (SQL%NOTFOUND) THEN
3199: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3200: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3201: fnd_msg_pub.ADD;
3202: END IF;
3203:
3204: RAISE fnd_api.g_exc_unexpected_error;
3205: END IF;

Line 3230: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3226: AND p.allocation_for_id = l_fund_id
3227: AND p.item_id = -9999;
3228:
3229: IF (SQL%NOTFOUND) THEN
3230: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3231: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3232: fnd_msg_pub.ADD;
3233: END IF;
3234:

Line 3232: fnd_msg_pub.ADD;

3228:
3229: IF (SQL%NOTFOUND) THEN
3230: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3231: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3232: fnd_msg_pub.ADD;
3233: END IF;
3234:
3235: RAISE fnd_api.g_exc_unexpected_error;
3236: END IF;

Line 3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3248: AND p.allocation_for_id = l_fund_id
3249: AND p.item_id = -9999 );
3250:
3251: IF (SQL%NOTFOUND) THEN
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3254: fnd_msg_pub.ADD;
3255: END IF;
3256: RAISE fnd_api.g_exc_unexpected_error;

Line 3254: fnd_msg_pub.ADD;

3250:
3251: IF (SQL%NOTFOUND) THEN
3252: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3253: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3254: fnd_msg_pub.ADD;
3255: END IF;
3256: RAISE fnd_api.g_exc_unexpected_error;
3257: END IF;
3258:

Line 3274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3270: AND p.allocation_for_id = l_fund_id
3271: AND p.item_id = -9999;
3272:
3273: IF (SQL%NOTFOUND) THEN
3274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3275: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3276: fnd_msg_pub.ADD;
3277: END IF;
3278:

Line 3276: fnd_msg_pub.ADD;

3272:
3273: IF (SQL%NOTFOUND) THEN
3274: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3275: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3276: fnd_msg_pub.ADD;
3277: END IF;
3278:
3279: RAISE fnd_api.g_exc_unexpected_error;
3280: END IF;

Line 3434: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

3430: AND p.item_id = -9999 )
3431: );
3432:
3433: IF (SQL%NOTFOUND) THEN
3434: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3435: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3436: fnd_msg_pub.ADD;
3437: END IF;
3438: RAISE fnd_api.g_exc_unexpected_error;

Line 3436: fnd_msg_pub.ADD;

3432:
3433: IF (SQL%NOTFOUND) THEN
3434: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3435: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3436: fnd_msg_pub.ADD;
3437: END IF;
3438: RAISE fnd_api.g_exc_unexpected_error;
3439: END IF;
3440: END IF;

Line 3453: FND_MSG_PUB.add;

3449: EXCEPTION
3450: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
3451: ROLLBACK TO create_root_product_spread;
3452: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
3453: FND_MSG_PUB.add;
3454: x_return_status := FND_API.g_ret_sts_error ;
3455: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3456: p_data => x_error_message);
3457: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));

Line 3455: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3451: ROLLBACK TO create_root_product_spread;
3452: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
3453: FND_MSG_PUB.add;
3454: x_return_status := FND_API.g_ret_sts_error ;
3455: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3456: p_data => x_error_message);
3457: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
3458: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
3459:

Line 3463: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3459:
3460: WHEN FND_API.G_EXC_ERROR THEN
3461: ROLLBACK TO create_root_product_spread;
3462: x_return_status := FND_API.g_ret_sts_error ;
3463: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3464: p_data => x_error_message);
3465:
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: ROLLBACK TO create_root_product_spread;

Line 3469: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3465:
3466: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3467: ROLLBACK TO create_root_product_spread;
3468: x_return_status := FND_API.g_ret_sts_unexp_error ;
3469: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3470: p_data => x_error_message);
3471:
3472: WHEN OTHERS THEN
3473: ROLLBACK TO create_root_product_spread;

Line 3475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3471:
3472: WHEN OTHERS THEN
3473: ROLLBACK TO create_root_product_spread;
3474: x_return_status := FND_API.g_ret_sts_unexp_error ;
3475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3476: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3477: END IF;
3478: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3479: p_data => x_error_message);

Line 3476: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

3472: WHEN OTHERS THEN
3473: ROLLBACK TO create_root_product_spread;
3474: x_return_status := FND_API.g_ret_sts_unexp_error ;
3475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3476: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3477: END IF;
3478: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3479: p_data => x_error_message);
3480: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 3478: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3474: x_return_status := FND_API.g_ret_sts_unexp_error ;
3475: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3476: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3477: END IF;
3478: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3479: p_data => x_error_message);
3480: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
3481:
3482: END create_root_product_spread;

Line 3560: FND_MSG_PUB.initialize;

3556: END IF;
3557:
3558: -- Initialize message list if p_init_msg_list is set to TRUE.
3559: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3560: FND_MSG_PUB.initialize;
3561: END IF;
3562:
3563: -- Initialize API return status to SUCCESS
3564: x_return_status := FND_API.g_ret_sts_success;

Line 3620: FND_MSG_PUB.add;

3616: EXCEPTION
3617: WHEN OZF_TP_OPER_NOT_ALLOWED THEN
3618: ROLLBACK TO publish_fact_product_spread;
3619: FND_MESSAGE.set_name('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT');
3620: FND_MSG_PUB.add;
3621: x_return_status := FND_API.g_ret_sts_error ;
3622: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3623: p_data => x_error_message);
3624: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT'));

Line 3622: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3618: ROLLBACK TO publish_fact_product_spread;
3619: FND_MESSAGE.set_name('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT');
3620: FND_MSG_PUB.add;
3621: x_return_status := FND_API.g_ret_sts_error ;
3622: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3623: p_data => x_error_message);
3624: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT'));
3625:
3626: WHEN FND_API.G_EXC_ERROR THEN

Line 3629: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3625:
3626: WHEN FND_API.G_EXC_ERROR THEN
3627: ROLLBACK TO publish_fact_product_spread;
3628: x_return_status := FND_API.g_ret_sts_error ;
3629: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3630: p_data => x_error_message);
3631:
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: ROLLBACK TO publish_fact_product_spread;

Line 3635: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3631:
3632: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3633: ROLLBACK TO publish_fact_product_spread;
3634: x_return_status := FND_API.g_ret_sts_unexp_error ;
3635: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3636: p_data => x_error_message);
3637:
3638: WHEN OTHERS THEN
3639: ROLLBACK TO publish_fact_product_spread;

Line 3641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3637:
3638: WHEN OTHERS THEN
3639: ROLLBACK TO publish_fact_product_spread;
3640: x_return_status := FND_API.g_ret_sts_unexp_error ;
3641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3642: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3643: END IF;
3644: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3645: p_data => x_error_message);

Line 3642: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

3638: WHEN OTHERS THEN
3639: ROLLBACK TO publish_fact_product_spread;
3640: x_return_status := FND_API.g_ret_sts_unexp_error ;
3641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3642: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3643: END IF;
3644: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3645: p_data => x_error_message);
3646: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 3644: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3640: x_return_status := FND_API.g_ret_sts_unexp_error ;
3641: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3642: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3643: END IF;
3644: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3645: p_data => x_error_message);
3646: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
3647:
3648: END publish_fact_product_spread;

Line 3705: FND_MSG_PUB.initialize;

3701: END IF;
3702:
3703: -- Initialize message list if p_init_msg_list is set to TRUE.
3704: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3705: FND_MSG_PUB.initialize;
3706: END IF;
3707:
3708: -- Initialize API return status to SUCCESS
3709: x_return_status := FND_API.g_ret_sts_success;

Line 3738: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3734: EXCEPTION
3735: WHEN FND_API.G_EXC_ERROR THEN
3736: ROLLBACK TO delete_fact_product_spread;
3737: x_return_status := FND_API.g_ret_sts_error ;
3738: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3739: p_data => x_error_message);
3740:
3741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3742: ROLLBACK TO delete_fact_product_spread;

Line 3744: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3740:
3741: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3742: ROLLBACK TO delete_fact_product_spread;
3743: x_return_status := FND_API.g_ret_sts_unexp_error ;
3744: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3745: p_data => x_error_message);
3746:
3747: WHEN OTHERS THEN
3748: ROLLBACK TO delete_fact_product_spread;

Line 3750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3746:
3747: WHEN OTHERS THEN
3748: ROLLBACK TO delete_fact_product_spread;
3749: x_return_status := FND_API.g_ret_sts_unexp_error ;
3750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3751: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3752: END IF;
3753: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3754: p_data => x_error_message);

Line 3751: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

3747: WHEN OTHERS THEN
3748: ROLLBACK TO delete_fact_product_spread;
3749: x_return_status := FND_API.g_ret_sts_unexp_error ;
3750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3751: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3752: END IF;
3753: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3754: p_data => x_error_message);
3755: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 3753: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3749: x_return_status := FND_API.g_ret_sts_unexp_error ;
3750: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3751: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3752: END IF;
3753: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3754: p_data => x_error_message);
3755: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
3756:
3757: END delete_fact_product_spread;

Line 3879: FND_MSG_PUB.initialize;

3875: END IF;
3876:
3877: -- Initialize message list if p_init_msg_list is set to TRUE.
3878: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3879: FND_MSG_PUB.initialize;
3880: END IF;
3881:
3882: -- Initialize API return status to SUCCESS
3883: x_return_status := FND_API.g_ret_sts_success;

Line 3954: FND_MSG_PUB.add;

3950: EXCEPTION
3951: WHEN OZF_TP_CHG_PS_NOT_ALLOWED THEN
3952: ROLLBACK TO delete_cascade_product_spread;
3953: FND_MESSAGE.set_name('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT');
3954: FND_MSG_PUB.add;
3955: x_return_status := FND_API.g_ret_sts_error ;
3956: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3957: p_data => x_error_message);
3958: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT'));

Line 3956: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3952: ROLLBACK TO delete_cascade_product_spread;
3953: FND_MESSAGE.set_name('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT');
3954: FND_MSG_PUB.add;
3955: x_return_status := FND_API.g_ret_sts_error ;
3956: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3957: p_data => x_error_message);
3958: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT'));
3959:
3960: WHEN FND_API.G_EXC_ERROR THEN

Line 3963: FND_MSG_PUB.count_and_get (p_count => x_error_number,

3959:
3960: WHEN FND_API.G_EXC_ERROR THEN
3961: ROLLBACK TO delete_cascade_product_spread;
3962: x_return_status := FND_API.g_ret_sts_error ;
3963: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3964: p_data => x_error_message);
3965:
3966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3967: ROLLBACK TO delete_cascade_product_spread;

Line 3969: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3965:
3966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3967: ROLLBACK TO delete_cascade_product_spread;
3968: x_return_status := FND_API.g_ret_sts_unexp_error ;
3969: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3970: p_data => x_error_message);
3971:
3972: WHEN OTHERS THEN
3973: ROLLBACK TO delete_cascade_product_spread;

Line 3975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3971:
3972: WHEN OTHERS THEN
3973: ROLLBACK TO delete_cascade_product_spread;
3974: x_return_status := FND_API.g_ret_sts_unexp_error ;
3975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3976: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3977: END IF;
3978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3979: p_data => x_error_message);

Line 3976: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

3972: WHEN OTHERS THEN
3973: ROLLBACK TO delete_cascade_product_spread;
3974: x_return_status := FND_API.g_ret_sts_unexp_error ;
3975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3976: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3977: END IF;
3978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3979: p_data => x_error_message);
3980: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 3978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

3974: x_return_status := FND_API.g_ret_sts_unexp_error ;
3975: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3976: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
3977: END IF;
3978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
3979: p_data => x_error_message);
3980: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
3981:
3982: END delete_cascade_product_spread;

Line 4189: FND_MSG_PUB.initialize;

4185: END IF;
4186:
4187: -- Initialize message list if p_init_msg_list is set to TRUE.
4188: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4189: FND_MSG_PUB.initialize;
4190: END IF;
4191:
4192: -- Initialize API return status to SUCCESS
4193: x_return_status := FND_API.g_ret_sts_success;

Line 4390: FND_MSG_PUB.add;

4386: EXCEPTION
4387: WHEN OZF_TP_ADDITEM_NOT_ALLOWED THEN
4388: ROLLBACK TO add_cascade_product_spread;
4389: FND_MESSAGE.set_name('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT');
4390: FND_MSG_PUB.add;
4391: x_return_status := FND_API.g_ret_sts_error ;
4392: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4393: p_data => x_error_message);
4394: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT'));

Line 4392: FND_MSG_PUB.count_and_get (p_count => x_error_number,

4388: ROLLBACK TO add_cascade_product_spread;
4389: FND_MESSAGE.set_name('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT');
4390: FND_MSG_PUB.add;
4391: x_return_status := FND_API.g_ret_sts_error ;
4392: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4393: p_data => x_error_message);
4394: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT'));
4395:
4396: WHEN FND_API.G_EXC_ERROR THEN

Line 4399: FND_MSG_PUB.count_and_get (p_count => x_error_number,

4395:
4396: WHEN FND_API.G_EXC_ERROR THEN
4397: ROLLBACK TO add_cascade_product_spread;
4398: x_return_status := FND_API.g_ret_sts_error ;
4399: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4400: p_data => x_error_message);
4401:
4402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4403: ROLLBACK TO add_cascade_product_spread;

Line 4405: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4401:
4402: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4403: ROLLBACK TO add_cascade_product_spread;
4404: x_return_status := FND_API.g_ret_sts_unexp_error ;
4405: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4406: p_data => x_error_message);
4407:
4408: WHEN OTHERS THEN
4409: ROLLBACK TO add_cascade_product_spread;

Line 4411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4407:
4408: WHEN OTHERS THEN
4409: ROLLBACK TO add_cascade_product_spread;
4410: x_return_status := FND_API.g_ret_sts_unexp_error ;
4411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4412: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4413: END IF;
4414: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4415: p_data => x_error_message);

Line 4412: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

4408: WHEN OTHERS THEN
4409: ROLLBACK TO add_cascade_product_spread;
4410: x_return_status := FND_API.g_ret_sts_unexp_error ;
4411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4412: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4413: END IF;
4414: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4415: p_data => x_error_message);
4416: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 4414: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4410: x_return_status := FND_API.g_ret_sts_unexp_error ;
4411: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4412: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4413: END IF;
4414: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4415: p_data => x_error_message);
4416: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
4417:
4418: END add_cascade_product_spread;

Line 4631: FND_MSG_PUB.initialize;

4627: END IF;
4628:
4629: -- Initialize message list if p_init_msg_list is set to TRUE.
4630: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4631: FND_MSG_PUB.initialize;
4632: END IF;
4633:
4634: -- Initialize API return status to SUCCESS
4635: x_return_status := FND_API.g_ret_sts_success;

Line 4745: FND_MSG_PUB.add;

4741: EXCEPTION
4742: WHEN OZF_TP_DELITEM_NOT_ALLOWED THEN
4743: ROLLBACK TO delete_single_product;
4744: FND_MESSAGE.set_name('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT');
4745: FND_MSG_PUB.add;
4746: x_return_status := FND_API.g_ret_sts_error ;
4747: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4748: p_data => x_error_message);
4749: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT'));

Line 4747: FND_MSG_PUB.count_and_get (p_count => x_error_number,

4743: ROLLBACK TO delete_single_product;
4744: FND_MESSAGE.set_name('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT');
4745: FND_MSG_PUB.add;
4746: x_return_status := FND_API.g_ret_sts_error ;
4747: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4748: p_data => x_error_message);
4749: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT'));
4750:
4751: WHEN FND_API.G_EXC_ERROR THEN

Line 4754: FND_MSG_PUB.count_and_get (p_count => x_error_number,

4750:
4751: WHEN FND_API.G_EXC_ERROR THEN
4752: ROLLBACK TO delete_single_product;
4753: x_return_status := FND_API.g_ret_sts_error ;
4754: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4755: p_data => x_error_message);
4756:
4757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4758: ROLLBACK TO delete_single_product;

Line 4760: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4756:
4757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4758: ROLLBACK TO delete_single_product;
4759: x_return_status := FND_API.g_ret_sts_unexp_error ;
4760: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4761: p_data => x_error_message);
4762:
4763: WHEN OTHERS THEN
4764: ROLLBACK TO delete_single_product;

Line 4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4762:
4763: WHEN OTHERS THEN
4764: ROLLBACK TO delete_single_product;
4765: x_return_status := FND_API.g_ret_sts_unexp_error ;
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4767: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4768: END IF;
4769: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4770: p_data => x_error_message);

Line 4767: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

4763: WHEN OTHERS THEN
4764: ROLLBACK TO delete_single_product;
4765: x_return_status := FND_API.g_ret_sts_unexp_error ;
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4767: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4768: END IF;
4769: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4770: p_data => x_error_message);
4771: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 4769: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4765: x_return_status := FND_API.g_ret_sts_unexp_error ;
4766: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4767: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4768: END IF;
4769: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4770: p_data => x_error_message);
4771: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
4772:
4773: END delete_single_product;

Line 4841: FND_MSG_PUB.initialize;

4837: END IF;
4838:
4839: -- Initialize message list if p_init_msg_list is set to TRUE.
4840: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4841: FND_MSG_PUB.initialize;
4842: END IF;
4843:
4844: -- Initialize API return status to SUCCESS
4845: x_return_status := FND_API.g_ret_sts_success;

Line 4889: FND_MSG_PUB.count_and_get (p_count => x_error_number,

4885: EXCEPTION
4886: WHEN FND_API.G_EXC_ERROR THEN
4887: ROLLBACK TO delete_target_allocation;
4888: x_return_status := FND_API.g_ret_sts_error ;
4889: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4890: p_data => x_error_message);
4891:
4892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4893: ROLLBACK TO delete_target_allocation;

Line 4895: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4891:
4892: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4893: ROLLBACK TO delete_target_allocation;
4894: x_return_status := FND_API.g_ret_sts_unexp_error ;
4895: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4896: p_data => x_error_message);
4897:
4898: WHEN OTHERS THEN
4899: ROLLBACK TO delete_target_allocation;

Line 4901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4897:
4898: WHEN OTHERS THEN
4899: ROLLBACK TO delete_target_allocation;
4900: x_return_status := FND_API.g_ret_sts_unexp_error ;
4901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4902: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4903: END IF;
4904: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4905: p_data => x_error_message);

Line 4902: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

4898: WHEN OTHERS THEN
4899: ROLLBACK TO delete_target_allocation;
4900: x_return_status := FND_API.g_ret_sts_unexp_error ;
4901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4902: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4903: END IF;
4904: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4905: p_data => x_error_message);
4906: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 4904: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

4900: x_return_status := FND_API.g_ret_sts_unexp_error ;
4901: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4902: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
4903: END IF;
4904: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
4905: p_data => x_error_message);
4906: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
4907:
4908: END delete_target_allocation;

Line 5304: FND_MSG_PUB.initialize;

5300: END IF;
5301:
5302: -- Initialize message list if p_init_msg_list is set to TRUE.
5303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
5304: FND_MSG_PUB.initialize;
5305: END IF;
5306:
5307: -- Initialize API return status to SUCCESS
5308: x_return_status := FND_API.g_ret_sts_success;

Line 5951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

5947: AND a.parent_party_id = -9999 )
5948: );
5949:
5950: IF (SQL%NOTFOUND) THEN
5951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5952: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
5953: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
5954: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
5955: fnd_msg_pub.ADD;

Line 5955: fnd_msg_pub.ADD;

5951: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5952: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
5953: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
5954: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
5955: fnd_msg_pub.ADD;
5956: END IF;
5957: RAISE fnd_api.g_exc_unexpected_error;
5958: END IF;
5959:

Line 5979: FND_MSG_PUB.add;

5975:
5976: WHEN OZF_TP_INVALID_PARAM THEN
5977: ROLLBACK TO old_allocate_target_first_time;
5978: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
5979: FND_MSG_PUB.add;
5980: x_return_status := FND_API.g_ret_sts_error ;
5981: FND_MSG_PUB.count_and_get (p_count => x_error_number,
5982: p_data => x_error_message);
5983: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 5981: FND_MSG_PUB.count_and_get (p_count => x_error_number,

5977: ROLLBACK TO old_allocate_target_first_time;
5978: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
5979: FND_MSG_PUB.add;
5980: x_return_status := FND_API.g_ret_sts_error ;
5981: FND_MSG_PUB.count_and_get (p_count => x_error_number,
5982: p_data => x_error_message);
5983: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
5984: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
5985:

Line 5989: FND_MSG_PUB.count_and_get (p_count => x_error_number,

5985:
5986: WHEN FND_API.G_EXC_ERROR THEN
5987: ROLLBACK TO old_allocate_target_first_time;
5988: x_return_status := FND_API.g_ret_sts_error ;
5989: FND_MSG_PUB.count_and_get (p_count => x_error_number,
5990: p_data => x_error_message);
5991:
5992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5993: ROLLBACK TO old_allocate_target_first_time;

Line 5995: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

5991:
5992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5993: ROLLBACK TO old_allocate_target_first_time;
5994: x_return_status := FND_API.g_ret_sts_unexp_error ;
5995: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
5996: p_data => x_error_message);
5997:
5998: WHEN OTHERS THEN
5999: ROLLBACK TO old_allocate_target_first_time;

Line 6004: FND_MSG_PUB.add;

6000:
6001: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
6002: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
6003: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
6004: FND_MSG_PUB.add;
6005:
6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6008: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 6007: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6003: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
6004: FND_MSG_PUB.add;
6005:
6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6008: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
6011: p_data => x_error_message);

Line 6008: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

6004: FND_MSG_PUB.add;
6005:
6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6008: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
6011: p_data => x_error_message);
6012: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 6010: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

6006: x_return_status := FND_API.g_ret_sts_unexp_error ;
6007: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6008: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
6009: END IF;
6010: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
6011: p_data => x_error_message);
6012: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
6013:
6014: END old_allocate_target_first_time;

Line 6416: FND_MSG_PUB.initialize;

6412: END IF;
6413:
6414: -- Initialize message list if p_init_msg_list is set to TRUE.
6415: IF FND_API.to_Boolean( p_init_msg_list ) THEN
6416: FND_MSG_PUB.initialize;
6417: END IF;
6418:
6419: -- Initialize API return status to SUCCESS
6420: x_return_status := FND_API.g_ret_sts_success;

Line 6716: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

6712: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
6713: WHERE a.account_allocation_id = l_account_allocation_id;
6714:
6715: IF (SQL%NOTFOUND) THEN
6716: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6717: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6718: fnd_msg_pub.ADD;
6719: END IF;
6720:

Line 6718: fnd_msg_pub.ADD;

6714:
6715: IF (SQL%NOTFOUND) THEN
6716: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6717: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6718: fnd_msg_pub.ADD;
6719: END IF;
6720:
6721: RAISE fnd_api.g_exc_unexpected_error;
6722: END IF;

Line 6947: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

6943: WHERE p.allocation_for = 'CUST'
6944: AND p.allocation_for_id = l_account_allocation_id);
6945:
6946: IF (SQL%NOTFOUND) THEN
6947: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6948: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6949: fnd_msg_pub.ADD;
6950: END IF;
6951:

Line 6949: fnd_msg_pub.ADD;

6945:
6946: IF (SQL%NOTFOUND) THEN
6947: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6948: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6949: fnd_msg_pub.ADD;
6950: END IF;
6951:
6952: RAISE fnd_api.g_exc_unexpected_error;
6953: END IF;

Line 6968: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

6964: WHERE p.allocation_for = 'CUST'
6965: AND p.allocation_for_id = l_account_allocation_id;
6966:
6967: IF (SQL%NOTFOUND) THEN
6968: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6969: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
6970: fnd_msg_pub.ADD;
6971: END IF;
6972:

Line 6970: fnd_msg_pub.ADD;

6966:
6967: IF (SQL%NOTFOUND) THEN
6968: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6969: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
6970: fnd_msg_pub.ADD;
6971: END IF;
6972:
6973: RAISE fnd_api.g_exc_unexpected_error;
6974: END IF;

Line 6998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

6994: AND p.allocation_for_id = l_account_allocation_id
6995: AND p.item_id = -9999;
6996:
6997: IF (SQL%NOTFOUND) THEN
6998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6999: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7000: fnd_msg_pub.ADD;
7001: END IF;
7002:

Line 7000: fnd_msg_pub.ADD;

6996:
6997: IF (SQL%NOTFOUND) THEN
6998: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6999: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7000: fnd_msg_pub.ADD;
7001: END IF;
7002:
7003: RAISE fnd_api.g_exc_unexpected_error;
7004: END IF;

Line 7021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7017: AND p.allocation_for_id = l_account_allocation_id
7018: AND p.item_id = -9999 );
7019:
7020: IF (SQL%NOTFOUND) THEN
7021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7022: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7023: fnd_msg_pub.ADD;
7024: END IF;
7025: RAISE fnd_api.g_exc_unexpected_error;

Line 7023: fnd_msg_pub.ADD;

7019:
7020: IF (SQL%NOTFOUND) THEN
7021: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7022: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7023: fnd_msg_pub.ADD;
7024: END IF;
7025: RAISE fnd_api.g_exc_unexpected_error;
7026: END IF;
7027:

Line 7042: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7038: AND p.allocation_for_id = l_account_allocation_id
7039: AND p.item_id = -9999;
7040:
7041: IF (SQL%NOTFOUND) THEN
7042: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7043: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7044: fnd_msg_pub.ADD;
7045: END IF;
7046:

Line 7044: fnd_msg_pub.ADD;

7040:
7041: IF (SQL%NOTFOUND) THEN
7042: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7043: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7044: fnd_msg_pub.ADD;
7045: END IF;
7046:
7047: RAISE fnd_api.g_exc_unexpected_error;
7048: END IF;

Line 7134: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7130: RETURNING t.allocation_for_id INTO l_temp_product_allocation_id;
7131:
7132:
7133: IF (SQL%NOTFOUND) THEN
7134: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7135: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7136: fnd_msg_pub.ADD;
7137: END IF;
7138: RAISE fnd_api.g_exc_unexpected_error;

Line 7136: fnd_msg_pub.ADD;

7132:
7133: IF (SQL%NOTFOUND) THEN
7134: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7135: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7136: fnd_msg_pub.ADD;
7137: END IF;
7138: RAISE fnd_api.g_exc_unexpected_error;
7139: END IF;
7140:

Line 7150: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7146: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7147: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7148:
7149: IF (SQL%NOTFOUND) THEN
7150: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7151: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7152: fnd_msg_pub.ADD;
7153: END IF;
7154: RAISE fnd_api.g_exc_unexpected_error;

Line 7152: fnd_msg_pub.ADD;

7148:
7149: IF (SQL%NOTFOUND) THEN
7150: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7151: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7152: fnd_msg_pub.ADD;
7153: END IF;
7154: RAISE fnd_api.g_exc_unexpected_error;
7155: END IF;
7156: */

Line 7177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7173: );
7174:
7175:
7176: IF (SQL%NOTFOUND) THEN
7177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7179: fnd_msg_pub.ADD;
7180: END IF;
7181: RAISE fnd_api.g_exc_unexpected_error;

Line 7179: fnd_msg_pub.ADD;

7175:
7176: IF (SQL%NOTFOUND) THEN
7177: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7179: fnd_msg_pub.ADD;
7180: END IF;
7181: RAISE fnd_api.g_exc_unexpected_error;
7182: END IF;
7183:

Line 7195: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7191: AND p.allocation_for_id = l_account_allocation_id
7192: AND p.item_id = -9999;
7193:
7194: IF (SQL%NOTFOUND) THEN
7195: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7196: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7197: fnd_msg_pub.ADD;
7198: END IF;
7199: RAISE fnd_api.g_exc_unexpected_error;

Line 7197: fnd_msg_pub.ADD;

7193:
7194: IF (SQL%NOTFOUND) THEN
7195: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7196: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7197: fnd_msg_pub.ADD;
7198: END IF;
7199: RAISE fnd_api.g_exc_unexpected_error;
7200: END IF;
7201: ---------------------------------------------------------------------------------------------------

Line 7386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7382: AND a.parent_party_id = -9999 )
7383: );
7384:
7385: IF (SQL%NOTFOUND) THEN
7386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7387: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7388: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
7389: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7390: fnd_msg_pub.ADD;

Line 7390: fnd_msg_pub.ADD;

7386: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7387: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7388: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
7389: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7390: fnd_msg_pub.ADD;
7391: END IF;
7392: RAISE fnd_api.g_exc_unexpected_error;
7393: END IF;
7394:

Line 7448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7444: AND a.parent_party_id = -9999)
7445: );
7446:
7447: IF (SQL%NOTFOUND) THEN
7448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7449: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7450: fnd_msg_pub.ADD;
7451: END IF;
7452: RAISE fnd_api.g_exc_unexpected_error;

Line 7450: fnd_msg_pub.ADD;

7446:
7447: IF (SQL%NOTFOUND) THEN
7448: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7449: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7450: fnd_msg_pub.ADD;
7451: END IF;
7452: RAISE fnd_api.g_exc_unexpected_error;
7453: END IF;
7454:

Line 7467: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7463: AND a.allocation_for_id = l_fund_id
7464: AND a.parent_party_id = -9999;
7465:
7466: IF (SQL%NOTFOUND) THEN
7467: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7468: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7469: fnd_msg_pub.ADD;
7470: END IF;
7471:

Line 7469: fnd_msg_pub.ADD;

7465:
7466: IF (SQL%NOTFOUND) THEN
7467: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7468: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7469: fnd_msg_pub.ADD;
7470: END IF;
7471:
7472: RAISE fnd_api.g_exc_unexpected_error;
7473: END IF;

Line 7527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7523: )
7524: RETURNING t.allocation_for_id INTO l_temp_account_allocation_id;
7525:
7526: IF (SQL%NOTFOUND) THEN
7527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7528: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7529: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');
7530: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7531: fnd_msg_pub.ADD;

Line 7531: fnd_msg_pub.ADD;

7527: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7528: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7529: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');
7530: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7531: fnd_msg_pub.ADD;
7532: END IF;
7533: RAISE fnd_api.g_exc_unexpected_error;
7534: END IF;
7535:

Line 7548: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7544: a.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7545: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7546:
7547: IF (SQL%NOTFOUND) THEN
7548: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7549: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');
7550: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');
7551: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);
7552: fnd_msg_pub.ADD;

Line 7552: fnd_msg_pub.ADD;

7548: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7549: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');
7550: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');
7551: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);
7552: fnd_msg_pub.ADD;
7553: END IF;
7554: RAISE fnd_api.g_exc_unexpected_error;
7555: END IF;
7556:

Line 7610: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7606: RETURNING t.allocation_for_id INTO l_temp_product_allocation_id;
7607:
7608:
7609: IF (SQL%NOTFOUND) THEN
7610: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7611: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7612: fnd_msg_pub.ADD;
7613: END IF;
7614: RAISE fnd_api.g_exc_unexpected_error;

Line 7612: fnd_msg_pub.ADD;

7608:
7609: IF (SQL%NOTFOUND) THEN
7610: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7611: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7612: fnd_msg_pub.ADD;
7613: END IF;
7614: RAISE fnd_api.g_exc_unexpected_error;
7615: END IF;
7616:

Line 7626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN

7622: p.last_update_login = FND_GLOBAL.CONC_LOGIN_ID
7623: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7624:
7625: IF (SQL%NOTFOUND) THEN
7626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7627: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7628: fnd_msg_pub.ADD;
7629: END IF;
7630: RAISE fnd_api.g_exc_unexpected_error;

Line 7628: fnd_msg_pub.ADD;

7624:
7625: IF (SQL%NOTFOUND) THEN
7626: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7627: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7628: fnd_msg_pub.ADD;
7629: END IF;
7630: RAISE fnd_api.g_exc_unexpected_error;
7631: END IF;
7632:

Line 7648: FND_MSG_PUB.add;

7644:
7645: WHEN OZF_TP_INVALID_PARAM THEN
7646: ROLLBACK TO allocate_target_first_time;
7647: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
7648: FND_MSG_PUB.add;
7649: x_return_status := FND_API.g_ret_sts_error ;
7650: FND_MSG_PUB.count_and_get (p_count => x_error_number,
7651: p_data => x_error_message);
7652: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 7650: FND_MSG_PUB.count_and_get (p_count => x_error_number,

7646: ROLLBACK TO allocate_target_first_time;
7647: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
7648: FND_MSG_PUB.add;
7649: x_return_status := FND_API.g_ret_sts_error ;
7650: FND_MSG_PUB.count_and_get (p_count => x_error_number,
7651: p_data => x_error_message);
7652: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
7653: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
7654:

Line 7658: FND_MSG_PUB.count_and_get (p_count => x_error_number,

7654:
7655: WHEN FND_API.G_EXC_ERROR THEN
7656: ROLLBACK TO allocate_target_first_time;
7657: x_return_status := FND_API.g_ret_sts_error ;
7658: FND_MSG_PUB.count_and_get (p_count => x_error_number,
7659: p_data => x_error_message);
7660:
7661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7662: ROLLBACK TO allocate_target_first_time;

Line 7664: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

7660:
7661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7662: ROLLBACK TO allocate_target_first_time;
7663: x_return_status := FND_API.g_ret_sts_unexp_error ;
7664: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
7665: p_data => x_error_message);
7666:
7667: WHEN OTHERS THEN
7668: ROLLBACK TO allocate_target_first_time;

Line 7673: FND_MSG_PUB.add;

7669:
7670: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
7671: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
7672: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
7673: FND_MSG_PUB.add;
7674:
7675: x_return_status := FND_API.g_ret_sts_unexp_error ;
7676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7677: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 7676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7672: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
7673: FND_MSG_PUB.add;
7674:
7675: x_return_status := FND_API.g_ret_sts_unexp_error ;
7676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7677: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
7678: END IF;
7679: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
7680: p_data => x_error_message);

Line 7677: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

7673: FND_MSG_PUB.add;
7674:
7675: x_return_status := FND_API.g_ret_sts_unexp_error ;
7676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7677: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
7678: END IF;
7679: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
7680: p_data => x_error_message);
7681: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 7679: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

7675: x_return_status := FND_API.g_ret_sts_unexp_error ;
7676: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7677: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
7678: END IF;
7679: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
7680: p_data => x_error_message);
7681: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
7682:
7683: END allocate_target_first_time;

Line 8083: FND_MSG_PUB.initialize;

8079: END IF;
8080:
8081: -- Initialize message list if p_init_msg_list is set to TRUE.
8082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8083: FND_MSG_PUB.initialize;
8084: END IF;
8085:
8086: -- Initialize API return status to SUCCESS
8087: x_return_status := FND_API.g_ret_sts_success;

Line 8149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8145: EXCEPTION
8146: WHEN OTHERS THEN
8147: ROLLBACK TO allocate_target_addon;
8148: x_return_status := FND_API.g_ret_sts_unexp_error ;
8149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8150: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8151: END IF;
8152: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8153: p_data => x_error_message);

Line 8150: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

8146: WHEN OTHERS THEN
8147: ROLLBACK TO allocate_target_addon;
8148: x_return_status := FND_API.g_ret_sts_unexp_error ;
8149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8150: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8151: END IF;
8152: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8153: p_data => x_error_message);
8154: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : COLLECTION UNNESTING: OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 8152: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8148: x_return_status := FND_API.g_ret_sts_unexp_error ;
8149: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8150: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8151: END IF;
8152: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8153: p_data => x_error_message);
8154: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : COLLECTION UNNESTING: OTHERS EXCEPTION = '||sqlerrm(sqlcode));
8155:
8156: IF l_period_tbl IS NULL OR l_period_tbl.COUNT <= 0 THEN

Line 8568: FND_MSG_PUB.add;

8564:
8565: WHEN OZF_TP_INVALID_PARAM THEN
8566: ROLLBACK TO allocate_target_addon;
8567: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8568: FND_MSG_PUB.add;
8569: x_return_status := FND_API.g_ret_sts_error ;
8570: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8571: p_data => x_error_message);
8572: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 8570: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8566: ROLLBACK TO allocate_target_addon;
8567: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8568: FND_MSG_PUB.add;
8569: x_return_status := FND_API.g_ret_sts_error ;
8570: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8571: p_data => x_error_message);
8572: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8573: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8574:

Line 8578: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8574:
8575: WHEN FND_API.G_EXC_ERROR THEN
8576: ROLLBACK TO allocate_target_addon;
8577: x_return_status := FND_API.g_ret_sts_error ;
8578: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8579: p_data => x_error_message);
8580:
8581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8582: ROLLBACK TO allocate_target_addon;

Line 8584: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8580:
8581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8582: ROLLBACK TO allocate_target_addon;
8583: x_return_status := FND_API.g_ret_sts_unexp_error ;
8584: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8585: p_data => x_error_message);
8586:
8587: WHEN OTHERS THEN
8588: ROLLBACK TO allocate_target_addon;

Line 8593: FND_MSG_PUB.add;

8589:
8590: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8591: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8592: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8593: FND_MSG_PUB.add;
8594:
8595: x_return_status := FND_API.g_ret_sts_unexp_error ;
8596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8597: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 8596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8592: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8593: FND_MSG_PUB.add;
8594:
8595: x_return_status := FND_API.g_ret_sts_unexp_error ;
8596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8597: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8598: END IF;
8599: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8600: p_data => x_error_message);

Line 8597: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

8593: FND_MSG_PUB.add;
8594:
8595: x_return_status := FND_API.g_ret_sts_unexp_error ;
8596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8597: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8598: END IF;
8599: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8600: p_data => x_error_message);
8601: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 8599: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8595: x_return_status := FND_API.g_ret_sts_unexp_error ;
8596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8597: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8598: END IF;
8599: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8600: p_data => x_error_message);
8601: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
8602:
8603: END allocate_target_addon;

Line 8701: FND_MSG_PUB.initialize;

8697: END IF;
8698:
8699: -- Initialize message list if p_init_msg_list is set to TRUE.
8700: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8701: FND_MSG_PUB.initialize;
8702: END IF;
8703:
8704: -- Initialize API return status to SUCCESS
8705: x_return_status := FND_API.g_ret_sts_success;

Line 8797: FND_MSG_PUB.add;

8793:
8794: WHEN OZF_TP_INVALID_PARAM THEN
8795: ROLLBACK TO setup_product_spread;
8796: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8797: FND_MSG_PUB.add;
8798: x_return_status := FND_API.g_ret_sts_error ;
8799: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8800: p_data => x_error_message);
8801: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 8799: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8795: ROLLBACK TO setup_product_spread;
8796: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8797: FND_MSG_PUB.add;
8798: x_return_status := FND_API.g_ret_sts_error ;
8799: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8800: p_data => x_error_message);
8801: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8802: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8803:

Line 8807: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8803:
8804: WHEN FND_API.G_EXC_ERROR THEN
8805: ROLLBACK TO setup_product_spread;
8806: x_return_status := FND_API.g_ret_sts_error ;
8807: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8808: p_data => x_error_message);
8809:
8810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8811: ROLLBACK TO setup_product_spread;

Line 8813: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8809:
8810: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8811: ROLLBACK TO setup_product_spread;
8812: x_return_status := FND_API.g_ret_sts_unexp_error ;
8813: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8814: p_data => x_error_message);
8815:
8816: WHEN OTHERS THEN
8817: ROLLBACK TO setup_product_spread;

Line 8822: FND_MSG_PUB.add;

8818:
8819: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8820: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8821: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8822: FND_MSG_PUB.add;
8823:
8824: x_return_status := FND_API.g_ret_sts_unexp_error ;
8825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8826: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 8825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8821: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8822: FND_MSG_PUB.add;
8823:
8824: x_return_status := FND_API.g_ret_sts_unexp_error ;
8825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8826: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8827: END IF;
8828: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8829: p_data => x_error_message);

Line 8826: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

8822: FND_MSG_PUB.add;
8823:
8824: x_return_status := FND_API.g_ret_sts_unexp_error ;
8825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8826: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8827: END IF;
8828: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8829: p_data => x_error_message);
8830: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 8828: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8824: x_return_status := FND_API.g_ret_sts_unexp_error ;
8825: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8826: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8827: END IF;
8828: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8829: p_data => x_error_message);
8830: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
8831:
8832: END setup_product_spread;

Line 8891: FND_MSG_PUB.initialize;

8887: END IF;
8888:
8889: -- Initialize message list if p_init_msg_list is set to TRUE.
8890: IF FND_API.to_Boolean( p_init_msg_list ) THEN
8891: FND_MSG_PUB.initialize;
8892: END IF;
8893:
8894: -- Initialize API return status to SUCCESS
8895: x_return_status := FND_API.g_ret_sts_success;

Line 8962: FND_MSG_PUB.add;

8958:
8959: WHEN OZF_TP_INVALID_PARAM THEN
8960: ROLLBACK TO cascade_product_spread;
8961: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8962: FND_MSG_PUB.add;
8963: x_return_status := FND_API.g_ret_sts_error ;
8964: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8965: p_data => x_error_message);
8966: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 8964: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8960: ROLLBACK TO cascade_product_spread;
8961: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8962: FND_MSG_PUB.add;
8963: x_return_status := FND_API.g_ret_sts_error ;
8964: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8965: p_data => x_error_message);
8966: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8967: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8968:

Line 8972: FND_MSG_PUB.count_and_get (p_count => x_error_number,

8968:
8969: WHEN FND_API.G_EXC_ERROR THEN
8970: ROLLBACK TO cascade_product_spread;
8971: x_return_status := FND_API.g_ret_sts_error ;
8972: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8973: p_data => x_error_message);
8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976: ROLLBACK TO cascade_product_spread;

Line 8978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8974:
8975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8976: ROLLBACK TO cascade_product_spread;
8977: x_return_status := FND_API.g_ret_sts_unexp_error ;
8978: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8979: p_data => x_error_message);
8980:
8981: WHEN OTHERS THEN
8982: ROLLBACK TO cascade_product_spread;

Line 8987: FND_MSG_PUB.add;

8983:
8984: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8985: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8986: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8987: FND_MSG_PUB.add;
8988:
8989: x_return_status := FND_API.g_ret_sts_unexp_error ;
8990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8991: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 8990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8986: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8987: FND_MSG_PUB.add;
8988:
8989: x_return_status := FND_API.g_ret_sts_unexp_error ;
8990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8991: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8992: END IF;
8993: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8994: p_data => x_error_message);

Line 8991: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

8987: FND_MSG_PUB.add;
8988:
8989: x_return_status := FND_API.g_ret_sts_unexp_error ;
8990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8991: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8992: END IF;
8993: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8994: p_data => x_error_message);
8995: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 8993: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

8989: x_return_status := FND_API.g_ret_sts_unexp_error ;
8990: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8991: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
8992: END IF;
8993: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
8994: p_data => x_error_message);
8995: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
8996:
8997: END cascade_product_spread;

Line 9063: FND_MSG_PUB.initialize;

9059: END IF;
9060:
9061: -- Initialize message list if p_init_msg_list is set to TRUE.
9062: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9063: FND_MSG_PUB.initialize;
9064: END IF;
9065:
9066: -- Initialize API return status to SUCCESS
9067: x_return_status := FND_API.g_ret_sts_success;

Line 9159: FND_MSG_PUB.add;

9155:
9156: WHEN OZF_TP_INVALID_PARAM THEN
9157: ROLLBACK TO allocate_target;
9158: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
9159: FND_MSG_PUB.add;
9160: x_return_status := FND_API.g_ret_sts_error ;
9161: FND_MSG_PUB.count_and_get (p_count => x_error_number,
9162: p_data => x_error_message);
9163: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 9161: FND_MSG_PUB.count_and_get (p_count => x_error_number,

9157: ROLLBACK TO allocate_target;
9158: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
9159: FND_MSG_PUB.add;
9160: x_return_status := FND_API.g_ret_sts_error ;
9161: FND_MSG_PUB.count_and_get (p_count => x_error_number,
9162: p_data => x_error_message);
9163: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
9164: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
9165:

Line 9169: FND_MSG_PUB.count_and_get (p_count => x_error_number,

9165:
9166: WHEN FND_API.G_EXC_ERROR THEN
9167: ROLLBACK TO allocate_target;
9168: x_return_status := FND_API.g_ret_sts_error ;
9169: FND_MSG_PUB.count_and_get (p_count => x_error_number,
9170: p_data => x_error_message);
9171:
9172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9173: ROLLBACK TO allocate_target;

Line 9175: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

9171:
9172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9173: ROLLBACK TO allocate_target;
9174: x_return_status := FND_API.g_ret_sts_unexp_error ;
9175: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
9176: p_data => x_error_message);
9177:
9178: WHEN OTHERS THEN
9179: ROLLBACK TO allocate_target;

Line 9184: FND_MSG_PUB.add;

9180:
9181: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
9182: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
9183: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
9184: FND_MSG_PUB.add;
9185:
9186: x_return_status := FND_API.g_ret_sts_unexp_error ;
9187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9188: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 9187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9183: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
9184: FND_MSG_PUB.add;
9185:
9186: x_return_status := FND_API.g_ret_sts_unexp_error ;
9187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9188: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
9189: END IF;
9190: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
9191: p_data => x_error_message);

Line 9188: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

9184: FND_MSG_PUB.add;
9185:
9186: x_return_status := FND_API.g_ret_sts_unexp_error ;
9187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9188: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
9189: END IF;
9190: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
9191: p_data => x_error_message);
9192: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 9190: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

9186: x_return_status := FND_API.g_ret_sts_unexp_error ;
9187: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9188: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
9189: END IF;
9190: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
9191: p_data => x_error_message);
9192: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
9193:
9194: END allocate_target;

Line 9559: FND_MSG_PUB.initialize;

9555: END IF;
9556:
9557: -- Initialize message list if p_init_msg_list is set to TRUE.
9558: IF FND_API.to_Boolean( p_init_msg_list ) THEN
9559: FND_MSG_PUB.initialize;
9560: END IF;
9561:
9562: -- Initialize API return status to SUCCESS
9563: x_return_status := FND_API.g_ret_sts_success;

Line 10229: FND_MSG_PUB.add;

10225:
10226: WHEN OZF_TP_INVALID_PARAM THEN
10227: ROLLBACK TO adjust_target_for_acct_added;
10228: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10229: FND_MSG_PUB.add;
10230: x_return_status := FND_API.g_ret_sts_error ;
10231: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10232: p_data => x_error_message);
10233: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 10231: FND_MSG_PUB.count_and_get (p_count => x_error_number,

10227: ROLLBACK TO adjust_target_for_acct_added;
10228: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10229: FND_MSG_PUB.add;
10230: x_return_status := FND_API.g_ret_sts_error ;
10231: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10232: p_data => x_error_message);
10233: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
10234: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
10235:

Line 10239: FND_MSG_PUB.count_and_get (p_count => x_error_number,

10235:
10236: WHEN FND_API.G_EXC_ERROR THEN
10237: ROLLBACK TO adjust_target_for_acct_added;
10238: x_return_status := FND_API.g_ret_sts_error ;
10239: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10240: p_data => x_error_message);
10241:
10242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10243: ROLLBACK TO adjust_target_for_acct_added;

Line 10245: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

10241:
10242: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10243: ROLLBACK TO adjust_target_for_acct_added;
10244: x_return_status := FND_API.g_ret_sts_unexp_error ;
10245: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10246: p_data => x_error_message);
10247:
10248: WHEN OTHERS THEN
10249: ROLLBACK TO adjust_target_for_acct_added;

Line 10254: FND_MSG_PUB.add;

10250:
10251: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10252: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10253: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10254: FND_MSG_PUB.add;
10255:
10256: x_return_status := FND_API.g_ret_sts_unexp_error ;
10257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10258: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 10257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10253: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10254: FND_MSG_PUB.add;
10255:
10256: x_return_status := FND_API.g_ret_sts_unexp_error ;
10257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10258: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10259: END IF;
10260: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10261: p_data => x_error_message);

Line 10258: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

10254: FND_MSG_PUB.add;
10255:
10256: x_return_status := FND_API.g_ret_sts_unexp_error ;
10257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10258: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10259: END IF;
10260: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10261: p_data => x_error_message);
10262: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 10260: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

10256: x_return_status := FND_API.g_ret_sts_unexp_error ;
10257: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10258: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10259: END IF;
10260: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10261: p_data => x_error_message);
10262: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
10263:
10264: END adjust_target_for_acct_added;

Line 10314: FND_MSG_PUB.initialize;

10310: END IF;
10311:
10312: -- Initialize message list if p_init_msg_list is set to TRUE.
10313: IF FND_API.to_Boolean( p_init_msg_list ) THEN
10314: FND_MSG_PUB.initialize;
10315: END IF;
10316:
10317: -- Initialize API return status to SUCCESS
10318: x_return_status := FND_API.g_ret_sts_success;

Line 10520: FND_MSG_PUB.add;

10516:
10517: WHEN OZF_TP_INVALID_PARAM THEN
10518: ROLLBACK TO adjust_target_for_acct_deleted;
10519: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10520: FND_MSG_PUB.add;
10521: x_return_status := FND_API.g_ret_sts_error ;
10522: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10523: p_data => x_error_message);
10524: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));

Line 10522: FND_MSG_PUB.count_and_get (p_count => x_error_number,

10518: ROLLBACK TO adjust_target_for_acct_deleted;
10519: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10520: FND_MSG_PUB.add;
10521: x_return_status := FND_API.g_ret_sts_error ;
10522: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10523: p_data => x_error_message);
10524: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
10525: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
10526:

Line 10530: FND_MSG_PUB.count_and_get (p_count => x_error_number,

10526:
10527: WHEN FND_API.G_EXC_ERROR THEN
10528: ROLLBACK TO adjust_target_for_acct_deleted;
10529: x_return_status := FND_API.g_ret_sts_error ;
10530: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10531: p_data => x_error_message);
10532:
10533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10534: ROLLBACK TO adjust_target_for_acct_deleted;

Line 10536: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

10532:
10533: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10534: ROLLBACK TO adjust_target_for_acct_deleted;
10535: x_return_status := FND_API.g_ret_sts_unexp_error ;
10536: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10537: p_data => x_error_message);
10538:
10539: WHEN OTHERS THEN
10540: ROLLBACK TO adjust_target_for_acct_deleted;

Line 10545: FND_MSG_PUB.add;

10541:
10542: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10543: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10544: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10545: FND_MSG_PUB.add;
10546:
10547: x_return_status := FND_API.g_ret_sts_unexp_error ;
10548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10549: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 10548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10544: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10545: FND_MSG_PUB.add;
10546:
10547: x_return_status := FND_API.g_ret_sts_unexp_error ;
10548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10549: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10550: END IF;
10551: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10552: p_data => x_error_message);

Line 10549: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

10545: FND_MSG_PUB.add;
10546:
10547: x_return_status := FND_API.g_ret_sts_unexp_error ;
10548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10549: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10550: END IF;
10551: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10552: p_data => x_error_message);
10553: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 10551: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

10547: x_return_status := FND_API.g_ret_sts_unexp_error ;
10548: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10549: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
10550: END IF;
10551: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
10552: p_data => x_error_message);
10553: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
10554:
10555: END adjust_target_for_acct_deleted;

Line 10872: FND_MSG_PUB.initialize;

10868: END IF;
10869:
10870: -- Initialize message list if l_init_msg_list is set to TRUE.
10871: IF FND_API.to_Boolean( l_init_msg_list ) THEN
10872: FND_MSG_PUB.initialize;
10873: END IF;
10874:
10875: -- Initialize API return status to SUCCESS
10876: x_return_status := FND_API.g_ret_sts_success;

Line 11028: FND_MSG_PUB.count_and_get (p_count => x_error_number,

11024:
11025: WHEN FND_API.G_EXC_ERROR THEN
11026: ROLLBACK TO adjust_account_targets;
11027: x_return_status := FND_API.g_ret_sts_error ;
11028: FND_MSG_PUB.count_and_get (p_count => x_error_number,
11029: p_data => x_error_message);
11030:
11031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11032: ROLLBACK TO adjust_account_targets;

Line 11034: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

11030:
11031: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
11032: ROLLBACK TO adjust_account_targets;
11033: x_return_status := FND_API.g_ret_sts_unexp_error ;
11034: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
11035: p_data => x_error_message);
11036:
11037: WHEN OTHERS THEN
11038: ROLLBACK TO adjust_account_targets;

Line 11043: FND_MSG_PUB.add;

11039:
11040: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
11041: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
11042: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
11043: FND_MSG_PUB.add;
11044:
11045: x_return_status := FND_API.g_ret_sts_unexp_error ;
11046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11047: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

Line 11046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

11042: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
11043: FND_MSG_PUB.add;
11044:
11045: x_return_status := FND_API.g_ret_sts_unexp_error ;
11046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11047: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
11048: END IF;
11049: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
11050: p_data => x_error_message);

Line 11047: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);

11043: FND_MSG_PUB.add;
11044:
11045: x_return_status := FND_API.g_ret_sts_unexp_error ;
11046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11047: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
11048: END IF;
11049: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
11050: p_data => x_error_message);
11051: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));

Line 11049: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,

11045: x_return_status := FND_API.g_ret_sts_unexp_error ;
11046: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
11047: FND_MSG_PUB.Add_Exc_Msg (g_pkg_name, l_api_name);
11048: END IF;
11049: FND_MSG_PUB.Count_And_Get (p_count => x_error_number,
11050: p_data => x_error_message);
11051: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : OTHERS EXCEPTION = '||sqlerrm(sqlcode));
11052:
11053: END adjust_account_targets;