DBA Data[Home] [Help]

APPS.AMS_SETUP_ATTR_PVT dependencies on FND_API

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

15:
16: PROCEDURE create_setup_attr
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,

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

16: PROCEDURE create_setup_attr
17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,

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

17: (
18: p_api_version IN NUMBER,
19: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
20: p_commit IN VARCHAR2 := FND_API.g_false,
21: p_validation_level IN NUMBER :=FND_API.g_valid_level_full,
22:
23: x_return_status OUT NOCOPY VARCHAR2,
24: x_msg_count OUT NOCOPY NUMBER,
25: x_msg_data OUT NOCOPY VARCHAR2,

Line 52: IF FND_API.to_boolean(p_init_msg_list) THEN

48: BEGIN
49: -- initialize
50: SAVEPOINT create_setup_attr;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: IF (AMS_DEBUG_HIGH_ON) THEN

Line 64: /* IF NOT FND_API.compatible_api_call

60: AMS_Utility_PVT.debug_message(l_full_name || ': start');
61:
62: END IF;
63:
64: /* IF NOT FND_API.compatible_api_call
65: (
66: l_api_version,
67: p_api_version,
68: l_api_name,

Line 72: RAISE FND_API.g_exc_unexpected_error;

68: l_api_name,
69: g_pkg_name
70: )
71: THEN
72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74: */
75:
76: x_return_status := FND_API.g_ret_sts_success;

Line 76: x_return_status := FND_API.g_ret_sts_success;

72: RAISE FND_API.g_exc_unexpected_error;
73: END IF;
74: */
75:
76: x_return_status := FND_API.g_ret_sts_success;
77:
78: -- validate
79: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
80: IF (AMS_DEBUG_HIGH_ON) THEN

Line 96: IF l_return_status = FND_API.g_ret_sts_error THEN

92: x_msg_data => x_msg_data,
93: p_setup_attr_rec => l_setup_attr_rec
94: );
95:
96: IF l_return_status = FND_API.g_ret_sts_error THEN
97: RAISE FND_API.g_exc_error;
98: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
99: RAISE FND_API.g_exc_unexpected_error;
100: END IF;

Line 97: RAISE FND_API.g_exc_error;

93: p_setup_attr_rec => l_setup_attr_rec
94: );
95:
96: IF l_return_status = FND_API.g_ret_sts_error THEN
97: RAISE FND_API.g_exc_error;
98: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
99: RAISE FND_API.g_exc_unexpected_error;
100: END IF;
101: END IF;

Line 98: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

94: );
95:
96: IF l_return_status = FND_API.g_ret_sts_error THEN
97: RAISE FND_API.g_exc_error;
98: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
99: RAISE FND_API.g_exc_unexpected_error;
100: END IF;
101: END IF;
102:

Line 99: RAISE FND_API.g_exc_unexpected_error;

95:
96: IF l_return_status = FND_API.g_ret_sts_error THEN
97: RAISE FND_API.g_exc_error;
98: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
99: RAISE FND_API.g_exc_unexpected_error;
100: END IF;
101: END IF;
102:
103: -- insert

Line 175: IF FND_API.to_boolean(p_commit) THEN

171:
172: -- finish
173: x_setup_attr_id := l_setup_attr_rec.setup_attribute_id;
174:
175: IF FND_API.to_boolean(p_commit) THEN
176: COMMIT;
177: END IF;
178:
179: FND_MSG_PUB.count_and_get

Line 181: p_encoded => FND_API.g_false,

177: END IF;
178:
179: FND_MSG_PUB.count_and_get
180: (
181: p_encoded => FND_API.g_false,
182: p_count => x_msg_count,
183: p_data => x_msg_data
184: );
185:

Line 196: WHEN FND_API.g_exc_error THEN

192: END IF;
193:
194: EXCEPTION
195:
196: WHEN FND_API.g_exc_error THEN
197: ROLLBACK TO create_setup_attr;
198: x_return_status := FND_API.g_ret_sts_error;
199: FND_MSG_PUB.count_and_get
200: (

Line 198: x_return_status := FND_API.g_ret_sts_error;

194: EXCEPTION
195:
196: WHEN FND_API.g_exc_error THEN
197: ROLLBACK TO create_setup_attr;
198: x_return_status := FND_API.g_ret_sts_error;
199: FND_MSG_PUB.count_and_get
200: (
201: p_encoded => FND_API.g_false,
202: p_count => x_msg_count,

Line 201: p_encoded => FND_API.g_false,

197: ROLLBACK TO create_setup_attr;
198: x_return_status := FND_API.g_ret_sts_error;
199: FND_MSG_PUB.count_and_get
200: (
201: p_encoded => FND_API.g_false,
202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205:

Line 206: WHEN FND_API.g_exc_unexpected_error THEN

202: p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205:
206: WHEN FND_API.g_exc_unexpected_error THEN
207: ROLLBACK TO create_setup_attr;
208: x_return_status := FND_API.g_ret_sts_unexp_error;
209: FND_MSG_PUB.count_and_get
210: (

Line 208: x_return_status := FND_API.g_ret_sts_unexp_error;

204: );
205:
206: WHEN FND_API.g_exc_unexpected_error THEN
207: ROLLBACK TO create_setup_attr;
208: x_return_status := FND_API.g_ret_sts_unexp_error;
209: FND_MSG_PUB.count_and_get
210: (
211: p_encoded => FND_API.g_false,
212: p_count => x_msg_count,

Line 211: p_encoded => FND_API.g_false,

207: ROLLBACK TO create_setup_attr;
208: x_return_status := FND_API.g_ret_sts_unexp_error;
209: FND_MSG_PUB.count_and_get
210: (
211: p_encoded => FND_API.g_false,
212: p_count => x_msg_count,
213: p_data => x_msg_data
214: );
215:

Line 218: x_return_status :=FND_API.g_ret_sts_unexp_error;

214: );
215:
216: WHEN OTHERS THEN
217: ROLLBACK TO create_setup_attr;
218: x_return_status :=FND_API.g_ret_sts_unexp_error;
219: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
220: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
221: END IF;
222: FND_MSG_PUB.count_and_get

Line 224: p_encoded => FND_API.g_false,

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

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

237: -------------------------------------------------------------------------------
238: PROCEDURE update_setup_attr
239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,

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

238: PROCEDURE update_setup_attr
239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,

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

239: (
240: p_api_version IN NUMBER,
241: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
242: p_commit IN VARCHAR2 := FND_API.g_false,
243: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
244:
245: x_return_status OUT NOCOPY VARCHAR2,
246: x_msg_count OUT NOCOPY NUMBER,
247: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: IF FND_API.to_boolean(p_init_msg_list) THEN

260:
261: -- initialize
262: SAVEPOINT update_setup_attr;
263:
264: IF FND_API.to_boolean(p_init_msg_list) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_success;

Line 268: x_return_status := FND_API.g_ret_sts_success;

264: IF FND_API.to_boolean(p_init_msg_list) THEN
265: FND_MSG_PUB.initialize;
266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_success;
269:
270: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start of api'); END IF;
271:
272: /***

Line 273: IF NOT FND_API.compatible_api_call

269:
270: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start of api'); END IF;
271:
272: /***
273: IF NOT FND_API.compatible_api_call
274: (
275: l_api_version,
276: p_api_version,
277: l_api_name,

Line 281: RAISE FND_API.g_exc_unexpected_error;

277: l_api_name,
278: g_pkg_name
279: )
280: THEN
281: RAISE FND_API.g_exc_unexpected_error;
282: END IF;
283: **/
284:
285:

Line 306: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

302: x_return_status => l_return_status,
303: p_setup_attr_rec => l_setup_attr_rec
304: );
305:
306: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.g_exc_error;
310: END IF;

Line 307: RAISE FND_API.g_exc_unexpected_error;

303: p_setup_attr_rec => l_setup_attr_rec
304: );
305:
306: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.g_exc_error;
310: END IF;
311: END IF;

Line 308: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

304: );
305:
306: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.g_exc_error;
310: END IF;
311: END IF;
312:

Line 309: RAISE FND_API.g_exc_error;

305:
306: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
307: RAISE FND_API.g_exc_unexpected_error;
308: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
309: RAISE FND_API.g_exc_error;
310: END IF;
311: END IF;
312:
313: -- update

Line 344: RAISE FND_API.g_exc_error;

340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
341: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
342: FND_MSG_PUB.add;
343: END IF;
344: RAISE FND_API.g_exc_error;
345: END IF;
346:
347: -- finish
348: IF FND_API.to_boolean(p_commit) THEN

Line 348: IF FND_API.to_boolean(p_commit) THEN

344: RAISE FND_API.g_exc_error;
345: END IF;
346:
347: -- finish
348: IF FND_API.to_boolean(p_commit) THEN
349: COMMIT;
350: END IF;
351:
352: FND_MSG_PUB.count_and_get

Line 354: P_ENCODED => FND_API.g_false,

350: END IF;
351:
352: FND_MSG_PUB.count_and_get
353: (
354: P_ENCODED => FND_API.g_false,
355: p_count => x_msg_count,
356: p_data => x_msg_data
357: );
358:

Line 369: WHEN FND_API.g_exc_error THEN

365: END IF;
366:
367: EXCEPTION
368:
369: WHEN FND_API.g_exc_error THEN
370: ROLLBACK TO update_setup_attr;
371: x_return_status := FND_API.g_ret_sts_error;
372: FND_MSG_PUB.count_and_get
373: (

Line 371: x_return_status := FND_API.g_ret_sts_error;

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

Line 374: p_encoded => FND_API.g_false,

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

Line 379: WHEN FND_API.g_exc_unexpected_error THEN

375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );
378:
379: WHEN FND_API.g_exc_unexpected_error THEN
380: ROLLBACK TO update_setup_attr;
381: x_return_status := FND_API.g_ret_sts_unexp_error;
382: FND_MSG_PUB.count_and_get
383: (

Line 381: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 384: p_encoded => FND_API.g_false,

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

Line 391: x_return_status :=FND_API.g_ret_sts_unexp_error;

387: );
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO update_setup_attr;
391: x_return_status :=FND_API.g_ret_sts_unexp_error;
392: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
393: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
394: END IF;
395: FND_MSG_PUB.count_and_get

Line 397: p_encoded => FND_API.g_false,

393: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
394: END IF;
395: FND_MSG_PUB.count_and_get
396: (
397: p_encoded => FND_API.g_false,
398: p_count => x_msg_count,
399: p_data => x_msg_data
400: );
401:

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

411: --------------------------------------------------------------------
412: PROCEDURE validate_setup_attr
413: (
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
416: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
417:
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,

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

412: PROCEDURE validate_setup_attr
413: (
414: p_api_version IN NUMBER,
415: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
416: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
417:
418: x_return_status OUT NOCOPY VARCHAR2,
419: x_msg_count OUT NOCOPY NUMBER,
420: x_msg_data OUT NOCOPY VARCHAR2,

Line 437: IF FND_API.to_boolean(p_init_msg_list) THEN

433:
434: ----------------------- initialize --------------------
435: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name||': start start '); END IF;
436:
437: IF FND_API.to_boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: /** IF NOT FND_API.compatible_api_call(

Line 441: /** IF NOT FND_API.compatible_api_call(

437: IF FND_API.to_boolean(p_init_msg_list) THEN
438: FND_MSG_PUB.initialize;
439: END IF;
440:
441: /** IF NOT FND_API.compatible_api_call(
442: l_api_version,
443: p_api_version,
444: l_api_name,
445: g_pkg_name

Line 447: RAISE FND_API.g_exc_unexpected_error;

443: p_api_version,
444: l_api_name,
445: g_pkg_name
446: ) THEN
447: RAISE FND_API.g_exc_unexpected_error;
448: END IF;
449: **/
450:
451: x_return_status := FND_API.g_ret_sts_success;

Line 451: x_return_status := FND_API.g_ret_sts_success;

447: RAISE FND_API.g_exc_unexpected_error;
448: END IF;
449: **/
450:
451: x_return_status := FND_API.g_ret_sts_success;
452:
453: ---------------------- validate ------------------------
454: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
455: IF (AMS_DEBUG_HIGH_ON) THEN

Line 466: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

462: x_return_status => l_return_status,
463: p_setup_attr_rec => p_setup_attr_rec
464: );
465:
466: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
467: RAISE FND_API.g_exc_unexpected_error;
468: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
469: RAISE FND_API.g_exc_error;
470: END IF;

Line 467: RAISE FND_API.g_exc_unexpected_error;

463: p_setup_attr_rec => p_setup_attr_rec
464: );
465:
466: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
467: RAISE FND_API.g_exc_unexpected_error;
468: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
469: RAISE FND_API.g_exc_error;
470: END IF;
471: END IF;

Line 468: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

464: );
465:
466: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
467: RAISE FND_API.g_exc_unexpected_error;
468: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
469: RAISE FND_API.g_exc_error;
470: END IF;
471: END IF;
472:

Line 469: RAISE FND_API.g_exc_error;

465:
466: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
467: RAISE FND_API.g_exc_unexpected_error;
468: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
469: RAISE FND_API.g_exc_error;
470: END IF;
471: END IF;
472:
473: -------------------- finish --------------------------

Line 475: p_encoded => FND_API.g_false,

471: END IF;
472:
473: -------------------- finish --------------------------
474: FND_MSG_PUB.count_and_get(
475: p_encoded => FND_API.g_false,
476: p_count => x_msg_count,
477: p_data => x_msg_data
478: );
479:

Line 489: WHEN FND_API.g_exc_error THEN

485:
486: END IF;
487:
488: EXCEPTION
489: WHEN FND_API.g_exc_error THEN
490: x_return_status := FND_API.g_ret_sts_error;
491: FND_MSG_PUB.count_and_get
492: (
493: p_encoded => FND_API.g_false,

Line 490: x_return_status := FND_API.g_ret_sts_error;

486: END IF;
487:
488: EXCEPTION
489: WHEN FND_API.g_exc_error THEN
490: x_return_status := FND_API.g_ret_sts_error;
491: FND_MSG_PUB.count_and_get
492: (
493: p_encoded => FND_API.g_false,
494: p_count => x_msg_count,

Line 493: p_encoded => FND_API.g_false,

489: WHEN FND_API.g_exc_error THEN
490: x_return_status := FND_API.g_ret_sts_error;
491: FND_MSG_PUB.count_and_get
492: (
493: p_encoded => FND_API.g_false,
494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );
497:

Line 498: WHEN FND_API.g_exc_unexpected_error THEN

494: p_count => x_msg_count,
495: p_data => x_msg_data
496: );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error ;
500: FND_MSG_PUB.count_and_get
501: (
502: p_encoded => FND_API.g_false,

Line 499: x_return_status := FND_API.g_ret_sts_unexp_error ;

495: p_data => x_msg_data
496: );
497:
498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error ;
500: FND_MSG_PUB.count_and_get
501: (
502: p_encoded => FND_API.g_false,
503: p_count => x_msg_count,

Line 502: p_encoded => FND_API.g_false,

498: WHEN FND_API.g_exc_unexpected_error THEN
499: x_return_status := FND_API.g_ret_sts_unexp_error ;
500: FND_MSG_PUB.count_and_get
501: (
502: p_encoded => FND_API.g_false,
503: p_count => x_msg_count,
504: p_data => x_msg_data
505: );
506:

Line 508: x_return_status := FND_API.g_ret_sts_unexp_error;

504: p_data => x_msg_data
505: );
506:
507: WHEN OTHERS THEN
508: x_return_status := FND_API.g_ret_sts_unexp_error;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
510: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
511: END IF;
512:

Line 515: p_encoded => FND_API.g_false,

511: END IF;
512:
513: FND_MSG_PUB.count_and_get
514: (
515: p_encoded => FND_API.g_false,
516: p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519:

Line 545: x_return_status := FND_API.g_ret_sts_success;

541: BEGIN
542: -- initialize
543: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': start'); END IF;
544:
545: x_return_status := FND_API.g_ret_sts_success;
546:
547: -- check required items
548: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': check required items'); END IF;
549: check_setup_attr_req_items

Line 556: IF x_return_status <> FND_API.g_ret_sts_success THEN

552: p_setup_attr_rec => p_setup_attr_rec,
553: x_return_status => x_return_status
554: );
555:
556: IF x_return_status <> FND_API.g_ret_sts_success THEN
557: RETURN;
558: END IF;
559:
560: -- check unique key items

Line 569: IF x_return_status <> FND_API.g_ret_sts_success THEN

565: p_setup_attr_rec => p_setup_attr_rec,
566: x_return_status => x_return_status
567: );
568:
569: IF x_return_status <> FND_API.g_ret_sts_success THEN
570: RETURN;
571: END IF;
572: */
573: -- check foreign key items

Line 581: IF x_return_status <> FND_API.g_ret_sts_success THEN

577: p_setup_attr_rec => p_setup_attr_rec,
578: x_return_status => x_return_status
579: );
580:
581: IF x_return_status <> FND_API.g_ret_sts_success THEN
582: RETURN;
583: END IF;
584:
585: -- check flag items

Line 593: IF x_return_status <> FND_API.g_ret_sts_success THEN

589: p_setup_attr_rec => p_setup_attr_rec,
590: x_return_status => x_return_status
591: );
592:
593: IF x_return_status <> FND_API.g_ret_sts_success THEN
594: RETURN;
595: END IF;
596:
597: END check_items;

Line 616: x_return_status := FND_API.g_ret_sts_success;

612: IS
613:
614: BEGIN
615:
616: x_return_status := FND_API.g_ret_sts_success;
617:
618: -- check setup_attribute_id
619: IF p_setup_attr_rec.setup_attribute_id IS NULL
620: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 626: x_return_status := FND_API.g_ret_sts_error;

622: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_SETUP_ATT_ID');
623: FND_MSG_PUB.add;
624: END IF;
625:
626: x_return_status := FND_API.g_ret_sts_error;
627: RETURN;
628: END IF;
629:
630: -- check object_version_number

Line 639: x_return_status := FND_API.g_ret_sts_error;

635: FND_MESSAGE.set_name('AMS', 'AMS_API_NO_OBJ_VER_NUM');
636: FND_MSG_PUB.add;
637: END IF;
638:
639: x_return_status := FND_API.g_ret_sts_error;
640: RETURN;
641: END IF;
642:
643: -- check custom_setup_id

Line 650: x_return_status := FND_API.g_ret_sts_error;

646: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_CUS_SETUP_ID');
647: FND_MSG_PUB.add;
648: END IF;
649:
650: x_return_status := FND_API.g_ret_sts_error;
651: RETURN;
652: END IF;
653:
654: -- check display_sequence_no

Line 661: x_return_status := FND_API.g_ret_sts_error;

657: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_DIS_SEQ_NO');
658: FND_MSG_PUB.add;
659: END IF;
660:
661: x_return_status := FND_API.g_ret_sts_error;
662: RETURN;
663: END IF;
664:
665: -- check object_attribute

Line 672: x_return_status := FND_API.g_ret_sts_error;

668: FND_MESSAGE.set_name('AMS', 'AMS_CUS_SETUP_NO_OBJ_ATTR');
669: FND_MSG_PUB.add;
670: END IF;
671:
672: x_return_status := FND_API.g_ret_sts_error;
673: RETURN;
674: END IF;
675:
676: -- check attr_mandatory_flag

Line 684: x_return_status := FND_API.g_ret_sts_error;

680: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_ESS_FLAG');
681: FND_MSG_PUB.add;
682: END IF;
683:
684: x_return_status := FND_API.g_ret_sts_error;
685: RETURN;
686: END IF;
687:
688: -- Put the check for the essential seq num here

Line 696: x_return_status := FND_API.g_ret_sts_error;

692: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ESS_SEQ_NUM');
693: FND_MSG_PUB.add;
694: END IF;
695:
696: x_return_status := FND_API.g_ret_sts_error;
697: RETURN;
698: END IF;
699:
700: -- check attr_available_flag

Line 707: x_return_status := FND_API.g_ret_sts_error;

703: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATT_NO_ATT_AVAL_FLAG');
704: FND_MSG_PUB.add;
705: END IF;
706:
707: x_return_status := FND_API.g_ret_sts_error;
708: RETURN;
709: END IF;
710:
711: END check_setup_attr_req_items;

Line 742: x_return_status := FND_API.g_ret_sts_success;

738: BEGIN
739:
740: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(' UK Check '); END IF;
741:
742: x_return_status := FND_API.g_ret_sts_success;
743:
744: -- check PK, if custom_setup_id is passed in, must check if it is duplicate
745:
746: /***

Line 758: IF l_uk_flag = FND_API.g_false THEN

754: 'setup_attribute_id = ' || p_setup_attr_rec.setup_attribute_id
755: );
756: END IF;
757:
758: IF l_uk_flag = FND_API.g_false THEN
759: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
760: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_DUPLICATE_ID');
761: FND_MSG_PUB.add;
762: END IF;

Line 765: x_return_status := FND_API.g_ret_sts_error;

761: FND_MSG_PUB.add;
762: END IF;
763:
764:
765: x_return_status := FND_API.g_ret_sts_error;
766: RETURN;
767: END IF;
768: *****/
769:

Line 783: x_return_status := Fnd_Api.g_ret_sts_error;

779: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.G_MSG_LVL_ERROR)
780: THEN
781: Fnd_Message.set_name('AMS', 'AMS_ESSENTIAL_DUP_SEQ');
782: Fnd_Msg_Pub.ADD;
783: x_return_status := Fnd_Api.g_ret_sts_error;
784: RETURN;
785: END IF;
786: END IF;
787: END IF;

Line 816: x_return_status := FND_API.g_ret_sts_success;

812:
813: AMS_Utility_PVT.debug_message(' FK Check ');
814:
815: END IF;
816: x_return_status := FND_API.g_ret_sts_success;
817:
818: l_fk_flag := AMS_Utility_PVT.check_fk_exists
819: (
820: 'AMS_CUSTOM_SETUPS_B',

Line 825: IF l_fk_flag = FND_API.g_false THEN

821: 'custom_setup_id',
822: p_setup_attr_rec.custom_setup_id
823: );
824:
825: IF l_fk_flag = FND_API.g_false THEN
826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
827: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_CUS_SET_ID');
828: FND_MSG_PUB.add;
829: END IF;

Line 831: x_return_status := FND_API.g_ret_sts_error;

827: FND_MESSAGE.set_name('AMS', 'AMS_SETUP_ATTR_BAD_CUS_SET_ID');
828: FND_MSG_PUB.add;
829: END IF;
830:
831: x_return_status := FND_API.g_ret_sts_error;
832: RETURN;
833: END IF;
834:
835: END check_setup_attr_fk_items;

Line 900: x_return_status := FND_API.g_ret_sts_success;

896: l_mand_flag VARCHAR2(1);
897: l_mand_setup_attr AMS_LOOKUPS.meaning%type;
898:
899: BEGIN
900: x_return_status := FND_API.g_ret_sts_success;
901: l_mand_setup_attr := NULL;
902: IF p_setup_attr_rec.attr_mandatory_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)
903: THEN
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 902: IF p_setup_attr_rec.attr_mandatory_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)

898:
899: BEGIN
900: x_return_status := FND_API.g_ret_sts_success;
901: l_mand_setup_attr := NULL;
902: IF p_setup_attr_rec.attr_mandatory_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)
903: THEN
904: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
905: -- Added by cgoyal on 06/Feb/2002 for bugfix 2178381
906: IF l_mand_setup_attr IS NULL THEN

Line 923: x_return_status := FND_API.g_ret_sts_error;

919: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
920: -- End Add by cgoyal
921: FND_MSG_PUB.add;
922: END IF;
923: x_return_status := FND_API.g_ret_sts_error;
924: RETURN;
925: END IF;
926:
927: IF p_setup_attr_rec.attr_available_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)

Line 927: IF p_setup_attr_rec.attr_available_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)

923: x_return_status := FND_API.g_ret_sts_error;
924: RETURN;
925: END IF;
926:
927: IF p_setup_attr_rec.attr_available_flag NOT IN ('Y','N',FND_API.g_miss_char,NULL)
928: THEN
929: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
930: -- Added by cgoyal on 06/Feb/2002 for bugfix 2178381
931: IF l_mand_setup_attr IS NULL THEN

Line 948: x_return_status := FND_API.g_ret_sts_error;

944: -- End Add by cgoyal
945: FND_MSG_PUB.add;
946: END IF;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;
949: RETURN;
950: END IF;
951:
952: -- start of code modified by ptendulk on 29th Dec

Line 988: x_return_status := FND_API.g_ret_sts_error;

984: FND_MESSAGE.set_token('ESS_SETUP_ATTR', l_mand_setup_attr);
985: -- End Add by cgoyal
986: FND_MSG_PUB.add;
987: END IF;
988: x_return_status := FND_API.g_ret_sts_error;
989: RETURN;
990: END IF;
991:
992: IF l_mand_flag = 'Y' THEN

Line 1013: x_return_status := FND_API.g_ret_sts_error;

1009: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1010: -- End Add by cgoyal
1011: FND_MSG_PUB.add;
1012: END IF;
1013: x_return_status := FND_API.g_ret_sts_error;
1014: RETURN;
1015: END IF;
1016: END IF;
1017:

Line 1040: x_return_status := FND_API.g_ret_sts_error;

1036: FND_MESSAGE.set_token('MAND_SETUP_ATTR', l_mand_setup_attr);
1037: -- End Add by cgoyal
1038: FND_MSG_PUB.add;
1039: END IF;
1040: x_return_status := FND_API.g_ret_sts_error;
1041: RETURN;
1042: END IF;
1043:
1044: END check_setup_attr_flag_items;

Line 1078: RAISE FND_API.g_exc_error;

1074: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1075: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1076: FND_MSG_PUB.add;
1077: END IF;
1078: RAISE FND_API.g_exc_error;
1079: END IF;
1080: CLOSE c_setup_attr;
1081:
1082: IF p_setup_attr_rec.display_sequence_no = FND_API.g_miss_num THEN

Line 1082: IF p_setup_attr_rec.display_sequence_no = FND_API.g_miss_num THEN

1078: RAISE FND_API.g_exc_error;
1079: END IF;
1080: CLOSE c_setup_attr;
1081:
1082: IF p_setup_attr_rec.display_sequence_no = FND_API.g_miss_num THEN
1083: x_complete_rec.display_sequence_no := l_setup_attr_rec.display_sequence_no;
1084: END IF;
1085:
1086: IF p_setup_attr_rec.parent_display_sequence = FND_API.g_miss_num THEN

Line 1086: IF p_setup_attr_rec.parent_display_sequence = FND_API.g_miss_num THEN

1082: IF p_setup_attr_rec.display_sequence_no = FND_API.g_miss_num THEN
1083: x_complete_rec.display_sequence_no := l_setup_attr_rec.display_sequence_no;
1084: END IF;
1085:
1086: IF p_setup_attr_rec.parent_display_sequence = FND_API.g_miss_num THEN
1087: x_complete_rec.parent_display_sequence := l_setup_attr_rec.parent_display_sequence;
1088: END IF;
1089: IF p_setup_attr_rec.object_attribute = FND_API.g_miss_char THEN
1090: x_complete_rec.object_attribute := l_setup_attr_rec.object_attribute;

Line 1089: IF p_setup_attr_rec.object_attribute = FND_API.g_miss_char THEN

1085:
1086: IF p_setup_attr_rec.parent_display_sequence = FND_API.g_miss_num THEN
1087: x_complete_rec.parent_display_sequence := l_setup_attr_rec.parent_display_sequence;
1088: END IF;
1089: IF p_setup_attr_rec.object_attribute = FND_API.g_miss_char THEN
1090: x_complete_rec.object_attribute := l_setup_attr_rec.object_attribute;
1091: END IF;
1092:
1093: IF p_setup_attr_rec.attr_mandatory_flag = FND_API.g_miss_char THEN

Line 1093: IF p_setup_attr_rec.attr_mandatory_flag = FND_API.g_miss_char THEN

1089: IF p_setup_attr_rec.object_attribute = FND_API.g_miss_char THEN
1090: x_complete_rec.object_attribute := l_setup_attr_rec.object_attribute;
1091: END IF;
1092:
1093: IF p_setup_attr_rec.attr_mandatory_flag = FND_API.g_miss_char THEN
1094: x_complete_rec.attr_available_flag := l_setup_attr_rec.attr_available_flag;
1095: END IF;
1096:
1097: IF p_setup_attr_rec.attr_available_flag = FND_API.g_miss_char THEN

Line 1097: IF p_setup_attr_rec.attr_available_flag = FND_API.g_miss_char THEN

1093: IF p_setup_attr_rec.attr_mandatory_flag = FND_API.g_miss_char THEN
1094: x_complete_rec.attr_available_flag := l_setup_attr_rec.attr_available_flag;
1095: END IF;
1096:
1097: IF p_setup_attr_rec.attr_available_flag = FND_API.g_miss_char THEN
1098: x_complete_rec.attr_available_flag := l_setup_attr_rec.attr_available_flag;
1099: END IF;
1100:
1101: IF p_setup_attr_rec.show_in_report = FND_API.g_miss_char THEN

Line 1101: IF p_setup_attr_rec.show_in_report = FND_API.g_miss_char THEN

1097: IF p_setup_attr_rec.attr_available_flag = FND_API.g_miss_char THEN
1098: x_complete_rec.attr_available_flag := l_setup_attr_rec.attr_available_flag;
1099: END IF;
1100:
1101: IF p_setup_attr_rec.show_in_report = FND_API.g_miss_char THEN
1102: x_complete_rec.show_in_report := l_setup_attr_rec.show_in_report;
1103: END IF;
1104:
1105: IF p_setup_attr_rec.copy_allowed_flag = FND_API.g_miss_char THEN

Line 1105: IF p_setup_attr_rec.copy_allowed_flag = FND_API.g_miss_char THEN

1101: IF p_setup_attr_rec.show_in_report = FND_API.g_miss_char THEN
1102: x_complete_rec.show_in_report := l_setup_attr_rec.show_in_report;
1103: END IF;
1104:
1105: IF p_setup_attr_rec.copy_allowed_flag = FND_API.g_miss_char THEN
1106: x_complete_rec.copy_allowed_flag := l_setup_attr_rec.copy_allowed_flag;
1107: END IF;
1108:
1109: IF p_setup_attr_rec.parent_setup_attribute= FND_API.g_miss_char THEN

Line 1109: IF p_setup_attr_rec.parent_setup_attribute= FND_API.g_miss_char THEN

1105: IF p_setup_attr_rec.copy_allowed_flag = FND_API.g_miss_char THEN
1106: x_complete_rec.copy_allowed_flag := l_setup_attr_rec.copy_allowed_flag;
1107: END IF;
1108:
1109: IF p_setup_attr_rec.parent_setup_attribute= FND_API.g_miss_char THEN
1110: x_complete_rec.parent_setup_attribute := l_setup_attr_rec.parent_setup_attribute;
1111: END IF;
1112:
1113: IF p_setup_attr_rec.related_ak_attribute = FND_API.g_miss_char THEN

Line 1113: IF p_setup_attr_rec.related_ak_attribute = FND_API.g_miss_char THEN

1109: IF p_setup_attr_rec.parent_setup_attribute= FND_API.g_miss_char THEN
1110: x_complete_rec.parent_setup_attribute := l_setup_attr_rec.parent_setup_attribute;
1111: END IF;
1112:
1113: IF p_setup_attr_rec.related_ak_attribute = FND_API.g_miss_char THEN
1114: x_complete_rec.related_ak_attribute := l_setup_attr_rec.related_ak_attribute;
1115: END IF;
1116:
1117: IF p_setup_attr_rec.parent_function_name = FND_API.g_miss_char THEN

Line 1117: IF p_setup_attr_rec.parent_function_name = FND_API.g_miss_char THEN

1113: IF p_setup_attr_rec.related_ak_attribute = FND_API.g_miss_char THEN
1114: x_complete_rec.related_ak_attribute := l_setup_attr_rec.related_ak_attribute;
1115: END IF;
1116:
1117: IF p_setup_attr_rec.parent_function_name = FND_API.g_miss_char THEN
1118: x_complete_rec.parent_function_name := l_setup_attr_rec.parent_function_name;
1119: END IF;
1120:
1121: IF p_setup_attr_rec.function_name= FND_API.g_miss_char THEN

Line 1121: IF p_setup_attr_rec.function_name= FND_API.g_miss_char THEN

1117: IF p_setup_attr_rec.parent_function_name = FND_API.g_miss_char THEN
1118: x_complete_rec.parent_function_name := l_setup_attr_rec.parent_function_name;
1119: END IF;
1120:
1121: IF p_setup_attr_rec.function_name= FND_API.g_miss_char THEN
1122: x_complete_rec.function_name := l_setup_attr_rec.function_name;
1123: END IF;
1124:
1125: IF p_setup_attr_rec.essential_seq_num = FND_API.g_miss_num THEN

Line 1125: IF p_setup_attr_rec.essential_seq_num = FND_API.g_miss_num THEN

1121: IF p_setup_attr_rec.function_name= FND_API.g_miss_char THEN
1122: x_complete_rec.function_name := l_setup_attr_rec.function_name;
1123: END IF;
1124:
1125: IF p_setup_attr_rec.essential_seq_num = FND_API.g_miss_num THEN
1126: x_complete_rec.essential_seq_num := l_setup_attr_rec.essential_seq_num;
1127: END IF;
1128:
1129: END complete_setup_attr_rec;

Line 1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;

1143: IS
1144:
1145: BEGIN
1146:
1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;
1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;

Line 1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;

1144:
1145: BEGIN
1146:
1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;
1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;

Line 1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;

1145: BEGIN
1146:
1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;
1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;

Line 1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;

1146:
1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;
1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;

Line 1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;

1147: x_setup_attr_rec.setup_attribute_id := FND_API.g_miss_num;
1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;

Line 1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;

1148: x_setup_attr_rec.custom_setup_id := FND_API.g_miss_num;
1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;

Line 1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;

1149: x_setup_attr_rec.last_update_date := FND_API.g_miss_date;
1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;

Line 1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;

1150: x_setup_attr_rec.last_updated_by := FND_API.g_miss_num;
1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;

Line 1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;

1151: x_setup_attr_rec.creation_date := FND_API.g_miss_date;
1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;

Line 1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;

1152: x_setup_attr_rec.created_by := FND_API.g_miss_num;
1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;

Line 1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;

1153: x_setup_attr_rec.last_update_login := FND_API.g_miss_num;
1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;

Line 1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;

1154: x_setup_attr_rec.object_version_number := FND_API.g_miss_num;
1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;

Line 1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;

1155: x_setup_attr_rec.display_sequence_no := FND_API.g_miss_num;
1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;

Line 1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;

1156: x_setup_attr_rec.object_attribute := FND_API.g_miss_char;
1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;

Line 1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;

1157: x_setup_attr_rec.attr_mandatory_flag := FND_API.g_miss_char;
1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;

Line 1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;

1158: x_setup_attr_rec.attr_available_flag := FND_API.g_miss_char;
1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;

Line 1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;

1159: x_setup_attr_rec.function_name := FND_API.g_miss_char;
1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;
1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;

Line 1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;

1160: x_setup_attr_rec.parent_function_name := FND_API.g_miss_char;
1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;
1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;
1168:

Line 1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;

1161: x_setup_attr_rec.parent_setup_attribute := FND_API.g_miss_char;
1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;
1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;
1168:
1169: END init_rec;

Line 1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;

1162: x_setup_attr_rec.parent_display_sequence := FND_API.g_miss_num;
1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;
1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;
1168:
1169: END init_rec;
1170:

Line 1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;

1163: x_setup_attr_rec.show_in_report := FND_API.g_miss_char;
1164: x_setup_attr_rec.show_in_cue_card := FND_API.g_miss_char;
1165: x_setup_attr_rec.copy_allowed_flag := FND_API.g_miss_char;
1166: x_setup_attr_rec.related_ak_attribute := FND_API.g_miss_char;
1167: x_setup_attr_rec.essential_seq_num := FND_API.g_miss_num;
1168:
1169: END init_rec;
1170:
1171: END AMS_Setup_Attr_PVT;