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

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

1: Package BODY OZF_Offer_PUB AS
2: /* $Header: ozfpofrb.pls 120.12.12020000.3 2013/03/10 03:16:25 bkunjan ship $ */
3:
4: G_DEBUG BOOLEAN := FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_debug_high);
5:
6:
7: PROCEDURE process_modifiers(
8: p_init_msg_list IN VARCHAR2

Line 69: Fnd_Msg_Pub.initialize;

65: BEGIN
66:
67: SAVEPOINT process_modifiers_pub;
68: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
69: Fnd_Msg_Pub.initialize;
70: END IF;
71:
72: IF NOT Fnd_Api.compatible_api_call(l_api_version,
73: p_api_version,

Line 1157: Fnd_Msg_Pub.Count_AND_Get

1153: EXCEPTION
1154: WHEN Fnd_Api.G_EXC_ERROR THEN
1155: x_return_status := Fnd_Api.g_ret_sts_error ;
1156: ROLLBACK TO process_modifiers_pub;
1157: Fnd_Msg_Pub.Count_AND_Get
1158: ( p_count => x_msg_count,
1159: p_data => x_msg_data,
1160: p_encoded => Fnd_Api.G_FALSE
1161: );

Line 1165: Fnd_Msg_Pub.Count_AND_Get

1161: );
1162: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1163: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1164: ROLLBACK TO process_modifiers_pub;
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 1173: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )

1169: );
1170: WHEN OTHERS THEN
1171: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1172: ROLLBACK TO process_modifiers_pub;
1173: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1174: THEN
1175: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1176: END IF;
1177: Fnd_Msg_Pub.Count_AND_Get

Line 1175: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1171: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1172: ROLLBACK TO process_modifiers_pub;
1173: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1174: THEN
1175: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1176: END IF;
1177: Fnd_Msg_Pub.Count_AND_Get
1178: ( p_count => x_msg_count,
1179: p_data => x_msg_data,

Line 1177: Fnd_Msg_Pub.Count_AND_Get

1173: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR )
1174: THEN
1175: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1176: END IF;
1177: Fnd_Msg_Pub.Count_AND_Get
1178: ( p_count => x_msg_count,
1179: p_data => x_msg_data,
1180: p_encoded => Fnd_Api.G_FALSE
1181: );

Line 1236: Fnd_Msg_Pub.initialize;

