32: --
33: -- HISTORY
34: --
35: -- ========================================================
36: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
37: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
38: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: PROCEDURE Insert_Row(
33: -- HISTORY
34: --
35: -- ========================================================
36: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
37: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
38: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: PROCEDURE Insert_Row(
41: px_program_payment_mode_id IN OUT NOCOPY NUMBER
34: --
35: -- ========================================================
36: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
37: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
38: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
39:
40: PROCEDURE Insert_Row(
41: px_program_payment_mode_id IN OUT NOCOPY NUMBER
42: ,p_program_id NUMBER
149: WHERE PROGRAM_PAYMENT_MODE_ID = p_program_payment_mode_id
150: AND object_version_number = p_object_version_number;
151:
152: IF (SQL%NOTFOUND) THEN
153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
154: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
155: FND_MSG_PUB.add;
156: END IF;
157: RAISE FND_API.g_exc_error;
151:
152: IF (SQL%NOTFOUND) THEN
153: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
154: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
155: FND_MSG_PUB.add;
156: END IF;
157: RAISE FND_API.g_exc_error;
158: END IF;
159:
185: WHERE program_payment_mode_id = p_program_payment_mode_id
186: AND object_version_number = p_object_version_number;
187:
188: IF (SQL%NOTFOUND) THEN
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
190: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
191: FND_MSG_PUB.add;
192: END IF;
193: RAISE FND_API.g_exc_error;
187:
188: IF (SQL%NOTFOUND) THEN
189: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
190: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
191: FND_MSG_PUB.add;
192: END IF;
193: RAISE FND_API.g_exc_error;
194: END IF;
195: