166:
167: WHEN FND_API.G_EXC_ERROR THEN
168: ROLLBACK TO Get_contract_lines;
169: x_return_status := FND_API.G_RET_STS_ERROR ;
170: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
171: p_data => x_msg_data ,
172: p_encoded => fnd_api.g_false );
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
173:
174: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
175: ROLLBACK TO Get_contract_lines;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
177: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
178: p_data => x_msg_data ,
179: p_encoded => fnd_api.g_false );
180:
181: WHEN OTHERS THEN
180:
181: WHEN OTHERS THEN
182: ROLLBACK TO Get_contract_lines;
183: x_return_status := FND_API.G_RET_STS_unexp_error ;
184: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
186: END IF;
187: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
188: p_data => x_msg_data ,
181: WHEN OTHERS THEN
182: ROLLBACK TO Get_contract_lines;
183: x_return_status := FND_API.G_RET_STS_unexp_error ;
184: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
186: END IF;
187: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => fnd_api.g_false );
183: x_return_status := FND_API.G_RET_STS_unexp_error ;
184: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
185: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
186: END IF;
187: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
188: p_data => x_msg_data ,
189: p_encoded => fnd_api.g_false );
190:
191:
292:
293: WHEN FND_API.G_EXC_ERROR THEN
294: ROLLBACK TO check_reaction_times;
295: x_return_status := FND_API.G_RET_STS_ERROR ;
296: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
297: p_data => x_msg_data ,
298: p_encoded => fnd_api.g_false );
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
299:
300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: ROLLBACK TO check_reaction_times;
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
303: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
304: p_data => x_msg_data ,
305: p_encoded => fnd_api.g_false );
306:
307: WHEN OTHERS THEN
306:
307: WHEN OTHERS THEN
308: ROLLBACK TO check_reaction_times;
309: x_return_status := FND_API.G_RET_STS_unexp_error ;
310: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
311: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
312: END IF;
313: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
314: p_data => x_msg_data ,
307: WHEN OTHERS THEN
308: ROLLBACK TO check_reaction_times;
309: x_return_status := FND_API.G_RET_STS_unexp_error ;
310: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
311: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
312: END IF;
313: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => fnd_api.g_false );
309: x_return_status := FND_API.G_RET_STS_unexp_error ;
310: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
311: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
312: END IF;
313: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
314: p_data => x_msg_data ,
315: p_encoded => fnd_api.g_false );
316:
317:
412:
413: WHEN FND_API.G_EXC_ERROR THEN
414: ROLLBACK TO validate_contact;
415: x_return_status := FND_API.G_RET_STS_ERROR ;
416: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
417: p_data => x_msg_data ,
418: p_encoded => fnd_api.g_false );
419:
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
419:
420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
421: ROLLBACK TO validate_contact;
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
424: p_data => x_msg_data ,
425: p_encoded => fnd_api.g_false );
426:
427: WHEN OTHERS THEN
426:
427: WHEN OTHERS THEN
428: ROLLBACK TO validate_contact;
429: x_return_status := FND_API.G_RET_STS_unexp_error ;
430: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
432: END IF;
433: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
434: p_data => x_msg_data ,
427: WHEN OTHERS THEN
428: ROLLBACK TO validate_contact;
429: x_return_status := FND_API.G_RET_STS_unexp_error ;
430: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
432: END IF;
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 );
429: x_return_status := FND_API.G_RET_STS_unexp_error ;
430: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
431: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
432: END IF;
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:
437: END;
539:
540: WHEN FND_API.G_EXC_ERROR THEN
541: ROLLBACK TO validate_contact;
542: x_return_status := FND_API.G_RET_STS_ERROR ;
543: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
544: p_data => x_msg_data ,
545: p_encoded => fnd_api.g_false );
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546:
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO validate_contact;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
550: FND_MSG_PUB.COUNT_AND_GET ( p_count =>x_msg_count ,
551: p_data => x_msg_data ,
552: p_encoded => fnd_api.g_false );
553:
554: WHEN OTHERS THEN
553:
554: WHEN OTHERS THEN
555: ROLLBACK TO validate_contact;
556: x_return_status := FND_API.G_RET_STS_unexp_error ;
557: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
558: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
559: END IF;
560: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
561: p_data => x_msg_data ,
554: WHEN OTHERS THEN
555: ROLLBACK TO validate_contact;
556: x_return_status := FND_API.G_RET_STS_unexp_error ;
557: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
558: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
559: END IF;
560: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
561: p_data => x_msg_data ,
562: p_encoded => fnd_api.g_false );
556: x_return_status := FND_API.G_RET_STS_unexp_error ;
557: IF fnd_msg_pub.check_msg_level ( fnd_msg_pub.g_msg_lvl_unexp_error ) THEN
558: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name ) ;
559: END IF;
560: fnd_msg_pub.count_and_get ( p_count =>x_msg_count ,
561: p_data => x_msg_data ,
562: p_encoded => fnd_api.g_false );
563:
564: END;