56: -- utl_file.invalid_operation - file is not open for writing/appending
57: -- utl_file.write_error - OS error occured during write operation
58: x_return_status := fnd_api.g_ret_sts_unexp_error ;
59:
60: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
61: THEN
62: fnd_msg_pub.add_exc_msg
63: ( g_pkg_name
64: , 'Write_To_Logfile'
58: x_return_status := fnd_api.g_ret_sts_unexp_error ;
59:
60: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
61: THEN
62: fnd_msg_pub.add_exc_msg
63: ( g_pkg_name
64: , 'Write_To_Logfile'
65: );
66: END IF;
111: EXCEPTION
112: WHEN OTHERS THEN
113: x_return_status := fnd_api.g_ret_sts_unexp_error ;
114:
115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
116: THEN
117: fnd_msg_pub.add_exc_msg
118: ( g_pkg_name
119: , 'Search_Item_Cache'
113: x_return_status := fnd_api.g_ret_sts_unexp_error ;
114:
115: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
116: THEN
117: fnd_msg_pub.add_exc_msg
118: ( g_pkg_name
119: , 'Search_Item_Cache'
120: );
121: END IF;
142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := fnd_api.g_ret_sts_unexp_error ;
145:
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
147: THEN
148: fnd_msg_pub.add_exc_msg
149: ( g_pkg_name
150: , 'Add_Item_Cache'
144: x_return_status := fnd_api.g_ret_sts_unexp_error ;
145:
146: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
147: THEN
148: fnd_msg_pub.add_exc_msg
149: ( g_pkg_name
150: , 'Add_Item_Cache'
151: );
152: END IF;
194: EXCEPTION
195: WHEN OTHERS THEN
196: x_return_status := fnd_api.g_ret_sts_unexp_error ;
197:
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
199: THEN
200: fnd_msg_pub.add_exc_msg
201: ( g_pkg_name
202: , 'Search_Organization_Cache'
196: x_return_status := fnd_api.g_ret_sts_unexp_error ;
197:
198: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
199: THEN
200: fnd_msg_pub.add_exc_msg
201: ( g_pkg_name
202: , 'Search_Organization_Cache'
203: );
204: END IF;
225: EXCEPTION
226: WHEN OTHERS THEN
227: x_return_status := fnd_api.g_ret_sts_unexp_error ;
228:
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
230: THEN
231: fnd_msg_pub.add_exc_msg
232: ( g_pkg_name
233: , 'Add_Organization_Cache'
227: x_return_status := fnd_api.g_ret_sts_unexp_error ;
228:
229: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
230: THEN
231: fnd_msg_pub.add_exc_msg
232: ( g_pkg_name
233: , 'Add_Organization_Cache'
234: );
235: END IF;
318: EXCEPTION
319: WHEN OTHERS THEN
320: x_return_status := fnd_api.g_ret_sts_unexp_error ;
321:
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
323: THEN
324: fnd_msg_pub.add_exc_msg
325: ( g_pkg_name
326: , 'Search_Demand_Cache'
320: x_return_status := fnd_api.g_ret_sts_unexp_error ;
321:
322: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
323: THEN
324: fnd_msg_pub.add_exc_msg
325: ( g_pkg_name
326: , 'Search_Demand_Cache'
327: );
328: END IF;
365: EXCEPTION
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error ;
368:
369: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
370: THEN
371: fnd_msg_pub.add_exc_msg
372: ( g_pkg_name
373: , 'Add_Demand_Cache'
367: x_return_status := fnd_api.g_ret_sts_unexp_error ;
368:
369: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
370: THEN
371: fnd_msg_pub.add_exc_msg
372: ( g_pkg_name
373: , 'Add_Demand_Cache'
374: );
375: END IF;
434: EXCEPTION
435: WHEN OTHERS THEN
436: x_return_status := fnd_api.g_ret_sts_unexp_error ;
437:
438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
439: THEN
440: fnd_msg_pub.add_exc_msg
441: ( g_pkg_name
442: , 'Search_Supply_Cache'
436: x_return_status := fnd_api.g_ret_sts_unexp_error ;
437:
438: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
439: THEN
440: fnd_msg_pub.add_exc_msg
441: ( g_pkg_name
442: , 'Search_Supply_Cache'
443: );
444: END IF;
464: EXCEPTION
465: WHEN OTHERS THEN
466: x_return_status := fnd_api.g_ret_sts_unexp_error ;
467:
468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
469: THEN
470: fnd_msg_pub.add_exc_msg
471: ( g_pkg_name
472: , 'Add_Supply_Cache'
466: x_return_status := fnd_api.g_ret_sts_unexp_error ;
467:
468: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
469: THEN
470: fnd_msg_pub.add_exc_msg
471: ( g_pkg_name
472: , 'Add_Supply_Cache'
473: );
474: END IF;
519: EXCEPTION
520: WHEN OTHERS THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
522:
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
524: THEN
525: fnd_msg_pub.add_exc_msg
526: ( g_pkg_name
527: , 'Search_Sub_Cache'
521: x_return_status := fnd_api.g_ret_sts_unexp_error ;
522:
523: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
524: THEN
525: fnd_msg_pub.add_exc_msg
526: ( g_pkg_name
527: , 'Search_Sub_Cache'
528: );
529: END IF;
549: EXCEPTION
550: WHEN OTHERS THEN
551: x_return_status := fnd_api.g_ret_sts_unexp_error ;
552:
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
554: THEN
555: fnd_msg_pub.add_exc_msg
556: ( g_pkg_name
557: , 'Add_Sub_Cache'
551: x_return_status := fnd_api.g_ret_sts_unexp_error ;
552:
553: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)
554: THEN
555: fnd_msg_pub.add_exc_msg
556: ( g_pkg_name
557: , 'Add_Sub_Cache'
558: );
559: END IF;
707: x_return_status := fnd_api.g_ret_sts_unexp_error ;
708: WHEN OTHERS THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error ;
710:
711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
712: fnd_msg_pub.add_exc_msg
713: ( g_pkg_name
714: , 'Add_Wip_Cache'
715: );
708: WHEN OTHERS THEN
709: x_return_status := fnd_api.g_ret_sts_unexp_error ;
710:
711: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
712: fnd_msg_pub.add_exc_msg
713: ( g_pkg_name
714: , 'Add_Wip_Cache'
715: );
716: END IF;