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

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

15:
16: PROCEDURE create_list_rule_field
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_field
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 58: IF FND_API.to_boolean(p_init_msg_list) THEN

54: BEGIN
55: -- initialize
56: SAVEPOINT create_list_rule_field;
57:
58: IF FND_API.to_boolean(p_init_msg_list) THEN
59: FND_MSG_PUB.initialize;
60: END IF;
61:
62:

Line 74: IF NOT FND_API.compatible_api_call

70:
71:
72: END IF;
73:
74: IF NOT FND_API.compatible_api_call
75: (
76: l_api_version,
77: p_api_version,
78: l_api_name,

Line 82: RAISE FND_API.g_exc_unexpected_error;

78: l_api_name,
79: g_pkg_name
80: )
81: THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: x_return_status := FND_API.g_ret_sts_success;
86:

Line 85: x_return_status := FND_API.g_ret_sts_success;

81: THEN
82: RAISE FND_API.g_exc_unexpected_error;
83: END IF;
84:
85: x_return_status := FND_API.g_ret_sts_success;
86:
87: OPEN c_list_rule_count(l_rule_fld_rec.list_rule_id);
88: FETCH c_list_rule_count INTO l_list_rule_count;
89: CLOSE c_list_rule_count;

Line 96: ---RAISE FND_API.g_exc_error;

92: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
93: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
94: FND_MSG_PUB.add;
95: END IF;
96: ---RAISE FND_API.g_exc_error;
97: END IF;
98:
99: -- validate
100: IF (AMS_DEBUG_HIGH_ON) THEN

Line 115: IF l_return_status = FND_API.g_ret_sts_error THEN

111: x_msg_data => x_msg_data,
112: p_rule_fld_rec => l_rule_fld_rec
113: );
114:
115: IF l_return_status = FND_API.g_ret_sts_error THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;

Line 116: RAISE FND_API.g_exc_error;

112: p_rule_fld_rec => l_rule_fld_rec
113: );
114:
115: IF l_return_status = FND_API.g_ret_sts_error THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:

Line 117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

113: );
114:
115: IF l_return_status = FND_API.g_ret_sts_error THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:
121: -- insert

Line 118: RAISE FND_API.g_exc_unexpected_error;

114:
115: IF l_return_status = FND_API.g_ret_sts_error THEN
116: RAISE FND_API.g_exc_error;
117: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
118: RAISE FND_API.g_exc_unexpected_error;
119: END IF;
120:
121: -- insert
122: IF (AMS_DEBUG_HIGH_ON) THEN

Line 179: IF FND_API.to_boolean(p_commit) THEN

175:
176: -- finish
177: x_rule_fld_id := l_rule_fld_rec.list_rule_field_id;
178:
179: IF FND_API.to_boolean(p_commit) THEN
180: COMMIT;
181: END IF;
182:
183: FND_MSG_PUB.count_and_get

Line 185: p_encoded => FND_API.g_false,

181: END IF;
182:
183: FND_MSG_PUB.count_and_get
184: (
185: p_encoded => FND_API.g_false,
186: p_count => x_msg_count,
187: p_data => x_msg_data
188: );
189:

Line 200: WHEN FND_API.g_exc_error THEN

196: END IF;
197:
198: EXCEPTION
199:
200: WHEN FND_API.g_exc_error THEN
201: ROLLBACK TO create_list_rule_field;
202: x_return_status := FND_API.g_ret_sts_error;
203: FND_MSG_PUB.count_and_get
204: (

Line 202: x_return_status := FND_API.g_ret_sts_error;

198: EXCEPTION
199:
200: WHEN FND_API.g_exc_error THEN
201: ROLLBACK TO create_list_rule_field;
202: x_return_status := FND_API.g_ret_sts_error;
203: FND_MSG_PUB.count_and_get
204: (
205: p_encoded => FND_API.g_false,
206: p_count => x_msg_count,

Line 205: p_encoded => FND_API.g_false,

201: ROLLBACK TO create_list_rule_field;
202: x_return_status := FND_API.g_ret_sts_error;
203: FND_MSG_PUB.count_and_get
204: (
205: p_encoded => FND_API.g_false,
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209:

Line 210: WHEN FND_API.g_exc_unexpected_error THEN

206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209:
210: WHEN FND_API.g_exc_unexpected_error THEN
211: ROLLBACK TO create_list_rule_field;
212: x_return_status := FND_API.g_ret_sts_unexp_error;
213: FND_MSG_PUB.count_and_get
214: (

Line 212: x_return_status := FND_API.g_ret_sts_unexp_error;

208: );
209:
210: WHEN FND_API.g_exc_unexpected_error THEN
211: ROLLBACK TO create_list_rule_field;
212: x_return_status := FND_API.g_ret_sts_unexp_error;
213: FND_MSG_PUB.count_and_get
214: (
215: p_encoded => FND_API.g_false,
216: p_count => x_msg_count,

Line 215: p_encoded => FND_API.g_false,

211: ROLLBACK TO create_list_rule_field;
212: x_return_status := FND_API.g_ret_sts_unexp_error;
213: FND_MSG_PUB.count_and_get
214: (
215: p_encoded => FND_API.g_false,
216: p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219:

Line 222: x_return_status :=FND_API.g_ret_sts_unexp_error;

218: );
219:
220: WHEN OTHERS THEN
221: ROLLBACK TO create_list_rule_field;
222: x_return_status :=FND_API.g_ret_sts_unexp_error;
223: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
225: END IF;
226: FND_MSG_PUB.count_and_get

Line 228: p_encoded => FND_API.g_false,

224: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
225: END IF;
226: FND_MSG_PUB.count_and_get
227: (
228: p_encoded => FND_API.g_false,
229: p_count => x_msg_count,
230: p_data => x_msg_data
231: );
232:

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

241: -------------------------------------------------------------------------------
242: PROCEDURE update_list_rule_field
243: (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
246: p_commit IN VARCHAR2 := FND_API.g_false,
247: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
248:
249: x_return_status OUT NOCOPY VARCHAR2,

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

242: PROCEDURE update_list_rule_field
243: (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
246: p_commit IN VARCHAR2 := FND_API.g_false,
247: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
248:
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,

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

243: (
244: p_api_version IN NUMBER,
245: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
246: p_commit IN VARCHAR2 := FND_API.g_false,
247: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
248:
249: x_return_status OUT NOCOPY VARCHAR2,
250: x_msg_count OUT NOCOPY NUMBER,
251: x_msg_data OUT NOCOPY VARCHAR2,

Line 268: IF FND_API.to_boolean(p_init_msg_list) THEN

264:
265: -- initialize
266: SAVEPOINT update_list_rule_field;
267:
268: IF FND_API.to_boolean(p_init_msg_list) THEN
269: FND_MSG_PUB.initialize;
270: END IF;
271:
272: IF (AMS_DEBUG_HIGH_ON) THEN

Line 280: IF NOT FND_API.compatible_api_call

276: AMS_Utility_PVT.debug_message(l_full_name || ': start');
277:
278: END IF;
279:
280: IF NOT FND_API.compatible_api_call
281: (
282: l_api_version,
283: p_api_version,
284: l_api_name,

Line 288: RAISE FND_API.g_exc_unexpected_error;

284: l_api_name,
285: g_pkg_name
286: )
287: THEN
288: RAISE FND_API.g_exc_unexpected_error;
289: END IF;
290:
291: x_return_status := FND_API.g_ret_sts_success;
292:

Line 291: x_return_status := FND_API.g_ret_sts_success;

287: THEN
288: RAISE FND_API.g_exc_unexpected_error;
289: END IF;
290:
291: x_return_status := FND_API.g_ret_sts_success;
292:
293: -- validate
294: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
295: IF (AMS_DEBUG_HIGH_ON) THEN

Line 307: IF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 308: RAISE FND_API.g_exc_error;

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

Line 309: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 310: RAISE FND_API.g_exc_unexpected_error;

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

Line 349: RAISE FND_API.g_exc_error;

345: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
346: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
347: FND_MSG_PUB.add;
348: END IF;
349: RAISE FND_API.g_exc_error;
350: END IF;
351:
352: -- finish
353: IF FND_API.to_boolean(p_commit) THEN

Line 353: IF FND_API.to_boolean(p_commit) THEN

349: RAISE FND_API.g_exc_error;
350: END IF;
351:
352: -- finish
353: IF FND_API.to_boolean(p_commit) THEN
354: COMMIT;
355: END IF;
356:
357: FND_MSG_PUB.count_and_get

Line 359: P_ENCODED => FND_API.g_false,

355: END IF;
356:
357: FND_MSG_PUB.count_and_get
358: (
359: P_ENCODED => FND_API.g_false,
360: p_count => x_msg_count,
361: p_data => x_msg_data
362: );
363:

Line 374: WHEN FND_API.g_exc_error THEN

370: END IF;
371:
372: EXCEPTION
373:
374: WHEN FND_API.g_exc_error THEN
375: ROLLBACK TO update_list_rule_field;
376: x_return_status := FND_API.g_ret_sts_error;
377: FND_MSG_PUB.count_and_get
378: (

Line 376: x_return_status := FND_API.g_ret_sts_error;

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

Line 379: p_encoded => FND_API.g_false,

375: ROLLBACK TO update_list_rule_field;
376: x_return_status := FND_API.g_ret_sts_error;
377: FND_MSG_PUB.count_and_get
378: (
379: p_encoded => FND_API.g_false,
380: p_count => x_msg_count,
381: p_data => x_msg_data
382: );
383:

Line 384: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 386: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 389: p_encoded => FND_API.g_false,

385: ROLLBACK TO update_list_rule_field;
386: x_return_status := FND_API.g_ret_sts_unexp_error;
387: FND_MSG_PUB.count_and_get
388: (
389: p_encoded => FND_API.g_false,
390: p_count => x_msg_count,
391: p_data => x_msg_data
392: );
393:

Line 396: x_return_status :=FND_API.g_ret_sts_unexp_error;

392: );
393:
394: WHEN OTHERS THEN
395: ROLLBACK TO update_list_rule_field;
396: x_return_status :=FND_API.g_ret_sts_unexp_error;
397: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
398: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
399: END IF;
400: FND_MSG_PUB.count_and_get

Line 402: p_encoded => FND_API.g_false,

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

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

415: -------------------------------------------------------------------------------
416: PROCEDURE delete_list_rule_field
417: (
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
420: p_commit IN VARCHAR2 := FND_API.g_false,
421:
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,

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

416: PROCEDURE delete_list_rule_field
417: (
418: p_api_version IN NUMBER,
419: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
420: p_commit IN VARCHAR2 := FND_API.g_false,
421:
422: x_return_status OUT NOCOPY VARCHAR2,
423: x_msg_count OUT NOCOPY NUMBER,
424: 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: OPEN c_list_rule_id(p_rule_fld_id);
479: FETCH c_list_rule_id INTO l_list_rule_id;
480: CLOSE c_list_rule_id;

Line 491: ---RAISE FND_API.g_exc_error;

487: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
488: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_CANNOT_MODIFY');
489: FND_MSG_PUB.add;
490: END IF;
491: ---RAISE FND_API.g_exc_error;
492: END IF;
493:
494: -- delete
495: IF (AMS_DEBUG_HIGH_ON) THEN

Line 509: RAISE FND_API.g_exc_error;

505: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
506: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
507: FND_MSG_PUB.add;
508: END IF;
509: RAISE FND_API.g_exc_error;
510: END IF;
511:
512: -- finish
513: IF FND_API.to_boolean(p_commit) THEN

Line 513: IF FND_API.to_boolean(p_commit) THEN

509: RAISE FND_API.g_exc_error;
510: END IF;
511:
512: -- finish
513: IF FND_API.to_boolean(p_commit) THEN
514: COMMIT;
515: END IF;
516:
517: FND_MSG_PUB.count_and_get

Line 519: P_ENCODED => FND_API.g_false,

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

Line 534: WHEN FND_API.g_exc_error THEN

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

Line 536: x_return_status := FND_API.g_ret_sts_error;

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

Line 539: p_encoded => FND_API.g_false,

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

Line 544: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 546: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 549: p_encoded => FND_API.g_false,

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

Line 556: x_return_status :=FND_API.g_ret_sts_unexp_error;

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

Line 562: p_encoded => FND_API.g_false,

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

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

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

Line 609: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 613: IF NOT FND_API.compatible_api_call

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

Line 621: RAISE FND_API.g_exc_unexpected_error;

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

Line 624: x_return_status := FND_API.g_ret_sts_success;

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

Line 640: RAISE FND_API.g_exc_error;

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

Line 647: p_encoded => FND_API.g_false,

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

Line 663: x_return_status := FND_API.g_ret_sts_error;

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

Line 670: p_encoded => FND_API.g_false,

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

Line 675: WHEN FND_API.g_exc_error THEN

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

Line 676: x_return_status := FND_API.g_ret_sts_error;

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

Line 679: p_encoded => FND_API.g_false,

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

Line 684: WHEN FND_API.g_exc_unexpected_error THEN

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

Line 685: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 688: p_encoded => FND_API.g_false,

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

Line 694: x_return_status :=FND_API.g_ret_sts_unexp_error;

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

Line 700: p_encoded => FND_API.g_false,

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

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

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

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

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

Line 743: IF NOT FND_API.compatible_api_call

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

Line 751: RAISE FND_API.g_exc_unexpected_error;

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

Line 754: x_return_status := FND_API.g_ret_sts_success;

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

Line 769: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 770: RAISE FND_API.g_exc_unexpected_error;

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

Line 771: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 772: RAISE FND_API.g_exc_error;

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

Line 781: p_encoded => FND_API.g_false,

777:
778: -------------------- finish --------------------------
779: FND_MSG_PUB.count_and_get
780: (
781: p_encoded => FND_API.g_false,
782: p_count => x_msg_count,
783: p_data => x_msg_data
784: );
785:

Line 795: WHEN FND_API.g_exc_error THEN

791:
792: END IF;
793:
794: EXCEPTION
795: WHEN FND_API.g_exc_error THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MSG_PUB.count_and_get
798: (
799: p_encoded => FND_API.g_false,

Line 796: x_return_status := FND_API.g_ret_sts_error;

792: END IF;
793:
794: EXCEPTION
795: WHEN FND_API.g_exc_error THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MSG_PUB.count_and_get
798: (
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,

Line 799: p_encoded => FND_API.g_false,

795: WHEN FND_API.g_exc_error THEN
796: x_return_status := FND_API.g_ret_sts_error;
797: FND_MSG_PUB.count_and_get
798: (
799: p_encoded => FND_API.g_false,
800: p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803:

Line 804: WHEN FND_API.g_exc_unexpected_error THEN

800: p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.g_false,

Line 805: x_return_status := FND_API.g_ret_sts_unexp_error ;

801: p_data => x_msg_data
802: );
803:
804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,

Line 808: p_encoded => FND_API.g_false,

804: WHEN FND_API.g_exc_unexpected_error THEN
805: x_return_status := FND_API.g_ret_sts_unexp_error ;
806: FND_MSG_PUB.count_and_get
807: (
808: p_encoded => FND_API.g_false,
809: p_count => x_msg_count,
810: p_data => x_msg_data
811: );
812:

Line 814: x_return_status := FND_API.g_ret_sts_unexp_error;

810: p_data => x_msg_data
811: );
812:
813: WHEN OTHERS THEN
814: x_return_status := FND_API.g_ret_sts_unexp_error;
815: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
816: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
817: END IF;
818:

Line 821: p_encoded => FND_API.g_false,

817: END IF;
818:
819: FND_MSG_PUB.count_and_get
820: (
821: p_encoded => FND_API.g_false,
822: p_count => x_msg_count,
823: p_data => x_msg_data
824: );
825:

Line 853: x_return_status := FND_API.g_ret_sts_success;

849:
850: AMS_Utility_PVT.debug_message(l_full_name || ': start');
851: END IF;
852:
853: x_return_status := FND_API.g_ret_sts_success;
854:
855: -- check required items
856: IF (AMS_DEBUG_HIGH_ON) THEN
857:

Line 867: IF x_return_status <> FND_API.g_ret_sts_success THEN

863: p_rule_fld_rec => p_rule_fld_rec,
864: x_return_status => x_return_status
865: );
866:
867: IF x_return_status <> FND_API.g_ret_sts_success THEN
868: RETURN;
869: END IF;
870:
871: -- check foreign key items

Line 882: IF x_return_status <> FND_API.g_ret_sts_success THEN

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

Line 898: IF x_return_status <> FND_API.g_ret_sts_success THEN

894: p_rule_fld_rec => p_rule_fld_rec,
895: x_return_status => x_return_status
896: );
897:
898: IF x_return_status <> FND_API.g_ret_sts_success THEN
899: RETURN;
900: END IF;
901:
902: END check_items;

Line 921: x_return_status := FND_API.g_ret_sts_success;

917: IS
918:
919: BEGIN
920:
921: x_return_status := FND_API.g_ret_sts_success;
922:
923: -- check list_rule_field_id
924: IF p_rule_fld_rec.list_rule_field_id IS NULL
925: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 931: x_return_status := FND_API.g_ret_sts_error;

927: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
928: FND_MSG_PUB.add;
929: END IF;
930:
931: x_return_status := FND_API.g_ret_sts_error;
932: RETURN;
933: END IF;
934:
935: -- check object_version_number

Line 944: x_return_status := FND_API.g_ret_sts_error;

940: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
941: FND_MSG_PUB.add;
942: END IF;
943:
944: x_return_status := FND_API.g_ret_sts_error;
945: RETURN;
946: END IF;
947:
948: -- check field_table_name

Line 955: x_return_status := FND_API.g_ret_sts_error;

951: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_TBL_NAME');
952: FND_MSG_PUB.add;
953: END IF;
954:
955: x_return_status := FND_API.g_ret_sts_error;
956: RETURN;
957: END IF;
958:
959: -- check field_column_name

Line 966: x_return_status := FND_API.g_ret_sts_error;

962: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_COL_NAME');
963: FND_MSG_PUB.add;
964: END IF;
965:
966: x_return_status := FND_API.g_ret_sts_error;
967: RETURN;
968: END IF;
969:
970: -- check list_rule_id

Line 977: x_return_status := FND_API.g_ret_sts_error;

973: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULES_ALL_NO_ID');
974: FND_MSG_PUB.add;
975: END IF;
976:
977: x_return_status := FND_API.g_ret_sts_error;
978: RETURN;
979: END IF;
980:
981: END check_req_items;

Line 1001: x_return_status := FND_API.g_ret_sts_success;

997: l_fk_flag VARCHAR2(1);
998:
999: BEGIN
1000:
1001: x_return_status := FND_API.g_ret_sts_success;
1002:
1003: -- check field_table_name, field_column_name
1004: l_fk_flag := AMS_Utility_PVT.check_fk_exists
1005: (

Line 1013: IF l_fk_flag = FND_API.g_false THEN

1009: 2, -- varchar2 type
1010: 'field_column_name = ''' || p_rule_fld_rec.field_column_name || ''''
1011: );
1012:
1013: IF l_fk_flag = FND_API.g_false THEN
1014: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1015: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_BAD_TBL_COL');
1016: FND_MSG_PUB.add;
1017: END IF;

Line 1019: x_return_status := FND_API.g_ret_sts_error;

1015: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_BAD_TBL_COL');
1016: FND_MSG_PUB.add;
1017: END IF;
1018:
1019: x_return_status := FND_API.g_ret_sts_error;
1020: RETURN;
1021: END IF;
1022:
1023: -- check list_rule_id

Line 1032: IF l_fk_flag = FND_API.g_false THEN

1028: 'list_rule_id',
1029: p_rule_fld_rec.list_rule_id
1030: );
1031:
1032: IF l_fk_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: END IF;
1042:

Line 1064: x_return_status := FND_API.g_ret_sts_success;

1060: l_uk_flag VARCHAR2(1);
1061:
1062: BEGIN
1063:
1064: x_return_status := FND_API.g_ret_sts_success;
1065:
1066: -- check PK, if list_rule_field_id is passed in, must check if it is duplicate
1067: IF p_validation_mode = JTF_PLSQL_API.g_create
1068: AND p_rule_fld_rec.list_rule_field_id IS NOT NULL

Line 1077: IF l_uk_flag = FND_API.g_false THEN

1073: 'list_rule_field_id = ' || p_rule_fld_rec.list_rule_field_id
1074: );
1075: END IF;
1076:
1077: IF l_uk_flag = FND_API.g_false THEN
1078: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1079: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
1080: FND_MSG_PUB.add;
1081: END IF;

Line 1083: x_return_status := FND_API.g_ret_sts_error;

1079: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_NO_ID');
1080: FND_MSG_PUB.add;
1081: END IF;
1082:
1083: x_return_status := FND_API.g_ret_sts_error;
1084: RETURN;
1085: END IF;
1086:
1087: -- check original_word, replacement_word

Line 1107: IF l_uk_flag = FND_API.g_false THEN

1103: || ''' AND field_column_name = ''' || p_rule_fld_rec.field_column_name || ''''
1104: );
1105: END IF;
1106:
1107: IF l_uk_flag = FND_API.g_false THEN
1108: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1109: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_DUP_RU_TB_CO');
1110: FND_MSG_PUB.add;
1111: END IF;

Line 1113: x_return_status := FND_API.g_ret_sts_error;

1109: FND_MESSAGE.set_name('AMS', 'AMS_LIST_RULE_FLD_DUP_RU_TB_CO');
1110: FND_MSG_PUB.add;
1111: END IF;
1112:
1113: x_return_status := FND_API.g_ret_sts_error;
1114: RETURN;
1115: END IF;
1116:
1117: END check_uk_items;

Line 1151: RAISE FND_API.g_exc_error;

1147: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1148: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1149: FND_MSG_PUB.add;
1150: END IF;
1151: RAISE FND_API.g_exc_error;
1152: END IF;
1153: CLOSE c_list_rule_field;
1154:
1155: IF p_rule_fld_rec.field_table_name = FND_API.g_miss_char THEN

Line 1155: IF p_rule_fld_rec.field_table_name = FND_API.g_miss_char THEN

1151: RAISE FND_API.g_exc_error;
1152: END IF;
1153: CLOSE c_list_rule_field;
1154:
1155: IF p_rule_fld_rec.field_table_name = FND_API.g_miss_char THEN
1156: x_complete_rec.field_table_name := l_rule_fld_rec.field_table_name;
1157: END IF;
1158:
1159: IF p_rule_fld_rec.field_column_name = FND_API.g_miss_char THEN

Line 1159: IF p_rule_fld_rec.field_column_name = FND_API.g_miss_char THEN

1155: IF p_rule_fld_rec.field_table_name = FND_API.g_miss_char THEN
1156: x_complete_rec.field_table_name := l_rule_fld_rec.field_table_name;
1157: END IF;
1158:
1159: IF p_rule_fld_rec.field_column_name = FND_API.g_miss_char THEN
1160: x_complete_rec.field_column_name := l_rule_fld_rec.field_column_name;
1161: END IF;
1162:
1163: IF p_rule_fld_rec.list_rule_id = FND_API.g_miss_num THEN

Line 1163: IF p_rule_fld_rec.list_rule_id = FND_API.g_miss_num THEN

1159: IF p_rule_fld_rec.field_column_name = FND_API.g_miss_char THEN
1160: x_complete_rec.field_column_name := l_rule_fld_rec.field_column_name;
1161: END IF;
1162:
1163: IF p_rule_fld_rec.list_rule_id = FND_API.g_miss_num THEN
1164: x_complete_rec.list_rule_id := l_rule_fld_rec.list_rule_id;
1165: END IF;
1166:
1167: IF p_rule_fld_rec.substring_length = FND_API.g_miss_num THEN

Line 1167: IF p_rule_fld_rec.substring_length = FND_API.g_miss_num THEN

1163: IF p_rule_fld_rec.list_rule_id = FND_API.g_miss_num THEN
1164: x_complete_rec.list_rule_id := l_rule_fld_rec.list_rule_id;
1165: END IF;
1166:
1167: IF p_rule_fld_rec.substring_length = FND_API.g_miss_num THEN
1168: x_complete_rec.substring_length := l_rule_fld_rec.substring_length;
1169: END IF;
1170:
1171: IF p_rule_fld_rec.weightage = FND_API.g_miss_num THEN

Line 1171: IF p_rule_fld_rec.weightage = FND_API.g_miss_num THEN

1167: IF p_rule_fld_rec.substring_length = FND_API.g_miss_num THEN
1168: x_complete_rec.substring_length := l_rule_fld_rec.substring_length;
1169: END IF;
1170:
1171: IF p_rule_fld_rec.weightage = FND_API.g_miss_num THEN
1172: x_complete_rec.weightage := l_rule_fld_rec.weightage;
1173: END IF;
1174:
1175: IF p_rule_fld_rec.sequence_number = FND_API.g_miss_num THEN

Line 1175: IF p_rule_fld_rec.sequence_number = FND_API.g_miss_num THEN

1171: IF p_rule_fld_rec.weightage = FND_API.g_miss_num THEN
1172: x_complete_rec.weightage := l_rule_fld_rec.weightage;
1173: END IF;
1174:
1175: IF p_rule_fld_rec.sequence_number = FND_API.g_miss_num THEN
1176: x_complete_rec.sequence_number := l_rule_fld_rec.sequence_number;
1177: END IF;
1178:
1179: IF p_rule_fld_rec.word_replacement_code = FND_API.g_miss_char THEN

Line 1179: IF p_rule_fld_rec.word_replacement_code = FND_API.g_miss_char THEN

1175: IF p_rule_fld_rec.sequence_number = FND_API.g_miss_num THEN
1176: x_complete_rec.sequence_number := l_rule_fld_rec.sequence_number;
1177: END IF;
1178:
1179: IF p_rule_fld_rec.word_replacement_code = FND_API.g_miss_char THEN
1180: x_complete_rec.word_replacement_code := l_rule_fld_rec.word_replacement_code;
1181: END IF;
1182:
1183:

Line 1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;

1198: IS
1199:
1200: BEGIN
1201:
1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;
1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;

Line 1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;

1199:
1200: BEGIN
1201:
1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;
1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;

Line 1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;

1200: BEGIN
1201:
1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;
1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;

Line 1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;

1201:
1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;
1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;

Line 1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;

1202: x_rule_fld_rec.list_rule_field_id := FND_API.g_miss_num;
1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;

Line 1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;

1203: x_rule_fld_rec.last_update_date := FND_API.g_miss_date;
1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;

Line 1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;

1204: x_rule_fld_rec.last_updated_by := FND_API.g_miss_num;
1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;

Line 1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;

1205: x_rule_fld_rec.creation_date := FND_API.g_miss_date;
1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;

Line 1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;

1206: x_rule_fld_rec.created_by := FND_API.g_miss_num;
1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;

Line 1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;

1207: x_rule_fld_rec.last_update_login := FND_API.g_miss_num;
1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;
1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;

Line 1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;

1208: x_rule_fld_rec.object_version_number := FND_API.g_miss_num;
1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;
1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;
1216:

Line 1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;

1209: x_rule_fld_rec.list_rule_id := FND_API.g_miss_num;
1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;
1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;
1216:
1217: END init_rec;

Line 1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;

1210: x_rule_fld_rec.field_table_name := FND_API.g_miss_char;
1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;
1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;
1216:
1217: END init_rec;
1218:

Line 1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;

1211: x_rule_fld_rec.field_column_name := FND_API.g_miss_char;
1212: x_rule_fld_rec.substring_length := FND_API.g_miss_num;
1213: x_rule_fld_rec.weightage := FND_API.g_miss_num;
1214: x_rule_fld_rec.sequence_number := FND_API.g_miss_num;
1215: x_rule_fld_rec.word_replacement_code := FND_API.g_miss_char;
1216:
1217: END init_rec;
1218:
1219: END AMS_List_Rule_Fields_PVT;