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

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

18: p_timezone_rec IN TimeZone_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_timezone_rec.name = TAPI_DEV_KIT.G_MISS_CHAR OR
25: p_timezone_rec.name IS NULL
26: THEN

Line 28: l_return_status := FND_API.G_RET_STS_ERROR;

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

Line 33: l_return_status := FND_API.G_RET_STS_ERROR;

29: ELSIF p_timezone_rec.offset_time = TAPI_DEV_KIT.G_MISS_DATE OR
30: p_timezone_rec.offset_time IS NULL
31: THEN
32: TAPI_DEV_KIT.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'offset_time');
33: l_return_status := FND_API.G_RET_STS_ERROR;
34: ELSIF p_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_timezone_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_timezone_rec.last_update_date = TAPI_DEV_KIT.G_MISS_DATE OR
35: p_timezone_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_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_timezone_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_timezone_rec.last_updated_by = TAPI_DEV_KIT.G_MISS_NUM OR
40: p_timezone_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_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_timezone_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_timezone_rec.creation_date = TAPI_DEV_KIT.G_MISS_DATE OR
45: p_timezone_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_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_timezone_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_timezone_rec.created_by = TAPI_DEV_KIT.G_MISS_NUM OR
50: p_timezone_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_timezone_rec OUT TimeZone_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_timezone_rec := p_timezone_rec;
70: l_def_timezone_rec.OBJECT_VERSION_NUMBER := NVL(l_def_timezone_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_timezone_rec IN TimeZone_Rec_Type
77: )
78: RETURN VARCHAR2 IS
79: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
80: BEGIN
81: RETURN (l_return_status);
82: END Validate_Item_Record;
83:

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

165: x_time_zone_id OUT NUMBER,
166: x_object_version_number OUT NUMBER) IS
167: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
168: l_api_version CONSTANT NUMBER := 1;
169: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
170: l_timezone_rec TimeZone_Rec_Type;
171: l_def_timezone_rec TimeZone_Rec_Type;
172: BEGIN
173: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

176: p_api_version,
177: p_init_msg_list,
178: '_Pvt',
179: x_return_status);
180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;

Line 181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

177: p_init_msg_list,
178: '_Pvt',
179: x_return_status);
180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: l_timezone_rec := p_timezone_rec;

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

178: '_Pvt',
179: x_return_status);
180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: l_timezone_rec := p_timezone_rec;
186: --- Validate all non-missing attributes (Item Level Validation)

Line 183: RAISE FND_API.G_EXC_ERROR;

179: x_return_status);
180: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
182: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: l_timezone_rec := p_timezone_rec;
186: --- Validate all non-missing attributes (Item Level Validation)
187: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 187: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

183: RAISE FND_API.G_EXC_ERROR;
184: END IF;
185: l_timezone_rec := p_timezone_rec;
186: --- Validate all non-missing attributes (Item Level Validation)
187: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
188: l_return_status := Validate_Item_Attributes
189: (
190: l_timezone_rec ---- IN
191: );

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

189: (
190: l_timezone_rec ---- IN
191: );
192: --- If any errors happen abort API
193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;

Line 194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

190: l_timezone_rec ---- IN
191: );
192: --- If any errors happen abort API
193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: END IF;

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

191: );
192: --- If any errors happen abort API
193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: END IF;
199: --- Defaulting item attributes

Line 196: RAISE FND_API.G_EXC_ERROR;

192: --- If any errors happen abort API
193: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
196: RAISE FND_API.G_EXC_ERROR;
197: END IF;
198: END IF;
199: --- Defaulting item attributes
200: l_return_status := Default_Item_Attributes

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

202: l_timezone_rec, ---- IN
203: l_def_timezone_rec
204: );
205: --- If any errors happen abort API
206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: l_def_timezone_rec
204: );
205: --- If any errors happen abort API
206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

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

204: );
205: --- If any errors happen abort API
206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);

Line 209: RAISE FND_API.G_EXC_ERROR;

205: --- If any errors happen abort API
206: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

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

207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;

Line 214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

210: END IF;
211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: END IF;

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

211: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: END IF;
219: -- Set primary key value

Line 216: RAISE FND_API.G_EXC_ERROR;

212: l_return_status := Validate_Item_Record(l_def_timezone_rec);
213: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
215: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
216: RAISE FND_API.G_EXC_ERROR;
217: END IF;
218: END IF;
219: -- Set primary key value
220: l_def_timezone_rec.time_zone_id := get_seq_id;

Line 286: WHEN FND_API.G_EXC_ERROR THEN

282: x_time_zone_id := l_def_timezone_rec.time_zone_id;
283: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
284: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
288: (
289: l_api_name,
290: G_PKG_NAME,

Line 291: 'FND_API.G_RET_STS_ERROR',

287: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
288: (
289: l_api_name,
290: G_PKG_NAME,
291: 'FND_API.G_RET_STS_ERROR',
292: x_msg_count,
293: x_msg_data,
294: '_Pvt'
295: );

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

293: x_msg_data,
294: '_Pvt'
295: );
296: APP_EXCEPTION.RAISE_EXCEPTION;
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
299: (
300: l_api_name,
301: G_PKG_NAME,

Line 302: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

357: x_time_zone_id OUT NUMBER,
358: x_object_version_number OUT NUMBER) IS
359: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
360: l_api_version CONSTANT NUMBER := 1;
361: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
362: l_timezone_rec TimeZone_Rec_Type;
363: BEGIN
364: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
365: G_PKG_NAME,

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

367: p_api_version,
368: p_init_msg_list,
369: '_Pvt',
370: x_return_status);
371: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;

Line 372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

368: p_init_msg_list,
369: '_Pvt',
370: x_return_status);
371: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376: l_timezone_rec.NAME := p_name;

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

369: '_Pvt',
370: x_return_status);
371: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376: l_timezone_rec.NAME := p_name;
377: l_timezone_rec.DESCRIPTION := p_description;

Line 374: RAISE FND_API.G_EXC_ERROR;

370: x_return_status);
371: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
373: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
374: RAISE FND_API.G_EXC_ERROR;
375: END IF;
376: l_timezone_rec.NAME := p_name;
377: l_timezone_rec.DESCRIPTION := p_description;
378: l_timezone_rec.OFFSET_INDICATOR := p_offset_indicator;

Line 418: WHEN FND_API.G_EXC_ERROR THEN

414: x_object_version_number
415: );
416: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
420: (
421: l_api_name,
422: G_PKG_NAME,

Line 423: 'FND_API.G_RET_STS_ERROR',

419: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
420: (
421: l_api_name,
422: G_PKG_NAME,
423: 'FND_API.G_RET_STS_ERROR',
424: x_msg_count,
425: x_msg_data,
426: '_Pvt'
427: );

Line 429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

425: x_msg_data,
426: '_Pvt'
427: );
428: APP_EXCEPTION.RAISE_EXCEPTION;
429: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
430: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
431: (
432: l_api_name,
433: G_PKG_NAME,

Line 434: 'FND_API.G_RET_STS_UNEXP_ERROR',

430: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
431: (
432: l_api_name,
433: G_PKG_NAME,
434: 'FND_API.G_RET_STS_UNEXP_ERROR',
435: x_msg_count,
436: x_msg_data,
437: '_Pvt'
438: );

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

477: TIME_ZONE_ID = p_time_zone_id
478: ;
479: l_api_name CONSTANT VARCHAR2(30) := 'lock_row';
480: l_api_version CONSTANT NUMBER := 1;
481: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
482: l_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;
483: lc_object_version_number CS_TIME_ZONES.OBJECT_VERSION_NUMBER%TYPE;
484: l_row_notfound BOOLEAN := FALSE;
485: lc_row_notfound BOOLEAN := FALSE;

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

490: p_api_version,
491: p_init_msg_list,
492: '_Pvt',
493: x_return_status);
494: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;

Line 495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

491: p_init_msg_list,
492: '_Pvt',
493: x_return_status);
494: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: BEGIN

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

492: '_Pvt',
493: x_return_status);
494: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: BEGIN
500: OPEN lock_csr;

Line 497: RAISE FND_API.G_EXC_ERROR;

493: x_return_status);
494: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
496: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: BEGIN
500: OPEN lock_csr;
501: FETCH lock_csr INTO l_object_version_number;

Line 521: RAISE FND_API.G_EXC_ERROR;

517: CLOSE lchk_csr;
518: END IF;
519: IF (lc_row_notfound) THEN
520: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF lc_object_version_number > p_object_version_number THEN
523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN

Line 524: RAISE FND_API.G_EXC_ERROR;

520: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
521: RAISE FND_API.G_EXC_ERROR;
522: ELSIF lc_object_version_number > p_object_version_number THEN
523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN
526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF lc_object_version_number = -1 THEN

Line 527: RAISE FND_API.G_EXC_ERROR;

523: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
524: RAISE FND_API.G_EXC_ERROR;
525: ELSIF lc_object_version_number <> p_object_version_number THEN
526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF lc_object_version_number = -1 THEN
529: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;

Line 530: RAISE FND_API.G_EXC_ERROR;

526: TAPI_DEV_KIT.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
527: RAISE FND_API.G_EXC_ERROR;
528: ELSIF lc_object_version_number = -1 THEN
529: TAPI_DEV_KIT.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN

Line 534: WHEN FND_API.G_EXC_ERROR THEN

530: RAISE FND_API.G_EXC_ERROR;
531: END IF;
532: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
533: EXCEPTION
534: WHEN FND_API.G_EXC_ERROR THEN
535: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
536: (
537: l_api_name,
538: G_PKG_NAME,

Line 539: 'FND_API.G_RET_STS_ERROR',

535: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
536: (
537: l_api_name,
538: G_PKG_NAME,
539: 'FND_API.G_RET_STS_ERROR',
540: x_msg_count,
541: x_msg_data,
542: '_Pvt'
543: );

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: x_msg_data,
542: '_Pvt'
543: );
544: APP_EXCEPTION.RAISE_EXCEPTION;
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
547: (
548: l_api_name,
549: G_PKG_NAME,

Line 550: 'FND_API.G_RET_STS_UNEXP_ERROR',

546: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
547: (
548: l_api_name,
549: G_PKG_NAME,
550: 'FND_API.G_RET_STS_UNEXP_ERROR',
551: x_msg_count,
552: x_msg_data,
553: '_Pvt'
554: );

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

577: p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC,
578: x_object_version_number OUT NUMBER) IS
579: l_api_name CONSTANT VARCHAR2(30) := 'update_row';
580: l_api_version CONSTANT NUMBER := 1;
581: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
582: l_timezone_rec TimeZone_Rec_Type;
583: l_def_timezone_rec TimeZone_Rec_Type;
584: FUNCTION populate_new_record (
585: p_timezone_rec IN TimeZone_Rec_Type,

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

590: FROM Cs_Time_Zones
591: WHERE cs_time_zones.time_zone_id = p_time_zone_id;
592: l_cs_time_zones_pk cs_time_zones_pk_csr%ROWTYPE;
593: l_row_notfound BOOLEAN := TRUE;
594: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
595: BEGIN
596: x_timezone_rec := p_timezone_rec;
597: -- Get current database values
598: OPEN cs_time_zones_pk_csr (p_timezone_rec.time_zone_id);

Line 603: l_return_status := FND_API.G_RET_STS_ERROR;

599: FETCH cs_time_zones_pk_csr INTO l_cs_time_zones_pk;
600: l_row_notfound := cs_time_zones_pk_csr%NOTFOUND;
601: CLOSE cs_time_zones_pk_csr;
602: IF (l_row_notfound) THEN
603: l_return_status := FND_API.G_RET_STS_ERROR;
604: END IF;
605: IF (x_timezone_rec.time_zone_id = TAPI_DEV_KIT.G_MISS_NUM)
606: THEN
607: x_timezone_rec.time_zone_id := l_cs_time_zones_pk.time_zone_id;

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

727: p_api_version,
728: p_init_msg_list,
729: '_Pvt',
730: x_return_status);
731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;

Line 732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

728: p_init_msg_list,
729: '_Pvt',
730: x_return_status);
731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: migrate(p_timezone_val_rec, l_timezone_rec);

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

729: '_Pvt',
730: x_return_status);
731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: migrate(p_timezone_val_rec, l_timezone_rec);
737: --- Defaulting item attributes

Line 734: RAISE FND_API.G_EXC_ERROR;

730: x_return_status);
731: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
732: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
733: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
734: RAISE FND_API.G_EXC_ERROR;
735: END IF;
736: migrate(p_timezone_val_rec, l_timezone_rec);
737: --- Defaulting item attributes
738: l_return_status := Default_Item_Attributes

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

740: l_timezone_rec, ---- IN
741: l_def_timezone_rec
742: );
743: --- If any errors happen abort API
744: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

741: l_def_timezone_rec
742: );
743: --- If any errors happen abort API
744: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);

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

742: );
743: --- If any errors happen abort API
744: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

Line 747: RAISE FND_API.G_EXC_ERROR;

743: --- If any errors happen abort API
744: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

746: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;

Line 751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

747: RAISE FND_API.G_EXC_ERROR;
748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: --- Validate all non-missing attributes (Item Level Validation)

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

748: END IF;
749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: --- Validate all non-missing attributes (Item Level Validation)
756: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 753: RAISE FND_API.G_EXC_ERROR;

749: l_return_status := populate_new_record(l_def_timezone_rec, l_def_timezone_rec);
750: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
751: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: --- Validate all non-missing attributes (Item Level Validation)
756: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
757: l_return_status := Validate_Item_Attributes

Line 756: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

752: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
753: RAISE FND_API.G_EXC_ERROR;
754: END IF;
755: --- Validate all non-missing attributes (Item Level Validation)
756: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
757: l_return_status := Validate_Item_Attributes
758: (
759: l_def_timezone_rec ---- IN
760: );

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

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

Line 763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 765: RAISE FND_API.G_EXC_ERROR;

761: --- If any errors happen abort API
762: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: END IF;
768: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
769: l_return_status := Validate_Item_Record(l_def_timezone_rec);

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

764: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
765: RAISE FND_API.G_EXC_ERROR;
766: END IF;
767: END IF;
768: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
769: l_return_status := Validate_Item_Record(l_def_timezone_rec);
770: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

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

766: END IF;
767: END IF;
768: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
769: l_return_status := Validate_Item_Record(l_def_timezone_rec);
770: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;

Line 771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

767: END IF;
768: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
769: l_return_status := Validate_Item_Record(l_def_timezone_rec);
770: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;

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

768: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
769: l_return_status := Validate_Item_Record(l_def_timezone_rec);
770: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;
776: UPDATE CS_TIME_ZONES

Line 773: RAISE FND_API.G_EXC_ERROR;

769: l_return_status := Validate_Item_Record(l_def_timezone_rec);
770: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
772: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
773: RAISE FND_API.G_EXC_ERROR;
774: END IF;
775: END IF;
776: UPDATE CS_TIME_ZONES
777: SET

Line 813: WHEN FND_API.G_EXC_ERROR THEN

809: ;
810: x_object_version_number := l_def_timezone_rec.OBJECT_VERSION_NUMBER;
811: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
812: EXCEPTION
813: WHEN FND_API.G_EXC_ERROR THEN
814: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
815: (
816: l_api_name,
817: G_PKG_NAME,

Line 818: 'FND_API.G_RET_STS_ERROR',

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

Line 824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 829: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

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

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

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

Line 899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

895: p_init_msg_list,
896: '_Pvt',
897: x_return_status);
898: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;

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

896: '_Pvt',
897: x_return_status);
898: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;
904: l_timezone_rec.NAME := p_name;

Line 901: RAISE FND_API.G_EXC_ERROR;

897: x_return_status);
898: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
899: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
900: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
901: RAISE FND_API.G_EXC_ERROR;
902: END IF;
903: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;
904: l_timezone_rec.NAME := p_name;
905: l_timezone_rec.DESCRIPTION := p_description;

Line 945: WHEN FND_API.G_EXC_ERROR THEN

941: x_object_version_number
942: );
943: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
944: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
947: (
948: l_api_name,
949: G_PKG_NAME,

Line 950: 'FND_API.G_RET_STS_ERROR',

946: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
947: (
948: l_api_name,
949: G_PKG_NAME,
950: 'FND_API.G_RET_STS_ERROR',
951: x_msg_count,
952: x_msg_data,
953: '_Pvt'
954: );

Line 956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

952: x_msg_data,
953: '_Pvt'
954: );
955: APP_EXCEPTION.RAISE_EXCEPTION;
956: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
957: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
958: (
959: l_api_name,
960: G_PKG_NAME,

Line 961: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

987: x_msg_data OUT VARCHAR2,
988: p_time_zone_id IN NUMBER) IS
989: l_api_name CONSTANT VARCHAR2(30) := 'delete_row';
990: l_api_version CONSTANT NUMBER := 1;
991: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
992: BEGIN
993: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
994: G_PKG_NAME,
995: l_api_version,

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

996: p_api_version,
997: p_init_msg_list,
998: '_Pvt',
999: x_return_status);
1000: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;

Line 1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

997: p_init_msg_list,
998: '_Pvt',
999: x_return_status);
1000: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: DELETE FROM CS_TIME_ZONES

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

998: '_Pvt',
999: x_return_status);
1000: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: DELETE FROM CS_TIME_ZONES
1006: WHERE

Line 1003: RAISE FND_API.G_EXC_ERROR;

999: x_return_status);
1000: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1001: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1002: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1003: RAISE FND_API.G_EXC_ERROR;
1004: END IF;
1005: DELETE FROM CS_TIME_ZONES
1006: WHERE
1007: TIME_ZONE_ID = p_time_zone_id

Line 1011: WHEN FND_API.G_EXC_ERROR THEN

1007: TIME_ZONE_ID = p_time_zone_id
1008: ;
1009: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1010: EXCEPTION
1011: WHEN FND_API.G_EXC_ERROR THEN
1012: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1013: (
1014: l_api_name,
1015: G_PKG_NAME,

Line 1016: 'FND_API.G_RET_STS_ERROR',

1012: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1013: (
1014: l_api_name,
1015: G_PKG_NAME,
1016: 'FND_API.G_RET_STS_ERROR',
1017: x_msg_count,
1018: x_msg_data,
1019: '_Pvt'
1020: );

Line 1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1018: x_msg_data,
1019: '_Pvt'
1020: );
1021: APP_EXCEPTION.RAISE_EXCEPTION;
1022: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1023: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1024: (
1025: l_api_name,
1026: G_PKG_NAME,

Line 1027: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

1053: x_msg_data OUT VARCHAR2,
1054: p_timezone_val_rec IN TimeZone_Val_Rec_Type := G_MISS_TIMEZONE_VAL_REC) IS
1055: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1056: l_api_version CONSTANT NUMBER := 1;
1057: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1058: l_timezone_rec TimeZone_Rec_Type;
1059: l_def_timezone_rec TimeZone_Rec_Type;
1060: BEGIN
1061: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,

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

1064: p_api_version,
1065: p_init_msg_list,
1066: '_Pvt',
1067: x_return_status);
1068: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;

Line 1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1065: p_init_msg_list,
1066: '_Pvt',
1067: x_return_status);
1068: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: migrate(p_timezone_val_rec, l_timezone_rec);

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

1066: '_Pvt',
1067: x_return_status);
1068: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: migrate(p_timezone_val_rec, l_timezone_rec);
1074: --- Validate all non-missing attributes (Item Level Validation)

Line 1071: RAISE FND_API.G_EXC_ERROR;

1067: x_return_status);
1068: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1069: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1070: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: migrate(p_timezone_val_rec, l_timezone_rec);
1074: --- Validate all non-missing attributes (Item Level Validation)
1075: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

Line 1075: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN

1071: RAISE FND_API.G_EXC_ERROR;
1072: END IF;
1073: migrate(p_timezone_val_rec, l_timezone_rec);
1074: --- Validate all non-missing attributes (Item Level Validation)
1075: IF p_validation_level >= FND_API.G_VALID_LEVEL_FULL THEN
1076: l_return_status := Validate_Item_Attributes
1077: (
1078: l_timezone_rec ---- IN
1079: );

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

1077: (
1078: l_timezone_rec ---- IN
1079: );
1080: --- If any errors happen abort API
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;

Line 1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1078: l_timezone_rec ---- IN
1079: );
1080: --- If any errors happen abort API
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;

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

1079: );
1080: --- If any errors happen abort API
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;
1087: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

Line 1084: RAISE FND_API.G_EXC_ERROR;

1080: --- If any errors happen abort API
1081: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1083: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: END IF;
1087: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1088: l_return_status := Validate_Item_Record(l_def_timezone_rec);

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

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

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

1085: END IF;
1086: END IF;
1087: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1088: l_return_status := Validate_Item_Record(l_def_timezone_rec);
1089: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;

Line 1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1086: END IF;
1087: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1088: l_return_status := Validate_Item_Record(l_def_timezone_rec);
1089: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;

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

1087: IF (p_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
1088: l_return_status := Validate_Item_Record(l_def_timezone_rec);
1089: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);

Line 1092: RAISE FND_API.G_EXC_ERROR;

1088: l_return_status := Validate_Item_Record(l_def_timezone_rec);
1089: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1090: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1091: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1092: RAISE FND_API.G_EXC_ERROR;
1093: END IF;
1094: END IF;
1095: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1096: EXCEPTION

Line 1097: WHEN FND_API.G_EXC_ERROR THEN

1093: END IF;
1094: END IF;
1095: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1099: (
1100: l_api_name,
1101: G_PKG_NAME,

Line 1102: 'FND_API.G_RET_STS_ERROR',

1098: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1099: (
1100: l_api_name,
1101: G_PKG_NAME,
1102: 'FND_API.G_RET_STS_ERROR',
1103: x_msg_count,
1104: x_msg_data,
1105: '_Pvt'
1106: );

Line 1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1104: x_msg_data,
1105: '_Pvt'
1106: );
1107: APP_EXCEPTION.RAISE_EXCEPTION;
1108: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1109: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1110: (
1111: l_api_name,
1112: G_PKG_NAME,

Line 1113: 'FND_API.G_RET_STS_UNEXP_ERROR',

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

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

1167: p_context IN CS_TIME_ZONES.CONTEXT%TYPE := TAPI_DEV_KIT.G_MISS_CHAR,
1168: p_object_version_number IN NUMBER := TAPI_DEV_KIT.G_MISS_NUM) IS
1169: l_api_name CONSTANT VARCHAR2(30) := 'validate_row';
1170: l_api_version CONSTANT NUMBER := 1;
1171: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1172: l_timezone_rec TimeZone_Val_Rec_Type;
1173: BEGIN
1174: l_return_status := TAPI_DEV_KIT.START_ACTIVITY(l_api_name,
1175: G_PKG_NAME,

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

1177: p_api_version,
1178: p_init_msg_list,
1179: '_Pvt',
1180: x_return_status);
1181: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;

Line 1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1178: p_init_msg_list,
1179: '_Pvt',
1180: x_return_status);
1181: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;

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

1179: '_Pvt',
1180: x_return_status);
1181: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;
1187: l_timezone_rec.NAME := p_name;

Line 1184: RAISE FND_API.G_EXC_ERROR;

1180: x_return_status);
1181: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1182: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1183: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1184: RAISE FND_API.G_EXC_ERROR;
1185: END IF;
1186: l_timezone_rec.TIME_ZONE_ID := p_time_zone_id;
1187: l_timezone_rec.NAME := p_name;
1188: l_timezone_rec.DESCRIPTION := p_description;

Line 1227: WHEN FND_API.G_EXC_ERROR THEN

1223: l_timezone_rec
1224: );
1225: TAPI_DEV_KIT.END_ACTIVITY(p_commit, x_msg_count, x_msg_data);
1226: EXCEPTION
1227: WHEN FND_API.G_EXC_ERROR THEN
1228: x_return_status := TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1229: (
1230: l_api_name,
1231: G_PKG_NAME,

Line 1232: 'FND_API.G_RET_STS_ERROR',

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

Line 1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1234: x_msg_data,
1235: '_Pvt'
1236: );
1237: APP_EXCEPTION.RAISE_EXCEPTION;
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: x_return_status :=TAPI_DEV_KIT.HANDLE_EXCEPTIONS
1240: (
1241: l_api_name,
1242: G_PKG_NAME,

Line 1243: 'FND_API.G_RET_STS_UNEXP_ERROR',

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