93: end if;
94: return l_object_type;
95: EXCEPTION
96: WHEN OTHERS THEN
97: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
98: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
99: end if;
100: RETURN NULL;
101: END;
94: return l_object_type;
95: EXCEPTION
96: WHEN OTHERS THEN
97: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
98: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
99: end if;
100: RETURN NULL;
101: END;
102: -----------------------------------------
174: return l_object_name;
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
179: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
180: end if;
181: RETURN NULL;
182: END;
175:
176: EXCEPTION
177: WHEN OTHERS THEN
178: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
179: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
180: end if;
181: RETURN NULL;
182: END;
183:
221: end if;
222: return l_strategy;
223: EXCEPTION
224: WHEN OTHERS THEN
225: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
227: end if;
228: RETURN NULL;
229: END;
222: return l_strategy;
223: EXCEPTION
224: WHEN OTHERS THEN
225: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
226: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
227: end if;
228: RETURN NULL;
229: END;
230:
265: end if;
266: return l_rule;
267: EXCEPTION
268: WHEN OTHERS THEN
269: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: end if;
272: RETURN NULL;
273: END;
266: return l_rule;
267: EXCEPTION
268: WHEN OTHERS THEN
269: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
270: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
271: end if;
272: RETURN NULL;
273: END;
274:
301: end if;
302: return l_costgroup;
303: EXCEPTION
304: WHEN OTHERS THEN
305: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
307: end if;
308: RETURN NULL;
309: END;
302: return l_costgroup;
303: EXCEPTION
304: WHEN OTHERS THEN
305: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
306: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
307: end if;
308: RETURN NULL;
309: END;
310:
338: end if;
339: return l_costgroup_desc;
340: EXCEPTION
341: WHEN OTHERS THEN
342: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: end if;
345: RETURN NULL;
346: END;
339: return l_costgroup_desc;
340: EXCEPTION
341: WHEN OTHERS THEN
342: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
343: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
344: end if;
345: RETURN NULL;
346: END;
347:
568: end if;
569:
570: -- Initialize message list if p_init_msg_list is set to TRUE
571: if fnd_api.to_boolean( p_init_msg_list ) then
572: fnd_msg_pub.initialize;
573: end if;
574:
575: IF (nvl(p_move_order_line_id,0) > 0) then
576:
630: end if;
631: EXCEPTION
632: when fnd_api.g_exc_error then
633: x_return_status := fnd_api.g_ret_sts_error;
634: fnd_msg_pub.count_and_get( p_count => x_msg_count
635: ,p_data => x_msg_data );
636:
637: when fnd_api.g_exc_unexpected_error then
638: x_return_status := fnd_api.g_ret_sts_unexp_error;
635: ,p_data => x_msg_data );
636:
637: when fnd_api.g_exc_unexpected_error then
638: x_return_status := fnd_api.g_ret_sts_unexp_error;
639: fnd_msg_pub.count_and_get( p_count => x_msg_count
640: ,p_data => x_msg_data );
641:
642: when others then
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: ,p_data => x_msg_data );
641:
642: when others then
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
645: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
646: end if;
647: /* fnd_msg_pub.count_and_get( p_count => x_msg_count
648: ,p_data => x_msg_data );*/
641:
642: when others then
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
645: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
646: end if;
647: /* fnd_msg_pub.count_and_get( p_count => x_msg_count
648: ,p_data => x_msg_data );*/
649:
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
645: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
646: end if;
647: /* fnd_msg_pub.count_and_get( p_count => x_msg_count
648: ,p_data => x_msg_data );*/
649:
650: end insert_trace_header;
651: ------------------------------------------------------------------------------------
689: end if;
690:
691: -- Initialize message list if p_init_msg_list is set to TRUE
692: if fnd_api.to_boolean( p_init_msg_list ) then
693: fnd_msg_pub.initialize;
694: end if;
695:
696: if ( nvl(p_header_id ,0 ) > 0 and nvl(p_rule_id,0) > 0 ) then
697:
761: end if;
762: EXCEPTION
763: when fnd_api.g_exc_error then
764: x_return_status := fnd_api.g_ret_sts_error;
765: fnd_msg_pub.count_and_get( p_count => x_msg_count
766: ,p_data => x_msg_data );
767:
768: when fnd_api.g_exc_unexpected_error then
769: x_return_status := fnd_api.g_ret_sts_unexp_error;
766: ,p_data => x_msg_data );
767:
768: when fnd_api.g_exc_unexpected_error then
769: x_return_status := fnd_api.g_ret_sts_unexp_error;
770: fnd_msg_pub.count_and_get( p_count => x_msg_count
771: ,p_data => x_msg_data );
772:
773: when others then
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
771: ,p_data => x_msg_data );
772:
773: when others then
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
776: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
777: end if;
778: /*fnd_msg_pub.count_and_get( p_count => x_msg_count
779: ,p_data => x_msg_data ); */
772:
773: when others then
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
776: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
777: end if;
778: /*fnd_msg_pub.count_and_get( p_count => x_msg_count
779: ,p_data => x_msg_data ); */
780:
774: x_return_status := fnd_api.g_ret_sts_unexp_error;
775: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
776: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
777: end if;
778: /*fnd_msg_pub.count_and_get( p_count => x_msg_count
779: ,p_data => x_msg_data ); */
780:
781: end insert_trace_lines;
782:
1064: end if;
1065: return l_return_status;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1069: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1070: end if;
1071: RETURN 'N';
1072: END IS_Object_selected;
1065: return l_return_status;
1066: EXCEPTION
1067: WHEN OTHERS THEN
1068: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1069: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1070: end if;
1071: RETURN 'N';
1072: END IS_Object_selected;
1073:
1138:
1139: return l_return_status;
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1144: end if;
1145: RETURN 'N';
1146:
1139: return l_return_status;
1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: if (fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error)) then
1143: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1144: end if;
1145: RETURN 'N';
1146:
1147: END IS_BO_Object_selected;
2208:
2209: EXCEPTION
2210: when fnd_api.g_exc_error then
2211: x_return_status := fnd_api.g_ret_sts_error;
2212: fnd_msg_pub.count_and_get( p_count => x_msg_count
2213: ,p_data => x_msg_data );
2214:
2215: when fnd_api.g_exc_unexpected_error then
2216: x_return_status := fnd_api.g_ret_sts_unexp_error;
2213: ,p_data => x_msg_data );
2214:
2215: when fnd_api.g_exc_unexpected_error then
2216: x_return_status := fnd_api.g_ret_sts_unexp_error;
2217: fnd_msg_pub.count_and_get( p_count => x_msg_count
2218: ,p_data => x_msg_data );
2219:
2220: when others then
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2218: ,p_data => x_msg_data );
2219:
2220: when others then
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2222: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2223: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2224: end if;
2225: End insert_txn_trace_rows;
2226: ---------------------------------------------------------------------------------------
2219:
2220: when others then
2221: x_return_status := fnd_api.g_ret_sts_unexp_error;
2222: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
2223: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
2224: end if;
2225: End insert_txn_trace_rows;
2226: ---------------------------------------------------------------------------------------
2227: ---- This procedure is used by 'Run time trace form' to set the