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

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

18: p_billrate_rec IN BillRate_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_billrate_rec.coverage_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_billrate_rec.coverage_billing_type_id IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_billrate_rec.rate_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
30: p_billrate_rec.rate_type_code IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'rate_type_code');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billrate_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_billrate_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_billrate_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_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billrate_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_billrate_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_billrate_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_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billrate_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_billrate_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_billrate_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_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billrate_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_billrate_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_billrate_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_billrate_rec OUT BillRate_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_billrate_rec := p_billrate_rec;
70: l_def_billrate_rec.OBJECT_VERSION_NUMBER := NVL(l_def_billrate_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_billrate_rec IN BillRate_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_billrate_rec IN BillRate_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_Cov_Billing_Types
88: WHERE cs_cov_billing_types.coverage_billing_type_id = p_coverage_billing_type_id;
89: l_cs_coverage_billing_types_pk cs_coverage_billing_1_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_billrate_rec.COVERAGE_BILLING_TYPE_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_billrate_rec);

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

194: x_coverage_bill_rate_id OUT NUMBER,
195: x_object_version_number OUT NUMBER) IS
196: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
197: l_api_version CONSTANT NUMBER := 1;
198: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
199: l_billrate_rec BillRate_Rec_Type;
200: l_def_billrate_rec BillRate_Rec_Type;
201: BEGIN
202: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

205: p_api_version,
206: p_init_msg_list,
207: '_Pvt',
208: x_return_status);
209: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;

Line 210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

206: p_init_msg_list,
207: '_Pvt',
208: x_return_status);
209: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: l_billrate_rec := p_billrate_rec;

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

207: '_Pvt',
208: x_return_status);
209: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: l_billrate_rec := p_billrate_rec;
215: --- Validate all non-missing attributes (Item Level Validation)

Line 212: RAISE FND_API.G_EXC_ERROR;

208: x_return_status);
209: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
211: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: l_billrate_rec := p_billrate_rec;
215: --- Validate all non-missing attributes (Item Level Validation)
216: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 216: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

212: RAISE FND_API.G_EXC_ERROR;
213: END IF;
214: l_billrate_rec := p_billrate_rec;
215: --- Validate all non-missing attributes (Item Level Validation)
216: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
217: l_return_status := Validate_Item_Attributes
218: (
219: l_billrate_rec ---- IN
220: );

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

218: (
219: l_billrate_rec ---- IN
220: );
221: --- If any errors happen abort API
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: l_billrate_rec ---- IN
220: );
221: --- If any errors happen abort API
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;

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

220: );
221: --- If any errors happen abort API
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;
228: --- Defaulting item attributes

Line 225: RAISE FND_API.G_EXC_ERROR;

221: --- If any errors happen abort API
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;
228: --- Defaulting item attributes
229: l_return_status := Default_Item_Attributes

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

231: l_billrate_rec, ---- IN
232: l_def_billrate_rec
233: );
234: --- If any errors happen abort API
235: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;

Line 236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

232: l_def_billrate_rec
233: );
234: --- If any errors happen abort API
235: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

233: );
234: --- If any errors happen abort API
235: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);

Line 238: RAISE FND_API.G_EXC_ERROR;

234: --- If any errors happen abort API
235: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

236: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
237: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;

Line 243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

239: END IF;
240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;

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

240: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;
248: -- Set primary key value

Line 245: RAISE FND_API.G_EXC_ERROR;

241: l_return_status := Validate_Item_Record(l_def_billrate_rec);
242: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
245: RAISE FND_API.G_EXC_ERROR;
246: END IF;
247: END IF;
248: -- Set primary key value
249: l_def_billrate_rec.coverage_bill_rate_id := get_seq_id;

Line 313: WHEN FND_API.G_EXC_ERROR THEN

309: x_coverage_bill_rate_id := l_def_billrate_rec.coverage_bill_rate_id;
310: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
311: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
312: EXCEPTION
313: WHEN FND_API.G_EXC_ERROR THEN
314: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
315: (
316: l_api_name,
317: G_PKG_NAME,

Line 318: 'FND_API.G_RET_STS_ERROR',

314: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
315: (
316: l_api_name,
317: G_PKG_NAME,
318: 'FND_API.G_RET_STS_ERROR',
319: x_msg_count,
320: x_msg_data,
321: '_Pvt'
322: );

Line 324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

320: x_msg_data,
321: '_Pvt'
322: );
323: APP_EXCEPTION.RAISE_EXCEPTION;
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
326: (
327: l_api_name,
328: G_PKG_NAME,

Line 329: 'FND_API.G_RET_STS_UNEXP_ERROR',

325: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
326: (
327: l_api_name,
328: G_PKG_NAME,
329: 'FND_API.G_RET_STS_UNEXP_ERROR',
330: x_msg_count,
331: x_msg_data,
332: '_Pvt'
333: );

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

383: x_coverage_bill_rate_id OUT NUMBER,
384: x_object_version_number OUT NUMBER) IS
385: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
386: l_api_version CONSTANT NUMBER := 1;
387: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
388: l_billrate_rec BillRate_Rec_Type;
389: BEGIN
390: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
391: G_PKG_NAME,

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

393: p_api_version,
394: p_init_msg_list,
395: '_Pvt',
396: x_return_status);
397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;

Line 398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

394: p_init_msg_list,
395: '_Pvt',
396: x_return_status);
397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;

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

395: '_Pvt',
396: x_return_status);
397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;
403: l_billrate_rec.RATE_TYPE_CODE := p_rate_type_code;

Line 400: RAISE FND_API.G_EXC_ERROR;

396: x_return_status);
397: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
398: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
399: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
400: RAISE FND_API.G_EXC_ERROR;
401: END IF;
402: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;
403: l_billrate_rec.RATE_TYPE_CODE := p_rate_type_code;
404: l_billrate_rec.UNIT_OF_MEASURE_CODE := p_unit_of_measure_code;

Line 443: WHEN FND_API.G_EXC_ERROR THEN

439: x_object_version_number
440: );
441: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
442: EXCEPTION
443: WHEN FND_API.G_EXC_ERROR THEN
444: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
445: (
446: l_api_name,
447: G_PKG_NAME,

Line 448: 'FND_API.G_RET_STS_ERROR',

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

Line 454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

450: x_msg_data,
451: '_Pvt'
452: );
453: APP_EXCEPTION.RAISE_EXCEPTION;
454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
455: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
456: (
457: l_api_name,
458: G_PKG_NAME,

Line 459: 'FND_API.G_RET_STS_UNEXP_ERROR',

455: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
456: (
457: l_api_name,
458: G_PKG_NAME,
459: 'FND_API.G_RET_STS_UNEXP_ERROR',
460: x_msg_count,
461: x_msg_data,
462: '_Pvt'
463: );

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

502: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
503: ;
504: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
505: l_api_version CONSTANT NUMBER := 1;
506: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
507: l_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
508: lc_object_version_number CS_COV_BILL_RATES.OBJECT_VERSION_NUMBER%TYPE;
509: l_row_notfound BOOLEAN := FALSE;
510: lc_row_notfound BOOLEAN := FALSE;

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

515: p_api_version,
516: p_init_msg_list,
517: '_Pvt',
518: x_return_status);
519: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: p_init_msg_list,
517: '_Pvt',
518: x_return_status);
519: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: BEGIN

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

517: '_Pvt',
518: x_return_status);
519: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: BEGIN
525: OPEN lock_csr;

Line 522: RAISE FND_API.G_EXC_ERROR;

518: x_return_status);
519: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
522: RAISE FND_API.G_EXC_ERROR;
523: END IF;
524: BEGIN
525: OPEN lock_csr;
526: FETCH lock_csr INTO l_object_version_number;

Line 546: RAISE FND_API.G_EXC_ERROR;

542: CLOSE lchk_csr;
543: END IF;
544: IF (lc_row_notfound) THEN
545: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
546: RAISE FND_API.G_EXC_ERROR;
547: ELSIF lc_object_version_number > p_object_version_number THEN
548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 549: RAISE FND_API.G_EXC_ERROR;

545: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
546: RAISE FND_API.G_EXC_ERROR;
547: ELSIF lc_object_version_number > p_object_version_number THEN
548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN
551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF lc_object_version_number = -1 THEN

Line 552: RAISE FND_API.G_EXC_ERROR;

548: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
549: RAISE FND_API.G_EXC_ERROR;
550: ELSIF lc_object_version_number <> p_object_version_number THEN
551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF lc_object_version_number = -1 THEN
554: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;

Line 555: RAISE FND_API.G_EXC_ERROR;

551: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
552: RAISE FND_API.G_EXC_ERROR;
553: ELSIF lc_object_version_number = -1 THEN
554: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN

Line 559: WHEN FND_API.G_EXC_ERROR THEN

555: RAISE FND_API.G_EXC_ERROR;
556: END IF;
557: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,

Line 564: 'FND_API.G_RET_STS_ERROR',

560: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
561: (
562: l_api_name,
563: G_PKG_NAME,
564: 'FND_API.G_RET_STS_ERROR',
565: x_msg_count,
566: x_msg_data,
567: '_Pvt'
568: );

Line 570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

566: x_msg_data,
567: '_Pvt'
568: );
569: APP_EXCEPTION.RAISE_EXCEPTION;
570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
571: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
572: (
573: l_api_name,
574: G_PKG_NAME,

Line 575: 'FND_API.G_RET_STS_UNEXP_ERROR',

571: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
572: (
573: l_api_name,
574: G_PKG_NAME,
575: 'FND_API.G_RET_STS_UNEXP_ERROR',
576: x_msg_count,
577: x_msg_data,
578: '_Pvt'
579: );

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

602: p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC,
603: x_object_version_number OUT NUMBER) IS
604: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
605: l_api_version CONSTANT NUMBER := 1;
606: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
607: l_billrate_rec BillRate_Rec_Type;
608: l_def_billrate_rec BillRate_Rec_Type;
609: FUNCTION populate_new_record (
610: p_billrate_rec IN BillRate_Rec_Type,

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

615: FROM Cs_Cov_Bill_Rates
616: WHERE cs_cov_bill_rates.coverage_bill_rate_id = p_coverage_bill_rate_id;
617: l_cs_coverage_bill_rates_pk cs_coverage_bill_rates_pk_csr%ROWTYPE;
618: l_row_notfound BOOLEAN := TRUE;
619: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
620: BEGIN
621: x_billrate_rec := p_billrate_rec;
622: -- Get current database values
623: OPEN cs_coverage_bill_rates_pk_csr (p_billrate_rec.coverage_bill_rate_id);

Line 628: l_return_status := FND_API.G_RET_STS_ERROR;

624: FETCH cs_coverage_bill_rates_pk_csr INTO l_cs_coverage_bill_rates_pk;
625: l_row_notfound := cs_coverage_bill_rates_pk_csr%NOTFOUND;
626: CLOSE cs_coverage_bill_rates_pk_csr;
627: IF (l_row_notfound) THEN
628: l_return_status := FND_API.G_RET_STS_ERROR;
629: END IF;
630: IF (x_billrate_rec.coverage_bill_rate_id = TAPI_DEV_KIT.G_MISS_NUM)
631: THEN
632: x_billrate_rec.coverage_bill_rate_id := l_cs_coverage_bill_rates_pk.coverage_bill_rate_id;

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

748: p_api_version,
749: p_init_msg_list,
750: '_Pvt',
751: x_return_status);
752: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
755: RAISE FND_API.G_EXC_ERROR;
756: END IF;

Line 753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

749: p_init_msg_list,
750: '_Pvt',
751: x_return_status);
752: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
755: RAISE FND_API.G_EXC_ERROR;
756: END IF;
757: migrate(p_billrate_val_rec, l_billrate_rec);

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

750: '_Pvt',
751: x_return_status);
752: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
755: RAISE FND_API.G_EXC_ERROR;
756: END IF;
757: migrate(p_billrate_val_rec, l_billrate_rec);
758: --- Defaulting item attributes

Line 755: RAISE FND_API.G_EXC_ERROR;

751: x_return_status);
752: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
753: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
754: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
755: RAISE FND_API.G_EXC_ERROR;
756: END IF;
757: migrate(p_billrate_val_rec, l_billrate_rec);
758: --- Defaulting item attributes
759: l_return_status := Default_Item_Attributes

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

761: l_billrate_rec, ---- IN
762: l_def_billrate_rec
763: );
764: --- If any errors happen abort API
765: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;

Line 766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

762: l_def_billrate_rec
763: );
764: --- If any errors happen abort API
765: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);

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

763: );
764: --- If any errors happen abort API
765: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 768: RAISE FND_API.G_EXC_ERROR;

764: --- If any errors happen abort API
765: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
766: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
767: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

767: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

768: RAISE FND_API.G_EXC_ERROR;
769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: --- Validate all non-missing attributes (Item Level Validation)

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

769: END IF;
770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: --- Validate all non-missing attributes (Item Level Validation)
777: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 774: RAISE FND_API.G_EXC_ERROR;

770: l_return_status := populate_new_record(l_def_billrate_rec, l_def_billrate_rec);
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: --- Validate all non-missing attributes (Item Level Validation)
777: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
778: l_return_status := Validate_Item_Attributes

Line 777: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: --- Validate all non-missing attributes (Item Level Validation)
777: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
778: l_return_status := Validate_Item_Attributes
779: (
780: l_def_billrate_rec ---- IN
781: );

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

779: (
780: l_def_billrate_rec ---- IN
781: );
782: --- If any errors happen abort API
783: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;

Line 784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

780: l_def_billrate_rec ---- IN
781: );
782: --- If any errors happen abort API
783: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: END IF;

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

781: );
782: --- If any errors happen abort API
783: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: END IF;
789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 786: RAISE FND_API.G_EXC_ERROR;

782: --- If any errors happen abort API
783: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
785: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: END IF;
789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
790: l_return_status := Validate_Item_Record(l_def_billrate_rec);

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

785: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
786: RAISE FND_API.G_EXC_ERROR;
787: END IF;
788: END IF;
789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
790: l_return_status := Validate_Item_Record(l_def_billrate_rec);
791: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

787: END IF;
788: END IF;
789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
790: l_return_status := Validate_Item_Record(l_def_billrate_rec);
791: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;

Line 792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

788: END IF;
789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
790: l_return_status := Validate_Item_Record(l_def_billrate_rec);
791: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;

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

789: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
790: l_return_status := Validate_Item_Record(l_def_billrate_rec);
791: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;
797: UPDATE CS_COV_BILL_RATES

Line 794: RAISE FND_API.G_EXC_ERROR;

790: l_return_status := Validate_Item_Record(l_def_billrate_rec);
791: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
792: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
793: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
794: RAISE FND_API.G_EXC_ERROR;
795: END IF;
796: END IF;
797: UPDATE CS_COV_BILL_RATES
798: SET

Line 833: WHEN FND_API.G_EXC_ERROR THEN

829: ;
830: x_object_version_number := l_def_billrate_rec.OBJECT_VERSION_NUMBER;
831: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
835: (
836: l_api_name,
837: G_PKG_NAME,

Line 838: 'FND_API.G_RET_STS_ERROR',

834: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
835: (
836: l_api_name,
837: G_PKG_NAME,
838: 'FND_API.G_RET_STS_ERROR',
839: x_msg_count,
840: x_msg_data,
841: '_Pvt'
842: );

Line 844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

840: x_msg_data,
841: '_Pvt'
842: );
843: APP_EXCEPTION.RAISE_EXCEPTION;
844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
845: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,

Line 849: 'FND_API.G_RET_STS_UNEXP_ERROR',

845: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
846: (
847: l_api_name,
848: G_PKG_NAME,
849: 'FND_API.G_RET_STS_UNEXP_ERROR',
850: x_msg_count,
851: x_msg_data,
852: '_Pvt'
853: );

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

903: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
904: x_object_version_number OUT NUMBER) IS
905: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
906: l_api_version CONSTANT NUMBER := 1;
907: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
908: l_billrate_rec BillRate_Val_Rec_Type;
909: BEGIN
910: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
911: G_PKG_NAME,

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

913: p_api_version,
914: p_init_msg_list,
915: '_Pvt',
916: x_return_status);
917: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;

Line 918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

914: p_init_msg_list,
915: '_Pvt',
916: x_return_status);
917: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;

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

915: '_Pvt',
916: x_return_status);
917: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;
923: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;

Line 920: RAISE FND_API.G_EXC_ERROR;

916: x_return_status);
917: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
918: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
919: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;
923: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;
924: l_billrate_rec.RATE_TYPE_CODE := p_rate_type_code;

Line 963: WHEN FND_API.G_EXC_ERROR THEN

959: x_object_version_number
960: );
961: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
962: EXCEPTION
963: WHEN FND_API.G_EXC_ERROR THEN
964: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,

Line 968: 'FND_API.G_RET_STS_ERROR',

964: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
965: (
966: l_api_name,
967: G_PKG_NAME,
968: 'FND_API.G_RET_STS_ERROR',
969: x_msg_count,
970: x_msg_data,
971: '_Pvt'
972: );

Line 974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

970: x_msg_data,
971: '_Pvt'
972: );
973: APP_EXCEPTION.RAISE_EXCEPTION;
974: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
975: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,

Line 979: 'FND_API.G_RET_STS_UNEXP_ERROR',

975: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
976: (
977: l_api_name,
978: G_PKG_NAME,
979: 'FND_API.G_RET_STS_UNEXP_ERROR',
980: x_msg_count,
981: x_msg_data,
982: '_Pvt'
983: );

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

1005: x_msg_data OUT VARCHAR2,
1006: p_coverage_bill_rate_id IN NUMBER) IS
1007: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1008: l_api_version CONSTANT NUMBER := 1;
1009: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1010: BEGIN
1011: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1012: G_PKG_NAME,
1013: l_api_version,

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

1014: p_api_version,
1015: p_init_msg_list,
1016: '_Pvt',
1017: x_return_status);
1018: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1015: p_init_msg_list,
1016: '_Pvt',
1017: x_return_status);
1018: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: DELETE FROM CS_COV_BILL_RATES

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

1016: '_Pvt',
1017: x_return_status);
1018: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: DELETE FROM CS_COV_BILL_RATES
1024: WHERE

Line 1021: RAISE FND_API.G_EXC_ERROR;

1017: x_return_status);
1018: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1020: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR;
1022: END IF;
1023: DELETE FROM CS_COV_BILL_RATES
1024: WHERE
1025: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id

Line 1029: WHEN FND_API.G_EXC_ERROR THEN

1025: COVERAGE_BILL_RATE_ID = p_coverage_bill_rate_id
1026: ;
1027: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1031: (
1032: l_api_name,
1033: G_PKG_NAME,

Line 1034: 'FND_API.G_RET_STS_ERROR',

1030: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1031: (
1032: l_api_name,
1033: G_PKG_NAME,
1034: 'FND_API.G_RET_STS_ERROR',
1035: x_msg_count,
1036: x_msg_data,
1037: '_Pvt'
1038: );

Line 1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1036: x_msg_data,
1037: '_Pvt'
1038: );
1039: APP_EXCEPTION.RAISE_EXCEPTION;
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,

Line 1045: 'FND_API.G_RET_STS_UNEXP_ERROR',

1041: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1042: (
1043: l_api_name,
1044: G_PKG_NAME,
1045: 'FND_API.G_RET_STS_UNEXP_ERROR',
1046: x_msg_count,
1047: x_msg_data,
1048: '_Pvt'
1049: );

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

1071: x_msg_data OUT VARCHAR2,
1072: p_billrate_val_rec IN BillRate_Val_Rec_Type := G_MISS_BILLRATE_VAL_REC) IS
1073: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1074: l_api_version CONSTANT NUMBER := 1;
1075: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1076: l_billrate_rec BillRate_Rec_Type;
1077: l_def_billrate_rec BillRate_Rec_Type;
1078: BEGIN
1079: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1082: p_api_version,
1083: p_init_msg_list,
1084: '_Pvt',
1085: x_return_status);
1086: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: p_init_msg_list,
1084: '_Pvt',
1085: x_return_status);
1086: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: migrate(p_billrate_val_rec, l_billrate_rec);

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

1084: '_Pvt',
1085: x_return_status);
1086: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: migrate(p_billrate_val_rec, l_billrate_rec);
1092: --- Validate all non-missing attributes (Item Level Validation)

Line 1089: RAISE FND_API.G_EXC_ERROR;

1085: x_return_status);
1086: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: migrate(p_billrate_val_rec, l_billrate_rec);
1092: --- Validate all non-missing attributes (Item Level Validation)
1093: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1093: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;
1091: migrate(p_billrate_val_rec, l_billrate_rec);
1092: --- Validate all non-missing attributes (Item Level Validation)
1093: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1094: l_return_status := Validate_Item_Attributes
1095: (
1096: l_billrate_rec ---- IN
1097: );

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

1095: (
1096: l_billrate_rec ---- IN
1097: );
1098: --- If any errors happen abort API
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: l_billrate_rec ---- IN
1097: );
1098: --- If any errors happen abort API
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END IF;

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

1097: );
1098: --- If any errors happen abort API
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END IF;
1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: --- If any errors happen abort API
1099: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END IF;
1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);

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

1101: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: END IF;
1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);
1107: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1103: END IF;
1104: END IF;
1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);
1107: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;

Line 1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1104: END IF;
1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);
1107: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: END IF;

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

1105: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);
1107: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: END IF;
1113: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1110: RAISE FND_API.G_EXC_ERROR;

1106: l_return_status := Validate_Item_Record(l_def_billrate_rec);
1107: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1108: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1109: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: END IF;
1113: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1114: EXCEPTION

Line 1115: WHEN FND_API.G_EXC_ERROR THEN

1111: END IF;
1112: END IF;
1113: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1114: EXCEPTION
1115: WHEN FND_API.G_EXC_ERROR THEN
1116: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,

Line 1120: 'FND_API.G_RET_STS_ERROR',

1116: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1117: (
1118: l_api_name,
1119: G_PKG_NAME,
1120: 'FND_API.G_RET_STS_ERROR',
1121: x_msg_count,
1122: x_msg_data,
1123: '_Pvt'
1124: );

Line 1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1122: x_msg_data,
1123: '_Pvt'
1124: );
1125: APP_EXCEPTION.RAISE_EXCEPTION;
1126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1127: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,

Line 1131: 'FND_API.G_RET_STS_UNEXP_ERROR',

1127: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1128: (
1129: l_api_name,
1130: G_PKG_NAME,
1131: 'FND_API.G_RET_STS_UNEXP_ERROR',
1132: x_msg_count,
1133: x_msg_data,
1134: '_Pvt'
1135: );

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

1184: p_context IN CS_COV_BILL_RATES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1185: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1186: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1187: l_api_version CONSTANT NUMBER := 1;
1188: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1189: l_billrate_rec BillRate_Val_Rec_Type;
1190: BEGIN
1191: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1192: G_PKG_NAME,

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

1194: p_api_version,
1195: p_init_msg_list,
1196: '_Pvt',
1197: x_return_status);
1198: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;

Line 1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1195: p_init_msg_list,
1196: '_Pvt',
1197: x_return_status);
1198: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;

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

1196: '_Pvt',
1197: x_return_status);
1198: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;
1204: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;

Line 1201: RAISE FND_API.G_EXC_ERROR;

1197: x_return_status);
1198: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1199: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1200: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1201: RAISE FND_API.G_EXC_ERROR;
1202: END IF;
1203: l_billrate_rec.COVERAGE_BILL_RATE_ID := p_coverage_bill_rate_id;
1204: l_billrate_rec.COVERAGE_BILLING_TYPE_ID := p_coverage_billing_type_id;
1205: l_billrate_rec.RATE_TYPE_CODE := p_rate_type_code;

Line 1243: WHEN FND_API.G_EXC_ERROR THEN

1239: l_billrate_rec
1240: );
1241: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1242: EXCEPTION
1243: WHEN FND_API.G_EXC_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_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_ERROR',
1249: x_msg_count,
1250: x_msg_data,
1251: '_Pvt'
1252: );

Line 1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1250: x_msg_data,
1251: '_Pvt'
1252: );
1253: APP_EXCEPTION.RAISE_EXCEPTION;
1254: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1255: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,

Line 1259: 'FND_API.G_RET_STS_UNEXP_ERROR',

1255: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1256: (
1257: l_api_name,
1258: G_PKG_NAME,
1259: 'FND_API.G_RET_STS_UNEXP_ERROR',
1260: x_msg_count,
1261: x_msg_data,
1262: '_Pvt'
1263: );