107:
108: /* Initialize message list if p_int_msg_list is set TRUE. */
109: IF FND_API.to_boolean(p_init_msg_list)
110: THEN
111: FND_MSG_PUB.Initialize;
112: END IF;
113:
114: -- Initialize API return Parameters
115:
422: EXCEPTION
423: WHEN FND_API.G_EXC_ERROR THEN
424: ROLLBACK TO Create_Tests;
425: x_return_status := FND_API.G_RET_STS_ERROR;
426: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
427: , p_count => x_msg_count
428: , p_data => x_msg_data
429: );
430:
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO Create_Tests;
433: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
434: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
435: , p_count => x_msg_count
436: , p_data => x_msg_data
437: );
438:
440:
441: WHEN OTHERS THEN
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: ROLLBACK TO Create_Tests;
444: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
445: , l_api_name
446: );
447:
448: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
444: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
445: , l_api_name
446: );
447:
448: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
449: , p_count => x_msg_count
450: , p_data => x_msg_data
451: );
452:
492:
493: -- Initialize message list if p_int_msg_list is set TRUE.
494: IF FND_API.to_boolean(p_init_msg_list)
495: THEN
496: FND_MSG_PUB.Initialize;
497: END IF;
498:
499: -- Initialize API return Parameters
500:
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: ROLLBACK TO DELETE_TEST_HEADERS;
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
600: , p_count => x_msg_count
601: , p_data => x_msg_data
602: );
603:
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO DELETE_TEST_HEADERS;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
607: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
608: , p_count => x_msg_count
609: , p_data => x_msg_data
610: );
611:
613:
614: WHEN OTHERS THEN
615: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
616: ROLLBACK TO DELETE_TEST_HEADERS;
617: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
618: , l_api_name
619: );
620:
621: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
617: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
618: , l_api_name
619: );
620:
621: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
622: , p_count => x_msg_count
623: , p_data => x_msg_data
624: );
625:
668: -- Initialize message list if p_int_msg_list is set TRUE.
669:
670: IF FND_API.to_boolean(p_init_msg_list)
671: THEN
672: FND_MSG_PUB.Initialize;
673: END IF;
674:
675: -- Initialize API return Parameters
676:
811: EXCEPTION
812: WHEN FND_API.G_EXC_ERROR THEN
813: ROLLBACK TO DELETE_TEST_VALUES;
814: x_return_status := FND_API.G_RET_STS_ERROR;
815: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
816: , p_count => x_msg_count
817: , p_data => x_msg_data
818: );
819:
819:
820: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
821: ROLLBACK TO DELETE_TEST_VALUES;
822: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
823: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
824: , p_count => x_msg_count
825: , p_data => x_msg_data
826: );
827:
829:
830: WHEN OTHERS THEN
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: ROLLBACK TO DELETE_TEST_VALUES;
833: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
834: , l_api_name
835: );
836:
837: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
833: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
834: , l_api_name
835: );
836:
837: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
838: , p_count => x_msg_count
839: , p_data => x_msg_data
840: );
841:
882: -- Initialize message list if p_int_msg_list is set TRUE.
883:
884: IF FND_API.to_boolean(p_init_msg_list)
885: THEN
886: FND_MSG_PUB.Initialize;
887: END IF;
888:
889: -- Initialize API return Parameters
890:
1004: EXCEPTION
1005: WHEN FND_API.G_EXC_ERROR THEN
1006: ROLLBACK TO DELETE_CUSTOMER_TESTS;
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );
1012:
1012:
1013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1014: ROLLBACK TO DELETE_CUSTOMER_TESTS;
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1016: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1017: , p_count => x_msg_count
1018: , p_data => x_msg_data
1019: );
1020:
1022:
1023: WHEN OTHERS THEN
1024: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1025: ROLLBACK TO DELETE_CUSTOMER_TESTS;
1026: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1027: , l_api_name
1028: );
1029:
1030: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1026: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1027: , l_api_name
1028: );
1029:
1030: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
1031: , p_count => x_msg_count
1032: , p_data => x_msg_data
1033: );
1034: