DBA Data[Home] [Help]

APPS.AMS_OBJECTATTRIBUTE_PVT dependencies on AMS_UTILITY_PVT

Line 127: AMS_Utility_PVT.debug_message(l_full_name||': start');

123: BEGIN
124:
125: -- initialize
126: SAVEPOINT create_object_attributes;
127: AMS_Utility_PVT.debug_message(l_full_name||': start');
128:
129: IF FND_API.to_boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.initialize;
131: END IF;

Line 145: AMS_Utility_PVT.debug_message(l_full_name ||': checking setup id');

141:
142: x_return_status := FND_API.g_ret_sts_success;
143:
144:
145: AMS_Utility_PVT.debug_message(l_full_name ||': checking setup id');
146:
147: -- check arc object
148: -- Following code is modified by ptendulk on 30-Jan-2001 to add attributes to schedules.
149: -- IF p_object_type NOT IN ('CAMP','DELV','EVEH','EVEO','FUND','MESG','OFFR','CLAM','PROD','PRIC') THEN

Line 152: AMS_Utility_PVT.error_message('AMS_SCG_BAD_ARC_OBJECT');

148: -- Following code is modified by ptendulk on 30-Jan-2001 to add attributes to schedules.
149: -- IF p_object_type NOT IN ('CAMP','DELV','EVEH','EVEO','FUND','MESG','OFFR','CLAM','PROD','PRIC') THEN
150: -- end of code Modified by ptendulk
151: IF p_object_type NOT IN ('CAMP','DELV','EVEH','EVEO','FUND','MESG','OFFR','CLAM','PROD','PRIC','CSCH') THEN
152: AMS_Utility_PVT.error_message('AMS_SCG_BAD_ARC_OBJECT');
153: RAISE FND_API.g_exc_error;
154: END IF;
155:
156: -- check if the setup type is valid and if there are any attributes

Line 163: AMS_Utility_PVT.error_message('AMS_OBA_BAD_SETUP_TYPE');

159: close c_get_object_attr_count;
160:
161: if l_attr_count = 0 then
162: -- raise an error -- setup type / attributes does not exist
163: AMS_Utility_PVT.error_message('AMS_OBA_BAD_SETUP_TYPE');
164: RAISE FND_API.g_exc_error;
165: end if;
166:
167:

Line 168: AMS_Utility_PVT.debug_message(l_full_name ||': get attributes');

164: RAISE FND_API.g_exc_error;
165: end if;
166:
167:
168: AMS_Utility_PVT.debug_message(l_full_name ||': get attributes');
169:
170: open c_get_custom_attributes;
171: loop
172: fetch c_get_custom_attributes into l_seq_no, l_obj_attr;

Line 175: AMS_Utility_PVT.debug_message(l_full_name ||': '||l_obj_attr);

171: loop
172: fetch c_get_custom_attributes into l_seq_no, l_obj_attr;
173: exit when c_get_custom_attributes%notfound;
174:
175: AMS_Utility_PVT.debug_message(l_full_name ||': '||l_obj_attr);
176:
177: --insert attribute row;
178: create_attribute(
179: x_object_type => p_object_type,

Line 200: AMS_Utility_PVT.debug_message(l_full_name ||': insert general attribute');

196:
197: end loop;
198: close c_get_custom_attributes;
199:
200: AMS_Utility_PVT.debug_message(l_full_name ||': insert general attribute');
201:
202: create_attribute(
203: x_object_type => p_object_type,
204: x_object_id => p_object_id,

Line 218: AMS_Utility_PVT.debug_message(l_full_name ||': End');

214: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
215: RAISE FND_API.g_exc_unexpected_error;
216: END IF;
217:
218: AMS_Utility_PVT.debug_message(l_full_name ||': End');
219:
220: IF FND_API.to_boolean(p_commit) THEN
221: COMMIT;
222: END IF;

Line 309: AMS_Utility_PVT.debug_message(l_full_name||': start');

305:
306: --------------------- initialize -----------------------
307: SAVEPOINT modify_object_attribute;
308:
309: AMS_Utility_PVT.debug_message(l_full_name||': start');
310:
311: IF FND_API.to_boolean(p_init_msg_list) THEN
312: FND_MSG_PUB.initialize;
313: END IF;

Line 331: AMS_Utility_PVT.error_message('AMS_SCG_BAD_ARC_OBJECT');

327: -- Following code is modified by ptendulk on 30-Jan-2001 to add attributes to schedules.
328: --IF p_object_type NOT IN ('CAMP','DELV','EVEH','EVEO','FUND','MESG','OFFR','CLAM','PROD','PRIC') THEN
329: IF p_object_type NOT IN ('CAMP','DELV','EVEH','EVEO','FUND','MESG','OFFR','CLAM','PROD','PRIC','CSCH') THEN
330: -- End of code modified by ptendulk on 30-Jan-2001 to add attributes to schedules.
331: AMS_Utility_PVT.error_message('AMS_SCG_BAD_ARC_OBJECT');
332: RAISE FND_API.g_exc_error;
333: END IF;
334:
335: IF p_attr_defined_flag NOT IN ( 'Y', 'N') THEN

Line 336: AMS_Utility_PVT.error_message('AMS_OBA_BAD_ATTR_FLAG');

332: RAISE FND_API.g_exc_error;
333: END IF;
334:
335: IF p_attr_defined_flag NOT IN ( 'Y', 'N') THEN
336: AMS_Utility_PVT.error_message('AMS_OBA_BAD_ATTR_FLAG');
337: RAISE FND_API.g_exc_error;
338: END IF;
339:
340: open c_get_object_attribute;

Line 344: AMS_Utility_PVT.error_message('AMS_OBA_BAD_SETUP_ATTR');

340: open c_get_object_attribute;
341: fetch c_get_object_attribute into l_attr_flag;
342: if c_get_object_attribute%notfound then
343: close c_get_object_attribute;
344: AMS_Utility_PVT.error_message('AMS_OBA_BAD_SETUP_ATTR');
345: RAISE FND_API.g_exc_error;
346: else
347: AMS_Utility_PVT.debug_message(l_full_name ||': updating object attribute');
348: close c_get_object_attribute;

Line 347: AMS_Utility_PVT.debug_message(l_full_name ||': updating object attribute');

343: close c_get_object_attribute;
344: AMS_Utility_PVT.error_message('AMS_OBA_BAD_SETUP_ATTR');
345: RAISE FND_API.g_exc_error;
346: else
347: AMS_Utility_PVT.debug_message(l_full_name ||': updating object attribute');
348: close c_get_object_attribute;
349: UPDATE ams_object_attributes
350: SET attribute_defined_flag = p_attr_defined_flag,
351: object_version_number = object_version_number + 1

Line 362: AMS_Utility_PVT.debug_message(l_full_name ||': End');

358: IF FND_API.to_boolean(p_commit) THEN
359: COMMIT;
360: END IF;
361:
362: AMS_Utility_PVT.debug_message(l_full_name ||': End');
363:
364: FND_MSG_PUB.count_and_get(
365: p_encoded => FND_API.g_false,
366: p_count => x_msg_count,