23: p_adv_rcpt_rec IN adv_rcpt_rec,
24: x_adv_rcpt_rec OUT NOCOPY adv_rcpt_rec ) IS
25:
26:
27: l_return_status VARCHAR2(1) DEFAULT FND_API.G_RET_STS_SUCCESS;
28: lp_adv_rcpt_rec adv_rcpt_rec DEFAULT p_adv_rcpt_rec;
29:
30: BEGIN
31: SAVEPOINT save_handle_adv_man_pay;
40: p_adv_rcpt_rec => lp_adv_rcpt_rec,
41: x_adv_rcpt_rec => x_adv_rcpt_rec
42: );
43:
44: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
41: x_adv_rcpt_rec => x_adv_rcpt_rec
42: );
43:
44: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
42: );
43:
44: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: EXCEPTION
43:
44: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
45: RAISE FND_API.G_EXC_ERROR;
46: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: EXCEPTION
51: WHEN FND_API.G_EXC_ERROR THEN
47: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
48: END IF;
49:
50: EXCEPTION
51: WHEN FND_API.G_EXC_ERROR THEN
52: ROLLBACK TO save_handle_adv_man_pay;
53: x_return_status := FND_API.G_RET_STS_ERROR;
54:
55: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
49:
50: EXCEPTION
51: WHEN FND_API.G_EXC_ERROR THEN
52: ROLLBACK TO save_handle_adv_man_pay;
53: x_return_status := FND_API.G_RET_STS_ERROR;
54:
55: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
56: ,p_count => x_msg_count
57: ,p_data => x_msg_data);
55: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
56: ,p_count => x_msg_count
57: ,p_data => x_msg_data);
58:
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: ROLLBACK TO save_handle_adv_man_pay;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
63: ,p_count => x_msg_count
57: ,p_data => x_msg_data);
58:
59: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
60: ROLLBACK TO save_handle_adv_man_pay;
61: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
62: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
63: ,p_count => x_msg_count
64: ,p_data => x_msg_data);
65:
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73: -- notify caller of an UNEXPECTED error
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75:
76: END handle_advanced_manual_pay;
77: END okl_bpd_cap_adv_mon_pub;