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_SETUPFORMULAE_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_fmav_rec OUT NOCOPY fmav_rec_type) IS
18: l_fmav_rec fmav_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_fmav_rec := p_fmav_rec;

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: l_no_data_found BOOLEAN;
21: BEGIN
22:
23: l_fmav_rec := p_fmav_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_setupformulae_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_setupformulae_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_setupformulae_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 76: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

72: l_fmav_rec fmav_rec_type;
73: l_data VARCHAR2(100);
74: l_api_name CONSTANT VARCHAR2(30) := 'insert_formulae';
75: l_count NUMBER ;
76: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
77: BEGIN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: SAVEPOINT sp_insert_formulae;
80: l_fmav_rec := p_fmav_rec;

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: l_api_name CONSTANT VARCHAR2(30) := 'insert_formulae';
75: l_count NUMBER ;
76: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
77: BEGIN
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: SAVEPOINT sp_insert_formulae;
80: l_fmav_rec := p_fmav_rec;
81:
82:

Line 109: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 110: RAISE FND_API.G_EXC_ERROR;

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

Line 111: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 121: WHEN FND_API.G_EXC_ERROR THEN

117:
118:
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO sp_insert_formulae;
123: -- notify caller of an UNEXPECTED error
124: x_return_status := FND_API.G_RET_STS_ERROR;
125:

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

163: l_fmav_rec fmav_rec_type;
164: l_data VARCHAR2(100);
165: l_count NUMBER ;
166: l_api_name CONSTANT VARCHAR2(30) := 'update_formulae';
167: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: SAVEPOINT sp_update_formulae;
171: l_fmav_rec := p_fmav_rec;

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: l_count NUMBER ;
166: l_api_name CONSTANT VARCHAR2(30) := 'update_formulae';
167: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
168: BEGIN
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170: SAVEPOINT sp_update_formulae;
171: l_fmav_rec := p_fmav_rec;
172:
173:

Line 200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

196: END;
197: END IF;
198: -- End of wraper code generated automatically by Debug code generator for okl_setupformulae_pvt.update_formulae
199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;

Line 201: RAISE FND_API.G_EXC_ERROR;

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

Line 202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199:
200: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
201: RAISE FND_API.G_EXC_ERROR;
202: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: END IF;
205:
206: /* re-assign local record structure using output record from pvt api */
207: l_fmav_rec := x_fmav_rec;

Line 212: WHEN FND_API.G_EXC_ERROR THEN

208:
209:
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ROLLBACK TO sp_update_formulae;
214: -- notify caller of an UNEXPECTED error
215: x_return_status := FND_API.G_RET_STS_ERROR;
216:

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

218: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
219: p_count => x_msg_count,
220: p_data => x_msg_data);
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO sp_update_formulae;
224: -- notify caller of an UNEXPECTED error
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226:

Line 225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

230: p_data => x_msg_data);
231:
232: WHEN OTHERS THEN
233: -- notify caller of an UNEXPECTED error
234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
235: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPFORMULAE_PUB','update_formulae');
236:
237: -- store SQL error message on message stack for caller
238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,