DBA Data[Home] [Help]

APPS.OZF_ALLOCATION_ENGINE_PVT dependencies on FND_MESSAGE

Line 731: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');

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

Line 732: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);

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;
735: END IF;
736: RAISE fnd_api.g_exc_unexpected_error;

Line 733: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);

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;
735: END IF;
736: RAISE fnd_api.g_exc_unexpected_error;
737: END IF;

Line 749: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');

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

Line 750: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);

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;
753: END IF;
754: RAISE fnd_api.g_exc_unexpected_error;

Line 751: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);

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;
753: END IF;
754: RAISE fnd_api.g_exc_unexpected_error;
755: END IF;

Line 776: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 794: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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

Line 1432: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');

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

Line 1433: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');

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;
1436: END IF;
1437: RAISE fnd_api.g_exc_unexpected_error;

Line 1434: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);

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;
1436: END IF;
1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;

Line 1453: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');

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

Line 1454: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');

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;
1457: END IF;
1458: RAISE fnd_api.g_exc_unexpected_error;

Line 1455: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);

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;
1457: END IF;
1458: RAISE fnd_api.g_exc_unexpected_error;
1459: END IF;

Line 1475: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');

1471:
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);

Line 1481: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));

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

Line 1485: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');

1481: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
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);

Line 1491: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));

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

Line 2142: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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:
2146: RAISE fnd_api.g_exc_unexpected_error;

Line 2163: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
2167: RAISE fnd_api.g_exc_unexpected_error;

Line 2193: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
2197: RAISE fnd_api.g_exc_unexpected_error;

Line 2215: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 2236: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
2240: RAISE fnd_api.g_exc_unexpected_error;

Line 2296: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 2314: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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

Line 2336: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');

2332:
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);

Line 2342: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));

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

Line 2346: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');

2342: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
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);

Line 2352: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));

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

Line 3156: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
3160: RAISE fnd_api.g_exc_unexpected_error;

Line 3178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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:
3182: RAISE fnd_api.g_exc_unexpected_error;

Line 3200: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
3204: RAISE fnd_api.g_exc_unexpected_error;

Line 3231: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
3235: RAISE fnd_api.g_exc_unexpected_error;

Line 3253: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 3275: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
3279: RAISE fnd_api.g_exc_unexpected_error;

Line 3435: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 3452: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');

3448:
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);

Line 3458: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));

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

Line 3619: FND_MESSAGE.set_name('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT');

3615:
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);

Line 3624: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('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
3627: ROLLBACK TO publish_fact_product_spread;
3628: x_return_status := FND_API.g_ret_sts_error ;

Line 3953: FND_MESSAGE.set_name('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT');

3949:
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);

Line 3958: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('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
3961: ROLLBACK TO delete_cascade_product_spread;
3962: x_return_status := FND_API.g_ret_sts_error ;

Line 4389: FND_MESSAGE.set_name('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT');

4385:
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);

Line 4394: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('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
4397: ROLLBACK TO add_cascade_product_spread;
4398: x_return_status := FND_API.g_ret_sts_error ;

Line 4744: FND_MESSAGE.set_name('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT');

4740:
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);

Line 4749: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('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
4752: ROLLBACK TO delete_single_product;
4753: x_return_status := FND_API.g_ret_sts_error ;

Line 5952: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');

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

Line 5953: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');

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;
5956: END IF;
5957: RAISE fnd_api.g_exc_unexpected_error;

Line 5954: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);

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;
5956: END IF;
5957: RAISE fnd_api.g_exc_unexpected_error;
5958: END IF;

Line 5978: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

5974: EXCEPTION
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);

Line 5984: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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

Line 6001: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

5997:
5998: WHEN OTHERS THEN
5999: ROLLBACK TO old_allocate_target_first_time;
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:

Line 6002: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

5998: WHEN OTHERS THEN
5999: ROLLBACK TO old_allocate_target_first_time;
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 ;

Line 6003: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

5999: ROLLBACK TO old_allocate_target_first_time;
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

Line 6717: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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:
6721: RAISE fnd_api.g_exc_unexpected_error;

Line 6948: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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:
6952: RAISE fnd_api.g_exc_unexpected_error;

Line 6969: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
6973: RAISE fnd_api.g_exc_unexpected_error;

Line 6999: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
7003: RAISE fnd_api.g_exc_unexpected_error;

Line 7022: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 7043: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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:
7047: RAISE fnd_api.g_exc_unexpected_error;

Line 7135: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 7151: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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

Line 7178: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 7196: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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

Line 7387: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');

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

Line 7388: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');

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;
7391: END IF;
7392: RAISE fnd_api.g_exc_unexpected_error;

Line 7389: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);

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;
7391: END IF;
7392: RAISE fnd_api.g_exc_unexpected_error;
7393: END IF;

