DBA Data[Home] [Help]

APPS.OKL_CSH_ALLCT_RULES_PUB dependencies on FND_API

Line 61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

57: x_return_status := l_return_status ;
58: x_msg_count := l_msg_count ;
59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;

Line 62: RAISE Fnd_Api.G_EXC_ERROR;

58: x_msg_count := l_msg_count ;
59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:

Line 63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:

Line 64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:
68:

Line 72: WHEN Fnd_Api.G_EXC_ERROR THEN

68:
69:
70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO csh_allct_rules_delete_rec;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;

Line 74: x_return_status := Fnd_Api.G_RET_STS_ERROR;

70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO csh_allct_rules_delete_rec;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: --Fnd_Msg_Pub.count_and_get(
78: -- p_count => x_msg_count

Line 80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

76: x_msg_data := l_msg_data ;
77: --Fnd_Msg_Pub.count_and_get(
78: -- p_count => x_msg_count
79: -- ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO csh_allct_rules_delete_rec;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;

Line 82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

78: -- p_count => x_msg_count
79: -- ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO csh_allct_rules_delete_rec;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
85: --Fnd_Msg_Pub.count_and_get(
86: -- p_count => x_msg_count

Line 90: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

86: -- p_count => x_msg_count
87: -- ,p_data => x_msg_data);
88: WHEN OTHERS THEN
89: ROLLBACK TO csh_allct_rules_delete_rec;
90: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
91: x_msg_count := l_msg_count ;
92: x_msg_data := l_msg_data ;
93: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_RULES_PUB','delete_csh_allct_srchs');
94: --Fnd_Msg_Pub.count_and_get(

Line 167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN

163: i := p_cahv_tbl.NEXT(i);
164: END LOOP;
165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;

Line 168: RAISE Fnd_Api.G_EXC_ERROR;

164: END LOOP;
165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:

Line 169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN

165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173:

Line 170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173:
174:

Line 179: WHEN Fnd_Api.G_EXC_ERROR THEN

175:
176:
177: EXCEPTION
178:
179: WHEN Fnd_Api.G_EXC_ERROR THEN
180: ROLLBACK TO csh_allct_rules_delete_tbl;
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;

Line 181: x_return_status := Fnd_Api.G_RET_STS_ERROR;

177: EXCEPTION
178:
179: WHEN Fnd_Api.G_EXC_ERROR THEN
180: ROLLBACK TO csh_allct_rules_delete_tbl;
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;
184: --Fnd_Msg_Pub.count_and_get(
185: -- p_count => x_msg_count

Line 187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

183: x_msg_data := l_msg_data ;
184: --Fnd_Msg_Pub.count_and_get(
185: -- p_count => x_msg_count
186: -- ,p_data => x_msg_data);
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO csh_allct_rules_delete_tbl;
189: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;

Line 189: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

185: -- p_count => x_msg_count
186: -- ,p_data => x_msg_data);
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO csh_allct_rules_delete_tbl;
189: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;
192: --Fnd_Msg_Pub.count_and_get(
193: -- p_count => x_msg_count

Line 197: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

193: -- p_count => x_msg_count
194: -- ,p_data => x_msg_data);
195: WHEN OTHERS THEN
196: ROLLBACK TO csh_allct_rules_delete_tbl;
197: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
198: x_msg_count := l_msg_count ;
199: x_msg_data := l_msg_data ;
200: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_RULES_PUB','delete_csh_allct_srchs');
201: --Fnd_Msg_Pub.count_and_get(