43: );
44:
45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
44:
45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
45:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53:
46:
47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
48: RAISE FND_API.G_EXC_ERROR;
49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
51: END IF;
52:
53:
54:
62: x_amhv_tbl := lx_amhv_tbl;
63:
64: EXCEPTION
65:
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO trx_create_hold_setup_trx;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_msg_count := l_msg_count ;
70: x_msg_data := l_msg_data ;
64: EXCEPTION
65:
66: WHEN FND_API.G_EXC_ERROR THEN
67: ROLLBACK TO trx_create_hold_setup_trx;
68: x_return_status := FND_API.G_RET_STS_ERROR;
69: x_msg_count := l_msg_count ;
70: x_msg_data := l_msg_data ;
71: FND_MSG_PUB.count_and_get(
72: p_count => x_msg_count
70: x_msg_data := l_msg_data ;
71: FND_MSG_PUB.count_and_get(
72: p_count => x_msg_count
73: ,p_data => x_msg_data);
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO trx_create_hold_setup_trx;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: x_msg_count := l_msg_count ;
78: x_msg_data := l_msg_data ;
72: p_count => x_msg_count
73: ,p_data => x_msg_data);
74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
75: ROLLBACK TO trx_create_hold_setup_trx;
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: x_msg_count := l_msg_count ;
78: x_msg_data := l_msg_data ;
79: FND_MSG_PUB.count_and_get(
80: p_count => x_msg_count
80: p_count => x_msg_count
81: ,p_data => x_msg_data);
82: WHEN OTHERS THEN
83: ROLLBACK TO trx_create_hold_setup_trx;
84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
85: x_msg_count := l_msg_count ;
86: x_msg_data := l_msg_data ;
87: FND_MSG_PUB.ADD_EXC_MSG('OKL_AM_LOAD_CAT_BK_PUB','create_hold_setup_trx');
88: FND_MSG_PUB.count_and_get(