Line 7449: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 7468: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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:
7472: RAISE fnd_api.g_exc_unexpected_error;

Line 7528: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');

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

Line 7529: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');

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;
7532: END IF;
7533: RAISE fnd_api.g_exc_unexpected_error;

Line 7530: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);

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;
7532: END IF;
7533: RAISE fnd_api.g_exc_unexpected_error;
7534: END IF;

Line 7549: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');

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

Line 7550: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');

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;
7553: END IF;
7554: RAISE fnd_api.g_exc_unexpected_error;

Line 7551: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);

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;
7553: END IF;
7554: RAISE fnd_api.g_exc_unexpected_error;
7555: END IF;

Line 7611: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');

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

Line 7627: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');

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

Line 7647: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

7643: EXCEPTION
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);

Line 7653: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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

Line 7670: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

7666:
7667: WHEN OTHERS THEN
7668: ROLLBACK TO allocate_target_first_time;
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:

Line 7671: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

7667: WHEN OTHERS THEN
7668: ROLLBACK TO allocate_target_first_time;
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 ;

Line 7672: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

7668: ROLLBACK TO allocate_target_first_time;
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

Line 8567: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

8563: EXCEPTION
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);

Line 8573: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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:
8575: WHEN FND_API.G_EXC_ERROR THEN
8576: ROLLBACK TO allocate_target_addon;
8577: x_return_status := FND_API.g_ret_sts_error ;

Line 8590: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

8586:
8587: WHEN OTHERS THEN
8588: ROLLBACK TO allocate_target_addon;
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:

Line 8591: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

8587: WHEN OTHERS THEN
8588: ROLLBACK TO allocate_target_addon;
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 ;

Line 8592: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

8588: ROLLBACK TO allocate_target_addon;
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

Line 8796: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

8792: EXCEPTION
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);

Line 8802: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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:
8804: WHEN FND_API.G_EXC_ERROR THEN
8805: ROLLBACK TO setup_product_spread;
8806: x_return_status := FND_API.g_ret_sts_error ;

Line 8819: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

8815:
8816: WHEN OTHERS THEN
8817: ROLLBACK TO setup_product_spread;
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:

Line 8820: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

8816: WHEN OTHERS THEN
8817: ROLLBACK TO setup_product_spread;
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 ;

Line 8821: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

8817: ROLLBACK TO setup_product_spread;
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

Line 8961: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

8957: EXCEPTION
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);

Line 8967: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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:
8969: WHEN FND_API.G_EXC_ERROR THEN
8970: ROLLBACK TO cascade_product_spread;
8971: x_return_status := FND_API.g_ret_sts_error ;

Line 8984: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

8980:
8981: WHEN OTHERS THEN
8982: ROLLBACK TO cascade_product_spread;
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:

Line 8985: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

8981: WHEN OTHERS THEN
8982: ROLLBACK TO cascade_product_spread;
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 ;

Line 8986: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

8982: ROLLBACK TO cascade_product_spread;
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

Line 9158: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

9154: EXCEPTION
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);

Line 9164: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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:
9166: WHEN FND_API.G_EXC_ERROR THEN
9167: ROLLBACK TO allocate_target;
9168: x_return_status := FND_API.g_ret_sts_error ;

Line 9181: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

9177:
9178: WHEN OTHERS THEN
9179: ROLLBACK TO allocate_target;
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:

Line 9182: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

9178: WHEN OTHERS THEN
9179: ROLLBACK TO allocate_target;
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 ;

Line 9183: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

9179: ROLLBACK TO allocate_target;
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

Line 10228: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

10224: EXCEPTION
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);

Line 10234: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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

Line 10251: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

10247:
10248: WHEN OTHERS THEN
10249: ROLLBACK TO adjust_target_for_acct_added;
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:

Line 10252: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

10248: WHEN OTHERS THEN
10249: ROLLBACK TO adjust_target_for_acct_added;
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 ;

Line 10253: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

10249: ROLLBACK TO adjust_target_for_acct_added;
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

Line 10519: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');

10515: EXCEPTION
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);

Line 10525: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));

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

Line 10542: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

10538:
10539: WHEN OTHERS THEN
10540: ROLLBACK TO adjust_target_for_acct_deleted;
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:

Line 10543: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

10539: WHEN OTHERS THEN
10540: ROLLBACK TO adjust_target_for_acct_deleted;
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 ;

Line 10544: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

10540: ROLLBACK TO adjust_target_for_acct_deleted;
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

Line 11040: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');

11036:
11037: WHEN OTHERS THEN
11038: ROLLBACK TO adjust_account_targets;
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:

Line 11041: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);

11037: WHEN OTHERS THEN
11038: ROLLBACK TO adjust_account_targets;
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 ;

Line 11042: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);

11038: ROLLBACK TO adjust_account_targets;
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