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

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

102: --
103: PROCEDURE Load_SectionItems_For_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_id IN NUMBER,
110: x_section_csr OUT NOCOPY SECTION_CSR,

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

103: PROCEDURE Load_SectionItems_For_Section
104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_id IN NUMBER,
110: x_section_csr OUT NOCOPY SECTION_CSR,
111: x_sectionitem_item_csr OUT NOCOPY SECTIONITEM_ITEM_CSR,

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

104: (
105: p_api_version IN NUMBER,
106: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
107: p_commit IN VARCHAR2 := FND_API.G_FALSE,
108: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
109: p_section_id IN NUMBER,
110: x_section_csr OUT NOCOPY SECTION_CSR,
111: x_sectionitem_item_csr OUT NOCOPY SECTIONITEM_ITEM_CSR,
112: x_return_status OUT NOCOPY VARCHAR2,

Line 125: IF FND_API.to_Boolean(p_init_msg_list) THEN

121: l_organization_id NUMBER;
122: BEGIN
123:
124: -- Initialize message list if p_init_msg_list is set to TRUE.
125: IF FND_API.to_Boolean(p_init_msg_list) THEN
126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API return status to success

Line 130: x_return_status := FND_API.G_RET_STS_SUCCESS;

126: FND_MSG_PUB.initialize;
127: END IF;
128:
129: -- Initialize API return status to success
130: x_return_status := FND_API.G_RET_STS_SUCCESS;
131:
132: -- Get the section data
133: OPEN x_section_csr FOR SELECT display_name FROM ibe_dsp_sections_vl
134: WHERE section_id = p_section_id;

Line 139: RAISE FND_API.G_EXC_ERROR;

135: /* bug fix 4864940 */
136: l_organization_id_str
137: := FND_PROFILE.VALUE_SPECIFIC('IBE_ITEM_VALIDATION_ORGANIZATION',null,null,671);
138: IF (l_organization_id_str IS NULL) THEN
139: RAISE FND_API.G_EXC_ERROR;
140: ELSE
141: l_organization_id := to_number(l_organization_id_str);
142: END IF;
143:

Line 162: WHEN FND_API.G_EXC_ERROR THEN

158:
159:
160: EXCEPTION
161:
162: WHEN FND_API.G_EXC_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
165: p_data => x_msg_data,
166: p_encoded => 'F');

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

159:
160: EXCEPTION
161:
162: WHEN FND_API.G_EXC_ERROR THEN
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
165: p_data => x_msg_data,
166: p_encoded => 'F');
167:

Line 168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

164: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
165: p_data => x_msg_data,
166: p_encoded => 'F');
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => 'F');

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165: p_data => x_msg_data,
166: p_encoded => 'F');
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => 'F');
173:

Line 181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

177: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
178: FND_MESSAGE.Set_Token('REASON', SQLERRM);
179: FND_MSG_PUB.Add;
180:
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182:
183: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
184: THEN
185: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

198: --
199: PROCEDURE Load_SectionItems_For_Item
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_inventory_item_id IN NUMBER,
206: p_organization_id IN NUMBER,

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

199: PROCEDURE Load_SectionItems_For_Item
200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_inventory_item_id IN NUMBER,
206: p_organization_id IN NUMBER,
207: x_sectionitem_section_csr OUT NOCOPY SECTIONITEM_SECTION_CSR,

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

200: (
201: p_api_version IN NUMBER,
202: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
203: p_commit IN VARCHAR2 := FND_API.G_FALSE,
204: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
205: p_inventory_item_id IN NUMBER,
206: p_organization_id IN NUMBER,
207: x_sectionitem_section_csr OUT NOCOPY SECTIONITEM_SECTION_CSR,
208: x_return_status OUT NOCOPY VARCHAR2,

Line 219: IF FND_API.to_Boolean(p_init_msg_list) THEN

215: l_api_version CONSTANT NUMBER := 1.0;
216: BEGIN
217:
218: -- Initialize message list if p_init_msg_list is set to TRUE.
219: IF FND_API.to_Boolean(p_init_msg_list) THEN
220: FND_MSG_PUB.initialize;
221: END IF;
222:
223: -- Initialize API return status to success

Line 224: x_return_status := FND_API.G_RET_STS_SUCCESS;

220: FND_MSG_PUB.initialize;
221: END IF;
222:
223: -- Initialize API return status to success
224: x_return_status := FND_API.G_RET_STS_SUCCESS;
225:
226: -- Get the section-item data and section data
227: OPEN x_sectionitem_section_csr FOR SELECT S.section_id, S.display_name,
228: SI.section_item_id, SI.object_version_number, SI.start_date_active,

Line 237: WHEN FND_API.G_EXC_ERROR THEN

233: AND SI.section_id = S.section_id;
234:
235: EXCEPTION
236:
237: WHEN FND_API.G_EXC_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
240: p_data => x_msg_data,
241: p_encoded => 'F');

