DBA Data[Home] [Help]

APPS.BIS_CUSTOMIZATIONS_PVT dependencies on FND_API

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88:
89: if (p_commit = 'Y') then
90: COMMIT;
91: end if;
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 95: when FND_API.G_EXC_ERROR then

91: end if;
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then

Line 96: x_return_status := FND_API.G_RET_STS_ERROR ;

92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 97: when FND_API.G_EXC_UNEXPECTED_ERROR then

93:
94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:

Line 98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

94: EXCEPTION
95: when FND_API.G_EXC_ERROR then
96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:
102: END Create_Customizations;

Line 100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

96: x_return_status := FND_API.G_RET_STS_ERROR ;
97: when FND_API.G_EXC_UNEXPECTED_ERROR then
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
99: when others then
100: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
101:
102: END Create_Customizations;
103: --
104: --

Line 147: x_return_status := FND_API.G_RET_STS_SUCCESS;

143: null;
144: END;
145: Create_Customizations(p_api_version, p_commit,p_Customizations_Rec,x_return_status);
146:
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 150: when FND_API.G_EXC_ERROR then

146:
147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then

Line 151: x_return_status := FND_API.G_RET_STS_ERROR ;

147: x_return_status := FND_API.G_RET_STS_SUCCESS;
148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 152: when FND_API.G_EXC_UNEXPECTED_ERROR then

148:
149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:

Line 153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

149: EXCEPTION
150: when FND_API.G_EXC_ERROR then
151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:
157: END Update_Customizations;

Line 155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

151: x_return_status := FND_API.G_RET_STS_ERROR ;
152: when FND_API.G_EXC_UNEXPECTED_ERROR then
153: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
154: when others then
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
156:
157: END Update_Customizations;
158:
159: PROCEDURE Create_Custom_Regions

Line 189: x_return_status := FND_API.G_RET_STS_SUCCESS;

185: );
186: if (p_commit = 'Y') then
187: COMMIT;
188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then

Line 191: when FND_API.G_EXC_ERROR then

187: COMMIT;
188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then

Line 192: x_return_status := FND_API.G_RET_STS_ERROR ;

188: end if;
189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 193: when FND_API.G_EXC_UNEXPECTED_ERROR then

189: x_return_status := FND_API.G_RET_STS_SUCCESS;
190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:

Line 194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

190: EXCEPTION
191: when FND_API.G_EXC_ERROR then
192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
198: END Create_Custom_Regions;

Line 196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

192: x_return_status := FND_API.G_RET_STS_ERROR ;
193: when FND_API.G_EXC_UNEXPECTED_ERROR then
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
195: when others then
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197:
198: END Create_Custom_Regions;
199: --
200: --

Line 227: x_return_status := FND_API.G_RET_STS_SUCCESS;

223: END;
224: */
225: Create_Custom_Regions(p_api_version, p_commit,p_Custom_Regions_Rec,x_return_status);
226:
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 230: when FND_API.G_EXC_ERROR then

226:
227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then

Line 231: x_return_status := FND_API.G_RET_STS_ERROR ;

227: x_return_status := FND_API.G_RET_STS_SUCCESS;
228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 232: when FND_API.G_EXC_UNEXPECTED_ERROR then

228:
229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:

Line 233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

229: EXCEPTION
230: when FND_API.G_EXC_ERROR then
231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:
237:

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

231: x_return_status := FND_API.G_RET_STS_ERROR ;
232: when FND_API.G_EXC_UNEXPECTED_ERROR then
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
234: when others then
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
236:
237:
238: END Update_Custom_Regions;
239:

Line 273: x_return_status := FND_API.G_RET_STS_SUCCESS;

269: if (p_commit = 'Y') then
270: COMMIT;
271: end if;
272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 276: when FND_API.G_EXC_ERROR then

272:
273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then

Line 277: x_return_status := FND_API.G_RET_STS_ERROR ;

273: x_return_status := FND_API.G_RET_STS_SUCCESS;
274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 278: when FND_API.G_EXC_UNEXPECTED_ERROR then

274:
275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

275: EXCEPTION
276: when FND_API.G_EXC_ERROR then
277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
283: END Create_Custom_Region_Items;

Line 281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

277: x_return_status := FND_API.G_RET_STS_ERROR ;
278: when FND_API.G_EXC_UNEXPECTED_ERROR then
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
280: when others then
281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
282:
283: END Create_Custom_Region_Items;
284: --
285: --

Line 314: x_return_status := FND_API.G_RET_STS_SUCCESS;

310: END;
311: */
312: Create_Custom_Region_items(p_api_version, p_commit,p_Custom_Region_Items_Rec,x_return_status);
313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;

Line 317: when FND_API.G_EXC_ERROR then

313:
314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then

Line 318: x_return_status := FND_API.G_RET_STS_ERROR ;

314: x_return_status := FND_API.G_RET_STS_SUCCESS;
315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 319: when FND_API.G_EXC_UNEXPECTED_ERROR then

315:
316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:

Line 320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

316: EXCEPTION
317: when FND_API.G_EXC_ERROR then
318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324:

Line 322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

318: x_return_status := FND_API.G_RET_STS_ERROR ;
319: when FND_API.G_EXC_UNEXPECTED_ERROR then
320: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
321: when others then
322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
323:
324:
325: END Update_Custom_Region_items;
326:

Line 349: x_return_status := FND_API.G_RET_STS_SUCCESS;

345: DELETE FROM ak_custom_region_items WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
346: DELETE FROM ak_custom_region_items_tl WHERE region_code = p_regionCode AND region_application_id = p_regionAppId AND customization_code = p_customizationCode AND customization_application_id = p_customizationAppId;
347: END IF;
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: EXCEPTION
352: when others then
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
351: EXCEPTION
352: when others then
353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
354:
355: END deleteCustomView;
356:
357: -- Delete all customizations for a ak region

Line 394: WHEN FND_API.G_EXC_ERROR THEN

390: WHERE region_code = p_region_code
391: AND region_application_id = p_region_application_id;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);

Line 395: x_return_status := FND_API.G_RET_STS_ERROR;

391: AND region_application_id = p_region_application_id;
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: x_return_status := FND_API.G_RET_STS_ERROR;
396: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
397: , p_count => x_msg_count
398: , p_data => x_msg_data);
399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 400: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 405: x_return_status := FND_API.G_RET_STS_ERROR;

401: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
402: , p_count => x_msg_count
403: , p_data => x_msg_data);
404: WHEN NO_DATA_FOUND THEN
405: x_return_status := FND_API.G_RET_STS_ERROR;
406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN

Line 410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

406: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
407: , p_count => x_msg_count
408: , p_data => x_msg_data);
409: WHEN OTHERS THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: FND_MSG_PUB.Count_And_Get( p_encoded => 'F'
412: , p_count => x_msg_count
413: , p_data => x_msg_data);
414: IF (x_msg_data IS NULL) THEN