20: l_silv_rec silv_rec_type;
21: l_data VARCHAR2(100);
22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_lines';
23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: SAVEPOINT insert_sif_lines;
28: l_silv_rec := p_silv_rec;
22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_lines';
23: l_count NUMBER ;
24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
25: BEGIN
26: x_return_status := FND_API.G_RET_STS_SUCCESS;
27: SAVEPOINT insert_sif_lines;
28: l_silv_rec := p_silv_rec;
29:
30:
38: ,p_silv_rec => l_silv_rec
39: ,x_silv_rec => x_silv_rec
40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
39: ,x_silv_rec => x_silv_rec
40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
40: );
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48:
41:
42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
43: RAISE FND_API.G_EXC_ERROR;
44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
46: END IF;
47:
48:
49:
48:
49:
50:
51: EXCEPTION
52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_lines;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
50:
51: EXCEPTION
52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_lines;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
57: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_lines;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
63: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
64: ,p_count => x_msg_count
58: ,p_data => x_msg_data);
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_lines;
62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
63: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
73: -- notify caller of an UNEXPECTED error
74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
75: END insert_sif_lines;
76:
77:
78: PROCEDURE insert_sif_lines(
87: l_silv_tbl silv_tbl_type;
88: l_data VARCHAR2(100);
89: l_count NUMBER ;
90: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_lines';
91: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
92: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
93: i NUMBER;
94:
95: BEGIN
88: l_data VARCHAR2(100);
89: l_count NUMBER ;
90: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_lines';
91: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
92: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
93: i NUMBER;
94:
95: BEGIN
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
92: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
93: i NUMBER;
94:
95: BEGIN
96: x_return_status := FND_API.G_RET_STS_SUCCESS;
97: SAVEPOINT insert_sif_lines;
98: l_silv_tbl := p_silv_tbl;
99:
100:
113: ,x_silv_rec => x_silv_tbl(i)
114: );
115:
116: -- store the highest degree of error
117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
118: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
119: l_overall_status := x_return_status;
120: END IF;
121: END IF;
114: );
115:
116: -- store the highest degree of error
117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
118: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
119: l_overall_status := x_return_status;
120: END IF;
121: END IF;
122: EXIT WHEN (i = p_silv_tbl.LAST);
130: END IF;
131:
132: l_return_status := x_return_status;
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
131:
132: l_return_status := x_return_status;
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
132: l_return_status := x_return_status;
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
140:
133:
134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
135: RAISE FND_API.G_EXC_ERROR;
136: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
138: END IF;
139:
140:
141:
139:
140:
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_lines;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_lines;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
148: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_sif_lines;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
155: ,p_count => x_msg_count
149: ,p_data => x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_sif_lines;
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
154: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
166: END insert_sif_lines;
167:
168: PROCEDURE lock_sif_lines(
169: p_api_version IN NUMBER
174: ,p_silv_rec IN silv_rec_type
175: ) IS
176:
177: l_silv_rec silv_rec_type;
178: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
179:
180: BEGIN
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: SAVEPOINT lock_sif_lines;
177: l_silv_rec silv_rec_type;
178: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
179:
180: BEGIN
181: x_return_status := FND_API.G_RET_STS_SUCCESS;
182: SAVEPOINT lock_sif_lines;
183: l_silv_rec := p_silv_rec;
184:
185: okl_sil_pvt.lock_row(
190: ,x_msg_data => x_msg_data
191: ,p_silv_rec => l_silv_rec
192: );
193:
194: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
191: ,p_silv_rec => l_silv_rec
192: );
193:
194: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
192: );
193:
194: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: EXCEPTION
193:
194: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
195: RAISE FND_API.G_EXC_ERROR;
196: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_lines;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_lines;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
206: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
206: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_lines;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
213: ,p_count => x_msg_count
207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_lines;
211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
212: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
222: -- notify caller of an UNEXPECTED error
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: END lock_sif_lines;
225:
226: PROCEDURE lock_sif_lines(
227: p_api_version IN NUMBER
231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,p_silv_tbl IN silv_tbl_type
233: ) IS
234:
235: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
237: i NUMBER;
238:
239: BEGIN
232: ,p_silv_tbl IN silv_tbl_type
233: ) IS
234:
235: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
237: i NUMBER;
238:
239: BEGIN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
237: i NUMBER;
238:
239: BEGIN
240: x_return_status := FND_API.G_RET_STS_SUCCESS;
241: SAVEPOINT lock_sif_lines;
242:
243: IF (p_silv_tbl.COUNT > 0) THEN
244: i := p_silv_tbl.FIRST;
253: ,p_silv_rec => p_silv_tbl(i)
254: );
255:
256: -- store the highest degree of error
257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
259: l_overall_status := x_return_status;
260: END IF;
261: END IF;
254: );
255:
256: -- store the highest degree of error
257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
258: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
259: l_overall_status := x_return_status;
260: END IF;
261: END IF;
262: EXIT WHEN (i = p_silv_tbl.LAST);
270: END IF;
271:
272: l_return_status := x_return_status;
273:
274: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
275: RAISE FND_API.G_EXC_ERROR;
276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
271:
272: l_return_status := x_return_status;
273:
274: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
275: RAISE FND_API.G_EXC_ERROR;
276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
272: l_return_status := x_return_status;
273:
274: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
275: RAISE FND_API.G_EXC_ERROR;
276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
280: EXCEPTION
273:
274: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
275: RAISE FND_API.G_EXC_ERROR;
276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
278: END IF;
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_lines;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_lines;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
286: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_lines;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
293: ,p_count => x_msg_count
287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_lines;
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
302: -- notify caller of an UNEXPECTED error
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: END lock_sif_lines;
305:
306: PROCEDURE update_sif_lines(
307: p_api_version IN NUMBER
315: l_silv_rec silv_rec_type;
316: l_data VARCHAR2(100);
317: l_count NUMBER ;
318: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_lines';
319: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
320: BEGIN
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: SAVEPOINT update_sif_lines;
323: l_silv_rec := p_silv_rec;
317: l_count NUMBER ;
318: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_lines';
319: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
320: BEGIN
321: x_return_status := FND_API.G_RET_STS_SUCCESS;
322: SAVEPOINT update_sif_lines;
323: l_silv_rec := p_silv_rec;
324:
325:
333: ,p_silv_rec => l_silv_rec
334: ,x_silv_rec => x_silv_rec
335: );
336:
337: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
334: ,x_silv_rec => x_silv_rec
335: );
336:
337: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
335: );
336:
337: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343:
336:
337: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
338: RAISE FND_API.G_EXC_ERROR;
339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END IF;
342:
343:
344:
342:
343:
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_lines;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_lines;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
351: ,p_count => x_msg_count
352: ,p_data => x_msg_data);
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
351: ,p_count => x_msg_count
352: ,p_data => x_msg_data);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_sif_lines;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
358: ,p_count => x_msg_count
352: ,p_data => x_msg_data);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_sif_lines;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
357: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
358: ,p_count => x_msg_count
359: ,p_data => x_msg_data);
360:
364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
365: ,p_count => x_msg_count
366: ,p_data => x_msg_data);
367: -- notify caller of an UNEXPECTED error
368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
369: END update_sif_lines;
370:
371:
372: PROCEDURE update_sif_lines(
381: l_silv_tbl silv_tbl_type;
382: l_data VARCHAR2(100);
383: l_count NUMBER;
384: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_lines';
385: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
386: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
387: i NUMBER;
388:
389: BEGIN
382: l_data VARCHAR2(100);
383: l_count NUMBER;
384: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_lines';
385: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
386: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
387: i NUMBER;
388:
389: BEGIN
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
386: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
387: i NUMBER;
388:
389: BEGIN
390: x_return_status := FND_API.G_RET_STS_SUCCESS;
391: SAVEPOINT update_sif_lines;
392: l_silv_tbl := p_silv_tbl;
393:
394:
407: ,x_silv_rec => x_silv_tbl(i)
408: );
409:
410: -- store the highest degree of error
411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
412: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
413: l_overall_status := x_return_status;
414: END IF;
415: END IF;
408: );
409:
410: -- store the highest degree of error
411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
412: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
413: l_overall_status := x_return_status;
414: END IF;
415: END IF;
416: EXIT WHEN (i = p_silv_tbl.LAST);
424: END IF;
425:
426: l_return_status := x_return_status;
427:
428: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
425:
426: l_return_status := x_return_status;
427:
428: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433:
426: l_return_status := x_return_status;
427:
428: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433:
434:
427:
428: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
429: RAISE FND_API.G_EXC_ERROR;
430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
432: END IF;
433:
434:
435:
433:
434:
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_lines;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_lines;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
442: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO update_sif_lines;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
449: ,p_count => x_msg_count
443: ,p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO update_sif_lines;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
449: ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451:
455: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data);
458: -- notify caller of an UNEXPECTED error
459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
460: END update_sif_lines;
461:
462: PROCEDURE delete_sif_lines(
463: p_api_version IN NUMBER
471: l_silv_rec silv_rec_type;
472: l_data VARCHAR2(100);
473: l_count NUMBER ;
474: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_lines';
475: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
476: BEGIN
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478: SAVEPOINT delete_sif_lines;
479: l_silv_rec := p_silv_rec;
473: l_count NUMBER ;
474: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_lines';
475: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
476: BEGIN
477: x_return_status := FND_API.G_RET_STS_SUCCESS;
478: SAVEPOINT delete_sif_lines;
479: l_silv_rec := p_silv_rec;
480:
481:
488: ,x_msg_data => x_msg_data
489: ,p_silv_rec => l_silv_rec
490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
489: ,p_silv_rec => l_silv_rec
490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
490: );
491:
492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498:
491:
492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
493: RAISE FND_API.G_EXC_ERROR;
494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: END IF;
497:
498:
499:
497:
498:
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_lines;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504:
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_lines;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504:
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
506: ,p_count => x_msg_count
507: ,p_data => x_msg_data);
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
506: ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO delete_sif_lines;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
513: ,p_count => x_msg_count
507: ,p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO delete_sif_lines;
511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
512: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515:
519: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
520: ,p_count => x_msg_count
521: ,p_data => x_msg_data);
522: -- notify caller of an UNEXPECTED error
523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524: END delete_sif_lines;
525:
526:
527: PROCEDURE delete_sif_lines(
536: l_silv_tbl silv_tbl_type;
537: l_data VARCHAR2(100);
538: l_count NUMBER ;
539: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_lines';
540: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
541: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
542: i NUMBER;
543:
544: BEGIN
537: l_data VARCHAR2(100);
538: l_count NUMBER ;
539: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_lines';
540: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
541: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
542: i NUMBER;
543:
544: BEGIN
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
541: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
542: i NUMBER;
543:
544: BEGIN
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546: SAVEPOINT delete_sif_lines;
547: l_silv_tbl := p_silv_tbl;
548:
549:
562: ,x_silv_rec => x_silv_tbl(i)
563: );
564:
565: -- store the highest degree of error
566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
567: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
568: l_overall_status := x_return_status;
569: END IF;
570: END IF;
563: );
564:
565: -- store the highest degree of error
566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
567: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
568: l_overall_status := x_return_status;
569: END IF;
570: END IF;
571: EXIT WHEN (i = p_silv_tbl.LAST);
579: END IF;
580:
581: l_return_status := x_return_status;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
580:
581: l_return_status := x_return_status;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
581: l_return_status := x_return_status;
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589:
582:
583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
584: RAISE FND_API.G_EXC_ERROR;
585: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
587: END IF;
588:
589:
590:
588:
589:
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_lines;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595:
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_lines;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595:
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
597: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO delete_sif_lines;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
604: ,p_count => x_msg_count
598: ,p_data => x_msg_data);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO delete_sif_lines;
602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
603: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
604: ,p_count => x_msg_count
605: ,p_data => x_msg_data);
606:
610: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
611: ,p_count => x_msg_count
612: ,p_data => x_msg_data);
613: -- notify caller of an UNEXPECTED error
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: END delete_sif_lines;
616:
617: PROCEDURE validate_sif_lines(
618: p_api_version IN NUMBER
626: l_silv_rec silv_rec_type;
627: l_data VARCHAR2(100);
628: l_count NUMBER;
629: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_lines';
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
631: BEGIN
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633: SAVEPOINT validate_sif_lines;
634: l_silv_rec := p_silv_rec;
628: l_count NUMBER;
629: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_lines';
630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
631: BEGIN
632: x_return_status := FND_API.G_RET_STS_SUCCESS;
633: SAVEPOINT validate_sif_lines;
634: l_silv_rec := p_silv_rec;
635:
636:
643: ,x_msg_data => x_msg_data
644: ,p_silv_rec => l_silv_rec
645: );
646:
647: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
648: RAISE FND_API.G_EXC_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
644: ,p_silv_rec => l_silv_rec
645: );
646:
647: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
648: RAISE FND_API.G_EXC_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
645: );
646:
647: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
648: RAISE FND_API.G_EXC_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653:
646:
647: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
648: RAISE FND_API.G_EXC_ERROR;
649: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653:
654:
652:
653:
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_lines;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_lines;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
661: ,p_count => x_msg_count
662: ,p_data => x_msg_data);
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
661: ,p_count => x_msg_count
662: ,p_data => x_msg_data);
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO validate_sif_lines;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
668: ,p_count => x_msg_count
662: ,p_data => x_msg_data);
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO validate_sif_lines;
666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
668: ,p_count => x_msg_count
669: ,p_data => x_msg_data);
670:
674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
677: -- notify caller of an UNEXPECTED error
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: END validate_sif_lines;
680:
681:
682: PROCEDURE validate_sif_lines(
691: l_silv_tbl silv_tbl_type;
692: l_data VARCHAR2(100);
693: l_count NUMBER;
694: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_lines';
695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
696: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
697: i NUMBER;
698:
699: BEGIN
692: l_data VARCHAR2(100);
693: l_count NUMBER;
694: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_lines';
695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
696: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
697: i NUMBER;
698:
699: BEGIN
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
696: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
697: i NUMBER;
698:
699: BEGIN
700: x_return_status := FND_API.G_RET_STS_SUCCESS;
701: SAVEPOINT validate_sif_lines;
702: l_silv_tbl := p_silv_tbl;
703:
704:
717: ,x_silv_rec => x_silv_tbl(i)
718: );
719:
720: -- store the highest degree of error
721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
723: l_overall_status := x_return_status;
724: END IF;
725: END IF;
718: );
719:
720: -- store the highest degree of error
721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
722: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
723: l_overall_status := x_return_status;
724: END IF;
725: END IF;
726: EXIT WHEN (i = p_silv_tbl.LAST);
734: END IF;
735:
736: l_return_status := x_return_status;
737:
738: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
739: RAISE FND_API.G_EXC_ERROR;
740: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
735:
736: l_return_status := x_return_status;
737:
738: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
739: RAISE FND_API.G_EXC_ERROR;
740: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
736: l_return_status := x_return_status;
737:
738: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
739: RAISE FND_API.G_EXC_ERROR;
740: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744:
737:
738: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
739: RAISE FND_API.G_EXC_ERROR;
740: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743:
744:
745:
744:
745:
746:
747: EXCEPTION
748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_lines;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
746:
747: EXCEPTION
748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_lines;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
753: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO validate_sif_lines;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
760: ,p_count => x_msg_count
754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO validate_sif_lines;
758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
759: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
769: -- notify caller of an UNEXPECTED error
770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
771: END validate_sif_lines;
772:
773:
774: END OKL_SIF_LINES_PUB;