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_MESSAGE

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

708:
709:
710: IF (SQL%NOTFOUND) THEN
711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
712: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
713: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
714: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
715: fnd_msg_pub.ADD;
716: END IF;

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

709:
710: IF (SQL%NOTFOUND) THEN
711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
712: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
713: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
714: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
715: fnd_msg_pub.ADD;
716: END IF;
717: RAISE fnd_api.g_exc_unexpected_error;

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

710: IF (SQL%NOTFOUND) THEN
711: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
712: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
713: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
714: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
715: fnd_msg_pub.ADD;
716: END IF;
717: RAISE fnd_api.g_exc_unexpected_error;
718: END IF;

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

726: WHERE p.product_allocation_id = l_temp_product_allocation_id;
727:
728: IF (SQL%NOTFOUND) THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
730: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
731: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
732: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
733: fnd_msg_pub.ADD;
734: END IF;

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

727:
728: IF (SQL%NOTFOUND) THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
730: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
731: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
732: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
733: fnd_msg_pub.ADD;
734: END IF;
735: RAISE fnd_api.g_exc_unexpected_error;

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

728: IF (SQL%NOTFOUND) THEN
729: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
730: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_PROD_ERR');
731: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN',l_object_type);
732: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_object_id);
733: fnd_msg_pub.ADD;
734: END IF;
735: RAISE fnd_api.g_exc_unexpected_error;
736: END IF;

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

753:
754:
755: IF (SQL%NOTFOUND) THEN
756: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
757: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
758: fnd_msg_pub.ADD;
759: END IF;
760: RAISE fnd_api.g_exc_unexpected_error;
761: END IF;

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

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

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

1407: );
1408:
1409: IF (SQL%NOTFOUND) THEN
1410: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1411: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
1412: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1413: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1414: fnd_msg_pub.ADD;
1415: END IF;

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

1408:
1409: IF (SQL%NOTFOUND) THEN
1410: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1411: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
1412: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1413: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1414: fnd_msg_pub.ADD;
1415: END IF;
1416: RAISE fnd_api.g_exc_unexpected_error;

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

1409: IF (SQL%NOTFOUND) THEN
1410: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
1411: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
1412: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','FACT');
1413: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fact_id);
1414: fnd_msg_pub.ADD;
1415: END IF;
1416: RAISE fnd_api.g_exc_unexpected_error;
1417: END IF;

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

1428: AND p.item_id = -9999;
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_PROD_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_PROD_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_PROD_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 1454: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');

1450:
1451: EXCEPTION
1452: WHEN OZF_TP_DIFF_TIME_SPREAD THEN
1453: ROLLBACK TO create_old_fact_product_spread;
1454: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
1455: FND_MSG_PUB.add;
1456: x_return_status := FND_API.g_ret_sts_error ;
1457: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1458: p_data => x_error_message);

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

1456: x_return_status := FND_API.g_ret_sts_error ;
1457: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1458: p_data => x_error_message);
1459: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));
1460: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
1461:
1462: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
1463: ROLLBACK TO create_old_fact_product_spread;
1464: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');

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

1460: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
1461:
1462: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
1463: ROLLBACK TO create_old_fact_product_spread;
1464: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
1465: FND_MSG_PUB.add;
1466: x_return_status := FND_API.g_ret_sts_error ;
1467: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1468: p_data => x_error_message);

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

1466: x_return_status := FND_API.g_ret_sts_error ;
1467: FND_MSG_PUB.count_and_get (p_count => x_error_number,
1468: p_data => x_error_message);
1469: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
1470: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
1471:
1472: WHEN FND_API.G_EXC_ERROR THEN
1473: ROLLBACK TO create_old_fact_product_spread;
1474: x_return_status := FND_API.g_ret_sts_error ;

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

2115: AND p.allocation_for_id = l_fact_id );
2116:
2117: IF (SQL%NOTFOUND) THEN
2118: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2119: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2120: fnd_msg_pub.ADD;
2121: END IF;
2122:
2123: RAISE fnd_api.g_exc_unexpected_error;

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

2136: AND p.allocation_for_id = l_fact_id;
2137:
2138: IF (SQL%NOTFOUND) THEN
2139: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2140: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2141: fnd_msg_pub.ADD;
2142: END IF;
2143:
2144: RAISE fnd_api.g_exc_unexpected_error;

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

2166: AND p.item_id = -9999;
2167:
2168: IF (SQL%NOTFOUND) THEN
2169: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2170: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2171: fnd_msg_pub.ADD;
2172: END IF;
2173:
2174: RAISE fnd_api.g_exc_unexpected_error;

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

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

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

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

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

2269:
2270:
2271: IF (SQL%NOTFOUND) THEN
2272: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2273: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
2274: fnd_msg_pub.ADD;
2275: END IF;
2276: RAISE fnd_api.g_exc_unexpected_error;
2277: END IF;

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

2287: AND p.item_id = -9999;
2288:
2289: IF (SQL%NOTFOUND) THEN
2290: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
2291: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
2292: fnd_msg_pub.ADD;
2293: END IF;
2294: RAISE fnd_api.g_exc_unexpected_error;
2295: END IF;

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

2309:
2310: EXCEPTION
2311: WHEN OZF_TP_DIFF_TIME_SPREAD THEN
2312: ROLLBACK TO create_fact_product_spread;
2313: FND_MESSAGE.set_name('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT');
2314: FND_MSG_PUB.add;
2315: x_return_status := FND_API.g_ret_sts_error ;
2316: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2317: p_data => x_error_message);

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

2315: x_return_status := FND_API.g_ret_sts_error ;
2316: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2317: p_data => x_error_message);
2318: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : TIME SPREAD MISMATCH EXCEPTION = '||sqlerrm(sqlcode));
2319: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
2320:
2321: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
2322: ROLLBACK TO create_fact_product_spread;
2323: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');

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

2319: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DIFF_TIME_SPREAD_TXT'));
2320:
2321: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
2322: ROLLBACK TO create_fact_product_spread;
2323: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
2324: FND_MSG_PUB.add;
2325: x_return_status := FND_API.g_ret_sts_error ;
2326: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2327: p_data => x_error_message);

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

2325: x_return_status := FND_API.g_ret_sts_error ;
2326: FND_MSG_PUB.count_and_get (p_count => x_error_number,
2327: p_data => x_error_message);
2328: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
2329: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
2330:
2331: WHEN FND_API.G_EXC_ERROR THEN
2332: ROLLBACK TO create_fact_product_spread;
2333: x_return_status := FND_API.g_ret_sts_error ;

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

3127: AND p.allocation_for_id = l_fund_id;
3128:
3129: IF (SQL%NOTFOUND) THEN
3130: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3131: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3132: fnd_msg_pub.ADD;
3133: END IF;
3134:
3135: RAISE fnd_api.g_exc_unexpected_error;

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

3149: AND p.allocation_for_id = l_fund_id );
3150:
3151: IF (SQL%NOTFOUND) THEN
3152: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3153: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3154: fnd_msg_pub.ADD;
3155: END IF;
3156:
3157: RAISE fnd_api.g_exc_unexpected_error;

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

3171: AND p.allocation_for_id = l_fund_id;
3172:
3173: IF (SQL%NOTFOUND) THEN
3174: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3175: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3176: fnd_msg_pub.ADD;
3177: END IF;
3178:
3179: RAISE fnd_api.g_exc_unexpected_error;

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

3202: AND p.item_id = -9999;
3203:
3204: IF (SQL%NOTFOUND) THEN
3205: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3206: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
3207: fnd_msg_pub.ADD;
3208: END IF;
3209:
3210: RAISE fnd_api.g_exc_unexpected_error;

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

3224: AND p.item_id = -9999 );
3225:
3226: IF (SQL%NOTFOUND) THEN
3227: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3228: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3229: fnd_msg_pub.ADD;
3230: END IF;
3231: RAISE fnd_api.g_exc_unexpected_error;
3232: END IF;

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

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

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

3406: );
3407:
3408: IF (SQL%NOTFOUND) THEN
3409: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
3410: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
3411: fnd_msg_pub.ADD;
3412: END IF;
3413: RAISE fnd_api.g_exc_unexpected_error;
3414: END IF;

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

3423:
3424: EXCEPTION
3425: WHEN OZF_TP_BLANK_PERIOD_TBL THEN
3426: ROLLBACK TO create_root_product_spread;
3427: FND_MESSAGE.set_name('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT');
3428: FND_MSG_PUB.add;
3429: x_return_status := FND_API.g_ret_sts_error ;
3430: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3431: p_data => x_error_message);

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

3429: x_return_status := FND_API.g_ret_sts_error ;
3430: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3431: p_data => x_error_message);
3432: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : BLANK PERIOD TABLE EXCEPTION = '||sqlerrm(sqlcode));
3433: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_BLANK_PERIOD_TBL_TXT'));
3434:
3435: WHEN FND_API.G_EXC_ERROR THEN
3436: ROLLBACK TO create_root_product_spread;
3437: x_return_status := FND_API.g_ret_sts_error ;

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

3590:
3591: EXCEPTION
3592: WHEN OZF_TP_OPER_NOT_ALLOWED THEN
3593: ROLLBACK TO publish_fact_product_spread;
3594: FND_MESSAGE.set_name('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT');
3595: FND_MSG_PUB.add;
3596: x_return_status := FND_API.g_ret_sts_error ;
3597: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3598: p_data => x_error_message);

Line 3599: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT'));

3595: FND_MSG_PUB.add;
3596: x_return_status := FND_API.g_ret_sts_error ;
3597: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3598: p_data => x_error_message);
3599: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_OPER_NOT_ALLOWED_TXT'));
3600:
3601: WHEN FND_API.G_EXC_ERROR THEN
3602: ROLLBACK TO publish_fact_product_spread;
3603: x_return_status := FND_API.g_ret_sts_error ;

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

3924:
3925: EXCEPTION
3926: WHEN OZF_TP_CHG_PS_NOT_ALLOWED THEN
3927: ROLLBACK TO delete_cascade_product_spread;
3928: FND_MESSAGE.set_name('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT');
3929: FND_MSG_PUB.add;
3930: x_return_status := FND_API.g_ret_sts_error ;
3931: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3932: p_data => x_error_message);

Line 3933: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT'));

3929: FND_MSG_PUB.add;
3930: x_return_status := FND_API.g_ret_sts_error ;
3931: FND_MSG_PUB.count_and_get (p_count => x_error_number,
3932: p_data => x_error_message);
3933: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_CHG_PS_NOT_ALLOWED_TXT'));
3934:
3935: WHEN FND_API.G_EXC_ERROR THEN
3936: ROLLBACK TO delete_cascade_product_spread;
3937: x_return_status := FND_API.g_ret_sts_error ;

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

4358:
4359: EXCEPTION
4360: WHEN OZF_TP_ADDITEM_NOT_ALLOWED THEN
4361: ROLLBACK TO add_cascade_product_spread;
4362: FND_MESSAGE.set_name('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT');
4363: FND_MSG_PUB.add;
4364: x_return_status := FND_API.g_ret_sts_error ;
4365: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4366: p_data => x_error_message);

Line 4367: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT'));

4363: FND_MSG_PUB.add;
4364: x_return_status := FND_API.g_ret_sts_error ;
4365: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4366: p_data => x_error_message);
4367: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_ADDITEM_NOT_ALLOWED_TXT'));
4368:
4369: WHEN FND_API.G_EXC_ERROR THEN
4370: ROLLBACK TO add_cascade_product_spread;
4371: x_return_status := FND_API.g_ret_sts_error ;

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

4713:
4714: EXCEPTION
4715: WHEN OZF_TP_DELITEM_NOT_ALLOWED THEN
4716: ROLLBACK TO delete_single_product;
4717: FND_MESSAGE.set_name('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT');
4718: FND_MSG_PUB.add;
4719: x_return_status := FND_API.g_ret_sts_error ;
4720: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4721: p_data => x_error_message);

Line 4722: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT'));