Line 238: x_return_status := FND_API.G_RET_STS_ERROR;

234:
235: EXCEPTION
236:
237: WHEN FND_API.G_EXC_ERROR THEN
238: x_return_status := FND_API.G_RET_STS_ERROR;
239: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
240: p_data => x_msg_data,
241: p_encoded => 'F');
242:

Line 243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

239: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
240: p_data => x_msg_data,
241: p_encoded => 'F');
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
246: p_data => x_msg_data,
247: p_encoded => 'F');

Line 244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

240: p_data => x_msg_data,
241: p_encoded => 'F');
242:
243: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
245: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
246: p_data => x_msg_data,
247: p_encoded => 'F');
248:

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
253: FND_MESSAGE.Set_Token('REASON', SQLERRM);
254: FND_MSG_PUB.Add;
255:
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257:
258: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
259: THEN
260: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

273: --
274: PROCEDURE Load_ChildSections_For_Section
275: (
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_section_id IN NUMBER,
281: x_section_csr OUT NOCOPY SECTION_CSR,

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

274: PROCEDURE Load_ChildSections_For_Section
275: (
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_section_id IN NUMBER,
281: x_section_csr OUT NOCOPY SECTION_CSR,
282: x_section_section_csr OUT NOCOPY SECTION_SECTION_CSR,

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

275: (
276: p_api_version IN NUMBER,
277: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
278: p_commit IN VARCHAR2 := FND_API.G_FALSE,
279: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
280: p_section_id IN NUMBER,
281: x_section_csr OUT NOCOPY SECTION_CSR,
282: x_section_section_csr OUT NOCOPY SECTION_SECTION_CSR,
283: x_return_status OUT NOCOPY VARCHAR2,

Line 298: IF FND_API.to_Boolean(p_init_msg_list) THEN

294:
295: BEGIN
296:
297: -- Initialize message list if p_init_msg_list is set to TRUE.
298: IF FND_API.to_Boolean(p_init_msg_list) THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: -- Initialize API return status to success

Line 303: x_return_status := FND_API.G_RET_STS_SUCCESS;

299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: -- Initialize API return status to success
303: x_return_status := FND_API.G_RET_STS_SUCCESS;
304:
305: -- Get the master mini-site id
306: IBE_DSP_HIERARCHY_SETUP_PVT.Get_Master_Mini_Site_Id
307: (

Line 357: WHEN FND_API.G_EXC_ERROR THEN

353: AND sysdate BETWEEN S.start_date_active AND NVL(S.end_date_active,sysdate)
354: ORDER BY MSS.sort_order;
355: EXCEPTION
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
360: p_data => x_msg_data,
361: p_encoded => 'F');

Line 358: x_return_status := FND_API.G_RET_STS_ERROR;

354: ORDER BY MSS.sort_order;
355: EXCEPTION
356:
357: WHEN FND_API.G_EXC_ERROR THEN
358: x_return_status := FND_API.G_RET_STS_ERROR;
359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
360: p_data => x_msg_data,
361: p_encoded => 'F');
362:

Line 363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

359: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
360: p_data => x_msg_data,
361: p_encoded => 'F');
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
366: p_data => x_msg_data,
367: p_encoded => 'F');

Line 364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

360: p_data => x_msg_data,
361: p_encoded => 'F');
362:
363: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
366: p_data => x_msg_data,
367: p_encoded => 'F');
368:

Line 376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

