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

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

14: x_msg_data OUT NOCOPY VARCHAR2,
15: x_no_data_found OUT NOCOPY BOOLEAN,
16: x_pqvv_rec OUT NOCOPY pqvv_rec_type) IS
17: l_pqvv_rec pqvv_rec_type;
18: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
19: l_no_data_found BOOLEAN;
20: BEGIN
21:
22: l_pqvv_rec := p_pqvv_rec;

Line 23: x_return_status := FND_API.G_RET_STS_SUCCESS;

19: l_no_data_found BOOLEAN;
20: BEGIN
21:
22: l_pqvv_rec := p_pqvv_rec;
23: x_return_status := FND_API.G_RET_STS_SUCCESS;
24: x_no_data_found := TRUE;
25:
26: -- Start of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.get_rec
27: IF(L_DEBUG_ENABLED='Y') THEN

Line 47: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

43: END;
44: END IF;
45: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.get_rec
46:
47: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50:
51: EXCEPTION

Line 48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

44: END IF;
45: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.get_rec
46:
47: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
48: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
49: END IF;
50:
51: EXCEPTION
52: WHEN OTHERS THEN

Line 53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

49: END IF;
50:
51: EXCEPTION
52: WHEN OTHERS THEN
53: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
54: x_no_data_found := FALSE;
55: FND_MESSAGE.set_name(application => G_APP_NAME,
56: name => G_UNEXPECTED_ERROR);
57: x_msg_data := FND_MESSAGE.get;

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

76: l_pdtv_rec pdtv_rec_type;
77: l_data VARCHAR2(100);
78: l_count NUMBER ;
79: l_api_name CONSTANT VARCHAR2(30) := 'insert_pqvalues';
80: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
81: BEGIN
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83: SAVEPOINT sp_insert_pqvalues;
84: l_pqvv_rec := p_pqvv_rec;

Line 82: x_return_status := FND_API.G_RET_STS_SUCCESS;

78: l_count NUMBER ;
79: l_api_name CONSTANT VARCHAR2(30) := 'insert_pqvalues';
80: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
81: BEGIN
82: x_return_status := FND_API.G_RET_STS_SUCCESS;
83: SAVEPOINT sp_insert_pqvalues;
84: l_pqvv_rec := p_pqvv_rec;
85: l_pqyv_rec := p_pqyv_rec;
86: l_pdtv_rec := p_pdtv_rec;

Line 118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

114: END;
115: END IF;
116: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.insert_pqvalues
117:
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 119: RAISE FND_API.G_EXC_ERROR;

115: END IF;
116: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.insert_pqvalues
117:
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:

Line 120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

116: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.insert_pqvalues
117:
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: /* re-assign local record structure using output record from pvt api */

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117:
118: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: /* re-assign local record structure using output record from pvt api */
125: l_pqvv_rec := x_pqvv_rec;

Line 129: WHEN FND_API.G_EXC_ERROR THEN

125: l_pqvv_rec := x_pqvv_rec;
126:
127:
128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO sp_insert_pqvalues;
131: -- notify caller of an UNEXPECTED error
132: x_return_status := FND_API.G_RET_STS_ERROR;
133:

Line 132: x_return_status := FND_API.G_RET_STS_ERROR;

128: EXCEPTION
129: WHEN FND_API.G_EXC_ERROR THEN
130: ROLLBACK TO sp_insert_pqvalues;
131: -- notify caller of an UNEXPECTED error
132: x_return_status := FND_API.G_RET_STS_ERROR;
133:
134: -- store SQL error message on message stack for caller
135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
136: p_count => x_msg_count,

Line 139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

135: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
136: p_count => x_msg_count,
137: p_data => x_msg_data);
138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: ROLLBACK TO sp_insert_pqvalues;
141: -- notify caller of an UNEXPECTED error
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143:

Line 142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

138:
139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
140: ROLLBACK TO sp_insert_pqvalues;
141: -- notify caller of an UNEXPECTED error
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143:
144: -- store SQL error message on message stack for caller
145: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
146: p_count => x_msg_count,

Line 151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

147: p_data => x_msg_data);
148:
149: WHEN OTHERS THEN
150: -- notify caller of an UNEXPECTED error
151: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
152: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
153:
154: -- store SQL error message on message stack for caller
155: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

176: l_pdtv_rec pdtv_rec_type;
177: l_data VARCHAR2(100);
178: l_count NUMBER ;
179: l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: BEGIN
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183: SAVEPOINT sp_update_pqvalues;
184: l_pqvv_rec := p_pqvv_rec;

Line 182: x_return_status := FND_API.G_RET_STS_SUCCESS;

178: l_count NUMBER ;
179: l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
180: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
181: BEGIN
182: x_return_status := FND_API.G_RET_STS_SUCCESS;
183: SAVEPOINT sp_update_pqvalues;
184: l_pqvv_rec := p_pqvv_rec;
185: l_pqyv_rec := p_pqyv_rec;
186: l_pdtv_rec := p_pdtv_rec;

Line 218: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

214: END;
215: END IF;
216: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.update_pqvalues
217:
218: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
219: RAISE FND_API.G_EXC_ERROR;
220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;

Line 219: RAISE FND_API.G_EXC_ERROR;

215: END IF;
216: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.update_pqvalues
217:
218: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
219: RAISE FND_API.G_EXC_ERROR;
220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:

Line 220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

216: -- End of wraper code generated automatically by Debug code generator for okl_setuppqvalues_pvt.update_pqvalues
217:
218: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
219: RAISE FND_API.G_EXC_ERROR;
220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
224: /* re-assign local record structure using output record from pvt api */

Line 221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

217:
218: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
219: RAISE FND_API.G_EXC_ERROR;
220: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
221: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
222: END IF;
223:
224: /* re-assign local record structure using output record from pvt api */
225: l_pqvv_rec := x_pqvv_rec;

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: l_pqvv_rec := x_pqvv_rec;
226:
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO sp_update_pqvalues;
231: -- notify caller of an UNEXPECTED error
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:

Line 232: x_return_status := FND_API.G_RET_STS_ERROR;

228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230: ROLLBACK TO sp_update_pqvalues;
231: -- notify caller of an UNEXPECTED error
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: -- store SQL error message on message stack for caller
235: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
236: p_count => x_msg_count,

Line 239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

235: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO sp_update_pqvalues;
241: -- notify caller of an UNEXPECTED error
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:

Line 242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
240: ROLLBACK TO sp_update_pqvalues;
241: -- notify caller of an UNEXPECTED error
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:
244: -- store SQL error message on message stack for caller
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
246: p_count => x_msg_count,

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: p_data => x_msg_data);
248:
249: WHEN OTHERS THEN
250: -- notify caller of an UNEXPECTED error
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
253:
254: -- store SQL error message on message stack for caller
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

271: l_pqvv_tbl pqvv_tbl_type:= p_pqvv_tbl ;
272: l_data VARCHAR2(100);
273: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
274: l_count NUMBER ;
275: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
276: BEGIN
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278: SAVEPOINT sp_insert_pqvalues;
279: l_pqyv_rec := p_pqyv_rec;

Line 277: x_return_status := FND_API.G_RET_STS_SUCCESS;

273: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
274: l_count NUMBER ;
275: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
276: BEGIN
277: x_return_status := FND_API.G_RET_STS_SUCCESS;
278: SAVEPOINT sp_insert_pqvalues;
279: l_pqyv_rec := p_pqyv_rec;
280: l_pdtv_rec := p_pdtv_rec;
281: l_pqvv_tbl := p_pqvv_tbl;

Line 312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

308: END;
309: END IF;
310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
311:
312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;

Line 313: RAISE FND_API.G_EXC_ERROR;

309: END IF;
310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
311:
312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:

Line 314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

310: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
311:
312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: /* re-assign local record structure using output record from pvt api */

Line 315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

311:
312: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
313: RAISE FND_API.G_EXC_ERROR;
314: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
316: END IF;
317:
318: /* re-assign local record structure using output record from pvt api */
319: l_pqvv_tbl := x_pqvv_tbl;

Line 325: WHEN FND_API.G_EXC_ERROR THEN

321:
322:
323:
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO sp_insert_pqvalues;
327: -- notify caller of an UNEXPECTED error
328: x_return_status := FND_API.G_RET_STS_ERROR;
329:

Line 328: x_return_status := FND_API.G_RET_STS_ERROR;

324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ROLLBACK TO sp_insert_pqvalues;
327: -- notify caller of an UNEXPECTED error
328: x_return_status := FND_API.G_RET_STS_ERROR;
329:
330: -- store SQL error message on message stack for caller
331: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
332: p_count => x_msg_count,

Line 335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

331: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => x_msg_data);
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: ROLLBACK TO sp_insert_pqvalues;
337: -- notify caller of an UNEXPECTED error
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: ROLLBACK TO sp_insert_pqvalues;
337: -- notify caller of an UNEXPECTED error
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
339:
340: -- store SQL error message on message stack for caller
341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
342: p_count => x_msg_count,

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

343: p_data => x_msg_data);
344:
345: WHEN OTHERS THEN
346: -- notify caller of an UNEXPECTED error
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','insert_pqvalues');
349:
350: -- store SQL error message on message stack for caller
351: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

367: l_pqvv_tbl pqvv_tbl_type:= p_pqvv_tbl ;
368: l_data VARCHAR2(100);
369: l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
370: l_count NUMBER ;
371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: BEGIN
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: SAVEPOINT sp_update_pqvalues;
375: l_pqyv_rec := p_pqyv_rec;

Line 373: x_return_status := FND_API.G_RET_STS_SUCCESS;

369: l_api_name CONSTANT VARCHAR2(30) := 'update_pqvalues';
370: l_count NUMBER ;
371: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
372: BEGIN
373: x_return_status := FND_API.G_RET_STS_SUCCESS;
374: SAVEPOINT sp_update_pqvalues;
375: l_pqyv_rec := p_pqyv_rec;
376: l_pdtv_rec := p_pdtv_rec;
377: l_pqvv_tbl := p_pqvv_tbl;

Line 408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

404: END;
405: END IF;
406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
407:
408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;

Line 409: RAISE FND_API.G_EXC_ERROR;

405: END IF;
406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
407:
408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:

Line 410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

406: -- End of wraper code generated automatically by Debug code generator for OKL_SETUPPQVALUES_PUB .insert_pqvalues
407:
408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: /* re-assign local record structure using output record from pvt api */

Line 411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

407:
408: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
409: RAISE FND_API.G_EXC_ERROR;
410: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
412: END IF;
413:
414: /* re-assign local record structure using output record from pvt api */
415: l_pqvv_tbl := x_pqvv_tbl;

Line 421: WHEN FND_API.G_EXC_ERROR THEN

417:
418:
419:
420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: ROLLBACK TO sp_update_pqvalues;
423: -- notify caller of an UNEXPECTED error
424: x_return_status := FND_API.G_RET_STS_ERROR;
425:

Line 424: x_return_status := FND_API.G_RET_STS_ERROR;

420: EXCEPTION
421: WHEN FND_API.G_EXC_ERROR THEN
422: ROLLBACK TO sp_update_pqvalues;
423: -- notify caller of an UNEXPECTED error
424: x_return_status := FND_API.G_RET_STS_ERROR;
425:
426: -- store SQL error message on message stack for caller
427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
428: p_count => x_msg_count,

Line 431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

427: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
428: p_count => x_msg_count,
429: p_data => x_msg_data);
430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO sp_update_pqvalues;
433: -- notify caller of an UNEXPECTED error
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435:

Line 434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

430:
431: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
432: ROLLBACK TO sp_update_pqvalues;
433: -- notify caller of an UNEXPECTED error
434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
435:
436: -- store SQL error message on message stack for caller
437: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
438: p_count => x_msg_count,

Line 443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

439: p_data => x_msg_data);
440:
441: WHEN OTHERS THEN
442: -- notify caller of an UNEXPECTED error
443: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
444: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPQVALUES_PUB','update_pqvalues');
445:
446: -- store SQL error message on message stack for caller
447: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,