1: PACKAGE BODY AS_CLASSIFICATION_HOOKS as
2: /* $Header: asxccihb.pls 115.7 2002/11/06 00:39:49 appldev ship $ */
3:
4:
5: procedure update_selectable_flag(p_class_category in varchar2) is
22: and denorm.class_category = p_class_category);
23: Exception
24: When Others then
25: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd sel flag:' || sqlerrm);
26: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_selectable_flag');
27: end;
28:
29: procedure update_class_category_post(p_class_category in varchar2,
30: p_category_meaning in varchar2,
53:
54: Exception
55: When Others then
56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd Category Post:' || sqlerrm);
57: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_class_category_post');
58:
59:
60: end;
61:
164:
165: Exception
166: When Others then
167: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Reg lookup code Post:' || sqlerrm);
168: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'register_lookup_code_post');
169:
170: end;
171:
172: -- private function
361:
362: Exception
363: When Others then
364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd lookup code Post:' || sqlerrm);
365: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_lookup_code_post');
366:
367: end;
368:
369: -- private procedure
763:
764: Exception
765: When Others then
766: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Cre code rel Post:' || sqlerrm);
767: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'create_class_code_rel_post');
768:
769: end;
770:
771: procedure update_class_code_rel_post(p_class_category in varchar2,
779: and p_class_code = p_sub_class_code
780: and sysdate between start_date_active and nvl(end_date_active,sysdate);
781:
782: cursor get_concat_meaning_csr is
783: select lookup_code,language,as_classification_hooks.get_concat_meaning(lookup_type,lookup_code,language)
784: from fnd_lookup_values
785: where lookup_type = p_class_category;
786:
787: cursor get_concat_code_csr is
784: from fnd_lookup_values
785: where lookup_type = p_class_category;
786:
787: cursor get_concat_code_csr is
788: select lookup_code,as_classification_hooks.get_concat_code(lookup_type,lookup_code)
789: from fnd_lookup_values
790: where lookup_type = p_class_category;
791:
792: cursor code_relation_exist_csr is
911: end if;
912: Exception
913: When Others then
914: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd code rel Post:' || sqlerrm);
915: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_class_code_rel_post');
916:
917: end;
918:
919: END AS_CLASSIFICATION_HOOKS;
915: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_class_code_rel_post');
916:
917: end;
918:
919: END AS_CLASSIFICATION_HOOKS;