DBA Data[Home] [Help]

APPS.OKL_CREATE_ADJST_PUB dependencies on FND_API

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

60: END IF;
61: Bug 6727171 End */
62:
63: --Bug 6727171 Start
64: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
65: RAISE FND_API.G_EXC_ERROR;
66: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;

Line 65: RAISE FND_API.G_EXC_ERROR;

61: Bug 6727171 End */
62:
63: --Bug 6727171 Start
64: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
65: RAISE FND_API.G_EXC_ERROR;
66: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69: --Bug 6727171 End

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

62:
63: --Bug 6727171 Start
64: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
65: RAISE FND_API.G_EXC_ERROR;
66: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69: --Bug 6727171 End
70:

Line 67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

63: --Bug 6727171 Start
64: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
65: RAISE FND_API.G_EXC_ERROR;
66: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
67: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
68: END IF;
69: --Bug 6727171 End
70:
71: --Assign value to OUT variables

Line 79: WHEN Fnd_Api.G_EXC_ERROR THEN

75: x_msg_data := l_msg_data ;
76:
77: EXCEPTION
78:
79: WHEN Fnd_Api.G_EXC_ERROR THEN
80: ROLLBACK TO save_Insert_row;
81: x_return_status := Fnd_Api.G_RET_STS_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;

Line 81: x_return_status := Fnd_Api.G_RET_STS_ERROR;

77: EXCEPTION
78:
79: WHEN Fnd_Api.G_EXC_ERROR THEN
80: ROLLBACK TO save_Insert_row;
81: x_return_status := Fnd_Api.G_RET_STS_ERROR;
82: x_msg_count := l_msg_count ;
83: x_msg_data := l_msg_data ;
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count

Line 87: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

83: x_msg_data := l_msg_data ;
84: Fnd_Msg_Pub.count_and_get(
85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
88: ROLLBACK TO save_Insert_row;
89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;

Line 89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

85: p_count => x_msg_count
86: ,p_data => x_msg_data);
87: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
88: ROLLBACK TO save_Insert_row;
89: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
90: x_msg_count := l_msg_count ;
91: x_msg_data := l_msg_data ;
92: Fnd_Msg_Pub.count_and_get(
93: p_count => x_msg_count

Line 97: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: WHEN OTHERS THEN
96: ROLLBACK TO save_Insert_row;
97: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
98: x_msg_count := l_msg_count ;
99: x_msg_data := l_msg_data ;
100: Fnd_Msg_Pub.ADD_EXC_MSG('CREATE_ADJUSTMENTS_PUB','insert_row');
101: Fnd_Msg_Pub.count_and_get(

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

182: END IF;
183: Bug 6727171 End */
184:
185: --Bug 6727171 Start
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;

Line 187: RAISE FND_API.G_EXC_ERROR;

183: Bug 6727171 End */
184:
185: --Bug 6727171 Start
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Bug 6727171 End

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

184:
185: --Bug 6727171 Start
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Bug 6727171 End
192:

Line 189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

185: --Bug 6727171 Start
186: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
187: RAISE FND_API.G_EXC_ERROR;
188: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
190: END IF;
191: --Bug 6727171 End
192:
193:

Line 203: WHEN Fnd_Api.G_EXC_ERROR THEN

199: x_msg_data := l_msg_data ;
200:
201: EXCEPTION
202:
203: WHEN Fnd_Api.G_EXC_ERROR THEN
204: ROLLBACK TO save_Insert_row;
205: x_return_status := Fnd_Api.G_RET_STS_ERROR;
206: x_msg_count := l_msg_count ;
207: x_msg_data := l_msg_data ;

Line 205: x_return_status := Fnd_Api.G_RET_STS_ERROR;

201: EXCEPTION
202:
203: WHEN Fnd_Api.G_EXC_ERROR THEN
204: ROLLBACK TO save_Insert_row;
205: x_return_status := Fnd_Api.G_RET_STS_ERROR;
206: x_msg_count := l_msg_count ;
207: x_msg_data := l_msg_data ;
208: Fnd_Msg_Pub.count_and_get(
209: p_count => x_msg_count

Line 211: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

207: x_msg_data := l_msg_data ;
208: Fnd_Msg_Pub.count_and_get(
209: p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO save_Insert_row;
213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
214: x_msg_count := l_msg_count ;
215: x_msg_data := l_msg_data ;

Line 213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

209: p_count => x_msg_count
210: ,p_data => x_msg_data);
211: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
212: ROLLBACK TO save_Insert_row;
213: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
214: x_msg_count := l_msg_count ;
215: x_msg_data := l_msg_data ;
216: Fnd_Msg_Pub.count_and_get(
217: p_count => x_msg_count

Line 221: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: ROLLBACK TO save_Insert_row;
221: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
222: x_msg_count := l_msg_count ;
223: x_msg_data := l_msg_data ;
224: Fnd_Msg_Pub.ADD_EXC_MSG('IEX_CREATE_ADJUSTMENTS_PUB','insert_row');
225: Fnd_Msg_Pub.count_and_get(