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

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

18:
19: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_ACTFORECAST_PVT'; -- Name of the current package.
20: G_DEBUG_FLAG VARCHAR2(1) := 'N';
21:
22: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26:

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

19: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_ACTFORECAST_PVT'; -- Name of the current package.
20: G_DEBUG_FLAG VARCHAR2(1) := 'N';
21:
22: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26:
27: ---------------------------------------------------------------------

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

20: G_DEBUG_FLAG VARCHAR2(1) := 'N';
21:
22: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
23: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
24: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
25:
26:
27: ---------------------------------------------------------------------
28: -- PROCEDURE

Line 136: FND_MSG_PUB.Initialize;

132: --
133: -- Initialize message list if p_init_msg_list is set to TRUE.
134: --
135: IF FND_API.To_Boolean (p_init_msg_list) THEN
136: FND_MSG_PUB.Initialize;
137: END IF;
138:
139: --
140: -- Initialize API return status to success.

Line 246: FND_MSG_PUB.Initialize;

242: --
243: -- Initialize message list if p_init_msg_list is set to TRUE.
244: --
245: IF FND_API.To_Boolean (p_init_msg_list) THEN
246: FND_MSG_PUB.Initialize;
247: END IF;
248:
249: --
250: -- Standard check for API version compatibility.

Line 499: FND_MSG_PUB.Count_And_Get (

495: --
496: -- Standard API to get message count, and if 1,
497: -- set the message data OUT NOCOPY variable.
498: --
499: FND_MSG_PUB.Count_And_Get (
500: p_count => x_msg_count,
501: p_data => x_msg_data,
502: p_encoded => FND_API.G_FALSE
503: );

Line 526: FND_MSG_PUB.Count_And_Get (

522:
523:
524: ROLLBACK TO Create_ActForecast_Pvt;
525: x_return_status := FND_API.G_RET_STS_ERROR;
526: FND_MSG_PUB.Count_And_Get (
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 536: FND_MSG_PUB.Count_And_Get (

532:
533:
534: ROLLBACK TO Create_ActForecast_Pvt;
535: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
536: FND_MSG_PUB.Count_And_Get (
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
540: WHEN OTHERS THEN

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

541:
542:
543: ROLLBACK TO Create_ActForecast_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
546: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
547: END IF;
548: FND_MSG_PUB.Count_And_Get (
549: p_count => x_msg_count,

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

542:
543: ROLLBACK TO Create_ActForecast_Pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
546: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
547: END IF;
548: FND_MSG_PUB.Count_And_Get (
549: p_count => x_msg_count,
550: p_data => x_msg_data

Line 548: FND_MSG_PUB.Count_And_Get (

544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
546: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
547: END IF;
548: FND_MSG_PUB.Count_And_Get (
549: p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552: END Create_ActForecast;

Line 611: FND_MSG_PUB.Initialize;

607: --
608: -- Initialize message list if p_init_msg_list is set to TRUE.
609: --
610: IF FND_API.To_Boolean (p_init_msg_list) THEN
611: FND_MSG_PUB.Initialize;
612: END IF;
613:
614: --
615: -- Standard check for API version compatibility.

Line 780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

776: THEN
777: --
778: -- Add error message to API message list.
779: --
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
781: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
782: FND_MSG_PUB.add;
783: END IF;
784: RAISE FND_API.g_exc_error;

Line 782: FND_MSG_PUB.add;

778: -- Add error message to API message list.
779: --
780: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
781: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
782: FND_MSG_PUB.add;
783: END IF;
784: RAISE FND_API.g_exc_error;
785: END IF;
786:

Line 800: FND_MSG_PUB.Count_And_Get (

796: --
797: -- Standard API to get message count, and if 1,
798: -- set the message data OUT NOCOPY variable.
799: --
800: FND_MSG_PUB.Count_And_Get (
801: p_count => x_msg_count,
802: p_data => x_msg_data,
803: p_encoded => FND_API.G_FALSE
804: );

Line 821: FND_MSG_PUB.Count_And_Get (

817:
818: ROLLBACK TO Update_ActForecast_pvt;
819:
820: x_return_status := FND_API.G_RET_STS_ERROR;
821: FND_MSG_PUB.Count_And_Get (
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 829: FND_MSG_PUB.Count_And_Get (

825: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
826:
827: ROLLBACK TO Update_ActForecast_pvt;
828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
829: FND_MSG_PUB.Count_And_Get (
830: p_count => x_msg_count,
831: p_data => x_msg_data
832: );
833: WHEN OTHERS THEN

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

833: WHEN OTHERS THEN
834:
835: ROLLBACK TO Update_ActForecast_pvt;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
838: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
839: END IF;
840: FND_MSG_PUB.Count_And_Get (
841: p_count => x_msg_count,

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

834:
835: ROLLBACK TO Update_ActForecast_pvt;
836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
838: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
839: END IF;
840: FND_MSG_PUB.Count_And_Get (
841: p_count => x_msg_count,
842: p_data => x_msg_data

Line 840: FND_MSG_PUB.Count_And_Get (

836: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
837: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
838: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
839: END IF;
840: FND_MSG_PUB.Count_And_Get (
841: p_count => x_msg_count,
842: p_data => x_msg_data
843: );
844: END Update_ActForecast;

Line 897: FND_MSG_PUB.Initialize;

893: --
894: -- Initialize message list if p_init_msg_list is set to TRUE.
895: --
896: IF FND_API.To_Boolean (p_init_msg_list) THEN
897: FND_MSG_PUB.Initialize;
898: END IF;
899:
900: --
901: -- Standard check for API version compatibility.

Line 954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

950: DELETE from ozf_act_forecasts_all
951: WHERE forecast_id = p_forecast_id;
952:
953: IF (SQL%NOTFOUND) THEN
954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
955: THEN
956:
957: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
958: FND_MSG_PUB.add;

Line 958: FND_MSG_PUB.add;

954: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
955: THEN
956:
957: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
958: FND_MSG_PUB.add;
959: RAISE FND_API.g_exc_error;
960: END IF;
961: END IF;
962:

Line 986: FND_MSG_PUB.Count_And_Get (

982: --
983: -- Standard API to get message count, and if 1,
984: -- set the message data OUT NOCOPY variable.
985: --
986: FND_MSG_PUB.Count_And_Get (
987: p_count => x_msg_count,
988: p_data => x_msg_data,
989: p_encoded => FND_API.G_FALSE
990: );

Line 996: FND_MSG_PUB.Count_And_Get (

992: EXCEPTION
993: WHEN FND_API.G_EXC_ERROR THEN
994: ROLLBACK TO Delete_ActForecast_pvt;
995: x_return_status := FND_API.G_RET_STS_ERROR;
996: FND_MSG_PUB.Count_And_Get (
997: p_count => x_msg_count,
998: p_data => x_msg_data
999: );
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1003: FND_MSG_PUB.Count_And_Get (

999: );
1000: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1001: ROLLBACK TO Delete_ActForecast_pvt;
1002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1003: FND_MSG_PUB.Count_And_Get (
1004: p_count => x_msg_count,
1005: p_data => x_msg_data
1006: );
1007: WHEN OTHERS THEN

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

1006: );
1007: WHEN OTHERS THEN
1008: ROLLBACK TO Delete_ActForecast_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get (
1014: p_count => x_msg_count,

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

1007: WHEN OTHERS THEN
1008: ROLLBACK TO Delete_ActForecast_pvt;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get (
1014: p_count => x_msg_count,
1015: p_data => x_msg_data

Line 1013: FND_MSG_PUB.Count_And_Get (

1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1011: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1012: END IF;
1013: FND_MSG_PUB.Count_And_Get (
1014: p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1017: END Delete_ActForecast;

Line 1072: FND_MSG_PUB.Initialize;

1068: --
1069: -- Initialize message list if p_init_msg_list is set to TRUE.
1070: --
1071: IF FND_API.To_Boolean (p_init_msg_list) THEN
1072: FND_MSG_PUB.Initialize;
1073: END IF;
1074:
1075: --
1076: -- Standard check for API version compatibility.

Line 1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1102: THEN
1103: CLOSE c_act_forecast_info;
1104: -- Error, check the msg level and added an error message to the
1105: -- API message list
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1108: FND_MSG_PUB.add;
1109: END IF;
1110: RAISE FND_API.g_exc_error;

Line 1108: FND_MSG_PUB.add;

1104: -- Error, check the msg level and added an error message to the
1105: -- API message list
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1108: FND_MSG_PUB.add;
1109: END IF;
1110: RAISE FND_API.g_exc_error;
1111: END IF;
1112: CLOSE c_act_forecast_info;

Line 1119: FND_MSG_PUB.Count_And_Get (

1115: --
1116: -- Standard API to get message count, and if 1,
1117: -- set the message data OUT NOCOPY variable.
1118: --
1119: FND_MSG_PUB.Count_And_Get (
1120: p_count => x_msg_count,
1121: p_data => x_msg_data,
1122: p_encoded => FND_API.G_FALSE
1123: );

Line 1137: FND_MSG_PUB.Count_And_Get (

1133:
1134: EXCEPTION
1135: WHEN FND_API.G_EXC_ERROR THEN
1136: x_return_status := FND_API.G_RET_STS_ERROR;
1137: FND_MSG_PUB.Count_And_Get (
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1143: FND_MSG_PUB.Count_And_Get (

1139: p_data => x_msg_data
1140: );
1141: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1143: FND_MSG_PUB.Count_And_Get (
1144: p_count => x_msg_count,
1145: p_data => x_msg_data
1146: );
1147: WHEN OZF_Utility_PVT.RESOURCE_LOCKED THEN

Line 1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1146: );
1147: WHEN OZF_Utility_PVT.RESOURCE_LOCKED THEN
1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1152: FND_MSG_PUB.add;
1153: END IF;
1154:

Line 1152: FND_MSG_PUB.add;

1148: x_return_status := FND_API.G_RET_STS_ERROR ;
1149:
1150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1151: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1152: FND_MSG_PUB.add;
1153: END IF;
1154:
1155: FND_MSG_PUB.Count_And_Get (
1156: p_count => x_msg_count,

Line 1155: FND_MSG_PUB.Count_And_Get (

1151: FND_MESSAGE.set_name('OZF', 'OZF_API_RESOURCE_LOCKED');
1152: FND_MSG_PUB.add;
1153: END IF;
1154:
1155: FND_MSG_PUB.Count_And_Get (
1156: p_count => x_msg_count,
1157: p_data => x_msg_data,
1158: p_encoded => FND_API.G_FALSE
1159: );

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

1158: p_encoded => FND_API.G_FALSE
1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1163: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get (
1166: p_count => x_msg_count,

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

1159: );
1160: WHEN OTHERS THEN
1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1163: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get (
1166: p_count => x_msg_count,
1167: p_data => x_msg_data,

Line 1165: FND_MSG_PUB.Count_And_Get (

1161: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1162: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1163: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1164: END IF;
1165: FND_MSG_PUB.Count_And_Get (
1166: p_count => x_msg_count,
1167: p_data => x_msg_data,
1168: p_encoded => FND_API.G_FALSE
1169: );

Line 1223: FND_MSG_PUB.Initialize;

1219: --
1220: -- Initialize message list if p_init_msg_list is set to TRUE.
1221: --
1222: IF FND_API.To_Boolean (p_init_msg_list) THEN
1223: FND_MSG_PUB.Initialize;
1224: END IF;
1225:
1226: --
1227: -- Standard check for API version compatibility.

Line 1318: FND_MSG_PUB.Count_And_Get (

1314: --
1315: -- Standard API to get message count, and if 1,
1316: -- set the message data OUT NOCOPY variable.
1317: --
1318: FND_MSG_PUB.Count_And_Get (
1319: p_count => x_msg_count,
1320: p_data => x_msg_data,
1321: p_encoded => FND_API.G_FALSE
1322: );

Line 1336: FND_MSG_PUB.Count_And_Get (

1332:
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := FND_API.G_RET_STS_ERROR;
1336: FND_MSG_PUB.Count_And_Get (
1337: p_count => x_msg_count,
1338: p_data => x_msg_data
1339: );
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1342: FND_MSG_PUB.Count_And_Get (

1338: p_data => x_msg_data
1339: );
1340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1341: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1342: FND_MSG_PUB.Count_And_Get (
1343: p_count => x_msg_count,
1344: p_data => x_msg_data
1345: );
1346: WHEN OTHERS THEN

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

1344: p_data => x_msg_data
1345: );
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1349: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get (
1352: p_count => x_msg_count,

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

1345: );
1346: WHEN OTHERS THEN
1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1349: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get (
1352: p_count => x_msg_count,
1353: p_data => x_msg_data

Line 1351: FND_MSG_PUB.Count_And_Get (

1347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1348: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1349: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1350: END IF;
1351: FND_MSG_PUB.Count_And_Get (
1352: p_count => x_msg_count,
1353: p_data => x_msg_data
1354: );
1355: END Validate_ActForecast;

Line 1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

1402: IF (OZF_DEBUG_HIGH_ON) THEN
1403:
1404: OZF_Utility_PVT.debug_message('forecast_id before raising exception : ' || x_complete_fcst_rec.forecast_id);
1405: END IF;
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1408: FND_MSG_PUB.add;
1409: END IF;
1410: RAISE FND_API.g_exc_error;

Line 1408: FND_MSG_PUB.add;

1404: OZF_Utility_PVT.debug_message('forecast_id before raising exception : ' || x_complete_fcst_rec.forecast_id);
1405: END IF;
1406: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1407: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
1408: FND_MSG_PUB.add;
1409: END IF;
1410: RAISE FND_API.g_exc_error;
1411: END IF;
1412: CLOSE c_act_forecast;

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

1689:
1690: IF p_act_forecast_rec.forecast_type IS NULL
1691: THEN
1692: -- missing required fields
1693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1694: THEN -- MMSG
1695: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_TYPE');
1696: FND_MSG_PUB.Add;
1697: END IF;

Line 1696: FND_MSG_PUB.Add;

1692: -- missing required fields
1693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1694: THEN -- MMSG
1695: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_TYPE');
1696: FND_MSG_PUB.Add;
1697: END IF;
1698:
1699: x_return_status := FND_API.G_RET_STS_ERROR;
1700:

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

1706:
1707: IF p_act_forecast_rec.arc_act_fcast_used_by IS NULL
1708: THEN
1709: -- missing required fields
1710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1711: THEN -- MMSG
1712: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1713: FND_MSG_PUB.Add;
1714: END IF;

Line 1713: FND_MSG_PUB.Add;

1709: -- missing required fields
1710: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1711: THEN -- MMSG
1712: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1713: FND_MSG_PUB.Add;
1714: END IF;
1715:
1716: x_return_status := FND_API.G_RET_STS_ERROR;
1717:

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

1723:
1724: IF p_act_forecast_rec.act_fcast_used_by_id IS NULL
1725: THEN
1726: -- missing required fields
1727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1728: THEN -- MMSG
1729: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1730: FND_MSG_PUB.Add;
1731: END IF;

Line 1730: FND_MSG_PUB.Add;

1726: -- missing required fields
1727: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1728: THEN -- MMSG
1729: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_ARC_USED_FOR');
1730: FND_MSG_PUB.Add;
1731: END IF;
1732:
1733: x_return_status := FND_API.G_RET_STS_ERROR;
1734:

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

1740:
1741: IF p_act_forecast_rec.forecast_calendar IS NULL
1742: THEN
1743: -- missing required fields
1744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1745: THEN -- MMSG
1746: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_CALENDAR');
1747: FND_MSG_PUB.Add;
1748: END IF;

Line 1747: FND_MSG_PUB.Add;

1743: -- missing required fields
1744: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1745: THEN -- MMSG
1746: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_CALENDAR');
1747: FND_MSG_PUB.Add;
1748: END IF;
1749:
1750: x_return_status := FND_API.G_RET_STS_ERROR;
1751:

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

1757:
1758: IF p_act_forecast_rec.forecast_uom_code IS NULL
1759: THEN
1760: -- missing required fields
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1762: THEN -- MMSG
1763: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_UOM_CODE');
1764: FND_MSG_PUB.Add;
1765: END IF;

Line 1764: FND_MSG_PUB.Add;

1760: -- missing required fields
1761: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1762: THEN -- MMSG
1763: FND_MESSAGE.Set_Name('OZF', 'OZF_FCST_MISSING_UOM_CODE');
1764: FND_MSG_PUB.Add;
1765: END IF;
1766:
1767: x_return_status := FND_API.G_RET_STS_ERROR;
1768:

Line 1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1823: p_table_name => 'ozf_act_forecasts_all',
1824: p_where_clause => l_where_clause
1825: ) = FND_API.g_false
1826: THEN
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1828: THEN
1829: FND_MESSAGE.set_name('OZF', 'OZF_FCST_DUP_ID');
1830: FND_MSG_PUB.add;
1831: END IF;

Line 1830: FND_MSG_PUB.add;

1826: THEN
1827: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1828: THEN
1829: FND_MESSAGE.set_name('OZF', 'OZF_FCST_DUP_ID');
1830: FND_MSG_PUB.add;
1831: END IF;
1832: x_return_status := FND_API.g_ret_sts_error;
1833: RETURN;
1834: END IF;

Line 1887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1883: p_lookup_type => 'OZF_FCAST_TYPE',
1884: p_lookup_code => l_act_forecast_rec.forecast_type
1885: ) = FND_API.g_false
1886: THEN
1887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1888: THEN
1889: FND_MESSAGE.set_name('OZF', 'OZF_FCST_INVALID_TYPE');
1890: FND_MSG_PUB.add;
1891: END IF;

Line 1890: FND_MSG_PUB.add;

1886: THEN
1887: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1888: THEN
1889: FND_MESSAGE.set_name('OZF', 'OZF_FCST_INVALID_TYPE');
1890: FND_MSG_PUB.add;
1891: END IF;
1892:
1893: x_return_status := FND_API.g_ret_sts_error;
1894: RETURN;

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

1901: IF l_act_forecast_rec.arc_act_fcast_used_by <> FND_API.G_MISS_CHAR THEN
1902: IF l_act_forecast_rec.arc_act_fcast_used_by not in ( 'CAMP','OFFR')
1903:
1904: THEN
1905: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909:

Line 1907: FND_MSG_PUB.Add;

1903:
1904: THEN
1905: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1906: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
1907: FND_MSG_PUB.Add;
1908: END IF;
1909:
1910: x_return_status := FND_API.G_RET_STS_ERROR;
1911: RETURN;

Line 1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1919: p_lookup_type => 'OZF_FCAST_BASE_VOL_SOURCE',
1920: p_lookup_code => l_act_forecast_rec.base_quantity_type
1921: ) = FND_API.g_false
1922: THEN
1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1924: THEN
1925: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_BASE_QTY');
1926: FND_MSG_PUB.add;
1927: END IF;

Line 1926: FND_MSG_PUB.add;

1922: THEN
1923: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1924: THEN
1925: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_BASE_QTY');
1926: FND_MSG_PUB.add;
1927: END IF;
1928:
1929: x_return_status := FND_API.g_ret_sts_error;
1930: RETURN;

Line 1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1940: p_lookup_type => 'OZF_FCAST_SPREAD',
1941: p_lookup_code => l_act_forecast_rec.forecast_spread_type
1942: ) = FND_API.g_false
1943: THEN
1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1945: THEN
1946: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_SPREAD_TYPE');
1947: FND_MSG_PUB.add;
1948: END IF;

Line 1947: FND_MSG_PUB.add;

1943: THEN
1944: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1945: THEN
1946: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_SPREAD_TYPE');
1947: FND_MSG_PUB.add;
1948: END IF;
1949:
1950: x_return_status := FND_API.g_ret_sts_error;
1951: RETURN;

Line 1967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1963: p_lookup_type => 'OZF_FCAST_UOM',
1964: p_lookup_code => l_act_forecast_rec.forecast_uom_code
1965: ) = FND_API.g_false
1966: THEN
1967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1968: THEN
1969: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_UOM_CODE');
1970: FND_MSG_PUB.add;
1971: END IF;

Line 1970: FND_MSG_PUB.add;

1966: THEN
1967: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1968: THEN
1969: FND_MESSAGE.set_name('OZF', 'OZF_FSCT_INVALID_UOM_CODE');
1970: FND_MSG_PUB.add;
1971: END IF;
1972:
1973: x_return_status := FND_API.g_ret_sts_error;
1974: RETURN;

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

2043: ,p_pk_data_type => l_pk_data_type
2044: ,p_additional_where_clause => NULL
2045: ) = FND_API.G_FALSE
2046: THEN
2047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2048: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
2049: FND_MSG_PUB.Add;
2050: END IF;
2051:

Line 2049: FND_MSG_PUB.Add;

2045: ) = FND_API.G_FALSE
2046: THEN
2047: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2048: FND_MESSAGE.Set_Name ('OZF', 'OZF_FCST_INVALID_USED_BY');
2049: FND_MSG_PUB.Add;
2050: END IF;
2051:
2052: x_return_status := FND_API.G_RET_STS_ERROR;
2053: RETURN;