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

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

9: x_msg_data OUT NOCOPY VARCHAR2,
10: x_no_data_found OUT NOCOPY BOOLEAN,
11: x_ovev_rec OUT NOCOPY ovev_rec_type) IS
12: l_ovev_rec ovev_rec_type;
13: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14: l_no_data_found BOOLEAN;
15: BEGIN
16:
17: l_ovev_rec := p_ovev_rec;

Line 18: x_return_status := FND_API.G_RET_STS_SUCCESS;

14: l_no_data_found BOOLEAN;
15: BEGIN
16:
17: l_ovev_rec := p_ovev_rec;
18: x_return_status := FND_API.G_RET_STS_SUCCESS;
19: x_no_data_found := TRUE;
20:
21: okl_setupoptvalues_pvt.get_rec(p_ovev_rec => l_ovev_rec,
22: x_return_status => l_return_status,

Line 26: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

22: x_return_status => l_return_status,
23: x_no_data_found => l_no_data_found,
24: x_ovev_rec => x_ovev_rec);
25:
26: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
27: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
28: END IF;
29:
30: EXCEPTION

Line 27: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

23: x_no_data_found => l_no_data_found,
24: x_ovev_rec => x_ovev_rec);
25:
26: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
27: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
28: END IF;
29:
30: EXCEPTION
31: WHEN OTHERS THEN

Line 32: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

28: END IF;
29:
30: EXCEPTION
31: WHEN OTHERS THEN
32: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
33: x_no_data_found := FALSE;
34: FND_MESSAGE.set_name(application => G_APP_NAME,
35: name => G_UNEXPECTED_ERROR);
36: x_msg_data := FND_MESSAGE.get;

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

52: l_ovev_rec ovev_rec_type;
53: l_data VARCHAR2(100);
54: l_api_name CONSTANT VARCHAR2(30) := 'insert_optvalues';
55: l_count NUMBER ;
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: BEGIN
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: SAVEPOINT sp_insert_optvalues;
60:

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: l_api_name CONSTANT VARCHAR2(30) := 'insert_optvalues';
55: l_count NUMBER ;
56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
57: BEGIN
58: x_return_status := FND_API.G_RET_STS_SUCCESS;
59: SAVEPOINT sp_insert_optvalues;
60:
61: l_optv_rec := p_optv_rec;
62: l_ovev_rec := p_ovev_rec;

Line 76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

72: p_optv_rec => l_optv_rec,
73: p_ovev_rec => l_ovev_rec,
74: x_ovev_rec => x_ovev_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;

Line 77: RAISE FND_API.G_EXC_ERROR;

73: p_ovev_rec => l_ovev_rec,
74: x_ovev_rec => x_ovev_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:

Line 78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

74: x_ovev_rec => x_ovev_rec);
75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: /* re-assign local record structure using output record from pvt api */

Line 79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

75:
76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
77: RAISE FND_API.G_EXC_ERROR;
78: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
79: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
80: END IF;
81:
82: /* re-assign local record structure using output record from pvt api */
83: l_ovev_rec := x_ovev_rec;

Line 88: WHEN FND_API.G_EXC_ERROR THEN

84:
85:
86:
87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: ROLLBACK TO sp_insert_optvalues;
90: -- notify caller of an UNEXPECTED error
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:

Line 91: x_return_status := FND_API.G_RET_STS_ERROR;

87: EXCEPTION
88: WHEN FND_API.G_EXC_ERROR THEN
89: ROLLBACK TO sp_insert_optvalues;
90: -- notify caller of an UNEXPECTED error
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:
93: -- store SQL error message on message stack for caller
94: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
95: p_count => x_msg_count,

Line 98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

94: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data);
97:
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO sp_insert_optvalues;
100: -- notify caller of an UNEXPECTED error
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102:

Line 101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

97:
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
99: ROLLBACK TO sp_insert_optvalues;
100: -- notify caller of an UNEXPECTED error
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102:
103: -- store SQL error message on message stack for caller
104: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
105: p_count => x_msg_count,

Line 110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

106: p_data => x_msg_data);
107:
108: WHEN OTHERS THEN
109: -- notify caller of an UNEXPECTED error
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTVALUES_PUB','insert_optvalues');
112:
113: -- store SQL error message on message stack for caller
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

132: l_ovev_rec ovev_rec_type;
133: l_data VARCHAR2(100);
134: l_count NUMBER ;
135: l_api_name CONSTANT VARCHAR2(30) := 'update_optvalues';
136: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: SAVEPOINT sp_update_optvalues;
140:

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: l_count NUMBER ;
135: l_api_name CONSTANT VARCHAR2(30) := 'update_optvalues';
136: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
137: BEGIN
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139: SAVEPOINT sp_update_optvalues;
140:
141: l_optv_rec := p_optv_rec;
142: l_ovev_rec := p_ovev_rec;

Line 156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

152: p_optv_rec => l_optv_rec,
153: p_ovev_rec => l_ovev_rec,
154: x_ovev_rec => x_ovev_rec);
155:
156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;

Line 157: RAISE FND_API.G_EXC_ERROR;

153: p_ovev_rec => l_ovev_rec,
154: x_ovev_rec => x_ovev_rec);
155:
156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:

Line 158: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

154: x_ovev_rec => x_ovev_rec);
155:
156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: /* re-assign local record structure using output record from pvt api */

Line 159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

155:
156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
157: RAISE FND_API.G_EXC_ERROR;
158: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
159: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
160: END IF;
161:
162: /* re-assign local record structure using output record from pvt api */
163: l_ovev_rec := x_ovev_rec;

Line 168: WHEN FND_API.G_EXC_ERROR THEN

164:
165:
166:
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK TO sp_update_optvalues;
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:

Line 171: x_return_status := FND_API.G_RET_STS_ERROR;

167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK TO sp_update_optvalues;
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_ERROR;
172:
173: -- store SQL error message on message stack for caller
174: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
175: p_count => x_msg_count,

Line 178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

174: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO sp_update_optvalues;
180: -- notify caller of an UNEXPECTED error
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177:
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: ROLLBACK TO sp_update_optvalues;
180: -- notify caller of an UNEXPECTED error
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,

Line 190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

186: p_data => x_msg_data);
187:
188: WHEN OTHERS THEN
189: -- notify caller of an UNEXPECTED error
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPOPTVALUES_PUB','update_optvalues');
192:
193: -- store SQL error message on message stack for caller
194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,