130: -- Initialize message list if p_int_msg_list is set TRUE.
131: -- ======================================================
132: IF FND_API.to_boolean(p_init_msg_list)
133: THEN
134: FND_MSG_PUB.Initialize;
135: END IF;
136:
137: -- Initialize API return Parameters
138: -- ================================
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
363: ROLLBACK TO Create_Spec;
364: x_return_status := FND_API.G_RET_STS_ERROR;
365: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
366: , p_count => x_msg_count
367: , p_data => x_msg_data
368: );
369:
369:
370: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
371: ROLLBACK TO Create_Spec;
372: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
373: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
374: , p_count => x_msg_count
375: , p_data => x_msg_data
376: );
377:
377:
378: WHEN OTHERS THEN
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: ROLLBACK TO Create_Spec;
381: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
382: , l_api_name
383: );
384:
385: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
381: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
382: , l_api_name
383: );
384:
385: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
386: , p_count => x_msg_count
387: , p_data => x_msg_data
388: );
389:
449: -- Initialize message list if p_int_msg_list is set TRUE.
450: -- ======================================================
451: IF FND_API.to_boolean(p_init_msg_list)
452: THEN
453: FND_MSG_PUB.Initialize;
454: END IF;
455:
456: -- Initialize API return Parameters
457: -- ================================
527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO Delete_Spec;
529: x_deleted_rows := 0;
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
532: , p_count => x_msg_count
533: , p_data => x_msg_data
534: );
535:
536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
537: ROLLBACK TO Delete_Spec;
538: x_deleted_rows := 0;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
541: , p_count => x_msg_count
542: , p_data => x_msg_data
543: );
544:
547: WHEN OTHERS THEN
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: x_deleted_rows := 0;
550: ROLLBACK TO Delete_Spec;
551: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
552: , l_api_name
553: );
554:
555: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
551: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
552: , l_api_name
553: );
554:
555: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
556: , p_count => x_msg_count
557: , p_data => x_msg_data
558: );
559:
617: -- Initialize message list if p_int_msg_list is set TRUE.
618: -- ======================================================
619: IF FND_API.to_boolean(p_init_msg_list)
620: THEN
621: FND_MSG_PUB.Initialize;
622: END IF;
623:
624: -- Initialize API return Parameters
625: -- ================================
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO Delete_Spec_Tests;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: x_deleted_rows := 0;
747: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
748: , p_count => x_msg_count
749: , p_data => x_msg_data
750: );
751:
752: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
753: ROLLBACK TO Delete_Spec_Tests;
754: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
755: x_deleted_rows := 0;
756: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
757: , p_count => x_msg_count
758: , p_data => x_msg_data
759: );
760:
763: WHEN OTHERS THEN
764: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
765: x_deleted_rows := 0;
766: ROLLBACK TO Delete_Spec_Tests;
767: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
768: , l_api_name
769: );
770:
771: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
767: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
768: , l_api_name
769: );
770:
771: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
772: , p_count => x_msg_count
773: , p_data => x_msg_data
774: );
775: