APPS.AS_CLASSIFICATION_HOOKS dependencies on FND_MSG_PUB

Line 25: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd sel flag:' || sqlerrm);

21: and denorm.class_category= rel2.class_category
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,

Line 26: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_selectable_flag');

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,

Line 34: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post Start');

30: p_category_meaning in varchar2,
31: p_allow_leaf_node_only_flag in varchar2) is
32:
33: begin
34: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post Start');
35:
36: update as_hz_class_code_denorm
37: set class_category_meaning = p_category_meaning
38: where class_category = p_class_category

Line 52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post End');

48: where denorm.class_category = p_class_category
49: and selectable_flag = 'N';
50: end if;
51:
52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post End');
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);

Line 56: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd Category Post:' || sqlerrm);

52: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Update Category Post End');
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;

Line 57: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_class_category_post');

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:

Line 167: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Reg lookup code Post:' || sqlerrm);

163: where lookup_type = p_lookup_type;
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:

Line 168: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'register_lookup_code_post');

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

Line 364: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd lookup code Post:' || sqlerrm);

360: and language = userenv('LANG');
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:

Line 365: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_lookup_code_post');

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

Line 766: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Cre code rel Post:' || sqlerrm);

762: end if;
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:

Line 767: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'create_class_code_rel_post');

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,

Line 914: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,'Error in Upd code rel Post:' || sqlerrm);

910: close code_relation_exist_csr;
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:

Line 915: FND_MSG_PUB.Add_Exc_Msg('AS_CLASSIFICATION_HOOKS', 'update_class_code_rel_post');

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;