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

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

18: p_counterfilter_rec IN CounterFilter_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_counterfilter_rec.counter_id = TAPI_DEV_KIT.G_MISS_NUM OR
25: p_counterfilter_rec.counter_id IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 38: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 43: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 48: l_return_status := FND_API.G_RET_STS_ERROR;

44: ELSIF p_counterfilter_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
45: p_counterfilter_rec.last_updated_by IS NULL
46: THEN
47: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'last_updated_by');
48: l_return_status := FND_API.G_RET_STS_ERROR;
49: ELSIF p_counterfilter_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_counterfilter_rec.creation_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');

Line 53: l_return_status := FND_API.G_RET_STS_ERROR;

49: ELSIF p_counterfilter_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
50: p_counterfilter_rec.creation_date IS NULL
51: THEN
52: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'creation_date');
53: l_return_status := FND_API.G_RET_STS_ERROR;
54: ELSIF p_counterfilter_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_counterfilter_rec.created_by IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');

Line 58: l_return_status := FND_API.G_RET_STS_ERROR;

54: ELSIF p_counterfilter_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
55: p_counterfilter_rec.created_by IS NULL
56: THEN
57: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'created_by');
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_counterfilter_rec OUT NOCOPY CounterFilter_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_counterfilter_rec := p_counterfilter_rec;
75: l_def_counterfilter_rec.OBJECT_VERSION_NUMBER := NVL(l_def_counterfilter_rec.OBJECT_VERSION_NUMBER, 0) + 1;
76: RETURN(l_return_status);

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

80: FUNCTION Validate_Item_Record (
81: p_counterfilter_rec IN CounterFilter_Rec_Type
82: )
83: RETURN VARCHAR2 IS
84: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
85: BEGIN
86: RETURN (l_return_status);
87: END Validate_Item_Record;
88:

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

174: x_counter_der_filter_id OUT NOCOPY NUMBER,
175: x_object_version_number OUT NOCOPY NUMBER) IS
176: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
177: l_api_version CONSTANT NUMBER := 1;
178: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
179: l_counterfilter_rec CounterFilter_Rec_Type;
180: l_def_counterfilter_rec CounterFilter_Rec_Type;
181: BEGIN
182: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

185: p_api_version,
186: p_init_msg_list,
187: '_Pvt',
188: x_return_status);
189: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;

Line 190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

186: p_init_msg_list,
187: '_Pvt',
188: x_return_status);
189: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: l_counterfilter_rec := p_counterfilter_rec;

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

187: '_Pvt',
188: x_return_status);
189: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: l_counterfilter_rec := p_counterfilter_rec;
195: --- Validate all non-missing attributes (Item Level Validation)

Line 192: RAISE FND_API.G_EXC_ERROR;

188: x_return_status);
189: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
190: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
191: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: l_counterfilter_rec := p_counterfilter_rec;
195: --- Validate all non-missing attributes (Item Level Validation)
196: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 196: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194: l_counterfilter_rec := p_counterfilter_rec;
195: --- Validate all non-missing attributes (Item Level Validation)
196: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
197: l_return_status := Validate_Item_Attributes
198: (
199: l_counterfilter_rec ---- IN
200: );

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

198: (
199: l_counterfilter_rec ---- IN
200: );
201: --- If any errors happen abort API
202: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;

Line 203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

199: l_counterfilter_rec ---- IN
200: );
201: --- If any errors happen abort API
202: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: END IF;

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

200: );
201: --- If any errors happen abort API
202: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: END IF;
208: --- Defaulting item attributes

Line 205: RAISE FND_API.G_EXC_ERROR;

201: --- If any errors happen abort API
202: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
203: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
204: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
205: RAISE FND_API.G_EXC_ERROR;
206: END IF;
207: END IF;
208: --- Defaulting item attributes
209: l_return_status := Default_Item_Attributes

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

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

Line 216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 218: RAISE FND_API.G_EXC_ERROR;

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

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

216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
217: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
221: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

218: RAISE FND_API.G_EXC_ERROR;
219: END IF;
220: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
221: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;

Line 223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

219: END IF;
220: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
221: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;

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

220: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
221: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;
228: -- Set primary key value

Line 225: RAISE FND_API.G_EXC_ERROR;

221: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
222: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
225: RAISE FND_API.G_EXC_ERROR;
226: END IF;
227: END IF;
228: -- Set primary key value
229: l_def_counterfilter_rec.counter_der_filter_id := get_seq_id;

Line 299: WHEN FND_API.G_EXC_ERROR THEN

295: x_counter_der_filter_id := l_def_counterfilter_rec.counter_der_filter_id;
296: x_object_version_number := l_def_counterfilter_rec.OBJECT_VERSION_NUMBER;
297: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
298: EXCEPTION
299: WHEN FND_API.G_EXC_ERROR THEN
300: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
301: (
302: l_api_name,
303: G_PKG_NAME,

Line 304: 'FND_API.G_RET_STS_ERROR',

300: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
301: (
302: l_api_name,
303: G_PKG_NAME,
304: 'FND_API.G_RET_STS_ERROR',
305: x_msg_count,
306: x_msg_data,
307: '_Pvt'
308: );

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

306: x_msg_data,
307: '_Pvt'
308: );
309: APP_EXCEPTION.RAISE_EXCEPTION;
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
312: (
313: l_api_name,
314: G_PKG_NAME,

Line 315: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

372: x_counter_der_filter_id OUT NOCOPY NUMBER,
373: x_object_version_number OUT NOCOPY NUMBER) IS
374: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
375: l_api_version CONSTANT NUMBER := 1;
376: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
377: l_counterfilter_rec CounterFilter_Rec_Type;
378: BEGIN
379: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
380: G_PKG_NAME,

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

382: p_api_version,
383: p_init_msg_list,
384: '_Pvt',
385: x_return_status);
386: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;

Line 387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

383: p_init_msg_list,
384: '_Pvt',
385: x_return_status);
386: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391: l_counterfilter_rec.COUNTER_ID := p_counter_id;

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

384: '_Pvt',
385: x_return_status);
386: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391: l_counterfilter_rec.COUNTER_ID := p_counter_id;
392: l_counterfilter_rec.SEQ_NO := p_seq_no;

Line 389: RAISE FND_API.G_EXC_ERROR;

385: x_return_status);
386: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
387: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
388: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
389: RAISE FND_API.G_EXC_ERROR;
390: END IF;
391: l_counterfilter_rec.COUNTER_ID := p_counter_id;
392: l_counterfilter_rec.SEQ_NO := p_seq_no;
393: l_counterfilter_rec.LEFT_PAREN := p_left_paren;

Line 424: FND_API.G_TRUE,

420: l_counterfilter_rec.OBJECT_VERSION_NUMBER := p_object_version_number;
421: insert_row(
422: p_api_version,
423: --p_init_msg_list,
424: FND_API.G_TRUE,
425: p_validation_level,
426: --p_commit,
427: FND_API.G_TRUE,
428: x_return_status,

Line 427: FND_API.G_TRUE,

423: --p_init_msg_list,
424: FND_API.G_TRUE,
425: p_validation_level,
426: --p_commit,
427: FND_API.G_TRUE,
428: x_return_status,
429: x_msg_count,
430: x_msg_data,
431: l_counterfilter_rec,

Line 437: WHEN FND_API.G_EXC_ERROR THEN

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

Line 442: 'FND_API.G_RET_STS_ERROR',

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

Line 448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 453: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

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

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

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

Line 514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 516: RAISE FND_API.G_EXC_ERROR;

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

Line 540: RAISE FND_API.G_EXC_ERROR;

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

Line 543: RAISE FND_API.G_EXC_ERROR;

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

Line 546: RAISE FND_API.G_EXC_ERROR;

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

Line 549: RAISE FND_API.G_EXC_ERROR;

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

Line 553: WHEN FND_API.G_EXC_ERROR THEN

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

Line 558: 'FND_API.G_RET_STS_ERROR',

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

Line 564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 569: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

596: p_counterfilter_val_rec IN CounterFilter_Val_Rec_Type := G_MISS_COUNTERFILTER_VAL_REC,
597: x_object_version_number OUT NOCOPY NUMBER) IS
598: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
599: l_api_version CONSTANT NUMBER := 1;
600: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
601: l_counterfilter_rec CounterFilter_Rec_Type;
602: l_def_counterfilter_rec CounterFilter_Rec_Type;
603: FUNCTION populate_new_record (
604: p_counterfilter_rec IN CounterFilter_Rec_Type,

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

609: FROM Cs_Counter_Der_Filters
610: WHERE cs_counter_der_filters.counter_der_filter_id = p_counter_der_filter_id;
611: l_ccd_pk ccd_pk_csr%ROWTYPE;
612: l_row_notfound BOOLEAN := TRUE;
613: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
614: BEGIN
615: x_counterfilter_rec := p_counterfilter_rec;
616: -- Get current database values
617: OPEN ccd_pk_csr (p_counterfilter_rec.counter_der_filter_id);

Line 622: l_return_status := FND_API.G_RET_STS_ERROR;

618: FETCH ccd_pk_csr INTO l_ccd_pk;
619: l_row_notfound := ccd_pk_csr%NOTFOUND;
620: CLOSE ccd_pk_csr;
621: IF (l_row_notfound) THEN
622: l_return_status := FND_API.G_RET_STS_ERROR;
623: END IF;
624: IF (x_counterfilter_rec.counter_der_filter_id = TAPI_DEV_KIT.G_MISS_NUM)
625: THEN
626: x_counterfilter_rec.counter_der_filter_id := l_ccd_pk.counter_der_filter_id;

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

754: p_api_version,
755: p_init_msg_list,
756: '_Pvt',
757: x_return_status);
758: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;

Line 759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

755: p_init_msg_list,
756: '_Pvt',
757: x_return_status);
758: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: migrate(p_counterfilter_val_rec, l_counterfilter_rec);

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

756: '_Pvt',
757: x_return_status);
758: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: migrate(p_counterfilter_val_rec, l_counterfilter_rec);
764: --- Defaulting item attributes

Line 761: RAISE FND_API.G_EXC_ERROR;

757: x_return_status);
758: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
761: RAISE FND_API.G_EXC_ERROR;
762: END IF;
763: migrate(p_counterfilter_val_rec, l_counterfilter_rec);
764: --- Defaulting item attributes
765: l_return_status := Default_Item_Attributes

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

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

Line 772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

769: );
770: --- If any errors happen abort API
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 774: RAISE FND_API.G_EXC_ERROR;

770: --- If any errors happen abort API
771: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
772: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_rec);
777: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
778: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

773: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_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: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_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: --- Validate all non-missing attributes (Item Level Validation)

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

775: END IF;
776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_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: --- Validate all non-missing attributes (Item Level Validation)
783: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 780: RAISE FND_API.G_EXC_ERROR;

776: l_return_status := populate_new_record(l_def_counterfilter_rec, l_def_counterfilter_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: --- Validate all non-missing attributes (Item Level Validation)
783: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
784: l_return_status := Validate_Item_Attributes

Line 783: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

779: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
780: RAISE FND_API.G_EXC_ERROR;
781: END IF;
782: --- Validate all non-missing attributes (Item Level Validation)
783: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
784: l_return_status := Validate_Item_Attributes
785: (
786: l_def_counterfilter_rec ---- IN
787: );

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

785: (
786: l_def_counterfilter_rec ---- IN
787: );
788: --- If any errors happen abort API
789: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;

Line 790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

786: l_def_counterfilter_rec ---- IN
787: );
788: --- If any errors happen abort API
789: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;

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

787: );
788: --- If any errors happen abort API
789: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;
795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 792: RAISE FND_API.G_EXC_ERROR;

788: --- If any errors happen abort API
789: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
790: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
791: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;
795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);

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

791: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794: END IF;
795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
797: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

793: END IF;
794: END IF;
795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
797: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;

Line 798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

794: END IF;
795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
797: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;

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

795: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
797: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;
803: UPDATE CS_COUNTER_DER_FILTERS

Line 800: RAISE FND_API.G_EXC_ERROR;

796: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
797: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
800: RAISE FND_API.G_EXC_ERROR;
801: END IF;
802: END IF;
803: UPDATE CS_COUNTER_DER_FILTERS
804: SET

Line 842: WHEN FND_API.G_EXC_ERROR THEN

838: ;
839: x_object_version_number := l_def_counterfilter_rec.OBJECT_VERSION_NUMBER;
840: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
841: EXCEPTION
842: WHEN FND_API.G_EXC_ERROR THEN
843: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
844: (
845: l_api_name,
846: G_PKG_NAME,

Line 847: 'FND_API.G_RET_STS_ERROR',

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

Line 853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

849: x_msg_data,
850: '_Pvt'
851: );
852: APP_EXCEPTION.RAISE_EXCEPTION;
853: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
854: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
855: (
856: l_api_name,
857: G_PKG_NAME,

Line 858: 'FND_API.G_RET_STS_UNEXP_ERROR',

854: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
855: (
856: l_api_name,
857: G_PKG_NAME,
858: 'FND_API.G_RET_STS_UNEXP_ERROR',
859: x_msg_count,
860: x_msg_data,
861: '_Pvt'
862: );

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

915: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM,
916: x_object_version_number OUT NOCOPY NUMBER) IS
917: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
918: l_api_version CONSTANT NUMBER := 1;
919: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
920: l_counterfilter_rec CounterFilter_Val_Rec_Type;
921: BEGIN
922: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
923: G_PKG_NAME,

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

925: p_api_version,
926: p_init_msg_list,
927: '_Pvt',
928: x_return_status);
929: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;

Line 930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

926: p_init_msg_list,
927: '_Pvt',
928: x_return_status);
929: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;

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

927: '_Pvt',
928: x_return_status);
929: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;
935: l_counterfilter_rec.COUNTER_ID := p_counter_id;

Line 932: RAISE FND_API.G_EXC_ERROR;

928: x_return_status);
929: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
930: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
931: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
932: RAISE FND_API.G_EXC_ERROR;
933: END IF;
934: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;
935: l_counterfilter_rec.COUNTER_ID := p_counter_id;
936: l_counterfilter_rec.SEQ_NO := p_seq_no;

Line 967: FND_API.G_TRUE ,

963: l_counterfilter_rec.CONTEXT := p_context;
964: l_counterfilter_rec.OBJECT_VERSION_NUMBER := p_object_version_number;
965: update_row(
966: p_api_version,
967: FND_API.G_TRUE ,
968: p_validation_level,
969: FND_API.G_TRUE ,
970: x_return_status,
971: x_msg_count,

Line 969: FND_API.G_TRUE ,

965: update_row(
966: p_api_version,
967: FND_API.G_TRUE ,
968: p_validation_level,
969: FND_API.G_TRUE ,
970: x_return_status,
971: x_msg_count,
972: x_msg_data,
973: l_counterfilter_rec,

Line 978: WHEN FND_API.G_EXC_ERROR THEN

974: x_object_version_number
975: );
976: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
977: EXCEPTION
978: WHEN FND_API.G_EXC_ERROR THEN
979: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
980: (
981: l_api_name,
982: G_PKG_NAME,

Line 983: 'FND_API.G_RET_STS_ERROR',

979: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
980: (
981: l_api_name,
982: G_PKG_NAME,
983: 'FND_API.G_RET_STS_ERROR',
984: x_msg_count,
985: x_msg_data,
986: '_Pvt'
987: );

Line 989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

985: x_msg_data,
986: '_Pvt'
987: );
988: APP_EXCEPTION.RAISE_EXCEPTION;
989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
990: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
991: (
992: l_api_name,
993: G_PKG_NAME,

Line 994: 'FND_API.G_RET_STS_UNEXP_ERROR',

990: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
991: (
992: l_api_name,
993: G_PKG_NAME,
994: 'FND_API.G_RET_STS_UNEXP_ERROR',
995: x_msg_count,
996: x_msg_data,
997: '_Pvt'
998: );

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

1021: p_counter_der_filter_id IN NUMBER
1022: ) IS
1023: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
1024: l_api_version CONSTANT NUMBER := 1;
1025: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1026: BEGIN
1027: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1028: G_PKG_NAME,
1029: l_api_version,

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

1030: p_api_version,
1031: p_init_msg_list,
1032: '_Pvt',
1033: x_return_status);
1034: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;

Line 1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1031: p_init_msg_list,
1032: '_Pvt',
1033: x_return_status);
1034: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: DELETE FROM CS_COUNTER_DER_FILTERS

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

1032: '_Pvt',
1033: x_return_status);
1034: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: DELETE FROM CS_COUNTER_DER_FILTERS
1040: WHERE

Line 1037: RAISE FND_API.G_EXC_ERROR;

1033: x_return_status);
1034: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1035: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1036: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1037: RAISE FND_API.G_EXC_ERROR;
1038: END IF;
1039: DELETE FROM CS_COUNTER_DER_FILTERS
1040: WHERE
1041: COUNTER_DER_FILTER_ID = p_counter_der_filter_id

Line 1045: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1050: 'FND_API.G_RET_STS_ERROR',

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

Line 1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1061: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

1087: x_msg_data OUT NOCOPY VARCHAR2,
1088: p_counterfilter_val_rec IN CounterFilter_Val_Rec_Type := G_MISS_COUNTERFILTER_VAL_REC) IS
1089: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1090: l_api_version CONSTANT NUMBER := 1;
1091: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1092: l_counterfilter_rec CounterFilter_Rec_Type;
1093: l_def_counterfilter_rec CounterFilter_Rec_Type;
1094: BEGIN
1095: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1098: p_api_version,
1099: p_init_msg_list,
1100: '_Pvt',
1101: x_return_status);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;

Line 1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1099: p_init_msg_list,
1100: '_Pvt',
1101: x_return_status);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: migrate(p_counterfilter_val_rec, l_counterfilter_rec);

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

1100: '_Pvt',
1101: x_return_status);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: migrate(p_counterfilter_val_rec, l_counterfilter_rec);
1108: --- Validate all non-missing attributes (Item Level Validation)

Line 1105: RAISE FND_API.G_EXC_ERROR;

1101: x_return_status);
1102: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1103: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1104: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: migrate(p_counterfilter_val_rec, l_counterfilter_rec);
1108: --- Validate all non-missing attributes (Item Level Validation)
1109: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1109: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1105: RAISE FND_API.G_EXC_ERROR;
1106: END IF;
1107: migrate(p_counterfilter_val_rec, l_counterfilter_rec);
1108: --- Validate all non-missing attributes (Item Level Validation)
1109: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1110: l_return_status := Validate_Item_Attributes
1111: (
1112: l_counterfilter_rec ---- IN
1113: );

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

1111: (
1112: l_counterfilter_rec ---- IN
1113: );
1114: --- If any errors happen abort API
1115: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;

Line 1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1112: l_counterfilter_rec ---- IN
1113: );
1114: --- If any errors happen abort API
1115: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;

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

1113: );
1114: --- If any errors happen abort API
1115: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;
1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1118: RAISE FND_API.G_EXC_ERROR;

1114: --- If any errors happen abort API
1115: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1116: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;
1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);

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

1117: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1118: RAISE FND_API.G_EXC_ERROR;
1119: END IF;
1120: END IF;
1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
1123: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

1119: END IF;
1120: END IF;
1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
1123: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;

Line 1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1120: END IF;
1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
1123: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: END IF;

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

1121: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
1123: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: END IF;
1129: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1126: RAISE FND_API.G_EXC_ERROR;

1122: l_return_status := Validate_Item_Record(l_def_counterfilter_rec);
1123: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1124: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1125: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1126: RAISE FND_API.G_EXC_ERROR;
1127: END IF;
1128: END IF;
1129: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1130: EXCEPTION

Line 1131: WHEN FND_API.G_EXC_ERROR THEN

1127: END IF;
1128: END IF;
1129: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1130: EXCEPTION
1131: WHEN FND_API.G_EXC_ERROR THEN
1132: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,

Line 1136: 'FND_API.G_RET_STS_ERROR',

1132: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1133: (
1134: l_api_name,
1135: G_PKG_NAME,
1136: 'FND_API.G_RET_STS_ERROR',
1137: x_msg_count,
1138: x_msg_data,
1139: '_Pvt'
1140: );

Line 1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1138: x_msg_data,
1139: '_Pvt'
1140: );
1141: APP_EXCEPTION.RAISE_EXCEPTION;
1142: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1143: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1144: (
1145: l_api_name,
1146: G_PKG_NAME,

Line 1147: 'FND_API.G_RET_STS_UNEXP_ERROR',

1143: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1144: (
1145: l_api_name,
1146: G_PKG_NAME,
1147: 'FND_API.G_RET_STS_UNEXP_ERROR',
1148: x_msg_count,
1149: x_msg_data,
1150: '_Pvt'
1151: );

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

1203: p_context IN CS_COUNTER_DER_FILTERS.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1204: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1205: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1206: l_api_version CONSTANT NUMBER := 1;
1207: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1208: l_counterfilter_rec CounterFilter_Val_Rec_Type;
1209: BEGIN
1210: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1211: G_PKG_NAME,

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

1213: p_api_version,
1214: p_init_msg_list,
1215: '_Pvt',
1216: x_return_status);
1217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;

Line 1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1214: p_init_msg_list,
1215: '_Pvt',
1216: x_return_status);
1217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;

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

1215: '_Pvt',
1216: x_return_status);
1217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;
1223: l_counterfilter_rec.COUNTER_ID := p_counter_id;

Line 1220: RAISE FND_API.G_EXC_ERROR;

1216: x_return_status);
1217: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1218: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1219: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1220: RAISE FND_API.G_EXC_ERROR;
1221: END IF;
1222: l_counterfilter_rec.COUNTER_DER_FILTER_ID := p_counter_der_filter_id;
1223: l_counterfilter_rec.COUNTER_ID := p_counter_id;
1224: l_counterfilter_rec.SEQ_NO := p_seq_no;

Line 1265: WHEN FND_API.G_EXC_ERROR THEN

1261: l_counterfilter_rec
1262: );
1263: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1264: EXCEPTION
1265: WHEN FND_API.G_EXC_ERROR THEN
1266: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1267: (
1268: l_api_name,
1269: G_PKG_NAME,

Line 1270: 'FND_API.G_RET_STS_ERROR',

1266: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1267: (
1268: l_api_name,
1269: G_PKG_NAME,
1270: 'FND_API.G_RET_STS_ERROR',
1271: x_msg_count,
1272: x_msg_data,
1273: '_Pvt'
1274: );

Line 1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1272: x_msg_data,
1273: '_Pvt'
1274: );
1275: APP_EXCEPTION.RAISE_EXCEPTION;
1276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1277: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1278: (
1279: l_api_name,
1280: G_PKG_NAME,

Line 1281: 'FND_API.G_RET_STS_UNEXP_ERROR',

1277: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1278: (
1279: l_api_name,
1280: G_PKG_NAME,
1281: 'FND_API.G_RET_STS_UNEXP_ERROR',
1282: x_msg_count,
1283: x_msg_data,
1284: '_Pvt'
1285: );