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;
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
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:
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
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 ;
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
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 ;
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
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(
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;
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
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:
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:
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 ;
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
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 ;
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
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(