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_SETUPPOPTIONS_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_ponv_rec OUT NOCOPY ponv_rec_type) IS
12: l_ponv_rec ponv_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_ponv_rec := p_ponv_rec;

Line 18: x_return_status := FND_API.G_RET_STS_SUCCESS;

14: l_no_data_found BOOLEAN;
15: BEGIN
16:
17: l_ponv_rec := p_ponv_rec;
18: x_return_status := FND_API.G_RET_STS_SUCCESS;
19: x_no_data_found := TRUE;
20:
21: okl_setuppoptions_pvt.get_rec(p_ponv_rec => l_ponv_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_ponv_rec => x_ponv_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_ponv_rec => x_ponv_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 57: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

53: l_pdtv_rec pdtv_rec_type;
54: l_data VARCHAR2(100);
55: l_api_name CONSTANT VARCHAR2(30) := 'insert_poptions';
56: l_count NUMBER ;
57: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: BEGIN
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: SAVEPOINT sp_insert_poptions;
61: l_ponv_rec := p_ponv_rec;

Line 59: x_return_status := FND_API.G_RET_STS_SUCCESS;

55: l_api_name CONSTANT VARCHAR2(30) := 'insert_poptions';
56: l_count NUMBER ;
57: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
58: BEGIN
59: x_return_status := FND_API.G_RET_STS_SUCCESS;
60: SAVEPOINT sp_insert_poptions;
61: l_ponv_rec := p_ponv_rec;
62: l_pdtv_rec := p_pdtv_rec;
63:

Line 77: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 78: RAISE FND_API.G_EXC_ERROR;

74: p_pdtv_rec => l_pdtv_rec
75: );
76:
77: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
78: RAISE FND_API.G_EXC_ERROR;
79: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82: l_ponv_rec := x_ponv_rec;

Line 79: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

75: );
76:
77: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
78: RAISE FND_API.G_EXC_ERROR;
79: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82: l_ponv_rec := x_ponv_rec;
83:

Line 80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

76:
77: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
78: RAISE FND_API.G_EXC_ERROR;
79: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
80: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
81: END IF;
82: l_ponv_rec := x_ponv_rec;
83:
84:

Line 86: WHEN FND_API.G_EXC_ERROR THEN

82: l_ponv_rec := x_ponv_rec;
83:
84:
85: EXCEPTION
86: WHEN FND_API.G_EXC_ERROR THEN
87: ROLLBACK TO sp_insert_poptions;
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_poptions;
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 sp_insert_poptions;
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 sp_insert_poptions;
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_setuppoptions_PUB','insert_poptions');
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 133: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

129: l_pdtv_rec pdtv_rec_type;
130: l_data VARCHAR2(100);
131: l_count NUMBER ;
132: l_api_name CONSTANT VARCHAR2(30) := 'delete_poptions';
133: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136: SAVEPOINT sp_delete_poptions;
137: l_ponv_tbl := p_ponv_tbl;

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: l_count NUMBER ;
132: l_api_name CONSTANT VARCHAR2(30) := 'delete_poptions';
133: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
134: BEGIN
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136: SAVEPOINT sp_delete_poptions;
137: l_ponv_tbl := p_ponv_tbl;
138: l_pdtv_rec := p_pdtv_rec;
139:

Line 151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

147: x_msg_data => x_msg_data,
148: p_pdtv_rec => l_pdtv_rec,
149: p_ponv_tbl => l_ponv_tbl);
150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;

Line 152: RAISE FND_API.G_EXC_ERROR;

148: p_pdtv_rec => l_pdtv_rec,
149: p_ponv_tbl => l_ponv_tbl);
150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:

Line 153: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

149: p_ponv_tbl => l_ponv_tbl);
150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157:

Line 154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

150:
151: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
152: RAISE FND_API.G_EXC_ERROR;
153: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
154: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
155: END IF;
156:
157:
158:

Line 160: WHEN FND_API.G_EXC_ERROR THEN

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

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 173: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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