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

Line 24: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

20: l_sitv_rec sitv_rec_type;
21: l_data VARCHAR2(100);
22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_stream_types';
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_stream_types;
28: l_sitv_rec := p_sitv_rec;

Line 26: x_return_status := FND_API.G_RET_STS_SUCCESS;

22: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_stream_types';
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_stream_types;
28: l_sitv_rec := p_sitv_rec;
29:
30:

Line 42: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

38: ,p_sitv_rec => l_sitv_rec
39: ,x_sitv_rec => x_sitv_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;

Line 43: RAISE FND_API.G_EXC_ERROR;

39: ,x_sitv_rec => x_sitv_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:

Line 44: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 45: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 52: WHEN FND_API.G_EXC_ERROR THEN

48:
49:
50:
51: EXCEPTION
52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_stream_types;
54: x_return_status := FND_API.G_RET_STS_ERROR;
55:
56: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 54: x_return_status := FND_API.G_RET_STS_ERROR;

50:
51: EXCEPTION
52: WHEN FND_API.G_EXC_ERROR THEN
53: ROLLBACK TO insert_sif_stream_types;
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);

Line 60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 62: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

58: ,p_data => x_msg_data);
59:
60: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
61: ROLLBACK TO insert_sif_stream_types;
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:

Line 74: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
76:
77:
78: PROCEDURE insert_sif_stream_types(

Line 91: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

87: l_sitv_tbl sitv_tbl_type;
88: l_data VARCHAR2(100);
89: l_count NUMBER ;
90: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_stream_types';
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

Line 92: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

88: l_data VARCHAR2(100);
89: l_count NUMBER ;
90: l_api_name CONSTANT VARCHAR2(30) := 'insert_sif_stream_types';
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;

Line 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_stream_types;
98: l_sitv_tbl := p_sitv_tbl;
99:
100:

Line 117: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

113: ,x_sitv_rec => x_sitv_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;

Line 118: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

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_sitv_tbl.LAST);

Line 134: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 135: RAISE FND_API.G_EXC_ERROR;

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:

Line 136: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 143: WHEN FND_API.G_EXC_ERROR THEN

139:
140:
141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_stream_types;
145: x_return_status := FND_API.G_RET_STS_ERROR;
146:
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 145: x_return_status := FND_API.G_RET_STS_ERROR;

141:
142: EXCEPTION
143: WHEN FND_API.G_EXC_ERROR THEN
144: ROLLBACK TO insert_sif_stream_types;
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);

Line 151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

149: ,p_data => x_msg_data);
150:
151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
152: ROLLBACK TO insert_sif_stream_types;
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:

Line 165: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
167:
168: PROCEDURE lock_sif_stream_types(
169: p_api_version IN NUMBER

Line 178: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

174: ,p_sitv_rec IN sitv_rec_type
175: ) IS
176:
177: l_sitv_rec sitv_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_stream_types;

Line 181: x_return_status := FND_API.G_RET_STS_SUCCESS;

177: l_sitv_rec sitv_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_stream_types;
183: l_sitv_rec := p_sitv_rec;
184:
185: okl_sit_pvt.lock_row(

Line 194: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

190: ,x_msg_data => x_msg_data
191: ,p_sitv_rec => l_sitv_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;

Line 195: RAISE FND_API.G_EXC_ERROR;

191: ,p_sitv_rec => l_sitv_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:

Line 196: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 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_stream_types;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204:
205: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 203: x_return_status := FND_API.G_RET_STS_ERROR;

199:
200: EXCEPTION
201: WHEN FND_API.G_EXC_ERROR THEN
202: ROLLBACK TO lock_sif_stream_types;
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);

Line 209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

207: ,p_data => x_msg_data);
208:
209: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
210: ROLLBACK TO lock_sif_stream_types;
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:

Line 223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
225:
226: PROCEDURE lock_sif_stream_types(
227: p_api_version IN NUMBER

Line 235: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

231: ,x_msg_data OUT NOCOPY VARCHAR2
232: ,p_sitv_tbl IN sitv_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

Line 236: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

232: ,p_sitv_tbl IN sitv_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;

Line 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_stream_types;
242:
243: IF (p_sitv_tbl.COUNT > 0) THEN
244: i := p_sitv_tbl.FIRST;

Line 257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

253: ,p_sitv_rec => p_sitv_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;

Line 258: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

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_sitv_tbl.LAST);

Line 274: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 275: RAISE FND_API.G_EXC_ERROR;

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:

Line 276: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 277: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 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_stream_types;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284:
285: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279:
280: EXCEPTION
281: WHEN FND_API.G_EXC_ERROR THEN
282: ROLLBACK TO lock_sif_stream_types;
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);

Line 289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: ,p_data => x_msg_data);
288:
289: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
290: ROLLBACK TO lock_sif_stream_types;
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:

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
305:
306: PROCEDURE update_sif_stream_types(
307: p_api_version IN NUMBER

Line 319: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

315: l_sitv_rec sitv_rec_type;
316: l_data VARCHAR2(100);
317: l_count NUMBER ;
318: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_stream_types';
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_stream_types;
323: l_sitv_rec := p_sitv_rec;

Line 321: x_return_status := FND_API.G_RET_STS_SUCCESS;

317: l_count NUMBER ;
318: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_stream_types';
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_stream_types;
323: l_sitv_rec := p_sitv_rec;
324:
325:

Line 337: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

333: ,p_sitv_rec => l_sitv_rec
334: ,x_sitv_rec => x_sitv_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;

Line 338: RAISE FND_API.G_EXC_ERROR;

334: ,x_sitv_rec => x_sitv_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:

Line 339: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 346: WHEN FND_API.G_EXC_ERROR THEN

342:
343:
344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_stream_types;
348: x_return_status := FND_API.G_RET_STS_ERROR;
349:
350: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 348: x_return_status := FND_API.G_RET_STS_ERROR;

344:
345: EXCEPTION
346: WHEN FND_API.G_EXC_ERROR THEN
347: ROLLBACK TO update_sif_stream_types;
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);

Line 354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

352: ,p_data => x_msg_data);
353:
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_sif_stream_types;
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:

Line 368: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
370:
371:
372: PROCEDURE update_sif_stream_types(

Line 385: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

381: l_sitv_tbl sitv_tbl_type;
382: l_data VARCHAR2(100);
383: l_count NUMBER;
384: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_stream_types';
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

Line 386: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

382: l_data VARCHAR2(100);
383: l_count NUMBER;
384: l_api_name CONSTANT VARCHAR2(30) := 'update_sif_stream_types';
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;

Line 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_stream_types;
392: l_sitv_tbl := p_sitv_tbl;
393:
394:

Line 411: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

407: ,x_sitv_rec => x_sitv_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;

Line 412: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

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_sitv_tbl.LAST);

Line 428: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 429: RAISE FND_API.G_EXC_ERROR;

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:

Line 430: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 437: WHEN FND_API.G_EXC_ERROR THEN

433:
434:
435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_stream_types;
439: x_return_status := FND_API.G_RET_STS_ERROR;
440:
441: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 439: x_return_status := FND_API.G_RET_STS_ERROR;

435:
436: EXCEPTION
437: WHEN FND_API.G_EXC_ERROR THEN
438: ROLLBACK TO update_sif_stream_types;
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);

Line 445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

443: ,p_data => x_msg_data);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO update_sif_stream_types;
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:

Line 459: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
461:
462: PROCEDURE delete_sif_stream_types(
463: p_api_version IN NUMBER

Line 475: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

471: l_sitv_rec sitv_rec_type;
472: l_data VARCHAR2(100);
473: l_count NUMBER ;
474: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_stream_types';
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_stream_types;
479: l_sitv_rec := p_sitv_rec;

Line 477: x_return_status := FND_API.G_RET_STS_SUCCESS;

473: l_count NUMBER ;
474: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_stream_types';
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_stream_types;
479: l_sitv_rec := p_sitv_rec;
480:
481:

Line 492: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

488: ,x_msg_data => x_msg_data
489: ,p_sitv_rec => l_sitv_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;

Line 493: RAISE FND_API.G_EXC_ERROR;

489: ,p_sitv_rec => l_sitv_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:

Line 494: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 501: WHEN FND_API.G_EXC_ERROR THEN

497:
498:
499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_stream_types;
503: x_return_status := FND_API.G_RET_STS_ERROR;
504:
505: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 503: x_return_status := FND_API.G_RET_STS_ERROR;

499:
500: EXCEPTION
501: WHEN FND_API.G_EXC_ERROR THEN
502: ROLLBACK TO delete_sif_stream_types;
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);

Line 509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 511: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

507: ,p_data => x_msg_data);
508:
509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
510: ROLLBACK TO delete_sif_stream_types;
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:

Line 523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
525:
526:
527: PROCEDURE delete_sif_stream_types(

Line 540: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

536: l_sitv_tbl sitv_tbl_type;
537: l_data VARCHAR2(100);
538: l_count NUMBER ;
539: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_stream_types';
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

Line 541: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

537: l_data VARCHAR2(100);
538: l_count NUMBER ;
539: l_api_name CONSTANT VARCHAR2(30) := 'delete_sif_stream_types';
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;

Line 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_stream_types;
547: l_sitv_tbl := p_sitv_tbl;
548:
549:

Line 566: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

562: ,x_sitv_rec => x_sitv_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;

Line 567: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

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_sitv_tbl.LAST);

Line 583: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 584: RAISE FND_API.G_EXC_ERROR;

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:

Line 585: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 592: WHEN FND_API.G_EXC_ERROR THEN

588:
589:
590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_stream_types;
594: x_return_status := FND_API.G_RET_STS_ERROR;
595:
596: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 594: x_return_status := FND_API.G_RET_STS_ERROR;

590:
591: EXCEPTION
592: WHEN FND_API.G_EXC_ERROR THEN
593: ROLLBACK TO delete_sif_stream_types;
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);

Line 600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 602: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

598: ,p_data => x_msg_data);
599:
600: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
601: ROLLBACK TO delete_sif_stream_types;
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:

Line 614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
616:
617: PROCEDURE validate_sif_stream_types(
618: p_api_version IN NUMBER

Line 630: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

626: l_sitv_rec sitv_rec_type;
627: l_data VARCHAR2(100);
628: l_count NUMBER;
629: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_stream_types';
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_stream_types;
634: l_sitv_rec := p_sitv_rec;

Line 632: x_return_status := FND_API.G_RET_STS_SUCCESS;

628: l_count NUMBER;
629: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_stream_types';
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_stream_types;
634: l_sitv_rec := p_sitv_rec;
635:
636:

Line 647: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

643: ,x_msg_data => x_msg_data
644: ,p_sitv_rec => l_sitv_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;

Line 648: RAISE FND_API.G_EXC_ERROR;

644: ,p_sitv_rec => l_sitv_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:

Line 649: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 656: WHEN FND_API.G_EXC_ERROR THEN

652:
653:
654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_stream_types;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659:
660: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654:
655: EXCEPTION
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO validate_sif_stream_types;
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);

Line 664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

662: ,p_data => x_msg_data);
663:
664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
665: ROLLBACK TO validate_sif_stream_types;
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:

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
680:
681:
682: PROCEDURE validate_sif_stream_types(

Line 695: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

691: l_sitv_tbl sitv_tbl_type;
692: l_data VARCHAR2(100);
693: l_count NUMBER;
694: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_stream_types';
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

Line 696: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

692: l_data VARCHAR2(100);
693: l_count NUMBER;
694: l_api_name CONSTANT VARCHAR2(30) := 'validate_sif_stream_types';
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;

Line 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_stream_types;
702: l_sitv_tbl := p_sitv_tbl;
703:
704:

Line 721: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

717: ,x_sitv_rec => x_sitv_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;

Line 722: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

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_sitv_tbl.LAST);

Line 738: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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;

Line 739: RAISE FND_API.G_EXC_ERROR;

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:

Line 740: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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:

Line 741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:

Line 748: WHEN FND_API.G_EXC_ERROR THEN

744:
745:
746:
747: EXCEPTION
748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_stream_types;
750: x_return_status := FND_API.G_RET_STS_ERROR;
751:
752: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 750: x_return_status := FND_API.G_RET_STS_ERROR;

746:
747: EXCEPTION
748: WHEN FND_API.G_EXC_ERROR THEN
749: ROLLBACK TO validate_sif_stream_types;
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);

Line 756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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_stream_types;
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

Line 758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

754: ,p_data => x_msg_data);
755:
756: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
757: ROLLBACK TO validate_sif_stream_types;
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:

Line 770: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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_stream_types;
772:
773:
774: END OKL_SIF_stream_types_PUB;