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

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

8: x_msg_data OUT NOCOPY VARCHAR2,
9: x_no_data_found OUT NOCOPY BOOLEAN,
10: x_psyv_rec OUT NOCOPY psyv_rec_type) IS
11: l_psyv_rec psyv_rec_type;
12: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
13: l_no_data_found BOOLEAN;
14: BEGIN
15:
16: l_psyv_rec := p_psyv_rec;

Line 17: x_return_status := FND_API.G_RET_STS_SUCCESS;

13: l_no_data_found BOOLEAN;
14: BEGIN
15:
16: l_psyv_rec := p_psyv_rec;
17: x_return_status := FND_API.G_RET_STS_SUCCESS;
18: x_no_data_found := TRUE;
19:
20: okl_setuppstypes_pvt.get_rec(p_psyv_rec => l_psyv_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_psyv_rec => x_psyv_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_psyv_rec => x_psyv_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 56: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

52: l_pdtv_rec pdtv_rec_type;
53: l_data VARCHAR2(100);
54: l_count NUMBER ;
55: l_api_name CONSTANT VARCHAR2(30) := 'insert_pstypes';
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_pstypes;
60: l_psyv_rec := p_psyv_rec;

Line 58: x_return_status := FND_API.G_RET_STS_SUCCESS;

54: l_count NUMBER ;
55: l_api_name CONSTANT VARCHAR2(30) := 'insert_pstypes';
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_pstypes;
60: l_psyv_rec := p_psyv_rec;
61: l_pdtv_rec := p_pdtv_rec;
62:

Line 76: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

72: x_psyv_rec => x_psyv_rec,
73: p_pdtv_rec => l_pdtv_rec
74: );
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_pdtv_rec => l_pdtv_rec
74: );
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: );
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_psyv_rec := x_psyv_rec;

Line 87: WHEN FND_API.G_EXC_ERROR THEN

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

Line 90: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 97: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

105: p_data => x_msg_data);
106:
107: WHEN OTHERS THEN
108: -- notify caller of an UNEXPECTED error
109: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
110: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPSTYPES_PUB','insert_pstypes');
111:
112: -- store SQL error message on message stack for caller
113: 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_pdtv_rec pdtv_rec_type;
133: l_data VARCHAR2(100);
134: l_count NUMBER ;
135: l_api_name CONSTANT VARCHAR2(30) := 'update_pstypes';
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_pstypes;
140: l_psyv_rec := p_psyv_rec;

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: l_count NUMBER ;
135: l_api_name CONSTANT VARCHAR2(30) := 'update_pstypes';
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_pstypes;
140: l_psyv_rec := p_psyv_rec;
141: l_pdtv_rec := p_pdtv_rec;
142:

Line 156: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

152: x_psyv_rec => x_psyv_rec,
153: p_pdtv_rec => l_pdtv_rec
154: );
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_pdtv_rec => l_pdtv_rec
154: );
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: );
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_psyv_rec := x_psyv_rec;

Line 167: WHEN FND_API.G_EXC_ERROR THEN

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

Line 170: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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