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

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

18: p_txnbtype_rec IN TxnBType_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_txnbtype_rec.billing_type = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_txnbtype_rec.billing_type IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_txnbtype_rec.transaction_type_id = TAPI_DEV_KIT.G_MISS_NUM OR
30: p_txnbtype_rec.transaction_type_id IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'transaction_type_id');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txnbtype_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_txnbtype_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_txnbtype_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_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txnbtype_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_txnbtype_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_txnbtype_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_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txnbtype_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_txnbtype_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_txnbtype_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_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txnbtype_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_txnbtype_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_txnbtype_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_txnbtype_rec OUT TxnBType_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_txnbtype_rec := p_txnbtype_rec;
70: l_def_txnbtype_rec.OBJECT_VERSION_NUMBER := NVL(l_def_txnbtype_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_txnbtype_rec IN TxnBType_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_txnbtype_rec IN TxnBType_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_Transaction_Types
93: WHERE cs_transaction_types.transaction_type_id = p_transaction_type_id;
94: l_ctt_pk ctt_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_txnbtype_rec.BILLING_TYPE 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_txnbtype_rec);

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

204: x_txn_billing_type_id OUT NUMBER,
205: x_object_version_number OUT NUMBER) IS
206: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
207: l_api_version CONSTANT NUMBER := 1;
208: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
209: l_txnbtype_rec TxnBType_Rec_Type;
210: l_def_txnbtype_rec TxnBType_Rec_Type;
211: BEGIN
212: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

215: p_api_version,
216: p_init_msg_list,
217: '_Pvt',
218: x_return_status);
219: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;

Line 220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

216: p_init_msg_list,
217: '_Pvt',
218: x_return_status);
219: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: l_txnbtype_rec := p_txnbtype_rec;

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

217: '_Pvt',
218: x_return_status);
219: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: l_txnbtype_rec := p_txnbtype_rec;
225: --- Validate all non-missing attributes (Item Level Validation)

Line 222: RAISE FND_API.G_EXC_ERROR;

218: x_return_status);
219: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
221: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: l_txnbtype_rec := p_txnbtype_rec;
225: --- Validate all non-missing attributes (Item Level Validation)
226: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 226: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

222: RAISE FND_API.G_EXC_ERROR;
223: END IF;
224: l_txnbtype_rec := p_txnbtype_rec;
225: --- Validate all non-missing attributes (Item Level Validation)
226: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
227: l_return_status := Validate_Item_Attributes
228: (
229: l_txnbtype_rec ---- IN
230: );

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

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

Line 233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

230: );
231: --- If any errors happen abort API
232: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
234: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
235: RAISE FND_API.G_EXC_ERROR;
236: END IF;
237: END IF;
238: --- Defaulting item attributes

Line 235: RAISE FND_API.G_EXC_ERROR;

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

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

241: l_txnbtype_rec, ---- IN
242: l_def_txnbtype_rec
243: );
244: --- If any errors happen abort API
245: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;

Line 246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

242: l_def_txnbtype_rec
243: );
244: --- If any errors happen abort API
245: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

243: );
244: --- If any errors happen abort API
245: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);

Line 248: RAISE FND_API.G_EXC_ERROR;

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

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

246: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
247: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
252: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

248: RAISE FND_API.G_EXC_ERROR;
249: END IF;
250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
252: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;

Line 253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

249: END IF;
250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
252: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;

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

250: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
252: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258: -- Set primary key value

Line 255: RAISE FND_API.G_EXC_ERROR;

251: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
252: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
253: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
254: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
255: RAISE FND_API.G_EXC_ERROR;
256: END IF;
257: END IF;
258: -- Set primary key value
259: l_def_txnbtype_rec.txn_billing_type_id := get_seq_id;

Line 317: WHEN FND_API.G_EXC_ERROR THEN

313: x_txn_billing_type_id := l_def_txnbtype_rec.txn_billing_type_id;
314: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
315: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
319: (
320: l_api_name,
321: G_PKG_NAME,

Line 322: 'FND_API.G_RET_STS_ERROR',

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

Line 328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

324: x_msg_data,
325: '_Pvt'
326: );
327: APP_EXCEPTION.RAISE_EXCEPTION;
328: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,

Line 333: 'FND_API.G_RET_STS_UNEXP_ERROR',

329: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
330: (
331: l_api_name,
332: G_PKG_NAME,
333: 'FND_API.G_RET_STS_UNEXP_ERROR',
334: x_msg_count,
335: x_msg_data,
336: '_Pvt'
337: );

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

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

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

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

Line 399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

395: p_init_msg_list,
396: '_Pvt',
397: x_return_status);
398: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403: l_txnbtype_rec.BILLING_TYPE := p_billing_type;

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

396: '_Pvt',
397: x_return_status);
398: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403: l_txnbtype_rec.BILLING_TYPE := p_billing_type;
404: l_txnbtype_rec.TRANSACTION_TYPE_ID := p_transaction_type_id;

Line 401: RAISE FND_API.G_EXC_ERROR;

397: x_return_status);
398: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
399: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
400: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
401: RAISE FND_API.G_EXC_ERROR;
402: END IF;
403: l_txnbtype_rec.BILLING_TYPE := p_billing_type;
404: l_txnbtype_rec.TRANSACTION_TYPE_ID := p_transaction_type_id;
405: l_txnbtype_rec.LAST_UPDATE_DATE := p_last_update_date;

Line 441: WHEN FND_API.G_EXC_ERROR THEN

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

Line 446: 'FND_API.G_RET_STS_ERROR',

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

Line 452: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 457: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

500: TXN_BILLING_TYPE_ID = p_txn_billing_type_id
501: ;
502: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
503: l_api_version CONSTANT NUMBER := 1;
504: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
505: l_object_version_number CS_TXN_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
506: lc_object_version_number CS_TXN_BILLING_TYPES.OBJECT_VERSION_NUMBER%TYPE;
507: l_row_notfound BOOLEAN := FALSE;
508: lc_row_notfound BOOLEAN := FALSE;

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

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

Line 518: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 520: RAISE FND_API.G_EXC_ERROR;

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

Line 544: RAISE FND_API.G_EXC_ERROR;

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

Line 547: RAISE FND_API.G_EXC_ERROR;

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

Line 550: RAISE FND_API.G_EXC_ERROR;

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

Line 553: RAISE FND_API.G_EXC_ERROR;

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

Line 557: WHEN FND_API.G_EXC_ERROR THEN

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

Line 562: 'FND_API.G_RET_STS_ERROR',

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

Line 568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 573: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

600: p_txnbtype_val_rec IN TxnBType_Val_Rec_Type := G_MISS_TXNBTYPE_VAL_REC,
601: x_object_version_number OUT NUMBER) IS
602: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
603: l_api_version CONSTANT NUMBER := 1;
604: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
605: l_txnbtype_rec TxnBType_Rec_Type;
606: l_def_txnbtype_rec TxnBType_Rec_Type;
607: FUNCTION populate_new_record (
608: p_txnbtype_rec IN TxnBType_Rec_Type,

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

613: FROM Cs_Txn_Billing_Types
614: WHERE cs_txn_billing_types.txn_billing_type_id = p_txn_billing_type_id;
615: l_cs_txn_billing_types_pk cs_txn_billing_types_pk_csr%ROWTYPE;
616: l_row_notfound BOOLEAN := TRUE;
617: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
618: BEGIN
619: x_txnbtype_rec := p_txnbtype_rec;
620: -- Get current database values
621: OPEN cs_txn_billing_types_pk_csr (p_txnbtype_rec.txn_billing_type_id);

Line 626: l_return_status := FND_API.G_RET_STS_ERROR;

622: FETCH cs_txn_billing_types_pk_csr INTO l_cs_txn_billing_types_pk;
623: l_row_notfound := cs_txn_billing_types_pk_csr%NOTFOUND;
624: CLOSE cs_txn_billing_types_pk_csr;
625: IF (l_row_notfound) THEN
626: l_return_status := FND_API.G_RET_STS_ERROR;
627: END IF;
628: IF (x_txnbtype_rec.txn_billing_type_id = TAPI_DEV_KIT.G_MISS_NUM)
629: THEN
630: x_txnbtype_rec.txn_billing_type_id := l_cs_txn_billing_types_pk.txn_billing_type_id;

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

734: p_api_version,
735: p_init_msg_list,
736: '_Pvt',
737: x_return_status);
738: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;

Line 739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

735: p_init_msg_list,
736: '_Pvt',
737: x_return_status);
738: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743: migrate(p_txnbtype_val_rec, l_txnbtype_rec);

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

736: '_Pvt',
737: x_return_status);
738: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743: migrate(p_txnbtype_val_rec, l_txnbtype_rec);
744: --- Defaulting item attributes

Line 741: RAISE FND_API.G_EXC_ERROR;

737: x_return_status);
738: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
739: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
740: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
741: RAISE FND_API.G_EXC_ERROR;
742: END IF;
743: migrate(p_txnbtype_val_rec, l_txnbtype_rec);
744: --- Defaulting item attributes
745: l_return_status := Default_Item_Attributes

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

747: l_txnbtype_rec, ---- IN
748: l_def_txnbtype_rec
749: );
750: --- If any errors happen abort API
751: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;

Line 752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

748: l_def_txnbtype_rec
749: );
750: --- If any errors happen abort API
751: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);

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

749: );
750: --- If any errors happen abort API
751: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 754: RAISE FND_API.G_EXC_ERROR;

750: --- If any errors happen abort API
751: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
752: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
753: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

753: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;

Line 758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

754: RAISE FND_API.G_EXC_ERROR;
755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: --- Validate all non-missing attributes (Item Level Validation)

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

755: END IF;
756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: --- Validate all non-missing attributes (Item Level Validation)
763: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 760: RAISE FND_API.G_EXC_ERROR;

756: l_return_status := populate_new_record(l_def_txnbtype_rec, l_def_txnbtype_rec);
757: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
758: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
759: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: --- Validate all non-missing attributes (Item Level Validation)
763: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
764: l_return_status := Validate_Item_Attributes

Line 763: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

759: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
760: RAISE FND_API.G_EXC_ERROR;
761: END IF;
762: --- Validate all non-missing attributes (Item Level Validation)
763: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
764: l_return_status := Validate_Item_Attributes
765: (
766: l_def_txnbtype_rec ---- IN
767: );

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

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

Line 770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

766: l_def_txnbtype_rec ---- IN
767: );
768: --- If any errors happen abort API
769: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: END IF;

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

767: );
768: --- If any errors happen abort API
769: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: END IF;
775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 772: RAISE FND_API.G_EXC_ERROR;

768: --- If any errors happen abort API
769: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
770: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
771: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: END IF;
775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);

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

771: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774: END IF;
775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

773: END IF;
774: END IF;
775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;

Line 778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

774: END IF;
775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: END IF;

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

775: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: END IF;
783: UPDATE CS_TXN_BILLING_TYPES

Line 780: RAISE FND_API.G_EXC_ERROR;

776: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: END IF;
783: UPDATE CS_TXN_BILLING_TYPES
784: SET

Line 816: WHEN FND_API.G_EXC_ERROR THEN

812: ;
813: x_object_version_number := l_def_txnbtype_rec.OBJECT_VERSION_NUMBER;
814: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
815: EXCEPTION
816: WHEN FND_API.G_EXC_ERROR THEN
817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
819: l_api_name,
820: G_PKG_NAME,

Line 821: 'FND_API.G_RET_STS_ERROR',

817: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
818: (
819: l_api_name,
820: G_PKG_NAME,
821: 'FND_API.G_RET_STS_ERROR',
822: x_msg_count,
823: x_msg_data,
824: '_Pvt'
825: );

Line 827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

823: x_msg_data,
824: '_Pvt'
825: );
826: APP_EXCEPTION.RAISE_EXCEPTION;
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
829: (
830: l_api_name,
831: G_PKG_NAME,

Line 832: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

883: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
884: x_object_version_number OUT NUMBER) IS
885: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
886: l_api_version CONSTANT NUMBER := 1;
887: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
888: l_txnbtype_rec TxnBType_Val_Rec_Type;
889: BEGIN
890: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
891: G_PKG_NAME,

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

893: p_api_version,
894: p_init_msg_list,
895: '_Pvt',
896: x_return_status);
897: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;

Line 898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

894: p_init_msg_list,
895: '_Pvt',
896: x_return_status);
897: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;

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

895: '_Pvt',
896: x_return_status);
897: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;
903: l_txnbtype_rec.BILLING_TYPE := p_billing_type;

Line 900: RAISE FND_API.G_EXC_ERROR;

896: x_return_status);
897: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
898: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
899: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
900: RAISE FND_API.G_EXC_ERROR;
901: END IF;
902: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;
903: l_txnbtype_rec.BILLING_TYPE := p_billing_type;
904: l_txnbtype_rec.TRANSACTION_TYPE_ID := p_transaction_type_id;

Line 940: WHEN FND_API.G_EXC_ERROR THEN

936: x_object_version_number
937: );
938: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
942: (
943: l_api_name,
944: G_PKG_NAME,

Line 945: 'FND_API.G_RET_STS_ERROR',

941: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
942: (
943: l_api_name,
944: G_PKG_NAME,
945: 'FND_API.G_RET_STS_ERROR',
946: x_msg_count,
947: x_msg_data,
948: '_Pvt'
949: );

Line 951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

947: x_msg_data,
948: '_Pvt'
949: );
950: APP_EXCEPTION.RAISE_EXCEPTION;
951: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
952: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
953: (
954: l_api_name,
955: G_PKG_NAME,

Line 956: 'FND_API.G_RET_STS_UNEXP_ERROR',

952: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
953: (
954: l_api_name,
955: G_PKG_NAME,
956: 'FND_API.G_RET_STS_UNEXP_ERROR',
957: x_msg_count,
958: x_msg_data,
959: '_Pvt'
960: );

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

982: x_msg_data OUT VARCHAR2,
983: p_txn_billing_type_id IN NUMBER) IS
984: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
985: l_api_version CONSTANT NUMBER := 1;
986: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
987: BEGIN
988: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
989: G_PKG_NAME,
990: l_api_version,

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

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

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992: p_init_msg_list,
993: '_Pvt',
994: x_return_status);
995: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: DELETE FROM CS_TXN_BILLING_TYPES

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

993: '_Pvt',
994: x_return_status);
995: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: DELETE FROM CS_TXN_BILLING_TYPES
1001: WHERE

Line 998: RAISE FND_API.G_EXC_ERROR;

994: x_return_status);
995: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
998: RAISE FND_API.G_EXC_ERROR;
999: END IF;
1000: DELETE FROM CS_TXN_BILLING_TYPES
1001: WHERE
1002: TXN_BILLING_TYPE_ID = p_txn_billing_type_id

Line 1006: WHEN FND_API.G_EXC_ERROR THEN

1002: TXN_BILLING_TYPE_ID = p_txn_billing_type_id
1003: ;
1004: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1005: EXCEPTION
1006: WHEN FND_API.G_EXC_ERROR THEN
1007: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1008: (
1009: l_api_name,
1010: G_PKG_NAME,

Line 1011: 'FND_API.G_RET_STS_ERROR',

1007: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1008: (
1009: l_api_name,
1010: G_PKG_NAME,
1011: 'FND_API.G_RET_STS_ERROR',
1012: x_msg_count,
1013: x_msg_data,
1014: '_Pvt'
1015: );

Line 1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1013: x_msg_data,
1014: '_Pvt'
1015: );
1016: APP_EXCEPTION.RAISE_EXCEPTION;
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1019: (
1020: l_api_name,
1021: G_PKG_NAME,

Line 1022: 'FND_API.G_RET_STS_UNEXP_ERROR',

1018: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1019: (
1020: l_api_name,
1021: G_PKG_NAME,
1022: 'FND_API.G_RET_STS_UNEXP_ERROR',
1023: x_msg_count,
1024: x_msg_data,
1025: '_Pvt'
1026: );

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

1048: x_msg_data OUT VARCHAR2,
1049: p_txnbtype_val_rec IN TxnBType_Val_Rec_Type := G_MISS_TXNBTYPE_VAL_REC) IS
1050: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1051: l_api_version CONSTANT NUMBER := 1;
1052: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1053: l_txnbtype_rec TxnBType_Rec_Type;
1054: l_def_txnbtype_rec TxnBType_Rec_Type;
1055: BEGIN
1056: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1059: p_api_version,
1060: p_init_msg_list,
1061: '_Pvt',
1062: x_return_status);
1063: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;

Line 1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1060: p_init_msg_list,
1061: '_Pvt',
1062: x_return_status);
1063: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: migrate(p_txnbtype_val_rec, l_txnbtype_rec);

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

1061: '_Pvt',
1062: x_return_status);
1063: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: migrate(p_txnbtype_val_rec, l_txnbtype_rec);
1069: --- Validate all non-missing attributes (Item Level Validation)

Line 1066: RAISE FND_API.G_EXC_ERROR;

1062: x_return_status);
1063: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1064: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1065: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: migrate(p_txnbtype_val_rec, l_txnbtype_rec);
1069: --- Validate all non-missing attributes (Item Level Validation)
1070: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1070: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1066: RAISE FND_API.G_EXC_ERROR;
1067: END IF;
1068: migrate(p_txnbtype_val_rec, l_txnbtype_rec);
1069: --- Validate all non-missing attributes (Item Level Validation)
1070: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1071: l_return_status := Validate_Item_Attributes
1072: (
1073: l_txnbtype_rec ---- IN
1074: );

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

1072: (
1073: l_txnbtype_rec ---- IN
1074: );
1075: --- If any errors happen abort API
1076: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;

Line 1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1073: l_txnbtype_rec ---- IN
1074: );
1075: --- If any errors happen abort API
1076: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;

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

1074: );
1075: --- If any errors happen abort API
1076: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;
1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: --- If any errors happen abort API
1076: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1077: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1078: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;
1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);

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

1078: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081: END IF;
1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
1084: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1080: END IF;
1081: END IF;
1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
1084: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;

Line 1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1081: END IF;
1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
1084: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: END IF;

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

1082: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
1084: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: END IF;
1090: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1087: RAISE FND_API.G_EXC_ERROR;

1083: l_return_status := Validate_Item_Record(l_def_txnbtype_rec);
1084: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1085: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1086: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: END IF;
1090: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1091: EXCEPTION

Line 1092: WHEN FND_API.G_EXC_ERROR THEN

1088: END IF;
1089: END IF;
1090: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1091: EXCEPTION
1092: WHEN FND_API.G_EXC_ERROR THEN
1093: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1094: (
1095: l_api_name,
1096: G_PKG_NAME,

Line 1097: 'FND_API.G_RET_STS_ERROR',

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

Line 1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1099: x_msg_data,
1100: '_Pvt'
1101: );
1102: APP_EXCEPTION.RAISE_EXCEPTION;
1103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1104: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1105: (
1106: l_api_name,
1107: G_PKG_NAME,

Line 1108: 'FND_API.G_RET_STS_UNEXP_ERROR',

1104: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1105: (
1106: l_api_name,
1107: G_PKG_NAME,
1108: 'FND_API.G_RET_STS_UNEXP_ERROR',
1109: x_msg_count,
1110: x_msg_data,
1111: '_Pvt'
1112: );

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

1158: p_context IN CS_TXN_BILLING_TYPES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1159: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1160: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1161: l_api_version CONSTANT NUMBER := 1;
1162: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1163: l_txnbtype_rec TxnBType_Val_Rec_Type;
1164: BEGIN
1165: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1166: G_PKG_NAME,

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

1168: p_api_version,
1169: p_init_msg_list,
1170: '_Pvt',
1171: x_return_status);
1172: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;

Line 1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1169: p_init_msg_list,
1170: '_Pvt',
1171: x_return_status);
1172: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;

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

1170: '_Pvt',
1171: x_return_status);
1172: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;
1178: l_txnbtype_rec.BILLING_TYPE := p_billing_type;

Line 1175: RAISE FND_API.G_EXC_ERROR;

1171: x_return_status);
1172: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1174: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1175: RAISE FND_API.G_EXC_ERROR;
1176: END IF;
1177: l_txnbtype_rec.TXN_BILLING_TYPE_ID := p_txn_billing_type_id;
1178: l_txnbtype_rec.BILLING_TYPE := p_billing_type;
1179: l_txnbtype_rec.TRANSACTION_TYPE_ID := p_transaction_type_id;

Line 1214: WHEN FND_API.G_EXC_ERROR THEN

1210: l_txnbtype_rec
1211: );
1212: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1213: EXCEPTION
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1216: (
1217: l_api_name,
1218: G_PKG_NAME,

Line 1219: 'FND_API.G_RET_STS_ERROR',

1215: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1216: (
1217: l_api_name,
1218: G_PKG_NAME,
1219: 'FND_API.G_RET_STS_ERROR',
1220: x_msg_count,
1221: x_msg_data,
1222: '_Pvt'
1223: );

Line 1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1221: x_msg_data,
1222: '_Pvt'
1223: );
1224: APP_EXCEPTION.RAISE_EXCEPTION;
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1227: (
1228: l_api_name,
1229: G_PKG_NAME,

Line 1230: 'FND_API.G_RET_STS_UNEXP_ERROR',

1226: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1227: (
1228: l_api_name,
1229: G_PKG_NAME,
1230: 'FND_API.G_RET_STS_UNEXP_ERROR',
1231: x_msg_count,
1232: x_msg_data,
1233: '_Pvt'
1234: );