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

Line 23: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);

19: -- Global variables and constants.
20:
21: G_PKG_NAME CONSTANT VARCHAR2(30) := 'Ozf_Actmetricfact_Pvt'; -- Name of the current package.
22: G_DEBUG_FLAG VARCHAR2(1) := 'N';
23: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
24:
25:
26: -- Start of comments
27: -- NAME

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

37: -- 24-Apr-2000 tdonohoe Created.
38: --
39: -- End of comments
40:
41: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Default_ActMetricFact(

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

38: --
39: -- End of comments
40:
41: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Default_ActMetricFact(
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

39: -- End of comments
40:
41: OZF_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: OZF_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: OZF_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Default_ActMetricFact(
46: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
47: p_act_metric_fact_rec IN act_metric_fact_rec_type,

Line 61: FND_MSG_PUB.Initialize;

57: --
58: -- Initialize message list if p_init_msg_list is set to TRUE.
59: --
60: IF FND_API.To_Boolean (p_init_msg_list) THEN
61: FND_MSG_PUB.Initialize;
62: END IF;
63:
64: --
65: -- Initialize API return status to success.

Line 198: FND_MSG_PUB.Initialize;

194: --
195: -- Initialize message list if p_init_msg_list is set to TRUE.
196: --
197: IF FND_API.To_Boolean (p_init_msg_list) THEN
198: FND_MSG_PUB.Initialize;
199: END IF;
200:
201: --
202: -- Standard check for API version compatibility.

Line 554: FND_MSG_PUB.Count_And_Get (

550: --
551: -- Standard API to get message count, and if 1,
552: -- set the message data OUT NOCOPY variable.
553: --
554: FND_MSG_PUB.Count_And_Get (
555: p_count => x_msg_count,
556: p_data => x_msg_data,
557: p_encoded => FND_API.G_FALSE
558: );

Line 577: FND_MSG_PUB.Count_And_Get (

573:
574:
575: ROLLBACK TO Create_ActMetricFact_Pvt;
576: x_return_status := FND_API.G_RET_STS_ERROR;
577: FND_MSG_PUB.Count_And_Get (
578: p_count => x_msg_count,
579: p_data => x_msg_data
580: );
581: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 587: FND_MSG_PUB.Count_And_Get (

583:
584:
585: ROLLBACK TO Create_ActMetricFact_Pvt;
586: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
587: FND_MSG_PUB.Count_And_Get (
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );
591: WHEN OTHERS THEN

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

592:
593:
594: ROLLBACK TO Create_ActMetricFact_Pvt;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
597: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
598: END IF;
599: FND_MSG_PUB.Count_And_Get (
600: p_count => x_msg_count,

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

593:
594: ROLLBACK TO Create_ActMetricFact_Pvt;
595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
597: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
598: END IF;
599: FND_MSG_PUB.Count_And_Get (
600: p_count => x_msg_count,
601: p_data => x_msg_data

Line 599: FND_MSG_PUB.Count_And_Get (

595: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
596: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
597: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
598: END IF;
599: FND_MSG_PUB.Count_And_Get (
600: p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603: END Create_ActMetricFact;

Line 661: FND_MSG_PUB.Initialize;

657: --
658: -- Initialize message list if p_init_msg_list is set to TRUE.
659: --
660: IF FND_API.To_Boolean (p_init_msg_list) THEN
661: FND_MSG_PUB.Initialize;
662: END IF;
663:
664: --
665: -- Standard check for API version compatibility.

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

879: THEN
880: --
881: -- Add error message to API message list.
882: --
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
884: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;

Line 885: FND_MSG_PUB.add;

881: -- Add error message to API message list.
882: --
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
884: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;
888: END IF;
889:

Line 903: FND_MSG_PUB.Count_And_Get (

899: --
900: -- Standard API to get message count, and if 1,
901: -- set the message data OUT NOCOPY variable.
902: --
903: FND_MSG_PUB.Count_And_Get (
904: p_count => x_msg_count,
905: p_data => x_msg_data,
906: p_encoded => FND_API.G_FALSE
907: );

Line 925: FND_MSG_PUB.Count_And_Get (

921:
922:
923: ROLLBACK TO Update_ActMetricFact_pvt;
924: x_return_status := FND_API.G_RET_STS_ERROR;
925: FND_MSG_PUB.Count_And_Get (
926: p_count => x_msg_count,
927: p_data => x_msg_data
928: );
929: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 935: FND_MSG_PUB.Count_And_Get (

931:
932:
933: ROLLBACK TO Update_ActMetricFact_pvt;
934: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
935: FND_MSG_PUB.Count_And_Get (
936: p_count => x_msg_count,
937: p_data => x_msg_data
938: );
939: WHEN OTHERS THEN

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

941:
942:
943: ROLLBACK TO Update_ActMetricFact_pvt;
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
946: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
947: END IF;
948: FND_MSG_PUB.Count_And_Get (
949: p_count => x_msg_count,

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

942:
943: ROLLBACK TO Update_ActMetricFact_pvt;
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
946: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
947: END IF;
948: FND_MSG_PUB.Count_And_Get (
949: p_count => x_msg_count,
950: p_data => x_msg_data

Line 948: FND_MSG_PUB.Count_And_Get (

944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
946: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
947: END IF;
948: FND_MSG_PUB.Count_And_Get (
949: p_count => x_msg_count,
950: p_data => x_msg_data
951: );
952: END Update_ActMetricFact;

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

982: OPEN c_act_metric_fact;
983: FETCH c_act_metric_fact INTO l_act_metric_fact_rec;
984: IF c_act_metric_fact%NOTFOUND THEN
985: CLOSE c_act_metric_fact;
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
988: FND_MSG_PUB.add;
989: END IF;
990: RAISE FND_API.g_exc_error;

Line 988: FND_MSG_PUB.add;

984: IF c_act_metric_fact%NOTFOUND THEN
985: CLOSE c_act_metric_fact;
986: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
987: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
988: FND_MSG_PUB.add;
989: END IF;
990: RAISE FND_API.g_exc_error;
991: END IF;
992: CLOSE c_act_metric_fact;

Line 1743: FND_MSG_PUB.Initialize;

1739: --
1740: -- Initialize message list if p_init_msg_list is set to TRUE.
1741: --
1742: IF FND_API.To_Boolean (p_init_msg_list) THEN
1743: FND_MSG_PUB.Initialize;
1744: END IF;
1745:
1746: --
1747: -- Standard check for API version compatibility.

Line 1828: FND_MSG_PUB.Count_And_Get (

1824: --
1825: -- Standard API to get message count, and if 1,
1826: -- set the message data OUT NOCOPY variable.
1827: --
1828: FND_MSG_PUB.Count_And_Get (
1829: p_count => x_msg_count,
1830: p_data => x_msg_data,
1831: p_encoded => FND_API.G_FALSE
1832: );

Line 1855: FND_MSG_PUB.Count_And_Get (

1851:
1852: EXCEPTION
1853: WHEN FND_API.G_EXC_ERROR THEN
1854: x_return_status := FND_API.G_RET_STS_ERROR;
1855: FND_MSG_PUB.Count_And_Get (
1856: p_count => x_msg_count,
1857: p_data => x_msg_data
1858: );
1859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1861: FND_MSG_PUB.Count_And_Get (

1857: p_data => x_msg_data
1858: );
1859: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1861: FND_MSG_PUB.Count_And_Get (
1862: p_count => x_msg_count,
1863: p_data => x_msg_data
1864: );
1865: WHEN OTHERS THEN

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

1863: p_data => x_msg_data
1864: );
1865: WHEN OTHERS THEN
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1869: END IF;
1870: FND_MSG_PUB.Count_And_Get (
1871: p_count => x_msg_count,

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

1864: );
1865: WHEN OTHERS THEN
1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1869: END IF;
1870: FND_MSG_PUB.Count_And_Get (
1871: p_count => x_msg_count,
1872: p_data => x_msg_data

Line 1870: FND_MSG_PUB.Count_And_Get (

1866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1867: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1868: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
1869: END IF;
1870: FND_MSG_PUB.Count_And_Get (
1871: p_count => x_msg_count,
1872: p_data => x_msg_data
1873: );
1874: END Validate_ActMetFact;

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

1905:
1906: IF p_act_metric_fact_rec.act_metric_used_by_id IS NULL
1907: THEN
1908: -- missing required fields
1909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN -- MMSG
1911: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1912: FND_MSG_PUB.Add;
1913: END IF;

Line 1912: FND_MSG_PUB.Add;

1908: -- missing required fields
1909: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1910: THEN -- MMSG
1911: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1912: FND_MSG_PUB.Add;
1913: END IF;
1914:
1915: x_return_status := FND_API.G_RET_STS_ERROR;
1916:

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

1924:
1925: IF p_act_metric_fact_rec.arc_act_metric_used_by IS NULL
1926: THEN
1927: -- missing required fields
1928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1929: THEN -- MMSG
1930: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1931: FND_MSG_PUB.Add;
1932: END IF;

Line 1931: FND_MSG_PUB.Add;

1927: -- missing required fields
1928: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1929: THEN -- MMSG
1930: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ARC_USED_FOR');
1931: FND_MSG_PUB.Add;
1932: END IF;
1933:
1934: x_return_status := FND_API.G_RET_STS_ERROR;
1935:

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

1943:
1944: IF p_act_metric_fact_rec.value_type IS NULL
1945: THEN
1946: -- missing required fields
1947: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1948: THEN -- MMSG
1949: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_VAL_TYPE');
1950: FND_MSG_PUB.Add;
1951: END IF;

Line 1950: FND_MSG_PUB.Add;

1946: -- missing required fields
1947: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1948: THEN -- MMSG
1949: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_VAL_TYPE');
1950: FND_MSG_PUB.Add;
1951: END IF;
1952:
1953: x_return_status := FND_API.G_RET_STS_ERROR;
1954:

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

1963:
1964: IF p_act_metric_fact_rec.activity_metric_id IS NULL
1965: THEN
1966: -- missing required fields
1967: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1968: THEN -- MMSG
1969: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ACT_METRIC_ID');
1970: FND_MSG_PUB.Add;
1971: END IF;

Line 1970: FND_MSG_PUB.Add;

1966: -- missing required fields
1967: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1968: THEN -- MMSG
1969: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_ACT_METRIC_ID');
1970: FND_MSG_PUB.Add;
1971: END IF;
1972:
1973: x_return_status := FND_API.G_RET_STS_ERROR;
1974:

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

1982:
1983: IF p_act_metric_fact_rec.trans_forecasted_value IS NULL
1984: THEN
1985: -- missing required fields
1986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1987: THEN -- MMSG
1988: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_TRAN_FCST_VAL');
1989: FND_MSG_PUB.Add;
1990: END IF;

Line 1989: FND_MSG_PUB.Add;

1985: -- missing required fields
1986: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1987: THEN -- MMSG
1988: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_TRAN_FCST_VAL');
1989: FND_MSG_PUB.Add;
1990: END IF;
1991:
1992: x_return_status := FND_API.G_RET_STS_ERROR;
1993:

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

2001: --FUNCTIONAL_CURRENCY_CODE
2002: IF p_act_metric_fact_rec.functional_currency_code IS NULL
2003: THEN
2004: -- missing required fields
2005: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2006: THEN -- MMSG
2007: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FUNC_CUR_CODE');
2008: FND_MSG_PUB.Add;
2009: END IF;

Line 2008: FND_MSG_PUB.Add;

2004: -- missing required fields
2005: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2006: THEN -- MMSG
2007: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FUNC_CUR_CODE');
2008: FND_MSG_PUB.Add;
2009: END IF;
2010:
2011: x_return_status := FND_API.G_RET_STS_ERROR;
2012:

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

2020:
2021: IF p_act_metric_fact_rec.func_forecasted_value IS NULL
2022: THEN
2023: -- missing required fields
2024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2025: THEN -- MMSG
2026: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FUNC_FCST_VAL');
2027: FND_MSG_PUB.Add;
2028: END IF;

Line 2027: FND_MSG_PUB.Add;

2023: -- missing required fields
2024: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2025: THEN -- MMSG
2026: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FUNC_FCST_VAL');
2027: FND_MSG_PUB.Add;
2028: END IF;
2029:
2030: x_return_status := FND_API.G_RET_STS_ERROR;
2031:

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

2040:
2041: IF p_act_metric_fact_rec.de_metric_id IS NULL
2042: THEN
2043: -- missing required fields
2044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2045: THEN -- MMSG
2046: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_METRIC_ID');
2047: FND_MSG_PUB.Add;
2048: END IF;

Line 2047: FND_MSG_PUB.Add;

2043: -- missing required fields
2044: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2045: THEN -- MMSG
2046: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_METRIC_ID');
2047: FND_MSG_PUB.Add;
2048: END IF;
2049:
2050: x_return_status := FND_API.G_RET_STS_ERROR;
2051:

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

2060:
2061: IF p_act_metric_fact_rec.time_id1 IS NULL
2062: THEN
2063: -- missing required fields
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN -- MMSG
2066: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_TIME_ID1');
2067: FND_MSG_PUB.Add;
2068: END IF;

Line 2067: FND_MSG_PUB.Add;

2063: -- missing required fields
2064: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2065: THEN -- MMSG
2066: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_TIME_ID1');
2067: FND_MSG_PUB.Add;
2068: END IF;
2069:
2070: x_return_status := FND_API.G_RET_STS_ERROR;
2071:

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

2091:
2092:
2093:
2094: -- missing required fields
2095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2096: THEN -- MMSG
2097: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_NODE_ID');
2098: FND_MSG_PUB.Add;
2099: END IF;

Line 2098: FND_MSG_PUB.Add;

2094: -- missing required fields
2095: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2096: THEN -- MMSG
2097: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_NODE_ID');
2098: FND_MSG_PUB.Add;
2099: END IF;
2100:
2101: x_return_status := FND_API.G_RET_STS_ERROR;
2102:

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

2109:
2110: IF p_act_metric_fact_rec.fact_value IS NULL
2111: THEN
2112: -- missing required fields
2113: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2114: THEN -- MMSG
2115: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FACT_VAL');
2116: FND_MSG_PUB.Add;
2117: END IF;

Line 2116: FND_MSG_PUB.Add;

2112: -- missing required fields
2113: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2114: THEN -- MMSG
2115: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_MISSING_FACT_VAL');
2116: FND_MSG_PUB.Add;
2117: END IF;
2118:
2119: x_return_status := FND_API.G_RET_STS_ERROR;
2120:

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

2169: p_table_name => 'ozf_act_metric_facts_all',
2170: p_where_clause => l_where_clause
2171: ) = FND_API.g_false
2172: THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2174: THEN
2175: FND_MESSAGE.set_name('OZF', 'OZF_METR_FACT_DUP_ID');
2176: FND_MSG_PUB.add;
2177: END IF;

Line 2176: FND_MSG_PUB.add;

2172: THEN
2173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
2174: THEN
2175: FND_MESSAGE.set_name('OZF', 'OZF_METR_FACT_DUP_ID');
2176: FND_MSG_PUB.add;
2177: END IF;
2178: x_return_status := FND_API.g_ret_sts_error;
2179: RETURN;
2180: END IF;

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

2252: ,p_pk_data_type => l_pk_data_type
2253: ,p_additional_where_clause => l_additional_where_clause
2254: ) = FND_API.G_FALSE
2255: THEN
2256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2257: THEN
2258: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_INVALID_MET');
2259: FND_MSG_PUB.Add;
2260: END IF;

Line 2259: FND_MSG_PUB.Add;

2255: THEN
2256: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2257: THEN
2258: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_INVALID_MET');
2259: FND_MSG_PUB.Add;
2260: END IF;
2261:
2262: x_return_status := FND_API.G_RET_STS_ERROR;
2263: RETURN;

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

2271: IF l_act_metric_fact_rec.arc_act_metric_used_by <> FND_API.G_MISS_CHAR THEN
2272: IF l_act_metric_fact_rec.arc_act_metric_used_by NOT IN
2273: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST')
2274: THEN
2275: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2276: FND_MESSAGE.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
2277: FND_MSG_PUB.Add;
2278: END IF;
2279:

Line 2277: FND_MSG_PUB.Add;

2273: ('CAMP','CSCH','EVEH','EVEO','DELV','FUND','FCST')
2274: THEN
2275: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2276: FND_MESSAGE.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
2277: FND_MSG_PUB.Add;
2278: END IF;
2279:
2280: x_return_status := FND_API.G_RET_STS_ERROR;
2281: RETURN;

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

2304:
2305:
2306: IF c_hierarchy_node_check%FOUND THEN
2307: CLOSE c_hierarchy_node_check;
2308: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2309: FND_MESSAGE.set_name('OZF', 'OZF_METR_FACT_DUP_NODE_ID');
2310: FND_MSG_PUB.add;
2311: RAISE FND_API.g_exc_error;
2312: END IF;

Line 2310: FND_MSG_PUB.add;

2306: IF c_hierarchy_node_check%FOUND THEN
2307: CLOSE c_hierarchy_node_check;
2308: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2309: FND_MESSAGE.set_name('OZF', 'OZF_METR_FACT_DUP_NODE_ID');
2310: FND_MSG_PUB.add;
2311: RAISE FND_API.g_exc_error;
2312: END IF;
2313: ELSE
2314: CLOSE c_hierarchy_node_check;

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

2387: ,p_additional_where_clause => l_additional_where_clause
2388: ) = FND_API.G_FALSE
2389: THEN
2390:
2391: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_INVALID_ACT_USAGE');
2394: FND_MSG_PUB.Add;
2395: END IF;

Line 2394: FND_MSG_PUB.Add;

2390:
2391: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2392: THEN
2393: FND_MESSAGE.Set_Name('OZF', 'OZF_METR_INVALID_ACT_USAGE');
2394: FND_MSG_PUB.Add;
2395: END IF;
2396:
2397: x_return_status := FND_API.G_RET_STS_ERROR;
2398:

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

2424: ,p_pk_data_type => l_pk_data_type
2425: ,p_additional_where_clause => NULL
2426: ) = FND_API.G_FALSE
2427: THEN
2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2429: FND_MESSAGE.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
2430: FND_MSG_PUB.Add;
2431: END IF;
2432:

Line 2430: FND_MSG_PUB.Add;

2426: ) = FND_API.G_FALSE
2427: THEN
2428: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2429: FND_MESSAGE.Set_Name ('OZF', 'OZF_METR_INVALID_USED_BY');
2430: FND_MSG_PUB.Add;
2431: END IF;
2432:
2433: x_return_status := FND_API.G_RET_STS_ERROR;
2434: RETURN;

Line 2538: FND_MSG_PUB.Initialize;

2534: --
2535: -- Initialize message list if p_init_msg_list is set to TRUE.
2536: --
2537: IF FND_API.To_Boolean (p_init_msg_list) THEN
2538: FND_MSG_PUB.Initialize;
2539: END IF;
2540:
2541: --
2542: -- Initialize API return status to success.

Line 2587: FND_MSG_PUB.Initialize;

2583: --
2584: -- Initialize message list if p_init_msg_list is set to TRUE.
2585: --
2586: IF FND_API.To_Boolean (p_init_msg_list) THEN
2587: FND_MSG_PUB.Initialize;
2588: END IF;
2589:
2590: --
2591: -- Initialize API return status to success.

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

2633:
2634: IF p_formula_rec.activity_metric_id IS NULL
2635: THEN
2636: -- missing required fields
2637: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2638: THEN -- MMSG
2639: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ACT_METRIC_ID');
2640: FND_MSG_PUB.Add;
2641: END IF;

Line 2640: FND_MSG_PUB.Add;

2636: -- missing required fields
2637: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2638: THEN -- MMSG
2639: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ACT_METRIC_ID');
2640: FND_MSG_PUB.Add;
2641: END IF;
2642:
2643: x_return_status := FND_API.G_RET_STS_ERROR;
2644:

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

2650:
2651: IF p_formula_rec.level_depth IS NULL
2652: THEN
2653: -- missing required fields
2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2655: THEN -- MMSG
2656: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_LEVEL_DEPTH');
2657: FND_MSG_PUB.Add;
2658: END IF;

Line 2657: FND_MSG_PUB.Add;

2653: -- missing required fields
2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2655: THEN -- MMSG
2656: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_LEVEL_DEPTH');
2657: FND_MSG_PUB.Add;
2658: END IF;
2659:
2660: x_return_status := FND_API.G_RET_STS_ERROR;
2661:

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

2700:
2701: IF p_formula_entry_rec.formula_id IS NULL
2702: THEN
2703: -- missing required fields
2704: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN -- MMSG
2706: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_FORMULA_ID');
2707: FND_MSG_PUB.Add;
2708: END IF;

Line 2707: FND_MSG_PUB.Add;

2703: -- missing required fields
2704: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2705: THEN -- MMSG
2706: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_FORMULA_ID');
2707: FND_MSG_PUB.Add;
2708: END IF;
2709:
2710: x_return_status := FND_API.G_RET_STS_ERROR;
2711:

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

2716: --ORDER_NUMBER
2717: IF p_formula_entry_rec.order_number IS NULL
2718: THEN
2719: -- missing required fields
2720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2721: THEN -- MMSG
2722: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ORDER_NUM');
2723: FND_MSG_PUB.Add;
2724: END IF;

Line 2723: FND_MSG_PUB.Add;

2719: -- missing required fields
2720: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2721: THEN -- MMSG
2722: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ORDER_NUM');
2723: FND_MSG_PUB.Add;
2724: END IF;
2725:
2726: x_return_status := FND_API.G_RET_STS_ERROR;
2727:

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

2732: -- FORMULA_ENTRY_TYPE
2733: IF p_formula_entry_rec.formula_entry_type IS NULL
2734: THEN
2735: -- missing required fields
2736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2737: THEN -- MMSG
2738: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ENT_TYPE');
2739: FND_MSG_PUB.Add;
2740: END IF;

Line 2739: FND_MSG_PUB.Add;

2735: -- missing required fields
2736: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2737: THEN -- MMSG
2738: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_ENT_TYPE');
2739: FND_MSG_PUB.Add;
2740: END IF;
2741:
2742: x_return_status := FND_API.G_RET_STS_ERROR;
2743:

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

2748: -- OBJECT_VERSION_NUMBER
2749: IF p_formula_entry_rec.object_version_number IS NULL
2750: THEN
2751: -- missing required fields
2752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2753: THEN -- MMSG
2754: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_OBJ_NUM');
2755: FND_MSG_PUB.Add;
2756: END IF;

Line 2755: FND_MSG_PUB.Add;

2751: -- missing required fields
2752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2753: THEN -- MMSG
2754: FND_MESSAGE.Set_Name('OZF', 'OZF_FML_MISSING_OBJ_NUM');
2755: FND_MSG_PUB.Add;
2756: END IF;
2757:
2758: x_return_status := FND_API.G_RET_STS_ERROR;
2759:

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

2811: FETCH c_formula_type INTO l_formula_count;
2812: CLOSE c_formula_type;
2813:
2814: IF (l_formula_count > 0) THEN
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2816:
2817: FND_MESSAGE.set_name('OZF', 'OZF_FML_MAX_LEVEL');
2818: FND_MSG_PUB.add;
2819: END IF;

Line 2818: FND_MSG_PUB.add;

2814: IF (l_formula_count > 0) THEN
2815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2816:
2817: FND_MESSAGE.set_name('OZF', 'OZF_FML_MAX_LEVEL');
2818: FND_MSG_PUB.add;
2819: END IF;
2820: x_return_status := FND_API.g_ret_sts_error;
2821: RETURN;
2822: END IF;

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

2864: FETCH c_formula_entry_type INTO l_formula_entry_count;
2865: CLOSE c_formula_entry_type;
2866:
2867: IF (l_formula_entry_count > 0) THEN
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2869:
2870: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_DUP_ORDNUM');
2871: FND_MSG_PUB.add;
2872: END IF;

Line 2871: FND_MSG_PUB.add;

2867: IF (l_formula_entry_count > 0) THEN
2868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2869:
2870: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_DUP_ORDNUM');
2871: FND_MSG_PUB.add;
2872: END IF;
2873: x_return_status := FND_API.g_ret_sts_error;
2874: RETURN;
2875: END IF;

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

2915:
2916: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_TYPE',
2917: p_lookup_code => l_formula_rec.formula_type) = FND_API.g_false THEN
2918:
2919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2920: FND_MESSAGE.set_name('OZF', 'OZF_FML_INVALID_TYPE');
2921: FND_MSG_PUB.add;
2922: END IF;
2923:

Line 2921: FND_MSG_PUB.add;

2917: p_lookup_code => l_formula_rec.formula_type) = FND_API.g_false THEN
2918:
2919: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2920: FND_MESSAGE.set_name('OZF', 'OZF_FML_INVALID_TYPE');
2921: FND_MSG_PUB.add;
2922: END IF;
2923:
2924: x_return_status := FND_API.g_ret_sts_error;
2925: RETURN;

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

2970:
2971: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_ENT_TYPE',
2972: p_lookup_code => l_formula_entry_rec.formula_entry_type) = FND_API.g_false THEN
2973:
2974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2975: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_TYPE');
2976: FND_MSG_PUB.add;
2977: END IF;
2978:

Line 2976: FND_MSG_PUB.add;

2972: p_lookup_code => l_formula_entry_rec.formula_entry_type) = FND_API.g_false THEN
2973:
2974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2975: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_TYPE');
2976: FND_MSG_PUB.add;
2977: END IF;
2978:
2979: x_return_status := FND_API.g_ret_sts_error;
2980: RETURN;

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

2988:
2989: IF ozf_utility_pvt.check_lookup_exists(p_lookup_type => 'OZF_FORMULA_OPERATOR',
2990: p_lookup_code => l_formula_entry_rec.formula_entry_operator) = FND_API.g_false THEN
2991:
2992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2993: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_OP');
2994: FND_MSG_PUB.add;
2995: END IF;
2996:

Line 2994: FND_MSG_PUB.add;

2990: p_lookup_code => l_formula_entry_rec.formula_entry_operator) = FND_API.g_false THEN
2991:
2992: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2993: FND_MESSAGE.set_name('OZF', 'OZF_FML_ENT_INVALID_OP');
2994: FND_MSG_PUB.add;
2995: END IF;
2996:
2997: x_return_status := FND_API.g_ret_sts_error;
2998: RETURN;

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

3046: ,p_pk_data_type => NULL
3047: ,p_additional_where_clause => NULL
3048: ) = FND_API.G_FALSE
3049: THEN
3050: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3051: FND_MESSAGE.Set_Name ('OZF', 'OZF_FML_INVALID_ACT_METRIC');
3052: FND_MSG_PUB.Add;
3053: END IF;
3054:

Line 3052: FND_MSG_PUB.Add;

3048: ) = FND_API.G_FALSE
3049: THEN
3050: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3051: FND_MESSAGE.Set_Name ('OZF', 'OZF_FML_INVALID_ACT_METRIC');
3052: FND_MSG_PUB.Add;
3053: END IF;
3054:
3055: x_return_status := FND_API.G_RET_STS_ERROR;
3056: RETURN;

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

3104: ,p_pk_data_type => NULL
3105: ,p_additional_where_clause => NULL
3106: ) = FND_API.G_FALSE
3107: THEN
3108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3109: FND_MESSAGE.Set_Name ('OZF', 'OZF_FML_INVALID_FORMULA_ID');
3110: FND_MSG_PUB.Add;
3111: END IF;
3112:

Line 3110: FND_MSG_PUB.Add;

3106: ) = FND_API.G_FALSE
3107: THEN
3108: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3109: FND_MESSAGE.Set_Name ('OZF', 'OZF_FML_INVALID_FORMULA_ID');
3110: FND_MSG_PUB.Add;
3111: END IF;
3112:
3113: x_return_status := FND_API.G_RET_STS_ERROR;
3114: RETURN;

Line 3287: FND_MSG_PUB.Initialize;

3283: --
3284: -- Initialize message list if p_init_msg_list is set to TRUE.
3285: --
3286: IF FND_API.To_Boolean (p_init_msg_list) THEN
3287: FND_MSG_PUB.Initialize;
3288: END IF;
3289:
3290: --
3291: -- Standard check for API version compatibility.

Line 3368: FND_MSG_PUB.Count_And_Get (

3364: --
3365: -- Standard API to get message count, and if 1,
3366: -- set the message data OUT variable.
3367: --
3368: FND_MSG_PUB.Count_And_Get (
3369: p_count => x_msg_count,
3370: p_data => x_msg_data,
3371: p_encoded => FND_API.G_FALSE
3372: );

Line 3382: FND_MSG_PUB.Count_And_Get (

3378:
3379: EXCEPTION
3380: WHEN FND_API.G_EXC_ERROR THEN
3381: x_return_status := FND_API.G_RET_STS_ERROR;
3382: FND_MSG_PUB.Count_And_Get (
3383: p_count => x_msg_count,
3384: p_data => x_msg_data
3385: );
3386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3388: FND_MSG_PUB.Count_And_Get (

3384: p_data => x_msg_data
3385: );
3386: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3388: FND_MSG_PUB.Count_And_Get (
3389: p_count => x_msg_count,
3390: p_data => x_msg_data
3391: );
3392: WHEN OTHERS THEN

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

3390: p_data => x_msg_data
3391: );
3392: WHEN OTHERS THEN
3393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3396: END IF;
3397: FND_MSG_PUB.Count_And_Get (
3398: p_count => x_msg_count,

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

3391: );
3392: WHEN OTHERS THEN
3393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3396: END IF;
3397: FND_MSG_PUB.Count_And_Get (
3398: p_count => x_msg_count,
3399: p_data => x_msg_data

Line 3397: FND_MSG_PUB.Count_And_Get (

3393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3394: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3395: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3396: END IF;
3397: FND_MSG_PUB.Count_And_Get (
3398: p_count => x_msg_count,
3399: p_data => x_msg_data
3400: );
3401: END Validate_Formula;

Line 3449: FND_MSG_PUB.Initialize;

3445: --
3446: -- Initialize message list if p_init_msg_list is set to TRUE.
3447: --
3448: IF FND_API.To_Boolean (p_init_msg_list) THEN
3449: FND_MSG_PUB.Initialize;
3450: END IF;
3451:
3452: --
3453: -- Standard check for API version compatibility.

Line 3530: FND_MSG_PUB.Count_And_Get (

3526: --
3527: -- Standard API to get message count, and if 1,
3528: -- set the message data OUT variable.
3529: --
3530: FND_MSG_PUB.Count_And_Get (
3531: p_count => x_msg_count,
3532: p_data => x_msg_data,
3533: p_encoded => FND_API.G_FALSE
3534: );

Line 3544: FND_MSG_PUB.Count_And_Get (

3540:
3541: EXCEPTION
3542: WHEN FND_API.G_EXC_ERROR THEN
3543: x_return_status := FND_API.G_RET_STS_ERROR;
3544: FND_MSG_PUB.Count_And_Get (
3545: p_count => x_msg_count,
3546: p_data => x_msg_data
3547: );
3548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3550: FND_MSG_PUB.Count_And_Get (

3546: p_data => x_msg_data
3547: );
3548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3550: FND_MSG_PUB.Count_And_Get (
3551: p_count => x_msg_count,
3552: p_data => x_msg_data
3553: );
3554: WHEN OTHERS THEN

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

3552: p_data => x_msg_data
3553: );
3554: WHEN OTHERS THEN
3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3558: END IF;
3559: FND_MSG_PUB.Count_And_Get (
3560: p_count => x_msg_count,

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

3553: );
3554: WHEN OTHERS THEN
3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3558: END IF;
3559: FND_MSG_PUB.Count_And_Get (
3560: p_count => x_msg_count,
3561: p_data => x_msg_data

Line 3559: FND_MSG_PUB.Count_And_Get (

3555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3556: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3557: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3558: END IF;
3559: FND_MSG_PUB.Count_And_Get (
3560: p_count => x_msg_count,
3561: p_data => x_msg_data
3562: );
3563: END Validate_Formula_Entry;

Line 3635: FND_MSG_PUB.Initialize;

3631: --
3632: -- Initialize message list if p_init_msg_list is set to TRUE.
3633: --
3634: IF FND_API.To_Boolean (p_init_msg_list) THEN
3635: FND_MSG_PUB.Initialize;
3636: END IF;
3637:
3638: --
3639: -- Standard check for API version compatibility.

Line 3789: FND_MSG_PUB.Count_And_Get (

3785: --
3786: -- Standard API to get message count, and if 1,
3787: -- set the message data OUT variable.
3788: --
3789: FND_MSG_PUB.Count_And_Get (
3790: p_count => x_msg_count,
3791: p_data => x_msg_data,
3792: p_encoded => FND_API.G_FALSE
3793: );

Line 3812: FND_MSG_PUB.Count_And_Get (

3808:
3809:
3810: ROLLBACK TO Create_Formula_Pvt;
3811: x_return_status := FND_API.G_RET_STS_ERROR;
3812: FND_MSG_PUB.Count_And_Get (
3813: p_count => x_msg_count,
3814: p_data => x_msg_data
3815: );
3816: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3822: FND_MSG_PUB.Count_And_Get (

3818:
3819:
3820: ROLLBACK TO Create_Formula_Pvt;
3821: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3822: FND_MSG_PUB.Count_And_Get (
3823: p_count => x_msg_count,
3824: p_data => x_msg_data
3825: );
3826: WHEN OTHERS THEN

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

3827:
3828:
3829: ROLLBACK TO Create_Formula_Pvt;
3830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3833: END IF;
3834: FND_MSG_PUB.Count_And_Get (
3835: p_count => x_msg_count,

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

3828:
3829: ROLLBACK TO Create_Formula_Pvt;
3830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3833: END IF;
3834: FND_MSG_PUB.Count_And_Get (
3835: p_count => x_msg_count,
3836: p_data => x_msg_data

Line 3834: FND_MSG_PUB.Count_And_Get (

3830: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3831: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3832: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
3833: END IF;
3834: FND_MSG_PUB.Count_And_Get (
3835: p_count => x_msg_count,
3836: p_data => x_msg_data
3837: );
3838:

Line 3911: FND_MSG_PUB.Initialize;

3907: --
3908: -- Initialize message list if p_init_msg_list is set to TRUE.
3909: --
3910: IF FND_API.To_Boolean (p_init_msg_list) THEN
3911: FND_MSG_PUB.Initialize;
3912: END IF;
3913:
3914: --
3915: -- Standard check for API version compatibility.

Line 4069: FND_MSG_PUB.Count_And_Get (

4065: --
4066: -- Standard API to get message count, and if 1,
4067: -- set the message data OUT variable.
4068: --
4069: FND_MSG_PUB.Count_And_Get (
4070: p_count => x_msg_count,
4071: p_data => x_msg_data,
4072: p_encoded => FND_API.G_FALSE
4073: );

Line 4092: FND_MSG_PUB.Count_And_Get (

4088:
4089:
4090: ROLLBACK TO Create_Formula_Entry_Pvt;
4091: x_return_status := FND_API.G_RET_STS_ERROR;
4092: FND_MSG_PUB.Count_And_Get (
4093: p_count => x_msg_count,
4094: p_data => x_msg_data
4095: );
4096: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4102: FND_MSG_PUB.Count_And_Get (

4098:
4099:
4100: ROLLBACK TO Create_Formula_Entry_Pvt;
4101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4102: FND_MSG_PUB.Count_And_Get (
4103: p_count => x_msg_count,
4104: p_data => x_msg_data
4105: );
4106: WHEN OTHERS THEN

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

4107:
4108:
4109: ROLLBACK TO Create_Formula_Entry_Pvt;
4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4113: END IF;
4114: FND_MSG_PUB.Count_And_Get (
4115: p_count => x_msg_count,

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

4108:
4109: ROLLBACK TO Create_Formula_Entry_Pvt;
4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4113: END IF;
4114: FND_MSG_PUB.Count_And_Get (
4115: p_count => x_msg_count,
4116: p_data => x_msg_data

Line 4114: FND_MSG_PUB.Count_And_Get (

4110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4111: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4112: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4113: END IF;
4114: FND_MSG_PUB.Count_And_Get (
4115: p_count => x_msg_count,
4116: p_data => x_msg_data
4117: );
4118:

Line 4173: FND_MSG_PUB.Initialize;

4169: --
4170: -- Initialize message list if p_init_msg_list is set to TRUE.
4171: --
4172: IF FND_API.To_Boolean (p_init_msg_list) THEN
4173: FND_MSG_PUB.Initialize;
4174: END IF;
4175:
4176: --
4177: -- Standard check for API version compatibility.

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

4207: WHERE formula_id = p_formula_id
4208: AND object_version_number = p_object_version_number;
4209:
4210: IF (SQL%NOTFOUND) THEN
4211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4212: THEN
4213:
4214: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4215: FND_MSG_PUB.add;

Line 4215: FND_MSG_PUB.add;

4211: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
4212: THEN
4213:
4214: FND_MESSAGE.set_name('OZF', 'OZF_API_RECORD_NOT_FOUND');
4215: FND_MSG_PUB.add;
4216: RAISE FND_API.g_exc_error;
4217: END IF;
4218: END IF;
4219:

Line 4244: FND_MSG_PUB.Count_And_Get (

4240: --
4241: -- Standard API to get message count, and if 1,
4242: -- set the message data OUT variable.
4243: --
4244: FND_MSG_PUB.Count_And_Get (
4245: p_count => x_msg_count,
4246: p_data => x_msg_data,
4247: p_encoded => FND_API.G_FALSE
4248: );

Line 4254: FND_MSG_PUB.Count_And_Get (

4250: EXCEPTION
4251: WHEN FND_API.G_EXC_ERROR THEN
4252: ROLLBACK TO Delete_Formula_pvt;
4253: x_return_status := FND_API.G_RET_STS_ERROR;
4254: FND_MSG_PUB.Count_And_Get (
4255: p_count => x_msg_count,
4256: p_data => x_msg_data
4257: );
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 4261: FND_MSG_PUB.Count_And_Get (

4257: );
4258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4259: ROLLBACK TO Delete_Formula_pvt;
4260: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4261: FND_MSG_PUB.Count_And_Get (
4262: p_count => x_msg_count,
4263: p_data => x_msg_data
4264: );
4265: WHEN OTHERS THEN

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

4264: );
4265: WHEN OTHERS THEN
4266: ROLLBACK TO Delete_Formula_pvt;
4267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4270: END IF;
4271: FND_MSG_PUB.Count_And_Get (
4272: p_count => x_msg_count,

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

4265: WHEN OTHERS THEN
4266: ROLLBACK TO Delete_Formula_pvt;
4267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4270: END IF;
4271: FND_MSG_PUB.Count_And_Get (
4272: p_count => x_msg_count,
4273: p_data => x_msg_data

Line 4271: FND_MSG_PUB.Count_And_Get (

4267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4268: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4269: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, L_API_NAME);
4270: END IF;
4271: FND_MSG_PUB.Count_And_Get (
4272: p_count => x_msg_count,
4273: p_data => x_msg_data
4274: );
4275: END Delete_Formula;