184: CLOSE l_Service_Csr;
185: END IF;
186: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME('CS', 'CS_CONTRACT_NOT_FOUND');
190: FND_MSG_PUB.Add;
191: END IF;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
186: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
187: x_return_status := FND_API.G_RET_STS_ERROR;
188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME('CS', 'CS_CONTRACT_NOT_FOUND');
190: FND_MSG_PUB.Add;
191: END IF;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
193: p_data => x_msg_data,
194: p_encoded => FND_API.G_FALSE );
188: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
189: FND_MESSAGE.SET_NAME('CS', 'CS_CONTRACT_NOT_FOUND');
190: FND_MSG_PUB.Add;
191: END IF;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
193: p_data => x_msg_data,
194: p_encoded => FND_API.G_FALSE );
195: WHEN FND_API.G_EXC_ERROR THEN
196: IF (l_Contract_csr%ISOPEN) THEN
199: CLOSE l_Service_Csr;
200: END IF;
201: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
202: x_return_status := FND_API.G_RET_STS_ERROR;
203: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
204: p_data => x_msg_data,
205: p_encoded => FND_API.G_FALSE );
206:
207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
212: CLOSE l_Service_Csr;
213: END IF;
214: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
217: p_data => x_msg_data,
218: p_encoded => FND_API.G_FALSE );
219: END Contract_to_template;
220:
405: CLOSE l_Contract_Tmpl_csr;
406: END IF;
407: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
410: FND_MESSAGE.SET_NAME('CS', 'CS_TEMPLATE_NOT_FOUND');
411: FND_MSG_PUB.Add;
412: END IF;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
407: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
408: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
410: FND_MESSAGE.SET_NAME('CS', 'CS_TEMPLATE_NOT_FOUND');
411: FND_MSG_PUB.Add;
412: END IF;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
414: p_data => x_msg_data,
415: p_encoded => FND_API.G_FALSE );
409: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
410: FND_MESSAGE.SET_NAME('CS', 'CS_TEMPLATE_NOT_FOUND');
411: FND_MSG_PUB.Add;
412: END IF;
413: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
414: p_data => x_msg_data,
415: p_encoded => FND_API.G_FALSE );
416: WHEN FND_API.G_EXC_ERROR THEN
417: IF (l_Contract_Tmpl_csr%ISOPEN) THEN
418: CLOSE l_Contract_Tmpl_csr;
419: END IF;
420: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
421: x_return_status := FND_API.G_RET_STS_ERROR;
422: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
423: p_data => x_msg_data,
424: p_encoded => FND_API.G_FALSE );
425:
426: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
429: CLOSE l_Contract_Tmpl_csr;
430: END IF;
431: --DBMS_TRANSACTION.ROLLBACK_SAVEPOINT(l_api_name || l_api_type);
432: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
433: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
434: p_data => x_msg_data,
435: p_encoded => FND_API.G_FALSE );
436: END Template_to_Contract;
437: