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

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

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

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

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

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

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

Line 53: IF FND_API.to_boolean(p_init_msg_list) THEN

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

Line 69: IF NOT FND_API.compatible_api_call

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

Line 77: RAISE FND_API.g_exc_unexpected_error;

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

Line 80: x_return_status := FND_API.g_ret_sts_success;

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

Line 98: IF l_return_status = FND_API.g_ret_sts_error THEN

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

Line 99: RAISE FND_API.g_exc_error;

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

Line 100: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

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

Line 101: RAISE FND_API.g_exc_unexpected_error;

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

Line 156: IF FND_API.to_boolean(p_commit) THEN

152:
153: -- finish
154: x_wrd_rpl_id := l_wrd_rpl_rec.list_word_replaces_id;
155:
156: IF FND_API.to_boolean(p_commit) THEN
157: COMMIT;
158: END IF;
159:
160: FND_MSG_PUB.count_and_get

Line 162: p_encoded => FND_API.g_false,

158: END IF;
159:
160: FND_MSG_PUB.count_and_get
161: (
162: p_encoded => FND_API.g_false,
163: p_count => x_msg_count,
164: p_data => x_msg_data
165: );
166:

Line 177: WHEN FND_API.g_exc_error THEN

173: END IF;
174:
175: EXCEPTION
176:
177: WHEN FND_API.g_exc_error THEN
178: ROLLBACK TO create_list_word_replace;
179: x_return_status := FND_API.g_ret_sts_error;
180: FND_MSG_PUB.count_and_get
181: (

Line 179: x_return_status := FND_API.g_ret_sts_error;

175: EXCEPTION
176:
177: WHEN FND_API.g_exc_error THEN
178: ROLLBACK TO create_list_word_replace;
179: x_return_status := FND_API.g_ret_sts_error;
180: FND_MSG_PUB.count_and_get
181: (
182: p_encoded => FND_API.g_false,
183: p_count => x_msg_count,

Line 182: p_encoded => FND_API.g_false,

178: ROLLBACK TO create_list_word_replace;
179: x_return_status := FND_API.g_ret_sts_error;
180: FND_MSG_PUB.count_and_get
181: (
182: p_encoded => FND_API.g_false,
183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:

Line 187: WHEN FND_API.g_exc_unexpected_error THEN

183: p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186:
187: WHEN FND_API.g_exc_unexpected_error THEN
188: ROLLBACK TO create_list_word_replace;
189: x_return_status := FND_API.g_ret_sts_unexp_error;
190: FND_MSG_PUB.count_and_get
191: (

Line 189: x_return_status := FND_API.g_ret_sts_unexp_error;

185: );
186:
187: WHEN FND_API.g_exc_unexpected_error THEN
188: ROLLBACK TO create_list_word_replace;
189: x_return_status := FND_API.g_ret_sts_unexp_error;
190: FND_MSG_PUB.count_and_get
191: (
192: p_encoded => FND_API.g_false,
193: p_count => x_msg_count,

Line 192: p_encoded => FND_API.g_false,

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

Line 199: x_return_status :=FND_API.g_ret_sts_unexp_error;

195: );
196:
197: WHEN OTHERS THEN
198: ROLLBACK TO create_list_word_replace;
199: x_return_status :=FND_API.g_ret_sts_unexp_error;
200: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
202: END IF;
203: FND_MSG_PUB.count_and_get

Line 205: p_encoded => FND_API.g_false,

201: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
202: END IF;
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 222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

218: -------------------------------------------------------------------------------
219: PROCEDURE update_list_word_replace
220: (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,

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

219: PROCEDURE update_list_word_replace
220: (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,

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

220: (
221: p_api_version IN NUMBER,
222: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
223: p_commit IN VARCHAR2 := FND_API.g_false,
224: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
225:
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

Line 245: IF FND_API.to_boolean(p_init_msg_list) THEN

241:
242: -- initialize
243: SAVEPOINT update_list_word_replace;
244:
245: IF FND_API.to_boolean(p_init_msg_list) THEN
246: FND_MSG_PUB.initialize;
247: END IF;
248:
249: IF (AMS_DEBUG_HIGH_ON) THEN

Line 257: IF NOT FND_API.compatible_api_call

253: AMS_Utility_PVT.debug_message(l_full_name || ': start');
254:
255: END IF;
256:
257: IF NOT FND_API.compatible_api_call
258: (
259: l_api_version,
260: p_api_version,
261: l_api_name,

Line 265: RAISE FND_API.g_exc_unexpected_error;

261: l_api_name,
262: g_pkg_name
263: )
264: THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_success;
269:

Line 268: x_return_status := FND_API.g_ret_sts_success;

264: THEN
265: RAISE FND_API.g_exc_unexpected_error;
266: END IF;
267:
268: x_return_status := FND_API.g_ret_sts_success;
269:
270: -- validate
271: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
272: IF (AMS_DEBUG_HIGH_ON) THEN

Line 284: IF l_return_status = FND_API.g_ret_sts_error THEN

280: x_return_status => l_return_status,
281: p_wrd_rpl_rec => l_wrd_rpl_rec
282: );
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;

Line 285: RAISE FND_API.g_exc_error;

281: p_wrd_rpl_rec => l_wrd_rpl_rec
282: );
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;

Line 286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

282: );
283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;
290:

Line 287: RAISE FND_API.g_exc_unexpected_error;

283:
284: IF l_return_status = FND_API.g_ret_sts_error THEN
285: RAISE FND_API.g_exc_error;
286: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
287: RAISE FND_API.g_exc_unexpected_error;
288: END IF;
289: END IF;
290:
291: -- complete record

Line 323: RAISE FND_API.g_exc_error;

319: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
320: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
321: FND_MSG_PUB.add;
322: END IF;
323: RAISE FND_API.g_exc_error;
324: END IF;
325:
326: -- finish
327: IF FND_API.to_boolean(p_commit) THEN

Line 327: IF FND_API.to_boolean(p_commit) THEN

323: RAISE FND_API.g_exc_error;
324: END IF;
325:
326: -- finish
327: IF FND_API.to_boolean(p_commit) THEN
328: COMMIT;
329: END IF;
330:
331: FND_MSG_PUB.count_and_get

Line 333: P_ENCODED => FND_API.g_false,

329: END IF;
330:
331: FND_MSG_PUB.count_and_get
332: (
333: P_ENCODED => FND_API.g_false,
334: p_count => x_msg_count,
335: p_data => x_msg_data
336: );
337:

Line 348: WHEN FND_API.g_exc_error THEN

344: END IF;
345:
346: EXCEPTION
347:
348: WHEN FND_API.g_exc_error THEN
349: ROLLBACK TO update_list_word_replace;
350: x_return_status := FND_API.g_ret_sts_error;
351: FND_MSG_PUB.count_and_get
352: (

Line 350: x_return_status := FND_API.g_ret_sts_error;

346: EXCEPTION
347:
348: WHEN FND_API.g_exc_error THEN
349: ROLLBACK TO update_list_word_replace;
350: x_return_status := FND_API.g_ret_sts_error;
351: FND_MSG_PUB.count_and_get
352: (
353: p_encoded => FND_API.g_false,
354: p_count => x_msg_count,

Line 353: p_encoded => FND_API.g_false,

349: ROLLBACK TO update_list_word_replace;
350: x_return_status := FND_API.g_ret_sts_error;
351: FND_MSG_PUB.count_and_get
352: (
353: p_encoded => FND_API.g_false,
354: p_count => x_msg_count,
355: p_data => x_msg_data
356: );
357:

Line 358: WHEN FND_API.g_exc_unexpected_error THEN

354: p_count => x_msg_count,
355: p_data => x_msg_data
356: );
357:
358: WHEN FND_API.g_exc_unexpected_error THEN
359: ROLLBACK TO update_list_word_replace;
360: x_return_status := FND_API.g_ret_sts_unexp_error;
361: FND_MSG_PUB.count_and_get
362: (

Line 360: x_return_status := FND_API.g_ret_sts_unexp_error;

356: );
357:
358: WHEN FND_API.g_exc_unexpected_error THEN
359: ROLLBACK TO update_list_word_replace;
360: x_return_status := FND_API.g_ret_sts_unexp_error;
361: FND_MSG_PUB.count_and_get
362: (
363: p_encoded => FND_API.g_false,
364: p_count => x_msg_count,

Line 363: p_encoded => FND_API.g_false,

359: ROLLBACK TO update_list_word_replace;
360: x_return_status := FND_API.g_ret_sts_unexp_error;
361: FND_MSG_PUB.count_and_get
362: (
363: p_encoded => FND_API.g_false,
364: p_count => x_msg_count,
365: p_data => x_msg_data
366: );
367:

Line 370: x_return_status :=FND_API.g_ret_sts_unexp_error;

366: );
367:
368: WHEN OTHERS THEN
369: ROLLBACK TO update_list_word_replace;
370: x_return_status :=FND_API.g_ret_sts_unexp_error;
371: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
373: END IF;
374: FND_MSG_PUB.count_and_get

Line 376: p_encoded => FND_API.g_false,

372: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
373: END IF;
374: FND_MSG_PUB.count_and_get
375: (
376: p_encoded => FND_API.g_false,
377: p_count => x_msg_count,
378: p_data => x_msg_data
379: );
380:

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

390: -------------------------------------------------------------------------------
391: PROCEDURE delete_list_word_replace
392: (
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
395: p_commit IN VARCHAR2 := FND_API.g_false,
396:
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,

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

391: PROCEDURE delete_list_word_replace
392: (
393: p_api_version IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
395: p_commit IN VARCHAR2 := FND_API.g_false,
396:
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,
399: 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: IF (AMS_DEBUG_HIGH_ON) THEN
464:
465: AMS_Utility_PVT.debug_message(l_full_name || ': list word fields delete');

Line 472: p_init_msg_list => FND_API.g_true,

468: FOR l_word_fields_rec IN c_list_word_fields
469: LOOP
470: AMS_LIST_word_FIELDS_PVT.delete_list_word_field(
471: p_api_version => l_api_version,
472: p_init_msg_list => FND_API.g_true,
473: x_return_status => l_return_status,
474: x_msg_count => l_msg_count,
475: x_msg_data => l_msg_data,
476: p_wrd_fld_id => l_word_fields_rec.list_word_field_id,

Line 481: IF l_return_status = FND_API.g_ret_sts_error THEN

477: p_object_version => l_word_fields_rec.object_version_number
478: );
479: END LOOP;
480:
481: IF l_return_status = FND_API.g_ret_sts_error THEN
482: RAISE FND_API.g_exc_error;
483: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
484: RAISE FND_API.g_exc_unexpected_error;
485: END IF ;

Line 482: RAISE FND_API.g_exc_error;

478: );
479: END LOOP;
480:
481: IF l_return_status = FND_API.g_ret_sts_error THEN
482: RAISE FND_API.g_exc_error;
483: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
484: RAISE FND_API.g_exc_unexpected_error;
485: END IF ;
486:

Line 483: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN

479: END LOOP;
480:
481: IF l_return_status = FND_API.g_ret_sts_error THEN
482: RAISE FND_API.g_exc_error;
483: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
484: RAISE FND_API.g_exc_unexpected_error;
485: END IF ;
486:
487:

Line 484: RAISE FND_API.g_exc_unexpected_error;

480:
481: IF l_return_status = FND_API.g_ret_sts_error THEN
482: RAISE FND_API.g_exc_error;
483: ELSIF l_return_status = FND_API.g_ret_sts_unexp_error THEN
484: RAISE FND_API.g_exc_unexpected_error;
485: END IF ;
486:
487:
488:

Line 490: IF FND_API.to_boolean(p_commit) THEN

486:
487:
488:
489: -- finish
490: IF FND_API.to_boolean(p_commit) THEN
491: COMMIT;
492: END IF;
493:
494: FND_MSG_PUB.count_and_get

Line 496: P_ENCODED => FND_API.g_false,

492: END IF;
493:
494: FND_MSG_PUB.count_and_get
495: (
496: P_ENCODED => FND_API.g_false,
497: p_count => x_msg_count,
498: p_data => x_msg_data
499: );
500:

Line 511: WHEN FND_API.g_exc_error THEN

507: END IF;
508:
509: EXCEPTION
510:
511: WHEN FND_API.g_exc_error THEN
512: ROLLBACK TO delete_list_word_replace;
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get
515: (

Line 513: x_return_status := FND_API.g_ret_sts_error;

509: EXCEPTION
510:
511: WHEN FND_API.g_exc_error THEN
512: ROLLBACK TO delete_list_word_replace;
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get
515: (
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,

Line 516: p_encoded => FND_API.g_false,

512: ROLLBACK TO delete_list_word_replace;
513: x_return_status := FND_API.g_ret_sts_error;
514: FND_MSG_PUB.count_and_get
515: (
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520:

Line 521: WHEN FND_API.g_exc_unexpected_error THEN

517: p_count => x_msg_count,
518: p_data => x_msg_data
519: );
520:
521: WHEN FND_API.g_exc_unexpected_error THEN
522: ROLLBACK TO delete_list_word_replace;
523: x_return_status := FND_API.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get
525: (

Line 523: x_return_status := FND_API.g_ret_sts_unexp_error;

519: );
520:
521: WHEN FND_API.g_exc_unexpected_error THEN
522: ROLLBACK TO delete_list_word_replace;
523: x_return_status := FND_API.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get
525: (
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,

Line 526: p_encoded => FND_API.g_false,

522: ROLLBACK TO delete_list_word_replace;
523: x_return_status := FND_API.g_ret_sts_unexp_error;
524: FND_MSG_PUB.count_and_get
525: (
526: p_encoded => FND_API.g_false,
527: p_count => x_msg_count,
528: p_data => x_msg_data
529: );
530:

Line 533: x_return_status :=FND_API.g_ret_sts_unexp_error;

529: );
530:
531: WHEN OTHERS THEN
532: ROLLBACK TO delete_list_word_replace;
533: x_return_status :=FND_API.g_ret_sts_unexp_error;
534: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
536: END IF;
537: FND_MSG_PUB.count_and_get

Line 539: p_encoded => FND_API.g_false,

535: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
536: END IF;
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 556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

552: -------------------------------------------------------------------------------
553: PROCEDURE lock_list_word_replace
554: (
555: p_api_version IN NUMBER,
556: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
557:
558: x_return_status OUT NOCOPY VARCHAR2,
559: x_msg_count OUT NOCOPY NUMBER,
560: x_msg_data OUT NOCOPY VARCHAR2,

Line 586: IF FND_API.to_boolean(p_init_msg_list) THEN

582:
583: AMS_Utility_PVT.debug_message(l_full_name || ': start');
584: END IF;
585:
586: IF FND_API.to_boolean(p_init_msg_list) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: IF NOT FND_API.compatible_api_call

Line 590: IF NOT FND_API.compatible_api_call

586: IF FND_API.to_boolean(p_init_msg_list) THEN
587: FND_MSG_PUB.initialize;
588: END IF;
589:
590: IF NOT FND_API.compatible_api_call
591: (
592: l_api_version,
593: p_api_version,
594: l_api_name,

Line 598: RAISE FND_API.g_exc_unexpected_error;

594: l_api_name,
595: g_pkg_name
596: )
597: THEN
598: RAISE FND_API.g_exc_unexpected_error;
599: END IF;
600:
601: x_return_status := FND_API.g_ret_sts_success;
602:

Line 601: x_return_status := FND_API.g_ret_sts_success;

597: THEN
598: RAISE FND_API.g_exc_unexpected_error;
599: END IF;
600:
601: x_return_status := FND_API.g_ret_sts_success;
602:
603: -- lock
604: IF (AMS_DEBUG_HIGH_ON) THEN
605:

Line 617: RAISE FND_API.g_exc_error;

613: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
614: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
615: FND_MSG_PUB.add;
616: END IF;
617: RAISE FND_API.g_exc_error;
618: END IF;
619: CLOSE c_list_word_replace;
620:
621: -- finish

Line 624: p_encoded => FND_API.g_false,

620:
621: -- finish
622: FND_MSG_PUB.count_and_get
623: (
624: p_encoded => FND_API.g_false,
625: p_count => x_msg_count,
626: p_data => x_msg_data
627: );
628:

Line 640: x_return_status := FND_API.g_ret_sts_error;

636:
637: EXCEPTION
638:
639: WHEN AMS_Utility_PVT.resource_locked THEN
640: x_return_status := FND_API.g_ret_sts_error;
641: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
642: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
643: FND_MSG_PUB.add;
644: END IF;

Line 647: p_encoded => FND_API.g_false,

643: FND_MSG_PUB.add;
644: END IF;
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 652: WHEN FND_API.g_exc_error THEN

648: p_count => x_msg_count,
649: p_data => x_msg_data
650: );
651:
652: WHEN FND_API.g_exc_error THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: FND_MSG_PUB.count_and_get
655: (
656: p_encoded => FND_API.g_false,

Line 653: x_return_status := FND_API.g_ret_sts_error;

649: p_data => x_msg_data
650: );
651:
652: WHEN FND_API.g_exc_error THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: FND_MSG_PUB.count_and_get
655: (
656: p_encoded => FND_API.g_false,
657: p_count => x_msg_count,

Line 656: p_encoded => FND_API.g_false,

652: WHEN FND_API.g_exc_error THEN
653: x_return_status := FND_API.g_ret_sts_error;
654: FND_MSG_PUB.count_and_get
655: (
656: p_encoded => FND_API.g_false,
657: p_count => x_msg_count,
658: p_data => x_msg_data
659: );
660:

Line 661: WHEN FND_API.g_exc_unexpected_error THEN

657: p_count => x_msg_count,
658: p_data => x_msg_data
659: );
660:
661: WHEN FND_API.g_exc_unexpected_error THEN
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,

Line 662: x_return_status := FND_API.g_ret_sts_unexp_error;

658: p_data => x_msg_data
659: );
660:
661: WHEN FND_API.g_exc_unexpected_error THEN
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,

Line 665: p_encoded => FND_API.g_false,

661: WHEN FND_API.g_exc_unexpected_error THEN
662: x_return_status := FND_API.g_ret_sts_unexp_error;
663: FND_MSG_PUB.count_and_get
664: (
665: p_encoded => FND_API.g_false,
666: p_count => x_msg_count,
667: p_data => x_msg_data
668: );
669:

Line 671: x_return_status :=FND_API.g_ret_sts_unexp_error;

667: p_data => x_msg_data
668: );
669:
670: WHEN OTHERS THEN
671: x_return_status :=FND_API.g_ret_sts_unexp_error;
672: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
674: END IF;
675: FND_MSG_PUB.count_and_get

Line 677: p_encoded => FND_API.g_false,

673: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
674: END IF;
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 695: p_init_msg_list IN VARCHAR2 := FND_API.g_false,

691: --------------------------------------------------------------------
692: PROCEDURE validate_list_word_replace
693: (
694: p_api_version IN NUMBER,
695: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
696: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
697:
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,

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

692: PROCEDURE validate_list_word_replace
693: (
694: p_api_version IN NUMBER,
695: p_init_msg_list IN VARCHAR2 := FND_API.g_false,
696: p_validation_level IN NUMBER := FND_API.g_valid_level_full,
697:
698: x_return_status OUT NOCOPY VARCHAR2,
699: x_msg_count OUT NOCOPY NUMBER,
700: x_msg_data OUT NOCOPY VARCHAR2,

Line 720: IF NOT FND_API.compatible_api_call

716:
717: AMS_Utility_PVT.debug_message(l_full_name||': start');
718: END IF;
719:
720: IF NOT FND_API.compatible_api_call
721: (
722: l_api_version,
723: p_api_version,
724: l_api_name,

Line 728: RAISE FND_API.g_exc_unexpected_error;

724: l_api_name,
725: g_pkg_name
726: )
727: THEN
728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: x_return_status := FND_API.g_ret_sts_success;
732:

Line 731: x_return_status := FND_API.g_ret_sts_success;

727: THEN
728: RAISE FND_API.g_exc_unexpected_error;
729: END IF;
730:
731: x_return_status := FND_API.g_ret_sts_success;
732:
733: ---------------------- validate ------------------------
734: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
735: IF (AMS_DEBUG_HIGH_ON) THEN

Line 746: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN

742: x_return_status => l_return_status,
743: p_wrd_rpl_rec => p_wrd_rpl_rec
744: );
745:
746: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
747: RAISE FND_API.g_exc_unexpected_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
749: RAISE FND_API.g_exc_error;
750: END IF;

Line 747: RAISE FND_API.g_exc_unexpected_error;

743: p_wrd_rpl_rec => p_wrd_rpl_rec
744: );
745:
746: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
747: RAISE FND_API.g_exc_unexpected_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
749: RAISE FND_API.g_exc_error;
750: END IF;
751: END IF;

Line 748: ELSIF l_return_status = FND_API.g_ret_sts_error THEN

744: );
745:
746: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
747: RAISE FND_API.g_exc_unexpected_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
749: RAISE FND_API.g_exc_error;
750: END IF;
751: END IF;
752:

Line 749: RAISE FND_API.g_exc_error;

745:
746: IF l_return_status = FND_API.g_ret_sts_unexp_error THEN
747: RAISE FND_API.g_exc_unexpected_error;
748: ELSIF l_return_status = FND_API.g_ret_sts_error THEN
749: RAISE FND_API.g_exc_error;
750: END IF;
751: END IF;
752:
753: -- record level

Line 758: p_encoded => FND_API.g_false,

754:
755: -------------------- finish --------------------------
756: FND_MSG_PUB.count_and_get
757: (
758: p_encoded => FND_API.g_false,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:

Line 772: WHEN FND_API.g_exc_error THEN

768:
769: END IF;
770:
771: EXCEPTION
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,

Line 773: x_return_status := FND_API.g_ret_sts_error;

769: END IF;
770:
771: EXCEPTION
772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,

Line 776: p_encoded => FND_API.g_false,

772: WHEN FND_API.g_exc_error THEN
773: x_return_status := FND_API.g_ret_sts_error;
774: FND_MSG_PUB.count_and_get
775: (
776: p_encoded => FND_API.g_false,
777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:

Line 781: WHEN FND_API.g_exc_unexpected_error THEN

777: p_count => x_msg_count,
778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error ;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,

Line 782: x_return_status := FND_API.g_ret_sts_unexp_error ;

778: p_data => x_msg_data
779: );
780:
781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error ;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,

Line 785: p_encoded => FND_API.g_false,

781: WHEN FND_API.g_exc_unexpected_error THEN
782: x_return_status := FND_API.g_ret_sts_unexp_error ;
783: FND_MSG_PUB.count_and_get
784: (
785: p_encoded => FND_API.g_false,
786: p_count => x_msg_count,
787: p_data => x_msg_data
788: );
789:

Line 791: x_return_status := FND_API.g_ret_sts_unexp_error;

787: p_data => x_msg_data
788: );
789:
790: WHEN OTHERS THEN
791: x_return_status := FND_API.g_ret_sts_unexp_error;
792: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error) THEN
793: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
794: END IF;
795:

Line 798: p_encoded => FND_API.g_false,

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

Line 830: x_return_status := FND_API.g_ret_sts_success;

826:
827: AMS_Utility_PVT.debug_message(l_full_name || ': start');
828: END IF;
829:
830: x_return_status := FND_API.g_ret_sts_success;
831:
832: -- check required items
833: IF (AMS_DEBUG_HIGH_ON) THEN
834:

Line 844: IF x_return_status <> FND_API.g_ret_sts_success THEN

840: p_wrd_rpl_rec => p_wrd_rpl_rec,
841: x_return_status => x_return_status
842: );
843:
844: IF x_return_status <> FND_API.g_ret_sts_success THEN
845: RETURN;
846: END IF;
847:
848: -- check unique key items

Line 860: IF x_return_status <> FND_API.g_ret_sts_success THEN

856: p_wrd_rpl_rec => p_wrd_rpl_rec,
857: x_return_status => x_return_status
858: );
859:
860: IF x_return_status <> FND_API.g_ret_sts_success THEN
861: RETURN;
862: END IF;
863:
864: END check_items;

Line 883: x_return_status := FND_API.g_ret_sts_success;

879: IS
880:
881: BEGIN
882:
883: x_return_status := FND_API.g_ret_sts_success;
884:
885: -- check list_word_replaces_id
886: IF p_wrd_rpl_rec.list_word_replaces_id IS NULL
887: AND p_validation_mode = JTF_PLSQL_API.g_update THEN

Line 893: x_return_status := FND_API.g_ret_sts_error;

889: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
890: FND_MSG_PUB.add;
891: END IF;
892:
893: x_return_status := FND_API.g_ret_sts_error;
894: RETURN;
895: END IF;
896:
897: -- check object_version_number

Line 906: x_return_status := FND_API.g_ret_sts_error;

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

Line 917: x_return_status := FND_API.g_ret_sts_error;

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

Line 928: x_return_status := FND_API.g_ret_sts_error;

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

Line 939: x_return_status := FND_API.g_ret_sts_error;

935: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
936: FND_MSG_PUB.add;
937: END IF;
938:
939: x_return_status := FND_API.g_ret_sts_error;
940: RETURN;
941: END IF;
942:
943: IF p_wrd_rpl_rec.enabled_flag <> 'Y'

Line 951: x_return_status := FND_API.g_ret_sts_error;

947: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WRD_FLD_NO_ENBL_FLAG');
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: END check_req_items;

Line 976: x_return_status := FND_API.g_ret_sts_success;

972: l_uk_flag VARCHAR2(1);
973:
974: BEGIN
975:
976: x_return_status := FND_API.g_ret_sts_success;
977:
978: -- check PK, if list_word_replaces_id is passed in, must check if it is duplicate
979: IF p_validation_mode = JTF_PLSQL_API.g_create
980: AND p_wrd_rpl_rec.list_word_replaces_id IS NOT NULL

Line 989: IF l_uk_flag = FND_API.g_false THEN

985: 'list_word_replaces_id = ' || p_wrd_rpl_rec.list_word_replaces_id
986: );
987: END IF;
988:
989: IF l_uk_flag = FND_API.g_false THEN
990: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
991: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
992: FND_MSG_PUB.add;
993: END IF;

