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

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

15:
16: PROCEDURE create_list_word_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_word_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 52: IF FND_API.to_boolean(p_init_msg_list) THEN

48: BEGIN
49: -- initialize
50: SAVEPOINT create_list_word_field;
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_wrd_fld_rec => l_wrd_fld_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_wrd_fld_rec => l_wrd_fld_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 161: IF FND_API.to_boolean(p_commit) THEN

157:
158: -- finish
159: x_wrd_fld_id := l_wrd_fld_rec.list_word_field_id;
160:
161: IF FND_API.to_boolean(p_commit) THEN
162: COMMIT;
163: END IF;
164:
165: FND_MSG_PUB.count_and_get

Line 167: p_encoded => FND_API.g_false,

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

Line 182: WHEN FND_API.g_exc_error THEN

178: END IF;
179:
180: EXCEPTION
181:
182: WHEN FND_API.g_exc_error THEN
183: ROLLBACK TO create_list_word_field;
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MSG_PUB.count_and_get
186: (

Line 184: x_return_status := FND_API.g_ret_sts_error;

180: EXCEPTION
181:
182: WHEN FND_API.g_exc_error THEN
183: ROLLBACK TO create_list_word_field;
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MSG_PUB.count_and_get
186: (
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,

Line 187: p_encoded => FND_API.g_false,

183: ROLLBACK TO create_list_word_field;
184: x_return_status := FND_API.g_ret_sts_error;
185: FND_MSG_PUB.count_and_get
186: (
187: p_encoded => FND_API.g_false,
188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:

Line 192: WHEN FND_API.g_exc_unexpected_error THEN

188: p_count => x_msg_count,
189: p_data => x_msg_data
190: );
191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_list_word_field;
194: x_return_status := FND_API.g_ret_sts_unexp_error;
195: FND_MSG_PUB.count_and_get
196: (

Line 194: x_return_status := FND_API.g_ret_sts_unexp_error;

190: );
191:
192: WHEN FND_API.g_exc_unexpected_error THEN
193: ROLLBACK TO create_list_word_field;
194: x_return_status := FND_API.g_ret_sts_unexp_error;
195: FND_MSG_PUB.count_and_get
196: (
197: p_encoded => FND_API.g_false,
198: p_count => x_msg_count,

Line 197: p_encoded => FND_API.g_false,

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

Line 204: x_return_status :=FND_API.g_ret_sts_unexp_error;

200: );
201:
202: WHEN OTHERS THEN
203: ROLLBACK TO create_list_word_field;
204: x_return_status :=FND_API.g_ret_sts_unexp_error;
205: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
206: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
207: END IF;
208: FND_MSG_PUB.count_and_get

Line 210: p_encoded => FND_API.g_false,

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

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

223: -------------------------------------------------------------------------------
224: PROCEDURE update_list_word_field
225: (
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
228: p_commit IN VARCHAR2 := FND_API.g_false,
229: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
230:
231: x_return_status OUT NOCOPY VARCHAR2,

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

224: PROCEDURE update_list_word_field
225: (
226: p_api_version IN NUMBER,
227: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
228: p_commit IN VARCHAR2 := FND_API.g_false,
229: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
230:
231: x_return_status OUT NOCOPY VARCHAR2,
232: x_msg_count OUT NOCOPY NUMBER,

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

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

Line 250: IF FND_API.to_boolean(p_init_msg_list) THEN

246:
247: -- initialize
248: SAVEPOINT update_list_word_field;
249:
250: IF FND_API.to_boolean(p_init_msg_list) THEN
251: FND_MSG_PUB.initialize;
252: END IF;
253:
254: IF (AMS_DEBUG_HIGH_ON) THEN

Line 262: IF NOT FND_API.compatible_api_call

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

Line 270: RAISE FND_API.g_exc_unexpected_error;

266: l_api_name,
267: g_pkg_name
268: )
269: THEN
270: RAISE FND_API.g_exc_unexpected_error;
271: END IF;
272:
273: x_return_status := FND_API.g_ret_sts_success;
274:

Line 273: x_return_status := FND_API.g_ret_sts_success;

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

Line 289: IF l_return_status = FND_API.g_ret_sts_error THEN

285: x_return_status => l_return_status,
286: p_wrd_fld_rec => l_wrd_fld_rec
287: );
288:
289: IF l_return_status = FND_API.g_ret_sts_error THEN
290: RAISE FND_API.g_exc_error;
291: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
292: RAISE FND_API.g_exc_unexpected_error;
293: END IF;

Line 290: RAISE FND_API.g_exc_error;

286: p_wrd_fld_rec => l_wrd_fld_rec
287: );
288:
289: IF l_return_status = FND_API.g_ret_sts_error THEN
290: RAISE FND_API.g_exc_error;
291: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
292: RAISE FND_API.g_exc_unexpected_error;
293: END IF;
294: END IF;

Line 291: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

287: );
288:
289: IF l_return_status = FND_API.g_ret_sts_error THEN
290: RAISE FND_API.g_exc_error;
291: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
292: RAISE FND_API.g_exc_unexpected_error;
293: END IF;
294: END IF;
295:

Line 292: RAISE FND_API.g_exc_unexpected_error;

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

Line 331: RAISE FND_API.g_exc_error;

327: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
328: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
329: FND_MSG_PUB.add;
330: END IF;
331: RAISE FND_API.g_exc_error;
332: END IF;
333:
334: -- finish
335: IF FND_API.to_boolean(p_commit) THEN

Line 335: IF FND_API.to_boolean(p_commit) THEN

331: RAISE FND_API.g_exc_error;
332: END IF;
333:
334: -- finish
335: IF FND_API.to_boolean(p_commit) THEN
336: COMMIT;
337: END IF;
338:
339: FND_MSG_PUB.count_and_get

Line 341: P_ENCODED => FND_API.g_false,

337: END IF;
338:
339: FND_MSG_PUB.count_and_get
340: (
341: P_ENCODED => FND_API.g_false,
342: p_count => x_msg_count,
343: p_data => x_msg_data
344: );
345:

Line 356: WHEN FND_API.g_exc_error THEN

352: END IF;
353:
354: EXCEPTION
355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_list_word_field;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get
360: (

Line 358: x_return_status := FND_API.g_ret_sts_error;

354: EXCEPTION
355:
356: WHEN FND_API.g_exc_error THEN
357: ROLLBACK TO update_list_word_field;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get
360: (
361: p_encoded => FND_API.g_false,
362: p_count => x_msg_count,

Line 361: p_encoded => FND_API.g_false,

357: ROLLBACK TO update_list_word_field;
358: x_return_status := FND_API.g_ret_sts_error;
359: FND_MSG_PUB.count_and_get
360: (
361: p_encoded => FND_API.g_false,
362: p_count => x_msg_count,
363: p_data => x_msg_data
364: );
365:

Line 366: WHEN FND_API.g_exc_unexpected_error THEN

362: p_count => x_msg_count,
363: p_data => x_msg_data
364: );
365:
366: WHEN FND_API.g_exc_unexpected_error THEN
367: ROLLBACK TO update_list_word_field;
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get
370: (

Line 368: x_return_status := FND_API.g_ret_sts_unexp_error;

364: );
365:
366: WHEN FND_API.g_exc_unexpected_error THEN
367: ROLLBACK TO update_list_word_field;
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get
370: (
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,

Line 371: p_encoded => FND_API.g_false,

367: ROLLBACK TO update_list_word_field;
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: FND_MSG_PUB.count_and_get
370: (
371: p_encoded => FND_API.g_false,
372: p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375:

Line 378: x_return_status :=FND_API.g_ret_sts_unexp_error;

374: );
375:
376: WHEN OTHERS THEN
377: ROLLBACK TO update_list_word_field;
378: x_return_status :=FND_API.g_ret_sts_unexp_error;
379: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382: FND_MSG_PUB.count_and_get

Line 384: p_encoded => FND_API.g_false,

380: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
381: END IF;
382: FND_MSG_PUB.count_and_get
383: (
384: p_encoded => FND_API.g_false,
385: p_count => x_msg_count,
386: p_data => x_msg_data
387: );
388:

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

397: -------------------------------------------------------------------------------
398: PROCEDURE delete_list_word_field
399: (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
402: p_commit IN VARCHAR2 := FND_API.g_false,
403:
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,

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

398: PROCEDURE delete_list_word_field
399: (
400: p_api_version IN NUMBER,
401: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
402: p_commit IN VARCHAR2 := FND_API.g_false,
403:
404: x_return_status OUT NOCOPY VARCHAR2,
405: x_msg_count OUT NOCOPY NUMBER,
406: x_msg_data OUT NOCOPY VARCHAR2,

Line 429: IF FND_API.to_boolean(p_init_msg_list) THEN

425: AMS_Utility_PVT.debug_message(l_full_name || ': start');
426:
427: END IF;
428:
429: IF FND_API.to_boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;
432:
433: IF NOT FND_API.compatible_api_call

Line 433: IF NOT FND_API.compatible_api_call

429: IF FND_API.to_boolean(p_init_msg_list) THEN
430: FND_MSG_PUB.initialize;
431: END IF;
432:
433: IF NOT FND_API.compatible_api_call
434: (
435: l_api_version,
436: p_api_version,
437: l_api_name,

Line 441: RAISE FND_API.g_exc_unexpected_error;

437: l_api_name,
438: g_pkg_name
439: )
440: THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: x_return_status := FND_API.g_ret_sts_success;
445:

Line 444: x_return_status := FND_API.g_ret_sts_success;

440: THEN
441: RAISE FND_API.g_exc_unexpected_error;
442: END IF;
443:
444: x_return_status := FND_API.g_ret_sts_success;
445:
446: -- delete
447: IF (AMS_DEBUG_HIGH_ON) THEN
448:

Line 461: RAISE FND_API.g_exc_error;

457: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
458: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
459: FND_MSG_PUB.add;
460: END IF;
461: RAISE FND_API.g_exc_error;
462: END IF;
463:
464: -- finish
465: IF FND_API.to_boolean(p_commit) THEN

Line 465: IF FND_API.to_boolean(p_commit) THEN

461: RAISE FND_API.g_exc_error;
462: END IF;
463:
464: -- finish
465: IF FND_API.to_boolean(p_commit) THEN
466: COMMIT;
467: END IF;
468:
469: FND_MSG_PUB.count_and_get

Line 471: P_ENCODED => FND_API.g_false,

467: END IF;
468:
469: FND_MSG_PUB.count_and_get
470: (
471: P_ENCODED => FND_API.g_false,
472: p_count => x_msg_count,
473: p_data => x_msg_data
474: );
475:

Line 486: WHEN FND_API.g_exc_error THEN

482: END IF;
483:
484: EXCEPTION
485:
486: WHEN FND_API.g_exc_error THEN
487: ROLLBACK TO delete_list_word_field;
488: x_return_status := FND_API.g_ret_sts_error;
489: FND_MSG_PUB.count_and_get
490: (

Line 488: x_return_status := FND_API.g_ret_sts_error;

484: EXCEPTION
485:
486: WHEN FND_API.g_exc_error THEN
487: ROLLBACK TO delete_list_word_field;
488: x_return_status := FND_API.g_ret_sts_error;
489: FND_MSG_PUB.count_and_get
490: (
491: p_encoded => FND_API.g_false,
492: p_count => x_msg_count,

Line 491: p_encoded => FND_API.g_false,

487: ROLLBACK TO delete_list_word_field;
488: x_return_status := FND_API.g_ret_sts_error;
489: FND_MSG_PUB.count_and_get
490: (
491: p_encoded => FND_API.g_false,
492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495:

Line 496: WHEN FND_API.g_exc_unexpected_error THEN

492: p_count => x_msg_count,
493: p_data => x_msg_data
494: );
495:
496: WHEN FND_API.g_exc_unexpected_error THEN
497: ROLLBACK TO delete_list_word_field;
498: x_return_status := FND_API.g_ret_sts_unexp_error;
499: FND_MSG_PUB.count_and_get
500: (

Line 498: x_return_status := FND_API.g_ret_sts_unexp_error;

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

Line 501: p_encoded => FND_API.g_false,

497: ROLLBACK TO delete_list_word_field;
498: x_return_status := FND_API.g_ret_sts_unexp_error;
499: FND_MSG_PUB.count_and_get
500: (
501: p_encoded => FND_API.g_false,
502: p_count => x_msg_count,
503: p_data => x_msg_data
504: );
505:

Line 508: x_return_status :=FND_API.g_ret_sts_unexp_error;

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

Line 514: p_encoded => FND_API.g_false,

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

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

527: -------------------------------------------------------------------------------
528: PROCEDURE lock_list_word_field
529: (
530: p_api_version IN NUMBER,
531: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
532:
533: x_return_status OUT NOCOPY VARCHAR2,
534: x_msg_count OUT NOCOPY NUMBER,
535: x_msg_data OUT NOCOPY VARCHAR2,

Line 561: IF FND_API.to_boolean(p_init_msg_list) THEN

557:
558: AMS_Utility_PVT.debug_message(l_full_name || ': start');
559: END IF;
560:
561: IF FND_API.to_boolean(p_init_msg_list) THEN
562: FND_MSG_PUB.initialize;
563: END IF;
564:
565: IF NOT FND_API.compatible_api_call

Line 565: IF NOT FND_API.compatible_api_call

561: IF FND_API.to_boolean(p_init_msg_list) THEN
562: FND_MSG_PUB.initialize;
563: END IF;
564:
565: IF NOT FND_API.compatible_api_call
566: (
567: l_api_version,
568: p_api_version,
569: l_api_name,

Line 573: RAISE FND_API.g_exc_unexpected_error;

569: l_api_name,
570: g_pkg_name
571: )
572: THEN
573: RAISE FND_API.g_exc_unexpected_error;
574: END IF;
575:
576: x_return_status := FND_API.g_ret_sts_success;
577:

Line 576: x_return_status := FND_API.g_ret_sts_success;

572: THEN
573: RAISE FND_API.g_exc_unexpected_error;
574: END IF;
575:
576: x_return_status := FND_API.g_ret_sts_success;
577:
578: -- lock
579: IF (AMS_DEBUG_HIGH_ON) THEN
580:

Line 592: RAISE FND_API.g_exc_error;

588: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
589: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
590: FND_MSG_PUB.add;
591: END IF;
592: RAISE FND_API.g_exc_error;
593: END IF;
594: CLOSE c_list_word_field;
595:
596: -- finish

Line 599: p_encoded => FND_API.g_false,

595:
596: -- finish
597: FND_MSG_PUB.count_and_get
598: (
599: p_encoded => FND_API.g_false,
600: p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:

Line 615: x_return_status := FND_API.g_ret_sts_error;

611:
612: EXCEPTION
613:
614: WHEN AMS_Utility_PVT.resource_locked THEN
615: x_return_status := FND_API.g_ret_sts_error;
616: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
617: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
618: FND_MSG_PUB.add;
619: END IF;

Line 622: p_encoded => FND_API.g_false,

618: FND_MSG_PUB.add;
619: END IF;
620: FND_MSG_PUB.count_and_get
621: (
622: p_encoded => FND_API.g_false,
623: p_count => x_msg_count,
624: p_data => x_msg_data
625: );
626:

Line 627: WHEN FND_API.g_exc_error THEN

623: p_count => x_msg_count,
624: p_data => x_msg_data
625: );
626:
627: WHEN FND_API.g_exc_error THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: FND_MSG_PUB.count_and_get
630: (
631: p_encoded => FND_API.g_false,

Line 628: x_return_status := FND_API.g_ret_sts_error;

624: p_data => x_msg_data
625: );
626:
627: WHEN FND_API.g_exc_error THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: FND_MSG_PUB.count_and_get
630: (
631: p_encoded => FND_API.g_false,
632: p_count => x_msg_count,

Line 631: p_encoded => FND_API.g_false,

627: WHEN FND_API.g_exc_error THEN
628: x_return_status := FND_API.g_ret_sts_error;
629: FND_MSG_PUB.count_and_get
630: (
631: p_encoded => FND_API.g_false,
632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:

Line 636: WHEN FND_API.g_exc_unexpected_error THEN

632: p_count => x_msg_count,
633: p_data => x_msg_data
634: );
635:
636: WHEN FND_API.g_exc_unexpected_error THEN
637: x_return_status := FND_API.g_ret_sts_unexp_error;
638: FND_MSG_PUB.count_and_get
639: (
640: p_encoded => FND_API.g_false,

Line 637: x_return_status := FND_API.g_ret_sts_unexp_error;

633: p_data => x_msg_data
634: );
635:
636: WHEN FND_API.g_exc_unexpected_error THEN
637: x_return_status := FND_API.g_ret_sts_unexp_error;
638: FND_MSG_PUB.count_and_get
639: (
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,

Line 640: p_encoded => FND_API.g_false,

636: WHEN FND_API.g_exc_unexpected_error THEN
637: x_return_status := FND_API.g_ret_sts_unexp_error;
638: FND_MSG_PUB.count_and_get
639: (
640: p_encoded => FND_API.g_false,
641: p_count => x_msg_count,
642: p_data => x_msg_data
643: );
644:

Line 646: x_return_status :=FND_API.g_ret_sts_unexp_error;

642: p_data => x_msg_data
643: );
644:
645: WHEN OTHERS THEN
646: x_return_status :=FND_API.g_ret_sts_unexp_error;
647: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
648: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
649: END IF;
650: FND_MSG_PUB.count_and_get

Line 652: p_encoded => FND_API.g_false,

648: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
649: END IF;
650: FND_MSG_PUB.count_and_get
651: (
652: p_encoded => FND_API.g_false,
653: p_count => x_msg_count,
654: p_data => x_msg_data
655: );
656:

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

666: --------------------------------------------------------------------
667: PROCEDURE validate_list_word_field
668: (
669: p_api_version IN NUMBER,
670: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
671: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
672:
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,

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

667: PROCEDURE validate_list_word_field
668: (
669: p_api_version IN NUMBER,
670: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
671: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
672:
673: x_return_status OUT NOCOPY VARCHAR2,
674: x_msg_count OUT NOCOPY NUMBER,
675: x_msg_data OUT NOCOPY VARCHAR2,

Line 695: IF NOT FND_API.compatible_api_call

691:
692: AMS_Utility_PVT.debug_message(l_full_name||': start');
693: END IF;
694:
695: IF NOT FND_API.compatible_api_call
696: (
697: l_api_version,
698: p_api_version,
699: l_api_name,

Line 703: RAISE FND_API.g_exc_unexpected_error;

699: l_api_name,
700: g_pkg_name
701: )
702: THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;
705:
706: x_return_status := FND_API.g_ret_sts_success;
707:

Line 706: x_return_status := FND_API.g_ret_sts_success;

702: THEN
703: RAISE FND_API.g_exc_unexpected_error;
704: END IF;
705:
706: x_return_status := FND_API.g_ret_sts_success;
707:
708: ---------------------- validate ------------------------
709: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
710: IF (AMS_DEBUG_HIGH_ON) THEN

Line 721: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

717: x_return_status => l_return_status,
718: p_wrd_fld_rec => p_wrd_fld_rec
719: );
720:
721: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
722: RAISE FND_API.g_exc_unexpected_error;
723: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
724: RAISE FND_API.g_exc_error;
725: END IF;

Line 722: RAISE FND_API.g_exc_unexpected_error;

718: p_wrd_fld_rec => p_wrd_fld_rec
719: );
720:
721: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
722: RAISE FND_API.g_exc_unexpected_error;
723: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
724: RAISE FND_API.g_exc_error;
725: END IF;
726: END IF;

Line 723: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

719: );
720:
721: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
722: RAISE FND_API.g_exc_unexpected_error;
723: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
724: RAISE FND_API.g_exc_error;
725: END IF;
726: END IF;
727:

Line 724: RAISE FND_API.g_exc_error;

720:
721: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
722: RAISE FND_API.g_exc_unexpected_error;
723: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
724: RAISE FND_API.g_exc_error;
725: END IF;
726: END IF;
727:
728: -- record level

Line 733: p_encoded => FND_API.g_false,

729:
730: -------------------- finish --------------------------
731: FND_MSG_PUB.count_and_get
732: (
733: p_encoded => FND_API.g_false,
734: p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737:

Line 747: WHEN FND_API.g_exc_error THEN

743:
744: END IF;
745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,

Line 748: x_return_status := FND_API.g_ret_sts_error;

744: END IF;
745:
746: EXCEPTION
747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,
752: p_count => x_msg_count,

Line 751: p_encoded => FND_API.g_false,

747: WHEN FND_API.g_exc_error THEN
748: x_return_status := FND_API.g_ret_sts_error;
749: FND_MSG_PUB.count_and_get
750: (
751: p_encoded => FND_API.g_false,
752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:

Line 756: WHEN FND_API.g_exc_unexpected_error THEN

752: p_count => x_msg_count,
753: p_data => x_msg_data
754: );
755:
756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,

Line 757: x_return_status := FND_API.g_ret_sts_unexp_error ;

753: p_data => x_msg_data
754: );
755:
756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,
761: p_count => x_msg_count,

Line 760: p_encoded => FND_API.g_false,

756: WHEN FND_API.g_exc_unexpected_error THEN
757: x_return_status := FND_API.g_ret_sts_unexp_error ;
758: FND_MSG_PUB.count_and_get
759: (
760: p_encoded => FND_API.g_false,
761: p_count => x_msg_count,
762: p_data => x_msg_data
763: );
764:

Line 766: x_return_status := FND_API.g_ret_sts_unexp_error;

762: p_data => x_msg_data
763: );
764:
765: WHEN OTHERS THEN
766: x_return_status := FND_API.g_ret_sts_unexp_error;
767: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
768: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
769: END IF;
770:

Line 773: p_encoded => FND_API.g_false,

769: END IF;
770:
771: FND_MSG_PUB.count_and_get
772: (
773: p_encoded => FND_API.g_false,
774: p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777:

Line 805: x_return_status := FND_API.g_ret_sts_success;

801:
802: AMS_Utility_PVT.debug_message(l_full_name || ': start');
803: END IF;
804:
805: x_return_status := FND_API.g_ret_sts_success;
806:
807: -- check required items
808: IF (AMS_DEBUG_HIGH_ON) THEN
809:

Line 819: IF x_return_status <> FND_API.g_ret_sts_success THEN

815: p_wrd_fld_rec => p_wrd_fld_rec,
816: x_return_status => x_return_status
817: );
818:
819: IF x_return_status <> FND_API.g_ret_sts_success THEN
820: RETURN;
821: END IF;
822:
823: -- check foreign key items

Line 834: IF x_return_status <> FND_API.g_ret_sts_success THEN

830: p_wrd_fld_rec => p_wrd_fld_rec,
831: x_return_status => x_return_status
832: );
833:
834: IF x_return_status <> FND_API.g_ret_sts_success THEN
835: RETURN;
836: END IF;
837:
838: -- check unique key items

Line 850: IF x_return_status <> FND_API.g_ret_sts_success THEN

846: p_wrd_fld_rec => p_wrd_fld_rec,
847: x_return_status => x_return_status
848: );
849:
850: IF x_return_status <> FND_API.g_ret_sts_success THEN
851: RETURN;
852: END IF;
853:
854: END check_items;

Line 873: x_return_status := FND_API.g_ret_sts_success;

869: IS
870:
871: BEGIN
872:
873: x_return_status := FND_API.g_ret_sts_success;
874:
875: -- check list_word_field_id
876: IF p_wrd_fld_rec.list_word_field_id IS NULL
877: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 883: x_return_status := FND_API.g_ret_sts_error;

879: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
880: FND_MSG_PUB.add;
881: END IF;
882:
883: x_return_status := FND_API.g_ret_sts_error;
884: RETURN;
885: END IF;
886:
887: -- check object_version_number

Line 896: x_return_status := FND_API.g_ret_sts_error;

892: FND_MESSAGE.set_name('AMS', 'AMS_NO_OBJ_VER_NUM');
893: FND_MSG_PUB.add;
894: END IF;
895:
896: x_return_status := FND_API.g_ret_sts_error;
897: RETURN;
898: END IF;
899:
900: -- check field_table_name

Line 907: x_return_status := FND_API.g_ret_sts_error;

903: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_TBL_NAME');
904: FND_MSG_PUB.add;
905: END IF;
906:
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
909: END IF;
910:
911: -- check field_column_name

Line 918: x_return_status := FND_API.g_ret_sts_error;

914: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_COL_NAME');
915: FND_MSG_PUB.add;
916: END IF;
917:
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
920: END IF;
921:
922: -- check list_word_replaces_id

Line 929: x_return_status := FND_API.g_ret_sts_error;

925: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_ID');
926: FND_MSG_PUB.add;
927: END IF;
928:
929: x_return_status := FND_API.g_ret_sts_error;
930: RETURN;
931: END IF;
932:
933: -- check original_word

Line 940: x_return_status := FND_API.g_ret_sts_error;

936: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ORG_WRD');
937: FND_MSG_PUB.add;
938: END IF;
939:
940: x_return_status := FND_API.g_ret_sts_error;
941: RETURN;
942: END IF;
943:
944: -- check replacement_word

Line 951: x_return_status := FND_API.g_ret_sts_error;

947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_RPL_WRD');
948: FND_MSG_PUB.add;
949: END IF;
950:
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;
953: END IF;
954:
955: -- check enabled_flag

Line 962: x_return_status := FND_API.g_ret_sts_error;

958: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
959: FND_MSG_PUB.add;
960: END IF;
961:
962: x_return_status := FND_API.g_ret_sts_error;
963: RETURN;
964: END IF;
965:
966: IF p_wrd_fld_rec.enabled_flag <> 'Y'

Line 968: AND p_wrd_fld_rec.enabled_flag <> FND_API.g_miss_char

964: END IF;
965:
966: IF p_wrd_fld_rec.enabled_flag <> 'Y'
967: AND p_wrd_fld_rec.enabled_flag <> 'N'
968: AND p_wrd_fld_rec.enabled_flag <> FND_API.g_miss_char
969: THEN
970: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
971: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
972: FND_MSG_PUB.add;

Line 975: x_return_status := FND_API.g_ret_sts_error;

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

Line 999: x_return_status := FND_API.g_ret_sts_success;

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

Line 1011: IF l_fk_flag = FND_API.g_false THEN

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

Line 1017: x_return_status := FND_API.g_ret_sts_error;

1013: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_TBL_COL');
1014: FND_MSG_PUB.add;
1015: END IF;
1016:
1017: x_return_status := FND_API.g_ret_sts_error;
1018: RETURN;
1019: END IF;
1020:
1021: -- check list_word_replaces_id

Line 1030: IF l_fk_flag = FND_API.g_false THEN

1026: 'list_word_replaces_id',
1027: p_wrd_fld_rec.list_word_replaces_id
1028: );
1029:
1030: IF l_fk_flag = FND_API.g_false THEN
1031: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');
1033: FND_MSG_PUB.add;
1034: END IF;

Line 1036: x_return_status := FND_API.g_ret_sts_error;

1032: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_BAD_RPL_ID');
1033: FND_MSG_PUB.add;
1034: END IF;
1035:
1036: x_return_status := FND_API.g_ret_sts_error;
1037: RETURN;
1038: END IF;
1039: END IF;
1040:

Line 1062: x_return_status := FND_API.g_ret_sts_success;

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

Line 1075: IF l_uk_flag = FND_API.g_false THEN

1071: 'list_word_field_id = ' || p_wrd_fld_rec.list_word_field_id
1072: );
1073: END IF;
1074:
1075: IF l_uk_flag = FND_API.g_false THEN
1076: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
1078: FND_MSG_PUB.add;
1079: END IF;

Line 1081: x_return_status := FND_API.g_ret_sts_error;

1077: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FIELDS_NO_ID');
1078: FND_MSG_PUB.add;
1079: END IF;
1080:
1081: x_return_status := FND_API.g_ret_sts_error;
1082: RETURN;
1083: END IF;
1084:
1085: -- check list_word_replaces_id, field_table_name, field_column_name

Line 1105: IF l_uk_flag = FND_API.g_false THEN

1101: || ''' AND field_column_name = ''' || p_wrd_fld_rec.field_column_name || ''''
1102: );
1103: END IF;
1104:
1105: IF l_uk_flag = FND_API.g_false THEN
1106: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1107: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_FLD_DUP_RP_TB_CO');
1108: FND_MSG_PUB.add;
1109: END IF;

Line 1111: x_return_status := FND_API.g_ret_sts_error;

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

Line 1149: RAISE FND_API.g_exc_error;

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

Line 1153: IF p_wrd_fld_rec.field_table_name = FND_API.g_miss_char THEN

1149: RAISE FND_API.g_exc_error;
1150: END IF;
1151: CLOSE c_list_word_field;
1152:
1153: IF p_wrd_fld_rec.field_table_name = FND_API.g_miss_char THEN
1154: x_complete_rec.field_table_name := l_wrd_fld_rec.field_table_name;
1155: END IF;
1156:
1157: IF p_wrd_fld_rec.field_column_name = FND_API.g_miss_char THEN

Line 1157: IF p_wrd_fld_rec.field_column_name = FND_API.g_miss_char THEN

1153: IF p_wrd_fld_rec.field_table_name = FND_API.g_miss_char THEN
1154: x_complete_rec.field_table_name := l_wrd_fld_rec.field_table_name;
1155: END IF;
1156:
1157: IF p_wrd_fld_rec.field_column_name = FND_API.g_miss_char THEN
1158: x_complete_rec.field_column_name := l_wrd_fld_rec.field_column_name;
1159: END IF;
1160:
1161: IF p_wrd_fld_rec.list_word_replaces_id = FND_API.g_miss_num THEN

Line 1161: IF p_wrd_fld_rec.list_word_replaces_id = FND_API.g_miss_num THEN

1157: IF p_wrd_fld_rec.field_column_name = FND_API.g_miss_char THEN
1158: x_complete_rec.field_column_name := l_wrd_fld_rec.field_column_name;
1159: END IF;
1160:
1161: IF p_wrd_fld_rec.list_word_replaces_id = FND_API.g_miss_num THEN
1162: x_complete_rec.list_word_replaces_id := l_wrd_fld_rec.list_word_replaces_id;
1163: END IF;
1164:
1165: IF p_wrd_fld_rec.original_word = FND_API.g_miss_char THEN

Line 1165: IF p_wrd_fld_rec.original_word = FND_API.g_miss_char THEN

1161: IF p_wrd_fld_rec.list_word_replaces_id = FND_API.g_miss_num THEN
1162: x_complete_rec.list_word_replaces_id := l_wrd_fld_rec.list_word_replaces_id;
1163: END IF;
1164:
1165: IF p_wrd_fld_rec.original_word = FND_API.g_miss_char THEN
1166: x_complete_rec.original_word := l_wrd_fld_rec.original_word;
1167: END IF;
1168:
1169: IF p_wrd_fld_rec.replacement_word = FND_API.g_miss_char THEN

Line 1169: IF p_wrd_fld_rec.replacement_word = FND_API.g_miss_char THEN

1165: IF p_wrd_fld_rec.original_word = FND_API.g_miss_char THEN
1166: x_complete_rec.original_word := l_wrd_fld_rec.original_word;
1167: END IF;
1168:
1169: IF p_wrd_fld_rec.replacement_word = FND_API.g_miss_char THEN
1170: x_complete_rec.replacement_word := l_wrd_fld_rec.replacement_word;
1171: END IF;
1172:
1173: IF p_wrd_fld_rec.enabled_flag = FND_API.g_miss_char THEN

Line 1173: IF p_wrd_fld_rec.enabled_flag = FND_API.g_miss_char THEN

1169: IF p_wrd_fld_rec.replacement_word = FND_API.g_miss_char THEN
1170: x_complete_rec.replacement_word := l_wrd_fld_rec.replacement_word;
1171: END IF;
1172:
1173: IF p_wrd_fld_rec.enabled_flag = FND_API.g_miss_char THEN
1174: x_complete_rec.enabled_flag := l_wrd_fld_rec.enabled_flag;
1175: END IF;
1176:
1177: IF p_wrd_fld_rec.description = FND_API.g_miss_char THEN

Line 1177: IF p_wrd_fld_rec.description = FND_API.g_miss_char THEN

1173: IF p_wrd_fld_rec.enabled_flag = FND_API.g_miss_char THEN
1174: x_complete_rec.enabled_flag := l_wrd_fld_rec.enabled_flag;
1175: END IF;
1176:
1177: IF p_wrd_fld_rec.description = FND_API.g_miss_char THEN
1178: x_complete_rec.description := l_wrd_fld_rec.description;
1179: END IF;
1180:
1181: END complete_rec;

Line 1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;

1195: IS
1196:
1197: BEGIN
1198:
1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;
1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;

Line 1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;

1196:
1197: BEGIN
1198:
1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;
1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;

Line 1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;

1197: BEGIN
1198:
1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;
1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;

Line 1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;

1198:
1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;
1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;

Line 1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;

1199: x_wrd_fld_rec.list_word_field_id := FND_API.g_miss_num;
1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;

Line 1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;

1200: x_wrd_fld_rec.last_update_date := FND_API.g_miss_date;
1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;

Line 1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;

1201: x_wrd_fld_rec.last_updated_by := FND_API.g_miss_num;
1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;

Line 1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;

1202: x_wrd_fld_rec.creation_date := FND_API.g_miss_date;
1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;

Line 1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;

1203: x_wrd_fld_rec.created_by := FND_API.g_miss_num;
1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;

Line 1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;

1204: x_wrd_fld_rec.last_update_login := FND_API.g_miss_num;
1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;
1212: x_wrd_fld_rec.description := FND_API.g_miss_char;

Line 1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;

1205: x_wrd_fld_rec.object_version_number := FND_API.g_miss_num;
1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;
1212: x_wrd_fld_rec.description := FND_API.g_miss_char;
1213:

Line 1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;

1206: x_wrd_fld_rec.list_word_replaces_id := FND_API.g_miss_num;
1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;
1212: x_wrd_fld_rec.description := FND_API.g_miss_char;
1213:
1214: END init_rec;

Line 1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;

1207: x_wrd_fld_rec.field_table_name := FND_API.g_miss_char;
1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;
1212: x_wrd_fld_rec.description := FND_API.g_miss_char;
1213:
1214: END init_rec;
1215:

Line 1212: x_wrd_fld_rec.description := FND_API.g_miss_char;

1208: x_wrd_fld_rec.field_column_name := FND_API.g_miss_char;
1209: x_wrd_fld_rec.original_word := FND_API.g_miss_char;
1210: x_wrd_fld_rec.replacement_word := FND_API.g_miss_char;
1211: x_wrd_fld_rec.enabled_flag := FND_API.g_miss_char;
1212: x_wrd_fld_rec.description := FND_API.g_miss_char;
1213:
1214: END init_rec;
1215:
1216: END AMS_List_Word_Fields_PVT;