eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_TXNGRP_PVT dependencies on FND_API

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

18: p_txngrp_rec IN TxnGrp_Rec_Type
19: )
20: RETURN VARCHAR2
21: IS
22: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
23: BEGIN
24: IF p_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_txngrp_rec.coverage_id IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

24: IF p_txngrp_rec.coverage_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_txngrp_rec.coverage_id IS NULL
26: THEN
27: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_id');
28: l_return_status := FND_API.G_RET_STS_ERROR;
29: ELSIF p_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'business_process_id');

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_txngrp_rec.business_process_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txngrp_rec.business_process_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'business_process_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

Line 38: l_return_status := FND_API.G_RET_STS_ERROR;

34: ELSIF p_txngrp_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txngrp_rec.last_update_date IS NULL
36: THEN
37: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');
38: l_return_status := FND_API.G_RET_STS_ERROR;
39: ELSIF p_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');

Line 43: l_return_status := FND_API.G_RET_STS_ERROR;

39: ELSIF p_txngrp_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txngrp_rec.last_updated_by IS NULL
41: THEN
42: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
43: l_return_status := FND_API.G_RET_STS_ERROR;
44: ELSIF p_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txngrp_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');

Line 48: l_return_status := FND_API.G_RET_STS_ERROR;

44: ELSIF p_txngrp_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txngrp_rec.creation_date IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txngrp_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');

Line 53: l_return_status := FND_API.G_RET_STS_ERROR;

49: ELSIF p_txngrp_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txngrp_rec.created_by IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: END IF;
55: RETURN(l_return_status);
56: END Validate_Item_Attributes;
57:

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

63: l_def_txngrp_rec OUT TxnGrp_Rec_Type
64: )
65: RETURN VARCHAR2
66: IS
67: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
68: BEGIN
69: l_def_txngrp_rec := p_txngrp_rec;
70: l_def_txngrp_rec.OBJECT_VERSION_NUMBER := NVL(l_def_txngrp_rec.OBJECT_VERSION_NUMBER, 0) + 1;
71: RETURN(l_return_status);

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

75: FUNCTION Validate_Item_Record (
76: p_txngrp_rec IN TxnGrp_Rec_Type
77: )
78: RETURN VARCHAR2 IS
79: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
80: FUNCTION validate_foreign_keys (
81: p_txngrp_rec IN TxnGrp_Rec_Type
82: )
83: RETURN VARCHAR2 IS

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

96: SELECT *
97: FROM Cs_Time_Zones
98: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
99: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
100: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
101: l_row_notfound BOOLEAN := TRUE;
102: BEGIN
103: IF (p_txngrp_rec.COVERAGE_ID IS NOT NULL)
104: THEN

Line 139: l_return_status := FND_API.G_RET_STS_ERROR;

135: END IF;
136: RETURN (l_return_status);
137: EXCEPTION
138: WHEN item_not_found_error THEN
139: l_return_status := FND_API.G_RET_STS_ERROR;
140: RETURN (l_return_status);
141: END validate_foreign_keys;
142: BEGIN
143: l_return_status := validate_foreign_keys (p_txngrp_rec);

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

270: x_coverage_txn_group_id OUT NUMBER,
271: x_object_version_number OUT NUMBER) IS
272: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
273: l_api_version CONSTANT NUMBER := 1;
274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
275: l_txngrp_rec TxnGrp_Rec_Type;
276: l_def_txngrp_rec TxnGrp_Rec_Type;
277: BEGIN
278: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 285: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

281: p_api_version,
282: p_init_msg_list,
283: '_Pvt',
284: x_return_status);
285: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;

Line 286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

282: p_init_msg_list,
283: '_Pvt',
284: x_return_status);
285: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: l_txngrp_rec := p_txngrp_rec;

Line 287: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

283: '_Pvt',
284: x_return_status);
285: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: l_txngrp_rec := p_txngrp_rec;
291: --- Validate all non-missing attributes (Item Level Validation)

Line 288: RAISE FND_API.G_EXC_ERROR;

284: x_return_status);
285: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
286: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
287: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: l_txngrp_rec := p_txngrp_rec;
291: --- Validate all non-missing attributes (Item Level Validation)
292: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 292: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

288: RAISE FND_API.G_EXC_ERROR;
289: END IF;
290: l_txngrp_rec := p_txngrp_rec;
291: --- Validate all non-missing attributes (Item Level Validation)
292: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
293: l_return_status := Validate_Item_Attributes
294: (
295: l_txngrp_rec ---- IN
296: );

Line 298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

294: (
295: l_txngrp_rec ---- IN
296: );
297: --- If any errors happen abort API
298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: l_txngrp_rec ---- IN
296: );
297: --- If any errors happen abort API
298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: END IF;

Line 300: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

296: );
297: --- If any errors happen abort API
298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: END IF;
304: --- Defaulting item attributes

Line 301: RAISE FND_API.G_EXC_ERROR;

297: --- If any errors happen abort API
298: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303: END IF;
304: --- Defaulting item attributes
305: l_return_status := Default_Item_Attributes

Line 311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

307: l_txngrp_rec, ---- IN
308: l_def_txngrp_rec
309: );
310: --- If any errors happen abort API
311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;

Line 312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

308: l_def_txngrp_rec
309: );
310: --- If any errors happen abort API
311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

309: );
310: --- If any errors happen abort API
311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);

Line 314: RAISE FND_API.G_EXC_ERROR;

310: --- If any errors happen abort API
311: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;

Line 319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

315: END IF;
316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323: END IF;

Line 320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

316: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323: END IF;
324: -- Set primary key value

Line 321: RAISE FND_API.G_EXC_ERROR;

317: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
318: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
320: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
321: RAISE FND_API.G_EXC_ERROR;
322: END IF;
323: END IF;
324: -- Set primary key value
325: l_def_txngrp_rec.coverage_txn_group_id := get_seq_id;

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429: x_coverage_txn_group_id := l_def_txngrp_rec.coverage_txn_group_id;
430: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
435: (
436: l_api_name,
437: G_PKG_NAME,

Line 438: 'FND_API.G_RET_STS_ERROR',

434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
435: (
436: l_api_name,
437: G_PKG_NAME,
438: 'FND_API.G_RET_STS_ERROR',
439: x_msg_count,
440: x_msg_data,
441: '_Pvt'
442: );

Line 444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

440: x_msg_data,
441: '_Pvt'
442: );
443: APP_EXCEPTION.RAISE_EXCEPTION;
444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
446: (
447: l_api_name,
448: G_PKG_NAME,

Line 449: 'FND_API.G_RET_STS_UNEXP_ERROR',

445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
446: (
447: l_api_name,
448: G_PKG_NAME,
449: 'FND_API.G_RET_STS_UNEXP_ERROR',
450: x_msg_count,
451: x_msg_data,
452: '_Pvt'
453: );

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

525: x_coverage_txn_group_id OUT NUMBER,
526: x_object_version_number OUT NUMBER) IS
527: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
528: l_api_version CONSTANT NUMBER := 1;
529: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
530: l_txngrp_rec TxnGrp_Rec_Type;
531: BEGIN
532: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
533: G_PKG_NAME,

Line 539: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

535: p_api_version,
536: p_init_msg_list,
537: '_Pvt',
538: x_return_status);
539: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;

Line 540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

536: p_init_msg_list,
537: '_Pvt',
538: x_return_status);
539: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;

Line 541: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

537: '_Pvt',
538: x_return_status);
539: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;
545: l_txngrp_rec.OFFSET_PERIOD := p_offset_period;

Line 542: RAISE FND_API.G_EXC_ERROR;

538: x_return_status);
539: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;
545: l_txngrp_rec.OFFSET_PERIOD := p_offset_period;
546: l_txngrp_rec.COVERAGE_START_DATE := p_coverage_start_date;

Line 607: WHEN FND_API.G_EXC_ERROR THEN

603: x_object_version_number
604: );
605: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
606: EXCEPTION
607: WHEN FND_API.G_EXC_ERROR THEN
608: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
609: (
610: l_api_name,
611: G_PKG_NAME,

Line 612: 'FND_API.G_RET_STS_ERROR',

608: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
609: (
610: l_api_name,
611: G_PKG_NAME,
612: 'FND_API.G_RET_STS_ERROR',
613: x_msg_count,
614: x_msg_data,
615: '_Pvt'
616: );

Line 618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

614: x_msg_data,
615: '_Pvt'
616: );
617: APP_EXCEPTION.RAISE_EXCEPTION;
618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
619: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
620: (
621: l_api_name,
622: G_PKG_NAME,

Line 623: 'FND_API.G_RET_STS_UNEXP_ERROR',

619: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
620: (
621: l_api_name,
622: G_PKG_NAME,
623: 'FND_API.G_RET_STS_UNEXP_ERROR',
624: x_msg_count,
625: x_msg_data,
626: '_Pvt'
627: );

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

666: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
667: ;
668: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
669: l_api_version CONSTANT NUMBER := 1;
670: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
671: l_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
672: lc_object_version_number CS_COVERAGE_TXN_GROUPS.OBJECT_VERSION_NUMBER%TYPE;
673: l_row_notfound BOOLEAN := FALSE;
674: lc_row_notfound BOOLEAN := FALSE;

Line 683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

679: p_api_version,
680: p_init_msg_list,
681: '_Pvt',
682: x_return_status);
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;

Line 684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

680: p_init_msg_list,
681: '_Pvt',
682: x_return_status);
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: BEGIN

Line 685: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

681: '_Pvt',
682: x_return_status);
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: BEGIN
689: OPEN lock_csr;

Line 686: RAISE FND_API.G_EXC_ERROR;

682: x_return_status);
683: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
684: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
685: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
686: RAISE FND_API.G_EXC_ERROR;
687: END IF;
688: BEGIN
689: OPEN lock_csr;
690: FETCH lock_csr INTO l_object_version_number;

Line 710: RAISE FND_API.G_EXC_ERROR;

706: CLOSE lchk_csr;
707: END IF;
708: IF (lc_row_notfound) THEN
709: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF lc_object_version_number > p_object_version_number THEN
712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 713: RAISE FND_API.G_EXC_ERROR;

709: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
710: RAISE FND_API.G_EXC_ERROR;
711: ELSIF lc_object_version_number > p_object_version_number THEN
712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN
715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF lc_object_version_number = -1 THEN

Line 716: RAISE FND_API.G_EXC_ERROR;

712: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
713: RAISE FND_API.G_EXC_ERROR;
714: ELSIF lc_object_version_number <> p_object_version_number THEN
715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF lc_object_version_number = -1 THEN
718: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;

Line 719: RAISE FND_API.G_EXC_ERROR;

715: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
716: RAISE FND_API.G_EXC_ERROR;
717: ELSIF lc_object_version_number = -1 THEN
718: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN

Line 723: WHEN FND_API.G_EXC_ERROR THEN

719: RAISE FND_API.G_EXC_ERROR;
720: END IF;
721: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
722: EXCEPTION
723: WHEN FND_API.G_EXC_ERROR THEN
724: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,

Line 728: 'FND_API.G_RET_STS_ERROR',

724: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
725: (
726: l_api_name,
727: G_PKG_NAME,
728: 'FND_API.G_RET_STS_ERROR',
729: x_msg_count,
730: x_msg_data,
731: '_Pvt'
732: );

Line 734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

730: x_msg_data,
731: '_Pvt'
732: );
733: APP_EXCEPTION.RAISE_EXCEPTION;
734: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
735: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
736: (
737: l_api_name,
738: G_PKG_NAME,

Line 739: 'FND_API.G_RET_STS_UNEXP_ERROR',

735: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
736: (
737: l_api_name,
738: G_PKG_NAME,
739: 'FND_API.G_RET_STS_UNEXP_ERROR',
740: x_msg_count,
741: x_msg_data,
742: '_Pvt'
743: );

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

766: p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC,
767: x_object_version_number OUT NUMBER) IS
768: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
769: l_api_version CONSTANT NUMBER := 1;
770: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
771: l_txngrp_rec TxnGrp_Rec_Type;
772: l_def_txngrp_rec TxnGrp_Rec_Type;
773: FUNCTION populate_new_record (
774: p_txngrp_rec IN TxnGrp_Rec_Type,

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

779: FROM Cs_Coverage_Txn_Groups
780: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
781: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
782: l_row_notfound BOOLEAN := TRUE;
783: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
784: BEGIN
785: x_txngrp_rec := p_txngrp_rec;
786: -- Get current database values
787: OPEN cs_coverage_txn_groups_pk_csr (p_txngrp_rec.coverage_txn_group_id);

Line 792: l_return_status := FND_API.G_RET_STS_ERROR;

788: FETCH cs_coverage_txn_groups_pk_csr INTO l_cs_coverage_txn_groups_pk;
789: l_row_notfound := cs_coverage_txn_groups_pk_csr%NOTFOUND;
790: CLOSE cs_coverage_txn_groups_pk_csr;
791: IF (l_row_notfound) THEN
792: l_return_status := FND_API.G_RET_STS_ERROR;
793: END IF;
794: IF (x_txngrp_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM)
795: THEN
796: x_txngrp_rec.coverage_txn_group_id := l_cs_coverage_txn_groups_pk.coverage_txn_group_id;

Line 1004: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1000: p_api_version,
1001: p_init_msg_list,
1002: '_Pvt',
1003: x_return_status);
1004: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: p_init_msg_list,
1002: '_Pvt',
1003: x_return_status);
1004: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: migrate(p_txngrp_val_rec, l_txngrp_rec);

Line 1006: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1002: '_Pvt',
1003: x_return_status);
1004: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: migrate(p_txngrp_val_rec, l_txngrp_rec);
1010: --- Defaulting item attributes

Line 1007: RAISE FND_API.G_EXC_ERROR;

1003: x_return_status);
1004: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1007: RAISE FND_API.G_EXC_ERROR;
1008: END IF;
1009: migrate(p_txngrp_val_rec, l_txngrp_rec);
1010: --- Defaulting item attributes
1011: l_return_status := Default_Item_Attributes

Line 1017: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1013: l_txngrp_rec, ---- IN
1014: l_def_txngrp_rec
1015: );
1016: --- If any errors happen abort API
1017: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;

Line 1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1014: l_def_txngrp_rec
1015: );
1016: --- If any errors happen abort API
1017: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);

Line 1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1015: );
1016: --- If any errors happen abort API
1017: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1020: RAISE FND_API.G_EXC_ERROR;

1016: --- If any errors happen abort API
1017: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1018: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1019: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;

Line 1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1020: RAISE FND_API.G_EXC_ERROR;
1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: --- Validate all non-missing attributes (Item Level Validation)

Line 1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1021: END IF;
1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: --- Validate all non-missing attributes (Item Level Validation)
1029: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: l_return_status := populate_new_record(l_def_txngrp_rec, l_def_txngrp_rec);
1023: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1024: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: --- Validate all non-missing attributes (Item Level Validation)
1029: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1030: l_return_status := Validate_Item_Attributes

Line 1029: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1025: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: --- Validate all non-missing attributes (Item Level Validation)
1029: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1030: l_return_status := Validate_Item_Attributes
1031: (
1032: l_def_txngrp_rec ---- IN
1033: );

Line 1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1031: (
1032: l_def_txngrp_rec ---- IN
1033: );
1034: --- If any errors happen abort API
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;

Line 1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1032: l_def_txngrp_rec ---- IN
1033: );
1034: --- If any errors happen abort API
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: END IF;

Line 1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1033: );
1034: --- If any errors happen abort API
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: END IF;
1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1038: RAISE FND_API.G_EXC_ERROR;

1034: --- If any errors happen abort API
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: END IF;
1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);

Line 1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: END IF;
1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1039: END IF;
1040: END IF;
1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;

Line 1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1040: END IF;
1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: END IF;

Line 1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1041: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: END IF;
1049: UPDATE CS_COVERAGE_TXN_GROUPS

Line 1046: RAISE FND_API.G_EXC_ERROR;

1042: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1043: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1044: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1045: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: END IF;
1049: UPDATE CS_COVERAGE_TXN_GROUPS
1050: SET

Line 1107: WHEN FND_API.G_EXC_ERROR THEN

1103: ;
1104: x_object_version_number := l_def_txngrp_rec.OBJECT_VERSION_NUMBER;
1105: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1106: EXCEPTION
1107: WHEN FND_API.G_EXC_ERROR THEN
1108: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1109: (
1110: l_api_name,
1111: G_PKG_NAME,

Line 1112: 'FND_API.G_RET_STS_ERROR',

1108: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1109: (
1110: l_api_name,
1111: G_PKG_NAME,
1112: 'FND_API.G_RET_STS_ERROR',
1113: x_msg_count,
1114: x_msg_data,
1115: '_Pvt'
1116: );

Line 1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1114: x_msg_data,
1115: '_Pvt'
1116: );
1117: APP_EXCEPTION.RAISE_EXCEPTION;
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,

Line 1123: 'FND_API.G_RET_STS_UNEXP_ERROR',

1119: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1120: (
1121: l_api_name,
1122: G_PKG_NAME,
1123: 'FND_API.G_RET_STS_UNEXP_ERROR',
1124: x_msg_count,
1125: x_msg_data,
1126: '_Pvt'
1127: );

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

1199: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1200: x_object_version_number OUT NUMBER) IS
1201: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1202: l_api_version CONSTANT NUMBER := 1;
1203: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1204: l_txngrp_rec TxnGrp_Val_Rec_Type;
1205: BEGIN
1206: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1207: G_PKG_NAME,

Line 1213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1209: p_api_version,
1210: p_init_msg_list,
1211: '_Pvt',
1212: x_return_status);
1213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;

Line 1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1210: p_init_msg_list,
1211: '_Pvt',
1212: x_return_status);
1213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;

Line 1215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1211: '_Pvt',
1212: x_return_status);
1213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;
1219: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;

Line 1216: RAISE FND_API.G_EXC_ERROR;

1212: x_return_status);
1213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1216: RAISE FND_API.G_EXC_ERROR;
1217: END IF;
1218: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;
1219: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;
1220: l_txngrp_rec.OFFSET_PERIOD := p_offset_period;

Line 1281: WHEN FND_API.G_EXC_ERROR THEN

1277: x_object_version_number
1278: );
1279: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1280: EXCEPTION
1281: WHEN FND_API.G_EXC_ERROR THEN
1282: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1283: (
1284: l_api_name,
1285: G_PKG_NAME,

Line 1286: 'FND_API.G_RET_STS_ERROR',

1282: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1283: (
1284: l_api_name,
1285: G_PKG_NAME,
1286: 'FND_API.G_RET_STS_ERROR',
1287: x_msg_count,
1288: x_msg_data,
1289: '_Pvt'
1290: );

Line 1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1288: x_msg_data,
1289: '_Pvt'
1290: );
1291: APP_EXCEPTION.RAISE_EXCEPTION;
1292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1293: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,

Line 1297: 'FND_API.G_RET_STS_UNEXP_ERROR',

1293: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1294: (
1295: l_api_name,
1296: G_PKG_NAME,
1297: 'FND_API.G_RET_STS_UNEXP_ERROR',
1298: x_msg_count,
1299: x_msg_data,
1300: '_Pvt'
1301: );

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

1323: x_msg_data OUT VARCHAR2,
1324: p_coverage_txn_group_id IN NUMBER) IS
1325: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1326: l_api_version CONSTANT NUMBER := 1;
1327: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1328: BEGIN
1329: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1330: G_PKG_NAME,
1331: l_api_version,

Line 1336: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1332: p_api_version,
1333: p_init_msg_list,
1334: '_Pvt',
1335: x_return_status);
1336: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;

Line 1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1333: p_init_msg_list,
1334: '_Pvt',
1335: x_return_status);
1336: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341: DELETE FROM CS_COVERAGE_TXN_GROUPS

Line 1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1334: '_Pvt',
1335: x_return_status);
1336: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341: DELETE FROM CS_COVERAGE_TXN_GROUPS
1342: WHERE

Line 1339: RAISE FND_API.G_EXC_ERROR;

1335: x_return_status);
1336: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1337: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1338: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341: DELETE FROM CS_COVERAGE_TXN_GROUPS
1342: WHERE
1343: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id

Line 1347: WHEN FND_API.G_EXC_ERROR THEN

1343: COVERAGE_TXN_GROUP_ID = p_coverage_txn_group_id
1344: ;
1345: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1346: EXCEPTION
1347: WHEN FND_API.G_EXC_ERROR THEN
1348: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1349: (
1350: l_api_name,
1351: G_PKG_NAME,

Line 1352: 'FND_API.G_RET_STS_ERROR',

1348: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1349: (
1350: l_api_name,
1351: G_PKG_NAME,
1352: 'FND_API.G_RET_STS_ERROR',
1353: x_msg_count,
1354: x_msg_data,
1355: '_Pvt'
1356: );

Line 1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1354: x_msg_data,
1355: '_Pvt'
1356: );
1357: APP_EXCEPTION.RAISE_EXCEPTION;
1358: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1359: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1360: (
1361: l_api_name,
1362: G_PKG_NAME,

Line 1363: 'FND_API.G_RET_STS_UNEXP_ERROR',

1359: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1360: (
1361: l_api_name,
1362: G_PKG_NAME,
1363: 'FND_API.G_RET_STS_UNEXP_ERROR',
1364: x_msg_count,
1365: x_msg_data,
1366: '_Pvt'
1367: );

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

1389: x_msg_data OUT VARCHAR2,
1390: p_txngrp_val_rec IN TxnGrp_Val_Rec_Type := G_MISS_TXNGRP_VAL_REC) IS
1391: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1392: l_api_version CONSTANT NUMBER := 1;
1393: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1394: l_txngrp_rec TxnGrp_Rec_Type;
1395: l_def_txngrp_rec TxnGrp_Rec_Type;
1396: BEGIN
1397: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

Line 1404: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1400: p_api_version,
1401: p_init_msg_list,
1402: '_Pvt',
1403: x_return_status);
1404: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;

Line 1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1401: p_init_msg_list,
1402: '_Pvt',
1403: x_return_status);
1404: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: migrate(p_txngrp_val_rec, l_txngrp_rec);

Line 1406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1402: '_Pvt',
1403: x_return_status);
1404: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: migrate(p_txngrp_val_rec, l_txngrp_rec);
1410: --- Validate all non-missing attributes (Item Level Validation)

Line 1407: RAISE FND_API.G_EXC_ERROR;

1403: x_return_status);
1404: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1406: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: migrate(p_txngrp_val_rec, l_txngrp_rec);
1410: --- Validate all non-missing attributes (Item Level Validation)
1411: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1411: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1407: RAISE FND_API.G_EXC_ERROR;
1408: END IF;
1409: migrate(p_txngrp_val_rec, l_txngrp_rec);
1410: --- Validate all non-missing attributes (Item Level Validation)
1411: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1412: l_return_status := Validate_Item_Attributes
1413: (
1414: l_txngrp_rec ---- IN
1415: );

Line 1417: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1413: (
1414: l_txngrp_rec ---- IN
1415: );
1416: --- If any errors happen abort API
1417: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: END IF;

Line 1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1414: l_txngrp_rec ---- IN
1415: );
1416: --- If any errors happen abort API
1417: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: END IF;
1422: END IF;

Line 1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1415: );
1416: --- If any errors happen abort API
1417: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: END IF;
1422: END IF;
1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1420: RAISE FND_API.G_EXC_ERROR;

1416: --- If any errors happen abort API
1417: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1418: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: END IF;
1422: END IF;
1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);

Line 1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

1419: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1420: RAISE FND_API.G_EXC_ERROR;
1421: END IF;
1422: END IF;
1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

Line 1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1421: END IF;
1422: END IF;
1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;

Line 1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1422: END IF;
1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;

Line 1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1423: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1428: RAISE FND_API.G_EXC_ERROR;

1424: l_return_status := Validate_Item_Record(l_def_txngrp_rec);
1425: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1428: RAISE FND_API.G_EXC_ERROR;
1429: END IF;
1430: END IF;
1431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1432: EXCEPTION

Line 1433: WHEN FND_API.G_EXC_ERROR THEN

1429: END IF;
1430: END IF;
1431: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1432: EXCEPTION
1433: WHEN FND_API.G_EXC_ERROR THEN
1434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,

Line 1438: 'FND_API.G_RET_STS_ERROR',

1434: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1435: (
1436: l_api_name,
1437: G_PKG_NAME,
1438: 'FND_API.G_RET_STS_ERROR',
1439: x_msg_count,
1440: x_msg_data,
1441: '_Pvt'
1442: );

Line 1444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1440: x_msg_data,
1441: '_Pvt'
1442: );
1443: APP_EXCEPTION.RAISE_EXCEPTION;
1444: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1446: (
1447: l_api_name,
1448: G_PKG_NAME,

Line 1449: 'FND_API.G_RET_STS_UNEXP_ERROR',

1445: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1446: (
1447: l_api_name,
1448: G_PKG_NAME,
1449: 'FND_API.G_RET_STS_UNEXP_ERROR',
1450: x_msg_count,
1451: x_msg_data,
1452: '_Pvt'
1453: );

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

1524: p_context IN CS_COVERAGE_TXN_GROUPS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1525: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1526: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1527: l_api_version CONSTANT NUMBER := 1;
1528: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1529: l_txngrp_rec TxnGrp_Val_Rec_Type;
1530: BEGIN
1531: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1532: G_PKG_NAME,

Line 1538: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1534: p_api_version,
1535: p_init_msg_list,
1536: '_Pvt',
1537: x_return_status);
1538: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;

Line 1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1535: p_init_msg_list,
1536: '_Pvt',
1537: x_return_status);
1538: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;

Line 1540: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1536: '_Pvt',
1537: x_return_status);
1538: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;
1544: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;

Line 1541: RAISE FND_API.G_EXC_ERROR;

1537: x_return_status);
1538: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1539: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1540: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1541: RAISE FND_API.G_EXC_ERROR;
1542: END IF;
1543: l_txngrp_rec.COVERAGE_TXN_GROUP_ID := p_coverage_txn_group_id;
1544: l_txngrp_rec.OFFSET_DURATION := p_offset_duration;
1545: l_txngrp_rec.OFFSET_PERIOD := p_offset_period;

Line 1605: WHEN FND_API.G_EXC_ERROR THEN

1601: l_txngrp_rec
1602: );
1603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1604: EXCEPTION
1605: WHEN FND_API.G_EXC_ERROR THEN
1606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,

Line 1610: 'FND_API.G_RET_STS_ERROR',

1606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1607: (
1608: l_api_name,
1609: G_PKG_NAME,
1610: 'FND_API.G_RET_STS_ERROR',
1611: x_msg_count,
1612: x_msg_data,
1613: '_Pvt'
1614: );

Line 1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1612: x_msg_data,
1613: '_Pvt'
1614: );
1615: APP_EXCEPTION.RAISE_EXCEPTION;
1616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1617: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,

Line 1621: 'FND_API.G_RET_STS_UNEXP_ERROR',

1617: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1618: (
1619: l_api_name,
1620: G_PKG_NAME,
1621: 'FND_API.G_RET_STS_UNEXP_ERROR',
1622: x_msg_count,
1623: x_msg_data,
1624: '_Pvt'
1625: );