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

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

18: p_contractltmpl_rec IN ContractLTmpl_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_contractltmpl_rec.service_manufacturing_org_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_contractltmpl_rec.service_manufacturing_org_id IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_contractltmpl_rec.service_inventory_item_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_contractltmpl_rec.service_inventory_item_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'service_inventory_item_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractltmpl_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_contractltmpl_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_contractltmpl_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_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractltmpl_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_contractltmpl_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_contractltmpl_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_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractltmpl_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_contractltmpl_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_contractltmpl_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_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractltmpl_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_contractltmpl_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_contractltmpl_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_contractltmpl_rec OUT ContractLTmpl_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_contractltmpl_rec := p_contractltmpl_rec;
70: l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER := NVL(l_def_contractltmpl_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_contractltmpl_rec IN ContractLTmpl_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_contractltmpl_rec IN ContractLTmpl_Rec_Type
82: )
83: RETURN VARCHAR2 IS

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

91: SELECT *
92: FROM Cs_Contract_Templates
93: WHERE cs_contract_templates.contract_template_id = p_contract_template_id;
94: l_cs_contract_templates_pk cs_contract_templates_pk_csr%ROWTYPE;
95: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
96: l_row_notfound BOOLEAN := TRUE;
97: BEGIN
98: IF (p_contractltmpl_rec.COVERAGE_ID IS NOT NULL)
99: THEN

Line 123: l_return_status := FND_API.G_RET_STS_ERROR;

119: END IF;
120: RETURN (l_return_status);
121: EXCEPTION
122: WHEN item_not_found_error THEN
123: l_return_status := FND_API.G_RET_STS_ERROR;
124: RETURN (l_return_status);
125: END validate_foreign_keys;
126: BEGIN
127: l_return_status := validate_foreign_keys (p_contractltmpl_rec);

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

220: x_contract_line_template_id OUT NUMBER,
221: x_object_version_number OUT NUMBER) IS
222: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
223: l_api_version CONSTANT NUMBER := 1;
224: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
225: l_contractltmpl_rec ContractLTmpl_Rec_Type;
226: l_def_contractltmpl_rec ContractLTmpl_Rec_Type;
227: BEGIN
228: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

231: p_api_version,
232: p_init_msg_list,
233: '_Pvt',
234: x_return_status);
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: p_init_msg_list,
233: '_Pvt',
234: x_return_status);
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: l_contractltmpl_rec := p_contractltmpl_rec;

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

233: '_Pvt',
234: x_return_status);
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: l_contractltmpl_rec := p_contractltmpl_rec;
241: --- Validate all non-missing attributes (Item Level Validation)

Line 238: RAISE FND_API.G_EXC_ERROR;

234: x_return_status);
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: l_contractltmpl_rec := p_contractltmpl_rec;
241: --- Validate all non-missing attributes (Item Level Validation)
242: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 242: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: l_contractltmpl_rec := p_contractltmpl_rec;
241: --- Validate all non-missing attributes (Item Level Validation)
242: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
243: l_return_status := Validate_Item_Attributes
244: (
245: l_contractltmpl_rec ---- IN
246: );

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

244: (
245: l_contractltmpl_rec ---- IN
246: );
247: --- If any errors happen abort API
248: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;

Line 249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

245: l_contractltmpl_rec ---- IN
246: );
247: --- If any errors happen abort API
248: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: END IF;

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

246: );
247: --- If any errors happen abort API
248: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: END IF;
254: --- Defaulting item attributes

Line 251: RAISE FND_API.G_EXC_ERROR;

247: --- If any errors happen abort API
248: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253: END IF;
254: --- Defaulting item attributes
255: l_return_status := Default_Item_Attributes

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

257: l_contractltmpl_rec, ---- IN
258: l_def_contractltmpl_rec
259: );
260: --- If any errors happen abort API
261: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;

Line 262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

258: l_def_contractltmpl_rec
259: );
260: --- If any errors happen abort API
261: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

259: );
260: --- If any errors happen abort API
261: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);

Line 264: RAISE FND_API.G_EXC_ERROR;

260: --- If any errors happen abort API
261: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
263: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

264: RAISE FND_API.G_EXC_ERROR;
265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;

Line 269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

265: END IF;
266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273: END IF;

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

266: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273: END IF;
274: -- Set primary key value

Line 271: RAISE FND_API.G_EXC_ERROR;

267: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
268: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
270: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
271: RAISE FND_API.G_EXC_ERROR;
272: END IF;
273: END IF;
274: -- Set primary key value
275: l_def_contractltmpl_rec.contract_line_template_id := get_seq_id;

Line 349: WHEN FND_API.G_EXC_ERROR THEN

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

Line 354: 'FND_API.G_RET_STS_ERROR',

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

Line 360: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 365: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

424: x_contract_line_template_id OUT NUMBER,
425: x_object_version_number OUT NUMBER) IS
426: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
427: l_api_version CONSTANT NUMBER := 1;
428: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
429: l_contractltmpl_rec ContractLTmpl_Rec_Type;
430: BEGIN
431: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
432: G_PKG_NAME,

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

434: p_api_version,
435: p_init_msg_list,
436: '_Pvt',
437: x_return_status);
438: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;

Line 439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

435: p_init_msg_list,
436: '_Pvt',
437: x_return_status);
438: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;

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

436: '_Pvt',
437: x_return_status);
438: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;
444: l_contractltmpl_rec.COVERAGE_ID := p_coverage_id;

Line 441: RAISE FND_API.G_EXC_ERROR;

437: x_return_status);
438: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
439: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
440: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
441: RAISE FND_API.G_EXC_ERROR;
442: END IF;
443: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;
444: l_contractltmpl_rec.COVERAGE_ID := p_coverage_id;
445: l_contractltmpl_rec.SERVICE_MANUFACTURING_ORG_ID := p_service_manufacturing_org_id;

Line 489: WHEN FND_API.G_EXC_ERROR THEN

485: x_object_version_number
486: );
487: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
488: EXCEPTION
489: WHEN FND_API.G_EXC_ERROR THEN
490: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,

Line 494: 'FND_API.G_RET_STS_ERROR',

490: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
491: (
492: l_api_name,
493: G_PKG_NAME,
494: 'FND_API.G_RET_STS_ERROR',
495: x_msg_count,
496: x_msg_data,
497: '_Pvt'
498: );

Line 500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

496: x_msg_data,
497: '_Pvt'
498: );
499: APP_EXCEPTION.RAISE_EXCEPTION;
500: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
501: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
502: (
503: l_api_name,
504: G_PKG_NAME,

Line 505: 'FND_API.G_RET_STS_UNEXP_ERROR',

501: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
502: (
503: l_api_name,
504: G_PKG_NAME,
505: 'FND_API.G_RET_STS_UNEXP_ERROR',
506: x_msg_count,
507: x_msg_data,
508: '_Pvt'
509: );

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

548: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
549: ;
550: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
551: l_api_version CONSTANT NUMBER := 1;
552: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
553: l_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;
554: lc_object_version_number CS_CONTRACT_LINE_TPLTS.OBJECT_VERSION_NUMBER%TYPE;
555: l_row_notfound BOOLEAN := FALSE;
556: lc_row_notfound BOOLEAN := FALSE;

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

561: p_api_version,
562: p_init_msg_list,
563: '_Pvt',
564: x_return_status);
565: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;

Line 566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

562: p_init_msg_list,
563: '_Pvt',
564: x_return_status);
565: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: BEGIN

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

563: '_Pvt',
564: x_return_status);
565: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: BEGIN
571: OPEN lock_csr;

Line 568: RAISE FND_API.G_EXC_ERROR;

564: x_return_status);
565: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
566: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
567: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
568: RAISE FND_API.G_EXC_ERROR;
569: END IF;
570: BEGIN
571: OPEN lock_csr;
572: FETCH lock_csr INTO l_object_version_number;

Line 592: RAISE FND_API.G_EXC_ERROR;

588: CLOSE lchk_csr;
589: END IF;
590: IF (lc_row_notfound) THEN
591: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF lc_object_version_number > p_object_version_number THEN
594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 595: RAISE FND_API.G_EXC_ERROR;

591: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
592: RAISE FND_API.G_EXC_ERROR;
593: ELSIF lc_object_version_number > p_object_version_number THEN
594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF lc_object_version_number <> p_object_version_number THEN
597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF lc_object_version_number = -1 THEN

Line 598: RAISE FND_API.G_EXC_ERROR;

594: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
595: RAISE FND_API.G_EXC_ERROR;
596: ELSIF lc_object_version_number <> p_object_version_number THEN
597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF lc_object_version_number = -1 THEN
600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;

Line 601: RAISE FND_API.G_EXC_ERROR;

597: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
598: RAISE FND_API.G_EXC_ERROR;
599: ELSIF lc_object_version_number = -1 THEN
600: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601: RAISE FND_API.G_EXC_ERROR;
602: END IF;
603: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
607: (
608: l_api_name,
609: G_PKG_NAME,

Line 610: 'FND_API.G_RET_STS_ERROR',

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

Line 616: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 621: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

648: p_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC,
649: x_object_version_number OUT NUMBER) IS
650: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
651: l_api_version CONSTANT NUMBER := 1;
652: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
653: l_contractltmpl_rec ContractLTmpl_Rec_Type;
654: l_def_contractltmpl_rec ContractLTmpl_Rec_Type;
655: FUNCTION populate_new_record (
656: p_contractltmpl_rec IN ContractLTmpl_Rec_Type,

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

661: FROM Cs_Contract_Line_Tplts
662: WHERE cs_contract_line_tplts.contract_line_template_id = p_contract_line_template_id;
663: l_cs_contract_line_tem1 cs_contract_line_tem1_csr%ROWTYPE;
664: l_row_notfound BOOLEAN := TRUE;
665: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
666: BEGIN
667: x_contractltmpl_rec := p_contractltmpl_rec;
668: -- Get current database values
669: OPEN cs_contract_line_tem1_csr (p_contractltmpl_rec.contract_line_template_id);

Line 674: l_return_status := FND_API.G_RET_STS_ERROR;

670: FETCH cs_contract_line_tem1_csr INTO l_cs_contract_line_tem1;
671: l_row_notfound := cs_contract_line_tem1_csr%NOTFOUND;
672: CLOSE cs_contract_line_tem1_csr;
673: IF (l_row_notfound) THEN
674: l_return_status := FND_API.G_RET_STS_ERROR;
675: END IF;
676: IF (x_contractltmpl_rec.contract_line_template_id = TAPI_DEV_KIT.G_MISS_NUM)
677: THEN
678: x_contractltmpl_rec.contract_line_template_id := l_cs_contract_line_tem1.contract_line_template_id;

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

814: p_api_version,
815: p_init_msg_list,
816: '_Pvt',
817: x_return_status);
818: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;

Line 819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

815: p_init_msg_list,
816: '_Pvt',
817: x_return_status);
818: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);

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

816: '_Pvt',
817: x_return_status);
818: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);
824: --- Defaulting item attributes

Line 821: RAISE FND_API.G_EXC_ERROR;

817: x_return_status);
818: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
819: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
820: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);
824: --- Defaulting item attributes
825: l_return_status := Default_Item_Attributes

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

827: l_contractltmpl_rec, ---- IN
828: l_def_contractltmpl_rec
829: );
830: --- If any errors happen abort API
831: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;

Line 832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

828: l_def_contractltmpl_rec
829: );
830: --- If any errors happen abort API
831: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);

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

829: );
830: --- If any errors happen abort API
831: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 834: RAISE FND_API.G_EXC_ERROR;

830: --- If any errors happen abort API
831: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
832: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
833: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

833: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;

Line 838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

834: RAISE FND_API.G_EXC_ERROR;
835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: --- Validate all non-missing attributes (Item Level Validation)

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

835: END IF;
836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: --- Validate all non-missing attributes (Item Level Validation)
843: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 840: RAISE FND_API.G_EXC_ERROR;

836: l_return_status := populate_new_record(l_def_contractltmpl_rec, l_def_contractltmpl_rec);
837: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
838: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: --- Validate all non-missing attributes (Item Level Validation)
843: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
844: l_return_status := Validate_Item_Attributes

Line 843: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

839: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
840: RAISE FND_API.G_EXC_ERROR;
841: END IF;
842: --- Validate all non-missing attributes (Item Level Validation)
843: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
844: l_return_status := Validate_Item_Attributes
845: (
846: l_def_contractltmpl_rec ---- IN
847: );

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

845: (
846: l_def_contractltmpl_rec ---- IN
847: );
848: --- If any errors happen abort API
849: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: l_def_contractltmpl_rec ---- IN
847: );
848: --- If any errors happen abort API
849: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: END IF;

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

847: );
848: --- If any errors happen abort API
849: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: END IF;
855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 852: RAISE FND_API.G_EXC_ERROR;

848: --- If any errors happen abort API
849: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: END IF;
855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);

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

851: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854: END IF;
855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

853: END IF;
854: END IF;
855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: END IF;
855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: END IF;

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

855: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: END IF;
863: UPDATE CS_CONTRACT_LINE_TPLTS

Line 860: RAISE FND_API.G_EXC_ERROR;

856: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862: END IF;
863: UPDATE CS_CONTRACT_LINE_TPLTS
864: SET

Line 904: WHEN FND_API.G_EXC_ERROR THEN

900: ;
901: x_object_version_number := l_def_contractltmpl_rec.OBJECT_VERSION_NUMBER;
902: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
903: EXCEPTION
904: WHEN FND_API.G_EXC_ERROR THEN
905: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,

Line 909: 'FND_API.G_RET_STS_ERROR',

905: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
906: (
907: l_api_name,
908: G_PKG_NAME,
909: 'FND_API.G_RET_STS_ERROR',
910: x_msg_count,
911: x_msg_data,
912: '_Pvt'
913: );

Line 915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

911: x_msg_data,
912: '_Pvt'
913: );
914: APP_EXCEPTION.RAISE_EXCEPTION;
915: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
916: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,

Line 920: 'FND_API.G_RET_STS_UNEXP_ERROR',

916: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
917: (
918: l_api_name,
919: G_PKG_NAME,
920: 'FND_API.G_RET_STS_UNEXP_ERROR',
921: x_msg_count,
922: x_msg_data,
923: '_Pvt'
924: );

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

979: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
980: x_object_version_number OUT NUMBER) IS
981: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
982: l_api_version CONSTANT NUMBER := 1;
983: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
984: l_contractltmpl_rec ContractLTmpl_Val_Rec_Type;
985: BEGIN
986: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
987: G_PKG_NAME,

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

989: p_api_version,
990: p_init_msg_list,
991: '_Pvt',
992: x_return_status);
993: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;

Line 994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

990: p_init_msg_list,
991: '_Pvt',
992: x_return_status);
993: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;
998: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;

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

991: '_Pvt',
992: x_return_status);
993: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;
998: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;
999: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;

Line 996: RAISE FND_API.G_EXC_ERROR;

992: x_return_status);
993: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
994: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
995: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
996: RAISE FND_API.G_EXC_ERROR;
997: END IF;
998: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;
999: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;
1000: l_contractltmpl_rec.COVERAGE_ID := p_coverage_id;

Line 1044: WHEN FND_API.G_EXC_ERROR THEN

1040: x_object_version_number
1041: );
1042: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1043: EXCEPTION
1044: WHEN FND_API.G_EXC_ERROR THEN
1045: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1046: (
1047: l_api_name,
1048: G_PKG_NAME,

Line 1049: 'FND_API.G_RET_STS_ERROR',

1045: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1046: (
1047: l_api_name,
1048: G_PKG_NAME,
1049: 'FND_API.G_RET_STS_ERROR',
1050: x_msg_count,
1051: x_msg_data,
1052: '_Pvt'
1053: );

Line 1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1051: x_msg_data,
1052: '_Pvt'
1053: );
1054: APP_EXCEPTION.RAISE_EXCEPTION;
1055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1056: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1057: (
1058: l_api_name,
1059: G_PKG_NAME,

Line 1060: 'FND_API.G_RET_STS_UNEXP_ERROR',

1056: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1057: (
1058: l_api_name,
1059: G_PKG_NAME,
1060: 'FND_API.G_RET_STS_UNEXP_ERROR',
1061: x_msg_count,
1062: x_msg_data,
1063: '_Pvt'
1064: );

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

1086: x_msg_data OUT VARCHAR2,
1087: p_contract_line_template_id IN NUMBER) IS
1088: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1089: l_api_version CONSTANT NUMBER := 1;
1090: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1091: BEGIN
1092: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1093: G_PKG_NAME,
1094: l_api_version,

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

1095: p_api_version,
1096: p_init_msg_list,
1097: '_Pvt',
1098: x_return_status);
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: p_init_msg_list,
1097: '_Pvt',
1098: x_return_status);
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: DELETE FROM CS_CONTRACT_LINE_TPLTS

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

1097: '_Pvt',
1098: x_return_status);
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: DELETE FROM CS_CONTRACT_LINE_TPLTS
1105: WHERE

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: x_return_status);
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: DELETE FROM CS_CONTRACT_LINE_TPLTS
1105: WHERE
1106: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id

Line 1110: WHEN FND_API.G_EXC_ERROR THEN

1106: CONTRACT_LINE_TEMPLATE_ID = p_contract_line_template_id
1107: ;
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 1156: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

1152: x_msg_data OUT VARCHAR2,
1153: p_contractltmpl_val_rec IN ContractLTmpl_Val_Rec_Type := G_MISS_CONTRACTLTMPL_VAL_REC) IS
1154: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1155: l_api_version CONSTANT NUMBER := 1;
1156: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1157: l_contractltmpl_rec ContractLTmpl_Rec_Type;
1158: l_def_contractltmpl_rec ContractLTmpl_Rec_Type;
1159: BEGIN
1160: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1163: p_api_version,
1164: p_init_msg_list,
1165: '_Pvt',
1166: x_return_status);
1167: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;

Line 1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1164: p_init_msg_list,
1165: '_Pvt',
1166: x_return_status);
1167: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);

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

1165: '_Pvt',
1166: x_return_status);
1167: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);
1173: --- Validate all non-missing attributes (Item Level Validation)

Line 1170: RAISE FND_API.G_EXC_ERROR;

1166: x_return_status);
1167: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1169: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);
1173: --- Validate all non-missing attributes (Item Level Validation)
1174: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1174: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1170: RAISE FND_API.G_EXC_ERROR;
1171: END IF;
1172: migrate(p_contractltmpl_val_rec, l_contractltmpl_rec);
1173: --- Validate all non-missing attributes (Item Level Validation)
1174: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1175: l_return_status := Validate_Item_Attributes
1176: (
1177: l_contractltmpl_rec ---- IN
1178: );

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

1176: (
1177: l_contractltmpl_rec ---- IN
1178: );
1179: --- If any errors happen abort API
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1177: l_contractltmpl_rec ---- IN
1178: );
1179: --- If any errors happen abort API
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: END IF;

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

1178: );
1179: --- If any errors happen abort API
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: END IF;
1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1183: RAISE FND_API.G_EXC_ERROR;

1179: --- If any errors happen abort API
1180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: END IF;
1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);

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

1182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR;
1184: END IF;
1185: END IF;
1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
1188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1184: END IF;
1185: END IF;
1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
1188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;

Line 1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1185: END IF;
1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
1188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: END IF;

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

1186: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
1188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: END IF;
1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1191: RAISE FND_API.G_EXC_ERROR;

1187: l_return_status := Validate_Item_Record(l_def_contractltmpl_rec);
1188: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1189: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1190: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1191: RAISE FND_API.G_EXC_ERROR;
1192: END IF;
1193: END IF;
1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1195: EXCEPTION

Line 1196: WHEN FND_API.G_EXC_ERROR THEN

1192: END IF;
1193: END IF;
1194: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1195: EXCEPTION
1196: WHEN FND_API.G_EXC_ERROR THEN
1197: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1198: (
1199: l_api_name,
1200: G_PKG_NAME,

Line 1201: 'FND_API.G_RET_STS_ERROR',

1197: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1198: (
1199: l_api_name,
1200: G_PKG_NAME,
1201: 'FND_API.G_RET_STS_ERROR',
1202: x_msg_count,
1203: x_msg_data,
1204: '_Pvt'
1205: );

Line 1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1203: x_msg_data,
1204: '_Pvt'
1205: );
1206: APP_EXCEPTION.RAISE_EXCEPTION;
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1209: (
1210: l_api_name,
1211: G_PKG_NAME,

Line 1212: 'FND_API.G_RET_STS_UNEXP_ERROR',

1208: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1209: (
1210: l_api_name,
1211: G_PKG_NAME,
1212: 'FND_API.G_RET_STS_UNEXP_ERROR',
1213: x_msg_count,
1214: x_msg_data,
1215: '_Pvt'
1216: );

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

1270: p_context IN CS_CONTRACT_LINE_TPLTS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1271: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1272: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1273: l_api_version CONSTANT NUMBER := 1;
1274: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1275: l_contractltmpl_rec ContractLTmpl_Val_Rec_Type;
1276: BEGIN
1277: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1278: G_PKG_NAME,

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

1280: p_api_version,
1281: p_init_msg_list,
1282: '_Pvt',
1283: x_return_status);
1284: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;

Line 1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1281: p_init_msg_list,
1282: '_Pvt',
1283: x_return_status);
1284: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;

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

1282: '_Pvt',
1283: x_return_status);
1284: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;
1290: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;

Line 1287: RAISE FND_API.G_EXC_ERROR;

1283: x_return_status);
1284: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1285: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1286: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1287: RAISE FND_API.G_EXC_ERROR;
1288: END IF;
1289: l_contractltmpl_rec.CONTRACT_LINE_TEMPLATE_ID := p_contract_line_template_id;
1290: l_contractltmpl_rec.CONTRACT_TEMPLATE_ID := p_contract_template_id;
1291: l_contractltmpl_rec.COVERAGE_ID := p_coverage_id;

Line 1334: WHEN FND_API.G_EXC_ERROR THEN

1330: l_contractltmpl_rec
1331: );
1332: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1333: EXCEPTION
1334: WHEN FND_API.G_EXC_ERROR THEN
1335: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,

Line 1339: 'FND_API.G_RET_STS_ERROR',

1335: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1336: (
1337: l_api_name,
1338: G_PKG_NAME,
1339: 'FND_API.G_RET_STS_ERROR',
1340: x_msg_count,
1341: x_msg_data,
1342: '_Pvt'
1343: );

Line 1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1341: x_msg_data,
1342: '_Pvt'
1343: );
1344: APP_EXCEPTION.RAISE_EXCEPTION;
1345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1346: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1347: (
1348: l_api_name,
1349: G_PKG_NAME,

Line 1350: 'FND_API.G_RET_STS_UNEXP_ERROR',

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