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(
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
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
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;
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:
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;
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:
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;
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:
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;
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: