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.IBE_DSP_MSITE_SCT_SECT_PVT dependencies on FND_API

Line 74: (x_mini_site_section_section_id = FND_API.G_MISS_NUM))

70:
71: -- Primary key validation check
72: x_mini_site_section_section_id := p_mini_site_section_section_id;
73: IF ((x_mini_site_section_section_id IS NULL) OR
74: (x_mini_site_section_section_id = FND_API.G_MISS_NUM))
75: THEN
76: OPEN c2;
77: FETCH c2 INTO x_mini_site_section_section_id;
78: CLOSE c2;

Line 105: decode(p_parent_section_id, FND_API.G_MISS_NUM, NULL, p_parent_section_id),

101: (
102: x_mini_site_section_section_id,
103: p_object_version_number,
104: p_mini_site_id,
105: decode(p_parent_section_id, FND_API.G_MISS_NUM, NULL, p_parent_section_id),
106: p_child_section_id,
107: p_start_date_active,
108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),

Line 108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),

104: p_mini_site_id,
105: decode(p_parent_section_id, FND_API.G_MISS_NUM, NULL, p_parent_section_id),
106: p_child_section_id,
107: p_start_date_active,
108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),
110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),

105: decode(p_parent_section_id, FND_API.G_MISS_NUM, NULL, p_parent_section_id),
106: p_child_section_id,
107: p_start_date_active,
108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),
110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),

Line 110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),

106: p_child_section_id,
107: p_start_date_active,
108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),
110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),

107: p_start_date_active,
108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),
110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),

Line 112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

108: decode(p_end_date_active, FND_API.G_MISS_DATE, NULL, p_end_date_active),
109: decode(p_level_number, FND_API.G_MISS_NUM, NULL, p_level_number),
110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

Line 114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

110: decode(p_sort_order, FND_API.G_MISS_NUM, NULL, p_sort_order),
111: decode(p_concat_ids, FND_API.G_MISS_CHAR, NULL, p_concat_ids),
112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

Line 116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,

112: decode(p_creation_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
113: p_creation_date),
114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

Line 118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,

114: decode(p_created_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
115: NULL, FND_GLOBAL.user_id, p_created_by),
116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );

Line 120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,

116: decode(p_last_update_date, FND_API.G_MISS_DATE, sysdate, NULL, sysdate,
117: p_last_update_date),
118: decode(p_last_updated_by, FND_API.G_MISS_NUM, FND_GLOBAL.user_id,
119: NULL, FND_GLOBAL.user_id, p_last_updated_by),
120: decode(p_last_update_login, FND_API.G_MISS_NUM, FND_GLOBAL.login_id,
121: NULL, FND_GLOBAL.login_id, p_last_update_login)
122: );
123:
124: OPEN c;

Line 142: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

138:
139: PROCEDURE update_row
140: (
141: p_mini_site_section_section_id IN NUMBER,
142: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
143: p_start_date_active IN DATE,
144: p_end_date_active IN DATE,
145: p_level_number IN NUMBER,
146: p_sort_order IN NUMBER,

Line 158: level_number = decode(p_level_number, FND_API.G_MISS_NUM,

154:
155: -- update base
156: UPDATE ibe_dsp_msite_sct_sects SET
157: object_version_number = object_version_number + 1,
158: level_number = decode(p_level_number, FND_API.G_MISS_NUM,
159: level_number, p_level_number),
160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
161: sort_order, p_sort_order),
162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,

Line 160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,

156: UPDATE ibe_dsp_msite_sct_sects SET
157: object_version_number = object_version_number + 1,
158: level_number = decode(p_level_number, FND_API.G_MISS_NUM,
159: level_number, p_level_number),
160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
161: sort_order, p_sort_order),
162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,
163: concat_ids, p_concat_ids),
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

Line 162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,

158: level_number = decode(p_level_number, FND_API.G_MISS_NUM,
159: level_number, p_level_number),
160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
161: sort_order, p_sort_order),
162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,
163: concat_ids, p_concat_ids),
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

Line 164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,

160: sort_order = decode(p_sort_order, FND_API.G_MISS_NUM,
161: sort_order, p_sort_order),
162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,
163: concat_ids, p_concat_ids),
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,

Line 166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,

162: concat_ids = decode(p_concat_ids, FND_API.G_MISS_CHAR,
163: concat_ids, p_concat_ids),
164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

Line 168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,

164: start_date_active = decode(p_start_date_active, FND_API.G_MISS_DATE,
165: start_date_active, p_start_date_active),
166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),

Line 170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,

166: end_date_active = decode(p_end_date_active, FND_API.G_MISS_DATE,
167: end_date_active, p_end_date_active),
168: last_update_date = decode(p_last_update_date, FND_API.G_MISS_DATE,
169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,

Line 173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,

169: sysdate, NULL, sysdate, p_last_update_date),
170: last_updated_by = decode(p_last_updated_by, FND_API.G_MISS_NUM,
171: FND_GLOBAL.user_id, NULL, FND_GLOBAL.user_id,
172: p_last_updated_by),
173: last_update_login = decode(p_last_update_login, FND_API.G_MISS_NUM,
174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE mini_site_section_section_id = p_mini_site_section_section_id
177: AND object_version_number = decode(p_object_version_number,

Line 178: FND_API.G_MISS_NUM,

174: FND_GLOBAL.login_id, NULL,
175: FND_GLOBAL.login_id, p_last_update_login)
176: WHERE mini_site_section_section_id = p_mini_site_section_section_id
177: AND object_version_number = decode(p_object_version_number,
178: FND_API.G_MISS_NUM,
179: object_version_number,
180: p_object_version_number);
181:
182: IF (sql%NOTFOUND) THEN

Line 216: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,

212: PROCEDURE load_row
213: (
214: p_owner IN VARCHAR2,
215: p_mini_site_section_section_id IN NUMBER,
216: p_object_version_number IN NUMBER := FND_API.G_MISS_NUM,
217: p_mini_site_id IN NUMBER,
218: p_parent_section_id IN NUMBER,
219: p_child_section_id IN NUMBER,
220: p_start_date_active IN DATE,

Line 248: (p_object_version_number <> FND_API.G_MISS_NUM))

244: where mini_site_id = p_mini_site_id and child_section_id=p_child_section_id;
245:
246:
247: IF ((p_object_version_number IS NOT NULL) AND
248: (p_object_version_number <> FND_API.G_MISS_NUM))
249: THEN
250: l_object_version_number := p_object_version_number;
251: END IF;
252:

Line 316: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate

312: -- PROCEDURE Check_Duplicate_Entry()
313: --*****************************************************************************
314:
315: --
316: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
317: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
318: --
319: --
320: PROCEDURE Check_Duplicate_Entry

Line 317: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate

313: --*****************************************************************************
314:
315: --
316: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
317: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
318: --
319: --
320: PROCEDURE Check_Duplicate_Entry
321: (

Line 322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

318: --
319: --
320: PROCEDURE Check_Duplicate_Entry
321: (
322: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
323: p_mini_site_id IN NUMBER,
324: p_parent_section_id IN NUMBER,
325: p_child_section_id IN NUMBER,
326: x_return_status OUT NOCOPY VARCHAR2,

Line 338: IF FND_API.to_Boolean(p_init_msg_list) THEN

334: l_tmp_msite_sct_sect_id NUMBER;
335: BEGIN
336:
337: -- Initialize message list if p_init_msg_list is set to TRUE.
338: IF FND_API.to_Boolean(p_init_msg_list) THEN
339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initialize API return status to error, i.e, its not duplicate

Line 343: x_return_status := FND_API.G_RET_STS_ERROR;

339: FND_MSG_PUB.initialize;
340: END IF;
341:
342: -- Initialize API return status to error, i.e, its not duplicate
343: x_return_status := FND_API.G_RET_STS_ERROR;
344:
345: -- Check duplicate entry
346: BEGIN
347:

Line 380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

376: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
377: FND_MESSAGE.Set_Token('REASON', SQLERRM);
378: FND_MSG_PUB.Add;
379:
380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381:
382: END;
383:
384: IF (l_tmp_msite_sct_sect_id IS NOT NULL) THEN

Line 386: RAISE FND_API.G_EXC_ERROR;

382: END;
383:
384: IF (l_tmp_msite_sct_sect_id IS NOT NULL) THEN
385: -- found duplicate
386: RAISE FND_API.G_EXC_ERROR;
387: END IF;
388:
389: EXCEPTION
390:

Line 391: WHEN FND_API.G_EXC_ERROR THEN

387: END IF;
388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => 'F');

Line 392: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate

388:
389: EXCEPTION
390:
391: WHEN FND_API.G_EXC_ERROR THEN
392: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => 'F');
396:

Line 397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

393: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
394: p_data => x_msg_data,
395: p_encoded => 'F');
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => 'F');

Line 398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

394: p_data => x_msg_data,
395: p_encoded => 'F');
396:
397: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
398: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
399: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
400: p_data => x_msg_data,
401: p_encoded => 'F');
402:

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
407: FND_MESSAGE.Set_Token('REASON', SQLERRM);
408: FND_MSG_PUB.Add;
409:
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411:
412: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
413: THEN
414: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 427: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

423:
424: --*****************************************************************************
425: -- PROCEDURE Validate_Create()
426: --*****************************************************************************
427: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
428: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
429:
430: PROCEDURE Validate_Create
431: (

Line 428: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

424: --*****************************************************************************
425: -- PROCEDURE Validate_Create()
426: --*****************************************************************************
427: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
428: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
429:
430: PROCEDURE Validate_Create
431: (
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

428: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
429:
430: PROCEDURE Validate_Create
431: (
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434: p_mini_site_id IN NUMBER,
435: p_parent_section_id IN NUMBER,
436: p_child_section_id IN NUMBER,

Line 433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

429:
430: PROCEDURE Validate_Create
431: (
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
434: p_mini_site_id IN NUMBER,
435: p_parent_section_id IN NUMBER,
436: p_child_section_id IN NUMBER,
437: p_start_date_active IN DATE,

Line 459: IF FND_API.to_Boolean(p_init_msg_list) THEN

455: l_return_status VARCHAR2(1);
456: BEGIN
457:
458: -- Initialize message list if p_init_msg_list is set to TRUE.
459: IF FND_API.to_Boolean(p_init_msg_list) THEN
460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Initialize API return status to success

Line 464: x_return_status := FND_API.G_RET_STS_SUCCESS;

460: FND_MSG_PUB.initialize;
461: END IF;
462:
463: -- Initialize API return status to success
464: x_return_status := FND_API.G_RET_STS_SUCCESS;
465:
466: --
467: -- Check null values for required fields
468: --

Line 472: (p_mini_site_id = FND_API.G_MISS_NUM))

468: --
469:
470: -- mini site id
471: IF ((p_mini_site_id IS NULL) OR
472: (p_mini_site_id = FND_API.G_MISS_NUM))
473: THEN
474: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');
475: FND_MSG_PUB.Add;
476: RAISE FND_API.G_EXC_ERROR;

Line 476: RAISE FND_API.G_EXC_ERROR;

472: (p_mini_site_id = FND_API.G_MISS_NUM))
473: THEN
474: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_MSITE_ID');
475: FND_MSG_PUB.Add;
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: -- child section id
480: IF ((p_child_section_id IS NULL) OR

Line 481: (p_child_section_id = FND_API.G_MISS_NUM))

477: END IF;
478:
479: -- child section id
480: IF ((p_child_section_id IS NULL) OR
481: (p_child_section_id = FND_API.G_MISS_NUM))
482: THEN
483: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_CHILD_SCT_ID');
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;

Line 485: RAISE FND_API.G_EXC_ERROR;

481: (p_child_section_id = FND_API.G_MISS_NUM))
482: THEN
483: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_CHILD_SCT_ID');
484: FND_MSG_PUB.Add;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487:
488: -- start_date_active
489: IF ((p_start_date_active IS NULL) OR

Line 490: (p_start_date_active = FND_API.G_MISS_DATE))

486: END IF;
487:
488: -- start_date_active
489: IF ((p_start_date_active IS NULL) OR
490: (p_start_date_active = FND_API.G_MISS_DATE))
491: THEN
492: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_ERROR;

Line 494: RAISE FND_API.G_EXC_ERROR;

490: (p_start_date_active = FND_API.G_MISS_DATE))
491: THEN
492: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
493: FND_MSG_PUB.Add;
494: RAISE FND_API.G_EXC_ERROR;
495: END IF;
496:
497: --
498: -- non-null field validation

Line 503: (p_level_number <> FND_API.G_MISS_NUM))

499: --
500:
501: -- level number
502: IF ((p_level_number IS NOT NULL) AND
503: (p_level_number <> FND_API.G_MISS_NUM))
504: THEN
505: IF(p_level_number < 0) THEN
506: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
507: FND_MSG_PUB.Add;

Line 508: RAISE FND_API.G_EXC_ERROR;

504: THEN
505: IF(p_level_number < 0) THEN
506: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510: END IF;
511:
512: -- sort order

Line 514: (p_sort_order <> FND_API.G_MISS_NUM))

510: END IF;
511:
512: -- sort order
513: IF ((p_sort_order IS NOT NULL) AND
514: (p_sort_order <> FND_API.G_MISS_NUM))
515: THEN
516: IF(p_sort_order < 0) THEN
517: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
518: FND_MSG_PUB.Add;

Line 519: RAISE FND_API.G_EXC_ERROR;

515: THEN
516: IF(p_sort_order < 0) THEN
517: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
518: FND_MSG_PUB.Add;
519: RAISE FND_API.G_EXC_ERROR;
520: END IF;
521: END IF;
522:
523: --

Line 537: RAISE FND_API.G_EXC_ERROR;

533: WHEN NO_DATA_FOUND THEN
534: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_MSITE_ID');
535: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
536: FND_MSG_PUB.Add;
537: RAISE FND_API.G_EXC_ERROR;
538: WHEN OTHERS THEN
539: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
540: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
541: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

544:
545: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_MSITE_ID');
546: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
547: FND_MSG_PUB.Add;
548: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
549: END;
550:
551: -- parent section id
552: IF ((p_parent_section_id IS NOT NULL) AND

Line 553: (p_parent_section_id <> FND_API.G_MISS_NUM))

549: END;
550:
551: -- parent section id
552: IF ((p_parent_section_id IS NOT NULL) AND
553: (p_parent_section_id <> FND_API.G_MISS_NUM))
554: THEN
555: BEGIN
556: SELECT section_id INTO l_parent_section_id FROM ibe_dsp_sections_b
557: WHERE section_id = p_parent_section_id;

Line 563: RAISE FND_API.G_EXC_ERROR;

559: WHEN NO_DATA_FOUND THEN
560: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
561: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
562: FND_MSG_PUB.Add;
563: RAISE FND_API.G_EXC_ERROR;
564: WHEN OTHERS THEN
565: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
566: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
567: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

570:
571: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
572: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
573: FND_MSG_PUB.Add;
574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
575: END;
576: END IF;
577:
578: -- child section id

Line 588: RAISE FND_API.G_EXC_ERROR;

584: WHEN NO_DATA_FOUND THEN
585: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_NO_SCT_ID');
586: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
587: FND_MSG_PUB.Add;
588: RAISE FND_API.G_EXC_ERROR;
589: WHEN OTHERS THEN
590: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
591: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
592: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

595:
596: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_SCT_GET_SCT_ID');
597: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
598: FND_MSG_PUB.Add;
599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END;
601:
602: -- Validate if the entry is duplicate
603: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,

Line 603: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,

599: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
600: END;
601:
602: -- Validate if the entry is duplicate
603: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,
604: p_mini_site_id => p_mini_site_id,
605: p_parent_section_id => p_parent_section_id,
606: p_child_section_id => p_child_section_id,
607: x_return_status => l_return_status,

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

607: x_return_status => l_return_status,
608: x_msg_count => l_msg_count,
609: x_msg_data => l_msg_data);
610:
611: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
615: FND_MSG_PUB.Add;

Line 612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

608: x_msg_count => l_msg_count,
609: x_msg_data => l_msg_data);
610:
611: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

Line 613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN

609: x_msg_data => l_msg_data);
610:
611: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
617: END IF;

Line 616: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
613: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
614: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_DUPLICATE_ENTRY');
615: FND_MSG_PUB.Add;
616: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
617: END IF;
618:
619: EXCEPTION
620:

Line 621: WHEN FND_API.G_EXC_ERROR THEN

617: END IF;
618:
619: EXCEPTION
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => 'F');

Line 622: x_return_status := FND_API.G_RET_STS_ERROR;

618:
619: EXCEPTION
620:
621: WHEN FND_API.G_EXC_ERROR THEN
622: x_return_status := FND_API.G_RET_STS_ERROR;
623: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => 'F');
626:

Line 627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

623: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
624: p_data => x_msg_data,
625: p_encoded => 'F');
626:
627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
630: p_data => x_msg_data,
631: p_encoded => 'F');

Line 628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

624: p_data => x_msg_data,
625: p_encoded => 'F');
626:
627: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
629: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
630: p_data => x_msg_data,
631: p_encoded => 'F');
632:

Line 640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

636: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
637: FND_MESSAGE.Set_Token('REASON', SQLERRM);
638: FND_MSG_PUB.Add;
639:
640: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
641:
642: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
643: THEN
644: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 657: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid

653:
654: --*****************************************************************************
655: -- PROCEDURE Validate_Update()
656: --*****************************************************************************
657: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
658: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
659:
660: PROCEDURE Validate_Update
661: (

Line 658: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid

654: --*****************************************************************************
655: -- PROCEDURE Validate_Update()
656: --*****************************************************************************
657: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
658: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
659:
660: PROCEDURE Validate_Update
661: (
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

Line 662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

658: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
659:
660: PROCEDURE Validate_Update
661: (
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: p_mini_site_section_section_id IN NUMBER,
665: p_object_version_number IN NUMBER,
666: p_start_date_active IN DATE,

Line 663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

659:
660: PROCEDURE Validate_Update
661: (
662: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
663: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
664: p_mini_site_section_section_id IN NUMBER,
665: p_object_version_number IN NUMBER,
666: p_start_date_active IN DATE,
667: p_end_date_active IN DATE,

Line 690: IF FND_API.to_Boolean(p_init_msg_list) THEN

686:
687: BEGIN
688:
689: -- Initialize message list if p_init_msg_list is set to TRUE.
690: IF FND_API.to_Boolean(p_init_msg_list) THEN
691: FND_MSG_PUB.initialize;
692: END IF;
693:
694: -- Initialize API return status to success

Line 695: x_return_status := FND_API.G_RET_STS_SUCCESS;

691: FND_MSG_PUB.initialize;
692: END IF;
693:
694: -- Initialize API return status to success
695: x_return_status := FND_API.G_RET_STS_SUCCESS;
696:
697: --
698: -- Check null values for required fields
699: --

Line 705: RAISE FND_API.G_EXC_ERROR;

701: -- mini_site_section_section_id
702: IF (p_mini_site_section_section_id IS NULL) THEN
703: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NULL_PRIMARY_KEY');
704: FND_MSG_PUB.Add;
705: RAISE FND_API.G_EXC_ERROR;
706: END IF;
707:
708: -- start_date_active
709: IF (p_start_date_active IS NULL) THEN

Line 712: RAISE FND_API.G_EXC_ERROR;

708: -- start_date_active
709: IF (p_start_date_active IS NULL) THEN
710: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_START_DATE');
711: FND_MSG_PUB.Add;
712: RAISE FND_API.G_EXC_ERROR;
713: END IF;
714:
715: --
716: -- non-null field validation

Line 721: (p_level_number <> FND_API.G_MISS_NUM))

717: --
718:
719: -- level number
720: IF ((p_level_number IS NOT NULL) AND
721: (p_level_number <> FND_API.G_MISS_NUM))
722: THEN
723: IF(p_level_number < 0) THEN
724: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
725: FND_MSG_PUB.Add;

Line 726: RAISE FND_API.G_EXC_ERROR;

722: THEN
723: IF(p_level_number < 0) THEN
724: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_LVL_NUM');
725: FND_MSG_PUB.Add;
726: RAISE FND_API.G_EXC_ERROR;
727: END IF;
728: END IF;
729:
730: -- sort order

Line 732: (p_sort_order <> FND_API.G_MISS_NUM))

728: END IF;
729:
730: -- sort order
731: IF ((p_sort_order IS NOT NULL) AND
732: (p_sort_order <> FND_API.G_MISS_NUM))
733: THEN
734: IF(p_sort_order < 0) THEN
735: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
736: FND_MSG_PUB.Add;

Line 737: RAISE FND_API.G_EXC_ERROR;

733: THEN
734: IF(p_sort_order < 0) THEN
735: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_INVALID_SCT_SORT_ORDER');
736: FND_MSG_PUB.Add;
737: RAISE FND_API.G_EXC_ERROR;
738: END IF;
739: END IF;
740:
741: EXCEPTION

Line 743: WHEN FND_API.G_EXC_ERROR THEN

739: END IF;
740:
741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
746: p_data => x_msg_data,
747: p_encoded => 'F');

Line 744: x_return_status := FND_API.G_RET_STS_ERROR;

740:
741: EXCEPTION
742:
743: WHEN FND_API.G_EXC_ERROR THEN
744: x_return_status := FND_API.G_RET_STS_ERROR;
745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
746: p_data => x_msg_data,
747: p_encoded => 'F');
748:

Line 749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

745: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
746: p_data => x_msg_data,
747: p_encoded => 'F');
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
752: p_data => x_msg_data,
753: p_encoded => 'F');

Line 750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

746: p_data => x_msg_data,
747: p_encoded => 'F');
748:
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
752: p_data => x_msg_data,
753: p_encoded => 'F');
754:

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

758: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
759: FND_MESSAGE.Set_Token('REASON', SQLERRM);
760: FND_MSG_PUB.Add;
761:
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763:
764: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
765: THEN
766: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 782: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

778:
779: PROCEDURE Create_MSite_Section_Section
780: (
781: p_api_version IN NUMBER,
782: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
783: p_commit IN VARCHAR2 := FND_API.G_FALSE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_mini_site_id IN NUMBER,
786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 783: p_commit IN VARCHAR2 := FND_API.G_FALSE,

779: PROCEDURE Create_MSite_Section_Section
780: (
781: p_api_version IN NUMBER,
782: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
783: p_commit IN VARCHAR2 := FND_API.G_FALSE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_mini_site_id IN NUMBER,
786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_child_section_id IN NUMBER,

Line 784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

780: (
781: p_api_version IN NUMBER,
782: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
783: p_commit IN VARCHAR2 := FND_API.G_FALSE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_mini_site_id IN NUMBER,
786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_child_section_id IN NUMBER,
788: p_start_date_active IN DATE,

Line 786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

782: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
783: p_commit IN VARCHAR2 := FND_API.G_FALSE,
784: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
785: p_mini_site_id IN NUMBER,
786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_child_section_id IN NUMBER,
788: p_start_date_active IN DATE,
789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

Line 789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

785: p_mini_site_id IN NUMBER,
786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_child_section_id IN NUMBER,
788: p_start_date_active IN DATE,
789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
791: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
792: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: x_mini_site_section_section_id OUT NOCOPY NUMBER,

Line 790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

786: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
787: p_child_section_id IN NUMBER,
788: p_start_date_active IN DATE,
789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
791: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
792: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: x_mini_site_section_section_id OUT NOCOPY NUMBER,
794: x_return_status OUT NOCOPY VARCHAR2,

Line 791: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

787: p_child_section_id IN NUMBER,
788: p_start_date_active IN DATE,
789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
791: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
792: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: x_mini_site_section_section_id OUT NOCOPY NUMBER,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,

Line 792: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

788: p_start_date_active IN DATE,
789: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
790: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
791: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
792: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
793: x_mini_site_section_section_id OUT NOCOPY NUMBER,
794: x_return_status OUT NOCOPY VARCHAR2,
795: x_msg_count OUT NOCOPY NUMBER,
796: x_msg_data OUT NOCOPY VARCHAR2

Line 815: IF NOT FND_API.Compatible_API_Call(l_api_version,

811: -- Standard Start of API savepoint
812: SAVEPOINT CREATE_MSITE_SCT_SECT_PVT;
813:
814: -- Standard call to check for call compatibility.
815: IF NOT FND_API.Compatible_API_Call(l_api_version,
816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816: p_api_version,
817: l_api_name,
818: G_PKG_NAME)
819: THEN
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 824: IF FND_API.to_Boolean(p_init_msg_list) THEN

820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: END IF;
822:
823: -- Initialize message list if p_init_msg_list is set to TRUE.
824: IF FND_API.to_Boolean(p_init_msg_list) THEN
825: FND_MSG_PUB.initialize;
826: END IF;
827:
828: -- Initialize API return status to success

Line 829: x_return_status := FND_API.G_RET_STS_SUCCESS;

825: FND_MSG_PUB.initialize;
826: END IF;
827:
828: -- Initialize API return status to success
829: x_return_status := FND_API.G_RET_STS_SUCCESS;
830:
831: -- API body
832: -- CALL FLOW :
833: -- 1. Validate

Line 842: p_init_msg_list => FND_API.G_FALSE,

838: -- 1. Validate
839: --
840: Validate_Create
841: (
842: p_init_msg_list => FND_API.G_FALSE,
843: p_validation_level => p_validation_level,
844: p_mini_site_id => p_mini_site_id,
845: p_parent_section_id => p_parent_section_id,
846: p_child_section_id => p_child_section_id,

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

853: x_msg_count => l_msg_count,
854: x_msg_data => l_msg_data
855: );
856:
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');
861: FND_MSG_PUB.Add;

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: x_msg_data => l_msg_data
855: );
856:
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR; -- invalid

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

855: );
856:
857: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR; -- invalid
863: END IF;

Line 862: RAISE FND_API.G_EXC_ERROR; -- invalid

858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
860: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_CREATE');
861: FND_MSG_PUB.Add;
862: RAISE FND_API.G_EXC_ERROR; -- invalid
863: END IF;
864:
865: --
866: -- 2. Insert row

Line 871: FND_API.G_MISS_NUM,

867: --
868: BEGIN
869: insert_row
870: (
871: FND_API.G_MISS_NUM,
872: l_object_version_number,
873: p_mini_site_id,
874: p_parent_section_id,
875: p_child_section_id,

Line 893: RAISE FND_API.G_EXC_ERROR;

889: EXCEPTION
890: WHEN NO_DATA_FOUND THEN
891: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
892: FND_MSG_PUB.Add;
893: RAISE FND_API.G_EXC_ERROR;
894: WHEN OTHERS THEN
895: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
896: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
897: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

899: FND_MSG_PUB.Add;
900:
901: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INSERT_FAIL');
902: FND_MSG_PUB.Add;
903: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
904: END;
905:
906: --
907: -- End of main API body.

Line 910: IF (FND_API.To_Boolean(p_commit)) THEN

906: --
907: -- End of main API body.
908:
909: -- Standard check of p_commit.
910: IF (FND_API.To_Boolean(p_commit)) THEN
911: COMMIT WORK;
912: END IF;
913:
914: -- Standard call to get message count and if count is 1, get message info.

Line 921: WHEN FND_API.G_EXC_ERROR THEN

917: p_encoded => 'F');
918:
919: EXCEPTION
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
925: p_data => x_msg_data,

Line 923: x_return_status := FND_API.G_RET_STS_ERROR;

919: EXCEPTION
920:
921: WHEN FND_API.G_EXC_ERROR THEN
922: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
923: x_return_status := FND_API.G_RET_STS_ERROR;
924: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
925: p_data => x_msg_data,
926: p_encoded => 'F');
927:

Line 928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

924: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
925: p_data => x_msg_data,
926: p_encoded => 'F');
927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
932: p_data => x_msg_data,

Line 930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

926: p_encoded => 'F');
927:
928: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
929: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
930: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
931: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
932: p_data => x_msg_data,
933: p_encoded => 'F');
934:

Line 944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

940: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
941: FND_MESSAGE.Set_Token('REASON', SQLERRM);
942: FND_MSG_PUB.Add;
943:
944: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
945:
946: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
947: THEN
948: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

956:
957: PROCEDURE Update_MSite_Section_Section
958: (
959: p_api_version IN NUMBER,
960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,

Line 961: p_commit IN VARCHAR2 := FND_API.G_FALSE,

957: PROCEDURE Update_MSite_Section_Section
958: (
959: p_api_version IN NUMBER,
960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

958: (
959: p_api_version IN NUMBER,
960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,

959: p_api_version IN NUMBER,
960: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

961: p_commit IN VARCHAR2 := FND_API.G_FALSE,
962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

Line 966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

962: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

Line 967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

963: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

Line 968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,

964: p_object_version_number IN NUMBER,
965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

Line 969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

965: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY VARCHAR2,

Line 970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

966: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY VARCHAR2,
974: x_msg_count OUT NOCOPY NUMBER,

Line 971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

967: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY VARCHAR2,
974: x_msg_count OUT NOCOPY NUMBER,
975: x_msg_data OUT NOCOPY VARCHAR2

Line 972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

968: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
969: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
970: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
971: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
972: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
973: x_return_status OUT NOCOPY VARCHAR2,
974: x_msg_count OUT NOCOPY NUMBER,
975: x_msg_data OUT NOCOPY VARCHAR2
976: )

Line 992: IF NOT FND_API.Compatible_API_Call(l_api_version,

988: -- Standard Start of API savepoint
989: SAVEPOINT UPDATE_MSITE_SCT_SECT_PVT;
990:
991: -- Standard call to check for call compatibility.
992: IF NOT FND_API.Compatible_API_Call(l_api_version,
993: p_api_version,
994: l_api_name,
995: G_PKG_NAME)
996: THEN

Line 997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

993: p_api_version,
994: l_api_name,
995: G_PKG_NAME)
996: THEN
997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1001: IF FND_API.to_Boolean(p_init_msg_list) THEN

997: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
998: END IF;
999:
1000: -- Initialize message list if p_init_msg_list is set to TRUE.
1001: IF FND_API.to_Boolean(p_init_msg_list) THEN
1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to success

Line 1006: x_return_status := FND_API.G_RET_STS_SUCCESS;

1002: FND_MSG_PUB.initialize;
1003: END IF;
1004:
1005: -- Initialize API return status to success
1006: x_return_status := FND_API.G_RET_STS_SUCCESS;
1007:
1008: -- API body
1009: -- CALL FLOW :
1010: -- 1. Check if either mini_site_section_section_id or combination of

Line 1018: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))

1014:
1015: -- 1. Check if either mini_site_section_section_id or combination of
1016: -- mini_site_id, parent_section_id and child_section_id is specified
1017: IF ((p_mini_site_section_section_id IS NOT NULL) AND
1018: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))
1019: THEN
1020: -- mini_site_section_section_id specified, continue
1021: l_msite_sct_sect_id := p_mini_site_section_section_id;
1022: ELSIF ((p_mini_site_id IS NOT NULL) AND

Line 1023: (p_mini_site_id <> FND_API.G_MISS_NUM) AND

1019: THEN
1020: -- mini_site_section_section_id specified, continue
1021: l_msite_sct_sect_id := p_mini_site_section_section_id;
1022: ELSIF ((p_mini_site_id IS NOT NULL) AND
1023: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1024: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1025: (p_child_section_id IS NOT NULL) AND
1026: (p_child_section_id <> FND_API.G_MISS_NUM))
1027: THEN

Line 1024: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL

1020: -- mini_site_section_section_id specified, continue
1021: l_msite_sct_sect_id := p_mini_site_section_section_id;
1022: ELSIF ((p_mini_site_id IS NOT NULL) AND
1023: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1024: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1025: (p_child_section_id IS NOT NULL) AND
1026: (p_child_section_id <> FND_API.G_MISS_NUM))
1027: THEN
1028: -- If combination of mini_site_id, parent_section_id and child_section_id

Line 1026: (p_child_section_id <> FND_API.G_MISS_NUM))

1022: ELSIF ((p_mini_site_id IS NOT NULL) AND
1023: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1024: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1025: (p_child_section_id IS NOT NULL) AND
1026: (p_child_section_id <> FND_API.G_MISS_NUM))
1027: THEN
1028: -- If combination of mini_site_id, parent_section_id and child_section_id
1029: -- is specified, then query for mini_site_section_section_id
1030: BEGIN

Line 1059: RAISE FND_API.G_EXC_ERROR;

1055: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1056: END IF;
1057: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1058: FND_MSG_PUB.Add;
1059: RAISE FND_API.G_EXC_ERROR;
1060: WHEN OTHERS THEN
1061: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1062: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1063: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1072: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1073: END IF;
1074: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1075: FND_MSG_PUB.Add;
1076: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1077: END;
1078: ELSE
1079: -- neither mini_site_section_section_id nor combination of
1080: -- mini_site_id, parent_section_id and child_section_id is specified

Line 1083: RAISE FND_API.G_EXC_ERROR;

1079: -- neither mini_site_section_section_id nor combination of
1080: -- mini_site_id, parent_section_id and child_section_id is specified
1081: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');
1082: FND_MSG_PUB.Add;
1083: RAISE FND_API.G_EXC_ERROR;
1084: END IF;
1085:
1086:
1087: --

Line 1092: p_init_msg_list => FND_API.G_FALSE,

1088: -- 1. Validate the input data
1089: --
1090: Validate_Update
1091: (
1092: p_init_msg_list => FND_API.G_FALSE,
1093: p_validation_level => p_validation_level,
1094: p_mini_site_section_section_id => l_msite_sct_sect_id,
1095: p_object_version_number => p_object_version_number,
1096: p_start_date_active => p_start_date_active,

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

1102: x_msg_count => l_msg_count,
1103: x_msg_data => l_msg_data
1104: );
1105:
1106: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');
1110: FND_MSG_PUB.Add;

Line 1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1103: x_msg_data => l_msg_data
1104: );
1105:
1106: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR; -- invalid

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

1104: );
1105:
1106: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR; -- invalid
1112: END IF;

Line 1111: RAISE FND_API.G_EXC_ERROR; -- invalid

1107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1108: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1109: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_INVALID_UPDATE');
1110: FND_MSG_PUB.Add;
1111: RAISE FND_API.G_EXC_ERROR; -- invalid
1112: END IF;
1113:
1114: -- 2. update row
1115: BEGIN

Line 1133: RAISE FND_API.G_EXC_ERROR;

1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN
1131: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1132: FND_MSG_PUB.Add;
1133: RAISE FND_API.G_EXC_ERROR;
1134: WHEN OTHERS THEN
1135: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1136: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1137: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139: FND_MSG_PUB.Add;
1140:
1141: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_MSS_UPDATE_FAIL');
1142: FND_MSG_PUB.Add;
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END;
1145:
1146: --
1147: -- End of main API body.

Line 1150: IF (FND_API.To_Boolean(p_commit)) THEN

1146: --
1147: -- End of main API body.
1148:
1149: -- Standard check of p_commit.
1150: IF (FND_API.To_Boolean(p_commit)) THEN
1151: COMMIT WORK;
1152: END IF;
1153:
1154: -- Standard call to get message count and if count is 1, get message info.

Line 1161: WHEN FND_API.G_EXC_ERROR THEN

1157: p_encoded => 'F');
1158:
1159: EXCEPTION
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1165: p_data => x_msg_data,

Line 1163: x_return_status := FND_API.G_RET_STS_ERROR;

1159: EXCEPTION
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1163: x_return_status := FND_API.G_RET_STS_ERROR;
1164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1165: p_data => x_msg_data,
1166: p_encoded => 'F');
1167:

Line 1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1165: p_data => x_msg_data,
1166: p_encoded => 'F');
1167:
1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1169: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1172: p_data => x_msg_data,

Line 1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1166: p_encoded => 'F');
1167:
1168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1169: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1170: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1171: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1172: p_data => x_msg_data,
1173: p_encoded => 'F');
1174:

Line 1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1180: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1181: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1182: FND_MSG_PUB.Add;
1183:
1184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1185:
1186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1187: THEN
1188: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1197:
1198: PROCEDURE Delete_MSite_Section_Section
1199: (
1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1198: PROCEDURE Delete_MSite_Section_Section
1199: (
1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1199: (
1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

Line 1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,

1200: p_api_version IN NUMBER,
1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1208: x_return_status OUT NOCOPY VARCHAR2,

Line 1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

1201: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,

Line 1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

1202: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,
1210: x_msg_data OUT NOCOPY VARCHAR2

Line 1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

1203: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1204: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1205: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1206: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1207: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1208: x_return_status OUT NOCOPY VARCHAR2,
1209: x_msg_count OUT NOCOPY NUMBER,
1210: x_msg_data OUT NOCOPY VARCHAR2
1211: )

Line 1222: IF NOT FND_API.Compatible_API_Call(l_api_version,

1218: -- Standard Start of API savepoint
1219: SAVEPOINT DELETE_MSITE_SCT_SECT_PVT;
1220:
1221: -- Standard call to check for call compatibility.
1222: IF NOT FND_API.Compatible_API_Call(l_api_version,
1223: p_api_version,
1224: l_api_name,
1225: G_PKG_NAME)
1226: THEN

Line 1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1223: p_api_version,
1224: l_api_name,
1225: G_PKG_NAME)
1226: THEN
1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Initialize message list if p_init_msg_list is set to TRUE.
1231: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1231: IF FND_API.to_Boolean(p_init_msg_list) THEN

1227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1228: END IF;
1229:
1230: -- Initialize message list if p_init_msg_list is set to TRUE.
1231: IF FND_API.to_Boolean(p_init_msg_list) THEN
1232: FND_MSG_PUB.initialize;
1233: END IF;
1234:
1235: -- Initialize API return status to success

Line 1236: x_return_status := FND_API.G_RET_STS_SUCCESS;

1232: FND_MSG_PUB.initialize;
1233: END IF;
1234:
1235: -- Initialize API return status to success
1236: x_return_status := FND_API.G_RET_STS_SUCCESS;
1237:
1238: -- CALL FLOW
1239: -- 1. If mini_site_section_section_id specified, delete all references for it
1240: -- 2. If combination of mini_site_id, parent_section_id and child_section_id

Line 1246: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))

1242: -- all references
1243:
1244: -- 1. If mini_site_section_section_id specified, delete all references for it
1245: IF ((p_mini_site_section_section_id IS NOT NULL) AND
1246: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))
1247: THEN
1248: -- mini_site_section_section_id specified, continue
1249: l_msite_sct_sect_id := p_mini_site_section_section_id;
1250: ELSIF ((p_mini_site_id IS NOT NULL) AND

Line 1251: (p_mini_site_id <> FND_API.G_MISS_NUM) AND

1247: THEN
1248: -- mini_site_section_section_id specified, continue
1249: l_msite_sct_sect_id := p_mini_site_section_section_id;
1250: ELSIF ((p_mini_site_id IS NOT NULL) AND
1251: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1252: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1253: (p_child_section_id IS NOT NULL) AND
1254: (p_child_section_id <> FND_API.G_MISS_NUM))
1255: THEN

Line 1252: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL

1248: -- mini_site_section_section_id specified, continue
1249: l_msite_sct_sect_id := p_mini_site_section_section_id;
1250: ELSIF ((p_mini_site_id IS NOT NULL) AND
1251: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1252: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1253: (p_child_section_id IS NOT NULL) AND
1254: (p_child_section_id <> FND_API.G_MISS_NUM))
1255: THEN
1256: -- If combination of mini_site_id, parent_section_id and child_section_id

Line 1254: (p_child_section_id <> FND_API.G_MISS_NUM))

1250: ELSIF ((p_mini_site_id IS NOT NULL) AND
1251: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1252: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1253: (p_child_section_id IS NOT NULL) AND
1254: (p_child_section_id <> FND_API.G_MISS_NUM))
1255: THEN
1256: -- If combination of mini_site_id, parent_section_id and child_section_id
1257: -- is specified, then query for mini_site_section_section_id
1258: BEGIN

Line 1287: RAISE FND_API.G_EXC_ERROR;

1283: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1284: END IF;
1285: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1286: FND_MSG_PUB.Add;
1287: RAISE FND_API.G_EXC_ERROR;
1288: WHEN OTHERS THEN
1289: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1290: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1291: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1300: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1301: END IF;
1302: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1303: FND_MSG_PUB.Add;
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: END;
1306:
1307: ELSE
1308: -- neither mini_site_section_section_id nor combination of

Line 1312: RAISE FND_API.G_EXC_ERROR;

1308: -- neither mini_site_section_section_id nor combination of
1309: -- mini_site_id, parent_section_id and child_section_id is specified
1310: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_NO_MSS_IDS_SPEC');
1311: FND_MSG_PUB.Add;
1312: RAISE FND_API.G_EXC_ERROR;
1313: END IF;
1314:
1315: -- delete row
1316: delete_row(l_msite_sct_sect_id);

Line 1320: WHEN FND_API.G_EXC_ERROR THEN

1316: delete_row(l_msite_sct_sect_id);
1317:
1318: EXCEPTION
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1324: p_data => x_msg_data,

Line 1322: x_return_status := FND_API.G_RET_STS_ERROR;

1318: EXCEPTION
1319:
1320: WHEN FND_API.G_EXC_ERROR THEN
1321: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1322: x_return_status := FND_API.G_RET_STS_ERROR;
1323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1324: p_data => x_msg_data,
1325: p_encoded => 'F');
1326:

Line 1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1323: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1324: p_data => x_msg_data,
1325: p_encoded => 'F');
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1331: p_data => x_msg_data,

Line 1329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1325: p_encoded => 'F');
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1329: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1330: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1331: p_data => x_msg_data,
1332: p_encoded => 'F');
1333:

Line 1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1339: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1340: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1341: FND_MSG_PUB.Add;
1342:
1343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1344:
1345: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1346: THEN
1347: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

Line 1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1355:
1356: PROCEDURE Update_MSite_Section_Sections
1357: (
1358: p_api_version IN NUMBER,
1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1360: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1363: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 1360: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1356: PROCEDURE Update_MSite_Section_Sections
1357: (
1358: p_api_version IN NUMBER,
1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1360: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1363: p_object_version_numbers IN JTF_NUMBER_TABLE,
1364: p_start_date_actives IN JTF_DATE_TABLE,

Line 1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1357: (
1358: p_api_version IN NUMBER,
1359: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1360: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1361: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1362: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1363: p_object_version_numbers IN JTF_NUMBER_TABLE,
1364: p_start_date_actives IN JTF_DATE_TABLE,
1365: p_end_date_actives IN JTF_DATE_TABLE,

Line 1386: IF NOT FND_API.Compatible_API_Call(l_api_version,

1382: -- Standard Start of API savepoint
1383: SAVEPOINT UPDATE_MSITE_SCT_SECTS_PVT;
1384:
1385: -- Standard call to check for call compatibility.
1386: IF NOT FND_API.Compatible_API_Call(l_api_version,
1387: p_api_version,
1388: l_api_name,
1389: G_PKG_NAME)
1390: THEN

Line 1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1387: p_api_version,
1388: l_api_name,
1389: G_PKG_NAME)
1390: THEN
1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1395: IF FND_API.to_Boolean(p_init_msg_list) THEN

1391: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1392: END IF;
1393:
1394: -- Initialize message list if p_init_msg_list is set to TRUE.
1395: IF FND_API.to_Boolean(p_init_msg_list) THEN
1396: FND_MSG_PUB.initialize;
1397: END IF;
1398:
1399: -- Initialize API return status to success

Line 1400: x_return_status := FND_API.G_RET_STS_SUCCESS;

1396: FND_MSG_PUB.initialize;
1397: END IF;
1398:
1399: -- Initialize API return status to success
1400: x_return_status := FND_API.G_RET_STS_SUCCESS;
1401:
1402: -- API body
1403: -- CALL FLOW :
1404: -- 1.

Line 1410: p_init_msg_list => FND_API.G_FALSE,

1406:
1407: Update_MSite_Section_Section
1408: (
1409: p_api_version => p_api_version,
1410: p_init_msg_list => FND_API.G_FALSE,
1411: p_commit => FND_API.G_FALSE,
1412: p_validation_level => p_validation_level,
1413: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1414: p_object_version_number => p_object_version_numbers(i),

Line 1411: p_commit => FND_API.G_FALSE,

1407: Update_MSite_Section_Section
1408: (
1409: p_api_version => p_api_version,
1410: p_init_msg_list => FND_API.G_FALSE,
1411: p_commit => FND_API.G_FALSE,
1412: p_validation_level => p_validation_level,
1413: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1414: p_object_version_number => p_object_version_numbers(i),
1415: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1415: p_mini_site_id => FND_API.G_MISS_NUM,

1411: p_commit => FND_API.G_FALSE,
1412: p_validation_level => p_validation_level,
1413: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1414: p_object_version_number => p_object_version_numbers(i),
1415: p_mini_site_id => FND_API.G_MISS_NUM,
1416: p_parent_section_id => FND_API.G_MISS_NUM,
1417: p_child_section_id => FND_API.G_MISS_NUM,
1418: p_start_date_active => p_start_date_actives(i),
1419: p_end_date_active => p_end_date_actives(i),

Line 1416: p_parent_section_id => FND_API.G_MISS_NUM,

1412: p_validation_level => p_validation_level,
1413: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1414: p_object_version_number => p_object_version_numbers(i),
1415: p_mini_site_id => FND_API.G_MISS_NUM,
1416: p_parent_section_id => FND_API.G_MISS_NUM,
1417: p_child_section_id => FND_API.G_MISS_NUM,
1418: p_start_date_active => p_start_date_actives(i),
1419: p_end_date_active => p_end_date_actives(i),
1420: p_level_number => FND_API.G_MISS_NUM,

Line 1417: p_child_section_id => FND_API.G_MISS_NUM,

1413: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1414: p_object_version_number => p_object_version_numbers(i),
1415: p_mini_site_id => FND_API.G_MISS_NUM,
1416: p_parent_section_id => FND_API.G_MISS_NUM,
1417: p_child_section_id => FND_API.G_MISS_NUM,
1418: p_start_date_active => p_start_date_actives(i),
1419: p_end_date_active => p_end_date_actives(i),
1420: p_level_number => FND_API.G_MISS_NUM,
1421: p_sort_order => p_sort_orders(i),

Line 1420: p_level_number => FND_API.G_MISS_NUM,

1416: p_parent_section_id => FND_API.G_MISS_NUM,
1417: p_child_section_id => FND_API.G_MISS_NUM,
1418: p_start_date_active => p_start_date_actives(i),
1419: p_end_date_active => p_end_date_actives(i),
1420: p_level_number => FND_API.G_MISS_NUM,
1421: p_sort_order => p_sort_orders(i),
1422: p_concat_ids => FND_API.G_MISS_CHAR,
1423: x_return_status => l_return_status,
1424: x_msg_count => x_msg_count,

Line 1422: p_concat_ids => FND_API.G_MISS_CHAR,

1418: p_start_date_active => p_start_date_actives(i),
1419: p_end_date_active => p_end_date_actives(i),
1420: p_level_number => FND_API.G_MISS_NUM,
1421: p_sort_order => p_sort_orders(i),
1422: p_concat_ids => FND_API.G_MISS_CHAR,
1423: x_return_status => l_return_status,
1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data
1426: );

Line 1428: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1424: x_msg_count => x_msg_count,
1425: x_msg_data => x_msg_data
1426: );
1427:
1428: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;

Line 1429: RAISE FND_API.G_EXC_ERROR;

1425: x_msg_data => x_msg_data
1426: );
1427:
1428: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:

Line 1430: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1426: );
1427:
1428: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:
1434: END LOOP;

Line 1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1427:
1428: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1429: RAISE FND_API.G_EXC_ERROR;
1430: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: END IF;
1433:
1434: END LOOP;
1435:

Line 1440: IF (FND_API.To_Boolean(p_commit)) THEN

1436: --
1437: -- End of main API body.
1438:
1439: -- Standard check of p_commit.
1440: IF (FND_API.To_Boolean(p_commit)) THEN
1441: COMMIT WORK;
1442: END IF;
1443:
1444: -- Standard call to get message count and if count is 1, get message info.

Line 1451: WHEN FND_API.G_EXC_ERROR THEN

1447: p_encoded => 'F');
1448:
1449: EXCEPTION
1450:
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1455: p_data => x_msg_data,

Line 1453: x_return_status := FND_API.G_RET_STS_ERROR;

1449: EXCEPTION
1450:
1451: WHEN FND_API.G_EXC_ERROR THEN
1452: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1453: x_return_status := FND_API.G_RET_STS_ERROR;
1454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1455: p_data => x_msg_data,
1456: p_encoded => 'F');
1457:

Line 1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1454: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1455: p_data => x_msg_data,
1456: p_encoded => 'F');
1457:
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1462: p_data => x_msg_data,

Line 1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1456: p_encoded => 'F');
1457:
1458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1459: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1460: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1461: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1462: p_data => x_msg_data,
1463: p_encoded => 'F');
1464:

Line 1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1470: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1471: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1472: FND_MSG_PUB.Add;
1473:
1474: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1475:
1476: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1477: THEN
1478: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1486:
1487: PROCEDURE Update_Delete_Sct_Scts
1488: (
1489: p_api_version IN NUMBER,
1490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1493: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1494: p_object_version_numbers IN JTF_NUMBER_TABLE,

Line 1491: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1487: PROCEDURE Update_Delete_Sct_Scts
1488: (
1489: p_api_version IN NUMBER,
1490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1493: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1494: p_object_version_numbers IN JTF_NUMBER_TABLE,
1495: p_start_date_actives IN JTF_DATE_TABLE,

Line 1492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1488: (
1489: p_api_version IN NUMBER,
1490: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1491: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1492: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1493: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1494: p_object_version_numbers IN JTF_NUMBER_TABLE,
1495: p_start_date_actives IN JTF_DATE_TABLE,
1496: p_end_date_actives IN JTF_DATE_TABLE,

Line 1518: IF NOT FND_API.Compatible_API_Call(l_api_version,

1514: -- Standard Start of API savepoint
1515: SAVEPOINT UPDATE_DELETE_SCT_SCTS_PVT;
1516:
1517: -- Standard call to check for call compatibility.
1518: IF NOT FND_API.Compatible_API_Call(l_api_version,
1519: p_api_version,
1520: l_api_name,
1521: G_PKG_NAME)
1522: THEN

Line 1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1519: p_api_version,
1520: l_api_name,
1521: G_PKG_NAME)
1522: THEN
1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:
1526: -- Initialize message list if p_init_msg_list is set to TRUE.
1527: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1527: IF FND_API.to_Boolean(p_init_msg_list) THEN

1523: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1524: END IF;
1525:
1526: -- Initialize message list if p_init_msg_list is set to TRUE.
1527: IF FND_API.to_Boolean(p_init_msg_list) THEN
1528: FND_MSG_PUB.initialize;
1529: END IF;
1530:
1531: -- Initialize API return status to success

Line 1532: x_return_status := FND_API.G_RET_STS_SUCCESS;

1528: FND_MSG_PUB.initialize;
1529: END IF;
1530:
1531: -- Initialize API return status to success
1532: x_return_status := FND_API.G_RET_STS_SUCCESS;
1533:
1534: -- API body
1535: -- CALL FLOW :
1536: -- 1.

Line 1545: p_init_msg_list => FND_API.G_FALSE,

1541:
1542: Delete_MSite_Section_Section
1543: (
1544: p_api_version => p_api_version,
1545: p_init_msg_list => FND_API.G_FALSE,
1546: p_commit => FND_API.G_FALSE,
1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1546: p_commit => FND_API.G_FALSE,

1542: Delete_MSite_Section_Section
1543: (
1544: p_api_version => p_api_version,
1545: p_init_msg_list => FND_API.G_FALSE,
1546: p_commit => FND_API.G_FALSE,
1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,
1550: p_parent_section_id => FND_API.G_MISS_NUM,

Line 1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1543: (
1544: p_api_version => p_api_version,
1545: p_init_msg_list => FND_API.G_FALSE,
1546: p_commit => FND_API.G_FALSE,
1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,
1550: p_parent_section_id => FND_API.G_MISS_NUM,
1551: p_child_section_id => FND_API.G_MISS_NUM,

Line 1549: p_mini_site_id => FND_API.G_MISS_NUM,

1545: p_init_msg_list => FND_API.G_FALSE,
1546: p_commit => FND_API.G_FALSE,
1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,
1550: p_parent_section_id => FND_API.G_MISS_NUM,
1551: p_child_section_id => FND_API.G_MISS_NUM,
1552: x_return_status => x_return_status,
1553: x_msg_count => x_msg_count,

Line 1550: p_parent_section_id => FND_API.G_MISS_NUM,

1546: p_commit => FND_API.G_FALSE,
1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,
1550: p_parent_section_id => FND_API.G_MISS_NUM,
1551: p_child_section_id => FND_API.G_MISS_NUM,
1552: x_return_status => x_return_status,
1553: x_msg_count => x_msg_count,
1554: x_msg_data => x_msg_data

Line 1551: p_child_section_id => FND_API.G_MISS_NUM,

1547: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1548: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1549: p_mini_site_id => FND_API.G_MISS_NUM,
1550: p_parent_section_id => FND_API.G_MISS_NUM,
1551: p_child_section_id => FND_API.G_MISS_NUM,
1552: x_return_status => x_return_status,
1553: x_msg_count => x_msg_count,
1554: x_msg_data => x_msg_data
1555: );

Line 1557: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1553: x_msg_count => x_msg_count,
1554: x_msg_data => x_msg_data
1555: );
1556:
1557: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;

Line 1558: RAISE FND_API.G_EXC_ERROR;

1554: x_msg_data => x_msg_data
1555: );
1556:
1557: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;
1562:

Line 1559: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1555: );
1556:
1557: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;
1562:
1563: ELSE

Line 1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1556:
1557: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1558: RAISE FND_API.G_EXC_ERROR;
1559: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1560: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1561: END IF;
1562:
1563: ELSE
1564:

Line 1568: p_init_msg_list => FND_API.G_FALSE,

1564:
1565: Update_Msite_Section_Section
1566: (
1567: p_api_version => p_api_version,
1568: p_init_msg_list => FND_API.G_FALSE,
1569: p_commit => FND_API.G_FALSE,
1570: p_validation_level => p_validation_level,
1571: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1572: p_object_version_number => p_object_version_numbers(i),

Line 1569: p_commit => FND_API.G_FALSE,

1565: Update_Msite_Section_Section
1566: (
1567: p_api_version => p_api_version,
1568: p_init_msg_list => FND_API.G_FALSE,
1569: p_commit => FND_API.G_FALSE,
1570: p_validation_level => p_validation_level,
1571: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1572: p_object_version_number => p_object_version_numbers(i),
1573: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1573: p_mini_site_id => FND_API.G_MISS_NUM,

1569: p_commit => FND_API.G_FALSE,
1570: p_validation_level => p_validation_level,
1571: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1572: p_object_version_number => p_object_version_numbers(i),
1573: p_mini_site_id => FND_API.G_MISS_NUM,
1574: p_parent_section_id => FND_API.G_MISS_NUM,
1575: p_child_section_id => FND_API.G_MISS_NUM,
1576: p_start_date_active => p_start_date_actives(i),
1577: p_end_date_active => p_end_date_actives(i),

Line 1574: p_parent_section_id => FND_API.G_MISS_NUM,

1570: p_validation_level => p_validation_level,
1571: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1572: p_object_version_number => p_object_version_numbers(i),
1573: p_mini_site_id => FND_API.G_MISS_NUM,
1574: p_parent_section_id => FND_API.G_MISS_NUM,
1575: p_child_section_id => FND_API.G_MISS_NUM,
1576: p_start_date_active => p_start_date_actives(i),
1577: p_end_date_active => p_end_date_actives(i),
1578: p_level_number => FND_API.G_MISS_NUM,

Line 1575: p_child_section_id => FND_API.G_MISS_NUM,

1571: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1572: p_object_version_number => p_object_version_numbers(i),
1573: p_mini_site_id => FND_API.G_MISS_NUM,
1574: p_parent_section_id => FND_API.G_MISS_NUM,
1575: p_child_section_id => FND_API.G_MISS_NUM,
1576: p_start_date_active => p_start_date_actives(i),
1577: p_end_date_active => p_end_date_actives(i),
1578: p_level_number => FND_API.G_MISS_NUM,
1579: p_sort_order => p_sort_orders(i),

Line 1578: p_level_number => FND_API.G_MISS_NUM,

1574: p_parent_section_id => FND_API.G_MISS_NUM,
1575: p_child_section_id => FND_API.G_MISS_NUM,
1576: p_start_date_active => p_start_date_actives(i),
1577: p_end_date_active => p_end_date_actives(i),
1578: p_level_number => FND_API.G_MISS_NUM,
1579: p_sort_order => p_sort_orders(i),
1580: p_concat_ids => FND_API.G_MISS_CHAR,
1581: x_return_status => l_return_status,
1582: x_msg_count => x_msg_count,

Line 1580: p_concat_ids => FND_API.G_MISS_CHAR,

1576: p_start_date_active => p_start_date_actives(i),
1577: p_end_date_active => p_end_date_actives(i),
1578: p_level_number => FND_API.G_MISS_NUM,
1579: p_sort_order => p_sort_orders(i),
1580: p_concat_ids => FND_API.G_MISS_CHAR,
1581: x_return_status => l_return_status,
1582: x_msg_count => x_msg_count,
1583: x_msg_data => x_msg_data
1584: );

Line 1586: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1582: x_msg_count => x_msg_count,
1583: x_msg_data => x_msg_data
1584: );
1585:
1586: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590: END IF;

Line 1587: RAISE FND_API.G_EXC_ERROR;

1583: x_msg_data => x_msg_data
1584: );
1585:
1586: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590: END IF;
1591:

Line 1588: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1584: );
1585:
1586: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590: END IF;
1591:
1592: END IF;

Line 1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1585:
1586: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1587: RAISE FND_API.G_EXC_ERROR;
1588: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1590: END IF;
1591:
1592: END IF;
1593:

Line 1600: IF (FND_API.To_Boolean(p_commit)) THEN

1596: --
1597: -- End of main API body.
1598:
1599: -- Standard check of p_commit.
1600: IF (FND_API.To_Boolean(p_commit)) THEN
1601: COMMIT WORK;
1602: END IF;
1603:
1604: -- Standard call to get message count and if count is 1, get message info.

Line 1611: WHEN FND_API.G_EXC_ERROR THEN

1607: p_encoded => 'F');
1608:
1609: EXCEPTION
1610:
1611: WHEN FND_API.G_EXC_ERROR THEN
1612: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1615: p_data => x_msg_data,

Line 1613: x_return_status := FND_API.G_RET_STS_ERROR;

1609: EXCEPTION
1610:
1611: WHEN FND_API.G_EXC_ERROR THEN
1612: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => 'F');
1617:

Line 1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1614: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1615: p_data => x_msg_data,
1616: p_encoded => 'F');
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1622: p_data => x_msg_data,

Line 1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1616: p_encoded => 'F');
1617:
1618: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1621: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1622: p_data => x_msg_data,
1623: p_encoded => 'F');
1624:

Line 1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1630: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1631: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1632: FND_MSG_PUB.Add;
1633:
1634: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1635:
1636: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1637: THEN
1638: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1651: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,

1647: PROCEDURE LOAD_SEED_ROW
1648: (
1649: P_MINI_SITE_SECTION_SECTION_ID IN NUMBER,
1650: P_OWNER IN VARCHAR2,
1651: P_OBJECT_VERSION_NUMBER IN NUMBER := FND_API.G_MISS_NUM,
1652: P_MINI_SITE_ID IN NUMBER,
1653: P_PARENT_SECTION_ID IN NUMBER,
1654: P_CHILD_SECTION_ID IN NUMBER,
1655: P_START_DATE_ACTIVE IN VARCHAR2, --IN DATE,