15: x_msg_data OUT NOCOPY VARCHAR2,
16: x_no_data_found OUT NOCOPY BOOLEAN,
17: x_dsfv_rec OUT NOCOPY dsfv_rec_type) IS
18: l_dsfv_rec dsfv_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_dsfv_rec := p_dsfv_rec;
20: l_no_data_found BOOLEAN;
21: BEGIN
22:
23: l_dsfv_rec := p_dsfv_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_setupfunctions_pvt.get_rec
28: IF(L_DEBUG_ENABLED='Y') THEN
44: END;
45: END IF;
46: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_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
45: END IF;
46: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_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
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;
72: l_dsfv_rec dsfv_rec_type;
73: l_data VARCHAR2(100);
74: l_api_name CONSTANT VARCHAR2(30) := 'insert_functions';
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_functions;
80: l_dsfv_rec := p_dsfv_rec;
74: l_api_name CONSTANT VARCHAR2(30) := 'insert_functions';
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_functions;
80: l_dsfv_rec := p_dsfv_rec;
81:
82:
105: END;
106: END IF;
107: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.insert_functions
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;
106: END IF;
107: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.insert_functions
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:
107: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.insert_functions
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 */
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_dsfv_rec := x_dsfv_rec;
117:
118:
119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO sp_insert_functions;
123: -- notify caller of an UNEXPECTED error
124: x_return_status := FND_API.G_RET_STS_ERROR;
125:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: ROLLBACK TO sp_insert_functions;
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,
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_functions;
133: -- notify caller of an UNEXPECTED error
134: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
135:
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO sp_insert_functions;
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,
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_SETUPFUNCTIONS_PUB','insert_functions');
145:
146: -- store SQL error message on message stack for caller
147: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
163: l_dsfv_rec dsfv_rec_type;
164: l_data VARCHAR2(100);
165: l_count NUMBER ;
166: l_api_name CONSTANT VARCHAR2(30) := 'update_functions';
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_functions;
171: l_dsfv_rec := p_dsfv_rec;
165: l_count NUMBER ;
166: l_api_name CONSTANT VARCHAR2(30) := 'update_functions';
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_functions;
171: l_dsfv_rec := p_dsfv_rec;
172:
173:
196: END;
197: END IF;
198: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.update_functions
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;
197: END IF;
198: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.update_functions
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:
198: -- End of wraper code generated automatically by Debug code generator for okl_setupfunctions_pvt.update_functions
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 */
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_dsfv_rec := x_dsfv_rec;
208:
209:
210:
211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ROLLBACK TO sp_update_functions;
214: -- notify caller of an UNEXPECTED error
215: x_return_status := FND_API.G_RET_STS_ERROR;
216:
211: EXCEPTION
212: WHEN FND_API.G_EXC_ERROR THEN
213: ROLLBACK TO sp_update_functions;
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,
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_functions;
224: -- notify caller of an UNEXPECTED error
225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
226:
221:
222: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
223: ROLLBACK TO sp_update_functions;
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,
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_SETUPFUNCTIONS_PUB','update_functions');
236:
237: -- store SQL error message on message stack for caller
238: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,