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

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

19: l_psyv_rec psyv_rec_type;
20: l_data VARCHAR2(100);
21: l_api_name CONSTANT VARCHAR2(30) := 'insert_pdt_stys';
22: l_count NUMBER ;
23: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
24: BEGIN
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26: SAVEPOINT insert_pdt_stys;
27: l_psyv_rec := p_psyv_rec;

Line 25: x_return_status := FND_API.G_RET_STS_SUCCESS;

21: l_api_name CONSTANT VARCHAR2(30) := 'insert_pdt_stys';
22: l_count NUMBER ;
23: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
24: BEGIN
25: x_return_status := FND_API.G_RET_STS_SUCCESS;
26: SAVEPOINT insert_pdt_stys;
27: l_psyv_rec := p_psyv_rec;
28:
29:

Line 41: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

37: ,p_psyv_rec => l_psyv_rec
38: ,x_psyv_rec => x_psyv_rec
39: );
40:
41: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
42: RAISE FND_API.G_EXC_ERROR;
43: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;

Line 42: RAISE FND_API.G_EXC_ERROR;

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

Line 43: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

39: );
40:
41: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
42: RAISE FND_API.G_EXC_ERROR;
43: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47: /* re-assign local record structure using output record from pvt api */

Line 44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

40:
41: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
42: RAISE FND_API.G_EXC_ERROR;
43: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END IF;
46:
47: /* re-assign local record structure using output record from pvt api */
48: l_psyv_rec := x_psyv_rec;

Line 54: WHEN FND_API.G_EXC_ERROR THEN

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

Line 56: x_return_status := FND_API.G_RET_STS_ERROR;

52:
53: EXCEPTION
54: WHEN FND_API.G_EXC_ERROR THEN
55: ROLLBACK TO insert_pdt_stys;
56: x_return_status := FND_API.G_RET_STS_ERROR;
57:
58: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
59: ,p_count => x_msg_count
60: ,p_data => x_msg_data);

Line 62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

58: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
59: ,p_count => x_msg_count
60: ,p_data => x_msg_data);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO insert_pdt_stys;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
66: ,p_count => x_msg_count

Line 64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

60: ,p_data => x_msg_data);
61:
62: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
63: ROLLBACK TO insert_pdt_stys;
64: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
65: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
66: ,p_count => x_msg_count
67: ,p_data => x_msg_data);
68:

Line 76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

72: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
73: ,p_count => x_msg_count
74: ,p_data => x_msg_data);
75: -- notify caller of an UNEXPECTED error
76: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: END insert_pdt_stys;
78:
79:
80: PROCEDURE insert_pdt_stys(

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

89: l_psyv_tbl psyv_tbl_type;
90: l_data VARCHAR2(100);
91: l_count NUMBER ;
92: l_api_name CONSTANT VARCHAR2(30) := 'insert_pdt_stys';
93: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
94: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: i NUMBER;
96:
97: BEGIN

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

90: l_data VARCHAR2(100);
91: l_count NUMBER ;
92: l_api_name CONSTANT VARCHAR2(30) := 'insert_pdt_stys';
93: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
94: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: i NUMBER;
96:
97: BEGIN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 98: x_return_status := FND_API.G_RET_STS_SUCCESS;

94: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: i NUMBER;
96:
97: BEGIN
98: x_return_status := FND_API.G_RET_STS_SUCCESS;
99: SAVEPOINT insert_pdt_stys;
100: l_psyv_tbl := p_psyv_tbl;
101:
102:

Line 119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

115: ,x_psyv_rec => x_psyv_tbl(i)
116: );
117:
118: -- store the highest degree of error
119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
120: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
121: l_overall_status := x_return_status;
122: END IF;
123: END IF;

Line 120: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

116: );
117:
118: -- store the highest degree of error
119: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
120: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
121: l_overall_status := x_return_status;
122: END IF;
123: END IF;
124: EXIT WHEN (i = p_psyv_tbl.LAST);

Line 136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

132: END IF;
133:
134: l_return_status := x_return_status;
135:
136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;

Line 137: RAISE FND_API.G_EXC_ERROR;

133:
134: l_return_status := x_return_status;
135:
136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:

Line 138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

134: l_return_status := x_return_status;
135:
136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: /* re-assign local table structure using output table from pvt api */

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135:
136: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
137: RAISE FND_API.G_EXC_ERROR;
138: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: /* re-assign local table structure using output table from pvt api */
143: l_psyv_tbl := x_psyv_tbl;

Line 148: WHEN FND_API.G_EXC_ERROR THEN

144:
145:
146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO insert_pdt_stys;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 150: x_return_status := FND_API.G_RET_STS_ERROR;

146:
147: EXCEPTION
148: WHEN FND_API.G_EXC_ERROR THEN
149: ROLLBACK TO insert_pdt_stys;
150: x_return_status := FND_API.G_RET_STS_ERROR;
151:
152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
153: ,p_count => x_msg_count
154: ,p_data => x_msg_data);

Line 156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

152: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
153: ,p_count => x_msg_count
154: ,p_data => x_msg_data);
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO insert_pdt_stys;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
160: ,p_count => x_msg_count

Line 158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

154: ,p_data => x_msg_data);
155:
156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
157: ROLLBACK TO insert_pdt_stys;
158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
159: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
160: ,p_count => x_msg_count
161: ,p_data => x_msg_data);
162:

Line 170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

166: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
167: ,p_count => x_msg_count
168: ,p_data => x_msg_data);
169: -- notify caller of an UNEXPECTED error
170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
171: END insert_pdt_stys;
172:
173: PROCEDURE lock_pdt_stys(
174: p_api_version IN NUMBER

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

179: ,p_psyv_rec IN psyv_rec_type
180: ) IS
181:
182: l_psyv_rec psyv_rec_type;
183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
184:
185: BEGIN
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: SAVEPOINT lock_pdt_stys;

Line 186: x_return_status := FND_API.G_RET_STS_SUCCESS;

182: l_psyv_rec psyv_rec_type;
183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
184:
185: BEGIN
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
187: SAVEPOINT lock_pdt_stys;
188: l_psyv_rec := p_psyv_rec;
189:
190: okl_psy_pvt.lock_row(

Line 199: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

195: ,x_msg_data => x_msg_data
196: ,p_psyv_rec => l_psyv_rec
197: );
198:
199: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;

Line 200: RAISE FND_API.G_EXC_ERROR;

196: ,p_psyv_rec => l_psyv_rec
197: );
198:
199: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:

Line 201: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

197: );
198:
199: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: EXCEPTION

Line 202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

198:
199: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
200: RAISE FND_API.G_EXC_ERROR;
201: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN

Line 206: WHEN FND_API.G_EXC_ERROR THEN

202: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
203: END IF;
204:
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN
207: ROLLBACK TO lock_pdt_stys;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209:
210: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 208: x_return_status := FND_API.G_RET_STS_ERROR;

204:
205: EXCEPTION
206: WHEN FND_API.G_EXC_ERROR THEN
207: ROLLBACK TO lock_pdt_stys;
208: x_return_status := FND_API.G_RET_STS_ERROR;
209:
210: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
211: ,p_count => x_msg_count
212: ,p_data => x_msg_data);

Line 214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

210: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
211: ,p_count => x_msg_count
212: ,p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO lock_pdt_stys;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
218: ,p_count => x_msg_count

Line 216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

212: ,p_data => x_msg_data);
213:
214: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
215: ROLLBACK TO lock_pdt_stys;
216: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
217: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
218: ,p_count => x_msg_count
219: ,p_data => x_msg_data);
220:

Line 228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

224: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
225: ,p_count => x_msg_count
226: ,p_data => x_msg_data);
227: -- notify caller of an UNEXPECTED error
228: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
229: END lock_pdt_stys;
230:
231: PROCEDURE lock_pdt_stys(
232: p_api_version IN NUMBER

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

236: ,x_msg_data OUT NOCOPY VARCHAR2
237: ,p_psyv_tbl IN psyv_tbl_type
238: ) IS
239:
240: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
241: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: i NUMBER;
243:
244: BEGIN

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

237: ,p_psyv_tbl IN psyv_tbl_type
238: ) IS
239:
240: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
241: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: i NUMBER;
243:
244: BEGIN
245: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 245: x_return_status := FND_API.G_RET_STS_SUCCESS;

241: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
242: i NUMBER;
243:
244: BEGIN
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: SAVEPOINT lock_pdt_stys;
247:
248: IF (p_psyv_tbl.COUNT > 0) THEN
249: i := p_psyv_tbl.FIRST;

Line 262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

258: ,p_psyv_rec => p_psyv_tbl(i)
259: );
260:
261: -- store the highest degree of error
262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
264: l_overall_status := x_return_status;
265: END IF;
266: END IF;

Line 263: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

259: );
260:
261: -- store the highest degree of error
262: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
263: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
264: l_overall_status := x_return_status;
265: END IF;
266: END IF;
267: EXIT WHEN (i = p_psyv_tbl.LAST);

Line 279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

275: END IF;
276:
277: l_return_status := x_return_status;
278:
279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;

Line 280: RAISE FND_API.G_EXC_ERROR;

276:
277: l_return_status := x_return_status;
278:
279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:

Line 281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

277: l_return_status := x_return_status;
278:
279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: EXCEPTION

Line 282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

278:
279: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
280: RAISE FND_API.G_EXC_ERROR;
281: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN

Line 286: WHEN FND_API.G_EXC_ERROR THEN

282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
283: END IF;
284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: ROLLBACK TO lock_pdt_stys;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289:
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 288: x_return_status := FND_API.G_RET_STS_ERROR;

284:
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: ROLLBACK TO lock_pdt_stys;
288: x_return_status := FND_API.G_RET_STS_ERROR;
289:
290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);

Line 294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

290: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
291: ,p_count => x_msg_count
292: ,p_data => x_msg_data);
293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO lock_pdt_stys;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
298: ,p_count => x_msg_count

Line 296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

292: ,p_data => x_msg_data);
293:
294: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
295: ROLLBACK TO lock_pdt_stys;
296: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
297: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
298: ,p_count => x_msg_count
299: ,p_data => x_msg_data);
300:

Line 308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

304: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
305: ,p_count => x_msg_count
306: ,p_data => x_msg_data);
307: -- notify caller of an UNEXPECTED error
308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
309: END lock_pdt_stys;
310:
311: PROCEDURE update_pdt_stys(
312: p_api_version IN NUMBER

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

320: l_psyv_rec psyv_rec_type;
321: l_data VARCHAR2(100);
322: l_count NUMBER ;
323: l_api_name CONSTANT VARCHAR2(30) := 'update_pdt_stys';
324: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
325: BEGIN
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: SAVEPOINT update_pdt_stys;
328: l_psyv_rec := p_psyv_rec;

Line 326: x_return_status := FND_API.G_RET_STS_SUCCESS;

322: l_count NUMBER ;
323: l_api_name CONSTANT VARCHAR2(30) := 'update_pdt_stys';
324: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
325: BEGIN
326: x_return_status := FND_API.G_RET_STS_SUCCESS;
327: SAVEPOINT update_pdt_stys;
328: l_psyv_rec := p_psyv_rec;
329:
330:

Line 342: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

338: ,p_psyv_rec => l_psyv_rec
339: ,x_psyv_rec => x_psyv_rec
340: );
341:
342: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;

Line 343: RAISE FND_API.G_EXC_ERROR;

339: ,x_psyv_rec => x_psyv_rec
340: );
341:
342: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347:

Line 344: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

340: );
341:
342: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347:
348: /* re-assign local record structure using output record from pvt api */

Line 345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

341:
342: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
345: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
346: END IF;
347:
348: /* re-assign local record structure using output record from pvt api */
349: l_psyv_rec := x_psyv_rec;

Line 354: WHEN FND_API.G_EXC_ERROR THEN

350:
351:
352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO update_pdt_stys;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357:
358: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 356: x_return_status := FND_API.G_RET_STS_ERROR;

352:
353: EXCEPTION
354: WHEN FND_API.G_EXC_ERROR THEN
355: ROLLBACK TO update_pdt_stys;
356: x_return_status := FND_API.G_RET_STS_ERROR;
357:
358: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);

Line 362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

358: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
359: ,p_count => x_msg_count
360: ,p_data => x_msg_data);
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO update_pdt_stys;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: ,p_data => x_msg_data);
361:
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: ROLLBACK TO update_pdt_stys;
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
366: ,p_count => x_msg_count
367: ,p_data => x_msg_data);
368:

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
373: ,p_count => x_msg_count
374: ,p_data => x_msg_data);
375: -- notify caller of an UNEXPECTED error
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377: END update_pdt_stys;
378:
379:
380: PROCEDURE update_pdt_stys(

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

389: l_psyv_tbl psyv_tbl_type;
390: l_data VARCHAR2(100);
391: l_count NUMBER;
392: l_api_name CONSTANT VARCHAR2(30) := 'update_pdt_stys';
393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
394: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
395: i NUMBER;
396:
397: BEGIN

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

390: l_data VARCHAR2(100);
391: l_count NUMBER;
392: l_api_name CONSTANT VARCHAR2(30) := 'update_pdt_stys';
393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
394: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
395: i NUMBER;
396:
397: BEGIN
398: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 398: x_return_status := FND_API.G_RET_STS_SUCCESS;

394: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
395: i NUMBER;
396:
397: BEGIN
398: x_return_status := FND_API.G_RET_STS_SUCCESS;
399: SAVEPOINT update_pdt_stys;
400: l_psyv_tbl := p_psyv_tbl;
401:
402:

Line 419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

415: ,x_psyv_rec => x_psyv_tbl(i)
416: );
417:
418: -- store the highest degree of error
419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
420: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
421: l_overall_status := x_return_status;
422: END IF;
423: END IF;

Line 420: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

416: );
417:
418: -- store the highest degree of error
419: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
420: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
421: l_overall_status := x_return_status;
422: END IF;
423: END IF;
424: EXIT WHEN (i = p_psyv_tbl.LAST);

Line 436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

432: END IF;
433:
434: l_return_status := x_return_status;
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;

Line 437: RAISE FND_API.G_EXC_ERROR;

433:
434: l_return_status := x_return_status;
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:

Line 438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

434: l_return_status := x_return_status;
435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: /* re-assign local table structure using output table from pvt api */

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435:
436: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
437: RAISE FND_API.G_EXC_ERROR;
438: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: END IF;
441:
442: /* re-assign local table structure using output table from pvt api */
443: l_psyv_tbl := x_psyv_tbl;

Line 448: WHEN FND_API.G_EXC_ERROR THEN

444:
445:
446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: ROLLBACK TO update_pdt_stys;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451:
452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 450: x_return_status := FND_API.G_RET_STS_ERROR;

446:
447: EXCEPTION
448: WHEN FND_API.G_EXC_ERROR THEN
449: ROLLBACK TO update_pdt_stys;
450: x_return_status := FND_API.G_RET_STS_ERROR;
451:
452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
453: ,p_count => x_msg_count
454: ,p_data => x_msg_data);

Line 456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

452: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
453: ,p_count => x_msg_count
454: ,p_data => x_msg_data);
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: ROLLBACK TO update_pdt_stys;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
460: ,p_count => x_msg_count

Line 458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

454: ,p_data => x_msg_data);
455:
456: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
457: ROLLBACK TO update_pdt_stys;
458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
459: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
460: ,p_count => x_msg_count
461: ,p_data => x_msg_data);
462:

Line 470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

466: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
467: ,p_count => x_msg_count
468: ,p_data => x_msg_data);
469: -- notify caller of an UNEXPECTED error
470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
471: END update_pdt_stys;
472:
473: PROCEDURE delete_pdt_stys(
474: p_api_version IN NUMBER

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

481: l_psyv_rec psyv_rec_type;
482: l_data VARCHAR2(100);
483: l_count NUMBER ;
484: l_api_name CONSTANT VARCHAR2(30) := 'delete_pdt_stys';
485: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
486: BEGIN
487: x_return_status := FND_API.G_RET_STS_SUCCESS;
488: SAVEPOINT delete_pdt_stys;
489: l_psyv_rec := p_psyv_rec;

Line 487: x_return_status := FND_API.G_RET_STS_SUCCESS;

483: l_count NUMBER ;
484: l_api_name CONSTANT VARCHAR2(30) := 'delete_pdt_stys';
485: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
486: BEGIN
487: x_return_status := FND_API.G_RET_STS_SUCCESS;
488: SAVEPOINT delete_pdt_stys;
489: l_psyv_rec := p_psyv_rec;
490:
491:

Line 502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

498: ,x_msg_data => x_msg_data
499: ,p_psyv_rec => l_psyv_rec
500: );
501:
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;

Line 503: RAISE FND_API.G_EXC_ERROR;

499: ,p_psyv_rec => l_psyv_rec
500: );
501:
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:

Line 504: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

500: );
501:
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508:

Line 505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

501:
502: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
503: RAISE FND_API.G_EXC_ERROR;
504: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
505: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
506: END IF;
507:
508:
509:

Line 511: WHEN FND_API.G_EXC_ERROR THEN

507:
508:
509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO delete_pdt_stys;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514:
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 513: x_return_status := FND_API.G_RET_STS_ERROR;

509:
510: EXCEPTION
511: WHEN FND_API.G_EXC_ERROR THEN
512: ROLLBACK TO delete_pdt_stys;
513: x_return_status := FND_API.G_RET_STS_ERROR;
514:
515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);

Line 519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

515: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
516: ,p_count => x_msg_count
517: ,p_data => x_msg_data);
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO delete_pdt_stys;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count

Line 521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

517: ,p_data => x_msg_data);
518:
519: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
520: ROLLBACK TO delete_pdt_stys;
521: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
522: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
523: ,p_count => x_msg_count
524: ,p_data => x_msg_data);
525:

Line 533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

529: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
530: ,p_count => x_msg_count
531: ,p_data => x_msg_data);
532: -- notify caller of an UNEXPECTED error
533: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
534: END delete_pdt_stys;
535:
536:
537: PROCEDURE delete_pdt_stys(

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

545: l_psyv_tbl psyv_tbl_type;
546: l_data VARCHAR2(100);
547: l_count NUMBER ;
548: l_api_name CONSTANT VARCHAR2(30) := 'delete_pdt_stys';
549: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
550: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: i NUMBER;
552:
553: BEGIN

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

546: l_data VARCHAR2(100);
547: l_count NUMBER ;
548: l_api_name CONSTANT VARCHAR2(30) := 'delete_pdt_stys';
549: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
550: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: i NUMBER;
552:
553: BEGIN
554: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 554: x_return_status := FND_API.G_RET_STS_SUCCESS;

550: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
551: i NUMBER;
552:
553: BEGIN
554: x_return_status := FND_API.G_RET_STS_SUCCESS;
555: SAVEPOINT delete_pdt_stys;
556: l_psyv_tbl := p_psyv_tbl;
557:
558:

Line 574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

570: ,p_psyv_rec => p_psyv_tbl(i)
571: );
572:
573: -- store the highest degree of error
574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
575: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
576: l_overall_status := x_return_status;
577: END IF;
578: END IF;

Line 575: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

571: );
572:
573: -- store the highest degree of error
574: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
575: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
576: l_overall_status := x_return_status;
577: END IF;
578: END IF;
579: EXIT WHEN (i = p_psyv_tbl.LAST);

Line 591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

587: END IF;
588:
589: l_return_status := x_return_status;
590:
591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;

Line 592: RAISE FND_API.G_EXC_ERROR;

588:
589: l_return_status := x_return_status;
590:
591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:

Line 593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

589: l_return_status := x_return_status;
590:
591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:
597:

Line 594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

590:
591: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
594: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
595: END IF;
596:
597:
598:

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596:
597:
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: ROLLBACK TO delete_pdt_stys;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603:
604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 602: x_return_status := FND_API.G_RET_STS_ERROR;

598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: ROLLBACK TO delete_pdt_stys;
602: x_return_status := FND_API.G_RET_STS_ERROR;
603:
604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);

Line 608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

604: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
605: ,p_count => x_msg_count
606: ,p_data => x_msg_data);
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_pdt_stys;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count

Line 610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

606: ,p_data => x_msg_data);
607:
608: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
609: ROLLBACK TO delete_pdt_stys;
610: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
611: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
612: ,p_count => x_msg_count
613: ,p_data => x_msg_data);
614:

Line 622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

618: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
619: ,p_count => x_msg_count
620: ,p_data => x_msg_data);
621: -- notify caller of an UNEXPECTED error
622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
623: END delete_pdt_stys;
624:
625: PROCEDURE validate_pdt_stys(
626: p_api_version IN NUMBER

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

633: l_psyv_rec psyv_rec_type;
634: l_data VARCHAR2(100);
635: l_count NUMBER;
636: l_api_name CONSTANT VARCHAR2(30) := 'validate_pdt_stys';
637: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
638: BEGIN
639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640: SAVEPOINT validate_pdt_stys;
641: l_psyv_rec := p_psyv_rec;

Line 639: x_return_status := FND_API.G_RET_STS_SUCCESS;

635: l_count NUMBER;
636: l_api_name CONSTANT VARCHAR2(30) := 'validate_pdt_stys';
637: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
638: BEGIN
639: x_return_status := FND_API.G_RET_STS_SUCCESS;
640: SAVEPOINT validate_pdt_stys;
641: l_psyv_rec := p_psyv_rec;
642:
643:

Line 654: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

650: ,x_msg_data => x_msg_data
651: ,p_psyv_rec => l_psyv_rec
652: );
653:
654: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;

Line 655: RAISE FND_API.G_EXC_ERROR;

651: ,p_psyv_rec => l_psyv_rec
652: );
653:
654: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:

Line 656: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

652: );
653:
654: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:
660:

Line 657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

653:
654: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
657: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
658: END IF;
659:
660:
661:

Line 663: WHEN FND_API.G_EXC_ERROR THEN

659:
660:
661:
662: EXCEPTION
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO validate_pdt_stys;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666:
667: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 665: x_return_status := FND_API.G_RET_STS_ERROR;

661:
662: EXCEPTION
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO validate_pdt_stys;
665: x_return_status := FND_API.G_RET_STS_ERROR;
666:
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);

Line 671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ROLLBACK TO validate_pdt_stys;
673: 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

Line 673: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

669: ,p_data => x_msg_data);
670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ROLLBACK TO validate_pdt_stys;
673: 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:

Line 685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

681: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
682: ,p_count => x_msg_count
683: ,p_data => x_msg_data);
684: -- notify caller of an UNEXPECTED error
685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
686: END validate_pdt_stys;
687:
688:
689: PROCEDURE validate_pdt_stys(

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

697: l_psyv_tbl psyv_tbl_type;
698: l_data VARCHAR2(100);
699: l_count NUMBER;
700: l_api_name CONSTANT VARCHAR2(30) := 'validate_pdt_stys';
701: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
702: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
703: i NUMBER;
704:
705: BEGIN

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

698: l_data VARCHAR2(100);
699: l_count NUMBER;
700: l_api_name CONSTANT VARCHAR2(30) := 'validate_pdt_stys';
701: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
702: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
703: i NUMBER;
704:
705: BEGIN
706: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 706: x_return_status := FND_API.G_RET_STS_SUCCESS;

702: l_overall_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
703: i NUMBER;
704:
705: BEGIN
706: x_return_status := FND_API.G_RET_STS_SUCCESS;
707: SAVEPOINT validate_pdt_stys;
708: l_psyv_tbl := p_psyv_tbl;
709:
710:

Line 726: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

722: ,p_psyv_rec => p_psyv_tbl(i)
723: );
724:
725: -- store the highest degree of error
726: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
727: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
728: l_overall_status := x_return_status;
729: END IF;
730: END IF;

Line 727: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN

723: );
724:
725: -- store the highest degree of error
726: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
727: IF l_overall_status <> FND_API.G_RET_STS_UNEXP_ERROR THEN
728: l_overall_status := x_return_status;
729: END IF;
730: END IF;
731: EXIT WHEN (i = p_psyv_tbl.LAST);

Line 743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

739: END IF;
740:
741: l_return_status := x_return_status;
742:
743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;

Line 744: RAISE FND_API.G_EXC_ERROR;

740:
741: l_return_status := x_return_status;
742:
743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:

Line 745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

741: l_return_status := x_return_status;
742:
743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749:

Line 746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

742:
743: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
744: RAISE FND_API.G_EXC_ERROR;
745: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
747: END IF;
748:
749:
750:

Line 753: WHEN FND_API.G_EXC_ERROR THEN

749:
750:
751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO validate_pdt_stys;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756:
757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE

Line 755: x_return_status := FND_API.G_RET_STS_ERROR;

751:
752: EXCEPTION
753: WHEN FND_API.G_EXC_ERROR THEN
754: ROLLBACK TO validate_pdt_stys;
755: x_return_status := FND_API.G_RET_STS_ERROR;
756:
757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data);

Line 761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

757: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data);
760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO validate_pdt_stys;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
765: ,p_count => x_msg_count

Line 763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

759: ,p_data => x_msg_data);
760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO validate_pdt_stys;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
765: ,p_count => x_msg_count
766: ,p_data => x_msg_data);
767:

Line 775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

771: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
772: ,p_count => x_msg_count
773: ,p_data => x_msg_data);
774: -- notify caller of an UNEXPECTED error
775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
776: END validate_pdt_stys;
777:
778:
779: END OKL_PDT_STYS_PUB;