77: END;
78: IF l_temp = 1 THEN
79: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
80: THEN
81: FND_MESSAGE.SET_NAME ('CN','CN_ALREADY_EXISTS');
82: FND_MSG_PUB.Add;
83: END IF;
84: RAISE FND_API.G_EXC_ERROR ;
85: END IF;
217: END;
218: IF l_temp = 1 THEN
219: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
220: THEN
221: FND_MESSAGE.SET_NAME ('CN','CN_ALREADY_EXISTS');
222: FND_MSG_PUB.Add;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR ;
225: END IF;
234: EXCEPTION
235: WHEN no_data_found THEN
236: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
237: THEN
238: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
239: FND_MSG_PUB.Add;
240: END IF;
241: RAISE FND_API.G_EXC_ERROR ;
242: END ;
245: IF p_imp_header.object_version_number >
246: p_imp_header.object_version_number THEN
247: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
248: THEN
249: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
250: FND_MSG_PUB.Add;
251: END IF;
252: RAISE FND_API.G_EXC_ERROR ;
253: END IF;
383: EXCEPTION
384: WHEN no_data_found THEN
385: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
386: THEN
387: FND_MESSAGE.SET_NAME ('CN','CN_REC_NOT_EXISTS');
388: FND_MSG_PUB.Add;
389: END IF;
390: RAISE FND_API.G_EXC_ERROR ;
391: END;
394: IF l_imp_header.object_version_number >
395: p_imp_header.object_version_number THEN
396: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
397: THEN
398: FND_MESSAGE.SET_NAME ('CN' , 'CN_RECORD_CHANGED');
399: FND_MSG_PUB.Add;
400: END IF;
401: RAISE FND_API.G_EXC_ERROR ;
402: END IF;