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

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

15: x_msg_data OUT NOCOPY VARCHAR2,
16: x_no_data_found OUT NOCOPY BOOLEAN,
17: x_pdtv_rec OUT NOCOPY pdtv_rec_type) IS
18: l_pdtv_rec pdtv_rec_type;
19: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
20: l_no_data_found BOOLEAN;
21: BEGIN
22:
23: l_pdtv_rec := p_pdtv_rec;

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 48: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 49: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 54: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

73: p_pdt_parameter_rec OUT NOCOPY pdt_parameters_rec_type) IS
74:
75: l_pdtv_rec pdtv_rec_type;
76: l_product_date DATE;
77: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
78: l_no_data_found BOOLEAN;
79:
80:
81: BEGIN

Line 85: x_return_status := FND_API.G_RET_STS_SUCCESS;

81: BEGIN
82:
83: l_pdtv_rec := p_pdtv_rec;
84: l_product_date := p_product_date;
85: x_return_status := FND_API.G_RET_STS_SUCCESS;
86: x_no_data_found := TRUE;
87:
88: -- Start of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.Getpdt_parameters
89: IF(L_DEBUG_ENABLED='Y') THEN

Line 114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

110: END;
111: END IF;
112: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.Getpdt_parameters
113:
114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: EXCEPTION

Line 115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

111: END IF;
112: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.Getpdt_parameters
113:
114: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
116: END IF;
117:
118: EXCEPTION
119: WHEN OTHERS THEN

Line 120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

116: END IF;
117:
118: EXCEPTION
119: WHEN OTHERS THEN
120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
121: FND_MESSAGE.set_name(application => G_APP_NAME,
122: name => G_UNEXPECTED_ERROR);
123: x_msg_data := FND_MESSAGE.get;
124: END Getpdt_parameters;

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

137: l_pdtv_rec pdtv_rec_type;
138: l_data VARCHAR2(100);
139: l_api_name CONSTANT VARCHAR2(30) := 'insert_products';
140: l_count NUMBER ;
141: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
142: BEGIN
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144: SAVEPOINT sp_insert_products;
145: l_pdtv_rec := p_pdtv_rec;

Line 143: x_return_status := FND_API.G_RET_STS_SUCCESS;

139: l_api_name CONSTANT VARCHAR2(30) := 'insert_products';
140: l_count NUMBER ;
141: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
142: BEGIN
143: x_return_status := FND_API.G_RET_STS_SUCCESS;
144: SAVEPOINT sp_insert_products;
145: l_pdtv_rec := p_pdtv_rec;
146:
147: -- call process api to insert products

Line 172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

168: END;
169: END IF;
170: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.insert_products
171:
172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;

Line 173: RAISE FND_API.G_EXC_ERROR;

169: END IF;
170: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.insert_products
171:
172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:

Line 174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

170: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.insert_products
171:
172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: /* re-assign local record structure using output record from pvt api */

Line 175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

171:
172: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
173: RAISE FND_API.G_EXC_ERROR;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
176: END IF;
177:
178: /* re-assign local record structure using output record from pvt api */
179: l_pdtv_rec := x_pdtv_rec;

Line 183: WHEN FND_API.G_EXC_ERROR THEN

179: l_pdtv_rec := x_pdtv_rec;
180:
181:
182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO sp_insert_products;
185: -- notify caller of an UNEXPECTED error
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:

Line 186: x_return_status := FND_API.G_RET_STS_ERROR;

182: EXCEPTION
183: WHEN FND_API.G_EXC_ERROR THEN
184: ROLLBACK TO sp_insert_products;
185: -- notify caller of an UNEXPECTED error
186: x_return_status := FND_API.G_RET_STS_ERROR;
187:
188: -- store SQL error message on message stack for caller
189: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
190: p_count => x_msg_count,

Line 193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

189: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
190: p_count => x_msg_count,
191: p_data => x_msg_data);
192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO sp_insert_products;
195: -- notify caller of an UNEXPECTED error
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197:

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

192:
193: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
194: ROLLBACK TO sp_insert_products;
195: -- notify caller of an UNEXPECTED error
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197:
198: -- store SQL error message on message stack for caller
199: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
200: p_count => x_msg_count,

Line 205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

201: p_data => x_msg_data);
202:
203: WHEN OTHERS THEN
204: -- notify caller of an UNEXPECTED error
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','insert_products');
207:
208: -- store SQL error message on message stack for caller
209: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

225: l_pdtv_rec pdtv_rec_type;
226: l_data VARCHAR2(100);
227: l_count NUMBER ;
228: l_api_name CONSTANT VARCHAR2(30) := 'update_products';
229: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
230: BEGIN
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: SAVEPOINT sp_update_products;
233: l_pdtv_rec := p_pdtv_rec;

Line 231: x_return_status := FND_API.G_RET_STS_SUCCESS;

227: l_count NUMBER ;
228: l_api_name CONSTANT VARCHAR2(30) := 'update_products';
229: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
230: BEGIN
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: SAVEPOINT sp_update_products;
233: l_pdtv_rec := p_pdtv_rec;
234:
235:

Line 261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

257: END;
258: END IF;
259: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.update_products
260:
261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;

Line 262: RAISE FND_API.G_EXC_ERROR;

258: END IF;
259: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.update_products
260:
261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:

Line 263: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

259: -- End of wraper code generated automatically by Debug code generator for okl_setupproducts_pvt.update_products
260:
261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: /* re-assign local record structure using output record from pvt api */

Line 264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

260:
261: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
262: RAISE FND_API.G_EXC_ERROR;
263: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
265: END IF;
266:
267: /* re-assign local record structure using output record from pvt api */
268: l_pdtv_rec := x_pdtv_rec;

Line 272: WHEN FND_API.G_EXC_ERROR THEN

268: l_pdtv_rec := x_pdtv_rec;
269:
270:
271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO sp_update_products;
274: -- notify caller of an UNEXPECTED error
275: x_return_status := FND_API.G_RET_STS_ERROR;
276:

Line 275: x_return_status := FND_API.G_RET_STS_ERROR;

271: EXCEPTION
272: WHEN FND_API.G_EXC_ERROR THEN
273: ROLLBACK TO sp_update_products;
274: -- notify caller of an UNEXPECTED error
275: x_return_status := FND_API.G_RET_STS_ERROR;
276:
277: -- store SQL error message on message stack for caller
278: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
279: p_count => x_msg_count,

Line 282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

278: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
279: p_count => x_msg_count,
280: p_data => x_msg_data);
281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283: ROLLBACK TO sp_update_products;
284: -- notify caller of an UNEXPECTED error
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281:
282: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
283: ROLLBACK TO sp_update_products;
284: -- notify caller of an UNEXPECTED error
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:
287: -- store SQL error message on message stack for caller
288: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
289: p_count => x_msg_count,

Line 294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

290: p_data => x_msg_data);
291:
292: WHEN OTHERS THEN
293: -- notify caller of an UNEXPECTED error
294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
295: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPRODUCTS_PUB','update_products');
296:
297: -- store SQL error message on message stack for caller
298: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,