33: --
34: -- HISTORY
35: --
36: -- ========================================================
37: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE Insert_Row(
34: -- HISTORY
35: --
36: -- ========================================================
37: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE Insert_Row(
42: px_program_benefits_id IN OUT NOCOPY NUMBER
35: --
36: -- ========================================================
37: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
38: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
39: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
40:
41: PROCEDURE Insert_Row(
42: px_program_benefits_id IN OUT NOCOPY NUMBER
43: ,p_program_id NUMBER
148: WHERE PROGRAM_BENEFITS_ID = p_program_benefits_id
149: AND object_version_number = p_object_version_number;
150:
151: IF (SQL%NOTFOUND) THEN
152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
153: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
154: FND_MSG_PUB.add;
155: END IF;
156: RAISE FND_API.g_exc_error;
150:
151: IF (SQL%NOTFOUND) THEN
152: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
153: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
154: FND_MSG_PUB.add;
155: END IF;
156: RAISE FND_API.g_exc_error;
157: END IF;
158:
189: WHERE program_benefits_id = p_program_benefits_id
190: AND object_version_number = p_object_version_number;
191:
192: IF (SQL%NOTFOUND) THEN
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
191:
192: IF (SQL%NOTFOUND) THEN
193: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
194: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
195: FND_MSG_PUB.add;
196: END IF;
197: RAISE FND_API.g_exc_error;
198: END IF;
199: