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_LIST_RULES_ALL_PVT dependencies on FND_API

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

15:
16: PROCEDURE create_list_rule
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_list_rule
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_list_rule;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56:

Line 68: IF NOT FND_API.compatible_api_call

64:
65:
66: END IF;
67:
68: IF NOT FND_API.compatible_api_call
69: (
70: l_api_version,
71: p_api_version,
72: l_api_name,

Line 76: RAISE FND_API.g_exc_unexpected_error;

72: l_api_name,
73: g_pkg_name
74: )
75: THEN
76: RAISE FND_API.g_exc_unexpected_error;
77: END IF;
78:
79: x_return_status := FND_API.g_ret_sts_success;
80:

Line 79: x_return_status := FND_API.g_ret_sts_success;

75: THEN
76: RAISE FND_API.g_exc_unexpected_error;
77: END IF;
78:
79: x_return_status := FND_API.g_ret_sts_success;
80:
81: -- validate
82: IF (AMS_DEBUG_HIGH_ON) THEN
83:

Line 97: IF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 98: RAISE FND_API.g_exc_error;

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

Line 99: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 100: RAISE FND_API.g_exc_unexpected_error;

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

Line 164: IF FND_API.to_boolean(p_commit) THEN

160:
161: -- finish
162: x_list_rule_id := l_list_rule_rec.list_rule_id;
163:
164: IF FND_API.to_boolean(p_commit) THEN
165: COMMIT;
166: END IF;
167:
168: FND_MSG_PUB.count_and_get

Line 170: p_encoded => FND_API.g_false,

166: END IF;
167:
168: FND_MSG_PUB.count_and_get
169: (
170: p_encoded => FND_API.g_false,
171: p_count => x_msg_count,
172: p_data => x_msg_data
173: );
174:

Line 185: WHEN FND_API.g_exc_error THEN

181: END IF;
182:
183: EXCEPTION
184:
185: WHEN FND_API.g_exc_error THEN
186: ROLLBACK TO create_list_rule;
187: x_return_status := FND_API.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get
189: (

Line 187: x_return_status := FND_API.g_ret_sts_error;

183: EXCEPTION
184:
185: WHEN FND_API.g_exc_error THEN
186: ROLLBACK TO create_list_rule;
187: x_return_status := FND_API.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get
189: (
190: p_encoded => FND_API.g_false,
191: p_count => x_msg_count,

Line 190: p_encoded => FND_API.g_false,

186: ROLLBACK TO create_list_rule;
187: x_return_status := FND_API.g_ret_sts_error;
188: FND_MSG_PUB.count_and_get
189: (
190: p_encoded => FND_API.g_false,
191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194:

Line 195: WHEN FND_API.g_exc_unexpected_error THEN

191: p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194:
195: WHEN FND_API.g_exc_unexpected_error THEN
196: ROLLBACK TO create_list_rule;
197: x_return_status := FND_API.g_ret_sts_unexp_error;
198: FND_MSG_PUB.count_and_get
199: (

Line 197: x_return_status := FND_API.g_ret_sts_unexp_error;

193: );
194:
195: WHEN FND_API.g_exc_unexpected_error THEN
196: ROLLBACK TO create_list_rule;
197: x_return_status := FND_API.g_ret_sts_unexp_error;
198: FND_MSG_PUB.count_and_get
199: (
200: p_encoded => FND_API.g_false,
201: p_count => x_msg_count,

Line 200: p_encoded => FND_API.g_false,

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

Line 207: x_return_status :=FND_API.g_ret_sts_unexp_error;

203: );
204:
205: WHEN OTHERS THEN
206: ROLLBACK TO create_list_rule;
207: x_return_status :=FND_API.g_ret_sts_unexp_error;
208: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211: FND_MSG_PUB.count_and_get

Line 213: p_encoded => FND_API.g_false,

209: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
210: END IF;
211: FND_MSG_PUB.count_and_get
212: (
213: p_encoded => FND_API.g_false,
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );
217:

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

226: -------------------------------------------------------------------------------
227: PROCEDURE update_list_rule
228: (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: x_return_status OUT NOCOPY VARCHAR2,

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

227: PROCEDURE update_list_rule
228: (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,

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

228: (
229: p_api_version IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
231: p_commit IN VARCHAR2 := FND_API.g_false,
232: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
233:
234: x_return_status OUT NOCOPY VARCHAR2,
235: x_msg_count OUT NOCOPY NUMBER,
236: x_msg_data OUT NOCOPY VARCHAR2,

Line 253: IF FND_API.to_boolean(p_init_msg_list) THEN

249:
250: -- initialize
251: SAVEPOINT update_list_rule;
252:
253: IF FND_API.to_boolean(p_init_msg_list) THEN
254: FND_MSG_PUB.initialize;
255: END IF;
256:
257: IF (AMS_DEBUG_HIGH_ON) THEN

Line 265: IF NOT FND_API.compatible_api_call

261: AMS_Utility_PVT.debug_message(l_full_name || ': start');
262:
263: END IF;
264:
265: IF NOT FND_API.compatible_api_call
266: (
267: l_api_version,
268: p_api_version,
269: l_api_name,

Line 273: RAISE FND_API.g_exc_unexpected_error;

269: l_api_name,
270: g_pkg_name
271: )
272: THEN
273: RAISE FND_API.g_exc_unexpected_error;
274: END IF;
275:
276: x_return_status := FND_API.g_ret_sts_success;
277:

Line 276: x_return_status := FND_API.g_ret_sts_success;

272: THEN
273: RAISE FND_API.g_exc_unexpected_error;
274: END IF;
275:
276: x_return_status := FND_API.g_ret_sts_success;
277:
278: -- validate
279: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
280: IF (AMS_DEBUG_HIGH_ON) THEN

Line 292: IF l_return_status = FND_API.g_ret_sts_error THEN

288: x_return_status => l_return_status,
289: p_list_rule_rec => l_list_rule_rec
290: );
291:
292: IF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;

Line 293: RAISE FND_API.g_exc_error;

289: p_list_rule_rec => l_list_rule_rec
290: );
291:
292: IF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;
297: END IF;

Line 294: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

290: );
291:
292: IF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;
297: END IF;
298:

Line 295: RAISE FND_API.g_exc_unexpected_error;

291:
292: IF l_return_status = FND_API.g_ret_sts_error THEN
293: RAISE FND_API.g_exc_error;
294: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
295: RAISE FND_API.g_exc_unexpected_error;
296: END IF;
297: END IF;
298:
299: -- complete record

Line 319: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

315: p_complete_rec => l_list_rule_rec,
316: x_return_status => l_return_status
317: );
318:
319: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
320: RAISE FND_API.g_exc_unexpected_error;
321: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
322: RAISE FND_API.g_exc_error;
323: END IF;

Line 320: RAISE FND_API.g_exc_unexpected_error;

316: x_return_status => l_return_status
317: );
318:
319: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
320: RAISE FND_API.g_exc_unexpected_error;
321: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
322: RAISE FND_API.g_exc_error;
323: END IF;
324: END IF;

Line 321: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

317: );
318:
319: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
320: RAISE FND_API.g_exc_unexpected_error;
321: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
322: RAISE FND_API.g_exc_error;
323: END IF;
324: END IF;
325:

Line 322: RAISE FND_API.g_exc_error;

318:
319: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
320: RAISE FND_API.g_exc_unexpected_error;
321: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
322: RAISE FND_API.g_exc_error;
323: END IF;
324: END IF;
325:
326: -- update

Line 355: RAISE FND_API.g_exc_error;

351: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
352: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
353: FND_MSG_PUB.add;
354: END IF;
355: RAISE FND_API.g_exc_error;
356: END IF;
357:
358: -- finish
359: IF FND_API.to_boolean(p_commit) THEN

Line 359: IF FND_API.to_boolean(p_commit) THEN

355: RAISE FND_API.g_exc_error;
356: END IF;
357:
358: -- finish
359: IF FND_API.to_boolean(p_commit) THEN
360: COMMIT;
361: END IF;
362:
363: FND_MSG_PUB.count_and_get

Line 365: P_ENCODED => FND_API.g_false,

361: END IF;
362:
363: FND_MSG_PUB.count_and_get
364: (
365: P_ENCODED => FND_API.g_false,
366: p_count => x_msg_count,
367: p_data => x_msg_data
368: );
369:

Line 380: WHEN FND_API.g_exc_error THEN

376: END IF;
377:
378: EXCEPTION
379:
380: WHEN FND_API.g_exc_error THEN
381: ROLLBACK TO update_list_rule;
382: x_return_status := FND_API.g_ret_sts_error;
383: FND_MSG_PUB.count_and_get
384: (

Line 382: x_return_status := FND_API.g_ret_sts_error;

378: EXCEPTION
379:
380: WHEN FND_API.g_exc_error THEN
381: ROLLBACK TO update_list_rule;
382: x_return_status := FND_API.g_ret_sts_error;
383: FND_MSG_PUB.count_and_get
384: (
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,

Line 385: p_encoded => FND_API.g_false,

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

Line 390: WHEN FND_API.g_exc_unexpected_error THEN

386: p_count => x_msg_count,
387: p_data => x_msg_data
388: );
389:
390: WHEN FND_API.g_exc_unexpected_error THEN
391: ROLLBACK TO update_list_rule;
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: FND_MSG_PUB.count_and_get
394: (

Line 392: x_return_status := FND_API.g_ret_sts_unexp_error;

388: );
389:
390: WHEN FND_API.g_exc_unexpected_error THEN
391: ROLLBACK TO update_list_rule;
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: FND_MSG_PUB.count_and_get
394: (
395: p_encoded => FND_API.g_false,
396: p_count => x_msg_count,

Line 395: p_encoded => FND_API.g_false,

391: ROLLBACK TO update_list_rule;
392: x_return_status := FND_API.g_ret_sts_unexp_error;
393: FND_MSG_PUB.count_and_get
394: (
395: p_encoded => FND_API.g_false,
396: p_count => x_msg_count,
397: p_data => x_msg_data
398: );
399:

Line 402: x_return_status :=FND_API.g_ret_sts_unexp_error;

398: );
399:
400: WHEN OTHERS THEN
401: ROLLBACK TO update_list_rule;
402: x_return_status :=FND_API.g_ret_sts_unexp_error;
403: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406: FND_MSG_PUB.count_and_get

Line 408: p_encoded => FND_API.g_false,

404: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
405: END IF;
406: FND_MSG_PUB.count_and_get
407: (
408: p_encoded => FND_API.g_false,
409: p_count => x_msg_count,
410: p_data => x_msg_data
411: );
412:

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

421: -------------------------------------------------------------------------------
422: PROCEDURE delete_list_rule
423: (
424: p_api_version IN NUMBER,
425: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
426: p_commit IN VARCHAR2 := FND_API.g_false,
427:
428: x_return_status OUT NOCOPY VARCHAR2,
429: x_msg_count OUT NOCOPY NUMBER,

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

422: PROCEDURE delete_list_rule
423: (
424: p_api_version IN NUMBER,
425: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
426: p_commit IN VARCHAR2 := FND_API.g_false,
427:
428: x_return_status OUT NOCOPY VARCHAR2,
429: x_msg_count OUT NOCOPY NUMBER,
430: x_msg_data OUT NOCOPY VARCHAR2,

Line 461: IF FND_API.to_boolean(p_init_msg_list) THEN

457: AMS_Utility_PVT.debug_message(l_full_name || ': start');
458:
459: END IF;
460:
461: IF FND_API.to_boolean(p_init_msg_list) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: IF NOT FND_API.compatible_api_call

Line 465: IF NOT FND_API.compatible_api_call

461: IF FND_API.to_boolean(p_init_msg_list) THEN
462: FND_MSG_PUB.initialize;
463: END IF;
464:
465: IF NOT FND_API.compatible_api_call
466: (
467: l_api_version,
468: p_api_version,
469: l_api_name,

Line 473: RAISE FND_API.g_exc_unexpected_error;

469: l_api_name,
470: g_pkg_name
471: )
472: THEN
473: RAISE FND_API.g_exc_unexpected_error;
474: END IF;
475:
476: x_return_status := FND_API.g_ret_sts_success;
477:

Line 476: x_return_status := FND_API.g_ret_sts_success;

472: THEN
473: RAISE FND_API.g_exc_unexpected_error;
474: END IF;
475:
476: x_return_status := FND_API.g_ret_sts_success;
477:
478: -- delete
479: -- IF (AMS_DEBUG_HIGH_ON) THEN AMS_Utility_PVT.debug_message(l_full_name || ': delete'); END IF;
480:

Line 490: RAISE FND_API.g_exc_error;

486: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
487: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_BEING_USED');
488: FND_MSG_PUB.add;
489: END IF;
490: RAISE FND_API.g_exc_error;
491: END IF;
492:
493: DELETE FROM AMS_LIST_RULES_ALL
494: WHERE list_rule_id = p_list_rule_id

Line 502: RAISE FND_API.g_exc_error;

498: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
499: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
500: FND_MSG_PUB.add;
501: END IF;
502: RAISE FND_API.g_exc_error;
503: END IF;
504:
505: -- SOLIN, bug 4377845
506: --Vbhandar added 05/16/2003 to fix bug 3003409

Line 511: IF FND_API.to_boolean(p_commit) THEN

507: DELETE FROM AMS_LIST_RULE_FIELDS
508: WHERE list_rule_id = p_list_rule_id;
509:
510: -- finish
511: IF FND_API.to_boolean(p_commit) THEN
512: COMMIT;
513: END IF;
514:
515: FND_MSG_PUB.count_and_get

Line 517: P_ENCODED => FND_API.g_false,

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

Line 532: WHEN FND_API.g_exc_error THEN

528: END IF;
529:
530: EXCEPTION
531:
532: WHEN FND_API.g_exc_error THEN
533: ROLLBACK TO delete_list_rule;
534: x_return_status := FND_API.g_ret_sts_error;
535: FND_MSG_PUB.count_and_get
536: (

Line 534: x_return_status := FND_API.g_ret_sts_error;

530: EXCEPTION
531:
532: WHEN FND_API.g_exc_error THEN
533: ROLLBACK TO delete_list_rule;
534: x_return_status := FND_API.g_ret_sts_error;
535: FND_MSG_PUB.count_and_get
536: (
537: p_encoded => FND_API.g_false,
538: p_count => x_msg_count,

Line 537: p_encoded => FND_API.g_false,

533: ROLLBACK TO delete_list_rule;
534: x_return_status := FND_API.g_ret_sts_error;
535: FND_MSG_PUB.count_and_get
536: (
537: p_encoded => FND_API.g_false,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541:

Line 542: WHEN FND_API.g_exc_unexpected_error THEN

538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );
541:
542: WHEN FND_API.g_exc_unexpected_error THEN
543: ROLLBACK TO delete_list_rule;
544: x_return_status := FND_API.g_ret_sts_unexp_error;
545: FND_MSG_PUB.count_and_get
546: (

Line 544: x_return_status := FND_API.g_ret_sts_unexp_error;

540: );
541:
542: WHEN FND_API.g_exc_unexpected_error THEN
543: ROLLBACK TO delete_list_rule;
544: x_return_status := FND_API.g_ret_sts_unexp_error;
545: FND_MSG_PUB.count_and_get
546: (
547: p_encoded => FND_API.g_false,
548: p_count => x_msg_count,

Line 547: p_encoded => FND_API.g_false,

543: ROLLBACK TO delete_list_rule;
544: x_return_status := FND_API.g_ret_sts_unexp_error;
545: FND_MSG_PUB.count_and_get
546: (
547: p_encoded => FND_API.g_false,
548: p_count => x_msg_count,
549: p_data => x_msg_data
550: );
551:

Line 554: x_return_status :=FND_API.g_ret_sts_unexp_error;

550: );
551:
552: WHEN OTHERS THEN
553: ROLLBACK TO delete_list_rule;
554: x_return_status :=FND_API.g_ret_sts_unexp_error;
555: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
556: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
557: END IF;
558: FND_MSG_PUB.count_and_get

Line 560: p_encoded => FND_API.g_false,

556: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
557: END IF;
558: FND_MSG_PUB.count_and_get
559: (
560: p_encoded => FND_API.g_false,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );
564:

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

573: -------------------------------------------------------------------------------
574: PROCEDURE lock_list_rule
575: (
576: p_api_version IN NUMBER,
577: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
578:
579: x_return_status OUT NOCOPY VARCHAR2,
580: x_msg_count OUT NOCOPY NUMBER,
581: x_msg_data OUT NOCOPY VARCHAR2,

Line 607: IF FND_API.to_boolean(p_init_msg_list) THEN

603:
604: AMS_Utility_PVT.debug_message(l_full_name || ': start');
605: END IF;
606:
607: IF FND_API.to_boolean(p_init_msg_list) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: IF NOT FND_API.compatible_api_call

Line 611: IF NOT FND_API.compatible_api_call

607: IF FND_API.to_boolean(p_init_msg_list) THEN
608: FND_MSG_PUB.initialize;
609: END IF;
610:
611: IF NOT FND_API.compatible_api_call
612: (
613: l_api_version,
614: p_api_version,
615: l_api_name,

Line 619: RAISE FND_API.g_exc_unexpected_error;

615: l_api_name,
616: g_pkg_name
617: )
618: THEN
619: RAISE FND_API.g_exc_unexpected_error;
620: END IF;
621:
622: x_return_status := FND_API.g_ret_sts_success;
623:

Line 622: x_return_status := FND_API.g_ret_sts_success;

618: THEN
619: RAISE FND_API.g_exc_unexpected_error;
620: END IF;
621:
622: x_return_status := FND_API.g_ret_sts_success;
623:
624: -- lock
625: IF (AMS_DEBUG_HIGH_ON) THEN
626:

Line 638: RAISE FND_API.g_exc_error;

634: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
635: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
636: FND_MSG_PUB.add;
637: END IF;
638: RAISE FND_API.g_exc_error;
639: END IF;
640: CLOSE c_list_rule;
641:
642: -- finish

Line 645: p_encoded => FND_API.g_false,

641:
642: -- finish
643: FND_MSG_PUB.count_and_get
644: (
645: p_encoded => FND_API.g_false,
646: p_count => x_msg_count,
647: p_data => x_msg_data
648: );
649:

Line 661: x_return_status := FND_API.g_ret_sts_error;

657:
658: EXCEPTION
659:
660: WHEN AMS_Utility_PVT.resource_locked THEN
661: x_return_status := FND_API.g_ret_sts_error;
662: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
663: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
664: FND_MSG_PUB.add;
665: END IF;

Line 668: p_encoded => FND_API.g_false,

664: FND_MSG_PUB.add;
665: END IF;
666: FND_MSG_PUB.count_and_get
667: (
668: p_encoded => FND_API.g_false,
669: p_count => x_msg_count,
670: p_data => x_msg_data
671: );
672:

Line 673: WHEN FND_API.g_exc_error THEN

669: p_count => x_msg_count,
670: p_data => x_msg_data
671: );
672:
673: WHEN FND_API.g_exc_error THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: FND_MSG_PUB.count_and_get
676: (
677: p_encoded => FND_API.g_false,

Line 674: x_return_status := FND_API.g_ret_sts_error;

670: p_data => x_msg_data
671: );
672:
673: WHEN FND_API.g_exc_error THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: FND_MSG_PUB.count_and_get
676: (
677: p_encoded => FND_API.g_false,
678: p_count => x_msg_count,

Line 677: p_encoded => FND_API.g_false,

673: WHEN FND_API.g_exc_error THEN
674: x_return_status := FND_API.g_ret_sts_error;
675: FND_MSG_PUB.count_and_get
676: (
677: p_encoded => FND_API.g_false,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:

Line 682: WHEN FND_API.g_exc_unexpected_error THEN

678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );
681:
682: WHEN FND_API.g_exc_unexpected_error THEN
683: x_return_status := FND_API.g_ret_sts_unexp_error;
684: FND_MSG_PUB.count_and_get
685: (
686: p_encoded => FND_API.g_false,

Line 683: x_return_status := FND_API.g_ret_sts_unexp_error;

679: p_data => x_msg_data
680: );
681:
682: WHEN FND_API.g_exc_unexpected_error THEN
683: x_return_status := FND_API.g_ret_sts_unexp_error;
684: FND_MSG_PUB.count_and_get
685: (
686: p_encoded => FND_API.g_false,
687: p_count => x_msg_count,

Line 686: p_encoded => FND_API.g_false,

682: WHEN FND_API.g_exc_unexpected_error THEN
683: x_return_status := FND_API.g_ret_sts_unexp_error;
684: FND_MSG_PUB.count_and_get
685: (
686: p_encoded => FND_API.g_false,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );
690:

Line 692: x_return_status :=FND_API.g_ret_sts_unexp_error;

688: p_data => x_msg_data
689: );
690:
691: WHEN OTHERS THEN
692: x_return_status :=FND_API.g_ret_sts_unexp_error;
693: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
694: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
695: END IF;
696: FND_MSG_PUB.count_and_get

Line 698: p_encoded => FND_API.g_false,

694: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
695: END IF;
696: FND_MSG_PUB.count_and_get
697: (
698: p_encoded => FND_API.g_false,
699: p_count => x_msg_count,
700: p_data => x_msg_data
701: );
702:

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

712: --------------------------------------------------------------------
713: PROCEDURE validate_list_rule
714: (
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
717: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
718:
719: x_return_status OUT NOCOPY VARCHAR2,
720: x_msg_count OUT NOCOPY NUMBER,

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

713: PROCEDURE validate_list_rule
714: (
715: p_api_version IN NUMBER,
716: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
717: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
718:
719: x_return_status OUT NOCOPY VARCHAR2,
720: x_msg_count OUT NOCOPY NUMBER,
721: x_msg_data OUT NOCOPY VARCHAR2,

Line 741: IF NOT FND_API.compatible_api_call

737:
738: AMS_Utility_PVT.debug_message(l_full_name||': start');
739: END IF;
740:
741: IF NOT FND_API.compatible_api_call
742: (
743: l_api_version,
744: p_api_version,
745: l_api_name,

Line 749: RAISE FND_API.g_exc_unexpected_error;

745: l_api_name,
746: g_pkg_name
747: )
748: THEN
749: RAISE FND_API.g_exc_unexpected_error;
750: END IF;
751:
752: x_return_status := FND_API.g_ret_sts_success;
753:

Line 752: x_return_status := FND_API.g_ret_sts_success;

748: THEN
749: RAISE FND_API.g_exc_unexpected_error;
750: END IF;
751:
752: x_return_status := FND_API.g_ret_sts_success;
753:
754: ---------------------- validate ------------------------
755: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
756: IF (AMS_DEBUG_HIGH_ON) THEN

Line 767: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

763: x_return_status => l_return_status,
764: p_list_rule_rec => p_list_rule_rec
765: );
766:
767: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
768: RAISE FND_API.g_exc_unexpected_error;
769: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
770: RAISE FND_API.g_exc_error;
771: END IF;

Line 768: RAISE FND_API.g_exc_unexpected_error;

764: p_list_rule_rec => p_list_rule_rec
765: );
766:
767: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
768: RAISE FND_API.g_exc_unexpected_error;
769: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
770: RAISE FND_API.g_exc_error;
771: END IF;
772: END IF;

Line 769: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

765: );
766:
767: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
768: RAISE FND_API.g_exc_unexpected_error;
769: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
770: RAISE FND_API.g_exc_error;
771: END IF;
772: END IF;
773:

Line 770: RAISE FND_API.g_exc_error;

766:
767: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
768: RAISE FND_API.g_exc_unexpected_error;
769: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
770: RAISE FND_API.g_exc_error;
771: END IF;
772: END IF;
773:
774: -- record level

Line 787: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

783: p_complete_rec => p_list_rule_rec,
784: x_return_status => l_return_status
785: );
786:
787: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
788: RAISE FND_API.g_exc_unexpected_error;
789: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: END IF;

Line 788: RAISE FND_API.g_exc_unexpected_error;

784: x_return_status => l_return_status
785: );
786:
787: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
788: RAISE FND_API.g_exc_unexpected_error;
789: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: END IF;
792: END IF;

Line 789: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

785: );
786:
787: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
788: RAISE FND_API.g_exc_unexpected_error;
789: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: END IF;
792: END IF;
793:

Line 790: RAISE FND_API.g_exc_error;

786:
787: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
788: RAISE FND_API.g_exc_unexpected_error;
789: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
790: RAISE FND_API.g_exc_error;
791: END IF;
792: END IF;
793:
794: -------------------- finish --------------------------

Line 797: p_encoded => FND_API.g_false,

793:
794: -------------------- finish --------------------------
795: FND_MSG_PUB.count_and_get
796: (
797: p_encoded => FND_API.g_false,
798: p_count => x_msg_count,
799: p_data => x_msg_data
800: );
801:

Line 811: WHEN FND_API.g_exc_error THEN

807:
808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.g_exc_error THEN
812: x_return_status := FND_API.g_ret_sts_error;
813: FND_MSG_PUB.count_and_get
814: (
815: p_encoded => FND_API.g_false,

Line 812: x_return_status := FND_API.g_ret_sts_error;

808: END IF;
809:
810: EXCEPTION
811: WHEN FND_API.g_exc_error THEN
812: x_return_status := FND_API.g_ret_sts_error;
813: FND_MSG_PUB.count_and_get
814: (
815: p_encoded => FND_API.g_false,
816: p_count => x_msg_count,

Line 815: p_encoded => FND_API.g_false,

811: WHEN FND_API.g_exc_error THEN
812: x_return_status := FND_API.g_ret_sts_error;
813: FND_MSG_PUB.count_and_get
814: (
815: p_encoded => FND_API.g_false,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819:

Line 820: WHEN FND_API.g_exc_unexpected_error THEN

816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );
819:
820: WHEN FND_API.g_exc_unexpected_error THEN
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822: FND_MSG_PUB.count_and_get
823: (
824: p_encoded => FND_API.g_false,

Line 821: x_return_status := FND_API.g_ret_sts_unexp_error ;

817: p_data => x_msg_data
818: );
819:
820: WHEN FND_API.g_exc_unexpected_error THEN
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822: FND_MSG_PUB.count_and_get
823: (
824: p_encoded => FND_API.g_false,
825: p_count => x_msg_count,

Line 824: p_encoded => FND_API.g_false,

820: WHEN FND_API.g_exc_unexpected_error THEN
821: x_return_status := FND_API.g_ret_sts_unexp_error ;
822: FND_MSG_PUB.count_and_get
823: (
824: p_encoded => FND_API.g_false,
825: p_count => x_msg_count,
826: p_data => x_msg_data
827: );
828:

Line 830: x_return_status := FND_API.g_ret_sts_unexp_error;

826: p_data => x_msg_data
827: );
828:
829: WHEN OTHERS THEN
830: x_return_status := FND_API.g_ret_sts_unexp_error;
831: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
832: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
833: END IF;
834:

Line 837: p_encoded => FND_API.g_false,

833: END IF;
834:
835: FND_MSG_PUB.count_and_get
836: (
837: p_encoded => FND_API.g_false,
838: p_count => x_msg_count,
839: p_data => x_msg_data
840: );
841:

Line 869: x_return_status := FND_API.g_ret_sts_success;

865:
866: AMS_Utility_PVT.debug_message(l_full_name || ': start');
867: END IF;
868:
869: x_return_status := FND_API.g_ret_sts_success;
870:
871: -- check required items
872: IF (AMS_DEBUG_HIGH_ON) THEN
873:

Line 883: IF x_return_status <> FND_API.g_ret_sts_success THEN

879: p_list_rule_rec => p_list_rule_rec,
880: x_return_status => x_return_status
881: );
882:
883: IF x_return_status <> FND_API.g_ret_sts_success THEN
884: RETURN;
885: END IF;
886:
887: -- check unique key items

Line 899: IF x_return_status <> FND_API.g_ret_sts_success THEN

895: p_list_rule_rec => p_list_rule_rec,
896: x_return_status => x_return_status
897: );
898:
899: IF x_return_status <> FND_API.g_ret_sts_success THEN
900: RETURN;
901: END IF;
902:
903: -- check lookup items

Line 914: IF x_return_status <> FND_API.g_ret_sts_success THEN

910: p_list_rule_rec => p_list_rule_rec,
911: x_return_status => x_return_status
912: );
913:
914: IF x_return_status <> FND_API.g_ret_sts_success THEN
915: RETURN;
916: END IF;
917:
918: END check_items;

Line 937: x_return_status := FND_API.g_ret_sts_success;

933: IS
934:
935: BEGIN
936:
937: x_return_status := FND_API.g_ret_sts_success;
938:
939: -- check list_rule_id
940: IF p_list_rule_rec.list_rule_id IS NULL
941: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 947: x_return_status := FND_API.g_ret_sts_error;

943: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
944: FND_MSG_PUB.add;
945: END IF;
946:
947: x_return_status := FND_API.g_ret_sts_error;
948: RETURN;
949: END IF;
950:
951: -- check object_version_number

Line 960: x_return_status := FND_API.g_ret_sts_error;

956: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
957: FND_MSG_PUB.add;
958: END IF;
959:
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;
962: END IF;
963:
964: -- check list_rule_name

Line 971: x_return_status := FND_API.g_ret_sts_error;

967: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_NAME');
968: FND_MSG_PUB.add;
969: END IF;
970:
971: x_return_status := FND_API.g_ret_sts_error;
972: RETURN;
973: END IF;
974:
975: -- check weightage_for_dedupe

Line 983: x_return_status := FND_API.g_ret_sts_error;

979: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_DEDUPE');
980: FND_MSG_PUB.add;
981: END IF;
982:
983: x_return_status := FND_API.g_ret_sts_error;
984: RETURN;
985: END IF;
986:
987: -- check active_from_date

Line 994: x_return_status := FND_API.g_ret_sts_error;

990: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_STRT_DT');
991: FND_MSG_PUB.add;
992: END IF;
993:
994: x_return_status := FND_API.g_ret_sts_error;
995: RETURN;
996: END IF;
997: */
998: END check_req_items;

Line 1019: x_return_status := FND_API.g_ret_sts_success;

1015: l_uk_flag VARCHAR2(1);
1016:
1017: BEGIN
1018:
1019: x_return_status := FND_API.g_ret_sts_success;
1020:
1021: -- check PK, if list_rule_id is passed in, must check if it is duplicate
1022: IF p_validation_mode = JTF_PLSQL_API.g_create
1023: AND p_list_rule_rec.list_rule_id IS NOT NULL

Line 1032: IF l_uk_flag = FND_API.g_false THEN

1028: 'list_rule_id = ' || p_list_rule_rec.list_rule_id
1029: );
1030: END IF;
1031:
1032: IF l_uk_flag = FND_API.g_false THEN
1033: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1034: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
1035: FND_MSG_PUB.add;
1036: END IF;

Line 1038: x_return_status := FND_API.g_ret_sts_error;

1034: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
1035: FND_MSG_PUB.add;
1036: END IF;
1037:
1038: x_return_status := FND_API.g_ret_sts_error;
1039: RETURN;
1040: END IF;
1041:
1042: -- check list_rule_name

Line 1058: IF l_uk_flag = FND_API.g_false THEN

1054: 'list_rule_name = ''' || p_list_rule_rec.list_rule_name || ''''
1055: );
1056: END IF;
1057:
1058: IF l_uk_flag = FND_API.g_false THEN
1059: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1060: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_DUP_NAME');
1061: FND_MSG_PUB.add;
1062: END IF;

Line 1064: x_return_status := FND_API.g_ret_sts_error;

1060: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_DUP_NAME');
1061: FND_MSG_PUB.add;
1062: END IF;
1063:
1064: x_return_status := FND_API.g_ret_sts_error;
1065: RETURN;
1066: END IF;
1067:
1068: END check_uk_items;

Line 1086: x_return_status := FND_API.g_ret_sts_success;

1082: IS
1083:
1084: BEGIN
1085:
1086: x_return_status := FND_API.g_ret_sts_success;
1087:
1088: -- check list_rule_type
1089: IF p_list_rule_rec.list_rule_type <> FND_API.g_miss_char
1090: AND p_list_rule_rec.list_rule_type IS NOT NULL

Line 1089: IF p_list_rule_rec.list_rule_type <> FND_API.g_miss_char

1085:
1086: x_return_status := FND_API.g_ret_sts_success;
1087:
1088: -- check list_rule_type
1089: IF p_list_rule_rec.list_rule_type <> FND_API.g_miss_char
1090: AND p_list_rule_rec.list_rule_type IS NOT NULL
1091: THEN
1092: IF AMS_Utility_PVT.check_lookup_exists(
1093: -- p_lookup_type => 'AMS_LIST_SRC_TYPE',

Line 1096: ) = FND_API.g_false

1092: IF AMS_Utility_PVT.check_lookup_exists(
1093: -- p_lookup_type => 'AMS_LIST_SRC_TYPE',
1094: p_lookup_type => 'AMS_LIST_DEDUP_TYPE',
1095: p_lookup_code => p_list_rule_rec.list_rule_type
1096: ) = FND_API.g_false
1097: THEN
1098: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1099: THEN
1100: FND_MESSAGE.set_name('AMS', 'AMS_LST_RULE_BAD_LST_RULE_TYPE');

Line 1103: x_return_status := FND_API.g_ret_sts_error;

1099: THEN
1100: FND_MESSAGE.set_name('AMS', 'AMS_LST_RULE_BAD_LST_RULE_TYPE');
1101: FND_MSG_PUB.add;
1102: END IF;
1103: x_return_status := FND_API.g_ret_sts_error;
1104: RETURN;
1105: END IF;
1106: END IF;
1107:

Line 1131: x_return_status := FND_API.g_ret_sts_success;

1127: l_to_date DATE;
1128:
1129: BEGIN
1130:
1131: x_return_status := FND_API.g_ret_sts_success;
1132:
1133: -- check that date_effective_from <= date_effective_to
1134: IF p_complete_rec.active_from_date <> FND_API.g_miss_date
1135: AND p_complete_rec.active_from_date IS NOT NULL

Line 1134: IF p_complete_rec.active_from_date <> FND_API.g_miss_date

1130:
1131: x_return_status := FND_API.g_ret_sts_success;
1132:
1133: -- check that date_effective_from <= date_effective_to
1134: IF p_complete_rec.active_from_date <> FND_API.g_miss_date
1135: AND p_complete_rec.active_from_date IS NOT NULL
1136: AND p_complete_rec.active_to_date <> FND_API.g_miss_date
1137: AND p_complete_rec.active_to_date IS NOT NULL
1138: THEN

Line 1136: AND p_complete_rec.active_to_date <> FND_API.g_miss_date

1132:
1133: -- check that date_effective_from <= date_effective_to
1134: IF p_complete_rec.active_from_date <> FND_API.g_miss_date
1135: AND p_complete_rec.active_from_date IS NOT NULL
1136: AND p_complete_rec.active_to_date <> FND_API.g_miss_date
1137: AND p_complete_rec.active_to_date IS NOT NULL
1138: THEN
1139: l_from_date := p_complete_rec.active_from_date;
1140: l_to_date := p_complete_rec.active_to_date;

Line 1147: x_return_status := FND_API.g_ret_sts_error;

1143: FND_MESSAGE.set_name('AMS', 'AMS_DATE_FROM_AFTER_DATE_TO');
1144: FND_MSG_PUB.add;
1145: END IF;
1146:
1147: x_return_status := FND_API.g_ret_sts_error;
1148: RETURN;
1149: END IF;
1150: END IF;
1151:

Line 1186: RAISE FND_API.g_exc_error;

1182: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1183: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1184: FND_MSG_PUB.add;
1185: END IF;
1186: RAISE FND_API.g_exc_error;
1187: END IF;
1188: CLOSE c_list_rule;
1189:
1190: IF p_list_rule_rec.list_rule_name = FND_API.g_miss_char THEN

Line 1190: IF p_list_rule_rec.list_rule_name = FND_API.g_miss_char THEN

1186: RAISE FND_API.g_exc_error;
1187: END IF;
1188: CLOSE c_list_rule;
1189:
1190: IF p_list_rule_rec.list_rule_name = FND_API.g_miss_char THEN
1191: x_complete_rec.list_rule_name := l_list_rule_rec.list_rule_name;
1192: END IF;
1193:
1194: IF p_list_rule_rec.weightage_for_dedupe = FND_API.g_miss_num THEN

Line 1194: IF p_list_rule_rec.weightage_for_dedupe = FND_API.g_miss_num THEN

1190: IF p_list_rule_rec.list_rule_name = FND_API.g_miss_char THEN
1191: x_complete_rec.list_rule_name := l_list_rule_rec.list_rule_name;
1192: END IF;
1193:
1194: IF p_list_rule_rec.weightage_for_dedupe = FND_API.g_miss_num THEN
1195: x_complete_rec.weightage_for_dedupe := l_list_rule_rec.weightage_for_dedupe;
1196: END IF;
1197:
1198: IF p_list_rule_rec.active_from_date = FND_API.g_miss_date THEN

Line 1198: IF p_list_rule_rec.active_from_date = FND_API.g_miss_date THEN

1194: IF p_list_rule_rec.weightage_for_dedupe = FND_API.g_miss_num THEN
1195: x_complete_rec.weightage_for_dedupe := l_list_rule_rec.weightage_for_dedupe;
1196: END IF;
1197:
1198: IF p_list_rule_rec.active_from_date = FND_API.g_miss_date THEN
1199: x_complete_rec.active_from_date := l_list_rule_rec.active_from_date;
1200: END IF;
1201:
1202: IF p_list_rule_rec.active_to_date = FND_API.g_miss_date THEN

Line 1202: IF p_list_rule_rec.active_to_date = FND_API.g_miss_date THEN

1198: IF p_list_rule_rec.active_from_date = FND_API.g_miss_date THEN
1199: x_complete_rec.active_from_date := l_list_rule_rec.active_from_date;
1200: END IF;
1201:
1202: IF p_list_rule_rec.active_to_date = FND_API.g_miss_date THEN
1203: x_complete_rec.active_to_date := l_list_rule_rec.active_to_date;
1204: END IF;
1205:
1206: IF p_list_rule_rec.description = FND_API.g_miss_char THEN

Line 1206: IF p_list_rule_rec.description = FND_API.g_miss_char THEN

1202: IF p_list_rule_rec.active_to_date = FND_API.g_miss_date THEN
1203: x_complete_rec.active_to_date := l_list_rule_rec.active_to_date;
1204: END IF;
1205:
1206: IF p_list_rule_rec.description = FND_API.g_miss_char THEN
1207: x_complete_rec.description := l_list_rule_rec.description;
1208: END IF;
1209:
1210: IF p_list_rule_rec.org_id = FND_API.g_miss_num THEN

Line 1210: IF p_list_rule_rec.org_id = FND_API.g_miss_num THEN

1206: IF p_list_rule_rec.description = FND_API.g_miss_char THEN
1207: x_complete_rec.description := l_list_rule_rec.description;
1208: END IF;
1209:
1210: IF p_list_rule_rec.org_id = FND_API.g_miss_num THEN
1211: x_complete_rec.org_id := l_list_rule_rec.org_id;
1212: END IF;
1213:
1214: IF p_list_rule_rec.list_rule_type = FND_API.g_miss_char THEN

Line 1214: IF p_list_rule_rec.list_rule_type = FND_API.g_miss_char THEN

1210: IF p_list_rule_rec.org_id = FND_API.g_miss_num THEN
1211: x_complete_rec.org_id := l_list_rule_rec.org_id;
1212: END IF;
1213:
1214: IF p_list_rule_rec.list_rule_type = FND_API.g_miss_char THEN
1215: x_complete_rec.list_rule_type := l_list_rule_rec.list_rule_type;
1216: END IF;
1217:
1218: END complete_rec;

Line 1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;

1232: IS
1233:
1234: BEGIN
1235:
1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;
1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;

Line 1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;

1233:
1234: BEGIN
1235:
1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;
1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;

Line 1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;

1234: BEGIN
1235:
1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;
1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;

Line 1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;

1235:
1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;
1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;

Line 1240: x_list_rule_rec.created_by := FND_API.g_miss_num;

1236: x_list_rule_rec.list_rule_id := FND_API.g_miss_num;
1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;

Line 1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;

1237: x_list_rule_rec.last_update_date := FND_API.g_miss_date;
1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;

Line 1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;

1238: x_list_rule_rec.last_updated_by := FND_API.g_miss_num;
1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;

Line 1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;

1239: x_list_rule_rec.creation_date := FND_API.g_miss_date;
1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;

Line 1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;

1240: x_list_rule_rec.created_by := FND_API.g_miss_num;
1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;

Line 1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;

1241: x_list_rule_rec.last_update_login := FND_API.g_miss_num;
1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;
1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;

Line 1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;

1242: x_list_rule_rec.object_version_number := FND_API.g_miss_num;
1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;
1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;
1250:

Line 1247: x_list_rule_rec.description := FND_API.g_miss_char;

1243: x_list_rule_rec.list_rule_name := FND_API.g_miss_char;
1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;
1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;
1250:
1251: END init_rec;

Line 1248: x_list_rule_rec.org_id := FND_API.g_miss_num;

1244: x_list_rule_rec.weightage_for_dedupe := FND_API.g_miss_num;
1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;
1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;
1250:
1251: END init_rec;
1252:

Line 1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;

1245: x_list_rule_rec.active_from_date := FND_API.g_miss_date;
1246: x_list_rule_rec.active_to_date := FND_API.g_miss_date;
1247: x_list_rule_rec.description := FND_API.g_miss_char;
1248: x_list_rule_rec.org_id := FND_API.g_miss_num;
1249: x_list_rule_rec.list_rule_type := FND_API.g_miss_char;
1250:
1251: END init_rec;
1252:
1253: END AMS_List_Rules_All_PVT;