4718: FND_MSG_PUB.add;
4719: x_return_status := FND_API.g_ret_sts_error ;
4720: FND_MSG_PUB.count_and_get (p_count => x_error_number,
4721: p_data => x_error_message);
4722: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_DELITEM_NOT_ALLOWED_TXT'));
4723:
4724: WHEN FND_API.G_EXC_ERROR THEN
4725: ROLLBACK TO delete_single_product;
4726: x_return_status := FND_API.g_ret_sts_error ;

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

5919: );
5920:
5921: IF (SQL%NOTFOUND) THEN
5922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5923: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
5924: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
5925: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
5926: fnd_msg_pub.ADD;
5927: END IF;

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

5920:
5921: IF (SQL%NOTFOUND) THEN
5922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5923: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
5924: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
5925: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
5926: fnd_msg_pub.ADD;
5927: END IF;
5928: RAISE fnd_api.g_exc_unexpected_error;

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

5921: IF (SQL%NOTFOUND) THEN
5922: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
5923: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
5924: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
5925: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
5926: fnd_msg_pub.ADD;
5927: END IF;
5928: RAISE fnd_api.g_exc_unexpected_error;
5929: END IF;

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

5945: EXCEPTION
5946:
5947: WHEN OZF_TP_INVALID_PARAM THEN
5948: ROLLBACK TO old_allocate_target_first_time;
5949: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
5950: FND_MSG_PUB.add;
5951: x_return_status := FND_API.g_ret_sts_error ;
5952: FND_MSG_PUB.count_and_get (p_count => x_error_number,
5953: p_data => x_error_message);

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

5951: x_return_status := FND_API.g_ret_sts_error ;
5952: FND_MSG_PUB.count_and_get (p_count => x_error_number,
5953: p_data => x_error_message);
5954: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
5955: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
5956:
5957: WHEN FND_API.G_EXC_ERROR THEN
5958: ROLLBACK TO old_allocate_target_first_time;
5959: x_return_status := FND_API.g_ret_sts_error ;

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

5968:
5969: WHEN OTHERS THEN
5970: ROLLBACK TO old_allocate_target_first_time;
5971:
5972: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
5973: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
5974: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
5975: FND_MSG_PUB.add;
5976:

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

5969: WHEN OTHERS THEN
5970: ROLLBACK TO old_allocate_target_first_time;
5971:
5972: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
5973: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
5974: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
5975: FND_MSG_PUB.add;
5976:
5977: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

5970: ROLLBACK TO old_allocate_target_first_time;
5971:
5972: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
5973: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
5974: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
5975: FND_MSG_PUB.add;
5976:
5977: x_return_status := FND_API.g_ret_sts_unexp_error ;
5978: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

6682: WHERE a.account_allocation_id = l_account_allocation_id;
6683:
6684: IF (SQL%NOTFOUND) THEN
6685: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6686: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6687: fnd_msg_pub.ADD;
6688: END IF;
6689:
6690: RAISE fnd_api.g_exc_unexpected_error;

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

6913: AND p.allocation_for_id = l_account_allocation_id);
6914:
6915: IF (SQL%NOTFOUND) THEN
6916: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6917: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6918: fnd_msg_pub.ADD;
6919: END IF;
6920:
6921: RAISE fnd_api.g_exc_unexpected_error;

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

6934: AND p.allocation_for_id = l_account_allocation_id;
6935:
6936: IF (SQL%NOTFOUND) THEN
6937: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6938: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
6939: fnd_msg_pub.ADD;
6940: END IF;
6941:
6942: RAISE fnd_api.g_exc_unexpected_error;

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

6964: AND p.item_id = -9999;
6965:
6966: IF (SQL%NOTFOUND) THEN
6967: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6968: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
6969: fnd_msg_pub.ADD;
6970: END IF;
6971:
6972: RAISE fnd_api.g_exc_unexpected_error;

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

6987: AND p.item_id = -9999 );
6988:
6989: IF (SQL%NOTFOUND) THEN
6990: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
6991: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
6992: fnd_msg_pub.ADD;
6993: END IF;
6994: RAISE fnd_api.g_exc_unexpected_error;
6995: END IF;

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

