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
88: ,p_data => x_msg_data);
89: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
90: ROLLBACK TO save_Insert_row;
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
96: ,p_data => x_msg_data);
97: WHEN OTHERS THEN
98: ROLLBACK TO save_Insert_row;
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(
104: p_count => x_msg_count
105: ,p_data => x_msg_data);
106:
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(
104: p_count => x_msg_count
105: ,p_data => x_msg_data);
106:
107: END create_adjustments_pub;
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
212: ,p_data => x_msg_data);
213: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
214: ROLLBACK TO save_Insert_row;
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
220: ,p_data => x_msg_data);
221: WHEN OTHERS THEN
222: ROLLBACK TO save_Insert_row;
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(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230:
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(
228: p_count => x_msg_count
229: ,p_data => x_msg_data);
230:
231: END iex_create_adjustments_pub;
293: END LOOP;
294: END IF;
295: /*
296: FOR i in 1..lx_msg_count LOOP
297: fnd_msg_pub.get (p_msg_index => i,
298: p_encoded => 'F',
299: p_data => lx_msg_data,
300: p_msg_index_out => l_msg_index_out);
301: