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

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

18: p_contracttype_rec IN ContractType_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_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttype_rec.name IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

24: IF p_contracttype_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_contracttype_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_contracttype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_contracttype_rec.last_update_date IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_update_date');

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 38: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 43: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 48: l_return_status := FND_API.G_RET_STS_ERROR;

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

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

58: l_def_contracttype_rec OUT ContractType_Rec_Type
59: )
60: RETURN VARCHAR2
61: IS
62: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
63: BEGIN
64: l_def_contracttype_rec := p_contracttype_rec;
65: l_def_contracttype_rec.OBJECT_VERSION_NUMBER := NVL(l_def_contracttype_rec.OBJECT_VERSION_NUMBER, 0) + 1;
66: RETURN(l_return_status);

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

70: FUNCTION Validate_Item_Record (
71: p_contracttype_rec IN ContractType_Rec_Type
72: )
73: RETURN VARCHAR2 IS
74: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
75: FUNCTION validate_foreign_keys (
76: p_contracttype_rec IN ContractType_Rec_Type
77: )
78: RETURN VARCHAR2 IS

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

81: SELECT *
82: FROM Ra_Cust_Trx_Types
83: WHERE ra_cust_trx_types.cust_trx_type_id = p_cust_trx_type_id;
84: l_ra_cust_trx_types_pk ra_cust_trx_types_pk_csr%ROWTYPE;
85: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
86: l_row_notfound BOOLEAN := TRUE;
87: BEGIN
88: IF (p_contracttype_rec.CUST_TRX_TYPE_ID IS NOT NULL)
89: THEN

Line 102: l_return_status := FND_API.G_RET_STS_ERROR;

98: END IF;
99: RETURN (l_return_status);
100: EXCEPTION
101: WHEN item_not_found_error THEN
102: l_return_status := FND_API.G_RET_STS_ERROR;
103: RETURN (l_return_status);
104: END validate_foreign_keys;
105: BEGIN
106: l_return_status := validate_foreign_keys (p_contracttype_rec);

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

189: x_contract_type_id OUT NUMBER,
190: x_object_version_number OUT NUMBER) IS
191: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
192: l_api_version CONSTANT NUMBER := 1;
193: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
194: l_contracttype_rec ContractType_Rec_Type;
195: l_def_contracttype_rec ContractType_Rec_Type;
196: BEGIN
197: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

200: p_api_version,
201: p_init_msg_list,
202: '_Pvt',
203: x_return_status);
204: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;

Line 205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

201: p_init_msg_list,
202: '_Pvt',
203: x_return_status);
204: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: l_contracttype_rec := p_contracttype_rec;

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

202: '_Pvt',
203: x_return_status);
204: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: l_contracttype_rec := p_contracttype_rec;
210: --- Validate all non-missing attributes (Item Level Validation)

Line 207: RAISE FND_API.G_EXC_ERROR;

203: x_return_status);
204: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
205: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
206: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: l_contracttype_rec := p_contracttype_rec;
210: --- Validate all non-missing attributes (Item Level Validation)
211: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 211: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

207: RAISE FND_API.G_EXC_ERROR;
208: END IF;
209: l_contracttype_rec := p_contracttype_rec;
210: --- Validate all non-missing attributes (Item Level Validation)
211: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
212: l_return_status := Validate_Item_Attributes
213: (
214: l_contracttype_rec ---- IN
215: );

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

213: (
214: l_contracttype_rec ---- IN
215: );
216: --- If any errors happen abort API
217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;

Line 218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

214: l_contracttype_rec ---- IN
215: );
216: --- If any errors happen abort API
217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222: END IF;

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

215: );
216: --- If any errors happen abort API
217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222: END IF;
223: --- Defaulting item attributes

Line 220: RAISE FND_API.G_EXC_ERROR;

216: --- If any errors happen abort API
217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
220: RAISE FND_API.G_EXC_ERROR;
221: END IF;
222: END IF;
223: --- Defaulting item attributes
224: l_return_status := Default_Item_Attributes

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

226: l_contracttype_rec, ---- IN
227: l_def_contracttype_rec
228: );
229: --- If any errors happen abort API
230: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;

Line 231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

227: l_def_contracttype_rec
228: );
229: --- If any errors happen abort API
230: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

228: );
229: --- If any errors happen abort API
230: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);

Line 233: RAISE FND_API.G_EXC_ERROR;

229: --- If any errors happen abort API
230: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

231: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
232: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

233: RAISE FND_API.G_EXC_ERROR;
234: END IF;
235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;

Line 238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

235: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: END IF;
243: -- Set primary key value

Line 240: RAISE FND_API.G_EXC_ERROR;

236: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
237: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
238: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
239: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
240: RAISE FND_API.G_EXC_ERROR;
241: END IF;
242: END IF;
243: -- Set primary key value
244: l_def_contracttype_rec.contract_type_id := get_seq_id;

Line 308: WHEN FND_API.G_EXC_ERROR THEN

304: x_contract_type_id := l_def_contracttype_rec.contract_type_id;
305: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
306: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
307: EXCEPTION
308: WHEN FND_API.G_EXC_ERROR THEN
309: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,

Line 313: 'FND_API.G_RET_STS_ERROR',

309: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
310: (
311: l_api_name,
312: G_PKG_NAME,
313: 'FND_API.G_RET_STS_ERROR',
314: x_msg_count,
315: x_msg_data,
316: '_Pvt'
317: );

Line 319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

315: x_msg_data,
316: '_Pvt'
317: );
318: APP_EXCEPTION.RAISE_EXCEPTION;
319: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
320: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
321: (
322: l_api_name,
323: G_PKG_NAME,

Line 324: 'FND_API.G_RET_STS_UNEXP_ERROR',

320: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
321: (
322: l_api_name,
323: G_PKG_NAME,
324: 'FND_API.G_RET_STS_UNEXP_ERROR',
325: x_msg_count,
326: x_msg_data,
327: '_Pvt'
328: );

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

378: x_contract_type_id OUT NUMBER,
379: x_object_version_number OUT NUMBER) IS
380: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
381: l_api_version CONSTANT NUMBER := 1;
382: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
383: l_contracttype_rec ContractType_Rec_Type;
384: BEGIN
385: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
386: G_PKG_NAME,

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

388: p_api_version,
389: p_init_msg_list,
390: '_Pvt',
391: x_return_status);
392: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;

Line 393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

389: p_init_msg_list,
390: '_Pvt',
391: x_return_status);
392: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: l_contracttype_rec.NAME := p_name;

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

390: '_Pvt',
391: x_return_status);
392: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: l_contracttype_rec.NAME := p_name;
398: l_contracttype_rec.DESCRIPTION := p_description;

Line 395: RAISE FND_API.G_EXC_ERROR;

391: x_return_status);
392: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
393: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: l_contracttype_rec.NAME := p_name;
398: l_contracttype_rec.DESCRIPTION := p_description;
399: l_contracttype_rec.CUST_TRX_TYPE_ID := p_cust_trx_type_id;

Line 438: WHEN FND_API.G_EXC_ERROR THEN

434: x_object_version_number
435: );
436: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN
439: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
440: (
441: l_api_name,
442: G_PKG_NAME,

Line 443: 'FND_API.G_RET_STS_ERROR',

439: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
440: (
441: l_api_name,
442: G_PKG_NAME,
443: 'FND_API.G_RET_STS_ERROR',
444: x_msg_count,
445: x_msg_data,
446: '_Pvt'
447: );

Line 449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

445: x_msg_data,
446: '_Pvt'
447: );
448: APP_EXCEPTION.RAISE_EXCEPTION;
449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
450: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
451: (
452: l_api_name,
453: G_PKG_NAME,

Line 454: 'FND_API.G_RET_STS_UNEXP_ERROR',

450: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
451: (
452: l_api_name,
453: G_PKG_NAME,
454: 'FND_API.G_RET_STS_UNEXP_ERROR',
455: x_msg_count,
456: x_msg_data,
457: '_Pvt'
458: );

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

497: CONTRACT_TYPE_ID = p_contract_type_id
498: ;
499: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
500: l_api_version CONSTANT NUMBER := 1;
501: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
502: l_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
503: lc_object_version_number CS_CONTRACT_TYPES.OBJECT_VERSION_NUMBER%TYPE;
504: l_row_notfound BOOLEAN := FALSE;
505: lc_row_notfound BOOLEAN := FALSE;

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

510: p_api_version,
511: p_init_msg_list,
512: '_Pvt',
513: x_return_status);
514: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;

Line 515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

511: p_init_msg_list,
512: '_Pvt',
513: x_return_status);
514: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: BEGIN

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

512: '_Pvt',
513: x_return_status);
514: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: BEGIN
520: OPEN lock_csr;

Line 517: RAISE FND_API.G_EXC_ERROR;

513: x_return_status);
514: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
515: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
516: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
517: RAISE FND_API.G_EXC_ERROR;
518: END IF;
519: BEGIN
520: OPEN lock_csr;
521: FETCH lock_csr INTO l_object_version_number;

Line 541: RAISE FND_API.G_EXC_ERROR;

537: CLOSE lchk_csr;
538: END IF;
539: IF (lc_row_notfound) THEN
540: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
541: RAISE FND_API.G_EXC_ERROR;
542: ELSIF lc_object_version_number > p_object_version_number THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 544: RAISE FND_API.G_EXC_ERROR;

540: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
541: RAISE FND_API.G_EXC_ERROR;
542: ELSIF lc_object_version_number > p_object_version_number THEN
543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number = -1 THEN

Line 547: RAISE FND_API.G_EXC_ERROR;

543: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
544: RAISE FND_API.G_EXC_ERROR;
545: ELSIF lc_object_version_number <> p_object_version_number THEN
546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number = -1 THEN
549: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;

Line 550: RAISE FND_API.G_EXC_ERROR;

546: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
547: RAISE FND_API.G_EXC_ERROR;
548: ELSIF lc_object_version_number = -1 THEN
549: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN

Line 554: WHEN FND_API.G_EXC_ERROR THEN

550: RAISE FND_API.G_EXC_ERROR;
551: END IF;
552: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
553: EXCEPTION
554: WHEN FND_API.G_EXC_ERROR THEN
555: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
556: (
557: l_api_name,
558: G_PKG_NAME,

Line 559: 'FND_API.G_RET_STS_ERROR',

555: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
556: (
557: l_api_name,
558: G_PKG_NAME,
559: 'FND_API.G_RET_STS_ERROR',
560: x_msg_count,
561: x_msg_data,
562: '_Pvt'
563: );

Line 565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

561: x_msg_data,
562: '_Pvt'
563: );
564: APP_EXCEPTION.RAISE_EXCEPTION;
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
567: (
568: l_api_name,
569: G_PKG_NAME,

Line 570: 'FND_API.G_RET_STS_UNEXP_ERROR',

566: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
567: (
568: l_api_name,
569: G_PKG_NAME,
570: 'FND_API.G_RET_STS_UNEXP_ERROR',
571: x_msg_count,
572: x_msg_data,
573: '_Pvt'
574: );

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

597: p_contracttype_val_rec IN ContractType_Val_Rec_Type := G_MISS_CONTRACTTYPE_VAL_REC,
598: x_object_version_number OUT NUMBER) IS
599: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
600: l_api_version CONSTANT NUMBER := 1;
601: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
602: l_contracttype_rec ContractType_Rec_Type;
603: l_def_contracttype_rec ContractType_Rec_Type;
604: FUNCTION populate_new_record (
605: p_contracttype_rec IN ContractType_Rec_Type,

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

610: FROM Cs_Contract_Types
611: WHERE cs_contract_types.contract_type_id = p_contract_type_id;
612: l_cs_contract_types_pk cs_contract_types_pk_csr%ROWTYPE;
613: l_row_notfound BOOLEAN := TRUE;
614: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
615: BEGIN
616: x_contracttype_rec := p_contracttype_rec;
617: -- Get current database values
618: OPEN cs_contract_types_pk_csr (p_contracttype_rec.contract_type_id);

Line 623: l_return_status := FND_API.G_RET_STS_ERROR;

619: FETCH cs_contract_types_pk_csr INTO l_cs_contract_types_pk;
620: l_row_notfound := cs_contract_types_pk_csr%NOTFOUND;
621: CLOSE cs_contract_types_pk_csr;
622: IF (l_row_notfound) THEN
623: l_return_status := FND_API.G_RET_STS_ERROR;
624: END IF;
625: IF (x_contracttype_rec.contract_type_id = TAPI_DEV_KIT.G_MISS_NUM)
626: THEN
627: x_contracttype_rec.contract_type_id := l_cs_contract_types_pk.contract_type_id;

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

743: p_api_version,
744: p_init_msg_list,
745: '_Pvt',
746: x_return_status);
747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;

Line 748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

744: p_init_msg_list,
745: '_Pvt',
746: x_return_status);
747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: migrate(p_contracttype_val_rec, l_contracttype_rec);

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

745: '_Pvt',
746: x_return_status);
747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: migrate(p_contracttype_val_rec, l_contracttype_rec);
753: --- Defaulting item attributes

Line 750: RAISE FND_API.G_EXC_ERROR;

746: x_return_status);
747: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
748: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
749: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752: migrate(p_contracttype_val_rec, l_contracttype_rec);
753: --- Defaulting item attributes
754: l_return_status := Default_Item_Attributes

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

756: l_contracttype_rec, ---- IN
757: l_def_contracttype_rec
758: );
759: --- If any errors happen abort API
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;

Line 761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

757: l_def_contracttype_rec
758: );
759: --- If any errors happen abort API
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);

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

758: );
759: --- If any errors happen abort API
760: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
761: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 763: RAISE FND_API.G_EXC_ERROR;

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

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

762: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;

Line 767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

763: RAISE FND_API.G_EXC_ERROR;
764: END IF;
765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --- Validate all non-missing attributes (Item Level Validation)

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

764: END IF;
765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --- Validate all non-missing attributes (Item Level Validation)
772: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 769: RAISE FND_API.G_EXC_ERROR;

765: l_return_status := populate_new_record(l_def_contracttype_rec, l_def_contracttype_rec);
766: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
768: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --- Validate all non-missing attributes (Item Level Validation)
772: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
773: l_return_status := Validate_Item_Attributes

Line 772: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

768: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
769: RAISE FND_API.G_EXC_ERROR;
770: END IF;
771: --- Validate all non-missing attributes (Item Level Validation)
772: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
773: l_return_status := Validate_Item_Attributes
774: (
775: l_def_contracttype_rec ---- IN
776: );

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

774: (
775: l_def_contracttype_rec ---- IN
776: );
777: --- If any errors happen abort API
778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;

Line 779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

775: l_def_contracttype_rec ---- IN
776: );
777: --- If any errors happen abort API
778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: END IF;

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

776: );
777: --- If any errors happen abort API
778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: END IF;
784: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 781: RAISE FND_API.G_EXC_ERROR;

777: --- If any errors happen abort API
778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: END IF;
784: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
785: l_return_status := Validate_Item_Record(l_def_contracttype_rec);

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

780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
781: RAISE FND_API.G_EXC_ERROR;
782: END IF;
783: END IF;
784: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
785: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
786: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

782: END IF;
783: END IF;
784: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
785: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
786: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;

Line 787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 789: RAISE FND_API.G_EXC_ERROR;

785: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
786: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
787: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
788: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
789: RAISE FND_API.G_EXC_ERROR;
790: END IF;
791: END IF;
792: UPDATE CS_CONTRACT_TYPES
793: SET

Line 828: WHEN FND_API.G_EXC_ERROR THEN

824: ;
825: x_object_version_number := l_def_contracttype_rec.OBJECT_VERSION_NUMBER;
826: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
827: EXCEPTION
828: WHEN FND_API.G_EXC_ERROR THEN
829: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,

Line 833: 'FND_API.G_RET_STS_ERROR',

829: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
830: (
831: l_api_name,
832: G_PKG_NAME,
833: 'FND_API.G_RET_STS_ERROR',
834: x_msg_count,
835: x_msg_data,
836: '_Pvt'
837: );

Line 839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

835: x_msg_data,
836: '_Pvt'
837: );
838: APP_EXCEPTION.RAISE_EXCEPTION;
839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,

Line 844: 'FND_API.G_RET_STS_UNEXP_ERROR',

840: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
841: (
842: l_api_name,
843: G_PKG_NAME,
844: 'FND_API.G_RET_STS_UNEXP_ERROR',
845: x_msg_count,
846: x_msg_data,
847: '_Pvt'
848: );

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

898: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
899: x_object_version_number OUT NUMBER) IS
900: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
901: l_api_version CONSTANT NUMBER := 1;
902: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
903: l_contracttype_rec ContractType_Val_Rec_Type;
904: BEGIN
905: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
906: G_PKG_NAME,

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

908: p_api_version,
909: p_init_msg_list,
910: '_Pvt',
911: x_return_status);
912: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;

Line 913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

909: p_init_msg_list,
910: '_Pvt',
911: x_return_status);
912: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;

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

910: '_Pvt',
911: x_return_status);
912: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;
918: l_contracttype_rec.NAME := p_name;

Line 915: RAISE FND_API.G_EXC_ERROR;

911: x_return_status);
912: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
913: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
914: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
915: RAISE FND_API.G_EXC_ERROR;
916: END IF;
917: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;
918: l_contracttype_rec.NAME := p_name;
919: l_contracttype_rec.DESCRIPTION := p_description;

Line 958: WHEN FND_API.G_EXC_ERROR THEN

954: x_object_version_number
955: );
956: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
957: EXCEPTION
958: WHEN FND_API.G_EXC_ERROR THEN
959: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
960: (
961: l_api_name,
962: G_PKG_NAME,

Line 963: 'FND_API.G_RET_STS_ERROR',

959: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
960: (
961: l_api_name,
962: G_PKG_NAME,
963: 'FND_API.G_RET_STS_ERROR',
964: x_msg_count,
965: x_msg_data,
966: '_Pvt'
967: );

Line 969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

965: x_msg_data,
966: '_Pvt'
967: );
968: APP_EXCEPTION.RAISE_EXCEPTION;
969: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,

Line 974: 'FND_API.G_RET_STS_UNEXP_ERROR',

970: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
971: (
972: l_api_name,
973: G_PKG_NAME,
974: 'FND_API.G_RET_STS_UNEXP_ERROR',
975: x_msg_count,
976: x_msg_data,
977: '_Pvt'
978: );

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

1000: x_msg_data OUT VARCHAR2,
1001: p_contract_type_id IN NUMBER) IS
1002: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1003: l_api_version CONSTANT NUMBER := 1;
1004: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1005: BEGIN
1006: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1007: G_PKG_NAME,
1008: l_api_version,

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

1009: p_api_version,
1010: p_init_msg_list,
1011: '_Pvt',
1012: x_return_status);
1013: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;

Line 1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1010: p_init_msg_list,
1011: '_Pvt',
1012: x_return_status);
1013: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: DELETE FROM CS_CONTRACT_TYPES

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

1011: '_Pvt',
1012: x_return_status);
1013: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: DELETE FROM CS_CONTRACT_TYPES
1019: WHERE

Line 1016: RAISE FND_API.G_EXC_ERROR;

1012: x_return_status);
1013: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1014: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1015: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1016: RAISE FND_API.G_EXC_ERROR;
1017: END IF;
1018: DELETE FROM CS_CONTRACT_TYPES
1019: WHERE
1020: CONTRACT_TYPE_ID = p_contract_type_id

Line 1024: WHEN FND_API.G_EXC_ERROR THEN

1020: CONTRACT_TYPE_ID = p_contract_type_id
1021: ;
1022: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1023: EXCEPTION
1024: WHEN FND_API.G_EXC_ERROR THEN
1025: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1026: (
1027: l_api_name,
1028: G_PKG_NAME,

Line 1029: 'FND_API.G_RET_STS_ERROR',

1025: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1026: (
1027: l_api_name,
1028: G_PKG_NAME,
1029: 'FND_API.G_RET_STS_ERROR',
1030: x_msg_count,
1031: x_msg_data,
1032: '_Pvt'
1033: );

Line 1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1031: x_msg_data,
1032: '_Pvt'
1033: );
1034: APP_EXCEPTION.RAISE_EXCEPTION;
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1037: (
1038: l_api_name,
1039: G_PKG_NAME,

Line 1040: 'FND_API.G_RET_STS_UNEXP_ERROR',

1036: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1037: (
1038: l_api_name,
1039: G_PKG_NAME,
1040: 'FND_API.G_RET_STS_UNEXP_ERROR',
1041: x_msg_count,
1042: x_msg_data,
1043: '_Pvt'
1044: );

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

1066: x_msg_data OUT VARCHAR2,
1067: p_contracttype_val_rec IN ContractType_Val_Rec_Type := G_MISS_CONTRACTTYPE_VAL_REC) IS
1068: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1069: l_api_version CONSTANT NUMBER := 1;
1070: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1071: l_contracttype_rec ContractType_Rec_Type;
1072: l_def_contracttype_rec ContractType_Rec_Type;
1073: BEGIN
1074: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1077: p_api_version,
1078: p_init_msg_list,
1079: '_Pvt',
1080: x_return_status);
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078: p_init_msg_list,
1079: '_Pvt',
1080: x_return_status);
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: migrate(p_contracttype_val_rec, l_contracttype_rec);

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

1079: '_Pvt',
1080: x_return_status);
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: migrate(p_contracttype_val_rec, l_contracttype_rec);
1087: --- Validate all non-missing attributes (Item Level Validation)

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: x_return_status);
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: migrate(p_contracttype_val_rec, l_contracttype_rec);
1087: --- Validate all non-missing attributes (Item Level Validation)
1088: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1088: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: migrate(p_contracttype_val_rec, l_contracttype_rec);
1087: --- Validate all non-missing attributes (Item Level Validation)
1088: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1089: l_return_status := Validate_Item_Attributes
1090: (
1091: l_contracttype_rec ---- IN
1092: );

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

1090: (
1091: l_contracttype_rec ---- IN
1092: );
1093: --- If any errors happen abort API
1094: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;

Line 1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1091: l_contracttype_rec ---- IN
1092: );
1093: --- If any errors happen abort API
1094: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;

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

1092: );
1093: --- If any errors happen abort API
1094: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;
1100: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1097: RAISE FND_API.G_EXC_ERROR;

1093: --- If any errors happen abort API
1094: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1096: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;
1100: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1101: l_return_status := Validate_Item_Record(l_def_contracttype_rec);

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

1096: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1097: RAISE FND_API.G_EXC_ERROR;
1098: END IF;
1099: END IF;
1100: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1101: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1098: END IF;
1099: END IF;
1100: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1101: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

1100: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1101: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: END IF;
1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1105: RAISE FND_API.G_EXC_ERROR;

1101: l_return_status := Validate_Item_Record(l_def_contracttype_rec);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: END IF;
1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1109: EXCEPTION

Line 1110: WHEN FND_API.G_EXC_ERROR THEN

1106: END IF;
1107: END IF;
1108: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1109: EXCEPTION
1110: WHEN FND_API.G_EXC_ERROR THEN
1111: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1112: (
1113: l_api_name,
1114: G_PKG_NAME,

Line 1115: 'FND_API.G_RET_STS_ERROR',

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

Line 1121: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1126: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

1179: p_context IN CS_CONTRACT_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1180: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1181: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1182: l_api_version CONSTANT NUMBER := 1;
1183: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1184: l_contracttype_rec ContractType_Val_Rec_Type;
1185: BEGIN
1186: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1187: G_PKG_NAME,

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

1189: p_api_version,
1190: p_init_msg_list,
1191: '_Pvt',
1192: x_return_status);
1193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;

Line 1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1190: p_init_msg_list,
1191: '_Pvt',
1192: x_return_status);
1193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;

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

1191: '_Pvt',
1192: x_return_status);
1193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;
1199: l_contracttype_rec.NAME := p_name;

Line 1196: RAISE FND_API.G_EXC_ERROR;

1192: x_return_status);
1193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1196: RAISE FND_API.G_EXC_ERROR;
1197: END IF;
1198: l_contracttype_rec.CONTRACT_TYPE_ID := p_contract_type_id;
1199: l_contracttype_rec.NAME := p_name;
1200: l_contracttype_rec.DESCRIPTION := p_description;

Line 1238: WHEN FND_API.G_EXC_ERROR THEN

1234: l_contracttype_rec
1235: );
1236: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1237: EXCEPTION
1238: WHEN FND_API.G_EXC_ERROR THEN
1239: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1241: l_api_name,
1242: G_PKG_NAME,

Line 1243: 'FND_API.G_RET_STS_ERROR',

1239: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1241: l_api_name,
1242: G_PKG_NAME,
1243: 'FND_API.G_RET_STS_ERROR',
1244: x_msg_count,
1245: x_msg_data,
1246: '_Pvt'
1247: );

Line 1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1245: x_msg_data,
1246: '_Pvt'
1247: );
1248: APP_EXCEPTION.RAISE_EXCEPTION;
1249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1250: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,

Line 1254: 'FND_API.G_RET_STS_UNEXP_ERROR',

1250: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1251: (
1252: l_api_name,
1253: G_PKG_NAME,
1254: 'FND_API.G_RET_STS_UNEXP_ERROR',
1255: x_msg_count,
1256: x_msg_data,
1257: '_Pvt'
1258: );