APPS.OKL_OPT_RUL_TMP_PVT dependencies on FND_API

Line 124: WHEN Fnd_Api.G_EXC_ERROR THEN

120: x_msg_data => x_msg_data,
121: p_ovtv_rec => l_ovtv_rec,
122: x_ovtv_rec => x_ovtv_rec);
123: EXCEPTION
124: WHEN Fnd_Api.G_EXC_ERROR THEN
125: ROLLBACK TO Opt_Rul_Tmp_insert;
126: x_return_status := Fnd_Api.G_RET_STS_ERROR;
127: x_msg_count := l_msg_count ;
128: x_msg_data := l_msg_data ;

Line 126: x_return_status := Fnd_Api.G_RET_STS_ERROR;

122: x_ovtv_rec => x_ovtv_rec);
123: EXCEPTION
124: WHEN Fnd_Api.G_EXC_ERROR THEN
125: ROLLBACK TO Opt_Rul_Tmp_insert;
126: x_return_status := Fnd_Api.G_RET_STS_ERROR;
127: x_msg_count := l_msg_count ;
128: x_msg_data := l_msg_data ;
129: Fnd_Msg_Pub.count_and_get(
130: p_count => x_msg_count

Line 132: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

128: x_msg_data := l_msg_data ;
129: Fnd_Msg_Pub.count_and_get(
130: p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO Opt_Rul_Tmp_insert;
134: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
135: x_msg_count := l_msg_count ;
136: x_msg_data := l_msg_data ;

Line 134: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

130: p_count => x_msg_count
131: ,p_data => x_msg_data);
132: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
133: ROLLBACK TO Opt_Rul_Tmp_insert;
134: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
135: x_msg_count := l_msg_count ;
136: x_msg_data := l_msg_data ;
137: Fnd_Msg_Pub.count_and_get(
138: p_count => x_msg_count

Line 142: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

138: p_count => x_msg_count
139: ,p_data => x_msg_data);
140: WHEN OTHERS THEN
141: ROLLBACK TO Opt_Rul_Tmp_insert;
142: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
143: x_msg_count := l_msg_count ;
144: x_msg_data := l_msg_data ;
145: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');
146: Fnd_Msg_Pub.count_and_get(

Line 188: WHEN Fnd_Api.G_EXC_ERROR THEN

184: ,x_rgrv_rec);
185:
186: END LOOP;
187: EXCEPTION
188: WHEN Fnd_Api.G_EXC_ERROR THEN
189: ROLLBACK TO Opt_Rul_Tmp_insert;
190: x_return_status := Fnd_Api.G_RET_STS_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;

Line 190: x_return_status := Fnd_Api.G_RET_STS_ERROR;

186: END LOOP;
187: EXCEPTION
188: WHEN Fnd_Api.G_EXC_ERROR THEN
189: ROLLBACK TO Opt_Rul_Tmp_insert;
190: x_return_status := Fnd_Api.G_RET_STS_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;
193: Fnd_Msg_Pub.count_and_get(
194: p_count => x_msg_count

Line 196: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

192: x_msg_data := l_msg_data ;
193: Fnd_Msg_Pub.count_and_get(
194: p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
197: ROLLBACK TO Opt_Rul_Tmp_insert;
198: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;

Line 198: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

194: p_count => x_msg_count
195: ,p_data => x_msg_data);
196: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
197: ROLLBACK TO Opt_Rul_Tmp_insert;
198: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
199: x_msg_count := l_msg_count ;
200: x_msg_data := l_msg_data ;
201: Fnd_Msg_Pub.count_and_get(
202: p_count => x_msg_count

Line 206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: WHEN OTHERS THEN
205: ROLLBACK TO Opt_Rul_Tmp_insert;
206: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
207: x_msg_count := l_msg_count ;
208: x_msg_data := l_msg_data ;
209: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_Opt_Rul_Tmp_PVT','insert_Opt_Rul_Tmp');
210: Fnd_Msg_Pub.count_and_get(