372: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
373: FND_MESSAGE.Set_Token('REASON', SQLERRM);
374: FND_MSG_PUB.Add;
375:
376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
377:
378: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
379: THEN
380: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

399: --
400: PROCEDURE Load_Children_For_Section
401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: p_section_id IN NUMBER,
407: x_is_leaf_section OUT NOCOPY VARCHAR2,

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

400: PROCEDURE Load_Children_For_Section
401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: p_section_id IN NUMBER,
407: x_is_leaf_section OUT NOCOPY VARCHAR2,
408: x_section_path OUT NOCOPY VARCHAR2,

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

401: (
402: p_api_version IN NUMBER,
403: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
404: p_commit IN VARCHAR2 := FND_API.G_FALSE,
405: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
406: p_section_id IN NUMBER,
407: x_is_leaf_section OUT NOCOPY VARCHAR2,
408: x_section_path OUT NOCOPY VARCHAR2,
409: x_section_csr OUT NOCOPY SECTION_CSR,

Line 434: IF FND_API.to_Boolean(p_init_msg_list) THEN

430:
431: BEGIN
432:
433: -- Initialize message list if p_init_msg_list is set to TRUE.
434: IF FND_API.to_Boolean(p_init_msg_list) THEN
435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- Initialize API return status to success

Line 439: x_return_status := FND_API.G_RET_STS_SUCCESS;

435: FND_MSG_PUB.initialize;
436: END IF;
437:
438: -- Initialize API return status to success
439: x_return_status := FND_API.G_RET_STS_SUCCESS;
440:
441: -- Get the master mini-site id
442: IBE_DSP_HIERARCHY_SETUP_PVT.Get_Master_Mini_Site_Id
443: (

Line 465: p_init_msg_list => FND_API.G_FALSE,

461: x_is_leaf_section := 'Y';
462: Load_SectionItems_For_Section
463: (
464: p_api_version => p_api_version,
465: p_init_msg_list => FND_API.G_FALSE,
466: p_commit => FND_API.G_FALSE,
467: p_validation_level => p_validation_level,
468: p_section_id => p_section_id,
469: x_section_csr => x_section_csr,

Line 466: p_commit => FND_API.G_FALSE,

462: Load_SectionItems_For_Section
463: (
464: p_api_version => p_api_version,
465: p_init_msg_list => FND_API.G_FALSE,
466: p_commit => FND_API.G_FALSE,
467: p_validation_level => p_validation_level,
468: p_section_id => p_section_id,
469: x_section_csr => x_section_csr,
470: x_sectionitem_item_csr => x_sectionitem_item_csr,

Line 476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

472: x_msg_count => x_msg_count,
473: x_msg_data => x_msg_data
474: );
475:
476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

Line 477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

473: x_msg_data => x_msg_data
474: );
475:
476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;

Line 478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

474: );
475:
476: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
477: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;
482: RAISE FND_API.G_EXC_ERROR;

Line 482: RAISE FND_API.G_EXC_ERROR;

478: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
479: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_ITM_FOR_SCT');
480: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
481: FND_MSG_PUB.Add;
482: RAISE FND_API.G_EXC_ERROR;
483: END IF;
484:
485: ELSE
486:

Line 491: p_init_msg_list => FND_API.G_FALSE,

487: x_is_leaf_section := 'N';
488: Load_ChildSections_For_Section
489: (
490: p_api_version => p_api_version,
491: p_init_msg_list => FND_API.G_FALSE,
492: p_commit => FND_API.G_FALSE,
493: p_validation_level => p_validation_level,
494: p_section_id => p_section_id,
495: x_section_csr => x_section_csr,

Line 492: p_commit => FND_API.G_FALSE,

488: Load_ChildSections_For_Section
489: (
490: p_api_version => p_api_version,
491: p_init_msg_list => FND_API.G_FALSE,
492: p_commit => FND_API.G_FALSE,
493: p_validation_level => p_validation_level,
494: p_section_id => p_section_id,
495: x_section_csr => x_section_csr,
496: x_section_section_csr => x_section_section_csr,

Line 502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

498: x_msg_count => x_msg_count,
499: x_msg_data => x_msg_data
500: );
501:
502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);

Line 503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

499: x_msg_data => x_msg_data
500: );
501:
502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;

Line 504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

500: );
501:
502: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
503: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;

Line 508: RAISE FND_API.G_EXC_ERROR;

504: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
505: FND_MESSAGE.Set_Name('IBE', 'IBE_DSP_LOAD_CHILD_SCT_FOR_SCT');
506: FND_MESSAGE.Set_Token('SECTION_ID', p_section_id);
507: FND_MSG_PUB.Add;
508: RAISE FND_API.G_EXC_ERROR;
509: END IF;
510:
511: END IF;
512:

Line 518: WHEN FND_API.G_EXC_ERROR THEN

514:
515:
516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
521: p_data => x_msg_data,
522: p_encoded => 'F');

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515:
516: EXCEPTION
517:
518: WHEN FND_API.G_EXC_ERROR THEN
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
521: p_data => x_msg_data,
522: p_encoded => 'F');
523:

Line 524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

520: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
521: p_data => x_msg_data,
522: p_encoded => 'F');
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => 'F');

Line 525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

521: p_data => x_msg_data,
522: p_encoded => 'F');
523:
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => 'F');
529:

Line 537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

533: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
534: FND_MESSAGE.Set_Token('REASON', SQLERRM);
535: FND_MSG_PUB.Add;
536:
537: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
538:
539: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
540: THEN
541: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

549:
550: PROCEDURE Load_Section_For_Basic_Desc
551: (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_section_id IN NUMBER,
557: x_section_path OUT NOCOPY VARCHAR2,

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

550: PROCEDURE Load_Section_For_Basic_Desc
551: (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_section_id IN NUMBER,
557: x_section_path OUT NOCOPY VARCHAR2,
558: x_section_csr OUT NOCOPY SECTION_CSR,

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

551: (
552: p_api_version IN NUMBER,
553: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
554: p_commit IN VARCHAR2 := FND_API.G_FALSE,
555: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
556: p_section_id IN NUMBER,
557: x_section_path OUT NOCOPY VARCHAR2,
558: x_section_csr OUT NOCOPY SECTION_CSR,
559: x_section_type_csr OUT NOCOPY SECTION_TYPE_CSR,

Line 578: IF FND_API.to_Boolean(p_init_msg_list) THEN

574:
575: BEGIN
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean(p_init_msg_list) THEN
579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success

Line 583: x_return_status := FND_API.G_RET_STS_SUCCESS;

579: FND_MSG_PUB.initialize;
580: END IF;
581:
582: -- Initialize API return status to success
583: x_return_status := FND_API.G_RET_STS_SUCCESS;
584:
585: -- Get the section data
586: OPEN x_section_csr FOR SELECT section_id, object_version_number,
587: display_name, access_name, section_type_code, status_code,

Line 625: WHEN FND_API.G_EXC_ERROR THEN

621: WHERE context_type_code = 'TEMPLATE';
622:
623: EXCEPTION
624:
625: WHEN FND_API.G_EXC_ERROR THEN
626: x_return_status := FND_API.G_RET_STS_ERROR;
627: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
628: p_data => x_msg_data,
629: p_encoded => 'F');

Line 626: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

628: p_data => x_msg_data,
629: p_encoded => 'F');
630:
631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
633: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
634: p_data => x_msg_data,
635: p_encoded => 'F');
636:

Line 644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

640: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
641: FND_MESSAGE.Set_Token('REASON', SQLERRM);
642: FND_MSG_PUB.Add;
643:
644: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
645:
646: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
647: THEN
648: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

656:
657: PROCEDURE Load_Root_Sct_For_Basic_Desc
658: (
659: p_api_version IN NUMBER,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: x_section_path OUT NOCOPY VARCHAR2,
664: x_section_csr OUT NOCOPY SECTION_CSR,

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

657: PROCEDURE Load_Root_Sct_For_Basic_Desc
658: (
659: p_api_version IN NUMBER,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: x_section_path OUT NOCOPY VARCHAR2,
664: x_section_csr OUT NOCOPY SECTION_CSR,
665: x_section_type_csr OUT NOCOPY SECTION_TYPE_CSR,

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

658: (
659: p_api_version IN NUMBER,
660: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
661: p_commit IN VARCHAR2 := FND_API.G_FALSE,
662: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
663: x_section_path OUT NOCOPY VARCHAR2,
664: x_section_csr OUT NOCOPY SECTION_CSR,
665: x_section_type_csr OUT NOCOPY SECTION_TYPE_CSR,
666: x_section_status_csr OUT NOCOPY SECTION_STATUS_CSR,

Line 684: IF FND_API.to_Boolean(p_init_msg_list) THEN

680:
681: BEGIN
682:
683: -- Initialize message list if p_init_msg_list is set to TRUE.
684: IF FND_API.to_Boolean(p_init_msg_list) THEN
685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to success

Line 689: x_return_status := FND_API.G_RET_STS_SUCCESS;

685: FND_MSG_PUB.initialize;
686: END IF;
687:
688: -- Initialize API return status to success
689: x_return_status := FND_API.G_RET_STS_SUCCESS;
690:
691: --
692: -- Get the master mini-site id
693: --

Line 706: p_init_msg_list => FND_API.G_FALSE,

702: --
703: Load_Section_For_Basic_Desc
704: (
705: p_api_version => p_api_version,
706: p_init_msg_list => FND_API.G_FALSE,
707: p_commit => FND_API.G_FALSE,
708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
709: p_section_id => l_master_root_section_id,
710: x_section_path => x_section_path,

Line 707: p_commit => FND_API.G_FALSE,

703: Load_Section_For_Basic_Desc
704: (
705: p_api_version => p_api_version,
706: p_init_msg_list => FND_API.G_FALSE,
707: p_commit => FND_API.G_FALSE,
708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
709: p_section_id => l_master_root_section_id,
710: x_section_path => x_section_path,
711: x_section_csr => x_section_csr,

Line 708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

704: (
705: p_api_version => p_api_version,
706: p_init_msg_list => FND_API.G_FALSE,
707: p_commit => FND_API.G_FALSE,
708: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
709: p_section_id => l_master_root_section_id,
710: x_section_path => x_section_path,
711: x_section_csr => x_section_csr,
712: x_section_type_csr => x_section_type_csr,

Line 721: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

717: x_msg_count => x_msg_count,
718: x_msg_data => x_msg_data
719: );
720:
721: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;

Line 722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

718: x_msg_data => x_msg_data
719: );
720:
721: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:

Line 723: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

719: );
720:
721: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:
727: EXCEPTION

Line 724: RAISE FND_API.G_EXC_ERROR;

720:
721: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
722: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
723: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
724: RAISE FND_API.G_EXC_ERROR;
725: END IF;
726:
727: EXCEPTION
728:

Line 729: WHEN FND_API.G_EXC_ERROR THEN

725: END IF;
726:
727: EXCEPTION
728:
729: WHEN FND_API.G_EXC_ERROR THEN
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data,
733: p_encoded => 'F');

Line 730: x_return_status := FND_API.G_RET_STS_ERROR;

726:
727: EXCEPTION
728:
729: WHEN FND_API.G_EXC_ERROR THEN
730: x_return_status := FND_API.G_RET_STS_ERROR;
731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data,
733: p_encoded => 'F');
734:

Line 735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

731: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
732: p_data => x_msg_data,
733: p_encoded => 'F');
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
738: p_data => x_msg_data,
739: p_encoded => 'F');

Line 736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

732: p_data => x_msg_data,
733: p_encoded => 'F');
734:
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
737: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
738: p_data => x_msg_data,
739: p_encoded => 'F');
740:

Line 748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

744: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
745: FND_MESSAGE.Set_Token('REASON', SQLERRM);
746: FND_MSG_PUB.Add;
747:
748: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
749:
750: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
751: THEN
752: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

766: --
767: PROCEDURE Get_Cand_Incl_MSites_For_Sct
768: (
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
771: p_commit IN VARCHAR2 := FND_API.G_FALSE,
772: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
773: p_section_id IN NUMBER,
774: x_section_path OUT NOCOPY VARCHAR2,

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

767: PROCEDURE Get_Cand_Incl_MSites_For_Sct
768: (
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
771: p_commit IN VARCHAR2 := FND_API.G_FALSE,
772: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
773: p_section_id IN NUMBER,
774: x_section_path OUT NOCOPY VARCHAR2,
775: x_section_csr OUT NOCOPY SECTION_CSR,

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

768: (
769: p_api_version IN NUMBER,
770: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
771: p_commit IN VARCHAR2 := FND_API.G_FALSE,
772: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
773: p_section_id IN NUMBER,
774: x_section_path OUT NOCOPY VARCHAR2,
775: x_section_csr OUT NOCOPY SECTION_CSR,
776: x_incl_mini_site_csr OUT NOCOPY MINI_SITE_CSR,

Line 799: IF NOT FND_API.Compatible_API_Call(l_api_version,

795:
796: BEGIN
797:
798: -- Standard call to check for call compatibility.
799: IF NOT FND_API.Compatible_API_Call(l_api_version,
800: p_api_version,
801: l_api_name,
802: G_PKG_NAME)
803: THEN

Line 804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

800: p_api_version,
801: l_api_name,
802: G_PKG_NAME)
803: THEN
804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: -- Initialize message list if p_init_msg_list is set to TRUE.
808: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 808: IF FND_API.to_Boolean(p_init_msg_list) THEN

804: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
805: END IF;
806:
807: -- Initialize message list if p_init_msg_list is set to TRUE.
808: IF FND_API.to_Boolean(p_init_msg_list) THEN
809: FND_MSG_PUB.initialize;
810: END IF;
811:
812: -- Initialize API return status to success

Line 813: x_return_status := FND_API.G_RET_STS_SUCCESS;

809: FND_MSG_PUB.initialize;
810: END IF;
811:
812: -- Initialize API return status to success
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: --
816: -- Get the master mini-site id
817: --

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

898: --
899: -- End of main API body.
900:
901: -- Standard check of p_commit.
902: IF (FND_API.To_Boolean(p_commit)) THEN
903: COMMIT WORK;
904: END IF;
905:
906: -- Standard call to get message count and if count is 1, get message info.

Line 913: WHEN FND_API.G_EXC_ERROR THEN

909: p_encoded => 'F');
910:
911: EXCEPTION
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
916: p_data => x_msg_data,
917: p_encoded => 'F');

Line 914: x_return_status := FND_API.G_RET_STS_ERROR;

910:
911: EXCEPTION
912:
913: WHEN FND_API.G_EXC_ERROR THEN
914: x_return_status := FND_API.G_RET_STS_ERROR;
915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
916: p_data => x_msg_data,
917: p_encoded => 'F');
918:

Line 919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

915: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
916: p_data => x_msg_data,
917: p_encoded => 'F');
918:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => 'F');

Line 920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

916: p_data => x_msg_data,
917: p_encoded => 'F');
918:
919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
921: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
922: p_data => x_msg_data,
923: p_encoded => 'F');
924:

Line 932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

928: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
929: FND_MESSAGE.Set_Token('REASON', SQLERRM);
930: FND_MSG_PUB.Add;
931:
932: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
933:
934: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
935: THEN
936: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

944:
945: PROCEDURE Load_Items_For_Basic_Desc
946: (
947: p_api_version IN NUMBER,
948: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
949: p_commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: p_inventory_item_id IN NUMBER,
952: p_organization_id IN NUMBER,

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

945: PROCEDURE Load_Items_For_Basic_Desc
946: (
947: p_api_version IN NUMBER,
948: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
949: p_commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: p_inventory_item_id IN NUMBER,
952: p_organization_id IN NUMBER,
953: x_inventory_item_csr OUT NOCOPY INVENTORY_ITEM_CSR,

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

946: (
947: p_api_version IN NUMBER,
948: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
949: p_commit IN VARCHAR2 := FND_API.G_FALSE,
950: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
951: p_inventory_item_id IN NUMBER,
952: p_organization_id IN NUMBER,
953: x_inventory_item_csr OUT NOCOPY INVENTORY_ITEM_CSR,
954: x_web_status_type_csr OUT NOCOPY WEB_STATUS_TYPE_CSR,

Line 967: IF FND_API.to_Boolean(p_init_msg_list) THEN

963:
964: BEGIN
965:
966: -- Initialize message list if p_init_msg_list is set to TRUE.
967: IF FND_API.to_Boolean(p_init_msg_list) THEN
968: FND_MSG_PUB.initialize;
969: END IF;
970:
971: -- Initialize API return status to success

Line 972: x_return_status := FND_API.G_RET_STS_SUCCESS;

968: FND_MSG_PUB.initialize;
969: END IF;
970:
971: -- Initialize API return status to success
972: x_return_status := FND_API.G_RET_STS_SUCCESS;
973:
974: -- Get the item data
975: OPEN x_inventory_item_csr FOR SELECT inventory_item_id, organization_id,
976: web_status, description, long_description, concatenated_segments,

Line 988: WHEN FND_API.G_EXC_ERROR THEN

984: WHERE lookup_type = 'IBE_ITEM_STATUS';
985:
986: EXCEPTION
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
991: p_data => x_msg_data,
992: p_encoded => 'F');

Line 989: x_return_status := FND_API.G_RET_STS_ERROR;

985:
986: EXCEPTION
987:
988: WHEN FND_API.G_EXC_ERROR THEN
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
991: p_data => x_msg_data,
992: p_encoded => 'F');
993:

Line 994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

990: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
991: p_data => x_msg_data,
992: p_encoded => 'F');
993:
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
997: p_data => x_msg_data,
998: p_encoded => 'F');

Line 995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

991: p_data => x_msg_data,
992: p_encoded => 'F');
993:
994: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
995: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
996: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
997: p_data => x_msg_data,
998: p_encoded => 'F');
999:

Line 1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1003: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1004: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1005: FND_MSG_PUB.Add;
1006:
1007: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1008:
1009: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1010: THEN
1011: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

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

1024: --
1025: PROCEDURE Get_Cand_Incl_MSites_For_Itm
1026: (
1027: p_api_version IN NUMBER,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1031: p_inventory_item_id IN NUMBER,
1032: p_organization_id IN NUMBER,

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

1025: PROCEDURE Get_Cand_Incl_MSites_For_Itm
1026: (
1027: p_api_version IN NUMBER,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1031: p_inventory_item_id IN NUMBER,
1032: p_organization_id IN NUMBER,
1033: x_inventory_item_csr OUT NOCOPY INVENTORY_ITEM_CSR,

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

1026: (
1027: p_api_version IN NUMBER,
1028: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1029: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1030: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1031: p_inventory_item_id IN NUMBER,
1032: p_organization_id IN NUMBER,
1033: x_inventory_item_csr OUT NOCOPY INVENTORY_ITEM_CSR,
1034: x_incl_mini_site_csr OUT NOCOPY MINI_SITE_CSR,

Line 1051: IF NOT FND_API.Compatible_API_Call(l_api_version,

1047:
1048: BEGIN
1049:
1050: -- Standard call to check for call compatibility.
1051: IF NOT FND_API.Compatible_API_Call(l_api_version,
1052: p_api_version,
1053: l_api_name,
1054: G_PKG_NAME)
1055: THEN

Line 1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1052: p_api_version,
1053: l_api_name,
1054: G_PKG_NAME)
1055: THEN
1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: END IF;
1058:
1059: -- Initialize message list if p_init_msg_list is set to TRUE.
1060: IF FND_API.to_Boolean(p_init_msg_list) THEN

Line 1060: IF FND_API.to_Boolean(p_init_msg_list) THEN

1056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1057: END IF;
1058:
1059: -- Initialize message list if p_init_msg_list is set to TRUE.
1060: IF FND_API.to_Boolean(p_init_msg_list) THEN
1061: FND_MSG_PUB.initialize;
1062: END IF;
1063:
1064: -- Initialize API return status to success

Line 1065: x_return_status := FND_API.G_RET_STS_SUCCESS;

1061: FND_MSG_PUB.initialize;
1062: END IF;
1063:
1064: -- Initialize API return status to success
1065: x_return_status := FND_API.G_RET_STS_SUCCESS;
1066:
1067: --
1068: -- Get the master mini-site id
1069: --

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

1118: --
1119: -- End of main API body.
1120:
1121: -- Standard check of p_commit.
1122: IF (FND_API.To_Boolean(p_commit)) THEN
1123: COMMIT WORK;
1124: END IF;
1125:
1126: -- Standard call to get message count and if count is 1, get message info.

Line 1133: WHEN FND_API.G_EXC_ERROR THEN

1129: p_encoded => 'F');
1130:
1131: EXCEPTION
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => 'F');

Line 1134: x_return_status := FND_API.G_RET_STS_ERROR;

1130:
1131: EXCEPTION
1132:
1133: WHEN FND_API.G_EXC_ERROR THEN
1134: x_return_status := FND_API.G_RET_STS_ERROR;
1135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => 'F');
1138:

Line 1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1135: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1136: p_data => x_msg_data,
1137: p_encoded => 'F');
1138:
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1142: p_data => x_msg_data,
1143: p_encoded => 'F');

Line 1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1136: p_data => x_msg_data,
1137: p_encoded => 'F');
1138:
1139: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1142: p_data => x_msg_data,
1143: p_encoded => 'F');
1144:

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1148: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1149: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1150: FND_MSG_PUB.Add;
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1153:
1154: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1155: THEN
1156: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

Line 1211: x_return_status := FND_API.G_RET_STS_SUCCESS;

1207: BEGIN
1208:
1209:
1210: -- Initialize API return status to success
1211: x_return_status := FND_API.G_RET_STS_SUCCESS;
1212:
1213: -- Get the master mini-site id
1214: IBE_DSP_HIERARCHY_SETUP_PVT.Get_Master_Mini_Site_Id
1215: (

Line 1239: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

1235: -- get the section name and desc
1236: OPEN c1(p_section_id);
1237: FETCH c1 INTO x_section_name, x_section_desc;
1238:
1239: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;

Line 1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1236: OPEN c1(p_section_id);
1237: FETCH c1 INTO x_section_name, x_section_desc;
1238:
1239: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244: CLOSE c1;

Line 1241: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN

1237: FETCH c1 INTO x_section_name, x_section_desc;
1238:
1239: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244: CLOSE c1;
1245:

Line 1242: RAISE FND_API.G_EXC_ERROR;

1238:
1239: IF (x_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
1240: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1241: ELSIF (x_return_status = FND_API.G_RET_STS_ERROR) THEN
1242: RAISE FND_API.G_EXC_ERROR;
1243: END IF;
1244: CLOSE c1;
1245:
1246:

Line 1249: WHEN FND_API.G_EXC_ERROR THEN

1245:
1246:
1247: EXCEPTION
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1250: x_return_status := FND_API.G_RET_STS_ERROR;

1246:
1247: EXCEPTION
1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:

Line 1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1248:
1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: WHEN OTHERS THEN
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1249: WHEN FND_API.G_EXC_ERROR THEN
1250: x_return_status := FND_API.G_RET_STS_ERROR;
1251:
1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: WHEN OTHERS THEN
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257:

Line 1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1252: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1254:
1255: WHEN OTHERS THEN
1256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1257:
1258:
1259: END Get_Section_Path;
1260:

Line 1281: x_return_status := FND_API.G_RET_STS_SUCCESS;

1277:
1278: BEGIN
1279:
1280: -- Initialize API return status to success
1281: x_return_status := FND_API.G_RET_STS_SUCCESS;
1282:
1283:
1284: IF p_level_number >0 THEN
1285:

Line 1366: WHEN FND_API.G_EXC_ERROR THEN

1362: END if;
1363:
1364: EXCEPTION
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1369: p_data => x_msg_data,
1370: p_encoded => 'F');

Line 1367: x_return_status := FND_API.G_RET_STS_ERROR;

1363:
1364: EXCEPTION
1365:
1366: WHEN FND_API.G_EXC_ERROR THEN
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1369: p_data => x_msg_data,
1370: p_encoded => 'F');
1371:

Line 1372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1368: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1369: p_data => x_msg_data,
1370: p_encoded => 'F');
1371:
1372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => 'F');

Line 1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1369: p_data => x_msg_data,
1370: p_encoded => 'F');
1371:
1372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1373: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1374: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
1375: p_data => x_msg_data,
1376: p_encoded => 'F');
1377:

Line 1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1381: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1382: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1383: FND_MSG_PUB.Add;
1384:
1385: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1386:
1387: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1388: THEN
1389: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);