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

Line 46: RAISE FND_API.G_EXC_ERROR;

42: OPEN c1;
43: FETCH c1 INTO x_mini_site_id, x_root_section_id;
44: IF (c1%NOTFOUND) THEN
45: CLOSE c1;
46: RAISE FND_API.G_EXC_ERROR;
47: END IF;
48: CLOSE c1;
49:
50: END Get_Master_Mini_Site_Id;

Line 132: x_return_status := FND_API.G_RET_STS_SUCCESS;

128: l_index BINARY_INTEGER;
129: l_msite_not_exists_excp EXCEPTION;
130: l_api_name CONSTANT VARCHAR2(30) := 'Get_Msite_Excluded_Items';
131: BEGIN
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
135: IBE_Util.Debug('IBE_MinisiteRuntime_PVT.Get_Msite_Excluded_Items start');
136: END IF;

Line 134: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

130: l_api_name CONSTANT VARCHAR2(30) := 'Get_Msite_Excluded_Items';
131: BEGIN
132: x_return_status := FND_API.G_RET_STS_SUCCESS;
133:
134: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
135: IBE_Util.Debug('IBE_MinisiteRuntime_PVT.Get_Msite_Excluded_Items start');
136: END IF;
137:
138: l_msite_id := p_msite_id ;

Line 139: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And

135: IBE_Util.Debug('IBE_MinisiteRuntime_PVT.Get_Msite_Excluded_Items start');
136: END IF;
137:
138: l_msite_id := p_msite_id ;
139: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
140: (p_access_name IS NOT NULL) Then
141: Open C_msite_Id(p_access_name);
142: Fetch C_msite_Id INTO l_msite_id, l_root_section_id;
143: If C_msite_Id%NOTFOUND Then

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: l_index := l_index + 1;
168: END LOOP; -- end loop r2
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: END LOOP; -- end loop r2
169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:

Line 173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

169:
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

173: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data);

Line 178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

174: p_count => x_msg_count,
175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:

Line 179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

175: p_data => x_msg_data);
176:
177: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
178: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
179: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: WHEN l_msite_not_exists_excp THEN

Line 184: x_return_status := FND_API.g_ret_sts_error;

180: p_count => x_msg_count,
181: p_data => x_msg_data);
182:
183: WHEN l_msite_not_exists_excp THEN
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.count_and_get(
188: p_encoded => FND_API.g_false,

Line 188: p_encoded => FND_API.g_false,

184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
186: FND_MSG_PUB.ADD;
187: FND_MSG_PUB.count_and_get(
188: p_encoded => FND_API.g_false,
189: p_count => x_msg_count,
190: p_data => x_msg_data );
191:
192: WHEN OTHERS THEN

Line 193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

189: p_count => x_msg_count,
190: p_data => x_msg_data );
191:
192: WHEN OTHERS THEN
193: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
194: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

195: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
196: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
197: FND_MESSAGE.Set_Token('REASON', SQLERRM);
198: FND_MSG_PUB.Add;
199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
200: p_count => x_msg_count,
201: p_data => x_msg_data);
202: END Get_Msite_Excluded_Items;
203:

Line 250: x_return_status := FND_API.G_RET_STS_SUCCESS;

246: And master_msite_flag = 'N' and site_type = 'I';
247:
248: BEGIN
249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: l_msite_id := p_msite_id ;
253: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
254: (p_access_name IS NOT NULL) Then

Line 253: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And

249:
250: x_return_status := FND_API.G_RET_STS_SUCCESS;
251:
252: l_msite_id := p_msite_id ;
253: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
254: (p_access_name IS NOT NULL) Then
255: Open C_msite_Id(p_access_name);
256: Fetch C_msite_Id INTO l_msite_id, l_root_section_id;
257: If C_msite_Id%NOTFOUND Then

Line 280: WHEN FND_API.G_EXC_ERROR THEN

276: END LOOP; -- end loop r1
277:
278: EXCEPTION
279:
280: WHEN FND_API.G_EXC_ERROR THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);

Line 281: x_return_status := FND_API.G_RET_STS_ERROR;

277:
278: EXCEPTION
279:
280: WHEN FND_API.G_EXC_ERROR THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:

Line 282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

278: EXCEPTION
279:
280: WHEN FND_API.G_EXC_ERROR THEN
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

282: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);

Line 287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

283: p_count => x_msg_count,
284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:

Line 288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

284: p_data => x_msg_data);
285:
286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:
292: WHEN l_msite_not_exists_excp THEN

Line 293: x_return_status := FND_API.g_ret_sts_error;

