37: --
38: -- HISTORY
39: --
40: -- ========================================================
41: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Insert_Row(
38: -- HISTORY
39: --
40: -- ========================================================
41: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Insert_Row(
46: px_program_contracts_id IN OUT NOCOPY NUMBER
39: --
40: -- ========================================================
41: PV_DEBUG_HIGH_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
42: PV_DEBUG_LOW_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
43: PV_DEBUG_MEDIUM_ON CONSTANT boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
44:
45: PROCEDURE Insert_Row(
46: px_program_contracts_id IN OUT NOCOPY NUMBER
47: ,p_program_id NUMBER
130: WHERE program_contracts_id = p_program_contracts_id
131: AND object_version_number = p_object_version_number;
132:
133: IF (SQL%NOTFOUND) THEN
134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
135: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
136: FND_MSG_PUB.add;
137: END IF;
138: RAISE FND_API.g_exc_error;
132:
133: IF (SQL%NOTFOUND) THEN
134: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
135: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
136: FND_MSG_PUB.add;
137: END IF;
138: RAISE FND_API.g_exc_error;
139: END IF;
140:
166: WHERE program_contracts_id = p_program_contracts_id
167: AND object_version_number = p_object_version_number;
168:
169: IF (SQL%NOTFOUND) THEN
170: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
171: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
172: FND_MSG_PUB.add;
173: END IF;
174: RAISE FND_API.g_exc_error;
168:
169: IF (SQL%NOTFOUND) THEN
170: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
171: FND_MESSAGE.set_name('PV', 'PV_RECORD_NOT_FOUND');
172: FND_MSG_PUB.add;
173: END IF;
174: RAISE FND_API.g_exc_error;
175: END IF;
176: