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_CUST_FACTS_PVT dependencies on FND_API

Line 6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2: /*$Header: ozfvcftb.pls 120.13 2011/03/25 09:45:46 kdass ship $*/
3:
4: PROCEDURE refresh_accts_and_products(
5: p_api_version IN NUMBER,
6: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
7: p_report_date IN DATE,
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 50: IF FND_API.to_boolean(p_init_msg_list) THEN

46: BEGIN
47:
48: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
49:
50: IF FND_API.to_boolean(p_init_msg_list) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: IF NOT FND_API.compatible_api_call(l_api_version,

Line 54: IF NOT FND_API.compatible_api_call(l_api_version,

50: IF FND_API.to_boolean(p_init_msg_list) THEN
51: FND_MSG_PUB.initialize;
52: END IF;
53:
54: IF NOT FND_API.compatible_api_call(l_api_version,
55: p_api_version,
56: l_api_name,
57: g_pkg_name)
58: THEN

Line 59: RAISE FND_API.g_exc_unexpected_error;

55: p_api_version,
56: l_api_name,
57: g_pkg_name)
58: THEN
59: RAISE FND_API.g_exc_unexpected_error;
60: END IF;
61: x_return_status := FND_API.g_ret_sts_success;
62:
63: DELETE FROM ozf_cust_daily_facts

Line 61: x_return_status := FND_API.g_ret_sts_success;

57: g_pkg_name)
58: THEN
59: RAISE FND_API.g_exc_unexpected_error;
60: END IF;
61: x_return_status := FND_API.g_ret_sts_success;
62:
63: DELETE FROM ozf_cust_daily_facts
64: WHERE report_date = p_report_date;
65:

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144:
145: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: x_return_status := FND_API.g_ret_sts_error ;
150: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);

Line 149: x_return_status := FND_API.g_ret_sts_error ;

145: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: x_return_status := FND_API.g_ret_sts_error ;
150: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:

Line 150: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: x_return_status := FND_API.g_ret_sts_error ;
150: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

150: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: x_return_status := FND_API.g_ret_sts_unexp_error ;
156: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
157: p_count => x_msg_count,
158: p_data => x_msg_data);

Line 155: x_return_status := FND_API.g_ret_sts_unexp_error ;

151: p_count => x_msg_count,
152: p_data => x_msg_data);
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: x_return_status := FND_API.g_ret_sts_unexp_error ;
156: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
157: p_count => x_msg_count,
158: p_data => x_msg_data);
159:

Line 156: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

152: p_data => x_msg_data);
153:
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: x_return_status := FND_API.g_ret_sts_unexp_error ;
156: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
157: p_count => x_msg_count,
158: p_data => x_msg_data);
159:
160: WHEN OTHERS THEN

Line 161: x_return_status := FND_API.g_ret_sts_unexp_error ;

157: p_count => x_msg_count,
158: p_data => x_msg_data);
159:
160: WHEN OTHERS THEN
161: x_return_status := FND_API.g_ret_sts_unexp_error ;
162: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
163: p_count => x_msg_count,
164: p_data => x_msg_data);
165: END refresh_accts_and_products;

Line 162: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

158: p_data => x_msg_data);
159:
160: WHEN OTHERS THEN
161: x_return_status := FND_API.g_ret_sts_unexp_error ;
162: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
163: p_count => x_msg_count,
164: p_data => x_msg_data);
165: END refresh_accts_and_products;
166:

Line 170: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

166:
167:
168: PROCEDURE refresh_sales_info(
169: p_api_version IN NUMBER,
170: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
171: p_report_date IN DATE,
172: x_return_status OUT NOCOPY VARCHAR2,
173: x_msg_count OUT NOCOPY NUMBER,
174: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 305: IF FND_API.to_boolean(p_init_msg_list) THEN

301: BEGIN
302:
303: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
304:
305: IF FND_API.to_boolean(p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: IF NOT FND_API.compatible_api_call(l_api_version,

Line 309: IF NOT FND_API.compatible_api_call(l_api_version,

305: IF FND_API.to_boolean(p_init_msg_list) THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:
309: IF NOT FND_API.compatible_api_call(l_api_version,
310: p_api_version,
311: l_api_name,
312: g_pkg_name)
313: THEN

Line 314: RAISE FND_API.g_exc_unexpected_error;

310: p_api_version,
311: l_api_name,
312: g_pkg_name)
313: THEN
314: RAISE FND_API.g_exc_unexpected_error;
315: END IF;
316: x_return_status := FND_API.g_ret_sts_success;
317:
318: --

Line 316: x_return_status := FND_API.g_ret_sts_success;

312: g_pkg_name)
313: THEN
314: RAISE FND_API.g_exc_unexpected_error;
315: END IF;
316: x_return_status := FND_API.g_ret_sts_success;
317:
318: --
319: l_report_date := p_report_date;
320: l_ly_report_date := add_months(p_report_date, -12);

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: --
530: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.g_ret_sts_error ;
535: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data);

Line 534: x_return_status := FND_API.g_ret_sts_error ;

530: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.g_ret_sts_error ;
535: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:

Line 535: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: x_return_status := FND_API.g_ret_sts_error ;
535: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

535: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: x_return_status := FND_API.g_ret_sts_unexp_error ;
541: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data);

Line 540: x_return_status := FND_API.g_ret_sts_unexp_error ;

536: p_count => x_msg_count,
537: p_data => x_msg_data);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: x_return_status := FND_API.g_ret_sts_unexp_error ;
541: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data);
544:

Line 541: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

537: p_data => x_msg_data);
538:
539: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
540: x_return_status := FND_API.g_ret_sts_unexp_error ;
541: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
542: p_count => x_msg_count,
543: p_data => x_msg_data);
544:
545: WHEN OTHERS THEN

Line 546: x_return_status := FND_API.g_ret_sts_unexp_error ;

542: p_count => x_msg_count,
543: p_data => x_msg_data);
544:
545: WHEN OTHERS THEN
546: x_return_status := FND_API.g_ret_sts_unexp_error ;
547: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550: END refresh_sales_info;

Line 547: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

543: p_data => x_msg_data);
544:
545: WHEN OTHERS THEN
546: x_return_status := FND_API.g_ret_sts_unexp_error ;
547: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
548: p_count => x_msg_count,
549: p_data => x_msg_data);
550: END refresh_sales_info;
551:

Line 555: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

551:
552:
553: PROCEDURE refresh_orders_info(
554: p_api_version IN NUMBER,
555: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
556: p_report_date IN DATE,
557: x_return_status OUT NOCOPY VARCHAR2,
558: x_msg_count OUT NOCOPY NUMBER,
559: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 685: IF FND_API.to_boolean(p_init_msg_list) THEN

681: BEGIN
682:
683: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
684:
685: IF FND_API.to_boolean(p_init_msg_list) THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: IF NOT FND_API.compatible_api_call(l_api_version,

Line 689: IF NOT FND_API.compatible_api_call(l_api_version,

685: IF FND_API.to_boolean(p_init_msg_list) THEN
686: FND_MSG_PUB.initialize;
687: END IF;
688:
689: IF NOT FND_API.compatible_api_call(l_api_version,
690: p_api_version,
691: l_api_name,
692: g_pkg_name)
693: THEN

Line 694: RAISE FND_API.g_exc_unexpected_error;

690: p_api_version,
691: l_api_name,
692: g_pkg_name)
693: THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_success;
697: --
698:

Line 696: x_return_status := FND_API.g_ret_sts_success;

692: g_pkg_name)
693: THEN
694: RAISE FND_API.g_exc_unexpected_error;
695: END IF;
696: x_return_status := FND_API.g_ret_sts_success;
697: --
698:
699: -- Get Last Day of the Period
700: OPEN last_day_csr;

Line 790: WHEN FND_API.G_EXC_ERROR THEN

786: --
787: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
788:
789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status := FND_API.g_ret_sts_error ;
792: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data);

Line 791: x_return_status := FND_API.g_ret_sts_error ;

787: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
788:
789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status := FND_API.g_ret_sts_error ;
792: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:

Line 792: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

788:
789: EXCEPTION
790: WHEN FND_API.G_EXC_ERROR THEN
791: x_return_status := FND_API.g_ret_sts_error ;
792: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

792: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := FND_API.g_ret_sts_unexp_error ;
798: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
799: p_count => x_msg_count,
800: p_data => x_msg_data);

Line 797: x_return_status := FND_API.g_ret_sts_unexp_error ;

793: p_count => x_msg_count,
794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := FND_API.g_ret_sts_unexp_error ;
798: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
799: p_count => x_msg_count,
800: p_data => x_msg_data);
801:

Line 798: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

794: p_data => x_msg_data);
795:
796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := FND_API.g_ret_sts_unexp_error ;
798: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
799: p_count => x_msg_count,
800: p_data => x_msg_data);
801:
802: WHEN OTHERS THEN

Line 803: x_return_status := FND_API.g_ret_sts_unexp_error ;

799: p_count => x_msg_count,
800: p_data => x_msg_data);
801:
802: WHEN OTHERS THEN
803: x_return_status := FND_API.g_ret_sts_unexp_error ;
804: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,
806: p_data => x_msg_data);
807: END refresh_orders_info;

Line 804: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

800: p_data => x_msg_data);
801:
802: WHEN OTHERS THEN
803: x_return_status := FND_API.g_ret_sts_unexp_error ;
804: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
805: p_count => x_msg_count,
806: p_data => x_msg_data);
807: END refresh_orders_info;
808:

Line 925: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

921: END get_cust_target;
922:
923: PROCEDURE refresh_target_info(
924: p_api_version IN NUMBER,
925: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
926: p_report_date IN DATE,
927: x_return_status OUT NOCOPY VARCHAR2,
928: x_msg_count OUT NOCOPY NUMBER,
929: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 1046: IF FND_API.to_boolean(p_init_msg_list) THEN

1042: BEGIN
1043:
1044: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1045:
1046: IF FND_API.to_boolean(p_init_msg_list) THEN
1047: FND_MSG_PUB.initialize;
1048: END IF;
1049:
1050: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1050: IF NOT FND_API.compatible_api_call(l_api_version,

1046: IF FND_API.to_boolean(p_init_msg_list) THEN
1047: FND_MSG_PUB.initialize;
1048: END IF;
1049:
1050: IF NOT FND_API.compatible_api_call(l_api_version,
1051: p_api_version,
1052: l_api_name,
1053: g_pkg_name)
1054: THEN

Line 1055: RAISE FND_API.g_exc_unexpected_error;

1051: p_api_version,
1052: l_api_name,
1053: g_pkg_name)
1054: THEN
1055: RAISE FND_API.g_exc_unexpected_error;
1056: END IF;
1057:
1058: x_return_status := FND_API.g_ret_sts_success;
1059: --

Line 1058: x_return_status := FND_API.g_ret_sts_success;

1054: THEN
1055: RAISE FND_API.g_exc_unexpected_error;
1056: END IF;
1057:
1058: x_return_status := FND_API.g_ret_sts_success;
1059: --
1060:
1061: -- Updates the following columns
1062: -- current_period_target

Line 1195: WHEN FND_API.G_EXC_ERROR THEN

1191: --
1192: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
1193:
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: x_return_status := FND_API.g_ret_sts_error ;
1197: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1198: p_count => x_msg_count,
1199: p_data => x_msg_data);

Line 1196: x_return_status := FND_API.g_ret_sts_error ;

1192: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
1193:
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: x_return_status := FND_API.g_ret_sts_error ;
1197: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1198: p_count => x_msg_count,
1199: p_data => x_msg_data);
1200:

Line 1197: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1193:
1194: EXCEPTION
1195: WHEN FND_API.G_EXC_ERROR THEN
1196: x_return_status := FND_API.g_ret_sts_error ;
1197: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1198: p_count => x_msg_count,
1199: p_data => x_msg_data);
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1197: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1198: p_count => x_msg_count,
1199: p_data => x_msg_data);
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: x_return_status := FND_API.g_ret_sts_unexp_error ;
1203: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);

Line 1202: x_return_status := FND_API.g_ret_sts_unexp_error ;

1198: p_count => x_msg_count,
1199: p_data => x_msg_data);
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: x_return_status := FND_API.g_ret_sts_unexp_error ;
1203: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:

Line 1203: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

1199: p_data => x_msg_data);
1200:
1201: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1202: x_return_status := FND_API.g_ret_sts_unexp_error ;
1203: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:
1207: WHEN OTHERS THEN

Line 1208: x_return_status := FND_API.g_ret_sts_unexp_error ;

1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.g_ret_sts_unexp_error ;
1209: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data);
1212: END refresh_target_info;

Line 1209: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

1205: p_data => x_msg_data);
1206:
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.g_ret_sts_unexp_error ;
1209: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1210: p_count => x_msg_count,
1211: p_data => x_msg_data);
1212: END refresh_target_info;
1213:

Line 1408: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1404:
1405:
1406: PROCEDURE refresh_kpi_info(
1407: p_api_version IN NUMBER,
1408: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1409: p_report_date IN DATE,
1410: x_return_status OUT NOCOPY VARCHAR2,
1411: x_msg_count OUT NOCOPY NUMBER,
1412: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 1583: IF FND_API.to_boolean(p_init_msg_list) THEN

1579: BEGIN
1580:
1581: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1582:
1583: IF FND_API.to_boolean(p_init_msg_list) THEN
1584: FND_MSG_PUB.initialize;
1585: END IF;
1586:
1587: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1587: IF NOT FND_API.compatible_api_call(l_api_version,

1583: IF FND_API.to_boolean(p_init_msg_list) THEN
1584: FND_MSG_PUB.initialize;
1585: END IF;
1586:
1587: IF NOT FND_API.compatible_api_call(l_api_version,
1588: p_api_version,
1589: l_api_name,
1590: g_pkg_name)
1591: THEN

Line 1592: RAISE FND_API.g_exc_unexpected_error;

1588: p_api_version,
1589: l_api_name,
1590: g_pkg_name)
1591: THEN
1592: RAISE FND_API.g_exc_unexpected_error;
1593: END IF;
1594:
1595: x_return_status := FND_API.g_ret_sts_success;
1596:

Line 1595: x_return_status := FND_API.g_ret_sts_success;

1591: THEN
1592: RAISE FND_API.g_exc_unexpected_error;
1593: END IF;
1594:
1595: x_return_status := FND_API.g_ret_sts_success;
1596:
1597: -- Fetch current periods
1598:
1599: OPEN period_time_id_csr;

Line 1714: WHEN FND_API.G_EXC_ERROR THEN

1710: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
1711:
1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: x_return_status := FND_API.g_ret_sts_error ;
1716: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);

Line 1715: x_return_status := FND_API.g_ret_sts_error ;

1711:
1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: x_return_status := FND_API.g_ret_sts_error ;
1716: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:

Line 1716: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

1712: EXCEPTION
1713:
1714: WHEN FND_API.G_EXC_ERROR THEN
1715: x_return_status := FND_API.g_ret_sts_error ;
1716: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1716: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1721: x_return_status := FND_API.g_ret_sts_unexp_error ;
1722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);

Line 1721: x_return_status := FND_API.g_ret_sts_unexp_error ;

1717: p_count => x_msg_count,
1718: p_data => x_msg_data);
1719:
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1721: x_return_status := FND_API.g_ret_sts_unexp_error ;
1722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:

Line 1722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

1718: p_data => x_msg_data);
1719:
1720: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1721: x_return_status := FND_API.g_ret_sts_unexp_error ;
1722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN OTHERS THEN

Line 1727: x_return_status := FND_API.g_ret_sts_unexp_error ;

1723: p_count => x_msg_count,
1724: p_data => x_msg_data);
1725:
1726: WHEN OTHERS THEN
1727: x_return_status := FND_API.g_ret_sts_unexp_error ;
1728: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:

Line 1728: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

1724: p_data => x_msg_data);
1725:
1726: WHEN OTHERS THEN
1727: x_return_status := FND_API.g_ret_sts_unexp_error ;
1728: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
1729: p_count => x_msg_count,
1730: p_data => x_msg_data);
1731:
1732: END refresh_kpi_info;

Line 1737: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

1733:
1734:
1735: PROCEDURE update_sales_info(
1736: p_api_version IN NUMBER,
1737: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
1738: p_report_date IN DATE,
1739: x_return_status OUT NOCOPY VARCHAR2,
1740: x_msg_count OUT NOCOPY NUMBER,
1741: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 1859: IF FND_API.to_boolean(p_init_msg_list) THEN

1855:
1856: BEGIN
1857: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
1858:
1859: IF FND_API.to_boolean(p_init_msg_list) THEN
1860: FND_MSG_PUB.initialize;
1861: END IF;
1862:
1863: IF NOT FND_API.compatible_api_call(l_api_version,

Line 1863: IF NOT FND_API.compatible_api_call(l_api_version,

1859: IF FND_API.to_boolean(p_init_msg_list) THEN
1860: FND_MSG_PUB.initialize;
1861: END IF;
1862:
1863: IF NOT FND_API.compatible_api_call(l_api_version,
1864: p_api_version,
1865: l_api_name,
1866: g_pkg_name)
1867: THEN

Line 1868: RAISE FND_API.g_exc_unexpected_error;

1864: p_api_version,
1865: l_api_name,
1866: g_pkg_name)
1867: THEN
1868: RAISE FND_API.g_exc_unexpected_error;
1869: END IF;
1870:
1871: x_return_status := FND_API.g_ret_sts_success;
1872: -- Package Body Start

Line 1871: x_return_status := FND_API.g_ret_sts_success;

1867: THEN
1868: RAISE FND_API.g_exc_unexpected_error;
1869: END IF;
1870:
1871: x_return_status := FND_API.g_ret_sts_success;
1872: -- Package Body Start
1873:
1874: -- Get the current period and quarter's time_ids
1875: OPEN current_periods_csr;

Line 2017: WHEN FND_API.G_EXC_ERROR THEN

2013: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2014:
2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_ERROR THEN
2018: x_return_status := FND_API.g_ret_sts_error ;
2019: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);

Line 2018: x_return_status := FND_API.g_ret_sts_error ;

2014:
2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_ERROR THEN
2018: x_return_status := FND_API.g_ret_sts_error ;
2019: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:

Line 2019: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

2015: EXCEPTION
2016:
2017: WHEN FND_API.G_EXC_ERROR THEN
2018: x_return_status := FND_API.g_ret_sts_error ;
2019: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:
2023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2019: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:
2023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2024: x_return_status := FND_API.g_ret_sts_unexp_error ;
2025: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2026: p_count => x_msg_count,
2027: p_data => x_msg_data);

Line 2024: x_return_status := FND_API.g_ret_sts_unexp_error ;

2020: p_count => x_msg_count,
2021: p_data => x_msg_data);
2022:
2023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2024: x_return_status := FND_API.g_ret_sts_unexp_error ;
2025: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2026: p_count => x_msg_count,
2027: p_data => x_msg_data);
2028:

Line 2025: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2021: p_data => x_msg_data);
2022:
2023: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2024: x_return_status := FND_API.g_ret_sts_unexp_error ;
2025: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2026: p_count => x_msg_count,
2027: p_data => x_msg_data);
2028:
2029: WHEN OTHERS THEN

Line 2030: x_return_status := FND_API.g_ret_sts_unexp_error ;

2026: p_count => x_msg_count,
2027: p_data => x_msg_data);
2028:
2029: WHEN OTHERS THEN
2030: x_return_status := FND_API.g_ret_sts_unexp_error ;
2031: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);
2034:

Line 2031: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2027: p_data => x_msg_data);
2028:
2029: WHEN OTHERS THEN
2030: x_return_status := FND_API.g_ret_sts_unexp_error ;
2031: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2032: p_count => x_msg_count,
2033: p_data => x_msg_data);
2034:
2035: END update_sales_info;

Line 2040: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2036:
2037:
2038: PROCEDURE update_quota_sales_info(
2039: p_api_version IN NUMBER,
2040: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2041: p_report_date IN DATE,
2042: x_return_status OUT NOCOPY VARCHAR2,
2043: x_msg_count OUT NOCOPY NUMBER,
2044: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 2109: IF NOT FND_API.Compatible_API_Call ( l_api_version,

2105: l_tot_parent_quota_sales NUMBER;
2106:
2107: BEGIN
2108: -- Standard call to check for call compatibility.
2109: IF NOT FND_API.Compatible_API_Call ( l_api_version,
2110: p_api_version,
2111: l_api_name,
2112: g_pkg_name)
2113: THEN

Line 2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2110: p_api_version,
2111: l_api_name,
2112: g_pkg_name)
2113: THEN
2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: END IF;
2116:
2117: -- Initialize message list if p_init_msg_list is set to TRUE.
2118: FND_MSG_PUB.initialize;

Line 2124: x_return_status := FND_API.G_RET_STS_SUCCESS;

2120: -- Debug Message
2121: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');
2122:
2123: -- Initialize API return status to SUCCESS
2124: x_return_status := FND_API.G_RET_STS_SUCCESS;
2125:
2126: -- Procedure body start
2127: FOR quota IN leaf_node_quotas_csr
2128: LOOP

Line 2170: WHEN FND_API.G_EXC_ERROR THEN

2166: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2167:
2168: EXCEPTION
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: x_return_status := FND_API.g_ret_sts_error ;
2172: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data);

Line 2171: x_return_status := FND_API.g_ret_sts_error ;

2167:
2168: EXCEPTION
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: x_return_status := FND_API.g_ret_sts_error ;
2172: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data);
2175:

Line 2172: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

2168: EXCEPTION
2169:
2170: WHEN FND_API.G_EXC_ERROR THEN
2171: x_return_status := FND_API.g_ret_sts_error ;
2172: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data);
2175:
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2172: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2173: p_count => x_msg_count,
2174: p_data => x_msg_data);
2175:
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: x_return_status := FND_API.g_ret_sts_unexp_error ;
2178: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);

Line 2177: x_return_status := FND_API.g_ret_sts_unexp_error ;

2173: p_count => x_msg_count,
2174: p_data => x_msg_data);
2175:
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: x_return_status := FND_API.g_ret_sts_unexp_error ;
2178: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:

Line 2178: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2174: p_data => x_msg_data);
2175:
2176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2177: x_return_status := FND_API.g_ret_sts_unexp_error ;
2178: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:
2182: WHEN OTHERS THEN

Line 2183: x_return_status := FND_API.g_ret_sts_unexp_error ;

2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:
2182: WHEN OTHERS THEN
2183: x_return_status := FND_API.g_ret_sts_unexp_error ;
2184: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2185: p_count => x_msg_count,
2186: p_data => x_msg_data);
2187:

Line 2184: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2180: p_data => x_msg_data);
2181:
2182: WHEN OTHERS THEN
2183: x_return_status := FND_API.g_ret_sts_unexp_error ;
2184: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2185: p_count => x_msg_count,
2186: p_data => x_msg_data);
2187:
2188: END update_quota_sales_info;

Line 2193: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2189:
2190: -- Added in R12 - Used to populate the OZF_RES_CUST_PROD_FACTS table
2191: PROCEDURE populate_res_cust_prod_facts (
2192: p_api_version IN NUMBER,
2193: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2194: p_report_date IN DATE,
2195: x_return_status OUT NOCOPY VARCHAR2,
2196: x_msg_count OUT NOCOPY NUMBER,
2197: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 2207: IF FND_API.to_boolean(p_init_msg_list) THEN

2203: BEGIN
2204:
2205: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
2206:
2207: IF FND_API.to_boolean(p_init_msg_list) THEN
2208: FND_MSG_PUB.initialize;
2209: END IF;
2210:
2211: IF NOT FND_API.compatible_api_call(l_api_version,

Line 2211: IF NOT FND_API.compatible_api_call(l_api_version,

2207: IF FND_API.to_boolean(p_init_msg_list) THEN
2208: FND_MSG_PUB.initialize;
2209: END IF;
2210:
2211: IF NOT FND_API.compatible_api_call(l_api_version,
2212: p_api_version,
2213: l_api_name,
2214: g_pkg_name)
2215: THEN

Line 2216: RAISE FND_API.g_exc_unexpected_error;

2212: p_api_version,
2213: l_api_name,
2214: g_pkg_name)
2215: THEN
2216: RAISE FND_API.g_exc_unexpected_error;
2217: END IF;
2218: x_return_status := FND_API.g_ret_sts_success;
2219:
2220: DELETE FROM OZF_RES_CUST_PROD_FACTS

Line 2218: x_return_status := FND_API.g_ret_sts_success;

2214: g_pkg_name)
2215: THEN
2216: RAISE FND_API.g_exc_unexpected_error;
2217: END IF;
2218: x_return_status := FND_API.g_ret_sts_success;
2219:
2220: DELETE FROM OZF_RES_CUST_PROD_FACTS
2221: WHERE report_date = p_report_date;
2222:

Line 2748: WHEN FND_API.G_EXC_ERROR THEN

2744:
2745: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2746:
2747: EXCEPTION
2748: WHEN FND_API.G_EXC_ERROR THEN
2749: x_return_status := FND_API.g_ret_sts_error ;
2750: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);

Line 2749: x_return_status := FND_API.g_ret_sts_error ;

2745: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
2746:
2747: EXCEPTION
2748: WHEN FND_API.G_EXC_ERROR THEN
2749: x_return_status := FND_API.g_ret_sts_error ;
2750: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);
2753:

Line 2750: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

2746:
2747: EXCEPTION
2748: WHEN FND_API.G_EXC_ERROR THEN
2749: x_return_status := FND_API.g_ret_sts_error ;
2750: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);
2753:
2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2750: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
2751: p_count => x_msg_count,
2752: p_data => x_msg_data);
2753:
2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2755: x_return_status := FND_API.g_ret_sts_unexp_error ;
2756: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2757: p_count => x_msg_count,
2758: p_data => x_msg_data);

Line 2755: x_return_status := FND_API.g_ret_sts_unexp_error ;

2751: p_count => x_msg_count,
2752: p_data => x_msg_data);
2753:
2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2755: x_return_status := FND_API.g_ret_sts_unexp_error ;
2756: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2757: p_count => x_msg_count,
2758: p_data => x_msg_data);
2759:

Line 2756: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2752: p_data => x_msg_data);
2753:
2754: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2755: x_return_status := FND_API.g_ret_sts_unexp_error ;
2756: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2757: p_count => x_msg_count,
2758: p_data => x_msg_data);
2759:
2760: WHEN OTHERS THEN

Line 2761: x_return_status := FND_API.g_ret_sts_unexp_error ;

2757: p_count => x_msg_count,
2758: p_data => x_msg_data);
2759:
2760: WHEN OTHERS THEN
2761: x_return_status := FND_API.g_ret_sts_unexp_error ;
2762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2763: p_count => x_msg_count,
2764: p_data => x_msg_data);
2765: END populate_res_cust_prod_facts;

Line 2762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

2758: p_data => x_msg_data);
2759:
2760: WHEN OTHERS THEN
2761: x_return_status := FND_API.g_ret_sts_unexp_error ;
2762: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
2763: p_count => x_msg_count,
2764: p_data => x_msg_data);
2765: END populate_res_cust_prod_facts;
2766:

Line 2770: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

2766:
2767: -- for R12, proc to get the budget and claims info and update the ozf_res_cust_prod_facts
2768: PROCEDURE refresh_budget_and_claims_info (
2769: p_api_version IN NUMBER,
2770: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
2771: p_report_date IN DATE,
2772: x_return_status OUT NOCOPY VARCHAR2,
2773: x_msg_count OUT NOCOPY NUMBER,
2774: x_msg_data OUT NOCOPY VARCHAR2) AS

Line 2784: IF FND_API.to_boolean(p_init_msg_list) THEN

