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_SETUPDQUALITYS_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_return_status OUT NOCOPY VARCHAR2,
16: x_pdqv_rec OUT NOCOPY pdqv_rec_type) IS
17: l_pdqv_rec pdqv_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_pdqv_rec := p_pdqv_rec;

Line 23: x_return_status := FND_API.G_RET_STS_SUCCESS;

19: l_no_data_found BOOLEAN;
20: BEGIN
21:
22: l_pdqv_rec := p_pdqv_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_setupdqualitys_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_setupdqualitys_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_setupdqualitys_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 77: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

73: l_ptlv_rec ptlv_rec_type;
74: l_data VARCHAR2(100);
75: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
76: l_count NUMBER ;
77: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
78: BEGIN
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80: SAVEPOINT sp_insert_dqualitys;
81: l_pdqv_rec := p_pdqv_rec;

Line 79: x_return_status := FND_API.G_RET_STS_SUCCESS;

75: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
76: l_count NUMBER ;
77: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
78: BEGIN
79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80: SAVEPOINT sp_insert_dqualitys;
81: l_pdqv_rec := p_pdqv_rec;
82: l_ptlv_rec := p_ptlv_rec;
83:

Line 111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

107: END;
108: END IF;
109: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
110:
111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;

Line 112: RAISE FND_API.G_EXC_ERROR;

108: END IF;
109: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
110:
111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:

Line 113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

109: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
110:
111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: /* re-assign local record structure using output record from pvt api */

Line 114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

110:
111: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
112: RAISE FND_API.G_EXC_ERROR;
113: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
115: END IF;
116:
117: /* re-assign local record structure using output record from pvt api */
118: l_pdqv_rec := x_pdqv_rec;

Line 124: WHEN FND_API.G_EXC_ERROR THEN

120:
121:
122:
123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO sp_insert_dqualitys;
126: -- notify caller of an UNEXPECTED error
127: x_return_status := FND_API.G_RET_STS_ERROR;
128:

Line 127: x_return_status := FND_API.G_RET_STS_ERROR;

123: EXCEPTION
124: WHEN FND_API.G_EXC_ERROR THEN
125: ROLLBACK TO sp_insert_dqualitys;
126: -- notify caller of an UNEXPECTED error
127: x_return_status := FND_API.G_RET_STS_ERROR;
128:
129: -- store SQL error message on message stack for caller
130: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
131: p_count => x_msg_count,

Line 134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

130: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
131: p_count => x_msg_count,
132: p_data => x_msg_data);
133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO sp_insert_dqualitys;
136: -- notify caller of an UNEXPECTED error
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:

Line 137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

133:
134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
135: ROLLBACK TO sp_insert_dqualitys;
136: -- notify caller of an UNEXPECTED error
137: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
138:
139: -- store SQL error message on message stack for caller
140: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
141: p_count => x_msg_count,

Line 146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

142: p_data => x_msg_data);
143:
144: WHEN OTHERS THEN
145: -- notify caller of an UNEXPECTED error
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
147: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','insert_dqualitys');
148:
149: -- store SQL error message on message stack for caller
150: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

165: l_ptlv_rec ptlv_rec_type;
166: l_data VARCHAR2(100);
167: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
168: l_count NUMBER ;
169: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: SAVEPOINT sp_insert_dqualitys;
173: l_pdqv_tbl := p_pdqv_tbl;

Line 171: x_return_status := FND_API.G_RET_STS_SUCCESS;

167: l_api_name CONSTANT VARCHAR2(30) := 'insert_dqualitys';
168: l_count NUMBER ;
169: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
170: BEGIN
171: x_return_status := FND_API.G_RET_STS_SUCCESS;
172: SAVEPOINT sp_insert_dqualitys;
173: l_pdqv_tbl := p_pdqv_tbl;
174: l_ptlv_rec := p_ptlv_rec;
175:

Line 203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

199: END;
200: END IF;
201: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
202:
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;

Line 204: RAISE FND_API.G_EXC_ERROR;

200: END IF;
201: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
202:
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208:

Line 205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

201: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.insert_dqualitys
202:
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208:
209: /* re-assign local record structure using output record from pvt api */

Line 206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

202:
203: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
204: RAISE FND_API.G_EXC_ERROR;
205: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
206: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
207: END IF;
208:
209: /* re-assign local record structure using output record from pvt api */
210: l_pdqv_tbl := x_pdqv_tbl;

Line 216: WHEN FND_API.G_EXC_ERROR THEN

212:
213:
214:
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO sp_insert_dqualitys;
218: -- notify caller of an UNEXPECTED error
219: x_return_status := FND_API.G_RET_STS_ERROR;
220:

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: ROLLBACK TO sp_insert_dqualitys;
218: -- notify caller of an UNEXPECTED error
219: x_return_status := FND_API.G_RET_STS_ERROR;
220:
221: -- store SQL error message on message stack for caller
222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
223: p_count => x_msg_count,

Line 226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

222: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
223: p_count => x_msg_count,
224: p_data => x_msg_data);
225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO sp_insert_dqualitys;
228: -- notify caller of an UNEXPECTED error
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:

Line 229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

225:
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: ROLLBACK TO sp_insert_dqualitys;
228: -- notify caller of an UNEXPECTED error
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
230:
231: -- store SQL error message on message stack for caller
232: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
233: p_count => x_msg_count,

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: p_data => x_msg_data);
235:
236: WHEN OTHERS THEN
237: -- notify caller of an UNEXPECTED error
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','insert_dqualitys');
240:
241: -- store SQL error message on message stack for caller
242: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

259: l_ptlv_rec ptlv_rec_type;
260: l_data VARCHAR2(100);
261: l_count NUMBER ;
262: l_api_name CONSTANT VARCHAR2(30) := 'delete_dqualitys';
263: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
264: BEGIN
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: SAVEPOINT sp_delete_dqualitys;
267: l_pdqv_tbl := p_pdqv_tbl;

Line 265: x_return_status := FND_API.G_RET_STS_SUCCESS;

261: l_count NUMBER ;
262: l_api_name CONSTANT VARCHAR2(30) := 'delete_dqualitys';
263: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
264: BEGIN
265: x_return_status := FND_API.G_RET_STS_SUCCESS;
266: SAVEPOINT sp_delete_dqualitys;
267: l_pdqv_tbl := p_pdqv_tbl;
268: l_ptlv_rec := p_ptlv_rec;
269:

Line 297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

293: END;
294: END IF;
295: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
296:
297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;

Line 298: RAISE FND_API.G_EXC_ERROR;

294: END IF;
295: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
296:
297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:

Line 299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

295: -- End of wraper code generated automatically by Debug code generator for okl_setupdqualitys_pvt.delete_dqualitys
296:
297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303:

Line 300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

296:
297: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
298: RAISE FND_API.G_EXC_ERROR;
299: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
301: END IF;
302:
303:
304:

Line 306: WHEN FND_API.G_EXC_ERROR THEN

302:
303:
304:
305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: ROLLBACK TO sp_delete_dqualitys;
308: -- notify caller of an UNEXPECTED error
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:

Line 309: x_return_status := FND_API.G_RET_STS_ERROR;

305: EXCEPTION
306: WHEN FND_API.G_EXC_ERROR THEN
307: ROLLBACK TO sp_delete_dqualitys;
308: -- notify caller of an UNEXPECTED error
309: x_return_status := FND_API.G_RET_STS_ERROR;
310:
311: -- store SQL error message on message stack for caller
312: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
313: p_count => x_msg_count,

Line 316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

312: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
313: p_count => x_msg_count,
314: p_data => x_msg_data);
315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO sp_delete_dqualitys;
318: -- notify caller of an UNEXPECTED error
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320:

Line 319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: ROLLBACK TO sp_delete_dqualitys;
318: -- notify caller of an UNEXPECTED error
319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
320:
321: -- store SQL error message on message stack for caller
322: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
323: p_count => x_msg_count,

Line 328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

324: p_data => x_msg_data);
325:
326: WHEN OTHERS THEN
327: -- notify caller of an UNEXPECTED error
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDQUALITYS_PUB','delete_dqualitys');
330:
331: -- store SQL error message on message stack for caller
332: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,