1232:
1233: BEGIN
1234: SAVEPOINT process_vo;
1235: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
1236: Fnd_Msg_Pub.initialize;
1237: END IF;
1238:
1239: IF NOT Fnd_Api.compatible_api_call(l_api_version,
1240: p_api_version,

Line 1851: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

1847: EXCEPTION
1848: WHEN Fnd_Api.G_EXC_ERROR THEN
1849: x_return_status := Fnd_Api.g_ret_sts_error ;
1850: ROLLBACK TO process_vo;
1851: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1852: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1853: END IF;
1854: Fnd_Msg_Pub.Count_AND_Get
1855: ( p_count => x_msg_count,

Line 1852: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1848: WHEN Fnd_Api.G_EXC_ERROR THEN
1849: x_return_status := Fnd_Api.g_ret_sts_error ;
1850: ROLLBACK TO process_vo;
1851: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1852: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1853: END IF;
1854: Fnd_Msg_Pub.Count_AND_Get
1855: ( p_count => x_msg_count,
1856: p_data => x_msg_data,

Line 1854: Fnd_Msg_Pub.Count_AND_Get

1850: ROLLBACK TO process_vo;
1851: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1852: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1853: END IF;
1854: Fnd_Msg_Pub.Count_AND_Get
1855: ( p_count => x_msg_count,
1856: p_data => x_msg_data,
1857: p_encoded => Fnd_Api.G_FALSE
1858: );

Line 1862: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

1858: );
1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1861: ROLLBACK TO process_vo;
1862: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1863: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1864: END IF;
1865: Fnd_Msg_Pub.Count_AND_Get
1866: ( p_count => x_msg_count,

Line 1863: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.g_ret_sts_unexp_error ;
1861: ROLLBACK TO process_vo;
1862: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1863: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1864: END IF;
1865: Fnd_Msg_Pub.Count_AND_Get
1866: ( p_count => x_msg_count,
1867: p_data => x_msg_data,

Line 1865: Fnd_Msg_Pub.Count_AND_Get

1861: ROLLBACK TO process_vo;
1862: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1863: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1864: END IF;
1865: Fnd_Msg_Pub.Count_AND_Get
1866: ( p_count => x_msg_count,
1867: p_data => x_msg_data,
1868: p_encoded => Fnd_Api.G_FALSE
1869: );

Line 1873: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN

1869: );
1870: WHEN OTHERS THEN
1871: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1872: ROLLBACK TO process_vo;
1873: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1874: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1875: END IF;
1876: Fnd_Msg_Pub.Count_AND_Get
1877: ( p_count => x_msg_count,

Line 1874: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1870: WHEN OTHERS THEN
1871: x_return_status := Fnd_Api.g_ret_sts_unexp_erroR ;
1872: ROLLBACK TO process_vo;
1873: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1874: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1875: END IF;
1876: Fnd_Msg_Pub.Count_AND_Get
1877: ( p_count => x_msg_count,
1878: p_data => x_msg_data,

Line 1876: Fnd_Msg_Pub.Count_AND_Get

1872: ROLLBACK TO process_vo;
1873: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR ) THEN
1874: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1875: END IF;
1876: Fnd_Msg_Pub.Count_AND_Get
1877: ( p_count => x_msg_count,
1878: p_data => x_msg_data,
1879: p_encoded => Fnd_Api.G_FALSE
1880: );

Line 1981: Fnd_Msg_Pub.initialize;

1977: SAVEPOINT process_offer_from_adapter;
1978:
1979: -- Standard call to check for call compatibility.
1980: IF Fnd_Api.to_boolean(p_init_msg_list) THEN
1981: Fnd_Msg_Pub.initialize;
1982: END IF;
1983:
1984: MO_GLOBAL.init('OZF');
1985: IF p_modifier_rec.orig_org_id <> FND_API.g_miss_num AND p_modifier_rec.orig_org_id IS NOT NULL THEN

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

2000:
2001: --//Validations
2002: IF p_modifier_rec.qp_list_header_id = FND_API.g_miss_num OR p_modifier_rec.qp_list_header_id IS NULL THEN
2003: IF p_modifier_rec.offer_type = FND_API.g_miss_char OR p_modifier_rec.offer_type IS NULL THEN
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2005: FND_MESSAGE.set_name('OZF', 'OZF_OFFERS_NO_OFFER_TYPE');
2006: --//Please enter a value for Offer Type
2007: FND_MSG_PUB.add;
2008: END IF;

Line 2007: FND_MSG_PUB.add;

2003: IF p_modifier_rec.offer_type = FND_API.g_miss_char OR p_modifier_rec.offer_type IS NULL THEN
2004: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2005: FND_MESSAGE.set_name('OZF', 'OZF_OFFERS_NO_OFFER_TYPE');
2006: --//Please enter a value for Offer Type
2007: FND_MSG_PUB.add;
2008: END IF;
2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:

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

2009: RAISE FND_API.G_EXC_ERROR;
2010: END IF;
2011:
2012: IF p_modifier_rec.offer_type NOT IN ('ACCRUAL','OFF_INVOICE','LUMPSUM') THEN
2013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2014: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_TPM_OFFR_TYPE');
2015: --//Only Lump sum, Off Invoice and Accrual offer types are supported.
2016: FND_MSG_PUB.add;
2017: END IF;

Line 2016: FND_MSG_PUB.add;

2012: IF p_modifier_rec.offer_type NOT IN ('ACCRUAL','OFF_INVOICE','LUMPSUM') THEN
2013: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2014: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_TPM_OFFR_TYPE');
2015: --//Only Lump sum, Off Invoice and Accrual offer types are supported.
2016: FND_MSG_PUB.add;
2017: END IF;
2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020:

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

2018: RAISE FND_API.G_EXC_ERROR;
2019: END IF;
2020:
2021: IF p_modifier_rec.name = FND_API.g_miss_char OR p_modifier_rec.name IS NULL THEN
2022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2023: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Offer Name');
2025: FND_MSG_PUB.add;
2026: END IF;

Line 2025: FND_MSG_PUB.add;

2021: IF p_modifier_rec.name = FND_API.g_miss_char OR p_modifier_rec.name IS NULL THEN
2022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2023: FND_MESSAGE.SET_NAME('QP','QP_ATTRIBUTE_REQUIRED');
2024: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','Offer Name');
2025: FND_MSG_PUB.add;
2026: END IF;
2027: RAISE FND_API.G_EXC_ERROR;
2028: END IF;
2029:

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

2031: --//==============================
2032: IF p_modifier_rec.offer_type = 'LUMPSUM' THEN
2033: IF p_modifier_rec.lumpsum_amount = FND_API.g_miss_num OR p_modifier_rec.lumpsum_amount IS NULL THEN
2034: IF p_modifier_rec.offer_amount = FND_API.g_miss_num OR p_modifier_rec.offer_amount IS NULL THEN
2035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2036: FND_MESSAGE.set_name('OZF', 'OZF_NO_LUMPSUM_AMOUNT');
2037: --//Lumpsum Amount is mandatory.Please provide Lumpsum Amount
2038: FND_MSG_PUB.add;
2039: END IF;

Line 2038: FND_MSG_PUB.add;

2034: IF p_modifier_rec.offer_amount = FND_API.g_miss_num OR p_modifier_rec.offer_amount IS NULL THEN
2035: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2036: FND_MESSAGE.set_name('OZF', 'OZF_NO_LUMPSUM_AMOUNT');
2037: --//Lumpsum Amount is mandatory.Please provide Lumpsum Amount
2038: FND_MSG_PUB.add;
2039: END IF;
2040: RAISE FND_API.G_EXC_ERROR;
2041: ELSE
2042: l_modifier_list_rec.lumpsum_amount := p_modifier_rec.offer_amount;

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

2053: ,p_lookup_type =>'OZF_LUMPSUM_DISTRIBUTION_TYPE'
2054: ,p_lookup_code => p_modifier_rec.distribution_type);
2055:
2056: IF l_lookup_stat = FND_API.g_false THEN
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2058: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_DISTRIBUTION');
2059: --//Invalid distribution of Lumpsum Offer amount
2060: FND_MSG_PUB.add;
2061: END IF;

Line 2060: FND_MSG_PUB.add;

2056: IF l_lookup_stat = FND_API.g_false THEN
2057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2058: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_DISTRIBUTION');
2059: --//Invalid distribution of Lumpsum Offer amount
2060: FND_MSG_PUB.add;
2061: END IF;
2062: RAISE FND_API.G_EXC_ERROR;
2063: END IF;
2064: l_modifier_list_rec.distribution_type := p_modifier_rec.distribution_type;

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

2072: ,p_lookup_type =>'OZF_OFFER_LUMPSUM_PAYMENT'
2073: ,p_lookup_code => p_modifier_rec.lumpsum_payment_type);
2074:
2075: IF l_lookup_stat = FND_API.g_false THEN
2076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2077: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_LUMPSUM_PAYMENT');
2078: --//Lumpsum Offer payment Type provided is invalid, please provide a valid Payment type Type.
2079: FND_MSG_PUB.add;
2080: END IF;

Line 2079: FND_MSG_PUB.add;

2075: IF l_lookup_stat = FND_API.g_false THEN
2076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2077: FND_MESSAGE.set_name('OZF', 'OZF_OFFER_LUMPSUM_PAYMENT');
2078: --//Lumpsum Offer payment Type provided is invalid, please provide a valid Payment type Type.
2079: FND_MSG_PUB.add;
2080: END IF;
2081: RAISE FND_API.G_EXC_ERROR;
2082: END IF;
2083: l_modifier_list_rec.lumpsum_payment_type := p_modifier_rec.lumpsum_payment_type;

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

2085: l_modifier_list_rec.lumpsum_payment_type := 'ACCRUE';
2086: END IF;
2087:
2088: IF p_modifier_rec.start_date_active = FND_API.g_miss_date OR p_modifier_rec.start_date_active IS NULL THEN
2089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2090: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_START_DATE');
2091: --//Start date is required for this offer type.
2092: FND_MSG_PUB.add;
2093: END IF;

Line 2092: FND_MSG_PUB.add;

2088: IF p_modifier_rec.start_date_active = FND_API.g_miss_date OR p_modifier_rec.start_date_active IS NULL THEN
2089: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2090: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_NO_START_DATE');
2091: --//Start date is required for this offer type.
2092: FND_MSG_PUB.add;
2093: END IF;
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096: IF p_modifier_rec.transaction_currency_code = FND_API.g_miss_char OR p_modifier_rec.transaction_currency_code IS NULL THEN

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

2093: END IF;
2094: RAISE FND_API.G_EXC_ERROR;
2095: END IF;
2096: IF p_modifier_rec.transaction_currency_code = FND_API.g_miss_char OR p_modifier_rec.transaction_currency_code IS NULL THEN
2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2098: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_LS_SD_CURR_REQD');
2099: --//Currency is required for this offer.
2100: FND_MSG_PUB.add;
2101: END IF;

Line 2100: FND_MSG_PUB.add;

2096: IF p_modifier_rec.transaction_currency_code = FND_API.g_miss_char OR p_modifier_rec.transaction_currency_code IS NULL THEN
2097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2098: FND_MESSAGE.set_name('OZF', 'OZF_OFFR_LS_SD_CURR_REQD');
2099: --//Currency is required for this offer.
2100: FND_MSG_PUB.add;
2101: END IF;
2102: RAISE FND_API.G_EXC_ERROR;
2103: ELSE
2104: OPEN c_currency(p_modifier_rec.transaction_currency_code);

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

2104: OPEN c_currency(p_modifier_rec.transaction_currency_code);
2105: FETCH c_currency INTO l_currency_code;
2106: CLOSE c_currency;
2107: IF l_currency_code IS NULL THEN
2108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2109: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CURRENCY_CODE');
2110: --//Mandatory field Currency Code is missing. Please enter a valid Currency Code
2111: FND_MSG_PUB.add;
2112: END IF;

Line 2111: FND_MSG_PUB.add;

2107: IF l_currency_code IS NULL THEN
2108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2109: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CURRENCY_CODE');
2110: --//Mandatory field Currency Code is missing. Please enter a valid Currency Code
2111: FND_MSG_PUB.add;
2112: END IF;
2113: RAISE FND_API.G_EXC_ERROR;
2114: END IF;
2115: END IF;

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

2121: FETCH c_fund_id INTO l_fund_id;
2122: CLOSE c_fund_id;
2123:
2124: IF l_fund_id IS NULL THEN
2125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2126: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_FUND_ID');
2127: --//The Fund ID provided is invalid. Please provide a valid Fund ID.
2128: FND_MSG_PUB.add;
2129: END IF;

Line 2128: FND_MSG_PUB.add;

2124: IF l_fund_id IS NULL THEN
2125: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2126: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_FUND_ID');
2127: --//The Fund ID provided is invalid. Please provide a valid Fund ID.
2128: FND_MSG_PUB.add;
2129: END IF;
2130: RAISE FND_API.G_EXC_ERROR;
2131: END IF;
2132: END IF;

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

2150: FETCH c_currency INTO l_currency_code;
2151: CLOSE c_currency;
2152:
2153: IF l_currency_code IS NULL THEN
2154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2155: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CURRENCY_CODE');
2156: --//Mandatory field Currency Code is missing. Please enter a valid Currency Code
2157: FND_MSG_PUB.add;
2158: END IF;

Line 2157: FND_MSG_PUB.add;

2153: IF l_currency_code IS NULL THEN
2154: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2155: FND_MESSAGE.set_name('OZF', 'OZF_INVALID_CURRENCY_CODE');
2156: --//Mandatory field Currency Code is missing. Please enter a valid Currency Code
2157: FND_MSG_PUB.add;
2158: END IF;
2159: RAISE FND_API.G_EXC_ERROR;
2160: END IF;
2161: END IF;

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

2372:
2373: OPEN c_uom(l_act_product_rec.inventory_item_id, fnd_profile.value('QP_ORGANIZATION_ID'));
2374: FETCH c_uom INTO l_uom;
2375: IF (c_uom%NOTFOUND) THEN
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE Fnd_Api.g_exc_error;

Line 2378: FND_MSG_PUB.add;

2374: FETCH c_uom INTO l_uom;
2375: IF (c_uom%NOTFOUND) THEN
2376: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2377: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2378: FND_MSG_PUB.add;
2379: END IF;
2380: RAISE Fnd_Api.g_exc_error;
2381: END IF;
2382: CLOSE c_uom;

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

2495: ,fnd_profile.value('QP_ORGANIZATION_ID')
2496: );
2497: FETCH c_uom INTO l_uom;
2498: IF ( c_uom%NOTFOUND) THEN
2499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2500: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2501: FND_MSG_PUB.add;
2502: END IF;
2503: RAISE Fnd_Api.g_exc_error;

Line 2501: FND_MSG_PUB.add;

2497: FETCH c_uom INTO l_uom;
2498: IF ( c_uom%NOTFOUND) THEN
2499: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2500: FND_MESSAGE.SET_NAME('QP','QP_INVALID_PROD_UOM');
2501: FND_MSG_PUB.add;
2502: END IF;
2503: RAISE Fnd_Api.g_exc_error;
2504: END IF;
2505: CLOSE c_uom;

Line 2605: FND_MSG_PUB.Count_And_Get (

2601: END LOOP;
2602: END IF;
2603:
2604:
2605: FND_MSG_PUB.Count_And_Get (
2606: p_encoded => FND_API.G_FALSE,
2607: p_count => x_msg_count,
2608: p_data => x_msg_data
2609: );

Line 2614: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);

2610:
2611: x_msg_tbl(1).msg_text :='successful';
2612:
2613: FOR i IN 1..x_msg_count LOOP
2614: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);
2615: END LOOP;
2616:
2617: IF p_commit = Fnd_Api.g_true THEN
2618: COMMIT WORK;

