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_SETUPPMVALUES_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_pmvv_rec OUT NOCOPY pmvv_rec_type) IS
12: l_pmvv_rec pmvv_rec_type;
13: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14: l_no_data_found BOOLEAN;
15: BEGIN
16: l_pmvv_rec := p_pmvv_rec;
17: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 17: x_return_status := FND_API.G_RET_STS_SUCCESS;

13: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
14: l_no_data_found BOOLEAN;
15: BEGIN
16: l_pmvv_rec := p_pmvv_rec;
17: x_return_status := FND_API.G_RET_STS_SUCCESS;
18: x_no_data_found := TRUE;
19:
20: okl_SETUPPMVALUES_pvt.get_rec(p_pmvv_rec => l_pmvv_rec,
21: x_return_status => l_return_status,

Line 25: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 26: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 31: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

51: l_ptlv_rec ptlv_rec_type;
52: l_data VARCHAR2(100);
53: l_api_name CONSTANT VARCHAR2(30) := 'insert_pmvalues';
54: l_count NUMBER ;
55: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
56: BEGIN
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: SAVEPOINT sp_insert_pmvalues;
59: l_pmvv_rec := p_pmvv_rec;

Line 57: x_return_status := FND_API.G_RET_STS_SUCCESS;

53: l_api_name CONSTANT VARCHAR2(30) := 'insert_pmvalues';
54: l_count NUMBER ;
55: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
56: BEGIN
57: x_return_status := FND_API.G_RET_STS_SUCCESS;
58: SAVEPOINT sp_insert_pmvalues;
59: l_pmvv_rec := p_pmvv_rec;
60: l_ptlv_rec := p_ptlv_rec;
61:

Line 74: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

70: p_ptlv_rec => l_ptlv_rec,
71: p_pmvv_rec => l_pmvv_rec,
72: x_pmvv_rec => x_pmvv_rec);
73:
74: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;

Line 75: RAISE FND_API.G_EXC_ERROR;

71: p_pmvv_rec => l_pmvv_rec,
72: x_pmvv_rec => x_pmvv_rec);
73:
74: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
75: RAISE FND_API.G_EXC_ERROR;
76: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
78: END IF;
79:

Line 76: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 77: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 86: WHEN FND_API.G_EXC_ERROR THEN

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

Line 89: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

127: l_ptlv_rec ptlv_rec_type;
128: l_data VARCHAR2(100);
129: l_api_name CONSTANT VARCHAR2(30) := 'insert_pmvalues';
130: l_count NUMBER ;
131: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
132: BEGIN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: SAVEPOINT sp_insert_pmvalues;
135: l_pmvv_tbl := p_pmvv_tbl;

Line 133: x_return_status := FND_API.G_RET_STS_SUCCESS;

129: l_api_name CONSTANT VARCHAR2(30) := 'insert_pmvalues';
130: l_count NUMBER ;
131: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
132: BEGIN
133: x_return_status := FND_API.G_RET_STS_SUCCESS;
134: SAVEPOINT sp_insert_pmvalues;
135: l_pmvv_tbl := p_pmvv_tbl;
136: l_ptlv_rec := p_ptlv_rec;
137:

Line 150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

146: p_ptlv_rec => l_ptlv_rec,
147: p_pmvv_tbl => l_pmvv_tbl,
148: x_pmvv_tbl => x_pmvv_tbl);
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;

Line 151: RAISE FND_API.G_EXC_ERROR;

147: p_pmvv_tbl => l_pmvv_tbl,
148: x_pmvv_tbl => x_pmvv_tbl);
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:

Line 152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

148: x_pmvv_tbl => x_pmvv_tbl);
149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: /* re-assign local record structure using output record from pvt api */

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149:
150: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
151: RAISE FND_API.G_EXC_ERROR;
152: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156: /* re-assign local record structure using output record from pvt api */
157: l_pmvv_tbl := x_pmvv_tbl;

Line 162: WHEN FND_API.G_EXC_ERROR THEN

158:
159:
160:
161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: ROLLBACK TO sp_insert_pmvalues;
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_ERROR;
166:

Line 165: x_return_status := FND_API.G_RET_STS_ERROR;

161: EXCEPTION
162: WHEN FND_API.G_EXC_ERROR THEN
163: ROLLBACK TO sp_insert_pmvalues;
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_ERROR;
166:
167: -- store SQL error message on message stack for caller
168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
169: p_count => x_msg_count,

Line 172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO pm_insert_pmvalues;
174: -- notify caller of an UNEXPECTED error
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:

Line 175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

171:
172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
173: ROLLBACK TO pm_insert_pmvalues;
174: -- notify caller of an UNEXPECTED error
175: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176:
177: -- store SQL error message on message stack for caller
178: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
179: p_count => x_msg_count,

Line 184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

180: p_data => x_msg_data);
181:
182: WHEN OTHERS THEN
183: -- notify caller of an UNEXPECTED error
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','insert_pmvalues');
186:
187: -- store SQL error message on message stack for caller
188: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,

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

206: l_ptlv_rec ptlv_rec_type;
207: l_data VARCHAR2(100);
208: l_count NUMBER ;
209: l_api_name CONSTANT VARCHAR2(30) := 'delete_pmvalues';
210: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: SAVEPOINT sp_delete_pmvalues;
214: l_pmvv_tbl := p_pmvv_tbl;

Line 212: x_return_status := FND_API.G_RET_STS_SUCCESS;

208: l_count NUMBER ;
209: l_api_name CONSTANT VARCHAR2(30) := 'delete_pmvalues';
210: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
211: BEGIN
212: x_return_status := FND_API.G_RET_STS_SUCCESS;
213: SAVEPOINT sp_delete_pmvalues;
214: l_pmvv_tbl := p_pmvv_tbl;
215: l_ptlv_rec := p_ptlv_rec;
216:

Line 228: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

224: x_msg_data => x_msg_data,
225: p_ptlv_rec => l_ptlv_rec,
226: p_pmvv_tbl => l_pmvv_tbl);
227:
228: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;

Line 229: RAISE FND_API.G_EXC_ERROR;

225: p_ptlv_rec => l_ptlv_rec,
226: p_pmvv_tbl => l_pmvv_tbl);
227:
228: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:

Line 230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

226: p_pmvv_tbl => l_pmvv_tbl);
227:
228: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234:

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227:
228: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: END IF;
233:
234:
235:

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233:
234:
235:
236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO sp_delete_pmvalues;
239: -- notify caller of an UNEXPECTED error
240: x_return_status := FND_API.G_RET_STS_ERROR;
241:

Line 240: x_return_status := FND_API.G_RET_STS_ERROR;

236: EXCEPTION
237: WHEN FND_API.G_EXC_ERROR THEN
238: ROLLBACK TO sp_delete_pmvalues;
239: -- notify caller of an UNEXPECTED error
240: x_return_status := FND_API.G_RET_STS_ERROR;
241:
242: -- store SQL error message on message stack for caller
243: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
244: p_count => x_msg_count,

Line 247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

243: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: ROLLBACK TO sp_delete_pmvalues;
249: -- notify caller of an UNEXPECTED error
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251:

Line 250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
248: ROLLBACK TO sp_delete_pmvalues;
249: -- notify caller of an UNEXPECTED error
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251:
252: -- store SQL error message on message stack for caller
253: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
254: p_count => x_msg_count,

Line 259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

255: p_data => x_msg_data);
256:
257: WHEN OTHERS THEN
258: -- notify caller of an UNEXPECTED error
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','delete_pmvalues');
261:
262: -- store SQL error message on message stack for caller
263: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,