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

Line 73: (x_mini_site_section_section_id = FND_API.G_MISS_NUM))

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 177: FND_API.G_MISS_NUM,

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

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

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

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

233: l_user_id := 1;
234: END IF;
235:
236: IF ((p_object_version_number IS NOT NULL) AND
237: (p_object_version_number <> FND_API.G_MISS_NUM))
238: THEN
239: l_object_version_number := p_object_version_number;
240: END IF;
241:

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

302: -- PROCEDURE Check_Duplicate_Entry()
303: --*****************************************************************************
304:
305: --
306: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
307: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
308: --
309: --
310: PROCEDURE Check_Duplicate_Entry

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

303: --*****************************************************************************
304:
305: --
306: -- x_return_status = FND_API.G_RET_STS_SUCCESS, if the section is duplicate
307: -- x_return_status = FND_API.G_RET_STS_ERROR, if the section is not duplicate
308: --
309: --
310: PROCEDURE Check_Duplicate_Entry
311: (

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

308: --
309: --
310: PROCEDURE Check_Duplicate_Entry
311: (
312: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
313: p_mini_site_id IN NUMBER,
314: p_parent_section_id IN NUMBER,
315: p_child_section_id IN NUMBER,
316: x_return_status OUT VARCHAR2,

Line 328: IF FND_API.to_Boolean(p_init_msg_list) THEN

324: l_tmp_msite_sct_sect_id NUMBER;
325: BEGIN
326:
327: -- Initialize message list if p_init_msg_list is set to TRUE.
328: IF FND_API.to_Boolean(p_init_msg_list) THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Initialize API return status to error, i.e, its not duplicate

Line 333: x_return_status := FND_API.G_RET_STS_ERROR;

329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: -- Initialize API return status to error, i.e, its not duplicate
333: x_return_status := FND_API.G_RET_STS_ERROR;
334:
335: -- Check duplicate entry
336: BEGIN
337:

Line 364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

360: -- do nothing
361: NULL;
362:
363: WHEN OTHERS THEN
364: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
365:
366: END;
367:
368: IF (l_tmp_msite_sct_sect_id IS NOT NULL) THEN

Line 370: RAISE FND_API.G_EXC_ERROR;

366: END;
367:
368: IF (l_tmp_msite_sct_sect_id IS NOT NULL) THEN
369: -- found duplicate
370: RAISE FND_API.G_EXC_ERROR;
371: END IF;
372:
373: EXCEPTION
374:

Line 375: WHEN FND_API.G_EXC_ERROR THEN

371: END IF;
372:
373: EXCEPTION
374:
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => 'F');

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

372:
373: EXCEPTION
374:
375: WHEN FND_API.G_EXC_ERROR THEN
376: x_return_status := FND_API.G_RET_STS_SUCCESS; -- found duplicate
377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => 'F');
380:

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
378: p_data => x_msg_data,
379: p_encoded => 'F');
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data,
385: p_encoded => 'F');

Line 382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

378: p_data => x_msg_data,
379: p_encoded => 'F');
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
383: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
384: p_data => x_msg_data,
385: p_encoded => 'F');
386:

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

384: p_data => x_msg_data,
385: p_encoded => 'F');
386:
387: WHEN OTHERS THEN
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389:
390: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
391: THEN
392: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

401:
402: --*****************************************************************************
403: -- PROCEDURE Validate_Create()
404: --*****************************************************************************
405: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
406: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
407:
408: PROCEDURE Validate_Create
409: (

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

402: --*****************************************************************************
403: -- PROCEDURE Validate_Create()
404: --*****************************************************************************
405: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
406: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
407:
408: PROCEDURE Validate_Create
409: (
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

406: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
407:
408: PROCEDURE Validate_Create
409: (
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: p_mini_site_id IN NUMBER,
413: p_parent_section_id IN NUMBER,
414: p_child_section_id IN NUMBER,

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

407:
408: PROCEDURE Validate_Create
409: (
410: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
412: p_mini_site_id IN NUMBER,
413: p_parent_section_id IN NUMBER,
414: p_child_section_id IN NUMBER,
415: p_start_date_active IN DATE,

Line 437: IF FND_API.to_Boolean(p_init_msg_list) THEN

433: l_return_status VARCHAR2(1);
434: BEGIN
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success

Line 442: x_return_status := FND_API.G_RET_STS_SUCCESS;

438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: -- Initialize API return status to success
442: x_return_status := FND_API.G_RET_STS_SUCCESS;
443:
444: --
445: -- Check null values for required fields
446: --

Line 450: (p_mini_site_id = FND_API.G_MISS_NUM))

446: --
447:
448: -- mini site id
449: IF ((p_mini_site_id IS NULL) OR
450: (p_mini_site_id = FND_API.G_MISS_NUM))
451: THEN
452: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_ERROR;

Line 454: RAISE FND_API.G_EXC_ERROR;

450: (p_mini_site_id = FND_API.G_MISS_NUM))
451: THEN
452: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_MSITE_ID');
453: FND_MSG_PUB.Add;
454: RAISE FND_API.G_EXC_ERROR;
455: END IF;
456:
457: -- child section id
458: IF ((p_child_section_id IS NULL) OR

Line 459: (p_child_section_id = FND_API.G_MISS_NUM))

455: END IF;
456:
457: -- child section id
458: IF ((p_child_section_id IS NULL) OR
459: (p_child_section_id = FND_API.G_MISS_NUM))
460: THEN
461: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_CHILD_SCT_ID');
462: FND_MSG_PUB.Add;
463: RAISE FND_API.G_EXC_ERROR;

Line 463: RAISE FND_API.G_EXC_ERROR;

459: (p_child_section_id = FND_API.G_MISS_NUM))
460: THEN
461: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_CHILD_SCT_ID');
462: FND_MSG_PUB.Add;
463: RAISE FND_API.G_EXC_ERROR;
464: END IF;
465:
466: -- start_date_active
467: IF ((p_start_date_active IS NULL) OR

Line 468: (p_start_date_active = FND_API.G_MISS_DATE))

464: END IF;
465:
466: -- start_date_active
467: IF ((p_start_date_active IS NULL) OR
468: (p_start_date_active = FND_API.G_MISS_DATE))
469: THEN
470: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;

Line 472: RAISE FND_API.G_EXC_ERROR;

468: (p_start_date_active = FND_API.G_MISS_DATE))
469: THEN
470: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
471: FND_MSG_PUB.Add;
472: RAISE FND_API.G_EXC_ERROR;
473: END IF;
474:
475: --
476: -- non-null field validation

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

477: --
478:
479: -- level number
480: IF ((p_level_number IS NOT NULL) AND
481: (p_level_number <> FND_API.G_MISS_NUM))
482: THEN
483: IF(p_level_number < 0) THEN
484: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
485: FND_MSG_PUB.Add;

Line 486: RAISE FND_API.G_EXC_ERROR;

