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