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

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

18: p_reacttime_rec IN ReactTime_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_reacttime_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_reacttime_rec.name IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_reacttime_rec.coverage_txn_group_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_reacttime_rec.coverage_txn_group_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'coverage_txn_group_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_reacttime_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_reacttime_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_reacttime_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_reacttime_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_reacttime_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_reacttime_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_reacttime_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_reacttime_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_reacttime_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_reacttime_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_reacttime_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_reacttime_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_reacttime_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_reacttime_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_reacttime_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_reacttime_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_reacttime_rec OUT ReactTime_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_reacttime_rec := p_reacttime_rec;
70: l_def_reacttime_rec.OBJECT_VERSION_NUMBER := NVL(l_def_reacttime_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_reacttime_rec IN ReactTime_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_reacttime_rec IN ReactTime_Rec_Type
82: )
83: RETURN VARCHAR2 IS

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

86: SELECT *
87: FROM Cs_Coverage_Txn_Groups
88: WHERE cs_coverage_txn_groups.coverage_txn_group_id = p_coverage_txn_group_id;
89: l_cs_coverage_txn_groups_pk cs_coverage_txn_groups_pk_csr%ROWTYPE;
90: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
91: l_row_notfound BOOLEAN := TRUE;
92: BEGIN
93: IF (p_reacttime_rec.COVERAGE_TXN_GROUP_ID IS NOT NULL)
94: THEN

Line 107: l_return_status := FND_API.G_RET_STS_ERROR;

103: END IF;
104: RETURN (l_return_status);
105: EXCEPTION
106: WHEN item_not_found_error THEN
107: l_return_status := FND_API.G_RET_STS_ERROR;
108: RETURN (l_return_status);
109: END validate_foreign_keys;
110: BEGIN
111: l_return_status := validate_foreign_keys (p_reacttime_rec);

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

212: x_reaction_time_id OUT NUMBER,
213: x_object_version_number OUT NUMBER) IS
214: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
215: l_api_version CONSTANT NUMBER := 1;
216: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
217: l_reacttime_rec ReactTime_Rec_Type;
218: l_def_reacttime_rec ReactTime_Rec_Type;
219: BEGIN
220: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

223: p_api_version,
224: p_init_msg_list,
225: '_Pvt',
226: x_return_status);
227: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;

Line 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: p_init_msg_list,
225: '_Pvt',
226: x_return_status);
227: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: l_reacttime_rec := p_reacttime_rec;

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

225: '_Pvt',
226: x_return_status);
227: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: l_reacttime_rec := p_reacttime_rec;
233: --- Validate all non-missing attributes (Item Level Validation)

Line 230: RAISE FND_API.G_EXC_ERROR;

226: x_return_status);
227: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: l_reacttime_rec := p_reacttime_rec;
233: --- Validate all non-missing attributes (Item Level Validation)
234: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 234: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232: l_reacttime_rec := p_reacttime_rec;
233: --- Validate all non-missing attributes (Item Level Validation)
234: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
235: l_return_status := Validate_Item_Attributes
236: (
237: l_reacttime_rec ---- IN
238: );

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

236: (
237: l_reacttime_rec ---- IN
238: );
239: --- If any errors happen abort API
240: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;

Line 241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

237: l_reacttime_rec ---- IN
238: );
239: --- If any errors happen abort API
240: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: END IF;

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

238: );
239: --- If any errors happen abort API
240: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: END IF;
246: --- Defaulting item attributes

Line 243: RAISE FND_API.G_EXC_ERROR;

239: --- If any errors happen abort API
240: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
241: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
242: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
243: RAISE FND_API.G_EXC_ERROR;
244: END IF;
245: END IF;
246: --- Defaulting item attributes
247: l_return_status := Default_Item_Attributes

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

249: l_reacttime_rec, ---- IN
250: l_def_reacttime_rec
251: );
252: --- If any errors happen abort API
253: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: l_def_reacttime_rec
251: );
252: --- If any errors happen abort API
253: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

251: );
252: --- If any errors happen abort API
253: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);

Line 256: RAISE FND_API.G_EXC_ERROR;

252: --- If any errors happen abort API
253: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;

Line 261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

257: END IF;
258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: END IF;

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

258: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: END IF;
266: -- Set primary key value

Line 263: RAISE FND_API.G_EXC_ERROR;

259: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
260: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
261: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
262: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
263: RAISE FND_API.G_EXC_ERROR;
264: END IF;
265: END IF;
266: -- Set primary key value
267: l_def_reacttime_rec.reaction_time_id := get_seq_id;

Line 349: WHEN FND_API.G_EXC_ERROR THEN

345: x_reaction_time_id := l_def_reacttime_rec.reaction_time_id;
346: x_object_version_number := l_def_reacttime_rec.OBJECT_VERSION_NUMBER;
347: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
348: EXCEPTION
349: WHEN FND_API.G_EXC_ERROR THEN
350: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
351: (
352: l_api_name,
353: G_PKG_NAME,

Line 354: 'FND_API.G_RET_STS_ERROR',

350: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
351: (
352: l_api_name,
353: G_PKG_NAME,
354: 'FND_API.G_RET_STS_ERROR',
355: x_msg_count,
356: x_msg_data,
357: '_Pvt'
358: );

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

356: x_msg_data,
357: '_Pvt'
358: );
359: APP_EXCEPTION.RAISE_EXCEPTION;
360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
361: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
362: (
363: l_api_name,
364: G_PKG_NAME,

Line 365: 'FND_API.G_RET_STS_UNEXP_ERROR',

361: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
362: (
363: l_api_name,
364: G_PKG_NAME,
365: 'FND_API.G_RET_STS_UNEXP_ERROR',
366: x_msg_count,
367: x_msg_data,
368: '_Pvt'
369: );

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

428: x_reaction_time_id OUT NUMBER,
429: x_object_version_number OUT NUMBER) IS
430: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
431: l_api_version CONSTANT NUMBER := 1;
432: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
433: l_reacttime_rec ReactTime_Rec_Type;
434: BEGIN
435: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
436: G_PKG_NAME,

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

438: p_api_version,
439: p_init_msg_list,
440: '_Pvt',
441: x_return_status);
442: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: p_init_msg_list,
440: '_Pvt',
441: x_return_status);
442: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: l_reacttime_rec.NAME := p_name;

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

440: '_Pvt',
441: x_return_status);
442: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: l_reacttime_rec.NAME := p_name;
448: l_reacttime_rec.DESCRIPTION := p_description;

Line 445: RAISE FND_API.G_EXC_ERROR;

441: x_return_status);
442: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447: l_reacttime_rec.NAME := p_name;
448: l_reacttime_rec.DESCRIPTION := p_description;
449: l_reacttime_rec.REACTION_TIME_SUNDAY := p_reaction_time_sunday;

Line 497: WHEN FND_API.G_EXC_ERROR THEN

493: x_object_version_number
494: );
495: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
496: EXCEPTION
497: WHEN FND_API.G_EXC_ERROR THEN
498: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
499: (
500: l_api_name,
501: G_PKG_NAME,

Line 502: 'FND_API.G_RET_STS_ERROR',

498: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
499: (
500: l_api_name,
501: G_PKG_NAME,
502: 'FND_API.G_RET_STS_ERROR',
503: x_msg_count,
504: x_msg_data,
505: '_Pvt'
506: );

Line 508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

504: x_msg_data,
505: '_Pvt'
506: );
507: APP_EXCEPTION.RAISE_EXCEPTION;
508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
509: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
510: (
511: l_api_name,
512: G_PKG_NAME,

Line 513: 'FND_API.G_RET_STS_UNEXP_ERROR',

509: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
510: (
511: l_api_name,
512: G_PKG_NAME,
513: 'FND_API.G_RET_STS_UNEXP_ERROR',
514: x_msg_count,
515: x_msg_data,
516: '_Pvt'
517: );

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

556: REACTION_TIME_ID = p_reaction_time_id
557: ;
558: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
559: l_api_version CONSTANT NUMBER := 1;
560: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
561: l_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
562: lc_object_version_number CS_COV_REACTION_TIMES.OBJECT_VERSION_NUMBER%TYPE;
563: l_row_notfound BOOLEAN := FALSE;
564: lc_row_notfound BOOLEAN := FALSE;

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

569: p_api_version,
570: p_init_msg_list,
571: '_Pvt',
572: x_return_status);
573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570: p_init_msg_list,
571: '_Pvt',
572: x_return_status);
573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: BEGIN

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

571: '_Pvt',
572: x_return_status);
573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: BEGIN
579: OPEN lock_csr;

Line 576: RAISE FND_API.G_EXC_ERROR;

572: x_return_status);
573: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
576: RAISE FND_API.G_EXC_ERROR;
577: END IF;
578: BEGIN
579: OPEN lock_csr;
580: FETCH lock_csr INTO l_object_version_number;

Line 600: RAISE FND_API.G_EXC_ERROR;

596: CLOSE lchk_csr;
597: END IF;
598: IF (lc_row_notfound) THEN
599: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF lc_object_version_number > p_object_version_number THEN
602: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 603: RAISE FND_API.G_EXC_ERROR;

599: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
600: RAISE FND_API.G_EXC_ERROR;
601: ELSIF lc_object_version_number > p_object_version_number THEN
602: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF lc_object_version_number <> p_object_version_number THEN
605: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF lc_object_version_number = -1 THEN

Line 606: RAISE FND_API.G_EXC_ERROR;

602: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
603: RAISE FND_API.G_EXC_ERROR;
604: ELSIF lc_object_version_number <> p_object_version_number THEN
605: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF lc_object_version_number = -1 THEN
608: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;

Line 609: RAISE FND_API.G_EXC_ERROR;

605: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
606: RAISE FND_API.G_EXC_ERROR;
607: ELSIF lc_object_version_number = -1 THEN
608: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN

Line 613: WHEN FND_API.G_EXC_ERROR THEN

609: RAISE FND_API.G_EXC_ERROR;
610: END IF;
611: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
612: EXCEPTION
613: WHEN FND_API.G_EXC_ERROR THEN
614: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
615: (
616: l_api_name,
617: G_PKG_NAME,

Line 618: 'FND_API.G_RET_STS_ERROR',

614: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
615: (
616: l_api_name,
617: G_PKG_NAME,
618: 'FND_API.G_RET_STS_ERROR',
619: x_msg_count,
620: x_msg_data,
621: '_Pvt'
622: );

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620: x_msg_data,
621: '_Pvt'
622: );
623: APP_EXCEPTION.RAISE_EXCEPTION;
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
626: (
627: l_api_name,
628: G_PKG_NAME,

Line 629: 'FND_API.G_RET_STS_UNEXP_ERROR',

625: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
626: (
627: l_api_name,
628: G_PKG_NAME,
629: 'FND_API.G_RET_STS_UNEXP_ERROR',
630: x_msg_count,
631: x_msg_data,
632: '_Pvt'
633: );

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

656: p_reacttime_val_rec IN ReactTime_Val_Rec_Type := G_MISS_REACTTIME_VAL_REC,
657: x_object_version_number OUT NUMBER) IS
658: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
659: l_api_version CONSTANT NUMBER := 1;
660: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
661: l_reacttime_rec ReactTime_Rec_Type;
662: l_def_reacttime_rec ReactTime_Rec_Type;
663: FUNCTION populate_new_record (
664: p_reacttime_rec IN ReactTime_Rec_Type,

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

669: FROM Cs_Cov_Reaction_Times
670: WHERE cs_cov_reaction_times.reaction_time_id = p_reaction_time_id;
671: l_cs_coverage_reaction1 cs_coverage_reaction1_csr%ROWTYPE;
672: l_row_notfound BOOLEAN := TRUE;
673: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
674: BEGIN
675: x_reacttime_rec := p_reacttime_rec;
676: -- Get current database values
677: OPEN cs_coverage_reaction1_csr (p_reacttime_rec.reaction_time_id);

Line 682: l_return_status := FND_API.G_RET_STS_ERROR;

678: FETCH cs_coverage_reaction1_csr INTO l_cs_coverage_reaction1;
679: l_row_notfound := cs_coverage_reaction1_csr%NOTFOUND;
680: CLOSE cs_coverage_reaction1_csr;
681: IF (l_row_notfound) THEN
682: l_return_status := FND_API.G_RET_STS_ERROR;
683: END IF;
684: IF (x_reacttime_rec.reaction_time_id = TAPI_DEV_KIT.G_MISS_NUM)
685: THEN
686: x_reacttime_rec.reaction_time_id := l_cs_coverage_reaction1.reaction_time_id;

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

838: p_api_version,
839: p_init_msg_list,
840: '_Pvt',
841: x_return_status);
842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;

Line 843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

839: p_init_msg_list,
840: '_Pvt',
841: x_return_status);
842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847: migrate(p_reacttime_val_rec, l_reacttime_rec);

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

840: '_Pvt',
841: x_return_status);
842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847: migrate(p_reacttime_val_rec, l_reacttime_rec);
848: --- Defaulting item attributes

Line 845: RAISE FND_API.G_EXC_ERROR;

841: x_return_status);
842: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
843: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
844: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
845: RAISE FND_API.G_EXC_ERROR;
846: END IF;
847: migrate(p_reacttime_val_rec, l_reacttime_rec);
848: --- Defaulting item attributes
849: l_return_status := Default_Item_Attributes

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

851: l_reacttime_rec, ---- IN
852: l_def_reacttime_rec
853: );
854: --- If any errors happen abort API
855: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;

Line 856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

852: l_def_reacttime_rec
853: );
854: --- If any errors happen abort API
855: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);

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

853: );
854: --- If any errors happen abort API
855: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 858: RAISE FND_API.G_EXC_ERROR;

854: --- If any errors happen abort API
855: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
857: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

857: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;

Line 862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

858: RAISE FND_API.G_EXC_ERROR;
859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: --- Validate all non-missing attributes (Item Level Validation)

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

859: END IF;
860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: --- Validate all non-missing attributes (Item Level Validation)
867: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 864: RAISE FND_API.G_EXC_ERROR;

860: l_return_status := populate_new_record(l_def_reacttime_rec, l_def_reacttime_rec);
861: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
862: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
863: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: --- Validate all non-missing attributes (Item Level Validation)
867: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
868: l_return_status := Validate_Item_Attributes

Line 867: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

863: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: --- Validate all non-missing attributes (Item Level Validation)
867: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
868: l_return_status := Validate_Item_Attributes
869: (
870: l_def_reacttime_rec ---- IN
871: );

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

869: (
870: l_def_reacttime_rec ---- IN
871: );
872: --- If any errors happen abort API
873: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

870: l_def_reacttime_rec ---- IN
871: );
872: --- If any errors happen abort API
873: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;

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

871: );
872: --- If any errors happen abort API
873: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 876: RAISE FND_API.G_EXC_ERROR;

872: --- If any errors happen abort API
873: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);

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

875: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
876: RAISE FND_API.G_EXC_ERROR;
877: END IF;
878: END IF;
879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
881: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

877: END IF;
878: END IF;
879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
881: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

878: END IF;
879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
881: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;

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

879: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
881: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;
887: UPDATE CS_COV_REACTION_TIMES

Line 884: RAISE FND_API.G_EXC_ERROR;

880: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
881: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
884: RAISE FND_API.G_EXC_ERROR;
885: END IF;
886: END IF;
887: UPDATE CS_COV_REACTION_TIMES
888: SET

Line 932: WHEN FND_API.G_EXC_ERROR THEN

928: ;
929: x_object_version_number := l_def_reacttime_rec.OBJECT_VERSION_NUMBER;
930: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
931: EXCEPTION
932: WHEN FND_API.G_EXC_ERROR THEN
933: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
934: (
935: l_api_name,
936: G_PKG_NAME,

Line 937: 'FND_API.G_RET_STS_ERROR',

933: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
934: (
935: l_api_name,
936: G_PKG_NAME,
937: 'FND_API.G_RET_STS_ERROR',
938: x_msg_count,
939: x_msg_data,
940: '_Pvt'
941: );

Line 943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

939: x_msg_data,
940: '_Pvt'
941: );
942: APP_EXCEPTION.RAISE_EXCEPTION;
943: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
944: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
945: (
946: l_api_name,
947: G_PKG_NAME,

Line 948: 'FND_API.G_RET_STS_UNEXP_ERROR',

944: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
945: (
946: l_api_name,
947: G_PKG_NAME,
948: 'FND_API.G_RET_STS_UNEXP_ERROR',
949: x_msg_count,
950: x_msg_data,
951: '_Pvt'
952: );

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

1011: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1012: x_object_version_number OUT NUMBER) IS
1013: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1014: l_api_version CONSTANT NUMBER := 1;
1015: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1016: l_reacttime_rec ReactTime_Val_Rec_Type;
1017: BEGIN
1018: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1019: G_PKG_NAME,

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

1021: p_api_version,
1022: p_init_msg_list,
1023: '_Pvt',
1024: x_return_status);
1025: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;

Line 1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1022: p_init_msg_list,
1023: '_Pvt',
1024: x_return_status);
1025: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;

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

1023: '_Pvt',
1024: x_return_status);
1025: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;
1031: l_reacttime_rec.NAME := p_name;

Line 1028: RAISE FND_API.G_EXC_ERROR;

1024: x_return_status);
1025: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1026: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1027: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;
1031: l_reacttime_rec.NAME := p_name;
1032: l_reacttime_rec.DESCRIPTION := p_description;

Line 1080: WHEN FND_API.G_EXC_ERROR THEN

1076: x_object_version_number
1077: );
1078: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1079: EXCEPTION
1080: WHEN FND_API.G_EXC_ERROR THEN
1081: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1082: (
1083: l_api_name,
1084: G_PKG_NAME,

Line 1085: 'FND_API.G_RET_STS_ERROR',

1081: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1082: (
1083: l_api_name,
1084: G_PKG_NAME,
1085: 'FND_API.G_RET_STS_ERROR',
1086: x_msg_count,
1087: x_msg_data,
1088: '_Pvt'
1089: );

Line 1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1087: x_msg_data,
1088: '_Pvt'
1089: );
1090: APP_EXCEPTION.RAISE_EXCEPTION;
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1093: (
1094: l_api_name,
1095: G_PKG_NAME,

Line 1096: 'FND_API.G_RET_STS_UNEXP_ERROR',

1092: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1093: (
1094: l_api_name,
1095: G_PKG_NAME,
1096: 'FND_API.G_RET_STS_UNEXP_ERROR',
1097: x_msg_count,
1098: x_msg_data,
1099: '_Pvt'
1100: );

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

1122: x_msg_data OUT VARCHAR2,
1123: p_reaction_time_id IN NUMBER) IS
1124: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1125: l_api_version CONSTANT NUMBER := 1;
1126: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1127: BEGIN
1128: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1129: G_PKG_NAME,
1130: l_api_version,

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

1131: p_api_version,
1132: p_init_msg_list,
1133: '_Pvt',
1134: x_return_status);
1135: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;

Line 1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1132: p_init_msg_list,
1133: '_Pvt',
1134: x_return_status);
1135: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: DELETE FROM CS_COV_REACTION_TIMES

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

1133: '_Pvt',
1134: x_return_status);
1135: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: DELETE FROM CS_COV_REACTION_TIMES
1141: WHERE

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: x_return_status);
1135: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: DELETE FROM CS_COV_REACTION_TIMES
1141: WHERE
1142: REACTION_TIME_ID = p_reaction_time_id

Line 1146: WHEN FND_API.G_EXC_ERROR THEN

1142: REACTION_TIME_ID = p_reaction_time_id
1143: ;
1144: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1145: EXCEPTION
1146: WHEN FND_API.G_EXC_ERROR THEN
1147: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,

Line 1151: 'FND_API.G_RET_STS_ERROR',

1147: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1148: (
1149: l_api_name,
1150: G_PKG_NAME,
1151: 'FND_API.G_RET_STS_ERROR',
1152: x_msg_count,
1153: x_msg_data,
1154: '_Pvt'
1155: );

Line 1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1153: x_msg_data,
1154: '_Pvt'
1155: );
1156: APP_EXCEPTION.RAISE_EXCEPTION;
1157: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1158: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,

Line 1162: 'FND_API.G_RET_STS_UNEXP_ERROR',

1158: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1159: (
1160: l_api_name,
1161: G_PKG_NAME,
1162: 'FND_API.G_RET_STS_UNEXP_ERROR',
1163: x_msg_count,
1164: x_msg_data,
1165: '_Pvt'
1166: );

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

1188: x_msg_data OUT VARCHAR2,
1189: p_reacttime_val_rec IN ReactTime_Val_Rec_Type := G_MISS_REACTTIME_VAL_REC) IS
1190: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1191: l_api_version CONSTANT NUMBER := 1;
1192: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1193: l_reacttime_rec ReactTime_Rec_Type;
1194: l_def_reacttime_rec ReactTime_Rec_Type;
1195: BEGIN
1196: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1199: p_api_version,
1200: p_init_msg_list,
1201: '_Pvt',
1202: x_return_status);
1203: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;

Line 1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1200: p_init_msg_list,
1201: '_Pvt',
1202: x_return_status);
1203: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: migrate(p_reacttime_val_rec, l_reacttime_rec);

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

1201: '_Pvt',
1202: x_return_status);
1203: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: migrate(p_reacttime_val_rec, l_reacttime_rec);
1209: --- Validate all non-missing attributes (Item Level Validation)

Line 1206: RAISE FND_API.G_EXC_ERROR;

1202: x_return_status);
1203: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1204: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1205: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: migrate(p_reacttime_val_rec, l_reacttime_rec);
1209: --- Validate all non-missing attributes (Item Level Validation)
1210: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1210: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1206: RAISE FND_API.G_EXC_ERROR;
1207: END IF;
1208: migrate(p_reacttime_val_rec, l_reacttime_rec);
1209: --- Validate all non-missing attributes (Item Level Validation)
1210: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1211: l_return_status := Validate_Item_Attributes
1212: (
1213: l_reacttime_rec ---- IN
1214: );

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

1212: (
1213: l_reacttime_rec ---- IN
1214: );
1215: --- If any errors happen abort API
1216: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;

Line 1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1213: l_reacttime_rec ---- IN
1214: );
1215: --- If any errors happen abort API
1216: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;

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

1214: );
1215: --- If any errors happen abort API
1216: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;
1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: --- If any errors happen abort API
1216: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1218: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;
1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);

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

1218: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1219: RAISE FND_API.G_EXC_ERROR;
1220: END IF;
1221: END IF;
1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
1224: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1220: END IF;
1221: END IF;
1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
1224: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;

Line 1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1221: END IF;
1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
1224: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;

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

1222: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
1224: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1227: RAISE FND_API.G_EXC_ERROR;

1223: l_return_status := Validate_Item_Record(l_def_reacttime_rec);
1224: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1225: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1226: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1227: RAISE FND_API.G_EXC_ERROR;
1228: END IF;
1229: END IF;
1230: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1231: EXCEPTION

Line 1232: WHEN FND_API.G_EXC_ERROR THEN

1228: END IF;
1229: END IF;
1230: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1231: EXCEPTION
1232: WHEN FND_API.G_EXC_ERROR THEN
1233: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1234: (
1235: l_api_name,
1236: G_PKG_NAME,

Line 1237: 'FND_API.G_RET_STS_ERROR',

1233: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1234: (
1235: l_api_name,
1236: G_PKG_NAME,
1237: 'FND_API.G_RET_STS_ERROR',
1238: x_msg_count,
1239: x_msg_data,
1240: '_Pvt'
1241: );

Line 1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1239: x_msg_data,
1240: '_Pvt'
1241: );
1242: APP_EXCEPTION.RAISE_EXCEPTION;
1243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1244: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,

Line 1248: 'FND_API.G_RET_STS_UNEXP_ERROR',

1244: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1245: (
1246: l_api_name,
1247: G_PKG_NAME,
1248: 'FND_API.G_RET_STS_UNEXP_ERROR',
1249: x_msg_count,
1250: x_msg_data,
1251: '_Pvt'
1252: );

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

1310: p_context IN CS_COV_REACTION_TIMES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1311: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1312: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1313: l_api_version CONSTANT NUMBER := 1;
1314: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1315: l_reacttime_rec ReactTime_Val_Rec_Type;
1316: BEGIN
1317: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1318: G_PKG_NAME,

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

1320: p_api_version,
1321: p_init_msg_list,
1322: '_Pvt',
1323: x_return_status);
1324: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: END IF;

Line 1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1321: p_init_msg_list,
1322: '_Pvt',
1323: x_return_status);
1324: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: END IF;
1329: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;

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

1322: '_Pvt',
1323: x_return_status);
1324: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: END IF;
1329: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;
1330: l_reacttime_rec.NAME := p_name;

Line 1327: RAISE FND_API.G_EXC_ERROR;

1323: x_return_status);
1324: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1325: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1326: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1327: RAISE FND_API.G_EXC_ERROR;
1328: END IF;
1329: l_reacttime_rec.REACTION_TIME_ID := p_reaction_time_id;
1330: l_reacttime_rec.NAME := p_name;
1331: l_reacttime_rec.DESCRIPTION := p_description;

Line 1378: WHEN FND_API.G_EXC_ERROR THEN

1374: l_reacttime_rec
1375: );
1376: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1377: EXCEPTION
1378: WHEN FND_API.G_EXC_ERROR THEN
1379: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1380: (
1381: l_api_name,
1382: G_PKG_NAME,

Line 1383: 'FND_API.G_RET_STS_ERROR',

1379: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1380: (
1381: l_api_name,
1382: G_PKG_NAME,
1383: 'FND_API.G_RET_STS_ERROR',
1384: x_msg_count,
1385: x_msg_data,
1386: '_Pvt'
1387: );

Line 1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1385: x_msg_data,
1386: '_Pvt'
1387: );
1388: APP_EXCEPTION.RAISE_EXCEPTION;
1389: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1390: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,

Line 1394: 'FND_API.G_RET_STS_UNEXP_ERROR',

1390: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1391: (
1392: l_api_name,
1393: G_PKG_NAME,
1394: 'FND_API.G_RET_STS_UNEXP_ERROR',
1395: x_msg_count,
1396: x_msg_data,
1397: '_Pvt'
1398: );