482: THEN
483: IF(p_level_number < 0) THEN
484: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
485: FND_MSG_PUB.Add;
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488: END IF;
489:
490: -- sort order

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

488: END IF;
489:
490: -- sort order
491: IF ((p_sort_order IS NOT NULL) AND
492: (p_sort_order <> FND_API.G_MISS_NUM))
493: THEN
494: IF(p_sort_order < 0) THEN
495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
496: FND_MSG_PUB.Add;

Line 497: RAISE FND_API.G_EXC_ERROR;

493: THEN
494: IF(p_sort_order < 0) THEN
495: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
496: FND_MSG_PUB.Add;
497: RAISE FND_API.G_EXC_ERROR;
498: END IF;
499: END IF;
500:
501: --

Line 515: RAISE FND_API.G_EXC_ERROR;

511: WHEN NO_DATA_FOUND THEN
512: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_MSITE_ID');
513: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
514: FND_MSG_PUB.Add;
515: RAISE FND_API.G_EXC_ERROR;
516: WHEN OTHERS THEN
517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
519: FND_MSG_PUB.Add;

Line 520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

516: WHEN OTHERS THEN
517: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_MSITE_ID');
518: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
519: FND_MSG_PUB.Add;
520: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
521: END;
522:
523: -- parent section id
524: IF ((p_parent_section_id IS NOT NULL) AND

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

521: END;
522:
523: -- parent section id
524: IF ((p_parent_section_id IS NOT NULL) AND
525: (p_parent_section_id <> FND_API.G_MISS_NUM))
526: THEN
527: BEGIN
528: SELECT section_id INTO l_parent_section_id FROM jtf_dsp_sections_b
529: WHERE section_id = p_parent_section_id;

Line 535: RAISE FND_API.G_EXC_ERROR;

531: WHEN NO_DATA_FOUND THEN
532: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
533: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
534: FND_MSG_PUB.Add;
535: RAISE FND_API.G_EXC_ERROR;
536: WHEN OTHERS THEN
537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
539: FND_MSG_PUB.Add;

Line 540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

536: WHEN OTHERS THEN
537: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
538: FND_MESSAGE.Set_Token('SECTION_ID', p_parent_section_id);
539: FND_MSG_PUB.Add;
540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
541: END;
542: END IF;
543:
544: -- child section id

Line 554: RAISE FND_API.G_EXC_ERROR;

550: WHEN NO_DATA_FOUND THEN
551: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_NO_SCT_ID');
552: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
553: FND_MSG_PUB.Add;
554: RAISE FND_API.G_EXC_ERROR;
555: WHEN OTHERS THEN
556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
558: FND_MSG_PUB.Add;

Line 559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

555: WHEN OTHERS THEN
556: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_SCT_GET_SCT_ID');
557: FND_MESSAGE.Set_Token('SECTION_ID', p_child_section_id);
558: FND_MSG_PUB.Add;
559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END;
561:
562: -- Validate if the entry is duplicate
563: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,

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

559: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
560: END;
561:
562: -- Validate if the entry is duplicate
563: Check_Duplicate_Entry(p_init_msg_list => FND_API.G_FALSE,
564: p_mini_site_id => p_mini_site_id,
565: p_parent_section_id => p_parent_section_id,
566: p_child_section_id => p_child_section_id,
567: x_return_status => l_return_status,

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

567: x_return_status => l_return_status,
568: x_msg_count => l_msg_count,
569: x_msg_data => l_msg_data);
570:
571: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
575: FND_MSG_PUB.Add;

Line 572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

568: x_msg_count => l_msg_count,
569: x_msg_data => l_msg_data);
570:
571: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- duplicate entry

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

569: x_msg_data => l_msg_data);
570:
571: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
577: END IF;

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

572: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
573: ELSIF (l_return_status = FND_API.G_RET_STS_SUCCESS) THEN
574: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_DUPLICATE_ENTRY');
575: FND_MSG_PUB.Add;
576: RAISE FND_API.G_EXC_ERROR; -- duplicate entry
577: END IF;
578:
579: EXCEPTION
580:

Line 581: WHEN FND_API.G_EXC_ERROR THEN

577: END IF;
578:
579: EXCEPTION
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data,
585: p_encoded => 'F');

Line 582: x_return_status := FND_API.G_RET_STS_ERROR;

578:
579: EXCEPTION
580:
581: WHEN FND_API.G_EXC_ERROR THEN
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data,
585: p_encoded => 'F');
586:

Line 587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

583: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
584: p_data => x_msg_data,
585: p_encoded => 'F');
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
590: p_data => x_msg_data,
591: p_encoded => 'F');

Line 588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

584: p_data => x_msg_data,
585: p_encoded => 'F');
586:
587: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
588: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
589: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
590: p_data => x_msg_data,
591: p_encoded => 'F');
592:

Line 594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

590: p_data => x_msg_data,
591: p_encoded => 'F');
592:
593: WHEN OTHERS THEN
594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
595:
596: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
597: THEN
598: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

607:
608: --*****************************************************************************
609: -- PROCEDURE Validate_Update()
610: --*****************************************************************************
611: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
612: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
613:
614: PROCEDURE Validate_Update
615: (

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

608: --*****************************************************************************
609: -- PROCEDURE Validate_Update()
610: --*****************************************************************************
611: -- IF x_return_status := FND_API.G_RET_STS_ERROR, then invalid
612: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
613:
614: PROCEDURE Validate_Update
615: (
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

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

612: -- IF x_return_status := FND_API.G_RET_STS_SUCCESS, then valid
613:
614: PROCEDURE Validate_Update
615: (
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
618: p_mini_site_section_section_id IN NUMBER,
619: p_object_version_number IN NUMBER,
620: p_start_date_active IN DATE,

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

613:
614: PROCEDURE Validate_Update
615: (
616: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
617: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
618: p_mini_site_section_section_id IN NUMBER,
619: p_object_version_number IN NUMBER,
620: p_start_date_active IN DATE,
621: p_end_date_active IN DATE,

Line 644: IF FND_API.to_Boolean(p_init_msg_list) THEN

640:
641: BEGIN
642:
643: -- Initialize message list if p_init_msg_list is set to TRUE.
644: IF FND_API.to_Boolean(p_init_msg_list) THEN
645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success

Line 649: x_return_status := FND_API.G_RET_STS_SUCCESS;

645: FND_MSG_PUB.initialize;
646: END IF;
647:
648: -- Initialize API return status to success
649: x_return_status := FND_API.G_RET_STS_SUCCESS;
650:
651: --
652: -- Check null values for required fields
653: --

Line 659: RAISE FND_API.G_EXC_ERROR;

655: -- mini_site_section_section_id
656: IF (p_mini_site_section_section_id IS NULL) THEN
657: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NULL_PRIMARY_KEY');
658: FND_MSG_PUB.Add;
659: RAISE FND_API.G_EXC_ERROR;
660: END IF;
661:
662: -- start_date_active
663: IF (p_start_date_active IS NULL) THEN

Line 666: RAISE FND_API.G_EXC_ERROR;

662: -- start_date_active
663: IF (p_start_date_active IS NULL) THEN
664: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_START_DATE');
665: FND_MSG_PUB.Add;
666: RAISE FND_API.G_EXC_ERROR;
667: END IF;
668:
669: --
670: -- non-null field validation

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

671: --
672:
673: -- level number
674: IF ((p_level_number IS NOT NULL) AND
675: (p_level_number <> FND_API.G_MISS_NUM))
676: THEN
677: IF(p_level_number < 0) THEN
678: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
679: FND_MSG_PUB.Add;

Line 680: RAISE FND_API.G_EXC_ERROR;

676: THEN
677: IF(p_level_number < 0) THEN
678: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_LVL_NUM');
679: FND_MSG_PUB.Add;
680: RAISE FND_API.G_EXC_ERROR;
681: END IF;
682: END IF;
683:
684: -- sort order

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

682: END IF;
683:
684: -- sort order
685: IF ((p_sort_order IS NOT NULL) AND
686: (p_sort_order <> FND_API.G_MISS_NUM))
687: THEN
688: IF(p_sort_order < 0) THEN
689: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
690: FND_MSG_PUB.Add;

Line 691: RAISE FND_API.G_EXC_ERROR;

687: THEN
688: IF(p_sort_order < 0) THEN
689: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_INVALID_SCT_SORT_ORDER');
690: FND_MSG_PUB.Add;
691: RAISE FND_API.G_EXC_ERROR;
692: END IF;
693: END IF;
694:
695: EXCEPTION

Line 697: WHEN FND_API.G_EXC_ERROR THEN

693: END IF;
694:
695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => 'F');

Line 698: x_return_status := FND_API.G_RET_STS_ERROR;

694:
695: EXCEPTION
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: x_return_status := FND_API.G_RET_STS_ERROR;
699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => 'F');
702:

Line 703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

699: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
700: p_data => x_msg_data,
701: p_encoded => 'F');
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => 'F');

Line 704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

700: p_data => x_msg_data,
701: p_encoded => 'F');
702:
703: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
705: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
706: p_data => x_msg_data,
707: p_encoded => 'F');
708:

Line 710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

706: p_data => x_msg_data,
707: p_encoded => 'F');
708:
709: WHEN OTHERS THEN
710: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
711:
712: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
713: THEN
714: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

726:
727: PROCEDURE Create_MSite_Section_Section
728: (
729: p_api_version IN NUMBER,
730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: p_mini_site_id IN NUMBER,
734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

727: PROCEDURE Create_MSite_Section_Section
728: (
729: p_api_version IN NUMBER,
730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: p_mini_site_id IN NUMBER,
734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
735: p_child_section_id IN NUMBER,

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

728: (
729: p_api_version IN NUMBER,
730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: p_mini_site_id IN NUMBER,
734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
735: p_child_section_id IN NUMBER,
736: p_start_date_active IN DATE,

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

730: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
731: p_commit IN VARCHAR2 := FND_API.G_FALSE,
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733: p_mini_site_id IN NUMBER,
734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
735: p_child_section_id IN NUMBER,
736: p_start_date_active IN DATE,
737: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
738: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

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

733: p_mini_site_id IN NUMBER,
734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
735: p_child_section_id IN NUMBER,
736: p_start_date_active IN DATE,
737: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
738: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
739: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
740: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: x_mini_site_section_section_id OUT NUMBER,

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

734: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
735: p_child_section_id IN NUMBER,
736: p_start_date_active IN DATE,
737: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
738: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
739: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
740: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: x_mini_site_section_section_id OUT NUMBER,
742: x_return_status OUT VARCHAR2,

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

735: p_child_section_id IN NUMBER,
736: p_start_date_active IN DATE,
737: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
738: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
739: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
740: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: x_mini_site_section_section_id OUT NUMBER,
742: x_return_status OUT VARCHAR2,
743: x_msg_count OUT NUMBER,

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

736: p_start_date_active IN DATE,
737: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
738: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
739: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
740: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
741: x_mini_site_section_section_id OUT NUMBER,
742: x_return_status OUT VARCHAR2,
743: x_msg_count OUT NUMBER,
744: x_msg_data OUT VARCHAR2

Line 763: IF NOT FND_API.Compatible_API_Call(l_api_version,

759: -- Standard Start of API savepoint
760: SAVEPOINT CREATE_MSITE_SCT_SECT_PVT;
761:
762: -- Standard call to check for call compatibility.
763: IF NOT FND_API.Compatible_API_Call(l_api_version,
764: p_api_version,
765: l_api_name,
766: G_PKG_NAME)
767: THEN

Line 768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

764: p_api_version,
765: l_api_name,
766: G_PKG_NAME)
767: THEN
768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE.
772: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 772: IF FND_API.to_Boolean(p_init_msg_list) THEN

768: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
769: END IF;
770:
771: -- Initialize message list if p_init_msg_list is set to TRUE.
772: IF FND_API.to_Boolean(p_init_msg_list) THEN
773: FND_MSG_PUB.initialize;
774: END IF;
775:
776: -- Initialize API return status to success

Line 777: x_return_status := FND_API.G_RET_STS_SUCCESS;

773: FND_MSG_PUB.initialize;
774: END IF;
775:
776: -- Initialize API return status to success
777: x_return_status := FND_API.G_RET_STS_SUCCESS;
778:
779: -- API body
780: -- CALL FLOW :
781: -- 1. Validate

Line 790: p_init_msg_list => FND_API.G_FALSE,

786: -- 1. Validate
787: --
788: Validate_Create
789: (
790: p_init_msg_list => FND_API.G_FALSE,
791: p_validation_level => p_validation_level,
792: p_mini_site_id => p_mini_site_id,
793: p_parent_section_id => p_parent_section_id,
794: p_child_section_id => p_child_section_id,

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

801: x_msg_count => l_msg_count,
802: x_msg_data => l_msg_data
803: );
804:
805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');
809: FND_MSG_PUB.Add;

Line 806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

802: x_msg_data => l_msg_data
803: );
804:
805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid

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

803: );
804:
805: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid
811: END IF;

Line 810: RAISE FND_API.G_EXC_ERROR; -- invalid

806: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
807: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
808: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_CREATE');
809: FND_MSG_PUB.Add;
810: RAISE FND_API.G_EXC_ERROR; -- invalid
811: END IF;
812:
813: --
814: -- 2. Insert row

Line 819: FND_API.G_MISS_NUM,

815: --
816: BEGIN
817: insert_row
818: (
819: FND_API.G_MISS_NUM,
820: l_object_version_number,
821: p_mini_site_id,
822: p_parent_section_id,
823: p_child_section_id,

Line 841: RAISE FND_API.G_EXC_ERROR;

837: EXCEPTION
838: WHEN NO_DATA_FOUND THEN
839: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
840: FND_MSG_PUB.Add;
841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
844: FND_MSG_PUB.Add;
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

841: RAISE FND_API.G_EXC_ERROR;
842: WHEN OTHERS THEN
843: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INSERT_FAIL');
844: FND_MSG_PUB.Add;
845: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
846: END;
847:
848: --
849: -- End of main API body.

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

848: --
849: -- End of main API body.
850:
851: -- Standard check of p_commit.
852: IF (FND_API.To_Boolean(p_commit)) THEN
853: COMMIT WORK;
854: END IF;
855:
856: -- Standard call to get message count and if count is 1, get message info.

Line 863: WHEN FND_API.G_EXC_ERROR THEN

859: p_encoded => 'F');
860:
861: EXCEPTION
862:
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data,

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

861: EXCEPTION
862:
863: WHEN FND_API.G_EXC_ERROR THEN
864: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
865: x_return_status := FND_API.G_RET_STS_ERROR;
866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data,
868: p_encoded => 'F');
869:

Line 870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

866: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
867: p_data => x_msg_data,
868: p_encoded => 'F');
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
874: p_data => x_msg_data,

Line 872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

868: p_encoded => 'F');
869:
870: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
871: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
872: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
873: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
874: p_data => x_msg_data,
875: p_encoded => 'F');
876:

Line 879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

875: p_encoded => 'F');
876:
877: WHEN OTHERS THEN
878: ROLLBACK TO CREATE_MSITE_SCT_SECT_PVT;
879: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
880:
881: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
882: THEN
883: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

891:
892: PROCEDURE Update_MSite_Section_Section
893: (
894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,

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

892: PROCEDURE Update_MSite_Section_Section
893: (
894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

893: (
894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

894: p_api_version IN NUMBER,
895: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

896: p_commit IN VARCHAR2 := FND_API.G_FALSE,
897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,

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

897: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,

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

898: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,

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

899: p_object_version_number IN NUMBER,
900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
907: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,

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

900: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
907: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: x_return_status OUT VARCHAR2,

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

901: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
907: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,

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

902: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
907: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2

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

903: p_start_date_active IN DATE := FND_API.G_MISS_DATE,
904: p_end_date_active IN DATE := FND_API.G_MISS_DATE,
905: p_level_number IN NUMBER := FND_API.G_MISS_NUM,
906: p_sort_order IN NUMBER := FND_API.G_MISS_NUM,
907: p_concat_ids IN VARCHAR2 := FND_API.G_MISS_CHAR,
908: x_return_status OUT VARCHAR2,
909: x_msg_count OUT NUMBER,
910: x_msg_data OUT VARCHAR2
911: )

Line 927: IF NOT FND_API.Compatible_API_Call(l_api_version,

923: -- Standard Start of API savepoint
924: SAVEPOINT UPDATE_MSITE_SCT_SECT_PVT;
925:
926: -- Standard call to check for call compatibility.
927: IF NOT FND_API.Compatible_API_Call(l_api_version,
928: p_api_version,
929: l_api_name,
930: G_PKG_NAME)
931: THEN

Line 932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

928: p_api_version,
929: l_api_name,
930: G_PKG_NAME)
931: THEN
932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: -- Initialize message list if p_init_msg_list is set to TRUE.
936: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 936: IF FND_API.to_Boolean(p_init_msg_list) THEN

932: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
933: END IF;
934:
935: -- Initialize message list if p_init_msg_list is set to TRUE.
936: IF FND_API.to_Boolean(p_init_msg_list) THEN
937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: -- Initialize API return status to success

Line 941: x_return_status := FND_API.G_RET_STS_SUCCESS;

937: FND_MSG_PUB.initialize;
938: END IF;
939:
940: -- Initialize API return status to success
941: x_return_status := FND_API.G_RET_STS_SUCCESS;
942:
943: -- API body
944: -- CALL FLOW :
945: -- 1. Check if either mini_site_section_section_id or combination of

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

949:
950: -- 1. Check if either mini_site_section_section_id or combination of
951: -- mini_site_id, parent_section_id and child_section_id is specified
952: IF ((p_mini_site_section_section_id IS NOT NULL) AND
953: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))
954: THEN
955: -- mini_site_section_section_id specified, continue
956: l_msite_sct_sect_id := p_mini_site_section_section_id;
957: ELSIF ((p_mini_site_id IS NOT NULL) AND

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

954: THEN
955: -- mini_site_section_section_id specified, continue
956: l_msite_sct_sect_id := p_mini_site_section_section_id;
957: ELSIF ((p_mini_site_id IS NOT NULL) AND
958: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
959: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
960: (p_child_section_id IS NOT NULL) AND
961: (p_child_section_id <> FND_API.G_MISS_NUM))
962: THEN

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

955: -- mini_site_section_section_id specified, continue
956: l_msite_sct_sect_id := p_mini_site_section_section_id;
957: ELSIF ((p_mini_site_id IS NOT NULL) AND
958: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
959: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
960: (p_child_section_id IS NOT NULL) AND
961: (p_child_section_id <> FND_API.G_MISS_NUM))
962: THEN
963: -- If combination of mini_site_id, parent_section_id and child_section_id

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

957: ELSIF ((p_mini_site_id IS NOT NULL) AND
958: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
959: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
960: (p_child_section_id IS NOT NULL) AND
961: (p_child_section_id <> FND_API.G_MISS_NUM))
962: THEN
963: -- If combination of mini_site_id, parent_section_id and child_section_id
964: -- is specified, then query for mini_site_section_section_id
965: BEGIN

Line 994: RAISE FND_API.G_EXC_ERROR;

990: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
991: END IF;
992: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
993: FND_MSG_PUB.Add;
994: RAISE FND_API.G_EXC_ERROR;
995: WHEN OTHERS THEN
996: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
997: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
998: IF (p_parent_section_id IS NOT NULL) THEN

Line 1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1001: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1002: END IF;
1003: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1004: FND_MSG_PUB.Add;
1005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1006: END;
1007: ELSE
1008: -- neither mini_site_section_section_id nor combination of
1009: -- mini_site_id, parent_section_id and child_section_id is specified

Line 1012: RAISE FND_API.G_EXC_ERROR;

1008: -- neither mini_site_section_section_id nor combination of
1009: -- mini_site_id, parent_section_id and child_section_id is specified
1010: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');
1011: FND_MSG_PUB.Add;
1012: RAISE FND_API.G_EXC_ERROR;
1013: END IF;
1014:
1015:
1016: --

Line 1021: p_init_msg_list => FND_API.G_FALSE,

1017: -- 1. Validate the input data
1018: --
1019: Validate_Update
1020: (
1021: p_init_msg_list => FND_API.G_FALSE,
1022: p_validation_level => p_validation_level,
1023: p_mini_site_section_section_id => l_msite_sct_sect_id,
1024: p_object_version_number => p_object_version_number,
1025: p_start_date_active => p_start_date_active,

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

1031: x_msg_count => l_msg_count,
1032: x_msg_data => l_msg_data
1033: );
1034:
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');
1039: FND_MSG_PUB.Add;

Line 1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1032: x_msg_data => l_msg_data
1033: );
1034:
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR; -- invalid

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

1033: );
1034:
1035: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR; -- invalid
1041: END IF;

Line 1040: RAISE FND_API.G_EXC_ERROR; -- invalid

1036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1037: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1038: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_INVALID_UPDATE');
1039: FND_MSG_PUB.Add;
1040: RAISE FND_API.G_EXC_ERROR; -- invalid
1041: END IF;
1042:
1043: -- 2. update row
1044: BEGIN

Line 1062: RAISE FND_API.G_EXC_ERROR;

1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1061: FND_MSG_PUB.Add;
1062: RAISE FND_API.G_EXC_ERROR;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1065: FND_MSG_PUB.Add;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1062: RAISE FND_API.G_EXC_ERROR;
1063: WHEN OTHERS THEN
1064: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_MSS_UPDATE_FAIL');
1065: FND_MSG_PUB.Add;
1066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1067: END;
1068:
1069: --
1070: -- End of main API body.

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

1069: --
1070: -- End of main API body.
1071:
1072: -- Standard check of p_commit.
1073: IF (FND_API.To_Boolean(p_commit)) THEN
1074: COMMIT WORK;
1075: END IF;
1076:
1077: -- Standard call to get message count and if count is 1, get message info.

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080: p_encoded => 'F');
1081:
1082: EXCEPTION
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1088: p_data => x_msg_data,

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

1082: EXCEPTION
1083:
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1088: p_data => x_msg_data,
1089: p_encoded => 'F');
1090:

Line 1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1088: p_data => x_msg_data,
1089: p_encoded => 'F');
1090:
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1095: p_data => x_msg_data,

Line 1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1089: p_encoded => 'F');
1090:
1091: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1092: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1094: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1095: p_data => x_msg_data,
1096: p_encoded => 'F');
1097:

Line 1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1096: p_encoded => 'F');
1097:
1098: WHEN OTHERS THEN
1099: ROLLBACK TO UPDATE_MSITE_SCT_SECT_PVT;
1100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1101:
1102: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1103: THEN
1104: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1113:
1114: PROCEDURE Delete_MSite_Section_Section
1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,

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

1114: PROCEDURE Delete_MSite_Section_Section
1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

1115: (
1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1123: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,

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

1116: p_api_version IN NUMBER,
1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1123: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1124: x_return_status OUT VARCHAR2,

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

1117: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1123: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1124: x_return_status OUT VARCHAR2,
1125: x_msg_count OUT NUMBER,

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

1118: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1123: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1124: x_return_status OUT VARCHAR2,
1125: x_msg_count OUT NUMBER,
1126: x_msg_data OUT VARCHAR2

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

1119: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1120: p_mini_site_section_section_id IN NUMBER := FND_API.G_MISS_NUM,
1121: p_mini_site_id IN NUMBER := FND_API.G_MISS_NUM,
1122: p_parent_section_id IN NUMBER := FND_API.G_MISS_NUM,
1123: p_child_section_id IN NUMBER := FND_API.G_MISS_NUM,
1124: x_return_status OUT VARCHAR2,
1125: x_msg_count OUT NUMBER,
1126: x_msg_data OUT VARCHAR2
1127: )

Line 1138: IF NOT FND_API.Compatible_API_Call(l_api_version,

1134: -- Standard Start of API savepoint
1135: SAVEPOINT DELETE_MSITE_SCT_SECT_PVT;
1136:
1137: -- Standard call to check for call compatibility.
1138: IF NOT FND_API.Compatible_API_Call(l_api_version,
1139: p_api_version,
1140: l_api_name,
1141: G_PKG_NAME)
1142: THEN

Line 1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1139: p_api_version,
1140: l_api_name,
1141: G_PKG_NAME)
1142: THEN
1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END IF;
1145:
1146: -- Initialize message list if p_init_msg_list is set to TRUE.
1147: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1147: IF FND_API.to_Boolean(p_init_msg_list) THEN

1143: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1144: END IF;
1145:
1146: -- Initialize message list if p_init_msg_list is set to TRUE.
1147: IF FND_API.to_Boolean(p_init_msg_list) THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151: -- Initialize API return status to success

Line 1152: x_return_status := FND_API.G_RET_STS_SUCCESS;

1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:
1151: -- Initialize API return status to success
1152: x_return_status := FND_API.G_RET_STS_SUCCESS;
1153:
1154: -- CALL FLOW
1155: -- 1. If mini_site_section_section_id specified, delete all references for it
1156: -- 2. If combination of mini_site_id, parent_section_id and child_section_id

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

1158: -- all references
1159:
1160: -- 1. If mini_site_section_section_id specified, delete all references for it
1161: IF ((p_mini_site_section_section_id IS NOT NULL) AND
1162: (p_mini_site_section_section_id <> FND_API.G_MISS_NUM))
1163: THEN
1164: -- mini_site_section_section_id specified, continue
1165: l_msite_sct_sect_id := p_mini_site_section_section_id;
1166: ELSIF ((p_mini_site_id IS NOT NULL) AND

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

1163: THEN
1164: -- mini_site_section_section_id specified, continue
1165: l_msite_sct_sect_id := p_mini_site_section_section_id;
1166: ELSIF ((p_mini_site_id IS NOT NULL) AND
1167: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1168: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1169: (p_child_section_id IS NOT NULL) AND
1170: (p_child_section_id <> FND_API.G_MISS_NUM))
1171: THEN

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

1164: -- mini_site_section_section_id specified, continue
1165: l_msite_sct_sect_id := p_mini_site_section_section_id;
1166: ELSIF ((p_mini_site_id IS NOT NULL) AND
1167: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1168: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1169: (p_child_section_id IS NOT NULL) AND
1170: (p_child_section_id <> FND_API.G_MISS_NUM))
1171: THEN
1172: -- If combination of mini_site_id, parent_section_id and child_section_id

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

1166: ELSIF ((p_mini_site_id IS NOT NULL) AND
1167: (p_mini_site_id <> FND_API.G_MISS_NUM) AND
1168: (p_parent_section_id <> FND_API.G_MISS_NUM) AND -- parent can be NULL
1169: (p_child_section_id IS NOT NULL) AND
1170: (p_child_section_id <> FND_API.G_MISS_NUM))
1171: THEN
1172: -- If combination of mini_site_id, parent_section_id and child_section_id
1173: -- is specified, then query for mini_site_section_section_id
1174: BEGIN

Line 1203: RAISE FND_API.G_EXC_ERROR;

1199: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1200: END IF;
1201: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1202: FND_MSG_PUB.Add;
1203: RAISE FND_API.G_EXC_ERROR;
1204: WHEN OTHERS THEN
1205: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_ID');
1206: FND_MESSAGE.Set_Token('MINI_SITE_ID', p_mini_site_id);
1207: IF (p_parent_section_id IS NOT NULL) THEN

Line 1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1210: FND_MESSAGE.Set_Token('PARENT_SECTION_ID', 'NULL');
1211: END IF;
1212: FND_MESSAGE.Set_Token('CHILD_SECTION_ID', p_child_section_id);
1213: FND_MSG_PUB.Add;
1214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1215: END;
1216:
1217: ELSE
1218: -- neither mini_site_section_section_id nor combination of

Line 1222: RAISE FND_API.G_EXC_ERROR;

1218: -- neither mini_site_section_section_id nor combination of
1219: -- mini_site_id, parent_section_id and child_section_id is specified
1220: FND_MESSAGE.Set_Name('JTF', 'JTF_DSP_NO_MSS_IDS_SPEC');
1221: FND_MSG_PUB.Add;
1222: RAISE FND_API.G_EXC_ERROR;
1223: END IF;
1224:
1225: -- delete row
1226: delete_row(l_msite_sct_sect_id);

Line 1230: WHEN FND_API.G_EXC_ERROR THEN

1226: delete_row(l_msite_sct_sect_id);
1227:
1228: EXCEPTION
1229:
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1234: p_data => x_msg_data,

Line 1232: x_return_status := FND_API.G_RET_STS_ERROR;

1228: EXCEPTION
1229:
1230: WHEN FND_API.G_EXC_ERROR THEN
1231: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1232: x_return_status := FND_API.G_RET_STS_ERROR;
1233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1234: p_data => x_msg_data,
1235: p_encoded => 'F');
1236:

Line 1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1233: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1234: p_data => x_msg_data,
1235: p_encoded => 'F');
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1241: p_data => x_msg_data,

Line 1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1235: p_encoded => 'F');
1236:
1237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1238: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1240: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1241: p_data => x_msg_data,
1242: p_encoded => 'F');
1243:

Line 1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1242: p_encoded => 'F');
1243:
1244: WHEN OTHERS THEN
1245: ROLLBACK TO DELETE_MSITE_SCT_SECT_PVT;
1246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1247:
1248: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
1249: THEN
1250: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME, l_api_name );

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

1258:
1259: PROCEDURE Update_MSite_Section_Sections
1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1265: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1266: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

1259: PROCEDURE Update_MSite_Section_Sections
1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1265: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1266: p_object_version_numbers IN JTF_NUMBER_TABLE,
1267: p_start_date_actives IN JTF_DATE_TABLE,

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

1260: (
1261: p_api_version IN NUMBER,
1262: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1263: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1264: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1265: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1266: p_object_version_numbers IN JTF_NUMBER_TABLE,
1267: p_start_date_actives IN JTF_DATE_TABLE,
1268: p_end_date_actives IN JTF_DATE_TABLE,

Line 1289: IF NOT FND_API.Compatible_API_Call(l_api_version,

1285: -- Standard Start of API savepoint
1286: SAVEPOINT UPDATE_MSITE_SCT_SECTS_PVT;
1287:
1288: -- Standard call to check for call compatibility.
1289: IF NOT FND_API.Compatible_API_Call(l_api_version,
1290: p_api_version,
1291: l_api_name,
1292: G_PKG_NAME)
1293: THEN

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290: p_api_version,
1291: l_api_name,
1292: G_PKG_NAME)
1293: THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296:
1297: -- Initialize message list if p_init_msg_list is set to TRUE.
1298: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1298: IF FND_API.to_Boolean(p_init_msg_list) THEN

1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: END IF;
1296:
1297: -- Initialize message list if p_init_msg_list is set to TRUE.
1298: IF FND_API.to_Boolean(p_init_msg_list) THEN
1299: FND_MSG_PUB.initialize;
1300: END IF;
1301:
1302: -- Initialize API return status to success

Line 1303: x_return_status := FND_API.G_RET_STS_SUCCESS;

1299: FND_MSG_PUB.initialize;
1300: END IF;
1301:
1302: -- Initialize API return status to success
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: -- API body
1306: -- CALL FLOW :
1307: -- 1.

Line 1313: p_init_msg_list => FND_API.G_FALSE,

1309:
1310: Update_MSite_Section_Section
1311: (
1312: p_api_version => p_api_version,
1313: p_init_msg_list => FND_API.G_FALSE,
1314: p_commit => FND_API.G_FALSE,
1315: p_validation_level => p_validation_level,
1316: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1317: p_object_version_number => p_object_version_numbers(i),

Line 1314: p_commit => FND_API.G_FALSE,

1310: Update_MSite_Section_Section
1311: (
1312: p_api_version => p_api_version,
1313: p_init_msg_list => FND_API.G_FALSE,
1314: p_commit => FND_API.G_FALSE,
1315: p_validation_level => p_validation_level,
1316: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1317: p_object_version_number => p_object_version_numbers(i),
1318: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1318: p_mini_site_id => FND_API.G_MISS_NUM,

1314: p_commit => FND_API.G_FALSE,
1315: p_validation_level => p_validation_level,
1316: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1317: p_object_version_number => p_object_version_numbers(i),
1318: p_mini_site_id => FND_API.G_MISS_NUM,
1319: p_parent_section_id => FND_API.G_MISS_NUM,
1320: p_child_section_id => FND_API.G_MISS_NUM,
1321: p_start_date_active => p_start_date_actives(i),
1322: p_end_date_active => p_end_date_actives(i),

Line 1319: p_parent_section_id => FND_API.G_MISS_NUM,

1315: p_validation_level => p_validation_level,
1316: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1317: p_object_version_number => p_object_version_numbers(i),
1318: p_mini_site_id => FND_API.G_MISS_NUM,
1319: p_parent_section_id => FND_API.G_MISS_NUM,
1320: p_child_section_id => FND_API.G_MISS_NUM,
1321: p_start_date_active => p_start_date_actives(i),
1322: p_end_date_active => p_end_date_actives(i),
1323: p_level_number => FND_API.G_MISS_NUM,

Line 1320: p_child_section_id => FND_API.G_MISS_NUM,

1316: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1317: p_object_version_number => p_object_version_numbers(i),
1318: p_mini_site_id => FND_API.G_MISS_NUM,
1319: p_parent_section_id => FND_API.G_MISS_NUM,
1320: p_child_section_id => FND_API.G_MISS_NUM,
1321: p_start_date_active => p_start_date_actives(i),
1322: p_end_date_active => p_end_date_actives(i),
1323: p_level_number => FND_API.G_MISS_NUM,
1324: p_sort_order => p_sort_orders(i),

Line 1323: p_level_number => FND_API.G_MISS_NUM,

1319: p_parent_section_id => FND_API.G_MISS_NUM,
1320: p_child_section_id => FND_API.G_MISS_NUM,
1321: p_start_date_active => p_start_date_actives(i),
1322: p_end_date_active => p_end_date_actives(i),
1323: p_level_number => FND_API.G_MISS_NUM,
1324: p_sort_order => p_sort_orders(i),
1325: p_concat_ids => FND_API.G_MISS_CHAR,
1326: x_return_status => l_return_status,
1327: x_msg_count => x_msg_count,

Line 1325: p_concat_ids => FND_API.G_MISS_CHAR,

1321: p_start_date_active => p_start_date_actives(i),
1322: p_end_date_active => p_end_date_actives(i),
1323: p_level_number => FND_API.G_MISS_NUM,
1324: p_sort_order => p_sort_orders(i),
1325: p_concat_ids => FND_API.G_MISS_CHAR,
1326: x_return_status => l_return_status,
1327: x_msg_count => x_msg_count,
1328: x_msg_data => x_msg_data
1329: );

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

1327: x_msg_count => x_msg_count,
1328: x_msg_data => x_msg_data
1329: );
1330:
1331: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328: x_msg_data => x_msg_data
1329: );
1330:
1331: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;
1336:

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

1329: );
1330:
1331: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;
1336:
1337: END LOOP;

Line 1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1330:
1331: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1332: RAISE FND_API.G_EXC_ERROR;
1333: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1335: END IF;
1336:
1337: END LOOP;
1338:

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

1339: --
1340: -- End of main API body.
1341:
1342: -- Standard check of p_commit.
1343: IF (FND_API.To_Boolean(p_commit)) THEN
1344: COMMIT WORK;
1345: END IF;
1346:
1347: -- Standard call to get message count and if count is 1, get message info.

Line 1354: WHEN FND_API.G_EXC_ERROR THEN

1350: p_encoded => 'F');
1351:
1352: EXCEPTION
1353:
1354: WHEN FND_API.G_EXC_ERROR THEN
1355: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1358: p_data => x_msg_data,

Line 1356: x_return_status := FND_API.G_RET_STS_ERROR;

1352: EXCEPTION
1353:
1354: WHEN FND_API.G_EXC_ERROR THEN
1355: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1356: x_return_status := FND_API.G_RET_STS_ERROR;
1357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1358: p_data => x_msg_data,
1359: p_encoded => 'F');
1360:

Line 1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1357: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1358: p_data => x_msg_data,
1359: p_encoded => 'F');
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1365: p_data => x_msg_data,

Line 1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1359: p_encoded => 'F');
1360:
1361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1362: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1365: p_data => x_msg_data,
1366: p_encoded => 'F');
1367:

Line 1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1366: p_encoded => 'F');
1367:
1368: WHEN OTHERS THEN
1369: ROLLBACK TO UPDATE_MSITE_SCT_SECTS_PVT;
1370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1371:
1372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1373: THEN
1374: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1382:
1383: PROCEDURE Update_Delete_Sct_Scts
1384: (
1385: p_api_version IN NUMBER,
1386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1389: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1390: p_object_version_numbers IN JTF_NUMBER_TABLE,

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

1383: PROCEDURE Update_Delete_Sct_Scts
1384: (
1385: p_api_version IN NUMBER,
1386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1389: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1390: p_object_version_numbers IN JTF_NUMBER_TABLE,
1391: p_start_date_actives IN JTF_DATE_TABLE,

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

1384: (
1385: p_api_version IN NUMBER,
1386: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1387: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1388: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1389: p_msite_section_section_ids IN JTF_NUMBER_TABLE,
1390: p_object_version_numbers IN JTF_NUMBER_TABLE,
1391: p_start_date_actives IN JTF_DATE_TABLE,
1392: p_end_date_actives IN JTF_DATE_TABLE,

Line 1414: IF NOT FND_API.Compatible_API_Call(l_api_version,

1410: -- Standard Start of API savepoint
1411: SAVEPOINT UPDATE_DELETE_SCT_SCTS_PVT;
1412:
1413: -- Standard call to check for call compatibility.
1414: IF NOT FND_API.Compatible_API_Call(l_api_version,
1415: p_api_version,
1416: l_api_name,
1417: G_PKG_NAME)
1418: THEN

Line 1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1415: p_api_version,
1416: l_api_name,
1417: G_PKG_NAME)
1418: THEN
1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;
1421:
1422: -- Initialize message list if p_init_msg_list is set to TRUE.
1423: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1423: IF FND_API.to_Boolean(p_init_msg_list) THEN

1419: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1420: END IF;
1421:
1422: -- Initialize message list if p_init_msg_list is set to TRUE.
1423: IF FND_API.to_Boolean(p_init_msg_list) THEN
1424: FND_MSG_PUB.initialize;
1425: END IF;
1426:
1427: -- Initialize API return status to success

Line 1428: x_return_status := FND_API.G_RET_STS_SUCCESS;

1424: FND_MSG_PUB.initialize;
1425: END IF;
1426:
1427: -- Initialize API return status to success
1428: x_return_status := FND_API.G_RET_STS_SUCCESS;
1429:
1430: -- API body
1431: -- CALL FLOW :
1432: -- 1.

Line 1441: p_init_msg_list => FND_API.G_FALSE,

1437:
1438: Delete_MSite_Section_Section
1439: (
1440: p_api_version => p_api_version,
1441: p_init_msg_list => FND_API.G_FALSE,
1442: p_commit => FND_API.G_FALSE,
1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1442: p_commit => FND_API.G_FALSE,

1438: Delete_MSite_Section_Section
1439: (
1440: p_api_version => p_api_version,
1441: p_init_msg_list => FND_API.G_FALSE,
1442: p_commit => FND_API.G_FALSE,
1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,
1446: p_parent_section_id => FND_API.G_MISS_NUM,

Line 1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1439: (
1440: p_api_version => p_api_version,
1441: p_init_msg_list => FND_API.G_FALSE,
1442: p_commit => FND_API.G_FALSE,
1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,
1446: p_parent_section_id => FND_API.G_MISS_NUM,
1447: p_child_section_id => FND_API.G_MISS_NUM,

Line 1445: p_mini_site_id => FND_API.G_MISS_NUM,

1441: p_init_msg_list => FND_API.G_FALSE,
1442: p_commit => FND_API.G_FALSE,
1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,
1446: p_parent_section_id => FND_API.G_MISS_NUM,
1447: p_child_section_id => FND_API.G_MISS_NUM,
1448: x_return_status => x_return_status,
1449: x_msg_count => x_msg_count,

Line 1446: p_parent_section_id => FND_API.G_MISS_NUM,

1442: p_commit => FND_API.G_FALSE,
1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,
1446: p_parent_section_id => FND_API.G_MISS_NUM,
1447: p_child_section_id => FND_API.G_MISS_NUM,
1448: x_return_status => x_return_status,
1449: x_msg_count => x_msg_count,
1450: x_msg_data => x_msg_data

Line 1447: p_child_section_id => FND_API.G_MISS_NUM,

1443: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1444: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1445: p_mini_site_id => FND_API.G_MISS_NUM,
1446: p_parent_section_id => FND_API.G_MISS_NUM,
1447: p_child_section_id => FND_API.G_MISS_NUM,
1448: x_return_status => x_return_status,
1449: x_msg_count => x_msg_count,
1450: x_msg_data => x_msg_data
1451: );

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

1449: x_msg_count => x_msg_count,
1450: x_msg_data => x_msg_data
1451: );
1452:
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;

Line 1454: RAISE FND_API.G_EXC_ERROR;

1450: x_msg_data => x_msg_data
1451: );
1452:
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458:

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

1451: );
1452:
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458:
1459: ELSE

Line 1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1452:
1453: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1454: RAISE FND_API.G_EXC_ERROR;
1455: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1456: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1457: END IF;
1458:
1459: ELSE
1460:

Line 1464: p_init_msg_list => FND_API.G_FALSE,

1460:
1461: Update_Msite_Section_Section
1462: (
1463: p_api_version => p_api_version,
1464: p_init_msg_list => FND_API.G_FALSE,
1465: p_commit => FND_API.G_FALSE,
1466: p_validation_level => p_validation_level,
1467: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1468: p_object_version_number => p_object_version_numbers(i),

Line 1465: p_commit => FND_API.G_FALSE,

1461: Update_Msite_Section_Section
1462: (
1463: p_api_version => p_api_version,
1464: p_init_msg_list => FND_API.G_FALSE,
1465: p_commit => FND_API.G_FALSE,
1466: p_validation_level => p_validation_level,
1467: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1468: p_object_version_number => p_object_version_numbers(i),
1469: p_mini_site_id => FND_API.G_MISS_NUM,

Line 1469: p_mini_site_id => FND_API.G_MISS_NUM,

1465: p_commit => FND_API.G_FALSE,
1466: p_validation_level => p_validation_level,
1467: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1468: p_object_version_number => p_object_version_numbers(i),
1469: p_mini_site_id => FND_API.G_MISS_NUM,
1470: p_parent_section_id => FND_API.G_MISS_NUM,
1471: p_child_section_id => FND_API.G_MISS_NUM,
1472: p_start_date_active => p_start_date_actives(i),
1473: p_end_date_active => p_end_date_actives(i),

Line 1470: p_parent_section_id => FND_API.G_MISS_NUM,

1466: p_validation_level => p_validation_level,
1467: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1468: p_object_version_number => p_object_version_numbers(i),
1469: p_mini_site_id => FND_API.G_MISS_NUM,
1470: p_parent_section_id => FND_API.G_MISS_NUM,
1471: p_child_section_id => FND_API.G_MISS_NUM,
1472: p_start_date_active => p_start_date_actives(i),
1473: p_end_date_active => p_end_date_actives(i),
1474: p_level_number => FND_API.G_MISS_NUM,

Line 1471: p_child_section_id => FND_API.G_MISS_NUM,

1467: p_mini_site_section_section_id => p_msite_section_section_ids(i),
1468: p_object_version_number => p_object_version_numbers(i),
1469: p_mini_site_id => FND_API.G_MISS_NUM,
1470: p_parent_section_id => FND_API.G_MISS_NUM,
1471: p_child_section_id => FND_API.G_MISS_NUM,
1472: p_start_date_active => p_start_date_actives(i),
1473: p_end_date_active => p_end_date_actives(i),
1474: p_level_number => FND_API.G_MISS_NUM,
1475: p_sort_order => p_sort_orders(i),

Line 1474: p_level_number => FND_API.G_MISS_NUM,

1470: p_parent_section_id => FND_API.G_MISS_NUM,
1471: p_child_section_id => FND_API.G_MISS_NUM,
1472: p_start_date_active => p_start_date_actives(i),
1473: p_end_date_active => p_end_date_actives(i),
1474: p_level_number => FND_API.G_MISS_NUM,
1475: p_sort_order => p_sort_orders(i),
1476: p_concat_ids => FND_API.G_MISS_CHAR,
1477: x_return_status => l_return_status,
1478: x_msg_count => x_msg_count,

Line 1476: p_concat_ids => FND_API.G_MISS_CHAR,

1472: p_start_date_active => p_start_date_actives(i),
1473: p_end_date_active => p_end_date_actives(i),
1474: p_level_number => FND_API.G_MISS_NUM,
1475: p_sort_order => p_sort_orders(i),
1476: p_concat_ids => FND_API.G_MISS_CHAR,
1477: x_return_status => l_return_status,
1478: x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data
1480: );

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

1478: x_msg_count => x_msg_count,
1479: x_msg_data => x_msg_data
1480: );
1481:
1482: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;

Line 1483: RAISE FND_API.G_EXC_ERROR;

1479: x_msg_data => x_msg_data
1480: );
1481:
1482: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:

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

1480: );
1481:
1482: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:
1488: END IF;

Line 1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1481:
1482: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1483: RAISE FND_API.G_EXC_ERROR;
1484: ELSIF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1485: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1486: END IF;
1487:
1488: END IF;
1489:

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

1492: --
1493: -- End of main API body.
1494:
1495: -- Standard check of p_commit.
1496: IF (FND_API.To_Boolean(p_commit)) THEN
1497: COMMIT WORK;
1498: END IF;
1499:
1500: -- Standard call to get message count and if count is 1, get message info.

Line 1507: WHEN FND_API.G_EXC_ERROR THEN

1503: p_encoded => 'F');
1504:
1505: EXCEPTION
1506:
1507: WHEN FND_API.G_EXC_ERROR THEN
1508: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1511: p_data => x_msg_data,

Line 1509: x_return_status := FND_API.G_RET_STS_ERROR;

1505: EXCEPTION
1506:
1507: WHEN FND_API.G_EXC_ERROR THEN
1508: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1509: x_return_status := FND_API.G_RET_STS_ERROR;
1510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1511: p_data => x_msg_data,
1512: p_encoded => 'F');
1513:

Line 1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1510: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1511: p_data => x_msg_data,
1512: p_encoded => 'F');
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1518: p_data => x_msg_data,

Line 1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1512: p_encoded => 'F');
1513:
1514: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1515: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1517: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1518: p_data => x_msg_data,
1519: p_encoded => 'F');
1520:

Line 1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1519: p_encoded => 'F');
1520:
1521: WHEN OTHERS THEN
1522: ROLLBACK TO UPDATE_DELETE_SCT_SCTS_PVT;
1523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1524:
1525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1526: THEN
1527: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);