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

Line 13: OZF_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

9: -----------------------------------------------------------
10: -- CF
11: -----------------------------------------------------------
12:
13: OZF_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: OZF_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: OZF_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE get_dates ( p_period_type_id IN NUMBER,

Line 14: OZF_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

10: -- CF
11: -----------------------------------------------------------
12:
13: OZF_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: OZF_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: OZF_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE get_dates ( p_period_type_id IN NUMBER,
18: p_time_id IN NUMBER,

Line 15: OZF_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

11: -----------------------------------------------------------
12:
13: OZF_DEBUG_HIGH_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
14: OZF_DEBUG_LOW_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
15: OZF_DEBUG_MEDIUM_ON constant boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
16:
17: PROCEDURE get_dates ( p_period_type_id IN NUMBER,
18: p_time_id IN NUMBER,
19: x_record_type_id OUT NOCOPY NUMBER,

Line 293: FND_MSG_PUB.initialize;

289:
290: SAVEPOINT Create_Forecast;
291:
292: IF FND_API.to_boolean(p_init_msg_list) THEN
293: FND_MSG_PUB.initialize;
294: END IF;
295:
296: IF NOT FND_API.compatible_api_call(l_api_version,
297: p_api_version,

Line 388: FND_MSG_PUB.Count_And_Get (

384: WHEN FND_API.G_EXC_ERROR THEN
385:
386: ROLLBACK TO Create_Forecast;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: FND_MSG_PUB.Count_And_Get (
389: p_count => x_msg_count,
390: p_data => x_msg_data
391: );
392:

Line 397: FND_MSG_PUB.Count_And_Get (

393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394:
395: ROLLBACK TO Create_Forecast;
396: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
397: FND_MSG_PUB.Count_And_Get (
398: p_count => x_msg_count,
399: p_data => x_msg_data
400: );
401:

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

403:
404: ROLLBACK TO Create_Forecast;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
409: END IF;
410: FND_MSG_PUB.Count_And_Get (
411: p_count => x_msg_count,

Line 408: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);

404: ROLLBACK TO Create_Forecast;
405: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
406:
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
409: END IF;
410: FND_MSG_PUB.Count_And_Get (
411: p_count => x_msg_count,
412: p_data => x_msg_data

Line 410: FND_MSG_PUB.Count_And_Get (

406:
407: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
408: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
409: END IF;
410: FND_MSG_PUB.Count_And_Get (
411: p_count => x_msg_count,
412: p_data => x_msg_data
413: );
414:

Line 699: FND_MSG_PUB.initialize;

695:
696: SAVEPOINT Create_Dimentions;
697:
698: IF FND_API.to_boolean(p_init_msg_list) THEN
699: FND_MSG_PUB.initialize;
700: END IF;
701:
702: IF NOT FND_API.compatible_api_call(l_api_version,
703: p_api_version,

Line 827: FND_MSG_PUB.add;

823: THEN
824: if p_obj_type <> 'WKST'
825: then
826: FND_MESSAGE.set_name('OZF', 'OZF_FCST_PROD_MKT_REQD');
827: FND_MSG_PUB.add;
828: RAISE FND_API.G_EXC_ERROR;
829: end if;
830: END IF;
831:

Line 905: FND_MSG_PUB.Count_And_Get (

901: WHEN FND_API.G_EXC_ERROR THEN
902:
903: ROLLBACK TO Create_Dimentions;
904: x_return_status := FND_API.G_RET_STS_ERROR;
905: FND_MSG_PUB.Count_And_Get (
906: p_count => x_msg_count,
907: p_data => x_msg_data
908: );
909:

Line 914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

910: WHEN OTHERS THEN
911: x_return_status := FND_API.g_ret_sts_unexp_error;
912: ROLLBACK TO Create_Dimentions;
913:
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
915: THEN
916: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
917: END IF;
918:

Line 916: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

912: ROLLBACK TO Create_Dimentions;
913:
914: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
915: THEN
916: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
917: END IF;
918:
919: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
920: p_count => x_msg_count,

Line 919: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

915: THEN
916: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
917: END IF;
918:
919: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
920: p_count => x_msg_count,
921: p_data => x_msg_data);
922:
923:

Line 1020: FND_MSG_PUB.initialize;

1016:
1017: SAVEPOINT Populate_Products;
1018:
1019: IF FND_API.to_boolean(p_init_msg_list) THEN
1020: FND_MSG_PUB.initialize;
1021: END IF;
1022:
1023: IF NOT FND_API.compatible_api_call(l_api_version,
1024: p_api_version,

Line 1177: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1173: WHEN OTHERS THEN
1174: x_return_status := FND_API.g_ret_sts_unexp_error;
1175: ROLLBACK TO Populate_Products;
1176:
1177: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1178: THEN
1179: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1180: END IF;
1181:

Line 1179: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1175: ROLLBACK TO Populate_Products;
1176:
1177: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1178: THEN
1179: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1180: END IF;
1181:
1182: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1183: p_count => x_msg_count,

Line 1182: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1178: THEN
1179: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1180: END IF;
1181:
1182: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1183: p_count => x_msg_count,
1184: p_data => x_msg_data);
1185:
1186: END populate_fcst_products;

Line 1308: FND_MSG_PUB.initialize;

1304: END IF;
1305: SAVEPOINT Populate_Customers;
1306:
1307: IF FND_API.to_boolean(p_init_msg_list) THEN
1308: FND_MSG_PUB.initialize;
1309: END IF;
1310:
1311: IF NOT FND_API.compatible_api_call(l_api_version,
1312: p_api_version,

Line 1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1447: WHEN OTHERS THEN
1448: x_return_status := FND_API.g_ret_sts_unexp_error;
1449: ROLLBACK TO Populate_Customers;
1450:
1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1452: THEN
1453: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1454: END IF;
1455:

Line 1453: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1449: ROLLBACK TO Populate_Customers;
1450:
1451: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1452: THEN
1453: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1454: END IF;
1455:
1456: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1457: p_count => x_msg_count,

Line 1456: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1452: THEN
1453: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1454: END IF;
1455:
1456: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1457: p_count => x_msg_count,
1458: p_data => x_msg_data);
1459: x_msg_data := SQLERRM;
1460: END populate_fcst_customers;

Line 1537: FND_MSG_PUB.initialize;

1533: END IF;
1534: SAVEPOINT Populate_Periods;
1535:
1536: IF FND_API.to_boolean(p_init_msg_list) THEN
1537: FND_MSG_PUB.initialize;
1538: END IF;
1539:
1540: IF NOT FND_API.compatible_api_call(l_api_version,
1541: p_api_version,

Line 1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

1651: WHEN OTHERS THEN
1652: x_return_status := FND_API.g_ret_sts_unexp_error;
1653: ROLLBACK TO Populate_Periods;
1654:
1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1656: THEN
1657: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1658: END IF;
1659:

Line 1657: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

1653: ROLLBACK TO Populate_Periods;
1654:
1655: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1656: THEN
1657: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1658: END IF;
1659:
1660: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1661: p_count => x_msg_count,

Line 1660: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

1656: THEN
1657: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1658: END IF;
1659:
1660: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
1661: p_count => x_msg_count,
1662: p_data => x_msg_data);
1663:
1664:

Line 1929: FND_MSG_PUB.initialize;

1925:
1926: SAVEPOINT Create_Dimention_Facts;
1927:
1928: IF FND_API.to_boolean(p_init_msg_list) THEN
1929: FND_MSG_PUB.initialize;
1930: END IF;
1931:
1932: IF NOT FND_API.compatible_api_call(l_api_version,
1933: p_api_version,

Line 2140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2136: WHEN OTHERS THEN
2137: x_return_status := FND_API.g_ret_sts_unexp_error;
2138: ROLLBACK TO Create_Dimention_Facts;
2139:
2140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2141: THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: END IF;
2144:

Line 2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2138: ROLLBACK TO Create_Dimention_Facts;
2139:
2140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2141: THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: END IF;
2144:
2145: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2146: p_count => x_msg_count,

Line 2145: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

2141: THEN
2142: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2143: END IF;
2144:
2145: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2146: p_count => x_msg_count,
2147: p_data => x_msg_data);
2148:
2149: END create_dimention_facts;

Line 2239: FND_MSG_PUB.initialize;

2235:
2236: SAVEPOINT Create_Fcst_Facts;
2237:
2238: IF FND_API.to_boolean(p_init_msg_list) THEN
2239: FND_MSG_PUB.initialize;
2240: END IF;
2241:
2242: IF NOT FND_API.compatible_api_call(l_api_version,
2243: p_api_version,

Line 2452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2448:
2449: WHEN OTHERS THEN
2450: x_return_status := FND_API.g_ret_sts_unexp_error;
2451:
2452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2453: THEN
2454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456:

Line 2454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2450: x_return_status := FND_API.g_ret_sts_unexp_error;
2451:
2452: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2453: THEN
2454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456:
2457: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2458: p_count => x_msg_count,

Line 2457: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

2453: THEN
2454: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2455: END IF;
2456:
2457: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2458: p_count => x_msg_count,
2459: p_data => x_msg_data);
2460:
2461:

Line 2964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

2960: RETURN NVL(l_lift_factor, 0);
2961:
2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2965: THEN
2966: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2967: END IF;
2968: --OZF_Utility_PVT.debug_message(' get_best_fit_lift : OTHER ERROR ' || sqlerrm );

Line 2966: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
2965: THEN
2966: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2967: END IF;
2968: --OZF_Utility_PVT.debug_message(' get_best_fit_lift : OTHER ERROR ' || sqlerrm );
2969: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2970: p_count => l_msg_count,

Line 2969: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

2965: THEN
2966: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
2967: END IF;
2968: --OZF_Utility_PVT.debug_message(' get_best_fit_lift : OTHER ERROR ' || sqlerrm );
2969: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
2970: p_count => l_msg_count,
2971: p_data => l_msg_data);
2972: Return 0; -- i.e. lift is ZERO
2973: END get_best_fit_lift; --end of function

Line 3193: FND_MSG_PUB.initialize;

3189: --
3190: SAVEPOINT adjust_baseline_spreads;
3191:
3192: IF FND_API.to_boolean(p_init_msg_list) THEN
3193: FND_MSG_PUB.initialize;
3194: END IF;
3195:
3196: IF NOT FND_API.compatible_api_call(l_api_version,
3197: p_api_version,

Line 3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

3461: ROLLBACK TO adjust_baseline_spreads;
3462:
3463: x_return_status := FND_API.g_ret_sts_unexp_error;
3464:
3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3466: THEN
3467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3468: END IF;
3469:

Line 3467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

3463: x_return_status := FND_API.g_ret_sts_unexp_error;
3464:
3465: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
3466: THEN
3467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3468: END IF;
3469:
3470: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3471: p_count => x_msg_count,

Line 3470: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

3466: THEN
3467: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
3468: END IF;
3469:
3470: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
3471: p_count => x_msg_count,
3472: p_data => x_msg_data);
3473:
3474: END adjust_baseline_spreads; --end of procedure

Line 3728: FND_MSG_PUB.initialize;

3724: --
3725: SAVEPOINT process_baseline_forecast;
3726:
3727: IF FND_API.to_boolean(p_init_msg_list) THEN
3728: FND_MSG_PUB.initialize;
3729: END IF;
3730:
3731: IF NOT FND_API.compatible_api_call(l_api_version,
3732: p_api_version,

Line 4143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

4139: ROLLBACK TO process_baseline_forecast;
4140:
4141: x_return_status := FND_API.g_ret_sts_unexp_error;
4142:
4143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
4144: THEN
4145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4146: END IF;
4147:

Line 4145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4141: x_return_status := FND_API.g_ret_sts_unexp_error;
4142:
4143: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
4144: THEN
4145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4146: END IF;
4147:
4148: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
4149: p_count => x_msg_count,

Line 4148: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

4144: THEN
4145: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4146: END IF;
4147:
4148: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
4149: p_count => x_msg_count,
4150: p_data => x_msg_data);
4151:
4152:

Line 4224: FND_MSG_PUB.initialize;

4220:
4221: SAVEPOINT Create_Wkst_Forecasts;
4222:
4223: IF FND_API.to_boolean(p_init_msg_list) THEN
4224: FND_MSG_PUB.initialize;
4225: END IF;
4226:
4227: IF NOT FND_API.compatible_api_call(l_api_version,
4228: p_api_version,

Line 4539: FND_MSG_PUB.Count_And_Get (

4535: WHEN FND_API.G_EXC_ERROR THEN
4536:
4537: ROLLBACK TO Create_Wkst_Forecasts;
4538: x_return_status := FND_API.G_RET_STS_ERROR;
4539: FND_MSG_PUB.Count_And_Get (
4540: p_encoded => FND_API.g_false,
4541: p_count => x_msg_count,
4542: p_data => x_msg_data
4543: );

Line 4549: FND_MSG_PUB.Count_And_Get (

4545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4546:
4547: ROLLBACK TO Create_Wkst_Forecasts;
4548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4549: FND_MSG_PUB.Count_And_Get (
4550: p_count => x_msg_count,
4551: p_data => x_msg_data
4552: );
4553:

Line 4559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

4555:
4556: ROLLBACK TO Create_Wkst_Forecasts;
4557: x_return_status := FND_API.g_ret_sts_unexp_error;
4558:
4559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
4560: THEN
4561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4562: END IF;
4563:

Line 4561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

4557: x_return_status := FND_API.g_ret_sts_unexp_error;
4558:
4559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
4560: THEN
4561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4562: END IF;
4563:
4564: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
4565: p_count => x_msg_count,

Line 4564: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

4560: THEN
4561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
4562: END IF;
4563:
4564: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
4565: p_count => x_msg_count,
4566: p_data => x_msg_data);
4567: END ; -- create_wkst_forecasts
4568:

Line 4688: FND_MSG_PUB.initialize;

4684: SAVEPOINT Create_Base_Sales;
4685:
4686:
4687: IF FND_API.to_boolean(p_init_msg_list) THEN
4688: FND_MSG_PUB.initialize;
4689: END IF;
4690:
4691: IF NOT FND_API.compatible_api_call(l_api_version,
4692: p_api_version,

Line 5324: FND_MSG_PUB.Count_And_Get (

5320: WHEN FND_API.G_EXC_ERROR THEN
5321:
5322: ROLLBACK TO Create_Base_Sales;
5323: x_return_status := FND_API.G_RET_STS_ERROR;
5324: FND_MSG_PUB.Count_And_Get (
5325: p_encoded => FND_API.g_false,
5326: p_count => x_msg_count,
5327: p_data => x_msg_data
5328: );

Line 5334: FND_MSG_PUB.Count_And_Get (

5330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5331:
5332: ROLLBACK TO Create_Base_Sales;
5333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5334: FND_MSG_PUB.Count_And_Get (
5335: p_count => x_msg_count,
5336: p_data => x_msg_data
5337: );
5338:

Line 5344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5340:
5341: ROLLBACK TO Create_Base_Sales;
5342: x_return_status := FND_API.g_ret_sts_unexp_error;
5343:
5344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5345: THEN
5346: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5347: END IF;
5348:

Line 5346: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5342: x_return_status := FND_API.g_ret_sts_unexp_error;
5343:
5344: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5345: THEN
5346: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5347: END IF;
5348:
5349: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5350: p_count => x_msg_count,

Line 5349: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

5345: THEN
5346: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5347: END IF;
5348:
5349: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5350: p_count => x_msg_count,
5351: p_data => x_msg_data);
5352:
5353: END create_base_sales;

Line 5419: FND_MSG_PUB.initialize;

5415: END IF;
5416: SAVEPOINT Fcst_Remaining_Qty;
5417:
5418: IF FND_API.to_boolean(p_init_msg_list) THEN
5419: FND_MSG_PUB.initialize;
5420: END IF;
5421:
5422: IF NOT FND_API.compatible_api_call(l_api_version,
5423: p_api_version,

Line 5484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5480: WHEN OTHERS THEN
5481: x_return_status := FND_API.g_ret_sts_unexp_error;
5482: ROLLBACK TO Fcst_Remaining_Qty;
5483:
5484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5485: THEN
5486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5487: END IF;
5488:

Line 5486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5482: ROLLBACK TO Fcst_Remaining_Qty;
5483:
5484: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5485: THEN
5486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5487: END IF;
5488:
5489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5490: p_count => x_msg_count,

Line 5489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

5485: THEN
5486: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5487: END IF;
5488:
5489: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5490: p_count => x_msg_count,
5491: p_data => x_msg_data);
5492:
5493:

Line 5556: FND_MSG_PUB.initialize;

5552: END IF;
5553: SAVEPOINT Fcst_BL_Remaining_Qty;
5554:
5555: IF FND_API.to_boolean(p_init_msg_list) THEN
5556: FND_MSG_PUB.initialize;
5557: END IF;
5558:
5559: IF NOT FND_API.compatible_api_call(l_api_version,
5560: p_api_version,

Line 5620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5616: WHEN OTHERS THEN
5617: x_return_status := FND_API.g_ret_sts_unexp_error;
5618: ROLLBACK TO Fcst_BL_Remaining_Qty;
5619:
5620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5621: THEN
5622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5623: END IF;
5624:

Line 5622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5618: ROLLBACK TO Fcst_BL_Remaining_Qty;
5619:
5620: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5621: THEN
5622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5623: END IF;
5624:
5625: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5626: p_count => x_msg_count,

Line 5625: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

5621: THEN
5622: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5623: END IF;
5624:
5625: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5626: p_count => x_msg_count,
5627: p_data => x_msg_data);
5628:
5629:

Line 5692: FND_MSG_PUB.initialize;

5688: END IF;
5689: SAVEPOINT freeze_check;
5690:
5691: IF FND_API.to_boolean(p_init_msg_list) THEN
5692: FND_MSG_PUB.initialize;
5693: END IF;
5694:
5695: IF NOT FND_API.compatible_api_call(l_api_version,
5696: p_api_version,

Line 5737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

5733:
5734:
5735: IF (l_flag_error = true) THEN
5736: -- forecast_remaining_quantity <> 0 for some record
5737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5738:
5739: IF (l_flag_fcst = true) THEN
5740: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_HEADER_QTY_REMAINING');
5741: FND_MSG_PUB.Add;

Line 5741: FND_MSG_PUB.Add;

5737: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
5738:
5739: IF (l_flag_fcst = true) THEN
5740: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_HEADER_QTY_REMAINING');
5741: FND_MSG_PUB.Add;
5742: END IF;
5743:
5744: IF (l_flag_level_one = true) THEN
5745: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');

Line 5747: FND_MSG_PUB.Add;

5743:
5744: IF (l_flag_level_one = true) THEN
5745: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5746: FND_MESSAGE.Set_Token('DIMENTION', l_dimention1 );
5747: FND_MSG_PUB.Add;
5748: END IF;
5749:
5750: IF (l_flag_level_two = true) THEN
5751: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');

Line 5753: FND_MSG_PUB.Add;

5749:
5750: IF (l_flag_level_two = true) THEN
5751: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_LEVEL_QTY_REMAINING');
5752: FND_MESSAGE.Set_Token('DIMENTION', l_dimention2 );
5753: FND_MSG_PUB.Add;
5754: END IF;
5755:
5756: END IF;
5757: x_return_status := FND_API.G_RET_STS_ERROR;

Line 5772: FND_MSG_PUB.Count_And_Get (

5768:
5769: WHEN FND_API.G_EXC_ERROR THEN
5770: ROLLBACK TO freeze_check;
5771: x_return_status := FND_API.G_RET_STS_ERROR;
5772: FND_MSG_PUB.Count_And_Get (
5773: p_encoded => FND_API.g_false,
5774: p_count => x_msg_count,
5775: p_data => x_msg_data
5776: );

Line 5781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

5777:
5778: WHEN OTHERS THEN
5779: x_return_status := FND_API.g_ret_sts_unexp_error;
5780:
5781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5782: THEN
5783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5784: END IF;
5785:

Line 5783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

5779: x_return_status := FND_API.g_ret_sts_unexp_error;
5780:
5781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
5782: THEN
5783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5784: END IF;
5785:
5786: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5787: p_count => x_msg_count,

Line 5786: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

5782: THEN
5783: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
5784: END IF;
5785:
5786: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
5787: p_count => x_msg_count,
5788: p_data => x_msg_data);
5789:
5790:

Line 5915: FND_MSG_PUB.initialize;

5911:
5912: END IF;
5913:
5914: IF FND_API.to_boolean(p_init_msg_list) THEN
5915: FND_MSG_PUB.initialize;
5916: END IF;
5917:
5918: IF NOT FND_API.compatible_api_call(l_api_version,
5919: p_api_version,

Line 6421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

6417: x_return_status := FND_API.g_ret_sts_unexp_error;
6418:
6419: ROLLBACK TO copy_forecast;
6420:
6421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6422: THEN
6423: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6424: END IF;
6425:

Line 6423: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6419: ROLLBACK TO copy_forecast;
6420:
6421: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6422: THEN
6423: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6424: END IF;
6425:
6426: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
6427: p_count => x_msg_count,

Line 6426: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

6422: THEN
6423: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6424: END IF;
6425:
6426: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
6427: p_count => x_msg_count,
6428: p_data => x_msg_data);
6429:
6430:

Line 6526: FND_MSG_PUB.initialize;

6522:
6523: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message(l_full_name || ': start refresh parties'); END IF;
6524:
6525: IF FND_API.to_boolean(p_init_msg_list) THEN
6526: FND_MSG_PUB.initialize;
6527: END IF;
6528:
6529: IF NOT FND_API.compatible_api_call(l_api_version,
6530: p_api_version,

Line 6914: FND_MSG_PUB.add;

6910: x_return_status := FND_API.g_ret_sts_unexp_error;
6911:
6912: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
6913: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
6914: FND_MSG_PUB.add;
6915:
6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6917: THEN
6918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

6912: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
6913: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
6914: FND_MSG_PUB.add;
6915:
6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6917: THEN
6918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6919: END IF;
6920:

Line 6918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

6914: FND_MSG_PUB.add;
6915:
6916: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
6917: THEN
6918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6919: END IF;
6920:
6921: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
6922: p_count => x_msg_count,

Line 6921: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

6917: THEN
6918: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
6919: END IF;
6920:
6921: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
6922: p_count => x_msg_count,
6923: p_data => x_msg_data);
6924:
6925:

Line 6989: FND_MSG_PUB.initialize;

6985:
6986: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message(l_full_name || ': start refresh parties'); END IF;
6987:
6988: IF FND_API.to_boolean(p_init_msg_list) THEN
6989: FND_MSG_PUB.initialize;
6990: END IF;
6991:
6992: IF NOT FND_API.compatible_api_call(l_api_version,
6993: p_api_version,

Line 7196: FND_MSG_PUB.add;

7192: x_return_status := FND_API.g_ret_sts_unexp_error;
7193:
7194: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7195: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7196: FND_MSG_PUB.add;
7197:
7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7199: THEN
7200: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

7194: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7195: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7196: FND_MSG_PUB.add;
7197:
7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7199: THEN
7200: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7201: END IF;
7202:

Line 7200: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

7196: FND_MSG_PUB.add;
7197:
7198: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7199: THEN
7200: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7201: END IF;
7202:
7203: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
7204: p_count => x_msg_count,

Line 7203: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

7199: THEN
7200: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7201: END IF;
7202:
7203: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
7204: p_count => x_msg_count,
7205: p_data => x_msg_data);
7206:
7207:

Line 7352: FND_MSG_PUB.initialize;

7348:
7349: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message(l_full_name || ': start refresh parties'); END IF;
7350:
7351: IF FND_API.to_boolean(p_init_msg_list) THEN
7352: FND_MSG_PUB.initialize;
7353: END IF;
7354:
7355: IF NOT FND_API.compatible_api_call(l_api_version,
7356: p_api_version,

Line 7745: FND_MSG_PUB.add;

7741: x_return_status := FND_API.g_ret_sts_unexp_error;
7742:
7743: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7744: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7745: FND_MSG_PUB.add;
7746:
7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7748: THEN
7749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

7743: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
7744: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
7745: FND_MSG_PUB.add;
7746:
7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7748: THEN
7749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7750: END IF;
7751:

Line 7749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

7745: FND_MSG_PUB.add;
7746:
7747: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
7748: THEN
7749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7750: END IF;
7751:
7752: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
7753: p_count => x_msg_count,

Line 7752: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

7748: THEN
7749: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
7750: END IF;
7751:
7752: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
7753: p_count => x_msg_count,
7754: p_data => x_msg_data);
7755:
7756: END calc_perc;

Line 7841: FND_MSG_PUB.initialize;

7837:
7838: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message(l_full_name || ': start get_list_price '); END IF;
7839:
7840: IF FND_API.to_boolean(p_init_msg_list) THEN
7841: FND_MSG_PUB.initialize;
7842: END IF;
7843:
7844: IF NOT FND_API.compatible_api_call(l_api_version,
7845: p_api_version,

Line 7960: FND_MSG_PUB.add;

7956: THEN
7957: x_return_status := FND_API.G_RET_STS_ERROR;
7958: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7959: FND_MESSAGE.set_token('ERR_MSG',x_return_status_text);
7960: FND_MSG_PUB.add;
7961: RAISE FND_API.G_EXC_ERROR;
7962: ELSE
7963:
7964: I := x_line_tbl.FIRST;

Line 7977: FND_MSG_PUB.add;

7973: THEN
7974: x_return_status := FND_API.G_RET_STS_ERROR;
7975: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
7976: FND_MESSAGE.set_token('ERR_MSG',l_status_text);
7977: FND_MSG_PUB.add;
7978: RAISE FND_API.G_EXC_ERROR;
7979:
7980: END IF;
7981:

Line 7994: FND_MSG_PUB.Count_And_Get (

7990: OZF_Utility_PVT.debug_message('Validate_get_list_price_of_goods: ' || substr(sqlerrm, 1, 100));
7991: END IF;
7992: x_return_status := FND_API.G_RET_STS_ERROR;
7993:
7994: FND_MSG_PUB.Count_And_Get (
7995: p_encoded => FND_API.g_false,
7996: p_count => x_msg_count,
7997: p_data => x_msg_data
7998: );

Line 8005: FND_MSG_PUB.add;

8001: x_return_status := FND_API.g_ret_sts_unexp_error;
8002:
8003: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
8004: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8005: FND_MSG_PUB.add;
8006:
8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8008: THEN
8009: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

8003: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_LISTPRICE_FAILURE');
8004: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8005: FND_MSG_PUB.add;
8006:
8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8008: THEN
8009: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8010: END IF;
8011:

Line 8009: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8005: FND_MSG_PUB.add;
8006:
8007: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8008: THEN
8009: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8010: END IF;
8011:
8012: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8013: p_count => x_msg_count,

Line 8012: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

8008: THEN
8009: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8010: END IF;
8011:
8012: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8013: p_count => x_msg_count,
8014: p_data => x_msg_data);
8015:
8016:

Line 8104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

8100: RETURN NVL(l_list_price,0);
8101:
8102: EXCEPTION
8103: WHEN OTHERS THEN
8104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8105: THEN
8106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8107: END IF;
8108: --OZF_Utility_PVT.debug_message(' get_product_list_price : OTHER ERROR ' || sqlerrm );

Line 8106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8102: EXCEPTION
8103: WHEN OTHERS THEN
8104: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8105: THEN
8106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8107: END IF;
8108: --OZF_Utility_PVT.debug_message(' get_product_list_price : OTHER ERROR ' || sqlerrm );
8109: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8110: p_count => l_msg_count,

Line 8109: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

8105: THEN
8106: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8107: END IF;
8108: --OZF_Utility_PVT.debug_message(' get_product_list_price : OTHER ERROR ' || sqlerrm );
8109: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8110: p_count => l_msg_count,
8111: p_data => l_msg_data);
8112: Return 33; -- i.e. list price is ZERO
8113: END get_product_list_price; --end of function

Line 8176: FND_MSG_PUB.initialize;

8172:
8173: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message(l_full_name || ': start refresh parties'); END IF;
8174:
8175: IF FND_API.to_boolean(p_init_msg_list) THEN
8176: FND_MSG_PUB.initialize;
8177: END IF;
8178:
8179: IF NOT FND_API.compatible_api_call(l_api_version,
8180: p_api_version,

Line 8251: FND_MSG_PUB.Count_And_Get (

8247: WHEN FND_API.G_EXC_ERROR THEN
8248: -- IF (OZF_DEBUG_HIGH_ON) THEN OZF_Utility_PVT.debug_message('Validate_Standard_Cost_Of_Goods: ' || substr(sqlerrm, 1, 100)); END IF;
8249: ROLLBACK TO calc_cost_of_goods;
8250: x_return_status := FND_API.G_RET_STS_ERROR;
8251: FND_MSG_PUB.Count_And_Get (
8252: p_encoded => FND_API.g_false,
8253: p_count => x_msg_count,
8254: p_data => x_msg_data
8255: );

Line 8262: FND_MSG_PUB.add;

8258: x_return_status := FND_API.g_ret_sts_unexp_error;
8259:
8260: FND_MESSAGE.set_name('OZF', 'OZF_FCST_CALC_COG_FAILED');
8261: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8262: FND_MSG_PUB.add;
8263:
8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8265: THEN
8266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

8260: FND_MESSAGE.set_name('OZF', 'OZF_FCST_CALC_COG_FAILED');
8261: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8262: FND_MSG_PUB.add;
8263:
8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8265: THEN
8266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:

Line 8266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8262: FND_MSG_PUB.add;
8263:
8264: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8265: THEN
8266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:
8269: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8270: p_count => x_msg_count,

Line 8269: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

8265: THEN
8266: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8267: END IF;
8268:
8269: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8270: p_count => x_msg_count,
8271: p_data => x_msg_data);
8272:
8273:

Line 8416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

8412: RETURN NVL(l_standard_cost,0); -- return total cost for Product
8413:
8414: EXCEPTION
8415: WHEN OTHERS THEN
8416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8417: THEN
8418: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8419: END IF;
8420: --OZF_Utility_PVT.debug_message(' get_product_cost : OTHER ERROR ' || sqlerrm );

Line 8418: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8414: EXCEPTION
8415: WHEN OTHERS THEN
8416: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8417: THEN
8418: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8419: END IF;
8420: --OZF_Utility_PVT.debug_message(' get_product_cost : OTHER ERROR ' || sqlerrm );
8421: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8422: p_count => l_msg_count,

Line 8421: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

8417: THEN
8418: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8419: END IF;
8420: --OZF_Utility_PVT.debug_message(' get_product_cost : OTHER ERROR ' || sqlerrm );
8421: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8422: p_count => l_msg_count,
8423: p_data => l_msg_data);
8424: Return 100; -- i.e. cost is ZERO
8425: END get_product_cost; --end of function

Line 8554: FND_MSG_PUB.initialize;

8550:
8551: SAVEPOINT get_discount_percent;
8552:
8553: IF FND_API.to_boolean(p_init_msg_list) THEN
8554: FND_MSG_PUB.initialize;
8555: END IF;
8556:
8557: IF NOT FND_API.compatible_api_call(l_api_version,
8558: p_api_version,

Line 8705: FND_MSG_PUB.Count_And_Get (

8701: WHEN FND_API.g_exc_error THEN
8702:
8703: ROLLBACK TO get_discount_percent;
8704: x_return_status := FND_API.g_ret_sts_error;
8705: FND_MSG_PUB.Count_And_Get (
8706: p_encoded => FND_API.g_false,
8707: p_count => x_msg_count,
8708: p_data => x_msg_data
8709: );

Line 8715: FND_MSG_PUB.Count_And_Get (

8711: WHEN FND_API.g_exc_unexpected_error THEN
8712:
8713: ROLLBACK TO get_discount_percent;
8714: x_return_status := FND_API.g_ret_sts_unexp_error;
8715: FND_MSG_PUB.Count_And_Get (
8716: p_encoded => FND_API.g_false,
8717: p_count => x_msg_count,
8718: p_data => x_msg_data
8719: );

Line 8727: FND_MSG_PUB.add;

8723: x_return_status := FND_API.g_ret_sts_unexp_error;
8724:
8725: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
8726: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8727: FND_MSG_PUB.add;
8728:
8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8730: THEN
8731: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

8725: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
8726: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
8727: FND_MSG_PUB.add;
8728:
8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8730: THEN
8731: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8732: END IF;
8733:

Line 8731: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

8727: FND_MSG_PUB.add;
8728:
8729: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
8730: THEN
8731: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8732: END IF;
8733:
8734: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8735: p_count => x_msg_count,

Line 8734: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

8730: THEN
8731: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
8732: END IF;
8733:
8734: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
8735: p_count => x_msg_count,
8736: p_data => x_msg_data);
8737:
8738:

Line 8930: FND_MSG_PUB.initialize;

8926:
8927: SAVEPOINT get_discount_info;
8928:
8929: IF FND_API.to_boolean(p_init_msg_list) THEN
8930: FND_MSG_PUB.initialize;
8931: END IF;
8932:
8933: IF NOT FND_API.compatible_api_call(l_api_version,
8934: p_api_version,

Line 9163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

9159: THEN
9160:
9161: NULL;
9162: /*
9163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9164: THEN
9165: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_COG_MISSING');
9166: FND_MESSAGE.Set_Token('PRODUCT', p_product_attr_value );
9167: FND_MSG_PUB.Add;

Line 9167: FND_MSG_PUB.Add;

9163: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9164: THEN
9165: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_COG_MISSING');
9166: FND_MESSAGE.Set_Token('PRODUCT', p_product_attr_value );
9167: FND_MSG_PUB.Add;
9168: RAISE FND_API.g_exc_error;
9169: END IF;
9170: */
9171: ELSE

Line 9181: FND_MSG_PUB.Count_And_Get (

9177: WHEN FND_API.g_exc_error THEN
9178:
9179: ROLLBACK TO get_discount_info;
9180: x_return_status := FND_API.g_ret_sts_error;
9181: FND_MSG_PUB.Count_And_Get (
9182: p_encoded => FND_API.g_false,
9183: p_count => x_msg_count,
9184: p_data => x_msg_data
9185: );

Line 9191: FND_MSG_PUB.Count_And_Get (

9187: WHEN FND_API.g_exc_unexpected_error THEN
9188:
9189: ROLLBACK TO get_discount_info;
9190: x_return_status := FND_API.g_ret_sts_unexp_error;
9191: FND_MSG_PUB.Count_And_Get (
9192: p_encoded => FND_API.g_false,
9193: p_count => x_msg_count,
9194: p_data => x_msg_data
9195: );

Line 9203: FND_MSG_PUB.add;

9199: x_return_status := FND_API.g_ret_sts_unexp_error;
9200:
9201: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
9202: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9203: FND_MSG_PUB.add;
9204:
9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9206: THEN
9207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

9201: FND_MESSAGE.set_name('OZF', 'OZF_FCST_GET_DISC_FAILED');
9202: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9203: FND_MSG_PUB.add;
9204:
9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9206: THEN
9207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9208: END IF;
9209:

Line 9207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

9203: FND_MSG_PUB.add;
9204:
9205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9206: THEN
9207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9208: END IF;
9209:
9210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
9211: p_count => x_msg_count,

Line 9210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

9206: THEN
9207: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9208: END IF;
9209:
9210: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
9211: p_count => x_msg_count,
9212: p_data => x_msg_data);
9213:
9214:

Line 9306: FND_MSG_PUB.initialize;

9302:
9303: BEGIN
9304:
9305: IF FND_API.to_boolean(p_init_msg_list) THEN
9306: FND_MSG_PUB.initialize;
9307: END IF;
9308:
9309: IF NOT FND_API.compatible_api_call(l_api_version,
9310: p_api_version,

Line 9375: FND_MSG_PUB.Count_And_Get (

9371: WHEN FND_API.G_EXC_ERROR THEN
9372:
9373: x_return_status := FND_API.G_RET_STS_ERROR;
9374: -- Standard call to get message count and if count=1, get the message
9375: FND_MSG_PUB.Count_And_Get (
9376: p_encoded => FND_API.G_FALSE,
9377: p_count => x_msg_count,
9378: p_data => x_msg_data
9379: );

Line 9384: FND_MSG_PUB.Count_And_Get (

9380: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9381:
9382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9383: -- Standard call to get message count and if count=1, get the message
9384: FND_MSG_PUB.Count_And_Get (
9385: p_encoded => FND_API.G_FALSE,
9386: p_count => x_msg_count,
9387: p_data => x_msg_data
9388: );

Line 9393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9389: WHEN OTHERS THEN
9390:
9391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9392:
9393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9394: THEN
9395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9396: END IF;
9397: -- Standard call to get message count and if count=1, get the message

Line 9395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

9391: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9392:
9393: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9394: THEN
9395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9396: END IF;
9397: -- Standard call to get message count and if count=1, get the message
9398: FND_MSG_PUB.Count_And_Get (
9399: p_encoded => FND_API.G_FALSE,

Line 9398: FND_MSG_PUB.Count_And_Get (

9394: THEN
9395: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9396: END IF;
9397: -- Standard call to get message count and if count=1, get the message
9398: FND_MSG_PUB.Count_And_Get (
9399: p_encoded => FND_API.G_FALSE,
9400: p_count => x_msg_count,
9401: p_data => x_msg_data
9402: );

Line 9456: FND_MSG_PUB.initialize;

9452:
9453: SAVEPOINT allocate_facts;
9454:
9455: IF FND_API.to_boolean(p_init_msg_list) THEN
9456: FND_MSG_PUB.initialize;
9457: END IF;
9458:
9459: IF NOT FND_API.compatible_api_call(l_api_version,
9460: p_api_version,

Line 9588: FND_MSG_PUB.Count_And_Get (

9584: WHEN FND_API.G_EXC_ERROR THEN
9585: ROLLBACK TO allocate_facts ;
9586: x_return_status := FND_API.G_RET_STS_ERROR;
9587: -- Standard call to get message count and if count=1, get the message
9588: FND_MSG_PUB.Count_And_Get (
9589: p_encoded => FND_API.G_FALSE,
9590: p_count => x_msg_count,
9591: p_data => x_msg_data
9592: );

Line 9597: FND_MSG_PUB.Count_And_Get (

9593: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9594: ROLLBACK TO allocate_facts;
9595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9596: -- Standard call to get message count and if count=1, get the message
9597: FND_MSG_PUB.Count_And_Get (
9598: p_encoded => FND_API.G_FALSE,
9599: p_count => x_msg_count,
9600: p_data => x_msg_data
9601: );

Line 9605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

9601: );
9602: WHEN OTHERS THEN
9603: ROLLBACK TO allocate_facts;
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9606: THEN
9607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9608: END IF;
9609: -- Standard call to get message count and if count=1, get the message

Line 9607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

9603: ROLLBACK TO allocate_facts;
9604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9605: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
9606: THEN
9607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9608: END IF;
9609: -- Standard call to get message count and if count=1, get the message
9610: FND_MSG_PUB.Count_And_Get (
9611: p_encoded => FND_API.G_FALSE,

Line 9610: FND_MSG_PUB.Count_And_Get (

9606: THEN
9607: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
9608: END IF;
9609: -- Standard call to get message count and if count=1, get the message
9610: FND_MSG_PUB.Count_And_Get (
9611: p_encoded => FND_API.G_FALSE,
9612: p_count => x_msg_count,
9613: p_data => x_msg_data
9614: );

Line 9773: FND_MSG_PUB.initialize;

9769:
9770: SAVEPOINT get_volume_offer_discount;
9771:
9772: IF FND_API.to_boolean(p_init_msg_list) THEN
9773: FND_MSG_PUB.initialize;
9774: END IF;
9775:
9776: IF NOT FND_API.compatible_api_call(l_api_version,
9777: p_api_version,

Line 9851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

9847: THEN
9848:
9849: l_flag_error := true;
9850:
9851: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
9852: THEN
9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom
9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);

Line 9856: FND_MSG_PUB.Add;

9852: THEN
9853: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
9854: FND_MESSAGE.Set_Token('CURRENT_UOM', l_fcst_uom); -- replace with p_fcst_uom
9855: FND_MESSAGE.Set_Token('ORDER_UOM', i.uom_code);
9856: FND_MSG_PUB.Add;
9857: END IF;
9858:
9859: END IF;
9860:

Line 9904: FND_MSG_PUB.Count_And_Get (

9900: WHEN FND_API.g_exc_error THEN
9901:
9902: ROLLBACK TO get_volume_offer_discount;
9903: x_return_status := FND_API.g_ret_sts_error;
9904: FND_MSG_PUB.Count_And_Get (
9905: p_encoded => FND_API.g_false,
9906: p_count => x_msg_count,
9907: p_data => x_msg_data
9908: );

Line 9914: FND_MSG_PUB.Count_And_Get (

9910: WHEN FND_API.g_exc_unexpected_error THEN
9911:
9912: ROLLBACK TO get_volume_offer_discount;
9913: x_return_status := FND_API.g_ret_sts_unexp_error;
9914: FND_MSG_PUB.Count_And_Get (
9915: p_encoded => FND_API.g_false,
9916: p_count => x_msg_count,
9917: p_data => x_msg_data
9918: );

Line 9927: FND_MSG_PUB.add;

9923: x_return_status := FND_API.g_ret_sts_unexp_error;
9924:
9925: FND_MESSAGE.set_name('OZF', 'OZF_GET_VOLUME_OFFER_DISCOUNT_FAILED');
9926: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9927: FND_MSG_PUB.add;
9928:
9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9930: THEN
9931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

9925: FND_MESSAGE.set_name('OZF', 'OZF_GET_VOLUME_OFFER_DISCOUNT_FAILED');
9926: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
9927: FND_MSG_PUB.add;
9928:
9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9930: THEN
9931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9932: END IF;
9933:

Line 9931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

9927: FND_MSG_PUB.add;
9928:
9929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
9930: THEN
9931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9932: END IF;
9933:
9934: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
9935: p_count => x_msg_count,

Line 9934: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

9930: THEN
9931: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
9932: END IF;
9933:
9934: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
9935: p_count => x_msg_count,
9936: p_data => x_msg_data);
9937:
9938: END get_volume_offer_discount;

Line 10048: FND_MSG_PUB.initialize;

10044:
10045: SAVEPOINT allocate_pg_facts;
10046:
10047: IF FND_API.to_boolean(p_init_msg_list) THEN
10048: FND_MSG_PUB.initialize;
10049: END IF;
10050:
10051: IF NOT FND_API.compatible_api_call(l_api_version,
10052: p_api_version,

Line 10082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

10078: IF i.converted_ratio = -99999
10079: THEN
10080: l_flag_error := true;
10081:
10082: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10083: THEN
10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);
10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);

Line 10087: FND_MSG_PUB.Add;

10083: THEN
10084: FND_MESSAGE.Set_Name ('OZF', 'OZF_TP_UOM_CONVERSION_MISSING');
10085: FND_MESSAGE.Set_Token('CURRENT_UOM', i.forecast_uom_code);
10086: FND_MESSAGE.Set_Token('ORDER_UOM', i.offer_product_uom_code);
10087: FND_MSG_PUB.Add;
10088: END IF;
10089: ELSE
10090: l_ratio := i.converted_ratio ;
10091: END IF;

Line 10098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

10094: IF i.price_list_id IS NULL
10095: THEN
10096: l_flag_error := true;
10097:
10098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10099: THEN
10100: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRICE_LIST_NEEDED');
10101: FND_MSG_PUB.Add;
10102: END IF;

Line 10101: FND_MSG_PUB.Add;

10097:
10098: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
10099: THEN
10100: FND_MESSAGE.Set_Name ('OZF', 'OZF_PRICE_LIST_NEEDED');
10101: FND_MSG_PUB.Add;
10102: END IF;
10103:
10104: ELSE
10105:

Line 10221: FND_MSG_PUB.Count_And_Get (

10217: WHEN FND_API.G_EXC_ERROR THEN
10218: ROLLBACK TO allocate_pg_facts ;
10219: x_return_status := FND_API.G_RET_STS_ERROR;
10220: -- Standard call to get message count and if count=1, get the message
10221: FND_MSG_PUB.Count_And_Get (
10222: p_encoded => FND_API.G_FALSE,
10223: p_count => x_msg_count,
10224: p_data => x_msg_data
10225: );

Line 10230: FND_MSG_PUB.Count_And_Get (

10226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10227: ROLLBACK TO allocate_pg_facts;
10228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10229: -- Standard call to get message count and if count=1, get the message
10230: FND_MSG_PUB.Count_And_Get (
10231: p_encoded => FND_API.G_FALSE,
10232: p_count => x_msg_count,
10233: p_data => x_msg_data
10234: );

Line 10238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

10234: );
10235: WHEN OTHERS THEN
10236: ROLLBACK TO allocate_pg_facts;
10237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10239: THEN
10240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
10241: END IF;
10242: -- Standard call to get message count and if count=1, get the message

Line 10240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

10236: ROLLBACK TO allocate_pg_facts;
10237: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10238: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
10239: THEN
10240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
10241: END IF;
10242: -- Standard call to get message count and if count=1, get the message
10243: FND_MSG_PUB.Count_And_Get (
10244: p_encoded => FND_API.G_FALSE,

Line 10243: FND_MSG_PUB.Count_And_Get (

10239: THEN
10240: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
10241: END IF;
10242: -- Standard call to get message count and if count=1, get the message
10243: FND_MSG_PUB.Count_And_Get (
10244: p_encoded => FND_API.G_FALSE,
10245: p_count => x_msg_count,
10246: p_data => x_msg_data
10247: );

Line 10334: FND_MSG_PUB.initialize;

10330:
10331: BEGIN
10332:
10333: IF FND_API.to_boolean(p_init_msg_list) THEN
10334: FND_MSG_PUB.initialize;
10335: END IF;
10336:
10337: IF NOT FND_API.compatible_api_call(l_api_version,
10338: p_api_version,

Line 10534: FND_MSG_PUB.add;

10530: x_return_status := FND_API.g_ret_sts_unexp_error;
10531:
10532: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10533: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10534: FND_MSG_PUB.add;
10535:
10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10537: THEN
10538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

10532: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10533: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10534: FND_MSG_PUB.add;
10535:
10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10537: THEN
10538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10539: END IF;
10540:

Line 10538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

10534: FND_MSG_PUB.add;
10535:
10536: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10537: THEN
10538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10539: END IF;
10540:
10541: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
10542: p_count => x_msg_count,

Line 10541: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

10537: THEN
10538: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10539: END IF;
10540:
10541: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
10542: p_count => x_msg_count,
10543: p_data => x_msg_data);
10544:
10545: END cascade_baseline_update;

Line 10605: FND_MSG_PUB.initialize;

10601: OZF_Utility_PVT.debug_message(l_full_name || ': Start Cascade Baseline Levels');
10602: END IF;
10603:
10604: IF FND_API.to_boolean(p_init_msg_list) THEN
10605: FND_MSG_PUB.initialize;
10606: END IF;
10607:
10608: IF NOT FND_API.compatible_api_call(l_api_version,
10609: p_api_version,

Line 10711: FND_MSG_PUB.add;

10707: x_return_status := FND_API.g_ret_sts_unexp_error;
10708:
10709: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10710: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10711: FND_MSG_PUB.add;
10712:
10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10714: THEN
10715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)

10709: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_PARTY_STMT_FAILED');
10710: FND_MESSAGE.set_token('ERR_MSG',SQLERRM);
10711: FND_MSG_PUB.add;
10712:
10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10714: THEN
10715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10716: END IF;
10717:

Line 10715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

10711: FND_MSG_PUB.add;
10712:
10713: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
10714: THEN
10715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10716: END IF;
10717:
10718: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
10719: p_count => x_msg_count,

Line 10718: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,

10714: THEN
10715: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
10716: END IF;
10717:
10718: FND_MSG_PUB.count_and_get(p_encoded => FND_API.g_false,
10719: p_count => x_msg_count,
10720: p_data => x_msg_data);
10721:
10722: