DBA Data[Home] [Help]

APPS.OKL_AM_LOAD_CAT_BK_PUB dependencies on FND_API

Line 47: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

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;

Line 48: RAISE FND_API.G_EXC_ERROR;

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:

Line 49: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

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:

Line 50: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 66: WHEN FND_API.G_EXC_ERROR THEN

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 ;

Line 68: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 74: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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 ;

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 84: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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(