289: p_count => x_msg_count,
290: p_data => x_msg_data);
291:
292: WHEN l_msite_not_exists_excp THEN
293: x_return_status := FND_API.g_ret_sts_error;
294: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
295: FND_MSG_PUB.ADD;
296: FND_MSG_PUB.count_and_get(
297: p_encoded => FND_API.g_false,

Line 297: p_encoded => FND_API.g_false,

293: x_return_status := FND_API.g_ret_sts_error;
294: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
295: FND_MSG_PUB.ADD;
296: FND_MSG_PUB.count_and_get(
297: p_encoded => FND_API.g_false,
298: p_count => x_msg_count,
299: p_data => x_msg_data );
300:
301: WHEN OTHERS THEN

Line 302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

298: p_count => x_msg_count,
299: p_data => x_msg_data );
300:
301: WHEN OTHERS THEN
302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
303: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

304: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
305: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
306: FND_MESSAGE.Set_Token('REASON', SQLERRM);
307: FND_MSG_PUB.Add;
308: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
309: p_count => x_msg_count,
310: p_data => x_msg_data);
311:
312: END Get_Msite_Excluded_Sections;

Line 370: x_return_status := FND_API.G_RET_STS_SUCCESS;

366: -- And NVL(end_date_active,sysdate) ;
367:
368: BEGIN
369:
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:
372: l_msite_id := p_msite_id ;
373: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
374: (p_access_name IS NOT NULL) Then

Line 373: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And

369:
370: x_return_status := FND_API.G_RET_STS_SUCCESS;
371:
372: l_msite_id := p_msite_id ;
373: If (l_msite_id IS NULL OR l_msite_id = FND_API.G_MISS_NUM) And
374: (p_access_name IS NOT NULL) Then
375: Open C_msite_Id(p_access_name);
376: Fetch C_msite_Id INTO l_msite_id, l_root_section_id;
377: If C_msite_Id%NOTFOUND Then

Line 600: WHEN FND_API.G_EXC_ERROR THEN

596: AND a.msite_information1 = cc.card_issuer_code
597: ORDER BY msite_information_context;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.g_ret_sts_error;
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,

Line 601: x_return_status := FND_API.g_ret_sts_error;

597: ORDER BY msite_information_context;
598:
599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.g_ret_sts_error;
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data );

Line 603: p_encoded => FND_API.g_false,

599: EXCEPTION
600: WHEN FND_API.G_EXC_ERROR THEN
601: x_return_status := FND_API.g_ret_sts_error;
602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

602: FND_MSG_PUB.count_and_get(
603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get(
609: p_encoded => FND_API.g_false,
610: p_count => x_msg_count,

Line 607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

603: p_encoded => FND_API.g_false,
604: p_count => x_msg_count,
605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get(
609: p_encoded => FND_API.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data );

Line 609: p_encoded => FND_API.g_false,

605: p_data => x_msg_data );
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
608: FND_MSG_PUB.count_and_get(
609: p_encoded => FND_API.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data );
612: WHEN l_msite_not_exists_excp THEN
613: x_return_status := FND_API.g_ret_sts_error;

Line 613: x_return_status := FND_API.g_ret_sts_error;

609: p_encoded => FND_API.g_false,
610: p_count => x_msg_count,
611: p_data => x_msg_data );
612: WHEN l_msite_not_exists_excp THEN
613: x_return_status := FND_API.g_ret_sts_error;
614: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
615: FND_MSG_PUB.ADD;
616: FND_MSG_PUB.count_and_get(
617: p_encoded => FND_API.g_false,

Line 617: p_encoded => FND_API.g_false,

613: x_return_status := FND_API.g_ret_sts_error;
614: FND_MESSAGE.set_name('IBE','IBE_MSITE_NOT_EXISTS');
615: FND_MSG_PUB.ADD;
616: FND_MSG_PUB.count_and_get(
617: p_encoded => FND_API.g_false,
618: p_count => x_msg_count,
619: p_data => x_msg_data );
620: WHEN OTHERS THEN
621: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

622: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
623: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
630: p_data => x_msg_data );

Line 628: p_encoded => FND_API.g_false,

624: FND_MESSAGE.Set_Token('REASON', SQLERRM);
625: FND_MSG_PUB.Add;
626: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
627: FND_MSG_PUB.count_and_get(
628: p_encoded => FND_API.g_false,
629: p_count => x_msg_count,
630: p_data => x_msg_data );
631:
632: END Get_Msite_Details;

Line 656: x_return_status := FND_API.G_RET_STS_SUCCESS;

652: BEGIN
653:
654: l_quote_id := p_quote_id;
655:
656: x_return_status := FND_API.G_RET_STS_SUCCESS;
657:
658: OPEN x_ship_method_cur FOR SELECT SHIP_METHOD_CODE
659: FROM aso_shipments where quote_header_id = l_quote_id;
660:

Line 671: WHEN FND_API.G_EXC_ERROR THEN

667: WHERE A.quote_header_id = l_quote_id
668: AND A.party_id = F.customer_id;
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: FND_MSG_PUB.count_and_get(
674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,

Line 672: x_return_status := FND_API.g_ret_sts_error;

668: AND A.party_id = F.customer_id;
669:
670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: FND_MSG_PUB.count_and_get(
674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,
676: p_data => x_msg_data );

Line 674: p_encoded => FND_API.g_false,

670: EXCEPTION
671: WHEN FND_API.G_EXC_ERROR THEN
672: x_return_status := FND_API.g_ret_sts_error;
673: FND_MSG_PUB.count_and_get(
674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

673: FND_MSG_PUB.count_and_get(
674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: FND_MSG_PUB.count_and_get(
680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: p_encoded => FND_API.g_false,
675: p_count => x_msg_count,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: FND_MSG_PUB.count_and_get(
680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data );

Line 680: p_encoded => FND_API.g_false,

676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: FND_MSG_PUB.count_and_get(
680: p_encoded => FND_API.g_false,
681: p_count => x_msg_count,
682: p_data => x_msg_data );
683: WHEN OTHERS THEN
684: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

Line 689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

685: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
686: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
692: p_count => x_msg_count,
693: p_data => x_msg_data );

Line 691: p_encoded => FND_API.g_false,

687: FND_MESSAGE.Set_Token('REASON', SQLERRM);
688: FND_MSG_PUB.Add;
689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
690: FND_MSG_PUB.count_and_get(
691: p_encoded => FND_API.g_false,
692: p_count => x_msg_count,
693: p_data => x_msg_data );
694:
695: END Get_Quote_Details;

Line 933: x_return_status := FND_API.G_RET_STS_SUCCESS;

929:
930:
931: BEGIN
932:
933: x_return_status := FND_API.G_RET_STS_SUCCESS;
934:
935: --+
936: -- If p_msite_ids is null, then load all the ids and put it in x_msite_ids
937: --+

Line 969: RAISE FND_API.G_EXC_ERROR;

965:
966: IF (x_msite_ids.COUNT <= 0) THEN
967: FND_MESSAGE.Set_Name('IBE', 'IBE_MSITE_NO_MSITES_SPECIFIED');
968: FND_MSG_PUB.Add;
969: RAISE FND_API.G_EXC_ERROR;
970: END IF;
971:
972: Get_Master_Mini_Site_Id
973: (

Line 1147: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

1143: IF (l_exclude_flag IS NULL) THEN
1144: l_exclude_flag := 'N';
1145: END IF;
1146:
1147: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1148: IBE_Util.Debug('Get_Msite_Details - Set l_exclude_flag to N to prevent loading excluded items and excluded sections now');
1149: END IF;
1150: l_exclude_flag := 'N'; -- Bug 7676477, scnagara
1151: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

Line 1151: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN

1147: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1148: IBE_Util.Debug('Get_Msite_Details - Set l_exclude_flag to N to prevent loading excluded items and excluded sections now');
1149: END IF;
1150: l_exclude_flag := 'N'; -- Bug 7676477, scnagara
1151: IF (IBE_UTIL.G_DEBUGON = FND_API.G_TRUE) THEN
1152: IBE_Util.Debug('Get_Msite_Details - l_exclude_flag = ' || l_exclude_flag);
1153: END IF;
1154:
1155: -- Initialize the variables

Line 1197: WHEN FND_API.G_EXC_ERROR THEN

1193: END IF; -- end of exclusion block
1194:
1195: EXCEPTION
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);

Line 1198: x_return_status := FND_API.G_RET_STS_ERROR;

1194:
1195: EXCEPTION
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202:

Line 1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1195: EXCEPTION
1196:
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR;
1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1199: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);

Line 1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1200: p_count => x_msg_count,
1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:

Line 1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1201: p_data => x_msg_data);
1202:
1203: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1204: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1205: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN

Line 1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1206: p_count => x_msg_count,
1207: p_data => x_msg_data);
1208:
1209: WHEN OTHERS THEN
1210: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1211: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);

Line 1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1212: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1213: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1214: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1215: FND_MSG_PUB.Add;
1216: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1217: p_count => x_msg_count,
1218: p_data => x_msg_data);
1219:
1220: End Load_Msite_List_Details ;