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_AGN_PVT dependencies on OKC_API

Line 176: IF (l_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

172: p_agnv_rec IN agnv_rec_type
173: ) RETURN agnv_rec_type IS
174: l_agnv_rec agnv_rec_type := p_agnv_rec;
175: BEGIN
176: IF (l_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
177: l_agnv_rec.object_version_number := NULL;
178: END IF;
179: IF (l_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
180: l_agnv_rec.aro_code := NULL;

Line 179: IF (l_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN

175: BEGIN
176: IF (l_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
177: l_agnv_rec.object_version_number := NULL;
178: END IF;
179: IF (l_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
180: l_agnv_rec.aro_code := NULL;
181: END IF;
182: IF (l_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR) THEN
183: l_agnv_rec.arlo_code := NULL;

Line 182: IF (l_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR) THEN

178: END IF;
179: IF (l_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
180: l_agnv_rec.aro_code := NULL;
181: END IF;
182: IF (l_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR) THEN
183: l_agnv_rec.arlo_code := NULL;
184: END IF;
185: IF (l_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN
186: l_agnv_rec.acro_code := NULL;

Line 185: IF (l_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN

181: END IF;
182: IF (l_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR) THEN
183: l_agnv_rec.arlo_code := NULL;
184: END IF;
185: IF (l_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN
186: l_agnv_rec.acro_code := NULL;
187: END IF;
188: IF (l_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
189: l_agnv_rec.line_number := NULL;

Line 188: IF (l_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN

184: END IF;
185: IF (l_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN
186: l_agnv_rec.acro_code := NULL;
187: END IF;
188: IF (l_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
189: l_agnv_rec.line_number := NULL;
190: END IF;
191: IF (l_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
192: l_agnv_rec.version := NULL;

Line 191: IF (l_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN

187: END IF;
188: IF (l_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
189: l_agnv_rec.line_number := NULL;
190: END IF;
191: IF (l_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
192: l_agnv_rec.version := NULL;
193: END IF;
194: IF (l_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR) THEN
195: l_agnv_rec.left_parentheses := NULL;

Line 194: IF (l_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR) THEN

190: END IF;
191: IF (l_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
192: l_agnv_rec.version := NULL;
193: END IF;
194: IF (l_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR) THEN
195: l_agnv_rec.left_parentheses := NULL;
196: END IF;
197: IF (l_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
198: l_agnv_rec.right_operand_literal := NULL;

Line 197: IF (l_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN

193: END IF;
194: IF (l_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR) THEN
195: l_agnv_rec.left_parentheses := NULL;
196: END IF;
197: IF (l_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
198: l_agnv_rec.right_operand_literal := NULL;
199: END IF;
200: IF (l_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR) THEN
201: l_agnv_rec.right_parentheses := NULL;

Line 200: IF (l_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR) THEN

196: END IF;
197: IF (l_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
198: l_agnv_rec.right_operand_literal := NULL;
199: END IF;
200: IF (l_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR) THEN
201: l_agnv_rec.right_parentheses := NULL;
202: END IF;
203: IF (l_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
204: l_agnv_rec.from_date := NULL;

Line 203: IF (l_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN

199: END IF;
200: IF (l_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR) THEN
201: l_agnv_rec.right_parentheses := NULL;
202: END IF;
203: IF (l_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
204: l_agnv_rec.from_date := NULL;
205: END IF;
206: IF (l_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE) THEN
207: l_agnv_rec.TO_DATE := NULL;

Line 206: IF (l_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE) THEN

202: END IF;
203: IF (l_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
204: l_agnv_rec.from_date := NULL;
205: END IF;
206: IF (l_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE) THEN
207: l_agnv_rec.TO_DATE := NULL;
208: END IF;
209: IF (l_agnv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
210: l_agnv_rec.org_id := NULL;

Line 209: IF (l_agnv_rec.org_id = Okc_Api.G_MISS_NUM) THEN

205: END IF;
206: IF (l_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE) THEN
207: l_agnv_rec.TO_DATE := NULL;
208: END IF;
209: IF (l_agnv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
210: l_agnv_rec.org_id := NULL;
211: END IF;
212: IF (l_agnv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
213: l_agnv_rec.created_by := NULL;

Line 212: IF (l_agnv_rec.created_by = Okc_Api.G_MISS_NUM) THEN

208: END IF;
209: IF (l_agnv_rec.org_id = Okc_Api.G_MISS_NUM) THEN
210: l_agnv_rec.org_id := NULL;
211: END IF;
212: IF (l_agnv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
213: l_agnv_rec.created_by := NULL;
214: END IF;
215: IF (l_agnv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
216: l_agnv_rec.creation_date := NULL;

Line 215: IF (l_agnv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN

211: END IF;
212: IF (l_agnv_rec.created_by = Okc_Api.G_MISS_NUM) THEN
213: l_agnv_rec.created_by := NULL;
214: END IF;
215: IF (l_agnv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
216: l_agnv_rec.creation_date := NULL;
217: END IF;
218: IF (l_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
219: l_agnv_rec.last_updated_by := NULL;

Line 218: IF (l_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN

214: END IF;
215: IF (l_agnv_rec.creation_date = Okc_Api.G_MISS_DATE) THEN
216: l_agnv_rec.creation_date := NULL;
217: END IF;
218: IF (l_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
219: l_agnv_rec.last_updated_by := NULL;
220: END IF;
221: IF (l_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
222: l_agnv_rec.last_update_date := NULL;

Line 221: IF (l_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN

217: END IF;
218: IF (l_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
219: l_agnv_rec.last_updated_by := NULL;
220: END IF;
221: IF (l_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
222: l_agnv_rec.last_update_date := NULL;
223: END IF;
224: IF (l_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
225: l_agnv_rec.last_update_login := NULL;

Line 224: IF (l_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN

220: END IF;
221: IF (l_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
222: l_agnv_rec.last_update_date := NULL;
223: END IF;
224: IF (l_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
225: l_agnv_rec.last_update_login := NULL;
226: END IF;
227: RETURN(l_agnv_rec);
228: END null_out_defaults;

Line 240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

236: --------------------------------------------------
237: FUNCTION Validate_Attributes (
238: p_agnv_rec IN agnv_rec_type
239: ) RETURN VARCHAR2 IS
240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
241: BEGIN
242: IF p_agnv_rec.id = OKC_API.G_MISS_NUM OR
243: p_agnv_rec.id IS NULL
244: THEN

Line 242: IF p_agnv_rec.id = OKC_API.G_MISS_NUM OR

238: p_agnv_rec IN agnv_rec_type
239: ) RETURN VARCHAR2 IS
240: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
241: BEGIN
242: IF p_agnv_rec.id = OKC_API.G_MISS_NUM OR
243: p_agnv_rec.id IS NULL
244: THEN
245: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
246: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 245: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');

241: BEGIN
242: IF p_agnv_rec.id = OKC_API.G_MISS_NUM OR
243: p_agnv_rec.id IS NULL
244: THEN
245: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
246: l_return_status := OKC_API.G_RET_STS_ERROR;
247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
248: p_agnv_rec.object_version_number IS NULL
249: THEN

Line 246: l_return_status := OKC_API.G_RET_STS_ERROR;

242: IF p_agnv_rec.id = OKC_API.G_MISS_NUM OR
243: p_agnv_rec.id IS NULL
244: THEN
245: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
246: l_return_status := OKC_API.G_RET_STS_ERROR;
247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
248: p_agnv_rec.object_version_number IS NULL
249: THEN
250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

Line 247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR

243: p_agnv_rec.id IS NULL
244: THEN
245: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'id');
246: l_return_status := OKC_API.G_RET_STS_ERROR;
247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
248: p_agnv_rec.object_version_number IS NULL
249: THEN
250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
251: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');

246: l_return_status := OKC_API.G_RET_STS_ERROR;
247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
248: p_agnv_rec.object_version_number IS NULL
249: THEN
250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
251: l_return_status := OKC_API.G_RET_STS_ERROR;
252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR
253: p_agnv_rec.aro_code IS NULL
254: THEN

Line 251: l_return_status := OKC_API.G_RET_STS_ERROR;

247: ELSIF p_agnv_rec.object_version_number = OKC_API.G_MISS_NUM OR
248: p_agnv_rec.object_version_number IS NULL
249: THEN
250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
251: l_return_status := OKC_API.G_RET_STS_ERROR;
252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR
253: p_agnv_rec.aro_code IS NULL
254: THEN
255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');

Line 252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR

248: p_agnv_rec.object_version_number IS NULL
249: THEN
250: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'object_version_number');
251: l_return_status := OKC_API.G_RET_STS_ERROR;
252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR
253: p_agnv_rec.aro_code IS NULL
254: THEN
255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');
256: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');

251: l_return_status := OKC_API.G_RET_STS_ERROR;
252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR
253: p_agnv_rec.aro_code IS NULL
254: THEN
255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');
256: l_return_status := OKC_API.G_RET_STS_ERROR;
257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR
258: p_agnv_rec.arlo_code IS NULL
259: THEN

Line 256: l_return_status := OKC_API.G_RET_STS_ERROR;

252: ELSIF p_agnv_rec.aro_code = OKC_API.G_MISS_CHAR OR
253: p_agnv_rec.aro_code IS NULL
254: THEN
255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');
256: l_return_status := OKC_API.G_RET_STS_ERROR;
257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR
258: p_agnv_rec.arlo_code IS NULL
259: THEN
260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');

Line 257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR

253: p_agnv_rec.aro_code IS NULL
254: THEN
255: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'aro_code');
256: l_return_status := OKC_API.G_RET_STS_ERROR;
257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR
258: p_agnv_rec.arlo_code IS NULL
259: THEN
260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');
261: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');

256: l_return_status := OKC_API.G_RET_STS_ERROR;
257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR
258: p_agnv_rec.arlo_code IS NULL
259: THEN
260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');
261: l_return_status := OKC_API.G_RET_STS_ERROR;
262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR
263: p_agnv_rec.acro_code IS NULL
264: THEN

Line 261: l_return_status := OKC_API.G_RET_STS_ERROR;

257: ELSIF p_agnv_rec.arlo_code = OKC_API.G_MISS_CHAR OR
258: p_agnv_rec.arlo_code IS NULL
259: THEN
260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');
261: l_return_status := OKC_API.G_RET_STS_ERROR;
262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR
263: p_agnv_rec.acro_code IS NULL
264: THEN
265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');

Line 262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR

258: p_agnv_rec.arlo_code IS NULL
259: THEN
260: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'arlo_code');
261: l_return_status := OKC_API.G_RET_STS_ERROR;
262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR
263: p_agnv_rec.acro_code IS NULL
264: THEN
265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');
266: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');

261: l_return_status := OKC_API.G_RET_STS_ERROR;
262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR
263: p_agnv_rec.acro_code IS NULL
264: THEN
265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');
266: l_return_status := OKC_API.G_RET_STS_ERROR;
267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR
268: p_agnv_rec.line_number IS NULL
269: THEN

Line 266: l_return_status := OKC_API.G_RET_STS_ERROR;

262: ELSIF p_agnv_rec.acro_code = OKC_API.G_MISS_CHAR OR
263: p_agnv_rec.acro_code IS NULL
264: THEN
265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');
266: l_return_status := OKC_API.G_RET_STS_ERROR;
267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR
268: p_agnv_rec.line_number IS NULL
269: THEN
270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');

Line 267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR

263: p_agnv_rec.acro_code IS NULL
264: THEN
265: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'acro_code');
266: l_return_status := OKC_API.G_RET_STS_ERROR;
267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR
268: p_agnv_rec.line_number IS NULL
269: THEN
270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');
271: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');

266: l_return_status := OKC_API.G_RET_STS_ERROR;
267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR
268: p_agnv_rec.line_number IS NULL
269: THEN
270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');
271: l_return_status := OKC_API.G_RET_STS_ERROR;
272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR
273: p_agnv_rec.version IS NULL
274: THEN

Line 271: l_return_status := OKC_API.G_RET_STS_ERROR;

267: ELSIF p_agnv_rec.line_number = OKC_API.G_MISS_NUM OR
268: p_agnv_rec.line_number IS NULL
269: THEN
270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');
271: l_return_status := OKC_API.G_RET_STS_ERROR;
272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR
273: p_agnv_rec.version IS NULL
274: THEN
275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');

Line 272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR

268: p_agnv_rec.line_number IS NULL
269: THEN
270: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'line_number');
271: l_return_status := OKC_API.G_RET_STS_ERROR;
272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR
273: p_agnv_rec.version IS NULL
274: THEN
275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');
276: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');

271: l_return_status := OKC_API.G_RET_STS_ERROR;
272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR
273: p_agnv_rec.version IS NULL
274: THEN
275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');
276: l_return_status := OKC_API.G_RET_STS_ERROR;
277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR
278: p_agnv_rec.right_operand_literal IS NULL
279: THEN

Line 276: l_return_status := OKC_API.G_RET_STS_ERROR;

272: ELSIF p_agnv_rec.version = OKC_API.G_MISS_CHAR OR
273: p_agnv_rec.version IS NULL
274: THEN
275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');
276: l_return_status := OKC_API.G_RET_STS_ERROR;
277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR
278: p_agnv_rec.right_operand_literal IS NULL
279: THEN
280: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'right_operand_literal');

Line 277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR

273: p_agnv_rec.version IS NULL
274: THEN
275: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'version');
276: l_return_status := OKC_API.G_RET_STS_ERROR;
277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR
278: p_agnv_rec.right_operand_literal IS NULL
279: THEN
280: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'right_operand_literal');
281: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 280: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'right_operand_literal');

276: l_return_status := OKC_API.G_RET_STS_ERROR;
277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR
278: p_agnv_rec.right_operand_literal IS NULL
279: THEN
280: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'right_operand_literal');
281: l_return_status := OKC_API.G_RET_STS_ERROR;
282: END IF;
283: RETURN(l_return_status);
284: END Validate_Attributes;

Line 281: l_return_status := OKC_API.G_RET_STS_ERROR;

277: ELSIF p_agnv_rec.right_operand_literal = OKC_API.G_MISS_CHAR OR
278: p_agnv_rec.right_operand_literal IS NULL
279: THEN
280: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'right_operand_literal');
281: l_return_status := OKC_API.G_RET_STS_ERROR;
282: END IF;
283: RETURN(l_return_status);
284: END Validate_Attributes;
285:

Line 295: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

291: ----------------------------------------------
292: FUNCTION Validate_Record (
293: p_agnv_rec IN agnv_rec_type
294: ) RETURN VARCHAR2 IS
295: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
296: BEGIN
297: RETURN (l_return_status);
298: END Validate_Record;
299:

Line 320: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

316: PROCEDURE Validate_Id (x_return_status OUT NOCOPY VARCHAR2
317: ,p_agnv_rec IN agnv_rec_type )
318: IS
319:
320: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
321:
322: BEGIN
323: -- initialize return status
324: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 324: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

320: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
321:
322: BEGIN
323: -- initialize return status
324: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
325: -- check for data before processing
326: IF (p_agnv_rec.id IS NULL) OR
327: (p_agnv_rec.id = Okc_Api.G_MISS_NUM) THEN
328: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 327: (p_agnv_rec.id = Okc_Api.G_MISS_NUM) THEN

323: -- initialize return status
324: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
325: -- check for data before processing
326: IF (p_agnv_rec.id IS NULL) OR
327: (p_agnv_rec.id = Okc_Api.G_MISS_NUM) THEN
328: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
329: ,p_msg_name => g_required_value
330: ,p_token1 => g_col_name_token
331: ,p_token1_value => 'id');

Line 328: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

324: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
325: -- check for data before processing
326: IF (p_agnv_rec.id IS NULL) OR
327: (p_agnv_rec.id = Okc_Api.G_MISS_NUM) THEN
328: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
329: ,p_msg_name => g_required_value
330: ,p_token1 => g_col_name_token
331: ,p_token1_value => 'id');
332: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 332: x_return_status := Okc_Api.G_RET_STS_ERROR;

328: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
329: ,p_msg_name => g_required_value
330: ,p_token1 => g_col_name_token
331: ,p_token1_value => 'id');
332: x_return_status := Okc_Api.G_RET_STS_ERROR;
333: RAISE G_EXCEPTION_HALT_VALIDATION;
334: END IF;
335:
336: EXCEPTION

Line 344: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

340: NULL;
341:
342: WHEN OTHERS THEN
343: -- store SQL error message on message stack for caller
344: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
345: p_msg_name => g_unexpected_error,
346: p_token1 => g_sqlcode_token,
347: p_token1_value => SQLCODE,
348: p_token2 => g_sqlerrm_token,

Line 352: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

348: p_token2 => g_sqlerrm_token,
349: p_token2_value => SQLERRM);
350:
351: -- notify caller of an UNEXPECTED error
352: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
353:
354: END Validate_Id;
355:
356: ---------------------------------------------------------------------------

Line 372: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

368: PROCEDURE Validate_Object_Version_Number(x_return_status OUT NOCOPY VARCHAR2
369: ,p_agnv_rec IN agnv_rec_type )
370: IS
371:
372: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
373:
374: BEGIN
375: -- initialize return status
376: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 376: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

372: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
373:
374: BEGIN
375: -- initialize return status
376: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
377: -- check for data before processing
378: IF (p_agnv_rec.object_version_number IS NULL) OR
379: (p_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
380: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 379: (p_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN

375: -- initialize return status
376: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
377: -- check for data before processing
378: IF (p_agnv_rec.object_version_number IS NULL) OR
379: (p_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
380: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
381: ,p_msg_name => g_required_value
382: ,p_token1 => g_col_name_token
383: ,p_token1_value => 'object_version_number');

Line 380: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

376: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
377: -- check for data before processing
378: IF (p_agnv_rec.object_version_number IS NULL) OR
379: (p_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM) THEN
380: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
381: ,p_msg_name => g_required_value
382: ,p_token1 => g_col_name_token
383: ,p_token1_value => 'object_version_number');
384: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 384: x_return_status := Okc_Api.G_RET_STS_ERROR;

380: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
381: ,p_msg_name => g_required_value
382: ,p_token1 => g_col_name_token
383: ,p_token1_value => 'object_version_number');
384: x_return_status := Okc_Api.G_RET_STS_ERROR;
385: RAISE G_EXCEPTION_HALT_VALIDATION;
386: END IF;
387:
388: EXCEPTION

Line 396: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

392: NULL;
393:
394: WHEN OTHERS THEN
395: -- store SQL error message on message stack for caller
396: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
397: p_msg_name => g_unexpected_error,
398: p_token1 => g_sqlcode_token,
399: p_token1_value => SQLCODE,
400: p_token2 => g_sqlerrm_token,

Line 404: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

400: p_token2 => g_sqlerrm_token,
401: p_token2_value => SQLERRM);
402:
403: -- notify caller of an UNEXPECTED error
404: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
405:
406: END Validate_Object_Version_Number;
407:
408: ---------------------------------------------------------------------------

Line 430: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

426: l_dummy VARCHAR2(1) := okl_api.g_true;
427:
428: BEGIN
429: -- initialize return status
430: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
431: -- check for data before processing
432: IF (p_agnv_rec.aro_code IS NULL) OR
433: (p_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
434: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 433: (p_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN

429: -- initialize return status
430: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
431: -- check for data before processing
432: IF (p_agnv_rec.aro_code IS NULL) OR
433: (p_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
434: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
435: ,p_msg_name => g_required_value
436: ,p_token1 => g_col_name_token
437: ,p_token1_value => 'aro_code');

Line 434: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

430: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
431: -- check for data before processing
432: IF (p_agnv_rec.aro_code IS NULL) OR
433: (p_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR) THEN
434: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
435: ,p_msg_name => g_required_value
436: ,p_token1 => g_col_name_token
437: ,p_token1_value => 'aro_code');
438: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 438: x_return_status := Okc_Api.G_RET_STS_ERROR;

434: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
435: ,p_msg_name => g_required_value
436: ,p_token1 => g_col_name_token
437: ,p_token1_value => 'aro_code');
438: x_return_status := Okc_Api.G_RET_STS_ERROR;
439: RAISE G_EXCEPTION_HALT_VALIDATION;
440:
441: END IF;
442:

Line 448: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

444: p_lookup_type => 'OKL_ACCRUAL_RULE_OPERAND',
445: p_lookup_code => p_agnv_rec.aro_code);
446:
447: IF (l_dummy = okl_api.g_false) THEN
448: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
449: p_msg_name => g_invalid_value,
450: p_token1 => g_col_name_token,
451: p_token1_value => 'aro_code');
452: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 452: x_return_status := Okc_Api.G_RET_STS_ERROR;

448: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
449: p_msg_name => g_invalid_value,
450: p_token1 => g_col_name_token,
451: p_token1_value => 'aro_code');
452: x_return_status := Okc_Api.G_RET_STS_ERROR;
453: RAISE G_EXCEPTION_HALT_VALIDATION;
454: END IF;
455: EXCEPTION
456: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 463: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

459: NULL;
460:
461: WHEN OTHERS THEN
462: -- store SQL error message on message stack for caller
463: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
464: p_msg_name => g_unexpected_error,
465: p_token1 => g_sqlcode_token,
466: p_token1_value => SQLCODE,
467: p_token2 => g_sqlerrm_token,

Line 470: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

466: p_token1_value => SQLCODE,
467: p_token2 => g_sqlerrm_token,
468: p_token2_value => SQLERRM);
469: -- notify caller of an UNEXPECTED error
470: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
471: END Validate_Aro_Code;
472:
473: ---------------------------------------------------------------------------
474: -- PROCEDURE Validate_Arlo_Code

Line 495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

491: l_dummy VARCHAR2(1);
492:
493: BEGIN
494: -- initialize return status
495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
496:
497: IF (p_agnv_rec.arlo_code IS NOT NULL) AND (p_agnv_rec.arlo_code <> OKC_API.G_MISS_CHAR) THEN
498: --Check if arlo code exists in the FND_COMMON_LOOKUPS or not
499: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE (

Line 497: IF (p_agnv_rec.arlo_code IS NOT NULL) AND (p_agnv_rec.arlo_code <> OKC_API.G_MISS_CHAR) THEN

493: BEGIN
494: -- initialize return status
495: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
496:
497: IF (p_agnv_rec.arlo_code IS NOT NULL) AND (p_agnv_rec.arlo_code <> OKC_API.G_MISS_CHAR) THEN
498: --Check if arlo code exists in the FND_COMMON_LOOKUPS or not
499: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE (
500: p_lookup_type => 'OKL_ACCRUAL_RULE_LOGICAL_OP',
501: p_lookup_code => p_agnv_rec.arlo_code);

Line 504: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

500: p_lookup_type => 'OKL_ACCRUAL_RULE_LOGICAL_OP',
501: p_lookup_code => p_agnv_rec.arlo_code);
502:
503: IF (l_dummy = okl_api.g_false) THEN
504: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
505: p_msg_name => g_invalid_value,
506: p_token1 => g_col_name_token,
507: p_token1_value => 'arlo_code');
508:

Line 509: x_return_status := Okc_Api.G_RET_STS_ERROR;

505: p_msg_name => g_invalid_value,
506: p_token1 => g_col_name_token,
507: p_token1_value => 'arlo_code');
508:
509: x_return_status := Okc_Api.G_RET_STS_ERROR;
510: RAISE G_EXCEPTION_HALT_VALIDATION;
511: END IF;
512:
513: END IF;

Line 523: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

519: NULL;
520:
521: WHEN OTHERS THEN
522: -- store SQL error message on message stack for caller
523: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
524: p_msg_name => g_unexpected_error,
525: p_token1 => g_sqlcode_token,
526: p_token1_value => SQLCODE,
527: p_token2 => g_sqlerrm_token,

Line 530: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

526: p_token1_value => SQLCODE,
527: p_token2 => g_sqlerrm_token,
528: p_token2_value => SQLERRM);
529: -- notify caller of an UNEXPECTED error
530: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
531: END Validate_Arlo_Code;
532:
533: ---------------------------------------------------------------------------
534: -- PROCEDURE Validate_Acro_Code

Line 555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

551: l_dummy VARCHAR2(1);
552:
553: BEGIN
554: -- initialize return status
555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
556:
557: -- check for data before processing
558: IF (p_agnv_rec.acro_code IS NULL) OR
559: (p_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN

Line 559: (p_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN

555: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
556:
557: -- check for data before processing
558: IF (p_agnv_rec.acro_code IS NULL) OR
559: (p_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN
560: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
561: ,p_msg_name => g_required_value
562: ,p_token1 => g_col_name_token
563: ,p_token1_value => 'acro_code');

Line 560: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

556:
557: -- check for data before processing
558: IF (p_agnv_rec.acro_code IS NULL) OR
559: (p_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR) THEN
560: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
561: ,p_msg_name => g_required_value
562: ,p_token1 => g_col_name_token
563: ,p_token1_value => 'acro_code');
564: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 564: x_return_status := Okc_Api.G_RET_STS_ERROR;

560: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
561: ,p_msg_name => g_required_value
562: ,p_token1 => g_col_name_token
563: ,p_token1_value => 'acro_code');
564: x_return_status := Okc_Api.G_RET_STS_ERROR;
565: RAISE G_EXCEPTION_HALT_VALIDATION;
566: END IF;
567:
568: --Check if acro code exists in the FND_COMMON_LOOKUPS or not

Line 574: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

570: p_lookup_type => 'OKL_ACCRUAL_RULE_OPERATOR',
571: p_lookup_code => p_agnv_rec.acro_code);
572:
573: IF (l_dummy = okl_api.g_false) THEN
574: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
575: p_msg_name => g_invalid_value,
576: p_token1 => g_col_name_token,
577: p_token1_value => 'acro_code');
578: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 578: x_return_status := Okc_Api.G_RET_STS_ERROR;

574: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
575: p_msg_name => g_invalid_value,
576: p_token1 => g_col_name_token,
577: p_token1_value => 'acro_code');
578: x_return_status := Okc_Api.G_RET_STS_ERROR;
579: RAISE G_EXCEPTION_HALT_VALIDATION;
580: END IF;
581:
582: EXCEPTION

Line 590: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

586: NULL;
587:
588: WHEN OTHERS THEN
589: -- store SQL error message on message stack for caller
590: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
591: p_msg_name => g_unexpected_error,
592: p_token1 => g_sqlcode_token,
593: p_token1_value => SQLCODE,
594: p_token2 => g_sqlerrm_token,

Line 597: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

593: p_token1_value => SQLCODE,
594: p_token2 => g_sqlerrm_token,
595: p_token2_value => SQLERRM);
596: -- notify caller of an UNEXPECTED error
597: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
598: END Validate_Acro_Code;
599:
600: ---------------------------------------------------------------------------
601: -- PROCEDURE Validate_Right_Operand_Literal

Line 616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

612: PROCEDURE Validate_Right_Operand_Literal(x_return_status OUT NOCOPY VARCHAR2
613: ,p_agnv_rec IN agnv_rec_type )
614: IS
615:
616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617:
618: BEGIN
619: -- initialize return status
620: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 620: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

616: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
617:
618: BEGIN
619: -- initialize return status
620: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
621: -- check for data before processing
622: IF (p_agnv_rec.right_operand_literal IS NULL) OR
623: (p_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
624: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 623: (p_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN

619: -- initialize return status
620: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
621: -- check for data before processing
622: IF (p_agnv_rec.right_operand_literal IS NULL) OR
623: (p_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
624: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
625: ,p_msg_name => g_required_value
626: ,p_token1 => g_col_name_token
627: ,p_token1_value => 'right_operand_literal');

Line 624: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

620: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
621: -- check for data before processing
622: IF (p_agnv_rec.right_operand_literal IS NULL) OR
623: (p_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR) THEN
624: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
625: ,p_msg_name => g_required_value
626: ,p_token1 => g_col_name_token
627: ,p_token1_value => 'right_operand_literal');
628: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 628: x_return_status := Okc_Api.G_RET_STS_ERROR;

624: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
625: ,p_msg_name => g_required_value
626: ,p_token1 => g_col_name_token
627: ,p_token1_value => 'right_operand_literal');
628: x_return_status := Okc_Api.G_RET_STS_ERROR;
629: RAISE G_EXCEPTION_HALT_VALIDATION;
630: END IF;
631:
632: EXCEPTION

Line 640: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

636: NULL;
637:
638: WHEN OTHERS THEN
639: -- store SQL error message on message stack for caller
640: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
641: p_msg_name => g_unexpected_error,
642: p_token1 => g_sqlcode_token,
643: p_token1_value => SQLCODE,
644: p_token2 => g_sqlerrm_token,

Line 648: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

644: p_token2 => g_sqlerrm_token,
645: p_token2_value => SQLERRM);
646:
647: -- notify caller of an UNEXPECTED error
648: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
649:
650: END Validate_Right_Operand_Literal;
651:
652: ---------------------------------------------------------------------------

Line 668: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

664: PROCEDURE Validate_Line_Number(x_return_status OUT NOCOPY VARCHAR2
665: ,p_agnv_rec IN agnv_rec_type )
666: IS
667:
668: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
669:
670: BEGIN
671: -- initialize return status
672: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 672: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

668: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
669:
670: BEGIN
671: -- initialize return status
672: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
673: -- check for data before processing
674: IF (p_agnv_rec.line_number IS NULL) OR
675: (p_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
676: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 675: (p_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN

671: -- initialize return status
672: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
673: -- check for data before processing
674: IF (p_agnv_rec.line_number IS NULL) OR
675: (p_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
676: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
677: ,p_msg_name => g_required_value
678: ,p_token1 => g_col_name_token
679: ,p_token1_value => 'line_number');

Line 676: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

672: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
673: -- check for data before processing
674: IF (p_agnv_rec.line_number IS NULL) OR
675: (p_agnv_rec.line_number = Okc_Api.G_MISS_NUM) THEN
676: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
677: ,p_msg_name => g_required_value
678: ,p_token1 => g_col_name_token
679: ,p_token1_value => 'line_number');
680: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 680: x_return_status := Okc_Api.G_RET_STS_ERROR;

676: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
677: ,p_msg_name => g_required_value
678: ,p_token1 => g_col_name_token
679: ,p_token1_value => 'line_number');
680: x_return_status := Okc_Api.G_RET_STS_ERROR;
681: RAISE G_EXCEPTION_HALT_VALIDATION;
682: END IF;
683:
684: EXCEPTION

Line 692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

688: NULL;
689:
690: WHEN OTHERS THEN
691: -- store SQL error message on message stack for caller
692: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
693: p_msg_name => g_unexpected_error,
694: p_token1 => g_sqlcode_token,
695: p_token1_value => SQLCODE,
696: p_token2 => g_sqlerrm_token,

Line 700: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

696: p_token2 => g_sqlerrm_token,
697: p_token2_value => SQLERRM);
698:
699: -- notify caller of an UNEXPECTED error
700: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
701:
702: END Validate_Line_Number;
703:
704: ---------------------------------------------------------------------------

Line 720: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

716: PROCEDURE Validate_Version(x_return_status OUT NOCOPY VARCHAR2
717: ,p_agnv_rec IN agnv_rec_type )
718: IS
719:
720: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
721:
722: BEGIN
723: -- initialize return status
724: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 724: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

720: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
721:
722: BEGIN
723: -- initialize return status
724: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
725: -- check for data before processing
726: IF (p_agnv_rec.version IS NULL) OR
727: (p_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
728: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 727: (p_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN

723: -- initialize return status
724: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
725: -- check for data before processing
726: IF (p_agnv_rec.version IS NULL) OR
727: (p_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
728: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
729: ,p_msg_name => g_required_value
730: ,p_token1 => g_col_name_token
731: ,p_token1_value => 'version');

Line 728: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

724: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
725: -- check for data before processing
726: IF (p_agnv_rec.version IS NULL) OR
727: (p_agnv_rec.version = Okc_Api.G_MISS_CHAR) THEN
728: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
729: ,p_msg_name => g_required_value
730: ,p_token1 => g_col_name_token
731: ,p_token1_value => 'version');
732: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 732: x_return_status := Okc_Api.G_RET_STS_ERROR;

728: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
729: ,p_msg_name => g_required_value
730: ,p_token1 => g_col_name_token
731: ,p_token1_value => 'version');
732: x_return_status := Okc_Api.G_RET_STS_ERROR;
733: RAISE G_EXCEPTION_HALT_VALIDATION;
734: END IF;
735:
736: EXCEPTION

Line 744: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

740: NULL;
741:
742: WHEN OTHERS THEN
743: -- store SQL error message on message stack for caller
744: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
745: p_msg_name => g_unexpected_error,
746: p_token1 => g_sqlcode_token,
747: p_token1_value => SQLCODE,
748: p_token2 => g_sqlerrm_token,

Line 752: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

748: p_token2 => g_sqlerrm_token,
749: p_token2_value => SQLERRM);
750:
751: -- notify caller of an UNEXPECTED error
752: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
753:
754: END Validate_Version;
755:
756: ---------------------------------------------------------------------------

Line 776: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

772: l_dummy VARCHAR2(1);
773:
774: BEGIN
775: -- initialize return status
776: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
777: IF (p_agnv_rec.left_parentheses IS NOT NULL) AND
778: (p_agnv_rec.left_parentheses <> OKC_API.G_MISS_CHAR) THEN
779: --Check if left parentheses exists in the FND_COMMON_LOOKUPS or not
780: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE (

Line 778: (p_agnv_rec.left_parentheses <> OKC_API.G_MISS_CHAR) THEN

774: BEGIN
775: -- initialize return status
776: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
777: IF (p_agnv_rec.left_parentheses IS NOT NULL) AND
778: (p_agnv_rec.left_parentheses <> OKC_API.G_MISS_CHAR) THEN
779: --Check if left parentheses exists in the FND_COMMON_LOOKUPS or not
780: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE (
781: p_lookup_type => 'OKL_PARENTHESIS',
782: p_lookup_code => p_agnv_rec.left_parentheses);

Line 785: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

781: p_lookup_type => 'OKL_PARENTHESIS',
782: p_lookup_code => p_agnv_rec.left_parentheses);
783:
784: IF l_dummy = okl_api.g_false THEN
785: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
786: p_msg_name => g_invalid_value,
787: p_token1 => g_col_name_token,
788: p_token1_value => 'left_parentheses');
789: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 789: x_return_status := Okc_Api.G_RET_STS_ERROR;

785: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
786: p_msg_name => g_invalid_value,
787: p_token1 => g_col_name_token,
788: p_token1_value => 'left_parentheses');
789: x_return_status := Okc_Api.G_RET_STS_ERROR;
790: RAISE G_EXCEPTION_HALT_VALIDATION;
791: END IF;
792: END IF;
793:

Line 802: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

798: NULL;
799:
800: WHEN OTHERS THEN
801: -- store SQL error message on message stack for caller
802: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
803: p_msg_name => g_unexpected_error,
804: p_token1 => g_sqlcode_token,
805: p_token1_value => SQLCODE,
806: p_token2 => g_sqlerrm_token,

Line 809: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

805: p_token1_value => SQLCODE,
806: p_token2 => g_sqlerrm_token,
807: p_token2_value => SQLERRM);
808: -- notify caller of an UNEXPECTED error
809: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
810: END Validate_Left_Parentheses;
811:
812: ---------------------------------------------------------------------------
813: -- PROCEDURE Validate_Right_Parentheses

Line 832: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

828: l_dummy VARCHAR2(1);
829:
830: BEGIN
831: -- initialize return status
832: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
833:
834: IF (p_agnv_rec.right_parentheses IS NOT NULL) AND
835: (p_agnv_rec.right_parentheses <> OKC_API.G_MISS_CHAR) THEN
836: --Check if right parentheses exists in the FND_COMMON_LOOKUPS or not

Line 835: (p_agnv_rec.right_parentheses <> OKC_API.G_MISS_CHAR) THEN

831: -- initialize return status
832: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
833:
834: IF (p_agnv_rec.right_parentheses IS NOT NULL) AND
835: (p_agnv_rec.right_parentheses <> OKC_API.G_MISS_CHAR) THEN
836: --Check if right parentheses exists in the FND_COMMON_LOOKUPS or not
837: l_dummy := OKL_ACCOUNTING_UTIL.VALIDATE_LOOKUP_CODE (
838: p_lookup_type => 'OKL_PARENTHESIS',
839: p_lookup_code => p_agnv_rec.right_parentheses);

Line 842: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

838: p_lookup_type => 'OKL_PARENTHESIS',
839: p_lookup_code => p_agnv_rec.right_parentheses);
840:
841: IF l_dummy = okl_api.g_false THEN
842: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
843: p_msg_name => g_invalid_value,
844: p_token1 => g_col_name_token,
845: p_token1_value => 'right_parentheses');
846: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 846: x_return_status := Okc_Api.G_RET_STS_ERROR;

842: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
843: p_msg_name => g_invalid_value,
844: p_token1 => g_col_name_token,
845: p_token1_value => 'right_parentheses');
846: x_return_status := Okc_Api.G_RET_STS_ERROR;
847: RAISE G_EXCEPTION_HALT_VALIDATION;
848: END IF;
849: END IF;
850: EXCEPTION

Line 858: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

854: NULL;
855:
856: WHEN OTHERS THEN
857: -- store SQL error message on message stack for caller
858: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
859: p_msg_name => g_unexpected_error,
860: p_token1 => g_sqlcode_token,
861: p_token1_value => SQLCODE,
862: p_token2 => g_sqlerrm_token,

Line 865: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

861: p_token1_value => SQLCODE,
862: p_token2 => g_sqlerrm_token,
863: p_token2_value => SQLERRM);
864: -- notify caller of an UNEXPECTED error
865: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
866: END Validate_Right_Parentheses;
867:
868: ---------------------------------------------------------------------------
869: -- PROCEDURE Validate_From_Date

Line 884: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

880: PROCEDURE Validate_From_Date(x_return_status OUT NOCOPY VARCHAR2
881: ,p_agnv_rec IN agnv_rec_type )
882: IS
883:
884: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
885:
886: BEGIN
887: -- initialize return status
888: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 888: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

884: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
885:
886: BEGIN
887: -- initialize return status
888: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
889: -- check for data before processing
890: IF (p_agnv_rec.from_date IS NULL) OR
891: (p_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
892: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

Line 891: (p_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN

887: -- initialize return status
888: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
889: -- check for data before processing
890: IF (p_agnv_rec.from_date IS NULL) OR
891: (p_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
892: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
893: ,p_msg_name => g_required_value
894: ,p_token1 => g_col_name_token
895: ,p_token1_value => 'from_date');

Line 892: Okc_Api.SET_MESSAGE(p_app_name => g_app_name

888: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
889: -- check for data before processing
890: IF (p_agnv_rec.from_date IS NULL) OR
891: (p_agnv_rec.from_date = Okc_Api.G_MISS_DATE) THEN
892: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
893: ,p_msg_name => g_required_value
894: ,p_token1 => g_col_name_token
895: ,p_token1_value => 'from_date');
896: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 896: x_return_status := Okc_Api.G_RET_STS_ERROR;

892: Okc_Api.SET_MESSAGE(p_app_name => g_app_name
893: ,p_msg_name => g_required_value
894: ,p_token1 => g_col_name_token
895: ,p_token1_value => 'from_date');
896: x_return_status := Okc_Api.G_RET_STS_ERROR;
897: RAISE G_EXCEPTION_HALT_VALIDATION;
898: END IF;
899: EXCEPTION
900: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 907: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

903: NULL;
904:
905: WHEN OTHERS THEN
906: -- store SQL error message on message stack for caller
907: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
908: p_msg_name => g_unexpected_error,
909: p_token1 => g_sqlcode_token,
910: p_token1_value => SQLCODE,
911: p_token2 => g_sqlerrm_token,

Line 915: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

911: p_token2 => g_sqlerrm_token,
912: p_token2_value => SQLERRM);
913:
914: -- notify caller of an UNEXPECTED error
915: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
916:
917: END Validate_From_Date;
918:
919:

Line 936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

932: PROCEDURE Validate_To_Date(x_return_status OUT NOCOPY VARCHAR2
933: ,p_agnv_rec IN agnv_rec_type )
934: IS
935:
936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
937:
938: BEGIN
939: -- initialize return status
940: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

Line 940: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

936: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
937:
938: BEGIN
939: -- initialize return status
940: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
941: IF (p_agnv_rec.to_date IS NOT NULL) AND
942: (p_agnv_rec.to_date <> OKC_API.G_MISS_DATE) THEN
943: IF p_agnv_rec.to_date < p_agnv_rec.from_date THEN
944: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

Line 942: (p_agnv_rec.to_date <> OKC_API.G_MISS_DATE) THEN

938: BEGIN
939: -- initialize return status
940: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
941: IF (p_agnv_rec.to_date IS NOT NULL) AND
942: (p_agnv_rec.to_date <> OKC_API.G_MISS_DATE) THEN
943: IF p_agnv_rec.to_date < p_agnv_rec.from_date THEN
944: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
945: p_msg_name => g_invalid_value,
946: p_token1 => g_col_name_token,

Line 944: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

940: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
941: IF (p_agnv_rec.to_date IS NOT NULL) AND
942: (p_agnv_rec.to_date <> OKC_API.G_MISS_DATE) THEN
943: IF p_agnv_rec.to_date < p_agnv_rec.from_date THEN
944: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
945: p_msg_name => g_invalid_value,
946: p_token1 => g_col_name_token,
947: p_token1_value => 'to_date');
948: x_return_status := Okc_Api.G_RET_STS_ERROR;

Line 948: x_return_status := Okc_Api.G_RET_STS_ERROR;

944: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
945: p_msg_name => g_invalid_value,
946: p_token1 => g_col_name_token,
947: p_token1_value => 'to_date');
948: x_return_status := Okc_Api.G_RET_STS_ERROR;
949: RAISE G_EXCEPTION_HALT_VALIDATION;
950: END IF;
951: END IF;
952: EXCEPTION

Line 960: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

956: NULL;
957:
958: WHEN OTHERS THEN
959: -- store SQL error message on message stack for caller
960: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
961: p_msg_name => g_unexpected_error,
962: p_token1 => g_sqlcode_token,
963: p_token1_value => SQLCODE,
964: p_token2 => g_sqlerrm_token,

Line 968: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

964: p_token2 => g_sqlerrm_token,
965: p_token2_value => SQLERRM);
966:
967: -- notify caller of an UNEXPECTED error
968: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
969:
970: END Validate_To_Date;
971:
972: ---------------------------------------------------------------------------

Line 1008: x_return_status := Okc_Api.G_RET_STS_SUCCESS;

1004:
1005: BEGIN
1006:
1007: -- initialize return status
1008: x_return_status := Okc_Api.G_RET_STS_SUCCESS;
1009:
1010: OPEN unique_agn_csr(p_agnv_rec.line_number,
1011: p_agnv_rec.version, p_agnv_rec.org_id, p_agnv_rec.id);
1012: FETCH unique_agn_csr INTO l_dummy;

Line 1016: Okc_Api.set_message(G_APP_NAME,G_UNQS);

1012: FETCH unique_agn_csr INTO l_dummy;
1013: l_row_found := unique_agn_csr%FOUND;
1014: CLOSE unique_agn_csr;
1015: IF l_row_found THEN
1016: Okc_Api.set_message(G_APP_NAME,G_UNQS);
1017: x_return_status := Okc_Api.G_RET_STS_ERROR;
1018: END IF;
1019:
1020: EXCEPTION

Line 1017: x_return_status := Okc_Api.G_RET_STS_ERROR;

1013: l_row_found := unique_agn_csr%FOUND;
1014: CLOSE unique_agn_csr;
1015: IF l_row_found THEN
1016: Okc_Api.set_message(G_APP_NAME,G_UNQS);
1017: x_return_status := Okc_Api.G_RET_STS_ERROR;
1018: END IF;
1019:
1020: EXCEPTION
1021: WHEN G_EXCEPTION_HALT_VALIDATION THEN

Line 1028: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1024: NULL;
1025:
1026: WHEN OTHERS THEN
1027: -- store SQL error message on message stack for caller
1028: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1029: p_msg_name => g_unexpected_error,
1030: p_token1 => g_sqlcode_token,
1031: p_token1_value => SQLCODE,
1032: p_token2 => g_sqlerrm_token,

Line 1036: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1032: p_token2 => g_sqlerrm_token,
1033: p_token2_value => SQLERRM);
1034:
1035: -- notify caller of an UNEXPECTED error
1036: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1037:
1038: END Validate_Unique_Agn_Record;
1039:
1040:

Line 1058: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1054: FUNCTION Validate_Attributes (
1055: p_agnv_rec IN agnv_rec_type
1056: ) RETURN VARCHAR2 IS
1057:
1058: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1059: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1060: BEGIN
1061:
1062: -- call each column-level validation

Line 1059: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1055: p_agnv_rec IN agnv_rec_type
1056: ) RETURN VARCHAR2 IS
1057:
1058: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1059: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1060: BEGIN
1061:
1062: -- call each column-level validation
1063:

Line 1067: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1063:
1064: -- Validate_Id
1065: Validate_Id(x_return_status, p_agnv_rec );
1066: -- store the highest degree of error
1067: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1068: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1069: -- need to leave
1070: l_return_status := x_return_status;
1071: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1068: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1064: -- Validate_Id
1065: Validate_Id(x_return_status, p_agnv_rec );
1066: -- store the highest degree of error
1067: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1068: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1069: -- need to leave
1070: l_return_status := x_return_status;
1071: RAISE G_EXCEPTION_HALT_VALIDATION;
1072: ELSE

Line 1081: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1077:
1078: -- Validate_Object_Version_Number
1079: Validate_Object_Version_Number(x_return_status, p_agnv_rec );
1080: -- store the highest degree of error
1081: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1082: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1083: -- need to leave
1084: l_return_status := x_return_status;
1085: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1082: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1078: -- Validate_Object_Version_Number
1079: Validate_Object_Version_Number(x_return_status, p_agnv_rec );
1080: -- store the highest degree of error
1081: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1082: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1083: -- need to leave
1084: l_return_status := x_return_status;
1085: RAISE G_EXCEPTION_HALT_VALIDATION;
1086: ELSE

Line 1095: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1091:
1092: -- Validate_Line_Number
1093: Validate_Line_Number(x_return_status, p_agnv_rec );
1094: -- store the highest degree of error
1095: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1096: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1097: -- need to leave
1098: l_return_status := x_return_status;
1099: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1096: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1092: -- Validate_Line_Number
1093: Validate_Line_Number(x_return_status, p_agnv_rec );
1094: -- store the highest degree of error
1095: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1096: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1097: -- need to leave
1098: l_return_status := x_return_status;
1099: RAISE G_EXCEPTION_HALT_VALIDATION;
1100: ELSE

Line 1109: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1105:
1106: -- Validate_Version
1107: Validate_Version(x_return_status, p_agnv_rec );
1108: -- store the highest degree of error
1109: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1110: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: -- need to leave
1112: l_return_status := x_return_status;
1113: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1110: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1106: -- Validate_Version
1107: Validate_Version(x_return_status, p_agnv_rec );
1108: -- store the highest degree of error
1109: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1110: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1111: -- need to leave
1112: l_return_status := x_return_status;
1113: RAISE G_EXCEPTION_HALT_VALIDATION;
1114: ELSE

Line 1123: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1119:
1120: -- Validate_Aro_Code
1121: Validate_Aro_Code(x_return_status, p_agnv_rec );
1122: -- store the highest degree of error
1123: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1124: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1125: -- need to leave
1126: l_return_status := x_return_status;
1127: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1124: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1120: -- Validate_Aro_Code
1121: Validate_Aro_Code(x_return_status, p_agnv_rec );
1122: -- store the highest degree of error
1123: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1124: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1125: -- need to leave
1126: l_return_status := x_return_status;
1127: RAISE G_EXCEPTION_HALT_VALIDATION;
1128: ELSE

Line 1137: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

1133:
1134: -- Validate_Arlo_Code
1135: Validate_Arlo_Code(x_return_status, p_agnv_rec );
1136: -- store the highest degree of error
1137: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1138: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1139: -- need to leave
1140: l_return_status := x_return_status;
1141: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1138: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1134: -- Validate_Arlo_Code
1135: Validate_Arlo_Code(x_return_status, p_agnv_rec );
1136: -- store the highest degree of error
1137: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
1138: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1139: -- need to leave
1140: l_return_status := x_return_status;
1141: RAISE G_EXCEPTION_HALT_VALIDATION;
1142: ELSE

Line 1151: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1147:
1148: -- Validate_Acro_Code
1149: Validate_Acro_Code(x_return_status, p_agnv_rec );
1150: -- store the highest degree of error
1151: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1152: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1153: -- need to leave
1154: l_return_status := x_return_status;
1155: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1152: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1148: -- Validate_Acro_Code
1149: Validate_Acro_Code(x_return_status, p_agnv_rec );
1150: -- store the highest degree of error
1151: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1152: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1153: -- need to leave
1154: l_return_status := x_return_status;
1155: RAISE G_EXCEPTION_HALT_VALIDATION;
1156: ELSE

Line 1165: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1161:
1162: -- Validate_Right_Operand_Literal
1163: Validate_Right_Operand_Literal(x_return_status, p_agnv_rec );
1164: -- store the highest degree of error
1165: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1166: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1167: -- need to leave
1168: l_return_status := x_return_status;
1169: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1166: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1162: -- Validate_Right_Operand_Literal
1163: Validate_Right_Operand_Literal(x_return_status, p_agnv_rec );
1164: -- store the highest degree of error
1165: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1166: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1167: -- need to leave
1168: l_return_status := x_return_status;
1169: RAISE G_EXCEPTION_HALT_VALIDATION;
1170: ELSE

Line 1179: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1175:
1176: -- Validate_Left_Parentheses
1177: Validate_Left_Parentheses(x_return_status, p_agnv_rec );
1178: -- store the highest degree of error
1179: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1180: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: -- need to leave
1182: l_return_status := x_return_status;
1183: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1180: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1176: -- Validate_Left_Parentheses
1177: Validate_Left_Parentheses(x_return_status, p_agnv_rec );
1178: -- store the highest degree of error
1179: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1180: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1181: -- need to leave
1182: l_return_status := x_return_status;
1183: RAISE G_EXCEPTION_HALT_VALIDATION;
1184: ELSE

Line 1193: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1189:
1190: -- Validate_Right_Parentheses
1191: Validate_Right_Parentheses(x_return_status, p_agnv_rec );
1192: -- store the highest degree of error
1193: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1194: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1195: -- need to leave
1196: l_return_status := x_return_status;
1197: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1194: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1190: -- Validate_Right_Parentheses
1191: Validate_Right_Parentheses(x_return_status, p_agnv_rec );
1192: -- store the highest degree of error
1193: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1194: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1195: -- need to leave
1196: l_return_status := x_return_status;
1197: RAISE G_EXCEPTION_HALT_VALIDATION;
1198: ELSE

Line 1207: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1203:
1204: -- Validate_From_Date
1205: Validate_From_Date(x_return_status, p_agnv_rec );
1206: -- store the highest degree of error
1207: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1208: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1209: -- need to leave
1210: l_return_status := x_return_status;
1211: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1208: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1204: -- Validate_From_Date
1205: Validate_From_Date(x_return_status, p_agnv_rec );
1206: -- store the highest degree of error
1207: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1208: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1209: -- need to leave
1210: l_return_status := x_return_status;
1211: RAISE G_EXCEPTION_HALT_VALIDATION;
1212: ELSE

Line 1222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1218:
1219: -- Validate_To_Date
1220: Validate_To_Date(x_return_status, p_agnv_rec );
1221: -- store the highest degree of error
1222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1223: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1224: -- need to leave
1225: l_return_status := x_return_status;
1226: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1223: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1219: -- Validate_To_Date
1220: Validate_To_Date(x_return_status, p_agnv_rec );
1221: -- store the highest degree of error
1222: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1223: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1224: -- need to leave
1225: l_return_status := x_return_status;
1226: RAISE G_EXCEPTION_HALT_VALIDATION;
1227: ELSE

Line 1244: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1240: RETURN (l_return_status);
1241:
1242: WHEN OTHERS THEN
1243: -- store SQL error message on message stack for caller
1244: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1245: p_msg_name => g_unexpected_error,
1246: p_token1 => g_sqlcode_token,
1247: p_token1_value => SQLCODE,
1248: p_token2 => g_sqlerrm_token,

Line 1251: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1247: p_token1_value => SQLCODE,
1248: p_token2 => g_sqlerrm_token,
1249: p_token2_value => SQLERRM);
1250: -- notify caller of an UNEXPECTED error
1251: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1252: RETURN(l_return_status);
1253:
1254: END Validate_Attributes;
1255:

Line 1272: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1268:
1269: FUNCTION Validate_Record (
1270: p_agnv_rec IN agnv_rec_type
1271: ) RETURN VARCHAR2 IS
1272: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1273: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1274: BEGIN
1275:
1276: -- Validate_Unique_Agn_Record

Line 1273: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1269: FUNCTION Validate_Record (
1270: p_agnv_rec IN agnv_rec_type
1271: ) RETURN VARCHAR2 IS
1272: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1273: x_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1274: BEGIN
1275:
1276: -- Validate_Unique_Agn_Record
1277: Validate_Unique_Agn_Record(x_return_status, p_agnv_rec );

Line 1279: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN

1275:
1276: -- Validate_Unique_Agn_Record
1277: Validate_Unique_Agn_Record(x_return_status, p_agnv_rec );
1278: -- store the highest degree of error
1279: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1280: IF (x_return_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1281: -- need to leave
1282: l_return_status := x_return_status;
1283: RAISE G_EXCEPTION_HALT_VALIDATION;

Line 1280: IF (x_return_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1276: -- Validate_Unique_Agn_Record
1277: Validate_Unique_Agn_Record(x_return_status, p_agnv_rec );
1278: -- store the highest degree of error
1279: IF (x_return_status <> Okc_Api.G_RET_STS_SUCCESS) THEN
1280: IF (x_return_status <> Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1281: -- need to leave
1282: l_return_status := x_return_status;
1283: RAISE G_EXCEPTION_HALT_VALIDATION;
1284: ELSE

Line 1301: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,

1297: RETURN (l_return_status);
1298:
1299: WHEN OTHERS THEN
1300: -- store SQL error message on message stack for caller
1301: Okc_Api.SET_MESSAGE(p_app_name => g_app_name,
1302: p_msg_name => g_unexpected_error,
1303: p_token1 => g_sqlcode_token,
1304: p_token1_value => SQLCODE,
1305: p_token2 => g_sqlerrm_token,

Line 1309: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

1305: p_token2 => g_sqlerrm_token,
1306: p_token2_value => SQLERRM);
1307:
1308: -- notify caller of an UNEXPECTED error
1309: x_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
1310:
1311: END Validate_Record;
1312:
1313: /************************ END HAND CODING **********************************/

Line 1375: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1371: -- validate_row for:OKL_ACCRUAL_GNRTNS_V --
1372: -------------------------------------------
1373: PROCEDURE validate_row(
1374: p_api_version IN NUMBER,
1375: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1376: x_return_status OUT NOCOPY VARCHAR2,
1377: x_msg_count OUT NOCOPY NUMBER,
1378: x_msg_data OUT NOCOPY VARCHAR2,
1379: p_agnv_rec IN agnv_rec_type) IS

Line 1383: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1379: p_agnv_rec IN agnv_rec_type) IS
1380:
1381: l_api_version CONSTANT NUMBER := 1;
1382: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
1383: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1384: l_agnv_rec agnv_rec_type := p_agnv_rec;
1385: l_agn_rec agn_rec_type;
1386: BEGIN
1387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 1387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1383: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1384: l_agnv_rec agnv_rec_type := p_agnv_rec;
1385: l_agn_rec agn_rec_type;
1386: BEGIN
1387: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1388: G_PKG_NAME,
1389: p_init_msg_list,
1390: l_api_version,
1391: p_api_version,

Line 1394: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1390: l_api_version,
1391: p_api_version,
1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okc_Api.G_EXCEPTION_ERROR;
1398: END IF;

Line 1395: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1391: p_api_version,
1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okc_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: --- Validate all non-missing attributes (Item Level Validation)

Line 1396: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1392: '_PVT',
1393: x_return_status);
1394: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okc_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: --- Validate all non-missing attributes (Item Level Validation)
1400: l_return_status := Validate_Attributes(l_agnv_rec);

Line 1397: RAISE Okc_Api.G_EXCEPTION_ERROR;

1393: x_return_status);
1394: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1395: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1396: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1397: RAISE Okc_Api.G_EXCEPTION_ERROR;
1398: END IF;
1399: --- Validate all non-missing attributes (Item Level Validation)
1400: l_return_status := Validate_Attributes(l_agnv_rec);
1401: --- If any errors happen abort API

Line 1402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1398: END IF;
1399: --- Validate all non-missing attributes (Item Level Validation)
1400: l_return_status := Validate_Attributes(l_agnv_rec);
1401: --- If any errors happen abort API
1402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;

Line 1403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1399: --- Validate all non-missing attributes (Item Level Validation)
1400: l_return_status := Validate_Attributes(l_agnv_rec);
1401: --- If any errors happen abort API
1402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);

Line 1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1400: l_return_status := Validate_Attributes(l_agnv_rec);
1401: --- If any errors happen abort API
1402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1405: RAISE Okc_Api.G_EXCEPTION_ERROR;

1401: --- If any errors happen abort API
1402: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1403: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1404: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;

Line 1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1405: RAISE Okc_Api.G_EXCEPTION_ERROR;
1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1406: END IF;
1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1414: EXCEPTION

Line 1411: RAISE Okc_Api.G_EXCEPTION_ERROR;

1407: l_return_status := Validate_Record(l_agnv_rec);
1408: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1414: EXCEPTION
1415: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1409: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1414: EXCEPTION
1415: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1416: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1417: (

Line 1415: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1411: RAISE Okc_Api.G_EXCEPTION_ERROR;
1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1414: EXCEPTION
1415: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1416: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,

Line 1416: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1412: END IF;
1413: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1414: EXCEPTION
1415: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1416: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,
1420: 'OKC_API.G_RET_STS_ERROR',

Line 1420: 'OKC_API.G_RET_STS_ERROR',

1416: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1417: (
1418: l_api_name,
1419: G_PKG_NAME,
1420: 'OKC_API.G_RET_STS_ERROR',
1421: x_msg_count,
1422: x_msg_data,
1423: '_PVT'
1424: );

Line 1425: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1421: x_msg_count,
1422: x_msg_data,
1423: '_PVT'
1424: );
1425: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1426: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,

Line 1426: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1422: x_msg_data,
1423: '_PVT'
1424: );
1425: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1426: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1426: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1427: (
1428: l_api_name,
1429: G_PKG_NAME,
1430: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1431: x_msg_count,
1432: x_msg_data,
1433: '_PVT'
1434: );

Line 1436: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1432: x_msg_data,
1433: '_PVT'
1434: );
1435: WHEN OTHERS THEN
1436: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1437: (
1438: l_api_name,
1439: G_PKG_NAME,
1440: 'OTHERS',

Line 1451: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1447: -- PL/SQL TBL validate_row for:AGNV_TBL --
1448: ------------------------------------------
1449: PROCEDURE validate_row(
1450: p_api_version IN NUMBER,
1451: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1452: x_return_status OUT NOCOPY VARCHAR2,
1453: x_msg_count OUT NOCOPY NUMBER,
1454: x_msg_data OUT NOCOPY VARCHAR2,
1455: p_agnv_tbl IN agnv_tbl_type) IS

Line 1459: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1455: p_agnv_tbl IN agnv_tbl_type) IS
1456:
1457: l_api_version CONSTANT NUMBER := 1;
1458: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1459: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1460: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1461: i NUMBER := 0;
1462: BEGIN
1463: Okc_Api.init_msg_list(p_init_msg_list);

Line 1460: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1456:
1457: l_api_version CONSTANT NUMBER := 1;
1458: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1459: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1460: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1461: i NUMBER := 0;
1462: BEGIN
1463: Okc_Api.init_msg_list(p_init_msg_list);
1464: -- Make sure PL/SQL table has records in it before passing

Line 1463: Okc_Api.init_msg_list(p_init_msg_list);

1459: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1460: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1461: i NUMBER := 0;
1462: BEGIN
1463: Okc_Api.init_msg_list(p_init_msg_list);
1464: -- Make sure PL/SQL table has records in it before passing
1465: IF (p_agnv_tbl.COUNT > 0) THEN
1466: i := p_agnv_tbl.FIRST;
1467: LOOP

Line 1470: p_init_msg_list => Okc_Api.G_FALSE,

1466: i := p_agnv_tbl.FIRST;
1467: LOOP
1468: validate_row (
1469: p_api_version => p_api_version,
1470: p_init_msg_list => Okc_Api.G_FALSE,
1471: x_return_status => x_return_status,
1472: x_msg_count => x_msg_count,
1473: x_msg_data => x_msg_data,
1474: p_agnv_rec => p_agnv_tbl(i));

Line 1477: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1473: x_msg_data => x_msg_data,
1474: p_agnv_rec => p_agnv_tbl(i));
1475: /* Begin Post Generation Change */
1476: -- store the highest degree of error
1477: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1478: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1479: l_overall_status := x_return_status;
1480: END IF;
1481: END IF;

Line 1478: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1474: p_agnv_rec => p_agnv_tbl(i));
1475: /* Begin Post Generation Change */
1476: -- store the highest degree of error
1477: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1478: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1479: l_overall_status := x_return_status;
1480: END IF;
1481: END IF;
1482: /* End Post Generation Change */

Line 1488: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1484: i := p_agnv_tbl.NEXT(i);
1485: END LOOP;
1486: END IF;
1487: EXCEPTION
1488: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1490: (
1491: l_api_name,
1492: G_PKG_NAME,

Line 1489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1485: END LOOP;
1486: END IF;
1487: EXCEPTION
1488: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1490: (
1491: l_api_name,
1492: G_PKG_NAME,
1493: 'OKC_API.G_RET_STS_ERROR',

Line 1493: 'OKC_API.G_RET_STS_ERROR',

1489: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1490: (
1491: l_api_name,
1492: G_PKG_NAME,
1493: 'OKC_API.G_RET_STS_ERROR',
1494: x_msg_count,
1495: x_msg_data,
1496: '_PVT'
1497: );

Line 1498: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1494: x_msg_count,
1495: x_msg_data,
1496: '_PVT'
1497: );
1498: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1499: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,

Line 1499: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1495: x_msg_data,
1496: '_PVT'
1497: );
1498: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1499: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1503: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1499: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1500: (
1501: l_api_name,
1502: G_PKG_NAME,
1503: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1504: x_msg_count,
1505: x_msg_data,
1506: '_PVT'
1507: );

Line 1509: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1505: x_msg_data,
1506: '_PVT'
1507: );
1508: WHEN OTHERS THEN
1509: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1510: (
1511: l_api_name,
1512: G_PKG_NAME,
1513: 'OTHERS',

Line 1527: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1523: ---------------------------------------
1524: -- insert_row for:OKL_ACCRUAL_GNRTNS --
1525: ---------------------------------------
1526: PROCEDURE insert_row(
1527: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1528: x_return_status OUT NOCOPY VARCHAR2,
1529: x_msg_count OUT NOCOPY NUMBER,
1530: x_msg_data OUT NOCOPY VARCHAR2,
1531: p_agn_rec IN agn_rec_type,

Line 1536: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1532: x_agn_rec OUT NOCOPY agn_rec_type) IS
1533:
1534: l_api_version CONSTANT NUMBER := 1;
1535: l_api_name CONSTANT VARCHAR2(30) := 'GNRTNS_insert_row';
1536: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1537: l_agn_rec agn_rec_type := p_agn_rec;
1538: l_def_agn_rec agn_rec_type;
1539: -------------------------------------------
1540: -- Set_Attributes for:OKL_ACCRUAL_GNRTNS --

Line 1546: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1542: FUNCTION Set_Attributes (
1543: p_agn_rec IN agn_rec_type,
1544: x_agn_rec OUT NOCOPY agn_rec_type
1545: ) RETURN VARCHAR2 IS
1546: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1547: BEGIN
1548: x_agn_rec := p_agn_rec;
1549: RETURN(l_return_status);
1550: END Set_Attributes;

Line 1552: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1548: x_agn_rec := p_agn_rec;
1549: RETURN(l_return_status);
1550: END Set_Attributes;
1551: BEGIN
1552: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1553: p_init_msg_list,
1554: '_PVT',
1555: x_return_status);
1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1552: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1553: p_init_msg_list,
1554: '_PVT',
1555: x_return_status);
1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1559: RAISE Okc_Api.G_EXCEPTION_ERROR;
1560: END IF;

Line 1557: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1553: p_init_msg_list,
1554: '_PVT',
1555: x_return_status);
1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1559: RAISE Okc_Api.G_EXCEPTION_ERROR;
1560: END IF;
1561: --- Setting item attributes

Line 1558: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1554: '_PVT',
1555: x_return_status);
1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1559: RAISE Okc_Api.G_EXCEPTION_ERROR;
1560: END IF;
1561: --- Setting item attributes
1562: l_return_status := Set_Attributes(

Line 1559: RAISE Okc_Api.G_EXCEPTION_ERROR;

1555: x_return_status);
1556: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1557: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1558: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1559: RAISE Okc_Api.G_EXCEPTION_ERROR;
1560: END IF;
1561: --- Setting item attributes
1562: l_return_status := Set_Attributes(
1563: p_agn_rec, -- IN

Line 1566: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1562: l_return_status := Set_Attributes(
1563: p_agn_rec, -- IN
1564: l_agn_rec); -- OUT
1565: --- If any errors happen abort API
1566: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1569: RAISE Okc_Api.G_EXCEPTION_ERROR;
1570: END IF;

Line 1567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1563: p_agn_rec, -- IN
1564: l_agn_rec); -- OUT
1565: --- If any errors happen abort API
1566: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1569: RAISE Okc_Api.G_EXCEPTION_ERROR;
1570: END IF;
1571: INSERT INTO OKL_ACCRUAL_GNRTNS(

Line 1568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1564: l_agn_rec); -- OUT
1565: --- If any errors happen abort API
1566: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1569: RAISE Okc_Api.G_EXCEPTION_ERROR;
1570: END IF;
1571: INSERT INTO OKL_ACCRUAL_GNRTNS(
1572: id,

Line 1569: RAISE Okc_Api.G_EXCEPTION_ERROR;

1565: --- If any errors happen abort API
1566: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1569: RAISE Okc_Api.G_EXCEPTION_ERROR;
1570: END IF;
1571: INSERT INTO OKL_ACCRUAL_GNRTNS(
1572: id,
1573: line_number,

Line 1611: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1607: l_agn_rec.last_update_date,
1608: l_agn_rec.last_update_login);
1609: -- Set OUT values
1610: x_agn_rec := l_agn_rec;
1611: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1612: EXCEPTION
1613: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1614: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1615: (

Line 1613: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1609: -- Set OUT values
1610: x_agn_rec := l_agn_rec;
1611: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1612: EXCEPTION
1613: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1614: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,

Line 1614: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1610: x_agn_rec := l_agn_rec;
1611: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1612: EXCEPTION
1613: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1614: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,
1618: 'OKC_API.G_RET_STS_ERROR',

Line 1618: 'OKC_API.G_RET_STS_ERROR',

1614: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1615: (
1616: l_api_name,
1617: G_PKG_NAME,
1618: 'OKC_API.G_RET_STS_ERROR',
1619: x_msg_count,
1620: x_msg_data,
1621: '_PVT'
1622: );

Line 1623: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1619: x_msg_count,
1620: x_msg_data,
1621: '_PVT'
1622: );
1623: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1624: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,

Line 1624: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1620: x_msg_data,
1621: '_PVT'
1622: );
1623: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1624: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1624: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1625: (
1626: l_api_name,
1627: G_PKG_NAME,
1628: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1629: x_msg_count,
1630: x_msg_data,
1631: '_PVT'
1632: );

Line 1634: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1630: x_msg_data,
1631: '_PVT'
1632: );
1633: WHEN OTHERS THEN
1634: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1635: (
1636: l_api_name,
1637: G_PKG_NAME,
1638: 'OTHERS',

Line 1649: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1645: -- insert_row for:OKL_ACCRUAL_GNRTNS_V --
1646: -----------------------------------------
1647: PROCEDURE insert_row(
1648: p_api_version IN NUMBER,
1649: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1650: x_return_status OUT NOCOPY VARCHAR2,
1651: x_msg_count OUT NOCOPY NUMBER,
1652: x_msg_data OUT NOCOPY VARCHAR2,
1653: p_agnv_rec IN agnv_rec_type,

Line 1658: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1654: x_agnv_rec OUT NOCOPY agnv_rec_type) IS
1655:
1656: l_api_version CONSTANT NUMBER := 1;
1657: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
1658: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1659: l_agnv_rec agnv_rec_type;
1660: l_def_agnv_rec agnv_rec_type;
1661: l_agn_rec agn_rec_type;
1662: lx_agn_rec agn_rec_type;

Line 1685: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1681: FUNCTION Set_Attributes (
1682: p_agnv_rec IN agnv_rec_type,
1683: x_agnv_rec OUT NOCOPY agnv_rec_type
1684: ) RETURN VARCHAR2 IS
1685: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1686: BEGIN
1687: x_agnv_rec := p_agnv_rec;
1688: x_agnv_rec.OBJECT_VERSION_NUMBER := 1;
1689:

Line 1696: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1692:
1693: RETURN(l_return_status);
1694: END Set_Attributes;
1695: BEGIN
1696: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1697: G_PKG_NAME,
1698: p_init_msg_list,
1699: l_api_version,
1700: p_api_version,

Line 1703: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1699: l_api_version,
1700: p_api_version,
1701: '_PVT',
1702: x_return_status);
1703: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1706: RAISE Okc_Api.G_EXCEPTION_ERROR;
1707: END IF;

Line 1704: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1700: p_api_version,
1701: '_PVT',
1702: x_return_status);
1703: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1706: RAISE Okc_Api.G_EXCEPTION_ERROR;
1707: END IF;
1708: l_agnv_rec := null_out_defaults(p_agnv_rec);

Line 1705: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1701: '_PVT',
1702: x_return_status);
1703: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1706: RAISE Okc_Api.G_EXCEPTION_ERROR;
1707: END IF;
1708: l_agnv_rec := null_out_defaults(p_agnv_rec);
1709: -- Set primary key value

Line 1706: RAISE Okc_Api.G_EXCEPTION_ERROR;

1702: x_return_status);
1703: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1705: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1706: RAISE Okc_Api.G_EXCEPTION_ERROR;
1707: END IF;
1708: l_agnv_rec := null_out_defaults(p_agnv_rec);
1709: -- Set primary key value
1710: l_agnv_rec.ID := get_seq_id;

Line 1716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1712: l_return_status := Set_Attributes(
1713: l_agnv_rec, -- IN
1714: l_def_agnv_rec); -- OUT
1715: --- If any errors happen abort API
1716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1719: RAISE Okc_Api.G_EXCEPTION_ERROR;
1720: END IF;

Line 1717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1713: l_agnv_rec, -- IN
1714: l_def_agnv_rec); -- OUT
1715: --- If any errors happen abort API
1716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1719: RAISE Okc_Api.G_EXCEPTION_ERROR;
1720: END IF;
1721: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);

Line 1718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1714: l_def_agnv_rec); -- OUT
1715: --- If any errors happen abort API
1716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1719: RAISE Okc_Api.G_EXCEPTION_ERROR;
1720: END IF;
1721: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
1722: --- Validate all non-missing attributes (Item Level Validation)

Line 1719: RAISE Okc_Api.G_EXCEPTION_ERROR;

1715: --- If any errors happen abort API
1716: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1718: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1719: RAISE Okc_Api.G_EXCEPTION_ERROR;
1720: END IF;
1721: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
1722: --- Validate all non-missing attributes (Item Level Validation)
1723: l_return_status := Validate_Attributes(l_def_agnv_rec);

Line 1725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1721: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
1722: --- Validate all non-missing attributes (Item Level Validation)
1723: l_return_status := Validate_Attributes(l_def_agnv_rec);
1724: --- If any errors happen abort API
1725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;

Line 1726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1722: --- Validate all non-missing attributes (Item Level Validation)
1723: l_return_status := Validate_Attributes(l_def_agnv_rec);
1724: --- If any errors happen abort API
1725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);

Line 1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1723: l_return_status := Validate_Attributes(l_def_agnv_rec);
1724: --- If any errors happen abort API
1725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1728: RAISE Okc_Api.G_EXCEPTION_ERROR;

1724: --- If any errors happen abort API
1725: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1727: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1734: RAISE Okc_Api.G_EXCEPTION_ERROR;
1735: END IF;

Line 1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1728: RAISE Okc_Api.G_EXCEPTION_ERROR;
1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1734: RAISE Okc_Api.G_EXCEPTION_ERROR;
1735: END IF;
1736: --------------------------------------

Line 1733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1729: END IF;
1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1734: RAISE Okc_Api.G_EXCEPTION_ERROR;
1735: END IF;
1736: --------------------------------------
1737: -- Move VIEW record to "Child" records

Line 1734: RAISE Okc_Api.G_EXCEPTION_ERROR;

1730: l_return_status := Validate_Record(l_def_agnv_rec);
1731: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1732: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1733: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1734: RAISE Okc_Api.G_EXCEPTION_ERROR;
1735: END IF;
1736: --------------------------------------
1737: -- Move VIEW record to "Child" records
1738: --------------------------------------

Line 1751: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1747: x_msg_data,
1748: l_agn_rec,
1749: lx_agn_rec
1750: );
1751: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1754: RAISE Okc_Api.G_EXCEPTION_ERROR;
1755: END IF;

Line 1752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1748: l_agn_rec,
1749: lx_agn_rec
1750: );
1751: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1754: RAISE Okc_Api.G_EXCEPTION_ERROR;
1755: END IF;
1756: migrate(lx_agn_rec, l_def_agnv_rec);

Line 1753: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1749: lx_agn_rec
1750: );
1751: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1754: RAISE Okc_Api.G_EXCEPTION_ERROR;
1755: END IF;
1756: migrate(lx_agn_rec, l_def_agnv_rec);
1757: -- Set OUT values

Line 1754: RAISE Okc_Api.G_EXCEPTION_ERROR;

1750: );
1751: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1752: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1753: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1754: RAISE Okc_Api.G_EXCEPTION_ERROR;
1755: END IF;
1756: migrate(lx_agn_rec, l_def_agnv_rec);
1757: -- Set OUT values
1758: x_agnv_rec := l_def_agnv_rec;

Line 1759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1755: END IF;
1756: migrate(lx_agn_rec, l_def_agnv_rec);
1757: -- Set OUT values
1758: x_agnv_rec := l_def_agnv_rec;
1759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1760: EXCEPTION
1761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1763: (

Line 1761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1757: -- Set OUT values
1758: x_agnv_rec := l_def_agnv_rec;
1759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1760: EXCEPTION
1761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1763: (
1764: l_api_name,
1765: G_PKG_NAME,

Line 1762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1758: x_agnv_rec := l_def_agnv_rec;
1759: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1760: EXCEPTION
1761: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1763: (
1764: l_api_name,
1765: G_PKG_NAME,
1766: 'OKC_API.G_RET_STS_ERROR',

Line 1766: 'OKC_API.G_RET_STS_ERROR',

1762: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1763: (
1764: l_api_name,
1765: G_PKG_NAME,
1766: 'OKC_API.G_RET_STS_ERROR',
1767: x_msg_count,
1768: x_msg_data,
1769: '_PVT'
1770: );

Line 1771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1767: x_msg_count,
1768: x_msg_data,
1769: '_PVT'
1770: );
1771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1773: (
1774: l_api_name,
1775: G_PKG_NAME,

Line 1772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1768: x_msg_data,
1769: '_PVT'
1770: );
1771: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1773: (
1774: l_api_name,
1775: G_PKG_NAME,
1776: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1776: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1772: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1773: (
1774: l_api_name,
1775: G_PKG_NAME,
1776: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1777: x_msg_count,
1778: x_msg_data,
1779: '_PVT'
1780: );

Line 1782: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1778: x_msg_data,
1779: '_PVT'
1780: );
1781: WHEN OTHERS THEN
1782: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1783: (
1784: l_api_name,
1785: G_PKG_NAME,
1786: 'OTHERS',

Line 1797: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1793: -- PL/SQL TBL insert_row for:AGNV_TBL --
1794: ----------------------------------------
1795: PROCEDURE insert_row(
1796: p_api_version IN NUMBER,
1797: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1798: x_return_status OUT NOCOPY VARCHAR2,
1799: x_msg_count OUT NOCOPY NUMBER,
1800: x_msg_data OUT NOCOPY VARCHAR2,
1801: p_agnv_tbl IN agnv_tbl_type,

Line 1806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1802: x_agnv_tbl OUT NOCOPY agnv_tbl_type) IS
1803:
1804: l_api_version CONSTANT NUMBER := 1;
1805: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1807: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1808: i NUMBER := 0;
1809: BEGIN
1810: Okc_Api.init_msg_list(p_init_msg_list);

Line 1807: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1803:
1804: l_api_version CONSTANT NUMBER := 1;
1805: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1807: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1808: i NUMBER := 0;
1809: BEGIN
1810: Okc_Api.init_msg_list(p_init_msg_list);
1811: -- Make sure PL/SQL table has records in it before passing

Line 1810: Okc_Api.init_msg_list(p_init_msg_list);

1806: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1807: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1808: i NUMBER := 0;
1809: BEGIN
1810: Okc_Api.init_msg_list(p_init_msg_list);
1811: -- Make sure PL/SQL table has records in it before passing
1812: IF (p_agnv_tbl.COUNT > 0) THEN
1813: i := p_agnv_tbl.FIRST;
1814: LOOP

Line 1817: p_init_msg_list => Okc_Api.G_FALSE,

1813: i := p_agnv_tbl.FIRST;
1814: LOOP
1815: insert_row (
1816: p_api_version => p_api_version,
1817: p_init_msg_list => Okc_Api.G_FALSE,
1818: x_return_status => x_return_status,
1819: x_msg_count => x_msg_count,
1820: x_msg_data => x_msg_data,
1821: p_agnv_rec => p_agnv_tbl(i),

Line 1825: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

1821: p_agnv_rec => p_agnv_tbl(i),
1822: x_agnv_rec => x_agnv_tbl(i));
1823: /* Begin Post Generation Change */
1824: -- store the highest degree of error
1825: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1826: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1827: l_overall_status := x_return_status;
1828: END IF;
1829: END IF;

Line 1826: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

1822: x_agnv_rec => x_agnv_tbl(i));
1823: /* Begin Post Generation Change */
1824: -- store the highest degree of error
1825: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
1826: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
1827: l_overall_status := x_return_status;
1828: END IF;
1829: END IF;
1830: /* End Post Generation Change */

Line 1839: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1835: END IF;
1836: x_return_status := l_overall_status;
1837:
1838: EXCEPTION
1839: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1840: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1841: (
1842: l_api_name,
1843: G_PKG_NAME,

Line 1840: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1836: x_return_status := l_overall_status;
1837:
1838: EXCEPTION
1839: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1840: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1841: (
1842: l_api_name,
1843: G_PKG_NAME,
1844: 'OKC_API.G_RET_STS_ERROR',

Line 1844: 'OKC_API.G_RET_STS_ERROR',

1840: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1841: (
1842: l_api_name,
1843: G_PKG_NAME,
1844: 'OKC_API.G_RET_STS_ERROR',
1845: x_msg_count,
1846: x_msg_data,
1847: '_PVT'
1848: );

Line 1849: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1845: x_msg_count,
1846: x_msg_data,
1847: '_PVT'
1848: );
1849: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1851: (
1852: l_api_name,
1853: G_PKG_NAME,

Line 1850: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1846: x_msg_data,
1847: '_PVT'
1848: );
1849: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1850: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1851: (
1852: l_api_name,
1853: G_PKG_NAME,
1854: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1854: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1850: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1851: (
1852: l_api_name,
1853: G_PKG_NAME,
1854: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1855: x_msg_count,
1856: x_msg_data,
1857: '_PVT'
1858: );

Line 1860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1856: x_msg_data,
1857: '_PVT'
1858: );
1859: WHEN OTHERS THEN
1860: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1861: (
1862: l_api_name,
1863: G_PKG_NAME,
1864: 'OTHERS',

Line 1878: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1874: -------------------------------------
1875: -- lock_row for:OKL_ACCRUAL_GNRTNS --
1876: -------------------------------------
1877: PROCEDURE lock_row(
1878: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1879: x_return_status OUT NOCOPY VARCHAR2,
1880: x_msg_count OUT NOCOPY NUMBER,
1881: x_msg_data OUT NOCOPY VARCHAR2,
1882: p_agn_rec IN agn_rec_type) IS

Line 1899: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1895: FROM OKL_ACCRUAL_GNRTNS
1896: WHERE ID = p_agn_rec.id;
1897: l_api_version CONSTANT NUMBER := 1;
1898: l_api_name CONSTANT VARCHAR2(30) := 'GNRTNS_lock_row';
1899: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1900: l_object_version_number OKL_ACCRUAL_GNRTNS.OBJECT_VERSION_NUMBER%TYPE;
1901: lc_object_version_number OKL_ACCRUAL_GNRTNS.OBJECT_VERSION_NUMBER%TYPE;
1902: l_row_notfound BOOLEAN := FALSE;
1903: lc_row_notfound BOOLEAN := FALSE;

Line 1905: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1901: lc_object_version_number OKL_ACCRUAL_GNRTNS.OBJECT_VERSION_NUMBER%TYPE;
1902: l_row_notfound BOOLEAN := FALSE;
1903: lc_row_notfound BOOLEAN := FALSE;
1904: BEGIN
1905: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1906: p_init_msg_list,
1907: '_PVT',
1908: x_return_status);
1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1905: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1906: p_init_msg_list,
1907: '_PVT',
1908: x_return_status);
1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1912: RAISE Okc_Api.G_EXCEPTION_ERROR;
1913: END IF;

Line 1910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

1906: p_init_msg_list,
1907: '_PVT',
1908: x_return_status);
1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1912: RAISE Okc_Api.G_EXCEPTION_ERROR;
1913: END IF;
1914: BEGIN

Line 1911: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

1907: '_PVT',
1908: x_return_status);
1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1912: RAISE Okc_Api.G_EXCEPTION_ERROR;
1913: END IF;
1914: BEGIN
1915: OPEN lock_csr(p_agn_rec);

Line 1912: RAISE Okc_Api.G_EXCEPTION_ERROR;

1908: x_return_status);
1909: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
1910: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
1911: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
1912: RAISE Okc_Api.G_EXCEPTION_ERROR;
1913: END IF;
1914: BEGIN
1915: OPEN lock_csr(p_agn_rec);
1916: FETCH lock_csr INTO l_object_version_number;

Line 1924: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1920: WHEN E_Resource_Busy THEN
1921: IF (lock_csr%ISOPEN) THEN
1922: CLOSE lock_csr;
1923: END IF;
1924: Okc_Api.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1925: RAISE App_Exceptions.RECORD_LOCK_EXCEPTION;
1926: END;
1927:
1928: IF ( l_row_notfound ) THEN

Line 1935: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1931: lc_row_notfound := lchk_csr%NOTFOUND;
1932: CLOSE lchk_csr;
1933: END IF;
1934: IF (lc_row_notfound) THEN
1935: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: ELSIF lc_object_version_number > p_agn_rec.object_version_number THEN
1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1936: RAISE Okc_Api.G_EXCEPTION_ERROR;

1932: CLOSE lchk_csr;
1933: END IF;
1934: IF (lc_row_notfound) THEN
1935: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: ELSIF lc_object_version_number > p_agn_rec.object_version_number THEN
1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;
1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN

Line 1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1934: IF (lc_row_notfound) THEN
1935: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: ELSIF lc_object_version_number > p_agn_rec.object_version_number THEN
1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;
1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN
1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1939: RAISE Okc_Api.G_EXCEPTION_ERROR;

1935: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1936: RAISE Okc_Api.G_EXCEPTION_ERROR;
1937: ELSIF lc_object_version_number > p_agn_rec.object_version_number THEN
1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;
1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN
1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;
1943: ELSIF lc_object_version_number = -1 THEN

Line 1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1937: ELSIF lc_object_version_number > p_agn_rec.object_version_number THEN
1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;
1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN
1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;
1943: ELSIF lc_object_version_number = -1 THEN
1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1945: RAISE Okc_Api.G_EXCEPTION_ERROR;

Line 1942: RAISE Okc_Api.G_EXCEPTION_ERROR;

1938: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1939: RAISE Okc_Api.G_EXCEPTION_ERROR;
1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN
1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;
1943: ELSIF lc_object_version_number = -1 THEN
1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1945: RAISE Okc_Api.G_EXCEPTION_ERROR;
1946: END IF;

Line 1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1940: ELSIF lc_object_version_number <> p_agn_rec.object_version_number THEN
1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;
1943: ELSIF lc_object_version_number = -1 THEN
1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1945: RAISE Okc_Api.G_EXCEPTION_ERROR;
1946: END IF;
1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1948: EXCEPTION

Line 1945: RAISE Okc_Api.G_EXCEPTION_ERROR;

1941: Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1942: RAISE Okc_Api.G_EXCEPTION_ERROR;
1943: ELSIF lc_object_version_number = -1 THEN
1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1945: RAISE Okc_Api.G_EXCEPTION_ERROR;
1946: END IF;
1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1948: EXCEPTION
1949: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

1943: ELSIF lc_object_version_number = -1 THEN
1944: Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1945: RAISE Okc_Api.G_EXCEPTION_ERROR;
1946: END IF;
1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1948: EXCEPTION
1949: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1950: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1951: (

Line 1949: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

1945: RAISE Okc_Api.G_EXCEPTION_ERROR;
1946: END IF;
1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1948: EXCEPTION
1949: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1950: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1951: (
1952: l_api_name,
1953: G_PKG_NAME,

Line 1950: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

1946: END IF;
1947: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
1948: EXCEPTION
1949: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
1950: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1951: (
1952: l_api_name,
1953: G_PKG_NAME,
1954: 'OKC_API.G_RET_STS_ERROR',

Line 1954: 'OKC_API.G_RET_STS_ERROR',

1950: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
1951: (
1952: l_api_name,
1953: G_PKG_NAME,
1954: 'OKC_API.G_RET_STS_ERROR',
1955: x_msg_count,
1956: x_msg_data,
1957: '_PVT'
1958: );

Line 1959: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

1955: x_msg_count,
1956: x_msg_data,
1957: '_PVT'
1958: );
1959: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1960: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1961: (
1962: l_api_name,
1963: G_PKG_NAME,

Line 1960: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1956: x_msg_data,
1957: '_PVT'
1958: );
1959: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
1960: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1961: (
1962: l_api_name,
1963: G_PKG_NAME,
1964: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1964: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1960: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1961: (
1962: l_api_name,
1963: G_PKG_NAME,
1964: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1965: x_msg_count,
1966: x_msg_data,
1967: '_PVT'
1968: );

Line 1970: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

1966: x_msg_data,
1967: '_PVT'
1968: );
1969: WHEN OTHERS THEN
1970: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
1971: (
1972: l_api_name,
1973: G_PKG_NAME,
1974: 'OTHERS',

Line 1985: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

1981: -- lock_row for:OKL_ACCRUAL_GNRTNS_V --
1982: ---------------------------------------
1983: PROCEDURE lock_row(
1984: p_api_version IN NUMBER,
1985: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
1986: x_return_status OUT NOCOPY VARCHAR2,
1987: x_msg_count OUT NOCOPY NUMBER,
1988: x_msg_data OUT NOCOPY VARCHAR2,
1989: p_agnv_rec IN agnv_rec_type) IS

Line 1993: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

1989: p_agnv_rec IN agnv_rec_type) IS
1990:
1991: l_api_version CONSTANT NUMBER := 1;
1992: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1993: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1994: l_agn_rec agn_rec_type;
1995: BEGIN
1996: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1997: G_PKG_NAME,

Line 1996: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

1992: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1993: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1994: l_agn_rec agn_rec_type;
1995: BEGIN
1996: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
1997: G_PKG_NAME,
1998: p_init_msg_list,
1999: l_api_version,
2000: p_api_version,

Line 2003: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

1999: l_api_version,
2000: p_api_version,
2001: '_PVT',
2002: x_return_status);
2003: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2006: RAISE Okc_Api.G_EXCEPTION_ERROR;
2007: END IF;

Line 2004: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2000: p_api_version,
2001: '_PVT',
2002: x_return_status);
2003: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2006: RAISE Okc_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008: --------------------------------------

Line 2005: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2001: '_PVT',
2002: x_return_status);
2003: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2006: RAISE Okc_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008: --------------------------------------
2009: -- Move VIEW record to "Child" records

Line 2006: RAISE Okc_Api.G_EXCEPTION_ERROR;

2002: x_return_status);
2003: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2006: RAISE Okc_Api.G_EXCEPTION_ERROR;
2007: END IF;
2008: --------------------------------------
2009: -- Move VIEW record to "Child" records
2010: --------------------------------------

Line 2022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2018: x_msg_count,
2019: x_msg_data,
2020: l_agn_rec
2021: );
2022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;

Line 2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2019: x_msg_data,
2020: l_agn_rec
2021: );
2022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2020: l_agn_rec
2021: );
2022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2028: EXCEPTION

Line 2025: RAISE Okc_Api.G_EXCEPTION_ERROR;

2021: );
2022: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2028: EXCEPTION
2029: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2023: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2024: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2028: EXCEPTION
2029: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2030: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2031: (

Line 2029: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2025: RAISE Okc_Api.G_EXCEPTION_ERROR;
2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2028: EXCEPTION
2029: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2030: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,

Line 2030: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2026: END IF;
2027: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2028: EXCEPTION
2029: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2030: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,
2034: 'OKC_API.G_RET_STS_ERROR',

Line 2034: 'OKC_API.G_RET_STS_ERROR',

2030: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2031: (
2032: l_api_name,
2033: G_PKG_NAME,
2034: 'OKC_API.G_RET_STS_ERROR',
2035: x_msg_count,
2036: x_msg_data,
2037: '_PVT'
2038: );

Line 2039: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2035: x_msg_count,
2036: x_msg_data,
2037: '_PVT'
2038: );
2039: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2040: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2041: (
2042: l_api_name,
2043: G_PKG_NAME,

Line 2040: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2036: x_msg_data,
2037: '_PVT'
2038: );
2039: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2040: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2041: (
2042: l_api_name,
2043: G_PKG_NAME,
2044: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2044: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2040: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2041: (
2042: l_api_name,
2043: G_PKG_NAME,
2044: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2045: x_msg_count,
2046: x_msg_data,
2047: '_PVT'
2048: );

Line 2050: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2046: x_msg_data,
2047: '_PVT'
2048: );
2049: WHEN OTHERS THEN
2050: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2051: (
2052: l_api_name,
2053: G_PKG_NAME,
2054: 'OTHERS',

Line 2065: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2061: -- PL/SQL TBL lock_row for:AGNV_TBL --
2062: --------------------------------------
2063: PROCEDURE lock_row(
2064: p_api_version IN NUMBER,
2065: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2066: x_return_status OUT NOCOPY VARCHAR2,
2067: x_msg_count OUT NOCOPY NUMBER,
2068: x_msg_data OUT NOCOPY VARCHAR2,
2069: p_agnv_tbl IN agnv_tbl_type) IS

Line 2073: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2069: p_agnv_tbl IN agnv_tbl_type) IS
2070:
2071: l_api_version CONSTANT NUMBER := 1;
2072: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2073: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2074: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2075: i NUMBER := 0;
2076: BEGIN
2077: Okc_Api.init_msg_list(p_init_msg_list);

Line 2074: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2070:
2071: l_api_version CONSTANT NUMBER := 1;
2072: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2073: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2074: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2075: i NUMBER := 0;
2076: BEGIN
2077: Okc_Api.init_msg_list(p_init_msg_list);
2078: -- Make sure PL/SQL table has records in it before passing

Line 2077: Okc_Api.init_msg_list(p_init_msg_list);

2073: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2074: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2075: i NUMBER := 0;
2076: BEGIN
2077: Okc_Api.init_msg_list(p_init_msg_list);
2078: -- Make sure PL/SQL table has records in it before passing
2079: IF (p_agnv_tbl.COUNT > 0) THEN
2080: i := p_agnv_tbl.FIRST;
2081: LOOP

Line 2084: p_init_msg_list => Okc_Api.G_FALSE,

2080: i := p_agnv_tbl.FIRST;
2081: LOOP
2082: lock_row (
2083: p_api_version => p_api_version,
2084: p_init_msg_list => Okc_Api.G_FALSE,
2085: x_return_status => x_return_status,
2086: x_msg_count => x_msg_count,
2087: x_msg_data => x_msg_data,
2088: p_agnv_rec => p_agnv_tbl(i));

Line 2091: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2087: x_msg_data => x_msg_data,
2088: p_agnv_rec => p_agnv_tbl(i));
2089: /* Begin Post Generation Change */
2090: -- store the highest degree of error
2091: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2092: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2093: l_overall_status := x_return_status;
2094: END IF;
2095: END IF;

Line 2092: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2088: p_agnv_rec => p_agnv_tbl(i));
2089: /* Begin Post Generation Change */
2090: -- store the highest degree of error
2091: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2092: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2093: l_overall_status := x_return_status;
2094: END IF;
2095: END IF;
2096: /* End Post Generation Change */

Line 2102: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2098: i := p_agnv_tbl.NEXT(i);
2099: END LOOP;
2100: END IF;
2101: EXCEPTION
2102: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2103: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,

Line 2103: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2099: END LOOP;
2100: END IF;
2101: EXCEPTION
2102: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2103: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKC_API.G_RET_STS_ERROR',

Line 2107: 'OKC_API.G_RET_STS_ERROR',

2103: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2104: (
2105: l_api_name,
2106: G_PKG_NAME,
2107: 'OKC_API.G_RET_STS_ERROR',
2108: x_msg_count,
2109: x_msg_data,
2110: '_PVT'
2111: );

Line 2112: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2108: x_msg_count,
2109: x_msg_data,
2110: '_PVT'
2111: );
2112: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2113: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,

Line 2113: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2109: x_msg_data,
2110: '_PVT'
2111: );
2112: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2113: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2117: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2113: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2114: (
2115: l_api_name,
2116: G_PKG_NAME,
2117: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2118: x_msg_count,
2119: x_msg_data,
2120: '_PVT'
2121: );

Line 2123: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2119: x_msg_data,
2120: '_PVT'
2121: );
2122: WHEN OTHERS THEN
2123: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2124: (
2125: l_api_name,
2126: G_PKG_NAME,
2127: 'OTHERS',

Line 2141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2137: ---------------------------------------
2138: -- update_row for:OKL_ACCRUAL_GNRTNS --
2139: ---------------------------------------
2140: PROCEDURE update_row(
2141: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2142: x_return_status OUT NOCOPY VARCHAR2,
2143: x_msg_count OUT NOCOPY NUMBER,
2144: x_msg_data OUT NOCOPY VARCHAR2,
2145: p_agn_rec IN agn_rec_type,

Line 2150: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2146: x_agn_rec OUT NOCOPY agn_rec_type) IS
2147:
2148: l_api_version CONSTANT NUMBER := 1;
2149: l_api_name CONSTANT VARCHAR2(30) := 'GNRTNS_update_row';
2150: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2151: l_agn_rec agn_rec_type := p_agn_rec;
2152: l_def_agn_rec agn_rec_type;
2153: l_row_notfound BOOLEAN := TRUE;
2154: ----------------------------------

Line 2163: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2159: x_agn_rec OUT NOCOPY agn_rec_type
2160: ) RETURN VARCHAR2 IS
2161: l_agn_rec agn_rec_type;
2162: l_row_notfound BOOLEAN := TRUE;
2163: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2164: BEGIN
2165: x_agn_rec := p_agn_rec;
2166: -- Get current database values
2167: l_agn_rec := get_rec(p_agn_rec, l_row_notfound);

Line 2169: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2165: x_agn_rec := p_agn_rec;
2166: -- Get current database values
2167: l_agn_rec := get_rec(p_agn_rec, l_row_notfound);
2168: IF (l_row_notfound) THEN
2169: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2170: END IF;
2171: IF (x_agn_rec.id = Okc_Api.G_MISS_NUM)
2172: THEN
2173: x_agn_rec.id := l_agn_rec.id;

Line 2171: IF (x_agn_rec.id = Okc_Api.G_MISS_NUM)

2167: l_agn_rec := get_rec(p_agn_rec, l_row_notfound);
2168: IF (l_row_notfound) THEN
2169: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2170: END IF;
2171: IF (x_agn_rec.id = Okc_Api.G_MISS_NUM)
2172: THEN
2173: x_agn_rec.id := l_agn_rec.id;
2174: END IF;
2175: IF (x_agn_rec.line_number = Okc_Api.G_MISS_NUM)

Line 2175: IF (x_agn_rec.line_number = Okc_Api.G_MISS_NUM)

2171: IF (x_agn_rec.id = Okc_Api.G_MISS_NUM)
2172: THEN
2173: x_agn_rec.id := l_agn_rec.id;
2174: END IF;
2175: IF (x_agn_rec.line_number = Okc_Api.G_MISS_NUM)
2176: THEN
2177: x_agn_rec.line_number := l_agn_rec.line_number;
2178: END IF;
2179: IF (x_agn_rec.version = Okc_Api.G_MISS_CHAR)

Line 2179: IF (x_agn_rec.version = Okc_Api.G_MISS_CHAR)

2175: IF (x_agn_rec.line_number = Okc_Api.G_MISS_NUM)
2176: THEN
2177: x_agn_rec.line_number := l_agn_rec.line_number;
2178: END IF;
2179: IF (x_agn_rec.version = Okc_Api.G_MISS_CHAR)
2180: THEN
2181: x_agn_rec.version := l_agn_rec.version;
2182: END IF;
2183: IF (x_agn_rec.aro_code = Okc_Api.G_MISS_CHAR)

Line 2183: IF (x_agn_rec.aro_code = Okc_Api.G_MISS_CHAR)

2179: IF (x_agn_rec.version = Okc_Api.G_MISS_CHAR)
2180: THEN
2181: x_agn_rec.version := l_agn_rec.version;
2182: END IF;
2183: IF (x_agn_rec.aro_code = Okc_Api.G_MISS_CHAR)
2184: THEN
2185: x_agn_rec.aro_code := l_agn_rec.aro_code;
2186: END IF;
2187: IF (x_agn_rec.arlo_code = Okc_Api.G_MISS_CHAR)

Line 2187: IF (x_agn_rec.arlo_code = Okc_Api.G_MISS_CHAR)

2183: IF (x_agn_rec.aro_code = Okc_Api.G_MISS_CHAR)
2184: THEN
2185: x_agn_rec.aro_code := l_agn_rec.aro_code;
2186: END IF;
2187: IF (x_agn_rec.arlo_code = Okc_Api.G_MISS_CHAR)
2188: THEN
2189: x_agn_rec.arlo_code := l_agn_rec.arlo_code;
2190: END IF;
2191: IF (x_agn_rec.acro_code = Okc_Api.G_MISS_CHAR)

Line 2191: IF (x_agn_rec.acro_code = Okc_Api.G_MISS_CHAR)

2187: IF (x_agn_rec.arlo_code = Okc_Api.G_MISS_CHAR)
2188: THEN
2189: x_agn_rec.arlo_code := l_agn_rec.arlo_code;
2190: END IF;
2191: IF (x_agn_rec.acro_code = Okc_Api.G_MISS_CHAR)
2192: THEN
2193: x_agn_rec.acro_code := l_agn_rec.acro_code;
2194: END IF;
2195: IF (x_agn_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)

Line 2195: IF (x_agn_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)

2191: IF (x_agn_rec.acro_code = Okc_Api.G_MISS_CHAR)
2192: THEN
2193: x_agn_rec.acro_code := l_agn_rec.acro_code;
2194: END IF;
2195: IF (x_agn_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)
2196: THEN
2197: x_agn_rec.right_operand_literal := l_agn_rec.right_operand_literal;
2198: END IF;
2199: IF (x_agn_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2199: IF (x_agn_rec.object_version_number = Okc_Api.G_MISS_NUM)

2195: IF (x_agn_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)
2196: THEN
2197: x_agn_rec.right_operand_literal := l_agn_rec.right_operand_literal;
2198: END IF;
2199: IF (x_agn_rec.object_version_number = Okc_Api.G_MISS_NUM)
2200: THEN
2201: x_agn_rec.object_version_number := l_agn_rec.object_version_number;
2202: END IF;
2203: IF (x_agn_rec.left_parentheses = Okc_Api.G_MISS_CHAR)

Line 2203: IF (x_agn_rec.left_parentheses = Okc_Api.G_MISS_CHAR)

2199: IF (x_agn_rec.object_version_number = Okc_Api.G_MISS_NUM)
2200: THEN
2201: x_agn_rec.object_version_number := l_agn_rec.object_version_number;
2202: END IF;
2203: IF (x_agn_rec.left_parentheses = Okc_Api.G_MISS_CHAR)
2204: THEN
2205: x_agn_rec.left_parentheses := l_agn_rec.left_parentheses;
2206: END IF;
2207: IF (x_agn_rec.right_parentheses = Okc_Api.G_MISS_CHAR)

Line 2207: IF (x_agn_rec.right_parentheses = Okc_Api.G_MISS_CHAR)

2203: IF (x_agn_rec.left_parentheses = Okc_Api.G_MISS_CHAR)
2204: THEN
2205: x_agn_rec.left_parentheses := l_agn_rec.left_parentheses;
2206: END IF;
2207: IF (x_agn_rec.right_parentheses = Okc_Api.G_MISS_CHAR)
2208: THEN
2209: x_agn_rec.right_parentheses := l_agn_rec.right_parentheses;
2210: END IF;
2211: IF (x_agn_rec.from_date = Okc_Api.G_MISS_DATE)

Line 2211: IF (x_agn_rec.from_date = Okc_Api.G_MISS_DATE)

2207: IF (x_agn_rec.right_parentheses = Okc_Api.G_MISS_CHAR)
2208: THEN
2209: x_agn_rec.right_parentheses := l_agn_rec.right_parentheses;
2210: END IF;
2211: IF (x_agn_rec.from_date = Okc_Api.G_MISS_DATE)
2212: THEN
2213: x_agn_rec.from_date := l_agn_rec.from_date;
2214: END IF;
2215: IF (x_agn_rec.TO_DATE = Okc_Api.G_MISS_DATE)

Line 2215: IF (x_agn_rec.TO_DATE = Okc_Api.G_MISS_DATE)

2211: IF (x_agn_rec.from_date = Okc_Api.G_MISS_DATE)
2212: THEN
2213: x_agn_rec.from_date := l_agn_rec.from_date;
2214: END IF;
2215: IF (x_agn_rec.TO_DATE = Okc_Api.G_MISS_DATE)
2216: THEN
2217: x_agn_rec.TO_DATE := l_agn_rec.TO_DATE;
2218: END IF;
2219: IF (x_agn_rec.org_id = Okc_Api.G_MISS_NUM)

Line 2219: IF (x_agn_rec.org_id = Okc_Api.G_MISS_NUM)

2215: IF (x_agn_rec.TO_DATE = Okc_Api.G_MISS_DATE)
2216: THEN
2217: x_agn_rec.TO_DATE := l_agn_rec.TO_DATE;
2218: END IF;
2219: IF (x_agn_rec.org_id = Okc_Api.G_MISS_NUM)
2220: THEN
2221: x_agn_rec.org_id := l_agn_rec.org_id;
2222: END IF;
2223: IF (x_agn_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2223: IF (x_agn_rec.created_by = Okc_Api.G_MISS_NUM)

2219: IF (x_agn_rec.org_id = Okc_Api.G_MISS_NUM)
2220: THEN
2221: x_agn_rec.org_id := l_agn_rec.org_id;
2222: END IF;
2223: IF (x_agn_rec.created_by = Okc_Api.G_MISS_NUM)
2224: THEN
2225: x_agn_rec.created_by := l_agn_rec.created_by;
2226: END IF;
2227: IF (x_agn_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2227: IF (x_agn_rec.creation_date = Okc_Api.G_MISS_DATE)

2223: IF (x_agn_rec.created_by = Okc_Api.G_MISS_NUM)
2224: THEN
2225: x_agn_rec.created_by := l_agn_rec.created_by;
2226: END IF;
2227: IF (x_agn_rec.creation_date = Okc_Api.G_MISS_DATE)
2228: THEN
2229: x_agn_rec.creation_date := l_agn_rec.creation_date;
2230: END IF;
2231: IF (x_agn_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2231: IF (x_agn_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2227: IF (x_agn_rec.creation_date = Okc_Api.G_MISS_DATE)
2228: THEN
2229: x_agn_rec.creation_date := l_agn_rec.creation_date;
2230: END IF;
2231: IF (x_agn_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2232: THEN
2233: x_agn_rec.last_updated_by := l_agn_rec.last_updated_by;
2234: END IF;
2235: IF (x_agn_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2235: IF (x_agn_rec.last_update_date = Okc_Api.G_MISS_DATE)

2231: IF (x_agn_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2232: THEN
2233: x_agn_rec.last_updated_by := l_agn_rec.last_updated_by;
2234: END IF;
2235: IF (x_agn_rec.last_update_date = Okc_Api.G_MISS_DATE)
2236: THEN
2237: x_agn_rec.last_update_date := l_agn_rec.last_update_date;
2238: END IF;
2239: IF (x_agn_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2239: IF (x_agn_rec.last_update_login = Okc_Api.G_MISS_NUM)

2235: IF (x_agn_rec.last_update_date = Okc_Api.G_MISS_DATE)
2236: THEN
2237: x_agn_rec.last_update_date := l_agn_rec.last_update_date;
2238: END IF;
2239: IF (x_agn_rec.last_update_login = Okc_Api.G_MISS_NUM)
2240: THEN
2241: x_agn_rec.last_update_login := l_agn_rec.last_update_login;
2242: END IF;
2243: RETURN(l_return_status);

Line 2252: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2248: FUNCTION Set_Attributes (
2249: p_agn_rec IN agn_rec_type,
2250: x_agn_rec OUT NOCOPY agn_rec_type
2251: ) RETURN VARCHAR2 IS
2252: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2253: BEGIN
2254: x_agn_rec := p_agn_rec;
2255: RETURN(l_return_status);
2256: END Set_Attributes;

Line 2258: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2254: x_agn_rec := p_agn_rec;
2255: RETURN(l_return_status);
2256: END Set_Attributes;
2257: BEGIN
2258: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2259: p_init_msg_list,
2260: '_PVT',
2261: x_return_status);
2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2258: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2259: p_init_msg_list,
2260: '_PVT',
2261: x_return_status);
2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2265: RAISE Okc_Api.G_EXCEPTION_ERROR;
2266: END IF;

Line 2263: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2259: p_init_msg_list,
2260: '_PVT',
2261: x_return_status);
2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2265: RAISE Okc_Api.G_EXCEPTION_ERROR;
2266: END IF;
2267: --- Setting item attributes

Line 2264: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2260: '_PVT',
2261: x_return_status);
2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2265: RAISE Okc_Api.G_EXCEPTION_ERROR;
2266: END IF;
2267: --- Setting item attributes
2268: l_return_status := Set_Attributes(

Line 2265: RAISE Okc_Api.G_EXCEPTION_ERROR;

2261: x_return_status);
2262: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2263: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2264: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2265: RAISE Okc_Api.G_EXCEPTION_ERROR;
2266: END IF;
2267: --- Setting item attributes
2268: l_return_status := Set_Attributes(
2269: p_agn_rec, -- IN

Line 2272: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2268: l_return_status := Set_Attributes(
2269: p_agn_rec, -- IN
2270: l_agn_rec); -- OUT
2271: --- If any errors happen abort API
2272: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;

Line 2273: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2269: p_agn_rec, -- IN
2270: l_agn_rec); -- OUT
2271: --- If any errors happen abort API
2272: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);

Line 2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2270: l_agn_rec); -- OUT
2271: --- If any errors happen abort API
2272: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2275: RAISE Okc_Api.G_EXCEPTION_ERROR;

2271: --- If any errors happen abort API
2272: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2273: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2274: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2280: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2281: RAISE Okc_Api.G_EXCEPTION_ERROR;
2282: END IF;

Line 2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2275: RAISE Okc_Api.G_EXCEPTION_ERROR;
2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2280: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2281: RAISE Okc_Api.G_EXCEPTION_ERROR;
2282: END IF;
2283: UPDATE OKL_ACCRUAL_GNRTNS

Line 2280: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2276: END IF;
2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2280: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2281: RAISE Okc_Api.G_EXCEPTION_ERROR;
2282: END IF;
2283: UPDATE OKL_ACCRUAL_GNRTNS
2284: SET LINE_NUMBER = l_def_agn_rec.line_number,

Line 2281: RAISE Okc_Api.G_EXCEPTION_ERROR;

2277: l_return_status := populate_new_record(l_agn_rec, l_def_agn_rec);
2278: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2279: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2280: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2281: RAISE Okc_Api.G_EXCEPTION_ERROR;
2282: END IF;
2283: UPDATE OKL_ACCRUAL_GNRTNS
2284: SET LINE_NUMBER = l_def_agn_rec.line_number,
2285: VERSION = l_def_agn_rec.version,

Line 2304: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2300: LAST_UPDATE_LOGIN = l_def_agn_rec.last_update_login
2301: WHERE ID = l_def_agn_rec.id;
2302:
2303: x_agn_rec := l_def_agn_rec;
2304: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2305: EXCEPTION
2306: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2307: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2308: (

Line 2306: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2302:
2303: x_agn_rec := l_def_agn_rec;
2304: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2305: EXCEPTION
2306: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2307: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2308: (
2309: l_api_name,
2310: G_PKG_NAME,

Line 2307: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2303: x_agn_rec := l_def_agn_rec;
2304: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2305: EXCEPTION
2306: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2307: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2308: (
2309: l_api_name,
2310: G_PKG_NAME,
2311: 'OKC_API.G_RET_STS_ERROR',

Line 2311: 'OKC_API.G_RET_STS_ERROR',

2307: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2308: (
2309: l_api_name,
2310: G_PKG_NAME,
2311: 'OKC_API.G_RET_STS_ERROR',
2312: x_msg_count,
2313: x_msg_data,
2314: '_PVT'
2315: );

Line 2316: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2312: x_msg_count,
2313: x_msg_data,
2314: '_PVT'
2315: );
2316: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2317: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2318: (
2319: l_api_name,
2320: G_PKG_NAME,

Line 2317: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2313: x_msg_data,
2314: '_PVT'
2315: );
2316: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2317: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2318: (
2319: l_api_name,
2320: G_PKG_NAME,
2321: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2321: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2317: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2318: (
2319: l_api_name,
2320: G_PKG_NAME,
2321: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2322: x_msg_count,
2323: x_msg_data,
2324: '_PVT'
2325: );

Line 2327: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2323: x_msg_data,
2324: '_PVT'
2325: );
2326: WHEN OTHERS THEN
2327: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2328: (
2329: l_api_name,
2330: G_PKG_NAME,
2331: 'OTHERS',

Line 2342: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2338: -- update_row for:OKL_ACCRUAL_GNRTNS_V --
2339: -----------------------------------------
2340: PROCEDURE update_row(
2341: p_api_version IN NUMBER,
2342: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2343: x_return_status OUT NOCOPY VARCHAR2,
2344: x_msg_count OUT NOCOPY NUMBER,
2345: x_msg_data OUT NOCOPY VARCHAR2,
2346: p_agnv_rec IN agnv_rec_type,

Line 2351: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2347: x_agnv_rec OUT NOCOPY agnv_rec_type) IS
2348:
2349: l_api_version CONSTANT NUMBER := 1;
2350: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
2351: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2352: l_agnv_rec agnv_rec_type := p_agnv_rec;
2353: l_def_agnv_rec agnv_rec_type;
2354: l_agn_rec agn_rec_type;
2355: lx_agn_rec agn_rec_type;

Line 2378: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2374: x_agnv_rec OUT NOCOPY agnv_rec_type
2375: ) RETURN VARCHAR2 IS
2376: l_agnv_rec agnv_rec_type;
2377: l_row_notfound BOOLEAN := TRUE;
2378: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2379: BEGIN
2380: x_agnv_rec := p_agnv_rec;
2381: -- Get current database values
2382: l_agnv_rec := get_rec(p_agnv_rec, l_row_notfound);

Line 2384: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;

2380: x_agnv_rec := p_agnv_rec;
2381: -- Get current database values
2382: l_agnv_rec := get_rec(p_agnv_rec, l_row_notfound);
2383: IF (l_row_notfound) THEN
2384: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2385: END IF;
2386: IF (x_agnv_rec.id = Okc_Api.G_MISS_NUM)
2387: THEN
2388: x_agnv_rec.id := l_agnv_rec.id;

Line 2386: IF (x_agnv_rec.id = Okc_Api.G_MISS_NUM)

2382: l_agnv_rec := get_rec(p_agnv_rec, l_row_notfound);
2383: IF (l_row_notfound) THEN
2384: l_return_status := Okc_Api.G_RET_STS_UNEXP_ERROR;
2385: END IF;
2386: IF (x_agnv_rec.id = Okc_Api.G_MISS_NUM)
2387: THEN
2388: x_agnv_rec.id := l_agnv_rec.id;
2389: END IF;
2390: IF (x_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM)

Line 2390: IF (x_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM)

2386: IF (x_agnv_rec.id = Okc_Api.G_MISS_NUM)
2387: THEN
2388: x_agnv_rec.id := l_agnv_rec.id;
2389: END IF;
2390: IF (x_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2391: THEN
2392: x_agnv_rec.object_version_number := l_agnv_rec.object_version_number;
2393: END IF;
2394: IF (x_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR)

Line 2394: IF (x_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR)

2390: IF (x_agnv_rec.object_version_number = Okc_Api.G_MISS_NUM)
2391: THEN
2392: x_agnv_rec.object_version_number := l_agnv_rec.object_version_number;
2393: END IF;
2394: IF (x_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR)
2395: THEN
2396: x_agnv_rec.aro_code := l_agnv_rec.aro_code;
2397: END IF;
2398: IF (x_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR)

Line 2398: IF (x_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR)

2394: IF (x_agnv_rec.aro_code = Okc_Api.G_MISS_CHAR)
2395: THEN
2396: x_agnv_rec.aro_code := l_agnv_rec.aro_code;
2397: END IF;
2398: IF (x_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR)
2399: THEN
2400: x_agnv_rec.arlo_code := l_agnv_rec.arlo_code;
2401: END IF;
2402: IF (x_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR)

Line 2402: IF (x_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR)

2398: IF (x_agnv_rec.arlo_code = Okc_Api.G_MISS_CHAR)
2399: THEN
2400: x_agnv_rec.arlo_code := l_agnv_rec.arlo_code;
2401: END IF;
2402: IF (x_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR)
2403: THEN
2404: x_agnv_rec.acro_code := l_agnv_rec.acro_code;
2405: END IF;
2406: IF (x_agnv_rec.line_number = Okc_Api.G_MISS_NUM)

Line 2406: IF (x_agnv_rec.line_number = Okc_Api.G_MISS_NUM)

2402: IF (x_agnv_rec.acro_code = Okc_Api.G_MISS_CHAR)
2403: THEN
2404: x_agnv_rec.acro_code := l_agnv_rec.acro_code;
2405: END IF;
2406: IF (x_agnv_rec.line_number = Okc_Api.G_MISS_NUM)
2407: THEN
2408: x_agnv_rec.line_number := l_agnv_rec.line_number;
2409: END IF;
2410: IF (x_agnv_rec.version = Okc_Api.G_MISS_CHAR)

Line 2410: IF (x_agnv_rec.version = Okc_Api.G_MISS_CHAR)

2406: IF (x_agnv_rec.line_number = Okc_Api.G_MISS_NUM)
2407: THEN
2408: x_agnv_rec.line_number := l_agnv_rec.line_number;
2409: END IF;
2410: IF (x_agnv_rec.version = Okc_Api.G_MISS_CHAR)
2411: THEN
2412: x_agnv_rec.version := l_agnv_rec.version;
2413: END IF;
2414: IF (x_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR)

Line 2414: IF (x_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR)

2410: IF (x_agnv_rec.version = Okc_Api.G_MISS_CHAR)
2411: THEN
2412: x_agnv_rec.version := l_agnv_rec.version;
2413: END IF;
2414: IF (x_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR)
2415: THEN
2416: x_agnv_rec.left_parentheses := l_agnv_rec.left_parentheses;
2417: END IF;
2418: IF (x_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)

Line 2418: IF (x_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)

2414: IF (x_agnv_rec.left_parentheses = Okc_Api.G_MISS_CHAR)
2415: THEN
2416: x_agnv_rec.left_parentheses := l_agnv_rec.left_parentheses;
2417: END IF;
2418: IF (x_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)
2419: THEN
2420: x_agnv_rec.right_operand_literal := l_agnv_rec.right_operand_literal;
2421: END IF;
2422: IF (x_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR)

Line 2422: IF (x_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR)

2418: IF (x_agnv_rec.right_operand_literal = Okc_Api.G_MISS_CHAR)
2419: THEN
2420: x_agnv_rec.right_operand_literal := l_agnv_rec.right_operand_literal;
2421: END IF;
2422: IF (x_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR)
2423: THEN
2424: x_agnv_rec.right_parentheses := l_agnv_rec.right_parentheses;
2425: END IF;
2426: IF (x_agnv_rec.from_date = Okc_Api.G_MISS_DATE)

Line 2426: IF (x_agnv_rec.from_date = Okc_Api.G_MISS_DATE)

2422: IF (x_agnv_rec.right_parentheses = Okc_Api.G_MISS_CHAR)
2423: THEN
2424: x_agnv_rec.right_parentheses := l_agnv_rec.right_parentheses;
2425: END IF;
2426: IF (x_agnv_rec.from_date = Okc_Api.G_MISS_DATE)
2427: THEN
2428: x_agnv_rec.from_date := l_agnv_rec.from_date;
2429: END IF;
2430: IF (x_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE)

Line 2430: IF (x_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE)

2426: IF (x_agnv_rec.from_date = Okc_Api.G_MISS_DATE)
2427: THEN
2428: x_agnv_rec.from_date := l_agnv_rec.from_date;
2429: END IF;
2430: IF (x_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE)
2431: THEN
2432: x_agnv_rec.TO_DATE := l_agnv_rec.TO_DATE;
2433: END IF;
2434: IF (x_agnv_rec.org_id = Okc_Api.G_MISS_NUM)

Line 2434: IF (x_agnv_rec.org_id = Okc_Api.G_MISS_NUM)

2430: IF (x_agnv_rec.TO_DATE = Okc_Api.G_MISS_DATE)
2431: THEN
2432: x_agnv_rec.TO_DATE := l_agnv_rec.TO_DATE;
2433: END IF;
2434: IF (x_agnv_rec.org_id = Okc_Api.G_MISS_NUM)
2435: THEN
2436: x_agnv_rec.org_id := l_agnv_rec.org_id;
2437: END IF;
2438: IF (x_agnv_rec.created_by = Okc_Api.G_MISS_NUM)

Line 2438: IF (x_agnv_rec.created_by = Okc_Api.G_MISS_NUM)

2434: IF (x_agnv_rec.org_id = Okc_Api.G_MISS_NUM)
2435: THEN
2436: x_agnv_rec.org_id := l_agnv_rec.org_id;
2437: END IF;
2438: IF (x_agnv_rec.created_by = Okc_Api.G_MISS_NUM)
2439: THEN
2440: x_agnv_rec.created_by := l_agnv_rec.created_by;
2441: END IF;
2442: IF (x_agnv_rec.creation_date = Okc_Api.G_MISS_DATE)

Line 2442: IF (x_agnv_rec.creation_date = Okc_Api.G_MISS_DATE)

2438: IF (x_agnv_rec.created_by = Okc_Api.G_MISS_NUM)
2439: THEN
2440: x_agnv_rec.created_by := l_agnv_rec.created_by;
2441: END IF;
2442: IF (x_agnv_rec.creation_date = Okc_Api.G_MISS_DATE)
2443: THEN
2444: x_agnv_rec.creation_date := l_agnv_rec.creation_date;
2445: END IF;
2446: IF (x_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

Line 2446: IF (x_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)

2442: IF (x_agnv_rec.creation_date = Okc_Api.G_MISS_DATE)
2443: THEN
2444: x_agnv_rec.creation_date := l_agnv_rec.creation_date;
2445: END IF;
2446: IF (x_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2447: THEN
2448: x_agnv_rec.last_updated_by := l_agnv_rec.last_updated_by;
2449: END IF;
2450: IF (x_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE)

Line 2450: IF (x_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE)

2446: IF (x_agnv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
2447: THEN
2448: x_agnv_rec.last_updated_by := l_agnv_rec.last_updated_by;
2449: END IF;
2450: IF (x_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2451: THEN
2452: x_agnv_rec.last_update_date := l_agnv_rec.last_update_date;
2453: END IF;
2454: IF (x_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM)

Line 2454: IF (x_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM)

2450: IF (x_agnv_rec.last_update_date = Okc_Api.G_MISS_DATE)
2451: THEN
2452: x_agnv_rec.last_update_date := l_agnv_rec.last_update_date;
2453: END IF;
2454: IF (x_agnv_rec.last_update_login = Okc_Api.G_MISS_NUM)
2455: THEN
2456: x_agnv_rec.last_update_login := l_agnv_rec.last_update_login;
2457: END IF;
2458: RETURN(l_return_status);

Line 2467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2463: FUNCTION Set_Attributes (
2464: p_agnv_rec IN agnv_rec_type,
2465: x_agnv_rec OUT NOCOPY agnv_rec_type
2466: ) RETURN VARCHAR2 IS
2467: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2468: BEGIN
2469: x_agnv_rec := p_agnv_rec;
2470: RETURN(l_return_status);
2471: END Set_Attributes;

Line 2473: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2469: x_agnv_rec := p_agnv_rec;
2470: RETURN(l_return_status);
2471: END Set_Attributes;
2472: BEGIN
2473: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2474: G_PKG_NAME,
2475: p_init_msg_list,
2476: l_api_version,
2477: p_api_version,

Line 2480: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2476: l_api_version,
2477: p_api_version,
2478: '_PVT',
2479: x_return_status);
2480: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2481: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2482: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2483: RAISE Okc_Api.G_EXCEPTION_ERROR;
2484: END IF;

Line 2481: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2477: p_api_version,
2478: '_PVT',
2479: x_return_status);
2480: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2481: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2482: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2483: RAISE Okc_Api.G_EXCEPTION_ERROR;
2484: END IF;
2485: --- Setting item attributes

Line 2482: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2478: '_PVT',
2479: x_return_status);
2480: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2481: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2482: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2483: RAISE Okc_Api.G_EXCEPTION_ERROR;
2484: END IF;
2485: --- Setting item attributes
2486: l_return_status := Set_Attributes(

Line 2483: RAISE Okc_Api.G_EXCEPTION_ERROR;

2479: x_return_status);
2480: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2481: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2482: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2483: RAISE Okc_Api.G_EXCEPTION_ERROR;
2484: END IF;
2485: --- Setting item attributes
2486: l_return_status := Set_Attributes(
2487: p_agnv_rec, -- IN

Line 2490: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2486: l_return_status := Set_Attributes(
2487: p_agnv_rec, -- IN
2488: l_agnv_rec); -- OUT
2489: --- If any errors happen abort API
2490: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2491: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;

Line 2491: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2487: p_agnv_rec, -- IN
2488: l_agnv_rec); -- OUT
2489: --- If any errors happen abort API
2490: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2491: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);

Line 2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2488: l_agnv_rec); -- OUT
2489: --- If any errors happen abort API
2490: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2491: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2493: RAISE Okc_Api.G_EXCEPTION_ERROR;

2489: --- If any errors happen abort API
2490: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2491: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2492: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2499: RAISE Okc_Api.G_EXCEPTION_ERROR;
2500: END IF;

Line 2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2493: RAISE Okc_Api.G_EXCEPTION_ERROR;
2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2499: RAISE Okc_Api.G_EXCEPTION_ERROR;
2500: END IF;
2501: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);

Line 2498: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2494: END IF;
2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2499: RAISE Okc_Api.G_EXCEPTION_ERROR;
2500: END IF;
2501: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
2502: --- Validate all non-missing attributes (Item Level Validation)

Line 2499: RAISE Okc_Api.G_EXCEPTION_ERROR;

2495: l_return_status := populate_new_record(l_agnv_rec, l_def_agnv_rec);
2496: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2497: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2498: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2499: RAISE Okc_Api.G_EXCEPTION_ERROR;
2500: END IF;
2501: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
2502: --- Validate all non-missing attributes (Item Level Validation)
2503: l_return_status := Validate_Attributes(l_def_agnv_rec);

Line 2505: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2501: l_def_agnv_rec := fill_who_columns(l_def_agnv_rec);
2502: --- Validate all non-missing attributes (Item Level Validation)
2503: l_return_status := Validate_Attributes(l_def_agnv_rec);
2504: --- If any errors happen abort API
2505: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;

Line 2506: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2502: --- Validate all non-missing attributes (Item Level Validation)
2503: l_return_status := Validate_Attributes(l_def_agnv_rec);
2504: --- If any errors happen abort API
2505: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);

Line 2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2503: l_return_status := Validate_Attributes(l_def_agnv_rec);
2504: --- If any errors happen abort API
2505: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2508: RAISE Okc_Api.G_EXCEPTION_ERROR;

2504: --- If any errors happen abort API
2505: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2506: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

Line 2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2507: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2514: RAISE Okc_Api.G_EXCEPTION_ERROR;
2515: END IF;

Line 2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2508: RAISE Okc_Api.G_EXCEPTION_ERROR;
2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2514: RAISE Okc_Api.G_EXCEPTION_ERROR;
2515: END IF;
2516:

Line 2513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2509: END IF;
2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2514: RAISE Okc_Api.G_EXCEPTION_ERROR;
2515: END IF;
2516:
2517: --------------------------------------

Line 2514: RAISE Okc_Api.G_EXCEPTION_ERROR;

2510: l_return_status := Validate_Record(l_def_agnv_rec);
2511: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2512: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2513: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2514: RAISE Okc_Api.G_EXCEPTION_ERROR;
2515: END IF;
2516:
2517: --------------------------------------
2518: -- Move VIEW record to "Child" records

Line 2532: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2528: x_msg_data,
2529: l_agn_rec,
2530: lx_agn_rec
2531: );
2532: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2535: RAISE Okc_Api.G_EXCEPTION_ERROR;
2536: END IF;

Line 2533: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2529: l_agn_rec,
2530: lx_agn_rec
2531: );
2532: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2535: RAISE Okc_Api.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_agn_rec, l_def_agnv_rec);

Line 2534: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2530: lx_agn_rec
2531: );
2532: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2535: RAISE Okc_Api.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_agn_rec, l_def_agnv_rec);
2538: x_agnv_rec := l_def_agnv_rec;

Line 2535: RAISE Okc_Api.G_EXCEPTION_ERROR;

2531: );
2532: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2533: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2534: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2535: RAISE Okc_Api.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_agn_rec, l_def_agnv_rec);
2538: x_agnv_rec := l_def_agnv_rec;
2539: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2539: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2535: RAISE Okc_Api.G_EXCEPTION_ERROR;
2536: END IF;
2537: migrate(lx_agn_rec, l_def_agnv_rec);
2538: x_agnv_rec := l_def_agnv_rec;
2539: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2540: EXCEPTION
2541: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2542: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2543: (

Line 2541: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2537: migrate(lx_agn_rec, l_def_agnv_rec);
2538: x_agnv_rec := l_def_agnv_rec;
2539: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2540: EXCEPTION
2541: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2542: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,

Line 2542: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2538: x_agnv_rec := l_def_agnv_rec;
2539: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2540: EXCEPTION
2541: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2542: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,
2546: 'OKC_API.G_RET_STS_ERROR',

Line 2546: 'OKC_API.G_RET_STS_ERROR',

2542: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2543: (
2544: l_api_name,
2545: G_PKG_NAME,
2546: 'OKC_API.G_RET_STS_ERROR',
2547: x_msg_count,
2548: x_msg_data,
2549: '_PVT'
2550: );

Line 2551: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2547: x_msg_count,
2548: x_msg_data,
2549: '_PVT'
2550: );
2551: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2552: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2553: (
2554: l_api_name,
2555: G_PKG_NAME,

Line 2552: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2548: x_msg_data,
2549: '_PVT'
2550: );
2551: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2552: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2553: (
2554: l_api_name,
2555: G_PKG_NAME,
2556: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2556: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2552: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2553: (
2554: l_api_name,
2555: G_PKG_NAME,
2556: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2557: x_msg_count,
2558: x_msg_data,
2559: '_PVT'
2560: );

Line 2562: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2558: x_msg_data,
2559: '_PVT'
2560: );
2561: WHEN OTHERS THEN
2562: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2563: (
2564: l_api_name,
2565: G_PKG_NAME,
2566: 'OTHERS',

Line 2577: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2573: -- PL/SQL TBL update_row for:AGNV_TBL --
2574: ----------------------------------------
2575: PROCEDURE update_row(
2576: p_api_version IN NUMBER,
2577: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2578: x_return_status OUT NOCOPY VARCHAR2,
2579: x_msg_count OUT NOCOPY NUMBER,
2580: x_msg_data OUT NOCOPY VARCHAR2,
2581: p_agnv_tbl IN agnv_tbl_type,

Line 2586: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2582: x_agnv_tbl OUT NOCOPY agnv_tbl_type) IS
2583:
2584: l_api_version CONSTANT NUMBER := 1;
2585: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2586: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2587: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2588: i NUMBER := 0;
2589: BEGIN
2590: Okc_Api.init_msg_list(p_init_msg_list);

Line 2587: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2583:
2584: l_api_version CONSTANT NUMBER := 1;
2585: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
2586: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2587: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2588: i NUMBER := 0;
2589: BEGIN
2590: Okc_Api.init_msg_list(p_init_msg_list);
2591: -- Make sure PL/SQL table has records in it before passing

Line 2590: Okc_Api.init_msg_list(p_init_msg_list);

2586: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2587: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2588: i NUMBER := 0;
2589: BEGIN
2590: Okc_Api.init_msg_list(p_init_msg_list);
2591: -- Make sure PL/SQL table has records in it before passing
2592: IF (p_agnv_tbl.COUNT > 0) THEN
2593: i := p_agnv_tbl.FIRST;
2594: LOOP

Line 2597: p_init_msg_list => Okc_Api.G_FALSE,

2593: i := p_agnv_tbl.FIRST;
2594: LOOP
2595: update_row (
2596: p_api_version => p_api_version,
2597: p_init_msg_list => Okc_Api.G_FALSE,
2598: x_return_status => x_return_status,
2599: x_msg_count => x_msg_count,
2600: x_msg_data => x_msg_data,
2601: p_agnv_rec => p_agnv_tbl(i),

Line 2605: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2601: p_agnv_rec => p_agnv_tbl(i),
2602: x_agnv_rec => x_agnv_tbl(i));
2603: /* Begin Post Generation Change */
2604: -- store the highest degree of error
2605: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2606: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2607: l_overall_status := x_return_status;
2608: END IF;
2609: END IF;

Line 2606: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2602: x_agnv_rec => x_agnv_tbl(i));
2603: /* Begin Post Generation Change */
2604: -- store the highest degree of error
2605: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2606: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2607: l_overall_status := x_return_status;
2608: END IF;
2609: END IF;
2610: /* End Post Generation Change */

Line 2618: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2614: END IF;
2615: x_return_status := l_overall_status;
2616:
2617: EXCEPTION
2618: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2619: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,

Line 2619: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2615: x_return_status := l_overall_status;
2616:
2617: EXCEPTION
2618: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2619: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,
2623: 'OKC_API.G_RET_STS_ERROR',

Line 2623: 'OKC_API.G_RET_STS_ERROR',

2619: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2620: (
2621: l_api_name,
2622: G_PKG_NAME,
2623: 'OKC_API.G_RET_STS_ERROR',
2624: x_msg_count,
2625: x_msg_data,
2626: '_PVT'
2627: );

Line 2628: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2624: x_msg_count,
2625: x_msg_data,
2626: '_PVT'
2627: );
2628: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2629: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,

Line 2629: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2625: x_msg_data,
2626: '_PVT'
2627: );
2628: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2629: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2629: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2630: (
2631: l_api_name,
2632: G_PKG_NAME,
2633: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2634: x_msg_count,
2635: x_msg_data,
2636: '_PVT'
2637: );

Line 2639: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2635: x_msg_data,
2636: '_PVT'
2637: );
2638: WHEN OTHERS THEN
2639: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2640: (
2641: l_api_name,
2642: G_PKG_NAME,
2643: 'OTHERS',

Line 2657: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2653: ---------------------------------------
2654: -- delete_row for:OKL_ACCRUAL_GNRTNS --
2655: ---------------------------------------
2656: PROCEDURE delete_row(
2657: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2658: x_return_status OUT NOCOPY VARCHAR2,
2659: x_msg_count OUT NOCOPY NUMBER,
2660: x_msg_data OUT NOCOPY VARCHAR2,
2661: p_agn_rec IN agn_rec_type) IS

Line 2665: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2661: p_agn_rec IN agn_rec_type) IS
2662:
2663: l_api_version CONSTANT NUMBER := 1;
2664: l_api_name CONSTANT VARCHAR2(30) := 'GNRTNS_delete_row';
2665: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2666: l_agn_rec agn_rec_type:= p_agn_rec;
2667: l_row_notfound BOOLEAN := TRUE;
2668: BEGIN
2669: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2669: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2665: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2666: l_agn_rec agn_rec_type:= p_agn_rec;
2667: l_row_notfound BOOLEAN := TRUE;
2668: BEGIN
2669: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2670: p_init_msg_list,
2671: '_PVT',
2672: x_return_status);
2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

Line 2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2669: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2670: p_init_msg_list,
2671: '_PVT',
2672: x_return_status);
2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okc_Api.G_EXCEPTION_ERROR;
2677: END IF;

Line 2674: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2670: p_init_msg_list,
2671: '_PVT',
2672: x_return_status);
2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okc_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678: DELETE FROM OKL_ACCRUAL_GNRTNS

Line 2675: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2671: '_PVT',
2672: x_return_status);
2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okc_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678: DELETE FROM OKL_ACCRUAL_GNRTNS
2679: WHERE ID = l_agn_rec.id;

Line 2676: RAISE Okc_Api.G_EXCEPTION_ERROR;

2672: x_return_status);
2673: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2674: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2675: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2676: RAISE Okc_Api.G_EXCEPTION_ERROR;
2677: END IF;
2678: DELETE FROM OKL_ACCRUAL_GNRTNS
2679: WHERE ID = l_agn_rec.id;
2680:

Line 2681: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2677: END IF;
2678: DELETE FROM OKL_ACCRUAL_GNRTNS
2679: WHERE ID = l_agn_rec.id;
2680:
2681: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2682: EXCEPTION
2683: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2684: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2685: (

Line 2683: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2679: WHERE ID = l_agn_rec.id;
2680:
2681: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2682: EXCEPTION
2683: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2684: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2685: (
2686: l_api_name,
2687: G_PKG_NAME,

Line 2684: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2680:
2681: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2682: EXCEPTION
2683: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2684: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2685: (
2686: l_api_name,
2687: G_PKG_NAME,
2688: 'OKC_API.G_RET_STS_ERROR',

Line 2688: 'OKC_API.G_RET_STS_ERROR',

2684: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2685: (
2686: l_api_name,
2687: G_PKG_NAME,
2688: 'OKC_API.G_RET_STS_ERROR',
2689: x_msg_count,
2690: x_msg_data,
2691: '_PVT'
2692: );

Line 2693: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2689: x_msg_count,
2690: x_msg_data,
2691: '_PVT'
2692: );
2693: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2694: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2695: (
2696: l_api_name,
2697: G_PKG_NAME,

Line 2694: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2690: x_msg_data,
2691: '_PVT'
2692: );
2693: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2694: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2695: (
2696: l_api_name,
2697: G_PKG_NAME,
2698: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2698: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2694: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2695: (
2696: l_api_name,
2697: G_PKG_NAME,
2698: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2699: x_msg_count,
2700: x_msg_data,
2701: '_PVT'
2702: );

Line 2704: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2700: x_msg_data,
2701: '_PVT'
2702: );
2703: WHEN OTHERS THEN
2704: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2705: (
2706: l_api_name,
2707: G_PKG_NAME,
2708: 'OTHERS',

Line 2719: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2715: -- delete_row for:OKL_ACCRUAL_GNRTNS_V --
2716: -----------------------------------------
2717: PROCEDURE delete_row(
2718: p_api_version IN NUMBER,
2719: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2720: x_return_status OUT NOCOPY VARCHAR2,
2721: x_msg_count OUT NOCOPY NUMBER,
2722: x_msg_data OUT NOCOPY VARCHAR2,
2723: p_agnv_rec IN agnv_rec_type) IS

Line 2727: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2723: p_agnv_rec IN agnv_rec_type) IS
2724:
2725: l_api_version CONSTANT NUMBER := 1;
2726: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
2727: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2728: l_agnv_rec agnv_rec_type := p_agnv_rec;
2729: l_agn_rec agn_rec_type;
2730: BEGIN
2731: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

Line 2731: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,

2727: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2728: l_agnv_rec agnv_rec_type := p_agnv_rec;
2729: l_agn_rec agn_rec_type;
2730: BEGIN
2731: l_return_status := Okc_Api.START_ACTIVITY(l_api_name,
2732: G_PKG_NAME,
2733: p_init_msg_list,
2734: l_api_version,
2735: p_api_version,

Line 2738: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2734: l_api_version,
2735: p_api_version,
2736: '_PVT',
2737: x_return_status);
2738: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2741: RAISE Okc_Api.G_EXCEPTION_ERROR;
2742: END IF;

Line 2739: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2735: p_api_version,
2736: '_PVT',
2737: x_return_status);
2738: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2741: RAISE Okc_Api.G_EXCEPTION_ERROR;
2742: END IF;
2743: --------------------------------------

Line 2740: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2736: '_PVT',
2737: x_return_status);
2738: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2741: RAISE Okc_Api.G_EXCEPTION_ERROR;
2742: END IF;
2743: --------------------------------------
2744: -- Move VIEW record to "Child" records

Line 2741: RAISE Okc_Api.G_EXCEPTION_ERROR;

2737: x_return_status);
2738: IF (l_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2739: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2740: ELSIF (l_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2741: RAISE Okc_Api.G_EXCEPTION_ERROR;
2742: END IF;
2743: --------------------------------------
2744: -- Move VIEW record to "Child" records
2745: --------------------------------------

Line 2757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN

2753: x_msg_count,
2754: x_msg_data,
2755: l_agn_rec
2756: );
2757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;

Line 2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;

2754: x_msg_data,
2755: l_agn_rec
2756: );
2757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

Line 2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN

2755: l_agn_rec
2756: );
2757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2763: EXCEPTION

Line 2760: RAISE Okc_Api.G_EXCEPTION_ERROR;

2756: );
2757: IF (x_return_status = Okc_Api.G_RET_STS_UNEXP_ERROR) THEN
2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2763: EXCEPTION
2764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

Line 2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);

2758: RAISE Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR;
2759: ELSIF (x_return_status = Okc_Api.G_RET_STS_ERROR) THEN
2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2763: EXCEPTION
2764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2766: (

Line 2764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2760: RAISE Okc_Api.G_EXCEPTION_ERROR;
2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2763: EXCEPTION
2764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2766: (
2767: l_api_name,
2768: G_PKG_NAME,

Line 2765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2761: END IF;
2762: Okc_Api.END_ACTIVITY(x_msg_count, x_msg_data);
2763: EXCEPTION
2764: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2766: (
2767: l_api_name,
2768: G_PKG_NAME,
2769: 'OKC_API.G_RET_STS_ERROR',

Line 2769: 'OKC_API.G_RET_STS_ERROR',

2765: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2766: (
2767: l_api_name,
2768: G_PKG_NAME,
2769: 'OKC_API.G_RET_STS_ERROR',
2770: x_msg_count,
2771: x_msg_data,
2772: '_PVT'
2773: );

Line 2774: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2770: x_msg_count,
2771: x_msg_data,
2772: '_PVT'
2773: );
2774: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2775: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2776: (
2777: l_api_name,
2778: G_PKG_NAME,

Line 2775: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2771: x_msg_data,
2772: '_PVT'
2773: );
2774: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2775: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2776: (
2777: l_api_name,
2778: G_PKG_NAME,
2779: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2779: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2775: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2776: (
2777: l_api_name,
2778: G_PKG_NAME,
2779: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2780: x_msg_count,
2781: x_msg_data,
2782: '_PVT'
2783: );

Line 2785: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2781: x_msg_data,
2782: '_PVT'
2783: );
2784: WHEN OTHERS THEN
2785: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2786: (
2787: l_api_name,
2788: G_PKG_NAME,
2789: 'OTHERS',

Line 2800: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,

2796: -- PL/SQL TBL delete_row for:AGNV_TBL --
2797: ----------------------------------------
2798: PROCEDURE delete_row(
2799: p_api_version IN NUMBER,
2800: p_init_msg_list IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
2801: x_return_status OUT NOCOPY VARCHAR2,
2802: x_msg_count OUT NOCOPY NUMBER,
2803: x_msg_data OUT NOCOPY VARCHAR2,
2804: p_agnv_tbl IN agnv_tbl_type) IS

Line 2808: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2804: p_agnv_tbl IN agnv_tbl_type) IS
2805:
2806: l_api_version CONSTANT NUMBER := 1;
2807: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2808: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2809: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2810: i NUMBER := 0;
2811: BEGIN
2812: Okc_Api.init_msg_list(p_init_msg_list);

Line 2809: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;

2805:
2806: l_api_version CONSTANT NUMBER := 1;
2807: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
2808: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2809: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2810: i NUMBER := 0;
2811: BEGIN
2812: Okc_Api.init_msg_list(p_init_msg_list);
2813: -- Make sure PL/SQL table has records in it before passing

Line 2812: Okc_Api.init_msg_list(p_init_msg_list);

2808: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2809: l_overall_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
2810: i NUMBER := 0;
2811: BEGIN
2812: Okc_Api.init_msg_list(p_init_msg_list);
2813: -- Make sure PL/SQL table has records in it before passing
2814: IF (p_agnv_tbl.COUNT > 0) THEN
2815: i := p_agnv_tbl.FIRST;
2816: LOOP

Line 2819: p_init_msg_list => Okc_Api.G_FALSE,

2815: i := p_agnv_tbl.FIRST;
2816: LOOP
2817: delete_row (
2818: p_api_version => p_api_version,
2819: p_init_msg_list => Okc_Api.G_FALSE,
2820: x_return_status => x_return_status,
2821: x_msg_count => x_msg_count,
2822: x_msg_data => x_msg_data,
2823: p_agnv_rec => p_agnv_tbl(i));

Line 2826: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN

2822: x_msg_data => x_msg_data,
2823: p_agnv_rec => p_agnv_tbl(i));
2824: /* Begin Post Generation Change */
2825: -- store the highest degree of error
2826: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2827: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2828: l_overall_status := x_return_status;
2829: END IF;
2830: END IF;

Line 2827: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN

2823: p_agnv_rec => p_agnv_tbl(i));
2824: /* Begin Post Generation Change */
2825: -- store the highest degree of error
2826: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
2827: IF l_overall_status <> OKC_API.G_RET_STS_UNEXP_ERROR THEN
2828: l_overall_status := x_return_status;
2829: END IF;
2830: END IF;
2831: /* End Post Generation Change */

Line 2838: WHEN Okc_Api.G_EXCEPTION_ERROR THEN

2834: END LOOP;
2835: END IF;
2836: x_return_status := l_overall_Status;
2837: EXCEPTION
2838: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2839: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2840: (
2841: l_api_name,
2842: G_PKG_NAME,

Line 2839: x_return_status := Okc_Api.HANDLE_EXCEPTIONS

2835: END IF;
2836: x_return_status := l_overall_Status;
2837: EXCEPTION
2838: WHEN Okc_Api.G_EXCEPTION_ERROR THEN
2839: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2840: (
2841: l_api_name,
2842: G_PKG_NAME,
2843: 'OKC_API.G_RET_STS_ERROR',

Line 2843: 'OKC_API.G_RET_STS_ERROR',

2839: x_return_status := Okc_Api.HANDLE_EXCEPTIONS
2840: (
2841: l_api_name,
2842: G_PKG_NAME,
2843: 'OKC_API.G_RET_STS_ERROR',
2844: x_msg_count,
2845: x_msg_data,
2846: '_PVT'
2847: );

Line 2848: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN

2844: x_msg_count,
2845: x_msg_data,
2846: '_PVT'
2847: );
2848: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2849: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2850: (
2851: l_api_name,
2852: G_PKG_NAME,

Line 2849: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2845: x_msg_data,
2846: '_PVT'
2847: );
2848: WHEN Okc_Api.G_EXCEPTION_UNEXPECTED_ERROR THEN
2849: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2850: (
2851: l_api_name,
2852: G_PKG_NAME,
2853: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2853: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2849: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2850: (
2851: l_api_name,
2852: G_PKG_NAME,
2853: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2854: x_msg_count,
2855: x_msg_data,
2856: '_PVT'
2857: );

Line 2859: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS

2855: x_msg_data,
2856: '_PVT'
2857: );
2858: WHEN OTHERS THEN
2859: x_return_status :=Okc_Api.HANDLE_EXCEPTIONS
2860: (
2861: l_api_name,
2862: G_PKG_NAME,
2863: 'OTHERS',