2780: BEGIN
2781:
2782: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (-)') ;
2783:
2784: IF FND_API.to_boolean(p_init_msg_list) THEN
2785: FND_MSG_PUB.initialize;
2786: END IF;
2787:
2788: IF NOT FND_API.compatible_api_call(l_api_version,

Line 2788: IF NOT FND_API.compatible_api_call(l_api_version,

2784: IF FND_API.to_boolean(p_init_msg_list) THEN
2785: FND_MSG_PUB.initialize;
2786: END IF;
2787:
2788: IF NOT FND_API.compatible_api_call(l_api_version,
2789: p_api_version,
2790: l_api_name,
2791: g_pkg_name)
2792: THEN

Line 2793: RAISE FND_API.g_exc_unexpected_error;

2789: p_api_version,
2790: l_api_name,
2791: g_pkg_name)
2792: THEN
2793: RAISE FND_API.g_exc_unexpected_error;
2794: END IF;
2795: x_return_status := FND_API.g_ret_sts_success;
2796:
2797: --YTD budget amounts for 'PARTY'

Line 2795: x_return_status := FND_API.g_ret_sts_success;

2791: g_pkg_name)
2792: THEN
2793: RAISE FND_API.g_exc_unexpected_error;
2794: END IF;
2795: x_return_status := FND_API.g_ret_sts_success;
2796:
2797: --YTD budget amounts for 'PARTY'
2798: UPDATE ozf_res_cust_prod_facts outer
2799: Set (YTD_FUND_utilized, YTD_FUND_earned, YTD_FUND_paid)

Line 3491: WHEN FND_API.G_EXC_ERROR THEN

3487:
3488: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
3489:
3490: EXCEPTION
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: x_return_status := FND_API.g_ret_sts_error ;
3493: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);

Line 3492: x_return_status := FND_API.g_ret_sts_error ;

3488: ozf_utility_pvt.write_conc_log('Private API: ' || l_full_name || ' (+)');
3489:
3490: EXCEPTION
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: x_return_status := FND_API.g_ret_sts_error ;
3493: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:

Line 3493: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

3489:
3490: EXCEPTION
3491: WHEN FND_API.G_EXC_ERROR THEN
3492: x_return_status := FND_API.g_ret_sts_error ;
3493: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3493: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: x_return_status := FND_API.g_ret_sts_unexp_error ;
3499: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3500: p_count => x_msg_count,
3501: p_data => x_msg_data);

Line 3498: x_return_status := FND_API.g_ret_sts_unexp_error ;

3494: p_count => x_msg_count,
3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: x_return_status := FND_API.g_ret_sts_unexp_error ;
3499: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3500: p_count => x_msg_count,
3501: p_data => x_msg_data);
3502:

Line 3499: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

3495: p_data => x_msg_data);
3496:
3497: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3498: x_return_status := FND_API.g_ret_sts_unexp_error ;
3499: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3500: p_count => x_msg_count,
3501: p_data => x_msg_data);
3502:
3503: WHEN OTHERS THEN

Line 3504: x_return_status := FND_API.g_ret_sts_unexp_error ;

3500: p_count => x_msg_count,
3501: p_data => x_msg_data);
3502:
3503: WHEN OTHERS THEN
3504: x_return_status := FND_API.g_ret_sts_unexp_error ;
3505: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3506: p_count => x_msg_count,
3507: p_data => x_msg_data);
3508: END refresh_budget_and_claims_info;

Line 3505: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

3501: p_data => x_msg_data);
3502:
3503: WHEN OTHERS THEN
3504: x_return_status := FND_API.g_ret_sts_unexp_error ;
3505: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3506: p_count => x_msg_count,
3507: p_data => x_msg_data);
3508: END refresh_budget_and_claims_info;
3509:

Line 3523: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;

3519: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
3520: x_msg_count NUMBER;
3521: x_msg_data VARCHAR2(240);
3522: x_return_status VARCHAR2(1) ;
3523: l_init_msg_list VARCHAR2(10) := FND_API.G_FALSE;
3524:
3525: l_report_date DATE;
3526:
3527: BEGIN

Line 3530: IF NOT FND_API.Compatible_API_Call ( l_api_version,

3526:
3527: BEGIN
3528:
3529: -- Standard call to check for call compatibility.
3530: IF NOT FND_API.Compatible_API_Call ( l_api_version,
3531: p_api_version,
3532: l_api_name,
3533: g_pkg_name)
3534: THEN

Line 3535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3531: p_api_version,
3532: l_api_name,
3533: g_pkg_name)
3534: THEN
3535: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3536: END IF;
3537:
3538: -- Initialize message list if p_init_msg_list is set to TRUE.
3539: FND_MSG_PUB.initialize;

Line 3545: x_return_status := FND_API.G_RET_STS_SUCCESS;

3541: -- Debug Message
3542: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (-)');
3543:
3544: -- Initialize API return status to SUCCESS
3545: x_return_status := FND_API.G_RET_STS_SUCCESS;
3546:
3547: l_report_date := trunc(to_date(p_report_date,'YYYY/MM/DD HH24:MI:SS'));
3548:
3549: IF l_report_date IS NULL

Line 3567: IF x_return_status = FND_API.g_ret_sts_error

3563: x_return_status ,
3564: x_msg_count ,
3565: x_msg_data );
3566:
3567: IF x_return_status = FND_API.g_ret_sts_error
3568: THEN
3569: RAISE FND_API.g_exc_error;
3570: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3571: RAISE FND_API.g_exc_unexpected_error;

Line 3569: RAISE FND_API.g_exc_error;

3565: x_msg_data );
3566:
3567: IF x_return_status = FND_API.g_ret_sts_error
3568: THEN
3569: RAISE FND_API.g_exc_error;
3570: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3571: RAISE FND_API.g_exc_unexpected_error;
3572: END IF;
3573:

Line 3570: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3566:
3567: IF x_return_status = FND_API.g_ret_sts_error
3568: THEN
3569: RAISE FND_API.g_exc_error;
3570: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3571: RAISE FND_API.g_exc_unexpected_error;
3572: END IF;
3573:
3574: --

Line 3571: RAISE FND_API.g_exc_unexpected_error;

3567: IF x_return_status = FND_API.g_ret_sts_error
3568: THEN
3569: RAISE FND_API.g_exc_error;
3570: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3571: RAISE FND_API.g_exc_unexpected_error;
3572: END IF;
3573:
3574: --
3575: -- Refresh Sales Info

Line 3587: IF x_return_status = FND_API.g_ret_sts_error

3583: x_return_status ,
3584: x_msg_count ,
3585: x_msg_data );
3586:
3587: IF x_return_status = FND_API.g_ret_sts_error
3588: THEN
3589: RAISE FND_API.g_exc_error;
3590: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3591: RAISE FND_API.g_exc_unexpected_error;

Line 3589: RAISE FND_API.g_exc_error;

3585: x_msg_data );
3586:
3587: IF x_return_status = FND_API.g_ret_sts_error
3588: THEN
3589: RAISE FND_API.g_exc_error;
3590: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3591: RAISE FND_API.g_exc_unexpected_error;
3592: END IF;
3593:

Line 3590: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3586:
3587: IF x_return_status = FND_API.g_ret_sts_error
3588: THEN
3589: RAISE FND_API.g_exc_error;
3590: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3591: RAISE FND_API.g_exc_unexpected_error;
3592: END IF;
3593:
3594: refresh_target_info(

Line 3591: RAISE FND_API.g_exc_unexpected_error;

3587: IF x_return_status = FND_API.g_ret_sts_error
3588: THEN
3589: RAISE FND_API.g_exc_error;
3590: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3591: RAISE FND_API.g_exc_unexpected_error;
3592: END IF;
3593:
3594: refresh_target_info(
3595: l_api_version ,

Line 3602: IF x_return_status = FND_API.g_ret_sts_error

3598: x_return_status ,
3599: x_msg_count ,
3600: x_msg_data );
3601:
3602: IF x_return_status = FND_API.g_ret_sts_error
3603: THEN
3604: RAISE FND_API.g_exc_error;
3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;

Line 3604: RAISE FND_API.g_exc_error;

3600: x_msg_data );
3601:
3602: IF x_return_status = FND_API.g_ret_sts_error
3603: THEN
3604: RAISE FND_API.g_exc_error;
3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:

Line 3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3601:
3602: IF x_return_status = FND_API.g_ret_sts_error
3603: THEN
3604: RAISE FND_API.g_exc_error;
3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:
3609: -- ozf_utility_pvt.write_conc_log('-33');

Line 3606: RAISE FND_API.g_exc_unexpected_error;

3602: IF x_return_status = FND_API.g_ret_sts_error
3603: THEN
3604: RAISE FND_API.g_exc_error;
3605: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3606: RAISE FND_API.g_exc_unexpected_error;
3607: END IF;
3608:
3609: -- ozf_utility_pvt.write_conc_log('-33');
3610: --

Line 3622: IF x_return_status = FND_API.g_ret_sts_error

3618: x_return_status ,
3619: x_msg_count ,
3620: x_msg_data );
3621:
3622: IF x_return_status = FND_API.g_ret_sts_error
3623: THEN
3624: RAISE FND_API.g_exc_error;
3625: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3626: RAISE FND_API.g_exc_unexpected_error;

Line 3624: RAISE FND_API.g_exc_error;

3620: x_msg_data );
3621:
3622: IF x_return_status = FND_API.g_ret_sts_error
3623: THEN
3624: RAISE FND_API.g_exc_error;
3625: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3626: RAISE FND_API.g_exc_unexpected_error;
3627: END IF;
3628:

Line 3625: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3621:
3622: IF x_return_status = FND_API.g_ret_sts_error
3623: THEN
3624: RAISE FND_API.g_exc_error;
3625: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3626: RAISE FND_API.g_exc_unexpected_error;
3627: END IF;
3628:
3629: --

Line 3626: RAISE FND_API.g_exc_unexpected_error;

3622: IF x_return_status = FND_API.g_ret_sts_error
3623: THEN
3624: RAISE FND_API.g_exc_error;
3625: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3626: RAISE FND_API.g_exc_unexpected_error;
3627: END IF;
3628:
3629: --
3630: -- Refresh KPI Info

Line 3643: IF x_return_status = FND_API.g_ret_sts_error

3639: x_return_status ,
3640: x_msg_count ,
3641: x_msg_data );
3642:
3643: IF x_return_status = FND_API.g_ret_sts_error
3644: THEN
3645: RAISE FND_API.g_exc_error;
3646: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3647: RAISE FND_API.g_exc_unexpected_error;

Line 3645: RAISE FND_API.g_exc_error;

3641: x_msg_data );
3642:
3643: IF x_return_status = FND_API.g_ret_sts_error
3644: THEN
3645: RAISE FND_API.g_exc_error;
3646: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3647: RAISE FND_API.g_exc_unexpected_error;
3648: END IF;
3649:

Line 3646: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3642:
3643: IF x_return_status = FND_API.g_ret_sts_error
3644: THEN
3645: RAISE FND_API.g_exc_error;
3646: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3647: RAISE FND_API.g_exc_unexpected_error;
3648: END IF;
3649:
3650:

Line 3647: RAISE FND_API.g_exc_unexpected_error;

3643: IF x_return_status = FND_API.g_ret_sts_error
3644: THEN
3645: RAISE FND_API.g_exc_error;
3646: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3647: RAISE FND_API.g_exc_unexpected_error;
3648: END IF;
3649:
3650:
3651: populate_res_cust_prod_facts (l_api_version ,

Line 3658: IF x_return_status = FND_API.g_ret_sts_error

3654: x_return_status,
3655: x_msg_count,
3656: x_msg_data);
3657:
3658: IF x_return_status = FND_API.g_ret_sts_error
3659: THEN
3660: RAISE FND_API.g_exc_error;
3661: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3662: RAISE FND_API.g_exc_unexpected_error;

Line 3660: RAISE FND_API.g_exc_error;

3656: x_msg_data);
3657:
3658: IF x_return_status = FND_API.g_ret_sts_error
3659: THEN
3660: RAISE FND_API.g_exc_error;
3661: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3662: RAISE FND_API.g_exc_unexpected_error;
3663: END IF;
3664:

Line 3661: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3657:
3658: IF x_return_status = FND_API.g_ret_sts_error
3659: THEN
3660: RAISE FND_API.g_exc_error;
3661: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3662: RAISE FND_API.g_exc_unexpected_error;
3663: END IF;
3664:
3665: refresh_budget_and_claims_info(l_api_version ,

Line 3662: RAISE FND_API.g_exc_unexpected_error;

3658: IF x_return_status = FND_API.g_ret_sts_error
3659: THEN
3660: RAISE FND_API.g_exc_error;
3661: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3662: RAISE FND_API.g_exc_unexpected_error;
3663: END IF;
3664:
3665: refresh_budget_and_claims_info(l_api_version ,
3666: l_init_msg_list,

Line 3672: IF x_return_status = FND_API.g_ret_sts_error

3668: x_return_status,
3669: x_msg_count,
3670: x_msg_data);
3671:
3672: IF x_return_status = FND_API.g_ret_sts_error
3673: THEN
3674: RAISE FND_API.g_exc_error;
3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3676: RAISE FND_API.g_exc_unexpected_error;

Line 3674: RAISE FND_API.g_exc_error;

3670: x_msg_data);
3671:
3672: IF x_return_status = FND_API.g_ret_sts_error
3673: THEN
3674: RAISE FND_API.g_exc_error;
3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3676: RAISE FND_API.g_exc_unexpected_error;
3677: END IF;
3678:

Line 3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN

3671:
3672: IF x_return_status = FND_API.g_ret_sts_error
3673: THEN
3674: RAISE FND_API.g_exc_error;
3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3676: RAISE FND_API.g_exc_unexpected_error;
3677: END IF;
3678:
3679: -- ozf_utility_pvt.write_conc_log('- End');

Line 3676: RAISE FND_API.g_exc_unexpected_error;

3672: IF x_return_status = FND_API.g_ret_sts_error
3673: THEN
3674: RAISE FND_API.g_exc_error;
3675: ELSIF x_return_status = FND_API.g_ret_sts_unexp_error THEN
3676: RAISE FND_API.g_exc_unexpected_error;
3677: END IF;
3678:
3679: -- ozf_utility_pvt.write_conc_log('- End');
3680:

Line 3702: WHEN FND_API.G_EXC_ERROR THEN

3698:
3699: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');
3700:
3701: EXCEPTION
3702: WHEN FND_API.G_EXC_ERROR THEN
3703: x_return_status := FND_API.g_ret_sts_error ;
3704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3705: p_count => x_msg_count,
3706: p_data => x_msg_data);

Line 3703: x_return_status := FND_API.g_ret_sts_error ;

3699: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' (+)');
3700:
3701: EXCEPTION
3702: WHEN FND_API.G_EXC_ERROR THEN
3703: x_return_status := FND_API.g_ret_sts_error ;
3704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3705: p_count => x_msg_count,
3706: p_data => x_msg_data);
3707: ERRBUF := x_msg_data;

Line 3704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,

3700:
3701: EXCEPTION
3702: WHEN FND_API.G_EXC_ERROR THEN
3703: x_return_status := FND_API.g_ret_sts_error ;
3704: FND_MSG_PUB.count_and_get (p_encoded => FND_API.G_FALSE,
3705: p_count => x_msg_count,
3706: p_data => x_msg_data);
3707: ERRBUF := x_msg_data;
3708: RETCODE := 2;

Line 3711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3707: ERRBUF := x_msg_data;
3708: RETCODE := 2;
3709: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
3710:
3711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3712: x_return_status := FND_API.g_ret_sts_unexp_error ;
3713: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3714: p_count => x_msg_count,
3715: p_data => x_msg_data);

Line 3712: x_return_status := FND_API.g_ret_sts_unexp_error ;

3708: RETCODE := 2;
3709: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
3710:
3711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3712: x_return_status := FND_API.g_ret_sts_unexp_error ;
3713: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3714: p_count => x_msg_count,
3715: p_data => x_msg_data);
3716: ERRBUF := x_msg_data;

Line 3713: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

3709: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Expected Error');
3710:
3711: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3712: x_return_status := FND_API.g_ret_sts_unexp_error ;
3713: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3714: p_count => x_msg_count,
3715: p_data => x_msg_data);
3716: ERRBUF := x_msg_data;
3717: RETCODE := 2;

Line 3721: x_return_status := FND_API.g_ret_sts_unexp_error ;

3717: RETCODE := 2;
3718: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');
3719:
3720: WHEN OTHERS THEN
3721: x_return_status := FND_API.g_ret_sts_unexp_error ;
3722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3723: p_count => x_msg_count,
3724: p_data => x_msg_data);
3725:

Line 3722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,

3718: ozf_utility_pvt.write_conc_log('Private API: ' || l_api_name || ' Error');
3719:
3720: WHEN OTHERS THEN
3721: x_return_status := FND_API.g_ret_sts_unexp_error ;
3722: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,
3723: p_count => x_msg_count,
3724: p_data => x_msg_data);
3725:
3726: ERRBUF := sqlerrm(sqlcode);