7008: AND p.item_id = -9999;
7009:
7010: IF (SQL%NOTFOUND) THEN
7011: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7012: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7013: fnd_msg_pub.ADD;
7014: END IF;
7015:
7016: RAISE fnd_api.g_exc_unexpected_error;

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

7100:
7101:
7102: IF (SQL%NOTFOUND) THEN
7103: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7104: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7105: fnd_msg_pub.ADD;
7106: END IF;
7107: RAISE fnd_api.g_exc_unexpected_error;
7108: END IF;

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

7116: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7117:
7118: IF (SQL%NOTFOUND) THEN
7119: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7120: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7121: fnd_msg_pub.ADD;
7122: END IF;
7123: RAISE fnd_api.g_exc_unexpected_error;
7124: END IF;

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

7143:
7144:
7145: IF (SQL%NOTFOUND) THEN
7146: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7147: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7148: fnd_msg_pub.ADD;
7149: END IF;
7150: RAISE fnd_api.g_exc_unexpected_error;
7151: END IF;

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

7161: AND p.item_id = -9999;
7162:
7163: IF (SQL%NOTFOUND) THEN
7164: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7165: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7166: fnd_msg_pub.ADD;
7167: END IF;
7168: RAISE fnd_api.g_exc_unexpected_error;
7169: END IF;

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

7352: );
7353:
7354: IF (SQL%NOTFOUND) THEN
7355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7356: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7357: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
7358: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7359: fnd_msg_pub.ADD;
7360: END IF;

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

7353:
7354: IF (SQL%NOTFOUND) THEN
7355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7356: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7357: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
7358: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7359: fnd_msg_pub.ADD;
7360: END IF;
7361: RAISE fnd_api.g_exc_unexpected_error;

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

7354: IF (SQL%NOTFOUND) THEN
7355: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7356: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7357: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','UNALLOCATED FUND');
7358: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7359: fnd_msg_pub.ADD;
7360: END IF;
7361: RAISE fnd_api.g_exc_unexpected_error;
7362: END IF;

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

7414: );
7415:
7416: IF (SQL%NOTFOUND) THEN
7417: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7418: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7419: fnd_msg_pub.ADD;
7420: END IF;
7421: RAISE fnd_api.g_exc_unexpected_error;
7422: END IF;

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

7433: AND a.parent_party_id = -9999;
7434:
7435: IF (SQL%NOTFOUND) THEN
7436: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7437: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7438: fnd_msg_pub.ADD;
7439: END IF;
7440:
7441: RAISE fnd_api.g_exc_unexpected_error;

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

7493: RETURNING t.allocation_for_id INTO l_temp_account_allocation_id;
7494:
7495: IF (SQL%NOTFOUND) THEN
7496: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7497: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7498: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');
7499: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7500: fnd_msg_pub.ADD;
7501: END IF;

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

7494:
7495: IF (SQL%NOTFOUND) THEN
7496: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7497: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7498: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');
7499: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7500: fnd_msg_pub.ADD;
7501: END IF;
7502: RAISE fnd_api.g_exc_unexpected_error;

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

7495: IF (SQL%NOTFOUND) THEN
7496: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7497: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_TIME_ERR');
7498: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN','QUOTA');
7499: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN',l_fund_id);
7500: fnd_msg_pub.ADD;
7501: END IF;
7502: RAISE fnd_api.g_exc_unexpected_error;
7503: END IF;

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

7514: WHERE a.account_allocation_id = l_temp_account_allocation_id;
7515:
7516: IF (SQL%NOTFOUND) THEN
7517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7518: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');
7519: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');
7520: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);
7521: fnd_msg_pub.ADD;
7522: END IF;

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

7515:
7516: IF (SQL%NOTFOUND) THEN
7517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7518: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');
7519: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');
7520: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);
7521: fnd_msg_pub.ADD;
7522: END IF;
7523: RAISE fnd_api.g_exc_unexpected_error;

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

7516: IF (SQL%NOTFOUND) THEN
7517: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7518: fnd_message.set_name ('OZF', 'OZF_TP_ROUNDING_ACCT_ERR');
7519: fnd_message.set_token('OZF_TP_OBJECT_TYPE_TOKEN', 'ACCOUNT ALLOCATION');
7520: fnd_message.set_token('OZF_TP_OBJECT_ID_TOKEN', l_temp_account_allocation_id);
7521: fnd_msg_pub.ADD;
7522: END IF;
7523: RAISE fnd_api.g_exc_unexpected_error;
7524: END IF;

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

