DBA Data[Home] [Help]

APPS.PV_PARTNER_PGM_TYPE_PKG dependencies on FND_MSG_PUB

Line 38: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

34: --
35: -- HISTORY
36: --
37: -- ========================================================
38: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
39: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
40: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
41:
42: PROCEDURE Insert_Row(

Line 39: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

35: -- HISTORY
36: --
37: -- ========================================================
38: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
39: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
40: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
41:
42: PROCEDURE Insert_Row(
43: px_PROGRAM_TYPE_ID IN OUT NOCOPY NUMBER

Line 40: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

36: --
37: -- ========================================================
38: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
39: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
40: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
41:
42: PROCEDURE Insert_Row(
43: px_PROGRAM_TYPE_ID IN OUT NOCOPY NUMBER
44: ,p_active_flag VARCHAR2

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

169: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID
170: AND object_version_number = p_object_version_number;
171:
172: IF (SQL%NOTFOUND) THEN
173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
174: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
175: FND_MSG_PUB.add;
176: END IF;
177: RAISE FND_API.g_exc_error;

Line 175: FND_MSG_PUB.add;

171:
172: IF (SQL%NOTFOUND) THEN
173: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
174: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
175: FND_MSG_PUB.add;
176: END IF;
177: RAISE FND_API.g_exc_error;
178: END IF;
179:

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

188: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID
189: AND USERENV('LANG') IN (language, source_lang);
190:
191: IF (SQL%NOTFOUND) THEN
192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
193: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
194: FND_MSG_PUB.add;
195: END IF;
196: RAISE FND_API.g_exc_error;

Line 194: FND_MSG_PUB.add;

190:
191: IF (SQL%NOTFOUND) THEN
192: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
193: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
194: FND_MSG_PUB.add;
195: END IF;
196: RAISE FND_API.g_exc_error;
197: END IF;
198:

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

222: DELETE FROM PV_PARTNER_PROGRAM_TYPE_TL
223: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID;
224:
225: IF (SQL%NOTFOUND) THEN
226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
227: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
228: FND_MSG_PUB.add;
229: END IF;
230: RAISE FND_API.g_exc_error;

Line 228: FND_MSG_PUB.add;

224:
225: IF (SQL%NOTFOUND) THEN
226: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
227: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
228: FND_MSG_PUB.add;
229: END IF;
230: RAISE FND_API.g_exc_error;
231: END IF;
232:

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

234: WHERE PROGRAM_TYPE_ID = p_PROGRAM_TYPE_ID
235: AND object_version_number = p_object_version_number;
236:
237: IF (SQL%NOTFOUND) THEN
238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
239: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
240: FND_MSG_PUB.add;
241: END IF;
242: RAISE FND_API.g_exc_error;

Line 240: FND_MSG_PUB.add;

236:
237: IF (SQL%NOTFOUND) THEN
238: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
239: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
240: FND_MSG_PUB.add;
241: END IF;
242: RAISE FND_API.g_exc_error;
243: END IF;
244: