eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_INS_EXCLUSIONS_PUB dependencies on FND_API

Line 5: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1: PACKAGE BODY OKL_INS_EXCLUSIONS_PUB AS
2: /* $Header: OKLPIENB.pls 115.8 2004/04/13 10:48:09 rnaik noship $ */
3: PROCEDURE insert_ins_exclusions(
4: p_api_version IN NUMBER
5: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
6: ,x_return_status OUT NOCOPY VARCHAR2
7: ,x_msg_count OUT NOCOPY NUMBER
8: ,x_msg_data OUT NOCOPY VARCHAR2
9: ,p_ienv_rec IN ienv_rec_type

Line 40: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

36: ,l_msg_count
37: ,l_msg_data
38: ,lp_ienv_rec
39: ,lx_ienv_rec);
40: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
41: RAISE FND_API.G_EXC_ERROR;
42: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;

Line 41: RAISE FND_API.G_EXC_ERROR;

37: ,l_msg_data
38: ,lp_ienv_rec
39: ,lx_ienv_rec);
40: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
41: RAISE FND_API.G_EXC_ERROR;
42: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;
45:

Line 42: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

38: ,lp_ienv_rec
39: ,lx_ienv_rec);
40: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
41: RAISE FND_API.G_EXC_ERROR;
42: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;
45:
46:

Line 43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

39: ,lx_ienv_rec);
40: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
41: RAISE FND_API.G_EXC_ERROR;
42: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
43: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
44: END IF;
45:
46:
47:

Line 57: WHEN FND_API.G_EXC_ERROR THEN

53: x_msg_count := l_msg_count ;
54: x_msg_data := l_msg_data ;
55:
56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58:
59: ROLLBACK TO ins_exclusions_insert;
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: x_msg_count := l_msg_count ;

Line 60: x_return_status := FND_API.G_RET_STS_ERROR;

56: EXCEPTION
57: WHEN FND_API.G_EXC_ERROR THEN
58:
59: ROLLBACK TO ins_exclusions_insert;
60: x_return_status := FND_API.G_RET_STS_ERROR;
61: x_msg_count := l_msg_count ;
62: x_msg_data := l_msg_data ;
63: FND_MSG_PUB.count_and_get(
64: p_count => x_msg_count

Line 66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

62: x_msg_data := l_msg_data ;
63: FND_MSG_PUB.count_and_get(
64: p_count => x_msg_count
65: ,p_data => x_msg_data);
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67:
68: ROLLBACK TO ins_exclusions_insert;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;

Line 69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

65: ,p_data => x_msg_data);
66: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
67:
68: ROLLBACK TO ins_exclusions_insert;
69: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
70: x_msg_count := l_msg_count ;
71: x_msg_data := l_msg_data ;
72: FND_MSG_PUB.count_and_get(
73: p_count => x_msg_count

Line 77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

73: p_count => x_msg_count
74: ,p_data => x_msg_data);
75: WHEN OTHERS THEN
76: ROLLBACK TO ins_exclusions_insert;
77: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
78: x_msg_count := l_msg_count ;
79: x_msg_data := l_msg_data ;
80: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
81: FND_MSG_PUB.count_and_get(

Line 87: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

83: ,p_data => x_msg_data);
84: END insert_ins_exclusions;
85: PROCEDURE insert_ins_exclusions(
86: p_api_version IN NUMBER
87: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
88: ,x_return_status OUT NOCOPY VARCHAR2
89: ,x_msg_count OUT NOCOPY NUMBER
90: ,x_msg_data OUT NOCOPY VARCHAR2
91: ,p_ienv_tbl IN ienv_tbl_type

Line 117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

113: ,l_msg_count
114: ,l_msg_data
115: ,lp_ienv_tbl
116: ,lx_ienv_tbl);
117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;

Line 118: RAISE FND_API.G_EXC_ERROR;

114: ,l_msg_data
115: ,lp_ienv_tbl
116: ,lx_ienv_tbl);
117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: --Assign value to OUT variables

Line 119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

115: ,lp_ienv_tbl
116: ,lx_ienv_tbl);
117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: --Assign value to OUT variables
123: x_ienv_tbl := lx_ienv_tbl;

Line 120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

116: ,lx_ienv_tbl);
117: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
118: RAISE FND_API.G_EXC_ERROR;
119: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
120: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
121: END IF;
122: --Assign value to OUT variables
123: x_ienv_tbl := lx_ienv_tbl;
124: x_return_status := l_return_status ;

Line 129: WHEN FND_API.G_EXC_ERROR THEN

125: x_msg_count := l_msg_count ;
126: x_msg_data := l_msg_data ;
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130:
131: ROLLBACK TO ins_exclusions_insert;
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: x_msg_count := l_msg_count ;

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130:
131: ROLLBACK TO ins_exclusions_insert;
132: x_return_status := FND_API.G_RET_STS_ERROR;
133: x_msg_count := l_msg_count ;
134: x_msg_data := l_msg_data ;
135: FND_MSG_PUB.count_and_get(
136: p_count => x_msg_count

Line 138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

134: x_msg_data := l_msg_data ;
135: FND_MSG_PUB.count_and_get(
136: p_count => x_msg_count
137: ,p_data => x_msg_data);
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: ROLLBACK TO ins_exclusions_insert;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: x_msg_count := l_msg_count ;
142: x_msg_data := l_msg_data ;

Line 140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

136: p_count => x_msg_count
137: ,p_data => x_msg_data);
138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
139: ROLLBACK TO ins_exclusions_insert;
140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
141: x_msg_count := l_msg_count ;
142: x_msg_data := l_msg_data ;
143: FND_MSG_PUB.count_and_get(
144: p_count => x_msg_count

Line 148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

144: p_count => x_msg_count
145: ,p_data => x_msg_data);
146: WHEN OTHERS THEN
147: ROLLBACK TO ins_exclusions_insert;
148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
149: x_msg_count := l_msg_count ;
150: x_msg_data := l_msg_data ;
151: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','insert_ins_exclusions');
152: FND_MSG_PUB.count_and_get(

Line 158: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

154: ,p_data => x_msg_data);
155: END insert_ins_exclusions;
156: PROCEDURE lock_ins_exclusions(
157: p_api_version IN NUMBER
158: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: ,x_return_status OUT NOCOPY VARCHAR2
160: ,x_msg_count OUT NOCOPY NUMBER
161: ,x_msg_data OUT NOCOPY VARCHAR2
162: ,p_ienv_rec IN ienv_rec_type) IS

Line 171: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

167: x_return_status,
168: x_msg_count,
169: x_msg_data,
170: p_ienv_rec);
171: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;

Line 172: RAISE FND_API.G_EXC_ERROR;

168: x_msg_count,
169: x_msg_data,
170: p_ienv_rec);
171: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176: END lock_ins_exclusions;

Line 173: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

169: x_msg_data,
170: p_ienv_rec);
171: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176: END lock_ins_exclusions;
177: PROCEDURE lock_ins_exclusions(

Line 174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

170: p_ienv_rec);
171: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
172: RAISE FND_API.G_EXC_ERROR;
173: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
174: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
175: END IF;
176: END lock_ins_exclusions;
177: PROCEDURE lock_ins_exclusions(
178: p_api_version IN NUMBER

Line 179: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

175: END IF;
176: END lock_ins_exclusions;
177: PROCEDURE lock_ins_exclusions(
178: p_api_version IN NUMBER
179: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
180: ,x_return_status OUT NOCOPY VARCHAR2
181: ,x_msg_count OUT NOCOPY NUMBER
182: ,x_msg_data OUT NOCOPY VARCHAR2
183: ,p_ienv_tbl IN ienv_tbl_type) IS

Line 192: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN

188: x_return_status,
189: x_msg_count,
190: x_msg_data,
191: p_ienv_tbl);
192: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;

Line 193: RAISE FND_API.G_EXC_ERROR;

189: x_msg_count,
190: x_msg_data,
191: p_ienv_tbl);
192: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: END lock_ins_exclusions;

Line 194: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

190: x_msg_data,
191: p_ienv_tbl);
192: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: END lock_ins_exclusions;
198: PROCEDURE update_ins_exclusions(

Line 195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

191: p_ienv_tbl);
192: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
193: RAISE FND_API.G_EXC_ERROR;
194: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
195: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
196: END IF;
197: END lock_ins_exclusions;
198: PROCEDURE update_ins_exclusions(
199: p_api_version IN NUMBER

Line 200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

196: END IF;
197: END lock_ins_exclusions;
198: PROCEDURE update_ins_exclusions(
199: p_api_version IN NUMBER
200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
201: ,x_return_status OUT NOCOPY VARCHAR2
202: ,x_msg_count OUT NOCOPY NUMBER
203: ,x_msg_data OUT NOCOPY VARCHAR2
204: ,p_ienv_rec IN ienv_rec_type

Line 232: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

228: ,l_msg_count
229: ,l_msg_data
230: ,lp_ienv_rec
231: ,lx_ienv_rec);
232: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;

Line 233: RAISE FND_API.G_EXC_ERROR;

229: ,l_msg_data
230: ,lp_ienv_rec
231: ,lx_ienv_rec);
232: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237: --Assign value to OUT variables

Line 234: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

230: ,lp_ienv_rec
231: ,lx_ienv_rec);
232: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237: --Assign value to OUT variables
238: x_ienv_rec := lx_ienv_rec;

Line 235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

231: ,lx_ienv_rec);
232: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
235: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
236: END IF;
237: --Assign value to OUT variables
238: x_ienv_rec := lx_ienv_rec;
239: x_return_status := l_return_status ;

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: x_return_status := l_return_status ;
240: x_msg_count := l_msg_count ;
241: x_msg_data := l_msg_data ;
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO ins_exclusions_update;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: x_msg_count := l_msg_count ;
247: x_msg_data := l_msg_data ;

Line 245: x_return_status := FND_API.G_RET_STS_ERROR;

241: x_msg_data := l_msg_data ;
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO ins_exclusions_update;
245: x_return_status := FND_API.G_RET_STS_ERROR;
246: x_msg_count := l_msg_count ;
247: x_msg_data := l_msg_data ;
248: FND_MSG_PUB.count_and_get(
249: p_count => x_msg_count

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: x_msg_data := l_msg_data ;
248: FND_MSG_PUB.count_and_get(
249: p_count => x_msg_count
250: ,p_data => x_msg_data);
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO ins_exclusions_update;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: x_msg_count := l_msg_count ;
255: x_msg_data := l_msg_data ;

Line 253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

249: p_count => x_msg_count
250: ,p_data => x_msg_data);
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO ins_exclusions_update;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
254: x_msg_count := l_msg_count ;
255: x_msg_data := l_msg_data ;
256: FND_MSG_PUB.count_and_get(
257: p_count => x_msg_count

Line 261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

257: p_count => x_msg_count
258: ,p_data => x_msg_data);
259: WHEN OTHERS THEN
260: ROLLBACK TO ins_exclusions_update;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: x_msg_count := l_msg_count ;
263: x_msg_data := l_msg_data ;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
265: FND_MSG_PUB.count_and_get(

Line 271: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

267: ,p_data => x_msg_data);
268: END update_ins_exclusions;
269: PROCEDURE update_ins_exclusions(
270: p_api_version IN NUMBER
271: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
272: ,x_return_status OUT NOCOPY VARCHAR2
273: ,x_msg_count OUT NOCOPY NUMBER
274: ,x_msg_data OUT NOCOPY VARCHAR2
275: ,p_ienv_tbl IN ienv_tbl_type

Line 300: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

296: ,l_msg_count
297: ,l_msg_data
298: ,lp_ienv_tbl
299: ,lx_ienv_tbl);
300: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_ERROR;

297: ,l_msg_data
298: ,lp_ienv_tbl
299: ,lx_ienv_tbl);
300: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: --Assign value to OUT variables

Line 302: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

298: ,lp_ienv_tbl
299: ,lx_ienv_tbl);
300: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: --Assign value to OUT variables
306: x_ienv_tbl := lx_ienv_tbl;

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: ,lx_ienv_tbl);
300: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305: --Assign value to OUT variables
306: x_ienv_tbl := lx_ienv_tbl;
307: x_return_status := l_return_status ;

Line 311: WHEN FND_API.G_EXC_ERROR THEN

307: x_return_status := l_return_status ;
308: x_msg_count := l_msg_count ;
309: x_msg_data := l_msg_data ;
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: ROLLBACK TO ins_exclusions_update;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: x_msg_count := l_msg_count ;
315: x_msg_data := l_msg_data ;

Line 313: x_return_status := FND_API.G_RET_STS_ERROR;

309: x_msg_data := l_msg_data ;
310: EXCEPTION
311: WHEN FND_API.G_EXC_ERROR THEN
312: ROLLBACK TO ins_exclusions_update;
313: x_return_status := FND_API.G_RET_STS_ERROR;
314: x_msg_count := l_msg_count ;
315: x_msg_data := l_msg_data ;
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: x_msg_data := l_msg_data ;
316: FND_MSG_PUB.count_and_get(
317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO ins_exclusions_update;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: x_msg_count := l_msg_count ;
323: x_msg_data := l_msg_data ;

Line 321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

317: p_count => x_msg_count
318: ,p_data => x_msg_data);
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: ROLLBACK TO ins_exclusions_update;
321: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
322: x_msg_count := l_msg_count ;
323: x_msg_data := l_msg_data ;
324: FND_MSG_PUB.count_and_get(
325: p_count => x_msg_count

Line 329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

325: p_count => x_msg_count
326: ,p_data => x_msg_data);
327: WHEN OTHERS THEN
328: ROLLBACK TO ins_exclusions_update;
329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
330: x_msg_count := l_msg_count ;
331: x_msg_data := l_msg_data ;
332: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','update_ins_exclusions');
333: FND_MSG_PUB.count_and_get(

Line 340: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

336: END update_ins_exclusions;
337: --Put custom code for cascade delete by developer
338: PROCEDURE delete_ins_exclusions(
339: p_api_version IN NUMBER
340: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
341: ,x_return_status OUT NOCOPY VARCHAR2
342: ,x_msg_count OUT NOCOPY NUMBER
343: ,x_msg_data OUT NOCOPY VARCHAR2
344: ,p_ienv_rec IN ienv_rec_type) IS

Line 371: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

367: ,l_return_status
368: ,l_msg_count
369: ,l_msg_data
370: ,lp_ienv_rec);
371: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;

Line 372: RAISE FND_API.G_EXC_ERROR;

368: ,l_msg_count
369: ,l_msg_data
370: ,lp_ienv_rec);
371: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:

Line 373: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

369: ,l_msg_data
370: ,lp_ienv_rec);
371: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377:

Line 374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

370: ,lp_ienv_rec);
371: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
372: RAISE FND_API.G_EXC_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
374: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
375: END IF;
376:
377:
378:

Line 385: WHEN FND_API.G_EXC_ERROR THEN

381: x_msg_count := l_msg_count ;
382: x_msg_data := l_msg_data ;
383: x_return_status := l_return_status ;
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO ins_exclusions_delete;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: x_msg_count := l_msg_count ;
389: x_msg_data := l_msg_data ;

Line 387: x_return_status := FND_API.G_RET_STS_ERROR;

383: x_return_status := l_return_status ;
384: EXCEPTION
385: WHEN FND_API.G_EXC_ERROR THEN
386: ROLLBACK TO ins_exclusions_delete;
387: x_return_status := FND_API.G_RET_STS_ERROR;
388: x_msg_count := l_msg_count ;
389: x_msg_data := l_msg_data ;
390: FND_MSG_PUB.count_and_get(
391: p_count => x_msg_count

Line 393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

389: x_msg_data := l_msg_data ;
390: FND_MSG_PUB.count_and_get(
391: p_count => x_msg_count
392: ,p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO ins_exclusions_delete;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: x_msg_count := l_msg_count ;
397: x_msg_data := l_msg_data ;

Line 395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

391: p_count => x_msg_count
392: ,p_data => x_msg_data);
393: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
394: ROLLBACK TO ins_exclusions_delete;
395: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
396: x_msg_count := l_msg_count ;
397: x_msg_data := l_msg_data ;
398: FND_MSG_PUB.count_and_get(
399: p_count => x_msg_count

Line 403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

399: p_count => x_msg_count
400: ,p_data => x_msg_data);
401: WHEN OTHERS THEN
402: ROLLBACK TO ins_exclusions_delete;
403: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
404: x_msg_count := l_msg_count ;
405: x_msg_data := l_msg_data ;
406: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
407: FND_MSG_PUB.count_and_get(

Line 413: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

409: ,p_data => x_msg_data);
410: END delete_ins_exclusions;
411: PROCEDURE delete_ins_exclusions(
412: p_api_version IN NUMBER
413: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
414: ,x_return_status OUT NOCOPY VARCHAR2
415: ,x_msg_count OUT NOCOPY NUMBER
416: ,x_msg_data OUT NOCOPY VARCHAR2
417: ,p_ienv_tbl IN ienv_tbl_type) IS

Line 449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

445: EXIT WHEN (i = lp_ienv_tbl.LAST);
446: i := p_ienv_tbl.NEXT(i);
447: END LOOP;
448: END IF;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;

Line 450: RAISE FND_API.G_EXC_ERROR;

446: i := p_ienv_tbl.NEXT(i);
447: END LOOP;
448: END IF;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END;

Line 451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

447: END LOOP;
448: END IF;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END;
455: --Assign value to OUT variables

Line 452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

448: END IF;
449: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
450: RAISE FND_API.G_EXC_ERROR;
451: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
452: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
453: END IF;
454: END;
455: --Assign value to OUT variables
456: x_msg_count := l_msg_count ;

Line 461: WHEN FND_API.G_EXC_ERROR THEN

457: x_msg_data := l_msg_data ;
458: l_return_status := OKC_API.G_RET_STS_SUCCESS;
459: x_return_status := l_return_status ;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: ROLLBACK TO ins_exclusions_delete;
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: x_msg_count := l_msg_count ;
465: x_msg_data := l_msg_data ;

Line 463: x_return_status := FND_API.G_RET_STS_ERROR;

459: x_return_status := l_return_status ;
460: EXCEPTION
461: WHEN FND_API.G_EXC_ERROR THEN
462: ROLLBACK TO ins_exclusions_delete;
463: x_return_status := FND_API.G_RET_STS_ERROR;
464: x_msg_count := l_msg_count ;
465: x_msg_data := l_msg_data ;
466: FND_MSG_PUB.count_and_get(
467: p_count => x_msg_count

Line 469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

465: x_msg_data := l_msg_data ;
466: FND_MSG_PUB.count_and_get(
467: p_count => x_msg_count
468: ,p_data => x_msg_data);
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: ROLLBACK TO ins_exclusions_delete;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: x_msg_count := l_msg_count ;
473: x_msg_data := l_msg_data ;

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

467: p_count => x_msg_count
468: ,p_data => x_msg_data);
469: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
470: ROLLBACK TO ins_exclusions_delete;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: x_msg_count := l_msg_count ;
473: x_msg_data := l_msg_data ;
474: FND_MSG_PUB.count_and_get(
475: p_count => x_msg_count

Line 479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

475: p_count => x_msg_count
476: ,p_data => x_msg_data);
477: WHEN OTHERS THEN
478: ROLLBACK TO ins_exclusions_delete;
479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
480: x_msg_count := l_msg_count ;
481: x_msg_data := l_msg_data ;
482: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','delete_ins_exclusions');
483: FND_MSG_PUB.count_and_get(

Line 489: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

485: ,p_data => x_msg_data);
486: END delete_ins_exclusions;
487: PROCEDURE validate_ins_exclusions(
488: p_api_version IN NUMBER
489: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
490: ,x_return_status OUT NOCOPY VARCHAR2
491: ,x_msg_count OUT NOCOPY NUMBER
492: ,x_msg_data OUT NOCOPY VARCHAR2
493: ,p_ienv_rec IN ienv_rec_type) IS

Line 514: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

510: ,l_return_status
511: ,l_msg_count
512: ,l_msg_data
513: ,lp_ienv_rec);
514: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;

Line 515: RAISE FND_API.G_EXC_ERROR;

511: ,l_msg_count
512: ,l_msg_data
513: ,lp_ienv_rec);
514: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: --Assign value to OUT variables

Line 516: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

512: ,l_msg_data
513: ,lp_ienv_rec);
514: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: --Assign value to OUT variables
520: x_msg_count := l_msg_count ;

Line 517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

513: ,lp_ienv_rec);
514: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
515: RAISE FND_API.G_EXC_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
517: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
518: END IF;
519: --Assign value to OUT variables
520: x_msg_count := l_msg_count ;
521: x_msg_data := l_msg_data ;

Line 524: WHEN FND_API.G_EXC_ERROR THEN

520: x_msg_count := l_msg_count ;
521: x_msg_data := l_msg_data ;
522: x_return_status := l_return_status ;
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO ins_exclusions_validate;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;

Line 526: x_return_status := FND_API.G_RET_STS_ERROR;

522: x_return_status := l_return_status ;
523: EXCEPTION
524: WHEN FND_API.G_EXC_ERROR THEN
525: ROLLBACK TO ins_exclusions_validate;
526: x_return_status := FND_API.G_RET_STS_ERROR;
527: x_msg_count := l_msg_count ;
528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count

Line 532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

528: x_msg_data := l_msg_data ;
529: FND_MSG_PUB.count_and_get(
530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO ins_exclusions_validate;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;

Line 534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

530: p_count => x_msg_count
531: ,p_data => x_msg_data);
532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO ins_exclusions_validate;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: x_msg_count := l_msg_count ;
536: x_msg_data := l_msg_data ;
537: FND_MSG_PUB.count_and_get(
538: p_count => x_msg_count

Line 542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

538: p_count => x_msg_count
539: ,p_data => x_msg_data);
540: WHEN OTHERS THEN
541: ROLLBACK TO ins_exclusions_validate;
542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
543: x_msg_count := l_msg_count ;
544: x_msg_data := l_msg_data ;
545: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
546: FND_MSG_PUB.count_and_get(

Line 552: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

548: ,p_data => x_msg_data);
549: END validate_ins_exclusions;
550: PROCEDURE validate_ins_exclusions(
551: p_api_version IN NUMBER,
552: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,
555: x_msg_data OUT NOCOPY VARCHAR2,
556: p_ienv_tbl IN ienv_tbl_type) IS

Line 577: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN

573: ,x_return_status
574: ,x_msg_count
575: ,x_msg_data
576: ,lp_ienv_tbl);
577: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;

Line 578: RAISE FND_API.G_EXC_ERROR;

574: ,x_msg_count
575: ,x_msg_data
576: ,lp_ienv_tbl);
577: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: --Assign value to OUT variables

Line 579: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN

575: ,x_msg_data
576: ,lp_ienv_tbl);
577: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: --Assign value to OUT variables
583: x_msg_count := l_msg_count ;

Line 580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

576: ,lp_ienv_tbl);
577: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
578: RAISE FND_API.G_EXC_ERROR;
579: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
581: END IF;
582: --Assign value to OUT variables
583: x_msg_count := l_msg_count ;
584: x_msg_data := l_msg_data ;

Line 587: WHEN FND_API.G_EXC_ERROR THEN

583: x_msg_count := l_msg_count ;
584: x_msg_data := l_msg_data ;
585: x_return_status := l_return_status ;
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO ins_exclusions_validate;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: x_msg_count := l_msg_count ;
591: x_msg_data := l_msg_data ;

Line 589: x_return_status := FND_API.G_RET_STS_ERROR;

585: x_return_status := l_return_status ;
586: EXCEPTION
587: WHEN FND_API.G_EXC_ERROR THEN
588: ROLLBACK TO ins_exclusions_validate;
589: x_return_status := FND_API.G_RET_STS_ERROR;
590: x_msg_count := l_msg_count ;
591: x_msg_data := l_msg_data ;
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count

Line 595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

591: x_msg_data := l_msg_data ;
592: FND_MSG_PUB.count_and_get(
593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO ins_exclusions_validate;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: x_msg_count := l_msg_count ;
599: x_msg_data := l_msg_data ;

Line 597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

593: p_count => x_msg_count
594: ,p_data => x_msg_data);
595: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
596: ROLLBACK TO ins_exclusions_validate;
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598: x_msg_count := l_msg_count ;
599: x_msg_data := l_msg_data ;
600: FND_MSG_PUB.count_and_get(
601: p_count => x_msg_count

Line 605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

601: p_count => x_msg_count
602: ,p_data => x_msg_data);
603: WHEN OTHERS THEN
604: ROLLBACK TO ins_exclusions_validate;
605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
606: x_msg_count := l_msg_count ;
607: x_msg_data := l_msg_data ;
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_EXCLUSIONS_PUB','validate_ins_exclusions');
609: FND_MSG_PUB.count_and_get(