7576:
7577:
7578: IF (SQL%NOTFOUND) THEN
7579: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7580: fnd_message.set_name ('OZF', 'OZF_TP_TIMEALLOC_NOT_FOUND_TXT');
7581: fnd_msg_pub.ADD;
7582: END IF;
7583: RAISE fnd_api.g_exc_unexpected_error;
7584: END IF;

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

7592: WHERE p.product_allocation_id = l_temp_product_allocation_id;
7593:
7594: IF (SQL%NOTFOUND) THEN
7595: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_error) THEN
7596: fnd_message.set_name ('OZF', 'OZF_TP_PRODALLOC_NOT_FOUND_TXT');
7597: fnd_msg_pub.ADD;
7598: END IF;
7599: RAISE fnd_api.g_exc_unexpected_error;
7600: END IF;

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

7612: EXCEPTION
7613:
7614: WHEN OZF_TP_INVALID_PARAM THEN
7615: ROLLBACK TO allocate_target_first_time;
7616: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
7617: FND_MSG_PUB.add;
7618: x_return_status := FND_API.g_ret_sts_error ;
7619: FND_MSG_PUB.count_and_get (p_count => x_error_number,
7620: p_data => x_error_message);

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

7618: x_return_status := FND_API.g_ret_sts_error ;
7619: FND_MSG_PUB.count_and_get (p_count => x_error_number,
7620: p_data => x_error_message);
7621: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
7622: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
7623:
7624: WHEN FND_API.G_EXC_ERROR THEN
7625: ROLLBACK TO allocate_target_first_time;
7626: x_return_status := FND_API.g_ret_sts_error ;

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

7635:
7636: WHEN OTHERS THEN
7637: ROLLBACK TO allocate_target_first_time;
7638:
7639: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
7640: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
7641: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
7642: FND_MSG_PUB.add;
7643:

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

7636: WHEN OTHERS THEN
7637: ROLLBACK TO allocate_target_first_time;
7638:
7639: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
7640: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
7641: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
7642: FND_MSG_PUB.add;
7643:
7644: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

7637: ROLLBACK TO allocate_target_first_time;
7638:
7639: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
7640: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
7641: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
7642: FND_MSG_PUB.add;
7643:
7644: x_return_status := FND_API.g_ret_sts_unexp_error ;
7645: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

8530: EXCEPTION
8531:
8532: WHEN OZF_TP_INVALID_PARAM THEN
8533: ROLLBACK TO allocate_target_addon;
8534: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8535: FND_MSG_PUB.add;
8536: x_return_status := FND_API.g_ret_sts_error ;
8537: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8538: p_data => x_error_message);

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

8536: x_return_status := FND_API.g_ret_sts_error ;
8537: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8538: p_data => x_error_message);
8539: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8540: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8541:
8542: WHEN FND_API.G_EXC_ERROR THEN
8543: ROLLBACK TO allocate_target_addon;
8544: x_return_status := FND_API.g_ret_sts_error ;

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

8553:
8554: WHEN OTHERS THEN
8555: ROLLBACK TO allocate_target_addon;
8556:
8557: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8558: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8559: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8560: FND_MSG_PUB.add;
8561:

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

8554: WHEN OTHERS THEN
8555: ROLLBACK TO allocate_target_addon;
8556:
8557: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8558: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8559: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8560: FND_MSG_PUB.add;
8561:
8562: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

8555: ROLLBACK TO allocate_target_addon;
8556:
8557: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8558: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8559: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8560: FND_MSG_PUB.add;
8561:
8562: x_return_status := FND_API.g_ret_sts_unexp_error ;
8563: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

8759: EXCEPTION
8760:
8761: WHEN OZF_TP_INVALID_PARAM THEN
8762: ROLLBACK TO setup_product_spread;
8763: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8764: FND_MSG_PUB.add;
8765: x_return_status := FND_API.g_ret_sts_error ;
8766: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8767: p_data => x_error_message);

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

8765: x_return_status := FND_API.g_ret_sts_error ;
8766: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8767: p_data => x_error_message);
8768: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8769: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8770:
8771: WHEN FND_API.G_EXC_ERROR THEN
8772: ROLLBACK TO setup_product_spread;
8773: x_return_status := FND_API.g_ret_sts_error ;

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

8782:
8783: WHEN OTHERS THEN
8784: ROLLBACK TO setup_product_spread;
8785:
8786: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8787: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8788: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8789: FND_MSG_PUB.add;
8790:

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

8783: WHEN OTHERS THEN
8784: ROLLBACK TO setup_product_spread;
8785:
8786: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8787: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8788: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8789: FND_MSG_PUB.add;
8790:
8791: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

8784: ROLLBACK TO setup_product_spread;
8785:
8786: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8787: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8788: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8789: FND_MSG_PUB.add;
8790:
8791: x_return_status := FND_API.g_ret_sts_unexp_error ;
8792: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

8924: EXCEPTION
8925:
8926: WHEN OZF_TP_INVALID_PARAM THEN
8927: ROLLBACK TO cascade_product_spread;
8928: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
8929: FND_MSG_PUB.add;
8930: x_return_status := FND_API.g_ret_sts_error ;
8931: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8932: p_data => x_error_message);

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

8930: x_return_status := FND_API.g_ret_sts_error ;
8931: FND_MSG_PUB.count_and_get (p_count => x_error_number,
8932: p_data => x_error_message);
8933: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
8934: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
8935:
8936: WHEN FND_API.G_EXC_ERROR THEN
8937: ROLLBACK TO cascade_product_spread;
8938: x_return_status := FND_API.g_ret_sts_error ;

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

8947:
8948: WHEN OTHERS THEN
8949: ROLLBACK TO cascade_product_spread;
8950:
8951: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8952: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8953: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8954: FND_MSG_PUB.add;
8955:

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

8948: WHEN OTHERS THEN
8949: ROLLBACK TO cascade_product_spread;
8950:
8951: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8952: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8953: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8954: FND_MSG_PUB.add;
8955:
8956: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

8949: ROLLBACK TO cascade_product_spread;
8950:
8951: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
8952: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
8953: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
8954: FND_MSG_PUB.add;
8955:
8956: x_return_status := FND_API.g_ret_sts_unexp_error ;
8957: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

9121: EXCEPTION
9122:
9123: WHEN OZF_TP_INVALID_PARAM THEN
9124: ROLLBACK TO allocate_target;
9125: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
9126: FND_MSG_PUB.add;
9127: x_return_status := FND_API.g_ret_sts_error ;
9128: FND_MSG_PUB.count_and_get (p_count => x_error_number,
9129: p_data => x_error_message);

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

9127: x_return_status := FND_API.g_ret_sts_error ;
9128: FND_MSG_PUB.count_and_get (p_count => x_error_number,
9129: p_data => x_error_message);
9130: OZF_UTILITY_PVT.debug_message(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
9131: OZF_UTILITY_PVT.debug_message(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
9132:
9133: WHEN FND_API.G_EXC_ERROR THEN
9134: ROLLBACK TO allocate_target;
9135: x_return_status := FND_API.g_ret_sts_error ;

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

9144:
9145: WHEN OTHERS THEN
9146: ROLLBACK TO allocate_target;
9147:
9148: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
9149: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
9150: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
9151: FND_MSG_PUB.add;
9152:

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

9145: WHEN OTHERS THEN
9146: ROLLBACK TO allocate_target;
9147:
9148: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
9149: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
9150: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
9151: FND_MSG_PUB.add;
9152:
9153: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

9146: ROLLBACK TO allocate_target;
9147:
9148: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
9149: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
9150: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
9151: FND_MSG_PUB.add;
9152:
9153: x_return_status := FND_API.g_ret_sts_unexp_error ;
9154: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

10189: EXCEPTION
10190:
10191: WHEN OZF_TP_INVALID_PARAM THEN
10192: ROLLBACK TO adjust_target_for_acct_added;
10193: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10194: FND_MSG_PUB.add;
10195: x_return_status := FND_API.g_ret_sts_error ;
10196: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10197: p_data => x_error_message);

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

10195: x_return_status := FND_API.g_ret_sts_error ;
10196: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10197: p_data => x_error_message);
10198: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
10199: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
10200:
10201: WHEN FND_API.G_EXC_ERROR THEN
10202: ROLLBACK TO adjust_target_for_acct_added;
10203: x_return_status := FND_API.g_ret_sts_error ;

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