Line 995: x_return_status := FND_API.g_ret_sts_error;

991: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_REPLACES_NO_ID');
992: FND_MSG_PUB.add;
993: END IF;
994:
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;
997: END IF;
998:
999: -- check original_word, replacement_word

Line 1017: IF l_uk_flag = FND_API.g_false THEN

1013: ||''' AND replacement_word = ''' || p_wrd_rpl_rec.replacement_word || ''''
1014: );
1015: END IF;
1016:
1017: IF l_uk_flag = FND_API.g_false THEN
1018: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1019: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_RPL_DUP_ORG_RPL');
1020: FND_MSG_PUB.add;
1021: END IF;

Line 1023: x_return_status := FND_API.g_ret_sts_error;

1019: FND_MESSAGE.set_name('AMS', 'AMS_LIST_WORD_RPL_DUP_ORG_RPL');
1020: FND_MSG_PUB.add;
1021: END IF;
1022:
1023: x_return_status := FND_API.g_ret_sts_error;
1024: RETURN;
1025: END IF;
1026:
1027: END check_uk_items;

Line 1061: RAISE FND_API.g_exc_error;

1057: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1058: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1059: FND_MSG_PUB.add;
1060: END IF;
1061: RAISE FND_API.g_exc_error;
1062: END IF;
1063: CLOSE c_list_word_replace;
1064:
1065: IF p_wrd_rpl_rec.original_word = FND_API.g_miss_char THEN

Line 1065: IF p_wrd_rpl_rec.original_word = FND_API.g_miss_char THEN

1061: RAISE FND_API.g_exc_error;
1062: END IF;
1063: CLOSE c_list_word_replace;
1064:
1065: IF p_wrd_rpl_rec.original_word = FND_API.g_miss_char THEN
1066: x_complete_rec.original_word := l_wrd_rpl_rec.original_word;
1067: END IF;
1068:
1069: IF p_wrd_rpl_rec.replacement_word = FND_API.g_miss_char THEN

Line 1069: IF p_wrd_rpl_rec.replacement_word = FND_API.g_miss_char THEN

1065: IF p_wrd_rpl_rec.original_word = FND_API.g_miss_char THEN
1066: x_complete_rec.original_word := l_wrd_rpl_rec.original_word;
1067: END IF;
1068:
1069: IF p_wrd_rpl_rec.replacement_word = FND_API.g_miss_char THEN
1070: x_complete_rec.replacement_word := l_wrd_rpl_rec.replacement_word;
1071: END IF;
1072:
1073: IF p_wrd_rpl_rec.enabled_flag = FND_API.g_miss_char THEN

Line 1073: IF p_wrd_rpl_rec.enabled_flag = FND_API.g_miss_char THEN

1069: IF p_wrd_rpl_rec.replacement_word = FND_API.g_miss_char THEN
1070: x_complete_rec.replacement_word := l_wrd_rpl_rec.replacement_word;
1071: END IF;
1072:
1073: IF p_wrd_rpl_rec.enabled_flag = FND_API.g_miss_char THEN
1074: x_complete_rec.enabled_flag := l_wrd_rpl_rec.enabled_flag;
1075: END IF;
1076:
1077: IF p_wrd_rpl_rec.description = FND_API.g_miss_char THEN

Line 1077: IF p_wrd_rpl_rec.description = FND_API.g_miss_char THEN

1073: IF p_wrd_rpl_rec.enabled_flag = FND_API.g_miss_char THEN
1074: x_complete_rec.enabled_flag := l_wrd_rpl_rec.enabled_flag;
1075: END IF;
1076:
1077: IF p_wrd_rpl_rec.description = FND_API.g_miss_char THEN
1078: x_complete_rec.description := l_wrd_rpl_rec.description;
1079: END IF;
1080:
1081: END complete_rec;

Line 1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;

1095: IS
1096:
1097: BEGIN
1098:
1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;
1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;

Line 1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;

1096:
1097: BEGIN
1098:
1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;
1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;

Line 1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;

1097: BEGIN
1098:
1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;
1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;

Line 1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;

1098:
1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;
1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;

Line 1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;

1099: x_wrd_rpl_rec.list_word_replaces_id := FND_API.g_miss_num;
1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;

Line 1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;

1100: x_wrd_rpl_rec.last_update_date := FND_API.g_miss_date;
1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;

Line 1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;

1101: x_wrd_rpl_rec.last_updated_by := FND_API.g_miss_num;
1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;
1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;

Line 1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;

1102: x_wrd_rpl_rec.creation_date := FND_API.g_miss_date;
1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;
1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;
1110:

Line 1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;

1103: x_wrd_rpl_rec.created_by := FND_API.g_miss_num;
1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;
1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;
1110:
1111: END init_rec;

Line 1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;

1104: x_wrd_rpl_rec.last_update_login := FND_API.g_miss_num;
1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;
1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;
1110:
1111: END init_rec;
1112: END AMS_List_Word_Replaces_PVT;

Line 1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;

1105: x_wrd_rpl_rec.object_version_number := FND_API.g_miss_num;
1106: x_wrd_rpl_rec.original_word := FND_API.g_miss_char;
1107: x_wrd_rpl_rec.replacement_word := FND_API.g_miss_char;
1108: x_wrd_rpl_rec.enabled_flag := FND_API.g_miss_char;
1109: x_wrd_rpl_rec.description := FND_API.g_miss_char;
1110:
1111: END init_rec;
1112: END AMS_List_Word_Replaces_PVT;