1: PACKAGE BODY MO_UTILS AS
2: /* $Header: AFMOUTLB.pls 120.3 2005/11/17 13:27:13 sryu noship $ */
3:
4:
5:
39: RETURN Get_Ledger_Name(p_operating_unit);
40:
41: EXCEPTION
42: WHEN OTHERS THEN
43: Generic_Error( 'MO_UTILS.Get_Set_of_Books_Name'
44: , sqlcode
45: , sqlerrm);
46:
47: END Get_Set_Of_Books_Name;
62: p_sob_id,
63: p_sob_name);
64: EXCEPTION
65: WHEN OTHERS THEN
66: Generic_Error( 'MO_UTILS.Get_Set_Of_Books_Info'
67: , sqlcode
68: , sqlerrm);
69:
70: END Get_Set_Of_Books_Info;
96: RETURN l_ledger_name;
97:
98: EXCEPTION
99: WHEN OTHERS THEN
100: Generic_Error( 'MO_UTILS.Get_Ledger_Name'
101: , sqlcode
102: , sqlerrm);
103:
104: END Get_Ledger_Name;
137: p_ledger_name := l_ledger_name;
138:
139: EXCEPTION
140: WHEN OTHERS THEN
141: Generic_Error( 'MO_UTILS.Get_Ledger_Info'
142: , sqlcode
143: , sqlerrm);
144:
145: END Get_Ledger_Info;
156: RETURN mo_global.is_multi_org_enabled;
157:
158: EXCEPTION
159: WHEN OTHERS THEN
160: Generic_Error( 'MO_UTILS.Get_Multi_Org_Flag'
161: , sqlcode
162: , sqlerrm);
163:
164: END Get_Multi_Org_Flag;
237: p_default_ou_name := l_default_ou_name;
238:
239: EXCEPTION
240: WHEN OTHERS THEN
241: Generic_Error('MO_UTILS.Get_Default_OU'
242: , sqlcode
243: , sqlerrm);
244: END get_default_ou;
245:
297: END IF;
298:
299: EXCEPTION
300: WHEN OTHERS THEN
301: Generic_Error( 'MO_UTILS.Get_Child_Tab_Orgs'
302: , sqlcode
303: , sqlerrm);
304: END get_child_tab_orgs;
305:
319: return l_def_org_id;
320:
321: EXCEPTION
322: WHEN OTHERS THEN
323: generic_error('MO_UTILS.Get_Default_Org_ID', sqlcode, sqlerrm);
324:
325: END get_default_org_id;
326:
327: --
491:
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: generic_error('MO_UTILS.Check_Org_In_SP', sqlcode, sqlerrm);
496: END check_org_in_sp;
497:
498:
499: --
545: return 'Y';
546:
547: EXCEPTION
548: WHEN OTHERS THEN
549: -- generic_error('MO_UTILS.Check_Ledger_In_SP', sqlcode, sqlerrm);
550: return 'N';
551: END check_ledger_in_sp;
552:
553:
570: RETURN l_org_name;
571:
572: EXCEPTION
573: WHEN OTHERS THEN
574: Generic_Error('MO_UTILS.Get_Org_Name'
575: , sqlcode
576: , sqlerrm);
577:
578: END Get_Org_Name;
577:
578: END Get_Org_Name;
579:
580:
581: END MO_UTILS;