10212:
10213: WHEN OTHERS THEN
10214: ROLLBACK TO adjust_target_for_acct_added;
10215:
10216: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10217: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10218: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10219: FND_MSG_PUB.add;
10220:

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

10213: WHEN OTHERS THEN
10214: ROLLBACK TO adjust_target_for_acct_added;
10215:
10216: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10217: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10218: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10219: FND_MSG_PUB.add;
10220:
10221: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

10214: ROLLBACK TO adjust_target_for_acct_added;
10215:
10216: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10217: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10218: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10219: FND_MSG_PUB.add;
10220:
10221: x_return_status := FND_API.g_ret_sts_unexp_error ;
10222: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

10480: EXCEPTION
10481:
10482: WHEN OZF_TP_INVALID_PARAM THEN
10483: ROLLBACK TO adjust_target_for_acct_deleted;
10484: FND_MESSAGE.set_name('OZF', 'OZF_TP_INVALID_PARAM_TXT');
10485: FND_MSG_PUB.add;
10486: x_return_status := FND_API.g_ret_sts_error ;
10487: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10488: p_data => x_error_message);

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

10486: x_return_status := FND_API.g_ret_sts_error ;
10487: FND_MSG_PUB.count_and_get (p_count => x_error_number,
10488: p_data => x_error_message);
10489: Ozf_Utility_pvt.write_conc_log(l_full_api_name||' : INVALID PARAMETER EXCEPTION = '||sqlerrm(sqlcode));
10490: Ozf_Utility_pvt.write_conc_log(fnd_message.get_string('OZF', 'OZF_TP_INVALID_PARAM_TXT'));
10491:
10492: WHEN FND_API.G_EXC_ERROR THEN
10493: ROLLBACK TO adjust_target_for_acct_deleted;
10494: x_return_status := FND_API.g_ret_sts_error ;

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

10503:
10504: WHEN OTHERS THEN
10505: ROLLBACK TO adjust_target_for_acct_deleted;
10506:
10507: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10508: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10509: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10510: FND_MSG_PUB.add;
10511:

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

10504: WHEN OTHERS THEN
10505: ROLLBACK TO adjust_target_for_acct_deleted;
10506:
10507: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10508: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10509: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10510: FND_MSG_PUB.add;
10511:
10512: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

10505: ROLLBACK TO adjust_target_for_acct_deleted;
10506:
10507: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
10508: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
10509: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
10510: FND_MSG_PUB.add;
10511:
10512: x_return_status := FND_API.g_ret_sts_unexp_error ;
10513: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

11001:
11002: WHEN OTHERS THEN
11003: ROLLBACK TO adjust_account_targets;
11004:
11005: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
11006: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
11007: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
11008: FND_MSG_PUB.add;
11009:

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

11002: WHEN OTHERS THEN
11003: ROLLBACK TO adjust_account_targets;
11004:
11005: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
11006: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
11007: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
11008: FND_MSG_PUB.add;
11009:
11010: x_return_status := FND_API.g_ret_sts_unexp_error ;

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

11003: ROLLBACK TO adjust_account_targets;
11004:
11005: FND_MESSAGE.set_name('OZF', 'OZF_TP_OTHERS_ERROR_TXT');
11006: FND_MESSAGE.set_token('OZF_TP_SQLERRM_TOKEN',SQLERRM);
11007: FND_MESSAGE.set_token('OZF_TP_SQLCODE_TOKEN',SQLCODE);
11008: FND_MSG_PUB.add;
11009:
11010: x_return_status := FND_API.g_ret_sts_unexp_error ;
11011: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN