eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_OBJECTATTRIBUTE_PVT dependencies on FND_API

Line 33: x_return_status := FND_API.g_ret_sts_success;

29: l_api_name CONSTANT VARCHAR2(30) := 'create_attribute';
30:
31: BEGIN
32:
33: x_return_status := FND_API.g_ret_sts_success;
34:
35: open c_get_attr_seq;
36: fetch c_get_attr_seq into l_attribute_id;
37: close c_get_attr_seq;

Line 73: x_return_status := FND_API.g_ret_sts_unexp_error ;

69:
70: EXCEPTION
71:
72: WHEN OTHERS THEN
73: x_return_status := FND_API.g_ret_sts_unexp_error ;
74:
75: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
76: THEN
77: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

85: -- create_object_attributes
86: -----------------------------------------------------------------
87: PROCEDURE create_object_attributes(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT VARCHAR2,

Line 90: p_commit IN VARCHAR2 := FND_API.g_false,

86: -----------------------------------------------------------------
87: PROCEDURE create_object_attributes(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT VARCHAR2,
94: x_msg_count OUT NUMBER,

Line 91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

87: PROCEDURE create_object_attributes(
88: p_api_version IN NUMBER,
89: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
90: p_commit IN VARCHAR2 := FND_API.g_false,
91: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
92:
93: x_return_status OUT VARCHAR2,
94: x_msg_count OUT NUMBER,
95: x_msg_data OUT VARCHAR2,

Line 129: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
132:
133: IF NOT FND_API.compatible_api_call(

Line 133: IF NOT FND_API.compatible_api_call(

129: IF FND_API.to_boolean(p_init_msg_list) THEN
130: FND_MSG_PUB.initialize;
131: END IF;
132:
133: IF NOT FND_API.compatible_api_call(
134: l_api_version,
135: p_api_version,
136: l_api_name,
137: g_pkg_name

Line 139: RAISE FND_API.g_exc_unexpected_error;

135: p_api_version,
136: l_api_name,
137: g_pkg_name
138: ) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
141:
142: x_return_status := FND_API.g_ret_sts_success;
143:

Line 142: x_return_status := FND_API.g_ret_sts_success;

138: ) THEN
139: RAISE FND_API.g_exc_unexpected_error;
140: END IF;
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:

Line 153: RAISE FND_API.g_exc_error;

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
157: open c_get_object_attr_count;

Line 164: RAISE FND_API.g_exc_error;

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:
168: AMS_Utility_PVT.debug_message(l_full_name ||': get attributes');

Line 189: IF l_return_status = FND_API.g_ret_sts_error THEN

185:
186: x_return_status => l_return_status
187: );
188:
189: IF l_return_status = FND_API.g_ret_sts_error THEN
190: close c_get_custom_attributes;
191: RAISE FND_API.g_exc_error;
192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
193: close c_get_custom_attributes;

Line 191: RAISE FND_API.g_exc_error;

187: );
188:
189: IF l_return_status = FND_API.g_ret_sts_error THEN
190: close c_get_custom_attributes;
191: RAISE FND_API.g_exc_error;
192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
193: close c_get_custom_attributes;
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;

Line 192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

188:
189: IF l_return_status = FND_API.g_ret_sts_error THEN
190: close c_get_custom_attributes;
191: RAISE FND_API.g_exc_error;
192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
193: close c_get_custom_attributes;
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:

Line 194: RAISE FND_API.g_exc_unexpected_error;

190: close c_get_custom_attributes;
191: RAISE FND_API.g_exc_error;
192: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
193: close c_get_custom_attributes;
194: RAISE FND_API.g_exc_unexpected_error;
195: END IF;
196:
197: end loop;
198: close c_get_custom_attributes;

Line 212: IF l_return_status = FND_API.g_ret_sts_error THEN

208: x_attribute_defined_flag => 'Y',
209: x_return_status => l_return_status
210: );
211:
212: IF l_return_status = FND_API.g_ret_sts_error THEN
213: RAISE FND_API.g_exc_error;
214: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
215: RAISE FND_API.g_exc_unexpected_error;
216: END IF;

Line 213: RAISE FND_API.g_exc_error;

209: x_return_status => l_return_status
210: );
211:
212: IF l_return_status = FND_API.g_ret_sts_error THEN
213: RAISE FND_API.g_exc_error;
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:

Line 214: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

210: );
211:
212: IF l_return_status = FND_API.g_ret_sts_error THEN
213: RAISE FND_API.g_exc_error;
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');

Line 215: RAISE FND_API.g_exc_unexpected_error;

211:
212: IF l_return_status = FND_API.g_ret_sts_error THEN
213: RAISE FND_API.g_exc_error;
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:

Line 220: IF FND_API.to_boolean(p_commit) THEN

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;
223:
224: FND_MSG_PUB.count_and_get(

Line 225: p_encoded => FND_API.g_false,

221: COMMIT;
222: END IF;
223:
224: FND_MSG_PUB.count_and_get(
225: p_encoded => FND_API.g_false,
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229:

Line 232: WHEN FND_API.g_exc_error THEN

228: );
229:
230: EXCEPTION
231:
232: WHEN FND_API.g_exc_error THEN
233: ROLLBACK TO create_object_attributes;
234: x_return_status := FND_API.g_ret_sts_error;
235: FND_MSG_PUB.count_and_get(
236: p_encoded => FND_API.g_false,

Line 234: x_return_status := FND_API.g_ret_sts_error;

230: EXCEPTION
231:
232: WHEN FND_API.g_exc_error THEN
233: ROLLBACK TO create_object_attributes;
234: x_return_status := FND_API.g_ret_sts_error;
235: FND_MSG_PUB.count_and_get(
236: p_encoded => FND_API.g_false,
237: p_count => x_msg_count,
238: p_data => x_msg_data

Line 236: p_encoded => FND_API.g_false,

232: WHEN FND_API.g_exc_error THEN
233: ROLLBACK TO create_object_attributes;
234: x_return_status := FND_API.g_ret_sts_error;
235: FND_MSG_PUB.count_and_get(
236: p_encoded => FND_API.g_false,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240:

Line 241: WHEN FND_API.g_exc_unexpected_error THEN

237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240:
241: WHEN FND_API.g_exc_unexpected_error THEN
242: ROLLBACK TO create_object_attributes;
243: x_return_status := FND_API.g_ret_sts_unexp_error ;
244: FND_MSG_PUB.count_and_get(
245: p_encoded => FND_API.g_false,

Line 243: x_return_status := FND_API.g_ret_sts_unexp_error ;

239: );
240:
241: WHEN FND_API.g_exc_unexpected_error THEN
242: ROLLBACK TO create_object_attributes;
243: x_return_status := FND_API.g_ret_sts_unexp_error ;
244: FND_MSG_PUB.count_and_get(
245: p_encoded => FND_API.g_false,
246: p_count => x_msg_count,
247: p_data => x_msg_data

Line 245: p_encoded => FND_API.g_false,

241: WHEN FND_API.g_exc_unexpected_error THEN
242: ROLLBACK TO create_object_attributes;
243: x_return_status := FND_API.g_ret_sts_unexp_error ;
244: FND_MSG_PUB.count_and_get(
245: p_encoded => FND_API.g_false,
246: p_count => x_msg_count,
247: p_data => x_msg_data
248: );
249:

Line 253: x_return_status := FND_API.g_ret_sts_unexp_error ;

249:
250:
251: WHEN OTHERS THEN
252: ROLLBACK TO create_object_attributes;
253: x_return_status := FND_API.g_ret_sts_unexp_error ;
254:
255: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
256: THEN
257: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 261: p_encoded => FND_API.g_false,

257: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
258: END IF;
259:
260: FND_MSG_PUB.count_and_get(
261: p_encoded => FND_API.g_false,
262: p_count => x_msg_count,
263: p_data => x_msg_data
264: );
265:

Line 275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

271: -- process_object_attribute
272: -----------------------------------------------------------------
273: PROCEDURE modify_object_attribute(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276: p_commit IN VARCHAR2 := FND_API.g_false,
277: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
278:
279: x_return_status OUT VARCHAR2,

Line 276: p_commit IN VARCHAR2 := FND_API.g_false,

272: -----------------------------------------------------------------
273: PROCEDURE modify_object_attribute(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276: p_commit IN VARCHAR2 := FND_API.g_false,
277: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
278:
279: x_return_status OUT VARCHAR2,
280: x_msg_count OUT NUMBER,

Line 277: p_validation_level IN NUMBER := FND_API.g_valid_level_full,

273: PROCEDURE modify_object_attribute(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
276: p_commit IN VARCHAR2 := FND_API.g_false,
277: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
278:
279: x_return_status OUT VARCHAR2,
280: x_msg_count OUT NUMBER,
281: x_msg_data OUT VARCHAR2,

Line 311: IF FND_API.to_boolean(p_init_msg_list) THEN

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;
314:
315: IF NOT FND_API.compatible_api_call(

Line 315: IF NOT FND_API.compatible_api_call(

311: IF FND_API.to_boolean(p_init_msg_list) THEN
312: FND_MSG_PUB.initialize;
313: END IF;
314:
315: IF NOT FND_API.compatible_api_call(
316: l_api_version,
317: p_api_version,
318: l_api_name,
319: g_pkg_name

Line 321: RAISE FND_API.g_exc_unexpected_error;

317: p_api_version,
318: l_api_name,
319: g_pkg_name
320: ) THEN
321: RAISE FND_API.g_exc_unexpected_error;
322: END IF;
323:
324: x_return_status := FND_API.g_ret_sts_success;
325:

Line 324: x_return_status := FND_API.g_ret_sts_success;

320: ) THEN
321: RAISE FND_API.g_exc_unexpected_error;
322: END IF;
323:
324: x_return_status := FND_API.g_ret_sts_success;
325:
326: -- check 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

Line 332: RAISE FND_API.g_exc_error;

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
336: AMS_Utility_PVT.error_message('AMS_OBA_BAD_ATTR_FLAG');

Line 337: 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;
341: fetch c_get_object_attribute into l_attr_flag;

Line 345: RAISE FND_API.g_exc_error;

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;
349: UPDATE ams_object_attributes

Line 358: IF FND_API.to_boolean(p_commit) THEN

354: AND object_attribute = p_attr;
355: end if;
356:
357:
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');

Line 365: p_encoded => FND_API.g_false,

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,
367: p_data => x_msg_data
368: );
369:

Line 372: WHEN FND_API.g_exc_error THEN

368: );
369:
370: EXCEPTION
371:
372: WHEN FND_API.g_exc_error THEN
373: ROLLBACK TO modify_object_attribute;
374: x_return_status := FND_API.g_ret_sts_error;
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,

Line 374: x_return_status := FND_API.g_ret_sts_error;

370: EXCEPTION
371:
372: WHEN FND_API.g_exc_error THEN
373: ROLLBACK TO modify_object_attribute;
374: x_return_status := FND_API.g_ret_sts_error;
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data

Line 376: p_encoded => FND_API.g_false,

372: WHEN FND_API.g_exc_error THEN
373: ROLLBACK TO modify_object_attribute;
374: x_return_status := FND_API.g_ret_sts_error;
375: FND_MSG_PUB.count_and_get(
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380:

Line 381: WHEN FND_API.g_exc_unexpected_error THEN

377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO modify_object_attribute;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,

Line 383: x_return_status := FND_API.g_ret_sts_unexp_error ;

379: );
380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO modify_object_attribute;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data

Line 385: p_encoded => FND_API.g_false,

381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO modify_object_attribute;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );
389:

Line 393: x_return_status := FND_API.g_ret_sts_unexp_error ;

389:
390:
391: WHEN OTHERS THEN
392: ROLLBACK TO modify_object_attribute;
393: x_return_status := FND_API.g_ret_sts_unexp_error ;
394:
395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
396: THEN
397: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);

Line 401: p_encoded => FND_API.g_false,

397: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
398: END IF;
399:
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405:

Line 420: RETURN VARCHAR2 --FND_API.g_true/g_false

416: p_obj_type IN VARCHAR2,
417: p_obj_id IN NUMBER,
418: p_attribute IN VARCHAR2
419: )
420: RETURN VARCHAR2 --FND_API.g_true/g_false
421: IS
422:
423: l_dummy NUMBER;
424:

Line 442: RETURN FND_API.g_false;

438: FETCH c_object_attr INTO l_dummy;
439: CLOSE c_object_attr;
440:
441: IF l_dummy IS NULL THEN
442: RETURN FND_API.g_false;
443: ELSE
444: RETURN FND_API.g_true;
445: END IF;
446:

Line 444: RETURN FND_API.g_true;

440:
441: IF l_dummy IS NULL THEN
442: RETURN FND_API.g_false;
443: ELSE
444: RETURN FND_API.g_true;
445: END IF;
446:
447: END check_object_attribute;
448: