DBA Data[Home] [Help]

APPS.OKL_CREATE_ADJST_PUB dependencies on FND_API

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

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

Line 67: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 69: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 81: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 83: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 89: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 91: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 99: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 189: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 191: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 205: WHEN Fnd_Api.G_EXC_ERROR THEN

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

Line 207: x_return_status := Fnd_Api.G_RET_STS_ERROR;

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

Line 213: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

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

Line 215: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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

Line 223: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

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