Line 2626: FND_MSG_PUB.Count_And_Get (

2622: WHEN FND_API.G_EXC_ERROR THEN
2623: ROLLBACK TO process_offer_from_adapter;
2624: x_return_status := FND_API.G_RET_STS_ERROR;
2625: -- Standard call to get message count and if count=1, get the message
2626: FND_MSG_PUB.Count_And_Get (
2627: p_encoded => FND_API.G_FALSE,
2628: p_count => x_msg_count,
2629: p_data => x_msg_data
2630: );

Line 2633: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);

2629: p_data => x_msg_data
2630: );
2631:
2632: for i in 1..x_msg_count loop
2633: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);
2634: end loop;
2635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2636: ROLLBACK TO process_offer_from_adapter;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 2639: FND_MSG_PUB.Count_And_Get (

2635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2636: ROLLBACK TO process_offer_from_adapter;
2637: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2638: -- Standard call to get message count and if count=1, get the message
2639: FND_MSG_PUB.Count_And_Get (
2640: p_encoded => FND_API.G_FALSE,
2641: p_count => x_msg_count,
2642: p_data => x_msg_data
2643: );

Line 2645: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);

2641: p_count => x_msg_count,
2642: p_data => x_msg_data
2643: );
2644: for i in 1..x_msg_count loop
2645: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);
2646: end loop;
2647: WHEN OTHERS THEN
2648: ROLLBACK TO process_offer_from_adapter;
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2646: end loop;
2647: WHEN OTHERS THEN
2648: ROLLBACK TO process_offer_from_adapter;
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2650: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2651: THEN
2652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2653: END IF;
2654: -- Standard call to get message count and if count=1, get the message

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

2648: ROLLBACK TO process_offer_from_adapter;
2649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2650: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2651: THEN
2652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2653: END IF;
2654: -- Standard call to get message count and if count=1, get the message
2655: FND_MSG_PUB.Count_And_Get (
2656: p_encoded => FND_API.G_FALSE,

Line 2655: FND_MSG_PUB.Count_And_Get (

2651: THEN
2652: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2653: END IF;
2654: -- Standard call to get message count and if count=1, get the message
2655: FND_MSG_PUB.Count_And_Get (
2656: p_encoded => FND_API.G_FALSE,
2657: p_count => x_msg_count,
2658: p_data => x_msg_data
2659: );

Line 2661: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);

2657: p_count => x_msg_count,
2658: p_data => x_msg_data
2659: );
2660: for i in 1..x_msg_count loop
2661: x_msg_tbl(i).msg_text := substr(fnd_msg_pub.get(p_msg_index => i, p_encoded => 'F'), 1, 254);
2662: end loop;
2663:
2664: END process_offer_from_adapter;
2665: