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_POLICIES_PUB dependencies on FND_API

Line 5: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

1: PACKAGE BODY okl_ins_policies_pub AS
2: /* $Header: OKLPIPYB.pls 120.3 2006/11/22 18:28:40 asahoo noship $ */
3: PROCEDURE insert_ins_policies(
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_ipyv_rec IN ipyv_rec_type

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

35: ,l_msg_data
36: ,lp_ipyv_rec
37: ,lx_ipyv_rec);
38:
39: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
40: RAISE FND_API.G_EXC_ERROR;
41: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;

Line 40: RAISE FND_API.G_EXC_ERROR;

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

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

37: ,lx_ipyv_rec);
38:
39: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
40: RAISE FND_API.G_EXC_ERROR;
41: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: --Copy value of OUT variable in the IN record type

Line 42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

38:
39: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
40: RAISE FND_API.G_EXC_ERROR;
41: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
42: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
43: END IF;
44:
45: --Copy value of OUT variable in the IN record type
46: lp_ipyv_rec := lx_ipyv_rec;

Line 54: WHEN FND_API.G_EXC_ERROR THEN

50: x_return_status := l_return_status ;
51: x_msg_count := l_msg_count ;
52: x_msg_data := l_msg_data ;
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO ins_policies_insert;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: x_msg_count := l_msg_count ;
58: x_msg_data := l_msg_data ;

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52: x_msg_data := l_msg_data ;
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO ins_policies_insert;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57: x_msg_count := l_msg_count ;
58: x_msg_data := l_msg_data ;
59: FND_MSG_PUB.count_and_get(
60: p_count => x_msg_count

Line 62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

58: x_msg_data := l_msg_data ;
59: FND_MSG_PUB.count_and_get(
60: p_count => x_msg_count
61: ,p_data => x_msg_data);
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO ins_policies_insert;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: x_msg_count := l_msg_count ;
66: x_msg_data := l_msg_data ;

Line 64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

68: p_count => x_msg_count
69: ,p_data => x_msg_data);
70: WHEN OTHERS THEN
71: ROLLBACK TO ins_policies_insert;
72: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
73: x_msg_count := l_msg_count ;
74: x_msg_data := l_msg_data ;
75: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
76: FND_MSG_PUB.count_and_get(

Line 82: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

78: ,p_data => x_msg_data);
79: END insert_ins_policies;
80: PROCEDURE insert_ins_policies(
81: p_api_version IN NUMBER
82: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
83: ,x_return_status OUT NOCOPY VARCHAR2
84: ,x_msg_count OUT NOCOPY NUMBER
85: ,x_msg_data OUT NOCOPY VARCHAR2
86: ,p_ipyv_tbl IN ipyv_tbl_type

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

111: ,l_msg_count
112: ,l_msg_data
113: ,lp_ipyv_tbl
114: ,lx_ipyv_tbl);
115: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;

Line 116: RAISE FND_API.G_EXC_ERROR;

112: ,l_msg_data
113: ,lp_ipyv_tbl
114: ,lx_ipyv_tbl);
115: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120: --Copy value of OUT variable in the IN record type

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

113: ,lp_ipyv_tbl
114: ,lx_ipyv_tbl);
115: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120: --Copy value of OUT variable in the IN record type
121: lp_ipyv_tbl := lx_ipyv_tbl;

Line 118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

114: ,lx_ipyv_tbl);
115: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
116: RAISE FND_API.G_EXC_ERROR;
117: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
118: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
119: END IF;
120: --Copy value of OUT variable in the IN record type
121: lp_ipyv_tbl := lx_ipyv_tbl;
122: --Assign value to OUT variables

Line 128: WHEN FND_API.G_EXC_ERROR THEN

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

Line 130: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 138: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: p_count => x_msg_count
143: ,p_data => x_msg_data);
144: WHEN OTHERS THEN
145: ROLLBACK TO ins_policies_insert;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: x_msg_count := l_msg_count ;
148: x_msg_data := l_msg_data ;
149: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','insert_ins_policies');
150: FND_MSG_PUB.count_and_get(

Line 156: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

152: ,p_data => x_msg_data);
153: END insert_ins_policies;
154: PROCEDURE lock_ins_policies(
155: p_api_version IN NUMBER
156: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
157: ,x_return_status OUT NOCOPY VARCHAR2
158: ,x_msg_count OUT NOCOPY NUMBER
159: ,x_msg_data OUT NOCOPY VARCHAR2
160: ,p_ipyv_rec IN ipyv_rec_type) IS

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

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

Line 170: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

168: p_ipyv_rec);
169: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
170: RAISE FND_API.G_EXC_ERROR;
171: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: FND_MSG_PUB.count_and_get(

Line 175: WHEN FND_API.G_EXC_ERROR THEN

171: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
172: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
173: END IF;
174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

175: WHEN FND_API.G_EXC_ERROR THEN
176: FND_MSG_PUB.count_and_get(
177: p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: WHEN OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');
186: FND_MSG_PUB.count_and_get(
187: p_count => x_msg_count
188: ,p_data => x_msg_data);

Line 192: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

188: ,p_data => x_msg_data);
189: END lock_ins_policies;
190: PROCEDURE lock_ins_policies(
191: p_api_version IN NUMBER
192: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
193: ,x_return_status OUT NOCOPY VARCHAR2
194: ,x_msg_count OUT NOCOPY NUMBER
195: ,x_msg_data OUT NOCOPY VARCHAR2
196: ,p_ipyv_tbl IN ipyv_tbl_type) IS

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

201: x_return_status,
202: x_msg_count,
203: x_msg_data,
204: p_ipyv_tbl);
205: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
206: RAISE FND_API.G_EXC_ERROR;
207: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;

Line 206: RAISE FND_API.G_EXC_ERROR;

202: x_msg_count,
203: x_msg_data,
204: p_ipyv_tbl);
205: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
206: RAISE FND_API.G_EXC_ERROR;
207: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION

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

203: x_msg_data,
204: p_ipyv_tbl);
205: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
206: RAISE FND_API.G_EXC_ERROR;
207: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN

Line 208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

204: p_ipyv_tbl);
205: IF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
206: RAISE FND_API.G_EXC_ERROR;
207: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(

Line 211: WHEN FND_API.G_EXC_ERROR THEN

207: ELSIF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
208: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
209: END IF;
210: EXCEPTION
211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

211: WHEN FND_API.G_EXC_ERROR THEN
212: FND_MSG_PUB.count_and_get(
213: p_count => x_msg_count
214: ,p_data => x_msg_data);
215: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN

Line 220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

216: FND_MSG_PUB.count_and_get(
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','lock_ins_policies');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);

Line 228: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

224: ,p_data => x_msg_data);
225: END lock_ins_policies;
226: PROCEDURE update_ins_policies(
227: p_api_version IN NUMBER
228: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
229: ,x_return_status OUT NOCOPY VARCHAR2
230: ,x_msg_count OUT NOCOPY NUMBER
231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,p_ipyv_rec IN ipyv_rec_type

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

254: ,l_msg_count
255: ,l_msg_data
256: ,lp_ipyv_rec
257: ,lx_ipyv_rec);
258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;

Line 259: RAISE FND_API.G_EXC_ERROR;

255: ,l_msg_data
256: ,lp_ipyv_rec
257: ,lx_ipyv_rec);
258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: --Copy value of OUT variable in the IN record type

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

256: ,lp_ipyv_rec
257: ,lx_ipyv_rec);
258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: --Copy value of OUT variable in the IN record type
264: lp_ipyv_rec := lx_ipyv_rec;

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: ,lx_ipyv_rec);
258: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
259: RAISE FND_API.G_EXC_ERROR;
260: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: END IF;
263: --Copy value of OUT variable in the IN record type
264: lp_ipyv_rec := lx_ipyv_rec;
265: --Assign value to OUT variables

Line 271: WHEN FND_API.G_EXC_ERROR THEN

267: x_return_status := l_return_status ;
268: x_msg_count := l_msg_count ;
269: x_msg_data := l_msg_data ;
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO ins_policies_update;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_count := l_msg_count ;
275: x_msg_data := l_msg_data ;

Line 273: x_return_status := FND_API.G_RET_STS_ERROR;

269: x_msg_data := l_msg_data ;
270: EXCEPTION
271: WHEN FND_API.G_EXC_ERROR THEN
272: ROLLBACK TO ins_policies_update;
273: x_return_status := FND_API.G_RET_STS_ERROR;
274: x_msg_count := l_msg_count ;
275: x_msg_data := l_msg_data ;
276: FND_MSG_PUB.count_and_get(
277: p_count => x_msg_count

Line 279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

275: x_msg_data := l_msg_data ;
276: FND_MSG_PUB.count_and_get(
277: p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO ins_policies_update;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: x_msg_count := l_msg_count ;
283: x_msg_data := l_msg_data ;

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

277: p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO ins_policies_update;
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
282: x_msg_count := l_msg_count ;
283: x_msg_data := l_msg_data ;
284: FND_MSG_PUB.count_and_get(
285: p_count => x_msg_count

Line 289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

285: p_count => x_msg_count
286: ,p_data => x_msg_data);
287: WHEN OTHERS THEN
288: ROLLBACK TO ins_policies_update;
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: x_msg_count := l_msg_count ;
291: x_msg_data := l_msg_data ;
292: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
293: FND_MSG_PUB.count_and_get(

Line 299: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

295: ,p_data => x_msg_data);
296: END update_ins_policies;
297: PROCEDURE update_ins_policies(
298: p_api_version IN NUMBER
299: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
300: ,x_return_status OUT NOCOPY VARCHAR2
301: ,x_msg_count OUT NOCOPY NUMBER
302: ,x_msg_data OUT NOCOPY VARCHAR2
303: ,p_ipyv_tbl IN ipyv_tbl_type

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

324: ,l_msg_count
325: ,l_msg_data
326: ,lp_ipyv_tbl
327: ,lx_ipyv_tbl);
328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;

Line 329: RAISE FND_API.G_EXC_ERROR;

325: ,l_msg_data
326: ,lp_ipyv_tbl
327: ,lx_ipyv_tbl);
328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: --Copy value of OUT variable in the IN record type

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

326: ,lp_ipyv_tbl
327: ,lx_ipyv_tbl);
328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: --Copy value of OUT variable in the IN record type
334: lp_ipyv_tbl := lx_ipyv_tbl;

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: ,lx_ipyv_tbl);
328: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333: --Copy value of OUT variable in the IN record type
334: lp_ipyv_tbl := lx_ipyv_tbl;
335: --Assign value to OUT variables

Line 341: WHEN FND_API.G_EXC_ERROR THEN

337: x_return_status := l_return_status ;
338: x_msg_count := l_msg_count ;
339: x_msg_data := l_msg_data ;
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO ins_policies_update;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: x_msg_data := l_msg_data ;
340: EXCEPTION
341: WHEN FND_API.G_EXC_ERROR THEN
342: ROLLBACK TO ins_policies_update;
343: x_return_status := FND_API.G_RET_STS_ERROR;
344: x_msg_count := l_msg_count ;
345: x_msg_data := l_msg_data ;
346: FND_MSG_PUB.count_and_get(
347: p_count => x_msg_count

Line 349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

345: x_msg_data := l_msg_data ;
346: FND_MSG_PUB.count_and_get(
347: p_count => x_msg_count
348: ,p_data => x_msg_data);
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: ROLLBACK TO ins_policies_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;

Line 351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

347: p_count => x_msg_count
348: ,p_data => x_msg_data);
349: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
350: ROLLBACK TO ins_policies_update;
351: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
352: x_msg_count := l_msg_count ;
353: x_msg_data := l_msg_data ;
354: FND_MSG_PUB.count_and_get(
355: p_count => x_msg_count

Line 359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

355: p_count => x_msg_count
356: ,p_data => x_msg_data);
357: WHEN OTHERS THEN
358: ROLLBACK TO ins_policies_update;
359: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
360: x_msg_count := l_msg_count ;
361: x_msg_data := l_msg_data ;
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','update_ins_policies');
363: FND_MSG_PUB.count_and_get(

Line 370: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

366: END update_ins_policies;
367: --Put custom code for cascade delete by developer
368: PROCEDURE delete_ins_policies(
369: p_api_version IN NUMBER
370: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
371: ,x_return_status OUT NOCOPY VARCHAR2
372: ,x_msg_count OUT NOCOPY NUMBER
373: ,x_msg_data OUT NOCOPY VARCHAR2
374: ,p_ipyv_rec IN ipyv_rec_type) IS

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

395: ,l_return_status
396: ,l_msg_count
397: ,l_msg_data
398: ,lp_ipyv_rec);
399: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;

Line 400: RAISE FND_API.G_EXC_ERROR;

396: ,l_msg_count
397: ,l_msg_data
398: ,lp_ipyv_rec);
399: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: --Assign value to OUT variables

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

397: ,l_msg_data
398: ,lp_ipyv_rec);
399: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: --Assign value to OUT variables
405: x_msg_count := l_msg_count ;

Line 402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

398: ,lp_ipyv_rec);
399: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
402: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
403: END IF;
404: --Assign value to OUT variables
405: x_msg_count := l_msg_count ;
406: x_msg_data := l_msg_data ;

Line 409: WHEN FND_API.G_EXC_ERROR THEN

405: x_msg_count := l_msg_count ;
406: x_msg_data := l_msg_data ;
407: x_return_status := l_return_status ;
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO ins_policies_delete_rec;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;

Line 411: x_return_status := FND_API.G_RET_STS_ERROR;

407: x_return_status := l_return_status ;
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO ins_policies_delete_rec;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: x_msg_count := l_msg_count ;
413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.count_and_get(
415: p_count => x_msg_count

Line 417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

413: x_msg_data := l_msg_data ;
414: FND_MSG_PUB.count_and_get(
415: p_count => x_msg_count
416: ,p_data => x_msg_data);
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO ins_policies_delete_rec;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

415: p_count => x_msg_count
416: ,p_data => x_msg_data);
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418: ROLLBACK TO ins_policies_delete_rec;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: x_msg_count := l_msg_count ;
421: x_msg_data := l_msg_data ;
422: FND_MSG_PUB.count_and_get(
423: p_count => x_msg_count

Line 427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

423: p_count => x_msg_count
424: ,p_data => x_msg_data);
425: WHEN OTHERS THEN
426: ROLLBACK TO ins_policies_delete_rec;
427: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
428: x_msg_count := l_msg_count ;
429: x_msg_data := l_msg_data ;
430: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
431: FND_MSG_PUB.count_and_get(

Line 437: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

433: ,p_data => x_msg_data);
434: END delete_ins_policies;
435: PROCEDURE delete_ins_policies(
436: p_api_version IN NUMBER
437: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
438: ,x_return_status OUT NOCOPY VARCHAR2
439: ,x_msg_count OUT NOCOPY NUMBER
440: ,x_msg_data OUT NOCOPY VARCHAR2
441: ,p_ipyv_tbl IN ipyv_tbl_type) IS

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

471: EXIT WHEN (i = lp_ipyv_tbl.LAST);
472: i := p_ipyv_tbl.NEXT(i);
473: END LOOP;
474: END IF;
475: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;

Line 476: RAISE FND_API.G_EXC_ERROR;

472: i := p_ipyv_tbl.NEXT(i);
473: END LOOP;
474: END IF;
475: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480: END;

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

473: END LOOP;
474: END IF;
475: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480: END;
481: --Assign value to OUT variables

Line 478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

474: END IF;
475: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
476: RAISE FND_API.G_EXC_ERROR;
477: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
478: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
479: END IF;
480: END;
481: --Assign value to OUT variables
482: x_msg_count := l_msg_count ;

Line 486: WHEN FND_API.G_EXC_ERROR THEN

482: x_msg_count := l_msg_count ;
483: x_msg_data := l_msg_data ;
484: x_return_status := l_return_status ;
485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO ins_policies_delete_tbl;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_msg_count := l_msg_count ;
490: x_msg_data := l_msg_data ;

Line 488: x_return_status := FND_API.G_RET_STS_ERROR;

484: x_return_status := l_return_status ;
485: EXCEPTION
486: WHEN FND_API.G_EXC_ERROR THEN
487: ROLLBACK TO ins_policies_delete_tbl;
488: x_return_status := FND_API.G_RET_STS_ERROR;
489: x_msg_count := l_msg_count ;
490: x_msg_data := l_msg_data ;
491: FND_MSG_PUB.count_and_get(
492: p_count => x_msg_count

Line 494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

490: x_msg_data := l_msg_data ;
491: FND_MSG_PUB.count_and_get(
492: p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO ins_policies_delete_tbl;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;

Line 496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

492: p_count => x_msg_count
493: ,p_data => x_msg_data);
494: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
495: ROLLBACK TO ins_policies_delete_tbl;
496: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
497: x_msg_count := l_msg_count ;
498: x_msg_data := l_msg_data ;
499: FND_MSG_PUB.count_and_get(
500: p_count => x_msg_count

Line 504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

500: p_count => x_msg_count
501: ,p_data => x_msg_data);
502: WHEN OTHERS THEN
503: ROLLBACK TO ins_policies_delete_tbl;
504: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
505: x_msg_count := l_msg_count ;
506: x_msg_data := l_msg_data ;
507: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','delete_ins_policies');
508: FND_MSG_PUB.count_and_get(

Line 514: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

510: ,p_data => x_msg_data);
511: END delete_ins_policies;
512: PROCEDURE validate_ins_policies(
513: p_api_version IN NUMBER
514: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
515: ,x_return_status OUT NOCOPY VARCHAR2
516: ,x_msg_count OUT NOCOPY NUMBER
517: ,x_msg_data OUT NOCOPY VARCHAR2
518: ,p_ipyv_rec IN ipyv_rec_type) IS

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

537: ,l_return_status
538: ,l_msg_count
539: ,l_msg_data
540: ,lp_ipyv_rec);
541: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;

Line 542: RAISE FND_API.G_EXC_ERROR;

538: ,l_msg_count
539: ,l_msg_data
540: ,lp_ipyv_rec);
541: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546: --Copy value of OUT variable in the IN record type

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

539: ,l_msg_data
540: ,lp_ipyv_rec);
541: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546: --Copy value of OUT variable in the IN record type
547: lp_ipyv_rec := lx_ipyv_rec;

Line 544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

540: ,lp_ipyv_rec);
541: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
544: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
545: END IF;
546: --Copy value of OUT variable in the IN record type
547: lp_ipyv_rec := lx_ipyv_rec;
548: --Assign value to OUT variables

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: x_msg_count := l_msg_count ;
550: x_msg_data := l_msg_data ;
551: x_return_status := l_return_status ;
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO ins_policies_validate;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;

Line 555: x_return_status := FND_API.G_RET_STS_ERROR;

551: x_return_status := l_return_status ;
552: EXCEPTION
553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO ins_policies_validate;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: x_msg_count := l_msg_count ;
557: x_msg_data := l_msg_data ;
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count

Line 561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

557: x_msg_data := l_msg_data ;
558: FND_MSG_PUB.count_and_get(
559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO ins_policies_validate;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;

Line 563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

559: p_count => x_msg_count
560: ,p_data => x_msg_data);
561: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
562: ROLLBACK TO ins_policies_validate;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.count_and_get(
567: p_count => x_msg_count

Line 571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

567: p_count => x_msg_count
568: ,p_data => x_msg_data);
569: WHEN OTHERS THEN
570: ROLLBACK TO ins_policies_validate;
571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
572: x_msg_count := l_msg_count ;
573: x_msg_data := l_msg_data ;
574: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
575: FND_MSG_PUB.count_and_get(

Line 581: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

577: ,p_data => x_msg_data);
578: END validate_ins_policies;
579: PROCEDURE validate_ins_policies(
580: p_api_version IN NUMBER,
581: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
582: x_return_status OUT NOCOPY VARCHAR2,
583: x_msg_count OUT NOCOPY NUMBER,
584: x_msg_data OUT NOCOPY VARCHAR2,
585: p_ipyv_tbl IN ipyv_tbl_type) IS

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

604: ,x_return_status
605: ,x_msg_count
606: ,x_msg_data
607: ,lp_ipyv_tbl);
608: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;

Line 609: RAISE FND_API.G_EXC_ERROR;

605: ,x_msg_count
606: ,x_msg_data
607: ,lp_ipyv_tbl);
608: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613: --Copy value of OUT variable in the IN record type

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

606: ,x_msg_data
607: ,lp_ipyv_tbl);
608: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613: --Copy value of OUT variable in the IN record type
614: lp_ipyv_tbl := lx_ipyv_tbl;

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: ,lp_ipyv_tbl);
608: IF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
609: RAISE FND_API.G_EXC_ERROR;
610: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613: --Copy value of OUT variable in the IN record type
614: lp_ipyv_tbl := lx_ipyv_tbl;
615: --Assign value to OUT variables

Line 620: WHEN FND_API.G_EXC_ERROR THEN

616: x_msg_count := l_msg_count ;
617: x_msg_data := l_msg_data ;
618: x_return_status := l_return_status ;
619: EXCEPTION
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO ins_policies_validate;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618: x_return_status := l_return_status ;
619: EXCEPTION
620: WHEN FND_API.G_EXC_ERROR THEN
621: ROLLBACK TO ins_policies_validate;
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: x_msg_count := l_msg_count ;
624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.count_and_get(
626: p_count => x_msg_count

Line 628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

624: x_msg_data := l_msg_data ;
625: FND_MSG_PUB.count_and_get(
626: p_count => x_msg_count
627: ,p_data => x_msg_data);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO ins_policies_validate;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: x_msg_count := l_msg_count ;
632: x_msg_data := l_msg_data ;

Line 630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

626: p_count => x_msg_count
627: ,p_data => x_msg_data);
628: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO ins_policies_validate;
630: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
631: x_msg_count := l_msg_count ;
632: x_msg_data := l_msg_data ;
633: FND_MSG_PUB.count_and_get(
634: p_count => x_msg_count

Line 638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

634: p_count => x_msg_count
635: ,p_data => x_msg_data);
636: WHEN OTHERS THEN
637: ROLLBACK TO ins_policies_validate;
638: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
639: x_msg_count := l_msg_count ;
640: x_msg_data := l_msg_data ;
641: FND_MSG_PUB.ADD_EXC_MSG('OKL_INS_POLICIES_PUB','validate_ins_policies');
642: FND_MSG_PUB.count_and_get(