APPS.CS_SERVICETRAN_PVT dependencies on FND_API

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

18: p_servicetran_rec IN ServiceTran_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_servicetran_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
25: p_servicetran_rec.last_update_date IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 38: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 43: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 48: l_return_status := FND_API.G_RET_STS_ERROR;

44: ELSIF p_servicetran_rec.cp_service_id = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_servicetran_rec.cp_service_id IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cp_service_id');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_servicetran_rec.transaction_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
50: p_servicetran_rec.transaction_type_code IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_code');

Line 53: l_return_status := FND_API.G_RET_STS_ERROR;

49: ELSIF p_servicetran_rec.transaction_type_code = TAPI_DEV_KIT.G_MISS_CHAR OR
50: p_servicetran_rec.transaction_type_code IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_code');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_servicetran_rec.resulting_status_code = TAPI_DEV_KIT.G_MISS_CHAR OR
55: p_servicetran_rec.resulting_status_code IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'resulting_status_code');

Line 58: l_return_status := FND_API.G_RET_STS_ERROR;

54: ELSIF p_servicetran_rec.resulting_status_code = TAPI_DEV_KIT.G_MISS_CHAR OR
55: p_servicetran_rec.resulting_status_code IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'resulting_status_code');
58: l_return_status := FND_API.G_RET_STS_ERROR;
59: END IF;
60: RETURN(l_return_status);
61: END Validate_Item_Attributes;
62:

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

68: l_def_servicetran_rec OUT ServiceTran_Rec_Type
69: )
70: RETURN VARCHAR2
71: IS
72: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
73: BEGIN
74: l_def_servicetran_rec := p_servicetran_rec;
75: RETURN(l_return_status);
76: End Default_Item_attributes;

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

79: FUNCTION Validate_Item_Record (
80: p_servicetran_rec IN ServiceTran_Rec_Type
81: )
82: RETURN VARCHAR2 IS
83: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
84: FUNCTION validate_foreign_keys (
85: p_servicetran_rec IN ServiceTran_Rec_Type
86: )
87: RETURN VARCHAR2 IS

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

90: SELECT *
91: FROM Cs_Cp_Services_All
92: WHERE cs_cp_services_all.cp_service_id = p_cp_service_id;
93: l_cs_cp_services_all_pk cs_cp_services_all_pk_csr%ROWTYPE;
94: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
95: l_row_notfound BOOLEAN := TRUE;
96: BEGIN
97: IF (p_servicetran_rec.CP_SERVICE_ID IS NOT NULL)
98: THEN

Line 111: l_return_status := FND_API.G_RET_STS_ERROR;

107: END IF;
108: RETURN (l_return_status);
109: EXCEPTION
110: WHEN item_not_found_error THEN
111: l_return_status := FND_API.G_RET_STS_ERROR;
112: RETURN (l_return_status);
113: END validate_foreign_keys;
114: BEGIN
115: l_return_status := validate_foreign_keys (p_servicetran_rec);

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

285: p_servicetran_rec IN ServiceTran_Rec_Type := G_MISS_SERVICETRAN_REC,
286: x_cp_service_transaction_id OUT NUMBER) IS
287: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
288: l_api_version CONSTANT NUMBER := 1;
289: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
290: l_servicetran_rec ServiceTran_Rec_Type;
291: l_def_servicetran_rec ServiceTran_Rec_Type;
292: BEGIN
293: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

296: p_api_version,
297: p_init_msg_list,
298: '_Pvt',
299: x_return_status);
300: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;

Line 301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

297: p_init_msg_list,
298: '_Pvt',
299: x_return_status);
300: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: l_servicetran_rec := p_servicetran_rec;

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

298: '_Pvt',
299: x_return_status);
300: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: l_servicetran_rec := p_servicetran_rec;
306: --- Validate all non-missing attributes (Item Level Validation)

Line 303: RAISE FND_API.G_EXC_ERROR;

299: x_return_status);
300: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
301: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
302: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: l_servicetran_rec := p_servicetran_rec;
306: --- Validate all non-missing attributes (Item Level Validation)
307: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 307: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: l_servicetran_rec := p_servicetran_rec;
306: --- Validate all non-missing attributes (Item Level Validation)
307: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
308: l_return_status := Validate_Item_Attributes
309: (
310: l_servicetran_rec ---- IN
311: );

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

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

Line 314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

311: );
312: --- If any errors happen abort API
313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318: END IF;
319: --- Defaulting item attributes

Line 316: RAISE FND_API.G_EXC_ERROR;

312: --- If any errors happen abort API
313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
314: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
315: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
316: RAISE FND_API.G_EXC_ERROR;
317: END IF;
318: END IF;
319: --- Defaulting item attributes
320: l_return_status := Default_Item_Attributes

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

322: l_servicetran_rec, ---- IN
323: l_def_servicetran_rec
324: );
325: --- If any errors happen abort API
326: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

323: l_def_servicetran_rec
324: );
325: --- If any errors happen abort API
326: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

324: );
325: --- If any errors happen abort API
326: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);

Line 329: RAISE FND_API.G_EXC_ERROR;

325: --- If any errors happen abort API
326: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
328: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;

Line 334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

330: END IF;
331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: END IF;

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

331: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: END IF;
339: -- Set primary key value

Line 336: RAISE FND_API.G_EXC_ERROR;

332: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
333: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
335: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
336: RAISE FND_API.G_EXC_ERROR;
337: END IF;
338: END IF;
339: -- Set primary key value
340: l_def_servicetran_rec.cp_service_transaction_id := get_seq_id;

Line 491: WHEN FND_API.G_EXC_ERROR THEN

487: -- Set OUT values
488: x_cp_service_transaction_id := l_def_servicetran_rec.cp_service_transaction_id;
489: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
490: EXCEPTION
491: WHEN FND_API.G_EXC_ERROR THEN
492: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
493: (
494: l_api_name,
495: G_PKG_NAME,

Line 496: 'FND_API.G_RET_STS_ERROR',

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

Line 502: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 507: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

604: p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := NULL,
605: x_cp_service_transaction_id OUT NUMBER) IS
606: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
607: l_api_version CONSTANT NUMBER := 1;
608: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
609: l_servicetran_rec ServiceTran_Rec_Type;
610: BEGIN
611: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
612: G_PKG_NAME,

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

614: p_api_version,
615: p_init_msg_list,
616: '_Pvt',
617: x_return_status);
618: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;

Line 619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

615: p_init_msg_list,
616: '_Pvt',
617: x_return_status);
618: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

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

616: '_Pvt',
617: x_return_status);
618: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;
624: l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line 621: RAISE FND_API.G_EXC_ERROR;

617: x_return_status);
618: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
620: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
621: RAISE FND_API.G_EXC_ERROR;
622: END IF;
623: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;
624: l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;
625: l_servicetran_rec.CREATION_DATE := p_creation_date;

Line 707: WHEN FND_API.G_EXC_ERROR THEN

703: x_cp_service_transaction_id
704: );
705: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
709: (
710: l_api_name,
711: G_PKG_NAME,

Line 712: 'FND_API.G_RET_STS_ERROR',

708: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
709: (
710: l_api_name,
711: G_PKG_NAME,
712: 'FND_API.G_RET_STS_ERROR',
713: x_msg_count,
714: x_msg_data,
715: '_Pvt'
716: );

Line 718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

714: x_msg_data,
715: '_Pvt'
716: );
717: APP_EXCEPTION.RAISE_EXCEPTION;
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
720: (
721: l_api_name,
722: G_PKG_NAME,

Line 723: 'FND_API.G_RET_STS_UNEXP_ERROR',

719: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
720: (
721: l_api_name,
722: G_PKG_NAME,
723: 'FND_API.G_RET_STS_UNEXP_ERROR',
724: x_msg_count,
725: x_msg_data,
726: '_Pvt'
727: );

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

829: FOR UPDATE NOWAIT;
830:
831: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
832: l_api_version CONSTANT NUMBER := 1;
833: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
834: l_object_version_number lock_csr%ROWTYPE;
835: l_row_notfound BOOLEAN := FALSE;
836: lc_row_notfound BOOLEAN := FALSE;
837: BEGIN

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

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

Line 846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

842: p_init_msg_list,
843: '_Pvt',
844: x_return_status);
845: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: BEGIN

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

843: '_Pvt',
844: x_return_status);
845: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: BEGIN
851: OPEN lock_csr;

Line 848: RAISE FND_API.G_EXC_ERROR;

844: x_return_status);
845: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
846: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
847: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
848: RAISE FND_API.G_EXC_ERROR;
849: END IF;
850: BEGIN
851: OPEN lock_csr;
852: FETCH lock_csr INTO l_object_version_number;

Line 866: RAISE FND_API.G_EXC_ERROR;

862: END;
863:
864: IF ( l_row_notfound ) THEN
865: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
866: RAISE FND_API.G_EXC_ERROR;
867: ELSE
868: IF (l_object_version_number.CP_SERVICE_TRANSACTION_ID <> p_cp_service_transaction_id) THEN
869: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
870: RAISE FND_API.G_EXC_ERROR;

Line 870: RAISE FND_API.G_EXC_ERROR;

866: RAISE FND_API.G_EXC_ERROR;
867: ELSE
868: IF (l_object_version_number.CP_SERVICE_TRANSACTION_ID <> p_cp_service_transaction_id) THEN
869: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872: IF (l_object_version_number.LAST_UPDATE_DATE <> p_last_update_date) THEN
873: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
874: RAISE FND_API.G_EXC_ERROR;

Line 874: RAISE FND_API.G_EXC_ERROR;

870: RAISE FND_API.G_EXC_ERROR;
871: END IF;
872: IF (l_object_version_number.LAST_UPDATE_DATE <> p_last_update_date) THEN
873: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: IF (l_object_version_number.LAST_UPDATED_BY <> p_last_updated_by) THEN
877: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
878: RAISE FND_API.G_EXC_ERROR;

Line 878: RAISE FND_API.G_EXC_ERROR;

874: RAISE FND_API.G_EXC_ERROR;
875: END IF;
876: IF (l_object_version_number.LAST_UPDATED_BY <> p_last_updated_by) THEN
877: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880: IF (l_object_version_number.CREATION_DATE <> p_creation_date) THEN
881: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
882: RAISE FND_API.G_EXC_ERROR;

Line 882: RAISE FND_API.G_EXC_ERROR;

878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880: IF (l_object_version_number.CREATION_DATE <> p_creation_date) THEN
881: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884: IF (l_object_version_number.CREATED_BY <> p_created_by) THEN
885: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
886: RAISE FND_API.G_EXC_ERROR;

Line 886: RAISE FND_API.G_EXC_ERROR;

882: RAISE FND_API.G_EXC_ERROR;
883: END IF;
884: IF (l_object_version_number.CREATED_BY <> p_created_by) THEN
885: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: IF (l_object_version_number.LAST_UPDATE_LOGIN <> p_last_update_login) THEN
889: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
890: RAISE FND_API.G_EXC_ERROR;

Line 890: RAISE FND_API.G_EXC_ERROR;

886: RAISE FND_API.G_EXC_ERROR;
887: END IF;
888: IF (l_object_version_number.LAST_UPDATE_LOGIN <> p_last_update_login) THEN
889: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892: IF (l_object_version_number.CP_SERVICE_ID <> p_cp_service_id) THEN
893: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
894: RAISE FND_API.G_EXC_ERROR;

Line 894: RAISE FND_API.G_EXC_ERROR;

890: RAISE FND_API.G_EXC_ERROR;
891: END IF;
892: IF (l_object_version_number.CP_SERVICE_ID <> p_cp_service_id) THEN
893: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896: IF (l_object_version_number.TRANSACTION_TYPE_CODE <> p_transaction_type_code) THEN
897: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
898: RAISE FND_API.G_EXC_ERROR;

Line 898: RAISE FND_API.G_EXC_ERROR;

894: RAISE FND_API.G_EXC_ERROR;
895: END IF;
896: IF (l_object_version_number.TRANSACTION_TYPE_CODE <> p_transaction_type_code) THEN
897: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900: IF (l_object_version_number.RESULTING_STATUS_CODE <> p_resulting_status_code) THEN
901: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
902: RAISE FND_API.G_EXC_ERROR;

Line 902: RAISE FND_API.G_EXC_ERROR;

898: RAISE FND_API.G_EXC_ERROR;
899: END IF;
900: IF (l_object_version_number.RESULTING_STATUS_CODE <> p_resulting_status_code) THEN
901: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904: IF (l_object_version_number.EFFECTIVE_START_DATE <> p_effective_start_date) THEN
905: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
906: RAISE FND_API.G_EXC_ERROR;

Line 906: RAISE FND_API.G_EXC_ERROR;

902: RAISE FND_API.G_EXC_ERROR;
903: END IF;
904: IF (l_object_version_number.EFFECTIVE_START_DATE <> p_effective_start_date) THEN
905: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908: IF (l_object_version_number.EFFECTIVE_END_DATE <> p_effective_end_date) THEN
909: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
910: RAISE FND_API.G_EXC_ERROR;

Line 910: RAISE FND_API.G_EXC_ERROR;

906: RAISE FND_API.G_EXC_ERROR;
907: END IF;
908: IF (l_object_version_number.EFFECTIVE_END_DATE <> p_effective_end_date) THEN
909: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: IF (l_object_version_number.CURRENT_END_DATE <> p_current_end_date) THEN
913: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
914: RAISE FND_API.G_EXC_ERROR;

Line 914: RAISE FND_API.G_EXC_ERROR;

910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912: IF (l_object_version_number.CURRENT_END_DATE <> p_current_end_date) THEN
913: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916: IF (l_object_version_number.TERMINATED_TRANSACTION_ID <> p_terminated_transaction_id) THEN
917: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
918: RAISE FND_API.G_EXC_ERROR;

Line 918: RAISE FND_API.G_EXC_ERROR;

914: RAISE FND_API.G_EXC_ERROR;
915: END IF;
916: IF (l_object_version_number.TERMINATED_TRANSACTION_ID <> p_terminated_transaction_id) THEN
917: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (l_object_version_number.REASON_CODE <> p_reason_code) THEN
921: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
922: RAISE FND_API.G_EXC_ERROR;

Line 922: RAISE FND_API.G_EXC_ERROR;

918: RAISE FND_API.G_EXC_ERROR;
919: END IF;
920: IF (l_object_version_number.REASON_CODE <> p_reason_code) THEN
921: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: IF (l_object_version_number.REASON_COMMENTS <> p_reason_comments) THEN
925: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
926: RAISE FND_API.G_EXC_ERROR;

Line 926: RAISE FND_API.G_EXC_ERROR;

922: RAISE FND_API.G_EXC_ERROR;
923: END IF;
924: IF (l_object_version_number.REASON_COMMENTS <> p_reason_comments) THEN
925: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928: IF (l_object_version_number.SERVICE_SELLING_PRICE <> p_service_selling_price) THEN
929: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
930: RAISE FND_API.G_EXC_ERROR;

Line 930: RAISE FND_API.G_EXC_ERROR;

926: RAISE FND_API.G_EXC_ERROR;
927: END IF;
928: IF (l_object_version_number.SERVICE_SELLING_PRICE <> p_service_selling_price) THEN
929: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: IF (l_object_version_number.CURRENCY_CODE <> p_currency_code) THEN
933: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
934: RAISE FND_API.G_EXC_ERROR;

Line 934: RAISE FND_API.G_EXC_ERROR;

930: RAISE FND_API.G_EXC_ERROR;
931: END IF;
932: IF (l_object_version_number.CURRENCY_CODE <> p_currency_code) THEN
933: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: IF (l_object_version_number.CONVERSION_TYPE <> p_conversion_type) THEN
937: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
938: RAISE FND_API.G_EXC_ERROR;

Line 938: RAISE FND_API.G_EXC_ERROR;

934: RAISE FND_API.G_EXC_ERROR;
935: END IF;
936: IF (l_object_version_number.CONVERSION_TYPE <> p_conversion_type) THEN
937: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: IF (l_object_version_number.CONVERSION_RATE <> p_conversion_rate) THEN
941: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
942: RAISE FND_API.G_EXC_ERROR;

Line 942: RAISE FND_API.G_EXC_ERROR;

938: RAISE FND_API.G_EXC_ERROR;
939: END IF;
940: IF (l_object_version_number.CONVERSION_RATE <> p_conversion_rate) THEN
941: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944: IF (l_object_version_number.CONVERSION_DATE <> p_conversion_date) THEN
945: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
946: RAISE FND_API.G_EXC_ERROR;

Line 946: RAISE FND_API.G_EXC_ERROR;

942: RAISE FND_API.G_EXC_ERROR;
943: END IF;
944: IF (l_object_version_number.CONVERSION_DATE <> p_conversion_date) THEN
945: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: IF (l_object_version_number.INVOICING_RULE_ID <> p_invoicing_rule_id) THEN
949: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
950: RAISE FND_API.G_EXC_ERROR;

Line 950: RAISE FND_API.G_EXC_ERROR;

946: RAISE FND_API.G_EXC_ERROR;
947: END IF;
948: IF (l_object_version_number.INVOICING_RULE_ID <> p_invoicing_rule_id) THEN
949: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: IF (l_object_version_number.ACCOUNTING_RULE_ID <> p_accounting_rule_id) THEN
953: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
954: RAISE FND_API.G_EXC_ERROR;

Line 954: RAISE FND_API.G_EXC_ERROR;

950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: IF (l_object_version_number.ACCOUNTING_RULE_ID <> p_accounting_rule_id) THEN
953: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956: IF (l_object_version_number.PAYMENT_TERMS_ID <> p_payment_terms_id) THEN
957: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
958: RAISE FND_API.G_EXC_ERROR;

Line 958: RAISE FND_API.G_EXC_ERROR;

954: RAISE FND_API.G_EXC_ERROR;
955: END IF;
956: IF (l_object_version_number.PAYMENT_TERMS_ID <> p_payment_terms_id) THEN
957: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (l_object_version_number.SERVICE_ORDER_LINE_ID <> p_service_order_line_id) THEN
961: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
962: RAISE FND_API.G_EXC_ERROR;

Line 962: RAISE FND_API.G_EXC_ERROR;

958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960: IF (l_object_version_number.SERVICE_ORDER_LINE_ID <> p_service_order_line_id) THEN
961: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: IF (l_object_version_number.SERVICE_ORDER_NUMBER <> p_service_order_number) THEN
965: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
966: RAISE FND_API.G_EXC_ERROR;

Line 966: RAISE FND_API.G_EXC_ERROR;

962: RAISE FND_API.G_EXC_ERROR;
963: END IF;
964: IF (l_object_version_number.SERVICE_ORDER_NUMBER <> p_service_order_number) THEN
965: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968: IF (l_object_version_number.SERVICE_ORDER_DATE <> p_service_order_date) THEN
969: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
970: RAISE FND_API.G_EXC_ERROR;

Line 970: RAISE FND_API.G_EXC_ERROR;

966: RAISE FND_API.G_EXC_ERROR;
967: END IF;
968: IF (l_object_version_number.SERVICE_ORDER_DATE <> p_service_order_date) THEN
969: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972: IF (l_object_version_number.SERVICE_ORDER_TYPE <> p_service_order_type) THEN
973: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
974: RAISE FND_API.G_EXC_ERROR;

Line 974: RAISE FND_API.G_EXC_ERROR;

970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972: IF (l_object_version_number.SERVICE_ORDER_TYPE <> p_service_order_type) THEN
973: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: IF (l_object_version_number.INVOICE_FLAG <> p_invoice_flag) THEN
977: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
978: RAISE FND_API.G_EXC_ERROR;

Line 978: RAISE FND_API.G_EXC_ERROR;

974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976: IF (l_object_version_number.INVOICE_FLAG <> p_invoice_flag) THEN
977: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: IF (l_object_version_number.COVERAGE_SCHEDULE_ID <> p_coverage_schedule_id) THEN
981: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
982: RAISE FND_API.G_EXC_ERROR;

Line 982: RAISE FND_API.G_EXC_ERROR;

978: RAISE FND_API.G_EXC_ERROR;
979: END IF;
980: IF (l_object_version_number.COVERAGE_SCHEDULE_ID <> p_coverage_schedule_id) THEN
981: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF (l_object_version_number.DURATION_QUANTITY <> p_duration_quantity) THEN
985: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
986: RAISE FND_API.G_EXC_ERROR;

Line 986: RAISE FND_API.G_EXC_ERROR;

982: RAISE FND_API.G_EXC_ERROR;
983: END IF;
984: IF (l_object_version_number.DURATION_QUANTITY <> p_duration_quantity) THEN
985: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: IF (l_object_version_number.UNIT_OF_MEASURE_CODE <> p_unit_of_measure_code) THEN
989: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
990: RAISE FND_API.G_EXC_ERROR;

Line 990: RAISE FND_API.G_EXC_ERROR;

986: RAISE FND_API.G_EXC_ERROR;
987: END IF;
988: IF (l_object_version_number.UNIT_OF_MEASURE_CODE <> p_unit_of_measure_code) THEN
989: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: IF (l_object_version_number.STARTING_DELAY <> p_starting_delay) THEN
993: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
994: RAISE FND_API.G_EXC_ERROR;

Line 994: RAISE FND_API.G_EXC_ERROR;

990: RAISE FND_API.G_EXC_ERROR;
991: END IF;
992: IF (l_object_version_number.STARTING_DELAY <> p_starting_delay) THEN
993: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF (l_object_version_number.BILL_TO_SITE_USE_ID <> p_bill_to_site_use_id) THEN
997: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
998: RAISE FND_API.G_EXC_ERROR;

Line 998: RAISE FND_API.G_EXC_ERROR;

994: RAISE FND_API.G_EXC_ERROR;
995: END IF;
996: IF (l_object_version_number.BILL_TO_SITE_USE_ID <> p_bill_to_site_use_id) THEN
997: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: IF (l_object_version_number.BILL_TO_CONTACT_ID <> p_bill_to_contact_id) THEN
1001: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1002: RAISE FND_API.G_EXC_ERROR;

Line 1002: RAISE FND_API.G_EXC_ERROR;

998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: IF (l_object_version_number.BILL_TO_CONTACT_ID <> p_bill_to_contact_id) THEN
1001: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: IF (l_object_version_number.PRORATE_FLAG <> p_prorate_flag) THEN
1005: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1006: RAISE FND_API.G_EXC_ERROR;

Line 1006: RAISE FND_API.G_EXC_ERROR;

1002: RAISE FND_API.G_EXC_ERROR;
1003: END IF;
1004: IF (l_object_version_number.PRORATE_FLAG <> p_prorate_flag) THEN
1005: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: IF (l_object_version_number.RA_INTERFACE_STATUS <> p_ra_interface_status) THEN
1009: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1010: RAISE FND_API.G_EXC_ERROR;

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: RAISE FND_API.G_EXC_ERROR;
1007: END IF;
1008: IF (l_object_version_number.RA_INTERFACE_STATUS <> p_ra_interface_status) THEN
1009: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF (l_object_version_number.INVOICE_COUNT <> p_invoice_count) THEN
1013: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1014: RAISE FND_API.G_EXC_ERROR;

Line 1014: RAISE FND_API.G_EXC_ERROR;

1010: RAISE FND_API.G_EXC_ERROR;
1011: END IF;
1012: IF (l_object_version_number.INVOICE_COUNT <> p_invoice_count) THEN
1013: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016: IF (l_object_version_number.PRICE_LIST_ID <> p_price_list_id) THEN
1017: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1018: RAISE FND_API.G_EXC_ERROR;

Line 1018: RAISE FND_API.G_EXC_ERROR;

1014: RAISE FND_API.G_EXC_ERROR;
1015: END IF;
1016: IF (l_object_version_number.PRICE_LIST_ID <> p_price_list_id) THEN
1017: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020: IF (l_object_version_number.ATTRIBUTE1 <> p_attribute1) THEN
1021: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1022: RAISE FND_API.G_EXC_ERROR;

Line 1022: RAISE FND_API.G_EXC_ERROR;

1018: RAISE FND_API.G_EXC_ERROR;
1019: END IF;
1020: IF (l_object_version_number.ATTRIBUTE1 <> p_attribute1) THEN
1021: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024: IF (l_object_version_number.ATTRIBUTE2 <> p_attribute2) THEN
1025: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1026: RAISE FND_API.G_EXC_ERROR;

Line 1026: RAISE FND_API.G_EXC_ERROR;

1022: RAISE FND_API.G_EXC_ERROR;
1023: END IF;
1024: IF (l_object_version_number.ATTRIBUTE2 <> p_attribute2) THEN
1025: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: IF (l_object_version_number.ATTRIBUTE3 <> p_attribute3) THEN
1029: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1030: RAISE FND_API.G_EXC_ERROR;

Line 1030: RAISE FND_API.G_EXC_ERROR;

1026: RAISE FND_API.G_EXC_ERROR;
1027: END IF;
1028: IF (l_object_version_number.ATTRIBUTE3 <> p_attribute3) THEN
1029: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032: IF (l_object_version_number.ATTRIBUTE4 <> p_attribute4) THEN
1033: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1034: RAISE FND_API.G_EXC_ERROR;

Line 1034: RAISE FND_API.G_EXC_ERROR;

1030: RAISE FND_API.G_EXC_ERROR;
1031: END IF;
1032: IF (l_object_version_number.ATTRIBUTE4 <> p_attribute4) THEN
1033: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036: IF (l_object_version_number.ATTRIBUTE5 <> p_attribute5) THEN
1037: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1038: RAISE FND_API.G_EXC_ERROR;

Line 1038: RAISE FND_API.G_EXC_ERROR;

1034: RAISE FND_API.G_EXC_ERROR;
1035: END IF;
1036: IF (l_object_version_number.ATTRIBUTE5 <> p_attribute5) THEN
1037: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: IF (l_object_version_number.ATTRIBUTE6 <> p_attribute6) THEN
1041: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1042: RAISE FND_API.G_EXC_ERROR;

Line 1042: RAISE FND_API.G_EXC_ERROR;

1038: RAISE FND_API.G_EXC_ERROR;
1039: END IF;
1040: IF (l_object_version_number.ATTRIBUTE6 <> p_attribute6) THEN
1041: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044: IF (l_object_version_number.ATTRIBUTE7 <> p_attribute7) THEN
1045: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1046: RAISE FND_API.G_EXC_ERROR;

Line 1046: RAISE FND_API.G_EXC_ERROR;

1042: RAISE FND_API.G_EXC_ERROR;
1043: END IF;
1044: IF (l_object_version_number.ATTRIBUTE7 <> p_attribute7) THEN
1045: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: IF (l_object_version_number.ATTRIBUTE8 <> p_attribute8) THEN
1049: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1050: RAISE FND_API.G_EXC_ERROR;

Line 1050: RAISE FND_API.G_EXC_ERROR;

1046: RAISE FND_API.G_EXC_ERROR;
1047: END IF;
1048: IF (l_object_version_number.ATTRIBUTE8 <> p_attribute8) THEN
1049: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: IF (l_object_version_number.ATTRIBUTE9 <> p_attribute9) THEN
1053: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE FND_API.G_EXC_ERROR;

Line 1054: RAISE FND_API.G_EXC_ERROR;

1050: RAISE FND_API.G_EXC_ERROR;
1051: END IF;
1052: IF (l_object_version_number.ATTRIBUTE9 <> p_attribute9) THEN
1053: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056: IF (l_object_version_number.ATTRIBUTE10 <> p_attribute10) THEN
1057: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1058: RAISE FND_API.G_EXC_ERROR;

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: RAISE FND_API.G_EXC_ERROR;
1055: END IF;
1056: IF (l_object_version_number.ATTRIBUTE10 <> p_attribute10) THEN
1057: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060: IF (l_object_version_number.ATTRIBUTE11 <> p_attribute11) THEN
1061: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1062: RAISE FND_API.G_EXC_ERROR;

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058: RAISE FND_API.G_EXC_ERROR;
1059: END IF;
1060: IF (l_object_version_number.ATTRIBUTE11 <> p_attribute11) THEN
1061: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064: IF (l_object_version_number.ATTRIBUTE12 <> p_attribute12) THEN
1065: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1066: RAISE FND_API.G_EXC_ERROR;

Line 1066: RAISE FND_API.G_EXC_ERROR;

1062: RAISE FND_API.G_EXC_ERROR;
1063: END IF;
1064: IF (l_object_version_number.ATTRIBUTE12 <> p_attribute12) THEN
1065: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: IF (l_object_version_number.ATTRIBUTE13 <> p_attribute13) THEN
1069: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1070: RAISE FND_API.G_EXC_ERROR;

Line 1070: RAISE FND_API.G_EXC_ERROR;

1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: IF (l_object_version_number.ATTRIBUTE13 <> p_attribute13) THEN
1069: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: IF (l_object_version_number.ATTRIBUTE14 <> p_attribute14) THEN
1073: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1074: RAISE FND_API.G_EXC_ERROR;

Line 1074: RAISE FND_API.G_EXC_ERROR;

1070: RAISE FND_API.G_EXC_ERROR;
1071: END IF;
1072: IF (l_object_version_number.ATTRIBUTE14 <> p_attribute14) THEN
1073: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076: IF (l_object_version_number.ATTRIBUTE15 <> p_attribute15) THEN
1077: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1078: RAISE FND_API.G_EXC_ERROR;

Line 1078: RAISE FND_API.G_EXC_ERROR;

1074: RAISE FND_API.G_EXC_ERROR;
1075: END IF;
1076: IF (l_object_version_number.ATTRIBUTE15 <> p_attribute15) THEN
1077: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080: IF (l_object_version_number.CONTEXT <> p_context) THEN
1081: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1082: RAISE FND_API.G_EXC_ERROR;

Line 1082: RAISE FND_API.G_EXC_ERROR;

1078: RAISE FND_API.G_EXC_ERROR;
1079: END IF;
1080: IF (l_object_version_number.CONTEXT <> p_context) THEN
1081: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: IF (l_object_version_number.PRICING_ATTRIBUTE1 <> p_pricing_attribute1) THEN
1085: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1086: RAISE FND_API.G_EXC_ERROR;

Line 1086: RAISE FND_API.G_EXC_ERROR;

1082: RAISE FND_API.G_EXC_ERROR;
1083: END IF;
1084: IF (l_object_version_number.PRICING_ATTRIBUTE1 <> p_pricing_attribute1) THEN
1085: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088: IF (l_object_version_number.PRICING_ATTRIBUTE2 <> p_pricing_attribute2) THEN
1089: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE FND_API.G_EXC_ERROR;

Line 1090: RAISE FND_API.G_EXC_ERROR;

1086: RAISE FND_API.G_EXC_ERROR;
1087: END IF;
1088: IF (l_object_version_number.PRICING_ATTRIBUTE2 <> p_pricing_attribute2) THEN
1089: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092: IF (l_object_version_number.PRICING_ATTRIBUTE3 <> p_pricing_attribute3) THEN
1093: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1094: RAISE FND_API.G_EXC_ERROR;

Line 1094: RAISE FND_API.G_EXC_ERROR;

1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092: IF (l_object_version_number.PRICING_ATTRIBUTE3 <> p_pricing_attribute3) THEN
1093: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1094: RAISE FND_API.G_EXC_ERROR;
1095: END IF;
1096: IF (l_object_version_number.PRICING_ATTRIBUTE4 <> p_pricing_attribute4) THEN
1097: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1098: RAISE FND_API.G_EXC_ERROR;

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: RAISE FND_API.G_EXC_ERROR;
1095: END IF;
1096: IF (l_object_version_number.PRICING_ATTRIBUTE4 <> p_pricing_attribute4) THEN
1097: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: IF (l_object_version_number.PRICING_ATTRIBUTE5 <> p_pricing_attribute5) THEN
1101: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1102: RAISE FND_API.G_EXC_ERROR;

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: IF (l_object_version_number.PRICING_ATTRIBUTE5 <> p_pricing_attribute5) THEN
1101: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: IF (l_object_version_number.PRICING_ATTRIBUTE6 <> p_pricing_attribute6) THEN
1105: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE FND_API.G_EXC_ERROR;

Line 1106: RAISE FND_API.G_EXC_ERROR;

1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104: IF (l_object_version_number.PRICING_ATTRIBUTE6 <> p_pricing_attribute6) THEN
1105: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: IF (l_object_version_number.PRICING_ATTRIBUTE7 <> p_pricing_attribute7) THEN
1109: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1110: RAISE FND_API.G_EXC_ERROR;

Line 1110: RAISE FND_API.G_EXC_ERROR;

1106: RAISE FND_API.G_EXC_ERROR;
1107: END IF;
1108: IF (l_object_version_number.PRICING_ATTRIBUTE7 <> p_pricing_attribute7) THEN
1109: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: IF (l_object_version_number.PRICING_ATTRIBUTE8 <> p_pricing_attribute8) THEN
1113: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1114: RAISE FND_API.G_EXC_ERROR;

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: RAISE FND_API.G_EXC_ERROR;
1111: END IF;
1112: IF (l_object_version_number.PRICING_ATTRIBUTE8 <> p_pricing_attribute8) THEN
1113: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: IF (l_object_version_number.PRICING_ATTRIBUTE9 <> p_pricing_attribute9) THEN
1117: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE FND_API.G_EXC_ERROR;

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: RAISE FND_API.G_EXC_ERROR;
1115: END IF;
1116: IF (l_object_version_number.PRICING_ATTRIBUTE9 <> p_pricing_attribute9) THEN
1117: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: IF (l_object_version_number.PRICING_ATTRIBUTE10 <> p_pricing_attribute10) THEN
1121: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1122: RAISE FND_API.G_EXC_ERROR;

Line 1122: RAISE FND_API.G_EXC_ERROR;

1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: IF (l_object_version_number.PRICING_ATTRIBUTE10 <> p_pricing_attribute10) THEN
1121: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: IF (l_object_version_number.PRICING_ATTRIBUTE11 <> p_pricing_attribute11) THEN
1125: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1126: RAISE FND_API.G_EXC_ERROR;

Line 1126: RAISE FND_API.G_EXC_ERROR;

1122: RAISE FND_API.G_EXC_ERROR;
1123: END IF;
1124: IF (l_object_version_number.PRICING_ATTRIBUTE11 <> p_pricing_attribute11) THEN
1125: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: IF (l_object_version_number.PRICING_ATTRIBUTE12 <> p_pricing_attribute12) THEN
1129: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE FND_API.G_EXC_ERROR;

Line 1130: RAISE FND_API.G_EXC_ERROR;

1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: IF (l_object_version_number.PRICING_ATTRIBUTE12 <> p_pricing_attribute12) THEN
1129: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132: IF (l_object_version_number.PRICING_ATTRIBUTE13 <> p_pricing_attribute13) THEN
1133: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1134: RAISE FND_API.G_EXC_ERROR;

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132: IF (l_object_version_number.PRICING_ATTRIBUTE13 <> p_pricing_attribute13) THEN
1133: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136: IF (l_object_version_number.PRICING_ATTRIBUTE14 <> p_pricing_attribute14) THEN
1137: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1138: RAISE FND_API.G_EXC_ERROR;

Line 1138: RAISE FND_API.G_EXC_ERROR;

1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136: IF (l_object_version_number.PRICING_ATTRIBUTE14 <> p_pricing_attribute14) THEN
1137: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: IF (l_object_version_number.PRICING_ATTRIBUTE15 <> p_pricing_attribute15) THEN
1141: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1142: RAISE FND_API.G_EXC_ERROR;

Line 1142: RAISE FND_API.G_EXC_ERROR;

1138: RAISE FND_API.G_EXC_ERROR;
1139: END IF;
1140: IF (l_object_version_number.PRICING_ATTRIBUTE15 <> p_pricing_attribute15) THEN
1141: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: IF (l_object_version_number.PRICING_CONTEXT <> p_pricing_context) THEN
1145: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1146: RAISE FND_API.G_EXC_ERROR;

Line 1146: RAISE FND_API.G_EXC_ERROR;

1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: IF (l_object_version_number.PRICING_CONTEXT <> p_pricing_context) THEN
1145: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148: IF (l_object_version_number.CREDIT_AMOUNT <> p_credit_amount) THEN
1149: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1150: RAISE FND_API.G_EXC_ERROR;

Line 1150: RAISE FND_API.G_EXC_ERROR;

1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148: IF (l_object_version_number.CREDIT_AMOUNT <> p_credit_amount) THEN
1149: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152: IF (l_object_version_number.PURCHASE_ORDER_NUM <> p_purchase_order_num) THEN
1153: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1154: RAISE FND_API.G_EXC_ERROR;

Line 1154: RAISE FND_API.G_EXC_ERROR;

1150: RAISE FND_API.G_EXC_ERROR;
1151: END IF;
1152: IF (l_object_version_number.PURCHASE_ORDER_NUM <> p_purchase_order_num) THEN
1153: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1154: RAISE FND_API.G_EXC_ERROR;
1155: END IF;
1156: END IF;
1157: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1158: EXCEPTION

Line 1159: WHEN FND_API.G_EXC_ERROR THEN

1155: END IF;
1156: END IF;
1157: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1158: EXCEPTION
1159: WHEN FND_API.G_EXC_ERROR THEN
1160: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1161: (
1162: l_api_name,
1163: G_PKG_NAME,

Line 1164: 'FND_API.G_RET_STS_ERROR',

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

Line 1170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1166: x_msg_data,
1167: '_Pvt'
1168: );
1169: APP_EXCEPTION.RAISE_EXCEPTION;
1170: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1171: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1172: (
1173: l_api_name,
1174: G_PKG_NAME,

Line 1175: 'FND_API.G_RET_STS_UNEXP_ERROR',

1171: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1172: (
1173: l_api_name,
1174: G_PKG_NAME,
1175: 'FND_API.G_RET_STS_UNEXP_ERROR',
1176: x_msg_count,
1177: x_msg_data,
1178: '_Pvt'
1179: );

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

1201: x_msg_data OUT VARCHAR2,
1202: p_servicetran_val_rec IN ServiceTran_Val_Rec_Type := G_MISS_SERVICETRAN_VAL_REC) IS
1203: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1204: l_api_version CONSTANT NUMBER := 1;
1205: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1206: l_servicetran_rec ServiceTran_Rec_Type;
1207: l_def_servicetran_rec ServiceTran_Rec_Type;
1208: FUNCTION populate_new_record (
1209: p_servicetran_rec IN ServiceTran_Rec_Type,

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

1214: FROM Cs_Cp_Service_Transactions
1215: WHERE cs_cp_service_transactions.cp_service_transaction_id = p_cp_service_transaction_id;
1216: l_cs_cp_service_transa1 cs_cp_service_transa1_csr%ROWTYPE;
1217: l_row_notfound BOOLEAN := TRUE;
1218: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1219: BEGIN
1220: x_servicetran_rec := p_servicetran_rec;
1221: -- Get current database values
1222: OPEN cs_cp_service_transa1_csr (p_servicetran_rec.cp_service_transaction_id);

Line 1227: l_return_status := FND_API.G_RET_STS_ERROR;

1223: FETCH cs_cp_service_transa1_csr INTO l_cs_cp_service_transa1;
1224: l_row_notfound := cs_cp_service_transa1_csr%NOTFOUND;
1225: CLOSE cs_cp_service_transa1_csr;
1226: IF (l_row_notfound) THEN
1227: l_return_status := FND_API.G_RET_STS_ERROR;
1228: END IF;
1229: IF (x_servicetran_rec.cp_service_transaction_id = TAPI_DEV_KIT.G_MISS_NUM)
1230: THEN
1231: x_servicetran_rec.cp_service_transaction_id := l_cs_cp_service_transa1.cp_service_transaction_id;

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

1523: p_api_version,
1524: p_init_msg_list,
1525: '_Pvt',
1526: x_return_status);
1527: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;

Line 1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1524: p_init_msg_list,
1525: '_Pvt',
1526: x_return_status);
1527: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: migrate(p_servicetran_val_rec, l_servicetran_rec);

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

1525: '_Pvt',
1526: x_return_status);
1527: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: migrate(p_servicetran_val_rec, l_servicetran_rec);
1533: --- Defaulting item attributes

Line 1530: RAISE FND_API.G_EXC_ERROR;

1526: x_return_status);
1527: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1528: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1529: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1530: RAISE FND_API.G_EXC_ERROR;
1531: END IF;
1532: migrate(p_servicetran_val_rec, l_servicetran_rec);
1533: --- Defaulting item attributes
1534: l_return_status := Default_Item_Attributes

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

1536: l_servicetran_rec, ---- IN
1537: l_def_servicetran_rec
1538: );
1539: --- If any errors happen abort API
1540: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;

Line 1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1537: l_def_servicetran_rec
1538: );
1539: --- If any errors happen abort API
1540: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);

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

1538: );
1539: --- If any errors happen abort API
1540: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 1543: RAISE FND_API.G_EXC_ERROR;

1539: --- If any errors happen abort API
1540: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1541: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1542: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

1542: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;

Line 1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1543: RAISE FND_API.G_EXC_ERROR;
1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: --- Validate all non-missing attributes (Item Level Validation)

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

1544: END IF;
1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: --- Validate all non-missing attributes (Item Level Validation)
1552: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1549: RAISE FND_API.G_EXC_ERROR;

1545: l_return_status := populate_new_record(l_def_servicetran_rec, l_def_servicetran_rec);
1546: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1548: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: --- Validate all non-missing attributes (Item Level Validation)
1552: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1553: l_return_status := Validate_Item_Attributes

Line 1552: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1548: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1549: RAISE FND_API.G_EXC_ERROR;
1550: END IF;
1551: --- Validate all non-missing attributes (Item Level Validation)
1552: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1553: l_return_status := Validate_Item_Attributes
1554: (
1555: l_def_servicetran_rec ---- IN
1556: );

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

1554: (
1555: l_def_servicetran_rec ---- IN
1556: );
1557: --- If any errors happen abort API
1558: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;

Line 1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1555: l_def_servicetran_rec ---- IN
1556: );
1557: --- If any errors happen abort API
1558: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;

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

1556: );
1557: --- If any errors happen abort API
1558: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1561: RAISE FND_API.G_EXC_ERROR;

1557: --- If any errors happen abort API
1558: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1560: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);

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

1560: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1561: RAISE FND_API.G_EXC_ERROR;
1562: END IF;
1563: END IF;
1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
1566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1562: END IF;
1563: END IF;
1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
1566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;

Line 1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1563: END IF;
1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
1566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;

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

1564: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
1566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;
1572: UPDATE CS_CP_SERVICE_TRANSACTIONS

Line 1569: RAISE FND_API.G_EXC_ERROR;

1565: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
1566: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1567: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1568: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1569: RAISE FND_API.G_EXC_ERROR;
1570: END IF;
1571: END IF;
1572: UPDATE CS_CP_SERVICE_TRANSACTIONS
1573: SET

Line 1651: WHEN FND_API.G_EXC_ERROR THEN

1647: CP_SERVICE_TRANSACTION_ID = l_def_servicetran_rec.cp_service_transaction_id
1648: ;
1649: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1650: EXCEPTION
1651: WHEN FND_API.G_EXC_ERROR THEN
1652: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1653: (
1654: l_api_name,
1655: G_PKG_NAME,

Line 1656: 'FND_API.G_RET_STS_ERROR',

1652: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1653: (
1654: l_api_name,
1655: G_PKG_NAME,
1656: 'FND_API.G_RET_STS_ERROR',
1657: x_msg_count,
1658: x_msg_data,
1659: '_Pvt'
1660: );

Line 1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1658: x_msg_data,
1659: '_Pvt'
1660: );
1661: APP_EXCEPTION.RAISE_EXCEPTION;
1662: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1663: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,

Line 1667: 'FND_API.G_RET_STS_UNEXP_ERROR',

1663: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1664: (
1665: l_api_name,
1666: G_PKG_NAME,
1667: 'FND_API.G_RET_STS_UNEXP_ERROR',
1668: x_msg_count,
1669: x_msg_data,
1670: '_Pvt'
1671: );

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

1764: p_credit_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
1765: p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR) IS
1766: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
1767: l_api_version CONSTANT NUMBER := 1;
1768: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1769: l_servicetran_rec ServiceTran_Val_Rec_Type;
1770: BEGIN
1771: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1772: G_PKG_NAME,

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

1774: p_api_version,
1775: p_init_msg_list,
1776: '_Pvt',
1777: x_return_status);
1778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;

Line 1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1775: p_init_msg_list,
1776: '_Pvt',
1777: x_return_status);
1778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;

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

1776: '_Pvt',
1777: x_return_status);
1778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;
1784: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

Line 1781: RAISE FND_API.G_EXC_ERROR;

1777: x_return_status);
1778: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1779: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1780: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1781: RAISE FND_API.G_EXC_ERROR;
1782: END IF;
1783: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;
1784: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;
1785: l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line 1867: WHEN FND_API.G_EXC_ERROR THEN

1863: l_servicetran_rec
1864: );
1865: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1866: EXCEPTION
1867: WHEN FND_API.G_EXC_ERROR THEN
1868: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1869: (
1870: l_api_name,
1871: G_PKG_NAME,

Line 1872: 'FND_API.G_RET_STS_ERROR',

1868: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1869: (
1870: l_api_name,
1871: G_PKG_NAME,
1872: 'FND_API.G_RET_STS_ERROR',
1873: x_msg_count,
1874: x_msg_data,
1875: '_Pvt'
1876: );

Line 1878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1874: x_msg_data,
1875: '_Pvt'
1876: );
1877: APP_EXCEPTION.RAISE_EXCEPTION;
1878: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1879: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1880: (
1881: l_api_name,
1882: G_PKG_NAME,

Line 1883: 'FND_API.G_RET_STS_UNEXP_ERROR',

1879: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1880: (
1881: l_api_name,
1882: G_PKG_NAME,
1883: 'FND_API.G_RET_STS_UNEXP_ERROR',
1884: x_msg_count,
1885: x_msg_data,
1886: '_Pvt'
1887: );

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

1909: x_msg_data OUT VARCHAR2,
1910: p_cp_service_transaction_id IN NUMBER) IS
1911: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1912: l_api_version CONSTANT NUMBER := 1;
1913: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1914: BEGIN
1915: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1916: G_PKG_NAME,
1917: l_api_version,

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

1918: p_api_version,
1919: p_init_msg_list,
1920: '_Pvt',
1921: x_return_status);
1922: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;

Line 1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1919: p_init_msg_list,
1920: '_Pvt',
1921: x_return_status);
1922: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927: DELETE FROM CS_CP_SERVICE_TRANSACTIONS

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

1920: '_Pvt',
1921: x_return_status);
1922: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927: DELETE FROM CS_CP_SERVICE_TRANSACTIONS
1928: WHERE

Line 1925: RAISE FND_API.G_EXC_ERROR;

1921: x_return_status);
1922: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1923: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1924: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1925: RAISE FND_API.G_EXC_ERROR;
1926: END IF;
1927: DELETE FROM CS_CP_SERVICE_TRANSACTIONS
1928: WHERE
1929: CP_SERVICE_TRANSACTION_ID = p_cp_service_transaction_id

Line 1933: WHEN FND_API.G_EXC_ERROR THEN

1929: CP_SERVICE_TRANSACTION_ID = p_cp_service_transaction_id
1930: ;
1931: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1932: EXCEPTION
1933: WHEN FND_API.G_EXC_ERROR THEN
1934: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1935: (
1936: l_api_name,
1937: G_PKG_NAME,

Line 1938: 'FND_API.G_RET_STS_ERROR',

1934: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1935: (
1936: l_api_name,
1937: G_PKG_NAME,
1938: 'FND_API.G_RET_STS_ERROR',
1939: x_msg_count,
1940: x_msg_data,
1941: '_Pvt'
1942: );

Line 1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1940: x_msg_data,
1941: '_Pvt'
1942: );
1943: APP_EXCEPTION.RAISE_EXCEPTION;
1944: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1945: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1946: (
1947: l_api_name,
1948: G_PKG_NAME,

Line 1949: 'FND_API.G_RET_STS_UNEXP_ERROR',

1945: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1946: (
1947: l_api_name,
1948: G_PKG_NAME,
1949: 'FND_API.G_RET_STS_UNEXP_ERROR',
1950: x_msg_count,
1951: x_msg_data,
1952: '_Pvt'
1953: );

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

1975: x_msg_data OUT VARCHAR2,
1976: p_servicetran_val_rec IN ServiceTran_Val_Rec_Type := G_MISS_SERVICETRAN_VAL_REC) IS
1977: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1978: l_api_version CONSTANT NUMBER := 1;
1979: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1980: l_servicetran_rec ServiceTran_Rec_Type;
1981: l_def_servicetran_rec ServiceTran_Rec_Type;
1982: BEGIN
1983: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1986: p_api_version,
1987: p_init_msg_list,
1988: '_Pvt',
1989: x_return_status);
1990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;

Line 1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1987: p_init_msg_list,
1988: '_Pvt',
1989: x_return_status);
1990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;
1995: migrate(p_servicetran_val_rec, l_servicetran_rec);

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

1988: '_Pvt',
1989: x_return_status);
1990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;
1995: migrate(p_servicetran_val_rec, l_servicetran_rec);
1996: --- Validate all non-missing attributes (Item Level Validation)

Line 1993: RAISE FND_API.G_EXC_ERROR;

1989: x_return_status);
1990: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1991: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1992: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;
1995: migrate(p_servicetran_val_rec, l_servicetran_rec);
1996: --- Validate all non-missing attributes (Item Level Validation)
1997: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1997: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1993: RAISE FND_API.G_EXC_ERROR;
1994: END IF;
1995: migrate(p_servicetran_val_rec, l_servicetran_rec);
1996: --- Validate all non-missing attributes (Item Level Validation)
1997: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1998: l_return_status := Validate_Item_Attributes
1999: (
2000: l_servicetran_rec ---- IN
2001: );

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

1999: (
2000: l_servicetran_rec ---- IN
2001: );
2002: --- If any errors happen abort API
2003: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;

Line 2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2000: l_servicetran_rec ---- IN
2001: );
2002: --- If any errors happen abort API
2003: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;

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

2001: );
2002: --- If any errors happen abort API
2003: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;
2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 2006: RAISE FND_API.G_EXC_ERROR;

2002: --- If any errors happen abort API
2003: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2004: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2005: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;
2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);

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

2005: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008: END IF;
2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
2011: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

2007: END IF;
2008: END IF;
2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
2011: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;

Line 2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2008: END IF;
2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
2011: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;
2016: END IF;

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

2009: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
2011: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;
2016: END IF;
2017: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 2014: RAISE FND_API.G_EXC_ERROR;

2010: l_return_status := Validate_Item_Record(l_def_servicetran_rec);
2011: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2012: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2013: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2014: RAISE FND_API.G_EXC_ERROR;
2015: END IF;
2016: END IF;
2017: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
2018: EXCEPTION

Line 2019: WHEN FND_API.G_EXC_ERROR THEN

2015: END IF;
2016: END IF;
2017: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
2018: EXCEPTION
2019: WHEN FND_API.G_EXC_ERROR THEN
2020: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2021: (
2022: l_api_name,
2023: G_PKG_NAME,

Line 2024: 'FND_API.G_RET_STS_ERROR',

2020: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2021: (
2022: l_api_name,
2023: G_PKG_NAME,
2024: 'FND_API.G_RET_STS_ERROR',
2025: x_msg_count,
2026: x_msg_data,
2027: '_Pvt'
2028: );

Line 2030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2026: x_msg_data,
2027: '_Pvt'
2028: );
2029: APP_EXCEPTION.RAISE_EXCEPTION;
2030: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2031: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2032: (
2033: l_api_name,
2034: G_PKG_NAME,

Line 2035: 'FND_API.G_RET_STS_UNEXP_ERROR',

2031: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2032: (
2033: l_api_name,
2034: G_PKG_NAME,
2035: 'FND_API.G_RET_STS_UNEXP_ERROR',
2036: x_msg_count,
2037: x_msg_data,
2038: '_Pvt'
2039: );

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

2132: p_credit_amount IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
2133: p_purchase_order_num IN CS_CP_SERVICE_TRANSACTIONS.PURCHASE_ORDER_NUM%TYPE := TAPI_DEV_KIT.G_MISS_CHAR) IS
2134: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
2135: l_api_version CONSTANT NUMBER := 1;
2136: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2137: l_servicetran_rec ServiceTran_Val_Rec_Type;
2138: BEGIN
2139: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
2140: G_PKG_NAME,

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

2142: p_api_version,
2143: p_init_msg_list,
2144: '_Pvt',
2145: x_return_status);
2146: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;

Line 2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2143: p_init_msg_list,
2144: '_Pvt',
2145: x_return_status);
2146: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;
2151: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;

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

2144: '_Pvt',
2145: x_return_status);
2146: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;
2151: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;
2152: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;

Line 2149: RAISE FND_API.G_EXC_ERROR;

2145: x_return_status);
2146: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
2147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2148: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
2149: RAISE FND_API.G_EXC_ERROR;
2150: END IF;
2151: l_servicetran_rec.CP_SERVICE_TRANSACTION_ID := p_cp_service_transaction_id;
2152: l_servicetran_rec.LAST_UPDATE_DATE := p_last_update_date;
2153: l_servicetran_rec.LAST_UPDATED_BY := p_last_updated_by;

Line 2235: WHEN FND_API.G_EXC_ERROR THEN

2231: l_servicetran_rec
2232: );
2233: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
2234: EXCEPTION
2235: WHEN FND_API.G_EXC_ERROR THEN
2236: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,

Line 2240: 'FND_API.G_RET_STS_ERROR',

2236: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2237: (
2238: l_api_name,
2239: G_PKG_NAME,
2240: 'FND_API.G_RET_STS_ERROR',
2241: x_msg_count,
2242: x_msg_data,
2243: '_Pvt'
2244: );

Line 2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2242: x_msg_data,
2243: '_Pvt'
2244: );
2245: APP_EXCEPTION.RAISE_EXCEPTION;
2246: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2247: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2248: (
2249: l_api_name,
2250: G_PKG_NAME,

Line 2251: 'FND_API.G_RET_STS_UNEXP_ERROR',

2247: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
2248: (
2249: l_api_name,
2250: G_PKG_NAME,
2251: 'FND_API.G_RET_STS_UNEXP_ERROR',
2252: x_msg_count,
2253: x_msg_data,
2254: '_Pvt'
2255: );