APPS.OKC_VLO_PVT dependencies on OKC_API

Line 144: IF (l_vlov_rec.lse_id = OKC_API.G_MISS_NUM) THEN

140: p_vlov_rec IN vlov_rec_type
141: ) RETURN vlov_rec_type IS
142: l_vlov_rec vlov_rec_type := p_vlov_rec;
143: BEGIN
144: IF (l_vlov_rec.lse_id = OKC_API.G_MISS_NUM) THEN
145: l_vlov_rec.lse_id := NULL;
146: END IF;
147: IF (l_vlov_rec.opn_code = OKC_API.G_MISS_CHAR) THEN
148: l_vlov_rec.opn_code := NULL;

Line 147: IF (l_vlov_rec.opn_code = OKC_API.G_MISS_CHAR) THEN

143: BEGIN
144: IF (l_vlov_rec.lse_id = OKC_API.G_MISS_NUM) THEN
145: l_vlov_rec.lse_id := NULL;
146: END IF;
147: IF (l_vlov_rec.opn_code = OKC_API.G_MISS_CHAR) THEN
148: l_vlov_rec.opn_code := NULL;
149: END IF;
150: IF (l_vlov_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_vlov_rec.object_version_number := NULL;

Line 150: IF (l_vlov_rec.object_version_number = OKC_API.G_MISS_NUM) THEN

146: END IF;
147: IF (l_vlov_rec.opn_code = OKC_API.G_MISS_CHAR) THEN
148: l_vlov_rec.opn_code := NULL;
149: END IF;
150: IF (l_vlov_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_vlov_rec.object_version_number := NULL;
152: END IF;
153: IF (l_vlov_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_vlov_rec.created_by := NULL;

Line 153: IF (l_vlov_rec.created_by = OKC_API.G_MISS_NUM) THEN

149: END IF;
150: IF (l_vlov_rec.object_version_number = OKC_API.G_MISS_NUM) THEN
151: l_vlov_rec.object_version_number := NULL;
152: END IF;
153: IF (l_vlov_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_vlov_rec.created_by := NULL;
155: END IF;
156: IF (l_vlov_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_vlov_rec.creation_date := NULL;

Line 156: IF (l_vlov_rec.creation_date = OKC_API.G_MISS_DATE) THEN

152: END IF;
153: IF (l_vlov_rec.created_by = OKC_API.G_MISS_NUM) THEN
154: l_vlov_rec.created_by := NULL;
155: END IF;
156: IF (l_vlov_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_vlov_rec.creation_date := NULL;
158: END IF;
159: IF (l_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_vlov_rec.last_updated_by := NULL;

Line 159: IF (l_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN

155: END IF;
156: IF (l_vlov_rec.creation_date = OKC_API.G_MISS_DATE) THEN
157: l_vlov_rec.creation_date := NULL;
158: END IF;
159: IF (l_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_vlov_rec.last_updated_by := NULL;
161: END IF;
162: IF (l_vlov_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_vlov_rec.last_update_date := NULL;

Line 162: IF (l_vlov_rec.last_update_date = OKC_API.G_MISS_DATE) THEN

158: END IF;
159: IF (l_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM) THEN
160: l_vlov_rec.last_updated_by := NULL;
161: END IF;
162: IF (l_vlov_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_vlov_rec.last_update_date := NULL;
164: END IF;
165: IF (l_vlov_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
166: l_vlov_rec.last_update_login := NULL;

Line 165: IF (l_vlov_rec.last_update_login = OKC_API.G_MISS_NUM) THEN

161: END IF;
162: IF (l_vlov_rec.last_update_date = OKC_API.G_MISS_DATE) THEN
163: l_vlov_rec.last_update_date := NULL;
164: END IF;
165: IF (l_vlov_rec.last_update_login = OKC_API.G_MISS_NUM) THEN
166: l_vlov_rec.last_update_login := NULL;
167: END IF;
168: RETURN(l_vlov_rec);
169: END null_out_defaults;

Line 202: x_return_status:=OKC_API.G_RET_STS_SUCCESS;

198: l_row_found BOOLEAN := FALSE;
199: l_dummy VARCHAR2(1);
200:
201: BEGIN
202: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
203:
204: -- ---------------------------------------------------------------------
205: -- Bug 1636056 related changes - Shyam
206: -- OKC_UTIL.check_comp_unique call is replaced with

Line 211: AND (p_vlov_rec.lse_id <> OKC_API.G_MISS_NUM))

207: -- the explicit cursors above, for identical function to
208: -- check uniqueness for LSE_ID + OPN_CODE in OKC_VAL_LINE_OPERATIONS_V
209: -- ---------------------------------------------------------------------
210: IF ( (p_vlov_rec.lse_id IS NOT NULL)
211: AND (p_vlov_rec.lse_id <> OKC_API.G_MISS_NUM))
212: AND
213: ( (p_vlov_rec.opn_code IS NOT NULL)
214: AND (p_vlov_rec.opn_code <> OKC_API.G_MISS_CHAR))
215: THEN

Line 214: AND (p_vlov_rec.opn_code <> OKC_API.G_MISS_CHAR))

210: IF ( (p_vlov_rec.lse_id IS NOT NULL)
211: AND (p_vlov_rec.lse_id <> OKC_API.G_MISS_NUM))
212: AND
213: ( (p_vlov_rec.opn_code IS NOT NULL)
214: AND (p_vlov_rec.opn_code <> OKC_API.G_MISS_CHAR))
215: THEN
216: OPEN cur_vlov;
217: FETCH cur_vlov INTO l_dummy;
218: l_row_found := cur_vlov%FOUND;

Line 224: OKC_API.set_message(G_APP_NAME,

220:
221: IF (l_row_found)
222: THEN
223: -- Display the newly defined error message
224: OKC_API.set_message(G_APP_NAME,
225: 'OKC_DUP_VAL_LINE_OPERATION');
226:
227: -- Set return status to error
228: x_return_status := OKC_API.G_RET_STS_ERROR;

Line 228: x_return_status := OKC_API.G_RET_STS_ERROR;

224: OKC_API.set_message(G_APP_NAME,
225: 'OKC_DUP_VAL_LINE_OPERATION');
226:
227: -- Set return status to error
228: x_return_status := OKC_API.G_RET_STS_ERROR;
229: END IF;
230: END IF;
231:
232: EXCEPTION

Line 236: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,

232: EXCEPTION
233: WHEN OTHERS THEN
234: -- other appropriate handlers
235: -- store SQL error message on message stack
236: OKC_API.SET_MESSAGE(p_app_name => G_APP_NAME,
237: p_msg_name => G_UNEXPECTED_ERROR,
238: p_token1 => G_SQLCODE_TOKEN,
239: p_token1_value => sqlcode,
240: p_token2 => G_SQLERRM_TOKEN,

Line 244: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

240: p_token2 => G_SQLERRM_TOKEN,
241: p_token2_value => sqlerrm);
242:
243: -- notify UNEXPECTED error
244: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
245:
246: END Validate_Unique;
247:
248: -- Start of comments

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

254: ---------------------------------------------------------------------------
255: PROCEDURE validate_lse_id(
256: p_vlov_rec IN vlov_rec_type,
257: x_return_status OUT NOCOPY VARCHAR2) IS
258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
259: BEGIN
260: IF p_vlov_rec.lse_id = OKC_API.G_MISS_NUM OR
261: p_vlov_rec.lse_id IS NULL
262: THEN

Line 260: IF p_vlov_rec.lse_id = OKC_API.G_MISS_NUM OR

256: p_vlov_rec IN vlov_rec_type,
257: x_return_status OUT NOCOPY VARCHAR2) IS
258: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
259: BEGIN
260: IF p_vlov_rec.lse_id = OKC_API.G_MISS_NUM OR
261: p_vlov_rec.lse_id IS NULL
262: THEN
263: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lse_id');
264: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 263: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lse_id');

259: BEGIN
260: IF p_vlov_rec.lse_id = OKC_API.G_MISS_NUM OR
261: p_vlov_rec.lse_id IS NULL
262: THEN
263: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lse_id');
264: l_return_status := OKC_API.G_RET_STS_ERROR;
265: END IF;
266: x_return_status := l_return_status;
267: EXCEPTION

Line 264: l_return_status := OKC_API.G_RET_STS_ERROR;

260: IF p_vlov_rec.lse_id = OKC_API.G_MISS_NUM OR
261: p_vlov_rec.lse_id IS NULL
262: THEN
263: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'lse_id');
264: l_return_status := OKC_API.G_RET_STS_ERROR;
265: END IF;
266: x_return_status := l_return_status;
267: EXCEPTION
268: WHEN OTHERS THEN

Line 270: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

266: x_return_status := l_return_status;
267: EXCEPTION
268: WHEN OTHERS THEN
269: -- store SQL error message on message stack for caller
270: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
271: -- notify caller of an UNEXPECTED error
272: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
273: END validate_lse_id;
274:

Line 272: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

268: WHEN OTHERS THEN
269: -- store SQL error message on message stack for caller
270: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
271: -- notify caller of an UNEXPECTED error
272: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
273: END validate_lse_id;
274:
275: ---------------------------------------------------------------------------
276: -- PROCEDURE Validate_opn_code

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

277: ---------------------------------------------------------------------------
278: PROCEDURE validate_opn_code(
279: p_vlov_rec IN vlov_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2) IS
281: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
282: BEGIN
283: IF p_vlov_rec.opn_code = OKC_API.G_MISS_CHAR OR
284: p_vlov_rec.opn_code IS NULL
285: THEN

Line 283: IF p_vlov_rec.opn_code = OKC_API.G_MISS_CHAR OR

279: p_vlov_rec IN vlov_rec_type,
280: x_return_status OUT NOCOPY VARCHAR2) IS
281: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
282: BEGIN
283: IF p_vlov_rec.opn_code = OKC_API.G_MISS_CHAR OR
284: p_vlov_rec.opn_code IS NULL
285: THEN
286: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_code');
287: l_return_status := OKC_API.G_RET_STS_ERROR;

Line 286: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_code');

282: BEGIN
283: IF p_vlov_rec.opn_code = OKC_API.G_MISS_CHAR OR
284: p_vlov_rec.opn_code IS NULL
285: THEN
286: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_code');
287: l_return_status := OKC_API.G_RET_STS_ERROR;
288: END IF;
289: x_return_status := l_return_status;
290: EXCEPTION

Line 287: l_return_status := OKC_API.G_RET_STS_ERROR;

283: IF p_vlov_rec.opn_code = OKC_API.G_MISS_CHAR OR
284: p_vlov_rec.opn_code IS NULL
285: THEN
286: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'opn_code');
287: l_return_status := OKC_API.G_RET_STS_ERROR;
288: END IF;
289: x_return_status := l_return_status;
290: EXCEPTION
291: WHEN OTHERS THEN

Line 293: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

289: x_return_status := l_return_status;
290: EXCEPTION
291: WHEN OTHERS THEN
292: -- store SQL error message on message stack for caller
293: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
294: -- notify caller of an UNEXPECTED error
295: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
296: END validate_opn_code;
297:

Line 295: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

291: WHEN OTHERS THEN
292: -- store SQL error message on message stack for caller
293: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
294: -- notify caller of an UNEXPECTED error
295: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
296: END validate_opn_code;
297:
298: ---------------------------------------------------------------------------
299: -- PROCEDURE Validate_object_version_number

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

300: ---------------------------------------------------------------------------
301: PROCEDURE validate_object_version_number(
302: p_vlov_rec IN vlov_rec_type,
303: x_return_status OUT NOCOPY VARCHAR2) IS
304: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
305: BEGIN
306: IF p_vlov_rec.object_version_number = OKC_API.G_MISS_NUM OR
307: p_vlov_rec.object_version_number IS NULL
308: THEN

Line 306: IF p_vlov_rec.object_version_number = OKC_API.G_MISS_NUM OR

302: p_vlov_rec IN vlov_rec_type,
303: x_return_status OUT NOCOPY VARCHAR2) IS
304: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
305: BEGIN
306: IF p_vlov_rec.object_version_number = OKC_API.G_MISS_NUM OR
307: p_vlov_rec.object_version_number IS NULL
308: THEN
309: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
310: l_return_status := OKC_API.G_RET_STS_ERROR;

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

305: BEGIN
306: IF p_vlov_rec.object_version_number = OKC_API.G_MISS_NUM OR
307: p_vlov_rec.object_version_number IS NULL
308: THEN
309: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
310: l_return_status := OKC_API.G_RET_STS_ERROR;
311: RAISE G_EXCEPTION_HALT_VALIDATION;
312: END IF;
313:

Line 310: l_return_status := OKC_API.G_RET_STS_ERROR;

306: IF p_vlov_rec.object_version_number = OKC_API.G_MISS_NUM OR
307: p_vlov_rec.object_version_number IS NULL
308: THEN
309: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'object_version_number');
310: l_return_status := OKC_API.G_RET_STS_ERROR;
311: RAISE G_EXCEPTION_HALT_VALIDATION;
312: END IF;
313:
314: x_return_status := l_return_status;

Line 320: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

316: WHEN G_EXCEPTION_HALT_VALIDATION THEN
317: x_return_status := l_return_status;
318: WHEN OTHERS THEN
319: -- store SQL error message on message stack for caller
320: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
321: -- notify caller of an UNEXPECTED error
322: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
323: END validate_object_version_number;
324:

Line 322: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

318: WHEN OTHERS THEN
319: -- store SQL error message on message stack for caller
320: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
321: -- notify caller of an UNEXPECTED error
322: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
323: END validate_object_version_number;
324:
325: ---------------------------------------------------------------------------
326: -- PROCEDURE Validate_Attributes

Line 334: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

330: -------------------------------------------------------
331: FUNCTION Validate_Attributes (
332: p_vlov_rec IN vlov_rec_type
333: ) RETURN VARCHAR2 IS
334: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: VALIDATE_lse_id(p_vlov_rec, l_return_status);
338: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

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

331: FUNCTION Validate_Attributes (
332: p_vlov_rec IN vlov_rec_type
333: ) RETURN VARCHAR2 IS
334: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: VALIDATE_lse_id(p_vlov_rec, l_return_status);
338: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
339: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

Line 338: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

334: x_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: VALIDATE_lse_id(p_vlov_rec, l_return_status);
338: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
339: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
340: x_return_status := l_return_status;
341: RAISE G_EXCEPTION_HALT_VALIDATION;
342: ELSE

Line 339: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

335: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
336: BEGIN
337: VALIDATE_lse_id(p_vlov_rec, l_return_status);
338: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
339: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
340: x_return_status := l_return_status;
341: RAISE G_EXCEPTION_HALT_VALIDATION;
342: ELSE
343: x_return_status := l_return_status; -- record that there was an error

Line 348: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

344: END IF;
345: END IF;
346:
347: VALIDATE_opn_code(p_vlov_rec, l_return_status);
348: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
349: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
350: x_return_status := l_return_status;
351: RAISE G_EXCEPTION_HALT_VALIDATION;
352: ELSE

Line 349: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

345: END IF;
346:
347: VALIDATE_opn_code(p_vlov_rec, l_return_status);
348: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
349: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
350: x_return_status := l_return_status;
351: RAISE G_EXCEPTION_HALT_VALIDATION;
352: ELSE
353: x_return_status := l_return_status; -- record that there was an error

Line 358: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN

354: END IF;
355: END IF;
356:
357: VALIDATE_object_version_number(p_vlov_rec, l_return_status);
358: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
360: x_return_status := l_return_status;
361: RAISE G_EXCEPTION_HALT_VALIDATION;
362: ELSE

Line 359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave

355: END IF;
356:
357: VALIDATE_object_version_number(p_vlov_rec, l_return_status);
358: IF (l_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
359: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN -- need to leave
360: x_return_status := l_return_status;
361: RAISE G_EXCEPTION_HALT_VALIDATION;
362: ELSE
363: x_return_status := l_return_status; -- record that there was an error

Line 373: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);

369: WHEN G_EXCEPTION_HALT_VALIDATION THEN
370: return(x_return_status);
371: WHEN OTHERS THEN
372: -- store SQL error message on message stack for caller
373: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
374: -- notify caller of an UNEXPECTED error
375: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
376: return(x_return_status);
377: ---------------------------------------------------------------------------------------

Line 375: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

371: WHEN OTHERS THEN
372: -- store SQL error message on message stack for caller
373: OKC_API.set_message(G_APP_NAME, G_UNEXPECTED_ERROR,G_SQLCODE_TOKEN,SQLCODE,G_SQLERRM_TOKEN,SQLERRM);
374: -- notify caller of an UNEXPECTED error
375: x_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
376: return(x_return_status);
377: ---------------------------------------------------------------------------------------
378: --Attribute Level Validation Procedure Calls Ends(Modification on TAPI generated Code.)--
379: ---------------------------------------------------------------------------------------

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

388: ---------------------------------------------------
389: FUNCTION Validate_Record (
390: p_vlov_rec IN vlov_rec_type
391: ) RETURN VARCHAR2 IS
392: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
393: ------------------------------------
394: -- FUNCTION validate_foreign_keys --
395: ------------------------------------
396: FUNCTION validate_foreign_keys (

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

405: SELECT 'x'
406: FROM Okc_Operations_B
407: WHERE okc_operations_b.code = p_code;
408: l_dummy VARCHAR2(1);
409: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
410: l_row_notfound BOOLEAN := TRUE;
411: BEGIN
412: IF (p_vlov_rec.LSE_ID IS NOT NULL)
413: THEN

Line 419: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LSE_ID');

415: FETCH okc_lsev_pk_csr INTO l_dummy;
416: l_row_notfound := okc_lsev_pk_csr%NOTFOUND;
417: CLOSE okc_lsev_pk_csr;
418: IF (l_row_notfound) THEN
419: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'LSE_ID');
420: RAISE item_not_found_error;
421: END IF;
422: END IF;
423: IF (p_vlov_rec.OPN_CODE IS NOT NULL)

Line 430: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OPN_CODE');

426: FETCH okc_opnv_pk_csr INTO l_dummy;
427: l_row_notfound := okc_opnv_pk_csr%NOTFOUND;
428: CLOSE okc_opnv_pk_csr;
429: IF (l_row_notfound) THEN
430: OKC_API.set_message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'OPN_CODE');
431: RAISE item_not_found_error;
432: END IF;
433: END IF;
434: RETURN (l_return_status);

Line 437: l_return_status := OKC_API.G_RET_STS_ERROR;

433: END IF;
434: RETURN (l_return_status);
435: EXCEPTION
436: WHEN item_not_found_error THEN
437: l_return_status := OKC_API.G_RET_STS_ERROR;
438: RETURN (l_return_status);
439: END validate_foreign_keys;
440: BEGIN
441: l_return_status := validate_foreign_keys (p_vlov_rec);

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

489: p_vlov_rec IN vlov_rec_type) IS
490:
491: l_api_version CONSTANT NUMBER := 1;
492: l_api_name CONSTANT VARCHAR2(30) := 'V_validate_row';
493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: l_vlov_rec vlov_rec_type := p_vlov_rec;
495: l_vlo_rec vlo_rec_type;
496: BEGIN
497: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 497: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

493: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
494: l_vlov_rec vlov_rec_type := p_vlov_rec;
495: l_vlo_rec vlo_rec_type;
496: BEGIN
497: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
498: G_PKG_NAME,
499: p_init_msg_list,
500: l_api_version,
501: p_api_version,

Line 504: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

500: l_api_version,
501: p_api_version,
502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_ERROR;
508: END IF;

Line 505: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

501: p_api_version,
502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_ERROR;
508: END IF;
509: --- Validate all non-missing attributes (Item Level Validation)

Line 506: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

502: '_PVT',
503: x_return_status);
504: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_ERROR;
508: END IF;
509: --- Validate all non-missing attributes (Item Level Validation)
510: l_return_status := Validate_Attributes(l_vlov_rec);

Line 507: RAISE OKC_API.G_EXCEPTION_ERROR;

503: x_return_status);
504: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
505: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
506: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
507: RAISE OKC_API.G_EXCEPTION_ERROR;
508: END IF;
509: --- Validate all non-missing attributes (Item Level Validation)
510: l_return_status := Validate_Attributes(l_vlov_rec);
511: --- If any errors happen abort API

Line 512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

508: END IF;
509: --- Validate all non-missing attributes (Item Level Validation)
510: l_return_status := Validate_Attributes(l_vlov_rec);
511: --- If any errors happen abort API
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;

Line 513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

509: --- Validate all non-missing attributes (Item Level Validation)
510: l_return_status := Validate_Attributes(l_vlov_rec);
511: --- If any errors happen abort API
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);

Line 514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

510: l_return_status := Validate_Attributes(l_vlov_rec);
511: --- If any errors happen abort API
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 515: RAISE OKC_API.G_EXCEPTION_ERROR;

511: --- If any errors happen abort API
512: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
513: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

514: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;

Line 519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

515: RAISE OKC_API.G_EXCEPTION_ERROR;
516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

516: END IF;
517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
524: EXCEPTION

Line 521: RAISE OKC_API.G_EXCEPTION_ERROR;

517: l_return_status := Validate_Record(l_vlov_rec);
518: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
524: EXCEPTION
525: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
524: EXCEPTION
525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
527: (

Line 525: WHEN OKC_API.G_EXCEPTION_ERROR THEN

521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
524: EXCEPTION
525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
527: (
528: l_api_name,
529: G_PKG_NAME,

Line 526: x_return_status := OKC_API.HANDLE_EXCEPTIONS

522: END IF;
523: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
524: EXCEPTION
525: WHEN OKC_API.G_EXCEPTION_ERROR THEN
526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
527: (
528: l_api_name,
529: G_PKG_NAME,
530: 'OKC_API.G_RET_STS_ERROR',

Line 530: 'OKC_API.G_RET_STS_ERROR',

526: x_return_status := OKC_API.HANDLE_EXCEPTIONS
527: (
528: l_api_name,
529: G_PKG_NAME,
530: 'OKC_API.G_RET_STS_ERROR',
531: x_msg_count,
532: x_msg_data,
533: '_PVT'
534: );

Line 535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

531: x_msg_count,
532: x_msg_data,
533: '_PVT'
534: );
535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
537: (
538: l_api_name,
539: G_PKG_NAME,

Line 536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

532: x_msg_data,
533: '_PVT'
534: );
535: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
537: (
538: l_api_name,
539: G_PKG_NAME,
540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

536: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
537: (
538: l_api_name,
539: G_PKG_NAME,
540: 'OKC_API.G_RET_STS_UNEXP_ERROR',
541: x_msg_count,
542: x_msg_data,
543: '_PVT'
544: );

Line 546: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

542: x_msg_data,
543: '_PVT'
544: );
545: WHEN OTHERS THEN
546: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
547: (
548: l_api_name,
549: G_PKG_NAME,
550: 'OTHERS',

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

565: p_vlov_tbl IN vlov_tbl_type) IS
566:
567: l_api_version CONSTANT NUMBER := 1;
568: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
570: i NUMBER := 0;
571: BEGIN
572: OKC_API.init_msg_list(p_init_msg_list);
573: -- Make sure PL/SQL table has records in it before passing

Line 572: OKC_API.init_msg_list(p_init_msg_list);

568: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
569: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
570: i NUMBER := 0;
571: BEGIN
572: OKC_API.init_msg_list(p_init_msg_list);
573: -- Make sure PL/SQL table has records in it before passing
574: IF (p_vlov_tbl.COUNT > 0) THEN
575: i := p_vlov_tbl.FIRST;
576: LOOP

Line 579: p_init_msg_list => OKC_API.G_FALSE,

575: i := p_vlov_tbl.FIRST;
576: LOOP
577: validate_row (
578: p_api_version => p_api_version,
579: p_init_msg_list => OKC_API.G_FALSE,
580: x_return_status => x_return_status,
581: x_msg_count => x_msg_count,
582: x_msg_data => x_msg_data,
583: p_vlov_rec => p_vlov_tbl(i));

Line 589: WHEN OKC_API.G_EXCEPTION_ERROR THEN

585: i := p_vlov_tbl.NEXT(i);
586: END LOOP;
587: END IF;
588: EXCEPTION
589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS
591: (
592: l_api_name,
593: G_PKG_NAME,

Line 590: x_return_status := OKC_API.HANDLE_EXCEPTIONS

586: END LOOP;
587: END IF;
588: EXCEPTION
589: WHEN OKC_API.G_EXCEPTION_ERROR THEN
590: x_return_status := OKC_API.HANDLE_EXCEPTIONS
591: (
592: l_api_name,
593: G_PKG_NAME,
594: 'OKC_API.G_RET_STS_ERROR',

Line 594: 'OKC_API.G_RET_STS_ERROR',

590: x_return_status := OKC_API.HANDLE_EXCEPTIONS
591: (
592: l_api_name,
593: G_PKG_NAME,
594: 'OKC_API.G_RET_STS_ERROR',
595: x_msg_count,
596: x_msg_data,
597: '_PVT'
598: );

Line 599: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

595: x_msg_count,
596: x_msg_data,
597: '_PVT'
598: );
599: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
600: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,
603: G_PKG_NAME,

Line 600: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

596: x_msg_data,
597: '_PVT'
598: );
599: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
600: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,
603: G_PKG_NAME,
604: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 604: 'OKC_API.G_RET_STS_UNEXP_ERROR',

600: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
601: (
602: l_api_name,
603: G_PKG_NAME,
604: 'OKC_API.G_RET_STS_UNEXP_ERROR',
605: x_msg_count,
606: x_msg_data,
607: '_PVT'
608: );

Line 610: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

606: x_msg_data,
607: '_PVT'
608: );
609: WHEN OTHERS THEN
610: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
611: (
612: l_api_name,
613: G_PKG_NAME,
614: 'OTHERS',

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

633: x_vlo_rec OUT NOCOPY vlo_rec_type) IS
634:
635: l_api_version CONSTANT NUMBER := 1;
636: l_api_name CONSTANT VARCHAR2(30) := 'OPERATIONS_insert_row';
637: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
638: l_vlo_rec vlo_rec_type := p_vlo_rec;
639: l_def_vlo_rec vlo_rec_type;
640: ------------------------------------------------
641: -- Set_Attributes for:OKC_VAL_LINE_OPERATIONS --

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

643: FUNCTION Set_Attributes (
644: p_vlo_rec IN vlo_rec_type,
645: x_vlo_rec OUT NOCOPY vlo_rec_type
646: ) RETURN VARCHAR2 IS
647: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
648: BEGIN
649: x_vlo_rec := p_vlo_rec;
650: RETURN(l_return_status);
651: END Set_Attributes;

Line 653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

649: x_vlo_rec := p_vlo_rec;
650: RETURN(l_return_status);
651: END Set_Attributes;
652: BEGIN
653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
654: p_init_msg_list,
655: '_PVT',
656: x_return_status);
657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

653: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
654: p_init_msg_list,
655: '_PVT',
656: x_return_status);
657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
660: RAISE OKC_API.G_EXCEPTION_ERROR;
661: END IF;

Line 658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

654: p_init_msg_list,
655: '_PVT',
656: x_return_status);
657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
660: RAISE OKC_API.G_EXCEPTION_ERROR;
661: END IF;
662: --- Setting item attributes

Line 659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

655: '_PVT',
656: x_return_status);
657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
660: RAISE OKC_API.G_EXCEPTION_ERROR;
661: END IF;
662: --- Setting item attributes
663: l_return_status := Set_Attributes(

Line 660: RAISE OKC_API.G_EXCEPTION_ERROR;

656: x_return_status);
657: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
658: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
659: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
660: RAISE OKC_API.G_EXCEPTION_ERROR;
661: END IF;
662: --- Setting item attributes
663: l_return_status := Set_Attributes(
664: p_vlo_rec, -- IN

Line 667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

663: l_return_status := Set_Attributes(
664: p_vlo_rec, -- IN
665: l_vlo_rec); -- OUT
666: --- If any errors happen abort API
667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
670: RAISE OKC_API.G_EXCEPTION_ERROR;
671: END IF;

Line 668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

664: p_vlo_rec, -- IN
665: l_vlo_rec); -- OUT
666: --- If any errors happen abort API
667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
670: RAISE OKC_API.G_EXCEPTION_ERROR;
671: END IF;
672: INSERT INTO OKC_VAL_LINE_OPERATIONS(

Line 669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

665: l_vlo_rec); -- OUT
666: --- If any errors happen abort API
667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
670: RAISE OKC_API.G_EXCEPTION_ERROR;
671: END IF;
672: INSERT INTO OKC_VAL_LINE_OPERATIONS(
673: lse_id,

Line 670: RAISE OKC_API.G_EXCEPTION_ERROR;

666: --- If any errors happen abort API
667: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
668: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
669: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
670: RAISE OKC_API.G_EXCEPTION_ERROR;
671: END IF;
672: INSERT INTO OKC_VAL_LINE_OPERATIONS(
673: lse_id,
674: opn_code,

Line 692: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

688: l_vlo_rec.last_update_date,
689: l_vlo_rec.last_update_login);
690: -- Set OUT values
691: x_vlo_rec := l_vlo_rec;
692: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
693: EXCEPTION
694: WHEN OKC_API.G_EXCEPTION_ERROR THEN
695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
696: (

Line 694: WHEN OKC_API.G_EXCEPTION_ERROR THEN

690: -- Set OUT values
691: x_vlo_rec := l_vlo_rec;
692: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
693: EXCEPTION
694: WHEN OKC_API.G_EXCEPTION_ERROR THEN
695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
696: (
697: l_api_name,
698: G_PKG_NAME,

Line 695: x_return_status := OKC_API.HANDLE_EXCEPTIONS

691: x_vlo_rec := l_vlo_rec;
692: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
693: EXCEPTION
694: WHEN OKC_API.G_EXCEPTION_ERROR THEN
695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
696: (
697: l_api_name,
698: G_PKG_NAME,
699: 'OKC_API.G_RET_STS_ERROR',

Line 699: 'OKC_API.G_RET_STS_ERROR',

695: x_return_status := OKC_API.HANDLE_EXCEPTIONS
696: (
697: l_api_name,
698: G_PKG_NAME,
699: 'OKC_API.G_RET_STS_ERROR',
700: x_msg_count,
701: x_msg_data,
702: '_PVT'
703: );

Line 704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

700: x_msg_count,
701: x_msg_data,
702: '_PVT'
703: );
704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,

Line 705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

701: x_msg_data,
702: '_PVT'
703: );
704: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,
709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 709: 'OKC_API.G_RET_STS_UNEXP_ERROR',

705: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
706: (
707: l_api_name,
708: G_PKG_NAME,
709: 'OKC_API.G_RET_STS_UNEXP_ERROR',
710: x_msg_count,
711: x_msg_data,
712: '_PVT'
713: );

Line 715: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

711: x_msg_data,
712: '_PVT'
713: );
714: WHEN OTHERS THEN
715: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
716: (
717: l_api_name,
718: G_PKG_NAME,
719: 'OTHERS',

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

735: x_vlov_rec OUT NOCOPY vlov_rec_type) IS
736:
737: l_api_version CONSTANT NUMBER := 1;
738: l_api_name CONSTANT VARCHAR2(30) := 'V_insert_row';
739: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
740: l_vlov_rec vlov_rec_type;
741: l_def_vlov_rec vlov_rec_type;
742: l_vlo_rec vlo_rec_type;
743: lx_vlo_rec vlo_rec_type;

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

762: FUNCTION Set_Attributes (
763: p_vlov_rec IN vlov_rec_type,
764: x_vlov_rec OUT NOCOPY vlov_rec_type
765: ) RETURN VARCHAR2 IS
766: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
767: BEGIN
768: x_vlov_rec := p_vlov_rec;
769: x_vlov_rec.OBJECT_VERSION_NUMBER := 1;
770: RETURN(l_return_status);

Line 773: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

769: x_vlov_rec.OBJECT_VERSION_NUMBER := 1;
770: RETURN(l_return_status);
771: END Set_Attributes;
772: BEGIN
773: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
774: G_PKG_NAME,
775: p_init_msg_list,
776: l_api_version,
777: p_api_version,

Line 780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

776: l_api_version,
777: p_api_version,
778: '_PVT',
779: x_return_status);
780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_ERROR;
784: END IF;

Line 781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

777: p_api_version,
778: '_PVT',
779: x_return_status);
780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_ERROR;
784: END IF;
785: l_vlov_rec := null_out_defaults(p_vlov_rec);

Line 782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

778: '_PVT',
779: x_return_status);
780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_ERROR;
784: END IF;
785: l_vlov_rec := null_out_defaults(p_vlov_rec);
786: --- Setting item attributes

Line 783: RAISE OKC_API.G_EXCEPTION_ERROR;

779: x_return_status);
780: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
781: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
782: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
783: RAISE OKC_API.G_EXCEPTION_ERROR;
784: END IF;
785: l_vlov_rec := null_out_defaults(p_vlov_rec);
786: --- Setting item attributes
787: l_return_status := Set_Attributes(

Line 791: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

787: l_return_status := Set_Attributes(
788: l_vlov_rec, -- IN
789: l_def_vlov_rec); -- OUT
790: --- If any errors happen abort API
791: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
794: RAISE OKC_API.G_EXCEPTION_ERROR;
795: END IF;

Line 792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

788: l_vlov_rec, -- IN
789: l_def_vlov_rec); -- OUT
790: --- If any errors happen abort API
791: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
794: RAISE OKC_API.G_EXCEPTION_ERROR;
795: END IF;
796: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);

Line 793: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

789: l_def_vlov_rec); -- OUT
790: --- If any errors happen abort API
791: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
794: RAISE OKC_API.G_EXCEPTION_ERROR;
795: END IF;
796: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
797: --- Validate all non-missing attributes (Item Level Validation)

Line 794: RAISE OKC_API.G_EXCEPTION_ERROR;

790: --- If any errors happen abort API
791: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
794: RAISE OKC_API.G_EXCEPTION_ERROR;
795: END IF;
796: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
797: --- Validate all non-missing attributes (Item Level Validation)
798: l_return_status := Validate_Attributes(l_def_vlov_rec);

Line 800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

796: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
797: --- Validate all non-missing attributes (Item Level Validation)
798: l_return_status := Validate_Attributes(l_def_vlov_rec);
799: --- If any errors happen abort API
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;

Line 801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

797: --- Validate all non-missing attributes (Item Level Validation)
798: l_return_status := Validate_Attributes(l_def_vlov_rec);
799: --- If any errors happen abort API
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);

Line 802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

798: l_return_status := Validate_Attributes(l_def_vlov_rec);
799: --- If any errors happen abort API
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 803: RAISE OKC_API.G_EXCEPTION_ERROR;

799: --- If any errors happen abort API
800: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
801: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

802: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_ERROR;
810: END IF;

Line 807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

803: RAISE OKC_API.G_EXCEPTION_ERROR;
804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_ERROR;
810: END IF;
811:

Line 808: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

804: END IF;
805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_ERROR;
810: END IF;
811:
812:

Line 809: RAISE OKC_API.G_EXCEPTION_ERROR;

805: l_return_status := Validate_Record(l_def_vlov_rec);
806: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
807: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
808: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
809: RAISE OKC_API.G_EXCEPTION_ERROR;
810: END IF;
811:
812:
813: /****************ADDED AFTER TAPI**************/

Line 815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

811:
812:
813: /****************ADDED AFTER TAPI**************/
814: validate_unique(l_def_vlov_rec,l_return_status);
815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
818: RAISE OKC_API.G_EXCEPTION_ERROR;
819: END IF;

Line 816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

812:
813: /****************ADDED AFTER TAPI**************/
814: validate_unique(l_def_vlov_rec,l_return_status);
815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
818: RAISE OKC_API.G_EXCEPTION_ERROR;
819: END IF;
820: /****************END ADDED AFTER TAPI**************/

Line 817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

813: /****************ADDED AFTER TAPI**************/
814: validate_unique(l_def_vlov_rec,l_return_status);
815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
818: RAISE OKC_API.G_EXCEPTION_ERROR;
819: END IF;
820: /****************END ADDED AFTER TAPI**************/
821: --------------------------------------

Line 818: RAISE OKC_API.G_EXCEPTION_ERROR;

814: validate_unique(l_def_vlov_rec,l_return_status);
815: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
816: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
817: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
818: RAISE OKC_API.G_EXCEPTION_ERROR;
819: END IF;
820: /****************END ADDED AFTER TAPI**************/
821: --------------------------------------
822:

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

834: x_msg_data,
835: l_vlo_rec,
836: lx_vlo_rec
837: );
838: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
841: RAISE OKC_API.G_EXCEPTION_ERROR;
842: END IF;

Line 839: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

835: l_vlo_rec,
836: lx_vlo_rec
837: );
838: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
841: RAISE OKC_API.G_EXCEPTION_ERROR;
842: END IF;
843: migrate(lx_vlo_rec, l_def_vlov_rec);

Line 840: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

836: lx_vlo_rec
837: );
838: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
841: RAISE OKC_API.G_EXCEPTION_ERROR;
842: END IF;
843: migrate(lx_vlo_rec, l_def_vlov_rec);
844: -- Set OUT values

Line 841: RAISE OKC_API.G_EXCEPTION_ERROR;

837: );
838: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
839: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
840: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
841: RAISE OKC_API.G_EXCEPTION_ERROR;
842: END IF;
843: migrate(lx_vlo_rec, l_def_vlov_rec);
844: -- Set OUT values
845: x_vlov_rec := l_def_vlov_rec;

Line 846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

842: END IF;
843: migrate(lx_vlo_rec, l_def_vlov_rec);
844: -- Set OUT values
845: x_vlov_rec := l_def_vlov_rec;
846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
847: EXCEPTION
848: WHEN OKC_API.G_EXCEPTION_ERROR THEN
849: x_return_status := OKC_API.HANDLE_EXCEPTIONS
850: (

Line 848: WHEN OKC_API.G_EXCEPTION_ERROR THEN

844: -- Set OUT values
845: x_vlov_rec := l_def_vlov_rec;
846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
847: EXCEPTION
848: WHEN OKC_API.G_EXCEPTION_ERROR THEN
849: x_return_status := OKC_API.HANDLE_EXCEPTIONS
850: (
851: l_api_name,
852: G_PKG_NAME,

Line 849: x_return_status := OKC_API.HANDLE_EXCEPTIONS

845: x_vlov_rec := l_def_vlov_rec;
846: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
847: EXCEPTION
848: WHEN OKC_API.G_EXCEPTION_ERROR THEN
849: x_return_status := OKC_API.HANDLE_EXCEPTIONS
850: (
851: l_api_name,
852: G_PKG_NAME,
853: 'OKC_API.G_RET_STS_ERROR',

Line 853: 'OKC_API.G_RET_STS_ERROR',

849: x_return_status := OKC_API.HANDLE_EXCEPTIONS
850: (
851: l_api_name,
852: G_PKG_NAME,
853: 'OKC_API.G_RET_STS_ERROR',
854: x_msg_count,
855: x_msg_data,
856: '_PVT'
857: );

Line 858: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

854: x_msg_count,
855: x_msg_data,
856: '_PVT'
857: );
858: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
859: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
860: (
861: l_api_name,
862: G_PKG_NAME,

Line 859: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

855: x_msg_data,
856: '_PVT'
857: );
858: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
859: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
860: (
861: l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 863: 'OKC_API.G_RET_STS_UNEXP_ERROR',

859: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
860: (
861: l_api_name,
862: G_PKG_NAME,
863: 'OKC_API.G_RET_STS_UNEXP_ERROR',
864: x_msg_count,
865: x_msg_data,
866: '_PVT'
867: );

Line 869: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

865: x_msg_data,
866: '_PVT'
867: );
868: WHEN OTHERS THEN
869: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
870: (
871: l_api_name,
872: G_PKG_NAME,
873: 'OTHERS',

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

889: x_vlov_tbl OUT NOCOPY vlov_tbl_type) IS
890:
891: l_api_version CONSTANT NUMBER := 1;
892: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
893: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
894: i NUMBER := 0;
895: BEGIN
896: OKC_API.init_msg_list(p_init_msg_list);
897: -- Make sure PL/SQL table has records in it before passing

Line 896: OKC_API.init_msg_list(p_init_msg_list);

892: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
893: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
894: i NUMBER := 0;
895: BEGIN
896: OKC_API.init_msg_list(p_init_msg_list);
897: -- Make sure PL/SQL table has records in it before passing
898: IF (p_vlov_tbl.COUNT > 0) THEN
899: i := p_vlov_tbl.FIRST;
900: LOOP

Line 903: p_init_msg_list => OKC_API.G_FALSE,

899: i := p_vlov_tbl.FIRST;
900: LOOP
901: insert_row (
902: p_api_version => p_api_version,
903: p_init_msg_list => OKC_API.G_FALSE,
904: x_return_status => x_return_status,
905: x_msg_count => x_msg_count,
906: x_msg_data => x_msg_data,
907: p_vlov_rec => p_vlov_tbl(i),

Line 914: WHEN OKC_API.G_EXCEPTION_ERROR THEN

910: i := p_vlov_tbl.NEXT(i);
911: END LOOP;
912: END IF;
913: EXCEPTION
914: WHEN OKC_API.G_EXCEPTION_ERROR THEN
915: x_return_status := OKC_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,

Line 915: x_return_status := OKC_API.HANDLE_EXCEPTIONS

911: END LOOP;
912: END IF;
913: EXCEPTION
914: WHEN OKC_API.G_EXCEPTION_ERROR THEN
915: x_return_status := OKC_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,
919: 'OKC_API.G_RET_STS_ERROR',

Line 919: 'OKC_API.G_RET_STS_ERROR',

915: x_return_status := OKC_API.HANDLE_EXCEPTIONS
916: (
917: l_api_name,
918: G_PKG_NAME,
919: 'OKC_API.G_RET_STS_ERROR',
920: x_msg_count,
921: x_msg_data,
922: '_PVT'
923: );

Line 924: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

920: x_msg_count,
921: x_msg_data,
922: '_PVT'
923: );
924: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
925: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,

Line 925: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

921: x_msg_data,
922: '_PVT'
923: );
924: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
925: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,
929: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 929: 'OKC_API.G_RET_STS_UNEXP_ERROR',

925: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
926: (
927: l_api_name,
928: G_PKG_NAME,
929: 'OKC_API.G_RET_STS_UNEXP_ERROR',
930: x_msg_count,
931: x_msg_data,
932: '_PVT'
933: );

Line 935: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

931: x_msg_data,
932: '_PVT'
933: );
934: WHEN OTHERS THEN
935: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
936: (
937: l_api_name,
938: G_PKG_NAME,
939: 'OTHERS',

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

972: WHERE LSE_ID = p_vlo_rec.lse_id
973: AND OPN_CODE = p_vlo_rec.opn_code;
974: l_api_version CONSTANT NUMBER := 1;
975: l_api_name CONSTANT VARCHAR2(30) := 'OPERATIONS_lock_row';
976: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
977: l_object_version_number OKC_VAL_LINE_OPERATIONS.OBJECT_VERSION_NUMBER%TYPE;
978: lc_object_version_number OKC_VAL_LINE_OPERATIONS.OBJECT_VERSION_NUMBER%TYPE;
979: l_row_notfound BOOLEAN := FALSE;
980: lc_row_notfound BOOLEAN := FALSE;

Line 982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

978: lc_object_version_number OKC_VAL_LINE_OPERATIONS.OBJECT_VERSION_NUMBER%TYPE;
979: l_row_notfound BOOLEAN := FALSE;
980: lc_row_notfound BOOLEAN := FALSE;
981: BEGIN
982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
983: p_init_msg_list,
984: '_PVT',
985: x_return_status);
986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

982: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
983: p_init_msg_list,
984: '_PVT',
985: x_return_status);
986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_ERROR;
990: END IF;

Line 987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

983: p_init_msg_list,
984: '_PVT',
985: x_return_status);
986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_ERROR;
990: END IF;
991: BEGIN

Line 988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

984: '_PVT',
985: x_return_status);
986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_ERROR;
990: END IF;
991: BEGIN
992: OPEN lock_csr(p_vlo_rec);

Line 989: RAISE OKC_API.G_EXCEPTION_ERROR;

985: x_return_status);
986: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
987: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
988: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
989: RAISE OKC_API.G_EXCEPTION_ERROR;
990: END IF;
991: BEGIN
992: OPEN lock_csr(p_vlo_rec);
993: FETCH lock_csr INTO l_object_version_number;

Line 1001: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

997: WHEN E_Resource_Busy THEN
998: IF (lock_csr%ISOPEN) THEN
999: CLOSE lock_csr;
1000: END IF;
1001: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1002: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1003: END;
1004:
1005: IF ( l_row_notfound ) THEN

Line 1012: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1008: lc_row_notfound := lchk_csr%NOTFOUND;
1009: CLOSE lchk_csr;
1010: END IF;
1011: IF (lc_row_notfound) THEN
1012: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: ELSIF lc_object_version_number > p_vlo_rec.object_version_number THEN
1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1013: RAISE OKC_API.G_EXCEPTION_ERROR;

1009: CLOSE lchk_csr;
1010: END IF;
1011: IF (lc_row_notfound) THEN
1012: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: ELSIF lc_object_version_number > p_vlo_rec.object_version_number THEN
1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN

Line 1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1011: IF (lc_row_notfound) THEN
1012: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: ELSIF lc_object_version_number > p_vlo_rec.object_version_number THEN
1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN
1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1016: RAISE OKC_API.G_EXCEPTION_ERROR;

1012: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1013: RAISE OKC_API.G_EXCEPTION_ERROR;
1014: ELSIF lc_object_version_number > p_vlo_rec.object_version_number THEN
1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN
1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: ELSIF lc_object_version_number = -1 THEN

Line 1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1014: ELSIF lc_object_version_number > p_vlo_rec.object_version_number THEN
1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN
1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: ELSIF lc_object_version_number = -1 THEN
1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1022: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1019: RAISE OKC_API.G_EXCEPTION_ERROR;

1015: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1016: RAISE OKC_API.G_EXCEPTION_ERROR;
1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN
1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: ELSIF lc_object_version_number = -1 THEN
1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;

Line 1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1017: ELSIF lc_object_version_number <> p_vlo_rec.object_version_number THEN
1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: ELSIF lc_object_version_number = -1 THEN
1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION

Line 1022: RAISE OKC_API.G_EXCEPTION_ERROR;

1018: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1019: RAISE OKC_API.G_EXCEPTION_ERROR;
1020: ELSIF lc_object_version_number = -1 THEN
1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1020: ELSIF lc_object_version_number = -1 THEN
1021: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (

Line 1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1022: RAISE OKC_API.G_EXCEPTION_ERROR;
1023: END IF;
1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,

Line 1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1023: END IF;
1024: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1025: EXCEPTION
1026: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKC_API.G_RET_STS_ERROR',

Line 1031: 'OKC_API.G_RET_STS_ERROR',

1027: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1028: (
1029: l_api_name,
1030: G_PKG_NAME,
1031: 'OKC_API.G_RET_STS_ERROR',
1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );

Line 1036: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1032: x_msg_count,
1033: x_msg_data,
1034: '_PVT'
1035: );
1036: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1037: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,

Line 1037: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1033: x_msg_data,
1034: '_PVT'
1035: );
1036: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1037: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1041: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1037: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1038: (
1039: l_api_name,
1040: G_PKG_NAME,
1041: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1042: x_msg_count,
1043: x_msg_data,
1044: '_PVT'
1045: );

Line 1047: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1043: x_msg_data,
1044: '_PVT'
1045: );
1046: WHEN OTHERS THEN
1047: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1048: (
1049: l_api_name,
1050: G_PKG_NAME,
1051: 'OTHERS',

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

1066: p_vlov_rec IN vlov_rec_type) IS
1067:
1068: l_api_version CONSTANT NUMBER := 1;
1069: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1070: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1071: l_vlo_rec vlo_rec_type;
1072: BEGIN
1073: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1074: G_PKG_NAME,

Line 1073: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1069: l_api_name CONSTANT VARCHAR2(30) := 'V_lock_row';
1070: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1071: l_vlo_rec vlo_rec_type;
1072: BEGIN
1073: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1074: G_PKG_NAME,
1075: p_init_msg_list,
1076: l_api_version,
1077: p_api_version,

Line 1080: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1076: l_api_version,
1077: p_api_version,
1078: '_PVT',
1079: x_return_status);
1080: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1083: RAISE OKC_API.G_EXCEPTION_ERROR;
1084: END IF;

Line 1081: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1077: p_api_version,
1078: '_PVT',
1079: x_return_status);
1080: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1083: RAISE OKC_API.G_EXCEPTION_ERROR;
1084: END IF;
1085: --------------------------------------

Line 1082: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1078: '_PVT',
1079: x_return_status);
1080: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1083: RAISE OKC_API.G_EXCEPTION_ERROR;
1084: END IF;
1085: --------------------------------------
1086: -- Move VIEW record to "Child" records

Line 1083: RAISE OKC_API.G_EXCEPTION_ERROR;

1079: x_return_status);
1080: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1081: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1082: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1083: RAISE OKC_API.G_EXCEPTION_ERROR;
1084: END IF;
1085: --------------------------------------
1086: -- Move VIEW record to "Child" records
1087: --------------------------------------

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

1095: x_msg_count,
1096: x_msg_data,
1097: l_vlo_rec
1098: );
1099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;

Line 1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1096: x_msg_data,
1097: l_vlo_rec
1098: );
1099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1097: l_vlo_rec
1098: );
1099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1105: EXCEPTION

Line 1102: RAISE OKC_API.G_EXCEPTION_ERROR;

1098: );
1099: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1105: EXCEPTION
1106: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1100: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1105: EXCEPTION
1106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1108: (

Line 1106: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1102: RAISE OKC_API.G_EXCEPTION_ERROR;
1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1105: EXCEPTION
1106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,

Line 1107: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1103: END IF;
1104: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1105: EXCEPTION
1106: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,
1111: 'OKC_API.G_RET_STS_ERROR',

Line 1111: 'OKC_API.G_RET_STS_ERROR',

1107: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1108: (
1109: l_api_name,
1110: G_PKG_NAME,
1111: 'OKC_API.G_RET_STS_ERROR',
1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT'
1115: );

Line 1116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1112: x_msg_count,
1113: x_msg_data,
1114: '_PVT'
1115: );
1116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,

Line 1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1113: x_msg_data,
1114: '_PVT'
1115: );
1116: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1121: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1117: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1118: (
1119: l_api_name,
1120: G_PKG_NAME,
1121: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1122: x_msg_count,
1123: x_msg_data,
1124: '_PVT'
1125: );

Line 1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1123: x_msg_data,
1124: '_PVT'
1125: );
1126: WHEN OTHERS THEN
1127: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'OTHERS',

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

1146: p_vlov_tbl IN vlov_tbl_type) IS
1147:
1148: l_api_version CONSTANT NUMBER := 1;
1149: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1150: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1151: i NUMBER := 0;
1152: BEGIN
1153: OKC_API.init_msg_list(p_init_msg_list);
1154: -- Make sure PL/SQL table has records in it before passing

Line 1153: OKC_API.init_msg_list(p_init_msg_list);

1149: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
1150: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1151: i NUMBER := 0;
1152: BEGIN
1153: OKC_API.init_msg_list(p_init_msg_list);
1154: -- Make sure PL/SQL table has records in it before passing
1155: IF (p_vlov_tbl.COUNT > 0) THEN
1156: i := p_vlov_tbl.FIRST;
1157: LOOP

Line 1160: p_init_msg_list => OKC_API.G_FALSE,

1156: i := p_vlov_tbl.FIRST;
1157: LOOP
1158: lock_row (
1159: p_api_version => p_api_version,
1160: p_init_msg_list => OKC_API.G_FALSE,
1161: x_return_status => x_return_status,
1162: x_msg_count => x_msg_count,
1163: x_msg_data => x_msg_data,
1164: p_vlov_rec => p_vlov_tbl(i));

Line 1170: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1166: i := p_vlov_tbl.NEXT(i);
1167: END LOOP;
1168: END IF;
1169: EXCEPTION
1170: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1172: (
1173: l_api_name,
1174: G_PKG_NAME,

Line 1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1167: END LOOP;
1168: END IF;
1169: EXCEPTION
1170: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1172: (
1173: l_api_name,
1174: G_PKG_NAME,
1175: 'OKC_API.G_RET_STS_ERROR',

Line 1175: 'OKC_API.G_RET_STS_ERROR',

1171: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1172: (
1173: l_api_name,
1174: G_PKG_NAME,
1175: 'OKC_API.G_RET_STS_ERROR',
1176: x_msg_count,
1177: x_msg_data,
1178: '_PVT'
1179: );

Line 1180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1176: x_msg_count,
1177: x_msg_data,
1178: '_PVT'
1179: );
1180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1181: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1182: (
1183: l_api_name,
1184: G_PKG_NAME,

Line 1181: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1177: x_msg_data,
1178: '_PVT'
1179: );
1180: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1181: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1182: (
1183: l_api_name,
1184: G_PKG_NAME,
1185: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1185: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1181: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1182: (
1183: l_api_name,
1184: G_PKG_NAME,
1185: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1186: x_msg_count,
1187: x_msg_data,
1188: '_PVT'
1189: );

Line 1191: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1187: x_msg_data,
1188: '_PVT'
1189: );
1190: WHEN OTHERS THEN
1191: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1192: (
1193: l_api_name,
1194: G_PKG_NAME,
1195: 'OTHERS',

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

1214: x_vlo_rec OUT NOCOPY vlo_rec_type) IS
1215:
1216: l_api_version CONSTANT NUMBER := 1;
1217: l_api_name CONSTANT VARCHAR2(30) := 'OPERATIONS_update_row';
1218: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1219: l_vlo_rec vlo_rec_type := p_vlo_rec;
1220: l_def_vlo_rec vlo_rec_type;
1221: l_row_notfound BOOLEAN := TRUE;
1222: ----------------------------------

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

1227: x_vlo_rec OUT NOCOPY vlo_rec_type
1228: ) RETURN VARCHAR2 IS
1229: l_vlo_rec vlo_rec_type;
1230: l_row_notfound BOOLEAN := TRUE;
1231: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1232: BEGIN
1233: x_vlo_rec := p_vlo_rec;
1234: -- Get current database values
1235: l_vlo_rec := get_rec(p_vlo_rec, l_row_notfound);

Line 1237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1233: x_vlo_rec := p_vlo_rec;
1234: -- Get current database values
1235: l_vlo_rec := get_rec(p_vlo_rec, l_row_notfound);
1236: IF (l_row_notfound) THEN
1237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1238: END IF;
1239: IF (x_vlo_rec.lse_id = OKC_API.G_MISS_NUM)
1240: THEN
1241: x_vlo_rec.lse_id := l_vlo_rec.lse_id;

Line 1239: IF (x_vlo_rec.lse_id = OKC_API.G_MISS_NUM)

1235: l_vlo_rec := get_rec(p_vlo_rec, l_row_notfound);
1236: IF (l_row_notfound) THEN
1237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1238: END IF;
1239: IF (x_vlo_rec.lse_id = OKC_API.G_MISS_NUM)
1240: THEN
1241: x_vlo_rec.lse_id := l_vlo_rec.lse_id;
1242: END IF;
1243: IF (x_vlo_rec.opn_code = OKC_API.G_MISS_CHAR)

Line 1243: IF (x_vlo_rec.opn_code = OKC_API.G_MISS_CHAR)

1239: IF (x_vlo_rec.lse_id = OKC_API.G_MISS_NUM)
1240: THEN
1241: x_vlo_rec.lse_id := l_vlo_rec.lse_id;
1242: END IF;
1243: IF (x_vlo_rec.opn_code = OKC_API.G_MISS_CHAR)
1244: THEN
1245: x_vlo_rec.opn_code := l_vlo_rec.opn_code;
1246: END IF;
1247: IF (x_vlo_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1247: IF (x_vlo_rec.object_version_number = OKC_API.G_MISS_NUM)

1243: IF (x_vlo_rec.opn_code = OKC_API.G_MISS_CHAR)
1244: THEN
1245: x_vlo_rec.opn_code := l_vlo_rec.opn_code;
1246: END IF;
1247: IF (x_vlo_rec.object_version_number = OKC_API.G_MISS_NUM)
1248: THEN
1249: x_vlo_rec.object_version_number := l_vlo_rec.object_version_number;
1250: END IF;
1251: IF (x_vlo_rec.created_by = OKC_API.G_MISS_NUM)

Line 1251: IF (x_vlo_rec.created_by = OKC_API.G_MISS_NUM)

1247: IF (x_vlo_rec.object_version_number = OKC_API.G_MISS_NUM)
1248: THEN
1249: x_vlo_rec.object_version_number := l_vlo_rec.object_version_number;
1250: END IF;
1251: IF (x_vlo_rec.created_by = OKC_API.G_MISS_NUM)
1252: THEN
1253: x_vlo_rec.created_by := l_vlo_rec.created_by;
1254: END IF;
1255: IF (x_vlo_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1255: IF (x_vlo_rec.creation_date = OKC_API.G_MISS_DATE)

1251: IF (x_vlo_rec.created_by = OKC_API.G_MISS_NUM)
1252: THEN
1253: x_vlo_rec.created_by := l_vlo_rec.created_by;
1254: END IF;
1255: IF (x_vlo_rec.creation_date = OKC_API.G_MISS_DATE)
1256: THEN
1257: x_vlo_rec.creation_date := l_vlo_rec.creation_date;
1258: END IF;
1259: IF (x_vlo_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1259: IF (x_vlo_rec.last_updated_by = OKC_API.G_MISS_NUM)

1255: IF (x_vlo_rec.creation_date = OKC_API.G_MISS_DATE)
1256: THEN
1257: x_vlo_rec.creation_date := l_vlo_rec.creation_date;
1258: END IF;
1259: IF (x_vlo_rec.last_updated_by = OKC_API.G_MISS_NUM)
1260: THEN
1261: x_vlo_rec.last_updated_by := l_vlo_rec.last_updated_by;
1262: END IF;
1263: IF (x_vlo_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1263: IF (x_vlo_rec.last_update_date = OKC_API.G_MISS_DATE)

1259: IF (x_vlo_rec.last_updated_by = OKC_API.G_MISS_NUM)
1260: THEN
1261: x_vlo_rec.last_updated_by := l_vlo_rec.last_updated_by;
1262: END IF;
1263: IF (x_vlo_rec.last_update_date = OKC_API.G_MISS_DATE)
1264: THEN
1265: x_vlo_rec.last_update_date := l_vlo_rec.last_update_date;
1266: END IF;
1267: IF (x_vlo_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1267: IF (x_vlo_rec.last_update_login = OKC_API.G_MISS_NUM)

1263: IF (x_vlo_rec.last_update_date = OKC_API.G_MISS_DATE)
1264: THEN
1265: x_vlo_rec.last_update_date := l_vlo_rec.last_update_date;
1266: END IF;
1267: IF (x_vlo_rec.last_update_login = OKC_API.G_MISS_NUM)
1268: THEN
1269: x_vlo_rec.last_update_login := l_vlo_rec.last_update_login;
1270: END IF;
1271: RETURN(l_return_status);

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

1276: FUNCTION Set_Attributes (
1277: p_vlo_rec IN vlo_rec_type,
1278: x_vlo_rec OUT NOCOPY vlo_rec_type
1279: ) RETURN VARCHAR2 IS
1280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1281: BEGIN
1282: x_vlo_rec := p_vlo_rec;
1283: RETURN(l_return_status);
1284: END Set_Attributes;

Line 1286: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1282: x_vlo_rec := p_vlo_rec;
1283: RETURN(l_return_status);
1284: END Set_Attributes;
1285: BEGIN
1286: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1287: p_init_msg_list,
1288: '_PVT',
1289: x_return_status);
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1286: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1287: p_init_msg_list,
1288: '_PVT',
1289: x_return_status);
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_ERROR;
1294: END IF;

Line 1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1287: p_init_msg_list,
1288: '_PVT',
1289: x_return_status);
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_ERROR;
1294: END IF;
1295: --- Setting item attributes

Line 1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1288: '_PVT',
1289: x_return_status);
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_ERROR;
1294: END IF;
1295: --- Setting item attributes
1296: l_return_status := Set_Attributes(

Line 1293: RAISE OKC_API.G_EXCEPTION_ERROR;

1289: x_return_status);
1290: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1291: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1292: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1293: RAISE OKC_API.G_EXCEPTION_ERROR;
1294: END IF;
1295: --- Setting item attributes
1296: l_return_status := Set_Attributes(
1297: p_vlo_rec, -- IN

Line 1300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1296: l_return_status := Set_Attributes(
1297: p_vlo_rec, -- IN
1298: l_vlo_rec); -- OUT
1299: --- If any errors happen abort API
1300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;

Line 1301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1297: p_vlo_rec, -- IN
1298: l_vlo_rec); -- OUT
1299: --- If any errors happen abort API
1300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);

Line 1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1298: l_vlo_rec); -- OUT
1299: --- If any errors happen abort API
1300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1303: RAISE OKC_API.G_EXCEPTION_ERROR;

1299: --- If any errors happen abort API
1300: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1302: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1309: RAISE OKC_API.G_EXCEPTION_ERROR;
1310: END IF;

Line 1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1303: RAISE OKC_API.G_EXCEPTION_ERROR;
1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1309: RAISE OKC_API.G_EXCEPTION_ERROR;
1310: END IF;
1311: UPDATE OKC_VAL_LINE_OPERATIONS

Line 1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1304: END IF;
1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1309: RAISE OKC_API.G_EXCEPTION_ERROR;
1310: END IF;
1311: UPDATE OKC_VAL_LINE_OPERATIONS
1312: SET OBJECT_VERSION_NUMBER = l_def_vlo_rec.object_version_number,

Line 1309: RAISE OKC_API.G_EXCEPTION_ERROR;

1305: l_return_status := populate_new_record(l_vlo_rec, l_def_vlo_rec);
1306: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1307: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1308: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1309: RAISE OKC_API.G_EXCEPTION_ERROR;
1310: END IF;
1311: UPDATE OKC_VAL_LINE_OPERATIONS
1312: SET OBJECT_VERSION_NUMBER = l_def_vlo_rec.object_version_number,
1313: CREATED_BY = l_def_vlo_rec.created_by,

Line 1322: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1318: WHERE LSE_ID = l_def_vlo_rec.lse_id
1319: AND OPN_CODE = l_def_vlo_rec.opn_code;
1320:
1321: x_vlo_rec := l_def_vlo_rec;
1322: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (

Line 1324: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1320:
1321: x_vlo_rec := l_def_vlo_rec;
1322: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,

Line 1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1321: x_vlo_rec := l_def_vlo_rec;
1322: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1323: EXCEPTION
1324: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKC_API.G_RET_STS_ERROR',

Line 1329: 'OKC_API.G_RET_STS_ERROR',

1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1326: (
1327: l_api_name,
1328: G_PKG_NAME,
1329: 'OKC_API.G_RET_STS_ERROR',
1330: x_msg_count,
1331: x_msg_data,
1332: '_PVT'
1333: );

Line 1334: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1330: x_msg_count,
1331: x_msg_data,
1332: '_PVT'
1333: );
1334: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1335: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,

Line 1335: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1331: x_msg_data,
1332: '_PVT'
1333: );
1334: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1335: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1339: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1335: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1340: x_msg_count,
1341: x_msg_data,
1342: '_PVT'
1343: );

Line 1345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1341: x_msg_data,
1342: '_PVT'
1343: );
1344: WHEN OTHERS THEN
1345: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1346: (
1347: l_api_name,
1348: G_PKG_NAME,
1349: 'OTHERS',

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

1365: x_vlov_rec OUT NOCOPY vlov_rec_type) IS
1366:
1367: l_api_version CONSTANT NUMBER := 1;
1368: l_api_name CONSTANT VARCHAR2(30) := 'V_update_row';
1369: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1370: l_vlov_rec vlov_rec_type := p_vlov_rec;
1371: l_def_vlov_rec vlov_rec_type;
1372: l_vlo_rec vlo_rec_type;
1373: lx_vlo_rec vlo_rec_type;

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

1392: x_vlov_rec OUT NOCOPY vlov_rec_type
1393: ) RETURN VARCHAR2 IS
1394: l_vlov_rec vlov_rec_type;
1395: l_row_notfound BOOLEAN := TRUE;
1396: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1397: BEGIN
1398: x_vlov_rec := p_vlov_rec;
1399: -- Get current database values
1400: l_vlov_rec := get_rec(p_vlov_rec, l_row_notfound);

Line 1402: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1398: x_vlov_rec := p_vlov_rec;
1399: -- Get current database values
1400: l_vlov_rec := get_rec(p_vlov_rec, l_row_notfound);
1401: IF (l_row_notfound) THEN
1402: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1403: END IF;
1404: IF (x_vlov_rec.lse_id = OKC_API.G_MISS_NUM)
1405: THEN
1406: x_vlov_rec.lse_id := l_vlov_rec.lse_id;

Line 1404: IF (x_vlov_rec.lse_id = OKC_API.G_MISS_NUM)

1400: l_vlov_rec := get_rec(p_vlov_rec, l_row_notfound);
1401: IF (l_row_notfound) THEN
1402: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1403: END IF;
1404: IF (x_vlov_rec.lse_id = OKC_API.G_MISS_NUM)
1405: THEN
1406: x_vlov_rec.lse_id := l_vlov_rec.lse_id;
1407: END IF;
1408: IF (x_vlov_rec.opn_code = OKC_API.G_MISS_CHAR)

Line 1408: IF (x_vlov_rec.opn_code = OKC_API.G_MISS_CHAR)

1404: IF (x_vlov_rec.lse_id = OKC_API.G_MISS_NUM)
1405: THEN
1406: x_vlov_rec.lse_id := l_vlov_rec.lse_id;
1407: END IF;
1408: IF (x_vlov_rec.opn_code = OKC_API.G_MISS_CHAR)
1409: THEN
1410: x_vlov_rec.opn_code := l_vlov_rec.opn_code;
1411: END IF;
1412: IF (x_vlov_rec.object_version_number = OKC_API.G_MISS_NUM)

Line 1412: IF (x_vlov_rec.object_version_number = OKC_API.G_MISS_NUM)

1408: IF (x_vlov_rec.opn_code = OKC_API.G_MISS_CHAR)
1409: THEN
1410: x_vlov_rec.opn_code := l_vlov_rec.opn_code;
1411: END IF;
1412: IF (x_vlov_rec.object_version_number = OKC_API.G_MISS_NUM)
1413: THEN
1414: x_vlov_rec.object_version_number := l_vlov_rec.object_version_number;
1415: END IF;
1416: IF (x_vlov_rec.created_by = OKC_API.G_MISS_NUM)

Line 1416: IF (x_vlov_rec.created_by = OKC_API.G_MISS_NUM)

1412: IF (x_vlov_rec.object_version_number = OKC_API.G_MISS_NUM)
1413: THEN
1414: x_vlov_rec.object_version_number := l_vlov_rec.object_version_number;
1415: END IF;
1416: IF (x_vlov_rec.created_by = OKC_API.G_MISS_NUM)
1417: THEN
1418: x_vlov_rec.created_by := l_vlov_rec.created_by;
1419: END IF;
1420: IF (x_vlov_rec.creation_date = OKC_API.G_MISS_DATE)

Line 1420: IF (x_vlov_rec.creation_date = OKC_API.G_MISS_DATE)

1416: IF (x_vlov_rec.created_by = OKC_API.G_MISS_NUM)
1417: THEN
1418: x_vlov_rec.created_by := l_vlov_rec.created_by;
1419: END IF;
1420: IF (x_vlov_rec.creation_date = OKC_API.G_MISS_DATE)
1421: THEN
1422: x_vlov_rec.creation_date := l_vlov_rec.creation_date;
1423: END IF;
1424: IF (x_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM)

Line 1424: IF (x_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM)

1420: IF (x_vlov_rec.creation_date = OKC_API.G_MISS_DATE)
1421: THEN
1422: x_vlov_rec.creation_date := l_vlov_rec.creation_date;
1423: END IF;
1424: IF (x_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM)
1425: THEN
1426: x_vlov_rec.last_updated_by := l_vlov_rec.last_updated_by;
1427: END IF;
1428: IF (x_vlov_rec.last_update_date = OKC_API.G_MISS_DATE)

Line 1428: IF (x_vlov_rec.last_update_date = OKC_API.G_MISS_DATE)

1424: IF (x_vlov_rec.last_updated_by = OKC_API.G_MISS_NUM)
1425: THEN
1426: x_vlov_rec.last_updated_by := l_vlov_rec.last_updated_by;
1427: END IF;
1428: IF (x_vlov_rec.last_update_date = OKC_API.G_MISS_DATE)
1429: THEN
1430: x_vlov_rec.last_update_date := l_vlov_rec.last_update_date;
1431: END IF;
1432: IF (x_vlov_rec.last_update_login = OKC_API.G_MISS_NUM)

Line 1432: IF (x_vlov_rec.last_update_login = OKC_API.G_MISS_NUM)

1428: IF (x_vlov_rec.last_update_date = OKC_API.G_MISS_DATE)
1429: THEN
1430: x_vlov_rec.last_update_date := l_vlov_rec.last_update_date;
1431: END IF;
1432: IF (x_vlov_rec.last_update_login = OKC_API.G_MISS_NUM)
1433: THEN
1434: x_vlov_rec.last_update_login := l_vlov_rec.last_update_login;
1435: END IF;
1436: RETURN(l_return_status);

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

1441: FUNCTION Set_Attributes (
1442: p_vlov_rec IN vlov_rec_type,
1443: x_vlov_rec OUT NOCOPY vlov_rec_type
1444: ) RETURN VARCHAR2 IS
1445: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1446: BEGIN
1447: x_vlov_rec := p_vlov_rec;
1448: x_vlov_rec.OBJECT_VERSION_NUMBER := NVL(x_vlov_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1449: RETURN(l_return_status);

Line 1452: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1448: x_vlov_rec.OBJECT_VERSION_NUMBER := NVL(x_vlov_rec.OBJECT_VERSION_NUMBER, 0) + 1;
1449: RETURN(l_return_status);
1450: END Set_Attributes;
1451: BEGIN
1452: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1453: G_PKG_NAME,
1454: p_init_msg_list,
1455: l_api_version,
1456: p_api_version,

Line 1459: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1455: l_api_version,
1456: p_api_version,
1457: '_PVT',
1458: x_return_status);
1459: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1460: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_ERROR;
1463: END IF;

Line 1460: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1456: p_api_version,
1457: '_PVT',
1458: x_return_status);
1459: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1460: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --- Setting item attributes

Line 1461: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1457: '_PVT',
1458: x_return_status);
1459: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1460: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --- Setting item attributes
1465: l_return_status := Set_Attributes(

Line 1462: RAISE OKC_API.G_EXCEPTION_ERROR;

1458: x_return_status);
1459: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1460: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1461: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_ERROR;
1463: END IF;
1464: --- Setting item attributes
1465: l_return_status := Set_Attributes(
1466: p_vlov_rec, -- IN

Line 1469: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1465: l_return_status := Set_Attributes(
1466: p_vlov_rec, -- IN
1467: l_vlov_rec); -- OUT
1468: --- If any errors happen abort API
1469: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;

Line 1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1466: p_vlov_rec, -- IN
1467: l_vlov_rec); -- OUT
1468: --- If any errors happen abort API
1469: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);

Line 1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1467: l_vlov_rec); -- OUT
1468: --- If any errors happen abort API
1469: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1472: RAISE OKC_API.G_EXCEPTION_ERROR;

1468: --- If any errors happen abort API
1469: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1470: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1471: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_ERROR;
1479: END IF;

Line 1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1472: RAISE OKC_API.G_EXCEPTION_ERROR;
1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_ERROR;
1479: END IF;
1480: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);

Line 1477: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1473: END IF;
1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_ERROR;
1479: END IF;
1480: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
1481: --- Validate all non-missing attributes (Item Level Validation)

Line 1478: RAISE OKC_API.G_EXCEPTION_ERROR;

1474: l_return_status := populate_new_record(l_vlov_rec, l_def_vlov_rec);
1475: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1476: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1477: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1478: RAISE OKC_API.G_EXCEPTION_ERROR;
1479: END IF;
1480: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
1481: --- Validate all non-missing attributes (Item Level Validation)
1482: l_return_status := Validate_Attributes(l_def_vlov_rec);

Line 1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1480: l_def_vlov_rec := fill_who_columns(l_def_vlov_rec);
1481: --- Validate all non-missing attributes (Item Level Validation)
1482: l_return_status := Validate_Attributes(l_def_vlov_rec);
1483: --- If any errors happen abort API
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;

Line 1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1481: --- Validate all non-missing attributes (Item Level Validation)
1482: l_return_status := Validate_Attributes(l_def_vlov_rec);
1483: --- If any errors happen abort API
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);

Line 1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1482: l_return_status := Validate_Attributes(l_def_vlov_rec);
1483: --- If any errors happen abort API
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1487: RAISE OKC_API.G_EXCEPTION_ERROR;

1483: --- If any errors happen abort API
1484: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1486: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;

Line 1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1487: RAISE OKC_API.G_EXCEPTION_ERROR;
1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:

Line 1492: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1488: END IF;
1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: --------------------------------------

Line 1493: RAISE OKC_API.G_EXCEPTION_ERROR;

1489: l_return_status := Validate_Record(l_def_vlov_rec);
1490: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1491: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1492: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1493: RAISE OKC_API.G_EXCEPTION_ERROR;
1494: END IF;
1495:
1496: --------------------------------------
1497: -- Move VIEW record to "Child" records

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

1507: x_msg_data,
1508: l_vlo_rec,
1509: lx_vlo_rec
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;

Line 1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1508: l_vlo_rec,
1509: lx_vlo_rec
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516: migrate(lx_vlo_rec, l_def_vlov_rec);

Line 1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1509: lx_vlo_rec
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516: migrate(lx_vlo_rec, l_def_vlov_rec);
1517: x_vlov_rec := l_def_vlov_rec;

Line 1514: RAISE OKC_API.G_EXCEPTION_ERROR;

1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516: migrate(lx_vlo_rec, l_def_vlov_rec);
1517: x_vlov_rec := l_def_vlov_rec;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516: migrate(lx_vlo_rec, l_def_vlov_rec);
1517: x_vlov_rec := l_def_vlov_rec;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (

Line 1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1516: migrate(lx_vlo_rec, l_def_vlov_rec);
1517: x_vlov_rec := l_def_vlov_rec;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,

Line 1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1517: x_vlov_rec := l_def_vlov_rec;
1518: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1519: EXCEPTION
1520: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_ERROR',

Line 1525: 'OKC_API.G_RET_STS_ERROR',

1521: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1522: (
1523: l_api_name,
1524: G_PKG_NAME,
1525: 'OKC_API.G_RET_STS_ERROR',
1526: x_msg_count,
1527: x_msg_data,
1528: '_PVT'
1529: );

Line 1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1526: x_msg_count,
1527: x_msg_data,
1528: '_PVT'
1529: );
1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,

Line 1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1527: x_msg_data,
1528: '_PVT'
1529: );
1530: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,
1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1531: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1532: (
1533: l_api_name,
1534: G_PKG_NAME,
1535: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1536: x_msg_count,
1537: x_msg_data,
1538: '_PVT'
1539: );

Line 1541: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1537: x_msg_data,
1538: '_PVT'
1539: );
1540: WHEN OTHERS THEN
1541: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1542: (
1543: l_api_name,
1544: G_PKG_NAME,
1545: 'OTHERS',

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

1561: x_vlov_tbl OUT NOCOPY vlov_tbl_type) IS
1562:
1563: l_api_version CONSTANT NUMBER := 1;
1564: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1566: i NUMBER := 0;
1567: BEGIN
1568: OKC_API.init_msg_list(p_init_msg_list);
1569: -- Make sure PL/SQL table has records in it before passing

Line 1568: OKC_API.init_msg_list(p_init_msg_list);

1564: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
1565: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1566: i NUMBER := 0;
1567: BEGIN
1568: OKC_API.init_msg_list(p_init_msg_list);
1569: -- Make sure PL/SQL table has records in it before passing
1570: IF (p_vlov_tbl.COUNT > 0) THEN
1571: i := p_vlov_tbl.FIRST;
1572: LOOP

Line 1575: p_init_msg_list => OKC_API.G_FALSE,

1571: i := p_vlov_tbl.FIRST;
1572: LOOP
1573: update_row (
1574: p_api_version => p_api_version,
1575: p_init_msg_list => OKC_API.G_FALSE,
1576: x_return_status => x_return_status,
1577: x_msg_count => x_msg_count,
1578: x_msg_data => x_msg_data,
1579: p_vlov_rec => p_vlov_tbl(i),

Line 1586: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1582: i := p_vlov_tbl.NEXT(i);
1583: END LOOP;
1584: END IF;
1585: EXCEPTION
1586: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,

Line 1587: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1583: END LOOP;
1584: END IF;
1585: EXCEPTION
1586: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,
1591: 'OKC_API.G_RET_STS_ERROR',

Line 1591: 'OKC_API.G_RET_STS_ERROR',

1587: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1588: (
1589: l_api_name,
1590: G_PKG_NAME,
1591: 'OKC_API.G_RET_STS_ERROR',
1592: x_msg_count,
1593: x_msg_data,
1594: '_PVT'
1595: );

Line 1596: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1592: x_msg_count,
1593: x_msg_data,
1594: '_PVT'
1595: );
1596: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1598: (
1599: l_api_name,
1600: G_PKG_NAME,

Line 1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1593: x_msg_data,
1594: '_PVT'
1595: );
1596: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1598: (
1599: l_api_name,
1600: G_PKG_NAME,
1601: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1601: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1597: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1598: (
1599: l_api_name,
1600: G_PKG_NAME,
1601: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1602: x_msg_count,
1603: x_msg_data,
1604: '_PVT'
1605: );

Line 1607: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1603: x_msg_data,
1604: '_PVT'
1605: );
1606: WHEN OTHERS THEN
1607: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1608: (
1609: l_api_name,
1610: G_PKG_NAME,
1611: 'OTHERS',

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

1629: p_vlo_rec IN vlo_rec_type) IS
1630:
1631: l_api_version CONSTANT NUMBER := 1;
1632: l_api_name CONSTANT VARCHAR2(30) := 'OPERATIONS_delete_row';
1633: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1634: l_vlo_rec vlo_rec_type:= p_vlo_rec;
1635: l_row_notfound BOOLEAN := TRUE;
1636: BEGIN
1637: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1637: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1633: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1634: l_vlo_rec vlo_rec_type:= p_vlo_rec;
1635: l_row_notfound BOOLEAN := TRUE;
1636: BEGIN
1637: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1638: p_init_msg_list,
1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1637: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1638: p_init_msg_list,
1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;

Line 1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1638: p_init_msg_list,
1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: DELETE FROM OKC_VAL_LINE_OPERATIONS

Line 1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1639: '_PVT',
1640: x_return_status);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: DELETE FROM OKC_VAL_LINE_OPERATIONS
1647: WHERE LSE_ID = l_vlo_rec.lse_id AND

Line 1644: RAISE OKC_API.G_EXCEPTION_ERROR;

1640: x_return_status);
1641: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1642: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1643: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_ERROR;
1645: END IF;
1646: DELETE FROM OKC_VAL_LINE_OPERATIONS
1647: WHERE LSE_ID = l_vlo_rec.lse_id AND
1648: OPN_CODE = l_vlo_rec.opn_code;

Line 1650: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1646: DELETE FROM OKC_VAL_LINE_OPERATIONS
1647: WHERE LSE_ID = l_vlo_rec.lse_id AND
1648: OPN_CODE = l_vlo_rec.opn_code;
1649:
1650: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1651: EXCEPTION
1652: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1653: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1654: (

Line 1652: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1648: OPN_CODE = l_vlo_rec.opn_code;
1649:
1650: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1651: EXCEPTION
1652: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1653: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1654: (
1655: l_api_name,
1656: G_PKG_NAME,

Line 1653: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1649:
1650: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1651: EXCEPTION
1652: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1653: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1654: (
1655: l_api_name,
1656: G_PKG_NAME,
1657: 'OKC_API.G_RET_STS_ERROR',

Line 1657: 'OKC_API.G_RET_STS_ERROR',

1653: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1654: (
1655: l_api_name,
1656: G_PKG_NAME,
1657: 'OKC_API.G_RET_STS_ERROR',
1658: x_msg_count,
1659: x_msg_data,
1660: '_PVT'
1661: );

Line 1662: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1658: x_msg_count,
1659: x_msg_data,
1660: '_PVT'
1661: );
1662: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1663: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,

Line 1663: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1659: x_msg_data,
1660: '_PVT'
1661: );
1662: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1663: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,
1667: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1667: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1663: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,
1667: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1668: x_msg_count,
1669: x_msg_data,
1670: '_PVT'
1671: );

Line 1673: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1669: x_msg_data,
1670: '_PVT'
1671: );
1672: WHEN OTHERS THEN
1673: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1674: (
1675: l_api_name,
1676: G_PKG_NAME,
1677: 'OTHERS',

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

1692: p_vlov_rec IN vlov_rec_type) IS
1693:
1694: l_api_version CONSTANT NUMBER := 1;
1695: l_api_name CONSTANT VARCHAR2(30) := 'V_delete_row';
1696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1697: l_vlov_rec vlov_rec_type := p_vlov_rec;
1698: l_vlo_rec vlo_rec_type;
1699: BEGIN
1700: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

Line 1700: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1696: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1697: l_vlov_rec vlov_rec_type := p_vlov_rec;
1698: l_vlo_rec vlo_rec_type;
1699: BEGIN
1700: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1701: G_PKG_NAME,
1702: p_init_msg_list,
1703: l_api_version,
1704: p_api_version,

Line 1707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1703: l_api_version,
1704: p_api_version,
1705: '_PVT',
1706: x_return_status);
1707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_ERROR;
1711: END IF;

Line 1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1704: p_api_version,
1705: '_PVT',
1706: x_return_status);
1707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: --------------------------------------

Line 1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1705: '_PVT',
1706: x_return_status);
1707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: --------------------------------------
1713: -- Move VIEW record to "Child" records

Line 1710: RAISE OKC_API.G_EXCEPTION_ERROR;

1706: x_return_status);
1707: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1708: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1709: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1710: RAISE OKC_API.G_EXCEPTION_ERROR;
1711: END IF;
1712: --------------------------------------
1713: -- Move VIEW record to "Child" records
1714: --------------------------------------

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

1722: x_msg_count,
1723: x_msg_data,
1724: l_vlo_rec
1725: );
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;

Line 1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1723: x_msg_data,
1724: l_vlo_rec
1725: );
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

Line 1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1724: l_vlo_rec
1725: );
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1732: EXCEPTION

Line 1729: RAISE OKC_API.G_EXCEPTION_ERROR;

1725: );
1726: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1732: EXCEPTION
1733: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1727: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1728: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1732: EXCEPTION
1733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1735: (

Line 1733: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1729: RAISE OKC_API.G_EXCEPTION_ERROR;
1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1732: EXCEPTION
1733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1735: (
1736: l_api_name,
1737: G_PKG_NAME,

Line 1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1730: END IF;
1731: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1732: EXCEPTION
1733: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1735: (
1736: l_api_name,
1737: G_PKG_NAME,
1738: 'OKC_API.G_RET_STS_ERROR',

Line 1738: 'OKC_API.G_RET_STS_ERROR',

1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1735: (
1736: l_api_name,
1737: G_PKG_NAME,
1738: 'OKC_API.G_RET_STS_ERROR',
1739: x_msg_count,
1740: x_msg_data,
1741: '_PVT'
1742: );

Line 1743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1739: x_msg_count,
1740: x_msg_data,
1741: '_PVT'
1742: );
1743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,

Line 1744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1740: x_msg_data,
1741: '_PVT'
1742: );
1743: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,
1748: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1748: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1744: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1745: (
1746: l_api_name,
1747: G_PKG_NAME,
1748: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1749: x_msg_count,
1750: x_msg_data,
1751: '_PVT'
1752: );

Line 1754: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1750: x_msg_data,
1751: '_PVT'
1752: );
1753: WHEN OTHERS THEN
1754: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1755: (
1756: l_api_name,
1757: G_PKG_NAME,
1758: 'OTHERS',

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

1773: p_vlov_tbl IN vlov_tbl_type) IS
1774:
1775: l_api_version CONSTANT NUMBER := 1;
1776: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1778: i NUMBER := 0;
1779: BEGIN
1780: OKC_API.init_msg_list(p_init_msg_list);
1781: -- Make sure PL/SQL table has records in it before passing

Line 1780: OKC_API.init_msg_list(p_init_msg_list);

1776: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
1777: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1778: i NUMBER := 0;
1779: BEGIN
1780: OKC_API.init_msg_list(p_init_msg_list);
1781: -- Make sure PL/SQL table has records in it before passing
1782: IF (p_vlov_tbl.COUNT > 0) THEN
1783: i := p_vlov_tbl.FIRST;
1784: LOOP

Line 1787: p_init_msg_list => OKC_API.G_FALSE,

1783: i := p_vlov_tbl.FIRST;
1784: LOOP
1785: delete_row (
1786: p_api_version => p_api_version,
1787: p_init_msg_list => OKC_API.G_FALSE,
1788: x_return_status => x_return_status,
1789: x_msg_count => x_msg_count,
1790: x_msg_data => x_msg_data,
1791: p_vlov_rec => p_vlov_tbl(i));

Line 1797: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1793: i := p_vlov_tbl.NEXT(i);
1794: END LOOP;
1795: END IF;
1796: EXCEPTION
1797: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,

Line 1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1794: END LOOP;
1795: END IF;
1796: EXCEPTION
1797: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,
1802: 'OKC_API.G_RET_STS_ERROR',

Line 1802: 'OKC_API.G_RET_STS_ERROR',

1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1799: (
1800: l_api_name,
1801: G_PKG_NAME,
1802: 'OKC_API.G_RET_STS_ERROR',
1803: x_msg_count,
1804: x_msg_data,
1805: '_PVT'
1806: );

Line 1807: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1803: x_msg_count,
1804: x_msg_data,
1805: '_PVT'
1806: );
1807: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,

Line 1808: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1804: x_msg_data,
1805: '_PVT'
1806: );
1807: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1808: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1812: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1808: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1809: (
1810: l_api_name,
1811: G_PKG_NAME,
1812: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1813: x_msg_count,
1814: x_msg_data,
1815: '_PVT'
1816: );

Line 1818: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1814: x_msg_data,
1815: '_PVT'
1816: );
1817: WHEN OTHERS THEN
1818: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1819: (
1820: l_api_name,
1821: G_PKG_NAME,
1822: 'OTHERS',